Upcoming database changes RELEASE 08 July 2024

-ActiveRecord::Schema[7.0].define(version: 2024_06_04_121909) do
+ActiveRecord::Schema[7.0].define(version: 2024_07_01_075958) do
   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
   enable_extension "hstore"
@@ -833,6 +833,7 @@
     t.index ["contactable_type", "contactable_id"], name: "index_contacts_on_contactable_type_and_contactable_id"
     t.index ["created_by_id"], name: "index_contacts_on_created_by_id"
     t.index ["deleted_at"], name: "index_contacts_on_deleted_at"
+    t.index ["marketo_lead_id"], name: "index_contacts_on_marketo_lead_id"
     t.index ["status"], name: "index_contacts_on_status"
   end
 
@@ -1045,6 +1046,7 @@
     t.integer "thread_id"
     t.index ["emailable_id"], name: "index_emails_on_emailable_id"
     t.index ["emailable_type"], name: "index_emails_on_emailable_type"
+    t.index ["marketo_guid"], name: "index_emails_on_marketo_guid"
     t.index ["message_id"], name: "index_emails_on_message_id"
     t.index ["reminder_id"], name: "index_emails_on_reminder_id"
     t.index ["thread_id"], name: "index_emails_on_thread_id"
@@ -1727,7 +1729,9 @@
     t.bigint "site_id"
     t.boolean "gp_approved", default: false
     t.boolean "final_report_approved", default: false
+    t.bigint "managed_by_id"
     t.index ["case_number"], name: "index_jobseeker_decisions_on_case_number"
+    t.index ["managed_by_id"], name: "index_jobseeker_decisions_on_managed_by_id"
     t.index ["site_id"], name: "index_jobseeker_decisions_on_site_id"
     t.index ["stream_participant_id"], name: "index_jobseeker_decisions_on_stream_participant_id"
   end
@@ -1790,6 +1794,7 @@
     t.index ["lead_stage_id"], name: "index_jobseeker_leads_on_lead_stage_id"
     t.index ["lead_sub_stage_id"], name: "index_jobseeker_leads_on_lead_sub_stage_id"
     t.index ["lead_substatus_id"], name: "index_jobseeker_leads_on_lead_substatus_id"
+    t.index ["marketo_lead_id"], name: "index_jobseeker_leads_on_marketo_lead_id"
     t.index ["referral_source_id"], name: "index_jobseeker_leads_on_referral_source_id"
     t.index ["sub_source_type", "sub_source_id"], name: "index_jobseeker_leads_on_sub_source_type_and_sub_source_id"
   end
@@ -2039,6 +2044,7 @@
     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"
+    t.index ["marketo_lead_id"], name: "index_jobseekers_on_marketo_lead_id"
     t.index ["period_of_service_overridden_by_id"], name: "index_jobseekers_on_period_of_service_overridden_by_id"
     t.index ["programme"], name: "index_jobseekers_on_programme"
     t.index ["referring_company_id"], name: "index_jobseekers_on_referring_company_id"
@@ -2451,6 +2457,8 @@
     t.boolean "december", default: false
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
+    t.bigint "jobseeker_decision_id"
+    t.index ["jobseeker_decision_id"], name: "index_peppol_periodic_reports_on_jobseeker_decision_id"
     t.index ["jobseeker_id"], name: "index_peppol_periodic_reports_on_jobseeker_id"
   end
 
@@ -4039,6 +4047,7 @@
     t.string "personal_number"
     t.boolean "can_manage_calendar_templates", default: false, null: false
     t.boolean "can_edit_suppliers", default: false
+    t.boolean "can_contact_jr_support", default: 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"
@@ -4497,6 +4506,7 @@
   add_foreign_key "jobseeker_action_plans", "jobseekers"
   add_foreign_key "jobseeker_decisions", "sites"
   add_foreign_key "jobseeker_decisions", "stream_participants"
+  add_foreign_key "jobseeker_decisions", "users", column: "managed_by_id"
   add_foreign_key "jobseeker_goals", "goals"
   add_foreign_key "jobseeker_goals", "jobseekers"
   add_foreign_key "jobseeker_goals", "users", column: "created_by_id"