Is it safe to convert wp_users table to INNODB, so I can add a foreign key?

  • mplusplus

    (@mplusplus)


    3 years, 8 months ago

    Hi there

    Is it safe to convert the “wp_users” table to INNODB, so I can add a foreign key?
    I need to add a foreign key in my custom table, referencing the ID field in users table.

    Thanks.

    • This topic was modified 3 years, 8 months ago by Jan Dembowski.
Viewing 2 replies - 1 through 2 (of 2 total)
  • catacaustic

    (@catacaustic)

    3 years, 8 months ago

    You should be safe. I have various installations set up with the tables as InnoDB and I don’t have problems with any of those.

    I would suggest that you do a backup of the database first just in case someting does go wrong.

    Thread Starter mplusplus

    (@mplusplus)

    3 years, 8 months ago

    Hi @catacaustic
    So, WordPress upgrades normally work well, even if I change the users table to INNODB, right?

    Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Is it safe to convert wp_users table to INNODB, so I can add a foreign key?’ is closed to new replies.