From fed3dc0349be8faa5a94048e2ce2d96e432bf734 Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Fri, 10 Oct 2025 11:45:48 +0900
Subject: (김준회) chore: migrations_backup 경로 제거
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/migrations_backup/0099_clear_captain_marvel.sql | 31 ----------------------
 1 file changed, 31 deletions(-)
 delete mode 100644 db/migrations_backup/0099_clear_captain_marvel.sql

(limited to 'db/migrations_backup/0099_clear_captain_marvel.sql')

diff --git a/db/migrations_backup/0099_clear_captain_marvel.sql b/db/migrations_backup/0099_clear_captain_marvel.sql
deleted file mode 100644
index f2db52f8..00000000
--- a/db/migrations_backup/0099_clear_captain_marvel.sql
+++ /dev/null
@@ -1,31 +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(
-            'itemId', pi.id,
-            '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
-- 
cgit v1.2.3

