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.

2 files changed, 7 insertions, 1 deletions

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