diff options
| author | lpsolit%gmail.com <> | 2006-02-22 02:38:51 +0100 |
|---|---|---|
| committer | lpsolit%gmail.com <> | 2006-02-22 02:38:51 +0100 |
| commit | af703f64fdcc4f214a9cce5e990907ce4ec8ada8 (patch) | |
| tree | 56b1460789c46198fa5d588021c8ae325451f792 | |
| parent | 22c141030bfd6a3a5e911cad72bed53f6553c8af (diff) | |
| download | bugzilla-af703f64fdcc4f214a9cce5e990907ce4ec8ada8.tar.gz bugzilla-af703f64fdcc4f214a9cce5e990907ce4ec8ada8.tar.xz | |
Bug 225221: The 'longdescs' table needs a primary key - Patch by Albert Ting <altlst@sonic.net> r=mkanat a=justdave
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 2 | ||||
| -rwxr-xr-x | checksetup.pl | 4 |
2 files changed, 6 insertions, 0 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 3caeba707..44f17636c 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -256,6 +256,8 @@ use constant ABSTRACT_SCHEMA => { longdescs => { FIELDS => [ + comment_id => {TYPE => 'MEDIUMSERIAL', NOTNULL => 1, + PRIMARYKEY => 1}, bug_id => {TYPE => 'INT3', NOTNULL => 1}, who => {TYPE => 'INT3', NOTNULL => 1}, bug_when => {TYPE => 'DATETIME', NOTNULL => 1}, diff --git a/checksetup.pl b/checksetup.pl index f88c8bb28..4c1455d45 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -4270,6 +4270,10 @@ $dbh->bz_add_column('fielddefs', 'type', $dbh->bz_add_column('fielddefs', 'custom', { TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'FALSE' }); +# 2005-12-07 altlst@sonic.net -- Bug 225221 +$dbh->bz_add_column('longdescs', 'comment_id', + {TYPE => 'MEDIUMSERIAL', NOTNULL => 1, PRIMARYKEY => 1}); + # If you had to change the --TABLE-- definition in any way, then add your # differential change code *** A B O V E *** this comment. # |