--
-- Структура таблицы `static_banner`
--
CREATE TABLE `static_banner` (
`id` int(11) NOT NULL auto_increment,
`id_banner` int(11) NOT NULL,
`date` date NOT NULL default '0000-00-00',
`show` int(11) NOT NULL default '1',
`click` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id_banner` (`id_banner`,`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Статистика по баннерам' AUTO_INCREMENT=7 ;
--
-- Дамп данных таблицы `static_banner`
--
INSERT INTO `static_banner` VALUES(1, 7, '2008-10-26', 24, 0);
INSERT INTO `static_banner` VALUES(2, 8, '2008-10-26', 16, 0);
INSERT INTO `static_banner` VALUES(3, 6, '2008-10-26', 12, 0);
INSERT INTO `static_banner` VALUES(4, 6, '2008-10-27', 17, 0);
INSERT INTO `static_banner` VALUES(5, 8, '2008-10-27', 15, 0);
INSERT INTO `static_banner` VALUES(6, 7, '2008-10-27', 21, 0);
|