SET NAMES utf8mb4;

ALTER TABLE schema_migrations ADD COLUMN IF NOT EXISTS checksum CHAR(64) NULL;
ALTER TABLE schema_migrations ADD COLUMN IF NOT EXISTS status ENUM('applied','failed') NOT NULL DEFAULT 'applied';
ALTER TABLE schema_migrations ADD COLUMN IF NOT EXISTS error_message TEXT NULL;
ALTER TABLE schema_migrations MODIFY applied_at DATETIME NULL;

CREATE TABLE IF NOT EXISTS system_test_runs (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  workspace_id BIGINT UNSIGNED NULL,
  test_suite VARCHAR(120) NOT NULL,
  status ENUM('ok','failed') NOT NULL,
  result_json JSON NULL,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  INDEX idx_system_test_time(test_suite,created_at),
  CONSTRAINT fk_str_workspace FOREIGN KEY(workspace_id) REFERENCES workspaces(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
