CREATE TABLE IF NOT EXISTS thread_themes (
 id INT AUTO_INCREMENT PRIMARY KEY,
 thread_uid VARCHAR(255) NULL,
 background_hex_color CHAR(7) NULL,
 reply_background_hex_color CHAR(7) NULL,
 text_hex_color CHAR(7) NULL,
 background_image_url TEXT NULL, 
 date_added DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, 
 audio TEXT NULL, 
 raw_styling TEXT NULL, 
 added_by INT NULL,

 UNIQUE KEY unique_thread_uid (thread_uid),
 INDEX idx_theme_added_by (added_by),

 CONSTRAINT fk_theme_thread_uid FOREIGN KEY (thread_uid) REFERENCES threads(thread_uid) ON DELETE CASCADE,
 CONSTRAINT fk_theme_added_by FOREIGN KEY (added_by) REFERENCES accounts(id) ON DELETE SET NULL
) ENGINE=InnoDB;