From 57411366af5e116d6ffbb024a7c093e35851af21 Mon Sep 17 00:00:00 2001 From: "mkanat%bugzilla.org" <> Date: Sun, 23 Dec 2007 11:12:04 +0000 Subject: Bug 409593: namedqueries.query_type has the wrong definition in DB::Schema Patch By Max Kanat-Alexander (module owner) a=mkanat --- Bugzilla/DB/Schema.pm | 2 +- Bugzilla/Install/DB.pm | 4 ++++ 2 files changed, 5 insertions(+), 1 deletion(-) 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 # ################################################################ -- cgit v1.2.3-24-g4f1b