**[Err] 2006 - MySQL server has gone away
[Err] /*!40000 ALTER TABLE `infra_api_access_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `infra_api_access_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `infra_api_error_log`
--
DROP TABLE IF EXISTS `infra_api_error_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `infra_api_error_log` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
`trace_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '链路追踪编号',
`user_id` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
`user_type` tinyint NOT NULL DEFAULT '0' COMMENT '用户类型',
`application_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '应用名',
`request_method` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请求方法名',
`request_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请求地址',
`request_params` varchar(8000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请求参数',
`user_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户 IP',
`user_agent` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '浏览器 UA',
`exception_time` datetime NOT NULL COMMENT '异常发生时间',
`exception_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '异常名',
`exception_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '异常导致的消息',
`exception_root_cause_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '异常导致的根消息',
`exception_stack_trace` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '异常的栈轨迹',
`exception_class_name` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '异常发生的类全名',
`exception_file_name` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '异常发生的类文件',
`exception_method_name` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '异常发生的方法名',
`exception_line_number` int NOT NULL COMMENT '异常发生的方法所在行',
`process_status` tinyint NOT NULL COMMENT '处理状态',
`process_time` datetime DEFAULT NULL COMMENT '处理时间',
`process_user_id` int DEFAULT '0' COMMENT '处理用户编号',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统异常日志';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `infra_api_error_log`
--
LOCK TABLES `infra_api_error_log` WRITE;
/*!40000 ALTER TABLE `infra_api_error_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `infra_api_error_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `infra_codegen_column`
--
DROP TABLE IF EXISTS `infra_codegen_column`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `infra_codegen_column` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
`table_id` bigint NOT NULL COMMENT '表编号',
`column_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字段名',
`data_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字段类型',
`column_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字段描述',
`nullable` bit(1) NOT NULL COMMENT '是否允许为空',
`primary_key` bit(1) NOT NULL COMMENT '是否主键',
`ordinal_position` int NOT NULL COMMENT '排序',
`java_type` varchar(32) CHARACTER SET u
[Err] 1146 - Table 'autoee-crm.infra_job_log' doesn't exist
[Err] /*!40000 ALTER TABLE `infra_job_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `infra_job_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `institution_code_year_seq`
--
DROP TABLE IF EXISTS `institution_code_year_seq`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `institution_code_year_seq` (
`year` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`current_seq` int DEFAULT '0',
`tenant_id` bigint DEFAULT '1',
PRIMARY KEY (`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `institution_code_year_seq`
--
LOCK TABLES `institution_code_year_seq` WRITE;
/*!40000 ALTER TABLE `institution_code_year_seq` DISABLE KEYS */;
INSERT INTO `institution_code_year_seq` VALUES ('2025',36,1),('2026',1,1),('2027',1,1);
/*!40000 ALTER TABLE `institution_code_year_seq` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `qrtz_blob_triggers`
--
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `qrtz_blob_triggers` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`BLOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `qrtz_blob_triggers`
--
LOCK TABLES `qrtz_blob_triggers` WRITE;
/*!40000 ALTER TABLE `qrtz_blob_triggers` DISABLE KEYS */;
/*!40000 ALTER TABLE `qrtz_blob_triggers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `qrtz_calendars`
--
DROP TABLE IF EXISTS `qrtz_calendars`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `qrtz_calendars` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`CALENDAR_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`CALENDAR` blob NOT NULL,
PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `qrtz_calendars`
--
LOCK TABLES `qrtz_calendars` WRITE;
/*!40000 ALTER TABLE `qrtz_calendars` DISABLE KEYS */;
/*!40000 ALTER TABLE `qrtz_calendars` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `qrtz_cron_triggers`
--
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `qrtz_cron_triggers` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`CRON_EXPRESSION` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`TIME_ZONE_ID` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE R
[Err] 1824 - Failed to open the referenced table 'qrtz_triggers'
[Err] /*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `qrtz_simprop_triggers` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`STR_PROP_1` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`STR_PROP_2` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`STR_PROP_3` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`INT_PROP_1` int DEFAULT NULL,
`INT_PROP_2` int DEFAULT NULL,
`LONG_PROP_1` bigint DEFAULT NULL,
`LONG_PROP_2` bigint DEFAULT NULL,
`DEC_PROP_1` decimal(13,4) DEFAULT NULL,
`DEC_PROP_2` decimal(13,4) DEFAULT NULL,
`BOOL_PROP_1` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`BOOL_PROP_2` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `qrtz_simprop_triggers`
--
LOCK TABLES `qrtz_simprop_triggers` WRITE;
/*!40000 ALTER TABLE `qrtz_simprop_triggers` DISABLE KEYS */;
/*!40000 ALTER TABLE `qrtz_simprop_triggers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `qrtz_triggers`
--
DROP TABLE IF EXISTS `qrtz_triggers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `qrtz_triggers` (
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`JOB_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`JOB_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`DESCRIPTION` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`NEXT_FIRE_TIME` bigint DEFAULT NULL,
`PREV_FIRE_TIME` bigint DEFAULT NULL,
`PRIORITY` int DEFAULT NULL,
`TRIGGER_STATE` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`TRIGGER_TYPE` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`START_TIME` bigint NOT NULL,
`END_TIME` bigint DEFAULT NULL,
`CALENDAR_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`MISFIRE_INSTR` smallint DEFAULT NULL,
`JOB_DATA` blob,
PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE,
KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`) USING BTREE,
KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE,
KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`) USING BTREE,
KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`) USING BTREE,
KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`) USING BTREE,
KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`) USING BTREE,
KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`) USING BTREE,
KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
CONSTRAINT `qrtz_triggers_ibfk_1` FO
[Err] 1146 - Table 'autoee-crm.system_notice' doesn't exist
[Err] --
-- Dumping data for table `system_notice`
--
LOCK TABLES `system_notice` WRITE;
/*!40000 ALTER TABLE `system_notice` DISABLE KEYS */;
INSERT INTO `system_notice` VALUES (1,'芋道的公众','<p>新版本内容133</p>',1,0,'admin','2021-01-05 17:03:48','1','2022-05-04 21:00:20',0x00,1),(2,'维护通知:2018-07-01 系统凌晨维护','<p><img src=\"http://test.yudao.iocoder.cn/b7cb3cf49b4b3258bf7309a09dd2f4e5.jpg\" alt=\"\" data-href=\"\" style=\"\"/>11112222<img src=\"http://test.yudao.iocoder.cn/fe44fc7bdb82ca421184b2eebbaee9e2148d4a1827479a4eb4521e11d2a062ba.png\" alt=\"image\" data-href=\"http://test.yudao.iocoder.cn/fe44fc7bdb82ca421184b2eebbaee9e2148d4a1827479a4eb4521e11d2a062ba.png\" style=\"\"/></p>',2,1,'admin','2021-01-05 17:03:48','1','2024-09-24 20:48:09',0x00,1),(4,'我是测试标题','<p>哈哈哈哈123</p>',1,0,'110','2022-02-22 01:01:25','110','2022-02-22 01:01:46',0x00,121);
/*!40000 ALTER TABLE `system_notice` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `system_notify_message`
--
DROP TABLE IF EXISTS `system_notify_message`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_notify_message` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`user_id` bigint NOT NULL COMMENT '用户id',
`user_type` tinyint NOT NULL COMMENT '用户类型',
`template_id` bigint NOT NULL COMMENT '模版编号',
`template_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模板编码',
`template_nickname` varchar(63) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模版发送人名称',
`template_content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模版内容',
`template_type` int NOT NULL COMMENT '模版类型',
`template_params` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模版参数',
`read_status` bit(1) NOT NULL COMMENT '是否已读',
`read_time` datetime DEFAULT NULL COMMENT '阅读时间',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='站内信消息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `system_notify_message`
--
LOCK TABLES `system_notify_message` WRITE;
/*!40000 ALTER TABLE `system_notify_message` DISABLE KEYS */;
INSERT INTO `system_notify_message` VALUES (52,142,2,7,'bpm_task_assigned','系统','您收到了一条新的待办任务:科技制度属性管理流程-审核,申请人:超级管理员',2,'{\"startUserNickname\":\"超级管理员\",\"taskName\":\"审核\",\"detailUrl\":\"/bpm/process-instance/detail?id=ac5a400d-faf2-11ef-b4ca-14755b716e67\",\"processInstanceName\":\"科技制度属性管理流程\"}',0x00,NULL,'1','2025-03-07 09:22:46','1','2025-03-07 09:22:46',0x00,1),(53,1,2,9,'bpm_process_instance_reject','系统','您的流程被审批不通过:科技制度属性管理流程,原因:审批不通过任务,原因:111',2,'{\"reason\":\"审批不通过任务,原因:111\",\"detailUrl\":\"/bpm/process-instance/detail?id=ac5a400d-faf2-11ef-b4ca-14755b716e67\",\"processInstanceName\":\"科技制度属性管理流程\"}',0x00,NULL,'142','2025-03-07 09:23:42','142','2025-03-07 09:23:42',0x00,1),(54,142,2,7,'bpm_task_assigned','系统','您收到了一条新的待办任务:科技制度属性管理流程-审核,申请人:超级管理员',2,'{\"startUserNickname\":\"超级管理员\",\"taskName\":\"审核\",\"detailUrl\":\"/bpm/process-instance/detail?id=f7108848-faf2-11ef-b4ca-14755b716e67\",\"processInstanceName\":\"科技制度属性管理流程\"}',0x00,NULL,'1','2025-03-07 09:24:51','1','2025-03-07 09:24:51',0x00,1),(55,142,2,7,'bpm_task_assigned','系统','您收到了一条新的待办任务:科技制度属性管理流程-审核,申请人:超级管理员',2,'{\"startUserNickname\":\"超级管理员\",\"taskName\":\"审核\",\"detailUrl\":\"/bpm/process-instance/detail?id=abc7ab19-faf7-11ef-a9af-14755b716e67\",\"processInstanceName\":\"科技制度属性管理流程\"}',0x00,NULL,'
[Err] 1146 - Table 'autoee-crm.system_role' doesn't exist
[Err] /*!40000 ALTER TABLE `system_role` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `system_role_menu`
--
DROP TABLE IF EXISTS `system_role_menu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_role_menu` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增编号',
`role_id` bigint NOT NULL COMMENT '角色ID',
`menu_id` bigint NOT NULL COMMENT '菜单ID',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6127 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色和菜单关联表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `system_role_menu`
--
LOCK TABLES `system_role_menu` WRITE;
/*!40000 ALTER TABLE `system_role_menu` DISABLE KEYS */;
[Err] 1146 - Table 'autoee-crm.system_role_menu' doesn't exist
[Err] INSERT INTO `system_role_menu` VALUES (263,109,1,'1','2022-02-22 00:56:14','1','2022-02-22 00:56:14',0x00,121),(434,2,1,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(454,2,1093,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(455,2,1094,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(460,2,1100,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(467,2,1107,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(476,2,1117,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(477,2,100,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(478,2,101,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(479,2,102,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(480,2,1126,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(481,2,103,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(483,2,104,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(485,2,105,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(488,2,107,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(490,2,108,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(492,2,109,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(498,2,1138,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(523,2,1224,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(524,2,1225,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(541,2,500,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(543,2,501,'1','2022-02-22 13:09:12','1','2022-02-22 13:09:12',0x00,1),(675,2,2,'1','2022-02-22 13:16:57','1','2022-02-22 13:16:57',0x00,1),(689,2,1077,'1','2022-02-22 13:16:57','1','2022-02-22 13:16:57',0x00,1),(690,2,1078,'1','2022-02-22 13:16:57','1','2022-02-22 13:16:57',0x00,1),(692,2,1083,'1','2022-02-22 13:16:57','1','2022-02-22 13:16:57',0x00,1),(693,2,1084,'1','2022-02-22 13:16:57','1','2022-02-22 13:16:57',0x00,1),(699,2,1090,'1','2022-02-22 13:16:57','1','2022-02-22 13:16:57',0x00,1),(703,2,106,'1','2022-02-22 13:16:57','1','2022-02-22 13:16:57',0x00,1),(704,2,110,'1','2022-02-22 13:16:57','1','2022-02-22 13:16:57',0x00,1),(705,2,111,'1','2022-02-22 13:16:57','1','2022-02-22 13:16:57',0x00,1),(706,2,112,'1','2022-02-22 13:16:57','1','2022-02-22 13:16:57',0x00,1),(707,2,113,'1','2022-02-22 13:16:57','1','2022-02-22 13:16:57',0x00,1),(1296,110,1,'110','2022-02-23 00:23:55','110','2022-02-23 00:23:55',0x00,121),(1578,111,1,'1','2022-03-07 21:37:58','1','2022-03-07 21:37:58',0x00,122),(1604,101,1216,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1605,101,1217,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1606,101,1218,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1607,101,1219,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1608,101,1220,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1609,101,1221,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1610,101,5,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1611,101,1222,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1612,101,1118,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1613,101,1119,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1614,101,1120,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1615,101,1185,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1616,101,1186,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1617,101,1187,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1618,101,1188,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1619,101,1189,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1620,101,1190,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1621,101,1191,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1622,101,1192,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1623,101,1193,'1','2022-03-19 21:45:52','1','2022-03-19 21:45:52',0x00,1),(1624,101,1194,'1','2022-03-19 21:45:52','1','20
[Err] 1231 - Variable 'time_zone' can't be set to the value of 'NULL'
[Err] /*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `system_user_role`
--
LOCK TABLES `system_user_role` WRITE;
/*!40000 ALTER TABLE `system_user_role` DISABLE KEYS */;
INSERT INTO `system_user_role` VALUES (1,1,1,'','2022-01-11 13:19:45','','2022-05-12 12:35:17',0x00,1),(2,2,2,'','2022-01-11 13:19:45','','2022-05-12 12:35:13',0x00,1),(4,100,101,'','2022-01-11 13:19:45','','2022-05-12 12:35:13',0x00,1),(5,100,1,'','2022-01-11 13:19:45','','2022-05-12 12:35:12',0x00,1),(6,100,2,'','2022-01-11 13:19:45','','2022-05-12 12:35:11',0x00,1),(10,103,1,'1','2022-01-11 13:19:45','1','2022-01-11 13:19:45',0x00,1),(14,110,109,'1','2022-02-22 00:56:14','1','2022-02-22 00:56:14',0x00,121),(15,111,110,'110','2022-02-23 13:14:38','110','2022-02-23 13:14:38',0x00,121),(16,113,111,'1','2022-03-07 21:37:58','1','2022-03-07 21:37:58',0x00,122),(18,1,2,'1','2022-05-12 20:39:29','1','2022-05-12 20:39:29',0x00,1),(20,104,101,'1','2022-05-28 15:43:57','1','2022-05-28 15:43:57',0x00,1),(22,115,2,'1','2022-07-21 22:08:30','1','2022-07-21 22:08:30',0x00,1),(35,112,1,'1','2024-03-15 20:00:24','1','2024-03-15 20:00:24',0x00,1),(36,118,1,'1','2024-03-17 09:12:08','1','2024-03-17 09:12:08',0x00,1),(38,114,101,'1','2024-03-24 22:23:03','1','2024-03-24 22:23:03',0x00,1),(46,117,1,'1','2024-10-02 10:16:11','1','2024-10-02 10:16:11',0x00,1),(47,140,154,'1','2025-03-06 09:33:57','1','2025-03-06 09:33:57',0x00,1),(48,142,155,'1','2025-03-06 09:35:43','1','2025-03-06 09:35:43',0x00,1),(49,143,156,'1','2025-03-06 09:36:08','1','2025-03-06 09:36:08',0x00,1),(50,144,157,'1','2025-03-06 09:43:07','1','2025-03-06 09:43:07',0x00,1),(51,145,158,'1','2025-04-23 13:48:36','1','2025-04-23 13:48:36',0x00,1),(52,146,158,'1','2025-04-23 15:17:18','1','2025-04-23 15:17:18',0x00,1);
/*!40000 ALTER TABLE `system_user_role` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `system_users`
--
DROP TABLE IF EXISTS `system_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_users` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`username` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户账号',
`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '密码',
`nickname` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户昵称',
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
`dept_id` bigint DEFAULT NULL COMMENT '部门ID',
`post_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '岗位编号数组',
`email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户邮箱',
`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '手机号码',
`sex` tinyint DEFAULT '0' COMMENT '用户性别',
`avatar` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '头像地址',
`status` tinyint NOT NULL DEFAULT '0' COMMENT '帐号状态(0正常 1停用)',
`login_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '最后登录IP',
`login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `system_users`
--
LOCK TABLES `system_users` WRITE;
/*!40000 ALTER TABLE `system_users` DISABLE
[Msg] Finished - Unsuccessfully
--------------------------------------------------**
最新发布