From e4206816f0392538934de85323b9f0616cd5fcd7 Mon Sep 17 00:00:00 2001 From: Dave Lawrence Date: Thu, 12 Jan 2012 17:16:46 -0500 Subject: Bug 715731 - profile_search.user_id should have a FK pointing to profiles.userid r/a=LpSolit --- 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 7b7e4ffb6..da0c7d207 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -901,7 +901,10 @@ use constant ABSTRACT_SCHEMA => { profile_search => { FIELDS => [ id => {TYPE => 'INTSERIAL', NOTNULL => 1, PRIMARYKEY => 1}, - user_id => {TYPE => 'INT3', NOTNULL => 1}, + user_id => {TYPE => 'INT3', NOTNULL => 1, + REFERENCES => {TABLE => 'profiles', + COLUMN => 'userid', + DELETE => 'CASCADE'}}, bug_list => {TYPE => 'MEDIUMTEXT', NOTNULL => 1}, list_order => {TYPE => 'MEDIUMTEXT'}, ], -- cgit v1.2.3-24-g4f1b