CREATE TABLE blc_cart_action_audit (id VARCHAR(36) NOT NULL, action_type VARCHAR(60) NOT NULL, cart_id VARCHAR(36) NOT NULL, audit_comment LONGTEXT NULL, data LONGTEXT NULL, new_status VARCHAR(60) NULL, old_status VARCHAR(60) NULL, audit_timestamp datetime NULL, trk_application_context_id VARCHAR(36) NULL, trk_application_default_locale VARCHAR(255) NULL, trk_application_name VARCHAR(255) NULL, trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time datetime NULL, audit_creator VARCHAR(60) NULL, audit_update_time datetime NULL, audit_updater VARCHAR(60) NULL, trk_change_details LONGTEXT NULL, trk_creating_application_id VARCHAR(36) NULL, trk_current_message VARCHAR(255) NULL, trk_level INT NULL, trk_max_field_versions LONGTEXT NULL, trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36) NULL, trk_change_container_id VARCHAR(36) NULL, trk_change_container_name VARCHAR(255) NULL, trk_change_container_route_key VARCHAR(60) NULL, trk_sub_container_name VARCHAR(255) NULL, trk_sandbox_change_type VARCHAR(60) NULL, trk_sandbox_context_id VARCHAR(36) NULL, trk_sandbox_name VARCHAR(255) NULL, trk_sandbox_owner VARCHAR(60) NULL, trk_sandbox_stage VARCHAR(60) NULL, trk_tenant_id VARCHAR(36) NULL, user_id VARCHAR(36) NULL, user_type VARCHAR(60) NULL, user_email VARCHAR(255) NULL, CONSTRAINT PK_BLC_CART_ACTION_AUDIT PRIMARY KEY (id));
ALTER TABLE blc_cart ADD account_hierarchy LONGTEXT NULL;
ALTER TABLE blc_cart ADD account_id VARCHAR(36) NULL;
ALTER TABLE blc_cart ADD approver_email VARCHAR(255) NULL;
ALTER TABLE blc_cart ADD root_account_id VARCHAR(36) NULL;
ALTER TABLE blc_cart ADD approval_request_date datetime NULL;