From c79a25cdbb359a6757cf7c2bca64fb52642073e2 Mon Sep 17 00:00:00 2001 From: Jeffrey Armstrong Date: Wed, 24 Nov 2021 18:12:57 -0500 Subject: Started addition of scheduling jobs --- captain/sql/create.sql | 3 +++ 1 file changed, 3 insertions(+) (limited to 'captain/sql') diff --git a/captain/sql/create.sql b/captain/sql/create.sql index e4a944c..8e93e23 100644 --- a/captain/sql/create.sql +++ b/captain/sql/create.sql @@ -14,3 +14,6 @@ CREATE TABLE groups(id INTEGER PRIMARY KEY, name TEXT UNIQUE NOT NULL); CREATE TABLE group_instructions(group_id INTEGER, instruction INTEGER, player INTEGER, FOREIGN KEY(group_id) REFERENCES groups(id) ON DELETE CASCADE, FOREIGN KEY(instruction) REFERENCES instructions(id) ON DELETE CASCADE, FOREIGN KEY(player) REFERENCES players(id) ON DELETE CASCADE); CREATE TABLE checkin(player INTEGER PRIMARY KEY, year INTEGER, month INTEGER, day INTEGER, hour INTEGER, minute INTEGER, second INTEGER, os TEXT DEFAULT NULL, FOREIGN KEY(player) REFERENCES players(id) ON DELETE CASCADE); + +CREATE TABLE schedule(instruction INTEGER NOT NULL, player INTEGER NOT NULL, day INTEGER DEFAULT 0, hour INTEGER DEFAULT 0, FOREIGN KEY(instruction) REFERENCES instructions(id) ON DELETE CASCADE, FOREIGN KEY(player) REFERENCES players(id) ON DELETE CASCADE ); + -- cgit v1.2.3