diff options
| author | Dave Lawrence <dlawrence@mozilla.com> | 2012-07-25 21:56:05 +0200 |
|---|---|---|
| committer | Dave Lawrence <dlawrence@mozilla.com> | 2012-07-25 21:56:05 +0200 |
| commit | 4c10c375023526202df17a70927070e795305266 (patch) | |
| tree | 6f9c130147fac1c3c510e26e784ec660cda3b0c8 /Bugzilla/DB | |
| parent | 2f75b68d00ec8bf732b4f0874fec302bd3262988 (diff) | |
| download | bugzilla-4c10c375023526202df17a70927070e795305266.tar.gz bugzilla-4c10c375023526202df17a70927070e795305266.tar.xz | |
Bug 776972 - Increase bugs_activity primary key size to INTSERIAL for future growth
r/a=LpSolit
Diffstat (limited to 'Bugzilla/DB')
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 09475807c..5a88540a9 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -342,7 +342,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', @@ -361,7 +361,7 @@ use constant ABSTRACT_SCHEMA => { COLUMN => 'id'}}, added => {TYPE => 'varchar(255)'}, removed => {TYPE => 'varchar(255)'}, - comment_id => {TYPE => 'INT3', + comment_id => {TYPE => 'INT4', REFERENCES => { TABLE => 'longdescs', COLUMN => 'comment_id', DELETE => 'CASCADE'}}, @@ -396,7 +396,7 @@ use constant ABSTRACT_SCHEMA => { longdescs => { FIELDS => [ - comment_id => {TYPE => 'MEDIUMSERIAL', NOTNULL => 1, + comment_id => {TYPE => 'INTSERIAL', NOTNULL => 1, PRIMARYKEY => 1}, bug_id => {TYPE => 'INT3', NOTNULL => 1, REFERENCES => {TABLE => 'bugs', |