X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fccbs.sql;h=c1848f79d6af846aba13c6f9775ba2591f69d592;hp=6cd515465607f02f5f6f6f032379ba7041aa622f;hb=7efdf061d8e7e8a68d9641ee4261f219099a02a9;hpb=914b810749b54bb07e1944e558015d6c8f615528 diff --git a/sql/ccbs.sql b/sql/ccbs.sql index 6cd5154..c1848f7 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 PRIMARY KEY +);