CREATE TABLE PersonAvailability
(
    Node BIGINT UNSIGNED NOT NULL,
    Year CHAR(4) NOT NULL,
    Month CHAR(2) NOT NULL,
    Day CHAR(2) NOT NULL,
    Hour CHAR(2) NOT NULL,
    Minute CHAR(2) NOT NULL,
    Mixed CHAR(12) NOT NULL,
    AvailabilityId BIGINT UNSIGNED DEFAULT 0,
    Created BIGINT UNSIGNED DEFAULT NULL COMMENT "Timestamp at which the entry was created ",
    PRIMARY KEY ( Node,Year,Month,Day,Hour,Minute,AvailabilityId ),
    KEY Mixed ( Mixed )

) ENGINE=INNODB CHARSET=UTF8;
