X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fccbs.sql;fp=sql%2Fccbs.sql;h=4a9f0a8efc258c40f70f314a172d09a9dc323a20;hp=97bcd3f1be8c9b2a0e0dbcba2ec285240f785b0a;hb=9c78e37258ab59892b8032be8ed2265d2ad2f587;hpb=865e85b2e5da68f6bf0b907d239f2277579382a6 diff --git a/sql/ccbs.sql b/sql/ccbs.sql index 97bcd3f..4a9f0a8 100644 --- a/sql/ccbs.sql +++ b/sql/ccbs.sql @@ -175,8 +175,8 @@ CREATE TABLE bigscreen.active_groups ( tournament INTEGER NOT NULL REFERENCES bigscreen.active_tournament, round INTEGER NOT NULL, parallel INTEGER NOT NULL, + last_updated TIMESTAMP NOT NULL, PRIMARY KEY ( tournament, round, parallel ), FOREIGN KEY ( tournament, round, parallel ) REFERENCES groups ); -);