-- Create Table Statement for 'Change Account'
DROP TABLE IF EXISTS `CHANGE_ACCOUNT`;
CREATE TABLE `CHANGE_ACCOUNT` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CUSTOMER_ACCOUNT_CODE varchar,
	CONTRACT_CODE varchar,
	CREATE_DATE datetime,
	LAST_UPDATE_DATE datetime,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	MIDDLE_NAME varchar,
	GENDER_CL varchar,
	BIRTH_DATE datetime,
	SOCIAL_SECURITY varchar,
	SOCIAL_SECURITY_ENCODED varchar,
	DRIVER_LICENSE_NUMBER varchar,
	DRIVER_LICENSE_NUMBER_ENCODED varchar,
	STREET1 varchar,
	STREET2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	HOME_PHONE varchar,
	WORK_PHONE varchar,
	CELL_PHONE varchar,
	EMAIL varchar,
	SKIN_TYPE_CL varchar,
	EYE_COLOR_CL varchar,
	STATUS_CL varchar,
	PAYMENT_OPTION_CODE varchar,
	PAYMENT_OPTION_CL varchar,
	PAYMENT_OPTION_HOLDER_NAME varchar,
	PAYMENT_OPTION_ACCOUNT_NUMBER varchar,
	PAYMENT_OPTION_TOKEN_CODE varchar,
	PAYMENT_OPTION_ACCOUNT_NUMBER_MASKED varchar,
	PAYMENT_OPTION_ACCESSORY varchar,
	PAYMENT_OPTION_ACCESSORY_MASKED varchar,
	PAYMENT_OPTION_STREET1 varchar,
	PAYMENT_OPTION_STREET2 varchar,
	PAYMENT_OPTION_CITY varchar,
	PAYMENT_OPTION_STATE varchar,
	PAYMENT_OPTION_ZIP_CODE varchar,
	PAYMENT_PLAN_CODE varchar,
	FREEZE_LENGTH int(11),
	FREEZE_START_INDEX int(11),
	FREEZE_START_DATE datetime,
	FREEZE_FEE_AMOUNT int(11),
	POSTER_CODE varchar,
	SALES_PERSON_CODE varchar,
	SALES_PERSON_NUMBER1 varchar,
	IS_PERSONAL_CHANGED tinyint(1),
	IS_ADDRESS_CHANGED tinyint(1),
	IS_PAYMENT_OPTION_CHANGED tinyint(1),
	IS_CANCELLED_AUTO_RENEWAL tinyint(1),
	STORE_NUMBER varchar,
	FREEZE_REASON_CODE varchar,
	CANCELLATION_REASON_CODE varchar,
	DRAWER_ID varchar,
	PAYMENT_CL varchar,
	PAYMENT_CREDIT_CARD_CL varchar,
	SERVICE_TAX_RATE float,
	SERVICE_TAX_AMOUNT int(11),
	IS_MARKETING_EMAIL_ALLOWED tinyint(1),
	IS_BILLING_EMAIL_ALLOWED tinyint(1),
	IS_EMAIL_COMMUNICATION_TERMS_CHANGED tinyint(1),
	IS_MARKETING_CALL_ALLOWED tinyint(1),
	BONUS_BUCKS_AMOUNT int(11),
	PRIMARY KEY ()
) ENGINE=InnoDB;