deployment/init.sql

CREATE DATABASE IF NOT EXISTS `llm-app`;
USE `llm-app`;

-- MySQL dump 10.13  Distrib 8.0.34, for Win64 (x86_64)
--
-- Host: 192.168.107.2    Database: llm-app
-- ------------------------------------------------------
-- Server version	5.7.44


--
-- Table structure for table `code_column_config`
--

CREATE TABLE IF NOT EXISTS `code_column_config` (
  `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `table_name` varchar(180) DEFAULT NULL,
  `column_name` varchar(255) DEFAULT NULL,
  `column_type` varchar(255) DEFAULT NULL,
  `dict_name` varchar(255) DEFAULT NULL,
  `extra` varchar(255) DEFAULT NULL,
  `form_show` bit(1) DEFAULT NULL,
  `form_type` varchar(255) DEFAULT NULL,
  `key_type` varchar(255) DEFAULT NULL,
  `list_show` bit(1) DEFAULT NULL,
  `not_null` bit(1) DEFAULT NULL,
  `query_type` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `date_annotation` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`column_id`) USING BTREE,
  KEY `idx_table_name` (`table_name`)
) ENGINE=InnoDB AUTO_INCREMENT=479 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='代码生成字段信息存储';


--
-- Table structure for table `code_gen_config`
--


CREATE TABLE IF NOT EXISTS `code_gen_config` (
  `config_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `table_name` varchar(255) DEFAULT NULL COMMENT '表名',
  `author` varchar(255) DEFAULT NULL COMMENT '作者',
  `cover` bit(1) DEFAULT NULL COMMENT '是否覆盖',
  `module_name` varchar(255) DEFAULT NULL COMMENT '模块名称',
  `pack` varchar(255) DEFAULT NULL COMMENT '至于哪个包下',
  `path` varchar(255) DEFAULT NULL COMMENT '前端代码生成的路径',
  `api_path` varchar(255) DEFAULT NULL COMMENT '前端Api文件路径',
  `prefix` varchar(255) DEFAULT NULL COMMENT '表前缀',
  `api_alias` varchar(255) DEFAULT NULL COMMENT '接口名称',
  PRIMARY KEY (`config_id`) USING BTREE,
  KEY `idx_table_name` (`table_name`(100))
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='代码生成器配置';


--
-- Table structure for table `kb_auth`
--

CREATE TABLE IF NOT EXISTS `kb_auth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kb_id` int(11) DEFAULT NULL COMMENT '知识库ID',
  `auth_key` varchar(20) DEFAULT NULL COMMENT '权限类型 user/role/dept',
  `auth_value` bigint(20) DEFAULT NULL COMMENT '权限值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1007 DEFAULT CHARSET=utf8mb4 COMMENT='知识库权限配置';


--
-- Table structure for table `kb_chunk`
--

CREATE TABLE IF NOT EXISTS `kb_chunk` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_id` varchar(128) DEFAULT NULL COMMENT '文件ID（可选)',
  `kb_id` int(11) DEFAULT NULL COMMENT '知识库ID',
  `tree_id` int(11) DEFAULT NULL,
  `chunk` varchar(6096) DEFAULT NULL COMMENT '文本块',
  `metadata` varchar(1024) DEFAULT NULL COMMENT '元数据json',
  `status` varchar(50) DEFAULT NULL COMMENT '有效状态',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `update_index_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=199451 DEFAULT CHARSET=utf8mb4;


--
-- Table structure for table `kb_chunk_file`
--

CREATE TABLE IF NOT EXISTS `kb_chunk_file` (
  `id` varchar(128) NOT NULL,
  `kb_id` bigint(20) DEFAULT NULL COMMENT '知识库ID',
  `name` varchar(256) DEFAULT NULL COMMENT '文档名称',
  `num_char` varchar(64) DEFAULT NULL COMMENT '字符数',
  `content` longtext COMMENT '文档内容',
  `md5` varchar(255) DEFAULT NULL COMMENT 'md5',
  `user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文档片段文件';


--
-- Table structure for table `kb_content_check`
--

CREATE TABLE IF NOT EXISTS `kb_content_check` (
  `kb_id` bigint(20) NOT NULL COMMENT '知识库ID',
  `check_id` bigint(20) NOT NULL COMMENT '质检ID',
  PRIMARY KEY (`kb_id`,`check_id`),
  KEY `content_checkid_index` (`check_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='知识库质检规则关联表';


--
-- Table structure for table `kb_doc_split`
--

CREATE TABLE IF NOT EXISTS `kb_doc_split` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `kb_id` bigint(20) DEFAULT NULL COMMENT '知识库ID',
  `chunk_size` int(5) DEFAULT '1000' COMMENT '片段大小',
  `chunk_overlap` int(5) DEFAULT NULL COMMENT '片段重叠值',
  `separators` varchar(255) DEFAULT '["\n\n", "\n", " ", ""]' COMMENT '分隔符',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=176 DEFAULT CHARSET=utf8mb4 COMMENT='文档拆分';


--
-- Table structure for table `kb_file`
--

CREATE TABLE IF NOT EXISTS `kb_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kb_id` bigint(20) DEFAULT NULL COMMENT '知识库ID',
  `file_type` varchar(45) DEFAULT NULL COMMENT '文件所属（知识库/用户）',
  `name` varchar(255) DEFAULT NULL COMMENT '文档名称',
  `num_char` varchar(64) DEFAULT NULL COMMENT '字符数',
  `status_index` varchar(32) DEFAULT NULL COMMENT '索引状态',
  `index_des` varchar(2048) DEFAULT NULL,
  `doc_split` varchar(4096) DEFAULT NULL,
  `embedded_cost` int(11) DEFAULT NULL COMMENT '嵌入毫秒',
  `update_index_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL COMMENT '上传日期',
  `md5` varchar(255) DEFAULT NULL COMMENT '文件MD5值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19990 DEFAULT CHARSET=utf8mb4 COMMENT='知识库文件';


--
-- Table structure for table `kb_knowledge`
--

CREATE TABLE IF NOT EXISTS `kb_knowledge` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL COMMENT '知识库名称',
  `des` varchar(255) DEFAULT NULL COMMENT '知识库描述',
  `guide` varchar(255) DEFAULT NULL COMMENT 'Chat页引导',
  `num_hit` int(3) DEFAULT NULL COMMENT '命中率%',
  `icon` varchar(50) DEFAULT NULL COMMENT '图标',
  `num_file` int(11) DEFAULT NULL COMMENT '文档数',
  `prompt_id` bigint(20) DEFAULT NULL COMMENT 'promp模板',
  `auth_keys` varchar(255) DEFAULT NULL COMMENT '权限策略',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `total_query` bigint(20) DEFAULT NULL COMMENT '总调用检索次数',
  `prompt` text COMMENT '提示词内容',
  `user_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=382 DEFAULT CHARSET=utf8mb4 COMMENT='知识库基本信息';


--
-- Table structure for table `kb_label`
--

CREATE TABLE IF NOT EXISTS `kb_label` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) DEFAULT NULL COMMENT 'chunk、doc',
  `target_id` int(11) DEFAULT NULL COMMENT '所属目标',
  `name` varchar(255) DEFAULT NULL COMMENT '标签名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6580 DEFAULT CHARSET=utf8mb4 COMMENT='知识标签';


--
-- Table structure for table `kb_qna_pair`
--

CREATE TABLE IF NOT EXISTS `kb_qna_pair` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `kb_id` bigint(20) DEFAULT NULL COMMENT '知识库Id',
  `question` varchar(2048) DEFAULT NULL COMMENT '问题',
  `answer` mediumtext COMMENT '回答',
  `status_index` varchar(45) DEFAULT NULL,
  `index_des` varchar(3000) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `user_id` bigint(20) DEFAULT NULL COMMENT '操作用户',
  `update_index_time` datetime DEFAULT NULL COMMENT '创建更新索引时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=249459 DEFAULT CHARSET=utf8mb4 COMMENT='QA对管理';


--
-- Table structure for table `kb_tree`
--

CREATE TABLE IF NOT EXISTS `kb_tree` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) DEFAULT NULL COMMENT 'kb 知识库',
  `target_id` int(11) DEFAULT NULL COMMENT '所属目标',
  `parent_id` int(11) DEFAULT NULL COMMENT '根节点 0',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  PRIMARY KEY (`id`),
  KEY `uk` (`type`,`target_id`,`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=utf8mb4 COMMENT='目录树';


--
-- Table structure for table `llm_chat`
--

CREATE TABLE IF NOT EXISTS `llm_chat` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `chat_id` varchar(50) DEFAULT NULL COMMENT '会话ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `question` varchar(4000) DEFAULT NULL COMMENT '第一个问题',
  `source_type` varchar(50) DEFAULT NULL COMMENT '来源类型',
  `source_value` varchar(50) DEFAULT NULL COMMENT '来源值',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=655 DEFAULT CHARSET=utf8mb4 COMMENT='用户会话';


--
-- Table structure for table `llm_chat_history`
--


CREATE TABLE IF NOT EXISTS `llm_chat_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `chat_id` varchar(64) DEFAULT NULL COMMENT '会话id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `source_type` varchar(50) DEFAULT NULL COMMENT '来源类型',
  `source_value` varchar(255) DEFAULT NULL COMMENT '来源值',
  `question` varchar(4000) DEFAULT NULL COMMENT '问',
  `answer` varchar(4000) DEFAULT NULL COMMENT '答',
  `op_liked` varchar(10) DEFAULT NULL COMMENT '存:踩/赞',
  `op_copy` int(2) DEFAULT NULL COMMENT '复制',
  `chunk` text COMMENT '召回块',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `feedback` varchar(255) DEFAULT NULL COMMENT '反馈',
  `open_client_id` int(11) DEFAULT NULL COMMENT '外部系统接入id',
  `req_model_msg` text COMMENT '请求模型发送消息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6968 DEFAULT CHARSET=utf8mb4 COMMENT='问答历史';


--
-- Table structure for table `llm_content_check`
--

CREATE TABLE IF NOT EXISTS `llm_content_check` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '质检名称',
  `match` varchar(255) DEFAULT NULL COMMENT '正则匹配规则',
  `match_resp` varchar(255) DEFAULT NULL COMMENT '返回内容',
  `enable` varchar(10) DEFAULT NULL COMMENT '启用状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `match_type` varchar(24) DEFAULT NULL COMMENT '匹配类型，match:匹配返回, substitute:匹配替换',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COMMENT='内容质检';


--
-- Table structure for table `llm_eval`
--

CREATE TABLE IF NOT EXISTS `llm_eval` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `desc` varchar(1024) DEFAULT NULL COMMENT '描述',
  `data_num` int(5) DEFAULT NULL COMMENT '评估数据个数',
  `evaluate_num` int(5) DEFAULT NULL COMMENT '评估次数',
  `user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `evaluate_time` datetime DEFAULT NULL COMMENT '首次评估时间',
  `scene_desc` varchar(1024) DEFAULT NULL COMMENT '场景描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COMMENT='评估集';


--
-- Table structure for table `llm_eval_data`
--

CREATE TABLE IF NOT EXISTS `llm_eval_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eval_id` int(11) DEFAULT NULL COMMENT '评估集id',
  `question` varchar(4000) DEFAULT NULL COMMENT '问题',
  `answer` varchar(4000) DEFAULT NULL COMMENT '标准答案',
  `label` varchar(1024) DEFAULT NULL COMMENT '标签',
  `user_id` bigint(20) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint(20) DEFAULT NULL COMMENT '修改者',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `source` varchar(64) DEFAULT NULL COMMENT '来源',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2502 DEFAULT CHARSET=utf8mb4 COMMENT='评估集数据池';


--
-- Table structure for table `llm_eval_history`
--

CREATE TABLE IF NOT EXISTS `llm_eval_history` (
  `id` varchar(64) NOT NULL COMMENT '评估批次号',
  `eval_id` int(11) DEFAULT NULL COMMENT '评估集ID',
  `kb_id` int(11) DEFAULT NULL COMMENT '知识库ID',
  `data_num` int(5) DEFAULT NULL COMMENT '评估数据个数',
  `file_num` int(5) DEFAULT NULL COMMENT '文档个数',
  `correct_num` int(5) DEFAULT NULL COMMENT '正确个数',
  `error_num` int(5) DEFAULT NULL,
  `prompt` varchar(1024) DEFAULT NULL COMMENT '提示词',
  `mark_prompt` varchar(1024) DEFAULT NULL COMMENT '打分提示词',
  `eval_cost` int(11) DEFAULT NULL COMMENT '评估耗时',
  `user_id` bigint(20) DEFAULT NULL COMMENT '评估人',
  `create_time` datetime DEFAULT NULL COMMENT '评估时间',
  `remark` varchar(254) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='评估历史';


--
-- Table structure for table `llm_eval_history_detail`
--

CREATE TABLE `llm_eval_history_detail` (
  `history_id` varchar(64) NOT NULL COMMENT '评估批次号',
  `eval_data_id` int(11) NOT NULL COMMENT '评估数据id',
  `eval_id` int(11) DEFAULT NULL COMMENT '评估集ID',
  `kb_id` int(11) DEFAULT NULL COMMENT '知识库ID',
  `model_answer` varchar(4000) DEFAULT NULL COMMENT '大模型答案',
  `retrieval` text COMMENT '召回内容',
  `score` varchar(4000) DEFAULT NULL COMMENT '得分',
  `eval_cost` int(11) DEFAULT NULL COMMENT '评估耗时',
  `create_time` datetime DEFAULT NULL COMMENT '评估开始时间',
  PRIMARY KEY (`history_id`,`eval_data_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='评估历史数据';


--
-- Table structure for table `llm_history`
--

CREATE TABLE IF NOT EXISTS `llm_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `user_name` varchar(50) DEFAULT NULL COMMENT '用户',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `source_id` int(11) DEFAULT NULL COMMENT '来源ID',
  `source` varchar(50) DEFAULT NULL COMMENT '来源(如：表名)',
  `content` varchar(6000) DEFAULT NULL COMMENT '内容',
  `op_type` varchar(50) DEFAULT NULL COMMENT '操作类型(如：删除、修改等)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=110630 DEFAULT CHARSET=utf8mb4 COMMENT='历史记录';


--
-- Table structure for table `llm_model`
--

CREATE TABLE IF NOT EXISTS `llm_model` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `size` double DEFAULT NULL COMMENT '参数规模(B)',
  `api` varchar(255) DEFAULT NULL COMMENT 'api地址',
  `api_key` varchar(128) DEFAULT NULL COMMENT '模型apikey',
  `default_model` varchar(2) DEFAULT NULL COMMENT '是否默认访问模型，01-是，02-否',
  `model` varchar(32) DEFAULT NULL COMMENT '模型编码',
  `status` varchar(32) DEFAULT NULL COMMENT '模型是否可用，Y-是，N-否',
  `error_message` varchar(512) DEFAULT NULL COMMENT '异常信息',
  `connection_time` varchar(20) DEFAULT NULL COMMENT '连通测试时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COMMENT='模型';


--
-- Table structure for table `llm_model_embed`
--

CREATE TABLE IF NOT EXISTS `llm_model_embed` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL COMMENT '名称',
  `size` int(255) DEFAULT NULL COMMENT '参数大小',
  `des` varchar(255) DEFAULT NULL COMMENT '模型大小(GB）',
  `embed_dimension` int(5) DEFAULT NULL COMMENT '嵌入维数',
  `sequence_length` int(11) DEFAULT NULL COMMENT '序列长度',
  `api` varchar(255) DEFAULT NULL COMMENT 'Embedding API',
  `api_key` varchar(255) DEFAULT NULL COMMENT '访问密匙',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='embedding model';


--
-- Table structure for table `llm_open_client`
--

CREATE TABLE IF NOT EXISTS `llm_open_client` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL COMMENT '接入系统名称',
  `des` varchar(255) DEFAULT NULL COMMENT '系统描述',
  `access_key` varchar(50) DEFAULT NULL COMMENT '接入凭证',
  `count_use` int(10) DEFAULT NULL COMMENT '使用统计',
  `linkman` varchar(50) DEFAULT NULL COMMENT '接入系统联系人',
  `tel` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `enabled` varchar(10) DEFAULT NULL COMMENT '启用状态',
  `create_time` datetime DEFAULT NULL COMMENT '接入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COMMENT='外部系统接入';


--
-- Table structure for table `llm_prompt`
--

CREATE TABLE IF NOT EXISTS `llm_prompt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL COMMENT '名称',
  `des` varchar(255) DEFAULT NULL COMMENT '描述',
  `scene_id` int(11) DEFAULT NULL COMMENT '场景',
  `model_id` int(255) DEFAULT NULL COMMENT '模型',
  `prompt` varchar(1024) DEFAULT NULL COMMENT 'prompt模板',
  `temperature` double(3,1) DEFAULT '0.7' COMMENT '温度',
  `max_tokens` int(10) DEFAULT NULL COMMENT '模型最大token',
  `retrieval_topk` int(2) DEFAULT '3' COMMENT '召回topK',
  `retrieval_similarity` double(3,0) DEFAULT '0' COMMENT '召回相似度阀值',
  `user_id` varchar(32) DEFAULT NULL COMMENT '用户ID',
  `private_flag` varchar(2) DEFAULT NULL COMMENT '是否私有，Y-是，N-否',
  `code` varchar(128) DEFAULT NULL COMMENT '模板编码',
  `process_step` varchar(512) DEFAULT NULL COMMENT '模板处理',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COMMENT='prompt模板';


--
-- Table structure for table `llm_prompt_question`
--

CREATE TABLE IF NOT EXISTS `llm_prompt_question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL COMMENT '标题',
  `des` varchar(1000) DEFAULT NULL COMMENT '内容',
  `use_type` varchar(100) DEFAULT NULL COMMENT '用途 -字典sence_type',
  `use_value` varchar(50) DEFAULT NULL COMMENT '用途值-知识库id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8mb4 COMMENT='问答引导';


--
-- Table structure for table `llm_scene`
--

CREATE TABLE IF NOT EXISTS `llm_scene` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '场景id',
  `name` varchar(100) DEFAULT NULL COMMENT '名称',
  `type` varchar(100) DEFAULT NULL COMMENT '类别：1.文档生成 2.知识库使用',
  `des` varchar(255) DEFAULT NULL COMMENT '场景描述',
  `scene_code` varchar(128) DEFAULT NULL COMMENT '场景编码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1066 DEFAULT CHARSET=utf8mb4 COMMENT='场景信息';


--
-- Table structure for table `llm_user_conf`
--


CREATE TABLE IF NOT EXISTS `llm_user_conf` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `target_type` varchar(255) DEFAULT NULL COMMENT '类型 默认 kb',
  `target_id` varchar(255) DEFAULT NULL COMMENT '目标ID 如 kb_id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQUE_KEY` (`user_id`,`target_type`,`target_id`) COMMENT '唯一索引'
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb4 COMMENT='用户配置';


--
-- Table structure for table `mnt_app`
--

CREATE TABLE IF NOT EXISTS `mnt_app` (
  `app_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) DEFAULT NULL COMMENT '应用名称',
  `upload_path` varchar(255) DEFAULT NULL COMMENT '上传目录',
  `deploy_path` varchar(255) DEFAULT NULL COMMENT '部署路径',
  `backup_path` varchar(255) DEFAULT NULL COMMENT '备份路径',
  `port` int(255) DEFAULT NULL COMMENT '应用端口',
  `start_script` varchar(4000) DEFAULT NULL COMMENT '启动脚本',
  `deploy_script` varchar(4000) DEFAULT NULL COMMENT '部署脚本',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`app_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='应用管理';


--
-- Table structure for table `mnt_database`
--

CREATE TABLE IF NOT EXISTS `mnt_database` (
  `db_id` varchar(50) NOT NULL COMMENT 'ID',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `jdbc_url` varchar(255) NOT NULL COMMENT 'jdbc连接',
  `user_name` varchar(255) NOT NULL COMMENT '账号',
  `pwd` varchar(255) NOT NULL COMMENT '密码',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`db_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='数据库管理';


--
-- Table structure for table `mnt_deploy`
--


CREATE TABLE IF NOT EXISTS `mnt_deploy` (
  `deploy_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `app_id` bigint(20) DEFAULT NULL COMMENT '应用编号',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`deploy_id`) USING BTREE,
  KEY `FK6sy157pseoxx4fmcqr1vnvvhy` (`app_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='部署管理';


--
-- Table structure for table `mnt_deploy_history`
--

CREATE TABLE IF NOT EXISTS `mnt_deploy_history` (
  `history_id` varchar(50) NOT NULL COMMENT 'ID',
  `app_name` varchar(255) NOT NULL COMMENT '应用名称',
  `deploy_date` datetime NOT NULL COMMENT '部署日期',
  `deploy_user` varchar(50) NOT NULL COMMENT '部署用户',
  `ip` varchar(20) NOT NULL COMMENT '服务器IP',
  `deploy_id` bigint(20) DEFAULT NULL COMMENT '部署编号',
  PRIMARY KEY (`history_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='部署历史管理';


--
-- Table structure for table `mnt_deploy_server`
--

CREATE TABLE IF NOT EXISTS `mnt_deploy_server` (
  `deploy_id` bigint(20) NOT NULL COMMENT '部署ID',
  `server_id` bigint(20) NOT NULL COMMENT '服务ID',
  PRIMARY KEY (`deploy_id`,`server_id`) USING BTREE,
  KEY `FKeaaha7jew9a02b3bk9ghols53` (`server_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='应用与服务器关联';


--
-- Table structure for table `mnt_server`
--

CREATE TABLE IF NOT EXISTS `mnt_server` (
  `server_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `account` varchar(50) DEFAULT NULL COMMENT '账号',
  `ip` varchar(20) DEFAULT NULL COMMENT 'IP地址',
  `name` varchar(100) DEFAULT NULL COMMENT '名称',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `port` int(11) DEFAULT NULL COMMENT '端口',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`server_id`) USING BTREE,
  KEY `idx_ip` (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='服务器管理';


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

CREATE TABLE IF NOT EXISTS `sys_dept` (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级部门',
  `sub_count` int(5) DEFAULT '0' COMMENT '子部门数目',
  `name` varchar(255) NOT NULL COMMENT '名称',
  `dept_sort` int(5) DEFAULT '999' COMMENT '排序',
  `enabled` bit(1) NOT NULL COMMENT '状态',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dept_id`) USING BTREE,
  KEY `inx_pid` (`pid`),
  KEY `inx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='部门';


--
-- Table structure for table `sys_dict`
--

CREATE TABLE IF NOT EXISTS `sys_dict` (
  `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) NOT NULL COMMENT '字典名称',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`dict_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='数据字典';


--
-- Table structure for table `sys_dict_detail`
--

CREATE TABLE IF NOT EXISTS `sys_dict_detail` (
  `detail_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `dict_id` bigint(11) DEFAULT NULL COMMENT '字典id',
  `label` varchar(255) NOT NULL COMMENT '字典标签',
  `value` longtext NOT NULL COMMENT '字典值',
  `dict_sort` int(5) DEFAULT NULL COMMENT '排序',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`detail_id`) USING BTREE,
  KEY `FK5tpkputc6d9nboxojdbgnpmyb` (`dict_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=214 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='数据字典详情';


--
-- Table structure for table `sys_job`
--

CREATE TABLE IF NOT EXISTS `sys_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(180) NOT NULL COMMENT '岗位名称',
  `enabled` bit(1) NOT NULL COMMENT '岗位状态',
  `job_sort` int(5) DEFAULT NULL COMMENT '排序',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`job_id`) USING BTREE,
  UNIQUE KEY `uniq_name` (`name`),
  KEY `inx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='岗位';


--
-- Table structure for table `sys_log`
--

CREATE TABLE IF NOT EXISTS `sys_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `description` varchar(255) DEFAULT NULL,
  `log_type` varchar(10) DEFAULT NULL,
  `method` varchar(255) DEFAULT NULL,
  `params` text,
  `request_ip` varchar(255) DEFAULT NULL,
  `time` bigint(20) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `browser` varchar(255) DEFAULT NULL,
  `exception_detail` text,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`log_id`) USING BTREE,
  KEY `log_create_time_index` (`create_time`),
  KEY `inx_log_type` (`log_type`)
) ENGINE=InnoDB AUTO_INCREMENT=89877 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='系统日志';


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

CREATE TABLE IF NOT EXISTS `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级菜单ID',
  `sub_count` int(5) DEFAULT '0' COMMENT '子菜单数目',
  `type` int(11) DEFAULT NULL COMMENT '菜单类型',
  `title` varchar(100) DEFAULT NULL COMMENT '菜单标题',
  `name` varchar(100) DEFAULT NULL COMMENT '组件名称',
  `component` varchar(255) DEFAULT NULL COMMENT '组件',
  `menu_sort` int(5) DEFAULT NULL COMMENT '排序',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `path` varchar(255) DEFAULT NULL COMMENT '链接地址',
  `i_frame` bit(1) DEFAULT NULL COMMENT '是否外链',
  `cache` bit(1) DEFAULT b'0' COMMENT '缓存',
  `hidden` bit(1) DEFAULT b'0' COMMENT '隐藏',
  `permission` varchar(255) DEFAULT NULL COMMENT '权限',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`menu_id`) USING BTREE,
  UNIQUE KEY `uniq_title` (`title`),
  UNIQUE KEY `uniq_name` (`name`),
  KEY `inx_pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=281 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='系统菜单';


--
-- Table structure for table `sys_quartz_job`
--

CREATE TABLE IF NOT EXISTS `sys_quartz_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `bean_name` varchar(255) DEFAULT NULL COMMENT 'Spring Bean名称',
  `cron_expression` varchar(255) DEFAULT NULL COMMENT 'cron 表达式',
  `is_pause` bit(1) DEFAULT NULL COMMENT '状态：1暂停、0启用',
  `job_name` varchar(255) DEFAULT NULL COMMENT '任务名称',
  `method_name` varchar(255) DEFAULT NULL COMMENT '方法名称',
  `params` varchar(255) DEFAULT NULL COMMENT '参数',
  `description` varchar(255) DEFAULT NULL COMMENT '备注',
  `person_in_charge` varchar(100) DEFAULT NULL COMMENT '负责人',
  `email` varchar(100) DEFAULT NULL COMMENT '报警邮箱',
  `sub_task` varchar(100) DEFAULT NULL COMMENT '子任务ID',
  `pause_after_failure` bit(1) DEFAULT NULL COMMENT '任务失败后是否暂停',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`job_id`) USING BTREE,
  KEY `inx_is_pause` (`is_pause`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='定时任务';


--
-- Table structure for table `sys_quartz_log`
--

CREATE TABLE IF NOT EXISTS `sys_quartz_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `bean_name` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `cron_expression` varchar(255) DEFAULT NULL,
  `exception_detail` text,
  `is_success` bit(1) DEFAULT NULL,
  `job_name` varchar(255) DEFAULT NULL,
  `method_name` varchar(255) DEFAULT NULL,
  `params` varchar(255) DEFAULT NULL,
  `time` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`log_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='定时任务日志';


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

CREATE TABLE IF NOT EXISTS `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(100) NOT NULL COMMENT '名称',
  `level` int(50) DEFAULT NULL COMMENT '角色级别',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `data_scope` varchar(255) DEFAULT NULL COMMENT '数据权限',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`role_id`) USING BTREE,
  UNIQUE KEY `uniq_name` (`name`),
  KEY `role_name_index` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='角色表';


--
-- Table structure for table `sys_roles_depts`
--

CREATE TABLE IF NOT EXISTS `sys_roles_depts` (
  `role_id` bigint(20) NOT NULL,
  `dept_id` bigint(20) NOT NULL,
  PRIMARY KEY (`role_id`,`dept_id`) USING BTREE,
  KEY `FK7qg6itn5ajdoa9h9o78v9ksur` (`dept_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='角色部门关联';


--
-- Table structure for table `sys_roles_menus`
--

CREATE TABLE IF NOT EXISTS `sys_roles_menus` (
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`menu_id`,`role_id`) USING BTREE,
  KEY `FKcngg2qadojhi3a651a5adkvbq` (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='角色菜单关联';


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

CREATE TABLE IF NOT EXISTS `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门名称',
  `username` varchar(180) DEFAULT NULL COMMENT '用户名',
  `nick_name` varchar(255) DEFAULT NULL COMMENT '昵称',
  `gender` varchar(2) DEFAULT NULL COMMENT '性别',
  `phone` varchar(255) DEFAULT NULL COMMENT '手机号码',
  `email` varchar(180) DEFAULT NULL COMMENT '邮箱',
  `avatar_name` varchar(255) DEFAULT NULL COMMENT '头像地址',
  `avatar_path` varchar(255) DEFAULT NULL COMMENT '头像真实路径',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `is_admin` bit(1) DEFAULT b'0' COMMENT '是否为admin账号',
  `enabled` bit(1) DEFAULT NULL COMMENT '状态：1启用、0禁用',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `pwd_reset_time` datetime DEFAULT NULL COMMENT '修改密码的时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `UK_kpubos9gc2cvtkb0thktkbkes` (`email`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE,
  UNIQUE KEY `uniq_username` (`username`),
  UNIQUE KEY `uniq_email` (`email`),
  KEY `FK5rwmryny6jthaaxkogownknqp` (`dept_id`) USING BTREE,
  KEY `inx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='系统用户';


--
-- Table structure for table `sys_users_jobs`
--

CREATE TABLE IF NOT EXISTS `sys_users_jobs` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `job_id` bigint(20) NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`user_id`,`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


--
-- Table structure for table `sys_users_roles`
--

CREATE TABLE IF NOT EXISTS `sys_users_roles` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`) USING BTREE,
  KEY `FKq4eq273l04bpu4efj0jd0jb98` (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='用户角色关联';


--
-- Table structure for table `tool_alipay_config`
--

CREATE TABLE IF NOT EXISTS `tool_alipay_config` (
  `config_id` bigint(20) NOT NULL COMMENT 'ID',
  `app_id` varchar(255) DEFAULT NULL COMMENT '应用ID',
  `charset` varchar(255) DEFAULT NULL COMMENT '编码',
  `format` varchar(255) DEFAULT NULL COMMENT '类型 固定格式json',
  `gateway_url` varchar(255) DEFAULT NULL COMMENT '网关地址',
  `notify_url` varchar(255) DEFAULT NULL COMMENT '异步回调',
  `private_key` text COMMENT '私钥',
  `public_key` text COMMENT '公钥',
  `return_url` varchar(255) DEFAULT NULL COMMENT '回调地址',
  `sign_type` varchar(255) DEFAULT NULL COMMENT '签名方式',
  `sys_service_provider_id` varchar(255) DEFAULT NULL COMMENT '商户号',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='支付宝配置类';


--
-- Table structure for table `tool_email_config`
--

CREATE TABLE IF NOT EXISTS `tool_email_config` (
  `config_id` bigint(20) NOT NULL COMMENT 'ID',
  `from_user` varchar(255) DEFAULT NULL COMMENT '收件人',
  `host` varchar(255) DEFAULT NULL COMMENT '邮件服务器SMTP地址',
  `pass` varchar(255) DEFAULT NULL COMMENT '密码',
  `port` varchar(255) DEFAULT NULL COMMENT '端口',
  `user` varchar(255) DEFAULT NULL COMMENT '发件者用户名',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='邮箱配置';


--
-- Table structure for table `tool_local_storage`
--


CREATE TABLE IF NOT EXISTS `tool_local_storage` (
  `storage_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `real_name` varchar(255) DEFAULT NULL COMMENT '文件真实的名称',
  `name` varchar(255) DEFAULT NULL COMMENT '文件名',
  `suffix` varchar(255) DEFAULT NULL COMMENT '后缀',
  `path` varchar(255) DEFAULT NULL COMMENT '路径',
  `type` varchar(255) DEFAULT NULL COMMENT '类型',
  `size` varchar(100) DEFAULT NULL COMMENT '大小',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`storage_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='本地存储';


--
-- Table structure for table `tool_qiniu_config`
--

CREATE TABLE IF NOT EXISTS `tool_qiniu_config` (
  `config_id` bigint(20) NOT NULL COMMENT 'ID',
  `access_key` text COMMENT 'accessKey',
  `bucket` varchar(255) DEFAULT NULL COMMENT 'Bucket 识别符',
  `host` varchar(255) NOT NULL COMMENT '外链域名',
  `secret_key` text COMMENT 'secretKey',
  `type` varchar(255) DEFAULT NULL COMMENT '空间类型',
  `zone` varchar(255) DEFAULT NULL COMMENT '机房',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='七牛云配置';


--
-- Table structure for table `tool_qiniu_content`
--
CREATE TABLE IF NOT EXISTS `tool_qiniu_content` (
  `content_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `bucket` varchar(255) DEFAULT NULL COMMENT 'Bucket 识别符',
  `name` varchar(180) DEFAULT NULL COMMENT '文件名称',
  `size` varchar(255) DEFAULT NULL COMMENT '文件大小',
  `type` varchar(255) DEFAULT NULL COMMENT '文件类型：私有或公开',
  `url` varchar(255) DEFAULT NULL COMMENT '文件url',
  `suffix` varchar(255) DEFAULT NULL COMMENT '文件后缀',
  `update_time` datetime DEFAULT NULL COMMENT '上传或同步的时间',
  PRIMARY KEY (`content_id`) USING BTREE,
  UNIQUE KEY `uniq_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='七牛云文件存储';


--
-- Table structure for table `wf_process`
--

CREATE TABLE IF NOT EXISTS `wf_process` (
  `code` varchar(32) NOT NULL COMMENT '流程代码',
  `name` varchar(64) NOT NULL COMMENT '流程名称',
  `flow_conf` text COMMENT '配置',
  `desc` varchar(255) DEFAULT NULL COMMENT '流程描述',
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程管理表';


--
-- Table structure for table `wf_process_param`
--


CREATE TABLE IF NOT EXISTS `wf_process_param` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `process_code` varchar(32) DEFAULT NULL COMMENT '流程CODE',
  `type` varchar(32) DEFAULT NULL COMMENT '类型（入参，出参）',
  `name` varchar(255) DEFAULT NULL COMMENT '参数',
  `label` varchar(255) DEFAULT NULL COMMENT '参数别名',
  `editor_type` varchar(32) DEFAULT NULL COMMENT '参数类型',
  `default_value` varchar(64) DEFAULT NULL COMMENT '默认值',
  `must` char(1) DEFAULT NULL COMMENT '是否必须',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COMMENT='流程参数';


-- Dump completed on 2024-09-02 14:56:41



SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!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 */;
/*!40101 SET NAMES utf8mb4 */;


INSERT INTO `kb_knowledge` (`name`, `des`, `guide`, `num_hit`, `icon`, `num_file`, `prompt_id`, `auth_keys`, `create_time`, `update_time`, `total_query`, `prompt`, `user_id`) VALUES
('客服问答知识库模板', '客服问答知识库模板描述', NULL, 0, 'ico-28', 0, NULL, NULL, '2024-08-19 15:03:40', NULL, 0, '{\"isTemplate\":\"Y\",\"prologue\":\"我是你的智能问答助手，我能帮你答疑解惑。\",\"code\":\"PT-20240620-00000048\",\"des\":\"ZX-QA-20240511 TEST\",\"id\":87,\"modelId\":23,\"modelName\":\"qwen2-72b\",\"name\":\"ZX-QA-20240527-by-YWW\",\"privateFlag\":\"Y\",\"prompt\":\"首先阅读如下的文档片段：\\n\\\"\\\"\\\"\\n{context}\\n\\\"\\\"\\\"\\n然后寻找如下问题的答案：\\n\\\"\\\"\\\"\\n{question}\\n\\\"\\\"\\\"\\n严格使用文档片段中的语句回答问题，找不到请直接回答`无法找到答案`。\\n\\n不要复述问题，直接开始回答。\\n\",\"retrievalTopk\":6,\"sceneId\":1005,\"sceneName\":\"知识库\",\"temperature\":\"0.1\",\"userId\":\"1\"}', NULL);
UPDATE `kb_knowledge` SET id = 999999 where name = '客服问答知识库模板' limit 1;

INSERT INTO `llm_model` (`id`, `name`, `size`, `api`, `api_key`, `default_model`, `model`, `status`, `error_message`, `connection_time`) VALUES
(23, 'qwen2-72b', 33, 'http://llm-chat:8000/v1/chat/completions', '123', 'Y', 'Qwen/Qwen2.5-72B-Instruct-AWQ', 'Y', '', '2024-08-20 11:29:17');

INSERT INTO `llm-app`.llm_prompt (id, name, des, scene_id, model_id, prompt, temperature, max_tokens, retrieval_topk, retrieval_similarity, user_id, private_flag, code, process_step) VALUES(1, '默认提示词模板', '默认提示词', 1, 23, '首先阅读如下的文档片段：
"""
{context}
"""
然后寻找如下问题的答案：
"""
{question}
"""
严格使用文档片段中的语句回答问题，找不到请直接回答````无法找到答案````。

不要复述问题，直接开始回答。
', 0.1, NULL, 6, 0.0, '1', 'N', 'da5bad82-46e4-4170-8cbe-255c2d7958c0', NULL);
INSERT INTO `llm-app`.llm_prompt (id, name, des, scene_id, model_id, prompt, temperature, max_tokens, retrieval_topk, retrieval_similarity, user_id, private_flag, code, process_step) VALUES(7, '问答打分模板', '问答打分模板', 1006, 23, '你是一位在银行领域业务经验丰富的专家。请仔细分析以下两个答案,评判它们在内容上是否基本等价。

问题:
{query}

同事A的答案:
{ans1}

同事B的答案:
{ans2}

根据以下标准计算相似度得分:
- 如果两个答案完全不同或某个答案与问题无关，得分为0
- 如果两个答案虽然都和问题相关,但核心内容差异较大,专业性有一定差距，得分为0.01
- 如果两个答案的内容、专业性、表述方式等各方面都极为相似，可认为基本等价，得分为1
- 如果同事A或者同事B的答案为无法找到答案,请直接输出-1。

现在，请仅输出一个表示相似度的数字作为得分，不附加任何其他文字或解释。


', 0.1, NULL, 6, 0.0, '1', 'Y', 'PT-20240620-00000007', NULL);
INSERT INTO `llm-app`.llm_prompt (id, name, des, scene_id, model_id, prompt, temperature, max_tokens, retrieval_topk, retrieval_similarity, user_id, private_flag, code, process_step) VALUES(8, '问答对生成模板', '问答对生成模板', 1006, 23, '你是一名报告撰写者，请根据以下要求从上下文中提炼问题和答案：

----------------
要求：
1. 请从上下文中，提取出3个问题和答案。
2. 提取的问题必须有对应的答案。
3. 提取的答案必须是上下文出现的内容，不得随意修改，保证内容严谨真实。
4. 按照JSON格式返回最后提取的问题答案列表，示例: [{"question":"问题","answer":"答案"}]。

----------------
上下文：
{context}
', 0.7, NULL, 3, 0.0, '1', 'Y', 'PT-20240620-00000008', NULL);
INSERT INTO `llm-app`.llm_prompt (id, name, des, scene_id, model_id, prompt, temperature, max_tokens, retrieval_topk, retrieval_similarity, user_id, private_flag, code, process_step) VALUES(9, '文本标签生成模板', '文本标签生成模板', 1006, 23, '你是一名报告撰写者，请根据以下要求从上下文中提炼要点：

----------------
要求：
1. 请根据上下文，提取出3个最能代表文本主题的关键词。
2. 确保这些关键词应能够概括文本的主要内容和重点。
3. 按照JSON格式返回最后提取的关键词列表，示例: [{"keyword":"关键词"}]。

----------------
上下文：
{context}', 0.7, NULL, 3, 0.0, '1', 'Y', 'PT-20240620-00000009', NULL);
INSERT INTO `llm-app`.llm_prompt (id, name, des, scene_id, model_id, prompt, temperature, max_tokens, retrieval_topk, retrieval_similarity, user_id, private_flag, code, process_step) VALUES(10, '单文档问答模板', '根据文档片段方法大模型生成答案', 1006, 23, '# Role:文本分析助手

## 上下文:
{context}

## 背景:
你是一个专业的文本分析助手。你的任务是从上下文中回答用户问题，给出的答案必须是上下文中的内容。

## 目标:
1. 用中文回答用户问题，并保证答案要严谨专业。
2. 请仔细理解上下文中的参考片段，判断是否为标准的问答对形式。
3. 如果片段中有 Q: *** A:*** 的，则优先使用 A: 后面的值。
4. 否则，仅当上下文中的参考片段有和用户问题相关的内容时才进行回答，不可根据自己的知识来回答。
5. 如果没有找到相关信息,请回答"没有找到相关内容"。

## 用户问题:
{question}', 0.1, NULL, 6, 0.0, '1', 'Y', 'PT-20240620-00000010', NULL);
INSERT INTO `llm-app`.llm_prompt (id, name, des, scene_id, model_id, prompt, temperature, max_tokens, retrieval_topk, retrieval_similarity, user_id, private_flag, code, process_step) VALUES(130, '多轮会话意图识别模板', '多轮会话意图识别模板', 1006, 23, '你是一名专业的语言分析师，擅长捕捉用户的真正意图。

历史问题：
"""
{chat_history}
"""

目标：
"""
1、判断用户问题语义是否完整，如果不完整则根据【历史问题】补充完整的意图。
2、输出结果为JSON格式，示例：{"result":"处理后的用户问题"}
"""

步骤：
"""
1、首先分析用户问题，判断是否语义完整。
2、如果语义完整，直接原样返回用户问题，不得添加任何字，保证原内容不变。
3、如果语义不完整，根据【历史问题】依次查找最合适的词语，补充到用户问题中。
4、将用户问题，赋值到JSON串中的result字段。
"""

要求：
"""
1、使用中文回答用户问题。
2、保证输出的问题简洁明了。
3、仅仅需要返回一个用户问题。
"""

用户问题：{question}', 0.1, NULL, 3, 0.0, '1', 'N', 'PT-20240620-00000011', NULL);

INSERT INTO `llm_prompt_question` (`id`, `name`, `des`, `use_type`, `use_value`, `create_time`) VALUES
(137, '信用卡投诉处理指引', '信用卡投诉处理指引', 'knowledge', '999999', '2024-08-19 15:19:20'),
(138, '小微企业贷款操作流程', '小微企业贷款操作流程', 'knowledge', '999999', '2024-08-19 15:19:20'),
(139, '贷款产品介绍', '贷款产品介绍', 'knowledge', '999999', '2024-08-19 15:19:20');

INSERT INTO `llm_scene` (`id`, `name`, `type`, `des`, `scene_code`) VALUES
(1, '知识库', 'knowledge', '知识库场景描述', 'SE-20240624-00001005');

INSERT INTO `sys_dept` (`dept_id`, `pid`, `sub_count`, `name`, `dept_sort`, `enabled`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES
(2, NULL, 0, '研发部', 999, b'1', 'admin', 'admin', '2019-03-25 09:15:32', '2020-08-02 14:48:47');

INSERT INTO `sys_dict` (`dict_id`, `name`, `description`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES
(1, 'user_status', '用户状态', NULL, NULL, '2019-10-27 20:31:36', NULL),
(4, 'dept_status', '部门状态', NULL, NULL, '2019-10-27 20:31:36', NULL),
(5, 'job_status', '岗位状态', NULL, NULL, '2019-10-27 20:31:36', NULL),
(6, 'yes_no', '是否', 'admin', 'admin', '2024-01-16 10:59:51', '2024-01-16 10:59:51'),
(7, 'sence_type', '场景类型', 'admin', 'admin', '2024-01-16 13:39:35', '2024-01-16 13:39:35'),
(8, 'env', '初始化环境信息配置', 'test', 'test', '2024-01-17 15:37:27', '2024-01-17 15:37:27'),
(10, 'process_status', '处理状态', 'admin', 'admin', '2024-01-20 15:42:47', '2024-01-20 15:42:47'),
(11, 'chat_queue', '单位时间内并发聊天用户数控制', 'admin', 'admin', '2024-01-22 17:32:08', '2024-01-22 18:30:04'),
(13, 'feature', '功能启用', 'admin', 'admin', '2024-01-29 09:59:50', '2024-01-29 09:59:50'),
(16, 'ui_theme', '皮肤变量', 'admin', 'test', '2024-02-04 17:11:41', '2024-02-04 18:16:27'),
(19, 'kb_create_defult', '创建提示词模版默认值', 'msyh', 'msyh', '2024-04-07 16:49:43', '2024-04-08 10:53:13'),
(20, 'char_type', '字符类型', 'test', 'test', '2024-05-07 15:46:22', '2024-05-13 16:26:29'),
(22, 'register', '服务注册', 'test', 'test', '2024-05-14 11:44:19', '2024-05-14 11:44:28'),
(26, 'kb_splitter', '文档分割器', 'test', 'test', '2024-05-20 10:28:40', '2024-05-20 10:28:40'),
(28, 'prompt_constant_code', '默认模板编码', 'test', 'test', '2024-06-20 09:56:17', '2024-06-20 09:56:17'),
(30, '行业类型', '行业类型', 'admin', 'admin', '2024-07-15 17:55:06', '2024-07-15 17:55:06'),
(32, 'file', '文件', 'test', 'test', '2024-07-29 11:07:18', '2024-07-29 11:07:49');

INSERT INTO `sys_dict_detail` (`detail_id`, `dict_id`, `label`, `value`, `dict_sort`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES
(1, 1, '激活', 'true', 1, NULL, NULL, '2019-10-27 20:31:36', NULL),
(2, 1, '禁用', 'false', 2, NULL, NULL, NULL, NULL),
(3, 4, '启用', 'true', 1, NULL, NULL, NULL, NULL),
(4, 4, '停用', 'false', 2, NULL, NULL, '2019-10-27 20:31:36', NULL),
(5, 5, '启用', 'true', 1, NULL, NULL, NULL, NULL),
(6, 5, '停用', 'false', 2, NULL, NULL, '2019-10-27 20:31:36', NULL),
(7, 6, '是', 'Y', 999, 'admin', 'admin', '2024-01-16 11:00:33', '2024-01-16 11:00:33'),
(8, 6, '否', 'N', 999, 'admin', 'admin', '2024-01-16 11:00:44', '2024-01-16 11:00:44'),
(9, 7, '通用问答', 'aigc', 999, 'admin', 'admin', '2024-01-16 13:40:05', '2024-05-24 10:26:23'),
(10, 7, '知识库问答使用', 'knowledge', 999, 'admin', 'test', '2024-01-16 13:40:20', '2024-01-31 18:00:41'),
(15, 10, '处理中', 'processing', 2, 'admin', 'test', '2024-01-20 15:43:41', '2024-07-18 16:43:22'),
(16, 10, '成功', 'success', 3, 'admin', 'test', '2024-01-20 15:44:05', '2024-07-18 16:43:26'),
(17, 10, '失败', 'fail', 4, 'admin', 'test', '2024-01-20 15:45:21', '2024-07-18 16:43:29'),
(18, 11, 'limited_concurrent', '1000', 999, 'admin', 'admin', '2024-01-22 18:28:54', '2024-05-31 14:33:25'),
(19, 11, 'limited_period', '40', 999, 'admin', 'wangyin', '2024-01-22 18:29:22', '2024-07-30 14:21:17'),
(22, 8, 'minio_url', 'http://minio:9000', 1, 'admin', 'test', '2024-01-26 17:26:04', '2024-06-11 14:20:23'),
(23, 13, 'chat_check', 'Y', 999, 'admin', 'admin', '2024-01-29 11:34:45', '2024-07-30 17:21:46'),
(24, 13, 'chat_rate_limit', 'Y', 999, 'admin', 'admin', '2024-01-29 11:38:22', '2024-01-29 11:39:20'),
(28, 8, 'minio_access_key', 'root', 1, 'admin', 'test', '2024-01-30 15:53:58', '2024-01-31 15:01:17'),
(29, 8, 'minio_secret_key', 'llmllmllm', 1, 'admin', 'test', '2024-01-30 15:54:22', '2024-01-31 15:01:25'),
(30, 8, 'minio_bucket_name', 'create-default', 1, 'admin', 'test', '2024-01-30 15:54:45', '2024-01-31 15:01:30'),
(31, 11, 'limited_multiwheel', '3', 999, 'admin', 'admin', '2024-02-04 10:51:49', '2024-07-31 14:21:30'),
(54, 16, '--side-bar-width', '240px', 999, 'admin', 'wangyin', '2024-02-05 17:27:59', '2024-08-01 14:04:13'),
(55, 16, '--sidebar-bg', '#AB3636', 999, 'admin', 'wangyin', '2024-02-05 17:28:06', '2024-08-01 14:04:49'),
(56, 16, '--menu-bg', '#FFFFFF', 999, 'admin', 'wangyin', '2024-02-05 17:28:13', '2024-08-01 14:04:49'),
(57, 16, '--menu-margin', '3px 8px', 999, 'admin', 'wangyin', '2024-02-05 17:28:20', '2024-08-01 14:04:14'),
(58, 16, '--menu-border-radius', '8px', 999, 'admin', 'wangyin', '2024-02-05 17:28:27', '2024-08-01 14:04:14'),
(59, 16, '--menu-active-bg', '#1E75FF', 999, 'admin', 'wangyin', '2024-02-05 17:28:34', '2024-08-01 14:04:14'),
(60, 16, '--menu-hover-bg', '#1E75FF', 999, 'admin', 'wangyin', '2024-02-05 17:28:42', '2024-08-01 14:04:14'),
(61, 16, '--active-submenu-parent-color', '#404D6A', 999, 'admin', 'wangyin', '2024-02-05 17:28:50', '2024-08-01 14:04:14'),
(62, 16, '--submenu-bg', '#fff', 999, 'admin', 'wangyin', '2024-02-05 17:28:57', '2024-08-01 14:04:14'),
(63, 16, '--nest-submenu-hover-bg', '#1E75FF', 999, 'admin', 'wangyin', '2024-02-05 17:29:09', '2024-08-01 14:04:15'),
(64, 16, '--menu-text-color', '#404D6A', 999, 'admin', 'wangyin', '2024-02-05 17:29:17', '2024-08-01 14:04:15'),
(65, 16, '--menu-active-text-color', '#fff', 999, 'admin', 'wangyin', '2024-02-05 17:29:25', '2024-08-01 14:04:15'),
(66, 16, '--side-bar-logo-title-color', '', 999, 'admin', 'wangyin', '2024-02-05 17:29:32', '2024-08-01 14:04:15'),
(67, 16, '--side-bar-logo-title', '', 999, 'admin', 'wangyin', '2024-02-05 17:29:39', '2024-08-01 14:04:15'),
(68, 16, '--side-bar-logo-title-img', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAASYAAAAmCAYAAABpszZuAAAAAXNSR0IArs4c6QAAAERlWElmTU0AKgAAAAgAAYdpAAQAAAABAAAAGgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAABJqADAAQAAAABAAAAJgAAAABroJa6AAAgUklEQVR4Ae1dCZhdRZWuuu91dzqhu9MJgd6SNFlYBNJL2GQNqwN8IotBPsEBdQBncBBwAUQlLoiCgCCOLJ+Iio4xKiCD4gJEhWCATndw4mSnO+klCaT3/d17a/5z36v7qure12/pTifR1JdOVZ0651TdWk6dOrU8zsbhistrrxSMna6ysBhv7OlofESF7cnw9PL6SwVzD1bziFgFv+lsW92qwmS4uKzufM7FbBknv6ej6TE1LsPFVfULuOOeJePki4j1Um/rms0qbF8Kl5TXL1bLw7nldre/2ajCJjqMftAihJij8rU4vwP1+nUVdiDMWGlV/SLXYXlaXeRN3dqz7ZUuDWZEDp1/8iGjg8NHqGCXscGejjUNKmxfCM+YU3O0E4tMGbMsGIQ97Q1rUuFEUyVkAheMn8aEe52K63L2NOKTJphc5n4eg0IbjMKN/QvKECqYGHc/5Qr2PrXMCIcKJuY4JwH3URWXO85HEE8rmIrLap9lnJ2j0uYaFpyd29fetCoTelc4b6p4nLmDiE9TYft7mCZEfAO18V5xnPEHMflq9ZxJQUi4DA4MNAGXq/gRe7ge8TEF09DgwHlCsB+rdOCyHvGjNFiWkenVtdXuCPtFlmRsRsH0U5ubVw6bdDSZx0adtxhzLDNNi0OjwRi5sHdH0280eCIyLsEEoeeisvZ5V1xe9xFoVdcmCnqMWeCi8po/m7BE/JAQ+BeA7wnjwilTlu56e/XOEBx0PVGAupkampYlMMoiESIpqaw/y3Xd5So55+z53vama1TYP0F4MSajq/bWd1pc/Ap5Zy2YhgaGSJhqQgmRvnNPOeytFSuyZjchnx8ZsQod4WgTe1rGnA+FCSWiE477OXhjC6VEBoKL2xGceMFE5UjksU97nInZEBKnUSFDC5xIMz8iDBd8SJ32VOrYiF1g0uzJuHCxBBBCW7ZCay2eiDyLK+quAO/v58ILQqLQpIOmuQyazR0mPG2ci1t729c+PDbe/jAdhn2Be0EAyvlrK1ascALwfRjABQudjEtmL57v2vbVGRddsFNLKmrP7Wlv+oNJMy6Nibnh49zMZCLiy5Ytsx577LkZJq8+4QS+gVtOSUXFYn8ADwhHm6VMHgfiqAHhRidKw4vXp8gDP92WkkFFY5kUaE+TDFoiZKEJ3bfjRx+9NH9758bzAiOGi7+qfTXVVwy4bhG0fi0ZdRXJhJaI2tre3M2xxNEY5B7ZFUbqxmwyieSHpaWCYc31SFXVe49pbX1tSMVJ2wlU5GCYPnSivjXIXYU8+NhzVbZrt6iwVGEYF5f3MdtPhiH2C37kQOBADeyFGtjetfkyCNNSM2vh8j701XdMeCZxSOeFfSIz2srK42aB57uZ8E2PIwIaU0l57bWw62gbRcQHkwg2XrgvUQUTx0Bk+CsNSI95vc7QXUC9Rc13nIIJCvt+4FzO/waV6SkqKjrH2fi/XC02ZhIvTYUlwvPQ+CercOCSEXorwWweGVDT1HCE86+iER51uVUlXPchNQ2t9W6ECc9ORXBH8Pko070GThtw/pNgthX9u5Z2IBKoAbTvarTNE4GEBAAjYy4a//NqOmj6QfNpFWaG0YZ3o88ENHUTL10c/egGEweDtgsbG6sMRchE26Pxshnzt+zo2nrUqOt8FH2Q7EOeQ728mccjtNHDYq79PAmQeAqwONcEU2nF4lNtYX9Hpksf9bu8t2PtFTJOPgzed6JOl6kw1M3N2C1v6t3R+CMJH59ggko9SQqTLG9Ofl97469BSH+suLzmBXQ0TTD1djR5DWAyBy4ZWDXBhGb5Hio7lSDzWXS1N71KkZnl9UeN+tB4AA022N2xlnYvPUdb/NhNk9GEL/pUHCPxnzwaoqlzvinVsQ+qLK+OmaMJJgywYbT9Y2NVZtxOJsYlmKZX1tU4jntKIB/Of2YJa8RlZtsHMPcYYN26FdQ916Ov01I+6QTburujgXb9aMxMV8c5+q8vmGZWLD5yVDhPq1oQ0QCnPz/PuoXCqpsxZfo3O4e7sRklMBknneDu4yWVdW09bY0vEnR8gglbTxioSe77QQjbBdBi+AuZFDWPR9+MMedmFRezyN7ZPlELMUlhdK4+i7OrJyk7Lxs3Yv1tMvObjLxcR4RvAljiyb0ok/RPF3y2NpY5ayeExYsX521ss3XBzLlnYyqqqD05JuznIAL0dNBBG/zMu9sbPR5qRrSbh93l64TjkMEbwzHhBMvHjvPzJRX1V/e0r1kehVX8c2Cck4CCSDpe8lX8I7De1GYmJS1tsO6I6fesXLkyaSBKUFiW7XDBtwUYCFGKchSpcKihuxHXllmY+b4GvOvD5qaiFLtHmAlUtl4YsDuAz7hlvb+3bc1fAwgAHHLYiYfKHTubY9losEE5IlB/50hahztlJg6+NarilOQX7eoc6ZUkk+JDoxjp7mjyNbtJyTSTTCZx0yWT4oyF4y1zXHtpAAdnkHpb175uHogN4E0eoErNCoKlg+Jv74geCmOCmgRtiO+cseDE4tjA8IvQsqZoiYhg/D0F7VU7/6fi9LSteQky4kuwSX1NhZPWhZXDf0+vrN1A6tudWONNyHkbLxMh3oP1PBmzcnIbN/Z9G4R6TQCwu3VtG7y5JlMInAdgO7hJh4ubQpZb04Dn79Tp+NnHIrR1n8INDQ+vQCWfliIZE5OoxJq8JWU6EqDqLlCN/RBKe+1A4VjlVNNoEOLboGjFHeTHUC4HESX9/u5jXPGSijrqzwGHGxI/JuDN11/UiN1m/wBsn+s8j9ZfIglIaz3IipYNMudcxxXPSDj5EACrDuKRc/td99PYsfuKmhZh1pKplvWGhLW3NwzKcJiPM0Wz0el8h7J72o7jjpb5wEQAlwl2Thm082MhQgmFGkKZ/5Iwg5ikfhzHXEjJQB6iwgfGA5y7VlEUZfE7koGwz0VLK2pPgbn9DFkwKxr9tWMHZJhMPuBPYA2UVCyuF8I5XWUZzRN/6Ny2dp2EQZCuQNjvyBg43YgHdqIIH8uAz2IgLKCwdFbeQbelu5pBuJj4lCGUoBbsIhx8/T/Jy/SFcAMzO7iUjkVDPDBxmwPHZJ0yDqF0IwZ46OFFTDye9o9jMPgc5gsNDOhy1dYDMd9GQqW4vH4Y2yRaXuDhxNNq3jZrBHQHpxNGktnSpUsjL/xlE+yuyWrlVsQTTK7FA9p8xLF2hkoNzoZRYYX4oJTakszTa0WKeDRBrSsKqaTWQ5JuHwyRUIL652tjwna251pMGjRohpczoYeNvxCVtM9rLJl8S644QtjvQR08oNI7MU62E18woS81o059wYRBOb103uKSrq0NPSodhWGd/CTS5yTh3K6bF71hZXCxnkTxQ0HbJgZpMcZVysOmSPepkwGBjU92ZDIeFgqjC8PTYcVVNScIR9yjQzOJ6bYeLJta01FZEd7q2Ho58b2z09HJ9BdXbSOhFJFx8qOCe4LJEm4ZSU7VjVrRXQXm2UDOX4U98kmMz8dV3HRhLBnvQRscjtJfoeLmZFtSGezVMPTBUMmdWaG29HU0XZoJKtl60i29MuGzP+NEeLQZdaB9AjpstQaAYEL8JBUmRtxqxNeqsOrqJVN2D3dpAwcd9O0w26JKt7+Ei6veO4M5Qz/HlJ+fTZmJTtiDullFpLjzqTB2mQXhpWtTEDRa/SrogWCMjQZwxdSoJ5ggNGBjUh23e1tXd+Jc1EwJxYS0HHfnruke6b0gWA6JFe7Dlgo7ZuOHiytqm5HXrcACO9qVE+yP6BT+gadw8nAoZtAapPgzJGHF1XexOpwiPXTq1EPMGlaJvEJLgIgIK3l0S0LhC34RdhOWNzQ0xBSoFsRsXQkjtq99aYlGxHGdEgP0TxflEEym6Q+NUa1WhGBWi6+iywQhCEcTTD1OPy3htLZEfBP+/jGcM3gBxsbcbD/GEsOzA52fp9eYillBW09yNRjP1ttly6wEFnNnq1oRGmagc/Nqb6cFZjKMb00b24UxLnDinBqwT1jsU7hC9ANCxksfmWVoYBE/gG7HRtxLrsuepOQobvd+gALZOgxsMuy9DV8nFSKv8JBDL9v51u8H9ITMYr16H9aIoJ7qndkztOogIgDeUmxxzsQy4tKwZUSCaRlmtIx2D40v1MoUFqHLvXJXDkLtW1QeFQ8N8WCER+6XMOzKHQu1/39knHyogpsjVuRsCaNduaHi/Ij97u6jJMzzLbtPi++hyI3Xnt9+3yPPQNAL1ehfrWYHVb7ZPHLrMj5XxaGwsGMLTRjimQsmjlyybZSQDPc1kMNoGac7vA6RdilH1zmwCbQbY9HXYlDLAV4652TMda0qbULh8WUcYcAojnGSxIUM8c4wWVb+AM+L1PS2vP62TLWEWO9w/nUZz8SHxvSqxKM7c9Aaj41G7fycl3KlFfWnoSKCnQ5PbAy9s/MSZPaUzHDCfGFZWgUyDAW11vSMzrIHnVfxoaf3tr7WqSft2Zh8cYDu9933yNOnm7kJbr3Y1d7gW1OwZTxLGKo4OoSt4nQlmaynYFHlCTPzhTOLudEiOuQmk0ddfbkl4eP1yUiLU7vb0EfnS16QDnPQByBnvRkPLcGbZZrvxzUmP0oBTC+HB5qNi80aUrYRzp+O8oixO5tkEir8OevEErUuiRUM2cJZhQmsMpgy8RC8/TVHkQFeBlgTpBVMhAg6wvMFE9pijscgg/+8S+4KHtp0PgSdp1ggrG0a0CqJ0nrsoYf7Wpto6eW7zh2NdEPhDh+QQ0CO1ZwFk8PGenaCfwRlmnjBZGhMkFLxEZGyAsTR3Bk5DMlBwUS7AXGbSEpqmQCpnodB6A9ICU/n437fycAx1uiMTS2csnq8ao7ljn5i1DwHkq5A404XzWCRrAecO5k1px6G0/hhvDzOm0eNkYVoNdI1B30nqDGJSOYaU8jBXsxQA6og1zJEJFT44w7XWDTEo7isxvwkk/XExbk4whTYEW5tzyQDLsR21DWZVhJOVBx8xClF7254NW1XAx00Js1B+Ul5hMhLw2SUlf1M455BJCfBtGDB+QW7BjqWGn3Qzw5S9exZ1ceXvdP8xg4fOBEBGDq0PUSBFW6ODkuldbiOcFwm5J7xO8MLxCo/x7UvV+MURoNu2rll1S4Tvj/EMfhbzDYfcTwbkmcoLbTyW0yNDbNxdci3HW7CsCzIQjCZ1HsyTlZM86uzzY/DdKTveoVz4Fima3mJaaxgk6Ith5MRlLONOiljoz0DpEn7Z5lSEUOozdZyTYUYAi8pq/k+blJc5CcJ9r99O5rOPHju4vIR78E4PwXrG+uTdKqbIPTMDoTfd5KpjBXkRxa929LgHezMSTC9M7Djo2A6XWWqh0VkeGT0U4DdrsPHF8MhspzKG5qrYDPTHQKTdHhIK+uDmYmG+TdNkBJDkfLCsMwuUz/XvhTOP7BMprLiBSjFwbjdrC+lPVvYXKCsIjSydRSV1ZANQtUSqylNcwGNicfOO7G6ZcW2tGNIspnYb5dcw3wYecwBH4aWCoaJ6C5U5PmYrNNahvFR71H5gHab+RyImq6GMdGuDxreSNClF0xY9sEelVuVYlnej36ijg/vG445rOidhvVdM5C/ojy482SZIQzpgrxCx50zT5i3a0VL/KXgrAc63k4pxPrySzKDVD4q6kZoTQ9OpNaE50uiOCfhZwlJjWsqybhMwC4jLuryc1HZEQkzfTRiNdrixyY8PB7MIxwvCR2NOXejwQqTEC8EkwH7oQHLNQoFZuIczET04qbmUI8jOgDHAUwcw4aEQjUDxRdM4FlK1xfkLg8tL0Z6+rHTk3TIe2s2j6VZeOdJk5jESogodoqmJrnqoSHmTDEN8ygrH4uGOPQL44CQznbMGD23g6sZd2ECPH9MRCR6Vzz6hw1blvDsieloKR3jbQMqQUNFTBN0WmIiAuFAm1ht4OBpKmE44FuEdgxouYQLC2Mr6l4lm0VvT61cuWK0qKwWk1TyJQ+g+d+H8acb57noUPtA1oKpzx3CUxzJzNQSqWF88NSR0dgXAbtBhY8njEeltGMNULJttEiY+wnApCYuD0vc0zA09Dn4/qWY8fwTvYk8/4QzGy1m/vSDAYm3uZUkMaREAkF0iC1YJv0ukGAA0GXIlpbWgd8Uo4NRr9MEUwTGbdO0DgFRbTBvRvxEFSaGY9WIv0WwWN/wQvI1J3hWhm8s4KdBj9EcvvOKPte+QgOmiaCNZuI9o5x2j8dmTaZP/hlcx7kvjkdx/BvD2cPD/gaGggZhk5krmFq4Hu+Ja8joH0dpgJAI+igV7ISQJB9UWl5/ms2cP/sAJYBx1mZ8GW8b2ESn5ZsxsbVCGJVLdGhXSVuWUMJAQClaJR75WQkmshuNjIzepjKIh3kM39ePQpSqaVgIXDujrO67CWu9mpRTGIOnQBs8POSWbYIzPXKOaxRnsKhF1yIm1fW0N/4RGU7LNNPEr5j4+Dhf9SjNgXE/ziUvTzykXv/obW/8GVLob0IcOnGh0cFoKGmCifNIM25BaPmhY1arACwLWsxBaLvQThOCCWlBwcSzOCoQz8yvKzXvfSWM+2tPt3eod9OMYy4hBRV2wL6EwWplrDGR3RK7Zd0QtkkTCx/fDxWEFDMAsgROnRtCl49GSAA1o/9AE0te9Edf8TUmGFur1LHsaV4K94wF05IlS6ING7qXowya8CFe2MR/EOdVdiGjexTeCIq8GBe/hPp+Qia7AzptMGYOHmgatmEG0YjUn4eJWgX3OW7sKQ0hERHceS+EqGaIw0zSzZl1Thg+waIzijfE71+nwhgHXCQfkZNc7FjkVwivk/GJ9vGS4hRToGCy0QTTjddd2BY8y+QJHb84uJzabBpl0CHnSgTctwsKJpGlYHIn5kceZJkm2s/0jpqaL7SLOn1FhNQILc+ycDhHBOyTJAWE1PxMd+YkjerTmG/cahexmKn4J7FE1GrDS3JJAEJof08AQQvStCl1KQc0bSmHPqLtPmYsmNZs6PomhNLpWgm8CO/IK5r2lfy+YQdPhN4CUJmGg7tII70DTwC2VIPnEIEE1mwIWP8MeIpoGl64APk+242lxMJxgJKA4RCWXsxzinFOJx/p7D0YP8fTONYOG2wLa6D5HKFTpo+hQwWQcM7pWcyIuroSwAoCojzvyM72N7RGD2KhlJZbrJu6IaYE71Vx42eZamhb2jdiIjwX5YUcj7cE4s0qjRcWbrUCC9gquJWlYOLevTiF5T9AUASXU/jFkeuhNX8o/nWuNpA9GDYRVK0aDebb9hI1Ytn9/cch/HIiHvCo7WZWnlDlcPtwSJSFGAd0xuxwqGsLG9Z3z4Pi/oTFrNAJnZiVRoradsf0fUPYgeOCCWewYH5R8hSHkrDbvHkkr8cenKkkIEv9vFZGggkH6/4DH0BCJ+Ag6T8rtSEYu25Dd34ygCTEB3GL++6+jrW3B9KyAECqHqR+ZoQ5A9DU0nLALP3CWEgqT4mHBsKl0LHpRgYHLgX+05LG9MG3EJ1FE6YmTsZxnBkKCM8MiPEyYPoKAh8IpaSaneALDXWHmQW+qRkwXzChRxXMqj6OJqMOwk17limwIwehmJ+dYIofHtRbDR/ZB/GoaXhUHumQjid+lGVOPAGsvLe7JFrQ91YIqTdRggTZQ7zH2NrtOtSl5tDel0uYkSTx6PbCdTIShoM5juxHL0sc04c99D7Uy80mPJ4vcRy7+9DDb5gwtVPn6DeeLQl501JOddZbGwfKbcspUIEUtiz9hPuYgomkKc4b3AU/XKBw9grOAv1EZoLzCz+EEMP5JnGhhPm+YLfhol75wvLItWPdYfPxQwMcGkyy+l2H96ept1AuB4DBGoB2WKlUbRzBeNuZgBYEk664wxBlu9VI8gRTAect5olEdG1Kjzvz1Ddnozddc/G2ZcuaJMaYfrxP1h5mIkHr+iB+X+/3JlzG6UE2aJ3666MQSrjIPUvihPnesyhpXyAIo1RhpE0m+62aQuHN7WIRkrGUnnjnCq5tRITkMLbkCSEwQQkBlNSAErtvJGwcQ8ePcbsKTzoUGGAoa/pB0pSCadbRSw6CNH0EEvlKsyAUx/ZkL97j+YSZlp/HrxuJCSxhklvGEgdq3dWb2p2KsrK6K3fsaHxHwjP3xSEqrrCivbi5oYIOhHOsAQydKnPoYHkWojEFL+qCdi6yfY2y9t4HKqu9AR0kXxYFWnU/hRO352dIeMLfSktEA5Yy6p00DxnEPJ9vTEm01xPSGL+FGHNXbJzF35O8vaIldt8WyXJ6kxwiDi4XG/snzHJYJY75FJqCOk9EWyU9+aGCaXp5zSXDnV0PQYp7KplKQGGI2IGIxS5Qd4kkDr3zi7doLsJzLSsh1FAA3WHGO3eQi/W4SXxrd1vj96VtQscKj2HgaIKpiIntXo8PR9/rUAjvTjRS9j+Zox08i38GTQTgNZrtR9HRr3Q03kNhr2wMaExY3rWbtPkF1uPOKH9ZhUciYosax47of6nxZHg0YPiGUNuUTE8fchwLy0jjk3C9KButK30uk4shLHGi+UkTVgLYe2ZW1VQmXoDNii3G5m6M9W3piDAutSUbaDy5MXXm9LbBXTs1ctwBrUT6VNCozl10+LSOlUpv0wQTXQbFT7Xc4wj2fpVKC6MT4HW7i7ra1ryqwZUIvWUM4XYlbksvh2TMU5K8IFS/GRBQj2OZeA2WfjejI79h4pjxxAG05NoUP4Hkzc54fzud69uxFnURdCWVNZdj9/sbqKTDgqlxAYz/7z3Iityby04LlrmnhPFNB8PpaaPdQMGty/s61vwuHW0u6X9YtZl+68vXcCQPzIR/l2HpJ64MeMs2CcvYd9zDA7hZHhVwmFsf4CH4lmy0rgD93ga47NRgEaxvwgDtr3i8k9LGY2poH2xExJ/olfTAOxudR1u+4Ygo9cOfSxzd5/gJK6xwaIKw6FqLtYlFrI3cKtwoXxOlc0w6jRGz8r/FXfuXEsqt+DKGXhiBAnIebo7BApBwEbYFP2d2C/JLOs47zLe4PMFUXLX4RPxqwa2453QxsEMHsccFMzZ2sC6jx8STXMND9NNDEDoXwyD5izDNyaMS4hSU73UMxJcsi38j7KeCJXc+EKuUYfJRyGY1nk2Yvpc5zv349YqTx6JD2XBeRizDO8zXFVXUfOHT113yw/16AKT4WCyxw9R9dxq3/t6TgiYnMHcXah0STHAkIyuNibkiKOzpntg+7VLbmKZX11Y7w/oFcWgqm3o7GrGRlHS0s4zNmCuSEG8x1Awb2R0qDBtQqAtoYIpzXboFES6YkM8XkUZ/Obu+ttep/kPbIGxM42K0thKDMNWWcVSQKLYbVwrbPiNdqVBZ3ZCoV/W2Nf0mHa5Mp0OOeNv5HJwgXoHKqpDwEP8s1xVnYXu90SrgZ3U3N3WbOJg6jlJhMLC3qPF04ZI5p5Yyu/8yPET1YXzvmanxeQxlNbQ8lN1lT9z/6DO3w4D/U8Hzf5pojFA208vqznC5qAtNzAAIbTKAhe+9BLsfWh0EkFIBBO9Uf0zQRMO5E60jUzqWjm9LLRHtsh6QQpMu67gb/H025P1VfJe/uYJv3wwN9+xUvFEzAe0Ck1RAs0tFnw6OH178V2gqvh0M5fHD6WhTp6e2MYlRdk6ATrCUq5EArgHANfdVptkVYjGYh0GXS7RkzvHzRCyGmyDZOXRvHGHQ+vgh6AMPEBdogNv7Ohrvp9v6mQilVTg492HYhLISBpRRX3vTKrwdtAjPj/wARUm9RKRCCVaHU6PFCAYEEy7waoMSnTGjshRX1S6EQnyvG+s7H18dWK5QGclBLe7CyeZ/jzK+Fr+V9ROUJbBkQCelGf9OGPTuREU2YPDejWsHvgob5wQLCBcXA/cmGZ8QX7jXa02ZDVPY9ID+o5Qkgp9kdBTMJfErJETjbc+H2AtT8ssmAfY07bu4+RRjkllCuwhMcFiK/DmJNb4Qjlfcjg8+cnxcMqeGHY+0Gc3hcMKfNEAWkd7Wpk3QmmCtSSoCmNSqS2Yvnt+zvWFLJqwgnL8E4fxxiYs3qZImFAmEb8Uc/NrP+Ps52v8wDH5vvGAcNoD1/cm1n5KhDAKpE7+fduP7Tl14etgdL4mXzod2sbt3x9qLoHVdhak4oLalo6d0FF4TTLC5NGdCZznWsfjoD4DBGEKJ/zZqTVlETzLsbm9Yv7AiehJOlX8NZR1OlQcED7afxcWp0vcXOM16qN2jzfJC8PuDA2FNdpi4kxV3R9mFgbxgXpjGoq8E4PsBAH0IlhF2llnUPFbwRxOWTRzjNkhvuwEBmJInx2814oci5B/wDk2Ju4cSQgUTBMgg/r7NIlMX4k7Wd9Rbv+MpB515KuLRI6BpLPOWhtkxexcV/jv5h7MQdCRhfI6zv9Dvb6FcF3S2rfYFJp2zorV3QdSaj7J+FwJqdHwZ7bvU7mjs0rDS4ShIsHOHIU4iDAPlQyHZrZZLzpC0fQRENqagK608vhaTJs7mJR369wa1LyZTsgnxQNu5zN0jy7lsSpUNbtRA3omKeVhY+d8jLcdIm5BoohN9Geek7hvp6vkYc92bPFUuDXcIjwlZGkHQ0Lb7cmiCT6T6JV1ZlMRPHH8ST2Ms62fOVRgYH0PasTL9H8HHKd3LQkbNjrCjIHvze2nLe9QOsS/x1Kea92Z5M8l7KhMbhqzoXBW3wHWHelVADuHZMxYsb+/a6mu8xCKSh4cdcuC1t0hgUsH2v+DP4aGgp+aULnhh3boVk6IdvLNuJR1Begi7XA8/8PizZ+Ix/qsQD529x6ocMpZBmNK6NOmEfs0A6Z1IfB47QM9ip+m32c6wwKezSN+mv9Kq+kX4gYHLcOn1smSGegiX7J7BRZAWHboXYzB+h+VOv/nmDDn024Ja/WGFoc+4nH8cAsycxMJYjhsmeCR0IzDmWqfjJdwNZgZ4P/0FExYWR+EH8QSG9p3QVrpDcNdBm9ffDzGRrFA6E0uJhxu/E/1wm4KYMoizTr24XaSVHxNKoD6IQWIMZ8Q3LMPQMWUgxnEizfiFFW1X0EDLOorDl/FDvXQ+KGvqPURQjd8bo3tDE8meTrDTxcGJ5Cl50cCW4QP+gRo4UAMTVwP/D+ivYZ7Ysvs4AAAAAElFTkSuQmCC', 999, 'admin', 'wangyin', '2024-02-05 17:29:46', '2024-08-01 14:04:15'),
(69, 16, '--side-bar-logo-title-width', '150px', 999, 'admin', 'wangyin', '2024-02-05 17:30:00', '2024-08-01 14:04:16'),
(70, 16, '--side-bar-logo-bg-height', '88px', 999, 'admin', 'wangyin', '2024-02-05 17:30:09', '2024-08-01 14:04:16'),
(71, 16, '--side-bar-logo-line-height', '60px', 999, 'admin', 'wangyin', '2024-02-05 17:30:15', '2024-08-01 14:04:16'),
(72, 16, '--side-bar-logo-bg-color', '#fff', 999, 'admin', 'wangyin', '2024-02-05 17:30:23', '2024-08-01 14:04:16'),
(73, 16, '--side-bar-logo-img', 'data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPHN2ZyB3aWR0aD0iMTY3cHgiIGhlaWdodD0iMTkzcHgiIHZpZXdCb3g9IjAgMCAxNjcgMTkzIiB2ZXJzaW9uPSIxLjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgeG1sbnM6eGxpbms9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkveGxpbmsiPgogICAgPHRpdGxlPue8lue7hCA0PC90aXRsZT4KICAgIDxkZWZzPgogICAgICAgIDxsaW5lYXJHcmFkaWVudCB4MT0iNDguNzI4NTUwMyUiIHkxPSIxMDEuOTI5NTglIiB4Mj0iNTEuMjM4OTEwNSUiIHkyPSItMS4zNDczNTA2NiUiIGlkPSJsaW5lYXJHcmFkaWVudC0xIj4KICAgICAgICAgICAgPHN0b3Agc3RvcC1jb2xvcj0iIzFFMDBFOCIgb2Zmc2V0PSIwJSI+PC9zdG9wPgogICAgICAgICAgICA8c3RvcCBzdG9wLWNvbG9yPSIjMUQ0N0U3IiBvZmZzZXQ9IjAlIj48L3N0b3A+CiAgICAgICAgICAgIDxzdG9wIHN0b3AtY29sb3I9IiMwNkZGQzkiIHN0b3Atb3BhY2l0eT0iMC4xIiBvZmZzZXQ9IjEwMCUiPjwvc3RvcD4KICAgICAgICA8L2xpbmVhckdyYWRpZW50PgogICAgICAgIDxsaW5lYXJHcmFkaWVudCB4MT0iMTAxLjkyOTk1JSIgeTE9IjYyLjU3Mjc4NiUiIHgyPSIyNy4zMDUyMTglIiB5Mj0iMzAuNDIyMzc2MSUiIGlkPSJsaW5lYXJHcmFkaWVudC0yIj4KICAgICAgICAgICAgPHN0b3Agc3RvcC1jb2xvcj0iIzFFMDBFOCIgb2Zmc2V0PSIwJSI+PC9zdG9wPgogICAgICAgICAgICA8c3RvcCBzdG9wLWNvbG9yPSIjMDZGRkM5IiBzdG9wLW9wYWNpdHk9IjAuMSIgb2Zmc2V0PSIxMDAlIj48L3N0b3A+CiAgICAgICAgPC9saW5lYXJHcmFkaWVudD4KICAgICAgICA8bGluZWFyR3JhZGllbnQgeDE9IjQxLjY0MzUxNzglIiB5MT0iOTAuMTU0Nzk4OCUiIHgyPSI5Ni40MDQwMDI1JSIgeTI9Ii05LjQ3MzY4NDIxJSIgaWQ9ImxpbmVhckdyYWRpZW50LTMiPgogICAgICAgICAgICA8c3RvcCBzdG9wLWNvbG9yPSIjMUUwMEU4IiBvZmZzZXQ9IjAlIj48L3N0b3A+CiAgICAgICAgICAgIDxzdG9wIHN0b3AtY29sb3I9IiMxRDQ3RTciIG9mZnNldD0iMCUiPjwvc3RvcD4KICAgICAgICAgICAgPHN0b3Agc3RvcC1jb2xvcj0iIzA2RkZDOSIgc3RvcC1vcGFjaXR5PSIwIiBvZmZzZXQ9IjY4JSI+PC9zdG9wPgogICAgICAgIDwvbGluZWFyR3JhZGllbnQ+CiAgICAgICAgPGxpbmVhckdyYWRpZW50IHgxPSIwJSIgeTE9IjUwJSIgeDI9IjEwMCUiIHkyPSI1MCUiIGlkPSJsaW5lYXJHcmFkaWVudC00Ij4KICAgICAgICAgICAgPHN0b3Agc3RvcC1jb2xvcj0iIzFFMDBFOCIgb2Zmc2V0PSIwJSI+PC9zdG9wPgogICAgICAgICAgICA8c3RvcCBzdG9wLWNvbG9yPSIjMUQ0N0U3IiBvZmZzZXQ9IjAlIj48L3N0b3A+CiAgICAgICAgICAgIDxzdG9wIHN0b3AtY29sb3I9IiMwNkZGQzkiIHN0b3Atb3BhY2l0eT0iMC4xIiBvZmZzZXQ9IjEwMCUiPjwvc3RvcD4KICAgICAgICA8L2xpbmVhckdyYWRpZW50PgogICAgICAgIDxsaW5lYXJHcmFkaWVudCB4MT0iMCUiIHkxPSI0OS45NTc0NDY4JSIgeDI9IjEwMCUiIHkyPSI0OS45NTc0NDY4JSIgaWQ9ImxpbmVhckdyYWRpZW50LTUiPgogICAgICAgICAgICA8c3RvcCBzdG9wLWNvbG9yPSIjMUUwMEU4IiBvZmZzZXQ9IjAlIj48L3N0b3A+CiAgICAgICAgICAgIDxzdG9wIHN0b3AtY29sb3I9IiMxRDQ3RTciIG9mZnNldD0iMCUiPjwvc3RvcD4KICAgICAgICAgICAgPHN0b3Agc3RvcC1jb2xvcj0iIzA2RkZDOSIgc3RvcC1vcGFjaXR5PSIwLjEiIG9mZnNldD0iMTAwJSI+PC9zdG9wPgogICAgICAgIDwvbGluZWFyR3JhZGllbnQ+CiAgICAgICAgPGxpbmVhckdyYWRpZW50IHgxPSI1MC45NDE4NDE1JSIgeTE9IjEwMy43ODUwMTElIiB4Mj0iNDkuOTM0MjkwMSUiIHkyPSI0Ni4wMjU3MzgxJSIgaWQ9ImxpbmVhckdyYWRpZW50LTYiPgogICAgICAgICAgICA8c3RvcCBzdG9wLWNvbG9yPSIjMjYzMEVBIiBzdG9wLW9wYWNpdHk9IjAuNCIgb2Zmc2V0PSIwJSI+PC9zdG9wPgogICAgICAgICAgICA8c3RvcCBzdG9wLWNvbG9yPSIjMDZGRkM5IiBzdG9wLW9wYWNpdHk9IjAuMiIgb2Zmc2V0PSI5OSUiPjwvc3RvcD4KICAgICAgICA8L2xpbmVhckdyYWRpZW50PgogICAgPC9kZWZzPgogICAgPGcgaWQ9IkNvZGVQYWwiIHN0cm9rZT0ibm9uZSIgc3Ryb2tlLXdpZHRoPSIxIiBmaWxsPSJub25lIiBmaWxsLXJ1bGU9ImV2ZW5vZGQiPgogICAgICAgIDxnIGlkPSLnvJbnu4QtNCIgdHJhbnNmb3JtPSJ0cmFuc2xhdGUoMC4wMDAwMDAsIDAuNDQ3MjIyKSIgZmlsbC1ydWxlPSJub256ZXJvIj4KICAgICAgICAgICAgPHBvbHlnb24gaWQ9Iui3r+W+hCIgZmlsbD0iIzFFMDBFOCIgcG9pbnRzPSI0NS4zOTc2NTk2IDIxLjgxNTQ3OTkgMzcuODQxMjk5NCAyNi4yMTQyNDE1IDAgNDcuOTcwMjc4NiAzNy44NDEyOTk0IDY5Ljg0NTIwMTIgODMuMjM4OTU5IDQzLjYzMDk1OTggODMuMjM4OTU5IDAiPjwvcG9seWdvbj4KICAgICAgICAgICAgPHBvbHlnb24gaWQ9Iui3r+W+hCIgZmlsbD0idXJsKCNsaW5lYXJHcmFkaWVudC0xKSIgcG9pbnRzPSI4My4yMzg5NTkgOTYgODMuMjM4OTU5IDE5MiAxMjMuODE3MjA4IDE2OC41Nzk1NjcgMTIzLjgxNzIwOCA3Mi41Nzk1NjY2IDgzLjIzODk1OSA5NiA4My4yMzg5NTkgOTYiPjwvcG9seWdvbj4KICAgICAgICAgICAgPHBvbHlnb24gaWQ9Iui3r+W+hCIgZmlsbD0idXJsKCNsaW5lYXJHcmFkaWVudC0yKSIgcG9pbnRzPSIzNy44NDEyOTk0IDEyMi4yMTQyNDEgMzcuODQxMjk5NCAxMjIuMjE0MjQxIDAgMTQ0LjAyOTcyMSAzNy44NDEyOTk0IDE2NS44NDUyMDEgNDUuMzk3NjU5NiAxNzAuMTg0NTIgODMuMjM4OTU5IDE5MiA4My4yMzg5NTkgMTQ4LjM2OTA0IDgzLjIzODk1OSAxNDguMzY5MDQiPjwvcG9seWdvbj4KICAgICAgICAgICAgPHBvbHlsaW5lIGlkPSLot6/lvoQiIGZpbGw9InVybCgjbGluZWFyR3JhZGllbnQtMykiIHBvaW50cz0iODMuMjM4OTU5IDk2IDgzLjIzODk1OSA5NiAwIDE0NC4wMjk3MjEgMCAxNDQuMDI5NzIxIDgzLjIzODk1OSAxOTIgODMuMjM4OTU5IDE5MiI+PC9wb2x5bGluZT4KICAgICAgICAgICAgPHBvbHlnb24gaWQ9Iui3r+W+hCIgZmlsbD0idXJsKCNsaW5lYXJHcmFkaWVudC00KSIgcG9pbnRzPSI4My4yMzg5NTkgOTYgMTIzLjgxNzIwOCA3Mi41Nzk1NjY2IDgzLjIzODk1OSA0OS4xNTkxMzMxIDQyLjY2MDcxMDIgNzIuNTc5NTY2NiA4My4yMzg5NTkgOTYgODMuMjM4OTU5IDk2Ij48L3BvbHlnb24+CiAgICAgICAgICAgIDxwb2x5Z29uIGlkPSLot6/lvoQiIGZpbGw9IiMwNjExQzkiIHBvaW50cz0iMCA0Ny45NzAyNzg2IDAgOTEuNjYwNjgxMSAwIDEwMC4zOTg3NjIgMCAxNDQuMDI5NzIxIDM3Ljg0MTI5OTQgMTIyLjIxNDI0MSAzNy44NDEyOTk0IDEyMi4yMTQyNDEgMzcuODQxMjk5NCA2OS44NDUyMDEyIj48L3BvbHlnb24+CiAgICAgICAgICAgIDxwb2x5Z29uIGlkPSLot6/lvoQiIGZpbGw9IiMxNTE2RjciIHBvaW50cz0iMTIzLjgxNzIwOCAxMjIuMTU0Nzk5IDEyMy44MTcyMDggMTIyLjIxNDI0MSAxMjMuODE3MjA4IDEyMi4yMTQyNDEiPjwvcG9seWdvbj4KICAgICAgICAgICAgPHBvbHlnb24gaWQ9Iui3r+W+hCIgZmlsbD0iIzI2MzBFQSIgcG9pbnRzPSIxMjguNjM2NjE5IDI2LjIxNDI0MTUgMTIxLjAyMDc2IDIxLjgxNTQ3OTkgODMuMjM4OTU5IDAgODMuMjM4OTU5IDQzLjYzMDk1OTggMTI4LjYzNjYxOSA2OS44NDUyMDEyIDE2Ni40MTg0MTkgOTEuNjYwNjgxMSAxNjYuNDE4NDE5IDQ3Ljk3MDI3ODYiPjwvcG9seWdvbj4KICAgICAgICAgICAgPHBvbHlnb24gaWQ9Iui3r+W+hCIgZmlsbD0idXJsKCNsaW5lYXJHcmFkaWVudC01KSIgcG9pbnRzPSI0NS4zOTc2NTk2IDIxLjgxNTQ3OTkgMzcuODQxMjk5NCAyNi4yMTQyNDE1IDAgNDcuOTcwMjc4NiAzNy44NDEyOTk0IDY5Ljg0NTIwMTIgMzcuODQxMjk5NCA2OS44NDUyMDEyIDgzLjIzODk1OSA0My42MzA5NTk4IDgzLjIzODk1OSAwIj48L3BvbHlnb24+CiAgICAgICAgICAgIDxwb2x5Z29uIGlkPSLot6/lvoQiIGZpbGw9IiMwNjExQzkiIHBvaW50cz0iMTY2LjQxODQxOSA0Ny45NzAyNzg2IDEyOC42MzY2MTkgNjkuODQ1MjAxMiAxMjguNjM2NjE5IDEyMi4xNTQ3OTkgMTI4LjYzNjYxOSAxMjIuMTU0Nzk5IDEyOC42MzY2MTkgMTIyLjE1NDc5OSAxMjguNjM2NjE5IDEyMi4yMTQyNDEgMTI4LjYzNjYxOSAxMjIuMjE0MjQxIDEyOC42MzY2MTkgMTY1Ljg0NTIwMSAxNjYuNDE4NDE5IDE0NC4wMjk3MjEgMTY2LjQxODQxOSAxMDAuMzk4NzYyIj48L3BvbHlnb24+CiAgICAgICAgICAgIDxwb2x5Z29uIGlkPSLot6/lvoQiIGZpbGw9InVybCgjbGluZWFyR3JhZGllbnQtNikiIG9wYWNpdHk9IjAuNSIgcG9pbnRzPSI4My4yMzg5NTkgOTYgMzcuODQxMjk5NCA2OS44NDUyMDEyIDM3Ljg0MTI5OTQgMTIyLjIxNDI0MSA4My4yMzg5NTkgMTQ4LjM2OTA0IDgzLjIzODk1OSA5NiA4My4yMzg5NTkgOTYiPjwvcG9seWdvbj4KICAgICAgICA8L2c+CiAgICA8L2c+Cjwvc3ZnPg==', 999, 'admin', 'test', '2024-02-05 17:30:30', '2024-07-16 23:07:52');
INSERT INTO `sys_dict_detail` (`detail_id`, `dict_id`, `label`, `value`, `dict_sort`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES
(75, 16, '--side-bar-logo-icon-width', '32px', 999, 'admin', 'test', '2024-02-05 17:30:44', '2024-05-07 16:18:44'),
(76, 16, '--side-bar-logo-icon-height', '32px', 999, 'admin', 'test', '2024-02-05 17:30:51', '2024-05-07 16:16:36'),
(77, 16, '--side-bar-box-shadow', '10px 10px 16px 0 rgba(0,0,0,0.10)', 999, 'admin', 'wangyin', '2024-02-05 17:30:59', '2024-08-01 14:04:17'),
(78, 16, '--side-bar-logo-font-size', '14px', 999, 'admin', 'wangyin', '2024-02-07 13:51:26', '2024-08-01 14:04:15'),
(84, 8, 'es_url', 'http://es01:9200', 3, 'test', 'test', '2024-02-29 11:21:46', '2024-08-23 11:10:11'),
(85, 8, 'es_user', 'elastic', 3, 'test', 'test', '2024-03-04 14:40:51', '2024-03-04 15:05:28'),
(86, 8, 'es_password', '8IpWQfcZXXmRsIkX7+yy', 3, 'test', 'test', '2024-03-04 14:41:44', '2024-08-23 11:10:52'),
(87, 7, '文档阅读', 'doc', 999, 'admin', 'admin', '2024-03-21 14:12:31', '2024-05-24 10:26:06'),
(90, 19, 'llm', 'qwen-72B', 999, 'msyh', 'msyh', '2024-04-07 17:05:49', '2024-04-07 17:05:49'),
(91, 19, 'temperature', '0.1', 999, 'msyh', 'msyh', '2024-04-07 17:06:42', '2024-04-07 17:06:42'),
(92, 19, 'topK', '3', 999, 'msyh', 'msyh', '2024-04-07 17:06:58', '2024-04-07 17:06:58'),
(93, 19, 'prompt_template', '参考文本:{context) ---------------------------- #Role: 客服 #Background  -你是一名人工客服，你的日常工作是根据【参考文本】的内容来回复用户的各种问题 #Goals:  -以上【参考文本)中是从企业知识率中查找到相关信息，只能结合以上信息进行回答，若以上内容为空或者没有找到能回答【用户问题】的内容时，则回复”没有找到相关内容”，不能很播你自己的知识发挥。特别要区分【用户问题】与【参考文本】中不同的日期、人名、公司这些关键信息。·用中文回答问题，并且答案严谨、专业、清晰、可读性好。-拥有排版市美，会利用序号、缩进、分制线和换行符等等来美化信息排版。  ------------------------------  用户问题:(question) 你的回答:', 999, 'msyh', 'msyh', '2024-04-07 17:08:52', '2024-04-07 17:10:47'),
(94, 19, 'prompt_default', '知识库默认模版1', 999, 'msyh', 'msyh', '2024-04-08 10:55:40', '2024-04-08 10:56:34'),
(95, 8, 'rag_api', 'http://llm-rag:8001', 2, 'test', 'admin', '2024-04-10 10:07:45', '2024-08-21 14:34:55'),
(96, 8, 'embed_url', 'http://llm-infinity:8781', 4, 'test', 'admin', '2024-04-11 17:30:12', '2024-08-28 17:13:00'),
(97, 8, 'embed_apikey', 'Basic YWRtaW46YWRtaW4xMjM=', 4, 'test', 'test', '2024-04-11 17:36:36', '2024-04-25 11:19:12'),
(99, 8, 'reranker_size', '30', 999, 'test', 'test', '2024-04-26 16:45:26', '2024-06-20 17:21:07'),
(100, 8, 'embed_model', 'BAAI/bge-large-zh', 999, 'test', 'test', '2024-04-28 12:54:28', '2024-08-23 11:13:08'),
(105, 8, 'reranker_url', 'http://llm-infinity:8781/rerank', 4, 'test', 'test', '2024-05-12 00:15:08', '2024-08-23 12:32:14'),
(110, 20, '知识库匹配替换', 'substitute', 999, 'test', 'admin', '2024-05-13 16:27:33', '2024-07-30 10:50:49'),
(111, 20, '知识库匹配返回', 'match', 999, 'test', 'admin', '2024-05-13 16:27:50', '2024-07-30 10:50:42'),
(112, 22, 'app_url', 'http://192.168.107.2:8029', 999, 'test', 'test', '2024-05-14 11:45:04', '2024-07-04 16:59:45'),
(114, 22, 'app_apikey', '8b0e066ec86a49eaa7ccea9d42b20c17', 999, 'admin', 'admin', '2024-05-15 17:27:10', '2024-05-16 11:40:47'),
(122, 8, 'load_doc_deep', 'false', 999, 'test', 'test', '2024-05-24 18:55:29', '2024-08-23 09:45:33'),
(123, 26, '递归分割', 'RecursiveCharacterTextSplitter', 999, 'test', 'admin', '2024-05-27 14:44:56', '2024-05-27 14:48:04'),
(124, 26, '语义分割', 'SemanticChunker', 999, 'test', 'admin', '2024-05-27 14:45:25', '2024-05-27 14:47:56'),
(125, 26, 'Spacy语句分割', 'Spacy', 999, 'admin', 'admin', '2024-05-27 14:53:17', '2024-05-27 14:53:17'),
(126, 26, 'NLTK语句分割', 'NLTK', 999, 'admin', 'admin', '2024-05-27 14:53:30', '2024-05-27 14:53:30'),
(129, 20, '知识库匹配扩写', 'expansion', 999, 'admin', 'admin', '2024-05-28 14:33:52', '2024-07-30 10:50:37'),
(138, 8, 'multi_model_url', 'http://192.168.107.2:8012/v1/chat/completions', 999, 'test', 'test', '2024-06-05 13:56:05', '2024-06-05 18:30:27'),
(139, 28, 'DOC_CAHT_CODE', 'PT-20240620-00000010', 999, 'test', 'admin', '2024-06-20 09:57:56', '2024-06-20 14:49:03'),
(140, 28, 'GENERATE_TAGS_CODE', 'PT-20240620-00000009', 999, 'test', 'test', '2024-06-20 09:58:26', '2024-07-01 17:48:53'),
(141, 28, 'GENERATE_QUESTION_CODE', 'PT-20240620-00000008', 999, 'test', 'admin', '2024-06-20 10:00:14', '2024-06-20 14:48:06'),
(142, 28, 'GENERATE_MARK_CODE', 'PT-20240620-00000007', 999, 'test', 'admin', '2024-06-20 10:00:59', '2024-06-20 14:47:45'),
(143, 10, '排队中', 'waiting', 1, 'test', 'test', '2024-06-21 01:28:35', '2024-07-18 16:43:17'),
(150, 22, 'cass_url', 'http://192.168.107.2:8025', 999, 'test', 'test', '2024-06-27 10:55:05', '2024-06-27 10:55:05'),
(154, 8, 'notice_content', '2024-07-05发版', 999, 'test', 'test', '2024-07-04 16:17:14', '2024-07-04 16:17:14'),
(155, 13, 'chat_content_length', '2048', 999, 'test', 'test', '2024-07-04 16:20:14', '2024-08-02 14:19:08'),
(156, 8, 'upload_rag_limit', '4', 999, 'test', 'test', '2024-07-09 18:50:52', '2024-08-24 19:06:55'),
(159, 13, 'notice_enable', 'N', 999, 'admin', 'test', '2024-07-12 15:14:04', '2024-07-25 16:28:57'),
(160, 13, 'notice_content', '2024年07月16日15:27:36  进行系统升级。', 999, 'admin', 'test', '2024-07-12 15:15:01', '2024-07-24 10:17:49'),
(161, 8, 'user_limit_size', '2048', 999, 'admin', '林光', '2024-07-12 15:20:05', '2024-08-21 19:22:12'),
(162, 30, '农、林、牧、渔业', 'A', 999, 'admin', '林光', '2024-07-15 17:56:50', '2024-08-09 09:30:14'),
(164, 6, '处理中', 'processing', 999, 'test', 'test', '2024-07-26 15:11:06', '2024-07-26 15:11:06'),
(165, 13, 'bm25_retriever', 'N', 999, 'test', 'test', '2024-07-26 17:21:26', '2024-07-26 17:21:26'),
(166, 32, 'size', '100', 999, 'test', '林光', '2024-07-29 11:22:22', '2024-08-21 19:22:00'),
(167, 32, 'suffix', 'txt|doc|docx|ppt|pptx|xls|xlsx|html|pdf|jpg|jpeg|png|apng|gif|tif|bmp|webp|md|py|json', 999, 'test', '林光', '2024-07-29 11:26:41', '2024-08-13 16:32:28'),
(168, 20, '通用匹配返回', 'chat_match', 999, 'admin', 'admin', '2024-07-29 14:04:37', '2024-07-29 14:20:44'),
(169, 28, 'QUESTION_COMPLETE_CODE', 'PT-20240620-00000011', 999, 'admin', 'admin', '2024-07-31 10:10:26', '2024-07-31 10:10:26'),
(171, 32, 'topdf', 'Y', 999, 'admin', 'admin', '2024-07-31 11:42:59', '2024-08-23 17:39:22'),
(172, 8, 'llm_data_url', 'http://192.168.107.3:8023', 999, 'test', 'test', '2024-08-01 18:01:39', '2024-08-23 06:33:03'),
(173, 6, '排队中', 'waiting', 999, 'test', 'test', '2024-08-05 11:16:55', '2024-08-05 11:16:55'),
(174, 8, 'converter_url', 'http://gotenberg:3000', 999, 'test', 'test', '2024-08-07 13:41:28', '2024-08-07 13:41:28'),
(175, 32, 'excludeToPdf', 'txt,pdf,html,md', 999, 'test', 'admin', '2024-08-07 13:43:27', '2024-08-29 09:38:42'),
(177, 32, 'pdfParams', 'landscape=false;exportNotes=true', 999, 'test', 'test', '2024-08-07 15:51:47', '2024-08-07 16:02:55'),
(178, 32, 'jorp', 'p', 999, 'test', 'test', '2024-08-07 18:20:21', '2024-08-23 17:40:41'),
(183, 30, '采矿业', 'B', 999, '林光', '林光', '2024-08-09 09:30:25', '2024-08-09 09:30:25'),
(184, 30, '制造业', 'C', 999, '林光', '林光', '2024-08-09 09:30:35', '2024-08-09 09:30:35'),
(185, 30, '电力、热力、燃气及水生产和供应业', 'D', 999, '林光', '林光', '2024-08-09 09:30:48', '2024-08-09 09:30:48'),
(186, 30, '建筑业', 'E', 999, '林光', '林光', '2024-08-09 09:30:58', '2024-08-09 09:30:58'),
(187, 30, '批发和零售业', 'F', 999, '林光', '林光', '2024-08-09 09:31:06', '2024-08-09 09:31:06'),
(188, 30, '交通运输、仓储和邮政业', 'G', 999, '林光', '林光', '2024-08-09 09:31:14', '2024-08-09 09:31:14'),
(189, 30, '住宿和餐饮业', 'H', 999, '林光', '林光', '2024-08-09 09:31:24', '2024-08-09 09:31:24'),
(190, 30, '信息传输、软件和信息技术服务业', 'I', 999, '林光', '林光', '2024-08-09 09:31:42', '2024-08-09 09:31:42'),
(191, 30, '金融业', 'J', 999, '林光', '林光', '2024-08-09 09:31:51', '2024-08-09 09:31:51'),
(192, 30, '房地产业', 'K', 999, '林光', '林光', '2024-08-09 09:32:00', '2024-08-09 09:32:00'),
(193, 30, '租赁和商务服务业', 'L', 999, '林光', '林光', '2024-08-09 09:32:09', '2024-08-09 09:32:09'),
(194, 30, '科学研究和技术服务业', 'M', 999, '林光', '林光', '2024-08-09 09:32:20', '2024-08-09 09:32:20'),
(195, 30, '水利、环境和公共设施管理业', 'N', 999, '林光', '林光', '2024-08-09 09:32:28', '2024-08-09 09:32:28'),
(196, 30, '居民服务、修理和其他服务业', 'O', 999, '林光', '林光', '2024-08-09 09:32:36', '2024-08-09 09:32:36'),
(197, 30, '教育', 'P', 999, '林光', '林光', '2024-08-09 09:32:45', '2024-08-09 09:32:45'),
(198, 30, '卫生和社会工作', 'Q', 999, '林光', '林光', '2024-08-09 09:32:52', '2024-08-09 09:32:52'),
(199, 30, '文化、体育和娱乐业', 'R', 999, '林光', '林光', '2024-08-09 09:33:02', '2024-08-09 09:33:02'),
(200, 30, '公共管理、社会保障和社会组织', 'S', 999, '林光', '林光', '2024-08-09 09:33:11', '2024-08-09 09:33:11'),
(201, 30, '国际组织', 'T', 999, '林光', '林光', '2024-08-09 09:33:20', '2024-08-09 09:33:20'),
(204, 13, 'related_question_kb_id', '354', 999, '林光', '林光', '2024-08-20 10:50:08', '2024-08-20 10:50:08'),
(205, 13, 'related_question_topK', '4', 999, '林光', '林光', '2024-08-20 10:50:25', '2024-08-27 17:17:15'),
(207, 13, 'rag_retriever', 'Y', 999, 'test', 'test', '2024-08-20 17:22:39', '2024-08-20 17:22:39'),
(208, 8, 'reranker_model', 'BAAI/bge-reranker-v2-m3', 999, 'test', 'test', '2024-08-22 17:25:25', '2024-08-23 11:00:18'),
(211, 8, 'spacy_pipeline', 'zh_core_web_sm', 999, 'test', 'test', '2024-08-23 16:33:52', '2024-08-26 09:50:06'),
(212, 8, 'doc_parser', 'unstructured', 999, 'test', 'test', '2024-08-24 14:26:58', '2024-08-24 18:35:35'),
(213, 32, 'gdupload', 'true', 999, 'admin', 'test', '2024-08-28 15:35:19', '2024-08-29 14:01:34'),
(218, 28, 'default_template_code', 'da5bad82-46e4-4170-8cbe-255c2d7958c0', 999, 'admin', 'admin', '2024-09-09 18:04:38', '2024-09-09 18:04:38');

INSERT INTO `sys_job` (`job_id`, `name`, `enabled`, `job_sort`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES
(11, '全栈开发', b'1', 2, NULL, 'admin', '2019-03-31 13:39:30', '2020-05-05 11:33:43');


INSERT INTO `sys_menu` VALUES (1,245,10,0,'系统管理',NULL,NULL,999,'system','system',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:04','2024-09-08 16:38:04'),(2,1,3,1,'用户管理','User','system/user/index',2,'peoples','user',_binary '\0',_binary '\0',_binary '\0','user:list','admin','admin','2024-09-08 16:37:53','2024-09-08 16:37:53'),(3,1,3,1,'角色管理','Role','system/role/index',3,'role','role',_binary '\0',_binary '\0',_binary '\0','roles:list','admin','admin','2024-09-08 16:37:55','2024-09-08 16:37:55'),(5,1,3,1,'菜单管理','Menu','system/menu/index',5,'menu','menu',_binary '\0',_binary '\0',_binary '\0','menu:list','admin','admin','2024-09-08 16:37:57','2024-09-08 16:37:57'),(6,245,5,0,'系统监控',NULL,NULL,10,'monitor','monitor',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:00','2024-09-08 16:38:00'),(7,6,0,1,'操作日志','Log','monitor/log/index',11,'log','logs',_binary '\0',_binary '
',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:00','2024-09-08 16:38:00'),(9,6,0,1,'SQL监控','Sql','monitor/sql/index',18,'sqlMonitor','druid',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:03','2024-09-08 16:38:03'),(28,1,3,1,'任务调度','Timing','system/timing/index',999,'timing','timing',_binary '\0',_binary '\0',_binary '\0','timing:list','admin','admin','2024-09-08 16:38:05','2024-09-08 16:38:05'),(32,6,0,1,'异常日志','ErrorLog','monitor/log/errorLog',12,'error','errorLog',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:02','2024-09-08 16:38:02'),(35,1,3,1,'部门管理','Dept','system/dept/index',6,'dept','dept',_binary '\0',_binary '\0',_binary '\0','dept:list','admin','admin','2024-09-08 16:37:58','2024-09-08 16:37:58'),(37,1,3,1,'岗位管理','Job','system/job/index',7,'Steve-Jobs','job',_binary '\0',_binary '\0',_binary '\0','job:list','admin','admin','2024-09-08 16:37:59','2024-09-08 16:37:59'),(39,1,3,1,'参数配置','Dict','system/dict/index',8,'dictionary','dict',_binary '\0',_binary '\0',_binary '\0','dict:list','admin','admin','2024-09-08 16:37:59','2024-09-08 16:37:59'),(41,6,0,1,'在线用户','OnlineUser','monitor/online/index',10,'Steve-Jobs','online',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:00','2024-09-08 16:38:00'),(80,6,0,1,'服务监控','ServerMonitor','monitor/server/index',14,'codeConsole','server',_binary '\0',_binary '\0',_binary '\0','monitor:list','admin','admin','2024-09-08 16:38:03','2024-09-08 16:38:03'),(118,245,9,0,'知识库',NULL,NULL,1,'skill','knowledge',_binary '\0',_binary '\0',_binary '\0','','admin','admin','2024-09-08 16:37:53','2024-09-08 16:37:53'),(119,118,4,1,'知识库管理KBM','KbKnowledge','knowledge/index',2,'app','knowledge',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:54','2024-09-08 16:37:54'),(120,118,0,1,'命中测试','Hit','knowledge/hit/index',91,'tools','hit',_binary '\0',_binary '
',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:03','2024-09-08 16:38:03'),(121,245,3,0,'模型管理',NULL,NULL,4,'chain','model',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:56','2024-09-08 16:37:56'),(122,245,3,0,'提示词工程',NULL,NULL,3,'chart','prompt',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:55','2024-09-08 16:37:55'),(123,125,4,1,'问题预处理CC','ContentCheck','chat/contentcheck/index',4,'sys-tools','security',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:56','2024-09-08 16:37:56'),(124,125,3,1,'问答历史','ChatHistory','chat/chathistory/index',11,'database','chat_history',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:01','2024-09-08 16:38:01'),(125,245,5,0,'问答管理',NULL,NULL,2,'dashboard','chat',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:54','2024-09-08 16:37:54'),(126,118,7,1,'知识源接入','file','knowledge/file/index',4,'doc','file',_binary '\0',_binary '
',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:57','2024-09-08 16:37:57'),(128,118,4,1,'权限策略','Auth','knowledge/auth/index',7,'role','auth',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:59','2024-09-08 16:37:59'),(130,121,4,1,'语言模型','LlmModel','model/model/index',11,'chain','llmmodel',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:01','2024-09-08 16:38:01'),(131,121,4,1,'Embedding模型','ModelEmbed','model/modelEmbed/index.vue',999,'date','modelEmbed',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:05','2024-09-08 16:38:05'),(133,125,0,1,'问答排队','ChatLimit','chat/limit/index',5,'timing','chatLimit',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:57','2024-09-08 16:37:57'),(134,122,4,1,'提示词场景','Scene','prompt/sence/index',11,'app','scene',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:01','2024-09-08 16:38:01'),(135,122,4,1,'提示词模板','Prompt','prompt/prompt/index',12,'dept','promp',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:02','2024-09-08 16:38:02'),(136,245,2,0,'应用接入',NULL,NULL,5,'web','open',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:57','2024-09-08 16:37:57'),(137,136,3,1,'接入渠道','OpenClient','open/openapi/index',999,'doc','openClient',_binary '\0',_binary '\0',_binary '\0','','admin','admin','2024-09-08 16:38:05','2024-09-08 16:38:05'),(139,136,0,1,'接入APIs','KnowledgeSdk','knowledge/sdk/index',999,'app','knowledgeSdk',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:05','2024-09-08 16:38:05'),(140,118,0,1,'知识库问答','ChatKnowledge','chat/chatKb.vue',1,'message','chatkb',_binary '\0',_binary '
',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:53','2024-09-08 16:37:53'),(143,122,4,1,'问题引导','PromptQuestion','prompt/promptQuestion/index',999,'database','promptQuestion',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:06','2024-09-08 16:38:06'),(188,125,0,1,'问答统计','ChatStatics','chat/statics/index',12,'anq','chatStatics',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:02','2024-09-08 16:38:02'),(189,1,0,1,'皮肤管理','UiTheme','system/uiTheme/index',998,'theme','system/uiTheme',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:03','2024-09-08 16:38:03'),(190,245,4,0,'民生现场技能',NULL,NULL,999,'like-fill','a',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:06','2024-09-08 16:38:06'),(191,190,0,1,'续写',NULL,NULL,999,'unlike-fill','http://110.16.193.170:50062/chat/0eebd5b8-bcce-4483-ac84-c38fda7c272a?userId=0000197350&role=R001',_binary '
',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:06','2024-09-08 16:38:06'),(192,190,0,1,'润色',NULL,NULL,999,'validCode','http://110.16.193.170:50062/chat/b61698e4-dabe-4748-a974-51dcbc1436c1?userId=0000197350&role=R001',_binary '
',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:06','2024-09-08 16:38:06'),(193,190,0,0,'摘要',NULL,NULL,999,'validCode','http://110.16.193.170:50062/chat/e93e8585-3905-4016-8c71-70de4a70d29f?userId=0000197350&role=R001',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:07','2024-09-08 16:38:07'),(194,190,0,1,'单文档问答',NULL,NULL,999,'source','http://110.16.193.170:50062/chat/c6e6b6dd-6c34-46fa-890a-17833e7a098f?userId=0000197350&role=R001',_binary '
',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:07','2024-09-08 16:38:07'),(195,245,5,0,'民生应用中心',NULL,NULL,999,'swagger','v',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:07','2024-09-08 16:38:07'),(196,195,0,1,'知识库集合',NULL,NULL,999,'tree','http://110.16.193.170:50062/api/v2/rpc/auth?deptId=0000177350&deptName=数据部&user_id=0000197350&role_id=1&menu=filelib',_binary '
',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:07','2024-09-08 16:38:07'),(197,195,0,1,'新建技能',NULL,NULL,999,'tools','http://110.16.193.170:50062/api/v2/rpc/auth?deptId=0000177350&deptName=数据部8&user_id=0000197350&role_id=1&menu=skills',_binary '
',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:08','2024-09-08 16:38:08'),(198,195,0,1,'应用体验',NULL,NULL,999,'redis','http://110.16.193.170:50062/api/v2/rpc/auth?deptId=0000177350&deptName=数据部&user_id=0000197350&role_id=1',_binary '
',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:08','2024-09-08 16:38:08'),(199,195,0,1,'大模型管理',NULL,NULL,999,'web','http://110.16.193.170:50062/api/v2/rpc/auth?deptId=0000177350&deptName=数据部&user_id=0000197350&role_id=1&menu=sys',_binary '
',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:08','2024-09-08 16:38:08'),(200,195,0,1,'基础模型管理',NULL,NULL,999,'user1','http://110.16.193.170:50062/api/v2/rpc/auth?deptId=0000177350&deptName=数据部&user_id=0000197350&role_id=1&menu=model',_binary '
',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:08','2024-09-08 16:38:08'),(201,118,0,1,'问答准确率评估','Ragas','knowledge/ragas/index',999,'source','ragas',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:09','2024-09-08 16:38:09'),(206,118,3,1,'问答对管理','qnaPair','knowledge/qnaPair/index.vue',5,'weixin','qnaPair',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:58','2024-09-08 16:37:58'),(210,211,0,1,'元数据配置',NULL,NULL,999,'source','http://llmtest.yangzhiqiang.tech/openkv/',_binary '
',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:09','2024-09-08 16:38:09'),(211,245,1,0,'数据集管理',NULL,NULL,999,'survey','datasets',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:09','2024-09-08 16:38:09'),(212,1,0,1,'工作台','WorkSpace','workSpace/index.vue',999,'system1','workSpace',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:09','2024-09-08 16:38:09'),(220,245,4,0,'大模型应用开发',NULL,NULL,999,'survey','llmdev',_binary '\0',_binary '\0',_binary '
',NULL,'admin','admin','2024-09-08 16:38:10','2024-09-08 16:38:10'),(221,220,0,1,'dify平台',NULL,NULL,999,'star-fill','http://192.168.107.2/signin',_binary '
',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:10','2024-09-08 16:38:10'),(222,118,7,1,'知识管理KM',NULL,'knowledge/chunk/index',6,'education','chunk',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:58','2024-09-08 16:37:58'),(225,121,0,1,'GPU算力','GpuLimit','model/gpuLimit/index',999,'statistics','gpuLimit',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:10','2024-09-08 16:38:10'),(229,245,1,0,'运营管理',NULL,NULL,999,'survey','/operationManagement',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:11','2024-09-08 16:38:11'),(230,229,0,1,'知识运营KO','KnowledgeOperations','operationManagement/knowledgeOperations/index',999,'survey','knowledgeOperations',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:11','2024-09-08 16:38:11'),(236,NULL,1,1,'信审报告',NULL,NULL,999,'validCode','/creditReviewReport',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:11','2024-09-08 16:38:11'),(237,236,0,1,'文件上传',NULL,'creditReviewReport/fileUpload/index',999,'upload','/fileUpload',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:11','2024-09-08 16:38:11'),(238,220,0,0,'Langflow平台',NULL,NULL,999,'ico-30','http://192.168.107.2:7860/flows',_binary '
',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:12','2024-09-08 16:38:12'),(239,220,0,1,'FlowiseAI',NULL,NULL,999,'ico-25','http://192.168.107.2:3001/chatflows',_binary '
',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:12','2024-09-08 16:38:12'),(240,220,0,1,'ragflow',NULL,NULL,999,'ico-39','http://192.168.107.2:8081/login',_binary '
',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:12','2024-09-08 16:38:12'),(244,1,0,1,'配置管理','Config','system/config/index',999,'sys-tools','config',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:12','2024-09-08 16:38:12'),(245,NULL,12,0,'历史版本',NULL,NULL,999,'banben','12312',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:13','2024-09-08 16:38:13'),(246,125,0,1,'知识库统计','KnowledgeStatistics','chat/knowledgeStatistics/index',13,'codeConsole','knowledgeStatistics',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:02','2024-09-08 16:38:02'),(248,NULL,4,0,'知识管理',NULL,NULL,2,'ico-03','KnowledgeManage',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:54','2024-09-08 16:37:54'),(249,248,4,1,'知识库管理','KBKnowledge2','knowledge/index',2,'ico-03','knowlege2',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:54','2024-09-08 16:37:54'),(254,248,7,1,'知识内容管理','filenew','knowledge/file/index',3,'ico-01','file',_binary '\0',_binary '
',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:56','2024-09-08 16:37:56'),(262,248,5,1,'知识库权限管理','AuthNew','knowledge/auth/index',999,'role','auth',_binary '\0',_binary '
',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:04','2024-09-08 16:38:04'),(267,NULL,4,0,'知识运营',NULL,NULL,3,'nested','KnowledgeOperation',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:55','2024-09-08 16:37:55'),(268,267,4,1,'问题预处理','ContentCheckNew','chat/contentcheck/index',3,'document','security',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:55','2024-09-08 16:37:55'),(273,267,0,1,'知识库问答验证',NULL,'operationManagement/knowledgeOperations/index',7,'edit1','/knowledgeOperations',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:37:58','2024-09-08 16:37:58'),(274,248,0,1,'智能问答','ChatKnowledgeNew','chat/chatKb.vue',1,'ico-43','chatkb',_binary '\0',_binary '
',_binary '
',NULL,'admin','admin','2024-09-08 16:37:53','2024-09-08 16:37:53'),(275,267,3,1,'问答历史记录','ChatHistoryNew','chat/chathistory/index',11,'banben','chat_history',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:00','2024-09-08 16:38:00'),(281,118,11,1,'评估','Evaluation','knowledge/evaluation/index',999,'ico-39','evaluation',_binary '\0',_binary '\0',_binary '\0',NULL,'admin','admin','2024-09-08 16:38:04','2024-09-08 16:38:04'),(357,2,0,2,'用户新增',NULL,NULL,2,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','user:add',NULL,NULL,'2019-10-29 10:59:46',NULL),(358,2,0,2,'用户编辑',NULL,NULL,3,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','user:edit',NULL,NULL,'2019-10-29 11:00:08',NULL),(359,2,0,2,'用户删除',NULL,NULL,4,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','user:del',NULL,NULL,'2019-10-29 11:00:23',NULL),(360,3,0,2,'角色创建',NULL,NULL,2,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','roles:add',NULL,NULL,'2019-10-29 12:45:34',NULL),(361,3,0,2,'角色修改',NULL,NULL,3,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','roles:edit',NULL,NULL,'2019-10-29 12:46:16',NULL),(362,3,0,2,'角色删除',NULL,NULL,4,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','roles:del',NULL,NULL,'2019-10-29 12:46:51',NULL),(363,5,0,2,'菜单新增',NULL,NULL,2,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','menu:add',NULL,NULL,'2019-10-29 12:55:07',NULL),(364,5,0,2,'菜单编辑',NULL,NULL,3,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','menu:edit',NULL,NULL,'2019-10-29 12:55:40',NULL),(365,5,0,2,'菜单删除',NULL,NULL,4,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','menu:del',NULL,NULL,'2019-10-29 12:56:00',NULL),(366,28,0,2,'任务新增',NULL,NULL,2,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','timing:add',NULL,NULL,'2019-10-29 13:07:28',NULL),(367,28,0,2,'任务编辑',NULL,NULL,3,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','timing:edit',NULL,NULL,'2019-10-29 13:07:41',NULL),(368,28,0,2,'任务删除',NULL,NULL,4,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','timing:del',NULL,NULL,'2019-10-29 13:07:54',NULL),(369,35,0,2,'部门新增',NULL,NULL,2,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','dept:add',NULL,NULL,'2019-10-29 12:57:09',NULL),(370,35,0,2,'部门编辑',NULL,NULL,3,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','dept:edit',NULL,NULL,'2019-10-29 12:57:27',NULL),(371,35,0,2,'部门删除',NULL,NULL,4,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','dept:del',NULL,NULL,'2019-10-29 12:57:41',NULL),(372,37,0,2,'岗位新增',NULL,NULL,2,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','job:add',NULL,NULL,'2019-10-29 12:58:27',NULL),(373,37,0,2,'岗位编辑',NULL,NULL,3,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','job:edit',NULL,NULL,'2019-10-29 12:58:45',NULL),(374,37,0,2,'岗位删除',NULL,NULL,4,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','job:del',NULL,NULL,'2019-10-29 12:59:04',NULL),(375,39,0,2,'字典新增',NULL,NULL,2,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','dict:add',NULL,NULL,'2019-10-29 13:00:17',NULL),(376,39,0,2,'字典编辑',NULL,NULL,3,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','dict:edit',NULL,NULL,'2019-10-29 13:00:42',NULL),(377,39,0,2,'字典删除',NULL,NULL,4,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','dict:del',NULL,NULL,'2019-10-29 13:00:59',NULL),(378,18,0,2,'上传文件',NULL,NULL,2,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','storage:add',NULL,NULL,'2019-10-29 13:09:09',NULL),(379,18,0,2,'文件编辑',NULL,NULL,3,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','storage:edit',NULL,NULL,'2019-10-29 13:09:22',NULL),(380,18,0,2,'文件删除',NULL,NULL,4,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','storage:del',NULL,NULL,'2019-10-29 13:09:34',NULL),(381,92,0,2,'服务器新增',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','serverDeploy:add',NULL,NULL,'2019-11-17 11:08:33',NULL),(382,92,0,2,'服务器编辑',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','serverDeploy:edit',NULL,NULL,'2019-11-17 11:08:57',NULL),(383,92,0,2,'服务器删除',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','serverDeploy:del',NULL,NULL,'2019-11-17 11:09:15',NULL),(384,93,0,2,'应用新增',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','app:add',NULL,NULL,'2019-11-17 11:10:03',NULL),(385,93,0,2,'应用编辑',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','app:edit',NULL,NULL,'2019-11-17 11:10:28',NULL),(386,93,0,2,'应用删除',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','app:del',NULL,NULL,'2019-11-17 11:10:55',NULL),(387,94,0,2,'部署新增',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','deploy:add',NULL,NULL,'2019-11-17 11:11:22',NULL),(388,94,0,2,'部署编辑',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','deploy:edit',NULL,NULL,'2019-11-17 11:11:41',NULL),(389,94,0,2,'部署删除',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','deploy:del',NULL,NULL,'2019-11-17 11:12:01',NULL),(390,97,0,2,'删除',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','deployHistory:del',NULL,NULL,'2019-11-17 09:32:48',NULL),(391,98,0,2,'数据库新增',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','database:add',NULL,NULL,'2019-11-17 11:12:43',NULL),(392,98,0,2,'数据库编辑',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','database:edit',NULL,NULL,'2019-11-17 11:12:58',NULL),(393,98,0,2,'数据库删除',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','database:del',NULL,NULL,'2019-11-17 11:13:14',NULL),(394,119,0,2,'编辑知识库',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','kbKnowledge:edit','admin','admin','2024-01-29 15:19:39','2024-01-29 15:19:39'),(395,119,0,2,'删除知识库',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','kbKnowledge:del','admin','admin','2024-01-29 15:20:18','2024-01-29 15:20:18'),(396,119,0,2,'导出知识库',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','kbKnowledge:list','admin','test','2024-01-29 15:21:01','2024-03-20 16:26:18'),(397,119,0,2,'新增知识库',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','kbKnowledge:add','test','test','2024-08-02 10:10:52','2024-08-02 10:10:52'),(398,126,0,2,'上传知识源接入',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','kbKnowledgeFile:upload','admin','admin','2024-01-29 15:35:28','2024-01-29 15:35:28'),(399,126,0,2,'上传知识库接入ZIP',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','kbKnowledgeFile:uploadZip','admin','admin','2024-01-29 15:36:55','2024-01-29 15:36:55'),(400,126,0,2,'重新索引知识源接入',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','kbKnowledgeFile:reIndexFile','admin','admin','2024-01-29 15:38:02','2024-01-29 15:38:02'),(401,126,0,2,'删除知识源接入',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','kbKnowledgeFile:delete','admin','admin','2024-01-29 15:39:09','2024-01-29 15:39:09'),(402,126,0,2,'查询知识源列表',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','file:list','test','test','2024-01-29 16:51:30','2024-01-29 16:51:30'),(403,126,0,2,'删除文件',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','file:del','admin','admin','2024-01-31 01:36:39','2024-01-31 01:36:39'),(404,126,0,2,'修改文件',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','file:edit','test','test','2024-06-17 17:41:49','2024-06-17 17:41:49'),(405,128,0,2,'新增权限策略',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','auth:add','admin','admin','2024-01-29 15:43:20','2024-01-29 15:43:20'),(406,128,0,2,'修改权限策略',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','auth:edit','admin','admin','2024-01-29 15:44:04','2024-01-29 15:44:04'),(407,128,0,2,'删除权限策略',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','auth:del','admin','admin','2024-01-29 15:44:31','2024-01-29 15:44:31'),(408,128,0,2,'导出权限策略',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','auth:list','admin','admin','2024-01-29 15:45:28','2024-01-29 15:45:28'),(409,128,0,2,'全部权限',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','admin','admin','admin','2024-08-23 11:07:58','2024-08-23 11:07:58'),(410,140,0,2,'文档下载',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','file:download','admin','test','2024-08-01 17:15:49','2024-08-02 09:36:43'),(411,206,0,2,'QA对管理新增',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','qnaPair:add','admin','admin','2024-03-28 11:03:38','2024-03-28 11:03:38'),(412,206,0,2,'修改qnaPair',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','qnaPair:edit','admin','admin','2024-03-28 11:04:16','2024-03-28 11:04:16'),(413,206,0,2,'删除qnaPair',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','qnaPair:del','admin','admin','2024-03-28 11:04:48','2024-03-28 11:04:48'),(414,222,0,2,'chunk管理新增',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','kbChunk:add','test','test','2024-06-01 16:31:34','2024-06-01 16:31:34'),(415,222,0,2,'chunk管理更新',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','kbChunk:edit','test','test','2024-06-01 16:32:20','2024-06-01 16:32:20'),(416,222,0,2,'chunk管理删除',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','kbChunk:del','test','test','2024-06-01 16:32:50','2024-06-01 16:32:50'),(417,222,0,2,'树新增',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','tree:add','test','test','2024-06-04 11:24:39','2024-06-04 11:24:39'),(418,222,0,2,'树删除',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','tree:del','test','test','2024-06-04 11:25:08','2024-06-04 11:25:08'),(419,222,0,2,'树编辑',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','tree:edit','test','test','2024-06-04 11:25:38','2024-06-04 11:25:38'),(420,222,0,2,'知识管理列表',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','kbChunk:list','test','test','2024-06-17 18:42:38','2024-06-17 18:42:38'),(421,267,0,2,'新增数据',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','evalData:add','林光','林光','2024-08-26 14:23:38','2024-08-26 14:23:38'),(422,267,0,2,'编辑数据',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','evalData:edit','林光','林光','2024-08-26 14:24:58','2024-08-26 14:24:58'),(423,267,0,2,'删除数据',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','evalData:del','林光','林光','2024-08-26 14:25:15','2024-08-26 14:25:15'),(424,267,0,2,'新增评估集',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','eval:add','林光','林光','2024-08-27 14:15:42','2024-08-27 14:15:42'),(425,267,0,2,'编辑评估集',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','eval:edit','林光','林光','2024-08-27 14:16:00','2024-08-27 14:16:00'),(426,267,0,2,'删除评估集',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','eval:del','林光','林光','2024-08-27 14:16:17','2024-08-27 14:16:17'),(427,267,0,2,'评估历史导出数据',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','evalHistory:list','admin','admin','2024-08-30 16:23:23','2024-08-30 16:23:23'),(428,267,0,2,'评估历史删除',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','evalHistory:del','admin','admin','2024-08-30 16:25:31','2024-08-30 16:25:31'),(429,267,0,2,'开始评估',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','evalHistory:eval','admin','admin','2024-08-30 16:25:58','2024-08-30 16:25:58'),(430,267,0,2,'暂停评估',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','evalHistory:pause','admin','admin','2024-08-30 16:26:24','2024-08-30 16:26:24'),(431,267,0,2,'导出评估历史明细',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','evalHistoryDetail:list','admin','admin','2024-08-30 16:27:03','2024-08-30 16:27:03'),(432,130,0,2,'新增模型',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','llmModel:add','admin','admin','2024-01-29 10:56:24','2024-01-29 10:56:24'),(433,130,0,2,'修改模型',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','llmModel:edit','admin','admin','2024-01-29 10:57:14','2024-01-29 10:57:14'),(434,130,0,2,'删除模型',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','llmModel:del','admin','admin','2024-01-29 11:05:10','2024-01-29 11:05:10'),(435,130,0,2,'导出模型',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','llmModel:list','admin','admin','2024-01-29 11:05:39','2024-01-29 11:05:39'),(436,131,0,2,'新增Embedding模型',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','modelEmbed:add','admin','admin','2024-01-29 14:44:23','2024-01-29 14:45:16'),(437,131,0,2,'修改Embedding模型',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','modelEmbed:edit','admin','admin','2024-01-29 14:47:15','2024-01-29 14:47:15'),(438,131,0,2,'删除Embedding模型',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','modelEmbed:del','admin','admin','2024-01-29 14:58:16','2024-01-29 14:58:16'),(439,131,0,2,'导出Embedding模型',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','modelEmbed:list','admin','admin','2024-01-29 14:59:07','2024-01-29 14:59:07'),(440,134,0,2,'新增场景',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','scene:add','admin','admin','2024-01-29 10:42:51','2024-01-29 10:42:51'),(441,134,0,2,'修改场景',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','scene:edit','admin','admin','2024-01-29 10:43:23','2024-01-29 10:43:23'),(442,134,0,2,'删除场景',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','scene:del','admin','admin','2024-01-29 10:46:06','2024-01-29 10:46:06'),(443,134,0,2,'导出场景',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','scene:list','admin','admin','2024-01-29 10:46:40','2024-01-29 10:46:40'),(444,135,0,2,'新增模板',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','prompt:add','admin','admin','2024-01-16 10:46:37','2024-01-29 10:48:06'),(445,135,0,2,'修改模板',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','prompt:edit','admin','admin','2024-01-29 10:47:47','2024-01-29 10:47:47'),(446,135,0,2,'删除模板',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','prompt:del','admin','admin','2024-01-29 10:48:55','2024-01-29 10:48:55'),(447,135,0,2,'导出模板',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','prompt:list','admin','admin','2024-01-29 10:49:26','2024-01-29 10:49:26'),(448,143,0,2,'新增引导',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','promptQuestion:add','admin','admin','2024-01-29 10:50:14','2024-01-29 10:50:14'),(449,143,0,2,'修改引导',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','promptQuestion:edit','admin','admin','2024-01-29 10:50:38','2024-01-29 10:50:38'),(450,143,0,2,'删除引导',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','promptQuestion:del','admin','admin','2024-01-29 10:51:05','2024-01-29 10:51:05'),(451,143,0,2,'导出引导',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','promptQuestion:list','admin','admin','2024-01-29 10:52:58','2024-01-29 10:52:58'),(452,123,0,2,'新增质检',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','contentCheck:add','admin','admin','2024-01-29 10:27:52','2024-01-29 10:27:52'),(453,123,0,2,'编辑质检',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','contentCheck:edit','admin','admin','2024-01-29 10:28:30','2024-01-29 10:28:30'),(454,123,0,2,'删除质检',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','contentCheck:del','admin','admin','2024-01-29 10:31:19','2024-01-29 10:31:19'),(455,123,0,2,'导出质检',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','contentCheck:list','admin','admin','2024-01-29 10:40:12','2024-01-29 10:40:12'),(456,124,0,2,'删除问答',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','chatHistory:del','admin','admin','2024-01-29 10:33:03','2024-01-29 10:33:03'),(457,124,0,2,'导出问答',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','chatHistory:list','admin','admin','2024-01-29 10:41:48','2024-01-29 10:41:48'),(458,124,0,2,'修改历史',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','chatHistory:edit','admin','admin','2024-01-31 09:46:09','2024-01-31 09:46:09'),(459,137,0,2,'新增',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','openClient:add','test','test','2024-03-13 14:28:49','2024-03-13 14:28:49'),(460,137,0,2,'修改',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','openClient:edit','test','test','2024-03-13 14:29:49','2024-03-13 14:29:49'),(461,137,0,2,'删除渠道',NULL,NULL,999,NULL,NULL,_binary '\0',_binary '\0',_binary '\0','openClient:del','admin','admin','2024-03-13 14:50:46','2024-03-13 14:50:46');

INSERT INTO `sys_roles_menus` VALUES (1,1),(2,1),(3,1),(5,1),(6,1),(7,1),(9,1),(28,1),(32,1),(35,1),(37,1),(39,1),(41,1),(80,1),(118,1),(119,1),(120,1),(121,1),(122,1),(123,1),(124,1),(125,1),(126,1),(128,1),(130,1),(131,1),(133,1),(134,1),(135,1),(136,1),(137,1),(139,1),(140,1),(143,1),(188,1),(189,1),(190,1),(191,1),(192,1),(193,1),(194,1),(195,1),(196,1),(197,1),(198,1),(199,1),(200,1),(201,1),(206,1),(210,1),(211,1),(212,1),(220,1),(221,1),(222,1),(225,1),(229,1),(230,1),(236,1),(237,1),(238,1),(239,1),(240,1),(244,1),(245,1),(246,1),(248,1),(249,1),(254,1),(262,1),(267,1),(268,1),(273,1),(274,1),(275,1),(281,1);


INSERT INTO `sys_role` (`role_id`, `name`, `level`, `description`, `data_scope`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES
(1, '超级管理员', 2, '所有权限的超级管理员', '全部', NULL, 'admin', '2018-11-23 11:04:37', '2024-08-30 10:58:00');


INSERT INTO `sys_user` (`user_id`, `dept_id`, `username`, `nick_name`, `gender`, `phone`, `email`, `avatar_name`, `avatar_path`, `password`, `is_admin`, `enabled`, `create_by`, `update_by`, `pwd_reset_time`, `create_time`, `update_time`) VALUES
(1, 2, 'admin', '管理员', '男', '18888888888', '201507802@qq.com', NULL, NULL, '$2a$10$iTydKaW9h1GHaz1mCZWZ7e4ZJZDHkBPLUl3vMmDVWoC8XziaGk8y.', b'1', b'1', NULL, 'admin', '2024-01-30 15:05:59', '2018-08-23 09:11:56', '2024-07-02 16:52:10');

INSERT INTO `sys_users_jobs` (`user_id`, `job_id`) VALUES
(1, 11);

INSERT INTO `sys_users_roles` (`user_id`, `role_id`) VALUES
(1, 1);
COMMIT;

/*!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 */;