diff options
Diffstat (limited to 'db/migrations_backup/0015_black_fixer.sql')
| -rw-r--r-- | db/migrations_backup/0015_black_fixer.sql | 18 |
1 files changed, 0 insertions, 18 deletions
diff --git a/db/migrations_backup/0015_black_fixer.sql b/db/migrations_backup/0015_black_fixer.sql deleted file mode 100644 index da6260c8..00000000 --- a/db/migrations_backup/0015_black_fixer.sql +++ /dev/null @@ -1,18 +0,0 @@ -/* - 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 |
