摘要：/*Navicat MySQL Data TransferSource Server : ouyangkeSource Server Version : 50553Source Host : 127.0.0.1:3306Source Database&n
/*
Navicat MySQL Data Transfer
Source Server : ouyangke
Source Server Version : 50553
Source Host : 127.0.0.1:3306
Source Database : ouyangke
Target Server Type : MYSQL
Target Server Version : 50553
File Encoding : 65001
Date: 2018-07-26 10:45:32
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
`email` varchar(50) NOT NULL COMMENT '账号',
`psword` varchar(32) NOT NULL COMMENT '密码',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理员表';
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin@ouyangke.com', '123456');
-- ----------------------------
-- Table structure for director
-- ----------------------------
DROP TABLE IF EXISTS `director`;
CREATE TABLE `director` (
`tid` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(50) NOT NULL COMMENT '姓名',
`phone` varchar(20) NOT NULL COMMENT '手机号',
`country` varchar(20) NOT NULL COMMENT '国家',
`add_time` int(11) unsigned NOT NULL COMMENT '添加时间',
PRIMARY KEY (`tid`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='导演表';
-- ----------------------------
-- Records of director
-- ----------------------------
INSERT INTO `director` VALUES ('1', '一本道', '15577774444', '日本', '1531103719');
INSERT INTO `director` VALUES ('2', '东京热', '16655554444', '日本', '1531103826');
INSERT INTO `director` VALUES ('3', '啄木鸟', '19944441111', '法国', '1531103872');
INSERT INTO `director` VALUES ('4', '宇宙企', '15522223333', '日本', '1531103891');
INSERT INTO `director` VALUES ('5', '桃太郎', '18844441111', '日本', '1531103925');
INSERT INTO `director` VALUES ('6', '鬼畜', '15345645645', '日本', '1531103944');
INSERT INTO `director` VALUES ('7', 'S1', '12299956662', '日本', '1531104091');
INSERT INTO `director` VALUES ('9', '二本道', '122111111111', '日本', '1532425162');
INSERT INTO `director` VALUES ('10', '二本道1', '122111111111', '日本', '1532425172');
INSERT INTO `director` VALUES ('11', '二本到', '122111111111', '日本', '1532425172');
-- ----------------------------
-- Table structure for merge
-- ----------------------------
DROP TABLE IF EXISTS `merge`;
CREATE TABLE `merge` (
`video_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
`video_name` varchar(50) NOT NULL COMMENT '影片名',
`video_time` date NOT NULL COMMENT '上线时间',
`director_name` varchar(50) NOT NULL COMMENT '导演名',
`director_phone` varchar(20) NOT NULL COMMENT '导演电话',
`director_country` varchar(20) NOT NULL COMMENT '导演国家',
`user_name` varchar(50) NOT NULL COMMENT '明星名',
`user_phone` varchar(20) NOT NULL COMMENT '明星名',
`user_country` varchar(20) NOT NULL COMMENT '演员国家',
`birthday` date NOT NULL COMMENT '生日',
`weight` smallint(3) unsigned NOT NULL COMMENT '体重',
`height` smallint(3) unsigned NOT NULL COMMENT '身高',
`add_time` datetime NOT NULL COMMENT '添加时间',
PRIMARY KEY (`video_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='合并表';
-- ----------------------------
-- Records of merge
-- ----------------------------
INSERT INTO `merge` VALUES ('1', '天下无码', '0000-00-00', '', '', '', '小泽', '16644445555', '日本', '1990-07-08', '102', '165', '0000-00-00 00:00:00');
INSERT INTO `merge` VALUES ('2', '天下无码', '2018-10-10', '一本道', '15500003333', '日本', '波多野结衣', '18844441111', '日本', '1988-05-05', '98', '170', '2018-08-08 00:00:00');
INSERT INTO `merge` VALUES ('3', '天下无码', '2018-10-10', '一本道', '15500003333', '日本', '', '', '', '0000-00-00', '0', '0', '2018-08-08 00:00:00');
INSERT INTO `merge` VALUES ('4', '天下无码', '2018-10-10', '一本道', '15500003333', '日本', '小泽', '16644445555', '日本', '1990-07-08', '102', '165', '2018-08-08 12:00:00');
INSERT INTO `merge` VALUES ('5', '天下无码', '2018-10-10', '一本道', '15500003333', '日本', '', '', '', '0000-00-00', '0', '0', '2018-08-08 12:00:00');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`uid` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`name` varchar(50) NOT NULL COMMENT '姓名',
`phone` varchar(20) NOT NULL COMMENT '手机号',
`country` varchar(20) NOT NULL COMMENT '国家',
`birthday` date NOT NULL COMMENT '生日',
`weight` smallint(3) unsigned NOT NULL COMMENT '体重',
`height` smallint(3) unsigned NOT NULL COMMENT '身高',
`add_time` int(11) unsigned NOT NULL COMMENT '添加时间',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='明星表';
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '波多野结衣', '12211112222', '日本', '1988-05-24', '100', '163', '1531104265');
INSERT INTO `user` VALUES ('2', '大桥未久', '14455554444', '日本', '1987-12-24', '98', '158', '1531104315');
INSERT INTO `user` VALUES ('3', '京香', '16644442222', '日本', '1987-05-25', '90', '158', '1531104374');
INSERT INTO `user` VALUES ('4', '麻生希', '19988886666', '日本', '1988-12-20', '102', '170', '1531104407');
INSERT INTO `user` VALUES ('5', '天海翼', '14532147896', '日本', '1988-03-08', '92', '160', '1531104445');
INSERT INTO `user` VALUES ('6', '林由奈', '14512312312', '日本', '1976-11-30', '86', '159', '1531104523');
INSERT INTO `user` VALUES ('7', '小川阿佐美', '19012312345', '日本', '1985-05-11', '96', '167', '1531104606');
INSERT INTO `user` VALUES ('8', '濑亚美莉', '14465479820', '日本', '1987-09-16', '103', '167', '1531104671');
INSERT INTO `user` VALUES ('9', '原纱央莉', '14501201200', '日本', '1988-01-01', '99', '165', '1531104710');
INSERT INTO `user` VALUES ('10', '柚木提娜', '12345679800', '日本', '1986-10-29', '89', '154', '1531104747');
INSERT INTO `user` VALUES ('11', '早乙女露依', '16578945555', '日本', '1988-06-26', '86', '153', '1531104811');
-- ----------------------------
-- Table structure for video
-- ----------------------------
DROP TABLE IF EXISTS `video`;
CREATE TABLE `video` (
`video_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '影片ID',
`video_name` varchar(100) NOT NULL COMMENT '片名',
`uid` int(11) unsigned NOT NULL COMMENT '明星ID',
`tid` int(11) unsigned NOT NULL COMMENT '导演ID',
`release_time` date NOT NULL COMMENT '上映时间',
`number` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '观看量',
`add_time` int(11) unsigned NOT NULL COMMENT '添加时间',
PRIMARY KEY (`video_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='影片表';
-- ----------------------------
-- Records of video
-- ----------------------------
INSERT INTO `video` VALUES ('1', '女老师', '1', '1', '2016-05-04', '100', '1531104951');
INSERT INTO `video` VALUES ('2', '同行爱', '2', '1', '2016-04-01', '200', '1531104974');
INSERT INTO `video` VALUES ('3', '颜物语', '3', '2', '2017-10-22', '600', '1531105003');
INSERT INTO `video` VALUES ('4', '義姉', '3', '4', '2018-02-22', '1000', '1531105108');
INSERT INTO `video` VALUES ('5', '妄想', '4', '4', '2016-08-20', '1110', '1531105159');
INSERT INTO `video` VALUES ('6', '天下无码', '10', '6', '2018-10-31', '1000', '1532315533');
INSERT INTO `video` VALUES ('8', '邻家女孩', '10', '3', '2018-10-25', '1000', '1532572221');
批改老师：韦小宝批改时间：2019-01-15 13:20:45
老师总结：你这提交的是啥啊？就是sql文件啊 你的作业呢？作业讲的是利用多表关系来完成各小案例，那么这中间肯定就需要多表联合查询 你可以先创建两个数据表 这两个表是关联表 再来通过联合查询对两表的内容进行查询！课后没事把这个作业改一下！
