/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50556
Source Host           : localhost:3306
Source Database       : my_meifa

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

Date: 2017-07-14 18:09:32
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for mf_hairdresser
-- ----------------------------
DROP TABLE IF EXISTS `mf_hairdresser`;
CREATE TABLE `mf_hairdresser` (
  `hairdresser_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL COMMENT '微信名称',
  `alias` varchar(255) DEFAULT NULL COMMENT '别名 设计师优先取别名 没有时再取name',
  `type_id` tinyint(1) DEFAULT '0' COMMENT '0会员1设计师',
  `level_id` int(11) DEFAULT '0' COMMENT '设计师等级',
  `stat` tinyint(4) NOT NULL DEFAULT '0' COMMENT '在职0,1离职禁止登陆',
  `ism` tinyint(4) NOT NULL DEFAULT '0' COMMENT '超管1，普通0',
  `create_at` int(11) NOT NULL DEFAULT '0' COMMENT '时间',
  `haird_num` varchar(30) DEFAULT NULL COMMENT '店员编号',
  `phone_num` varchar(20) DEFAULT NULL COMMENT '手机号',
  `open_id` varchar(255) DEFAULT '' COMMENT 'OPENid',
  PRIMARY KEY (`hairdresser_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='美发师';

-- ----------------------------
-- Records of mf_hairdresser
-- ----------------------------
INSERT INTO `mf_hairdresser` VALUES ('1', '王小贱', null, '0', '1', '0', '0', '1495612097', '', '', '');
INSERT INTO `mf_hairdresser` VALUES ('24', '徐小贱', null, '0', '2', '0', '0', '1495612097', '', '', '');

-- ----------------------------
-- Table structure for mf_item_hairdresser_relation
-- ----------------------------
DROP TABLE IF EXISTS `mf_item_hairdresser_relation`;
CREATE TABLE `mf_item_hairdresser_relation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hairdresser_id` int(11) NOT NULL COMMENT '美发师ID',
  `item_id` int(11) NOT NULL COMMENT '服务项ID',
  `price` float NOT NULL COMMENT '价格',
  `fencheng` float NOT NULL DEFAULT '0' COMMENT '个人分成数字',
  `subscribe` int(11) NOT NULL DEFAULT '0' COMMENT '预约人数',
  `create_at` int(11) NOT NULL,
  `update_at` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='服务项与美发师关系表';

-- ----------------------------
-- Records of mf_item_hairdresser_relation
-- ----------------------------
INSERT INTO `mf_item_hairdresser_relation` VALUES ('1', '24', '4', '5', '0', '0', '1495612097', '1495612097');
INSERT INTO `mf_item_hairdresser_relation` VALUES ('2', '1', '4', '5', '0', '0', '1495612097', '1495612097');

-- ----------------------------
-- Table structure for mf_levels
-- ----------------------------
DROP TABLE IF EXISTS `mf_levels`;
CREATE TABLE `mf_levels` (
  `level_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(94) DEFAULT NULL,
  `create_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`level_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mf_levels
-- ----------------------------
INSERT INTO `mf_levels` VALUES ('1', '店长', '1495612097');
INSERT INTO `mf_levels` VALUES ('2', '经理', '1495612097');
INSERT INTO `mf_levels` VALUES ('3', '店员', '1495612097');

-- ----------------------------
-- Table structure for mf_orders
-- ----------------------------
DROP TABLE IF EXISTS `mf_orders`;
CREATE TABLE `mf_orders` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT,
  `order_name` varchar(64) NOT NULL,
  `price` float NOT NULL,
  `order_code` varchar(64) NOT NULL,
  `order_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '订单状态，0待处理，1已处理，2 退单',
  `item_id` int(11) NOT NULL,
  `hairdresser_id` int(11) NOT NULL,
  `subscribe_time` int(11) NOT NULL,
  `phone_num` varchar(11) DEFAULT NULL COMMENT '手机号',
  `remarks` varchar(255) NOT NULL,
  `create_at` int(11) NOT NULL,
  `complete_time` int(11) NOT NULL DEFAULT '0' COMMENT '完成时间',
  `jsstat` tinyint(4) NOT NULL DEFAULT '0' COMMENT '结算状态，结算给理发师，及分成状态1已分成0未结算分成',
  `jstime` int(11) NOT NULL DEFAULT '0' COMMENT '结算时间，店长点击结算给员工的算账时间',
  `mphone` char(11) DEFAULT NULL COMMENT '下单人手机号码',
  `mnickname` varchar(50) DEFAULT NULL COMMENT '下单人昵称',
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='订单表';

-- ----------------------------
-- Records of mf_orders
-- ----------------------------
INSERT INTO `mf_orders` VALUES ('1', '丁丁名称', '23', '002', '1', '1', '1', '1498579200', null, '', '1498579200', '1498579200', '0', '0', '13122310539', '你妹哟@!');
INSERT INTO `mf_orders` VALUES ('2', '名称2', '35', '002', '1', '4', '1', '1498579200', null, '', '1498579200', '1498579200', '0', '0', '13122548745', '啥时候!~');
INSERT INTO `mf_orders` VALUES ('3', '订单名是什么', '100', '003', '0', '3', '1', '1498579200', null, '', '1498579200', '1498579200', '0', '0', '15944512345', '能能能~');
INSERT INTO `mf_orders` VALUES ('4', 'name3', '55', '004', '0', '2', '1', '1498579200', null, '', '1498579200', '1498579200', '0', '0', '18845613345', '做好啊~');

-- ----------------------------
-- Table structure for mf_service_item
-- ----------------------------
DROP TABLE IF EXISTS `mf_service_item`;
CREATE TABLE `mf_service_item` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_name` varchar(64) NOT NULL,
  `item_time` int(11) NOT NULL,
  `create_at` int(11) NOT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='服务项目';

-- ----------------------------
-- Records of mf_service_item
-- ----------------------------
INSERT INTO `mf_service_item` VALUES ('1', '洗吹', '20', '1496297816');
INSERT INTO `mf_service_item` VALUES ('2', '剪发', '30', '1496297816');
INSERT INTO `mf_service_item` VALUES ('3', '染发', '180', '1496297816');
INSERT INTO `mf_service_item` VALUES ('4', '拉直', '180', '1496297816');
INSERT INTO `mf_service_item` VALUES ('5', '烫发', '180', '1496297816');
INSERT INTO `mf_service_item` VALUES ('6', '护理', '180', '1496297816');
INSERT INTO `mf_service_item` VALUES ('7', '干洗', '30', '1496297816');

-- ----------------------------
-- Table structure for mf_set_conf
-- ----------------------------
DROP TABLE IF EXISTS `mf_set_conf`;
CREATE TABLE `mf_set_conf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `column_name` varchar(64) NOT NULL,
  `column_value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='设置表';

-- ----------------------------
-- Records of mf_set_conf
-- ----------------------------
INSERT INTO `mf_set_conf` VALUES ('1', 'store_name', '文峰美发美容');
INSERT INTO `mf_set_conf` VALUES ('2', 'store_banner', '../../img/banner/banner_1.png');
INSERT INTO `mf_set_conf` VALUES ('3', 'store_address', '上海市浦东新区张杨路1254号2楼05室');
INSERT INTO `mf_set_conf` VALUES ('4', 'store_latitude', '0');
INSERT INTO `mf_set_conf` VALUES ('5', 'store_longitude', '0');
INSERT INTO `mf_set_conf` VALUES ('6', 'store_qr_code', '../../img/banner/20170606135634.jpg');
INSERT INTO `mf_set_conf` VALUES ('7', 'start_time', '9:00');
INSERT INTO `mf_set_conf` VALUES ('8', 'end_time', '22:30');