X-Git-Url: http://git.cyclocoop.org/?a=blobdiff_plain;f=maintenance%2Fsqlite%2Farchives%2Fpatch-querycache_info-fix-pk.sql;h=6960667fa1f7c120381d173a3caad4f6cebb2f3e;hb=65e25dd3e98c3f65b9bec0a9ec9523c768fdf4ff;hp=d9483be4e9791947d1e9066758c977872fdc371b;hpb=eff0131f6d8df4f4c81414beb558fdc7c5244f64;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/sqlite/archives/patch-querycache_info-fix-pk.sql b/maintenance/sqlite/archives/patch-querycache_info-fix-pk.sql index d9483be4e9..6960667fa1 100644 --- a/maintenance/sqlite/archives/patch-querycache_info-fix-pk.sql +++ b/maintenance/sqlite/archives/patch-querycache_info-fix-pk.sql @@ -7,9 +7,9 @@ CREATE TABLE /*_*/querycache_info_tmp ( qci_timestamp binary(14) NOT NULL default '19700101000000' ) /*$wgDBTableOptions*/; -INSERT INTO /*_*/querycache_info_tmp - SELECT * FROM /*_*/querycache_info; +INSERT INTO /*_*/querycache_info_tmp(qci_type, qci_timestamp) + SELECT qci_type, qci_timestamp FROM /*_*/querycache_info; DROP TABLE /*_*/querycache_info; -ALTER TABLE /*_*/querycache_info_tmp RENAME TO /*_*/querycache_info; \ No newline at end of file +ALTER TABLE /*_*/querycache_info_tmp RENAME TO /*_*/querycache_info;