-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