1 DROP TABLE IF EXISTS /*_*/site_stats_tmp
;
3 -- Create the temporary table. The following part
4 -- is copied & pasted from the changed tables.sql
5 -- file besides having an other table name.
6 CREATE TABLE /*_*/site_stats_tmp (
7 ss_row_id
int unsigned
NOT NULL PRIMARY KEY,
8 ss_total_edits
bigint unsigned
default NULL,
9 ss_good_articles
bigint unsigned
default NULL,
10 ss_total_pages
bigint unsigned
default NULL,
11 ss_users
bigint unsigned
default NULL,
12 ss_active_users
bigint unsigned
default NULL,
13 ss_images
bigint unsigned
default NULL
14 ) /*$wgDBTableOptions*/;
16 -- Move the data from the old to the new table
17 INSERT OR IGNORE INTO /*_*/site_stats_tmp (
33 DROP TABLE /*_*/site_stats
;
35 ALTER TABLE /*_*/site_stats_tmp
RENAME TO /*_*/site_stats
;