From c6a3bdfc5e02b9e35b1e0fc5af2d0bf0319681ac Mon Sep 17 00:00:00 2001 From: Jeffrey Armstrong Date: Tue, 30 Mar 2021 15:09:09 -0400 Subject: Added script to scan and load instructions. Instructions now displayed on a page. --- captain/sql/create.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'captain/sql/create.sql') 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), \ -- cgit v1.2.3