CREATE TABLE CaucaAPILauncher
(
    Notification BIGINT UNSIGNED DEFAULT NULL,
    Expire BIGINT UNSIGNED DEFAULT 0,
    Zone BIGINT UNSIGNED DEFAULT 0,
    LaunchCode VARCHAR(4) NOT NULL,
    IsMessageReceived TINYINT UNSIGNED DEFAULT 0,
    UNIQUE KEY Notification ( Notification ),
    UNIQUE KEY Zone ( Zone,LaunchCode )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Track recently launched notifications so we can update inste";
