diff options
| author | lpsolit%gmail.com <> | 2009-05-30 13:49:49 +0200 |
|---|---|---|
| committer | lpsolit%gmail.com <> | 2009-05-30 13:49:49 +0200 |
| commit | e73a7b4c8b4d5980bb825543c256cfc20202be15 (patch) | |
| tree | 1754277acdb41150bd3732add220c458142333ce /Bugzilla/DB | |
| parent | 405e90c5d5ef383f1034e64ad3780d0e012a8927 (diff) | |
| download | bugzilla-e73a7b4c8b4d5980bb825543c256cfc20202be15.tar.gz bugzilla-e73a7b4c8b4d5980bb825543c256cfc20202be15.tar.xz | |
Bug 462070: Add FK constraints to the status_workflow table - Patch by Nitish Bezzala <nbezzala@yahoo.com> r/a=mkanat
Diffstat (limited to 'Bugzilla/DB')
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 5416a9fe8..ad2303efc 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -805,8 +805,14 @@ use constant ABSTRACT_SCHEMA => { status_workflow => { FIELDS => [ # On bug creation, there is no old value. - old_status => {TYPE => 'INT2'}, - new_status => {TYPE => 'INT2', NOTNULL => 1}, + old_status => {TYPE => 'INT2', + REFERENCES => {TABLE => 'bug_status', + COLUMN => 'id', + DELETE => 'CASCADE'}}, + new_status => {TYPE => 'INT2', NOTNULL => 1, + REFERENCES => {TABLE => 'bug_status', + COLUMN => 'id', + DELETE => 'CASCADE'}}, require_comment => {TYPE => 'INT1', NOTNULL => 1, DEFAULT => 0}, ], INDEXES => [ |