· 8 years ago · Mar 08, 2018, 03:30 PM
1DROP TABLE IF EXISTS `isksense_devel`.`adverts`;
2CREATE TABLE `isksense_devel`.`adverts` (
3 `id` int(11) NOT NULL auto_increment,
4 `user_id` int(11) default NULL,
5 `link` varchar(255) default NULL,
6 `title` varchar(255) default NULL,
7 `text` varchar(255) default NULL,
8 `excluded_sites` varchar(255) default NULL,
9 `excluded_keywords` varchar(255) default NULL,
10 `continent` varchar(3) default NULL,
11 PRIMARY KEY (`id`),
12 KEY `index_adverts_on_id` (`id`),
13 KEY `index_adverts_on_user_id` (`user_id`)
14) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 DELAY_KEY_WRITE=1;