git.mcksp 
    1
    2
    3
    4
    5
    6
    7
    8
    9
   10
   11
   12
   13
   14
   15
   16
   17
   18
   19
   20

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)
);

create table if not exists ssh_keys(
  id text not null primary key,
  user_id text not null,
  key text not null,
  created_at datetime not null,
  foreign key(user_id) references user(id)
);