/*
SQLyog Ultimate v12.3.1 (64 bit)
MySQL - 5.6.40-log : Database - happy_tour
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`happy_tour` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;

USE `happy_tour`;

/*Table structure for table `address` */

DROP TABLE IF EXISTS `address`;

CREATE TABLE `address` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `parent_id` int(8) DEFAULT NULL COMMENT '上级id',
  `address_name` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '地址名',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=168 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='地址表';

/*Data for the table `address` */

insert  into `address`(`id`,`parent_id`,`address_name`,`create_time`,`update_time`) values 
(1,0,'北京','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(2,0,'天津','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(3,0,'上海','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(4,0,'重庆','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(5,0,'河北','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(6,0,'山西','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(7,0,'辽宁','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(8,0,'吉林','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(9,0,'黑龙江','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(10,0,'江苏','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(11,0,'浙江','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(12,0,'安徽','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(13,0,'福建','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(14,0,'江西','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(15,0,'山东','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(16,0,'河南','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(17,0,'湖北','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(18,0,'湖南','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(19,0,'广东','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(20,0,'海南','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(21,0,'四川','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(22,0,'贵州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(23,0,'云南','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(24,0,'陕西','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(25,0,'甘肃','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(26,0,'青海','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(27,0,'台湾','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(28,0,'内蒙古','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(29,0,'广西','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(30,0,'西藏','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(31,0,'宁夏','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(32,0,'新疆','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(33,0,'香港','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(34,0,'澳门','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(35,5,'石家庄','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(36,5,'唐山','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(37,5,'秦皇岛','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(38,5,'邯郸','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(39,5,'邢台','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(40,5,'保定','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(41,5,'张家口','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(42,5,'承德','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(43,5,'沧州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(44,5,'廊坊','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(45,5,'衡水','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(46,6,'太原','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(47,6,'大同','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(48,6,'阳泉','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(49,6,'长治','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(50,6,'晋城','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(51,6,'朔州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(52,6,'晋中','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(53,6,'运城','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(54,6,'忻州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(55,6,'临汾','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(56,6,'吕梁','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(57,27,'台北','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(58,27,'高雄','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(59,27,'基隆','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(60,27,'台中','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(61,27,'台南','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(62,27,'新竹','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(63,27,'嘉义','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(64,7,'沈阳','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(65,7,'大连','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(66,7,'鞍山','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(67,7,'抚顺','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(68,7,'本溪','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(69,7,'丹东','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(70,7,'锦州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(71,7,'营口','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(72,7,'阜新','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(73,7,'辽阳','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(74,7,'盘锦','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(75,7,'铁岭','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(76,7,'朝阳','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(77,7,'葫芦岛','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(78,8,'长春','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(79,8,'吉林','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(80,8,'四平','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(81,8,'白城','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(82,9,'哈尔滨','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(83,9,'齐齐哈尔','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(84,10,'南京','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(85,10,'无锡','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(86,10,'徐州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(87,10,'常州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(88,10,'苏州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(89,10,'淮安','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(90,10,'盐城','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(91,10,'扬州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(92,11,'杭州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(93,11,'宁波','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(94,11,'温州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(95,11,'台州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(96,12,'合肥','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(97,12,'芜湖','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(98,12,'蚌埠','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(99,12,'宿州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(100,13,'福州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(101,13,'厦门','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(102,13,'莆田','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(103,13,'南平','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(104,14,'南昌','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(105,14,'景德镇','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(106,14,'萍乡','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(107,14,'九江','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(108,15,'济南','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(109,15,'青岛','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(110,15,'枣庄','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(111,15,'烟台','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(112,16,'郑州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(113,16,'开封','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(114,16,'洛阳','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(115,16,'新乡','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(116,17,'武汉','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(117,17,'黄石','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(118,17,'荆州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(119,17,'宜昌','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(120,18,'长沙','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(121,18,'衡阳','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(122,18,'岳阳','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(123,18,'张家界','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(124,19,'广州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(125,19,'深圳','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(126,19,'佛山','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(127,19,'湛江','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(128,25,'兰州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(129,25,'金昌','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(130,25,'天水','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(131,25,'庆阳','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(132,21,'成都','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(133,21,'绵阳','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(134,21,'广元','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(135,21,'遂宁','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(136,22,'贵阳','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(137,22,'遵义','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(138,22,'安顺','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(139,20,'海口','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(140,20,'三亚','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(141,20,'五指山','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(142,20,'文昌','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(143,23,'昆明','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(144,23,'玉溪','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(145,23,'丽江','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(146,26,'西宁','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(147,24,'西安','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(148,24,'咸阳','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(149,24,'延安','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(150,24,'汉中','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(151,29,'南宁','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(152,29,'桂林','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(153,29,'梧州','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(154,29,'北海','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(155,30,'拉萨','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(156,31,'银川','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(157,31,'吴忠','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(158,31,'固原','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(159,31,'中卫','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(160,32,'乌鲁木齐','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(161,32,'克拉玛依','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(162,32,'吐鲁番','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(163,32,'库尔勒','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(164,28,'呼和浩特','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(165,28,'鄂尔多斯','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(166,28,'呼伦贝尔','2018-09-27 09:20:02','2018-09-27 09:20:02'),
(167,28,'乌兰察布','2018-09-27 09:20:02','2018-09-27 09:20:02');

/*Table structure for table `answer` */

DROP TABLE IF EXISTS `answer`;

CREATE TABLE `answer` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `question_id` int(8) DEFAULT NULL COMMENT '对应问题id',
  `content` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '问题内容',
  `create_time` date DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='答案表';

/*Data for the table `answer` */

/*Table structure for table `coach` */

DROP TABLE IF EXISTS `coach`;

CREATE TABLE `coach` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `coach_num` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '汽车号码',
  `frome_space` int(8) DEFAULT NULL COMMENT '出发地',
  `tospace` int(8) DEFAULT NULL COMMENT '目的地',
  `frome_time` datetime DEFAULT NULL COMMENT '出发时间',
  `to_time` datetime DEFAULT NULL COMMENT '到达时间',
  `discount` float DEFAULT NULL COMMENT '折扣',
  `price` decimal(8,2) DEFAULT NULL COMMENT '价格',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='汽车';

/*Data for the table `coach` */

/*Table structure for table `data_dictionary` */

DROP TABLE IF EXISTS `data_dictionary`;

CREATE TABLE `data_dictionary` (
  `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '数据id',
  `data_code` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '数据类型名',
  `data_id` int(4) DEFAULT NULL,
  `data` varchar(600) COLLATE utf8_bin DEFAULT NULL COMMENT '数据',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='数据字典';

/*Data for the table `data_dictionary` */

insert  into `data_dictionary`(`id`,`data_code`,`data_id`,`data`) values 
(1,'user_type',1,'系统管理员'),
(2,'user_type',2,'加盟商'),
(3,'user_type',3,'普通游客'),
(4,'card_type',1,'身份证'),
(5,'card_type',2,'护照'),
(6,'card_type',3,'驾照'),
(7,'hotel_level',1,'三星级'),
(8,'hotel_level',2,'四星级'),
(9,'hotel_level',3,'五星级'),
(10,'house_type',1,'标准间'),
(11,'house_type',2,'打开水立方'),
(12,'house_type',3,'是的'),
(13,'house_type',4,'todo'),
(14,'pay_type',1,'支付宝'),
(15,'pay_type',2,'微信'),
(16,'pay_type',3,'银联'),
(17,'dis_type',1,'酒店评论'),
(18,'dis_type',2,'旅游评论'),
(19,'dis_type',3,'评论回复');

/*Table structure for table `discuss` */

DROP TABLE IF EXISTS `discuss`;

CREATE TABLE `discuss` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `user_id` int(8) DEFAULT NULL COMMENT '用户id',
  `target_id` int(8) DEFAULT NULL COMMENT '评论对象的id',
  `content` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '内容',
  `praise` int(8) DEFAULT NULL COMMENT '点赞数',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `dis_type` int(8) DEFAULT NULL COMMENT '评论的类型：如酒店评论，旅游项目评论',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='评论表\n';

/*Data for the table `discuss` */

/*Table structure for table `hotel` */

DROP TABLE IF EXISTS `hotel`;

CREATE TABLE `hotel` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `hotel_name` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '酒店名',
  `address_id` int(8) DEFAULT NULL COMMENT '地址id',
  `hotel_phone` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '酒店联系电话',
  `level` int(8) DEFAULT NULL COMMENT '酒店星级',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='酒店表';

/*Data for the table `hotel` */

/*Table structure for table `house_detail` */

DROP TABLE IF EXISTS `house_detail`;

CREATE TABLE `house_detail` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `hotel_id` int(8) NOT NULL COMMENT '酒店id',
  `house_type` int(8) DEFAULT NULL COMMENT '房间类型',
  `price` decimal(8,2) DEFAULT NULL COMMENT '价格',
  `status` int(8) DEFAULT NULL COMMENT '状态，是否为空',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='酒店房间详情';

/*Data for the table `house_detail` */

/*Table structure for table `order` */

DROP TABLE IF EXISTS `order`;

CREATE TABLE `order` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `order_type` int(8) NOT NULL COMMENT '订单类型',
  `poject_code` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '订单号',
  `user_id` int(8) DEFAULT NULL COMMENT '用户id',
  `payment` decimal(8,2) DEFAULT NULL COMMENT '付款金额',
  `payment_type` int(8) DEFAULT NULL COMMENT '支付方式',
  `status` int(8) DEFAULT NULL COMMENT '状态：是否已付款',
  `payment_time` datetime DEFAULT NULL COMMENT '支付时间',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='订单表';

/*Data for the table `order` */

/*Table structure for table `order_detail` */

DROP TABLE IF EXISTS `order_detail`;

CREATE TABLE `order_detail` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `user_id` int(8) DEFAULT NULL COMMENT '用户id',
  `order_on` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '订单号',
  `product_id` int(8) DEFAULT NULL COMMENT '产品id',
  `product_name` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '产品名',
  `product_img` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '产品主图',
  `current_unit_price` decimal(8,2) DEFAULT NULL COMMENT '产品子图',
  `quantity` int(8) DEFAULT NULL COMMENT '数量',
  `total_price` decimal(8,2) DEFAULT NULL COMMENT '总价',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='订单明细表';

/*Data for the table `order_detail` */

/*Table structure for table `plane` */

DROP TABLE IF EXISTS `plane`;

CREATE TABLE `plane` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `flight` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '航班',
  `from_space` int(8) DEFAULT NULL COMMENT '出发地',
  `tospace` int(8) DEFAULT NULL COMMENT '目的地',
  `company` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '航空公司',
  `frome_time` datetime DEFAULT NULL COMMENT '起飞时间',
  `to_time` datetime DEFAULT NULL COMMENT '落地时间',
  `discount` float DEFAULT NULL COMMENT '折扣',
  `price` decimal(8,2) DEFAULT NULL COMMENT '票价',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='飞机表';

/*Data for the table `plane` */

/*Table structure for table `question` */

DROP TABLE IF EXISTS `question`;

CREATE TABLE `question` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `user_id` int(8) DEFAULT NULL COMMENT '用户id',
  `content` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '内容',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='提问表';

/*Data for the table `question` */

/*Table structure for table `train` */

DROP TABLE IF EXISTS `train`;

CREATE TABLE `train` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `train_num` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '火车车次',
  `frome_space` int(8) DEFAULT NULL COMMENT '出发地',
  `tospace` int(8) DEFAULT NULL COMMENT '目的地',
  `frome_time` datetime DEFAULT NULL COMMENT '出发时间',
  `to_time` datetime DEFAULT NULL COMMENT '到达时间',
  `discount` float DEFAULT NULL COMMENT '折扣',
  `price` decimal(8,2) DEFAULT NULL COMMENT '票价',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='火车时刻表';

/*Data for the table `train` */

/*Table structure for table `treval_project` */

DROP TABLE IF EXISTS `treval_project`;

CREATE TABLE `treval_project` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `project_type` int(8) DEFAULT NULL COMMENT '旅游项目类型：跟团，团购',
  `project_name` varbinary(100) DEFAULT NULL COMMENT '项目名',
  `project_code` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '项目编号',
  `from_place` int(8) DEFAULT NULL COMMENT '上车地点',
  `to_place` int(8) DEFAULT NULL COMMENT '目的地',
  `from_time` date DEFAULT NULL COMMENT '出发时间',
  `to_time` date DEFAULT NULL COMMENT '到达时间',
  `price` decimal(8,2) DEFAULT NULL COMMENT '价格',
  `people_num` int(4) DEFAULT NULL COMMENT '人数',
  `main_img` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '项目主图',
  `sub_img` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '子图',
  `detail_info` text COLLATE utf8_bin COMMENT '详细介绍',
  `user_id` int(8) DEFAULT NULL COMMENT '发布项目的用户id',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='旅游项目表\n';

/*Data for the table `treval_project` */

insert  into `treval_project`(`id`,`project_type`,`project_name`,`project_code`,`from_place`,`to_place`,`from_time`,`to_time`,`price`,`people_num`,`main_img`,`sub_img`,`detail_info`,`user_id`,`create_time`,`update_time`) values 
(1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '用户名',
  `password` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '密码',
  `realname` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '真实姓名',
  `email` varchar(60) COLLATE utf8_bin DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '电话',
  `question` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '校验问题',
  `answer` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '校验答案',
  `card_type` int(8) DEFAULT NULL COMMENT '证件类型',
  `card_no` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '证件号',
  `gender` int(2) DEFAULT NULL COMMENT '性别',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `address` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '居住地址',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `last_login_time` datetime DEFAULT NULL COMMENT '最近一次登录时间',
  `role` int(8) DEFAULT NULL COMMENT '角色id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='游客表';

/*Data for the table `user` */

insert  into `user`(`id`,`username`,`password`,`realname`,`email`,`phone`,`question`,`answer`,`card_type`,`card_no`,`gender`,`birthday`,`address`,`create_time`,`update_time`,`last_login_time`,`role`) values 
(1,'admin','admin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2,'tang','tang',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;