From: Steinar H. Gunderson <sesse@samfundet.no>
Date: Mon, 28 Feb 2005 20:23:12 +0000 (+0000)
Subject: Added a primary key for the "active screens" table.
X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=7efdf061d8e7e8a68d9641ee4261f219099a02a9

Added a primary key for the "active screens" table.
---

diff --git a/sql/ccbs.sql b/sql/ccbs.sql
index 3697f6e..c1848f7 100644
--- a/sql/ccbs.sql
+++ b/sql/ccbs.sql
@@ -183,5 +183,5 @@ CREATE TABLE bigscreen.active_groups (
 	FOREIGN KEY ( tournament, round, parallel ) REFERENCES groups
 );
 CREATE TABLE bigscreen.active_screens (
-	id VARCHAR NOT NULL
+	id VARCHAR NOT NULL PRIMARY KEY
 );