lutong
/
deerkid.sql

/*
Navicat MySQL Data Transfer

Source Server         : 本地mysql
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : deerkids

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

Date: 2018-11-04 17:37:29
*/

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
-- ----------------------------
INSERT INTO `kid_admin` VALUES ('5', 'admin', '$2b$10$1JDuFJNtHg69L3T412Zh3ubXPuxWNkvQv.1Ofe9GTibPAd/yxwt2a');
INSERT INTO `kid_admin` VALUES ('6', '谢海', '$2b$10$rXH6yRKJX9M5B92eHnxibucDGPnz/x22KTPEbxPJ/OIO3NPNVn2Tq');
INSERT INTO `kid_admin` VALUES ('7', '谢海2', '$2b$10$o0Mwa5n1ZvWDQQg2IO7gPuKszgL2U/f1cJab0z/kA1JqbXVdSgx/.');
INSERT INTO `kid_admin` VALUES ('8', 'admin2', '$2b$10$CsMGhMvHlb2K56IRDhehheg7m2R3H.uGkTDZuHVCITem.6Z6/agvm');

-- ----------------------------
-- 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 '特别说明',
  `pictures` varchar(500) DEFAULT '[]' COMMENT '样图',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of kid_category
-- ----------------------------
INSERT INTO `kid_category` VALUES ('5', '哈哈', '哈哈', '哈哈', '哈哈', '[\"测试\"]', null, '哈哈', '[{\"url\":\"http://127.0.0.1:3000/uploads/img/47700ca576d6f.png\",\"name\":\"47700ca576d6f.png\",\"uid\":1541320264244,\"status\":\"success\"},{\"url\":\"http://127.0.0.1:3000/uploads/img/8b9b02b1379c6.jpg\",\"name\":\"8b9b02b1379c6.jpg\",\"uid\":1541320266934,\"status\":\"success\"}]');

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of kid_package
-- ----------------------------

-- ----------------------------
-- 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
-- ----------------------------
INSERT INTO `kid_prop` VALUES ('2', '测试', '1');
INSERT INTO `kid_prop` VALUES ('3', '可携带衣服', '1');

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of kid_schedule
-- ----------------------------

-- ----------------------------
-- 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
-- ----------------------------
INSERT INTO `kid_user` VALUES ('1', '谢海', 'saadsdsadsa', '1', 'https://aaa.com');
INSERT INTO `kid_user` VALUES ('2', '花裤熊二', 'aaaaaa', '0', 'https://aaa.com');