-- Baltique OS Core 1.3.7 — Scenario Governance Sign-off
-- Reference migration. Runtime upgrade is executed by /upgrade_1_3_7.php for idempotent compatibility.
CREATE TABLE IF NOT EXISTS enterprise_release_program_steps (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  version VARCHAR(32) NOT NULL UNIQUE,
  phase_label VARCHAR(255) NOT NULL,
  title VARCHAR(255) NOT NULL,
  purpose TEXT NULL,
  module_key VARCHAR(120) NOT NULL,
  route_path VARCHAR(255) NOT NULL,
  upgrade_path VARCHAR(255) NOT NULL,
  owner_role VARCHAR(80) NOT NULL DEFAULT 'admin',
  status VARCHAR(40) NOT NULL DEFAULT 'planned',
  release_order INT NOT NULL DEFAULT 0,
  safety_json JSON NULL,
  deliverables_json JSON NULL,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  KEY idx_phase (phase_label),
  KEY idx_status (status),
  KEY idx_order (release_order)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Seed: 1.3.7 — Scenario Governance Sign-off
