-- Create Table Statement for 'EFT1464 Canada Profile'
DROP TABLE IF EXISTS `EFT1464_CANADA_PROFILE`;
CREATE TABLE `EFT1464_CANADA_PROFILE` (
	ID bigint(20) NOT NULL,
	ORIGINATOR_ID_NUMBER_SALE varchar,
	ORIGINATOR_SHORT_NAME varchar,
	ORIGINATOR_LONG_NAME varchar,
	INSTITUTION_ID varchar,
	ACCOUNT_NUMBER varchar,
	SUNDRY_INFORMATION varchar,
	CONTACT_NAME varchar,
	CONTACT_PHONE_NUMBER varchar,
	ORIGINATOR_ID_NUMBER_CREDIT varchar,
	LAST_FILE_CREATION_NUMBER_SALE int(11),
	LAST_FILE_CREATION_NUMBER_CREDIT int(11),
	EFT1464_CANADA_PROFILE_CL varchar,
	DESTINATION_DATA_CENTRE_CODE varchar,
	IS_TEST_MODE tinyint(1),
	CODE_CPA varchar,
	CODE_CPA varchar,
	CODE_CPA varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;