-- Create Table Statement for 'CC Compass Profile'
DROP TABLE IF EXISTS `CC_COMPASS_PROFILE`;
CREATE TABLE `CC_COMPASS_PROFILE` (
	ID bigint(20) NOT NULL,
	MERCHANT_NAME varchar,
	PID varchar,
	PID_PASSWORD varchar,
	SID varchar,
	SID_PASSWORD varchar,
	CUSTOMER_SERVICE_PHONE_NUMBER varchar,
	DIVISION_NUMBER varchar,
	ITEM_DESCRIPTION varchar,
	FILENAME varchar,
	TPP_ID varchar,
	CC_COMPASS_PROFILE_CL varchar,
	DESCRIPTOR_PREFIX varchar,
	DESCRIPTOR varchar,
	MERCHANT_STREET varchar,
	MERCHANT_CITY varchar,
	MERCHANT_REGION varchar,
	MERCHANT_POSTAL_CODE varchar,
	MERCHANT_COUNTRY_CODE varchar,
	MERCHANT_LOCATION_ID varchar,
	MERCHANT_EMAIL varchar,
	MERCHANT_CATEGORY_CODE varchar,
	MERCHANT_LOCATION_ID varchar,
	MERCHANT_EMAIL varchar,
	MERCHANT_CATEGORY_CODE varchar,
	MERCHANT_LOCATION_ID varchar,
	MERCHANT_EMAIL varchar,
	MERCHANT_CATEGORY_CODE varchar,
	ITEM_DESCRIPTION bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;