diff options
| author | Dave Lawrence <dlawrence@mozilla.com> | 2012-07-23 23:27:16 +0200 |
|---|---|---|
| committer | Dave Lawrence <dlawrence@mozilla.com> | 2012-07-23 23:27:16 +0200 |
| commit | d23802e8b18093a2d257b319f02f6e0942326b67 (patch) | |
| tree | f97c800c0ed6d564b3c12c969d469afb1d700a78 | |
| parent | e4e2e19aeac85b534d5f3b8074b2b3a42122fa4c (diff) | |
| download | bugzilla-d23802e8b18093a2d257b319f02f6e0942326b67.tar.gz bugzilla-d23802e8b18093a2d257b319f02f6e0942326b67.tar.xz | |
Bug 764457 - Add a primary key to the bugs_activity table
r=glob, a=LpSolit
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 2 | ||||
| -rw-r--r-- | Bugzilla/Install/DB.pm | 4 | ||||
| -rwxr-xr-x | contrib/recode.pl | 1 |
3 files changed, 7 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 # ################################################################ diff --git a/contrib/recode.pl b/contrib/recode.pl index f8de12eb1..76e10ad2c 100755 --- a/contrib/recode.pl +++ b/contrib/recode.pl @@ -42,6 +42,7 @@ use constant MAX_STRING_LEN => 25; # For certain tables, we can't automatically determine their Primary Key. # So, we specify it here as a string. use constant SPECIAL_KEYS => { + # bugs_activity since 4.4 has a unique primary key added bugs_activity => 'bug_id,bug_when,fieldid', profile_setting => 'user_id,setting_name', profiles_activity => 'userid,profiles_when,fieldid', |