BL 4.0 Liquibase changelog for MySQL error
Posted: Sun Jun 21, 2015 8:40 am
The Liquibase MySQL changelog (https://github.com/BroadleafCommerce/docs/blob/4.0/Migration-Notes/databasemigrationMySql.xml) contains the following command, which will fail during database migration:
The correct command should be:
Code: Select all
<addPrimaryKey columnNames="PG_TMPLT_FLD_GRP_ID" tableName="PGTMPLT_FLDGRP_XREF_PK" />
The correct command should be:
Code: Select all
<addPrimaryKey columnNames="PG_TMPLT_FLD_GRP_ID" tableName="BLC_PGTMPLT_FLDGRP_XREF" constraintName="PGTMPLT_FLDGRP_XREF_PK" />