Page 1 of 1

BL 4.0 Liquibase changelog for MySQL error

Posted: Sun Jun 21, 2015 8:40 am
by soulfly
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:

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" />