CREATE TABLE ResellersCommissions
(
    Invoice BIGINT UNSIGNED DEFAULT NULL,
    Customer BIGINT UNSIGNED DEFAULT NULL,
    Type VARCHAR(30) DEFAULT NULL,
    GrossAmount DECIMAL(10,2) DEFAULT NULL,
    NetAmount DECIMAL(10,2) DEFAULT NULL,
    ts BIGINT UNSIGNED DEFAULT NULL,
    Referer BIGINT UNSIGNED DEFAULT NULL,
    ActivationDate BIGINT UNSIGNED DEFAULT NULL,
    Agent BIGINT UNSIGNED DEFAULT NULL,
    Distributor BIGINT UNSIGNED DEFAULT NULL,
    PRIMARY KEY ( Invoice,Type )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Amounts applicable to commissions";
