diff options
| author | Jeffrey Armstrong <jeff@approximatrix.com> | 2021-04-01 11:38:06 -0400 |
|---|---|---|
| committer | Jeffrey Armstrong <jeff@approximatrix.com> | 2021-04-01 11:38:06 -0400 |
| commit | af084b8acb5ed7e883e422c4626a596eb32fba25 (patch) | |
| tree | 323cb1c5c0de5ad919d0c932718efaff14a5566b /captain/sql | |
| parent | 9d19023f554dee7d8656a18dd81479decc03b3ee (diff) | |
| download | levitating-af084b8acb5ed7e883e422c4626a596eb32fba25.tar.gz levitating-af084b8acb5ed7e883e422c4626a596eb32fba25.zip | |
Added support for viewing individual instruction pages, assigning players, and launching instruction jobs
Diffstat (limited to 'captain/sql')
| -rw-r--r-- | captain/sql/create.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/captain/sql/create.sql b/captain/sql/create.sql index 745c536..edb21c7 100644 --- a/captain/sql/create.sql +++ b/captain/sql/create.sql @@ -7,4 +7,5 @@ CREATE TABLE tasks(job INTEGER, task INTEGER, status INTEGER, FOREIGN KEY(job) R CREATE TABLE instructions(id INTEGER PRIMARY KEY, name TEXT UNIQUE NOT NULL); -CREATE TABLE available(instruction INTEGER, player INTEGER, FOREIGN KEY(instruction) REFERENCES instructions(id), FOREIGN KEY(player) REFERENCES players(id)); +CREATE TABLE available(instruction INTEGER, player INTEGER, FOREIGN KEY(instruction) REFERENCES instructions(id), FOREIGN KEY(player) REFERENCES players(id), UNIQUE(instructions, player)); + |