Upcoming database changes RELEASE 26 October 2023

-ActiveRecord::Schema[7.0].define(version: 2023_09_28_061450) do
+ActiveRecord::Schema[7.0].define(version: 2023_10_12_073203) do
   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
   enable_extension "hstore"
@@ -657,6 +657,7 @@
     t.bigint "employer_status_id"
     t.string "better_proposal_company_identifier"
     t.boolean "unsubscribed_from_bulk_emails", default: false
+    t.string "address_city"
     t.index ["account_manager_id"], name: "index_companies_on_account_manager_id"
     t.index ["activity_status"], name: "index_companies_on_activity_status"
     t.index ["address_postcode"], name: "index_companies_on_address_postcode"
@@ -1536,16 +1537,16 @@
   end

   create_table "individual_development_schedules", force: :cascade do |t|
-    t.integer "stream_participant_id", null: false
-    t.integer "jobseeker_id", null: false
+    t.integer "stream_participant_id"
+    t.integer "jobseeker_id"
     t.integer "created_by_id", null: false
     t.integer "individual_development_schedule_template_id"
-    t.datetime "starts_at"
-    t.datetime "ends_at"
+    t.datetime "starts_at", precision: nil
+    t.datetime "ends_at", precision: nil
     t.text "title"
     t.text "description"
-    t.datetime "created_at", precision: 6, null: false
-    t.datetime "updated_at", precision: 6, null: false
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
     t.string "location"
     t.boolean "is_remote", default: false
     t.boolean "is_onsite", default: false
@@ -1939,6 +1940,7 @@
     t.string "residential_address_city"
     t.string "postal_address_county"
     t.string "postal_address_city"
+    t.boolean "share_individual_development_plan", default: false
     t.index ["deleted_at"], name: "index_jobseekers_on_deleted_at"
     t.index ["ess_identifier"], name: "index_jobseekers_on_ess_identifier"
     t.index ["jobseeker_lead_id"], name: "index_jobseekers_on_jobseeker_lead_id"
@@ -3711,6 +3713,7 @@
     t.string "locale"
     t.boolean "can_send_sms", default: true, null: false
     t.boolean "ess_subs_admin", default: false, null: false
+    t.boolean "can_import_jobseekers", default: false, null: false
     t.index ["active"], name: "index_users_on_active"
     t.index ["confirmation_token"], name: "index_users_on_confirmation_token", unique: true
     t.index ["delegate_id"], name: "index_users_on_delegate_id"
@@ -3974,7 +3977,7 @@

   create_table "wage_subsidy_requests", force: :cascade do |t|
     t.bigint "jobseeker_id", null: false
-    t.bigint "placement_id", null: false
+    t.bigint "placement_id"
     t.bigint "wage_subsidy_agreement_id", null: false
     t.bigint "custom_expense_type_id"
     t.decimal "wage_subsidy_amount"
@@ -3998,8 +4001,11 @@
     t.string "previous_system_identifier"
     t.bigint "suggested_contact_id"
     t.bigint "wage_subsidy_end_reason_id"
+    t.bigint "company_id"
+    t.bigint "vacancy_id"
     t.index "((id)::text) text_pattern_ops", name: "index_wage_subsidy_requests_on_cast_id_as_text"
     t.index ["cancelled_by_id"], name: "index_wage_subsidy_requests_on_cancelled_by_id"
+    t.index ["company_id"], name: "index_wage_subsidy_requests_on_company_id"
     t.index ["custom_expense_type_id"], name: "index_wage_subsidy_requests_on_custom_expense_type_id"
     t.index ["ended_by_id"], name: "index_wage_subsidy_requests_on_ended_by_id"
     t.index ["first_approved_by_id"], name: "index_wage_subsidy_requests_on_first_approved_by_id"
@@ -4009,6 +4015,7 @@
     t.index ["requested_by_id"], name: "index_wage_subsidy_requests_on_requested_by_id"
     t.index ["second_approved_by_id"], name: "index_wage_subsidy_requests_on_second_approved_by_id"
     t.index ["suggested_contact_id"], name: "index_wage_subsidy_requests_on_suggested_contact_id"
+    t.index ["vacancy_id"], name: "index_wage_subsidy_requests_on_vacancy_id"
     t.index ["wage_subsidy_agreement_id"], name: "index_wage_subsidy_requests_on_wage_subsidy_agreement_id"
     t.index ["wage_subsidy_end_reason_id"], name: "index_wage_subsidy_requests_on_wage_subsidy_end_reason_id"
   end
@@ -4270,6 +4277,7 @@
   add_foreign_key "wage_subsidy_payment_schedules", "users", column: "created_by_id"
   add_foreign_key "wage_subsidy_payment_schedules", "wage_subsidy_payment_schedule_templates"
   add_foreign_key "wage_subsidy_payment_schedules", "wage_subsidy_requests"
+  add_foreign_key "wage_subsidy_requests", "companies"
   add_foreign_key "wage_subsidy_requests", "custom_expense_types"
   add_foreign_key "wage_subsidy_requests", "jobseekers"
   add_foreign_key "wage_subsidy_requests", "placements"
@@ -4279,6 +4287,7 @@
   add_foreign_key "wage_subsidy_requests", "users", column: "rejected_by_id"
   add_foreign_key "wage_subsidy_requests", "users", column: "requested_by_id"
   add_foreign_key "wage_subsidy_requests", "users", column: "second_approved_by_id"
+  add_foreign_key "wage_subsidy_requests", "vacancies"
   add_foreign_key "wage_subsidy_requests", "wage_subsidy_agreements"
   add_foreign_key "wage_subsidy_requests", "wage_subsidy_end_reasons"
   add_foreign_key "widget_configurations", "users"
   end