14 lines
784 B
SQL
Executable File
14 lines
784 B
SQL
Executable File
-- 抖音用户黑名单表
|
|
CREATE TABLE IF NOT EXISTS `douyin_blacklist` (
|
|
`id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|
`douyin_user_id` VARCHAR(64) NOT NULL COMMENT '抖音用户ID',
|
|
`reason` VARCHAR(255) DEFAULT '' COMMENT '拉黑原因',
|
|
`operator_id` BIGINT DEFAULT 0 COMMENT '操作人ID',
|
|
`status` TINYINT NOT NULL DEFAULT 1 COMMENT '状态: 1=生效, 0=已解除',
|
|
`created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
|
|
`updated_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `uk_douyin_user_id` (`douyin_user_id`),
|
|
KEY `idx_status` (`status`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='抖音用户黑名单表';
|