-- Migration: add manual Audiomack / Boomplay link 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 < 002_add_audiomack_boomplay_links.sql

USE tokensto_bmmg_records;

ALTER TABLE songs
  ADD COLUMN audiomack_url VARCHAR(500) NULL AFTER apple_match_score,
  ADD COLUMN boomplay_url  VARCHAR(500) NULL AFTER audiomack_url;
