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);
16
17create table if not exists platforms (
18    platform_id INTEGER PRIMARY KEY,
19    name text unique not null
20);
21
22create table if not exists games (
23    game_id INTEGER PRIMARY KEY,
24    title text not null
25);
26
27create table if not exists saves (
28    user_id integer not null,
29    game_id integer not null,
30    platform_id integer not null,
31    filename text not null,
32    primary key (user_id, game_id, platform_id)
33);