summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorDave Lawrence <dlawrence@mozilla.com>2012-06-26 18:45:58 +0200
committerDave Lawrence <dlawrence@mozilla.com>2012-06-26 18:45:58 +0200
commit06feb186d98d718264671e8079ccd01d20935165 (patch)
tree2842e9bcb0c938d4eaf9904edc573c068f5d4964
parent5c656675e8a45f1ba6cf57dfdd32a2ef0c9acf85 (diff)
downloadbugzilla-06feb186d98d718264671e8079ccd01d20935165.tar.gz
bugzilla-06feb186d98d718264671e8079ccd01d20935165.tar.xz
Bug 762288 - Change bugs_activity.removed to match data type of bugs_activity.added
r/a=LpSolit
-rw-r--r--Bugzilla/DB/Schema.pm3
-rw-r--r--Bugzilla/Install/DB.pm5
2 files changed, 7 insertions, 1 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 00ff4acc9..70b0c0650 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -358,7 +358,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',
@@ -370,6 +370,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 e89e19647..baf9adeed 100644
--- a/Bugzilla/Install/DB.pm
+++ b/Bugzilla/Install/DB.pm
@@ -669,6 +669,11 @@ sub update_table_definitions {
$dbh->bz_add_index('profile_search', 'profile_search_user_id_idx', [qw(user_id)]);
}
+ # 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 #
################################################################