summaryrefslogtreecommitdiffstats
path: root/Bugzilla
diff options
context:
space:
mode:
authorDave Lawrence <dlawrence@mozilla.com>2012-07-23 23:27:16 +0200
committerDave Lawrence <dlawrence@mozilla.com>2012-07-23 23:27:16 +0200
commitd23802e8b18093a2d257b319f02f6e0942326b67 (patch)
treef97c800c0ed6d564b3c12c969d469afb1d700a78 /Bugzilla
parente4e2e19aeac85b534d5f3b8074b2b3a42122fa4c (diff)
downloadbugzilla-d23802e8b18093a2d257b319f02f6e0942326b67.tar.gz
bugzilla-d23802e8b18093a2d257b319f02f6e0942326b67.tar.xz
Bug 764457 - Add a primary key to the bugs_activity table
r=glob, a=LpSolit
Diffstat (limited to 'Bugzilla')
-rw-r--r--Bugzilla/DB/Schema.pm2
-rw-r--r--Bugzilla/Install/DB.pm4
2 files changed, 6 insertions, 0 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 70b0c0650..f8469e66e 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -342,6 +342,8 @@ use constant ABSTRACT_SCHEMA => {
bugs_activity => {
FIELDS => [
+ id => {TYPE => 'MEDIUMSERIAL', NOTNULL => 1,
+ PRIMARYKEY => 1},
bug_id => {TYPE => 'INT3', NOTNULL => 1,
REFERENCES => {TABLE => 'bugs',
COLUMN => 'bug_id',
diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm
index baf9adeed..39bfca602 100644
--- a/Bugzilla/Install/DB.pm
+++ b/Bugzilla/Install/DB.pm
@@ -674,6 +674,10 @@ sub update_table_definitions {
{ TYPE => 'varchar(255)' });
$dbh->bz_add_index('bugs_activity', 'bugs_activity_removed_idx', ['removed']);
+ # 2012-06-13 dkl@mozilla.com - Bug 764457
+ $dbh->bz_add_column('bugs_activity', 'id',
+ {TYPE => 'MEDIUMSERIAL', NOTNULL => 1, PRIMARYKEY => 1});
+
################################################################
# New --TABLE-- changes should go *** A B O V E *** this point #
################################################################