Эхлэл Бүгдийг харах Тусламж
Нэвтрэх
yp
/
intelligent-etmf-system
7
0
Салаа 0
Файлууд Асуудлууд 0 Хуулах хүсэлтүүд 0 Мэдлэгийн сан
Мод: 93fd8f0c67
Салаанууд Тагууд
intelligent-etm...
/
script
/
sql
/
business
/
dump
/
2025
/
12
/
20251202_dump.sql

20251202_dump.sql 133 KB
Түүх Анхны өгөгдөл

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012 
  1. -- MySQL dump 10.13  Distrib 8.0.35, for Win64 (x86_64)
    2. 

  2. --
    3. 

  3. -- Host: 127.0.0.1    Database: intelligent_etmf_system
    4. 

  4. -- ------------------------------------------------------
    5. 

  5. -- Server version	8.0.35
    6. 

  6. 

  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    8. 

  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    9. 

  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    10. 

  10. /*!50503 SET NAMES utf8mb4 */;
    11. 

  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    12. 

  12. /*!40103 SET TIME_ZONE='+00:00' */;
    13. 

  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    14. 

  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    15. 

  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    16. 

  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    17. 

  17. 

  18. --
    19. 

  19. -- Table structure for table `applet_setting`
    20. 

  20. --
    21. 

  21. 

  22. DROP TABLE IF EXISTS `applet_setting`;
    23. 

  23. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    24. 

  24. /*!50503 SET character_set_client = utf8mb4 */;
    25. 

  25. CREATE TABLE `applet_setting` (
    26. 

  26.   `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '序号',
    27. 

  27.   `user_agreement` text COMMENT '用户协议',
    28. 

  28.   `privacy_agreement` text COMMENT '隐私协议',
    29. 

  29.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    30. 

  30.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    31. 

  31.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    32. 

  32.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    33. 

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

  34.   `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
    35. 

  35.   `tenant_id` varchar(40) DEFAULT NULL COMMENT '租户id',
    36. 

  36.   PRIMARY KEY (`id`)
    37. 

  37. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='微信小程序设置';
    38. 

  38. /*!40101 SET character_set_client = @saved_cs_client */;
    39. 

  39. 

  40. --
    41. 

  41. -- Dumping data for table `applet_setting`
    42. 

  42. --
    43. 

  43. 

  44. LOCK TABLES `applet_setting` WRITE;
    45. 

  45. /*!40000 ALTER TABLE `applet_setting` DISABLE KEYS */;
    46. 

  46. INSERT INTO `applet_setting` VALUES (1,'<p>这是一段测试使用的用户协议</p>','<p>这是一段测试使用的隐私协议</p>',100,1,'2025-11-28 16:41:27',1,'2025-11-28 17:01:57','0','');
    47. 

  47. /*!40000 ALTER TABLE `applet_setting` ENABLE KEYS */;
    48. 

  48. UNLOCK TABLES;
    49. 

  49. 

  50. --
    51. 

  51. -- Table structure for table `gen_table`
    52. 

  52. --
    53. 

  53. 

  54. DROP TABLE IF EXISTS `gen_table`;
    55. 

  55. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    56. 

  56. /*!50503 SET character_set_client = utf8mb4 */;
    57. 

  57. CREATE TABLE `gen_table` (
    58. 

  58.   `table_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    59. 

  59.   `data_name` varchar(200) DEFAULT '' COMMENT '数据源名称',
    60. 

  60.   `table_name` varchar(200) DEFAULT '' COMMENT '表名称',
    61. 

  61.   `table_comment` varchar(500) DEFAULT '' COMMENT '表描述',
    62. 

  62.   `sub_table_name` varchar(64) DEFAULT NULL COMMENT '关联子表的表名',
    63. 

  63.   `sub_table_fk_name` varchar(64) DEFAULT NULL COMMENT '子表关联的外键名',
    64. 

  64.   `class_name` varchar(100) DEFAULT '' COMMENT '实体类名称',
    65. 

  65.   `tpl_category` varchar(200) DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作）',
    66. 

  66.   `package_name` varchar(100) DEFAULT NULL COMMENT '生成包路径',
    67. 

  67.   `module_name` varchar(30) DEFAULT NULL COMMENT '生成模块名',
    68. 

  68.   `business_name` varchar(30) DEFAULT NULL COMMENT '生成业务名',
    69. 

  69.   `function_name` varchar(50) DEFAULT NULL COMMENT '生成功能名',
    70. 

  70.   `function_author` varchar(50) DEFAULT NULL COMMENT '生成功能作者',
    71. 

  71.   `gen_type` char(1) DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）',
    72. 

  72.   `gen_path` varchar(200) DEFAULT '/' COMMENT '生成路径（不填默认项目路径）',
    73. 

  73.   `options` varchar(1000) DEFAULT NULL COMMENT '其它生成选项',
    74. 

  74.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    75. 

  75.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    76. 

  76.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    77. 

  77.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    78. 

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

  79.   `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    80. 

  80.   PRIMARY KEY (`table_id`)
    81. 

  81. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='代码生成业务表';
    82. 

  82. /*!40101 SET character_set_client = @saved_cs_client */;
    83. 

  83. 

  84. --
    85. 

  85. -- Dumping data for table `gen_table`
    86. 

  86. --
    87. 

  87. 

  88. LOCK TABLES `gen_table` WRITE;
    89. 

  89. /*!40000 ALTER TABLE `gen_table` DISABLE KEYS */;
    90. 

  90. INSERT INTO `gen_table` VALUES (1,'master','applet_setting','微信小程序设置',NULL,NULL,'AppletSetting','crud','com.yingpaipay.setting','setting','applet','小程序设置','Huanyi','0','/','{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null}',100,1,'2025-11-28 16:33:04',1,'2025-11-28 16:35:20',NULL),(2,'master','project','项目',NULL,NULL,'Project','crud','org.dromara.system','system','project','项目','Lion Li','0','/','{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null}',100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27',NULL);
    91. 

  91. /*!40000 ALTER TABLE `gen_table` ENABLE KEYS */;
    92. 

  92. UNLOCK TABLES;
    93. 

  93. 

  94. --
    95. 

  95. -- Table structure for table `gen_table_column`
    96. 

  96. --
    97. 

  97. 

  98. DROP TABLE IF EXISTS `gen_table_column`;
    99. 

  99. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    100. 

  100. /*!50503 SET character_set_client = utf8mb4 */;
    101. 

  101. CREATE TABLE `gen_table_column` (
    102. 

  102.   `column_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
    103. 

  103.   `table_id` bigint DEFAULT NULL COMMENT '归属表编号',
    104. 

  104.   `column_name` varchar(200) DEFAULT NULL COMMENT '列名称',
    105. 

  105.   `column_comment` varchar(500) DEFAULT NULL COMMENT '列描述',
    106. 

  106.   `column_type` varchar(100) DEFAULT NULL COMMENT '列类型',
    107. 

  107.   `java_type` varchar(500) DEFAULT NULL COMMENT 'JAVA类型',
    108. 

  108.   `java_field` varchar(200) DEFAULT NULL COMMENT 'JAVA字段名',
    109. 

  109.   `is_pk` char(1) DEFAULT NULL COMMENT '是否主键（1是）',
    110. 

  110.   `is_increment` char(1) DEFAULT NULL COMMENT '是否自增（1是）',
    111. 

  111.   `is_required` char(1) DEFAULT NULL COMMENT '是否必填（1是）',
    112. 

  112.   `is_insert` char(1) DEFAULT NULL COMMENT '是否为插入字段（1是）',
    113. 

  113.   `is_edit` char(1) DEFAULT NULL COMMENT '是否编辑字段（1是）',
    114. 

  114.   `is_list` char(1) DEFAULT NULL COMMENT '是否列表字段（1是）',
    115. 

  115.   `is_query` char(1) DEFAULT NULL COMMENT '是否查询字段（1是）',
    116. 

  116.   `query_type` varchar(200) DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
    117. 

  117.   `html_type` varchar(200) DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
    118. 

  118.   `dict_type` varchar(200) DEFAULT '' COMMENT '字典类型',
    119. 

  119.   `sort` int DEFAULT NULL COMMENT '排序',
    120. 

  120.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    121. 

  121.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    122. 

  122.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    123. 

  123.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    124. 

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

  125.   PRIMARY KEY (`column_id`)
    126. 

  126. ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='代码生成业务表字段';
    127. 

  127. /*!40101 SET character_set_client = @saved_cs_client */;
    128. 

  128. 

  129. --
    130. 

  130. -- Dumping data for table `gen_table_column`
    131. 

  131. --
    132. 

  132. 

  133. LOCK TABLES `gen_table_column` WRITE;
    134. 

  134. /*!40000 ALTER TABLE `gen_table_column` DISABLE KEYS */;
    135. 

  135. INSERT INTO `gen_table_column` VALUES (1,1,'id','序号','bigint','Long','id','1','1','1',NULL,'1','0',NULL,'EQ','input','',1,100,1,'2025-11-28 16:33:04',1,'2025-11-28 16:35:20'),(2,1,'user_agreement','用户协议','text','String','userAgreement','0','0','0','0','1','0','1','EQ','editor','',2,100,1,'2025-11-28 16:33:04',1,'2025-11-28 16:35:20'),(3,1,'privacy_agreement','隐私协议','text','String','privacyAgreement','0','0','0','0','1','0','1','EQ','editor','',3,100,1,'2025-11-28 16:33:04',1,'2025-11-28 16:35:20'),(4,1,'create_dept','创建部门','bigint','Long','createDept','0','0','0',NULL,NULL,NULL,NULL,'EQ','input','',4,100,1,'2025-11-28 16:33:04',1,'2025-11-28 16:35:20'),(5,1,'create_by','创建者','bigint','Long','createBy','0','0','0',NULL,NULL,NULL,NULL,'EQ','input','',5,100,1,'2025-11-28 16:33:04',1,'2025-11-28 16:35:20'),(6,1,'create_time','创建时间','datetime','Date','createTime','0','0','0',NULL,NULL,NULL,NULL,'EQ','datetime','',6,100,1,'2025-11-28 16:33:04',1,'2025-11-28 16:35:20'),(7,1,'update_by','更新者','bigint','Long','updateBy','0','0','0',NULL,NULL,NULL,NULL,'EQ','input','',7,100,1,'2025-11-28 16:33:04',1,'2025-11-28 16:35:20'),(8,1,'update_time','更新时间','datetime','Date','updateTime','0','0','0',NULL,NULL,NULL,NULL,'EQ','datetime','',8,100,1,'2025-11-28 16:33:04',1,'2025-11-28 16:35:20'),(9,1,'del_flag','删除标志（0代表存在 1代表删除）','char(1)','String','delFlag','0','0','0',NULL,NULL,NULL,NULL,'EQ','input','',9,100,1,'2025-11-28 16:33:04',1,'2025-11-28 16:35:20'),(10,1,'tenant_id','租户id','varchar(40)','String','tenantId','0','0','0',NULL,NULL,NULL,NULL,'EQ','input','',10,100,1,'2025-11-28 16:33:04',1,'2025-11-28 16:35:20'),(11,2,'id','序号','bigint','Long','id','1','1','1',NULL,'1','1',NULL,'EQ','input','',1,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(12,2,'code','项目编号','varchar(128)','String','code','0','0','1','1','1','1','1','LIKE','input','',2,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(13,2,'name','名称','varchar(128)','String','name','0','0','1','1','1','1','1','LIKE','input','',3,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(14,2,'icon','图标','bigint','Long','icon','0','0','1','1','1','1','0','EQ','imageUpload','',4,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(15,2,'language','项目语言','char(1)','String','language','0','0','1','1','1','1','1','EQ','select','project_language',5,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(16,2,'type','项目类型','char(1)','String','type','0','0','1','1','1','1','1','EQ','select','project_type',6,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(17,2,'status','状态','tinyint(1)','Long','status','0','0','1','1','1','1','1','EQ','radio','',7,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(18,2,'pd_gpd','PD/GPD','bigint','Long','pdGpd','0','0','0','1','1','1','1','EQ','input','',8,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(19,2,'pm_gpm','PM/GPM','bigint','Long','pmGpm','0','0','0','1','1','1','1','EQ','input','',9,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(20,2,'cta_gcta','CTA/GCTA','bigint','Long','ctaGcta','0','0','0','1','1','1','1','EQ','input','',10,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(21,2,'sponsor','申办方','varchar(128)','String','sponsor','0','0','0','1','1','1','1','EQ','input','',11,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(22,2,'cro','CRO','bigint','Long','cro','0','0','0','1','1','1','1','EQ','input','',12,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(23,2,'note','备注','varchar(255)','String','note','0','0','0','1','1','1','0','EQ','input','',13,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(24,2,'create_dept','创建部门','bigint','Long','createDept','0','0','0',NULL,NULL,NULL,NULL,'EQ','input','',14,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(25,2,'create_by','创建者','bigint','Long','createBy','0','0','0',NULL,NULL,NULL,NULL,'EQ','input','',15,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(26,2,'create_time','创建时间','datetime','Date','createTime','0','0','0',NULL,NULL,'1','1','EQ','datetime','',16,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(27,2,'update_by','更新者','bigint','Long','updateBy','0','0','0',NULL,NULL,NULL,NULL,'EQ','input','',17,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(28,2,'update_time','更新时间','datetime','Date','updateTime','0','0','0',NULL,NULL,'1','1','EQ','datetime','',18,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(29,2,'del_flag','删除标志（0代表存在 1代表删除）','char(1)','String','delFlag','0','0','0',NULL,NULL,NULL,NULL,'EQ','input','',19,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27'),(30,2,'tenant_id','租户id','varchar(40)','String','tenantId','0','0','0',NULL,NULL,NULL,NULL,'EQ','input','',20,100,1,'2025-12-01 11:37:08',1,'2025-12-01 11:40:27');
    136. 

  136. /*!40000 ALTER TABLE `gen_table_column` ENABLE KEYS */;
    137. 

  137. UNLOCK TABLES;
    138. 

  138. 

  139. --
    140. 

  140. -- Table structure for table `project`
    141. 

  141. --
    142. 

  142. 

  143. DROP TABLE IF EXISTS `project`;
    144. 

  144. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    145. 

  145. /*!50503 SET character_set_client = utf8mb4 */;
    146. 

  146. CREATE TABLE `project` (
    147. 

  147.   `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '序号',
    148. 

  148.   `code` varchar(128) NOT NULL COMMENT '项目编号',
    149. 

  149.   `name` varchar(128) NOT NULL COMMENT '名称',
    150. 

  150.   `icon` bigint NOT NULL COMMENT '图标',
    151. 

  151.   `language` char(1) NOT NULL DEFAULT '0' COMMENT '项目语言',
    152. 

  152.   `type` char(1) NOT NULL DEFAULT '0' COMMENT '项目类型',
    153. 

  153.   `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
    154. 

  154.   `pd_gpd` bigint unsigned DEFAULT NULL COMMENT 'PD/GPD',
    155. 

  155.   `pm_gpm` bigint unsigned DEFAULT NULL COMMENT 'PM/GPM',
    156. 

  156.   `cta_gcta` bigint unsigned DEFAULT NULL COMMENT 'CTA/GCTA',
    157. 

  157.   `sponsor` varchar(128) DEFAULT NULL COMMENT '申办方',
    158. 

  158.   `cro` bigint unsigned DEFAULT NULL COMMENT 'CRO',
    159. 

  159.   `note` varchar(255) DEFAULT NULL COMMENT '备注',
    160. 

  160.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    161. 

  161.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    162. 

  162.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    163. 

  163.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    164. 

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

  165.   `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
    166. 

  166.   `tenant_id` varchar(40) DEFAULT NULL COMMENT '租户id',
    167. 

  167.   PRIMARY KEY (`id`)
    168. 

  168. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='项目';
    169. 

  169. /*!40101 SET character_set_client = @saved_cs_client */;
    170. 

  170. 

  171. --
    172. 

  172. -- Dumping data for table `project`
    173. 

  173. --
    174. 

  174. 

  175. LOCK TABLES `project` WRITE;
    176. 

  176. /*!40000 ALTER TABLE `project` DISABLE KEYS */;
    177. 

  177. /*!40000 ALTER TABLE `project` ENABLE KEYS */;
    178. 

  178. UNLOCK TABLES;
    179. 

  179. 

  180. --
    181. 

  181. -- Table structure for table `sys_client`
    182. 

  182. --
    183. 

  183. 

  184. DROP TABLE IF EXISTS `sys_client`;
    185. 

  185. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    186. 

  186. /*!50503 SET character_set_client = utf8mb4 */;
    187. 

  187. CREATE TABLE `sys_client` (
    188. 

  188.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
    189. 

  189.   `client_id` varchar(64) DEFAULT NULL COMMENT '客户端id',
    190. 

  190.   `client_key` varchar(32) DEFAULT NULL COMMENT '客户端key',
    191. 

  191.   `client_secret` varchar(255) DEFAULT NULL COMMENT '客户端秘钥',
    192. 

  192.   `grant_type` varchar(255) DEFAULT NULL COMMENT '授权类型',
    193. 

  193.   `device_type` varchar(32) DEFAULT NULL COMMENT '设备类型',
    194. 

  194.   `active_timeout` int DEFAULT '1800' COMMENT 'token活跃超时时间',
    195. 

  195.   `timeout` int DEFAULT '604800' COMMENT 'token固定超时',
    196. 

  196.   `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
    197. 

  197.   `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
    198. 

  198.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    199. 

  199.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    200. 

  200.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    201. 

  201.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    202. 

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

  203.   PRIMARY KEY (`id`)
    204. 

  204. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统授权表';
    205. 

  205. /*!40101 SET character_set_client = @saved_cs_client */;
    206. 

  206. 

  207. --
    208. 

  208. -- Dumping data for table `sys_client`
    209. 

  209. --
    210. 

  210. 

  211. LOCK TABLES `sys_client` WRITE;
    212. 

  212. /*!40000 ALTER TABLE `sys_client` DISABLE KEYS */;
    213. 

  213. INSERT INTO `sys_client` VALUES (1,'e5cd7e4891bf95d1d19206ce24a7b32e','pc','pc123','password,sms','pc',1800,604800,'0','0',103,1,'2025-11-26 13:39:29',1,'2025-11-28 11:17:57'),(2,'428a8310cd442757ae699df5d894f051','app','app123','password,sms,social','android',1800,604800,'0','1',103,1,'2025-11-26 13:39:29',1,'2025-11-28 11:16:20'),(3,'2f847927afb2b3ebeefc870c13d623f2','applet','applet123','social','xcx',604800,2592000,'0','0',100,1,'2025-11-28 11:17:40',1,'2025-11-28 11:17:40');
    214. 

  214. /*!40000 ALTER TABLE `sys_client` ENABLE KEYS */;
    215. 

  215. UNLOCK TABLES;
    216. 

  216. 

  217. --
    218. 

  218. -- Table structure for table `sys_config`
    219. 

  219. --
    220. 

  220. 

  221. DROP TABLE IF EXISTS `sys_config`;
    222. 

  222. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    223. 

  223. /*!50503 SET character_set_client = utf8mb4 */;
    224. 

  224. CREATE TABLE `sys_config` (
    225. 

  225.   `config_id` bigint NOT NULL AUTO_INCREMENT COMMENT '参数主键',
    226. 

  226.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
    227. 

  227.   `config_name` varchar(100) DEFAULT '' COMMENT '参数名称',
    228. 

  228.   `config_key` varchar(100) DEFAULT '' COMMENT '参数键名',
    229. 

  229.   `config_value` varchar(500) DEFAULT '' COMMENT '参数键值',
    230. 

  230.   `config_type` char(1) DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
    231. 

  231.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    232. 

  232.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    233. 

  233.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    234. 

  234.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    235. 

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

  236.   `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    237. 

  237.   PRIMARY KEY (`config_id`)
    238. 

  238. ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='参数配置表';
    239. 

  239. /*!40101 SET character_set_client = @saved_cs_client */;
    240. 

  240. 

  241. --
    242. 

  242. -- Dumping data for table `sys_config`
    243. 

  243. --
    244. 

  244. 

  245. LOCK TABLES `sys_config` WRITE;
    246. 

  246. /*!40000 ALTER TABLE `sys_config` DISABLE KEYS */;
    247. 

  247. INSERT INTO `sys_config` VALUES (1,'000000','主框架页-默认皮肤样式名称','sys.index.skinName','skin-blue','Y',103,1,'2025-11-26 13:39:29',NULL,NULL,'蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow'),(2,'000000','用户管理-账号初始密码','sys.user.initPassword','123456','Y',103,1,'2025-11-26 13:39:29',NULL,NULL,'初始化密码 123456'),(3,'000000','主框架页-侧边栏主题','sys.index.sideTheme','theme-dark','Y',103,1,'2025-11-26 13:39:29',NULL,NULL,'深色主题theme-dark，浅色主题theme-light'),(5,'000000','账号自助-是否开启用户注册功能','sys.account.registerUser','false','Y',103,1,'2025-11-26 13:39:29',NULL,NULL,'是否开启注册用户功能（true开启，false关闭）'),(11,'000000','OSS预览列表资源开关','sys.oss.previewListResource','true','Y',103,1,'2025-11-26 13:39:29',NULL,NULL,'true:开启, false:关闭');
    248. 

  248. /*!40000 ALTER TABLE `sys_config` ENABLE KEYS */;
    249. 

  249. UNLOCK TABLES;
    250. 

  250. 

  251. --
    252. 

  252. -- Table structure for table `sys_dept`
    253. 

  253. --
    254. 

  254. 

  255. DROP TABLE IF EXISTS `sys_dept`;
    256. 

  256. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    257. 

  257. /*!50503 SET character_set_client = utf8mb4 */;
    258. 

  258. CREATE TABLE `sys_dept` (
    259. 

  259.   `dept_id` bigint NOT NULL AUTO_INCREMENT COMMENT '部门id',
    260. 

  260.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
    261. 

  261.   `parent_id` bigint DEFAULT '0' COMMENT '父部门id',
    262. 

  262.   `ancestors` varchar(500) DEFAULT '' COMMENT '祖级列表',
    263. 

  263.   `dept_name` varchar(30) DEFAULT '' COMMENT '部门名称',
    264. 

  264.   `dept_category` varchar(100) DEFAULT NULL COMMENT '部门类别编码',
    265. 

  265.   `order_num` int DEFAULT '0' COMMENT '显示顺序',
    266. 

  266.   `leader` bigint DEFAULT NULL COMMENT '负责人',
    267. 

  267.   `phone` varchar(11) DEFAULT NULL COMMENT '联系电话',
    268. 

  268.   `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
    269. 

  269.   `status` char(1) DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
    270. 

  270.   `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
    271. 

  271.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    272. 

  272.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    273. 

  273.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    274. 

  274.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    275. 

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

  276.   PRIMARY KEY (`dept_id`)
    277. 

  277. ) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='部门表';
    278. 

  278. /*!40101 SET character_set_client = @saved_cs_client */;
    279. 

  279. 

  280. --
    281. 

  281. -- Dumping data for table `sys_dept`
    282. 

  282. --
    283. 

  283. 

  284. LOCK TABLES `sys_dept` WRITE;
    285. 

  285. /*!40000 ALTER TABLE `sys_dept` DISABLE KEYS */;
    286. 

  286. INSERT INTO `sys_dept` VALUES (100,'000000',0,'0','公司',NULL,0,NULL,'15888888888','xxx@qq.com','0','0',103,1,'2025-11-26 13:39:24',NULL,NULL);
    287. 

  287. /*!40000 ALTER TABLE `sys_dept` ENABLE KEYS */;
    288. 

  288. UNLOCK TABLES;
    289. 

  289. 

  290. --
    291. 

  291. -- Table structure for table `sys_dict_data`
    292. 

  292. --
    293. 

  293. 

  294. DROP TABLE IF EXISTS `sys_dict_data`;
    295. 

  295. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    296. 

  296. /*!50503 SET character_set_client = utf8mb4 */;
    297. 

  297. CREATE TABLE `sys_dict_data` (
    298. 

  298.   `dict_code` bigint NOT NULL AUTO_INCREMENT COMMENT '字典编码',
    299. 

  299.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
    300. 

  300.   `dict_sort` int DEFAULT '0' COMMENT '字典排序',
    301. 

  301.   `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',
    302. 

  302.   `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',
    303. 

  303.   `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
    304. 

  304.   `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
    305. 

  305.   `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式',
    306. 

  306.   `is_default` char(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
    307. 

  307.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    308. 

  308.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    309. 

  309.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    310. 

  310.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    311. 

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

  312.   `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    313. 

  313.   PRIMARY KEY (`dict_code`)
    314. 

  314. ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典数据表';
    315. 

  315. /*!40101 SET character_set_client = @saved_cs_client */;
    316. 

  316. 

  317. --
    318. 

  318. -- Dumping data for table `sys_dict_data`
    319. 

  319. --
    320. 

  320. 

  321. LOCK TABLES `sys_dict_data` WRITE;
    322. 

  322. /*!40000 ALTER TABLE `sys_dict_data` DISABLE KEYS */;
    323. 

  323. INSERT INTO `sys_dict_data` VALUES (1,'000000',1,'男','0','sys_user_sex','','','Y',103,1,'2025-11-26 13:39:28',NULL,NULL,'性别男'),(2,'000000',2,'女','1','sys_user_sex','','','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'性别女'),(3,'000000',3,'未知','2','sys_user_sex','','','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'性别未知'),(4,'000000',1,'显示','0','sys_show_hide','','primary','Y',103,1,'2025-11-26 13:39:28',NULL,NULL,'显示菜单'),(5,'000000',2,'隐藏','1','sys_show_hide','','danger','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'隐藏菜单'),(6,'000000',1,'正常','0','sys_normal_disable','','primary','Y',103,1,'2025-11-26 13:39:28',NULL,NULL,'正常状态'),(7,'000000',2,'停用','1','sys_normal_disable','','danger','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'停用状态'),(12,'000000',1,'是','Y','sys_yes_no','','primary','Y',103,1,'2025-11-26 13:39:28',NULL,NULL,'系统默认是'),(13,'000000',2,'否','N','sys_yes_no','','danger','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'系统默认否'),(14,'000000',1,'通知','1','sys_notice_type','','warning','Y',103,1,'2025-11-26 13:39:28',NULL,NULL,'通知'),(15,'000000',2,'公告','2','sys_notice_type','','success','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'公告'),(16,'000000',1,'正常','0','sys_notice_status','','primary','Y',103,1,'2025-11-26 13:39:28',NULL,NULL,'正常状态'),(17,'000000',2,'关闭','1','sys_notice_status','','danger','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'关闭状态'),(18,'000000',1,'新增','1','sys_oper_type','','info','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'新增操作'),(19,'000000',2,'修改','2','sys_oper_type','','info','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'修改操作'),(20,'000000',3,'删除','3','sys_oper_type','','danger','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'删除操作'),(21,'000000',4,'授权','4','sys_oper_type','','primary','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'授权操作'),(22,'000000',5,'导出','5','sys_oper_type','','warning','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'导出操作'),(23,'000000',6,'导入','6','sys_oper_type','','warning','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'导入操作'),(24,'000000',7,'强退','7','sys_oper_type','','danger','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'强退操作'),(25,'000000',8,'生成代码','8','sys_oper_type','','warning','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'生成操作'),(26,'000000',9,'清空数据','9','sys_oper_type','','danger','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'清空操作'),(27,'000000',1,'成功','0','sys_common_status','','primary','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'正常状态'),(28,'000000',2,'失败','1','sys_common_status','','danger','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'停用状态'),(29,'000000',99,'其他','0','sys_oper_type','','info','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'其他操作'),(30,'000000',0,'密码认证','password','sys_grant_type','el-check-tag','default','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'密码认证'),(31,'000000',0,'短信认证','sms','sys_grant_type','el-check-tag','default','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'短信认证'),(32,'000000',0,'邮件认证','email','sys_grant_type','el-check-tag','default','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'邮件认证'),(33,'000000',0,'小程序认证','xcx','sys_grant_type','el-check-tag','default','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'小程序认证'),(34,'000000',0,'三方登录认证','social','sys_grant_type','el-check-tag','default','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'三方登录认证'),(35,'000000',0,'PC','pc','sys_device_type','','default','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'PC'),(36,'000000',0,'安卓','android','sys_device_type','','default','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'安卓'),(37,'000000',0,'iOS','ios','sys_device_type','','default','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'iOS'),(38,'000000',0,'小程序','xcx','sys_device_type','','default','N',103,1,'2025-11-26 13:39:28',NULL,NULL,'小程序'),(49,'000000',1,'基本文档','0','project_file_specification','','info','N',100,1,'2025-11-28 11:54:08',1,'2025-11-28 11:54:08',''),(50,'000000',1,'基本文档','0','center_file_specification','','info','N',100,1,'2025-11-28 11:54:27',1,'2025-11-28 11:54:27',''),(51,'000000',1,'Single Region','0','project_type','','default','N',100,1,'2025-12-01 11:27:29',1,'2025-12-01 11:27:29',''),(52,'000000',1,'中文','0','project_language','','default','N',100,1,'2025-12-01 11:38:55',1,'2025-12-01 11:38:58',''),(53,'000000',2,'英文','1','project_language','','default','N',100,1,'2025-12-01 11:39:08',1,'2025-12-01 11:39:08','');
    324. 

  324. /*!40000 ALTER TABLE `sys_dict_data` ENABLE KEYS */;
    325. 

  325. UNLOCK TABLES;
    326. 

  326. 

  327. --
    328. 

  328. -- Table structure for table `sys_dict_type`
    329. 

  329. --
    330. 

  330. 

  331. DROP TABLE IF EXISTS `sys_dict_type`;
    332. 

  332. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    333. 

  333. /*!50503 SET character_set_client = utf8mb4 */;
    334. 

  334. CREATE TABLE `sys_dict_type` (
    335. 

  335.   `dict_id` bigint NOT NULL AUTO_INCREMENT COMMENT '字典主键',
    336. 

  336.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
    337. 

  337.   `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称',
    338. 

  338.   `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
    339. 

  339.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    340. 

  340.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    341. 

  341.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    342. 

  342.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    343. 

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

  344.   `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    345. 

  345.   PRIMARY KEY (`dict_id`),
    346. 

  346.   UNIQUE KEY `tenant_id` (`tenant_id`,`dict_type`)
    347. 

  347. ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典类型表';
    348. 

  348. /*!40101 SET character_set_client = @saved_cs_client */;
    349. 

  349. 

  350. --
    351. 

  351. -- Dumping data for table `sys_dict_type`
    352. 

  352. --
    353. 

  353. 

  354. LOCK TABLES `sys_dict_type` WRITE;
    355. 

  355. /*!40000 ALTER TABLE `sys_dict_type` DISABLE KEYS */;
    356. 

  356. INSERT INTO `sys_dict_type` VALUES (1,'000000','用户性别','sys_user_sex',103,1,'2025-11-26 13:39:28',NULL,NULL,'用户性别列表'),(2,'000000','菜单状态','sys_show_hide',103,1,'2025-11-26 13:39:28',NULL,NULL,'菜单状态列表'),(3,'000000','系统开关','sys_normal_disable',103,1,'2025-11-26 13:39:28',NULL,NULL,'系统开关列表'),(6,'000000','系统是否','sys_yes_no',103,1,'2025-11-26 13:39:28',NULL,NULL,'系统是否列表'),(7,'000000','通知类型','sys_notice_type',103,1,'2025-11-26 13:39:28',NULL,NULL,'通知类型列表'),(8,'000000','通知状态','sys_notice_status',103,1,'2025-11-26 13:39:28',NULL,NULL,'通知状态列表'),(9,'000000','操作类型','sys_oper_type',103,1,'2025-11-26 13:39:28',NULL,NULL,'操作类型列表'),(10,'000000','系统状态','sys_common_status',103,1,'2025-11-26 13:39:28',NULL,NULL,'登录状态列表'),(11,'000000','授权类型','sys_grant_type',103,1,'2025-11-26 13:39:28',NULL,NULL,'认证授权类型'),(12,'000000','设备类型','sys_device_type',103,1,'2025-11-26 13:39:28',NULL,NULL,'客户端设备类型'),(17,'000000','项目文档标识','project_file_specification',100,1,'2025-11-28 11:22:17',1,'2025-11-28 16:29:45','用于区分不同类型的文档'),(18,'000000','中心文档标识','center_file_specification',100,1,'2025-11-28 11:24:49',1,'2025-11-28 11:24:49','用于区分不同类型的文档'),(19,'000000','项目类型','project_type',100,1,'2025-12-01 11:26:08',1,'2025-12-01 11:26:08','这个项目的类型，用于标识搜索'),(20,'000000','项目语言','project_language',100,1,'2025-12-01 11:38:38',1,'2025-12-01 11:38:38','每个项目的语言');
    357. 

  357. /*!40000 ALTER TABLE `sys_dict_type` ENABLE KEYS */;
    358. 

  358. UNLOCK TABLES;
    359. 

  359. 

  360. --
    361. 

  361. -- Table structure for table `sys_logininfor`
    362. 

  362. --
    363. 

  363. 

  364. DROP TABLE IF EXISTS `sys_logininfor`;
    365. 

  365. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    366. 

  366. /*!50503 SET character_set_client = utf8mb4 */;
    367. 

  367. CREATE TABLE `sys_logininfor` (
    368. 

  368.   `info_id` bigint NOT NULL AUTO_INCREMENT COMMENT '访问ID',
    369. 

  369.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
    370. 

  370.   `user_name` varchar(50) DEFAULT '' COMMENT '用户账号',
    371. 

  371.   `client_key` varchar(32) DEFAULT '' COMMENT '客户端',
    372. 

  372.   `device_type` varchar(32) DEFAULT '' COMMENT '设备类型',
    373. 

  373.   `ipaddr` varchar(128) DEFAULT '' COMMENT '登录IP地址',
    374. 

  374.   `login_location` varchar(255) DEFAULT '' COMMENT '登录地点',
    375. 

  375.   `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型',
    376. 

  376.   `os` varchar(50) DEFAULT '' COMMENT '操作系统',
    377. 

  377.   `status` char(1) DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
    378. 

  378.   `msg` varchar(255) DEFAULT '' COMMENT '提示消息',
    379. 

  379.   `login_time` datetime DEFAULT NULL COMMENT '访问时间',
    380. 

  380.   PRIMARY KEY (`info_id`),
    381. 

  381.   KEY `idx_sys_logininfor_s` (`status`),
    382. 

  382.   KEY `idx_sys_logininfor_lt` (`login_time`)
    383. 

  383. ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统访问记录';
    384. 

  384. /*!40101 SET character_set_client = @saved_cs_client */;
    385. 

  385. 

  386. --
    387. 

  387. -- Dumping data for table `sys_logininfor`
    388. 

  388. --
    389. 

  389. 

  390. LOCK TABLES `sys_logininfor` WRITE;
    391. 

  391. /*!40000 ALTER TABLE `sys_logininfor` DISABLE KEYS */;
    392. 

  392. INSERT INTO `sys_logininfor` VALUES (1,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','登录成功','2025-11-26 14:13:43'),(2,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','退出成功','2025-11-26 14:17:27'),(3,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','登录成功','2025-11-26 14:17:29'),(4,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','退出成功','2025-11-26 14:21:50'),(5,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','登录成功','2025-11-26 14:21:51'),(6,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','登录成功','2025-11-26 14:24:27'),(7,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','登录成功','2025-11-26 15:01:23'),(8,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','退出成功','2025-11-26 15:10:54'),(9,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','登录成功','2025-11-26 15:10:59'),(10,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','登录成功','2025-11-28 10:55:40'),(11,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','退出成功','2025-11-28 11:18:02'),(12,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','登录成功','2025-11-28 11:18:04'),(13,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','登录成功','2025-11-28 15:05:25'),(14,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','登录成功','2025-11-28 16:25:50'),(15,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','退出成功','2025-11-28 16:30:22'),(16,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','登录成功','2025-11-28 16:30:36'),(17,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','登录成功','2025-11-28 17:15:46'),(18,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','Login successful','2025-12-01 13:58:31'),(19,'000000','admin','pc','pc','127.0.0.1','内网IP','Chrome','Windows 10 or Windows Server 2016','0','Login successful','2025-12-01 15:14:11');
    393. 

  393. /*!40000 ALTER TABLE `sys_logininfor` ENABLE KEYS */;
    394. 

  394. UNLOCK TABLES;
    395. 

  395. 

  396. --
    397. 

  397. -- Table structure for table `sys_menu`
    398. 

  398. --
    399. 

  399. 

  400. DROP TABLE IF EXISTS `sys_menu`;
    401. 

  401. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    402. 

  402. /*!50503 SET character_set_client = utf8mb4 */;
    403. 

  403. CREATE TABLE `sys_menu` (
    404. 

  404.   `menu_id` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
    405. 

  405.   `menu_name` varchar(50) NOT NULL COMMENT '菜单名称',
    406. 

  406.   `parent_id` bigint DEFAULT '0' COMMENT '父菜单ID',
    407. 

  407.   `order_num` int DEFAULT '0' COMMENT '显示顺序',
    408. 

  408.   `path` varchar(200) DEFAULT '' COMMENT '路由地址',
    409. 

  409.   `component` varchar(255) DEFAULT NULL COMMENT '组件路径',
    410. 

  410.   `query_param` varchar(255) DEFAULT NULL COMMENT '路由参数',
    411. 

  411.   `is_frame` int DEFAULT '1' COMMENT '是否为外链（0是 1否）',
    412. 

  412.   `is_cache` int DEFAULT '0' COMMENT '是否缓存（0缓存 1不缓存）',
    413. 

  413.   `menu_type` char(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
    414. 

  414.   `visible` char(1) DEFAULT '0' COMMENT '显示状态（0显示 1隐藏）',
    415. 

  415.   `status` char(1) DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
    416. 

  416.   `perms` varchar(100) DEFAULT NULL COMMENT '权限标识',
    417. 

  417.   `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标',
    418. 

  418.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    419. 

  419.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    420. 

  420.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    421. 

  421.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    422. 

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

  423.   `remark` varchar(500) DEFAULT '' COMMENT '备注',
    424. 

  424.   PRIMARY KEY (`menu_id`)
    425. 

  425. ) ENGINE=InnoDB AUTO_INCREMENT=1994324549864804363 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单权限表';
    426. 

  426. /*!40101 SET character_set_client = @saved_cs_client */;
    427. 

  427. 

  428. --
    429. 

  429. -- Dumping data for table `sys_menu`
    430. 

  430. --
    431. 

  431. 

  432. LOCK TABLES `sys_menu` WRITE;
    433. 

  433. /*!40000 ALTER TABLE `sys_menu` DISABLE KEYS */;
    434. 

  434. INSERT INTO `sys_menu` VALUES (1,'系统管理',0,1,'system',NULL,'',1,0,'M','0','0','','system',103,1,'2025-11-26 13:39:25',NULL,NULL,'系统管理目录'),(2,'系统监控',0,3,'monitor',NULL,'',1,0,'M','0','0','','monitor',103,1,'2025-11-26 13:39:25',NULL,NULL,'系统监控目录'),(3,'系统工具',0,4,'tool',NULL,'',1,0,'M','0','0','','tool',103,1,'2025-11-26 13:39:25',NULL,NULL,'系统工具目录'),(5,'测试菜单',0,5,'demo',NULL,'',1,0,'M','1','0','','star',103,1,'2025-11-26 13:39:25',1,'2025-11-26 14:25:32','测试菜单'),(6,'租户管理',0,2,'tenant',NULL,'',1,0,'M','0','0','','chart',103,1,'2025-11-26 13:39:25',NULL,NULL,'租户管理目录'),(100,'用户管理',1,1,'user','system/user/index','',1,0,'C','0','0','system:user:list','user',103,1,'2025-11-26 13:39:25',NULL,NULL,'用户管理菜单'),(101,'角色管理',1,2,'role','system/role/index','',1,0,'C','0','0','system:role:list','peoples',103,1,'2025-11-26 13:39:25',NULL,NULL,'角色管理菜单'),(102,'菜单管理',1,3,'menu','system/menu/index','',1,0,'C','0','0','system:menu:list','tree-table',103,1,'2025-11-26 13:39:25',NULL,NULL,'菜单管理菜单'),(103,'部门管理',1,4,'dept','system/dept/index','',1,0,'C','0','0','system:dept:list','tree',103,1,'2025-11-26 13:39:25',NULL,NULL,'部门管理菜单'),(104,'岗位管理',1,5,'post','system/post/index','',1,0,'C','0','0','system:post:list','post',103,1,'2025-11-26 13:39:25',NULL,NULL,'岗位管理菜单'),(105,'字典管理',1,6,'dict','system/dict/index','',1,0,'C','0','0','system:dict:list','dict',103,1,'2025-11-26 13:39:25',NULL,NULL,'字典管理菜单'),(106,'参数设置',1,7,'config','system/config/index','',1,0,'C','1','0','system:config:list','edit',103,1,'2025-11-26 13:39:25',1,'2025-12-01 16:31:31','参数设置菜单'),(107,'通知公告',1,8,'notice','system/notice/index','',1,0,'C','1','0','system:notice:list','message',103,1,'2025-11-26 13:39:25',1,'2025-11-26 14:25:54','通知公告菜单'),(108,'日志管理',1,9,'log','','',1,0,'M','1','0','','log',103,1,'2025-11-26 13:39:25',1,'2025-11-26 14:26:56','日志管理菜单'),(109,'在线用户',2,1,'online','monitor/online/index','',1,0,'C','0','0','monitor:online:list','online',103,1,'2025-11-26 13:39:25',NULL,NULL,'在线用户菜单'),(113,'缓存监控',2,5,'cache','monitor/cache/index','',1,0,'C','1','0','monitor:cache:list','redis',103,1,'2025-11-26 13:39:25',1,'2025-11-26 14:25:37','缓存监控菜单'),(115,'代码生成',3,2,'gen','tool/gen/index','',1,0,'C','0','0','tool:gen:list','code',103,1,'2025-11-26 13:39:25',NULL,NULL,'代码生成菜单'),(116,'修改生成配置',3,2,'gen-edit/index/:tableId','tool/gen/editTable','',1,1,'C','1','0','tool:gen:edit','#',103,1,'2025-11-26 13:39:25',NULL,NULL,'/tool/gen'),(117,'Admin监控',2,5,'Admin','monitor/admin/index','',1,0,'C','1','0','monitor:admin:list','dashboard',103,1,'2025-11-26 13:39:25',1,'2025-11-26 14:25:40','Admin监控菜单'),(118,'文件管理',1,10,'oss','system/oss/index','',1,0,'C','0','0','system:oss:list','upload',103,1,'2025-11-26 13:39:25',NULL,NULL,'文件管理菜单'),(120,'任务调度中心',2,6,'snailjob','monitor/snailjob/index','',1,0,'C','1','0','monitor:snailjob:list','job',103,1,'2025-11-26 13:39:25',1,'2025-11-26 14:25:44','SnailJob控制台菜单'),(121,'租户管理',6,1,'tenant','system/tenant/index','',1,0,'C','0','0','system:tenant:list','list',103,1,'2025-11-26 13:39:25',NULL,NULL,'租户管理菜单'),(122,'租户套餐管理',6,2,'tenantPackage','system/tenantPackage/index','',1,0,'C','0','0','system:tenantPackage:list','form',103,1,'2025-11-26 13:39:25',NULL,NULL,'租户套餐管理菜单'),(123,'客户端管理',1,11,'client','system/client/index','',1,0,'C','0','0','system:client:list','international',103,1,'2025-11-26 13:39:25',NULL,NULL,'客户端管理菜单'),(130,'分配用户',1,2,'role-auth/user/:roleId','system/role/authUser','',1,1,'C','1','0','system:role:edit','#',103,1,'2025-11-26 13:39:25',NULL,NULL,'/system/role'),(131,'分配角色',1,1,'user-auth/role/:userId','system/user/authRole','',1,1,'C','1','0','system:user:edit','#',103,1,'2025-11-26 13:39:25',NULL,NULL,'/system/user'),(132,'字典数据',1,6,'dict-data/index/:dictId','system/dict/data','',1,1,'C','1','0','system:dict:list','#',103,1,'2025-11-26 13:39:25',NULL,NULL,'/system/dict'),(133,'文件配置管理',1,10,'oss-config/index','system/oss/config','',1,1,'C','1','0','system:ossConfig:list','#',103,1,'2025-11-26 13:39:25',NULL,NULL,'/system/oss'),(500,'操作日志',108,1,'operlog','monitor/operlog/index','',1,0,'C','0','0','monitor:operlog:list','form',103,1,'2025-11-26 13:39:25',NULL,NULL,'操作日志菜单'),(501,'登录日志',108,2,'logininfor','monitor/logininfor/index','',1,0,'C','0','0','monitor:logininfor:list','logininfor',103,1,'2025-11-26 13:39:25',NULL,NULL,'登录日志菜单'),(1001,'用户查询',100,1,'','','',1,0,'F','0','0','system:user:query','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1002,'用户新增',100,2,'','','',1,0,'F','0','0','system:user:add','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1003,'用户修改',100,3,'','','',1,0,'F','0','0','system:user:edit','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1004,'用户删除',100,4,'','','',1,0,'F','0','0','system:user:remove','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1005,'用户导出',100,5,'','','',1,0,'F','0','0','system:user:export','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1006,'用户导入',100,6,'','','',1,0,'F','0','0','system:user:import','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1007,'重置密码',100,7,'','','',1,0,'F','0','0','system:user:resetPwd','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1008,'角色查询',101,1,'','','',1,0,'F','0','0','system:role:query','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1009,'角色新增',101,2,'','','',1,0,'F','0','0','system:role:add','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1010,'角色修改',101,3,'','','',1,0,'F','0','0','system:role:edit','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1011,'角色删除',101,4,'','','',1,0,'F','0','0','system:role:remove','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1012,'角色导出',101,5,'','','',1,0,'F','0','0','system:role:export','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1013,'菜单查询',102,1,'','','',1,0,'F','0','0','system:menu:query','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1014,'菜单新增',102,2,'','','',1,0,'F','0','0','system:menu:add','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1015,'菜单修改',102,3,'','','',1,0,'F','0','0','system:menu:edit','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1016,'菜单删除',102,4,'','','',1,0,'F','0','0','system:menu:remove','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1017,'部门查询',103,1,'','','',1,0,'F','0','0','system:dept:query','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1018,'部门新增',103,2,'','','',1,0,'F','0','0','system:dept:add','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1019,'部门修改',103,3,'','','',1,0,'F','0','0','system:dept:edit','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1020,'部门删除',103,4,'','','',1,0,'F','0','0','system:dept:remove','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1021,'岗位查询',104,1,'','','',1,0,'F','0','0','system:post:query','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1022,'岗位新增',104,2,'','','',1,0,'F','0','0','system:post:add','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1023,'岗位修改',104,3,'','','',1,0,'F','0','0','system:post:edit','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1024,'岗位删除',104,4,'','','',1,0,'F','0','0','system:post:remove','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1025,'岗位导出',104,5,'','','',1,0,'F','0','0','system:post:export','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1026,'字典查询',105,1,'#','','',1,0,'F','0','0','system:dict:query','#',103,1,'2025-11-26 13:39:25',NULL,NULL,''),(1027,'字典新增',105,2,'#','','',1,0,'F','0','0','system:dict:add','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1028,'字典修改',105,3,'#','','',1,0,'F','0','0','system:dict:edit','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1029,'字典删除',105,4,'#','','',1,0,'F','0','0','system:dict:remove','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1030,'字典导出',105,5,'#','','',1,0,'F','0','0','system:dict:export','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1031,'参数查询',106,1,'#','','',1,0,'F','0','0','system:config:query','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1032,'参数新增',106,2,'#','','',1,0,'F','0','0','system:config:add','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1033,'参数修改',106,3,'#','','',1,0,'F','0','0','system:config:edit','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1034,'参数删除',106,4,'#','','',1,0,'F','0','0','system:config:remove','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1035,'参数导出',106,5,'#','','',1,0,'F','0','0','system:config:export','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1036,'公告查询',107,1,'#','','',1,0,'F','0','0','system:notice:query','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1037,'公告新增',107,2,'#','','',1,0,'F','0','0','system:notice:add','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1038,'公告修改',107,3,'#','','',1,0,'F','0','0','system:notice:edit','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1039,'公告删除',107,4,'#','','',1,0,'F','0','0','system:notice:remove','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1040,'操作查询',500,1,'#','','',1,0,'F','0','0','monitor:operlog:query','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1041,'操作删除',500,2,'#','','',1,0,'F','0','0','monitor:operlog:remove','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1042,'日志导出',500,4,'#','','',1,0,'F','0','0','monitor:operlog:export','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1043,'登录查询',501,1,'#','','',1,0,'F','0','0','monitor:logininfor:query','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1044,'登录删除',501,2,'#','','',1,0,'F','0','0','monitor:logininfor:remove','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1045,'日志导出',501,3,'#','','',1,0,'F','0','0','monitor:logininfor:export','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1046,'在线查询',109,1,'#','','',1,0,'F','0','0','monitor:online:query','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1047,'批量强退',109,2,'#','','',1,0,'F','0','0','monitor:online:batchLogout','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1048,'单条强退',109,3,'#','','',1,0,'F','0','0','monitor:online:forceLogout','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1050,'账户解锁',501,4,'#','','',1,0,'F','0','0','monitor:logininfor:unlock','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1055,'生成查询',115,1,'#','','',1,0,'F','0','0','tool:gen:query','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1056,'生成修改',115,2,'#','','',1,0,'F','0','0','tool:gen:edit','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1057,'生成删除',115,3,'#','','',1,0,'F','0','0','tool:gen:remove','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1058,'导入代码',115,2,'#','','',1,0,'F','0','0','tool:gen:import','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1059,'预览代码',115,4,'#','','',1,0,'F','0','0','tool:gen:preview','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1060,'生成代码',115,5,'#','','',1,0,'F','0','0','tool:gen:code','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1061,'客户端管理查询',123,1,'#','','',1,0,'F','0','0','system:client:query','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1062,'客户端管理新增',123,2,'#','','',1,0,'F','0','0','system:client:add','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1063,'客户端管理修改',123,3,'#','','',1,0,'F','0','0','system:client:edit','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1064,'客户端管理删除',123,4,'#','','',1,0,'F','0','0','system:client:remove','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1065,'客户端管理导出',123,5,'#','','',1,0,'F','0','0','system:client:export','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1500,'测试单表',5,1,'demo','demo/demo/index','',1,0,'C','0','0','demo:demo:list','#',103,1,'2025-11-26 13:39:26',NULL,NULL,'测试单表菜单'),(1501,'测试单表查询',1500,1,'#','','',1,0,'F','0','0','demo:demo:query','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1502,'测试单表新增',1500,2,'#','','',1,0,'F','0','0','demo:demo:add','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1503,'测试单表修改',1500,3,'#','','',1,0,'F','0','0','demo:demo:edit','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1504,'测试单表删除',1500,4,'#','','',1,0,'F','0','0','demo:demo:remove','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1505,'测试单表导出',1500,5,'#','','',1,0,'F','0','0','demo:demo:export','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1506,'测试树表',5,1,'tree','demo/tree/index','',1,0,'C','0','0','demo:tree:list','#',103,1,'2025-11-26 13:39:26',NULL,NULL,'测试树表菜单'),(1507,'测试树表查询',1506,1,'#','','',1,0,'F','0','0','demo:tree:query','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1508,'测试树表新增',1506,2,'#','','',1,0,'F','0','0','demo:tree:add','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1509,'测试树表修改',1506,3,'#','','',1,0,'F','0','0','demo:tree:edit','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1510,'测试树表删除',1506,4,'#','','',1,0,'F','0','0','demo:tree:remove','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1511,'测试树表导出',1506,5,'#','','',1,0,'F','0','0','demo:tree:export','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1600,'文件查询',118,1,'#','','',1,0,'F','0','0','system:oss:query','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1601,'文件上传',118,2,'#','','',1,0,'F','0','0','system:oss:upload','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1602,'文件下载',118,3,'#','','',1,0,'F','0','0','system:oss:download','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1603,'文件删除',118,4,'#','','',1,0,'F','0','0','system:oss:remove','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1606,'租户查询',121,1,'#','','',1,0,'F','0','0','system:tenant:query','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1607,'租户新增',121,2,'#','','',1,0,'F','0','0','system:tenant:add','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1608,'租户修改',121,3,'#','','',1,0,'F','0','0','system:tenant:edit','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1609,'租户删除',121,4,'#','','',1,0,'F','0','0','system:tenant:remove','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1610,'租户导出',121,5,'#','','',1,0,'F','0','0','system:tenant:export','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1611,'租户套餐查询',122,1,'#','','',1,0,'F','0','0','system:tenantPackage:query','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1612,'租户套餐新增',122,2,'#','','',1,0,'F','0','0','system:tenantPackage:add','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1613,'租户套餐修改',122,3,'#','','',1,0,'F','0','0','system:tenantPackage:edit','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1614,'租户套餐删除',122,4,'#','','',1,0,'F','0','0','system:tenantPackage:remove','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1615,'租户套餐导出',122,5,'#','','',1,0,'F','0','0','system:tenantPackage:export','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1620,'配置列表',118,5,'#','','',1,0,'F','0','0','system:ossConfig:list','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1621,'配置添加',118,6,'#','','',1,0,'F','0','0','system:ossConfig:add','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1622,'配置编辑',118,6,'#','','',1,0,'F','0','0','system:ossConfig:edit','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1623,'配置删除',118,6,'#','','',1,0,'F','0','0','system:ossConfig:remove','#',103,1,'2025-11-26 13:39:26',NULL,NULL,''),(1624,'项目管理',0,7,'project',NULL,NULL,1,0,'M','0','0',NULL,'zip',100,1,'2025-11-26 16:37:07',1,'2025-12-01 10:59:56',''),(1625,'文档管理',0,8,'document',NULL,NULL,1,0,'M','0','0',NULL,'documentation',100,1,'2025-11-26 16:45:26',1,'2025-12-01 10:59:59',''),(1994324549864804354,'小程序设置',0,9999,'applet','setting/applet/index',NULL,1,0,'C','0','0','setting:applet:list','category',103,1,'2025-11-28 16:37:51',1,'2025-12-01 11:03:48','小程序设置菜单'),(1994324549864804355,'小程序设置查询',1994324549864804354,1,'#','',NULL,1,0,'F','0','0','setting:applet:query','#',103,1,'2025-11-28 16:37:51',NULL,NULL,''),(1994324549864804357,'小程序设置修改',1994324549864804354,2,'#','',NULL,1,0,'F','0','0','setting:applet:edit','#',103,1,'2025-11-28 16:37:51',1,'2025-11-28 17:16:26',''),(1994324549864804360,'仪表盘',0,6,'dashBoard',NULL,NULL,1,0,'M','0','0',NULL,'time',100,1,'2025-12-01 11:01:05',1,'2025-12-01 11:01:05',''),(1994324549864804361,'文件检索',0,9,'search',NULL,NULL,1,0,'M','0','0',NULL,'search',100,1,'2025-12-01 11:01:41',1,'2025-12-01 11:03:54',''),(1994324549864804362,'文件质控',0,10,'quality',NULL,NULL,1,0,'M','0','0',NULL,'workflow',100,1,'2025-12-01 11:02:36',1,'2025-12-01 11:02:36','');
    435. 

  435. /*!40000 ALTER TABLE `sys_menu` ENABLE KEYS */;
    436. 

  436. UNLOCK TABLES;
    437. 

  437. 

  438. --
    439. 

  439. -- Table structure for table `sys_notice`
    440. 

  440. --
    441. 

  441. 

  442. DROP TABLE IF EXISTS `sys_notice`;
    443. 

  443. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    444. 

  444. /*!50503 SET character_set_client = utf8mb4 */;
    445. 

  445. CREATE TABLE `sys_notice` (
    446. 

  446.   `notice_id` bigint NOT NULL AUTO_INCREMENT COMMENT '公告ID',
    447. 

  447.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
    448. 

  448.   `notice_title` varchar(50) NOT NULL COMMENT '公告标题',
    449. 

  449.   `notice_type` char(1) NOT NULL COMMENT '公告类型（1通知 2公告）',
    450. 

  450.   `notice_content` longblob COMMENT '公告内容',
    451. 

  451.   `status` char(1) DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
    452. 

  452.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    453. 

  453.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    454. 

  454.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    455. 

  455.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    456. 

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

  457.   `remark` varchar(255) DEFAULT NULL COMMENT '备注',
    458. 

  458.   PRIMARY KEY (`notice_id`)
    459. 

  459. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='通知公告表';
    460. 

  460. /*!40101 SET character_set_client = @saved_cs_client */;
    461. 

  461. 

  462. --
    463. 

  463. -- Dumping data for table `sys_notice`
    464. 

  464. --
    465. 

  465. 

  466. LOCK TABLES `sys_notice` WRITE;
    467. 

  467. /*!40000 ALTER TABLE `sys_notice` DISABLE KEYS */;
    468. 

  468. INSERT INTO `sys_notice` VALUES (1,'000000','温馨提醒：2018-07-01 新版本发布啦','2',_binary '新版本内容','0',103,1,'2025-11-26 13:39:29',NULL,NULL,'管理员'),(2,'000000','维护通知：2018-07-01 系统凌晨维护','1',_binary '维护内容','0',103,1,'2025-11-26 13:39:29',NULL,NULL,'管理员');
    469. 

  469. /*!40000 ALTER TABLE `sys_notice` ENABLE KEYS */;
    470. 

  470. UNLOCK TABLES;
    471. 

  471. 

  472. --
    473. 

  473. -- Table structure for table `sys_oper_log`
    474. 

  474. --
    475. 

  475. 

  476. DROP TABLE IF EXISTS `sys_oper_log`;
    477. 

  477. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    478. 

  478. /*!50503 SET character_set_client = utf8mb4 */;
    479. 

  479. CREATE TABLE `sys_oper_log` (
    480. 

  480.   `oper_id` bigint NOT NULL AUTO_INCREMENT COMMENT '日志主键',
    481. 

  481.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
    482. 

  482.   `title` varchar(50) DEFAULT '' COMMENT '模块标题',
    483. 

  483.   `business_type` int DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',
    484. 

  484.   `method` varchar(100) DEFAULT '' COMMENT '方法名称',
    485. 

  485.   `request_method` varchar(10) DEFAULT '' COMMENT '请求方式',
    486. 

  486.   `operator_type` int DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
    487. 

  487.   `oper_name` varchar(50) DEFAULT '' COMMENT '操作人员',
    488. 

  488.   `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称',
    489. 

  489.   `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL',
    490. 

  490.   `oper_ip` varchar(128) DEFAULT '' COMMENT '主机地址',
    491. 

  491.   `oper_location` varchar(255) DEFAULT '' COMMENT '操作地点',
    492. 

  492.   `oper_param` varchar(4000) DEFAULT '' COMMENT '请求参数',
    493. 

  493.   `json_result` varchar(4000) DEFAULT '' COMMENT '返回参数',
    494. 

  494.   `status` int DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
    495. 

  495.   `error_msg` varchar(4000) DEFAULT '' COMMENT '错误消息',
    496. 

  496.   `oper_time` datetime DEFAULT NULL COMMENT '操作时间',
    497. 

  497.   `cost_time` bigint DEFAULT '0' COMMENT '消耗时间',
    498. 

  498.   PRIMARY KEY (`oper_id`),
    499. 

  499.   KEY `idx_sys_oper_log_bt` (`business_type`),
    500. 

  500.   KEY `idx_sys_oper_log_s` (`status`),
    501. 

  501.   KEY `idx_sys_oper_log_ot` (`oper_time`)
    502. 

  502. ) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='操作日志记录';
    503. 

  503. /*!40101 SET character_set_client = @saved_cs_client */;
    504. 

  504. 

  505. --
    506. 

  506. -- Dumping data for table `sys_oper_log`
    507. 

  507. --
    508. 

  508. 

  509. LOCK TABLES `sys_oper_log` WRITE;
    510. 

  510. /*!40000 ALTER TABLE `sys_oper_log` DISABLE KEYS */;
    511. 

  511. INSERT INTO `sys_oper_log` VALUES (1,'000000','个人信息',2,'org.dromara.system.controller.system.SysProfileController.updateProfile()','PUT',1,'admin','研发部门','/system/user/profile','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"nickName\":\"系统管理员\",\"email\":\"admin@gmail.com\",\"phonenumber\":\"15888888888\",\"sex\":\"0\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 14:18:06',71),(2,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','','/system/menu','127.0.0.1','内网IP','{\"createDept\":103,\"createBy\":null,\"createTime\":\"2025-11-26 13:39:25\",\"updateBy\":null,\"updateTime\":null,\"menuId\":5,\"parentId\":0,\"menuName\":\"测试菜单\",\"orderNum\":5,\"path\":\"demo\",\"component\":null,\"queryParam\":\"\",\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"M\",\"visible\":\"1\",\"status\":\"0\",\"perms\":\"\",\"icon\":\"star\",\"remark\":\"测试菜单\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 14:25:32',56),(3,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','','/system/menu','127.0.0.1','内网IP','{\"createDept\":103,\"createBy\":null,\"createTime\":\"2025-11-26 13:39:25\",\"updateBy\":null,\"updateTime\":null,\"menuId\":113,\"parentId\":2,\"menuName\":\"缓存监控\",\"orderNum\":5,\"path\":\"cache\",\"component\":\"monitor/cache/index\",\"queryParam\":\"\",\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"C\",\"visible\":\"1\",\"status\":\"0\",\"perms\":\"monitor:cache:list\",\"icon\":\"redis\",\"remark\":\"缓存监控菜单\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 14:25:37',28),(4,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','','/system/menu','127.0.0.1','内网IP','{\"createDept\":103,\"createBy\":null,\"createTime\":\"2025-11-26 13:39:25\",\"updateBy\":null,\"updateTime\":null,\"menuId\":117,\"parentId\":2,\"menuName\":\"Admin监控\",\"orderNum\":5,\"path\":\"Admin\",\"component\":\"monitor/admin/index\",\"queryParam\":\"\",\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"C\",\"visible\":\"1\",\"status\":\"0\",\"perms\":\"monitor:admin:list\",\"icon\":\"dashboard\",\"remark\":\"Admin监控菜单\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 14:25:40',27),(5,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','','/system/menu','127.0.0.1','内网IP','{\"createDept\":103,\"createBy\":null,\"createTime\":\"2025-11-26 13:39:25\",\"updateBy\":null,\"updateTime\":null,\"menuId\":120,\"parentId\":2,\"menuName\":\"任务调度中心\",\"orderNum\":6,\"path\":\"snailjob\",\"component\":\"monitor/snailjob/index\",\"queryParam\":\"\",\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"C\",\"visible\":\"1\",\"status\":\"0\",\"perms\":\"monitor:snailjob:list\",\"icon\":\"job\",\"remark\":\"SnailJob控制台菜单\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 14:25:44',14),(6,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','','/system/menu','127.0.0.1','内网IP','{\"createDept\":103,\"createBy\":null,\"createTime\":\"2025-11-26 13:39:25\",\"updateBy\":null,\"updateTime\":null,\"menuId\":107,\"parentId\":1,\"menuName\":\"通知公告\",\"orderNum\":8,\"path\":\"notice\",\"component\":\"system/notice/index\",\"queryParam\":\"\",\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"C\",\"visible\":\"1\",\"status\":\"0\",\"perms\":\"system:notice:list\",\"icon\":\"message\",\"remark\":\"通知公告菜单\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 14:25:54',45),(7,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','','/system/menu','127.0.0.1','内网IP','{\"createDept\":103,\"createBy\":null,\"createTime\":\"2025-11-26 13:39:25\",\"updateBy\":null,\"updateTime\":null,\"menuId\":108,\"parentId\":1,\"menuName\":\"日志管理\",\"orderNum\":9,\"path\":\"log\",\"component\":\"\",\"queryParam\":\"\",\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"M\",\"visible\":\"1\",\"status\":\"0\",\"perms\":\"\",\"icon\":\"log\",\"remark\":\"日志管理菜单\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 14:26:56',54),(8,'000000','对象存储状态修改',2,'org.dromara.system.controller.system.SysOssConfigController.changeStatus()','PUT',1,'admin','','/resource/oss/config/changeStatus','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"ossConfigId\":1,\"configKey\":\"minio\",\"accessKey\":null,\"secretKey\":null,\"bucketName\":null,\"prefix\":null,\"endpoint\":null,\"domain\":null,\"isHttps\":null,\"status\":\"1\",\"region\":null,\"ext1\":null,\"remark\":null,\"accessPolicy\":null}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 14:27:06',63),(9,'000000','对象存储状态修改',2,'org.dromara.system.controller.system.SysOssConfigController.changeStatus()','PUT',1,'admin','','/resource/oss/config/changeStatus','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"ossConfigId\":2,\"configKey\":\"qiniu\",\"accessKey\":null,\"secretKey\":null,\"bucketName\":null,\"prefix\":null,\"endpoint\":null,\"domain\":null,\"isHttps\":null,\"status\":\"0\",\"region\":null,\"ext1\":null,\"remark\":null,\"accessPolicy\":null}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 14:27:08',9),(10,'000000','对象存储配置',2,'org.dromara.system.controller.system.SysOssConfigController.edit()','PUT',1,'admin','','/resource/oss/config','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"ossConfigId\":2,\"configKey\":\"qiniu\",\"accessKey\":\"2XFWgtUdiNwKonHUc7Yitl6AjTBXelR2rYZJDR7b\",\"secretKey\":\"2bYou-FJVKaf4xckk1Bo7PiPkXojbY__BRV3mOII\",\"bucketName\":\"img-tpidea\",\"prefix\":\"\",\"endpoint\":\"s3.cn-south-1.qiniucs.com\",\"domain\":\"img.tpidea.cn\",\"isHttps\":\"N\",\"status\":\"0\",\"region\":\"\",\"ext1\":\"\",\"remark\":null,\"accessPolicy\":\"1\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 14:27:48',37),(11,'000000','OSS对象存储',1,'org.dromara.system.controller.system.SysOssController.upload()','POST',1,'admin','','/resource/oss/upload','127.0.0.1','内网IP','','{\"code\":200,\"msg\":\"操作成功\",\"data\":{\"url\":\"http://img.tpidea.cn/2025/11/26/f3afc984dff94d0f8f9a3368b0ba6c76.jpg\",\"fileName\":\"头像.jpg\",\"ossId\":\"1\"}}',0,'','2025-11-26 14:28:20',1902),(12,'000000','字典类型',1,'org.dromara.system.controller.system.SysDictTypeController.add()','POST',1,'admin','公司','/system/dict/type','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictId\":null,\"dictName\":\"小程序登录状态\",\"dictType\":\"applet_login_status\",\"remark\":\"是否允许小程序登录\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 15:38:21',58),(13,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":1,\"dictLabel\":\"允许\",\"dictValue\":\"0\",\"dictType\":\"applet_login_status\",\"cssClass\":\"\",\"listClass\":\"success\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 15:38:37',54),(14,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":2,\"dictLabel\":\"禁止\",\"dictValue\":\"1\",\"dictType\":\"applet_login_status\",\"cssClass\":\"\",\"listClass\":\"danger\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 15:38:50',66),(15,'000000','字典类型',3,'org.dromara.system.controller.system.SysDictDataController.remove()','DELETE',1,'admin','公司','/system/dict/data/40','127.0.0.1','内网IP','[40]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 15:40:21',42),(16,'000000','字典类型',3,'org.dromara.system.controller.system.SysDictDataController.remove()','DELETE',1,'admin','公司','/system/dict/data/39','127.0.0.1','内网IP','[39]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 15:40:22',47),(17,'000000','字典类型',3,'org.dromara.system.controller.system.SysDictTypeController.remove()','DELETE',1,'admin','公司','/system/dict/type/13','127.0.0.1','内网IP','[13]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 15:40:25',21),(18,'000000','字典类型',1,'org.dromara.system.controller.system.SysDictTypeController.add()','POST',1,'admin','公司','/system/dict/type','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictId\":null,\"dictName\":\"文件目录类型\",\"dictType\":\"file_folder_type\",\"remark\":\"文件的目录类型\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 16:02:12',122),(19,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":1,\"dictLabel\":\"项目\",\"dictValue\":\"0\",\"dictType\":\"file_folder_type\",\"cssClass\":\"\",\"listClass\":\"primary\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 16:02:28',61),(20,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":2,\"dictLabel\":\"中心\",\"dictValue\":\"1\",\"dictType\":\"file_folder_type\",\"cssClass\":\"\",\"listClass\":\"primary\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 16:02:43',51),(21,'000000','字典类型',1,'org.dromara.system.controller.system.SysDictTypeController.add()','POST',1,'admin','公司','/system/dict/type','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictId\":null,\"dictName\":\"文件类型\",\"dictType\":\"file_type\",\"remark\":\"上传的文件类型\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 16:03:53',39),(22,'000000','菜单管理',1,'org.dromara.system.controller.system.SysMenuController.add()','POST',1,'admin','公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"menuId\":null,\"parentId\":0,\"menuName\":\"项目管理\",\"orderNum\":6,\"path\":\"project\",\"component\":null,\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"M\",\"visible\":\"0\",\"status\":\"0\",\"icon\":\"zip\",\"remark\":null}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 16:37:07',40),(23,'000000','菜单管理',1,'org.dromara.system.controller.system.SysMenuController.add()','POST',1,'admin','公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"menuId\":null,\"parentId\":0,\"menuName\":\"文档管理\",\"orderNum\":7,\"path\":\"document\",\"component\":null,\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"M\",\"visible\":\"0\",\"status\":\"0\",\"icon\":\"documentation\",\"remark\":null}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-26 16:45:26',27),(24,'000000','字典类型',1,'org.dromara.system.controller.system.SysDictTypeController.add()','POST',1,'admin','总公司','/system/dict/type','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictId\":null,\"dictName\":\"文档状态\",\"dictType\":\"file_status\",\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 10:56:03',42),(25,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":1,\"dictLabel\":\"待归档\",\"dictValue\":\"0\",\"dictType\":\"file_status\",\"cssClass\":\"\",\"listClass\":\"info\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 10:56:42',43),(26,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":2,\"dictLabel\":\"待审核\",\"dictValue\":\"1\",\"dictType\":\"file_status\",\"cssClass\":\"\",\"listClass\":\"warning\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 10:57:14',65),(27,'000000','字典数据',2,'org.dromara.system.controller.system.SysDictDataController.edit()','PUT',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":\"2025-11-28 10:56:42\",\"updateBy\":null,\"updateTime\":null,\"dictCode\":43,\"dictSort\":1,\"dictLabel\":\"待上传\",\"dictValue\":\"0\",\"dictType\":\"file_status\",\"cssClass\":\"\",\"listClass\":\"info\",\"isDefault\":\"N\",\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 10:57:32',30),(28,'000000','字典数据',2,'org.dromara.system.controller.system.SysDictDataController.edit()','PUT',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":\"2025-11-28 10:57:14\",\"updateBy\":null,\"updateTime\":null,\"dictCode\":44,\"dictSort\":2,\"dictLabel\":\"待归档\",\"dictValue\":\"1\",\"dictType\":\"file_status\",\"cssClass\":\"\",\"listClass\":\"warning\",\"isDefault\":\"N\",\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 10:58:09',49),(29,'000000','字典数据',2,'org.dromara.system.controller.system.SysDictDataController.edit()','PUT',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":\"2025-11-28 10:57:14\",\"updateBy\":null,\"updateTime\":null,\"dictCode\":44,\"dictSort\":2,\"dictLabel\":\"待归档\",\"dictValue\":\"1\",\"dictType\":\"file_status\",\"cssClass\":\"\",\"listClass\":\"danger\",\"isDefault\":\"N\",\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 10:58:24',40),(30,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":0,\"dictLabel\":\"待审核\",\"dictValue\":\"2\",\"dictType\":\"file_status\",\"cssClass\":\"\",\"listClass\":\"warning\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 10:58:33',38),(31,'000000','字典数据',2,'org.dromara.system.controller.system.SysDictDataController.edit()','PUT',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":\"2025-11-28 10:58:33\",\"updateBy\":null,\"updateTime\":null,\"dictCode\":45,\"dictSort\":3,\"dictLabel\":\"待审核\",\"dictValue\":\"2\",\"dictType\":\"file_status\",\"cssClass\":\"\",\"listClass\":\"warning\",\"isDefault\":\"N\",\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 10:58:40',22),(32,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":4,\"dictLabel\":\"已归档\",\"dictValue\":\"3\",\"dictType\":\"file_status\",\"cssClass\":\"\",\"listClass\":\"success\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 10:58:58',37),(33,'000000','字典数据',2,'org.dromara.system.controller.system.SysDictDataController.edit()','PUT',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":\"2025-11-28 10:57:14\",\"updateBy\":null,\"updateTime\":null,\"dictCode\":44,\"dictSort\":2,\"dictLabel\":\"待归档\",\"dictValue\":\"1\",\"dictType\":\"file_status\",\"cssClass\":\"\",\"listClass\":\"primary\",\"isDefault\":\"N\",\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 10:59:06',57),(34,'000000','字典类型',3,'org.dromara.system.controller.system.SysDictDataController.remove()','DELETE',1,'admin','总公司','/system/dict/data/46','127.0.0.1','内网IP','[46]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:12:13',41),(35,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":3,\"dictLabel\":\"已归档\",\"dictValue\":\"3\",\"dictType\":\"file_status\",\"cssClass\":\"\",\"listClass\":\"success\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:12:29',35),(36,'000000','字典数据',2,'org.dromara.system.controller.system.SysDictDataController.edit()','PUT',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":\"2025-11-28 11:12:29\",\"updateBy\":null,\"updateTime\":null,\"dictCode\":47,\"dictSort\":4,\"dictLabel\":\"已归档\",\"dictValue\":\"3\",\"dictType\":\"file_status\",\"cssClass\":\"\",\"listClass\":\"success\",\"isDefault\":\"N\",\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:12:33',22),(37,'000000','字典类型',3,'org.dromara.system.controller.system.SysDictDataController.remove()','DELETE',1,'admin','总公司','/system/dict/data/47','127.0.0.1','内网IP','[47]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:12:52',30),(38,'000000','字典类型',3,'org.dromara.system.controller.system.SysDictDataController.remove()','DELETE',1,'admin','总公司','/system/dict/data/45','127.0.0.1','内网IP','[45]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:12:54',15),(39,'000000','字典类型',3,'org.dromara.system.controller.system.SysDictDataController.remove()','DELETE',1,'admin','总公司','/system/dict/data/44','127.0.0.1','内网IP','[44]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:12:56',43),(40,'000000','字典类型',3,'org.dromara.system.controller.system.SysDictDataController.remove()','DELETE',1,'admin','总公司','/system/dict/data/43','127.0.0.1','内网IP','[43]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:12:58',31),(41,'000000','字典类型',3,'org.dromara.system.controller.system.SysDictTypeController.remove()','DELETE',1,'admin','总公司','/system/dict/type/16','127.0.0.1','内网IP','[16]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:13:00',54),(42,'000000','客户端管理',3,'org.dromara.system.controller.system.SysClientController.remove()','DELETE',1,'admin','总公司','/system/client/2','127.0.0.1','内网IP','[2]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:16:20',27),(43,'000000','客户端管理',1,'org.dromara.system.controller.system.SysClientController.add()','POST',1,'admin','总公司','/system/client','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"id\":3,\"clientId\":null,\"clientKey\":\"applet\",\"clientSecret\":\"applet123\",\"grantTypeList\":[\"social\"],\"grantType\":null,\"deviceType\":\"xcx\",\"activeTimeout\":604800,\"timeout\":2592000,\"status\":\"0\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:17:40',34),(44,'000000','客户端管理',2,'org.dromara.system.controller.system.SysClientController.edit()','PUT',1,'admin','总公司','/system/client','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"id\":1,\"clientId\":\"e5cd7e4891bf95d1d19206ce24a7b32e\",\"clientKey\":\"pc\",\"clientSecret\":\"pc123\",\"grantTypeList\":[\"password\"],\"grantType\":\"password,social\",\"deviceType\":\"pc\",\"activeTimeout\":1800,\"timeout\":604800,\"status\":\"0\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:17:47',28),(45,'000000','客户端管理',2,'org.dromara.system.controller.system.SysClientController.edit()','PUT',1,'admin','总公司','/system/client','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"id\":1,\"clientId\":\"e5cd7e4891bf95d1d19206ce24a7b32e\",\"clientKey\":\"pc\",\"clientSecret\":\"pc123\",\"grantTypeList\":[\"password\",\"sms\"],\"grantType\":\"password\",\"deviceType\":\"pc\",\"activeTimeout\":1800,\"timeout\":604800,\"status\":\"0\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:17:57',25),(46,'000000','字典类型',3,'org.dromara.system.controller.system.SysDictTypeController.remove()','DELETE',1,'admin','总公司','/system/dict/type/15','127.0.0.1','内网IP','[15]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:18:24',31),(47,'000000','字典类型',3,'org.dromara.system.controller.system.SysDictDataController.remove()','DELETE',1,'admin','总公司','/system/dict/data/42','127.0.0.1','内网IP','[42]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:18:35',29),(48,'000000','字典类型',3,'org.dromara.system.controller.system.SysDictDataController.remove()','DELETE',1,'admin','总公司','/system/dict/data/41','127.0.0.1','内网IP','[41]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:18:37',28),(49,'000000','字典类型',3,'org.dromara.system.controller.system.SysDictTypeController.remove()','DELETE',1,'admin','总公司','/system/dict/type/14','127.0.0.1','内网IP','[14]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:18:39',31),(50,'000000','字典类型',1,'org.dromara.system.controller.system.SysDictTypeController.add()','POST',1,'admin','总公司','/system/dict/type','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictId\":null,\"dictName\":\"文档标识\",\"dictType\":\"file_specification\",\"remark\":\"用于区分不同类型文档\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:22:17',30),(51,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":1,\"dictLabel\":\"基本文档\",\"dictValue\":\"0\",\"dictType\":\"file_specification\",\"cssClass\":\"\",\"listClass\":\"info\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:22:42',36),(52,'000000','字典类型',3,'org.dromara.system.controller.system.SysDictDataController.remove()','DELETE',1,'admin','总公司','/system/dict/data/48','127.0.0.1','内网IP','[48]','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:23:57',32),(53,'000000','字典类型',2,'org.dromara.system.controller.system.SysDictTypeController.edit()','PUT',1,'admin','总公司','/system/dict/type','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":\"2025-11-28 11:22:17\",\"updateBy\":null,\"updateTime\":null,\"dictId\":17,\"dictName\":\"项目文档标识\",\"dictType\":\"project_file_specification\",\"remark\":\"用于区分不同类型文档\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:24:11',89),(54,'000000','字典类型',1,'org.dromara.system.controller.system.SysDictTypeController.add()','POST',1,'admin','总公司','/system/dict/type','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictId\":null,\"dictName\":\"中心文档标识\",\"dictType\":\"center_file_specification\",\"remark\":\"用于区分不同类型的文档\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:24:49',27),(55,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":1,\"dictLabel\":\"基本文档\",\"dictValue\":\"0\",\"dictType\":\"project_file_specification\",\"cssClass\":\"\",\"listClass\":\"info\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:54:08',37),(56,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":1,\"dictLabel\":\"基本文档\",\"dictValue\":\"0\",\"dictType\":\"center_file_specification\",\"cssClass\":\"\",\"listClass\":\"info\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 11:54:27',51),(57,'000000','字典类型',2,'org.dromara.system.controller.system.SysDictTypeController.edit()','PUT',1,'admin','总公司','/system/dict/type','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":\"2025-11-28 11:22:17\",\"updateBy\":null,\"updateTime\":null,\"dictId\":17,\"dictName\":\"项目文档标识\",\"dictType\":\"project_file_specification\",\"remark\":\"用于区分不同类型的文档\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 16:29:46',49),(58,'000000','代码生成',6,'org.dromara.generator.controller.GenController.importTableSave()','POST',1,'admin','总公司','/tool/gen/importTable','127.0.0.1','内网IP','{\"tables\":\"applet_setting\",\"dataName\":\"master\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 16:33:04',149),(59,'000000','代码生成',2,'org.dromara.generator.controller.GenController.editSave()','PUT',1,'admin','总公司','/tool/gen','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":1,\"updateTime\":\"2025-11-28 16:35:20\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":1,\"dataName\":\"master\",\"tableName\":\"applet_setting\",\"tableComment\":\"微信小程序设置\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"AppletSetting\",\"tplCategory\":\"crud\",\"packageName\":\"com.yingpaipay.setting\",\"moduleName\":\"setting\",\"businessName\":\"applet\",\"functionName\":\"小程序设置\",\"functionAuthor\":\"Huanyi\",\"genType\":\"0\",\"genPath\":\"/\",\"pkColumn\":null,\"columns\":[{\"createDept\":100,\"createBy\":1,\"createTime\":\"2025-11-28 16:33:04\",\"updateBy\":1,\"updateTime\":\"2025-11-28 16:35:20\",\"columnId\":1,\"tableId\":1,\"columnName\":\"id\",\"columnComment\":\"序号\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"0\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"required\":true,\"list\":false,\"pk\":true,\"insert\":false,\"edit\":true,\"superColumn\":false,\"usableColumn\":false,\"increment\":true,\"capJavaField\":\"Id\",\"query\":false},{\"createDept\":100,\"createBy\":1,\"createTime\":\"2025-11-28 16:33:04\",\"updateBy\":1,\"updateTime\":\"2025-11-28 16:35:20\",\"columnId\":2,\"tableId\":1,\"columnName\":\"user_agreement\",\"columnComment\":\"用户协议\",\"columnType\":\"text\",\"javaType\":\"String\",\"javaField\":\"userAgreement\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"0\",\"isInsert\":\"0\",\"isEdit\":\"1\",\"isList\":\"0\",\"isQuery\":\"1\",\"queryType\":\"EQ\",\"htmlType\":\"editor\",\"dictType\":\"\",\"sort\":2,\"required\":false,\"list\":false,\"pk\":false,\"insert\":false,\"edit\":true,\"superColumn\":false,\"usableColumn\":false,\"increment\":false,\"capJavaField\":\"UserAgreement\",\"query\":true},{\"createDept\":100,\"createBy\":1,\"createTime\":\"2025-11-28 16:33:04\",\"updateBy\":1,\"updateTime\":\"2025-11-28 16:35:20\",\"columnId\":3,\"tableId\":1,\"columnName\":\"privacy_agreement\",\"columnComment\":\"隐私协议\",\"columnType\":\"text\",\"javaType\":\"String\",\"javaField\":\"privacyAgreement\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"0\",\"isInsert\":\"0\",\"isEdit\":\"1\",\"isList\":\"0\",\"isQuery\":\"1\",\"queryType\":\"EQ\",\"htmlType\":\"editor\",\"dictType\":\"\",\"sort\":3,\"required\":false,\"list\":false,\"pk\":false,\"insert\":false,\"edit\":true,\"superColumn\":false,\"usableColumn\":false,\"increment\":false,\"capJavaField\":\"PrivacyAgreement\",\"query\":true},{\"createDept\":100,\"createBy\":1,\"createTime\":\"2025-11-28 16:33:04\",\"updateBy\":1,\"updateTime\":\"2025-11-28 16:35:20\",\"columnId\":4,\"tableId\":1,\"columnName\":\"create_dept\",\"columnComment\":\"创建部门\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"createDept\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"0\",\"isInsert\":null,\"isEdit\":null,\"isList\":null,\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":4,\"required\":false,\"list\":false,\"pk\":false,\"insert\":false,\"edit\":false,\"superColumn\":false,\"usableColumn\":false,\"increment\":false,\"capJavaField\":\"CreateDept\",\"query\":false},{\"createDept\":100,\"createBy\":1,\"createTime\":\"2025-11-28 16:33:04\",\"updateBy\":1,\"updateTime\":\"2025-11-28 16:35:20\",\"columnId\":5,\"tableId\":1,\"columnName\":\"create_by\",\"columnComment\":\"创建者\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"createBy\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"0\",\"isInsert\":null,\"isEdit\":null,\"isList\":null,\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":5,\"required\":false,\"list\":false,\"pk\":false,\"insert\":false,\"edit\":false,\"superColumn\":true,\"usableColumn\":false,\"increment\":false,\"capJavaField\":\"CreateBy\",\"query\":false},{\"createDept\":100,\"createBy\":1,\"createTime\":\"2025-11-28 16:33:04\",\"updateBy\":1,\"updateTime\":\"2025-11-28 16:35:20\",\"columnId\":6,\"tableId\":1,\"columnName\":\"create_time\",\"columnComment\":\"创建时间\",\"columnType\":\"datetime\",\"javaType\":\"Date\",\"javaField\":\"createTime\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"0\",\"isInsert\":null,\"isEdit\"','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 16:35:20',37),(60,'000000','代码生成',8,'org.dromara.generator.controller.GenController.batchGenCode()','GET',1,'admin','总公司','/tool/gen/batchGenCode','127.0.0.1','内网IP','{\"tableIdStr\":\"1\"}','',0,'','2025-11-28 16:36:41',600),(61,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','总公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":103,\"createBy\":null,\"createTime\":\"2025-11-28 16:37:51\",\"updateBy\":null,\"updateTime\":null,\"menuId\":\"1994324549864804354\",\"parentId\":0,\"menuName\":\"小程序设置\",\"orderNum\":1,\"path\":\"applet\",\"component\":\"setting/applet/index\",\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"C\",\"visible\":\"0\",\"status\":\"0\",\"perms\":\"setting:applet:list\",\"icon\":\"system\",\"remark\":\"小程序设置菜单\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 16:44:09',64),(62,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','总公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":103,\"createBy\":null,\"createTime\":\"2025-11-28 16:37:51\",\"updateBy\":null,\"updateTime\":null,\"menuId\":\"1994324549864804354\",\"parentId\":0,\"menuName\":\"小程序设置\",\"orderNum\":8,\"path\":\"applet\",\"component\":\"setting/applet/index\",\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"C\",\"visible\":\"0\",\"status\":\"0\",\"perms\":\"setting:applet:list\",\"icon\":\"system\",\"remark\":\"小程序设置菜单\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 16:44:18',39),(63,'000000','小程序设置',2,'com.yingpaipay.setting.controller.AppletSettingController.edit()','PUT',1,'admin','总公司','/setting/applet','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"id\":1,\"userAgreement\":\"PHA+6L+Z5piv5LiA5q615rWL6K+V5L2/55So55qE55So5oi35Y2P6K6uPC9wPg==\",\"privacyAgreement\":\"PHA+5rWL6K+VPC9wPg==\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 17:01:40',36),(64,'000000','小程序设置',2,'com.yingpaipay.setting.controller.AppletSettingController.edit()','PUT',1,'admin','总公司','/setting/applet','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"id\":1,\"userAgreement\":\"PHA+6L+Z5piv5LiA5q615rWL6K+V5L2/55So55qE55So5oi35Y2P6K6uPC9wPg==\",\"privacyAgreement\":\"PHA+6L+Z5piv5LiA5q615rWL6K+V5L2/55So55qE6ZqQ56eB5Y2P6K6uPC9wPg==\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 17:01:57',20),(65,'000000','菜单管理',3,'org.dromara.system.controller.system.SysMenuController.remove()','DELETE',1,'admin','总公司','/system/menu/1994324549864804356','127.0.0.1','内网IP','\"1994324549864804356\"','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 17:16:13',47),(66,'000000','菜单管理',3,'org.dromara.system.controller.system.SysMenuController.remove()','DELETE',1,'admin','总公司','/system/menu/1994324549864804358','127.0.0.1','内网IP','\"1994324549864804358\"','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 17:16:16',63),(67,'000000','菜单管理',3,'org.dromara.system.controller.system.SysMenuController.remove()','DELETE',1,'admin','总公司','/system/menu/1994324549864804359','127.0.0.1','内网IP','\"1994324549864804359\"','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 17:16:18',14),(68,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','总公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":103,\"createBy\":null,\"createTime\":\"2025-11-28 16:37:51\",\"updateBy\":null,\"updateTime\":null,\"menuId\":\"1994324549864804357\",\"parentId\":\"1994324549864804354\",\"menuName\":\"小程序设置修改\",\"orderNum\":2,\"path\":\"#\",\"component\":\"\",\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"F\",\"visible\":\"0\",\"status\":\"0\",\"perms\":\"setting:applet:edit\",\"icon\":\"#\",\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-11-28 17:16:26',37),(69,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','总公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":100,\"createBy\":null,\"createTime\":\"2025-11-26 16:37:07\",\"updateBy\":null,\"updateTime\":null,\"menuId\":1624,\"parentId\":0,\"menuName\":\"项目管理\",\"orderNum\":7,\"path\":\"project\",\"component\":null,\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"M\",\"visible\":\"0\",\"status\":\"0\",\"icon\":\"zip\",\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 10:59:56',43),(70,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','总公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":100,\"createBy\":null,\"createTime\":\"2025-11-26 16:45:26\",\"updateBy\":null,\"updateTime\":null,\"menuId\":1625,\"parentId\":0,\"menuName\":\"文档管理\",\"orderNum\":8,\"path\":\"document\",\"component\":null,\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"M\",\"visible\":\"0\",\"status\":\"0\",\"icon\":\"documentation\",\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 10:59:59',32),(71,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','总公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":103,\"createBy\":null,\"createTime\":\"2025-11-28 16:37:51\",\"updateBy\":null,\"updateTime\":null,\"menuId\":\"1994324549864804354\",\"parentId\":0,\"menuName\":\"小程序设置\",\"orderNum\":9,\"path\":\"applet\",\"component\":\"setting/applet/index\",\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"C\",\"visible\":\"0\",\"status\":\"0\",\"perms\":\"setting:applet:list\",\"icon\":\"system\",\"remark\":\"小程序设置菜单\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:00:03',21),(72,'000000','菜单管理',1,'org.dromara.system.controller.system.SysMenuController.add()','POST',1,'admin','总公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"menuId\":null,\"parentId\":0,\"menuName\":\"仪表盘\",\"orderNum\":6,\"path\":\"dashBoard\",\"component\":null,\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"M\",\"visible\":\"0\",\"status\":\"0\",\"icon\":\"time\",\"remark\":null}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:01:05',32),(73,'000000','菜单管理',1,'org.dromara.system.controller.system.SysMenuController.add()','POST',1,'admin','总公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"menuId\":null,\"parentId\":0,\"menuName\":\"文件检索\",\"orderNum\":9,\"path\":\"search\",\"component\":null,\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"M\",\"visible\":\"0\",\"status\":\"0\",\"icon\":\"excel\",\"remark\":null}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:01:41',30),(74,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','总公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":103,\"createBy\":null,\"createTime\":\"2025-11-28 16:37:51\",\"updateBy\":null,\"updateTime\":null,\"menuId\":\"1994324549864804354\",\"parentId\":0,\"menuName\":\"小程序设置\",\"orderNum\":99999,\"path\":\"applet\",\"component\":\"setting/applet/index\",\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"C\",\"visible\":\"0\",\"status\":\"0\",\"perms\":\"setting:applet:list\",\"icon\":\"system\",\"remark\":\"小程序设置菜单\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:01:49',32),(75,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','总公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":103,\"createBy\":null,\"createTime\":\"2025-11-28 16:37:51\",\"updateBy\":null,\"updateTime\":null,\"menuId\":\"1994324549864804354\",\"parentId\":0,\"menuName\":\"小程序设置\",\"orderNum\":9999,\"path\":\"applet\",\"component\":\"setting/applet/index\",\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"C\",\"visible\":\"0\",\"status\":\"0\",\"perms\":\"setting:applet:list\",\"icon\":\"system\",\"remark\":\"小程序设置菜单\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:01:54',29),(76,'000000','菜单管理',1,'org.dromara.system.controller.system.SysMenuController.add()','POST',1,'admin','总公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"menuId\":null,\"parentId\":0,\"menuName\":\"文件质控\",\"orderNum\":10,\"path\":\"quality\",\"component\":null,\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"M\",\"visible\":\"0\",\"status\":\"0\",\"icon\":\"workflow\",\"remark\":null}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:02:36',27),(77,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','总公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":103,\"createBy\":null,\"createTime\":\"2025-11-28 16:37:51\",\"updateBy\":null,\"updateTime\":null,\"menuId\":\"1994324549864804354\",\"parentId\":0,\"menuName\":\"小程序设置\",\"orderNum\":9999,\"path\":\"applet\",\"component\":\"setting/applet/index\",\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"C\",\"visible\":\"0\",\"status\":\"0\",\"perms\":\"setting:applet:list\",\"icon\":\"category\",\"remark\":\"小程序设置菜单\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:03:48',36),(78,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','总公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":100,\"createBy\":null,\"createTime\":\"2025-12-01 11:01:41\",\"updateBy\":null,\"updateTime\":null,\"menuId\":\"1994324549864804361\",\"parentId\":0,\"menuName\":\"文件检索\",\"orderNum\":9,\"path\":\"search\",\"component\":null,\"queryParam\":null,\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"M\",\"visible\":\"0\",\"status\":\"0\",\"icon\":\"search\",\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:03:55',36),(79,'000000','字典类型',1,'org.dromara.system.controller.system.SysDictTypeController.add()','POST',1,'admin','总公司','/system/dict/type','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictId\":null,\"dictName\":\"项目类型\",\"dictType\":\"project_type\",\"remark\":\"这个项目的类型，用于标识搜索\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:26:08',39),(80,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":1,\"dictLabel\":\"Single Region\",\"dictValue\":\"0\",\"dictType\":\"project_type\",\"cssClass\":\"\",\"listClass\":\"default\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:27:29',46),(81,'000000','代码生成',6,'org.dromara.generator.controller.GenController.importTableSave()','POST',1,'admin','总公司','/tool/gen/importTable','127.0.0.1','内网IP','{\"tables\":\"project\",\"dataName\":\"master\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:37:08',153),(82,'000000','字典类型',1,'org.dromara.system.controller.system.SysDictTypeController.add()','POST',1,'admin','总公司','/system/dict/type','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictId\":null,\"dictName\":\"项目语言\",\"dictType\":\"project_language\",\"remark\":\"每个项目的语言\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:38:38',27),(83,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":0,\"dictLabel\":\"中文\",\"dictValue\":\"0\",\"dictType\":\"project_language\",\"cssClass\":\"\",\"listClass\":\"default\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:38:55',36),(84,'000000','字典数据',2,'org.dromara.system.controller.system.SysDictDataController.edit()','PUT',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":\"2025-12-01 11:38:55\",\"updateBy\":null,\"updateTime\":null,\"dictCode\":52,\"dictSort\":1,\"dictLabel\":\"中文\",\"dictValue\":\"0\",\"dictType\":\"project_language\",\"cssClass\":\"\",\"listClass\":\"default\",\"isDefault\":\"N\",\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:38:58',39),(85,'000000','字典数据',1,'org.dromara.system.controller.system.SysDictDataController.add()','POST',1,'admin','总公司','/system/dict/data','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":null,\"updateTime\":null,\"dictCode\":null,\"dictSort\":2,\"dictLabel\":\"英文\",\"dictValue\":\"1\",\"dictType\":\"project_language\",\"cssClass\":\"\",\"listClass\":\"default\",\"isDefault\":null,\"remark\":\"\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:39:08',23),(86,'000000','代码生成',2,'org.dromara.generator.controller.GenController.editSave()','PUT',1,'admin','总公司','/tool/gen','127.0.0.1','内网IP','{\"createDept\":null,\"createBy\":null,\"createTime\":null,\"updateBy\":1,\"updateTime\":\"2025-12-01 11:40:26\",\"params\":{\"treeCode\":null,\"treeName\":null,\"treeParentCode\":null,\"parentMenuId\":null},\"tableId\":2,\"dataName\":\"master\",\"tableName\":\"project\",\"tableComment\":\"项目\",\"subTableName\":null,\"subTableFkName\":null,\"className\":\"Project\",\"tplCategory\":\"crud\",\"packageName\":\"org.dromara.system\",\"moduleName\":\"system\",\"businessName\":\"project\",\"functionName\":\"项目\",\"functionAuthor\":\"Lion Li\",\"genType\":\"0\",\"genPath\":\"/\",\"pkColumn\":null,\"columns\":[{\"createDept\":100,\"createBy\":1,\"createTime\":\"2025-12-01 11:37:08\",\"updateBy\":1,\"updateTime\":\"2025-12-01 11:40:26\",\"columnId\":11,\"tableId\":2,\"columnName\":\"id\",\"columnComment\":\"序号\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"id\",\"isPk\":\"1\",\"isIncrement\":\"1\",\"isRequired\":\"1\",\"isInsert\":null,\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":null,\"queryType\":\"EQ\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":1,\"insert\":false,\"pk\":true,\"edit\":true,\"superColumn\":false,\"usableColumn\":false,\"capJavaField\":\"Id\",\"increment\":true,\"query\":false,\"required\":true,\"list\":true},{\"createDept\":100,\"createBy\":1,\"createTime\":\"2025-12-01 11:37:08\",\"updateBy\":1,\"updateTime\":\"2025-12-01 11:40:26\",\"columnId\":12,\"tableId\":2,\"columnName\":\"code\",\"columnComment\":\"项目编号\",\"columnType\":\"varchar(128)\",\"javaType\":\"String\",\"javaField\":\"code\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"LIKE\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":2,\"insert\":true,\"pk\":false,\"edit\":true,\"superColumn\":false,\"usableColumn\":false,\"capJavaField\":\"Code\",\"increment\":false,\"query\":true,\"required\":true,\"list\":true},{\"createDept\":100,\"createBy\":1,\"createTime\":\"2025-12-01 11:37:08\",\"updateBy\":1,\"updateTime\":\"2025-12-01 11:40:26\",\"columnId\":13,\"tableId\":2,\"columnName\":\"name\",\"columnComment\":\"名称\",\"columnType\":\"varchar(128)\",\"javaType\":\"String\",\"javaField\":\"name\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"LIKE\",\"htmlType\":\"input\",\"dictType\":\"\",\"sort\":3,\"insert\":true,\"pk\":false,\"edit\":true,\"superColumn\":false,\"usableColumn\":false,\"capJavaField\":\"Name\",\"increment\":false,\"query\":true,\"required\":true,\"list\":true},{\"createDept\":100,\"createBy\":1,\"createTime\":\"2025-12-01 11:37:08\",\"updateBy\":1,\"updateTime\":\"2025-12-01 11:40:26\",\"columnId\":14,\"tableId\":2,\"columnName\":\"icon\",\"columnComment\":\"图标\",\"columnType\":\"bigint\",\"javaType\":\"Long\",\"javaField\":\"icon\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"0\",\"queryType\":\"EQ\",\"htmlType\":\"imageUpload\",\"dictType\":\"\",\"sort\":4,\"insert\":true,\"pk\":false,\"edit\":true,\"superColumn\":false,\"usableColumn\":false,\"capJavaField\":\"Icon\",\"increment\":false,\"query\":false,\"required\":true,\"list\":true},{\"createDept\":100,\"createBy\":1,\"createTime\":\"2025-12-01 11:37:08\",\"updateBy\":1,\"updateTime\":\"2025-12-01 11:40:26\",\"columnId\":15,\"tableId\":2,\"columnName\":\"language\",\"columnComment\":\"项目语言\",\"columnType\":\"char(1)\",\"javaType\":\"String\",\"javaField\":\"language\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"EQ\",\"htmlType\":\"select\",\"dictType\":\"project_language\",\"sort\":5,\"insert\":true,\"pk\":false,\"edit\":true,\"superColumn\":false,\"usableColumn\":false,\"capJavaField\":\"Language\",\"increment\":false,\"query\":true,\"required\":true,\"list\":true},{\"createDept\":100,\"createBy\":1,\"createTime\":\"2025-12-01 11:37:08\",\"updateBy\":1,\"updateTime\":\"2025-12-01 11:40:26\",\"columnId\":16,\"tableId\":2,\"columnName\":\"type\",\"columnComment\":\"项目类型\",\"columnType\":\"char(1)\",\"javaType\":\"String\",\"javaField\":\"type\",\"isPk\":\"0\",\"isIncrement\":\"0\",\"isRequired\":\"1\",\"isInsert\":\"1\",\"isEdit\":\"1\",\"isList\":\"1\",\"isQuery\":\"1\",\"queryType\":\"EQ\",\"htmlType\":\"select\",\"dictType\":\"project_type\",\"so','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 11:40:27',76),(87,'000000','角色管理',5,'org.dromara.system.controller.system.SysRoleController.export()','POST',1,'admin','总公司','/system/role/export','127.0.0.1','内网IP','{\"pageSize\":\"10\",\"pageNum\":\"1\"}','',0,'','2025-12-01 15:56:27',2155),(88,'000000','菜单管理',2,'org.dromara.system.controller.system.SysMenuController.edit()','PUT',1,'admin','总公司','/system/menu','127.0.0.1','内网IP','{\"createDept\":103,\"createBy\":null,\"createTime\":\"2025-11-26 13:39:25\",\"updateBy\":null,\"updateTime\":null,\"menuId\":106,\"parentId\":1,\"menuName\":\"参数设置\",\"orderNum\":7,\"path\":\"config\",\"component\":\"system/config/index\",\"queryParam\":\"\",\"isFrame\":\"1\",\"isCache\":\"0\",\"menuType\":\"C\",\"visible\":\"1\",\"status\":\"0\",\"perms\":\"system:config:list\",\"icon\":\"edit\",\"remark\":\"参数设置菜单\"}','{\"code\":200,\"msg\":\"操作成功\",\"data\":null}',0,'','2025-12-01 16:31:31',27);
    512. 

  512. /*!40000 ALTER TABLE `sys_oper_log` ENABLE KEYS */;
    513. 

  513. UNLOCK TABLES;
    514. 

  514. 

  515. --
    516. 

  516. -- Table structure for table `sys_oss`
    517. 

  517. --
    518. 

  518. 

  519. DROP TABLE IF EXISTS `sys_oss`;
    520. 

  520. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    521. 

  521. /*!50503 SET character_set_client = utf8mb4 */;
    522. 

  522. CREATE TABLE `sys_oss` (
    523. 

  523.   `oss_id` bigint NOT NULL AUTO_INCREMENT COMMENT '对象存储主键',
    524. 

  524.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
    525. 

  525.   `file_name` varchar(255) NOT NULL DEFAULT '' COMMENT '文件名',
    526. 

  526.   `original_name` varchar(255) NOT NULL DEFAULT '' COMMENT '原名',
    527. 

  527.   `file_suffix` varchar(10) NOT NULL DEFAULT '' COMMENT '文件后缀名',
    528. 

  528.   `url` varchar(500) NOT NULL COMMENT 'URL地址',
    529. 

  529.   `ext1` text COMMENT '扩展字段',
    530. 

  530.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    531. 

  531.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    532. 

  532.   `create_by` bigint DEFAULT NULL COMMENT '上传人',
    533. 

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

  534.   `update_by` bigint DEFAULT NULL COMMENT '更新人',
    535. 

  535.   `service` varchar(20) NOT NULL DEFAULT 'minio' COMMENT '服务商',
    536. 

  536.   PRIMARY KEY (`oss_id`)
    537. 

  537. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='OSS对象存储表';
    538. 

  538. /*!40101 SET character_set_client = @saved_cs_client */;
    539. 

  539. 

  540. --
    541. 

  541. -- Dumping data for table `sys_oss`
    542. 

  542. --
    543. 

  543. 

  544. LOCK TABLES `sys_oss` WRITE;
    545. 

  545. /*!40000 ALTER TABLE `sys_oss` DISABLE KEYS */;
    546. 

  546. INSERT INTO `sys_oss` VALUES (1,'000000','2025/11/26/f3afc984dff94d0f8f9a3368b0ba6c76.jpg','头像.jpg','.jpg','http://img.tpidea.cn/2025/11/26/f3afc984dff94d0f8f9a3368b0ba6c76.jpg','{\"bizType\":null,\"fileSize\":38260,\"contentType\":\"image/jpeg\",\"source\":null,\"uploadIp\":null,\"remark\":null,\"tags\":null,\"refId\":null,\"refType\":null,\"isTemp\":null,\"md5\":null}',103,'2025-11-26 14:28:20',1,'2025-11-26 14:28:20',1,'qiniu');
    547. 

  547. /*!40000 ALTER TABLE `sys_oss` ENABLE KEYS */;
    548. 

  548. UNLOCK TABLES;
    549. 

  549. 

  550. --
    551. 

  551. -- Table structure for table `sys_oss_config`
    552. 

  552. --
    553. 

  553. 

  554. DROP TABLE IF EXISTS `sys_oss_config`;
    555. 

  555. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    556. 

  556. /*!50503 SET character_set_client = utf8mb4 */;
    557. 

  557. CREATE TABLE `sys_oss_config` (
    558. 

  558.   `oss_config_id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    559. 

  559.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
    560. 

  560.   `config_key` varchar(20) NOT NULL DEFAULT '' COMMENT '配置key',
    561. 

  561.   `access_key` varchar(255) DEFAULT '' COMMENT 'accessKey',
    562. 

  562.   `secret_key` varchar(255) DEFAULT '' COMMENT '秘钥',
    563. 

  563.   `bucket_name` varchar(255) DEFAULT '' COMMENT '桶名称',
    564. 

  564.   `prefix` varchar(255) DEFAULT '' COMMENT '前缀',
    565. 

  565.   `endpoint` varchar(255) DEFAULT '' COMMENT '访问站点',
    566. 

  566.   `domain` varchar(255) DEFAULT '' COMMENT '自定义域名',
    567. 

  567.   `is_https` char(1) DEFAULT 'N' COMMENT '是否https（Y=是,N=否）',
    568. 

  568.   `region` varchar(255) DEFAULT '' COMMENT '域',
    569. 

  569.   `access_policy` char(1) NOT NULL DEFAULT '1' COMMENT '桶权限类型(0=private 1=public 2=custom)',
    570. 

  570.   `status` char(1) DEFAULT '1' COMMENT '是否默认（0=是,1=否）',
    571. 

  571.   `ext1` varchar(255) DEFAULT '' COMMENT '扩展字段',
    572. 

  572.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    573. 

  573.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    574. 

  574.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    575. 

  575.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    576. 

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

  577.   `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    578. 

  578.   PRIMARY KEY (`oss_config_id`)
    579. 

  579. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='对象存储配置表';
    580. 

  580. /*!40101 SET character_set_client = @saved_cs_client */;
    581. 

  581. 

  582. --
    583. 

  583. -- Dumping data for table `sys_oss_config`
    584. 

  584. --
    585. 

  585. 

  586. LOCK TABLES `sys_oss_config` WRITE;
    587. 

  587. /*!40000 ALTER TABLE `sys_oss_config` DISABLE KEYS */;
    588. 

  588. INSERT INTO `sys_oss_config` VALUES (1,'000000','minio','ruoyi','ruoyi123','ruoyi','','127.0.0.1:9000','','N','','1','1','',103,1,'2025-11-26 13:39:29',1,'2025-11-26 14:27:06',NULL),(2,'000000','qiniu','2XFWgtUdiNwKonHUc7Yitl6AjTBXelR2rYZJDR7b','2bYou-FJVKaf4xckk1Bo7PiPkXojbY__BRV3mOII','img-tpidea','','s3.cn-south-1.qiniucs.com','img.tpidea.cn','N','','1','0','',103,1,'2025-11-26 13:39:29',1,'2025-11-26 14:27:48',''),(3,'000000','aliyun','XXXXXXXXXXXXXXX','XXXXXXXXXXXXXXX','ruoyi','','oss-cn-beijing.aliyuncs.com','','N','','1','1','',103,1,'2025-11-26 13:39:29',1,'2025-11-26 13:39:29',NULL),(4,'000000','qcloud','XXXXXXXXXXXXXXX','XXXXXXXXXXXXXXX','ruoyi-1240000000','','cos.ap-beijing.myqcloud.com','','N','ap-beijing','1','1','',103,1,'2025-11-26 13:39:29',1,'2025-11-26 13:39:29',NULL),(5,'000000','image','ruoyi','ruoyi123','ruoyi','image','127.0.0.1:9000','','N','','1','1','',103,1,'2025-11-26 13:39:29',1,'2025-11-26 13:39:29',NULL);
    589. 

  589. /*!40000 ALTER TABLE `sys_oss_config` ENABLE KEYS */;
    590. 

  590. UNLOCK TABLES;
    591. 

  591. 

  592. --
    593. 

  593. -- Table structure for table `sys_post`
    594. 

  594. --
    595. 

  595. 

  596. DROP TABLE IF EXISTS `sys_post`;
    597. 

  597. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    598. 

  598. /*!50503 SET character_set_client = utf8mb4 */;
    599. 

  599. CREATE TABLE `sys_post` (
    600. 

  600.   `post_id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
    601. 

  601.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
    602. 

  602.   `dept_id` bigint NOT NULL COMMENT '部门id',
    603. 

  603.   `post_code` varchar(64) NOT NULL COMMENT '岗位编码',
    604. 

  604.   `post_category` varchar(100) DEFAULT NULL COMMENT '岗位类别编码',
    605. 

  605.   `post_name` varchar(50) NOT NULL COMMENT '岗位名称',
    606. 

  606.   `post_sort` int NOT NULL COMMENT '显示顺序',
    607. 

  607.   `status` char(1) NOT NULL COMMENT '状态（0正常 1停用）',
    608. 

  608.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    609. 

  609.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    610. 

  610.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    611. 

  611.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    612. 

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

  613.   `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    614. 

  614.   PRIMARY KEY (`post_id`)
    615. 

  615. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='岗位信息表';
    616. 

  616. /*!40101 SET character_set_client = @saved_cs_client */;
    617. 

  617. 

  618. --
    619. 

  619. -- Dumping data for table `sys_post`
    620. 

  620. --
    621. 

  621. 

  622. LOCK TABLES `sys_post` WRITE;
    623. 

  623. /*!40000 ALTER TABLE `sys_post` DISABLE KEYS */;
    624. 

  624. INSERT INTO `sys_post` VALUES (1,'000000',100,'ceo',NULL,'董事长',1,'0',103,1,'2025-11-26 13:39:24',NULL,NULL,'');
    625. 

  625. /*!40000 ALTER TABLE `sys_post` ENABLE KEYS */;
    626. 

  626. UNLOCK TABLES;
    627. 

  627. 

  628. --
    629. 

  629. -- Table structure for table `sys_role`
    630. 

  630. --
    631. 

  631. 

  632. DROP TABLE IF EXISTS `sys_role`;
    633. 

  633. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    634. 

  634. /*!50503 SET character_set_client = utf8mb4 */;
    635. 

  635. CREATE TABLE `sys_role` (
    636. 

  636.   `role_id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID',
    637. 

  637.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
    638. 

  638.   `role_name` varchar(30) NOT NULL COMMENT '角色名称',
    639. 

  639.   `role_key` varchar(100) NOT NULL COMMENT '角色权限字符串',
    640. 

  640.   `role_sort` int NOT NULL COMMENT '显示顺序',
    641. 

  641.   `data_scope` char(1) DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限 5：仅本人数据权限 6：部门及以下或本人数据权限）',
    642. 

  642.   `menu_check_strictly` tinyint(1) DEFAULT '1' COMMENT '菜单树选择项是否关联显示',
    643. 

  643.   `dept_check_strictly` tinyint(1) DEFAULT '1' COMMENT '部门树选择项是否关联显示',
    644. 

  644.   `status` char(1) NOT NULL COMMENT '角色状态（0正常 1停用）',
    645. 

  645.   `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
    646. 

  646.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    647. 

  647.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    648. 

  648.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    649. 

  649.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    650. 

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

  651.   `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    652. 

  652.   PRIMARY KEY (`role_id`)
    653. 

  653. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色信息表';
    654. 

  654. /*!40101 SET character_set_client = @saved_cs_client */;
    655. 

  655. 

  656. --
    657. 

  657. -- Dumping data for table `sys_role`
    658. 

  658. --
    659. 

  659. 

  660. LOCK TABLES `sys_role` WRITE;
    661. 

  661. /*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
    662. 

  662. INSERT INTO `sys_role` VALUES (1,'000000','超级管理员','superadmin',1,'1',1,1,'0','0',103,1,'2025-11-26 13:39:24',NULL,NULL,'超级管理员');
    663. 

  663. /*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
    664. 

  664. UNLOCK TABLES;
    665. 

  665. 

  666. --
    667. 

  667. -- Table structure for table `sys_role_dept`
    668. 

  668. --
    669. 

  669. 

  670. DROP TABLE IF EXISTS `sys_role_dept`;
    671. 

  671. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    672. 

  672. /*!50503 SET character_set_client = utf8mb4 */;
    673. 

  673. CREATE TABLE `sys_role_dept` (
    674. 

  674.   `role_id` bigint NOT NULL COMMENT '角色ID',
    675. 

  675.   `dept_id` bigint NOT NULL COMMENT '部门ID',
    676. 

  676.   PRIMARY KEY (`role_id`,`dept_id`)
    677. 

  677. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色和部门关联表';
    678. 

  678. /*!40101 SET character_set_client = @saved_cs_client */;
    679. 

  679. 

  680. --
    681. 

  681. -- Dumping data for table `sys_role_dept`
    682. 

  682. --
    683. 

  683. 

  684. LOCK TABLES `sys_role_dept` WRITE;
    685. 

  685. /*!40000 ALTER TABLE `sys_role_dept` DISABLE KEYS */;
    686. 

  686. /*!40000 ALTER TABLE `sys_role_dept` ENABLE KEYS */;
    687. 

  687. UNLOCK TABLES;
    688. 

  688. 

  689. --
    690. 

  690. -- Table structure for table `sys_role_menu`
    691. 

  691. --
    692. 

  692. 

  693. DROP TABLE IF EXISTS `sys_role_menu`;
    694. 

  694. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    695. 

  695. /*!50503 SET character_set_client = utf8mb4 */;
    696. 

  696. CREATE TABLE `sys_role_menu` (
    697. 

  697.   `role_id` bigint NOT NULL COMMENT '角色ID',
    698. 

  698.   `menu_id` bigint NOT NULL COMMENT '菜单ID',
    699. 

  699.   PRIMARY KEY (`role_id`,`menu_id`)
    700. 

  700. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色和菜单关联表';
    701. 

  701. /*!40101 SET character_set_client = @saved_cs_client */;
    702. 

  702. 

  703. --
    704. 

  704. -- Dumping data for table `sys_role_menu`
    705. 

  705. --
    706. 

  706. 

  707. LOCK TABLES `sys_role_menu` WRITE;
    708. 

  708. /*!40000 ALTER TABLE `sys_role_menu` DISABLE KEYS */;
    709. 

  709. INSERT INTO `sys_role_menu` VALUES (3,1),(3,5),(3,100),(3,101),(3,102),(3,103),(3,104),(3,105),(3,106),(3,107),(3,108),(3,118),(3,123),(3,130),(3,131),(3,132),(3,133),(3,500),(3,501),(3,1001),(3,1002),(3,1003),(3,1004),(3,1005),(3,1006),(3,1007),(3,1008),(3,1009),(3,1010),(3,1011),(3,1012),(3,1013),(3,1014),(3,1015),(3,1016),(3,1017),(3,1018),(3,1019),(3,1020),(3,1021),(3,1022),(3,1023),(3,1024),(3,1025),(3,1026),(3,1027),(3,1028),(3,1029),(3,1030),(3,1031),(3,1032),(3,1033),(3,1034),(3,1035),(3,1036),(3,1037),(3,1038),(3,1039),(3,1040),(3,1041),(3,1042),(3,1043),(3,1044),(3,1045),(3,1050),(3,1061),(3,1062),(3,1063),(3,1064),(3,1065),(3,1500),(3,1501),(3,1502),(3,1503),(3,1504),(3,1505),(3,1506),(3,1507),(3,1508),(3,1509),(3,1510),(3,1511),(3,1600),(3,1601),(3,1602),(3,1603),(3,1620),(3,1621),(3,1622),(3,1623),(3,11616),(3,11618),(3,11619),(3,11622),(3,11623),(3,11629),(3,11632),(3,11633),(3,11638),(3,11639),(3,11640),(3,11641),(3,11642),(3,11643),(3,11701),(4,5),(4,1500),(4,1501),(4,1502),(4,1503),(4,1504),(4,1505),(4,1506),(4,1507),(4,1508),(4,1509),(4,1510),(4,1511);
    710. 

  710. /*!40000 ALTER TABLE `sys_role_menu` ENABLE KEYS */;
    711. 

  711. UNLOCK TABLES;
    712. 

  712. 

  713. --
    714. 

  714. -- Table structure for table `sys_social`
    715. 

  715. --
    716. 

  716. 

  717. DROP TABLE IF EXISTS `sys_social`;
    718. 

  718. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    719. 

  719. /*!50503 SET character_set_client = utf8mb4 */;
    720. 

  720. CREATE TABLE `sys_social` (
    721. 

  721.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    722. 

  722.   `user_id` bigint NOT NULL COMMENT '用户ID',
    723. 

  723.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户id',
    724. 

  724.   `auth_id` varchar(255) NOT NULL COMMENT '平台+平台唯一id',
    725. 

  725.   `source` varchar(255) NOT NULL COMMENT '用户来源',
    726. 

  726.   `open_id` varchar(255) DEFAULT NULL COMMENT '平台编号唯一id',
    727. 

  727.   `user_name` varchar(30) NOT NULL COMMENT '登录账号',
    728. 

  728.   `nick_name` varchar(30) DEFAULT '' COMMENT '用户昵称',
    729. 

  729.   `email` varchar(255) DEFAULT '' COMMENT '用户邮箱',
    730. 

  730.   `avatar` varchar(500) DEFAULT '' COMMENT '头像地址',
    731. 

  731.   `access_token` varchar(2000) NOT NULL COMMENT '用户的授权令牌',
    732. 

  732.   `expire_in` int DEFAULT NULL COMMENT '用户的授权令牌的有效期，部分平台可能没有',
    733. 

  733.   `refresh_token` varchar(255) DEFAULT NULL COMMENT '刷新令牌，部分平台可能没有',
    734. 

  734.   `access_code` varchar(2000) DEFAULT NULL COMMENT '平台的授权信息，部分平台可能没有',
    735. 

  735.   `union_id` varchar(255) DEFAULT NULL COMMENT '用户的 unionid',
    736. 

  736.   `scope` varchar(255) DEFAULT NULL COMMENT '授予的权限，部分平台可能没有',
    737. 

  737.   `token_type` varchar(255) DEFAULT NULL COMMENT '个别平台的授权信息，部分平台可能没有',
    738. 

  738.   `id_token` varchar(2000) DEFAULT NULL COMMENT 'id token，部分平台可能没有',
    739. 

  739.   `mac_algorithm` varchar(255) DEFAULT NULL COMMENT '小米平台用户的附带属性，部分平台可能没有',
    740. 

  740.   `mac_key` varchar(255) DEFAULT NULL COMMENT '小米平台用户的附带属性，部分平台可能没有',
    741. 

  741.   `code` varchar(255) DEFAULT NULL COMMENT '用户的授权code，部分平台可能没有',
    742. 

  742.   `oauth_token` varchar(255) DEFAULT NULL COMMENT 'Twitter平台用户的附带属性，部分平台可能没有',
    743. 

  743.   `oauth_token_secret` varchar(255) DEFAULT NULL COMMENT 'Twitter平台用户的附带属性，部分平台可能没有',
    744. 

  744.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    745. 

  745.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    746. 

  746.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    747. 

  747.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    748. 

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

  749.   `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
    750. 

  750.   PRIMARY KEY (`id`)
    751. 

  751. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='社会化关系表';
    752. 

  752. /*!40101 SET character_set_client = @saved_cs_client */;
    753. 

  753. 

  754. --
    755. 

  755. -- Dumping data for table `sys_social`
    756. 

  756. --
    757. 

  757. 

  758. LOCK TABLES `sys_social` WRITE;
    759. 

  759. /*!40000 ALTER TABLE `sys_social` DISABLE KEYS */;
    760. 

  760. /*!40000 ALTER TABLE `sys_social` ENABLE KEYS */;
    761. 

  761. UNLOCK TABLES;
    762. 

  762. 

  763. --
    764. 

  764. -- Table structure for table `sys_tenant`
    765. 

  765. --
    766. 

  766. 

  767. DROP TABLE IF EXISTS `sys_tenant`;
    768. 

  768. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    769. 

  769. /*!50503 SET character_set_client = utf8mb4 */;
    770. 

  770. CREATE TABLE `sys_tenant` (
    771. 

  771.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
    772. 

  772.   `tenant_id` varchar(20) NOT NULL COMMENT '租户编号',
    773. 

  773.   `contact_user_name` varchar(20) DEFAULT NULL COMMENT '联系人',
    774. 

  774.   `contact_phone` varchar(20) DEFAULT NULL COMMENT '联系电话',
    775. 

  775.   `company_name` varchar(30) DEFAULT NULL COMMENT '企业名称',
    776. 

  776.   `license_number` varchar(30) DEFAULT NULL COMMENT '统一社会信用代码',
    777. 

  777.   `address` varchar(200) DEFAULT NULL COMMENT '地址',
    778. 

  778.   `intro` varchar(200) DEFAULT NULL COMMENT '企业简介',
    779. 

  779.   `domain` varchar(200) DEFAULT NULL COMMENT '域名',
    780. 

  780.   `remark` varchar(200) DEFAULT NULL COMMENT '备注',
    781. 

  781.   `package_id` bigint DEFAULT NULL COMMENT '租户套餐编号',
    782. 

  782.   `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
    783. 

  783.   `account_count` int DEFAULT '-1' COMMENT '用户数量（-1不限制）',
    784. 

  784.   `status` char(1) DEFAULT '0' COMMENT '租户状态（0正常 1停用）',
    785. 

  785.   `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
    786. 

  786.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    787. 

  787.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    788. 

  788.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    789. 

  789.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    790. 

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

  791.   PRIMARY KEY (`id`)
    792. 

  792. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='租户表';
    793. 

  793. /*!40101 SET character_set_client = @saved_cs_client */;
    794. 

  794. 

  795. --
    796. 

  796. -- Dumping data for table `sys_tenant`
    797. 

  797. --
    798. 

  798. 

  799. LOCK TABLES `sys_tenant` WRITE;
    800. 

  800. /*!40000 ALTER TABLE `sys_tenant` DISABLE KEYS */;
    801. 

  801. INSERT INTO `sys_tenant` VALUES (1,'000000','超级管理员','15888888888','总控中心',NULL,NULL,'主后台',NULL,NULL,NULL,NULL,-1,'0','0',103,1,'2025-11-26 13:39:24',NULL,NULL);
    802. 

  802. /*!40000 ALTER TABLE `sys_tenant` ENABLE KEYS */;
    803. 

  803. UNLOCK TABLES;
    804. 

  804. 

  805. --
    806. 

  806. -- Table structure for table `sys_tenant_package`
    807. 

  807. --
    808. 

  808. 

  809. DROP TABLE IF EXISTS `sys_tenant_package`;
    810. 

  810. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    811. 

  811. /*!50503 SET character_set_client = utf8mb4 */;
    812. 

  812. CREATE TABLE `sys_tenant_package` (
    813. 

  813.   `package_id` bigint NOT NULL AUTO_INCREMENT COMMENT '租户套餐id',
    814. 

  814.   `package_name` varchar(20) DEFAULT NULL COMMENT '套餐名称',
    815. 

  815.   `menu_ids` varchar(3000) DEFAULT NULL COMMENT '关联菜单id',
    816. 

  816.   `remark` varchar(200) DEFAULT NULL COMMENT '备注',
    817. 

  817.   `menu_check_strictly` tinyint(1) DEFAULT '1' COMMENT '菜单树选择项是否关联显示',
    818. 

  818.   `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
    819. 

  819.   `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
    820. 

  820.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    821. 

  821.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    822. 

  822.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    823. 

  823.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    824. 

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

  825.   PRIMARY KEY (`package_id`)
    826. 

  826. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='租户套餐表';
    827. 

  827. /*!40101 SET character_set_client = @saved_cs_client */;
    828. 

  828. 

  829. --
    830. 

  830. -- Dumping data for table `sys_tenant_package`
    831. 

  831. --
    832. 

  832. 

  833. LOCK TABLES `sys_tenant_package` WRITE;
    834. 

  834. /*!40000 ALTER TABLE `sys_tenant_package` DISABLE KEYS */;
    835. 

  835. /*!40000 ALTER TABLE `sys_tenant_package` ENABLE KEYS */;
    836. 

  836. UNLOCK TABLES;
    837. 

  837. 

  838. --
    839. 

  839. -- Table structure for table `sys_user`
    840. 

  840. --
    841. 

  841. 

  842. DROP TABLE IF EXISTS `sys_user`;
    843. 

  843. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    844. 

  844. /*!50503 SET character_set_client = utf8mb4 */;
    845. 

  845. CREATE TABLE `sys_user` (
    846. 

  846.   `user_id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
    847. 

  847.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
    848. 

  848.   `dept_id` bigint DEFAULT NULL COMMENT '部门ID',
    849. 

  849.   `user_name` varchar(30) NOT NULL COMMENT '用户账号',
    850. 

  850.   `nick_name` varchar(30) NOT NULL COMMENT '用户昵称',
    851. 

  851.   `user_type` varchar(10) DEFAULT 'sys_user' COMMENT '用户类型（sys_user系统用户）',
    852. 

  852.   `email` varchar(50) DEFAULT '' COMMENT '用户邮箱',
    853. 

  853.   `phonenumber` varchar(11) DEFAULT '' COMMENT '手机号码',
    854. 

  854.   `sex` char(1) DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
    855. 

  855.   `avatar` bigint DEFAULT NULL COMMENT '头像地址',
    856. 

  856.   `password` varchar(100) DEFAULT '' COMMENT '密码',
    857. 

  857.   `status` char(1) DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
    858. 

  858.   `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
    859. 

  859.   `login_ip` varchar(128) DEFAULT '' COMMENT '最后登录IP',
    860. 

  860.   `login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
    861. 

  861.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    862. 

  862.   `create_by` bigint DEFAULT NULL COMMENT '创建者',
    863. 

  863.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    864. 

  864.   `update_by` bigint DEFAULT NULL COMMENT '更新者',
    865. 

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

  866.   `remark` varchar(500) DEFAULT NULL COMMENT '备注',
    867. 

  867.   `wechat_open_id` varchar(128) DEFAULT NULL COMMENT '微信的 open ID',
    868. 

  868.   `wechat_union_id` varchar(128) DEFAULT NULL COMMENT '微信的 union ID',
    869. 

  869.   `applet_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许微信小程序登录(0 -> 允许; 1 -> 禁止)',
    870. 

  870.   PRIMARY KEY (`user_id`)
    871. 

  871. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户信息表';
    872. 

  872. /*!40101 SET character_set_client = @saved_cs_client */;
    873. 

  873. 

  874. --
    875. 

  875. -- Dumping data for table `sys_user`
    876. 

  876. --
    877. 

  877. 

  878. LOCK TABLES `sys_user` WRITE;
    879. 

  879. /*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
    880. 

  880. INSERT INTO `sys_user` VALUES (1,'000000',100,'admin','系统管理员','sys_user','admin@gmail.com','15888888888','0',NULL,'$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2','0','0','127.0.0.1','2025-12-01 15:14:11',100,1,'2025-11-26 13:39:24',-1,'2025-12-01 15:14:11','管理员',NULL,NULL,0);
    881. 

  881. /*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
    882. 

  882. UNLOCK TABLES;
    883. 

  883. 

  884. --
    885. 

  885. -- Table structure for table `sys_user_post`
    886. 

  886. --
    887. 

  887. 

  888. DROP TABLE IF EXISTS `sys_user_post`;
    889. 

  889. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    890. 

  890. /*!50503 SET character_set_client = utf8mb4 */;
    891. 

  891. CREATE TABLE `sys_user_post` (
    892. 

  892.   `user_id` bigint NOT NULL COMMENT '用户ID',
    893. 

  893.   `post_id` bigint NOT NULL COMMENT '岗位ID',
    894. 

  894.   PRIMARY KEY (`user_id`,`post_id`)
    895. 

  895. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户与岗位关联表';
    896. 

  896. /*!40101 SET character_set_client = @saved_cs_client */;
    897. 

  897. 

  898. --
    899. 

  899. -- Dumping data for table `sys_user_post`
    900. 

  900. --
    901. 

  901. 

  902. LOCK TABLES `sys_user_post` WRITE;
    903. 

  903. /*!40000 ALTER TABLE `sys_user_post` DISABLE KEYS */;
    904. 

  904. INSERT INTO `sys_user_post` VALUES (1,1);
    905. 

  905. /*!40000 ALTER TABLE `sys_user_post` ENABLE KEYS */;
    906. 

  906. UNLOCK TABLES;
    907. 

  907. 

  908. --
    909. 

  909. -- Table structure for table `sys_user_role`
    910. 

  910. --
    911. 

  911. 

  912. DROP TABLE IF EXISTS `sys_user_role`;
    913. 

  913. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    914. 

  914. /*!50503 SET character_set_client = utf8mb4 */;
    915. 

  915. CREATE TABLE `sys_user_role` (
    916. 

  916.   `user_id` bigint NOT NULL COMMENT '用户ID',
    917. 

  917.   `role_id` bigint NOT NULL COMMENT '角色ID',
    918. 

  918.   PRIMARY KEY (`user_id`,`role_id`)
    919. 

  919. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户和角色关联表';
    920. 

  920. /*!40101 SET character_set_client = @saved_cs_client */;
    921. 

  921. 

  922. --
    923. 

  923. -- Dumping data for table `sys_user_role`
    924. 

  924. --
    925. 

  925. 

  926. LOCK TABLES `sys_user_role` WRITE;
    927. 

  927. /*!40000 ALTER TABLE `sys_user_role` DISABLE KEYS */;
    928. 

  928. INSERT INTO `sys_user_role` VALUES (1,1);
    929. 

  929. /*!40000 ALTER TABLE `sys_user_role` ENABLE KEYS */;
    930. 

  930. UNLOCK TABLES;
    931. 

  931. 

  932. --
    933. 

  933. -- Table structure for table `test_demo`
    934. 

  934. --
    935. 

  935. 

  936. DROP TABLE IF EXISTS `test_demo`;
    937. 

  937. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    938. 

  938. /*!50503 SET character_set_client = utf8mb4 */;
    939. 

  939. CREATE TABLE `test_demo` (
    940. 

  940.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    941. 

  941.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
    942. 

  942.   `dept_id` bigint DEFAULT NULL COMMENT '部门id',
    943. 

  943.   `user_id` bigint DEFAULT NULL COMMENT '用户id',
    944. 

  944.   `order_num` int DEFAULT '0' COMMENT '排序号',
    945. 

  945.   `test_key` varchar(255) DEFAULT NULL COMMENT 'key键',
    946. 

  946.   `value` varchar(255) DEFAULT NULL COMMENT '值',
    947. 

  947.   `version` int DEFAULT '0' COMMENT '版本',
    948. 

  948.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    949. 

  949.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    950. 

  950.   `create_by` bigint DEFAULT NULL COMMENT '创建人',
    951. 

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

  952.   `update_by` bigint DEFAULT NULL COMMENT '更新人',
    953. 

  953.   `del_flag` int DEFAULT '0' COMMENT '删除标志',
    954. 

  954.   PRIMARY KEY (`id`) USING BTREE
    955. 

  955. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='测试单表';
    956. 

  956. /*!40101 SET character_set_client = @saved_cs_client */;
    957. 

  957. 

  958. --
    959. 

  959. -- Dumping data for table `test_demo`
    960. 

  960. --
    961. 

  961. 

  962. LOCK TABLES `test_demo` WRITE;
    963. 

  963. /*!40000 ALTER TABLE `test_demo` DISABLE KEYS */;
    964. 

  964. INSERT INTO `test_demo` VALUES (1,'000000',102,4,1,'测试数据权限','测试',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(2,'000000',102,3,2,'子节点1','111',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(3,'000000',102,3,3,'子节点2','222',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(4,'000000',108,4,4,'测试数据','demo',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(5,'000000',108,3,13,'子节点11','1111',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(6,'000000',108,3,12,'子节点22','2222',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(7,'000000',108,3,11,'子节点33','3333',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(8,'000000',108,3,10,'子节点44','4444',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(9,'000000',108,3,9,'子节点55','5555',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(10,'000000',108,3,8,'子节点66','6666',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(11,'000000',108,3,7,'子节点77','7777',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(12,'000000',108,3,6,'子节点88','8888',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(13,'000000',108,3,5,'子节点99','9999',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0);
    965. 

  965. /*!40000 ALTER TABLE `test_demo` ENABLE KEYS */;
    966. 

  966. UNLOCK TABLES;
    967. 

  967. 

  968. --
    969. 

  969. -- Table structure for table `test_tree`
    970. 

  970. --
    971. 

  971. 

  972. DROP TABLE IF EXISTS `test_tree`;
    973. 

  973. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    974. 

  974. /*!50503 SET character_set_client = utf8mb4 */;
    975. 

  975. CREATE TABLE `test_tree` (
    976. 

  976.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    977. 

  977.   `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
    978. 

  978.   `parent_id` bigint DEFAULT '0' COMMENT '父id',
    979. 

  979.   `dept_id` bigint DEFAULT NULL COMMENT '部门id',
    980. 

  980.   `user_id` bigint DEFAULT NULL COMMENT '用户id',
    981. 

  981.   `tree_name` varchar(255) DEFAULT NULL COMMENT '值',
    982. 

  982.   `version` int DEFAULT '0' COMMENT '版本',
    983. 

  983.   `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
    984. 

  984.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    985. 

  985.   `create_by` bigint DEFAULT NULL COMMENT '创建人',
    986. 

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

  987.   `update_by` bigint DEFAULT NULL COMMENT '更新人',
    988. 

  988.   `del_flag` int DEFAULT '0' COMMENT '删除标志',
    989. 

  989.   PRIMARY KEY (`id`) USING BTREE
    990. 

  990. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='测试树表';
    991. 

  991. /*!40101 SET character_set_client = @saved_cs_client */;
    992. 

  992. 

  993. --
    994. 

  994. -- Dumping data for table `test_tree`
    995. 

  995. --
    996. 

  996. 

  997. LOCK TABLES `test_tree` WRITE;
    998. 

  998. /*!40000 ALTER TABLE `test_tree` DISABLE KEYS */;
    999. 

  999. INSERT INTO `test_tree` VALUES (1,'000000',0,102,4,'测试数据权限',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(2,'000000',1,102,3,'子节点1',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(3,'000000',2,102,3,'子节点2',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(4,'000000',0,108,4,'测试树1',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(5,'000000',4,108,3,'子节点11',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(6,'000000',4,108,3,'子节点22',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(7,'000000',4,108,3,'子节点33',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(8,'000000',5,108,3,'子节点44',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(9,'000000',6,108,3,'子节点55',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(10,'000000',7,108,3,'子节点66',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(11,'000000',7,108,3,'子节点77',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(12,'000000',10,108,3,'子节点88',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0),(13,'000000',10,108,3,'子节点99',0,103,'2025-11-26 13:39:29',1,NULL,NULL,0);
    1000. 

  1000. /*!40000 ALTER TABLE `test_tree` ENABLE KEYS */;
    1001. 

  1001. UNLOCK TABLES;
    1002. 

  1002. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
    1003. 

  1003. 

  1004. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    1005. 

  1005. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    1006. 

  1006. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    1007. 

  1007. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    1008. 

  1008. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    1009. 

  1009. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    1010. 

  1010. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    1011. 

  1011. 

  1012. -- Dump completed on 2025-12-02  9:34:46
    1013.