summaryrefslogtreecommitdiffstats
path: root/Bugzilla
diff options
context:
space:
mode:
authorDave Lawrence <dlawrence@mozilla.com>2012-01-12 23:18:37 +0100
committerDave Lawrence <dlawrence@mozilla.com>2012-01-12 23:18:37 +0100
commit7f598481cd15b11c43cd68befaad3ce1809669bf (patch)
treec57db5e09d90f596bcea1080061743521a53346f /Bugzilla
parent4c8c286191bc37e4fca87b0395dce2ebadb73068 (diff)
downloadbugzilla-7f598481cd15b11c43cd68befaad3ce1809669bf.tar.gz
bugzilla-7f598481cd15b11c43cd68befaad3ce1809669bf.tar.xz
Bug 715731 - profile_search.user_id should have a FK pointing to profiles.userid
r/a=LpSolit
Diffstat (limited to 'Bugzilla')
-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 3045ae4e6..eda4653e7 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -881,7 +881,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'},
],