3/25 까지의 대표님 작업사항

1 files changed, 18 insertions, 0 deletions

diff --git a/db/migrations/0015_black_fixer.sql b/db/migrations/0015_black_fixer.sql
new file mode 100644
index 00000000..da6260c8
--- /dev/null
+++ b/db/migrations/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 "<constraint_name>";--> 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