diff options
| author | Dave Lawrence <dlawrence@mozilla.com> | 2012-01-12 23:16:46 +0100 |
|---|---|---|
| committer | Dave Lawrence <dlawrence@mozilla.com> | 2012-01-12 23:16:46 +0100 |
| commit | e4206816f0392538934de85323b9f0616cd5fcd7 (patch) | |
| tree | 09938175ecc0293a3d4628c84c37bc00b42f155e /Bugzilla/DB | |
| parent | eba2ab79d0d4a53fef4c3ca6d5001f73907608c7 (diff) | |
| download | bugzilla-e4206816f0392538934de85323b9f0616cd5fcd7.tar.gz bugzilla-e4206816f0392538934de85323b9f0616cd5fcd7.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 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'}, ], |