-- Create Table Statement for 'Chip Application'
DROP TABLE IF EXISTS `CHIP_APPLICATION`;
CREATE TABLE `CHIP_APPLICATION` (
	ID bigint(20) NOT NULL,
	AID varchar,
	APPLICATION_VERSION varchar,
	APPLICATION_NAME varchar,
	APPLICATION_SELECTION_ID varchar,
	FLOOR_LIMIT varchar,
	THRESHOLD varchar,
	RANDOM_SELECTION_TARGET_PERCENTAGE int(11),
	RANDOM_SELECTION_MAX_PERCENTAGE int(11),
	TAC_DENIAL varchar,
	TAC_ONLINE varchar,
	TAC_DEFAULT varchar,
	DEFAULT_D_DOL varchar,
	DEFAULT_T_DOL varchar,
	PROVIDER_CODE bigint(20),
	RID varchar,
	PIX varchar,
	CARD_SCHEME_CL varchar,
	CVM_LIMIT varchar,
	CONTACTLESS_LIMIT varchar,
	IS_CONTACTLESS tinyint(1),
	PAYPASS_DEFAULT_UDOL varchar,
	MSTRIPE_APP_VERSION varchar,
	PAY_PASS_MCHIP_CARDINPUT_CAPABILITY varchar,
	PAYPASS_MCHIP_C_V_M_REQUIRED varchar,
	PAYPASS_M_STRIPE_APP_VERSION varchar,
	PAYPASS_C_V_M_REQUIRED varchar,
	PAYPASS_C_V_M_NOT_REQUIRED varchar,
	CLESS_C_V_M_LIMIT varchar,
	PAYPASS_KERNEL_CONFIG varchar,
	PAYPASS_CLESS_LIMIT_DCV varchar,
	PAYPASS_M_STRIPE_C_V_M_REQUIRED varchar,
	INTERNAL_TRANSACTION_TYPE varchar,
	PAY_PASS_M_STRIPE_CARDINPUT_CAPABILITY varchar,
	PAYPASS_MERCHANT_CUSTOM_DATA varchar,
	PAYPASS_SECURITY_CAPABILITY varchar,
	PAYPASS_EMV_TERMINAL_RISK_MANAGEMENT_DATA varchar,
	PAYPASS_CLESS_LIMIT_NO_DCV varchar,
	PAYPASS_M_STRIPE_APP_VERSION varchar,
	TRESHOLD_OLD int(11),
	TRESHOLD varchar,
	THRESHOLD varchar,
	PAYPASS_EMV_TERMINAL_RISK_MANAGEMENT_DATA varchar,
	PAYPASS_CLESS_LIMIT_NO_DCV varchar,
	PAYPASS_M_STRIPE_APP_VERSION varchar,
	THRESHOLD varchar,
	PAYPASS_EMV_TERMINAL_RISK_MANAGEMENT_DATA varchar,
	PAYPASS_CLESS_LIMIT_NO_DCV varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;