-- #migration 2026_07_02_019
CREATE TABLE IF NOT EXISTS parcours_config (
  parcours_id VARCHAR(30) PRIMARY KEY,
  archived    TINYINT(1)  NOT NULL DEFAULT 0,
  created_at  TIMESTAMP   DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS public_parcours (
  id             VARCHAR(30)     PRIMARY KEY,
  title          VARCHAR(255)    NOT NULL,
  subtitle       TEXT,
  slug           VARCHAR(100)    UNIQUE,
  duration_weeks INT             DEFAULT 4,
  price_normal   DECIMAL(8,2)    DEFAULT 60.00,
  price_launch   DECIMAL(8,2)    DEFAULT 40.00,
  archived       TINYINT(1)      DEFAULT 0,
  created_at     TIMESTAMP       DEFAULT CURRENT_TIMESTAMP
);