TABLE `marka` (
`id` int(10) NOT NULL auto_increment,
`content` text NOT NULL,
`brand_id` int(10) NOT NULL,
`bodytype` text NOT NULL,
`year` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
)





TABLE `odel` (
`id` int(10) NOT NULL auto_increment,
`carname` text NOT NULL,
`brand_id` int(10) NOT NULL,
`content` text NOT NULL,
`marka_id` int(10) NOT NULL,
`year` int(10) NOT NULL,
`color` varchar(20) NOT NULL,
`value` int(10) NOT NULL,
`run` int(10) NOT NULL default '0',
`user_login` varchar(255) NOT NULL,
`descr` text NOT NULL,
`image1` text NOT NULL,
`image2` text NOT NULL,
`image3` text NOT NULL,
`image4` text NOT NULL,
`image5` text NOT NULL,
`bodytype` int(10) NOT NULL,
`kpp` int(10) NOT NULL,
`drive` int(10) NOT NULL,
`state` int(10) NOT NULL,
`power` int(10) NOT NULL,
`typemotor` int(10) NOT NULL,
`wheel` int(10) NOT NULL default '1',
`location` text NOT NULL,
`fio` text NOT NULL,
`tel` text NOT NULL,
`email` varchar(255) NOT NULL,
`price` int(10) NOT NULL,
`date` date NOT NULL,
`ip` varchar(15) NOT NULL,
`time` time NOT NULL,
PRIMARY KEY (`id`)
)