diff options
Diffstat (limited to 'captain/sql/create.sql')
-rw-r--r-- | captain/sql/create.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/captain/sql/create.sql b/captain/sql/create.sql index 9fd00d0..e8198e4 100644 --- a/captain/sql/create.sql +++ b/captain/sql/create.sql @@ -5,7 +5,7 @@ CREATE TABLE jobs(id INTEGER PRIMARY KEY, player INTEGER DEFAULT NULL, status IN 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 instructions(id INTEGER PRIMARY KEY, name TEXT UNIQUE NOT NULL); CREATE_TABLE available(instruction INTEGER, player INTEGER, \ FOREIGN KEY(instruction) REFERENCES instructions(id), \ |