diff options
| author | Dave Lawrence <dlawrence@mozilla.com> | 2012-07-23 23:23:43 +0200 |
|---|---|---|
| committer | Dave Lawrence <dlawrence@mozilla.com> | 2012-07-23 23:23:43 +0200 |
| commit | 3dce1aa3a9ec8898b0dbcadfc3d7a4bdb5893327 (patch) | |
| tree | 998857e488f9432be52116f7d8256e29ed90211d /Bugzilla | |
| parent | 58cfa7b96dd3e480140b258b9dd88b65b772b0a2 (diff) | |
| download | bugzilla-3dce1aa3a9ec8898b0dbcadfc3d7a4bdb5893327.tar.gz bugzilla-3dce1aa3a9ec8898b0dbcadfc3d7a4bdb5893327.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.pm | 2 | ||||
| -rw-r--r-- | Bugzilla/Install/DB.pm | 4 |
2 files changed, 6 insertions, 0 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index fadc38fc5..7293d25d8 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -322,6 +322,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 ba656a769..f516748b9 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -678,6 +678,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 # ################################################################ |