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