
START TRANSACTION;

UPDATE `options` SET `is_visible` = '0' WHERE `key` = 'o_layout';

INSERT INTO `fields` VALUES (NULL, 'lblProperty', 'backend', 'Label / Property', 'script', NULL);

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

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

INSERT INTO `fields` VALUES (NULL, 'infoListingDetailsTitle', 'backend', 'Infobox / Property details', 'script', NULL);

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

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

INSERT INTO `fields` VALUES (NULL, 'infoListingDetailsDesc', 'backend', 'Infobox / Property details', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'You can fill in the fields below to set the detail information for the selected property.', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoListingExtrasTitle', 'backend', 'Infobox / Property extras', 'script', NULL);

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

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

INSERT INTO `fields` VALUES (NULL, 'infoListingExtrasDesc', 'backend', 'Infobox / Property extras', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'There are two types of extras that you can assign for the selected property - Property Features and Community Features. ', 'script');

INSERT INTO `fields` VALUES (NULL, 'infoListingSEOTitle', 'backend', 'Infobox / SEO settings', 'script', NULL);

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

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

INSERT INTO `fields` VALUES (NULL, 'infoListingSEODesc', 'backend', 'Infobox / SEO settings', 'script', NULL);

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

INSERT INTO `multi_lang` VALUES (NULL, @id, 'pjField', '::LOCALE::', 'title', 'For search engines it is important that your web pages have Meta tags. These Meta tags refer to your listing details page. They not only give relevant information to the search engines, but are usually used as snippets when the page appears in a search engine results page (as a result of a conducted search). So, use them to define before searchers that use Google, Yahoo or Bing what is this page for.', 'script');

INSERT INTO `fields` VALUES (NULL, 'lblListingAllowCashPayments', 'backend', 'Label / Allow cash payments', 'script', NULL);

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

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

INSERT INTO `fields` VALUES (NULL, 'payment_methods_ARRAY_cash', 'arrays', 'payment_methods_ARRAY_cash', 'script', NULL);

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

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

INSERT INTO `fields` VALUES (NULL, 'lblListingEmails', 'backend', 'Label / Emails', 'script', NULL);

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

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

COMMIT;