diff options
author | Jeffrey Armstrong <jeff@approximatrix.com> | 2021-03-30 15:09:09 -0400 |
---|---|---|
committer | Jeffrey Armstrong <jeff@approximatrix.com> | 2021-03-30 15:09:09 -0400 |
commit | c6a3bdfc5e02b9e35b1e0fc5af2d0bf0319681ac (patch) | |
tree | e9714d50e2be010557992708ad92aa93522d3daa /captain/sql/create.sql | |
parent | 8da227ca130355332fc92935cfbabc87bd0db078 (diff) | |
download | levitating-c6a3bdfc5e02b9e35b1e0fc5af2d0bf0319681ac.tar.gz levitating-c6a3bdfc5e02b9e35b1e0fc5af2d0bf0319681ac.zip |
Added script to scan and load instructions. Instructions now displayed on a page.
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), \ |