Space

rails generate migration remove_unused_indexes

And paste

remove_index :sync_jobs, name: "sync_jobs_createdAt_idx"
remove_index :sync_jobs, name: "sync_jobs_integrationId_idx"
remove_index :expense_category_link, name: "idx_ecl_expense"
remove_index :expense, name: "idx_expense_created"
remove_index :expense, name: "idx_expense_expense_date"
remove_index :access_groups, name: "access_groups_groupType_idx"
remove_index :access_groups, name: "access_groups_platform_idx"
remove_index :access_reviews, name: "access_reviews_accountId_idx"
remove_index :access_reviews, name: "access_reviews_nextReviewDate_idx"
remove_index :access_reviews, name: "access_reviews_status_idx"
remove_index :account_group_memberships, name: "account_group_memberships_accountId_idx"
remove_index :account_group_memberships, name: "account_group_memberships_groupId_idx"
remove_index :account, name: "account_provider_idx"
remove_index :account, name: "account_userId_idx"
remove_index :account, name: "account_userId_idx"
remove_index :account, name: "account_userId_idx"
remove_index :account, name: "account_user_id_idx"
remove_index :account, name: "account_user_id_idx"
remove_index :activity_log, name: "activity_log_action_idx"
remove_index :activity_log, name: "activity_log_action_idx"
remove_index :activity_log, name: "activity_log_created_at_idx"
remove_index :activity_log, name: "activity_log_created_at_idx"
remove_index :activity_log, name: "activity_log_entity_id_idx"
remove_index :activity_log, name: "activity_log_entity_id_idx"
remove_index :activity_log, name: "activity_log_entity_type_idx"
remove_index :activity_log, name: "activity_log_entity_type_idx"
remove_index :activity_log, name: "activity_log_staff_id_idx"
remove_index :activity_log, name: "activity_log_staff_id_idx"
remove_index :activity_log, name: "activity_log_user_id_idx"
remove_index :activity_log, name: "activity_log_user_id_idx"
remove_index :appraisals, name: "appraisals_cycleid_idx"
remove_index :appraisals, name: "appraisals_scheduledDate_idx"
remove_index :appraisals, name: "appraisals_scheduleddate_idx"
remove_index :appraisals, name: "appraisals_staffProfileId_idx"
remove_index :appraisals, name: "appraisals_staffprofileid_idx"
remove_index :appraisals, name: "appraisals_status_idx"
remove_index :on_call_assignments, name: "assignments_scheduleId_idx"
remove_index :on_call_assignments, name: "assignments_staffId_idx"
remove_index :audit_logs, name: "audit_logs_actorId_idx"
remove_index :audit_logs, name: "audit_logs_correlationId_idx"
remove_index :audit_logs, name: "audit_logs_createdAt_idx"
remove_index :audit_logs, name: "audit_logs_module_idx"
remove_index :audit_logs, name: "audit_logs_resource_idx"
remove_index :client, name: "client_display_name_idx"
remove_index :client, name: "client_display_name_idx"
remove_index :client, name: "client_email_idx"
remove_index :client, name: "client_email_idx"
remove_index :client, name: "client_primary_staff_idx"
remove_index :client, name: "client_primary_staff_idx"
remove_index :client_service_selection, name: "client_service_selection_business_idx"
remove_index :client_service_selection, name: "client_service_selection_business_idx"
remove_index :client_service_selection, name: "client_service_selection_client_id_idx"
remove_index :client_service_selection, name: "client_service_selection_client_id_idx"
remove_index :client_service_selection, name: "client_service_selection_service_code_idx"
remove_index :client_service_selection, name: "client_service_selection_service_code_idx"
remove_index :client_service_selection, name: "client_service_selection_status_idx"
remove_index :client_service_selection, name: "client_service_selection_status_idx"
remove_index :client, name: "client_status_idx"
remove_index :client, name: "client_status_idx"
remove_index :client, name: "client_tin_idx"
remove_index :client, name: "client_tin_idx"
remove_index :client, name: "client_type_idx"
remove_index :client, name: "client_type_idx"
remove_index :contracts, name: "contracts_endDate_idx"
remove_index :contracts, name: "contracts_staffProfileId_idx"
remove_index :contracts, name: "contracts_status_idx"
remove_index :cycle_work_items, name: "cycle_work_items_cycleId_idx"
remove_index :cycle_work_items, name: "cycle_work_items_workItemId_idx"
remove_index :cycles, name: "cycles_departmentId_idx"
remove_index :cycles, name: "cycles_startDate_idx"
remove_index :cycles, name: "cycles_status_idx"
remove_index :directus_activity, name: "directus_activity_timestamp_index"
remove_index :directus_revisions, name: "directus_revisions_activity_index"
remove_index :directus_revisions, name: "directus_revisions_parent_index"
remove_index :document, name: "document_category_idx"
remove_index :document, name: "document_category_idx"
remove_index :document, name: "document_client_id_idx"
remove_index :document, name: "document_client_id_idx"
remove_index :document, name: "document_expiration_date_idx"
remove_index :document, name: "document_expiration_date_idx"
remove_index :document, name: "document_is_backed_up_idx"
remove_index :document, name: "document_is_backed_up_idx"
remove_index :document, name: "document_matter_id_idx"
remove_index :document, name: "document_matter_id_idx"
remove_index :document, name: "document_status_idx"
remove_index :document, name: "document_status_idx"
remove_index :document_template, name: "document_template_business_idx"
remove_index :document_template, name: "document_template_business_idx"
remove_index :document_template, name: "document_template_category_idx"
remove_index :document_template, name: "document_template_category_idx"
remove_index :document_template, name: "document_template_is_active_idx"
remove_index :document_template, name: "document_template_is_active_idx"
remove_index :document, name: "document_uploaded_by_idx"
remove_index :document, name: "document_uploaded_by_idx"
remove_index :external_contacts, name: "external_contacts_affiliationType_idx"
remove_index :external_contacts, name: "external_contacts_email_idx"
remove_index :audit_log, name: "idx_audit_log_action_type"
remove_index :audit_log, name: "idx_audit_log_created"
remove_index :audit_log, name: "idx_audit_log_entity_id"
remove_index :audit_log, name: "idx_audit_log_entity_type"
remove_index :audit_log, name: "idx_audit_log_location"
remove_index :audit_log, name: "idx_audit_log_user"
remove_index :netsurf_bookings, name: "idx_bookings_cabin_dates"
remove_index :netsurf_bookings, name: "idx_bookings_status"
remove_index :netsurf_bookings, name: "idx_bookings_stay_type"
remove_index :budget, name: "idx_budget_org"
remove_index :budget, name: "idx_budget_period"
remove_index :budget, name: "idx_budget_status"
remove_index :cash_drop, name: "idx_cash_drop_session"
remove_index :cash_payout, name: "idx_cash_payout_session"
remove_index :cash_session, name: "idx_cash_session_location"
remove_index :cash_session, name: "idx_cash_session_register"
remove_index :cash_session, name: "idx_cash_session_status"
remove_index :combo_component, name: "idx_combo_component_combo"
remove_index :combo_product, name: "idx_combo_product_product"
remove_index :credit_note, name: "idx_credit_note_customer"
remove_index :credit_note, name: "idx_credit_note_invoice"
remove_index :credit_note, name: "idx_credit_note_number"
remove_index :credit_note, name: "idx_credit_note_org"
remove_index :credit_note, name: "idx_credit_note_status"
remove_index :custom_role, name: "idx_custom_role_org"
remove_index :customer, name: "idx_customer_email"
remove_index :customer, name: "idx_customer_org"
remove_index :customer, name: "idx_customer_phone"
remove_index :customer_pricelist, name: "idx_customer_pricelist_cust"
remove_index :discount_rule, name: "idx_discount_rule_org"
remove_index :discount_rule, name: "idx_discount_rule_promo"
remove_index :expense_category_link, name: "idx_ecl_category"
remove_index :expense, name: "idx_expense_billable_uninvoiced"
remove_index :expense_category, name: "idx_expense_category_org"
remove_index :expense, name: "idx_expense_funding_source"
remove_index :expense, name: "idx_expense_org"
remove_index :expense, name: "idx_expense_session"
remove_index :expense, name: "idx_expense_supplier"
remove_index :finance_audit_event, name: "idx_finance_audit_org_entity"
remove_index :finance_audit_event, name: "idx_finance_audit_performed_at"
remove_index :funding_source, name: "idx_funding_source_org"
remove_index :gift_card, name: "idx_gift_card_code"
remove_index :gift_card, name: "idx_gift_card_org"
remove_index :gift_card_transaction, name: "idx_gift_card_txn_card"
remove_index :inventory_item, name: "idx_inventory_item_org"
remove_index :inventory_item, name: "idx_inventory_item_sku"
remove_index :inventory_item, name: "idx_inventory_item_supplier"
remove_index :invoice, name: "idx_invoice_created"
remove_index :invoice, name: "idx_invoice_customer"
remove_index :invoice, name: "idx_invoice_number"
remove_index :invoice, name: "idx_invoice_org"
remove_index :invoice_payment, name: "idx_invoice_payment_date"
remove_index :invoice_payment, name: "idx_invoice_payment_invoice"
remove_index :invoice_payment, name: "idx_invoice_payment_org"
remove_index :invoice, name: "idx_invoice_status"
remove_index :kitchen_order_item, name: "idx_koi_status"
remove_index :kitchen_order_item, name: "idx_koi_ticket"
remove_index :kitchen_order_ticket, name: "idx_kot_location"
remove_index :kitchen_order_ticket, name: "idx_kot_order"
remove_index :kitchen_order_ticket, name: "idx_kot_station"
remove_index :kitchen_order_ticket, name: "idx_kot_status"
remove_index :location, name: "idx_location_org"
remove_index :loyalty_tier, name: "idx_loyalty_tier_program"
remove_index :loyalty_transaction, name: "idx_loyalty_txn_customer"
remove_index :loyalty_transaction, name: "idx_loyalty_txn_order"
remove_index :menu_schedule, name: "idx_menu_schedule_org"
remove_index :modifier, name: "idx_modifier_group"
remove_index :modifier_group, name: "idx_modifier_group_org"
remove_index :notification_log, name: "idx_notification_log_created"
remove_index :notification_log, name: "idx_notification_log_org"
remove_index :notification_log, name: "idx_notification_log_status"
remove_index :notification_template, name: "idx_notification_template_event"
remove_index :notification_template, name: "idx_notification_template_org"
remove_index :order, name: "idx_order_created"
remove_index :order_line_item, name: "idx_order_line_item_order"
remove_index :order_line_item, name: "idx_order_line_item_product"
remove_index :order, name: "idx_order_location"
remove_index :order, name: "idx_order_org"
remove_index :order, name: "idx_order_register"
remove_index :order, name: "idx_order_status"
remove_index :order, name: "idx_order_user"
remove_index :payment, name: "idx_payment_method"
remove_index :payment, name: "idx_payment_order"
remove_index :pin_login_rate_limit, name: "idx_pin_login_rate_limit_locked_until"
remove_index :pin_login_rate_limit, name: "idx_pin_login_rate_limit_updated_at"
remove_index :purchase_order_line, name: "idx_po_line_po"
remove_index :pricelist, name: "idx_pricelist_org"
remove_index :product_production_component, name: "idx_prod_component_product"
remove_index :product_barcode, name: "idx_product_barcode_product"
remove_index :netsurf_product_categories, name: "idx_product_categories_sort_order"
remove_index :product, name: "idx_product_category"
remove_index :product, name: "idx_product_org"
remove_index :product, name: "idx_product_protein_category"
remove_index :product, name: "idx_product_sku"
remove_index :production_log, name: "idx_production_log_date"
remove_index :production_log, name: "idx_production_log_entry_type"
remove_index :production_log, name: "idx_production_log_location"
remove_index :production_log, name: "idx_production_log_product"
remove_index :netsurf_products, name: "idx_products_category_active"
remove_index :netsurf_products, name: "idx_products_track_stock"
remove_index :purchase_order, name: "idx_purchase_order_org"
remove_index :purchase_order, name: "idx_purchase_order_status"
remove_index :purchase_order, name: "idx_purchase_order_supplier"
remove_index :quotation, name: "idx_quotation_created"
remove_index :quotation, name: "idx_quotation_customer"
remove_index :quotation, name: "idx_quotation_number"
remove_index :quotation, name: "idx_quotation_org"
remove_index :quotation, name: "idx_quotation_status"
remove_index :receipt_config, name: "idx_receipt_config_org"
remove_index :recipe_ingredient, name: "idx_recipe_ingredient_item"
remove_index :recipe_ingredient, name: "idx_recipe_ingredient_product"
remove_index :recurring_template, name: "idx_recurring_template_active"
remove_index :recurring_template, name: "idx_recurring_template_next_run"
remove_index :recurring_template, name: "idx_recurring_template_org"
remove_index :refund, name: "idx_refund_order"
remove_index :refund, name: "idx_refund_original_order"
remove_index :register, name: "idx_register_location"
remove_index :reporting_category, name: "idx_reporting_category_org"
remove_index :netsurf_sale_items, name: "idx_sale_items_sale_id"
remove_index :netsurf_sale_payments, name: "idx_sale_payments_sale_id"
remove_index :netsurf_sales, name: "idx_sales_created_at"
remove_index :netsurf_sales, name: "idx_sales_voided_created_at"
remove_index :stock_alert, name: "idx_stock_alert_item"
remove_index :stock_alert, name: "idx_stock_alert_org"
remove_index :stock_count_line, name: "idx_stock_count_line_count"
remove_index :stock_count, name: "idx_stock_count_location"
remove_index :stock_count, name: "idx_stock_count_org"
remove_index :stock_ledger, name: "idx_stock_ledger_created"
remove_index :stock_ledger, name: "idx_stock_ledger_item"
remove_index :stock_ledger, name: "idx_stock_ledger_location"
remove_index :netsurf_stock_movements, name: "idx_stock_movements_product_created_at"
remove_index :supplier, name: "idx_supplier_org"
remove_index :table_layout, name: "idx_table_layout_floor"
remove_index :table_layout, name: "idx_table_layout_location"
remove_index :table_layout, name: "idx_table_layout_status"
remove_index :tax_rate, name: "idx_tax_rate_org"
remove_index :time_entry, name: "idx_time_entry_org"
remove_index :time_entry, name: "idx_time_entry_user"
remove_index :user_role, name: "idx_user_role_role"
remove_index :user_role, name: "idx_user_role_user"
remove_index :vendor_bill, name: "idx_vendor_bill_due"
remove_index :vendor_bill, name: "idx_vendor_bill_number"
remove_index :vendor_bill, name: "idx_vendor_bill_org"
remove_index :vendor_bill_payment, name: "idx_vendor_bill_payment_bill"
remove_index :vendor_bill_payment, name: "idx_vendor_bill_payment_date"
remove_index :vendor_bill_payment, name: "idx_vendor_bill_payment_org"
remove_index :vendor_bill, name: "idx_vendor_bill_status"
remove_index :vendor_bill, name: "idx_vendor_bill_supplier"
remove_index :waste_log, name: "idx_waste_log_created"
remove_index :waste_log, name: "idx_waste_log_item"
remove_index :waste_log, name: "idx_waste_log_org"
remove_index :webhook_delivery, name: "idx_webhook_delivery_created"
remove_index :webhook_delivery, name: "idx_webhook_delivery_endpoint"
remove_index :webhook_endpoint, name: "idx_webhook_endpoint_org"
remove_index :rota_import_warnings, name: "import_warnings_status_idx"
remove_index :rota_import_warnings, name: "import_warnings_weekStart_idx"
remove_index :incident_timeline, name: "incident_timeline_incidentId_idx"
remove_index :incidents, name: "incidents_detectedAt_idx"
remove_index :incidents, name: "incidents_severity_idx"
remove_index :incidents, name: "incidents_status_idx"
remove_index :knowledge_base_download, name: "knowledge_base_download_client_id_idx"
remove_index :knowledge_base_download, name: "knowledge_base_download_client_id_idx"
remove_index :knowledge_base_download, name: "knowledge_base_download_downloaded_by_idx"
remove_index :knowledge_base_download, name: "knowledge_base_download_downloaded_by_idx"
remove_index :knowledge_base_download, name: "knowledge_base_download_item_id_idx"
remove_index :knowledge_base_download, name: "knowledge_base_download_item_id_idx"
remove_index :knowledge_base_item, name: "knowledge_base_item_business_idx"
remove_index :knowledge_base_item, name: "knowledge_base_item_business_idx"
remove_index :knowledge_base_item, name: "knowledge_base_item_category_idx"
remove_index :knowledge_base_item, name: "knowledge_base_item_category_idx"
remove_index :knowledge_base_item, name: "knowledge_base_item_is_active_idx"
remove_index :knowledge_base_item, name: "knowledge_base_item_is_active_idx"
remove_index :knowledge_base_item, name: "knowledge_base_item_is_featured_idx"
remove_index :knowledge_base_item, name: "knowledge_base_item_is_featured_idx"
remove_index :knowledge_base_item, name: "knowledge_base_item_is_staff_only_idx"
remove_index :knowledge_base_item, name: "knowledge_base_item_is_staff_only_idx"
remove_index :knowledge_base_item, name: "knowledge_base_item_type_idx"
remove_index :knowledge_base_item, name: "knowledge_base_item_type_idx"
remove_index :leave_requests, name: "leave_requests_dateRange_idx"
remove_index :leave_requests, name: "leave_requests_staffProfileId_idx"
remove_index :leave_requests, name: "leave_requests_status_idx"
remove_index :member, name: "member_organizationId_idx"
remove_index :member, name: "member_userId_idx"
remove_index :notifications, name: "notifications_createdAt_idx"
remove_index :notifications, name: "notifications_recipientId_status_idx"
remove_index :overlay_assignments, name: "overlay_assignments_scheduleId_idx"
remove_index :overlay_assignments, name: "overlay_assignments_staffId_idx"
remove_index :overlay_schedules, name: "overlay_schedules_quarter_year_idx"
remove_index :overlay_schedules, name: "overlay_schedules_typeId_idx"
remove_index :overlay_tasks, name: "overlay_tasks_dueDate_idx"
remove_index :overlay_tasks, name: "overlay_tasks_scheduleId_idx"
remove_index :overlay_tasks, name: "overlay_tasks_status_idx"
remove_index :password_setup_token, name: "password_setup_token_userId_idx"
remove_index :password_setup_token, name: "password_setup_token_userId_idx"
remove_index :platform_accounts, name: "platform_accounts_affiliationType_idx"
remove_index :platform_accounts, name: "platform_accounts_externalAccountId_idx"
remove_index :platform_accounts, name: "platform_accounts_externalContactId_idx"
remove_index :platform_accounts, name: "platform_accounts_isOrphaned_idx"
remove_index :platform_accounts, name: "platform_accounts_platform_idx"
remove_index :platform_accounts, name: "platform_accounts_staffProfileId_idx"
remove_index :platform_accounts, name: "platform_accounts_status_idx"
remove_index :platform_accounts, name: "platform_accounts_syncMode_idx"
remove_index :platform_accounts, name: "platform_accounts_vpnEnabled_idx"
remove_index :platform_integrations, name: "platform_integrations_platform_idx"
remove_index :platform_integrations, name: "platform_integrations_status_idx"
remove_index :policy_acknowledgements, name: "policy_acks_staffProfileId_idx"
remove_index :portal_invite, name: "portal_invite_client_id_idx"
remove_index :portal_invite, name: "portal_invite_client_id_idx"
remove_index :portal_invite, name: "portal_invite_email_idx"
remove_index :portal_invite, name: "portal_invite_email_idx"
remove_index :portal_invite, name: "portal_invite_expires_at_idx"
remove_index :portal_invite, name: "portal_invite_expires_at_idx"
remove_index :portal_invite, name: "portal_invite_status_idx"
remove_index :portal_invite, name: "portal_invite_status_idx"
remove_index :portal_invite, name: "portal_invite_token_idx"
remove_index :portal_invite, name: "portal_invite_token_idx"
remove_index :ppe_records, name: "ppe_records_expiryDate_idx"
remove_index :ppe_records, name: "ppe_records_staffProfileId_idx"
remove_index :purchase_requisitions, name: "pr_createdAt_idx"
remove_index :purchase_requisitions, name: "pr_departmentId_idx"
remove_index :purchase_requisitions, name: "pr_requestedById_idx"
remove_index :purchase_requisitions, name: "pr_status_idx"
remove_index :reconciliation_issues, name: "reconciliation_issues_integrationId_idx"
remove_index :reconciliation_issues, name: "reconciliation_issues_issueType_idx"
remove_index :reconciliation_issues, name: "reconciliation_issues_resolvedAt_idx"
remove_index :on_call_schedules, name: "schedules_status_idx"
remove_index :on_call_schedules, name: "schedules_weekStart_idx"
remove_index :service_catalog, name: "service_catalog_business_idx"
remove_index :service_catalog, name: "service_catalog_business_idx"
remove_index :service_catalog, name: "service_catalog_category_idx"
remove_index :service_catalog, name: "service_catalog_category_idx"
remove_index :service_catalog, name: "service_catalog_is_active_idx"
remove_index :service_catalog, name: "service_catalog_is_active_idx"
remove_index :service_catalog, name: "service_catalog_is_featured_idx"
remove_index :service_catalog, name: "service_catalog_is_featured_idx"
remove_index :service_catalog, name: "service_catalog_sort_order_idx"
remove_index :service_catalog, name: "service_catalog_sort_order_idx"
remove_index :service_category, name: "service_category_business_idx"
remove_index :service_category, name: "service_category_business_idx"
remove_index :service_category, name: "service_category_is_active_idx"
remove_index :service_category, name: "service_category_is_active_idx"
remove_index :service_category, name: "service_category_sort_order_idx"
remove_index :service_category, name: "service_category_sort_order_idx"
remove_index :session, name: "session_token_idx"
remove_index :session, name: "session_userId_idx"
remove_index :session, name: "session_userId_idx"
remove_index :session, name: "session_userId_idx"
remove_index :session, name: "session_userId_idx"
remove_index :session, name: "session_user_id_idx"
remove_index :session, name: "session_user_id_idx"
remove_index :staff_profiles, name: "staff_profiles_departmentId_idx"
remove_index :staff_profiles, name: "staff_profiles_teamleadid_idx"
remove_index :staff_profiles, name: "staff_profiles_userId_idx"
remove_index :staff, name: "staff_user_id_idx"
remove_index :staff, name: "staff_user_id_idx"
remove_index :system_backup, name: "system_backup_created_at_idx"
remove_index :system_backup, name: "system_backup_created_at_idx"
remove_index :system_backup, name: "system_backup_status_idx"
remove_index :system_backup, name: "system_backup_status_idx"
remove_index :system_backup, name: "system_backup_type_idx"
remove_index :system_backup, name: "system_backup_type_idx"
remove_index :tag, name: "tag_business_idx"
remove_index :tag, name: "tag_business_idx"
remove_index :tag, name: "tag_name_idx"
remove_index :tag, name: "tag_name_idx"
remove_index :temporary_changes, name: "temp_changes_category_idx"
remove_index :temporary_changes, name: "temp_changes_ownerId_idx"
remove_index :temporary_changes, name: "temp_changes_removeByDate_idx"
remove_index :temporary_changes, name: "temp_changes_riskLevel_idx"
remove_index :temporary_changes, name: "temp_changes_status_idx"
remove_index :training_records, name: "training_records_expiryDate_idx"
remove_index :training_records, name: "training_records_staffProfileId_idx"
remove_index :training_records, name: "training_records_status_idx"
remove_index :work_initiatives, name: "work_initiatives_departmentId_idx"
remove_index :work_initiatives, name: "work_initiatives_status_idx"
remove_index :work_items, name: "work_items_assignedToId_idx"
remove_index :work_items, name: "work_items_departmentId_idx"
remove_index :work_items, name: "work_items_dueDate_idx"
remove_index :work_items, name: "work_items_status_idx"
remove_index :work_items, name: "work_items_type_idx"
remove_index :account, name: "account_provider_idx"
remove_index :account, name: "account_userId_idx"
remove_index :account, name: "account_userId_idx"
remove_index :account, name: "account_user_id_idx"
remove_index :active_timer, name: "active_timer_matter_id_idx"
remove_index :active_timer, name: "active_timer_matter_id_idx"
remove_index :active_timer, name: "active_timer_staff_id_idx"
remove_index :active_timer, name: "active_timer_staff_id_idx"
remove_index :api_key, name: "apiKey_keyHash_idx"
remove_index :api_key, name: "apiKey_keyPrefix_idx"
remove_index :api_key, name: "apiKey_organizationId_idx"
remove_index :api_usage, name: "apiUsage_apiKeyId_idx"
remove_index :api_usage, name: "apiUsage_createdAt_idx"
remove_index :api_usage, name: "apiUsage_endpoint_idx"
remove_index :api_usage, name: "apiUsage_organizationId_idx"
remove_index :appointment, name: "appointment_appointment_type_id_idx"
remove_index :appointment, name: "appointment_appointment_type_id_idx"
remove_index :appointment, name: "appointment_assigned_staff_id_idx"
remove_index :appointment, name: "appointment_assigned_staff_id_idx"
remove_index :appointment, name: "appointment_business_idx"
remove_index :appointment, name: "appointment_business_idx"
remove_index :appointment, name: "appointment_client_id_idx"
remove_index :appointment, name: "appointment_client_id_idx"
remove_index :appointment, name: "appointment_is_public_booking_idx"
remove_index :appointment, name: "appointment_is_public_booking_idx"
remove_index :appointment, name: "appointment_matter_id_idx"
remove_index :appointment, name: "appointment_matter_id_idx"
remove_index :appointment, name: "appointment_public_booking_token_idx"
remove_index :appointment, name: "appointment_public_booking_token_idx"
remove_index :appointment_reminder, name: "appointment_reminder_appointment_id_idx"
remove_index :appointment_reminder, name: "appointment_reminder_appointment_id_idx"
remove_index :appointment_reminder, name: "appointment_reminder_is_sent_idx"
remove_index :appointment_reminder, name: "appointment_reminder_is_sent_idx"
remove_index :appointment_reminder, name: "appointment_reminder_scheduled_at_idx"
remove_index :appointment_reminder, name: "appointment_reminder_scheduled_at_idx"
remove_index :appointment, name: "appointment_scheduled_at_idx"
remove_index :appointment, name: "appointment_scheduled_at_idx"
remove_index :appointment, name: "appointment_status_idx"
remove_index :appointment, name: "appointment_status_idx"
remove_index :appointment_type, name: "appointment_type_business_idx"
remove_index :appointment_type, name: "appointment_type_business_idx"
remove_index :appointment_type, name: "appointment_type_is_active_idx"
remove_index :appointment_type, name: "appointment_type_is_active_idx"
remove_index :appointment_type, name: "appointment_type_public_booking_token_idx"
remove_index :appointment_type, name: "appointment_type_public_booking_token_idx"
remove_index :appraisal_cycles, name: "appraisal_cycles_departmentid_idx"
remove_index :appraisal_cycles, name: "appraisal_cycles_status_idx"
remove_index :appraisal_cycles, name: "appraisal_cycles_year_idx"
remove_index :appraisal_followups, name: "appraisal_followups_appraisalid_idx"
remove_index :appraisal_followups, name: "appraisal_followups_duedate_idx"
remove_index :attendance_exceptions, name: "attendance_exceptions_exceptiondate_idx"
remove_index :attendance_exceptions, name: "attendance_exceptions_leaverequestid_idx"
remove_index :attendance_exceptions, name: "attendance_exceptions_staff_date_idx"
remove_index :attendance_exceptions, name: "attendance_exceptions_staffprofileid_idx"
remove_index :attendance_exceptions, name: "attendance_exceptions_status_idx"
remove_index :audit_log, name: "auditLog_action_idx"
remove_index :audit_log, name: "auditLog_createdAt_idx"
remove_index :audit_log, name: "auditLog_entityType_entityId_idx"
remove_index :audit_log, name: "auditLog_organizationId_idx"
remove_index :audit_log, name: "auditLog_userId_idx"
remove_index :automation_rule_logs, name: "automation_rule_logs_firedAt_idx"
remove_index :automation_rule_logs, name: "automation_rule_logs_ruleId_idx"
remove_index :automation_rules, name: "automation_rules_enabled_idx"
remove_index :automation_rules, name: "automation_rules_module_event_idx"
remove_index :callouts, name: "callouts_calloutat_idx"
remove_index :callouts, name: "callouts_relatedincidentid_idx"
remove_index :callouts, name: "callouts_staffprofileid_idx"
remove_index :callouts, name: "callouts_status_idx"
remove_index :career_path_plans, name: "career_path_plans_status_idx"
remove_index :career_path_years, name: "career_path_years_planid_idx"
remove_index :client_aml_assessment, name: "client_aml_assessment_client_id_idx"
remove_index :client_aml_assessment, name: "client_aml_assessment_client_id_idx"
remove_index :client_aml_assessment, name: "client_aml_assessment_next_review_idx"
remove_index :client_aml_assessment, name: "client_aml_assessment_next_review_idx"
remove_index :client_aml_assessment, name: "client_aml_assessment_risk_rating_idx"
remove_index :client_aml_assessment, name: "client_aml_assessment_risk_rating_idx"
remove_index :client_aml_assessment, name: "client_aml_assessment_status_idx"
remove_index :client_aml_assessment, name: "client_aml_assessment_status_idx"
remove_index :client_beneficial_owner, name: "client_beneficial_owner_client_id_idx"
remove_index :client_beneficial_owner, name: "client_beneficial_owner_client_id_idx"
remove_index :client_beneficial_owner, name: "client_beneficial_owner_is_pep_idx"
remove_index :client_beneficial_owner, name: "client_beneficial_owner_is_pep_idx"
remove_index :client_beneficial_owner, name: "client_beneficial_owner_risk_level_idx"
remove_index :client_beneficial_owner, name: "client_beneficial_owner_risk_level_idx"
remove_index :client_communication, name: "client_communication_client_id_idx"
remove_index :client_communication, name: "client_communication_client_id_idx"
remove_index :client_communication, name: "client_communication_date_idx"
remove_index :client_communication, name: "client_communication_date_idx"
remove_index :client_communication, name: "client_communication_staff_id_idx"
remove_index :client_communication, name: "client_communication_staff_id_idx"
remove_index :client_contact, name: "client_contact_client_id_idx"
remove_index :client_contact, name: "client_contact_client_id_idx"
remove_index :client_emergency_contact, name: "client_emergency_contact_client_id_idx"
remove_index :client_emergency_contact, name: "client_emergency_contact_client_id_idx"
remove_index :client_emergency_contact, name: "client_emergency_contact_type_idx"
remove_index :client_emergency_contact, name: "client_emergency_contact_type_idx"
remove_index :client_employment_info, name: "client_employment_info_client_id_idx"
remove_index :client_employment_info, name: "client_employment_info_client_id_idx"
remove_index :client_employment_info, name: "client_employment_info_is_current_idx"
remove_index :client_employment_info, name: "client_employment_info_is_current_idx"
remove_index :client_employment_info, name: "client_employment_info_status_idx"
remove_index :client_employment_info, name: "client_employment_info_status_idx"
remove_index :client_link, name: "client_link_client_id_idx"
remove_index :client_link, name: "client_link_client_id_idx"
remove_index :client_link, name: "client_link_linked_client_id_idx"
remove_index :client_link, name: "client_link_linked_client_id_idx"
remove_index :customer_tag, name: "customerTag_name_idx"
remove_index :customer_tag, name: "customerTag_organizationId_idx"
remove_index :customer_to_tag, name: "customerToTag_customerId_idx"
remove_index :customer_to_tag, name: "customerToTag_tagId_idx"
remove_index :customer, name: "customer_email_idx"
remove_index :customer, name: "customer_name_idx"
remove_index :customer, name: "customer_organizationId_idx"
remove_index :deadline, name: "deadline_assigned_staff_idx"
remove_index :deadline, name: "deadline_assigned_staff_idx"
remove_index :deadline, name: "deadline_business_idx"
remove_index :deadline, name: "deadline_business_idx"
remove_index :deadline, name: "deadline_client_id_idx"
remove_index :deadline, name: "deadline_client_id_idx"
remove_index :deadline, name: "deadline_due_date_idx"
remove_index :deadline, name: "deadline_due_date_idx"
remove_index :deadline, name: "deadline_is_completed_idx"
remove_index :deadline, name: "deadline_is_completed_idx"
remove_index :deadline, name: "deadline_matter_id_idx"
remove_index :deadline, name: "deadline_matter_id_idx"
remove_index :deadline, name: "deadline_parent_id_idx"
remove_index :deadline, name: "deadline_parent_id_idx"
remove_index :deadline_reminder, name: "deadline_reminder_deadline_id_idx"
remove_index :deadline_reminder, name: "deadline_reminder_deadline_id_idx"
remove_index :deadline_reminder, name: "deadline_reminder_is_sent_idx"
remove_index :deadline_reminder, name: "deadline_reminder_is_sent_idx"
remove_index :deadline_reminder, name: "deadline_reminder_reminder_date_idx"
remove_index :deadline_reminder, name: "deadline_reminder_reminder_date_idx"
remove_index :deadline, name: "deadline_type_idx"
remove_index :deadline, name: "deadline_type_idx"
remove_index :department_assignment_history, name: "department_assignment_history_assignmentid_idx"
remove_index :department_assignment_history, name: "department_assignment_history_createdat_idx"
remove_index :department_assignments, name: "department_assignments_departmentid_idx"
remove_index :department_assignments, name: "department_assignments_isactive_idx"
remove_index :department_assignments, name: "department_assignments_role_idx"
remove_index :department_assignments, name: "department_assignments_staffprofileid_idx"
remove_index :document_verification, name: "document_verification_document_id_idx"
remove_index :document_verification, name: "document_verification_document_id_idx"
remove_index :document_verification, name: "document_verification_expiry_date_idx"
remove_index :document_verification, name: "document_verification_expiry_date_idx"
remove_index :document_verification, name: "document_verification_status_idx"
remove_index :document_verification, name: "document_verification_status_idx"
remove_index :email_report_history, name: "email_report_history_createdAt_idx"
remove_index :email_report_history, name: "email_report_history_organizationId_idx"
remove_index :email_report_history, name: "email_report_history_preferenceId_idx"
remove_index :email_report_history, name: "email_report_history_status_idx"
remove_index :email_report_history, name: "email_report_history_userId_idx"
remove_index :email_report_preference, name: "email_report_preference_frequency_idx"
remove_index :email_report_preference, name: "email_report_preference_isEnabled_idx"
remove_index :email_report_preference, name: "email_report_preference_organizationId_idx"
remove_index :email_report_preference, name: "email_report_preference_userId_idx"
remove_index :email_report_preference, name: "email_report_preference_userId_organizationId_idx"
remove_index :escalation_steps, name: "escalation_steps_policyId_idx"
remove_index :customer_feedback, name: "feedback_order_idx"
remove_index :customer_feedback, name: "feedback_org_idx"
remove_index :customer_feedback, name: "feedback_rating_idx"
remove_index :friendships, name: "friendships_addressee_idx"
remove_index :friendships, name: "friendships_requester_idx"
remove_index :assignment_history, name: "history_scheduleId_idx"
remove_index :assignment_history, name: "history_staffId_idx"
remove_index :agency, name: "idx_agency_name"
remove_index :agency, name: "idx_agency_org"
remove_index :netsurf_blocked_dates, name: "idx_blocked_cabin"
remove_index :cash_reconciliation_rule, name: "idx_cash_recon_rule_org"
remove_index :customer_payment_ledger, name: "idx_customer_payment_ledger_created"
remove_index :customer_payment_ledger, name: "idx_customer_payment_ledger_payment"
remove_index :customer_payment, name: "idx_customer_payment_org_customer"
remove_index :customer_payment, name: "idx_customer_payment_status"
remove_index :floor, name: "idx_floor_active"
remove_index :floor, name: "idx_floor_location"
remove_index :goods_receipt, name: "idx_goods_receipt_po"
remove_index :goods_receipt_line, name: "idx_gr_line_receipt"
remove_index :inventory_item_barcode, name: "idx_inv_barcode_barcode"
remove_index :inventory_item_barcode, name: "idx_inv_barcode_item"
remove_index :invoice_lifecycle_event, name: "idx_invoice_lifecycle_entity"
remove_index :no_sale_event, name: "idx_no_sale_event_session"
remove_index :no_sale_event, name: "idx_no_sale_event_user"
remove_index :customer_payment_allocation, name: "idx_payment_alloc_invoice"
remove_index :customer_payment_allocation, name: "idx_payment_alloc_payment"
remove_index :netsurf_pos_audit_log, name: "idx_pos_audit_log_entity"
remove_index :pricelist_item, name: "idx_pricelist_item_list"
remove_index :pricelist_item, name: "idx_pricelist_item_product"
remove_index :printer, name: "idx_printer_location"
remove_index :printer, name: "idx_printer_org"
remove_index :recurring_template_run, name: "idx_recurring_run_org"
remove_index :recurring_template_run, name: "idx_recurring_run_template"
remove_index :reservation, name: "idx_reservation_date"
remove_index :reservation, name: "idx_reservation_location"
remove_index :reservation, name: "idx_reservation_org"
remove_index :reservation, name: "idx_reservation_status"
remove_index :shift_handoff, name: "idx_shift_handoff_from"
remove_index :shift_handoff, name: "idx_shift_handoff_session"
remove_index :shift_handoff, name: "idx_shift_handoff_to"
remove_index :netsurf_stock_transfer_items, name: "idx_stock_transfer_items_transfer_id"
remove_index :netsurf_stock_transfers, name: "idx_stock_transfers_status_created_at"
remove_index :transfer, name: "idx_transfer_from"
remove_index :transfer_line, name: "idx_transfer_line_transfer"
remove_index :transfer, name: "idx_transfer_org"
remove_index :transfer, name: "idx_transfer_to"
remove_index :iftaar_submissions, name: "iftaar_submissions_date_idx"
remove_index :import_job, name: "importJob_createdAt_idx"
remove_index :import_job, name: "importJob_organizationId_idx"
remove_index :import_job, name: "importJob_status_idx"
remove_index :import_job, name: "importJob_type_idx"
remove_index :import_job, name: "importJob_userId_idx"
remove_index :invitation, name: "invitation_email_idx"
remove_index :invitation, name: "invitation_email_idx"
remove_index :invitation, name: "invitation_organizationId_idx"
remove_index :invitation, name: "invitation_organizationId_idx"
remove_index :invitation, name: "invitation_status_idx"
remove_index :invoice, name: "invoice_business_idx"
remove_index :invoice, name: "invoice_business_idx"
remove_index :invoice, name: "invoice_client_id_idx"
remove_index :invoice, name: "invoice_client_id_idx"
remove_index :invoice, name: "invoice_created_by_idx"
remove_index :invoice, name: "invoice_created_by_idx"
remove_index :invoice, name: "invoice_due_date_idx"
remove_index :invoice, name: "invoice_due_date_idx"
remove_index :invoice, name: "invoice_invoice_date_idx"
remove_index :invoice, name: "invoice_invoice_date_idx"
remove_index :invoice, name: "invoice_invoice_number_idx"
remove_index :invoice, name: "invoice_invoice_number_idx"
remove_index :invoice_line_item, name: "invoice_line_item_invoice_id_idx"
remove_index :invoice_line_item, name: "invoice_line_item_invoice_id_idx"
remove_index :invoice_line_item, name: "invoice_line_item_sort_order_idx"
remove_index :invoice_line_item, name: "invoice_line_item_sort_order_idx"
remove_index :invoice, name: "invoice_matter_id_idx"
remove_index :invoice, name: "invoice_matter_id_idx"
remove_index :invoice_payment, name: "invoice_payment_invoice_id_idx"
remove_index :invoice_payment, name: "invoice_payment_invoice_id_idx"
remove_index :invoice_payment, name: "invoice_payment_payment_date_idx"
remove_index :invoice_payment, name: "invoice_payment_payment_date_idx"
remove_index :invoice_payment, name: "invoice_payment_recorded_by_idx"
remove_index :invoice_payment, name: "invoice_payment_recorded_by_idx"
remove_index :invoice, name: "invoice_status_idx"
remove_index :invoice, name: "invoice_status_idx"
remove_index :maintenance_assignments, name: "maintenance_assignments_scheduleddate_idx"
remove_index :maintenance_assignments, name: "maintenance_assignments_status_idx"
remove_index :maintenance_assignments, name: "maintenance_assignments_type_idx"
remove_index :matter, name: "matter_assigned_staff_idx"
remove_index :matter, name: "matter_assigned_staff_idx"
remove_index :matter, name: "matter_business_idx"
remove_index :matter, name: "matter_business_idx"
remove_index :matter_checklist, name: "matter_checklist_is_completed_idx"
remove_index :matter_checklist, name: "matter_checklist_is_completed_idx"
remove_index :matter_checklist, name: "matter_checklist_matter_id_idx"
remove_index :matter_checklist, name: "matter_checklist_matter_id_idx"
remove_index :matter, name: "matter_client_id_idx"
remove_index :matter, name: "matter_client_id_idx"
remove_index :matter, name: "matter_due_date_idx"
remove_index :matter, name: "matter_due_date_idx"
remove_index :matter, name: "matter_is_recurring_idx"
remove_index :matter, name: "matter_is_recurring_idx"
remove_index :matter_link, name: "matter_link_linked_matter_id_idx"
remove_index :matter_link, name: "matter_link_linked_matter_id_idx"
remove_index :matter_link, name: "matter_link_matter_id_idx"
remove_index :matter_link, name: "matter_link_matter_id_idx"
remove_index :matter, name: "matter_next_recurrence_date_idx"
remove_index :matter, name: "matter_next_recurrence_date_idx"
remove_index :matter_note, name: "matter_note_matter_id_idx"
remove_index :matter_note, name: "matter_note_matter_id_idx"
remove_index :matter, name: "matter_parent_matter_id_idx"
remove_index :matter, name: "matter_parent_matter_id_idx"
remove_index :matter, name: "matter_reference_number_idx"
remove_index :matter, name: "matter_reference_number_idx"
remove_index :matter, name: "matter_service_type_id_idx"
remove_index :matter, name: "matter_service_type_id_idx"
remove_index :matter, name: "matter_status_idx"
remove_index :matter, name: "matter_status_idx"
remove_index :member, name: "member_organizationId_idx"
remove_index :member, name: "member_userId_idx"
remove_index :member, name: "member_userId_organizationId_idx"
remove_index :nag_action, name: "nagAction_actionType_idx"
remove_index :nag_action, name: "nagAction_createdAt_idx"
remove_index :nag_action, name: "nagAction_organizationId_idx"
remove_index :nag_action, name: "nagAction_terminalId_idx"
remove_index :notification, name: "notification_client_id_idx"
remove_index :notification, name: "notification_client_id_idx"
remove_index :notification, name: "notification_createdAt_idx"
remove_index :notification, name: "notification_created_at_idx"
remove_index :notification, name: "notification_created_at_idx"
remove_index :notification, name: "notification_matter_id_idx"
remove_index :notification, name: "notification_matter_id_idx"
remove_index :notification, name: "notification_organizationId_idx"
remove_index :notification_preference, name: "notification_preference_user_id_idx"
remove_index :notification_preference, name: "notification_preference_user_id_idx"
remove_index :notification, name: "notification_read_at_idx"
remove_index :notification, name: "notification_read_at_idx"
remove_index :notification, name: "notification_type_idx"
remove_index :notification, name: "notification_type_idx"
remove_index :notification, name: "notification_userId_idx"
remove_index :notification, name: "notification_userId_isRead_idx"
remove_index :notification, name: "notification_user_id_idx"
remove_index :notification, name: "notification_user_id_idx"
remove_index :on_call_overrides, name: "on_call_overrides_dateRange_idx"
remove_index :on_call_overrides, name: "on_call_overrides_scheduleId_idx"
remove_index :organization, name: "organization_slug_idx"
remove_index :passkey, name: "passkey_credentialId_idx"
remove_index :passkey, name: "passkey_userId_idx"
remove_index :payment, name: "payment_createdAt_idx"
remove_index :payment, name: "payment_customerId_idx"
remove_index :payment, name: "payment_organizationId_idx"
remove_index :payment, name: "payment_status_idx"
remove_index :payment, name: "payment_terminalId_idx"
remove_index :payment, name: "payment_type_idx"
remove_index :performance_journal_entries, name: "performance_journal_entries_appraisalid_idx"
remove_index :performance_journal_entries, name: "performance_journal_entries_entrydate_idx"
remove_index :performance_journal_entries, name: "performance_journal_entries_staffprofileid_idx"
remove_index :portal_activity_log, name: "portal_activity_log_action_idx"
remove_index :portal_activity_log, name: "portal_activity_log_action_idx"
remove_index :portal_activity_log, name: "portal_activity_log_client_id_idx"
remove_index :portal_activity_log, name: "portal_activity_log_client_id_idx"
remove_index :portal_activity_log, name: "portal_activity_log_created_at_idx"
remove_index :portal_activity_log, name: "portal_activity_log_created_at_idx"
remove_index :portal_activity_log, name: "portal_activity_log_impersonated_by_user_id_idx"
remove_index :portal_activity_log, name: "portal_activity_log_impersonated_by_user_id_idx"
remove_index :portal_activity_log, name: "portal_activity_log_is_impersonated_idx"
remove_index :portal_activity_log, name: "portal_activity_log_is_impersonated_idx"
remove_index :portal_activity_log, name: "portal_activity_log_portal_user_id_idx"
remove_index :portal_activity_log, name: "portal_activity_log_portal_user_id_idx"
remove_index :portal_document_upload, name: "portal_document_upload_client_id_idx"
remove_index :portal_document_upload, name: "portal_document_upload_client_id_idx"
remove_index :portal_document_upload, name: "portal_document_upload_document_id_idx"
remove_index :portal_document_upload, name: "portal_document_upload_document_id_idx"
remove_index :portal_document_upload, name: "portal_document_upload_portal_user_id_idx"
remove_index :portal_document_upload, name: "portal_document_upload_portal_user_id_idx"
remove_index :portal_document_upload, name: "portal_document_upload_status_idx"
remove_index :portal_document_upload, name: "portal_document_upload_status_idx"
remove_index :portal_message, name: "portal_message_client_id_idx"
remove_index :portal_message, name: "portal_message_client_id_idx"
remove_index :portal_message, name: "portal_message_created_at_idx"
remove_index :portal_message, name: "portal_message_created_at_idx"
remove_index :portal_message, name: "portal_message_is_read_idx"
remove_index :portal_message, name: "portal_message_is_read_idx"
remove_index :portal_message, name: "portal_message_parent_message_idx"
remove_index :portal_message, name: "portal_message_parent_message_idx"
remove_index :portal_message, name: "portal_message_sender_portal_user_idx"
remove_index :portal_message, name: "portal_message_sender_portal_user_idx"
remove_index :portal_message, name: "portal_message_sender_staff_user_idx"
remove_index :portal_message, name: "portal_message_sender_staff_user_idx"
remove_index :portal_password_reset, name: "portal_password_reset_expires_at_idx"
remove_index :portal_password_reset, name: "portal_password_reset_expires_at_idx"
remove_index :portal_password_reset, name: "portal_password_reset_portal_user_id_idx"
remove_index :portal_password_reset, name: "portal_password_reset_portal_user_id_idx"
remove_index :portal_password_reset, name: "portal_password_reset_token_idx"
remove_index :portal_password_reset, name: "portal_password_reset_token_idx"
remove_index :portal_session, name: "portal_session_expires_at_idx"
remove_index :portal_session, name: "portal_session_expires_at_idx"
remove_index :portal_session, name: "portal_session_portal_user_id_idx"
remove_index :portal_session, name: "portal_session_portal_user_id_idx"
remove_index :portal_session, name: "portal_session_token_idx"
remove_index :portal_session, name: "portal_session_token_idx"
remove_index :portal_user, name: "portal_user_client_id_idx"
remove_index :portal_user, name: "portal_user_client_id_idx"
remove_index :portal_user, name: "portal_user_email_idx"
remove_index :portal_user, name: "portal_user_email_idx"
remove_index :portal_user, name: "portal_user_invited_by_idx"
remove_index :portal_user, name: "portal_user_invited_by_idx"
remove_index :portal_user, name: "portal_user_status_idx"
remove_index :portal_user, name: "portal_user_status_idx"
remove_index :ppe_issuances, name: "ppe_issuances_duedate_idx"
remove_index :ppe_issuances, name: "ppe_issuances_ppeitemid_idx"
remove_index :ppe_issuances, name: "ppe_issuances_staffprofileid_idx"
remove_index :ppe_issuances, name: "ppe_issuances_status_idx"
remove_index :ppe_items, name: "ppe_items_isactive_idx"
remove_index :promotion_letters, name: "promotion_letters_staffprofileid_idx"
remove_index :promotion_letters, name: "promotion_letters_status_idx"
remove_index :promotion_recommendations, name: "promotion_recommendations_appraisalid_idx"
remove_index :promotion_recommendations, name: "promotion_recommendations_staffprofileid_idx"
remove_index :promotion_recommendations, name: "promotion_recommendations_status_idx"
remove_index :push_subscriptions, name: "push_subs_active_idx"
remove_index :push_subscriptions, name: "push_subs_user_idx"
remove_index :push_subscription, name: "push_subscription_endpoint_idx"
remove_index :push_subscription, name: "push_subscription_userId_idx"
remove_index :rate_limit_bucket, name: "rateLimitBucket_bucketKey_idx"
remove_index :rate_limit_bucket, name: "rateLimitBucket_windowStart_idx"
remove_index :recurring_invoice, name: "recurring_invoice_business_idx"
remove_index :recurring_invoice, name: "recurring_invoice_business_idx"
remove_index :recurring_invoice, name: "recurring_invoice_client_id_idx"
remove_index :recurring_invoice, name: "recurring_invoice_client_id_idx"
remove_index :recurring_invoice, name: "recurring_invoice_next_date_idx"
remove_index :recurring_invoice, name: "recurring_invoice_next_date_idx"
remove_index :recurring_invoice, name: "recurring_invoice_status_idx"
remove_index :recurring_invoice, name: "recurring_invoice_status_idx"
remove_index :recurring_invoice_line_item, name: "recurring_line_item_recurring_id_idx"
remove_index :recurring_invoice_line_item, name: "recurring_line_item_recurring_id_idx"
remove_index :report_definition, name: "report_definition_category_idx"
remove_index :report_definition, name: "report_definition_category_idx"
remove_index :report_definition, name: "report_definition_report_code_idx"
remove_index :report_definition, name: "report_definition_report_code_idx"
remove_index :report_definition, name: "report_definition_type_idx"
remove_index :report_definition, name: "report_definition_type_idx"
remove_index :report_execution, name: "report_execution_report_id_idx"
remove_index :report_execution, name: "report_execution_report_id_idx"
remove_index :report_execution, name: "report_execution_started_at_idx"
remove_index :report_execution, name: "report_execution_started_at_idx"
remove_index :report_execution, name: "report_execution_status_idx"
remove_index :report_execution, name: "report_execution_status_idx"
remove_index :report_execution, name: "report_execution_user_idx"
remove_index :report_execution, name: "report_execution_user_idx"
remove_index :roster_assignments, name: "roster_assignments_scheduleid_idx"
remove_index :roster_assignments, name: "roster_assignments_shiftdate_idx"
remove_index :roster_assignments, name: "roster_assignments_staffprofileid_idx"
remove_index :roster_schedules, name: "roster_schedules_departmentid_idx"
remove_index :roster_schedules, name: "roster_schedules_status_idx"
remove_index :roster_swap_requests, name: "roster_swap_requests_requesterid_idx"
remove_index :roster_swap_requests, name: "roster_swap_requests_status_idx"
remove_index :scheduled_report, name: "scheduled_report_active_idx"
remove_index :scheduled_report, name: "scheduled_report_active_idx"
remove_index :scheduled_report, name: "scheduled_report_next_run_idx"
remove_index :scheduled_report, name: "scheduled_report_next_run_idx"
remove_index :scheduled_report, name: "scheduled_report_report_id_idx"
remove_index :scheduled_report, name: "scheduled_report_report_id_idx"
remove_index :service_type, name: "service_type_business_idx"
remove_index :service_type, name: "service_type_business_idx"
remove_index :service_type, name: "service_type_category_idx"
remove_index :service_type, name: "service_type_category_idx"
remove_index :service_type, name: "service_type_is_active_idx"
remove_index :service_type, name: "service_type_is_active_idx"
remove_index :session, name: "session_activeOrganizationId_idx"
remove_index :session, name: "session_userId_idx"
remove_index :session, name: "session_user_id_idx"
remove_index :shift, name: "shift_org_idx"
remove_index :shift, name: "shift_user_idx"
remove_index :staff_availability, name: "staff_availability_day_of_week_idx"
remove_index :staff_availability, name: "staff_availability_day_of_week_idx"
remove_index :staff_availability_override, name: "staff_availability_override_date_idx"
remove_index :staff_availability_override, name: "staff_availability_override_date_idx"
remove_index :staff_availability_override, name: "staff_availability_override_staff_id_idx"
remove_index :staff_availability_override, name: "staff_availability_override_staff_id_idx"
remove_index :staff_availability, name: "staff_availability_staff_id_idx"
remove_index :staff_availability, name: "staff_availability_staff_id_idx"
remove_index :staff_feedback, name: "staff_feedback_appraisalid_idx"
remove_index :staff_feedback, name: "staff_feedback_staffprofileid_idx"
remove_index :staff_feedback, name: "staff_feedback_status_idx"
remove_index :staff_hourly_rate, name: "staff_hourly_rate_business_idx"
remove_index :staff_hourly_rate, name: "staff_hourly_rate_business_idx"
remove_index :staff_hourly_rate, name: "staff_hourly_rate_effective_from_idx"
remove_index :staff_hourly_rate, name: "staff_hourly_rate_effective_from_idx"
remove_index :staff_hourly_rate, name: "staff_hourly_rate_staff_id_idx"
remove_index :staff_hourly_rate, name: "staff_hourly_rate_staff_id_idx"
remove_index :staff_impersonation_session, name: "staff_impersonation_session_client_id_idx"
remove_index :staff_impersonation_session, name: "staff_impersonation_session_client_id_idx"
remove_index :staff_impersonation_session, name: "staff_impersonation_session_expires_at_idx"
remove_index :staff_impersonation_session, name: "staff_impersonation_session_expires_at_idx"
remove_index :staff_impersonation_session, name: "staff_impersonation_session_is_active_idx"
remove_index :staff_impersonation_session, name: "staff_impersonation_session_is_active_idx"
remove_index :staff_impersonation_session, name: "staff_impersonation_session_portal_user_id_idx"
remove_index :staff_impersonation_session, name: "staff_impersonation_session_portal_user_id_idx"
remove_index :staff_impersonation_session, name: "staff_impersonation_session_staff_user_id_idx"
remove_index :staff_impersonation_session, name: "staff_impersonation_session_staff_user_id_idx"
remove_index :staff_impersonation_session, name: "staff_impersonation_session_token_idx"
remove_index :staff_impersonation_session, name: "staff_impersonation_session_token_idx"
remove_index :staff_invite, name: "staff_invite_email_idx"
remove_index :staff_invite, name: "staff_invite_email_idx"
remove_index :staff_invite, name: "staff_invite_status_idx"
remove_index :staff_invite, name: "staff_invite_status_idx"
remove_index :staff_invite, name: "staff_invite_token_idx"
remove_index :staff_invite, name: "staff_invite_token_idx"
remove_index :starlink_account, name: "starlinkAccount_email_idx"
remove_index :starlink_account, name: "starlinkAccount_organizationId_idx"
remove_index :submission_reactions, name: "submission_reactions_sub_idx"
remove_index :submission_reactions, name: "submission_reactions_user_idx"
remove_index :subscription, name: "subscription_organizationId_idx"
remove_index :subscription, name: "subscription_status_idx"
remove_index :subscription, name: "subscription_stripeCustomerId_idx"
remove_index :subscription, name: "subscription_stripeSubscriptionId_idx"
remove_index :on_call_swaps, name: "swaps_assignmentId_idx"
remove_index :on_call_swaps, name: "swaps_requesterId_idx"
remove_index :on_call_swaps, name: "swaps_status_idx"
remove_index :terminal, name: "terminal_customerId_idx"
remove_index :terminal, name: "terminal_kitSerialNumber_idx"
remove_index :terminal, name: "terminal_nagLevel_idx"
remove_index :terminal, name: "terminal_nextBillingDate_idx"
remove_index :terminal, name: "terminal_organizationId_idx"
remove_index :terminal, name: "terminal_starlinkAccountId_idx"
remove_index :terminal, name: "terminal_status_idx"
remove_index :time_entry, name: "time_entry_business_idx"
remove_index :time_entry, name: "time_entry_business_idx"
remove_index :time_entry, name: "time_entry_created_at_idx"
remove_index :time_entry, name: "time_entry_created_at_idx"
remove_index :time_entry, name: "time_entry_date_idx"
remove_index :time_entry, name: "time_entry_date_idx"
remove_index :time_entry, name: "time_entry_invoice_id_idx"
remove_index :time_entry, name: "time_entry_invoice_id_idx"
remove_index :time_entry, name: "time_entry_is_billable_idx"
remove_index :time_entry, name: "time_entry_is_billable_idx"
remove_index :time_entry, name: "time_entry_matter_id_idx"
remove_index :time_entry, name: "time_entry_matter_id_idx"
remove_index :time_entry, name: "time_entry_staff_id_idx"
remove_index :time_entry, name: "time_entry_staff_id_idx"
remove_index :timesheet_entries, name: "timesheet_entries_timesheetid_idx"
remove_index :timesheet_entries, name: "timesheet_entries_workdate_idx"
remove_index :timesheets, name: "timesheets_periodstart_idx"
remove_index :timesheets, name: "timesheets_staffprofileid_idx"
remove_index :timesheets, name: "timesheets_status_idx"
remove_index :two_factor, name: "two_factor_userId_idx"
remove_index :verification, name: "verification_identifier_idx"
remove_index :verification, name: "verification_identifier_idx"
remove_index :verification, name: "verification_identifier_idx"
remove_index :verification, name: "verification_identifier_idx"
remove_index :verification, name: "verification_identifier_idx"
remove_index :verification, name: "verification_identifier_idx"
remove_index :verification, name: "verification_identifier_idx"
remove_index :voucher, name: "voucher_createdAt_idx"
remove_index :voucher, name: "voucher_customerId_idx"
remove_index :voucher, name: "voucher_organizationId_idx"
remove_index :voucher, name: "voucher_paymentId_idx"
remove_index :voucher, name: "voucher_terminalId_idx"
remove_index :voucher, name: "voucher_voucherNumber_idx"
remove_index :waitlist_entry, name: "waitlist_org_idx"
remove_index :waitlist_entry, name: "waitlist_status_idx"
remove_index :webhook_delivery, name: "webhookDelivery_createdAt_idx"
remove_index :webhook_delivery, name: "webhookDelivery_event_idx"
remove_index :webhook_delivery, name: "webhookDelivery_isSuccess_idx"
remove_index :webhook_delivery, name: "webhookDelivery_webhookId_idx"
remove_index :webhook, name: "webhook_isActive_idx"
remove_index :webhook, name: "webhook_organizationId_idx"
remove_index :work_item_assignees, name: "work_item_assignees_staff_idx"
remove_index :work_item_assignees, name: "work_item_assignees_work_item_idx"
remove_index :work_item_dependencies, name: "work_item_deps_dependsOnId_idx"
remove_index :work_item_dependencies, name: "work_item_deps_workItemId_idx"
remove_index :work_item_team_allocations, name: "work_item_team_alloc_work_item_idx"