diff options
author | cyeh%bluemartini.com <> | 2000-04-27 04:12:17 +0200 |
---|---|---|
committer | cyeh%bluemartini.com <> | 2000-04-27 04:12:17 +0200 |
commit | dc17dc6d5faf0ec2c15400194da515ec2e4d7d62 (patch) | |
tree | c3e3d293cc76ee712d34c0d5f9d6c3cbbe34f367 | |
parent | 6ee776b0f05c6acc23270fc87c180401e64c6069 (diff) | |
download | bugzilla-dc17dc6d5faf0ec2c15400194da515ec2e4d7d62.tar.gz bugzilla-dc17dc6d5faf0ec2c15400194da515ec2e4d7d62.tar.xz |
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
-rwxr-xr-x | checksetup.pl | 3 |
1 files changed, 2 insertions, 1 deletions
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, |