-- Create Table Statement for 'Terminal Profile'
DROP TABLE IF EXISTS `TERMINAL_PROFILE`;
CREATE TABLE `TERMINAL_PROFILE` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TERMINAL_CODE bigint(20),
	CONNECTION_CL varchar,
	GATEWAY_HOST varchar,
	READ_TIMEOUT int(11),
	IDLE_MESSAGE varchar,
	IS_C_S_C_ENABLED tinyint(1),
	IS_TIP_ENABLED tinyint(1),
	IS_OFFLINE_AUTH_ENABLED tinyint(1),
	OFFLINE_AUTH_LIMIT int(11),
	OFFLINE_AUTH_SYNC_TIME int(11),
	DATE_FORMAT varchar,
	CURRENT_UPDATE_CODE bigint(20),
	IS_CASHBACK_ENABLED tinyint(1),
	OPERATION_TYPE_CL varchar,
	LAST_UPDATE_DATE datetime,
	CONNECTION_PATH varchar,
	IS_AMOUNT_CONFIRMATION_ENABLED tinyint(1),
	TIME_FORMAT varchar,
	PAYMENT_POLICY varchar,
	RECEIPT_POLICY varchar,
	ENTRY_MODE_POLICY varchar,
	UPDATE_PROFILE varchar,
	UPDATE_VERSION varchar,
	ADVERTISING_PROFILE varchar,
	ADVERTISING_VERSION varchar,
	PARAMETERS_VERSION varchar,
	ADMIN_PIN varchar,
	MANAGER_PIN varchar,
	PASSWORD varchar,
	SECRET_KEY varchar,
	TMS_HOST varchar,
	LOCK_LIST varchar,
	APPLICATION_ID_POLICY varchar,
	LAST_PASSWORD_GENERATION_DATE datetime,
	INITIALIZATION_DATE datetime,
	ACTIVATION_DATE datetime,
	COUNTRY_CODE varchar,
	CURRENCY_CODE varchar,
	TIME_ZONE_CL varchar,
	COMMUNICATION_PROTOCOL_CL varchar,
	DEFAULT_INDUSTRY_CL varchar,
	IS_CONVENIENCE_FEE_ENABLED tinyint(1),
	IS_OFFLINE_CREDIT_ENABLED tinyint(1),
	OFFLINE_TRANSACTION_POLICY_CL varchar,
	IS_PIN_BYPASS_ENABLED tinyint(1),
	RECEIPT_PRINTING_ORDER_TYPE_CL varchar,
	CLOUD_HOST varchar,
	CLOUD_PORT int(11),
	IS_SIGNATURE_CONFIRMATION_ENABLED tinyint(1),
	NEW_MERCHANT_ACCOUNT_CODE int(11),
	NEW_TERMINAL_CODE bigint(20),
	CURRENCY_SIGN varchar,
	PIN_PAD_CL varchar,
	VERSION int(11),
	IS_APPLICATION_SELECTION_ENABLED tinyint(1),
	ENCRYPTION_TYPE_CL varchar,
	ENCRYPTION_TYPE_CL varchar,
	THEME_TYPE_CL varchar,
	THEME_TYPE_CL varchar,
	THEME_TYPE_CL varchar,
	ENCRYPTION_TYPE_CL varchar,
	ENCRYPTION_TYPE_CL varchar binary,
	ENCRYPTION_TYPE_CL varchar binary,
	UPDATE_PROFILE varchar,
	UPDATE_PROFILE varchar,
	UPDATE_PROFILE varchar,
	UPDATE_PROFILE varchar,
	ENCRYPTION_CL varchar binary,
	OFFLINE_TRANSACTION_MODE varchar,
	OPERATION_CL varchar,
	RECEIPT_PRINTING_ORDER_CL varchar,
	THEME_CL varchar,
	TERMINAL_MODE varchar,
	IS_DEBIT_PRIORITIZATION_ENABLED tinyint(1),
	IS_DEBIT_PRIORITIZATION_ENABLED tinyint(1),
	IS_DEBIT_PRIORITIZATION_ENABLED tinyint(1),
	CONNECTION_CL varchar,
	ENCRYPTION_CL varchar binary,
	OFFLINE_TRANSACTION_MODE varchar,
	OPERATION_CL varchar,
	RECEIPT_PRINTING_ORDER_CL varchar,
	THEME_CL varchar,
	TERMINAL_MODE varchar,
	CONNECTION_CL varchar,
	APPLICATION_ID_POLICY varchar,
	PAYMENT_POLICY varchar,
	IS_DEBIT_PRIORITIZATION_ENABLED tinyint(1),
	ENCRYPTION_CL varchar binary,
	OFFLINE_TRANSACTION_MODE varchar,
	OPERATION_CL varchar,
	RECEIPT_PRINTING_ORDER_CL varchar,
	THEME_CL varchar,
	TERMINAL_MODE varchar,
	APPLICATION_ID_POLICY varchar,
	APPLICATION_ID_POLICY varchar,
	LOG_LEVEL_CL varchar,
	LOG_LEVEL_CL varchar,
	LOG_LEVEL_CL varchar,
	IS_REWARD_NUMBER_ENABLED tinyint(1),
	IS_REWARD_NUMBER_ENABLED tinyint(1),
	GATEWAY_HOST varchar,
	GATEWAY_HOST varchar,
	PAYMENT_POLICY varchar,
	PAYMENT_POLICY varchar,
	IS_REWARD_NUMBER_ENABLED tinyint(1),
	ENCRYPTION_TYPE_CL varchar binary,
	ENCRYPTION_CL varchar binary,
	ENCRYPTION_TYPE_CL varchar binary,
	ENCRYPTION_CL varchar binary,
	SECRET_KEY varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;