From fa7651e2a24148a0464bc16ffe70f8438f97d793 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Sat, 30 May 2009 11:54:23 +0000
Subject: Bug 462072: Add FK constraints to the products table - Patch by
 Nitish Bezzala <nbezzala@yahoo.com> r/a=mkanat

---
 Bugzilla/DB/Schema.pm | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index ad2303efc..825e91812 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -1188,7 +1188,10 @@ use constant ABSTRACT_SCHEMA => {
                                   PRIMARYKEY => 1},
             name              => {TYPE => 'varchar(64)', NOTNULL => 1},
             classification_id => {TYPE => 'INT2', NOTNULL => 1,
-                                  DEFAULT => '1'},
+                                  DEFAULT => '1',
+                                  REFERENCES => {TABLE  => 'classifications',
+                                                 COLUMN => 'id',
+                                                 DELETE => 'CASCADE'}},
             description       => {TYPE => 'MEDIUMTEXT'},
             milestoneurl      => {TYPE => 'TINYTEXT', NOTNULL => 1,
                                   DEFAULT => "''"},
-- 
cgit v1.2.3-24-g4f1b