sql

/*
Navicat MySQL Data Transfer


Source Server         : localhost
Source Server Version : 50717
Source Host           : localhost:3306
Source Database       : travel


Target Server Type    : MYSQL
Target Server Version : 50717
File Encoding         : 65001


Date: 2017-11-06 09:43:19
*/


SET FOREIGN_KEY_CHECKS=0;


-- ----------------------------
-- Table structure for t_advert
-- ----------------------------
DROP TABLE IF EXISTS `t_advert`;
CREATE TABLE `t_advert` (
  `id` varchar(50) DEFAULT NULL COMMENT '主键',
  `imgurl` varchar(255) DEFAULT '' COMMENT '图片地址',
  `url` varchar(255) DEFAULT '' COMMENT '跳转地址',
  `imginfo` varchar(50) DEFAULT NULL COMMENT '图片说明',
  `price` varchar(20) DEFAULT NULL COMMENT '价格'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- ----------------------------
-- Records of t_advert
-- ----------------------------


-- ----------------------------
-- Table structure for t_area
-- ----------------------------
DROP TABLE IF EXISTS `t_area`;
CREATE TABLE `t_area` (
  `id` varchar(50) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `parentname` varchar(20) DEFAULT NULL,
  `parentid` varchar(50) DEFAULT NULL,
  `is_leaf` varchar(2) DEFAULT NULL,
  `sort_no` varchar(10) DEFAULT NULL,
  `cascade_id` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- ----------------------------
-- Records of t_area
-- ----------------------------


-- ----------------------------
-- Table structure for t_picture
-- ----------------------------
DROP TABLE IF EXISTS `t_picture`;
CREATE TABLE `t_picture` (
  `id` varchar(50) DEFAULT NULL,
  `picturename` varchar(20) DEFAULT NULL,
  `pictureurl` varchar(50) DEFAULT NULL,
  `intruction` varchar(50) DEFAULT NULL,
  `point` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- ----------------------------
-- Records of t_picture
-- ----------------------------


-- ----------------------------
-- Table structure for t_price
-- ----------------------------
DROP TABLE IF EXISTS `t_price`;
CREATE TABLE `t_price` (
  `id` varchar(50) NOT NULL,
  `ticket` varchar(10) DEFAULT NULL COMMENT '门票价格',
  `other` varchar(10) DEFAULT NULL COMMENT '其他费用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- ----------------------------
-- Records of t_price
-- ----------------------------


-- ----------------------------
-- Table structure for t_scenic
-- ----------------------------
DROP TABLE IF EXISTS `t_scenic`;
CREATE TABLE `t_scenic` (
  `id` varchar(50) DEFAULT NULL COMMENT '景点名称',
  `placename` varchar(20) DEFAULT NULL,
  `featuer` varchar(50) DEFAULT NULL COMMENT '特色',
  `pictureid` varchar(50) DEFAULT NULL COMMENT '图片集合id',
  `scoreid` varchar(50) DEFAULT NULL COMMENT '评分id',
  `priceid` varchar(50) DEFAULT NULL,
  `addrid` varchar(50) DEFAULT NULL,
  `hotpoint` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- ----------------------------
-- Records of t_scenic
-- ----------------------------


-- ----------------------------
-- Table structure for t_score
-- ----------------------------
DROP TABLE IF EXISTS `t_score`;
CREATE TABLE `t_score` (
  `id` varchar(50) DEFAULT NULL,
  `f_environment` varchar(5) DEFAULT NULL,
  `f_price` varchar(5) DEFAULT NULL,
  `f_transport` varchar(5) DEFAULT NULL,
  `descript` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- ----------------------------
-- Records of t_score
-- ----------------------------


-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` varchar(50) NOT NULL COMMENT '主键',
  `userid` varchar(20) DEFAULT NULL COMMENT '用户登录id',
  `username` varchar(10) DEFAULT NULL COMMENT '用户名称',
  `password` varchar(20) DEFAULT NULL COMMENT '密码',
  `tel` varchar(20) DEFAULT NULL COMMENT '电话号码',
  `addr` varchar(50) DEFAULT NULL COMMENT '地址',
  `type` varchar(2) DEFAULT NULL COMMENT '类型（0：管理员/1：用户）',
  `age` varchar(5) DEFAULT NULL COMMENT '年龄',
  `sex` varchar(2) DEFAULT NULL COMMENT '性别',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- ----------------------------
-- Records of t_user
-- ----------------------------