text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : kevin
  Source Server Version : 50553
  Source Host           : localhost:3306
  Source Database       : wildcubic
  
  Target Server Type    : MYSQL
  Target Server Version : 50553
  File Encoding         : 65001
  
  Date: 2018-10-16 20:09:23
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for about
  -- ----------------------------
  DROP TABLE IF EXISTS `about`;
  CREATE TABLE `about` (
    `about_id` int(11) NOT NULL AUTO_INCREMENT,
    `about_category_id` int(11) NOT NULL,
    `about_title` varchar(255) NOT NULL,
    `type` int(3) NOT NULL DEFAULT '1',
    `about_content` text NOT NULL,
    `link` varchar(255) DEFAULT NULL,
    `sort_id` int(11) DEFAULT NULL,
    `time_create` varchar(11) NOT NULL,
    `time_update` varchar(11) NOT NULL,
    `page_keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
    `page_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
    `status` int(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`about_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of about
  -- ----------------------------
  INSERT INTO `about` VALUES ('1', '0', '加入我们吧', '1', '好好好', '', '2', '1519704891', '1528109770', '关键字111', '页面描述', '1');
  INSERT INTO `about` VALUES ('2', '1', '免责声明', '1', '好好好', null, '2', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('3', '0', '市场合作', '1', '好好好', '', '3', '1519704891', '1528109664', '关键字', '', '1');
  INSERT INTO `about` VALUES ('4', '1', '企业采购', '1', '好好好', null, '4', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('5', '2', '品牌态度', '1', '好好好', null, '5', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('6', '2', '官方验证', '1', '好好好', null, '6', '1519704891', '1520682905', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('7', '2', '保真承诺', '1', '好好好', null, '7', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('8', '2', '联系客服', '1', '好好好', null, '8', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('9', '2', '隐私条款', '1', '好好好', null, '9', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('10', '2', '赝品赔付', '1', '好好好', null, '10', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('11', '3', '会员及vip服务', '1', '好好好', null, '11', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('12', '3', '购物流程', '1', '好好好', null, '12', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('13', '3', '物流配送', '1', '好好好', null, '13', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('14', '3', '交易条款', '1', '好好好', null, '14', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('15', '4', '支付流程', '1', '好好好', null, '15', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('16', '4', '公司转账', '1', '好好好', null, '16', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('17', '4', '银行转账', '1', '好好好', null, '17', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('18', '4', '支付转账', '1', '好好好', null, '18', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('19', '5', '发票政策', '1', '好好好', null, '19', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('20', '5', '售后政策', '1', '好好好', null, '20', '1519704891', '1520683010', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('21', '5', '退货政策', '1', '好好好', null, '21', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('22', '5', '退款流程', '1', '好好好', null, '22', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('23', '6', '定制服务', '1', '好好好', null, '23', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('24', '6', '官方验证', '1', '好好好', null, '24', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('25', '6', 'VIP验证', '1', '好好好', null, '25', '1519704891', '1519704891', '关键字', '关键字', '1');
  INSERT INTO `about` VALUES ('26', '1', '广汇股份', '1', 'fgjfg', '', '255', '1520749628', '1520749682', 'ggjh', 'fhjhgmg', '-1');
  INSERT INTO `about` VALUES ('27', '1', '会员注册协议', '1', '', '', '255', '1520922719', '1520922719', '会员注册', '会员注册', '1');
  INSERT INTO `about` VALUES ('28', '1', '隐私保护声明', '1', '', '', '255', '1520922755', '1520922755', '', '', '1');
  INSERT INTO `about` VALUES ('29', '0', '哈哈哈', '1', '', '', '255', '1528109036', '1528109036', '', '', '-1');
  INSERT INTO `about` VALUES ('30', '10', '如火如荼', '2', '&lt;img src=&quot;http://img.hxframework.com/image/20180605/20180605181446_55763.jpg&quot; alt=&quot;&quot; /&gt;', '//www.mi.com', '255', '1528193622', '1528193736', '耿浩', '方彩娣', '1');
  
  -- ----------------------------
  -- Table structure for about_category
  -- ----------------------------
  DROP TABLE IF EXISTS `about_category`;
  CREATE TABLE `about_category` (
    `about_category_id` int(11) NOT NULL AUTO_INCREMENT,
    `pid` int(11) NOT NULL DEFAULT '0',
    `level` int(11) NOT NULL DEFAULT '1',
    `relation` varchar(255) DEFAULT NULL,
    `about_category_title` varchar(255) NOT NULL,
    `sort_id` int(11) DEFAULT NULL,
    `time_create` varchar(11) DEFAULT NULL,
    `time_update` varchar(11) DEFAULT NULL,
    `status` int(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`about_category_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of about_category
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for article
  -- ----------------------------
  DROP TABLE IF EXISTS `article`;
  CREATE TABLE `article` (
    `article_id` int(11) NOT NULL AUTO_INCREMENT,
    `article_cid` int(11) DEFAULT NULL COMMENT '分类编号',
    `article_img` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '文章banner图编号',
    `article_title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `article_author` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '作者',
    `organization` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `article_content` text COLLATE utf8_bin,
    `is_home` int(11) NOT NULL DEFAULT '1',
    `is_up` tinyint(3) DEFAULT '0',
    `is_original` tinyint(3) DEFAULT '1' COMMENT '是否原创 1 原创',
    `author` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `type` tinyint(3) NOT NULL DEFAULT '1',
    `tm_publish` int(11) NOT NULL,
    `sort_id` int(11) NOT NULL DEFAULT '255',
    `time_create` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL,
    PRIMARY KEY (`article_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of article
  -- ----------------------------
  INSERT INTO `article` VALUES ('2', '3', '/201809/0919184252.jpg', '库克再谈史上最贵iPhone：要创新就不便宜', '', '野立方', 0x266C743B70207374796C653D2671756F743B666F6E742D73697A653A313670783B666F6E742D66616D696C793A2671756F743B20766572746963616C2D616C69676E3A626173656C696E653B746578742D696E64656E743A32656D3B6261636B67726F756E642D636F6C6F723A72676261283235352C3D2671756F743B2671756F743B203235352C3D2671756F743B2671756F743B20302E3635293B2671756F743B3D2671756F743B2671756F743B2667743B0D0A09E4B8BBE68C81E4BABAE7BD97E5AEBEC2B7E7BD97E4BCAFE88CA828526F62696E20526F626572747329E4BE8BE4B8BEE4BA86E4B88DE5B091E88A82E79BAEE5898DE4B880E5A4A9E5A4A7E4BC97E59CA8205477697474657220E4B88AE58F91E5B883E79A84E997AEE9A298EFBC8CE585B6E4B8ADE69C80E58F97E585B3E6B3A8E79A84E997AEE9A298E887AAE784B6E698AFE585B3E4BA8E26616D703B6E6273703B266C743B6120687265663D2671756F743B68747470733A2F2F6170706C652E707678742E6E65742F632F313235313233342F3433353430302F373633393F753D68747470732533412532462532467777772E6170706C652E636F6D253246636E2532466970686F6E652532462671756F743B207461726765743D2671756F743B5F626C616E6B2671756F743B2667743B6950686F6E65266C743B2F612667743B26616D703B6E6273703B585320E5928C206950686F6E65205853204D617820E79A84E5AE9AE4BBB7EFBC8C20E6AF95E7AB9F206950686F6E65205853204D617820E68890E4B8BAE4BA86E88BB9E69E9CE8BF84E4BB8AE4B8BAE6ADA2E69C80E69882E8B4B5E79A84E4B880E6ACBE206950686F6E65EFBC8CE9A1B6E9858D20353132474220E78988E68AA5E4BBB7203134343920E7BE8EE58583E380820D0A09266C743B2F702667743B0D0A266C743B70207374796C653D2671756F743B666F6E742D73697A653A313670783B666F6E742D66616D696C793A2671756F743B20766572746963616C2D616C69676E3A626173656C696E653B746578742D696E64656E743A32656D3B6261636B67726F756E642D636F6C6F723A72676261283235352C3D2671756F743B2671756F743B203235352C3D2671756F743B2671756F743B20302E3635293B2671756F743B3D2671756F743B2671756F743B2667743B0D0A09E5BA93E5858BE8A7A3E9878AE7A7B0EFBC8CE8BF90E890A5E59586E68F90E4BE9BE79A84E68C89E69C88E4BB98E6ACBEE8AEA1E58892E69C89E58AA9E4BA8EE9998DE4BD8E206950686F6E6520E79A84E69EB6E69E84E38082E4BB96E68C87E587BAEFBC8C6950686F6E6520E4B8ADE58C85E590ABE79A84E68980E69C89E68A80E69CAFE983BDE8A681E6B182E5819AE588B0E58FAFE4BBA5E58F96E4BBA3E4B98BE5898DE69F90E4BA9BE78BACE7AB8BE79A84E8AEBEE5A487EFBC8CE4BE8BE5A682204D503320E692ADE694BEE599A8E5928CE695B0E7A081E79BB8E69CBAEFBC8CE59BA0E6ADA4E699BAE883BDE6898BE69CBAE6898DE9AB98E6BAA2E4BBB7E38082E5BA93E5858BE8BF98E9878DE794B3E4BA86E4B88AE591A8E59CA8E68EA5E58F97E3808AE697A5E7BB8FE3808BE98787E8AEBFE79A84E59B9EE5BA94EFBC8CE5A3B0E7A7B0E88BB9E69E9CE79A84E79BAEE6A087E698AFE2809CE4B8BAE6AF8FE4B880E4B8AAE4BABAE69C8DE58AA1E2809DEFBC8CE8AEA4E4B8BAE5889BE696B0E4BDBFE585B6E5AE9AE4BBB7E8B6B3E5A49FE59088E79086EFBC8CE69C89E4BABAE4BC9AE4B8BAE585B6E4B9B0E58D95E380820D0A266C743B2F702667743B0D0A266C743B70207374796C653D2671756F743B666F6E742D73697A653A313670783B666F6E742D66616D696C793A2671756F743B20766572746963616C2D616C69676E3A626173656C696E653B746578742D696E64656E743A32656D3B6261636B67726F756E642D636F6C6F723A72676261283235352C3D2671756F743B2671756F743B203235352C3D2671756F743B2671756F743B20302E3635293B2671756F743B3D2671756F743B2671756F743B2667743B0D0A09E7BD97E4BCAFE88CA8E8AFA2E997AEE5BA93E5858BEFBC9AE2809CE4B880E6ACBEE79A84E69CBAE59E8BE585B6E594AEE4BBB7E5B086E8BF91203131303020E7BE8EE58583EFBC8CE4BDA0E698AFE590A6E68B85E5BF83E4B880E983A8E58886E4BABAE7BEA4E8AEA4E4B8BAE6A087E4BBB7E8BF87E9AB98EFBC9FE2809D0D0A09266C743B2F702667743B0D0A266C743B70207374796C653D2671756F743B666F6E742D73697A653A313670783B666F6E742D66616D696C793A2671756F743B20766572746963616C2D616C69676E3A626173656C696E653B746578742D696E64656E743A32656D3B6261636B67726F756E642D636F6C6F723A72676261283235352C3D2671756F743B2671756F743B203235352C3D2671756F743B2671756F743B20302E3635293B2671756F743B3D2671756F743B2671756F743B2667743B0D0A09E5BA93E5858BE59B9EE7AD94E7A7B0EFBC9AE2809CE5A5BDE590A7EFBC8CE68891E4BBACE683B3E4B8BAE6AF8FE4B8AAE4BABAE983BDE7949FE4BAA7206950686F6E65EFBC8CE8BF99E4B880E79BB4E698AFE68891E4BBACE79A84E79BAEE6A087EFBC8CE68891E4BBACE79A84E4BAA7E59381E7BABFE4B8ADE5B7B2E69C89E5A5BDE587A0E6ACBE206950686F6E6520EFBC8CE5AE83E4BBACE79A84E4BBB7E6A0BCE4BC9AE5A4A7E5B985E4B88BE9998DE588B0E99D9EE5B8B8E4BD8EE79A84E6B0B4E5B9B3E38082E4BD86E698AFEFBC8CE5A682E69E9CE4BDA0EFBC88E5B086E696B0E4B880E4BBA3206950686F6E65EFBC89E5AFB9E6AF94E8BF99E6ACBEE6898BE69CBAE79C8BE79C8BEFBC8CE5AE83E697A0E79691E698AFE68891E4BBACE5819AE8BF87E79A84E69C80E58588E8BF9BE79A84206950686F6E65E38082E2809D0D0A266C743B2F702667743B0D0A266C743B70207374796C653D2671756F743B666F6E742D73697A653A313670783B666F6E742D66616D696C793A2671756F743B20766572746963616C2D616C69676E3A626173656C696E653B746578742D696E64656E743A32656D3B6261636B67726F756E642D636F6C6F723A72676261283235352C3D2671756F743B2671756F743B203235352C3D2671756F743B2671756F743B20302E3635293B2671756F743B3D2671756F743B2671756F743B2667743B0D0A09E5BA93E5858BE68EA5E79D80E8A1A8E7A4BAEFBC8CE2809CE4BA8BE5AE9EE4B88AEFBC8CE5A4A7E5A49AE695B0E4BABAE694AFE4BB98E8B4ADE69CBAE8B4B9E794A8E79A84E696B9E5BC8FE280A6E280A6E698AFE4B88EE8BF90E890A5E59586E7ADBEE59088E7BAA6EFBC8CE68C89E69C88E4BE9BE694AFE4BB98E8B4B9E794A8E38082E68980E4BBA5EFBC8CE5A682E69E9CE4BDA0E79C8BE4B880E4B88BE8BF99E4BBB7E6A0BCE8B685E8BF87203130303020E7BE8EE58583E79A84E6898BE69CBAEFBC8CE5A4A7E5A49AE695B0E4BABAE6AF8FE4B8AAE69C88E58FAAE99C80E4BB98E8B4B920333020E7BE8EE58583EFBC8CE4B99FE5B0B1E698AFE5A4A7E7BAA6203120E7BE8EE58583E4B880E5A4A9E38082E2809D0D0A09266C743B2F702667743B0D0A266C743B70207374796C653D2671756F743B666F6E742D73697A653A313670783B666F6E742D66616D696C793A2671756F743B20766572746963616C2D616C69676E3A626173656C696E653B746578742D696E64656E743A32656D3B6261636B67726F756E642D636F6C6F723A72676261283235352C3D2671756F743B2671756F743B203235352C3D2671756F743B2671756F743B20302E3635293B2671756F743B3D2671756F743B2671756F743B2667743B0D0A09E5BA93E5858BE8BF98E5BCBAE5A4A7EFBC9AE2809CE5A682E69E9CE4BDA0E5868DE79C8BE79C8BE8BF99E6ACBEE6898BE69CBAEFBC886950686F6E65205853204D6178EFBC89EFBC8CE5AE83E5B7B2E7BB8FE58F96E4BBA3E4BA86E4BDA0E79A84E695B0E7A081E79BB8E69CBAE280A6E280A6E5AE83E58F96E4BBA3E4BA86E4BDA0E79A84E69184E5838FE69CBAEFBC8CE58F96E4BBA3E4BA86E4BDA0E79A84E99FB3E4B990E692ADE694BEE599A8EFBC8CE58F96E4BBA3E4BA86E68980E69C89E8BF99E4BA9BE4B88DE5908CE79A84E8AEBEE5A487E38082E59BA0E6ADA4EFBC8CE58FAFE4BBA5E8AFB4E8BF99E6ACBEE4BAA7E59381E698AFE99D9EE5B8B8E9878DE8A681E79A84E38082E68891E4BBACE58F91E78EB0E4BABAE4BBACE5B88CE69C9BE68BA5E69C89E69C80E585B7E5889BE696B0E680A7E79A84E4BAA7E59381EFBC8CE784B6E8808CE5819AE8BF99E6A0B7E79A84E4BAA7E59381E5B9B6E4B88DE4BEBFE5AE9CE380820D0A266C743B2F702667743B, '1', '1', '1', 'john', '1', '1535126400', '255', '1535196682', '1537355133', '1');
  INSERT INTO `article` VALUES ('3', '2', '/201809/0919184422.jpg', '万元新iPhone闲鱼上被降价卖 卖家照样赚钱为何？', '', '野立方', 0x266C743B70207374796C653D2671756F743B666F6E742D73697A653A313670783B666F6E742D66616D696C793A2671756F743B20766572746963616C2D616C69676E3A626173656C696E653B746578742D696E64656E743A32656D3B6261636B67726F756E642D636F6C6F723A72676261283235352C3D2671756F743B2671756F743B203235352C3D2671756F743B2671756F743B20302E3635293B2671756F743B3D2671756F743B2671756F743B2667743B20266C743B7370616E207374796C653D2671756F743B666F6E742D7765696768743A3730303B2671756F743B2667743BE4B88DE4BB85E4B88DE58AA0E4BBB7EFBC8CE4BA8FE69CACE4B99FE8A681E58D96266C743B2F7370616E2667743B200D0A09266C743B2F702667743B0D0A266C743B70207374796C653D2671756F743B666F6E742D73697A653A313670783B666F6E742D66616D696C793A2671756F743B20766572746963616C2D616C69676E3A626173656C696E653B746578742D696E64656E743A32656D3B6261636B67726F756E642D636F6C6F723A72676261283235352C3D2671756F743B2671756F743B203235352C3D2671756F743B2671756F743B20302E3635293B2671756F743B3D2671756F743B2671756F743B2667743B0D0A09E4BB8AE5B9B4E79A846950686F6E65E594AEE4BBB7E5868DE5889BE7BAAAE5BD95EFBC8CE59BBDE8A18C6950686F6E65205853E5928C6950686F6E65205853204D415820E5AD98E582A8E5AEB9E9878F32353647E3808135313247E79A84E78988E69CACE4BBB7E6A0BCE59D87E8B685E8BF87E4B887E58583EFBC8CE69C80E9AB98E9858DE79A846950686F6E65205853204D6178E8BEBEE588B0E4BA863132373939E58583E380820D0A266C743B2F702667743B0D0A266C743B70207374796C653D2671756F743B666F6E742D73697A653A313670783B666F6E742D66616D696C793A2671756F743B20766572746963616C2D616C69676E3A626173656C696E653B746578742D696E64656E743A32656D3B6261636B67726F756E642D636F6C6F723A72676261283235352C3D2671756F743B2671756F743B203235352C3D2671756F743B2671756F743B20302E3635293B2671756F743B3D2671756F743B2671756F743B2667743B0D0A09E5B0BDE7AEA1E4BBB7E6A0BCE9AB98E4BC81EFBC8CE4BE9DE784B6E68CA1E4B88DE4BD8FE4B880E4BA9BE88BB9E69E9CE788B1E5A5BDE88085E79A84E783ADE68385EFBC8CE59CA8E9A284E8B4ADE79A84E794A8E688B7E5BD93E4B8ADEFBC8CE69C89E4BA9BE4BC9AE68A8AE68AA2E588B0E79A84E38081E5A49AE4BD99E79A846950686F6E65205853E5928C6950686F6E65205853204D6178E694BEE59CA8E4BA8CE6898BE5B9B3E58FB0E8BDACE58D96E380820D0A09266C743B2F702667743B0D0A266C743B70207374796C653D2671756F743B666F6E742D73697A653A313670783B666F6E742D66616D696C793A2671756F743B20766572746963616C2D616C69676E3A626173656C696E653B746578742D696E64656E743A32656D3B6261636B67726F756E642D636F6C6F723A72676261283235352C3D2671756F743B2671756F743B203235352C3D2671756F743B2671756F743B20302E3635293B2671756F743B3D2671756F743B2671756F743B2667743B0D0A09E59BA0E6ADA4EFBC8CE69C89E79A84E6B688E8B4B9E88085E5B88CE69C9BE5B0BDE5BFABE4BD93E9AA8CE588B0E696B06950686F6E65EFBC8CE58FAFE883BDE5B0B1E4BC9AE8BDACE59091E997B2E9B1BCE7AD89E4BA8CE6898BE4BAA4E69893E5B9B3E58FB0E58EBBE8B4ADE4B9B0E380820D0A266C743B2F702667743B, '1', '0', '1', 'john', '1', '1535126400', '255', '1535196741', '1537365730', '1');
  
  -- ----------------------------
  -- Table structure for article_category
  -- ----------------------------
  DROP TABLE IF EXISTS `article_category`;
  CREATE TABLE `article_category` (
    `article_cid` int(11) NOT NULL AUTO_INCREMENT,
    `article_ctitle` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `sort_id` int(11) NOT NULL,
    `time_update` int(11) DEFAULT NULL,
    `time_create` int(11) DEFAULT NULL,
    `status` int(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`article_cid`)
  ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of article_category
  -- ----------------------------
  INSERT INTO `article_category` VALUES ('1', '潮流一线', '1', '1535187470', '1535187046', '-1');
  INSERT INTO `article_category` VALUES ('2', '潮流一线', '1', '1535187707', '1535187707', '1');
  INSERT INTO `article_category` VALUES ('3', '品牌故事', '2', '1535187742', '1535187742', '1');
  INSERT INTO `article_category` VALUES ('4', '线下活动', '3', '1535187759', '1535187759', '1');
  
  -- ----------------------------
  -- Table structure for banner
  -- ----------------------------
  DROP TABLE IF EXISTS `banner`;
  CREATE TABLE `banner` (
    `banner_id` int(11) NOT NULL AUTO_INCREMENT,
    `cid` int(11) NOT NULL DEFAULT '1' COMMENT '分类id ,默认首页轮播图',
    `banner_title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `banner_img` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '图片地址',
    `banner_link` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '图片链接地址',
    `sort_id` int(11) NOT NULL DEFAULT '255',
    `time_update` int(11) DEFAULT NULL,
    `time_create` int(11) DEFAULT NULL,
    `status` int(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`banner_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of banner
  -- ----------------------------
  INSERT INTO `banner` VALUES ('1', '1', '轮播图1', '/201809/0919171850.jpg', '', '1', '1537348950', '1535179534', '1');
  INSERT INTO `banner` VALUES ('2', '1', '移动端商品111', '/201808/0825150118.JPG', '//www.mi.com', '2555', '1535180563', '1535179676', '-1');
  INSERT INTO `banner` VALUES ('3', '1', '轮播图2', '/201809/0919172201.jpg', '', '2', '1537348925', '1537348925', '1');
  INSERT INTO `banner` VALUES ('4', '1', '轮播图3', '/201809/0919172257.jpg', '', '3', '1537348981', '1537348981', '1');
  
  -- ----------------------------
  -- Table structure for brochure
  -- ----------------------------
  DROP TABLE IF EXISTS `brochure`;
  CREATE TABLE `brochure` (
    `brochure_id` int(11) NOT NULL AUTO_INCREMENT,
    `category_id` int(11) NOT NULL,
    `brochure_title` varchar(255) NOT NULL,
    `brochure_img` varchar(255) DEFAULT NULL,
    `brochure_content` varchar(255) DEFAULT NULL,
    `is_recommend` int(3) DEFAULT NULL,
    `home_show` int(3) DEFAULT NULL,
    `sort_id` int(11) DEFAULT NULL,
    `time_create` varchar(11) NOT NULL,
    `time_update` varchar(11) NOT NULL,
    `status` int(11) NOT NULL DEFAULT '1',
    PRIMARY KEY (`brochure_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of brochure
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for brochure_category
  -- ----------------------------
  DROP TABLE IF EXISTS `brochure_category`;
  CREATE TABLE `brochure_category` (
    `category_id` int(11) NOT NULL AUTO_INCREMENT,
    `parent_id` int(11) NOT NULL DEFAULT '0',
    `category_name` varchar(255) DEFAULT NULL,
    `category_key` varchar(255) DEFAULT NULL,
    `number` int(11) DEFAULT NULL,
    `is_show` int(3) DEFAULT NULL,
    `sort_id` int(11) DEFAULT NULL,
    `time_create` varchar(11) DEFAULT NULL,
    `time_update` varchar(11) DEFAULT NULL,
    `status` int(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`category_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of brochure_category
  -- ----------------------------
  INSERT INTO `brochure_category` VALUES ('10', '0', '各个地方', '', '0', '0', '1', '1531190713', '1531190713', '1');
  
  -- ----------------------------
  -- Table structure for express_company
  -- ----------------------------
  DROP TABLE IF EXISTS `express_company`;
  CREATE TABLE `express_company` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `key` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
    `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
    `sort_id` int(11) DEFAULT NULL,
    `tm_create` int(11) DEFAULT NULL,
    `tm_update` int(11) DEFAULT NULL,
    `status` int(11) DEFAULT '1',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=108 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of express_company
  -- ----------------------------
  INSERT INTO `express_company` VALUES ('102', 'YTO', '圆通快递', '2', null, null, '1');
  INSERT INTO `express_company` VALUES ('101', 'SFEXPRESS', '顺丰', '1', null, null, '1');
  INSERT INTO `express_company` VALUES ('103', 'ZTO', '中通快递', '3', null, null, '1');
  INSERT INTO `express_company` VALUES ('104', 'STO', '申通快递', '4', null, null, '1');
  INSERT INTO `express_company` VALUES ('105', 'YUNDA', '韵达快递', '5', null, null, '1');
  INSERT INTO `express_company` VALUES ('106', 'TTKDEX', '天天', '6', null, null, '1');
  INSERT INTO `express_company` VALUES ('107', 'ZJS', '宅急送', '7', null, null, '1');
  
  -- ----------------------------
  -- Table structure for goods
  -- ----------------------------
  DROP TABLE IF EXISTS `goods`;
  CREATE TABLE `goods` (
    `goods_id` int(11) NOT NULL AUTO_INCREMENT,
    `brand_id` int(11) DEFAULT NULL,
    `p_cid` int(11) DEFAULT NULL COMMENT '父级分类id',
    `relation` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `thumbnail` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '缩略图',
    `goods_pic_id` bigint(19) DEFAULT NULL COMMENT '多图编号',
    `color_unique_id` bigint(18) DEFAULT NULL,
    `goods_color_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `goods_size_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `goods_title` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '商品名称',
    `goods_title_en` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `goods_subtitle` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `goods_subtitle_en` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `goods_price` decimal(10,2) DEFAULT NULL,
    `goods_desc` text COLLATE utf8_bin COMMENT '商品描述',
    `goods_desc_en` text COLLATE utf8_bin,
    `is_home` int(3) NOT NULL DEFAULT '0' COMMENT '首页展示',
    `is_up` int(3) DEFAULT '0',
    `is_hot` int(3) NOT NULL DEFAULT '0',
    `express_free` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '邮费',
    `is_back` tinyint(3) DEFAULT NULL COMMENT '能否退换',
    `is_on` tinyint(3) NOT NULL DEFAULT '1',
    `is_check` tinyint(3) NOT NULL DEFAULT '0' COMMENT '官方审核 0 未审核 1 已审核 2 未通过',
    `stock` int(11) DEFAULT NULL COMMENT '库存',
    `address` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '厂家地址',
    `address_en` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `size_list` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `size_table` text COLLATE utf8_bin COMMENT '尺码对照表',
    `size_table_en` text COLLATE utf8_bin,
    `cloth_detail` text COLLATE utf8_bin COMMENT '成分护理表',
    `cloth_detail_en` text COLLATE utf8_bin,
    `back_policy` text COLLATE utf8_bin COMMENT '退换货政策',
    `back_policy_en` text COLLATE utf8_bin,
    `back_up` text COLLATE utf8_bin,
    `sort_id` int(11) DEFAULT NULL,
    `time_create` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `exe_name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '审核人姓名',
    `exe_status` int(3) DEFAULT '0' COMMENT '审核状态 0 未审核 1 审核失败 2 审核通过 ',
    `status` tinyint(3) NOT NULL DEFAULT '0',
    PRIMARY KEY (`goods_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of goods
  -- ----------------------------
  INSERT INTO `goods` VALUES ('12', '5', '1015', '<1007>,<1015>', '/201809/0919155321.png', '1537343486752', '1537343486334', '0', '1001,1002,1003,1004,1005,1006', '橙色羊毛大衣', 'T-shirt', '子标题2', 'subtitle2', '2800.00', '', '', '0', '0', '0', '0.00', null, '0', '0', '999', '上海', '', null, 0x313131, '', 0x323232, '', 0x333333, '', null, '255', '1537343695', '1539584806', null, '0', '1');
  INSERT INTO `goods` VALUES ('14', '6', '1008', '<1007>,<1008>', '/201809/0919161824.png', '1537344974203', '1537344974974', '0', '1001,1002,1003,1004,1006', '测试商品22', 'subtitle', '子标题2', 'subtitle21', '2000.00', '', '', '0', '0', '1', '0.00', null, '1', '1', '99', '上海市松江区洞泾镇', 'fhgfjhfjf', null, 0x313131, 0x323232, 0x333333, 0x343434, 0x353535, 0x363636, null, '255', '1537345116', '1538021651', null, '0', '1');
  INSERT INTO `goods` VALUES ('15', '7', '1008', '<1007>,<1008>', '/201809/0919161824.png', '1537344974203', '1537344974974', '0', '1001,1002,1003,1004,1005,1006', '测试商品3', null, '子标题', null, '200.00', '', '', '1', '1', '1', '0.00', null, '1', '1', '99', '上海市松江区', null, null, 0x313131, '', 0x323232, '', 0x333333, '', null, '255', '1537345116', '1537345116', null, '0', '1');
  INSERT INTO `goods` VALUES ('16', '5', '1008', '<1007>,<1008>', '/201809/0919161824.png', '1537344974203', '1537344974974', '0', '1001,1002,1003,1004,1005,1006', '测试商品4', null, '子标题', null, '200.00', '', '', '1', '1', '1', '0.00', null, '1', '1', '99', '上海市松江区', null, null, 0x313131, '', 0x323232, '', 0x333333, '', null, '255', '1537345116', '1537345116', null, '0', '1');
  INSERT INTO `goods` VALUES ('17', '4', '1008', '<1007>,<1008>', '/201809/0919161824.png', '1537344974203', '1537344974974', '0', '1001,1002,1003,1004,1005,1006', '测试商品5', null, '子标题', '', '155.53', '', '', '1', '1', '1', '0.25', null, '1', '1', '99', '上海市松江区', null, null, 0x313131, '', 0x323232, '', 0x333333, '', null, '255', '1537345116', '1537974219', null, '0', '1');
  INSERT INTO `goods` VALUES ('18', '6', '1008', '<1007>,<1008>', '/201809/0919161824.png', '1537344974203', '1537344974974', '0', '1001,1002,1003,1004,1005,1006', '测试商品6', null, '子标题', null, '200.00', '', '', '1', '1', '1', '0.00', null, '1', '1', '99', '上海市松江区', null, null, 0x313131, '', 0x323232, '', 0x333333, '', null, '255', '1537345116', '1537345116', null, '0', '1');
  INSERT INTO `goods` VALUES ('19', '7', '1009', '<1007>,<1009>', '/201809/0919161824.png', '1537344974203', '1537344974974', '0', '1001,1002,1003,1004,1005,1006', '测试商品7', null, '子标题', null, '200.00', '', '', '1', '1', '0', '0.00', null, '1', '1', '99', '上海市松江区', null, null, 0x313131, '', 0x323232, '', 0x333333, '', null, '255', '1537345116', '1537345116', null, '0', '1');
  INSERT INTO `goods` VALUES ('20', '5', '1009', '<1007>,<1009>', '/201809/0919161824.png', '1537344974203', '1537344974974', '0', '', '测试商品8', null, '子标题', '', '201.00', '', '', '1', '1', '0', '0.00', null, '1', '2', '99', '上海市松江区', '', null, 0x313131, '', 0x323232, '', 0x333333, '', 0xE5B0B1E8A681E79C8BE585B7E4BD93E79C8B, '255', '1537345117', '1539658189', null, '0', '1');
  INSERT INTO `goods` VALUES ('21', '4', '1009', '<1007>,<1009>', '/201809/0919161824.png', '1537344974203', '1537344974974', '0', '1001,1002,1003,1004,1005,1006', '测试商品9', null, '子标题', null, '202.00', '', '', '1', '1', '0', '0.00', null, '1', '1', '99', '上海市松江区', null, null, 0x313131, '', 0x323232, '', 0x333333, '', null, '255', '1537345119', '1537345116', null, '0', '1');
  INSERT INTO `goods` VALUES ('22', '6', '1009', '<1007>,<1009>', '/201809/0919161824.png', '1537344974203', '1537344974974', '0', '1001,1002,1003,1004,1005,1006', '测试商品10', null, '子标题', null, '203.00', '', '', '0', '1', '0', '0.00', null, '1', '1', '99', '上海市松江区', null, null, 0x313131, '', 0x323232, '', 0x333333, '', null, '255', '1537345120', '1537345116', null, '0', '1');
  INSERT INTO `goods` VALUES ('23', '7', '1009', '<1007>,<1009>', '/201809/0919161824.png', '1537344974203', '1537344974974', '0', '', '测试商品11', null, '子标题', '', '205.00', '', '', '0', '1', '0', '0.00', null, '1', '2', '99', '上海市松江区', '', null, 0x313131, '', 0x323232, '', 0x333333, '', 0xE4BB8AE5A4A9E8BF98E58FAFE4BBA5E4BA86, '255', '1537345200', '1539658147', null, '0', '1');
  INSERT INTO `goods` VALUES ('24', '6', '1010', '<1007>,<1010>', '/201809/0919161824.png', '1537344974203', '1537344974974', '0', '1001,1002,1003,1004,1005,1006', '测试商品12', null, '子标题', null, '200.00', '', '', '1', '1', '0', '0.00', null, '1', '1', '99', '上海市松江区', null, null, 0x313131, '', 0x323232, '', 0x333333, '', null, '255', '1537345116', '1537345116', null, '0', '1');
  INSERT INTO `goods` VALUES ('25', '5', '1010', '<1007>,<1010>', '/201809/0919161824.png', '1537344974203', '1537344974974', '0', '1001,1002,1003,1004,1005,1006', '测试商品13', null, '子标题', null, '200.00', '', '', '1', '1', '0', '0.00', null, '1', '1', '99', '上海市松江区', null, null, 0x313131, '', 0x323232, '', 0x333333, '', null, '255', '1537345116', '1537345116', null, '0', '1');
  INSERT INTO `goods` VALUES ('26', '7', '1010', '<1007>,<1010>', '/201809/0919161824.png', '1537344974203', '1537344974974', '0', '1001,1002,1003,1004,1005,1006', '测试商品14', null, '子标题', null, '200.00', '', '', '1', '1', '0', '0.00', null, '1', '1', '99', '上海市松江区', null, null, 0x313131, '', 0x323232, '', 0x333333, '', null, '255', '1537345116', '1537345116', null, '0', '1');
  INSERT INTO `goods` VALUES ('27', '5', '1015', '<1007>,<1015>', '/201809/0925210111.jpg', '1537880432476', '1537880432181', '0', '1001,1003,1004,1006', '短袖', null, null, null, '200.00', '', '', '0', '0', '0', '0.00', null, '1', '0', '0', '上海市松江区', null, null, 0xE4B8BAE4BBBBE4BD95E4BABA, 0xE9AB98E5BAA6E59BBDE99985E58C96, 0x656767E5908EE99DA2, 0xE79A84E8A784E88C83E58C96E8AEA1E58892, 0xE7BB9FE8AEA1, 0xE79A84E58A9FE5A4ABE5908EE99DA2, null, '255', '1537880581', '1537949882', null, '0', '1');
  INSERT INTO `goods` VALUES ('28', '5', '1007', '<1007>', '/201809/0926162257.jpg', '1537950162407', '1537950162580', '0', '1001,1002', '短袖', null, null, null, '200.00', '', '', '0', '0', '0', '0.00', null, '1', '0', '0', '上海市松江区', null, null, '', '', '', '', '', '', null, '255', '1537950234', '1537950234', null, '0', '1');
  INSERT INTO `goods` VALUES ('29', '4', '1007', null, '/201809/0927175751.jpg', '1538042247254', '1538042247465', '0', '1001,1002,1003', '短袖', null, '子标题2', 'subtitle2', '200.00', '', '', '0', '0', '0', '0.00', null, '0', '0', '0', '上海市松江区洞泾镇', 'fhgfjhfjf', null, 0x636276, 0x64676668, '', '', '', '', null, '255', '1538042291', '1538042291', null, '0', '1');
  INSERT INTO `goods` VALUES ('30', '4', '1007', '<1007>', '/201809/0927180418.png', '1538042635737', '1538042635638', '0', '', '短袖', null, '子标题2', 'subtitle2', '2000.00', '', '', '0', '0', '0', '0.00', null, '0', '0', '0', '上海市', 'fhgfjhfjf', null, '', '', '', '', '', '', null, '255', '1538042686', '1538042746', null, '0', '1');
  INSERT INTO `goods` VALUES ('31', '7', '1007', '<1007>', '/201809/0930163023.jpg', '1538296190575', '1538296190345', '0', '1001,1002', '短袖', null, '子标题2', 'subtitle2', '200.00', '', '', '0', '0', '0', '0.00', null, '0', '0', '0', '上海市松江区', 'fhgfjhfjf', null, 0x7366, 0x6326616D703B6E6273703B, 0x6463, 0x64, 0x64767366, 0x266C743B7374726F6E672667743B7366766662266C743B2F7374726F6E672667743B, null, '255', '1538296257', '1538296257', null, '0', '1');
  INSERT INTO `goods` VALUES ('32', '5', '1008', '<1007>,<1008>', '/201810/1016191114.jpg', '1539688258258', '1539688258666', '0', '1007,1019', '短袖', null, '子标题2', 'subtitle2', '2000.00', '', '', '0', '0', '0', '0.00', null, '1', '0', '0', '上海市松江区', null, null, '', '', '', '', '', '', null, '255', '1539688322', '1539689958', null, '0', '1');
  
  -- ----------------------------
  -- Table structure for goods_activity
  -- ----------------------------
  DROP TABLE IF EXISTS `goods_activity`;
  CREATE TABLE `goods_activity` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `type` tinyint(3) NOT NULL,
    `brand_id` int(11) DEFAULT NULL,
    `goods_ids` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `title_en` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `content` text COLLATE utf8_bin,
    `content_en` text COLLATE utf8_bin,
    `desc` text COLLATE utf8_bin,
    `desc_en` text COLLATE utf8_bin,
    `img` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `sort_id` int(11) NOT NULL DEFAULT '255',
    `time_create` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of goods_activity
  -- ----------------------------
  INSERT INTO `goods_activity` VALUES ('8', '1', '4', '<21>,<29>', '风格永存2', 'why', '', '', '', '', '/201809/0919163544.jpg', '255', '1537346157', '1538111936', '1');
  INSERT INTO `goods_activity` VALUES ('9', '2', null, '<15>,<19>,<23>,<12>,<14>,<22>,<24>', '夏日搭配推荐', '', 0xE79C8BE8BF87E69DA5EFBC8CE694B6E4B88BE4BDA0E79A84E5A48FE697A5E690ADE9858DE68C87E58D97, '', '', '', '/201809/0919163643.jpg', '255', '1537346252', '1538112366', '1');
  INSERT INTO `goods_activity` VALUES ('7', '1', '7', '<15>', '风格永存', 'new brand', '', '', '', '', '/201809/0919163430.jpg', '1', '1537346113', '1538111997', '1');
  INSERT INTO `goods_activity` VALUES ('10', '2', null, '<15>,<19>,<23>,<26>,<17>,<12>', '夏日搭配推荐2', '', 0xE79C8BE8BF87E69DA5EFBC8CE694B6E4B88BE4BDA0E79A84E5A48FE697A5E690ADE9858DE68C87E58D9732, '', '', '', '/201809/0919163750.jpg', '1', '1537346300', '1538111787', '1');
  INSERT INTO `goods_activity` VALUES ('13', '1', '5', '<12>,<16>', '为何参展', 'why', null, null, null, null, '/201809/0928132437.jpg', '255', '1538112284', '1538112331', '1');
  
  -- ----------------------------
  -- Table structure for goods_brand
  -- ----------------------------
  DROP TABLE IF EXISTS `goods_brand`;
  CREATE TABLE `goods_brand` (
    `brand_id` int(11) NOT NULL AUTO_INCREMENT,
    `brand_logo` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT 'logo图片地址',
    `brand_logo_transparent` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `brand_img` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `brand_title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `brand_title_en` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `brand_desc` text COLLATE utf8_bin,
    `brand_username` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `brand_pwd` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `back_address` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `back_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `back_mobile` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `designer_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `designer_name_en` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `designer_avatar` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `designer_desc` text COLLATE utf8_bin,
    `designer_desc_en` text COLLATE utf8_bin,
    `designer_bg` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `brand_word` text COLLATE utf8_bin NOT NULL COMMENT '品牌寄语',
    `brand_word_en` text COLLATE utf8_bin,
    `is_up` int(11) NOT NULL DEFAULT '0' COMMENT '置顶',
    `is_home` int(11) NOT NULL DEFAULT '1' COMMENT '首页显示',
    `sort_id` int(11) NOT NULL DEFAULT '255',
    `login_num` int(11) DEFAULT NULL,
    `last_login_time` int(11) DEFAULT NULL,
    `last_login_ip` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `time_create` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL,
    `wechat_no` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `mobile` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `qq` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `email` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `telphone` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `time_join` int(11) DEFAULT NULL,
    `gender` int(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`brand_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=1000001 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of goods_brand
  -- ----------------------------
  INSERT INTO `goods_brand` VALUES ('5', '/201809/0926211200.jpg', '/201809/0928144023.png', '/201809/0919154736.jpg', '莉香2', 'Adias22', null, '222', 'fc1c837c285fce4bd99e05a80abf7477', 'rhtejyjutj6k', '宛', '2643554747', 'Gordon Rivera2', '22225453', '/201809/0926211154.jpg', 0x31313132, 0x73666E68677367, '', 0x61676432, 0x6666676726616D703B6E6273703B32, '0', '1', '255', null, null, null, '1537340237', '1539656550', '1', 'yjkutkty2', '宛超', '18317119661', '19902578022', '364975602@qq.com', '189876543332', '2018', '2');
  INSERT INTO `goods_brand` VALUES ('4', '/201809/0919153544.png', '/201809/0928144023.png', '/201809/0919154736.jpg', 'CAFE2', 'Adias22', null, '111', 'fc1c837c285fce4bd99e05a80abf7477', null, null, null, 'Gordon Rivera2', 'ejhyr', '/201809/0919154640.jpg', 0xE587BAE7949FE4BA8EE6B395E59BBDE79A84E8AEBEE8AEA1E5B888476F72646F6E20526976657261E68980E5889BE7AB8BE79A84E78BACE7AB8BE8AEBEE8AEA1E5B888E59381E7898CE4BAA6E5A682E5A5B9E69CACE4BABAE79A84E6B395E59BBDE8A180E7BB9FE4B880E888ACE7AE80E7BAA6E38081E4BC98E99B85E58DB4E58F88E9808FE99CB2E587BAE78BACE7AB8BE887AAE4B8BBE79A84E5A5B3E680A7E5BDA2E8B1A1E38082476F72646F6E20526976657261E587BAE8BAABE4BA8EE4B880E4B8AAE889BAE69CAFE280A676337267727435, 0x7233626772746E7274, '/201809/0919154647.jpg', 0xE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFAD7267746568, 0x716464676562, '0', '0', '23', null, null, null, '1537339934', '1538201305', '1', 'yjkutkty', '', '18317119662', '', '364975601@qq.com', '18987654333', '1970', '1');
  INSERT INTO `goods_brand` VALUES ('6', '/201809/0928143656.jpg', '/201809/0928144023.png', '/201809/0929121943.jpg', '耐克2', 'Adias2', null, '', '', null, null, null, 'Gordon Rivera2', '2222', '/201809/0919154846.jpg', 0xE587BAE7949FE4BA8EE6B395E59BBDE79A84E8AEBEE8AEA1E5B888476F72646F6E20526976657261E68980E5889BE7AB8BE79A84E78BACE7AB8BE8AEBEE8AEA1E5B888E59381E7898CE4BAA6E5A682E5A5B9E69CACE4BABAE79A84E6B395E59BBDE8A180E7BB9FE4B880E888ACE7AE80E7BAA6E38081E4BC98E99B85E58DB4E58F88E9808FE99CB2E587BAE78BACE7AB8BE887AAE4B8BBE79A84E5A5B3E680A7E5BDA2E8B1A1E38082476F72646F6E20526976657261E587BAE8BAABE4BA8EE4B880E4B8AAE889BAE69CAFE280A6, 0x65666668726E6A, '', 0xE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFAD72656872746A797974, 0x6164736667686A, '0', '0', '300', null, null, null, '1537343373', '1538194786', '1', 'yjkutkty', null, '18317119662', '35436356', '364975601@qq.com', '18987654333', '1537842080', '1');
  INSERT INTO `goods_brand` VALUES ('7', '/201809/0919155038.png', '/201809/0928144023.png', '/201809/0929121917.jpg', '阿迪达斯', 'Adias', null, '444', 'fc1c837c285fce4bd99e05a80abf7477', 'rhtejyjutj6k', '宛', '2643554747', 'Gordon Rivera', '', '/201809/0919155019.jpg', 0xE587BAE7949FE4BA8EE6B395E59BBDE79A84E8AEBEE8AEA1E5B888476F72646F6E20526976657261E68980E5889BE7AB8BE79A84E78BACE7AB8BE8AEBEE8AEA1E5B888E59381E7898CE4BAA6E5A682E5A5B9E69CACE4BABAE79A84E6B395E59BBDE8A180E7BB9FE4B880E888ACE7AE80E7BAA6E38081E4BC98E99B85E58DB4E58F88E9808FE99CB2E587BAE78BACE7AB8BE887AAE4B8BBE79A84E5A5B3E680A7E5BDA2E8B1A1E38082476F72646F6E20526976657261E587BAE8BAABE4BA8EE4B880E4B8AAE889BAE69CAFE280A6, '', '', 0xE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFADE59381E7898CE5AF84E8AFAD, '', '0', '1', '4', null, null, null, '1537343474', '1539656314', '1', '', '', '', '', '', '', '2018', '1');
  INSERT INTO `goods_brand` VALUES ('1000000', '/201809/0928144008.jpg', '/201809/0928144023.png', '/201809/0928144033.jpg', '莉香', 'Adias2', null, null, 'fc1c837c285fce4bd99e05a80abf7477', null, null, null, 'Gordon Rivera', null, '/201809/0928144017.jpg', '', '', '/201809/0928144027.jpg', '', '', '0', '0', '255', null, null, null, '1538116873', '1538211757', '1', '', '', '', '', '', '', '1538211757', '1');
  
  -- ----------------------------
  -- Table structure for goods_brand_log
  -- ----------------------------
  DROP TABLE IF EXISTS `goods_brand_log`;
  CREATE TABLE `goods_brand_log` (
    `brand_log_id` int(11) NOT NULL,
    `brand_id` int(11) DEFAULT NULL,
    `login_ip` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '登录ip',
    `time_create` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`brand_log_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of goods_brand_log
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for goods_category
  -- ----------------------------
  DROP TABLE IF EXISTS `goods_category`;
  CREATE TABLE `goods_category` (
    `goods_cid` int(11) NOT NULL AUTO_INCREMENT,
    `goods_cpid` int(11) DEFAULT NULL COMMENT '父级分类编号',
    `goods_crelation` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `goods_clevel` int(11) NOT NULL DEFAULT '1' COMMENT '分类层级',
    `goods_ctitle` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `goods_ctitle_en` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `goods_cimg` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '分类缩略图地址',
    `sort_id` int(11) NOT NULL DEFAULT '255',
    `time_update` int(11) DEFAULT NULL,
    `time_create` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`goods_cid`)
  ) ENGINE=MyISAM AUTO_INCREMENT=1027 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of goods_category
  -- ----------------------------
  INSERT INTO `goods_category` VALUES ('1006', '1005', '<1004>,<1005>,<1006>', '3', '短袖', null, '/201808/0829141528.jpg', '1', '1535529424', '1535523329', '-1');
  INSERT INTO `goods_category` VALUES ('1005', '1004', '1004,1005', '2', 'T恤', null, '/201808/0829141237.jpg', '2', '1535529416', '1535523159', '-1');
  INSERT INTO `goods_category` VALUES ('1004', '0', '1004', '1', '上装', null, '/201808/0829141227.jpg', '1', '1535529410', '1535523148', '-1');
  INSERT INTO `goods_category` VALUES ('1007', '0', '<1007>', '1', '上装', '', '/201809/0928151323.jpg', '1', '1538118807', '1537338911', '1');
  INSERT INTO `goods_category` VALUES ('1008', '1007', '<1007>,<1008>', '2', 'T恤', '', '/201809/0919143535.png', '1', '1537338941', '1537338941', '1');
  INSERT INTO `goods_category` VALUES ('1009', '1007', '<1007>,<1009>', '2', '上衣', '', '/201809/0919143555.png', '2', '1537338960', '1537338960', '1');
  INSERT INTO `goods_category` VALUES ('1010', '1007', '<1007>,<1010>', '2', '卫衣', '', '/201809/0919143613.png', '3', '1537338977', '1537338977', '1');
  INSERT INTO `goods_category` VALUES ('1011', '1007', '<1007>,<1011>', '2', '雪纺', '', '/201809/0919143633.png', '4', '1537338998', '1537338998', '1');
  INSERT INTO `goods_category` VALUES ('1012', '1007', '<1007>,<1012>', '2', '衬衫', '', '/201809/0919143812.png', '5', '1537339096', '1537339096', '1');
  INSERT INTO `goods_category` VALUES ('1026', '1007', '<1007>,<1026>', '2', '测试', '的比分定格', '/201809/0927173154.jpg', '255', '1538040715', '1538040715', '1');
  INSERT INTO `goods_category` VALUES ('1016', '1007', '<1007>,<1016>', '2', '背心', '', '/201809/0919144116.png', '7', '1537947168', '1537339280', '1');
  INSERT INTO `goods_category` VALUES ('1025', '1009', '<1009>', '3', '上装', '', '/201809/0926152801.jpg', '255', '1537946913', '1537946882', '1');
  INSERT INTO `goods_category` VALUES ('1015', '1007', '<1007>,<1015>', '2', '针织衫', '', '/201809/0919144033.png', '6', '1537339237', '1537339237', '1');
  INSERT INTO `goods_category` VALUES ('1019', '0', '<1019>', '1', '裤装', '', '/201809/0919144444.jpg', '2', '1537339669', '1537339487', '1');
  INSERT INTO `goods_category` VALUES ('1022', '0', '<1022>', '1', '鞋履', '', '/201809/0919144808.jpg', '6', '1537339695', '1537339695', '1');
  INSERT INTO `goods_category` VALUES ('1020', '0', '<1020>', '1', '裙装', '', '/201809/0919144521.jpg', '3', '1537339607', '1537339510', '1');
  INSERT INTO `goods_category` VALUES ('1021', '0', '<1021>', '1', '外套', '', '/201809/0919144732.jpg', '4', '1537339657', '1537339657', '1');
  INSERT INTO `goods_category` VALUES ('1023', '0', '<1023>', '1', '包包', '', '/201809/0919144834.jpg', '7', '1537339731', '1537339723', '1');
  INSERT INTO `goods_category` VALUES ('1024', '0', '<1024>', '1', '珠宝首饰', '', '/201809/0919144907.jpg', '8', '1537947055', '1537339748', '1');
  
  -- ----------------------------
  -- Table structure for goods_color
  -- ----------------------------
  DROP TABLE IF EXISTS `goods_color`;
  CREATE TABLE `goods_color` (
    `goods_color_id` int(11) NOT NULL AUTO_INCREMENT,
    `color_unique_id` bigint(18) DEFAULT NULL COMMENT '商品对应颜色唯一标识',
    `goods_color_title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `goods_color_img` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `size_id` int(11) DEFAULT NULL,
    `stock` int(11) NOT NULL DEFAULT '0',
    `is_finished` tinyint(3) NOT NULL DEFAULT '0',
    `sort_id` int(11) NOT NULL DEFAULT '255',
    `time_create` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`goods_color_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=93 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of goods_color
  -- ----------------------------
  INSERT INTO `goods_color` VALUES ('54', '1537950162580', '', '/goods/201809/0926162346.jpg', null, '0', '1', '1', '1537950226', '1537950226', '1');
  INSERT INTO `goods_color` VALUES ('55', '1537343486334', '红色', '/goods/201809/0926163516.jpg', null, '0', '0', '1', '1537950916', '1537950916', '-1');
  INSERT INTO `goods_color` VALUES ('56', '0', '计划于九月', null, null, '0', '0', '3', '1537952311', '1537954917', '-1');
  INSERT INTO `goods_color` VALUES ('57', '0', '红色', null, null, '0', '0', '3', '1537954956', '1537954964', '-1');
  INSERT INTO `goods_color` VALUES ('58', '1537343486334', '蓝色', null, null, '0', '0', '3', '1537955115', '1537955123', '-1');
  INSERT INTO `goods_color` VALUES ('59', '1537343486334', '蓝色', '/goods/201809/0926175657.png', null, '0', '0', '9', '1537955188', '1537955863', '1');
  INSERT INTO `goods_color` VALUES ('60', '1537343486334', '人头就突然', '/goods/201809/0926175237.jpg', null, '0', '0', '60', '1537955257', '1537955851', '1');
  INSERT INTO `goods_color` VALUES ('61', '1537343486334', '红色', '/goods/201809/0926180252.png', null, '0', '0', '3', '1537955571', '1537956172', '1');
  INSERT INTO `goods_color` VALUES ('62', '1537343486334', '绿色', '/goods/201809/0926181536.jpg', null, '0', '0', '80', '1537955874', '1537956936', '1');
  INSERT INTO `goods_color` VALUES ('63', '1537343486334', '青色', '/goods/201809/0926175836.jpg', null, '0', '0', '20', '1537955916', '1538021280', '1');
  INSERT INTO `goods_color` VALUES ('64', '1537344974974', '蓝色', '/goods/201809/0927121315.jpg', null, '0', '0', '2', '1537974215', '1538021595', '1');
  INSERT INTO `goods_color` VALUES ('65', '1538042089172', '', '/goods/201809/0927175526.jpg', null, '0', '1', '2', '1538042126', '1538042126', '1');
  INSERT INTO `goods_color` VALUES ('66', '1538042089172', '', '/goods/201809/0927175703.jpg', null, '0', '0', '1', '1538042223', '1538042223', '1');
  INSERT INTO `goods_color` VALUES ('67', '1538042247465', '', '/goods/201809/0927175803.jpg', null, '0', '1', '1', '1538042283', '1538042283', '1');
  INSERT INTO `goods_color` VALUES ('68', '1538042635638', '', '/goods/201809/0927180437.jpg', null, '0', '1', '1', '1538042677', '1538042677', '1');
  INSERT INTO `goods_color` VALUES ('69', '1538296190345', '溪水', '/goods/201809/0930163037.jpg', null, '0', '1', '1', '1538296237', '1538296237', '1');
  INSERT INTO `goods_color` VALUES ('70', '1539676672530', '为何参展', '/goods/201810/1016155806.jpg', '998', '22', '0', '1', '1539676686', '1539676686', '1');
  INSERT INTO `goods_color` VALUES ('71', '1539676908720', '为何参展', '/goods/201810/1016160200.jpg', '998', '200', '0', '1', '1539676920', '1539676920', '1');
  INSERT INTO `goods_color` VALUES ('72', '1539676938797', '为何参展', '/goods/201810/1016160234.jpg', '998', '22', '0', '1', '1539676954', '1539676954', '1');
  INSERT INTO `goods_color` VALUES ('73', '1539678596529', '为何参展', '/goods/201810/1016163007.jpg', '998', '22', '0', '1', '1539678607', '1539678607', '1');
  INSERT INTO `goods_color` VALUES ('74', '1539679154564', '为何参展', '/goods/201810/1016163934.jpg', '998', '22', '0', '1', '1539679174', '1539679188', '1');
  INSERT INTO `goods_color` VALUES ('75', '1539679225284', '为何参展', '/goods/201810/1016164045.jpg', '998', '12', '0', '1', '1539679245', '1539679258', '1');
  INSERT INTO `goods_color` VALUES ('76', '1539679335895', '为何参展', '/goods/201810/1016164223.jpg', '998', '22', '0', '1', '1539679343', '1539679349', '1');
  INSERT INTO `goods_color` VALUES ('77', '1539679386312', '为何参展', '/goods/201810/1016164323.jpg', '998', '22', '0', '1', '1539679403', '1539679511', '1');
  INSERT INTO `goods_color` VALUES ('78', '1539679657316', '为何参展', '/goods/201810/1016164755.jpg', '998', '22', '0', '1', '1539679675', '1539679675', '1');
  INSERT INTO `goods_color` VALUES ('79', '1539679700175', '溪水', '/goods/201810/1016164937.jpg', '998', '22', '0', '1', '1539679777', '1539680339', '1');
  INSERT INTO `goods_color` VALUES ('80', '1539680343651', '为何参展', '/goods/201810/1016165927.jpg', '998', '22', '0', '1', '1539680367', '1539680473', '1');
  INSERT INTO `goods_color` VALUES ('81', '1539680563719', '为何参展', '/goods/201810/1016170300.jpg', '998', '22', '0', '1', '1539680580', '1539680580', '1');
  INSERT INTO `goods_color` VALUES ('82', '1539681608134', '为何参展', '/goods/201810/1016172025.jpg', '998', '22', '0', '1', '1539681625', '1539681625', '1');
  INSERT INTO `goods_color` VALUES ('83', '1539681608134', '为何参展', '/goods/201810/1016172326.jpg', '998', '22', '0', '1', '1539681806', '1539681806', '1');
  INSERT INTO `goods_color` VALUES ('84', '1539681964628', '为何参展', '/goods/201810/1016172619.jpg', '998', '22', '0', '1', '1539681979', '1539682279', '1');
  INSERT INTO `goods_color` VALUES ('85', '1539682289881', '为何参展', '/goods/201810/1016173144.jpg', '998', '12', '0', '1', '1539682304', '1539682304', '1');
  INSERT INTO `goods_color` VALUES ('86', '1539683077417', '为何参展', '/goods/201810/1016174453.jpg', '998', '22', '0', '1', '1539683093', '1539683093', '1');
  INSERT INTO `goods_color` VALUES ('87', '1539683890685', '为何参展', '/goods/201810/1016175829.jpg', '998', '22', '0', '4', '1539683909', '1539687564', '1');
  INSERT INTO `goods_color` VALUES ('88', '1539683890685', '为何参展', '/goods/201810/1016180047.jpg', '1000', '22', '0', '1', '1539684047', '1539684047', '1');
  INSERT INTO `goods_color` VALUES ('89', '1539688258666', '红色', '/goods/201810/1016191134.jpg', '999', '22', '1', '1', '1539688294', '1539688294', '-1');
  INSERT INTO `goods_color` VALUES ('90', '1539688258666', '蓝色b', '/goods/201810/1016191156.jpg', '1019', '200', '1', '19', '1539688316', '1539689208', '-1');
  INSERT INTO `goods_color` VALUES ('91', '1539688258666', '为何参展2224654', '/goods/201810/1016192804.jpg', '1007', '1012', '0', '4', '1539689284', '1539689954', '1');
  INSERT INTO `goods_color` VALUES ('92', '1537344974974', '为何参展', '/goods/201810/1016194456.jpg', '1003', '22', '0', '2', '1539690296', '1539690304', '1');
  
  -- ----------------------------
  -- Table structure for goods_img
  -- ----------------------------
  DROP TABLE IF EXISTS `goods_img`;
  CREATE TABLE `goods_img` (
    `goods_img_id` int(11) NOT NULL AUTO_INCREMENT,
    `goods_img` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '多图地址',
    `title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `pic_id` bigint(19) DEFAULT NULL,
    `sort_id` int(11) NOT NULL DEFAULT '255',
    `time_update` int(11) DEFAULT NULL,
    `time_create` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`goods_img_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=146 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of goods_img
  -- ----------------------------
  INSERT INTO `goods_img` VALUES ('114', '/goods/201809/0917143131.jpg', 'goods', '1537165853366', '255', '1537165892', '1537165892', '1');
  INSERT INTO `goods_img` VALUES ('115', '/goods/201809/0917143141.jpg', 'Why Exhibit?', '1537165853366', '255', '1537165901', '1537165901', '1');
  INSERT INTO `goods_img` VALUES ('116', '/goods/201809/0917154903.jpg', '红色', '1537170491514', '1', '1537170543', '1537170543', '1');
  INSERT INTO `goods_img` VALUES ('117', '/goods/201809/0917155157.jpg', '为何参展', '1537170695350', '1', '1537170717', '1537170717', '1');
  INSERT INTO `goods_img` VALUES ('118', '/goods/201809/0918164611.jpg', '为何参展', '1537260276809', '1', '1537260371', '1537260371', '1');
  INSERT INTO `goods_img` VALUES ('119', '/goods/201809/0918164618.jpg', '溪水', '1537260276809', '3', '1537260378', '1537260378', '1');
  INSERT INTO `goods_img` VALUES ('120', '/goods/201809/0918164625.jpg', 'aa', '1537260276809', '1', '1537260385', '1537260385', '1');
  INSERT INTO `goods_img` VALUES ('121', '/goods/201809/0919155341.jpg', '', '0', '3', '1537954903', '1537343621', '1');
  INSERT INTO `goods_img` VALUES ('122', '/goods/201809/0919155345.jpg', '为何参展', '1537343486752', '12', '1537955291', '1537343625', '1');
  INSERT INTO `goods_img` VALUES ('123', '/goods/201809/0926180229.jpg', '', '0', '3', '1537956149', '1537343631', '1');
  INSERT INTO `goods_img` VALUES ('124', '/goods/201809/0919161731.png', '', '1537344974203', '1', '1537345051', '1537345051', '1');
  INSERT INTO `goods_img` VALUES ('125', '/goods/201809/0919161735.jpg', '为何参展', '1537344974203', '3', '1539674789', '1537345055', '1');
  INSERT INTO `goods_img` VALUES ('126', '/goods/201809/0919161739.png', '', '1537344974203', '1', '1537345059', '1537345059', '1');
  INSERT INTO `goods_img` VALUES ('129', '/goods/201809/0925210202.png', '', '1537880432476', '1', '1537880522', '1537880522', '1');
  INSERT INTO `goods_img` VALUES ('130', '/goods/201809/0925210210.jpg', '', '1537880432476', '1', '1537880530', '1537880530', '1');
  INSERT INTO `goods_img` VALUES ('131', '/goods/201809/0926133613.jpg', '商品1', '1537343486752', '1', '1537959514', '1537940173', '1');
  INSERT INTO `goods_img` VALUES ('133', '/goods/201809/0926162341.jpg', '', '1537950162407', '1', '1537950221', '1537950221', '1');
  INSERT INTO `goods_img` VALUES ('135', '/goods/201809/0926181507.jpg', '商品3', '1537343486752', '57', '1537956907', '1537956111', '1');
  INSERT INTO `goods_img` VALUES ('136', '/goods/201809/0927175518.jpg', '为何参展', '1538042089289', '1', '1538042118', '1538042118', '1');
  INSERT INTO `goods_img` VALUES ('137', '/goods/201809/0927175756.jpg', '', '1538042247254', '1', '1538042276', '1538042276', '1');
  INSERT INTO `goods_img` VALUES ('138', '/goods/201809/0927180425.jpg', '', '1538042635737', '1', '1538042665', '1538042665', '1');
  INSERT INTO `goods_img` VALUES ('139', '/goods/201809/0927180429.jpg', '', '1538042635737', '1', '1538042669', '1538042669', '1');
  INSERT INTO `goods_img` VALUES ('140', '/goods/201809/0930163029.jpg', '为何参展', '1538296190575', '1', '1538296229', '1538296229', '1');
  INSERT INTO `goods_img` VALUES ('112', '/goods/201809/0917142053.jpg', null, '1537163518778', '255', '1537165253', '1537165253', '1');
  INSERT INTO `goods_img` VALUES ('113', '/goods/201809/0917142128.jpg', '高山流水', '1537163518778', '255', '1537165288', '1537165288', '1');
  INSERT INTO `goods_img` VALUES ('141', '/goods/201810/1016153259.jpg', '', '1539675171492', '1', '1539675179', '1539675179', '1');
  INSERT INTO `goods_img` VALUES ('142', '/goods/201810/1016154957.jpg', '', '1539675898430', '1', '1539676197', '1539676197', '1');
  INSERT INTO `goods_img` VALUES ('143', '/goods/201810/1016164035.jpg', '', '1539679225241', '1', '1539679235', '1539679235', '1');
  INSERT INTO `goods_img` VALUES ('144', '/goods/201810/1016191124.jpg', '为何参展', '1539688258258', '1', '1539688284', '1539688284', '1');
  INSERT INTO `goods_img` VALUES ('145', '/goods/201810/1016193028.jpg', '为何参展222', '1539688258258', '4', '1539689435', '1539689428', '1');
  
  -- ----------------------------
  -- Table structure for goods_stock
  -- ----------------------------
  DROP TABLE IF EXISTS `goods_stock`;
  CREATE TABLE `goods_stock` (
    `stock_id` int(11) NOT NULL AUTO_INCREMENT,
    `goods_size_id` int(11) DEFAULT NULL,
    `goods_color_id` int(11) DEFAULT NULL,
    `color_unique_id` bigint(18) DEFAULT NULL,
    `stock` int(11) DEFAULT NULL,
    `sort_id` int(11) NOT NULL DEFAULT '255',
    `time_create` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `status` int(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`stock_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of goods_stock
  -- ----------------------------
  INSERT INTO `goods_stock` VALUES ('7', '998', '80', '1539680343651', '22', '255', '1539680367', '1539680367', '1');
  INSERT INTO `goods_stock` VALUES ('12', '998', '85', '1539682289881', '12', '255', '1539682304', '1539682304', '1');
  INSERT INTO `goods_stock` VALUES ('13', '998', '86', '1539683077417', '22', '255', '1539683093', '1539683093', '1');
  INSERT INTO `goods_stock` VALUES ('14', '1012', '87', '1539683890685', '2233', '255', '1539683909', '1539683909', '1');
  INSERT INTO `goods_stock` VALUES ('15', '1000', '88', '1539683890685', '22', '255', '1539684047', '1539684047', '1');
  INSERT INTO `goods_stock` VALUES ('16', '999', '89', '1539688258666', '22', '255', '1539688294', '1539688294', '1');
  INSERT INTO `goods_stock` VALUES ('17', '1019', '90', '1539688258666', '200', '255', '1539688316', '1539688316', '1');
  INSERT INTO `goods_stock` VALUES ('18', '1017', '91', '1539688258666', '10', '255', '1539689284', '1539689284', '1');
  INSERT INTO `goods_stock` VALUES ('19', '998', '92', '1537344974974', '22', '255', '1539690296', '1539690296', '1');
  
  -- ----------------------------
  -- Table structure for manage_admin
  -- ----------------------------
  DROP TABLE IF EXISTS `manage_admin`;
  CREATE TABLE `manage_admin` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
    `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
    `tm_create` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '创建时间',
    `tm_update` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '更新时间',
    `login_num` int(11) DEFAULT NULL COMMENT '登录次数',
    `last_login_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '最后一次登录时间',
    `last_login_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '最后一次登录IP',
    `sort_id` int(11) DEFAULT NULL,
    `status` int(11) DEFAULT '1',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1004 DEFAULT CHARSET=latin1;
  
  -- ----------------------------
  -- Records of manage_admin
  -- ----------------------------
  INSERT INTO `manage_admin` VALUES ('1001', 'admin', 'fc1c837c285fce4bd99e05a80abf7477', '1527681600', '1528094012', '132', '1539690168', '127.0.0.1', '1', '1');
  INSERT INTO `manage_admin` VALUES ('1002', 'chaos1217', '86b35201388bce0ba45239632d23891c', '1527822336', '1528335904', '1', '1527822378', '127.0.0.1', '255', '1');
  INSERT INTO `manage_admin` VALUES ('1003', 'kevin', 'e0f9d5eca7c325bada96b7a568d558d1', '1528335922', '1528335922', '0', null, null, '25', '1');
  
  -- ----------------------------
  -- Table structure for manage_admin_auth
  -- ----------------------------
  DROP TABLE IF EXISTS `manage_admin_auth`;
  CREATE TABLE `manage_admin_auth` (
    `auth_id` int(11) NOT NULL,
    `admin_id` int(11) DEFAULT NULL,
    `menu_id` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `time_create` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`auth_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of manage_admin_auth
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for manage_admin_log
  -- ----------------------------
  DROP TABLE IF EXISTS `manage_admin_log`;
  CREATE TABLE `manage_admin_log` (
    `log_id` int(11) NOT NULL AUTO_INCREMENT,
    `id` int(11) NOT NULL COMMENT '帐号ID',
    `login_tm` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '登录时间',
    `login_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '登录IP',
    `is_brand` tinyint(3) NOT NULL DEFAULT '1',
    `fail_msg` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
    `status` int(11) NOT NULL DEFAULT '1',
    PRIMARY KEY (`log_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=10205 DEFAULT CHARSET=latin1;
  
  -- ----------------------------
  -- Records of manage_admin_log
  -- ----------------------------
  INSERT INTO `manage_admin_log` VALUES ('10003', '1001', '1527685727', '127.0.0.1', '0', '账户异常', '1');
  INSERT INTO `manage_admin_log` VALUES ('10004', '1001', '1527685762', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10005', '1001', '1527685802', '127.0.0.1', '0', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10006', '1001', '1527685861', '127.0.0.1', '0', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10007', '1001', '1527685872', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10008', '1001', '1527686105', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10009', '1001', '1527686662', '127.0.0.1', '0', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10010', '1001', '1527686677', '127.0.0.1', '0', '账户异常', '1');
  INSERT INTO `manage_admin_log` VALUES ('10011', '1001', '1527686692', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10012', '1001', '1527686797', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10013', '1001', '1527687985', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10014', '1001', '1527730396', '127.0.0.1', '0', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10015', '1001', '1527730403', '127.0.0.1', '0', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10016', '1001', '1527730446', '127.0.0.1', '0', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10017', '1001', '1527730453', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10018', '1001', '1527754553', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10019', '1001', '1527759411', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10020', '1001', '1527759434', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10021', '1002', '1527820876', '127.0.0.1', '0', null, '-1');
  INSERT INTO `manage_admin_log` VALUES ('10022', '1002', '1527820891', '127.0.0.1', '0', '密码错误', '-1');
  INSERT INTO `manage_admin_log` VALUES ('10023', '1002', '1527820898', '127.0.0.1', '0', null, '-1');
  INSERT INTO `manage_admin_log` VALUES ('10024', '1001', '1527822164', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10025', '1002', '1527822355', '127.0.0.1', '0', '密码错误', '-1');
  INSERT INTO `manage_admin_log` VALUES ('10026', '1001', '1527822366', '127.0.0.1', '0', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10027', '1002', '1527822378', '127.0.0.1', '0', null, '-1');
  INSERT INTO `manage_admin_log` VALUES ('10028', '1001', '1530170818', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10029', '1001', '1530243808', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10030', '1001', '1530497435', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10031', '1001', '1530498094', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10032', '1001', '1530498107', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10033', '1001', '1530498211', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10034', '1001', '1530504865', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10035', '1001', '1530582804', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10036', '1001', '1530598867', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10037', '1001', '1530676527', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10038', '1001', '1530695154', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10039', '1001', '1530703553', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10040', '1001', '1530758210', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10041', '1001', '1530768753', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10042', '1001', '1530842079', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10043', '1001', '1530865172', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10044', '1001', '1530881495', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10045', '1001', '1530881721', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10046', '1001', '1530882523', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10047', '1001', '1530883135', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10048', '1001', '1531101642', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10049', '1001', '1531117437', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10050', '1001', '1531133257', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10051', '1001', '1531137402', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10052', '1001', '1531190620', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10053', '1001', '1531200595', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10054', '1001', '1531212447', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10055', '1001', '1531274572', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10056', '1001', '1531294803', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10057', '1001', '1531294826', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10058', '1001', '1531294861', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10059', '1001', '1531361448', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10060', '1001', '1531446918', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10061', '1001', '1531449990', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10062', '1001', '1531460068', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10063', '1001', '1531993718', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10064', '1001', '1532051316', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10065', '1001', '1532310604', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10066', '1001', '1532346115', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10067', '1001', '1532397191', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10068', '1001', '1532404374', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10069', '1001', '1532432358', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10070', '1001', '1532484591', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10071', '1001', '1532500356', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10072', '1001', '1532500378', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10073', '1001', '1532507454', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10074', '1001', '1532507737', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10075', '1001', '1532570106', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10076', '1001', '1532591518', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10077', '1001', '1532592553', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10078', '1001', '1532682880', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10079', '1001', '1532915830', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10080', '1001', '1532926197', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10081', '1001', '1533002097', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10082', '1001', '1535097020', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10083', '1001', '1535097950', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10084', '1001', '1535174717', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10085', '1001', '1535336813', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10086', '1001', '1535339575', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10087', '1001', '1535364481', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10088', '1001', '1535460970', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10089', '1001', '1535518445', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10090', '1001', '1535613660', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10091', '1001', '1535684438', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10092', '1001', '1535767809', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10093', '1001', '1535861400', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10094', '1001', '1536029268', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10095', '1001', '1536044248', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10096', '1001', '1536214723', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10097', '1001', '1536377850', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10098', '1001', '1536468499', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10099', '1001', '1536558448', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10100', '1001', '1536631065', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10101', '1001', '1536803995', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10102', '1001', '1536891760', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10103', '1001', '1537064534', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10104', '1001', '1537067741', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10105', '1001', '1537067755', '127.0.0.1', '0', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10106', '1001', '1537067863', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10107', '1001', '1537068424', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10108', '1001', '1537068589', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10109', '1001', '1537068853', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10110', '1001', '1537068917', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10111', '1001', '1537068935', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10112', '1001', '1537068951', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10113', '1001', '1537068979', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10114', '1', '1537069372', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10115', '1', '1537069373', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10116', '2', '1537069758', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10117', '1', '1537070163', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10118', '2', '1537070170', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10119', '1', '1537070246', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10120', '1', '1537070465', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10121', '1', '1537070612', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10122', '1', '1537070619', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10123', '2', '1537070626', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10124', '1', '1537078242', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10125', '1', '1537078921', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10126', '1', '1537079622', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10127', '1', '1537085884', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10128', '1001', '1537149595', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10129', '1001', '1537234931', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10130', '1', '1537261461', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10131', '1001', '1537321311', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10132', '1', '1537321410', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10133', '1', '1537337667', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10134', '1001', '1537337693', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10135', '4', '1537344942', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10136', '4', '1537344948', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10137', '4', '1537344964', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10138', '1001', '1537412843', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10139', '4', '1537416201', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10140', '6', '1537418764', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10141', '1001', '1537526138', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10142', '1001', '1537617714', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10143', '6', '1537728230', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10144', '6', '1537840053', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10145', '4', '1537844196', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10146', '1001', '1537848851', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10147', '5', '1537851654', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10148', '5', '1537851672', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10149', '5', '1537857368', '192.168.2.130', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10150', '4', '1537857372', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10151', '5', '1537857385', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10152', '5', '1537868250', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10153', '1001', '1537887173', '192.168.2.130', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10154', '5', '1537926837', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10155', '1001', '1537928628', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10156', '1001', '1537946799', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10157', '1001', '1537948066', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10158', '5', '1537950156', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10159', '5', '1537959496', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10160', '1001', '1537962594', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10161', '1001', '1538013335', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10162', '1001', '1538014830', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10163', '5', '1538020743', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10164', '5', '1538033028', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10165', '5', '1538033050', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10166', '5', '1538035112', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10167', '5', '1538035125', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10168', '1001', '1538035139', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10169', '1001', '1538098635', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10170', '1001', '1538102608', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10171', '1001', '1538113461', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10172', '1001', '1538115270', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10173', '5', '1538116975', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10174', '1001', '1538118521', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10175', '1001', '1538122132', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10176', '5', '1538122202', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10177', '1001', '1538185238', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10178', '5', '1538185311', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10179', '5', '1538186407', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10180', '1001', '1538187789', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10181', '1001', '1538189308', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10182', '1001', '1538193789', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10183', '5', '1538194855', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10184', '1001', '1538200608', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10185', '1001', '1538201638', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10186', '5', '1538202768', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10187', '5', '1538202779', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10188', '5', '1538273735', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10189', '1001', '1538273755', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10190', '1001', '1538296172', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10191', '1001', '1539575655', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10192', '1001', '1539576927', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10193', '5', '1539579406', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10194', '5', '1539580138', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10195', '5', '1539581441', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10196', '5', '1539583062', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10197', '5', '1539595133', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10198', '1001', '1539598901', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10199', '5', '1539599056', '127.0.0.1', '1', '密码错误', '1');
  INSERT INTO `manage_admin_log` VALUES ('10200', '5', '1539599066', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10201', '1001', '1539655041', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10202', '5', '1539655137', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10203', '5', '1539674690', '127.0.0.1', '1', null, '1');
  INSERT INTO `manage_admin_log` VALUES ('10204', '1001', '1539690168', '127.0.0.1', '1', null, '1');
  
  -- ----------------------------
  -- Table structure for manage_brand_menu
  -- ----------------------------
  DROP TABLE IF EXISTS `manage_brand_menu`;
  CREATE TABLE `manage_brand_menu` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `pid` int(11) NOT NULL COMMENT '所属父级',
    `menu_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '菜单名',
    `menu_classname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '菜单icon样式名',
    `menu_relation` varchar(255) DEFAULT NULL,
    `menu_level` int(11) NOT NULL DEFAULT '1',
    `controller` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
    `action` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
    `view` int(11) DEFAULT NULL COMMENT '0不显示, 1显示',
    `is_brand` tinyint(3) NOT NULL DEFAULT '1',
    `sort_id` int(11) DEFAULT NULL COMMENT '排序ID',
    `status` int(11) DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1140 DEFAULT CHARSET=latin1;
  
  -- ----------------------------
  -- Records of manage_brand_menu
  -- ----------------------------
  INSERT INTO `manage_brand_menu` VALUES ('1001', '0', '设置', 'icon-set', '1001', '1', '', '', '1', '0', '1', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1002', '0', '管理员', 'icon-users', '1002', '1', '', '', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1015', '1074', '菜单设置', '', '1074,1015', '2', 'set', 'menu_list', '0', '0', '1', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1016', '1015', '添加菜单', '', '1074,1015,1016', '3', 'set', 'menu_add', '0', '0', '10', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1017', '1015', '编辑菜单', '', '1074,1015,1017', '3', 'set', 'menu_edit', '0', '0', '9', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1018', '1015', '删除菜单', '', '1074,1015,1018', '3', 'set', 'menu_del', '0', '0', '6', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1019', '1002', '管理员列表', '', '1002,1019', '2', 'admin', 'admin_list', '1', '0', '3', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1020', '1019', '添加管理员', '', '1002,1019,1020', '3', 'admin', 'admin_add', '0', '0', '6', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1021', '1019', '编辑管理员', '', '1002,1019,1021', '3', 'admin', 'admin_edit', '0', '0', '5', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1022', '1019', '删除管理员', '', '1002,1019,1022', '3', 'admin', 'admin_del', '0', '0', '4', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1023', '1002', '登录日志', '', '1002,1023', '2', 'admin', 'admin_log', '1', '0', '2', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1024', '0', '测试', '', '1024', '1', 'manage', 'index', '1', '0', '1', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1025', '0', '测试', '', '1025', '1', 'manage', 'index', '1', '0', '1', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1026', '0', '相关栏目', 'icon-about', '1026', '1', '', '', '1', '0', '7', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1027', '1026', '栏目管理', '', '1026,1027', '2', 'about', 'about_list', '1', '0', '12', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1028', '1027', '添加栏目', '', '1026,1027,1028', '3', 'about', 'about_add', '0', '0', '15', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1029', '1027', '编辑栏目', '', '1026,1027,1029', '3', 'about', 'about_edit', '0', '0', '14', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1030', '1027', '删除栏目', '', '1026,1027,1030', '3', 'about', 'about_del', '0', '0', '13', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1031', '1026', '栏目分类管理', '', '1026,1031', '2', 'about', 'cate_list', '1', '0', '8', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1032', '1031', '添加栏目分类', '', '1026,1031,1032', '3', 'about', 'cate_add', '0', '0', '11', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1033', '1031', '编辑栏目分类', '', '1026,1031,1033', '3', 'about', 'cate_edit', '0', '0', '10', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1034', '1031', '删除栏目分类', '', '1026,1031,1034', '3', 'about', 'cate_del', '0', '0', '9', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1035', '0', '文化文章', 'icon-news', '1035', '1', '', '', '1', '0', '4', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1036', '1035', '添加新闻', '', '1035,1036', '2', 'news', 'add', '0', '0', '22', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1037', '1035', '文章管理', '', '1035,1037', '2', 'article', 'list', '1', '0', '22', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1041', '1035', '文章分类管理', '', '1035,1041', '2', 'article', 'cate_list', '1', '0', '18', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1042', '1041', '添加文章分类', '', '1035,1041,1042', '3', 'article', 'cate_add', '0', '0', '21', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1043', '1041', '编辑文章分类', '', '1035,1041,1043', '3', 'article', 'cate_edit', '0', '0', '20', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1044', '1041', '删除文章分类', '', '1035,1041,1044', '3', 'article', 'cate_del', '0', '0', '19', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1045', '0', '画册管理', 'icon-brochure', '1045', '1', '', '', '1', '0', '23', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1046', '1045', '画册管理', '', '1045,1046', '2', 'brochure', 'brochure_list', '1', '0', '28', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1047', '1046', '添加画册', '', '1045,1046,1047', '3', 'brochure', 'brochure_add', '0', '0', '98', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1048', '1046', '编辑画册', '', '1045,1046,1048', '3', 'brochure', 'brochure_edit', '0', '0', '31', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1049', '1046', '删除画册', '', '1045,1046,1049', '3', 'brochure', 'brochure_del', '0', '0', '29', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1050', '1045', '画册分类管理', '', '1045,1050', '2', 'brochure', 'cate_list', '1', '0', '24', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1051', '1050', '添加画册分类', '', '1045,1050,1051', '3', 'brochure', 'cate_add', '0', '0', '27', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1052', '1050', '删除画册分类', '', '1045,1050,1052', '3', 'brochure', 'cate_del', '0', '0', '26', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1053', '1050', '编辑画册分类', '', '1045,1050,1053', '3', 'brochure', 'cate_edit', '0', '0', '25', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1054', '1035', '评论点赞', '', '1035,1054', '2', 'news', 'news_comms', '1', '0', '23', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1055', '1015', '保存排序', '', '1001,1015,1055', '3', 'set', 'menu_order', '1', '0', '5', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1056', '0', '个梵蒂冈', '股份给对方', '1056', '1', '', '', '0', '0', '38', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1057', '1018', '646', '', '1001,1015,1018,1057', '4', '46', '464', '1', '0', '8', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1058', '1018', '测试四级类目', '', '1001,1015,1018,1058', '4', 'fdf', 'yuuytu', '0', '0', '7', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1059', '1047', '发的发的是', '', '1045,1046,1047,1059', '4', 'gfg', 'gfg', '0', '0', '43', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1060', '1049', '估计', '', '1045,1046,1049,1060', '4', 'jgj', 'kj', '0', '0', '30', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1061', '1001', 'cxzc', '', '1001,1061', '2', 'jhk', 'jhk', '0', '0', '2', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1062', '1048', 'fsd', '', '1045,1046,1048,1062', '4', 'kjhk', 'hkj', '0', '0', '32', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1063', '1019', '下下周', '现在', '1002,1019,1063', '3', '现在X', '现在', '0', '0', '0', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1064', '1060', '水电费是否第三方', '', '1045,1046,1049,1060,1064', '5', '辅导费', '辅导费', '0', '0', '0', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1065', '0', '一级分类', '', '1065', '1', '', '', '0', '0', '0', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1066', '1065', '二级分类', '', '1065,1066', '2', '', '', '0', '0', '1', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1067', '1066', '三级分类', '', '1065,1066,1067', '3', '', '', '0', '0', '1', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1068', '1067', '四级分类', '', '1065,1066,1067,1068', '4', '', '', '0', '0', '1', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1069', '1068', '五级分类', '', '1065,1066,1067,1068,1069', '5', '', '', '0', '0', '1', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1070', '1069', '六级分类', '', '1065,1066,1067,1068,1069,1070', '6', '', '', '0', '0', '1', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1071', '1070', '七级分类', '', '1065,1066,1067,1068,1069,1070,1071', '7', '', '', '0', '0', '1', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1072', '1054', '评论详情', '', '1035,1054,1072', '3', 'news', 'comm_detail', '0', '0', '0', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1073', '1054', '点赞详情', '', '1035,1054,1073', '3', 'news', 'vote_detail', '0', '0', '0', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1074', '0', '系统设置', 'icon-set', '1074', '1', '', '', '0', '0', '257', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1075', '1074', '语言设置', '', '1074,1075', '2', 'language', 'set', '1', '0', '2', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1076', '1074', '前台菜单设置', '', '1074,1076', '2', 'frontmenu', 'menu_lists', '1', '0', '0', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1077', '0', '会员管理', 'icon-contact', '1077', '1', '', '', '1', '0', '4', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1078', '1077', '会员信息', '', '1077,1078', '2', '', '', '1', '0', '2555', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1079', '0', '商品管理', 'icon-product', '1079', '1', '', '', '1', '1', '3', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1080', '1079', '商品分类', '', '1079,1080', '2', 'goods', 'cate_list', '1', '0', '254', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1081', '1079', '商品列表', '', '1079,1081', '2', 'goods', 'list', '1', '1', '255', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1082', '1081', '添加商品', '', '1079,1081,1082', '3', 'goods', 'add', '0', '1', '2', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1083', '1081', '编辑商品', '', '1079,1081,1083', '3', 'goods', 'edit', '0', '1', '1', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1084', '0', '订单管理', 'icon-money4', '1084', '1', '', '', '1', '1', '2', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1085', '1084', '订单列表', '', '1084,1085', '2', 'order', 'list', '1', '1', '1', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1086', '1015', '搜索菜单', '', '1074,1015,1086', '3', 'set', 'search_menu', '0', '0', '2555', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1087', '0', '首页管理', 'icon-home', '1087', '1', '', '', '1', '0', '1', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1088', '0', '品牌管理', 'icon-ad', '1088', '1', '', '', '1', '1', '1', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1089', '1087', '轮播图管理', '', '1087,1089', '2', 'banner', 'list', '1', '0', '1', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1090', '1089', '添加轮播图', '', '1087,1089,1090', '3', 'banner', 'add', '0', '0', '1', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1091', '1089', '删除轮播图', '', '1087,1089,1091', '3', 'banner', 'del', '0', '0', '2', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1092', '1089', '编辑轮播图', '', '1087,1089,1092', '3', 'banner', 'edit', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1093', '1037', '添加文章', '', '1035,1037,1093', '3', 'article', 'add', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1094', '1037', '删除文章', '', '1035,1037,1094', '3', 'article', 'del', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1095', '1037', '编辑文章', '', '1035,1037,1095', '3', 'article', 'edit', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1096', '1088', '品牌列表', '', '1088,1096', '2', 'brand', 'list', '1', '1', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1097', '1096', '添加品牌', '', '1088,1096,1097', '3', 'brand', 'add', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1098', '1096', '删除品牌', '', '1088,1096,1098', '3', 'brand', 'del', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1099', '1096', '编辑品牌', '', '1088,1096,1099', '3', 'brand', 'edit', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1100', '1081', '删除商品', '', '1079,1081,1100', '3', 'goods', 'del', '0', '0', '255', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1101', '1078', '添加会员', '', '1077,1078,1101', '3', 'member', 'member_add', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1102', '1078', '删除会员', '', '1077,1078,1102', '3', 'member', 'member_del', '0', '0', '254', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1103', '1135', '编辑会员', '', '1077,1078,1135,1103', '4', 'member', 'member_edit', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1104', '1078', '查看收藏', '', '1077,1078,1104', '3', 'member', 'favorite_ck', '0', '0', '2', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1105', '1078', '商品收藏', '', '1077,1078,1105', '3', 'member', 'goods_favorite', '1', '0', '3', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1106', '1080', '添加商品分类', '', '1079,1080,1106', '3', 'goods', 'cate_add', '0', '1', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1107', '1080', '编辑菜单分类', '', '1079,1080,1107', '3', 'goods', 'cate_edit', '0', '1', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1108', '1080', '删除商品分类', '', '1079,1080,1108', '3', 'goods', 'cate_del', '0', '1', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1109', '1085', '编辑订单', '', '1084,1085,1109', '3', 'order', 'edit', '0', '1', '255', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1110', '1085', '添加订单', '', '1084,1085,1110', '3', 'goods', 'add', '0', '1', '255', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1111', '1085', '删除订单', '', '1084,1085,1111', '3', 'order', 'del', '0', '1', '255', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1112', '1079', '商品属性设置', '', '1079,1112', '2', '', '', '1', '0', '253', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1113', '1081', '商品颜色管理', '', '1079,1081,1113', '3', 'goods_property', 'color_list', '0', '1', '255', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1114', '1113', '添加商品颜色', '', '1079,1081,1113,1114', '4', 'goods_property', 'color_add', '0', '1', '255', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1115', '1113', '编辑商品颜色', '', '1079,1081,1113,1115', '4', 'goods_property', 'color_edit', '0', '1', '255', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1116', '1113', '删除商品颜色', '', '1079,1081,1113,1116', '4', 'goods_property', 'color_del', '0', '1', '255', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1117', '0', '专栏设置', 'icon-set', '1117', '1', '', '', '1', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1118', '1117', '专栏列表', '', '1117,1118', '2', 'activity', 'list', '1', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1119', '1118', '添加专栏', '', '1117,1118,1119', '3', 'activity', 'add', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1120', '1118', '编辑专栏', '', '1117,1118,1120', '3', 'activity', 'edit', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1121', '1118', '删除专栏', '', '1117,1118,1121', '3', 'activity', 'del', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1122', '1087', '活动设置', '', '1087,1122', '2', '', '', '1', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1123', '1122', '新品入驻', '', '1087,1122,1123', '3', 'activity', 'list?type=1', '1', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1124', '1122', '场景搭配', '', '1087,1122,1124', '3', 'activity', 'scene_match', '0', '0', '256', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1125', '1122', '新品入驻', '', '1087,1122,1125', '3', 'activity', 'new_brand_list', '1', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1126', '1125', '添加新品', '', '1087,1122,1125,1126', '4', 'activity', 'new_brand_add', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1127', '1125', '编辑新品', '', '1087,1122,1125,1127', '4', 'activity', 'new_brand_edit', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1128', '1122', '场景入驻', '', '1087,1122,1128', '3', 'activity', 'scene_match_list', '1', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1129', '1124', '添加场景搭配', '', '1087,1122,1124,1129', '4', 'activity', 'scene_match_add', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1130', '1128', '添加场景入驻', '', '1087,1122,1128,1130', '4', 'activity', 'scene_match_add', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1131', '1128', '编辑场景入驻', '', '1087,1122,1128,1131', '4', 'activity', 'scene_match_edit', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1132', '1128', '删除场景入驻', '', '1087,1122,1128,1132', '4', 'activity', 'scene_match_del', '0', '0', '255', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1133', '1078', '订单管理', '', '1077,1078,1133', '3', 'member', 'order_list', '1', '1', '4', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1134', '1078', '品牌收藏', '', '1077,1078,1134', '3', 'member', 'brand_favorite', '1', '1', '2', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1135', '1078', '会员列表', '', '1077,1078,1135', '3', 'member', 'member_list', '1', '1', '1', '-1');
  INSERT INTO `manage_brand_menu` VALUES ('1136', '1088', '品牌设置', '', '1088,1136', '2', 'set', 'brand_info', '1', '1', '1', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1137', '1088', '基础信息', '', '1088,1137', '2', 'set', 'base_info', '1', '1', '2', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1138', '1084', '退货列表', '', '1084,1138', '2', 'order', 'back_list', '1', '1', '255', '1');
  INSERT INTO `manage_brand_menu` VALUES ('1139', '1138', '编辑退货', '', '1084,1138,1139', '3', 'order', 'back_edit', '0', '1', '255', '1');
  
  -- ----------------------------
  -- Table structure for manage_config
  -- ----------------------------
  DROP TABLE IF EXISTS `manage_config`;
  CREATE TABLE `manage_config` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `language_en` text COLLATE utf8_bin,
    `language_cn` text COLLATE utf8_bin,
    `xcx_member_bg` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '小程序个人中心背景图',
    `time_update` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of manage_config
  -- ----------------------------
  INSERT INTO `manage_config` VALUES ('1', 0x65794A745A573531583352706447786C4D534936496D6876625755694C434A745A573531583352706447786C4D694936496D4E686447566E62334A35496977696257567564563930615852735A544D694F694A6A6457783064584A6C496977696257567564563930615852735A5451694F694A7A6147397759324679496977696257567564563930615852735A5455694F694A445958526C49697769614739745A563930615852735A534936496C64706247524464574A7059794973496D68766257566659574E3061585A7064486B78496A6F69626D5633516E4A68626D51694C434A6F6232316C5832466A64476C32615852354D694936496B68766445526C63326C6E62694973496D68766257566659574E3061585A7064486B7A496A6F6955324E6C626D55694C434A6F6232316C5832466A64476C32615852354E434936496B4E3162485231636D55694C434A6F6232316C5832466A64476C32615852354E534936496C4A6C59323974625756755A434973496D4E686447566664476C3062475578496A6F695130465552534973496D4E686447566664476C3062475579496A6F69516E4A68626D51694C434A68636E52705932786C583352706447786C496A6F6951335673496E303D, 0x65794A745A573531583352706447786C4D534936496C78314F546B354E6C78314F5467334E534973496D316C626E566664476C3062475579496A6F69584855314D6A413258485533597A6469496977696257567564563930615852735A544D694F694A63645459314F4464636454557A4D5459694C434A745A573531583352706447786C4E434936496C78314F4751795A4678314E7A49324F5678314F4759324E694973496D316C626E566664476C30624755314A794936496C78314E5449774E6C78314E324D3359694973496D68766257566664476C30624755694F694A6364546B78593256636454646859324A6364545931596A6B694C434A6F6232316C5832466A64476C32615852354D534936496C78314E6A56694D4678314E54526A4D5678314E5445324E5678314F57453359694973496D68766257566659574E3061585A7064486B79496A6F69584855334D47566B584855354E54417758485534596D4A6C58485534596D457849697769614739745A56396859335270646D6C3065544D694F694A63645455334D324663645459324E6D5A63645459304D6D526364546B784E4751694C434A6F6232316C5832466A64476C32615852354E434936496C78314F474A695A5678314F474A684D5678314E6A55344E3178314E544D784E694973496D68766257566659574E3061585A7064486B31496A6F69584855305A544E68584855305A6A5977584855324D324534584855344D7A5577496977696257567564563930615852735A5455694F694A63645455794D445A636454646A4E3249694C434A6A5958526C583352706447786C4D534936496C78314E5449774E6C78314E324D3359694973496D4E686447566664476C3062475579496A6F69584855314E474D78584855334D6A526A4969776959584A3061574E735A563930615852735A534936496C78314E6A55344E3178314E544D784E694A39, '/201809/0928163316.jpg', '1538123597', '1');
  
  -- ----------------------------
  -- Table structure for manage_menu
  -- ----------------------------
  DROP TABLE IF EXISTS `manage_menu`;
  CREATE TABLE `manage_menu` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `pid` int(11) NOT NULL COMMENT '所属父级',
    `menu_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '菜单名',
    `menu_classname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '菜单icon样式名',
    `menu_relation` varchar(255) DEFAULT NULL,
    `menu_level` int(11) NOT NULL DEFAULT '1',
    `controller` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
    `action` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
    `view` int(11) DEFAULT NULL COMMENT '0不显示, 1显示',
    `is_brand` tinyint(3) NOT NULL DEFAULT '1',
    `sort_id` int(11) DEFAULT NULL COMMENT '排序ID',
    `status` int(11) DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1154 DEFAULT CHARSET=latin1;
  
  -- ----------------------------
  -- Records of manage_menu
  -- ----------------------------
  INSERT INTO `manage_menu` VALUES ('1001', '0', '设置', 'icon-set', '1001', '1', '', '', '1', '0', '1', '-1');
  INSERT INTO `manage_menu` VALUES ('1002', '0', '管理员', 'icon-users', '1002', '1', '', '', '1', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1015', '1074', '菜单设置', '', '1074,1015', '2', 'set', 'menu_list', '1', '0', '1', '1');
  INSERT INTO `manage_menu` VALUES ('1016', '1015', '添加菜单', '', '1074,1015,1016', '3', 'set', 'menu_add', '0', '0', '10', '1');
  INSERT INTO `manage_menu` VALUES ('1017', '1015', '编辑菜单', '', '1074,1015,1017', '3', 'set', 'menu_edit', '0', '0', '9', '1');
  INSERT INTO `manage_menu` VALUES ('1018', '1015', '删除菜单', '', '1074,1015,1018', '3', 'set', 'menu_del', '0', '0', '6', '1');
  INSERT INTO `manage_menu` VALUES ('1019', '1002', '管理员列表', '', '1002,1019', '2', 'admin', 'admin_list', '1', '0', '3', '1');
  INSERT INTO `manage_menu` VALUES ('1020', '1019', '添加管理员', '', '1002,1019,1020', '3', 'admin', 'admin_add', '0', '0', '6', '1');
  INSERT INTO `manage_menu` VALUES ('1021', '1019', '编辑管理员', '', '1002,1019,1021', '3', 'admin', 'admin_edit', '0', '0', '5', '1');
  INSERT INTO `manage_menu` VALUES ('1022', '1019', '删除管理员', '', '1002,1019,1022', '3', 'admin', 'admin_del', '0', '0', '4', '1');
  INSERT INTO `manage_menu` VALUES ('1023', '1002', '登录日志', '', '1002,1023', '2', 'admin', 'admin_log', '1', '0', '2', '1');
  INSERT INTO `manage_menu` VALUES ('1024', '0', '测试', '', '1024', '1', 'manage', 'index', '1', '0', '1', '-1');
  INSERT INTO `manage_menu` VALUES ('1025', '0', '测试', '', '1025', '1', 'manage', 'index', '1', '0', '1', '-1');
  INSERT INTO `manage_menu` VALUES ('1026', '0', '相关栏目', 'icon-about', '1026', '1', '', '', '1', '0', '7', '-1');
  INSERT INTO `manage_menu` VALUES ('1027', '1026', '栏目管理', '', '1026,1027', '2', 'about', 'about_list', '1', '0', '12', '-1');
  INSERT INTO `manage_menu` VALUES ('1028', '1027', '添加栏目', '', '1026,1027,1028', '3', 'about', 'about_add', '0', '0', '15', '-1');
  INSERT INTO `manage_menu` VALUES ('1029', '1027', '编辑栏目', '', '1026,1027,1029', '3', 'about', 'about_edit', '0', '0', '14', '-1');
  INSERT INTO `manage_menu` VALUES ('1030', '1027', '删除栏目', '', '1026,1027,1030', '3', 'about', 'about_del', '0', '0', '13', '-1');
  INSERT INTO `manage_menu` VALUES ('1031', '1026', '栏目分类管理', '', '1026,1031', '2', 'about', 'cate_list', '1', '0', '8', '-1');
  INSERT INTO `manage_menu` VALUES ('1032', '1031', '添加栏目分类', '', '1026,1031,1032', '3', 'about', 'cate_add', '0', '0', '11', '-1');
  INSERT INTO `manage_menu` VALUES ('1033', '1031', '编辑栏目分类', '', '1026,1031,1033', '3', 'about', 'cate_edit', '0', '0', '10', '-1');
  INSERT INTO `manage_menu` VALUES ('1034', '1031', '删除栏目分类', '', '1026,1031,1034', '3', 'about', 'cate_del', '0', '0', '9', '-1');
  INSERT INTO `manage_menu` VALUES ('1035', '0', '文化文章', 'icon-news', '1035', '1', '', '', '1', '0', '4', '1');
  INSERT INTO `manage_menu` VALUES ('1036', '1035', '添加新闻', '', '1035,1036', '2', 'news', 'add', '0', '0', '22', '-1');
  INSERT INTO `manage_menu` VALUES ('1037', '1035', '文章管理', '', '1035,1037', '2', 'article', 'list', '1', '0', '22', '1');
  INSERT INTO `manage_menu` VALUES ('1041', '1035', '文章分类管理', '', '1035,1041', '2', 'article', 'cate_list', '1', '0', '18', '1');
  INSERT INTO `manage_menu` VALUES ('1042', '1041', '添加文章分类', '', '1035,1041,1042', '3', 'article', 'cate_add', '0', '0', '21', '1');
  INSERT INTO `manage_menu` VALUES ('1043', '1041', '编辑文章分类', '', '1035,1041,1043', '3', 'article', 'cate_edit', '0', '0', '20', '1');
  INSERT INTO `manage_menu` VALUES ('1044', '1041', '删除文章分类', '', '1035,1041,1044', '3', 'article', 'cate_del', '0', '0', '19', '1');
  INSERT INTO `manage_menu` VALUES ('1045', '0', '画册管理', 'icon-brochure', '1045', '1', '', '', '1', '0', '23', '-1');
  INSERT INTO `manage_menu` VALUES ('1046', '1045', '画册管理', '', '1045,1046', '2', 'brochure', 'brochure_list', '1', '0', '28', '-1');
  INSERT INTO `manage_menu` VALUES ('1047', '1046', '添加画册', '', '1045,1046,1047', '3', 'brochure', 'brochure_add', '0', '0', '98', '-1');
  INSERT INTO `manage_menu` VALUES ('1048', '1046', '编辑画册', '', '1045,1046,1048', '3', 'brochure', 'brochure_edit', '0', '0', '31', '-1');
  INSERT INTO `manage_menu` VALUES ('1049', '1046', '删除画册', '', '1045,1046,1049', '3', 'brochure', 'brochure_del', '0', '0', '29', '-1');
  INSERT INTO `manage_menu` VALUES ('1050', '1045', '画册分类管理', '', '1045,1050', '2', 'brochure', 'cate_list', '1', '0', '24', '-1');
  INSERT INTO `manage_menu` VALUES ('1051', '1050', '添加画册分类', '', '1045,1050,1051', '3', 'brochure', 'cate_add', '0', '0', '27', '-1');
  INSERT INTO `manage_menu` VALUES ('1052', '1050', '删除画册分类', '', '1045,1050,1052', '3', 'brochure', 'cate_del', '0', '0', '26', '-1');
  INSERT INTO `manage_menu` VALUES ('1053', '1050', '编辑画册分类', '', '1045,1050,1053', '3', 'brochure', 'cate_edit', '0', '0', '25', '-1');
  INSERT INTO `manage_menu` VALUES ('1054', '1035', '评论点赞', '', '1035,1054', '2', 'news', 'news_comms', '1', '0', '23', '-1');
  INSERT INTO `manage_menu` VALUES ('1055', '1015', '保存排序', '', '1001,1015,1055', '3', 'set', 'menu_order', '1', '0', '5', '-1');
  INSERT INTO `manage_menu` VALUES ('1056', '0', '个梵蒂冈', '股份给对方', '1056', '1', '', '', '0', '0', '38', '-1');
  INSERT INTO `manage_menu` VALUES ('1057', '1018', '646', '', '1001,1015,1018,1057', '4', '46', '464', '1', '0', '8', '-1');
  INSERT INTO `manage_menu` VALUES ('1058', '1018', '测试四级类目', '', '1001,1015,1018,1058', '4', 'fdf', 'yuuytu', '0', '0', '7', '-1');
  INSERT INTO `manage_menu` VALUES ('1059', '1047', '发的发的是', '', '1045,1046,1047,1059', '4', 'gfg', 'gfg', '0', '0', '43', '-1');
  INSERT INTO `manage_menu` VALUES ('1060', '1049', '估计', '', '1045,1046,1049,1060', '4', 'jgj', 'kj', '0', '0', '30', '-1');
  INSERT INTO `manage_menu` VALUES ('1061', '1001', 'cxzc', '', '1001,1061', '2', 'jhk', 'jhk', '0', '0', '2', '-1');
  INSERT INTO `manage_menu` VALUES ('1062', '1048', 'fsd', '', '1045,1046,1048,1062', '4', 'kjhk', 'hkj', '0', '0', '32', '-1');
  INSERT INTO `manage_menu` VALUES ('1063', '1019', '下下周', '现在', '1002,1019,1063', '3', '现在X', '现在', '0', '0', '0', '-1');
  INSERT INTO `manage_menu` VALUES ('1064', '1060', '水电费是否第三方', '', '1045,1046,1049,1060,1064', '5', '辅导费', '辅导费', '0', '0', '0', '-1');
  INSERT INTO `manage_menu` VALUES ('1065', '0', '一级分类', '', '1065', '1', '', '', '0', '0', '0', '-1');
  INSERT INTO `manage_menu` VALUES ('1066', '1065', '二级分类', '', '1065,1066', '2', '', '', '0', '0', '1', '-1');
  INSERT INTO `manage_menu` VALUES ('1067', '1066', '三级分类', '', '1065,1066,1067', '3', '', '', '0', '0', '1', '-1');
  INSERT INTO `manage_menu` VALUES ('1068', '1067', '四级分类', '', '1065,1066,1067,1068', '4', '', '', '0', '0', '1', '-1');
  INSERT INTO `manage_menu` VALUES ('1069', '1068', '五级分类', '', '1065,1066,1067,1068,1069', '5', '', '', '0', '0', '1', '-1');
  INSERT INTO `manage_menu` VALUES ('1070', '1069', '六级分类', '', '1065,1066,1067,1068,1069,1070', '6', '', '', '0', '0', '1', '-1');
  INSERT INTO `manage_menu` VALUES ('1071', '1070', '七级分类', '', '1065,1066,1067,1068,1069,1070,1071', '7', '', '', '0', '0', '1', '-1');
  INSERT INTO `manage_menu` VALUES ('1072', '1054', '评论详情', '', '1035,1054,1072', '3', 'news', 'comm_detail', '0', '0', '0', '-1');
  INSERT INTO `manage_menu` VALUES ('1073', '1054', '点赞详情', '', '1035,1054,1073', '3', 'news', 'vote_detail', '0', '0', '0', '-1');
  INSERT INTO `manage_menu` VALUES ('1074', '0', '系统设置', 'icon-set', '1074', '1', '', '', '1', '1', '257', '1');
  INSERT INTO `manage_menu` VALUES ('1075', '1074', '语言设置', '', '1074,1075', '2', 'language', 'set', '1', '0', '2', '1');
  INSERT INTO `manage_menu` VALUES ('1076', '1074', '前台菜单设置', '', '1074,1076', '2', 'frontmenu', 'menu_lists', '1', '0', '0', '-1');
  INSERT INTO `manage_menu` VALUES ('1077', '0', '会员管理', 'icon-contact', '1077', '1', '', '', '1', '0', '4', '1');
  INSERT INTO `manage_menu` VALUES ('1078', '1077', '会员信息', '', '1077,1078', '2', '', '', '1', '0', '2555', '1');
  INSERT INTO `manage_menu` VALUES ('1079', '0', '商品管理', 'icon-product', '1079', '1', '', '', '1', '1', '3', '1');
  INSERT INTO `manage_menu` VALUES ('1080', '1079', '商品分类', '', '1079,1080', '2', 'goods', 'cate_list', '1', '0', '254', '1');
  INSERT INTO `manage_menu` VALUES ('1081', '1079', '商品管理', '', '1079,1081', '2', 'goods', 'list', '1', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1082', '1081', '添加商品', '', '1079,1081,1082', '3', 'goods', 'add', '0', '1', '2', '1');
  INSERT INTO `manage_menu` VALUES ('1083', '1081', '编辑商品', '', '1079,1081,1083', '3', 'goods', 'edit', '0', '1', '1', '1');
  INSERT INTO `manage_menu` VALUES ('1084', '0', '订单管理', 'icon-money4', '1084', '1', '', '', '1', '1', '2', '1');
  INSERT INTO `manage_menu` VALUES ('1085', '1084', '订单列表', '', '1084,1085', '2', 'order', 'list', '1', '1', null, '1');
  INSERT INTO `manage_menu` VALUES ('1086', '1015', '搜索菜单', '', '1074,1015,1086', '3', 'set', 'search_menu', '0', '0', '2555', '-1');
  INSERT INTO `manage_menu` VALUES ('1087', '0', '首页管理', 'icon-home', '1087', '1', '', '', '1', '0', '1', '1');
  INSERT INTO `manage_menu` VALUES ('1088', '0', '品牌管理', 'icon-ad', '1088', '1', '', '', '1', '1', '2', '1');
  INSERT INTO `manage_menu` VALUES ('1089', '1087', '轮播图管理', '', '1087,1089', '2', 'banner', 'list', '1', '0', '1', '1');
  INSERT INTO `manage_menu` VALUES ('1090', '1089', '添加轮播图', '', '1087,1089,1090', '3', 'banner', 'add', '0', '0', '1', '1');
  INSERT INTO `manage_menu` VALUES ('1091', '1089', '删除轮播图', '', '1087,1089,1091', '3', 'banner', 'del', '0', '0', '2', '1');
  INSERT INTO `manage_menu` VALUES ('1092', '1089', '编辑轮播图', '', '1087,1089,1092', '3', 'banner', 'edit', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1093', '1037', '添加文章', '', '1035,1037,1093', '3', 'article', 'add', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1094', '1037', '删除文章', '', '1035,1037,1094', '3', 'article', 'del', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1095', '1037', '编辑文章', '', '1035,1037,1095', '3', 'article', 'edit', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1096', '1088', '品牌列表', '', '1088,1096', '2', '', '', '1', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1097', '1138', '添加品牌', '', '1088,1096,1138,1097', '4', 'brand', 'add', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1098', '1138', '删除品牌', '', '1088,1096,1138,1098', '4', 'brand', 'del', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1099', '1138', '编辑品牌', '', '1088,1096,1138,1099', '4', 'brand', 'edit', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1100', '1081', '删除商品', '', '1079,1081,1100', '3', 'goods', 'del', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1101', '1078', '添加会员', '', '1077,1078,1101', '3', 'member', 'member_add', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1102', '1078', '删除会员', '', '1077,1078,1102', '3', 'member', 'member_del', '0', '0', '254', '1');
  INSERT INTO `manage_menu` VALUES ('1103', '1135', '编辑会员', '', '1077,1078,1135,1103', '4', 'member', 'member_edit', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1104', '1078', '查看收藏', '', '1077,1078,1104', '3', 'member', 'favorite_ck', '0', '0', '2', '-1');
  INSERT INTO `manage_menu` VALUES ('1105', '1078', '商品收藏', '', '1077,1078,1105', '3', 'member', 'goods_favorite', '1', '0', '3', '1');
  INSERT INTO `manage_menu` VALUES ('1106', '1080', '添加商品分类', '', '1079,1080,1106', '3', 'goods', 'cate_add', '0', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1107', '1080', '编辑菜单分类', '', '1079,1080,1107', '3', 'goods', 'cate_edit', '0', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1108', '1080', '删除商品分类', '', '1079,1080,1108', '3', 'goods', 'cate_del', '0', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1109', '1085', '编辑订单', '', '1084,1085,1109', '3', 'order', 'edit', '0', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1110', '1085', '添加订单', '', '1084,1085,1110', '3', 'goods', 'add', '0', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1111', '1085', '删除订单', '', '1084,1085,1111', '3', 'order', 'del', '0', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1112', '1079', '商品属性设置', '', '1079,1112', '2', '', '', '1', '0', '253', '-1');
  INSERT INTO `manage_menu` VALUES ('1113', '1081', '商品颜色管理', '', '1079,1081,1113', '3', 'goods_property', 'color_list', '0', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1114', '1113', '添加商品颜色', '', '1079,1081,1113,1114', '4', 'goods_property', 'color_add', '0', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1115', '1113', '编辑商品颜色', '', '1079,1081,1113,1115', '4', 'goods_property', 'color_edit', '0', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1116', '1113', '删除商品颜色', '', '1079,1081,1113,1116', '4', 'goods_property', 'color_del', '0', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1117', '0', '专栏设置', 'icon-set', '1117', '1', '', '', '1', '0', '255', '-1');
  INSERT INTO `manage_menu` VALUES ('1118', '1117', '专栏列表', '', '1117,1118', '2', 'activity', 'list', '1', '0', '255', '-1');
  INSERT INTO `manage_menu` VALUES ('1119', '1118', '添加专栏', '', '1117,1118,1119', '3', 'activity', 'add', '0', '0', '255', '-1');
  INSERT INTO `manage_menu` VALUES ('1120', '1118', '编辑专栏', '', '1117,1118,1120', '3', 'activity', 'edit', '0', '0', '255', '-1');
  INSERT INTO `manage_menu` VALUES ('1121', '1118', '删除专栏', '', '1117,1118,1121', '3', 'activity', 'del', '0', '0', '255', '-1');
  INSERT INTO `manage_menu` VALUES ('1122', '1087', '活动设置', '', '1087,1122', '2', '', '', '1', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1123', '1122', '新品入驻', '', '1087,1122,1123', '3', 'activity', 'list?type=1', '1', '0', '255', '-1');
  INSERT INTO `manage_menu` VALUES ('1124', '1122', '场景搭配', '', '1087,1122,1124', '3', 'activity', 'scene_match', '0', '0', '256', '1');
  INSERT INTO `manage_menu` VALUES ('1125', '1122', '新品入驻', '', '1087,1122,1125', '3', 'activity', 'new_brand_list', '1', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1126', '1125', '添加新品', '', '1087,1122,1125,1126', '4', 'activity', 'new_brand_add', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1127', '1125', '编辑新品', '', '1087,1122,1125,1127', '4', 'activity', 'new_brand_edit', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1128', '1122', '场景搭配', '', '1087,1122,1128', '3', 'activity', 'scene_match_list', '1', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1129', '1124', '添加场景搭配', '', '1087,1122,1128,1129', '4', 'activity', 'scene_match_add', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1130', '1128', '添加场景入驻', '', '1087,1122,1128,1130', '4', 'activity', 'scene_match_add', '0', '0', '255', '-1');
  INSERT INTO `manage_menu` VALUES ('1131', '1128', '编辑场景入驻', '', '1087,1122,1128,1131', '4', 'activity', 'scene_match_edit', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1132', '1128', '删除场景入驻', '', '1087,1122,1128,1132', '4', 'activity', 'scene_match_del', '0', '0', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1133', '1078', '订单管理', '', '1077,1078,1133', '3', 'member', 'order_list', '1', '1', '4', '1');
  INSERT INTO `manage_menu` VALUES ('1134', '1078', '品牌收藏', '', '1077,1078,1134', '3', 'member', 'brand_favorite', '1', '1', '2', '1');
  INSERT INTO `manage_menu` VALUES ('1135', '1078', '会员列表', '', '1077,1078,1135', '3', 'member', 'member_list', '1', '1', '1', '1');
  INSERT INTO `manage_menu` VALUES ('1136', '1015', '品牌商菜单设置', '', '1074,1015,1136', '3', 'set', 'brand_menu', '1', '1', '255', '-1');
  INSERT INTO `manage_menu` VALUES ('1137', '1074', '品牌商菜单设置', '', '1074,1137', '2', 'brandmenu', 'menu_list', '1', '1', '5', '1');
  INSERT INTO `manage_menu` VALUES ('1138', '1096', '品牌详情', '', '1088,1096,1138', '3', 'brand', 'list', '1', '1', '1', '1');
  INSERT INTO `manage_menu` VALUES ('1139', '1096', '订单列表', '', '1088,1096,1139', '3', 'brand', 'order_list', '1', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1140', '1096', '退货列表', '', '1088,1096,1140', '3', 'brand', 'back_list', '1', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1141', '1096', '基础信息设置', '', '1088,1096,1141', '3', 'brand', 'base_info', '1', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1142', '1096', '商品列表', '', '1088,1096,1142', '3', 'brand', 'goods_list', '1', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1143', '1084', '退货列表', '', '1084,1143', '2', 'order', 'back_list', '1', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1144', '1143', '编辑退货信息', '', '1084,1143,1144', '3', 'order', 'back_edit', '0', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1145', '1137', '品牌商菜单添加', '', '1074,1137,1145', '3', 'brandmenu', 'menu_add', '0', '1', '1', '1');
  INSERT INTO `manage_menu` VALUES ('1146', '1137', '品牌商菜单编辑', '', '1074,1137,1146', '3', 'brandmenu', 'menu_edit', '0', '1', '2', '1');
  INSERT INTO `manage_menu` VALUES ('1147', '1137', '品牌商菜单删除', '', '1074,1137,1147', '3', 'brandenu', 'menu_del', '0', '1', '3', '1');
  INSERT INTO `manage_menu` VALUES ('1148', '1074', '衣橱管理', '', '1074,1148', '2', 'wardrobe', 'list', '1', '1', '4', '1');
  INSERT INTO `manage_menu` VALUES ('1149', '1148', '删除衣橱', '', '1074,1148,1149', '3', 'wardrobe', 'del', '0', '1', '1', '1');
  INSERT INTO `manage_menu` VALUES ('1150', '1148', '编辑衣橱', '', '1074,1148,1150', '3', 'wardrobe', 'edit', '0', '1', '255', '1');
  INSERT INTO `manage_menu` VALUES ('1151', '1148', '添加衣橱', '', '1074,1148,1151', '3', 'wardrobe', 'add', '0', '1', '3', '1');
  INSERT INTO `manage_menu` VALUES ('1152', '1074', '内页设置', '', '1074,1152', '2', 'set', 'page', '1', '1', '3', '1');
  INSERT INTO `manage_menu` VALUES ('1153', '1078', '退货管理', '', '1077,1078,1153', '3', 'member', 'back_list', '1', '1', '255', '1');
  
  -- ----------------------------
  -- Table structure for member
  -- ----------------------------
  DROP TABLE IF EXISTS `member`;
  CREATE TABLE `member` (
    `member_id` int(11) NOT NULL AUTO_INCREMENT,
    `mobile` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '手机号',
    `email` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `username` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '会员账号',
    `gender` tinyint(3) NOT NULL DEFAULT '1' COMMENT '1 男 2 女',
    `avatar` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `password` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '会员密码',
    `wechat_openid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `wechat_avatar` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '微信头像地址',
    `wechat_nickname` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '微信昵称',
    `wechat_language` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT 'en 英文 cn 中文',
    `city` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `province` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `country` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `device_reg` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `type_reg` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '注册类型',
    `ip_create` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `ip_reg` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '注册ip',
    `time_reg` int(11) DEFAULT NULL COMMENT '注册时间',
    `ip_bind` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `time_bind` int(11) DEFAULT NULL COMMENT '换绑时间',
    `time_create` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`member_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=130 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of member
  -- ----------------------------
  INSERT INTO `member` VALUES ('111', '18317119662', '364975601@qq.com', '', '1', null, 'e0f9d5eca7c325bada96b7a568d558d1', 'openidopenid', null, 'Smash', null, null, null, null, '4', 'wechat', null, '127.0.0.1', '1537839417', '192.168.2.130', '1537448160', '1537253418', null, '1');
  INSERT INTO `member` VALUES ('129', '13918157859', null, null, '1', '/avatar/20181008100505697.jpeg', null, 'o4LjW5avSau8TK-px4qnd0biEO8Q', 'https://wx.qlogo.cn/mmopen/vi_32/DYAIOgq83eobfn8t4BNhx5MuicTXOp9FOWTSzeHh8yI66ZLddt3AvoWFicnZfeicMkBznGErAn5TF97sCQf0ibtC9w/132', '陈生', null, '松江', '上海', '中国', null, null, '114.95.225.123', '180.175.90.184', '1539067207', null, null, '1538964305', null, '1');
  INSERT INTO `member` VALUES ('113', '16612341234', null, null, '1', '/avatar/20180920184104901.jpeg', null, 'o4LjW5RwZF0_imjZC8Cd9OdTAvw4', 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTIT3b3QFe2QIFNIafV81BwtR9iaEUE1Ig599ic6CfY6ljV4K4bbsAdEUhllEbXAIB6IFR0zEp1KS9ZA/132', '宛超', null, '松江', '上海', '中国', null, null, '127.0.0.1', '127.0.0.1', '1537449091', null, null, '1537440065', null, '1');
  
  -- ----------------------------
  -- Table structure for member_address
  -- ----------------------------
  DROP TABLE IF EXISTS `member_address`;
  CREATE TABLE `member_address` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `member_id` int(11) DEFAULT NULL COMMENT '会员id',
    `name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '联系人姓名',
    `mobile` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '联系人手机',
    `province` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `city` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `area` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `address` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `title` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
    `is_default` tinyint(3) NOT NULL DEFAULT '0',
    `time_create` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of member_address
  -- ----------------------------
  INSERT INTO `member_address` VALUES ('1', '111', '宛', '18726196082', '安徽', '合肥', '庐江', '盛桥', '', '0', '1537427438', '1537612346', '1');
  INSERT INTO `member_address` VALUES ('2', '111', '宛', '18726196082', '安徽', '合肥', '庐江', '盛桥', '', '0', '1537427438', '1537612431', '1');
  INSERT INTO `member_address` VALUES ('3', '111', '宛', '18726196082', '安徽', '合肥', '庐江', '盛桥', '', '0', '1537605822', '1538216858', '1');
  INSERT INTO `member_address` VALUES ('4', '111', '宛', '18726196082', '安徽', '合肥', '庐江', '盛桥', '', '0', '1537605932', '1537612325', '1');
  INSERT INTO `member_address` VALUES ('5', '111', '宛', '18726196082', '安徽', '合肥', '庐江', '盛桥', null, '0', '1537605939', '1537605939', '1');
  INSERT INTO `member_address` VALUES ('14', '111', '宛', '18726196082', '安徽', '合肥', '庐江', '盛桥', 'gjfh', '0', '1537612635', '1537612635', '1');
  INSERT INTO `member_address` VALUES ('19', '112', '陈生', '13918157859', '上海市', '上海市', '松江区', '高技路655号3号楼', '公司', '0', '1537613805', '1537614244', '1');
  INSERT INTO `member_address` VALUES ('20', '112', '陈', '13888888888', '北京市', '北京市', '东城区', '长安街1号', '家', '0', '1537614087', '1537614181', '1');
  INSERT INTO `member_address` VALUES ('21', '113', '宛先生', '18726196082', '上海市', '上海市', '松江区', '洞泾镇', '公司', '1', '1537618273', '1537883269', '1');
  
  -- ----------------------------
  -- Table structure for member_favorite
  -- ----------------------------
  DROP TABLE IF EXISTS `member_favorite`;
  CREATE TABLE `member_favorite` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `member_id` int(11) DEFAULT NULL,
    `is_favorite` tinyint(3) NOT NULL DEFAULT '1' COMMENT '1 收藏 2 取消收藏',
    `type` int(11) DEFAULT NULL COMMENT '1 商品 2 品牌',
    `type_id` int(11) DEFAULT NULL COMMENT '商品或品牌编号',
    `ip` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `time_create` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of member_favorite
  -- ----------------------------
  INSERT INTO `member_favorite` VALUES ('3', '111', '1', '2', '4', '127.0.0.1', '1537493421', '1537703219', '-1');
  INSERT INTO `member_favorite` VALUES ('4', '111', '1', '2', '4', '127.0.0.1', '1537493455', '1537493580', '-1');
  INSERT INTO `member_favorite` VALUES ('5', '111', '1', '1', '12', '127.0.0.1', '1537501310', '1537501630', '-1');
  INSERT INTO `member_favorite` VALUES ('6', '111', '1', '1', '13', '127.0.0.1', '1537501638', '1537501638', '1');
  INSERT INTO `member_favorite` VALUES ('7', '111', '1', '1', '12', '127.0.0.1', '1537501651', '1537501651', '1');
  INSERT INTO `member_favorite` VALUES ('8', '111', '1', '1', '15', '127.0.0.1', '1537501664', '1537501664', '1');
  INSERT INTO `member_favorite` VALUES ('9', '111', '1', '2', '5', '127.0.0.1', '1537502340', '1537502374', '-1');
  INSERT INTO `member_favorite` VALUES ('10', '111', '1', '2', '5', '127.0.0.1', '1537502587', '1537502588', '-1');
  INSERT INTO `member_favorite` VALUES ('53', '112', '1', '2', '6', '192.168.2.130', '1537707059', '1537707072', '-1');
  INSERT INTO `member_favorite` VALUES ('12', '111', '1', '2', '6', '127.0.0.1', '1537502625', '1537502625', '1');
  INSERT INTO `member_favorite` VALUES ('13', '112', '1', '1', '13', '192.168.2.130', '1537518187', '1537518198', '-1');
  INSERT INTO `member_favorite` VALUES ('14', '112', '1', '1', '14', '192.168.2.130', '1537518229', '1537518230', '-1');
  INSERT INTO `member_favorite` VALUES ('15', '112', '1', '1', '14', '192.168.2.130', '1537518244', '1537518261', '-1');
  INSERT INTO `member_favorite` VALUES ('16', '112', '1', '1', '13', '192.168.2.130', '1537518341', '1537518360', '-1');
  INSERT INTO `member_favorite` VALUES ('17', '112', '1', '1', '14', '192.168.2.130', '1537518388', '1537518881', '-1');
  INSERT INTO `member_favorite` VALUES ('18', '112', '1', '1', '13', '192.168.2.130', '1537518861', '1537518876', '-1');
  INSERT INTO `member_favorite` VALUES ('19', '112', '1', '1', '13', '192.168.2.130', '1537518880', '1537519195', '-1');
  INSERT INTO `member_favorite` VALUES ('20', '112', '1', '1', '14', '192.168.2.130', '1537518884', '1537519305', '-1');
  INSERT INTO `member_favorite` VALUES ('21', '112', '1', '1', '16', '192.168.2.130', '1537518887', '1537519306', '-1');
  INSERT INTO `member_favorite` VALUES ('22', '112', '1', '1', '15', '192.168.2.130', '1537518956', '1537519307', '-1');
  INSERT INTO `member_favorite` VALUES ('23', '112', '1', '1', '13', '192.168.2.130', '1537519199', '1537519308', '-1');
  INSERT INTO `member_favorite` VALUES ('24', '112', '1', '1', '14', '192.168.2.130', '1537519315', '1537519323', '-1');
  INSERT INTO `member_favorite` VALUES ('25', '112', '1', '1', '13', '192.168.2.130', '1537519322', '1537525616', '-1');
  INSERT INTO `member_favorite` VALUES ('26', '112', '1', '1', '14', '192.168.2.130', '1537522240', '1537522258', '-1');
  INSERT INTO `member_favorite` VALUES ('27', '112', '1', '1', '14', '192.168.2.130', '1537522262', '1537522267', '-1');
  INSERT INTO `member_favorite` VALUES ('28', '112', '1', '1', '14', '192.168.2.130', '1537522269', '1537522275', '-1');
  INSERT INTO `member_favorite` VALUES ('29', '112', '1', '1', '14', '192.168.2.130', '1537522277', '1537522280', '-1');
  INSERT INTO `member_favorite` VALUES ('30', '112', '1', '1', '14', '192.168.2.130', '1537522283', '1537522345', '-1');
  INSERT INTO `member_favorite` VALUES ('31', '112', '1', '1', '14', '192.168.2.130', '1537522351', '1537522355', '-1');
  INSERT INTO `member_favorite` VALUES ('32', '112', '1', '1', '14', '192.168.2.130', '1537522360', '1537707045', '-1');
  INSERT INTO `member_favorite` VALUES ('33', '112', '1', '1', '13', '192.168.2.130', '1537526091', '1537526091', '1');
  INSERT INTO `member_favorite` VALUES ('34', '112', '1', '1', '15', '192.168.2.130', '1537583169', '1537706337', '-1');
  INSERT INTO `member_favorite` VALUES ('35', '112', '1', '1', '16', '192.168.2.130', '1537583174', '1537583177', '-1');
  INSERT INTO `member_favorite` VALUES ('36', '112', '1', '1', '12', '192.168.2.130', '1537676384', '1537676424', '-1');
  INSERT INTO `member_favorite` VALUES ('37', '112', '1', '1', '16', '192.168.2.130', '1537676410', '1537706299', '-1');
  INSERT INTO `member_favorite` VALUES ('38', '112', '1', '2', '5', '192.168.2.130', '1537702971', '1537702984', '-1');
  INSERT INTO `member_favorite` VALUES ('39', '112', '1', '2', '5', '192.168.2.130', '1537702988', '1537703358', '-1');
  INSERT INTO `member_favorite` VALUES ('40', '111', '1', '2', '7', '127.0.0.1', '1537703236', '1537703236', '1');
  INSERT INTO `member_favorite` VALUES ('41', '112', '1', '1', '12', '192.168.2.130', '1537703240', '1537703253', '-1');
  INSERT INTO `member_favorite` VALUES ('42', '112', '1', '2', '5', '192.168.2.130', '1537703360', '1537703362', '-1');
  INSERT INTO `member_favorite` VALUES ('43', '112', '1', '2', '5', '192.168.2.130', '1537703364', '1537703416', '-1');
  INSERT INTO `member_favorite` VALUES ('44', '112', '1', '1', '12', '192.168.2.130', '1537703369', '1537703370', '-1');
  INSERT INTO `member_favorite` VALUES ('45', '112', '1', '1', '25', '192.168.2.130', '1537703373', '1537703374', '-1');
  INSERT INTO `member_favorite` VALUES ('46', '112', '1', '1', '20', '192.168.2.130', '1537703375', '1537703376', '-1');
  INSERT INTO `member_favorite` VALUES ('47', '112', '1', '1', '12', '192.168.2.130', '1537703377', '1537703378', '-1');
  INSERT INTO `member_favorite` VALUES ('48', '112', '1', '1', '12', '192.168.2.130', '1537703380', '1537703384', '-1');
  INSERT INTO `member_favorite` VALUES ('49', '112', '1', '1', '12', '192.168.2.130', '1537703385', '1537706289', '-1');
  INSERT INTO `member_favorite` VALUES ('50', '112', '1', '2', '5', '192.168.2.130', '1537703420', '1537703427', '-1');
  INSERT INTO `member_favorite` VALUES ('51', '112', '1', '2', '5', '192.168.2.130', '1537703430', '1537707013', '-1');
  INSERT INTO `member_favorite` VALUES ('52', '112', '1', '1', '17', '192.168.2.130', '1537704280', '1537706322', '-1');
  INSERT INTO `member_favorite` VALUES ('54', '112', '1', '2', '5', '192.168.2.130', '1537707962', '1537708125', '-1');
  INSERT INTO `member_favorite` VALUES ('55', '113', '1', '1', '17', '127.0.0.1', '1537723322', '1537723322', '1');
  INSERT INTO `member_favorite` VALUES ('56', '112', '1', '1', '14', '192.168.2.130', '1537885243', '1537885266', '-1');
  INSERT INTO `member_favorite` VALUES ('57', '112', '1', '1', '18', '192.168.2.130', '1537885267', '1537885267', '1');
  INSERT INTO `member_favorite` VALUES ('58', '112', '1', '1', '14', '192.168.2.130', '1537885270', '1537885272', '-1');
  INSERT INTO `member_favorite` VALUES ('59', '112', '1', '1', '23', '192.168.2.130', '1537885275', '1537885275', '1');
  INSERT INTO `member_favorite` VALUES ('60', '112', '1', '1', '22', '192.168.2.130', '1537885276', '1537885276', '1');
  INSERT INTO `member_favorite` VALUES ('61', '112', '1', '1', '14', '192.168.2.130', '1537885278', '1537885278', '1');
  
  -- ----------------------------
  -- Table structure for member_wardrobe
  -- ----------------------------
  DROP TABLE IF EXISTS `member_wardrobe`;
  CREATE TABLE `member_wardrobe` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `wardrobe_title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `wardrobe_title_en` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `cids` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `sort_id` int(11) DEFAULT '255',
    `time_create` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of member_wardrobe
  -- ----------------------------
  INSERT INTO `member_wardrobe` VALUES ('1', '上装', 'cloth', '1007', '255', '1537884253', '1537884253', '1');
  INSERT INTO `member_wardrobe` VALUES ('2', '裤/裙装', 'paints', '<1024>', '255', '1537884253', '1538102170', '1');
  INSERT INTO `member_wardrobe` VALUES ('3', '鞋履', 'shoes', '1009', '255', '1537884253', '1537884253', '1');
  INSERT INTO `member_wardrobe` VALUES ('4', '上衣11', 'cloth111', '<1007>,<1019>,<1020>,<1021>,<1022>,<1023>,<1024>', '1', '1538100996', '1538102143', '-1');
  
  -- ----------------------------
  -- Table structure for message_code
  -- ----------------------------
  DROP TABLE IF EXISTS `message_code`;
  CREATE TABLE `message_code` (
    `code_id` int(10) NOT NULL AUTO_INCREMENT,
    `account` varchar(200) NOT NULL,
    `code` int(10) DEFAULT NULL,
    `type` int(3) DEFAULT NULL,
    `time_create` varchar(11) NOT NULL,
    `status` int(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`code_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=166 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of message_code
  -- ----------------------------
  INSERT INTO `message_code` VALUES ('149', '18317119662', '526814', null, '1537440795', '1');
  INSERT INTO `message_code` VALUES ('150', '18317119662', '179548', null, '1537440814', '1');
  INSERT INTO `message_code` VALUES ('151', '18317119662', '584732', null, '1537441080', '1');
  INSERT INTO `message_code` VALUES ('152', '18317119662', '234856', null, '1537443909', '1');
  INSERT INTO `message_code` VALUES ('153', '16612341234', '853492', null, '1537447476', '1');
  INSERT INTO `message_code` VALUES ('154', '13333333333', '537892', null, '1537447925', '1');
  INSERT INTO `message_code` VALUES ('155', '13333333333', '423986', null, '1537448142', '1');
  INSERT INTO `message_code` VALUES ('156', '18317119662', '936178', null, '1537448414', '1');
  INSERT INTO `message_code` VALUES ('157', '18726196082', '684951', null, '1537448890', '1');
  INSERT INTO `message_code` VALUES ('158', '18726196082', '745318', null, '1537448954', '1');
  INSERT INTO `message_code` VALUES ('159', '18317119662', '763892', null, '1537449016', '1');
  INSERT INTO `message_code` VALUES ('160', '16612341234', '236857', null, '1537449064', '1');
  INSERT INTO `message_code` VALUES ('161', '13333333333', '739516', null, '1537449311', '1');
  INSERT INTO `message_code` VALUES ('162', '13222222222', '632971', null, '1537449785', '1');
  INSERT INTO `message_code` VALUES ('163', '13333333333', '387495', null, '1537450058', '1');
  INSERT INTO `message_code` VALUES ('164', '13555555555', '246578', null, '1537450088', '1');
  INSERT INTO `message_code` VALUES ('165', '18317119662', '572964', null, '1537839331', '1');
  
  -- ----------------------------
  -- Table structure for message_log
  -- ----------------------------
  DROP TABLE IF EXISTS `message_log`;
  CREATE TABLE `message_log` (
    `message_log_id` int(11) NOT NULL AUTO_INCREMENT,
    `wechat_openid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `mobile` varchar(20) COLLATE utf8_bin DEFAULT NULL,
    `content` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `message_type` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '短信类型1 发送验证码 2 通知',
    `send_type` int(3) NOT NULL DEFAULT '1' COMMENT '1 短信 2 微信',
    `time_create` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL,
    PRIMARY KEY (`message_log_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of message_log
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for orders
  -- ----------------------------
  DROP TABLE IF EXISTS `orders`;
  CREATE TABLE `orders` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `member_id` int(11) DEFAULT NULL,
    `main_order_no` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `order_no` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '订单编号',
    `sort_id` int(11) NOT NULL DEFAULT '1' COMMENT '子订单排序编号',
    `brand_id` int(11) DEFAULT NULL,
    `name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '联系人',
    `mobile` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '联系人手机',
    `province` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `city` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `area` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `address` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '联系地址',
    `goods_id` int(11) DEFAULT NULL COMMENT '商品编号',
    `goods_category_relation` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '商品分类信息',
    `goods_per_price` decimal(10,2) DEFAULT '0.00' COMMENT '商品单价',
    `goods_count` int(11) DEFAULT NULL COMMENT '商品总数',
    `goods_size_id` int(11) DEFAULT NULL,
    `goods_color_id` int(11) DEFAULT NULL,
    `express_free` decimal(10,2) DEFAULT NULL COMMENT '邮费',
    `express_no` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '物流单号',
    `express_company` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '物流类型',
    `express_info` text COLLATE utf8_bin COMMENT '物流信息',
    `row_goods_price` decimal(10,2) DEFAULT NULL,
    `row_goods_express_free` decimal(10,2) DEFAULT NULL,
    `row_total_price` decimal(10,2) DEFAULT NULL COMMENT '商品小计',
    `brand_goods_price` decimal(10,2) DEFAULT NULL,
    `brand_goods_express_free` decimal(10,2) DEFAULT NULL,
    `brand_total_price` decimal(10,2) DEFAULT NULL,
    `total_goods_price` decimal(10,2) DEFAULT NULL,
    `total_express_free` decimal(10,2) DEFAULT NULL,
    `total_price` decimal(10,2) DEFAULT NULL,
    `order_status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '订单状态 1 已取消 2 待付款 3 待发货 4 待收货 5 已收货 6 退货中 7 已退货',
    `pay_price` decimal(10,2) DEFAULT NULL,
    `pay_type` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '付款类型',
    `wechat_trade_id` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '微信交易号',
    `order_ip` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `back_status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '1 未退货 2 申请退货 3 退货完毕',
    `back_address` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `back_reason` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `back_express_no` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `back_express_company` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `back_express_info` text COLLATE utf8_bin,
    `time_pay` int(11) DEFAULT NULL COMMENT '付款时间',
    `time_send` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '发货时间',
    `time_receive` int(11) DEFAULT NULL COMMENT '确认收货时间',
    `time_cancel` int(11) DEFAULT NULL COMMENT '取消时间',
    `cancel_type` int(3) NOT NULL DEFAULT '0' COMMENT '取消类型 0 未取消 1 用户取消 2 自动取消',
    `time_create` int(11) DEFAULT NULL COMMENT '下单时间',
    `time_update` int(11) DEFAULT NULL,
    `time_back_apply` int(11) DEFAULT NULL,
    `time_back_confirm` int(11) DEFAULT NULL,
    `status` int(3) NOT NULL DEFAULT '2' COMMENT '订单状态 1 已取消 2 待付款 3 待发货 4 待收货 5 已收货 6 已退货',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=194 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of orders
  -- ----------------------------
  INSERT INTO `orders` VALUES ('140', '111', '180923162352111', '1809231623521111', '1', '5', '宛', '18317119662', '安徽', '合肥', '庐江', '盛桥', '25', '1007,1010', '200.00', '2', '1001', '47', '0.00', '888888', 'YTO', null, '400.00', '0.00', '400.00', '400.00', '0.00', '400.00', '400.00', '0.00', '400.00', '1', null, 'wechat', 'wechat_trade_id', '127.0.0.1', '2', null, '尺寸不对', '1111', 'ZTO', null, '1537841150', '1537861557', '1537841150', '1539660279', '2', '1537691032', '1539660279', '1537711189', '1537865797', '1');
  INSERT INTO `orders` VALUES ('143', '112', '180923211732112', '1809232117321121', '1', '5', '陈生', '13918157859', '上海市', '上海市', '松江区', '高技路655号3号楼', '12', '1007,1015', '2800.00', '1', '1001', '42', '0.00', '266689333332', 'ZTO', null, '2800.00', '0.00', '2800.00', '2800.00', '0.00', '2800.00', '2800.00', '0.00', '2800.00', '5', null, 'wechat', 'wechat_trade_id', '127.0.0.1', '1', null, '款式发错', '266939303241', 'ZTO', null, '1537844749', '1537844749', '1537844749', null, '0', '1537708652', '1537723736', '1537723736', '1537844749', '2');
  INSERT INTO `orders` VALUES ('144', '111', '180924012403113', '1809240124031131', '1', '4', '宛先生', '18726196082', '上海市', '上海市', '黄浦区', '洞泾镇', '17', '1007,1008', '155.53', '4', '1005', '46', '0.25', null, 'YTO', null, '622.12', '1.00', '623.12', '622.12', '1.00', '623.12', '622.12', '1.00', '623.12', '3', null, 'wechat', 'wechat_trade_id', '127.0.0.1', '1', null, null, null, 'ZTO', null, null, null, null, null, '0', '1537723443', '1537723443', null, null, '2');
  INSERT INTO `orders` VALUES ('145', '111', '180924012614113', '1809240126141131', '1', '7', '宛先生', '18726196082', '上海市', '上海市', '黄浦区', '洞泾镇', '23', '1007,1009', '205.00', '2', '1002', '45', '0.00', null, 'ZTO', null, '410.00', '0.00', '410.00', '410.00', '0.00', '410.00', '410.00', '0.00', '410.00', '1', null, 'wechat', 'wechat_trade_id', '127.0.0.1', '1', null, null, null, 'ZTO', null, null, null, null, '1539654006', '2', '1537723574', '1539654006', null, null, '2');
  INSERT INTO `orders` VALUES ('146', '113', '180926150538113', '1809261505381131', '1', '6', '宛先生', '18726196082', '上海市', '上海市', '松江区', '洞泾镇', '14', null, '200.00', '1', '1002', '45', '0.00', null, null, null, '200.00', '0.00', '200.00', '200.00', '0.00', '200.00', '200.00', '0.00', '200.00', '1', null, null, null, null, '1', null, null, null, null, null, null, null, null, '1539654006', '2', '1537945538', '1539654006', null, null, '2');
  INSERT INTO `orders` VALUES ('147', '112', '180926223522112', '1809262235221121', '1', '7', '陈', '13888888888', '北京市', '北京市', '东城区', '长安街1号', '15', null, '200.00', '1', '1002', '45', '0.00', null, null, null, '200.00', '0.00', '200.00', '200.00', '0.00', '200.00', '200.00', '0.00', '200.00', '1', null, null, null, null, '1', null, null, null, null, null, null, null, null, '1539654006', '2', '1537972522', '1539654006', null, null, '2');
  INSERT INTO `orders` VALUES ('148', '112', '180927102043112', '1809271020431121', '1', '5', '陈', '13888888888', '北京市', '北京市', '东城区', '长安街1号', '12', null, '2800.00', '1', '1003', '59', '0.00', null, null, null, '2800.00', '0.00', '2800.00', '2800.00', '0.00', '2800.00', '2800.00', '0.00', '2800.00', '1', null, null, null, null, '1', null, null, null, null, null, null, null, null, '1539654006', '2', '1537973214', '1539654006', null, null, '2');
  INSERT INTO `orders` VALUES ('149', '112', '180927102043112', '1809271020431121', '1', '5', '陈', '13888888888', '北京市', '北京市', '东城区', '长安街1号', '15', null, '2800.00', '2', '1002', '63', '0.00', null, null, null, '5600.00', '0.00', '5600.00', '5600.00', '0.00', '5600.00', '5600.00', '0.00', '5600.00', '1', null, null, null, null, '1', null, null, null, null, null, null, null, null, '1539654006', '2', '1538014843', '1539654006', null, null, '2');
  INSERT INTO `orders` VALUES ('193', '129', '181015173042129', '1810151730421291', '1', '1000000', '陈生', '13918157859', '上海市', '上海市', '松江区', '高技路655号', '29', '1007,1010', '399.00', '1', '1003', '56', '0.00', '123456789', 'SFEXPRESS', null, '399.00', '0.00', '399.00', '399.00', '0.00', '399.00', '399.00', '0.00', '399.00', '5', '0.01', 'wechat', '4200000197201810156365199819', '180.175.149.181', '1', null, null, null, null, null, '1539595846', '1539595958', '1539595980', null, '0', '1539595842', '1539595958', null, null, '2');
  
  -- ----------------------------
  -- Table structure for order_back_log
  -- ----------------------------
  DROP TABLE IF EXISTS `order_back_log`;
  CREATE TABLE `order_back_log` (
    `log_id` int(11) NOT NULL,
    `member_id` int(11) DEFAULT NULL,
    `order_id` int(11) DEFAULT NULL,
    `goods_id` int(11) DEFAULT NULL,
    `size_id` int(11) DEFAULT NULL,
    `size_title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `color_id` int(11) DEFAULT NULL,
    `color_title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `time_create` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `status` int(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`log_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of order_back_log
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for order_back_reason
  -- ----------------------------
  DROP TABLE IF EXISTS `order_back_reason`;
  CREATE TABLE `order_back_reason` (
    `back_reason_id` int(11) NOT NULL,
    `back_reason_desc` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `sort_id` int(11) NOT NULL DEFAULT '255',
    `time_ create` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `status` int(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`back_reason_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of order_back_reason
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for order_remind
  -- ----------------------------
  DROP TABLE IF EXISTS `order_remind`;
  CREATE TABLE `order_remind` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `member_id` int(11) DEFAULT NULL,
    `brand_id` int(11) DEFAULT NULL,
    `order_no` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `content` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `time_send` int(11) DEFAULT NULL,
    `time_create` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of order_remind
  -- ----------------------------
  INSERT INTO `order_remind` VALUES ('6', '111', '5', '1809231623521111', null, '1270', '1537703894', '1537703894', '1');
  INSERT INTO `order_remind` VALUES ('7', '111', '5', '1809231623521111', null, '1270', '1537703920', '1537703920', '1');
  INSERT INTO `order_remind` VALUES ('8', '111', '5', '1809231623521111', null, '1270', '1537703921', '1537703921', '1');
  INSERT INTO `order_remind` VALUES ('9', '111', '5', '1809231623521111', null, '1270', '1537703922', '1537703922', '1');
  INSERT INTO `order_remind` VALUES ('10', '112', '5', '1809232117321121', null, '192168', '1537710574', '1537710574', '1');
  
  -- ----------------------------
  -- Table structure for shopcar
  -- ----------------------------
  DROP TABLE IF EXISTS `shopcar`;
  CREATE TABLE `shopcar` (
    `shopcar_id` int(11) NOT NULL AUTO_INCREMENT,
    `member_id` int(11) DEFAULT NULL,
    `brand_id` int(11) DEFAULT NULL,
    `goods_id` int(11) DEFAULT NULL,
    `count` int(11) DEFAULT NULL COMMENT '商品个数',
    `size_id` int(11) DEFAULT NULL,
    `color_id` int(11) DEFAULT NULL,
    `time_create` int(11) DEFAULT NULL,
    `time_update` int(11) DEFAULT NULL,
    `status` tinyint(3) NOT NULL DEFAULT '1',
    PRIMARY KEY (`shopcar_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- ----------------------------
  -- Records of shopcar
  -- ----------------------------
  INSERT INTO `shopcar` VALUES ('53', '112', '5', '12', '1', '1002', '42', '1537843356', '1537843356', '-1');
  INSERT INTO `shopcar` VALUES ('54', '112', '6', '14', '2', '1002', '45', '1537843439', '1537843439', '-1');
  INSERT INTO `shopcar` VALUES ('44', '111', '5', '25', '2', '1001', '47', '1537690980', '1537690980', '-2');
  INSERT INTO `shopcar` VALUES ('49', '112', '5', '12', '1', '1001', '42', '1537708641', '1537708641', '-2');
  INSERT INTO `shopcar` VALUES ('50', '113', '4', '17', '4', '1005', '46', '1537723335', '1537723335', '-2');
  INSERT INTO `shopcar` VALUES ('51', '113', '7', '23', '2', '1002', '45', '1537723562', '1537723564', '-2');
  INSERT INTO `shopcar` VALUES ('52', '112', '5', '12', '1', '1002', '42', '1537840873', '1537840890', '-1');
  INSERT INTO `shopcar` VALUES ('55', '112', '7', '19', '5', '1003', '45', '1537843698', '1537843698', '-1');
  INSERT INTO `shopcar` VALUES ('57', '113', '6', '14', '1', '1002', '45', '1537945518', '1537945518', '-2');
  INSERT INTO `shopcar` VALUES ('58', '112', '5', '12', '1', '1003', '59', '1537972653', '1537972653', '-2');
  INSERT INTO `shopcar` VALUES ('59', '112', '5', '12', '2', '1002', '63', '1537973586', '1537973586', '-2');
  INSERT INTO `shopcar` VALUES ('56', '112', '7', '15', '1', '1002', '45', '1537941213', '1537941213', '-2');
  