-- --------------------------------------------------------
-- 主机:                           127.0.0.1
-- 服务器版本:                        5.6.24-log - MySQL Community Server (GPL)
-- 服务器操作系统:                      Win32
-- HeidiSQL 版本:                  9.3.0.4984
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- 导出 o2o 的数据库结构
CREATE DATABASE IF NOT EXISTS `o2o` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;
USE `o2o`;


-- 导出  表 o2o.tb_area 结构
CREATE TABLE IF NOT EXISTS `tb_area` (
  `area_id` int(2) NOT NULL AUTO_INCREMENT,
  `area_name` varchar(200) NOT NULL,
  `priority` int(2) NOT NULL DEFAULT '0',
  `create_time` datetime DEFAULT NULL,
  `last_edit_time` datetime DEFAULT NULL,
  PRIMARY KEY (`area_id`),
  UNIQUE KEY `UK_AREA` (`area_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- 正在导出表  o2o.tb_area 的数据：~2 rows (大约)
DELETE FROM `tb_area`;
/*!40000 ALTER TABLE `tb_area` DISABLE KEYS */;
INSERT INTO `tb_area` (`area_id`, `area_name`, `priority`, `create_time`, `last_edit_time`) VALUES
	(1, '东苑', 1, NULL, NULL);
INSERT INTO `tb_area` (`area_id`, `area_name`, `priority`, `create_time`, `last_edit_time`) VALUES
	(2, '西苑', 2, NULL, NULL);
/*!40000 ALTER TABLE `tb_area` ENABLE KEYS */;


-- 导出  表 o2o.tb_head_line 结构
CREATE TABLE IF NOT EXISTS `tb_head_line` (
  `line_id` int(100) NOT NULL AUTO_INCREMENT,
  `line_name` varchar(1000) DEFAULT NULL,
  `line_link` varchar(2000) NOT NULL,
  `line_img` varchar(2000) NOT NULL,
  `priority` int(2) DEFAULT NULL,
  `enable_status` int(2) NOT NULL DEFAULT '0',
  `create_time` datetime DEFAULT NULL,
  `last_edit_time` datetime DEFAULT NULL,
  PRIMARY KEY (`line_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 正在导出表  o2o.tb_head_line 的数据：~0 rows (大约)
DELETE FROM `tb_head_line`;
/*!40000 ALTER TABLE `tb_head_line` DISABLE KEYS */;
/*!40000 ALTER TABLE `tb_head_line` ENABLE KEYS */;


-- 导出  表 o2o.tb_local_auth 结构
CREATE TABLE IF NOT EXISTS `tb_local_auth` (
  `local_auth_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `username` varchar(128) NOT NULL,
  `password` varchar(128) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  `last_edit_time` datetime DEFAULT NULL,
  PRIMARY KEY (`local_auth_id`),
  UNIQUE KEY `uk_local_profile` (`username`),
  KEY `fk_local_profile` (`user_id`),
  CONSTRAINT `fk_local_profile` FOREIGN KEY (`user_id`) REFERENCES `tb_person_info` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 正在导出表  o2o.tb_local_auth 的数据：~0 rows (大约)
DELETE FROM `tb_local_auth`;
/*!40000 ALTER TABLE `tb_local_auth` DISABLE KEYS */;
/*!40000 ALTER TABLE `tb_local_auth` ENABLE KEYS */;


-- 导出  表 o2o.tb_person_info 结构
CREATE TABLE IF NOT EXISTS `tb_person_info` (
  `user_id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL,
  `profile_img` varchar(1024) DEFAULT NULL,
  `email` varchar(1024) DEFAULT NULL,
  `gender` varchar(2) DEFAULT NULL,
  `enableStatus` int(2) NOT NULL DEFAULT '0' COMMENT '0:禁止使用本商城,1:允许使用本商城',
  `userType` int(2) NOT NULL DEFAULT '1' COMMENT '1:顾客,2:店家,3:超级管理员',
  `create_time` datetime DEFAULT NULL,
  `last_edit_time` datetime DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 正在导出表  o2o.tb_person_info 的数据：~0 rows (大约)
DELETE FROM `tb_person_info`;
/*!40000 ALTER TABLE `tb_person_info` DISABLE KEYS */;
INSERT INTO `tb_person_info` (`user_id`, `name`, `profile_img`, `email`, `gender`, `enableStatus`, `userType`, `create_time`, `last_edit_time`) VALUES
	(1, '测试', 'test', 'test', '1', 1, 2, NULL, NULL);
/*!40000 ALTER TABLE `tb_person_info` ENABLE KEYS */;


-- 导出  表 o2o.tb_product 结构
CREATE TABLE IF NOT EXISTS `tb_product` (
  `product_id` int(20) NOT NULL AUTO_INCREMENT,
  `product_name` varchar(100) NOT NULL,
  `product_desc` varchar(2000) DEFAULT NULL,
  `img_addr` varchar(2000) DEFAULT '',
  `normal_price` varchar(100) DEFAULT NULL,
  `promotion_price` varchar(100) DEFAULT NULL,
  `priority` int(2) NOT NULL DEFAULT '0',
  `create_time` datetime DEFAULT NULL,
  `last_edit_time` datetime DEFAULT NULL,
  `enable_status` int(20) NOT NULL DEFAULT '0',
  `product_category_id` int(11) DEFAULT NULL,
  `shop_id` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`product_id`),
  KEY `fk_product_procate` (`product_category_id`),
  KEY `fk_product_shop` (`shop_id`),
  CONSTRAINT `fk_product_procate` FOREIGN KEY (`product_category_id`) REFERENCES `tb_product_category` (`product_category_id`),
  CONSTRAINT `fk_product_shop` FOREIGN KEY (`shop_id`) REFERENCES `tb_shop` (`shop_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- 正在导出表  o2o.tb_product 的数据：~5 rows (大约)
DELETE FROM `tb_product`;
/*!40000 ALTER TABLE `tb_product` DISABLE KEYS */;
INSERT INTO `tb_product` (`product_id`, `product_name`, `product_desc`, `img_addr`, `normal_price`, `promotion_price`, `priority`, `create_time`, `last_edit_time`, `enable_status`, `product_category_id`, `shop_id`) VALUES
	(1, '正式的商品', '正式的商品2', 'upload\\item\\shop\\1\\2018070916001926040.jpg', '2', '1', 2, '2018-07-06 14:56:21', '2018-07-09 16:00:19', 1, 8, 1);
INSERT INTO `tb_product` (`product_id`, `product_name`, `product_desc`, `img_addr`, `normal_price`, `promotion_price`, `priority`, `create_time`, `last_edit_time`, `enable_status`, `product_category_id`, `shop_id`) VALUES
	(2, '测试2', '测试Desc2', 'test2', NULL, NULL, 2, '2018-07-06 14:56:21', '2018-07-06 14:56:21', 1, 1, 1);
INSERT INTO `tb_product` (`product_id`, `product_name`, `product_desc`, `img_addr`, `normal_price`, `promotion_price`, `priority`, `create_time`, `last_edit_time`, `enable_status`, `product_category_id`, `shop_id`) VALUES
	(3, 'aaa3', '测试Desc3', 'test3', NULL, NULL, 3, '2018-07-06 14:56:21', '2018-07-06 14:56:21', 1, 1, 1);
INSERT INTO `tb_product` (`product_id`, `product_name`, `product_desc`, `img_addr`, `normal_price`, `promotion_price`, `priority`, `create_time`, `last_edit_time`, `enable_status`, `product_category_id`, `shop_id`) VALUES
	(4, '测试商品1', '测试商品1', 'upload\\item\\shop\\1\\2018070616532697258.jpg', NULL, NULL, 20, '2018-07-06 16:53:27', '2018-07-06 16:53:27', 1, 1, 1);
INSERT INTO `tb_product` (`product_id`, `product_name`, `product_desc`, `img_addr`, `normal_price`, `promotion_price`, `priority`, `create_time`, `last_edit_time`, `enable_status`, `product_category_id`, `shop_id`) VALUES
	(5, '测试商品2', '测试商品类别2', 'upload\\item\\shop\\1\\2018070911412839577.jpg', '2', '1', 100, '2018-07-09 11:41:29', '2018-07-09 18:27:03', 1, 8, 1);
INSERT INTO `tb_product` (`product_id`, `product_name`, `product_desc`, `img_addr`, `normal_price`, `promotion_price`, `priority`, `create_time`, `last_edit_time`, `enable_status`, `product_category_id`, `shop_id`) VALUES
	(6, 'ttt', NULL, 'aa', NULL, NULL, 0, '2018-07-10 10:33:52', '2018-07-10 10:33:49', 0, NULL, 1);
/*!40000 ALTER TABLE `tb_product` ENABLE KEYS */;


-- 导出  表 o2o.tb_product_category 结构
CREATE TABLE IF NOT EXISTS `tb_product_category` (
  `product_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_category_name` varchar(100) NOT NULL,
  `priority` int(2) DEFAULT '0',
  `create_time` datetime DEFAULT NULL,
  `shop_id` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`product_category_id`),
  KEY `fk_procate_shop` (`shop_id`),
  CONSTRAINT `fk_procate_shop` FOREIGN KEY (`shop_id`) REFERENCES `tb_shop` (`shop_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- 正在导出表  o2o.tb_product_category 的数据：~5 rows (大约)
DELETE FROM `tb_product_category`;
/*!40000 ALTER TABLE `tb_product_category` DISABLE KEYS */;
INSERT INTO `tb_product_category` (`product_category_id`, `product_category_name`, `priority`, `create_time`, `shop_id`) VALUES
	(1, '水果', 2, '2018-07-05 14:08:48', 1);
INSERT INTO `tb_product_category` (`product_category_id`, `product_category_name`, `priority`, `create_time`, `shop_id`) VALUES
	(2, '蔬菜', 1, '2018-07-05 14:08:48', 1);
INSERT INTO `tb_product_category` (`product_category_id`, `product_category_name`, `priority`, `create_time`, `shop_id`) VALUES
	(8, '商品类别12', 300, NULL, 1);
INSERT INTO `tb_product_category` (`product_category_id`, `product_category_name`, `priority`, `create_time`, `shop_id`) VALUES
	(9, '测试1', 100, '2018-07-06 10:05:16', 1);
/*!40000 ALTER TABLE `tb_product_category` ENABLE KEYS */;


-- 导出  表 o2o.tb_product_img 结构
CREATE TABLE IF NOT EXISTS `tb_product_img` (
  `product_img_id` int(20) NOT NULL AUTO_INCREMENT,
  `img_addr` varchar(2000) NOT NULL,
  `img_desc` varchar(2000) DEFAULT NULL,
  `priority` int(2) DEFAULT '0',
  `create_time` datetime DEFAULT NULL,
  `product_id` int(20) DEFAULT NULL,
  PRIMARY KEY (`product_img_id`),
  KEY `fk_proimg_product` (`product_id`),
  CONSTRAINT `fk_proimg_product` FOREIGN KEY (`product_id`) REFERENCES `tb_product` (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- 正在导出表  o2o.tb_product_img 的数据：~6 rows (大约)
DELETE FROM `tb_product_img`;
/*!40000 ALTER TABLE `tb_product_img` DISABLE KEYS */;
INSERT INTO `tb_product_img` (`product_img_id`, `img_addr`, `img_desc`, `priority`, `create_time`, `product_id`) VALUES
	(5, 'upload\\item\\shop\\1\\2018070616532753073.jpg', NULL, NULL, '2018-07-06 16:53:27', 4);
INSERT INTO `tb_product_img` (`product_img_id`, `img_addr`, `img_desc`, `priority`, `create_time`, `product_id`) VALUES
	(6, 'upload\\item\\shop\\1\\2018070616532725108.jpg', NULL, NULL, '2018-07-06 16:53:27', 4);
INSERT INTO `tb_product_img` (`product_img_id`, `img_addr`, `img_desc`, `priority`, `create_time`, `product_id`) VALUES
	(7, 'upload\\item\\shop\\1\\2018070911412835552.jpg', NULL, NULL, '2018-07-09 11:41:28', 5);
INSERT INTO `tb_product_img` (`product_img_id`, `img_addr`, `img_desc`, `priority`, `create_time`, `product_id`) VALUES
	(8, 'upload\\item\\shop\\1\\2018070911412866848.jpg', NULL, NULL, '2018-07-09 11:41:28', 5);
INSERT INTO `tb_product_img` (`product_img_id`, `img_addr`, `img_desc`, `priority`, `create_time`, `product_id`) VALUES
	(17, 'upload\\item\\shop\\1\\2018070916001975036.jpg', NULL, NULL, '2018-07-09 16:00:19', 1);
INSERT INTO `tb_product_img` (`product_img_id`, `img_addr`, `img_desc`, `priority`, `create_time`, `product_id`) VALUES
	(18, 'upload\\item\\shop\\1\\2018070916001911666.jpg', NULL, NULL, '2018-07-09 16:00:19', 1);
/*!40000 ALTER TABLE `tb_product_img` ENABLE KEYS */;


-- 导出  表 o2o.tb_shop 结构
CREATE TABLE IF NOT EXISTS `tb_shop` (
  `shop_id` int(10) NOT NULL AUTO_INCREMENT,
  `owner_id` int(10) NOT NULL COMMENT '店铺创建人',
  `area_id` int(5) DEFAULT NULL,
  `shop_category_id` int(11) DEFAULT NULL,
  `shop_name` varchar(256) NOT NULL,
  `shop_desc` varchar(1024) DEFAULT NULL,
  `shop_addr` varchar(200) DEFAULT NULL,
  `phone` varchar(128) DEFAULT NULL,
  `shop_img` varchar(1024) DEFAULT NULL,
  `priority` int(3) DEFAULT '0',
  `create_time` datetime DEFAULT NULL,
  `last_edit_time` datetime DEFAULT NULL,
  `enable_status` int(11) NOT NULL DEFAULT '0',
  `advice` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`shop_id`),
  KEY `fk_shop_area` (`area_id`),
  KEY `fk_shop_profile` (`owner_id`),
  KEY `fk_shop_shopcate` (`shop_category_id`),
  CONSTRAINT `fk_shop_area` FOREIGN KEY (`area_id`) REFERENCES `tb_area` (`area_id`),
  CONSTRAINT `fk_shop_profile` FOREIGN KEY (`owner_id`) REFERENCES `tb_person_info` (`user_id`),
  CONSTRAINT `fk_shop_shopcate` FOREIGN KEY (`shop_category_id`) REFERENCES `tb_shop_category` (`shop_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- 正在导出表  o2o.tb_shop 的数据：~6 rows (大约)
DELETE FROM `tb_shop`;
/*!40000 ALTER TABLE `tb_shop` DISABLE KEYS */;
INSERT INTO `tb_shop` (`shop_id`, `owner_id`, `area_id`, `shop_category_id`, `shop_name`, `shop_desc`, `shop_addr`, `phone`, `shop_img`, `priority`, `create_time`, `last_edit_time`, `enable_status`, `advice`) VALUES
	(1, 1, 2, 1, '正式店铺名称', '测试描述', '正式地址', '15857281085', 'upload\\item\\shop\\1\\2018070417533278259.jpg', NULL, '2018-06-28 17:42:19', '2018-07-04 17:53:33', 1, '审核中');
INSERT INTO `tb_shop` (`shop_id`, `owner_id`, `area_id`, `shop_category_id`, `shop_name`, `shop_desc`, `shop_addr`, `phone`, `shop_img`, `priority`, `create_time`, `last_edit_time`, `enable_status`, `advice`) VALUES
	(3, 1, 2, 1, '测试的店铺1', 'test1', 'test1', 'test1', 'upload\\item\\shop\\3\\2018070215183439188.jpg', NULL, '2018-07-02 15:18:34', '2018-07-02 15:18:34', 0, '审核中');
INSERT INTO `tb_shop` (`shop_id`, `owner_id`, `area_id`, `shop_category_id`, `shop_name`, `shop_desc`, `shop_addr`, `phone`, `shop_img`, `priority`, `create_time`, `last_edit_time`, `enable_status`, `advice`) VALUES
	(6, 1, 2, 2, '商品1', '测试测试', '上海市', '15857281085', 'upload\\item\\shop\\6\\2018070318203246273.jpg', NULL, '2018-07-03 18:20:32', '2018-07-03 18:20:32', 0, NULL);
INSERT INTO `tb_shop` (`shop_id`, `owner_id`, `area_id`, `shop_category_id`, `shop_name`, `shop_desc`, `shop_addr`, `phone`, `shop_img`, `priority`, `create_time`, `last_edit_time`, `enable_status`, `advice`) VALUES
	(7, 1, 1, 2, '商品1', '测试测试', '上海市', '15857281085', 'upload\\item\\shop\\7\\2018070318210645857.jpg', NULL, '2018-07-03 18:21:07', '2018-07-03 18:21:07', 0, NULL);
INSERT INTO `tb_shop` (`shop_id`, `owner_id`, `area_id`, `shop_category_id`, `shop_name`, `shop_desc`, `shop_addr`, `phone`, `shop_img`, `priority`, `create_time`, `last_edit_time`, `enable_status`, `advice`) VALUES
	(8, 1, 2, 1, '测试的店铺', 'test', 'test', 'test', 'test', NULL, '2018-07-04 15:18:29', NULL, 1, '审核中');
INSERT INTO `tb_shop` (`shop_id`, `owner_id`, `area_id`, `shop_category_id`, `shop_name`, `shop_desc`, `shop_addr`, `phone`, `shop_img`, `priority`, `create_time`, `last_edit_time`, `enable_status`, `advice`) VALUES
	(9, 1, 2, 1, '测试的店铺3', 'test3', 'test3', 'test3', 'upload\\item\\shop\\9\\2018070415211174445.jpg', NULL, '2018-07-04 15:21:11', '2018-07-04 15:21:11', 0, '审核中');
/*!40000 ALTER TABLE `tb_shop` ENABLE KEYS */;


-- 导出  表 o2o.tb_shop_category 结构
CREATE TABLE IF NOT EXISTS `tb_shop_category` (
  `shop_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `shop_category_name` varchar(100) NOT NULL DEFAULT '',
  `shop_category_desc` varchar(1000) DEFAULT '',
  `shop_category_img` varchar(2000) DEFAULT NULL,
  `priority` int(2) NOT NULL DEFAULT '0',
  `create_time` datetime DEFAULT NULL,
  `last_edit_time` datetime DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`shop_category_id`),
  KEY `fk_shop_category_self` (`parent_id`),
  CONSTRAINT `fk_shop_category_self` FOREIGN KEY (`parent_id`) REFERENCES `tb_shop_category` (`shop_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- 正在导出表  o2o.tb_shop_category 的数据：~2 rows (大约)
DELETE FROM `tb_shop_category`;
/*!40000 ALTER TABLE `tb_shop_category` DISABLE KEYS */;
INSERT INTO `tb_shop_category` (`shop_category_id`, `shop_category_name`, `shop_category_desc`, `shop_category_img`, `priority`, `create_time`, `last_edit_time`, `parent_id`) VALUES
	(1, '咖啡奶茶', '咖啡奶茶', 'test', 1, NULL, NULL, NULL);
INSERT INTO `tb_shop_category` (`shop_category_id`, `shop_category_name`, `shop_category_desc`, `shop_category_img`, `priority`, `create_time`, `last_edit_time`, `parent_id`) VALUES
	(2, '测试', '测试', 'test3', 0, NULL, NULL, 1);
/*!40000 ALTER TABLE `tb_shop_category` ENABLE KEYS */;


-- 导出  表 o2o.tb_wechat_auth 结构
CREATE TABLE IF NOT EXISTS `tb_wechat_auth` (
  `wechat_auth_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `open_id` varchar(255) NOT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`wechat_auth_id`),
  UNIQUE KEY `open_id` (`open_id`),
  KEY `fk_wecahtauth_preofile` (`user_id`),
  CONSTRAINT `fk_wecahtauth_preofile` FOREIGN KEY (`user_id`) REFERENCES `tb_person_info` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 正在导出表  o2o.tb_wechat_auth 的数据：~0 rows (大约)
DELETE FROM `tb_wechat_auth`;
/*!40000 ALTER TABLE `tb_wechat_auth` DISABLE KEYS */;
/*!40000 ALTER TABLE `tb_wechat_auth` ENABLE KEYS */;


-- 导出  表 o2o.test 结构
CREATE TABLE IF NOT EXISTS `test` (
  `t` int(11) NOT NULL AUTO_INCREMENT,
  `a` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '0',
  PRIMARY KEY (`t`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- 正在导出表  o2o.test 的数据：~0 rows (大约)
DELETE FROM `test`;
/*!40000 ALTER TABLE `test` DISABLE KEYS */;
/*!40000 ALTER TABLE `test` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;