CREATE TABLE query_audit (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  project_id BIGINT UNSIGNED NOT NULL,
  tool VARCHAR(64) NOT NULL,
  database_connection_id BIGINT UNSIGNED NULL,
  statement_fingerprint TEXT NOT NULL,
  duration_ms INT UNSIGNED NULL,
  row_count INT UNSIGNED NULL,
  status VARCHAR(16) NOT NULL,
  error VARCHAR(512) NULL,
  created_by VARCHAR(255) NOT NULL,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY idx_query_audit_project_created (project_id, created_at),
  CONSTRAINT fk_query_audit_project FOREIGN KEY (project_id) REFERENCES projects (id),
  CONSTRAINT fk_query_audit_connection FOREIGN KEY (database_connection_id)
    REFERENCES database_connections (id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;