diff options
| author | Dave Lawrence <dlawrence@mozilla.com> | 2012-01-12 23:18:37 +0100 |
|---|---|---|
| committer | Dave Lawrence <dlawrence@mozilla.com> | 2012-01-12 23:18:37 +0100 |
| commit | 7f598481cd15b11c43cd68befaad3ce1809669bf (patch) | |
| tree | c57db5e09d90f596bcea1080061743521a53346f /Bugzilla/DB | |
| parent | 4c8c286191bc37e4fca87b0395dce2ebadb73068 (diff) | |
| download | bugzilla-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/DB')
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 5 |
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'}, ], |