3668MySQL数据库应用试题_sql脚本导入错误，数据库版本 5.7与8.0.22均已经尝试，mysql8的规则字符集改成9000也报错。...


这是2jeecgboot_mysql5.7.sql 文件中的注释导致的报错。



错误日志：

[SQL] Query jeecg-boot1217 start

[ERR] 1253 - COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4'

[ERR]

INSERT INTO `act_hi_varinst` VALUES ('45edd44b-2ee3-11eb-b0d6-80e82cf8a55b', '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', '45edad2b-2ee3-11eb-b0d6-80e82cf8a55b', '45edad2e-2ee3-11eb-b0d6-80e82cf8a55b', 'dept_1606283413037', 'string', 0, NULL, NULL, NULL, 'A02', NULL, '2020-11-25 13:58:43.060', '2020-11-25 13:58:43.060');

INSERT INTO `act_hi_varinst` VALUES ('45edd44d-2ee3-11eb-b0d6-80e82cf8a55b', '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', '45edad2b-2ee3-11eb-b0d6-80e82cf8a55b', '45edad2e-2ee3-11eb-b0d6-80e82cf8a55b', 'radio_1606283394658', 'string', 0, NULL, NULL, NULL, '2', NULL, '2020-11-25 13:58:43.060', '2020-11-25 13:58:43.060');

INSERT INTO `act_hi_varinst` VALUES ('4e8169b3-2ee3-11eb-b0d6-80e82cf8a55b', '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', '45edad2b-2ee3-11eb-b0d6-80e82cf8a55b', '4e8169b2-2ee3-11eb-b0d6-80e82cf8a55b', 'rate_1606283386226', 'integer', 0, NULL, NULL, 3, '3', NULL, '2020-11-25 13:58:57.449', '2020-11-25 13:58:57.449');

INSERT INTO `act_hi_varinst` VALUES ('4e8169b5-2ee3-11eb-b0d6-80e82cf8a55b', '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', '45edad2b-2ee3-11eb-b0d6-80e82cf8a55b', '4e8169b2-2ee3-11eb-b0d6-80e82cf8a55b', 'input_1606283379486', 'string', 0, NULL, NULL, NULL, '111', NULL, '2020-11-25 13:58:57.449', '2020-11-25 13:58:57.449');

INSERT INTO `act_hi_varinst` VALUES ('4e8169b7-2ee3-11eb-b0d6-80e82cf8a55b', '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', '45edad2b-2ee3-11eb-b0d6-80e82cf8a55b', '4e8169b2-2ee3-11eb-b0d6-80e82cf8a55b', 'textarea_1606283399642', 'string', 0, NULL, NULL, NULL, '111', NULL, '2020-11-25 13:58:57.449', '2020-11-25 13:58:57.449');

INSERT INTO `act_hi_varinst` VALUES ('4e8169b9-2ee3-11eb-b0d6-80e82cf8a55b', '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', '45edad2b-2ee3-11eb-b0d6-80e82cf8a55b', '4e8169b2-2ee3-11eb-b0d6-80e82cf8a55b', 'date_1606283495545', 'string', 0, NULL, NULL, NULL, '2020-11-04', NULL, '2020-11-25 13:58:57.449', '2020-11-25 13:58:57.449');

INSERT INTO `act_hi_varinst` VALUES ('4e8169bb-2ee3-11eb-b0d6-80e82cf8a55b', '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', '45edad2b-2ee3-11eb-b0d6-80e82cf8a55b', '4e8169b2-2ee3-11eb-b0d6-80e82cf8a55b', 'user_1606283409602', 'string', 0, NULL, NULL, NULL, 'admin', NULL, '2020-11-25 13:58:57.449', '2020-11-25 13:58:57.449');

INSERT INTO `act_hi_varinst` VALUES ('4e8169bd-2ee3-11eb-b0d6-80e82cf8a55b', '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', '45edad2b-2ee3-11eb-b0d6-80e82cf8a55b', '4e8169b2-2ee3-11eb-b0d6-80e82cf8a55b', 'input_1606283360729', 'string', 0, NULL, NULL, NULL, '111', NULL, '2020-11-25 13:58:57.449', '2020-11-25 13:58:57.449');

INSERT INTO `act_hi_varinst` VALUES ('4e8169bf-2ee3-11eb-b0d6-80e82cf8a55b', '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', '45edad2b-2ee3-11eb-b0d6-80e82cf8a55b', '4e8169b2-2ee3-11eb-b0d6-80e82cf8a55b', 'dept_1606283413037', 'string', 0, NULL, NULL, NULL, 'A02', NULL, '2020-11-25 13:58:57.449', '2020-11-25 13:58:57.449');

INSERT INTO `act_hi_varinst` VALUES ('4e8169c1-2ee3-11eb-b0d6-80e82cf8a55b', '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', '45edad2b-2ee3-11eb-b0d6-80e82cf8a55b', '4e8169b2-2ee3-11eb-b0d6-80e82cf8a55b', 'radio_1606283394658', 'string', 0, NULL, NULL, NULL, '2', NULL, '2020-11-25 13:58:57.449', '2020-11-25 13:58:57.449');

INSERT INTO `act_hi_varinst` VALUES ('fc8604e4-2ee2-11eb-b0d6-80e82cf8a55b', 'fc8568a3-2ee2-11eb-b0d6-80e82cf8a55b', 'fc8568a3-2ee2-11eb-b0d6-80e82cf8a55b', NULL, 'rate_1606283386226', 'integer', 0, NULL, NULL, 3, '3', NULL, '2020-11-25 13:56:39.906', '2020-11-25 13:56:39.906');

INSERT INTO `act_hi_varinst` VALUES ('fc865306-2ee2-11eb-b0d6-80e82cf8a55b', 'fc8568a3-2ee2-11eb-b0d6-80e82cf8a55b', 'fc8568a3-2ee2-11eb-b0d6-80e82cf8a55b', NULL, 'input_1606283379486', 'string', 0, NULL, NULL, NULL, '111', NULL, '2020-11-25 13:56:39.908', '2020-11-25 13:56:39.908');

INSERT INTO `act_hi_varinst` VALUES ('fc865308-2ee2-11eb-b0d6-80e82cf8a55b', 'fc8568a3-2ee2-11eb-b0d6-80e82cf8a55b', 'fc8568a3-2ee2-11eb-b0d6-80e82cf8a55b', NULL, 'textarea_1606283399642', 'string', 0, NULL, NULL, NULL, '111', NULL, '2020-11-25 13:56:39.908', '2020-11-25 13:56:39.908');

INSERT INTO `act_hi_varinst` VALUES ('fc867a1a-

[ERR] 1146 - Table 'jeecg-boot.act_ru_execution' doesn't exist

[ERR]

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

-- Records of act_ru_execution

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

INSERT INTO `act_ru_execution` VALUES ('45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', 1, '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', '1331476856589434882', NULL, 'test3:1:58c739ee-2ee2-11eb-b0d6-80e82cf8a55b', NULL, '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', NULL, 1, 0, 1, 0, 0, 1, NULL, '', NULL, '2020-11-25 13:58:43.058', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO `act_ru_execution` VALUES ('45edad2b-2ee3-11eb-b0d6-80e82cf8a55b', 2, '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', NULL, '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', 'test3:1:58c739ee-2ee2-11eb-b0d6-80e82cf8a55b', NULL, '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', 'Activity_02z1wus', 1, 0, 0, 0, 0, 1, NULL, '', NULL, '2020-11-25 13:58:43.059', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

-- Table structure for act_ru_identitylink

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

DROP TABLE IF EXISTS `act_ru_identitylink`;

CREATE TABLE `act_ru_identitylink` (

`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

`REV_` int(0) NULL DEFAULT NULL,

`GROUP_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

`TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

`USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

`PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

PRIMARY KEY (`ID_`) USING BTREE,

INDEX `ACT_IDX_IDENT_LNK_USER`(`USER_ID_`) USING BTREE,

INDEX `ACT_IDX_IDENT_LNK_GROUP`(`GROUP_ID_`) USING BTREE,

INDEX `ACT_IDX_ATHRZ_PROCEDEF`(`PROC_DEF_ID_`) USING BTREE,

INDEX `ACT_FK_TSKASS_TASK`(`TASK_ID_`) USING BTREE,

INDEX `ACT_FK_IDL_PROCINST`(`PROC_INST_ID_`) USING BTREE,

CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,

CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,

CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

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

-- Records of act_ru_identitylink

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

INSERT INTO `act_ru_identitylink` VALUES ('45edd44f-2ee3-11eb-b0d6-80e82cf8a55b', 1, NULL, 'participant', 'admin', NULL, '45ed860a-2ee3-11eb-b0d6-80e82cf8a55b', NULL);

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

-- Table structure for act_ru_integration

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

DROP TABLE IF EXISTS `act_ru_integration`;

CREATE TABLE `act_ru_integration` (

`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

`EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

`PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

`PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

`FLOW_NODE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,

`CREATED_DATE_` timestamp(3) NULL DEFAULT NULL,

PRIMARY KEY (`ID_`) USING BTREE,

INDEX `ACT_FK_INT_EXECUTION`(`EXECUTION_ID_`) USING BTREE,

INDEX `ACT_FK_INT_PROC_INST`(`PROCESS_INSTANCE_ID_`) USING BTREE,

INDEX `ACT_FK_INT_PROC_DEF`(`PROC_DEF_ID_`) USING BTREE,

CONSTRAINT `ACT_FK_INT_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE RESTRICT,

CONSTRAINT `ACT_FK_INT_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT,

CONSTRAINT `ACT_FK_INT_PROC_INST` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- --

[ERR] 1136 - Column count doesn't match value count at row 1

[ERR]

INSERT INTO `onl_cgform_field` VALUES ('68c12a37105b7a41ca1dc7b74ef707ac', '8bf8e7af3ea84faeb40c307b31b5e60b', 'sys_org_code', '所属部门', NULL, 0, 1, 'string', 64, 0, '', '', '', '', 'text', '', 120, NULL, '0', '', '', 0, 0, 0, 0, 'single', '', '', 6, 'admin', '2020-11-25 16:40:52', '2020-11-20 10:55:04', 'admin', '', '', '', '', '', NULL, '0', NULL, NULL, '0', NULL);

INSERT INTO `onl_cgform_field` VALUES ('6b694b14e80a325a5406c4c4aab5dbf3', '9e13bcda86554a199635c356ee25eb9d', 'create_time', '创建日期', NULL, 0, 1, 'Date', 20, 0, '', '', '', '', 'datetime', '', 120, NULL, '0', '', '', 0, 0, 0, 0, 'single', '', '', 3, 'admin', '2020-11-20 10:33:02', '2020-11-20 10:27:20', 'admin', '', '', '', '', '', NULL, '0', NULL, NULL, '0', NULL);

INSERT INTO `onl_cgform_field` VALUES ('6d3d693ecd5add86dff3cfbb1c9453b5', '9e13bcda86554a199635c356ee25eb9d', 'create_by', '创建人', NULL, 0, 1, 'string', 50, 0, '', '', '', '', 'text', '', 120, NULL, '0', '', '', 0, 0, 0, 0, 'single', '', '', 2, 'admin', '2020-11-20 10:33:02', '2020-11-20 10:27:20', 'admin', '', '', '', '', '', NULL, '0', NULL, NULL, '0', NULL);

INSERT INTO `onl_cgform_field` VALUES ('72a0924133b47f9aeb2b55d0316ba9f9', '10a72eb12f1940cc8311a2cb74f54fac', 'create_by', '创建人', NULL, 0, 1, 'string', 50, 0, '', '', '', '', 'text', '', 120, NULL, '0', '', '', 0, 0, 0, 0, 'single', '', '', 7, 'admin', '2020-11-25 11:14:22', '2020-11-20 16:49:33', 'admin', '', '', '', '', '', 'text', '0', NULL, NULL, '0', NULL);

INSERT INTO `onl_cgform_field` VALUES ('73f608af9de2badc8ff7b6e6cd70c72f', '8bf8e7af3ea84faeb40c307b31b5e60b', 'room_tel', '电话', NULL, 0, 1, 'string', 32, 0, '', '', '', '', 'text', '', 120, NULL, '0', '', '', 0, 1, 1, 0, 'single', '', '', 10, 'admin', '2020-11-25 16:40:52', '2020-11-20 10:55:04', 'admin', '', '', '', '', '', 'text', '0', NULL, NULL, '0', NULL);

INSERT INTO `onl_cgform_field` VALUES ('765dccf2d24c35d008b837abaa811a1f', '10a72eb12f1940cc8311a2cb74f54fac', 'update_by', '更新人', NULL, 0, 1, 'string', 50, 0, '', '', '', '', 'text', '', 120, NULL, '0', '', '', 0, 0, 0, 0, 'single', '', '', 2, 'admin', '2020-11-25 11:14:22', '2020-11-20 16:49:33', 'admin', '', '', '', '', '', NULL, '0', NULL, NULL, '0', NULL);

INSERT INTO `onl_cgform_field` VALUES ('76b806f582d887c593fbcff77a6d231d', '820de00176b44ed4991f5c895b6bdbfc', 'update_time', '更新日期', NULL, 0, 1, 'Date', 20, 0, '', '', '', '', 'datetime', '', 120, NULL, '0', '', '', 0, 0, 0, 0, 'single', '', '', 5, 'admin', '2020-11-20 10:39:45', '2020-11-20 10:38:03', 'admin', '', '', '', '', '', NULL, '0', NULL, NULL, '0', NULL);

INSERT INTO `onl_cgform_field` VALUES ('7815ebd4fb3ffa8610bf5921bbd2fffe', 'fa52072233754725983253b2d79c317c', 'update_time', '更新日期', NULL, 0, 1, 'Date', 20, 0, '', '', '', '', 'datetime', '', 120, NULL, '0', '', '', 0, 0, 0, 0, 'single', '', '', 5, 'admin', '2020-11-25 16:30:27', '2020-11-25 16:20:39', 'admin', '', '', '', '', '', NULL, '0', NULL, NULL, '0', NULL);

INSERT INTO `onl_cgform_field` VALUES ('78456e35b4c2987608ac7024b6be3668', '9e13bcda86554a199635c356ee25eb9d', 'building_status', '是否可用', NULL, 0, 1, 'string', 32, 0, 'Y', '', '', '', 'switch', '', 120, NULL, '0', '', 'Y', 1, 1, 1, 0, 'single', '', '', 12, 'admin', '2020-11-20 10:33:02', '2020-11-20 10:27:20', 'admin', '', '', '', '', '', 'text', '0', NULL, NULL, '1', NULL);

INSERT INTO `onl_cgform_field` VALUES ('7b0de0f188a9edf9e24f5ac387cd7149', '24c895c2d2e84cbe891b4f7a802fb91a', 'id', '主键', NULL, 1, 0, 'string', 36, 0, '', '', '', '', 'text', '', 120, NULL, '0', '', '', 0, 0, 0, 1, 'single', '', '', 1, 'admin', '2020-11-20 11:13:34', '2020-11-20 11:03:21', 'admin', '', '', '', '', '', NULL, '0', NULL, NULL, '0', NULL);

INSERT INTO `onl_cgform_field` VALUES ('831c0749d0fdbc993aeaeecaeca9c873', '9da3ddf4191f4db9b17c086a944d9f6f', 'create_time', '创建日期', NULL, 0, 1, 'Date', 20, 0, '', '', '', '', 'datetime', '', 120, NULL, '0', '', '', 0, 0, 0, 0, 'single', '', '', 3, 'admin', '2020-11-20 10:33:25', '2020-11-20 09:53:58', 'admin', '', '', '', '', '', NULL, '0', NULL, NULL, '0', NULL);

INSERT INTO `onl_cgform_field` VALUES ('854415d22979

[ERR] 1062 - Duplicate entry '67fc001af12a4f9b8458005d3f19934a' for key 'sys_depart.PRIMARY'

[ERR]

INSERT INTO `sys_depart` VALUES ('67fc001af12a4f9b8458005d3f19934a', 'c6d7cb4deeac411cb3384b1b31278596', '财务部', NULL, NULL, 0, NULL, '1', '2', 'A01A04', NULL, NULL, NULL, NULL, NULL, '0', 'admin', '2019-02-21 16:14:35', 'admin', '2019-02-25 12:49:41');

INSERT INTO `sys_depart` VALUES ('6d35e179cd814e3299bd588ea7daed3f', '', 'foxconn', NULL, NULL, 0, NULL, '1', '1', 'A02', '', NULL, '', '', NULL, '0', 'admin', '2019-02-26 16:36:39', 'admin', '2020-11-25 16:03:13');

INSERT INTO `sys_depart` VALUES ('743ba9dbdc114af8953a11022ef3096a', 'f28c6f53abd841ac87ead43afc483433', '财务部', NULL, NULL, 0, NULL, '1', '2', 'A03A01', NULL, NULL, NULL, NULL, NULL, '0', 'admin', '2019-03-22 16:45:43', NULL, NULL);

INSERT INTO `sys_depart` VALUES ('a7d7e77e06c84325a40932163adcdaa6', '6d35e179cd814e3299bd588ea7daed3f', '财务部', NULL, NULL, 0, NULL, '1', '2', 'A02A01', NULL, NULL, NULL, NULL, NULL, '0', 'admin', '2019-02-26 16:36:47', 'admin', '2019-02-26 16:37:25');

INSERT INTO `sys_depart` VALUES ('c6d7cb4deeac411cb3384b1b31278596', '', '富士康', NULL, NULL, 0, NULL, '1', '1', 'A01', '', NULL, '', '', NULL, '0', 'admin', '2019-02-11 14:21:51', 'admin', '2020-11-25 16:03:25');

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

-- Table structure for sys_depart_permission

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

DROP TABLE IF EXISTS `sys_depart_permission`;

CREATE TABLE `sys_depart_permission` (

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

`depart_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门id',

`permission_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限id',

`data_rule_ids` varchar(1000) 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 COMMENT = '部门权限表' ROW_FORMAT = Compact;

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

-- Table structure for sys_depart_role

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

DROP TABLE IF EXISTS `sys_depart_role`;

CREATE TABLE `sys_depart_role` (

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

`depart_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门id',

`role_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门角色名称',

`role_code` varchar(100) 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 '描述',

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

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

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

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

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门角色表' ROW_FORMAT = Compact;

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

-- Table structure for sys_depart_role_permission

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

DROP TABLE IF EXISTS `sys_depart_role_permission`;

CREATE TABLE `sys_depart_role_permission` (

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

`depart_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门id',

`role_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色id',

`permission_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限id',

`data_rule_ids` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据权限ids',

`operate_date` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',

`operate_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作ip',

PRIMARY KEY (`id`) USING BTREE,

INDEX `index_group_role_per_id`(`role_id`, `permission_id`) USING BTREE,

INDEX `index_group_role_id`(`role_id`) USING BTREE,

INDEX `index_group_per

[ERR] 1062 - Duplicate entry 'b09ccd219a1ce5c7270bb659748b8330' for key 'sys_log.PRIMARY'

[ERR]

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

-- Records of sys_log

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

INSERT INTO `sys_log` VALUES ('b09ccd219a1ce5c7270bb659748b8330', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-01-19 15:34:38', NULL, NULL);

INSERT INTO `sys_log` VALUES ('a22ddd4b5b0b84bd7794edd24b25fc64', 2, '添加测试DEMO', NULL, 'admin', '管理员', '127.0.0.1', 'org.jeecg.modules.demo.test.controller.JeecgDemoController.add()', NULL, '[{\"createBy\":\"admin\",\"createTime\":1547883299809,\"email\":\"zhangdaiscott@163.com\",\"id\":\"7eac655877842eb39dc2f0469f3964ec\",\"name\":\"zhang daihao\"}]', NULL, 25, 'admin', '2019-01-19 15:34:59', NULL, NULL);

INSERT INTO `sys_log` VALUES ('07a0b3f8b4140a7a586305c2f40a2310', 2, '删除测试DEMO', NULL, 'admin', '管理员', '127.0.0.1', 'org.jeecg.modules.demo.test.controller.JeecgDemoController.delete()', NULL, '[\"7eac655877842eb39dc2f0469f3964ec\"]', NULL, 14, 'admin', '2019-01-19 15:38:11', NULL, NULL);

INSERT INTO `sys_log` VALUES ('d7902eeab2c34611fad046a79bff1c1b', 2, '添加测试DEMO', NULL, 'admin', '管理员', '127.0.0.1', 'org.jeecg.modules.demo.test.controller.JeecgDemoController.add()', NULL, '[{\"createBy\":\"admin\",\"createTime\":1547883544104,\"email\":\"zhangdaiscott@163.com\",\"id\":\"4436302a0de50bb83025286bc414d6a9\",\"name\":\"zhang daihao\"}]', NULL, 1682, 'admin', '2019-01-19 15:39:05', NULL, NULL);

INSERT INTO `sys_log` VALUES ('a68160f37cace166fedd299c4ca0be10', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-01-19 15:40:00', NULL, NULL);

INSERT INTO `sys_log` VALUES ('c6c0316b6989bf1eea0a3803f593bf69', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-01-19 15:47:19', NULL, NULL);

INSERT INTO `sys_log` VALUES ('4b1341863a8fffeccda8bbe413bd815f', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-01-19 15:59:52', NULL, NULL);

INSERT INTO `sys_log` VALUES ('ed50b1fbc80c3b953f4551081b10335e', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-01-19 16:19:06', NULL, NULL);

INSERT INTO `sys_log` VALUES ('dabdcb8e15ea9215a1af22f7567ff73d', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-01-19 16:48:13', NULL, NULL);

INSERT INTO `sys_log` VALUES ('446724ea6dd41f4a03111c42e00d80cd', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-01-19 16:56:36', NULL, NULL);

INSERT INTO `sys_log` VALUES ('0e41fe3a34d5715bf4c88e220663583a', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-01-19 17:04:06', NULL, NULL);

INSERT INTO `sys_log` VALUES ('9f2db1ffaf89518a25cc6701da0c5858', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-01-19 17:05:07', NULL, NULL);

INSERT INTO `sys_log` VALUES ('954f1ccb8b230d2d7d4858eec3aba0a4', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-01-19 17:08:37', NULL, NULL);

INSERT INTO `sys_log` VALUES ('7374f3a2ccb20216cf8eecb26037ce0a', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-01-19 18:08:51', NULL, NULL);

INSERT INTO `sys_log` VALUES ('130de55edac71aab730786307cc65936', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-01-19 20:22:57', NULL, NULL);

INSERT INTO `sys_log` VALUES ('0bc44e2d682c9f28525d203589a90b43', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-01-19 20:31:08', NULL, NULL);

INSERT INTO `sys_log` VALUES ('122edcafd54dd06e12838f41123d9d5d', 2, '添加测试DEMO', NULL, 'admin', '管理员', '127.0.0.1', 'org.jeecg.modules.demo.test.controller.JeecgDemoController.add()', NULL, '[{\"age\":28,\"birthday\":1546617600000,\"createBy\":\"admin\",\"createTime\":1547901234989,\"id\":

[ERR] 1062 - Duplicate entry 'b3127e34f395e1f1790450da5689a4a1' for key 'sys_log.PRIMARY'

[ERR]

INSERT INTO `sys_log` VALUES ('b3127e34f395e1f1790450da5689a4a1', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-25 16:28:35', NULL, NULL);

INSERT INTO `sys_log` VALUES ('fb2871cda1421b766f8e68cb36a22bf3', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-25 17:35:01', NULL, NULL);

INSERT INTO `sys_log` VALUES ('29fb5d4297748af3cd1c7f2611b7a2d6', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-25 17:38:05', NULL, NULL);

INSERT INTO `sys_log` VALUES ('580256f7c7ea658786dba919009451b6', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-25 17:39:43', NULL, NULL);

INSERT INTO `sys_log` VALUES ('8802209912ca66d56f2ea241ffd0cc13', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-25 17:52:34', NULL, NULL);

INSERT INTO `sys_log` VALUES ('4778fe2992fd5efd65f86cb0e00e338e', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-25 17:53:11', NULL, NULL);

INSERT INTO `sys_log` VALUES ('d68957c067fb27e80a23babebdb1591f', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-25 17:55:06', NULL, NULL);

INSERT INTO `sys_log` VALUES ('472c34745b8f86a46efa28f408465a63', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-25 17:56:31', NULL, NULL);

INSERT INTO `sys_log` VALUES ('26975f09c66025d1c8d87a6894a3c262', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-25 18:29:08', NULL, NULL);

INSERT INTO `sys_log` VALUES ('e4a166fcd0fc4037cb26e35cc1fb87b2', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-25 18:32:41', NULL, NULL);

INSERT INTO `sys_log` VALUES ('286af82485388bfcd3bb9821ff1a4727', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-25 18:34:37', NULL, NULL);

INSERT INTO `sys_log` VALUES ('eaf74cd1489b02d39c470eed131fc918', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-25 18:37:39', NULL, NULL);

INSERT INTO `sys_log` VALUES ('e48a6bd82c92a8005c80c5ef36746117', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-25 19:32:26', NULL, NULL);

INSERT INTO `sys_log` VALUES ('10922e0d030960e6b026c67c6179247b', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-25 20:07:59', NULL, NULL);

INSERT INTO `sys_log` VALUES ('b53c9e8ce1e129a09a3cda8c01fe644c', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-26 11:38:49', NULL, NULL);

INSERT INTO `sys_log` VALUES ('65be8e015c9f2c493bd0a4e405dd8221', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-26 11:40:20', NULL, NULL);

INSERT INTO `sys_log` VALUES ('8ff27392165c8c707ee10ec0010c7bb8', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-26 11:44:07', NULL, NULL);

INSERT INTO `sys_log` VALUES ('337b647a4085e48f61c7832e6527517d', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-26 11:45:16', NULL, NULL);

INSERT INTO `sys_log` VALUES ('caee69e55ec929f7ba904280cac971e6', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-26 11:49:15', NULL, NULL);

INSERT INTO `sys_log` VALUES ('bdeae62057ae9858b6a546c1bdb6efc7', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-02-26 11:49:29', NULL, NULL);

INSERT INTO `sys_log` VALUES ('ea66ed22fde49640cee5d73c6ef69718', 1, '用户名: admin,登录成功！',

[ERR] 1062 - Duplicate entry '611fa74c70bd5a7a8af376464a2133e8' for key 'sys_log.PRIMARY'

[ERR]

INSERT INTO `sys_log` VALUES ('611fa74c70bd5a7a8af376464a2133e8', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-27 17:48:13', NULL, NULL);

INSERT INTO `sys_log` VALUES ('90555a39c0b02180df74752e4d33f253', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-27 18:26:25', NULL, NULL);

INSERT INTO `sys_log` VALUES ('217aa2f713b0903e6be699136e374012', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-27 20:07:32', NULL, NULL);

INSERT INTO `sys_log` VALUES ('5554869b3475770046602061775e0e57', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-28 14:38:05', NULL, NULL);

INSERT INTO `sys_log` VALUES ('bfec8c8c88868391041667d924e3af7f', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-28 14:38:27', NULL, NULL);

INSERT INTO `sys_log` VALUES ('675153568c479d8b7c6fe63327066c9f', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-28 15:29:42', NULL, NULL);

INSERT INTO `sys_log` VALUES ('4930e32672465979adbc592e116226a6', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-28 16:53:28', NULL, NULL);

INSERT INTO `sys_log` VALUES ('9a1456ef58a2b1fb63cdc54b723f2539', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-28 17:26:39', NULL, NULL);

INSERT INTO `sys_log` VALUES ('484cdb8db40e3f76ef686552f57d8099', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-28 18:14:49', NULL, NULL);

INSERT INTO `sys_log` VALUES ('02d4447c9d97ac4fc1c3a9a4c789c2a8', 1, '用户名: 管理员,退出成功！', NULL, 'admin', '管理员', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'admin', '2019-03-28 18:24:18', NULL, NULL);

INSERT INTO `sys_log` VALUES ('59558082e1b1d754fa3def125ed4db3c', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-28 18:24:19', NULL, NULL);

INSERT INTO `sys_log` VALUES ('c434dc5172dc993ee7cd96187ca58653', 1, '用户名: 管理员,退出成功！', NULL, 'admin', '管理员', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'admin', '2019-03-28 19:46:08', NULL, NULL);

INSERT INTO `sys_log` VALUES ('a6261bbbf8e964324935722ea1384a5d', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-28 19:46:27', NULL, NULL);

INSERT INTO `sys_log` VALUES ('f0748a25728348591c7b73a66f273457', 1, '用户名: 管理员,退出成功！', NULL, 'admin', '管理员', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'admin', '2019-03-28 19:46:27', NULL, NULL);

INSERT INTO `sys_log` VALUES ('14f447d9b60725cc86b3100a5cb20b75', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-28 19:46:30', NULL, NULL);

INSERT INTO `sys_log` VALUES ('7c88e9cf6018a1b97b420b8cb6122815', 1, '用户名: 管理员,退出成功！', NULL, 'admin', '管理员', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'admin', '2019-03-28 19:46:30', NULL, NULL);

INSERT INTO `sys_log` VALUES ('cb7c6178101ef049d3f1820ee41df539', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-28 19:59:19', NULL, NULL);

INSERT INTO `sys_log` VALUES ('21fed0f2d080e04cf0901436721a77a6', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-28 21:53:31', NULL, NULL);

INSERT INTO `sys_log` VALUES ('4ba055970859a6f1afcc01227cb82a2d', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-29 09:43:56', NULL, NULL);

INSERT INTO `sys_log` VALUES ('3ba1e54aa9aa760b59dfe1d1259459bc', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, 'jeecg-boot', '2019-03-29 09:44:07', NULL, NULL);

INSERT INTO `sys_log` VALUES ('7b44138c1b80b67da13b89db756a22b0', 2, '添加测试DEMO', NULL, NULL, NULL, '1

[ERR] 1062 - Duplicate entry '1231615277050998786' for key 'sys_log.PRIMARY'

[ERR]

INSERT INTO `sys_log` VALUES ('1231615277050998786', 1, '用户名: 管理员,退出成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-02-24 00:22:19', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1231615300820119553', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-02-24 00:22:25', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252829159877619713', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 13:18:42', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252829182954680322', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 13:18:48', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252840866976931842', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 14:05:13', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252866252326637570', 1, '用户名: 管理员,退出成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 15:46:06', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252866408107282433', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 15:46:43', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252866693185736706', 1, '用户名: 管理员,退出成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 15:47:51', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252866809623810049', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 15:48:19', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252866902947074049', 1, '用户名: 管理员,退出成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 15:48:41', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252867119947780097', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 15:49:33', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252867158422130690', 1, '用户名: 管理员,退出成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 15:49:42', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252868518089658370', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 15:55:06', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252868556564008962', 1, '用户名: 管理员,退出成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 15:55:15', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252869032655261697', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 15:57:09', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252869073868492801', 1, '用户名: 管理员,退出成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 15:57:19', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252870975398154242', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 16:04:52', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252871013855727617', 1, '用户名: 管理员,退出成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 16:05:01', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252871520036917249', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 16:07:02', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252871619295121409', 1, '用户名: 管理员,退出成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 16:07:25', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252871663926710274', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 16:07:36', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252871702258454529', 1, '用户名: 管理员,退出成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 16:07:45', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1252872496558968833', 1, '用户名: admin,登录成功！', NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-22 16:10:54', NULL,

[ERR] 1253 - COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4'

[ERR]

INSERT INTO `sys_log` VALUES ('1331432946668322818', 2, '职务表-分页列表查询', 1, 'admin', '管理员', '10.251.210.116', 'org.jeecg.modules.system.controller.SysPositionController.queryPageList()', NULL, ' sysPosition: SysPosition(id=null, code=null, name=null, postRank=null, companyId=null, createBy=null, createTime=null, updateBy=null, updateTime=null, sysOrgCode=null) pageNo: 1 pageSize: 10 req: org.apache.shiro.web.servlet.ShiroHttpServletRequest@730ebd76', NULL, 11, NULL, '2020-11-25 11:02:06', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1331432970164813826', 2, '职务表-分页列表查询', 1, 'admin', '管理员', '10.251.210.116', 'org.jeecg.modules.system.controller.SysPositionController.queryPageList()', NULL, ' sysPosition: SysPosition(id=null, code=null, name=null, postRank=null, companyId=null, createBy=null, createTime=null, updateBy=null, updateTime=null, sysOrgCode=null) pageNo: 1 pageSize: 99999 req: org.apache.shiro.web.servlet.ShiroHttpServletRequest@4075385c', NULL, 22, NULL, '2020-11-25 11:02:12', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1331434450632491010', 2, '职务表-分页列表查询', 1, 'admin', '管理员', '10.251.210.116', 'org.jeecg.modules.system.controller.SysPositionController.queryPageList()', NULL, ' sysPosition: SysPosition(id=null, code=null, name=null, postRank=null, companyId=null, createBy=null, createTime=null, updateBy=null, updateTime=null, sysOrgCode=null) pageNo: 1 pageSize: 10 req: org.apache.shiro.web.servlet.ShiroHttpServletRequest@404ddb05', NULL, 16, NULL, '2020-11-25 11:08:05', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1331434455686627329', 2, '职务表-分页列表查询', 1, 'admin', '管理员', '10.251.210.116', 'org.jeecg.modules.system.controller.SysPositionController.queryPageList()', NULL, ' sysPosition: SysPosition(id=null, code=null, name=null, postRank=null, companyId=null, createBy=null, createTime=null, updateBy=null, updateTime=null, sysOrgCode=null) pageNo: 1 pageSize: 99999 req: org.apache.shiro.web.servlet.ShiroHttpServletRequest@5d3e29a1', NULL, 13, NULL, '2020-11-25 11:08:06', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1331473884023275522', 1, '用户名: admin,登录成功！', NULL, 'admin', '管理员', '10.251.210.116', NULL, NULL, NULL, NULL, NULL, NULL, '2020-11-25 13:44:46', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1331474989679558657', 2, '表单配置-列表查询', 1, 'admin', '管理员', '10.251.210.116', 'org.jeecg.modules.online.cgreport.controller.FormHeadConfigurationController.queryList()', NULL, ' tableTypes: 1,2 req: org.apache.shiro.web.servlet.ShiroHttpServletRequest@1dd5f83e', NULL, 33, NULL, '2020-11-25 13:49:10', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1331475696566583297', 2, '表单配置-列表查询', 1, 'admin', '管理员', '10.251.210.116', 'org.jeecg.modules.online.cgreport.controller.FormHeadConfigurationController.queryList()', NULL, ' tableTypes: 1,2 req: org.apache.shiro.web.servlet.ShiroHttpServletRequest@7d6ae999', NULL, 8, NULL, '2020-11-25 13:51:58', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1331476142794391554', 2, '表单配置-列表查询', 1, 'admin', '管理员', '10.251.210.116', 'org.jeecg.modules.online.cgreport.controller.FormHeadConfigurationController.queryList()', NULL, ' tableTypes: 1,2 req: org.apache.shiro.web.servlet.ShiroHttpServletRequest@3fe227ae', NULL, 15, NULL, '2020-11-25 13:53:45', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1331477125108776962', 2, '图表组合配置-分页列表查询', 1, 'admin', '管理员', '10.251.210.116', 'org.jeecg.modules.online.cgreport.controller.DiagramCombinationController.queryPageList()', NULL, ' diagramCombination: DiagramCombination(templetName=null, templetCode=null, templetStyle=null, diagramCombinationDetails=null, diagramCombinationQueryConfigs=null) pageNo: 1 pageSize: 10 req: org.apache.shiro.web.servlet.ShiroHttpServletRequest@2111fb59', NULL, 14, NULL, '2020-11-25 13:57:39', NULL, NULL);

INSERT INTO `sys_log` VALUES ('1331477350158352385', 2, '图表组合配置-分页列表查询', 1, 'admin', '管理员', '10.251.210.116', 'org.jeecg.modules.online.cgreport.controller.DiagramCombinationController.queryPageList()', NULL, ' diagramCombination: DiagramCombination(templetName=null, templetCode=null, templetStyle=null, d

[ERR] 1062 - Duplicate entry '13212d3416eb690c2e1d5033166ff47a' for key 'sys_permission.PRIMARY'

[ERR]

INSERT INTO `sys_permission` VALUES ('1290916619055529985', '1289833000278949889', '我发起流程', '/task/MyApplyProcessList', 'modules/task/MyApplyProcessList', NULL, NULL, 1, NULL, '1', 2.00, 0, NULL, 1, 1, 0, 0, NULL, 'admin', '2020-08-05 15:44:40', NULL, NULL, 0, 0, '1', 0);

INSERT INTO `sys_permission` VALUES ('1290930283531730946', '1289833000278949889', '我的抄送', '/task/MyCcHisProcessList', 'modules/task/MyCcHisProcessList', NULL, NULL, 1, NULL, '1', 2.00, 0, NULL, 1, 1, 0, 0, NULL, 'admin', '2020-08-05 16:38:58', NULL, NULL, 0, 0, '1', 0);

INSERT INTO `sys_permission` VALUES ('1320994615364444162', 'e41b69c57a941a3bbcce45032fe57605', 'Online看板配置', '/databoard/list', 'vue-grid-layout/LayoutList', NULL, NULL, 1, NULL, '1', 5.00, 0, NULL, 1, 1, 0, 0, NULL, 'admin', '2020-10-27 15:43:54', 'admin', '2020-11-07 22:36:39', 0, 0, '1', 0);

INSERT INTO `sys_permission` VALUES ('1320994855421239298', 'e41b69c57a941a3bbcce45032fe57605', '看板展示', '/databoard/list/:code', 'vue-grid-layout/Layout', NULL, NULL, 1, NULL, '1', 99.00, 0, 'area-chart', 1, 1, 0, 1, NULL, 'admin', '2020-10-27 15:44:51', 'admin', '2020-11-07 22:38:33', 0, 0, '1', 0);

INSERT INTO `sys_permission` VALUES ('13212d3416eb690c2e1d5033166ff47a', '2e42e3835c2b44ec9f7bc26c146ee531', '失败', '/result/fail', 'result/Error', NULL, NULL, 1, NULL, NULL, 2.00, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, '2018-12-25 20:34:38', NULL, NULL, 0, 0, NULL, NULL);

INSERT INTO `sys_permission` VALUES ('1328902654732677122', 'e3c13679c73a4f829bcff2aba8fd68b1', '测试Online', '/online/cgformList/f258d3fe15ae4f0989209044d3642f3a', 'testOnline', NULL, NULL, 1, NULL, '1', 1.00, 0, NULL, 0, 1, 0, 0, NULL, 'admin', '2020-11-18 11:27:37', NULL, NULL, 0, 0, '1', 0);

INSERT INTO `sys_permission` VALUES ('1334378366316351489', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '系统参数', '/online/cgformList/15b7fc2ccbf34ab88ca6dc48dde12983', 'modules/online/cgform/auto/OnlCgformAutoList', NULL, NULL, 1, NULL, '1', 7.00, 0, NULL, 0, 1, 0, 0, NULL, 'admin', '2020-12-03 14:06:09', 'admin', '2020-12-03 14:08:05', 0, 0, '1', 0);

INSERT INTO `sys_permission` VALUES ('1337662158229504001', 'e41b69c57a941a3bbcce45032fe57605', 'online表单开发必选(隐藏)', '/online/cgform', 'modules/online/cgformys/OnlCgformHeadListYS', NULL, NULL, 1, NULL, '1', 1.00, 0, NULL, 1, 1, 0, 1, NULL, 'admin', '2020-12-12 15:34:46', NULL, NULL, 0, 0, '1', 0);

INSERT INTO `sys_permission` VALUES ('1367a93f2c410b169faa7abcbad2f77c', '6e73eb3c26099c191bf03852ee1310a1', '基本设置', '/account/settings/BaseSetting', 'account/settings/BaseSetting', 'account-settings-base', NULL, 1, 'BaseSettings', NULL, NULL, 0, NULL, 1, 1, NULL, 1, NULL, NULL, '2018-12-26 18:58:35', 'admin', '2019-03-20 12:57:31', 0, 0, NULL, NULL);

INSERT INTO `sys_permission` VALUES ('190c2b43bec6a5f7a4194a85db67d96a', 'd7d6e2e4e2934f2c9385a623fd98c6f3', '角色管理', '/isystem/roleUserList', 'system/RoleUserList', NULL, NULL, 1, NULL, NULL, 1.20, 0, NULL, 1, 1, 0, 0, NULL, 'admin', '2019-04-17 15:13:56', 'admin', '2019-12-25 09:36:31', 0, 0, NULL, 0);

INSERT INTO `sys_permission` VALUES ('1a0811914300741f4e11838ff37a1d3a', '3f915b2769fc80648e92d04e84ca059d', '手机号禁用', NULL, NULL, NULL, NULL, 2, 'user:form:phone', '2', 1.00, 0, NULL, 0, 1, NULL, 0, NULL, 'admin', '2019-05-11 17:19:30', 'admin', '2019-05-11 18:00:22', 0, 0, '1', NULL);

INSERT INTO `sys_permission` VALUES ('200006f0edf145a2b50eacca07585451', 'fb07ca05a3e13674dbf6d3245956da2e', '搜索列表(应用)', '/list/search/application', 'list/TableList', NULL, NULL, 1, NULL, NULL, 1.00, 0, NULL, 1, 1, NULL, 0, NULL, 'admin', '2019-02-12 14:02:51', 'admin', '2019-02-12 14:14:01', 0, 0, NULL, NULL);

INSERT INTO `sys_permission` VALUES ('22d6a3d39a59dd7ea9a30acfa6bfb0a5', 'e41b69c57a941a3bbcce45032fe57605', 'AUTO动态表单', '/online/df/:table/:id', 'modules/online/cgform/auto/OnlineDynamicForm', NULL, NULL, 1, NULL, NULL, 99.00, 0, NULL, 0, 1, 0, 1, NULL, 'admin', '2019-04-22 15:15:43', 'admin', '2020-11-07 22:38:38', 0, 0, NULL, 0);

INSERT INTO `sys_permission` VALUES ('265de841c58907954b8877fb85212622', '2a470fc0c3954d9dbb61de6d80846549', '图片拖拽排序', '/jeecg/imgDragSo

[ERR] 1062 - Duplicate entry '61835e48f3e675f7d3f5c9dd3a10dcf3' for key 'sys_role_permission.PRIMARY'

[ERR]

INSERT INTO `sys_role_permission` VALUES ('61835e48f3e675f7d3f5c9dd3a10dcf3', 'f6817f48af4fb3af11b9e8bf182f618b', 'f0675b52d89100ee88472b6800754a08', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('6451dac67ba4acafb570fd6a03f47460', 'ee8626f80f7c2619917b6236f3a7f02b', 'e3c13679c73a4f829bcff2aba8fd68b1', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('660fbc40bcb1044738f7cabdf1708c28', 'f6817f48af4fb3af11b9e8bf182f618b', 'b3c824fc22bd953e2eb16ae6914ac8f9', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('66b202f8f84fe766176b3f51071836ef', 'f6817f48af4fb3af11b9e8bf182f618b', '1367a93f2c410b169faa7abcbad2f77c', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('6b605c261ffbc8ac8a98ae33579c8c78', 'f6817f48af4fb3af11b9e8bf182f618b', 'fba41089766888023411a978d13c0aa4', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('6c43fd3f10fdaf2a0646434ae68709b5', 'ee8626f80f7c2619917b6236f3a7f02b', '540a2936940846cb98114ffb0d145cb8', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('6c74518eb6bb9a353f6a6c459c77e64b', 'f6817f48af4fb3af11b9e8bf182f618b', 'b4dfc7d5dd9e8d5b6dd6d4579b1aa559', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('6daddafacd7eccb91309530c17c5855d', 'f6817f48af4fb3af11b9e8bf182f618b', 'edfa74d66e8ea63ea432c2910837b150', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('6fb4c2142498dd6d5b6c014ef985cb66', 'f6817f48af4fb3af11b9e8bf182f618b', '6e73eb3c26099c191bf03852ee1310a1', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('71a5f54a90aa8c7a250a38b7dba39f6f', 'ee8626f80f7c2619917b6236f3a7f02b', '8fb8172747a78756c11916216b8b8066', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('737d35f582036cd18bfd4c8e5748eaa4', 'e51758fa916c881624b046d26bd09230', '693ce69af3432bd00be13c3971a57961', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('7413acf23b56c906aedb5a36fb75bd3a', 'f6817f48af4fb3af11b9e8bf182f618b', 'a4fc7b64b01a224da066bb16230f9c5a', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('75002588591820806', '16457350655250432', '5129710648430592', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('75002588604403712', '16457350655250432', '5129710648430593', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('75002588612792320', '16457350655250432', '40238597734928384', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('75002588625375232', '16457350655250432', '57009744761589760', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('75002588633763840', '16457350655250432', '16392452747300864', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('75002588637958144', '16457350655250432', '16392767785668608', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('75002588650541056', '16457350655250432', '16439068543946752', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('76a54a8cc609754360bf9f57e7dbb2db', 'f6817f48af4fb3af11b9e8bf182f618b', 'c65321e57b7949b7a975313220de0422', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('77277779875336192', '496138616573952', '5129710648430592', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('77277780043108352', '496138616573952', '5129710648430593', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('77277780055691264', '496138616573952', '15701400130424832', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('77277780064079872', '496138616573952', '16678126574637056', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('77277780072468480', '496138616573952', '15701915807518720', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('77277780076662784', '496138616573952', '15708892205944832', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('77277780085051392', '496138616573952', '16678447719911424', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('77277780089245696', '496138616573952', '25014528525733888', NULL, NULL, NULL);

INSERT INTO `sys_role_permission` VALUES ('772777800

[SQL] Finished with error