Record job success without deleting the job record

Previously, the records for jobs would be deleted. It's useful to know when
jobs were inserted in to the database, as well as when they succeeded (if they
have). This change also makes it possible to keep track of jobs that have
failed, as they won't be deleted.

1 files changed, 12 insertions, 0 deletions

diff --git a/sqitch/deploy/dates_to_load_new_guix_revision_jobs.sql b/sqitch/deploy/dates_to_load_new_guix_revision_jobs.sql
new file mode 100644
index 0000000..989c4e5
--- /dev/null
+++ b/sqitch/deploy/dates_to_load_new_guix_revision_jobs.sql
@@ -0,0 +1,12 @@
+-- Deploy guix-data-service:dates_to_load_new_guix_revision_jobs to pg
+-- requires: initial_import
+
+BEGIN;
+
+ALTER TABLE load_new_guix_revision_jobs
+  ADD COLUMN created_at timestamp without time zone DEFAULT clock_timestamp();
+
+ALTER TABLE load_new_guix_revision_jobs
+  ADD COLUMN succeeded_at timestamp without time zone;
+
+COMMIT;