Convert INDEX into PRIMARY KEY in l10n_cache
[lhc/web/wiklou.git] / maintenance / sqlite / archives / patch-l10n_cache-primary-key.sql
1 --
2 -- patch-l10n_cache-primary-key.sql
3 --
4 -- Bug T146591. Add l10n_cache primary key
5 DROP TABLE IF EXISTS /*_*/l10n_cache;
6
7 CREATE TABLE /*$wgDBprefix*/l10n_cache (
8 lc_lang varbinary(32) NOT NULL,
9 lc_key varchar(255) NOT NULL,
10 lc_value mediumblob NOT NULL,
11 PRIMARY KEY (lc_lang, lc_key)
12 ) /*$wgDBTableOptions*/;