From 012a54e59c8d6cd27754c1abfc8a3fba3e2d0fab Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Fri, 4 Mar 2005 22:23:25 +0000 Subject: [PATCH 1/1] Added a field in the bigscreen active groups allowing for versus play. --- sql/ccbs.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/sql/ccbs.sql b/sql/ccbs.sql index c1848f7..839dd86 100644 --- a/sql/ccbs.sql +++ b/sql/ccbs.sql @@ -177,6 +177,7 @@ CREATE TABLE bigscreen.active_groups ( 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 ), -- 2.39.2