CREATE TABLE NotifyProgress
(
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    Notification BIGINT UNSIGNED NOT NULL,
    Person BIGINT UNSIGNED NOT NULL,
    RecipientName VARCHAR(100) DEFAULT NULL,
    Status VARCHAR(50) DEFAULT "queue",
    LastUpdate BIGINT UNSIGNED DEFAULT 0,
    ETA BIGINT UNSIGNED DEFAULT NULL,
    Distance BIGINT UNSIGNED DEFAULT NULL,
    Service VARCHAR(50) DEFAULT NULL,
    PRIMARY KEY ( id ),
    KEY ( Notification, Person ),
    KEY ( Person )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Progress by person, service and notification";
