docs/devlogs/db/logs.sql

INSERT INTO "public"."projects" ("id", "client_id", "contractor_id", "title", "description", "service_type", "primary_manager_id", "status", "planned_start_date", "planned_end_date", "actual_start_date", "actual_end_date", "is_closed", "closed_at", "closed_by_user_id", "platform_billing_plan", "is_billable", "budget", "inventory_requirements", "photo_requirements", "activation_requirements", "additional_metadata", "created_at", "updated_at", "deleted_at", "project_type", "invoice_pricing_rules", "total_tickets_invoiced") VALUES ('0ade6bd1-e492-4e25-b681-59f42058d29a', 'a2455244-d87e-4279-9fca-dc067f06b5c3', '1af9fb24-e5bb-40ac-a748-0997580b4c32', 'Atomio Fttx', 'Install of testing purposes', 'ftth', 'c5cf92be-4172-4fe2-af5c-f05d83b3a938', 'active', '2025-11-22', '2026-01-23', null, null, 'false', null, null, null, 'true', '{}', '{}', '[{"type": "Speedtest", "required": true, "max_photos": 1, "min_photos": 1, "description": "speed test collected "}, {"type": "Airtel network", "required": true, "max_photos": 1, "min_photos": 1, "description": "strength metrics"}, {"type": "ODU outdoor image", "required": true, "max_photos": 1, "min_photos": 1, "description": "take a photo of the odu antenna"}, {"type": "JCC", "required": true, "max_photos": 1, "min_photos": 1, "description": "Job Completion Form"}]', '[{"type": "text", "field": "ont_serial", "label": "ONT", "options": null, "required": true}, {"type": "text", "field": "odu_serial", "label": "ODU", "options": null, "required": true}, {"type": "text", "field": "odu_imei_number", "label": "ODU IMEI Number", "options": null, "required": true}, {"type": "phone", "field": "activated_number", "label": "Activated number", "options": null, "pattern": null, "required": true, "help_text": null, "max_length": null, "min_length": null, "placeholder": null}]', '{"setup_finalized_at": "2025-11-23T13:47:18.729614", "setup_finalized_by": "c5cf92be-4172-4fe2-af5c-f05d83b3a938"}', '2025-11-20 19:04:04.11638+00', '2025-12-15 09:53:09.048077+00', null, 'customer_service', null, '0');