-- Migration: Create shop_perks table
CREATE TABLE IF NOT EXISTS shop_perks (
    id INT AUTO_INCREMENT PRIMARY KEY,
    perk_type VARCHAR(50) NOT NULL, -- "pinned_message", "background"
    perk_value TEXT NOT NULL,       -- The message text or the image URL
    user_name VARCHAR(255) NOT NULL,
    expires_at TIMESTAMP NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);