# Host: localhost  (Version: 5.5.53)
# Date: 2019-03-29 15:31:19
# Generator: MySQL-Front 5.3  (Build 4.234)


#
# Structure for table "address_table"
#

CREATE TABLE `address_table` (
  `address_id` int(14) NOT NULL AUTO_INCREMENT,
  `user_id` int(14) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `address_area` varchar(100) DEFAULT NULL,
  `address_detail` varchar(100) DEFAULT NULL,
  `address_tag` varchar(100) DEFAULT NULL,
  `address_default` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`address_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "address_table"
#

INSERT INTO `address_table` VALUES (1,1,'王忠华','13888888888','北京市海淀区','八维研修学院','学校','1');

#
# Structure for table "assess_img_table"
#

CREATE TABLE `assess_img_table` (
  `assess_img_id` int(14) NOT NULL AUTO_INCREMENT,
  `assess_id` int(14) NOT NULL,
  `assess_path` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`assess_img_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "assess_img_table"
#


#
# Structure for table "assess_table"
#

CREATE TABLE `assess_table` (
  `assess_id` int(14) NOT NULL AUTO_INCREMENT,
  `user_id` int(14) NOT NULL,
  `goods_id` int(14) NOT NULL,
  `assess_values` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`assess_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "assess_table"
#


#
# Structure for table "banner_table"
#

CREATE TABLE `banner_table` (
  `banner_id` int(14) NOT NULL AUTO_INCREMENT,
  `goods_id` int(14) NOT NULL,
  PRIMARY KEY (`banner_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "banner_table"
#

INSERT INTO `banner_table` VALUES (1,1),(2,2),(3,3),(4,1),(5,2),(6,3),(7,1);

#
# Structure for table "brand_table"
#

CREATE TABLE `brand_table` (
  `brand_id` int(14) NOT NULL AUTO_INCREMENT,
  `menu_id` int(14) NOT NULL,
  `brand_letter` varchar(100) DEFAULT NULL,
  `brand_name` varchar(100) DEFAULT NULL,
  `hot_tag` varchar(100) DEFAULT NULL,
  `brand_time` varchar(100) DEFAULT NULL,
  `brand_icon` varchar(100) DEFAULT NULL,
  `brand_bg` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`brand_id`)
) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=utf8;

#
# Data for table "brand_table"
#

INSERT INTO `brand_table` VALUES (1,1,'A','AAAA','true','1552221466','/brand_img/brand1.png','/brand_img/brand_big_1.jpg'),(2,1,'B','BBBB','false','1552221466','/brand_img/brand2.png','/brand_img/brand_big_2.jpg'),(3,1,'C','CCCC','true','1552221466','/brand_img/brand3.png','/brand_img/brand_big_3.jpg'),(4,1,'D','DDDD','true','1552221466','/brand_img/brand4.png','/brand_img/brand_big_4.jpg'),(5,1,'E','EEEE','false','1552221466','/brand_img/brand5.png','/brand_img/brand_big_5.jpg'),(6,1,'F','FFFF','true','1552221466','/brand_img/brand6.png','/brand_img/brand_big_6.jpg'),(7,1,'G','GGGG','true','1552221466','/brand_img/brand7.png','/brand_img/brand_big_7.jpg'),(8,1,'H','HHHH','false','1552221466','/brand_img/brand8.png','/brand_img/brand_big_8.jpg'),(9,1,'I','IIII','true','1552221466','/brand_img/brand9.png','/brand_img/brand_big_9.jpg'),(10,1,'J','JJJJ','false','1552221466','/brand_img/brand10.png','/brand_img/brand_big_10.jpg'),(11,1,'K','KKKK','false','1552221466','/brand_img/brand11.png','/brand_img/brand_big_1.jpg'),(12,1,'L','LLLL','false','1552221466','/brand_img/brand12.png','/brand_img/brand_big_2.jpg'),(13,1,'M','MMMM','false','1552221466','/brand_img/brand13.png','/brand_img/brand_big_3.jpg'),(14,1,'N','NNNN','false','1552221466','/brand_img/brand14.png','/brand_img/brand_big_4.jpg'),(15,1,'O','OOOO','false','1552221466','/brand_img/brand15.png','/brand_img/brand_big_5.jpg'),(16,1,'P','PPPP','false','1552221466','/brand_img/brand16.png','/brand_img/brand_big_6.jpg'),(17,1,'Q','QQQQ','false','1552221466','/brand_img/brand17.png','/brand_img/brand_big_7.jpg'),(18,1,'R','RRRR','false','1552221466','/brand_img/brand18.png','/brand_img/brand_big_8.jpg'),(19,1,'S','SSSS','true','1552221466','/brand_img/brand19.png','/brand_img/brand_big_9.jpg'),(20,1,'T','TTTT','false','1552221466','/brand_img/brand20.png','/brand_img/brand_big_10.jpg'),(21,2,'A','AAAA','true','1552221466','/brand_img/brand1.png','/brand_img/brand_big_1.jpg'),(22,2,'B','BBBB','false','1552221466','/brand_img/brand2.png','/brand_img/brand_big_2.jpg'),(23,2,'C','CCCC','true','1552221466','/brand_img/brand3.png','/brand_img/brand_big_3.jpg'),(24,2,'D','DDDD','true','1552221466','/brand_img/brand4.png','/brand_img/brand_big_4.jpg'),(25,2,'E','EEEE','false','1552221466','/brand_img/brand5.png','/brand_img/brand_big_5.jpg'),(26,2,'F','FFFF','true','1552221466','/brand_img/brand6.png','/brand_img/brand_big_6.jpg'),(27,2,'G','GGGG','true','1552221466','/brand_img/brand7.png','/brand_img/brand_big_7.jpg'),(28,2,'H','HHHH','false','1552221466','/brand_img/brand8.png','/brand_img/brand_big_8.jpg'),(29,2,'I','IIII','true','1552221466','/brand_img/brand9.png','/brand_img/brand_big_9.jpg'),(30,2,'J','JJJJ','false','1552221466','/brand_img/brand10.png','/brand_img/brand_big_10.jpg'),(31,2,'K','KKKK','false','1552221466','/brand_img/brand11.png','/brand_img/brand_big_1.jpg'),(32,2,'L','LLLL','false','1552221466','/brand_img/brand12.png','/brand_img/brand_big_2.jpg'),(33,2,'M','MMMM','false','1552221466','/brand_img/brand13.png','/brand_img/brand_big_3.jpg'),(34,2,'N','NNNN','false','1552221466','/brand_img/brand14.png','/brand_img/brand_big_4.jpg'),(35,2,'O','OOOO','false','1552221466','/brand_img/brand15.png','/brand_img/brand_big_5.jpg'),(36,2,'P','PPPP','false','1552221466','/brand_img/brand16.png','/brand_img/brand_big_6.jpg'),(37,2,'Q','QQQQ','false','1552221466','/brand_img/brand17.png','/brand_img/brand_big_7.jpg'),(38,2,'R','RRRR','false','1552221466','/brand_img/brand18.png','/brand_img/brand_big_8.jpg'),(39,2,'S','SSSS','true','1552221466','/brand_img/brand19.png','/brand_img/brand_big_9.jpg'),(40,2,'T','TTTT','false','1552221466','/brand_img/brand20.png','/brand_img/brand_big_10.jpg'),(41,3,'A','AAAA','true','1552221466','/brand_img/brand1.png','/brand_img/brand_big_1.jpg'),(42,3,'B','BBBB','false','1552221466','/brand_img/brand2.png','/brand_img/brand_big_2.jpg'),(43,3,'C','CCCC','true','1552221466','/brand_img/brand3.png','/brand_img/brand_big_3.jpg'),(44,3,'D','DDDD','true','1552221466','/brand_img/brand4.png','/brand_img/brand_big_4.jpg'),(45,3,'E','EEEE','false','1552221466','/brand_img/brand5.png','/brand_img/brand_big_5.jpg'),(46,3,'F','FFFF','true','1552221466','/brand_img/brand6.png','/brand_img/brand_big_6.jpg'),(47,3,'G','GGGG','true','1552221466','/brand_img/brand7.png','/brand_img/brand_big_7.jpg'),(48,3,'H','HHHH','false','1552221466','/brand_img/brand8.png','/brand_img/brand_big_8.jpg'),(49,3,'I','IIII','true','1552221466','/brand_img/brand9.png','/brand_img/brand_big_9.jpg'),(50,3,'J','JJJJ','false','1552221466','/brand_img/brand10.png','/brand_img/brand_big_10.jpg'),(51,3,'K','KKKK','false','1552221466','/brand_img/brand11.png','/brand_img/brand_big_1.jpg'),(52,3,'L','LLLL','false','1552221466','/brand_img/brand12.png','/brand_img/brand_big_2.jpg'),(53,3,'M','MMMM','false','1552221466','/brand_img/brand13.png','/brand_img/brand_big_3.jpg'),(54,3,'N','NNNN','false','1552221466','/brand_img/brand14.png','/brand_img/brand_big_4.jpg'),(55,3,'O','OOOO','false','1552221466','/brand_img/brand15.png','/brand_img/brand_big_5.jpg'),(56,3,'P','PPPP','false','1552221466','/brand_img/brand16.png','/brand_img/brand_big_6.jpg'),(57,3,'Q','QQQQ','false','1552221466','/brand_img/brand17.png','/brand_img/brand_big_7.jpg'),(58,3,'R','RRRR','false','1552221466','/brand_img/brand18.png','/brand_img/brand_big_8.jpg'),(59,3,'S','SSSS','true','1552221466','/brand_img/brand19.png','/brand_img/brand_big_9.jpg'),(60,3,'T','TTTT','false','1552221466','/brand_img/brand20.png','/brand_img/brand_big_10.jpg'),(61,4,'A','AAAA','true','1552221466','/brand_img/brand1.png','/brand_img/brand_big_1.jpg'),(62,4,'B','BBBB','false','1552221466','/brand_img/brand2.png','/brand_img/brand_big_2.jpg'),(63,4,'C','CCCC','true','1552221466','/brand_img/brand3.png','/brand_img/brand_big_3.jpg'),(64,4,'D','DDDD','true','1552221466','/brand_img/brand4.png','/brand_img/brand_big_4.jpg'),(65,4,'E','EEEE','false','1552221466','/brand_img/brand5.png','/brand_img/brand_big_5.jpg'),(66,4,'F','FFFF','true','1552221466','/brand_img/brand6.png','/brand_img/brand_big_6.jpg'),(67,4,'G','GGGG','true','1552221466','/brand_img/brand7.png','/brand_img/brand_big_7.jpg'),(68,4,'H','HHHH','false','1552221466','/brand_img/brand8.png','/brand_img/brand_big_8.jpg'),(69,4,'I','IIII','true','1552221466','/brand_img/brand9.png','/brand_img/brand_big_9.jpg'),(70,4,'J','JJJJ','false','1552221466','/brand_img/brand10.png','/brand_img/brand_big_10.jpg'),(71,4,'K','KKKK','false','1552221466','/brand_img/brand11.png','/brand_img/brand_big_1.jpg'),(72,4,'L','LLLL','false','1552221466','/brand_img/brand12.png','/brand_img/brand_big_2.jpg'),(73,4,'M','MMMM','false','1552221466','/brand_img/brand13.png','/brand_img/brand_big_3.jpg'),(74,4,'N','NNNN','false','1552221466','/brand_img/brand14.png','/brand_img/brand_big_4.jpg'),(75,4,'O','OOOO','false','1552221466','/brand_img/brand15.png','/brand_img/brand_big_5.jpg'),(76,4,'P','PPPP','false','1552221466','/brand_img/brand16.png','/brand_img/brand_big_6.jpg'),(77,4,'Q','QQQQ','false','1552221466','/brand_img/brand17.png','/brand_img/brand_big_7.jpg'),(78,4,'R','RRRR','false','1552221466','/brand_img/brand18.png','/brand_img/brand_big_8.jpg'),(79,4,'S','SSSS','true','1552221466','/brand_img/brand19.png','/brand_img/brand_big_9.jpg'),(80,4,'T','TTTT','false','1552221466','/brand_img/brand20.png','/brand_img/brand_big_10.jpg');

#
# Structure for table "browse_table"
#

CREATE TABLE `browse_table` (
  `browse_id` int(14) NOT NULL AUTO_INCREMENT,
  `user_id` int(14) NOT NULL,
  `goods_id` int(14) NOT NULL,
  PRIMARY KEY (`browse_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "browse_table"
#

INSERT INTO `browse_table` VALUES (1,1,1);

#
# Structure for table "car_table"
#

CREATE TABLE `car_table` (
  `car_id` int(14) NOT NULL AUTO_INCREMENT,
  `user_id` int(14) NOT NULL,
  `goods_id` int(14) NOT NULL,
  `car_path` varchar(100) DEFAULT NULL,
  `shop_name` varchar(100) DEFAULT NULL,
  `shop_color` varchar(100) DEFAULT NULL,
  `shop_size` varchar(100) DEFAULT NULL,
  `shop_num` varchar(100) DEFAULT NULL,
  `shop_price` varchar(100) DEFAULT NULL,
  `shop_select` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`car_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "car_table"
#


#
# Structure for table "category_table"
#

CREATE TABLE `category_table` (
  `category_id` int(14) NOT NULL AUTO_INCREMENT,
  `menu_id` int(14) NOT NULL,
  `category_name` varchar(100) DEFAULT NULL,
  `category_img_path` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

#
# Data for table "category_table"
#

INSERT INTO `category_table` VALUES (1,1,'上衣','/brand_img/brand_big_1.jpg'),(2,1,'裤子','/brand_img/brand_big_2.jpg'),(3,1,'鞋子','/brand_img/brand_big_3.jpg'),(4,1,'包类','/brand_img/brand_big_4.jpg'),(5,1,'服配','/brand_img/brand_big_5.jpg'),(6,1,'创意生活','/brand_img/brand_big_6.jpg'),(7,1,'个人护理','/brand_img/brand_big_7.jpg'),(8,1,'toys','/brand_img/brand_big_8.jpg'),(9,1,'有食','/brand_img/brand_big_9.jpg'),(10,2,'上衣','/brand_img/brand_big_1.jpg'),(11,2,'裤子','/brand_img/brand_big_2.jpg'),(12,2,'鞋子','/brand_img/brand_big_3.jpg'),(13,2,'包类','/brand_img/brand_big_4.jpg'),(14,2,'服配','/brand_img/brand_big_5.jpg'),(15,2,'创意生活','/brand_img/brand_big_6.jpg'),(16,2,'个人护理','/brand_img/brand_big_7.jpg'),(17,2,'toys','/brand_img/brand_big_8.jpg'),(18,2,'有食','/brand_img/brand_big_9.jpg'),(19,3,'上衣','/brand_img/brand_big_1.jpg'),(20,3,'裤子','/brand_img/brand_big_2.jpg'),(21,3,'鞋子','/brand_img/brand_big_3.jpg'),(22,3,'包类','/brand_img/brand_big_4.jpg'),(23,3,'服配','/brand_img/brand_big_5.jpg'),(24,3,'创意生活','/brand_img/brand_big_6.jpg'),(25,3,'个人护理','/brand_img/brand_big_7.jpg'),(26,3,'toys','/brand_img/brand_big_8.jpg'),(27,3,'有食','/brand_img/brand_big_9.jpg'),(28,4,'上衣','/brand_img/brand_big_1.jpg'),(29,4,'裤子','/brand_img/brand_big_2.jpg'),(30,4,'鞋子','/brand_img/brand_big_3.jpg'),(31,4,'包类','/brand_img/brand_big_4.jpg'),(32,4,'服配','/brand_img/brand_big_5.jpg'),(33,4,'创意生活','/brand_img/brand_big_6.jpg'),(34,4,'个人护理','/brand_img/brand_big_7.jpg'),(35,4,'toys','/brand_img/brand_big_8.jpg'),(36,4,'有食','/brand_img/brand_big_9.jpg');

#
# Structure for table "collection_goods_table"
#

CREATE TABLE `collection_goods_table` (
  `collection_goods_id` int(14) NOT NULL AUTO_INCREMENT,
  `user_id` int(14) NOT NULL,
  `goods_id` int(14) NOT NULL,
  PRIMARY KEY (`collection_goods_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "collection_goods_table"
#


#
# Structure for table "collection_table"
#

CREATE TABLE `collection_table` (
  `collection_id` int(14) NOT NULL AUTO_INCREMENT,
  `user_id` int(14) NOT NULL,
  `brand_id` int(14) NOT NULL,
  PRIMARY KEY (`collection_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "collection_table"
#


#
# Structure for table "colors_table"
#

CREATE TABLE `colors_table` (
  `color_id` int(14) NOT NULL AUTO_INCREMENT,
  `colors_values` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`color_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "colors_table"
#

INSERT INTO `colors_table` VALUES (1,'红色'),(2,'绿色'),(3,'白色'),(4,'黑色');

#
# Structure for table "comment_table"
#

CREATE TABLE `comment_table` (
  `comment_id` int(14) NOT NULL AUTO_INCREMENT,
  `theme_id` int(14) NOT NULL,
  `user_id` int(14) NOT NULL,
  `comment_time` varchar(100) DEFAULT NULL,
  `comment_values` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`comment_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "comment_table"
#


#
# Structure for table "community_img_table"
#

CREATE TABLE `community_img_table` (
  `community_img_id` int(14) NOT NULL AUTO_INCREMENT,
  `community_id` int(14) NOT NULL,
  `img_path` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`community_img_id`)
) ENGINE=MyISAM AUTO_INCREMENT=56 DEFAULT CHARSET=utf8;

#
# Data for table "community_img_table"
#

INSERT INTO `community_img_table` VALUES (1,1,'/goods_img/goods_img_1'),(2,1,'/goods_img/goods_img_2'),(3,1,'/goods_img/goods_img_3'),(4,1,'/goods_img/goods_img_4'),(5,1,'/goods_img/goods_img_5'),(6,1,'/goods_img/goods_img_6'),(7,1,'/goods_img/goods_img_7'),(8,1,'/goods_img/goods_img_8'),(9,1,'/goods_img/goods_img_9'),(10,2,'/goods_img/goods_img_1'),(11,2,'/goods_img/goods_img_2'),(12,2,'/goods_img/goods_img_3'),(13,2,'/goods_img/goods_img_4'),(14,2,'/goods_img/goods_img_5'),(15,3,'/goods_img/goods_img_1'),(16,4,'/goods_img/goods_img_1'),(17,4,'/goods_img/goods_img_2'),(18,5,'/goods_img/goods_img_1'),(19,5,'/goods_img/goods_img_2'),(20,5,'/goods_img/goods_img_3'),(21,5,'/goods_img/goods_img_4'),(22,5,'/goods_img/goods_img_5'),(23,5,'/goods_img/goods_img_6'),(24,6,'/goods_img/goods_img_1'),(25,6,'/goods_img/goods_img_2'),(26,7,'/goods_img/goods_img_1'),(27,8,'/goods_img/goods_img_1'),(28,8,'/goods_img/goods_img_2'),(29,8,'/goods_img/goods_img_3'),(30,9,'/goods_img/goods_img_1'),(31,9,'/goods_img/goods_img_2'),(32,9,'/goods_img/goods_img_3'),(33,9,'/goods_img/goods_img_4'),(34,10,'/goods_img/goods_img_1'),(35,10,'/goods_img/goods_img_2'),(36,11,'/goods_img/goods_img_1'),(37,12,'/goods_img/goods_img_2'),(38,13,'/goods_img/goods_img_3'),(39,14,'/goods_img/goods_img_4'),(40,15,'/goods_img/goods_img_5'),(41,16,'/goods_img/goods_img_6'),(42,17,'/goods_img/goods_img_7'),(43,18,'/goods_img/goods_img_8'),(44,19,'/goods_img/goods_img_9'),(45,20,'/goods_img/goods_img_1'),(46,21,'/goods_img/goods_img_2'),(47,22,'/goods_img/goods_img_3'),(48,23,'/goods_img/goods_img_4'),(49,24,'/goods_img/goods_img_5'),(50,25,'/goods_img/goods_img_6'),(51,26,'/goods_img/goods_img_7'),(52,27,'/goods_img/goods_img_8'),(53,28,'/goods_img/goods_img_9'),(54,29,'/goods_img/goods_img_1'),(55,30,'/goods_img/goods_img_2');

#
# Structure for table "community_table"
#

CREATE TABLE `community_table` (
  `community_id` int(14) NOT NULL AUTO_INCREMENT,
  `user_id` int(14) NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `community_values` varchar(100) DEFAULT NULL,
  `community_time` varchar(100) DEFAULT NULL,
  `tag` varchar(100) DEFAULT NULL,
  `hot_flag` varchar(100) DEFAULT NULL,
  `fabulous` varchar(100) DEFAULT NULL,
  `collection` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`community_id`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

#
# Data for table "community_table"
#

INSERT INTO `community_table` VALUES (1,1,'王忠华上头条','头条王忠华','1553436563','华仔','1','100','20'),(2,1,'王忠华上头条1','头条王忠华','1553436563','华仔','1','101','20'),(3,1,'王忠华上头条2','头条王忠华','1553436563','华仔','0','102','20'),(4,1,'王忠华上头条3','头条王忠华','1553436563','华仔','0','103','20'),(5,1,'王忠华上头条4','头条王忠华','1553436563','华仔','0','10','20'),(6,1,'王忠华上头条5','头条王忠华','1553436563','华仔','1','1040','20'),(7,1,'王忠华上头条6','头条王忠华','1553436563','华仔','1','105','20'),(8,1,'王忠华上头条7','头条王忠华','1553436563','华仔','0','106','20'),(9,1,'王忠华上头条8','头条王忠华','1553436563','华仔','1','107','20'),(10,1,'王忠华上头条9','头条王忠华','1553436563','华仔','1','105','20'),(11,1,'王忠华上头条10','头条王忠华','1553436563','华仔','0','160','20'),(12,1,'王忠华上头条11','头条王忠华','1553436563','华仔','1','100','20'),(13,1,'王忠华上头条12','头条王忠华','1553436563','华仔','1','100','20'),(14,1,'王忠华上头条13','头条王忠华','1553436563','华仔','1','100','20'),(15,1,'王忠华上头条14','头条王忠华','1553436563','华仔','1','100','20'),(16,1,'王忠华上头条15','头条王忠华','1553436563','华仔','0','100','20'),(17,1,'王忠华上头条16','头条王忠华','1553436563','华仔','1','100','20'),(18,1,'王忠华上头条17','头条王忠华','1553436563','华仔','1','100','20'),(19,1,'王忠华上头条18','头条王忠华','1553436563','华仔','1','100','20'),(20,1,'王忠华上头条19','头条王忠华','1553436563','华仔','0','100','20'),(21,1,'王忠华上头条20','头条王忠华','1553436563','华仔','1','100','20'),(22,1,'王忠华上头条21','头条王忠华','1553436563','华仔','1','100','20'),(23,1,'王忠华上头222','头条王忠华','1553436563','华仔','1','100','20'),(24,1,'王忠华上头条23','头条王忠华','1553436563','华仔','1','100','20'),(25,1,'王忠华上头条24','头条王忠华','1553436563','华仔','0','100','20'),(26,1,'王忠华上头条25','头条王忠华','1553436563','华仔','1','100','20'),(27,1,'王忠华上头条26','头条王忠华','1553436563','华仔','1','100','20'),(28,1,'王忠华上头条27','头条王忠华','1553436563','华仔','1','100','20'),(29,1,'王忠华上头条28','头条王忠华','1553436563','华仔','1','100','20'),(30,1,'王忠华上头条29','头条王忠华','1553436563','华仔','1','100','20'),(31,1,'王忠华上头条30','头条王忠华','1553436563','华仔','1','100','20');

#
# Structure for table "coupon_table"
#

CREATE TABLE `coupon_table` (
  `coupon_id` int(14) NOT NULL AUTO_INCREMENT,
  `coupon_title` varchar(100) DEFAULT NULL,
  `coupon_condition` varchar(100) DEFAULT NULL,
  `coupon_data` varchar(100) DEFAULT NULL,
  `coupon_explain` varchar(100) DEFAULT NULL,
  `coupon_ufo` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`coupon_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "coupon_table"
#

INSERT INTO `coupon_table` VALUES (1,'换新季新品减50元','50','1552221466','特例商品不支持优惠券',0),(2,'单品减10元','10','1552221466','特例商品不支持优惠券',0),(3,'爆款新品减55元','55','1552221466','特例商品不支持优惠券',0),(4,'王忠话打折减20元','20','1552221466','特例商品不支持优惠券',0),(5,'冀佳丽折扣减30元','30','1552221466','特例商品不支持优惠券',0),(6,'老和尚打折减90元','90','1552221466','特例商品不支持优惠券',0),(7,'翻新减50元','50','1552221466','特例商品不支持优惠券',0),(8,'水货减50元','50','1552221466','特例商品不支持优惠券',0),(9,'山寨减50元','50','1552221466','特例商品不支持优惠券',0),(10,'假货减50元','50','1552221466','特例商品不支持优惠券',0),(11,'山寨战斗机减50元','50','1552221466','特例商品不支持优惠券',0),(12,'山寨货减50元','50','1552221466','特例商品不支持优惠券',0),(13,'假的减50元','50','1552221466','特例商品不支持优惠券',0),(14,'真的减50元','50','1552221466','特例商品不支持优惠券',0),(15,'纯真减50元','50','1552221466','特例商品不支持优惠券',0),(16,'真假不分减50元','50','1552221466','特例商品不支持优惠券',0),(17,'真真假假减50元','50','1552221466','特例商品不支持优惠券',0),(18,'二手减50元','50','1552221466','特例商品不支持优惠券',0),(19,'n手减50元','50','1552221466','特例商品不支持优惠券',0),(20,'9手小奥拓减50元','50','1552221466','特例商品不支持优惠券',0);

#
# Structure for table "goods_img_table"
#

CREATE TABLE `goods_img_table` (
  `goods_img_id` int(14) NOT NULL AUTO_INCREMENT,
  `goods_id` int(11) NOT NULL DEFAULT '1',
  `goods_img_path` varchar(100) DEFAULT NULL,
  `detail_flag` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`goods_img_id`)
) ENGINE=MyISAM AUTO_INCREMENT=151 DEFAULT CHARSET=utf8;

#
# Data for table "goods_img_table"
#

INSERT INTO `goods_img_table` VALUES (1,1,'/goods_img/goods_img1.jpg',1),(2,1,'/goods_img/goods_img2.jpg',0),(3,1,'/goods_img/goods_img3jpg',0),(4,1,'/goods_img/goods_img4.jpg',0),(5,1,'/goods_img/goods_img5.jpg',0),(6,2,'/goods_img/goods_img6.jpg',1),(7,2,'/goods_img/goods_img7.jpg',0),(8,2,'/goods_img/goods_img8jpg',0),(9,2,'/goods_img/goods_img9.jpg',0),(10,3,'/goods_img/goods_img10.jpg',1),(11,3,'/goods_img/goods_img11.jpg',0),(12,3,'/goods_img/goods_img12.jpg',0),(13,3,'/goods_img/goods_img13jpg',0),(14,3,'/goods_img/goods_img14.jpg',0),(15,3,'/goods_img/goods_img15.jpg',0),(16,1,'/goods_img/goods1.jpg',0),(17,1,'/goods_img/goods2.jpg',0),(18,1,'/goods_img/goods3jpg',0),(19,1,'/goods_img/goods4.jpg',0),(20,1,'/goods_img/goods5.jpg',0),(21,2,'/goods_img/goods6.jpg',0),(22,2,'/goods_img/goods7.jpg',0),(23,2,'/goods_img/goods8jpg',0),(24,2,'/goods_img/goods9.jpg',0),(25,3,'/goods_img/goods10.jpg',0),(26,3,'/goods_img/goods11.jpg',0),(27,3,'/goods_img/goods12.jpg',0),(28,3,'/goods_img/goods13jpg',0),(29,3,'/goods_img/goods14.jpg',0),(30,3,'/goods_img/goods15.jpg',0),(31,4,'/goods_img/goods_img1.jpg',1),(32,4,'/goods_img/goods_img2.jpg',0),(33,4,'/goods_img/goods_img3jpg',0),(34,4,'/goods_img/goods_img4.jpg',0),(35,4,'/goods_img/goods_img5.jpg',0),(36,5,'/goods_img/goods_img6.jpg',1),(37,5,'/goods_img/goods_img7.jpg',0),(38,5,'/goods_img/goods_img8jpg',0),(39,5,'/goods_img/goods_img9.jpg',0),(40,6,'/goods_img/goods_img10.jpg',1),(41,6,'/goods_img/goods_img11.jpg',0),(42,6,'/goods_img/goods_img12.jpg',0),(43,6,'/goods_img/goods_img13jpg',0),(44,6,'/goods_img/goods_img14.jpg',0),(45,6,'/goods_img/goods_img15.jpg',0),(46,4,'/goods_img/goods1.jpg',0),(47,4,'/goods_img/goods2.jpg',0),(48,4,'/goods_img/goods3jpg',0),(49,4,'/goods_img/goods4.jpg',0),(50,4,'/goods_img/goods5.jpg',0),(51,5,'/goods_img/goods6.jpg',0),(52,5,'/goods_img/goods7.jpg',0),(53,5,'/goods_img/goods8jpg',0),(54,5,'/goods_img/goods9.jpg',0),(55,6,'/goods_img/goods10.jpg',0),(56,6,'/goods_img/goods11.jpg',0),(57,6,'/goods_img/goods12.jpg',0),(58,6,'/goods_img/goods13jpg',0),(59,6,'/goods_img/goods14.jpg',0),(60,6,'/goods_img/goods15.jpg',0),(61,7,'/goods_img/goods_img1.jpg',1),(62,7,'/goods_img/goods_img2.jpg',0),(63,7,'/goods_img/goods_img3jpg',0),(64,7,'/goods_img/goods_img4.jpg',0),(65,7,'/goods_img/goods_img5.jpg',0),(66,8,'/goods_img/goods_img6.jpg',1),(67,8,'/goods_img/goods_img7.jpg',0),(68,8,'/goods_img/goods_img8jpg',0),(69,8,'/goods_img/goods_img9.jpg',0),(70,9,'/goods_img/goods_img10.jpg',1),(71,9,'/goods_img/goods_img11.jpg',0),(72,9,'/goods_img/goods_img12.jpg',0),(73,9,'/goods_img/goods_img13jpg',0),(74,9,'/goods_img/goods_img14.jpg',0),(75,9,'/goods_img/goods_img15.jpg',0),(76,7,'/goods_img/goods1.jpg',0),(77,7,'/goods_img/goods2.jpg',0),(78,7,'/goods_img/goods3jpg',0),(79,7,'/goods_img/goods4.jpg',0),(80,7,'/goods_img/goods5.jpg',0),(81,8,'/goods_img/goods6.jpg',0),(82,8,'/goods_img/goods7.jpg',0),(83,8,'/goods_img/goods8jpg',0),(84,8,'/goods_img/goods9.jpg',0),(85,9,'/goods_img/goods10.jpg',0),(86,9,'/goods_img/goods11.jpg',0),(87,9,'/goods_img/goods12.jpg',0),(88,9,'/goods_img/goods13jpg',0),(89,9,'/goods_img/goods14.jpg',0),(90,9,'/goods_img/goods15.jpg',0),(91,10,'/goods_img/goods_img1.jpg',1),(92,10,'/goods_img/goods_img2.jpg',0),(93,10,'/goods_img/goods_img3jpg',0),(94,10,'/goods_img/goods_img4.jpg',0),(95,10,'/goods_img/goods_img5.jpg',0),(96,11,'/goods_img/goods_img6.jpg',1),(97,11,'/goods_img/goods_img7.jpg',0),(98,11,'/goods_img/goods_img8jpg',0),(99,11,'/goods_img/goods_img9.jpg',0),(100,12,'/goods_img/goods_img10.jpg',1),(101,12,'/goods_img/goods_img11.jpg',0),(102,12,'/goods_img/goods_img12.jpg',0),(103,12,'/goods_img/goods_img13jpg',0),(104,12,'/goods_img/goods_img14.jpg',0),(105,12,'/goods_img/goods_img15.jpg',0),(106,10,'/goods_img/goods1.jpg',0),(107,10,'/goods_img/goods2.jpg',0),(108,10,'/goods_img/goods3jpg',0),(109,10,'/goods_img/goods4.jpg',0),(110,10,'/goods_img/goods5.jpg',0),(111,11,'/goods_img/goods6.jpg',0),(112,11,'/goods_img/goods7.jpg',0),(113,11,'/goods_img/goods8jpg',0),(114,11,'/goods_img/goods9.jpg',0),(115,12,'/goods_img/goods10.jpg',0),(116,12,'/goods_img/goods11.jpg',0),(117,12,'/goods_img/goods12.jpg',0),(118,12,'/goods_img/goods13jpg',0),(119,12,'/goods_img/goods14.jpg',0),(120,12,'/goods_img/goods15.jpg',0),(121,13,'/goods_img/goods_img1.jpg',1),(122,13,'/goods_img/goods_img2.jpg',0),(123,13,'/goods_img/goods_img3jpg',0),(124,13,'/goods_img/goods_img4.jpg',0),(125,13,'/goods_img/goods_img5.jpg',0),(126,14,'/goods_img/goods_img6.jpg',1),(127,14,'/goods_img/goods_img7.jpg',0),(128,14,'/goods_img/goods_img8jpg',0),(129,14,'/goods_img/goods_img9.jpg',0),(130,15,'/goods_img/goods_img10.jpg',1),(131,15,'/goods_img/goods_img11.jpg',0),(132,15,'/goods_img/goods_img12.jpg',0),(133,15,'/goods_img/goods_img13jpg',0),(134,15,'/goods_img/goods_img14.jpg',0),(135,15,'/goods_img/goods_img15.jpg',0),(136,13,'/goods_img/goods1.jpg',0),(137,13,'/goods_img/goods2.jpg',0),(138,13,'/goods_img/goods3jpg',0),(139,13,'/goods_img/goods4.jpg',0),(140,13,'/goods_img/goods5.jpg',0),(141,14,'/goods_img/goods6.jpg',0),(142,14,'/goods_img/goods7.jpg',0),(143,14,'/goods_img/goods8jpg',0),(144,14,'/goods_img/goods9.jpg',0),(145,15,'/goods_img/goods10.jpg',0),(146,15,'/goods_img/goods11.jpg',0),(147,15,'/goods_img/goods12.jpg',0),(148,15,'/goods_img/goods13jpg',0),(149,15,'/goods_img/goods14.jpg',0),(150,15,'/goods_img/goods15.jpg',0);

#
# Structure for table "goods_table"
#

CREATE TABLE `goods_table` (
  `goods_id` int(14) NOT NULL AUTO_INCREMENT,
  `category_id` int(14) NOT NULL,
  `brand_id` int(14) NOT NULL,
  `shop_id` int(14) NOT NULL,
  `goods_name` varchar(100) DEFAULT NULL,
  `goods_original_price` varchar(100) DEFAULT NULL,
  `goods_discount_price` varchar(100) DEFAULT NULL,
  `discount_detail` varchar(100) DEFAULT NULL,
  `goods_guarantee` varchar(100) DEFAULT NULL,
  `goods_popularity` varchar(100) DEFAULT NULL,
  `follow` varchar(100) DEFAULT NULL,
  `time` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`goods_id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

#
# Data for table "goods_table"
#

INSERT INTO `goods_table` VALUES (1,1,1,1,'漂亮的衣服1','120','100','8','7天无理由退货','100','99','1552221466'),(2,1,1,1,'漂亮的衣服2','121','101','8','7天无理由退货','100','99','1552221467'),(3,1,1,1,'漂亮的衣服3','122','102','8','7天无理由退货','100','99','1552221468'),(4,1,1,1,'漂亮的衣服4','123','103','8','7天无理由退货','100','99','1552221469'),(5,1,1,1,'漂亮的衣服5','124','104','8','7天无理由退货','100','99','1552221410'),(6,1,1,1,'漂亮的衣服6','125','105','8','7天无理由退货','100','99','1552221470'),(7,1,1,1,'漂亮的衣服7','126','106','8','7天无理由退货','100','99','1552221471'),(8,1,1,1,'漂亮的衣服8','127','107','8','7天无理由退货','100','99','1552221472'),(9,1,1,1,'漂亮的衣服9','128','108','8','7天无理由退货','100','99','1552221473'),(10,1,1,1,'漂亮的衣服10','129','109','9','7天无理由退货','100','99','1552221474'),(11,1,1,1,'漂亮的衣服11','130','110','9','7天无理由退货','100','99','1552221475'),(12,1,1,1,'漂亮的衣服12','140','111','9','7天无理由退货','100','99','1552221476'),(13,1,1,1,'漂亮的衣服13','160','113','9','7天无理由退货','100','99','1552221477'),(14,2,2,2,'漂亮的衣服1','120','100','8','7天无理由退货','100','99','1552221466'),(15,2,2,2,'漂亮的衣服2','121','101','8','7天无理由退货','100','99','1552221467'),(16,2,2,2,'漂亮的衣服3','122','102','8','7天无理由退货','100','99','1552221468'),(17,2,2,2,'漂亮的衣服4','123','103','8','7天无理由退货','100','99','1552221469'),(18,2,2,2,'漂亮的衣服5','124','104','8','7天无理由退货','100','99','1552221410'),(19,2,2,2,'漂亮的衣服6','125','105','8','7天无理由退货','100','99','1552221470'),(20,2,2,2,'漂亮的衣服7','126','106','8','7天无理由退货','100','99','1552221471'),(21,2,2,2,'漂亮的衣服8','127','107','8','7天无理由退货','100','99','1552221472'),(22,2,2,2,'漂亮的衣服9','128','108','8','7天无理由退货','100','99','1552221473'),(23,2,2,2,'漂亮的衣服10','129','109','9','7天无理由退货','100','99','1552221474'),(24,2,2,2,'漂亮的衣服11','130','110','9','7天无理由退货','100','99','1552221475'),(25,2,2,2,'漂亮的衣服12','140','111','9','7天无理由退货','100','99','1552221476'),(26,2,2,2,'漂亮的衣服13','160','113','9','7天无理由退货','100','99','1552221477');

#
# Structure for table "menu_table"
#

CREATE TABLE `menu_table` (
  `menu_id` int(14) NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "menu_table"
#

INSERT INTO `menu_table` VALUES (1,'MAN'),(2,'WOMAN'),(3,'KIDS'),(4,'LIFE');

#
# Structure for table "order_table"
#

CREATE TABLE `order_table` (
  `order_id` int(14) NOT NULL AUTO_INCREMENT,
  `user_id` int(14) NOT NULL,
  `pay_id` int(14) NOT NULL,
  `delivery_id` int(14) NOT NULL,
  `car_id` int(14) NOT NULL,
  `order_statues` int(14) NOT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "order_table"
#


#
# Structure for table "pick_table"
#

CREATE TABLE `pick_table` (
  `pick_id` int(14) NOT NULL AUTO_INCREMENT,
  `goods_id` int(14) NOT NULL,
  PRIMARY KEY (`pick_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "pick_table"
#

INSERT INTO `pick_table` VALUES (1,1),(2,2),(3,3),(4,4),(5,5);

#
# Structure for table "question_table"
#

CREATE TABLE `question_table` (
  `question_id` int(14) NOT NULL AUTO_INCREMENT,
  `question_title` varchar(100) DEFAULT NULL,
  `question_answer` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`question_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "question_table"
#


#
# Structure for table "recommend_table"
#

CREATE TABLE `recommend_table` (
  `recommend_id` int(14) NOT NULL AUTO_INCREMENT,
  `recommend_name` varchar(100) DEFAULT NULL,
  `recommend_url` varchar(100) DEFAULT NULL,
  `recommend_path` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`recommend_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "recommend_table"
#

INSERT INTO `recommend_table` VALUES (1,'重点推荐1','/recommend_img/recommend1.jpg','http://www.baidu.com/'),(2,'重点推荐2','/recommend_img/recommend2.jpg','http://www.baidu.com/'),(3,'重点推荐3','/recommend_img/recommend3.jpg','http://www.baidu.com/'),(4,'重点推荐4','/recommend_img/recommend4.jpg','http://www.baidu.com/'),(5,'重点推荐5','/recommend_img/recommend5.jpg','http://www.baidu.com/'),(6,'重点推荐6','/recommend_img/recommend6.jpg','http://www.baidu.com/'),(7,'重点推荐7','/recommend_img/recommend7.jpg','http://www.baidu.com/');

#
# Structure for table "see_category_table"
#

CREATE TABLE `see_category_table` (
  `see_category_id` int(14) NOT NULL AUTO_INCREMENT,
  `see_category_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`see_category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

#
# Data for table "see_category_table"
#

INSERT INTO `see_category_table` VALUES (1,'最新'),(2,'搭配'),(3,'头条'),(4,'上新'),(5,'视频');

#
# Structure for table "see_edt_table"
#

CREATE TABLE `see_edt_table` (
  `see_edt_id` int(14) NOT NULL AUTO_INCREMENT,
  `see_category_id` int(14) NOT NULL,
  `see_edt_name` varchar(100) DEFAULT NULL,
  `see_edt_icon` varchar(100) DEFAULT NULL,
  `see_edt_tag` varchar(100) DEFAULT NULL,
  `see_edt_values` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`see_edt_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

#
# Data for table "see_edt_table"
#

INSERT INTO `see_edt_table` VALUES (1,1,'wzh1','/head_img/wzh_head.png','最肥','史上最胖的人'),(2,1,'wzh2','/head_img/wzh_head.png','最肥','史上最胖的人'),(3,1,'wzh3','/head_img/wzh_head.png','最肥','史上最胖的人'),(4,1,'wzh4','/head_img/wzh_head.png','最肥','史上最胖的人');

#
# Structure for table "see_news_table"
#

CREATE TABLE `see_news_table` (
  `see_news_id` int(14) NOT NULL AUTO_INCREMENT,
  `see_edt_id` int(14) NOT NULL,
  `see_news_title` varchar(100) DEFAULT NULL,
  `see_news_img` varchar(100) DEFAULT NULL,
  `see_news_values` varchar(100) DEFAULT NULL,
  `see_news_time` varchar(100) DEFAULT NULL,
  `see_news_num` varchar(100) DEFAULT NULL,
  `see_news_collection` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`see_news_id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

#
# Data for table "see_news_table"
#

INSERT INTO `see_news_table` VALUES (1,1,'王忠华1','/recommend_img/recommend1.jpg','游戏学院最亮的仔','1553139538','100','90'),(2,1,'王忠华2','/recommend_img/recommend2.jpg','游戏学院最亮的仔','1553139538','100','90'),(3,1,'王忠华3','/recommend_img/recommend3.jpg','游戏学院最亮的仔','1553139538','100','90'),(4,1,'王忠华4','/recommend_img/recommend4.jpg','游戏学院最亮的仔','1553139538','100','90'),(5,1,'王忠华5','/recommend_img/recommend5.jpg','游戏学院最亮的仔','1553139538','100','90'),(6,1,'王忠华6','/recommend_img/recommend6.jpg','游戏学院最亮的仔','1553139538','100','90'),(7,1,'王忠华7','/recommend_img/recommend7.jpg','游戏学院最亮的仔','1553139538','100','90'),(8,1,'王忠华8','/recommend_img/recommend1.jpg','游戏学院最亮的仔','1553139538','100','90'),(9,1,'王忠华9','/recommend_img/recommend2.jpg','游戏学院最亮的仔','1553139538','100','90'),(10,1,'王忠华10','/recommend_img/recommend3.jpg','游戏学院最亮的仔','1553139538','100','90'),(11,1,'王忠华11','/recommend_img/recommend4.jpg','游戏学院最亮的仔','1553139538','100','90'),(12,1,'王忠华12','/recommend_img/recommend5.jpg','游戏学院最亮的仔','1553139538','100','90'),(13,1,'王忠华13','/recommend_img/recommend6.jpg','游戏学院最亮的仔','1553139538','100','90'),(14,1,'王忠华14','/recommend_img/recommend7.jpg','游戏学院最亮的仔','1553139538','100','90'),(15,1,'王忠华15','/recommend_img/recommend1.jpg','游戏学院最亮的仔','1553139538','100','90'),(16,1,'王忠华16','/recommend_img/recommend2.jpg','游戏学院最亮的仔','1553139538','100','90'),(17,1,'王忠华17','/recommend_img/recommend3.jpg','游戏学院最亮的仔','1553139538','100','90'),(18,1,'王忠华18','/recommend_img/recommend4.jpg','游戏学院最亮的仔','1553139538','100','90'),(19,1,'王忠华19','/recommend_img/recommend5.jpg','游戏学院最亮的仔','1553139538','100','90'),(20,1,'王忠华20','/recommend_img/recommend6.jpg','游戏学院最亮的仔','1553139538','100','90'),(21,1,'王忠华1qqq','/recommend_img/recommend7.jpg','游戏学院最亮的仔','1553139538','100','90'),(22,2,'王忠华2eewe','/recommend_img/recommend2.jpg','游戏学院最亮的仔','1553139538','100','90'),(23,1,'王忠华3wc','/recommend_img/recommend1.jpg','游戏学院最亮的仔','1553139538','100','90'),(24,1,'王忠华4wcg','/recommend_img/recommend6.jpg','游戏学院最亮的仔','1553139538','100','90'),(25,1,'王忠华jcw','/recommend_img/recommend7.jpg','游戏学院最亮的仔','1553139538','100','90'),(26,2,'王忠华sd','/recommend_img/recommend4.jpg','游戏学院最亮的仔','1553139538','100','90'),(27,1,'王忠华1sd','/recommend_img/recommend3.jpg','游戏学院最亮的仔','1553139538','100','90'),(28,1,'王忠华1ss','/recommend_img/recommend5.jpg','游戏学院最亮的仔','1553139538','100','90'),(29,2,'王忠华1ee','/recommend_img/recommend2.jpg','游戏学院最亮的仔','1553139538','100','90'),(30,1,'王忠华1kk','/recommend_img/recommend6.jpg','游戏学院最亮的仔','1553139538','100','90');

#
# Structure for table "show_table"
#

CREATE TABLE `show_table` (
  `show_id` int(14) NOT NULL AUTO_INCREMENT,
  `user_id` int(14) NOT NULL,
  `goods_id` int(14) NOT NULL,
  `img_path` varchar(100) DEFAULT NULL,
  `fabulous` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`show_id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

#
# Data for table "show_table"
#

INSERT INTO `show_table` VALUES (1,1,1,'/head_img/brand1.png','10'),(2,1,2,'/head_img/brand10.png','10'),(3,1,1,'/head_img/brand2.png','10'),(4,1,2,'/head_img/brand11.png','10'),(5,1,3,'/head_img/brand3.png','10'),(6,1,2,'/head_img/brand12.png','10'),(7,1,4,'/head_img/brand4.png','10'),(8,1,3,'/head_img/brand13.png','10'),(9,1,5,'/head_img/brand5.png','10'),(10,1,3,'/head_img/brand14.png','10'),(11,1,6,'/head_img/brand6.png','10'),(12,1,4,'/head_img/brand15.png','10'),(13,1,7,'/head_img/brand7.png','10'),(14,1,4,'/head_img/brand16.png','10'),(15,1,8,'/head_img/brand8.png','10'),(16,1,5,'/head_img/brand17.png','10'),(17,1,2,'/head_img/brand9.png','10'),(18,1,5,'/head_img/brand18.png','10'),(19,1,3,'/head_img/brand8.png','10'),(20,1,6,'/head_img/brand19.png','10'),(21,1,5,'/head_img/brand7.png','10');

#
# Structure for table "size_table"
#

CREATE TABLE `size_table` (
  `size_id` int(14) NOT NULL AUTO_INCREMENT,
  `size_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`size_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "size_table"
#

INSERT INTO `size_table` VALUES (1,'L'),(2,'XL'),(3,'XXL'),(4,'XXXL');

#
# Structure for table "theme_img_table"
#

CREATE TABLE `theme_img_table` (
  `theme_img_id` int(14) NOT NULL AUTO_INCREMENT,
  `theme_id` int(14) NOT NULL,
  `theme_path` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`theme_img_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "theme_img_table"
#


#
# Structure for table "theme_table"
#

CREATE TABLE `theme_table` (
  `theme_id` int(14) NOT NULL AUTO_INCREMENT,
  `user_id` int(14) NOT NULL,
  `theme_values` varchar(100) DEFAULT NULL,
  `theme_tag` varchar(100) DEFAULT NULL,
  `theme_fabulous` varchar(100) DEFAULT NULL,
  `theme_comment` varchar(100) DEFAULT NULL,
  `theme_time` varchar(100) DEFAULT NULL,
  `theme_top` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`theme_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "theme_table"
#


#
# Structure for table "vip_level_table"
#

CREATE TABLE `vip_level_table` (
  `level_id` int(14) NOT NULL AUTO_INCREMENT,
  `level_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`level_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "vip_level_table"
#

INSERT INTO `vip_level_table` VALUES (1,'普通'),(2,'银卡'),(3,'金卡'),(4,'白金'),(5,'黑卡');

#
# Structure for table "vip_table"
#

CREATE TABLE `vip_table` (
  `vip_id` int(14) NOT NULL AUTO_INCREMENT,
  `user_id` int(14) NOT NULL,
  `vip_level` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`vip_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

#
# Data for table "vip_table"
#

INSERT INTO `vip_table` VALUES (1,1,1);
