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 VARCHAR(65535), data VARCHAR(10485760), new_status VARCHAR(60), old_status VARCHAR(60), audit_timestamp TIMESTAMP WITHOUT TIME ZONE, trk_application_context_id VARCHAR(36), trk_application_default_locale VARCHAR(255), trk_application_name VARCHAR(255), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, audit_creation_time TIMESTAMP WITHOUT TIME ZONE, audit_creator VARCHAR(60), audit_update_time TIMESTAMP WITHOUT TIME ZONE, audit_updater VARCHAR(60), trk_change_details VARCHAR(10485760), trk_creating_application_id VARCHAR(36), trk_current_message VARCHAR(255), trk_level INTEGER, trk_max_field_versions VARCHAR(10485760), trk_sandbox_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_sub_container_catalog VARCHAR(36), trk_change_container_id VARCHAR(36), trk_change_container_name VARCHAR(255), trk_change_container_route_key VARCHAR(60), trk_sub_container_name VARCHAR(255), trk_sandbox_change_type VARCHAR(60), trk_sandbox_context_id VARCHAR(36), trk_sandbox_name VARCHAR(255), trk_sandbox_owner VARCHAR(60), trk_sandbox_stage VARCHAR(60), trk_tenant_id VARCHAR(36), user_id VARCHAR(36), user_type VARCHAR(60), user_email VARCHAR(255), CONSTRAINT blc_cart_action_audit_pkey PRIMARY KEY (id));
ALTER TABLE blc_cart ADD account_hierarchy VARCHAR(65535);
ALTER TABLE blc_cart ADD account_id VARCHAR(36);
ALTER TABLE blc_cart ADD approver_email VARCHAR(255);
ALTER TABLE blc_cart ADD root_account_id VARCHAR(36);
ALTER TABLE blc_cart ADD approval_request_date TIMESTAMP WITHOUT TIME ZONE;