SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `zz_admin_log`;
CREATE TABLE `zz_admin_log` (
`id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`admin_member_id`  int(11) NULL DEFAULT NULL ,
`admin_member_username`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`url`  varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '访问url' ,
`route`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '访问路由' ,
`title`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题' ,
`content`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容' ,
`ip`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'ip地址' ,
`useragent`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'useragent' ,
`create_time`  int(11) NULL DEFAULT NULL COMMENT '创建时间' ,
`delete_time`  int(11) NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
CHECKSUM=0
ROW_FORMAT=Dynamic
DELAY_KEY_WRITE=0
;


-- ----------------------------
-- Table structure for `zz_admin_menu`
-- ----------------------------
DROP TABLE IF EXISTS `zz_admin_menu`;
CREATE TABLE `zz_admin_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文档ID',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级分类ID',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序（同级有效）',
  `url` char(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `hide` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否隐藏{radio[0:显示,1:隐藏]}',
  `tip` varchar(255) NOT NULL DEFAULT '' COMMENT '提示',
  `is_dev` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否仅开发者模式可见',
  `icon` char(50) DEFAULT NULL COMMENT '菜单图标',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`),
  KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=246 DEFAULT CHARSET=utf8;

ALTER TABLE `zz_config` ADD COLUMN `issync`  tinyint(4) NOT NULL DEFAULT 0 AFTER `sort`;

ALTER TABLE `zz_document` MODIFY COLUMN `title`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标题' AFTER `name`;

ALTER TABLE `zz_document` MODIFY COLUMN `keywords`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' AFTER `category_id`;

ALTER TABLE `zz_document` MODIFY COLUMN `description`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '描述' AFTER `keywords`;

ALTER TABLE `zz_document` MODIFY COLUMN `link_str`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '外链' AFTER `istop`;

ALTER TABLE `zz_document` MODIFY COLUMN `cover_path`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '封面' AFTER `link_str`;

ALTER TABLE `zz_document` ADD COLUMN `images`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '图集' AFTER `cover_path`;

ALTER TABLE `zz_document_category` MODIFY COLUMN `name`  varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标志' AFTER `id`;

ALTER TABLE `zz_document_category` MODIFY COLUMN `title`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标题' AFTER `name`;

ALTER TABLE `zz_document_category` MODIFY COLUMN `keywords`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '关键字' AFTER `meta_title`;

ALTER TABLE `zz_document_category` MODIFY COLUMN `description`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '描述' AFTER `keywords`;

ALTER TABLE `zz_document_category` MODIFY COLUMN `link_str`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '外链' AFTER `template_detail`;

ALTER TABLE `zz_document_category` MODIFY COLUMN `icon`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分类图标' AFTER `status`;

ALTER TABLE `zz_friend_link` MODIFY COLUMN `title`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '链接网站名称' AFTER `uid`;

ALTER TABLE `zz_friend_link` MODIFY COLUMN `url`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '链接地址' AFTER `title`;

ALTER TABLE `zz_friend_link` MODIFY COLUMN `image`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '图片连接的图片' AFTER `url`;

DROP TABLE IF EXISTS `zz_admin_action`;

DROP TABLE IF EXISTS `zz_admin_action_log`;

DROP TABLE  IF EXISTS`zz_document_product`;

-- ----------------------------
-- Records of zz_admin_menu
-- ----------------------------
INSERT INTO `zz_admin_menu` VALUES ('1', '后台首页', '0', '1', 'Index/main', '0', '', '0', 'layui-icon-home', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('2', '内容管理', '0', '2', '', '0', '', '0', 'layui-icon-template-1', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('16', '后台管理', '0', '3', '', '0', '', '0', 'layui-icon-auz', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('17', '管理员信息', '16', '1', 'AdminMember/index', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('140', '友情链接', '2', '4', 'FriendLink/index', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('27', '权限管理', '16', '2', 'AdminAuthGroup/index', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('68', '系统管理', '0', '4', '', '0', '', '0', 'layui-icon-set', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('69', '网站设置', '68', '1', 'Config/groups', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('70', '配置管理', '68', '2', 'Config/index', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('75', '菜单管理', '68', '3', 'AdminMenu/index', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('218', '插件应用', '0', '5', '', '0', '', '1', 'layui-icon-app', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('219', '插件管理', '218', '0', 'Addons/index', '0', '', '1', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('195', '编辑管理员', '17', '99', 'AdminMember/edit', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('194', '启用禁用', '17', '99', 'AdminMember/set_status', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('141', '留言管理', '2', '5', 'MessageForm/index', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('136', '文章列表', '2', '1', 'Document/index', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('137', '栏目分类', '2', '2', 'DocumentCategory/index', '0', '文章分类', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('138', '新增文章', '136', '1', 'Document/add', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('139', '编辑文章', '136', '2', 'Document/edit', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('191', '启用禁用', '140', '99', 'FriendLink/enable', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('143', '添加分类', '137', '2', 'DocumentCategory/add', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('144', '编辑分类', '137', '3', 'DocumentCategory/edit', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('192', '排序', '140', '99', 'FriendLink/sort', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('146', '新增', '140', '1', 'FriendLink/add', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('147', '编辑', '140', '2', 'FriendLink/edit', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('148', '留言详情', '141', '1', 'MessageForm/details', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('149', '新增管理员', '17', '1', 'AdminMember/add', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('150', '授权', '17', '2', 'AdminMember/auth', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('151', '新增', '27', '1', 'AdminAuthGroup/add', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('152', '编辑', '27', '2', 'AdminAuthGroup/edit', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('157', '新增', '70', '1', 'Config/add', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('158', '编辑', '70', '2', 'Config/edit', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('159', '新增', '75', '1', 'AdminMenu/add', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('160', '编辑', '75', '2', 'AdminMenu/edit', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('161', '访问授权', '27', '3', 'AdminAuthGroup/access', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('162', '成员授权', '27', '4', 'AdminAuthGroup/user', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('166', '删除文章', '136', '3', 'Document/del', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('167', '删除分类', '137', '5', 'Documentcategory/del', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('168', '删除', '140', '3', 'FriendLink/del', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('169', '删除留言', '141', '2', 'MessageForm/del', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('170', '删除管理员', '17', '3', 'AdminMember/del', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('171', '删除权限', '27', '5', 'AdminAuthGroup/del', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('174', '删除配置', '70', '993', 'Config/del', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('175', '删除菜单', '75', '3', 'AdminMenu/del', '0', '', '0', '', '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('184', '显示隐藏', '136', '99', 'Document/enable', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('185', '排序', '136', '99', 'Document/sort', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('190', '显示隐藏', '137', '99', 'DocumentCategory/set_display', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('196', '修改昵称', '17', '99', 'AdminMember/nickname', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('197', '启用禁用', '27', '99', 'AdminAuthGroup/set_status', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('199', '显示隐藏', '75', '99', 'AdminMenu/hide', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('200', '排序', '75', '99', 'AdminMenu/sort', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('203', '上传附件', '16', '99', '', '1', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('204', '上传视频', '203', '99', 'Upload/video', '0', '', '1', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('205', '上传文件', '203', '99', 'Upload/file', '0', '', '1', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('206', '编辑器上传', '16', '99', 'Ueditor/index', '1', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('207', '上传图片', '206', '99', 'Ueditor/picture', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('208', '上传文件', '206', '99', 'Ueditor/file', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('209', '上传视频', '206', '99', 'Ueditor/video', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('210', '上传图片', '203', '99', 'Upload/picture', '0', '', '1', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('233', '访问日志', '218', '0', 'addons/admin_log-index-index', '0', '', '0', null, '1', '1631354905', null);
INSERT INTO `zz_admin_menu` VALUES ('234', '日志详情', '233', '0', 'addons/admin_log-index-detail', '0', '', '0', null, '1', '1631354905', null);
INSERT INTO `zz_admin_menu` VALUES ('235', '删除日志', '233', '0', 'addons/admin_log-index-del', '0', '', '0', null, '1', '1631354905', null);
INSERT INTO `zz_admin_menu` VALUES ('236', '插件配置', '219', '0', 'Addons/config', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('237', '启用禁用', '219', '0', 'Addons/enable', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('238', '安装插件', '219', '0', 'Addons/local', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('239', '删除插件', '219', '0', 'Addons/del', '0', '', '0', null, '1', '0', null);
INSERT INTO `zz_admin_menu` VALUES ('240', '备份/还原', '218', '0', 'addons/databack-index-index', '0', '', '0', null, '1', '1631357691', null);
INSERT INTO `zz_admin_menu` VALUES ('241', '优化表', '240', '0', 'addons/databack-index-optimize', '0', '', '0', null, '1', '1631357691', null);
INSERT INTO `zz_admin_menu` VALUES ('242', '修复表', '240', '0', 'addons/databack-index-repair', '0', '', '0', null, '1', '1631357691', null);
INSERT INTO `zz_admin_menu` VALUES ('243', '删除备份', '240', '0', 'addons/databack-index-del', '0', '', '0', null, '1', '1631357691', null);
INSERT INTO `zz_admin_menu` VALUES ('244', '备份数据库', '240', '0', 'addons/databack-index-export', '0', '', '0', null, '1', '1631357691', null);
INSERT INTO `zz_admin_menu` VALUES ('245', '还原数据库', '240', '0', 'addons/databack-index-import', '0', '', '0', null, '1', '1631357691', null);
INSERT INTO `zz_admin_menu` VALUES ('246', '修改管理员密码', '1', '0', 'AdminMember/resetpwd/', '1', '', '0', null, '1', '0', null);

SET FOREIGN_KEY_CHECKS=1;