Commit Graph

10 Commits

Author SHA1 Message Date
vergiLgood1 aa675f04f9 first commit 2025-08-05 14:30:36 +07:00
vergiLgood1 db8e2a6321 add seeds supaabse 2025-05-14 06:54:34 +07:00
vergiLgood1 e422c59da9 Add crime data CSV files and update database schema
- Added crime summary by type CSV file with district-wise crime statistics.
- Added yearly crime data CSV file with detailed crime statistics per district and year.
- Modified the database schema to include a new column `source_type` in the `crimes` table and a new column `distance` in the `locations` table.
- Created migration to add `location_logs` table for tracking user location data with relevant fields and indices.
- Updated migration to drop the `distance` column and replace it with `distance_from_unit` in the `locations` table.
- Added additional migrations to drop and recreate the `location_logs` table, modify existing columns, and enforce new constraints in the `unit_statistics` and `units` tables.
2025-05-11 14:44:14 +07:00
vergiLgood1 57fb1e4e46 Refactor GeoJSON seeder to insert data in smaller batches to prevent timeouts; added chunking logic and improved error handling. Update permission seeder to batch create permissions for roles and resources. Optimize unit seeder to prepare and insert unit data in bulk, enhancing performance. Adjust Supabase configuration for local development and modify migration scripts to restore GIS functions and types. 2025-05-06 21:37:28 +07:00
vergiLgood1 276a63a4dc add layout for my account, preference, notiication and import 2025-03-07 23:08:16 +07:00
vergiLgood1 aa52dd0ca4 resolve RLS issue for upload avatars images 2025-03-07 00:22:44 +07:00
vergiLgood1 121017dfb1 add profile and remove older project 2025-03-05 14:58:15 +07:00
vergiLgood1 ca90871b22 remove older project 2025-02-28 19:26:26 +07:00
vergiLgood1 39a0af5e0f add users table 2025-02-27 00:58:32 +07:00
vergiLgood1 8137c58cd8 add some hooks 2025-02-19 00:05:16 +07:00