From 4d3c5e7d8ae5d0846d0b4241811ffe20e57a006b Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Fri, 18 Feb 2005 18:20:26 +0000 Subject: [PATCH] Started on a bigscreen SQL schema. --- sql/ccbs.sql | 6 ++++++ 1 file changed, 6 insertions(+) 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 +); -- 2.39.2