maintenance/archives/patch-hit_statistics.sql

   1 -- Creates the hit_statistics table, for storing, as the name implies, hit statistics.
   2
   3 CREATE TABLE /*$wgDBprefix*/hit_statistics (
   4         hs_page bigint(20) NOT NULL, -- Maybe this should be a namespace/title tuple instead.
   5         hs_period_start binary(14) NOT NULL,
   6         hs_period_end binary(14) NOT NULL,
   7         hs_period_length bigint(20) NOT NULL,
   8         hs_count bigint(20) NOT NULL,
   9
  10         PRIMARY KEY  (hs_page,hs_period_start),
  11         KEY hs_period_start (hs_period_start),
  12         KEY hs_period_length (hs_period_length),
  13         KEY hs_count (hs_count)
  14 ) /*$wgDBTableOptions*/;