|
/** 优惠券活动增加领取周期字段 **/
|
ALTER TABLE li_coupon_activity ADD coupon_frequency_enum varchar(255) COMMENT '领取周期';
|
-- 会员优惠券标识
|
CREATE TABLE `li_member_coupon_sign` (
|
`id` bigint NOT NULL,
|
`coupon_activity_Id` bigint NULL DEFAULT NULL COMMENT '优惠券活动id',
|
`member_id` bigint NULL DEFAULT NULL COMMENT '会员id',
|
`invalid_time` datetime NULL DEFAULT NULL COMMENT '过期时间',
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC;
|
|
/**
|
IM聊天
|
*/
|
CREATE TABLE `li_im_talk` (
|
`id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
`delete_flag` bit(1) DEFAULT NULL COMMENT '删除标志',
|
`update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '修改者',
|
`update_time` datetime(6) DEFAULT NULL COMMENT '修改时间',
|
`user_id1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户1Id',
|
`user_id2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户2Id',
|
`name1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户1名称',
|
`name2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户2名称',
|
`face1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户1头像',
|
`face2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户2头像',
|
`top1` bit(1) DEFAULT NULL COMMENT '用户1置顶标识',
|
`top2` bit(1) DEFAULT NULL COMMENT '用户2置顶标识',
|
`disable1` bit(1) DEFAULT NULL COMMENT '用户1禁用标识',
|
`disable2` bit(1) DEFAULT NULL COMMENT '用户2禁用标识',
|
`store_flag1` bit(1) DEFAULT NULL COMMENT '用户1店铺标识',
|
`store_flag2` bit(1) DEFAULT NULL COMMENT '用户2店铺标识',
|
`last_talk_time` datetime DEFAULT NULL COMMENT '最后聊天时间',
|
`last_talk_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '最后的消息',
|
`last_message_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '最后消息类型',
|
`talk_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '聊天Id',
|
`tenant_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '坐席Id',
|
`tenant_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '坐席名称',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
/**
|
IM消息
|
*/
|
CREATE TABLE `li_im_message` (
|
`id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
|
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建者',
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
`delete_flag` bit(1) DEFAULT NULL COMMENT '删除标识',
|
`update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '修改者',
|
`update_time` datetime(6) DEFAULT NULL COMMENT '修改标识',
|
`from_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发送用户Id',
|
`to_user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '接收用户Id',
|
`is_read` bit(1) DEFAULT NULL COMMENT '已读标识',
|
`message_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '聊天类型',
|
`text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '聊天内容',
|
`talk_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '聊天Id',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
|
/**
|
订单增加自提信息
|
*/
|
ALTER TABLE li_order ADD `store_address_path` varchar(255) DEFAULT NULL;
|
ALTER TABLE li_order ADD `store_address_center` varchar(255) DEFAULT NULL;
|
ALTER TABLE li_order ADD `store_address_mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL;
|
|
/**
|
店铺是否开启自提
|
*/
|
ALTER TABLE li_store ADD `self_pick_flag` bit(1) DEFAULT NULL;
|
/**
|
历史足迹增加店铺Id
|
*/
|
ALTER TABLE li_foot_print ADD `store_id` varchar(255) DEFAULT NULL COMMENT '店铺ID';
|
|
|
|
/**
|
用户提现申请增加字段
|
*/
|
ALTER TABLE li_member_withdraw_apply ADD `real_name` varchar(255) DEFAULT NULL;
|
ALTER TABLE li_member_withdraw_apply ADD `connect_number` varchar(255) DEFAULT NULL;
|
ALTER TABLE li_member_withdraw_apply ADD `error_message` text DEFAULT NULL;
|
