From 6222af28e15f4b958d6d094b557abe4251cea084 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Sat, 30 May 2009 11:58:04 +0000
Subject: Bug 462073: Add FK constraints to the profile_setting 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 825e91812..583b49352 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -1422,7 +1422,10 @@ use constant ABSTRACT_SCHEMA => {
                               REFERENCES => {TABLE  => 'profiles',
                                              COLUMN => 'userid',
                                              DELETE => 'CASCADE'}},
-            setting_name  => {TYPE => 'varchar(32)', NOTNULL => 1},
+            setting_name  => {TYPE => 'varchar(32)', NOTNULL => 1,
+                              REFERENCES => {TABLE  => 'setting',
+                                             COLUMN => 'name',
+                                             DELETE => 'CASCADE'}},
             setting_value => {TYPE => 'varchar(32)', NOTNULL => 1},
         ],
         INDEXES => [
-- 
cgit v1.2.3-24-g4f1b