-
Notifications
You must be signed in to change notification settings - Fork 19
/
movie.sql
107 lines (96 loc) · 4.15 KB
/
movie.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 50719
Source Host : localhost:3306
Source Schema : movie
Target Server Type : MySQL
Target Server Version : 50719
File Encoding : 65001
Date: 04/06/2018 23:09:18
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for movie
-- ----------------------------
DROP TABLE IF EXISTS `movie`;
CREATE TABLE `movie` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`ima_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`movie_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of movie
-- ----------------------------
INSERT INTO `movie` VALUES (1, '1526711273653046.jpg', '哥谭 第四季 Gotham');
INSERT INTO `movie` VALUES (2, '1526726844323744.jpg', '游戏之夜');
INSERT INTO `movie` VALUES (3, '1526727108393284.jpg', '环太平洋:雷霆再起');
INSERT INTO `movie` VALUES (4, '1526727155977248.jpg', '头号玩家');
INSERT INTO `movie` VALUES (5, '1527405023383089.jpg', '良种动物');
INSERT INTO `movie` VALUES (7, '1527405918883501.jpg', '悲惨世界');
INSERT INTO `movie` VALUES (8, '1527410387608938.jpg', '猛龙怪客');
INSERT INTO `movie` VALUES (9, '1527410913000043.jpg', '绿野仙踪');
INSERT INTO `movie` VALUES (10, '1527414992530668.jpg', '苍穹浩瀚');
INSERT INTO `movie` VALUES (11, '1527415066008906.jpg', '犯罪现场调查');
INSERT INTO `movie` VALUES (12, '1527415725066605.jpg', '西部世界');
-- ----------------------------
-- Table structure for rate
-- ----------------------------
DROP TABLE IF EXISTS `rate`;
CREATE TABLE `rate` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`movie_id` bigint(20) NOT NULL,
`rate` double NOT NULL,
`user_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 34 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;
-- ----------------------------
-- Records of rate
-- ----------------------------
INSERT INTO `rate` VALUES (1, 1, 2.5, 1000);
INSERT INTO `rate` VALUES (2, 2, 3.5, 1000);
INSERT INTO `rate` VALUES (3, 3, 4.5, 1000);
INSERT INTO `rate` VALUES (4, 4, 3, 1000);
INSERT INTO `rate` VALUES (5, 5, 2.5, 1000);
INSERT INTO `rate` VALUES (12, 1, 2, 1003);
INSERT INTO `rate` VALUES (13, 2, 3, 1003);
INSERT INTO `rate` VALUES (14, 3, 3, 1003);
INSERT INTO `rate` VALUES (15, 4, 3, 1003);
INSERT INTO `rate` VALUES (16, 5, 3, 1003);
INSERT INTO `rate` VALUES (17, 7, 3, 1003);
INSERT INTO `rate` VALUES (18, 8, 3.5, 1003);
INSERT INTO `rate` VALUES (19, 9, 2, 1003);
INSERT INTO `rate` VALUES (20, 10, 2.5, 1003);
INSERT INTO `rate` VALUES (21, 11, 2.5, 1003);
INSERT INTO `rate` VALUES (22, 12, 3, 1003);
INSERT INTO `rate` VALUES (23, 1, 3.5, 1004);
INSERT INTO `rate` VALUES (24, 2, 3.5, 1004);
INSERT INTO `rate` VALUES (25, 3, 4, 1004);
INSERT INTO `rate` VALUES (26, 4, 5, 1004);
INSERT INTO `rate` VALUES (27, 5, 4, 1004);
INSERT INTO `rate` VALUES (28, 8, 3.5, 1004);
INSERT INTO `rate` VALUES (29, 9, 3.5, 1004);
INSERT INTO `rate` VALUES (30, 7, 2, 1004);
INSERT INTO `rate` VALUES (31, 10, 3.5, 1004);
INSERT INTO `rate` VALUES (32, 11, 3.5, 1004);
INSERT INTO `rate` VALUES (33, 12, 3, 1004);
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`user_name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1005 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1003, '12345', 'yang1');
INSERT INTO `user` VALUES (1004, '12345', 'aaa');
INSERT INTO `user` VALUES (1000, '12345', 'yang');
SET FOREIGN_KEY_CHECKS = 1;