CREATE TABLE `SUPPLIER` ( `PROCUBE_SEQ_ID` varchar(20) NOT NULL, `ADDRESS` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `SUPPLIER_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `FO_DUNS_ID` varchar(20) DEFAULT NULL, `PROC_FK` varchar(20) NOT NULL, `COUNTRY_FK` varchar(20) NOT NULL, `AMOUNT` double NOT NULL, `LEGAL_ENTITY_ID` varchar(20) DEFAULT NULL, `ISGRPHEADER` tinyint(1) DEFAULT NULL, `SUBSIDIARIES_COUNT` int(15) DEFAULT NULL, `SUPP_AMOUNT` double DEFAULT ''0'', PRIMARY KEY (`PROCUBE_SEQ_ID`), KEY `FO_DUNS` (`FO_DUNS_ID`), KEY `PROC_FK` (`PROC_FK`), KEY `COUNTRY_FK` (`COUNTRY_FK`), KEY `AMOUNT` (`AMOUNT`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE `TURNOVER` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `LEGAL_ENTITY_ID` varchar(20) DEFAULT NULL, `AMOUNT` double DEFAULT NULL, `START_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `END_DATE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `SUPPLIER_FK` varchar(20) NOT NULL, PRIMARY KEY (`ID`), KEY `TURNOVER_SUPPLIER_FKC` (`SUPPLIER_FK`), KEY `LEGAL_ENTITY` (`LEGAL_ENTITY_ID`) ) ENGINE=MyISAM AUTO_INCREMENT=423114 DEFAULT CHARSET=utf8 CREATE TABLE `TMP_ENTITY_COUNTRY` ( `ENTITY_FK` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `COUNTRY_FK` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, KEY `ENTITY_FKC` (`ENTITY_FK`), KEY `COUNTRY_FKC` (`COUNTRY_FK`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8