CREATE TABLE IF NOT EXISTS integration_report_catalog (
  id              INT AUTO_INCREMENT PRIMARY KEY,
  integration_id  VARCHAR(50) NOT NULL,
  report_id       VARCHAR(50) NOT NULL,
  name            VARCHAR(100) NOT NULL,
  description     VARCHAR(255) DEFAULT '',
  icon            VARCHAR(50) DEFAULT 'fa-file-lines',
  color           VARCHAR(20) DEFAULT '#94a3b8',
  is_core         TINYINT(1) DEFAULT 0,
  sort_order      INT DEFAULT 100,
  updated_at      TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY unique_report (integration_id, report_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
