Documentation Home

2.0.x to 2.1.0 Migration

This module requires at least Broadleaf 5.1.0-GA

What's changed?

  1. Use of @OrderBy instead of @OrderColumn
  2. Introduce broadleaf-contentmanagement-module as an optional dependency.

Migration

In your application's pom.xml, change the version for broadleaf-advanced-cms to 2.1.0-GA

Database Changes

In order to actually remove the restraints place by @OrderBy, you have to drop the primary key and re-add the primary key on just SC_FLD_TMPLT_ID.

Liquibase:

<dropPrimaryKey
            tableName="BLC_SC_FLDGRP_XREF"/>
<addPrimaryKey columnNames="SC_FLD_TMPLT_ID"
            tableName="BLC_SC_FLDGRP_XREF"/>
<dropNotNullConstraint
            columnDataType="int"
            columnName="GROUP_ORDER"/>

MySQL:

ALTER TABLE BLC_SC_FLDGRP_XREF DROP PRIMARY KEY;
ALTER TABLE BLC_SC_FLDGRP_XREF ADD PRIMARY KEY (SC_FLD_TMPLT_ID);
ALTER TABLE BLC_SC_FLDGRP_XREF MODIFY GROUP_ORDER INT NULL;