Closed
Bug 764466
Opened 13 years ago
Closed 13 years ago
Add a primary key to the profiles_activity table
Categories
(Bugzilla :: Database, enhancement)
Tracking
()
RESOLVED
FIXED
Bugzilla 4.4
People
(Reporter: dkl, Assigned: dkl)
References
(Blocks 1 open bug)
Details
Attachments
(1 file)
|
1.21 KB,
patch
|
glob
:
review+
|
Details | Diff | Splinter Review |
Due to recent database issues and also being good practice to have a primary key on tables due to replication, I will be attaching a patch to add a primary key to the profiles_activity table.
dkl
|
||
Updated•13 years ago
|
Severity: normal → enhancement
OS: Linux → All
Hardware: x86_64 → All
Summary: Add a new autoinc primary key for the profiles_activity table → Add a primary key to the profiles_activity table
|
Assignee | |
Comment 1•13 years ago
|
||
Attachment #632760 -
Flags: review?(glob)
Comment on attachment 632760 [details] [diff] [review]
Patch to add incrementing primary key to profiles_activity table (v1)
r=glob
Attachment #632760 -
Flags: review?(glob) → review+
|
|
||
Comment 3•13 years ago
|
||
I found a place where this new primary key will be useful: in contrib/recode.pl. On checkin, add a comment in SPECIAL_KEYS right above
profiles_activity => 'userid,profiles_when,fieldid'
that the PK only exists since 4.4 (else someone is going to accidentally remove
this entry).
|
|
Assignee | |
Comment 4•13 years ago
|
||
Committing to: bzr+ssh://dlawrence%40mozilla.com@bzr.mozilla.org/bugzilla/trunk
modified contrib/recode.pl
modified Bugzilla/Install/DB.pm
modified Bugzilla/DB/Schema.pm
Committed revision 8291.
Status: ASSIGNED → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
You need to log in
before you can comment on or make changes to this bug.
Description
•