From dc17dc6d5faf0ec2c15400194da515ec2e4d7d62 Mon Sep 17 00:00:00 2001
From: "cyeh%bluemartini.com" <>
Date: Thu, 27 Apr 2000 02:12:17 +0000
Subject: slightly more paranoid database schema:. made column 'program' in
 table 'versions' be not null, and unique. optimally you would want a unique
 index on 'value' and 'program' but indexes are not supported on datatype
 'tinytext' until mysql 3.23

---
 checksetup.pl | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'checksetup.pl')

diff --git a/checksetup.pl b/checksetup.pl
index f0a7a3d77..fc8f471f4 100755
--- a/checksetup.pl
+++ b/checksetup.pl
@@ -735,8 +735,9 @@ $table{fielddefs} =
 
 $table{versions} =
    'value tinytext,
-    program varchar(64)';
+    program varchar(64) not null,
 
+    unique(program)';
 
 $table{votes} =
    'who mediumint not null,
-- 
cgit v1.2.3-24-g4f1b