数据库：wiki
表名：tb_edu_intelligence_content
CREATE TABLE `tb_edu_intelligence_content` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`wiki_admin_id` int(11) NOT NULL,
`company_name_digest` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL DEFAULT '''''' COMMENT '名称',
`license` varchar(255) NOT NULL DEFAULT '''''' COMMENT '许可证号',
`address` varchar(255) NOT NULL DEFAULT '''''' COMMENT '地址',
`headmaster` varchar(255) NOT NULL DEFAULT '''''' COMMENT '校长',
`school_type` varchar(255) NOT NULL DEFAULT '''''' COMMENT '学校内容',
`content` varchar(2555) NOT NULL DEFAULT '''''' COMMENT '办学内容',
`competent_department` varchar(255) NOT NULL DEFAULT '''''' COMMENT '主管部门',
`period_validity` varchar(255) NOT NULL DEFAULT '''''' COMMENT '有效期限',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态，1未审核，2审核通过，3审核失败',
`add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `company_name_digest` (`company_name_digest`),
KEY `wiki_admin_id` (`wiki_admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
