SET NAMES utf8mb4;

CREATE TABLE IF NOT EXISTS sla_snapshots (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  workspace_id BIGINT UNSIGNED NOT NULL,
  period_date DATE NOT NULL,
  uptime_percent DECIMAL(8,4) NOT NULL DEFAULT 100,
  sla_compliance_percent DECIMAL(8,4) NOT NULL DEFAULT 100,
  mtta_minutes DECIMAL(12,2) NOT NULL DEFAULT 0,
  mttr_minutes DECIMAL(12,2) NOT NULL DEFAULT 0,
  incidents_total INT UNSIGNED NOT NULL DEFAULT 0,
  incidents_critical INT UNSIGNED NOT NULL DEFAULT 0,
  sla_breaches INT UNSIGNED NOT NULL DEFAULT 0,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY uq_sla_snapshot(workspace_id,period_date),
  CONSTRAINT fk_ss_workspace FOREIGN KEY(workspace_id) REFERENCES workspaces(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
