Email Newsletter 1 : Database Guest

CREATE TABLE `mt_guest` (
    `guest_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
    `full_name` VARCHAR(100) NULL DEFAULT NULL,
    `email` VARCHAR(50) NULL DEFAULT NULL,
    `type` ENUM('GUEST','SUBSCRIBER') NULL DEFAULT 'GUEST',
    `codeverification` VARCHAR(50) NULL DEFAULT NULL,
    `unsubscribe` ENUM('Y','N') NULL DEFAULT 'N',
    PRIMARY KEY (`guest_id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1;