-- Phase 5: pilot hardening — backup runs, restore checks and monitoring events
CREATE TABLE IF NOT EXISTS backup_runs (
  id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  kind ENUM('backup','restore_check') NOT NULL DEFAULT 'backup',
  started_at DATETIME NOT NULL,
  finished_at DATETIME NULL,
  status ENUM('running','ok','failed') NOT NULL DEFAULT 'running',
  set_name VARCHAR(80) NULL,
  files INT UNSIGNED NOT NULL DEFAULT 0,
  bytes BIGINT UNSIGNED NOT NULL DEFAULT 0,
  encrypted TINYINT(1) NOT NULL DEFAULT 0,
  offsite TINYINT(1) NOT NULL DEFAULT 0,
  detail TEXT NULL,
  KEY (kind, started_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS monitor_events (
  id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  check_key VARCHAR(40) NOT NULL,
  status ENUM('fail','warn','recovered') NOT NULL,
  detail VARCHAR(255) NULL,
  notified TINYINT(1) NOT NULL DEFAULT 0,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY (check_key, created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

UPDATE central_meta SET v = '3' WHERE k = 'schema_version';
