Fixup some SELECT * usages in sqlite schema patches

[lhc/web/wiklou.git] / maintenance / sqlite / archives / patch-site_stats-fix-pk.sql

diff --git a/maintenance/sqlite/archives/patch-site_stats-fix-pk.sql b/maintenance/sqlite/archives/patch-site_stats-fix-pk.sql
index d785e98..b5b60f1 100644 (file)
--- a/maintenance/sqlite/archives/patch-site_stats-fix-pk.sql
+++ b/maintenance/sqlite/archives/patch-site_stats-fix-pk.sql
@@ -25,9 +25,9 @@ CREATE TABLE /*_*/site_stats_tmp (
   ss_images int default 0
 ) /*$wgDBTableOptions*/;
 
-INSERT INTO /*_*/site_stats_tmp
-       SELECT * FROM /*_*/site_stats;
+INSERT INTO /*_*/site_stats_tmp(ss_row_id, ss_total_edits, ss_good_articles, ss_total_pages, ss_users, ss_active_users, ss_images)
+       SELECT ss_row_id, ss_total_edits, ss_good_articles, ss_total_pages, ss_users, ss_active_users, ss_images FROM /*_*/site_stats;
 
 DROP TABLE /*_*/site_stats;
 
-ALTER TABLE /*_*/site_stats_tmp RENAME TO /*_*/site_stats;
\ No newline at end of file
+ALTER TABLE /*_*/site_stats_tmp RENAME TO /*_*/site_stats;