Documentation Home

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; 

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