migrations/init.sql (view raw)
1create table if not exists login (
2 user_id INTEGER PRIMARY KEY AUTOINCREMENT,
3 username text unique not null,
4 password text not null,
5 salt text not null,
6 email text
7);
8
9create table if not exists queue (
10 username text primary key,
11 password text not null,
12 salt text not null,
13 email text,
14 requested datetime DEFAULT CURRENT_TIMESTAMP
15)