Add extra fields to the Terraform AWS backend

4 files changed, 23 insertions, 2 deletions

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');