summaryrefslogtreecommitdiff
path: root/db/migrations/0014_good_radioactive_man.sql
diff options
context:
space:
mode:
authorjoonhoekim <26rote@gmail.com>2025-10-13 19:00:34 +0900
committerjoonhoekim <26rote@gmail.com>2025-10-13 19:00:34 +0900
commitb7069eccf7d54a9bb51c244207110c75a1d55f33 (patch)
treeea19187c3a8f6dd7d5969bc42c547915bae69f92 /db/migrations/0014_good_radioactive_man.sql
parent80e3d0befed487e0447bacffd76ed6539f01e992 (diff)
(김준회) migrations 기존 watched 파일 제거 (gitignore에 추가된 항목들)
Diffstat (limited to 'db/migrations/0014_good_radioactive_man.sql')
-rw-r--r--db/migrations/0014_good_radioactive_man.sql2
1 files changed, 0 insertions, 2 deletions
diff --git a/db/migrations/0014_good_radioactive_man.sql b/db/migrations/0014_good_radioactive_man.sql
deleted file mode 100644
index 25ac8f80..00000000
--- a/db/migrations/0014_good_radioactive_man.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-DROP VIEW "public"."vendor_candidates_with_vendor_info";--> statement-breakpoint
-CREATE VIEW "public"."vendor_candidates_with_vendor_info" AS (select "vendor_candidates"."id", "vendor_candidates"."company_name", "vendor_candidates"."contact_email", "vendor_candidates"."contact_phone", "vendor_candidates"."tax_id", "vendor_candidates"."address", "vendor_candidates"."country", "vendor_candidates"."source", "vendor_candidates"."status", "vendor_candidates"."remark", "vendor_candidates"."items", "vendor_candidates"."vendor_id", "vendor_candidates"."created_at", "vendor_candidates"."updated_at", "vendors"."vendor_name", "vendors"."vendor_code", "vendors"."created_at" AS vendor_created_at as "vendor_created_at" from "vendor_candidates" left join "vendors" on "vendor_candidates"."vendor_id" = "vendors"."id"); \ No newline at end of file