From 807c10c5652423be96d125a502be222aa8d80119 Mon Sep 17 00:00:00 2001
From: Christopher Baines <mail@cbaines.net>
Date: Thu, 3 May 2018 21:34:08 +0100
Subject: Add extra fields to the Terraform AWS backend

---
 ...0410192329_add_route53_zone_id_to_terraform_aws_backends.rb |  5 +++++
 ...0192412_add_efs_file_system_id_to_terraform_aws_backends.rb |  5 +++++
 .../20180417195307_add_vpc_id_to_terraform_aws_backends.rb     |  5 +++++
 db/structure.sql                                               | 10 ++++++++--
 4 files changed, 23 insertions(+), 2 deletions(-)
 create mode 100644 db/migrate/20180410192329_add_route53_zone_id_to_terraform_aws_backends.rb
 create mode 100644 db/migrate/20180410192412_add_efs_file_system_id_to_terraform_aws_backends.rb
 create mode 100644 db/migrate/20180417195307_add_vpc_id_to_terraform_aws_backends.rb

(limited to 'db')

diff --git a/db/migrate/20180410192329_add_route53_zone_id_to_terraform_aws_backends.rb b/db/migrate/20180410192329_add_route53_zone_id_to_terraform_aws_backends.rb
new file mode 100644
index 0000000..6bb7186
--- /dev/null
+++ b/db/migrate/20180410192329_add_route53_zone_id_to_terraform_aws_backends.rb
@@ -0,0 +1,5 @@
+class AddRoute53ZoneIdToTerraformAwsBackends < ActiveRecord::Migration[5.1]
+  def change
+    add_column :terraform_aws_backends, :route_53_zone_id, :string, null: false
+  end
+end
diff --git a/db/migrate/20180410192412_add_efs_file_system_id_to_terraform_aws_backends.rb b/db/migrate/20180410192412_add_efs_file_system_id_to_terraform_aws_backends.rb
new file mode 100644
index 0000000..745bb0f
--- /dev/null
+++ b/db/migrate/20180410192412_add_efs_file_system_id_to_terraform_aws_backends.rb
@@ -0,0 +1,5 @@
+class AddEfsFileSystemIdToTerraformAwsBackends < ActiveRecord::Migration[5.1]
+  def change
+    add_column :terraform_aws_backends, :efs_file_system_id, :string, null: false
+  end
+end
diff --git a/db/migrate/20180417195307_add_vpc_id_to_terraform_aws_backends.rb b/db/migrate/20180417195307_add_vpc_id_to_terraform_aws_backends.rb
new file mode 100644
index 0000000..d1c176d
--- /dev/null
+++ b/db/migrate/20180417195307_add_vpc_id_to_terraform_aws_backends.rb
@@ -0,0 +1,5 @@
+class AddVpcIdToTerraformAwsBackends < ActiveRecord::Migration[5.1]
+  def change
+    add_column :terraform_aws_backends, :vpc_id, :string, null: false
+  end
+end
diff --git a/db/structure.sql b/db/structure.sql
index 602948d..0d56576 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -183,7 +183,10 @@ CREATE TABLE public.terraform_aws_backends (
     aws_secret_access_key character varying,
     created_at timestamp without time zone NOT NULL,
     updated_at timestamp without time zone NOT NULL,
-    domain character varying
+    domain character varying,
+    route_53_zone_id character varying NOT NULL,
+    efs_file_system_id character varying NOT NULL,
+    vpc_id character varying NOT NULL
 );
 
 
@@ -495,6 +498,9 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('20180329035512'),
 ('20180406082851'),
 ('20180406123612'),
-('20180406124443');
+('20180406124443'),
+('20180410192329'),
+('20180410192412'),
+('20180417195307');
 
 
-- 
cgit v1.2.3