代码拉取完成，页面将自动刷新
同步操作将从 BBBUG/BBBUG GO API 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
/*
Navicat Premium Data Transfer
Source Server : mysql
Source Server Type : MySQL
Source Server Version : 80020
Source Host : localhost:3306
Source Schema : test
Target Server Type : MySQL
Target Server Version : 80020
File Encoding : 65001
Date: 02/04/2022 17:58:19
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for sa_access
-- ----------------------------
DROP TABLE IF EXISTS `sa_access`;
CREATE TABLE `sa_access` (
`access_id` int(0) NOT NULL AUTO_INCREMENT,
`access_user` int(0) NOT NULL DEFAULT 0 COMMENT '用户ID',
`access_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'AccessToken',
`access_plat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'all' COMMENT '登录平台',
`access_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'IP',
`access_status` int(0) NOT NULL DEFAULT 0 COMMENT '状态',
`access_createtime` int(0) NOT NULL DEFAULT 0 COMMENT '创建时间',
`access_updatetime` int(0) NOT NULL DEFAULT 0 COMMENT '修改时间',
PRIMARY KEY (`access_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '授权信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sa_access
-- ----------------------------
INSERT INTO `sa_access` VALUES (1, 2, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJQbGF0IjoicGMiLCJVc2VySWQiOjIsIlVzZXJOYW1lIjoiNjI2NjA0NzY5QHFxLmNvbSIsImV4cCI6MTY0ODY5Njc2NywiaWF0IjoxNjQ4NTIzOTY3fQ.SIRzwwmEzcn3XufNs8JJNf6-tnU8SGpHHoQuvfmebws', 'pc', '::1', 0, 1648523967, 1648523967);
INSERT INTO `sa_access` VALUES (2, 2, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJQbGF0IjoicGMiLCJVc2VySWQiOjIsIlVzZXJOYW1lIjoiNjI2NjA0NzY5QHFxLmNvbSIsImV4cCI6MTY0ODY5Njg1OCwiaWF0IjoxNjQ4NTI0MDU4fQ.QejypUWpZ6bR1Z9emmEem3C6DKLI1zwvXeeuXlRBwCE', 'pc', '::1', 0, 1648524058, 1648524058);
INSERT INTO `sa_access` VALUES (3, 2, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJQbGF0IjoicGMiLCJVc2VySWQiOjIsIlVzZXJOYW1lIjoiNjI2NjA0NzY5QHFxLmNvbSIsImV4cCI6MTY0ODY5NzA3OSwiaWF0IjoxNjQ4NTI0Mjc5fQ.FKZ8CYasriXdBu9cTFElIRFzi3tQTjeoYZuCfT6ezK0', 'pc', '::1', 0, 1648524279, 1648524279);
INSERT INTO `sa_access` VALUES (4, 2, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJQbGF0IjoicGMiLCJVc2VySWQiOjIsIlVzZXJOYW1lIjoiNjI2NjA0NzY5QHFxLmNvbSIsImV4cCI6MTY0ODY5NzE0MCwiaWF0IjoxNjQ4NTI0MzQwfQ.LhpdkH1nIw_QqQIr0FUnvy2-B0dcKFTcOjrvtMTK2E8', 'pc', '::1', 0, 1648524340, 1648524340);
INSERT INTO `sa_access` VALUES (5, 2, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJQbGF0IjoicGMiLCJVc2VySWQiOjIsIlVzZXJOYW1lIjoiNjI2NjA0NzY5QHFxLmNvbSIsImV4cCI6MTY0ODc5MjA3MywiaWF0IjoxNjQ4NjE5MjczfQ.xRUo_2UUZkFH3QIk5TVbQOV8sPJuCDWqugdk0PJx_xs', 'pc', '::1', 0, 1648619273, 1648619273);
INSERT INTO `sa_access` VALUES (6, 2, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJQbGF0IjoicGMiLCJVc2VySWQiOjIsIlVzZXJOYW1lIjoiNjI2NjA0NzY5QHFxLmNvbSIsImV4cCI6MTY0ODc5MjI3MiwiaWF0IjoxNjQ4NjE5NDcyfQ.0s_1b1Tgyn6KB2r_Jix_jHyRCpPC1gjK4l4VV3PrJ_U', 'pc', '::1', 0, 1648619472, 1648619472);
INSERT INTO `sa_access` VALUES (7, 200, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJQbGF0IjoicGMiLCJVc2VySWQiOjIwMCwiVXNlck5hbWUiOiI2MjY2MDQ3NjlAcXEuY29tIiwiZXhwIjoxNjQ4ODA5MjU5LCJpYXQiOjE2NDg2MzY0NTl9.dGAwfSZLOH02MP70FFVDbIXWQvjuqnSy07WsRXMRD7E', 'pc', '::1', 0, 1648636459, 1648636459);
INSERT INTO `sa_access` VALUES (8, 200, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJQbGF0IjoicGMiLCJVc2VySWQiOjIwMCwiVXNlck5hbWUiOiI2MjY2MDQ3NjlAcXEuY29tIiwiZXhwIjoxNjQ5MDQzMDMxLCJpYXQiOjE2NDg4NzAyMzF9.XdOyh6ML1gRJ4hUKLTYT9zJzaPRWYHdrKDZX6LAXfUI', 'pc', '::1', 0, 1648870231, 1648870231);
-- ----------------------------
-- Table structure for sa_app
-- ----------------------------
DROP TABLE IF EXISTS `sa_app`;
CREATE TABLE `sa_app` (
`app_id` int(0) NOT NULL AUTO_INCREMENT,
`app_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'key',
`app_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'name',
`app_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'url',
`app_user` int(0) NOT NULL DEFAULT 0 COMMENT 'user',
`app_scope` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'scope',
`app_status` int(0) NOT NULL DEFAULT 0 COMMENT '状态',
`app_createtime` int(0) NOT NULL DEFAULT 0 COMMENT '创建时间',
`app_updatetime` int(0) NOT NULL DEFAULT 0 COMMENT '修改时间',
PRIMARY KEY (`app_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '应用表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sa_app
-- ----------------------------
INSERT INTO `sa_app` VALUES (1, '请重置后对接', 'BBBUG', 'https://bbbug.com', 1, '', 0, 0, 0);
INSERT INTO `sa_app` VALUES (1001, '请重置后对接', 'Gitee', 'https://gitee.com/#extra#', 1, '', 0, 0, 0);
INSERT INTO `sa_app` VALUES (1002, '请重置后对接', 'OSChina', 'https://my.oschina.net/#extra#', 1, '', 0, 0, 0);
INSERT INTO `sa_app` VALUES (1003, '请重置后对接', 'QQ', 'https://hamm.cn', 1, '', 0, 0, 0);
INSERT INTO `sa_app` VALUES (1004, '请重置后对接', '钉钉', 'https://hamm.cn', 1, '', 0, 0, 0);
INSERT INTO `sa_app` VALUES (1005, '请重置后对接', '微信小程序', 'https://hamm.cn', 1, '', 0, 0, 0);
-- ----------------------------
-- Table structure for sa_attach
-- ----------------------------
DROP TABLE IF EXISTS `sa_attach`;
CREATE TABLE `sa_attach` (
`attach_id` int(0) NOT NULL AUTO_INCREMENT,
`attach_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '路径',
`attach_used` int(0) NOT NULL DEFAULT 0,
`attach_thumb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
`attach_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '类型',
`attach_sha` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
`attach_size` int(0) NOT NULL DEFAULT 0 COMMENT '大小',
`attach_user` int(0) NOT NULL DEFAULT 0 COMMENT '用户',
`attach_status` int(0) NOT NULL DEFAULT 0 COMMENT '状态',
`attach_createtime` int(0) NOT NULL DEFAULT 0 COMMENT '创建时间',
`attach_updatetime` int(0) NOT NULL DEFAULT 0 COMMENT '修改时间',
PRIMARY KEY (`attach_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '附件表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sa_attach
-- ----------------------------
INSERT INTO `sa_attach` VALUES (1, '', 0, 'uploads/thumb/image/89386380c834351cd716ef0652a1a24d.png', 'png', '89386380c834351cd716ef0652a1a24d', 0, 0, 0, 1648611218, 1648611218);
INSERT INTO `sa_attach` VALUES (2, '75cabffb5ad0061352ed05eca0fbe1d8.png', 0, 'uploads/thumb/image/75cabffb5ad0061352ed05eca0fbe1d8.png', 'png', '75cabffb5ad0061352ed05eca0fbe1d8', 10977, 0, 0, 1648611303, 1648611303);
INSERT INTO `sa_attach` VALUES (3, '', 0, 'uploads/thumb/image/75cabffb5ad0061352ed05eca0fbe1d8.png', 'png', '75cabffb5ad0061352ed05eca0fbe1d8', 0, 0, 0, 1648611412, 1648611412);
INSERT INTO `sa_attach` VALUES (4, '75cabffb5ad0061352ed05eca0fbe1d8.png', 0, 'uploads/thumb/image/75cabffb5ad0061352ed05eca0fbe1d8.png', 'png', '75cabffb5ad0061352ed05eca0fbe1d8', 10977, 0, 0, 1648611549, 1648611549);
INSERT INTO `sa_attach` VALUES (5, '75cabffb5ad0061352ed05eca0fbe1d8.png', 0, 'uploads/thumb/image/75cabffb5ad0061352ed05eca0fbe1d8.png', 'png', '75cabffb5ad0061352ed05eca0fbe1d8', 10977, 2, 0, 1648619529, 1648619529);
INSERT INTO `sa_attach` VALUES (6, '75cabffb5ad0061352ed05eca0fbe1d8.png', 0, 'uploads/thumb/image/75cabffb5ad0061352ed05eca0fbe1d8.png', 'png', '75cabffb5ad0061352ed05eca0fbe1d8', 10977, 2, 0, 1648619633, 1648619633);
INSERT INTO `sa_attach` VALUES (7, '75cabffb5ad0061352ed05eca0fbe1d8.png', 0, 'uploads/thumb/image/75cabffb5ad0061352ed05eca0fbe1d8.png', 'png', '75cabffb5ad0061352ed05eca0fbe1d8', 10977, 2, 0, 1648619844, 1648619844);
INSERT INTO `sa_attach` VALUES (8, '75cabffb5ad0061352ed05eca0fbe1d8.png', 0, '', 'png', '', 66628, 2, 0, 1648620223, 1648620223);
INSERT INTO `sa_attach` VALUES (9, '75cabffb5ad0061352ed05eca0fbe1d8.png', 0, 'uploads/thumb/image/head/75cabffb5ad0061352ed05eca0fbe1d8.png', 'png', '75cabffb5ad0061352ed05eca0fbe1d8', 66628, 2, 0, 1648620306, 1648620306);
INSERT INTO `sa_attach` VALUES (10, '75cabffb5ad0061352ed05eca0fbe1d8.png', 0, 'uploads/thumb/image/head/75cabffb5ad0061352ed05eca0fbe1d8.png', 'png', '75cabffb5ad0061352ed05eca0fbe1d8', 66628, 2, 0, 1648627404, 1648627404);
-- ----------------------------
-- Table structure for sa_conf
-- ----------------------------
DROP TABLE IF EXISTS `sa_conf`;
CREATE TABLE `sa_conf` (
`conf_id` int(0) NOT NULL AUTO_INCREMENT,
`conf_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '参数名',
`conf_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '参数值',
`conf_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '参数描述',
`conf_int` int(0) NOT NULL DEFAULT 0 COMMENT '参数到期',
`conf_status` int(0) NOT NULL DEFAULT 0,
`conf_createtime` int(0) NOT NULL DEFAULT 0,
`conf_updatetime` int(0) NOT NULL DEFAULT 0,
PRIMARY KEY (`conf_id`) USING BTREE,
INDEX `conf_key`(`conf_key`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '配置表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sa_conf
-- ----------------------------
INSERT INTO `sa_conf` VALUES (11, 'weapp_appid', '', '小程序APPID', 0, 0, 0, 0);
INSERT INTO `sa_conf` VALUES (12, 'weapp_appkey', '', '小程序SECRET', 0, 0, 0, 0);
INSERT INTO `sa_conf` VALUES (39, 'upload_max_file', '2097152', '最大文件上传限制', 0, 0, 0, 0);
INSERT INTO `sa_conf` VALUES (40, 'upload_file_type', 'jpg,png,gif,jpeg,bmp,txt,pdf,mp3,mp4,amr,m4a,xls,xlsx,ppt,pptx,doc,docx', '允许文件上传类型', 0, 0, 0, 0);
INSERT INTO `sa_conf` VALUES (41, 'upload_max_image', '2097152', '最大图片上传限制', 0, 0, 0, 0);
INSERT INTO `sa_conf` VALUES (42, 'upload_image_type', 'jpg,png,gif,jpeg,bmp', '允许上传图片类型', 0, 0, 0, 0);
INSERT INTO `sa_conf` VALUES (47, 'default_group', '5', '注册默认用户组', 0, 0, 0, 1598539052);
INSERT INTO `sa_conf` VALUES (48, 'email_account', 'admin@mail.bbbug.com', '邮箱账号', 0, 0, 0, 1598539052);
INSERT INTO `sa_conf` VALUES (49, 'email_password', '123456', '邮箱密码', 0, 0, 0, 1598539052);
INSERT INTO `sa_conf` VALUES (50, 'email_host', 'smtp.exmail.qq.com', '邮箱服务器', 0, 0, 0, 1598539052);
INSERT INTO `sa_conf` VALUES (51, 'email_remark', 'BBBUG TEAM', '邮箱签名', 0, 0, 0, 1598539052);
INSERT INTO `sa_conf` VALUES (52, 'email_port', '465', '邮箱端口号', 0, 0, 0, 1598539052);
INSERT INTO `sa_conf` VALUES (53, 'websocket_http', 'http://127.0.0.1:10012/', 'WebsocketHTTP请求地址', 0, 0, 0, 1598539052);
INSERT INTO `sa_conf` VALUES (54, 'websocket_token', 'wss_bbbug_com', 'Websocket验证串', 0, 0, 0, 1598539052);
INSERT INTO `sa_conf` VALUES (55, 'api_guest_token', '45af3cfe44942c956e026d5fd58f0feffbd3a237', '临时用户access_token', 0, 0, 0, 1598539052);
INSERT INTO `sa_conf` VALUES (56, 'frontend_url', '', '前端地址', 0, 0, 0, 0);
INSERT INTO `sa_conf` VALUES (57, 'api_url', '', 'API地址', 0, 0, 0, 0);
INSERT INTO `sa_conf` VALUES (58, 'tencent_ai_appid', '', '腾讯AI的APPID', 0, 0, 0, 1598539052);
INSERT INTO `sa_conf` VALUES (59, 'tencent_ai_appkey', '', '腾讯AI的APPKEY', 0, 0, 0, 1598539052);
INSERT INTO `sa_conf` VALUES (60, 'static_url', '', 'Static文件地址', 0, 0, 0, 0);
-- ----------------------------
-- Table structure for sa_keywords
-- ----------------------------
DROP TABLE IF EXISTS `sa_keywords`;
CREATE TABLE `sa_keywords` (
`keywords_id` int(0) NOT NULL AUTO_INCREMENT,
`keywords_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '原串',
`keywords_target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '替换',
`keywords_all` int(0) NOT NULL DEFAULT 0 COMMENT '全替换',
`keywords_status` int(0) NOT NULL DEFAULT 0 COMMENT '状态',
`keywords_createtime` int(0) NOT NULL DEFAULT 0 COMMENT '创建时间',
`keywords_updatetime` int(0) NOT NULL DEFAULT 0 COMMENT '修改时间',
PRIMARY KEY (`keywords_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '关键词表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sa_keywords
-- ----------------------------
INSERT INTO `sa_keywords` VALUES (3, '<script>', '我傻乎乎的想试试能不能XSS，结果被系统拦截了。。。', 1, 0, 1592574791, 1592575266);
-- ----------------------------
-- Table structure for sa_message
-- ----------------------------
DROP TABLE IF EXISTS `sa_message`;
CREATE TABLE `sa_message` (
`message_id` bigint(0) NOT NULL AUTO_INCREMENT,
`message_user` int(0) NOT NULL DEFAULT 0 COMMENT 'user',
`message_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'type',
`message_where` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
`message_to` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
`message_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT 'content',
`message_status` int(0) NOT NULL DEFAULT 0 COMMENT '状态',
`message_createtime` int(0) NOT NULL DEFAULT 0 COMMENT '创建时间',
`message_updatetime` int(0) NOT NULL DEFAULT 0 COMMENT '修改时间',
PRIMARY KEY (`message_id`) USING BTREE,
INDEX `message_user`(`message_user`) USING BTREE,
INDEX `message_createtime`(`message_createtime`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '消息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sa_room
-- ----------------------------
DROP TABLE IF EXISTS `sa_room`;
CREATE TABLE `sa_room` (
`room_id` int(0) NOT NULL AUTO_INCREMENT,
`room_user` int(0) NOT NULL DEFAULT 0 COMMENT '所有者ID',
`room_addsongcd` int(0) NOT NULL DEFAULT 60 COMMENT '点歌CD',
`room_addcount` int(0) NOT NULL DEFAULT 5 COMMENT '点歌数量',
`room_pushdaycount` int(0) NOT NULL DEFAULT 5 COMMENT '顶歌日限额',
`room_pushsongcd` int(0) NOT NULL DEFAULT 3600 COMMENT '顶歌CD',
`room_online` int(0) NOT NULL DEFAULT 0 COMMENT '已登录在线',
`room_realonline` int(0) NOT NULL DEFAULT 0 COMMENT '所有在线',
`room_hide` int(0) NOT NULL DEFAULT 0 COMMENT '是否从列表隐藏',
`room_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '房间名称',
`room_type` int(0) NOT NULL DEFAULT 1 COMMENT '房间类型',
`room_public` int(0) NOT NULL DEFAULT 0,
`room_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '房间密码',
`room_notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '进入房间提醒',
`room_addsong` int(0) NOT NULL DEFAULT 0,
`room_sendmsg` int(0) NOT NULL DEFAULT 0,
`room_robot` int(0) NOT NULL DEFAULT 0,
`room_order` int(0) NOT NULL DEFAULT 0,
`room_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
`room_playone` int(0) NOT NULL DEFAULT 0 COMMENT '0随机1单曲',
`room_votepass` int(0) NOT NULL DEFAULT 1,
`room_votepercent` int(0) NOT NULL DEFAULT 30,
`room_background` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '房间背景图',
`room_app` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '插件地址',
`room_fullpage` int(0) NOT NULL DEFAULT 0 COMMENT '插件是否全屏',
`room_status` int(0) NOT NULL DEFAULT 0 COMMENT '状态',
`room_createtime` int(0) NOT NULL DEFAULT 0 COMMENT '创建时间',
`room_updatetime` int(0) NOT NULL DEFAULT 0 COMMENT '修改时间',
PRIMARY KEY (`room_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1889 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '房间表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sa_room
-- ----------------------------
INSERT INTO `sa_room` VALUES (888, 1, 60, 5, 5, 3600, 1, 2, 0, 'BBBUG音乐大厅', 1, 0, '', '大厅为电台播放模式，欢迎大家点歌，房间已支持自定义点歌/顶歌等CD和数量，快去房间管理页面看看吧~', 0, 0, 0, 10000000, '', 0, 1, 30, '', '', 0, 0, 1598539777, 1648883680);
INSERT INTO `sa_room` VALUES (1888, 200, 60, 5, 5, 3600, 1, 2, 0, 'BBBUG音乐大厅', 1, 0, '1111', '大厅为电台播放模式，欢迎大家点歌，房间已支持自定义点歌/顶歌等CD和数量，快去房间管理页面看看吧~', 0, 0, 0, 10000000, '', 0, 1, 30, '', '', 0, 0, 1598539777, 1648888144);
-- ----------------------------
-- Table structure for sa_song
-- ----------------------------
DROP TABLE IF EXISTS `sa_song`;
CREATE TABLE `sa_song` (
`song_id` int(0) NOT NULL AUTO_INCREMENT,
`song_user` int(0) NOT NULL DEFAULT 0,
`song_mid` bigint(0) NOT NULL DEFAULT 0,
`song_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '歌曲名称',
`song_singer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '歌手',
`song_pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
`song_length` int(0) NOT NULL DEFAULT 0,
`song_play` int(0) NOT NULL DEFAULT 1 COMMENT '被点次数',
`song_week` int(0) NOT NULL DEFAULT 0 COMMENT '本周被点次数',
`song_fav` int(0) NOT NULL DEFAULT 0 COMMENT '0点歌 1收藏',
`song_status` int(0) NOT NULL DEFAULT 0 COMMENT '状态',
`song_createtime` int(0) NOT NULL DEFAULT 0 COMMENT '创建时间',
`song_updatetime` int(0) NOT NULL DEFAULT 0 COMMENT '修改时间',
PRIMARY KEY (`song_id`) USING BTREE,
INDEX `song_mid`(`song_mid`) USING BTREE,
INDEX `song_user`(`song_user`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '歌曲表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for sa_user
-- ----------------------------
DROP TABLE IF EXISTS `sa_user`;
CREATE TABLE `sa_user` (
`user_id` int(0) NOT NULL AUTO_INCREMENT COMMENT 'UID',
`user_icon` int(0) NOT NULL DEFAULT 0,
`user_sex` int(0) NOT NULL DEFAULT 0,
`user_account` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '帐号',
`user_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
`user_salt` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '密码盐',
`user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户昵称',
`user_head` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'new/images/nohead.jpg',
`user_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '每个人都应该有签名,但偏偏我没有.',
`user_group` int(0) NOT NULL DEFAULT 0 COMMENT '用户组',
`user_ipreg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '注册IP',
`user_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
`user_extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
`user_app` int(0) NOT NULL DEFAULT 1,
`user_device` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
`user_touchtip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
`user_vip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
`user_status` int(0) NOT NULL DEFAULT 0 COMMENT '1被禁用',
`user_createtime` int(0) NOT NULL DEFAULT 0 COMMENT '创建时间',
`user_updatetime` int(0) NOT NULL DEFAULT 0 COMMENT '修改时间',
PRIMARY KEY (`user_id`) USING BTREE,
UNIQUE INDEX `admin_account`(`user_account`) USING BTREE,
INDEX `admin_group`(`user_group`) USING BTREE,
INDEX `admin_name`(`user_name`) USING BTREE,
INDEX `admin_password`(`user_password`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 301 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sa_user
-- ----------------------------
INSERT INTO `sa_user` VALUES (1, 1, 0, 'admin@bbbug.com', 'f1bd0923a2b09c1a1674780d1318a177', 'zXZy', '%E6%9C%BA%E5%99%A8%E4%BA%BA', 'new/images/nohead.jpg', '别@我,我只是个测试号', 1, '127.0.0.1', '', '', 1, 'iPhone', '%EF%BC%8C%E6%9C%BA%E5%99%A8%E4%BA%BA%E5%B7%AE%E7%82%B9%E7%88%BD%E7%BF%BB%E5%A4%A9%E3%80%82', '', 0, 0, 1605004436);
INSERT INTO `sa_user` VALUES (200, 0, 1, '626604769@qq.com', '814f0f4863f42145ba86912a63a7f23c', 'CquV', 'Hammaa', 'http://localhost:8080/uploads/thumb/image/75cabffb5ad0061352ed05eca0fbe1d8.png', '欢迎来BBBUG聊天听歌划水呀~', 0, '::1', '', '', 0, 'pc', '帅气的脸庞', '', 0, 1648523967, 1648619443);
INSERT INTO `sa_user` VALUES (300, 0, 1, '6266@qq.com', '814f0f4863f42145ba86912a63a7f23c', 'CquV', '12312321', 'http://localhost:8080/uploads/thumb/image/75cabffb5ad0061352ed05eca0fbe1d8.png', '欢迎来BBBUG聊天听歌划水呀~', 0, '::1', '', '', 0, 'pc', '帅气的脸庞', '', 0, 1648523967, 1648619443);
-- ----------------------------
-- Table structure for sa_weapp
-- ----------------------------
DROP TABLE IF EXISTS `sa_weapp`;
CREATE TABLE `sa_weapp` (
`weapp_id` int(0) NOT NULL AUTO_INCREMENT,
`weapp_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'OPENID',
`weapp_status` int(0) NOT NULL DEFAULT 0 COMMENT '状态',
`weapp_createtime` int(0) NOT NULL DEFAULT 0 COMMENT '创建时间',
`weapp_updatetime` int(0) NOT NULL DEFAULT 0 COMMENT '修改时间',
PRIMARY KEY (`weapp_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '小程序用户表' ROW_FORMAT = Compact;
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手