From 3defd9c08f4d352c53723828665f999d25613076 Mon Sep 17 00:00:00 2001
From: "mkanat%bugzilla.org" <>
Date: Thu, 26 Jun 2008 14:23:27 +0000
Subject: Bug 423598: Add foreign key constraints for keywords table Patch By
 Tony Fu <tfu@redhat.com> r=mkanat, a=mkanat

---
 Bugzilla/DB/Schema.pm | 11 +++++++++--
 1 file changed, 9 insertions(+), 2 deletions(-)

(limited to 'Bugzilla/DB')

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)],
-- 
cgit v1.2.3-24-g4f1b