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