DT
Drizzle Team•16mo ago
hotshoe

compound uniqueIndex

In Prisma, I have in my schema definition the following declaration that requires userId and timestamp tuple to be unique: 
@@unique([userId, time])
@@unique([userId, time])
How can I express the same using drizzle kit schema file?
3 Replies
Andrii Sherman
Andrii Sherman•16mo ago
https://github.com/drizzle-team/drizzle-orm/blob/main/drizzle-orm/src/pg-core/README.md#declaring-indexes-foreign-keys-and-composite-primary-keys here is an example for postgres
GitHub
drizzle-orm/README.md at main · drizzle-team/drizzle-orm
TypeScript ORM for SQL. Contribute to drizzle-team/drizzle-orm development by creating an account on GitHub.
Andrii Sherman
Andrii Sherman•16mo ago
You can find a part with namePopulationIdx 
namePopulationIdx: index('name_population_idx').on(countries.name, countries.population), // multiple columns
namePopulationIdx: index('name_population_idx').on(countries.name, countries.population), // multiple columns
hotshoe
hotshoe•16mo ago
Thanks for the quick response!
Want results from more Discord servers?
Add your server
More Posts
planetscale: how to index col using drizzle?Hi, seems most of the samples are pg. I'm using planetscale, and no having any luck figuring out how[Bug?] Drizzle generates a broken query when passing an explicit value for a column as `undefined`I've translated most of my logic from Prisma usage -> Drizzle. Noticed an issue where when explicitlHelp improving my queryIf feel like this is far from how what it actually should look like in drizzle could I get some poinLeft join with JSONI'm using PlanetScale (MySQL) and have 2 tables: orders and products. Every order contains basic infDrizzle-kit throws module not found error for internal files imported through absolute pathI've attached the error log and how the error was fixed.drizzle bug won't let me update mysql tablewrote a bug ticket on github describing the bug but just wanted to post here as well for visibility Generated Collate valueNot sure if this is relevant but I'm translating a Prisma schema into drizzle. Every Prisma table haCan I know when I can use Mysql proxy driver?Hi, I’m Daun and I’m a huge fan of drizzle. i’m really grateful that drizzle is open source and have