aboutsummaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2019-01-06 11:27:50 +0000
committerChristopher Baines <mail@cbaines.net>2019-01-06 11:55:15 +0000
commit503ad56e7aeae6050ef98477b3a60f6b4c9f59cf (patch)
treedcb700d7c33b7300d5d86ebf480dd486dcf67c24 /db
parent1c097bf9041939b286c1d2f764f65bcf017cd117 (diff)
downloadgovuk-mini-environment-admin-503ad56e7aeae6050ef98477b3a60f6b4c9f59cf.tar
govuk-mini-environment-admin-503ad56e7aeae6050ef98477b3a60f6b4c9f59cf.tar.gz
Add support for archiving mini environments
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20190106112141_add_archived_to_mini_environment.rb5
-rw-r--r--db/structure.sql6
2 files changed, 9 insertions, 2 deletions
diff --git a/db/migrate/20190106112141_add_archived_to_mini_environment.rb b/db/migrate/20190106112141_add_archived_to_mini_environment.rb
new file mode 100644
index 0000000..75527a7
--- /dev/null
+++ b/db/migrate/20190106112141_add_archived_to_mini_environment.rb
@@ -0,0 +1,5 @@
+class AddArchivedToMiniEnvironment < ActiveRecord::Migration[5.2]
+ def change
+ add_column :mini_environments, :archived, :boolean, default: false, null: false
+ end
+end
diff --git a/db/structure.sql b/db/structure.sql
index f766762..5e5aaba 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -338,7 +338,8 @@ CREATE TABLE public.mini_environments (
backend_id bigint,
backend_data jsonb,
signon_users jsonb,
- data_snapshot_id bigint
+ data_snapshot_id bigint,
+ archived boolean DEFAULT false NOT NULL
);
@@ -877,6 +878,7 @@ INSERT INTO "schema_migrations" (version) VALUES
('20180603120426'),
('20180621065525'),
('20180621220505'),
-('20180623083735');
+('20180623083735'),
+('20190106112141');