diff options
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 2 | ||||
| -rw-r--r-- | Bugzilla/Install/DB.pm | 4 |
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 # ################################################################ |