-- Create Table Statement for 'Country Code'
DROP TABLE IF EXISTS `IAPP_COUNTRY_CODE`;
CREATE TABLE `IAPP_COUNTRY_CODE` (
CODE varchar NOT NULL,
NAME varchar,
NUMERIC_CODE varchar,
CODE_EXTENDED varchar,
CURRENCY_CODE varchar,
REGION varchar,
POSITION int(11),
POSITION int(11),
POSITION int(11),
AMOUNT_FORMAT varchar,
AMOUNT_FORMAT varchar,
WEEKEND_DAY varchar,
AMOUNT_FORMAT varchar,
WEEKEND_DAY varchar,
TAX_ID_VALIDATION_PATTERN varchar,
TAX_ID_VALIDATION_PATTERN varchar,
VAT_NUMBER_VALIDATION_PATTERN varchar,
REGIONAL_COUNTRY_CODE_LIST varchar,
VAT_NUMBER_VALIDATION_PATTERN varchar,
REGIONAL_COUNTRY_CODE_LIST varchar,
WEEKEND_DAY varchar,
TAX_ID_VALIDATION_PATTERN varchar,
VAT_NUMBER_VALIDATION_PATTERN varchar,
REGIONAL_COUNTRY_CODE_LIST varchar,
PRIMARY KEY (CODE)
) ENGINE=InnoDB;