tutuxiang/setup/db/20190516/update.sql

-- web用户订单
alter table user_order add client_order_id int(11) default null comment '客户端订单';
alter table user_order add album_quantity int(11) default 0 comment '相册数量';
alter table user_order add album_status int(4) DEFAULT 0 COMMENT '相册状态';
alter table user_order add client_flag char(1) DEFAULT 'N' COMMENT '客户端标识';
alter table user_order add jie_suan char(1) DEFAULT null COMMENT '结算标识';
ALTER TABLE user_order ADD COLUMN album_confirm_time datetime DEFAULT NULL COMMENT '相册确认时间';

-- web订单图片
alter table order_image add client_order_id int(11) default null comment '客户端订单';
alter table order_image add client_flag char(1) DEFAULT 'N' COMMENT '客户端标识';
alter table order_image add client_order_image_id int(11) DEFAULT null COMMENT '客户端订单图片ID';


-- web 店铺信息
ALTER TABLE store_info ADD album_price INT (11) DEFAULT 10 COMMENT '相册单价';

ALTER TABLE store_info ADD rate_flag CHAR (1) DEFAULT 'N' COMMENT '比率标识';

ALTER TABLE store_info ADD order_rate INT (11) DEFAULT 10 COMMENT '订单比率';


SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for order_album
-- ----------------------------
DROP TABLE IF EXISTS `order_album`;
CREATE TABLE `order_album` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `del_flag` char(1) NOT NULL DEFAULT 'N' COMMENT '删除标识',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_user` varchar(45) DEFAULT NULL COMMENT '更新人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user` varchar(45) DEFAULT NULL COMMENT '创建人',
  `order_id` varchar(45) DEFAULT NULL COMMENT '订单',
  `user_id` varchar(45) DEFAULT NULL COMMENT '用户',
  `store_id` varchar(45) DEFAULT NULL COMMENT '店铺',
  `finished_image` varchar(1000) DEFAULT NULL COMMENT '成片地址',
  `finished_size` decimal(10,0) DEFAULT '0' COMMENT '成片大小',
  `deal_user` varchar(45) DEFAULT NULL COMMENT '修图人',
  `status_flag` int(4) DEFAULT '0' COMMENT '状态',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `image_name` varchar(255) DEFAULT NULL COMMENT '图片名称',
  `finished_artwork` varchar(1000) DEFAULT NULL COMMENT '正片原片',
  `download_flag` char(1) DEFAULT 'N' COMMENT '是否下载成片',
  `clean_flag` char(1) DEFAULT 'N' COMMENT '是否清理OSS',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='订单图片';


-- ----------------------------
-- Table structure for order_album_repair
-- ----------------------------
DROP TABLE IF EXISTS `order_album_repair`;
CREATE TABLE `order_album_repair` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `del_flag` char(1) NOT NULL DEFAULT 'N' COMMENT '删除标识',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_user` varchar(45) DEFAULT NULL COMMENT '更新人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user` varchar(45) DEFAULT NULL COMMENT '创建人',
  `user_id` varchar(45) DEFAULT NULL COMMENT '用户',
  `order_id` varchar(45) DEFAULT NULL COMMENT '订单',
  `store_id` varchar(45) DEFAULT NULL COMMENT '店铺',
  `status_flag` int(4) DEFAULT '0' COMMENT '状态',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `type_flag` int(4) DEFAULT '0' COMMENT '返修类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='订单返修';


-- ----------------------------
-- Table structure for order_album_repair_detail
-- ----------------------------
DROP TABLE IF EXISTS `order_album_repair_detail`;
CREATE TABLE `order_album_repair_detail` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `del_flag` char(1) NOT NULL DEFAULT 'N' COMMENT '删除标识',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_user` varchar(45) DEFAULT NULL COMMENT '更新人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user` varchar(45) DEFAULT NULL COMMENT '创建人',
  `repair_id` varchar(45) DEFAULT NULL COMMENT '返修ID',
  `image_id` varchar(45) DEFAULT NULL COMMENT '图片ID',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='订单返修详情';



-- ----------------------------
-- Table structure for client_notice
-- ----------------------------
DROP TABLE IF EXISTS `client_notice`;
CREATE TABLE `client_notice` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `del_flag` char(1) NOT NULL DEFAULT 'N' COMMENT '删除标识',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_user` varchar(45) DEFAULT NULL COMMENT '更新人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user` varchar(45) DEFAULT NULL COMMENT '创建人',
  `client_order_id` int(11) DEFAULT NULL COMMENT '客户端订单ID',
  `order_id` int(11) DEFAULT NULL COMMENT 'web订单ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户',
  `product_id` int(11) DEFAULT NULL COMMENT '商品',
  `store_id` int(11) DEFAULT NULL COMMENT '店铺',
  `remark` varchar(255) DEFAULT NULL COMMENT '内容',
  `status_flag` int(4) DEFAULT '0' COMMENT '状态',
  `type_flag` int(4) DEFAULT '0' COMMENT '类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='客户端通知';

-- ----------------------------
-- Table structure for client_order
-- ----------------------------
DROP TABLE IF EXISTS `client_order`;
CREATE TABLE `client_order` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `del_flag` char(1) NOT NULL DEFAULT 'N' COMMENT '删除标识',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_user` varchar(45) DEFAULT NULL COMMENT '更新人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user` varchar(45) DEFAULT NULL COMMENT '创建人',
  `user_id` int(10) DEFAULT NULL COMMENT '用户',
  `order_code` varchar(45) DEFAULT NULL COMMENT '订单编码',
  `store_id` int(10) DEFAULT NULL COMMENT '店铺',
  `product_type` varchar(45) DEFAULT NULL COMMENT '商品类型',
  `product_id` int(10) DEFAULT NULL COMMENT '商品ID',
  `product_name` varchar(255) DEFAULT NULL COMMENT '商品名称',
  `specification` varchar(45) DEFAULT NULL COMMENT '规格',
  `unit_price` decimal(10,2) DEFAULT NULL COMMENT '单价',
  `quantity` int(10) DEFAULT NULL COMMENT '数量',
  `user_coupon_id` int(10) DEFAULT NULL COMMENT '优惠券',
  `off_price` decimal(10,2) DEFAULT NULL COMMENT '优惠金额',
  `totle_price` decimal(10,2) DEFAULT NULL COMMENT '总价',
  `deal_price` decimal(10,2) DEFAULT NULL COMMENT '成交价',
  `pay_mode` int(4) DEFAULT '0' COMMENT '支付方式',
  `pay_time` datetime DEFAULT NULL COMMENT '支付时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `show_flag` char(1) DEFAULT 'Y' COMMENT '显示标识',
  `status_flag` int(4) DEFAULT '0' COMMENT '状态',
  `fee` decimal(10,2) DEFAULT NULL COMMENT '手续费',
  `coin` decimal(10,2) DEFAULT NULL COMMENT '余额',
  `point` decimal(10,2) DEFAULT NULL COMMENT '积分',
  `cash` decimal(10,2) DEFAULT NULL COMMENT '现金',
  `cancel_reason` varchar(255) DEFAULT NULL COMMENT '取消原因',
  `album_price` decimal(10,2) DEFAULT '0.00' COMMENT '相册价格',
  `album_quantity` int(11) DEFAULT '0' COMMENT '相册数量',
  `order_name` varchar(255) DEFAULT NULL COMMENT '订单名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='用户订单';

-- ----------------------------
-- Table structure for client_order_image
-- ----------------------------
DROP TABLE IF EXISTS `client_order_image`;
CREATE TABLE `client_order_image` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `del_flag` char(1) NOT NULL DEFAULT 'N' COMMENT '删除标识',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_user` varchar(45) DEFAULT NULL COMMENT '更新人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user` varchar(45) DEFAULT NULL COMMENT '创建人',
  `client_order_id` int(11) DEFAULT NULL COMMENT '客户端订单ID',
  `order_id` int(11) DEFAULT NULL COMMENT 'web订单ID',
  `type_flag` int(4) DEFAULT '0' COMMENT '类型',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `pid` int(11) DEFAULT '0' COMMENT '父级ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `local_path` varchar(1000) DEFAULT NULL COMMENT '本地地址',
  `size` decimal(11,0) DEFAULT NULL COMMENT '大小',
  `full_name` varchar(500) DEFAULT NULL COMMENT '全名',
  `status_flag` int(4) DEFAULT '0' COMMENT '状态',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `oss_artwork` varchar(1000) DEFAULT NULL COMMENT '原图',
  `oss_thumbnail` varchar(1000) DEFAULT NULL COMMENT '缩略图',
  `clean_flag` char(1) DEFAULT 'N' COMMENT '清理',
  `store_id` int(11) DEFAULT NULL COMMENT '商铺ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='客户端订单图片';

-- ----------------------------
-- Table structure for client_version
-- ----------------------------
DROP TABLE IF EXISTS `client_version`;
CREATE TABLE `client_version` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `del_flag` char(1) NOT NULL DEFAULT 'N' COMMENT '删除标识',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_user` varchar(45) DEFAULT NULL COMMENT '更新人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user` varchar(45) DEFAULT NULL COMMENT '创建人',
  `win_version` varchar(255) DEFAULT NULL COMMENT 'win32版本',
  `win_url` varchar(255) DEFAULT NULL COMMENT 'win32地址',
  `darwin_version` varchar(255) DEFAULT NULL COMMENT 'IOS版本',
  `darwin_url` varchar(255) DEFAULT NULL COMMENT 'IOS地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='客户端版本';


-- ----------------------------
-- Table structure for activity_banner
-- ----------------------------
DROP TABLE IF EXISTS `activity_banner`;
CREATE TABLE `activity_banner` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `del_flag` char(1) NOT NULL DEFAULT 'N' COMMENT '删除标识',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_user` varchar(45) DEFAULT NULL COMMENT '更新人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user` varchar(45) DEFAULT NULL COMMENT '创建人',
  `type_flag` varchar(45) DEFAULT NULL COMMENT '类型',
  `banner_name` varchar(45) DEFAULT NULL COMMENT '名称',
  `subtitle` varchar(255) DEFAULT NULL COMMENT '子标题',
  `url` varchar(255) DEFAULT NULL COMMENT '地址',
  `image_url` varchar(1000) DEFAULT NULL COMMENT '图片地址',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `content` text COMMENT '详情',
  `rank` int(11) DEFAULT '0' COMMENT '排序',
  `use_flag` char(1) DEFAULT 'N' COMMENT '可用',
  `activity_id` int(11) DEFAULT NULL COMMENT '活动ID',
  `type_id` int(11) DEFAULT NULL COMMENT '活动类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='活动banner';

-- ----------------------------
-- Records of activity_banner
-- ----------------------------
INSERT INTO `activity_banner` VALUES ('1', 'N', '2019-07-12 18:19:14', null, '2019-07-03 21:28:09', null, null, null, null, 'https://www.baidu.com/', 'https://img.tutuxiang.com/tutuxiangTest/images/2019-07-03-09-26-53-xcf8n7hy.jpg', null, null, '0', 'N', null, null);
INSERT INTO `activity_banner` VALUES ('2', 'N', '2019-07-12 18:19:12', null, '2019-07-03 21:28:29', null, null, null, null, 'https://www.baidu.com/', 'https://img.tutuxiang.com/tutuxiangTest/images/2019-07-03-09-28-18-ht2obxqs.jpg', null, null, '0', 'N', null, null);
INSERT INTO `activity_banner` VALUES ('3', 'N', '2019-07-12 18:19:11', null, '2019-07-03 21:28:49', null, null, null, null, 'https://www.baidu.com/', 'https://img.tutuxiang.com/tutuxiangTest/images/2019-07-03-09-28-36-iao4vrfm.jpg', null, null, '0', 'N', null, null);
INSERT INTO `activity_banner` VALUES ('4', 'N', '2019-07-12 18:19:10', null, '2019-07-04 10:18:03', null, null, null, null, 'https://www.baidu.com/', 'https://img.tutuxiang.com/tutuxiangTest/images/2019-07-04-10-18-14-6i9f8zof.jpg', null, null, '0', 'N', null, null);
INSERT INTO `activity_banner` VALUES ('5', 'N', '2019-07-04 10:19:04', null, '2019-07-04 10:19:04', null, null, null, null, 'https://www.baidu.com/', 'https://img.tutuxiang.com/tutuxiangTest/images/2019-07-04-10-19-15-zn4mg77k.jpg', null, null, '0', 'N', null, null);

-- ----------------------------
-- Table structure for activity_info
-- ----------------------------
DROP TABLE IF EXISTS `activity_info`;
CREATE TABLE `activity_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `del_flag` char(1) NOT NULL DEFAULT 'N' COMMENT '删除标识',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_user` varchar(45) DEFAULT NULL COMMENT '更新人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user` varchar(45) DEFAULT NULL COMMENT '创建人',
  `NAME` varchar(45) DEFAULT NULL COMMENT '活动名称',
  `type_id` int(11) DEFAULT NULL COMMENT '活动类型',
  `min_value` varchar(45) DEFAULT NULL COMMENT '最小值',
  `max_value` varchar(45) DEFAULT NULL COMMENT '最大值',
  `ratio` varchar(45) DEFAULT NULL COMMENT '比率',
  `begin_time` datetime DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '结束时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `limit_num` varchar(45) DEFAULT NULL COMMENT '限制总数',
  `use_flag` char(1) DEFAULT 'N' COMMENT '可用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='活动信息';

-- ----------------------------
-- Records of activity_info
-- ----------------------------
INSERT INTO `activity_info` VALUES ('1', 'N', '2019-06-05 17:06:25', null, '2019-06-05 17:06:25', null, '注册有礼', '1', '1000', null, null, '2019-07-08 00:00:00', '2019-07-19 00:00:00', '注册送800积分', null, 'Y');
INSERT INTO `activity_info` VALUES ('2', 'N', '2019-06-06 10:21:50', null, '2019-06-06 10:21:50', null, '充值有礼', '2', '500', null, '100', '2019-07-04 00:00:00', '2019-07-31 00:00:00', '充值金额大于500，即送充值金额等值积分，单个账户赠送上线为10000', '10000', 'Y');
INSERT INTO `activity_info` VALUES ('3', 'N', '2019-06-10 18:58:50', null, '2019-06-06 15:34:23', null, '众筹礼', '3', '18', null, '1', '2019-06-06 15:33:41', '2019-07-31 00:00:00', '18个人一轮，反1%', null, 'Y');
INSERT INTO `activity_info` VALUES ('4', 'N', '2019-06-06 15:36:01', null, '2019-06-06 15:36:01', null, '消费反积分', '4', '10', null, '20', '2019-06-06 15:35:48', '2099-08-31 00:00:00', '确认完成订单，反积分20%', null, 'Y');
INSERT INTO `activity_info` VALUES ('5', 'N', '2019-07-05 15:16:29', null, '2019-06-06 15:43:42', null, '积分抵扣', '5', '5', null, '10', '2019-06-06 15:43:05', '2019-07-31 00:00:00', '消费满5，积分可抵扣10%', null, 'Y');

-- ----------------------------
-- Table structure for activity_log
-- ----------------------------
DROP TABLE IF EXISTS `activity_log`;
CREATE TABLE `activity_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `del_flag` char(1) NOT NULL DEFAULT 'N' COMMENT '删除标识',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_user` varchar(45) DEFAULT NULL COMMENT '更新人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user` varchar(45) DEFAULT NULL COMMENT '创建人',
  `activity_id` varchar(255) DEFAULT NULL COMMENT '活动ID',
  `type_id` varchar(255) DEFAULT NULL COMMENT '类型',
  `user_id` varchar(255) DEFAULT NULL COMMENT '用户',
  `store_id` varchar(255) DEFAULT NULL COMMENT '店铺',
  `product_id` varchar(255) DEFAULT NULL COMMENT '产品',
  `order_id` varchar(255) DEFAULT NULL COMMENT '订单',
  `total_price` varchar(255) DEFAULT NULL COMMENT '总金额',
  `cash` varchar(255) DEFAULT NULL COMMENT '现金',
  `coin` varchar(255) DEFAULT NULL COMMENT '余额',
  `point` varchar(255) DEFAULT NULL COMMENT '积分',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `remark2` varchar(255) DEFAULT NULL COMMENT '备注2',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='活动日志';


-- ----------------------------
-- Table structure for activity_type
-- ----------------------------
DROP TABLE IF EXISTS `activity_type`;
CREATE TABLE `activity_type` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `del_flag` char(1) NOT NULL DEFAULT 'N' COMMENT '删除标识',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_user` varchar(45) DEFAULT NULL COMMENT '更新人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user` varchar(45) DEFAULT NULL COMMENT '创建人',
  `type_name` varchar(45) DEFAULT NULL COMMENT '活动类型',
  `limit_num` varchar(45) DEFAULT NULL COMMENT '限制数量',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `use_flag` char(1) DEFAULT 'N' COMMENT '可用标识',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='活动类型';

-- ----------------------------
-- Records of activity_type
-- ----------------------------
INSERT INTO `activity_type` VALUES ('1', 'N', '2019-06-05 15:45:41', null, '2019-06-05 15:45:41', null, '注册礼', null, '注册送积分', 'Y');
INSERT INTO `activity_type` VALUES ('2', 'N', '2019-06-05 18:28:15', null, '2019-06-05 18:28:15', null, '充值礼', '10000', '充值送积分，上限10000', 'Y');
INSERT INTO `activity_type` VALUES ('3', 'N', '2019-06-05 18:30:05', null, '2019-06-05 18:30:05', null, '众筹礼', null, '充值客户即加送1%积分，越早充值，加送越多。', 'Y');
INSERT INTO `activity_type` VALUES ('4', 'N', '2019-06-06 15:26:09', null, '2019-06-06 15:26:09', null, '消费返', null, '消费满足条件，返还相应比率积分', 'Y');
INSERT INTO `activity_type` VALUES ('5', 'N', '2019-06-06 15:27:18', null, '2019-06-06 15:27:18', null, '积分抵扣', null, '满足条件可积分抵扣', 'Y');


-- ----------------------------
-- Table structure for order_accept_log
-- ----------------------------
DROP TABLE IF EXISTS `order_accept_log`;
CREATE TABLE `order_accept_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `del_flag` char(1) NOT NULL DEFAULT 'N' COMMENT '删除标识',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_user` varchar(45) DEFAULT NULL COMMENT '更新人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user` varchar(45) DEFAULT NULL COMMENT '创建人',
  `client_order_id` int(11) DEFAULT NULL COMMENT '客户端',
  `order_id` int(11) DEFAULT NULL COMMENT '订单',
  `user_id` int(11) DEFAULT NULL COMMENT '用户',
  `product_id` int(11) DEFAULT NULL COMMENT '商品',
  `store_id` int(11) DEFAULT NULL COMMENT '店铺',
  `status_flag` int(4) DEFAULT '0' COMMENT '状态',
  `type_flag` varchar(45) DEFAULT NULL COMMENT '类型',
  `limit_day` int(4) DEFAULT '7' COMMENT '限制天数',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='订单验收审核记录';