Sebastian Posts - Answer Overflow

Sebastian

Explore posts from servers

•Created by Sebastian on 7/9/2023 in #help

Cannot drop index 'idx': needed in a foreign key constraint

So I had this table with its migration in the database:

export const userProfile = mysqlTable('user_profile', {
        id: int("id").primaryKey().autoincrement()
    userId: int('user_id'),
    profilePicture: text('profile_picture').notNull(),
    updatedAt: datetime('updated_at'),
    bio: text('bio').notNull(),
    age: int('age').notNull(),
}, (userProfile) => ({
     userIdIndex: uniqueIndex("user_id_index").on(userProfile.userId)
}));

export const userProfile = mysqlTable('user_profile', {
        id: int("id").primaryKey().autoincrement()
    userId: int('user_id'),
    profilePicture: text('profile_picture').notNull(),
    updatedAt: datetime('updated_at'),
    bio: text('bio').notNull(),
    age: int('age').notNull(),
}, (userProfile) => ({
     userIdIndex: uniqueIndex("user_id_index").on(userProfile.userId)
}));

Then modified it to the following: ( dropped id and made the userId the primaryKey )

export const userProfile = mysqlTable('user_profile', {
    userId: int('user_id')
              .primaryKey()
          .references(() => users.id),,
    profilePicture: text('profile_picture').notNull(),
    updatedAt: datetime('updated_at'),
    bio: text('bio').notNull(),
    age: int('age').notNull(),
})

export const userProfile = mysqlTable('user_profile', {
    userId: int('user_id')
              .primaryKey()
          .references(() => users.id),,
    profilePicture: text('profile_picture').notNull(),
    updatedAt: datetime('updated_at'),
    bio: text('bio').notNull(),
    age: int('age').notNull(),
})

When I'm trying to apply the migration, I get the error: "Cannot drop index 'user_id_idx': needed in a foreign key constraint" How can this type of thing be safely done? And is it a drizzle problem?

2 replies

Gaming

Programming