2 -- Replace slot_inherited with slot_origin.
4 -- NOTE: There is no release that has slot_inherited. This is only needed to transition between
5 -- snapshot versions of 1.30.
7 -- NOTE: No code that writes to the slots table was merge yet, the table is assumed to be empty.
11 DROP TABLE /*_*/slots
;
13 CREATE TABLE /*_*/slots (
15 -- reference to rev_id
16 slot_revision_id
bigint unsigned
NOT NULL,
18 -- reference to role_id
19 slot_role_id
smallint unsigned
NOT NULL,
21 -- reference to content_id
22 slot_content_id
bigint unsigned
NOT NULL,
24 -- The revision ID of the revision that originated the slot's content.
25 -- To find revisions that changed slots, look for slot_origin = slot_revision_id.
26 slot_origin
bigint unsigned
NOT NULL,
28 PRIMARY KEY ( slot_revision_id
, slot_role_id
)
29 ) /*$wgDBTableOptions*/;
31 -- Index for finding revisions that modified a specific slot
32 CREATE INDEX /*i*/slot_revision_origin_role
ON /*_*/slots (slot_revision_id
, slot_origin
, slot_role_id
);