/*
SQLyog 企业版 - MySQL GUI v8.14 
MySQL - 5.7.17 : Database - sell
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`sell` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;

USE `sell`;

/*Table structure for table `order_detail` */

DROP TABLE IF EXISTS `order_detail`;

CREATE TABLE `order_detail` (
  `detail_id` varchar(32) NOT NULL,
  `order_id` varchar(32) NOT NULL,
  `product_id` varchar(32) NOT NULL,
  `product_name` varchar(64) NOT NULL,
  `product_price` decimal(8,2) NOT NULL,
  `product_quantity` int(11) NOT NULL COMMENT '商品数量',
  `product_icon` varchar(512) DEFAULT NULL COMMENT '商品图片',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`detail_id`),
  KEY `idx_order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单详情表';

/*Data for the table `order_detail` */

insert  into `order_detail`(`detail_id`,`order_id`,`product_id`,`product_name`,`product_price`,`product_quantity`,`product_icon`,`create_time`,`update_time`) values ('1533632485068268727','1533632485017975195','123332','披萨','22.00',1,'http://xxsa.jpa','2018-08-07 07:23:23','2018-08-07 07:23:23'),('1533632877106631372','1533632877047575623','123332','披萨','22.00',1,'http://xxsa.jpa','2018-08-07 07:30:27','2018-08-07 07:30:27'),('1533633024974738481','1533633024919333162','123332','披萨','22.00',1,'http://xxsa.jpa','2018-08-07 07:33:08','2018-08-07 07:33:08'),('1533633024990706912','1533633024919333162','123456','皮蛋粥','18.00',2,'http://xxx.jpg','2018-08-07 07:33:08','2018-08-07 07:33:08'),('1533633052626270268','1533633052569571216','123332','披萨','22.00',1,'http://xxsa.jpa','2018-08-07 07:33:37','2018-08-07 07:33:37'),('1533633052641675206','1533633052569571216','123456','皮蛋粥','18.00',2,'http://xxx.jpg','2018-08-07 07:33:38','2018-08-07 07:33:38'),('1534383444979672087','1534383440704548840','123456','皮蛋粥','18.00',2,'http://xxx.jpg','2018-08-16 01:37:43','2018-08-16 01:37:43'),('1534383510088547168','1534383510085548238','123456','皮蛋粥','18.00',1,'http://xxx.jpg','2018-08-16 01:38:31','2018-08-16 01:38:31'),('1534383904497783466','1534383904471159599','123456','皮蛋粥','18.00',1,'http://xxx.jpg','2018-08-16 01:45:06','2018-08-16 01:45:06'),('1534384304563677010','1534384304550543241','123456','皮蛋粥','18.00',1,'http://xxx.jpg','2018-08-16 01:51:46','2018-08-16 01:51:46'),('1534384543718518697','1534384543706542278','123456','皮蛋粥','18.00',1,'http://xxx.jpg','2018-08-16 01:55:45','2018-08-16 01:55:45'),('1534384603841861568','1534384603826246641','123456','皮蛋粥','18.00',1,'http://xxx.jpg','2018-08-16 01:56:45','2018-08-16 01:56:45'),('1534385959698759348','1534385959685872893','1534324731503508898','fdsafdas','22.00',1,'http://xxx.jpg','2018-08-16 02:19:21','2018-08-16 02:19:21'),('1536719686293263601','1536719685510526273','123332','披萨','22.00',9,'http://xxsa.jpa','2018-09-11 15:03:55','2018-09-11 15:03:55'),('1536719789495357189','1536719789483426301','123332','披萨','22.00',10,'http://xxsa.jpa','2018-09-11 15:05:47','2018-09-11 15:05:47'),('1536719789501116401','1536719789483426301','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-09-11 15:05:47','2018-09-11 15:05:47'),('1537177637239742073','1537177636192812510','123332','披萨','22.00',10,'http://xxsa.jpa','2018-09-17 07:28:43','2018-09-17 07:28:43'),('1537177637348250792','1537177636192812510','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-09-17 07:28:43','2018-09-17 07:28:43'),('1537177736370581537','1537177736361163072','123332','披萨','22.00',10,'http://xxsa.jpa','2018-09-17 07:30:30','2018-09-17 07:30:30'),('1537177736376616649','1537177736361163072','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-09-17 07:30:30','2018-09-17 07:30:30'),('1537234883931288432','1537234881965829662','123332','披萨','22.00',10,'http://xxsa.jpa','2018-09-18 01:41:26','2018-09-18 01:41:26'),('1537234884248494651','1537234881965829662','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-09-18 01:41:26','2018-09-18 01:41:26'),('1537236449192942129','1537236448454577210','123332','披萨','22.00',10,'http://xxsa.jpa','2018-09-18 02:07:31','2018-09-18 02:07:31'),('1537236449275725880','1537236448454577210','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-09-18 02:07:31','2018-09-18 02:07:31'),('1537237662128467029','1537237660947901316','123332','披萨','22.00',10,'http://xxsa.jpa','2018-09-18 02:27:44','2018-09-18 02:27:44'),('1537237662267519744','1537237660947901316','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-09-18 02:27:44','2018-09-18 02:27:44'),('1537239741764976828','1537239741751585800','123332','披萨','22.00',10,'http://xxsa.jpa','2018-09-18 03:02:23','2018-09-18 03:02:23'),('1537239741772181290','1537239741751585800','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-09-18 03:02:23','2018-09-18 03:02:23'),('1537253177727661601','1537253177718869334','123332','披萨','22.00',10,'http://xxsa.jpa','2018-09-18 04:20:06','2018-09-18 04:20:06'),('1537253177734761217','1537253177718869334','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-09-18 04:20:06','2018-09-18 04:20:06'),('1537253670442535748','1537253670434853110','123332','披萨','22.00',10,'http://xxsa.jpa','2018-09-18 04:28:19','2018-09-18 04:28:19'),('1537253670447528546','1537253670434853110','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-09-18 04:28:19','2018-09-18 04:28:19'),('1537256600387327473','1537256600378347340','123332','披萨','22.00',10,'http://xxsa.jpa','2018-09-18 05:20:41','2018-09-18 05:20:41'),('1537256600396294707','1537256600378347340','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-09-18 05:20:41','2018-09-18 05:20:41'),('1537256628927446956','1537256628920680118','123332','披萨','22.00',10,'http://xxsa.jpa','2018-09-18 05:21:12','2018-09-18 05:21:12'),('1537256628932922756','1537256628920680118','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-09-18 05:21:12','2018-09-18 05:21:12'),('1538038696187131049','1538038695608457748','123332','披萨','22.00',10,'http://xxsa.jpa','2018-09-27 06:36:06','2018-09-27 06:36:06'),('1538038696220484948','1538038695608457748','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-09-27 06:36:06','2018-09-27 06:36:06'),('1538038716070360396','1538038716063487586','123332','披萨','22.00',10,'http://xxsa.jpa','2018-09-27 06:36:28','2018-09-27 06:36:28'),('1538038716072710517','1538038716063487586','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-09-27 06:36:28','2018-09-27 06:36:28'),('1538038874864522757','1538038874799597805','123332','披萨','22.00',10,'http://xxsa.jpa','2018-09-27 06:39:20','2018-09-27 06:39:20'),('1538038874869472690','1538038874799597805','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-09-27 06:39:20','2018-09-27 06:39:20'),('1538990858793919558','1538990858156683632','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 07:07:09','2018-10-08 07:07:09'),('1538990858861172590','1538990858156683632','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 07:07:09','2018-10-08 07:07:09'),('1538991250726309564','1538991250253576254','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 07:14:13','2018-10-08 07:14:13'),('1538991250765438643','1538991250253576254','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 07:14:13','2018-10-08 07:14:13'),('1538991269219665146','1538991269209214895','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 07:14:33','2018-10-08 07:14:33'),('1538991269221817893','1538991269209214895','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 07:14:34','2018-10-08 07:14:34'),('1538991433297399259','1538991433024354074','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 07:17:31','2018-10-08 07:17:31'),('1538991433299571889','1538991433024354074','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 07:17:31','2018-10-08 07:17:31'),('1538992229833204682','1538992229343402910','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 07:31:54','2018-10-08 07:31:54'),('1538992229881863471','1538992229343402910','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 07:31:54','2018-10-08 07:31:54'),('1539045549360374048','1539045549348134290','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 07:59:26','2018-10-08 07:59:26'),('1539045549363103161','1539045549348134290','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 07:59:26','2018-10-08 07:59:26'),('1539045754262814344','1539045754247721696','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 08:03:08','2018-10-08 08:03:08'),('1539045754266941507','1539045754247721696','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 08:03:08','2018-10-08 08:03:08'),('1539045949076750557','1539045948212755738','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 08:06:39','2018-10-08 08:06:39'),('1539045949197182031','1539045948212755738','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 08:06:39','2018-10-08 08:06:39'),('1539046349522552116','1539046348321399540','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 08:13:53','2018-10-08 08:13:53'),('1539046349618440033','1539046348321399540','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 08:13:53','2018-10-08 08:13:53'),('1539046615009338589','1539046613710348386','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 08:18:40','2018-10-08 08:18:40'),('1539046615093541569','1539046613710348386','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 08:18:40','2018-10-08 08:18:40'),('1539046783228468772','1539046782123679306','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 08:21:43','2018-10-08 08:21:43'),('1539046783326199330','1539046782123679306','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 08:21:43','2018-10-08 08:21:43'),('1539046968909500018','1539046968054143236','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 08:25:04','2018-10-08 08:25:04'),('1539046968981887315','1539046968054143236','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 08:25:04','2018-10-08 08:25:04'),('1539047140903938246','1539047139973272817','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 08:28:10','2018-10-08 08:28:10'),('1539047141014219066','1539047139973272817','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 08:28:10','2018-10-08 08:28:10'),('1539047248614442992','1539047247600346142','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 08:30:07','2018-10-08 08:30:07'),('1539047248713161125','1539047247600346142','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 08:30:07','2018-10-08 08:30:07'),('1539047672070169292','1539047670822403944','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 08:37:46','2018-10-08 08:37:46'),('1539047672152107530','1539047670822403944','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 08:37:46','2018-10-08 08:37:46'),('1539047953692333502','1539047953661615924','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 08:42:51','2018-10-08 08:42:51'),('1539047953764489750','1539047953661615924','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 08:42:51','2018-10-08 08:42:51'),('1539048050962900711','1539048050951908848','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 08:44:36','2018-10-08 08:44:36'),('1539048050967925050','1539048050951908848','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 08:44:36','2018-10-08 08:44:36'),('1539070342150996253','1539070341399229758','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 12:38:22','2018-10-08 12:38:22'),('1539070342187955957','1539070341399229758','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 12:38:22','2018-10-08 12:38:22'),('1539070992680869933','1539070992167382579','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 12:50:07','2018-10-08 12:50:07'),('1539070992742539221','1539070992167382579','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 12:50:07','2018-10-08 12:50:07'),('1539072791833297681','1539072791364401780','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 13:22:36','2018-10-08 13:22:36'),('1539072791872370301','1539072791364401780','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 13:22:36','2018-10-08 13:22:36'),('1539072863730923496','1539072863031642294','123332','披萨','22.00',10,'http://xxsa.jpa','2018-10-08 13:23:54','2018-10-08 13:23:54'),('1539072863769226678','1539072863031642294','123456','皮蛋粥','18.00',5,'http://xxx.jpg','2018-10-08 13:23:54','2018-10-08 13:23:54');

/*Table structure for table `order_master` */

DROP TABLE IF EXISTS `order_master`;

CREATE TABLE `order_master` (
  `order_id` varchar(32) NOT NULL,
  `buyer_name` varchar(32) NOT NULL COMMENT '买家名称',
  `buyer_phone` varchar(32) NOT NULL COMMENT '买家电话',
  `buyer_address` varchar(128) NOT NULL COMMENT '买家地址',
  `buyer_openid` varchar(64) NOT NULL COMMENT '买家微信id',
  `order_amount` decimal(8,2) NOT NULL COMMENT '订单金额',
  `order_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '订单状态默认0新下单',
  `pay_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '支付状态默认0未支付',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`order_id`),
  KEY `idx_buyer_openid` (`buyer_openid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单表';

/*Data for the table `order_master` */

insert  into `order_master`(`order_id`,`buyer_name`,`buyer_phone`,`buyer_address`,`buyer_openid`,`order_amount`,`order_status`,`pay_status`,`create_time`,`update_time`) values ('1533632485017975195','余浩','12323212322','战府','110abc','22.00',1,0,'2018-08-07 07:23:23','2018-08-14 11:05:43'),('1533632877047575623','余浩','12323212322','战府','110abc','22.00',2,0,'2018-08-07 07:30:27','2018-08-16 12:38:24'),('1533633024919333162','余浩','12323212322','战府','110abc','58.00',0,0,'2018-08-07 07:33:08','2018-08-13 21:55:39'),('1533633052569571216','余浩','12323212322','战府','110abc','58.00',1,0,'2018-08-07 07:33:38','2018-08-13 21:57:08'),('1534383440704548840','aa','11111111111','aa','123','36.00',0,0,'2018-08-16 01:37:43','2018-08-16 01:37:43'),('1534383510085548238','yhao','11111111111','aaa','123','18.00',0,0,'2018-08-16 01:38:31','2018-08-16 01:38:31'),('1534383904471159599','zz','11111111111','zz','123','18.00',0,0,'2018-08-16 01:45:06','2018-08-16 01:45:06'),('1534384304550543241','dd','11111111111','dsadsa','123','18.00',0,0,'2018-08-16 01:51:46','2018-08-16 01:51:46'),('1534384543706542278','dsa','11111111111','dsasa','123','18.00',0,0,'2018-08-16 01:55:45','2018-08-16 01:55:45'),('1534384603826246641','21','11111111111','sa','123','18.00',0,0,'2018-08-16 01:56:45','2018-08-16 01:56:45'),('1534385959685872893','zz','11111111111','ddd','123','22.00',0,0,'2018-08-16 02:19:21','2018-08-16 02:19:21'),('1536719685510526273','余浩','110','枫林三路','abc123','198.00',0,0,'2018-09-11 15:03:55','2018-09-11 15:03:55'),('1536719789483426301','余浩','110','枫林三路','abc123','310.00',0,0,'2018-09-11 15:05:47','2018-09-11 15:05:47'),('1537177636192812510','余浩','110','枫林三路','abc123','310.00',0,0,'2018-09-17 07:28:43','2018-09-17 07:28:43'),('1537177736361163072','余浩','110','枫林三路','abc123','310.00',0,0,'2018-09-17 07:30:30','2018-09-17 07:30:30'),('1537234881965829662','余浩','110','枫林三路','abc123','310.00',0,0,'2018-09-18 01:41:26','2018-09-18 01:41:26'),('1537236448454577210','余浩','110','枫林三路','abc123','310.00',0,0,'2018-09-18 02:07:31','2018-09-18 02:07:31'),('1537237660947901316','余浩','110','枫林三路','abc123','310.00',0,0,'2018-09-18 02:27:44','2018-09-18 02:27:44'),('1537239741751585800','余浩','110','枫林三路','abc123','310.00',0,0,'2018-09-18 03:02:23','2018-09-18 03:02:23'),('1537253177718869334','余浩','110','枫林三路','abc123','310.00',0,0,'2018-09-18 04:20:06','2018-09-18 04:20:06'),('1537253670434853110','余浩','110','枫林三路','abc123','310.00',0,0,'2018-09-18 04:28:19','2018-09-18 04:28:19'),('1537256600378347340','余浩','110','枫林三路','abc123','310.00',0,0,'2018-09-18 05:20:41','2018-09-18 05:20:41'),('1537256628920680118','余浩','110','枫林三路','abc123','310.00',1,0,'2018-09-18 05:21:12','2018-09-27 05:56:14'),('1538038695608457748','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-09-27 06:36:06','2018-09-27 06:36:06'),('1538038716063487586','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-09-27 06:36:28','2018-09-27 06:36:28'),('1538038874799597805','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-09-27 06:39:20','2018-09-27 06:39:20'),('1538990858156683632','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 07:07:09','2018-10-08 07:07:09'),('1538991250253576254','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 07:14:13','2018-10-08 07:14:13'),('1538991269209214895','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 07:14:34','2018-10-08 07:14:34'),('1538991433024354074','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 07:17:31','2018-10-08 07:17:31'),('1538992229343402910','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 07:31:54','2018-10-08 07:31:54'),('1539045549348134290','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 07:59:26','2018-10-08 07:59:26'),('1539045754247721696','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 08:03:08','2018-10-08 08:03:08'),('1539045948212755738','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 08:06:39','2018-10-08 08:06:39'),('1539046348321399540','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 08:13:53','2018-10-08 08:13:53'),('1539046613710348386','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 08:18:40','2018-10-08 08:18:40'),('1539046782123679306','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 08:21:43','2018-10-08 08:21:43'),('1539046968054143236','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 08:25:04','2018-10-08 08:25:04'),('1539047139973272817','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 08:28:10','2018-10-08 08:28:10'),('1539047247600346142','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 08:30:07','2018-10-08 08:30:07'),('1539047670822403944','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 08:37:46','2018-10-08 08:37:46'),('1539047953661615924','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 08:42:51','2018-10-08 08:42:51'),('1539048050951908848','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 08:44:36','2018-10-08 08:44:36'),('1539070341399229758','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 12:38:22','2018-10-08 12:38:22'),('1539070992167382579','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 12:50:07','2018-10-08 12:50:07'),('1539072791364401780','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 13:22:36','2018-10-08 13:22:36'),('1539072863031642294','余浩','11011111111111111111111','枫林三路','abc123','310.00',0,0,'2018-10-08 13:23:54','2018-10-08 13:23:54');

/*Table structure for table `product_category` */

DROP TABLE IF EXISTS `product_category`;

CREATE TABLE `product_category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(64) NOT NULL COMMENT '类目名称',
  `category_type` int(11) NOT NULL COMMENT '类目编号',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`category_id`),
  UNIQUE KEY `uqe_category_type` (`category_type`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='商品类目表';

/*Data for the table `product_category` */

insert  into `product_category`(`category_id`,`category_name`,`category_type`,`create_time`,`update_time`) values (1,'热销榜1',2,'2018-08-06 03:39:26','2018-08-14 12:20:42'),(2,'男生最爱',3,'2018-08-06 03:41:17','2018-08-06 03:48:33'),(3,'dsa',1,'2018-08-14 12:21:08','2018-08-14 12:21:08');

/*Table structure for table `product_info` */

DROP TABLE IF EXISTS `product_info`;

CREATE TABLE `product_info` (
  `product_id` varchar(32) NOT NULL,
  `product_name` varchar(64) NOT NULL COMMENT '商品名称',
  `product_price` decimal(8,2) NOT NULL COMMENT '商品单价',
  `product_stock` int(11) NOT NULL COMMENT '库存',
  `product_description` varchar(64) DEFAULT NULL COMMENT '描述',
  `product_icon` varchar(512) DEFAULT NULL COMMENT '图片',
  `category_type` int(11) NOT NULL COMMENT '类目',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `product_status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '商品状态默认0上架',
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品表';

/*Data for the table `product_info` */

insert  into `product_info`(`product_id`,`product_name`,`product_price`,`product_stock`,`product_description`,`product_icon`,`category_type`,`create_time`,`update_time`,`product_status`) values ('123332','披萨','22.00',1860,'dsa','http://xxsa.jpa',3,'2018-08-07 02:48:55','2018-10-08 13:23:54',0),('123456','皮蛋粥','18.00',980,'dsa','http://xxx.jpg',2,'2018-08-07 01:30:15','2018-10-08 13:23:54',0),('12345622','肉夹馍','18.00',100,'dsdsaa','http://xxsx.jpg',2,'2018-08-07 01:56:53','2018-08-07 02:48:21',0),('1534324731503508898','fdsafdas','22.00',21,'22','http://xxx.jpg',2,'2018-08-14 12:16:26','2018-08-16 02:19:21',0);

/*Table structure for table `seller_info` */

DROP TABLE IF EXISTS `seller_info`;

CREATE TABLE `seller_info` (
  `id` varchar(32) NOT NULL,
  `username` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `openid` varchar(64) NOT NULL COMMENT 'openid',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `role` tinyint(1) NOT NULL COMMENT '1买家2卖家',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='卖家信息表';

/*Data for the table `seller_info` */

insert  into `seller_info`(`id`,`username`,`password`,`openid`,`create_time`,`update_time`,`role`) values ('1','admin','admin','abc','2018-08-16 05:09:06','2018-09-27 04:34:04',1);

/*Table structure for table `user_info` */

DROP TABLE IF EXISTS `user_info`;

CREATE TABLE `user_info` (
  `id` varchar(32) NOT NULL,
  `username` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `openid` varchar(64) NOT NULL COMMENT 'openid',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `role` tinyint(1) NOT NULL COMMENT '1买家2卖家',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户信息表';

/*Data for the table `user_info` */

insert  into `user_info`(`id`,`username`,`password`,`openid`,`create_time`,`update_time`,`role`) values ('1','123','123','abc','2018-09-27 04:53:20','2018-09-27 04:55:20',1),('2','123','123','123','2018-09-27 04:53:35','2018-09-27 05:05:16',2);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;