From 9ceed79cf32c896f8a998399bf1b296506b2cd4a Mon Sep 17 00:00:00 2001 From: dujinkim Date: Tue, 8 Apr 2025 03:08:19 +0000 Subject: 로그인 및 미들웨어 처리. 구조 변경 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/migrations_backup/0015_black_fixer.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 db/migrations_backup/0015_black_fixer.sql (limited to 'db/migrations_backup/0015_black_fixer.sql') diff --git a/db/migrations_backup/0015_black_fixer.sql b/db/migrations_backup/0015_black_fixer.sql new file mode 100644 index 00000000..da6260c8 --- /dev/null +++ b/db/migrations_backup/0015_black_fixer.sql @@ -0,0 +1,18 @@ +/* + Unfortunately in current drizzle-kit version we can't automatically get name for primary key. + We are working on making it available! + + Meanwhile you can: + 1. Check pk name in your database, by running + SELECT constraint_name FROM information_schema.table_constraints + WHERE table_schema = 'public' + AND table_name = 'items' + AND constraint_type = 'PRIMARY KEY'; + 2. Uncomment code below and paste pk name manually + + Hope to release this update as soon as possible +*/ + +-- ALTER TABLE "items" DROP CONSTRAINT "";--> statement-breakpoint +ALTER TABLE "items" ALTER COLUMN "item_code" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "items" ADD CONSTRAINT "items_item_code_unique" UNIQUE("item_code"); \ No newline at end of file -- cgit v1.2.3