
ALTER TABLE `custom_permissions` CHANGE `start_time` `start_time` VARCHAR(8) NOT NULL;
UPDATE `custom_permissions` SET start_time = CONCAT(start_time,":00:00");
ALTER TABLE `custom_permissions` CHANGE `start_time` `start_time` TIME NOT NULL;

ALTER TABLE `custom_permissions` CHANGE `end_time` `end_time` VARCHAR(8) NOT NULL;
UPDATE `custom_permissions` SET end_time = CONCAT(end_time,":00:00");
ALTER TABLE `custom_permissions` CHANGE `end_time` `end_time` TIME NOT NULL;




ALTER TABLE `users` ADD `url_ics` TEXT NULL DEFAULT NULL AFTER `private_profile`;
ALTER TABLE `resource` ADD `assistance_chooseStaff` INT NOT NULL DEFAULT '0' AFTER `insert_tolerance`;
ALTER TABLE `calendar` ADD `staff` INT NULL AFTER `parent`;