数据库脚本 #5
李寻欢
commented
Owner
```sql
/*
Navicat Premium Data Transfer
Source Server : 开发库[wechat]
Source Server Type : MySQL
Source Server Version : 80026 (8.0.26)
Source Host : 10.0.0.31:3307
Source Schema : wechat
Target Server Type : MySQL
Target Server Version : 80026 (8.0.26)
File Encoding : 65001
Date: 29/01/2024 08:33:20
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_friend
-- ----------------------------
DROP TABLE IF EXISTS `t_friend`;
CREATE TABLE `t_friend` (
`wxid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '微信Id',
`nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '昵称',
`pinyin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '简拼',
`pinyin_all` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '全拼',
`custom_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '微信号',
`is_ok` tinyint(1) NULL DEFAULT 1 COMMENT '是否在通讯录',
`enable_ai` tinyint(1) NULL DEFAULT 0 COMMENT '是否启用AI',
`ai_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'AI模型',
`prompt` varchar(999) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '提示词',
`enable_chat_rank` tinyint(1) NULL DEFAULT 0 COMMENT '是否启用水群排行榜',
`enable_summary` tinyint(1) DEFAULT '0' COMMENT '是否启用聊天记录总结',
`enable_welcome` tinyint(1) NULL DEFAULT 0 COMMENT '是否启用迎新',
`enable_command` tinyint(1) NULL DEFAULT 0 COMMENT '是否启用指令',
`last_active` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后活跃时间',
PRIMARY KEY (`wxid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_group_user
-- ----------------------------
DROP TABLE IF EXISTS `t_group_user`;
CREATE TABLE `t_group_user` (
`group_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '微信群Id',
`wxid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '微信id',
`account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '微信号',
`nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '昵称',
`head_image` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '头像',
`is_member` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否群成员0否1是',
`join_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '加入时间',
`last_active` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后活跃时间',
`leave_time` datetime NULL DEFAULT NULL COMMENT '退群时间',
`skip_chat_rank` tinyint(1) NULL DEFAULT 0 COMMENT '是否跳过水群排行榜',
`is_admin` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否管理员',
PRIMARY KEY (`group_id`, `wxid`) USING BTREE,
INDEX `idx_one`(`group_id` ASC, `wxid` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_message
-- ----------------------------
DROP TABLE IF EXISTS `t_message`;
CREATE TABLE `t_message` (
`msg_id` bigint NOT NULL COMMENT '消息Id',
`create_time` bigint NOT NULL COMMENT '创建时间',
`create_at` datetime NULL DEFAULT NULL,
`from_user` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '发送人或群id',
`group_user` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '群成员id',
`type` int NOT NULL COMMENT '消息类型',
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',
`to_user` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '接收者',
`display_full_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '显示的完整内容',
`raw` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '原始通知字符串',
PRIMARY KEY (`msg_id`) USING BTREE,
INDEX `idx_msg_from_user`(`from_user` ASC) USING BTREE,
INDEX `idx_msg_group_user`(`group_user` ASC) USING BTREE,
INDEX `idx_msg_type`(`type` ASC) USING BTREE,
INDEX `idx_created_at`(`create_at` DESC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for t_plugin_data
-- ----------------------------
DROP TABLE IF EXISTS `t_plugin_data`;
CREATE TABLE `t_plugin_data` (
`user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '微信Id',
`plugin_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '插件代码',
`data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '插件数据',
PRIMARY KEY (`user_id`, `plugin_code`) USING BTREE,
UNIQUE INDEX `idx_pd_onlyone`(`user_id` ASC, `plugin_code` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
```
李寻欢
pinned this
李寻欢
locked as Resolved and limited conversation to collaborators
李寻欢
added the question
label
Labels
No Label
bug
duplicate
enhancement
help wanted
invalid
question
wontfix
No Milestone
No project
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: lxh/go-wxhelper#5
Loading…
Reference in New Issue
No description provided.
Delete Branch "%!s(<nil>)"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?