git.mcksp
    1
    2
    3
    4
    5
    6
    7
    8
    9
   10
   11
   12
create table if not exists users (
  id text not null primary key,
  username text not null unique,
  hash_pass text not null,
  created_at datetime not null
);

create table if not exists sessions (
  token text not null primary key,
  user_id text not null,
  foreign key(user_id) references user(id)
)