-- Migration: add per-song marketing pixel fields
-- Run this against an existing bmmg_records database that predates
-- these columns (fresh installs already get them via schema.sql).
--
-- On cPanel: paste this into phpMyAdmin's SQL tab for the bmmg_records
-- database, or run via the mysql CLI if you have shell access:
--   mysql -u <user> -p bmmg_records < 001_add_marketing_pixels.sql

USE tokensto_bmmg_records;

ALTER TABLE songs
  ADD COLUMN meta_pixel_id      VARCHAR(32) NULL COMMENT 'Meta/Facebook Pixel ID' AFTER release_date,
  ADD COLUMN tiktok_pixel_id    VARCHAR(32) NULL COMMENT 'TikTok Pixel ID' AFTER meta_pixel_id,
  ADD COLUMN custom_head_script TEXT        NULL COMMENT 'Raw script/HTML injected as-is into <head> for other pixels' AFTER tiktok_pixel_id;
