X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fccbs.sql;h=5125fdbbfd87cacb06f4596e893ad7795317c230;hp=bc4b0e45287b35cf3af4a1a11dd6e503898d29ae;hb=4d3c5e7d8ae5d0846d0b4241811ffe20e57a006b;hpb=6c49eba2219d2af1a5ffd918ab853443d9c48b42 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 +);