Add a primary key to the profiles_activity table

RESOLVED FIXED in Bugzilla 4.4

Status

()

--
enhancement
RESOLVED FIXED
7 years ago
6 years ago

People

(Reporter: dkl, Assigned: dkl)

Tracking

(Blocks: 1 bug)

Bugzilla 4.4
Dependency tree / graph
Bug Flags:
approval +

Details

Attachments

(1 attachment)

(Assignee)

Description

7 years ago
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

7 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

7 years ago
Created attachment 632760 [details] [diff] [review]
Patch to add incrementing primary key to profiles_activity table (v1)
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+
Flags: approval?

Comment 3

6 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).
Flags: approval? → approval+
Keywords: relnote
Target Milestone: --- → Bugzilla 4.4
(Assignee)

Comment 4

6 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
Last Resolved: 6 years ago
Resolution: --- → FIXED

Updated

6 years ago
Keywords: relnote
You need to log in before you can comment on or make changes to this bug.