Support for Indexes & Constraints

[constantins2001]

When defining Indexes in Prisma those aren't reflected in the resulting drizzle schema.
Example:

model User {
  id                 String              @id
  email              String?
  emailVerified      Boolean             @default(false)
  createdAt          Int                 @default(dbgenerated("(unixepoch('subsecond') * 1000)"))

  @@index([email])
}

Actual

export const users = sqliteTable('User', {
    id: text('id').primaryKey(),
    email: text('email'),
    emailVerified: integer('emailVerified', {mode: 'boolean'}).default(false).notNull(),
    createdAt: integer('createdAt', {mode: 'number'}).default(sql`(unixepoch('subsecond') * 1000)`).notNull()
});

Expected

export const users = sqliteTable('User', {
    id: text('id').primaryKey(),
    email: text('email'),
    emailVerified: integer('emailVerified', {mode: 'boolean'}).default(false).notNull(),
    createdAt: integer('createdAt', {mode: 'number'}).default(sql`(unixepoch('subsecond') * 1000)`).notNull()
}, (table) => {
    return {
        emailIdx: index('email_idx').on(table.email)
    }
});