ALTER TABLE comments
    ADD COLUMN ip_address VARCHAR(45) DEFAULT NULL AFTER guest_name,
    ADD COLUMN body_hash VARCHAR(64) DEFAULT NULL AFTER body;

ALTER TABLE comments ADD INDEX idx_comments_spam (video_id, ip_address, body_hash, created_at);
