-- Create Table Statement for 'Deferred Revenue Statistics'
DROP TABLE IF EXISTS `DEFERRED_REVENUE_STATISTICS`;
CREATE TABLE `DEFERRED_REVENUE_STATISTICS` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	BEGIN_DATE datetime,
	END_DATE datetime,
	CONTRACT_FK bigint(20),
	CONSUMED_DAYS_COUNT int(11),
	CONSUMED_VALUE int(11),
	DEFERRED_VALUE int(11),
	DESCRIPTION varchar,
	CONSUMED_WEEKS_COUNT int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;