summaryrefslogtreecommitdiffstats
path: root/Bugzilla
diff options
context:
space:
mode:
Diffstat (limited to 'Bugzilla')
-rw-r--r--Bugzilla/DB/Schema.pm11
1 files changed, 9 insertions, 2 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index e35162b02..27f6384e4 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -482,8 +482,15 @@ use constant ABSTRACT_SCHEMA => {
keywords => {
FIELDS => [
- bug_id => {TYPE => 'INT3', NOTNULL => 1},
- keywordid => {TYPE => 'INT2', NOTNULL => 1},
+ bug_id => {TYPE => 'INT3', NOTNULL => 1,
+ REFERENCES => {TABLE => 'bugs',
+ COLUMN => 'bug_id',
+ DELETE => 'CASCADE'}},
+ keywordid => {TYPE => 'INT2', NOTNULL => 1,
+ REFERENCES => {TABLE => 'keyworddefs',
+ COLUMN => 'id',
+ DELETE => 'CASCADE'}},
+
],
INDEXES => [
keywords_bug_id_idx => {FIELDS => [qw(bug_id keywordid)],