text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : local xmapp
  Source Server Version : 100128
  Source Host           : localhost:3306
  Source Database       : thinkcmf5
  
  Target Server Type    : MYSQL
  Target Server Version : 100128
  File Encoding         : 65001
  
  Date: 2018-06-29 09:29:40
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for cmf_admin_menu
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_admin_menu`;
  CREATE TABLE `cmf_admin_menu` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父菜单id',
    `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '菜单类型;1:有界面可访问菜单,2:无界面可访问菜单,0:只作为菜单',
    `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态;1:显示,0:不显示',
    `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
    `app` varchar(40) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '应用名',
    `controller` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '控制器名',
    `action` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '操作名称',
    `param` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '额外参数',
    `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
    `icon` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '菜单图标',
    `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
    PRIMARY KEY (`id`),
    KEY `status` (`status`),
    KEY `parent_id` (`parent_id`),
    KEY `controller` (`controller`)
  ) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8mb4 COMMENT='后台菜单表';
  
  -- ----------------------------
  -- Records of cmf_admin_menu
  -- ----------------------------
  INSERT INTO `cmf_admin_menu` VALUES ('1', '0', '0', '1', '20', 'admin', 'Plugin', 'default', '', '插件中心', 'cloud', '插件中心');
  INSERT INTO `cmf_admin_menu` VALUES ('2', '1', '1', '1', '10000', 'admin', 'Hook', 'index', '', '钩子管理', '', '钩子管理');
  INSERT INTO `cmf_admin_menu` VALUES ('3', '2', '1', '0', '10000', 'admin', 'Hook', 'plugins', '', '钩子插件管理', '', '钩子插件管理');
  INSERT INTO `cmf_admin_menu` VALUES ('4', '2', '2', '0', '10000', 'admin', 'Hook', 'pluginListOrder', '', '钩子插件排序', '', '钩子插件排序');
  INSERT INTO `cmf_admin_menu` VALUES ('5', '2', '1', '0', '10000', 'admin', 'Hook', 'sync', '', '同步钩子', '', '同步钩子');
  INSERT INTO `cmf_admin_menu` VALUES ('6', '0', '0', '1', '0', 'admin', 'Setting', 'default', '', '设置', 'cogs', '系统设置入口');
  INSERT INTO `cmf_admin_menu` VALUES ('7', '6', '1', '1', '50', 'admin', 'Link', 'index', '', '友情链接', '', '友情链接管理');
  INSERT INTO `cmf_admin_menu` VALUES ('8', '7', '1', '0', '10000', 'admin', 'Link', 'add', '', '添加友情链接', '', '添加友情链接');
  INSERT INTO `cmf_admin_menu` VALUES ('9', '7', '2', '0', '10000', 'admin', 'Link', 'addPost', '', '添加友情链接提交保存', '', '添加友情链接提交保存');
  INSERT INTO `cmf_admin_menu` VALUES ('10', '7', '1', '0', '10000', 'admin', 'Link', 'edit', '', '编辑友情链接', '', '编辑友情链接');
  INSERT INTO `cmf_admin_menu` VALUES ('11', '7', '2', '0', '10000', 'admin', 'Link', 'editPost', '', '编辑友情链接提交保存', '', '编辑友情链接提交保存');
  INSERT INTO `cmf_admin_menu` VALUES ('12', '7', '2', '0', '10000', 'admin', 'Link', 'delete', '', '删除友情链接', '', '删除友情链接');
  INSERT INTO `cmf_admin_menu` VALUES ('13', '7', '2', '0', '10000', 'admin', 'Link', 'listOrder', '', '友情链接排序', '', '友情链接排序');
  INSERT INTO `cmf_admin_menu` VALUES ('14', '7', '2', '0', '10000', 'admin', 'Link', 'toggle', '', '友情链接显示隐藏', '', '友情链接显示隐藏');
  INSERT INTO `cmf_admin_menu` VALUES ('15', '6', '1', '1', '10', 'admin', 'Mailer', 'index', '', '邮箱配置', '', '邮箱配置');
  INSERT INTO `cmf_admin_menu` VALUES ('16', '15', '2', '0', '10000', 'admin', 'Mailer', 'indexPost', '', '邮箱配置提交保存', '', '邮箱配置提交保存');
  INSERT INTO `cmf_admin_menu` VALUES ('17', '15', '1', '0', '10000', 'admin', 'Mailer', 'template', '', '邮件模板', '', '邮件模板');
  INSERT INTO `cmf_admin_menu` VALUES ('18', '15', '2', '0', '10000', 'admin', 'Mailer', 'templatePost', '', '邮件模板提交', '', '邮件模板提交');
  INSERT INTO `cmf_admin_menu` VALUES ('19', '15', '1', '0', '10000', 'admin', 'Mailer', 'test', '', '邮件发送测试', '', '邮件发送测试');
  INSERT INTO `cmf_admin_menu` VALUES ('20', '6', '1', '0', '10000', 'admin', 'Menu', 'index', '', '后台菜单', '', '后台菜单管理');
  INSERT INTO `cmf_admin_menu` VALUES ('21', '20', '1', '0', '10000', 'admin', 'Menu', 'lists', '', '所有菜单', '', '后台所有菜单列表');
  INSERT INTO `cmf_admin_menu` VALUES ('22', '20', '1', '0', '10000', 'admin', 'Menu', 'add', '', '后台菜单添加', '', '后台菜单添加');
  INSERT INTO `cmf_admin_menu` VALUES ('23', '20', '2', '0', '10000', 'admin', 'Menu', 'addPost', '', '后台菜单添加提交保存', '', '后台菜单添加提交保存');
  INSERT INTO `cmf_admin_menu` VALUES ('24', '20', '1', '0', '10000', 'admin', 'Menu', 'edit', '', '后台菜单编辑', '', '后台菜单编辑');
  INSERT INTO `cmf_admin_menu` VALUES ('25', '20', '2', '0', '10000', 'admin', 'Menu', 'editPost', '', '后台菜单编辑提交保存', '', '后台菜单编辑提交保存');
  INSERT INTO `cmf_admin_menu` VALUES ('26', '20', '2', '0', '10000', 'admin', 'Menu', 'delete', '', '后台菜单删除', '', '后台菜单删除');
  INSERT INTO `cmf_admin_menu` VALUES ('27', '20', '2', '0', '10000', 'admin', 'Menu', 'listOrder', '', '后台菜单排序', '', '后台菜单排序');
  INSERT INTO `cmf_admin_menu` VALUES ('28', '20', '1', '0', '10000', 'admin', 'Menu', 'getActions', '', '导入新后台菜单', '', '导入新后台菜单');
  INSERT INTO `cmf_admin_menu` VALUES ('29', '6', '1', '1', '30', 'admin', 'Nav', 'index', '', '导航管理', '', '导航管理');
  INSERT INTO `cmf_admin_menu` VALUES ('30', '29', '1', '0', '10000', 'admin', 'Nav', 'add', '', '添加导航', '', '添加导航');
  INSERT INTO `cmf_admin_menu` VALUES ('31', '29', '2', '0', '10000', 'admin', 'Nav', 'addPost', '', '添加导航提交保存', '', '添加导航提交保存');
  INSERT INTO `cmf_admin_menu` VALUES ('32', '29', '1', '0', '10000', 'admin', 'Nav', 'edit', '', '编辑导航', '', '编辑导航');
  INSERT INTO `cmf_admin_menu` VALUES ('33', '29', '2', '0', '10000', 'admin', 'Nav', 'editPost', '', '编辑导航提交保存', '', '编辑导航提交保存');
  INSERT INTO `cmf_admin_menu` VALUES ('34', '29', '2', '0', '10000', 'admin', 'Nav', 'delete', '', '删除导航', '', '删除导航');
  INSERT INTO `cmf_admin_menu` VALUES ('35', '29', '1', '0', '10000', 'admin', 'NavMenu', 'index', '', '导航菜单', '', '导航菜单');
  INSERT INTO `cmf_admin_menu` VALUES ('36', '35', '1', '0', '10000', 'admin', 'NavMenu', 'add', '', '添加导航菜单', '', '添加导航菜单');
  INSERT INTO `cmf_admin_menu` VALUES ('37', '35', '2', '0', '10000', 'admin', 'NavMenu', 'addPost', '', '添加导航菜单提交保存', '', '添加导航菜单提交保存');
  INSERT INTO `cmf_admin_menu` VALUES ('38', '35', '1', '0', '10000', 'admin', 'NavMenu', 'edit', '', '编辑导航菜单', '', '编辑导航菜单');
  INSERT INTO `cmf_admin_menu` VALUES ('39', '35', '2', '0', '10000', 'admin', 'NavMenu', 'editPost', '', '编辑导航菜单提交保存', '', '编辑导航菜单提交保存');
  INSERT INTO `cmf_admin_menu` VALUES ('40', '35', '2', '0', '10000', 'admin', 'NavMenu', 'delete', '', '删除导航菜单', '', '删除导航菜单');
  INSERT INTO `cmf_admin_menu` VALUES ('41', '35', '2', '0', '10000', 'admin', 'NavMenu', 'listOrder', '', '导航菜单排序', '', '导航菜单排序');
  INSERT INTO `cmf_admin_menu` VALUES ('42', '1', '1', '1', '10000', 'admin', 'Plugin', 'index', '', '插件列表', '', '插件列表');
  INSERT INTO `cmf_admin_menu` VALUES ('43', '42', '2', '0', '10000', 'admin', 'Plugin', 'toggle', '', '插件启用禁用', '', '插件启用禁用');
  INSERT INTO `cmf_admin_menu` VALUES ('44', '42', '1', '0', '10000', 'admin', 'Plugin', 'setting', '', '插件设置', '', '插件设置');
  INSERT INTO `cmf_admin_menu` VALUES ('45', '42', '2', '0', '10000', 'admin', 'Plugin', 'settingPost', '', '插件设置提交', '', '插件设置提交');
  INSERT INTO `cmf_admin_menu` VALUES ('46', '42', '2', '0', '10000', 'admin', 'Plugin', 'install', '', '插件安装', '', '插件安装');
  INSERT INTO `cmf_admin_menu` VALUES ('47', '42', '2', '0', '10000', 'admin', 'Plugin', 'update', '', '插件更新', '', '插件更新');
  INSERT INTO `cmf_admin_menu` VALUES ('48', '42', '2', '0', '10000', 'admin', 'Plugin', 'uninstall', '', '卸载插件', '', '卸载插件');
  INSERT INTO `cmf_admin_menu` VALUES ('49', '109', '0', '1', '10000', 'admin', 'User', 'default', '', '管理组', '', '管理组');
  INSERT INTO `cmf_admin_menu` VALUES ('50', '49', '1', '1', '10000', 'admin', 'Rbac', 'index', '', '角色管理', '', '角色管理');
  INSERT INTO `cmf_admin_menu` VALUES ('51', '50', '1', '0', '10000', 'admin', 'Rbac', 'roleAdd', '', '添加角色', '', '添加角色');
  INSERT INTO `cmf_admin_menu` VALUES ('52', '50', '2', '0', '10000', 'admin', 'Rbac', 'roleAddPost', '', '添加角色提交', '', '添加角色提交');
  INSERT INTO `cmf_admin_menu` VALUES ('53', '50', '1', '0', '10000', 'admin', 'Rbac', 'roleEdit', '', '编辑角色', '', '编辑角色');
  INSERT INTO `cmf_admin_menu` VALUES ('54', '50', '2', '0', '10000', 'admin', 'Rbac', 'roleEditPost', '', '编辑角色提交', '', '编辑角色提交');
  INSERT INTO `cmf_admin_menu` VALUES ('55', '50', '2', '0', '10000', 'admin', 'Rbac', 'roleDelete', '', '删除角色', '', '删除角色');
  INSERT INTO `cmf_admin_menu` VALUES ('56', '50', '1', '0', '10000', 'admin', 'Rbac', 'authorize', '', '设置角色权限', '', '设置角色权限');
  INSERT INTO `cmf_admin_menu` VALUES ('57', '50', '2', '0', '10000', 'admin', 'Rbac', 'authorizePost', '', '角色授权提交', '', '角色授权提交');
  INSERT INTO `cmf_admin_menu` VALUES ('58', '0', '1', '0', '10000', 'admin', 'RecycleBin', 'index', '', '回收站', '', '回收站');
  INSERT INTO `cmf_admin_menu` VALUES ('59', '58', '2', '0', '10000', 'admin', 'RecycleBin', 'restore', '', '回收站还原', '', '回收站还原');
  INSERT INTO `cmf_admin_menu` VALUES ('60', '58', '2', '0', '10000', 'admin', 'RecycleBin', 'delete', '', '回收站彻底删除', '', '回收站彻底删除');
  INSERT INTO `cmf_admin_menu` VALUES ('61', '6', '1', '1', '10000', 'admin', 'Route', 'index', '', 'URL美化', '', 'URL规则管理');
  INSERT INTO `cmf_admin_menu` VALUES ('62', '61', '1', '0', '10000', 'admin', 'Route', 'add', '', '添加路由规则', '', '添加路由规则');
  INSERT INTO `cmf_admin_menu` VALUES ('63', '61', '2', '0', '10000', 'admin', 'Route', 'addPost', '', '添加路由规则提交', '', '添加路由规则提交');
  INSERT INTO `cmf_admin_menu` VALUES ('64', '61', '1', '0', '10000', 'admin', 'Route', 'edit', '', '路由规则编辑', '', '路由规则编辑');
  INSERT INTO `cmf_admin_menu` VALUES ('65', '61', '2', '0', '10000', 'admin', 'Route', 'editPost', '', '路由规则编辑提交', '', '路由规则编辑提交');
  INSERT INTO `cmf_admin_menu` VALUES ('66', '61', '2', '0', '10000', 'admin', 'Route', 'delete', '', '路由规则删除', '', '路由规则删除');
  INSERT INTO `cmf_admin_menu` VALUES ('67', '61', '2', '0', '10000', 'admin', 'Route', 'ban', '', '路由规则禁用', '', '路由规则禁用');
  INSERT INTO `cmf_admin_menu` VALUES ('68', '61', '2', '0', '10000', 'admin', 'Route', 'open', '', '路由规则启用', '', '路由规则启用');
  INSERT INTO `cmf_admin_menu` VALUES ('69', '61', '2', '0', '10000', 'admin', 'Route', 'listOrder', '', '路由规则排序', '', '路由规则排序');
  INSERT INTO `cmf_admin_menu` VALUES ('70', '61', '1', '0', '10000', 'admin', 'Route', 'select', '', '选择URL', '', '选择URL');
  INSERT INTO `cmf_admin_menu` VALUES ('71', '6', '1', '1', '0', 'admin', 'Setting', 'site', '', '网站信息', '', '网站信息');
  INSERT INTO `cmf_admin_menu` VALUES ('72', '71', '2', '0', '10000', 'admin', 'Setting', 'sitePost', '', '网站信息设置提交', '', '网站信息设置提交');
  INSERT INTO `cmf_admin_menu` VALUES ('73', '6', '1', '0', '10000', 'admin', 'Setting', 'password', '', '密码修改', '', '密码修改');
  INSERT INTO `cmf_admin_menu` VALUES ('74', '73', '2', '0', '10000', 'admin', 'Setting', 'passwordPost', '', '密码修改提交', '', '密码修改提交');
  INSERT INTO `cmf_admin_menu` VALUES ('75', '6', '1', '1', '10000', 'admin', 'Setting', 'upload', '', '上传设置', '', '上传设置');
  INSERT INTO `cmf_admin_menu` VALUES ('76', '75', '2', '0', '10000', 'admin', 'Setting', 'uploadPost', '', '上传设置提交', '', '上传设置提交');
  INSERT INTO `cmf_admin_menu` VALUES ('77', '6', '1', '0', '10000', 'admin', 'Setting', 'clearCache', '', '清除缓存', '', '清除缓存');
  INSERT INTO `cmf_admin_menu` VALUES ('78', '6', '1', '1', '40', 'admin', 'Slide', 'index', '', '幻灯片管理', '', '幻灯片管理');
  INSERT INTO `cmf_admin_menu` VALUES ('79', '78', '1', '0', '10000', 'admin', 'Slide', 'add', '', '添加幻灯片', '', '添加幻灯片');
  INSERT INTO `cmf_admin_menu` VALUES ('80', '78', '2', '0', '10000', 'admin', 'Slide', 'addPost', '', '添加幻灯片提交', '', '添加幻灯片提交');
  INSERT INTO `cmf_admin_menu` VALUES ('81', '78', '1', '0', '10000', 'admin', 'Slide', 'edit', '', '编辑幻灯片', '', '编辑幻灯片');
  INSERT INTO `cmf_admin_menu` VALUES ('82', '78', '2', '0', '10000', 'admin', 'Slide', 'editPost', '', '编辑幻灯片提交', '', '编辑幻灯片提交');
  INSERT INTO `cmf_admin_menu` VALUES ('83', '78', '2', '0', '10000', 'admin', 'Slide', 'delete', '', '删除幻灯片', '', '删除幻灯片');
  INSERT INTO `cmf_admin_menu` VALUES ('84', '78', '1', '0', '10000', 'admin', 'SlideItem', 'index', '', '幻灯片页面列表', '', '幻灯片页面列表');
  INSERT INTO `cmf_admin_menu` VALUES ('85', '84', '1', '0', '10000', 'admin', 'SlideItem', 'add', '', '幻灯片页面添加', '', '幻灯片页面添加');
  INSERT INTO `cmf_admin_menu` VALUES ('86', '84', '2', '0', '10000', 'admin', 'SlideItem', 'addPost', '', '幻灯片页面添加提交', '', '幻灯片页面添加提交');
  INSERT INTO `cmf_admin_menu` VALUES ('87', '84', '1', '0', '10000', 'admin', 'SlideItem', 'edit', '', '幻灯片页面编辑', '', '幻灯片页面编辑');
  INSERT INTO `cmf_admin_menu` VALUES ('88', '84', '2', '0', '10000', 'admin', 'SlideItem', 'editPost', '', '幻灯片页面编辑提交', '', '幻灯片页面编辑提交');
  INSERT INTO `cmf_admin_menu` VALUES ('89', '84', '2', '0', '10000', 'admin', 'SlideItem', 'delete', '', '幻灯片页面删除', '', '幻灯片页面删除');
  INSERT INTO `cmf_admin_menu` VALUES ('90', '84', '2', '0', '10000', 'admin', 'SlideItem', 'ban', '', '幻灯片页面隐藏', '', '幻灯片页面隐藏');
  INSERT INTO `cmf_admin_menu` VALUES ('91', '84', '2', '0', '10000', 'admin', 'SlideItem', 'cancelBan', '', '幻灯片页面显示', '', '幻灯片页面显示');
  INSERT INTO `cmf_admin_menu` VALUES ('92', '84', '2', '0', '10000', 'admin', 'SlideItem', 'listOrder', '', '幻灯片页面排序', '', '幻灯片页面排序');
  INSERT INTO `cmf_admin_menu` VALUES ('93', '6', '1', '1', '10000', 'admin', 'Storage', 'index', '', '文件存储', '', '文件存储');
  INSERT INTO `cmf_admin_menu` VALUES ('94', '93', '2', '0', '10000', 'admin', 'Storage', 'settingPost', '', '文件存储设置提交', '', '文件存储设置提交');
  INSERT INTO `cmf_admin_menu` VALUES ('95', '6', '1', '1', '20', 'admin', 'Theme', 'index', '', '模板管理', '', '模板管理');
  INSERT INTO `cmf_admin_menu` VALUES ('96', '95', '1', '0', '10000', 'admin', 'Theme', 'install', '', '安装模板', '', '安装模板');
  INSERT INTO `cmf_admin_menu` VALUES ('97', '95', '2', '0', '10000', 'admin', 'Theme', 'uninstall', '', '卸载模板', '', '卸载模板');
  INSERT INTO `cmf_admin_menu` VALUES ('98', '95', '2', '0', '10000', 'admin', 'Theme', 'installTheme', '', '模板安装', '', '模板安装');
  INSERT INTO `cmf_admin_menu` VALUES ('99', '95', '2', '0', '10000', 'admin', 'Theme', 'update', '', '模板更新', '', '模板更新');
  INSERT INTO `cmf_admin_menu` VALUES ('100', '95', '2', '0', '10000', 'admin', 'Theme', 'active', '', '启用模板', '', '启用模板');
  INSERT INTO `cmf_admin_menu` VALUES ('101', '95', '1', '0', '10000', 'admin', 'Theme', 'files', '', '模板文件列表', '', '启用模板');
  INSERT INTO `cmf_admin_menu` VALUES ('102', '95', '1', '0', '10000', 'admin', 'Theme', 'fileSetting', '', '模板文件设置', '', '模板文件设置');
  INSERT INTO `cmf_admin_menu` VALUES ('103', '95', '1', '0', '10000', 'admin', 'Theme', 'fileArrayData', '', '模板文件数组数据列表', '', '模板文件数组数据列表');
  INSERT INTO `cmf_admin_menu` VALUES ('104', '95', '2', '0', '10000', 'admin', 'Theme', 'fileArrayDataEdit', '', '模板文件数组数据添加编辑', '', '模板文件数组数据添加编辑');
  INSERT INTO `cmf_admin_menu` VALUES ('105', '95', '2', '0', '10000', 'admin', 'Theme', 'fileArrayDataEditPost', '', '模板文件数组数据添加编辑提交保存', '', '模板文件数组数据添加编辑提交保存');
  INSERT INTO `cmf_admin_menu` VALUES ('106', '95', '2', '0', '10000', 'admin', 'Theme', 'fileArrayDataDelete', '', '模板文件数组数据删除', '', '模板文件数组数据删除');
  INSERT INTO `cmf_admin_menu` VALUES ('107', '95', '2', '0', '10000', 'admin', 'Theme', 'settingPost', '', '模板文件编辑提交保存', '', '模板文件编辑提交保存');
  INSERT INTO `cmf_admin_menu` VALUES ('108', '95', '1', '0', '10000', 'admin', 'Theme', 'dataSource', '', '模板文件设置数据源', '', '模板文件设置数据源');
  INSERT INTO `cmf_admin_menu` VALUES ('109', '0', '0', '1', '10', 'user', 'AdminIndex', 'default', '', '用户管理', 'group', '用户管理');
  INSERT INTO `cmf_admin_menu` VALUES ('110', '49', '1', '1', '10000', 'admin', 'User', 'index', '', '管理员', '', '管理员管理');
  INSERT INTO `cmf_admin_menu` VALUES ('111', '110', '1', '0', '10000', 'admin', 'User', 'add', '', '管理员添加', '', '管理员添加');
  INSERT INTO `cmf_admin_menu` VALUES ('112', '110', '2', '0', '10000', 'admin', 'User', 'addPost', '', '管理员添加提交', '', '管理员添加提交');
  INSERT INTO `cmf_admin_menu` VALUES ('113', '110', '1', '0', '10000', 'admin', 'User', 'edit', '', '管理员编辑', '', '管理员编辑');
  INSERT INTO `cmf_admin_menu` VALUES ('114', '110', '2', '0', '10000', 'admin', 'User', 'editPost', '', '管理员编辑提交', '', '管理员编辑提交');
  INSERT INTO `cmf_admin_menu` VALUES ('115', '110', '1', '0', '10000', 'admin', 'User', 'userInfo', '', '个人信息', '', '管理员个人信息修改');
  INSERT INTO `cmf_admin_menu` VALUES ('116', '110', '2', '0', '10000', 'admin', 'User', 'userInfoPost', '', '管理员个人信息修改提交', '', '管理员个人信息修改提交');
  INSERT INTO `cmf_admin_menu` VALUES ('117', '110', '2', '0', '10000', 'admin', 'User', 'delete', '', '管理员删除', '', '管理员删除');
  INSERT INTO `cmf_admin_menu` VALUES ('118', '110', '2', '0', '10000', 'admin', 'User', 'ban', '', '停用管理员', '', '停用管理员');
  INSERT INTO `cmf_admin_menu` VALUES ('119', '110', '2', '0', '10000', 'admin', 'User', 'cancelBan', '', '启用管理员', '', '启用管理员');
  INSERT INTO `cmf_admin_menu` VALUES ('120', '0', '0', '1', '30', 'portal', 'AdminIndex', 'default', '', '门户管理', 'th', '门户管理');
  INSERT INTO `cmf_admin_menu` VALUES ('121', '120', '1', '1', '10000', 'portal', 'AdminArticle', 'index', '', '文章管理', '', '文章列表');
  INSERT INTO `cmf_admin_menu` VALUES ('122', '121', '1', '0', '10000', 'portal', 'AdminArticle', 'add', '', '添加文章', '', '添加文章');
  INSERT INTO `cmf_admin_menu` VALUES ('123', '121', '2', '0', '10000', 'portal', 'AdminArticle', 'addPost', '', '添加文章提交', '', '添加文章提交');
  INSERT INTO `cmf_admin_menu` VALUES ('124', '121', '1', '0', '10000', 'portal', 'AdminArticle', 'edit', '', '编辑文章', '', '编辑文章');
  INSERT INTO `cmf_admin_menu` VALUES ('125', '121', '2', '0', '10000', 'portal', 'AdminArticle', 'editPost', '', '编辑文章提交', '', '编辑文章提交');
  INSERT INTO `cmf_admin_menu` VALUES ('126', '121', '2', '0', '10000', 'portal', 'AdminArticle', 'delete', '', '文章删除', '', '文章删除');
  INSERT INTO `cmf_admin_menu` VALUES ('127', '121', '2', '0', '10000', 'portal', 'AdminArticle', 'publish', '', '文章发布', '', '文章发布');
  INSERT INTO `cmf_admin_menu` VALUES ('128', '121', '2', '0', '10000', 'portal', 'AdminArticle', 'top', '', '文章置顶', '', '文章置顶');
  INSERT INTO `cmf_admin_menu` VALUES ('129', '121', '2', '0', '10000', 'portal', 'AdminArticle', 'recommend', '', '文章推荐', '', '文章推荐');
  INSERT INTO `cmf_admin_menu` VALUES ('130', '121', '2', '0', '10000', 'portal', 'AdminArticle', 'listOrder', '', '文章排序', '', '文章排序');
  INSERT INTO `cmf_admin_menu` VALUES ('131', '120', '1', '1', '10000', 'portal', 'AdminCategory', 'index', '', '分类管理', '', '文章分类列表');
  INSERT INTO `cmf_admin_menu` VALUES ('132', '131', '1', '0', '10000', 'portal', 'AdminCategory', 'add', '', '添加文章分类', '', '添加文章分类');
  INSERT INTO `cmf_admin_menu` VALUES ('133', '131', '2', '0', '10000', 'portal', 'AdminCategory', 'addPost', '', '添加文章分类提交', '', '添加文章分类提交');
  INSERT INTO `cmf_admin_menu` VALUES ('134', '131', '1', '0', '10000', 'portal', 'AdminCategory', 'edit', '', '编辑文章分类', '', '编辑文章分类');
  INSERT INTO `cmf_admin_menu` VALUES ('135', '131', '2', '0', '10000', 'portal', 'AdminCategory', 'editPost', '', '编辑文章分类提交', '', '编辑文章分类提交');
  INSERT INTO `cmf_admin_menu` VALUES ('136', '131', '1', '0', '10000', 'portal', 'AdminCategory', 'select', '', '文章分类选择对话框', '', '文章分类选择对话框');
  INSERT INTO `cmf_admin_menu` VALUES ('137', '131', '2', '0', '10000', 'portal', 'AdminCategory', 'listOrder', '', '文章分类排序', '', '文章分类排序');
  INSERT INTO `cmf_admin_menu` VALUES ('138', '131', '2', '0', '10000', 'portal', 'AdminCategory', 'delete', '', '删除文章分类', '', '删除文章分类');
  INSERT INTO `cmf_admin_menu` VALUES ('139', '120', '1', '1', '10000', 'portal', 'AdminPage', 'index', '', '页面管理', '', '页面管理');
  INSERT INTO `cmf_admin_menu` VALUES ('140', '139', '1', '0', '10000', 'portal', 'AdminPage', 'add', '', '添加页面', '', '添加页面');
  INSERT INTO `cmf_admin_menu` VALUES ('141', '139', '2', '0', '10000', 'portal', 'AdminPage', 'addPost', '', '添加页面提交', '', '添加页面提交');
  INSERT INTO `cmf_admin_menu` VALUES ('142', '139', '1', '0', '10000', 'portal', 'AdminPage', 'edit', '', '编辑页面', '', '编辑页面');
  INSERT INTO `cmf_admin_menu` VALUES ('143', '139', '2', '0', '10000', 'portal', 'AdminPage', 'editPost', '', '编辑页面提交', '', '编辑页面提交');
  INSERT INTO `cmf_admin_menu` VALUES ('144', '139', '2', '0', '10000', 'portal', 'AdminPage', 'delete', '', '删除页面', '', '删除页面');
  INSERT INTO `cmf_admin_menu` VALUES ('145', '120', '1', '1', '10000', 'portal', 'AdminTag', 'index', '', '文章标签', '', '文章标签');
  INSERT INTO `cmf_admin_menu` VALUES ('146', '145', '1', '0', '10000', 'portal', 'AdminTag', 'add', '', '添加文章标签', '', '添加文章标签');
  INSERT INTO `cmf_admin_menu` VALUES ('147', '145', '2', '0', '10000', 'portal', 'AdminTag', 'addPost', '', '添加文章标签提交', '', '添加文章标签提交');
  INSERT INTO `cmf_admin_menu` VALUES ('148', '145', '2', '0', '10000', 'portal', 'AdminTag', 'upStatus', '', '更新标签状态', '', '更新标签状态');
  INSERT INTO `cmf_admin_menu` VALUES ('149', '145', '2', '0', '10000', 'portal', 'AdminTag', 'delete', '', '删除文章标签', '', '删除文章标签');
  INSERT INTO `cmf_admin_menu` VALUES ('150', '0', '1', '0', '10000', 'user', 'AdminAsset', 'index', '', '资源管理', 'file', '资源管理列表');
  INSERT INTO `cmf_admin_menu` VALUES ('151', '150', '2', '0', '10000', 'user', 'AdminAsset', 'delete', '', '删除文件', '', '删除文件');
  INSERT INTO `cmf_admin_menu` VALUES ('152', '109', '0', '1', '10000', 'user', 'AdminIndex', 'default1', '', '用户组', '', '用户组');
  INSERT INTO `cmf_admin_menu` VALUES ('153', '152', '1', '1', '10000', 'user', 'AdminIndex', 'index', '', '本站用户', '', '本站用户');
  INSERT INTO `cmf_admin_menu` VALUES ('154', '153', '2', '0', '10000', 'user', 'AdminIndex', 'ban', '', '本站用户拉黑', '', '本站用户拉黑');
  INSERT INTO `cmf_admin_menu` VALUES ('155', '153', '2', '0', '10000', 'user', 'AdminIndex', 'cancelBan', '', '本站用户启用', '', '本站用户启用');
  INSERT INTO `cmf_admin_menu` VALUES ('156', '152', '1', '1', '10000', 'user', 'AdminOauth', 'index', '', '第三方用户', '', '第三方用户');
  INSERT INTO `cmf_admin_menu` VALUES ('157', '156', '2', '0', '10000', 'user', 'AdminOauth', 'delete', '', '删除第三方用户绑定', '', '删除第三方用户绑定');
  INSERT INTO `cmf_admin_menu` VALUES ('158', '6', '1', '1', '10000', 'user', 'AdminUserAction', 'index', '', '用户操作管理', '', '用户操作管理');
  INSERT INTO `cmf_admin_menu` VALUES ('159', '158', '1', '0', '10000', 'user', 'AdminUserAction', 'edit', '', '编辑用户操作', '', '编辑用户操作');
  INSERT INTO `cmf_admin_menu` VALUES ('160', '158', '2', '0', '10000', 'user', 'AdminUserAction', 'editPost', '', '编辑用户操作提交', '', '编辑用户操作提交');
  INSERT INTO `cmf_admin_menu` VALUES ('161', '158', '1', '0', '10000', 'user', 'AdminUserAction', 'sync', '', '同步用户操作', '', '同步用户操作');
  
  -- ----------------------------
  -- Table structure for cmf_asset
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_asset`;
  CREATE TABLE `cmf_asset` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
    `file_size` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小,单位B',
    `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上传时间',
    `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:可用,0:不可用',
    `download_times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '下载次数',
    `file_key` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '文件惟一码',
    `filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件名',
    `file_path` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '文件路径,相对于upload目录,可以为url',
    `file_md5` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '文件md5值',
    `file_sha1` varchar(40) CHARACTER SET utf8 NOT NULL DEFAULT '',
    `suffix` varchar(10) NOT NULL DEFAULT '' COMMENT '文件后缀名,不包括点',
    `more` text COMMENT '其它详细信息,JSON格式',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COMMENT='资源表';
  
  -- ----------------------------
  -- Records of cmf_asset
  -- ----------------------------
  INSERT INTO `cmf_asset` VALUES ('29', '1', '703462', '1529895337', '1', '0', '95580ec6bfd8ed629d2123ddaf0dfd3da0137702f9c59dce9b75f182e32bfad6', 'banner1.png', 'admin/20180625/4a98790eaf5fe1e32cfe9cb4924ca21e.png', '95580ec6bfd8ed629d2123ddaf0dfd3d', '0649e770ac5d51440fae0a8e1814195a242b58d4', 'png', null);
  INSERT INTO `cmf_asset` VALUES ('30', '1', '2760', '1529898058', '1', '0', '8927e472fef075c8e71e1e72ab621c9c9c58ea58f7556416cbee6d119f881077', 'XL.png', 'default/20180625/9a5c7963529023a88fedeb0a00a7c275.png', '8927e472fef075c8e71e1e72ab621c9c', '33c29cd54c9c9d1cafc75b2c31d603fa6eaa3dc9', 'png', null);
  INSERT INTO `cmf_asset` VALUES ('31', '1', '26020', '1529910833', '1', '0', 'babb252b4b0d50ef1394b550d5f1e18801a065ef320a321f88c83f5641c62266', 't1.png', 'portal/20180625/fc1bd2bcd91e8c32ede0ce68c41a8211.png', 'babb252b4b0d50ef1394b550d5f1e188', 'df7d2c2cc78344f905b77b6be862ce2cee36a07c', 'png', null);
  INSERT INTO `cmf_asset` VALUES ('32', '1', '530088', '1529975375', '1', '0', 'cf17107b085cbd627e87468cda8fc47a8640a57fa8ea9f46e9f4ba697ad095bd', '豆芽之家贴纸10X10c绿色.png', 'default/20180626/3a4f840ccda82d146fd6fbe197d5a1c3.png', 'cf17107b085cbd627e87468cda8fc47a', '8c12c3215dcfde67f69e9ddb3d3e305e9fd61ca1', 'png', null);
  INSERT INTO `cmf_asset` VALUES ('33', '1', '433458', '1529977928', '1', '0', '666e97c412d59c6e6cc4bc82bd0fee481793ca68ed67875a2d914d9b397e8d17', '空调清洗.jpg', 'default/20180626/6a3b32461e6e06da48a4350cb86c4305.jpg', '666e97c412d59c6e6cc4bc82bd0fee48', 'e8a6ddae465d5271142f15c4b97e1d26b737ac17', 'jpg', null);
  INSERT INTO `cmf_asset` VALUES ('34', '1', '4389', '1529980301', '1', '0', '931fbd764706ddb7aea1dfe32e8022910651f1a5fdc49bbb8ae77b84c318d532', 'XL.png', 'default/20180626/df7a61ff3d31e3ae3ac057bdbb884483.png', '931fbd764706ddb7aea1dfe32e802291', 'b7c806224b918b0c9159cb7223c35706e13b2a04', 'png', null);
  INSERT INTO `cmf_asset` VALUES ('35', '1', '2874', '1529997382', '1', '0', '4c4984bb8baafda5ddae92728191fd9cafdf88c87f0ee8d1691cab08afd3ab64', 'YG.jpg', 'default/20180626/71bf4f7c975e9a8de4199610682c5319.jpg', '4c4984bb8baafda5ddae92728191fd9c', 'e1fb8b767c3c78b1a643cdd99213f198ebc0c7b0', 'jpg', null);
  INSERT INTO `cmf_asset` VALUES ('37', '1', '23275', '1530005322', '1', '0', '810aa8bda1f3411e25f8763fe675c4e6e54f1cf20168d992a42390b39811d8b4', 'qywh.png', 'default/20180626/8335f024cd3367ee9a6702bfb9d13b26.png', '810aa8bda1f3411e25f8763fe675c4e6', '0f2f1ef6bba02bb9a8c72269ef97121f7a22fac4', 'png', null);
  INSERT INTO `cmf_asset` VALUES ('42', '1', '54943', '1530152775', '1', '0', '8bd121709883e73b2b9e859eeba7cc7590a336c138ec648d5d219ad35ff9d460', '025.jpg', 'default/20180628/d987d596e56de5d27e266e94b89173d4.jpg', '8bd121709883e73b2b9e859eeba7cc75', '4a4a788c56ed4657c3b4c570efc556d40e4e9840', 'jpg', null);
  INSERT INTO `cmf_asset` VALUES ('43', '1', '5440', '1530152899', '1', '0', '224808e1cb5a7b185e535d9324aa6dd0a1af7cf8f8658e7c5f07b57299f53600', '026.jpg', 'default/20180628/a8a8f743c29a81c614ab86b13fb644bc.jpg', '224808e1cb5a7b185e535d9324aa6dd0', 'ab7308aaa38570437305e4b1e7e797c8c71af777', 'jpg', null);
  INSERT INTO `cmf_asset` VALUES ('44', '1', '200189', '1530173927', '1', '0', '2062e3afb5352e29eec04cf21700e2f4a123112c2c8267b500defbfbabbce301', '2.jpg', 'admin/20180628/9019d07f17ec6831b26d361c11be12e0.jpg', '2062e3afb5352e29eec04cf21700e2f4', '85d4c38b75ea4b70b13f3dda31c69ed7d4d502d4', 'jpg', null);
  INSERT INTO `cmf_asset` VALUES ('45', '1', '3484583', '1530233314', '1', '0', '1afaad2967c827ce7b7d74aa183440ae5b824fb3e374af2369b6035c829ba035', '20180420103224.jpg', 'admin/20180629/2368a5d8d38448b0e4b3d91adc657c37.jpg', '1afaad2967c827ce7b7d74aa183440ae', 'caf09afb6f821886d66d77c9c556e7d3ed3938d4', 'jpg', null);
  INSERT INTO `cmf_asset` VALUES ('46', '1', '23230', '1530233690', '1', '0', '52017523f68e7e697fd7155414b40b63129b19d2d190c380d4a612b76dd8dd52', 'eft.png', 'admin/20180629/f68b0e4b0633890a4a69c78c9709069d.png', '52017523f68e7e697fd7155414b40b63', '90ff252fb6fc35ea5e80da0129714086a61f8d06', 'png', null);
  
  -- ----------------------------
  -- Table structure for cmf_auth_access
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_auth_access`;
  CREATE TABLE `cmf_auth_access` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `role_id` int(10) unsigned NOT NULL COMMENT '角色',
    `rule_name` varchar(100) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识,全小写',
    `type` varchar(30) NOT NULL DEFAULT '' COMMENT '权限规则分类,请加应用前缀,如admin_',
    PRIMARY KEY (`id`),
    KEY `role_id` (`role_id`),
    KEY `rule_name` (`rule_name`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限授权表';
  
  -- ----------------------------
  -- Records of cmf_auth_access
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cmf_auth_rule
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_auth_rule`;
  CREATE TABLE `cmf_auth_rule` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键',
    `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否有效(0:无效,1:有效)',
    `app` varchar(15) NOT NULL COMMENT '规则所属module',
    `type` varchar(30) NOT NULL DEFAULT '' COMMENT '权限规则分类，请加应用前缀,如admin_',
    `name` varchar(100) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识,全小写',
    `param` varchar(100) NOT NULL DEFAULT '' COMMENT '额外url参数',
    `title` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规则描述',
    `condition` varchar(200) NOT NULL DEFAULT '' COMMENT '规则附加条件',
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`) USING BTREE,
    KEY `module` (`app`,`status`,`type`)
  ) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8mb4 COMMENT='权限规则表';
  
  -- ----------------------------
  -- Records of cmf_auth_rule
  -- ----------------------------
  INSERT INTO `cmf_auth_rule` VALUES ('1', '1', 'admin', 'admin_url', 'admin/Hook/index', '', '钩子管理', '');
  INSERT INTO `cmf_auth_rule` VALUES ('2', '1', 'admin', 'admin_url', 'admin/Hook/plugins', '', '钩子插件管理', '');
  INSERT INTO `cmf_auth_rule` VALUES ('3', '1', 'admin', 'admin_url', 'admin/Hook/pluginListOrder', '', '钩子插件排序', '');
  INSERT INTO `cmf_auth_rule` VALUES ('4', '1', 'admin', 'admin_url', 'admin/Hook/sync', '', '同步钩子', '');
  INSERT INTO `cmf_auth_rule` VALUES ('5', '1', 'admin', 'admin_url', 'admin/Link/index', '', '友情链接', '');
  INSERT INTO `cmf_auth_rule` VALUES ('6', '1', 'admin', 'admin_url', 'admin/Link/add', '', '添加友情链接', '');
  INSERT INTO `cmf_auth_rule` VALUES ('7', '1', 'admin', 'admin_url', 'admin/Link/addPost', '', '添加友情链接提交保存', '');
  INSERT INTO `cmf_auth_rule` VALUES ('8', '1', 'admin', 'admin_url', 'admin/Link/edit', '', '编辑友情链接', '');
  INSERT INTO `cmf_auth_rule` VALUES ('9', '1', 'admin', 'admin_url', 'admin/Link/editPost', '', '编辑友情链接提交保存', '');
  INSERT INTO `cmf_auth_rule` VALUES ('10', '1', 'admin', 'admin_url', 'admin/Link/delete', '', '删除友情链接', '');
  INSERT INTO `cmf_auth_rule` VALUES ('11', '1', 'admin', 'admin_url', 'admin/Link/listOrder', '', '友情链接排序', '');
  INSERT INTO `cmf_auth_rule` VALUES ('12', '1', 'admin', 'admin_url', 'admin/Link/toggle', '', '友情链接显示隐藏', '');
  INSERT INTO `cmf_auth_rule` VALUES ('13', '1', 'admin', 'admin_url', 'admin/Mailer/index', '', '邮箱配置', '');
  INSERT INTO `cmf_auth_rule` VALUES ('14', '1', 'admin', 'admin_url', 'admin/Mailer/indexPost', '', '邮箱配置提交保存', '');
  INSERT INTO `cmf_auth_rule` VALUES ('15', '1', 'admin', 'admin_url', 'admin/Mailer/template', '', '邮件模板', '');
  INSERT INTO `cmf_auth_rule` VALUES ('16', '1', 'admin', 'admin_url', 'admin/Mailer/templatePost', '', '邮件模板提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('17', '1', 'admin', 'admin_url', 'admin/Mailer/test', '', '邮件发送测试', '');
  INSERT INTO `cmf_auth_rule` VALUES ('18', '1', 'admin', 'admin_url', 'admin/Menu/index', '', '后台菜单', '');
  INSERT INTO `cmf_auth_rule` VALUES ('19', '1', 'admin', 'admin_url', 'admin/Menu/lists', '', '所有菜单', '');
  INSERT INTO `cmf_auth_rule` VALUES ('20', '1', 'admin', 'admin_url', 'admin/Menu/add', '', '后台菜单添加', '');
  INSERT INTO `cmf_auth_rule` VALUES ('21', '1', 'admin', 'admin_url', 'admin/Menu/addPost', '', '后台菜单添加提交保存', '');
  INSERT INTO `cmf_auth_rule` VALUES ('22', '1', 'admin', 'admin_url', 'admin/Menu/edit', '', '后台菜单编辑', '');
  INSERT INTO `cmf_auth_rule` VALUES ('23', '1', 'admin', 'admin_url', 'admin/Menu/editPost', '', '后台菜单编辑提交保存', '');
  INSERT INTO `cmf_auth_rule` VALUES ('24', '1', 'admin', 'admin_url', 'admin/Menu/delete', '', '后台菜单删除', '');
  INSERT INTO `cmf_auth_rule` VALUES ('25', '1', 'admin', 'admin_url', 'admin/Menu/listOrder', '', '后台菜单排序', '');
  INSERT INTO `cmf_auth_rule` VALUES ('26', '1', 'admin', 'admin_url', 'admin/Menu/getActions', '', '导入新后台菜单', '');
  INSERT INTO `cmf_auth_rule` VALUES ('27', '1', 'admin', 'admin_url', 'admin/Nav/index', '', '导航管理', '');
  INSERT INTO `cmf_auth_rule` VALUES ('28', '1', 'admin', 'admin_url', 'admin/Nav/add', '', '添加导航', '');
  INSERT INTO `cmf_auth_rule` VALUES ('29', '1', 'admin', 'admin_url', 'admin/Nav/addPost', '', '添加导航提交保存', '');
  INSERT INTO `cmf_auth_rule` VALUES ('30', '1', 'admin', 'admin_url', 'admin/Nav/edit', '', '编辑导航', '');
  INSERT INTO `cmf_auth_rule` VALUES ('31', '1', 'admin', 'admin_url', 'admin/Nav/editPost', '', '编辑导航提交保存', '');
  INSERT INTO `cmf_auth_rule` VALUES ('32', '1', 'admin', 'admin_url', 'admin/Nav/delete', '', '删除导航', '');
  INSERT INTO `cmf_auth_rule` VALUES ('33', '1', 'admin', 'admin_url', 'admin/NavMenu/index', '', '导航菜单', '');
  INSERT INTO `cmf_auth_rule` VALUES ('34', '1', 'admin', 'admin_url', 'admin/NavMenu/add', '', '添加导航菜单', '');
  INSERT INTO `cmf_auth_rule` VALUES ('35', '1', 'admin', 'admin_url', 'admin/NavMenu/addPost', '', '添加导航菜单提交保存', '');
  INSERT INTO `cmf_auth_rule` VALUES ('36', '1', 'admin', 'admin_url', 'admin/NavMenu/edit', '', '编辑导航菜单', '');
  INSERT INTO `cmf_auth_rule` VALUES ('37', '1', 'admin', 'admin_url', 'admin/NavMenu/editPost', '', '编辑导航菜单提交保存', '');
  INSERT INTO `cmf_auth_rule` VALUES ('38', '1', 'admin', 'admin_url', 'admin/NavMenu/delete', '', '删除导航菜单', '');
  INSERT INTO `cmf_auth_rule` VALUES ('39', '1', 'admin', 'admin_url', 'admin/NavMenu/listOrder', '', '导航菜单排序', '');
  INSERT INTO `cmf_auth_rule` VALUES ('40', '1', 'admin', 'admin_url', 'admin/Plugin/default', '', '插件中心', '');
  INSERT INTO `cmf_auth_rule` VALUES ('41', '1', 'admin', 'admin_url', 'admin/Plugin/index', '', '插件列表', '');
  INSERT INTO `cmf_auth_rule` VALUES ('42', '1', 'admin', 'admin_url', 'admin/Plugin/toggle', '', '插件启用禁用', '');
  INSERT INTO `cmf_auth_rule` VALUES ('43', '1', 'admin', 'admin_url', 'admin/Plugin/setting', '', '插件设置', '');
  INSERT INTO `cmf_auth_rule` VALUES ('44', '1', 'admin', 'admin_url', 'admin/Plugin/settingPost', '', '插件设置提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('45', '1', 'admin', 'admin_url', 'admin/Plugin/install', '', '插件安装', '');
  INSERT INTO `cmf_auth_rule` VALUES ('46', '1', 'admin', 'admin_url', 'admin/Plugin/update', '', '插件更新', '');
  INSERT INTO `cmf_auth_rule` VALUES ('47', '1', 'admin', 'admin_url', 'admin/Plugin/uninstall', '', '卸载插件', '');
  INSERT INTO `cmf_auth_rule` VALUES ('48', '1', 'admin', 'admin_url', 'admin/Rbac/index', '', '角色管理', '');
  INSERT INTO `cmf_auth_rule` VALUES ('49', '1', 'admin', 'admin_url', 'admin/Rbac/roleAdd', '', '添加角色', '');
  INSERT INTO `cmf_auth_rule` VALUES ('50', '1', 'admin', 'admin_url', 'admin/Rbac/roleAddPost', '', '添加角色提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('51', '1', 'admin', 'admin_url', 'admin/Rbac/roleEdit', '', '编辑角色', '');
  INSERT INTO `cmf_auth_rule` VALUES ('52', '1', 'admin', 'admin_url', 'admin/Rbac/roleEditPost', '', '编辑角色提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('53', '1', 'admin', 'admin_url', 'admin/Rbac/roleDelete', '', '删除角色', '');
  INSERT INTO `cmf_auth_rule` VALUES ('54', '1', 'admin', 'admin_url', 'admin/Rbac/authorize', '', '设置角色权限', '');
  INSERT INTO `cmf_auth_rule` VALUES ('55', '1', 'admin', 'admin_url', 'admin/Rbac/authorizePost', '', '角色授权提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('56', '1', 'admin', 'admin_url', 'admin/RecycleBin/index', '', '回收站', '');
  INSERT INTO `cmf_auth_rule` VALUES ('57', '1', 'admin', 'admin_url', 'admin/RecycleBin/restore', '', '回收站还原', '');
  INSERT INTO `cmf_auth_rule` VALUES ('58', '1', 'admin', 'admin_url', 'admin/RecycleBin/delete', '', '回收站彻底删除', '');
  INSERT INTO `cmf_auth_rule` VALUES ('59', '1', 'admin', 'admin_url', 'admin/Route/index', '', 'URL美化', '');
  INSERT INTO `cmf_auth_rule` VALUES ('60', '1', 'admin', 'admin_url', 'admin/Route/add', '', '添加路由规则', '');
  INSERT INTO `cmf_auth_rule` VALUES ('61', '1', 'admin', 'admin_url', 'admin/Route/addPost', '', '添加路由规则提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('62', '1', 'admin', 'admin_url', 'admin/Route/edit', '', '路由规则编辑', '');
  INSERT INTO `cmf_auth_rule` VALUES ('63', '1', 'admin', 'admin_url', 'admin/Route/editPost', '', '路由规则编辑提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('64', '1', 'admin', 'admin_url', 'admin/Route/delete', '', '路由规则删除', '');
  INSERT INTO `cmf_auth_rule` VALUES ('65', '1', 'admin', 'admin_url', 'admin/Route/ban', '', '路由规则禁用', '');
  INSERT INTO `cmf_auth_rule` VALUES ('66', '1', 'admin', 'admin_url', 'admin/Route/open', '', '路由规则启用', '');
  INSERT INTO `cmf_auth_rule` VALUES ('67', '1', 'admin', 'admin_url', 'admin/Route/listOrder', '', '路由规则排序', '');
  INSERT INTO `cmf_auth_rule` VALUES ('68', '1', 'admin', 'admin_url', 'admin/Route/select', '', '选择URL', '');
  INSERT INTO `cmf_auth_rule` VALUES ('69', '1', 'admin', 'admin_url', 'admin/Setting/default', '', '设置', '');
  INSERT INTO `cmf_auth_rule` VALUES ('70', '1', 'admin', 'admin_url', 'admin/Setting/site', '', '网站信息', '');
  INSERT INTO `cmf_auth_rule` VALUES ('71', '1', 'admin', 'admin_url', 'admin/Setting/sitePost', '', '网站信息设置提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('72', '1', 'admin', 'admin_url', 'admin/Setting/password', '', '密码修改', '');
  INSERT INTO `cmf_auth_rule` VALUES ('73', '1', 'admin', 'admin_url', 'admin/Setting/passwordPost', '', '密码修改提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('74', '1', 'admin', 'admin_url', 'admin/Setting/upload', '', '上传设置', '');
  INSERT INTO `cmf_auth_rule` VALUES ('75', '1', 'admin', 'admin_url', 'admin/Setting/uploadPost', '', '上传设置提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('76', '1', 'admin', 'admin_url', 'admin/Setting/clearCache', '', '清除缓存', '');
  INSERT INTO `cmf_auth_rule` VALUES ('77', '1', 'admin', 'admin_url', 'admin/Slide/index', '', '幻灯片管理', '');
  INSERT INTO `cmf_auth_rule` VALUES ('78', '1', 'admin', 'admin_url', 'admin/Slide/add', '', '添加幻灯片', '');
  INSERT INTO `cmf_auth_rule` VALUES ('79', '1', 'admin', 'admin_url', 'admin/Slide/addPost', '', '添加幻灯片提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('80', '1', 'admin', 'admin_url', 'admin/Slide/edit', '', '编辑幻灯片', '');
  INSERT INTO `cmf_auth_rule` VALUES ('81', '1', 'admin', 'admin_url', 'admin/Slide/editPost', '', '编辑幻灯片提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('82', '1', 'admin', 'admin_url', 'admin/Slide/delete', '', '删除幻灯片', '');
  INSERT INTO `cmf_auth_rule` VALUES ('83', '1', 'admin', 'admin_url', 'admin/SlideItem/index', '', '幻灯片页面列表', '');
  INSERT INTO `cmf_auth_rule` VALUES ('84', '1', 'admin', 'admin_url', 'admin/SlideItem/add', '', '幻灯片页面添加', '');
  INSERT INTO `cmf_auth_rule` VALUES ('85', '1', 'admin', 'admin_url', 'admin/SlideItem/addPost', '', '幻灯片页面添加提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('86', '1', 'admin', 'admin_url', 'admin/SlideItem/edit', '', '幻灯片页面编辑', '');
  INSERT INTO `cmf_auth_rule` VALUES ('87', '1', 'admin', 'admin_url', 'admin/SlideItem/editPost', '', '幻灯片页面编辑提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('88', '1', 'admin', 'admin_url', 'admin/SlideItem/delete', '', '幻灯片页面删除', '');
  INSERT INTO `cmf_auth_rule` VALUES ('89', '1', 'admin', 'admin_url', 'admin/SlideItem/ban', '', '幻灯片页面隐藏', '');
  INSERT INTO `cmf_auth_rule` VALUES ('90', '1', 'admin', 'admin_url', 'admin/SlideItem/cancelBan', '', '幻灯片页面显示', '');
  INSERT INTO `cmf_auth_rule` VALUES ('91', '1', 'admin', 'admin_url', 'admin/SlideItem/listOrder', '', '幻灯片页面排序', '');
  INSERT INTO `cmf_auth_rule` VALUES ('92', '1', 'admin', 'admin_url', 'admin/Storage/index', '', '文件存储', '');
  INSERT INTO `cmf_auth_rule` VALUES ('93', '1', 'admin', 'admin_url', 'admin/Storage/settingPost', '', '文件存储设置提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('94', '1', 'admin', 'admin_url', 'admin/Theme/index', '', '模板管理', '');
  INSERT INTO `cmf_auth_rule` VALUES ('95', '1', 'admin', 'admin_url', 'admin/Theme/install', '', '安装模板', '');
  INSERT INTO `cmf_auth_rule` VALUES ('96', '1', 'admin', 'admin_url', 'admin/Theme/uninstall', '', '卸载模板', '');
  INSERT INTO `cmf_auth_rule` VALUES ('97', '1', 'admin', 'admin_url', 'admin/Theme/installTheme', '', '模板安装', '');
  INSERT INTO `cmf_auth_rule` VALUES ('98', '1', 'admin', 'admin_url', 'admin/Theme/update', '', '模板更新', '');
  INSERT INTO `cmf_auth_rule` VALUES ('99', '1', 'admin', 'admin_url', 'admin/Theme/active', '', '启用模板', '');
  INSERT INTO `cmf_auth_rule` VALUES ('100', '1', 'admin', 'admin_url', 'admin/Theme/files', '', '模板文件列表', '');
  INSERT INTO `cmf_auth_rule` VALUES ('101', '1', 'admin', 'admin_url', 'admin/Theme/fileSetting', '', '模板文件设置', '');
  INSERT INTO `cmf_auth_rule` VALUES ('102', '1', 'admin', 'admin_url', 'admin/Theme/fileArrayData', '', '模板文件数组数据列表', '');
  INSERT INTO `cmf_auth_rule` VALUES ('103', '1', 'admin', 'admin_url', 'admin/Theme/fileArrayDataEdit', '', '模板文件数组数据添加编辑', '');
  INSERT INTO `cmf_auth_rule` VALUES ('104', '1', 'admin', 'admin_url', 'admin/Theme/fileArrayDataEditPost', '', '模板文件数组数据添加编辑提交保存', '');
  INSERT INTO `cmf_auth_rule` VALUES ('105', '1', 'admin', 'admin_url', 'admin/Theme/fileArrayDataDelete', '', '模板文件数组数据删除', '');
  INSERT INTO `cmf_auth_rule` VALUES ('106', '1', 'admin', 'admin_url', 'admin/Theme/settingPost', '', '模板文件编辑提交保存', '');
  INSERT INTO `cmf_auth_rule` VALUES ('107', '1', 'admin', 'admin_url', 'admin/Theme/dataSource', '', '模板文件设置数据源', '');
  INSERT INTO `cmf_auth_rule` VALUES ('108', '1', 'admin', 'admin_url', 'admin/User/default', '', '管理组', '');
  INSERT INTO `cmf_auth_rule` VALUES ('109', '1', 'admin', 'admin_url', 'admin/User/index', '', '管理员', '');
  INSERT INTO `cmf_auth_rule` VALUES ('110', '1', 'admin', 'admin_url', 'admin/User/add', '', '管理员添加', '');
  INSERT INTO `cmf_auth_rule` VALUES ('111', '1', 'admin', 'admin_url', 'admin/User/addPost', '', '管理员添加提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('112', '1', 'admin', 'admin_url', 'admin/User/edit', '', '管理员编辑', '');
  INSERT INTO `cmf_auth_rule` VALUES ('113', '1', 'admin', 'admin_url', 'admin/User/editPost', '', '管理员编辑提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('114', '1', 'admin', 'admin_url', 'admin/User/userInfo', '', '个人信息', '');
  INSERT INTO `cmf_auth_rule` VALUES ('115', '1', 'admin', 'admin_url', 'admin/User/userInfoPost', '', '管理员个人信息修改提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('116', '1', 'admin', 'admin_url', 'admin/User/delete', '', '管理员删除', '');
  INSERT INTO `cmf_auth_rule` VALUES ('117', '1', 'admin', 'admin_url', 'admin/User/ban', '', '停用管理员', '');
  INSERT INTO `cmf_auth_rule` VALUES ('118', '1', 'admin', 'admin_url', 'admin/User/cancelBan', '', '启用管理员', '');
  INSERT INTO `cmf_auth_rule` VALUES ('119', '1', 'portal', 'admin_url', 'portal/AdminArticle/index', '', '文章管理', '');
  INSERT INTO `cmf_auth_rule` VALUES ('120', '1', 'portal', 'admin_url', 'portal/AdminArticle/add', '', '添加文章', '');
  INSERT INTO `cmf_auth_rule` VALUES ('121', '1', 'portal', 'admin_url', 'portal/AdminArticle/addPost', '', '添加文章提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('122', '1', 'portal', 'admin_url', 'portal/AdminArticle/edit', '', '编辑文章', '');
  INSERT INTO `cmf_auth_rule` VALUES ('123', '1', 'portal', 'admin_url', 'portal/AdminArticle/editPost', '', '编辑文章提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('124', '1', 'portal', 'admin_url', 'portal/AdminArticle/delete', '', '文章删除', '');
  INSERT INTO `cmf_auth_rule` VALUES ('125', '1', 'portal', 'admin_url', 'portal/AdminArticle/publish', '', '文章发布', '');
  INSERT INTO `cmf_auth_rule` VALUES ('126', '1', 'portal', 'admin_url', 'portal/AdminArticle/top', '', '文章置顶', '');
  INSERT INTO `cmf_auth_rule` VALUES ('127', '1', 'portal', 'admin_url', 'portal/AdminArticle/recommend', '', '文章推荐', '');
  INSERT INTO `cmf_auth_rule` VALUES ('128', '1', 'portal', 'admin_url', 'portal/AdminArticle/listOrder', '', '文章排序', '');
  INSERT INTO `cmf_auth_rule` VALUES ('129', '1', 'portal', 'admin_url', 'portal/AdminCategory/index', '', '分类管理', '');
  INSERT INTO `cmf_auth_rule` VALUES ('130', '1', 'portal', 'admin_url', 'portal/AdminCategory/add', '', '添加文章分类', '');
  INSERT INTO `cmf_auth_rule` VALUES ('131', '1', 'portal', 'admin_url', 'portal/AdminCategory/addPost', '', '添加文章分类提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('132', '1', 'portal', 'admin_url', 'portal/AdminCategory/edit', '', '编辑文章分类', '');
  INSERT INTO `cmf_auth_rule` VALUES ('133', '1', 'portal', 'admin_url', 'portal/AdminCategory/editPost', '', '编辑文章分类提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('134', '1', 'portal', 'admin_url', 'portal/AdminCategory/select', '', '文章分类选择对话框', '');
  INSERT INTO `cmf_auth_rule` VALUES ('135', '1', 'portal', 'admin_url', 'portal/AdminCategory/listOrder', '', '文章分类排序', '');
  INSERT INTO `cmf_auth_rule` VALUES ('136', '1', 'portal', 'admin_url', 'portal/AdminCategory/delete', '', '删除文章分类', '');
  INSERT INTO `cmf_auth_rule` VALUES ('137', '1', 'portal', 'admin_url', 'portal/AdminIndex/default', '', '门户管理', '');
  INSERT INTO `cmf_auth_rule` VALUES ('138', '1', 'portal', 'admin_url', 'portal/AdminPage/index', '', '页面管理', '');
  INSERT INTO `cmf_auth_rule` VALUES ('139', '1', 'portal', 'admin_url', 'portal/AdminPage/add', '', '添加页面', '');
  INSERT INTO `cmf_auth_rule` VALUES ('140', '1', 'portal', 'admin_url', 'portal/AdminPage/addPost', '', '添加页面提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('141', '1', 'portal', 'admin_url', 'portal/AdminPage/edit', '', '编辑页面', '');
  INSERT INTO `cmf_auth_rule` VALUES ('142', '1', 'portal', 'admin_url', 'portal/AdminPage/editPost', '', '编辑页面提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('143', '1', 'portal', 'admin_url', 'portal/AdminPage/delete', '', '删除页面', '');
  INSERT INTO `cmf_auth_rule` VALUES ('144', '1', 'portal', 'admin_url', 'portal/AdminTag/index', '', '文章标签', '');
  INSERT INTO `cmf_auth_rule` VALUES ('145', '1', 'portal', 'admin_url', 'portal/AdminTag/add', '', '添加文章标签', '');
  INSERT INTO `cmf_auth_rule` VALUES ('146', '1', 'portal', 'admin_url', 'portal/AdminTag/addPost', '', '添加文章标签提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('147', '1', 'portal', 'admin_url', 'portal/AdminTag/upStatus', '', '更新标签状态', '');
  INSERT INTO `cmf_auth_rule` VALUES ('148', '1', 'portal', 'admin_url', 'portal/AdminTag/delete', '', '删除文章标签', '');
  INSERT INTO `cmf_auth_rule` VALUES ('149', '1', 'user', 'admin_url', 'user/AdminAsset/index', '', '资源管理', '');
  INSERT INTO `cmf_auth_rule` VALUES ('150', '1', 'user', 'admin_url', 'user/AdminAsset/delete', '', '删除文件', '');
  INSERT INTO `cmf_auth_rule` VALUES ('151', '1', 'user', 'admin_url', 'user/AdminIndex/default', '', '用户管理', '');
  INSERT INTO `cmf_auth_rule` VALUES ('152', '1', 'user', 'admin_url', 'user/AdminIndex/default1', '', '用户组', '');
  INSERT INTO `cmf_auth_rule` VALUES ('153', '1', 'user', 'admin_url', 'user/AdminIndex/index', '', '本站用户', '');
  INSERT INTO `cmf_auth_rule` VALUES ('154', '1', 'user', 'admin_url', 'user/AdminIndex/ban', '', '本站用户拉黑', '');
  INSERT INTO `cmf_auth_rule` VALUES ('155', '1', 'user', 'admin_url', 'user/AdminIndex/cancelBan', '', '本站用户启用', '');
  INSERT INTO `cmf_auth_rule` VALUES ('156', '1', 'user', 'admin_url', 'user/AdminOauth/index', '', '第三方用户', '');
  INSERT INTO `cmf_auth_rule` VALUES ('157', '1', 'user', 'admin_url', 'user/AdminOauth/delete', '', '删除第三方用户绑定', '');
  INSERT INTO `cmf_auth_rule` VALUES ('158', '1', 'user', 'admin_url', 'user/AdminUserAction/index', '', '用户操作管理', '');
  INSERT INTO `cmf_auth_rule` VALUES ('159', '1', 'user', 'admin_url', 'user/AdminUserAction/edit', '', '编辑用户操作', '');
  INSERT INTO `cmf_auth_rule` VALUES ('160', '1', 'user', 'admin_url', 'user/AdminUserAction/editPost', '', '编辑用户操作提交', '');
  INSERT INTO `cmf_auth_rule` VALUES ('161', '1', 'user', 'admin_url', 'user/AdminUserAction/sync', '', '同步用户操作', '');
  
  -- ----------------------------
  -- Table structure for cmf_comment
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_comment`;
  CREATE TABLE `cmf_comment` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '被回复的评论id',
    `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发表评论的用户id',
    `to_user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '被评论的用户id',
    `object_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论内容 id',
    `like_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞数',
    `dislike_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '不喜欢数',
    `floor` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '楼层数',
    `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论时间',
    `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
    `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:已审核,0:未审核',
    `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '评论类型；1实名评论',
    `table_name` varchar(64) NOT NULL DEFAULT '' COMMENT '评论内容所在表，不带表前缀',
    `full_name` varchar(50) NOT NULL DEFAULT '' COMMENT '评论者昵称',
    `email` varchar(255) NOT NULL DEFAULT '' COMMENT '评论者邮箱',
    `path` varchar(255) NOT NULL DEFAULT '' COMMENT '层级关系',
    `url` text COMMENT '原文地址',
    `content` text CHARACTER SET utf8mb4 COMMENT '评论内容',
    `more` text CHARACTER SET utf8mb4 COMMENT '扩展属性',
    PRIMARY KEY (`id`),
    KEY `table_id_status` (`table_name`,`object_id`,`status`),
    KEY `object_id` (`object_id`) USING BTREE,
    KEY `status` (`status`) USING BTREE,
    KEY `parent_id` (`parent_id`) USING BTREE,
    KEY `create_time` (`create_time`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='评论表';
  
  -- ----------------------------
  -- Records of cmf_comment
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cmf_hook
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_hook`;
  CREATE TABLE `cmf_hook` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '钩子类型(1:系统钩子;2:应用钩子;3:模板钩子;4:后台模板钩子)',
    `once` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否只允许一个插件运行(0:多个;1:一个)',
    `name` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子名称',
    `hook` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子',
    `app` varchar(15) NOT NULL DEFAULT '' COMMENT '应用名(只有应用钩子才用)',
    `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COMMENT='系统钩子表';
  
  -- ----------------------------
  -- Records of cmf_hook
  -- ----------------------------
  INSERT INTO `cmf_hook` VALUES ('1', '1', '0', '应用初始化', 'app_init', 'cmf', '应用初始化');
  INSERT INTO `cmf_hook` VALUES ('2', '1', '0', '应用开始', 'app_begin', 'cmf', '应用开始');
  INSERT INTO `cmf_hook` VALUES ('3', '1', '0', '模块初始化', 'module_init', 'cmf', '模块初始化');
  INSERT INTO `cmf_hook` VALUES ('4', '1', '0', '控制器开始', 'action_begin', 'cmf', '控制器开始');
  INSERT INTO `cmf_hook` VALUES ('5', '1', '0', '视图输出过滤', 'view_filter', 'cmf', '视图输出过滤');
  INSERT INTO `cmf_hook` VALUES ('6', '1', '0', '应用结束', 'app_end', 'cmf', '应用结束');
  INSERT INTO `cmf_hook` VALUES ('7', '1', '0', '日志write方法', 'log_write', 'cmf', '日志write方法');
  INSERT INTO `cmf_hook` VALUES ('8', '1', '0', '输出结束', 'response_end', 'cmf', '输出结束');
  INSERT INTO `cmf_hook` VALUES ('9', '1', '0', '后台控制器初始化', 'admin_init', 'cmf', '后台控制器初始化');
  INSERT INTO `cmf_hook` VALUES ('10', '1', '0', '前台控制器初始化', 'home_init', 'cmf', '前台控制器初始化');
  INSERT INTO `cmf_hook` VALUES ('11', '1', '1', '发送手机验证码', 'send_mobile_verification_code', 'cmf', '发送手机验证码');
  INSERT INTO `cmf_hook` VALUES ('12', '3', '0', '模板 body标签开始', 'body_start', '', '模板 body标签开始');
  INSERT INTO `cmf_hook` VALUES ('13', '3', '0', '模板 head标签结束前', 'before_head_end', '', '模板 head标签结束前');
  INSERT INTO `cmf_hook` VALUES ('14', '3', '0', '模板底部开始', 'footer_start', '', '模板底部开始');
  INSERT INTO `cmf_hook` VALUES ('15', '3', '0', '模板底部开始之前', 'before_footer', '', '模板底部开始之前');
  INSERT INTO `cmf_hook` VALUES ('16', '3', '0', '模板底部结束之前', 'before_footer_end', '', '模板底部结束之前');
  INSERT INTO `cmf_hook` VALUES ('17', '3', '0', '模板 body 标签结束之前', 'before_body_end', '', '模板 body 标签结束之前');
  INSERT INTO `cmf_hook` VALUES ('18', '3', '0', '模板左边栏开始', 'left_sidebar_start', '', '模板左边栏开始');
  INSERT INTO `cmf_hook` VALUES ('19', '3', '0', '模板左边栏结束之前', 'before_left_sidebar_end', '', '模板左边栏结束之前');
  INSERT INTO `cmf_hook` VALUES ('20', '3', '0', '模板右边栏开始', 'right_sidebar_start', '', '模板右边栏开始');
  INSERT INTO `cmf_hook` VALUES ('21', '3', '0', '模板右边栏结束之前', 'before_right_sidebar_end', '', '模板右边栏结束之前');
  INSERT INTO `cmf_hook` VALUES ('22', '3', '1', '评论区', 'comment', '', '评论区');
  INSERT INTO `cmf_hook` VALUES ('23', '3', '1', '留言区', 'guestbook', '', '留言区');
  INSERT INTO `cmf_hook` VALUES ('24', '2', '0', '后台首页仪表盘', 'admin_dashboard', 'admin', '后台首页仪表盘');
  INSERT INTO `cmf_hook` VALUES ('25', '4', '0', '后台模板 head标签结束前', 'admin_before_head_end', '', '后台模板 head标签结束前');
  INSERT INTO `cmf_hook` VALUES ('26', '4', '0', '后台模板 body 标签结束之前', 'admin_before_body_end', '', '后台模板 body 标签结束之前');
  INSERT INTO `cmf_hook` VALUES ('27', '2', '0', '后台登录页面', 'admin_login', 'admin', '后台登录页面');
  INSERT INTO `cmf_hook` VALUES ('28', '1', '1', '前台模板切换', 'switch_theme', 'cmf', '前台模板切换');
  INSERT INTO `cmf_hook` VALUES ('29', '3', '0', '主要内容之后', 'after_content', '', '主要内容之后');
  INSERT INTO `cmf_hook` VALUES ('30', '2', '0', '文章显示之前', 'portal_before_assign_article', 'portal', '文章显示之前');
  INSERT INTO `cmf_hook` VALUES ('31', '2', '0', '后台文章保存之后', 'portal_admin_after_save_article', 'portal', '后台文章保存之后');
  INSERT INTO `cmf_hook` VALUES ('32', '2', '1', '获取上传界面', 'fetch_upload_view', 'user', '获取上传界面');
  INSERT INTO `cmf_hook` VALUES ('33', '3', '0', '主要内容之前', 'before_content', 'cmf', '主要内容之前');
  INSERT INTO `cmf_hook` VALUES ('34', '1', '0', '日志写入完成', 'log_write_done', 'cmf', '日志写入完成');
  INSERT INTO `cmf_hook` VALUES ('35', '1', '1', '后台模板切换', 'switch_admin_theme', 'cmf', '后台模板切换');
  
  -- ----------------------------
  -- Table structure for cmf_hook_plugin
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_hook_plugin`;
  CREATE TABLE `cmf_hook_plugin` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
    `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态(0:禁用,1:启用)',
    `hook` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子名',
    `plugin` varchar(50) NOT NULL DEFAULT '' COMMENT '插件',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统钩子插件表';
  
  -- ----------------------------
  -- Records of cmf_hook_plugin
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cmf_link
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_link`;
  CREATE TABLE `cmf_link` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:显示;0:不显示',
    `rating` int(11) NOT NULL DEFAULT '0' COMMENT '友情链接评级',
    `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
    `description` varchar(255) NOT NULL DEFAULT '' COMMENT '友情链接描述',
    `url` varchar(255) NOT NULL DEFAULT '' COMMENT '友情链接地址',
    `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '友情链接名称',
    `image` varchar(100) NOT NULL DEFAULT '' COMMENT '友情链接图标',
    `target` varchar(10) NOT NULL DEFAULT '' COMMENT '友情链接打开方式',
    `rel` varchar(50) NOT NULL DEFAULT '' COMMENT '链接与网站的关系',
    PRIMARY KEY (`id`),
    KEY `status` (`status`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='友情链接表';
  
  -- ----------------------------
  -- Records of cmf_link
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cmf_nav
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_nav`;
  CREATE TABLE `cmf_nav` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `is_main` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否为主导航;1:是;0:不是',
    `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '导航位置名称',
    `remark` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '备注',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='前台导航位置表';
  
  -- ----------------------------
  -- Records of cmf_nav
  -- ----------------------------
  INSERT INTO `cmf_nav` VALUES ('1', '1', '主导航', '主导航');
  INSERT INTO `cmf_nav` VALUES ('2', '0', '底部导航', '');
  INSERT INTO `cmf_nav` VALUES ('3', '0', '服务项目', '服务项目');
  
  -- ----------------------------
  -- Table structure for cmf_nav_menu
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_nav_menu`;
  CREATE TABLE `cmf_nav_menu` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nav_id` int(11) NOT NULL COMMENT '导航 id',
    `parent_id` int(11) NOT NULL COMMENT '父 id',
    `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:显示;0:隐藏',
    `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
    `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
    `target` varchar(10) NOT NULL DEFAULT '' COMMENT '打开方式',
    `href` varchar(100) NOT NULL DEFAULT '' COMMENT '链接',
    `icon` varchar(20) NOT NULL DEFAULT '' COMMENT '图标',
    `path` varchar(255) NOT NULL DEFAULT '' COMMENT '层级关系',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COMMENT='前台导航菜单表';
  
  -- ----------------------------
  -- Records of cmf_nav_menu
  -- ----------------------------
  INSERT INTO `cmf_nav_menu` VALUES ('1', '1', '0', '1', '0', '首页', '', 'home', '', '0-1');
  INSERT INTO `cmf_nav_menu` VALUES ('2', '1', '0', '1', '10000', '关于我们', '', '{\"action\":\"portal\\/Page\\/index\",\"param\":{\"id\":2}}', '', '');
  INSERT INTO `cmf_nav_menu` VALUES ('3', '1', '0', '1', '10000', '公司动态', '', 'Company-news', '', '');
  INSERT INTO `cmf_nav_menu` VALUES ('5', '1', '0', '1', '10000', '招聘中心', '', 'Recruitment-center', '', '');
  INSERT INTO `cmf_nav_menu` VALUES ('6', '1', '0', '1', '10000', '联系我们', '', '{\"action\":\"portal\\/Page\\/index\",\"param\":{\"id\":5}}', '', '');
  INSERT INTO `cmf_nav_menu` VALUES ('7', '1', '0', '1', '10000', '服务介绍', '', '{\"action\":\"portal\\/Page\\/index\",\"param\":{\"id\":6}}', '', '');
  INSERT INTO `cmf_nav_menu` VALUES ('8', '3', '0', '1', '10000', '家电维修', '', '{\"action\":\"portal\\/Page\\/index\",\"param\":{\"id\":35}}', '', '');
  INSERT INTO `cmf_nav_menu` VALUES ('9', '3', '0', '1', '10000', '家政保洁', '', '{\"action\":\"portal\\/Page\\/index\",\"param\":{\"id\":36}}', '', '');
  INSERT INTO `cmf_nav_menu` VALUES ('10', '3', '0', '1', '10000', '家电清洗', '', '{\"action\":\"portal\\/Page\\/index\",\"param\":{\"id\":37}}', '', '');
  INSERT INTO `cmf_nav_menu` VALUES ('11', '3', '0', '1', '10000', '家庭装修', '', '{\"action\":\"portal\\/Page\\/index\",\"param\":{\"id\":38}}', '', '');
  INSERT INTO `cmf_nav_menu` VALUES ('12', '3', '0', '1', '10000', '空气治理', '', '{\"action\":\"portal\\/Page\\/index\",\"param\":{\"id\":39}}', '', '');
  
  -- ----------------------------
  -- Table structure for cmf_option
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_option`;
  CREATE TABLE `cmf_option` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `autoload` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否自动加载;1:自动加载;0:不自动加载',
    `option_name` varchar(64) NOT NULL DEFAULT '' COMMENT '配置名',
    `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '配置值',
    PRIMARY KEY (`id`),
    UNIQUE KEY `option_name` (`option_name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='全站配置表';
  
  -- ----------------------------
  -- Records of cmf_option
  -- ----------------------------
  INSERT INTO `cmf_option` VALUES ('1', '1', 'site_info', '{\"site_name\":\"\\u8c46\\u82bd\\u4e4b\\u5bb6\",\"site_seo_title\":\"\\u8c46\\u82bd\\u4e4b\\u5bb6\",\"site_seo_keywords\":\"ThinkCMF,php,\\u5185\\u5bb9\\u7ba1\\u7406\\u6846\\u67b6,cmf,cms,\\u7b80\\u7ea6\\u98ce, simplewind,framework\",\"site_seo_description\":\"ThinkCMF\\u662f\\u7b80\\u7ea6\\u98ce\\u7f51\\u7edc\\u79d1\\u6280\\u53d1\\u5e03\\u7684\\u4e00\\u6b3e\\u7528\\u4e8e\\u5feb\\u901f\\u5f00\\u53d1\\u7684\\u5185\\u5bb9\\u7ba1\\u7406\\u6846\\u67b6\",\"site_icp\":\"\\u6842ICP\\u590718005073\\u53f7-1\",\"site_gwa\":\" \",\"site_admin_email\":\"\",\"site_analytics\":\"\"}');
  INSERT INTO `cmf_option` VALUES ('2', '1', 'cmf_settings', '{\"open_registration\":\"0\",\"banned_usernames\":\"\"}');
  INSERT INTO `cmf_option` VALUES ('3', '1', 'cdn_settings', '{\"cdn_static_root\":\"\"}');
  INSERT INTO `cmf_option` VALUES ('4', '1', 'admin_settings', '{\"admin_password\":\"\",\"admin_style\":\"flatadmin\"}');
  
  -- ----------------------------
  -- Table structure for cmf_plugin
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_plugin`;
  CREATE TABLE `cmf_plugin` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
    `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '插件类型;1:网站;8:微信',
    `has_admin` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否有后台管理,0:没有;1:有',
    `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:开启;0:禁用',
    `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '插件安装时间',
    `name` varchar(50) NOT NULL DEFAULT '' COMMENT '插件标识名,英文字母(惟一)',
    `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '插件名称',
    `demo_url` varchar(50) NOT NULL DEFAULT '' COMMENT '演示地址，带协议',
    `hooks` varchar(255) NOT NULL DEFAULT '' COMMENT '实现的钩子;以“,”分隔',
    `author` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '插件作者',
    `author_url` varchar(50) NOT NULL DEFAULT '' COMMENT '作者网站链接',
    `version` varchar(20) NOT NULL DEFAULT '' COMMENT '插件版本号',
    `description` varchar(255) NOT NULL COMMENT '插件描述',
    `config` text COMMENT '插件配置',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='插件表';
  
  -- ----------------------------
  -- Records of cmf_plugin
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cmf_portal_category
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_portal_category`;
  CREATE TABLE `cmf_portal_category` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类id',
    `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类父id',
    `post_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类文章数',
    `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:发布,0:不发布',
    `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
    `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
    `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '分类名称',
    `description` varchar(255) NOT NULL DEFAULT '' COMMENT '分类描述',
    `path` varchar(255) NOT NULL DEFAULT '' COMMENT '分类层级关系路径',
    `seo_title` varchar(100) NOT NULL DEFAULT '',
    `seo_keywords` varchar(255) NOT NULL DEFAULT '',
    `seo_description` varchar(255) NOT NULL DEFAULT '',
    `list_tpl` varchar(50) NOT NULL DEFAULT '' COMMENT '分类列表模板',
    `one_tpl` varchar(50) NOT NULL DEFAULT '' COMMENT '分类文章页模板',
    `more` text COMMENT '扩展属性',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='portal应用 文章分类表';
  
  -- ----------------------------
  -- Records of cmf_portal_category
  -- ----------------------------
  INSERT INTO `cmf_portal_category` VALUES ('1', '0', '0', '1', '0', '10000', '公司动态', '', '0-1', '', '', '', 'list', 'article', '{\"thumbnail\":\"\"}');
  INSERT INTO `cmf_portal_category` VALUES ('4', '0', '0', '1', '0', '10000', '招聘中心', '', '0-4', '', '', '', 'list-re', 'article-re', '{\"thumbnail\":\"\"}');
  
  -- ----------------------------
  -- Table structure for cmf_portal_category_post
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_portal_category_post`;
  CREATE TABLE `cmf_portal_category_post` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `post_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '文章id',
    `category_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类id',
    `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
    `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:发布;0:不发布',
    PRIMARY KEY (`id`),
    KEY `term_taxonomy_id` (`category_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='portal应用 分类文章对应表';
  
  -- ----------------------------
  -- Records of cmf_portal_category_post
  -- ----------------------------
  INSERT INTO `cmf_portal_category_post` VALUES ('1', '7', '1', '10000', '1');
  INSERT INTO `cmf_portal_category_post` VALUES ('2', '8', '1', '10000', '1');
  INSERT INTO `cmf_portal_category_post` VALUES ('3', '9', '1', '10000', '1');
  INSERT INTO `cmf_portal_category_post` VALUES ('4', '10', '1', '10000', '1');
  INSERT INTO `cmf_portal_category_post` VALUES ('8', '14', '4', '10000', '1');
  INSERT INTO `cmf_portal_category_post` VALUES ('9', '44', '4', '10000', '1');
  INSERT INTO `cmf_portal_category_post` VALUES ('10', '45', '4', '10000', '1');
  INSERT INTO `cmf_portal_category_post` VALUES ('11', '46', '4', '10000', '1');
  
  -- ----------------------------
  -- Table structure for cmf_portal_post
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_portal_post`;
  CREATE TABLE `cmf_portal_post` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
    `post_type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '类型,1:文章;2:页面',
    `post_format` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '内容格式;1:html;2:md',
    `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '发表者用户id',
    `post_status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:已发布;0:未发布;',
    `comment_status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '评论状态;1:允许;0:不允许',
    `is_top` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否置顶;1:置顶;0:不置顶',
    `recommended` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否推荐;1:推荐;0:不推荐',
    `post_hits` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '查看数',
    `post_like` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '点赞数',
    `comment_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '评论数',
    `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
    `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
    `published_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
    `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
    `post_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'post标题',
    `post_keywords` varchar(150) NOT NULL DEFAULT '' COMMENT 'seo keywords',
    `post_excerpt` varchar(500) NOT NULL DEFAULT '' COMMENT 'post摘要',
    `post_source` varchar(150) NOT NULL DEFAULT '' COMMENT '转载文章的来源',
    `post_content` text COMMENT '文章内容',
    `post_content_filtered` text COMMENT '处理过的文章内容',
    `more` text COMMENT '扩展属性,如缩略图;格式为json',
    PRIMARY KEY (`id`),
    KEY `type_status_date` (`post_type`,`post_status`,`create_time`,`id`),
    KEY `parent_id` (`parent_id`),
    KEY `user_id` (`user_id`),
    KEY `create_time` (`create_time`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='portal应用 文章表';
  
  -- ----------------------------
  -- Records of cmf_portal_post
  -- ----------------------------
  INSERT INTO `cmf_portal_post` VALUES ('2', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1527047769', '1529889135', '1527047700', '0', '关于我们', 'About-us', '', '', '&lt;p&gt;&lt;img src=&quot;default/20180622/9dc348cc31dca3268fb836e85cf21631.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180622/9dc348cc31dca3268fb836e85cf21631.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180622/9dc348cc31dca3268fb836e85cf21631.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180622/9dc348cc31dca3268fb836e85cf21631.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;/p&gt;', null, '{\"thumbnail\":\"portal\\/20180620\\/f85eeb45b9825b41eb457369f5bbdf13.png\",\"template\":\"page-about\"}');
  INSERT INTO `cmf_portal_post` VALUES ('3', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1527060442', '1527298766', '1527060060', '0', '公司动态', 'Company-news', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"page\"}');
  INSERT INTO `cmf_portal_post` VALUES ('4', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1527060682', '1527736306', '1527060600', '0', '招聘中心', 'Recruitment-center', '', '', '', null, '{\"thumbnail\":\"\",\"template\":\"page-re\"}');
  INSERT INTO `cmf_portal_post` VALUES ('5', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1527060724', '1527298722', '1527060660', '0', '联系我们', 'Contact-us', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"contact\"}');
  INSERT INTO `cmf_portal_post` VALUES ('6', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1527300627', '1529975388', '1527300540', '0', '服务介绍', 'Service-intro', '', '', '\n&lt;p&gt;&lt;img src=&quot;default/20180626/3a4f840ccda82d146fd6fbe197d5a1c3.png&quot; title=&quot;豆芽之家贴纸10X10c绿色.png&quot; alt=&quot;豆芽之家贴纸10X10c绿色.png&quot;&gt;&lt;/p&gt;\n&lt;p&gt;&lt;br&gt;&lt;/p&gt;\n', null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('7', '0', '1', '1', '1', '1', '1', '0', '0', '24', '0', '0', '1527302190', '1529910841', '1527302160', '0', '公司动态', 'Company-news', 'XXXXXXXXXXXXXXXXXXXXXXXXX', '', '\n&lt;p&gt;公司动态公司动态公司动态公司动态公司动态公司动态公司动态公司动态公司动态公司动态公司动态公司动态公司动态&lt;/p&gt;\n&lt;p&gt;&lt;br&gt;&lt;/p&gt;\n&lt;p&gt;&lt;br&gt;&lt;/p&gt;\n', null, '{\"thumbnail\":\"portal\\/20180625\\/fc1bd2bcd91e8c32ede0ce68c41a8211.png\",\"template\":\"article\"}');
  INSERT INTO `cmf_portal_post` VALUES ('8', '0', '1', '1', '1', '1', '1', '0', '0', '1', '0', '0', '1527496339', '1527496358', '1527496260', '0', 'xxxxx', 'xxxxx', 'xxxxx', 'xxxxx', '&lt;p&gt;xxxxx&lt;/p&gt;', null, '{\"thumbnail\":\"\",\"template\":\"\"}');
  INSERT INTO `cmf_portal_post` VALUES ('9', '0', '1', '1', '1', '1', '1', '0', '0', '1', '0', '0', '1527496404', '1527496411', '1527496380', '0', 'xxxxx', 'xxxxx', 'xxxxx', 'xxxxx', '&lt;p&gt;xxxxx&lt;/p&gt;', null, '{\"thumbnail\":\"\",\"template\":\"\"}');
  INSERT INTO `cmf_portal_post` VALUES ('10', '0', '1', '1', '1', '1', '1', '0', '0', '9', '0', '0', '1527496438', '1527496444', '1527496380', '0', 'xxxxx', 'xxxxx', 'xxxxx', 'xxxxx', '&lt;p&gt;xxxxx&lt;/p&gt;', null, '{\"thumbnail\":\"\",\"template\":\"\"}');
  INSERT INTO `cmf_portal_post` VALUES ('14', '0', '1', '1', '1', '1', '1', '0', '0', '12', '0', '0', '1527736585', '1530148857', '1527736560', '0', '招聘安装、维修工程师 （数名）', '', '负责格力、美的、海尔、创维、海信、志高、奥克斯等知名家电品牌安装维修工作。', '', '\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;岗位职责：&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;负责格力、美的、海尔、创维、海信、志高、奥克斯等知名家电品牌安装维修工作。&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;任职要求：&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;1、身体健康、品行端正；&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;2&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;、踏实肯干，对工作认真负责，对用户要有耐心，服从安排；&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;3&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;、对南宁市区路线熟悉；&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;4&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;、有维修制冷设备工具和安装工具，有品牌厂家的安装维修经验者优先。&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;工作地点：南宁市&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;待遇：&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;1、&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;底薪&lt;/span&gt;+提成，月休4天&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;2、&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;安装工程师保底&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;3500元/月，维修工程师保底2800元/月&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;福利：社保、意外保险、通讯补贴、节日补贴&lt;/span&gt; &lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;br&gt;&lt;/p&gt;\n', null, '{\"thumbnail\":\"\",\"template\":\"article-re\"}');
  INSERT INTO `cmf_portal_post` VALUES ('15', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528075378', '1529980018', '1528075260', '0', '空调清洗', '', '', '', '', null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('16', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528103021', '1529980070', '1528102620', '0', '油烟机清洗', '', '', '', '&lt;p&gt;&lt;img src=&quot;default/20180604/f07ba93fa477ab3c27b7528e6b905d2c.png&quot; title=&quot;油烟机清洗.png&quot; alt=&quot;油烟机清洗.png&quot;&gt;&lt;/p&gt;', null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('17', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528166526', '1529980213', '1528164840', '0', '洗衣机清洗', '', '', '', '&lt;p&gt;&lt;img src=&quot;default/20180605/80a0aaf266deb92526705876e752c48e.png&quot; title=&quot;洗衣机清洗.png&quot; alt=&quot;洗衣机清洗.png&quot;&gt;&lt;/p&gt;', null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('18', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528166681', '1529978092', '1528166640', '0', '空调维修', '', '', '', '', null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('19', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528166704', '1529978439', '1528166640', '0', '油烟机维修', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('20', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528166744', '1529978465', '1528166700', '0', '洗衣机维修', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('21', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528166762', '1529978673', '1528166700', '0', '冰箱维修', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('22', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528166814', '1529978716', '1528166760', '0', '电视机维修', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('23', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528167082', '1529978745', '1528167060', '0', '热水器维修', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('24', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528167104', '1529979320', '1528167060', '0', '钟点工', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('25', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528167149', '1529979613', '1528167120', '0', '日常保洁', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('26', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528167290', '1529979657', '1528167180', '0', '新居开荒', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('27', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528167332', '1529979930', '1528167300', '0', '家居保养', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('28', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528167446', '1528167446', '1528167420', '0', '精装', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"service_intro\"}');
  INSERT INTO `cmf_portal_post` VALUES ('29', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528167463', '1528167463', '1528167420', '0', '旧房改造', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"service_intro\"}');
  INSERT INTO `cmf_portal_post` VALUES ('30', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528167488', '1528167488', '1528167420', '0', '工长', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"service_intro\"}');
  INSERT INTO `cmf_portal_post` VALUES ('31', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528167510', '1528167510', '1528167480', '0', '水电工', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"service_intro\"}');
  INSERT INTO `cmf_portal_post` VALUES ('32', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528167543', '1528167543', '1528167480', '0', '木工', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"service_intro\"}');
  INSERT INTO `cmf_portal_post` VALUES ('33', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528167563', '1528167563', '1528167540', '0', '油漆工', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"service_intro\"}');
  INSERT INTO `cmf_portal_post` VALUES ('34', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528167581', '1528167581', '1528167540', '0', '泥瓦工', '', '', '', null, null, '{\"thumbnail\":\"\",\"template\":\"service_intro\"}');
  INSERT INTO `cmf_portal_post` VALUES ('35', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528248647', '1529981197', '1528248480', '0', '家电维修', '', '', '', '&lt;p&gt;&lt;a href=&quot;/ktwx&quot; target=&quot;_self&quot;&gt;&lt;img src=&quot;default/20180626/df7a61ff3d31e3ae3ac057bdbb884483.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;/a&gt;&lt;a href=&quot;/yyjwx&quot; target=&quot;_self&quot;&gt;&lt;img src=&quot;default/20180626/df7a61ff3d31e3ae3ac057bdbb884483.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;/a&gt;&lt;a href=&quot;/xyjwx&quot; target=&quot;_self&quot;&gt;&lt;img src=&quot;default/20180626/df7a61ff3d31e3ae3ac057bdbb884483.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;/a&gt;&lt;a href=&quot;/bxwx&quot; target=&quot;_self&quot;&gt;&lt;img src=&quot;default/20180626/df7a61ff3d31e3ae3ac057bdbb884483.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;/a&gt;&lt;a href=&quot;/dsjwx&quot; target=&quot;_self&quot;&gt;&lt;img src=&quot;default/20180626/df7a61ff3d31e3ae3ac057bdbb884483.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;/a&gt;&lt;a href=&quot;/rsqwx&quot; target=&quot;_self&quot;&gt;&lt;img src=&quot;default/20180626/df7a61ff3d31e3ae3ac057bdbb884483.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;/a&gt;&lt;/p&gt;', null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('36', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528248702', '1529918668', '1528248600', '0', '家政保洁', '', '', '', '&lt;p&gt;&lt;img src=&quot;default/20180625/9a5c7963529023a88fedeb0a00a7c275.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180625/9a5c7963529023a88fedeb0a00a7c275.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180625/9a5c7963529023a88fedeb0a00a7c275.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180625/9a5c7963529023a88fedeb0a00a7c275.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;/p&gt;', null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('37', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528248736', '1529918649', '1528248660', '0', '家电清洗', '', '', '', '&lt;p&gt;&lt;img src=&quot;default/20180625/9a5c7963529023a88fedeb0a00a7c275.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180625/9a5c7963529023a88fedeb0a00a7c275.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180625/9a5c7963529023a88fedeb0a00a7c275.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180625/9a5c7963529023a88fedeb0a00a7c275.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;/p&gt;', null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('38', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528248765', '1529918724', '1528248720', '0', '家庭装修', '', '', '', '&lt;p&gt;&lt;img src=&quot;default/20180625/9a5c7963529023a88fedeb0a00a7c275.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180625/9a5c7963529023a88fedeb0a00a7c275.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180625/9a5c7963529023a88fedeb0a00a7c275.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180625/9a5c7963529023a88fedeb0a00a7c275.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;/p&gt;', null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('39', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1528248790', '1529891034', '1528248720', '0', '空气治理', '', '', '', '&lt;p&gt;&lt;img src=&quot;default/20180622/9dc348cc31dca3268fb836e85cf21631.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180622/9dc348cc31dca3268fb836e85cf21631.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180622/9dc348cc31dca3268fb836e85cf21631.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;img src=&quot;default/20180622/9dc348cc31dca3268fb836e85cf21631.png&quot; title=&quot;XL.png&quot; alt=&quot;XL.png&quot;&gt;&lt;/p&gt;', null, '{\"thumbnail\":\"\",\"template\":\"page-service\"}');
  INSERT INTO `cmf_portal_post` VALUES ('40', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1529460372', '1529460383', '1529460360', '1529639782', 'test', '', '', '', '&lt;p&gt;test&lt;/p&gt;', null, '{\"thumbnail\":\"\",\"template\":\"page\"}');
  INSERT INTO `cmf_portal_post` VALUES ('41', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1529896393', '1530153473', '1529896320', '0', '公司简介', '', '', '', '\n&lt;p style=&quot;text-indent: 2em; margin-top: 5px; line-height: 1.5em;&quot;&gt;&lt;span style=\'background-color: rgb(255, 255, 255); color: rgb(51, 51, 51); font-family: &quot;Arial Normal&quot;, Arial; font-size: 16px;\'&gt;广西南宁豆芽之家生活服务有限公司，是一家专业从事家电维修、家政保洁、家居装修等业务的服务公司，承接格力、志高、奥克斯等多家知名品牌售后服务工作，设施齐全、管理科学。公司现拥有一支经验丰富的管理团队和一整套完善的工作体系、管理制度、质量监督体系、现代企业管理模式，秉承“勤奋、务实、敬业、创新”的经营管理理念，以用户需求为核心，为广大用户提供快速、高质量的服务，满足了市场需求。&lt;br&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p style=&quot;box-sizing: border-box; margin-bottom: 0px; color: rgb(51, 51, 51); font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255); text-rendering: optimizeLegibility; font-feature-settings: \'kern\' 1; font-kerning: normal; font-family: &amp;quot;Arial Normal&amp;quot;, Arial; text-indent: 2em; margin-top: 5px; line-height: 1.5em;&quot;&gt;&lt;span style=&quot;font-size: 16px;&quot;&gt;为确保服务质量，公司对所有服务人员实行标准化管理，所有员工接受诚信职业道德与职业技能的岗前培训，确保每一位客户都能享受到专业、快捷、细致的服务。豆芽之家以“诚信立口碑、品质求市场、创新谋发展”为宗旨，为成为全国知名的服务品牌而不懈努力。&lt;/span&gt;&lt;/p&gt;\n&lt;p style=&quot;box-sizing: border-box; margin-bottom: 0px; color: rgb(51, 51, 51); font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255); text-rendering: optimizeLegibility; font-feature-settings: \'kern\' 1; font-kerning: normal; font-family: &amp;quot;Arial Normal&amp;quot;, Arial; text-indent: 2em; margin-top: 5px; line-height: 1.5em;&quot;&gt;&lt;span style=&quot;font-size: 16px;&quot;&gt;公司位于民歌湖畔，交通便利、工作环境优良、内部管理规范，注重企业文化建设和人力资源培训与开发，能够为员工提供良好的展示自我、实现个人价值的广阔平台。为加速提升企业综合实力，适应企业面临的市场新的发展机遇和挑战，我公司竭诚欢迎广大电类专业及服务行业的优秀人才的加入，共同创造豆芽之家美好未来。&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;br&gt;&lt;/p&gt;\n', null, '{\"thumbnail\":\"\",\"template\":\"page-case\"}');
  INSERT INTO `cmf_portal_post` VALUES ('42', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1529896858', '1530005324', '1529896740', '0', '企业文化', '', '', '', '&lt;p&gt;&lt;img src=&quot;default/20180626/8335f024cd3367ee9a6702bfb9d13b26.png&quot; title=&quot;qywh.png&quot; alt=&quot;qywh.png&quot;&gt;&lt;/p&gt;', null, '{\"thumbnail\":\"\",\"template\":\"page-case\"}');
  INSERT INTO `cmf_portal_post` VALUES ('43', '0', '2', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1529896894', '1530152904', '1529896860', '0', '员工风采', '', '', '', '&lt;p&gt;&lt;img src=&quot;default/20180628/d987d596e56de5d27e266e94b89173d4.jpg&quot; title=&quot;025.jpg&quot; alt=&quot;025.jpg&quot;&gt;&lt;img src=&quot;default/20180628/a8a8f743c29a81c614ab86b13fb644bc.jpg&quot; title=&quot;026.jpg&quot; alt=&quot;026.jpg&quot;&gt;&lt;img src=&quot;default/20180628/a8a8f743c29a81c614ab86b13fb644bc.jpg&quot; title=&quot;026.jpg&quot; alt=&quot;026.jpg&quot;&gt;&lt;/p&gt;', null, '{\"thumbnail\":\"\",\"template\":\"page-case\"}');
  INSERT INTO `cmf_portal_post` VALUES ('44', '0', '1', '1', '1', '1', '1', '0', '0', '1', '0', '0', '1530148938', '1530148954', '1530148860', '0', '招聘保洁员（数名）', '', '男女不限，专职兼职均可', '', '\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;任职要求：&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;1、男女不限，专职兼职均可；&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;2、品行端正，身体健康，应聘时须持身份证原件、复印件、二级甲等以上医院体检健康证明；&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;3、能吃苦耐劳，工作认真仔细，责任心强，有良好的服务意识；&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;4、有相关从业经验者优先录用。&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;工作地点：南宁市&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt; &lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;待遇：&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;1、&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;底薪&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;+提成，月休4天&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;2、&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;专职保底&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;1500元/月&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;福利：保险、通讯补贴、节日补贴&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;br&gt;&lt;/p&gt;\n', null, '{\"thumbnail\":\"\",\"template\":\"article-re\"}');
  INSERT INTO `cmf_portal_post` VALUES ('45', '0', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '1530149333', '1530149385', '1530149220', '0', '招聘信息员 1名', '', '负责公司服务热线的接听，处理各种咨询问题', '', '\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;岗位职责：&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;1、负责公司服务热线的接听，处理各种咨询问题；&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;2、负责与厂家、服务商对接各项工作事务；&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;3、负责安装维修信息派工，协调处理用户投诉；&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;4、协助处理公司其他日常事务&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt; &lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;。&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;任职要求：&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;1、熟练操作办公软件；&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;2、&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;口齿伶俐，&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;身体健康、品行端正；&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;3、踏实肯干，对工作认真负责，有耐心；&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;4、具备良好的与他人合作、与他人沟通的工作能力；&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;5、有从业经验的优先考虑。&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;工作地点：南宁市&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;待遇：&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;2000-3500元&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;，月休&lt;/span&gt;4天&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;福利：社保、通讯补贴、节日补贴&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;br&gt;&lt;/p&gt;\n', null, '{\"thumbnail\":\"\",\"template\":\"article-re\"}');
  INSERT INTO `cmf_portal_post` VALUES ('46', '0', '1', '1', '1', '1', '1', '0', '0', '2', '0', '0', '1530149426', '1530149434', '1530149340', '0', '家电清洗主管工程师 1名', '', '主要工作内容：清洗油烟机，空调，冰箱，洗衣机等家电', '', '\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;主要工作内容：清洗油烟机，空调，冰箱，洗衣机等家电&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;岗位职责：&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;br&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;1、&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;按要求进行操作&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;；&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;br&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;2、服从领导安排，完成本岗以外的技术学习任务；&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;br&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;3、完成领导交办的临时工作。&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;br&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;任职资格：&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;br&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;1、&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;2&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;年以上&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;相关&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;工作经验&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;；&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;br&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;2、吃苦耐劳，有责任心；&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;br&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;3、有家电售后经验和交通工具者优先考虑&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;。&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;工作地点：南宁市&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;待遇：&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;面议&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;，月休&lt;/span&gt;4天&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;span style=&quot;font-family: 微软雅黑;color: rgb(46, 52, 59);letter-spacing: 0;font-size: 14px;background: rgb(255, 255, 255)&quot;&gt;&lt;span style=&quot;font-family:微软雅黑&quot;&gt;福利：社保、意外保险、通讯补贴、节日补贴&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;\n&lt;p&gt;&lt;br&gt;&lt;/p&gt;\n', null, '{\"thumbnail\":\"\",\"template\":\"article-re\"}');
  
  -- ----------------------------
  -- Table structure for cmf_portal_tag
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_portal_tag`;
  CREATE TABLE `cmf_portal_tag` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类id',
    `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:发布,0:不发布',
    `recommended` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否推荐;1:推荐;0:不推荐',
    `post_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '标签文章数',
    `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标签名称',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='portal应用 文章标签表';
  
  -- ----------------------------
  -- Records of cmf_portal_tag
  -- ----------------------------
  INSERT INTO `cmf_portal_tag` VALUES ('7', '1', '0', '0', 'xxxxxx');
  INSERT INTO `cmf_portal_tag` VALUES ('8', '1', '0', '0', 'Company-news');
  
  -- ----------------------------
  -- Table structure for cmf_portal_tag_post
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_portal_tag_post`;
  CREATE TABLE `cmf_portal_tag_post` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `tag_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '标签 id',
    `post_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '文章 id',
    `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:发布;0:不发布',
    PRIMARY KEY (`id`),
    KEY `post_id` (`post_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='portal应用 标签文章对应表';
  
  -- ----------------------------
  -- Records of cmf_portal_tag_post
  -- ----------------------------
  INSERT INTO `cmf_portal_tag_post` VALUES ('1', '8', '7', '1');
  
  -- ----------------------------
  -- Table structure for cmf_recycle_bin
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_recycle_bin`;
  CREATE TABLE `cmf_recycle_bin` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `object_id` int(11) DEFAULT '0' COMMENT '删除内容 id',
    `create_time` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
    `table_name` varchar(60) DEFAULT '' COMMENT '删除内容所在表名',
    `name` varchar(255) DEFAULT '' COMMENT '删除内容名称',
    `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT=' 回收站';
  
  -- ----------------------------
  -- Records of cmf_recycle_bin
  -- ----------------------------
  INSERT INTO `cmf_recycle_bin` VALUES ('1', '7', '1528073001', 'slide', '服务详情', '0');
  INSERT INTO `cmf_recycle_bin` VALUES ('2', '40', '1529639782', 'portal_post#page', 'test', '0');
  
  -- ----------------------------
  -- Table structure for cmf_role
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_role`;
  CREATE TABLE `cmf_role` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父角色ID',
    `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态;0:禁用;1:正常',
    `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
    `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
    `list_order` float NOT NULL DEFAULT '0' COMMENT '排序',
    `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '角色名称',
    `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
    PRIMARY KEY (`id`),
    KEY `parent_id` (`parent_id`),
    KEY `status` (`status`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='角色表';
  
  -- ----------------------------
  -- Records of cmf_role
  -- ----------------------------
  INSERT INTO `cmf_role` VALUES ('1', '0', '1', '1329633709', '1329633709', '0', '超级管理员', '拥有网站最高管理员权限！');
  INSERT INTO `cmf_role` VALUES ('2', '0', '1', '1329633709', '1329633709', '0', '普通管理员', '权限由最高管理员分配！');
  
  -- ----------------------------
  -- Table structure for cmf_role_user
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_role_user`;
  CREATE TABLE `cmf_role_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `role_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '角色 id',
    `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
    PRIMARY KEY (`id`),
    KEY `role_id` (`role_id`),
    KEY `user_id` (`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色对应表';
  
  -- ----------------------------
  -- Records of cmf_role_user
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cmf_route
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_route`;
  CREATE TABLE `cmf_route` (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '路由id',
    `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
    `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态;1:启用,0:不启用',
    `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'URL规则类型;1:用户自定义;2:别名添加',
    `full_url` varchar(255) NOT NULL DEFAULT '' COMMENT '完整url',
    `url` varchar(255) NOT NULL DEFAULT '' COMMENT '实际显示的url',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COMMENT='url路由表';
  
  -- ----------------------------
  -- Records of cmf_route
  -- ----------------------------
  INSERT INTO `cmf_route` VALUES ('1', '5000', '1', '2', 'portal/Page/index?id=2', 'About-us');
  INSERT INTO `cmf_route` VALUES ('2', '5000', '1', '2', 'portal/Page/index?id=3', 'Company-news');
  INSERT INTO `cmf_route` VALUES ('3', '5000', '1', '2', 'portal/Page/index?id=4', 'Recruitment-center');
  INSERT INTO `cmf_route` VALUES ('4', '5000', '1', '2', 'portal/Page/index?id=5', 'Contact-us');
  INSERT INTO `cmf_route` VALUES ('5', '5000', '1', '2', 'portal/Page/index?id=6', 'Service-intro');
  INSERT INTO `cmf_route` VALUES ('6', '5000', '1', '2', 'portal/List/index?id=1', 'Company-news');
  INSERT INTO `cmf_route` VALUES ('7', '4999', '1', '2', 'portal/Article/index?cid=1', 'Company-news/:id');
  INSERT INTO `cmf_route` VALUES ('8', '5000', '1', '2', 'portal/List/index?id=2', 'Recruitment-center2');
  INSERT INTO `cmf_route` VALUES ('9', '4999', '1', '2', 'portal/Article/index?cid=2', 'Recruitment-center2/:id');
  INSERT INTO `cmf_route` VALUES ('10', '5000', '1', '2', 'portal/List/index?id=3', 'Recruitment-centers');
  INSERT INTO `cmf_route` VALUES ('11', '4999', '1', '2', 'portal/Article/index?cid=3', 'Recruitment-centers/:id');
  INSERT INTO `cmf_route` VALUES ('12', '5000', '1', '2', 'portal/List/index?id=4', 'Recruitment-center');
  INSERT INTO `cmf_route` VALUES ('13', '4999', '1', '2', 'portal/Article/index?cid=4', 'Recruitment-center/:id');
  INSERT INTO `cmf_route` VALUES ('14', '5000', '1', '2', 'portal/Page/index?id=40', 'test');
  INSERT INTO `cmf_route` VALUES ('15', '5000', '1', '2', 'portal/Page/index?id=41', 'about-company');
  INSERT INTO `cmf_route` VALUES ('16', '5000', '1', '2', 'portal/Page/index?id=43', 'about-staff');
  INSERT INTO `cmf_route` VALUES ('17', '5000', '1', '2', 'portal/Page/index?id=42', 'about-enterprise');
  INSERT INTO `cmf_route` VALUES ('18', '5000', '1', '2', 'portal/Page/index?id=18', 'ktwx');
  INSERT INTO `cmf_route` VALUES ('19', '5000', '1', '2', 'portal/Page/index?id=19', 'yyjwx');
  INSERT INTO `cmf_route` VALUES ('20', '5000', '1', '2', 'portal/Page/index?id=20', 'xyjwx');
  INSERT INTO `cmf_route` VALUES ('21', '5000', '1', '2', 'portal/Page/index?id=21', 'bxwx');
  INSERT INTO `cmf_route` VALUES ('22', '5000', '1', '2', 'portal/Page/index?id=22', 'dsjwx');
  INSERT INTO `cmf_route` VALUES ('23', '5000', '1', '2', 'portal/Page/index?id=23', 'rsqwx');
  INSERT INTO `cmf_route` VALUES ('24', '5000', '1', '2', 'portal/Page/index?id=24', 'zdg');
  INSERT INTO `cmf_route` VALUES ('25', '5000', '1', '2', 'portal/Page/index?id=25', 'rcbj');
  INSERT INTO `cmf_route` VALUES ('26', '5000', '1', '2', 'portal/Page/index?id=26', 'xjkh');
  INSERT INTO `cmf_route` VALUES ('27', '5000', '1', '2', 'portal/Page/index?id=27', 'jjby');
  INSERT INTO `cmf_route` VALUES ('28', '5000', '1', '2', 'portal/Page/index?id=15', 'ktqx');
  INSERT INTO `cmf_route` VALUES ('29', '5000', '1', '2', 'portal/Page/index?id=16', 'yyjqx');
  INSERT INTO `cmf_route` VALUES ('30', '5000', '1', '2', 'portal/Page/index?id=17', 'xyjqx');
  
  -- ----------------------------
  -- Table structure for cmf_slide
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_slide`;
  CREATE TABLE `cmf_slide` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:显示,0不显示',
    `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
    `name` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '幻灯片分类',
    `remark` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '分类备注',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='幻灯片表';
  
  -- ----------------------------
  -- Records of cmf_slide
  -- ----------------------------
  INSERT INTO `cmf_slide` VALUES ('1', '1', '0', '首页banner', '');
  INSERT INTO `cmf_slide` VALUES ('2', '1', '0', '关于我们banner', '');
  INSERT INTO `cmf_slide` VALUES ('3', '1', '0', '公司动态banner', '');
  INSERT INTO `cmf_slide` VALUES ('4', '1', '0', '联系我们banner', '');
  INSERT INTO `cmf_slide` VALUES ('5', '1', '0', '招聘中心banner', '');
  INSERT INTO `cmf_slide` VALUES ('6', '1', '0', '服务介绍banner', '');
  INSERT INTO `cmf_slide` VALUES ('7', '1', '1528073001', '服务详情', '');
  
  -- ----------------------------
  -- Table structure for cmf_slide_item
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_slide_item`;
  CREATE TABLE `cmf_slide_item` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `slide_id` int(11) NOT NULL DEFAULT '0' COMMENT '幻灯片id',
    `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态,1:显示;0:隐藏',
    `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
    `title` varchar(50) NOT NULL DEFAULT '' COMMENT '幻灯片名称',
    `image` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '幻灯片图片',
    `url` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '幻灯片链接',
    `target` varchar(10) NOT NULL DEFAULT '' COMMENT '友情链接打开方式',
    `description` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '幻灯片描述',
    `content` text CHARACTER SET utf8 COMMENT '幻灯片内容',
    `more` text COMMENT '链接打开方式',
    PRIMARY KEY (`id`),
    KEY `slide_id` (`slide_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='幻灯片子项表';
  
  -- ----------------------------
  -- Records of cmf_slide_item
  -- ----------------------------
  INSERT INTO `cmf_slide_item` VALUES ('3', '3', '1', '10000', '公司动态banner', 'admin/20180628/9019d07f17ec6831b26d361c11be12e0.jpg', '', '', '', '', null);
  INSERT INTO `cmf_slide_item` VALUES ('4', '4', '1', '10000', '联系我们', 'admin/20180628/9019d07f17ec6831b26d361c11be12e0.jpg', '', '', '', '', null);
  INSERT INTO `cmf_slide_item` VALUES ('5', '5', '1', '10000', '招聘', 'admin/20180628/9019d07f17ec6831b26d361c11be12e0.jpg', '', '', '', '', null);
  INSERT INTO `cmf_slide_item` VALUES ('6', '6', '1', '10000', '服务介绍', 'admin/20180628/9019d07f17ec6831b26d361c11be12e0.jpg', '', '', '', '', null);
  INSERT INTO `cmf_slide_item` VALUES ('7', '1', '1', '10000', '1', 'admin/20180629/2368a5d8d38448b0e4b3d91adc657c37.jpg', '', '', '', '', null);
  INSERT INTO `cmf_slide_item` VALUES ('8', '1', '1', '10000', '2', 'admin/20180629/f68b0e4b0633890a4a69c78c9709069d.png', '', '', '', '', null);
  INSERT INTO `cmf_slide_item` VALUES ('9', '1', '1', '10000', '3', 'admin/20180606/6ca71f675cabf16c81cfa17d30fed452.png', '', '', '', '', null);
  INSERT INTO `cmf_slide_item` VALUES ('10', '2', '1', '10000', '关于我们', 'admin/20180628/9019d07f17ec6831b26d361c11be12e0.jpg', '', '', '', '', null);
  
  -- ----------------------------
  -- Table structure for cmf_theme
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_theme`;
  CREATE TABLE `cmf_theme` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '安装时间',
    `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后升级时间',
    `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '模板状态,1:正在使用;0:未使用',
    `is_compiled` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否为已编译模板',
    `theme` varchar(20) NOT NULL DEFAULT '' COMMENT '主题目录名，用于主题的维一标识',
    `name` varchar(20) NOT NULL DEFAULT '' COMMENT '主题名称',
    `version` varchar(20) NOT NULL DEFAULT '' COMMENT '主题版本号',
    `demo_url` varchar(50) NOT NULL DEFAULT '' COMMENT '演示地址，带协议',
    `thumbnail` varchar(100) NOT NULL DEFAULT '' COMMENT '缩略图',
    `author` varchar(20) NOT NULL DEFAULT '' COMMENT '主题作者',
    `author_url` varchar(50) NOT NULL DEFAULT '' COMMENT '作者网站链接',
    `lang` varchar(10) NOT NULL DEFAULT '' COMMENT '支持语言',
    `keywords` varchar(50) NOT NULL DEFAULT '' COMMENT '主题关键字',
    `description` varchar(100) NOT NULL DEFAULT '' COMMENT '主题描述',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of cmf_theme
  -- ----------------------------
  INSERT INTO `cmf_theme` VALUES ('1', '0', '0', '0', '0', 'simpleboot3', 'simpleboot3', '1.0.2', 'http://demo.thinkcmf.com', '', 'ThinkCMF', 'http://www.thinkcmf.com', 'zh-cn', 'ThinkCMF模板', 'ThinkCMF默认模板');
  INSERT INTO `cmf_theme` VALUES ('2', '0', '0', '0', '0', 'simpleboot4', 'simpleboot4', '1.0.2', 'http://demo.thinkcmf.com', '', 'ThinkCMF', 'http://www.thinkcmf.com', 'zh-cn', 'ThinkCMF模板', 'ThinkCMF默认模板');
  
  -- ----------------------------
  -- Table structure for cmf_theme_file
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_theme_file`;
  CREATE TABLE `cmf_theme_file` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `is_public` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否公共的模板文件',
    `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
    `theme` varchar(20) NOT NULL DEFAULT '' COMMENT '模板名称',
    `name` varchar(20) NOT NULL DEFAULT '' COMMENT '模板文件名',
    `action` varchar(50) NOT NULL DEFAULT '' COMMENT '操作',
    `file` varchar(50) NOT NULL DEFAULT '' COMMENT '模板文件，相对于模板根目录，如Portal/index.html',
    `description` varchar(100) NOT NULL DEFAULT '' COMMENT '模板文件描述',
    `more` text COMMENT '模板更多配置,用户自己后台设置的',
    `config_more` text COMMENT '模板更多配置,来源模板的配置文件',
    `draft_more` text COMMENT '模板更多配置,用户临时保存的配置',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of cmf_theme_file
  -- ----------------------------
  INSERT INTO `cmf_theme_file` VALUES ('1', '0', '10', 'simpleboot3', '文章页', 'portal/Article/index', 'portal/article', '文章页模板文件', '{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}', '{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('2', '0', '10', 'simpleboot3', '联系我们页', 'portal/Page/index', 'portal/contact', '联系我们页模板文件', '{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"ThinkCMF<br\\/><span class=\'\'>\\u5730\\u5740\\uff1a\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def2601\\u53f7<\\/span>\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_cn\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"value\":\"\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def0001\\u53f7\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_en\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"NO.0001 Xie Tu Road, Shanghai China\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"value\":\"catman@thinkcmf.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_cn\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"value\":\"021 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_en\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"+8621 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"qq\":{\"title\":\"\\u8054\\u7cfbQQ\",\"value\":\"478519726\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}}}}', '{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"ThinkCMF<br\\/><span class=\'\'>\\u5730\\u5740\\uff1a\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def2601\\u53f7<\\/span>\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_cn\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"value\":\"\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def0001\\u53f7\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_en\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"NO.0001 Xie Tu Road, Shanghai China\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"value\":\"catman@thinkcmf.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_cn\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"value\":\"021 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_en\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"+8621 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"qq\":{\"title\":\"\\u8054\\u7cfbQQ\",\"value\":\"478519726\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('3', '0', '5', 'simpleboot3', '首页', 'portal/Index/index', 'portal/index', '首页模板文件', '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"features\":{\"title\":\"\\u5feb\\u901f\\u4e86\\u89e3ThinkCMF\",\"display\":\"1\",\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Quickly understand the ThinkCMF\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"features\":{\"title\":\"\\u7279\\u6027\\u4ecb\\u7ecd\",\"value\":[{\"title\":\"MVC\\u5206\\u5c42\\u6a21\\u5f0f\",\"icon\":\"bars\",\"content\":\"\\u4f7f\\u7528MVC\\u5e94\\u7528\\u7a0b\\u5e8f\\u88ab\\u5206\\u6210\\u4e09\\u4e2a\\u6838\\u5fc3\\u90e8\\u4ef6\\uff1a\\u6a21\\u578b\\uff08M\\uff09\\u3001\\u89c6\\u56fe\\uff08V\\uff09\\u3001\\u63a7\\u5236\\u5668\\uff08C\\uff09\\uff0c\\u4ed6\\u4e0d\\u662f\\u4e00\\u4e2a\\u65b0\\u7684\\u6982\\u5ff5\\uff0c\\u53ea\\u662fThinkCMF\\u5c06\\u5176\\u53d1\\u6325\\u5230\\u4e86\\u6781\\u81f4\\u3002\"},{\"title\":\"\\u7528\\u6237\\u7ba1\\u7406\",\"icon\":\"group\",\"content\":\"ThinkCMF\\u5185\\u7f6e\\u4e86\\u7075\\u6d3b\\u7684\\u7528\\u6237\\u7ba1\\u7406\\u65b9\\u5f0f\\uff0c\\u5e76\\u53ef\\u76f4\\u63a5\\u4e0e\\u7b2c\\u4e09\\u65b9\\u7ad9\\u70b9\\u8fdb\\u884c\\u4e92\\u8054\\u4e92\\u901a\\uff0c\\u5982\\u679c\\u4f60\\u613f\\u610f\\u751a\\u81f3\\u53ef\\u4ee5\\u5bf9\\u5355\\u4e2a\\u7528\\u6237\\u6216\\u7fa4\\u4f53\\u7528\\u6237\\u7684\\u884c\\u4e3a\\u8fdb\\u884c\\u8bb0\\u5f55\\u53ca\\u5206\\u4eab\\uff0c\\u4e3a\\u60a8\\u7684\\u8fd0\\u8425\\u51b3\\u7b56\\u63d0\\u4f9b\\u6709\\u6548\\u53c2\\u8003\\u6570\\u636e\\u3002\"},{\"title\":\"\\u4e91\\u7aef\\u90e8\\u7f72\",\"icon\":\"cloud\",\"content\":\"\\u901a\\u8fc7\\u9a71\\u52a8\\u7684\\u65b9\\u5f0f\\u53ef\\u4ee5\\u8f7b\\u677e\\u652f\\u6301\\u4e91\\u5e73\\u53f0\\u7684\\u90e8\\u7f72\\uff0c\\u8ba9\\u4f60\\u7684\\u7f51\\u7ad9\\u65e0\\u7f1d\\u8fc1\\u79fb\\uff0c\\u5185\\u7f6e\\u5df2\\u7ecf\\u652f\\u6301SAE\\u3001BAE\\uff0c\\u6b63\\u5f0f\\u7248\\u5c06\\u5bf9\\u4e91\\u7aef\\u90e8\\u7f72\\u8fdb\\u884c\\u8fdb\\u4e00\\u6b65\\u4f18\\u5316\\u3002\"},{\"title\":\"\\u5b89\\u5168\\u7b56\\u7565\",\"icon\":\"heart\",\"content\":\"\\u63d0\\u4f9b\\u7684\\u7a33\\u5065\\u7684\\u5b89\\u5168\\u7b56\\u7565\\uff0c\\u5305\\u62ec\\u5907\\u4efd\\u6062\\u590d\\uff0c\\u5bb9\\u9519\\uff0c\\u9632\\u6cbb\\u6076\\u610f\\u653b\\u51fb\\u767b\\u9646\\uff0c\\u7f51\\u9875\\u9632\\u7be1\\u6539\\u7b49\\u591a\\u9879\\u5b89\\u5168\\u7ba1\\u7406\\u529f\\u80fd\\uff0c\\u4fdd\\u8bc1\\u7cfb\\u7edf\\u5b89\\u5168\\uff0c\\u53ef\\u9760\\uff0c\\u7a33\\u5b9a\\u7684\\u8fd0\\u884c\\u3002\"},{\"title\":\"\\u5e94\\u7528\\u6a21\\u5757\\u5316\",\"icon\":\"cubes\",\"content\":\"\\u63d0\\u51fa\\u5168\\u65b0\\u7684\\u5e94\\u7528\\u6a21\\u5f0f\\u8fdb\\u884c\\u6269\\u5c55\\uff0c\\u4e0d\\u7ba1\\u662f\\u4f60\\u5f00\\u53d1\\u4e00\\u4e2a\\u5c0f\\u529f\\u80fd\\u8fd8\\u662f\\u4e00\\u4e2a\\u5168\\u65b0\\u7684\\u7ad9\\u70b9\\uff0c\\u5728ThinkCMF\\u4e2d\\u4f60\\u53ea\\u662f\\u589e\\u52a0\\u4e86\\u4e00\\u4e2aAPP\\uff0c\\u6bcf\\u4e2a\\u72ec\\u7acb\\u8fd0\\u884c\\u4e92\\u4e0d\\u5f71\\u54cd\\uff0c\\u4fbf\\u4e8e\\u7075\\u6d3b\\u6269\\u5c55\\u548c\\u4e8c\\u6b21\\u5f00\\u53d1\\u3002\"},{\"title\":\"\\u514d\\u8d39\\u5f00\\u6e90\",\"icon\":\"certificate\",\"content\":\"\\u4ee3\\u7801\\u9075\\u5faaApache2\\u5f00\\u6e90\\u534f\\u8bae\\uff0c\\u514d\\u8d39\\u4f7f\\u7528\\uff0c\\u5bf9\\u5546\\u4e1a\\u7528\\u6237\\u4e5f\\u65e0\\u4efb\\u4f55\\u9650\\u5236\\u3002\"}],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"icon\":{\"title\":\"\\u56fe\\u6807\",\"value\":\"\",\"type\":\"text\"},\"content\":{\"title\":\"\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}},\"last_news\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"display\":\"1\",\"vars\":{\"last_news_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"features\":{\"title\":\"\\u5feb\\u901f\\u4e86\\u89e3ThinkCMF\",\"display\":\"1\",\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Quickly understand the ThinkCMF\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"features\":{\"title\":\"\\u7279\\u6027\\u4ecb\\u7ecd\",\"value\":[{\"title\":\"MVC\\u5206\\u5c42\\u6a21\\u5f0f\",\"icon\":\"bars\",\"content\":\"\\u4f7f\\u7528MVC\\u5e94\\u7528\\u7a0b\\u5e8f\\u88ab\\u5206\\u6210\\u4e09\\u4e2a\\u6838\\u5fc3\\u90e8\\u4ef6\\uff1a\\u6a21\\u578b\\uff08M\\uff09\\u3001\\u89c6\\u56fe\\uff08V\\uff09\\u3001\\u63a7\\u5236\\u5668\\uff08C\\uff09\\uff0c\\u4ed6\\u4e0d\\u662f\\u4e00\\u4e2a\\u65b0\\u7684\\u6982\\u5ff5\\uff0c\\u53ea\\u662fThinkCMF\\u5c06\\u5176\\u53d1\\u6325\\u5230\\u4e86\\u6781\\u81f4\\u3002\"},{\"title\":\"\\u7528\\u6237\\u7ba1\\u7406\",\"icon\":\"group\",\"content\":\"ThinkCMF\\u5185\\u7f6e\\u4e86\\u7075\\u6d3b\\u7684\\u7528\\u6237\\u7ba1\\u7406\\u65b9\\u5f0f\\uff0c\\u5e76\\u53ef\\u76f4\\u63a5\\u4e0e\\u7b2c\\u4e09\\u65b9\\u7ad9\\u70b9\\u8fdb\\u884c\\u4e92\\u8054\\u4e92\\u901a\\uff0c\\u5982\\u679c\\u4f60\\u613f\\u610f\\u751a\\u81f3\\u53ef\\u4ee5\\u5bf9\\u5355\\u4e2a\\u7528\\u6237\\u6216\\u7fa4\\u4f53\\u7528\\u6237\\u7684\\u884c\\u4e3a\\u8fdb\\u884c\\u8bb0\\u5f55\\u53ca\\u5206\\u4eab\\uff0c\\u4e3a\\u60a8\\u7684\\u8fd0\\u8425\\u51b3\\u7b56\\u63d0\\u4f9b\\u6709\\u6548\\u53c2\\u8003\\u6570\\u636e\\u3002\"},{\"title\":\"\\u4e91\\u7aef\\u90e8\\u7f72\",\"icon\":\"cloud\",\"content\":\"\\u901a\\u8fc7\\u9a71\\u52a8\\u7684\\u65b9\\u5f0f\\u53ef\\u4ee5\\u8f7b\\u677e\\u652f\\u6301\\u4e91\\u5e73\\u53f0\\u7684\\u90e8\\u7f72\\uff0c\\u8ba9\\u4f60\\u7684\\u7f51\\u7ad9\\u65e0\\u7f1d\\u8fc1\\u79fb\\uff0c\\u5185\\u7f6e\\u5df2\\u7ecf\\u652f\\u6301SAE\\u3001BAE\\uff0c\\u6b63\\u5f0f\\u7248\\u5c06\\u5bf9\\u4e91\\u7aef\\u90e8\\u7f72\\u8fdb\\u884c\\u8fdb\\u4e00\\u6b65\\u4f18\\u5316\\u3002\"},{\"title\":\"\\u5b89\\u5168\\u7b56\\u7565\",\"icon\":\"heart\",\"content\":\"\\u63d0\\u4f9b\\u7684\\u7a33\\u5065\\u7684\\u5b89\\u5168\\u7b56\\u7565\\uff0c\\u5305\\u62ec\\u5907\\u4efd\\u6062\\u590d\\uff0c\\u5bb9\\u9519\\uff0c\\u9632\\u6cbb\\u6076\\u610f\\u653b\\u51fb\\u767b\\u9646\\uff0c\\u7f51\\u9875\\u9632\\u7be1\\u6539\\u7b49\\u591a\\u9879\\u5b89\\u5168\\u7ba1\\u7406\\u529f\\u80fd\\uff0c\\u4fdd\\u8bc1\\u7cfb\\u7edf\\u5b89\\u5168\\uff0c\\u53ef\\u9760\\uff0c\\u7a33\\u5b9a\\u7684\\u8fd0\\u884c\\u3002\"},{\"title\":\"\\u5e94\\u7528\\u6a21\\u5757\\u5316\",\"icon\":\"cubes\",\"content\":\"\\u63d0\\u51fa\\u5168\\u65b0\\u7684\\u5e94\\u7528\\u6a21\\u5f0f\\u8fdb\\u884c\\u6269\\u5c55\\uff0c\\u4e0d\\u7ba1\\u662f\\u4f60\\u5f00\\u53d1\\u4e00\\u4e2a\\u5c0f\\u529f\\u80fd\\u8fd8\\u662f\\u4e00\\u4e2a\\u5168\\u65b0\\u7684\\u7ad9\\u70b9\\uff0c\\u5728ThinkCMF\\u4e2d\\u4f60\\u53ea\\u662f\\u589e\\u52a0\\u4e86\\u4e00\\u4e2aAPP\\uff0c\\u6bcf\\u4e2a\\u72ec\\u7acb\\u8fd0\\u884c\\u4e92\\u4e0d\\u5f71\\u54cd\\uff0c\\u4fbf\\u4e8e\\u7075\\u6d3b\\u6269\\u5c55\\u548c\\u4e8c\\u6b21\\u5f00\\u53d1\\u3002\"},{\"title\":\"\\u514d\\u8d39\\u5f00\\u6e90\",\"icon\":\"certificate\",\"content\":\"\\u4ee3\\u7801\\u9075\\u5faaApache2\\u5f00\\u6e90\\u534f\\u8bae\\uff0c\\u514d\\u8d39\\u4f7f\\u7528\\uff0c\\u5bf9\\u5546\\u4e1a\\u7528\\u6237\\u4e5f\\u65e0\\u4efb\\u4f55\\u9650\\u5236\\u3002\"}],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"icon\":{\"title\":\"\\u56fe\\u6807\",\"value\":\"\",\"type\":\"text\"},\"content\":{\"title\":\"\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}},\"last_news\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"display\":\"1\",\"vars\":{\"last_news_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('4', '0', '10', 'simpleboot3', '文章列表页', 'portal/List/index', 'portal/list', '文章列表模板文件', '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('5', '0', '10', 'simpleboot3', '单页面', 'portal/Page/index', 'portal/page', '单页面模板文件', '{\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', '{\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('6', '0', '10', 'simpleboot3', '搜索页面', 'portal/search/index', 'portal/search', '搜索模板文件', '{\"vars\":{\"varName1\":{\"title\":\"\\u70ed\\u95e8\\u641c\\u7d22\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8fd9\\u662f\\u4e00\\u4e2atext\",\"rule\":{\"require\":true}}}}', '{\"vars\":{\"varName1\":{\"title\":\"\\u70ed\\u95e8\\u641c\\u7d22\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8fd9\\u662f\\u4e00\\u4e2atext\",\"rule\":{\"require\":true}}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('7', '1', '0', 'simpleboot3', '模板全局配置', 'public/Config', 'public/config', '模板全局配置文件', '{\"vars\":{\"enable_mobile\":{\"title\":\"\\u624b\\u673a\\u6ce8\\u518c\",\"value\":1,\"type\":\"select\",\"options\":{\"1\":\"\\u5f00\\u542f\",\"0\":\"\\u5173\\u95ed\"},\"tip\":\"\"}}}', '{\"vars\":{\"enable_mobile\":{\"title\":\"\\u624b\\u673a\\u6ce8\\u518c\",\"value\":1,\"type\":\"select\",\"options\":{\"1\":\"\\u5f00\\u542f\",\"0\":\"\\u5173\\u95ed\"},\"tip\":\"\"}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('8', '1', '1', 'simpleboot3', '导航条', 'public/Nav', 'public/nav', '导航条模板文件', '{\"vars\":{\"company_name\":{\"title\":\"\\u516c\\u53f8\\u540d\\u79f0\",\"name\":\"company_name\",\"value\":\"ThinkCMF\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}', '{\"vars\":{\"company_name\":{\"title\":\"\\u516c\\u53f8\\u540d\\u79f0\",\"name\":\"company_name\",\"value\":\"ThinkCMF\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('9', '0', '10', 'simpleboot4', '文章页', 'portal/Article/index', 'portal/article', '文章页模板文件', '{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}', '{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('10', '0', '10', 'simpleboot4', '联系我们页', 'portal/Page/index', 'portal/contact', '联系我们页模板文件', '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"4\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true},\"valueText\":\"\\u8054\\u7cfb\\u6211\\u4eecbanner\"},\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"\\u8c46\\u82bd\\u4e4b\\u5bb6&lt;br\\/&gt;&lt;span class=\'\'&gt;\\u5730\\u5740\\uff1a\\u5357\\u5b81\\u5e02\\u9752\\u79c0\\u533a\\u53a2\\u7af9\\u5927\\u90535\\u53f7\\u4e30\\u6cfdSOHO\\u5927\\u53a61\\u697c109\\u5546\\u94fa&lt;\\/span&gt;\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"108.384746,22.822478\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u5e7f\\u897f\\u58ee\\u65cf\\u81ea\\u6cbb\\u533a\\u5357\\u5b81\\u5e02\\u9752\\u79c0\\u533a\\u53a2\\u7af9\\u5927\\u90535\\u53f7\"},\"address_cn\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"value\":\"\\u5357\\u5b81\\u5e02\\u9752\\u79c0\\u533a\\u53a2\\u7af9\\u5927\\u90535\\u53f7\\u4e30\\u6cfdSOHO-109\\u5546\\u94fa\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"value\":\"3294476964@qq.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_cn\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"value\":\"0771-5858185\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}}}}', '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}},\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"\\u8c46\\u82bd\\u4e4b\\u5bb6<br\\/><span class=\'\'>\\u5730\\u5740\\uff1a\\u53a2\\u7af9\\u5927\\u90535\\u53f7\\u4e30\\u6cfdSOHO\\u5927\\u53a61\\u697c109\\u5546\\u94fa<\\/span>\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_location\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"location\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_cn\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"value\":\" \",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"value\":\"catman@thinkcmf.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phone_cn\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"value\":\"021 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('11', '0', '5', 'simpleboot4', '首页', 'portal/Index/index', 'portal/index', '首页模板文件', '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"1\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true},\"valueText\":\"\\u9996\\u9875banner\"}},\"widgets\":{\"features\":{\"title\":\"\\u4e3b\\u8425\\u4e1a\\u52a1\",\"display\":1,\"vars\":{\"features\":{\"title\":\"\\u5185\\u5bb9\",\"value\":[{\"title\":\"\\u5bb6\\u7535\\u7ef4\\u4fee\",\"icon\":\"\",\"content\":\"\\u4ef7\\u683c\\u900f\\u660e\\uff0c\\u8d28\\u91cf\\u4fdd\\u8bc1\\uff0c\\u4e0d\\u6210\\u4ea4\\u4e0d\\u6536\\u53d6\\u4efb\\u4f55\\u8d39\\u7528\"},{\"title\":\"\\u5bb6\\u653f\\u4fdd\\u6d01\",\"icon\":\"\",\"content\":\"\\u5bb6\\u52a1\\u6709\\u6211\\uff0c\\u4f60\\u53bb\\u505a\\u4f60\\u60f3\\u505a\\u7684\\u4e8b\"},{\"title\":\"\\u5bb6\\u7535\\u6e05\\u6d17\",\"icon\":\"\",\"content\":\"\\u5efa\\u8bae\\u6bcf\\u5e74\\u4ea4\\u7531\\u4e13\\u4e1a\\u4eba\\u5458\\u6e05\\u6d17\\u4e00\\u6b21\"},{\"title\":\"\\u5bb6\\u5ead\\u88c5\\u4fee\",\"icon\":\"\",\"content\":\"\\u5305\\u8bbe\\u8ba1\\uff0c\\u5305\\u65bd\\u5de5\\uff0c\\u5305\\u4e3b\\u6750\\uff0c\\u5305\\u552e\\u540e\"},{\"title\":\"\\u7a7a\\u6c14\\u6cbb\\u7406\",\"icon\":\"\",\"content\":\"\\u670d\\u52a1\\u5373\\u5c06\\u4e0a\\u7ebf\"},{\"title\":\"\\u4fee\\u9501\\u6362\\u9501\",\"icon\":\"\",\"content\":\"\\u670d\\u52a1\\u5373\\u5c06\\u4e0a\\u7ebf\"}],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"icon\":{\"title\":\"\\u56fe\\u6807\",\"value\":\"\",\"type\":\"text\"},\"content\":{\"title\":\"\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}},\"last_news\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"display\":\"1\",\"vars\":{\"last_news_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"features\":{\"title\":\"\\u8054\\u7cfb\\u6211\\u4eec\",\"display\":\"1\",\"vars\":{\"features\":{\"title\":\"\\u5185\\u5bb9\",\"value\":[{\"title\":\"\",\"icon\":\"\",\"content\":\"\"},{\"title\":\"\",\"icon\":\"\",\"content\":\"\"},{\"title\":\"\",\"icon\":\"\",\"content\":\"\"},{\"title\":\"\",\"icon\":\"\",\"content\":\"\"},{\"title\":\"\",\"icon\":\"\",\"content\":\"\"},{\"title\":\"\",\"icon\":\"\",\"content\":\"\"}],\"type\":\"array\",\"item\":{\"title\":{\"title\":\"\\u6807\\u9898\",\"value\":\"\",\"type\":\"text\",\"rule\":{\"require\":true}},\"icon\":{\"title\":\"\\u56fe\\u6807\",\"value\":\"\",\"type\":\"text\"},\"content\":{\"title\":\"\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}},\"last_news\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"display\":\"1\",\"vars\":{\"last_news_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('12', '0', '10', 'simpleboot4', '文章列表页', 'portal/List/index', 'portal/list', '文章列表模板文件', '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('13', '0', '10', 'simpleboot4', '单页面', 'portal/Page/index', 'portal/page', '单页面模板文件', '{\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', '{\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('14', '0', '10', 'simpleboot4', '搜索页面', 'portal/search/index', 'portal/search', '搜索模板文件', '{\"vars\":{\"varName1\":{\"title\":\"\\u70ed\\u95e8\\u641c\\u7d22\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8fd9\\u662f\\u4e00\\u4e2atext\",\"rule\":{\"require\":true}}}}', '{\"vars\":{\"varName1\":{\"title\":\"\\u70ed\\u95e8\\u641c\\u7d22\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8fd9\\u662f\\u4e00\\u4e2atext\",\"rule\":{\"require\":true}}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('15', '1', '0', 'simpleboot4', '模板全局配置', 'public/Config', 'public/config', '模板全局配置文件', '{\"vars\":{\"enable_mobile\":{\"title\":\"\\u624b\\u673a\\u6ce8\\u518c\",\"value\":1,\"type\":\"select\",\"options\":{\"1\":\"\\u5f00\\u542f\",\"0\":\"\\u5173\\u95ed\"},\"tip\":\"\"}}}', '{\"vars\":{\"enable_mobile\":{\"title\":\"\\u624b\\u673a\\u6ce8\\u518c\",\"value\":1,\"type\":\"select\",\"options\":{\"1\":\"\\u5f00\\u542f\",\"0\":\"\\u5173\\u95ed\"},\"tip\":\"\"}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('16', '1', '1', 'simpleboot4', '导航条', 'public/Nav', 'public/nav', '导航条模板文件', '{\"vars\":{\"company_name\":{\"title\":\"\\u516c\\u53f8\\u540d\\u79f0\",\"name\":\"company_name\",\"value\":\"\\u8c46\\u82bd\\u4e4b\\u5bb6\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}', '{\"vars\":{\"company_name\":{\"title\":\"\\u516c\\u53f8\\u540d\\u79f0\",\"name\":\"company_name\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('18', '0', '10', 'simpleboot4', '单页面', 'portal/Page/index', 'portal/page-about', '单页面模板文件', '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"2\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true},\"valueText\":\"\\u5173\\u4e8e\\u6211\\u4eecbanner\"}},\"widgets\":{\"features\":{\"title\":\"\\u4e3b\\u8425\\u4e1a\\u52a1\",\"display\":\"1\",\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Main business\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"features\":{\"title\":\"\\u516c\\u53f8\\u4ecb\\u7ecd\",\"value\":[{\"content\":\"\\u5e7f\\u897f\\u5357\\u5b81\\u8c46\\u82bd\\u4e4b\\u5bb6\\uff08\\u540e\\u53f0\\u53ef\\u7f16\\u8f91\\uff09\"},{\"content\":\"\\u516c\\u53f8\\u62e5\\u6709XXXXXX\"},{\"content\":\"\\u4e3a\\u786e\\u4fddXXXXXX\\r\\n\"},{\"content\":\"\\u4f01\\u4e1a\\u5b97\\u65e8\"},{\"content\":\"\\u7ecf\\u8425\\u7406\\u5ff5\"},{\"content\":\"\\u670d\\u52a1\\u7406\\u5ff5\"}],\"type\":\"array\",\"item\":{\"content\":{\"title\":\"\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}}}}', '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"features\":{\"title\":\"\\u516c\\u53f8\\u4ecb\\u7ecd\",\"display\":\"1\",\"vars\":{\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Companies introduce\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"features\":{\"title\":\"\\u516c\\u53f8\\u4ecb\\u7ecd\",\"value\":[{\"content\":\"\"},{\"content\":\"\"},{\"content\":\"\"}],\"type\":\"array\",\"item\":{\"content\":{\"title\":\"\\u63cf\\u8ff0\",\"value\":\"\",\"type\":\"textarea\"}},\"tip\":\"\"}}}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('23', '0', '10', 'simpleboot4', '招聘中心', 'portal/Page/index', 'portal/page-re', '招聘中心模板文件', '{\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', '{\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('24', '0', '10', 'simpleboot4', '招聘页', 'portal/Article/index', 'portal/article-re', '招聘页模板', '{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}', '{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('25', '0', '10', 'simpleboot4', '文章列表页', 'portal/List/index', 'portal/list-re', '文章列表模板文件', '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"5\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true},\"valueText\":\"\\u62db\\u8058\\u4e2d\\u5fc3banner\"}},\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('26', '0', '10', 'simpleboot4', '单页面', 'portal/Page/index', 'portal/page-service', '单页面模板文件', '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"6\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true},\"valueText\":\"\\u670d\\u52a1\\u4ecb\\u7ecdbanner\"}}}', '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}}}', null);
  INSERT INTO `cmf_theme_file` VALUES ('29', '0', '10', 'simpleboot4', '服务介绍', 'portal/Page/index', 'portal/page-case', '服务介绍模板文件', '[]', '[]', null);
  
  -- ----------------------------
  -- Table structure for cmf_third_party_user
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_third_party_user`;
  CREATE TABLE `cmf_third_party_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '本站用户id',
    `last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
    `expire_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'access_token过期时间',
    `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '绑定时间',
    `login_times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录次数',
    `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态;1:正常;0:禁用',
    `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '用户昵称',
    `third_party` varchar(20) NOT NULL DEFAULT '' COMMENT '第三方惟一码',
    `app_id` varchar(64) NOT NULL DEFAULT '' COMMENT '第三方应用 id',
    `last_login_ip` varchar(15) NOT NULL DEFAULT '' COMMENT '最后登录ip',
    `access_token` varchar(512) NOT NULL DEFAULT '' COMMENT '第三方授权码',
    `openid` varchar(40) NOT NULL DEFAULT '' COMMENT '第三方用户id',
    `union_id` varchar(64) NOT NULL DEFAULT '' COMMENT '第三方用户多个产品中的惟一 id,(如:微信平台)',
    `more` text COMMENT '扩展信息',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='第三方用户表';
  
  -- ----------------------------
  -- Records of cmf_third_party_user
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cmf_user
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_user`;
  CREATE TABLE `cmf_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '用户类型;1:admin;2:会员',
    `sex` tinyint(2) NOT NULL DEFAULT '0' COMMENT '性别;0:保密,1:男,2:女',
    `birthday` int(11) NOT NULL DEFAULT '0' COMMENT '生日',
    `last_login_time` int(11) NOT NULL DEFAULT '0' COMMENT '最后登录时间',
    `score` int(11) NOT NULL DEFAULT '0' COMMENT '用户积分',
    `coin` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '金币',
    `balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
    `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间',
    `user_status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '用户状态;0:禁用,1:正常,2:未验证',
    `user_login` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名',
    `user_pass` varchar(64) NOT NULL DEFAULT '' COMMENT '登录密码;cmf_password加密',
    `user_nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户昵称',
    `user_email` varchar(100) NOT NULL DEFAULT '' COMMENT '用户登录邮箱',
    `user_url` varchar(100) NOT NULL DEFAULT '' COMMENT '用户个人网址',
    `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '用户头像',
    `signature` varchar(255) NOT NULL DEFAULT '' COMMENT '个性签名',
    `last_login_ip` varchar(15) NOT NULL DEFAULT '' COMMENT '最后登录ip',
    `user_activation_key` varchar(60) NOT NULL DEFAULT '' COMMENT '激活码',
    `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '用户手机号',
    `more` text COMMENT '扩展属性',
    PRIMARY KEY (`id`),
    KEY `user_login` (`user_login`),
    KEY `user_nickname` (`user_nickname`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';
  
  -- ----------------------------
  -- Records of cmf_user
  -- ----------------------------
  INSERT INTO `cmf_user` VALUES ('1', '1', '0', '0', '1530232686', '1', '1', '0.00', '1527044878', '1', 'admin', '###9a62fad234a981f36575c7b0ce7353ff', 'admin', 'test@qq.com', '', '', '', '127.0.0.1', '', '', null);
  
  -- ----------------------------
  -- Table structure for cmf_user_action
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_user_action`;
  CREATE TABLE `cmf_user_action` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `score` int(11) NOT NULL DEFAULT '0' COMMENT '更改积分，可以为负',
    `coin` int(11) NOT NULL DEFAULT '0' COMMENT '更改金币，可以为负',
    `reward_number` int(11) NOT NULL DEFAULT '0' COMMENT '奖励次数',
    `cycle_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '周期类型;0:不限;1:按天;2:按小时;3:永久',
    `cycle_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '周期时间值',
    `name` varchar(50) NOT NULL DEFAULT '' COMMENT '用户操作名称',
    `action` varchar(50) NOT NULL DEFAULT '' COMMENT '用户操作名称',
    `app` varchar(50) NOT NULL DEFAULT '' COMMENT '操作所在应用名或插件名等',
    `url` text COMMENT '执行操作的url',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户操作表';
  
  -- ----------------------------
  -- Records of cmf_user_action
  -- ----------------------------
  INSERT INTO `cmf_user_action` VALUES ('1', '1', '1', '1', '2', '1', '用户登录', 'login', 'user', '');
  
  -- ----------------------------
  -- Table structure for cmf_user_action_log
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_user_action_log`;
  CREATE TABLE `cmf_user_action_log` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
    `count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '访问次数',
    `last_visit_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后访问时间',
    `object` varchar(100) NOT NULL DEFAULT '' COMMENT '访问对象的id,格式:不带前缀的表名+id;如posts1表示xx_posts表里id为1的记录',
    `action` varchar(50) NOT NULL DEFAULT '' COMMENT '操作名称;格式:应用名+控制器+操作名,也可自己定义格式只要不发生冲突且惟一;',
    `ip` varchar(15) NOT NULL DEFAULT '' COMMENT '用户ip',
    PRIMARY KEY (`id`),
    KEY `user_object_action` (`user_id`,`object`,`action`),
    KEY `user_object_action_ip` (`user_id`,`object`,`action`,`ip`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='访问记录表';
  
  -- ----------------------------
  -- Records of cmf_user_action_log
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cmf_user_balance_log
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_user_balance_log`;
  CREATE TABLE `cmf_user_balance_log` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户 id',
    `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
    `change` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '更改余额',
    `balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '更改后余额',
    `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
    `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户余额变更日志表';
  
  -- ----------------------------
  -- Records of cmf_user_balance_log
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cmf_user_favorite
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_user_favorite`;
  CREATE TABLE `cmf_user_favorite` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户 id',
    `title` varchar(100) NOT NULL DEFAULT '' COMMENT '收藏内容的标题',
    `url` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '收藏内容的原文地址，不带域名',
    `description` varchar(500) CHARACTER SET utf8 DEFAULT '' COMMENT '收藏内容的描述',
    `table_name` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '收藏实体以前所在表,不带前缀',
    `object_id` int(10) unsigned DEFAULT '0' COMMENT '收藏内容原来的主键id',
    `create_time` int(10) unsigned DEFAULT '0' COMMENT '收藏时间',
    PRIMARY KEY (`id`),
    KEY `uid` (`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户收藏表';
  
  -- ----------------------------
  -- Records of cmf_user_favorite
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cmf_user_login_attempt
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_user_login_attempt`;
  CREATE TABLE `cmf_user_login_attempt` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `login_attempts` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '尝试次数',
    `attempt_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '尝试登录时间',
    `locked_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '锁定时间',
    `ip` varchar(15) NOT NULL DEFAULT '' COMMENT '用户 ip',
    `account` varchar(100) NOT NULL DEFAULT '' COMMENT '用户账号,手机号,邮箱或用户名',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='用户登录尝试表';
  
  -- ----------------------------
  -- Records of cmf_user_login_attempt
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cmf_user_score_log
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_user_score_log`;
  CREATE TABLE `cmf_user_score_log` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户 id',
    `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
    `action` varchar(50) NOT NULL DEFAULT '' COMMENT '用户操作名称',
    `score` int(11) NOT NULL DEFAULT '0' COMMENT '更改积分，可以为负',
    `coin` int(11) NOT NULL DEFAULT '0' COMMENT '更改金币，可以为负',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户操作积分等奖励日志表';
  
  -- ----------------------------
  -- Records of cmf_user_score_log
  -- ----------------------------
  INSERT INTO `cmf_user_score_log` VALUES ('1', '1', '1527045146', 'login', '1', '1');
  
  -- ----------------------------
  -- Table structure for cmf_user_token
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_user_token`;
  CREATE TABLE `cmf_user_token` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户id',
    `expire_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT ' 过期时间',
    `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
    `token` varchar(64) NOT NULL DEFAULT '' COMMENT 'token',
    `device_type` varchar(10) NOT NULL DEFAULT '' COMMENT '设备类型;mobile,android,iphone,ipad,web,pc,mac,wxapp',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户客户端登录 token 表';
  
  -- ----------------------------
  -- Records of cmf_user_token
  -- ----------------------------
  INSERT INTO `cmf_user_token` VALUES ('1', '1', '1542597082', '1527045082', 'ac4395bebebc9cafe5c1bc419276bbe9ac4395bebebc9cafe5c1bc419276bbe9', 'web');
  
  -- ----------------------------
  -- Table structure for cmf_verification_code
  -- ----------------------------
  DROP TABLE IF EXISTS `cmf_verification_code`;
  CREATE TABLE `cmf_verification_code` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '表id',
    `count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '当天已经发送成功的次数',
    `send_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后发送成功时间',
    `expire_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '验证码过期时间',
    `code` varchar(8) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '最后发送成功的验证码',
    `account` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '手机号或者邮箱',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='手机邮箱数字验证码表';
  
  -- ----------------------------
  -- Records of cmf_verification_code
  -- ----------------------------
  SET FOREIGN_KEY_CHECKS=1;
  