text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : 123.57.93.65
  Source Server Version : 50727
  Source Host           : 123.57.93.65:3306
  Source Database       : miaosha
  
  Target Server Type    : MYSQL
  Target Server Version : 50727
  File Encoding         : 65001
  
  Date: 2020-04-09 19:06:50
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for `order_info`
  -- ----------------------------
  DROP TABLE IF EXISTS `order_info`;
  CREATE TABLE `order_info` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
    `goods_id` bigint(20) DEFAULT NULL COMMENT '商品ID',
    `delivery_addr_id` bigint(20) DEFAULT NULL COMMENT '收获地址ID',
    `goods_name` varchar(16) DEFAULT NULL COMMENT '冗余过来的商品名称',
    `goods_count` int(11) DEFAULT '0' COMMENT '商品数量',
    `goods_price` decimal(10,2) DEFAULT '0.00' COMMENT '商品单价',
    `order_channel` tinyint(4) DEFAULT '0' COMMENT '1pc，2android，3ios',
    `status` tinyint(4) DEFAULT '0' COMMENT '订单状态，0新建未支付，1已支付，2已发货，3已收货，4已退款，5已完成',
    `create_date` datetime DEFAULT NULL COMMENT '订单的创建时间',
    `pay_date` datetime DEFAULT NULL COMMENT '支付时间',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1574 DEFAULT CHARSET=utf8mb4;
  
  -- ----------------------------
  -- Records of order_info
  -- ----------------------------
  INSERT INTO `order_info` VALUES ('1561', '18912341234', '1', null, 'iphoneX', '1', '0.01', '1', '0', '2017-12-14 22:49:10', null);
  INSERT INTO `order_info` VALUES ('1562', '18912341234', '2', null, '华为Meta9', '1', '0.01', '1', '0', '2017-12-14 22:55:42', null);
  INSERT INTO `order_info` VALUES ('1563', '18912341234', '4', null, '小米6', '1', '0.01', '1', '0', '2017-12-16 16:19:23', null);
  INSERT INTO `order_info` VALUES ('1564', '18912341234', '3', null, 'iphone8', '1', '0.01', '1', '0', '2017-12-16 16:35:20', null);
  