summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorDave Lawrence <dlawrence@mozilla.com>2012-01-12 23:16:46 +0100
committerDave Lawrence <dlawrence@mozilla.com>2012-01-12 23:16:46 +0100
commite4206816f0392538934de85323b9f0616cd5fcd7 (patch)
tree09938175ecc0293a3d4628c84c37bc00b42f155e
parenteba2ab79d0d4a53fef4c3ca6d5001f73907608c7 (diff)
downloadbugzilla-e4206816f0392538934de85323b9f0616cd5fcd7.tar.gz
bugzilla-e4206816f0392538934de85323b9f0616cd5fcd7.tar.xz
Bug 715731 - profile_search.user_id should have a FK pointing to profiles.userid
r/a=LpSolit
-rw-r--r--Bugzilla/DB/Schema.pm5
1 files changed, 4 insertions, 1 deletions
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'},
],