
ALTER TABLE `booking_emails` ADD `email_cancel_text` TEXT NOT NULL AFTER `email_text` ;
ALTER TABLE `booking_reservation` ADD `reservation_cancelled` INT NOT NULL DEFAULT '0' AFTER `reservation_confirmed` ;


INSERT INTO `booking_config` ( `config_name`, `config_value`)
VALUES
	('reservation_cancel','0'),
	('redirect_cancel_path',''),
	('slot_selection','0'),
	('date_format','UK'),
	('time_format','24');



UPDATE `booking_emails` SET email_cancel_text = '<p>If you want to cancel your reservation, simply click the link below:<br />[cancellation-link]<br />If the link is not clickable, please copy and paste this URL into your browser\'s address bar: [cancellation-link-url]</p>' WHERE email_id IN (1,4);

