From e043d884e9dc077f1ab366d956ee7dd9df4c7460 Mon Sep 17 00:00:00 2001
From: Christopher Baines <mail@cbaines.net>
Date: Wed, 30 May 2018 20:36:03 +0100
Subject: Add the GovukGuix::Revision commit_hash to the DataSnapshot model

This is to record the revision of govuk-guix used to create the
snapshot.
---
 ...dd_govuk_guix_revision_to_govuk_guix_data_snapshot.rb | 16 ++++++++++++++++
 db/structure.sql                                         | 14 ++++++++++++--
 2 files changed, 28 insertions(+), 2 deletions(-)
 create mode 100644 db/migrate/20180530192706_add_govuk_guix_revision_to_govuk_guix_data_snapshot.rb

(limited to 'db')

diff --git a/db/migrate/20180530192706_add_govuk_guix_revision_to_govuk_guix_data_snapshot.rb b/db/migrate/20180530192706_add_govuk_guix_revision_to_govuk_guix_data_snapshot.rb
new file mode 100644
index 0000000..5a735dc
--- /dev/null
+++ b/db/migrate/20180530192706_add_govuk_guix_revision_to_govuk_guix_data_snapshot.rb
@@ -0,0 +1,16 @@
+class AddGovukGuixRevisionToGovukGuixDataSnapshot < ActiveRecord::Migration[5.1]
+  def change
+    add_column(
+      :govuk_guix_data_snapshots,
+      :govuk_guix_revision_commit_hash,
+      :string,
+      null: false
+    )
+    add_foreign_key(
+      :govuk_guix_data_snapshots,
+      :govuk_guix_revisions,
+      column: :govuk_guix_revision_commit_hash,
+      primary_key: :commit_hash
+    )
+  end
+end
diff --git a/db/structure.sql b/db/structure.sql
index 08cfe22..500c09d 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -80,7 +80,8 @@ CREATE TABLE public.govuk_guix_data_snapshots (
     archived boolean DEFAULT false NOT NULL,
     manifest json NOT NULL,
     created_at timestamp without time zone NOT NULL,
-    updated_at timestamp without time zone NOT NULL
+    updated_at timestamp without time zone NOT NULL,
+    govuk_guix_revision_commit_hash character varying NOT NULL
 );
 
 
@@ -587,6 +588,14 @@ ALTER TABLE ONLY public.mini_environment_services
     ADD CONSTRAINT fk_rails_36052da616 FOREIGN KEY (mini_environment_id) REFERENCES public.mini_environments(id);
 
 
+--
+-- Name: govuk_guix_data_snapshots fk_rails_59b1facc61; Type: FK CONSTRAINT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY public.govuk_guix_data_snapshots
+    ADD CONSTRAINT fk_rails_59b1facc61 FOREIGN KEY (govuk_guix_revision_commit_hash) REFERENCES public.govuk_guix_revisions(commit_hash);
+
+
 --
 -- PostgreSQL database dump complete
 --
@@ -623,6 +632,7 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('20180417195307'),
 ('20180523062426'),
 ('20180527183740'),
-('20180530191341');
+('20180530191341'),
+('20180530192706');
 
 
-- 
cgit v1.2.3