| Marostegui renamed this task from "In the slots table, replace slot_inherited with slot_origin" to "DROP unused 'slots' table (WAS: In the slots table, replace slot_inherited with slot_origin)". Marostegui updated the task description. (Show Details) |
CHANGES TO TASK DESCRIPTION
Apply `maintenance/archives/patch-slot-origin.sql` to all wiki databases (if they already have the `slots` table)In order to create the `slots` table with the correct schema, as it is unused (will be confirmed), it is faster to drop it and then recreate it.
The patch contains the following code:Dropping progress:
[] s1
[] s2
[] s3
[] s4
[] s5
[] s6
[] s7
DROP INDEX /*i*/slot_role_inherited ON /*_*/slots;[] s8
~~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~~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!
The patch contains the following code:Dropping progress:
[] s1
[] s2
[] s3
[] s4
[] s5
[] s6
[] s7
DROP INDEX /*i*/slot_role_inherited ON /*_*/slots;[] s8
~~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~~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: Marostegui
Cc: jcrespo, Marostegui, aude, Addshore, Aklapper, Anomie, Tgr, daniel, Lahi, PDrouin-WMF, Gq86, E1presidente, Ramsey-WMF, Cparle, SandraF_WMF, GoranSMilovanovic, QZanden, Tramullas, Acer, LawExplorer, Minhnv-2809, Agabi10, Susannaanas, Luke081515, Aschroet, Jane023, Wikidata-bugs, PKM, Base, matthiasmullie, Ricordisamoa, Lydia_Pintscher, Fabrice_Florin, Raymond, Steinsplitter, Mbch331, Jay8g, Krenair
Cc: jcrespo, Marostegui, aude, Addshore, Aklapper, Anomie, Tgr, daniel, Lahi, PDrouin-WMF, Gq86, E1presidente, Ramsey-WMF, Cparle, SandraF_WMF, GoranSMilovanovic, QZanden, Tramullas, Acer, 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
