vergiLgood1 c7bdb24ceb feat: Add triggers and functions for user management and location handling ... - Implemented user creation, update, and deletion triggers to manage officer and standard user data. - Created functions to handle user type changes and conditional updates based on user metadata. - Added a function to retrieve nearby units based on geographical coordinates. - Established triggers to update distance to units upon location changes. - Created spatial indexes for efficient querying of units and locations. - Added a function to delete the current user from the auth.users table.		2025-05-18 13:52:26 +07:00
..
20250423141344_init_migration	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250423155055_add_phone_and_create_polres_jemebr	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250505171530_delete_phone_field_on_units	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250505171603_add_field_phone_on_units	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250506075152_add_field_phone	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250506080119_change_id_to_code_unit	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250506080400_make_year_optional_in_crimes	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250506082733_make_code_unit_to_primary_key	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250510020457_add_source_type_and_distance_field	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250511072008_add_location_logs	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250511072210_	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250511074218_	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250511074520_make_year_nullable	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250511103440_test_table	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250511105354_add_crime_cleared_to_crimes_table	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250511105911_add_city_id_to_units	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250511110222_add_phone_on_units	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250511222953_add_avg_crime_on_crimes	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250513091416_use_code_unit_for_id_units	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250515104827_add_officer_and_patrol_unit	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250515115714_add_evidence_model	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250515120411_add_some_field_on_evidence	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250515142934_change_id_on_evidence_and_patrol_unit_to_custom_id	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250515145450_change_id_on_evidence_and_patrol_unit_to_custom_id	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250515155559_	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250517021614_add_field_nik_for_user	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
migration_lock.toml	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00