~jiangyouyao/beauty-erp.git

New file
			@@ -0,0 +1,203 @@

			/**
			* 奖品设置表
			* @author yourName
			* @date 2021-03-31 16:57
			*/
			CREATE TABLE activity_sign_award_set(
			create_by varchar(100) NOT NULL COMMENT '创建人',
			create_time datetime NOT NULL COMMENT '创建时间',
			update_by varchar(100) NOT NULL COMMENT '更新人',
			update_time datetime NOT NULL COMMENT '更新时间',
			id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

			award_type int(4) COMMENT '奖项类型（1：自定义产品2：积分3：优惠券4：店铺商品）',

			award_rule int(4) COMMENT '奖项规则（1：每日奖励（默认）2：累计签到天数）',

			cumulative_day int(4) COMMENT '签到累计天数',

			award_name varchar(100) COMMENT '奖项名称',

			introduce_img varchar(500) COMMENT '图片介绍',

			introduce_tip varchar(500) COMMENT '文字介绍',

			award_inventory_cnt int(4) COMMENT '奖项库存数量',

			award_distribute_cnt int(4) COMMENT '已派发数量',

			award_way int(4) COMMENT '兑奖方式（1：线下兑换2：物流配送3：客服兑换）',

			operation_tip varchar(500) COMMENT '操作提示',

			prize_address varchar(500) COMMENT '兑奖地址',

			prize_start_time datetime COMMENT '兑奖期限开始日期',

			prize_end_time datetime COMMENT '兑奖期限结束日期',

			wechat_img varchar(500) COMMENT '客服微信',

			score_cnt int(4) COMMENT '积分数量',

			coupon_id varchar(100) COMMENT '优惠券ID',

			goods_id varchar(100) COMMENT '商品ID',

			activity_id bigint(20) COMMENT '活动主表ID',

			company_id bigint(20) COMMENT '公司ID',

			PRIMARY KEY(id)
			)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='奖品设置表';



			/**
			* 领
			* @author yourName
			* @date 2021-03-31 16:57
			*/
			CREATE TABLE activity_sign_receive_record(
			create_by varchar(100) NOT NULL COMMENT '创建人',
			create_time datetime NOT NULL COMMENT '创建时间',
			update_by varchar(100) NOT NULL COMMENT '更新人',
			update_time datetime NOT NULL COMMENT '更新时间',
			id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

			open_id varchar(100) COMMENT 'openID',

			receive_time datetime COMMENT '领取时间',

			remark varchar(500) COMMENT '备注',

			award_id bigint(20) COMMENT '奖品设置表ID',

			state int(4) COMMENT '是否已领取（1：待领取2:已领取）',

			write_off_code varchar(100) COMMENT '核销码',

			activity_id bigint(20) COMMENT '活动主表ID',

			company_id bigint(20) COMMENT '公司ID',

			PRIMARY KEY(id)
			)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='领取记录表';




			/**
			* 签到记录表
			* @author yourName
			* @date 2021-03-31 16:57
			*/
			CREATE TABLE activity_sign_record(
			create_by varchar(100) NOT NULL COMMENT '创建人',
			create_time datetime NOT NULL COMMENT '创建时间',
			update_by varchar(100) NOT NULL COMMENT '更新人',
			update_time datetime NOT NULL COMMENT '更新时间',
			id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

			open_id varchar(100) COMMENT 'openID',

			sign_time datetime COMMENT '签到时间',

			cumulative_day int(4) COMMENT '累计签到天数',

			activity_id bigint(20) COMMENT '活动主表ID',

			company_id bigint(20) COMMENT '公司ID',

			PRIMARY KEY(id)
			)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='签到记录表';

			ALTER TABLE `shop_activities`
			ADD COLUMN `act_code` varchar(200) NULL COMMENT '活动编码' AFTER `id`;

			ALTER TABLE `activity_sign_award_set`
			ADD COLUMN `award_state` int(4) NULL COMMENT '奖品是否有效（1：有效 2：无效）' AFTER `company_id`;

			ALTER TABLE `activity_sign_award_set`
			ADD COLUMN `goods_name` varchar(200) NULL COMMENT '产品名称' AFTER `coupon_id`;

			ALTER TABLE `activity_sign_award_set`
			ADD COLUMN `coupon_name` varchar(200) NULL COMMENT '优惠券名' AFTER `score_cnt`;

			ALTER TABLE `activity_sign_record`
			CHANGE COLUMN `open_id` `user_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'openID' AFTER `id`;

			ALTER TABLE `activity_sign_receive_record`
			CHANGE COLUMN `open_id` `user_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'openID' AFTER `id`;

			/**
			* 核销记录
			* @author yourName
			* @date 2021-04-08 14:25
			*/
			CREATE TABLE activity_sign_writeoff(
			create_by varchar(100) NOT NULL COMMENT '创建人',
			create_time datetime NOT NULL COMMENT '创建时间',
			update_by varchar(100) NOT NULL COMMENT '更新人',
			update_time datetime NOT NULL COMMENT '更新时间',
			id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

			writeoff_time datetime COMMENT '核销时间',

			writeoff_user varchar(100) COMMENT '核销员',

			writeoff_code varchar(100) COMMENT '兑奖码',

			act_id bigint(20) COMMENT '活动ID',

			award_id bigint(20) COMMENT '奖品ID',

			win_time datetime COMMENT '中奖时间',

			state int(4) COMMENT '状态',

			user_id bigint(20) COMMENT '中奖者ID',

			logistics_id bigint(20) COMMENT '物流ID',

			receive_id bigint(20) COMMENT '中奖记录ID',

			company_id bigint(20) COMMENT '公司ID',

			shop_id bigint(20) COMMENT '店铺ID',

			writeoff_userid bigint(20) COMMENT '核销员ID',

			PRIMARY KEY(id)
			)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='核销记录';

			ALTER TABLE `activity_sign_receive_record`
			ADD COLUMN `consignee` varchar(200) NULL COMMENT '收货人' AFTER `user_id`;

			ALTER TABLE `activity_sign_receive_record`
			ADD COLUMN `consignee_phone` varchar(50) NULL COMMENT '联系电话' AFTER `user_id`;

			ALTER TABLE `activity_sign_receive_record`
			ADD COLUMN `consignee_address` varchar(300) NULL COMMENT '收货地址' AFTER `consignee_phone`;

			ALTER TABLE `shop_delivery_info`
			ADD COLUMN `receive_id` bigint(20) NULL COMMENT '奖品领取ID' AFTER `company_id`;