X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=sql%2Fccbs.sql;h=839dd86879d6c9a2ff352caf2ea65d3b12a32879;hb=6f4098ac40bff31e41d31af6395f848b20ca9dea;hp=9f0cdeaa283e933da933674715dd187f51fb7e6d;hpb=8963fce7337a09bdcfea051a81c0c3d9281acd6e;p=ccbs diff --git a/sql/ccbs.sql b/sql/ccbs.sql index 9f0cdea..839dd86 100644 --- a/sql/ccbs.sql +++ b/sql/ccbs.sql @@ -176,8 +176,13 @@ CREATE TABLE bigscreen.active_groups ( tournament INTEGER NOT NULL REFERENCES bigscreen.active_tournament, round INTEGER NOT NULL, parallel INTEGER NOT NULL, + num_machines INTEGER NOT NULL, + players_per_machine INTEGER NOT NULL CHECK ( players_per_machine IN (1, 2) ), last_updated TIMESTAMP NOT NULL, PRIMARY KEY ( tournament, round, parallel ), FOREIGN KEY ( tournament, round, parallel ) REFERENCES groups ); +CREATE TABLE bigscreen.active_screens ( + id VARCHAR NOT NULL PRIMARY KEY +);