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