登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 11 Fork 1

浪子花梦 / ruoyi-admin-template

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
克隆/下载
admin.sql 26.39 KB
一键复制 编辑 原始数据 按行查看 历史
浪子花梦 提交于 2023-03-11 11:04 . 1.admin-api目录结构修改 2.删除系统日志模块
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342
/*

 Navicat Premium Data Transfer



 Source Server         : localhost

 Source Server Type    : MySQL

 Source Server Version : 50527

 Source Host           : localhost:3306

 Source Schema         : admin



 Target Server Type    : MySQL

 Target Server Version : 50527

 File Encoding         : 65001



 Date: 11/03/2023 10:18:31

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for t_dict_data

-- ----------------------------

DROP TABLE IF EXISTS `t_dict_data`;

CREATE TABLE `t_dict_data`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',

  `dict_sort` int(4) NULL DEFAULT 0 COMMENT '字典排序',

  `dict_label` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典标签',

  `dict_value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典键值',

  `dict_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典类型',

  `css_class` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '样式属性（其他样式扩展）',

  `list_class` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表格回显样式',

  `is_default` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'N' COMMENT '是否默认',

  `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'Y' COMMENT '状态',

  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',

  `deleted` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N' COMMENT '是否删除',

  `create_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建人',

  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',

  `update_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新人',

  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典数据表' ROW_FORMAT = COMPACT;



-- ----------------------------

-- Records of t_dict_data

-- ----------------------------

INSERT INTO `t_dict_data` VALUES (1, 1, '正常', 'Y', 'sys_normal_disable', 'primary', 'default', 'Y', 'Y', '', 'N', 'admin', '2021-10-18 10:46:07', '', '2021-10-18 16:09:37');

INSERT INTO `t_dict_data` VALUES (2, 2, '停用', 'N', 'sys_normal_disable', 'danger', 'default', 'N', 'Y', NULL, 'N', 'admin', '2021-10-18 10:46:07', '', '2021-10-18 10:49:50');

INSERT INTO `t_dict_data` VALUES (3, 1, '显示', 'Y', 'sys_show_hide', 'primary', 'default', 'Y', 'Y', NULL, 'N', 'admin', '2021-10-18 10:46:07', '', NULL);

INSERT INTO `t_dict_data` VALUES (4, 2, '隐藏', 'N', 'sys_show_hide', 'danger', 'default', 'N', 'Y', NULL, 'N', 'admin', '2021-10-18 10:46:07', '', NULL);

INSERT INTO `t_dict_data` VALUES (5, 1, '正常', 'W', 'sys_job_status', NULL, 'default', 'N', 'Y', NULL, 'N', 'admin', '2022-09-29 13:57:22', 'admin', '2022-09-29 13:57:50');

INSERT INTO `t_dict_data` VALUES (6, 2, '停止', 'S', 'sys_job_status', NULL, 'default', 'N', 'Y', NULL, 'N', 'admin', '2022-09-29 13:57:31', 'admin', '2022-09-29 13:57:55');

INSERT INTO `t_dict_data` VALUES (11, 1, '正常', 'FINE', 'sys_log_type', NULL, 'default', 'N', 'Y', NULL, 'N', 'admin', '2022-10-17 09:33:11', 'admin', '2022-10-17 09:33:11');

INSERT INTO `t_dict_data` VALUES (12, 2, '异常', 'ERROR', 'sys_log_type', NULL, 'default', 'N', 'Y', NULL, 'N', 'admin', '2022-10-17 09:33:20', 'admin', '2022-10-17 09:33:20');



-- ----------------------------

-- Table structure for t_dict_type

-- ----------------------------

DROP TABLE IF EXISTS `t_dict_type`;

CREATE TABLE `t_dict_type`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',

  `dict_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典名称',

  `dict_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典类型',

  `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'Y' COMMENT '状态',

  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',

  `deleted` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N' COMMENT '是否删除',

  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建人',

  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',

  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新人',

  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `dict_type`(`dict_type`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 105 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典类型表' ROW_FORMAT = COMPACT;



-- ----------------------------

-- Records of t_dict_type

-- ----------------------------

INSERT INTO `t_dict_type` VALUES (100, '系统开关', 'sys_normal_disable', 'Y', '', 'N', '', '2021-10-17 18:23:14', '', '2021-11-30 18:38:57');

INSERT INTO `t_dict_type` VALUES (101, '菜单状态', 'sys_show_hide', 'Y', '', 'N', '', '2021-10-17 18:23:14', '', '2021-10-18 16:09:02');

INSERT INTO `t_dict_type` VALUES (102, '任务状态', 'sys_job_status', 'Y', NULL, 'N', 'admin', '2022-09-29 13:56:56', 'admin', '2022-09-29 13:56:56');

INSERT INTO `t_dict_type` VALUES (104, '日志类型', 'sys_log_type', 'Y', NULL, 'N', 'admin', '2022-10-17 09:32:50', 'admin', '2022-10-17 09:32:50');



-- ----------------------------

-- Table structure for t_menu

-- ----------------------------

DROP TABLE IF EXISTS `t_menu`;

CREATE TABLE `t_menu`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',

  `parent_id` bigint(20) NOT NULL DEFAULT -1 COMMENT '父权限编号',

  `parent_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',

  `path` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路径',

  `component` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单页面实现',

  `type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'M' COMMENT '类型',

  `display` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'Y' COMMENT '是否显示',

  `icon` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',

  `seq` int(11) NOT NULL DEFAULT 0 COMMENT '排序',

  `perms` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限字符串',

  `query` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由参数',

  `frame` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N' COMMENT '是否外链',

  `cache` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'Y' COMMENT '是否缓存',

  `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'Y' COMMENT '状态',

  `deleted` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N' COMMENT '是否删除',

  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',

  `create_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',

  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',

  `update_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 105010 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单表' ROW_FORMAT = COMPACT;



-- ----------------------------

-- Records of t_menu

-- ----------------------------

INSERT INTO `t_menu` VALUES (100000, '系统管理', 0, '', 'system', '', 'M', 'Y', 'system', 5, NULL, NULL, 'N', 'Y', 'Y', 'N', '2021-10-17 15:00:00', 'sys', '2021-11-06 17:41:20', 'admin');

INSERT INTO `t_menu` VALUES (101000, '用户管理', 100000, '系统管理', 'user', 'system/user/index', 'C', 'Y', 'user', 1, 'system:user:list', NULL, 'N', 'Y', 'Y', 'N', '2021-10-17 15:00:00', 'sys', NULL, NULL);

INSERT INTO `t_menu` VALUES (101002, '用户新增', 101000, NULL, NULL, NULL, 'F', 'Y', NULL, 1, 'system:user:add', NULL, 'N', 'Y', 'Y', 'N', '2021-10-22 16:57:32', NULL, '2022-10-01 11:51:10', 'admin');

INSERT INTO `t_menu` VALUES (101003, '用户修改', 101000, NULL, NULL, NULL, 'F', 'Y', NULL, 2, 'system:user:edit', NULL, 'N', 'Y', 'Y', 'N', '2021-10-22 16:57:58', NULL, '2022-10-01 11:51:13', 'admin');

INSERT INTO `t_menu` VALUES (101004, '用户删除', 101000, NULL, NULL, NULL, 'F', 'Y', NULL, 3, 'system:user:remove', NULL, 'N', 'Y', 'Y', 'N', '2021-10-22 16:58:12', NULL, '2022-10-01 11:51:17', 'admin');

INSERT INTO `t_menu` VALUES (101005, '重置密码', 101000, NULL, NULL, NULL, 'F', 'Y', NULL, 4, 'system:user:resetPwd', NULL, 'N', 'Y', 'Y', 'N', '2021-10-22 16:58:26', NULL, '2022-10-01 11:51:20', 'admin');

INSERT INTO `t_menu` VALUES (102000, '角色管理', 100000, '系统管理', 'role', 'system/role/index', 'C', 'Y', 'peoples', 2, 'system:role:list', NULL, 'N', 'Y', 'Y', 'N', '2021-10-17 15:00:00', 'sys', NULL, NULL);

INSERT INTO `t_menu` VALUES (102002, '角色新增', 102000, NULL, NULL, NULL, 'F', 'Y', NULL, 1, 'system:role:add', NULL, 'N', 'Y', 'Y', 'N', NULL, NULL, '2022-10-01 11:51:26', 'admin');

INSERT INTO `t_menu` VALUES (102003, '角色修改', 102000, NULL, NULL, NULL, 'F', 'Y', NULL, 2, 'system:role:edit', NULL, 'N', 'Y', 'Y', 'N', NULL, NULL, '2022-10-01 11:51:30', 'admin');

INSERT INTO `t_menu` VALUES (102004, '角色删除', 102000, NULL, NULL, NULL, 'F', 'Y', NULL, 3, 'system:role:remove', NULL, 'N', 'Y', 'Y', 'N', NULL, NULL, '2022-10-01 11:51:33', 'admin');

INSERT INTO `t_menu` VALUES (103000, '菜单管理', 100000, '系统管理', 'menu', 'system/menu/index', 'C', 'Y', 'tree-table', 3, 'system:menu:list', NULL, 'N', 'Y', 'Y', 'N', '2021-10-17 15:00:00', 'sys', NULL, NULL);

INSERT INTO `t_menu` VALUES (103002, '菜单新增', 103000, NULL, NULL, NULL, 'F', 'Y', NULL, 1, 'system:menu:add', NULL, 'N', 'Y', 'Y', 'N', NULL, NULL, '2022-10-01 11:51:39', 'admin');

INSERT INTO `t_menu` VALUES (103003, '菜单修改', 103000, NULL, NULL, NULL, 'F', 'Y', NULL, 2, 'system:menu:edit', NULL, 'N', 'Y', 'Y', 'N', NULL, NULL, '2022-10-01 11:51:42', 'admin');

INSERT INTO `t_menu` VALUES (103004, '菜单删除', 103000, NULL, NULL, NULL, 'F', 'Y', NULL, 3, 'system:menu:remove', NULL, 'N', 'Y', 'Y', 'N', NULL, NULL, '2022-10-01 11:51:45', 'admin');

INSERT INTO `t_menu` VALUES (104000, '字典管理', 100000, '系统管理', 'dict', 'system/dict/index', 'C', 'Y', 'dict', 4, 'system:dict:list', NULL, 'N', 'Y', 'Y', 'N', '2021-10-17 15:00:00', 'sys', NULL, NULL);

INSERT INTO `t_menu` VALUES (104002, '字典新增', 104000, NULL, NULL, NULL, 'F', 'Y', NULL, 1, 'system:dict:add', NULL, 'N', 'Y', 'Y', 'N', NULL, NULL, '2022-10-01 11:51:50', 'admin');

INSERT INTO `t_menu` VALUES (104003, '字典修改', 104000, NULL, NULL, NULL, 'F', 'Y', NULL, 2, 'system:dict:edit', NULL, 'N', 'Y', 'Y', 'N', NULL, NULL, '2022-10-01 11:51:53', 'admin');

INSERT INTO `t_menu` VALUES (104004, '字典删除', 104000, NULL, NULL, NULL, 'F', 'Y', NULL, 3, 'system:dict:remove', NULL, 'N', 'Y', 'Y', 'N', NULL, NULL, '2022-10-01 11:51:56', 'admin');

INSERT INTO `t_menu` VALUES (105000, '流水号管理', 100000, NULL, 'sequence', 'system/sequence/index', 'C', 'Y', 'number', 5, 'system:sequence:list', NULL, 'N', 'Y', 'Y', 'N', '2021-10-19 14:19:58', NULL, '2021-10-19 16:28:14', NULL);

INSERT INTO `t_menu` VALUES (105001, '流水号修改', 105000, NULL, NULL, NULL, 'F', 'Y', NULL, 1, 'system:sequence:edit', NULL, 'N', 'Y', 'Y', 'N', NULL, NULL, '2022-10-01 11:52:01', 'admin');

INSERT INTO `t_menu` VALUES (105002, '定时任务', 100000, NULL, 'job', 'system/job/index', 'C', 'Y', 'job', 6, 'system:job:list', NULL, 'N', 'Y', 'Y', 'N', '2022-09-29 08:25:32', 'admin', '2022-09-29 08:25:32', 'admin');

INSERT INTO `t_menu` VALUES (105003, '任务新增', 105002, NULL, NULL, NULL, 'F', 'Y', NULL, 1, 'system:job:add', NULL, 'N', 'Y', 'Y', 'N', '2022-10-01 11:49:21', 'admin', '2022-10-01 11:49:21', 'admin');

INSERT INTO `t_menu` VALUES (105004, '任务删除', 105002, NULL, NULL, NULL, 'F', 'Y', NULL, 2, 'system:job:remove', NULL, 'N', 'Y', 'Y', 'N', '2022-10-01 11:49:41', 'admin', '2022-10-01 11:49:41', 'admin');

INSERT INTO `t_menu` VALUES (105005, '任务修改', 105002, NULL, NULL, NULL, 'F', 'Y', NULL, 3, 'system:job:edit', NULL, 'N', 'Y', 'Y', 'N', '2022-10-01 11:49:56', 'admin', '2022-10-01 11:49:56', 'admin');

INSERT INTO `t_menu` VALUES (105006, '任务执行', 105002, NULL, NULL, NULL, 'F', 'Y', NULL, 4, 'system:job:run', NULL, 'N', 'Y', 'Y', 'N', '2022-10-01 11:50:07', 'admin', '2022-10-01 11:50:07', 'admin');

INSERT INTO `t_menu` VALUES (105007, '任务暂停', 105002, NULL, NULL, NULL, 'F', 'Y', NULL, 5, 'system:job:pause', NULL, 'N', 'Y', 'Y', 'N', '2022-10-01 11:50:21', 'admin', '2022-10-01 11:50:21', 'admin');

INSERT INTO `t_menu` VALUES (105008, '任务恢复', 105002, NULL, NULL, NULL, 'F', 'Y', NULL, 6, 'system:job:resume', NULL, 'N', 'Y', 'Y', 'N', '2022-10-01 11:50:35', 'admin', '2022-10-17 08:33:15', 'admin');



-- ----------------------------

-- Table structure for t_role

-- ----------------------------

DROP TABLE IF EXISTS `t_role`;

CREATE TABLE `t_role`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `role_key` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色权限',

  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',

  `seq` int(11) NOT NULL DEFAULT 0,

  `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',

  `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'Y',

  `deleted` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N' COMMENT '是否删除',

  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',

  `create_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',

  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',

  `update_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户角色表' ROW_FORMAT = COMPACT;



-- ----------------------------

-- Records of t_role

-- ----------------------------

INSERT INTO `t_role` VALUES (1, 'role_admin', '超级管理员角色', 1, '超级管理员', 'Y', 'N', '2021-10-18 15:28:00', 'sys', NULL, NULL);



-- ----------------------------

-- Table structure for t_role_menu

-- ----------------------------

DROP TABLE IF EXISTS `t_role_menu`;

CREATE TABLE `t_role_menu`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `role_id` bigint(20) NOT NULL COMMENT '角色编号',

  `menu_id` bigint(20) NOT NULL COMMENT '权限编号',

  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',

  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色菜单表' ROW_FORMAT = COMPACT;



-- ----------------------------

-- Records of t_role_menu

-- ----------------------------



-- ----------------------------

-- Table structure for t_seq_data

-- ----------------------------

DROP TABLE IF EXISTS `t_seq_data`;

CREATE TABLE `t_seq_data`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `prefix` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '前缀',

  `precode` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '前端部分',

  `current_val` bigint(20) NOT NULL DEFAULT 1 COMMENT '当前值',

  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',

  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流水号数据' ROW_FORMAT = COMPACT;



-- ----------------------------

-- Records of t_seq_data

-- ----------------------------



-- ----------------------------

-- Table structure for t_seq_rule

-- ----------------------------

DROP TABLE IF EXISTS `t_seq_rule`;

CREATE TABLE `t_seq_rule`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型',

  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',

  `prefix` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '前缀',

  `pattern` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板',

  `length` int(11) NOT NULL DEFAULT 6 COMMENT '流水长度',

  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',

  `create_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',

  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',

  `update_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `type_UNIQUE`(`type`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流水号规则' ROW_FORMAT = COMPACT;



-- ----------------------------

-- Records of t_seq_rule

-- ----------------------------

INSERT INTO `t_seq_rule` VALUES (1, 'T', '测试流水号', 'T', NULL, 6, '2021-10-18 18:49:00', 'sys', '2021-10-19 16:27:12', NULL);



-- ----------------------------

-- Table structure for t_sys_job

-- ----------------------------

DROP TABLE IF EXISTS `t_sys_job`;

CREATE TABLE `t_sys_job`  (

  `id` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

  `job_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务名称',

  `job_class_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务类名',

  `cron_expression` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'cron表达式',

  `with_param` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'N' COMMENT '是否有参数',

  `parameter` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数',

  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',

  `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'S' COMMENT '状态 W正常 S停止',

  `deleted` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'N' COMMENT '删除状态',

  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',

  `create_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',

  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',

  `update_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;



-- ----------------------------

-- Records of t_sys_job

-- ----------------------------

INSERT INTO `t_sys_job` VALUES ('9fc82870ecf84173929a701fcf630773', '测试Job1', 'com.ithuameng.admin.job.test.TestJob', '0/5 * * * * ?', 'Y', 'a=5&b=2&c=0', '测试Job', 'S', 'N', '2021-08-12 15:06:00', 'admin', '2022-10-17 09:37:03', 'admin');



-- ----------------------------

-- Table structure for t_sys_job_log

-- ----------------------------

DROP TABLE IF EXISTS `t_sys_job_log`;

CREATE TABLE `t_sys_job_log`  (

  `id` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

  `job_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务编号',

  `job_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务名称',

  `parameter` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行参数',

  `status` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '执行状态',

  `exception_message` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '异常信息',

  `execute_time` datetime NOT NULL COMMENT '执行时间',

  `end_time` datetime NOT NULL COMMENT '结束时间',

  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '任务执行记录表' ROW_FORMAT = COMPACT;



-- ----------------------------

-- Records of t_sys_job_log

-- ----------------------------

INSERT INTO `t_sys_job_log` VALUES ('0e3eb57a90ede292bcf9a4610ac9b272', '9fc82870ecf84173929a701fcf630773', '测试Job1', 'a=5,b=2,c=0', 'S', NULL, '2022-10-17 09:36:55', '2022-10-17 09:36:55', '2022-10-17 09:36:55');

INSERT INTO `t_sys_job_log` VALUES ('b3f90da057d58f725b5480934745e6e5', '9fc82870ecf84173929a701fcf630773', '测试Job1', 'a=5,b=2,c=0', 'S', NULL, '2022-10-17 09:36:50', '2022-10-17 09:36:50', '2022-10-17 09:36:50');

INSERT INTO `t_sys_job_log` VALUES ('bd8085ac2a6e1ce36311c0e70fb0bd79', '9fc82870ecf84173929a701fcf630773', '测试Job1', 'a=5,b=2,c=0', 'S', NULL, '2022-10-17 09:37:00', '2022-10-17 09:37:00', '2022-10-17 09:37:00');



-- ----------------------------

-- Table structure for t_sys_log

-- ----------------------------

DROP TABLE IF EXISTS `t_sys_log`;

CREATE TABLE `t_sys_log`  (

  `id` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',

  `type` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志类型',

  `title` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志标题',

  `remote_addr` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求地址',

  `request_uri` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'URI',

  `method` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求方式',

  `params` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交参数',

  `exception` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '异常',

  `operate_date` datetime NULL DEFAULT NULL COMMENT '开始时间',

  `duration` bigint(20) NULL DEFAULT NULL COMMENT '持续时间',

  `user_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户ID',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;



-- ----------------------------

-- Records of t_sys_log

-- ----------------------------

INSERT INTO `t_sys_log` VALUES ('37dd2a12b6f7a2018832f7fde14a116d', 'FINE', '暂停定时任务', '0:0:0:0:0:0:0:1', '/admin/v1/quartz/job/pause', 'GET', '[9fc82870ecf84173929a701fcf630773]', NULL, '2022-10-17 09:37:03', 0, '1');

INSERT INTO `t_sys_log` VALUES ('50a6eeb0ce80a7a51c589212e6f64839', 'FINE', '新增字典数据', '0:0:0:0:0:0:0:1', '/admin/v1/dict/data/add', 'POST', '[DictData(id=null, dictSort=2, dictLabel=异常, dictValue=ERROR, dictType=sys_log_type, cssClass=null, listClass=default, isDefault=null, status=YES, remark=null)]', NULL, '2022-10-17 09:33:20', 0, '1');

INSERT INTO `t_sys_log` VALUES ('7933484835db08111d227fb150377474', 'FINE', '新增字典数据', '0:0:0:0:0:0:0:1', '/admin/v1/dict/data/add', 'POST', '[DictData(id=null, dictSort=1, dictLabel=正常, dictValue=FINE, dictType=sys_log_type, cssClass=null, listClass=default, isDefault=null, status=YES, remark=null)]', NULL, '2022-10-17 09:33:11', 0, '1');

INSERT INTO `t_sys_log` VALUES ('9774e9a3d5f7e7b9610776f1edf42607', 'ERROR', '新增字典类型', '0:0:0:0:0:0:0:1', '/admin/v1/dict/type/add', 'POST', '[DictType(id=null, dictName=日志类型, dictType=sys_log_type, status=YES, remark=null)]', '异常测试', '2022-10-17 09:32:50', 0, '1');

INSERT INTO `t_sys_log` VALUES ('edf4ee7268c9575e3f647d55d504e939', 'FINE', '恢复定时任务', '0:0:0:0:0:0:0:1', '/admin/v1/quartz/job/resume', 'GET', '[9fc82870ecf84173929a701fcf630773]', NULL, '2022-10-17 09:36:48', 0, '1');



-- ----------------------------

-- Table structure for t_user

-- ----------------------------

DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `username` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',

  `password` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',

  `nickname` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',

  `mobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号码',

  `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '描述',

  `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'Y' COMMENT '是否锁定',

  `deleted` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N' COMMENT '是否删除',

  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',

  `create_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',

  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',

  `update_by` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = COMPACT;



-- ----------------------------

-- Records of t_user

-- ----------------------------

INSERT INTO `t_user` VALUES (1, 'admin', '$2a$10$okymFxoyFxWCFiEeC0UmMezkfS22zNX6dseDqw590BUd78q/.bRoC', '管理员', '17798982608', '超级管理员', 'Y', 'N', '2021-10-15 00:00:00', 'admin', '2021-12-07 19:40:57', 'admin');



-- ----------------------------

-- Table structure for t_user_role

-- ----------------------------

DROP TABLE IF EXISTS `t_user_role`;

CREATE TABLE `t_user_role`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_id` bigint(20) NOT NULL COMMENT '用户编号',

  `role_id` bigint(20) NOT NULL COMMENT '角色编号',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;



-- ----------------------------

-- Records of t_user_role

-- ----------------------------



SET FOREIGN_KEY_CHECKS = 1;
1
https://gitee.com/ithuameng/ruoyi-admin-template.git
git@gitee.com:ithuameng/ruoyi-admin-template.git
ithuameng
ruoyi-admin-template
ruoyi-admin-template
master
点此查找更多帮助

搜索帮助

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