Add FK constraints to the products table

RESOLVED FIXED in Bugzilla 3.6

Status

()

Bugzilla
Database
--
enhancement
RESOLVED FIXED
9 years ago
9 years ago

People

(Reporter: Frédéric Buclin, Assigned: Nitish Bezzala)

Tracking

(Blocks: 1 bug)

Bugzilla 3.6
Dependency tree / graph
Bug Flags:
approval +

Details

Attachments

(1 attachment)

(Reporter)

Description

9 years ago
classification_id should point to classifications.id.
(Reporter)

Updated

9 years ago
Whiteboard: [Good Intro Bug]

Comment 1

9 years ago
I'll take this one.

Updated

9 years ago
Assignee: database → vipinhegde
(Reporter)

Comment 2

9 years ago
Vipin, any progress on this bug and the other two assigned to you?
(Assignee)

Comment 3

9 years ago
Created attachment 379653 [details] [diff] [review]
Added REFERENCE block
Attachment #379653 - Flags: review?(LpSolit)
(Reporter)

Updated

9 years ago
Attachment #379653 - Flags: review?(LpSolit) → review?(mkanat)

Comment 4

9 years ago
Comment on attachment 379653 [details] [diff] [review]
Added REFERENCE block

  Yeah, this is fine, but:

>+                                  REFERENCES    =>  {TABLE  =>  'classifications',

  Why the weird spacing after REFERENCES? And why are there two spaces after => on TABLE?

  Fix the spacing on checkin.
Attachment #379653 - Flags: review?(mkanat) → review+

Updated

9 years ago
Assignee: vipinhegde → nbezzala
Flags: approval+
Whiteboard: [Good Intro Bug]
Target Milestone: --- → Bugzilla 3.6
(Reporter)

Comment 5

9 years ago
Checking in Bugzilla/DB/Schema.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/DB/Schema.pm,v  <--  Schema.pm
new revision: 1.120; previous revision: 1.119
done
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → FIXED
(Reporter)

Updated

9 years ago
Blocks: 495783
You need to log in before you can comment on or make changes to this bug.