CREATE TABLE BLC_CART_ACTION_AUDIT (ID VARCHAR2(36 CHAR) NOT NULL, ACTION_TYPE VARCHAR2(60 CHAR) NOT NULL, CART_ID VARCHAR2(36 CHAR) NOT NULL, AUDIT_COMMENT CLOB, DATA CLOB, NEW_STATUS VARCHAR2(60 CHAR), OLD_STATUS VARCHAR2(60 CHAR), AUDIT_TIMESTAMP TIMESTAMP(6), TRK_APPLICATION_CONTEXT_ID VARCHAR2(36 CHAR), TRK_APPLICATION_DEFAULT_LOCALE VARCHAR2(255 CHAR), TRK_APPLICATION_NAME VARCHAR2(255 CHAR), TRK_ARCHIVED CHAR(1 CHAR) DEFAULT 'N' NOT NULL, AUDIT_CREATION_TIME TIMESTAMP(6), AUDIT_CREATOR VARCHAR2(60 CHAR), AUDIT_UPDATE_TIME TIMESTAMP(6), AUDIT_UPDATER VARCHAR2(60 CHAR), TRK_CHANGE_DETAILS CLOB, TRK_CREATING_APPLICATION_ID VARCHAR2(36 CHAR), TRK_CURRENT_MESSAGE VARCHAR2(255 CHAR), TRK_LEVEL NUMBER(10, 0), TRK_MAX_FIELD_VERSIONS CLOB, TRK_SANDBOX_ARCHIVED CHAR(1 CHAR) DEFAULT 'N' NOT NULL, TRK_SUB_CONTAINER_CATALOG VARCHAR2(36 CHAR), TRK_CHANGE_CONTAINER_ID VARCHAR2(36 CHAR), TRK_CHANGE_CONTAINER_NAME VARCHAR2(255 CHAR), TRK_CHANGE_CONTAINER_ROUTE_KEY VARCHAR2(60 CHAR), TRK_SUB_CONTAINER_NAME VARCHAR2(255 CHAR), TRK_SANDBOX_CHANGE_TYPE VARCHAR2(60 CHAR), TRK_SANDBOX_CONTEXT_ID VARCHAR2(36 CHAR), TRK_SANDBOX_NAME VARCHAR2(255 CHAR), TRK_SANDBOX_OWNER VARCHAR2(60 CHAR), TRK_SANDBOX_STAGE VARCHAR2(60 CHAR), TRK_TENANT_ID VARCHAR2(36 CHAR), USER_ID VARCHAR2(36 CHAR), USER_TYPE VARCHAR2(60 CHAR), USER_EMAIL VARCHAR2(255 CHAR), CONSTRAINT CT_YF5UVQI9694C9O6KSH7O PRIMARY KEY (ID));
ALTER TABLE BLC_CART ADD ACCOUNT_HIERARCHY CLOB;
ALTER TABLE BLC_CART ADD ACCOUNT_ID VARCHAR2(36 CHAR);
ALTER TABLE BLC_CART ADD APPROVER_EMAIL VARCHAR2(255 CHAR);
ALTER TABLE BLC_CART ADD ROOT_ACCOUNT_ID VARCHAR2(36 CHAR);
