sql/sqlite/patch-objectcache-exptime-notnull.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

CREATE TABLE /*_*/objectcache_tmp (
  keyname BLOB DEFAULT '' NOT NULL,
  value BLOB DEFAULT NULL,
  exptime BLOB NOT NULL,
  PRIMARY KEY(keyname)
) /*$wgDBTableOptions*/;

INSERT INTO /*_*/objectcache_tmp(keyname, value, exptime)
  SELECT keyname, value, exptime FROM /*_*/objectcache;

DROP TABLE /*_*/objectcache;
ALTER TABLE /*_*/objectcache_tmp RENAME TO /*_*/objectcache;

CREATE INDEX exptime ON /*_*/objectcache (exptime);