-- v6: Add real_content_id (canonical TikTok aweme_id) to videos tables.
-- Some users input only a link instead of the numeric content_id; after TikTok API
-- refresh we save the resolved aweme_id here so sales matching can link by either field.

ALTER TABLE kol_videos
  ADD COLUMN real_content_id VARCHAR(100) DEFAULT NULL AFTER content_id,
  ADD INDEX idx_real_content_id (real_content_id);

ALTER TABLE video_entries
  ADD COLUMN real_content_id VARCHAR(100) DEFAULT NULL AFTER content_id,
  ADD INDEX idx_video_real_content_id (real_content_id);