/*
SQLyog Ultimate v10.00 Beta1
MySQL - 5.7.20 : Database - dirsir
*********************************************************************
*/

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

USE `dirsir`;

/*Table structure for table `account` */

DROP TABLE IF EXISTS `account`;

CREATE TABLE `account` (
  `account_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `account_name` varchar(20) NOT NULL COMMENT '用户名',
  `phone` varchar(11) DEFAULT NULL COMMENT '用户电话',
  `account_password` varchar(20) NOT NULL COMMENT '用户密码',
  `name` varchar(10) DEFAULT NULL COMMENT '真实姓名',
  `gender` int(1) NOT NULL DEFAULT '1' COMMENT '默认为1男',
  `age` int(3) NOT NULL COMMENT '年龄',
  `birthday` date NOT NULL COMMENT '生日',
  `id_card` varchar(18) NOT NULL COMMENT '身份证号',
  `balance` double(10,2) DEFAULT '0.00' COMMENT '余额',
  `email` varchar(30) NOT NULL COMMENT '邮箱',
  `picture` varchar(50) DEFAULT NULL COMMENT '头像',
  `vip` int(1) NOT NULL DEFAULT '0' COMMENT '是否为VIP',
  `vip_date` date DEFAULT NULL COMMENT '开通vip日期',
  `vip_birthday` date DEFAULT NULL COMMENT '注册日期',
  PRIMARY KEY (`account_id`),
  UNIQUE KEY `account_name` (`account_name`),
  UNIQUE KEY `phone` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `account` */

insert  into `account`(`account_id`,`account_name`,`phone`,`account_password`,`name`,`gender`,`age`,`birthday`,`id_card`,`balance`,`email`,`picture`,`vip`,`vip_date`,`vip_birthday`) values (1,'吉祥','18213229960','admin','吉祥',1,20,'2019-11-10','130722199906184546',19200.00,'123456@qq.com',NULL,0,NULL,NULL),(2,'丁二','18827916662','account123','丁二',1,23,'1996-07-12','350181199607126764',0.00,'987654@qq.com',NULL,0,NULL,NULL),(3,'南','18865659090','account123','南',1,21,'1998-10-15','469025199810159090',0.00,'345678@qq.com',NULL,0,NULL,NULL);

/*Table structure for table `account_service` */

DROP TABLE IF EXISTS `account_service`;

CREATE TABLE `account_service` (
  `service_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '售后服务ID',
  `order_id` int(11) DEFAULT NULL COMMENT '订单号ID',
  `return_reason` varchar(100) NOT NULL COMMENT '退货原因',
  `return_date` date NOT NULL COMMENT '退货时间',
  `return_state` int(1) DEFAULT '1' COMMENT '退货状态',
  PRIMARY KEY (`service_id`),
  KEY `ser_list_fk` (`order_id`),
  CONSTRAINT `ser_list_fk` FOREIGN KEY (`order_id`) REFERENCES `order_list` (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `account_service` */

insert  into `account_service`(`service_id`,`order_id`,`return_reason`,`return_date`,`return_state`) values (1,1,'商品破损，需要退货','2019-10-09',1),(2,2,'买错了，需要退货','2019-10-09',1);

/*Table structure for table `account_tarding` */

DROP TABLE IF EXISTS `account_tarding`;

CREATE TABLE `account_tarding` (
  `tarding_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '交易记录ID',
  `account_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `trading_date` date DEFAULT NULL COMMENT '交易日期',
  `tarding_prices` double(10,2) DEFAULT NULL COMMENT '交易金额',
  `tarding_type` int(1) DEFAULT NULL COMMENT '交易类型',
  `note` varchar(100) DEFAULT NULL COMMENT '备注 可为空',
  PRIMARY KEY (`tarding_id`),
  KEY `acc_tar_fk` (`account_id`),
  CONSTRAINT `acc_tar_fk` FOREIGN KEY (`account_id`) REFERENCES `account` (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

/*Data for the table `account_tarding` */

insert  into `account_tarding`(`tarding_id`,`account_id`,`trading_date`,`tarding_prices`,`tarding_type`,`note`) values (1,1,'2019-10-15',72.00,1,'购物'),(2,2,'2019-10-15',200.00,1,'购物'),(3,1,'2019-11-10',200.00,2,'充值'),(4,1,'2019-11-10',100.00,2,'充值'),(5,1,'2019-11-10',500.00,2,'充值'),(6,1,'2019-11-10',200.00,2,'充值'),(7,1,'2019-11-10',100.00,2,'充值'),(8,1,'2019-11-10',200.00,2,'充值'),(9,1,'2019-11-10',200.00,2,'充值'),(10,1,'2019-11-10',100.00,2,'充值'),(11,1,'2019-11-10',100.00,4,'提现'),(12,1,'2019-11-10',200.00,4,'提现'),(13,1,'2019-11-10',2000.00,4,'提现'),(14,1,'2019-11-10',200.00,2,'充值'),(15,1,'2019-11-10',500.00,4,'提现'),(16,1,'2019-11-10',500.00,4,'提现');

/*Table structure for table `admin` */

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (
  `admin_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '平台管理员ID',
  `admin_number` int(11) DEFAULT NULL COMMENT '工号',
  `admin_name` varchar(20) DEFAULT NULL COMMENT '用户名',
  `admin_password` varchar(20) DEFAULT NULL COMMENT '密码',
  `real_name` varchar(20) DEFAULT NULL COMMENT '使用人',
  `state` int(1) DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`admin_id`),
  UNIQUE KEY `admin_number` (`admin_number`),
  UNIQUE KEY `admin_name` (`admin_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `admin` */

insert  into `admin`(`admin_id`,`admin_number`,`admin_name`,`admin_password`,`real_name`,`state`) values (1,1001,'艾希','admin123','寒冰',1),(2,1002,'阿卡丽','admin123','暗影之拳',1);

/*Table structure for table `commodity` */

DROP TABLE IF EXISTS `commodity`;

CREATE TABLE `commodity` (
  `commodity_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品ID',
  `commodity_name` varchar(100) NOT NULL COMMENT '商品名称',
  `commodity_describe` varchar(100) DEFAULT NULL COMMENT '商品描述',
  `price` double(10,2) DEFAULT NULL COMMENT '商品单价',
  `vip_price` double(10,2) DEFAULT NULL COMMENT 'VIP单价',
  `subtype_id` int(11) DEFAULT NULL COMMENT '子类类型ID',
  `merchant_id` int(11) DEFAULT NULL COMMENT '商家ID',
  `sale_info` int(1) DEFAULT '0' COMMENT '上下架信息',
  `check_info` int(1) DEFAULT '1' COMMENT '审核信息',
  `check_date` date DEFAULT NULL COMMENT '审核时间',
  `admin_id` int(11) DEFAULT NULL COMMENT '审核人ID（管理员）',
  PRIMARY KEY (`commodity_id`),
  KEY `com_sub_fk` (`subtype_id`),
  KEY `mer_commo_fk` (`merchant_id`),
  KEY `admin_commo_fk` (`admin_id`),
  CONSTRAINT `admin_commo_fk` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`admin_id`),
  CONSTRAINT `com_sub_fk` FOREIGN KEY (`subtype_id`) REFERENCES `commodity_subtype` (`subtype_id`),
  CONSTRAINT `mer_commo_fk` FOREIGN KEY (`merchant_id`) REFERENCES `merchant` (`merchant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8;

/*Data for the table `commodity` */

insert  into `commodity`(`commodity_id`,`commodity_name`,`commodity_describe`,`price`,`vip_price`,`subtype_id`,`merchant_id`,`sale_info`,`check_info`,`check_date`,`admin_id`) values (1,'百草味零食水果干大礼包女生芒果干混合散装','味道好极了',135.00,126.00,552,1,1,3,'2019-11-22',1),(2,'易烊千玺同款 百草味水果干礼盒420g ','7种搭配 缤纷鲜果风味 人气果干 精制礼盒',43.90,46.00,552,1,1,3,'2019-11-10',1),(3,'百草味夏威夷果218g休闲零食特产每日坚','夏威夷果感受快乐的滋味',25.00,20.00,552,1,1,3,'2019-11-22',1),(4,'手机',NULL,NULL,NULL,NULL,3,1,3,NULL,1),(5,'小米9Pro5G 骁龙855 Plus 30W无线闪充智能游戏手机小米官方旗舰店正品',NULL,3999.09,3999.00,241,5,1,3,'2019-12-15',1),(6,'红米k20 骁龙730三摄4800万AI指纹拍照智能游戏手机小米官方旗舰店redmi正品',NULL,1799.99,2299.00,241,5,1,3,'2019-12-15',1),(53,'Nike耐克官方NIKE COURT BOROUGH MID男子运动鞋休闲鞋838938',NULL,342.99,342.00,77,4,1,3,'2019-10-17',1),(54,'Nike耐克 女鞋 2019秋季新款正品运动休闲鞋低帮跑步鞋AT1369-004',NULL,589.99,799.00,60,4,1,3,'2019-10-17',1),(55,'蕾丝内裤女纯棉100%裆A中腰性感B高腰收腹女士短裤','',69.00,69.00,42,6,1,3,'2019-10-17',1),(56,'运动速干男士平角裤无痕四角裤 ','',139.00,139.00,44,6,1,3,'2019-10-17',1),(58,'Apple/苹果 iPhone XS Max 手机iPhonexsmax 官方国行正品苹果xr/xs/8/7/P','',6999.99,6999.00,240,7,1,3,'2019-10-17',1),(59,'预定立减150元【送无线充】Apple/苹果 iPhone 11 手机新款iphone11 pro max官方旗舰店国行xr/xs max ','',6099.00,6099.00,247,7,1,3,'2019-10-10',1),(60,'花花公子长袖t恤男士2019新款潮流行圆领卫衣韩版体恤秋季上衣服','',139.00,139.00,30,8,1,3,'2019-10-09',1),(61,'阿迪达斯外套男春秋季 黑针织夹克上衣','',499.00,499.00,28,9,1,3,'2019-12-15',1),(62,'Adidas阿迪达斯外套女2019秋季新款潮流运动服宽松防风衣连帽夹克 ','',259.00,259.00,760,9,1,3,'2019-10-11',1),(63,'百草味每日坚果大礼包','真的好吃',88.00,85.00,552,2,1,3,'2019-11-22',1),(64,'百草味开心果','开心每一天',88.00,88.00,552,2,1,3,'2019-11-22',1),(65,'百草味开心果大礼包','',88.00,85.00,552,2,1,3,'2019-11-22',1),(66,'百草味零食大礼包双十一特惠','双十一真的很优惠',88.00,85.00,552,2,1,3,'2019-11-22',1),(73,'百草味每日坚果','每日坚果，健康每一天',88.00,88.00,552,1,1,3,'2019-11-22',1);

/*Table structure for table `commodity_picture` */

DROP TABLE IF EXISTS `commodity_picture`;

CREATE TABLE `commodity_picture` (
  `picture_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '图片ID',
  `commodity_id` int(11) DEFAULT NULL COMMENT '商品ID',
  `picture_type` int(11) NOT NULL COMMENT '图片类型',
  `picture_url` varchar(50) DEFAULT NULL COMMENT '图片路径',
  `picsort_code` int(11) DEFAULT '1' COMMENT '图片排序码',
  `picture_state` int(11) DEFAULT '1' COMMENT '图片状态',
  PRIMARY KEY (`picture_id`),
  KEY `commo_pic_fk` (`commodity_id`),
  CONSTRAINT `commo_pic_fk` FOREIGN KEY (`commodity_id`) REFERENCES `commodity` (`commodity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=225 DEFAULT CHARSET=utf8;

/*Data for the table `commodity_picture` */

insert  into `commodity_picture`(`picture_id`,`commodity_id`,`picture_type`,`picture_url`,`picsort_code`,`picture_state`) values (1,1,2,'2019102815314340469500000001.mp4',1,0),(2,1,1,'2019102815414159897200000001.jpg',1,1),(3,1,1,'2019102815414558353600000001.jpg',1,1),(4,1,1,'2019102815415135863200000001.jpg',1,1),(5,1,1,'2019102815415540159400000001.jpg',1,1),(7,1,3,'2019102815421005137600000001.jpg',1,1),(8,1,4,'2019102815424311059900000001.jpg',1,1),(9,1,4,'2019102815425889159300000001.jpg',1,1),(10,1,4,'2019102815431602250900000001.jpg',1,1),(11,1,4,'2019102815432397957100000001.jpg',1,1),(12,1,4,'2019102815433564771600000001.jpg',1,1),(13,1,4,'2019102815434603761200000001.jpg',1,1),(14,1,4,'2019102815435740799100000001.jpg',1,1),(15,1,4,'2019102815440898964400000001.jpg',1,1),(16,1,4,'2019102815442689566600000001.jpg',1,1),(17,1,4,'2019102815444538524200000001.jpg',1,1),(18,2,2,'2019102815270339108600000001.mp4',1,1),(19,2,1,'20191028153627038321000000001.jpg',1,1),(20,2,1,'2019102815363189085900000001.jpg',1,1),(21,2,1,'2019102815363901672700000001.jpg',1,1),(22,2,1,'2019102815364348923100000001.jpg',1,1),(23,2,1,'2019102815370914475800000001.jpg',1,1),(24,2,3,'2019102815371652787500000001.jpg',1,1),(25,2,4,'2019102815374113132500000001.jpg',1,1),(26,2,4,'20191028153747773651000000001.jpg',1,1),(27,2,4,'2019102815380700905800000001.jpg',1,1),(28,2,4,'20191028153814608721000000001.jpg',1,1),(29,2,4,'2019102815384422335200000001.jpg',1,1),(30,2,4,'2019102815384986015500000001.jpg',1,1),(31,3,1,'2019102815274151875300000001.jpg',1,1),(32,3,1,'2019102815275756815700000001.jpg',1,1),(33,3,1,'2019102815280477563700000001.jpg',1,1),(34,3,1,'2019102815282254969100000001.jpg',1,1),(35,3,1,'2019102815285551212400000001.jpg',1,1),(36,3,2,'2019102815291139617900000001.mp4',1,1),(37,3,3,'2019102815292915429300000001.jpg',1,1),(38,3,4,'2019102815295337212700000001.jpg',1,1),(39,3,4,'2019102815295888271700000001.jpg',1,1),(40,3,4,'2019102815300422971800000001.jpg',1,1),(41,3,4,'2019102815302434286600000001.gif',1,1),(42,3,4,'2019102815303095882700000001.gif',1,1),(43,3,4,'2019102815303690822200000001.jpg',1,1),(44,3,4,'2019102815305129694400000001.jpg',1,1),(45,3,4,'20191028153055864801000000001.jpg',1,1),(46,3,4,'2019102815310026211400000001.jpg',1,1),(47,3,4,'20191028153105879551000000001.jpg',1,1),(55,55,4,'2019103016332380699019216843173.png',1,1),(56,55,4,'2019103016333159649719216843173.png',1,1),(57,55,4,'20191030163337160103119216843173.png',1,1),(58,55,4,'2019103016334184766519216843173.png',1,1),(59,55,3,'20191030163415738581019216843173.png',1,1),(60,56,4,'2019103016505390037719216843173.png',1,1),(61,56,4,'20191030165101581851019216843173.png',1,1),(62,56,4,'2019103016510731545519216843173.png',1,1),(63,56,4,'2019103016511315345419216843173.png',1,1),(64,56,4,'2019103016511909597919216843173.png',1,1),(65,58,3,'2019103017144842957119216843173.png',1,1),(66,58,4,'2019103017150259062619216843173.png',1,1),(67,58,4,'2019103017151062289919216843173.png',1,1),(68,58,4,'2019103017151552057019216843173.png',1,1),(69,5,1,'2019103017175787268719216843124.png',1,1),(70,5,1,'2019103017175794510219216843124.png',1,1),(71,5,1,'2019103017175796677119216843124.jpg',1,1),(72,5,1,'2019103017175799285919216843124.jpg',1,1),(73,5,1,'20191030171758016104419216843124.png',1,1),(74,5,2,'2019103017190623933619216843124.mp4',1,1),(75,5,3,'2019103017191740699319216843124.png',1,1),(76,5,4,'2019103017195796341319216843124.jpg',1,1),(77,5,4,'20191030172006169971019216843124.jpg',1,1),(78,5,4,'2019103017201457326819216843124.jpg',1,1),(79,5,4,'2019103017202817664719216843124.jpg',1,1),(80,5,4,'2019103017205555347319216843124.jpg',1,1),(81,5,4,'20191030172127278410019216843124.jpg',1,1),(82,5,4,'2019103017214899542619216843124.jpg',1,1),(83,5,4,'20191030172159649710919216843124.jpg',1,1),(84,6,1,'2019103017225163264719216843124.png',1,1),(85,6,1,'20191030172251697110819216843124.png',1,1),(86,6,1,'2019103017225172595119216843124.jpg',1,1),(87,6,1,'2019103017225177776119216843124.png',1,1),(88,6,1,'20191030172251802810419216843124.jpg',1,1),(89,6,2,'2019103017230306492519216843124.mp4',1,1),(90,6,3,'20191030172316118109419216843124.jpg',1,1),(91,6,4,'2019103017233524620919216843124.jpg',1,1),(92,6,4,'2019103017235914027619216843124.jpg',1,1),(93,6,4,'2019103017235917240419216843124.jpg',1,1),(94,6,4,'20191030172359197105719216843124.jpg',1,1),(95,6,4,'2019103017235921961219216843124.jpg',1,1),(96,6,4,'2019103017235923769419216843124.jpg',1,1),(97,6,4,'2019103017235929434219216843124.jpg',1,1),(98,6,4,'2019103017235931024419216843124.jpg',1,1),(99,6,4,'2019103017240461311719216843124.png',1,1),(100,59,3,'20191030172617983108519216843173.png',1,1),(105,59,4,'2019103017273709176919216843173.png',1,1),(106,59,4,'2019103017274306171419216843173.png',1,1),(107,59,4,'2019103017274952376619216843173.png',1,1),(108,59,4,'2019103017275557635019216843173.png',1,1),(109,59,4,'2019103017280129429219216843173.png',1,1),(110,59,4,'2019103017280586268319216843173.png',1,1),(111,60,1,'2019103017455076599819216843124.jpg',1,1),(112,60,1,'20191030174550833510419216843124.jpg',1,1),(113,60,1,'2019103017455085362519216843124.jpg',1,1),(114,60,1,'2019103017455088102619216843124.jpg',1,1),(115,60,1,'2019103017455090395519216843124.jpg',1,1),(116,60,3,'20191030174559996107119216843124.jpg',1,1),(117,60,4,'2019103017463820474619216843124.jpg',1,1),(118,60,4,'2019103017463826567419216843124.jpg',1,1),(119,60,4,'2019103017463828740719216843124.jpg',1,1),(120,60,4,'2019103017463831457719216843124.jpg',1,1),(121,60,4,'2019103017463833714619216843124.jpg',1,1),(122,60,4,'20191030174638363102719216843124.jpg',1,1),(123,60,4,'2019103017463837936219216843124.jpg',1,1),(124,60,4,'2019103017463840361519216843124.jpg',1,1),(125,61,4,'20191030175315192108119216843173.png',1,1),(126,61,4,'2019103017532759286819216843173.png',1,1),(127,61,4,'2019103017535631675919216843173.png',1,1),(128,61,4,'2019103017540283943719216843173.png',1,1),(129,61,4,'2019103017540849927019216843173.png',1,1),(130,61,4,'20191030175416735910819216843173.png',1,1),(131,61,4,'2019103017542376913219216843173.png',1,1),(133,62,4,'20191030181204381391019216843173.png',1,1),(134,62,4,'20191030181222258108419216843173.png',1,1),(135,62,4,'2019103018122231179119216843173.png',1,1),(136,62,4,'2019103018122232747219216843173.png',1,1),(137,62,4,'2019103018122234242819216843173.png',1,1),(138,62,4,'2019103018122235826619216843173.png',1,1),(139,62,4,'2019103018122238011219216843173.png',1,1),(140,62,4,'2019103018122239641719216843173.png',1,1),(142,61,3,'2019110117294322886600000001.png',1,1),(143,55,1,'2019110320114209865200000001.png',1,1),(144,55,1,'2019110320114217329000000001.png',1,1),(145,55,1,'2019110320114221638300000001.png',1,1),(146,55,1,'2019110320114225842900000001.png',1,1),(147,55,1,'2019110320114229046100000001.png',1,1),(148,56,1,'2019110320120853003700000001.png',1,1),(149,56,1,'2019110320120859888600000001.png',1,1),(150,56,1,'2019110320120863081200000001.png',1,1),(151,56,1,'2019110320120865645400000001.png',1,1),(152,56,1,'2019110320120868082000000001.png',1,1),(153,56,3,'2019110320122059725800000001.png',1,1),(154,56,4,'2019110320123359816600000001.png',1,1),(155,56,4,'2019110320123367693500000001.png',1,1),(156,56,4,'2019110320123371671300000001.png',1,1),(157,56,4,'2019110320123375097900000001.png',1,1),(158,55,4,'20191103201253187106000000001.png',1,1),(159,55,4,'2019110320125326584600000001.png',1,1),(160,55,4,'2019110320125335034600000001.png',1,1),(161,55,4,'2019110320125339382200000001.png',1,1),(162,58,1,'2019110320140625869000000001.png',1,1),(163,58,1,'2019110320142456574600000001.png',1,1),(164,58,1,'2019110320142463595400000001.png',1,1),(165,58,1,'2019110320142466473200000001.png',1,1),(166,58,1,'2019110320142469239800000001.png',1,1),(167,59,1,'2019110320145232039600000001.png',1,1),(168,59,1,'2019110320145238687400000001.png',1,1),(169,59,1,'2019110320145241571600000001.png',1,1),(170,59,1,'2019110320145244021100000001.png',1,1),(171,61,1,'2019110320162649070000000001.png',1,1),(172,61,1,'2019110320162680147900000001.png',1,1),(173,61,1,'2019110320162683464100000001.png',1,1),(174,61,1,'2019110320162687532700000001.png',1,1),(175,61,1,'2019110320162690779200000001.png',1,1),(176,62,1,'2019110320170598278300000001.png',1,1),(177,62,1,'2019110320170628447800000001.png',1,1),(178,62,1,'2019110320170636558800000001.png',1,1),(179,62,1,'2019110320170639478500000001.png',1,1),(180,62,3,'20191103201723003510800000001.png',1,1),(181,53,1,'2019110320240411760600000001.jpg',1,1),(182,53,1,'2019110320240443094700000001.jpg',1,1),(183,53,1,'2019110320240446425300000001.jpg',1,1),(184,53,1,'2019110320240449801400000001.jpg',1,1),(185,53,1,'2019110320240453181400000001.png',1,1),(186,53,3,'20191103202421436101100000001.jpg',1,1),(187,53,4,'2019110320244736346600000001.jpg',1,1),(188,53,4,'2019110320244743216700000001.jpg',1,1),(189,53,4,'2019110320244746289200000001.jpg',1,1),(190,53,4,'2019110320244748932500000001.jpg',1,1),(191,53,4,'2019110320244751591700000001.jpg',1,1),(192,53,4,'2019110320244754695600000001.jpg',1,1),(193,53,4,'2019110320244757067300000001.jpg',1,1),(194,53,4,'20191103202447598109500000001.jpg',1,1),(195,53,4,'20191103202447631531000000001.jpg',1,1),(196,53,4,'2019110320244766519200000001.jpg',1,1),(197,54,1,'2019110320283095611500000001.jpg',1,1),(198,54,1,'20191103203020374521000000001.jpg',1,1),(199,54,1,'2019110320302067453400000001.jpg',1,1),(200,54,1,'2019110320302069854200000001.jpg',1,1),(201,54,1,'2019110320302075694700000001.jpg',1,1),(202,54,3,'2019110320302948431600000001.jpg',1,1),(203,54,4,'2019110320310319751400000001.gif',1,1),(204,54,4,'2019110320310351089300000001.jpg',1,1),(205,54,4,'2019110320310354389700000001.jpg',1,1),(206,54,4,'2019110320310358481700000001.gif',1,1),(207,54,4,'2019110320310361822600000001.gif',1,1),(208,54,4,'2019110320310365371800000001.jpg',1,1),(216,63,3,'2019110409544075620200000001.jpg',1,1),(220,64,1,'201911111123085347641921682221.jpg',1,1),(221,64,1,'201911111123126352691921682221.jpg',1,1),(222,64,3,'201911111123224421631921682221.jpg',1,1),(223,64,2,'201911111123353139661921682221.mp4',1,1),(224,73,3,'20191215193913195109900000001.jpg',1,1);

/*Table structure for table `commodity_sort` */

DROP TABLE IF EXISTS `commodity_sort`;

CREATE TABLE `commodity_sort` (
  `sort_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '类别ID',
  `commodity_id` int(11) DEFAULT NULL COMMENT '商品ID',
  `sort_name` varchar(30) NOT NULL COMMENT '类别名称',
  `sort_state` int(1) DEFAULT '1' COMMENT '类别状态',
  `sort_code` int(11) DEFAULT '1' COMMENT '排序码',
  PRIMARY KEY (`sort_id`),
  KEY `commo_subsort_fk` (`commodity_id`),
  CONSTRAINT `commo_subsort_fk` FOREIGN KEY (`commodity_id`) REFERENCES `commodity` (`commodity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8;

/*Data for the table `commodity_sort` */

insert  into `commodity_sort`(`sort_id`,`commodity_id`,`sort_name`,`sort_state`,`sort_code`) values (1,1,'食品口味',1,1),(2,2,'更多套餐',1,1),(3,3,'版本',1,1),(18,4,'颜色',1,1),(19,4,'内存',1,1),(20,4,'套餐',1,1),(21,4,'网络制式',1,1),(23,53,'鞋码',1,1),(24,53,'颜色分类',1,1),(25,54,'鞋码',1,1),(26,54,'颜色',1,1),(27,55,'尺码',1,1),(28,55,'颜色',1,1),(29,5,'机身颜色',1,1),(30,5,'套餐类型',1,1),(31,5,'存储类型',1,1),(32,5,'网络类型',1,1),(33,56,'尺码',1,1),(34,56,'颜色',1,1),(35,6,'网络类型',1,1),(36,6,'机身颜色',1,1),(37,6,'套餐类型',1,1),(38,6,'存储容量',1,1),(39,58,'机身颜色',1,1),(40,58,'套餐类型',1,1),(41,58,'存储容量',1,1),(42,59,'机身颜色',1,1),(43,59,'套餐类型',1,1),(44,59,'存储容量',1,1),(45,60,'尺码',1,1),(46,60,'颜色',1,1),(47,61,'尺码',1,1),(48,61,'颜色分类',1,1),(49,62,'尺码',1,1),(50,62,'颜色分类',1,1),(51,1,'规格',1,1),(52,73,'规格',1,1);

/*Table structure for table `commodity_stock` */

DROP TABLE IF EXISTS `commodity_stock`;

CREATE TABLE `commodity_stock` (
  `stock_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品进货id',
  `merchant_id` int(11) DEFAULT NULL COMMENT '商家id',
  `commodity_id` int(11) DEFAULT NULL COMMENT '商品id',
  `subsort` varchar(100) DEFAULT NULL COMMENT '商品类别',
  `stock_number` int(11) DEFAULT NULL COMMENT '商品数量',
  `stock_price` double(10,2) DEFAULT NULL COMMENT '商品单价',
  `stock_prices` double(10,2) DEFAULT NULL COMMENT '商品总价',
  `procurement` varchar(30) NOT NULL COMMENT '采购人',
  `buystock_date` date DEFAULT NULL COMMENT '进货日期',
  `supplier` varchar(50) NOT NULL COMMENT '供应商',
  PRIMARY KEY (`stock_id`),
  KEY `merch_stock_fk` (`merchant_id`),
  KEY `commo_stock_fk` (`commodity_id`),
  CONSTRAINT `commo_stock_fk` FOREIGN KEY (`commodity_id`) REFERENCES `commodity` (`commodity_id`),
  CONSTRAINT `merch_stock_fk` FOREIGN KEY (`merchant_id`) REFERENCES `merchant` (`merchant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

/*Data for the table `commodity_stock` */

insert  into `commodity_stock`(`stock_id`,`merchant_id`,`commodity_id`,`subsort`,`stock_number`,`stock_price`,`stock_prices`,`procurement`,`buystock_date`,`supplier`) values (1,1,1,'21款果干（Fou you礼盒）百草味500g/箱',100,98.00,9800.00,'百草味零食大礼包','2019-10-08','南老板有限公司'),(2,1,1,'21款果干（我的女神礼盒）百草味500g/箱',100,86.00,8600.00,'南老板','2019-10-08','吴老板有限公司'),(3,1,1,'21款果干（猪饲料礼盒）百草味500g/箱',200,50.00,10000.00,'南老板','2019-11-10','百草味'),(4,1,1,'21款果干（锦鲤礼盒）百草味500g/箱',100,58.00,5800.00,'南老板','2019-11-11','百草味公司'),(5,1,1,'21款果干（熬过异地礼盒）百草味500g/箱',100,40.00,4000.00,'南老板','2019-11-11','百草味'),(6,1,1,'21款果干（空投箱礼盒）百草味500g/箱',100,3.00,300.00,'南老板','2019-11-22','百草味'),(7,1,1,'21款果干（Fou you礼盒）百草味1000g/箱',100,4.00,400.00,'哈哈少年','2019-11-22','百草味'),(8,1,1,'21款果干（空投箱礼盒）百草味500g/箱',100,85.00,8500.00,'南老板','2019-11-22','百草味'),(9,1,73,'24袋/箱',100,58.00,5800.00,'南老板','2019-11-23','百草味'),(10,1,1,'21款果干（我的女神礼盒）百草味1000g/箱',100,88.00,8800.00,'南老板','2019-11-23','百草味'),(11,1,73,'36袋/箱',100,88.00,8800.00,'南老板','2019-11-23','百草味');

/*Table structure for table `commodity_subsort` */

DROP TABLE IF EXISTS `commodity_subsort`;

CREATE TABLE `commodity_subsort` (
  `subsort_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '详细类别ID',
  `sort_id` int(11) DEFAULT NULL COMMENT '类别ID',
  `subsort_name` varchar(100) DEFAULT NULL COMMENT '详细类别名称',
  `subsort_price` double(10,2) DEFAULT NULL COMMENT '价格',
  `vip_price` double(10,2) DEFAULT NULL COMMENT 'VIP价格',
  `subsort_state` int(1) DEFAULT '1' COMMENT '详细类别状态',
  `subsort_code` int(11) DEFAULT '1' COMMENT '排序码',
  PRIMARY KEY (`subsort_id`),
  KEY `sort_sub_fk` (`sort_id`),
  CONSTRAINT `sort_sub_fk` FOREIGN KEY (`sort_id`) REFERENCES `commodity_sort` (`sort_id`)
) ENGINE=InnoDB AUTO_INCREMENT=153 DEFAULT CHARSET=utf8;

/*Data for the table `commodity_subsort` */

insert  into `commodity_subsort`(`subsort_id`,`sort_id`,`subsort_name`,`subsort_price`,`vip_price`,`subsort_state`,`subsort_code`) values (1,1,'21款果干(彩箱)百草味',119.00,119.00,1,1),(2,1,'21款果干（空投箱礼盒）百草味',125.00,125.00,1,1),(3,1,'21款果干（我的女神礼盒）百草味',125.00,125.00,1,1),(4,1,'21款果干（陪伴你礼盒）百草味',125.00,125.00,1,1),(5,1,'21款果干（熬过异地礼盒）百草味',125.00,125.00,1,1),(6,1,'21款果干（往后余生礼盒）百草味',125.00,125.00,1,1),(7,1,'21款果干（Fou you礼盒）百草味',125.00,125.00,1,1),(8,1,'21款果干（猪饲料礼盒）百草味',125.00,125.00,1,1),(9,1,'21款果干（锦鲤礼盒）百草味',125.00,125.00,1,1),(10,1,'21款果干（世界那么大）百草味',125.00,125.00,1,1),(11,2,'水果干礼盒420g×1盒',43.90,43.90,1,1),(12,2,'零食大礼包590g×1盒',69.80,69.80,1,1),(13,2,'蔬菜干礼包548g×1盒',69.90,69.90,1,1),(14,2,'每日抱抱果30天装758g×1盒',79.90,79.90,1,1),(15,2,'果干无聊急救包800g×1盒',69.90,69.90,1,1),(16,3,'夏威夷果100g',24.90,24.90,1,1),(17,3,'夏威夷果56gg',46.90,46.90,1,1),(18,3,'夏威夷果218g',19.90,19.90,1,1),(19,18,'红色',NULL,NULL,1,1),(20,18,'黑色',NULL,NULL,1,1),(21,18,'蓝色',NULL,NULL,1,1),(22,18,'白色',NULL,NULL,1,1),(23,19,'3+16G',NULL,NULL,1,1),(24,19,'4+32G',NULL,NULL,1,1),(25,19,'6+64G',NULL,NULL,1,1),(26,19,'8+128G',NULL,NULL,1,1),(27,20,'套餐一',NULL,NULL,1,1),(28,20,'套餐二',NULL,NULL,1,1),(29,20,'套餐三',NULL,NULL,1,1),(30,20,'套餐四',NULL,NULL,1,1),(31,21,'全网通',NULL,NULL,1,1),(32,21,'中国移动',NULL,NULL,1,1),(33,21,'中国电信',NULL,NULL,1,1),(34,21,'中国联通',NULL,NULL,1,1),(35,23,'38.5',324.00,324.00,1,1),(36,23,'40',324.00,324.00,1,1),(37,23,'40.5',324.00,324.00,1,1),(38,23,'41',324.00,324.00,1,1),(39,23,'42',324.00,324.00,1,1),(40,23,'42.5',324.00,324.00,1,1),(41,23,'43',324.00,324.00,1,1),(42,23,'44',324.00,324.00,1,1),(43,23,'44.5',324.00,324.00,1,1),(44,23,'46',324.00,324.00,1,1),(45,24,'黑色',324.00,324.00,1,1),(46,24,'白色',324.00,324.00,1,1),(47,25,'36',349.00,349.00,1,1),(48,25,'36.5',349.00,349.00,1,1),(49,25,'37',349.00,349.00,1,1),(50,25,'37.5',349.00,349.00,1,1),(51,25,'38',349.00,349.00,1,1),(52,25,'38.5',349.00,349.00,1,1),(53,25,'39',349.00,349.00,1,1),(54,25,'40',349.00,349.00,1,1),(56,27,'L',0.00,0.00,1,1),(57,27,'XL',10.00,10.00,1,1),(58,27,'XXL',10.00,10.00,1,1),(59,28,'肤色',69.00,69.00,1,1),(60,28,'幽紫',69.00,69.00,1,1),(61,28,'粉色',69.00,69.00,1,1),(62,28,'宝蓝',69.00,69.00,1,1),(63,29,'梦之白',0.00,0.00,1,1),(64,33,'L',0.00,0.00,1,1),(65,33,'XL',0.00,0.00,1,1),(66,33,'XXL',0.00,0.00,1,1),(67,34,'【平角】锰花黑',0.00,0.00,1,1),(68,34,'【平角】锰50度花灰',0.00,0.00,1,1),(69,34,'【平角】锰花蓝',0.00,0.00,1,1),(70,34,'【平角】锰花绿',0.00,0.00,1,1),(71,34,'【平角】锰照柿',0.00,0.00,1,1),(72,29,'钛银黑',0.00,0.00,1,1),(73,30,'官方标配',0.00,0.00,1,1),(74,30,'套餐一',100.00,100.00,1,1),(75,31,'8+256GB',50.00,50.00,1,1),(76,31,'12+512GB',200.00,200.00,1,1),(77,32,'5G',100.00,100.00,1,1),(78,35,'4G+全网通',0.00,0.00,1,1),(79,36,'碳纤黑',0.00,0.00,1,1),(80,36,'火焰红',0.00,0.00,1,1),(81,36,'冰川蓝',0.00,0.00,1,1),(82,37,'官方标配',0.00,0.00,1,1),(83,37,'套餐二',100.00,100.00,1,1),(84,38,'6+128G',0.00,0.00,1,1),(85,38,'8+256G',500.00,500.00,1,1),(86,39,'深空灰色',0.00,0.00,1,1),(87,39,'银色',0.00,0.00,1,1),(88,39,'金色',0.00,0.00,1,1),(89,40,'官方标配',0.00,0.00,1,1),(90,40,'套餐一',39.00,39.00,1,1),(91,40,'套餐二',39.00,39.00,1,1),(92,40,'套餐三',60.00,60.00,1,1),(93,41,'64G',0.00,0.00,1,1),(94,41,'256G',600.00,600.00,1,1),(95,41,'512G',3689.00,3689.00,1,1),(96,42,'黑色',0.00,0.00,1,1),(97,42,'白色',100.00,100.00,1,1),(98,42,'红色',-100.00,-100.00,1,1),(99,42,'黄色',200.00,200.00,1,1),(100,42,'绿色',800.00,800.00,1,1),(101,42,'紫色',500.00,500.00,1,1),(102,43,'官方标配',0.00,0.00,1,1),(103,44,'64G',0.00,0.00,1,1),(104,44,'128G',300.00,300.00,1,1),(105,44,'256G',1200.00,1200.00,1,1),(106,45,'165/M',0.00,0.00,1,1),(107,45,'170/L',0.00,0.00,1,1),(108,45,'175/XL',0.00,0.00,1,1),(109,45,'180/XXL',0.00,0.00,1,1),(110,45,'185/XXL',0.00,0.00,1,1),(111,45,'190/XXXL',0.00,0.00,1,1),(112,46,'H014黑色',0.00,0.00,1,1),(113,46,'H014白色',0.00,0.00,1,1),(114,46,'H008黑色',0.00,0.00,1,1),(115,47,'170/88/XS',0.00,0.00,1,1),(116,46,'H009黑色',0.00,0.00,1,1),(117,46,'H009白色',0.00,0.00,1,1),(118,47,'175/92/S',0.00,0.00,1,1),(119,47,'175/96/M',0.00,0.00,1,1),(120,47,'180/100/L',0.00,0.00,1,1),(121,47,'185/104/XL',0.00,0.00,1,1),(122,47,'185/108/XXL',0.00,0.00,1,1),(123,47,'190/112/XXXL',0.00,0.00,1,1),(124,48,'主题图款一',0.00,0.00,1,1),(125,48,'黑-加绒款',0.00,0.00,1,1),(127,48,'深蓝',0.00,0.00,1,1),(128,48,'ZNE',0.00,0.00,1,1),(129,48,'灰加绒',0.00,0.00,1,1),(130,48,'灰',0.00,0.00,1,1),(131,48,'黑连帽',0.00,0.00,1,1),(132,49,'XS',0.00,0.00,1,1),(133,49,'S',0.00,0.00,1,1),(134,49,'M',0.00,0.00,1,1),(135,49,'L',0.00,0.00,1,1),(136,49,'XL',0.00,0.00,1,1),(137,49,'XXL',0.00,0.00,1,1),(138,50,'S97065/针织款/新品上市',0.00,0.00,1,1),(139,50,'DP2419/针织款',30.00,30.00,1,1),(140,50,'DP2412/针织款',40.00,40.00,1,1),(141,50,'S97085/针织款',40.00,40.00,1,1),(142,50,'DP2411/针织款',30.00,30.00,1,1),(143,50,'FK3515/速干防风衣',70.00,70.00,1,1),(144,50,'FK3517//速干防风衣',107.00,107.00,1,1),(145,50,'EH3908/速干防风衣',70.00,70.00,1,1),(146,26,'火焰红',10.00,10.00,1,1),(147,26,'冷艳蓝',10.00,10.00,1,1),(148,51,'500g/箱',8.00,8.00,1,1),(149,51,'1000g/箱',25.00,25.00,1,1),(150,51,'1500g/箱',98.00,95.00,1,1),(151,52,'24袋/箱',85.00,88.00,1,1),(152,52,'36袋/箱',88.00,85.00,1,1);

/*Table structure for table `commodity_subtype` */

DROP TABLE IF EXISTS `commodity_subtype`;

CREATE TABLE `commodity_subtype` (
  `subtype_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '子类类型ID',
  `type_id` int(11) DEFAULT NULL COMMENT '主类类型ID',
  `subtype_name` varchar(30) NOT NULL COMMENT '子类类型名称',
  `subtype_describe` varchar(100) DEFAULT NULL COMMENT '子类类型描述',
  `subtype_state` int(11) DEFAULT '1' COMMENT '子类类型状态',
  `subsort_code` int(11) DEFAULT '1' COMMENT '子类排序码',
  PRIMARY KEY (`subtype_id`),
  KEY `sub_type_fk` (`type_id`),
  CONSTRAINT `sub_type_fk` FOREIGN KEY (`type_id`) REFERENCES `commodity_type` (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=763 DEFAULT CHARSET=utf8;

/*Data for the table `commodity_subtype` */

insert  into `commodity_subtype`(`subtype_id`,`type_id`,`subtype_name`,`subtype_describe`,`subtype_state`,`subsort_code`) values (1,1,'连衣裙',NULL,1,1),(2,1,'T恤',NULL,1,1),(3,1,'衬衫',NULL,1,1),(4,1,'裤子',NULL,1,1),(5,1,'牛仔裤',NULL,1,1),(6,1,'西装',NULL,1,1),(7,1,'短外套',NULL,1,1),(8,1,'时尚套餐',NULL,1,1),(9,1,'半身裙',NULL,1,1),(10,1,'毛针织衫',NULL,1,1),(11,1,'卫衣绒衫',NULL,1,1),(12,1,'大码女装',NULL,1,1),(13,1,'背心吊带',NULL,1,1),(14,1,'毛衣',NULL,1,1),(15,1,'羽绒服',NULL,1,1),(16,1,'皮衣',NULL,1,1),(17,1,'棉衣棉服',NULL,1,1),(18,1,'中老年女装',NULL,1,1),(19,1,'打底裤',NULL,1,1),(20,1,'婚纱礼服',NULL,1,1),(21,1,'汉服',NULL,1,1),(22,2,'春夏新品',NULL,1,1),(23,2,'T恤',NULL,1,1),(24,2,'衬衫',NULL,1,1),(25,2,'POLO衫',NULL,1,1),(26,2,'休闲库',NULL,1,1),(27,2,'套装',NULL,1,1),(28,2,'外套',NULL,1,1),(29,2,'夹克',NULL,1,1),(30,2,'卫衣',NULL,1,1),(31,2,'风衣',NULL,1,1),(32,2,'西装',NULL,1,1),(33,2,'牛仔外套',NULL,1,1),(34,2,'棒球服',NULL,1,1),(35,2,'皮衣',NULL,1,1),(36,2,'运动裤',NULL,1,1),(37,2,'工装裤',NULL,1,1),(38,2,'开衫',NULL,1,1),(39,2,'马甲',NULL,1,1),(40,2,'羽绒服',NULL,1,1),(41,3,'法式内衣',NULL,1,1),(42,3,'内裤女',NULL,1,1),(43,3,'文胸',NULL,1,1),(44,3,'内裤男',NULL,1,1),(45,3,'长袖睡衣',NULL,1,1),(46,3,'睡裙',NULL,1,1),(47,3,'丝袜',NULL,1,1),(48,3,'船袜',NULL,1,1),(49,3,'情侣睡衣',NULL,1,1),(50,3,'抹胸',NULL,1,1),(51,3,'背心',NULL,1,1),(52,3,'睡袍',NULL,1,1),(53,3,'男士睡衣',NULL,1,1),(54,3,'塑身衣',NULL,1,1),(55,3,'内衣套餐',NULL,1,1),(56,3,'打底裤',NULL,1,1),(57,3,'男士袜子',NULL,1,1),(58,3,'棉袜女',NULL,1,1),(59,3,'卡通睡衣',NULL,1,1),(60,4,'流行女鞋',NULL,1,1),(61,4,'春上新',NULL,1,1),(62,4,'潮流新品',NULL,1,1),(63,4,'单鞋',NULL,1,1),(64,4,'靴子',NULL,1,1),(65,4,'运动风',NULL,1,1),(66,4,'高跟鞋',NULL,1,1),(67,4,'红人同款',NULL,1,1),(68,4,'厚底鞋',NULL,1,1),(69,4,'内增高',NULL,1,1),(70,4,'玛丽珍鞋',NULL,1,1),(71,4,'蝴蝶结鞋',NULL,1,1),(72,4,'小白鞋',NULL,1,1),(73,4,'一脚蹬',NULL,1,1),(74,4,'圆头鞋',NULL,1,1),(75,4,'方根鞋',NULL,1,1),(76,4,'水晶鞋',NULL,1,1),(77,4,'男鞋',NULL,1,1),(78,4,'休闲鞋',NULL,1,1),(79,4,'板鞋',NULL,1,1),(80,4,'帆布鞋',NULL,1,1),(81,4,'豆豆鞋',NULL,1,1),(82,4,'乐福鞋',NULL,1,1),(83,4,'户外休闲',NULL,1,1),(84,4,'爸爸鞋',NULL,1,1),(85,5,'女包',NULL,1,1),(86,5,'双肩包',NULL,1,1),(87,5,'男包',NULL,1,1),(88,5,'旅行箱',NULL,1,1),(89,5,'钱包',NULL,1,1),(90,5,'真皮包',NULL,1,1),(91,5,'大牌',NULL,1,1),(92,5,'小方包',NULL,1,1),(93,5,'水桶包',NULL,1,1),(94,5,'迷你包',NULL,1,1),(95,5,'链条包',NULL,1,1),(96,5,'贝壳包',NULL,1,1),(97,5,'手拿包',NULL,1,1),(98,5,'单肩包',NULL,1,1),(99,5,'手提包',NULL,1,1),(100,5,'斜挎包',NULL,1,1),(101,5,'日韩流行',NULL,1,1),(102,5,'男士商务',NULL,1,1),(103,5,'拉杆箱',NULL,1,1),(104,5,'腰包',NULL,1,1),(105,5,'胸包',NULL,1,1),(106,5,'手工皮具',NULL,1,1),(107,6,'帽子',NULL,1,1),(108,6,'贝雷帽',NULL,1,1),(109,6,'渔夫帽',NULL,1,1),(110,6,'鸭舌帽',NULL,1,1),(111,6,'草帽',NULL,1,1),(112,6,'礼帽',NULL,1,1),(113,6,'围巾',NULL,1,1),(114,6,'丝巾',NULL,1,1),(115,6,'披肩',NULL,1,1),(116,6,'方巾',NULL,1,1),(117,6,'手套',NULL,1,1),(118,6,'真皮手套',NULL,1,1),(119,6,'触屏手套',NULL,1,1),(120,6,'半指手套',NULL,1,1),(121,6,'全指手套',NULL,1,1),(122,6,'真皮腰带',NULL,1,1),(123,6,'腰带',NULL,1,1),(124,6,'手工皮带',NULL,1,1),(125,7,'居家睡衣',NULL,1,1),(126,7,'针织',NULL,1,1),(127,7,'帽子',NULL,1,1),(128,7,'亲子装',NULL,1,1),(129,7,'童鞋',NULL,1,1),(130,7,'学步鞋',NULL,1,1),(131,7,'女童运动鞋',NULL,1,1),(132,7,'男童运动鞋',NULL,1,1),(133,7,'毛毛虫童鞋',NULL,1,1),(134,7,'雪地靴',NULL,1,1),(135,7,'马丁靴',NULL,1,1),(136,7,'长靴',NULL,1,1),(137,7,'玩具',NULL,1,1),(138,7,'积木',NULL,1,1),(139,7,'毛绒玩具',NULL,1,1),(140,7,'早教',NULL,1,1),(141,7,'儿童自行车',NULL,1,1),(142,7,'电动童车',NULL,1,1),(143,7,'遥控模型',NULL,1,1),(144,7,'户外玩具',NULL,1,1),(145,7,'亲子玩具',NULL,1,1),(146,7,'学习用品',NULL,1,1),(147,7,'描红本',NULL,1,1),(148,8,'美妈大衣',NULL,1,1),(149,8,'孕妇裤',NULL,1,1),(150,8,'月子服',NULL,1,1),(151,8,'哺乳文胸',NULL,1,1),(152,8,'吸奶器',NULL,1,1),(153,8,'防辐射',NULL,1,1),(154,8,'孕妇内裤',NULL,1,1),(155,8,'连衣裙',NULL,1,1),(156,8,'待产包',NULL,1,1),(157,8,'孕妇牛仔裤',NULL,1,1),(158,8,'孕妇营养品',NULL,1,1),(159,8,'防溢乳垫',NULL,1,1),(160,8,'美德乐',NULL,1,1),(161,8,'十月妈咪',NULL,1,1),(162,8,'三洋',NULL,1,1),(163,8,'新生儿',NULL,1,1),(164,8,'婴儿车',NULL,1,1),(165,8,'婴儿推车',NULL,1,1),(166,8,'睡袋',NULL,1,1),(167,8,'包被',NULL,1,1),(168,8,'学步车',NULL,1,1),(169,8,'安抚奶嘴',NULL,1,1),(170,8,'体温计',NULL,1,1),(171,8,'纸尿裤',NULL,1,1),(172,8,'花王',NULL,1,1),(173,9,'爱他美',NULL,1,1),(174,9,'羊奶粉',NULL,1,1),(175,9,'特殊配方奶粉',NULL,1,1),(176,9,'喜宝',NULL,1,1),(177,9,'惠氏',NULL,1,1),(178,9,'启赋',NULL,1,1),(179,9,'美素佳儿',NULL,1,1),(180,9,'牛栏',NULL,1,1),(181,9,'贝因美',NULL,1,1),(182,9,'雅培',NULL,1,1),(183,9,'美赞臣',NULL,1,1),(184,9,'科瑞康',NULL,1,1),(185,9,'a2',NULL,1,1),(186,9,'嘉宝',NULL,1,1),(187,9,'美林',NULL,1,1),(188,9,'米粉',NULL,1,1),(189,9,'泡芙',NULL,1,1),(190,9,'溶溶豆',NULL,1,1),(191,9,'果肉条',NULL,1,1),(192,9,'奶片',NULL,1,1),(193,9,'益生菌',NULL,1,1),(194,9,'维生素',NULL,1,1),(195,9,'钙铁锌',NULL,1,1),(196,9,'DHA',NULL,1,1),(197,9,'核桃油',NULL,1,1),(198,9,'葡萄糖',NULL,1,1),(199,9,'奶瓶',NULL,1,1),(200,9,'餐具',NULL,1,1),(201,10,'生活电器',NULL,1,1),(202,10,'厨房电器',NULL,1,1),(203,10,'个人护理',NULL,1,1),(204,10,'空气净化器',NULL,1,1),(205,10,'扫地机器人',NULL,1,1),(206,10,'吸尘器',NULL,1,1),(207,10,'取暖器',NULL,1,1),(208,10,'烤箱',NULL,1,1),(209,10,'豆浆机',NULL,1,1),(210,10,'榨汁料理',NULL,1,1),(211,10,'电饭煲',NULL,1,1),(212,10,'吹风机',NULL,1,1),(213,10,'足浴盆',NULL,1,1),(214,10,'剃须刀',NULL,1,1),(215,10,'卷发器',NULL,1,1),(216,10,'按摩器材',NULL,1,1),(217,10,'冬季火锅',NULL,1,1),(218,10,'蓝牙耳机',NULL,1,1),(219,10,'电暖桌',NULL,1,1),(220,10,'蓝牙音箱',NULL,1,1),(221,10,'电热毯',NULL,1,1),(222,10,'加湿器',NULL,1,1),(223,10,'暖风机',NULL,1,1),(224,11,'游戏主机',NULL,1,1),(225,11,'数码精选',NULL,1,1),(226,11,'手机壳套',NULL,1,1),(227,11,'苹果手机壳',NULL,1,1),(228,11,'电脑主机',NULL,1,1),(229,11,'数码相机',NULL,1,1),(230,11,'电玩动漫',NULL,1,1),(231,11,'单反相机',NULL,1,1),(232,11,'鼠标键盘',NULL,1,1),(233,11,'无人机',NULL,1,1),(234,11,'二手数码',NULL,1,1),(235,11,'二手手机',NULL,1,1),(236,11,'二手笔记本',NULL,1,1),(237,11,'二手平板',NULL,1,1),(238,11,'二手平板电脑',NULL,1,1),(239,12,'iPhone xs',NULL,1,1),(240,12,'iPhone xs max',NULL,1,1),(241,12,'小米手机',NULL,1,1),(242,12,'华为手机',NULL,1,1),(243,12,'魅族手机',NULL,1,1),(244,12,'锤子手机',NULL,1,1),(245,12,'vivo手机',NULL,1,1),(246,12,'OPPO手机',NULL,1,1),(247,12,'苹果手机',NULL,1,1),(248,12,'二手手机',NULL,1,1),(249,13,'面膜',NULL,1,1),(250,13,'洁面',NULL,1,1),(251,13,'防嗮',NULL,1,1),(252,13,'爽肤水',NULL,1,1),(253,13,'眼霜',NULL,1,1),(254,13,'乳液',NULL,1,1),(255,13,'面霜',NULL,1,1),(256,13,'精华',NULL,1,1),(257,13,'卸妆',NULL,1,1),(258,13,'男士护肤',NULL,1,1),(259,13,'眼线',NULL,1,1),(260,13,'粉底液',NULL,1,1),(261,13,'BB霜',NULL,1,1),(262,13,'隔离',NULL,1,1),(263,13,'睫毛膏',NULL,1,1),(264,13,'美妆盘',NULL,1,1),(265,13,'唇膏',NULL,1,1),(266,13,'腮红',NULL,1,1),(267,13,'香水',NULL,1,1),(268,13,'精油',NULL,1,1),(269,13,'身体护理',NULL,1,1),(270,13,'脱毛',NULL,1,1),(271,14,'洗发水',NULL,1,1),(272,14,'护发素',NULL,1,1),(273,14,'发膜',NULL,1,1),(274,14,'头发造型',NULL,1,1),(275,14,'染发膏',NULL,1,1),(276,14,'烫发水',NULL,1,1),(277,14,'假发',NULL,1,1),(278,14,'沐浴露',NULL,1,1),(279,14,'私处护理',NULL,1,1),(280,14,'牙膏',NULL,1,1),(281,14,'牙刷',NULL,1,1),(282,14,'漱口水',NULL,1,1),(283,14,'足浴',NULL,1,1),(284,14,'足贴',NULL,1,1),(285,14,'洗手液',NULL,1,1),(286,14,'卫生巾',NULL,1,1),(287,14,'成人纸尿裤',NULL,1,1),(288,14,'抽纸',NULL,1,1),(289,14,'卷纸',NULL,1,1),(290,14,'洗衣液',NULL,1,1),(291,14,'清洁剂',NULL,1,1),(292,14,'厨房清洁',NULL,1,1),(293,14,'香薰',NULL,1,1),(294,15,'B族维生素',NULL,1,1),(295,15,'葡萄籽',NULL,1,1),(296,15,'辅酶Q10',NULL,1,1),(297,15,'消化酶',NULL,1,1),(298,15,'软骨素',NULL,1,1),(299,15,'维生素C',NULL,1,1),(300,15,'钙',NULL,1,1),(301,15,'大豆异黄酮',NULL,1,1),(302,15,'益生菌',NULL,1,1),(303,15,'鱼油',NULL,1,1),(304,15,'氨基葡萄糖',NULL,1,1),(305,15,'生物素',NULL,1,1),(306,15,'吗啡（玛卡）',NULL,1,1),(307,15,'酵素',NULL,1,1),(308,15,'螺旋藻',NULL,1,1),(309,15,'胶原蛋白',NULL,1,1),(310,15,'月见草油',NULL,1,1),(311,15,'蔓越莓',NULL,1,1),(312,15,'左旋肉碱',NULL,1,1),(313,15,'褪黑素',NULL,1,1),(314,16,'琥珀蜜蜡',NULL,1,1),(315,16,'翡翠手镯',NULL,1,1),(316,16,'钻戒',NULL,1,1),(317,16,'铂金',NULL,1,1),(318,16,'黄金首饰',NULL,1,1),(319,16,'高端定制',NULL,1,1),(320,16,'彩色宝石',NULL,1,1),(321,16,'珍珠',NULL,1,1),(322,16,'金镶玉',NULL,1,1),(323,16,'钻石',NULL,1,1),(324,16,'K金首饰',NULL,1,1),(325,16,'岫岩玉雕',NULL,1,1),(326,16,'和田籽料拍卖',NULL,1,1),(327,16,'裸石',NULL,1,1),(328,16,'翡翠玉石',NULL,1,1),(329,16,'珠宝首饰',NULL,1,1),(330,16,'金条',NULL,1,1),(331,16,'情侣对戒',NULL,1,1),(332,16,'琥珀原石',NULL,1,1),(333,17,'眼镜架',NULL,1,1),(334,17,'3D眼镜',NULL,1,1),(335,17,'司机镜',NULL,1,1),(336,17,'老花镜',NULL,1,1),(337,17,'防辐射眼镜',NULL,1,1),(338,17,'色盲眼镜',NULL,1,1),(339,17,'无框眼镜',NULL,1,1),(340,17,'眼镜片',NULL,1,1),(341,17,'依视路',NULL,1,1),(342,17,'雷朋',NULL,1,1),(343,17,'复古眼镜',NULL,1,1),(344,17,'超轻眼镜',NULL,1,1),(345,17,'护目镜',NULL,1,1),(346,17,'眼镜配件',NULL,1,1),(347,17,'滑雪镜',NULL,1,1),(348,17,'超耐磨',NULL,1,1),(349,18,'运动表',NULL,1,1),(350,18,'卡西欧',NULL,1,1),(351,18,'国表',NULL,1,1),(352,18,'时尚表',NULL,1,1),(353,18,'女表',NULL,1,1),(354,18,'儿童表',NULL,1,1),(355,18,'学生表',NULL,1,1),(356,18,'浪琴',NULL,1,1),(357,18,'瑞士表',NULL,1,1),(358,18,'镂空机械表',NULL,1,1),(359,18,'皮带表',NULL,1,1),(360,18,'钢带表',NULL,1,1),(361,18,'电子表',NULL,1,1),(362,18,'复古手表',NULL,1,1),(363,18,'中性手表',NULL,1,1),(364,18,'深度防水',NULL,1,1),(365,18,'手表配件',NULL,1,1),(366,18,'表带',NULL,1,1),(367,19,'耐克',NULL,1,1),(368,19,'阿迪达斯',NULL,1,1),(369,19,'亚瑟士',NULL,1,1),(370,19,'匡威',NULL,1,1),(371,19,'彪马',NULL,1,1),(372,19,'VANS',NULL,1,1),(373,19,'锐步',NULL,1,1),(374,19,'斯凯奇',NULL,1,1),(375,19,'美津浓',NULL,1,1),(376,19,'李宁',NULL,1,1),(377,19,'跑鞋',NULL,1,1),(378,19,'篮球鞋',NULL,1,1),(379,19,'足球',NULL,1,1),(380,19,'篮球',NULL,1,1),(381,19,'羽毛球',NULL,1,1),(382,19,'乒乓球',NULL,1,1),(383,19,'排球',NULL,1,1),(384,19,'游泳圈',NULL,1,1),(385,19,'健身',NULL,1,1),(386,20,'鱼线',NULL,1,1),(387,20,'渔线轮',NULL,1,1),(388,20,'户外鞋',NULL,1,1),(389,20,'登山包',NULL,1,1),(390,20,'帐篷',NULL,1,1),(391,20,'睡袋',NULL,1,1),(392,20,'望远镜',NULL,1,1),(393,20,'速干衣',NULL,1,1),(394,20,'手电筒',NULL,1,1),(395,20,'山地车',NULL,1,1),(396,20,'速干衣',NULL,1,1),(397,20,'公路车',NULL,1,1),(398,20,'骑行服',NULL,1,1),(399,20,'护具',NULL,1,1),(400,20,'军迷用品',NULL,1,1),(401,20,'舞蹈体操',NULL,1,1),(402,20,'羽毛球',NULL,1,1),(403,20,'游泳',NULL,1,1),(404,20,'瑜伽',NULL,1,1),(405,20,'跑步机',NULL,1,1),(406,20,'健身器材',NULL,1,1),(407,20,'烧烤架',NULL,1,1),(408,20,'休闲鞋',NULL,1,1),(409,20,'单车零件',NULL,1,1),(410,20,'骑行装备',NULL,1,1),(411,20,'遮阳棚',NULL,1,1),(412,20,'户外手表',NULL,1,1),(413,20,'军迷套装',NULL,1,1),(414,20,'战术鞋',NULL,1,1),(415,21,'全新钢琴',NULL,1,1),(416,21,'二手钢琴',NULL,1,1),(417,21,'电钢琴',NULL,1,1),(418,21,'电子琴',NULL,1,1),(419,21,'萨克斯',NULL,1,1),(420,21,'尤克里里',NULL,1,1),(421,21,'架子鼓',NULL,1,1),(422,21,'小提琴',NULL,1,1),(423,21,'口琴',NULL,1,1),(424,21,'手卷钢琴',NULL,1,1),(425,21,'古筝',NULL,1,1),(426,21,'二胡',NULL,1,1),(427,21,'葫芦丝',NULL,1,1),(428,21,'陶笛',NULL,1,1),(429,21,'琵琶',NULL,1,1),(430,21,'笛子',NULL,1,1),(431,21,'非洲鼓',NULL,1,1),(432,21,'贝斯',NULL,1,1),(433,21,'调音器',NULL,1,1),(434,21,'节拍器',NULL,1,1),(435,21,'电吉他',NULL,1,1),(436,21,'电箱吉他',NULL,1,1),(437,21,'乐器音箱',NULL,1,1),(438,21,'电子鼓',NULL,1,1),(439,21,'手风琴',NULL,1,1),(440,21,'大提琴',NULL,1,1),(441,21,'合成器',NULL,1,1),(442,22,'DNF',NULL,1,1),(443,22,'梦幻西游',NULL,1,1),(444,22,'魔兽',NULL,1,1),(445,22,'LOL',NULL,1,1),(446,22,'坦克世界',NULL,1,1),(447,22,'剑网3',NULL,1,1),(448,22,'魔域',NULL,1,1),(449,22,'DOTA2',NULL,1,1),(450,22,'街头篮球',NULL,1,1),(451,22,'CF',NULL,1,1),(452,22,'天龙八部',NULL,1,1),(453,22,'大话西游2',NULL,1,1),(454,22,'三国争霸',NULL,1,1),(455,22,'劲舞团',NULL,1,1),(456,22,'倩女幽魂',NULL,1,1),(457,22,'天下3',NULL,1,1),(458,22,'反恐精英',NULL,1,1),(459,22,'冒险岛',NULL,1,1),(460,22,'问道',NULL,1,1),(461,22,'逆战',NULL,1,1),(462,22,'大唐无双',NULL,1,1),(463,22,'龙之谷',NULL,1,1),(464,22,'热血江湖',NULL,1,1),(465,22,'剑灵',NULL,1,1),(466,23,'手办',NULL,1,1),(467,23,'盲盒',NULL,1,1),(468,23,'航海王',NULL,1,1),(469,23,'命运之夜',NULL,1,1),(470,23,'高达模型',NULL,1,1),(471,23,'火影忍者',NULL,1,1),(472,23,'LOLITA洋装',NULL,1,1),(473,23,'潮玩',NULL,1,1),(474,23,'变形金刚',NULL,1,1),(475,23,'钢铁侠',NULL,1,1),(476,23,'COSPLAY服装',NULL,1,1),(477,23,'魔道祖师',NULL,1,1),(478,23,'BJD娃娃',NULL,1,1),(479,23,'假面骑士',NULL,1,1),(480,23,'名侦探柯南',NULL,1,1),(481,23,'我的英雄学院',NULL,1,1),(482,23,'哈利波特',NULL,1,1),(483,23,'秦时明月',NULL,1,1),(484,23,'剑网三',NULL,1,1),(485,23,'游戏王',NULL,1,1),(486,23,'兵人',NULL,1,1),(487,23,'七龙珠',NULL,1,1),(488,23,'美国队长',NULL,1,1),(489,24,'你的名字',NULL,1,1),(490,24,'动物世界',NULL,1,1),(491,24,'大圣归来',NULL,1,1),(492,24,'大鱼海棠',NULL,1,1),(493,24,'毒液',NULL,1,1),(494,24,'战狼',NULL,1,1),(495,24,'星球大战',NULL,1,1),(496,24,'海绵宝宝历险记',NULL,1,1),(497,24,'深夜食堂',NULL,1,1),(498,24,'碟中谍',NULL,1,1),(499,24,'神奇动物',NULL,1,1),(500,24,'老九门',NULL,1,1),(501,24,'赛尔号',NULL,1,1),(502,24,'黑豹',NULL,1,1),(503,24,'玩具总动员',NULL,1,1),(504,24,'正义联盟',NULL,1,1),(505,24,'金刚狼',NULL,1,1),(506,24,'流浪地球',NULL,1,1),(507,25,'牛奶',NULL,1,1),(508,25,'柚子茶',NULL,1,1),(509,25,'酸梅汤',NULL,1,1),(510,25,'矿泉水',NULL,1,1),(511,25,'酵素',NULL,1,1),(512,25,'藕粉',NULL,1,1),(513,25,'大米',NULL,1,1),(514,25,'小米',NULL,1,1),(515,25,'黄豆',NULL,1,1),(516,25,'木耳',NULL,1,1),(517,25,'枸杞',NULL,1,1),(518,25,'人参',NULL,1,1),(519,25,'石斛',NULL,1,1),(520,25,'雪蛤',NULL,1,1),(521,25,'蜂蜜',NULL,1,1),(522,25,'铁观音',NULL,1,1),(523,25,'红茶',NULL,1,1),(524,25,'花草茶',NULL,1,1),(525,25,'龙井',NULL,1,1),(526,25,'黑茶',NULL,1,1),(527,25,'绿茶',NULL,1,1),(528,25,'鸡尾酒',NULL,1,1),(529,25,'洋酒',NULL,1,1),(530,25,'红酒',NULL,1,1),(531,26,'水果',NULL,1,1),(532,26,'荔枝',NULL,1,1),(533,26,'百香果',NULL,1,1),(534,26,'芒果',NULL,1,1),(535,26,'小龙虾',NULL,1,1),(536,26,'海鲜',NULL,1,1),(537,26,'榴莲',NULL,1,1),(538,26,'牛排',NULL,1,1),(539,26,'柠檬',NULL,1,1),(540,26,'海参',NULL,1,1),(541,26,'水蜜桃',NULL,1,1),(542,26,'咸鸭蛋',NULL,1,1),(543,26,'李子',NULL,1,1),(544,26,'桃子',NULL,1,1),(545,26,'苹果',NULL,1,1),(546,26,'黄桃',NULL,1,1),(547,26,'火龙果',NULL,1,1),(548,26,'三文鱼',NULL,1,1),(549,26,'红薯',NULL,1,1),(550,26,'蓝莓',NULL,1,1),(551,27,'冰皮月饼',NULL,1,1),(552,27,'零食大礼包',NULL,1,1),(553,27,'牛肉干',NULL,1,1),(554,27,'面包',NULL,1,1),(555,27,'辣条',NULL,1,1),(556,27,'红枣',NULL,1,1),(557,27,'核桃',NULL,1,1),(558,27,'饼干',NULL,1,1),(559,27,'巧克力',NULL,1,1),(560,27,'葡萄干',NULL,1,1),(561,27,'芒果干',NULL,1,1),(562,27,'绿豆糕',NULL,1,1),(563,27,'薯片',NULL,1,1),(564,27,'锅巴',NULL,1,1),(565,27,'海苔',NULL,1,1),(566,27,'月饼',NULL,1,1),(567,27,'蛋白酥',NULL,1,1),(568,27,'猪肉脯',NULL,1,1),(569,27,'花生',NULL,1,1),(570,27,'瓜子',NULL,1,1),(571,27,'棒棒糖',NULL,1,1),(572,27,'手撕面包',NULL,1,1),(573,27,'豆干',NULL,1,1),(574,27,'开心果',NULL,1,1),(575,27,'坚果',NULL,1,1),(576,27,'山楂',NULL,1,1),(577,27,'全麦面包',NULL,1,1),(578,27,'早餐',NULL,1,1),(579,27,'腰果',NULL,1,1),(580,27,'压缩饼干',NULL,1,1),(581,28,'鲜花速递',NULL,1,1),(582,28,'多肉植物',NULL,1,1),(583,28,'干花',NULL,1,1),(584,28,'永生花',NULL,1,1),(585,28,'食肉植物',NULL,1,1),(586,28,'桌面盆栽',NULL,1,1),(587,28,'鲜果蓝',NULL,1,1),(588,28,'仿真蔬果',NULL,1,1),(589,28,'开业花篮',NULL,1,1),(590,28,'花瓶',NULL,1,1),(591,28,'蔬菜种子',NULL,1,1),(592,28,'肥料',NULL,1,1),(593,28,'花盆花器',NULL,1,1),(594,28,'水培花卉',NULL,1,1),(595,28,'花卉药剂',NULL,1,1),(596,28,'营养土',NULL,1,1),(597,28,'园艺工具',NULL,1,1),(598,28,'洒水壶',NULL,1,1),(599,28,'花架',NULL,1,1),(600,28,'铺面石',NULL,1,1),(601,29,'进口狗粮',NULL,1,1),(602,29,'宠物服饰',NULL,1,1),(603,29,'宠物窝',NULL,1,1),(604,29,'航空箱',NULL,1,1),(605,29,'海藻粉',NULL,1,1),(606,29,'狗零食',NULL,1,1),(607,29,'剃毛器',NULL,1,1),(608,29,'营养膏',NULL,1,1),(609,29,'上门服务',NULL,1,1),(610,29,'猫砂',NULL,1,1),(611,29,'猫粮',NULL,1,1),(612,29,'猫砂盆',NULL,1,1),(613,29,'化毛膏',NULL,1,1),(614,29,'猫罐头',NULL,1,1),(615,29,'喂食器',NULL,1,1),(616,29,'猫抓板',NULL,1,1),(617,29,'猫玩具',NULL,1,1),(618,29,'水草',NULL,1,1),(619,29,'水草泥',NULL,1,1),(620,29,'仿真水草',NULL,1,1),(621,29,'氧气泵',NULL,1,1),(622,29,'过滤器',NULL,1,1),(623,29,'鱼缸',NULL,1,1),(624,29,'水草灯',NULL,1,1),(625,30,'农药',NULL,1,1),(626,30,'除草剂',NULL,1,1),(627,30,'杀虫剂',NULL,1,1),(628,30,'杀菌剂',NULL,1,1),(629,30,'肥料',NULL,1,1),(630,30,'叶面肥',NULL,1,1),(631,30,'有机肥',NULL,1,1),(632,30,'新型肥料',NULL,1,1),(633,30,'氮肥',NULL,1,1),(634,30,'磷肥',NULL,1,1),(635,30,'钾肥',NULL,1,1),(636,30,'种子/种苗',NULL,1,1),(637,30,'粮油种',NULL,1,1),(638,30,'蔬菜种',NULL,1,1),(639,30,'果树苗',NULL,1,1),(640,30,'饲料',NULL,1,1),(641,30,'预混料',NULL,1,1),(642,30,'农具',NULL,1,1),(643,30,'农膜',NULL,1,1),(644,30,'农机',NULL,1,1),(645,30,'农配件',NULL,1,1),(646,30,'畜牧药品/兽药',NULL,1,1),(647,30,'化学药',NULL,1,1),(648,30,'消毒剂',NULL,1,1),(649,31,'电钻',NULL,1,1),(650,31,'气钉枪',NULL,1,1),(651,31,'电锯',NULL,1,1),(652,31,'抛光机',NULL,1,1),(653,31,'磨砂机',NULL,1,1),(654,31,'修边机',NULL,1,1),(655,31,'焊接设备',NULL,1,1),(656,31,'扳手',NULL,1,1),(657,31,'钳子',NULL,1,1),(658,31,'锉、刨',NULL,1,1),(659,31,'打磨机',NULL,1,1),(660,31,'角磨机',NULL,1,1),(661,31,'工具组套',NULL,1,1),(662,31,'电锯片',NULL,1,1),(663,31,'电锤',NULL,1,1),(664,31,'云石片',NULL,1,1),(665,31,'电动螺丝批',NULL,1,1),(666,31,'测电笔',NULL,1,1),(667,31,'电子钳',NULL,1,1),(668,31,'电烙铁',NULL,1,1),(669,31,'电子焊接工具套装',NULL,1,1),(670,31,'接线板',NULL,1,1),(671,31,'断路器',NULL,1,1),(672,31,'开关',NULL,1,1),(673,31,'布线箱',NULL,1,1),(674,31,'转换器',NULL,1,1),(675,31,'插座',NULL,1,1),(676,31,'电线',NULL,1,1),(677,31,'电工套管',NULL,1,1),(678,31,'监控器材及系统',NULL,1,1),(679,31,'防盗报警器材及系统',NULL,1,1),(680,32,'全包',NULL,1,1),(681,32,'半包',NULL,1,1),(682,32,'免费设计',NULL,1,1),(683,32,'全套设计',NULL,1,1),(684,32,'优质装修公司',NULL,1,1),(685,32,'样板',NULL,1,1),(686,32,'小户型',NULL,1,1),(687,32,'美式风',NULL,1,1),(688,32,'宜家风',NULL,1,1),(689,33,'建材优品',NULL,1,1),(690,33,'智能马桶',NULL,1,1),(691,33,'客厅灯',NULL,1,1),(692,33,'实木地板',NULL,1,1),(693,33,'强化地板',NULL,1,1),(694,33,'仿古砖',NULL,1,1),(695,33,'花砖',NULL,1,1),(696,33,'马赛克',NULL,1,1),(697,33,'玻化砖',NULL,1,1),(698,33,'浴室柜',NULL,1,1),(699,33,'花洒',NULL,1,1),(700,33,'水槽',NULL,1,1),(701,33,'台上盆',NULL,1,1),(702,33,'毛巾杆',NULL,1,1),(703,33,'普通马桶',NULL,1,1),(704,33,'龙头',NULL,1,1),(705,33,'浴缸',NULL,1,1),(706,33,'墙纸',NULL,1,1),(707,33,'墙布',NULL,1,1),(708,33,'背景墙',NULL,1,1),(709,33,'指纹锁',NULL,1,1),(710,34,'沙发',NULL,1,1),(711,34,'床',NULL,1,1),(712,34,'高低床',NULL,1,1),(713,34,'餐桌',NULL,1,1),(714,34,'床垫',NULL,1,1),(715,34,'茶几',NULL,1,1),(716,34,'电视柜',NULL,1,1),(717,34,'衣柜',NULL,1,1),(718,34,'鞋柜',NULL,1,1),(719,34,'椅凳',NULL,1,1),(720,34,'书桌',NULL,1,1),(721,34,'电脑桌',NULL,1,1),(722,34,'坐具',NULL,1,1),(723,34,'现代简约',NULL,1,1),(724,34,'美式家具',NULL,1,1),(725,34,'北欧家具',NULL,1,1),(726,34,'中式家具',NULL,1,1),(727,34,'真皮沙发',NULL,1,1),(728,34,'布艺沙发',NULL,1,1),(729,34,'皮床',NULL,1,1),(730,34,'实木床',NULL,1,1),(731,34,'儿童床',NULL,1,1),(732,34,'乳胶床垫',NULL,1,1),(733,34,'儿童学习桌',NULL,1,1),(734,34,'书架',NULL,1,1),(735,35,'窗帘',NULL,1,1),(736,35,'地毯',NULL,1,1),(737,35,'沙发垫',NULL,1,1),(738,35,'十字绣',NULL,1,1),(739,35,'桌布',NULL,1,1),(740,35,'地垫',NULL,1,1),(741,35,'抱枕',NULL,1,1),(742,35,'坐垫',NULL,1,1),(743,35,'飘窗垫',NULL,1,1),(744,35,'门帘',NULL,1,1),(745,35,'缝纫机',NULL,1,1),(746,35,'洗衣机罩',NULL,1,1),(747,35,'卷帘',NULL,1,1),(748,36,'草席',NULL,1,1),(749,36,'床禄',NULL,1,1),(750,36,'u型枕',NULL,1,1),(751,36,'蚊帐',NULL,1,1),(752,36,'凉席',NULL,1,1),(753,36,'天丝套件',NULL,1,1),(754,36,'婚庆套件',NULL,1,1),(755,36,'空调被',NULL,1,1),(756,36,'儿童床品',NULL,1,1),(757,36,'麻将凉席',NULL,1,1),(758,36,'四件套',NULL,1,1),(759,36,'毛巾被',NULL,1,1),(760,1,'夹克',NULL,1,1),(761,46,'图书','人类进步的阶梯',1,1),(762,47,'图书优惠卷','图书是人类进步的阶梯',1,1);

/*Table structure for table `commodity_type` */

DROP TABLE IF EXISTS `commodity_type`;

CREATE TABLE `commodity_type` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主类类型ID',
  `type_name` varchar(30) NOT NULL COMMENT '主类型名称',
  `type_describe` varchar(100) DEFAULT NULL COMMENT '主类类型描述',
  `type_state` int(11) DEFAULT '1' COMMENT '主类类型状态',
  `sort_code` int(11) DEFAULT '1' COMMENT '主类排序码',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;

/*Data for the table `commodity_type` */

insert  into `commodity_type`(`type_id`,`type_name`,`type_describe`,`type_state`,`sort_code`) values (1,'女装','',1,1),(2,'男装','',1,1),(3,'内衣','',1,1),(4,'鞋靴','',1,1),(5,'箱包','',1,1),(6,'配件','',1,1),(7,'童装玩具','',1,1),(8,'孕产','',1,1),(9,'用品','',1,1),(10,'家电','',1,1),(11,'数码',NULL,1,1),(12,'手机',NULL,1,1),(13,'美妆',NULL,1,1),(14,'洗护',NULL,1,1),(15,'保健品',NULL,1,1),(16,'珠宝',NULL,1,1),(17,'眼睛',NULL,1,1),(18,'手表',NULL,1,1),(19,'运动',NULL,1,1),(20,'户外',NULL,1,1),(21,'乐器',NULL,1,1),(22,'游戏',NULL,1,1),(23,'动漫',NULL,1,1),(24,'影视',NULL,1,1),(25,'美食',NULL,1,1),(26,'生鲜',NULL,1,1),(27,'零食',NULL,1,1),(28,'鲜花',NULL,1,1),(29,'宠物',NULL,1,1),(30,'农贸',NULL,1,1),(31,'工具',NULL,1,1),(32,'装修',NULL,1,1),(33,'建材',NULL,1,1),(34,'家具',NULL,1,1),(35,'家饰',NULL,1,1),(36,'家纺',NULL,1,1),(37,'汽车',NULL,1,1),(38,'二手车',NULL,1,1),(39,'用品',NULL,1,1),(40,'办公',NULL,1,1),(41,'DIY',NULL,1,1),(42,'五金电子',NULL,1,1),(43,'百货',NULL,1,1),(44,'餐厨',NULL,1,1),(45,'家庭保健',NULL,1,1),(46,'学习',NULL,1,1),(47,'卡劵',NULL,1,1),(48,'本地服务',NULL,1,1);

/*Table structure for table `evaluate` */

DROP TABLE IF EXISTS `evaluate`;

CREATE TABLE `evaluate` (
  `evaluate_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '评价id',
  `particulars_id` int(11) DEFAULT NULL COMMENT '订单号id',
  `commodity_score` int(11) DEFAULT '10' COMMENT '商品评分',
  `logistic_score` int(11) DEFAULT '10' COMMENT '物流评分',
  `service_score` int(11) DEFAULT '10' COMMENT '服务评分',
  `evaluate` varchar(100) DEFAULT NULL COMMENT '评价内容',
  `evlauate_date` date DEFAULT NULL COMMENT '评价日期',
  PRIMARY KEY (`evaluate_id`),
  KEY `eval_oreder_fk` (`particulars_id`),
  CONSTRAINT `eval_oreder_fk` FOREIGN KEY (`particulars_id`) REFERENCES `order_list_particulars` (`particulars_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `evaluate` */

insert  into `evaluate`(`evaluate_id`,`particulars_id`,`commodity_score`,`logistic_score`,`service_score`,`evaluate`,`evlauate_date`) values (1,2,10,10,10,'这个商品我很喜欢,下次还会买','2009-07-31'),(2,2,10,10,10,'这个商品不错','2019-10-08'),(3,3,10,10,10,'拍照效果：拍照效果很好，夜景柔和，非常棒 显示效果：屏幕采用AMOLED，显示效果卓越 电池续航：续航能力没有想象的那么差，虽然容量小，但是按照大部分手机一天一充的情况，可以接受 运行速度：速度极快，','2019-11-23'),(4,4,10,10,10,'拍照效果：拍照效果很好，夜景柔和，非常棒 显示效果：屏幕采用AMOLED，显示效果卓越 电池续航：续航能力没有想象的那么差，虽然容量小，但是按照大部分手机一天一充的情况，可以接受 运行速度：速度极快，','2019-11-10'),(5,5,10,10,10,'这个商品不错','2019-11-11');

/*Table structure for table `location` */

DROP TABLE IF EXISTS `location`;

CREATE TABLE `location` (
  `location_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '地址ID',
  `account_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `provinces` varchar(20) NOT NULL COMMENT '省',
  `city` varchar(20) NOT NULL COMMENT '市',
  `county` varchar(20) NOT NULL COMMENT '县',
  `specific_location` varchar(100) NOT NULL COMMENT '具体地址',
  `default_location` int(1) DEFAULT '0' COMMENT '是否为默认收获地址',
  `consignee` varchar(20) NOT NULL COMMENT '收件人',
  `phone` varchar(11) NOT NULL COMMENT '收货人电话',
  PRIMARY KEY (`location_id`),
  KEY `location_acc_fk` (`account_id`),
  CONSTRAINT `location_acc_fk` FOREIGN KEY (`account_id`) REFERENCES `account` (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `location` */

insert  into `location`(`location_id`,`account_id`,`provinces`,`city`,`county`,`specific_location`,`default_location`,`consignee`,`phone`) values (1,1,'福建','南平','南平市','青年大道69号',1,'吉祥','18213229960'),(2,1,'河北省','张家口市','张北县','张北大道76号',0,'丁二','18827190000'),(3,1,'山西省','大同市','年区','同地锦园78号',0,'南','18800005656'),(4,1,'北京','北京','北京市','宜化小区69号',1,'路明非','123'),(5,1,'海南','白沙黎族自治县','白沙黎族自治县','青年大道69号',1,'吉祥','18213229960');

/*Table structure for table `merchant` */

DROP TABLE IF EXISTS `merchant`;

CREATE TABLE `merchant` (
  `merchant_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商家ID',
  `merchant_name` varchar(50) NOT NULL,
  `account` varchar(30) NOT NULL COMMENT '商家登录账户',
  `merchant_password` varchar(30) NOT NULL COMMENT '商家登录密码',
  `unify_code` varchar(20) NOT NULL COMMENT '社会征信统一代码',
  `manage` varchar(100) NOT NULL COMMENT '经营范围',
  `location` varchar(100) NOT NULL COMMENT '商家地址',
  `money` double(10,2) NOT NULL COMMENT '注册资金',
  `corp` varchar(20) NOT NULL COMMENT '法人',
  `corp_phone` varchar(11) NOT NULL COMMENT '法人电话',
  `director` varchar(20) DEFAULT NULL COMMENT '主管',
  `director_phone` varchar(11) DEFAULT NULL COMMENT '主管电话',
  `merchant_balance` double(10,2) DEFAULT '0.00' COMMENT '商家余额',
  `record_date` date NOT NULL COMMENT '注册日期',
  `record_state` int(1) DEFAULT '1' COMMENT '注册状态',
  `admin_id` int(11) DEFAULT NULL COMMENT '平台管理员',
  `check_date` date DEFAULT NULL COMMENT '审核日期',
  `license_picture` varchar(50) NOT NULL COMMENT '营业与可证图片',
  `corp_picture` varchar(50) NOT NULL COMMENT ' 法人ID_card图片',
  PRIMARY KEY (`merchant_id`),
  UNIQUE KEY `account` (`account`),
  KEY `admin_mer_fk` (`admin_id`),
  CONSTRAINT `admin_mer_fk` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`admin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

/*Data for the table `merchant` */

insert  into `merchant`(`merchant_id`,`merchant_name`,`account`,`merchant_password`,`unify_code`,`manage`,`location`,`money`,`corp`,`corp_phone`,`director`,`director_phone`,`merchant_balance`,`record_date`,`record_state`,`admin_id`,`check_date`,`license_picture`,`corp_picture`) values (1,'百草味','baicaowei','bcw123','123456789123456789','零食大礼包','北京市',10000000.00,'吴老板','13799720853','南老板','13799720852',100.00,'2019-10-15',3,1,'2019-10-16','14.jpg','15.jpg'),(2,'百岁山','baisuishan','bss123','123456789123456789','矿泉水','上海市',1000000.00,'南老板','18827910000',NULL,NULL,0.00,'2018-11-23',3,1,'2018-11-24','14.jpg','15.jpg'),(3,'测试店家','admin','admin','1234567891234431234','测试','福建',134.00,'撒法','2341324134',NULL,NULL,0.00,'2019-10-08',3,1,'2019-10-11','3.jpg','4.jpg'),(4,'耐克旗舰店','naike','naike123','134132412341','鞋子，衣服','南昌市',1000000.00,'乔丹','2345243',NULL,NULL,0.00,'2019-10-19',3,1,'2019-10-17','3.jpg','4.jpg'),(5,'小米手机官方旗舰店','xiaomi','xiaomi','45243524352455','手机电脑、智能家具、等等','深圳市',99999999.99,'雷军','34234123441',NULL,NULL,0.00,'2019-10-18',3,2,'2019-10-26','3.jpg','4.jpg'),(6,' vimtree旗舰店','vimtree','vimtree','7861151515','女士内裤 男士内裤 ','北京',4654313.00,'吉祥','555135',NULL,NULL,0.00,'2019-10-09',3,1,'2019-10-30','3.jpg','4.jpg'),(7,'博盛景数码专营店','pingguossjouji','pingguossjouji','94656','手机 平板 等','济南',10000000.00,'乔布斯','65465',NULL,NULL,0.00,'2019-10-09',3,2,'2019-10-30','4.jpg','4.jpg'),(8,'花花公子官方旗舰店','huahuagongzi','huahuagongzi','1431443242','衣服、袜子、裤子等','浙江',1000000.00,'老花','12313113',NULL,NULL,0.00,'2019-10-24',3,2,'2019-10-18','3.jpg','4.jpg'),(9,'阿迪达斯官网旗舰','adidas','adidas','86462','鞋子 衣服 篮球','北平',10620626.00,'科比','45611',NULL,NULL,0.00,'2019-10-01',3,2,'2019-10-30','3.jpg','3.jpg'),(10,'惠普科技有限公司','HP','admin','134657954623','笔记本电脑','深圳市南山区',1000000.00,'南老板','1377972215','那老板','1377977515',0.00,'2019-11-11',3,1,NULL,'14.jpg','15.jpg'),(11,'惠普科技有限公司','惠普科技','admin','343434','笔记本电脑','深圳市南山区',10000.00,'孙悟空','13799720853','猪八戒','1379972085',0.00,'2019-11-11',3,1,NULL,'15734396444774341921682221.jpg_430x430q90','15734396452657021921682221.jpg_430x430q90');

/*Table structure for table `merchant_repertory` */

DROP TABLE IF EXISTS `merchant_repertory`;

CREATE TABLE `merchant_repertory` (
  `repertory_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '库存id',
  `commodity_id` int(11) DEFAULT NULL COMMENT '商品id',
  `subsort` varchar(100) DEFAULT NULL COMMENT '商品详细类别',
  `check_repertory` int(11) DEFAULT NULL COMMENT '检查库存',
  `count_repertory` int(11) DEFAULT NULL COMMENT '统计库存',
  `check_date` date NOT NULL COMMENT '检查日期',
  `check_name` varchar(20) NOT NULL COMMENT '检查人',
  PRIMARY KEY (`repertory_id`),
  KEY `commo_reper_fk` (`commodity_id`),
  CONSTRAINT `commo_reper_fk` FOREIGN KEY (`commodity_id`) REFERENCES `commodity` (`commodity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1164 DEFAULT CHARSET=utf8;

/*Data for the table `merchant_repertory` */

insert  into `merchant_repertory`(`repertory_id`,`commodity_id`,`subsort`,`check_repertory`,`count_repertory`,`check_date`,`check_name`) values (1,1,'规格一箱24瓶',100,100,'2019-10-31','泰达米尔'),(2,2,'规格一箱两百包',100,100,'2019-10-31','亚索'),(13,5,'梦之白套餐一12+512GB5G',50,50,'2019-11-01','当前登录人'),(14,5,'梦之白套餐一8+256GB5G',50,50,'2019-11-01','当前登录人'),(15,5,'梦之白官方标配12+512GB5G',50,50,'2019-11-01','当前登录人'),(16,5,'梦之白官方标配8+256GB5G',50,50,'2019-11-01','当前登录人'),(17,5,'钛银黑套餐一12+512GB5G',50,50,'2019-11-01','当前登录人'),(18,5,'钛银黑套餐一8+256GB5G',50,50,'2019-11-01','当前登录人'),(19,5,'钛银黑官方标配12+512GB5G',50,50,'2019-11-01','当前登录人'),(20,5,'钛银黑官方标配8+256GB5G',50,50,'2019-11-01','当前登录人'),(173,1,'21款果干(彩箱)百草味1000g/箱',0,0,'2019-11-11','当前登录人'),(174,1,'21款果干(彩箱)百草味1500g/箱',0,0,'2019-11-11','当前登录人'),(175,1,'21款果干(彩箱)百草味500g/箱',0,0,'2019-11-11','当前登录人'),(176,1,'21款果干（Fou you礼盒）百草味1000g/箱',0,0,'2019-11-11','当前登录人'),(177,1,'21款果干（Fou you礼盒）百草味1500g/箱',0,0,'2019-11-11','当前登录人'),(178,1,'21款果干（Fou you礼盒）百草味500g/箱',0,0,'2019-11-11','当前登录人'),(179,1,'21款果干（世界那么大）百草味1000g/箱',100,0,'2019-11-11','当前登录人'),(180,1,'21款果干（世界那么大）百草味1500g/箱',100,0,'2019-11-11','当前登录人'),(181,1,'21款果干（世界那么大）百草味500g/箱',100,0,'2019-11-11','当前登录人'),(182,1,'21款果干（往后余生礼盒）百草味1000g/箱',0,0,'2019-11-11','当前登录人'),(183,1,'21款果干（往后余生礼盒）百草味1500g/箱',0,0,'2019-11-11','当前登录人'),(184,1,'21款果干（往后余生礼盒）百草味500g/箱',0,0,'2019-11-11','当前登录人'),(185,1,'21款果干（我的女神礼盒）百草味1000g/箱',0,0,'2019-11-11','当前登录人'),(186,1,'21款果干（我的女神礼盒）百草味1500g/箱',0,0,'2019-11-11','当前登录人'),(187,1,'21款果干（我的女神礼盒）百草味500g/箱',0,0,'2019-11-11','当前登录人'),(188,1,'21款果干（熬过异地礼盒）百草味1000g/箱',0,0,'2019-11-11','当前登录人'),(189,1,'21款果干（熬过异地礼盒）百草味1500g/箱',0,0,'2019-11-11','当前登录人'),(190,1,'21款果干（熬过异地礼盒）百草味500g/箱',0,0,'2019-11-11','当前登录人'),(191,1,'21款果干（猪饲料礼盒）百草味1000g/箱',0,0,'2019-11-11','当前登录人'),(192,1,'21款果干（猪饲料礼盒）百草味1500g/箱',0,0,'2019-11-11','当前登录人'),(193,1,'21款果干（猪饲料礼盒）百草味500g/箱',0,0,'2019-11-11','当前登录人'),(194,1,'21款果干（空投箱礼盒）百草味1000g/箱',0,0,'2019-11-11','当前登录人'),(195,1,'21款果干（空投箱礼盒）百草味1500g/箱',0,0,'2019-11-11','当前登录人'),(196,1,'21款果干（空投箱礼盒）百草味500g/箱',0,0,'2019-11-11','当前登录人'),(197,1,'21款果干（锦鲤礼盒）百草味1000g/箱',0,0,'2019-11-11','当前登录人'),(198,1,'21款果干（锦鲤礼盒）百草味1500g/箱',0,0,'2019-11-11','当前登录人'),(199,1,'21款果干（锦鲤礼盒）百草味500g/箱',0,0,'2019-11-11','当前登录人'),(200,1,'21款果干（陪伴你礼盒）百草味1000g/箱',0,0,'2019-11-11','当前登录人'),(201,1,'21款果干（陪伴你礼盒）百草味1500g/箱',0,0,'2019-11-11','当前登录人'),(202,1,'21款果干（陪伴你礼盒）百草味500g/箱',0,0,'2019-11-11','当前登录人'),(203,1,'食品口味:21款果干（世界那么大）百草味',20,20,'2019-11-11','当前登录人'),(204,1,'食品口味:21款果干（空投箱礼盒）百草味',2,2,'2019-11-11','当前登录人'),(205,1,'果干无聊急救包800g×1盒',0,0,'2019-11-11','当前登录人'),(206,1,'每日抱抱果30天装758g×1盒',0,0,'2019-11-11','当前登录人'),(207,1,'水果干礼盒420g×1盒',0,0,'2019-11-11','当前登录人'),(208,1,'蔬菜干礼包548g×1盒',0,0,'2019-11-11','当前登录人'),(209,1,'零食大礼包590g×1盒',0,0,'2019-11-11','当前登录人'),(210,2,'一箱',1,-1,'2019-11-11','当前登录人'),(211,1,'夏威夷果100g',1,0,'2019-11-11','当前登录人'),(212,1,'夏威夷果218g',0,0,'2019-11-11','当前登录人'),(213,1,'夏威夷果56gg',0,0,'2019-11-11','当前登录人'),(484,1,'21款果干(彩箱)百草味1000g/箱',100,100,'2019-11-22','当前登录人'),(485,1,'21款果干(彩箱)百草味1500g/箱',0,0,'2019-11-22','当前登录人'),(486,1,'21款果干(彩箱)百草味500g/箱',0,0,'2019-11-22','当前登录人'),(487,1,'21款果干（Fou you礼盒）百草味1000g/箱',0,0,'2019-11-22','当前登录人'),(488,1,'21款果干（Fou you礼盒）百草味1500g/箱',0,0,'2019-11-22','当前登录人'),(489,1,'21款果干（Fou you礼盒）百草味500g/箱',0,0,'2019-11-22','当前登录人'),(490,1,'21款果干（世界那么大）百草味1000g/箱',0,0,'2019-11-22','当前登录人'),(491,1,'21款果干（世界那么大）百草味1500g/箱',0,0,'2019-11-22','当前登录人'),(492,1,'21款果干（世界那么大）百草味500g/箱',0,0,'2019-11-22','当前登录人'),(493,1,'21款果干（往后余生礼盒）百草味1000g/箱',0,0,'2019-11-22','当前登录人'),(494,1,'21款果干（往后余生礼盒）百草味1500g/箱',0,0,'2019-11-22','当前登录人'),(495,1,'21款果干（往后余生礼盒）百草味500g/箱',0,0,'2019-11-22','当前登录人'),(496,1,'21款果干（我的女神礼盒）百草味1000g/箱',0,0,'2019-11-22','当前登录人'),(497,1,'21款果干（我的女神礼盒）百草味1500g/箱',0,0,'2019-11-22','当前登录人'),(498,1,'21款果干（我的女神礼盒）百草味500g/箱',0,0,'2019-11-22','当前登录人'),(499,1,'21款果干（熬过异地礼盒）百草味1000g/箱',0,0,'2019-11-22','当前登录人'),(500,1,'21款果干（熬过异地礼盒）百草味1500g/箱',0,0,'2019-11-22','当前登录人'),(501,1,'21款果干（熬过异地礼盒）百草味500g/箱',0,0,'2019-11-22','当前登录人'),(502,1,'21款果干（猪饲料礼盒）百草味1000g/箱',0,0,'2019-11-22','当前登录人'),(503,1,'21款果干（猪饲料礼盒）百草味1500g/箱',0,0,'2019-11-22','当前登录人'),(504,1,'21款果干（猪饲料礼盒）百草味500g/箱',0,0,'2019-11-22','当前登录人'),(505,1,'21款果干（空投箱礼盒）百草味1000g/箱',0,0,'2019-11-22','当前登录人'),(506,1,'21款果干（空投箱礼盒）百草味1500g/箱',0,0,'2019-11-22','当前登录人'),(507,1,'21款果干（空投箱礼盒）百草味500g/箱',96,96,'2019-11-22','当前登录人'),(508,1,'21款果干（锦鲤礼盒）百草味1000g/箱',0,0,'2019-11-22','当前登录人'),(509,1,'21款果干（锦鲤礼盒）百草味1500g/箱',0,0,'2019-11-22','当前登录人'),(510,1,'21款果干（锦鲤礼盒）百草味500g/箱',0,0,'2019-11-22','当前登录人'),(511,1,'21款果干（陪伴你礼盒）百草味1000g/箱',0,0,'2019-11-22','当前登录人'),(512,1,'21款果干（陪伴你礼盒）百草味1500g/箱',0,0,'2019-11-22','当前登录人'),(513,1,'21款果干（陪伴你礼盒）百草味500g/箱',0,0,'2019-11-22','当前登录人'),(514,2,'果干无聊急救包800g×1盒',0,0,'2019-11-22','当前登录人'),(515,2,'每日抱抱果30天装758g×1盒',0,0,'2019-11-22','当前登录人'),(516,2,'水果干礼盒420g×1盒',2,2,'2019-11-22','当前登录人'),(517,2,'蔬菜干礼包548g×1盒',0,0,'2019-11-22','当前登录人'),(518,2,'零食大礼包590g×1盒',0,0,'2019-11-22','当前登录人'),(519,3,'夏威夷果100g',0,0,'2019-11-22','当前登录人'),(520,3,'夏威夷果218g',0,0,'2019-11-22','当前登录人'),(521,3,'夏威夷果56gg',0,0,'2019-11-22','当前登录人'),(522,73,'24袋/箱',0,0,'2019-11-22','当前登录人'),(523,73,'36袋/箱',0,0,'2019-11-22','当前登录人'),(684,1,'21款果干(彩箱)百草味1000g/箱',100,100,'2019-11-23','当前登录人'),(685,1,'21款果干(彩箱)百草味1500g/箱',0,0,'2019-11-23','当前登录人'),(686,1,'21款果干(彩箱)百草味500g/箱',0,0,'2019-11-23','当前登录人'),(687,1,'21款果干（Fou you礼盒）百草味1000g/箱',0,0,'2019-11-23','当前登录人'),(688,1,'21款果干（Fou you礼盒）百草味1500g/箱',0,0,'2019-11-23','当前登录人'),(689,1,'21款果干（Fou you礼盒）百草味500g/箱',0,0,'2019-11-23','当前登录人'),(690,1,'21款果干（世界那么大）百草味1000g/箱',0,0,'2019-11-23','当前登录人'),(691,1,'21款果干（世界那么大）百草味1500g/箱',0,0,'2019-11-23','当前登录人'),(692,1,'21款果干（世界那么大）百草味500g/箱',0,0,'2019-11-23','当前登录人'),(693,1,'21款果干（往后余生礼盒）百草味1000g/箱',0,0,'2019-11-23','当前登录人'),(694,1,'21款果干（往后余生礼盒）百草味1500g/箱',0,0,'2019-11-23','当前登录人'),(695,1,'21款果干（往后余生礼盒）百草味500g/箱',0,0,'2019-11-23','当前登录人'),(696,1,'21款果干（我的女神礼盒）百草味1000g/箱',100,100,'2019-11-23','当前登录人'),(697,1,'21款果干（我的女神礼盒）百草味1500g/箱',0,0,'2019-11-23','当前登录人'),(698,1,'21款果干（我的女神礼盒）百草味500g/箱',0,0,'2019-11-23','当前登录人'),(699,1,'21款果干（熬过异地礼盒）百草味1000g/箱',0,0,'2019-11-23','当前登录人'),(700,1,'21款果干（熬过异地礼盒）百草味1500g/箱',0,0,'2019-11-23','当前登录人'),(701,1,'21款果干（熬过异地礼盒）百草味500g/箱',0,0,'2019-11-23','当前登录人'),(702,1,'21款果干（猪饲料礼盒）百草味1000g/箱',0,0,'2019-11-23','当前登录人'),(703,1,'21款果干（猪饲料礼盒）百草味1500g/箱',0,0,'2019-11-23','当前登录人'),(704,1,'21款果干（猪饲料礼盒）百草味500g/箱',0,0,'2019-11-23','当前登录人'),(705,1,'21款果干（空投箱礼盒）百草味1000g/箱',0,0,'2019-11-23','当前登录人'),(706,1,'21款果干（空投箱礼盒）百草味1500g/箱',0,0,'2019-11-23','当前登录人'),(707,1,'21款果干（空投箱礼盒）百草味500g/箱',96,96,'2019-11-23','当前登录人'),(708,1,'21款果干（锦鲤礼盒）百草味1000g/箱',0,0,'2019-11-23','当前登录人'),(709,1,'21款果干（锦鲤礼盒）百草味1500g/箱',0,0,'2019-11-23','当前登录人'),(710,1,'21款果干（锦鲤礼盒）百草味500g/箱',0,0,'2019-11-23','当前登录人'),(711,1,'21款果干（陪伴你礼盒）百草味1000g/箱',0,0,'2019-11-23','当前登录人'),(712,1,'21款果干（陪伴你礼盒）百草味1500g/箱',0,0,'2019-11-23','当前登录人'),(713,1,'21款果干（陪伴你礼盒）百草味500g/箱',0,0,'2019-11-23','当前登录人'),(714,2,'果干无聊急救包800g×1盒',0,0,'2019-11-23','当前登录人'),(715,2,'每日抱抱果30天装758g×1盒',0,0,'2019-11-23','当前登录人'),(716,2,'水果干礼盒420g×1盒',2,2,'2019-11-23','当前登录人'),(717,2,'蔬菜干礼包548g×1盒',0,0,'2019-11-23','当前登录人'),(718,2,'零食大礼包590g×1盒',0,0,'2019-11-23','当前登录人'),(719,3,'夏威夷果100g',0,0,'2019-11-23','当前登录人'),(720,3,'夏威夷果218g',0,0,'2019-11-23','当前登录人'),(721,3,'夏威夷果56gg',100,0,'2019-11-23','当前登录人'),(722,73,'24袋/箱',100,100,'2019-11-23','当前登录人'),(723,73,'36袋/箱',88,88,'2019-11-23','当前登录人'),(1004,1,'21款果干(彩箱)百草味1000g/箱',100,100,'2019-11-24','baicaowei'),(1005,1,'21款果干(彩箱)百草味1500g/箱',0,0,'2019-11-24','baicaowei'),(1006,1,'21款果干(彩箱)百草味500g/箱',0,0,'2019-11-24','baicaowei'),(1007,1,'21款果干（Fou you礼盒）百草味1000g/箱',0,0,'2019-11-24','baicaowei'),(1008,1,'21款果干（Fou you礼盒）百草味1500g/箱',0,0,'2019-11-24','baicaowei'),(1009,1,'21款果干（Fou you礼盒）百草味500g/箱',0,0,'2019-11-24','baicaowei'),(1010,1,'21款果干（世界那么大）百草味1000g/箱',0,0,'2019-11-24','baicaowei'),(1011,1,'21款果干（世界那么大）百草味1500g/箱',0,0,'2019-11-24','baicaowei'),(1012,1,'21款果干（世界那么大）百草味500g/箱',0,0,'2019-11-24','baicaowei'),(1013,1,'21款果干（往后余生礼盒）百草味1000g/箱',0,0,'2019-11-24','baicaowei'),(1014,1,'21款果干（往后余生礼盒）百草味1500g/箱',0,0,'2019-11-24','baicaowei'),(1015,1,'21款果干（往后余生礼盒）百草味500g/箱',0,0,'2019-11-24','baicaowei'),(1016,1,'21款果干（我的女神礼盒）百草味1000g/箱',100,100,'2019-11-24','baicaowei'),(1017,1,'21款果干（我的女神礼盒）百草味1500g/箱',0,0,'2019-11-24','baicaowei'),(1018,1,'21款果干（我的女神礼盒）百草味500g/箱',0,0,'2019-11-24','baicaowei'),(1019,1,'21款果干（熬过异地礼盒）百草味1000g/箱',0,0,'2019-11-24','baicaowei'),(1020,1,'21款果干（熬过异地礼盒）百草味1500g/箱',0,0,'2019-11-24','baicaowei'),(1021,1,'21款果干（熬过异地礼盒）百草味500g/箱',0,0,'2019-11-24','baicaowei'),(1022,1,'21款果干（猪饲料礼盒）百草味1000g/箱',0,0,'2019-11-24','baicaowei'),(1023,1,'21款果干（猪饲料礼盒）百草味1500g/箱',0,0,'2019-11-24','baicaowei'),(1024,1,'21款果干（猪饲料礼盒）百草味500g/箱',0,0,'2019-11-24','baicaowei'),(1025,1,'21款果干（空投箱礼盒）百草味1000g/箱',0,0,'2019-11-24','baicaowei'),(1026,1,'21款果干（空投箱礼盒）百草味1500g/箱',0,0,'2019-11-24','baicaowei'),(1027,1,'21款果干（空投箱礼盒）百草味500g/箱',96,96,'2019-11-24','baicaowei'),(1028,1,'21款果干（锦鲤礼盒）百草味1000g/箱',0,0,'2019-11-24','baicaowei'),(1029,1,'21款果干（锦鲤礼盒）百草味1500g/箱',0,0,'2019-11-24','baicaowei'),(1030,1,'21款果干（锦鲤礼盒）百草味500g/箱',0,0,'2019-11-24','baicaowei'),(1031,1,'21款果干（陪伴你礼盒）百草味1000g/箱',0,0,'2019-11-24','baicaowei'),(1032,1,'21款果干（陪伴你礼盒）百草味1500g/箱',0,0,'2019-11-24','baicaowei'),(1033,1,'21款果干（陪伴你礼盒）百草味500g/箱',0,0,'2019-11-24','baicaowei'),(1034,2,'果干无聊急救包800g×1盒',0,0,'2019-11-24','baicaowei'),(1035,2,'每日抱抱果30天装758g×1盒',0,0,'2019-11-24','baicaowei'),(1036,2,'水果干礼盒420g×1盒',2,2,'2019-11-24','baicaowei'),(1037,2,'蔬菜干礼包548g×1盒',0,0,'2019-11-24','baicaowei'),(1038,2,'零食大礼包590g×1盒',0,0,'2019-11-24','baicaowei'),(1039,3,'夏威夷果100g',0,0,'2019-11-24','baicaowei'),(1040,3,'夏威夷果218g',0,0,'2019-11-24','baicaowei'),(1041,3,'夏威夷果56gg',100,100,'2019-11-24','baicaowei'),(1042,73,'24袋/箱',100,100,'2019-11-24','baicaowei'),(1043,73,'36袋/箱',88,88,'2019-11-24','baicaowei'),(1044,1,'21款果干(彩箱)百草味1000g/箱',100,100,'2019-11-25','baicaowei'),(1045,1,'21款果干(彩箱)百草味1500g/箱',0,0,'2019-11-25','baicaowei'),(1046,1,'21款果干(彩箱)百草味500g/箱',0,0,'2019-11-25','baicaowei'),(1047,1,'21款果干（Fou you礼盒）百草味1000g/箱',0,0,'2019-11-25','baicaowei'),(1048,1,'21款果干（Fou you礼盒）百草味1500g/箱',0,0,'2019-11-25','baicaowei'),(1049,1,'21款果干（Fou you礼盒）百草味500g/箱',0,0,'2019-11-25','baicaowei'),(1050,1,'21款果干（世界那么大）百草味1000g/箱',0,0,'2019-11-25','baicaowei'),(1051,1,'21款果干（世界那么大）百草味1500g/箱',0,0,'2019-11-25','baicaowei'),(1052,1,'21款果干（世界那么大）百草味500g/箱',0,0,'2019-11-25','baicaowei'),(1053,1,'21款果干（往后余生礼盒）百草味1000g/箱',0,0,'2019-11-25','baicaowei'),(1054,1,'21款果干（往后余生礼盒）百草味1500g/箱',0,0,'2019-11-25','baicaowei'),(1055,1,'21款果干（往后余生礼盒）百草味500g/箱',0,0,'2019-11-25','baicaowei'),(1056,1,'21款果干（我的女神礼盒）百草味1000g/箱',100,100,'2019-11-25','baicaowei'),(1057,1,'21款果干（我的女神礼盒）百草味1500g/箱',0,0,'2019-11-25','baicaowei'),(1058,1,'21款果干（我的女神礼盒）百草味500g/箱',0,0,'2019-11-25','baicaowei'),(1059,1,'21款果干（熬过异地礼盒）百草味1000g/箱',0,0,'2019-11-25','baicaowei'),(1060,1,'21款果干（熬过异地礼盒）百草味1500g/箱',0,0,'2019-11-25','baicaowei'),(1061,1,'21款果干（熬过异地礼盒）百草味500g/箱',0,0,'2019-11-25','baicaowei'),(1062,1,'21款果干（猪饲料礼盒）百草味1000g/箱',0,0,'2019-11-25','baicaowei'),(1063,1,'21款果干（猪饲料礼盒）百草味1500g/箱',0,0,'2019-11-25','baicaowei'),(1064,1,'21款果干（猪饲料礼盒）百草味500g/箱',0,0,'2019-11-25','baicaowei'),(1065,1,'21款果干（空投箱礼盒）百草味1000g/箱',0,0,'2019-11-25','baicaowei'),(1066,1,'21款果干（空投箱礼盒）百草味1500g/箱',0,0,'2019-11-25','baicaowei'),(1067,1,'21款果干（空投箱礼盒）百草味500g/箱',96,96,'2019-11-25','baicaowei'),(1068,1,'21款果干（锦鲤礼盒）百草味1000g/箱',0,0,'2019-11-25','baicaowei'),(1069,1,'21款果干（锦鲤礼盒）百草味1500g/箱',0,0,'2019-11-25','baicaowei'),(1070,1,'21款果干（锦鲤礼盒）百草味500g/箱',0,0,'2019-11-25','baicaowei'),(1071,1,'21款果干（陪伴你礼盒）百草味1000g/箱',0,0,'2019-11-25','baicaowei'),(1072,1,'21款果干（陪伴你礼盒）百草味1500g/箱',0,0,'2019-11-25','baicaowei'),(1073,1,'21款果干（陪伴你礼盒）百草味500g/箱',0,0,'2019-11-25','baicaowei'),(1074,2,'果干无聊急救包800g×1盒',0,0,'2019-11-25','baicaowei'),(1075,2,'每日抱抱果30天装758g×1盒',0,0,'2019-11-25','baicaowei'),(1076,2,'水果干礼盒420g×1盒',2,2,'2019-11-25','baicaowei'),(1077,2,'蔬菜干礼包548g×1盒',0,0,'2019-11-25','baicaowei'),(1078,2,'零食大礼包590g×1盒',0,0,'2019-11-25','baicaowei'),(1079,3,'夏威夷果100g',0,0,'2019-11-25','baicaowei'),(1080,3,'夏威夷果218g',0,0,'2019-11-25','baicaowei'),(1081,3,'夏威夷果56gg',100,100,'2019-11-25','baicaowei'),(1082,73,'24袋/箱',100,100,'2019-11-25','baicaowei'),(1083,73,'36袋/箱',88,88,'2019-11-25','baicaowei'),(1084,1,'21款果干(彩箱)百草味1000g/箱',0,0,'2019-11-27','baicaowei'),(1085,1,'21款果干(彩箱)百草味1500g/箱',0,0,'2019-11-27','baicaowei'),(1086,1,'21款果干(彩箱)百草味500g/箱',0,0,'2019-11-27','baicaowei'),(1087,1,'21款果干（Fou you礼盒）百草味1000g/箱',0,0,'2019-11-27','baicaowei'),(1088,1,'21款果干（Fou you礼盒）百草味1500g/箱',0,0,'2019-11-27','baicaowei'),(1089,1,'21款果干（Fou you礼盒）百草味500g/箱',0,0,'2019-11-27','baicaowei'),(1090,1,'21款果干（世界那么大）百草味1000g/箱',0,0,'2019-11-27','baicaowei'),(1091,1,'21款果干（世界那么大）百草味1500g/箱',0,0,'2019-11-27','baicaowei'),(1092,1,'21款果干（世界那么大）百草味500g/箱',0,0,'2019-11-27','baicaowei'),(1093,1,'21款果干（往后余生礼盒）百草味1000g/箱',0,0,'2019-11-27','baicaowei'),(1094,1,'21款果干（往后余生礼盒）百草味1500g/箱',0,0,'2019-11-27','baicaowei'),(1095,1,'21款果干（往后余生礼盒）百草味500g/箱',0,0,'2019-11-27','baicaowei'),(1096,1,'21款果干（我的女神礼盒）百草味1000g/箱',0,0,'2019-11-27','baicaowei'),(1097,1,'21款果干（我的女神礼盒）百草味1500g/箱',0,0,'2019-11-27','baicaowei'),(1098,1,'21款果干（我的女神礼盒）百草味500g/箱',0,0,'2019-11-27','baicaowei'),(1099,1,'21款果干（熬过异地礼盒）百草味1000g/箱',0,0,'2019-11-27','baicaowei'),(1100,1,'21款果干（熬过异地礼盒）百草味1500g/箱',0,0,'2019-11-27','baicaowei'),(1101,1,'21款果干（熬过异地礼盒）百草味500g/箱',0,0,'2019-11-27','baicaowei'),(1102,1,'21款果干（猪饲料礼盒）百草味1000g/箱',0,0,'2019-11-27','baicaowei'),(1103,1,'21款果干（猪饲料礼盒）百草味1500g/箱',0,0,'2019-11-27','baicaowei'),(1104,1,'21款果干（猪饲料礼盒）百草味500g/箱',0,0,'2019-11-27','baicaowei'),(1105,1,'21款果干（空投箱礼盒）百草味1000g/箱',0,0,'2019-11-27','baicaowei'),(1106,1,'21款果干（空投箱礼盒）百草味1500g/箱',0,0,'2019-11-27','baicaowei'),(1107,1,'21款果干（空投箱礼盒）百草味500g/箱',0,0,'2019-11-27','baicaowei'),(1108,1,'21款果干（锦鲤礼盒）百草味1000g/箱',0,0,'2019-11-27','baicaowei'),(1109,1,'21款果干（锦鲤礼盒）百草味1500g/箱',0,0,'2019-11-27','baicaowei'),(1110,1,'21款果干（锦鲤礼盒）百草味500g/箱',0,0,'2019-11-27','baicaowei'),(1111,1,'21款果干（陪伴你礼盒）百草味1000g/箱',0,0,'2019-11-27','baicaowei'),(1112,1,'21款果干（陪伴你礼盒）百草味1500g/箱',0,0,'2019-11-27','baicaowei'),(1113,1,'21款果干（陪伴你礼盒）百草味500g/箱',0,0,'2019-11-27','baicaowei'),(1114,2,'果干无聊急救包800g×1盒',0,0,'2019-11-27','baicaowei'),(1115,2,'每日抱抱果30天装758g×1盒',0,0,'2019-11-27','baicaowei'),(1116,2,'水果干礼盒420g×1盒',0,0,'2019-11-27','baicaowei'),(1117,2,'蔬菜干礼包548g×1盒',0,0,'2019-11-27','baicaowei'),(1118,2,'零食大礼包590g×1盒',0,0,'2019-11-27','baicaowei'),(1119,3,'夏威夷果100g',0,0,'2019-11-27','baicaowei'),(1120,3,'夏威夷果218g',0,0,'2019-11-27','baicaowei'),(1121,3,'夏威夷果56gg',0,0,'2019-11-27','baicaowei'),(1122,73,'24袋/箱',0,0,'2019-11-27','baicaowei'),(1123,73,'36袋/箱',0,0,'2019-11-27','baicaowei'),(1124,1,'21款果干(彩箱)百草味1000g/箱',0,0,'2019-11-28','baicaowei'),(1125,1,'21款果干(彩箱)百草味1500g/箱',0,0,'2019-11-28','baicaowei'),(1126,1,'21款果干(彩箱)百草味500g/箱',0,0,'2019-11-28','baicaowei'),(1127,1,'21款果干（Fou you礼盒）百草味1000g/箱',0,0,'2019-11-28','baicaowei'),(1128,1,'21款果干（Fou you礼盒）百草味1500g/箱',0,0,'2019-11-28','baicaowei'),(1129,1,'21款果干（Fou you礼盒）百草味500g/箱',0,0,'2019-11-28','baicaowei'),(1130,1,'21款果干（世界那么大）百草味1000g/箱',0,0,'2019-11-28','baicaowei'),(1131,1,'21款果干（世界那么大）百草味1500g/箱',0,0,'2019-11-28','baicaowei'),(1132,1,'21款果干（世界那么大）百草味500g/箱',0,0,'2019-11-28','baicaowei'),(1133,1,'21款果干（往后余生礼盒）百草味1000g/箱',0,0,'2019-11-28','baicaowei'),(1134,1,'21款果干（往后余生礼盒）百草味1500g/箱',0,0,'2019-11-28','baicaowei'),(1135,1,'21款果干（往后余生礼盒）百草味500g/箱',0,0,'2019-11-28','baicaowei'),(1136,1,'21款果干（我的女神礼盒）百草味1000g/箱',0,0,'2019-11-28','baicaowei'),(1137,1,'21款果干（我的女神礼盒）百草味1500g/箱',0,0,'2019-11-28','baicaowei'),(1138,1,'21款果干（我的女神礼盒）百草味500g/箱',0,0,'2019-11-28','baicaowei'),(1139,1,'21款果干（熬过异地礼盒）百草味1000g/箱',0,0,'2019-11-28','baicaowei'),(1140,1,'21款果干（熬过异地礼盒）百草味1500g/箱',0,0,'2019-11-28','baicaowei'),(1141,1,'21款果干（熬过异地礼盒）百草味500g/箱',0,0,'2019-11-28','baicaowei'),(1142,1,'21款果干（猪饲料礼盒）百草味1000g/箱',0,0,'2019-11-28','baicaowei'),(1143,1,'21款果干（猪饲料礼盒）百草味1500g/箱',0,0,'2019-11-28','baicaowei'),(1144,1,'21款果干（猪饲料礼盒）百草味500g/箱',0,0,'2019-11-28','baicaowei'),(1145,1,'21款果干（空投箱礼盒）百草味1000g/箱',0,0,'2019-11-28','baicaowei'),(1146,1,'21款果干（空投箱礼盒）百草味1500g/箱',0,0,'2019-11-28','baicaowei'),(1147,1,'21款果干（空投箱礼盒）百草味500g/箱',0,0,'2019-11-28','baicaowei'),(1148,1,'21款果干（锦鲤礼盒）百草味1000g/箱',0,0,'2019-11-28','baicaowei'),(1149,1,'21款果干（锦鲤礼盒）百草味1500g/箱',0,0,'2019-11-28','baicaowei'),(1150,1,'21款果干（锦鲤礼盒）百草味500g/箱',0,0,'2019-11-28','baicaowei'),(1151,1,'21款果干（陪伴你礼盒）百草味1000g/箱',0,0,'2019-11-28','baicaowei'),(1152,1,'21款果干（陪伴你礼盒）百草味1500g/箱',0,0,'2019-11-28','baicaowei'),(1153,1,'21款果干（陪伴你礼盒）百草味500g/箱',0,0,'2019-11-28','baicaowei'),(1154,2,'果干无聊急救包800g×1盒',0,0,'2019-11-28','baicaowei'),(1155,2,'每日抱抱果30天装758g×1盒',0,0,'2019-11-28','baicaowei'),(1156,2,'水果干礼盒420g×1盒',0,0,'2019-11-28','baicaowei'),(1157,2,'蔬菜干礼包548g×1盒',0,0,'2019-11-28','baicaowei'),(1158,2,'零食大礼包590g×1盒',0,0,'2019-11-28','baicaowei'),(1159,3,'夏威夷果100g',0,0,'2019-11-28','baicaowei'),(1160,3,'夏威夷果218g',0,0,'2019-11-28','baicaowei'),(1161,3,'夏威夷果56gg',0,0,'2019-11-28','baicaowei'),(1162,73,'24袋/箱',0,0,'2019-11-28','baicaowei'),(1163,73,'36袋/箱',0,0,'2019-11-28','baicaowei');

/*Table structure for table `merchant_return` */

DROP TABLE IF EXISTS `merchant_return`;

CREATE TABLE `merchant_return` (
  `return_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '退货id',
  `stock_id` int(11) DEFAULT NULL COMMENT '商家进货id',
  `return_cause` varchar(100) NOT NULL COMMENT '退货原因',
  `return_date` date NOT NULL COMMENT '退货时间',
  `return_number` int(11) DEFAULT NULL COMMENT '退货数量',
  `return_price` double(10,2) DEFAULT NULL COMMENT '退货单价',
  `return_prices` double(10,2) DEFAULT NULL COMMENT '退货总价',
  PRIMARY KEY (`return_id`),
  KEY `commo_return_fk` (`stock_id`),
  CONSTRAINT `commo_return_fk` FOREIGN KEY (`stock_id`) REFERENCES `commodity_stock` (`stock_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `merchant_return` */

insert  into `merchant_return`(`return_id`,`stock_id`,`return_cause`,`return_date`,`return_number`,`return_price`,`return_prices`) values (1,1,'不好吃','2019-11-10',100,1.00,100.00),(2,2,'瓶子破损','2019-11-10',9,3.00,27.00),(3,4,'不好吃,太贵了','2019-11-11',1,58.00,58.00),(4,3,'','2019-11-22',4,50.00,200.00),(5,7,'','2019-11-22',2,4.00,8.00);

/*Table structure for table `merchant_tarding` */

DROP TABLE IF EXISTS `merchant_tarding`;

CREATE TABLE `merchant_tarding` (
  `tarding_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商家交易ID',
  `merchant_id` int(11) DEFAULT NULL COMMENT '商家ID  FK',
  `tarding_date` date DEFAULT NULL COMMENT ' 商家交易时间',
  `tarding_prices` double(10,2) DEFAULT NULL COMMENT '商家交易金额',
  `tarding_state` int(1) DEFAULT NULL COMMENT '交易类型',
  `tarding_note` varchar(100) DEFAULT NULL COMMENT '备注  可为空',
  PRIMARY KEY (`tarding_id`),
  KEY `mer_tar_fk` (`merchant_id`),
  CONSTRAINT `mer_tar_fk` FOREIGN KEY (`merchant_id`) REFERENCES `merchant` (`merchant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

/*Data for the table `merchant_tarding` */

insert  into `merchant_tarding`(`tarding_id`,`merchant_id`,`tarding_date`,`tarding_prices`,`tarding_state`,`tarding_note`) values (1,1,'2019-10-08',20000.00,1,'进货'),(2,2,'2019-10-08',7200.00,1,'进货'),(3,1,'2019-11-10',20.00,1,'充值'),(4,1,'2019-11-10',50.00,1,'充值'),(6,1,'2019-11-10',-10.00,3,'提现'),(7,1,'2019-11-11',50.00,1,'充值'),(10,1,'2019-11-11',-10.00,3,'提现');

/*Table structure for table `order_list` */

DROP TABLE IF EXISTS `order_list`;

CREATE TABLE `order_list` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单id',
  `order_number` varchar(50) DEFAULT NULL COMMENT '订单号',
  `account_id` int(11) DEFAULT NULL COMMENT '用户id',
  `prices` double(10,2) DEFAULT NULL COMMENT '总价',
  `location_id` int(11) DEFAULT NULL COMMENT '收货地址id',
  `order_date` date DEFAULT NULL COMMENT '订单日期',
  PRIMARY KEY (`order_id`),
  KEY `order_acc_fk` (`account_id`),
  KEY `loca_order_fk` (`location_id`),
  CONSTRAINT `loca_order_fk` FOREIGN KEY (`location_id`) REFERENCES `location` (`location_id`),
  CONSTRAINT `order_acc_fk` FOREIGN KEY (`account_id`) REFERENCES `account` (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*Data for the table `order_list` */

insert  into `order_list`(`order_id`,`order_number`,`account_id`,`prices`,`location_id`,`order_date`) values (1,'201902191001',1,30.00,1,'2019-10-22'),(2,'200907241002',3,1000.00,3,'2009-07-24'),(3,'201010201003',1,100.00,1,'2019-11-15'),(4,'201011101004',1,1799.99,1,'2019-11-10'),(5,'201011101005',2,1799.99,2,'2019-11-21');

/*Table structure for table `order_list_particulars` */

DROP TABLE IF EXISTS `order_list_particulars`;

CREATE TABLE `order_list_particulars` (
  `particulars_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单详情ID',
  `order_id` int(11) DEFAULT NULL COMMENT '订单id',
  `commodity_id` int(11) DEFAULT NULL COMMENT '商品id',
  `subsort` varchar(20) DEFAULT NULL COMMENT '商品详细类别',
  `commodity_number` int(11) DEFAULT NULL COMMENT '商品数量',
  `commodity_price` double(10,2) DEFAULT NULL COMMENT '商品单价',
  `commodity_prices` double(10,2) DEFAULT NULL COMMENT '商品总价',
  `buy_date` date DEFAULT NULL COMMENT '购买日期',
  `state` int(1) DEFAULT '1' COMMENT '订单状态',
  `send_date` date DEFAULT NULL,
  `return_date` date DEFAULT NULL,
  PRIMARY KEY (`particulars_id`),
  KEY `comm_parti_fk` (`commodity_id`),
  KEY `order_parti_fk` (`order_id`),
  CONSTRAINT `comm_parti_fk` FOREIGN KEY (`commodity_id`) REFERENCES `commodity` (`commodity_id`),
  CONSTRAINT `order_parti_fk` FOREIGN KEY (`order_id`) REFERENCES `order_list` (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

/*Data for the table `order_list_particulars` */

insert  into `order_list_particulars`(`particulars_id`,`order_id`,`commodity_id`,`subsort`,`commodity_number`,`commodity_price`,`commodity_prices`,`buy_date`,`state`,`send_date`,`return_date`) values (1,1,1,'一箱',24,3.00,72.00,'2019-10-08',3,'2019-11-10',NULL),(2,2,2,'一箱',1,1.00,200.00,'2019-10-08',3,'2019-11-11',NULL),(3,3,5,'梦之白套餐一12+512GB5G',1,4399.00,4399.90,'2019-11-19',6,NULL,NULL),(4,4,6,'4G+全网通碳纤黑官方标配6+128G',1,1799.99,1799.99,'2019-11-10',4,NULL,NULL),(5,5,6,'4G+全网通碳纤黑官方标配6+128G',1,1799.99,1799.99,'2019-11-22',4,NULL,NULL),(6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL);

/*Table structure for table `shopping_cart` */

DROP TABLE IF EXISTS `shopping_cart`;

CREATE TABLE `shopping_cart` (
  `cart_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '购物车id',
  `account_id` int(11) DEFAULT NULL COMMENT '用户id',
  `commodity_id` int(11) DEFAULT NULL COMMENT '商品id',
  `subsort` varchar(100) DEFAULT NULL COMMENT '商品详细类别',
  `commodity_number` int(11) DEFAULT '1' COMMENT '商品数量',
  `commodity_price` double(10,2) DEFAULT NULL COMMENT '商品单价',
  `commodity_prices` double(10,2) DEFAULT NULL COMMENT '商品总价',
  PRIMARY KEY (`cart_id`),
  KEY `com_shopp_fk` (`commodity_id`),
  KEY `acc_shopp_fk` (`account_id`),
  CONSTRAINT `acc_shopp_fk` FOREIGN KEY (`account_id`) REFERENCES `account` (`account_id`),
  CONSTRAINT `com_shopp_fk` FOREIGN KEY (`commodity_id`) REFERENCES `commodity` (`commodity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

/*Data for the table `shopping_cart` */

insert  into `shopping_cart`(`cart_id`,`account_id`,`commodity_id`,`subsort`,`commodity_number`,`commodity_price`,`commodity_prices`) values (3,1,1,'21款果干（世界那么大）百草味1000g/箱',3,244.00,732.00),(6,1,5,'梦之白官方标配8+256GB5G',1,4199.00,4199.00),(8,1,6,'4G+全网通碳纤黑官方标配6+128G',4,1799.00,7196.00),(11,1,6,'4G+全网通冰川蓝官方标配6+128G',1,1799.99,1799.99),(13,1,61,'175/92/S黑-加绒款',7,499.00,3493.00),(14,1,1,'21款果干（空投箱礼盒）百草味500g/箱',1,268.00,268.00),(15,1,6,'4G+全网通碳纤黑官方标配8+256G',1,2299.99,2299.99);

/*Table structure for table `commodity_info_v` */

DROP TABLE IF EXISTS `commodity_info_v`;

/*!50001 DROP VIEW IF EXISTS `commodity_info_v` */;
/*!50001 DROP TABLE IF EXISTS `commodity_info_v` */;

/*!50001 CREATE TABLE  `commodity_info_v`(
 `commodity_id` int(11) ,
 `commodity_name` varchar(100) ,
 `commodity_describe` varchar(100) ,
 `price` double(10,2) ,
 `vip_price` double(10,2) ,
 `subtype_id` int(11) ,
 `sale_info` int(1) ,
 `check_info` int(1) ,
 `check_date` date ,
 `admin_id` int(11) ,
 `merchant_id` int(11) ,
 `merchant_name` varchar(50) ,
 `picture_id` int(11) ,
 `picture_type` int(11) ,
 `picture_url` varchar(50) ,
 `picsort_code` int(11) ,
 `picture_state` int(11) 
)*/;

/*Table structure for table `commodity_stock_v` */

DROP TABLE IF EXISTS `commodity_stock_v`;

/*!50001 DROP VIEW IF EXISTS `commodity_stock_v` */;
/*!50001 DROP TABLE IF EXISTS `commodity_stock_v` */;

/*!50001 CREATE TABLE  `commodity_stock_v`(
 `commodity_id` int(11) ,
 `commodity_name` varchar(100) ,
 `stock_id` int(11) ,
 `merchant_id` int(11) ,
 `subsort` varchar(100) ,
 `stock_number` int(11) ,
 `stock_price` double(10,2) ,
 `stock_prices` double(10,2) ,
 `procurement` varchar(30) ,
 `buystock_date` date ,
 `supplier` varchar(50) 
)*/;

/*Table structure for table `commodity_v` */

DROP TABLE IF EXISTS `commodity_v`;

/*!50001 DROP VIEW IF EXISTS `commodity_v` */;
/*!50001 DROP TABLE IF EXISTS `commodity_v` */;

/*!50001 CREATE TABLE  `commodity_v`(
 `commodity_id` int(11) ,
 `commodity_name` varchar(100) ,
 `commodity_describe` varchar(100) ,
 `price` double(10,2) ,
 `vip_price` double(10,2) ,
 `subtype_name` varchar(30) ,
 `subtype_describe` varchar(100) ,
 `subtype_state` int(11) ,
 `type_name` varchar(30) ,
 `type_describe` varchar(100) ,
 `type_state` int(11) ,
 `merchant_name` varchar(50) ,
 `record_state` int(1) 
)*/;

/*Table structure for table `eva_ord_v` */

DROP TABLE IF EXISTS `eva_ord_v`;

/*!50001 DROP VIEW IF EXISTS `eva_ord_v` */;
/*!50001 DROP TABLE IF EXISTS `eva_ord_v` */;

/*!50001 CREATE TABLE  `eva_ord_v`(
 `evaluate_id` int(11) ,
 `commodity_score` int(11) ,
 `logistic_score` int(11) ,
 `service_score` int(11) ,
 `evaluate` varchar(100) ,
 `evlauate_date` date ,
 `particulars_id` int(11) ,
 `subsort` varchar(20) ,
 `state` int(1) ,
 `commodity_id` int(11) ,
 `commodity_name` varchar(100) ,
 `merchant_id` int(11) ,
 `order_id` int(11) ,
 `order_number` varchar(50) ,
 `account_id` int(11) ,
 `account_name` varchar(20) 
)*/;

/*Table structure for table `merchant_return_v` */

DROP TABLE IF EXISTS `merchant_return_v`;

/*!50001 DROP VIEW IF EXISTS `merchant_return_v` */;
/*!50001 DROP TABLE IF EXISTS `merchant_return_v` */;

/*!50001 CREATE TABLE  `merchant_return_v`(
 `return_id` int(11) ,
 `stock_id` int(11) ,
 `return_cause` varchar(100) ,
 `return_date` date ,
 `return_number` int(11) ,
 `return_price` double(10,2) ,
 `return_prices` double(10,2) ,
 `commodity_name` varchar(100) ,
 `merchant_id` int(11) ,
 `subsort` varchar(100) ,
 `buystock_date` date 
)*/;

/*Table structure for table `order_list_v` */

DROP TABLE IF EXISTS `order_list_v`;

/*!50001 DROP VIEW IF EXISTS `order_list_v` */;
/*!50001 DROP TABLE IF EXISTS `order_list_v` */;

/*!50001 CREATE TABLE  `order_list_v`(
 `particulars_id` int(11) ,
 `order_id` int(11) ,
 `commodity_id` int(11) ,
 `subsort` varchar(20) ,
 `commodity_number` int(11) ,
 `commodity_price` double(10,2) ,
 `commodity_prices` double(10,2) ,
 `buy_date` date ,
 `state` int(1) ,
 `send_date` date ,
 `location` varchar(160) 
)*/;

/*Table structure for table `repertory_v` */

DROP TABLE IF EXISTS `repertory_v`;

/*!50001 DROP VIEW IF EXISTS `repertory_v` */;
/*!50001 DROP TABLE IF EXISTS `repertory_v` */;

/*!50001 CREATE TABLE  `repertory_v`(
 `repertory_id` int(11) ,
 `commodity_id` int(11) ,
 `merchant_id` int(11) ,
 `commodity_name` varchar(100) ,
 `subsort` varchar(100) ,
 `check_repertory` int(11) ,
 `count_repertory` int(11) ,
 `check_date` date ,
 `check_name` varchar(20) 
)*/;

/*Table structure for table `shopping_cart_v` */

DROP TABLE IF EXISTS `shopping_cart_v`;

/*!50001 DROP VIEW IF EXISTS `shopping_cart_v` */;
/*!50001 DROP TABLE IF EXISTS `shopping_cart_v` */;

/*!50001 CREATE TABLE  `shopping_cart_v`(
 `cart_id` int(11) ,
 `account_id` int(11) ,
 `commodity_id` int(11) ,
 `merchant_id` int(11) ,
 `subsort` varchar(100) ,
 `commodity_number` int(11) ,
 `commodity_price` double(10,2) ,
 `commodity_prices` double(10,2) ,
 `merchant_name` varchar(50) ,
 `commodity_name` varchar(100) ,
 `price` double(10,2) ,
 `vip_price` double(10,2) ,
 `picture_url` varchar(50) 
)*/;

/*View structure for view commodity_info_v */

/*!50001 DROP TABLE IF EXISTS `commodity_info_v` */;
/*!50001 DROP VIEW IF EXISTS `commodity_info_v` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `commodity_info_v` AS select `c`.`commodity_id` AS `commodity_id`,`c`.`commodity_name` AS `commodity_name`,`c`.`commodity_describe` AS `commodity_describe`,`c`.`price` AS `price`,`c`.`vip_price` AS `vip_price`,`c`.`subtype_id` AS `subtype_id`,`c`.`sale_info` AS `sale_info`,`c`.`check_info` AS `check_info`,`c`.`check_date` AS `check_date`,`c`.`admin_id` AS `admin_id`,`m`.`merchant_id` AS `merchant_id`,`m`.`merchant_name` AS `merchant_name`,`p`.`picture_id` AS `picture_id`,`p`.`picture_type` AS `picture_type`,`p`.`picture_url` AS `picture_url`,`p`.`picsort_code` AS `picsort_code`,`p`.`picture_state` AS `picture_state` from ((`commodity` `c` join `merchant` `m` on((`c`.`merchant_id` = `m`.`merchant_id`))) join `commodity_picture` `p` on((`p`.`commodity_id` = `c`.`commodity_id`))) */;

/*View structure for view commodity_stock_v */

/*!50001 DROP TABLE IF EXISTS `commodity_stock_v` */;
/*!50001 DROP VIEW IF EXISTS `commodity_stock_v` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `commodity_stock_v` AS select `c`.`commodity_id` AS `commodity_id`,`c`.`commodity_name` AS `commodity_name`,`s`.`stock_id` AS `stock_id`,`s`.`merchant_id` AS `merchant_id`,`s`.`subsort` AS `subsort`,`s`.`stock_number` AS `stock_number`,`s`.`stock_price` AS `stock_price`,`s`.`stock_prices` AS `stock_prices`,`s`.`procurement` AS `procurement`,`s`.`buystock_date` AS `buystock_date`,`s`.`supplier` AS `supplier` from (`commodity` `c` join `commodity_stock` `s` on((`c`.`commodity_id` = `s`.`commodity_id`))) */;

/*View structure for view commodity_v */

/*!50001 DROP TABLE IF EXISTS `commodity_v` */;
/*!50001 DROP VIEW IF EXISTS `commodity_v` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `commodity_v` AS select `a`.`commodity_id` AS `commodity_id`,`a`.`commodity_name` AS `commodity_name`,`a`.`commodity_describe` AS `commodity_describe`,`a`.`price` AS `price`,`a`.`vip_price` AS `vip_price`,`b`.`subtype_name` AS `subtype_name`,`b`.`subtype_describe` AS `subtype_describe`,`b`.`subtype_state` AS `subtype_state`,`d`.`type_name` AS `type_name`,`d`.`type_describe` AS `type_describe`,`d`.`type_state` AS `type_state`,`c`.`merchant_name` AS `merchant_name`,`c`.`record_state` AS `record_state` from (((`commodity` `a` join `commodity_subtype` `b` on((`a`.`subtype_id` = `b`.`subtype_id`))) join `merchant` `c` on((`c`.`merchant_id` = `a`.`merchant_id`))) join `commodity_type` `d` on((`d`.`type_id` = `b`.`type_id`))) where ((`a`.`check_info` = 1) and (`a`.`sale_info` = 1)) */;

/*View structure for view eva_ord_v */

/*!50001 DROP TABLE IF EXISTS `eva_ord_v` */;
/*!50001 DROP VIEW IF EXISTS `eva_ord_v` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `eva_ord_v` AS select `a`.`evaluate_id` AS `evaluate_id`,`a`.`commodity_score` AS `commodity_score`,`a`.`logistic_score` AS `logistic_score`,`a`.`service_score` AS `service_score`,`a`.`evaluate` AS `evaluate`,`a`.`evlauate_date` AS `evlauate_date`,`b`.`particulars_id` AS `particulars_id`,`b`.`subsort` AS `subsort`,`b`.`state` AS `state`,`c`.`commodity_id` AS `commodity_id`,`c`.`commodity_name` AS `commodity_name`,`c`.`merchant_id` AS `merchant_id`,`d`.`order_id` AS `order_id`,`d`.`order_number` AS `order_number`,`e`.`account_id` AS `account_id`,`e`.`account_name` AS `account_name` from ((((`evaluate` `a` join `order_list_particulars` `b` on((`a`.`particulars_id` = `b`.`particulars_id`))) join `commodity` `c` on((`b`.`commodity_id` = `c`.`commodity_id`))) join `order_list` `d` on((`b`.`order_id` = `d`.`order_id`))) join `account` `e` on((`e`.`account_id` = `d`.`account_id`))) */;

/*View structure for view merchant_return_v */

/*!50001 DROP TABLE IF EXISTS `merchant_return_v` */;
/*!50001 DROP VIEW IF EXISTS `merchant_return_v` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `merchant_return_v` AS select `s`.`return_id` AS `return_id`,`s`.`stock_id` AS `stock_id`,`s`.`return_cause` AS `return_cause`,`s`.`return_date` AS `return_date`,`s`.`return_number` AS `return_number`,`s`.`return_price` AS `return_price`,`s`.`return_prices` AS `return_prices`,`c`.`commodity_name` AS `commodity_name`,`cs`.`merchant_id` AS `merchant_id`,`cs`.`subsort` AS `subsort`,`cs`.`buystock_date` AS `buystock_date` from ((`merchant_return` `s` join `commodity_stock` `cs` on((`s`.`stock_id` = `cs`.`stock_id`))) join `commodity` `c` on((`cs`.`commodity_id` = `c`.`commodity_id`))) */;

/*View structure for view order_list_v */

/*!50001 DROP TABLE IF EXISTS `order_list_v` */;
/*!50001 DROP VIEW IF EXISTS `order_list_v` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `order_list_v` AS select `o`.`particulars_id` AS `particulars_id`,`o`.`order_id` AS `order_id`,`o`.`commodity_id` AS `commodity_id`,`o`.`subsort` AS `subsort`,`o`.`commodity_number` AS `commodity_number`,`o`.`commodity_price` AS `commodity_price`,`o`.`commodity_prices` AS `commodity_prices`,`o`.`buy_date` AS `buy_date`,`o`.`state` AS `state`,`o`.`send_date` AS `send_date`,concat(`n`.`provinces`,`n`.`city`,`n`.`county`,`n`.`specific_location`) AS `location` from ((`order_list_particulars` `o` join `order_list` `l` on((`o`.`order_id` = `l`.`order_id`))) join `location` `n` on((`n`.`location_id` = `l`.`location_id`))) */;

/*View structure for view repertory_v */

/*!50001 DROP TABLE IF EXISTS `repertory_v` */;
/*!50001 DROP VIEW IF EXISTS `repertory_v` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `repertory_v` AS select `c`.`repertory_id` AS `repertory_id`,`c`.`commodity_id` AS `commodity_id`,`m`.`merchant_id` AS `merchant_id`,`m`.`commodity_name` AS `commodity_name`,`c`.`subsort` AS `subsort`,`c`.`check_repertory` AS `check_repertory`,`c`.`count_repertory` AS `count_repertory`,`c`.`check_date` AS `check_date`,`c`.`check_name` AS `check_name` from (`commodity` `m` join `merchant_repertory` `c` on((`c`.`commodity_id` = `m`.`commodity_id`))) */;

/*View structure for view shopping_cart_v */

/*!50001 DROP TABLE IF EXISTS `shopping_cart_v` */;
/*!50001 DROP VIEW IF EXISTS `shopping_cart_v` */;

/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `shopping_cart_v` AS select `s`.`cart_id` AS `cart_id`,`s`.`account_id` AS `account_id`,`s`.`commodity_id` AS `commodity_id`,`m`.`merchant_id` AS `merchant_id`,`s`.`subsort` AS `subsort`,`s`.`commodity_number` AS `commodity_number`,`s`.`commodity_price` AS `commodity_price`,`s`.`commodity_prices` AS `commodity_prices`,`m`.`merchant_name` AS `merchant_name`,`c`.`commodity_name` AS `commodity_name`,`c`.`price` AS `price`,`c`.`vip_price` AS `vip_price`,`p`.`picture_url` AS `picture_url` from (((`commodity` `c` join `merchant` `m` on((`c`.`merchant_id` = `m`.`merchant_id`))) join `shopping_cart` `s` on((`s`.`commodity_id` = `c`.`commodity_id`))) join `commodity_picture` `p` on((`p`.`commodity_id` = `c`.`commodity_id`))) where ((`m`.`record_state` = 3) and (`c`.`sale_info` = 1) and (`c`.`check_info` = 3) and (`p`.`picture_type` = 3)) */;

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