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

yinglonglll/java_standard_database

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
java_standard_multiple.sql 45.44 KB
一键复制 编辑 原始数据 按行查看 历史
yinglonglll 提交于 2023-03-16 16:25 . add：实现BySql方式从数据库动态注入数据源，并优化代码规范
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420
/*

 Navicat Premium Data Transfer



 Source Server         : localhost

 Source Server Type    : MySQL

 Source Server Version : 50733

 Source Host           : localhost:3306

 Source Schema         : java_standard_multiple



 Target Server Type    : MySQL

 Target Server Version : 50733

 File Encoding         : 65001



 Date: 16/03/2023 16:22:50

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



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

-- Table structure for sequence

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

DROP TABLE IF EXISTS `sequence`;

CREATE TABLE `sequence`  (

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `current_value` bigint(25) NULL DEFAULT NULL,

  `increment` int(25) NULL DEFAULT NULL

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



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

-- Records of sequence

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

INSERT INTO `sequence` VALUES ('sys_admin', 5, 1);

INSERT INTO `sequence` VALUES ('sys_quartz_job', 1582931182951129089, 1);

INSERT INTO `sequence` VALUES ('sys_quartz_log', 1, 1);

INSERT INTO `sequence` VALUES ('sys_quartz_run_job', 1, 1);

INSERT INTO `sequence` VALUES ('sys_quartz_schedule', 1, 1);

INSERT INTO `sequence` VALUES ('sys_sql_log', 1, 1);

INSERT INTO `sequence` VALUES ('sys_user', 1, 1);



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

-- Table structure for sys_admin

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

DROP TABLE IF EXISTS `sys_admin`;

CREATE TABLE `sys_admin`  (

  `id` bigint(25) NOT NULL,

  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `age` bigint(25) NULL DEFAULT NULL,

  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `create_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `create_time` datetime NULL DEFAULT NULL,

  `update_time` datetime NULL DEFAULT NULL,

  `delete_flag` tinyint(1) NULL DEFAULT NULL,

  `version` int(25) NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

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



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

-- Records of sys_admin

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

INSERT INTO `sys_admin` VALUES (1, 'A张三', 23, '2323232323@qq.com', '1231231', NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sys_admin` VALUES (2, 'A李四', 24, '2424242424@qq.com', '7565685', NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sys_admin` VALUES (3, 'A王五', 25, '2525252525@qq.com', '4564747', NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sys_admin` VALUES (4, 'A老六', 26, '2626262626@qq.com', '9678675', NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `sys_admin` VALUES (5, 'A赵七', 27, '2727272727@qq.com', '65674845', NULL, NULL, NULL, NULL, NULL, NULL);



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

-- Table structure for sys_quartz_job

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

DROP TABLE IF EXISTS `sys_quartz_job`;

CREATE TABLE `sys_quartz_job`  (

  `id` bigint(25) NOT NULL,

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `group_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `class_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `params` json NULL,

  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `version` int(25) NULL DEFAULT NULL,

  `delete_flag` tinyint(1) NULL DEFAULT NULL,

  `create_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `create_time` datetime NULL DEFAULT NULL,

  `update_time` datetime NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

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



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

-- Records of sys_quartz_job

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

INSERT INTO `sys_quartz_job` VALUES (1579300160718917634, 'job2', 'test', 'testService', '{\"firstParam\": \"我是测试第一个参数\", \"thirdParam\": \"我是测试第三个参数\", \"secondParam\": \"我是测试第二个参数\"}', '我是quartzJob的描述信息', 1, 1, 'System', 'System', '2022-10-10 10:37:55', '2022-10-10 10:37:55');

INSERT INTO `sys_quartz_job` VALUES (1579300505566203906, 'job2', 'test', 'testService', '{\"firstParam\": \"我是测试第一个参数\", \"thirdParam\": \"我是测试第三个参数\", \"secondParam\": \"我是测试第二个参数\"}', '我是quartzJob的描述信息', 1, 1, 'System', 'System', '2022-10-10 10:39:17', '2022-10-10 10:39:17');

INSERT INTO `sys_quartz_job` VALUES (1579314057727344642, 'job2', 'test', 'testService', '{\"firstParam\": \"我是测试第一个参数\", \"thirdParam\": \"我是测试第三个参数\", \"secondParam\": \"我是测试第二个参数\"}', '我是quartzJob的描述信息', 1, 1, 'System', 'System', '2022-10-10 11:33:08', '2022-10-10 11:33:08');

INSERT INTO `sys_quartz_job` VALUES (1582931182951129089, 'job2', 'test', 'testService', '{\"firstParam\": \"我是测试第一个参数\", \"thirdParam\": \"我是测试第三个参数\", \"secondParam\": \"我是测试第二个参数\"}', '我是quartzJob的描述信息', 1, 1, 'System', 'System', '2022-10-20 11:06:18', '2022-10-20 11:06:18');

INSERT INTO `sys_quartz_job` VALUES (1627931048046129154, 'job2', 'test', 'testService', '{\"firstParam\": \"我是测试第一个参数\", \"thirdParam\": \"我是测试第三个参数\", \"secondParam\": \"我是测试第二个参数\"}', '我是quartzJob的描述信息', 1, 1, 'System', 'System', '2023-02-21 15:19:42', '2023-02-21 15:19:42');



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

-- Table structure for sys_quartz_log

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

DROP TABLE IF EXISTS `sys_quartz_log`;

CREATE TABLE `sys_quartz_log`  (

  `id` bigint(25) NOT NULL,

  `job_id` bigint(25) NULL DEFAULT NULL,

  `trigger_id` bigint(25) NULL DEFAULT NULL,

  `schedule_id` bigint(25) NULL DEFAULT NULL,

  `exception` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

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



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

-- Records of sys_quartz_log

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



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

-- Table structure for sys_quartz_run_job

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

DROP TABLE IF EXISTS `sys_quartz_run_job`;

CREATE TABLE `sys_quartz_run_job`  (

  `id` bigint(25) NOT NULL AUTO_INCREMENT,

  `job_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `trigger_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `create_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `create_time` datetime NULL DEFAULT NULL,

  `update_time` datetime NULL DEFAULT NULL,

  `delete_flag` tinyint(1) NULL DEFAULT NULL,

  `version` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 1627931049765793795 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;



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

-- Records of sys_quartz_run_job

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

INSERT INTO `sys_quartz_run_job` VALUES (1579300161339674625, 'job2', '我是正在运行触发器的名字', '我是正在运行的描述', 'System', 'System', '2022-10-10 10:37:55', '2022-10-10 10:37:55', 1, '1');

INSERT INTO `sys_quartz_run_job` VALUES (1579300506946129922, 'job2', '我是正在运行触发器的名字', '我是正在运行的描述', 'System', 'System', '2022-10-10 10:39:17', '2022-10-10 10:39:17', 1, '1');

INSERT INTO `sys_quartz_run_job` VALUES (1579314057920282626, 'job2', '我是正在运行触发器的名字', '我是正在运行的描述', 'System', 'System', '2022-10-10 11:33:08', '2022-10-10 11:33:08', 1, '1');

INSERT INTO `sys_quartz_run_job` VALUES (1582931183882264577, 'job2', '我是正在运行触发器的名字', '我是正在运行的描述', 'System', 'System', '2022-10-20 11:06:18', '2022-10-20 11:06:18', 1, '1');

INSERT INTO `sys_quartz_run_job` VALUES (1627931049765793794, 'job2', '我是正在运行触发器的名字', '我是正在运行的描述', 'System', 'System', '2023-02-21 15:19:42', '2023-02-21 15:19:42', 1, '1');



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

-- Table structure for sys_quartz_schedule

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

DROP TABLE IF EXISTS `sys_quartz_schedule`;

CREATE TABLE `sys_quartz_schedule`  (

  `id` int(11) NOT NULL,

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

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



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

-- Records of sys_quartz_schedule

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



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

-- Table structure for sys_quartz_trigger

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

DROP TABLE IF EXISTS `sys_quartz_trigger`;

CREATE TABLE `sys_quartz_trigger`  (

  `id` bigint(20) NOT NULL,

  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `group_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `state` tinyint(1) NULL DEFAULT NULL COMMENT '1:运行；0暂停',

  `job_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `job_group_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `type` tinyint(1) NULL DEFAULT NULL COMMENT '1:simpleTrigger；2:cornTirgger；3:calendarTrigger',

  `type_interval_param` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '1.间隔；2.corn表达式；3.corn表达式',

  `type_scope_param` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '1.次数；23.corn表达式执行的时间范围，若为null则为无限次循环，',

  `times_triggered` int(25) NULL DEFAULT NULL,

  `current_schedule_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `priority` tinyint(1) NULL DEFAULT NULL,

  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `version` int(25) NULL DEFAULT NULL,

  `delete_flag` tinyint(1) NULL DEFAULT NULL,

  `create_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `create_time` datetime NULL DEFAULT NULL,

  `update_time` datetime NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

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



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

-- Records of sys_quartz_trigger

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

INSERT INTO `sys_quartz_trigger` VALUES (1579300161150930946, '我是触发器的名字', 'test', 1, 'job2', NULL, 2, '0/5 * * * * ?', NULL, NULL, NULL, NULL, NULL, 1, 1, 'System', 'System', '2022-10-10 10:37:55', '2022-10-10 10:37:55');

INSERT INTO `sys_quartz_trigger` VALUES (1579300505612341249, '我是触发器的名字', 'test', 1, 'job2', NULL, 2, '0/5 * * * * ?', NULL, NULL, NULL, NULL, NULL, 1, 1, 'System', 'System', '2022-10-10 10:39:17', '2022-10-10 10:39:17');

INSERT INTO `sys_quartz_trigger` VALUES (1579314057874145282, '我是触发器的名字', 'test', 1, 'job2', NULL, 2, '0/5 * * * * ?', NULL, NULL, NULL, NULL, NULL, 1, 1, 'System', 'System', '2022-10-10 11:33:08', '2022-10-10 11:33:08');

INSERT INTO `sys_quartz_trigger` VALUES (1582931183609634818, '我是触发器的名字', 'test', 1, 'job2', NULL, 2, '0/5 * * * * ?', NULL, NULL, NULL, NULL, NULL, 1, 1, 'System', 'System', '2022-10-20 11:06:18', '2022-10-20 11:06:18');

INSERT INTO `sys_quartz_trigger` VALUES (1627931049593827329, '我是触发器的名字', 'test', 0, 'job2', NULL, 2, '0/5 * * * * ?', NULL, NULL, NULL, NULL, NULL, 2, 1, 'System', 'System', '2023-02-21 15:19:42', '2023-02-21 15:20:23');



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

-- Table structure for sys_sql_log

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

DROP TABLE IF EXISTS `sys_sql_log`;

CREATE TABLE `sys_sql_log`  (

  `id` bigint(25) NOT NULL,

  `user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `operation_sql` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,

  `create_time` datetime NULL DEFAULT NULL,

  `update_time` datetime NULL DEFAULT NULL,

  `create_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `delete_flag` tinyint(1) NULL DEFAULT NULL,

  `version` int(25) NULL DEFAULT NULL

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



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

-- Records of sys_sql_log

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

INSERT INTO `sys_sql_log` VALUES (1570241937031593985, 'pyrrha', '127.0.0.1', 'INSERT INTO sys_user  ( id,\nusername,\nage,\n\n\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1570241936993845249,\n\'zzj123???\',\n2020,\n\n\n\'System\',\n\'System\',\n\'2022-09-15 10:43:46.121\',\n\'2022-09-15 10:43:46.121\',\n0,\n1 )', '2022-09-15 10:43:46', '2022-09-15 10:43:46', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1570244941222858754, 'pyrrha', '127.0.0.1', 'INSERT INTO sys_user  ( id,\nusername,\nage,\n\n\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1570244940845371394,\n\'zzj123???\',\n2020,\n\n\n\'System\',\n\'System\',\n\'2022-09-15 10:55:42.295\',\n\'2022-09-15 10:55:42.295\',\n0,\n1 )', '2022-09-15 10:55:42', '2022-09-15 10:55:42', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1570245383805816834, 'pyrrha', '127.0.0.1', 'INSERT INTO sys_user  ( id,\nusername,\nage,\n\n\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1570245383780651010,\n\'zzj123???\',\n2020,\n\n\n\'System\',\n\'System\',\n\'2022-09-15 10:57:27.899\',\n\'2022-09-15 10:57:27.899\',\n0,\n1 )', '2022-09-15 10:57:28', '2022-09-15 10:57:28', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1570245594506645505, 'pyrrha', '127.0.0.1', 'INSERT INTO sys_user  ( id,\nusername,\nage,\n\n\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1570245594154323969,\n\'zzj123???\',\n2020,\n\n\n\'System\',\n\'System\',\n\'2022-09-15 10:58:18.056\',\n\'2022-09-15 10:58:18.056\',\n0,\n1 )', '2022-09-15 10:58:18', '2022-09-15 10:58:18', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697116149743617, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:07.708\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:08', '2022-09-19 11:06:08', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697117143793665, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:08.041\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:08', '2022-09-19 11:06:08', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697117634527234, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:08.162\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:08', '2022-09-19 11:06:08', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697118238507010, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:08.305\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:08', '2022-09-19 11:06:08', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697118536302593, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:08.407\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:08', '2022-09-19 11:06:08', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697118850875394, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:08.47\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:09', '2022-09-19 11:06:09', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697119178031105, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:08.552\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:09', '2022-09-19 11:06:09', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697119589072897, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:08.634\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:09', '2022-09-19 11:06:09', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697119916228610, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:08.742\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:09', '2022-09-19 11:06:09', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697120398573569, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:08.859\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:09', '2022-09-19 11:06:09', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697120776060929, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:08.949\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:09', '2022-09-19 11:06:09', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697121153548289, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:09.043\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:09', '2022-09-19 11:06:09', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697121732362241, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:09.176\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:09', '2022-09-19 11:06:09', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697122181152770, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:09.286\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:09', '2022-09-19 11:06:09', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1571697122445393921, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'Jan\',\nage=22,\nemail=\'tom@163.com\',\npassword=\'262626\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-07-21 16:20:15.0\',\nupdate_time=\'2022-09-19 11:06:09.356\',\nversion=5  \n WHERE  delete_flag=0\n\nAND (version = 4)', '2022-09-19 11:06:09', '2022-09-19 11:06:09', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1575764552381816833, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_user  ( id,\nusername,\nage,\nemail,\npassword,\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1575764552323096577,\n\'pyrrha\',\n17,\n\'948706806@qq.com\',\n\'123456\',\n\'System\',\n\'System\',\n\'2022-09-30 16:28:40.221\',\n\'2022-09-30 16:28:40.221\',\n0,\n1 )', '2022-09-30 16:28:40', '2022-09-30 16:28:40', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1575764553182928898, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'pyrrha\',\nage=20,\nemail=\'948706806@qq.com\',\npassword=\'123456\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-09-30 16:24:43.0\',\nupdate_time=\'2022-09-30 16:28:40.411\',\nversion=4  \n WHERE  delete_flag=0\n\nAND (version = 3)', '2022-09-30 16:28:40', '2022-09-30 16:28:40', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1575764553535250434, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'pyrrha\',\nage=19,\nemail=\'948706806@qq.com\',\npassword=\'123456\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-09-30 16:25:27.0\',\nupdate_time=\'2022-09-30 16:28:40.499\',\nversion=3  \n WHERE  delete_flag=0\n\nAND (version = 2)', '2022-09-30 16:28:41', '2022-09-30 16:28:41', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1575764553757548546, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'pyrrha\',\nage=18,\nemail=\'948706806@qq.com\',\npassword=\'123456\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2022-09-30 16:28:40.0\',\nupdate_time=\'2022-09-30 16:28:40.546\',\nversion=2  \n WHERE  delete_flag=0\n\nAND (version = 1)', '2022-09-30 16:28:41', '2022-09-30 16:28:41', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579300160999936002, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_job  ( id,\nname,\ngroup_name,\nclass_name,\nparams,\ndescription,\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1579300160718917634,\n\'job2\',\n\'test\',\n\'testService\',\n\'{\"firstParam\":\"我是测试第一个参数\",\"secondParam\":\"我是测试第二个参数\",\"thirdParam\":\"我是测试第三个参数\"}\',\n\'我是quartzJob的描述信息\',\n\'System\',\n\'System\',\n\'2022-10-10 10:37:54.95\',\n\'2022-10-10 10:37:54.951\',\n0,\n1 )', '2022-10-10 10:37:55', '2022-10-10 10:37:55', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579300161297731586, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_trigger  ( id,\nname,\ngroup_name,\nstate,\njob_name,\n\ntype,\ntype_interval_param,\n\n\n\n\n\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1579300161150930946,\n\'我是触发器的名字\',\n\'test\',\n1,\n\'job2\',\n\n2,\n\'0/5 * * * * ?\',\n\n\n\n\n\n\'System\',\n\'System\',\n\'2022-10-10 10:37:55.053\',\n\'2022-10-10 10:37:55.053\',\n0,\n1 )', '2022-10-10 10:37:55', '2022-10-10 10:37:55', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579300161385811970, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_run_job  ( id,\njob_name,\ntrigger_name,\ndescription,\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1579300161339674625,\n\'job2\',\n\'我是正在运行触发器的名字\',\n\'我是正在运行的描述\',\n\'System\',\n\'System\',\n\'2022-10-10 10:37:55.098\',\n\'2022-10-10 10:37:55.099\',\n0,\n1 )', '2022-10-10 10:37:55', '2022-10-10 10:37:55', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579300346098765826, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_trigger SET delete_flag=1  WHERE job_name = \'job2\' \n\n\n AND delete_flag=0', '2022-10-10 10:38:39', '2022-10-10 10:38:39', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579300346501419010, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_job SET delete_flag=1  WHERE name = \'job2\' \n\n\n AND delete_flag=0', '2022-10-10 10:38:39', '2022-10-10 10:38:39', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579300349412265986, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_run_job SET delete_flag=1  WHERE job_name = \'job2\' \n\n\n AND delete_flag=0', '2022-10-10 10:38:40', '2022-10-10 10:38:40', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579300505587175425, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_job  ( id,\nname,\ngroup_name,\nclass_name,\nparams,\ndescription,\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1579300505566203906,\n\'job2\',\n\'test\',\n\'testService\',\n\'{\"firstParam\":\"我是测试第一个参数\",\"secondParam\":\"我是测试第二个参数\",\"thirdParam\":\"我是测试第三个参数\"}\',\n\'我是quartzJob的描述信息\',\n\'System\',\n\'System\',\n\'2022-10-10 10:39:17.168\',\n\'2022-10-10 10:39:17.168\',\n0,\n1 )', '2022-10-10 10:39:17', '2022-10-10 10:39:17', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579300505637507074, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_trigger  ( id,\nname,\ngroup_name,\nstate,\njob_name,\n\ntype,\ntype_interval_param,\n\n\n\n\n\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1579300505612341249,\n\'我是触发器的名字\',\n\'test\',\n1,\n\'job2\',\n\n2,\n\'0/5 * * * * ?\',\n\n\n\n\n\n\'System\',\n\'System\',\n\'2022-10-10 10:39:17.179\',\n\'2022-10-10 10:39:17.179\',\n0,\n1 )', '2022-10-10 10:39:17', '2022-10-10 10:39:17', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579300506988072962, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_run_job  ( id,\njob_name,\ntrigger_name,\ndescription,\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1579300506946129922,\n\'job2\',\n\'我是正在运行触发器的名字\',\n\'我是正在运行的描述\',\n\'System\',\n\'System\',\n\'2022-10-10 10:39:17.497\',\n\'2022-10-10 10:39:17.497\',\n0,\n1 )', '2022-10-10 10:39:18', '2022-10-10 10:39:18', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579300542102786049, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_trigger SET delete_flag=1  WHERE job_name = \'job2\' \n\n\n AND delete_flag=0', '2022-10-10 10:39:26', '2022-10-10 10:39:26', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579300543356882946, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_job SET delete_flag=1  WHERE name = \'job2\' \n\n\n AND delete_flag=0', '2022-10-10 10:39:26', '2022-10-10 10:39:26', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579300544690671618, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_run_job SET delete_flag=1  WHERE job_name = \'job2\' \n\n\n AND delete_flag=0', '2022-10-10 10:39:26', '2022-10-10 10:39:26', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579314057840590849, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_job  ( id,\nname,\ngroup_name,\nclass_name,\nparams,\ndescription,\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1579314057727344642,\n\'job2\',\n\'test\',\n\'testService\',\n\'{\"firstParam\":\"我是测试第一个参数\",\"secondParam\":\"我是测试第二个参数\",\"thirdParam\":\"我是测试第三个参数\"}\',\n\'我是quartzJob的描述信息\',\n\'System\',\n\'System\',\n\'2022-10-10 11:33:08.256\',\n\'2022-10-10 11:33:08.256\',\n0,\n1 )', '2022-10-10 11:33:08', '2022-10-10 11:33:08', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579314057895116802, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_trigger  ( id,\nname,\ngroup_name,\nstate,\njob_name,\n\ntype,\ntype_interval_param,\n\n\n\n\n\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1579314057874145282,\n\'我是触发器的名字\',\n\'test\',\n1,\n\'job2\',\n\n2,\n\'0/5 * * * * ?\',\n\n\n\n\n\n\'System\',\n\'System\',\n\'2022-10-10 11:33:08.29\',\n\'2022-10-10 11:33:08.29\',\n0,\n1 )', '2022-10-10 11:33:08', '2022-10-10 11:33:08', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579314057937059842, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_run_job  ( id,\njob_name,\ntrigger_name,\ndescription,\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1579314057920282626,\n\'job2\',\n\'我是正在运行触发器的名字\',\n\'我是正在运行的描述\',\n\'System\',\n\'System\',\n\'2022-10-10 11:33:08.301\',\n\'2022-10-10 11:33:08.301\',\n0,\n1 )', '2022-10-10 11:33:08', '2022-10-10 11:33:08', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579314110848204802, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_trigger SET delete_flag=1  WHERE job_name = \'job2\' \n\n\n AND delete_flag=0', '2022-10-10 11:33:21', '2022-10-10 11:33:21', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579314111028559873, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_job SET delete_flag=1  WHERE name = \'job2\' \n\n\n AND delete_flag=0', '2022-10-10 11:33:21', '2022-10-10 11:33:21', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579314111225692161, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_run_job SET delete_flag=1  WHERE job_name = \'job2\' \n\n\n AND delete_flag=0', '2022-10-10 11:33:21', '2022-10-10 11:33:21', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1579314914082586625, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_run_job  ( id,\njob_name,\ntrigger_name,\n\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1579314913969340418,\n\'job2\',\n\'test\',\n\n\'System\',\n\'System\',\n\'2022-10-10 11:36:32.399\',\n\'2022-10-10 11:36:32.399\',\n0,\n1 )', '2022-10-10 11:36:32', '2022-10-10 11:36:32', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1582931183391531010, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_job  ( id,\nname,\ngroup_name,\nclass_name,\nparams,\ndescription,\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1582931182951129089,\n\'job2\',\n\'test\',\n\'testService\',\n\'{\"firstParam\":\"我是测试第一个参数\",\"secondParam\":\"我是测试第二个参数\",\"thirdParam\":\"我是测试第三个参数\"}\',\n\'我是quartzJob的描述信息\',\n\'System\',\n\'System\',\n\'2022-10-20 11:06:18.112\',\n\'2022-10-20 11:06:18.112\',\n0,\n1 )', '2022-10-20 11:06:18', '2022-10-20 11:06:18', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1582931183848710146, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_trigger  ( id,\nname,\ngroup_name,\nstate,\njob_name,\n\ntype,\ntype_interval_param,\n\n\n\n\n\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1582931183609634818,\n\'我是触发器的名字\',\n\'test\',\n1,\n\'job2\',\n\n2,\n\'0/5 * * * * ?\',\n\n\n\n\n\n\'System\',\n\'System\',\n\'2022-10-20 11:06:18.268\',\n\'2022-10-20 11:06:18.268\',\n0,\n1 )', '2022-10-20 11:06:18', '2022-10-20 11:06:18', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1582931183907430402, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_run_job  ( id,\njob_name,\ntrigger_name,\ndescription,\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1582931183882264577,\n\'job2\',\n\'我是正在运行触发器的名字\',\n\'我是正在运行的描述\',\n\'System\',\n\'System\',\n\'2022-10-20 11:06:18.333\',\n\'2022-10-20 11:06:18.333\',\n0,\n1 )', '2022-10-20 11:06:18', '2022-10-20 11:06:18', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1582931257521659906, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_trigger SET delete_flag=1  WHERE job_name = \'job2\' \n\n\n AND delete_flag=0', '2022-10-20 11:06:36', '2022-10-20 11:06:36', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1582931257798483969, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_job SET delete_flag=1  WHERE name = \'job2\' \n\n\n AND delete_flag=0', '2022-10-20 11:06:36', '2022-10-20 11:06:36', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1582931257974644738, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_run_job SET delete_flag=1  WHERE job_name = \'job2\' \n\n\n AND delete_flag=0', '2022-10-20 11:06:36', '2022-10-20 11:06:36', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1627931049488969730, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_job  ( id,\nname,\ngroup_name,\nclass_name,\nparams,\ndescription,\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1627931048046129154,\n\'job2\',\n\'test\',\n\'testService\',\n\'{\"firstParam\":\"我是测试第一个参数\",\"secondParam\":\"我是测试第二个参数\",\"thirdParam\":\"我是测试第三个参数\"}\',\n\'我是quartzJob的描述信息\',\n\'System\',\n\'System\',\n\'2023-02-21 15:19:42.008\',\n\'2023-02-21 15:19:42.008\',\n0,\n1 )', '2023-02-21 15:19:42', '2023-02-21 15:19:42', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1627931049728045057, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_trigger  ( id,\nname,\ngroup_name,\nstate,\njob_name,\n\ntype,\ntype_interval_param,\n\n\n\n\n\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1627931049593827329,\n\'我是触发器的名字\',\n\'test\',\n1,\n\'job2\',\n\n2,\n\'0/5 * * * * ?\',\n\n\n\n\n\n\'System\',\n\'System\',\n\'2023-02-21 15:19:42.378\',\n\'2023-02-21 15:19:42.378\',\n0,\n1 )', '2023-02-21 15:19:42', '2023-02-21 15:19:42', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1627931049790959617, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_quartz_run_job  ( id,\njob_name,\ntrigger_name,\ndescription,\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1627931049765793794,\n\'job2\',\n\'我是正在运行触发器的名字\',\n\'我是正在运行的描述\',\n\'System\',\n\'System\',\n\'2023-02-21 15:19:42.417\',\n\'2023-02-21 15:19:42.417\',\n0,\n1 )', '2023-02-21 15:19:42', '2023-02-21 15:19:42', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1627931221614817282, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_trigger  SET name=\'我是触发器的名字\',\ngroup_name=\'test\',\nstate=0,\njob_name=\'job2\',\n\ntype=2,\ntype_interval_param=\'0/5 * * * * ?\',\n\n\n\n\n\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2023-02-21 15:19:42.0\',\nupdate_time=\'2023-02-21 15:20:23.381\',\nversion=2  WHERE id=1627931049593827329   AND version=1  AND delete_flag=0', '2023-02-21 15:20:23', '2023-02-21 15:20:23', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1627931221656760322, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_run_job SET delete_flag=1  WHERE job_name = \'job2\' \n\n\n AND delete_flag=0', '2023-02-21 15:20:23', '2023-02-21 15:20:23', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1627931401953112066, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_trigger SET delete_flag=1  WHERE job_name = \'job2\' \n\n\n AND delete_flag=0', '2023-02-21 15:21:06', '2023-02-21 15:21:06', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1627931401995055105, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_job SET delete_flag=1  WHERE name = \'job2\' \n\n\n AND delete_flag=0', '2023-02-21 15:21:06', '2023-02-21 15:21:06', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1627931402045386753, 'Pyrrha', '127.0.0.1', 'UPDATE sys_quartz_run_job SET delete_flag=1  WHERE job_name = \'job2\' \n\n\n AND delete_flag=0', '2023-02-21 15:21:06', '2023-02-21 15:21:06', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1630748598949834753, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_user  ( id,\nusername,\nage,\nemail,\npassword,\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1630748597330833409,\n\'ar\',\n42,\n\'111111@qq.com\',\n\'111111\',\n\'System\',\n\'System\',\n\'2023-03-01 09:55:38.105\',\n\'2023-03-01 09:55:38.105\',\n0,\n1 )', '2023-03-01 09:55:38', '2023-03-01 09:55:38', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1630748854542376961, 'Pyrrha', '127.0.0.1', 'INSERT INTO sys_user  ( id,\nusername,\nage,\nemail,\npassword,\ncreate_by,\nupdate_by,\ncreate_time,\nupdate_time,\ndelete_flag,\nversion )  VALUES  ( 1630748853468635137,\n\'ar\',\n42,\n\'111111@qq.com\',\n\'111111\',\n\'System\',\n\'System\',\n\'2023-03-01 09:56:39.173\',\n\'2023-03-01 09:56:39.173\',\n0,\n1 )', '2023-03-01 09:56:39', '2023-03-01 09:56:39', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1630748854966001666, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user  SET username=\'ar\',\nage=42,\nemail=\'333333@qq.com\',\npassword=\'333333\',\ncreate_by=\'System\',\nupdate_by=\'System\',\ncreate_time=\'2023-03-01 09:56:39.173\',\nupdate_time=\'2023-03-01 09:56:39.504\',\nversion=2  \n WHERE  delete_flag=0\n\nAND (username = \'ar\' AND version = 1)', '2023-03-01 09:56:40', '2023-03-01 09:56:40', 'System', 'System', 0, 1);

INSERT INTO `sys_sql_log` VALUES (1630748855158939649, 'Pyrrha', '127.0.0.1', 'UPDATE sys_user SET delete_flag=1 \n WHERE  delete_flag=0\n\nAND (username = \'ar\')', '2023-03-01 09:56:40', '2023-03-01 09:56:40', 'System', 'System', 0, 1);



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

-- Table structure for sys_user

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

DROP TABLE IF EXISTS `sys_user`;

CREATE TABLE `sys_user`  (

  `id` bigint(25) NOT NULL COMMENT '主键ID',

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

  `age` bigint(25) NULL DEFAULT NULL COMMENT '年龄',

  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',

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

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

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

  `create_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创造者',

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

  `delete_flag` tinyint(1) NULL DEFAULT NULL COMMENT '逻辑删除（0 未删除、1 删除）',

  `version` int(25) NULL DEFAULT NULL COMMENT '乐观锁',

  PRIMARY KEY (`id`) USING BTREE

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



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

-- Records of sys_user

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

INSERT INTO `sys_user` VALUES (1, 'Jan', 22, 'tom@163.com', '8787878', '2022-07-21 16:20:15', '2022-09-19 11:06:08', 'System', 'System', 0, 5);

INSERT INTO `sys_user` VALUES (2, 'Jan', 22, 'tom@163.com', '787878', '2022-07-21 16:20:15', '2022-09-19 11:06:08', 'System', 'System', 0, 5);

INSERT INTO `sys_user` VALUES (3, '王五', 25, '2525252525@qq.com', '7878787', NULL, NULL, NULL, NULL, 1, 1);

INSERT INTO `sys_user` VALUES (4, 'Jan', 22, 'tom@163.com', '78787878', '2022-07-21 16:20:15', '2022-09-19 11:06:08', 'System', 'System', 0, 5);

INSERT INTO `sys_user` VALUES (5, 'Jan', 22, 'tom@163.com', '7878787', '2022-07-21 16:20:15', '2022-09-19 11:06:08', 'System', 'System', 0, 5);

INSERT INTO `sys_user` VALUES (1551819933331922946, 'ar', 42, '222222@qq.com', '898989', '2022-07-26 14:45:55', '2022-07-26 14:45:56', 'System', 'System', 1, 2);

INSERT INTO `sys_user` VALUES (1551821095502299137, 'ar', 42, '222222@qq.com', '89898989', '2022-07-26 14:45:55', '2022-07-26 14:45:56', 'System', 'System', 1, 2);

INSERT INTO `sys_user` VALUES (1575763557371273218, 'pyrrha', 20, '948706806@qq.com', '98989898', '2022-09-30 16:24:43', '2022-09-30 16:28:40', 'System', 'System', 0, 4);

INSERT INTO `sys_user` VALUES (1575763742314913793, 'pyrrha', 19, '948706806@qq.com', '98988989', '2022-09-30 16:25:27', '2022-09-30 16:28:40', 'System', 'System', 0, 3);

INSERT INTO `sys_user` VALUES (1575764552323096577, 'pyrrha', 18, '948706806@qq.com', '08908989', '2022-09-30 16:28:40', '2022-09-30 16:28:41', 'System', 'System', 0, 2);

INSERT INTO `sys_user` VALUES (1630748597330833409, 'ar', 42, '333333@qq.com', '09808908', '2023-03-01 09:56:39', '2023-03-01 09:56:40', 'System', 'System', 1, 2);

INSERT INTO `sys_user` VALUES (1630748853468635137, 'ar', 42, '333333@qq.com', '89798798', '2023-03-01 09:56:39', '2023-03-01 09:56:40', 'System', 'System', 1, 2);



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

-- Table structure for sys_user_permission

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

DROP TABLE IF EXISTS `sys_user_permission`;

CREATE TABLE `sys_user_permission`  (

  `id` bigint(25) NOT NULL,

  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `permission` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `create_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

  `create_time` datetime NULL DEFAULT NULL,

  `update_time` datetime NULL DEFAULT NULL,

  `delete_flag` tinyint(1) NULL DEFAULT NULL,

  `version` int(25) NULL DEFAULT NULL,

  PRIMARY KEY (`id`) USING BTREE

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



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

-- Records of sys_user_permission

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

INSERT INTO `sys_user_permission` VALUES (1623936986708369409, '小管', 'a123456', 'admin', 'System', 'System', '2023-02-10 14:48:44', '2023-02-10 14:48:44', 0, 1);

INSERT INTO `sys_user_permission` VALUES (1623936986788061185, '小领', 'b123456', 'leader', 'System', 'System', '2023-02-10 14:48:44', '2023-02-10 14:48:44', 0, 1);

INSERT INTO `sys_user_permission` VALUES (1623936986788061186, '小员', 'c123456', 'staff', 'System', 'System', '2023-02-10 14:48:44', '2023-02-10 14:48:44', 0, 1);



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

-- Function structure for getCurrentId

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

DROP FUNCTION IF EXISTS `getCurrentId`;

delimiter ;;

CREATE FUNCTION `getCurrentId`(`seq_name` VARCHAR(50))

 RETURNS bigint(20)

  DETERMINISTIC

BEGIN 

        DECLARE retval BIGINT;

        SET retval=0;  

        SELECT current_value INTO retval 

          FROM sequence  WHERE name = seq_name; 

        RETURN retval; 

END

;;

delimiter ;



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

-- Function structure for gsetNextId

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

DROP FUNCTION IF EXISTS `gsetNextId`;

delimiter ;;

CREATE FUNCTION `gsetNextId`(seq_name VARCHAR(50))

 RETURNS bigint(20)

  DETERMINISTIC

BEGIN

		UPDATE sequence  

			SET current_value = current_value + increment 

				WHERE name = seq_name;  

		RETURN getCurrentId(seq_name); 

END

;;

delimiter ;



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

-- Function structure for resetCurrentId

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

DROP FUNCTION IF EXISTS `resetCurrentId`;

delimiter ;;

CREATE FUNCTION `resetCurrentId`(seq_name VARCHAR(50))

 RETURNS bigint(20)

  DETERMINISTIC

BEGIN

		DECLARE currentId BIGINT;

    SET currentId=0;

		## 因为select语句中无法含有变量值动态执行或不能动态拼接sql实现参数传表名，实现动态查不同表值，因此选择ifelse语句实现动态查询 

		IF seq_name = 'sys_admin' THEN

			SELECT sn.id INTO currentId from sys_admin AS sn order by sn.ID DESC limit 1;

			UPDATE sequence  

				SET current_value = currentId WHERE name = seq_name; 

		ELSEIF(seq_name = 'sys_quartz_job') THEN

			SELECT sn.id INTO currentId from sys_quartz_job AS sn order by sn.ID DESC limit 1;

			UPDATE sequence  

			 SET current_value = currentId WHERE name = seq_name;

		ELSEIF(seq_name = 'sys_quartz_log') THEN

			SELECT sn.id INTO currentId from sys_quartz_log AS sn order by sn.ID DESC limit 1;

			UPDATE sequence  

			 SET current_value = currentId WHERE name = seq_name; 

		ELSEIF(seq_name = 'sys_quartz_run_job') THEN

			SELECT sn.id INTO currentId from sys_quartz_run_job AS sn order by sn.ID DESC limit 1;

			UPDATE sequence  

			 SET current_value = currentId WHERE name = seq_name;

		ELSEIF(seq_name = 'sys_quartz_trigger') THEN

			SELECT sn.id INTO currentId from sys_quartz_trigger AS sn order by sn.ID DESC limit 1;

			UPDATE sequence  

			 SET current_value = currentId WHERE name = seq_name; 

		ELSEIF(seq_name = 'sys_quartz_schedule') THEN

			SELECT sn.id INTO currentId from sys_quartz_schedule AS sn order by sn.ID DESC limit 1;

			UPDATE sequence  

			 SET current_value = currentId WHERE name = seq_name;

		ELSEIF(seq_name = 'sys_sql_log') THEN

			SELECT sn.id INTO currentId from sys_sql_log AS sn order by sn.ID DESC limit 1;

			UPDATE sequence  

			 SET current_value = currentId WHERE name = seq_name;

		ELSEIF(seq_name = 'sys_user') THEN

			SELECT sn.id INTO currentId from sys_user AS sn order by sn.ID DESC limit 1;

			UPDATE sequence  

			 SET current_value = currentId WHERE name = seq_name; 	

		END IF;



		

		RETURN getCurrentId(seq_name); 

END

;;

delimiter ;



SET FOREIGN_KEY_CHECKS = 1;
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/yinglonglll/java_standard_database.git
git@gitee.com:yinglonglll/java_standard_database.git
yinglonglll
java_standard_database
java_standard_database
master
点此查找更多帮助

搜索帮助

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