From c988473afb34914f8fb47d5b49711ccd6ec3fdbd Mon Sep 17 00:00:00 2001 From: Dave Lawrence Date: Tue, 26 Jun 2012 12:41:41 -0400 Subject: Bug 762288 - Change bugs_activity.removed to match data type of bugs_activity.added r/a=LpSolit --- Bugzilla/DB/Schema.pm | 3 ++- Bugzilla/Install/DB.pm | 5 +++++ 2 files changed, 7 insertions(+), 1 deletion(-) diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 06d4a632d..fadc38fc5 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -338,7 +338,7 @@ use constant ABSTRACT_SCHEMA => { REFERENCES => {TABLE => 'fielddefs', COLUMN => 'id'}}, added => {TYPE => 'varchar(255)'}, - removed => {TYPE => 'TINYTEXT'}, + removed => {TYPE => 'varchar(255)'}, comment_id => {TYPE => 'INT3', REFERENCES => { TABLE => 'longdescs', COLUMN => 'comment_id', @@ -350,6 +350,7 @@ use constant ABSTRACT_SCHEMA => { bugs_activity_bug_when_idx => ['bug_when'], bugs_activity_fieldid_idx => ['fieldid'], bugs_activity_added_idx => ['added'], + bugs_activity_removed_idx => ['removed'], ], }, diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index ef2b41e7d..ba656a769 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -673,6 +673,11 @@ sub update_table_definitions { # 2012-04-15 Frank@Frank-Becker.de - Bug 740536 $dbh->bz_add_index('audit_log', 'audit_log_class_idx', ['class', 'at_time']); + # 2012-06-06 dkl@mozilla.com - Bug 762288 + $dbh->bz_alter_column('bugs_activity', 'removed', + { TYPE => 'varchar(255)' }); + $dbh->bz_add_index('bugs_activity', 'bugs_activity_removed_idx', ['removed']); + ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # ################################################################ -- cgit v1.2.3-24-g4f1b