ALTER TABLE blc_order_fulfillment_item ADD attributes VARCHAR(10485760);
ALTER TABLE blc_order_fulfillment_item ADD internal_attributes VARCHAR(10485760);
ALTER TABLE blc_order_payment ADD adjustments_total numeric(19, 5);
ALTER TABLE blc_order_payment ADD display_attributes VARCHAR(10485760);
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);
ALTER TABLE blc_order_payment ADD fulfillment_total numeric(19, 5);
ALTER TABLE blc_order_payment ADD subtotal numeric(19, 5);
ALTER TABLE blc_order_payment ADD tax_total numeric(19, 5);
ALTER TABLE blc_order_payment_transaction ADD management_state VARCHAR(60);
ALTER TABLE blc_order ADD vouchers VARCHAR(10485760);
ALTER TABLE blc_order_item ADD brand_id VARCHAR(36);
ALTER TABLE blc_order_item ADD category_ids VARCHAR(65535);
ALTER TABLE blc_order_item ADD discountable CHAR(1) DEFAULT 'Y' NOT NULL;
ALTER TABLE blc_order_item ADD merchandising_context VARCHAR(255);
ALTER TABLE blc_order_item ADD merchandising_type_id VARCHAR(36);
ALTER TABLE blc_order_item ADD pricing_strategy VARCHAR(255);
ALTER TABLE blc_order_item ADD product_tags VARCHAR(65535);
ALTER TABLE blc_order_item ADD target_demographic_id VARCHAR(36);
ALTER TABLE blc_order_item ADD vendor_ref VARCHAR(255);
