From 6c62f841490783a42ffc837387cdf371c7ab12cb Mon Sep 17 00:00:00 2001 From: "lpsolit%gmail.com" <> Date: Tue, 29 Jul 2008 13:24:22 +0000 Subject: Bug 431669: The "product_id" column is incorrectly defined in the "group_control_map" DB table - Patch by Tony Fu r=LpSolit a=mkanat --- Bugzilla/DB/Schema.pm | 2 +- Bugzilla/Install/DB.pm | 4 ++++ 2 files changed, 5 insertions(+), 1 deletion(-) (limited to 'Bugzilla') diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 06a956222..850e48a1b 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -990,7 +990,7 @@ use constant ABSTRACT_SCHEMA => { group_control_map => { FIELDS => [ group_id => {TYPE => 'INT3', NOTNULL => 1}, - product_id => {TYPE => 'INT3', NOTNULL => 1}, + product_id => {TYPE => 'INT2', NOTNULL => 1}, entry => {TYPE => 'BOOLEAN', NOTNULL => 1}, membercontrol => {TYPE => 'BOOLEAN', NOTNULL => 1}, othercontrol => {TYPE => 'BOOLEAN', NOTNULL => 1}, diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index 54dbfc564..63a6dd2b0 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -528,6 +528,10 @@ sub update_table_definitions { # Add FK to multi select field tables _add_foreign_keys_to_multiselects(); + + # 2008-07-28 tfu@redhat.com - Bug 431669 + $dbh->bz_alter_column('group_control_map', 'product_id', + { TYPE => 'INT2', NOTNULL => 1 }); ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # -- cgit v1.2.3-24-g4f1b