1 files changed, 12 insertions, 2 deletions
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
 );
 
 
@@ -588,6 +589,14 @@ ALTER TABLE ONLY public.mini_environment_services
 
 
 --
+-- 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');