Closed
Bug 426688
Opened 17 years ago
Closed 17 years ago
Add foreign key constraints for flags table and flagtypes table
Categories
(Bugzilla :: Database, enhancement)
Tracking
()
RESOLVED
FIXED
Bugzilla 3.4
People
(Reporter: tfu, Assigned: tfu)
References
(Blocks 1 open bug)
Details
(Whiteboard: [hold checkin until 3.2 branch is created])
Attachments
(1 file)
|
(deleted),
patch
|
mkanat
:
review+
|
Details | Diff | Splinter Review |
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.10) Gecko/20070510 Fedora/1.5.0.10-6.fc6 Firefox/1.5.0.10
Build Identifier:
Add foreign key information for flags table and flagtypes table in Bugzilla/DB/Schema.pm file.
Reproducible: Always
Blocks: bz-references
Attachment #313273 -
Flags: review?(mkanat)
|
||
Updated•17 years ago
|
Assignee: database → tfu
Severity: normal → enhancement
Status: UNCONFIRMED → NEW
Ever confirmed: true
Target Milestone: --- → Bugzilla 4.0
|
|
||
Comment 2•17 years ago
|
||
Comment on attachment 313273 [details] [diff] [review]
adding foreign key constraints of flags table and flagtypes table
Looks good!
Attachment #313273 -
Flags: review?(mkanat) → review+
|
|
||
Updated•17 years ago
|
Status: NEW → ASSIGNED
Flags: approval+
Whiteboard: [hold checkin until 3.2 branch is created]
Version: unspecified → 3.1.3
|
|
||
Comment 3•17 years ago
|
||
I checked in all of the pending FK patches at once:
Checking in Bugzilla/DB/Schema.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/DB/Schema.pm,v <-- Schema.pm
new revision: 1.100; previous revision: 1.99
done
Status: ASSIGNED → RESOLVED
Closed: 17 years ago
Resolution: --- → FIXED
How can profiles.userid be a foreign key of flags.requestee_id? flags.requestee_id could be NULL.
(In reply to comment #4)
> How can profiles.userid be a foreign key of flags.requestee_id?
> flags.requestee_id could be NULL.
>
>
Foreign key constraint allows the referencing field (flags.requestee_id) to have NULL value as well as the values in referenced field (profiles.userid).
|
|
||
Updated•16 years ago
|
Flags: needsinfo?(tfu)
Flags: needsinfo?(mkanat)
|
|
||
Updated•16 years ago
|
Target Milestone: Bugzilla 4.0 → Bugzilla 3.4
You need to log in
before you can comment on or make changes to this bug.
Description
•