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_views
bigint unsigned
default 0,
5 ss_total_edits
bigint unsigned
default 0,
6 ss_good_articles
bigint unsigned
default 0,
7 ss_total_pages
bigint default '-1',
8 ss_users
bigint default '-1',
9 ss_active_users
bigint default '-1',
10 ss_images
int default 0
11 ) /*$wgDBTableOptions*/;
13 INSERT INTO /*_*/site_stats_tmp
14 SELECT ss_row_id
, ss_total_views
, ss_total_edits
, ss_good_articles
,
15 ss_total_pages
, ss_users
, ss_active_users
, ss_images
18 DROP TABLE /*_*/site_stats
;
20 ALTER TABLE /*_*/site_stats_tmp
RENAME TO /*_*/site_stats
;
22 CREATE UNIQUE INDEX /*i*/ss_row_id
ON /*_*/site_stats (ss_row_id
);