fastapiadmin_2025-12-04_221332.sql 72 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811
  1. -- MySQL dump 10.13 Distrib 8.4.3, for macos14.5 (arm64)
  2. --
  3. -- Host: 127.0.0.1 Database: fastapiadmin
  4. -- ------------------------------------------------------
  5. -- Server version 8.4.3
  6. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  7. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  8. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  9. /*!50503 SET NAMES utf8mb4 */;
  10. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  11. /*!40103 SET TIME_ZONE='+00:00' */;
  12. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  13. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  14. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  15. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  16. --
  17. -- Table structure for table `app_ai_mcp`
  18. --
  19. DROP TABLE IF EXISTS `app_ai_mcp`;
  20. /*!40101 SET @saved_cs_client = @@character_set_client */;
  21. /*!50503 SET character_set_client = utf8mb4 */;
  22. CREATE TABLE `app_ai_mcp` (
  23. `name` varchar(50) NOT NULL COMMENT 'MCP 名称',
  24. `type` int NOT NULL COMMENT 'MCP 类型(0:stdio 1:sse)',
  25. `url` varchar(255) DEFAULT NULL COMMENT '远程 SSE 地址',
  26. `command` varchar(255) DEFAULT NULL COMMENT 'MCP 命令',
  27. `args` varchar(255) DEFAULT NULL COMMENT 'MCP 命令参数',
  28. `env` json DEFAULT NULL COMMENT 'MCP 环境变量',
  29. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  30. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  31. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  32. `description` text COMMENT '备注/描述',
  33. `created_time` datetime NOT NULL COMMENT '创建时间',
  34. `updated_time` datetime NOT NULL COMMENT '更新时间',
  35. `created_id` int DEFAULT NULL COMMENT '创建人ID',
  36. `updated_id` int DEFAULT NULL COMMENT '更新人ID',
  37. PRIMARY KEY (`id`),
  38. UNIQUE KEY `uuid` (`uuid`),
  39. KEY `ix_app_ai_mcp_created_id` (`created_id`),
  40. KEY `ix_app_ai_mcp_updated_id` (`updated_id`),
  41. CONSTRAINT `app_ai_mcp_ibfk_1` FOREIGN KEY (`created_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  42. CONSTRAINT `app_ai_mcp_ibfk_2` FOREIGN KEY (`updated_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
  43. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='MCP 服务器表';
  44. /*!40101 SET character_set_client = @saved_cs_client */;
  45. --
  46. -- Dumping data for table `app_ai_mcp`
  47. --
  48. /*!40000 ALTER TABLE `app_ai_mcp` DISABLE KEYS */;
  49. /*!40000 ALTER TABLE `app_ai_mcp` ENABLE KEYS */;
  50. --
  51. -- Table structure for table `app_job`
  52. --
  53. DROP TABLE IF EXISTS `app_job`;
  54. /*!40101 SET @saved_cs_client = @@character_set_client */;
  55. /*!50503 SET character_set_client = utf8mb4 */;
  56. CREATE TABLE `app_job` (
  57. `name` varchar(64) DEFAULT NULL COMMENT '任务名称',
  58. `jobstore` varchar(64) DEFAULT NULL COMMENT '存储器',
  59. `executor` varchar(64) DEFAULT NULL COMMENT '执行器:将运行此作业的执行程序的名称',
  60. `trigger` varchar(64) NOT NULL COMMENT '触发器:控制此作业计划的 trigger 对象',
  61. `trigger_args` text COMMENT '触发器参数',
  62. `func` text NOT NULL COMMENT '任务函数',
  63. `args` text COMMENT '位置参数',
  64. `kwargs` text COMMENT '关键字参数',
  65. `coalesce` tinyint(1) DEFAULT NULL COMMENT '是否合并运行:是否在多个运行时间到期时仅运行作业一次',
  66. `max_instances` int DEFAULT NULL COMMENT '最大实例数:允许的最大并发执行实例数',
  67. `start_date` varchar(64) DEFAULT NULL COMMENT '开始时间',
  68. `end_date` varchar(64) DEFAULT NULL COMMENT '结束时间',
  69. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  70. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  71. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  72. `description` text COMMENT '备注/描述',
  73. `created_time` datetime NOT NULL COMMENT '创建时间',
  74. `updated_time` datetime NOT NULL COMMENT '更新时间',
  75. `created_id` int DEFAULT NULL COMMENT '创建人ID',
  76. `updated_id` int DEFAULT NULL COMMENT '更新人ID',
  77. PRIMARY KEY (`id`),
  78. UNIQUE KEY `uuid` (`uuid`),
  79. KEY `ix_app_job_updated_id` (`updated_id`),
  80. KEY `ix_app_job_created_id` (`created_id`),
  81. CONSTRAINT `app_job_ibfk_1` FOREIGN KEY (`created_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  82. CONSTRAINT `app_job_ibfk_2` FOREIGN KEY (`updated_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
  83. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='定时任务调度表';
  84. /*!40101 SET character_set_client = @saved_cs_client */;
  85. --
  86. -- Dumping data for table `app_job`
  87. --
  88. /*!40000 ALTER TABLE `app_job` DISABLE KEYS */;
  89. /*!40000 ALTER TABLE `app_job` ENABLE KEYS */;
  90. --
  91. -- Table structure for table `app_job_log`
  92. --
  93. DROP TABLE IF EXISTS `app_job_log`;
  94. /*!40101 SET @saved_cs_client = @@character_set_client */;
  95. /*!50503 SET character_set_client = utf8mb4 */;
  96. CREATE TABLE `app_job_log` (
  97. `job_name` varchar(64) NOT NULL COMMENT '任务名称',
  98. `job_group` varchar(64) NOT NULL COMMENT '任务组名',
  99. `job_executor` varchar(64) NOT NULL COMMENT '任务执行器',
  100. `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串',
  101. `job_args` varchar(255) DEFAULT NULL COMMENT '位置参数',
  102. `job_kwargs` varchar(255) DEFAULT NULL COMMENT '关键字参数',
  103. `job_trigger` varchar(255) DEFAULT NULL COMMENT '任务触发器',
  104. `job_message` varchar(500) DEFAULT NULL COMMENT '日志信息',
  105. `exception_info` varchar(2000) DEFAULT NULL COMMENT '异常信息',
  106. `job_id` int DEFAULT NULL COMMENT '任务ID',
  107. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  108. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  109. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  110. `description` text COMMENT '备注/描述',
  111. `created_time` datetime NOT NULL COMMENT '创建时间',
  112. `updated_time` datetime NOT NULL COMMENT '更新时间',
  113. PRIMARY KEY (`id`),
  114. UNIQUE KEY `uuid` (`uuid`),
  115. KEY `ix_app_job_log_job_id` (`job_id`),
  116. CONSTRAINT `app_job_log_ibfk_1` FOREIGN KEY (`job_id`) REFERENCES `app_job` (`id`) ON DELETE CASCADE
  117. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='定时任务调度日志表';
  118. /*!40101 SET character_set_client = @saved_cs_client */;
  119. --
  120. -- Dumping data for table `app_job_log`
  121. --
  122. /*!40000 ALTER TABLE `app_job_log` DISABLE KEYS */;
  123. /*!40000 ALTER TABLE `app_job_log` ENABLE KEYS */;
  124. --
  125. -- Table structure for table `app_myapp`
  126. --
  127. DROP TABLE IF EXISTS `app_myapp`;
  128. /*!40101 SET @saved_cs_client = @@character_set_client */;
  129. /*!50503 SET character_set_client = utf8mb4 */;
  130. CREATE TABLE `app_myapp` (
  131. `name` varchar(64) NOT NULL COMMENT '应用名称',
  132. `access_url` varchar(500) NOT NULL COMMENT '访问地址',
  133. `icon_url` varchar(300) DEFAULT NULL COMMENT '应用图标URL',
  134. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  135. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  136. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  137. `description` text COMMENT '备注/描述',
  138. `created_time` datetime NOT NULL COMMENT '创建时间',
  139. `updated_time` datetime NOT NULL COMMENT '更新时间',
  140. `created_id` int DEFAULT NULL COMMENT '创建人ID',
  141. `updated_id` int DEFAULT NULL COMMENT '更新人ID',
  142. PRIMARY KEY (`id`),
  143. UNIQUE KEY `uuid` (`uuid`),
  144. KEY `ix_app_myapp_created_id` (`created_id`),
  145. KEY `ix_app_myapp_updated_id` (`updated_id`),
  146. CONSTRAINT `app_myapp_ibfk_1` FOREIGN KEY (`created_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  147. CONSTRAINT `app_myapp_ibfk_2` FOREIGN KEY (`updated_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
  148. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='应用系统表';
  149. /*!40101 SET character_set_client = @saved_cs_client */;
  150. --
  151. -- Dumping data for table `app_myapp`
  152. --
  153. /*!40000 ALTER TABLE `app_myapp` DISABLE KEYS */;
  154. /*!40000 ALTER TABLE `app_myapp` ENABLE KEYS */;
  155. --
  156. -- Table structure for table `apscheduler_jobs`
  157. --
  158. DROP TABLE IF EXISTS `apscheduler_jobs`;
  159. /*!40101 SET @saved_cs_client = @@character_set_client */;
  160. /*!50503 SET character_set_client = utf8mb4 */;
  161. CREATE TABLE `apscheduler_jobs` (
  162. `id` varchar(191) NOT NULL,
  163. `next_run_time` double DEFAULT NULL,
  164. `job_state` blob NOT NULL,
  165. PRIMARY KEY (`id`),
  166. KEY `ix_apscheduler_jobs_next_run_time` (`next_run_time`)
  167. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  168. /*!40101 SET character_set_client = @saved_cs_client */;
  169. --
  170. -- Dumping data for table `apscheduler_jobs`
  171. --
  172. /*!40000 ALTER TABLE `apscheduler_jobs` DISABLE KEYS */;
  173. /*!40000 ALTER TABLE `apscheduler_jobs` ENABLE KEYS */;
  174. --
  175. -- Table structure for table `gen_demo`
  176. --
  177. DROP TABLE IF EXISTS `gen_demo`;
  178. /*!40101 SET @saved_cs_client = @@character_set_client */;
  179. /*!50503 SET character_set_client = utf8mb4 */;
  180. CREATE TABLE `gen_demo` (
  181. `name` varchar(64) DEFAULT NULL COMMENT '名称',
  182. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  183. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  184. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  185. `description` text COMMENT '备注/描述',
  186. `created_time` datetime NOT NULL COMMENT '创建时间',
  187. `updated_time` datetime NOT NULL COMMENT '更新时间',
  188. `created_id` int DEFAULT NULL COMMENT '创建人ID',
  189. `updated_id` int DEFAULT NULL COMMENT '更新人ID',
  190. PRIMARY KEY (`id`),
  191. UNIQUE KEY `uuid` (`uuid`),
  192. KEY `ix_gen_demo_created_id` (`created_id`),
  193. KEY `ix_gen_demo_updated_id` (`updated_id`),
  194. CONSTRAINT `gen_demo_ibfk_1` FOREIGN KEY (`created_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  195. CONSTRAINT `gen_demo_ibfk_2` FOREIGN KEY (`updated_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
  196. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='示例表';
  197. /*!40101 SET character_set_client = @saved_cs_client */;
  198. --
  199. -- Dumping data for table `gen_demo`
  200. --
  201. /*!40000 ALTER TABLE `gen_demo` DISABLE KEYS */;
  202. /*!40000 ALTER TABLE `gen_demo` ENABLE KEYS */;
  203. --
  204. -- Table structure for table `gen_table`
  205. --
  206. DROP TABLE IF EXISTS `gen_table`;
  207. /*!40101 SET @saved_cs_client = @@character_set_client */;
  208. /*!50503 SET character_set_client = utf8mb4 */;
  209. CREATE TABLE `gen_table` (
  210. `table_name` varchar(200) NOT NULL COMMENT '表名称',
  211. `table_comment` varchar(500) DEFAULT NULL COMMENT '表描述',
  212. `class_name` varchar(100) NOT NULL COMMENT '实体类名称',
  213. `package_name` varchar(100) DEFAULT NULL COMMENT '生成包路径',
  214. `module_name` varchar(30) DEFAULT NULL COMMENT '生成模块名',
  215. `business_name` varchar(30) DEFAULT NULL COMMENT '生成业务名',
  216. `function_name` varchar(100) DEFAULT NULL COMMENT '生成功能名',
  217. `sub_table_name` varchar(64) DEFAULT NULL COMMENT '关联子表的表名',
  218. `sub_table_fk_name` varchar(64) DEFAULT NULL COMMENT '子表关联的外键名',
  219. `parent_menu_id` int DEFAULT NULL COMMENT '父菜单ID',
  220. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  221. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  222. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  223. `description` text COMMENT '备注/描述',
  224. `created_time` datetime NOT NULL COMMENT '创建时间',
  225. `updated_time` datetime NOT NULL COMMENT '更新时间',
  226. `created_id` int DEFAULT NULL COMMENT '创建人ID',
  227. `updated_id` int DEFAULT NULL COMMENT '更新人ID',
  228. PRIMARY KEY (`id`),
  229. UNIQUE KEY `uuid` (`uuid`),
  230. KEY `ix_gen_table_created_id` (`created_id`),
  231. KEY `ix_gen_table_updated_id` (`updated_id`),
  232. CONSTRAINT `gen_table_ibfk_1` FOREIGN KEY (`created_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  233. CONSTRAINT `gen_table_ibfk_2` FOREIGN KEY (`updated_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
  234. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='代码生成表';
  235. /*!40101 SET character_set_client = @saved_cs_client */;
  236. --
  237. -- Dumping data for table `gen_table`
  238. --
  239. /*!40000 ALTER TABLE `gen_table` DISABLE KEYS */;
  240. /*!40000 ALTER TABLE `gen_table` ENABLE KEYS */;
  241. --
  242. -- Table structure for table `gen_table_column`
  243. --
  244. DROP TABLE IF EXISTS `gen_table_column`;
  245. /*!40101 SET @saved_cs_client = @@character_set_client */;
  246. /*!50503 SET character_set_client = utf8mb4 */;
  247. CREATE TABLE `gen_table_column` (
  248. `column_name` varchar(200) NOT NULL COMMENT '列名称',
  249. `column_comment` varchar(500) DEFAULT NULL COMMENT '列描述',
  250. `column_type` varchar(100) NOT NULL COMMENT '列类型',
  251. `column_length` varchar(50) DEFAULT NULL COMMENT '列长度',
  252. `column_default` varchar(200) DEFAULT NULL COMMENT '列默认值',
  253. `is_pk` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否主键',
  254. `is_increment` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否自增',
  255. `is_nullable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否允许为空',
  256. `is_unique` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否唯一',
  257. `python_type` varchar(100) DEFAULT NULL COMMENT 'Python类型',
  258. `python_field` varchar(200) DEFAULT NULL COMMENT 'Python字段名',
  259. `is_insert` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否为新增字段',
  260. `is_edit` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否编辑字段',
  261. `is_list` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否列表字段',
  262. `is_query` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否查询字段',
  263. `query_type` varchar(50) DEFAULT NULL COMMENT '查询方式',
  264. `html_type` varchar(100) DEFAULT NULL COMMENT '显示类型',
  265. `dict_type` varchar(200) DEFAULT NULL COMMENT '字典类型',
  266. `sort` int NOT NULL COMMENT '排序',
  267. `table_id` int NOT NULL COMMENT '归属表编号',
  268. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  269. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  270. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  271. `description` text COMMENT '备注/描述',
  272. `created_time` datetime NOT NULL COMMENT '创建时间',
  273. `updated_time` datetime NOT NULL COMMENT '更新时间',
  274. `created_id` int DEFAULT NULL COMMENT '创建人ID',
  275. `updated_id` int DEFAULT NULL COMMENT '更新人ID',
  276. PRIMARY KEY (`id`),
  277. UNIQUE KEY `uuid` (`uuid`),
  278. KEY `ix_gen_table_column_created_id` (`created_id`),
  279. KEY `ix_gen_table_column_updated_id` (`updated_id`),
  280. KEY `ix_gen_table_column_table_id` (`table_id`),
  281. CONSTRAINT `gen_table_column_ibfk_1` FOREIGN KEY (`table_id`) REFERENCES `gen_table` (`id`) ON DELETE CASCADE,
  282. CONSTRAINT `gen_table_column_ibfk_2` FOREIGN KEY (`created_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  283. CONSTRAINT `gen_table_column_ibfk_3` FOREIGN KEY (`updated_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
  284. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='代码生成表字段';
  285. /*!40101 SET character_set_client = @saved_cs_client */;
  286. --
  287. -- Dumping data for table `gen_table_column`
  288. --
  289. /*!40000 ALTER TABLE `gen_table_column` DISABLE KEYS */;
  290. /*!40000 ALTER TABLE `gen_table_column` ENABLE KEYS */;
  291. --
  292. -- Table structure for table `sys_dept`
  293. --
  294. DROP TABLE IF EXISTS `sys_dept`;
  295. /*!40101 SET @saved_cs_client = @@character_set_client */;
  296. /*!50503 SET character_set_client = utf8mb4 */;
  297. CREATE TABLE `sys_dept` (
  298. `name` varchar(40) NOT NULL COMMENT '部门名称',
  299. `order` int NOT NULL COMMENT '显示排序',
  300. `code` varchar(20) DEFAULT NULL COMMENT '部门编码',
  301. `leader` varchar(32) DEFAULT NULL COMMENT '部门负责人',
  302. `phone` varchar(11) DEFAULT NULL COMMENT '手机',
  303. `email` varchar(64) DEFAULT NULL COMMENT '邮箱',
  304. `parent_id` int DEFAULT NULL COMMENT '父级部门ID',
  305. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  306. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  307. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  308. `description` text COMMENT '备注/描述',
  309. `created_time` datetime NOT NULL COMMENT '创建时间',
  310. `updated_time` datetime NOT NULL COMMENT '更新时间',
  311. PRIMARY KEY (`id`),
  312. UNIQUE KEY `uuid` (`uuid`),
  313. KEY `ix_sys_dept_parent_id` (`parent_id`),
  314. KEY `ix_sys_dept_code` (`code`),
  315. CONSTRAINT `sys_dept_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `sys_dept` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
  316. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='部门表';
  317. /*!40101 SET character_set_client = @saved_cs_client */;
  318. --
  319. -- Dumping data for table `sys_dept`
  320. --
  321. /*!40000 ALTER TABLE `sys_dept` DISABLE KEYS */;
  322. INSERT INTO `sys_dept` VALUES ('集团总公司',1,'GROUP','部门负责人','1582112620','deptadmin@example.com',NULL,1,'fd26c8ee-8fb8-4dbe-8955-f72443089a41','0','集团总公司','2025-12-04 22:13:20','2025-12-04 22:13:20');
  323. /*!40000 ALTER TABLE `sys_dept` ENABLE KEYS */;
  324. --
  325. -- Table structure for table `sys_dict_data`
  326. --
  327. DROP TABLE IF EXISTS `sys_dict_data`;
  328. /*!40101 SET @saved_cs_client = @@character_set_client */;
  329. /*!50503 SET character_set_client = utf8mb4 */;
  330. CREATE TABLE `sys_dict_data` (
  331. `dict_sort` int NOT NULL COMMENT '字典排序',
  332. `dict_label` varchar(255) NOT NULL COMMENT '字典标签',
  333. `dict_value` varchar(255) NOT NULL COMMENT '字典键值',
  334. `css_class` varchar(255) DEFAULT NULL COMMENT '样式属性(其他样式扩展)',
  335. `list_class` varchar(255) DEFAULT NULL COMMENT '表格回显样式',
  336. `is_default` tinyint(1) NOT NULL COMMENT '是否默认(True是 False否)',
  337. `dict_type` varchar(255) NOT NULL COMMENT '字典类型',
  338. `dict_type_id` int NOT NULL COMMENT '字典类型ID',
  339. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  340. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  341. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  342. `description` text COMMENT '备注/描述',
  343. `created_time` datetime NOT NULL COMMENT '创建时间',
  344. `updated_time` datetime NOT NULL COMMENT '更新时间',
  345. PRIMARY KEY (`id`),
  346. UNIQUE KEY `uuid` (`uuid`),
  347. KEY `dict_type_id` (`dict_type_id`),
  348. CONSTRAINT `sys_dict_data_ibfk_1` FOREIGN KEY (`dict_type_id`) REFERENCES `sys_dict_type` (`id`) ON DELETE CASCADE
  349. ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典数据表';
  350. /*!40101 SET character_set_client = @saved_cs_client */;
  351. --
  352. -- Dumping data for table `sys_dict_data`
  353. --
  354. /*!40000 ALTER TABLE `sys_dict_data` DISABLE KEYS */;
  355. INSERT INTO `sys_dict_data` VALUES (1,'男','0','blue',NULL,1,'sys_user_sex',1,1,'cdc79615-d9f7-4c7d-9ee2-fc9ebb63be9f','0','性别男','2025-12-04 22:13:20','2025-12-04 22:13:20'),(2,'女','1','pink',NULL,0,'sys_user_sex',1,2,'5d354c73-481a-48bc-8f7f-c131c7d2773e','0','性别女','2025-12-04 22:13:20','2025-12-04 22:13:20'),(3,'未知','2','red',NULL,0,'sys_user_sex',1,3,'60bea9c3-eb76-4076-87d3-5879f843fb58','0','性别未知','2025-12-04 22:13:20','2025-12-04 22:13:20'),(1,'是','1','','primary',1,'sys_yes_no',2,4,'113cf2d8-5a1a-400b-8dc8-f0c328609479','0','是','2025-12-04 22:13:20','2025-12-04 22:13:20'),(2,'否','0','','danger',0,'sys_yes_no',2,5,'ce71548c-bafe-4fc8-b249-81d220669ad0','0','否','2025-12-04 22:13:20','2025-12-04 22:13:20'),(1,'启用','1','','primary',0,'sys_common_status',3,6,'2e95ccd1-c3f2-4fb2-8c8b-90fd0204b8c7','0','启用状态','2025-12-04 22:13:20','2025-12-04 22:13:20'),(2,'停用','0','','danger',0,'sys_common_status',3,7,'23b2da6c-5c84-446e-bbd9-6cf92c6f784c','0','停用状态','2025-12-04 22:13:20','2025-12-04 22:13:20'),(1,'通知','1','blue','warning',1,'sys_notice_type',4,8,'88e53e0d-1936-4b0d-917e-824a5f578cef','0','通知','2025-12-04 22:13:20','2025-12-04 22:13:20'),(2,'公告','2','orange','success',0,'sys_notice_type',4,9,'52d38c19-df02-43bd-82f1-b129faa45243','0','公告','2025-12-04 22:13:20','2025-12-04 22:13:20'),(99,'其他','0','','info',0,'sys_oper_type',5,10,'0eb24b46-9927-4378-a13f-07f2a68d1098','0','其他操作','2025-12-04 22:13:20','2025-12-04 22:13:20'),(1,'新增','1','','info',0,'sys_oper_type',5,11,'da656906-a590-4fa8-a572-eaaac3795293','0','新增操作','2025-12-04 22:13:20','2025-12-04 22:13:20'),(2,'修改','2','','info',0,'sys_oper_type',5,12,'8271e5c8-a91b-4a77-acfb-c1fe80c22328','0','修改操作','2025-12-04 22:13:20','2025-12-04 22:13:20'),(3,'删除','3','','danger',0,'sys_oper_type',5,13,'03c41a43-7df0-4c40-938f-15e3372012a1','0','删除操作','2025-12-04 22:13:20','2025-12-04 22:13:20'),(4,'分配权限','4','','primary',0,'sys_oper_type',5,14,'fcf02194-ab42-498b-b819-1dfe59aeb94d','0','授权操作','2025-12-04 22:13:20','2025-12-04 22:13:20'),(5,'导出','5','','warning',0,'sys_oper_type',5,15,'8562ffac-517f-42cf-9fee-0f1011e3cd5c','0','导出操作','2025-12-04 22:13:20','2025-12-04 22:13:20'),(6,'导入','6','','warning',0,'sys_oper_type',5,16,'a9502d4a-7bbd-4ad2-86d2-116e1f0dd7bd','0','导入操作','2025-12-04 22:13:20','2025-12-04 22:13:20'),(7,'强退','7','','danger',0,'sys_oper_type',5,17,'c8791121-6b5d-4973-b3f6-c3398538103c','0','强退操作','2025-12-04 22:13:20','2025-12-04 22:13:20'),(8,'生成代码','8','','warning',0,'sys_oper_type',5,18,'d185f1c3-a6a2-4b9a-a1b3-d98d9c91bbca','0','生成操作','2025-12-04 22:13:20','2025-12-04 22:13:20'),(9,'清空数据','9','','danger',0,'sys_oper_type',5,19,'f7f1567b-8ab9-47fb-a01b-96d570242912','0','清空操作','2025-12-04 22:13:20','2025-12-04 22:13:20'),(1,'默认(Memory)','default','',NULL,1,'sys_job_store',6,20,'c5336690-4068-4b74-985d-00f18b17f2b2','0','默认分组','2025-12-04 22:13:20','2025-12-04 22:13:20'),(2,'数据库(Sqlalchemy)','sqlalchemy','',NULL,0,'sys_job_store',6,21,'31924a7c-1d40-4e0f-a825-e7db92762457','0','数据库分组','2025-12-04 22:13:20','2025-12-04 22:13:20'),(3,'数据库(Redis)','redis','',NULL,0,'sys_job_store',6,22,'ae07cce7-105c-4fd7-a2e9-905ca0188aa4','0','reids分组','2025-12-04 22:13:20','2025-12-04 22:13:20'),(1,'线程池','default','',NULL,0,'sys_job_executor',7,23,'dbd7fabf-050d-4f1c-ad6c-17f19d562b5e','0','线程池','2025-12-04 22:13:20','2025-12-04 22:13:20'),(2,'进程池','processpool','',NULL,0,'sys_job_executor',7,24,'9987875b-b9cf-4277-96de-16f51eba00ab','0','进程池','2025-12-04 22:13:20','2025-12-04 22:13:20'),(1,'演示函数','scheduler_test.job','',NULL,1,'sys_job_function',8,25,'9e5e997d-c66b-48cd-afa9-c504b0cbdb05','0','演示函数','2025-12-04 22:13:20','2025-12-04 22:13:20'),(1,'指定日期(date)','date','',NULL,1,'sys_job_trigger',9,26,'d2fc2845-32ab-4f09-b80a-3a665ea275ee','0','指定日期任务触发器','2025-12-04 22:13:20','2025-12-04 22:13:20'),(2,'间隔触发器(interval)','interval','',NULL,0,'sys_job_trigger',9,27,'ef8b609a-46f2-4aed-8e28-b6efeee0e5f8','0','间隔触发器任务触发器','2025-12-04 22:13:20','2025-12-04 22:13:20'),(3,'cron表达式','cron','',NULL,0,'sys_job_trigger',9,28,'239a4c9e-aa31-4b88-bbce-176928f47b65','0','间隔触发器任务触发器','2025-12-04 22:13:20','2025-12-04 22:13:20'),(1,'默认(default)','default','',NULL,1,'sys_list_class',10,29,'8c4a7064-60fb-4ce7-b585-0904e5d3f96c','0','默认表格回显样式','2025-12-04 22:13:20','2025-12-04 22:13:20'),(2,'主要(primary)','primary','',NULL,0,'sys_list_class',10,30,'60b05aa6-2c95-4fcc-bb97-33a1d8d9084d','0','主要表格回显样式','2025-12-04 22:13:20','2025-12-04 22:13:20'),(3,'成功(success)','success','',NULL,0,'sys_list_class',10,31,'e446b174-4ba0-45f1-b822-a3684133ca0c','0','成功表格回显样式','2025-12-04 22:13:20','2025-12-04 22:13:20'),(4,'信息(info)','info','',NULL,0,'sys_list_class',10,32,'4d93f634-0966-4dc4-8021-6f533e6971a3','0','信息表格回显样式','2025-12-04 22:13:20','2025-12-04 22:13:20'),(5,'警告(warning)','warning','',NULL,0,'sys_list_class',10,33,'39e43a39-e2e5-43f6-9df2-6c05a3f3d75d','0','警告表格回显样式','2025-12-04 22:13:20','2025-12-04 22:13:20'),(6,'危险(danger)','danger','',NULL,0,'sys_list_class',10,34,'70d48977-fd15-48c6-bfb8-f73c4efd7e4e','0','危险表格回显样式','2025-12-04 22:13:20','2025-12-04 22:13:20');
  356. /*!40000 ALTER TABLE `sys_dict_data` ENABLE KEYS */;
  357. --
  358. -- Table structure for table `sys_dict_type`
  359. --
  360. DROP TABLE IF EXISTS `sys_dict_type`;
  361. /*!40101 SET @saved_cs_client = @@character_set_client */;
  362. /*!50503 SET character_set_client = utf8mb4 */;
  363. CREATE TABLE `sys_dict_type` (
  364. `dict_name` varchar(255) NOT NULL COMMENT '字典名称',
  365. `dict_type` varchar(255) NOT NULL COMMENT '字典类型',
  366. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  367. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  368. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  369. `description` text COMMENT '备注/描述',
  370. `created_time` datetime NOT NULL COMMENT '创建时间',
  371. `updated_time` datetime NOT NULL COMMENT '更新时间',
  372. PRIMARY KEY (`id`),
  373. UNIQUE KEY `dict_type` (`dict_type`),
  374. UNIQUE KEY `uuid` (`uuid`)
  375. ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典类型表';
  376. /*!40101 SET character_set_client = @saved_cs_client */;
  377. --
  378. -- Dumping data for table `sys_dict_type`
  379. --
  380. /*!40000 ALTER TABLE `sys_dict_type` DISABLE KEYS */;
  381. INSERT INTO `sys_dict_type` VALUES ('用户性别','sys_user_sex',1,'c013bc5a-cb3f-469c-a9ee-8bd9d055410b','0','用户性别列表','2025-12-04 22:13:20','2025-12-04 22:13:20'),('系统是否','sys_yes_no',2,'8d44339e-a860-47fb-a5e5-6cc8b65793f8','0','系统是否列表','2025-12-04 22:13:20','2025-12-04 22:13:20'),('系统状态','sys_common_status',3,'94023e9d-3657-4c1c-b3ba-6253ac25ee26','0','系统状态','2025-12-04 22:13:20','2025-12-04 22:13:20'),('通知类型','sys_notice_type',4,'9b7c871f-2d8a-4df7-bdaf-858cbfb37298','0','通知类型列表','2025-12-04 22:13:20','2025-12-04 22:13:20'),('操作类型','sys_oper_type',5,'6dd7cdb0-ea35-4644-a6ca-000691571c4d','0','操作类型列表','2025-12-04 22:13:20','2025-12-04 22:13:20'),('任务存储器','sys_job_store',6,'6592df8d-d5cf-4417-810b-b63d716749b6','0','任务分组列表','2025-12-04 22:13:20','2025-12-04 22:13:20'),('任务执行器','sys_job_executor',7,'890cfd50-bbf5-47d3-9d88-cebfd8163747','0','任务执行器列表','2025-12-04 22:13:20','2025-12-04 22:13:20'),('任务函数','sys_job_function',8,'d65e0fb3-984a-4bd6-bc84-4776882190e5','0','任务函数列表','2025-12-04 22:13:20','2025-12-04 22:13:20'),('任务触发器','sys_job_trigger',9,'5427e0fc-8c0b-4745-91c9-e36beeb37d19','0','任务触发器列表','2025-12-04 22:13:20','2025-12-04 22:13:20'),('表格回显样式','sys_list_class',10,'0700559c-2224-40d3-8a08-c576fe404272','0','表格回显样式列表','2025-12-04 22:13:20','2025-12-04 22:13:20');
  382. /*!40000 ALTER TABLE `sys_dict_type` ENABLE KEYS */;
  383. --
  384. -- Table structure for table `sys_log`
  385. --
  386. DROP TABLE IF EXISTS `sys_log`;
  387. /*!40101 SET @saved_cs_client = @@character_set_client */;
  388. /*!50503 SET character_set_client = utf8mb4 */;
  389. CREATE TABLE `sys_log` (
  390. `type` int NOT NULL COMMENT '日志类型(1登录日志 2操作日志)',
  391. `request_path` varchar(255) NOT NULL COMMENT '请求路径',
  392. `request_method` varchar(10) NOT NULL COMMENT '请求方式',
  393. `request_payload` text COMMENT '请求体',
  394. `request_ip` varchar(50) DEFAULT NULL COMMENT '请求IP地址',
  395. `login_location` varchar(255) DEFAULT NULL COMMENT '登录位置',
  396. `request_os` varchar(64) DEFAULT NULL COMMENT '操作系统',
  397. `request_browser` varchar(64) DEFAULT NULL COMMENT '浏览器',
  398. `response_code` int NOT NULL COMMENT '响应状态码',
  399. `response_json` text COMMENT '响应体',
  400. `process_time` varchar(20) DEFAULT NULL COMMENT '处理时间',
  401. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  402. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  403. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  404. `description` text COMMENT '备注/描述',
  405. `created_time` datetime NOT NULL COMMENT '创建时间',
  406. `updated_time` datetime NOT NULL COMMENT '更新时间',
  407. `created_id` int DEFAULT NULL COMMENT '创建人ID',
  408. `updated_id` int DEFAULT NULL COMMENT '更新人ID',
  409. PRIMARY KEY (`id`),
  410. UNIQUE KEY `uuid` (`uuid`),
  411. KEY `ix_sys_log_updated_id` (`updated_id`),
  412. KEY `ix_sys_log_created_id` (`created_id`),
  413. CONSTRAINT `sys_log_ibfk_1` FOREIGN KEY (`created_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  414. CONSTRAINT `sys_log_ibfk_2` FOREIGN KEY (`updated_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
  415. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统日志表';
  416. /*!40101 SET character_set_client = @saved_cs_client */;
  417. --
  418. -- Dumping data for table `sys_log`
  419. --
  420. /*!40000 ALTER TABLE `sys_log` DISABLE KEYS */;
  421. /*!40000 ALTER TABLE `sys_log` ENABLE KEYS */;
  422. --
  423. -- Table structure for table `sys_menu`
  424. --
  425. DROP TABLE IF EXISTS `sys_menu`;
  426. /*!40101 SET @saved_cs_client = @@character_set_client */;
  427. /*!50503 SET character_set_client = utf8mb4 */;
  428. CREATE TABLE `sys_menu` (
  429. `name` varchar(50) NOT NULL COMMENT '菜单名称',
  430. `type` int NOT NULL COMMENT '菜单类型(1:目录 2:菜单 3:按钮/权限 4:链接)',
  431. `order` int NOT NULL COMMENT '显示排序',
  432. `permission` varchar(100) DEFAULT NULL COMMENT '权限标识(如:module_system:user:list)',
  433. `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  434. `route_name` varchar(100) DEFAULT NULL COMMENT '路由名称',
  435. `route_path` varchar(200) DEFAULT NULL COMMENT '路由路径',
  436. `component_path` varchar(200) DEFAULT NULL COMMENT '组件路径',
  437. `redirect` varchar(200) DEFAULT NULL COMMENT '重定向地址',
  438. `hidden` tinyint(1) NOT NULL COMMENT '是否隐藏(True:隐藏 False:显示)',
  439. `keep_alive` tinyint(1) NOT NULL COMMENT '是否缓存(True:是 False:否)',
  440. `always_show` tinyint(1) NOT NULL COMMENT '是否始终显示(True:是 False:否)',
  441. `title` varchar(50) DEFAULT NULL COMMENT '菜单标题',
  442. `params` json DEFAULT NULL COMMENT '路由参数(JSON对象)',
  443. `affix` tinyint(1) NOT NULL COMMENT '是否固定标签页(True:是 False:否)',
  444. `parent_id` int DEFAULT NULL COMMENT '父菜单ID',
  445. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  446. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  447. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  448. `description` text COMMENT '备注/描述',
  449. `created_time` datetime NOT NULL COMMENT '创建时间',
  450. `updated_time` datetime NOT NULL COMMENT '更新时间',
  451. PRIMARY KEY (`id`),
  452. UNIQUE KEY `uuid` (`uuid`),
  453. KEY `ix_sys_menu_parent_id` (`parent_id`),
  454. CONSTRAINT `sys_menu_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `sys_menu` (`id`) ON DELETE SET NULL
  455. ) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单表';
  456. /*!40101 SET character_set_client = @saved_cs_client */;
  457. --
  458. -- Dumping data for table `sys_menu`
  459. --
  460. /*!40000 ALTER TABLE `sys_menu` DISABLE KEYS */;
  461. INSERT INTO `sys_menu` VALUES ('仪表盘',1,1,'','client','Dashboard','/dashboard',NULL,'/dashboard/workplace',0,1,1,'仪表盘','null',0,NULL,1,'cb4b6d66-e7ca-40b3-8bb6-93d303a67c72','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('系统管理',1,2,NULL,'system','System','/system',NULL,'/system/menu',0,1,0,'系统管理','null',0,NULL,2,'463da8d4-57fb-4a58-a4b8-e764e3b3cecf','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('应用管理',1,3,NULL,'el-icon-ShoppingBag','Application','/application',NULL,'/application/myapp',0,0,0,'应用管理','null',0,NULL,3,'62945c06-f52c-44f4-9941-6823c4f76a4e','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('监控管理',1,4,NULL,'monitor','Monitor','/monitor',NULL,'/monitor/online',0,0,0,'监控管理','null',0,NULL,4,'c0ef2b42-7b44-4b61-9e0d-6f394b1ad0fc','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('代码管理',1,5,NULL,'code','Generator','/generator',NULL,'/generator/gencode',0,0,0,'代码管理','null',0,NULL,5,'bb72faa7-c1b7-4bd8-b927-632905fc94e1','0','代码管理','2025-12-04 22:13:19','2025-12-04 22:13:19'),('接口管理',1,6,NULL,'document','Common','/common',NULL,'/common/docs',0,0,0,'接口管理','null',0,NULL,6,'6e936e8e-dbbe-4344-88e9-c5e4fd0361a2','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('模块管理',1,7,NULL,'menu','Gencode','/gencode',NULL,'/gencode/demo',0,0,0,'模块管理','null',0,NULL,7,'a8d485ce-6d8d-4e09-8b50-817062c958a3','0','模块管理','2025-12-04 22:13:19','2025-12-04 22:13:19'),('工作台',2,1,'dashboard:workplace:query','el-icon-PieChart','Workplace','/dashboard/workplace','dashboard/workplace',NULL,0,1,0,'工作台','null',0,1,8,'62bb634f-be53-491a-88d0-3a2ac3023744','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('菜单管理',2,1,'module_system:menu:query','menu','Menu','/system/menu','module_system/menu/index',NULL,0,1,0,'菜单管理','null',0,2,9,'bc02ff9f-6fd1-4ebd-8778-c0634bfe4cfd','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('部门管理',2,2,'module_system:dept:query','tree','Dept','/system/dept','module_system/dept/index',NULL,0,1,0,'部门管理','null',0,2,10,'2d816696-9844-42d9-aeb6-8d81c0ae63fe','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('岗位管理',2,3,'module_system:position:query','el-icon-Coordinate','Position','/system/position','module_system/position/index',NULL,0,1,0,'岗位管理','null',0,2,11,'bd52ed49-948e-4090-8963-0a5792944026','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('角色管理',2,4,'module_system:role:query','role','Role','/system/role','module_system/role/index',NULL,0,1,0,'角色管理','null',0,2,12,'e2aeb811-7046-4b16-9c3e-4ab9757582af','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('用户管理',2,5,'module_system:user:query','el-icon-User','User','/system/user','module_system/user/index',NULL,0,1,0,'用户管理','null',0,2,13,'a91c2f77-8082-4494-bf90-116859b737c7','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('日志管理',2,6,'module_system:log:query','el-icon-Aim','Log','/system/log','module_system/log/index',NULL,0,1,0,'日志管理','null',0,2,14,'8eb4afda-bdee-4a09-80f9-90452f9aff20','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('公告管理',2,7,'module_system:notice:query','bell','Notice','/system/notice','module_system/notice/index',NULL,0,1,0,'公告管理','null',0,2,15,'9d8fc784-33e4-4eda-9512-fe8ad22cc73b','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('参数管理',2,8,'module_system:param:query','setting','Params','/system/param','module_system/param/index',NULL,0,1,0,'参数管理','null',0,2,16,'131b6aac-40cd-4079-a49b-ce9801150d0b','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('字典管理',2,9,'module_system:dict_type:query','dict','Dict','/system/dict','module_system/dict/index',NULL,0,1,0,'字典管理','null',0,2,17,'6cecd766-3d26-43dd-beeb-184f10fe1d3f','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('我的应用',2,1,'module_application:myapp:query','el-icon-ShoppingCartFull','MYAPP','/application/myapp','module_application/myapp/index',NULL,0,1,0,'我的应用','null',0,3,18,'72cc4aca-3575-4545-a7e8-f12d9dcb0d08','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('任务管理',2,2,'module_application:job:query','el-icon-DataLine','Job','/application/job','module_application/job/index',NULL,0,1,0,'任务管理','null',0,3,19,'5e3ff424-9c4b-4ba2-a369-cf57ee5a80fe','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('AI智能助手',2,3,'module_application:ai:chat','el-icon-ToiletPaper','AI','/application/ai','module_application/ai/index',NULL,0,1,0,'AI智能助手','null',0,3,20,'c917c142-edad-41b0-91bb-81c4ada42cad','0','AI智能助手','2025-12-04 22:13:19','2025-12-04 22:13:19'),('流程管理',2,4,'module_application:workflow:query','el-icon-ShoppingBag','Workflow','/application/workflow','module_application/workflow/index',NULL,0,1,0,'我的流程','null',0,3,21,'73928ada-7f0a-4162-9f41-a4d812e2f46d','0','我的流程','2025-12-04 22:13:19','2025-12-04 22:13:19'),('在线用户',2,1,'module_monitor:online:query','el-icon-Headset','MonitorOnline','/monitor/online','module_monitor/online/index',NULL,0,0,0,'在线用户','null',0,4,22,'f1c25f62-4f94-4350-8aee-12ed5066165b','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('服务器监控',2,2,'module_monitor:server:query','el-icon-Odometer','MonitorServer','/monitor/server','module_monitor/server/index',NULL,0,0,0,'服务器监控','null',0,4,23,'606cc5be-cb57-4529-837b-791508744219','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('缓存监控',2,3,'module_monitor:cache:query','el-icon-Stopwatch','MonitorCache','/monitor/cache','module_monitor/cache/index',NULL,0,0,0,'缓存监控','null',0,4,24,'0a609124-5f7b-4f00-af8b-5cd0e2501317','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('文件管理',2,4,'module_monitor:resource:query','el-icon-Files','Resource','/monitor/resource','module_monitor/resource/index',NULL,0,1,0,'文件管理','null',0,4,25,'297baed4-dfe9-4bc3-a15f-50f87e809722','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('代码生成',2,1,'module_generator:gencode:query','code','GenCode','/generator/gencode','module_generator/gencode/index',NULL,0,1,0,'代码生成','null',0,5,26,'53a00f28-3140-48db-978e-e6b7eb6094b4','0','代码生成','2025-12-04 22:13:19','2025-12-04 22:13:19'),('Swagger文档',4,1,'module_common:docs:query','api','Docs','/common/docs','module_common/docs/index',NULL,0,0,0,'Swagger文档','null',0,6,27,'fd1263d6-5ca2-4d3b-baff-6e81409a3b9b','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('Redoc文档',4,2,'module_common:redoc:query','el-icon-Document','Redoc','/common/redoc','module_common/redoc/index',NULL,0,0,0,'Redoc文档','null',0,6,28,'ba186dc2-779f-4c8d-9286-4a20c78646f6','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('示例管理',2,1,'module_gencode:demo:query','menu','Demo','/gencode/demo','module_gencode/demo/index',NULL,0,1,0,'示例管理','null',0,7,29,'7fe20f79-2d4e-40e3-9e0e-784237d06ace','0','示例管理','2025-12-04 22:13:19','2025-12-04 22:13:19'),('创建菜单',3,1,'module_system:menu:create',NULL,NULL,NULL,NULL,NULL,0,1,0,'创建菜单','null',0,9,30,'d3448a0b-e776-41f0-ab20-f9c4375b3b07','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('修改菜单',3,2,'module_system:menu:update',NULL,NULL,NULL,NULL,NULL,0,1,0,'修改菜单','null',0,9,31,'19335b21-6ab1-4c04-9ed0-d3b80e977d03','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('删除菜单',3,3,'module_system:menu:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'删除菜单','null',0,9,32,'606b9f40-f116-4398-ace5-3e9961aea07e','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('批量修改菜单状态',3,4,'module_system:menu:patch',NULL,NULL,NULL,NULL,NULL,0,1,0,'批量修改菜单状态','null',0,9,33,'600c51e0-d001-4ba5-a961-b04e1fb50b1a','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('创建部门',3,1,'module_system:dept:create',NULL,NULL,NULL,NULL,NULL,0,1,0,'创建部门','null',0,10,34,'338e8331-e8a8-4eca-b09e-dd83bda22576','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('修改部门',3,2,'module_system:dept:update',NULL,NULL,NULL,NULL,NULL,0,1,0,'修改部门','null',0,10,35,'242afd04-85d2-4373-9e00-8718ae4c032f','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('删除部门',3,3,'module_system:dept:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'删除部门','null',0,10,36,'d9e2f8dc-4730-428b-a7bb-17ca783b64b9','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('批量修改部门状态',3,4,'module_system:dept:patch',NULL,NULL,NULL,NULL,NULL,0,1,0,'批量修改部门状态','null',0,10,37,'893b1b80-a651-47e3-b4c0-b044f1b27423','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('创建岗位',3,1,'module_system:position:create',NULL,NULL,NULL,NULL,NULL,0,1,0,'创建岗位','null',0,11,38,'f1fe9129-6bd6-4c72-939a-0c411a8822b4','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('修改岗位',3,2,'module_system:position:update',NULL,NULL,NULL,NULL,NULL,0,1,0,'修改岗位','null',0,11,39,'e7288bff-cb69-49b6-a39f-e88f41b53f83','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('删除岗位',3,3,'module_system:position:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'修改岗位','null',0,11,40,'872b1c4d-6c3b-41f9-b2b2-5299c55dd44f','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('批量修改岗位状态',3,4,'module_system:position:patch',NULL,NULL,NULL,NULL,NULL,0,1,0,'批量修改岗位状态','null',0,11,41,'f018c868-1a0d-49b4-be7b-ad8f127b1504','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('岗位导出',3,5,'module_system:position:export',NULL,NULL,NULL,NULL,NULL,0,1,0,'岗位导出','null',0,11,42,'cbe394bc-0627-4f89-99e2-b48de89d3121','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('设置角色权限',3,8,'module_system:role:permission',NULL,NULL,NULL,NULL,NULL,0,1,0,'设置角色权限','null',0,11,43,'5b62a581-6b3f-4a58-8fe6-61a72c853a95','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('创建角色',3,1,'module_system:role:create',NULL,NULL,NULL,NULL,NULL,0,1,0,'创建角色','null',0,12,44,'b50b092c-61d3-4aca-a89e-e5ca42d7b1dd','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('修改角色',3,2,'module_system:role:update',NULL,NULL,NULL,NULL,NULL,0,1,0,'修改角色','null',0,12,45,'a0b1a04c-aec1-4b1b-bc17-cdfe8a2c11c0','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('删除角色',3,3,'module_system:role:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'删除角色','null',0,12,46,'040dc3ee-ca5b-4521-a4c1-617b5c0eb34d','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('批量修改角色状态',3,4,'module_system:role:patch',NULL,NULL,NULL,NULL,NULL,0,1,0,'批量修改角色状态','null',0,12,47,'b9675590-51d0-43cc-b179-1ff7ad720865','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('角色导出',3,6,'module_system:role:export',NULL,NULL,NULL,NULL,NULL,0,1,0,'角色导出','null',0,12,48,'4720e2e3-8ca1-408a-bb05-53bf03ca3f3f','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('创建用户',3,1,'module_system:user:create',NULL,NULL,NULL,NULL,NULL,0,1,0,'创建用户','null',0,13,49,'b315f003-2b03-4de2-b973-f2db739ad471','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('修改用户',3,2,'module_system:user:update',NULL,NULL,NULL,NULL,NULL,0,1,0,'修改用户','null',0,13,50,'055528a9-73db-4f52-ac7a-41d349e608fe','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('删除用户',3,3,'module_system:user:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'删除用户','null',0,13,51,'365dff10-a7c0-4899-858a-e4d79f381e8c','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('批量修改用户状态',3,4,'module_system:user:patch',NULL,NULL,NULL,NULL,NULL,0,1,0,'批量修改用户状态','null',0,13,52,'73536219-3e3b-4d0f-a6a1-5068abc10fb6','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('导出用户',3,5,'module_system:user:export',NULL,NULL,NULL,NULL,NULL,0,1,0,'导出用户','null',0,13,53,'67a802f7-e12a-4f6e-a04d-44daacf853b9','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('导入用户',3,6,'module_system:user:import',NULL,NULL,NULL,NULL,NULL,0,1,0,'导入用户','null',0,13,54,'e598d21d-22bf-408b-a34e-41da67d7e05c','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('日志删除',3,1,'module_system:log:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'日志删除','null',0,14,55,'0200c882-5407-47e6-a377-44cdd27e6b6c','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('日志导出',3,2,'module_system:log:export',NULL,NULL,NULL,NULL,NULL,0,1,0,'日志导出','null',0,14,56,'9039923a-d1c3-4711-b031-ac92e93be7e9','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('公告创建',3,1,'module_system:notice:create',NULL,NULL,NULL,NULL,NULL,0,1,0,'公告创建','null',0,15,57,'f08c477a-75fd-4470-9996-724208894254','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('公告修改',3,2,'module_system:notice:update',NULL,NULL,NULL,NULL,NULL,0,1,0,'修改用户','null',0,15,58,'980e4ba6-9847-429e-8e24-fd471d134b4e','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('公告删除',3,3,'module_system:notice:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'公告删除','null',0,15,59,'a2e67a6c-4840-4a56-86d9-36c638dd0f96','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('公告导出',3,4,'module_system:notice:export',NULL,NULL,NULL,NULL,NULL,0,1,0,'公告导出','null',0,15,60,'62aa7d8f-bfcf-4d44-b026-754ba4ff050e','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('公告批量修改状态',3,5,'module_system:notice:patch',NULL,NULL,NULL,NULL,NULL,0,1,0,'公告批量修改状态','null',0,15,61,'55057f35-f506-4d90-8e03-5dd4de949db3','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('创建参数',3,1,'module_system:param:create',NULL,NULL,NULL,NULL,NULL,0,1,0,'创建参数','null',0,16,62,'b6cb724f-8ae4-4dc9-a41f-1c16848e3001','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('修改参数',3,2,'module_system:param:update',NULL,NULL,NULL,NULL,NULL,0,1,0,'修改参数','null',0,16,63,'b8cb6b5f-1f49-4a9f-a035-0653d065280b','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('删除参数',3,3,'module_system:param:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'删除参数','null',0,16,64,'ad232066-5f4b-46c6-9f5b-4d2e376a960d','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('导出参数',3,4,'module_system:param:export',NULL,NULL,NULL,NULL,NULL,0,1,0,'导出参数','null',0,16,65,'0d5e48aa-2129-4217-a111-4ceb786063cf','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('参数上传',3,5,'module_system:param:upload',NULL,NULL,NULL,NULL,NULL,0,1,0,'参数上传','null',0,16,66,'8cf93443-187a-4e42-bd56-f45c5d23fae3','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('创建字典类型',3,1,'module_system:dict_type:create',NULL,NULL,NULL,NULL,NULL,0,1,0,'创建字典类型','null',0,17,67,'93592f63-c5c5-47b5-b03e-9b0a3d752a76','0','初始化数据','2025-12-04 22:13:19','2025-12-04 22:13:19'),('修改字典类型',3,2,'module_system:dict_type:update',NULL,NULL,NULL,NULL,NULL,0,1,0,'修改字典类型','null',0,17,68,'c6cb02e6-7ee2-491e-8750-f7e64f9285ca','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('删除字典类型',3,3,'module_system:dict_type:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'删除字典类型','null',0,17,69,'47b17fe0-16a9-4668-a6b9-3fac7837c29f','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('导出字典类型',3,4,'module_system:dict_type:export',NULL,NULL,NULL,NULL,NULL,0,1,0,'导出字典类型','null',0,17,70,'bdcdfe0d-09ea-424d-9a3a-92693b63b57c','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('批量修改字典状态',3,5,'module_system:dict_type:patch',NULL,NULL,NULL,NULL,NULL,0,1,0,'导出字典类型','null',0,17,71,'954900a1-39bf-4439-bead-86f045ab89ad','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('字典数据查询',3,6,'module_system:dict_data:query',NULL,NULL,NULL,NULL,NULL,0,1,0,'字典数据查询','null',0,17,72,'6e4f02b2-667c-4b7f-95c9-e61c43bee902','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('创建字典数据',3,7,'module_system:dict_data:create',NULL,NULL,NULL,NULL,NULL,0,1,0,'创建字典数据','null',0,17,73,'ea7dfe93-ce16-44de-b72e-e8c114740ae8','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('修改字典数据',3,8,'module_system:dict_data:update',NULL,NULL,NULL,NULL,NULL,0,1,0,'修改字典数据','null',0,17,74,'cfb6a1a1-1971-48e1-9768-aac0742b8044','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('删除字典数据',3,9,'module_system:dict_data:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'删除字典数据','null',0,17,75,'1f4ac78b-35b1-4bbd-8c9b-f1430b9ab02a','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('导出字典数据',3,10,'module_system:dict_data:export',NULL,NULL,NULL,NULL,NULL,0,1,0,'导出字典数据','null',0,17,76,'e6448cb7-bb41-478f-abe4-e8d9e3cc2b53','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('批量修改字典数据状态',3,11,'module_system:dict_data:patch',NULL,NULL,NULL,NULL,NULL,0,1,0,'批量修改字典数据状态','null',0,17,77,'199b6564-18f5-4286-9052-fac9a338c26d','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('创建应用',3,1,'module_application:myapp:create',NULL,NULL,NULL,NULL,NULL,0,1,0,'创建应用','null',0,18,78,'383b9514-3301-4246-ad5d-2568cc53bee8','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('修改应用',3,2,'module_application:myapp:update',NULL,NULL,NULL,NULL,NULL,0,1,0,'修改应用','null',0,18,79,'6ddff587-dc9b-4e3f-a57f-bfc07e13e2fc','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('删除应用',3,3,'module_application:myapp:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'删除应用','null',0,18,80,'a17bbe6f-1da4-4af3-ad8e-326a0e6fcc65','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('批量修改应用状态',3,4,'module_application:myapp:patch',NULL,NULL,NULL,NULL,NULL,0,1,0,'批量修改应用状态','null',0,18,81,'644335a6-0233-4c5d-a58c-46e989c665bc','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('创建任务',3,1,'module_application:job:create',NULL,NULL,NULL,NULL,NULL,0,1,0,'创建任务','null',0,19,82,'a1b235df-28e0-45b4-bb67-ffbf80ee9c80','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('修改和操作任务',3,2,'module_application:job:update',NULL,NULL,NULL,NULL,NULL,0,1,0,'修改和操作任务','null',0,19,83,'82a0b73c-f49b-4644-b40e-f5e13e703659','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('删除和清除任务',3,3,'module_application:job:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'删除和清除任务','null',0,19,84,'33a6de8a-8100-472e-a79c-b53c55f2f4f9','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('导出定时任务',3,4,'module_application:job:export',NULL,NULL,NULL,NULL,NULL,0,1,0,'导出定时任务','null',0,19,85,'865a9aea-e054-44b1-b9b8-878a4640cd30','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('智能对话',3,1,'module_application:ai:chat',NULL,NULL,NULL,NULL,NULL,0,1,0,'智能对话','null',0,20,86,'529c801f-f71d-47c7-9ed5-6a97c14678e9','0','智能对话','2025-12-04 22:13:20','2025-12-04 22:13:20'),('在线用户强制下线',3,1,'module_monitor:online:delete',NULL,NULL,NULL,NULL,NULL,0,0,0,'在线用户强制下线','null',0,22,87,'12c6dfad-0ba1-4e53-bb39-1def93d5f96c','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('清除缓存',3,1,'module_monitor:cache:delete',NULL,NULL,NULL,NULL,NULL,0,0,0,'清除缓存','null',0,24,88,'f6ae80f9-4e26-44d7-82c9-c5e5eaa04e15','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('文件上传',3,1,'module_monitor:resource:upload',NULL,NULL,NULL,NULL,NULL,0,1,0,'文件上传','null',0,25,89,'5d362302-f8f8-4706-abea-5c8c04bed073','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('文件下载',3,2,'module_monitor:resource:download',NULL,NULL,NULL,NULL,NULL,0,1,0,'文件下载','null',0,25,90,'fa7f4611-7901-45a4-8cff-8aa04d84b120','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('文件删除',3,3,'module_monitor:resource:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'文件删除','null',0,25,91,'8d2d2261-a02d-44dd-85ad-aa5d527a611a','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('文件移动',3,4,'module_monitor:resource:move',NULL,NULL,NULL,NULL,NULL,0,1,0,'文件移动','null',0,25,92,'5628f8c3-7386-4f3c-8612-f53f7d630b46','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('文件复制',3,5,'module_monitor:resource:copy',NULL,NULL,NULL,NULL,NULL,0,1,0,'文件复制','null',0,25,93,'f765fbf7-dab1-44e4-8f71-717e6907f5c6','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('文件重命名',3,6,'module_monitor:resource:rename',NULL,NULL,NULL,NULL,NULL,0,1,0,'文件重命名','null',0,25,94,'27f6daca-2eff-4c44-adf7-ce87d1b54c23','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('创建目录',3,7,'module_monitor:resource:create_dir',NULL,NULL,NULL,NULL,NULL,0,1,0,'创建目录','null',0,25,95,'e4c38754-ffb2-464b-a914-0f6295229f72','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('导出文件列表',3,9,'module_monitor:resource:export',NULL,NULL,NULL,NULL,NULL,0,1,0,'导出文件列表','null',0,25,96,'862ad6ea-94c7-47be-a8c0-5d1e2011cc04','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('查询代码生成业务表列表',3,1,'module_generator:gencode:query',NULL,NULL,NULL,NULL,NULL,0,1,0,'查询代码生成业务表列表','null',0,26,97,'4afdd691-cedc-4dc3-a9d8-1ea0caa5d88a','0','查询代码生成业务表列表','2025-12-04 22:13:20','2025-12-04 22:13:20'),('创建表结构',3,2,'module_generator:gencode:create',NULL,NULL,NULL,NULL,NULL,0,1,0,'创建表结构','null',0,26,98,'cc44d1eb-6d4b-4021-bac4-bc8950929106','0','创建表结构','2025-12-04 22:13:20','2025-12-04 22:13:20'),('编辑业务表信息',3,3,'module_generator:gencode:update',NULL,NULL,NULL,NULL,NULL,0,1,0,'编辑业务表信息','null',0,26,99,'773175f6-2cc2-41ac-b850-d85fef452e91','0','编辑业务表信息','2025-12-04 22:13:20','2025-12-04 22:13:20'),('删除业务表信息',3,4,'module_generator:gencode:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'删除业务表信息','null',0,26,100,'e3f47375-d703-422c-812e-e74ee905c4ef','0','删除业务表信息','2025-12-04 22:13:20','2025-12-04 22:13:20'),('导入表结构',3,5,'module_generator:gencode:import',NULL,NULL,NULL,NULL,NULL,0,1,0,'导入表结构','null',0,26,101,'c623b688-1658-44c2-943a-d4e15c842268','0','导入表结构','2025-12-04 22:13:20','2025-12-04 22:13:20'),('批量生成代码',3,6,'module_generator:gencode:operate',NULL,NULL,NULL,NULL,NULL,0,1,0,'批量生成代码','null',0,26,102,'559957b7-fbc0-4d65-98f7-35e55ac9ae45','0','批量生成代码','2025-12-04 22:13:20','2025-12-04 22:13:20'),('生成代码到指定路径',3,7,'module_generator:gencode:code',NULL,NULL,NULL,NULL,NULL,0,1,0,'生成代码到指定路径','null',0,26,103,'79fea767-8cac-43e6-9afa-0219849e6351','0','生成代码到指定路径','2025-12-04 22:13:20','2025-12-04 22:13:20'),('查询数据库表列表',3,8,'module_generator:dblist:query',NULL,NULL,NULL,NULL,NULL,0,1,0,'查询数据库表列表','null',0,26,104,'2bcae664-f844-456d-8f1f-ea4786cabfef','0','查询数据库表列表','2025-12-04 22:13:20','2025-12-04 22:13:20'),('同步数据库',3,9,'module_generator:db:sync',NULL,NULL,NULL,NULL,NULL,0,1,0,'同步数据库','null',0,26,105,'68db7954-8032-4f3f-9b6f-325eddbb88b7','0','同步数据库','2025-12-04 22:13:20','2025-12-04 22:13:20'),('创建示例',3,1,'module_gencode:demo:create',NULL,NULL,NULL,NULL,NULL,0,1,0,'创建示例','null',0,29,106,'111b1a5d-80d2-4443-974b-53aaffd1ce8c','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('更新示例',3,2,'module_gencode:demo:update',NULL,NULL,NULL,NULL,NULL,0,1,0,'更新示例','null',0,29,107,'ec862776-6e4f-4bcc-8cd9-04147356f927','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('删除示例',3,3,'module_gencode:demo:delete',NULL,NULL,NULL,NULL,NULL,0,1,0,'删除示例','null',0,29,108,'c03a86cf-68f5-4850-9aea-1a7c4f3ad113','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('批量修改示例状态',3,4,'module_gencode:demo:patch',NULL,NULL,NULL,NULL,NULL,0,1,0,'批量修改示例状态','null',0,29,109,'15cdd940-8086-45f7-b847-fff1f6326b39','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('导出示例',3,5,'module_gencode:demo:export',NULL,NULL,NULL,NULL,NULL,0,1,0,'导出示例','null',0,29,110,'c191df95-bd10-41db-9d52-0d77a4c37b7e','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('导入示例',3,6,'module_gencode:demo:import',NULL,NULL,NULL,NULL,NULL,0,1,0,'导入示例','null',0,29,111,'48ad7c80-6767-48d6-8dad-064ad49330d2','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('下载导入示例模版',3,7,'module_gencode:demo:download',NULL,NULL,NULL,NULL,NULL,0,1,0,'下载导入示例模版','null',0,29,112,'5398a529-446d-4b7f-b8f2-620ba9260900','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20');
  462. /*!40000 ALTER TABLE `sys_menu` ENABLE KEYS */;
  463. --
  464. -- Table structure for table `sys_notice`
  465. --
  466. DROP TABLE IF EXISTS `sys_notice`;
  467. /*!40101 SET @saved_cs_client = @@character_set_client */;
  468. /*!50503 SET character_set_client = utf8mb4 */;
  469. CREATE TABLE `sys_notice` (
  470. `notice_title` varchar(50) NOT NULL COMMENT '公告标题',
  471. `notice_type` varchar(50) NOT NULL COMMENT '公告类型(1通知 2公告)',
  472. `notice_content` text COMMENT '公告内容',
  473. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  474. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  475. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  476. `description` text COMMENT '备注/描述',
  477. `created_time` datetime NOT NULL COMMENT '创建时间',
  478. `updated_time` datetime NOT NULL COMMENT '更新时间',
  479. `created_id` int DEFAULT NULL COMMENT '创建人ID',
  480. `updated_id` int DEFAULT NULL COMMENT '更新人ID',
  481. PRIMARY KEY (`id`),
  482. UNIQUE KEY `uuid` (`uuid`),
  483. KEY `ix_sys_notice_created_id` (`created_id`),
  484. KEY `ix_sys_notice_updated_id` (`updated_id`),
  485. CONSTRAINT `sys_notice_ibfk_1` FOREIGN KEY (`created_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  486. CONSTRAINT `sys_notice_ibfk_2` FOREIGN KEY (`updated_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
  487. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='通知公告表';
  488. /*!40101 SET character_set_client = @saved_cs_client */;
  489. --
  490. -- Dumping data for table `sys_notice`
  491. --
  492. /*!40000 ALTER TABLE `sys_notice` DISABLE KEYS */;
  493. /*!40000 ALTER TABLE `sys_notice` ENABLE KEYS */;
  494. --
  495. -- Table structure for table `sys_param`
  496. --
  497. DROP TABLE IF EXISTS `sys_param`;
  498. /*!40101 SET @saved_cs_client = @@character_set_client */;
  499. /*!50503 SET character_set_client = utf8mb4 */;
  500. CREATE TABLE `sys_param` (
  501. `config_name` varchar(500) NOT NULL COMMENT '参数名称',
  502. `config_key` varchar(500) NOT NULL COMMENT '参数键名',
  503. `config_value` varchar(500) DEFAULT NULL COMMENT '参数键值',
  504. `config_type` tinyint(1) DEFAULT NULL COMMENT '系统内置(True:是 False:否)',
  505. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  506. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  507. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  508. `description` text COMMENT '备注/描述',
  509. `created_time` datetime NOT NULL COMMENT '创建时间',
  510. `updated_time` datetime NOT NULL COMMENT '更新时间',
  511. PRIMARY KEY (`id`),
  512. UNIQUE KEY `uuid` (`uuid`)
  513. ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统参数表';
  514. /*!40101 SET character_set_client = @saved_cs_client */;
  515. --
  516. -- Dumping data for table `sys_param`
  517. --
  518. /*!40000 ALTER TABLE `sys_param` DISABLE KEYS */;
  519. INSERT INTO `sys_param` VALUES ('网站名称','sys_web_title','FastApiAdmin',1,1,'99a26847-da7f-4cf3-9a77-63c2b624f9b0','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('网站描述','sys_web_description','FastApiAdmin 是完全开源的权限管理系统',1,2,'8768add4-4722-45aa-9a1f-d8532d44b109','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('网页图标','sys_web_favicon','https://service.fastapiadmin.com/api/v1/static/image/favicon.png',1,3,'848146b5-71b6-471c-8daa-1bd503831fa0','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('网站Logo','sys_web_logo','https://service.fastapiadmin.com/api/v1/static/image/logo.png',1,4,'6d8ca22b-a66c-4d04-8686-1d68215106b8','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('登录背景','sys_login_background','https://service.fastapiadmin.com/api/v1/static/image/background.svg',1,5,'bccf8b9f-da8e-4981-b7a2-5ab18d4b0fe3','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('版权信息','sys_web_copyright','Copyright © 2025-2026 service.fastapiadmin.com 版权所有',1,6,'0a7f3bf5-79da-4eab-b113-5642d85f90b0','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('备案信息','sys_keep_record','陕ICP备2025069493号-1',1,7,'dfd29f83-aa0c-4b22-85c6-17980695888b','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('帮助文档','sys_help_doc','https://service.fastapiadmin.com',1,8,'241ecac4-e4c0-4020-919d-43424618ab22','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('隐私政策','sys_web_privacy','https://github.com/1014TaoTao/FastapiAdmin/blob/master/LICENSE',1,9,'87af3ea6-b363-4ac0-8c6f-dcdbcc55c46a','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('用户协议','sys_web_clause','https://github.com/1014TaoTao/FastapiAdmin/blob/master/LICENSE',1,10,'f318e994-a936-4faf-940e-bae4931d9c1a','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('源码代码','sys_git_code','https://github.com/1014TaoTao/FastapiAdmin.git',1,11,'46c56b5e-642a-451d-bca4-298fdc9ccb94','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('项目版本','sys_web_version','2.0.0',1,12,'5f7a07a8-6e1d-4eba-b6a0-8a77329429ae','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('演示模式启用','demo_enable','false',1,13,'a828490f-f795-43e6-ba24-056374227a97','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('演示访问IP白名单','ip_white_list','[\"127.0.0.1\"]',1,14,'f3387ea9-833a-43ae-85f5-b4d048bd2651','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('接口白名单','white_api_list_path','[\"/api/v1/system/auth/login\", \"/api/v1/system/auth/token/refresh\", \"/api/v1/system/auth/captcha/get\", \"/api/v1/system/auth/logout\", \"/api/v1/system/config/info\", \"/api/v1/system/user/current/info\", \"/api/v1/system/notice/available\"]',1,15,'371ed3f7-4516-431c-9fa2-a930ee5e3cfb','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20'),('访问IP黑名单','ip_black_list','[]',1,16,'66f1c69a-1fae-45ba-90c7-61744eeac469','0','初始化数据','2025-12-04 22:13:20','2025-12-04 22:13:20');
  520. /*!40000 ALTER TABLE `sys_param` ENABLE KEYS */;
  521. --
  522. -- Table structure for table `sys_position`
  523. --
  524. DROP TABLE IF EXISTS `sys_position`;
  525. /*!40101 SET @saved_cs_client = @@character_set_client */;
  526. /*!50503 SET character_set_client = utf8mb4 */;
  527. CREATE TABLE `sys_position` (
  528. `name` varchar(40) NOT NULL COMMENT '岗位名称',
  529. `order` int NOT NULL COMMENT '显示排序',
  530. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  531. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  532. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  533. `description` text COMMENT '备注/描述',
  534. `created_time` datetime NOT NULL COMMENT '创建时间',
  535. `updated_time` datetime NOT NULL COMMENT '更新时间',
  536. `created_id` int DEFAULT NULL COMMENT '创建人ID',
  537. `updated_id` int DEFAULT NULL COMMENT '更新人ID',
  538. PRIMARY KEY (`id`),
  539. UNIQUE KEY `uuid` (`uuid`),
  540. KEY `ix_sys_position_created_id` (`created_id`),
  541. KEY `ix_sys_position_updated_id` (`updated_id`),
  542. CONSTRAINT `sys_position_ibfk_1` FOREIGN KEY (`created_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  543. CONSTRAINT `sys_position_ibfk_2` FOREIGN KEY (`updated_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
  544. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='岗位表';
  545. /*!40101 SET character_set_client = @saved_cs_client */;
  546. --
  547. -- Dumping data for table `sys_position`
  548. --
  549. /*!40000 ALTER TABLE `sys_position` DISABLE KEYS */;
  550. /*!40000 ALTER TABLE `sys_position` ENABLE KEYS */;
  551. --
  552. -- Table structure for table `sys_role`
  553. --
  554. DROP TABLE IF EXISTS `sys_role`;
  555. /*!40101 SET @saved_cs_client = @@character_set_client */;
  556. /*!50503 SET character_set_client = utf8mb4 */;
  557. CREATE TABLE `sys_role` (
  558. `name` varchar(40) NOT NULL COMMENT '角色名称',
  559. `code` varchar(20) DEFAULT NULL COMMENT '角色编码',
  560. `order` int NOT NULL COMMENT '显示排序',
  561. `data_scope` int NOT NULL COMMENT '数据权限范围(1:仅本人 2:本部门 3:本部门及以下 4:全部 5:自定义)',
  562. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  563. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  564. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  565. `description` text COMMENT '备注/描述',
  566. `created_time` datetime NOT NULL COMMENT '创建时间',
  567. `updated_time` datetime NOT NULL COMMENT '更新时间',
  568. PRIMARY KEY (`id`),
  569. UNIQUE KEY `uuid` (`uuid`),
  570. KEY `ix_sys_role_code` (`code`)
  571. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色表';
  572. /*!40101 SET character_set_client = @saved_cs_client */;
  573. --
  574. -- Dumping data for table `sys_role`
  575. --
  576. /*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
  577. INSERT INTO `sys_role` VALUES ('管理员角色','ADMIN',1,4,1,'a64300ae-58f4-4ca9-8319-8fe706b4db33','0','初始化角色','2025-12-04 22:13:20','2025-12-04 22:13:20');
  578. /*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
  579. --
  580. -- Table structure for table `sys_role_depts`
  581. --
  582. DROP TABLE IF EXISTS `sys_role_depts`;
  583. /*!40101 SET @saved_cs_client = @@character_set_client */;
  584. /*!50503 SET character_set_client = utf8mb4 */;
  585. CREATE TABLE `sys_role_depts` (
  586. `role_id` int NOT NULL COMMENT '角色ID',
  587. `dept_id` int NOT NULL COMMENT '部门ID',
  588. PRIMARY KEY (`role_id`,`dept_id`),
  589. KEY `dept_id` (`dept_id`),
  590. CONSTRAINT `sys_role_depts_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  591. CONSTRAINT `sys_role_depts_ibfk_2` FOREIGN KEY (`dept_id`) REFERENCES `sys_dept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  592. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色部门关联表';
  593. /*!40101 SET character_set_client = @saved_cs_client */;
  594. --
  595. -- Dumping data for table `sys_role_depts`
  596. --
  597. /*!40000 ALTER TABLE `sys_role_depts` DISABLE KEYS */;
  598. /*!40000 ALTER TABLE `sys_role_depts` ENABLE KEYS */;
  599. --
  600. -- Table structure for table `sys_role_menus`
  601. --
  602. DROP TABLE IF EXISTS `sys_role_menus`;
  603. /*!40101 SET @saved_cs_client = @@character_set_client */;
  604. /*!50503 SET character_set_client = utf8mb4 */;
  605. CREATE TABLE `sys_role_menus` (
  606. `role_id` int NOT NULL COMMENT '角色ID',
  607. `menu_id` int NOT NULL COMMENT '菜单ID',
  608. PRIMARY KEY (`role_id`,`menu_id`),
  609. KEY `menu_id` (`menu_id`),
  610. CONSTRAINT `sys_role_menus_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  611. CONSTRAINT `sys_role_menus_ibfk_2` FOREIGN KEY (`menu_id`) REFERENCES `sys_menu` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  612. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色菜单关联表';
  613. /*!40101 SET character_set_client = @saved_cs_client */;
  614. --
  615. -- Dumping data for table `sys_role_menus`
  616. --
  617. /*!40000 ALTER TABLE `sys_role_menus` DISABLE KEYS */;
  618. /*!40000 ALTER TABLE `sys_role_menus` ENABLE KEYS */;
  619. --
  620. -- Table structure for table `sys_user`
  621. --
  622. DROP TABLE IF EXISTS `sys_user`;
  623. /*!40101 SET @saved_cs_client = @@character_set_client */;
  624. /*!50503 SET character_set_client = utf8mb4 */;
  625. CREATE TABLE `sys_user` (
  626. `username` varchar(32) NOT NULL COMMENT '用户名/登录账号',
  627. `password` varchar(255) NOT NULL COMMENT '密码哈希',
  628. `name` varchar(32) NOT NULL COMMENT '昵称',
  629. `mobile` varchar(11) DEFAULT NULL COMMENT '手机号',
  630. `email` varchar(64) DEFAULT NULL COMMENT '邮箱',
  631. `gender` varchar(1) DEFAULT NULL COMMENT '性别(0:男 1:女 2:未知)',
  632. `avatar` varchar(255) DEFAULT NULL COMMENT '头像URL地址',
  633. `is_superuser` tinyint(1) NOT NULL COMMENT '是否超管',
  634. `last_login` datetime DEFAULT NULL COMMENT '最后登录时间',
  635. `gitee_login` varchar(32) DEFAULT NULL COMMENT 'Gitee登录',
  636. `github_login` varchar(32) DEFAULT NULL COMMENT 'Github登录',
  637. `wx_login` varchar(32) DEFAULT NULL COMMENT '微信登录',
  638. `qq_login` varchar(32) DEFAULT NULL COMMENT 'QQ登录',
  639. `dept_id` int DEFAULT NULL COMMENT '部门ID',
  640. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  641. `uuid` varchar(64) NOT NULL COMMENT 'UUID全局唯一标识',
  642. `status` varchar(10) NOT NULL COMMENT '是否启用(0:启用 1:禁用)',
  643. `description` text COMMENT '备注/描述',
  644. `created_time` datetime NOT NULL COMMENT '创建时间',
  645. `updated_time` datetime NOT NULL COMMENT '更新时间',
  646. `created_id` int DEFAULT NULL COMMENT '创建人ID',
  647. `updated_id` int DEFAULT NULL COMMENT '更新人ID',
  648. PRIMARY KEY (`id`),
  649. UNIQUE KEY `username` (`username`),
  650. UNIQUE KEY `uuid` (`uuid`),
  651. UNIQUE KEY `mobile` (`mobile`),
  652. UNIQUE KEY `email` (`email`),
  653. KEY `ix_sys_user_created_id` (`created_id`),
  654. KEY `ix_sys_user_updated_id` (`updated_id`),
  655. KEY `ix_sys_user_dept_id` (`dept_id`),
  656. CONSTRAINT `sys_user_ibfk_1` FOREIGN KEY (`dept_id`) REFERENCES `sys_dept` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  657. CONSTRAINT `sys_user_ibfk_2` FOREIGN KEY (`created_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  658. CONSTRAINT `sys_user_ibfk_3` FOREIGN KEY (`updated_id`) REFERENCES `sys_user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
  659. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户表';
  660. /*!40101 SET character_set_client = @saved_cs_client */;
  661. --
  662. -- Dumping data for table `sys_user`
  663. --
  664. /*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
  665. INSERT INTO `sys_user` VALUES ('admin','$2b$12$e2IJgS/cvHgJ0H3G7Xa08OXoXnk6N/NX3IZRtubBDElA0VLZhkNOa','超级管理员',NULL,NULL,'0','https://service.fastapiadmin.com/api/v1/static/image/avatar.png',1,NULL,NULL,NULL,NULL,NULL,1,1,'55ca58bd-dac1-421c-aea1-033e5fbb7eff','0','超级管理员','2025-12-04 22:13:20','2025-12-04 22:13:20',NULL,NULL);
  666. /*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
  667. --
  668. -- Table structure for table `sys_user_positions`
  669. --
  670. DROP TABLE IF EXISTS `sys_user_positions`;
  671. /*!40101 SET @saved_cs_client = @@character_set_client */;
  672. /*!50503 SET character_set_client = utf8mb4 */;
  673. CREATE TABLE `sys_user_positions` (
  674. `user_id` int NOT NULL COMMENT '用户ID',
  675. `position_id` int NOT NULL COMMENT '岗位ID',
  676. PRIMARY KEY (`user_id`,`position_id`),
  677. KEY `position_id` (`position_id`),
  678. CONSTRAINT `sys_user_positions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  679. CONSTRAINT `sys_user_positions_ibfk_2` FOREIGN KEY (`position_id`) REFERENCES `sys_position` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  680. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户岗位关联表';
  681. /*!40101 SET character_set_client = @saved_cs_client */;
  682. --
  683. -- Dumping data for table `sys_user_positions`
  684. --
  685. /*!40000 ALTER TABLE `sys_user_positions` DISABLE KEYS */;
  686. /*!40000 ALTER TABLE `sys_user_positions` ENABLE KEYS */;
  687. --
  688. -- Table structure for table `sys_user_roles`
  689. --
  690. DROP TABLE IF EXISTS `sys_user_roles`;
  691. /*!40101 SET @saved_cs_client = @@character_set_client */;
  692. /*!50503 SET character_set_client = utf8mb4 */;
  693. CREATE TABLE `sys_user_roles` (
  694. `user_id` int NOT NULL COMMENT '用户ID',
  695. `role_id` int NOT NULL COMMENT '角色ID',
  696. PRIMARY KEY (`user_id`,`role_id`),
  697. KEY `role_id` (`role_id`),
  698. CONSTRAINT `sys_user_roles_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  699. CONSTRAINT `sys_user_roles_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  700. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户角色关联表';
  701. /*!40101 SET character_set_client = @saved_cs_client */;
  702. --
  703. -- Dumping data for table `sys_user_roles`
  704. --
  705. /*!40000 ALTER TABLE `sys_user_roles` DISABLE KEYS */;
  706. INSERT INTO `sys_user_roles` VALUES (1,1);
  707. /*!40000 ALTER TABLE `sys_user_roles` ENABLE KEYS */;
  708. --
  709. -- Dumping routines for database 'fastapiadmin'
  710. --
  711. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  712. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  713. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  714. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  715. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  716. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  717. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  718. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  719. -- Dump completed on 2025-12-04 22:13:36