Upcoming database changes RELEASE 14 March 2024

-ActiveRecord::Schema[7.0].define(version: 2024_02_26_020034) do
+ActiveRecord::Schema[7.0].define(version: 2024_02_26_073439) do
   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
   enable_extension "hstore"
@@ -3219,6 +3219,29 @@ create_table "reverse_marketing_activity_results", force: :cascade do |t|
     t.index ["result"], name: "index_reverse_marketing_activity_results_on_result", unique: true
   end

+  create_table "role_permissions", force: :cascade do |t|
+    t.string "key", null: false
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+    t.index ["key"], name: "index_role_permissions_on_key", unique: true
+  end
+
+  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"
+  end
+
+  create_table "roles", force: :cascade do |t|
+    t.string "name", null: false
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+    t.index ["name"], name: "index_roles_on_name", unique: true
+  end
+
   create_table "saved_searches", id: :serial, force: :cascade do |t|
     t.integer "user_id", null: false
     t.text "resource_type", null: false
@@ -3664,6 +3687,7 @@ create_table "superset_dashboards", force: :cascade do |t|
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
     t.boolean "enabled", default: true, null: false
+    t.jsonb "dashboard_ui_config", default: {"hideTab"=>false, "hideTitle"=>false, "filtersVisible"=>true, "filtersExpanded"=>true, "hideChartControls"=>true}, null: false
   end

   create_table "supplier_purchase_orders", id: :serial, force: :cascade do |t|
@@ -4473,6 +4497,8 @@ create_table "work_for_doles", force: :cascade do |t|
   add_foreign_key "requested_signature_histories", "jobseekers"
   add_foreign_key "requested_signature_histories", "placements"
   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"
   add_foreign_key "scanned_documents", "batches"
   add_foreign_key "short_messages", "reminders"
   end

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.