xiangqinxiangmu/service/Essential/target/classes/sql/blacklist.sql

-- 黑名单表
CREATE TABLE IF NOT EXISTS `blacklist` (
    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '黑名单记录ID',
    `user_id` BIGINT NOT NULL COMMENT '用户ID（拉黑者）',
    `blocked_user_id` BIGINT NOT NULL COMMENT '被拉黑的用户ID',
    `reason` VARCHAR(200) DEFAULT NULL COMMENT '拉黑原因',
    `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `uk_user_blocked` (`user_id`, `blocked_user_id`) COMMENT '用户和被拉黑用户的唯一索引',
    KEY `idx_user_id` (`user_id`) COMMENT '用户ID索引',
    KEY `idx_blocked_user_id` (`blocked_user_id`) COMMENT '被拉黑用户ID索引',
    KEY `idx_created_at` (`created_at`) COMMENT '创建时间索引'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='黑名单表';