
START TRANSACTION;
	
INSERT INTO `plugin_base_fields` VALUES (NULL, 'lblIncludeKm', 'frontend', 'Label / Inkl. Freikilometer', 'script', NULL);
SET @id := (SELECT LAST_INSERT_ID());
INSERT INTO `plugin_base_multi_lang` VALUES (NULL, @id, 'pjBaseField', '::LOCALE::', 'title', 'Inkl. Freikilometer', 'script');

SET @id := (SELECT `id` FROM `plugin_base_fields` WHERE `key`='opt_o_email_body_text');
UPDATE `plugin_base_multi_lang` SET `content`='<div class="col-xs-6">
<div><small>{Title}</small></div>
<div><small>{FirstName}</small></div>
<div><small>{LastName}</small></div>
<div><small>{Email}</small></div>
<div><small>{Phone}</small></div>
<div><small>{Country}</small></div>
<div><small>{City}</small></div>
<div><small>{State}</small></div>
<div><small>{Zip}</small></div>
<div><small>{Address}</small></div>
<div><small>{Company}</small></div>
<div><small>{Notes}</small></div>
<div><small>{DriverLicense}</small></div>
<div><small>{Birthday}</small></div>
<div><small>{DtFrom}{DtTo}</small></div>
<div><small>{PickupLocation}</small></div>
<div><small>{ReturnLocation}</small></div>
<div><small>{Type}</small></div>
<div><small>{LimitMileage}</small></div>
</div>
<div class="col-xs-6">
<div><small>{RentalDays}</small></div>
<div><small>{Extras}</small></div>
<div><small>{BookingID}</small></div>
<div><small>{UniqueID}</small></div>
<div><small>{Deposit}</small></div>
<div><small>{Total}</small></div>
<div><small>{Tax}</small></div>
<div><small>{Security}</small></div>
<div><small>{Insurance}</small></div>

<div><small>{PricePerDay}</small></div>
<div><small>{TotalDaysPrice}</small></div>
<div><small>{ExtraPrice}</small></div>

<div><small>{PaymentMethod}</small></div>
<div><small>{CarMake}</small></div>
<div><small>{CarModel}</small></div>
<div><small>{Mileage}</small></div>
<div><small>{Description}</small></div>
<div><small>{CancelURL}</small></div>
 </div>
 <div class="col-xs-12">
 <div><small>{InsuranceDeductable}</small></div>
 <div><small>{RegistrationNumber}</small></div>
 <div><small>{CarServicePhoneNumber}</small></div>
<div><small>{CarInsuranceCustomerNumber}</small></div>
<div><small>{SecurityDeposit}</small></div>
 <div><small>{KmsPerDay}</small></div>
 <div><small>{AdditionalKm}</small></div>
 <div><small>{Discount}</small></div>
 </div>
' WHERE `foreign_id`=@id AND `model`='pjBaseField' AND `field`='title';
	
	

COMMIT;