
START TRANSACTION;

ALTER TABLE `services` ADD COLUMN `hide_on_frontend` enum('T','F') DEFAULT 'F';

UPDATE `plugin_auth_permissions` SET `is_shown`='F' WHERE `key` IN('pjAdminAdditionalServices','pjAdminAdditionalServices_pjActionIndex','pjAdminAdditionalServices_pjActionCreate','pjAdminAdditionalServices_pjActionUpdate','pjAdminAdditionalServices_pjActionDelete','pjAdminAdditionalServices_pjActionDeleteBulk');


INSERT INTO `plugin_base_fields` VALUES (NULL, 'lblServiceHideOnFrontend', 'backend', 'Label / Hide on the front-end', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `plugin_base_multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Hide on the front-end', 'script');


SET @id := (SELECT `id` FROM `fields` WHERE `key` = "opt_o_email_body_text");
UPDATE `multi_lang` SET `content` = '<div class="col-xs-6">
<div><small>{Name}</small></div>
<div><small>{Phone}</small></div>
<div><small>{Email}</small></div>
<div><small>{Notes}</small></div>
<div><small>{Address1}</small></div>
<div><small>{Address2}</small></div>
<div><small>{City}</small></div>
<div><small>{State}</small></div>
<div><small>{Zip}</small></div>
<div><small>{Country}</small></div>

</div>
<div class="col-xs-6">
<div><small>{BookingID}</small></div>
<div><small>{Services}</small></div>
<div><small>{DateTime}</small></div>
<div><small>{Subservices}</small></div>
<div><small>{PaymentMethod}</small></div>
<div><small>{Price}</small></div>
<div><small>{Deposit}</small></div>
<div><small>{Tax}</small></div>
<div><small>{Total}</small></div>
<div><small>{CancelURL}</small></div>
 </div>
' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "opt_o_reminder_body_text");
UPDATE `multi_lang` SET `content` = '<div class="col-xs-6">
<p>{Name}</p>
<p>{Phone}</p>
<p>{Email}</p>
<p>{BookingID}</p>
<p>{Services}</p>
<p>{DateTime}</p>
<p>{Subservices}</p>
</div>
<div class="col-xs-6">
<p>{Price}</p>
<p>{Deposit}</p>
<p>{Tax}</p>
<p>{Total}</p>
<p>{CancelURL}</p>
</div>
' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";



COMMIT;