summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authormkanat%bugzilla.org <>2007-12-23 12:12:04 +0100
committermkanat%bugzilla.org <>2007-12-23 12:12:04 +0100
commit57411366af5e116d6ffbb024a7c093e35851af21 (patch)
tree4fdb222971b39c3664c3e7508d27d7b0af3273bf
parent4ee554d7d2a5a6a6f1e89f253afd9112f360d11e (diff)
downloadbugzilla-57411366af5e116d6ffbb024a7c093e35851af21.tar.gz
bugzilla-57411366af5e116d6ffbb024a7c093e35851af21.tar.xz
Bug 409593: namedqueries.query_type has the wrong definition in DB::Schema
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> (module owner) a=mkanat
-rw-r--r--Bugzilla/DB/Schema.pm2
-rw-r--r--Bugzilla/Install/DB.pm4
2 files changed, 5 insertions, 1 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 3d7f56674..2f7df56c1 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -783,7 +783,7 @@ use constant ABSTRACT_SCHEMA => {
DELETE => 'CASCADE'}},
name => {TYPE => 'varchar(64)', NOTNULL => 1},
query => {TYPE => 'LONGTEXT', NOTNULL => 1},
- query_type => {TYPE => 'BOOLEAN', NOTNULL => 1},
+ query_type => {TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 0},
],
INDEXES => [
namedqueries_userid_idx => {FIELDS => [qw(userid name)],
diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm
index 43c81d1dd..e9ce742d8 100644
--- a/Bugzilla/Install/DB.pm
+++ b/Bugzilla/Install/DB.pm
@@ -521,6 +521,10 @@ sub update_table_definitions {
# 2007-09-09 LpSolit@gmail.com - Bug 99215
_fix_attachment_modification_date();
+ # This had the wrong definition in DB::Schema.
+ $dbh->bz_alter_column('namedqueries', 'query_type',
+ {TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 0});
+
################################################################
# New --TABLE-- changes should go *** A B O V E *** this point #
################################################################