From: Steinar H. Gunderson <sesse@samfundet.no>
Date: Fri, 18 Feb 2005 18:20:26 +0000 (+0000)
Subject: Started on a bigscreen SQL schema.
X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=4d3c5e7d8ae5d0846d0b4241811ffe20e57a006b

Started on a bigscreen SQL schema.
---

diff --git a/sql/ccbs.sql b/sql/ccbs.sql
index bc4b0e4..5125fdb 100644
--- 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
+);