diff options
Diffstat (limited to 'opendc-web/opendc-web-server/src/main/resources/db')
2 files changed, 4 insertions, 0 deletions
diff --git a/opendc-web/opendc-web-server/src/main/resources/db/migration/V1__add_job_report_column.sql b/opendc-web/opendc-web-server/src/main/resources/db/migration/V1__add_job_report_column.sql new file mode 100644 index 00000000..108b0c07 --- /dev/null +++ b/opendc-web/opendc-web-server/src/main/resources/db/migration/V1__add_job_report_column.sql @@ -0,0 +1,2 @@ +-- Add report column to job table to store simulation warnings and errors +ALTER TABLE job ADD COLUMN IF NOT EXISTS report jsonb; diff --git a/opendc-web/opendc-web-server/src/main/resources/db/migration/V2__add_job_started_at.sql b/opendc-web/opendc-web-server/src/main/resources/db/migration/V2__add_job_started_at.sql new file mode 100644 index 00000000..9df4601a --- /dev/null +++ b/opendc-web/opendc-web-server/src/main/resources/db/migration/V2__add_job_started_at.sql @@ -0,0 +1,2 @@ +-- Add startedAt timestamp to track when job execution begins +ALTER TABLE job ADD COLUMN IF NOT EXISTS started_at TIMESTAMP; |