数据库建表语句备份（一）

团队项目movierankings数据库---8个数据表

1.movie1905

CREATE DATABASE /*!32312 IF NOT EXISTS*/`movierankings` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;

USE `movierankings`;

/*Table structure for table `movie1905` */

DROP TABLE IF EXISTS `movie1905`;

CREATE TABLE `movie1905` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) COLLATE utf8_bin NOT NULL,
  `score` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `path` VARCHAR(100) COLLATE utf8_bin NOT NULL,
  `state` VARCHAR(30) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`name`),
  KEY `id` (`id`)
) ENGINE=INNODB AUTO_INCREMENT=13530 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

2.moviebean

DROP TABLE IF EXISTS `moviebean`;

CREATE TABLE `moviebean` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `star` TEXT COLLATE utf8_bin NOT NULL,
  `director` TEXT COLLATE utf8_bin NOT NULL,
  `type_movie` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `area` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `date_time` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `summary` TEXT COLLATE utf8_bin NOT NULL,
  `score` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `language_movie` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `img` TEXT COLLATE utf8_bin NOT NULL,
  `scorenum` INT(11) NOT NULL,
  `timelen` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`,`title`,`scorenum`)
) ENGINE=INNODB AUTO_INCREMENT=3157 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

3.movieimdb

DROP TABLE IF EXISTS `movieimdb`;

CREATE TABLE `movieimdb` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) COLLATE utf8_bin NOT NULL,
  `score` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`name`),
  KEY `id` (`id`)
) ENGINE=INNODB AUTO_INCREMENT=12483 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

4.movieiqy

DROP TABLE IF EXISTS `movieiqy`;

CREATE TABLE `movieiqy` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `score` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `path` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `state` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`name`),
  KEY `id` (`id`)
) ENGINE=INNODB AUTO_INCREMENT=14350 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

5.moviesohu

DROP TABLE IF EXISTS `moviesohu`;

CREATE TABLE `moviesohu` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `score` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `path` VARCHAR(100) COLLATE utf8_bin NOT NULL,
  `state` VARCHAR(10) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`name`),
  KEY `id` (`id`)
) ENGINE=INNODB AUTO_INCREMENT=3654 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

6.movieten

DROP TABLE IF EXISTS `movieten`;

CREATE TABLE `movieten` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `score` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `path` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `state` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`name`),
  KEY `id` (`id`)
) ENGINE=INNODB AUTO_INCREMENT=20037 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

7.userdata

DROP TABLE IF EXISTS `userdata`;

CREATE TABLE `userdata` (
  `userphone` VARCHAR(20) COLLATE utf8_bin NOT NULL,
  `userpass` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `useremail` VARCHAR(100) COLLATE utf8_bin NOT NULL,
  `username` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`userphone`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

8.userlike

DROP TABLE IF EXISTS `userlike`;

CREATE TABLE `userlike` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `userphone` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `usermovie` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `usertype` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  `scorenum` INT(11) NOT NULL,
  `url` TEXT COLLATE utf8_bin NOT NULL,
  `score` VARCHAR(45) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`,`userphone`,`usermovie`,`usertype`,`scorenum`)
) ENGINE=INNODB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;