ALTER TABLE `tblcalendar_events` 
ADD `type` ENUM('general','schedule_estimate','schedule_post_inspection','schedule_work_order') NOT NULL AFTER `repeat_value_type`, 
ADD `client_id` BIGINT(20) NULL AFTER `type`, 
ADD `property_street` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `client_id`, 
ADD `property_street_2` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `property_street`,
ADD `property_city` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `property_street_2`,
ADD `property_state` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `property_city`,
ADD `property_state_id` BIGINT(20) NULL AFTER `property_state`,
ADD `property_zip` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `property_state_id`,
ADD `property_country` BIGINT(20) NULL AFTER `property_zip`,
ADD `property_id` BIGINT(20) NULL AFTER `property_country`;

CREATE TABLE `devcpapp_mycpapp`.`tblcalendar_event_staff` ( `id` BIGINT(20) NOT NULL PRIMARY KEY , `calendar_event_id` BIGINT(20) NOT NULL , `staff_id` BIGINT(20) NOT NULL , `added_on` DATETIME NOT NULL ) ENGINE = InnoDB;

ALTER TABLE `tblcalendar_event_staff` CHANGE `id` `id` BIGINT(20) NOT NULL AUTO_INCREMENT;