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

   1 CREATE TABLE /*_*/transcache_tmp (
   2   tc_url varbinary(255) NOT NULL PRIMARY KEY,
   3   tc_contents text,
   4   tc_time binary(14) NOT NULL
   5 ) /*$wgDBTableOptions*/;
   6
   7 INSERT INTO /*_*/transcache_tmp
   8         SELECT * FROM /*_*/transcache;
   9
  10 DROP TABLE /*_*/transcache;
  11
  12 ALTER TABLE /*_*/transcache_tmp RENAME TO /*_*/transcache;