
ALTER TABLE `was_event`
CHANGE `event_type` `event_type` ENUM('WEBINAR','CHAT','VIDEO_STREAM','SERIES') NOT NULL,
CHANGE `access_level` `access_level` ENUM('ALL','STARTER','PREMIUM', 'PREMIUM_PLUS') DEFAULT NULL,
CHANGE `audience` `audience` ENUM('EVERYONE','MY_FOLLOWERS','MY_REFERRALS') DEFAULT NULL,
ADD `est_duration_time` TIME NOT NULL DEFAULT '00:00:00' COMMENT 'Duration as MySQL time',
ADD `mute_notification` TINYINT(1) NOT NULL DEFAULT '0' AFTER `audience`;


UPDATE `was_event` SET `est_duration_time` = '01:00:00' WHERE `est_duration` = '1';
UPDATE `was_event` SET `est_duration_time` = '02:00:00' WHERE `est_duration` = '2';
UPDATE `was_event` SET `est_duration_time` = '03:00:00' WHERE `est_duration` = '3';
UPDATE `was_event` SET `est_duration_time` = '04:00:00' WHERE `est_duration` = '4';
UPDATE `was_event` SET `est_duration_time` = '05:00:00' WHERE `est_duration` = '5';
UPDATE `was_event` SET `est_duration_time` = '06:00:00' WHERE `est_duration` = '6';
UPDATE `was_event` SET `est_duration_time` = '07:00:00' WHERE `est_duration` = '7';
UPDATE `was_event` SET `est_duration_time` = '08:00:00' WHERE `est_duration` = '8';