Show the available services for each revision

2 files changed, 9 insertions, 2 deletions

diff --git a/db/migrate/20180523062426_add_available_services_to_govuk_guix_revision.rb b/db/migrate/20180523062426_add_available_services_to_govuk_guix_revision.rb
new file mode 100644
index 0000000..328a9ed
--- /dev/null
+++ b/db/migrate/20180523062426_add_available_services_to_govuk_guix_revision.rb
@@ -0,0 +1,5 @@
+class AddAvailableServicesToGovukGuixRevision < ActiveRecord::Migration[5.1]
+  def change
+    add_column :govuk_guix_revisions, :available_services, :json
+  end
+end
diff --git a/db/structure.sql b/db/structure.sql
index 0d56576..12c19cf 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -79,7 +79,8 @@ CREATE TABLE public.govuk_guix_revisions (
     store_path character varying,
     created_at timestamp without time zone NOT NULL,
     updated_at timestamp without time zone NOT NULL,
-    archived boolean DEFAULT false NOT NULL
+    archived boolean DEFAULT false NOT NULL,
+    available_services json
 );
 
 
@@ -501,6 +502,7 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('20180406124443'),
 ('20180410192329'),
 ('20180410192412'),
-('20180417195307');
+('20180417195307'),
+('20180523062426');