1 files changed, 35 insertions, 0 deletions
diff --git a/www/wiki/maintenance/sqlite/archives/patch-site_stats-modify.sql b/www/wiki/maintenance/sqlite/archives/patch-site_stats-modify.sql
new file mode 100644
index 00000000..8d267a62
--- /dev/null
+++ b/www/wiki/maintenance/sqlite/archives/patch-site_stats-modify.sql
@@ -0,0 +1,35 @@
+DROP TABLE IF EXISTS /*_*/site_stats_tmp;
+
+-- Create the temporary table. The following part
+-- is copied & pasted from the changed tables.sql
+-- file besides having an other table name.
+CREATE TABLE /*_*/site_stats_tmp (
+  ss_row_id int unsigned NOT NULL PRIMARY KEY,
+  ss_total_edits bigint unsigned default NULL,
+  ss_good_articles bigint unsigned default NULL,
+  ss_total_pages bigint unsigned default NULL,
+  ss_users bigint unsigned default NULL,
+  ss_active_users bigint unsigned default NULL,
+  ss_images bigint unsigned default NULL
+) /*$wgDBTableOptions*/;
+
+-- Move the data from the old to the new table
+INSERT OR IGNORE INTO /*_*/site_stats_tmp (
+	ss_row_id,
+	ss_total_edits,
+	ss_good_articles,
+	ss_total_pages,
+	ss_active_users,
+	ss_images
+) SELECT
+	ss_row_id,
+	ss_total_edits,
+	ss_good_articles,
+	ss_total_pages,
+	ss_active_users,
+	ss_images
+FROM /*_*/site_stats;
+
+DROP TABLE /*_*/site_stats;
+
+ALTER TABLE /*_*/site_stats_tmp RENAME TO /*_*/site_stats;