From 9649f88d2857e686c59867031aaad228cc4358fa Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Mon, 26 Mar 2018 22:09:43 +0100 Subject: Add a new signon_users field to MiniEnvironment To store the data regarding the Signon users seeded in the database. Store this as JSON, rather than data in different tables to simplify the schema, as I don't expect it to change at all once the MiniEnvironment is created. --- db/migrate/20180326201857_add_signon_users_to_mini_environment.rb | 5 +++++ db/schema.rb | 3 ++- 2 files changed, 7 insertions(+), 1 deletion(-) create mode 100644 db/migrate/20180326201857_add_signon_users_to_mini_environment.rb (limited to 'db') diff --git a/db/migrate/20180326201857_add_signon_users_to_mini_environment.rb b/db/migrate/20180326201857_add_signon_users_to_mini_environment.rb new file mode 100644 index 0000000..b78e3c9 --- /dev/null +++ b/db/migrate/20180326201857_add_signon_users_to_mini_environment.rb @@ -0,0 +1,5 @@ +class AddSignonUsersToMiniEnvironment < ActiveRecord::Migration[5.1] + def change + add_column :mini_environments, :signon_users, :jsonb + end +end diff --git a/db/schema.rb b/db/schema.rb index 59427c0..5c53432 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -10,7 +10,7 @@ # # It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(version: 20180311125615) do +ActiveRecord::Schema.define(version: 20180326201857) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" @@ -38,6 +38,7 @@ ActiveRecord::Schema.define(version: 20180311125615) do t.string "backend_type" t.bigint "backend_id" t.jsonb "backend_data" + t.jsonb "signon_users" t.index ["backend_type", "backend_id"], name: "index_mini_environments_on_backend_type_and_backend_id" t.index ["govuk_guix_revision_id"], name: "index_mini_environments_on_govuk_guix_revision_id" end -- cgit v1.2.3