diff options
| author | Jeffrey Armstrong <jeff@approximatrix.com> | 2021-03-26 11:19:59 -0400 |
|---|---|---|
| committer | Jeffrey Armstrong <jeff@approximatrix.com> | 2021-03-26 11:19:59 -0400 |
| commit | 13f8f7e0e5b2361a5d3aa3f3a21519b03cd4c9c2 (patch) | |
| tree | 62914777fe9fef2ade01be0361d65900bf73aacf /captain/sql | |
| parent | 2a79043e4b33118437b3ade35a792b9e0d1323be (diff) | |
| download | levitating-13f8f7e0e5b2361a5d3aa3f3a21519b03cd4c9c2.tar.gz levitating-13f8f7e0e5b2361a5d3aa3f3a21519b03cd4c9c2.zip | |
Started work on a template engine complete with variables. Added a few database routines and some hopeful, untested changes to the sql creation script.
Diffstat (limited to 'captain/sql')
| -rw-r--r-- | captain/sql/create.sql | 4 |
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)); |