Started on a bigscreen SQL schema.

[ccbs] / sql / ccbs.sql

diff --git a/sql/ccbs.sql b/sql/ccbs.sql
index bc4b0e45287b35cf3af4a1a11dd6e503898d29ae..5125fdbbfd87cacb06f4596e893ad7795317c230 100644 (file)
--- a/sql/ccbs.sql
+++ b/sql/ccbs.sql
@@ -157,3 +157,9 @@ CREATE TABLE scores (
 CREATE TABLE randomsongsused (
        song INTEGER NOT NULL PRIMARY KEY REFERENCES songs
 );
+
+CREATE SCHEMA bigscreen;
+
+CREATE TABLE bigscreen.active_tournament (
+       tournament INTEGER NOT NULL REFERENCES tournaments
+);