· 8 years ago · May 18, 2018, 10:56 AM
1--
2-- Структура на таблица `reklami`
3--
4
5CREATE TABLE IF NOT EXISTS `reklami` (
6 `id` int(20) NOT NULL AUTO_INCREMENT,
7 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
8 `opisanie` text COLLATE utf8_unicode_ci NOT NULL,
9 `kod` text COLLATE utf8_unicode_ci NOT NULL,
10 `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
11 `razmer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
12 `uploader` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
13 `time` int(20) NOT NULL,
14 `starttime` int(20) NOT NULL,
15 `livetime` int(20) NOT NULL,
16 `aktivna` int(20) NOT NULL,
17 `clicks` int(20) NOT NULL,
18 `impresii` int(20) NOT NULL,
19 PRIMARY KEY (`id`),
20 KEY `razmer` (`razmer`),
21 KEY `aktivna` (`aktivna`)
22) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=159 ;
23
24--
25-- Дъмп (Ñхема) на данните в таблицата `reklami`
26--