CREATE TABLE `new_buisness_table` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_of_company` varchar(2000) NOT NULL,
`name_of_legal` text NOT NULL,
`trademark` text NOT NULL,
`logo` varchar(2000) NOT NULL,
`photos` text NOT NULL,
`post_addr` text NOT NULL,
`bind_addr_to_map` text NOT NULL,
`site_addr` varchar(2000) NOT NULL,
`phone` text NOT NULL,
`email` text NOT NULL,
`short_descr_activities` text NOT NULL,
`major_production_facilities` text NOT NULL,
`name_of_director` text NOT NULL,
`contact_director` text NOT NULL,
`position_of_director` text NOT NULL,
`name_of_production` text NOT NULL,
`contact_production` text NOT NULL,
`position_of_production` text NOT NULL,
`name_of_press` text NOT NULL,
`contact_press` text NOT NULL,
`position_of_press` text NOT NULL,
`contragents` text NOT NULL,
`type_of_company` varchar(2000) NOT NULL,
`parent_type_of_company` varchar(200) NOT NULL,
`date_reg` datetime DEFAULT NULL,
`locked` int(1) NOT NULL,
`id_cats` varchar(500) NOT NULL,
`id_empl` text NOT NULL,
`count_empl_req` text NOT NULL,
`count_empl_free` text NOT NULL,
`topicality` varchar(400) NOT NULL,
`author` varchar(200) NOT NULL,
`hh_company` int(11) NOT NULL,
`city` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `id_cats` (`id_cats`(333))
) ENGINE=MyISAM AUTO_INCREMENT=1276 DEFAULT CHARSET=utf8