X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fccbs.sql;fp=sql%2Fccbs.sql;h=3697f6e2544919bf1b0ad8b3af5b95b07b555787;hp=6cd515465607f02f5f6f6f032379ba7041aa622f;hb=90657a2c45fa1043b7c30b95f21b0ee7426bf73a;hpb=81ab2a21cc586b81bc6362c0d48c276515caaf50 diff --git a/sql/ccbs.sql b/sql/ccbs.sql index 6cd5154..3697f6e 100644 --- a/sql/ccbs.sql +++ b/sql/ccbs.sql @@ -182,3 +182,6 @@ CREATE TABLE bigscreen.active_groups ( PRIMARY KEY ( tournament, round, parallel ), FOREIGN KEY ( tournament, round, parallel ) REFERENCES groups ); +CREATE TABLE bigscreen.active_screens ( + id VARCHAR NOT NULL +);