From: Steinar H. Gunderson <sesse@samfundet.no>
Date: Mon, 28 Feb 2005 19:51:18 +0000 (+0000)
Subject: Added a new mini-table for auxilliary bigscreen screens.
X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=90657a2c45fa1043b7c30b95f21b0ee7426bf73a;hp=81ab2a21cc586b81bc6362c0d48c276515caaf50

Added a new mini-table for auxilliary bigscreen screens.
---

diff --git a/sql/ccbs.sql b/sql/ccbs.sql
index 6cd5154..3697f6e 100644
--- a/sql/ccbs.sql
+++ b/sql/ccbs.sql
@@ -182,3 +182,6 @@ CREATE TABLE bigscreen.active_groups (
 	PRIMARY KEY ( tournament, round, parallel ),
 	FOREIGN KEY ( tournament, round, parallel ) REFERENCES groups
 );
+CREATE TABLE bigscreen.active_screens (
+	id VARCHAR NOT NULL
+);