Foreign Key Support?

  • Resolved mholubowski

    (@mholubowski)


    4 years ago

    Hi! Are foreign key constraints on custom tables supported by Duplicator?

    For example, the following SQL is used to create a foreign key constraint upon activation of the plugin in question:

        "ALTER TABLE wp_custom_table_visits
      ADD CONSTRAINT FK_visits_user_id FOREIGN KEY IF NOT EXISTS (user_id) 
      REFERENCES wp_custom_table_users(id);"

    Could you please point us in the right direction? Thank you so much!

Viewing 1 replies (of 1 total)
  • Cory Lamle

    (@corylamleorg)

    Hey @mholubowski,

    Yes. Both build modes mysqldump and PHP should both handle Foreign key creation. Let us know if you run into any issues.

    Thanks

Viewing 1 replies (of 1 total)
  • The topic ‘Foreign Key Support?’ is closed to new replies.