rendered paste bodyCREATE 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`)
)