summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authormkanat%kerio.com <>2005-04-12 10:30:44 +0200
committermkanat%kerio.com <>2005-04-12 10:30:44 +0200
commit4b0a77d047699b97e3f34924dbeee5a1e8fe0b62 (patch)
treec7f3dc9c1039a87b1d18db888a838ed0aecaa50b
parent683e10636b80dcf6b9e30fb6c41a64cc5620983d (diff)
downloadbugzilla-4b0a77d047699b97e3f34924dbeee5a1e8fe0b62.tar.gz
bugzilla-4b0a77d047699b97e3f34924dbeee5a1e8fe0b62.tar.xz
Bug 289455: products.classification_id has a different definition in an upgraded database than in a brand-new database
Patch By Albert Ting <altlst@sonic.net> r=mkanat, a=justdave
-rwxr-xr-xchecksetup.pl7
1 files changed, 6 insertions, 1 deletions
diff --git a/checksetup.pl b/checksetup.pl
index 8e076426d..f556682f3 100755
--- a/checksetup.pl
+++ b/checksetup.pl
@@ -3716,7 +3716,7 @@ if ($dbh->bz_get_field_def('bugs', 'short_desc')->[2]) { # if it allows nulls
# 2003-10-24 - alt@sonic.net, bug 224208
# Support classification level
-$dbh->bz_add_field('products', 'classification_id', 'smallint DEFAULT 1');
+$dbh->bz_add_field('products', 'classification_id', 'smallint NOT NULL DEFAULT 1');
# 2004-08-29 - Tomas.Kopal@altap.cz, bug 257303
# Change logincookies.lastused type from timestamp to datetime
@@ -3939,6 +3939,11 @@ add_setting ("comment_sort_order", {"oldest_to_newest" => 1,
"oldest_to_newest" );
+# 2005-04-07 - alt@sonic.net, bug 289455
+# make classification_id field type be consistent with DB:Schema
+$dbh->bz_change_field_type('products', 'classification_id',
+ 'smallint NOT NULL DEFAULT 1');
+
} # END LEGACY CHECKS
# If you had to change the --TABLE-- definition in any way, then add your