From 0f22a1dac624ea27e58df298f6fd67020b1df294 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Sat, 19 Feb 2005 14:05:58 +0000 Subject: [PATCH] Add an "active_rounds" table to the bigscreen schema, and set a primary key for the active_tournaments table. --- sql/ccbs.sql | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) diff --git a/sql/ccbs.sql b/sql/ccbs.sql index 5125fdb..0140141 100644 --- a/sql/ccbs.sql +++ b/sql/ccbs.sql @@ -161,5 +161,13 @@ CREATE TABLE randomsongsused ( CREATE SCHEMA bigscreen; CREATE TABLE bigscreen.active_tournament ( - tournament INTEGER NOT NULL REFERENCES tournaments + tournament INTEGER NOT NULL PRIMARY KEY REFERENCES tournaments +); +CREATE TABLE bigscreen.active_rounds ( + tournament INTEGER NOT NULL REFERENCES bigscreen.active_tournament, + round INTEGER NOT NULL, + + PRIMARY KEY ( tournament, round ), + FOREIGN KEY ( tournament, round ) REFERENCES rounds +); ); -- 2.39.2