ALTER TABLE BLC_ACCOUNT_MEMBER ADD ACCOUNT_ROLE_IDS VARCHAR2(500 BYTE);
CREATE TABLE BLC_ACCT_INVITE (ID VARCHAR2(36 CHAR) NOT NULL, ACCOUNT_ID VARCHAR2(255 CHAR) NOT NULL, ATTRIBUTES VARCHAR2(255 CHAR), EMAIL VARCHAR2(255 CHAR) NOT NULL, INVITE_EXP_DATE TIMESTAMP(6), INVITING_CUSTOMER_ID VARCHAR2(255 CHAR), PHONE VARCHAR2(255 CHAR), ROLE_IDS VARCHAR2(255 CHAR), 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_CUSTOMER_CONTEXT_ID VARCHAR2(36 CHAR), TRK_TENANT_ID VARCHAR2(36 CHAR), CONSTRAINT CT_3J55KW3OQWWDQWONS3N9 PRIMARY KEY (ID));
ALTER TABLE BLC_ACCOUNT_MEMBER MODIFY ACCOUNT_ROLE_IDS VARCHAR2(500 CHAR);
ALTER TABLE blc_account_member MODIFY account_role_id NULL;
ALTER TABLE BLC_ACCOUNT_MEMBER MODIFY ACCOUNT_ID NULL;
ALTER TABLE BLC_ACCOUNT_MEMBER MODIFY CUSTOMER_ID NULL;
ALTER TABLE BLC_ACCOUNT_MEMBER ADD ACTIVE CHAR(1 CHAR) DEFAULT 'N' NOT NULL;
ALTER TABLE BLC_ACCOUNT_MEMBER ADD CUSTOMER_FULL_NAME VARCHAR2(255 CHAR);
ALTER TABLE BLC_CUSTOMER ADD TAX_ID VARCHAR2(255 CHAR);
ALTER TABLE blc_customer ADD default_acct_id VARCHAR2(255 CHAR);
ALTER TABLE BLC_ACCOUNT_ADDRESS ADD VISIBLE_TO_CHILDREN VARCHAR2(60 CHAR);