Upcoming database changes RELEASE 06 September 2022

-ActiveRecord::Schema.define(version: 2022_08_24_041453) do
+ActiveRecord::Schema.define(version: 2022_08_24_223247) do

   enable_extension "citext"
@@ -1258,7 +1258,7 @@
     t.boolean "apply_break", default: false, null: false
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
-    t.string "stage"
+    t.string "stage", default: [], array: true
     t.date "start_date"
     t.date "end_date"
     t.decimal "overridden_ess_result"
@@ -2070,9 +2070,17 @@
     t.string "qualification_type", null: false
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
+    t.string "authority"
+    t.string "qualification_details"
     t.index ["user_id"], name: "index_professional_service_staff_on_user_id"
   end

+  create_table "professional_service_staff_programs", id: false, force: :cascade do |t|
+    t.bigint "professional_service_staff_id", null: false
+    t.bigint "program_id", null: false
+    t.index ["professional_service_staff_id", "program_id"], name: "index_professional_service_staff_id_program_id"
+  end
+
   create_table "program_referral_justification_templates", force: :cascade do |t|
     t.string "name", null: false
     t.text "content", null: false
@@ -2839,6 +2847,8 @@
     t.string "encrypted_imap_password_iv"
     t.string "imap_email"
     t.json "imap_fetch_progress_tracking", default: {}, null: false
+    t.string "smtp_server_type", default: "other"
+    t.string "ses_configuration_set"
   end