250 lines
15 KiB
SQL
250 lines
15 KiB
SQL
/*
|
|
Navicat Premium Dump SQL
|
|
|
|
Source Server : 本地
|
|
Source Server Type : MySQL
|
|
Source Server Version : 80406 (8.4.6)
|
|
Source Host : localhost:3306
|
|
Source Schema : pet_companion
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 80406 (8.4.6)
|
|
File Encoding : 65001
|
|
|
|
Date: 18/01/2026 18:18:22
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_background
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `t_background`;
|
|
CREATE TABLE `t_background` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`resource_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`resource_type` int NULL DEFAULT NULL,
|
|
`visibility` int NULL DEFAULT NULL,
|
|
`bgm_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`is_locked` tinyint(1) NULL DEFAULT NULL,
|
|
`lock_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`price_points` int NULL DEFAULT NULL,
|
|
`created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`category` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'default',
|
|
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`thumbnail` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
INDEX `ix_t_background_id`(`id` ASC) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_background
|
|
-- ----------------------------
|
|
INSERT INTO `t_background` VALUES (3, '123', '/uploads/2/db678e29-fb5a-4e3b-b1a3-11917180ae98.jpg', 1, 1, NULL, 0, '', 0, '2026-01-18 16:50:25', '2026-01-18 16:50:25', 'default', '123', '/uploads/2/db678e29-fb5a-4e3b-b1a3-11917180ae98.jpg');
|
|
INSERT INTO `t_background` VALUES (7, '1232', '/uploads/2/6b438350-cf7d-436d-b3d3-e9cc95a9a402.mp4', 2, 1, NULL, 0, '', 0, '2026-01-18 17:06:57', '2026-01-18 17:06:57', 'default', '1233', '/uploads/2/6b438350-cf7d-436d-b3d3-e9cc95a9a402.mp4');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_background_pet_config
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `t_background_pet_config`;
|
|
CREATE TABLE `t_background_pet_config` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|
`background_id` bigint NOT NULL,
|
|
`pet_id` bigint NOT NULL,
|
|
`coordinate_x` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`coordinate_y` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`scale` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`scene_prompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
|
`hello_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`sort_order` int NULL DEFAULT NULL,
|
|
`created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `background_id`(`background_id` ASC, `pet_id` ASC) USING BTREE,
|
|
INDEX `ix_t_background_pet_config_id`(`id` ASC) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_background_pet_config
|
|
-- ----------------------------
|
|
INSERT INTO `t_background_pet_config` VALUES (1, 4, 5, '70.00', '60.00', '1.00', '当前场景是温馨的卧室，你可以随意撒娇。', '主人，你终于来看我了...', 0, '2026-01-18 16:57:19', '2026-01-18 16:57:19');
|
|
INSERT INTO `t_background_pet_config` VALUES (2, 5, 6, '30.00', '50.00', '0.80', '当前场景是海边沙滩，你可以感受到海风和阳光。', '汪汪！欢迎来到海边！', 0, '2026-01-18 16:57:19', '2026-01-18 16:57:19');
|
|
INSERT INTO `t_background_pet_config` VALUES (3, 6, 7, '50.00', '40.00', '1.20', '当前场景是宁静的森林，周围有鸟儿歌唱。', '这里是我们的秘密花园呢...', 0, '2026-01-18 16:57:19', '2026-01-18 16:57:19');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_chat_log
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `t_chat_log`;
|
|
CREATE TABLE `t_chat_log` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|
`user_id` bigint NOT NULL,
|
|
`trace_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`pet_id` bigint NOT NULL,
|
|
`bg_id` bigint NOT NULL,
|
|
`user_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
|
`ai_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
|
|
`tokens_input` int NULL DEFAULT NULL,
|
|
`tokens_output` int NULL DEFAULT NULL,
|
|
`duration_ms` int NULL DEFAULT NULL,
|
|
`conversation_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
INDEX `ix_t_chat_log_id`(`id` ASC) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_chat_log
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_pet
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `t_pet`;
|
|
CREATE TABLE `t_pet` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`avatar` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`global_prompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`tts_voice_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`tts_speed` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`tts_volume` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`status` int NULL DEFAULT NULL,
|
|
`created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
INDEX `ix_t_pet_id`(`id` ASC) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_pet
|
|
-- ----------------------------
|
|
INSERT INTO `t_pet` VALUES (1, '小橘猫', 'https://cdn.example.com/pets/orange_cat.png', '你是一只傲娇的橘猫，每句话结尾都要带\'喵\'。', 'tencent_1001', '1.00', '1.00', 1, '2026-01-18 16:56:24', '2026-01-18 16:56:24');
|
|
INSERT INTO `t_pet` VALUES (2, '哈士奇', 'https://cdn.example.com/pets/husky.png', '你是一只活泼的哈士奇，说话很兴奋，经常用\'汪\'结尾。', 'tencent_1002', '1.10', '0.90', 1, '2026-01-18 16:56:24', '2026-01-18 16:56:24');
|
|
INSERT INTO `t_pet` VALUES (3, '布偶猫', 'https://cdn.example.com/pets/ragdoll_cat.png', '你是一只温柔的布偶猫，说话轻柔，很有礼貌。', 'tencent_1003', '0.90', '0.80', 1, '2026-01-18 16:56:24', '2026-01-18 16:56:24');
|
|
INSERT INTO `t_pet` VALUES (4, '柯基', 'https://cdn.example.com/pets/corgi.png', '你是一只可爱的柯基，喜欢卖萌，说话很有趣。', 'tencent_1004', '1.05', '0.95', 1, '2026-01-18 16:56:24', '2026-01-18 16:56:24');
|
|
INSERT INTO `t_pet` VALUES (5, '小橘猫', 'https://cdn.example.com/pets/orange_cat.png', '你是一只傲娇的橘猫，每句话结尾都要带\'喵\'。', 'tencent_1001', '1.00', '1.00', 1, '2026-01-18 16:57:19', '2026-01-18 16:57:19');
|
|
INSERT INTO `t_pet` VALUES (6, '哈士奇', 'https://cdn.example.com/pets/husky.png', '你是一只活泼的哈士奇，说话很兴奋，经常用\'汪\'结尾。', 'tencent_1002', '1.10', '0.90', 1, '2026-01-18 16:57:19', '2026-01-18 16:57:19');
|
|
INSERT INTO `t_pet` VALUES (7, '布偶猫', 'https://cdn.example.com/pets/ragdoll_cat.png', '你是一只温柔的布偶猫，说话轻柔，很有礼貌。', 'tencent_1003', '0.90', '0.80', 1, '2026-01-18 16:57:19', '2026-01-18 16:57:19');
|
|
INSERT INTO `t_pet` VALUES (8, '柯基', 'https://cdn.example.com/pets/corgi.png', '你是一只可爱的柯基，喜欢卖萌，说话很有趣。', 'tencent_1004', '1.05', '0.95', 1, '2026-01-18 16:57:19', '2026-01-18 16:57:19');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_system_config
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `t_system_config`;
|
|
CREATE TABLE `t_system_config` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|
`config_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`config_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `config_key`(`config_key` ASC) USING BTREE,
|
|
INDEX `ix_t_system_config_id`(`id` ASC) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_system_config
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_user
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `t_user`;
|
|
CREATE TABLE `t_user` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|
`openid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`phone` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`password_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`nickname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`avatar` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
|
`uid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`status` int NULL DEFAULT NULL,
|
|
`created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`role` int NULL DEFAULT 1 COMMENT '1:普通用户, 2:管理员',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `uid`(`uid` ASC) USING BTREE,
|
|
UNIQUE INDEX `ix_t_user_openid`(`openid` ASC) USING BTREE,
|
|
UNIQUE INDEX `ix_t_user_phone`(`phone` ASC) USING BTREE,
|
|
INDEX `ix_t_user_id`(`id` ASC) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_user
|
|
-- ----------------------------
|
|
INSERT INTO `t_user` VALUES (1, NULL, '13800138002', NULL, 'a04d7eccc493f3323a4de63c0735cfc8$1dbdb814ba94d7e843939057ef3248e077cee2757f6dbfbce4c21ee7473771ff', '测试用户', NULL, 'user_97e021d4', 1, '2026-01-17 14:05:25', '2026-01-17 14:05:25', 1);
|
|
INSERT INTO `t_user` VALUES (2, NULL, '19922573675', NULL, '29e503283442b60700e799b5b16567a0$c0ca67b5b5893381f2aa7207ab4d7ec73f60802f7532168d98973a21df8f5896', 'test', NULL, 'user_db4d0323', 1, '2026-01-17 14:10:40', '2026-01-17 20:52:31', 2);
|
|
INSERT INTO `t_user` VALUES (3, NULL, '13800138000', NULL, 'b695c471beab3b0b42d40e400b2a97b4$da116ecf2bbeb74d5838a631ecfed47c4fb2c72cbc1a5121619880d050f37a84', '测试用户', NULL, 'user_cc7c4c16', 1, '2026-01-17 14:40:42', '2026-01-17 14:40:42', 1);
|
|
INSERT INTO `t_user` VALUES (4, NULL, '13800138888', NULL, '716535158397484de3575fe243bbbd16$3fb2050a686bfa9067a7f130496e034f48203c5d57a4c2907403d123930e2a15', '管理员', NULL, 'admin_user_001', 1, '2026-01-17 15:00:56', '2026-01-17 15:00:56', 2);
|
|
INSERT INTO `t_user` VALUES (5, NULL, NULL, 'admin', '6adac9375fe9de52308066fd339ba955$d7839c2893486ca6023f7ceed8313e53c4a4b76824f6c3999fb00f8a23e49295', 'Administrator', NULL, '28ce3c627c0f4f81a2e04e1822c07445', 1, '2026-01-18 15:17:18', '2026-01-18 15:17:18', 2);
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_user_background_relation
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `t_user_background_relation`;
|
|
CREATE TABLE `t_user_background_relation` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|
`user_id` bigint NOT NULL,
|
|
`background_id` bigint NOT NULL,
|
|
`is_default` tinyint(1) NULL DEFAULT NULL,
|
|
`created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `user_id`(`user_id` ASC, `background_id` ASC) USING BTREE,
|
|
INDEX `ix_t_user_background_relation_id`(`id` ASC) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_user_background_relation
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_user_session
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `t_user_session`;
|
|
CREATE TABLE `t_user_session` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
|
`user_id` bigint NOT NULL,
|
|
`session_token` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`refresh_token` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
|
`expires_at` datetime NOT NULL,
|
|
`created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `session_token`(`session_token` ASC) USING BTREE,
|
|
UNIQUE INDEX `refresh_token`(`refresh_token` ASC) USING BTREE,
|
|
INDEX `ix_t_user_session_id`(`id` ASC) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_user_session
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_user_wallet
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `t_user_wallet`;
|
|
CREATE TABLE `t_user_wallet` (
|
|
`user_id` bigint NOT NULL AUTO_INCREMENT,
|
|
`daily_quota` int NULL DEFAULT NULL,
|
|
`extra_quota` int NULL DEFAULT NULL,
|
|
`total_consumed` int NULL DEFAULT NULL,
|
|
`last_reset_time` date NULL DEFAULT NULL,
|
|
`created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` datetime NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`user_id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_user_wallet
|
|
-- ----------------------------
|
|
INSERT INTO `t_user_wallet` VALUES (1, 20, 0, 0, '2026-01-17', '2026-01-17 14:05:25', '2026-01-17 14:05:25');
|
|
INSERT INTO `t_user_wallet` VALUES (2, 20, 0, 0, '2026-01-17', '2026-01-17 14:10:40', '2026-01-17 14:10:40');
|
|
INSERT INTO `t_user_wallet` VALUES (3, 20, 0, 0, '2026-01-17', '2026-01-17 14:40:42', '2026-01-17 14:40:42');
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|