-- Migration 2026_06_29_012 : champs infos personnelles utilisateur
ALTER TABLE users
  ADD COLUMN IF NOT EXISTS phone        VARCHAR(30)   NULL AFTER email,
  ADD COLUMN IF NOT EXISTS address      VARCHAR(255)  NULL AFTER phone,
  ADD COLUMN IF NOT EXISTS postal_code  VARCHAR(10)   NULL AFTER address,
  ADD COLUMN IF NOT EXISTS country      VARCHAR(80)   NULL AFTER postal_code;

-- Table contrats/abonnements signés
CREATE TABLE IF NOT EXISTS user_subscriptions (
  id            INT UNSIGNED     NOT NULL AUTO_INCREMENT PRIMARY KEY,
  user_id       VARCHAR(40)      NOT NULL,
  plan          VARCHAR(50)      NOT NULL,
  label         VARCHAR(150)     NULL,
  amount        INT UNSIGNED     NULL,
  status        ENUM('active','cancelled','expired') NOT NULL DEFAULT 'active',
  signed_at     DATETIME         NOT NULL DEFAULT CURRENT_TIMESTAMP,
  expires_at    DATETIME         NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;