php-migration icon indicating copy to clipboard operation
php-migration copied to clipboard

Published 20 hours ago • verified publisher icon byjg

Add primary KEY to migration_table

Open mrcnpdlk opened this issue 3 years ago • 1 comments

For Percona XtraDB Cluster tables without primary keys are prohibited: Uncaught PDOException: SQLSTATE[HY000]: General error: 1105 Percona-XtraDB-Cluster prohibits use of DML command on a table (my_base.migration_version) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER What about adding the primary key on version column? I can prepare the patch.

mrcnpdlk avatar Mar 31 '21 15:03 mrcnpdlk

It is cool a feature and I am happy to have this patch from you.

Quick question: Are you able to create the Patch for the other Databases too?

byjg avatar Mar 31 '21 16:03 byjg