aboutsummaryrefslogtreecommitdiff
path: root/captain/sql
diff options
context:
space:
mode:
authorJeffrey Armstrong <jeff@approximatrix.com>2021-04-15 12:03:51 -0400
committerJeffrey Armstrong <jeff@approximatrix.com>2021-04-15 12:03:51 -0400
commitefb5d8cec9531637c91fc1087f9c83b4d89a5612 (patch)
tree53368c28e9341bf06899cce1d0752c7dfcaabf35 /captain/sql
parentdf837aa90fc8357415924b3008cb163b02ffc571 (diff)
downloadlevitating-efb5d8cec9531637c91fc1087f9c83b4d89a5612.tar.gz
levitating-efb5d8cec9531637c91fc1087f9c83b4d89a5612.zip
Fixed typo in database creation
Diffstat (limited to 'captain/sql')
-rw-r--r--captain/sql/create.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/captain/sql/create.sql b/captain/sql/create.sql
index edb21c7..c09d120 100644
--- a/captain/sql/create.sql
+++ b/captain/sql/create.sql
@@ -7,5 +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), UNIQUE(instructions, player));
+CREATE TABLE available(instruction INTEGER, player INTEGER, FOREIGN KEY(instruction) REFERENCES instructions(id), FOREIGN KEY(player) REFERENCES players(id), UNIQUE(instruction, player));