From efb5d8cec9531637c91fc1087f9c83b4d89a5612 Mon Sep 17 00:00:00 2001 From: Jeffrey Armstrong Date: Thu, 15 Apr 2021 12:03:51 -0400 Subject: Fixed typo in database creation --- captain/sql/create.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/captain/sql/create.sql b/captain/sql/create.sql index edb21c7..c09d120 100644 --- a/captain/sql/create.sql +++ b/captain/sql/create.sql @@ -7,5 +7,5 @@ CREATE TABLE tasks(job INTEGER, task INTEGER, status INTEGER, FOREIGN KEY(job) R 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), FOREIGN KEY(player) REFERENCES players(id), UNIQUE(instructions, player)); +CREATE TABLE available(instruction INTEGER, player INTEGER, FOREIGN KEY(instruction) REFERENCES instructions(id), FOREIGN KEY(player) REFERENCES players(id), UNIQUE(instruction, player)); -- cgit v1.2.3