弹幕视频网站源码与数据库.zip

/* Navicat Premium Data Transfer Source Server : local Source Server Type : MySQL Source Server Version : 80029 Source Host : localhost:3306 Source Schema : ymzting Target Server Type : MySQL Target Server Version : 80029 File Encoding : 65001 Date: 07/05/2023 17:36:14 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for comment -- ---------------------------- DROP TABLE IF EXISTS `comment`; CREATE TABLE `comment` ( `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `isuse` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of comment -- ---------------------------- INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕！！！！！！！！！！', '0.00', '#000000', '0'); INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕1', '0.00', '#B42020', '0'); INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕2', '0.00', '#52C827', '0'); INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕3', '0.00', '#8311A0', '0'); INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '0.00', '#DD1919', '0'); INSERT INTO `comment` VALUES ('dog', 'ymzting', '', '0.00', '#000000', '0'); INSERT INTO `comment` VALUES ('dog', 'ymzting', '有时间的弹幕', '8.712107', '#000000', '0'); INSERT INTO `comment` VALUES ('dog', 'ymzting', '发送弹幕', '4.633285', '#000000', '0'); INSERT INTO `comment` VALUES ('dog', 'ymzting', '1111', '12.672615', '#000000', '0'); INSERT INTO `comment` VALUES ('dog', 'ymzting', 'wwww', '14.069479', '#9A1919', '0'); INSERT INTO `comment` VALUES ('dog', 'ymzting', '测试弹幕', '1.76306', '#000000', '0'); INSERT INTO `comment` VALUES ('dog', 'ymzting', 'websocket', '2.344148', '#000000', '0'); INSERT INTO `comment` VALUES ('dog', 'ymzting', '111', '3.385441', '#000000', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '弹幕', '5.381284', '#000000', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '弹幕', '13.613529', '#000000', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '11111', '2.407239', '#000000', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '11111', '5.256298', '#000000', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '1111', '2.059521', '#000000', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '11112222', '8.389185', '#000000', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '测试', '2.234286', '#000000', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '', '0', '#000000', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '33333', '3.96462', '#782D2D', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '3254524', '2.795794', '#000000', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '0.83545', '#000000', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '7.72843', '#000000', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '10.960832', '#000000', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '13.756024', '#000000', '0'); INSERT INTO `comment` VALUES ('build', 'ymzting', '啦啦啦啦啦啦啦啦啦', '15.708912', '#000000', '0'); INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '8.765993', '#000000', '0'); INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '2.432202', '#C50B0B', '0'); INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '6.952991', '#4429AF', '0'); INSERT INTO `comment` VALUES ('cat', 'ymzting', '猫猫', '8.168342', '#000000', '0'); INSERT INTO `comment` VALUES ('grass', 'ymzting', '1111', '2.505749', '#000000', '0'); INSERT INTO `comment` VALUES ('grass', 'ymzting', '1111', '0', '#000000', '0'); INSERT INTO `comment` VALUES ('grass', 'ymzting', 'wwww', '4.389952', '#000000', '0'); INSERT INTO `comment` VALUES ('grass', 'ymzting', '测试能完结了吗', '3.683333', '#000000', '0'); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(0) NOT NULL AUTO_INCREMENT, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for video -- ---------------------------- DROP TABLE IF EXISTS `video`; CREATE TABLE `video` ( `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of video -- ---------------------------- INSERT INTO `video` VALUES ('猫咪', 'cat', '宠物，猫，动物，可爱'); INSERT INTO `video` VALUES ('狗狗', 'dog', '宠物，狗，动物，汪汪'); INSERT INTO `video` VALUES ('大楼', 'build', '大楼，城市，建筑，景色'); INSERT INTO `video` VALUES ('草地', 'grass', '自然，景色，草原，绿色'); INSERT INTO `video` VALUES ('大鹅', 'goose', '动物，家畜，散养，凶猛'); INSERT INTO `video` VALUES ('人', 'people', '人类，摄影，美景'); INSERT INTO `video` VALUES ('很多车', 'manycar', '汽车，城市，生活'); INSERT INTO `video` VALUES ('汽车', 'car', '汽车，奢侈'); SET FOREIGN_KEY_CHECKS = 1;