/*
 Navicat Premium Data Transfer

 Source Server         : 我的数据库
 Source Server Type    : MySQL
 Source Server Version : 50710
 Source Host           : localhost
 Source Database       : deerkids

 Target Server Type    : MySQL
 Target Server Version : 50710
 File Encoding         : utf-8

 Date: 11/04/2018 13:45:27 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `kid_admin`
-- ----------------------------
DROP TABLE IF EXISTS `kid_admin`;
CREATE TABLE `kid_admin` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(225) NOT NULL,
  `password` varchar(225) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `kid_admin`
-- ----------------------------
BEGIN;
INSERT INTO `kid_admin` VALUES ('5', 'admin', '$2b$10$1JDuFJNtHg69L3T412Zh3ubXPuxWNkvQv.1Ofe9GTibPAd/yxwt2a'), ('6', '谢海', '$2b$10$rXH6yRKJX9M5B92eHnxibucDGPnz/x22KTPEbxPJ/OIO3NPNVn2Tq'), ('7', '谢海2', '$2b$10$o0Mwa5n1ZvWDQQg2IO7gPuKszgL2U/f1cJab0z/kA1JqbXVdSgx/.'), ('8', 'admin2', '$2b$10$CsMGhMvHlb2K56IRDhehheg7m2R3H.uGkTDZuHVCITem.6Z6/agvm');
COMMIT;

-- ----------------------------
--  Table structure for `kid_category`
-- ----------------------------
DROP TABLE IF EXISTS `kid_category`;
CREATE TABLE `kid_category` (
  `id` int(50) NOT NULL AUTO_INCREMENT COMMENT '类别id',
  `cateName` varchar(225) NOT NULL COMMENT '分类名称',
  `title` varchar(225) DEFAULT NULL COMMENT '标题',
  `subTitle` varchar(225) DEFAULT NULL COMMENT '副标题',
  `rang` varchar(100) DEFAULT NULL COMMENT '适用年龄',
  `tagType` varchar(500) DEFAULT NULL COMMENT '包含的服务标签',
  `childs` varchar(500) DEFAULT NULL COMMENT '包含的套餐id',
  `remark` text COMMENT '特别说明',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `kid_category`
-- ----------------------------
BEGIN;
INSERT INTO `kid_category` VALUES ('1', 'face', 'face 系列', '测试', '23个月以上', '[\"测试\",\"可携带衣服\"]', null, '哈哈'), ('2', 'look', 'look系列', '时尚大片／创意场景', '23个月以上', '[\"测试\",\"可携带衣服\"]', null, '无');
COMMIT;

-- ----------------------------
--  Table structure for `kid_package`
-- ----------------------------
DROP TABLE IF EXISTS `kid_package`;
CREATE TABLE `kid_package` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `packName` varchar(225) NOT NULL COMMENT '套餐名称',
  `price` decimal(5,2) NOT NULL DEFAULT '0.00' COMMENT '套餐价格',
  `interiorNum` tinyint(4) NOT NULL COMMENT '内景组数',
  `shotNum` tinyint(4) NOT NULL COMMENT '拍摄数量',
  `truingNum` tinyint(4) NOT NULL COMMENT '精修数量',
  `phoneSize` tinyint(4) NOT NULL COMMENT '相册大小',
  `negativeNum` tinyint(4) NOT NULL DEFAULT '0' COMMENT '底片数量',
  `imgs` varchar(255) NOT NULL COMMENT '示例照片',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `kid_prop`
-- ----------------------------
DROP TABLE IF EXISTS `kid_prop`;
CREATE TABLE `kid_prop` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '属性id',
  `title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `isShow` tinyint(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `kid_prop`
-- ----------------------------
BEGIN;
INSERT INTO `kid_prop` VALUES ('2', '测试', '1'), ('3', '可携带衣服', '1');
COMMIT;

-- ----------------------------
--  Table structure for `kid_schedule`
-- ----------------------------
DROP TABLE IF EXISTS `kid_schedule`;
CREATE TABLE `kid_schedule` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '预定者名称',
  `scheName` varchar(255) NOT NULL COMMENT '预定时间',
  `scheTime` varchar(225) NOT NULL COMMENT '预定时间',
  `phone` varchar(255) NOT NULL COMMENT '手机号码',
  `babyName` varchar(225) NOT NULL COMMENT '宝宝名称',
  `babySamllName` varchar(225) NOT NULL COMMENT '宝宝小名',
  `birthday` datetime NOT NULL COMMENT '宝宝生日',
  `babySex` tinyint(4) NOT NULL COMMENT '宝宝性别',
  `address` varchar(500) NOT NULL COMMENT '收货地址',
  `consignee` varchar(225) NOT NULL COMMENT '收件人',
  `tel` varchar(50) NOT NULL COMMENT '联系电话',
  `isAgree` tinyint(20) NOT NULL DEFAULT '0' COMMENT '是否同意展示客片',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `kid_user`
-- ----------------------------
DROP TABLE IF EXISTS `kid_user`;
CREATE TABLE `kid_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `userName` varchar(225) NOT NULL DEFAULT '' COMMENT '用户名称',
  `openid` varchar(225) NOT NULL DEFAULT '' COMMENT '微信openid',
  `sex` smallint(1) unsigned DEFAULT '0' COMMENT '用户性别',
  `avatarImg` varchar(500) DEFAULT NULL COMMENT '用户头像',
  PRIMARY KEY (`id`,`openid`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `kid_user`
-- ----------------------------
BEGIN;
INSERT INTO `kid_user` VALUES ('1', '谢海', 'saadsdsadsa', '1', 'https://aaa.com'), ('2', '花裤熊二', 'aaaaaa', '0', 'https://aaa.com');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;