-- ============================================================================
--  ArNi CRM – Server-API Stufe 3: asynchrone DB-Jobs (Dump/Import)
--  Owner: CRM (Prefix crm_server_db_jobs). Engine/Collation wie Bestand.
--  Pollbar wie Backup-/Cron-Runs; Dump-Dateien liegen unter storage/db_dumps.
-- ============================================================================
SET NAMES utf8mb4;

CREATE TABLE IF NOT EXISTS `crm_server_db_jobs` (
  `id`          int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type`        enum('dump','import') NOT NULL,
  `db_name`     varchar(190) NOT NULL,
  `mode`        varchar(16)  DEFAULT NULL,          -- dump: full|structure|data
  `gzip`        tinyint(1)   NOT NULL DEFAULT 0,
  `status`      varchar(16)  NOT NULL DEFAULT 'running', -- running|success|failed
  `message`     varchar(500) DEFAULT NULL,
  `file_path`   varchar(500) DEFAULT NULL,          -- nur Dump (serverseitig, nie in API-Antwort)
  `size_bytes`  bigint(20) unsigned DEFAULT NULL,
  `source`      varchar(190) DEFAULT NULL,          -- import: body | job:<id>
  `trigger`     varchar(16)  NOT NULL DEFAULT 'api',
  `created_by`  varchar(120) DEFAULT NULL,
  `started_at`  datetime     DEFAULT NULL,
  `finished_at` datetime     DEFAULT NULL,
  `created_at`  datetime     NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_type_status` (`type`,`status`),
  KEY `idx_created` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;