CREATE TABLE ProviderChannelUseTracker
(
    id BIGINT DEFAULT NULL AUTO_INCREMENT,
    Provider BIGINT UNSIGNED NOT NULL,
    ts BIGINT UNSIGNED NOT NULL,
    Inbound SmallINT UNSIGNED NOT NULL DEFAULT 0,
    Outbound SmallINT UNSIGNED NOT NULL DEFAULT 0,
    ChannelLimit SmallINT UNSIGNED NOT NULL DEFAULT 0,
    PRIMARY KEY ( id ),
    KEY ( Provider,ts )

) ENGINE=INNODB CHARSET=UTF8;
