-- #migration 2026_08_10_182_affiliate_links
CREATE TABLE IF NOT EXISTS affiliate_links (
    id           VARCHAR(36)  NOT NULL PRIMARY KEY DEFAULT (UUID()),
    key_name     VARCHAR(50)  NOT NULL UNIQUE,
    label        VARCHAR(200) NOT NULL,
    url_default  VARCHAR(500) NOT NULL,
    url_affiliate VARCHAR(500) NULL,
    active       TINYINT(1)   NOT NULL DEFAULT 1,
    created_at   DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at   DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Liens par défaut
INSERT INTO affiliate_links (key_name, label, url_default) VALUES
  ('bitly',    'Bit.ly',           'https://bit.ly'),
  ('behance',  'Behance',          'https://www.behance.net'),
  ('notion',   'Notion',           'https://www.notion.so'),
  ('linktree', 'Linktree',         'https://linktr.ee'),
  ('adobe_portfolio', 'Adobe Portfolio', 'https://portfolio.adobe.com')
ON DUPLICATE KEY UPDATE label=VALUES(label);