/*
Navicat MySQL Data Transfer

Source Server         : local_dev
Source Server Version : 50528
Source Host           : localhost:3306
Source Database       : huasbaodan

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

Date: 2014-11-25 11:26:37
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `oa_config`
-- ----------------------------
DROP TABLE IF EXISTS `oa_config`;
CREATE TABLE `oa_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `is_notify_kefu` tinyint(1) DEFAULT NULL,
  `kefu_email` varchar(55) DEFAULT NULL,
  `is_notify_wirter` tinyint(1) DEFAULT NULL,
  `is_nodify_manager` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of oa_config
-- ----------------------------
INSERT INTO `oa_config` VALUES ('1', '1', '[email protected]', '1', '1');

-- ----------------------------
-- Table structure for `oa_email`
-- ----------------------------
DROP TABLE IF EXISTS `oa_email`;
CREATE TABLE `oa_email` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `from` varchar(100) DEFAULT NULL,
  `to` varchar(100) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `body` text,
  `time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of oa_email
-- ----------------------------

-- ----------------------------
-- Table structure for `oa_employee`
-- ----------------------------
DROP TABLE IF EXISTS `oa_employee`;
CREATE TABLE `oa_employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `true_name` varchar(50) NOT NULL,
  `email` varchar(60) NOT NULL,
  `tel` varchar(11) NOT NULL,
  `qq` varchar(12) NOT NULL,
  `password` varchar(200) NOT NULL,
  `ranks` tinyint(1) NOT NULL DEFAULT '4' COMMENT 'ranks 分为1 2 3 4。普通业务为4，业务领导3，客服管理部为2，超级管理员1.',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `create_time` int(11) DEFAULT NULL,
  `ct_by_id` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  `up_by_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of oa_employee
-- ----------------------------
INSERT INTO `oa_employee` VALUES ('1', '赵飞', '[email protected]', '18200129961', '598320713', 'zhaofei', '1', '1', null, null, null, null);
INSERT INTO `oa_employee` VALUES ('2', 'feizhao', 'feizhao', '182098219', '212121', '21212', '4', '0', null, null, null, null);

-- ----------------------------
-- Table structure for `oa_em_store`
-- ----------------------------
DROP TABLE IF EXISTS `oa_em_store`;
CREATE TABLE `oa_em_store` (
  `id` int(11) NOT NULL DEFAULT '0',
  `e_id` int(11) DEFAULT NULL,
  `store_ids` varchar(255) DEFAULT NULL,
  `create_time` int(11) NOT NULL,
  `ct_by_id` int(11) NOT NULL,
  `update_time` int(11) DEFAULT NULL,
  `up_by_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk` (`e_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of oa_em_store
-- ----------------------------

-- ----------------------------
-- Table structure for `oa_order`
-- ----------------------------
DROP TABLE IF EXISTS `oa_order`;
CREATE TABLE `oa_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `e_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `write_time` int(11) NOT NULL DEFAULT '0',
  `examize_status` tinyint(4) NOT NULL,
  `examize_id` int(11) DEFAULT NULL,
  `examize_time` int(11) DEFAULT NULL,
  `examize_info` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of oa_order
-- ----------------------------

-- ----------------------------
-- Table structure for `oa_products`
-- ----------------------------
DROP TABLE IF EXISTS `oa_products`;
CREATE TABLE `oa_products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `p_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `sort` int(11) DEFAULT '0',
  `create_time` int(11) DEFAULT NULL,
  `ct_by_id` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  `up_by_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of oa_products
-- ----------------------------
INSERT INTO `oa_products` VALUES ('1', '0', '华氏宝贝', '1', '0', null, null, null, null);
INSERT INTO `oa_products` VALUES ('2', '0', ' 妙可', '1', '0', null, null, null, null);
INSERT INTO `oa_products` VALUES ('3', '1', '米粉', '1', '0', null, null, null, null);
INSERT INTO `oa_products` VALUES ('4', '3', '米粉——1', '1', '0', null, null, null, null);

-- ----------------------------
-- Table structure for `oa_store`
-- ----------------------------
DROP TABLE IF EXISTS `oa_store`;
CREATE TABLE `oa_store` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `provice` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `area` varchar(100) NOT NULL,
  `name` varchar(155) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `sort` int(11) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  `ct_by_id` int(11) DEFAULT NULL,
  `update_time` int(11) DEFAULT NULL,
  `up_by_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of oa_store
-- ----------------------------