/*
SQLyog Ultimate v12.3.1 (64 bit)
MySQL - 5.7.18-cynos-log : Database - ssmp-wx-order
*********************************************************************
*/

/*!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*/`ssmp-wx-order` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `ssmp-wx-order`;

/*Table structure for table `order_comments` */

DROP TABLE IF EXISTS `order_comments`;

CREATE TABLE `order_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  `product_name` varchar(80) DEFAULT NULL,
  `order_sn` varchar(50) DEFAULT NULL,
  `content` varchar(100) DEFAULT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `star` int(5) DEFAULT NULL,
  `image_src` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `order_comments` */

/*Table structure for table `orders` */

DROP TABLE IF EXISTS `orders`;

CREATE TABLE `orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(50) DEFAULT NULL,
  `pay_sn` varchar(50) DEFAULT NULL,
  `real_name` varchar(60) DEFAULT NULL COMMENT '收件人',
  `address` varchar(100) DEFAULT NULL COMMENT '收件人地址',
  `mobile` varchar(50) DEFAULT NULL COMMENT '电话',
  `order_money` decimal(10,2) DEFAULT NULL,
  `distinct_money` decimal(10,2) DEFAULT NULL,
  `order_status` char(1) DEFAULT NULL,
  `member_id` int(11) DEFAULT NULL,
  `source` char(1) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8;

/*Data for the table `orders` */

insert  into `orders`(`id`,`order_sn`,`pay_sn`,`real_name`,`address`,`mobile`,`order_money`,`distinct_money`,`order_status`,`member_id`,`source`,`create_time`) values 
(33,'5691572197226025','77432372570345495910','李四','天津 河北区 全境天河家园','18311369014',13.50,NULL,'8',7,'1','2021-03-30 16:21:42'),
(34,'4753950890161339','19422029113785868716','李四','天津 河北区 全境天河家园','18311369014',14.90,NULL,'8',7,'1','2021-03-30 16:30:13'),
(35,'2850249262327724','04107904626773041807','哈哈','上海 虹口区 城区208','15821470061',19.90,NULL,'8',14,'1','2021-03-31 11:21:19'),
(36,'5717241044469340','41155556464914223450','哈哈','上海 虹口区 城区208','15821470061',19.90,NULL,'8',14,'1','2021-03-31 11:21:20'),
(37,'3268831500352759','37456806858031048326','李四','天津 河北区 全境天河家园','18311369014',25.90,NULL,'8',7,'1','2021-04-01 11:07:44'),
(38,'2637981635282688','05655286476168480856','李四','天津 河北区 全境天河家园','18311369014',25.90,NULL,'8',7,'1','2021-04-02 09:28:05'),
(39,'5530582643961246','53237314738866871659','WeiKang Xuan','山西 太原市 迎泽区江苏南京奥术大师大所','15365166563',7.90,NULL,'8',12,'1','2021-04-02 15:05:38'),
(40,'7889812722950440','47426022891253680840','李四','天津 河北区 全境天河家园','18311369014',25.90,NULL,'8',7,'1','2021-04-02 15:42:51'),
(41,'7872157292489314','64972607999337504220','李四','天津 河北区 全境天河家园','18311369014',13.50,NULL,'8',7,'1','2021-04-02 16:20:57'),
(42,'9414867739177768','96235261567835526076','李四','天津 河北区 全境天河家园','18311369014',19.90,NULL,'8',7,'1','2021-04-02 16:30:20'),
(43,'6321067180591172','59702859679885478803','李四','天津 河北区 全境天河家园','18311369014',409.80,NULL,'8',7,'1','2021-04-02 17:34:57'),
(44,'7462727395134124','30357582928104475625','李四','天津 河北区 全境天河家园','18311369014',13.50,NULL,'8',7,'1','2021-04-02 17:56:09'),
(45,'2403905531394366','58522370107409143144','张三','北京 密云区 城区以外弄11','18311369014',25.90,NULL,'8',7,'1','2021-04-02 17:59:31'),
(46,'6812012880202462','09676755190456434929','张三','北京 密云区 城区以外弄11','18311369014',7.90,NULL,'8',7,'1','2021-04-02 18:02:05'),
(47,'0633820620366442','96923402517620459448','ww','重庆 开县 天和镇无','18315097713',19.90,NULL,'8',16,'1','2021-04-03 21:11:58'),
(48,'4344597086856861','17907035336575402731','张三','北京 密云区 城区以外弄11','18311369014',6.90,NULL,'8',7,'1','2021-04-04 09:20:34'),
(49,'9596102831624816','04456664572841452693','ww','重庆 开县 天和镇无','18315097713',25.90,NULL,'8',16,'1','2021-04-04 11:18:34'),
(50,'7237301825945400','56953482863330790637','ww','重庆 开县 天和镇无','18315097713',15.50,NULL,'8',16,'1','2021-04-04 11:31:19'),
(51,'0330374197033979','92249151304140639668','张三','北京 密云区 城区以外弄11','18311369014',173.60,NULL,'8',7,'1','2021-04-07 10:30:21'),
(52,'1522851931857844','90962432995668900819','哈哈','上海 虹口区 城区208','15821470061',47.90,NULL,'8',14,'1','2021-04-07 16:36:37'),
(53,'0520879618633849','02547210014631842103','张三','北京 密云区 城区以外弄11','18311369014',22.80,NULL,'8',7,'1','2021-04-08 10:16:29'),
(54,'6057503188485659','23356578609421357252','lxl','北京 昌平区 六环以内无','13935812714',74.50,NULL,'8',18,'1','2021-04-08 16:16:20'),
(55,'2063878006209227','09511099919923588076','lxl','北京 昌平区 六环以内无','13935812714',17.90,NULL,'8',18,'1','2021-04-08 16:18:54'),
(56,'6453320106010150','83051902327378237285','李四','天津 河北区 全境天河家园','18311369014',7.90,NULL,'8',7,'1','2021-04-13 15:32:54'),
(57,'1705304429343716','93650319560559629677','李四','天津 河北区 全境天河家园','18311369014',7.90,NULL,'8',7,'1','2021-04-13 15:33:14'),
(58,'8395945225312788','38680085446756289518','李四','天津 河北区 全境天河家园','18311369014',36.90,NULL,'8',7,'1','2021-04-13 15:33:24'),
(59,'4169542496748970','01581662279043283155','李四','天津 河北区 全境天河家园','18311369014',219.00,NULL,'8',7,'1','2021-04-13 16:55:41'),
(60,'9063292178033973','36754399178219948223','李四','天津 河北区 全境天河家园','18311369014',36.90,NULL,'8',7,'1','2021-04-19 10:18:27'),
(61,'7374751160849222','24389288695037330212','李四','天津 河北区 全境天河家园','18311369014',36.90,NULL,'8',7,'1','2021-04-19 10:22:16'),
(62,'7385921134377548','10913223776605525103','李四','天津 河北区 全境天河家园','18311369014',36.90,NULL,'8',7,'1','2021-04-21 09:10:24'),
(63,'1994374216513834','26917446275270433807','李四','天津 河北区 全境天河家园','18311369014',51.79,NULL,'8',7,'1','2021-04-21 09:29:13'),
(64,'7526288781124102','40648197057256415896','李四','天津 河北区 全境天河家园','18311369014',0.99,NULL,'8',7,'1','2021-04-21 09:37:28'),
(65,'1852952652974029','56292480713075914034','李四','天津 河北区 全境天河家园','18311369014',0.99,NULL,'8',7,'1','2021-04-21 09:44:54'),
(66,'3415902672949428','29170982278074181327','李四','天津 河北区 全境天河家园','18311369014',0.99,NULL,'8',7,'1','2021-04-21 09:45:32'),
(67,'0028157270426807','72539180672512608238','李四','天津 河北区 全境天河家园','18311369014',0.99,NULL,'8',7,'1','2021-04-21 10:26:19'),
(68,'5552038980236298','24086096772408364949','李四','天津 河北区 全境天河家园','18311369014',14.90,NULL,'8',7,'1','2021-04-21 12:04:27'),
(69,'8750215429743571','90624171710292624922','哈哈','上海 虹口区 城区208','15821470061',6.90,NULL,'8',14,'1','2021-04-21 15:29:28'),
(70,'5499900793308263','58814835601159205846','北京','北京 大兴区 六环以外黄村','18701357232',0.99,NULL,'8',22,'1','2021-04-24 19:30:11'),
(71,'0409359014604139','95580091322571733105','北京','北京 大兴区 六环以外黄村','18701357232',0.99,NULL,'8',22,'1','2021-04-24 19:30:28'),
(72,'2015299918924429','67186268325257534398','北京','北京 大兴区 六环以外黄村','18701357232',0.99,NULL,'8',22,'1','2021-04-25 07:52:28'),
(73,'6178371162637210','68898157765211005863','贾宝玉','上海 闸北区 城区顾村公园','18311369014',36.90,NULL,'8',7,'1','2021-04-25 14:10:42'),
(74,'4394786078824795','24204031690708206066','贾宝玉','上海 闸北区 城区顾村公园','18311369014',44.70,NULL,'8',7,'1','2021-04-25 14:38:11'),
(75,'8522822320999719','26424257048341179908','12123','上海 闸北区 城区111','18824250377',25.90,NULL,'8',29,'1','2021-05-06 11:18:52'),
(76,'1860390520158348','08733162082747360838','12123','上海 闸北区 城区111','18824250377',25.90,NULL,'8',29,'1','2021-05-06 11:18:54'),
(77,'6286305466194316','71428342825065813551','王志胜','黑龙江 大庆市 萨尔图区东北石油大学启智','15765964640',19.00,NULL,'8',30,'1','2021-05-08 09:40:59'),
(78,'5781411721981379','31956105517031364154','啊啊啊','天津 河北区 全境两居室','15853227323',31.00,NULL,'8',32,'1','2021-05-11 16:41:41'),
(79,'9769423538910969','52401506591277884036','贾宝玉','上海 闸北区 城区顾村公园','18311369014',15.80,NULL,'8',7,'1','2021-05-17 17:08:24'),
(80,'1241584148473782','58494585993085008688','贾宝玉','上海 闸北区 城区顾村公园','18311369014',15.80,NULL,'8',7,'1','2021-05-17 17:08:26'),
(81,'0577677134006115','70803546085089383508','let go','陕西 铜川市 宜君县北大青鸟','13999999999',39.80,NULL,'8',34,'1','2021-05-19 09:30:40'),
(82,'6050104744088760','02329642822625516644','let go','陕西 铜川市 宜君县北大青鸟','13999999999',36.90,NULL,'8',34,'1','2021-05-19 11:59:48'),
(83,'9941966817647225','59292574512577169692','dd','上海 闸北区 城区ddd','15882770173',13.50,NULL,'8',35,'1','2021-05-19 14:48:56'),
(84,'4686164465282314','29250509006061374667','dd','上海 闸北区 城区ddd','15882770173',409.80,NULL,'8',35,'1','2021-05-19 14:50:07'),
(85,'8658946689811205','97682847726442792696','let go','陕西 铜川市 宜君县北大青鸟','13999999999',13.50,NULL,'8',34,'1','2021-05-19 16:09:04'),
(86,'2542910410944881','75148567310800484295','let go','陕西 铜川市 宜君县北大青鸟','13999999999',7.90,NULL,'8',34,'1','2021-05-19 16:09:31'),
(87,'5716874922828155','01490800569887391397','贾宝玉','上海 闸北区 城区顾村公园','18311369014',29.90,NULL,'8',7,'1','2021-05-19 16:10:04'),
(88,'7514809858191760','22068999710477268273','贾宝玉','上海 闸北区 城区顾村公园','18311369014',36.90,NULL,'8',7,'1','2021-05-19 16:16:18'),
(89,'8281344301369459','92569429825333213716','贾宝玉','上海 闸北区 城区顾村公园','18311369014',36.90,NULL,'2',7,'1','2021-05-19 16:23:22'),
(90,'3618152666472121','22309497818354819523','贾宝玉','上海 闸北区 城区顾村公园','18311369014',13.90,NULL,'2',7,'1','2021-05-20 10:14:47'),
(91,'6692748811573391','90089587979549334218','贾宝玉','上海 闸北区 城区顾村公园','18311369014',14.90,NULL,'2',7,'1','2021-05-20 11:13:07'),
(92,'1571057010920486','74950617351106976907','贾宝玉','上海 闸北区 城区顾村公园','18311369014',440.30,NULL,'2',7,'1','2021-05-20 11:13:57'),
(93,'7541565252646442','30427810147715949795','贾宝玉','上海 闸北区 城区顾村公园','18311369014',14.90,NULL,'2',7,'1','2021-05-20 11:31:59'),
(94,'9223060532008552','61151719783946941220','贾宝玉','上海 闸北区 城区顾村公园','18311369014',25.90,NULL,'2',7,'1','2021-05-21 10:07:14'),
(95,'9984093994637081','98535704063067046219','fan fan','上海 静安区 城区fanfanfanfanfanfanfanfanfanfanfanfanfanfan','18994333979',15.50,NULL,'2',36,'1','2021-05-25 10:24:24'),
(96,'6980638622368085','55986652375544849999','爱平','湖南 长沙市 岳麓区马王堆','18874934626',14.90,NULL,'2',37,'1','2021-05-26 16:10:38'),
(97,'5945538071302451','19430375460480642592','贾宝玉','上海 闸北区 城区顾村公园','18311369014',13.50,NULL,'1',7,'1','2021-05-27 16:40:40'),
(98,'2781314479739605','03289596449393219467','贾宝玉','上海 闸北区 城区顾村公园','18311369014',13.50,NULL,'1',7,'1','2021-05-27 16:42:16'),
(99,'2604973230678885','36852401709560266686','贾宝玉','上海 闸北区 城区顾村公园','18311369014',13.50,NULL,'1',7,'1','2021-05-27 16:48:22'),
(100,'9222927192797794','40247163124196649985','贾宝玉','上海 闸北区 城区顾村公园','18311369014',13.50,NULL,'1',7,'1','2021-05-27 17:02:26'),
(101,'3150295938234221','54525961713001336029','贾宝玉','上海 闸北区 城区顾村公园','18311369014',13.50,NULL,'1',7,'1','2021-05-27 17:23:28'),
(102,'4427932985864868','49248331947466781830','贾宝玉','上海 闸北区 城区顾村公园','18311369014',13.50,NULL,'1',7,'1','2021-05-27 17:23:30'),
(103,'9081731995892012','53627052885141317114','贾宝玉','上海 闸北区 城区顾村公园','18311369014',13.50,NULL,'1',7,'1','2021-05-27 17:30:33'),
(104,'7646460008591275','57559740172184243931','贾宝玉','上海 闸北区 城区顾村公园','18311369014',27.00,NULL,'1',7,'1','2021-05-27 17:53:24'),
(105,'2373377998688361','38549363553460598529','贾宝玉','上海 闸北区 城区顾村公园','18311369014',27.00,NULL,'1',7,'1','2021-05-27 17:53:35'),
(106,'2374024606840415','33723128467255926742','贾宝玉','上海 闸北区 城区顾村公园','18311369014',27.00,NULL,'1',7,'1','2021-05-27 18:02:31'),
(107,'7078136649281868','20750966884370773171','贾宝玉','上海 闸北区 城区顾村公园','18311369014',27.00,NULL,'1',7,'1','2021-05-27 18:02:42'),
(108,'9782999710723315','18960526306767181342','贾宝玉','上海 闸北区 城区顾村公园','18311369014',40.50,NULL,'1',7,'1','2021-05-27 18:21:05'),
(109,'7588884518290009','29155320034113699906','贾宝玉','上海 闸北区 城区顾村公园','18311369014',40.50,NULL,'1',7,'1','2021-05-27 18:23:19'),
(110,'1969306473635917','00518840872266689358','贾宝玉','上海 闸北区 城区顾村公园','18311369014',40.50,NULL,'1',7,'1','2021-05-27 18:23:34'),
(111,'5402528767354616','59305201233330925401','贾宝玉','上海 闸北区 城区顾村公园','18311369014',39.90,NULL,'1',7,'1','2021-05-28 08:23:54'),
(112,'5573057669729983','13810530175417495660','贾宝玉','上海 闸北区 城区顾村公园','18311369014',39.90,NULL,'1',7,'1','2021-05-28 09:08:36'),
(113,'1884941658532479','75623861225064804086','贾宝玉','上海 闸北区 城区顾村公园','18311369014',39.90,NULL,'1',7,'1','2021-05-28 09:27:17'),
(114,'1552724100529987','68227220161948842131','贾宝玉','上海 闸北区 城区顾村公园','18311369014',79.80,NULL,'1',7,'1','2021-05-28 10:13:09'),
(115,'4022022736825929','61891617082371691053','贾宝玉','上海 闸北区 城区顾村公园','18311369014',79.80,NULL,'1',7,'1','2021-05-28 10:15:30'),
(116,'3310980106301497','42496401297566503099','贾宝玉','上海 闸北区 城区顾村公园','18311369014',79.80,NULL,'1',7,'1','2021-05-28 10:29:10'),
(117,'1639177339495874','17445224958478266765','贾宝玉','上海 闸北区 城区顾村公园','18311369014',79.80,NULL,'1',7,'1','2021-05-28 10:30:11'),
(118,'3434406074517303','01545377614114654301','李四','天津 河北区 全境天河家园','18311369014',29.90,NULL,'1',7,'1','2021-05-28 10:32:10'),
(119,'4205176047542476','89597734812776742803','李四','天津 河北区 全境天河家园','18311369014',29.90,NULL,'1',7,'1','2021-05-28 10:47:16'),
(120,'8540158215561509','84209418171286312795','李四','天津 河北区 全境天河家园','18311369014',54.00,NULL,'1',7,'1','2021-05-28 11:01:50');

/*Table structure for table `orders_product` */

DROP TABLE IF EXISTS `orders_product`;

CREATE TABLE `orders_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(50) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `product_name` varchar(100) DEFAULT NULL,
  `product_price` decimal(10,2) DEFAULT NULL,
  `product_number` int(11) DEFAULT NULL,
  `product_money` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8;

/*Data for the table `orders_product` */

insert  into `orders_product`(`id`,`order_sn`,`product_id`,`product_name`,`product_price`,`product_number`,`product_money`) values 
(11,'5691572197226025',423,'A级-佳沛金奇异果（大）1个',19.90,1,19.90),
(12,'5691572197226025',543,'A级-西柚中（个）1个/约300g',13.50,3,40.50),
(13,'4753950890161339',466,'A级-进口银火龙果（大）-1个/600-650g',14.90,1,14.90),
(14,'2850249262327724',423,'A级-佳沛金奇异果（大）1个',19.90,1,19.90),
(15,'3268831500352759',517,'B级-沙糖桔（中）1份/不少于250g',0.99,1,0.99),
(16,'3268831500352759',518,'A级-红宝玉草莓（大）-1份/230-250g',25.90,1,25.90),
(17,'2637981635282688',518,'A级-红宝玉草莓（大）-1份/230-250g',25.90,3,77.70),
(18,'5530582643961246',594,'B级-翠蜜香瓜1个/350-400g',17.90,1,17.90),
(19,'5530582643961246',465,'【如有需求请备注】B级-泰国椰青（中）1个/约800g',13.90,1,13.90),
(20,'5530582643961246',544,'B级-沙糖桔（中）-1份/不少于500g',7.90,1,7.90),
(21,'7889812722950440',583,'A级-千禧圣女果（中）1份230g-250g',14.90,2,29.80),
(22,'7889812722950440',517,'B级-沙糖桔（中）1份/不少于250g',0.99,2,1.98),
(23,'7889812722950440',518,'A级-红宝玉草莓（大）-1份/230-250g',25.90,1,25.90),
(24,'7872157292489314',543,'A级-西柚中（个）1个/约300g',13.50,1,13.50),
(25,'9414867739177768',423,'A级-佳沛金奇异果（大）1个',19.90,1,19.90),
(26,'6321067180591172',435,'【礼盒】欢聚时光礼盒1盒',149.00,1,149.00),
(27,'6321067180591172',426,'【整件装】A级-佳沛金奇异果（大）1件/22个',409.80,1,409.80),
(28,'7462727395134124',543,'A级-西柚中（个）1个/约300g',13.50,1,13.50),
(29,'2403905531394366',595,'A级-夏威夷木瓜（中）-1个850-900g',25.90,1,25.90),
(30,'6812012880202462',520,'A级-泰国龙眼（中）-1份/230-250g',7.90,1,7.90),
(31,'0633820620366442',423,'A级-佳沛金奇异果（大）1个',19.90,2,39.80),
(32,'4344597086856861',516,'【6.9特惠】B级 - 进口车厘子（小）1份约200g',6.90,1,6.90),
(33,'9596102831624816',518,'A级-红宝玉草莓（大）-1份/230-250g',25.90,1,25.90),
(34,'7237301825945400',547,'A级-高乐蜜芒果（中）1个/350-400g',15.50,3,46.50),
(35,'0330374197033979',518,'A级-红宝玉草莓（大）-1份/230-250g',25.90,1,25.90),
(36,'0330374197033979',543,'A级-西柚中（个）1个/约300g',13.50,1,13.50),
(37,'0330374197033979',543,'A级-西柚中（个）1个/约300g',13.50,1,13.50),
(38,'0330374197033979',427,'紫衣腰果1罐/约280g',46.90,2,93.80),
(39,'0330374197033979',429,'【会员精选】缤纷果园腰果1盒/6袋',59.90,1,59.90),
(40,'0330374197033979',465,'【如有需求请备注】B级-泰国椰青（中）1个/约800g',13.90,1,13.90),
(41,'1522851931857844',496,'【维C多多】1份/约800g',47.90,1,47.90),
(42,'0520879618633849',591,'B级-无核夏黑葡萄1份/480-500g',22.80,1,22.80),
(43,'6057503188485659',423,'A级-佳沛金奇异果（大）1个',19.90,2,39.80),
(44,'6057503188485659',424,'A级-佳沛金奇异果（大）--1份/4个',74.50,2,149.00),
(45,'2063878006209227',594,'B级-翠蜜香瓜1个/350-400g',17.90,1,17.90),
(46,'6453320106010150',520,'A级-泰国龙眼（中）-1份/230-250g',7.90,1,7.90),
(47,'1705304429343716',520,'A级-泰国龙眼（中）-1份/230-250g',7.90,1,7.90),
(48,'8395945225312788',484,'稀有-125g盒装怡颗莓国产蓝莓王1盒',36.90,1,36.90),
(49,'4169542496748970',433,'【果篮】温馨家庭果篮1份',219.00,1,219.00),
(50,'9063292178033973',484,'稀有-125g盒装怡颗莓国产蓝莓王1盒',36.90,1,36.90),
(51,'7374751160849222',484,'稀有-125g盒装怡颗莓国产蓝莓王1盒',36.90,1,36.90),
(52,'7385921134377548',484,'稀有-125g盒装怡颗莓国产蓝莓王1盒',36.90,2,73.80),
(53,'7385921134377548',465,'【如有需求请备注】B级-泰国椰青（中）1个/约800g',13.90,1,13.90),
(54,'7385921134377548',517,'B级-沙糖桔（中）1份/不少于250g',0.99,1,0.99),
(55,'1994374216513834',484,'稀有-125g盒装怡颗莓国产蓝莓王1盒',36.90,2,73.80),
(56,'1994374216513834',465,'【如有需求请备注】B级-泰国椰青（中）1个/约800g',13.90,1,13.90),
(57,'1994374216513834',517,'B级-沙糖桔（中）1份/不少于250g',0.99,1,0.99),
(58,'7526288781124102',517,'B级-沙糖桔（中）1份/不少于250g',0.99,1,0.99),
(59,'1852952652974029',517,'B级-沙糖桔（中）1份/不少于250g',0.99,1,0.99),
(60,'3415902672949428',517,'B级-沙糖桔（中）1份/不少于250g',0.99,1,0.99),
(61,'0028157270426807',517,'B级-沙糖桔（中）1份/不少于250g',0.99,1,0.99),
(62,'5552038980236298',521,'A级-千禧圣女果（中）1份230g-250g',14.90,1,14.90),
(63,'8750215429743571',596,'B级- 沙漠蜜瓜1个1.1-1.3kg',29.50,4,118.00),
(64,'8750215429743571',516,'【6.9特惠】B级 - 进口车厘子（小）1份约200g',6.90,2,13.80),
(65,'5499900793308263',547,'A级-高乐蜜芒果（中）1个/350-400g',15.50,1,15.50),
(66,'5499900793308263',517,'B级-沙糖桔（中）1份/不少于250g',0.99,1,0.99),
(67,'0409359014604139',517,'B级-沙糖桔（中）1份/不少于250g',0.99,1,0.99),
(68,'2015299918924429',424,'A级-佳沛金奇异果（大）--1份/4个',74.50,3,223.50),
(69,'2015299918924429',517,'B级-沙糖桔（中）1份/不少于250g',0.99,1,0.99),
(70,'6178371162637210',484,'稀有-125g盒装怡颗莓国产蓝莓王1盒',36.90,1,36.90),
(71,'4394786078824795',521,'A级-千禧圣女果（中）1份230g-250g',14.90,3,44.70),
(72,'8522822320999719',518,'A级-红宝玉草莓（大）-1份/230-250g',25.90,1,25.90),
(73,'6286305466194316',485,'A级-进口蛇果小（个）1个/约200g',9.50,2,19.00),
(74,'5781411721981379',547,'A级-高乐蜜芒果（中）1个/350-400g',15.50,2,31.00),
(75,'9769423538910969',519,'A级-沃柑（中）2个/300-350g',7.90,2,15.80),
(76,'1241584148473782',519,'A级-沃柑（中）2个/300-350g',7.90,2,15.80),
(77,'0577677134006115',423,'A级-佳沛金奇异果（大）1个',19.90,2,39.80),
(78,'6050104744088760',484,'稀有-125g盒装怡颗莓国产蓝莓王1盒',36.90,1,36.90),
(79,'9941966817647225',543,'A级-西柚中（个）1个/约300g',13.50,1,13.50),
(80,'4686164465282314',426,'【整件装】A级-佳沛金奇异果（大）1件/22个',409.80,1,409.80),
(81,'8658946689811205',543,'A级-西柚中（个）1个/约300g',13.50,1,13.50),
(82,'2542910410944881',519,'A级-沃柑（中）2个/300-350g',7.90,1,7.90),
(83,'5716874922828155',555,'招牌-中华桔柚（中）-1份/1-1.1kg',29.90,1,29.90),
(84,'7514809858191760',484,'稀有-125g盒装怡颗莓国产蓝莓王1盒',36.90,1,36.90),
(85,'8281344301369459',484,'稀有-125g盒装怡颗莓国产蓝莓王1盒',36.90,1,36.90),
(86,'3618152666472121',465,'【如有需求请备注】B级-泰国椰青（中）1个/约800g',13.90,1,13.90),
(87,'6692748811573391',583,'A级-千禧圣女果（中）1份230g-250g',14.90,1,14.90),
(88,'1571057010920486',518,'A级-红宝玉草莓（大）-1份/230-250g',25.90,17,440.30),
(89,'7541565252646442',521,'A级-千禧圣女果（中）1份230g-250g',14.90,1,14.90),
(90,'9223060532008552',518,'A级-红宝玉草莓（大）-1份/230-250g',25.90,1,25.90),
(91,'9984093994637081',547,'A级-高乐蜜芒果（中）1个/350-400g',15.50,1,15.50),
(92,'6980638622368085',583,'A级-千禧圣女果（中）1份230g-250g',14.90,1,14.90),
(93,'5945538071302451',543,'A级-西柚中（个）1个/约300g',13.50,1,13.50),
(94,'2781314479739605',543,'A级-西柚中（个）1个/约300g',13.50,1,13.50),
(95,'2604973230678885',543,'A级-西柚中（个）1个/约300g',13.50,1,13.50),
(96,'9222927192797794',543,'A级-西柚中（个）1个/约300g',13.50,1,13.50),
(97,'3150295938234221',543,'A级-西柚中（个）1个/约300g',13.50,1,13.50),
(98,'4427932985864868',543,'A级-西柚中（个）1个/约300g',13.50,1,13.50),
(99,'9081731995892012',543,'A级-西柚中（个）1个/约300g',13.50,1,13.50),
(100,'7646460008591275',543,'A级-西柚中（个）1个/约300g',13.50,2,27.00),
(101,'2373377998688361',543,'A级-西柚中（个）1个/约300g',13.50,2,27.00),
(102,'2374024606840415',543,'A级-西柚中（个）1个/约300g',13.50,2,27.00),
(103,'7078136649281868',543,'A级-西柚中（个）1个/约300g',13.50,2,27.00),
(104,'9782999710723315',543,'A级-西柚中（个）1个/约300g',13.50,3,40.50),
(105,'7588884518290009',543,'A级-西柚中（个）1个/约300g',13.50,3,40.50),
(106,'1969306473635917',543,'A级-西柚中（个）1个/约300g',13.50,3,40.50),
(107,'5402528767354616',543,'A级-西柚中（个）1个/约300g',13.50,3,40.50),
(108,'5402528767354616',505,'A级-小汤山草莓-1份/230-250g',39.90,1,39.90),
(109,'5573057669729983',543,'A级-西柚中（个）1个/约300g',13.50,3,40.50),
(110,'5573057669729983',505,'A级-小汤山草莓-1份/230-250g',39.90,1,39.90),
(111,'1884941658532479',543,'A级-西柚中（个）1个/约300g',13.50,3,40.50),
(112,'1884941658532479',505,'A级-小汤山草莓-1份/230-250g',39.90,1,39.90),
(113,'1552724100529987',543,'A级-西柚中（个）1个/约300g',13.50,3,40.50),
(114,'1552724100529987',505,'A级-小汤山草莓-1份/230-250g',39.90,2,79.80),
(115,'4022022736825929',543,'A级-西柚中（个）1个/约300g',13.50,3,40.50),
(116,'4022022736825929',505,'A级-小汤山草莓-1份/230-250g',39.90,2,79.80),
(117,'3310980106301497',543,'A级-西柚中（个）1个/约300g',13.50,3,40.50),
(118,'3310980106301497',505,'A级-小汤山草莓-1份/230-250g',39.90,2,79.80),
(119,'1639177339495874',543,'A级-西柚中（个）1个/约300g',13.50,3,40.50),
(120,'1639177339495874',505,'A级-小汤山草莓-1份/230-250g',39.90,2,79.80),
(121,'3434406074517303',543,'A级-西柚中（个）1个/约300g',13.50,3,40.50),
(122,'3434406074517303',505,'A级-小汤山草莓-1份/230-250g',39.90,2,79.80),
(123,'3434406074517303',555,'招牌-中华桔柚（中）-1份/1-1.1kg',29.90,1,29.90),
(124,'4205176047542476',543,'A级-西柚中（个）1个/约300g',13.50,3,40.50),
(125,'4205176047542476',505,'A级-小汤山草莓-1份/230-250g',39.90,2,79.80),
(126,'4205176047542476',555,'招牌-中华桔柚（中）-1份/1-1.1kg',29.90,1,29.90),
(127,'8540158215561509',543,'A级-西柚中（个）1个/约300g',13.50,4,54.00),
(128,'8540158215561509',505,'A级-小汤山草莓-1份/230-250g',39.90,2,79.80),
(129,'8540158215561509',555,'招牌-中华桔柚（中）-1份/1-1.1kg',29.90,1,29.90);

/*Table structure for table `undo_log` */

DROP TABLE IF EXISTS `undo_log`;

CREATE TABLE `undo_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `branch_id` bigint(20) NOT NULL,
  `xid` varchar(100) NOT NULL,
  `context` varchar(128) NOT NULL,
  `rollback_info` longblob NOT NULL,
  `log_status` int(11) NOT NULL,
  `log_created` datetime NOT NULL,
  `log_modified` datetime NOT NULL,
  `ext` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

/*Data for the table `undo_log` */

/*!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 */;