diff options
Diffstat (limited to 'db/migrations_backup/0100_normal_dreaming_celestial.sql')
| -rw-r--r-- | db/migrations_backup/0100_normal_dreaming_celestial.sql | 30 |
1 files changed, 0 insertions, 30 deletions
diff --git a/db/migrations_backup/0100_normal_dreaming_celestial.sql b/db/migrations_backup/0100_normal_dreaming_celestial.sql deleted file mode 100644 index c3ec34b5..00000000 --- a/db/migrations_backup/0100_normal_dreaming_celestial.sql +++ /dev/null @@ -1,30 +0,0 @@ -DROP VIEW "public"."vendor_investigations_view";--> statement-breakpoint -CREATE VIEW "public"."vendor_investigations_view" AS (select "vendor_investigations"."id", "vendor_investigations"."status", "vendor_investigations"."scheduled_start_at", "vendor_investigations"."scheduled_end_at", "vendor_investigations"."completed_at", "vendor_investigations"."investigation_notes", "vendor_investigations"."created_at", "vendor_investigations"."updated_at", "vendors"."id", "vendors"."vendor_name", "vendors"."vendor_code", "vendors"."tax_id", "vendors"."status", "vendors"."country", "vendors"."email", "vendors"."phone", "vendors"."website", "vendors"."created_at", "vendors"."updated_at", ( - SELECT COALESCE( - json_agg(json_build_object( - 'contactName', c.contact_name, - 'contactEmail', c.contact_email, - 'contactPhone', c.contact_phone, - 'contactPosition', c.contact_position, - 'isPrimary', c.is_primary, - 'contactCreatedAt', c.created_at, - 'contactUpdatedAt', c.updated_at - )), - '[]'::json - ) - FROM vendor_contacts c - WHERE c.vendor_id = "vendors"."id" - ) as "contacts", ( - SELECT COALESCE( - json_agg(json_build_object( - 'itemCode', pi.item_code, - 'itemName', i.item_name, - 'itemCreatedAt', pi.created_at, - 'itemUpdatedAt', pi.updated_at - )), - '[]'::json - ) - FROM vendor_possible_items pi - LEFT JOIN items i ON pi.item_code = i.item_code - WHERE pi.vendor_id = "vendors"."id" - ) as "possibleItems" from "vendor_investigations" left join "vendors" on "vendor_investigations"."vendor_id" = "vendors"."id");
\ No newline at end of file |