Broadleaf CartRules 1.1.x-GA to 1.2.x-GA Migration
These migration notes assumes that you are using either BLC-5.2 or BLC-6.0 and are looking to use the additional functionality that requires Schema change.
Module Compatibility
These functionality has been tested on BLC-5.2 as well as BLC-6.0.
Database Changes
New Columns
| Table Name | New Column(s) |
|---|---|
BLC_CART_RULE |
TIMES_PER_CUSTOMER |
BLC_CART_RULE |
TARGET_MIN_TOTAL |
BLC_CART_RULE_ACTION |
IS_DEFAULT_PRODUCT |
BLC_CART_RULE_ACTION |
ACTION_SKU_ID |
SQL For Column Changes
ALTER TABLE BLC_CART_RULE ADD TIMES_PER_CUSTOMER INT(11), ADD TARGET_MIN_TOTAL DECIMAL(19,5);
ALTER TABLE BLC_CART_RULE_ACTION ADD IS_DEFAULT_PRODUCT TINYINT(1), ADD ACTION_SKU_ID BIGINT(20);