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