2006-03-19

今日目标是:

1 .熟练使用clanLib的介面GUI

2. 完成地图编辑器的介面开发工作

 

目前虽然大概知道,clanLib中对于GUI是如何处理的。可是对定制的介面还不能达到clanLib中的用例水平,照这样下去,BOMMAN的介面肯定达不到neogeo中的要求。目前主要是在对内置的各个组件如何无缝的组合在一起。可能还要看一看clanLib中例子的源程序找找问题出在哪。加油吧!只要这部分搞定了,地图编辑器也会很快就做出来的了。

 

唉,上午起来得太晚了。今天是应该去买个闹钟的了,最无耻的还要算上午看了一个多钟头的《封神榜》动画,而且开工之前还得听了半个小时的音乐,搞得上午都没怎么做事。唉呀呀,这样下去可不行啊。下午要打起精神才行罗!午觉就不睡了吧!GOOD LUCK!希望今天能够完成目标!

 

2006-3-19  P.M11:15

结果下午与晚上都变成了装机时间,操作系统就装了两次。第一次是用GHOST还原,

还原后有次莫名其妙的重启,怀疑是不是之前ghost装的系统有问题。于是再塌塌实实的又装了一次。后面装开发软件,一开始是VC6.0装不进去,然后同邻居的硬盘拷了分创天中文版。装了之后发现也是又问题的,因为我都是把VC6.0装在E:盘同一个目录的。后来又发现如果不把原来文件完全的删除掉,还是有影响的。不过最终还是确认这张中文版是有问题!然后想想为什么之前装的英文版会有几条文件没读取来。我都是直接从压缩文件中解压的呀,如果有一个字节的错误都不可能解得出来啊。然后发现我用的解压软件换了,一般用的是WINRAR的,当时不知怎么的用了7-zip的一个免费软件。最终换回WINRAR果然就没有问题了,真是不知说什么了。

 

然后晚上把VC60 sp6补丁打上,准备编译一下之前的代码,发现又有错误。当然我就想把dx8 sdkstlport clanLib这几个开发工具重新装了一次。后面又经历了

1.       Microsoft Platform SDK 头文件目录的次序问题啦。

2.       stlport 中的C2733啦,发现又是stl_user_config.h中的

# define _STLP_NEW_PLATFORM_SDK 1  没有打上啦

3.       后面编绎clanLib,使用stlPort又出现些error C2059的一些其它错误,没有解决。(哦,好象上次使用stlport的时候编绎clanLib也是这个问题,后来是怕麻烦。直接用vc6.0中带的stl硬是把它编绎完了,唉~

4.       然后在clanLib中的clanGUI模块又出现莫名的预处理头文件问题,好在之前碰到过:

error C2857: '#include' statement specified with the /YcGUI/precomp.h command-line option was not found in the source file

Error executing cl.exe.

解决方法就是在工程中的precompiled header选为not using precompiled headers,并且把precomp.cpp从工程文件中删除就可以了。这个问题其实并不会出在ClanLib-0.8.0-RC1中。不过RC2解决了某些问题,碰巧又是被我撞上的,没法子。只能上贼船了。

 

之前也是这样,开发环境比较复杂。早知如此,clanLib我就不重编绎了。虽说是机器自动完成,但少说也得20分钟啊。所以我才不想重装的嘛。不过这次主要花的时间还是在装vc6.0以及操作系统上面。看来以后用vc.net 还好些。今天任务就彻底失败啦。明天要补回来才行哪!

 

**[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
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值