登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
开源项目 > 建站系统 > CMS建站系统 &&
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
7 Star 30 Fork 21

灼灼文化 / 呼啦企业网站管理系统

代码 Issues 3 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
hula_update.sql 14.05 KB
一键复制 编辑 原始数据 按行查看 历史
张阳 提交于 2021-10-28 15:38 . v3.1.6
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162
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;
PHP
1
https://gitee.com/zhuopro/hulacwms.git
git@gitee.com:zhuopro/hulacwms.git
zhuopro
hulacwms
呼啦企业网站管理系统
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部