-- 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;