Upcoming database changes RELEASE 02 April 2024

-ActiveRecord::Schema[7.0].define(version: 2024_02_26_073439) do
+ActiveRecord::Schema[7.0].define(version: 2024_03_21_232429) do
   # These are extensions that must be enabled in order to support this database
@@ -1695,3 +1695,5 @@
     t.boolean "extension"
+    t.bigint "site_id"
     t.index ["case_number"], name: "index_jobseeker_decisions_on_case_number"
+    t.index ["site_id"], name: "index_jobseeker_decisions_on_site_id"
     t.index ["stream_participant_id"], name: "index_jobseeker_decisions_on_stream_participant_id"
@@ -3228,9 +3230,7 @@

-  create_table "role_to_role_permissions", force: :cascade do |t|
-    t.bigint "role_id"
-    t.bigint "role_permission_id"
-    t.datetime "created_at", null: false
-    t.datetime "updated_at", null: false
-    t.index ["role_id"], name: "index_role_to_role_permissions_on_role_id"
-    t.index ["role_permission_id"], name: "index_role_to_role_permissions_on_role_permission_id"
+  create_table "role_permissions_roles", id: false, force: :cascade do |t|
+    t.bigint "role_id", null: false
+    t.bigint "role_permission_id", null: false
+    t.index ["role_id", "role_permission_id"], name: "index_role_permissions_roles_on_role_id_and_role_permission_id"
+    t.index ["role_permission_id", "role_id"], name: "index_role_permissions_roles_on_role_permission_id_and_role_id"
   end
@@ -3244,2 +3244,8 @@

+  create_table "roles_users", id: false, force: :cascade do |t|
+    t.bigint "role_id", null: false
+    t.bigint "user_id", null: false
+    t.index ["role_id", "user_id"], name: "index_roles_users_on_role_id_and_user_id"
+  end
+
   create_table "saved_searches", id: :serial, force: :cascade do |t|
@@ -3960,2 +3966,3 @@
     t.boolean "can_manage_calendar_templates", default: false, null: false
+    t.boolean "can_edit_suppliers", default: false
     t.index ["active"], name: "index_users_on_active"
@@ -4413,2 +4420,3 @@
   add_foreign_key "jobseeker_action_plans", "jobseekers"
+  add_foreign_key "jobseeker_decisions", "sites"
   add_foreign_key "jobseeker_decisions", "stream_participants"
@@ -4499,4 +4507,2 @@
   add_foreign_key "requested_signature_histories", "users", column: "requested_by_id"
-  add_foreign_key "role_to_role_permissions", "role_permissions"
-  add_foreign_key "role_to_role_permissions", "roles"
   add_foreign_key "scanned_document_images", "scanned_documents"