push:mysql dropping unique index

i think drizzle generates the following when it needs to drop a unique index

ALTER TABLE `stage` DROP CONSTRAINT `name`;

ALTER TABLE `stage` DROP CONSTRAINT `name`;

this doesn't work - i think it should be

alter table `stage` drop key `name`

alter table `stage` drop key `name`

2 Replies

thdxrOP•15mo ago

my workflow for figuring this out is just modifying the schema and seeing what planetscale generates as a diff - figure they know what they're doing when adding they also do

alter table `stage`   ADD UNIQUE KEY `name` (`app_id`, `aws_account_id`, `region`, `name`)

alter table `stage`   ADD UNIQUE KEY `name` (`app_id`, `aws_account_id`, `region`, `name`)

doesn't seem lke they use the term CONSTRAINT anywhere

Andrii Sherman•15mo ago

known issue need to finish the last task for the drizzle-orm that I was responsible for after that will add all the fixes to the kit that are waiting to be released thanks!

Gaming

Programming

push:mysql dropping unique index