X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Farchives%2Fpatch-slots.sql;h=5fafe6d39d5b21ea7c5734858d65384078349a99;hb=d2b7662bbae2b6ff6599e72eb449cb2ce444e877;hp=1a51bb9ef380995ea63ce3e1cc292d2ffaa78298;hpb=a18476eab39dc201384c68cbd27228c5af32f7fc;p=lhc%2Fweb%2Fwiklou.git

diff --git a/maintenance/archives/patch-slots.sql b/maintenance/archives/patch-slots.sql
index 1a51bb9ef3..5fafe6d39d 100644
--- a/maintenance/archives/patch-slots.sql
+++ b/maintenance/archives/patch-slots.sql
@@ -14,11 +14,12 @@ CREATE TABLE /*_*/slots (
   -- reference to content_id
   slot_content_id bigint unsigned NOT NULL,
 
-  -- whether the content is inherited (1) or new in this revision (0)
-  slot_inherited tinyint unsigned NOT NULL DEFAULT 0,
+  -- The revision ID of the revision that originated the slot's content.
+  -- To find revisions that changed slots, look for slot_origin = slot_revision_id.
+  slot_origin bigint unsigned NOT NULL,
 
   PRIMARY KEY ( slot_revision_id, slot_role_id )
 ) /*$wgDBTableOptions*/;
 
 -- Index for finding revisions that modified a specific slot
-CREATE INDEX /*i*/slot_role_inherited ON /*_*/slots (slot_revision_id, slot_role_id, slot_inherited);
\ No newline at end of file
+CREATE INDEX /*i*/slot_revision_origin_role ON /*_*/slots (slot_revision_id, slot_origin, slot_role_id);