-- MySQL dump 10.13  Distrib 8.0.35, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: intelligent_etmf_system
-- ------------------------------------------------------
-- Server version	8.0.35

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `applet_setting`
--

DROP TABLE IF EXISTS `applet_setting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `applet_setting` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '序号',
  `user_agreement` text COMMENT '用户协议',
  `privacy_agreement` text COMMENT '隐私协议',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `tenant_id` varchar(40) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='微信小程序设置';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `applet_setting`
--

LOCK TABLES `applet_setting` WRITE;
/*!40000 ALTER TABLE `applet_setting` DISABLE KEYS */;
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','');
/*!40000 ALTER TABLE `applet_setting` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gen_table`
--

DROP TABLE IF EXISTS `gen_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `gen_table` (
  `table_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `data_name` varchar(200) DEFAULT '' COMMENT '数据源名称',
  `table_name` varchar(200) DEFAULT '' COMMENT '表名称',
  `table_comment` varchar(500) DEFAULT '' COMMENT '表描述',
  `sub_table_name` varchar(64) DEFAULT NULL COMMENT '关联子表的表名',
  `sub_table_fk_name` varchar(64) DEFAULT NULL COMMENT '子表关联的外键名',
  `class_name` varchar(100) DEFAULT '' COMMENT '实体类名称',
  `tpl_category` varchar(200) DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作）',
  `package_name` varchar(100) DEFAULT NULL COMMENT '生成包路径',
  `module_name` varchar(30) DEFAULT NULL COMMENT '生成模块名',
  `business_name` varchar(30) DEFAULT NULL COMMENT '生成业务名',
  `function_name` varchar(50) DEFAULT NULL COMMENT '生成功能名',
  `function_author` varchar(50) DEFAULT NULL COMMENT '生成功能作者',
  `gen_type` char(1) DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）',
  `gen_path` varchar(200) DEFAULT '/' COMMENT '生成路径（不填默认项目路径）',
  `options` varchar(1000) DEFAULT NULL COMMENT '其它生成选项',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`table_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='代码生成业务表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gen_table`
--

LOCK TABLES `gen_table` WRITE;
/*!40000 ALTER TABLE `gen_table` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `gen_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gen_table_column`
--

DROP TABLE IF EXISTS `gen_table_column`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `gen_table_column` (
  `column_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_id` bigint DEFAULT NULL COMMENT '归属表编号',
  `column_name` varchar(200) DEFAULT NULL COMMENT '列名称',
  `column_comment` varchar(500) DEFAULT NULL COMMENT '列描述',
  `column_type` varchar(100) DEFAULT NULL COMMENT '列类型',
  `java_type` varchar(500) DEFAULT NULL COMMENT 'JAVA类型',
  `java_field` varchar(200) DEFAULT NULL COMMENT 'JAVA字段名',
  `is_pk` char(1) DEFAULT NULL COMMENT '是否主键（1是）',
  `is_increment` char(1) DEFAULT NULL COMMENT '是否自增（1是）',
  `is_required` char(1) DEFAULT NULL COMMENT '是否必填（1是）',
  `is_insert` char(1) DEFAULT NULL COMMENT '是否为插入字段（1是）',
  `is_edit` char(1) DEFAULT NULL COMMENT '是否编辑字段（1是）',
  `is_list` char(1) DEFAULT NULL COMMENT '是否列表字段（1是）',
  `is_query` char(1) DEFAULT NULL COMMENT '是否查询字段（1是）',
  `query_type` varchar(200) DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
  `html_type` varchar(200) DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
  `dict_type` varchar(200) DEFAULT '' COMMENT '字典类型',
  `sort` int DEFAULT NULL COMMENT '排序',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`column_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='代码生成业务表字段';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gen_table_column`
--

LOCK TABLES `gen_table_column` WRITE;
/*!40000 ALTER TABLE `gen_table_column` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `gen_table_column` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `project`
--

DROP TABLE IF EXISTS `project`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `project` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '序号',
  `code` varchar(128) NOT NULL COMMENT '项目编号',
  `name` varchar(128) NOT NULL COMMENT '名称',
  `icon` bigint NOT NULL COMMENT '图标',
  `language` char(1) NOT NULL DEFAULT '0' COMMENT '项目语言',
  `type` char(1) NOT NULL DEFAULT '0' COMMENT '项目类型',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `pd_gpd` bigint unsigned DEFAULT NULL COMMENT 'PD/GPD',
  `pm_gpm` bigint unsigned DEFAULT NULL COMMENT 'PM/GPM',
  `cta_gcta` bigint unsigned DEFAULT NULL COMMENT 'CTA/GCTA',
  `sponsor` varchar(128) DEFAULT NULL COMMENT '申办方',
  `cro` bigint unsigned DEFAULT NULL COMMENT 'CRO',
  `note` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `tenant_id` varchar(40) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='项目';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `project`
--

LOCK TABLES `project` WRITE;
/*!40000 ALTER TABLE `project` DISABLE KEYS */;
/*!40000 ALTER TABLE `project` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_client`
--

DROP TABLE IF EXISTS `sys_client`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_client` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `client_id` varchar(64) DEFAULT NULL COMMENT '客户端id',
  `client_key` varchar(32) DEFAULT NULL COMMENT '客户端key',
  `client_secret` varchar(255) DEFAULT NULL COMMENT '客户端秘钥',
  `grant_type` varchar(255) DEFAULT NULL COMMENT '授权类型',
  `device_type` varchar(32) DEFAULT NULL COMMENT '设备类型',
  `active_timeout` int DEFAULT '1800' COMMENT 'token活跃超时时间',
  `timeout` int DEFAULT '604800' COMMENT 'token固定超时',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统授权表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_client`
--

LOCK TABLES `sys_client` WRITE;
/*!40000 ALTER TABLE `sys_client` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `sys_client` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_config`
--

DROP TABLE IF EXISTS `sys_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_config` (
  `config_id` bigint NOT NULL AUTO_INCREMENT COMMENT '参数主键',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
  `config_name` varchar(100) DEFAULT '' COMMENT '参数名称',
  `config_key` varchar(100) DEFAULT '' COMMENT '参数键名',
  `config_value` varchar(500) DEFAULT '' COMMENT '参数键值',
  `config_type` char(1) DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`config_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='参数配置表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_config`
--

LOCK TABLES `sys_config` WRITE;
/*!40000 ALTER TABLE `sys_config` DISABLE KEYS */;
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:关闭');
/*!40000 ALTER TABLE `sys_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_dept`
--

DROP TABLE IF EXISTS `sys_dept`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_dept` (
  `dept_id` bigint NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
  `parent_id` bigint DEFAULT '0' COMMENT '父部门id',
  `ancestors` varchar(500) DEFAULT '' COMMENT '祖级列表',
  `dept_name` varchar(30) DEFAULT '' COMMENT '部门名称',
  `dept_category` varchar(100) DEFAULT NULL COMMENT '部门类别编码',
  `order_num` int DEFAULT '0' COMMENT '显示顺序',
  `leader` bigint DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `status` char(1) DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dept_id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='部门表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_dept`
--

LOCK TABLES `sys_dept` WRITE;
/*!40000 ALTER TABLE `sys_dept` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `sys_dept` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_dict_data`
--

DROP TABLE IF EXISTS `sys_dict_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_dict_data` (
  `dict_code` bigint NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
  `dict_sort` int DEFAULT '0' COMMENT '字典排序',
  `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',
  `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式',
  `is_default` char(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_code`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典数据表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_dict_data`
--

LOCK TABLES `sys_dict_data` WRITE;
/*!40000 ALTER TABLE `sys_dict_data` DISABLE KEYS */;
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','');
/*!40000 ALTER TABLE `sys_dict_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_dict_type`
--

DROP TABLE IF EXISTS `sys_dict_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_dict_type` (
  `dict_id` bigint NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
  `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_id`),
  UNIQUE KEY `tenant_id` (`tenant_id`,`dict_type`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典类型表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_dict_type`
--

LOCK TABLES `sys_dict_type` WRITE;
/*!40000 ALTER TABLE `sys_dict_type` DISABLE KEYS */;
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','每个项目的语言');
/*!40000 ALTER TABLE `sys_dict_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_logininfor`
--

DROP TABLE IF EXISTS `sys_logininfor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_logininfor` (
  `info_id` bigint NOT NULL AUTO_INCREMENT COMMENT '访问ID',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
  `user_name` varchar(50) DEFAULT '' COMMENT '用户账号',
  `client_key` varchar(32) DEFAULT '' COMMENT '客户端',
  `device_type` varchar(32) DEFAULT '' COMMENT '设备类型',
  `ipaddr` varchar(128) DEFAULT '' COMMENT '登录IP地址',
  `login_location` varchar(255) DEFAULT '' COMMENT '登录地点',
  `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型',
  `os` varchar(50) DEFAULT '' COMMENT '操作系统',
  `status` char(1) DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
  `msg` varchar(255) DEFAULT '' COMMENT '提示消息',
  `login_time` datetime DEFAULT NULL COMMENT '访问时间',
  PRIMARY KEY (`info_id`),
  KEY `idx_sys_logininfor_s` (`status`),
  KEY `idx_sys_logininfor_lt` (`login_time`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统访问记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_logininfor`
--

LOCK TABLES `sys_logininfor` WRITE;
/*!40000 ALTER TABLE `sys_logininfor` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `sys_logininfor` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_menu`
--

DROP TABLE IF EXISTS `sys_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_menu` (
  `menu_id` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(50) NOT NULL COMMENT '菜单名称',
  `parent_id` bigint DEFAULT '0' COMMENT '父菜单ID',
  `order_num` int DEFAULT '0' COMMENT '显示顺序',
  `path` varchar(200) DEFAULT '' COMMENT '路由地址',
  `component` varchar(255) DEFAULT NULL COMMENT '组件路径',
  `query_param` varchar(255) DEFAULT NULL COMMENT '路由参数',
  `is_frame` int DEFAULT '1' COMMENT '是否为外链（0是 1否）',
  `is_cache` int DEFAULT '0' COMMENT '是否缓存（0缓存 1不缓存）',
  `menu_type` char(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` char(1) DEFAULT '0' COMMENT '显示状态（0显示 1隐藏）',
  `status` char(1) DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
  `perms` varchar(100) DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1994324549864804363 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单权限表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_menu`
--

LOCK TABLES `sys_menu` WRITE;
/*!40000 ALTER TABLE `sys_menu` DISABLE KEYS */;
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','');
/*!40000 ALTER TABLE `sys_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_notice`
--

DROP TABLE IF EXISTS `sys_notice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_notice` (
  `notice_id` bigint NOT NULL AUTO_INCREMENT COMMENT '公告ID',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
  `notice_title` varchar(50) NOT NULL COMMENT '公告标题',
  `notice_type` char(1) NOT NULL COMMENT '公告类型（1通知 2公告）',
  `notice_content` longblob COMMENT '公告内容',
  `status` char(1) DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`notice_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='通知公告表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_notice`
--

LOCK TABLES `sys_notice` WRITE;
/*!40000 ALTER TABLE `sys_notice` DISABLE KEYS */;
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,'管理员');
/*!40000 ALTER TABLE `sys_notice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_oper_log`
--

DROP TABLE IF EXISTS `sys_oper_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_oper_log` (
  `oper_id` bigint NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
  `title` varchar(50) DEFAULT '' COMMENT '模块标题',
  `business_type` int DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',
  `method` varchar(100) DEFAULT '' COMMENT '方法名称',
  `request_method` varchar(10) DEFAULT '' COMMENT '请求方式',
  `operator_type` int DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
  `oper_name` varchar(50) DEFAULT '' COMMENT '操作人员',
  `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称',
  `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL',
  `oper_ip` varchar(128) DEFAULT '' COMMENT '主机地址',
  `oper_location` varchar(255) DEFAULT '' COMMENT '操作地点',
  `oper_param` varchar(4000) DEFAULT '' COMMENT '请求参数',
  `json_result` varchar(4000) DEFAULT '' COMMENT '返回参数',
  `status` int DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
  `error_msg` varchar(4000) DEFAULT '' COMMENT '错误消息',
  `oper_time` datetime DEFAULT NULL COMMENT '操作时间',
  `cost_time` bigint DEFAULT '0' COMMENT '消耗时间',
  PRIMARY KEY (`oper_id`),
  KEY `idx_sys_oper_log_bt` (`business_type`),
  KEY `idx_sys_oper_log_s` (`status`),
  KEY `idx_sys_oper_log_ot` (`oper_time`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='操作日志记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_oper_log`
--

LOCK TABLES `sys_oper_log` WRITE;
/*!40000 ALTER TABLE `sys_oper_log` DISABLE KEYS */;
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.AggrementSettingController.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.AggrementSettingController.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);
/*!40000 ALTER TABLE `sys_oper_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_oss`
--

DROP TABLE IF EXISTS `sys_oss`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_oss` (
  `oss_id` bigint NOT NULL AUTO_INCREMENT COMMENT '对象存储主键',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
  `file_name` varchar(255) NOT NULL DEFAULT '' COMMENT '文件名',
  `original_name` varchar(255) NOT NULL DEFAULT '' COMMENT '原名',
  `file_suffix` varchar(10) NOT NULL DEFAULT '' COMMENT '文件后缀名',
  `url` varchar(500) NOT NULL COMMENT 'URL地址',
  `ext1` text COMMENT '扩展字段',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '上传人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `service` varchar(20) NOT NULL DEFAULT 'minio' COMMENT '服务商',
  PRIMARY KEY (`oss_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='OSS对象存储表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_oss`
--

LOCK TABLES `sys_oss` WRITE;
/*!40000 ALTER TABLE `sys_oss` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `sys_oss` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_oss_config`
--

DROP TABLE IF EXISTS `sys_oss_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_oss_config` (
  `oss_config_id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
  `config_key` varchar(20) NOT NULL DEFAULT '' COMMENT '配置key',
  `access_key` varchar(255) DEFAULT '' COMMENT 'accessKey',
  `secret_key` varchar(255) DEFAULT '' COMMENT '秘钥',
  `bucket_name` varchar(255) DEFAULT '' COMMENT '桶名称',
  `prefix` varchar(255) DEFAULT '' COMMENT '前缀',
  `endpoint` varchar(255) DEFAULT '' COMMENT '访问站点',
  `domain` varchar(255) DEFAULT '' COMMENT '自定义域名',
  `is_https` char(1) DEFAULT 'N' COMMENT '是否https（Y=是,N=否）',
  `region` varchar(255) DEFAULT '' COMMENT '域',
  `access_policy` char(1) NOT NULL DEFAULT '1' COMMENT '桶权限类型(0=private 1=public 2=custom)',
  `status` char(1) DEFAULT '1' COMMENT '是否默认（0=是,1=否）',
  `ext1` varchar(255) DEFAULT '' COMMENT '扩展字段',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`oss_config_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='对象存储配置表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_oss_config`
--

LOCK TABLES `sys_oss_config` WRITE;
/*!40000 ALTER TABLE `sys_oss_config` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `sys_oss_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_post`
--

DROP TABLE IF EXISTS `sys_post`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_post` (
  `post_id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
  `dept_id` bigint NOT NULL COMMENT '部门id',
  `post_code` varchar(64) NOT NULL COMMENT '岗位编码',
  `post_category` varchar(100) DEFAULT NULL COMMENT '岗位类别编码',
  `post_name` varchar(50) NOT NULL COMMENT '岗位名称',
  `post_sort` int NOT NULL COMMENT '显示顺序',
  `status` char(1) NOT NULL COMMENT '状态（0正常 1停用）',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`post_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='岗位信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_post`
--

LOCK TABLES `sys_post` WRITE;
/*!40000 ALTER TABLE `sys_post` DISABLE KEYS */;
INSERT INTO `sys_post` VALUES (1,'000000',100,'ceo',NULL,'董事长',1,'0',103,1,'2025-11-26 13:39:24',NULL,NULL,'');
/*!40000 ALTER TABLE `sys_post` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role`
--

DROP TABLE IF EXISTS `sys_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_role` (
  `role_id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
  `role_name` varchar(30) NOT NULL COMMENT '角色名称',
  `role_key` varchar(100) NOT NULL COMMENT '角色权限字符串',
  `role_sort` int NOT NULL COMMENT '显示顺序',
  `data_scope` char(1) DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限 5：仅本人数据权限 6：部门及以下或本人数据权限）',
  `menu_check_strictly` tinyint(1) DEFAULT '1' COMMENT '菜单树选择项是否关联显示',
  `dept_check_strictly` tinyint(1) DEFAULT '1' COMMENT '部门树选择项是否关联显示',
  `status` char(1) NOT NULL COMMENT '角色状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role`
--

LOCK TABLES `sys_role` WRITE;
/*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
INSERT INTO `sys_role` VALUES (1,'000000','超级管理员','superadmin',1,'1',1,1,'0','0',103,1,'2025-11-26 13:39:24',NULL,NULL,'超级管理员');
/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role_dept`
--

DROP TABLE IF EXISTS `sys_role_dept`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_role_dept` (
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `dept_id` bigint NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`,`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色和部门关联表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role_dept`
--

LOCK TABLES `sys_role_dept` WRITE;
/*!40000 ALTER TABLE `sys_role_dept` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_role_dept` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role_menu`
--

DROP TABLE IF EXISTS `sys_role_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_role_menu` (
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `menu_id` bigint NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色和菜单关联表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role_menu`
--

LOCK TABLES `sys_role_menu` WRITE;
/*!40000 ALTER TABLE `sys_role_menu` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `sys_role_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_social`
--

DROP TABLE IF EXISTS `sys_social`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_social` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户id',
  `auth_id` varchar(255) NOT NULL COMMENT '平台+平台唯一id',
  `source` varchar(255) NOT NULL COMMENT '用户来源',
  `open_id` varchar(255) DEFAULT NULL COMMENT '平台编号唯一id',
  `user_name` varchar(30) NOT NULL COMMENT '登录账号',
  `nick_name` varchar(30) DEFAULT '' COMMENT '用户昵称',
  `email` varchar(255) DEFAULT '' COMMENT '用户邮箱',
  `avatar` varchar(500) DEFAULT '' COMMENT '头像地址',
  `access_token` varchar(2000) NOT NULL COMMENT '用户的授权令牌',
  `expire_in` int DEFAULT NULL COMMENT '用户的授权令牌的有效期，部分平台可能没有',
  `refresh_token` varchar(255) DEFAULT NULL COMMENT '刷新令牌，部分平台可能没有',
  `access_code` varchar(2000) DEFAULT NULL COMMENT '平台的授权信息，部分平台可能没有',
  `union_id` varchar(255) DEFAULT NULL COMMENT '用户的 unionid',
  `scope` varchar(255) DEFAULT NULL COMMENT '授予的权限，部分平台可能没有',
  `token_type` varchar(255) DEFAULT NULL COMMENT '个别平台的授权信息，部分平台可能没有',
  `id_token` varchar(2000) DEFAULT NULL COMMENT 'id token，部分平台可能没有',
  `mac_algorithm` varchar(255) DEFAULT NULL COMMENT '小米平台用户的附带属性，部分平台可能没有',
  `mac_key` varchar(255) DEFAULT NULL COMMENT '小米平台用户的附带属性，部分平台可能没有',
  `code` varchar(255) DEFAULT NULL COMMENT '用户的授权code，部分平台可能没有',
  `oauth_token` varchar(255) DEFAULT NULL COMMENT 'Twitter平台用户的附带属性，部分平台可能没有',
  `oauth_token_secret` varchar(255) DEFAULT NULL COMMENT 'Twitter平台用户的附带属性，部分平台可能没有',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='社会化关系表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_social`
--

LOCK TABLES `sys_social` WRITE;
/*!40000 ALTER TABLE `sys_social` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_social` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_tenant`
--

DROP TABLE IF EXISTS `sys_tenant`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_tenant` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `tenant_id` varchar(20) NOT NULL COMMENT '租户编号',
  `contact_user_name` varchar(20) DEFAULT NULL COMMENT '联系人',
  `contact_phone` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `company_name` varchar(30) DEFAULT NULL COMMENT '企业名称',
  `license_number` varchar(30) DEFAULT NULL COMMENT '统一社会信用代码',
  `address` varchar(200) DEFAULT NULL COMMENT '地址',
  `intro` varchar(200) DEFAULT NULL COMMENT '企业简介',
  `domain` varchar(200) DEFAULT NULL COMMENT '域名',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `package_id` bigint DEFAULT NULL COMMENT '租户套餐编号',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  `account_count` int DEFAULT '-1' COMMENT '用户数量（-1不限制）',
  `status` char(1) DEFAULT '0' COMMENT '租户状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='租户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_tenant`
--

LOCK TABLES `sys_tenant` WRITE;
/*!40000 ALTER TABLE `sys_tenant` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `sys_tenant` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_tenant_package`
--

DROP TABLE IF EXISTS `sys_tenant_package`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_tenant_package` (
  `package_id` bigint NOT NULL AUTO_INCREMENT COMMENT '租户套餐id',
  `package_name` varchar(20) DEFAULT NULL COMMENT '套餐名称',
  `menu_ids` varchar(3000) DEFAULT NULL COMMENT '关联菜单id',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `menu_check_strictly` tinyint(1) DEFAULT '1' COMMENT '菜单树选择项是否关联显示',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='租户套餐表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_tenant_package`
--

LOCK TABLES `sys_tenant_package` WRITE;
/*!40000 ALTER TABLE `sys_tenant_package` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_tenant_package` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user`
--

DROP TABLE IF EXISTS `sys_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_user` (
  `user_id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
  `dept_id` bigint DEFAULT NULL COMMENT '部门ID',
  `user_name` varchar(30) NOT NULL COMMENT '用户账号',
  `nick_name` varchar(30) NOT NULL COMMENT '用户昵称',
  `user_type` varchar(10) DEFAULT 'sys_user' COMMENT '用户类型（sys_user系统用户）',
  `email` varchar(50) DEFAULT '' COMMENT '用户邮箱',
  `phonenumber` varchar(11) DEFAULT '' COMMENT '手机号码',
  `sex` char(1) DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
  `avatar` bigint DEFAULT NULL COMMENT '头像地址',
  `password` varchar(100) DEFAULT '' COMMENT '密码',
  `status` char(1) DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  `login_ip` varchar(128) DEFAULT '' COMMENT '最后登录IP',
  `login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `wechat_open_id` varchar(128) DEFAULT NULL COMMENT '微信的 open ID',
  `wechat_union_id` varchar(128) DEFAULT NULL COMMENT '微信的 union ID',
  `applet_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许微信小程序登录(0 -> 允许; 1 -> 禁止)',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user`
--

LOCK TABLES `sys_user` WRITE;
/*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user_post`
--

DROP TABLE IF EXISTS `sys_user_post`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_user_post` (
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `post_id` bigint NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`,`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户与岗位关联表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_post`
--

LOCK TABLES `sys_user_post` WRITE;
/*!40000 ALTER TABLE `sys_user_post` DISABLE KEYS */;
INSERT INTO `sys_user_post` VALUES (1,1);
/*!40000 ALTER TABLE `sys_user_post` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user_role`
--

DROP TABLE IF EXISTS `sys_user_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_user_role` (
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `role_id` bigint NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户和角色关联表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_role`
--

LOCK TABLES `sys_user_role` WRITE;
/*!40000 ALTER TABLE `sys_user_role` DISABLE KEYS */;
INSERT INTO `sys_user_role` VALUES (1,1);
/*!40000 ALTER TABLE `sys_user_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `test_demo`
--

DROP TABLE IF EXISTS `test_demo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `test_demo` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
  `dept_id` bigint DEFAULT NULL COMMENT '部门id',
  `user_id` bigint DEFAULT NULL COMMENT '用户id',
  `order_num` int DEFAULT '0' COMMENT '排序号',
  `test_key` varchar(255) DEFAULT NULL COMMENT 'key键',
  `value` varchar(255) DEFAULT NULL COMMENT '值',
  `version` int DEFAULT '0' COMMENT '版本',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `del_flag` int DEFAULT '0' COMMENT '删除标志',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='测试单表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test_demo`
--

LOCK TABLES `test_demo` WRITE;
/*!40000 ALTER TABLE `test_demo` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `test_demo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `test_tree`
--

DROP TABLE IF EXISTS `test_tree`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `test_tree` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `tenant_id` varchar(20) DEFAULT '000000' COMMENT '租户编号',
  `parent_id` bigint DEFAULT '0' COMMENT '父id',
  `dept_id` bigint DEFAULT NULL COMMENT '部门id',
  `user_id` bigint DEFAULT NULL COMMENT '用户id',
  `tree_name` varchar(255) DEFAULT NULL COMMENT '值',
  `version` int DEFAULT '0' COMMENT '版本',
  `create_dept` bigint DEFAULT NULL COMMENT '创建部门',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` bigint DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` bigint DEFAULT NULL COMMENT '更新人',
  `del_flag` int DEFAULT '0' COMMENT '删除标志',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='测试树表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test_tree`
--

LOCK TABLES `test_tree` WRITE;
/*!40000 ALTER TABLE `test_tree` DISABLE KEYS */;
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);
/*!40000 ALTER TABLE `test_tree` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-12-02  9:34:46
