1 -- field is deprecated and no longer updated as of 1.5
2 CREATE TABLE /*_*/site_stats_tmp (
3 ss_row_id
int unsigned
NOT NULL,
4 ss_total_edits
bigint unsigned
default 0,
5 ss_good_articles
bigint unsigned
default 0,
6 ss_total_pages
bigint default '-1',
7 ss_users
bigint default '-1',
8 ss_active_users
bigint default '-1',
9 ss_images
int default 0
10 ) /*$wgDBTableOptions*/;
12 INSERT INTO /*_*/site_stats_tmp
13 SELECT ss_row_id
, ss_total_edits
, ss_good_articles
,
14 ss_total_pages
, ss_users
, ss_active_users
, ss_images
17 DROP TABLE /*_*/site_stats
;
19 ALTER TABLE /*_*/site_stats_tmp
RENAME TO /*_*/site_stats
;
21 CREATE UNIQUE INDEX /*i*/ss_row_id
ON /*_*/site_stats (ss_row_id
);