ALTER TABLE blc_order_fulfillment_item ADD attributes LONGTEXT NULL;
ALTER TABLE blc_order_fulfillment_item ADD internal_attributes LONGTEXT NULL;
ALTER TABLE blc_order_payment ADD adjustments_total DECIMAL(19, 5) DEFAULT null NULL;
ALTER TABLE blc_order_payment ADD display_attributes LONGTEXT NULL;
ALTER TABLE blc_order_payment ADD single_use_payment_method CHAR(1) DEFAULT 'N' NOT NULL;
ALTER TABLE blc_order_payment ADD name VARCHAR(255) NULL;
ALTER TABLE blc_order_payment ADD fulfillment_total DECIMAL(19, 5) DEFAULT null NULL;
ALTER TABLE blc_order_payment ADD subtotal DECIMAL(19, 5) DEFAULT null NULL;
ALTER TABLE blc_order_payment ADD tax_total DECIMAL(19, 5) DEFAULT null NULL;
ALTER TABLE blc_order_payment_transaction ADD management_state VARCHAR(60) NULL;
ALTER TABLE blc_order ADD vouchers LONGTEXT NULL;
ALTER TABLE blc_order_item ADD brand_id VARCHAR(36) NULL;
ALTER TABLE blc_order_item ADD category_ids LONGTEXT NULL;
ALTER TABLE blc_order_item ADD discountable CHAR(1) DEFAULT 'Y' NOT NULL;
ALTER TABLE blc_order_item ADD merchandising_context VARCHAR(255) NULL;
ALTER TABLE blc_order_item ADD merchandising_type_id VARCHAR(36) NULL;
ALTER TABLE blc_order_item ADD pricing_strategy VARCHAR(255) NULL;
ALTER TABLE blc_order_item ADD product_tags LONGTEXT NULL;
ALTER TABLE blc_order_item ADD target_demographic_id VARCHAR(36) NULL;
ALTER TABLE blc_order_item ADD vendor_ref VARCHAR(255) NULL;