aboutsummaryrefslogtreecommitdiff
path: root/captain/sql
diff options
context:
space:
mode:
Diffstat (limited to 'captain/sql')
-rw-r--r--captain/sql/create.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/captain/sql/create.sql b/captain/sql/create.sql
index d78c90c..9fd00d0 100644
--- a/captain/sql/create.sql
+++ b/captain/sql/create.sql
@@ -7,4 +7,6 @@ CREATE TABLE tasks(job INTEGER, task INTEGER, status INTEGER, FOREIGN KEY(job) R
CREATE TABLE instructions(id INTEGER PRIMARY KEY, name TEXT NOT NULL, file TEXT NOT NULL);
-CREATE_TABLE available(instructions INTEGER, player INTEGER, FOREIGN KEY(instructions) 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));