代码拉取完成,页面将自动刷新
/*
SQLyog Ultimate v11.33 (64 bit)
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 COMMENT '商品名称',
`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=utf8mb4 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 ('1212','123','1221','抹茶蛋糕','20.20',100,'1111.jpg','2017-12-03 09:59:21','2017-12-03 09:59:21'),('1512378794170993819','1512378793852215206','1221','抹茶蛋糕','20.20',1,'http://2232.jpg','2017-12-04 09:13:12','2017-12-04 09:13:12'),('1512378809985998159','1512378809914129805','1221','抹茶蛋糕','20.20',1,'http://2232.jpg','2017-12-04 09:13:28','2017-12-04 09:13:28'),('1512379153971631043','1512378867307709292','1221','抹茶蛋糕','20.20',1,'http://2232.jpg','2017-12-04 09:21:29','2017-12-04 09:21:29'),('1512379318205112346','1512379318146616858','1221','抹茶蛋糕','20.20',1,'http://2232.jpg','2017-12-04 09:21:56','2017-12-04 09:21:56'),('1512379401209455042','1512379379996740872','1221','抹茶蛋糕','20.20',1,'http://2232.jpg','2017-12-04 09:23:40','2017-12-04 09:23:40'),('1512379514455215411','1512379514399508460','1221','抹茶蛋糕','20.20',1,'http://2232.jpg','2017-12-04 09:25:12','2017-12-04 09:25:12'),('1512379789909690824','1512379788198353034','1221','抹茶蛋糕','20.20',1,'http://2232.jpg','2017-12-04 09:29:48','2017-12-04 09:29:48'),('1512379913089444065','1512379913026837195','1221','抹茶蛋糕','20.20',1,'http://2232.jpg','2017-12-04 09:31:51','2017-12-04 09:31:51'),('1512382592297584231','1512382590095672158','1221','抹茶蛋糕','20.20',1,'http://2232.jpg','2017-12-04 10:10:03','2017-12-04 10:10:03'),('1512382688513955060','1512382688440327788','1221','抹茶蛋糕','20.20',1,'http://2232.jpg','2017-12-04 10:10:03','2017-12-04 10:10:03'),('1512383139518626854','1512383139447962953','1221','抹茶蛋糕','20.20',1,'http://2232.jpg','2017-12-04 10:10:03','2017-12-04 10:10:03'),('1512383162225927905','1512383139447962953','123457','煎饺','8.90',2,'http://1wwdwees.jpg','2017-12-04 10:10:03','2017-12-04 10:10:03'),('1512464418942584471','1512464418893822327','1','皮蛋粥','8.90',2,'http://1wwdwees.jpg','2017-12-05 08:03:16','2017-12-05 08:03:16'),('1512464705005396211','1512464667913145241','1','皮蛋粥','8.90',2,'http://1wwdwees.jpg','2017-12-05 08:10:11','2017-12-05 08:10:11'),('1512465094655375129','1512465094613127010','1','皮蛋粥','8.90',2,'http://1wwdwees.jpg','2017-12-05 08:14:31','2017-12-05 08:14:31'),('1512465173039921850','1512465173030346332','1','皮蛋粥','8.90',2,'http://1wwdwees.jpg','2017-12-05 08:15:50','2017-12-05 08:15:50'),('1513692505664650416','1513692505661424611','1513587728259870519','大盘鸡','90.00',1,'/sell/pictures/default.jpg','2017-12-19 12:35:55','2017-12-19 12:35:55'),('1513692519001160578','1513692518996387443','1513587728259870519','大盘鸡','90.00',1,'/sell/pictures/default.jpg','2017-12-19 12:36:10','2017-12-19 12:36:10'),('1513692519364234063','1513692519358964735','1513587728259870519','大盘鸡','90.00',1,'/sell/pictures/default.jpg','2017-12-19 12:36:10','2017-12-19 12:36:10'),('1513692523347248961','1513692523341660144','1513587728259870519','大盘鸡','90.00',1,'/sell/pictures/default.jpg','2017-12-19 12:36:14','2017-12-19 12:36:14'),('1513692599882237093','1513692599870294115','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-19 12:37:37','2017-12-19 12:37:37'),('1513692602106308415','1513692602101372795','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-19 12:37:40','2017-12-19 12:37:40'),('1513692602920905497','1513692602916317319','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-19 12:37:41','2017-12-19 12:37:41'),('1513692603601961183','1513692603594817523','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-19 12:37:41','2017-12-19 12:37:41'),('1513692661905390902','1513692661897399599','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-19 12:38:45','2017-12-19 12:38:45'),('1513692675780341411','1513692675776989414','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-19 12:39:00','2017-12-19 12:39:00'),('1513692779251769537','1513692779240386260','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-19 12:40:52','2017-12-19 12:40:52'),('1513692786985809615','1513692786981548826','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-19 12:41:00','2017-12-19 12:41:00'),('1513692917094389839','1513692917090307955','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-19 12:43:21','2017-12-19 12:43:21'),('1513735563499981126','1513735563491362618','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-20 02:06:02','2017-12-20 02:06:02'),('1513735741420608266','1513735741162925682','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-20 02:09:00','2017-12-20 02:09:00'),('1513736028362179738','1513736028358145594','1513587728259870519','大盘鸡','90.00',2,'/sell/pictures/default.jpg','2017-12-20 02:13:47','2017-12-20 02:13:47'),('1513736038671103404','1513736038639550445','1513587728259870519','大盘鸡','90.00',2,'/sell/pictures/default.jpg','2017-12-20 02:13:57','2017-12-20 02:13:57'),('1513737516461304228','1513737516453451323','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-20 02:38:35','2017-12-20 02:38:35'),('1513737528155351280','1513737528153346558','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-20 02:38:47','2017-12-20 02:38:47'),('1513737533049876431','1513737533043705123','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-20 02:38:52','2017-12-20 02:38:52'),('1513737533918867877','1513737533911861286','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-20 02:38:53','2017-12-20 02:38:53'),('1513737985127671879','1513737985123201170','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-20 02:46:24','2017-12-20 02:46:24'),('1513738038211398566','1513738038180606138','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-20 02:47:17','2017-12-20 02:47:17'),('1513738074940868277','1513738074933411287','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-20 02:47:54','2017-12-20 02:47:54'),('1513738311165806531','1513738311161292597','','碳烤鳊鱼','12.00',1,'','2017-12-20 02:51:50','2017-12-20 02:51:50'),('1513738388725981802','1513738388686371547','','碳烤鳊鱼','12.00',1,'','2017-12-20 02:53:07','2017-12-20 02:53:07'),('1513738635469475286','1513738635465833460','1513587728259870519','大盘鸡','90.00',2,'/sell/pictures/default.jpg','2017-12-20 02:57:14','2017-12-20 02:57:14'),('1513739319293805931','1513739319285311012','','碳烤鳊鱼','12.00',1,'','2017-12-20 03:08:38','2017-12-20 03:08:38'),('1513739418185837484','1513739418176533150','','碳烤鳊鱼','12.00',1,'','2017-12-20 03:10:17','2017-12-20 03:10:17'),('1513739472981865103','1513739472947215055','','碳烤鳊鱼','12.00',1,'','2017-12-20 03:11:12','2017-12-20 03:11:12'),('1513739544242699615','1513739544235426718','1513587577587281492','大闸蟹','11.00',1,'','2017-12-20 03:12:23','2017-12-20 03:12:23'),('1513739664883757705','1513739664879511015','1513587577587281492','大闸蟹','11.00',1,'','2017-12-20 03:14:24','2017-12-20 03:14:24'),('1513739796565674869','1513739796556664117','1513587577587281492','大闸蟹','11.00',1,'','2017-12-20 03:16:35','2017-12-20 03:16:35'),('1513759251837400580','1513759251829517284','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-20 06:17:56','2017-12-20 06:17:56'),('1513760053181922365','1513760053173268812','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-20 06:32:24','2017-12-20 06:32:24'),('1513760193664961584','1513760193656524829','1513587577587281492','大闸蟹','11.00',1,'','2017-12-20 06:34:56','2017-12-20 06:34:56'),('1513760990870380487','1513760990862189042','1513587728259870519','大盘鸡','90.00',1,'/sell/pictures/default.jpg','2017-12-20 06:49:20','2017-12-20 06:49:20'),('1513761121263118124','1513761121259498217','','碳烤鳊鱼','12.00',1,'','2017-12-20 06:52:30','2017-12-20 06:52:30'),('1513761121263899833','1513761121259441625','','碳烤鳊鱼','12.00',1,'','2017-12-20 06:52:30','2017-12-20 06:52:30'),('1513761179205503183','1513761179202961013','','碳烤鳊鱼','12.00',1,'','2017-12-20 06:52:44','2017-12-20 06:52:44'),('1513823714057568595','1513823714049314556','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-21 02:35:13','2017-12-21 02:35:13'),('1513823993657667941','1513823993650916602','1513587728259870519','大盘鸡','90.00',1,'/sell/pictures/default.jpg','2017-12-21 02:39:52','2017-12-21 02:39:52'),('1513824293905523560','1513824293898839988','1513587577587281492','大闸蟹','11.00',1,'','2017-12-21 02:44:53','2017-12-21 02:44:53'),('1513824328558886902','1513824328558975916','123457','煎饺','8.90',1,'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg','2017-12-21 02:45:27','2017-12-21 02:45:27'),('1513824551072213928','1513824551064758063','1513587728259870519','大盘鸡','90.00',1,'/sell/pictures/default.jpg','2017-12-21 02:49:10','2017-12-21 02:49:10');
/*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 '买家微信openId',
`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=utf8mb4 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 ('123','小明','18764537334','NJUPT','111111','8.90',2,1,'2017-12-03 09:29:32','2017-12-03 09:47:32'),('12345','小明','18764537334','NJUPT','111111','8.90',0,1,'2017-12-03 09:43:08','2017-12-03 09:43:08'),('1512379514399508460','XJL','111111111','NJUPT','qwqqwqwqqwqwq','20.20',2,1,'2017-12-04 09:25:29','2017-12-04 09:25:29'),('1512379788198353034','XJL','111111111','NJUPT','qwqqwqwqqwqwq','20.20',2,1,'2017-12-04 09:30:16','2017-12-04 09:30:16'),('1512382688440327788','XJL','111111111','NJUPT','qwqqwqwqqwqwq','20.20',2,0,'2017-12-04 10:10:03','2017-12-04 10:10:03'),('1512383139447962953','XJLll','111111111','NJUPT','qwqqwqwqqwqwq','38.00',2,1,'2017-12-04 10:10:03','2017-12-05 03:41:19'),('1512465173030346332','张三','123121212','njupt','o97tn1TR6883y7GKzEiwBSGo9g0w','17.80',2,0,'2017-12-05 08:15:50','2017-12-19 12:43:50'),('1513692505661424611','哈哈','1876662222','Njupt','o97tn1TR6883y7GKzEiwBSGo9g0w','90.00',0,0,'2017-12-19 12:35:55','2017-12-19 12:35:55'),('1513692518996387443','哈哈','1876662222','Njupt','o97tn1TR6883y7GKzEiwBSGo9g0w','90.00',0,0,'2017-12-19 12:36:10','2017-12-19 12:36:10'),('1513692519358964735','哈哈','1876662222','Njupt','o97tn1TR6883y7GKzEiwBSGo9g0w','90.00',0,0,'2017-12-19 12:36:10','2017-12-19 12:36:10'),('1513692523341660144','哈哈','1876662222','Njupt','o97tn1TR6883y7GKzEiwBSGo9g0w','90.00',0,0,'2017-12-19 12:36:14','2017-12-19 12:36:14'),('1513692599870294115','Y','Wty','Dfgygcdg','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-19 12:37:37','2017-12-19 12:37:37'),('1513692602101372795','Y','Wty','Dfgygcdg','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-19 12:37:40','2017-12-19 12:37:40'),('1513692602916317319','Y','Wty','Dfgygcdg','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-19 12:37:41','2017-12-19 12:37:41'),('1513692603594817523','Y','Wty','Dfgygcdg','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-19 12:37:41','2017-12-19 12:37:41'),('1513692661897399599','F','18765642887','Cfhgt','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-19 12:38:45','2017-12-19 12:38:45'),('1513692675776989414','F','18765642887','Cfhgt','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-19 12:39:00','2017-12-19 12:39:00'),('1513692779240386260','E','12123454555','Df','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-19 12:40:52','2017-12-19 12:40:52'),('1513692786981548826','E','12123454555','Df','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-19 12:41:00','2017-12-19 12:41:00'),('1513692917090307955','刘海','18765647668','南京市江宁区','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-19 12:43:21','2017-12-19 12:43:21'),('1513735563491362618','啊啦','18557527443','j南京市江宁区','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-20 02:06:02','2017-12-20 02:06:02'),('1513735741162925682','啊啦','18557527443','j南京市江宁区','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-20 02:09:00','2017-12-20 02:09:00'),('1513736028358145594','小米','18642751558','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','180.00',0,0,'2017-12-20 02:13:47','2017-12-20 02:13:47'),('1513736038639550445','小米','18642751558','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','180.00',0,0,'2017-12-20 02:13:57','2017-12-20 02:13:57'),('1513737516453451323','小明','18476641616','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-20 02:38:35','2017-12-20 02:38:35'),('1513737528153346558','小明','18476641616','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-20 02:38:47','2017-12-20 02:38:47'),('1513737533043705123','小明','18476641616','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-20 02:38:52','2017-12-20 02:38:52'),('1513737533911861286','小明','18476641616','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-20 02:38:53','2017-12-20 02:38:53'),('1513737985123201170','鲜蘑','18465157558','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-20 02:46:24','2017-12-20 02:46:24'),('1513738038180606138','鲜蘑','18465157558','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-20 02:47:17','2017-12-20 02:47:17'),('1513738074933411287','鲜蘑','18465157558','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-20 02:47:54','2017-12-20 02:47:54'),('1513738311161292597','小米','18562567335','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','12.00',0,0,'2017-12-20 02:51:50','2017-12-20 02:51:50'),('1513738388686371547','小米','18562567335','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','12.00',0,0,'2017-12-20 02:53:07','2017-12-20 02:53:07'),('1513738635465833460','难得','15852544','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','180.00',0,0,'2017-12-20 02:57:14','2017-12-20 02:57:14'),('1513739319285311012','小明','18761657558','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','12.00',0,0,'2017-12-20 03:08:38','2017-12-20 03:08:38'),('1513739418176533150','小明','18761657558','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','12.00',0,0,'2017-12-20 03:10:17','2017-12-20 03:10:17'),('1513739472947215055','小明','18761657558','南京市鼓楼区','o97tn1TR6883y7GKzEiwBSGo9g0w','12.00',0,0,'2017-12-20 03:11:12','2017-12-20 03:11:12'),('1513739544235426718','小明','18761657558','南京邮电大学','o97tn1TR6883y7GKzEiwBSGo9g0w','11.00',0,0,'2017-12-20 03:12:23','2017-12-20 03:12:23'),('1513739664879511015','小明','18761657558','南京邮电大学','o97tn1TR6883y7GKzEiwBSGo9g0w','11.00',0,0,'2017-12-20 03:14:24','2017-12-20 03:14:24'),('1513739796556664117','张扬','18356156808','南京邮电大学','o97tn1TR6883y7GKzEiwBSGo9g0w','11.00',0,0,'2017-12-20 03:16:35','2017-12-20 03:16:35'),('1513759251829517284','几何','19846467558','南京邮电大学','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-20 06:17:56','2017-12-20 06:17:56'),('1513760053173268812','小明','18761657558','南京邮电部门','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-20 06:32:24','2017-12-20 06:32:24'),('1513760193656524829','小黄','18256156808','南京邮电部门','o97tn1TR6883y7GKzEiwBSGo9g0w','11.00',0,0,'2017-12-20 06:34:56','2017-12-20 06:34:56'),('1513760990862189042','小明英语毕业','18661656808','南京邮电大学','o97tn1TR6883y7GKzEiwBSGo9g0w','90.00',0,0,'2017-12-20 06:49:20','2017-12-20 06:49:20'),('1513761121259441625','小新','18661657558','南京市江宁区','o97tn1TR6883y7GKzEiwBSGo9g0w','12.00',0,0,'2017-12-20 06:52:30','2017-12-20 06:52:30'),('1513761121259498217','小新','18661657558','南京市江宁区','o97tn1TR6883y7GKzEiwBSGo9g0w','12.00',0,0,'2017-12-20 06:52:30','2017-12-20 06:52:30'),('1513761179202961013','小新','18661657558','南京市江宁区','o97tn1TR6883y7GKzEiwBSGo9g0w','12.00',0,0,'2017-12-20 06:52:44','2017-12-20 06:52:44'),('1513823714049314556','早早','18764657336','南京邮电部门','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-21 02:35:13','2017-12-21 02:35:13'),('1513823993650916602','小明','18356156808','淮北市','o97tn1TR6883y7GKzEiwBSGo9g0w','90.00',0,0,'2017-12-21 02:39:52','2017-12-21 02:39:52'),('1513824293898839988','小红','18656156808','南京市鼓楼区中山北路','o97tn1TR6883y7GKzEiwBSGo9g0w','11.00',0,0,'2017-12-21 02:44:53','2017-12-21 02:44:53'),('1513824328558975916','一抹','18764675788','南京市玄武区','o97tn1TR6883y7GKzEiwBSGo9g0w','8.90',0,0,'2017-12-21 02:45:27','2017-12-21 02:45:27'),('1513824551064758063','杠杠','18761568556','南京市鼓楼区湖南路','o97tn1TR6883y7GKzEiwBSGo9g0w','90.00',0,1,'2017-12-21 02:49:10','2017-12-21 02:49:10');
/*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=10 DEFAULT CHARSET=utf8mb4 COMMENT='类目表';
/*Data for the table `product_category` */
insert into `product_category`(`category_id`,`category_name`,`category_type`,`create_time`,`update_time`) values (1,'大胸妹子最爱',1,'2017-12-02 17:22:38','2017-12-18 11:42:10'),(3,'女生最爱',3,'2017-12-02 11:33:22','2017-12-02 11:33:22'),(7,'男1生最爱',4,'2017-12-02 11:47:07','2017-12-02 11:47:07'),(8,'美女专项',2,'2017-12-02 12:32:47','2017-12-02 12:32:47'),(9,'妹妹',5,'2017-12-18 11:40:56','2017-12-18 11:40:56');
/*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` int(11) NOT NULL,
PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 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 ('','碳烤鳊鱼','12.00',15,'好吃的鳊鱼','',3,'2017-12-18 08:44:14','2017-12-20 06:52:44',0),('1','皮蛋粥','8.90',1000,'皮蛋瘦肉粥','https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3218312129,436663849&fm=27&gp=0.jpg',3,'2017-12-02 13:39:23','2017-12-18 07:56:27',1),('1221','抹茶蛋糕','20.20',206,'好吃的蛋糕','http://ww1.sinaimg.cn/large/9ec19de8gw1eovh8nh9txj20vi18gwgz.jpg',2,'2017-12-03 14:07:07','2017-12-18 06:02:48',1),('123457','煎饺','8.90',90,'好吃的煎饺','https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=3760261115,86045368&fm=27&gp=0.jpg',3,'2017-12-02 14:22:14','2017-12-21 02:45:27',0),('1513587577587281492','大闸蟹','11.00',6,'好吃的打喳喳','',2,'2017-12-18 08:46:51','2017-12-21 02:44:53',0),('1513587728259870519','大盘鸡','90.00',77,'','/sell/pictures/default.jpg',1,'2017-12-18 08:49:34','2017-12-21 02:49:10',0);
/*Table structure for table `seller_info` */
DROP TABLE IF EXISTS `seller_info`;
CREATE TABLE `seller_info` (
`seller_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 COMMENT '修改时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='卖家信息表';
/*Data for the table `seller_info` */
insert into `seller_info`(`seller_id`,`username`,`password`,`openid`,`create_time`,`update_time`) values ('1513606653140335055','root','123456','123','2017-12-18 13:52:34','2017-12-18 13:52:34');
/*!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 */;
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。