5.0 to 5.1.0-GA Migration

Database Changes

New Columns

Table Name	New Column(s)
`BLC_CATEGORY`	`ROOT_DISPLAY_ORDER`
`BLC_URL_HANDLER`	`IS_REGEX`

Deleted Columns

Table Name	Old Column(s)
`BLC_CATEGORY_ATTRIBUTE`	`SEARCHABLE`
`BLC_PRODUCT_ATTRIBUTE`	`SEARCHABLE`
`BLC_SKU_ATTRIBUTE`	`SEARCHABLE`

SQL For Column Changes

-- Create ROOT_DISPLAY_ORDER column
ALTER TABLE BLC_CATEGORY ADD ROOT_DISPLAY_ORDER DECIMAL(10,6);
ALTER TABLE BLC_URL_HANDLER ADD IS_REGEX TINYINT(1);
ALTER TABLE BLC_URL_HANDLER ADD KEY `IS_REGEX_HANDLER_INDEX` (`IS_REGEX`);
ALTER TABLE BLC_CATEGORY_ATTRIBUTE DROP SEARCHABLE; 
ALTER TABLE BLC_PRODUCT_ATTRIBUTE DROP SEARCHABLE; 
ALTER TABLE BLC_SKU_ATTRIBUTE DROP SEARCHABLE;

Note: Categories are ordered using the relationship to their parent category (CategoryXrefImpl#displayOrder). In the case of any top level
categories, there is not a parent category and therefore not a xref relationship to pull the displayOrder from. Therefore, we introduced the
rootDisplayOrder to capture the displayOrder for all top-level categories. After adding the column, all top-level categories must be updated
with non-null values for ROOT_DISPLAY_ORDER according to the desired display order.

Other Notable changes

Removed the API classes from the core framework

Thymeleaf 3 support

See the 5.1 Thymeleaf Migration section

API Updates

See the [[5.1 Release Notes | 5.1.0 GA]] for more information