ALTER TABLE blc_account_member ADD account_role_ids VARCHAR(500) NULL;
CREATE TABLE blc_acct_invite (id VARCHAR(36) NOT NULL, account_id VARCHAR(255) NOT NULL, attributes VARCHAR(255) NULL, email VARCHAR(255) NOT NULL, invite_exp_date datetime NULL, inviting_customer_id VARCHAR(255) NULL, phone VARCHAR(255) NULL, role_ids VARCHAR(255) 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_customer_context_id VARCHAR(36) NULL, trk_tenant_id VARCHAR(36) NULL, CONSTRAINT PK_BLC_ACCT_INVITE PRIMARY KEY (id));
ALTER TABLE blc_account_member MODIFY account_role_id VARCHAR(36) NULL;
ALTER TABLE blc_account_member MODIFY account_id VARCHAR(36) NULL;
ALTER TABLE blc_account_member MODIFY customer_id VARCHAR(36) NULL;
ALTER TABLE blc_account_member ADD active CHAR(1) DEFAULT 'N' NOT NULL;
ALTER TABLE blc_account_member ADD customer_full_name VARCHAR(255) NULL;
ALTER TABLE blc_customer ADD tax_id VARCHAR(255) NULL;
ALTER TABLE blc_customer ADD default_acct_id VARCHAR(255) NULL;
ALTER TABLE blc_account_address ADD visible_to_children VARCHAR(60) NULL;