Closed
Bug 715731
Opened 13 years ago
Closed 12 years ago
profile_search.user_id should have a FK pointing to profiles.userid
Categories
(Bugzilla :: Database, enhancement)
Tracking
()
RESOLVED
FIXED
Bugzilla 4.2
People
(Reporter: LpSolit, Assigned: dkl)
References
Details
Attachments
(1 file)
|
737 bytes,
patch
|
LpSolit
:
review+
|
Details | Diff | Splinter Review |
If a user account is deleted, entries in the profile_search table should go away too, so profile_search.user_id should have a FK pointing to profiles.userid.
|
Assignee | |
Comment 1•12 years ago
|
||
This adds a foreign key relationship from profile_search to profiles on user_id which allows entries in profile_search to be removed properly when a user is deleted. I have verified the data is removed and no error is generated. dkl
|
Reporter | |
Comment 2•12 years ago
|
||
Comment on attachment 587820 [details] [diff] [review] Patch to add foreign key to profile_search table for user_id (v1) Works fine. r=LpSolit
Attachment #587820 -
Flags: review?(LpSolit) → review+
|
||
Updated•12 years ago
|
Flags: approval4.2+
Flags: approval+
Target Milestone: --- → Bugzilla 4.2
|
|
Reporter | |
Updated•12 years ago
|
Flags: blocking4.2+
|
|
Assignee | |
Comment 3•12 years ago
|
||
trunk: Committing to: bzr+ssh://dlawrence%40mozilla.com@bzr.mozilla.org/bugzilla/trunk modified Bugzilla/DB/Schema.pm Committed revision 8079. 4.2: Committing to: bzr+ssh://dlawrence%40mozilla.com@bzr.mozilla.org/bugzilla/4.2 modified Bugzilla/DB/Schema.pm Committed revision 8008.
Status: ASSIGNED → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
You need to log in
before you can comment on or make changes to this bug.
Description
•