Page MenuHomePhabricator

Add Primary Key to archive and logging tables
Closed, ResolvedPublic

Description

Schema Change:

All wikis
tables: archive and logging
changes: Add PK
commit status: Pending review

gerrit change Ib6b0fc37 (maintenance/archives/patch-archive-ar_id.sql maintenance/archives/patch-externallinks-el_id.sql)


Version: unspecified
Severity: normal

Details

Reference
bz49198

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 1:52 AM
bzimport set Reference to bz49198.

Primary Key. (this was not clear at all)

Assigning to Asher. As far as I know, he's the only one doing large database schema changes like this at the Wikimedia Foundation currently. Though I think there may be a new Wikimedia Foundation DBA?

(There is, Sean Pringle, though he is probably still in discovery mode)

I think some of these might fall into Sean's lap with guidance from Asher, so I'm going to reset assignee for now.

We (Sean, Asher, and I) just had a prioritization meeting yesterday for all schema changes, you can see the list of them (and sort by priority/whatever) here: http://ur1.ca/eldh1 (shorted long bugzilla url, for prosperity, it is just a list of all bugs that block bug 49188).

Also, I just realized I forgot to do one thing during that meeting, which was to mark this bug as a duplicate of bug 49189 (they're they same request, I was just blindly copying from the old Schema Changes wikitech page).

  • This bug has been marked as a duplicate of bug 49189 ***

(In reply to comment #4)

We (Sean, Asher, and I) just had a prioritization meeting yesterday for all
schema changes, you can see the list of them (and sort by priority/whatever)
here: http://ur1.ca/eldh1 (shorted long bugzilla url, for prosperity, it is
just a list of all bugs that block bug 49188).

Nice, thanks for the update.

And, BTW, s/prosperity/posterity/. ;-)