ALTER TABLE `booking_reservation` ADD `admin_confirmed_cancelled` INT NOT NULL AFTER `calendar_id` ;
ALTER TABLE `booking_slots` ADD `slot_av_max` INT NOT NULL AFTER `slot_av` ;
UPDATE booking_slots SET slot_av_max = slot_av WHERE slot_av>0 AND slot_av_max = 0;
INSERT INTO `booking_texts` ( `page_id`, `text_label`, `text_value`)
VALUES
(3,'CONFIGURATION_CANCEL_BUTTON','CANCEL'),
	(3,'CONFIGURATION_SAVE_BUTTON','SAVE'),
	(4,'STYLES_CANCEL_BUTTON','CANCEL'),
	(4,'STYLES_SAVE_BUTTON','SAVE'),
	(12,'TEXTS_CANCEL_BUTTON','CANCEL'),
	(12,'TEXTS_SAVE_BUTTON','SAVE'),
	(5,'NEW_CALENDAR_CANCEL_BUTTON','CANCEL'),
	(5,'NEW_CALENDAR_SAVE_BUTTON','SAVE'),
	(5,'SLOT_CANCEL_BUTTON','CANCEL'),
	(5,'SLOT_SAVE_BUTTON','SAVE'),
	(7,'MAIL_CANCEL_BUTTON','CANCEL'),
	(7,'MAIL_SAVE_BUTTON','SAVE'),
	(8,'FORM_CANCEL_BUTTON','CANCEL'),
	(8,'FORM_SAVE_BUTTON','SAVE'),
	(9,'PASSWORD_CANCEL_BUTTON','CANCEL'),
	(9,'PASSWORD_SAVE_BUTTON','SAVE'),
	(10,'METATAGS_CANCEL_BUTTON','CANCEL'),
	(10,'METATAGS_SAVE_BUTTON','SAVE'),
	(6,'RESERVATIONS_SEARCH','SEARCH'),
	(5,'SLOT_SEARCH','SEARCH'),
	(7,'MAIL_NAME_LABEL','Mail type'),
	(11,'PAYPAL_CONFIRM_NOT_CONFIRMED_1','We\'re sorry'),
	(11,'PAYPAL_CONFIRM_NOT_CONFIRMED_2','There\'s been a problem with your payment and your reservation has been cancelled.'),
	(3,'CONFIGURATION_PAYPAL_SUBLABEL1','Activate this option if you want people to pay the booking fee with Paypal. You must complete all the fields below to activate this service.'),
	(3,'CONFIGURATION_PAYPAL_SUBLABEL2','Note that if you activate IPN'),
	(3,'CONFIGURATION_PAYPAL_SUBLABEL3','in your Paypal profile the system will automatically confirm reservations after payments even if the user closes the browser before being redirected to the Booking Calendar. In the Notification URL text box just put your site address.'),
	(5,'SLOT_AV_MAX_LABEL','Maximum number of bookable seats at once'),
	(5,'SLOT_AV_MAX_SUBLABEL','Choose the maximum number of bookable seats at once by a customer'),
	(6,'RESERVATION_USER_CONTACT_TO_ALERT','You must add at least an email address to send the email'),
	(6,'RESERVATION_USER_CONTACT_SUBJECT_ALERT','Insert a subject for the message'),
	(6,'RESERVATION_USER_CONTACT_MESSAGE_ALERT','Insert a message for the user'),
	(6,'RESERVATION_USER_CONTACT_MODAL_TEXT1','Message to'),
	(6,'RESERVATION_USER_CONTACT_MODAL_TEXT2','Reservation info:'),
	(6,'RESERVATION_USER_CONTACT_TO','To (multiple addresses must be separated by comma)'),
	(6,'RESERVATION_USER_CONTACT_CC','Cc (multiple addresses must be separated by comma)'),
	(6,'RESERVATION_USER_CONTACT_BCC','Bcc (multiple addresses must be separated by comma)'),
	(6,'RESERVATION_USER_CONTACT_SUBJECT','Subject'),
	(6,'RESERVATION_USER_CONTACT_MESSAGE','Message'),
	(6,'RESERVATION_USER_CONTACT_BUTTON','Send'),
	(6,'RESERVATION_PRICE_LABEL','Price'),
	(5,'SLOT_MODIFY_NEW_AV_MAX','New maximum bookable slot seats'),
	(6,'RESERVATION_USER_CONTACT_MESSAGE_SENT','Message successfully sent!'),
	(6,'RESERVATION_USER_CONTACT_MESSAGE_ERROR','An error has occurred. Retry'),
	(5,'SLOTS_AV_MAX_LABEL','Max bookable'),
	(11,'DORESERVATION_MAIL_ADMIN_PRICE','Price'),
	(11,'DORESERVATION_MAIL_USER_PRICE','Price'),
	(11, 'DORESERVATION_ERROR', 'An error occurred. This time slot may be already reserved. Please try again'),
	(3, 'CONFIGURATION_BOOK_TO_SUBLABEL', 'Insert the maximum number of days that a user can book when landing on the calendar. Leave 0 if he can book at any date.'),
	(3, 'CONFIGURATION_NAME_FROM_RESERVATION_SIDE_LABEL', 'Sender name'),
	(3, 'CONFIGURATION_EMAIL_FROM_RESERVATION_SIDE_LABEL', 'E-mail address'),
	(5, 'SLOT_SUBTITLE', 'Remember to limit the time period to a maximum of 3 months at once if you have many slots in a day as there is a limit which prevent to insert more than 2000 slots at once to avoid your  website to crash or block during slots creation'),
	(5, 'SLOT_CUSTOM_TIME_LABEL', 'Even if you want to set a fixed hour (i.e. 6:00), please remember to select minutes too (00) or you\'ll get the error "Duplicated slots"');

INSERT INTO `booking_config` ( `config_name`, `config_value`)
VALUES 	
	('book_to', '0'),
	('name_from_reservation', 'Booking Calendar');