CREATE TABLE FinancialTransactionsTotal
(
    Account BIGINT UNSIGNED NOT NULL,
    Year CHAR(4) DEFAULT NULL,
    Month CHAR(2) DEFAULT NULL,
    Total DECIMAL(15,2) DEFAULT NULL,
    PRIMARY KEY ( Account,Year,Month )

) ENGINE=INNODB CHARSET=UTF8;
