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
..
20250421113117_remote_schema.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250421114454_add_prisma_user.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250421115005_remote_schema.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250421115206_grant_privileges_to_prisma.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250424033411_grant_deafult_previleges.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250424180834_grant_deafult_previleges_again.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250505150200_remote_schema.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250505150857_remote_schema.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250505161323_remote_schema.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250506125310_remote_schema.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250506125549_add_new_function.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250506132018_add_new_gis_function.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250506142627_drop_and_restore.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250506142701_remote_schema.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250506143002_drop_and_restore.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250506143054_remote_schema.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250510020227_add_model_location_logs.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250511100547_add_triger_and_function.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250515110003_add_new_auth_trigger.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250515110032_add_new_gis_trigger.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00
20250518035335_remote_schema.sql	feat: Add triggers and functions for user management and location handling	2025-05-18 13:52:26 +07:00