-- Create Table Statement for 'Branding Profile'
DROP TABLE IF EXISTS `IAPP_BRANDING_PROFILE`;
CREATE TABLE `IAPP_BRANDING_PROFILE` (
	ID bigint(20) NOT NULL,
	OWNER_CL varchar,
	OWNER_CODE varchar,
	UNIPAY_PORTAL_URL varchar,
	UNIPAY_NAME varchar,
	UNICHARGE_NAME varchar,
	UNIBILL_NAME varchar,
	UNICHARGE_REALTIME_PROCESSING_URL varchar,
	UNICHARGE_BATCH_PROCESSING_URL varchar,
	UNICHARGE_REALTIME_SPECIFICATION_HOST varchar,
	UNICHARGE_BATCH_SPECIFICATION_HOST varchar,
	UNIBILL_PROCESSING_URL varchar,
	UNIBILL_SPECIFICATION_URL varchar,
	UNIPAY_DOCUMENTATION_URL varchar,
	SUPPORT_SYSTEM_URL varchar,
	SUPPORT_SYSTEM_USERNAME varchar,
	SUPPORT_SYSTEM_PASSWORD varchar,
	EXTERNAL_ONBOARDING_DOCUMENTATION_URL varchar,
	ONBOARDING_CONTACT_PHONE varchar,
	ONBOARDING_CONTACT_EMAIL varchar,
	MERCHANT_SERVICES_PHONE varchar,
	MERCHANT_SERVICES_FAX varchar,
	MERCHANT_SERVICES_EMAIL varchar,
	MERCHANT_WORK_HOURS varchar,
	SUPPORT_PHONE varchar,
	SUPPORT_FAX varchar,
	SUPPORT_EMAIL varchar,
	SUPPORT_WORK_HOURS varchar,
	IMAGE_DATA varchar,
	STYLE_DATA varchar,
	CONTENT_MAIN_LOGO_WEB_FK bigint(20),
	CONTENT_MAIN_LOGO_PRINT_FK bigint(20),
	CONTENT_POWERED_LOGO_WEB_FK bigint(20),
	CONTENT_POWERED_LOGO_PRINT_FK bigint(20),
	UNICHARGE_SPECIFICATION_URL varchar,
	UNIREAD_NAME varchar,
	UNIREAD_REALTIME_PROCESSING_URL varchar,
	UNIREAD_SPECIFICATION_URL varchar,
	COMPANY_NAME varchar,
	PARENT_COMPANY_NAME varchar,
	MERCHANT_ACCOUNT_CODE int(11),
	UNIREAD_PROCESSING_URL varchar,
	ONBOARDING_PAGES_URL varchar,
	ONBOARDING_PAGES_URL varchar,
	ONBOARDING_PAGES_URL varchar,
	SUPPORT_EMAIL varchar,
	MERCHANT_SERVICE_EMAIL_REPLY_TO varchar,
	SUPPORT_EMAIL_REPLY_TO varchar,
	MERCHANT_SERVICE_EMAIL_REPLY_TO varchar,
	SUPPORT_EMAIL_REPLY_TO varchar,
	MERCHANT_SERVICE_EMAIL_REPLY_TO varchar,
	SUPPORT_EMAIL_REPLY_TO varchar,
	SUPPORT_SYSTEM_URL varchar,
	SUPPORT_PHONE varchar,
	SUPPORT_EMAIL varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;