CREATE TABLE ProvisionLog
(
    id BIGINT UNSIGNED DEFAULT NULL AUTO_INCREMENT,
    Node BIGINT UNSIGNED DEFAULT NULL,
    Type ENUM("Error", "Partial", "Full") DEFAULT NULL,
    ts BIGINT UNSIGNED DEFAULT NULL,
    Message VARCHAR(255) DEFAULT NULL,
    IP VARCHAR(15) DEFAULT NULL,
    PRIMARY KEY ( id ) ,
    KEY ( Node,ts ),
    KEY ( ts )

) ENGINE=INNODB CHARSET=UTF8;
