-- Create Table Statement for 'Routing Number'
DROP TABLE IF EXISTS `IAPP_ROUTING_NUMBER`;
CREATE TABLE `IAPP_ROUTING_NUMBER` (
	CODE int(11) NOT NULL,
	ROUTING_NUMBER varchar,
	ENCODED_ROUTING_NUMBER varchar,
	NEW_ROUTING_NUMBER varchar,
	ENCODED_NEW_ROUTING_NUMBER varchar,
	OFFICE_CODE varchar,
	SERVICING_FRB_NUMBER varchar,
	RECORD_TYPE_CODE varchar,
	CHANGE_DATE datetime,
	BANK_NAME varchar,
	COUNTRY varchar,
	STREET varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	PHONE_NUMBER varchar,
	IS_CHANGED tinyint(1),
	BIC varchar,
	BRANCH varchar,
	CREATE_DATE datetime,
	COUNTRY_CODE varchar,
	PRIMARY KEY (CODE)
) ENGINE=InnoDB;