Migration name .............................................. Batch / Status 0001_01_01_000001_create_cache_table ............................... [1] Ran 0001_01_01_000002_create_jobs_table ................................ [1] Ran 2024_01_01_000001_create_core_tables ............................... [1] Ran 2024_01_01_000003_create_tenant_tables ............................. [1] Ran 2024_01_01_000004_create_attendance_tables ......................... [1] Ran 2024_01_01_000005_create_field_operations_tables ................... [1] Ran 2025_12_30_121732_add_tenant_id_to_users_table ..................... [1] Ran 2025_12_30_122611_create_permission_tables ......................... [1] Ran 2025_12_30_190000_create_geofence_violations_table ................. [1] Ran 2025_12_31_070605_create_sessions_table ............................ [1] Ran 2026_01_02_052212_create_transits_table ............................ [1] Ran 2026_01_02_120000_add_indian_compliance_to_profiles ................ [1] Ran 2026_01_02_120001_create_bank_details_table ........................ [1] Ran 2026_01_02_120002_create_employee_documents_table .................. [1] Ran 2026_01_02_122309_create_personal_access_tokens_table .............. [1] Ran 2026_01_02_130000_create_leave_tables .............................. [1] Ran 2026_01_02_140000_add_break_types_to_attendance_details ............ [1] Ran 2026_01_04_create_client_services_table ............................ [1] Ran 2026_01_05_000001_create_patrol_system_hierarchy ................... [1] Ran 2026_01_05_000002_add_patrol_system_missing_tables ................. [1] Ran 2026_01_05_000003_create_patrol_missing_tables_only ................ [1] Ran 2026_01_05_120000_add_client_fields ................................ [1] Ran 2026_01_06_add_checkpoint_id_to_patrol_time_slots .................. [1] Ran 2026_01_06_add_missing_columns_to_patrol_tables .................... [1] Ran 2026_01_06_add_time_slot_id_to_patrol_logs ......................... [1] Ran 2026_01_06_drop_client_location_from_patrol_schedules .............. [1] Ran 2026_01_06_drop_location_name_from_client_services ................. [1] Ran 2026_01_06_make_patrol_schedule_time_fields_nullable ............... [1] Ran 2026_01_08_add_location_id_to_client_services ...................... [1] Ran 2026_01_08_add_missing_patrol_columns .............................. [1] Ran 2026_01_08_fix_missing_client_columns .............................. [1] Ran 2026_01_08_fix_patrol_checkpoint_schedule_relationship ............. [1] Ran 2026_01_08_update_client_service_location_relationship ............. [1] Ran 2026_01_08_update_service_type_to_enum ............................. [1] Ran 2026_01_09_000001_remove_shift_type_from_patrol_schedules .......... [1] Ran 2026_01_09_000003_add_nullable_employee_id_to_patrol_schedules .... [24] Ran 2026_01_09_150400_update_employee_assignment_transits_times_and_status [8] Ran 2026_01_09_151450_add_transit_duration_minutes_to_employee_assignment_transits [9] Ran 2026_01_09_181630_add_description_to_geofences_table .............. [24] Ran 2026_01_10_000001_create_transit_sessions_table ................... [57] Ran 2026_01_10_000002_create_transit_locations_table .................. [60] Ran 2026_01_10_add_date_and_visit_times_to_patrol_time_slots .......... [25] Ran 2026_01_10_create_employee_assignment_transits_table ............... [7] Ran 2026_01_10_fix_patrol_checkpoint_id_column ........................ [60] Ran 2026_01_10_make_schedule_id_nullable_in_patrol_time_slots ......... [60] Ran 2026_01_10_make_time_slot_fields_nullable ......................... [60] Ran 2026_01_10_remove_required_time_from_patrol_checkpoints ........... [22] Ran 2026_01_10_update_assignment_type_enum_in_employee_assignments_table [17] Ran 2026_01_13_000001_create_payroll_tables ........................... [60] Ran 2026_01_13_add_service_type_id_to_employee_assignments_table ...... [16] Ran 2026_01_13_create_service_types_table ............................. [14] Ran 2026_01_13_create_site_service_type_table ......................... [15] Ran 2026_01_13_migrate_geofences_from_client_to_service ............... [19] Ran 2026_01_19_000001_add_leave_allocation_fields_to_designations_table [21] Ran 2026_01_19_161413_add_half_day_type_to_leave_requests_table ....... [60] Ran 2026_01_22_000001_create_lead_form_tables ......................... [60] Ran 2026_01_22_000002_create_inventory_system_tables .................. [60] Ran 2026_04_13_000001_create_states_table .............................. [2] Ran 2026_04_13_000002_create_zones_table ............................... [3] Ran 2026_04_13_000003_create_districts_table ........................... [4] Ran 2026_04_13_000005_add_scope_fields_to_users_table ................. [63] Ran 2026_04_13_000006_add_school_id_to_core_tables .................... [11] Ran 2026_04_15_000001_add_hierarchical_columns_to_users_table .......... [6] Ran 2026_04_15_000002_add_zone_id_to_client_services_table ............ [12] Ran 2026_04_15_000003_create_user_service_access_table ................ [13] Ran 2026_04_16_112803_add_service_id_to_geofences_table ............... [18] Ran 2026_04_16_113405_add_state_id_to_client_services_table ........... [20] Ran 2026_04_17_142900_add_school_id_to_client_locations_table ......... [23] Ran 2026_04_21_000001_add_state_id_and_zone_id_to_clients_table ....... [27] Ran 2026_04_21_191515_add_alternate_phone_to_profiles_table ........... [26] Ran 2026_04_22_133901_add_district_id_to_user_service_access_table .... [28] Ran 2026_04_22_134216_add_district_id_to_client_services_table ........ [29] Ran 2026_04_24_134040_add_default_hierarchical_access_to_roles_table .. [30] Ran 2026_04_27_000001_add_tenant_id_to_user_service_access_table ...... [32] Ran 2026_04_27_124943_drop_schools_table .............................. [63] Ran 2026_04_27_125253_drop_schools_table_with_fk ...................... [31] Ran 2026_04_27_130000_add_district_id_and_tenant_id_to_user_service_access Pending 2026_04_27_130001_migrate_user_hierarchical_fields_to_service_access [33] Ran 2026_04_27_130002_remove_hierarchical_fields_from_users_table ..... [34] Ran 2026_04_27_140000_add_district_id_and_tenant_id_to_role_default_access Pending 2026_04_28_000001_fix_hierarchy_state_district_zone ............... [35] Ran 2026_04_28_003053_add_district_id_to_role_default_access_table .... [36] Ran 2026_05_02_000001_fix_zones_district_id ........................... [40] Ran 2026_05_02_000002_create_district_zone_pivot_table ................ [41] Ran 2026_05_02_make_client_id_nullable_in_client_services ............. [42] Ran 2026_05_02_services_only_no_contracts ............................. [38] Ran 2026_05_03_000002_add_performance_indexes ......................... [43] Ran 2026_05_03_000003_add_soft_delete_cascade ......................... [44] Ran 2026_05_10_110801_add_hierarchy_level_to_roles_table .............. [45] Ran 2026_05_10_114644_add_tenant_id_to_zones_table .................... [46] Ran 2026_05_10_115055_remove_tenant_id_from_zones_table ............... [47] Ran 2026_05_21_000001_add_client_user_id_to_client_services_table ..... [50] Ran 2026_05_21_120600_add_ic_number_to_profiles_table ................. [48] Ran 2026_05_21_133800_add_employee_code_to_profiles_table ............. [49] Ran 2026_05_22_134252_add_district_id_to_client_services_table ........ [51] Ran 2026_05_29_154135_add_capabilities_to_client_services_table ....... [55] Ran 2026_06_17_000001_add_face_descriptor_to_users_table .............. [58] Ran 2026_06_17_000002_add_can_face_attendance_to_employee_assignments . [58] Ran 2026_06_17_000003_add_client_code_to_employee_assignments ......... [59] Ran 2026_06_17_add_staff_guard_fields_to_employee_assignments ......... [56] Ran 2026_07_02_000001_expand_client_service_service_type_enum ......... [62] Ran 2026_07_02_000002_fix_users_school_foreign_key .................... [61] Ran