2006-03-19

1.完成炸弹人1.1游戏

2.制做炸弹人相关文档

3.翻译clanLib帮助文档

4.写一编游戏入门的短文

**[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 --------------------------------------------------**
07-01
评论 4
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值