1 -- Make reorderings of UNIQUE indices non-UNIQUE
2 -- Since 1.24, these indices have been non-UNIQUE in tables.sql.
3 -- However, an earlier update from 1.15 that made the indices
4 -- UNIQUE was not removed until 1.28 (T78513).
6 DROP INDEX /*i*/pl_namespace
ON /*_*/pagelinks
;
7 CREATE INDEX /*i*/pl_namespace
ON /*_*/pagelinks (pl_namespace
, pl_title
, pl_from
);
8 DROP INDEX /*i*/tl_namespace
ON /*_*/templatelinks
;
9 CREATE INDEX /*i*/tl_namespace
ON /*_*/templatelinks (tl_namespace
, tl_title
, tl_from
);
10 DROP INDEX /*i*/il_to
ON /*_*/imagelinks
;
11 CREATE INDEX /*i*/il_to
ON /*_*/imagelinks (il_to
, il_from
);