-- Create Table Statement for 'Split Out Balance Log' DROP TABLE IF EXISTS `SPLIT_OUT_BALANCE_LOG`; CREATE TABLE `SPLIT_OUT_BALANCE_LOG` ( CREATE_DATE datetime, IS_ACTIVE tinyint(1), ID bigint(20) NOT NULL, MERCHANT_ACCOUNT_CODE1 int(11), MERCHANT_ACCOUNT_CODE2 int(11), BALANCE_IN1_PRE int(11), BALANCE_IN1_POST int(11), BALANCE_IN2_PRE int(11), BALANCE_IN2_POST int(11), BALANCE_OUT1_PRE int(11), BALANCE_OUT1_POST int(11), BALANCE_OUT2_PRE int(11), BALANCE_OUT2_POST int(11), SPLIT_IN_AMOUNT1_PRE int(11), SPLIT_IN_AMOUNT1_POST int(11), SPLIT_IN_AMOUNT2_PRE int(11), SPLIT_IN_AMOUNT2_POST int(11), SPLIT_IN_REDUCTION_AMOUNT1_PRE int(11), SPLIT_IN_REDUCTION_AMOUNT1_POST int(11), SPLIT_IN_REDUCTION_AMOUNT2_PRE int(11), SPLIT_IN_REDUCTION_AMOUNT2_POST int(11), MERCHANT_STATEMENT_FK bigint(20), SPLIT_OUT_BALANCE_CODE bigint(20), PRIMARY KEY (ID) ) ENGINE=InnoDB;