diff options
Diffstat (limited to 'Bugzilla/DB/Schema.pm')
-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 => [ |