-- Companion SQL for migrations/Version20260922140000.php
ALTER TABLE `mobile_app`
  ADD `eas_project_id` VARCHAR(100) DEFAULT NULL,
  ADD `ota_enabled` TINYINT(1) DEFAULT 0 NOT NULL;

CREATE TABLE `mobile_app_update_job` (
  `id` INT AUTO_INCREMENT NOT NULL,
  `company_id` INT NOT NULL,
  `acronym` VARCHAR(100) NOT NULL,
  `type` VARCHAR(20) NOT NULL,
  `platform` VARCHAR(20) DEFAULT NULL,
  `status` VARCHAR(20) NOT NULL,
  `pipeline_uuid` VARCHAR(100) DEFAULT NULL,
  `pipeline_url` VARCHAR(1000) DEFAULT NULL,
  `pipeline_build_number` INT DEFAULT NULL,
  `branch` VARCHAR(255) DEFAULT NULL,
  `batch_id` VARCHAR(36) DEFAULT NULL,
  `error_message` LONGTEXT DEFAULT NULL,
  `pull_request_url` VARCHAR(1000) DEFAULT NULL,
  `created_at` DATETIME NOT NULL,
  `updated_at` DATETIME NOT NULL,
  `finished_at` DATETIME DEFAULT NULL,
  INDEX `idx_mobile_app_update_job_type_status` (`type`, `status`),
  INDEX `idx_mobile_app_update_job_batch` (`batch_id`),
  INDEX `idx_mobile_app_update_job_company` (`company_id`),
  PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB;