代码拉取完成,页面将自动刷新
同步操作将从 小灰灰/huicmf_webman 强制同步,此操作会覆盖自 Fork 仓库以来所做的任何修改,且无法恢复!!!
确定后同步将在后台操作,完成时将刷新页面,请耐心等待。
/*
Navicat Premium Data Transfer
Source Server : 127.0.0.1
Source Server Type : MySQL
Source Server Version : 50728
Source Host : 127.0.0.1:3306
Source Schema : 1043webman_huicmf
Target Server Type : MySQL
Target Server Version : 50728
File Encoding : 65001
Date: 30/08/2022 11:10:31
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for casbin_rule
-- ----------------------------
DROP TABLE IF EXISTS `casbin_rule`;
CREATE TABLE `casbin_rule` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`ptype` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`v0` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '想要访问资源的用户',
`v1` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '将要被访问的资源',
`v2` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户对资源进行的操作',
`v3` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`v4` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`v5` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_ptype`(`ptype`) USING BTREE,
INDEX `idx_v0`(`v0`) USING BTREE,
INDEX `idx_v1`(`v1`) USING BTREE,
INDEX `idx_v2`(`v2`) USING BTREE,
INDEX `idx_v3`(`v3`) USING BTREE,
INDEX `idx_v4`(`v4`) USING BTREE,
INDEX `idx_v5`(`v5`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 136 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '策略规则表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of casbin_rule
-- ----------------------------
INSERT INTO `casbin_rule` VALUES (120, 'p', 'admin_role_2', '/admin/Auth', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (121, 'p', 'admin_role_2', '/admin/plugin', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (122, 'p', 'admin_role_2', '/admin/system/node', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (123, 'p', 'admin_role_2', '/admin/system/node/refresh_node', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (124, 'p', 'admin_role_2', '/admin/system/node/index', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (125, 'p', 'admin_role_2', '/admin/system/node/clear_node', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (126, 'p', 'admin_role_2', '/admin/system/admin', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (127, 'p', 'admin_role_2', '/admin/system/admin/index', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (128, 'p', 'admin_role_2', '/admin/system/admin/info', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (129, 'p', 'admin_role_2', '/admin/system/admin/status', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (130, 'p', 'admin_role_2', '/admin/system/admin/pass', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (131, 'p', 'admin_role_2', '/admin/plugin/index', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (132, 'p', 'admin_role_2', '/admin/plugin/index/index', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (133, 'p', 'admin_role_2', '/admin/plugin/index/install', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (134, 'p', 'admin_role_2', '/admin/plugin/index/config', 'GET', '', '', '');
INSERT INTO `casbin_rule` VALUES (135, 'p', 'admin_role_2', '/admin/plugin/index/enable', 'GET', '', '', '');
-- ----------------------------
-- Table structure for cmf_admin
-- ----------------------------
DROP TABLE IF EXISTS `cmf_admin`;
CREATE TABLE `cmf_admin` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户名',
`nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '昵称',
`password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码',
`salt` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码盐',
`role_id` int(10) NOT NULL DEFAULT 0 COMMENT '所属角色ID',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像',
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '电子邮箱',
`login_failure` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '失败次数',
`logintime` int(10) NOT NULL DEFAULT 0 COMMENT '登录时间',
`loginip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '登录IP',
`login_num` int(11) NOT NULL DEFAULT 0 COMMENT '登录成功次数',
`create_time` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',
`token` varchar(59) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'Session标识',
`status` int(1) NOT NULL DEFAULT 0 COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `username`(`username`) USING BTREE,
INDEX `email`(`email`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员表' ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of cmf_admin
-- ----------------------------
INSERT INTO `cmf_admin` VALUES (1, 'admin', '超管', '0b601795f26fb26694639292920ab4ac', 'abedf7', 1, '/uploads/images/20220630/90dff0cea3ab6549.gif', 'admin1@admin.com', 3, 1661737241, '127.0.0.1', 121, 1635759162, 1661737241, '7e5d05d14cf5f92235d74a29edf24ac4', 1);
INSERT INTO `cmf_admin` VALUES (2, 'test', '测试', '15cf418175103802b3bb4b3f8dac4373', 'AsxJoZ', 2, '/uploads/images/20220815/b051245195c6d8b7.png', 'test1@gmail.com', 0, 1661310147, '127.0.0.1', 0, 1652854413, 1661310147, 'a9b6b90074045ceca4d87adde8a475a5', 1);
-- ----------------------------
-- Table structure for cmf_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `cmf_auth_group`;
CREATE TABLE `cmf_auth_group` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '组名',
`rules` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '规则ID',
`create_time` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',
`status` int(1) NOT NULL DEFAULT 0 COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE,
INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分组表' ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of cmf_auth_group
-- ----------------------------
INSERT INTO `cmf_auth_group` VALUES (1, '超级管理员', '*', 1623383000, 1623383000, 1);
INSERT INTO `cmf_auth_group` VALUES (2, '管理员', '1,2,3,5,6,7,9,12,13,68,69,70,73,74', 1623383000, 1661323488, 1);
-- ----------------------------
-- Table structure for cmf_auth_menu
-- ----------------------------
DROP TABLE IF EXISTS `cmf_auth_menu`;
CREATE TABLE `cmf_auth_menu` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`pid` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父id',
`type` int(1) NOT NULL DEFAULT 1 COMMENT '节点类型(暂时无用)',
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '规则名称',
`icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单图标',
`node` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '链接',
`params` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '链接参数',
`sort` int(11) NOT NULL DEFAULT 100 COMMENT '菜单排序',
`is_menu` int(1) NOT NULL DEFAULT 1 COMMENT '是否后台菜单(1=后台菜单,0=权限菜单)',
`open_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '打开方式',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态(0:禁用,1:启用)',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`create_time` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',
`delete_time` int(10) NOT NULL DEFAULT 0 COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `title`(`title`) USING BTREE,
INDEX `href`(`node`) USING BTREE,
INDEX `node`(`node`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统菜单表' ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of cmf_auth_menu
-- ----------------------------
INSERT INTO `cmf_auth_menu` VALUES (1, 0, 0, '系统管理', 'layui-icon-set', '/admin/Auth', '', 0, 1, '', 1, '', 1650867269, 1660290001, 0);
INSERT INTO `cmf_auth_menu` VALUES (2, 1, 1, '管理员管理', 'layui-icon-username', '/admin/system/admin', '', 90, 1, '', 1, '', 1650867356, 1660699290, 0);
INSERT INTO `cmf_auth_menu` VALUES (3, 1, 1, '角色组管理', 'layui-icon-group', '/admin/system/authgroup', '', 90, 1, '', 1, '', 1651113028, 1655691868, 0);
INSERT INTO `cmf_auth_menu` VALUES (4, 1, 1, '后台菜单管理', 'layui-icon-menu-fill', '/admin/system/authmenu', '', 90, 1, '', 1, '', 1651113028, 1655692571, 0);
INSERT INTO `cmf_auth_menu` VALUES (5, 2, 1, '管理员列表', 'layui-icon-username', '/admin/system/admin/index', '', 100, 1, '', 1, '', 1651113144, 1655691360, 0);
INSERT INTO `cmf_auth_menu` VALUES (6, 3, 1, '角色组列表', '', '/admin/system/authgroup/index', '', 100, 1, '', 1, '', 1651138568, 1651138568, 0);
INSERT INTO `cmf_auth_menu` VALUES (7, 4, 1, '后台菜单列表', '', '/admin/system/authmenu/index', '', 100, 1, '', 1, '', 1651140163, 1655692583, 0);
INSERT INTO `cmf_auth_menu` VALUES (8, 1, 1, '定时任务管理', 'layui-icon-time', '/admin/system/crontab', '', 100, 1, '', 1, '', 1653385178, 1655691884, 0);
INSERT INTO `cmf_auth_menu` VALUES (9, 1, 1, '数据库管理', 'layui-icon-component', '/admin/system/database', '', 100, 1, '', 1, '', 1655350029, 1655692737, 0);
INSERT INTO `cmf_auth_menu` VALUES (10, 9, 1, '数据库列表', '', '/admin/system/database/index', '', 100, 1, '', 1, '', 1655350106, 1655350145, 0);
INSERT INTO `cmf_auth_menu` VALUES (11, 8, 1, '定时任务列表', '', '/admin/system/crontab/index', '', 100, 1, '', 1, '', 1655691910, 1655691910, 0);
INSERT INTO `cmf_auth_menu` VALUES (12, 1, 1, '权限节点管理', 'layui-icon-auz', '/admin/system/node', '', 91, 1, '', 1, '', 1655692679, 1655692679, 0);
INSERT INTO `cmf_auth_menu` VALUES (13, 12, 1, '权限节点列表', '', '/admin/system/node/index', '', 100, 1, '', 1, '', 1655692697, 1655692697, 0);
INSERT INTO `cmf_auth_menu` VALUES (14, 1, 1, '系统设置', 'layui-icon-set-fill', '/admin/system/config', '', 97, 1, '', 1, '', 1655954183, 1655954183, 0);
INSERT INTO `cmf_auth_menu` VALUES (15, 14, 1, '系统设置', 'layui-icon-set-sm', '/admin/system/config/index', '', 100, 1, '', 1, '', 1655954230, 1655954230, 0);
INSERT INTO `cmf_auth_menu` VALUES (16, 1, 1, '自定义设置', 'layui-icon-set', '/admin/system/config/custom_config', '', 97, 1, '', 1, '', 1655955168, 1655955243, 0);
INSERT INTO `cmf_auth_menu` VALUES (17, 20, 1, '上传测试页', 'layui-icon-upload-drag', '/admin/dev/formbuild/upload_test', '', 100, 1, '', 1, '', 1656319409, 1672105909, 0);
INSERT INTO `cmf_auth_menu` VALUES (18, 0, 0, '应用管理', 'layui-icon-app', '/admin/plugin', '', 100, 1, '', 1, '', 1661237152, 1661237152, 0);
INSERT INTO `cmf_auth_menu` VALUES (19, 18, 1, '应用列表', 'layui-icon-app', '/admin/plugin/index', '', 100, 1, '', 1, '', 1661237263, 1661237263, 0);
INSERT INTO `cmf_auth_menu` VALUES (20, 0, 0, '开发辅助', 'layui-icon-fonts-code', '/admin/dev', '', 100, 1, '', 1, '', 1672103169, 1672103169, 0);
INSERT INTO `cmf_auth_menu` VALUES (21, 20, 1, '表单构建页', 'layui-icon-fonts-html', '/admin/dev/formbuild/form_build', '', 100, 1, '', 1, '', 1672103216, 1672106632, 0);
-- ----------------------------
-- 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,
`type` tinyint(1) NOT NULL DEFAULT 3 COMMENT '节点类型(1:控制器,2:节点)',
`node` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '规则名称',
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '规则名称',
`is_auth` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否启动RBAC权限控制',
`condition` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '条件',
`create_time` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name`(`node`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 82 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '节点表' ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of cmf_auth_rule
-- ----------------------------
INSERT INTO `cmf_auth_rule` VALUES (1, 1, '/admin/system/node', '系统节点管理', 1, '', 1655446092, 1655446092);
INSERT INTO `cmf_auth_rule` VALUES (2, 2, '/admin/system/node/refresh_node', '系统节点更新', 1, '', 1655446092, 1655446092);
INSERT INTO `cmf_auth_rule` VALUES (3, 2, '/admin/system/node/index', '节点列表', 1, '', 1655446390, 1655446390);
INSERT INTO `cmf_auth_rule` VALUES (5, 2, '/admin/system/node/clear_node', '清除失效节点', 1, '', 1655446411, 1655446411);
INSERT INTO `cmf_auth_rule` VALUES (6, 1, '/admin/system/admin', '管理员管理', 1, '', 1655448869, 1655448869);
INSERT INTO `cmf_auth_rule` VALUES (7, 2, '/admin/system/admin/index', '管理员列表', 1, '', 1655448869, 1655448869);
INSERT INTO `cmf_auth_rule` VALUES (8, 2, '/admin/system/admin/add', '添加管理员', 1, '', 1655448869, 1655448869);
INSERT INTO `cmf_auth_rule` VALUES (9, 2, '/admin/system/admin/info', '获取管理员信息', 1, '', 1655448869, 1655448869);
INSERT INTO `cmf_auth_rule` VALUES (10, 2, '/admin/system/admin/edit', '更新管理员', 1, '', 1655448869, 1655448869);
INSERT INTO `cmf_auth_rule` VALUES (11, 2, '/admin/system/admin/delete', '删除管理员', 1, '', 1655448869, 1655448869);
INSERT INTO `cmf_auth_rule` VALUES (12, 2, '/admin/system/admin/status', '更改状态', 1, '', 1655448869, 1655448869);
INSERT INTO `cmf_auth_rule` VALUES (13, 2, '/admin/system/admin/pass', '修改密码', 1, '', 1655448869, 1655448869);
INSERT INTO `cmf_auth_rule` VALUES (14, 1, '/admin/system/authmenu', '后台菜单管理', 1, '', 1655452308, 1655452308);
INSERT INTO `cmf_auth_rule` VALUES (15, 2, '/admin/system/authmenu/index', '菜单列表', 1, '', 1655452308, 1655452308);
INSERT INTO `cmf_auth_rule` VALUES (16, 2, '/admin/system/authmenu/add', '添加菜单', 1, '', 1655452308, 1655452308);
INSERT INTO `cmf_auth_rule` VALUES (17, 2, '/admin/system/authmenu/edit', '编辑菜单', 1, '', 1655452308, 1655452308);
INSERT INTO `cmf_auth_rule` VALUES (18, 2, '/admin/system/authmenu/delete', '删除菜单', 1, '', 1655452308, 1655452308);
INSERT INTO `cmf_auth_rule` VALUES (19, 2, '/admin/system/authmenu/modify', '属性修改', 1, '', 1655452308, 1655452308);
INSERT INTO `cmf_auth_rule` VALUES (20, 1, '/admin/system/authgroup', '角色组管理', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (21, 2, '/admin/system/authgroup/index', '角色组列表', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (22, 2, '/admin/system/authgroup/add', '添加角色组', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (23, 2, '/admin/system/authgroup/info', '获取角色组信息', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (24, 2, '/admin/system/authgroup/edit', '编辑角色组', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (25, 2, '/admin/system/authgroup/delete', '删除角色组', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (26, 2, '/admin/system/authgroup/authorize', '授权节点输出', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (27, 1, '/admin/system/crontab', '定时任务管理', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (28, 2, '/admin/system/crontab/index', '任务列表', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (29, 2, '/admin/system/crontab/add', '添加任务', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (30, 2, '/admin/system/crontab/edit', '编辑任务', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (31, 2, '/admin/system/crontab/reload', '重启任务', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (32, 2, '/admin/system/crontab/delete', '删除任务', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (33, 2, '/admin/system/crontab/status', '更改状态', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (34, 2, '/admin/system/crontab/log_list', '日志列表', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (35, 1, '/admin/system/database', '数据库管理', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (36, 2, '/admin/system/database/index', '数据列表', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (37, 2, '/admin/system/database/backup', '数据备份', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (38, 2, '/admin/system/database/restore', '还原数据', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (39, 2, '/admin/system/database/databack_list', '备份列表', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (40, 2, '/admin/system/database/delete', '删除备份', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (41, 2, '/admin/system/database/download', '下载备份', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (42, 2, '/admin/system/database/optimize', '优化表', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (43, 2, '/admin/system/database/repair', '修复表', 1, '', 1655693454, 1655693454);
INSERT INTO `cmf_auth_rule` VALUES (46, 1, '/admin/system/uplibrary', '文件库管理', 1, '', 1655953075, 1655953075);
INSERT INTO `cmf_auth_rule` VALUES (47, 2, '/admin/system/uplibrary/file_list', '文件库列表', 1, '', 1655953075, 1655953075);
INSERT INTO `cmf_auth_rule` VALUES (48, 2, '/admin/system/uplibrary/group_list', '分组列表', 1, '', 1655953075, 1655953075);
INSERT INTO `cmf_auth_rule` VALUES (49, 2, '/admin/system/uplibrary/add_group', '新增分组', 1, '', 1655953075, 1655953075);
INSERT INTO `cmf_auth_rule` VALUES (50, 2, '/admin/system/uplibrary/edit_group', '编辑分组', 1, '', 1655953075, 1655953075);
INSERT INTO `cmf_auth_rule` VALUES (51, 2, '/admin/system/uplibrary/delete_group', '删除分组', 1, '', 1655953075, 1655953075);
INSERT INTO `cmf_auth_rule` VALUES (52, 2, '/admin/system/uplibrary/delete_files', '删除文件', 1, '', 1655953075, 1655953075);
INSERT INTO `cmf_auth_rule` VALUES (54, 1, '/admin/system/config', '系统设置', 1, '', 1655966282, 1655966282);
INSERT INTO `cmf_auth_rule` VALUES (55, 2, '/admin/system/config/index', '系统设置', 1, '', 1655966282, 1655966282);
INSERT INTO `cmf_auth_rule` VALUES (56, 2, '/admin/system/config/save', '保存设置', 1, '', 1655966282, 1655966282);
INSERT INTO `cmf_auth_rule` VALUES (57, 2, '/admin/system/config/custom_config', '自定义配置', 1, '', 1655966282, 1655966282);
INSERT INTO `cmf_auth_rule` VALUES (58, 2, '/admin/system/config/custom_config_add', '添加自定义配置', 1, '', 1655966282, 1655966282);
INSERT INTO `cmf_auth_rule` VALUES (59, 2, '/admin/system/config/custom_config_edit', '修改自定义配置', 1, '', 1655966282, 1655966282);
INSERT INTO `cmf_auth_rule` VALUES (60, 2, '/admin/system/config/custom_config_delete', '删除自定义配置', 1, '', 1655966282, 1655966282);
INSERT INTO `cmf_auth_rule` VALUES (61, 2, '/admin/system/uplibrary/move_files', '批量移动文件分组', 1, '', 1657765032, 1657765032);
INSERT INTO `cmf_auth_rule` VALUES (68, 1, '/admin/plugin/index', '插件管理', 1, '', 1661310194, 1661310194);
INSERT INTO `cmf_auth_rule` VALUES (69, 2, '/admin/plugin/index/index', '插件列表', 1, '', 1661310194, 1661310194);
INSERT INTO `cmf_auth_rule` VALUES (70, 2, '/admin/plugin/index/install', '安装插件', 1, '', 1661310194, 1661310194);
INSERT INTO `cmf_auth_rule` VALUES (71, 2, '/admin/plugin/index/uninstall', '卸载插件', 1, '', 1661310194, 1661310194);
INSERT INTO `cmf_auth_rule` VALUES (72, 2, '/admin/plugin/index/delete', '删除插件', 1, '', 1661310194, 1661310194);
INSERT INTO `cmf_auth_rule` VALUES (73, 2, '/admin/plugin/index/config', '插件设置', 1, '', 1661310194, 1661310194);
INSERT INTO `cmf_auth_rule` VALUES (74, 2, '/admin/plugin/index/enable', '修改状态', 1, '', 1661310194, 1661310194);
INSERT INTO `cmf_auth_rule` VALUES (75, 2, '/admin/system/database/table_edit', '编辑表', 1, '', 1672039672, 1672039672);
INSERT INTO `cmf_auth_rule` VALUES (76, 2, '/admin/system/database/modify', '修改表操作', 1, '', 1672039672, 1672039672);
INSERT INTO `cmf_auth_rule` VALUES (77, 2, '/admin/system/database/table_crud', '一键CURD', 1, '', 1672039672, 1672039672);
INSERT INTO `cmf_auth_rule` VALUES (78, 2, '/admin/plugin/index/add', '创建插件', 1, '', 1672039672, 1672039672);
INSERT INTO `cmf_auth_rule` VALUES (79, 1, '/admin/dev/formbuild', '开发管理', 1, '', 1672106672, 1672106672);
INSERT INTO `cmf_auth_rule` VALUES (80, 2, '/admin/dev/formbuild/upload_test', '上传测试', 1, '', 1672106672, 1672106672);
INSERT INTO `cmf_auth_rule` VALUES (81, 2, '/admin/dev/formbuild/form_build', '表单构建', 1, '', 1672106672, 1672106672);
-- ----------------------------
-- Table structure for cmf_config
-- ----------------------------
DROP TABLE IF EXISTS `cmf_config`;
CREATE TABLE `cmf_config` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '配置名称',
`type` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '配置类型',
`title` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '配置说明',
`value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '配置值',
`fieldtype` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '字段类型',
`setting` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '字段设置',
`status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态',
`tips` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name`(`name`) USING BTREE,
INDEX `type`(`type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统配置' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of cmf_config
-- ----------------------------
INSERT INTO `cmf_config` VALUES (1, 'site_name', 1, '站点名称', 'HuiCMF-webman后台权限管理系统', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (2, 'site_url', 1, '站点跟网址', 'http://127.0.0.1:8787', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (3, 'admin_log', 3, '启用后台管理操作日志', '0', 'radio', '', 1, '');
INSERT INTO `cmf_config` VALUES (4, 'site_keyword', 1, '站点关键字', 'huicmf', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (5, 'site_copyright', 1, '网站版权信息', 'Powered By HuiCMF6后台系统 © 2019-2021 小灰灰工作室', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (6, 'site_beian', 1, '站点备案号', '豫ICP备666666号', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (7, 'site_description', 1, '站点描述', '我是描述', 'text', '', 1, '');
INSERT INTO `cmf_config` VALUES (8, 'site_code', 1, '统计代码', '', 'text', '', 1, '');
INSERT INTO `cmf_config` VALUES (9, 'admin_prohibit_ip', 3, '禁止访问网站的IP', '', 'text', '', 1, '');
INSERT INTO `cmf_config` VALUES (10, 'mail_server', 4, 'SMTP服务器', 'smtp.exmail.qq.com', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (11, 'mail_port', 4, 'SMTP服务器端口', '465', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (12, 'mail_user', 4, 'SMTP服务器的用户帐号', '', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (13, 'mail_pass', 4, 'SMTP服务器的用户密码', '', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (14, 'mail_inbox', 4, '收件邮箱地址', '', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (15, 'login_captcha', 2, '后台登录验证码', '1', 'string', NULL, 1, '');
INSERT INTO `cmf_config` VALUES (16, 'watermark_enable', 2, '是否开启图片水印', '0', 'radio', '', 1, '');
INSERT INTO `cmf_config` VALUES (17, 'watermark_name', 2, '水印图片名称', 'mark.png', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (18, 'watermark_position', 2, '水印的位置', '9', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (19, 'watermark_touming', 2, '水印透明度', '85', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (20, 'upload_types_image', 2, '允许上传图片类型', 'jpg,jpeg,png,gif,bmp', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (21, 'upload_mode', 2, '图片上传方式', 'local', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (22, 'site_editor', 1, '文本编辑器', 'uEditorPlus', 'string', ' ', 1, '');
INSERT INTO `cmf_config` VALUES (23, 'upload_types_file', 2, '允许上传附件类型', 'zip,pdf,doc,txt,json', 'string', ' ', 1, '');
INSERT INTO `cmf_config` VALUES (24, 'admin_url_password', 3, '后台加密码', 'admin', 'string', ' ', 1, ' ');
INSERT INTO `cmf_config` VALUES (25, 'dingxiang_appid', 2, '顶象验证appid', '', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (26, 'dingxiang_appSecret', 2, '顶象验证appSecret', '', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (27, 'dingxiang_apiurl', 2, '顶象验证-api地址', 'https://api-pro.dingxiang-inc.com', 'string', '', 1, '');
INSERT INTO `cmf_config` VALUES (28, 'ueditor_icon', 5, 'ueditor图标显示', 'fullscreen,source,undo,redo,bold,italic,underline,fontborder,strikethrough,superscript,subscript,removeformat,formatmatch,autotypeset,blockquote,pasteplain,forecolor,backcolor,insertorderedlist,insertunorderedlist,selectall,cleardoc,rowspacingtop,rowspacingbottom,lineheight,customstyle,paragraph,fontfamily,fontsize,directionalityltr,directionalityrtl,indent,justifyleft,justifycenter,justifyright,justifyjustify,touppercase,tolowercase,link,unlink,anchor,imagenone,imageleft,imageright,imagecenter,simpleupload,insertimage,emotion,scrawl,insertvideo,attachment,insertframe,insertcode,pagebreak,template,background,horizontal,date,time,spechars,wordimage,inserttable,deletetable,insertparagraphbeforetable,insertrow,deleterow,insertcol,deletecol,mergecells,mergeright,mergedown,splittocells,splittorows,splittocols,preview,searchreplace,help', 'text', NULL, 1, '');
INSERT INTO `cmf_config` VALUES (29, 'pic_more_nums', 2, '多图上传图片数量限制', '0', 'string', NULL, 1, '');
-- ----------------------------
-- Table structure for cmf_login_log
-- ----------------------------
DROP TABLE IF EXISTS `cmf_login_log`;
CREATE TABLE `cmf_login_log` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户id',
`user_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户名',
`ip_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'ip地址',
`country` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '国家',
`area` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省',
`city` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '市',
`isp` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '网络:【电信、联通】',
`status` int(1) NOT NULL DEFAULT '0' COMMENT '登录状态:1=成功;0=失败',
`desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`create_time` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `user`(`user_id`) USING BTREE,
INDEX `ip_address`(`ip_address`) USING BTREE,
INDEX `country`(`country`) USING BTREE,
INDEX `area`(`area`) USING BTREE,
INDEX `city`(`city`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '后台登录记录表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of cmf_login_log
-- ----------------------------
-- ----------------------------
-- Table structure for cmf_message
-- ----------------------------
DROP TABLE IF EXISTS `cmf_message`;
CREATE TABLE `cmf_message` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '类型:0=默认;1=通知(message);2=消息(notice)',
`text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`admin_id` int(10) NOT NULL DEFAULT 0 COMMENT '0=系统发送',
`is_read` tinyint(1) NOT NULL DEFAULT 0,
`create_time` int(10) NOT NULL DEFAULT 0,
`update_time` int(10) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE,
INDEX `is_read`(`is_read`, `type`) USING BTREE,
INDEX `text`(`text`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '站内消息' ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
-- ----------------------------
-- Table structure for cmf_options
-- ----------------------------
DROP TABLE IF EXISTS `cmf_options`;
CREATE TABLE `cmf_options` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '键',
`value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '值',
`create_time` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '选项表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of cmf_options
-- ----------------------------
INSERT INTO `cmf_options` VALUES (1, 'table_form_schema_casbin_rule', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"ptype\":{\"field\":\"ptype\",\"_field_id\":\"1\",\"comment\":\"\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"v0\":{\"field\":\"v0\",\"_field_id\":\"2\",\"comment\":\"想要访问资源的用户\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"v1\":{\"field\":\"v1\",\"_field_id\":\"3\",\"comment\":\"将要被访问的资源\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"v2\":{\"field\":\"v2\",\"_field_id\":\"4\",\"comment\":\"用户对资源进行的操作\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"v3\":{\"field\":\"v3\",\"_field_id\":\"5\",\"comment\":\"\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"v4\":{\"field\":\"v4\",\"_field_id\":\"6\",\"comment\":\"\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"v5\":{\"field\":\"v5\",\"_field_id\":\"7\",\"comment\":\"\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672038849, 1672038849);
INSERT INTO `cmf_options` VALUES (2, 'table_form_schema_cmf_admin', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"ID\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"username\":{\"field\":\"username\",\"_field_id\":\"1\",\"comment\":\"用户名\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"nickname\":{\"field\":\"nickname\",\"_field_id\":\"2\",\"comment\":\"昵称\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"password\":{\"field\":\"password\",\"_field_id\":\"3\",\"comment\":\"密码\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"salt\":{\"field\":\"salt\",\"_field_id\":\"4\",\"comment\":\"密码盐\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"role_id\":{\"field\":\"role_id\",\"_field_id\":\"5\",\"comment\":\"所属角色ID\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"avatar\":{\"field\":\"avatar\",\"_field_id\":\"6\",\"comment\":\"头像\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"email\":{\"field\":\"email\",\"_field_id\":\"7\",\"comment\":\"电子邮箱\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"login_failure\":{\"field\":\"login_failure\",\"_field_id\":\"8\",\"comment\":\"失败次数\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"logintime\":{\"field\":\"logintime\",\"_field_id\":\"9\",\"comment\":\"登录时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"loginip\":{\"field\":\"loginip\",\"_field_id\":\"10\",\"comment\":\"登录IP\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"login_num\":{\"field\":\"login_num\",\"_field_id\":\"11\",\"comment\":\"登录成功次数\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"12\",\"comment\":\"创建时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"update_time\":{\"field\":\"update_time\",\"_field_id\":\"13\",\"comment\":\"更新时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"token\":{\"field\":\"token\",\"_field_id\":\"14\",\"comment\":\"Session标识\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"status\":{\"field\":\"status\",\"_field_id\":\"15\",\"comment\":\"状态\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672038858, 1672038858);
INSERT INTO `cmf_options` VALUES (3, 'table_form_schema_cmf_auth_group', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"name\":{\"field\":\"name\",\"_field_id\":\"1\",\"comment\":\"组名\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"rules\":{\"field\":\"rules\",\"_field_id\":\"2\",\"comment\":\"规则ID\",\"control\":\"textArea\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"3\",\"comment\":\"创建时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"update_time\":{\"field\":\"update_time\",\"_field_id\":\"4\",\"comment\":\"更新时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"status\":{\"field\":\"status\",\"_field_id\":\"5\",\"comment\":\"状态\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672038864, 1672038864);
INSERT INTO `cmf_options` VALUES (4, 'table_form_schema_cmf_auth_menu', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"pid\":{\"field\":\"pid\",\"_field_id\":\"1\",\"comment\":\"父id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"type\":{\"field\":\"type\",\"_field_id\":\"2\",\"comment\":\"节点类型(暂时无用)\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"title\":{\"field\":\"title\",\"_field_id\":\"3\",\"comment\":\"规则名称\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"icon\":{\"field\":\"icon\",\"_field_id\":\"4\",\"comment\":\"菜单图标\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"node\":{\"field\":\"node\",\"_field_id\":\"5\",\"comment\":\"链接\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"params\":{\"field\":\"params\",\"_field_id\":\"6\",\"comment\":\"链接参数\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"sort\":{\"field\":\"sort\",\"_field_id\":\"7\",\"comment\":\"菜单排序\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"is_menu\":{\"field\":\"is_menu\",\"_field_id\":\"8\",\"comment\":\"是否后台菜单(1=后台菜单,0=权限菜单)\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"open_type\":{\"field\":\"open_type\",\"_field_id\":\"9\",\"comment\":\"打开方式\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"status\":{\"field\":\"status\",\"_field_id\":\"10\",\"comment\":\"状态(0:禁用,1:启用)\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"remark\":{\"field\":\"remark\",\"_field_id\":\"11\",\"comment\":\"\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"12\",\"comment\":\"创建时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"update_time\":{\"field\":\"update_time\",\"_field_id\":\"13\",\"comment\":\"更新时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"delete_time\":{\"field\":\"delete_time\",\"_field_id\":\"14\",\"comment\":\"删除时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672038871, 1672038871);
INSERT INTO `cmf_options` VALUES (5, 'table_form_schema_cmf_auth_rule', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"type\":{\"field\":\"type\",\"_field_id\":\"1\",\"comment\":\"节点类型(1:控制器,2:节点)\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"node\":{\"field\":\"node\",\"_field_id\":\"2\",\"comment\":\"规则名称\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"title\":{\"field\":\"title\",\"_field_id\":\"3\",\"comment\":\"规则名称\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"is_auth\":{\"field\":\"is_auth\",\"_field_id\":\"4\",\"comment\":\"是否启动RBAC权限控制\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"condition\":{\"field\":\"condition\",\"_field_id\":\"5\",\"comment\":\"条件\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"6\",\"comment\":\"创建时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"update_time\":{\"field\":\"update_time\",\"_field_id\":\"7\",\"comment\":\"更新时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672038875, 1672038875);
INSERT INTO `cmf_options` VALUES (6, 'table_form_schema_cmf_config', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"name\":{\"field\":\"name\",\"_field_id\":\"1\",\"comment\":\"配置名称\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"type\":{\"field\":\"type\",\"_field_id\":\"2\",\"comment\":\"配置类型\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"title\":{\"field\":\"title\",\"_field_id\":\"3\",\"comment\":\"配置说明\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"value\":{\"field\":\"value\",\"_field_id\":\"4\",\"comment\":\"配置值\",\"control\":\"textArea\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"fieldtype\":{\"field\":\"fieldtype\",\"_field_id\":\"5\",\"comment\":\"字段类型\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"setting\":{\"field\":\"setting\",\"_field_id\":\"6\",\"comment\":\"字段设置\",\"control\":\"textArea\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"status\":{\"field\":\"status\",\"_field_id\":\"7\",\"comment\":\"状态\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"tips\":{\"field\":\"tips\",\"_field_id\":\"8\",\"comment\":\"\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672038879, 1672038879);
INSERT INTO `cmf_options` VALUES (7, 'table_form_schema_cmf_login_log', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"user_id\":{\"field\":\"user_id\",\"_field_id\":\"1\",\"comment\":\"用户id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"user_name\":{\"field\":\"user_name\",\"_field_id\":\"2\",\"comment\":\"用户名\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"ip_address\":{\"field\":\"ip_address\",\"_field_id\":\"3\",\"comment\":\"ip地址\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"country\":{\"field\":\"country\",\"_field_id\":\"4\",\"comment\":\"国家\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"area\":{\"field\":\"area\",\"_field_id\":\"5\",\"comment\":\"省\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"city\":{\"field\":\"city\",\"_field_id\":\"6\",\"comment\":\"市\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"isp\":{\"field\":\"isp\",\"_field_id\":\"7\",\"comment\":\"网络:【电信、联通】\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"status\":{\"field\":\"status\",\"_field_id\":\"8\",\"comment\":\"登录状态:1=成功;0=失败\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"desc\":{\"field\":\"desc\",\"_field_id\":\"9\",\"comment\":\"\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"10\",\"comment\":\"创建时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"update_time\":{\"field\":\"update_time\",\"_field_id\":\"11\",\"comment\":\"更新时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672038884, 1672038884);
INSERT INTO `cmf_options` VALUES (8, 'table_form_schema_cmf_message', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"type\":{\"field\":\"type\",\"_field_id\":\"1\",\"comment\":\"类型:0=默认;1=通知(message);2=消息(notice)\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"text\":{\"field\":\"text\",\"_field_id\":\"2\",\"comment\":\"\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"admin_id\":{\"field\":\"admin_id\",\"_field_id\":\"3\",\"comment\":\"0=系统发送\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"is_read\":{\"field\":\"is_read\",\"_field_id\":\"4\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"5\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"update_time\":{\"field\":\"update_time\",\"_field_id\":\"6\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672038893, 1672038893);
INSERT INTO `cmf_options` VALUES (9, 'table_form_schema_cmf_options', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"name\":{\"field\":\"name\",\"_field_id\":\"1\",\"comment\":\"键\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"value\":{\"field\":\"value\",\"_field_id\":\"2\",\"comment\":\"值\",\"control\":\"textArea\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"3\",\"comment\":\"创建时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"update_time\":{\"field\":\"update_time\",\"_field_id\":\"4\",\"comment\":\"更新时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672038897, 1672038897);
INSERT INTO `cmf_options` VALUES (10, 'table_form_schema_cmf_system_log', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"ID\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"admin_id\":{\"field\":\"admin_id\",\"_field_id\":\"1\",\"comment\":\"管理员ID\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"url\":{\"field\":\"url\",\"_field_id\":\"2\",\"comment\":\"操作页面\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"method\":{\"field\":\"method\",\"_field_id\":\"3\",\"comment\":\"请求方法\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"title\":{\"field\":\"title\",\"_field_id\":\"4\",\"comment\":\"日志标题\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"content\":{\"field\":\"content\",\"_field_id\":\"5\",\"comment\":\"内容\",\"control\":\"textArea\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"ip\":{\"field\":\"ip\",\"_field_id\":\"6\",\"comment\":\"IP\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"7\",\"comment\":\"操作时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672038905, 1672038905);
INSERT INTO `cmf_options` VALUES (11, 'table_form_schema_cmf_upload_file', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"文件id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"storage\":{\"field\":\"storage\",\"_field_id\":\"1\",\"comment\":\"存储方式\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"group_id\":{\"field\":\"group_id\",\"_field_id\":\"2\",\"comment\":\"文件分组id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"file_url\":{\"field\":\"file_url\",\"_field_id\":\"3\",\"comment\":\"存储域名\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"file_name\":{\"field\":\"file_name\",\"_field_id\":\"4\",\"comment\":\"文件路径\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"file_size\":{\"field\":\"file_size\",\"_field_id\":\"5\",\"comment\":\"文件大小(字节)\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"file_type\":{\"field\":\"file_type\",\"_field_id\":\"6\",\"comment\":\"文件类型\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"extension\":{\"field\":\"extension\",\"_field_id\":\"7\",\"comment\":\"文件扩展名\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"is_delete\":{\"field\":\"is_delete\",\"_field_id\":\"8\",\"comment\":\"软删除\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"9\",\"comment\":\"创建时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672038912, 1672038912);
INSERT INTO `cmf_options` VALUES (12, 'table_form_schema_cmf_upload_group', '{\"group_id\":{\"field\":\"group_id\",\"_field_id\":\"0\",\"comment\":\"分类id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"group_type\":{\"field\":\"group_type\",\"_field_id\":\"1\",\"comment\":\"文件类型\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"group_name\":{\"field\":\"group_name\",\"_field_id\":\"2\",\"comment\":\"分类名称\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"sort\":{\"field\":\"sort\",\"_field_id\":\"3\",\"comment\":\"分类排序(数字越小越靠前)\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"wxapp_id\":{\"field\":\"wxapp_id\",\"_field_id\":\"4\",\"comment\":\"小程序id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"5\",\"comment\":\"创建时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"update_time\":{\"field\":\"update_time\",\"_field_id\":\"6\",\"comment\":\"更新时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672038917, 1672038917);
INSERT INTO `cmf_options` VALUES (13, 'table_form_schema_cmf_user', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"用户ID\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"username\":{\"field\":\"username\",\"_field_id\":\"1\",\"comment\":\"用户名\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"password\":{\"field\":\"password\",\"_field_id\":\"2\",\"comment\":\"密码\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"salt\":{\"field\":\"salt\",\"_field_id\":\"3\",\"comment\":\"密码盐\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"mobile\":{\"field\":\"mobile\",\"_field_id\":\"4\",\"comment\":\"手机号\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"sex\":{\"field\":\"sex\",\"_field_id\":\"5\",\"comment\":\"1=男 2=女 3=未知\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"birthday\":{\"field\":\"birthday\",\"_field_id\":\"6\",\"comment\":\"生日\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"avatar\":{\"field\":\"avatar\",\"_field_id\":\"7\",\"comment\":\"头像\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"nickname\":{\"field\":\"nickname\",\"_field_id\":\"8\",\"comment\":\"昵称\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"status\":{\"field\":\"status\",\"_field_id\":\"9\",\"comment\":\"1 = 正常 0 = 停用\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"remarks\":{\"field\":\"remarks\",\"_field_id\":\"10\",\"comment\":\"备注\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"11\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"update_time\":{\"field\":\"update_time\",\"_field_id\":\"12\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"delete_time\":{\"field\":\"delete_time\",\"_field_id\":\"13\",\"comment\":\"删除标志 有数据就是删除\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672038922, 1672038922);
INSERT INTO `cmf_options` VALUES (14, 'table_form_schema_cmf_user_log', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"user_id\":{\"field\":\"user_id\",\"_field_id\":\"1\",\"comment\":\"用户id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"state\":{\"field\":\"state\",\"_field_id\":\"2\",\"comment\":\"1=登录, 2=退出,3=注册\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"params\":{\"field\":\"params\",\"_field_id\":\"3\",\"comment\":\"参数\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"ip\":{\"field\":\"ip\",\"_field_id\":\"4\",\"comment\":\"ip地址\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"type\":{\"field\":\"type\",\"_field_id\":\"5\",\"comment\":\"类型,1会员,2管理员\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"6\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"update_time\":{\"field\":\"update_time\",\"_field_id\":\"7\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"delete_time\":{\"field\":\"delete_time\",\"_field_id\":\"8\",\"comment\":\"删除标志 有数据就是删除\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672038931, 1672038931);
INSERT INTO `cmf_options` VALUES (15, 'table_form_schema_system_crontab', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"title\":{\"field\":\"title\",\"_field_id\":\"1\",\"comment\":\"任务标题\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"type\":{\"field\":\"type\",\"_field_id\":\"2\",\"comment\":\"任务类型 (1 command, 2 class, 3 url, 4 eval)\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"rule\":{\"field\":\"rule\",\"_field_id\":\"3\",\"comment\":\"任务执行表达式\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"rule_params\":{\"field\":\"rule_params\",\"_field_id\":\"4\",\"comment\":\"任务执行表达式的字段\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"target\":{\"field\":\"target\",\"_field_id\":\"5\",\"comment\":\"调用任务字符串\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"running_times\":{\"field\":\"running_times\",\"_field_id\":\"6\",\"comment\":\"已运行次数\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"last_running_time\":{\"field\":\"last_running_time\",\"_field_id\":\"7\",\"comment\":\"上次运行时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"remark\":{\"field\":\"remark\",\"_field_id\":\"8\",\"comment\":\"备注\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"sort\":{\"field\":\"sort\",\"_field_id\":\"9\",\"comment\":\"排序,越大越前\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"status\":{\"field\":\"status\",\"_field_id\":\"10\",\"comment\":\"任务状态状态[0:禁用;1启用]\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"11\",\"comment\":\"创建时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"update_time\":{\"field\":\"update_time\",\"_field_id\":\"12\",\"comment\":\"更新时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"singleton\":{\"field\":\"singleton\",\"_field_id\":\"13\",\"comment\":\"是否单次执行 (0 是 1 不是)\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"parameter\":{\"field\":\"parameter\",\"_field_id\":\"14\",\"comment\":\"任务调用参数\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672039018, 1672039018);
INSERT INTO `cmf_options` VALUES (16, 'table_form_schema_system_crontab_log', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"crontab_id\":{\"field\":\"crontab_id\",\"_field_id\":\"1\",\"comment\":\"任务id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"target\":{\"field\":\"target\",\"_field_id\":\"2\",\"comment\":\"任务调用目标字符串\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"parameter\":{\"field\":\"parameter\",\"_field_id\":\"3\",\"comment\":\"任务调用参数\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"exception\":{\"field\":\"exception\",\"_field_id\":\"4\",\"comment\":\"异常信息输出\",\"control\":\"textArea\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"return_code\":{\"field\":\"return_code\",\"_field_id\":\"5\",\"comment\":\"执行返回状态[0成功; 1失败]\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"running_time\":{\"field\":\"running_time\",\"_field_id\":\"6\",\"comment\":\"执行所用时间\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"7\",\"comment\":\"创建时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"update_time\":{\"field\":\"update_time\",\"_field_id\":\"8\",\"comment\":\"更新时间\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672039031, 1672039031);
INSERT INTO `cmf_options` VALUES (17, 'table_form_schema_cmf_user_token', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"token\":{\"field\":\"token\",\"_field_id\":\"1\",\"comment\":\"\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"user_id\":{\"field\":\"user_id\",\"_field_id\":\"2\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"platform\":{\"field\":\"platform\",\"_field_id\":\"3\",\"comment\":\"平台类型,1就是默认,2就是微信小程序\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"create_time\":{\"field\":\"create_time\",\"_field_id\":\"4\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"update_time\":{\"field\":\"update_time\",\"_field_id\":\"5\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"delete_time\":{\"field\":\"delete_time\",\"_field_id\":\"6\",\"comment\":\"删除标志 有数据就是删除\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', 1672039496, 1672039496);
SET FOREIGN_KEY_CHECKS = 1;
-- ----------------------------
-- Table structure for cmf_system_log
-- ----------------------------
DROP TABLE IF EXISTS `cmf_system_log`;
CREATE TABLE `cmf_system_log` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`admin_id` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '管理员ID',
`url` varchar(1500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '操作页面',
`method` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求方法',
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '日志标题',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容',
`ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'IP',
`create_time` int(10) NOT NULL DEFAULT 0 COMMENT '操作时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '后台操作日志表' ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of cmf_system_log
-- ----------------------------
-- ----------------------------
-- Table structure for cmf_upload_file
-- ----------------------------
DROP TABLE IF EXISTS `cmf_upload_file`;
CREATE TABLE `cmf_upload_file` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文件id',
`storage` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '存储方式',
`group_id` int(11) NOT NULL DEFAULT 0 COMMENT '文件分组id',
`file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '存储域名',
`file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件路径',
`file_size` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文件大小(字节)',
`file_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件类型',
`extension` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件扩展名',
`is_delete` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '软删除',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of cmf_upload_file
-- ----------------------------
-- ----------------------------
-- Table structure for cmf_upload_group
-- ----------------------------
DROP TABLE IF EXISTS `cmf_upload_group`;
CREATE TABLE `cmf_upload_group` (
`group_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分类id',
`group_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件类型',
`group_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
`sort` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分类排序(数字越小越靠前)',
`wxapp_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '小程序id',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`group_id`) USING BTREE,
INDEX `type_index`(`group_type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of cmf_upload_group
-- ----------------------------
INSERT INTO `cmf_upload_group` VALUES (1, 'image', '分组1', 0, 0, 1657532935, 1657532935);
-- ----------------------------
-- Table structure for cmf_user
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user`;
CREATE TABLE `cmf_user` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户名',
`password` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码',
`salt` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码盐',
`mobile` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号',
`sex` tinyint(1) UNSIGNED NOT NULL DEFAULT 3 COMMENT '1=男 2=女 3=未知',
`birthday` int(10) NOT NULL DEFAULT 0 COMMENT '生日',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像',
`nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '昵称',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1 = 正常 0 = 停用',
`remarks` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0,
`update_time` int(10) UNSIGNED NOT NULL DEFAULT 0,
`delete_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除标志 有数据就是删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `mobile`(`mobile`) USING BTREE,
INDEX `status`(`status`) USING BTREE,
INDEX `username`(`username`) USING BTREE,
INDEX `sex`(`sex`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of cmf_user
-- ----------------------------
-- ----------------------------
-- Table structure for cmf_user_log
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_log`;
CREATE TABLE `cmf_user_log` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
`user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户id',
`state` tinyint(1) NOT NULL DEFAULT 0 COMMENT '登录 1 退出2,3注册',
`params` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '参数',
`ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'ip地址',
`type` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '类型,1会员,2管理员',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0,
`update_time` int(10) UNSIGNED NOT NULL DEFAULT 0,
`delete_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除标志 有数据就是删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `user_id`(`user_id`) USING BTREE,
INDEX `type`(`type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of cmf_user_log
-- ----------------------------
-- ----------------------------
-- Table structure for cmf_user_token
-- ----------------------------
DROP TABLE IF EXISTS `cmf_user_token`;
CREATE TABLE `cmf_user_token` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`token` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`platform` smallint(2) NOT NULL DEFAULT 1 COMMENT '平台类型,1就是默认,2就是微信小程序',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0,
`update_time` int(10) UNSIGNED NOT NULL DEFAULT 0,
`delete_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除标志 有数据就是删除',
PRIMARY KEY (`id`, `token`) USING BTREE,
INDEX `user_id`(`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户token' ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of cmf_user_token
-- ----------------------------
-- ----------------------------
-- Table structure for system_crontab
-- ----------------------------
DROP TABLE IF EXISTS `system_crontab`;
CREATE TABLE `system_crontab` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务标题',
`type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '任务类型 (1 command, 2 class, 3 url, 4 eval)',
`rule` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务执行表达式',
`rule_params` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务执行表达式的字段',
`target` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '调用任务字符串',
`running_times` int(11) NOT NULL DEFAULT 0 COMMENT '已运行次数',
`last_running_time` int(11) NOT NULL DEFAULT 0 COMMENT '上次运行时间',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序,越大越前',
`status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '任务状态状态[0:禁用;1启用]',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
`singleton` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否单次执行 (0 是 1 不是)',
`parameter` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务调用参数',
PRIMARY KEY (`id`) USING BTREE,
INDEX `title`(`title`) USING BTREE,
INDEX `create_time`(`create_time`) USING BTREE,
INDEX `status`(`status`) USING BTREE,
INDEX `type`(`type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定时器任务表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of system_crontab
-- ----------------------------
-- ----------------------------
-- Table structure for system_crontab_log
-- ----------------------------
DROP TABLE IF EXISTS `system_crontab_log`;
CREATE TABLE `system_crontab_log` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`crontab_id` bigint(20) UNSIGNED NOT NULL COMMENT '任务id',
`target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务调用目标字符串',
`parameter` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '任务调用参数',
`exception` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '异常信息输出',
`return_code` tinyint(1) NOT NULL DEFAULT 0 COMMENT '执行返回状态[0成功; 1失败]',
`running_time` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '执行所用时间',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `create_time`(`create_time`) USING BTREE,
INDEX `crontab_id`(`crontab_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定时器任务执行日志表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of system_crontab_log
-- ----------------------------
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。