-- 会员推送设备（极光 RegistrationID 绑定）
CREATE TABLE IF NOT EXISTS `member_push_device` (
    `id`              bigint       NOT NULL AUTO_INCREMENT COMMENT '编号',
    `member_id`       bigint       NOT NULL COMMENT '会员编号',
    `registration_id` varchar(64)  NOT NULL COMMENT '极光 RegistrationID',
    `alias`           varchar(64)  NULL DEFAULT NULL COMMENT '极光别名，如 u{memberId}',
    `platform`        varchar(16)  NOT NULL COMMENT 'ios / android',
    `provider`        varchar(16)  NOT NULL DEFAULT 'jpush' COMMENT '推送服务商',
    `tenant_id`       bigint       NOT NULL DEFAULT 0 COMMENT '租户编号',
    `creator`         varchar(64)  NULL DEFAULT '' COMMENT '创建者',
    `create_time`     datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updater`         varchar(64)  NULL DEFAULT '' COMMENT '更新者',
    `update_time`     datetime     NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `deleted`         bit(1)       NOT NULL DEFAULT b'0' COMMENT '是否删除',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `uk_registration_id` (`registration_id`) USING BTREE,
    KEY `idx_member_id` (`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会员推送设备';