Closed Bug 849998 Opened 13 years ago Closed 10 years ago

All foreign keys should be int(11) unsigned

Categories

(addons.mozilla.org Graveyard :: Code Quality, defect)

Product:
addons.mozilla.org Graveyard
Component:
Code Quality
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED WONTFIX

People

(Reporter: cvan, Unassigned)

Details

Almost everywhere we use `int(11) unsigned` for columns with foreign-key constraints. There are a few places where we're using `int(11)` (https://github.com/mozilla/zamboni/blob/master/migrations/412-add-in-mkt-logs.sql#L6 for example). For consistency we should use `int(11) unsigned`.
Lets do this when we move to migrations.
Status: NEW → RESOLVED
Closed: 10 years ago
Resolution: --- → WONTFIX
Product: addons.mozilla.org → addons.mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.