/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : localhost:3306
 Source Schema         : chat_sys_backup

 Target Server Type    : MySQL
 Target Server Version : 50734
 File Encoding         : 65001

 Date: 10/10/2023 11:11:23
*/


SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for chat_config
-- ----------------------------
DROP TABLE IF EXISTS `chat_config`;
CREATE TABLE `chat_config`  (
  `column` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '键',
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '值',
  `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_config
-- ----------------------------
INSERT INTO `chat_config` VALUES ('title', 'MAGICPPAI', '网站标题');
INSERT INTO `chat_config` VALUES ('keyword', '关键字', '网站关键字');
INSERT INTO `chat_config` VALUES ('description', '描述', '网站描述');
INSERT INTO `chat_config` VALUES ('quota_image_day', '100', '系统每个用户每天图像限制条数 -1不设置');
INSERT INTO `chat_config` VALUES ('quota_image_month', '1000', '系统每个用户每月图像限制条数 -1不设置');
INSERT INTO `chat_config` VALUES ('quota_image_year', '10000', '系统每个用户每年图像限制条数 -1不设置');
INSERT INTO `chat_config` VALUES ('pay', '1', '付费使用 0禁用 1开启');
INSERT INTO `chat_config` VALUES ('visit_mode', '1', '访客模式 0禁用 1开启');
INSERT INTO `chat_config` VALUES ('quota_text_day', '-1', '系统每个用户每天文本限制条数 -1不设置');
INSERT INTO `chat_config` VALUES ('quota_text_month', '-1', '系统每个用户每月文本限制条数 -1不设置');
INSERT INTO `chat_config` VALUES ('quota_text_year', '-1', '系统每个用户每年文本限制条数 -1不设置');
INSERT INTO `chat_config` VALUES ('version', '1.0.1', '程序版本号');
INSERT INTO `chat_config` VALUES ('server_ip', '192.168.3.48', '服务器ip “,”分割多个');
INSERT INTO `chat_config` VALUES ('domain', '192.168.3.48', '域名 “,”分割多个');
INSERT INTO `chat_config` VALUES ('mail_username', 'varywei@qq.com', '邮箱账号');
INSERT INTO `chat_config` VALUES ('mail_password', 'cqzgteqapufqdifc', '邮箱密码');
INSERT INTO `chat_config` VALUES ('mail_host', 'smtp.qq.com', '发送邮件服务器地址');
INSERT INTO `chat_config` VALUES ('mail_port', '465', '端口号');
INSERT INTO `chat_config` VALUES ('gpt_base_url', 'http://144.202.1.215', 'GPT请求根路径，默认为官方，可以填写代理路径');

-- ----------------------------
-- Table structure for chat_member
-- ----------------------------
DROP TABLE IF EXISTS `chat_member`;
CREATE TABLE `chat_member`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '会员id',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '会员名',
  `price` double(11, 2) NULL DEFAULT NULL COMMENT '价格',
  `quota_text` int(11) NULL DEFAULT NULL COMMENT '文本额度',
  `quota_image` int(11) NULL DEFAULT NULL COMMENT '图像额度',
  `duration` int(11) NULL DEFAULT NULL COMMENT '时长，以秒为单位',
  `active_number` int(11) NULL DEFAULT NULL COMMENT '允许激活次数',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '添加时间',
  `is_deleted` int(11) NULL DEFAULT 0 COMMENT '软删除',
  `deleted_admin_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '删除操作的管理员id',
  `deleted_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_member
-- ----------------------------
INSERT INTO `chat_member` VALUES (1, '试用会员', 0.99, 50, 5, 86400, NULL, 1690515181, 0, NULL, NULL);
INSERT INTO `chat_member` VALUES (2, '月会员', 9.90, 1000, 100, 2678400, NULL, 1690515181, 0, NULL, NULL);

-- ----------------------------
-- Table structure for chat_message_token
-- ----------------------------
DROP TABLE IF EXISTS `chat_message_token`;
CREATE TABLE `chat_message_token`  (
  `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'json内容',
  `user_id` bigint(30) NULL DEFAULT NULL COMMENT '用户id',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_message_token
-- ----------------------------

-- ----------------------------
-- Table structure for chat_model
-- ----------------------------
DROP TABLE IF EXISTS `chat_model`;
CREATE TABLE `chat_model`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '模型id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '模型名称（公开）',
  `model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '实际模型名',
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '归属 openai baidu ......',
  `sort` int(11) NULL DEFAULT 100 COMMENT '排序 值越大越靠前',
  `available` int(1) NULL DEFAULT 0 COMMENT '是否可用 0可用 1禁用',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_model
-- ----------------------------
INSERT INTO `chat_model` VALUES (1, 'gpt3.5', 'gpt-3.5-turbo', 'openai', NULL, 0, NULL);
INSERT INTO `chat_model` VALUES (2, 'ernie', 'ERNIE-Bot', 'baidu', NULL, 0, NULL);
INSERT INTO `chat_model` VALUES (3, 'OpenAI 绘图', NULL, 'openai', NULL, 0, NULL);

-- ----------------------------
-- Table structure for chat_order
-- ----------------------------
DROP TABLE IF EXISTS `chat_order`;
CREATE TABLE `chat_order`  (
  `id` bigint(30) NOT NULL COMMENT '会员开通订单',
  `order_no` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号',
  `member_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '会员名',
  `member_id` int(11) NULL DEFAULT NULL COMMENT '会员id',
  `money` double(11, 2) NULL DEFAULT 0.00 COMMENT '会员费用',
  `number` int(11) NULL DEFAULT 1 COMMENT '开通数量',
  `user_id` bigint(30) NULL DEFAULT NULL COMMENT '用户id',
  `pay_status` tinyint(1) NULL DEFAULT 0 COMMENT '支付状态 0=未完成 1=已完成',
  `pay_type_id` int(2) NULL DEFAULT 0 COMMENT '支付方式 支付列表id',
  `pay_type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '支付方式名称',
  `pay_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '支付地址',
  `pay_done_time` int(11) NULL DEFAULT NULL COMMENT '订单支付完成时间',
  `member_active_time` int(11) NULL DEFAULT NULL COMMENT '会员激活时间',
  `member_expire_time` int(11) NULL DEFAULT NULL COMMENT '会员过期时间',
  `member_duration` int(11) NULL DEFAULT NULL COMMENT '会员时长',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '创建时间',
  `expire_time` int(11) NULL DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_order
-- ----------------------------
INSERT INTO `chat_order` VALUES (1686329004449746946, '202308011852197950', '月会员', 2, 9.90, 1, 1659396218578637649, 1, 2, NULL, 'https%3A%2F%2Fds.alipay.com%2F%3Ffrom%3Dpc%26appId%3D20000116%26actionType%3DtoAccount%26goBack%3DNO%26amount%3D9.9%26userId%3D2088722555958394%26memo%3D202308011852197950', 1690887170, 1690887170, 1693565570, 2678400, 1690887139, 1690887439);
INSERT INTO `chat_order` VALUES (1686334150932115458, '202308011912468027', '月会员', 2, 9.90, 1, 1659396218578637649, 1, 2, NULL, 'https%3A%2F%2Fds.alipay.com%2F%3Ffrom%3Dpc%26appId%3D20000116%26actionType%3DtoAccount%26goBack%3DNO%26amount%3D9.9%26userId%3D2088722555958394%26memo%3D202308011912468027', 1690889418, 1690889418, 1693567818, 2678400, 1690888366, 1690888666);
INSERT INTO `chat_order` VALUES (1686336165091422209, '202308011920470250', '月会员', 2, 9.90, 1, 1659396218578637649, 1, 2, NULL, 'https%3A%2F%2Fds.alipay.com%2F%3Ffrom%3Dpc%26appId%3D20000116%26actionType%3DtoAccount%26goBack%3DNO%26amount%3D9.9%26userId%3D2088722555958394%26memo%3D202308011920470250', 1690888886, 1690888886, 1693567286, 2678400, 1690888847, 1690889147);
INSERT INTO `chat_order` VALUES (1691349759789002753, '202308151523011494', '试用会员', 1, 0.99, 1, 1659396218578637649, 0, 0, NULL, NULL, NULL, NULL, NULL, 86400, 1692084181, 1692084481);
INSERT INTO `chat_order` VALUES (1691357372144578561, '202308151553160762', '试用会员', 1, 0.99, 1, 1659396218578637649, 0, 0, NULL, NULL, NULL, NULL, NULL, 86400, 1692085996, 1692086296);
INSERT INTO `chat_order` VALUES (1691364148424351745, '202308151620116554', '试用会员', 1, 0.99, 1, 1659396218578637649, 0, 0, NULL, NULL, NULL, NULL, NULL, 86400, 1692087611, 1692087911);
INSERT INTO `chat_order` VALUES (1691365580359737346, '202308151625530683', '试用会员', 1, 0.99, 1, 1659396218578637649, 0, 0, NULL, 'https://qr.alipay.com/bax09602sbwah4bpyoxz2577', NULL, NULL, NULL, 86400, 1692087953, 1692088253);
INSERT INTO `chat_order` VALUES (1691366802370207745, '202308151630444172', '试用会员', 1, 0.99, 1, 1659396218578637649, 0, 0, NULL, 'https%3A%2F%2Fqr.alipay.com%2Fbax02378vvitfwmwlkak250a', NULL, NULL, NULL, 86400, 1692088244, 1692088544);
INSERT INTO `chat_order` VALUES (1691366802370207790, '202308151905473318', '试用会员', 1, 0.99, 1, 1659396218578637649, 1, 1, '支付宝', 'https%3A%2F%2Fqr.alipay.com%2Fbax02220ng8gsf14nfit3034', 1692099976, 1692099976, 1692186376, 86400, 1692089569, 1692089869);

-- ----------------------------
-- Table structure for chat_pay_type
-- ----------------------------
DROP TABLE IF EXISTS `chat_pay_type`;
CREATE TABLE `chat_pay_type`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  `pay_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付地址',
  `pay_identifier` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付标识',
  `app_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商户ID',
  `public_key` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公钥',
  `private_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '私钥',
  `available` int(1) NULL DEFAULT NULL COMMENT '可用状态 0可用 1禁用',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_pay_type
-- ----------------------------
INSERT INTO `chat_pay_type` VALUES (1, '支付宝', 'https://openapi.alipay.com/gateway.do', 'alif2f', '', '', 'MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQCE7dC6RaL9JqDVhtzb2H82iGI7RGPqeUEv4/SVQ5NE75qf1tISvlFeJ9eR2nr4KSxtWa62aLg6Zof/y5kYTbffB7e0DZ/CmK7ScdZjcuzlZ/CxjTdwJ45FiLSYRGal7vfvpBiqQdrCm0DcugqQovCAVkb4shllBADxSbhsD6LEg2/KweaFsz3ij0lKduMQ0p53e50ZoHqM2T2RurDb1ieI6q02DVYEzxbYog0lMxA/pKXGiwvIuyFeFz/lrOgIolPjH8eEMsL/0MIUPhM8mliCJ+DxeXHr6o0xL9f/kH1R2KKmsXe7tdGIMy9a68tbw9g3Srx6JNPaC+MDo5EU3h8bAgMBAAECggEAHUpt6O25SYD+ha6O8h6VgYWx549dWOhZFd1sIoveYp1NfBUQ+zJWqaGr3aa/2/juojXVyrnuhmfbZeEOHg3aC1oe/5zU7ENKmnKdJBLJ4o7xuZ39bkg5EFdcPAUufTfYCEUnbjTOqH0fYMPZ2h8dUZoxT1GnSNwF/SUaby1O13AxnER/ANsV6VQ2VYCa7RjMxb/FiHzKs6Z4hoffB+FcWJIOjjU4zZqhUP7S4tl0lgX2Hk5ko1MqpcTdCfZI+j5AAod61sm8RKH92q5A5EToECM0AtVVX2G1CroB7qXYYAD+ZTd+/LBZVAgDhfpYaI8RDJgMs3rmq60XkEtClMVksQKBgQC8Yrch9xMrw+P+tvFtUXd5REIj6uHc11zGdkIFByjtrDLYiueEm6EYqroJiys8/S+wLAuZbhOhJ+hvx+irSDNSkwx7p8Ren7BtmQZ693S+f+qC5M9X4SRHRJk1pVpiUFMS80l0BhqcKIVY0T+vViZZRWv4DH832riXGixOy8al2QKBgQC0o58j+hq2X6e77gCoOO9LciWUDXb1fJihfka9vWBEjY78G2svTDkpmaH1NoDglQDTR1kDz8g1TBWyX3nWPjj3wv4oquie8KJ5qUnci+HlJ21IGjhA2ioxxzxxlzcG41xtSdMMX/EmcMwtZtcpiCaSAfb+y4CXkrJYmQ7UYCxQEwKBgBPHhZTiXTfuJGUdDjI9KH8qBIvC4J4QWqRXzEy82LZDqz8DLpXExWBSpJ/V5d9MchJcPYeJgDQefZAm/C3nscPMvrXJApwwxhRrybtlefN6eMPvhDmk4Os+', 1, 1691746238, 1691746238);
INSERT INTO `chat_pay_type` VALUES (2, '码支付支付宝', 'https://www.mazfu.com', 'alicode', '', NULL, '', 1, 1691746238, 1691746238);

-- ----------------------------
-- Table structure for chat_quota
-- ----------------------------
DROP TABLE IF EXISTS `chat_quota`;
CREATE TABLE `chat_quota`  (
  `id` int(11) NOT NULL COMMENT '额度id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '额度名',
  `type` int(2) NULL DEFAULT NULL COMMENT '额度类型 1=文本 2=图像',
  `value` int(11) NULL DEFAULT NULL COMMENT '额度值',
  `money` int(11) NULL DEFAULT NULL COMMENT '额度费用',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) NULL DEFAULT NULL COMMENT '修改时间',
  `update_admin_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改 管理员id',
  `is_deleted` int(1) NULL DEFAULT NULL COMMENT '软删除',
  `deleted_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
  `deleted_admin_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '删除 管理员id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_quota
-- ----------------------------

-- ----------------------------
-- Table structure for chat_secret_key
-- ----------------------------
DROP TABLE IF EXISTS `chat_secret_key`;
CREATE TABLE `chat_secret_key`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `secret_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密钥',
  `tpm` int(11) NULL DEFAULT NULL COMMENT '每分钟速率',
  `usage` double(11, 4) NULL DEFAULT NULL COMMENT '可用额度',
  `balance` double(11, 4) NULL DEFAULT NULL COMMENT '总额度',
  `model_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应模型id 多个,分割',
  `comment` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `admin_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '管理员id',
  `available` int(11) NULL DEFAULT 1 COMMENT '可用1 不可用0',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_secret_key
-- ----------------------------
INSERT INTO `chat_secret_key` VALUES (1, '密钥', 3, NULL, 5.0000, '1', NULL, NULL, 0, NULL);

-- ----------------------------
-- Table structure for chat_secret_key_log
-- ----------------------------
DROP TABLE IF EXISTS `chat_secret_key_log`;
CREATE TABLE `chat_secret_key_log`  (
  `id` bigint(20) NOT NULL COMMENT 'secret使用日志',
  `secret_id` int(11) NULL DEFAULT NULL COMMENT 'secret id',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
  `window_id` bigint(20) NULL DEFAULT NULL COMMENT '窗口id',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_secret_key_log
-- ----------------------------

-- ----------------------------
-- Table structure for chat_system_key
-- ----------------------------
DROP TABLE IF EXISTS `chat_system_key`;
CREATE TABLE `chat_system_key`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指令标题',
  `prompt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '指令内容，发送给gpt',
  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'system/user角色',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_system_key
-- ----------------------------

-- ----------------------------
-- Table structure for chat_user
-- ----------------------------
DROP TABLE IF EXISTS `chat_user`;
CREATE TABLE `chat_user`  (
  `id` bigint(30) NOT NULL,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电子邮箱',
  `gender` int(1) NULL DEFAULT NULL COMMENT '性别 0=男 1=女',
  `telephone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像uri',
  `member_id` int(11) NULL DEFAULT NULL COMMENT '会员id',
  `member_create_time` int(11) NULL DEFAULT NULL COMMENT '会员开通时间',
  `member_expire_time` int(11) NULL DEFAULT NULL COMMENT '会员过期时间',
  `quota_text` int(11) NULL DEFAULT 0 COMMENT '文本额度',
  `quota_image` int(11) NULL DEFAULT 0 COMMENT '图像额度',
  `auto_cloud` int(1) NULL DEFAULT 0 COMMENT '自动同步云端 0启用 1禁用',
  `device_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '设备数据信息',
  `login_ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登录ip',
  `login_last_ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上次登录ip',
  `login_time` int(11) NULL DEFAULT NULL COMMENT '登录时间',
  `login_last_time` int(11) NULL DEFAULT NULL COMMENT '上次登录时间',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `is_deleted` int(1) NULL DEFAULT 0 COMMENT '软删除',
  `deleted_admin_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '删除操作的管理员id',
  `deleted_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_user
-- ----------------------------

-- ----------------------------
-- Table structure for chat_user_message
-- ----------------------------
DROP TABLE IF EXISTS `chat_user_message`;
CREATE TABLE `chat_user_message`  (
  `id` bigint(30) NOT NULL,
  `message` varchar(10000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '信息',
  `role` int(1) NOT NULL DEFAULT 1 COMMENT '角色 1=user 2=assistant 3=system',
  `user_id` bigint(30) NOT NULL COMMENT '用户id',
  `window_id` bigint(30) NOT NULL COMMENT '窗口id',
  `data` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关于gpt的其他信息',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '创建时间',
  `is_deleted` int(1) NULL DEFAULT 0 COMMENT '软删除',
  `deleted_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_user_message
-- ----------------------------

-- ----------------------------
-- Table structure for chat_user_uselog
-- ----------------------------
DROP TABLE IF EXISTS `chat_user_uselog`;
CREATE TABLE `chat_user_uselog`  (
  `id` bigint(30) NOT NULL AUTO_INCREMENT COMMENT '日志id',
  `user_id` bigint(30) NOT NULL COMMENT '用户id',
  `type` int(2) NULL DEFAULT NULL COMMENT '使用类型 1=文本 2=图像',
  `ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '使用的ip',
  `agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户代理',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_user_uselog
-- ----------------------------

-- ----------------------------
-- Table structure for chat_user_window
-- ----------------------------
DROP TABLE IF EXISTS `chat_user_window`;
CREATE TABLE `chat_user_window`  (
  `id` bigint(30) NOT NULL COMMENT '窗口id',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '窗口名',
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '窗口描述',
  `type` int(2) NULL DEFAULT 1 COMMENT '类型 1=文本 2=绘画',
  `system_key` int(2) NULL DEFAULT 0 COMMENT '系统指令id 0=未指定',
  `model_id` int(11) NULL DEFAULT 1 COMMENT '所使用的模型id',
  `user_id` bigint(30) NULL DEFAULT NULL COMMENT '用户id',
  `using_context` tinyint(1) NULL DEFAULT 1 COMMENT '承接上下文 1=true,0=false',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '创建时间',
  `deleted_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_user_window
-- ----------------------------

-- ----------------------------
-- Table structure for t_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `t_admin_log`;
CREATE TABLE `t_admin_log`  (
  `id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `create_time` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_admin_log
-- ----------------------------

-- ----------------------------
-- Table structure for t_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_permission`;
CREATE TABLE `t_permission`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `pid` int(11) NOT NULL DEFAULT 0 COMMENT '父编号,0为顶级',
  `permission` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '后端api权限字符串,menu例子：role:*，button例子：role:create,role:update,role:delete,role:view',
  `resource_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源类型，[menu|button]',
  `component` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组件路径 /src/views为根路径',
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'icon图标',
  `meta` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'json格式 其他属性',
  `weight` int(11) NULL DEFAULT NULL COMMENT '权重',
  `path` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源路径 如：/userinfo/list',
  `redirect` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '重定向',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由表name名',
  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限名称',
  `keep_alive` int(1) NULL DEFAULT NULL COMMENT '缓存0启用1禁用',
  `available` int(1) NULL DEFAULT 0 COMMENT '是否可用0可用 1不可用',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_permission
-- ----------------------------
INSERT INTO `t_permission` VALUES (1, 0, '', 'menu', '/dashboard/index.vue', 'gauge', NULL, 100, '/dashboard', NULL, 'dashboard', '控制台', 0, 0);
INSERT INTO `t_permission` VALUES (4, 0, '', 'menu_dir', '', 'users-rectangle', NULL, 99, '/permission', NULL, 'permission', '权限管理', 0, 0);
INSERT INTO `t_permission` VALUES (5, 4, '', 'menu', '/permission/role/role.vue', 'user-gear', NULL, 100, '/role', '', 'role', '角色组管理', 0, 0);
INSERT INTO `t_permission` VALUES (6, 4, '', 'menu', '/permission/menu/menu.vue', 'layer-group', NULL, 99, '/menu', NULL, 'menu', '菜单规则管理', 0, 0);
INSERT INTO `t_permission` VALUES (7, 5, 'role:create,role:retrieve', 'button', '/permission/role/add.vue', '', NULL, 3, '/add', NULL, 'roleAdd', '添加', 0, 0);
INSERT INTO `t_permission` VALUES (8, 6, 'menu:create', 'button', '/permission/menu/add.vue', '', NULL, 3, '/add', NULL, 'menuAdd', '添加', 0, 0);
INSERT INTO `t_permission` VALUES (9, 5, 'role:update,role:retrieve:id,role:retrieve', 'button', '/permission/role/edit.vue', '', NULL, 2, '/edit/:id', NULL, 'roleEdit', '编辑', 1, 0);
INSERT INTO `t_permission` VALUES (10, 6, 'menu:update,menu:retrieve:id', 'button', '/permission/menu/edit.vue', '', NULL, 2, '/edit/:id', NULL, 'menuEdit', '编辑', 1, 0);
INSERT INTO `t_permission` VALUES (14, 6, 'menu:delete', 'button', '', '', NULL, 1, '/del/:id', NULL, 'menuDel', '删除', 1, 0);
INSERT INTO `t_permission` VALUES (15, 5, 'role:delete', 'button', '', '', NULL, 1, '/del/:id', NULL, 'roleDel', '删除', 1, 0);
INSERT INTO `t_permission` VALUES (16, 6, 'menu:retrieve', 'button', '/permission/menu/menu.vue', '', NULL, 4, '/index', NULL, 'menuShow', '查看', 0, 0);
INSERT INTO `t_permission` VALUES (17, 5, 'role:retrieve', 'button', '/permission/role/role.vue', '', NULL, 4, '/index', NULL, 'roleShow', '查看', 0, 0);
INSERT INTO `t_permission` VALUES (18, 4, '', 'menu', '/permission/user/user.vue', 'users', NULL, 98, '/user', NULL, 'user', '用户管理', 0, 0);
INSERT INTO `t_permission` VALUES (19, 18, 'user:retrieve,role:retrieve', 'button', '', '', NULL, 4, '/index', NULL, 'userShow', '查看', 0, 0);
INSERT INTO `t_permission` VALUES (20, 18, 'user:create,role:retrieve', 'button', '/permission/user/add.vue', '', NULL, 3, '/add', NULL, 'userAdd', '添加', 0, 0);
INSERT INTO `t_permission` VALUES (21, 18, 'user:delete', 'button', '', '', NULL, 1, '/del/:id', NULL, 'userDel', '删除', 1, 0);
INSERT INTO `t_permission` VALUES (22, 18, 'user:update,user:retrieve:id,role:retrieve', 'button', '/permission/user/edit.vue', '', NULL, 2, '/edit/:id', NULL, 'userEdit', '编辑', 1, 0);
INSERT INTO `t_permission` VALUES (24, 0, '', 'menu', '/adminLog/index.vue', 'spider', NULL, 96, '/adminLog', NULL, 'adminLog', '操作日志', 0, 0);
INSERT INTO `t_permission` VALUES (25, 24, 'adminLog:retrieve', 'button', '/adminLog/index.vue', '', NULL, 4, '/index', NULL, 'adminLogShow', '查看', 0, 0);
INSERT INTO `t_permission` VALUES (27, 24, 'adminLog:delete', 'button', '', '', NULL, 1, '/del', NULL, 'adminLogDel', '清空日志', 1, 0);

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `pid` int(11) NULL DEFAULT NULL COMMENT '父id 0=根',
  `available` int(1) NULL DEFAULT 0 COMMENT '是否可用0可用 1不可用',
  `role` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色描述,UI界面显示使用',
  `create_time` int(11) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_role
-- ----------------------------
INSERT INTO `t_role` VALUES (1, 0, 0, '超级管理员', '权力最大的管理员，拥有一切权力', 1680861595);
INSERT INTO `t_role` VALUES (2, 1, 0, '一级管理员', 'Ceo desc...', 1680861596);
INSERT INTO `t_role` VALUES (3, 2, 1, '二级管理员', 'Cfo desc...', 1680861597);

-- ----------------------------
-- Table structure for t_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_role_permission`;
CREATE TABLE `t_role_permission`  (
  `role_id` int(11) NULL DEFAULT NULL COMMENT '角色id',
  `permission_id` int(11) NULL DEFAULT NULL COMMENT '权限id',
  INDEX `role_id`(`role_id`) USING BTREE,
  INDEX `permission_id`(`permission_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_role_permission
-- ----------------------------
INSERT INTO `t_role_permission` VALUES (1, 4);
INSERT INTO `t_role_permission` VALUES (1, 5);
INSERT INTO `t_role_permission` VALUES (1, 6);
INSERT INTO `t_role_permission` VALUES (2, 1);
INSERT INTO `t_role_permission` VALUES (1, 7);
INSERT INTO `t_role_permission` VALUES (1, 8);
INSERT INTO `t_role_permission` VALUES (1, 9);
INSERT INTO `t_role_permission` VALUES (1, 10);
INSERT INTO `t_role_permission` VALUES (1, 16);
INSERT INTO `t_role_permission` VALUES (1, 17);
INSERT INTO `t_role_permission` VALUES (2, 4);
INSERT INTO `t_role_permission` VALUES (1, 1);
INSERT INTO `t_role_permission` VALUES (1, 15);
INSERT INTO `t_role_permission` VALUES (1, 14);
INSERT INTO `t_role_permission` VALUES (2, 5);
INSERT INTO `t_role_permission` VALUES (2, 17);
INSERT INTO `t_role_permission` VALUES (2, 7);
INSERT INTO `t_role_permission` VALUES (2, 9);
INSERT INTO `t_role_permission` VALUES (2, 15);
INSERT INTO `t_role_permission` VALUES (1, 18);
INSERT INTO `t_role_permission` VALUES (1, 19);
INSERT INTO `t_role_permission` VALUES (1, 20);
INSERT INTO `t_role_permission` VALUES (1, 22);
INSERT INTO `t_role_permission` VALUES (1, 21);
INSERT INTO `t_role_permission` VALUES (3, 1);
INSERT INTO `t_role_permission` VALUES (1, 24);
INSERT INTO `t_role_permission` VALUES (1, 25);
INSERT INTO `t_role_permission` VALUES (1, 27);
INSERT INTO `t_role_permission` VALUES (2, 6);
INSERT INTO `t_role_permission` VALUES (2, 16);
INSERT INTO `t_role_permission` VALUES (2, 8);
INSERT INTO `t_role_permission` VALUES (2, 10);
INSERT INTO `t_role_permission` VALUES (2, 14);
INSERT INTO `t_role_permission` VALUES (2, 18);
INSERT INTO `t_role_permission` VALUES (2, 19);
INSERT INTO `t_role_permission` VALUES (2, 20);
INSERT INTO `t_role_permission` VALUES (2, 22);
INSERT INTO `t_role_permission` VALUES (2, 21);
INSERT INTO `t_role_permission` VALUES (3, 4);
INSERT INTO `t_role_permission` VALUES (3, 5);
INSERT INTO `t_role_permission` VALUES (3, 17);
INSERT INTO `t_role_permission` VALUES (3, 7);
INSERT INTO `t_role_permission` VALUES (3, 9);
INSERT INTO `t_role_permission` VALUES (3, 15);
INSERT INTO `t_role_permission` VALUES (3, 6);
INSERT INTO `t_role_permission` VALUES (3, 16);
INSERT INTO `t_role_permission` VALUES (3, 8);
INSERT INTO `t_role_permission` VALUES (3, 10);
INSERT INTO `t_role_permission` VALUES (3, 14);
INSERT INTO `t_role_permission` VALUES (3, 18);
INSERT INTO `t_role_permission` VALUES (3, 19);
INSERT INTO `t_role_permission` VALUES (3, 20);
INSERT INTO `t_role_permission` VALUES (3, 22);
INSERT INTO `t_role_permission` VALUES (3, 21);

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user`  (
  `id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id，雪花算法id\r\n',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
  `login_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录ip',
  `status` int(11) NOT NULL DEFAULT 0 COMMENT '状态 0|正常 1|封禁',
  `create_time` int(11) NULL DEFAULT NULL,
  `is_deleted` int(11) NULL DEFAULT 0 COMMENT '软删除',
  `deleted_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
  `deleted_user_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '删除操作的用户的id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1658747404616294402', 'admin', '96e79218965eb72c92a549dd5a330112', 'pick', '/2023/6/1686818393357.jpg', '127.0.0.1', 0, 1680861500, 0, NULL, NULL);
INSERT INTO `t_user` VALUES ('1658747428226031618', 'user', '96e79218965eb72c92a549dd5a330112', 'nick', '/2023/6/1686818416977.jpg', '127.0.0.1', 0, 1680861510, 0, NULL, NULL);
INSERT INTO `t_user` VALUES ('1659395730424516609', 'admin123', 'ae60c3dd88e6193a5d899ae0dbbf4559', '用户faeklfjlke', '/2023/6/1686818422425.jpg', NULL, 0, 1684465746, 0, NULL, NULL);
INSERT INTO `t_user` VALUES ('1659396218578587649', 'admin312', 'd064f3519426dcd30114b900431fc044', '', '/2023/5/1685276730394.jpg', NULL, 0, 1684465863, 1, 1685357053, '1658747404616294402');
INSERT INTO `t_user` VALUES ('1661995457018728450', 'test1/0', '7ac66c0f148de9519b8bd264312c4d64', 'afe', '/2023/6/1686915568956.jpg', NULL, 0, 1685085569, 0, 1685155820, '1658747404616294402');
INSERT INTO `t_user` VALUES ('1662000546936717314', 'faef12_ef1', '4297f44b13955235245b2497399d7a93', 'xiugai de nicheng', '', NULL, 0, 1685086783, 0, 1685155343, '1658747404616294402');
INSERT INTO `t_user` VALUES ('1662808548140859393', 'AFEIAJIA', '324d1907d9ca6733d399b87affe48c74', 'ANCD', '/2023/5/1685279364003.jpg', NULL, 0, 1685279426, 1, 1685357056, '1658747404616294402');
INSERT INTO `t_user` VALUES ('1700376709681631233', 'feafea', 'a1a28b48c75021dee923a9802137a491', '', '', NULL, 0, 1694236373, 0, NULL, NULL);

-- ----------------------------
-- Table structure for t_user_role
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role`  (
  `role_id` int(11) NULL DEFAULT NULL,
  `user_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
INSERT INTO `t_user_role` VALUES (1, '1658747404616294402');
INSERT INTO `t_user_role` VALUES (2, '1658747428226031618');
INSERT INTO `t_user_role` VALUES (2, '1659395730424516609');
INSERT INTO `t_user_role` VALUES (1, '1659396218578587649');
INSERT INTO `t_user_role` VALUES (2, '1661995457018728450');
INSERT INTO `t_user_role` VALUES (2, '1662808548140859393');
INSERT INTO `t_user_role` VALUES (3, '1662000546936717314');
INSERT INTO `t_user_role` VALUES (1, '1658747428226031618');

SET FOREIGN_KEY_CHECKS = 1;