
START TRANSACTION;

INSERT INTO `fields` VALUES (NULL, 'lblEmailAvailableTokens', 'backend', 'Label / Available tokens', 'script', '2016-08-01 07:05:32');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', '<div class="w200 float_left">Name: {Name}<br>Email: {Email}<br>Phone: {Phone}<br>City: {City}<br>State: {State}<br>Zip: {Zip}<br>Address: {Address}<br>Notes: {Notes}<br>Tickets: {Tickets}</div><div class="w250 float_left">PDF Ticket: {PDF_Tickets}<br>CC type: {CCType}<br>CC number: {CCNum}<br>CC expiration: {CCExp}<br>CC code: {CCSec}<br>Payment: {PaymentMethod}<br>Event: {Event}<br>Event Title: {EventTitle}</div><div class="w250 float_left">Event Date/time: {EventDateTime}<br>Event Location: {EventLocation}<br>Total price: {Total}<br>Tax: {Tax}<br>Deposit: {Deposit}<br>Remaining Balance: {Balance}<br>Booking ID: {BookingID}<br>Cancel URL: {CancelURL}</div>', 'script');

INSERT INTO `fields` VALUES (NULL, 'tabEmail', 'backend', 'Tab / Email', 'script', '2016-08-01 07:12:55');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Email', 'script');

INSERT INTO `fields` VALUES (NULL, 'tabSMS', 'backend', 'Tab / SMS', 'script', '2016-08-01 07:13:10');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'SMS', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoSMSConfirmationTitle', 'backend', 'SMS confirmations', 'script', '2016-08-01 07:18:18');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'SMS confirmations', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoSMSConfirmationBody', 'backend', 'SMS confirmations', 'script', '2016-08-01 07:19:02');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'There are 2 types of SMS confirmations - one after booking form is submitted and one after payment is made. Use the available tokens to personalize the SMS messages.', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblSMSAvailableTokens', 'backend', 'Label / Available tokens', 'script', '2016-08-01 07:22:25');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', '<div class="w200 float_left">Name: {Name}<br>Email: {Email}<br>Phone: {Phone}</div><div class="w250 float_left">Booking ID: {BookingID}<br/>Event Title: {EventTitle}<br>Event Date/time: {EventDateTime}</div><div class="w250 float_left">Total price: {Total}<br>Tax: {Tax}<br>Deposit: {Deposit}</div>', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblConfirmationSMS', 'backend', 'Label / Confirmation SMS', 'script', '2016-08-01 07:24:05');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Confirmation SMS', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblConfirmationSMSTip', 'backend', 'Label / Confirmation SMS tip', 'script', '2016-08-01 07:24:39');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'This is the SMS which will be sent to people who book an event right after booking form is submitted.', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblPaymentSMS', 'backend', 'Label / Payment SMS', 'script', '2016-08-01 07:25:56');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'Payment SMS', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblPaymentSMSTip', 'backend', 'Label / Payment SMS tip', 'script', '2016-08-01 07:26:23');

SET @id := (SELECT LAST_INSERT_ID());

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'This is the SMs which will be sent to people who book an event right after payment is made.', 'script');

COMMIT;