[Summary view] [Print] [Text view]

   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*/;
  12  
  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
  16          FROM /*_*/site_stats;
  17  
  18  DROP TABLE /*_*/site_stats;
  19  
  20  ALTER TABLE /*_*/site_stats_tmp RENAME TO /*_*/site_stats;
  21  
  22  CREATE UNIQUE INDEX /*i*/ss_row_id ON /*_*/site_stats (ss_row_id);