Files
Robin HuangandGitHub aee15debe4 Allow storing multiple output files per workflow. (#69)
* Allow multiple storage files per workflow result.

* Add migration.
2024-07-11 09:57:14 -07:00

5 lines
427 B
SQL

-- Modify "ci_workflow_results" table
ALTER TABLE "ci_workflow_results" DROP COLUMN "ci_workflow_result_storage_file";
-- Modify "storage_files" table
ALTER TABLE "storage_files" ADD COLUMN "ci_workflow_result_storage_file" uuid NULL, ADD CONSTRAINT "storage_files_ci_workflow_results_storage_file" FOREIGN KEY ("ci_workflow_result_storage_file") REFERENCES "ci_workflow_results" ("id") ON UPDATE NO ACTION ON DELETE SET NULL;