import db from "./database";

db.serialize(() => {
  db.run(`create table if not exists users (
    id integer primary key autoincrement,
    email text not null unique,
    username text not null unique,
    password text not null
  )`)
  db.run(`create table if not exists auth_tokens (
    id integer primary key autoincrement,
    token text not null unique,
    encryption_key text not null,
    encryption_iv text not null,
    user_id integer not null,
    foreign key(user_id) references users(id)
  )`)
  db.run(`create table if not exists password_resets (
    id integer primary key autoincrement,
    user_id integer not null,
    token text not null,
    expires integer not null,
    foreign key(user_id) references users(id)
)`)
  db.run(`create table if not exists password_allowances (
    id integer primary key autoincrement,
    user_id integer not null,
    token text not null,
    expires integer not null,
    foreign key(user_id) references users(id)
)`)
  db.run(`create table if not exists notes (
    id integer primary key autoincrement,
    title text not null,
    note text not null,
    created_at integer not null,
    updated_at integer not null,
    user_id integer not null,
    foreign key(user_id) references users(id)
  )`)
});