maintenance/sqlite/archives/patch-site_identifiers-fix-pk.sql

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