gYHWZq8K

1--
2-- Структура таблицы `counters_teasers`
3--
4
5CREATE TABLE IF NOT EXISTS `counters_teasers` (
6  `teaser_id` int(11) unsigned NOT NULL,
7  `rotates` int(11) unsigned NOT NULL DEFAULT '0',
8  `clicks` int(11) unsigned NOT NULL DEFAULT '0',
9  `real_clicks` int(11) unsigned NOT NULL DEFAULT '0',
10  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
11  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
12  PRIMARY KEY (`teaser_id`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Инкрементные счетчики по тизерам';
14
15
16
17--
18-- Ограничения внешнего ключа таблицы `counters_teasers`
19--
20ALTER TABLE `counters_teasers`
21  ADD CONSTRAINT `FK_counters_teasers` FOREIGN KEY (`teaser_id`) REFERENCES `teasers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;