short-video-back/web/gitdsp.sql

/*
 Navicat Premium Data Transfer
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cmf_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `cmf_admin_log`;
CREATE TABLE `cmf_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adminid` int(11) NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `admin` varchar(255) NOT NULL DEFAULT '' COMMENT '管理员',
  `action` text NOT NULL COMMENT '操作内容',
  `ip` bigint(20) NOT NULL DEFAULT '0' COMMENT 'IP地址',
  `addtime` int(11) NOT NULL DEFAULT '0' COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cmf_admin_log
-- ----------------------------
BEGIN;
INSERT INTO `cmf_admin_log` VALUES (1, 1, 'admin', '管理员登录', 2072465020, 1650961231);
INSERT INTO `cmf_admin_log` VALUES (2, 1, 'admin', '管理员登录', 659908154, 1650962203);
COMMIT;

-- ----------------------------
-- 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`) USING BTREE,
  KEY `status` (`status`) USING BTREE,
  KEY `parent_id` (`parent_id`) USING BTREE,
  KEY `controller` (`controller`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=451 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='后台菜单表';

-- ----------------------------
-- Records of cmf_admin_menu
-- ----------------------------
BEGIN;
INSERT INTO `cmf_admin_menu` VALUES (6, 0, 0, 1, 1, 'admin', 'Setting', 'default', '', '设置', 'cogs', '系统设置入口');
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 (49, 110, 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 (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 (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 (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, 1, 10000, 'admin', 'Setting', 'clearCache', '', '清除缓存', '', '清除缓存');
INSERT INTO `cmf_admin_menu` VALUES (110, 0, 0, 1, 2, 'user', 'AdminIndex', 'default', '', '用户管理', 'group', '用户管理');
INSERT INTO `cmf_admin_menu` VALUES (111, 49, 1, 1, 10000, 'admin', 'User', 'index', '', '管理员', '', '管理员管理');
INSERT INTO `cmf_admin_menu` VALUES (112, 111, 1, 0, 10000, 'admin', 'User', 'add', '', '管理员添加', '', '管理员添加');
INSERT INTO `cmf_admin_menu` VALUES (113, 111, 2, 0, 10000, 'admin', 'User', 'addPost', '', '管理员添加提交', '', '管理员添加提交');
INSERT INTO `cmf_admin_menu` VALUES (114, 111, 1, 0, 10000, 'admin', 'User', 'edit', '', '管理员编辑', '', '管理员编辑');
INSERT INTO `cmf_admin_menu` VALUES (115, 111, 2, 0, 10000, 'admin', 'User', 'editPost', '', '管理员编辑提交', '', '管理员编辑提交');
INSERT INTO `cmf_admin_menu` VALUES (116, 111, 1, 0, 10000, 'admin', 'User', 'userInfo', '', '个人信息', '', '管理员个人信息修改');
INSERT INTO `cmf_admin_menu` VALUES (117, 111, 2, 0, 10000, 'admin', 'User', 'userInfoPost', '', '管理员个人信息修改提交', '', '管理员个人信息修改提交');
INSERT INTO `cmf_admin_menu` VALUES (118, 111, 2, 0, 10000, 'admin', 'User', 'delete', '', '管理员删除', '', '管理员删除');
INSERT INTO `cmf_admin_menu` VALUES (119, 111, 2, 0, 10000, 'admin', 'User', 'ban', '', '停用管理员', '', '停用管理员');
INSERT INTO `cmf_admin_menu` VALUES (120, 111, 2, 0, 10000, 'admin', 'User', 'cancelBan', '', '启用管理员', '', '启用管理员');
INSERT INTO `cmf_admin_menu` VALUES (121, 0, 1, 0, 10000, 'user', 'AdminAsset', 'index', '', '资源管理', 'file', '资源管理列表');
INSERT INTO `cmf_admin_menu` VALUES (122, 121, 2, 0, 10000, 'user', 'AdminAsset', 'delete', '', '删除文件', '', '删除文件');
INSERT INTO `cmf_admin_menu` VALUES (123, 110, 0, 1, 10000, 'user', 'AdminIndex', 'default1', '', '用户组', '', '用户组');
INSERT INTO `cmf_admin_menu` VALUES (124, 123, 1, 1, 10000, 'user', 'AdminIndex', 'index', '', '本站用户', '', '本站用户');
INSERT INTO `cmf_admin_menu` VALUES (125, 124, 2, 0, 8, 'user', 'AdminIndex', 'ban', '', '本站用户拉黑', '', '本站用户拉黑');
INSERT INTO `cmf_admin_menu` VALUES (126, 124, 2, 0, 9, 'user', 'AdminIndex', 'cancelBan', '', '本站用户启用', '', '本站用户启用');
INSERT INTO `cmf_admin_menu` VALUES (133, 6, 1, 1, 10, 'admin', 'Setting', 'configpri', '', '私密设置', '', '');
INSERT INTO `cmf_admin_menu` VALUES (134, 6, 1, 1, 0, 'admin', 'Guide', 'set', '', '引导页', '', '');
INSERT INTO `cmf_admin_menu` VALUES (135, 134, 1, 0, 10000, 'admin', 'Guide', 'set_post', '', '设置提交', '', '');
INSERT INTO `cmf_admin_menu` VALUES (136, 134, 1, 0, 10000, 'admin', 'Guide', 'index', '', '管理', '', '');
INSERT INTO `cmf_admin_menu` VALUES (137, 136, 1, 0, 10000, 'admin', 'Guide', 'add', '', '添加', '', '');
INSERT INTO `cmf_admin_menu` VALUES (138, 136, 1, 0, 10000, 'admin', 'Guide', 'add_post', '', '添加提交', '', '');
INSERT INTO `cmf_admin_menu` VALUES (139, 136, 1, 0, 10000, 'admin', 'Guide', 'edit', '', '编辑', '', '');
INSERT INTO `cmf_admin_menu` VALUES (140, 136, 1, 0, 10000, 'admin', 'Guide', 'edit_post', '', '编辑提交', '', '');
INSERT INTO `cmf_admin_menu` VALUES (141, 136, 1, 0, 10000, 'admin', 'Guide', 'listorders', '', '排序', '', '');
INSERT INTO `cmf_admin_menu` VALUES (142, 136, 1, 0, 10000, 'admin', 'Guide', 'del', '', '删除', '', '');
INSERT INTO `cmf_admin_menu` VALUES (144, 0, 1, 1, 3, 'admin', 'Report', 'default', '', '用户举报', 'street-view', '');
INSERT INTO `cmf_admin_menu` VALUES (145, 144, 1, 1, 10000, 'admin', 'Report', 'classify', '', '举报分类', '', '');
INSERT INTO `cmf_admin_menu` VALUES (146, 145, 1, 0, 10000, 'admin', 'Report', 'classify_add', '', '举报分类添加', '', '');
INSERT INTO `cmf_admin_menu` VALUES (147, 145, 1, 0, 10000, 'admin', 'Report', 'classify_add_post', '', '用户举报分类添加保存', '', '');
INSERT INTO `cmf_admin_menu` VALUES (148, 145, 1, 0, 10000, 'admin', 'Report', 'classify_edit', '', '举报分类编辑', '', '');
INSERT INTO `cmf_admin_menu` VALUES (149, 145, 1, 0, 10000, 'admin', 'Report', 'classify_edit_post', '', '举报分类编辑保存', '', '');
INSERT INTO `cmf_admin_menu` VALUES (150, 145, 1, 0, 10000, 'admin', 'Report', 'classify_listorders', '', '举报分类排序', '', '');
INSERT INTO `cmf_admin_menu` VALUES (151, 145, 1, 0, 10000, 'admin', 'Report', 'classify_del', '', '举报分类删除', '', '');
INSERT INTO `cmf_admin_menu` VALUES (152, 144, 1, 1, 10000, 'admin', 'Report', 'index', '', '举报列表', '', '');
INSERT INTO `cmf_admin_menu` VALUES (153, 152, 1, 0, 10000, 'admin', 'Report', 'ban', '', '禁用用户', '', '');
INSERT INTO `cmf_admin_menu` VALUES (154, 152, 1, 0, 10000, 'admin', 'Report', 'ban_video', '', '下架视频', '', '');
INSERT INTO `cmf_admin_menu` VALUES (155, 152, 1, 0, 10000, 'admin', 'Report', 'setstatus', '', '标记处理', '', '');
INSERT INTO `cmf_admin_menu` VALUES (156, 152, 1, 0, 10000, 'admin', 'Report', 'ban_all', '', '标记处理+禁用用户+下架视频 ', '', '');
INSERT INTO `cmf_admin_menu` VALUES (157, 152, 1, 0, 10000, 'admin', 'Report', 'del', '', '用户举报删除', '', '');
INSERT INTO `cmf_admin_menu` VALUES (190, 0, 1, 1, 7, 'admin', 'Video', 'defaults', '', '视频管理', 'file-movie-o', '');
INSERT INTO `cmf_admin_menu` VALUES (198, 190, 1, 1, 3, 'admin', 'Video', 'add', '', '视频添加', '', '');
INSERT INTO `cmf_admin_menu` VALUES (199, 190, 1, 1, 4, 'admin', 'Video', 'passindex', '', '审核通过列表', '', '');
INSERT INTO `cmf_admin_menu` VALUES (200, 190, 1, 1, 6, 'admin', 'Video', 'nopassindex', '', '未通过列表', '', '');
INSERT INTO `cmf_admin_menu` VALUES (201, 190, 1, 1, 7, 'admin', 'Video', 'lowervideo', '', '下架列表', '', '');
INSERT INTO `cmf_admin_menu` VALUES (202, 201, 1, 0, 10000, 'admin', 'Video', 'set_shangjia', '', '上架', '', '');
INSERT INTO `cmf_admin_menu` VALUES (204, 190, 1, 1, 9, 'admin', 'Video', 'reportset', '', '举报类型', '', '');
INSERT INTO `cmf_admin_menu` VALUES (205, 204, 1, 0, 1, 'admin', 'Video', 'add_report', '', '添加类型', '', '');
INSERT INTO `cmf_admin_menu` VALUES (206, 205, 1, 0, 10000, 'admin', 'Video', 'add_reportpost', '', '添加提交', '', '');
INSERT INTO `cmf_admin_menu` VALUES (207, 204, 1, 0, 2, 'admin', 'Video', 'edit_report', '', '编辑类型', '', '');
INSERT INTO `cmf_admin_menu` VALUES (208, 207, 1, 0, 10000, 'admin', 'Video', 'edit_reportpost', '', '编辑提交', '', '');
INSERT INTO `cmf_admin_menu` VALUES (209, 204, 1, 0, 3, 'admin', 'Video', 'del_report', '', '删除类型', '', '');
INSERT INTO `cmf_admin_menu` VALUES (210, 204, 1, 0, 4, 'admin', 'Video', 'listsordersset', '', '类型排序', '', '');
INSERT INTO `cmf_admin_menu` VALUES (211, 190, 1, 1, 10, 'admin', 'Video', 'reportlist', '', '举报列表', '', '');
INSERT INTO `cmf_admin_menu` VALUES (212, 211, 1, 0, 1, 'admin', 'Video', 'setstatus', '', '标记处理', '', '');
INSERT INTO `cmf_admin_menu` VALUES (213, 211, 1, 0, 2, 'admin', 'Video', 'report_del', '', '删除', '', '');
INSERT INTO `cmf_admin_menu` VALUES (214, 190, 1, 1, 5, 'admin', 'Video', 'index', '', '等待审核列表', '', '');
INSERT INTO `cmf_admin_menu` VALUES (215, 198, 1, 0, 10000, 'admin', 'Video', 'add_post', '', '添加提交', '', '');
INSERT INTO `cmf_admin_menu` VALUES (216, 190, 1, 0, 11, 'admin', 'Video', 'edit', '', '视频编辑', '', '');
INSERT INTO `cmf_admin_menu` VALUES (217, 216, 1, 0, 10000, 'admin', 'Video', 'edit_post', '', '编辑提交', '', '');
INSERT INTO `cmf_admin_menu` VALUES (218, 190, 1, 0, 12, 'admin', 'Video', 'del', '', '删除', '', '');
INSERT INTO `cmf_admin_menu` VALUES (219, 190, 1, 0, 13, 'admin', 'Video', 'video_listen', '', '视频观看', '', '');
INSERT INTO `cmf_admin_menu` VALUES (220, 199, 1, 0, 10000, 'admin', 'Video', 'setXiajia', '', '下架', '', '');
INSERT INTO `cmf_admin_menu` VALUES (221, 190, 1, 0, 14, 'admin', 'Video', 'commentlists', '', '评论列表', '', '');
INSERT INTO `cmf_admin_menu` VALUES (229, 0, 1, 1, 12, 'admin', 'Content', 'default', '', '内容管理', 'th', '');
INSERT INTO `cmf_admin_menu` VALUES (242, 229, 1, 1, 3, 'admin', 'Adminpage', 'index', '', '页面管理', '', '');
INSERT INTO `cmf_admin_menu` VALUES (246, 242, 1, 0, 3, 'admin', 'Adminpage', 'edit', '', '编辑页面', '', '');
INSERT INTO `cmf_admin_menu` VALUES (247, 246, 1, 0, 10000, 'admin', 'Adminpage', 'editPost', '', '提交编辑', '', '');
INSERT INTO `cmf_admin_menu` VALUES (330, 124, 1, 0, 5, 'User', 'AdminIndex', 'edit', '', '编辑', '', '');
INSERT INTO `cmf_admin_menu` VALUES (331, 124, 1, 0, 6, 'User', 'AdminIndex', 'editPost', '', '编辑提交', '', '');
INSERT INTO `cmf_admin_menu` VALUES (332, 124, 1, 0, 7, 'User', 'AdminIndex', 'del', '', '删除', '', '');
INSERT INTO `cmf_admin_menu` VALUES (343, 133, 1, 0, 10000, 'Admin', 'Setting', 'configpriPost', '', '私密设置保存', '', '');
INSERT INTO `cmf_admin_menu` VALUES (362, 190, 1, 0, 10000, 'admin', 'Video', 'setBatchXiajia', '', '批量下架', '', '');
INSERT INTO `cmf_admin_menu` VALUES (363, 190, 1, 0, 10000, 'admin', 'Video', 'setBatchDel', '', '批量删除', '', '');
INSERT INTO `cmf_admin_menu` VALUES (364, 190, 1, 0, 10000, 'admin', 'Video', 'setBatchStatus', '', '批量通过/拒绝', '', '');
INSERT INTO `cmf_admin_menu` VALUES (444, 0, 1, 1, 10000, 'admin', 'Music', 'default', '', '音乐管理', 'music', '');
INSERT INTO `cmf_admin_menu` VALUES (445, 444, 1, 1, 10000, 'admin', 'Music', 'classify', '', '音乐分类', '', '');
INSERT INTO `cmf_admin_menu` VALUES (446, 444, 1, 1, 10000, 'admin', 'Music', 'index', '', '背景音乐列表', '', '');
INSERT INTO `cmf_admin_menu` VALUES (447, 50, 1, 0, 10000, 'admin', 'Rbac', 'roleAdd', '', '添加', '', '');
INSERT INTO `cmf_admin_menu` VALUES (448, 49, 1, 1, 10000, 'admin', 'adminlog', 'index', '', '操作日志', '', '');
INSERT INTO `cmf_admin_menu` VALUES (449, 229, 1, 1, 10000, 'admin', 'Adminpost', 'index', '', '文章管理', '', '');
INSERT INTO `cmf_admin_menu` VALUES (450, 229, 1, 1, 10000, 'admin', 'Adminterm', 'index', '', ' 分类管理', '', '');
COMMIT;

-- ----------------------------
-- Table structure for cmf_admin_push
-- ----------------------------
DROP TABLE IF EXISTS `cmf_admin_push`;
CREATE TABLE `cmf_admin_push` (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `title` varchar(255) DEFAULT '' COMMENT '标题',
  `synopsis` varchar(255) DEFAULT '' COMMENT '简介',
  `type` tinyint(1) DEFAULT '1' COMMENT '消息类型 1文本类型 2 链接类型',
  `content` longtext COMMENT '内容',
  `url` varchar(255) DEFAULT '' COMMENT '外链地址',
  `admin` varchar(255) DEFAULT '' COMMENT '发布者账号',
  `addtime` int(12) DEFAULT '0' COMMENT '发布时间',
  `ip` varchar(255) DEFAULT '' COMMENT 'IP地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_admin_push
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- 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`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='资源表';

-- ----------------------------
-- Records of cmf_asset
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- 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(40) NOT NULL DEFAULT '' COMMENT '规则所属app',
  `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`) USING BTREE,
  UNIQUE KEY `name` (`name`) USING BTREE,
  KEY `module` (`app`,`status`,`type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=445 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='权限规则表';

-- ----------------------------
-- Records of cmf_auth_rule
-- ----------------------------
BEGIN;
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/Theme/design', '', '模板设计', '');
INSERT INTO `cmf_auth_rule` VALUES (109, 1, 'admin', 'admin_url', 'admin/User/default', '', '管理组', '');
INSERT INTO `cmf_auth_rule` VALUES (110, 1, 'admin', 'admin_url', 'admin/User/index', '', '管理员', '');
INSERT INTO `cmf_auth_rule` VALUES (111, 1, 'admin', 'admin_url', 'admin/User/add', '', '管理员添加', '');
INSERT INTO `cmf_auth_rule` VALUES (112, 1, 'admin', 'admin_url', 'admin/User/addPost', '', '管理员添加提交', '');
INSERT INTO `cmf_auth_rule` VALUES (113, 1, 'admin', 'admin_url', 'admin/User/edit', '', '管理员编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (114, 1, 'admin', 'admin_url', 'admin/User/editPost', '', '管理员编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (115, 1, 'admin', 'admin_url', 'admin/User/userInfo', '', '个人信息', '');
INSERT INTO `cmf_auth_rule` VALUES (116, 1, 'admin', 'admin_url', 'admin/User/userInfoPost', '', '管理员个人信息修改提交', '');
INSERT INTO `cmf_auth_rule` VALUES (117, 1, 'admin', 'admin_url', 'admin/User/delete', '', '管理员删除', '');
INSERT INTO `cmf_auth_rule` VALUES (118, 1, 'admin', 'admin_url', 'admin/User/ban', '', '停用管理员', '');
INSERT INTO `cmf_auth_rule` VALUES (119, 1, 'admin', 'admin_url', 'admin/User/cancelBan', '', '启用管理员', '');
INSERT INTO `cmf_auth_rule` VALUES (120, 1, 'user', 'admin_url', 'user/AdminAsset/index', '', '资源管理', '');
INSERT INTO `cmf_auth_rule` VALUES (121, 1, 'user', 'admin_url', 'user/AdminAsset/delete', '', '删除文件', '');
INSERT INTO `cmf_auth_rule` VALUES (122, 1, 'user', 'admin_url', 'user/AdminIndex/default', '', '用户管理', '');
INSERT INTO `cmf_auth_rule` VALUES (123, 1, 'user', 'admin_url', 'user/AdminIndex/default1', '', '用户组', '');
INSERT INTO `cmf_auth_rule` VALUES (124, 1, 'user', 'admin_url', 'user/AdminIndex/index', '', '本站用户', '');
INSERT INTO `cmf_auth_rule` VALUES (125, 1, 'user', 'admin_url', 'user/AdminIndex/ban', '', '本站用户拉黑', '');
INSERT INTO `cmf_auth_rule` VALUES (126, 1, 'user', 'admin_url', 'user/AdminIndex/cancelBan', '', '本站用户启用', '');
INSERT INTO `cmf_auth_rule` VALUES (127, 1, 'user', 'admin_url', 'user/AdminOauth/index', '', '第三方用户', '');
INSERT INTO `cmf_auth_rule` VALUES (128, 1, 'user', 'admin_url', 'user/AdminOauth/delete', '', '删除第三方用户绑定', '');
INSERT INTO `cmf_auth_rule` VALUES (129, 1, 'user', 'admin_url', 'user/AdminUserAction/index', '', '用户操作管理', '');
INSERT INTO `cmf_auth_rule` VALUES (130, 1, 'user', 'admin_url', 'user/AdminUserAction/edit', '', '编辑用户操作', '');
INSERT INTO `cmf_auth_rule` VALUES (131, 1, 'user', 'admin_url', 'user/AdminUserAction/editPost', '', '编辑用户操作提交', '');
INSERT INTO `cmf_auth_rule` VALUES (132, 1, 'user', 'admin_url', 'user/AdminUserAction/sync', '', '同步用户操作', '');
INSERT INTO `cmf_auth_rule` VALUES (133, 1, 'admin', 'admin_url', 'admin/Setting/configpri', '', '私密设置', '');
INSERT INTO `cmf_auth_rule` VALUES (134, 1, 'Admin', 'admin_url', 'Admin/Guide/set', '', '引导页', '');
INSERT INTO `cmf_auth_rule` VALUES (135, 1, 'Admin', 'admin_url', 'Admin/Guide/set_post', '', '设置提交', '');
INSERT INTO `cmf_auth_rule` VALUES (136, 1, 'Admin', 'admin_url', 'Admin/Guide/index', '', '管理', '');
INSERT INTO `cmf_auth_rule` VALUES (137, 1, 'Admin', 'admin_url', 'Admin/Guide/add', '', '添加', '');
INSERT INTO `cmf_auth_rule` VALUES (138, 1, 'Admin', 'admin_url', 'Admin/Guide/add_post', '', '添加提交', '');
INSERT INTO `cmf_auth_rule` VALUES (139, 1, 'admin', 'admin_url', 'admin/Guide/edit', '', '编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (140, 1, 'admin', 'admin_url', 'admin/Guide/edit_post', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (141, 1, 'admin', 'admin_url', 'admin/Guide/listorders', '', '排序', '');
INSERT INTO `cmf_auth_rule` VALUES (142, 1, 'admin', 'admin_url', 'admin/Guide/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (143, 1, 'admin', 'admin_url', 'admin/Userauth/index', '', '身份认证', '');
INSERT INTO `cmf_auth_rule` VALUES (144, 1, 'admin', 'admin_url', 'admin/Report/default', '', '用户举报', '');
INSERT INTO `cmf_auth_rule` VALUES (145, 1, 'admin', 'admin_url', 'admin/Report/classify', '', '举报分类', '');
INSERT INTO `cmf_auth_rule` VALUES (146, 1, 'admin', 'admin_url', 'admin/Report/classify_add', '', '举报分类添加', '');
INSERT INTO `cmf_auth_rule` VALUES (147, 1, 'admin', 'admin_url', 'admin/Report/classify_add_post', '', '用户举报分类添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (148, 1, 'admin', 'admin_url', 'admin/Report/classify_edit', '', '举报分类编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (149, 1, 'admin', 'admin_url', 'admin/Report/classify_edit_post', '', '举报分类编辑保存', '');
INSERT INTO `cmf_auth_rule` VALUES (150, 1, 'admin', 'admin_url', 'admin/Report/classify_listorders', '', '举报分类排序', '');
INSERT INTO `cmf_auth_rule` VALUES (151, 1, 'admin', 'admin_url', 'admin/Report/classify_del', '', '举报分类删除', '');
INSERT INTO `cmf_auth_rule` VALUES (152, 1, 'admin', 'admin_url', 'admin/Report/index', '', '举报列表', '');
INSERT INTO `cmf_auth_rule` VALUES (153, 1, 'admin', 'admin_url', 'admin/Report/ban', '', '禁用用户', '');
INSERT INTO `cmf_auth_rule` VALUES (154, 1, 'admin', 'admin_url', 'admin/Report/ban_video', '', '下架视频', '');
INSERT INTO `cmf_auth_rule` VALUES (155, 1, 'admin', 'admin_url', 'admin/Report/setstatus', '', '标记处理', '');
INSERT INTO `cmf_auth_rule` VALUES (156, 1, 'admin', 'admin_url', 'admin/Report/ban_all', '', '标记处理+禁用用户+下架视频 ', '');
INSERT INTO `cmf_auth_rule` VALUES (157, 1, 'admin', 'admin_url', 'admin/Report/del', '', '用户举报删除', '');
INSERT INTO `cmf_auth_rule` VALUES (158, 1, 'admin', 'admin_url', 'admin/PushMessage/default', '', '官方通知', '');
INSERT INTO `cmf_auth_rule` VALUES (159, 1, 'admin', 'admin_url', 'admin/PushMessage/add', '', '通知添加', '');
INSERT INTO `cmf_auth_rule` VALUES (160, 1, 'admin', 'admin_url', 'admin/PushMessage/add_post', '', '推送添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (161, 1, 'admin', 'admin_url', 'admin/PushMessage/index', '', '通知记录', '');
INSERT INTO `cmf_auth_rule` VALUES (162, 1, 'admin', 'admin_url', 'admin/PushMessage/push', '', '记录推送', '');
INSERT INTO `cmf_auth_rule` VALUES (163, 1, 'admin', 'admin_url', 'admin/PushMessage/del', '', '推送记录删除', '');
INSERT INTO `cmf_auth_rule` VALUES (164, 1, 'admin', 'admin_url', 'admin/Advert/default', '', '广告管理', '');
INSERT INTO `cmf_auth_rule` VALUES (165, 1, 'admin', 'admin_url', 'admin/Advert/add', '', '广告添加', '');
INSERT INTO `cmf_auth_rule` VALUES (166, 1, 'admin', 'admin_url', 'admin/Advert/index', '', '平台广告列表', '');
INSERT INTO `cmf_auth_rule` VALUES (167, 1, 'admin', 'admin_url', 'admin/Advert/edit', '', '广告编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (168, 1, 'admin', 'admin_url', 'admin/Advert/edit_post', '', '编辑保存', '');
INSERT INTO `cmf_auth_rule` VALUES (169, 1, 'admin', 'admin_url', 'admin/Advert/del', '', '广告删除', '');
INSERT INTO `cmf_auth_rule` VALUES (170, 1, 'admin', 'admin_url', 'admin/Advert/lowervideo', '', '平台下架广告列表', '');
INSERT INTO `cmf_auth_rule` VALUES (171, 1, 'admin', 'admin_url', 'admin/Advert/setXiajia', '', '下架', '');
INSERT INTO `cmf_auth_rule` VALUES (172, 1, 'admin', 'admin_url', 'admin/Advert/set_shangjia', '', '上架', '');
INSERT INTO `cmf_auth_rule` VALUES (173, 1, 'admin', 'admin_url', 'admin/Advert/video_listen', '', '观看', '');
INSERT INTO `cmf_auth_rule` VALUES (174, 1, 'admin', 'admin_url', 'admin/Music/default', '', '音乐管理', '');
INSERT INTO `cmf_auth_rule` VALUES (175, 1, 'admin', 'admin_url', 'admin/Music/classify', '', '音乐分类', '');
INSERT INTO `cmf_auth_rule` VALUES (176, 1, 'admin', 'admin_url', 'admin/Music/classify_canceldel', '', '分类取消删除', '');
INSERT INTO `cmf_auth_rule` VALUES (177, 1, 'admin', 'admin_url', 'admin/Music/classify_del', '', '分类删除', '');
INSERT INTO `cmf_auth_rule` VALUES (178, 1, 'admin', 'admin_url', 'admin/Music/classify_edit', '', '分类编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (179, 1, 'admin', 'admin_url', 'admin/Music/classify_edit_post', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (180, 1, 'admin', 'admin_url', 'admin/Music/classify_add', '', '分类添加', '');
INSERT INTO `cmf_auth_rule` VALUES (181, 1, 'admin', 'admin_url', 'admin/Music/classify_add_post', '', '分类添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (182, 1, 'admin', 'admin_url', 'admin/Music/index', '', '背景音乐列表', '');
INSERT INTO `cmf_auth_rule` VALUES (183, 1, 'admin', 'admin_url', 'admin/Music/music_del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (184, 1, 'admin', 'admin_url', 'admin/Music/music_canceldel', '', '取消删除', '');
INSERT INTO `cmf_auth_rule` VALUES (185, 1, 'admin', 'admin_url', 'admin/Music/music_listen', '', '试听', '');
INSERT INTO `cmf_auth_rule` VALUES (186, 1, 'admin', 'admin_url', 'admin/Music/music_edit', '', '编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (187, 1, 'admin', 'admin_url', 'admin/Music/music_edit_post', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (188, 1, 'admin', 'admin_url', 'admin/Music/music_add', '', '添加', '');
INSERT INTO `cmf_auth_rule` VALUES (189, 1, 'admin', 'admin_url', 'admin/Music/music_add_post', '', '添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (190, 1, 'admin', 'admin_url', 'admin/Video/defaults', '', '视频管理', '');
INSERT INTO `cmf_auth_rule` VALUES (191, 1, 'admin', 'admin_url', 'admin/Label/index', '', '话题标签', '');
INSERT INTO `cmf_auth_rule` VALUES (192, 1, 'admin', 'admin_url', 'admin/Label/add', '', '添加', '');
INSERT INTO `cmf_auth_rule` VALUES (193, 1, 'admin', 'admin_url', 'admin/Label/add_post', '', '添加提交', '');
INSERT INTO `cmf_auth_rule` VALUES (194, 1, 'admin', 'admin_url', 'admin/Label/edit', '', '编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (195, 1, 'admin', 'admin_url', 'admin/Label/edit_post', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (196, 1, 'admin', 'admin_url', 'admin/Label/listsorders', '', '排序', '');
INSERT INTO `cmf_auth_rule` VALUES (197, 1, 'admin', 'admin_url', 'admin/Label/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (198, 1, 'admin', 'admin_url', 'admin/Video/add', '', '视频添加', '');
INSERT INTO `cmf_auth_rule` VALUES (199, 1, 'admin', 'admin_url', 'admin/Video/passindex', '', '审核通过列表', '');
INSERT INTO `cmf_auth_rule` VALUES (200, 1, 'admin', 'admin_url', 'admin/Video/nopassindex', '', '未通过列表', '');
INSERT INTO `cmf_auth_rule` VALUES (201, 1, 'admin', 'admin_url', 'admin/Video/lowervideo', '', '下架列表', '');
INSERT INTO `cmf_auth_rule` VALUES (202, 1, 'admin', 'admin_url', 'admin/Video/set_shangjia', '', '上架', '');
INSERT INTO `cmf_auth_rule` VALUES (203, 1, 'admin', 'admin_url', 'admin/Popular/index', '', '上热门', '');
INSERT INTO `cmf_auth_rule` VALUES (204, 1, 'admin', 'admin_url', 'admin/Video/reportset', '', '举报类型', '');
INSERT INTO `cmf_auth_rule` VALUES (205, 1, 'admin', 'admin_url', 'admin/Video/add_report', '', '添加类型', '');
INSERT INTO `cmf_auth_rule` VALUES (206, 1, 'admin', 'admin_url', 'admin/Video/add_reportpost', '', '添加提交', '');
INSERT INTO `cmf_auth_rule` VALUES (207, 1, 'admin', 'admin_url', 'admin/Video/edit_report', '', '编辑类型', '');
INSERT INTO `cmf_auth_rule` VALUES (208, 1, 'admin', 'admin_url', 'admin/Video/edit_reportpost', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (209, 1, 'admin', 'admin_url', 'admin/Video/del_report', '', '删除类型', '');
INSERT INTO `cmf_auth_rule` VALUES (210, 1, 'admin', 'admin_url', 'admin/Video/listsordersset', '', '类型排序', '');
INSERT INTO `cmf_auth_rule` VALUES (211, 1, 'admin', 'admin_url', 'admin/Video/reportlist', '', '举报列表', '');
INSERT INTO `cmf_auth_rule` VALUES (212, 1, 'admin', 'admin_url', 'admin/Video/setstatus', '', '标记处理', '');
INSERT INTO `cmf_auth_rule` VALUES (213, 1, 'admin', 'admin_url', 'admin/Video/report_del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (214, 1, 'admin', 'admin_url', 'admin/Video/index', '', '等待审核列表', '');
INSERT INTO `cmf_auth_rule` VALUES (215, 1, 'admin', 'admin_url', 'admin/Video/add_post', '', '添加提交', '');
INSERT INTO `cmf_auth_rule` VALUES (216, 1, 'admin', 'admin_url', 'admin/Video/edit', '', '视频编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (217, 1, 'admin', 'admin_url', 'admin/Video/edit_post', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (218, 1, 'admin', 'admin_url', 'admin/Video/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (219, 1, 'admin', 'admin_url', 'admin/Video/video_listen', '', '视频观看', '');
INSERT INTO `cmf_auth_rule` VALUES (220, 1, 'admin', 'admin_url', 'admin/Video/setXiajia', '', '下架', '');
INSERT INTO `cmf_auth_rule` VALUES (221, 1, 'admin', 'admin_url', 'admin/Video/commentlists', '', '评论列表', '');
INSERT INTO `cmf_auth_rule` VALUES (222, 1, 'admin', 'admin_url', 'admin/Shopapply/default', '', '店铺管理', '');
INSERT INTO `cmf_auth_rule` VALUES (223, 1, 'admin', 'admin_url', 'admin/Shopapply/index', '', '店铺申请', '');
INSERT INTO `cmf_auth_rule` VALUES (224, 1, 'admin', 'admin_url', 'admin/Shopapply/edit', '', '编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (225, 1, 'admin', 'admin_url', 'admin/Shopapply/edit_post', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (226, 1, 'admin', 'admin_url', 'admin/Shopapply/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (227, 1, 'admin', 'admin_url', 'admin/Shopgoods/index', '', '商品列表', '');
INSERT INTO `cmf_auth_rule` VALUES (228, 1, 'admin', 'admin_url', 'admin/Shopgoods/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (229, 1, 'admin', 'admin_url', 'admin/Content/default', '', '内容管理', '');
INSERT INTO `cmf_auth_rule` VALUES (230, 1, 'admin', 'admin_url', 'admin/Feedback/index', '', '用户反馈', '');
INSERT INTO `cmf_auth_rule` VALUES (231, 1, 'admin', 'admin_url', 'admin/Feedback/setstatus', '', '标记处理', '');
INSERT INTO `cmf_auth_rule` VALUES (232, 1, 'admin', 'admin_url', 'admin/Feedback/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (233, 1, 'admin', 'admin_url', 'admin/Adminpost/index', '', '文章管理', '');
INSERT INTO `cmf_auth_rule` VALUES (234, 1, 'admin', 'admin_url', 'admin/Adminpost/add', '', '添加', '');
INSERT INTO `cmf_auth_rule` VALUES (235, 1, 'admin', 'admin_url', 'admin/Adminpost/addPost', '', '添加提交', '');
INSERT INTO `cmf_auth_rule` VALUES (236, 1, 'admin', 'admin_url', 'admin/Adminpost/edit', '', '编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (237, 1, 'admin', 'admin_url', 'admin/Adminpost/editPost', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (238, 1, 'admin', 'admin_url', 'admin/Adminpost/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (239, 1, 'admin', 'admin_url', 'admin/Adminpost/check', '', '审核', '');
INSERT INTO `cmf_auth_rule` VALUES (240, 1, 'admin', 'admin_url', 'admin/Adminpost/tops', '', '置顶', '');
INSERT INTO `cmf_auth_rule` VALUES (241, 1, 'admin', 'admin_url', 'admin/Adminpost/deletes', '', '批量删除', '');
INSERT INTO `cmf_auth_rule` VALUES (242, 1, 'admin', 'admin_url', 'admin/Adminpage/index', '', '页面管理', '');
INSERT INTO `cmf_auth_rule` VALUES (243, 1, 'admin', 'admin_url', 'admin/Adminpage/listordersset', '', '页面排序', '');
INSERT INTO `cmf_auth_rule` VALUES (244, 1, 'admin', 'admin_url', 'admin/Adminpost/listordersset', '', '排序', '');
INSERT INTO `cmf_auth_rule` VALUES (245, 1, 'admin', 'admin_url', 'admin/Adminpage/del', '', '删除页面', '');
INSERT INTO `cmf_auth_rule` VALUES (246, 1, 'admin', 'admin_url', 'admin/Adminpage/edit', '', '编辑页面', '');
INSERT INTO `cmf_auth_rule` VALUES (247, 1, 'admin', 'admin_url', 'admin/Adminpage/editPost', '', '提交编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (248, 1, 'admin', 'admin_url', 'admin/Adminpage/add', '', '添加页面', '');
INSERT INTO `cmf_auth_rule` VALUES (249, 1, 'admin', 'admin_url', 'admin/Adminpage/addPost', '', '提交添加', '');
INSERT INTO `cmf_auth_rule` VALUES (250, 1, 'admin', 'admin_url', 'admin/Adminterm/index', '', '分类管理', '');
INSERT INTO `cmf_auth_rule` VALUES (251, 1, 'admin', 'admin_url', 'admin/Adminterm/add', '', '添加', '');
INSERT INTO `cmf_auth_rule` VALUES (252, 1, 'admin', 'admin_url', 'admin/Adminterm/addPost', '', '提交', '');
INSERT INTO `cmf_auth_rule` VALUES (253, 1, 'admin', 'admin_url', 'admin/Adminterm/edit', '', '编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (254, 1, 'admin', 'admin_url', 'admin/Adminterm/edit_post', '', '提交', '');
INSERT INTO `cmf_auth_rule` VALUES (255, 1, 'admin', 'admin_url', 'admin/Adminterm/listOrder', '', '排序', '');
INSERT INTO `cmf_auth_rule` VALUES (256, 1, 'admin', 'admin_url', 'admin/Adminterm/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (257, 1, 'admin', 'admin_url', 'admin/Agent/default', '', '分销管理', '');
INSERT INTO `cmf_auth_rule` VALUES (258, 1, 'admin', 'admin_url', 'admin/Agent/index', '', '分销关系', '');
INSERT INTO `cmf_auth_rule` VALUES (259, 1, 'admin', 'admin_url', 'admin/Agent/index2', '', '分销收益', '');
INSERT INTO `cmf_auth_rule` VALUES (260, 1, 'admin', 'admin_url', 'admin/Cash/default', '', '财务管理', '');
INSERT INTO `cmf_auth_rule` VALUES (261, 1, 'admin', 'admin_url', 'admin/Cash/index', '', '提现管理', '');
INSERT INTO `cmf_auth_rule` VALUES (262, 1, 'admin', 'admin_url', 'admin/Cash/edit', '', '编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (263, 1, 'admin', 'admin_url', 'admin/Cash/edit_post', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (264, 1, 'admin', 'admin_url', 'admin/Manual/index', '', '手动充值', '');
INSERT INTO `cmf_auth_rule` VALUES (265, 1, 'admin', 'admin_url', 'admin/Manual/add', '', '添加', '');
INSERT INTO `cmf_auth_rule` VALUES (266, 1, 'admin', 'admin_url', 'admin/Manual/add_post', '', '添加提交', '');
INSERT INTO `cmf_auth_rule` VALUES (267, 1, 'Admin', 'admin_url', 'Admin/Videoclass/index', '', '视频分类', '');
INSERT INTO `cmf_auth_rule` VALUES (268, 1, 'Admin', 'admin_url', 'Admin/Live/default', '', '直播管理', '');
INSERT INTO `cmf_auth_rule` VALUES (269, 1, 'Admin', 'admin_url', 'Admin/Liveban/index', '', '禁播列表', '');
INSERT INTO `cmf_auth_rule` VALUES (270, 1, 'Admin', 'admin_url', 'Admin/Liveban/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (271, 1, 'Admin', 'admin_url', 'Admin/Liveshut/index', '', '禁言列表', '');
INSERT INTO `cmf_auth_rule` VALUES (272, 1, 'Admin', 'admin_url', 'Admin/Liveshut/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (273, 1, 'Admin', 'admin_url', 'Admin/Livekick/index', '', '踢人列表', '');
INSERT INTO `cmf_auth_rule` VALUES (274, 1, 'Admin', 'admin_url', 'Admin/Livekick/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (275, 1, 'Admin', 'admin_url', 'Admin/Liveing/index', '', '直播列表', '');
INSERT INTO `cmf_auth_rule` VALUES (276, 1, 'Admin', 'admin_url', 'Admin/Liveing/add', '', '添加视频', '');
INSERT INTO `cmf_auth_rule` VALUES (277, 1, 'Admin', 'admin_url', 'Admin/Liveing/add_post', '', '添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (278, 1, 'Admin', 'admin_url', 'Admin/Liveing/edit', '', '视频编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (279, 1, 'Admin', 'admin_url', 'Admin/Liveing/edit_post', '', '视频编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (280, 1, 'Admin', 'admin_url', 'Admin/Liveing/del', '', '视频删除', '');
INSERT INTO `cmf_auth_rule` VALUES (281, 1, 'Admin', 'admin_url', 'Admin/Monitor/index', '', '直播监控', '');
INSERT INTO `cmf_auth_rule` VALUES (282, 1, 'Admin', 'admin_url', 'Admin/Monitor/stopRoom', '', '关播', '');
INSERT INTO `cmf_auth_rule` VALUES (283, 1, 'Admin', 'admin_url', 'Admin/Monitor/full', '', '监控大屏', '');
INSERT INTO `cmf_auth_rule` VALUES (284, 1, 'Admin', 'admin_url', 'Admin/Gift/index', '', '礼物列表', '');
INSERT INTO `cmf_auth_rule` VALUES (285, 1, 'Admin', 'admin_url', 'Admin/Livereport/default', '', '直播间举报管理', '');
INSERT INTO `cmf_auth_rule` VALUES (286, 1, 'Admin', 'admin_url', 'Admin/Live/index', '', '直播记录', '');
INSERT INTO `cmf_auth_rule` VALUES (287, 1, 'Admin', 'admin_url', 'Admin/Gift/add', '', '礼物添加', '');
INSERT INTO `cmf_auth_rule` VALUES (288, 1, 'Admin', 'admin_url', 'Admin/Gift/add_post', '', '添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (289, 1, 'Admin', 'admin_url', 'Admin/Gift/edit', '', '礼物修改', '');
INSERT INTO `cmf_auth_rule` VALUES (290, 1, 'Admin', 'admin_url', 'Admin/Gift/edit_post', '', '编辑保存', '');
INSERT INTO `cmf_auth_rule` VALUES (291, 1, 'Admin', 'admin_url', 'Admin/Gift/del', '', '礼物删除', '');
INSERT INTO `cmf_auth_rule` VALUES (292, 1, 'Admin', 'admin_url', 'Admin/Gift/listorders', '', '礼物排序', '');
INSERT INTO `cmf_auth_rule` VALUES (293, 1, 'Admin', 'admin_url', 'Admin/Reportcat/index', '', '直播间举报类型', '');
INSERT INTO `cmf_auth_rule` VALUES (294, 1, 'Admin', 'admin_url', 'Admin/Livereport/index', '', '直播间举报列表', '');
INSERT INTO `cmf_auth_rule` VALUES (295, 1, 'Admin', 'admin_url', 'Admin/Reportcat/add', '', '举报类型添加', '');
INSERT INTO `cmf_auth_rule` VALUES (296, 1, 'Admin', 'admin_url', 'Admin/Reportcat/add_post', '', '添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (297, 1, 'Admin', 'admin_url', 'Admin/Reportcat/edit', '', '举报类型编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (298, 1, 'Admin', 'admin_url', 'Admin/Reportcat/edit_post', '', '编辑保存', '');
INSERT INTO `cmf_auth_rule` VALUES (299, 1, 'Admin', 'admin_url', 'Admin/Reportcat/listorders', '', '排序', '');
INSERT INTO `cmf_auth_rule` VALUES (300, 1, 'Admin', 'admin_url', 'Admin/Reportcat/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (301, 1, 'Admin', 'admin_url', 'Admin/Livereport/setstatus', '', '标记处理', '');
INSERT INTO `cmf_auth_rule` VALUES (302, 1, 'Admin', 'admin_url', 'Admin/Chargerules/index', '', '钻石充值规则', '');
INSERT INTO `cmf_auth_rule` VALUES (303, 1, 'Admin', 'admin_url', 'Admin/Chargerules/add', '', '添加钻石充值规则', '');
INSERT INTO `cmf_auth_rule` VALUES (304, 1, 'Admin', 'admin_url', 'Admin/Chargerules/add_post', '', '添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (305, 1, 'Admin', 'admin_url', 'Admin/Chargerules/edit', '', '编辑钻石充值规则', '');
INSERT INTO `cmf_auth_rule` VALUES (306, 1, 'Admin', 'admin_url', 'Admin/Chargerules/edit_post', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (307, 1, 'Admin', 'admin_url', 'Admin/Chargerules/listorderset', '', '排序', '');
INSERT INTO `cmf_auth_rule` VALUES (308, 1, 'Admin', 'admin_url', 'Admin/Chargerules/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (309, 1, 'Admin', 'admin_url', 'Admin/Vipchargerules/index', '', 'VIP充值规则', '');
INSERT INTO `cmf_auth_rule` VALUES (310, 1, 'Admin', 'admin_url', 'Admin/Vipchargerules/add', '', '添加', '');
INSERT INTO `cmf_auth_rule` VALUES (311, 1, 'Admin', 'admin_url', 'Admin/Vipchargerules/add_post', '', '添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (312, 1, 'Admin', 'admin_url', 'Admin/Vipchargerules/edit', '', '编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (313, 1, 'Admin', 'admin_url', 'Admin/Vipchargerules/edit_post', '', '编辑保存', '');
INSERT INTO `cmf_auth_rule` VALUES (314, 1, 'Admin', 'admin_url', 'Admin/Vipchargerules/listorderset', '', '排序', '');
INSERT INTO `cmf_auth_rule` VALUES (315, 1, 'Admin', 'admin_url', 'Admin/Vipchargerules/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (316, 1, 'Admin', 'admin_url', 'Admin/Charge/index', '', '钻石充值记录', '');
INSERT INTO `cmf_auth_rule` VALUES (317, 1, 'Admin', 'admin_url', 'Admin/Charge/export', '', '导出', '');
INSERT INTO `cmf_auth_rule` VALUES (318, 1, 'Admin', 'admin_url', 'Admin/Charge/setPay', '', '确认支付', '');
INSERT INTO `cmf_auth_rule` VALUES (319, 1, 'Admin', 'admin_url', 'Admin/Vipcharge/index', '', 'VIP充值记录', '');
INSERT INTO `cmf_auth_rule` VALUES (320, 1, 'Admin', 'admin_url', 'Admin/Vipcharge/export', '', '导出', '');
INSERT INTO `cmf_auth_rule` VALUES (321, 1, 'Admin', 'admin_url', 'Admin/Cash/export', '', '导出提现记录', '');
INSERT INTO `cmf_auth_rule` VALUES (322, 1, 'Admin', 'admin_url', 'Admin/Votesrecord/index', '', '收入记录', '');
INSERT INTO `cmf_auth_rule` VALUES (323, 1, 'Admin', 'admin_url', 'Admin/Userauth/edit', '', '编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (324, 1, 'Admin', 'admin_url', 'Admin/Userauth/edit_post', '', '编辑保存', '');
INSERT INTO `cmf_auth_rule` VALUES (325, 1, 'Admin', 'admin_url', 'Admin/Userauth/del', '', '删除身份认证', '');
INSERT INTO `cmf_auth_rule` VALUES (326, 1, 'User', 'admin_url', 'User/AdminIndex/super', '', '设置超管', '');
INSERT INTO `cmf_auth_rule` VALUES (327, 1, 'User', 'admin_url', 'User/AdminIndex/cancelsuper', '', '取消超管', '');
INSERT INTO `cmf_auth_rule` VALUES (328, 1, 'User', 'admin_url', 'User/AdminIndex/setvip', '', '设置vip', '');
INSERT INTO `cmf_auth_rule` VALUES (329, 1, 'User', 'admin_url', 'User/AdminIndex/setvip_post', '', '设置vip提交', '');
INSERT INTO `cmf_auth_rule` VALUES (330, 1, 'User', 'admin_url', 'User/AdminIndex/edit', '', '编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (331, 1, 'User', 'admin_url', 'User/AdminIndex/editPost', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (332, 1, 'User', 'admin_url', 'User/AdminIndex/del', '', '删除', '');
INSERT INTO `cmf_auth_rule` VALUES (333, 1, 'Admin', 'admin_url', 'Admin/Advert/add_post', '', '广告添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (334, 1, 'Admin', 'admin_url', 'Admin/Videoclass/add', '', '视频分类添加', '');
INSERT INTO `cmf_auth_rule` VALUES (335, 1, 'Admin', 'admin_url', 'Admin/Videoclass/add_post', '', '添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (336, 1, 'Admin', 'admin_url', 'Admin/Videoclass/edit', '', '编辑分类', '');
INSERT INTO `cmf_auth_rule` VALUES (337, 1, 'Admin', 'admin_url', 'Admin/Videoclass/edit_post', '', '编辑保存', '');
INSERT INTO `cmf_auth_rule` VALUES (338, 1, 'Admin', 'admin_url', 'Admin/Videoclass/del', '', '删除视频分类', '');
INSERT INTO `cmf_auth_rule` VALUES (339, 1, 'Admin', 'admin_url', 'Admin/Videoclass/listordersset', '', '视频分类排序', '');
INSERT INTO `cmf_auth_rule` VALUES (340, 1, 'Admin', 'admin_url', 'Admin/Vipcharge/setPay', '', '确认支付', '');
INSERT INTO `cmf_auth_rule` VALUES (341, 1, 'Admin', 'admin_url', 'Admin/Votesrecord/export', '', '导出收入记录', '');
INSERT INTO `cmf_auth_rule` VALUES (342, 1, 'Admin', 'admin_url', 'Admin/Coinrecord/index', '', '钻石消费记录', '');
INSERT INTO `cmf_auth_rule` VALUES (343, 1, 'Admin', 'admin_url', 'Admin/Setting/configpriPost', '', '私密设置保存', '');
INSERT INTO `cmf_auth_rule` VALUES (344, 1, 'admin', 'admin_url', 'admin/shopgoods/setstatus', '', '上架或下架', '');
INSERT INTO `cmf_auth_rule` VALUES (345, 1, 'admin', 'admin_url', 'admin/Shopgoods/edit', '', '审核或详情', '');
INSERT INTO `cmf_auth_rule` VALUES (346, 1, 'admin', 'admin_url', 'admin/Shopgoods/editPost', '', '提交', '');
INSERT INTO `cmf_auth_rule` VALUES (347, 1, 'admin', 'admin_url', 'admin/Coinrecord/export', '', '导出', '');
INSERT INTO `cmf_auth_rule` VALUES (348, 1, 'admin', 'admin_url', 'admin/Turntable/default', '', '大转盘', '');
INSERT INTO `cmf_auth_rule` VALUES (349, 1, 'admin', 'admin_url', 'admin/Turntablecon/index', '', '价格管理', '');
INSERT INTO `cmf_auth_rule` VALUES (350, 1, 'admin', 'admin_url', 'admin/Turntable/index', '', '奖品管理', '');
INSERT INTO `cmf_auth_rule` VALUES (351, 1, 'admin', 'admin_url', 'admin/Turntable/index2', '', '转盘记录', '');
INSERT INTO `cmf_auth_rule` VALUES (352, 1, 'admin', 'admin_url', 'admin/Turntable/index3', '', '线下奖品', '');
INSERT INTO `cmf_auth_rule` VALUES (353, 1, 'admin', 'admin_url', 'admin/Turntablecon/edit', '', '编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (354, 1, 'admin', 'admin_url', 'admin/Turntablecon/editPost', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (355, 1, 'admin', 'admin_url', 'admin/Turntablecon/listOrder', '', '排序', '');
INSERT INTO `cmf_auth_rule` VALUES (356, 1, 'admin', 'admin_url', 'admin/Turntable/edit', '', '编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (357, 1, 'admin', 'admin_url', 'admin/Turntable/editPost', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (358, 1, 'admin', 'admin_url', 'admin/Turntable/setstatus', '', '处理', '');
INSERT INTO `cmf_auth_rule` VALUES (359, 1, 'admin', 'admin_url', 'admin/Guard/index', '', '守护管理', '');
INSERT INTO `cmf_auth_rule` VALUES (360, 1, 'Admin', 'admin_url', 'Admin/Guard/edit', '', '编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (361, 1, 'admin', 'admin_url', 'admin/Guard/editPost', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (362, 1, 'admin', 'admin_url', 'admin/Video/setBatchXiajia', '', '批量下架', '');
INSERT INTO `cmf_auth_rule` VALUES (363, 1, 'admin', 'admin_url', 'admin/Video/setBatchDel', '', '批量删除', '');
INSERT INTO `cmf_auth_rule` VALUES (364, 1, 'admin', 'admin_url', 'admin/Video/setBatchStatus', '', '批量通过/拒绝', '');
INSERT INTO `cmf_auth_rule` VALUES (365, 1, 'Admin', 'admin_url', 'Admin/Goodsclass/index', '', '商品分类列表', '');
INSERT INTO `cmf_auth_rule` VALUES (366, 1, 'Admin', 'admin_url', 'Admin/Goodsclass/add', '', '商品分类添加', '');
INSERT INTO `cmf_auth_rule` VALUES (367, 1, 'Admin', 'admin_url', 'Admin/Goodsclass/addPost', '', '商品分类添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (368, 1, 'Admin', 'admin_url', 'Admin/Goodsclass/edit', '', '商品分类编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (369, 1, 'Admin', 'admin_url', 'Admin/Goodsclass/editPost', '', '商品分类编辑保存', '');
INSERT INTO `cmf_auth_rule` VALUES (370, 1, 'Admin', 'admin_url', 'Admin/Goodsclass/del', '', '商品分类删除', '');
INSERT INTO `cmf_auth_rule` VALUES (371, 1, 'Admin', 'admin_url', 'Admin/shopbond/index', '', '保证金', '');
INSERT INTO `cmf_auth_rule` VALUES (372, 1, 'Admin', 'admin_url', 'Admin/shopbond/setstatus', '', '保证金处理', '');
INSERT INTO `cmf_auth_rule` VALUES (373, 1, 'Admin', 'admin_url', 'Admin/Buyeraddress/index', '', '收货地址管理', '');
INSERT INTO `cmf_auth_rule` VALUES (374, 1, 'Admin', 'admin_url', 'Admin/Buyeraddress/del', '', '收货地址删除', '');
INSERT INTO `cmf_auth_rule` VALUES (375, 1, 'Admin', 'admin_url', 'Admin/Express/index', '', '物流公司列表', '');
INSERT INTO `cmf_auth_rule` VALUES (376, 1, 'Admin', 'admin_url', 'Admin/Express/add', '', '物流公司添加', '');
INSERT INTO `cmf_auth_rule` VALUES (377, 1, 'Admin', 'admin_url', 'Admin/Express/add_post', '', '物流公司添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (378, 1, 'Admin', 'admin_url', 'Admin/Express/edit', '', '物流公司编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (379, 1, 'Admin', 'admin_url', 'Admin/Express/edit_post', '', '物流公司编辑保存', '');
INSERT INTO `cmf_auth_rule` VALUES (380, 1, 'Admin', 'admin_url', 'Admin/Express/del', '', '物流公司删除', '');
INSERT INTO `cmf_auth_rule` VALUES (381, 1, 'Admin', 'admin_url', 'Admin/Express/listOrder', '', '物流公司排序', '');
INSERT INTO `cmf_auth_rule` VALUES (382, 1, 'Admin', 'admin_url', 'Admin/Refundreason/index', '', '买家申请退款原因', '');
INSERT INTO `cmf_auth_rule` VALUES (383, 1, 'Admin', 'admin_url', 'Admin/Refundreason/add', '', '添加退款原因', '');
INSERT INTO `cmf_auth_rule` VALUES (384, 1, 'Admin', 'admin_url', 'Admin/Refundreason/add_post', '', '退款原因添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (385, 1, 'Admin', 'admin_url', 'Admin/Refundreason/edit', '', '编辑退款原因', '');
INSERT INTO `cmf_auth_rule` VALUES (386, 1, 'Admin', 'admin_url', 'Admin/Refundreason/edit_post', '', '退款原因编辑保存', '');
INSERT INTO `cmf_auth_rule` VALUES (387, 1, 'Admin', 'admin_url', 'Admin/Refundreason/del', '', '删除退款原因', '');
INSERT INTO `cmf_auth_rule` VALUES (388, 1, 'Admin', 'admin_url', 'Admin/Refundreason/listOrder', '', '排序', '');
INSERT INTO `cmf_auth_rule` VALUES (389, 1, 'Admin', 'admin_url', 'Admin/Refusereason/index', '', '卖家拒绝退款原因', '');
INSERT INTO `cmf_auth_rule` VALUES (390, 1, 'Admin', 'admin_url', 'Admin/Refusereason/add', '', '拒绝退款原因添加', '');
INSERT INTO `cmf_auth_rule` VALUES (391, 1, 'Admin', 'admin_url', 'Admin/Refusereason/add_post', '', '拒绝退款原因添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (392, 1, 'Admin', 'admin_url', 'Admin/Refusereason/edit', '', '拒绝退款原因编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (393, 1, 'Admin', 'admin_url', 'Admin/Refusereason/edit_post', '', '拒绝退款原因编辑保存', '');
INSERT INTO `cmf_auth_rule` VALUES (394, 1, 'Admin', 'admin_url', 'Admin/Refusereason/del', '', '拒绝退款原因删除', '');
INSERT INTO `cmf_auth_rule` VALUES (395, 1, 'Admin', 'admin_url', 'Admin/Refusereason/listOrder', '', '拒绝退款原因排序', '');
INSERT INTO `cmf_auth_rule` VALUES (396, 1, 'Admin', 'admin_url', 'Admin/Platformreason/index', '', '退款平台介入原因', '');
INSERT INTO `cmf_auth_rule` VALUES (397, 1, 'Admin', 'admin_url', 'Admin/Platformreason/add', '', '添加平台介入原因', '');
INSERT INTO `cmf_auth_rule` VALUES (398, 1, 'Admin', 'admin_url', 'Admin/Platformreason/add_post', '', '平台介入原因添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (399, 1, 'Admin', 'admin_url', 'Admin/Platformreason/edot', '', '编辑平台介入原因', '');
INSERT INTO `cmf_auth_rule` VALUES (400, 1, 'Admin', 'admin_url', 'Admin/Platformreason/edit_post', '', '平台介入原因添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (401, 1, 'Admin', 'admin_url', 'Admin/Platformreason/listOrder', '', '平台介入原因排序', '');
INSERT INTO `cmf_auth_rule` VALUES (402, 1, 'Admin', 'admin_url', 'Admin/Platformreason/del', '', '删除平台介入原因', '');
INSERT INTO `cmf_auth_rule` VALUES (403, 1, 'Admin', 'admin_url', 'Admin/Goodsorder/index', '', '商品订单列表', '');
INSERT INTO `cmf_auth_rule` VALUES (404, 1, 'Admin', 'admin_url', 'Admin/Goodsorder/info', '', '订单详情', '');
INSERT INTO `cmf_auth_rule` VALUES (405, 1, 'Admin', 'admin_url', 'Admin/Goodsorder/setexpress', '', '填写物流', '');
INSERT INTO `cmf_auth_rule` VALUES (406, 1, 'Admin', 'admin_url', 'Admin/Goodsorder/setexpresspost', '', '填写物流提交', '');
INSERT INTO `cmf_auth_rule` VALUES (407, 1, 'Admin', 'admin_url', 'Admin/Refundlist/index', '', '退款列表', '');
INSERT INTO `cmf_auth_rule` VALUES (408, 1, 'Admin', 'admin_url', 'Admin/Refundlist/edit', '', '编辑', '');
INSERT INTO `cmf_auth_rule` VALUES (409, 1, 'Admin', 'admin_url', 'Admin/Refundlist/edit_post', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (410, 1, 'Admin', 'admin_url', 'Admin/refundlist/platformedit', '', '平台自营处理退款', '');
INSERT INTO `cmf_auth_rule` VALUES (411, 1, 'Admin', 'admin_url', 'Admin/Shopcash/index', '', '提现记录', '');
INSERT INTO `cmf_auth_rule` VALUES (412, 1, 'Admin', 'admin_url', 'Admin/Shopcash/edit', '', '编辑提现记录', '');
INSERT INTO `cmf_auth_rule` VALUES (413, 1, 'Admin', 'admin_url', 'Admin/Shopcash/editPost', '', '编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (414, 1, 'Admin', 'admin_url', 'Admin/Shopcash/export', '', '导出提现记录', '');
INSERT INTO `cmf_auth_rule` VALUES (415, 1, 'Admin', 'admin_url', 'Admin/Balance/index', '', '余额手动充值', '');
INSERT INTO `cmf_auth_rule` VALUES (416, 1, 'Admin', 'admin_url', 'Admin/Balance/add', '', '充值添加', '');
INSERT INTO `cmf_auth_rule` VALUES (417, 1, 'Admin', 'admin_url', 'Admin/Balance/addPost', '', '余额充值保存', '');
INSERT INTO `cmf_auth_rule` VALUES (418, 1, 'Admin', 'admin_url', 'Admin/Balance/export', '', '余额充值记录导出', '');
INSERT INTO `cmf_auth_rule` VALUES (419, 1, 'Admin', 'admin_url', 'Admin/Shopcategory/index', '', ' 经营类目申请列表', '');
INSERT INTO `cmf_auth_rule` VALUES (420, 1, 'Admin', 'admin_url', 'Admin/Shopcategory/edit', '', '编辑经营类目申请', '');
INSERT INTO `cmf_auth_rule` VALUES (421, 1, 'Admin', 'admin_url', 'Admin/Shopcategory/editPost', '', ' 编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (422, 1, 'Admin', 'admin_url', 'Admin/Shopcategory/del', '', '删除类目申请记录', '');
INSERT INTO `cmf_auth_rule` VALUES (423, 1, 'Admin', 'admin_url', 'Admin/Liveclass/index', '', '直播分类', '');
INSERT INTO `cmf_auth_rule` VALUES (424, 1, 'Admin', 'admin_url', 'Admin/Liveclass/add', '', '添加直播分类', '');
INSERT INTO `cmf_auth_rule` VALUES (425, 1, 'Admin', 'admin_url', 'Admin/Liveclass/addPost', '', '直播分类添加保存', '');
INSERT INTO `cmf_auth_rule` VALUES (426, 1, 'Admin', 'admin_url', 'Admin/Liveclass/edit', '', '编辑直播分类', '');
INSERT INTO `cmf_auth_rule` VALUES (427, 1, 'Admin', 'admin_url', 'Admin/Liveclass/editPost', '', '直播分类编辑提交', '');
INSERT INTO `cmf_auth_rule` VALUES (428, 1, 'Admin', 'admin_url', 'Admin/Liveclass/del', '', '删除直播分类', '');
INSERT INTO `cmf_auth_rule` VALUES (429, 1, 'Admin', 'admin_url', 'Admin/Liveclass/listOrder', '', '直播分类排序', '');
INSERT INTO `cmf_auth_rule` VALUES (430, 1, 'Admin', 'admin_url', 'Admin/Advertiser/index', '', '用户广告主申请列表', '');
INSERT INTO `cmf_auth_rule` VALUES (431, 1, 'Admin', 'admin_url', 'Admin/Advertiser/setpass', '', '广告主申请通过', '');
INSERT INTO `cmf_auth_rule` VALUES (432, 1, 'Admin', 'admin_url', 'Admin/Advertiser/setstatus', '', '广告主申请拒绝', '');
INSERT INTO `cmf_auth_rule` VALUES (433, 1, 'Admin', 'admin_url', 'Admin/Useradvert/index', '', '用户广告列表', '');
INSERT INTO `cmf_auth_rule` VALUES (434, 1, 'Admin', 'admin_url', 'Admin/Useradvert/video_listen', '', '观看用户广告视频', '');
INSERT INTO `cmf_auth_rule` VALUES (435, 1, 'Admin', 'admin_url', 'Admin/Useradvert/commentlists', '', '用户广告视频评论列表', '');
INSERT INTO `cmf_auth_rule` VALUES (436, 1, 'Admin', 'admin_url', 'Admin/Useradvert/setDel', '', '用户广告视频上/下架', '');
INSERT INTO `cmf_auth_rule` VALUES (437, 1, 'Admin', 'admin_url', 'Admin/Useradvert/setStatus', '', '用户广告视频审核', '');
INSERT INTO `cmf_auth_rule` VALUES (438, 1, 'Admin', 'admin_url', 'Admin/Useradvert/del', '', '删除用户广告视频', '');
INSERT INTO `cmf_auth_rule` VALUES (439, 1, 'Admin', 'admin_url', 'Admin/loginbonus/default', '', '签到奖励', '');
INSERT INTO `cmf_auth_rule` VALUES (440, 1, 'Admin', 'admin_url', 'Admin/loginbonus/index', '', '签到奖励规则', '');
INSERT INTO `cmf_auth_rule` VALUES (441, 1, 'Admin', 'admin_url', 'Admin/loginbonus/edit', '', '编辑签到奖励规则', '');
INSERT INTO `cmf_auth_rule` VALUES (442, 1, 'Admin', 'admin_url', 'Admin/loginbonus/editPost', '', '编辑保存', '');
INSERT INTO `cmf_auth_rule` VALUES (443, 1, 'Admin', 'admin_url', 'Admin/loginbonus/index2', '', '签到奖励记录', '');
INSERT INTO `cmf_auth_rule` VALUES (444, 1, 'admin', 'admin_url', 'admin/adminlog/index', '', '操作日志', '');
COMMIT;

-- ----------------------------
-- Table structure for cmf_getcode_limit_ip
-- ----------------------------
DROP TABLE IF EXISTS `cmf_getcode_limit_ip`;
CREATE TABLE `cmf_getcode_limit_ip` (
  `ip` bigint(20) NOT NULL DEFAULT '0' COMMENT 'ip地址',
  `date` varchar(30) NOT NULL DEFAULT '' COMMENT '时间',
  `times` tinyint(4) NOT NULL DEFAULT '3' COMMENT '次数',
  PRIMARY KEY (`ip`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cmf_getcode_limit_ip
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_guide
-- ----------------------------
DROP TABLE IF EXISTS `cmf_guide`;
CREATE TABLE `cmf_guide` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `thumb` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图片/视频链接',
  `href` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '跳转链接',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型',
  `orderno` int(11) NOT NULL DEFAULT '10000' COMMENT '序号',
  `addtime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `uptime` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_guide
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- 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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='系统钩子表';

-- ----------------------------
-- Records of cmf_hook
-- ----------------------------
BEGIN;
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 (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', '后台模板切换');
INSERT INTO `cmf_hook` VALUES (36, 1, 1, '验证码图片', 'captcha_image', 'cmf', '验证码图片');
INSERT INTO `cmf_hook` VALUES (37, 2, 1, '后台模板设计界面', 'admin_theme_design_view', 'admin', '后台模板设计界面');
INSERT INTO `cmf_hook` VALUES (38, 2, 1, '后台设置网站信息界面', 'admin_setting_site_view', 'admin', '后台设置网站信息界面');
INSERT INTO `cmf_hook` VALUES (39, 2, 1, '后台清除缓存界面', 'admin_setting_clear_cache_view', 'admin', '后台清除缓存界面');
INSERT INTO `cmf_hook` VALUES (40, 2, 1, '后台导航管理界面', 'admin_nav_index_view', 'admin', '后台导航管理界面');
INSERT INTO `cmf_hook` VALUES (41, 2, 1, '后台友情链接管理界面', 'admin_link_index_view', 'admin', '后台友情链接管理界面');
INSERT INTO `cmf_hook` VALUES (42, 2, 1, '后台幻灯片管理界面', 'admin_slide_index_view', 'admin', '后台幻灯片管理界面');
INSERT INTO `cmf_hook` VALUES (43, 2, 1, '后台管理员列表界面', 'admin_user_index_view', 'admin', '后台管理员列表界面');
INSERT INTO `cmf_hook` VALUES (44, 2, 1, '后台角色管理界面', 'admin_rbac_index_view', 'admin', '后台角色管理界面');
INSERT INTO `cmf_hook` VALUES (49, 2, 1, '用户管理本站用户列表界面', 'user_admin_index_view', 'user', '用户管理本站用户列表界面');
INSERT INTO `cmf_hook` VALUES (50, 2, 1, '资源管理列表界面', 'user_admin_asset_index_view', 'user', '资源管理列表界面');
INSERT INTO `cmf_hook` VALUES (51, 2, 1, '用户管理第三方用户列表界面', 'user_admin_oauth_index_view', 'user', '用户管理第三方用户列表界面');
INSERT INTO `cmf_hook` VALUES (52, 2, 1, '后台首页界面', 'admin_index_index_view', 'admin', '后台首页界面');
INSERT INTO `cmf_hook` VALUES (53, 2, 1, '后台回收站界面', 'admin_recycle_bin_index_view', 'admin', '后台回收站界面');
INSERT INTO `cmf_hook` VALUES (54, 2, 1, '后台菜单管理界面', 'admin_menu_index_view', 'admin', '后台菜单管理界面');
INSERT INTO `cmf_hook` VALUES (55, 2, 1, '后台自定义登录是否开启钩子', 'admin_custom_login_open', 'admin', '后台自定义登录是否开启钩子');
INSERT INTO `cmf_hook` VALUES (64, 2, 1, '后台幻灯片页面列表界面', 'admin_slide_item_index_view', 'admin', '后台幻灯片页面列表界面');
INSERT INTO `cmf_hook` VALUES (65, 2, 1, '后台幻灯片页面添加界面', 'admin_slide_item_add_view', 'admin', '后台幻灯片页面添加界面');
INSERT INTO `cmf_hook` VALUES (66, 2, 1, '后台幻灯片页面编辑界面', 'admin_slide_item_edit_view', 'admin', '后台幻灯片页面编辑界面');
INSERT INTO `cmf_hook` VALUES (67, 2, 1, '后台管理员添加界面', 'admin_user_add_view', 'admin', '后台管理员添加界面');
INSERT INTO `cmf_hook` VALUES (68, 2, 1, '后台管理员编辑界面', 'admin_user_edit_view', 'admin', '后台管理员编辑界面');
INSERT INTO `cmf_hook` VALUES (69, 2, 1, '后台角色添加界面', 'admin_rbac_role_add_view', 'admin', '后台角色添加界面');
INSERT INTO `cmf_hook` VALUES (70, 2, 1, '后台角色编辑界面', 'admin_rbac_role_edit_view', 'admin', '后台角色编辑界面');
INSERT INTO `cmf_hook` VALUES (71, 2, 1, '后台角色授权界面', 'admin_rbac_authorize_view', 'admin', '后台角色授权界面');
COMMIT;

-- ----------------------------
-- 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`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='系统钩子插件表';

-- ----------------------------
-- Records of cmf_hook_plugin
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- 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`) USING BTREE,
  KEY `status` (`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='友情链接表';

-- ----------------------------
-- Records of cmf_link
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- 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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='前台导航位置表';

-- ----------------------------
-- Records of cmf_nav
-- ----------------------------
BEGIN;
INSERT INTO `cmf_nav` VALUES (1, 1, '主导航', '主导航');
INSERT INTO `cmf_nav` VALUES (2, 0, '底部导航', '');
COMMIT;

-- ----------------------------
-- 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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='前台导航菜单表';

-- ----------------------------
-- Records of cmf_nav_menu
-- ----------------------------
BEGIN;
INSERT INTO `cmf_nav_menu` VALUES (1, 1, 0, 1, 0, '首页', '', 'home', '', '0-1');
COMMIT;

-- ----------------------------
-- 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`) USING BTREE,
  UNIQUE KEY `option_name` (`option_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='全站配置表';

-- ----------------------------
-- Records of cmf_option
-- ----------------------------
BEGIN;
INSERT INTO `cmf_option` VALUES (1, 1, 'site_info', '{\"site_name\":\"\",\"site_seo_title\":\"\\u4e91\\u8c79\\u77ed\\u89c6\\u9891\\u5f00\\u6e90\\u7248\\u6f14\\u793a\",\"site_seo_keywords\":\"\\u4e91\\u8c79\\u77ed\\u89c6\\u9891\\u5f00\\u6e90\\u7248\\u6f14\\u793a\",\"site_seo_description\":\"\\u4e91\\u8c79\\u77ed\\u89c6\\u9891\\u5f00\\u6e90\\u7248\\u6f14\\u793a\",\"site_icp\":\"\",\"site_gwa\":\"\",\"site_admin_email\":\"\",\"site_analytics\":\"\",\"app_name\":\"\\u4e91\\u8c79\\u77ed\\u89c6\\u9891\\u5f00\\u6e90\\u7248\\u6f14\\u793a\",\"sitename\":\"\\u4e91\\u8c79\\u77ed\\u89c6\\u9891\\u5f00\\u6e90\\u7248\\u6f14\\u793a\",\"site\":\"http:\\/\\/\",\"name_votes\":\"\\u4e91\\u7968\",\"qq\":\"\",\"mobile\":\"\",\"apk_ver\":\"6.2.2\",\"apk_url\":\"http:\\/\\/ky.yyyybbbb.com\\/dsp\",\"apk_des\":\"\\u7248\\u672c\\u4f18\\u5316\\uff0c\\u8bf7\\u53ca\\u65f6\\u66f4\\u65b0\",\"ipa_ver\":\"\",\"ios_shelves\":\"1\",\"ipa_url\":\"\",\"ipa_des\":\"\\u7248\\u672c\\u4f18\\u5316\\uff0c\\u8bf7\\u53ca\\u65f6\\u66f4\\u65b0\",\"app_android\":\"\",\"app_ios\":\"\",\"video_share_title\":\"\\u5206\\u4eab\\u4e86{username}\\u7684\\u7cbe\\u5f69\\u89c6\\u9891\\uff01\",\"video_share_des\":\"\\u6211\\u770b\\u5230\\u4e00\\u4e2a\\u5f88\\u597d\\u770b\\u7684\\u89c6\\u9891\\uff0c\\u5feb\\u6765\\u8ddf\\u6211\\u4e00\\u8d77\\u56f4\\u89c2\\u5427\",\"agent_share_title\":\"\\u9080\\u8bf7\\u597d\\u53cb\\u5206\\u4eab\\u6807\\u9898\",\"agent_share_des\":\"\\u9080\\u8bf7\\u597d\\u53cb\\u5206\\u4eab\\u8bdd\\u672f\",\"copyright\":\"\\u4e91\\u8c79\\u4e00\\u5bf9\\u4e00\\u76f4\\u64ad-\\u5f00\\u6e90\\u7248\\u6f14\\u793a\\uff0c\\u5b98\\u65b9\\u7f51\\u7ad9http:\\/\\/www.yunbaokj.com\",\"watermark\":\"\",\"qr_url\":\"\",\"login_type\":\"\",\"share_type\":\"\",\"name_coin\":\"\\u4e91\\u5e01\",\"share_title\":\"\\u5206\\u4eab\\u4e86{username}\\u7684\\u7cbe\\u5f69\\u76f4\\u64ad\\uff01\",\"share_des\":\"\\u6211\\u770b\\u5230\\u4e00\\u4e2a\\u5f88\\u597d\\u770b\\u7684\\u76f4\\u64ad\\uff0c\\u5feb\\u6765\\u8ddf\\u6211\\u4e00\\u8d77\\u56f4\\u89c2\\u5427\",\"sprout_key\":\"\",\"sprout_key_ios\":\"\",\"skin_whiting\":\"5\",\"skin_smooth\":\"5\",\"skin_tenderness\":\"5\",\"eye_brow\":\"10\",\"big_eye\":\"10\",\"eye_length\":\"10\",\"eye_corner\":\"10\",\"eye_alat\":\"10\",\"face_lift\":\"10\",\"face_shave\":\"10\",\"mouse_lift\":\"10\",\"nose_lift\":\"10\",\"chin_lift\":\"10\",\"forehead_lift\":\"10\",\"lengthen_noseLift\":\"10\",\"login_alert_title\":\"\\u670d\\u52a1\\u534f\\u8bae\\u548c\\u9690\\u79c1\\u653f\\u7b56\",\"login_alert_content\":\"\\u8bf7\\u60a8\\u52a1\\u5fc5\\u4ed4\\u7ec6\\u9605\\u8bfb\\uff0c\\u5145\\u5206\\u7406\\u89e3\\u670d\\u52a1\\u534f\\u8bae\\u548c\\u9690\\u79c1\\u653f\\u7b56\\u5404\\u6761\\u6b3e\\uff0c\\u5305\\u62ec\\u4f46\\u4e0d\\u9650\\u4e8e\\u4e3a\\u4e86\\u5411\\u60a8\\u63d0\\u4f9b\\u5373\\u65f6\\u901a\\u8baf\\uff0c\\u5185\\u5bb9\\u5206\\u4eab\\u7b49\\u670d\\u52a1\\uff0c\\u6211\\u4eec\\u9700\\u8981\\u6536\\u96c6\\u60a8\\u8bbe\\u5907\\u4fe1\\u606f\\u548c\\u4e2a\\u4eba\\u4fe1\\u606f\\uff0c\\u60a8\\u53ef\\u4ee5\\u5728\\u8bbe\\u7f6e\\u4e2d\\u67e5\\u770b\\uff0c\\u7ba1\\u7406\\u60a8\\u7684\\u6388\\u6743\\u3002\\u60a8\\u53ef\\u9605\\u8bfb\\u300a\\u9690\\u79c1\\u653f\\u7b56\\u300b\\u548c\\u300a\\u670d\\u52a1\\u534f\\u8bae\\u300b\\u4e86\\u89e3\\u8be6\\u7ec6\\u4fe1\\u606f\\uff0c\\u5982\\u60a8\\u540c\\u610f\\uff0c\\u8bf7\\u70b9\\u51fb\\u540c\\u610f\\u63a5\\u53d7\\u6211\\u4eec\\u7684\\u670d\\u52a1\\u3002\",\"login_clause_title\":\"\\u767b\\u5f55\\u5373\\u4ee3\\u8868\\u540c\\u610f\\u300a\\u9690\\u79c1\\u653f\\u7b56\\u300b\\u548c\\u300a\\u670d\\u52a1\\u534f\\u8bae\\u300b\",\"login_private_title\":\"\\u300a\\u9690\\u79c1\\u653f\\u7b56\\u300b\",\"login_private_url\":\"\\/portal\\/page\\/index?id=26\",\"login_service_title\":\"\\u300a\\u670d\\u52a1\\u534f\\u8bae\\u300b\",\"login_service_url\":\"\\/portal\\/page\\/index?id=38\",\"qr_url_ios\":\"\",\"company_name\":\"\\u4e91\\u8c79\\u77ed\\u89c6\\u9891\\u5f00\\u6e90\\u7248\\u6f14\\u793a\",\"company_desc\":\"\\u672c\\u5f00\\u6e90\\u9879\\u76ee\\u7531\\u4e91\\u8c79\\u79d1\\u6280\\u5b98\\u65b9\\u81ea\\u4e3b\\u7814\\u53d1\\uff0c\\u63d0\\u4f9b\\u5f00\\u6e90\\u77ed\\u89c6\\u9891\\u6e90\\u7801\\u3001\\u642d\\u5efa\\u6587\\u6863\\u3001\\u7591\\u96be\\u8f85\\u52a9\\u8bf4\\u660e\\uff0c\\u4f9b\\u5927\\u5bb6\\u53c2\\u8003\\u3001\\u4ea4\\u6d41\\u3001\\u4f7f\\u7528\\r\\n\\u5f00\\u6e90\\u7248\\u7a0b\\u5e8f\\u4e3b\\u8981\\u56f4\\u7ed5\\u201c\\u77ed\\u89c6\\u9891\\u5f55\\u5236\\u3001\\u53d1\\u5e03\\u3001\\u6d4f\\u89c8\\u3001\\u70b9\\u8bc4\\u8d5e\\u3001\\u6536\\u53d1\\u6d88\\u606f\\u529f\\u80fd\\u201d\\u5c55\\u5f00\\uff0c\\u5982\\u60a8\\u9700\\u8981\\u66f4\\u591a\\u4e13\\u4e1a\\u529f\\u80fd\\u3001\\u4f18\\u8d28\\u670d\\u52a1\\uff0c\\u53ef\\u8054\\u7cfb\\u6211\\u4eec\\u4e86\\u89e3\\u5546\\u7528\\u7248\\u672c\\u3001\\u8fd0\\u8425\\u7248\\u672c\\u3002\",\"wx_siteurl\":\"http:\\/\\/x.com\\/wxshare\\/Share\\/show?roomnum=\",\"brightness\":\"50\",\"recommend_classname\":\"\\u63a8\\u8350\",\"copyright_url\":\"http:\\/\\/www.yunbaokj.com\"}');
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_theme\":\"admin_simpleboot3\",\"admin_style\":\"flatadmin\"}');
INSERT INTO `cmf_option` VALUES (5, 1, 'configpri', '{\"cache_switch\":\"1\",\"cache_time\":\"60\",\"auth_islimit\":\"0\",\"private_letter_switch\":\"1\",\"private_letter_nums\":\"5\",\"video_audit_switch\":\"0\",\"sendcode_switch\":\"0\",\"ccp_sid\":\"\",\"ccp_token\":\"\",\"ccp_appid\":\"\",\"ccp_tempid\":\"\",\"iplimit_switch\":\"0\",\"iplimit_times\":\"5\",\"jpush_key\":\"\",\"jpush_secret\":\"\",\"video_showtype\":\"0\",\"ad_video_switch\":\"1\",\"video_ad_num\":\"5\",\"comment_weight\":\"10000\",\"like_weight\":\"10000\",\"share_weight\":\"10000\",\"show_val\":\"10000\",\"hour_minus_val\":\"1\",\"um_apikey\":\"\",\"um_apisecurity\":\"\",\"um_appkey_android\":\"\",\"um_appkey_ios\":\"\",\"shop_fans\":\"0\",\"shop_videos\":\"0\",\"show_switch\":\"1\",\"agent_reward\":\"10\",\"agent_v_l\":\"1\",\"agent_v_a\":\"30\",\"agent_a\":\"20\",\"aliapp_switch\":\"1\",\"aliapp_partner\":\"\",\"aliapp_seller_id\":\"\",\"aliapp_key\":\"\",\"wx_switch\":\"1\",\"wx_appid\":\"\",\"wx_appsecret\":\"\",\"wx_mchid\":\"\",\"wx_key\":\"\",\"cash_rate\":\"100\",\"cash_min\":\"10\",\"popular_interval\":\"3\",\"popular_base\":\"10\",\"popular_tips\":\"\\u652f\\u4ed8\\u540e\\u89c6\\u9891\\u5c06\\u8fdb\\u5165\\u6295\\u653e\\u9636\\u6bb5\\uff0c\\u5982\\u679c\\u6295\\u653e\\u8fc7\\u7a0b\\u4e2d\\u9047\\u5230\\u5982\\u89c6\\u9891\\u5220\\u9664\\/\\u4eba\\u5de5\\u4e3e\\u62a5\\uff0c\\u6216\\u6295\\u653e\\u65f6\\u95f4\\u7ed3\\u675f\\u672a\\u8fbe\\u5230\\u9884\\u8ba1\\u64ad\\u653e\\u91cf\\u65f6\\uff0c\\u5269\\u4f59\\u672a\\u6d88\\u8017\\u7684\\u91d1\\u989d\\u5c06\\u9000\\u56de\\u5230\\u60a8\\u7684\\u63a8\\u5e7f\\u8d26\\u6237\\u4f59\\u989d\\u4e2d\\uff0c\\u53ef\\u4f9b\\u4e0b\\u6b21\\u8d2d\\u4e70\\u4f7f\\u7528\\u3002\",\"sprout_key\":\"\",\"login_type\":\"\",\"share_type\":\"\",\"qiniu_accesskey\":\"\",\"qiniu_secretkey\":\"\",\"qiniu_bucket\":\"testvideo\",\"qiniu_domain\":\"\",\"qiniu_domain_url\":\"\",\"txcloud_appid\":\"\",\"txcloud_secret_id\":\"\",\"txcloud_secret_key\":\"\",\"txcloud_region\":\"\",\"txcloud_bucket\":\"\",\"tximgfolder\":\"\",\"txvideofolder\":\"\",\"txuserimgfolder\":\"\",\"cloudtype\":\"1\",\"tx_domain_url\":\"\",\"\'cache_switch\'\":\"1\",\"same_device_ip_regnums\":\"10\",\"jpush_sandbox\":\"0\",\"jpush_switch\":\"1\",\"ad_video_loop\":\"1\",\"agent_switch\":\"1\",\"agent_must\":\"0\",\"ios_switch\":\"0\",\"vip_aliapp_switch\":\"1\",\"vip_ios_switch\":\"0\",\"vip_wx_switch\":\"1\",\"vip_coin_switch\":\"1\",\"vip_switch\":\"1\",\"nonvip_upload_nums\":\"5\",\"watch_video_type\":\"0\",\"nonvip_watch_nums\":\"5\",\"tx_private_signature\":\"0\",\"live_videos\":\"0\",\"live_fans\":\"0\",\"tx_appid\":\"\",\"tx_bizid\":\"\",\"tx_push_key\":\"\",\"tx_api_key\":\"\",\"tx_push\":\"\",\"tx_pull\":\"\",\"userlist_time\":\"15\",\"chatserver\":\"http:\\/\\/dspky.yyyybbbb.com:19970\",\"cdn_switch\":\"1\",\"sensitive_words\":\"\\u6bdb\\u6cfd\\u4e1c,\\u6c5f\\u6cfd\\u6c11,\\u6731\\u9555\\u57fa,\\u674e\\u9e4f,\\u9093\\u5c0f\\u5e73,\\u80e1\\u9526\\u6d9b,\\u6e29\\u5bb6\\u5b9d,\\u4e60\\u8fd1\\u5e73,\\u674e\\u514b\\u5f3a,\\u8584\\u7199\\u6765,\\u5468\\u6c38\\u5eb7,\\u50bb\\u903c,\\u6eda\\u4f60\\u5988,\\u654f\\u611f\\u8bcdw,y,b\\r\\n\",\"aliapp_key_ios\":\"\",\"login_wx_appid\":\"\",\"login_wx_appsecret\":\"\",\"qiniu_zone\":\"z0\",\"qiniu_protocol\":\"http\",\"code_switch\":\"1\",\"aly_keydi\":\"\",\"aly_secret\":\"\",\"aly_signName\":\"\",\"aly_templateCode\":\"\",\"aly_keyid\":\"\",\"goods_switch\":\"1\",\"reg_reward\":\"\",\"tx_acc_key\":\"\",\"watch_live_term\":\"6\",\"watch_live_coin\":\"10\",\"watch_video_term\":\"6\",\"watch_video_coin\":\"10\",\"open_live_term\":\"1\",\"open_live_coin\":\"10\",\"award_live_term\":\"500\",\"award_live_coin\":\"500\",\"share_live_term\":\"1\",\"share_live_coin\":\"20\",\"cash_take\":\"25\",\"cash_start\":\"1\",\"cash_end\":\"31\",\"cash_max_times\":\"0\",\"live_txcloud_secret_id\":\"\",\"live_txcloud_secret_key\":\"\",\"aliapp_key_android\":\"\",\"shop_aliapp_switch\":\"1\",\"shop_wx_switch\":\"1\",\"shop_balance_switch\":\"1\",\"shop_system_name\":\"\\u77ed\\u89c6\\u9891\\u5c0f\\u5e97\",\"shop_bond\":\"100\",\"show_category_switch\":\"1\",\"shoporder_percent\":\"10\",\"shop_certificate_desc\":\"\\u4ee5\\u4e0b\\u8425\\u4e1a\\u6267\\u7167\\u4fe1\\u606f\\u6765\\u6e90\\u4e8e\\u4e70\\u5bb6\\u81ea\\u884c\\u7533\\u62a5\\u6216\\u5de5\\u5546\\u7cfb\\u7edf\\u6570\\u636e\\uff0c\\u5177\\u4f53\\u4ee5\\u5de5\\u5546\\u90e8\\u95e8\\u767b\\u8bb0\\u4e3a\\u51c6\\uff0c\\u7ecf\\u8425\\u8005\\u9700\\u8981\\u786e\\u4fdd\\u4fe1\\u606f\\u771f\\u5b9e\\u6709\\u6548\\uff0c\\u5e73\\u53f0\\u4e5f\\u5c06\\u5b9a\\u671f\\u6838\\u67e5\\u3002\\u5982\\u4e0e\\u5b9e\\u9645\\u4e0d\\u7b26\\uff0c\\u4e3a\\u907f\\u514d\\u8fdd\\u89c4\\uff0c\\u8bf7\\u8054\\u7cfb\\u5f53\\u5730\\u5de5\\u5546\\u90e8\\u95e8\\u6216\\u5e73\\u53f0\\u5ba2\\u670d\\u66f4\\u65b0\\u3002\",\"shop_payment_time\":\"3\",\"shop_shipment_time\":\"1\",\"shop_receive_time\":\"2\",\"shop_refund_time\":\"0\",\"shop_refund_finish_time\":\"1\",\"shop_receive_refund_time\":\"1\",\"shop_settlement_time\":\"1\",\"balance_cash_min\":\"1\",\"balance_cash_start\":\"1\",\"balance_cash_end\":\"31\",\"balance_cash_max_times\":\"0\",\"express_id_dev\":\"\",\"express_appkey_dev\":\"\",\"express_id\":\"\",\"express_appkey\":\"\",\"express_type\":\"0\",\"aly_sendcode_type\":\"1\",\"aly_hw_signName\":\"\",\"aly_hw_templateCode\":\"\",\"braintree_paypal_environment\":\"0\",\"braintree_merchantid_sandbox\":\"\",\"braintree_publickey_sandbox\":\"\",\"braintree_privatekey_sandbox\":\"\",\"braintree_merchantid_product\":\"\",\"braintree_publickey_product\":\"\",\"braintree_privatekey_product\":\"\",\"shop_braintree_paypal_switch\":\"1\",\"aws_bucket\":\"\",\"aws_region\":\"\",\"aws_hosturl\":\"\",\"aws_identitypoolid\":\"\",\"openinstall_switch\":\"0\",\"openinstall_appkey\":\"\",\"braintree_paypal_switch\":\"1\",\"vip_braintree_paypal_switch\":\"1\",\"bonus_switch\":\"1\"}');
INSERT INTO `cmf_option` VALUES (6, 1, 'guide', '{\"switch\":\"0\",\"type\":\"0\",\"time\":\"2\"}');
INSERT INTO `cmf_option` VALUES (7, 1, 'storage', '{\"storages\":[],\"type\":\"Local\"}');
INSERT INTO `cmf_option` VALUES (8, 1, 'upload_setting', '{\"max_files\":\"20\",\"chunk_size\":\"512\",\"file_types\":{\"image\":{\"upload_max_filesize\":\"10240\",\"extensions\":\"jpg,jpeg,png,gif,bmp4,svga\"},\"video\":{\"upload_max_filesize\":\"10240\",\"extensions\":\"mp4,m3u8\"},\"audio\":{\"upload_max_filesize\":\"10240\",\"extensions\":\"mp3\"},\"file\":{\"upload_max_filesize\":\"10240\",\"extensions\":\"txt,pdf,doc,docx,xls,xlsx,ppt,pptx,zip,rar,svga\"}}}');
COMMIT;

-- ----------------------------
-- 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`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='插件表';

-- ----------------------------
-- Records of cmf_plugin
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_plugins
-- ----------------------------
DROP TABLE IF EXISTS `cmf_plugins`;
CREATE TABLE `cmf_plugins` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `name` varchar(50) NOT NULL COMMENT '插件名，英文',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '插件名称',
  `description` text COMMENT '插件描述',
  `type` tinyint(2) DEFAULT '0' COMMENT '插件类型, 1:网站；8;微信',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态；1开启；',
  `config` text COMMENT '插件配置',
  `hooks` varchar(255) DEFAULT NULL COMMENT '实现的钩子;以“，”分隔',
  `has_admin` tinyint(2) DEFAULT '0' COMMENT '插件是否有后台管理界面',
  `author` varchar(50) DEFAULT '' COMMENT '插件作者',
  `version` varchar(20) DEFAULT '' COMMENT '插件版本号',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '插件安装时间',
  `listorder` smallint(6) NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cmf_plugins
-- ----------------------------
BEGIN;
INSERT INTO `cmf_plugins` VALUES (2, 'Demo', '插件演示', '插件演示', 0, 1, '{\"text\":\"hello,ThinkCMF!\",\"password\":\"\",\"select\":\"1\",\"checkbox\":[\"1\"],\"radio\":\"1\",\"textarea\":\"\\u8fd9\\u91cc\\u662f\\u4f60\\u8981\\u586b\\u5199\\u7684\\u5185\\u5bb9\'\"}', 'footer', 1, 'ThinkCMF', '1.0', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for cmf_posts
-- ----------------------------
DROP TABLE IF EXISTS `cmf_posts`;
CREATE TABLE `cmf_posts` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `post_author` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '发表者id',
  `post_keywords` varchar(150) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'seo keywords',
  `post_source` varchar(150) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '转载文章的来源',
  `post_content` longtext CHARACTER SET utf8mb4 COMMENT 'post内容',
  `post_title` varchar(255) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'post标题',
  `post_excerpt` varchar(255) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'post摘要',
  `post_status` int(2) NOT NULL DEFAULT '1' COMMENT 'post状态，1已审核，0未审核,3删除',
  `post_parent` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'post的父级post id,表示post层级关系',
  `smeta` text CHARACTER SET utf8mb4 COMMENT 'post的扩展字段，保存相关扩展属性，如缩略图；格式为json',
  `post_hits` int(11) NOT NULL DEFAULT '0' COMMENT 'post点击数，查看数',
  `istop` tinyint(1) NOT NULL DEFAULT '0' COMMENT '置顶 1置顶； 0不置顶',
  `recommended` tinyint(1) NOT NULL DEFAULT '0' COMMENT '推荐 1推荐 0不推荐',
  `termid` bigint(20) NOT NULL DEFAULT '0' COMMENT '分类id',
  `post_relevant` varchar(255) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '相关阅读',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '分类路径',
  `topval` int(11) NOT NULL DEFAULT '0' COMMENT '置顶值',
  `orderno` int(11) NOT NULL DEFAULT '0' COMMENT '序号',
  `post_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '文章类型 0文章 1单页',
  `post_date` int(11) NOT NULL DEFAULT '0',
  `post_modified` int(11) NOT NULL DEFAULT '0',
  `post_title_en` varchar(255) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'post标题',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `type_status_date` (`post_status`,`id`) USING BTREE,
  KEY `post_parent` (`post_parent`) USING BTREE,
  KEY `post_author` (`post_author`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=164 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Portal文章表';

-- ----------------------------
-- Records of cmf_posts
-- ----------------------------
BEGIN;
INSERT INTO `cmf_posts` VALUES (26, 1, '', '', '<p>隐私政策</p>', '隐私政策', '', 1, 0, NULL, 0, 0, 0, 0, '', '', 0, 0, 1, 1575353776, 0, 'Privacy policy');
INSERT INTO `cmf_posts` VALUES (38, 1, '', '', '<p>服务协议</p>', '服务协议', '', 1, 0, NULL, 0, 0, 0, 0, '', '', 0, 0, 1, 1579138709, 0, '');
INSERT INTO `cmf_posts` VALUES (148, 1, '', '', '<p>常见问题1</p>', '常见问题1', '', 1, 0, NULL, 0, 0, 0, 13, '', '', 0, 4, 0, 1579137934, 0, '');
INSERT INTO `cmf_posts` VALUES (149, 1, '', '', '<p>常见问题2</p>', '常见问题2', '', 1, 0, NULL, 0, 0, 0, 13, '', '', 0, 5, 0, 1579137947, 0, '');
INSERT INTO `cmf_posts` VALUES (163, 1, '', '', '<p>联系客服</p>', '联系客服', '', 1, 0, NULL, 0, 0, 0, 11, '', '', 0, 0, 0, 1650965205, 0, '');
COMMIT;

-- ----------------------------
-- 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`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT=' 回收站';

-- ----------------------------
-- Records of cmf_recycle_bin
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_role
-- ----------------------------
DROP TABLE IF EXISTS `cmf_role`;
CREATE TABLE `cmf_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '角色名称',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父角色ID',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态;0:禁用;1:正常',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `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 '排序',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `parent_id` (`parent_id`) USING BTREE,
  KEY `status` (`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='角色表';

-- ----------------------------
-- Records of cmf_role
-- ----------------------------
BEGIN;
INSERT INTO `cmf_role` VALUES (1, '超级管理员', 0, 1, '拥有网站最高管理员权限！', 1329633709, 1329633709, 0);
COMMIT;

-- ----------------------------
-- 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`) USING BTREE,
  KEY `role_id` (`role_id`) USING BTREE,
  KEY `user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户角色对应表';

-- ----------------------------
-- Records of cmf_role_user
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- 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`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='url路由表';

-- ----------------------------
-- Records of cmf_route
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- 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`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='幻灯片表';

-- ----------------------------
-- Records of cmf_slide
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- 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`) USING BTREE,
  KEY `slide_id` (`slide_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='幻灯片子项表';

-- ----------------------------
-- Records of cmf_slide_item
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_terms
-- ----------------------------
DROP TABLE IF EXISTS `cmf_terms`;
CREATE TABLE `cmf_terms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类id',
  `name` varchar(200) DEFAULT NULL COMMENT '分类名称',
  `count` bigint(20) DEFAULT '0' COMMENT '分类文章数',
  `seo_title` varchar(500) DEFAULT NULL,
  `seo_keywords` varchar(500) DEFAULT NULL,
  `seo_description` varchar(500) DEFAULT NULL,
  `listorder` int(5) NOT NULL DEFAULT '0' COMMENT '排序',
  `parentid` int(11) NOT NULL DEFAULT '0',
  `path` varchar(255) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Portal 文章分类表';

-- ----------------------------
-- Records of cmf_terms
-- ----------------------------
BEGIN;
INSERT INTO `cmf_terms` VALUES (11, '关于我们', 0, '关于我们', '', '', 0, 0, '');
INSERT INTO `cmf_terms` VALUES (13, '常见问题', 0, '常见问题', '', '', 0, 0, '');
COMMIT;

-- ----------------------------
-- 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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_theme
-- ----------------------------
BEGIN;
INSERT INTO `cmf_theme` VALUES (1, 0, 0, 0, 0, 'default', 'default', '1.0.0', 'http://demo.thinkcmf.com', '', 'ThinkCMF', 'http://www.thinkcmf.com', 'zh-cn', 'ThinkCMF默认模板', 'ThinkCMF默认模板');
COMMIT;

-- ----------------------------
-- 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`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_theme_file
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_user
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user`;
CREATE TABLE `cmf_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_login` varchar(60) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '用户名',
  `user_pass` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '登录密码；sp_password加密',
  `user_nicename` varchar(50) NOT NULL DEFAULT '' COMMENT '用户美名',
  `user_email` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '登录邮箱',
  `user_url` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '用户个人网站',
  `avatar` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '用户头像，相对于upload/avatar目录',
  `avatar_thumb` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `sex` smallint(1) NOT NULL DEFAULT '2' COMMENT '性别；0：保密，1：男；2：女',
  `age` int(10) NOT NULL DEFAULT '-1' COMMENT '年龄',
  `birthday` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '生日',
  `signature` varchar(255) NOT NULL DEFAULT '' COMMENT '个性签名',
  `last_login_ip` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '最后登录ip',
  `last_login_time` int(11) NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间',
  `user_activation_key` varchar(60) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '激活码',
  `user_status` int(11) NOT NULL DEFAULT '1' COMMENT '用户状态 0：禁用； 1：正常 ；2：未验证 3：已注销',
  `score` int(11) NOT NULL DEFAULT '0' COMMENT '用户积分',
  `user_type` smallint(1) NOT NULL DEFAULT '1' COMMENT '用户类型，1:admin ;2:会员',
  `coin` int(20) unsigned NOT NULL DEFAULT '0' COMMENT '金币',
  `mobile` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '手机号',
  `province` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '省',
  `city` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '市',
  `area` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '区',
  `login_type` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT 'phone',
  `isauth` tinyint(1) NOT NULL DEFAULT '0',
  `source` varchar(255) NOT NULL DEFAULT 'pc' COMMENT '注册来源android/ios/pc',
  `mobileid` varchar(255) NOT NULL DEFAULT '' COMMENT '手机唯一识别码',
  `ip` bigint(20) NOT NULL DEFAULT '0' COMMENT 'ip地址ip2long 格式化',
  `country_code` int(11) NOT NULL DEFAULT '86' COMMENT '国家代号',
  `is_firstlogin` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否第一次登陆 0 否 1 是',
  `bg_img` varchar(255) NOT NULL DEFAULT '' COMMENT '背景图',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `user_login` (`user_login`) USING BTREE,
  KEY `user_login_key` (`user_login`) USING BTREE,
  KEY `user_nicename` (`user_nicename`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=20729 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cmf_user
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user` VALUES (1, 'admin', '###f283504ac9cdbb3a0ae187704498794b', 'admin', 'admin@qq.com', '', '', '', 1, 0, '', '', '39.85.102.58', 1651643102, 1457311672, '', 1, 0, 1, 0, '', '', '', '', 'phone', 0, 'pc', '', 0, 86, 0, '');
INSERT INTO `cmf_user` VALUES (20725, '15077777777', '###949a767e207d30111458bd34f62873ed', '测试', '', '', '/default.png', '/default_thumb.png', 1, -1, '2000-01-01', '这家伙很懒，什么都没留下', '', 0, 1650531101, '', 1, 0, 2, 0, '', '', '', '', 'phone', 0, 'pc', '', 0, 86, 0, '/default.png');
INSERT INTO `cmf_user` VALUES (20726, '13355558888', '###ea1e6729b1bcd5575033baf0e8cd127b', '手机用户8888', '', '', '20220425170054_95b94f974d18d90997ba41ae429a2695?imageView2/2/w/600/h/600%@%cloudtype=1', '20220425170054_95b94f974d18d90997ba41ae429a2695?imageView2/2/w/200/h/200%@%cloudtype=1', 2, 22, '2000-01-01', '这家伙很懒，什么都没留下', '39.85.102.58', 1650880498, 1650857475, '', 1, 0, 2, 0, '13355558888', '', '', '', 'phone', 0, 'android', '8e4a008d96b367867ece3d80e9f05f79', 659908154, 86, 0, 'android_20726_20220425_170125_073841.jpg%@%cloudtype=1');
INSERT INTO `cmf_user` VALUES (20727, '17811111111', '###ea1e6729b1bcd5575033baf0e8cd127b', '橘子郡着', '', '', '20220426170428_4306eadfa86aa8560c0dae3800a05ec5?imageView2/2/w/600/h/600%@%cloudtype=1', '20220426170428_4306eadfa86aa8560c0dae3800a05ec5?imageView2/2/w/200/h/200%@%cloudtype=1', 2, 24, '1998-04-26', '哈哈哈哈', '123.135.78.124', 1650962674, 1650962674, '', 1, 0, 2, 0, '17811111111', '北京市', '北京市', '东城区', 'phone', 0, 'android', '41a3097961efc4a891024fe0424da313', 2072465020, 86, 0, 'android_20727_20220426_170438_9552342.jpg%@%cloudtype=1');
INSERT INTO `cmf_user` VALUES (20728, '17822222222', '###ea1e6729b1bcd5575033baf0e8cd127b', '小宇哥', '', '', '/default.png', '/default_thumb.png', 2, 22, '2000-01-01', '这家伙很懒，什么都没留下', '123.135.78.124', 1651625648, 1651021959, '', 1, 0, 2, 0, '17822222222', '', '', '', 'phone', 0, 'android', '41a3097961efc4a891024fe0424da313', 2072465020, 86, 0, '/default.png');
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_attention
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_attention`;
CREATE TABLE `cmf_user_attention` (
  `uid` int(12) NOT NULL DEFAULT '0',
  `touid` int(12) NOT NULL DEFAULT '0',
  `addtime` int(12) DEFAULT '0' COMMENT '添加时间',
  KEY `uid_touid_index` (`uid`,`touid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cmf_user_attention
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_attention` VALUES (20726, 20725, 1650880517);
INSERT INTO `cmf_user_attention` VALUES (20727, 20726, 1650963546);
INSERT INTO `cmf_user_attention` VALUES (20728, 20726, 1651021964);
INSERT INTO `cmf_user_attention` VALUES (20728, 20727, 1651026105);
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_black
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_black`;
CREATE TABLE `cmf_user_black` (
  `uid` int(12) DEFAULT '0',
  `touid` int(12) DEFAULT '0',
  `addtime` int(12) DEFAULT '0' COMMENT '添加时间',
  KEY `uid_touid_index` (`uid`,`touid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_user_black
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_charge
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_charge`;
CREATE TABLE `cmf_user_charge` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
  `touid` int(11) NOT NULL DEFAULT '0' COMMENT '充值对象ID',
  `money` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
  `coin` int(11) NOT NULL DEFAULT '0' COMMENT '钻石数',
  `coin_give` int(11) NOT NULL DEFAULT '0' COMMENT '赠送钻石数',
  `orderno` varchar(50) NOT NULL DEFAULT '' COMMENT '商家订单号',
  `trade_no` varchar(100) NOT NULL DEFAULT '' COMMENT '三方平台订单号',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `addtime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '支付类型 1 支付宝 2 微信 3 ios 4 微信小程序 5 paypal 6 braintree_paypal',
  `ambient` tinyint(1) NOT NULL DEFAULT '0' COMMENT '支付环境',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cmf_user_charge
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_music
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_music`;
CREATE TABLE `cmf_user_music` (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `title` varchar(255) DEFAULT '' COMMENT '音乐名称',
  `author` varchar(255) DEFAULT '' COMMENT '演唱者',
  `uploader` int(255) DEFAULT '0' COMMENT '上传者ID',
  `upload_type` tinyint(1) DEFAULT '0' COMMENT '上传类型  1管理员上传 2 用户上传',
  `img_url` varchar(255) DEFAULT '' COMMENT '封面地址',
  `length` varchar(255) DEFAULT '' COMMENT '音乐长度',
  `file_url` varchar(255) DEFAULT '' COMMENT '文件地址',
  `use_nums` int(12) DEFAULT '0' COMMENT '被使用次数',
  `isdel` tinyint(1) DEFAULT '0' COMMENT '是否被删除 0否 1是',
  `addtime` int(12) DEFAULT '0' COMMENT '添加时间',
  `updatetime` int(12) DEFAULT '0' COMMENT '更新时间',
  `classify_id` int(12) DEFAULT '0' COMMENT '音乐分类ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_user_music
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_music` VALUES (1, 'Panama', 'Matteo', 1, 1, '20220504/6271cf6008a00.jpg%@%cloudtype=1', '00:31', '20220504/6271cfa0626f8.mp3%@%cloudtype=1', 123, 0, 1528535261, 1651625888, 2);
INSERT INTO `cmf_user_music` VALUES (3, 'California (On My Mind)', 'Stewart Mac', 1, 1, '20220504/6271cf48c35f9.jpg%@%cloudtype=1', '00:29', '20220504/6271cf4e3eeb1.mp3%@%cloudtype=1', 283, 0, 1529747678, 1651625806, 3);
INSERT INTO `cmf_user_music` VALUES (4, '最美的期待', '周笔畅', 1, 1, '20220504/6271cfbbb9b35.png%@%cloudtype=1', '00:22', '20220504/6271cfc2736b6.mp3%@%cloudtype=1', 105, 0, 1530090995, 1651625922, 4);
INSERT INTO `cmf_user_music` VALUES (5, 'Friendshipss', 'Pascal Letoublon', 1, 1, '20220504/6271cf3542d1c.jpg%@%cloudtype=1', '00:40', '20220504/6271cf3b1f5fc.mp3%@%cloudtype=1', 1037, 0, 1530095432, 1651625787, 5);
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_music_classify
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_music_classify`;
CREATE TABLE `cmf_user_music_classify` (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `title` varchar(255) DEFAULT '' COMMENT '分类名称',
  `orderno` int(12) DEFAULT '0' COMMENT '排序号',
  `isdel` tinyint(1) DEFAULT '0' COMMENT '是否删除',
  `addtime` int(12) DEFAULT '0' COMMENT '添加时间',
  `updatetime` int(12) DEFAULT '0' COMMENT '修改时间',
  `img_url` varchar(255) DEFAULT '' COMMENT '分类图标地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_user_music_classify
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_music_classify` VALUES (2, '热歌', 3, 0, 1528507131, 0, '20220428/626a63a294bd7.png%@%cloudtype=1');
INSERT INTO `cmf_user_music_classify` VALUES (3, '新歌', 2, 0, 1528699743, 0, '20220428/626a63bed7f20.png%@%cloudtype=1');
INSERT INTO `cmf_user_music_classify` VALUES (4, '经典', 3, 0, 1530090922, 0, '20220428/626a638f3e7a8.png%@%cloudtype=1');
INSERT INTO `cmf_user_music_classify` VALUES (5, '流行', 4, 0, 1531358655, 0, '20220428/626a63c9de426.png%@%cloudtype=1');
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_music_collection
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_music_collection`;
CREATE TABLE `cmf_user_music_collection` (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `uid` int(12) DEFAULT '0' COMMENT '用户id',
  `music_id` int(12) DEFAULT '0' COMMENT '音乐id',
  `addtime` int(12) DEFAULT '0' COMMENT '添加时间',
  `updatetime` int(12) DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(1) DEFAULT '1' COMMENT '音乐收藏状态 1收藏 0 取消收藏',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_user_music_collection
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_music_collection` VALUES (1, 20726, 5, 1650877457, 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_report
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_report`;
CREATE TABLE `cmf_user_report` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT '0',
  `touid` int(11) DEFAULT '0',
  `content` varchar(255) DEFAULT '',
  `status` tinyint(1) DEFAULT '0',
  `addtime` int(11) DEFAULT '0',
  `uptime` int(11) DEFAULT '0',
  `thumb` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '图片地址',
  `contact_msg` varchar(255) DEFAULT '' COMMENT '联系方式',
  `classify` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '举报类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_user_report
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_report` VALUES (1, 20728, 20726, '谷胱甘肽', 1, 1651022279, 1651022309, '', '', '头像、昵称、签名违规');
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_report_classify
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_report_classify`;
CREATE TABLE `cmf_user_report_classify` (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `title` varchar(255) DEFAULT '' COMMENT '分类名称',
  `orderno` int(12) DEFAULT '0' COMMENT '排序号',
  `isdel` tinyint(1) DEFAULT '0' COMMENT '是否删除',
  `addtime` int(12) DEFAULT '0' COMMENT '添加时间',
  `updatetime` int(12) DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_user_report_classify
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_report_classify` VALUES (1, '发布垃圾广告、售卖假货', 4, 0, 1528448412, 1589250866);
INSERT INTO `cmf_user_report_classify` VALUES (2, '色情低俗', 9, 0, 1528507131, 1532673373);
INSERT INTO `cmf_user_report_classify` VALUES (3, '政治敏感', 12, 0, 1528699743, 0);
INSERT INTO `cmf_user_report_classify` VALUES (4, '违法犯罪', 1, 0, 1530090922, 1651022131);
INSERT INTO `cmf_user_report_classify` VALUES (5, '冒充官员', 14, 0, 1531358655, 0);
INSERT INTO `cmf_user_report_classify` VALUES (6, '盗用TA人作品', 2, 0, 1531358676, 1583976058);
INSERT INTO `cmf_user_report_classify` VALUES (7, '疑似自我伤害', 3, 0, 1531358690, 0);
INSERT INTO `cmf_user_report_classify` VALUES (17, '侵犯隐私', 5, 0, 1532673227, 0);
INSERT INTO `cmf_user_report_classify` VALUES (18, '造谣传谣、涉嫌欺诈', 11, 0, 1532673245, 0);
INSERT INTO `cmf_user_report_classify` VALUES (19, '侮辱谩骂', 6, 0, 1532673268, 0);
INSERT INTO `cmf_user_report_classify` VALUES (20, '头像、昵称、签名违规', 7, 0, 1532673300, 0);
INSERT INTO `cmf_user_report_classify` VALUES (21, '其他', 8, 0, 1533028050, 0);
INSERT INTO `cmf_user_report_classify` VALUES (22, '冒犯官员', 10, 0, 1536300202, 0);
INSERT INTO `cmf_user_report_classify` VALUES (23, '违法直播', 13, 0, 1536300272, 1536300318);
COMMIT;

-- ----------------------------
-- 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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='用户客户端登录 token 表';

-- ----------------------------
-- Records of cmf_user_token
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_token` VALUES (1, 1, 1665813407, 1650261407, '02ee466c91b621a0acb9a774ea744528877e449ac4ad66f82c52eea524d732a6', 'web');
INSERT INTO `cmf_user_token` VALUES (2, 20726, 1676800498, 1650880498, 'd6725f4c71d32ad5255a5cc4057db05b', '');
INSERT INTO `cmf_user_token` VALUES (3, 20727, 1676882674, 1650962674, 'e0359d79a6ab08203e9f5ef1b45f04e8', '');
INSERT INTO `cmf_user_token` VALUES (4, 20728, 1677545648, 1651625648, 'ecd42ede4098c011f05236b129660abb', '');
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_video
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_video`;
CREATE TABLE `cmf_user_video` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `thumb` varchar(255) NOT NULL DEFAULT '' COMMENT '封面图片',
  `thumb_s` varchar(255) NOT NULL DEFAULT '' COMMENT '封面小图',
  `href` varchar(255) NOT NULL DEFAULT '' COMMENT '视频地址',
  `href_w` varchar(255) NOT NULL DEFAULT '' COMMENT '水印视频',
  `likes` int(11) NOT NULL DEFAULT '0' COMMENT '点赞数',
  `views` int(11) NOT NULL DEFAULT '1' COMMENT '浏览数（涉及到推荐排序机制，所以默认为1）',
  `comments` int(11) NOT NULL DEFAULT '0' COMMENT '评论数',
  `steps` int(11) NOT NULL DEFAULT '0' COMMENT '踩总数',
  `shares` int(11) NOT NULL DEFAULT '0' COMMENT '分享数量',
  `addtime` int(11) NOT NULL DEFAULT '0' COMMENT '发布时间',
  `lat` varchar(255) NOT NULL DEFAULT '' COMMENT '维度',
  `lng` varchar(255) NOT NULL DEFAULT '' COMMENT '经度',
  `city` varchar(255) NOT NULL DEFAULT '' COMMENT '城市',
  `isdel` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除 1删除（下架）0不下架',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '视频状态 0未审核 1通过 2拒绝',
  `music_id` int(12) NOT NULL DEFAULT '0' COMMENT '背景音乐ID',
  `xiajia_reason` varchar(255) NOT NULL DEFAULT '' COMMENT '下架原因',
  `watch_ok` int(12) NOT NULL DEFAULT '1' COMMENT '视频完整看完次数(涉及到推荐排序机制，所以默认为1)',
  `orderno` int(12) NOT NULL DEFAULT '0' COMMENT '权重值，数字越大越靠前',
  `anyway` varchar(10) NOT NULL DEFAULT '1.1' COMMENT '横竖屏(封面-高/宽)，大于1表示竖屏,小于1表示横屏',
  `reason` varchar(255) NOT NULL DEFAULT '' COMMENT '审核事由',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cmf_user_video
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_video` VALUES (1, 20725, '发发发发发', 'http://ybtestvideo.yunbaozb.com/20220424/6264c03168d60.png', 'http://ybtestvideo.yunbaozb.com/20220424/6264c03168d60.png', '20220424/6264c037c79af.mp4%@%cloudtype=1', '20220424/6264c039370b1.mp4%@%cloudtype=1', 1, 1, 1, 0, 0, 1650769975, '', '', '', 0, 1, 0, '', 239, 0, '1', '');
INSERT INTO `cmf_user_video` VALUES (2, 20726, 'jkckkxkkdkskss', 'android_20726_20220425_152034_6008712_c.jpg%@%cloudtype=1', 'android_20726_20220425_152034_6008712_c.jpg?imageView2/2/w/200/h/200%@%cloudtype=1', 'android_20726_20220425_152034_6008712.mp4%@%cloudtype=1', 'android_20726_20220425_152034_6008712.mp4%@%cloudtype=1', 0, 1, 5, 0, 0, 1650871263, '36.177991', '117.0863', '泰安', 1, 1, 0, '', 9, 0, '1.778', '');
INSERT INTO `cmf_user_video` VALUES (3, 20726, 'hjjjkkkk', 'android_20726_20220425_173712_7522083_c.jpg%@%cloudtype=1', 'android_20726_20220425_173712_7522083_c.jpg?imageView2/2/w/200/h/200%@%cloudtype=1', 'android_20726_20220425_173712_7522083.mp4%@%cloudtype=1', 'android_20726_20220425_173712_7522083.mp4%@%cloudtype=1', 1, 1, 2, 0, 0, 1650879455, '36.177991', '117.0863', '泰安', 1, 1, 0, '', 48, 0, '1.778', '');
INSERT INTO `cmf_user_video` VALUES (5, 20727, 'hhh', 'android_20727_20220426_165206_0723196_c.jpg%@%cloudtype=1', 'android_20727_20220426_165206_0723196_c.jpg?imageView2/2/w/200/h/200%@%cloudtype=1', 'android_20727_20220426_165206_0723196.mp4%@%cloudtype=1', 'android_20727_20220426_165206_0723196.mp4%@%cloudtype=1', 0, 1, 0, 0, 0, 1650963161, '0.0', '0.0', '', 0, 1, 0, '', 4, 0, '1.778', '');
INSERT INTO `cmf_user_video` VALUES (6, 20727, '很想你', 'android_20727_20220426_165526_6392692_c.jpg%@%cloudtype=1', 'android_20727_20220426_165526_6392692_c.jpg?imageView2/2/w/200/h/200%@%cloudtype=1', 'android_20727_20220426_165526_6392692.mp4%@%cloudtype=1', 'android_20727_20220426_165526_6392692.mp4%@%cloudtype=1', 1, 1, 0, 0, 0, 1650963360, '0.0', '0.0', '', 0, 1, 0, '', 11, 0, '1.778', '');
INSERT INTO `cmf_user_video` VALUES (7, 20727, '', 'android_20727_20220426_165627_5459067_c.jpg%@%cloudtype=1', 'android_20727_20220426_165627_5459067_c.jpg?imageView2/2/w/200/h/200%@%cloudtype=1', 'android_20727_20220426_165627_5459067.mp4%@%cloudtype=1', 'android_20727_20220426_165627_5459067.mp4%@%cloudtype=1', 0, 1, 0, 0, 0, 1650963462, '0.0', '0.0', '', 0, 1, 0, '', 84, 0, '1.778', '');
INSERT INTO `cmf_user_video` VALUES (8, 20728, '', 'android_20728_20220427_091625_730434_c.jpg%@%cloudtype=1', 'android_20728_20220427_091625_730434_c.jpg?imageView2/2/w/200/h/200%@%cloudtype=1', 'android_20728_20220427_091625_730434.mp4%@%cloudtype=1', 'android_20728_20220427_091625_730434.mp4%@%cloudtype=1', 0, 1, 1, 0, 0, 1651022199, '0.0', '0.0', '', 0, 1, 0, '', 1, 0, '1.778', '');
INSERT INTO `cmf_user_video` VALUES (9, 20728, '', 'http://ybtestvideo.yunbaozb.com/android_20728_20220427_092918_3728289_c.jpg', 'http://ybtestvideo.yunbaozb.com/android_20728_20220427_092918_3728289_c.jpg', 'android_20728_20220427_092918_3728289.mp4%@%cloudtype=1', 'android_20728_20220427_092918_3728289.mp4%@%cloudtype=1', 0, 1, 0, 0, 0, 1651022971, '0.0', '0.0', '', 0, 1, 0, '', 1, 0, '2', '');
INSERT INTO `cmf_user_video` VALUES (10, 20728, '', 'android_20728_20220427_093134_3127597_c.jpg%@%cloudtype=1', 'android_20728_20220427_093134_3127597_c.jpg?imageView2/2/w/200/h/200%@%cloudtype=1', 'android_20728_20220427_093134_3127597.mp4%@%cloudtype=1', 'android_20728_20220427_093134_3127597.mp4%@%cloudtype=1', 0, 1, 0, 0, 0, 1651023125, '0.0', '0.0', '', 0, 0, 0, '', 1, 0, '1.778', '');
INSERT INTO `cmf_user_video` VALUES (11, 20728, '', 'android_20728_20220427_095419_799627_c.jpg%@%cloudtype=1', 'android_20728_20220427_095419_799627_c.jpg?imageView2/2/w/200/h/200%@%cloudtype=1', 'android_20728_20220427_095419_799627.mp4%@%cloudtype=1', 'android_20728_20220427_095419_799627.mp4%@%cloudtype=1', 0, 1, 0, 0, 0, 1651024472, '0.0', '0.0', '', 0, 1, 0, '', 2, 0, '1.778', '');
INSERT INTO `cmf_user_video` VALUES (12, 20728, '', 'android_20728_20220428_142857_2895756_c.jpg%@%cloudtype=1', 'android_20728_20220428_142857_2895756_c.jpg?imageView2/2/w/200/h/200%@%cloudtype=1', 'android_20728_20220428_142857_2895756.mp4%@%cloudtype=1', 'android_20728_20220428_142857_2895756.mp4%@%cloudtype=1', 0, 1, 0, 0, 0, 1651127364, '0.0', '0.0', '', 0, 1, 0, '', 1, 0, '2.222', '');
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_video_comments
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_video_comments`;
CREATE TABLE `cmf_user_video_comments` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL DEFAULT '0' COMMENT '用户id',
  `touid` int(10) NOT NULL DEFAULT '0' COMMENT '被评论用户id',
  `videoid` int(10) NOT NULL DEFAULT '0' COMMENT '视频id',
  `commentid` int(10) NOT NULL DEFAULT '0' COMMENT '评论信息id',
  `parentid` int(10) NOT NULL DEFAULT '0' COMMENT '上级id',
  `content` text COMMENT '评论内容',
  `likes` int(11) NOT NULL DEFAULT '0' COMMENT '点赞数',
  `addtime` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `at_info` varchar(255) NOT NULL DEFAULT '' COMMENT '评论时被@用户的信息（json串）',
  `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型，0文字1语音',
  `voice` varchar(255) NOT NULL DEFAULT '' COMMENT '语音链接',
  `length` int(11) NOT NULL DEFAULT '0' COMMENT '语音时长',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `id_index` (`id`) USING BTREE,
  KEY `uid_touid_index` (`uid`,`touid`) USING BTREE,
  KEY `videoid_index` (`videoid`) USING BTREE,
  KEY `commentid_index` (`commentid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cmf_user_video_comments
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_video_comments` VALUES (1, 20726, 20726, 2, 0, 0, 'nxnnsjjs', 0, 1650871277, '', 0, '', 0);
INSERT INTO `cmf_user_video_comments` VALUES (2, 20726, 20726, 2, 0, 0, 'nxnmzms', 1, 1650871295, '', 0, '', 0);
INSERT INTO `cmf_user_video_comments` VALUES (3, 20726, 20726, 2, 0, 0, 'nxnmzms', 0, 1650871303, '', 0, '', 0);
INSERT INTO `cmf_user_video_comments` VALUES (4, 20726, 20725, 1, 0, 0, '[呲牙][睡][害羞][害羞]', 0, 1650872204, '', 0, '', 0);
INSERT INTO `cmf_user_video_comments` VALUES (5, 20727, 20726, 3, 0, 0, '纯纯粹粹', 0, 1650963552, '', 0, '', 0);
INSERT INTO `cmf_user_video_comments` VALUES (6, 20727, 20726, 3, 0, 0, '[色]', 0, 1650963558, '', 0, '', 0);
INSERT INTO `cmf_user_video_comments` VALUES (7, 20728, 20726, 2, 2, 2, '几号回家', 0, 1651021971, '', 0, '', 0);
INSERT INTO `cmf_user_video_comments` VALUES (8, 20728, 20726, 2, 0, 0, '[微笑][微笑]', 0, 1651021981, '', 0, '', 0);
INSERT INTO `cmf_user_video_comments` VALUES (9, 20728, 20728, 8, 0, 0, '近近景近景', 0, 1651022240, '', 0, '', 0);
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_video_comments_like
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_video_comments_like`;
CREATE TABLE `cmf_user_video_comments_like` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT '0',
  `commentid` int(10) DEFAULT '0',
  `addtime` int(10) DEFAULT '0',
  `touid` int(12) DEFAULT '0' COMMENT '被喜欢的评论者id',
  `videoid` int(12) DEFAULT '0' COMMENT '评论所属视频id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_user_video_comments_like
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_video_comments_like` VALUES (1, 20728, 2, 1651021976, 20726, 2);
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_video_comments_messages
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_video_comments_messages`;
CREATE TABLE `cmf_user_video_comments_messages` (
  `id` int(12) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `uid` int(12) DEFAULT '0' COMMENT '用户id',
  `videoid` int(12) DEFAULT '0' COMMENT '视频id',
  `touid` int(12) DEFAULT '0' COMMENT '被@的用户id',
  `addtime` int(12) DEFAULT '0',
  `content` varchar(255) DEFAULT '' COMMENT '评论内容',
  `status` tinyint(1) DEFAULT '1' COMMENT '是否显示 0否 1 是  （根据视频是否下架决定）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_user_video_comments_messages
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_video_comments_messages` VALUES (1, 20726, 1, 20725, 1650872204, '[呲牙][睡][害羞][害羞]', 1);
INSERT INTO `cmf_user_video_comments_messages` VALUES (2, 20727, 3, 20726, 1650963552, '纯纯粹粹', 1);
INSERT INTO `cmf_user_video_comments_messages` VALUES (3, 20727, 3, 20726, 1650963558, '[色]', 1);
INSERT INTO `cmf_user_video_comments_messages` VALUES (4, 20728, 2, 20726, 1651021971, '几号回家', 1);
INSERT INTO `cmf_user_video_comments_messages` VALUES (5, 20728, 2, 20726, 1651021981, '[微笑][微笑]', 1);
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_video_like
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_video_like`;
CREATE TABLE `cmf_user_video_like` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT '0',
  `videoid` int(10) DEFAULT '0',
  `addtime` int(10) DEFAULT '0',
  `status` tinyint(1) DEFAULT '1' COMMENT '视频是否被删除或被拒绝 0被删除或被拒绝 1 正常',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `uid_videoid` (`uid`,`videoid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_user_video_like
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_video_like` VALUES (1, 20726, 1, 1650868276, 1);
INSERT INTO `cmf_user_video_like` VALUES (2, 20727, 3, 1650963548, 1);
INSERT INTO `cmf_user_video_like` VALUES (3, 20728, 6, 1651026059, 1);
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_video_report
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_video_report`;
CREATE TABLE `cmf_user_video_report` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT '0',
  `touid` int(11) DEFAULT '0',
  `videoid` int(11) DEFAULT '0' COMMENT '视频ID',
  `content` varchar(255) DEFAULT '',
  `status` tinyint(1) DEFAULT '0' COMMENT '0处理中 1已处理  2审核失败',
  `addtime` int(11) DEFAULT '0',
  `uptime` int(11) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_user_video_report
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_video_report` VALUES (1, 20727, 20726, 3, '任性打抱不平，就爱举报', 0, 1650965499, 0);
INSERT INTO `cmf_user_video_report` VALUES (2, 20728, 20726, 2, '低俗色情', 1, 1651022147, 1651022255);
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_video_report_classify
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_video_report_classify`;
CREATE TABLE `cmf_user_video_report_classify` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `orderno` int(10) DEFAULT '0' COMMENT '排序',
  `name` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '举报类型名称',
  `addtime` int(10) DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_user_video_report_classify
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_video_report_classify` VALUES (1, 8, '骗取点击', 1513579351);
INSERT INTO `cmf_user_video_report_classify` VALUES (2, 2, '低俗色情', 1513579668);
INSERT INTO `cmf_user_video_report_classify` VALUES (3, 3, '侮辱谩骂', 1513579677);
INSERT INTO `cmf_user_video_report_classify` VALUES (4, 4, '盗用TA人作品', 1513579689);
INSERT INTO `cmf_user_video_report_classify` VALUES (5, 5, '引人不适', 1513579700);
INSERT INTO `cmf_user_video_report_classify` VALUES (10, 6, '任性打抱不平，就爱举报', 1521191977);
COMMIT;

-- ----------------------------
-- Table structure for cmf_user_video_view
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_video_view`;
CREATE TABLE `cmf_user_video_view` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT '0',
  `videoid` int(10) DEFAULT '0',
  `addtime` int(10) DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of cmf_user_video_view
-- ----------------------------
BEGIN;
INSERT INTO `cmf_user_video_view` VALUES (1, 20726, 1, 1650966221, 1);
INSERT INTO `cmf_user_video_view` VALUES (2, 20727, 2, 1650962923, 1);
INSERT INTO `cmf_user_video_view` VALUES (3, 20727, 3, 1650965463, 1);
INSERT INTO `cmf_user_video_view` VALUES (4, 20726, 7, 1651110607, 1);
INSERT INTO `cmf_user_video_view` VALUES (5, 20726, 6, 1650966223, 1);
INSERT INTO `cmf_user_video_view` VALUES (6, 20726, 5, 1650966225, 1);
INSERT INTO `cmf_user_video_view` VALUES (7, 20728, 1, 1651022300, 1);
INSERT INTO `cmf_user_video_view` VALUES (8, 20728, 6, 1651026057, 1);
INSERT INTO `cmf_user_video_view` VALUES (9, 20728, 7, 1651023070, 1);
COMMIT;

-- ----------------------------
-- Function structure for getDistance
-- ----------------------------
DROP FUNCTION IF EXISTS `getDistance`;
delimiter ;;
CREATE FUNCTION `getDistance`(lat1 FLOAT, lon1 FLOAT, lat2 FLOAT, lon2 FLOAT)
 RETURNS float
  DETERMINISTIC
BEGIN
    RETURN ROUND(6378.138 * 2 * ASIN(SQRT(POW(SIN((lat1 * PI() / 180 - lat2 * PI() / 180) / 2), 2)
           + COS(lat1 * PI() / 180) * COS(lat2 * PI() / 180)
           * POW(SIN(( lon1 * PI() / 180 - lon2 * PI() / 180 ) / 2),2))),2);
END
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;