| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132 |
- /*
- 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;
|