diff options
| author | Dave Lawrence <dlawrence@mozilla.com> | 2012-07-25 21:49:12 +0200 |
|---|---|---|
| committer | Dave Lawrence <dlawrence@mozilla.com> | 2012-07-25 21:49:12 +0200 |
| commit | 35e583d3b3ca622ab0288e0a64985b720aa30009 (patch) | |
| tree | d02cc3a8db4695cc7b78291b4111a971c2cd84d8 /Bugzilla | |
| parent | 3c12e5aa267fe9c89a79a65c36ea8f29317d6121 (diff) | |
| download | bugzilla-35e583d3b3ca622ab0288e0a64985b720aa30009.tar.gz bugzilla-35e583d3b3ca622ab0288e0a64985b720aa30009.tar.xz | |
Bug 776972 - Increase bugs_activity primary key size to INTSERIAL for future growth
r/a=LpSolit
Diffstat (limited to 'Bugzilla')
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 2 | ||||
| -rw-r--r-- | Bugzilla/Install/DB.pm | 7 |
2 files changed, 7 insertions, 2 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 1ca7d9d7c..a4bd40cbb 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -322,7 +322,7 @@ use constant ABSTRACT_SCHEMA => { bugs_activity => { FIELDS => [ - id => {TYPE => 'MEDIUMSERIAL', NOTNULL => 1, + id => {TYPE => 'INTSERIAL', NOTNULL => 1, PRIMARYKEY => 1}, bug_id => {TYPE => 'INT3', NOTNULL => 1, REFERENCES => {TABLE => 'bugs', diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index 194ed310b..382a50e50 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -680,12 +680,17 @@ sub update_table_definitions { # 2012-06-13 dkl@mozilla.com - Bug 764457 $dbh->bz_add_column('bugs_activity', 'id', - {TYPE => 'MEDIUMSERIAL', NOTNULL => 1, PRIMARYKEY => 1}); + {TYPE => 'INTSERIAL', NOTNULL => 1, PRIMARYKEY => 1}); # 2012-06-13 dkl@mozilla.com - Bug 764466 $dbh->bz_add_column('profiles_activity', 'id', {TYPE => 'MEDIUMSERIAL', NOTNULL => 1, PRIMARYKEY => 1}); + # 2012-07-24 dkl@mozilla.com - Bug 776972 + $dbh->bz_alter_column('bugs_activity', 'id', + {TYPE => 'INTSERIAL', NOTNULL => 1, PRIMARYKEY => 1}); + + ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # ################################################################ |