CREATE TABLE NotificationContactAttempt__Worker (
          id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier of contact attempt',
          NotifyCallId BIGINT UNSIGNED NULL DEFAULT NULL COMMENT 'Id of the NotifyCall associated to the attempt',
          LaunchId BIGINT UNSIGNED NULL DEFAULT NULL COMMENT 'Id of the launch that consumed the attempt',
          ZoneId BIGINT UNSIGNED NOT NULL COMMENT "Identity of client that bought or used this contact attempt",
          Method VARCHAR(255) NULL DEFAULT NULL COMMENT 'Communication method associated with the attempt',
          LaunchStart BIGINT UNSIGNED NULL DEFAULT NULL COMMENT 'Timestamp for keep the launch time of notification',
          CreatedAt BIGINT UNSIGNED NULL DEFAULT NULL COMMENT 'Timestamp for keep the row creation date',
          LockId CHAR(32) DEFAULT NULL COMMENT 'RowLocker LockId needed to update contact attempt',
          PRIMARY KEY ( id ),
          KEY ( LockId ),
          KEY ( ZoneId ),
          KEY ( LaunchId, NotifyCallId )
          )
COMMENT='Table that logs all the contact attempts needing treatments'
ENGINE=InnoDB

