From 20091904b7bf4b2074b45e25c7eee0e56d19348b Mon Sep 17 00:00:00 2001
From: Jeffrey Armstrong <jeff@approximatrix.com>
Date: Mon, 21 Jun 2021 11:04:31 -0400
Subject: Groups of instructions are now supported, allowing launching multiple
 jobs at once

---
 captain/sql/create.sql | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'captain/sql/create.sql')

diff --git a/captain/sql/create.sql b/captain/sql/create.sql
index c09d120..6457296 100644
--- a/captain/sql/create.sql
+++ b/captain/sql/create.sql
@@ -9,3 +9,6 @@ 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(instruction, player));
 
+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);
-- 
cgit v1.2.3

