
START TRANSACTION;

SET @id := (SELECT `id` FROM `fields` WHERE `key` = "lblAvailableTokens");
UPDATE `multi_lang` SET `content` = '<table width="100%" border="0" cellspacing="0" cellpadding="0"><tbody><tr><td width="50%" valign="top">{Name} - The customer''s name;<br/> {Email} - The customer''s e-mail;<br/> {Phone} - The provided phone number;<br/> {Adults} - Number of adults;<br/> {Children} - Number of children;<br/> {Notes} - Any additional notes;<br/> {Address} - The provided address;<br/> {City} - The provided city;<br/> {Country} - The provided country;<br/> {State} - The provided state;<br/> {Zip} - The provided zip code;<br/> {CCType} - The provided CC type;<br/> {CCNum} - The provided CC number;<br/>{CCExpMonth} - The provided CC exp.month;<br/> {CCExpYear} - The provided CC exp.year;<br/> {CCSec} - The provided CC sec. code;<br/> {PaymentMethod} - The payment method;</td><td width="50%" valign="top">{StartDate} - Reservation''s start date;<br/> {EndDate} - Reservation''s end date;<br/> {Deposit} - Deposit;<br/> {Security} - Security amount;<br/> {Tax} - Tax;<br/> {TouristTax} - Tourist Tax;<br/> {Price} - Price;<br/> {ExtraPrice} - Extras price;<br/> {Discount} - Discount Amount;<br/> {Promo} - Promo amount;<br/> {TotalPrice} - Total Price;<br/>  {CalendarID} - Property ID;<br/> {ReservationID} - Reservation''s ID;<br/> {ReservationUUID} - Reservation''s UUID;<br/> {CancelURL} - Cancel URL<br/> {FirstInvoice} - First Invoice<br/> {CalendarName} - Property name;</td></tr></tbody></table>' WHERE `foreign_id` = @id AND `model` = "pjField" AND `field` = "title";

COMMIT;