| daniel created this task. daniel triaged this task as "Normal" priority. daniel added projects: Structured-Data-Commons, Multi-Content-Revisions, DBA, Blocked-on-schema-change. Herald added a project: Wikidata. |
TASK DESCRIPTION
Apply maintenance/archives/patch-slot-origin.sql to all wiki databases (if they already have the slots table).
The patch contains the following code:
DROP INDEX /*i*/slot_role_inherited ON /*_*/slots;
ALTER TABLE /*_*/slots DROP COLUMN slot_inherited, ADD COLUMN slot_origin bigint unsigned NOT NULL; CREATE INDEX /*i*/slot_revision_origin_role ON /*_*/slots (slot_revision_id, slot_origin, slot_role_id);
NOTE: the slots table is not used by production code yet, so it should be completely empty in all production databases!
TASK DETAIL
EMAIL PREFERENCES
To: daniel
Cc: aude, Addshore, Aklapper, Anomie, Tgr, daniel, Lahi, PDrouin-WMF, Gq86, E1presidente, Ramsey-WMF, Cparle, SandraF_WMF, GoranSMilovanovic, QZanden, Tramullas, Acer, Marostegui, LawExplorer, Minhnv-2809, Agabi10, Susannaanas, Luke081515, Aschroet, Jane023, Wikidata-bugs, PKM, Base, matthiasmullie, Ricordisamoa, Lydia_Pintscher, Fabrice_Florin, Raymond, Steinsplitter, Mbch331, Jay8g, Krenair
Cc: aude, Addshore, Aklapper, Anomie, Tgr, daniel, Lahi, PDrouin-WMF, Gq86, E1presidente, Ramsey-WMF, Cparle, SandraF_WMF, GoranSMilovanovic, QZanden, Tramullas, Acer, Marostegui, LawExplorer, Minhnv-2809, Agabi10, Susannaanas, Luke081515, Aschroet, Jane023, Wikidata-bugs, PKM, Base, matthiasmullie, Ricordisamoa, Lydia_Pintscher, Fabrice_Florin, Raymond, Steinsplitter, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
