DROP TABLE IF EXISTS `vacationrentals_countries`;
CREATE TABLE IF NOT EXISTS `vacationrentals_countries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `status` enum('T','F') NOT NULL DEFAULT 'T',
  PRIMARY KEY (`id`),
  KEY `status` (`status`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

INSERT INTO `vacationrentals_countries` (`id`, `status`) VALUES
(1, 'T'),
(2, 'T'),
(3, 'T'),
(4, 'T'),
(5, 'T'),
(6, 'T'),
(7, 'T'),
(8, 'T'),
(9, 'T'),
(10, 'T'),
(11, 'T'),
(12, 'T'),
(13, 'T'),
(14, 'T'),
(15, 'T'),
(16, 'T'),
(17, 'T'),
(18, 'T'),
(19, 'T'),
(20, 'T'),
(21, 'T'),
(22, 'T'),
(23, 'T'),
(24, 'T'),
(25, 'T'),
(26, 'T'),
(27, 'T'),
(28, 'T'),
(29, 'T'),
(30, 'T'),
(31, 'T'),
(32, 'T'),
(33, 'T'),
(34, 'T'),
(35, 'T'),
(36, 'T'),
(37, 'T'),
(38, 'T'),
(39, 'T'),
(40, 'T'),
(41, 'T'),
(42, 'T'),
(43, 'T'),
(44, 'T'),
(45, 'T'),
(46, 'T'),
(47, 'T'),
(48, 'T'),
(49, 'T'),
(50, 'T'),
(51, 'T'),
(52, 'T'),
(53, 'T'),
(54, 'T'),
(55, 'T'),
(56, 'T'),
(57, 'T'),
(58, 'T'),
(59, 'T'),
(60, 'T'),
(61, 'T'),
(62, 'T'),
(63, 'T'),
(64, 'T'),
(65, 'T'),
(66, 'T'),
(67, 'T'),
(68, 'T'),
(69, 'T'),
(70, 'T'),
(71, 'T'),
(72, 'T'),
(73, 'T'),
(74, 'T'),
(75, 'T'),
(76, 'T'),
(77, 'T'),
(78, 'T'),
(79, 'T'),
(80, 'T'),
(81, 'T'),
(82, 'T'),
(83, 'T'),
(84, 'T'),
(85, 'T'),
(86, 'T'),
(87, 'T'),
(88, 'T'),
(89, 'T'),
(90, 'T'),
(91, 'T'),
(92, 'T'),
(93, 'T'),
(94, 'T'),
(95, 'T'),
(96, 'T'),
(97, 'T'),
(98, 'T'),
(99, 'T'),
(100, 'T'),
(101, 'T'),
(102, 'T'),
(103, 'T'),
(104, 'T'),
(105, 'T'),
(106, 'T'),
(107, 'T'),
(108, 'T'),
(109, 'T'),
(110, 'T'),
(111, 'T'),
(112, 'T'),
(113, 'T'),
(114, 'T'),
(115, 'T'),
(116, 'T'),
(117, 'T'),
(118, 'T'),
(119, 'T'),
(120, 'T'),
(121, 'T'),
(122, 'T'),
(123, 'T'),
(124, 'T'),
(125, 'T'),
(126, 'T'),
(127, 'T'),
(128, 'T'),
(129, 'T'),
(130, 'T'),
(131, 'T'),
(132, 'T'),
(133, 'T'),
(134, 'T'),
(135, 'T'),
(136, 'T'),
(137, 'T'),
(138, 'T'),
(139, 'T'),
(140, 'T'),
(141, 'T'),
(142, 'T'),
(143, 'T'),
(144, 'T'),
(145, 'T'),
(146, 'T'),
(147, 'T'),
(148, 'T'),
(149, 'T'),
(150, 'T'),
(151, 'T'),
(152, 'T'),
(153, 'T'),
(154, 'T'),
(155, 'T'),
(156, 'T'),
(157, 'T'),
(158, 'T'),
(159, 'T'),
(160, 'T'),
(161, 'T'),
(162, 'T'),
(163, 'T'),
(164, 'T'),
(165, 'T'),
(166, 'T'),
(167, 'T'),
(168, 'T'),
(169, 'T'),
(170, 'T'),
(171, 'T'),
(172, 'T'),
(173, 'T'),
(174, 'T'),
(175, 'T'),
(176, 'T'),
(177, 'T'),
(178, 'T'),
(179, 'T'),
(180, 'T'),
(181, 'T'),
(182, 'T'),
(183, 'T'),
(184, 'T'),
(185, 'T'),
(186, 'T'),
(187, 'T'),
(188, 'T'),
(189, 'T'),
(190, 'T'),
(191, 'T'),
(192, 'T'),
(193, 'T'),
(194, 'T'),
(195, 'T'),
(196, 'T'),
(197, 'T'),
(198, 'T'),
(199, 'T'),
(200, 'T'),
(201, 'T'),
(202, 'T'),
(203, 'T'),
(204, 'T'),
(205, 'T'),
(206, 'T'),
(207, 'T'),
(208, 'T'),
(209, 'T'),
(210, 'T'),
(211, 'T'),
(212, 'T'),
(213, 'T'),
(214, 'T'),
(215, 'T'),
(216, 'T'),
(217, 'T'),
(218, 'T'),
(219, 'T'),
(220, 'T'),
(221, 'T'),
(222, 'T'),
(223, 'T'),
(224, 'T'),
(225, 'T'),
(226, 'T'),
(227, 'T'),
(228, 'T'),
(229, 'T'),
(230, 'T'),
(231, 'T'),
(232, 'T'),
(233, 'T'),
(234, 'T'),
(235, 'T'),
(236, 'T'),
(237, 'T'),
(238, 'T'),
(239, 'T'),
(240, 'T'),
(241, 'T'),
(242, 'T'),
(243, 'T'),
(244, 'T'),
(245, 'T'),
(246, 'T'),
(247, 'T'),
(248, 'T'),
(249, 'T'),
(250, 'T'),
(251, 'T'),
(252, 'T'),
(253, 'T'),
(254, 'T'),
(255, 'T'),
(256, 'T'),
(257, 'T'),
(258, 'T'),
(259, 'T'),
(260, 'T'),
(261, 'T'),
(262, 'T'),
(263, 'T'),
(264, 'T'),
(265, 'T'),
(266, 'T'),
(267, 'T'),
(268, 'T'),
(269, 'T'),
(270, 'T'),
(271, 'T'),
(272, 'T'),
(273, 'T');

DROP TABLE IF EXISTS `vacationrentals_extras`;
CREATE TABLE IF NOT EXISTS `vacationrentals_extras` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('property','community') DEFAULT NULL,
  `status` enum('T','F') NOT NULL DEFAULT 'T',
  PRIMARY KEY (`id`),
  KEY `status` (`status`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

INSERT INTO `vacationrentals_extras` (`id`, `type`, `status`) VALUES
(1, 'property', 'T'),
(2, 'property', 'T'),
(3, 'property', 'T'),
(4, 'property', 'T'),
(5, 'property', 'T'),
(6, 'property', 'T'),
(7, 'property', 'T'),
(8, 'property', 'T'),
(9, 'property', 'T'),
(10, 'property', 'T'),
(11, 'property', 'T'),
(12, 'property', 'T'),
(13, 'property', 'T'),
(14, 'property', 'T'),
(15, 'property', 'T'),
(16, 'property', 'T'),
(17, 'property', 'T'),
(18, 'property', 'T'),
(19, 'property', 'T'),
(20, 'property', 'T'),
(21, 'property', 'T'),
(22, 'property', 'T'),
(23, 'property', 'T'),
(24, 'property', 'T'),
(25, 'property', 'T'),
(26, 'property', 'T'),
(27, 'property', 'T'),
(28, 'property', 'T'),
(29, 'property', 'T'),
(30, 'property', 'T'),
(31, 'property', 'T'),
(32, 'property', 'T'),
(33, 'property', 'T'),
(34, 'community', 'T'),
(35, 'community', 'T'),
(36, 'community', 'T'),
(37, 'community', 'T'),
(38, 'community', 'T'),
(39, 'community', 'T'),
(40, 'community', 'T'),
(41, 'community', 'T'),
(42, 'community', 'T'),
(43, 'community', 'T'),
(44, 'community', 'T'),
(45, 'community', 'T'),
(46, 'community', 'T'),
(47, 'community', 'T'),
(48, 'community', 'T'),
(49, 'community', 'T'),
(50, 'community', 'T'),
(51, 'community', 'T'),
(52, 'community', 'T'),
(53, 'community', 'T'),
(54, 'community', 'T');

DROP TABLE IF EXISTS `vacationrentals_fields`;
CREATE TABLE IF NOT EXISTS `vacationrentals_fields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) DEFAULT NULL,
  `type` enum('backend','frontend','arrays') DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `source` enum('script','plugin') DEFAULT 'script',
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

INSERT INTO `vacationrentals_fields` (`id`, `key`, `type`, `label`, `source`, `modified`) VALUES
(6, 'pass', 'backend', 'Password', 'script', NULL),
(7, 'email', 'backend', 'E-Mail', 'script', NULL),
(16, 'btnSave', 'backend', 'Save', 'script', NULL),
(24, 'menuUsers', 'backend', 'Menu Users', 'script', NULL),
(25, 'menuOptions', 'backend', 'Menu Options', 'script', NULL),
(26, 'menuLogout', 'backend', 'Menu Logout', 'script', NULL),
(36, 'lblChoose', 'backend', 'Choose', 'script', NULL),
(37, 'btnSearch', 'backend', 'Search', 'script', NULL),
(44, 'adminLogin', 'backend', 'Admin Login', 'script', NULL),
(45, 'btnLogin', 'backend', 'Login', 'script', NULL),
(46, 'menuInstall', 'backend', 'Menu Install', 'script', NULL),
(47, 'menuDashboard', 'backend', 'Menu Dashboard', 'script', NULL),
(48, 'menuBrowseProperty', 'backend', 'Menu Browse properties', 'script', NULL),
(49, 'menuAddProperty', 'backend', 'Menu Add property', 'script', NULL),
(51, 'menuReservations', 'backend', 'Menu Reservations', 'script', NULL),
(52, 'menuPreview', 'backend', 'Menu Preview', 'script', NULL),
(54, 'menuExtras', 'backend', 'Menu Extras', 'script', NULL),
(55, 'menuTypes', 'backend', 'Menu Types', 'script', NULL),
(56, 'menuProperties', 'backend', 'Menu Properties', 'script', NULL),
(58, 'btnAdd', 'backend', 'Button Add', 'script', NULL),
(61, 'lblCountry', 'backend', 'Country', 'script', NULL),
(62, 'lblDelete', 'backend', 'Delete', 'script', NULL),
(63, 'lblExtra', 'backend', 'Extra', 'script', NULL),
(64, 'lblExtraType', 'backend', 'Extra type', 'script', NULL),
(65, 'lblType', 'backend', 'Type', 'script', NULL),
(66, 'lblName', 'backend', 'Name', 'script', NULL),
(67, 'lblRole', 'backend', 'Role', 'script', NULL),
(68, 'lblStatus', 'backend', 'Status', 'script', NULL),
(69, 'lblIsActive', 'backend', 'Is Active', 'script', NULL),
(70, 'lblUpdateUser', 'backend', 'Update user', 'script', NULL),
(71, 'lblAddUser', 'backend', 'Add user', 'script', NULL),
(72, 'lblValue', 'backend', 'Value', 'script', NULL),
(73, 'lblOption', 'backend', 'Option', 'script', NULL),
(74, 'lblDays', 'backend', 'Days', 'script', NULL),
(76, 'lblInstallPhp1Title', 'backend', 'Install (PHP) Title', 'script', NULL),
(77, 'lblInstallPhp2Title', 'backend', 'Install (PHP) Search', 'script', NULL),
(78, 'lblInstallPhp3Title', 'backend', 'Install (PHP) Featured', 'script', NULL),
(79, 'lblInstallPhp1_1', 'backend', 'Install (Step 1)', 'script', NULL),
(80, 'lblInstallPhp1_2', 'backend', 'Install (Step 2)', 'script', NULL),
(81, 'lblInstallPhp1_3', 'backend', 'Install (Step 3)', 'script', NULL),
(82, 'lblInstallPhp1_4', 'backend', 'Install (Step 1)', 'script', NULL),
(83, 'lblInstallPhp1_5', 'backend', 'Install (Step 5)', 'script', NULL),
(84, 'lblInstallSearch_1', 'backend', 'Install Search (Step 1)', 'script', NULL),
(85, 'lblInstallSearch_2', 'backend', 'Install Search (Step 2)', 'script', NULL),
(86, 'lblInstallSearch_3', 'backend', 'Install Search (Step 3)', 'script', NULL),
(87, 'lblInstallFeat_1', 'backend', 'Install Featured (Step 1)', 'script', NULL),
(88, 'lblInstallFeat_2', 'backend', 'Install Featured (Step 2)', 'script', NULL),
(89, 'lblInstallFeat_3', 'backend', 'Install Featured (Step 3)', 'script', NULL),
(90, 'lblInstallFeat_4', 'backend', 'Install Featured (Step 4)', 'script', NULL),
(91, 'lblAddReservation', 'backend', 'Add reservation', 'script', NULL),
(92, 'lblReservationName', 'backend', 'Reservation / Name', 'script', NULL),
(93, 'lblReservationEmail', 'backend', 'Reservation / Email', 'script', NULL),
(94, 'lblReservationPhone', 'backend', 'Reservation / Phone', 'script', NULL),
(96, 'lblReservationNotes', 'backend', 'Reservation / Notes', 'script', NULL),
(97, 'lblReservationSecurity', 'backend', 'Reservation / Security', 'script', NULL),
(98, 'lblReservationDeposit', 'backend', 'Reservation / Deposit', 'script', NULL),
(99, 'lblReservationTax', 'backend', 'Reservation / Tax', 'script', NULL),
(100, 'lblReservationFrom', 'backend', 'Reservation / From', 'script', NULL),
(101, 'lblReservationTo', 'backend', 'Reservation / To', 'script', NULL),
(102, 'lblReservationPayment', 'backend', 'Reservation / Payment', 'script', NULL),
(103, 'lblReservationAmount', 'backend', 'Reservation / Amount', 'script', NULL),
(104, 'lblReservationStatus', 'backend', 'Reservation / Status', 'script', NULL),
(105, 'lblReservationListing', 'backend', 'Reservation / Listing', 'script', NULL),
(106, 'lblReservationCCType', 'backend', 'Reservation / CC Type', 'script', NULL),
(107, 'lblReservationCCNum', 'backend', 'Reservation / CC Number', 'script', NULL),
(108, 'lblReservationCCCode', 'backend', 'Reservation / CC Code', 'script', NULL),
(109, 'lblReservationCCExp', 'backend', 'Reservation / CC Expiration date', 'script', NULL),
(110, 'lblUpdateReservation', 'backend', 'Update reservation', 'script', NULL),
(111, 'lblListingRefid', 'backend', 'Listing / RefID', 'script', NULL),
(112, 'lblListingStatus', 'backend', 'Listing / Status', 'script', NULL),
(113, 'lblListingType', 'backend', 'Listing / Type', 'script', NULL),
(114, 'lblListingFeatured', 'backend', 'Listing / Featured', 'script', NULL),
(115, 'menuLocales', 'backend', 'Menu Languages', 'script', NULL),
(116, 'lblYes', 'backend', 'Yes', 'script', NULL),
(117, 'lblNo', 'backend', 'No', 'script', NULL),
(118, 'lblListingSummary', 'backend', 'Listing / Summary', 'script', NULL),
(119, 'lblListingDetails', 'backend', 'Listing / Details', 'script', NULL),
(120, 'lblListingExtras', 'backend', 'Listing / Extras', 'script', NULL),
(121, 'lblListingPhotos', 'backend', 'Listing / Photos', 'script', NULL),
(122, 'lblListingContact', 'backend', 'Listing / Contact', 'script', NULL),
(123, 'lblListingAddress', 'backend', 'Listing / Address', 'script', NULL),
(124, 'lblListingPrices', 'backend', 'Listing / Pricesq', 'script', NULL),
(125, 'lblListingBooking', 'backend', 'Listing / Booking', 'script', NULL),
(126, 'lblListingTerms', 'backend', 'Listing / Terms', 'script', NULL),
(127, 'lblListingCreated', 'backend', 'Listing / Added on', 'script', NULL),
(128, 'lblListingModified', 'backend', 'Listing / Last update on', 'script', NULL),
(129, 'lblListingViews', 'backend', 'Listing / Views', 'script', NULL),
(130, 'lblNotYet', 'backend', 'Not yet', 'script', NULL),
(131, 'lblListingExpire', 'backend', 'Listing / Expire date', 'script', NULL),
(132, 'lblListingFloorArea', 'backend', 'Listing / Floor Area', 'script', NULL),
(133, 'lblListingChildren', 'backend', 'Listing / Children', 'script', NULL),
(134, 'lblListingAdults', 'backend', 'Listing / Adults', 'script', NULL),
(135, 'lblListingBathrooms', 'backend', 'Listing / Bathrooms', 'script', NULL),
(136, 'lblListingBedrooms', 'backend', 'Listing / Bedrooms', 'script', NULL),
(137, 'lblListingFirstName', 'backend', 'Listing / First Name', 'script', NULL),
(138, 'lblListingLastName', 'backend', 'Listing / Last Name', 'script', NULL),
(139, 'lblListingMobile', 'backend', 'Listing / Cell phone', 'script', NULL),
(140, 'lblListingPhone', 'backend', 'Listing / Phone', 'script', NULL),
(141, 'lblListingEmail', 'backend', 'Listing / Email', 'script', NULL),
(142, 'lblListingFax', 'backend', 'Listing / Fax', 'script', NULL),
(143, 'lblListingUrl', 'backend', 'Listing / Url', 'script', NULL),
(144, 'lblListingTitle', 'backend', 'Listing / Title', 'script', NULL),
(145, 'lblListingContactShow', 'backend', 'Listing / Show contacts', 'script', NULL),
(146, 'lblListingShowMap', 'backend', 'Listing / Show on map', 'script', NULL),
(147, 'lblListingZip', 'backend', 'Listing / Zip', 'script', NULL),
(148, 'lblListingCountry', 'backend', 'Listing / Country', 'script', NULL),
(149, 'lblListingState', 'backend', 'Listing / State', 'script', NULL),
(150, 'lblListingCity', 'backend', 'Listing / City', 'script', NULL),
(151, 'lblListingPriceFrom', 'backend', 'Listing / Price from', 'script', NULL),
(152, 'lblListingPriceTo', 'backend', 'Listing / Price to', 'script', NULL),
(153, 'lblListingPriceTitle', 'backend', 'Listing / Price title', 'script', NULL),
(162, 'lblListingDescription', 'backend', 'Listing / Description', 'script', NULL),
(163, 'lblListingConfirmEmail', 'backend', 'Listing / Confirm email', 'script', NULL),
(164, 'lblListingPaymentEmail', 'backend', 'Listing / Payment email', 'script', NULL),
(165, 'lblListingConfirmTokens', 'backend', 'Listing / Confirm Tokens', 'script', NULL),
(166, 'lblListingPaymentTokens', 'backend', 'Listing / Payment Tokens', 'script', NULL),
(167, 'lblListingAcceptBookings', 'backend', 'Listing / Accept bookings', 'script', NULL),
(168, 'lblListingAcceptBookingsText', 'backend', 'Listing / Accept Bookings Text', 'script', NULL),
(169, 'lblListingBookItNow', 'backend', 'Listing / Disable payments', 'script', NULL),
(170, 'lblListingBookItNowText', 'backend', 'Listing / Disable payments text', 'script', NULL),
(171, 'lblListingMinimumBookingLength', 'backend', 'Listing / Minimum booking length', 'script', NULL),
(172, 'lblListingMinimumBookingLengthText', 'backend', 'Listing / Minimum booking length text', 'script', NULL),
(173, 'lblListingMaximumBookingLength', 'backend', 'Listing / Maximum booking length', 'script', NULL),
(174, 'lblListingMaximumBookingLengthText', 'backend', 'Listing / Maximum Booking Length Text', 'script', NULL),
(175, 'lblListingCalculatePriceBasedOnNumber', 'backend', 'Listing / Calculate Price Based On Number', 'script', NULL),
(176, 'lblListingCalculatePriceBasedOnNumberText', 'backend', 'Listing / Calculate Price Based On Number Text', 'script', NULL),
(181, 'lblListingAllowPayments', 'backend', 'Listing / Allow Payments', 'script', NULL),
(182, 'lblListingAllowPaymentsText', 'backend', 'Listing / Allow Payments Text', 'script', NULL),
(183, 'lblListingAllowPaypalPayments', 'backend', 'Listing / Allow Paypal Payments', 'script', NULL),
(185, 'lblListingAllowAuthorizePayments', 'backend', 'Listing / Allow Authorize Payments', 'script', NULL),
(187, 'lblListingAllowCreditCardPayments', 'backend', 'Listing / Allow Credit Card Payments', 'script', NULL),
(188, 'lblListingDepositPayment', 'backend', 'Listing / Deposit Payment', 'script', NULL),
(189, 'lblListingDepositPaymentText', 'backend', 'Listing / Deposit Payment Text', 'script', NULL),
(190, 'lblListingSecurityPayment', 'backend', 'Listing / Security Payment', 'script', NULL),
(191, 'lblListingSecurityPaymentText', 'backend', 'Listing / Security Payment Text', 'script', NULL),
(192, 'lblListingTaxPayment', 'backend', 'Listing / Tax Payment', 'script', NULL),
(193, 'lblListingTaxPaymentText', 'backend', 'Listing / Tax Payment Text', 'script', NULL),
(196, 'lblListingRequireAllWithinDays', 'backend', 'Listing / Require All Within Days', 'script', NULL),
(197, 'lblListingRequireAllWithinDaysText', 'backend', 'Listing / Require All Within Days Text', 'script', NULL),
(198, 'lblListingAuthorizeMerchantId', 'backend', 'Listing / Authorize Merchant Id', 'script', NULL),
(199, 'lblListingAuthorizeMerchantIdText', 'backend', 'Listing / Authorize Merchant Id Text', 'script', NULL),
(200, 'lblListingAuthorizeTransKey', 'backend', 'Listing / Authorize Trans Key', 'script', NULL),
(201, 'lblListingAuthorizeTransKeyText', 'backend', 'Listing / Authorize Trans Key Text', 'script', NULL),
(202, 'lblListingAuthorizeTZone', 'backend', 'Listing / Authorize Time Zone', 'script', NULL),
(203, 'lblListingAuthorizeTZoneText', 'backend', 'Listing / Authorize Time Zone Text', 'script', NULL),
(204, 'lblListingPaypalAddress', 'backend', 'Listing / Paypal Address', 'script', NULL),
(205, 'lblListingPaypalAddressText', 'backend', 'Listing / Paypal Address Text', 'script', NULL),
(208, 'lblListingDefaultStatusIfPaid', 'backend', 'Listing / Default Status If Paid', 'script', NULL),
(209, 'lblListingDefaultStatusIfPaidText', 'backend', 'Listing / Default Status If Paid Text', 'script', NULL),
(210, 'lblListingDefaultStatusIfNotPaid', 'backend', 'Listing / Default Status If Not Paid', 'script', NULL),
(211, 'lblListingDefaultStatusIfNotPaidText', 'backend', 'Listing / Default Status If Not Paid Text', 'script', NULL),
(212, 'lblListingThankYouPageLocation', 'backend', 'Listing / Thank You Page Location', 'script', NULL),
(213, 'lblListingThankYouPageLocationText', 'backend', 'Listing / Thank You Page Location Text', 'script', NULL),
(220, 'lblSure', 'backend', 'Listing / Are you sure', 'script', NULL),
(221, 'lblListingAllowBankPayments', 'backend', 'Listing / Allow Bank Account Payments', 'script', NULL),
(222, 'lblListingBankAccount', 'backend', 'Listing / Bank Account', 'script', NULL),
(223, 'lblListingBankAccountText', 'backend', 'Listing / Bank Account Text', 'script', NULL),
(224, 'lblInstallListing', 'backend', 'Install / Listing tab', 'script', NULL),
(225, 'lblInstallSearch', 'backend', 'Install / Search tab', 'script', NULL),
(226, 'lblInstallFeatured', 'backend', 'Install / Featured tab', 'script', NULL),
(227, 'lblInstallOptional', 'backend', 'Install / Optional tab', 'script', NULL),
(228, 'lblListingLat', 'backend', 'Listing / Latitude', 'script', NULL),
(229, 'lblListingLng', 'backend', 'Listing / Longitude', 'script', NULL),
(230, 'btnGoogleMapsApi', 'backend', 'Listing / Google Maps Api', 'script', NULL),
(234, 'lblDashProperties', 'backend', 'Dashboard / Properties', 'script', NULL),
(235, 'lblDashReservations', 'backend', 'Dashboard / Reservations', 'script', NULL),
(236, 'lblDashUsers', 'backend', 'Dashboard / Users', 'script', NULL),
(237, 'lblDashViews', 'backend', 'Dashboard / Views', 'script', NULL),
(238, 'lblDashLatestReservations', 'backend', 'Dashboard / Latest Reservations', 'script', NULL),
(239, 'lblDashNights', 'backend', 'Dashboard / Nights', 'script', NULL),
(240, 'lblDashTopUsers', 'backend', 'Dashboard / Top Users', 'script', NULL),
(241, 'lblDashLastLogin', 'backend', 'Dashboard / Last login', 'script', NULL),
(242, 'lblDashMostPopular', 'backend', 'Dashboard / Most Popular', 'script', NULL),
(243, 'front_menu_home', 'frontend', 'front_menu_home', 'script', NULL),
(244, 'front_menu_search', 'frontend', 'front_menu_search', 'script', NULL),
(245, 'front_menu_add', 'frontend', 'front_menu_add', 'script', NULL),
(246, 'front_menu_back', 'frontend', 'front_menu_back', 'script', NULL),
(247, 'front_menu_back_no', 'frontend', 'front_menu_back_no', 'script', NULL),
(248, 'front_index_empty', 'frontend', 'front_index_empty', 'script', NULL),
(249, 'front_index_bedrooms', 'frontend', 'front_index_bedrooms', 'script', NULL),
(250, 'front_index_bathrooms', 'frontend', 'front_index_bathrooms', 'script', NULL),
(251, 'front_index_type', 'frontend', 'front_index_type', 'script', NULL),
(252, 'front_index_floor', 'frontend', 'front_index_floor', 'script', NULL),
(253, 'front_index_details', 'frontend', 'front_index_details', 'script', NULL),
(256, 'front_view_refid', 'frontend', 'front_view_refid', 'script', NULL),
(257, 'front_view_type', 'frontend', 'front_view_type', 'script', NULL),
(258, 'front_view_bedrooms', 'frontend', 'front_view_bedrooms', 'script', NULL),
(259, 'front_view_bathrooms', 'frontend', 'front_view_bathrooms', 'script', NULL),
(260, 'front_view_adults', 'frontend', 'front_view_adults', 'script', NULL),
(261, 'front_view_children', 'frontend', 'front_view_children', 'script', NULL),
(262, 'front_view_floor_area', 'frontend', 'front_view_floor_area', 'script', NULL),
(263, 'front_view_extra', 'frontend', 'front_view_extra', 'script', NULL),
(264, 'front_view_description', 'frontend', 'front_view_description', 'script', NULL),
(265, 'front_view_na', 'frontend', 'front_view_na', 'script', NULL),
(266, 'front_view_contact', 'frontend', 'front_view_contact', 'script', NULL),
(267, 'front_view_postcode', 'frontend', 'front_view_postcode', 'script', NULL),
(268, 'front_view_address', 'frontend', 'front_view_address', 'script', NULL),
(269, 'front_view_country', 'frontend', 'front_view_country', 'script', NULL),
(270, 'front_view_state', 'frontend', 'front_view_state', 'script', NULL),
(271, 'front_view_city', 'frontend', 'front_view_city', 'script', NULL),
(272, 'front_view_name', 'frontend', 'front_view_name', 'script', NULL),
(273, 'front_view_phone', 'frontend', 'front_view_phone', 'script', NULL),
(274, 'front_view_mobile', 'frontend', 'front_view_mobile', 'script', NULL),
(275, 'front_view_email', 'frontend', 'front_view_email', 'script', NULL),
(276, 'front_view_fax', 'frontend', 'front_view_fax', 'script', NULL),
(277, 'front_view_url', 'frontend', 'front_view_url', 'script', NULL),
(278, 'front_view_map', 'frontend', 'front_view_map', 'script', NULL),
(279, 'front_view_price_quotes', 'frontend', 'front_view_price_quotes', 'script', NULL),
(280, 'front_view_price_from', 'frontend', 'front_view_price_from', 'script', NULL),
(281, 'front_view_price_to', 'frontend', 'front_view_price_to', 'script', NULL),
(282, 'front_view_price_value', 'frontend', 'front_view_price_value', 'script', NULL),
(283, 'front_view_calendar', 'frontend', 'front_view_calendar', 'script', NULL),
(284, 'front_view_terms', 'frontend', 'front_view_terms', 'script', NULL),
(290, 'front_booking_from', 'frontend', 'front_booking_from', 'script', NULL),
(291, 'front_booking_to', 'frontend', 'front_booking_to', 'script', NULL),
(292, 'front_booking_price', 'frontend', 'front_booking_price', 'script', NULL),
(293, 'front_booking_name', 'frontend', 'front_booking_name', 'script', NULL),
(294, 'front_booking_email', 'frontend', 'front_booking_email', 'script', NULL),
(295, 'front_booking_phone', 'frontend', 'front_booking_phone', 'script', NULL),
(296, 'front_booking_notes', 'frontend', 'front_booking_notes', 'script', NULL),
(297, 'front_booking_submit', 'frontend', 'front_booking_submit', 'script', NULL),
(298, 'front_booking_captcha', 'frontend', 'front_booking_captcha', 'script', NULL),
(299, 'front_booking_cc_type', 'frontend', 'front_booking_cc_type', 'script', NULL),
(300, 'front_booking_cc_num', 'frontend', 'front_booking_cc_num', 'script', NULL),
(301, 'front_booking_cc_code', 'frontend', 'front_booking_cc_code', 'script', NULL),
(302, 'front_booking_cc_exp', 'frontend', 'front_booking_cc_exp', 'script', NULL),
(303, 'front_booking_pm_empty', 'frontend', 'front_booking_pm_empty', 'script', NULL),
(304, 'front_booking_pm', 'frontend', 'front_booking_pm', 'script', NULL),
(305, 'front_search_title', 'frontend', 'front_search_title', 'script', NULL),
(306, 'front_search_submit', 'frontend', 'front_search_submit', 'script', NULL),
(307, 'front_search_choose', 'frontend', 'front_search_choose', 'script', NULL),
(308, 'front_search_type', 'frontend', 'front_search_type', 'script', NULL),
(309, 'front_search_refid', 'frontend', 'front_search_refid', 'script', NULL),
(310, 'front_search_country', 'frontend', 'front_search_country', 'script', NULL),
(311, 'front_search_bedrooms', 'frontend', 'front_search_bedrooms', 'script', NULL),
(312, 'front_search_bathrooms', 'frontend', 'front_search_bathrooms', 'script', NULL),
(313, 'front_search_adults', 'frontend', 'front_search_adults', 'script', NULL),
(314, 'front_search_children', 'frontend', 'front_search_children', 'script', NULL),
(315, 'front_search_floor_area', 'frontend', 'front_search_floor_area', 'script', NULL),
(316, 'front_search_to', 'frontend', 'front_search_to', 'script', NULL),
(318, 'front_search_above', 'frontend', 'front_search_above', 'script', NULL),
(319, 'front_search_date_from', 'frontend', 'front_search_date_from', 'script', NULL),
(320, 'front_search_date_to', 'frontend', 'front_search_date_to', 'script', NULL),
(324, 'front_login_title', 'frontend', 'front_login_title', 'script', NULL),
(325, 'front_login_submit', 'frontend', 'front_login_submit', 'script', NULL),
(327, 'front_login_password', 'frontend', 'front_login_password', 'script', NULL),
(328, 'front_register_title', 'frontend', 'front_register_title', 'script', NULL),
(329, 'front_register_submit', 'frontend', 'front_register_submit', 'script', NULL),
(331, 'front_register_password', 'frontend', 'front_register_password', 'script', NULL),
(332, 'front_register_password_repeat', 'frontend', 'front_register_password_repeat', 'script', NULL),
(333, 'front_register_name', 'frontend', 'front_register_name', 'script', NULL),
(334, 'front_register_email', 'frontend', 'front_register_email', 'script', NULL),
(335, 'front_featured_title', 'frontend', 'front_featured_title', 'script', NULL),
(339, 'btnAddPeriod', 'backend', 'Button Add Period & Price', 'script', NULL),
(340, 'listing_payment_period', 'backend', 'Listing / Period', 'script', NULL),
(341, 'listing_payment_price', 'backend', 'Listing / Price', 'script', NULL),
(343, 'listing_payment_free', 'backend', 'Listing / FREE', 'script', NULL),
(344, 'listing_payment_renew_free', 'backend', 'Listing / Extend your period for FREE', 'script', NULL),
(345, 'listing_payment_renew_paypal', 'backend', 'Listing / Buy now', 'script', NULL),
(346, 'front_login_email', 'frontend', 'front_login_email', 'script', NULL),
(348, 'lblListingOwner', 'backend', 'Listing / Owner', 'script', NULL),
(349, 'lblListingNotFound', 'backend', 'Listing / No properties found', 'script', NULL),
(350, 'lblReservationNotFound', 'backend', 'Reservation / No reservations found', 'script', NULL),
(351, 'lblInstallPhp4Title', 'backend', 'Install (PHP) Optional', 'script', NULL),
(352, 'lblListingPriceNotFound', 'backend', 'Listing / No prices added', 'script', NULL),
(353, 'lblListingAddTitle', 'backend', 'Listing / Add property (Title)', 'script', NULL),
(354, 'lblListingAddDesc', 'backend', 'Listing / Add property (Description)', 'script', NULL),
(355, 'btnCancel', 'backend', 'Button Cancel', 'script', NULL),
(356, 'lblForgot', 'backend', 'Forgot password', 'script', NULL),
(357, 'adminForgot', 'backend', 'Forgot password', 'script', NULL),
(358, 'btnSend', 'backend', 'Button Send', 'script', NULL),
(363, 'lblListingStatusTip', 'backend', 'Listing / Publish tooltip', 'script', NULL),
(364, 'lblListingExpireTip', 'backend', 'Listing / Expire date tooltip', 'script', NULL),
(365, 'menuProfile', 'backend', 'Menu Profile', 'script', NULL),
(366, 'infoSubmissionsTitle', 'backend', 'Infobox / Submission Title', 'script', NULL),
(367, 'infoSubmissionsBody', 'backend', 'Infobox / Submission Body', 'script', NULL),
(368, 'infoTypesTitle', 'backend', 'Infobox / Types Title', 'script', NULL),
(369, 'infoTypesBody', 'backend', 'Infobox / Types Body', 'script', NULL),
(370, 'infoExtrasTitle', 'backend', 'Infobox / Extras Title', 'script', NULL),
(371, 'infoExtrasBody', 'backend', 'Infobox / Extras Body', 'script', NULL),
(372, 'infoTypesCreateTitle', 'backend', 'Infobox / Add Type Title', 'script', NULL),
(373, 'infoTypesCreateBody', 'backend', 'Infobox / Add Type Body', 'script', NULL),
(374, 'infoTypesUpdateTitle', 'backend', 'Infobox / Update Type Title', 'script', NULL),
(375, 'infoTypesUpdateBody', 'backend', 'Infobox / Update Type Body', 'script', NULL),
(376, 'infoExtrasCreateTitle', 'backend', 'Infobox / Add Extra Title', 'script', NULL),
(377, 'infoExtrasCreateBody', 'backend', 'Infobox / Add Extra Body', 'script', NULL),
(378, 'infoExtrasUpdateTitle', 'backend', 'Infobox / Update Extra Title', 'script', NULL),
(379, 'infoExtrasUpdateBody', 'backend', 'Infobox / Update Extra Body', 'script', NULL),
(386, 'infoListingPricesTitle', 'backend', 'Infobox / Listing Prices Title', 'script', NULL),
(387, 'infoListingPricesBody', 'backend', 'Infobox / Listing Prices Body', 'script', NULL),
(388, 'infoListingBookingsTitle', 'backend', 'Infobox / Listing Bookings Title', 'script', NULL),
(389, 'infoListingBookingsBody', 'backend', 'Infobox / Listing Bookings Body', 'script', NULL),
(390, 'infoListingContactTitle', 'backend', 'Infobox / Listing Contact Title', 'script', NULL),
(391, 'infoListingContactBody', 'backend', 'Infobox / Listing Contact Body', 'script', NULL),
(392, 'infoListingAddressTitle', 'backend', 'Infobox / Listing Address Title', 'script', NULL),
(393, 'infoListingAddressBody', 'backend', 'Infobox / Listing Address Body', 'script', NULL),
(395, 'infoListingExtendTitle', 'backend', 'Infobox / Extend exp.date Title', 'script', NULL),
(396, 'infoListingExtendBody', 'backend', 'Infobox / Extend exp.date Body', 'script', NULL),
(397, 'lblListingExtend', 'backend', 'Listing / Extend expiration date', 'script', NULL),
(398, 'lblListingProperty', 'backend', 'Listing / Property', 'script', NULL),
(399, 'front_price_from', 'frontend', 'front_price_from', 'script', NULL),
(400, 'front_index_properties_found', 'frontend', 'front_index_properties_found', 'script', NULL),
(401, 'front_index_property_found', 'frontend', 'front_index_property_found', 'script', NULL),
(402, 'front_index_next_page', 'frontend', 'front_index_next_page', 'script', NULL),
(403, 'front_index_prev_page', 'frontend', 'front_index_prev_page', 'script', NULL),
(404, 'front_view_booking_form', 'frontend', 'front_view_booking_form', 'script', NULL),
(405, 'front_register_title_slogan', 'frontend', 'front_register_title_slogan', 'script', NULL),
(406, 'front_login_title_slogan', 'frontend', 'front_login_title_slogan', 'script', NULL),
(407, 'front_view_details', 'frontend', 'front_view_details', 'script', NULL),
(408, 'menuBackup', 'backend', 'Menu Backup', 'script', NULL),
(409, 'btnBackup', 'backend', 'Button Backup', 'script', NULL),
(410, 'lblBackupDatabase', 'backend', 'Backup / Database', 'script', NULL),
(411, 'lblBackupFiles', 'backend', 'Backup / Files', 'script', NULL),
(412, 'gridChooseAction', 'backend', 'Grid / Choose Action', 'script', NULL),
(413, 'gridGotoPage', 'backend', 'Grid / Go to page', 'script', NULL),
(414, 'gridTotalItems', 'backend', 'Grid / Total items', 'script', NULL),
(415, 'gridItemsPerPage', 'backend', 'Grid / Items per page', 'script', NULL),
(416, 'gridPrevPage', 'backend', 'Grid / Prev page', 'script', NULL),
(417, 'gridPrev', 'backend', 'Grid / Prev', 'script', NULL),
(418, 'gridNextPage', 'backend', 'Grid / Next page', 'script', NULL),
(419, 'gridNext', 'backend', 'Grid / Next', 'script', NULL),
(420, 'gridDeleteConfirmation', 'backend', 'Grid / Delete confirmation', 'script', NULL),
(421, 'gridConfirmationTitle', 'backend', 'Grid / Confirmation Title', 'script', NULL),
(422, 'gridActionTitle', 'backend', 'Grid / Action Title', 'script', NULL),
(423, 'gridBtnOk', 'backend', 'Grid / Button OK', 'script', NULL),
(424, 'gridBtnCancel', 'backend', 'Grid / Button Cancel', 'script', NULL),
(425, 'gridBtnDelete', 'backend', 'Grid / Button Delete', 'script', NULL),
(426, 'gridEmptyResult', 'backend', 'Grid / Empty resultset', 'script', NULL),
(427, 'gridActionEmptyTitle', 'backend', 'Grid / Action Empty Title', 'script', NULL),
(428, 'gridActionEmptyBody', 'backend', 'Grid / Action Empty Body', 'script', NULL),
(433, 'multilangTooltip', 'backend', 'MultiLang / Tooltip', 'script', NULL),
(434, 'lblIp', 'backend', 'IP address', 'script', NULL),
(435, 'lblUserCreated', 'backend', 'User / Registration Date & Time', 'script', NULL),
(436, 'lblReservationCreated', 'backend', 'Reservation / Date&Time made', 'script', NULL),
(437, 'front_index_na', 'frontend', 'front_index_na', 'script', NULL),
(438, 'ResConfirmationTitle', 'backend', 'Reservation / Confirmation Title', 'script', NULL),
(439, 'ResConfirmationText', 'backend', 'Reservation / Confirmation re-send', 'script', NULL),
(440, 'opt_o_allow_add_property', 'backend', 'Options / Allow users to add properties', 'script', NULL),
(441, 'opt_o_currency', 'backend', 'Options / Currency', 'script', NULL),
(442, 'opt_o_date_format', 'backend', 'Options / Date format', 'script', NULL),
(443, 'opt_o_floor', 'backend', 'Options / Floor metrics', 'script', NULL),
(444, 'opt_o_is_active_owner', 'backend', 'Options / User account confirmed by default', 'script', NULL),
(445, 'opt_o_layout', 'backend', 'Options / Select layout', 'script', NULL),
(446, 'opt_o_limit_featured_results', 'backend', 'Options / Featured properties', 'script', NULL),
(447, 'opt_o_listing_page', 'backend', 'Options / URL to the web page where listing is placed', 'script', NULL),
(448, 'opt_o_paypal_address', 'backend', 'Options / Paypal address', 'script', NULL),
(449, 'opt_o_per_page', 'backend', 'Options / Items per page', 'script', NULL),
(450, 'opt_o_seo_url', 'backend', 'Options / Use SEO Friendly URLs', 'script', NULL),
(451, 'opt_o_timezone', 'backend', 'Options / Timezone', 'script', NULL),
(452, 'opt_o_week_start', 'backend', 'Options / First day of the week', 'script', NULL),
(453, 'extra_type_arr_ARRAY_property', 'arrays', 'extra_type_arr_ARRAY_property', 'script', NULL),
(454, 'extra_type_arr_ARRAY_community', 'arrays', 'extra_type_arr_ARRAY_community', 'script', NULL),
(455, 'u_statarr_ARRAY_T', 'arrays', 'u_statarr_ARRAY_T', 'script', NULL),
(456, 'u_statarr_ARRAY_F', 'arrays', 'u_statarr_ARRAY_F', 'script', NULL),
(457, 'filter_ARRAY_active', 'arrays', 'filter_ARRAY_active', 'script', NULL),
(458, 'filter_ARRAY_inactive', 'arrays', 'filter_ARRAY_inactive', 'script', NULL),
(459, 'filter_ARRAY_featured', 'arrays', 'filter_ARRAY_featured', 'script', NULL),
(460, 'filter_ARRAY_non_featured', 'arrays', 'filter_ARRAY_non_featured', 'script', NULL),
(461, 'reservation_statuses_ARRAY_Confirmed', 'arrays', 'reservation_statuses_ARRAY_Confirmed', 'script', NULL),
(462, 'reservation_statuses_ARRAY_Pending', 'arrays', 'reservation_statuses_ARRAY_Pending', 'script', NULL),
(463, 'reservation_statuses_ARRAY_Cancelled', 'arrays', 'reservation_statuses_ARRAY_Cancelled', 'script', NULL),
(464, 'payment_methods_ARRAY_paypal', 'arrays', 'payment_methods_ARRAY_paypal', 'script', NULL),
(465, 'payment_methods_ARRAY_authorize', 'arrays', 'payment_methods_ARRAY_authorize', 'script', NULL),
(466, 'payment_methods_ARRAY_creditcard', 'arrays', 'payment_methods_ARRAY_creditcard', 'script', NULL),
(467, 'cc_types_ARRAY_Visa', 'arrays', 'cc_types_ARRAY_Visa', 'script', NULL),
(468, 'cc_types_ARRAY_MasterCard', 'arrays', 'cc_types_ARRAY_MasterCard', 'script', NULL),
(469, 'cc_types_ARRAY_Maestro', 'arrays', 'cc_types_ARRAY_Maestro', 'script', NULL),
(470, 'cc_types_ARRAY_AmericanExpress', 'arrays', 'cc_types_ARRAY_AmericanExpress', 'script', NULL),
(471, '_yesno_ARRAY_T', 'arrays', '_yesno_ARRAY_T', 'script', NULL),
(472, '_yesno_ARRAY_F', 'arrays', '_yesno_ARRAY_F', 'script', NULL),
(473, 'publish_status_ARRAY_T', 'arrays', 'publish_status_ARRAY_T', 'script', NULL),
(474, 'publish_status_ARRAY_F', 'arrays', 'publish_status_ARRAY_F', 'script', NULL),
(475, 'publish_status_ARRAY_E', 'arrays', 'publish_status_ARRAY_E', 'script', NULL),
(476, 'personal_titles_ARRAY_mr', 'arrays', 'personal_titles_ARRAY_mr', 'script', NULL),
(477, 'personal_titles_ARRAY_mrs', 'arrays', 'personal_titles_ARRAY_mrs', 'script', NULL),
(478, 'personal_titles_ARRAY_miss', 'arrays', 'personal_titles_ARRAY_miss', 'script', NULL),
(479, 'personal_titles_ARRAY_ms', 'arrays', 'personal_titles_ARRAY_ms', 'script', NULL),
(480, 'personal_titles_ARRAY_dr', 'arrays', 'personal_titles_ARRAY_dr', 'script', NULL),
(481, 'personal_titles_ARRAY_prof', 'arrays', 'personal_titles_ARRAY_prof', 'script', NULL),
(482, 'personal_titles_ARRAY_rev', 'arrays', 'personal_titles_ARRAY_rev', 'script', NULL),
(483, 'personal_titles_ARRAY_other', 'arrays', 'personal_titles_ARRAY_other', 'script', NULL),
(484, 'listing_b_dn_ARRAY_1', 'arrays', 'listing_b_dn_ARRAY_1', 'script', NULL),
(485, 'listing_b_dn_ARRAY_2', 'arrays', 'listing_b_dn_ARRAY_2', 'script', NULL),
(486, 'listing_b_statuses_ARRAY_1', 'arrays', 'listing_b_statuses_ARRAY_1', 'script', NULL),
(487, 'listing_b_statuses_ARRAY_2', 'arrays', 'listing_b_statuses_ARRAY_2', 'script', NULL),
(488, 'listing_b_statuses_ARRAY_3', 'arrays', 'listing_b_statuses_ARRAY_3', 'script', NULL),
(496, 'timezones_ARRAY_-43200', 'arrays', 'timezones_ARRAY_-43200', 'script', NULL),
(497, 'timezones_ARRAY_-39600', 'arrays', 'timezones_ARRAY_-39600', 'script', NULL),
(498, 'timezones_ARRAY_-36000', 'arrays', 'timezones_ARRAY_-36000', 'script', NULL),
(499, 'timezones_ARRAY_-32400', 'arrays', 'timezones_ARRAY_-32400', 'script', NULL),
(500, 'timezones_ARRAY_-28800', 'arrays', 'timezones_ARRAY_-28800', 'script', NULL),
(501, 'timezones_ARRAY_-25200', 'arrays', 'timezones_ARRAY_-25200', 'script', NULL),
(502, 'timezones_ARRAY_-21600', 'arrays', 'timezones_ARRAY_-21600', 'script', NULL),
(503, 'timezones_ARRAY_-18000', 'arrays', 'timezones_ARRAY_-18000', 'script', NULL),
(504, 'timezones_ARRAY_-14400', 'arrays', 'timezones_ARRAY_-14400', 'script', NULL),
(505, 'timezones_ARRAY_-10800', 'arrays', 'timezones_ARRAY_-10800', 'script', NULL),
(506, 'timezones_ARRAY_-7200', 'arrays', 'timezones_ARRAY_-7200', 'script', NULL),
(507, 'timezones_ARRAY_-3600', 'arrays', 'timezones_ARRAY_-3600', 'script', NULL),
(508, 'timezones_ARRAY_0', 'arrays', 'timezones_ARRAY_0', 'script', NULL),
(509, 'timezones_ARRAY_3600', 'arrays', 'timezones_ARRAY_3600', 'script', NULL),
(510, 'timezones_ARRAY_7200', 'arrays', 'timezones_ARRAY_7200', 'script', NULL),
(511, 'timezones_ARRAY_10800', 'arrays', 'timezones_ARRAY_10800', 'script', NULL),
(512, 'timezones_ARRAY_14400', 'arrays', 'timezones_ARRAY_14400', 'script', NULL),
(513, 'timezones_ARRAY_18000', 'arrays', 'timezones_ARRAY_18000', 'script', NULL),
(514, 'timezones_ARRAY_21600', 'arrays', 'timezones_ARRAY_21600', 'script', NULL),
(515, 'timezones_ARRAY_25200', 'arrays', 'timezones_ARRAY_25200', 'script', NULL),
(516, 'timezones_ARRAY_28800', 'arrays', 'timezones_ARRAY_28800', 'script', NULL),
(517, 'timezones_ARRAY_32400', 'arrays', 'timezones_ARRAY_32400', 'script', NULL),
(518, 'timezones_ARRAY_36000', 'arrays', 'timezones_ARRAY_36000', 'script', NULL),
(519, 'timezones_ARRAY_39600', 'arrays', 'timezones_ARRAY_39600', 'script', NULL),
(520, 'timezones_ARRAY_43200', 'arrays', 'timezones_ARRAY_43200', 'script', NULL),
(521, 'timezones_ARRAY_46800', 'arrays', 'timezones_ARRAY_46800', 'script', NULL),
(522, 'error_titles_ARRAY_AC01', 'arrays', 'error_titles_ARRAY_AC01', 'script', NULL),
(523, 'error_titles_ARRAY_AC03', 'arrays', 'error_titles_ARRAY_AC03', 'script', NULL),
(524, 'error_titles_ARRAY_AC04', 'arrays', 'error_titles_ARRAY_AC04', 'script', NULL),
(525, 'error_titles_ARRAY_AC08', 'arrays', 'error_titles_ARRAY_AC08', 'script', NULL),
(526, 'error_titles_ARRAY_AE01', 'arrays', 'error_titles_ARRAY_AE01', 'script', NULL),
(527, 'error_titles_ARRAY_AE03', 'arrays', 'error_titles_ARRAY_AE03', 'script', NULL),
(528, 'error_titles_ARRAY_AE04', 'arrays', 'error_titles_ARRAY_AE04', 'script', NULL),
(529, 'error_titles_ARRAY_AE08', 'arrays', 'error_titles_ARRAY_AE08', 'script', NULL),
(530, 'error_titles_ARRAY_AT01', 'arrays', 'error_titles_ARRAY_AT01', 'script', NULL),
(531, 'error_titles_ARRAY_AT03', 'arrays', 'error_titles_ARRAY_AT03', 'script', NULL),
(532, 'error_titles_ARRAY_AT04', 'arrays', 'error_titles_ARRAY_AT04', 'script', NULL),
(533, 'error_titles_ARRAY_AT08', 'arrays', 'error_titles_ARRAY_AT08', 'script', NULL),
(534, 'error_titles_ARRAY_AR01', 'arrays', 'error_titles_ARRAY_AR01', 'script', NULL),
(535, 'error_titles_ARRAY_AR03', 'arrays', 'error_titles_ARRAY_AR03', 'script', NULL),
(536, 'error_titles_ARRAY_AR04', 'arrays', 'error_titles_ARRAY_AR04', 'script', NULL),
(537, 'error_titles_ARRAY_AR08', 'arrays', 'error_titles_ARRAY_AR08', 'script', NULL),
(538, 'error_titles_ARRAY_AR09', 'arrays', 'error_titles_ARRAY_AR09', 'script', NULL),
(539, 'error_titles_ARRAY_AR10', 'arrays', 'error_titles_ARRAY_AR10', 'script', NULL),
(540, 'error_titles_ARRAY_AU01', 'arrays', 'error_titles_ARRAY_AU01', 'script', NULL),
(541, 'error_titles_ARRAY_AU03', 'arrays', 'error_titles_ARRAY_AU03', 'script', NULL),
(542, 'error_titles_ARRAY_AU04', 'arrays', 'error_titles_ARRAY_AU04', 'script', NULL),
(543, 'error_titles_ARRAY_AU08', 'arrays', 'error_titles_ARRAY_AU08', 'script', NULL),
(544, 'error_titles_ARRAY_AO01', 'arrays', 'error_titles_ARRAY_AO01', 'script', NULL),
(545, 'error_titles_ARRAY_AO02', 'arrays', 'error_titles_ARRAY_AO02', 'script', NULL),
(546, 'error_titles_ARRAY_AO03', 'arrays', 'error_titles_ARRAY_AO03', 'script', NULL),
(547, 'error_titles_ARRAY_AL01', 'arrays', 'error_titles_ARRAY_AL01', 'script', NULL),
(548, 'error_titles_ARRAY_AL08', 'arrays', 'error_titles_ARRAY_AL08', 'script', NULL),
(549, 'error_titles_ARRAY_AL09', 'arrays', 'error_titles_ARRAY_AL09', 'script', NULL),
(550, 'error_titles_ARRAY_AL10', 'arrays', 'error_titles_ARRAY_AL10', 'script', NULL),
(551, 'error_titles_ARRAY_ALC01', 'arrays', 'error_titles_ARRAY_ALC01', 'script', NULL),
(552, 'error_titles_ARRAY_AB01', 'arrays', 'error_titles_ARRAY_AB01', 'script', NULL),
(553, 'error_titles_ARRAY_AB02', 'arrays', 'error_titles_ARRAY_AB02', 'script', NULL),
(554, 'error_titles_ARRAY_AB03', 'arrays', 'error_titles_ARRAY_AB03', 'script', NULL),
(555, 'error_titles_ARRAY_AB04', 'arrays', 'error_titles_ARRAY_AB04', 'script', NULL),
(556, 'error_titles_ARRAY_AA10', 'arrays', 'error_titles_ARRAY_AA10', 'script', NULL),
(557, 'error_titles_ARRAY_AA11', 'arrays', 'error_titles_ARRAY_AA11', 'script', NULL),
(558, 'error_titles_ARRAY_AA12', 'arrays', 'error_titles_ARRAY_AA12', 'script', NULL),
(559, 'error_titles_ARRAY_AA13', 'arrays', 'error_titles_ARRAY_AA13', 'script', NULL),
(560, 'error_bodies_ARRAY_AC01', 'arrays', 'error_bodies_ARRAY_AC01', 'script', NULL),
(561, 'error_bodies_ARRAY_AC03', 'arrays', 'error_bodies_ARRAY_AC03', 'script', NULL),
(562, 'error_bodies_ARRAY_AC04', 'arrays', 'error_bodies_ARRAY_AC04', 'script', NULL),
(563, 'error_bodies_ARRAY_AC08', 'arrays', 'error_bodies_ARRAY_AC08', 'script', NULL),
(564, 'error_bodies_ARRAY_AE01', 'arrays', 'error_bodies_ARRAY_AE01', 'script', NULL),
(565, 'error_bodies_ARRAY_AE03', 'arrays', 'error_bodies_ARRAY_AE03', 'script', NULL),
(566, 'error_bodies_ARRAY_AE04', 'arrays', 'error_bodies_ARRAY_AE04', 'script', NULL),
(567, 'error_bodies_ARRAY_AE08', 'arrays', 'error_bodies_ARRAY_AE08', 'script', NULL),
(568, 'error_bodies_ARRAY_AT01', 'arrays', 'error_bodies_ARRAY_AT01', 'script', NULL),
(569, 'error_bodies_ARRAY_AT03', 'arrays', 'error_bodies_ARRAY_AT03', 'script', NULL),
(570, 'error_bodies_ARRAY_AT04', 'arrays', 'error_bodies_ARRAY_AT04', 'script', NULL),
(571, 'error_bodies_ARRAY_AT08', 'arrays', 'error_bodies_ARRAY_AT08', 'script', NULL),
(572, 'error_bodies_ARRAY_AR01', 'arrays', 'error_bodies_ARRAY_AR01', 'script', NULL),
(573, 'error_bodies_ARRAY_AR03', 'arrays', 'error_bodies_ARRAY_AR03', 'script', NULL),
(574, 'error_bodies_ARRAY_AR04', 'arrays', 'error_bodies_ARRAY_AR04', 'script', NULL),
(575, 'error_bodies_ARRAY_AR08', 'arrays', 'error_bodies_ARRAY_AR08', 'script', NULL),
(576, 'error_bodies_ARRAY_AR09', 'arrays', 'error_bodies_ARRAY_AR09', 'script', NULL),
(577, 'error_bodies_ARRAY_AR10', 'arrays', 'error_bodies_ARRAY_AR10', 'script', NULL),
(578, 'error_bodies_ARRAY_AU01', 'arrays', 'error_bodies_ARRAY_AU01', 'script', NULL),
(579, 'error_bodies_ARRAY_AU03', 'arrays', 'error_bodies_ARRAY_AU03', 'script', NULL),
(580, 'error_bodies_ARRAY_AU04', 'arrays', 'error_bodies_ARRAY_AU04', 'script', NULL),
(581, 'error_bodies_ARRAY_AU08', 'arrays', 'error_bodies_ARRAY_AU08', 'script', NULL),
(582, 'error_bodies_ARRAY_AO01', 'arrays', 'error_bodies_ARRAY_AO01', 'script', NULL),
(583, 'error_bodies_ARRAY_AO02', 'arrays', 'error_bodies_ARRAY_AO02', 'script', NULL),
(584, 'error_bodies_ARRAY_AO03', 'arrays', 'error_bodies_ARRAY_AO03', 'script', NULL),
(585, 'error_bodies_ARRAY_AL01', 'arrays', 'error_bodies_ARRAY_AL01', 'script', NULL),
(586, 'error_bodies_ARRAY_AL08', 'arrays', 'error_bodies_ARRAY_AL08', 'script', NULL),
(587, 'error_bodies_ARRAY_AL09', 'arrays', 'error_bodies_ARRAY_AL09', 'script', NULL),
(588, 'error_bodies_ARRAY_AL10', 'arrays', 'error_bodies_ARRAY_AL10', 'script', NULL),
(589, 'error_bodies_ARRAY_ALC01', 'arrays', 'error_bodies_ARRAY_ALC01', 'script', NULL),
(590, 'error_bodies_ARRAY_AB01', 'arrays', 'error_bodies_ARRAY_AB01', 'script', NULL),
(591, 'error_bodies_ARRAY_AB02', 'arrays', 'error_bodies_ARRAY_AB02', 'script', NULL),
(592, 'error_bodies_ARRAY_AB03', 'arrays', 'error_bodies_ARRAY_AB03', 'script', NULL),
(593, 'error_bodies_ARRAY_AB04', 'arrays', 'error_bodies_ARRAY_AB04', 'script', NULL),
(594, 'error_bodies_ARRAY_AA10', 'arrays', 'error_bodies_ARRAY_AA10', 'script', NULL),
(595, 'error_bodies_ARRAY_AA11', 'arrays', 'error_bodies_ARRAY_AA11', 'script', NULL),
(596, 'error_bodies_ARRAY_AA12', 'arrays', 'error_bodies_ARRAY_AA12', 'script', NULL),
(597, 'error_bodies_ARRAY_AA13', 'arrays', 'error_bodies_ARRAY_AA13', 'script', NULL),
(598, 'front_view_floor_measure_ARRAY_sq.m.', 'arrays', 'front_view_floor_measure_ARRAY_sq.m.', 'script', NULL),
(599, 'front_view_floor_measure_ARRAY_sq.f.', 'arrays', 'front_view_floor_measure_ARRAY_sq.f.', 'script', NULL),
(600, 'front_booking_status_ARRAY_1', 'arrays', 'front_booking_status_ARRAY_1', 'script', NULL),
(601, 'front_booking_status_ARRAY_2', 'arrays', 'front_booking_status_ARRAY_2', 'script', NULL),
(602, 'front_booking_status_ARRAY_3', 'arrays', 'front_booking_status_ARRAY_3', 'script', NULL),
(603, 'front_booking_status_ARRAY_4', 'arrays', 'front_booking_status_ARRAY_4', 'script', NULL),
(604, 'front_booking_status_ARRAY_5', 'arrays', 'front_booking_status_ARRAY_5', 'script', NULL),
(605, 'front_booking_status_ARRAY_6', 'arrays', 'front_booking_status_ARRAY_6', 'script', NULL),
(606, 'front_booking_status_ARRAY_8', 'arrays', 'front_booking_status_ARRAY_8', 'script', NULL),
(607, 'front_booking_status_ARRAY_9', 'arrays', 'front_booking_status_ARRAY_9', 'script', NULL),
(608, 'front_booking_status_ARRAY_10', 'arrays', 'front_booking_status_ARRAY_10', 'script', NULL),
(609, 'front_booking_status_ARRAY_11', 'arrays', 'front_booking_status_ARRAY_11', 'script', NULL),
(610, 'front_sys_ARRAY_bf_name', 'arrays', 'front_sys_ARRAY_bf_name', 'script', NULL),
(611, 'front_sys_ARRAY_bf_email', 'arrays', 'front_sys_ARRAY_bf_email', 'script', NULL),
(612, 'front_sys_ARRAY_bf_email_inv', 'arrays', 'front_sys_ARRAY_bf_email_inv', 'script', NULL),
(613, 'front_sys_ARRAY_bf_pm', 'arrays', 'front_sys_ARRAY_bf_pm', 'script', NULL),
(614, 'front_sys_ARRAY_bf_verify', 'arrays', 'front_sys_ARRAY_bf_verify', 'script', NULL),
(615, 'front_sys_ARRAY_bf_note', 'arrays', 'front_sys_ARRAY_bf_note', 'script', NULL),
(616, 'front_sys_ARRAY_log_email', 'arrays', 'front_sys_ARRAY_log_email', 'script', NULL),
(617, 'front_sys_ARRAY_log_email_inv', 'arrays', 'front_sys_ARRAY_log_email_inv', 'script', NULL),
(618, 'front_sys_ARRAY_log_pass', 'arrays', 'front_sys_ARRAY_log_pass', 'script', NULL),
(619, 'front_sys_ARRAY_log_note', 'arrays', 'front_sys_ARRAY_log_note', 'script', NULL),
(620, 'front_sys_ARRAY_reg_pass', 'arrays', 'front_sys_ARRAY_reg_pass', 'script', NULL),
(621, 'front_sys_ARRAY_reg_repeat', 'arrays', 'front_sys_ARRAY_reg_repeat', 'script', NULL),
(622, 'front_sys_ARRAY_reg_pass_diff', 'arrays', 'front_sys_ARRAY_reg_pass_diff', 'script', NULL),
(623, 'front_sys_ARRAY_reg_name', 'arrays', 'front_sys_ARRAY_reg_name', 'script', NULL),
(624, 'front_sys_ARRAY_reg_email', 'arrays', 'front_sys_ARRAY_reg_email', 'script', NULL),
(625, 'front_sys_ARRAY_reg_email_inv', 'arrays', 'front_sys_ARRAY_reg_email_inv', 'script', NULL),
(626, 'front_sys_ARRAY_reg_note', 'arrays', 'front_sys_ARRAY_reg_note', 'script', NULL),
(627, 'months_ARRAY_1', 'arrays', 'months_ARRAY_1', 'script', NULL),
(628, 'months_ARRAY_2', 'arrays', 'months_ARRAY_2', 'script', NULL),
(629, 'months_ARRAY_3', 'arrays', 'months_ARRAY_3', 'script', NULL),
(630, 'months_ARRAY_4', 'arrays', 'months_ARRAY_4', 'script', NULL),
(631, 'months_ARRAY_5', 'arrays', 'months_ARRAY_5', 'script', NULL),
(632, 'months_ARRAY_6', 'arrays', 'months_ARRAY_6', 'script', NULL),
(633, 'months_ARRAY_7', 'arrays', 'months_ARRAY_7', 'script', NULL),
(634, 'months_ARRAY_8', 'arrays', 'months_ARRAY_8', 'script', NULL),
(635, 'months_ARRAY_9', 'arrays', 'months_ARRAY_9', 'script', NULL),
(636, 'months_ARRAY_10', 'arrays', 'months_ARRAY_10', 'script', NULL),
(637, 'months_ARRAY_11', 'arrays', 'months_ARRAY_11', 'script', NULL),
(638, 'months_ARRAY_12', 'arrays', 'months_ARRAY_12', 'script', NULL),
(639, 'days_ARRAY_0', 'arrays', 'days_ARRAY_0', 'script', NULL),
(640, 'days_ARRAY_1', 'arrays', 'days_ARRAY_1', 'script', NULL),
(641, 'days_ARRAY_2', 'arrays', 'days_ARRAY_2', 'script', NULL),
(642, 'days_ARRAY_3', 'arrays', 'days_ARRAY_3', 'script', NULL),
(643, 'days_ARRAY_4', 'arrays', 'days_ARRAY_4', 'script', NULL),
(644, 'days_ARRAY_5', 'arrays', 'days_ARRAY_5', 'script', NULL),
(645, 'days_ARRAY_6', 'arrays', 'days_ARRAY_6', 'script', NULL),
(646, 'day_names_ARRAY_0', 'arrays', 'day_names_ARRAY_0', 'script', NULL),
(647, 'day_names_ARRAY_1', 'arrays', 'day_names_ARRAY_1', 'script', NULL),
(648, 'day_names_ARRAY_2', 'arrays', 'day_names_ARRAY_2', 'script', NULL),
(649, 'day_names_ARRAY_3', 'arrays', 'day_names_ARRAY_3', 'script', NULL),
(650, 'day_names_ARRAY_4', 'arrays', 'day_names_ARRAY_4', 'script', NULL),
(651, 'day_names_ARRAY_5', 'arrays', 'day_names_ARRAY_5', 'script', NULL),
(652, 'day_names_ARRAY_6', 'arrays', 'day_names_ARRAY_6', 'script', NULL),
(653, 'short_months_ARRAY_1', 'arrays', 'short_months_ARRAY_1', 'script', NULL),
(654, 'short_months_ARRAY_2', 'arrays', 'short_months_ARRAY_2', 'script', NULL),
(655, 'short_months_ARRAY_3', 'arrays', 'short_months_ARRAY_3', 'script', NULL),
(656, 'short_months_ARRAY_4', 'arrays', 'short_months_ARRAY_4', 'script', NULL),
(657, 'short_months_ARRAY_5', 'arrays', 'short_months_ARRAY_5', 'script', NULL),
(658, 'short_months_ARRAY_6', 'arrays', 'short_months_ARRAY_6', 'script', NULL),
(659, 'short_months_ARRAY_7', 'arrays', 'short_months_ARRAY_7', 'script', NULL),
(660, 'short_months_ARRAY_8', 'arrays', 'short_months_ARRAY_8', 'script', NULL),
(661, 'short_months_ARRAY_9', 'arrays', 'short_months_ARRAY_9', 'script', NULL),
(662, 'short_months_ARRAY_10', 'arrays', 'short_months_ARRAY_10', 'script', NULL),
(663, 'short_months_ARRAY_11', 'arrays', 'short_months_ARRAY_11', 'script', NULL),
(664, 'short_months_ARRAY_12', 'arrays', 'short_months_ARRAY_12', 'script', NULL),
(665, 'status_ARRAY_1', 'arrays', 'status_ARRAY_1', 'script', NULL),
(666, 'status_ARRAY_2', 'arrays', 'status_ARRAY_2', 'script', NULL),
(667, 'status_ARRAY_3', 'arrays', 'status_ARRAY_3', 'script', NULL),
(668, 'status_ARRAY_7', 'arrays', 'status_ARRAY_7', 'script', NULL),
(669, 'status_ARRAY_123', 'arrays', 'status_ARRAY_123', 'script', NULL),
(670, 'status_ARRAY_999', 'arrays', 'status_ARRAY_999', 'script', NULL),
(671, 'status_ARRAY_998', 'arrays', 'status_ARRAY_998', 'script', NULL),
(672, 'status_ARRAY_997', 'arrays', 'status_ARRAY_997', 'script', NULL),
(673, 'status_ARRAY_996', 'arrays', 'status_ARRAY_996', 'script', NULL),
(674, 'status_ARRAY_9999', 'arrays', 'status_ARRAY_9999', 'script', NULL),
(675, 'status_ARRAY_9998', 'arrays', 'status_ARRAY_9998', 'script', NULL),
(676, 'status_ARRAY_9997', 'arrays', 'status_ARRAY_9997', 'script', NULL),
(677, 'login_err_ARRAY_1', 'arrays', 'login_err_ARRAY_1', 'script', NULL),
(678, 'login_err_ARRAY_2', 'arrays', 'login_err_ARRAY_2', 'script', NULL),
(679, 'login_err_ARRAY_3', 'arrays', 'login_err_ARRAY_3', 'script', NULL),
(680, 'login_err_ARRAY_4', 'arrays', 'login_err_ARRAY_4', 'script', NULL),
(910, 'lnkBack', 'backend', 'Link Back', 'script', NULL),
(911, 'payment_methods_ARRAY_bank', 'arrays', 'payment_methods_ARRAY_bank', 'script', NULL),
(912, 'front_booking_price_security', 'frontend', 'front_booking_price_security', 'script', NULL),
(913, 'front_booking_price_tax', 'frontend', 'front_booking_price_tax', 'script', NULL),
(914, 'front_booking_price_deposit', 'frontend', 'front_booking_price_deposit', 'script', NULL),
(915, 'lblDashProperty', 'backend', 'Dashboard / Property', 'script', NULL),
(916, 'lblDashReservation', 'backend', 'Dashboard / Reservation', 'script', NULL),
(917, 'lblDashUser', 'backend', 'Dashboard / User', 'script', NULL),
(919, 'lblDashNight', 'backend', 'Dashboard / Night', 'script', NULL),
(961, 'vr_address_not_found', 'backend', 'Listings / Address not found', 'script', NULL),
(962, 'vr_exp_date_plus_30', 'backend', 'Listings / Expiration date +30 days', 'script', NULL),
(963, 'vr_view_reservations', 'backend', 'Listings / View reservations', 'script', NULL),
(964, 'vr_image', 'backend', 'Listings / Image', 'script', NULL),
(965, 'vr_ref_id', 'backend', 'Listings / Ref ID', 'script', NULL),
(966, 'vr_owner', 'backend', 'Listings / Owner', 'script', NULL),
(967, 'vr_expire', 'backend', 'Listings / Expire', 'script', NULL),
(968, 'vr_publish', 'backend', 'Listings / Publish', 'script', NULL),
(969, 'vr_active', 'backend', 'Listings / Active', 'script', NULL),
(970, 'vr_inactive', 'backend', 'Listings / Inactive', 'script', NULL),
(971, 'vr_exp_date', 'backend', 'Listings / Exp.date', 'script', NULL),
(972, 'vr_delete_selected', 'backend', 'Listings / Delete selected', 'script', NULL),
(973, 'vr_published', 'backend', 'Listings / Published', 'script', NULL),
(974, 'vr_not_published', 'backend', 'Listings / Not published', 'script', NULL),
(975, 'vr_extend_exp_date', 'backend', 'Listings / Extend expiration date', 'script', NULL),
(976, 'vr_delete_confirm', 'backend', 'Listings / Are you sure you want to delete selected properties?', 'script', NULL),
(979, 'vr_delete_confirmation', 'backend', 'Listings / Delete confirmation', 'script', NULL),
(980, 'vr_extra_property', 'backend', 'Extras / Type: property', 'script', NULL),
(981, 'vr_extra_community', 'backend', 'Extras / Type: community', 'script', NULL),
(986, 'btnDelete', 'backend', 'Button Delete', 'script', NULL),
(987, 'res_date_from', 'backend', 'Reservations / Date from', 'script', NULL),
(988, 'res_date_to', 'backend', 'Reservations / Date to', 'script', NULL),
(989, 'res_listing', 'backend', 'Reservations / Listing', 'script', NULL),
(990, 'btnContinue', 'backend', 'Button Continue', 'script', NULL),
(992, 'vr_email_taken', 'backend', 'Users / Email already taken', 'script', NULL),
(993, 'revert_status', 'backend', 'Revert status', 'script', NULL),
(994, 'lblExport', 'backend', 'Export', 'script', NULL),
(995, 'error_titles_ARRAY_AU02', 'arrays', 'error_titles_ARRAY_AU02', 'script', NULL),
(996, 'error_bodies_ARRAY_AU02', 'arrays', 'error_bodies_ARRAY_AU02', 'script', NULL),
(997, 'error_titles_ARRAY_AL02', 'arrays', 'error_titles_ARRAY_AL02', 'script', NULL),
(998, 'error_bodies_ARRAY_AL02', 'arrays', 'error_bodies_ARRAY_AL02', 'script', NULL),
(999, 'error_titles_ARRAY_AR02', 'arrays', 'error_titles_ARRAY_AR02', 'script', NULL),
(1000, 'error_bodies_ARRAY_AR02', 'arrays', 'error_bodies_ARRAY_AR02', 'script', NULL),
(1001, 'error_titles_ARRAY_AA14', 'arrays', 'error_titles_ARRAY_AA14', 'script', NULL),
(1002, 'error_bodies_ARRAY_AA14', 'arrays', 'error_bodies_ARRAY_AA14', 'script', NULL),
(1003, 'lblListingSeo', 'backend', 'Listing / SEO', 'script', NULL),
(1004, 'lblListingMetaTitle', 'backend', 'Listing / Meta title', 'script', NULL),
(1005, 'lblListingMetaKeywords', 'backend', 'Listing / Meta keywords', 'script', NULL),
(1006, 'lblListingMetaDesc', 'backend', 'Listing / Meta description', 'script', NULL),
(1007, 'lblInstallPhp1_2a', 'backend', 'Install (Step 2a)', 'script', NULL),
(1008, 'opt_period_note', 'backend', 'Submissions / Period note', 'script', NULL);
INSERT INTO `vacationrentals_fields` (`id`, `key`, `type`, `label`, `source`, `modified`) VALUES
(1009, 'lblListingGMapNote', 'backend', 'Listings / Google Maps note', 'script', NULL),
(1010, 'error_titles_ARRAY_AL41', 'arrays', 'error_titles_ARRAY_AL41', 'script', NULL),
(1011, 'error_bodies_ARRAY_AL41', 'arrays', 'error_bodies_ARRAY_AL41', 'script', NULL),
(1066, 'notify_email_ARRAY_1', 'arrays', 'notify_email_ARRAY_1', 'script', NULL),
(1067, 'notify_email_ARRAY_2', 'arrays', 'notify_email_ARRAY_2', 'script', NULL),
(1068, 'notify_email_ARRAY_3', 'arrays', 'notify_email_ARRAY_3', 'script', NULL),
(1069, 'notify_email_ARRAY_4', 'arrays', 'notify_email_ARRAY_4', 'script', NULL),
(1070, 'notify_email_ARRAY_5', 'arrays', 'notify_email_ARRAY_5', 'script', NULL),
(1071, 'notify_email_ARRAY_6', 'arrays', 'notify_email_ARRAY_6', 'script', NULL),
(1072, 'lblNotifyEmail', 'backend', 'User / Email notifications', 'script', NULL),
(1073, 'lblNotifySms', 'backend', 'User / Sms notifications', 'script', NULL),
(1074, 'menuNotifications', 'backend', 'Menu Notifications', 'script', NULL),
(1075, 'opt_o_email_new_user', 'backend', 'Notifications / New user registration', 'script', NULL),
(1076, 'opt_o_email_new_property', 'backend', 'Options / New property added', 'script', NULL),
(1077, 'opt_o_email_new_reservation', 'backend', 'Options / New reservation received', 'script', NULL),
(1078, 'opt_o_email_reservation_cancelled', 'backend', 'Options / Reservation cancelled', 'script', NULL),
(1079, 'tabEmails', 'backend', 'Tab / Emails', 'script', NULL),
(1080, 'tabSms', 'backend', 'Tab / Sms', 'script', NULL),
(1081, 'error_bodies_ARRAY_AO04', 'arrays', 'error_bodies_ARRAY_AO04', 'script', NULL),
(1082, 'error_titles_ARRAY_AO04', 'arrays', 'error_titles_ARRAY_AO04', 'script', NULL),
(1083, 'infoNotificationsEmailTitle', 'backend', 'Infobox / Email notifications title', 'script', NULL),
(1084, 'infoNotificationsSmsTitle', 'backend', 'Infobox / Sms notifications title', 'script', NULL),
(1085, 'infoNotificationsEmailBody', 'backend', 'Infobox / Email notifications body', 'script', NULL),
(1086, 'infoNotificationsSmsBody', 'backend', 'Infobox / Sms notifications body', 'script', NULL),
(1087, 'lblPhone', 'backend', 'Phone', 'script', NULL),
(1088, 'front_payment_paypal_title', 'frontend', 'front_payment_paypal_title', 'script', NULL),
(1089, 'front_payment_authorize_title', 'frontend', 'front_payment_authorize_title', 'script', NULL),
(1090, 'opt_subject', 'backend', 'Notifications / Subject', 'script', NULL),
(1092, 'opt_o_send_email', 'backend', 'opt_o_send_email', 'script', NULL),
(1093, 'opt_o_smtp_host', 'backend', 'opt_o_smtp_host', 'script', NULL),
(1094, 'opt_o_smtp_port', 'backend', 'opt_o_smtp_port', 'script', NULL),
(1095, 'opt_o_smtp_user', 'backend', 'opt_o_smtp_user', 'script', NULL),
(1096, 'opt_o_smtp_pass', 'backend', 'opt_o_smtp_pass', 'script', NULL),
(1097, 'lblDashFeatured', 'backend', 'Dashboard / Featured properties', 'script', NULL),
(1098, 'status_ARRAY_9996', 'arrays', 'status_ARRAY_9996', 'script', NULL),
(1099, 'front_booking_bank', 'frontend', 'front_booking_bank', 'script', NULL),
(1154, 'lblUserEmailTip', 'backend', 'User / Email notifications tip', 'script', NULL),
(1155, 'lblUserSmsTip', 'backend', 'User / Sms notifications tip', 'script', NULL),
(1156, 'opt_body_new_user', 'backend', 'Notifications / Body', 'script', NULL),
(1157, 'opt_body_new_property', 'backend', 'Notifications / Body', 'script', NULL),
(1158, 'opt_body_new_reservation', 'backend', 'Notifications / Body', 'script', NULL),
(1159, 'error_titles_ARRAY_AL91', 'arrays', 'error_titles_ARRAY_AL91', 'script', NULL),
(1160, 'error_bodies_ARRAY_AL91', 'arrays', 'error_bodies_ARRAY_AL91', 'script', NULL),
(1161, 'lblListingTermsTip', 'backend', 'Listings / Terms tooltip', 'script', NULL),
(1162, 'front_search_state', 'frontend', 'front_search_state', 'script', NULL),
(1163, 'opt_o_sort_by', 'backend', 'Options / Property display order', 'script', NULL),
(1164, 'front_login_note', 'frontend', 'front_login_note', 'script', NULL),
(1165, 'listing_b_tax_type_ARRAY_1', 'arrays', 'listing_b_tax_type_ARRAY_1', 'script', NULL),
(1166, 'listing_b_tax_type_ARRAY_2', 'arrays', 'listing_b_tax_type_ARRAY_2', 'script', NULL),
(1167, 'front_sys_ARRAY_bf_cc_code', 'arrays', 'front_sys_ARRAY_bf_cc_code', 'script', NULL),
(1168, 'front_sys_ARRAY_bf_cc_num', 'arrays', 'front_sys_ARRAY_bf_cc_num', 'script', NULL),
(1169, 'front_sys_ARRAY_bf_cc_code_mis', 'arrays', 'front_sys_ARRAY_bf_cc_code_mis', 'script', NULL),
(1170, 'front_sys_ARRAY_bf_cc_num_mis', 'arrays', 'front_sys_ARRAY_bf_cc_num_mis', 'script', NULL),
(1171, 'front_sys_ARRAY_bf_cc_exp', 'arrays', 'front_sys_ARRAY_bf_cc_exp', 'script', NULL),
(1172, 'front_sys_ARRAY_bf_cc_exp_mis', 'arrays', 'front_sys_ARRAY_bf_cc_exp_mis', 'script', NULL),
(1173, 'front_sys_ARRAY_bf_cc_type', 'arrays', 'front_sys_ARRAY_bf_cc_type', 'script', NULL),
(1174, 'front_sys_ARRAY_bf_cc_type_mis', 'arrays', 'front_sys_ARRAY_bf_cc_type_mis', 'script', NULL),
(1175, 'opt_o_email_password_reminder', 'backend', 'Notifications / Password reminder', 'script', NULL),
(1176, 'front_sys_ARRAY_reg_verification', 'arrays', 'front_sys_ARRAY_reg_verification', 'script', NULL),
(1177, 'opt_body_forgot_password', 'backend', 'Notifications / Body', 'script', NULL),
(1216, 'status_ARRAY_9901', 'arrays', 'status_ARRAY_9901', 'script', NULL),
(1217, 'status_ARRAY_9902', 'arrays', 'status_ARRAY_9902', 'script', NULL),
(1218, 'status_ARRAY_9903', 'arrays', 'status_ARRAY_9903', 'script', NULL),
(1219, 'status_ARRAY_9904', 'arrays', 'status_ARRAY_9904', 'script', NULL),
(1220, 'status_ARRAY_9905', 'arrays', 'status_ARRAY_9905', 'script', NULL),
(1221, 'status_ARRAY_9906', 'arrays', 'status_ARRAY_9906', 'script', NULL),
(1222, 'status_ARRAY_9907', 'arrays', 'status_ARRAY_9907', 'script', NULL),
(1223, 'status_ARRAY_9908', 'arrays', 'status_ARRAY_9908', 'script', NULL),
(1224, 'status_ARRAY_9909', 'arrays', 'status_ARRAY_9909', 'script', NULL),
(1225, 'status_ARRAY_9910', 'arrays', 'status_ARRAY_9910', 'script', NULL),
(1226, 'status_ARRAY_9911', 'arrays', 'status_ARRAY_9911', 'script', NULL),
(1227, 'status_ARRAY_9912', 'arrays', 'status_ARRAY_9912', 'script', NULL),
(1228, 'status_ARRAY_9913', 'arrays', 'status_ARRAY_9913', 'script', NULL),
(1229, 'lblReservationDateRangeValidation', 'backend', 'Reservation / Date range validation', 'script', NULL),
(1230, 'lblReservationNumDaysValidation', 'backend', 'Reservation / Number of days validation ', 'script', NULL),
(1231, 'error_titles_ARRAY_AL20', 'arrays', 'error_titles_ARRAY_AL20', 'script', NULL),
(1232, 'error_bodies_ARRAY_AL20', 'arrays', 'error_bodies_ARRAY_AL20', 'script', NULL),
(1233, 'lblListingTermsSubject', 'backend', 'Listing / Terms subject', 'script', NULL),
(1234, 'front_search_map', 'frontend', 'front_search_map', 'script', NULL),
(1235, 'front_clear_map', 'frontend', 'front_clear_map', 'script', NULL),
(1236, 'lblListingAuthorizeHashText', 'backend', 'Listing / Authorize MD5 Hash Text', 'script', NULL),
(1237, 'lblListingAuthorizeHash', 'backend', 'Listing / Authorize MD5 Hash', 'script', NULL),
(1238, 'res_uuid', 'backend', 'Reservations / Unique ID', 'script', NULL),
(1342, 'opt_o_email_welcome_msg', 'backend', 'Notifications / Welcome message', 'script', NULL),
(1343, 'opt_body_welcome_msg', 'backend', 'Notifications / Body', 'script', NULL),
(1344, 'front_search_city', 'frontend', 'front_search_city', 'script', NULL),
(1345, 'menuMap', 'backend', 'Menu Map', 'script', NULL),
(1346, 'opt_o_lang_store', 'backend', 'Options / Selected language stored in', 'script', NULL),
(1347, 'lblInstallConfig', 'backend', 'Install Config', 'script', NULL),
(1348, 'lblInstallConfigLocale', 'backend', 'Install Config Locale', 'script', NULL),
(1349, 'lblInstallConfigLang', 'backend', 'Install Config Language', 'script', NULL);

DROP TABLE IF EXISTS `vacationrentals_listings`;
CREATE TABLE IF NOT EXISTS `vacationrentals_listings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `owner_id` int(11) NOT NULL,
  `type_id` int(10) unsigned NOT NULL,
  `country_id` int(10) unsigned DEFAULT NULL,
  `address_map` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `address_postcode` varchar(255) DEFAULT NULL,
  `address_content` text,
  `address_city` varchar(255) DEFAULT NULL,
  `address_state` varchar(255) DEFAULT NULL,
  `listing_refid` varchar(50) DEFAULT NULL,
  `listing_bedrooms` smallint(5) unsigned DEFAULT NULL,
  `listing_bathrooms` decimal(7,2) unsigned DEFAULT NULL,
  `listing_floor_area` decimal(9,2) unsigned DEFAULT NULL,
  `listing_adults` smallint(5) unsigned DEFAULT NULL,
  `listing_children` smallint(5) unsigned DEFAULT NULL,
  `listing_deposit` decimal(9,2) unsigned DEFAULT NULL,
  `contact_show` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `contact_phone` varchar(255) DEFAULT NULL,
  `contact_mobile` varchar(255) DEFAULT NULL,
  `contact_email` varchar(255) DEFAULT NULL,
  `contact_fax` varchar(255) DEFAULT NULL,
  `contact_url` varchar(255) DEFAULT NULL,
  `personal_title` enum('mr','mrs','miss','ms','dr','prof','rev','other') DEFAULT NULL,
  `personal_fname` varchar(255) DEFAULT NULL,
  `personal_lname` varchar(255) DEFAULT NULL,
  `personal_age` varchar(255) DEFAULT NULL,
  `personal_gender` varchar(255) DEFAULT NULL,
  `views` int(100) unsigned NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `modified` datetime DEFAULT NULL,
  `expire` date DEFAULT NULL,
  `last_extend` enum('free','paid') DEFAULT NULL,
  `status` enum('T','F','E') NOT NULL DEFAULT 'F',
  `is_featured` enum('F','T') NOT NULL DEFAULT 'F',
  `lat` varchar(255) DEFAULT NULL,
  `lng` varchar(255) DEFAULT NULL,
  `o_accept_bookings` tinyint(1) unsigned DEFAULT '1',
  `o_disable_payments` tinyint(1) unsigned DEFAULT '0',
  `o_min_booking_lenght` smallint(5) unsigned DEFAULT '1',
  `o_max_booking_lenght` smallint(5) unsigned DEFAULT '10',
  `o_default_status_if_paid` tinyint(1) unsigned DEFAULT NULL,
  `o_default_status_if_not_paid` tinyint(1) unsigned DEFAULT NULL,
  `o_price_based_on` tinyint(1) unsigned DEFAULT '1',
  `o_deposit_payment` decimal(9,2) unsigned DEFAULT '10.00',
  `o_security_payment` smallint(5) unsigned DEFAULT '0',
  `o_tax_payment` decimal(9,2) unsigned DEFAULT '0.00',
  `o_tax_type` tinyint(1) unsigned DEFAULT '1',
  `o_require_all_within_days` smallint(5) unsigned DEFAULT NULL,
  `o_allow_paypal` tinyint(1) unsigned DEFAULT '1',
  `o_allow_authorize` tinyint(1) unsigned DEFAULT '0',
  `o_allow_creditcard` tinyint(1) unsigned DEFAULT '0',
  `o_allow_bank` tinyint(1) unsigned DEFAULT '0',
  `o_thankyou_page` varchar(255) DEFAULT NULL,
  `o_authorize_merchant_id` varchar(255) DEFAULT NULL,
  `o_authorize_transkey` varchar(255) DEFAULT NULL,
  `o_authorize_hash` varchar(255) DEFAULT NULL,
  `o_authorize_tz` int(10) DEFAULT NULL,
  `o_paypal_address` varchar(255) DEFAULT NULL,
  `o_bank_account` tinytext,
  PRIMARY KEY (`id`),
  UNIQUE KEY `listing_refid` (`listing_refid`),
  KEY `type_id` (`type_id`),
  KEY `country_id` (`country_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `vacationrentals_listings_extras`;
CREATE TABLE IF NOT EXISTS `vacationrentals_listings_extras` (
  `listing_id` int(10) unsigned NOT NULL,
  `extra_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`listing_id`,`extra_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `vacationrentals_multi_lang`;
CREATE TABLE IF NOT EXISTS `vacationrentals_multi_lang` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `foreign_id` int(10) unsigned DEFAULT NULL,
  `model` varchar(100) DEFAULT NULL,
  `locale` tinyint(3) unsigned DEFAULT NULL,
  `field` varchar(100) DEFAULT NULL,
  `content` text,
  `source` enum('script','plugin','data') DEFAULT 'script',
  PRIMARY KEY (`id`),
  UNIQUE KEY `foreign_id` (`foreign_id`,`model`,`locale`,`field`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

INSERT INTO `vacationrentals_multi_lang` (`id`, `foreign_id`, `model`, `locale`, `field`, `content`, `source`) VALUES
(NULL, 1, 'pjExtra', 1, 'name', 'Air conditioning', 'script'),
(NULL, 2, 'pjExtra', 1, 'name', 'Office / Den', 'script'),
(NULL, 3, 'pjExtra', 1, 'name', 'Washer', 'script'),
(NULL, 4, 'pjExtra', 1, 'name', 'Central heat', 'script'),
(NULL, 5, 'pjExtra', 1, 'name', 'Dining room', 'script'),
(NULL, 6, 'pjExtra', 1, 'name', 'Dryer', 'script'),
(NULL, 7, 'pjExtra', 1, 'name', 'Fireplace', 'script'),
(NULL, 8, 'pjExtra', 1, 'name', 'Breakfast nook', 'script'),
(NULL, 9, 'pjExtra', 1, 'name', 'Laundry area - inside', 'script'),
(NULL, 10, 'pjExtra', 1, 'name', 'High / Vaulted ceiling', 'script'),
(NULL, 11, 'pjExtra', 1, 'name', 'Dishwasher', 'script'),
(NULL, 12, 'pjExtra', 1, 'name', 'Laundry area - garage', 'script'),
(NULL, 13, 'pjExtra', 1, 'name', 'Walk-in closet', 'script'),
(NULL, 14, 'pjExtra', 1, 'name', 'Refrigerator', 'script'),
(NULL, 15, 'pjExtra', 1, 'name', 'Balcony, Deck or Patio', 'script'),
(NULL, 16, 'pjExtra', 1, 'name', 'Hardwood floor', 'script'),
(NULL, 17, 'pjExtra', 1, 'name', 'Stove / Oven', 'script'),
(NULL, 18, 'pjExtra', 1, 'name', 'Yard', 'script'),
(NULL, 19, 'pjExtra', 1, 'name', 'Tile floor', 'script'),
(NULL, 20, 'pjExtra', 1, 'name', 'Microwave', 'script'),
(NULL, 21, 'pjExtra', 1, 'name', 'Swimming pool', 'script'),
(NULL, 22, 'pjExtra', 1, 'name', 'Family room', 'script'),
(NULL, 23, 'pjExtra', 1, 'name', 'Granite countertop', 'script'),
(NULL, 24, 'pjExtra', 1, 'name', 'Jacuzzi / Whirlpool', 'script'),
(NULL, 25, 'pjExtra', 1, 'name', 'Living Room', 'script'),
(NULL, 26, 'pjExtra', 1, 'name', 'Stainless steel appliances', 'script'),
(NULL, 27, 'pjExtra', 1, 'name', 'Sauna', 'script'),
(NULL, 28, 'pjExtra', 1, 'name', 'Bonus / Rec room', 'script'),
(NULL, 29, 'pjExtra', 1, 'name', 'Attic', 'script'),
(NULL, 30, 'pjExtra', 1, 'name', 'Cable- ready', 'script'),
(NULL, 31, 'pjExtra', 1, 'name', 'Loft layout', 'script'),
(NULL, 32, 'pjExtra', 1, 'name', 'Basement', 'script'),
(NULL, 33, 'pjExtra', 1, 'name', 'High- speed internet', 'script'),
(NULL, 34, 'pjExtra', 1, 'name', 'Garage parking', 'script'),
(NULL, 35, 'pjExtra', 1, 'name', 'Fitness center', 'script'),
(NULL, 36, 'pjExtra', 1, 'name', 'Gated property', 'script'),
(NULL, 37, 'pjExtra', 1, 'name', 'Covered parking', 'script'),
(NULL, 38, 'pjExtra', 1, 'name', 'Swimming pool(s)', 'script'),
(NULL, 39, 'pjExtra', 1, 'name', 'Secured entry', 'script'),
(NULL, 40, 'pjExtra', 1, 'name', 'Guest parking', 'script'),
(NULL, 41, 'pjExtra', 1, 'name', 'Sauna / Spa', 'script'),
(NULL, 42, 'pjExtra', 1, 'name', 'Elevator', 'script'),
(NULL, 43, 'pjExtra', 1, 'name', 'Business center', 'script'),
(NULL, 44, 'pjExtra', 1, 'name', 'Tennis court(s)', 'script'),
(NULL, 45, 'pjExtra', 1, 'name', 'New property (<5 years)', 'script'),
(NULL, 46, 'pjExtra', 1, 'name', 'Clubhouse', 'script'),
(NULL, 47, 'pjExtra', 1, 'name', 'Golf course', 'script'),
(NULL, 48, 'pjExtra', 1, 'name', 'Small building', 'script'),
(NULL, 49, 'pjExtra', 1, 'name', 'Laundry on-site', 'script'),
(NULL, 50, 'pjExtra', 1, 'name', 'Lake', 'script'),
(NULL, 51, 'pjExtra', 1, 'name', 'Vintage building', 'script'),
(NULL, 52, 'pjExtra', 1, 'name', 'Storage space(s)', 'script'),
(NULL, 53, 'pjExtra', 1, 'name', 'Playground', 'script'),
(NULL, 54, 'pjExtra', 1, 'name', 'Wheelchair access', 'script'),
(NULL, 6, 'pjField', 1, 'title', 'Password', 'script'),
(NULL, 7, 'pjField', 1, 'title', 'Email', 'script'),
(NULL, 16, 'pjField', 1, 'title', 'Save', 'script'),
(NULL, 24, 'pjField', 1, 'title', 'Users', 'script'),
(NULL, 25, 'pjField', 1, 'title', 'Options', 'script'),
(NULL, 26, 'pjField', 1, 'title', 'Logout', 'script'),
(NULL, 36, 'pjField', 1, 'title', 'Choose', 'script'),
(NULL, 37, 'pjField', 1, 'title', 'Search', 'script'),
(NULL, 44, 'pjField', 1, 'title', 'Admin Login', 'script'),
(NULL, 45, 'pjField', 1, 'title', 'Login', 'script'),
(NULL, 46, 'pjField', 1, 'title', 'Install', 'script'),
(NULL, 47, 'pjField', 1, 'title', 'Dashboard', 'script'),
(NULL, 48, 'pjField', 1, 'title', 'Properties', 'script'),
(NULL, 49, 'pjField', 1, 'title', 'Add property', 'script'),
(NULL, 51, 'pjField', 1, 'title', 'Reservations', 'script'),
(NULL, 52, 'pjField', 1, 'title', 'Preview', 'script'),
(NULL, 54, 'pjField', 1, 'title', 'Extras', 'script'),
(NULL, 55, 'pjField', 1, 'title', 'Types', 'script'),
(NULL, 56, 'pjField', 1, 'title', 'Properties', 'script'),
(NULL, 58, 'pjField', 1, 'title', 'Add +', 'script'),
(NULL, 61, 'pjField', 1, 'title', 'Country', 'script'),
(NULL, 62, 'pjField', 1, 'title', 'Delete', 'script'),
(NULL, 63, 'pjField', 1, 'title', 'Extra', 'script'),
(NULL, 64, 'pjField', 1, 'title', 'Extra type', 'script'),
(NULL, 65, 'pjField', 1, 'title', 'Type', 'script'),
(NULL, 66, 'pjField', 1, 'title', 'Name', 'script'),
(NULL, 67, 'pjField', 1, 'title', 'Role', 'script'),
(NULL, 68, 'pjField', 1, 'title', 'Status', 'script'),
(NULL, 69, 'pjField', 1, 'title', 'Is confirmed', 'script'),
(NULL, 70, 'pjField', 1, 'title', 'Update user', 'script'),
(NULL, 71, 'pjField', 1, 'title', 'Add user', 'script'),
(NULL, 72, 'pjField', 1, 'title', 'Value', 'script'),
(NULL, 73, 'pjField', 1, 'title', 'Option', 'script'),
(NULL, 74, 'pjField', 1, 'title', 'days', 'script'),
(NULL, 76, 'pjField', 1, 'title', 'Follow these steps to put the property listing on your .php web page using PHP include code:', 'script'),
(NULL, 77, 'pjField', 1, 'title', 'Follow these steps to put the property search form on your .php web page using PHP include code:', 'script'),
(NULL, 78, 'pjField', 1, 'title', 'Follow these steps to put the featured property listing on your .php web page using PHP include code:', 'script'),
(NULL, 79, 'pjField', 1, 'title', 'Step 1. Copy and paste the code below at the very top of your .php page. It should be line 1 of your .php web page.', 'script'),
(NULL, 80, 'pjField', 1, 'title', 'Step 2. Copy and paste the code below into your html code, where properties will be displayed.', 'script'),
(NULL, 81, 'pjField', 1, 'title', 'Step 3. Copy and paste the code below at the very bottom of your .php web page after all the other code.', 'script'),
(NULL, 82, 'pjField', 1, 'title', 'Step 1. Create a file named ".htaccess" in the same directory where your .php page with property listing is. Then copy and paste the following code into the file.', 'script'),
(NULL, 83, 'pjField', 1, 'title', '(Optional) If you are experiencing problems with styling (CSS) put the following code into the HEAD part of your web page.', 'script'),
(NULL, 84, 'pjField', 1, 'title', 'Step 1. Copy and paste the code below at the very top of your .php page. It should be line 1 of your .php web page.', 'script'),
(NULL, 85, 'pjField', 1, 'title', 'Step 2. Copy and paste the code below into your html code, where the search form will be displayed.', 'script'),
(NULL, 86, 'pjField', 1, 'title', 'Step 3. Copy and paste the code below at the very bottom of your .php web page after all the other code.', 'script'),
(NULL, 87, 'pjField', 1, 'title', 'Step 1. Copy and paste the code below at the very top of your .php page. It should be line 1 of your .php web page.', 'script'),
(NULL, 88, 'pjField', 1, 'title', 'Step 2. Copy and paste the code below into your html code, where featured properties will be displayed.', 'script'),
(NULL, 89, 'pjField', 1, 'title', 'Step 3. Copy and paste the code below at the very bottom of your .php web page after all the other code.', 'script'),
(NULL, 90, 'pjField', 1, 'title', '(Optional) If you want to show the search form on the featured listings page, replace the code from Step 3 under "Featured listings" tab with this one.', 'script'),
(NULL, 91, 'pjField', 1, 'title', 'Add reservation', 'script'),
(NULL, 92, 'pjField', 1, 'title', 'Name', 'script'),
(NULL, 93, 'pjField', 1, 'title', 'Email', 'script'),
(NULL, 94, 'pjField', 1, 'title', 'Phone', 'script'),
(NULL, 96, 'pjField', 1, 'title', 'Notes', 'script'),
(NULL, 97, 'pjField', 1, 'title', 'Security', 'script'),
(NULL, 98, 'pjField', 1, 'title', 'Deposit', 'script'),
(NULL, 99, 'pjField', 1, 'title', 'Tax', 'script'),
(NULL, 100, 'pjField', 1, 'title', 'From', 'script'),
(NULL, 101, 'pjField', 1, 'title', 'To', 'script'),
(NULL, 102, 'pjField', 1, 'title', 'Payment method', 'script'),
(NULL, 103, 'pjField', 1, 'title', 'Amount', 'script'),
(NULL, 104, 'pjField', 1, 'title', 'Status', 'script'),
(NULL, 105, 'pjField', 1, 'title', 'Property', 'script'),
(NULL, 106, 'pjField', 1, 'title', 'CC Type', 'script'),
(NULL, 107, 'pjField', 1, 'title', 'CC Number', 'script'),
(NULL, 108, 'pjField', 1, 'title', 'CC Code', 'script'),
(NULL, 109, 'pjField', 1, 'title', 'CC Expiration date', 'script'),
(NULL, 110, 'pjField', 1, 'title', 'Update reservation', 'script'),
(NULL, 111, 'pjField', 1, 'title', 'Reference ID', 'script'),
(NULL, 112, 'pjField', 1, 'title', 'Publish', 'script'),
(NULL, 113, 'pjField', 1, 'title', 'Type', 'script'),
(NULL, 114, 'pjField', 1, 'title', 'Make Featured', 'script'),
(NULL, 115, 'pjField', 1, 'title', 'Languages', 'script'),
(NULL, 116, 'pjField', 1, 'title', 'Yes', 'script'),
(NULL, 117, 'pjField', 1, 'title', 'No', 'script'),
(NULL, 118, 'pjField', 1, 'title', 'Summary', 'script'),
(NULL, 119, 'pjField', 1, 'title', 'Details', 'script'),
(NULL, 120, 'pjField', 1, 'title', 'Extras', 'script'),
(NULL, 121, 'pjField', 1, 'title', 'Photos', 'script'),
(NULL, 122, 'pjField', 1, 'title', 'Contact', 'script'),
(NULL, 123, 'pjField', 1, 'title', 'Address', 'script'),
(NULL, 124, 'pjField', 1, 'title', 'Prices', 'script'),
(NULL, 125, 'pjField', 1, 'title', 'Booking', 'script'),
(NULL, 126, 'pjField', 1, 'title', 'Terms', 'script'),
(NULL, 127, 'pjField', 1, 'title', 'Added on', 'script'),
(NULL, 128, 'pjField', 1, 'title', 'Last update on', 'script'),
(NULL, 129, 'pjField', 1, 'title', 'Views', 'script'),
(NULL, 130, 'pjField', 1, 'title', 'Not yet', 'script'),
(NULL, 131, 'pjField', 1, 'title', 'Expire date', 'script'),
(NULL, 132, 'pjField', 1, 'title', 'Floor area', 'script'),
(NULL, 133, 'pjField', 1, 'title', 'Children', 'script'),
(NULL, 134, 'pjField', 1, 'title', 'Adults', 'script'),
(NULL, 135, 'pjField', 1, 'title', 'Bathrooms', 'script'),
(NULL, 136, 'pjField', 1, 'title', 'Bedrooms', 'script'),
(NULL, 137, 'pjField', 1, 'title', 'First Name', 'script'),
(NULL, 138, 'pjField', 1, 'title', 'Last Name', 'script'),
(NULL, 139, 'pjField', 1, 'title', 'Cell phone', 'script'),
(NULL, 140, 'pjField', 1, 'title', 'Phone', 'script'),
(NULL, 141, 'pjField', 1, 'title', 'Email', 'script'),
(NULL, 142, 'pjField', 1, 'title', 'Fax', 'script'),
(NULL, 143, 'pjField', 1, 'title', 'Website', 'script'),
(NULL, 144, 'pjField', 1, 'title', 'Title', 'script'),
(NULL, 145, 'pjField', 1, 'title', 'Show contact details', 'script'),
(NULL, 146, 'pjField', 1, 'title', 'Show on map', 'script'),
(NULL, 147, 'pjField', 1, 'title', 'Zip', 'script'),
(NULL, 148, 'pjField', 1, 'title', 'Country', 'script'),
(NULL, 149, 'pjField', 1, 'title', 'State', 'script'),
(NULL, 150, 'pjField', 1, 'title', 'City', 'script'),
(NULL, 151, 'pjField', 1, 'title', 'From', 'script'),
(NULL, 152, 'pjField', 1, 'title', 'To', 'script'),
(NULL, 153, 'pjField', 1, 'title', 'Price', 'script'),
(NULL, 162, 'pjField', 1, 'title', 'Description', 'script'),
(NULL, 163, 'pjField', 1, 'title', 'Confirmation email', 'script'),
(NULL, 164, 'pjField', 1, 'title', 'Payment email', 'script'),
(NULL, 165, 'pjField', 1, 'title', 'These are the supported tokens which can be used in the email message<br> {Name} - customer''s name<br> {Email} - customer''s e-mail<br> {Phone} - phone number<br> {Notes} - additional notes<br> {CCType} - CC type<br> {CCNum} - CC number<br> {CCExp} - CC exp. date<br> {CCSec} - CC security code<br> {PaymentMethod} - payment method<br> {StartDate} - start date<br> {EndDate} - end date<br> {Price} - price<br> {Deposit} - deposit<br> {Security} - security amount<br> {Tax} - tax<br> {Total} - total price<br> {ListingID} - property ID<br> {ListingRefID} - property ref.ID<br> {ReservationID} - reservation ID<br> {ReservationUUID} - reservation unique ID', 'script'),
(NULL, 166, 'pjField', 1, 'title', 'These are the supported tokens which can be used in the email message<br> {Name} - customer''s name<br> {Email} - customer''s e-mail<br> {Phone} - phone number<br> {Notes} - additional notes<br> {CCType} - CC type<br> {CCNum} - CC number<br> {CCExp} - CC exp. date<br> {CCSec} - CC security code<br> {PaymentMethod} - payment method<br> {StartDate} - start date<br> {EndDate} - end date<br> {Price} - price<br> {Deposit} - deposit<br> {Security} - security amount<br> {Tax} - tax<br> {Total} - total price<br> {ListingID} - property ID<br> {ListingRefID} - property ref.ID<br> {ReservationID} - reservation ID<br> {ReservationUUID} - reservation unique ID', 'script'),
(NULL, 167, 'pjField', 1, 'title', 'Accept bookings:', 'script'),
(NULL, 168, 'pjField', 1, 'title', 'You can disable the booking form on the property page details page.', 'script'),
(NULL, 169, 'pjField', 1, 'title', 'Disable payments:', 'script'),
(NULL, 170, 'pjField', 1, 'title', 'You can disable payments and only let people fill in the booking form.', 'script'),
(NULL, 171, 'pjField', 1, 'title', 'Minimum booking length', 'script'),
(NULL, 172, 'pjField', 1, 'title', 'set minimum number of days/nights visitors must book.', 'script'),
(NULL, 173, 'pjField', 1, 'title', 'Maximum booking length:', 'script'),
(NULL, 174, 'pjField', 1, 'title', 'set maximum number of days/nights visitors may book.', 'script'),
(NULL, 175, 'pjField', 1, 'title', 'Book days or nights:', 'script'),
(NULL, 176, 'pjField', 1, 'title', 'Price will be calculated based on the number of selected days or nights.', 'script'),
(NULL, 181, 'pjField', 1, 'title', 'Allow payments at:', 'script'),
(NULL, 182, 'pjField', 1, 'title', 'Check only the payment methods that you want to include at the front-end.', 'script'),
(NULL, 183, 'pjField', 1, 'title', 'PayPal payments', 'script'),
(NULL, 185, 'pjField', 1, 'title', 'Authorize.net payments', 'script'),
(NULL, 187, 'pjField', 1, 'title', 'Collect CC details', 'script'),
(NULL, 188, 'pjField', 1, 'title', 'Deposit payment:', 'script'),
(NULL, 189, 'pjField', 1, 'title', 'If you''d like to charge the full amount, just enter 100.', 'script'),
(NULL, 190, 'pjField', 1, 'title', 'Security deposit payment:', 'script'),
(NULL, 191, 'pjField', 1, 'title', 'If you do not want the system to collect security deposit, just enter 0.', 'script'),
(NULL, 192, 'pjField', 1, 'title', 'Tax payment:', 'script'),
(NULL, 193, 'pjField', 1, 'title', 'If there is no tax for payments, just enter 0. You can also add a fixed tax value or % of the total price.', 'script'),
(NULL, 196, 'pjField', 1, 'title', 'Require 100%, if the reservations is within X days:', 'script'),
(NULL, 197, 'pjField', 1, 'title', 'Example: if today is 10th and you enter "5" in the box, when someone makes reservation for 14th, then the full payment will be required.', 'script'),
(NULL, 198, 'pjField', 1, 'title', 'Authorize.net merchant ID:', 'script'),
(NULL, 199, 'pjField', 1, 'title', 'This is your authorize.net merchant ID.', 'script'),
(NULL, 200, 'pjField', 1, 'title', 'Authorize.net transaction key:', 'script'),
(NULL, 201, 'pjField', 1, 'title', 'This is your Authorize.net transaction key.', 'script'),
(NULL, 202, 'pjField', 1, 'title', 'Authorize.net time zone:', 'script'),
(NULL, 203, 'pjField', 1, 'title', 'Enter the time zone that your Authorize.Net account uses.', 'script'),
(NULL, 204, 'pjField', 1, 'title', 'Paypal address:', 'script'),
(NULL, 205, 'pjField', 1, 'title', 'Enter the email address associated with your PayPal account.', 'script'),
(NULL, 208, 'pjField', 1, 'title', 'Booking status if paid:', 'script'),
(NULL, 209, 'pjField', 1, 'title', 'set the default reservation status should be if payment is made.', 'script'),
(NULL, 210, 'pjField', 1, 'title', 'Booking status if not paid:', 'script'),
(NULL, 211, 'pjField', 1, 'title', 'set the default reservation status should be if payment is not made.', 'script'),
(NULL, 212, 'pjField', 1, 'title', '"Thank you" page location.', 'script'),
(NULL, 213, 'pjField', 1, 'title', 'Enter the full URL of the page that people will be redirected to after paying.', 'script'),
(NULL, 220, 'pjField', 1, 'title', 'Are you sure you want to delete selected record(s)?', 'script'),
(NULL, 221, 'pjField', 1, 'title', 'Bank Account payments', 'script'),
(NULL, 222, 'pjField', 1, 'title', 'Bank Account', 'script'),
(NULL, 223, 'pjField', 1, 'title', 'Enter your bank account information which people will see when making a reservation.', 'script'),
(NULL, 224, 'pjField', 1, 'title', 'Listing', 'script'),
(NULL, 225, 'pjField', 1, 'title', 'Search form', 'script'),
(NULL, 226, 'pjField', 1, 'title', 'Featured listings', 'script'),
(NULL, 227, 'pjField', 1, 'title', 'Optional', 'script'),
(NULL, 228, 'pjField', 1, 'title', 'Latitude', 'script'),
(NULL, 229, 'pjField', 1, 'title', 'Longitude', 'script'),
(NULL, 230, 'pjField', 1, 'title', 'Get from Google Maps API using the address.', 'script'),
(NULL, 234, 'pjField', 1, 'title', 'properties', 'script'),
(NULL, 235, 'pjField', 1, 'title', 'reservations', 'script'),
(NULL, 236, 'pjField', 1, 'title', 'users', 'script'),
(NULL, 237, 'pjField', 1, 'title', 'views', 'script'),
(NULL, 238, 'pjField', 1, 'title', 'Latest Reservations', 'script'),
(NULL, 239, 'pjField', 1, 'title', 'Nights', 'script'),
(NULL, 240, 'pjField', 1, 'title', 'Top Users', 'script'),
(NULL, 241, 'pjField', 1, 'title', 'last login', 'script'),
(NULL, 242, 'pjField', 1, 'title', 'Most Popular', 'script'),
(NULL, 243, 'pjField', 1, 'title', 'Home', 'script'),
(NULL, 244, 'pjField', 1, 'title', 'Search', 'script'),
(NULL, 245, 'pjField', 1, 'title', 'Add property', 'script'),
(NULL, 246, 'pjField', 1, 'title', '&laquo; Back', 'script'),
(NULL, 247, 'pjField', 1, 'title', 'Back', 'script'),
(NULL, 248, 'pjField', 1, 'title', 'No properties found', 'script'),
(NULL, 249, 'pjField', 1, 'title', 'Bedrooms', 'script'),
(NULL, 250, 'pjField', 1, 'title', 'Bathrooms', 'script'),
(NULL, 251, 'pjField', 1, 'title', 'Type', 'script'),
(NULL, 252, 'pjField', 1, 'title', 'Floor area', 'script'),
(NULL, 253, 'pjField', 1, 'title', 'View details', 'script'),
(NULL, 256, 'pjField', 1, 'title', 'Reference ID', 'script'),
(NULL, 257, 'pjField', 1, 'title', 'Type', 'script'),
(NULL, 258, 'pjField', 1, 'title', 'Bedrooms', 'script'),
(NULL, 259, 'pjField', 1, 'title', 'Bathrooms', 'script'),
(NULL, 260, 'pjField', 1, 'title', 'Adults', 'script'),
(NULL, 261, 'pjField', 1, 'title', 'Children', 'script'),
(NULL, 262, 'pjField', 1, 'title', 'Floor area', 'script'),
(NULL, 263, 'pjField', 1, 'title', 'Feature set', 'script'),
(NULL, 264, 'pjField', 1, 'title', 'Property description', 'script'),
(NULL, 265, 'pjField', 1, 'title', 'Not available', 'script'),
(NULL, 266, 'pjField', 1, 'title', 'Contact details', 'script'),
(NULL, 267, 'pjField', 1, 'title', 'Post code', 'script'),
(NULL, 268, 'pjField', 1, 'title', 'Address', 'script'),
(NULL, 269, 'pjField', 1, 'title', 'Country', 'script'),
(NULL, 270, 'pjField', 1, 'title', 'State', 'script'),
(NULL, 271, 'pjField', 1, 'title', 'City', 'script'),
(NULL, 272, 'pjField', 1, 'title', 'Name', 'script'),
(NULL, 273, 'pjField', 1, 'title', 'Phone', 'script'),
(NULL, 274, 'pjField', 1, 'title', 'Cell phone', 'script'),
(NULL, 275, 'pjField', 1, 'title', 'E-Mail', 'script'),
(NULL, 276, 'pjField', 1, 'title', 'Fax', 'script'),
(NULL, 277, 'pjField', 1, 'title', 'Website', 'script'),
(NULL, 278, 'pjField', 1, 'title', 'Map', 'script'),
(NULL, 279, 'pjField', 1, 'title', 'Prices', 'script'),
(NULL, 280, 'pjField', 1, 'title', 'From', 'script'),
(NULL, 281, 'pjField', 1, 'title', 'To', 'script'),
(NULL, 282, 'pjField', 1, 'title', 'Price', 'script'),
(NULL, 283, 'pjField', 1, 'title', 'Availability', 'script'),
(NULL, 284, 'pjField', 1, 'title', 'Booking terms', 'script'),
(NULL, 290, 'pjField', 1, 'title', 'From', 'script'),
(NULL, 291, 'pjField', 1, 'title', 'To', 'script'),
(NULL, 292, 'pjField', 1, 'title', 'Total price for selected date range', 'script'),
(NULL, 293, 'pjField', 1, 'title', 'Name', 'script'),
(NULL, 294, 'pjField', 1, 'title', 'E-Mail', 'script'),
(NULL, 295, 'pjField', 1, 'title', 'Phone', 'script'),
(NULL, 296, 'pjField', 1, 'title', 'Additional requirements', 'script'),
(NULL, 297, 'pjField', 1, 'title', 'Send request', 'script'),
(NULL, 298, 'pjField', 1, 'title', 'Captcha', 'script'),
(NULL, 299, 'pjField', 1, 'title', 'CC Type', 'script'),
(NULL, 300, 'pjField', 1, 'title', 'CC Number', 'script'),
(NULL, 301, 'pjField', 1, 'title', 'CC Security code', 'script'),
(NULL, 302, 'pjField', 1, 'title', 'CC Expiration date', 'script'),
(NULL, 303, 'pjField', 1, 'title', '-- Payment method --', 'script'),
(NULL, 304, 'pjField', 1, 'title', 'Payment method', 'script'),
(NULL, 305, 'pjField', 1, 'title', 'Search for properties', 'script'),
(NULL, 306, 'pjField', 1, 'title', 'Search', 'script'),
(NULL, 307, 'pjField', 1, 'title', '-- All --', 'script'),
(NULL, 308, 'pjField', 1, 'title', 'Type', 'script'),
(NULL, 309, 'pjField', 1, 'title', 'Reference ID', 'script'),
(NULL, 310, 'pjField', 1, 'title', 'Country', 'script'),
(NULL, 311, 'pjField', 1, 'title', 'Bedrooms', 'script'),
(NULL, 312, 'pjField', 1, 'title', 'Bathrooms', 'script'),
(NULL, 313, 'pjField', 1, 'title', 'Adults', 'script'),
(NULL, 314, 'pjField', 1, 'title', 'Children', 'script'),
(NULL, 315, 'pjField', 1, 'title', 'Floor area', 'script'),
(NULL, 316, 'pjField', 1, 'title', 'to', 'script'),
(NULL, 318, 'pjField', 1, 'title', 'above', 'script'),
(NULL, 319, 'pjField', 1, 'title', 'Available from', 'script'),
(NULL, 320, 'pjField', 1, 'title', 'Available to', 'script'),
(NULL, 324, 'pjField', 1, 'title', 'Login your account', 'script'),
(NULL, 325, 'pjField', 1, 'title', 'Login', 'script'),
(NULL, 327, 'pjField', 1, 'title', 'Password', 'script'),
(NULL, 328, 'pjField', 1, 'title', 'Create an account', 'script'),
(NULL, 329, 'pjField', 1, 'title', 'Register', 'script'),
(NULL, 331, 'pjField', 1, 'title', 'Password', 'script'),
(NULL, 332, 'pjField', 1, 'title', 'Confirm password', 'script'),
(NULL, 333, 'pjField', 1, 'title', 'Name', 'script'),
(NULL, 334, 'pjField', 1, 'title', 'Email', 'script'),
(NULL, 335, 'pjField', 1, 'title', 'Featured properties', 'script'),
(NULL, 339, 'pjField', 1, 'title', '+ Add period / price', 'script'),
(NULL, 340, 'pjField', 1, 'title', 'Period', 'script'),
(NULL, 341, 'pjField', 1, 'title', 'Price', 'script'),
(NULL, 343, 'pjField', 1, 'title', 'FREE', 'script'),
(NULL, 344, 'pjField', 1, 'title', 'Extend your period for FREE', 'script'),
(NULL, 345, 'pjField', 1, 'title', 'Buy now', 'script'),
(NULL, 346, 'pjField', 1, 'title', 'Email', 'script'),
(NULL, 348, 'pjField', 1, 'title', 'Owner', 'script'),
(NULL, 349, 'pjField', 1, 'title', 'No properties found.', 'script'),
(NULL, 350, 'pjField', 1, 'title', 'No reservations found.', 'script'),
(NULL, 351, 'pjField', 1, 'title', 'Follow these steps to turn on the SEO URL module and have search engine friendly URLs for your properties.', 'script'),
(NULL, 352, 'pjField', 1, 'title', 'Prices are not added yet.', 'script'),
(NULL, 353, 'pjField', 1, 'title', 'Add New Property', 'script'),
(NULL, 354, 'pjField', 1, 'title', 'Fill out the fields and click Save to continue. ', 'script'),
(NULL, 355, 'pjField', 1, 'title', 'Cancel', 'script'),
(NULL, 356, 'pjField', 1, 'title', 'Forgot password', 'script'),
(NULL, 357, 'pjField', 1, 'title', 'Password reminder', 'script'),
(NULL, 358, 'pjField', 1, 'title', 'Send', 'script'),
(NULL, 363, 'pjField', 1, 'title', 'Publish the property permanently, hide it or publish until the expiration date set.', 'script'),
(NULL, 364, 'pjField', 1, 'title', 'Set a date until the property will be published. Make sure Publish status is set based on exp. date', 'script'),
(NULL, 365, 'pjField', 1, 'title', 'Profile', 'script'),
(NULL, 366, 'pjField', 1, 'title', 'Front-end Submissions', 'script'),
(NULL, 367, 'pjField', 1, 'title', 'Allow website visitors to publish properties and set various options.', 'script'),
(NULL, 368, 'pjField', 1, 'title', 'Property Types', 'script'),
(NULL, 369, 'pjField', 1, 'title', 'Manage property types: add, edit or delete property types.', 'script'),
(NULL, 370, 'pjField', 1, 'title', 'Extras', 'script'),
(NULL, 371, 'pjField', 1, 'title', 'Manage extras: add, edit and delete extras.', 'script'),
(NULL, 372, 'pjField', 1, 'title', 'Add Property Type', 'script'),
(NULL, 373, 'pjField', 1, 'title', 'Write a name of the property type, than click Save.', 'script'),
(NULL, 374, 'pjField', 1, 'title', 'Update Property Type', 'script'),
(NULL, 375, 'pjField', 1, 'title', 'Edit the property type, then click Save.', 'script'),
(NULL, 376, 'pjField', 1, 'title', 'Add Extra', 'script'),
(NULL, 377, 'pjField', 1, 'title', 'Add an extra, select type and click Save.', 'script'),
(NULL, 378, 'pjField', 1, 'title', 'Update', 'script'),
(NULL, 379, 'pjField', 1, 'title', 'Edit the feature, then click Save.', 'script'),
(NULL, 386, 'pjField', 1, 'title', 'Rental Rates', 'script'),
(NULL, 387, 'pjField', 1, 'title', 'Select date range and add price, then click Save to confirm.', 'script'),
(NULL, 388, 'pjField', 1, 'title', 'Booking Options', 'script'),
(NULL, 389, 'pjField', 1, 'title', 'Edit booking options and then click Save.', 'script'),
(NULL, 390, 'pjField', 1, 'title', 'Contact Details', 'script'),
(NULL, 391, 'pjField', 1, 'title', 'Fill out the fields and click Save to add contact details to the listing.', 'script'),
(NULL, 392, 'pjField', 1, 'title', 'Property Address', 'script'),
(NULL, 393, 'pjField', 1, 'title', 'Fill out the address information and click Save.', 'script'),
(NULL, 395, 'pjField', 1, 'title', 'Extend exp.date ', 'script'),
(NULL, 396, 'pjField', 1, 'title', 'Extend exp.date', 'script'),
(NULL, 397, 'pjField', 1, 'title', 'Extend expiration date', 'script'),
(NULL, 398, 'pjField', 1, 'title', 'Property', 'script'),
(NULL, 399, 'pjField', 1, 'title', 'price from', 'script'),
(NULL, 400, 'pjField', 1, 'title', 'properties found', 'script'),
(NULL, 401, 'pjField', 1, 'title', 'property found', 'script'),
(NULL, 402, 'pjField', 1, 'title', 'next page &raquo;', 'script'),
(NULL, 403, 'pjField', 1, 'title', '&laquo; prev page', 'script'),
(NULL, 404, 'pjField', 1, 'title', 'Make a reservation', 'script'),
(NULL, 405, 'pjField', 1, 'title', 'and manage your own properties', 'script'),
(NULL, 406, 'pjField', 1, 'title', 'and manage your own properties', 'script'),
(NULL, 407, 'pjField', 1, 'title', 'View Details', 'script'),
(NULL, 408, 'pjField', 1, 'title', 'Backup', 'script'),
(NULL, 409, 'pjField', 1, 'title', 'Backup', 'script'),
(NULL, 410, 'pjField', 1, 'title', 'Backup database', 'script'),
(NULL, 411, 'pjField', 1, 'title', 'Backup files', 'script'),
(NULL, 412, 'pjField', 1, 'title', 'Choose Action', 'script'),
(NULL, 413, 'pjField', 1, 'title', 'Go to page:', 'script'),
(NULL, 414, 'pjField', 1, 'title', 'Total items:', 'script'),
(NULL, 415, 'pjField', 1, 'title', 'Items per page', 'script'),
(NULL, 416, 'pjField', 1, 'title', 'Prev page', 'script'),
(NULL, 417, 'pjField', 1, 'title', '&laquo; Prev', 'script'),
(NULL, 418, 'pjField', 1, 'title', 'Next page', 'script'),
(NULL, 419, 'pjField', 1, 'title', 'Next &raquo;', 'script'),
(NULL, 420, 'pjField', 1, 'title', 'Delete confirmation', 'script'),
(NULL, 421, 'pjField', 1, 'title', 'Are you sure you want to delete this entry?', 'script'),
(NULL, 422, 'pjField', 1, 'title', 'Action confirmation', 'script'),
(NULL, 423, 'pjField', 1, 'title', 'OK', 'script'),
(NULL, 424, 'pjField', 1, 'title', 'Cancel', 'script'),
(NULL, 425, 'pjField', 1, 'title', 'Delete', 'script'),
(NULL, 426, 'pjField', 1, 'title', 'No records found', 'script'),
(NULL, 427, 'pjField', 1, 'title', 'No records selected', 'script'),
(NULL, 428, 'pjField', 1, 'title', 'You need to select at least a single record', 'script'),
(NULL, 433, 'pjField', 1, 'title', 'Select a language by clicking on the corresponding flag and input the correct text.', 'script'),
(NULL, 434, 'pjField', 1, 'title', 'IP address', 'script'),
(NULL, 435, 'pjField', 1, 'title', 'Registration date/time', 'script'),
(NULL, 436, 'pjField', 1, 'title', 'Date/Time reservation made', 'script'),
(NULL, 437, 'pjField', 1, 'title', 'n/a', 'script'),
(NULL, 438, 'pjField', 1, 'title', 'Update confirmation', 'script'),
(NULL, 439, 'pjField', 1, 'title', 'Check of you''d like to re-send the confirmation message.', 'script'),
(NULL, 440, 'pjField', 1, 'title', 'Allow users to add properties', 'script'),
(NULL, 441, 'pjField', 1, 'title', 'Currency', 'script'),
(NULL, 442, 'pjField', 1, 'title', 'Date format', 'script'),
(NULL, 443, 'pjField', 1, 'title', 'Floor metrics', 'script'),
(NULL, 444, 'pjField', 1, 'title', 'User account confirmed by default', 'script'),
(NULL, 445, 'pjField', 1, 'title', 'Select layout', 'script'),
(NULL, 446, 'pjField', 1, 'title', 'Featured properties', 'script'),
(NULL, 447, 'pjField', 1, 'title', 'Enter web address for the web page where property listing is put:', 'script'),
(NULL, 448, 'pjField', 1, 'title', 'Paypal address', 'script'),
(NULL, 449, 'pjField', 1, 'title', 'Items per page', 'script'),
(NULL, 450, 'pjField', 1, 'title', 'Use SEO Friendly URLs', 'script'),
(NULL, 451, 'pjField', 1, 'title', 'Timezone', 'script'),
(NULL, 452, 'pjField', 1, 'title', 'First day of the week', 'script'),
(NULL, 453, 'pjField', 1, 'title', 'Property features', 'script'),
(NULL, 454, 'pjField', 1, 'title', 'Community features', 'script'),
(NULL, 455, 'pjField', 1, 'title', 'Active', 'script'),
(NULL, 456, 'pjField', 1, 'title', 'Inactive', 'script'),
(NULL, 457, 'pjField', 1, 'title', 'Active', 'script'),
(NULL, 458, 'pjField', 1, 'title', 'Inactive', 'script'),
(NULL, 459, 'pjField', 1, 'title', 'Featured', 'script'),
(NULL, 460, 'pjField', 1, 'title', 'Not featured', 'script'),
(NULL, 461, 'pjField', 1, 'title', 'Confirmed', 'script'),
(NULL, 462, 'pjField', 1, 'title', 'Pending', 'script'),
(NULL, 463, 'pjField', 1, 'title', 'Cancelled', 'script'),
(NULL, 464, 'pjField', 1, 'title', 'PayPal', 'script'),
(NULL, 465, 'pjField', 1, 'title', 'Authorize.NET', 'script'),
(NULL, 466, 'pjField', 1, 'title', 'Credit Card', 'script'),
(NULL, 467, 'pjField', 1, 'title', 'Visa', 'script'),
(NULL, 468, 'pjField', 1, 'title', 'MasterCard', 'script'),
(NULL, 469, 'pjField', 1, 'title', 'Maestro', 'script'),
(NULL, 470, 'pjField', 1, 'title', 'AmericanExpress', 'script'),
(NULL, 471, 'pjField', 1, 'title', 'Yes', 'script'),
(NULL, 472, 'pjField', 1, 'title', 'No', 'script'),
(NULL, 473, 'pjField', 1, 'title', 'Yes', 'script'),
(NULL, 474, 'pjField', 1, 'title', 'No', 'script'),
(NULL, 475, 'pjField', 1, 'title', 'Based on expiration date', 'script'),
(NULL, 476, 'pjField', 1, 'title', 'Mr.', 'script'),
(NULL, 477, 'pjField', 1, 'title', 'Mrs.', 'script'),
(NULL, 478, 'pjField', 1, 'title', 'Miss', 'script'),
(NULL, 479, 'pjField', 1, 'title', 'Ms.', 'script'),
(NULL, 480, 'pjField', 1, 'title', 'Dr.', 'script'),
(NULL, 481, 'pjField', 1, 'title', 'Prof.', 'script'),
(NULL, 482, 'pjField', 1, 'title', 'Rev.', 'script'),
(NULL, 483, 'pjField', 1, 'title', 'Other', 'script'),
(NULL, 484, 'pjField', 1, 'title', 'days', 'script'),
(NULL, 485, 'pjField', 1, 'title', 'nights', 'script'),
(NULL, 486, 'pjField', 1, 'title', 'Confirmed', 'script'),
(NULL, 487, 'pjField', 1, 'title', 'Pending', 'script'),
(NULL, 488, 'pjField', 1, 'title', 'Cancelled', 'script'),
(NULL, 496, 'pjField', 1, 'title', 'GMT-12:00', 'script'),
(NULL, 497, 'pjField', 1, 'title', 'GMT-11:00', 'script'),
(NULL, 498, 'pjField', 1, 'title', 'GMT-10:00', 'script'),
(NULL, 499, 'pjField', 1, 'title', 'GMT-09:00', 'script'),
(NULL, 500, 'pjField', 1, 'title', 'GMT-08:00', 'script'),
(NULL, 501, 'pjField', 1, 'title', 'GMT-07:00', 'script'),
(NULL, 502, 'pjField', 1, 'title', 'GMT-06:00', 'script'),
(NULL, 503, 'pjField', 1, 'title', 'GMT-05:00', 'script'),
(NULL, 504, 'pjField', 1, 'title', 'GMT-04:00', 'script'),
(NULL, 505, 'pjField', 1, 'title', 'GMT-03:00', 'script'),
(NULL, 506, 'pjField', 1, 'title', 'GMT-02:00', 'script'),
(NULL, 507, 'pjField', 1, 'title', 'GMT-01:00', 'script'),
(NULL, 508, 'pjField', 1, 'title', 'GMT', 'script'),
(NULL, 509, 'pjField', 1, 'title', 'GMT+01:00', 'script'),
(NULL, 510, 'pjField', 1, 'title', 'GMT+02:00', 'script'),
(NULL, 511, 'pjField', 1, 'title', 'GMT+03:00', 'script'),
(NULL, 512, 'pjField', 1, 'title', 'GMT+04:00', 'script'),
(NULL, 513, 'pjField', 1, 'title', 'GMT+05:00', 'script'),
(NULL, 514, 'pjField', 1, 'title', 'GMT+06:00', 'script'),
(NULL, 515, 'pjField', 1, 'title', 'GMT+07:00', 'script'),
(NULL, 516, 'pjField', 1, 'title', 'GMT+08:00', 'script'),
(NULL, 517, 'pjField', 1, 'title', 'GMT+09:00', 'script'),
(NULL, 518, 'pjField', 1, 'title', 'GMT+10:00', 'script'),
(NULL, 519, 'pjField', 1, 'title', 'GMT+11:00', 'script'),
(NULL, 520, 'pjField', 1, 'title', 'GMT+12:00', 'script'),
(NULL, 521, 'pjField', 1, 'title', 'GMT+13:00', 'script'),
(NULL, 522, 'pjField', 1, 'title', 'Country Updated', 'script'),
(NULL, 523, 'pjField', 1, 'title', 'Country Added', 'script'),
(NULL, 524, 'pjField', 1, 'title', 'Error: Failed to add country.', 'script'),
(NULL, 525, 'pjField', 1, 'title', 'Country not found.', 'script'),
(NULL, 526, 'pjField', 1, 'title', 'Extra Updated', 'script'),
(NULL, 527, 'pjField', 1, 'title', 'Extra Added', 'script'),
(NULL, 528, 'pjField', 1, 'title', 'Error: Failed to add extra.', 'script'),
(NULL, 529, 'pjField', 1, 'title', 'Extra not found.', 'script'),
(NULL, 530, 'pjField', 1, 'title', 'Property Type Updated', 'script'),
(NULL, 531, 'pjField', 1, 'title', 'Property Type Added', 'script'),
(NULL, 532, 'pjField', 1, 'title', 'Error: Failed to create type.', 'script'),
(NULL, 533, 'pjField', 1, 'title', 'Type not found.', 'script'),
(NULL, 534, 'pjField', 1, 'title', 'Reservation Updated', 'script'),
(NULL, 535, 'pjField', 1, 'title', 'Reservation Added', 'script'),
(NULL, 536, 'pjField', 1, 'title', 'Error: Failed to add reservation.', 'script'),
(NULL, 537, 'pjField', 1, 'title', 'Reservation not found.', 'script'),
(NULL, 538, 'pjField', 1, 'title', 'Associate property not found.', 'script'),
(NULL, 539, 'pjField', 1, 'title', 'Associate property forbidden.', 'script'),
(NULL, 540, 'pjField', 1, 'title', 'User Updated', 'script'),
(NULL, 541, 'pjField', 1, 'title', 'User Added', 'script'),
(NULL, 542, 'pjField', 1, 'title', 'Error: Failed to create user.', 'script'),
(NULL, 543, 'pjField', 1, 'title', 'User not found.', 'script'),
(NULL, 544, 'pjField', 1, 'title', 'Options Tab Updated', 'script'),
(NULL, 545, 'pjField', 1, 'title', 'Submissions Tab Updated', 'script'),
(NULL, 546, 'pjField', 1, 'title', 'Installation Settings Updated', 'script'),
(NULL, 547, 'pjField', 1, 'title', 'Property Updated', 'script'),
(NULL, 548, 'pjField', 1, 'title', 'Error Occured', 'script'),
(NULL, 549, 'pjField', 1, 'title', 'Error Occured', 'script'),
(NULL, 550, 'pjField', 1, 'title', 'System Notice', 'script'),
(NULL, 551, 'pjField', 1, 'title', 'Titles Updated', 'script'),
(NULL, 552, 'pjField', 1, 'title', 'Backup', 'script'),
(NULL, 553, 'pjField', 1, 'title', 'Backup Completed', 'script'),
(NULL, 554, 'pjField', 1, 'title', 'Error: Backup Failed', 'script'),
(NULL, 555, 'pjField', 1, 'title', 'Error: Backup Failed', 'script'),
(NULL, 556, 'pjField', 1, 'title', 'Account not found.', 'script'),
(NULL, 557, 'pjField', 1, 'title', 'Password Sent', 'script'),
(NULL, 558, 'pjField', 1, 'title', 'Password has not been sent.', 'script'),
(NULL, 559, 'pjField', 1, 'title', 'Profile Updated.', 'script'),
(NULL, 560, 'pjField', 1, 'title', 'Your changes to the country have been saved.', 'script'),
(NULL, 561, 'pjField', 1, 'title', 'New country has been added to the list.', 'script'),
(NULL, 562, 'pjField', 1, 'title', 'An error occurred! Data has not been saved.', 'script'),
(NULL, 563, 'pjField', 1, 'title', 'Oops! The country you are looking for is missing.', 'script'),
(NULL, 564, 'pjField', 1, 'title', 'Your changes to the entry has been saved.', 'script'),
(NULL, 565, 'pjField', 1, 'title', 'New extra has been added to the list.', 'script'),
(NULL, 566, 'pjField', 1, 'title', 'An error occurred! Data has not been saved.', 'script'),
(NULL, 567, 'pjField', 1, 'title', 'Oops! The extra you are looking for is missing.', 'script'),
(NULL, 568, 'pjField', 1, 'title', 'Your changes to the property type have been saved.', 'script'),
(NULL, 569, 'pjField', 1, 'title', 'New property type has been added to the list.', 'script'),
(NULL, 570, 'pjField', 1, 'title', 'An error occurred! Property type has not been added.', 'script'),
(NULL, 571, 'pjField', 1, 'title', 'Oops! The type you are looking for is missing.', 'script'),
(NULL, 572, 'pjField', 1, 'title', 'All changes made to the reservation have been saved.', 'script'),
(NULL, 573, 'pjField', 1, 'title', 'Your reservation has been added.', 'script'),
(NULL, 574, 'pjField', 1, 'title', 'An error occurred! Reservation has not been added.', 'script'),
(NULL, 575, 'pjField', 1, 'title', 'Oops! The reservation you are looking for is missing.', 'script'),
(NULL, 576, 'pjField', 1, 'title', 'The property for this reservation has not been found.', 'script'),
(NULL, 577, 'pjField', 1, 'title', 'The property belongs to somebody else.', 'script'),
(NULL, 578, 'pjField', 1, 'title', 'Your changes to the user have been saved.', 'script'),
(NULL, 579, 'pjField', 1, 'title', 'New user has been added.', 'script'),
(NULL, 580, 'pjField', 1, 'title', 'An error occurred! New user has not been added.', 'script'),
(NULL, 581, 'pjField', 1, 'title', 'Oops! The user you are looking for is missing.', 'script'),
(NULL, 582, 'pjField', 1, 'title', 'Your preferences have been saved.', 'script'),
(NULL, 583, 'pjField', 1, 'title', 'Your submissions preferences have been saved.', 'script'),
(NULL, 584, 'pjField', 1, 'title', 'Your configuration settings have been saved.', 'script'),
(NULL, 585, 'pjField', 1, 'title', 'Your changes to the property listing have been saved.', 'script'),
(NULL, 586, 'pjField', 1, 'title', 'Property not found.', 'script'),
(NULL, 587, 'pjField', 1, 'title', 'You have no permision to edit this property.', 'script'),
(NULL, 588, 'pjField', 1, 'title', 'Your plan has been extended.', 'script'),
(NULL, 589, 'pjField', 1, 'title', 'All changes to the titles have been saved.', 'script'),
(NULL, 590, 'pjField', 1, 'title', 'We recommend you to regularly back up your database and files to prevent any loss of information.', 'script'),
(NULL, 591, 'pjField', 1, 'title', 'All backup files have been saved.', 'script'),
(NULL, 592, 'pjField', 1, 'title', 'No option was selected.', 'script'),
(NULL, 593, 'pjField', 1, 'title', 'Backup has not being performed.', 'script'),
(NULL, 594, 'pjField', 1, 'title', 'Given email address is not associated with any account.', 'script'),
(NULL, 595, 'pjField', 1, 'title', 'For further instructions please check your mailbox.', 'script'),
(NULL, 596, 'pjField', 1, 'title', 'We''re sorry, please try again later.', 'script'),
(NULL, 597, 'pjField', 1, 'title', 'All changes made to your profile have been saved.', 'script'),
(NULL, 598, 'pjField', 1, 'title', 'sq.m.', 'script'),
(NULL, 599, 'pjField', 1, 'title', 'sq.f.', 'script'),
(NULL, 600, 'pjField', 1, 'title', 'Your request has been sent successfully. Thank you.', 'script'),
(NULL, 601, 'pjField', 1, 'title', 'Your request has not been sent successfully. Please try again.', 'script'),
(NULL, 602, 'pjField', 1, 'title', 'Selected period is not available.', 'script'),
(NULL, 603, 'pjField', 1, 'title', 'Verification code is invalid. Please try again.', 'script'),
(NULL, 604, 'pjField', 1, 'title', 'Invalid dates. Please try again.', 'script'),
(NULL, 605, 'pjField', 1, 'title', 'Invalid date range. Please check your dates.', 'script'),
(NULL, 606, 'pjField', 1, 'title', 'Date range in the past is not allowed.', 'script'),
(NULL, 607, 'pjField', 1, 'title', 'Min booking length is %u %s', 'script'),
(NULL, 608, 'pjField', 1, 'title', 'Max booking length is %u %s', 'script'),
(NULL, 609, 'pjField', 1, 'title', 'Please wait while you are being redirected to secure payment gateway to complete the payment. ', 'script'),
(NULL, 610, 'pjField', 1, 'title', 'Name is required.', 'script'),
(NULL, 611, 'pjField', 1, 'title', 'E-Mail is required.', 'script'),
(NULL, 612, 'pjField', 1, 'title', 'E-Mail is invalid.', 'script'),
(NULL, 613, 'pjField', 1, 'title', 'Payment method is required.', 'script'),
(NULL, 614, 'pjField', 1, 'title', 'Verification is required.', 'script'),
(NULL, 615, 'pjField', 1, 'title', 'Please note that:', 'script'),
(NULL, 616, 'pjField', 1, 'title', 'E-Mail is required.', 'script'),
(NULL, 617, 'pjField', 1, 'title', 'E-Mail is invalid.', 'script'),
(NULL, 618, 'pjField', 1, 'title', 'Password is required.', 'script'),
(NULL, 619, 'pjField', 1, 'title', 'Please note that:', 'script'),
(NULL, 620, 'pjField', 1, 'title', 'Password is required.', 'script'),
(NULL, 621, 'pjField', 1, 'title', 'Password confirmation field is required.', 'script'),
(NULL, 622, 'pjField', 1, 'title', 'Password does not match the confirm password.', 'script'),
(NULL, 623, 'pjField', 1, 'title', 'Name is required.', 'script'),
(NULL, 624, 'pjField', 1, 'title', 'E-Mail is required.', 'script'),
(NULL, 625, 'pjField', 1, 'title', 'E-Mail is invalid.', 'script'),
(NULL, 626, 'pjField', 1, 'title', 'Please note that:', 'script'),
(NULL, 627, 'pjField', 1, 'title', 'January', 'script'),
(NULL, 628, 'pjField', 1, 'title', 'February', 'script'),
(NULL, 629, 'pjField', 1, 'title', 'March', 'script'),
(NULL, 630, 'pjField', 1, 'title', 'April', 'script'),
(NULL, 631, 'pjField', 1, 'title', 'May', 'script'),
(NULL, 632, 'pjField', 1, 'title', 'June', 'script'),
(NULL, 633, 'pjField', 1, 'title', 'July', 'script'),
(NULL, 634, 'pjField', 1, 'title', 'August', 'script'),
(NULL, 635, 'pjField', 1, 'title', 'September', 'script'),
(NULL, 636, 'pjField', 1, 'title', 'October', 'script'),
(NULL, 637, 'pjField', 1, 'title', 'November', 'script'),
(NULL, 638, 'pjField', 1, 'title', 'December', 'script'),
(NULL, 639, 'pjField', 1, 'title', 'Sunday', 'script'),
(NULL, 640, 'pjField', 1, 'title', 'Monday', 'script'),
(NULL, 641, 'pjField', 1, 'title', 'Tuesday', 'script'),
(NULL, 642, 'pjField', 1, 'title', 'Wednesday', 'script'),
(NULL, 643, 'pjField', 1, 'title', 'Thursday', 'script'),
(NULL, 644, 'pjField', 1, 'title', 'Friday', 'script'),
(NULL, 645, 'pjField', 1, 'title', 'Saturday', 'script'),
(NULL, 646, 'pjField', 1, 'title', 'S', 'script'),
(NULL, 647, 'pjField', 1, 'title', 'M', 'script'),
(NULL, 648, 'pjField', 1, 'title', 'T', 'script'),
(NULL, 649, 'pjField', 1, 'title', 'W', 'script'),
(NULL, 650, 'pjField', 1, 'title', 'T', 'script'),
(NULL, 651, 'pjField', 1, 'title', 'F', 'script'),
(NULL, 652, 'pjField', 1, 'title', 'S', 'script'),
(NULL, 653, 'pjField', 1, 'title', 'Jan', 'script'),
(NULL, 654, 'pjField', 1, 'title', 'Feb', 'script'),
(NULL, 655, 'pjField', 1, 'title', 'Mar', 'script'),
(NULL, 656, 'pjField', 1, 'title', 'Apr', 'script'),
(NULL, 657, 'pjField', 1, 'title', 'May', 'script'),
(NULL, 658, 'pjField', 1, 'title', 'Jun', 'script'),
(NULL, 659, 'pjField', 1, 'title', 'Jul', 'script'),
(NULL, 660, 'pjField', 1, 'title', 'Aug', 'script'),
(NULL, 661, 'pjField', 1, 'title', 'Sep', 'script'),
(NULL, 662, 'pjField', 1, 'title', 'Oct', 'script'),
(NULL, 663, 'pjField', 1, 'title', 'Nov', 'script'),
(NULL, 664, 'pjField', 1, 'title', 'Dec', 'script'),
(NULL, 665, 'pjField', 1, 'title', 'You are not logged in.', 'script'),
(NULL, 666, 'pjField', 1, 'title', 'Access denied. You have not requisite rights to access this area.', 'script'),
(NULL, 667, 'pjField', 1, 'title', 'Empty resultset.', 'script'),
(NULL, 668, 'pjField', 1, 'title', 'The operation is not allowed in demo mode.', 'script'),
(NULL, 669, 'pjField', 1, 'title', 'Your hosting account does not allow uploading such a large image.', 'script'),
(NULL, 670, 'pjField', 1, 'title', 'You have no permision to edit this property.', 'script'),
(NULL, 671, 'pjField', 1, 'title', 'You have no permision to edit this reservation.', 'script'),
(NULL, 672, 'pjField', 1, 'title', 'No reservation found.', 'script'),
(NULL, 673, 'pjField', 1, 'title', 'No property for the reservation found.', 'script'),
(NULL, 674, 'pjField', 1, 'title', 'Registration Successful', 'script'),
(NULL, 675, 'pjField', 1, 'title', 'Your registration has been successful. Your account needs to be approved first.', 'script'),
(NULL, 676, 'pjField', 1, 'title', 'This e-mail address already exists in the system.', 'script'),
(NULL, 677, 'pjField', 1, 'title', 'Wrong username or password.', 'script'),
(NULL, 678, 'pjField', 1, 'title', 'Access denied', 'script'),
(NULL, 679, 'pjField', 1, 'title', 'Account is disabled', 'script'),
(NULL, 680, 'pjField', 1, 'title', 'Invalid data', 'script'),
(NULL, 910, 'pjField', 1, 'title', 'Back', 'script'),
(NULL, 911, 'pjField', 1, 'title', 'Bank account', 'script'),
(NULL, 912, 'pjField', 1, 'title', 'Security deposit', 'script'),
(NULL, 913, 'pjField', 1, 'title', 'Tax payment', 'script'),
(NULL, 914, 'pjField', 1, 'title', 'Deposit payment', 'script'),
(NULL, 915, 'pjField', 1, 'title', 'property', 'script'),
(NULL, 916, 'pjField', 1, 'title', 'reservation', 'script'),
(NULL, 917, 'pjField', 1, 'title', 'user', 'script'),
(NULL, 919, 'pjField', 1, 'title', 'Night', 'script'),
(NULL, 961, 'pjField', 1, 'title', 'Address not found', 'script'),
(NULL, 962, 'pjField', 1, 'title', 'Expiration date +30 days', 'script'),
(NULL, 963, 'pjField', 1, 'title', 'View reservations', 'script'),
(NULL, 964, 'pjField', 1, 'title', 'Image', 'script'),
(NULL, 965, 'pjField', 1, 'title', 'Ref ID', 'script'),
(NULL, 966, 'pjField', 1, 'title', 'Owner', 'script'),
(NULL, 967, 'pjField', 1, 'title', 'Expire', 'script'),
(NULL, 968, 'pjField', 1, 'title', 'Publish', 'script'),
(NULL, 969, 'pjField', 1, 'title', 'Active', 'script'),
(NULL, 970, 'pjField', 1, 'title', 'Inactive', 'script'),
(NULL, 971, 'pjField', 1, 'title', 'Exp.date', 'script'),
(NULL, 972, 'pjField', 1, 'title', 'Delete selected', 'script'),
(NULL, 973, 'pjField', 1, 'title', 'Published', 'script'),
(NULL, 974, 'pjField', 1, 'title', 'Not published', 'script'),
(NULL, 975, 'pjField', 1, 'title', 'Extend expiration date', 'script'),
(NULL, 976, 'pjField', 1, 'title', 'Are you sure you want to delete selected property(s)?', 'script'),
(NULL, 979, 'pjField', 1, 'title', 'Are you sure you want to delete selected entry(s)?', 'script'),
(NULL, 980, 'pjField', 1, 'title', 'Property', 'script'),
(NULL, 981, 'pjField', 1, 'title', 'Community', 'script'),
(NULL, 986, 'pjField', 1, 'title', 'Delete', 'script'),
(NULL, 987, 'pjField', 1, 'title', 'Date from', 'script'),
(NULL, 988, 'pjField', 1, 'title', 'Date to', 'script'),
(NULL, 989, 'pjField', 1, 'title', 'Listing', 'script'),
(NULL, 990, 'pjField', 1, 'title', 'Continue', 'script'),
(NULL, 992, 'pjField', 1, 'title', 'Email address is already in use.', 'script'),
(NULL, 993, 'pjField', 1, 'title', 'Revert status', 'script'),
(NULL, 994, 'pjField', 1, 'title', 'Export', 'script'),
(NULL, 995, 'pjField', 1, 'title', 'Oops! Failed to update user.', 'script'),
(NULL, 996, 'pjField', 1, 'title', 'An error occurred when trying to update user.', 'script'),
(NULL, 997, 'pjField', 1, 'title', 'Oops! Failed to update property.', 'script'),
(NULL, 998, 'pjField', 1, 'title', 'An error occurred when trying to update property.', 'script'),
(NULL, 999, 'pjField', 1, 'title', 'Oops! Failed to update reservation.', 'script'),
(NULL, 1000, 'pjField', 1, 'title', 'An error occurred when trying to update reservation.', 'script'),
(NULL, 1001, 'pjField', 1, 'title', 'Oops! Failed to update user profile.', 'script'),
(NULL, 1002, 'pjField', 1, 'title', ' An error occurred when trying to update user profile.', 'script'),
(NULL, 1003, 'pjField', 1, 'title', 'SEO', 'script'),
(NULL, 1004, 'pjField', 1, 'title', 'Meta title', 'script'),
(NULL, 1005, 'pjField', 1, 'title', 'Meta keywords', 'script'),
(NULL, 1006, 'pjField', 1, 'title', 'Meta description', 'script'),
(NULL, 1007, 'pjField', 1, 'title', 'Step 2a (Optional). Copy and paste the code below inside the &lt;head&gt; part of your page, where the meta tags will be printed.', 'script'),
(NULL, 1008, 'pjField', 1, 'title', 'You can create different periods for the properties to be posted on your website. Set different price for each period or 0 if you want to add a free period.', 'script'),
(NULL, 1009, 'pjField', 1, 'title', 'Click on the button to find address coordinates. You can also enter long/lat coordinates for your property.', 'script'),
(NULL, 1010, 'pjField', 1, 'title', 'Photos', 'script'),
(NULL, 1011, 'pjField', 1, 'title', 'Upload as many images as you want for this property. You can resize, crop, rotate, watermark and complress the uploaded images. Drag & drop to change their order.', 'script'),
(NULL, 1066, 'pjField', 1, 'title', 'New user registration', 'script'),
(NULL, 1067, 'pjField', 1, 'title', 'New property added', 'script'),
(NULL, 1068, 'pjField', 1, 'title', 'New reservation - all properties', 'script'),
(NULL, 1069, 'pjField', 1, 'title', 'New reservation - my properties', 'script'),
(NULL, 1070, 'pjField', 1, 'title', 'Reservation cancelled - all properties', 'script'),
(NULL, 1071, 'pjField', 1, 'title', 'Reservation cancelled - my properties', 'script'),
(NULL, 1072, 'pjField', 1, 'title', 'Email notifications', 'script'),
(NULL, 1073, 'pjField', 1, 'title', 'Sms notifications', 'script'),
(NULL, 1074, 'pjField', 1, 'title', 'Notifications', 'script'),
(NULL, 1075, 'pjField', 1, 'title', 'New user registration', 'script'),
(NULL, 1076, 'pjField', 1, 'title', 'New property added', 'script'),
(NULL, 1077, 'pjField', 1, 'title', 'New reservation received', 'script'),
(NULL, 1078, 'pjField', 1, 'title', 'Reservation cancelled', 'script'),
(NULL, 1079, 'pjField', 1, 'title', 'Emails', 'script'),
(NULL, 1080, 'pjField', 1, 'title', 'Sms', 'script'),
(NULL, 1081, 'pjField', 1, 'title', 'Your preferences have been saved.', 'script'),
(NULL, 1082, 'pjField', 1, 'title', 'Notifications Tab Updated', 'script'),
(NULL, 1083, 'pjField', 1, 'title', 'Email notifications', 'script'),
(NULL, 1084, 'pjField', 1, 'title', 'Sms notifications', 'script'),
(NULL, 1085, 'pjField', 1, 'title', 'Different email notifications will be sent when various events happen. You can edit each of the Users and set which emails to receive.', 'script'),
(NULL, 1086, 'pjField', 1, 'title', 'Different SMS notifications will be sent when various events happen. You can edit each of the Users and set which SMS messages to receive. Under SMS tab you need to input your API key for our SMS gateway.', 'script'),
(NULL, 1087, 'pjField', 1, 'title', 'Phone', 'script'),
(NULL, 1088, 'pjField', 1, 'title', 'Vacation Rentals', 'script'),
(NULL, 1089, 'pjField', 1, 'title', 'Vacation Rentals', 'script'),
(NULL, 1090, 'pjField', 1, 'title', 'Subject', 'script'),
(NULL, 1092, 'pjField', 1, 'title', 'Send email', 'script'),
(NULL, 1093, 'pjField', 1, 'title', 'SMTP Host', 'script'),
(NULL, 1094, 'pjField', 1, 'title', 'SMTP Port', 'script');
INSERT INTO `vacationrentals_multi_lang` (`id`, `foreign_id`, `model`, `locale`, `field`, `content`, `source`) VALUES
(NULL, 1095, 'pjField', 1, 'title', 'SMTP Username', 'script'),
(NULL, 1096, 'pjField', 1, 'title', 'SMTP Password', 'script'),
(NULL, 1097, 'pjField', 1, 'title', 'Featured properties', 'script'),
(NULL, 1098, 'pjField', 1, 'title', 'Missing or empty parameters.', 'script'),
(NULL, 1099, 'pjField', 1, 'title', 'Bank account', 'script'),
(NULL, 1154, 'pjField', 1, 'title', 'Select the email notifications to be sent to this user.', 'script'),
(NULL, 1155, 'pjField', 1, 'title', 'Select the SMS notifications to be sent to this user.', 'script'),
(NULL, 1156, 'pjField', 1, 'title', 'Body\r\n<br />\r\n<br />Available tokens:\r\n<br />{Name}\r\n<br />{Email}', 'script'),
(NULL, 1157, 'pjField', 1, 'title', 'Body\r\n<br />\r\n<br />Available tokens:\r\n<br />{PropertyID}\r\n<br />{RefID}', 'script'),
(NULL, 1158, 'pjField', 1, 'title', 'Body\r\n<br />\r\n<br />Available tokens:\r\n<br />{ReservationID}', 'script'),
(NULL, 1159, 'pjField', 1, 'title', 'Reservation Terms and Confirmation emails', 'script'),
(NULL, 1160, 'pjField', 1, 'title', 'Email notifications will be sent to people who make a reservation after reservation form is completed or/and payment is made. Suppored tokens to be used in the email are: {Name} - customer''s name; {Email} - customer''s e-mail; {Phone} - phone number; {Notes} - additional notes; {CCType} - CC type; {CCNum} - CC number; {CCExp} - CC exp. date; {CCSec} - CC security code; {PaymentMethod} - payment method; {StartDate} - start date;{EndDate} - end date; {Price} - price; {Deposit} - deposit; {Security} - security amount; {Tax} - tax; {Total} - total price; {ListingID} - property ID; {ListingRefID} - property ref.ID; {ReservationID} - reservation ID; {ReservationUUID} - reservation unique ID', 'script'),
(NULL, 1161, 'pjField', 1, 'title', 'Enter terms and conditions policy for making a reservation.', 'script'),
(NULL, 1162, 'pjField', 1, 'title', 'State', 'script'),
(NULL, 1163, 'pjField', 1, 'title', 'Property display order', 'script'),
(NULL, 1164, 'pjField', 1, 'title', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam arcu odio, posuere ac hendrerit eu, cursus sed nisl. Mauris velit dolor, congue vel facilisis ac, consequat a mauris. Cras sollicitudin arcu odio. Morbi eu est a ipsum rhoncus elementum nec eu erat.', 'script'),
(NULL, 1165, 'pjField', 1, 'title', 'Amount', 'script'),
(NULL, 1166, 'pjField', 1, 'title', 'Percent', 'script'),
(NULL, 1167, 'pjField', 1, 'title', 'Valid CC Security code is required', 'script'),
(NULL, 1168, 'pjField', 1, 'title', 'Valid CC Number is required', 'script'),
(NULL, 1169, 'pjField', 1, 'title', 'CC Security code is required', 'script'),
(NULL, 1170, 'pjField', 1, 'title', 'CC Number is required', 'script'),
(NULL, 1171, 'pjField', 1, 'title', 'Valid CC Expiration date is required', 'script'),
(NULL, 1172, 'pjField', 1, 'title', 'CC Expiration date is required', 'script'),
(NULL, 1173, 'pjField', 1, 'title', 'Valid CC Type is required', 'script'),
(NULL, 1174, 'pjField', 1, 'title', 'CC Type is required', 'script'),
(NULL, 1175, 'pjField', 1, 'title', 'Password reminder', 'script'),
(NULL, 1176, 'pjField', 1, 'title', 'Captcha is required.', 'script'),
(NULL, 1177, 'pjField', 1, 'title', 'Body\r\n<br />\r\n<br />Available tokens:\r\n<br />{Name}\r\n<br />{Email}\r\n<br />{Password}', 'script'),
(NULL, 1216, 'pjField', 1, 'title', 'Email is missing.', 'script'),
(NULL, 1217, 'pjField', 1, 'title', 'Password is missing.', 'script'),
(NULL, 1218, 'pjField', 1, 'title', 'Confirm password is missing.', 'script'),
(NULL, 1219, 'pjField', 1, 'title', 'Name is missing.', 'script'),
(NULL, 1220, 'pjField', 1, 'title', 'Captcha is missing.', 'script'),
(NULL, 1221, 'pjField', 1, 'title', 'Email couldn''t be empty.', 'script'),
(NULL, 1222, 'pjField', 1, 'title', 'Password couldn''t be empty.', 'script'),
(NULL, 1223, 'pjField', 1, 'title', 'Confirm password couldn''t be empty.', 'script'),
(NULL, 1224, 'pjField', 1, 'title', 'Name couldn''t be empty.', 'script'),
(NULL, 1225, 'pjField', 1, 'title', 'Captcha couldn''t be empty.', 'script'),
(NULL, 1226, 'pjField', 1, 'title', 'Captcha couldn''t match.', 'script'),
(NULL, 1227, 'pjField', 1, 'title', 'Email is not valid.', 'script'),
(NULL, 1228, 'pjField', 1, 'title', 'Password and Confirm password doesn''t match.', 'script'),
(NULL, 1229, 'pjField', 1, 'title', 'Date range is not available', 'script'),
(NULL, 1230, 'pjField', 1, 'title', 'Number of days(nights) is out of range.', 'script'),
(NULL, 1231, 'pjField', 1, 'title', 'Price warning', 'script'),
(NULL, 1232, 'pjField', 1, 'title', 'Price''s overlap can lead to unexpected results.', 'script'),
(NULL, 1233, 'pjField', 1, 'title', 'Subject', 'script'),
(NULL, 1234, 'pjField', 1, 'title', 'Search on map', 'script'),
(NULL, 1235, 'pjField', 1, 'title', 'Clear map', 'script'),
(NULL, 1236, 'pjField', 1, 'title', 'This is your Authorize.net MD5 hash value.', 'script'),
(NULL, 1237, 'pjField', 1, 'title', 'Authorize.net MD5 Hash value:', 'script'),
(NULL, 1238, 'pjField', 1, 'title', 'Unique ID', 'script'),
(NULL, 1342, 'pjField', 1, 'title', 'Welcome message', 'script'),
(NULL, 1343, 'pjField', 1, 'title', 'Body\r\n<br />\r\n<br />Available tokens:\r\n<br />{Name}\r\n<br />{Email}\r\n<br />{Password}', 'script'),
(NULL, 1344, 'pjField', 1, 'title', 'City', 'script'),
(NULL, 1345, 'pjField', 1, 'title', 'Map', 'script'),
(NULL, 1346, 'pjField', 1, 'title', 'Selected language stored in', 'script'),
(NULL, 1347, 'pjField', 1, 'title', 'Install config', 'script'),
(NULL, 1348, 'pjField', 1, 'title', 'Select default language:', 'script'),
(NULL, 1349, 'pjField', 1, 'title', 'Language icons', 'script'),
(NULL, 1, 'pjType', 1, 'name', 'House', 'script'),
(NULL, 2, 'pjType', 1, 'name', 'Flat / Apartment', 'script'),
(NULL, 3, 'pjType', 1, 'name', 'Commercial property ', 'script'),
(NULL, 4, 'pjType', 1, 'name', 'Land', 'script'),
(NULL, 5, 'pjType', 1, 'name', 'Other', 'script');

DROP TABLE IF EXISTS `vacationrentals_options`;
CREATE TABLE IF NOT EXISTS `vacationrentals_options` (
  `foreign_id` int(10) unsigned NOT NULL DEFAULT '0',
  `key` varchar(255) NOT NULL DEFAULT '',
  `tab_id` tinyint(3) unsigned DEFAULT NULL,
  `value` text,
  `label` text,
  `type` enum('string','text','int','float','enum') NOT NULL DEFAULT 'string',
  `order` int(10) unsigned DEFAULT NULL,
  `is_visible` tinyint(1) unsigned DEFAULT '1',
  `style` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`foreign_id`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `vacationrentals_options` (`foreign_id`, `key`, `tab_id`, `value`, `label`, `type`, `order`, `is_visible`, `style`) VALUES
(1, 'o_allow_add_property', 2, 'Yes|No::Yes', NULL, 'enum', 1, 1, NULL),
(1, 'o_currency', 1, 'AED|AFN|ALL|AMD|ANG|AOA|ARS|AUD|AWG|AZN|BAM|BBD|BDT|BGN|BHD|BIF|BMD|BND|BOB|BOV|BRL|BSD|BTN|BWP|BYR|BZD|CAD|CDF|CHE|CHF|CHW|CLF|CLP|CNY|COP|COU|CRC|CUC|CUP|CVE|CZK|DJF|DKK|DOP|DZD|EEK|EGP|ERN|ETB|EUR|FJD|FKP|GBP|GEL|GHS|GIP|GMD|GNF|GTQ|GYD|HKD|HNL|HRK|HTG|HUF|IDR|ILS|INR|IQD|IRR|ISK|JMD|JOD|JPY|KES|KGS|KHR|KMF|KPW|KRW|KWD|KYD|KZT|LAK|LBP|LKR|LRD|LSL|LTL|LVL|LYD|MAD|MDL|MGA|MKD|MMK|MNT|MOP|MRO|MUR|MVR|MWK|MXN|MXV|MYR|MZN|NAD|NGN|NIO|NOK|NPR|NZD|OMR|PAB|PEN|PGK|PHP|PKR|PLN|PYG|QAR|RON|RSD|RUB|RWF|SAR|SBD|SCR|SDG|SEK|SGD|SHP|SLL|SOS|SRD|STD|SYP|SZL|THB|TJS|TMT|TND|TOP|TRY|TTD|TWD|TZS|UAH|UGX|USD|USN|USS|UYU|UZS|VEF|VND|VUV|WST|XAF|XAG|XAU|XBA|XBB|XBC|XBD|XCD|XDR|XFU|XOF|XPD|XPF|XPT|XTS|XXX|YER|ZAR|ZMK|ZWL::EUR', NULL, 'enum', 3, 1, NULL),
(1, 'o_date_format', 1, 'd.m.Y|m.d.Y|Y.m.d|j.n.Y|n.j.Y|Y.n.j|d/m/Y|m/d/Y|Y/m/d|j/n/Y|n/j/Y|Y/n/j|d-m-Y|m-d-Y|Y-m-d|j-n-Y|n-j-Y|Y-n-j::d-m-Y', 'd.m.Y (25.09.2012)|m.d.Y (09.25.2012)|Y.m.d (2012.09.25)|j.n.Y (25.9.2012)|n.j.Y (9.25.2012)|Y.n.j (2012.9.25)|d/m/Y (25/09/2012)|m/d/Y (09/25/2012)|Y/m/d (2012/09/25)|j/n/Y (25/9/2012)|n/j/Y (9/25/2012)|Y/n/j (2012/9/25)|d-m-Y (25-09-2012)|m-d-Y (09-25-2012)|Y-m-d (2012-09-25)|j-n-Y (25-9-2012)|n-j-Y (9-25-2012)|Y-n-j (2012-9-25)', 'enum', 8, 1, NULL),
(1, 'o_email_new_property', 3, 'New property with following Ref.ID: {RefID} has been added.', NULL, 'text', 4, 1, NULL),
(1, 'o_email_new_property_subject', 3, 'New property has been added.', NULL, 'string', 3, 1, NULL),
(1, 'o_email_new_reservation', 3, 'New reservation with following ID: {ReservationID} has been received.', NULL, 'text', 6, 1, NULL),
(1, 'o_email_new_reservation_subject', 3, 'New reservation has been received.', NULL, 'string', 5, 1, NULL),
(1, 'o_email_new_user', 3, 'New user named {Name} with email {Email} has been registered.', NULL, 'text', 2, 1, NULL),
(1, 'o_email_new_user_subject', 3, 'New user has been registered.', NULL, 'string', 1, 1, NULL),
(1, 'o_email_reservation_cancelled', 3, 'A reservation with following ID: {ReservationID} has been cancelled.', NULL, 'text', 8, 1, NULL),
(1, 'o_email_reservation_cancelled_subject', 3, 'A reservation has been cancelled.', NULL, 'string', 7, 1, NULL),
(1, 'o_email_password_reminder', 3, 'Dear {Name},\r\n\r\nYour login email is: {Email}\r\nYour password is: {Password}', NULL, 'text', 10, 1, NULL),
(1, 'o_email_password_reminder_subject', 3, 'Password reminder.', NULL, 'string', 9, 1, NULL),
(1, 'o_email_welcome_msg', 3, 'Dear {Name},\r\n\r\nYou have been registered successfully. Now you''re able to submit your vacation properties.', NULL, 'text', 12, 1, NULL),
(1, 'o_email_welcome_msg_subject', 3, 'Welcome message.', NULL, 'string', 11, 1, NULL),
(1, 'o_floor', 1, 'sq.f.|sq.m.::sq.m.', NULL, 'enum', 2, 1, NULL),
(1, 'o_is_active_owner', 2, 'Yes|No::Yes', NULL, 'enum', 2, 1, NULL),
(1, 'o_lang_store', 99, 'url|session::session', 'URL|Session', 'enum', 13, 1, NULL),
(1, 'o_layout', 1, 'layout_1_list|layout_1_grid|layout_2_list|layout_2_grid|layout_3_list::layout_1_list', 'Layout 1 - List|Layout 1 - Grid|Layout 2 - List|Layout 2 - Grid|Layout 3 - List', 'enum', 4, 1, NULL),
(1, 'o_limit_featured_results', 1, '5', NULL, 'int', 7, 1, NULL),
(1, 'o_listing_page', 99, 'http://localhost/SCRIPTS/VacationRental/testpage.php', NULL, 'string', 6, 0, NULL),
(1, 'o_multi_lang', 99, '1|0::1', NULL, 'enum', NULL, 0, NULL),
(1, 'o_paypal_address', 2, 'paypal@domain.com', NULL, 'string', 4, 1, NULL),
(1, 'o_per_page', 1, '10', NULL, 'int', 1, 1, NULL),
(1, 'o_send_email', 1, 'mail|smtp::mail', 'PHP mail()|SMTP', 'enum', 11, 1, NULL),
(1, 'o_seo_url', 99, 'Yes|No::No', NULL, 'enum', 13, 1, NULL),
(1, 'o_sms_new_property', 4, 'New property has been added.', NULL, 'text', 2, 1, NULL),
(1, 'o_sms_new_reservation', 4, 'New reservation has been received.', NULL, 'text', 3, 1, NULL),
(1, 'o_sms_new_user', 4, 'New user has been registered.', NULL, 'text', 1, 1, NULL),
(1, 'o_sms_reservation_cancelled', 4, 'A reservation has been cancelled.', NULL, 'text', 4, 1, NULL),
(1, 'o_smtp_host', 1, NULL, NULL, 'string', 12, 1, NULL),
(1, 'o_smtp_pass', 1, NULL, NULL, 'string', 15, 1, NULL),
(1, 'o_smtp_port', 1, '25', NULL, 'int', 13, 1, NULL),
(1, 'o_smtp_user', 1, NULL, NULL, 'string', 14, 1, NULL),
(1, 'o_sort_by', 1, 'popularity|created_asc|created_desc|random::popularity', 'Popularity|Date added ASC|Date added DESC|Random', 'enum', 16, 1, NULL),
(1, 'o_timezone', 1, '-43200|-39600|-36000|-32400|-28800|-25200|-21600|-18000|-14400|-10800|-7200|-3600|0|3600|7200|10800|14400|18000|21600|25200|28800|32400|36000|39600|43200|46800::7200', 'GMT-12:00|GMT-11:00|GMT-10:00|GMT-09:00|GMT-08:00|GMT-07:00|GMT-06:00|GMT-05:00|GMT-04:00|GMT-03:00|GMT-02:00|GMT-01:00|GMT|GMT+01:00|GMT+02:00|GMT+03:00|GMT+04:00|GMT+05:00|GMT+06:00|GMT+07:00|GMT+08:00|GMT+09:00|GMT+10:00|GMT+11:00|GMT+12:00|GMT+13:00', 'enum', 10, 1, NULL),
(1, 'o_week_start', 1, '0|1|2|3|4|5|6::1', 'Sunday|Monday|Tuesday|Wednesday|Thursday|Friday|Saturday', 'enum', 9, 1, NULL);

DROP TABLE IF EXISTS `vacationrentals_payments`;
CREATE TABLE IF NOT EXISTS `vacationrentals_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `listing_id` int(10) unsigned DEFAULT NULL,
  `txn_id` varchar(255) DEFAULT NULL,
  `processed_on` datetime DEFAULT NULL,
  `date_from` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `price` decimal(9,2) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `vacationrentals_periods`;
CREATE TABLE IF NOT EXISTS `vacationrentals_periods` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `days` smallint(5) unsigned DEFAULT NULL,
  `price` decimal(9,2) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

INSERT INTO `vacationrentals_periods` (`id`, `days`, `price`) VALUES
(1, 10, 49.00),
(2, 20, 79.00),
(3, 30, 99.00),
(4, 40, 109.00),
(5, 50, 119.00);

DROP TABLE IF EXISTS `vacationrentals_prices`;
CREATE TABLE IF NOT EXISTS `vacationrentals_prices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `listing_id` int(10) unsigned NOT NULL,
  `date_from` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `price` decimal(15,2) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `vacationrentals_reservations`;
CREATE TABLE IF NOT EXISTS `vacationrentals_reservations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(12) DEFAULT NULL,
  `listing_id` int(10) unsigned NOT NULL,
  `date_from` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `notes` text,
  `created` datetime DEFAULT NULL,
  `ip` varchar(15) DEFAULT NULL,
  `amount` decimal(9,2) unsigned DEFAULT NULL,
  `deposit` decimal(9,2) unsigned DEFAULT NULL,
  `tax` decimal(7,2) unsigned DEFAULT NULL,
  `security` decimal(7,2) unsigned DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `cc_type` varchar(255) DEFAULT NULL,
  `cc_num` blob,
  `cc_exp` blob,
  `cc_code` blob,
  `txn_id` varchar(255) DEFAULT NULL,
  `processed_on` datetime DEFAULT NULL,
  `status` enum('Confirmed','Pending','Cancelled') DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid` (`uuid`),
  KEY `listing_id` (`listing_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `vacationrentals_roles`;
CREATE TABLE IF NOT EXISTS `vacationrentals_roles` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `role` varchar(255) DEFAULT NULL,
  `status` enum('T','F') NOT NULL DEFAULT 'T',
  PRIMARY KEY (`id`),
  KEY `status` (`status`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

INSERT INTO `vacationrentals_roles` (`id`, `role`, `status`) VALUES
(1, 'admin', 'T'),
(2, 'editor', 'T'),
(3, 'owner', 'T');

DROP TABLE IF EXISTS `vacationrentals_types`;
CREATE TABLE IF NOT EXISTS `vacationrentals_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `status` enum('T','F') NOT NULL DEFAULT 'T',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

INSERT INTO `vacationrentals_types` (`id`, `status`) VALUES
(1, 'T'),
(2, 'T'),
(3, 'T'),
(4, 'T'),
(5, 'T');

DROP TABLE IF EXISTS `vacationrentals_users`;
CREATE TABLE IF NOT EXISTS `vacationrentals_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(10) unsigned NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` blob,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `created` datetime NOT NULL,
  `last_login` datetime DEFAULT NULL,
  `status` enum('T','F') NOT NULL DEFAULT 'T',
  `is_active` enum('T','F') NOT NULL DEFAULT 'F',
  `ip` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `role_id` (`role_id`),
  KEY `status` (`status`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `vacationrentals_users_notifications`;
CREATE TABLE IF NOT EXISTS `vacationrentals_users_notifications` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT NULL,
  `notification_id` tinyint(3) unsigned DEFAULT NULL,
  `type` enum('email','sms') DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`notification_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;