CREATE DATABASE wwt_film DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 
use wwt_film;

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_name` varchar(20) COLLATE utf8_bin NOT NULL,
  `account` varchar(255) COLLATE utf8_bin NOT NULL,
  `admin_pwd` varchar(255) COLLATE utf8_bin NOT NULL,
  `img_url` varchar(255) COLLATE utf8_bin NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `is_delete` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`admin_id`),
  UNIQUE KEY `admin_name` (`admin_name`) USING BTREE,
  UNIQUE KEY `account` (`account`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '/img/1234.jpg', '2019-12-20 15:28:12', '2019-12-20 15:28:14', '1');

-- ----------------------------
-- Table structure for film
-- ----------------------------
DROP TABLE IF EXISTS `film`;
CREATE TABLE `film` (
  `film_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `film_name` varchar(255) COLLATE utf8_bin NOT NULL,
  `film_time` date NOT NULL,
  `director` varchar(255) COLLATE utf8_bin NOT NULL,
  `play_time` int(10) NOT NULL,
  `poster_url` varchar(255) COLLATE utf8_bin NOT NULL,
  `is_delete` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`film_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of film
-- ----------------------------
INSERT INTO `film` VALUES ('1', '南方车站的聚会', '2019-12-20', '刁亦男', '113', '/img/1.jpeg', '1');
INSERT INTO `film` VALUES ('2', '被光抓走的人', '2019-12-20', '董润年', '131', '/img/2.jpg', '1');
INSERT INTO `film` VALUES ('4', '叶问4：完结篇', '2019-12-20', '叶伟信', '107', '/img/3.jpg', '1');
INSERT INTO `film` VALUES ('5', '误杀', '2019-12-20', '柯汶利', '112', '/img/4.jpg', '1');
INSERT INTO `film` VALUES ('6', '半个喜剧', '2019-12-20', '周申', '111', '/img/5.jpg', '1');
INSERT INTO `film` VALUES ('7', '利刃出鞘 Knives Out ', '2019-12-20', '莱恩·约翰逊', '130', '/img/6.jpg', '1');
INSERT INTO `film` VALUES ('8', '坂本龙一：终曲', '2019-12-20', '史蒂芬·野村·斯奇博', '100', '/img/7.jpg', '1');
INSERT INTO `film` VALUES ('9', '平原上的夏洛克', '2019-12-20', '徐磊', '98', '/img/8.jpg', '1');
INSERT INTO `film` VALUES ('10', '星球大战9：天行者崛起', '2019-12-20', 'J·J·艾布拉姆斯', '142', '/img/9.jpg', '1');
INSERT INTO `film` VALUES ('11', '教授与疯子', '2019-12-20', '法尔哈德·撒夫尼亚', '124', '/img/10.jpg', '1');
INSERT INTO `film` VALUES ('28', '行者主义a', '2019-12-20', '董润年', '110', '/img/108.jpg', '1');
INSERT INTO `film` VALUES ('29', 'dwa', '2019-12-01', 'dwadw', '110', '/img/109.jpg', '0');
INSERT INTO `film` VALUES ('30', '爱河', '2019-12-29', '买了笑忘录', '110', '/img/84.jpg', '0');

-- ----------------------------
-- Table structure for film_and_type
-- ----------------------------
DROP TABLE IF EXISTS `film_and_type`;
CREATE TABLE `film_and_type` (
  `type_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int(20) NOT NULL,
  `film_id` int(20) NOT NULL,
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of film_and_type
-- ----------------------------
INSERT INTO `film_and_type` VALUES ('1', '2', '1');
INSERT INTO `film_and_type` VALUES ('2', '1', '4');
INSERT INTO `film_and_type` VALUES ('4', '3', '5');
INSERT INTO `film_and_type` VALUES ('5', '3', '6');
INSERT INTO `film_and_type` VALUES ('6', '7', '2');
INSERT INTO `film_and_type` VALUES ('7', '9', '10');
INSERT INTO `film_and_type` VALUES ('8', '8', '11');
INSERT INTO `film_and_type` VALUES ('9', '2', '9');
INSERT INTO `film_and_type` VALUES ('10', '3', '7');
INSERT INTO `film_and_type` VALUES ('11', '2', '8');
INSERT INTO `film_and_type` VALUES ('12', '3', '14');
INSERT INTO `film_and_type` VALUES ('25', '1', '29');
INSERT INTO `film_and_type` VALUES ('26', '1', '30');

-- ----------------------------
-- Table structure for film_category
-- ----------------------------
DROP TABLE IF EXISTS `film_category`;
CREATE TABLE `film_category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `film_category` varchar(255) COLLATE utf8_bin NOT NULL,
  `is_delete` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of film_category
-- ----------------------------
INSERT INTO `film_category` VALUES ('1', '动作', '1');
INSERT INTO `film_category` VALUES ('2', '爱情', '1');
INSERT INTO `film_category` VALUES ('3', '谍战', '1');
INSERT INTO `film_category` VALUES ('7', '悬疑', '1');
INSERT INTO `film_category` VALUES ('8', '侦探', '1');
INSERT INTO `film_category` VALUES ('9', '科幻', '1');
INSERT INTO `film_category` VALUES ('10', '战争', '1');

-- ----------------------------
-- Table structure for performer
-- ----------------------------
DROP TABLE IF EXISTS `performer`;
CREATE TABLE `performer` (
  `performer_id` int(11) NOT NULL AUTO_INCREMENT,
  `performer_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`performer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of performer
-- ----------------------------
INSERT INTO `performer` VALUES ('1', '胡歌');
INSERT INTO `performer` VALUES ('2', '黄渤');
INSERT INTO `performer` VALUES ('3', '甄子丹');
INSERT INTO `performer` VALUES ('4', '肖央');
INSERT INTO `performer` VALUES ('5', '任素汐');
INSERT INTO `performer` VALUES ('6', '丹尼尔·克雷格');
INSERT INTO `performer` VALUES ('7', '坂本龙一');
INSERT INTO `performer` VALUES ('8', '徐朝英 ');
INSERT INTO `performer` VALUES ('9', '黛西·雷德利');
INSERT INTO `performer` VALUES ('10', '梅尔·吉布森 ');
INSERT INTO `performer` VALUES ('11', '坂本龙一');
INSERT INTO `performer` VALUES ('27', 'wadwa');
INSERT INTO `performer` VALUES ('28', '买了笑忘录');

-- ----------------------------
-- Table structure for play
-- ----------------------------
DROP TABLE IF EXISTS `play`;
CREATE TABLE `play` (
  `play_id` int(11) NOT NULL AUTO_INCREMENT,
  `play_time` datetime NOT NULL,
  `film_id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL,
  `money` double(11,2) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `is_delete` int(10) NOT NULL DEFAULT '1',
  PRIMARY KEY (`play_id`),
  KEY `play_time` (`play_time`),
  KEY `room_id` (`room_id`),
  KEY `film_id` (`film_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of play
-- ----------------------------
INSERT INTO `play` VALUES ('1', '2019-12-21 19:00:00', '1', '1', '39.00', '2019-12-21 19:13:20', '2019-12-21 19:13:22', '1');
INSERT INTO `play` VALUES ('2', '2019-12-22 19:00:00', '1', '1', '39.00', '2019-12-21 19:13:45', '2019-12-21 19:13:47', '1');
INSERT INTO `play` VALUES ('3', '2019-12-21 19:00:00', '2', '2', '39.00', '2019-12-21 19:14:12', '2019-12-21 19:14:14', '1');
INSERT INTO `play` VALUES ('4', '2019-12-22 19:00:19', '2', '2', '39.00', '2019-12-21 19:14:27', '2019-12-21 19:14:29', '1');
INSERT INTO `play` VALUES ('5', '2019-12-21 19:14:36', '4', '3', '39.00', '2019-12-21 19:14:46', '2019-12-29 16:02:07', '0');
INSERT INTO `play` VALUES ('6', '2019-12-22 19:14:53', '4', '3', '39.00', '2019-12-21 19:15:11', '2019-12-21 19:15:14', '1');
INSERT INTO `play` VALUES ('7', '2019-12-21 19:15:47', '5', '4', '39.00', '2019-12-21 19:16:07', '2019-12-21 19:16:09', '1');
INSERT INTO `play` VALUES ('8', '2019-12-22 19:16:26', '5', '4', '39.00', '2019-12-21 19:16:33', '2019-12-21 19:16:36', '1');
INSERT INTO `play` VALUES ('9', '2019-12-21 19:16:43', '6', '5', '39.00', '2019-12-21 19:16:58', '2019-12-21 19:17:00', '1');
INSERT INTO `play` VALUES ('10', '2019-12-22 19:17:05', '6', '5', '39.00', '2019-12-21 19:17:12', '2019-12-21 19:17:16', '1');
INSERT INTO `play` VALUES ('12', '2019-12-31 12:30:00', '6', '1', '50.00', '2019-12-29 16:01:30', '2019-12-29 16:01:30', '1');

-- ----------------------------
-- Table structure for room
-- ----------------------------
DROP TABLE IF EXISTS `room`;
CREATE TABLE `room` (
  `room_id` int(11) NOT NULL AUTO_INCREMENT,
  `room_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`room_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of room
-- ----------------------------
INSERT INTO `room` VALUES ('1', '一号厅');
INSERT INTO `room` VALUES ('2', '二号厅');
INSERT INTO `room` VALUES ('3', '三号厅');
INSERT INTO `room` VALUES ('4', '四号厅');
INSERT INTO `room` VALUES ('5', '五号厅');

-- ----------------------------
-- Table structure for screenwriter
-- ----------------------------
DROP TABLE IF EXISTS `screenwriter`;
CREATE TABLE `screenwriter` (
  `screenwriter_id` int(11) NOT NULL AUTO_INCREMENT,
  `screenwriter_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`screenwriter_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of screenwriter
-- ----------------------------
INSERT INTO `screenwriter` VALUES ('1', 'J·J·艾布拉姆斯');
INSERT INTO `screenwriter` VALUES ('2', '约翰·保曼');
INSERT INTO `screenwriter` VALUES ('3', '莱恩·约翰逊');
INSERT INTO `screenwriter` VALUES ('4', '杨薇薇');
INSERT INTO `screenwriter` VALUES ('5', '董润年');
INSERT INTO `screenwriter` VALUES ('6', '刁亦男');
INSERT INTO `screenwriter` VALUES ('7', '黄子桓');
INSERT INTO `screenwriter` VALUES ('8', '周申');
INSERT INTO `screenwriter` VALUES ('9', '徐磊');
INSERT INTO `screenwriter` VALUES ('12', '阿帕奇');
INSERT INTO `screenwriter` VALUES ('13', '瓦尔塔');
INSERT INTO `screenwriter` VALUES ('15', '达瓦');
INSERT INTO `screenwriter` VALUES ('16', 'wdaw');
INSERT INTO `screenwriter` VALUES ('17', '行者主义wd');
INSERT INTO `screenwriter` VALUES ('18', 'wdawd');
INSERT INTO `screenwriter` VALUES ('19', '123');
INSERT INTO `screenwriter` VALUES ('20', '伟大');
INSERT INTO `screenwriter` VALUES ('21', 'dwadw');
INSERT INTO `screenwriter` VALUES ('22', '买了笑忘录');

-- ----------------------------
-- Table structure for screenwriter_film
-- ----------------------------
DROP TABLE IF EXISTS `screenwriter_film`;
CREATE TABLE `screenwriter_film` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `film_id` int(11) NOT NULL,
  `screenwriter_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of screenwriter_film
-- ----------------------------
INSERT INTO `screenwriter_film` VALUES ('1', '9', '9');
INSERT INTO `screenwriter_film` VALUES ('2', '1', '6');
INSERT INTO `screenwriter_film` VALUES ('3', '4', '7');
INSERT INTO `screenwriter_film` VALUES ('4', '6', '8');
INSERT INTO `screenwriter_film` VALUES ('5', '2', '5');
INSERT INTO `screenwriter_film` VALUES ('6', '5', '4');
INSERT INTO `screenwriter_film` VALUES ('7', '7', '3');
INSERT INTO `screenwriter_film` VALUES ('8', '10', '1');
INSERT INTO `screenwriter_film` VALUES ('9', '11', '2');
INSERT INTO `screenwriter_film` VALUES ('10', '8', '1');
INSERT INTO `screenwriter_film` VALUES ('11', '14', '12');
INSERT INTO `screenwriter_film` VALUES ('24', '29', '21');
INSERT INTO `screenwriter_film` VALUES ('25', '30', '22');

-- ----------------------------
-- Table structure for seat
-- ----------------------------
DROP TABLE IF EXISTS `seat`;
CREATE TABLE `seat` (
  `seat_id` int(11) NOT NULL AUTO_INCREMENT,
  `seat` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`seat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of seat
-- ----------------------------
INSERT INTO `seat` VALUES ('1', '1-1');
INSERT INTO `seat` VALUES ('2', '1-2');
INSERT INTO `seat` VALUES ('3', '1-3');
INSERT INTO `seat` VALUES ('4', '1-4');
INSERT INTO `seat` VALUES ('5', '1-5');
INSERT INTO `seat` VALUES ('6', '1-6');
INSERT INTO `seat` VALUES ('7', '1-7');
INSERT INTO `seat` VALUES ('8', '1-8');
INSERT INTO `seat` VALUES ('9', '1-9');
INSERT INTO `seat` VALUES ('10', '2-1');
INSERT INTO `seat` VALUES ('11', '2-2');
INSERT INTO `seat` VALUES ('12', '2-3');
INSERT INTO `seat` VALUES ('13', '2-4');
INSERT INTO `seat` VALUES ('14', '2-5');
INSERT INTO `seat` VALUES ('15', '2-6');
INSERT INTO `seat` VALUES ('16', '2-7');
INSERT INTO `seat` VALUES ('17', '2-8');
INSERT INTO `seat` VALUES ('18', '2-9');
INSERT INTO `seat` VALUES ('19', '3-1');
INSERT INTO `seat` VALUES ('20', '3-2');
INSERT INTO `seat` VALUES ('21', '3-3');
INSERT INTO `seat` VALUES ('22', '3-4');
INSERT INTO `seat` VALUES ('23', '3-5');
INSERT INTO `seat` VALUES ('24', '3-6');
INSERT INTO `seat` VALUES ('25', '3-7');
INSERT INTO `seat` VALUES ('26', '3-8');
INSERT INTO `seat` VALUES ('27', '3-9');
INSERT INTO `seat` VALUES ('28', '4-1');
INSERT INTO `seat` VALUES ('29', '4-2');
INSERT INTO `seat` VALUES ('30', '4-3');
INSERT INTO `seat` VALUES ('31', '4-4');
INSERT INTO `seat` VALUES ('32', '4-5');
INSERT INTO `seat` VALUES ('33', '4-6');
INSERT INTO `seat` VALUES ('34', '4-7');
INSERT INTO `seat` VALUES ('35', '4-8');
INSERT INTO `seat` VALUES ('36', '4-9');
INSERT INTO `seat` VALUES ('37', '5-1');
INSERT INTO `seat` VALUES ('38', '5-2');
INSERT INTO `seat` VALUES ('39', '5-3');
INSERT INTO `seat` VALUES ('40', '5-4');
INSERT INTO `seat` VALUES ('41', '5-5');
INSERT INTO `seat` VALUES ('42', '5-6');
INSERT INTO `seat` VALUES ('43', '5-7');
INSERT INTO `seat` VALUES ('44', '5-8');
INSERT INTO `seat` VALUES ('45', '5-9');
INSERT INTO `seat` VALUES ('46', '6-1');
INSERT INTO `seat` VALUES ('47', '6-2');
INSERT INTO `seat` VALUES ('48', '6-3');
INSERT INTO `seat` VALUES ('49', '6-4');
INSERT INTO `seat` VALUES ('50', '6-5');
INSERT INTO `seat` VALUES ('51', '6-6');
INSERT INTO `seat` VALUES ('52', '6-7');
INSERT INTO `seat` VALUES ('53', '6-8');
INSERT INTO `seat` VALUES ('54', '6-9');

-- ----------------------------
-- Table structure for star
-- ----------------------------
DROP TABLE IF EXISTS `star`;
CREATE TABLE `star` (
  `star_id` int(11) NOT NULL AUTO_INCREMENT,
  `film_id` int(11) NOT NULL,
  `performer_id` int(11) NOT NULL,
  PRIMARY KEY (`star_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of star
-- ----------------------------
INSERT INTO `star` VALUES ('1', '1', '3');
INSERT INTO `star` VALUES ('2', '2', '6');
INSERT INTO `star` VALUES ('3', '4', '3');
INSERT INTO `star` VALUES ('4', '5', '4');
INSERT INTO `star` VALUES ('5', '6', '5');
INSERT INTO `star` VALUES ('6', '7', '6');
INSERT INTO `star` VALUES ('7', '8', '7');
INSERT INTO `star` VALUES ('8', '9', '8');
INSERT INTO `star` VALUES ('9', '10', '9');
INSERT INTO `star` VALUES ('10', '11', '10');
INSERT INTO `star` VALUES ('11', '14', '10');
INSERT INTO `star` VALUES ('12', '15', '14');
INSERT INTO `star` VALUES ('13', '17', '17');
INSERT INTO `star` VALUES ('14', '18', '18');
INSERT INTO `star` VALUES ('15', '19', '19');
INSERT INTO `star` VALUES ('16', '20', '20');
INSERT INTO `star` VALUES ('17', '21', '21');
INSERT INTO `star` VALUES ('18', '22', '22');
INSERT INTO `star` VALUES ('19', '23', '23');
INSERT INTO `star` VALUES ('20', '24', '24');
INSERT INTO `star` VALUES ('21', '25', '25');
INSERT INTO `star` VALUES ('22', '26', '26');
INSERT INTO `star` VALUES ('23', '28', '14');
INSERT INTO `star` VALUES ('24', '29', '27');
INSERT INTO `star` VALUES ('25', '30', '28');

-- ----------------------------
-- Table structure for ticket
-- ----------------------------
DROP TABLE IF EXISTS `ticket`;
CREATE TABLE `ticket` (
  `ticket_id` int(11) NOT NULL AUTO_INCREMENT,
  `play_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `seat_id` int(11) NOT NULL,
  `buying_time` datetime NOT NULL,
  PRIMARY KEY (`ticket_id`),
  KEY `user_id` (`user_id`),
  KEY `play_id` (`play_id`),
  CONSTRAINT `play_id` FOREIGN KEY (`play_id`) REFERENCES `play` (`play_id`),
  CONSTRAINT `user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=534 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of ticket
-- ----------------------------
INSERT INTO `ticket` VALUES ('1', '1', '1', '21', '2019-12-22 17:17:22');
INSERT INTO `ticket` VALUES ('2', '1', '6', '22', '2019-12-22 17:17:39');
INSERT INTO `ticket` VALUES ('3', '1', '1', '6', '2019-12-22 21:37:30');
INSERT INTO `ticket` VALUES ('4', '1', '1', '5', '2019-12-22 21:37:30');
INSERT INTO `ticket` VALUES ('5', '1', '1', '4', '2019-12-22 21:37:30');
INSERT INTO `ticket` VALUES ('6', '1', '1', '3', '2019-12-22 21:37:31');
INSERT INTO `ticket` VALUES ('12', '1', '1', '35', '2019-12-23 12:03:09');
INSERT INTO `ticket` VALUES ('13', '1', '1', '26', '2019-12-23 12:03:09');
INSERT INTO `ticket` VALUES ('14', '1', '1', '36', '2019-12-23 12:04:24');
INSERT INTO `ticket` VALUES ('15', '1', '1', '27', '2019-12-23 12:04:25');
INSERT INTO `ticket` VALUES ('16', '1', '1', '15', '2019-12-23 12:05:20');
INSERT INTO `ticket` VALUES ('17', '1', '1', '16', '2019-12-23 12:05:20');
INSERT INTO `ticket` VALUES ('21', '1', '1', '41', '2019-12-23 12:08:11');
INSERT INTO `ticket` VALUES ('22', '1', '1', '32', '2019-12-23 12:08:11');
INSERT INTO `ticket` VALUES ('23', '2', '1', '34', '2019-12-23 12:11:00');
INSERT INTO `ticket` VALUES ('24', '2', '1', '25', '2019-12-23 12:11:00');
INSERT INTO `ticket` VALUES ('120', '3', '1', '24', '2019-12-26 17:57:35');
INSERT INTO `ticket` VALUES ('530', '1', '1', '33', '2019-12-27 16:12:34');
INSERT INTO `ticket` VALUES ('531', '1', '1', '24', '2019-12-27 16:12:34');
INSERT INTO `ticket` VALUES ('532', '3', '1', '25', '2019-12-29 14:00:45');
INSERT INTO `ticket` VALUES ('533', '1', '1', '45', '2019-12-29 17:19:41');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_account` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sex` int(10) DEFAULT '2',
  `user_emli` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `img_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `last_ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_delete` int(11) DEFAULT '1',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_account` (`user_account`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', '先生', '20682', 'e10adc3949ba59abbe56e057f20f883e', '1', '2068@qq.com', '15555555', '/img/106.jpg', '2019-12-20 14:50:02', '2019-12-29 14:01:12', '0:0:0:0:0:0:0:1', '1');
INSERT INTO `users` VALUES ('6', '隔壁老王', '206886', 'e10adc3949ba59abbe56e057f20f883e', '1', '123@qq.com', '15019999999', '/img/ht.jpg', '2019-12-20 17:13:52', '2019-12-20 17:13:52', '0:0:0:0:0:0:0:1', '1');
INSERT INTO `users` VALUES ('7', '123456', '123456', 'e10adc3949ba59abbe56e057f20f883e', '2', '123456', '123456', '/img/ht.jpg', '2019-12-23 14:15:31', '2019-12-23 14:15:31', null, '1');
INSERT INTO `users` VALUES ('8', '456789', '456789', 'e10adc3949ba59abbe56e057f20f883e', '2', '123123@qq.com', '132123123', '/img/ht.jpg', '2019-12-23 14:19:20', '2019-12-23 14:19:20', '0:0:0:0:0:0:0:1', '1');
INSERT INTO `users` VALUES ('9', 'aaaa', '147258', 'e10adc3949ba59abbe56e057f20f883e', '2', '147258@qq.com', '147288', '/img/ht.jpg', '2019-12-23 14:22:23', '2019-12-23 14:22:23', null, '1');
INSERT INTO `users` VALUES ('10', 'laowan', '20666', 'e10adc3949ba59abbe56e057f20f883e', '2', '2068@qq.com', '1234567', '/img/ht.jpg', '2019-12-29 16:38:33', '2019-12-29 16:41:54', '0:0:0:0:0:0:0:1', '1');