blob: 9fd00d0c2d3669624fbcb49eac2fe9fa7e471bfd (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
CREATE TABLE players(id INTEGER PRIMARY KEY, name TEXT NOT NULL, token TEXT NOT NULL);
CREATE TABLE jobs(id INTEGER PRIMARY KEY, player INTEGER DEFAULT NULL, status INTEGER, FOREIGN KEY(player) REFERENCES players(id));
CREATE TABLE tasks(job INTEGER, task INTEGER, status INTEGER, FOREIGN KEY(job) REFERENCES jobs(id));
CREATE TABLE instructions(id INTEGER PRIMARY KEY, name TEXT NOT NULL, file TEXT NOT NULL);
CREATE_TABLE available(instruction INTEGER, player INTEGER, \
FOREIGN KEY(instruction) REFERENCES instructions(id), \
FOREIGN KEY(player) REFERENCES players(id));
|