summaryrefslogtreecommitdiff
path: root/db/migrations/0050_furry_black_tarantula.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/0050_furry_black_tarantula.sql
parent230ce796836c25df26c130dbcd616ef97d12b2ec (diff)
로그인 및 미들웨어 처리. 구조 변경
Diffstat (limited to 'db/migrations/0050_furry_black_tarantula.sql')
-rw-r--r--db/migrations/0050_furry_black_tarantula.sql14
1 files changed, 0 insertions, 14 deletions
diff --git a/db/migrations/0050_furry_black_tarantula.sql b/db/migrations/0050_furry_black_tarantula.sql
deleted file mode 100644
index 66aaa47e..00000000
--- a/db/migrations/0050_furry_black_tarantula.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-CREATE TABLE "document_attachments" (
- "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "document_attachments_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1),
- "revision_id" integer NOT NULL,
- "file_name" varchar(255) NOT NULL,
- "file_path" varchar(1024) NOT NULL,
- "file_type" varchar(50),
- "file_size" integer,
- "created_at" timestamp DEFAULT now() NOT NULL,
- "updated_at" timestamp DEFAULT now() NOT NULL
-);
---> statement-breakpoint
-ALTER TABLE "document_attachments" ADD CONSTRAINT "document_attachments_revision_id_revisions_id_fk" FOREIGN KEY ("revision_id") REFERENCES "public"."revisions"("id") ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
-ALTER TABLE "revisions" DROP COLUMN "file_name";--> statement-breakpoint
-ALTER TABLE "revisions" DROP COLUMN "file_path"; \ No newline at end of file