DROP TABLE IF EXISTS `recovery_ec_shukka`; CREATE TABLE IF NOT EXISTS `recovery_ec_shukka` ( `contact_id` varchar(36) DEFAULT NULL, `event_id` varchar(36) DEFAULT NULL, `koza_id` varchar(36) DEFAULT '', start_date date , schedule tinyint(1) DEFAULT '1', shukka tinyint(1) DEFAULT '1', PRIMARY KEY (`contact_id`,`event_id`,`koza_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;