Drizzle Team•14mo ago

Add descending indexes in mySQL schema

I do not find how to add a descending index from a schema in mySQL. I know I could always execute the following line manually:

ALTER TABLE tablename ADD index col_desc_idx(col desc);

ALTER TABLE tablename ADD index col_desc_idx(col desc);

But I'd really like to be able to include it in the drizzle-kit push command because I know I will forget at some point otherwise. Any idea of how to accomplish it?

2 Replies

Angelelz•14mo ago

I believe this behavior is available in drizzle-orm but not yet supported in the kit. Maybe it is in the latest. You'll need to do some tests.

Angelelz•14mo ago

See here: https://orm.drizzle.team/docs/indexes-constraints#indexes

Indexes & Constraints - Drizzle ORM

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

Gaming

Programming

Add descending indexes in mySQL schema