新版行业分类
#数据库 ucs
CREATE TABLE `tb_company_type_new` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`level` int(11) NOT NULL,
`pid` int(11) NOT NULL DEFAULT '0',
`pids` varchar(64) NOT NULL DEFAULT '',
`rpids` varchar(64) NOT NULL DEFAULT '',
`add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8