/* Navicat Premium Data Transfer Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 50724 Source Host : localhost:3306 Source Schema : sk39 Target Server Type : MySQL Target Server Version : 50724 File Encoding : 65001 Date: 19/11/2019 14:03:43 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for image -- ---------------------------- DROP TABLE IF EXISTS `image`; CREATE TABLE `image` ( `id` int(11) NOT NULL COMMENT '图片ID', `uid` int(11) NOT NULL COMMENT '图片所属用户ID', `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '图片url', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of image -- ---------------------------- INSERT INTO `image` VALUES (1, 1, 'images/Sunset.jpg'); INSERT INTO `image` VALUES (2, 1, 'images/19185_en_1.jpg'); INSERT INTO `image` VALUES (3, 2, 'images/19201_en_1.jpg'); INSERT INTO `image` VALUES (4, 2, 'images/Blue hills.jpg'); INSERT INTO `image` VALUES (5, 3, 'images/19230_en_1.jpg'); INSERT INTO `image` VALUES (6, 3, 'images/19185_en_1.jpg'); INSERT INTO `image` VALUES (7, 4, 'images/Water lilies.jpg'); INSERT INTO `image` VALUES (8, 4, 'images/19542_en_1.jpg'); INSERT INTO `image` VALUES (9, 5, 'images/Winter.jpg'); INSERT INTO `image` VALUES (10, 5, 'images/19666_en_1.jpg'); INSERT INTO `image` VALUES (11, 2, 'images/19889_en_1.jpg'); -- ---------------------------- -- Table structure for setting -- ---------------------------- DROP TABLE IF EXISTS `setting`; CREATE TABLE `setting` ( `id` int(11) NOT NULL COMMENT '设置ID', `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '键', `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '值', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of setting -- ---------------------------- INSERT INTO `setting` VALUES (1, 'GROUP_NAME', '小组名称'); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) NOT NULL COMMENT '用户ID', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名', `class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '班级', `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系方式', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES (1, '张三', '17卫星维修G5-2', '13012345678'); INSERT INTO `user` VALUES (2, '李四', '16航母制造G5', '13987654321'); INSERT INTO `user` VALUES (3, '王五', '18飞机维修G3', '13579135791'); INSERT INTO `user` VALUES (4, '李华', '16航母制造G5', '12345678901'); INSERT INTO `user` VALUES (5, '小明', '17卫星维修G5-1', '13987654321'); -- ---------------------------- -- Table structure for video -- ---------------------------- DROP TABLE IF EXISTS `video`; CREATE TABLE `video` ( `id` int(11) NOT NULL COMMENT '视频ID', `uid` int(11) NOT NULL COMMENT '视频所属用户ID', `video` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '视频URL', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of video -- ---------------------------- INSERT INTO `video` VALUES (1, 1, 'videos/mov_bbb.mp4'); INSERT INTO `video` VALUES (2, 1, 'videos/movie.mp4'); INSERT INTO `video` VALUES (3, 2, 'videos/movie.mp4'); INSERT INTO `video` VALUES (4, 2, 'videos/mov_bbb.mp4'); INSERT INTO `video` VALUES (5, 3, 'videos/movie.mp4'); INSERT INTO `video` VALUES (6, 3, 'videos/mov_bbb.mp4'); INSERT INTO `video` VALUES (7, 4, 'videos/mov_bbb.mp4'); INSERT INTO `video` VALUES (8, 4, 'videos/movie.mp4'); INSERT INTO `video` VALUES (9, 5, 'videos/mov_bbb.mp4'); INSERT INTO `video` VALUES (10, 5, 'videos/movie.mp4'); -- ---------------------------- -- Procedure structure for get_all -- ---------------------------- DROP PROCEDURE IF EXISTS `get_all`; delimiter ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `get_all`() BEGIN #Routine body goes here... # 获取setting表 SELECT `key`,`value` FROM setting; # 获取用户表 SELECT * FROM user; # 获取图片 SELECT * FROM image; # 获取视频 SELECT * FROM video; END ;; delimiter ; SET FOREIGN_KEY_CHECKS = 1;