summaryrefslogtreecommitdiffstats
path: root/Bugzilla/DB
diff options
context:
space:
mode:
authorlpsolit%gmail.com <>2009-05-30 13:49:49 +0200
committerlpsolit%gmail.com <>2009-05-30 13:49:49 +0200
commite73a7b4c8b4d5980bb825543c256cfc20202be15 (patch)
tree1754277acdb41150bd3732add220c458142333ce /Bugzilla/DB
parent405e90c5d5ef383f1034e64ad3780d0e012a8927 (diff)
downloadbugzilla-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.pm10
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 => [