All pastes #400313 Raw Edit

Someone

public text v1 · immutable
·published 2007-03-18 16:55 UTC
rendered paste body
CREATE TABLE `site_counters` (
  `id` int(15) unsigned NOT NULL auto_increment,
  `hour` varchar(12) collate latin1_general_ci NOT NULL,
  `hour_visits` int(6) unsigned NOT NULL,
  `day` varchar(12) collate latin1_general_ci NOT NULL,
  `day_visits` int(6) unsigned NOT NULL,
  `week` int(3) unsigned NOT NULL,
  `week_visits` int(6) unsigned NOT NULL,
  `month` int(2) unsigned NOT NULL,
  `month_visits` int(8) unsigned NOT NULL,
  `total` int(8) unsigned NOT NULL,
  `site` varchar(64) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `site` (`site`),
  KEY `hour_visits` (`hour_visits`),
  KEY `day_visits` (`day_visits`),
  KEY `week_visits` (`week_visits`),
  KEY `month_visits` (`month_visits`),
  KEY `total` (`total`)
)