summaryrefslogtreecommitdiff
path: root/db/migrations/0040_absurd_human_cannonball.sql
diff options
context:
space:
mode:
authordujinkim <dujin.kim@dtsolution.co.kr>2025-04-08 03:08:19 +0000
committerdujinkim <dujin.kim@dtsolution.co.kr>2025-04-08 03:08:19 +0000
commit9ceed79cf32c896f8a998399bf1b296506b2cd4a (patch)
treef84750fa6cac954d5e31221fc47a54c655fc06a9 /db/migrations/0040_absurd_human_cannonball.sql
parent230ce796836c25df26c130dbcd616ef97d12b2ec (diff)
로그인 및 미들웨어 처리. 구조 변경
Diffstat (limited to 'db/migrations/0040_absurd_human_cannonball.sql')
-rw-r--r--db/migrations/0040_absurd_human_cannonball.sql15
1 files changed, 0 insertions, 15 deletions
diff --git a/db/migrations/0040_absurd_human_cannonball.sql b/db/migrations/0040_absurd_human_cannonball.sql
deleted file mode 100644
index 7a6170f5..00000000
--- a/db/migrations/0040_absurd_human_cannonball.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-CREATE TABLE "tag_types" (
- "code" varchar(50) PRIMARY KEY NOT NULL,
- "description" text NOT NULL,
- "created_at" timestamp with time zone DEFAULT now() NOT NULL,
- "updated_at" timestamp with time zone DEFAULT now() NOT NULL
-);
---> statement-breakpoint
-ALTER TABLE "tag_subfields" DROP CONSTRAINT "tag_subfields_tag_type_code_unique";--> statement-breakpoint
-ALTER TABLE "tag_classes" DROP CONSTRAINT "tag_classes_tag_type_code_tag_subfields_tag_type_code_fk";
---> statement-breakpoint
-ALTER TABLE "tag_classes" ALTER COLUMN "id" SET DATA TYPE serial;--> statement-breakpoint
-ALTER TABLE "tag_classes" ALTER COLUMN "id" DROP IDENTITY;--> statement-breakpoint
-ALTER TABLE "tag_classes" ADD CONSTRAINT "tag_classes_tag_type_code_tag_types_code_fk" FOREIGN KEY ("tag_type_code") REFERENCES "public"."tag_types"("code") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "tag_subfields" ADD CONSTRAINT "tag_subfields_tag_type_code_tag_types_code_fk" FOREIGN KEY ("tag_type_code") REFERENCES "public"."tag_types"("code") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "tag_subfields" DROP COLUMN "tag_type_description"; \ No newline at end of file