1 CREATE TABLE /*_*/site_identifiers_tmp (
3 si_site
INT UNSIGNED
NOT NULL,
5 -- local key type, ie 'interwiki' or 'langlink'
6 si_type
varbinary(32) NOT NULL,
8 -- local key value, ie 'en' or 'wiktionary'
9 si_key
varbinary(32) NOT NULL,
11 PRIMARY KEY (si_type
, si_key
)
12 ) /*$wgDBTableOptions*/;
14 INSERT INTO /*_*/site_identifiers_tmp
15 SELECT * FROM /*_*/site_identifiers
;
17 DROP TABLE /*_*/site_identifiers
;
19 ALTER TABLE /*_*/site_identifiers_tmp
RENAME TO /*_*/site_identifiers
;
21 CREATE INDEX /*i*/site_ids_site
ON /*_*/site_identifiers (si_site
);
22 CREATE INDEX /*i*/site_ids_key
ON /*_*/site_identifiers (si_key
);