6ZPv53bY

1CREATE TABLE IF NOT EXISTS `category` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `title` varchar(255) NOT NULL,
4  PRIMARY KEY (`id`)
5) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10;
6
7CREATE TABLE IF NOT EXISTS `category_typeadverts` (
8  `id` int(11) NOT NULL AUTO_INCREMENT,
9  `id_category` int(11) NOT NULL,
10  `id_type` int(11) NOT NULL,
11  PRIMARY KEY (`id`)
12) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
13
14CREATE TABLE IF NOT EXISTS `type_adverts` (
15  `id` int(11) NOT NULL AUTO_INCREMENT,
16  `type_title` varchar(64) NOT NULL,
17  PRIMARY KEY (`id`)
18) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;