diff options
| author | joonhoekim <26rote@gmail.com> | 2025-10-10 11:45:48 +0900 |
|---|---|---|
| committer | joonhoekim <26rote@gmail.com> | 2025-10-10 11:45:48 +0900 |
| commit | fed3dc0349be8faa5a94048e2ce2d96e432bf734 (patch) | |
| tree | 1c81e9b2e98d9869225a2897fd2a0d2c9398a556 /db/migrations_backup/0073_damp_reaper.sql | |
| parent | 631b09172b48ec24c4f0131bc97017b87ddf0c47 (diff) | |
(김준회) chore: migrations_backup 경로 제거
Diffstat (limited to 'db/migrations_backup/0073_damp_reaper.sql')
| -rw-r--r-- | db/migrations_backup/0073_damp_reaper.sql | 13 |
1 files changed, 0 insertions, 13 deletions
diff --git a/db/migrations_backup/0073_damp_reaper.sql b/db/migrations_backup/0073_damp_reaper.sql deleted file mode 100644 index 437a2d04..00000000 --- a/db/migrations_backup/0073_damp_reaper.sql +++ /dev/null @@ -1,13 +0,0 @@ -DROP VIEW "public"."vendor_rfq_view";--> statement-breakpoint -DROP VIEW "public"."vendor_rfqs_view";--> statement-breakpoint -DROP VIEW "public"."vendor_tbe_view";--> statement-breakpoint -ALTER TABLE "rfqs" ADD COLUMN "project_id" integer;--> statement-breakpoint -ALTER TABLE "rfqs" ADD COLUMN "rfq_type" varchar(30) DEFAULT 'PURCHASE';--> statement-breakpoint -ALTER TABLE "rfqs" ADD COLUMN "parent_rfq_id" integer;--> statement-breakpoint -ALTER TABLE "rfqs" ADD CONSTRAINT "rfqs_project_id_projects_id_fk" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint -ALTER TABLE "rfqs" ADD CONSTRAINT "rfqs_parent_rfq_id_rfqs_id_fk" FOREIGN KEY ("parent_rfq_id") REFERENCES "public"."rfqs"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint -ALTER TABLE "rfqs" DROP COLUMN "project_code";--> statement-breakpoint -ALTER TABLE "rfqs" DROP COLUMN "project_name";--> statement-breakpoint -CREATE VIEW "public"."vendor_rfq_view" AS (select "vendors"."id" as "vendor_id", "vendors"."vendor_name" as "vendor_name", "vendors"."vendor_code" as "vendor_code", "vendors"."address" as "address", "vendors"."country" as "country", "vendors"."email" as "email", "vendors"."website" as "website", "vendors"."status" as "vendor_status", "rfq_vendors"."rfq_id" as "rfq_id", "rfq_vendors"."status" as "rfq_vendor_status", "rfq_vendors"."updated_at" as "rfq_vendor_updated", "rfqs"."rfq_code" as "rfq_code", "rfqs"."description" as "description", "rfqs"."due_date" as "due_date", "projects"."id" as "project_id", "projects"."code" as "project_code", "projects"."name" as "project_name" from "vendors" left join "rfq_vendors" on "rfq_vendors"."vendor_id" = "vendors"."id" left join "rfqs" on "rfq_vendors"."rfq_id" = "rfqs"."id" left join "projects" on "rfqs"."project_id" = "projects"."id");--> statement-breakpoint -CREATE VIEW "public"."vendor_rfqs_view" AS (select "rfqs"."id" as "id", "rfqs"."status" as "status", "rfqs"."created_at" as "created_at", "rfqs"."updated_at" as "updated_at", "rfqs"."created_by" as "created_by", "rfq_vendors"."id" as "rfq_vendor_id", "rfq_vendors"."vendor_id" as "vendor_id", "rfq_vendors"."status" as "rfq_vendor_status", "rfq_vendors"."updated_at" as "rfq_vendor_updated", "rfqs"."rfq_code" as "rfq_code", "rfqs"."description" as "description", "rfqs"."due_date" as "due_date", "projects"."id" as "project_id", "projects"."code" as "project_code", "projects"."name" as "project_name" from "rfq_vendors" inner join "rfqs" on "rfq_vendors"."rfq_id" = "rfqs"."id" left join "projects" on "rfqs"."project_id" = "projects"."id");--> statement-breakpoint -CREATE VIEW "public"."vendor_tbe_view" AS (select "vendors"."id" as "vendor_id", "vendors"."vendor_name" as "vendor_name", "vendors"."vendor_code" as "vendor_code", "vendors"."address" as "address", "vendors"."country" as "country", "vendors"."email" as "email", "vendors"."website" as "website", "vendors"."status" as "vendor_status", "rfq_vendors"."rfq_id" as "rfq_id", "rfq_vendors"."status" as "rfq_vendor_status", "rfq_vendors"."updated_at" as "rfq_vendor_updated", "rfqs"."rfq_code" as "rfq_code", "rfqs"."description" as "description", "rfqs"."due_date" as "due_date", "projects"."id" as "project_id", "projects"."code" as "project_code", "projects"."name" as "project_name", "rfq_evaluations"."id" as "tbe_id", "rfq_evaluations"."result" as "tbe_result", "rfq_evaluations"."notes" as "tbe_note", "rfq_evaluations"."updated_at" as "tbe_updated" from "vendors" left join "rfq_vendors" on "rfq_vendors"."vendor_id" = "vendors"."id" left join "rfqs" on "rfq_vendors"."rfq_id" = "rfqs"."id" left join "projects" on "rfqs"."project_id" = "projects"."id" left join "rfq_evaluations" on ("rfq_evaluations"."vendor_id" = "vendors"."id" and "rfq_evaluations"."eval_type" = 'TBE' and "rfq_evaluations"."rfq_id" = "rfq_vendors"."rfq_id"));
\ No newline at end of file |