-- http://www.phpmyadmin.net
--




--
-- Database: `dominoestate`
--

-- --------------------------------------------------------

--
-- Table structure for table `amenities`
--

CREATE TABLE `amenities` (
  `amenity_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `icon` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`amenity_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=14 ;

--
-- Dumping data for table `amenities`
--

INSERT INTO `amenities` VALUES(1, 'AC', 'air-conditioner.png');
INSERT INTO `amenities` VALUES(2, 'Balcony', 'balcony.png');
INSERT INTO `amenities` VALUES(3, 'Cable TV', 'cable-tv.png');
INSERT INTO `amenities` VALUES(4, 'Computer', 'computer.png');
INSERT INTO `amenities` VALUES(5, 'Dishwasher', 'dishwasher.png');
INSERT INTO `amenities` VALUES(6, 'Grill', 'grill.png');
INSERT INTO `amenities` VALUES(7, 'Heater', 'heater.png');
INSERT INTO `amenities` VALUES(8, 'Lift', 'lift.png');
INSERT INTO `amenities` VALUES(9, 'Parking', 'car-parking.png');
INSERT INTO `amenities` VALUES(10, 'Pool', 'pool.png');
INSERT INTO `amenities` VALUES(11, 'Smoking', 'smoking.png');
INSERT INTO `amenities` VALUES(12, 'Washing Machine', 'washing-machine.png');
INSERT INTO `amenities` VALUES(13, 'WiFi', 'wi-fi.png');

-- --------------------------------------------------------

--
-- Table structure for table `distance_fields`
--

CREATE TABLE `distance_fields` (
  `distance_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `icon` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`distance_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

--
-- Dumping data for table `distance_fields`
--

INSERT INTO `distance_fields` VALUES(1, 'Bus Stop', '2246-200.png');
INSERT INTO `distance_fields` VALUES(2, 'Gas Station', 'gas-station.png');
INSERT INTO `distance_fields` VALUES(3, 'Hospital', 'hospital.png');
INSERT INTO `distance_fields` VALUES(4, 'Restaurant', 'restaurant.png');
INSERT INTO `distance_fields` VALUES(5, 'Shop', 'shop.png');
INSERT INTO `distance_fields` VALUES(6, 'University', 'university.png');

-- --------------------------------------------------------

--
-- Table structure for table `estate`
--

CREATE TABLE `estate` (
  `estate_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `purpose` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `price` decimal(15,0) DEFAULT NULL,
  `contact_for_price` tinyint(1) NOT NULL DEFAULT '0',
  `rent_price` decimal(15,0) DEFAULT NULL,
  `rent_price_unit` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `total_price` decimal(14,0) NOT NULL,
  `size` decimal(15,0) DEFAULT NULL,
  `size_unit` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bedroom` int(5) DEFAULT NULL,
  `bath` int(5) DEFAULT NULL,
  `year_built` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `country` int(11) DEFAULT NULL,
  `state` int(11) DEFAULT NULL,
  `city` int(11) DEFAULT NULL,
  `zip_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `latitude` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `featured_image` text COLLATE utf8_unicode_ci,
  `gallery` longtext COLLATE utf8_unicode_ci,
  `amenities` longtext COLLATE utf8_unicode_ci,
  `distance_fields` longtext COLLATE utf8_unicode_ci,
  `energy_efficiency` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gas_emission` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `create_time` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `report` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `total_views` int(11) NOT NULL DEFAULT '0',
  `search_meta` longtext COLLATE utf8_unicode_ci,
  `video_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `house_plan` longtext COLLATE utf8_unicode_ci,
  `tags` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`estate_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `estate`
--

INSERT INTO `estate` VALUES(1, 'New BeachFront House', '   Aliquam vel egestas turpis. Proin sollicitudin imperdiet nisi ac rutrum. Sed imperdiet libero malesuada erat cursus eu pulvinar tellus rhoncus. Ut eget tellus neque, faucibus ornare odio. Fusce sagittis hendrerit mi a sollicitudin. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam ullamcorper libero sed ante auctor vel gravida nunc placerat. Suspendisse molestie posuere sem, in viverra dolor venenatis sit amet. Aliquam gravida nibh quis justo pulvinar luctus. Phasellus a malesuada massa. Mauris elementum tempus nisi, vitae ullamcorper sem ultricies vitae. Nullam consectetur lacinia nisi, quis laoreet magna pulvinar in. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. In hac habitasse platea dictumst. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.Morbi eu sapien ac diam facilisis vehicula nec sit amet odio. Vivamus quis dui ac nulla molestie blandit eu in nunc. In justo erat, lacinia in vulputate non, tristique eu mi. Aliquam tristique dapibus tempor. Vivamus malesuada tempor urna, in convallis massa lacinia sed. Phasellus gravida auctor vestibulum. Suspendisse potenti. In tincidunt felis bibendum nunc tempus sagittis. Praesent elit dolor, ultricies interdum porta sit amet, iaculis in neque. Nullam urna ante, tempus vel iaculis nec, rutrum sit amet nulla. Morbi vestibulum ante in turpis ultricies in tincidunt sapien iaculis. Aenean feugiat rhoncus arcu, at luctus libero blandit tempus. Vivamus rutrum tellus quis leo placerat eu adipiscing purus vehicula.', 'house', 'sale', 1300000, 0, 0, 'per_week', 1300000, 8300, 'sqft', 5, 3, '1990', '16 N Norman Ave', 1, 4, 10, '90027', '34.09365364732373', '-118.31992711284181', 'demo1.jpg', '["Your-Perfect-Fantasy-Beach-House-Cotton-House-2-Barbados.jpg","xKillcare_Beach_House_p_living_jpg_pagespeed_ic_8tJZPeXXnH.jpg","stbarts-FAY-Beach-House-19.jpg","BED-ISL-140707_0.jpg","1-Beach-House-qualia-Jason-Loucas-2010-HR-(7).jpg"]', '["1","2","3","5","6","7","9","10","12","13"]', '["{\\"id\\":\\"1\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"2\\",\\"value\\":\\"10\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"3\\",\\"value\\":\\"2\\",\\"units\\":\\"kms\\"}","{\\"id\\":\\"4\\",\\"value\\":\\"30\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"5\\",\\"value\\":\\"1\\",\\"units\\":\\"kms\\"}","{\\"id\\":\\"6\\",\\"value\\":\\"32\\",\\"units\\":\\"kms\\"}"]', '', '', 1, 1509871342, 1, 1, NULL, 0, 'New BeachFront House sale house 16 N Norman Ave USA California  Los Angeles ', 'https://www.youtube.com/watch?v=Is34PPQW3Ag', NULL, 'beach house, hours, new   ');
INSERT INTO `estate` VALUES(3, 'Luxury Condominium for Sale', ' Aliquam vel egestas turpis. Proin sollicitudin imperdiet nisi ac rutrum. Sed imperdiet libero malesuada erat cursus eu pulvinar tellus rhoncus. Ut eget tellus neque, faucibus ornare odio. Fusce sagittis hendrerit mi a sollicitudin. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam ullamcorper libero sed ante auctor vel gravida nunc placerat. Suspendisse molestie posuere sem, in viverra dolor venenatis sit amet. Aliquam gravida nibh quis justo pulvinar luctus. Phasellus a malesuada massa. Mauris elementum tempus nisi, vitae ullamcorper sem ultricies vitae. Nullam consectetur lacinia nisi, quis laoreet magna pulvinar in. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. In hac habitasse platea dictumst. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.Morbi eu sapien ac diam facilisis vehicula nec sit amet odio. Vivamus quis dui ac nulla molestie blandit eu in nunc. In justo erat, lacinia in vulputate non, tristique eu mi. Aliquam tristique dapibus tempor. Vivamus malesuada tempor urna, in convallis massa lacinia sed. Phasellus gravida auctor vestibulum. Suspendisse potenti. In tincidunt felis bibendum nunc tempus sagittis. Praesent elit dolor, ultricies interdum porta sit amet, iaculis in neque. Nullam urna ante, tempus vel iaculis nec, rutrum sit amet nulla. Morbi vestibulum ante in turpis ultricies in tincidunt sapien iaculis. Aenean feugiat rhoncus arcu, at luctus libero blandit tempus. Vivamus rutrum tellus quis leo placerat eu adipiscing purus vehicula.', 'condominium', 'sale', 14000000, 0, 0, 'per_week', 14000000, 9000, 'sqft', 6, 4, '2010', '1475 Mission St', 1, 4, 9, '94103', '37.7742953', '-122.41656039999998', '1-Nirvana-Condominium-Kalim-Phuket-Patong-Condo-for-Sale-Kalim-Beach-Property-Phuket-Emerald-Development-Group-Thailand.jpg', '["Auberge-Beach-Residences-and-Spa-03-LIVING-03-557.jpg","160407-modernapartment-stock.jpg","3-Central-Condo-Phuket-for-Sale-Phuket-Real-Estate-Emerald-Development-Group-Thailand.jpg"]', '["1","2","3","5","7","8","9","12","13"]', '["{\\"id\\":\\"1\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}"]', '', '', 1, 1509874520, 1, 1, NULL, 0, 'Luxury Condominium for Sale sale condominium 1475 Mission St USA California  San Fransisco ', 'https://www.youtube.com/watch?v=Fx2UjQyaWhg', NULL, ' condominium, condo, apartment, pool');
INSERT INTO `estate` VALUES(4, 'Studio Apartment for Rent', '  Aliquam vel egestas turpis. Proin sollicitudin imperdiet nisi ac rutrum. Sed imperdiet libero malesuada erat cursus eu pulvinar tellus rhoncus. Ut eget tellus neque, faucibus ornare odio. Fusce sagittis hendrerit mi a sollicitudin. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam ullamcorper libero sed ante auctor vel gravida nunc placerat. Suspendisse molestie posuere sem, in viverra dolor venenatis sit amet. Aliquam gravida nibh quis justo pulvinar luctus. Phasellus a malesuada massa. Mauris elementum tempus nisi, vitae ullamcorper sem ultricies vitae. Nullam consectetur lacinia nisi, quis laoreet magna pulvinar in. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. In hac habitasse platea dictumst. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.Morbi eu sapien ac diam facilisis vehicula nec sit amet odio. Vivamus quis dui ac nulla molestie blandit eu in nunc. In justo erat, lacinia in vulputate non, tristique eu mi. Aliquam tristique dapibus tempor. Vivamus malesuada tempor urna, in convallis massa lacinia sed. Phasellus gravida auctor vestibulum. Suspendisse potenti. In tincidunt felis bibendum nunc tempus sagittis. Praesent elit dolor, ultricies interdum porta sit amet, iaculis in neque. Nullam urna ante, tempus vel iaculis nec, rutrum sit amet nulla. Morbi vestibulum ante in turpis ultricies in tincidunt sapien iaculis. Aenean feugiat rhoncus arcu, at luctus libero blandit tempus. Vivamus rutrum tellus quis leo placerat eu adipiscing purus vehicula.', 'apartment', 'rent', 0, 0, 3499, 'per_month', 3499, 890, 'sqft', 2, 1, '2005', '408 Almaden Blvd', 1, 4, 13, '95110', '37.3286661', '-121.88975310000001', 'wood-paneling-apartment_(1).jpg', '["wood-paneling-apartment_(1).jpg","yes-its-possible-to-live-well-in-a-studio-apartmentheres-how-1752664-1461975810_640x0c.jpg","The-Madison-at-Racine-Apartments-in-Chicago-2.jpg","","How-To-Decorate-A-Studio-Apartment-9.jpg"]', '["3","4","5","7","8","11","13"]', '["{\\"id\\":\\"1\\",\\"value\\":\\"32\\",\\"units\\":\\"meters\\"}"]', '', '', 1, 1509967529, 1, 1, NULL, 0, 'Studio Apartment for Rent rent apartment 408 Almaden Blvd USA California San Jose ', 'https://www.youtube.com/watch?v=ACzz-G8FUf0', NULL, '  ');
INSERT INTO `estate` VALUES(5, 'Country Side Villa', ' Aliquam vel egestas turpis. Proin sollicitudin imperdiet nisi ac rutrum. Sed imperdiet libero malesuada erat cursus eu pulvinar tellus rhoncus. Ut eget tellus neque, faucibus ornare odio. Fusce sagittis hendrerit mi a sollicitudin. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam ullamcorper libero sed ante auctor vel gravida nunc placerat. Suspendisse molestie posuere sem, in viverra dolor venenatis sit amet. Aliquam gravida nibh quis justo pulvinar luctus. Phasellus a malesuada massa. Mauris elementum tempus nisi, vitae ullamcorper sem ultricies vitae. Nullam consectetur lacinia nisi, quis laoreet magna pulvinar in. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. In hac habitasse platea dictumst. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.Morbi eu sapien ac diam facilisis vehicula nec sit amet odio. Vivamus quis dui ac nulla molestie blandit eu in nunc. In justo erat, lacinia in vulputate non, tristique eu mi. Aliquam tristique dapibus tempor. Vivamus malesuada tempor urna, in convallis massa lacinia sed. Phasellus gravida auctor vestibulum. Suspendisse potenti. In tincidunt felis bibendum nunc tempus sagittis. Praesent elit dolor, ultricies interdum porta sit amet, iaculis in neque. Nullam urna ante, tempus vel iaculis nec, rutrum sit amet nulla. Morbi vestibulum ante in turpis ultricies in tincidunt sapien iaculis. Aenean feugiat rhoncus arcu, at luctus libero blandit tempus. Vivamus rutrum tellus quis leo placerat eu adipiscing purus vehicula.', 'villa', 'sale', 16000000, 0, 0, 'per_week', 16000000, 20000, 'sqft', 9, 6, '1951', '420 Long Beach Blvd', 1, 4, 15, '90807', '33.82211518237268', '-118.21106567211916', 'luxury-countryside-villa-3d-model-max.jpg', '["Italian-Countryside-1_(1).jpg","countryside_villa_spain5.jpg","avalon_170-500x335.jpg","380f63aa-309a-41b7-a81f-debfffe291e9_c10.jpg"]', '["2","3","5","6","7","9","10","11","12","13"]', '["{\\"id\\":\\"1\\",\\"value\\":\\"30\\",\\"units\\":\\"meters\\"}"]', '', '', 1, 1509968063, 1, 1, NULL, 0, 'Country Side Villa sale villa 420 Long Beach Blvd USA California  Long Beach ', 'https://vimeo.com/169414134', NULL, ' ');
INSERT INTO `estate` VALUES(6, 'Beautiful Bay View House for Rent', ' Aliquam vel egestas turpis. Proin sollicitudin imperdiet nisi ac rutrum. Sed imperdiet libero malesuada erat cursus eu pulvinar tellus rhoncus. Ut eget tellus neque, faucibus ornare odio. Fusce sagittis hendrerit mi a sollicitudin. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam ullamcorper libero sed ante auctor vel gravida nunc placerat. Suspendisse molestie posuere sem, in viverra dolor venenatis sit amet. Aliquam gravida nibh quis justo pulvinar luctus. Phasellus a malesuada massa. Mauris elementum tempus nisi, vitae ullamcorper sem ultricies vitae. Nullam consectetur lacinia nisi, quis laoreet magna pulvinar in. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. In hac habitasse platea dictumst. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.Morbi eu sapien ac diam facilisis vehicula nec sit amet odio. Vivamus quis dui ac nulla molestie blandit eu in nunc. In justo erat, lacinia in vulputate non, tristique eu mi. Aliquam tristique dapibus tempor. Vivamus malesuada tempor urna, in convallis massa lacinia sed. Phasellus gravida auctor vestibulum. Suspendisse potenti. In tincidunt felis bibendum nunc tempus sagittis. Praesent elit dolor, ultricies interdum porta sit amet, iaculis in neque. Nullam urna ante, tempus vel iaculis nec, rutrum sit amet nulla. Morbi vestibulum ante in turpis ultricies in tincidunt sapien iaculis. Aenean feugiat rhoncus arcu, at luctus libero blandit tempus. Vivamus rutrum tellus quis leo placerat eu adipiscing purus vehicula.', 'house', 'rent', 0, 0, 988, 'per_week', 988, 4000, 'sqft', 3, 3, '1980', '571 Rexleigh Drive', 1, 4, 14, '59823', '38.417207690118005', '-121.45494584189453', '772.jpg', '["toronto-sale-of-the-week-46-page-avenue-1.jpg","SK100_ZZ00005101_01.jpg","772.jpg","380f63aa-309a-41b7-a81f-debfffe291e9_c101.jpg","7cec06b9e19C42a-81632083.jpg"]', '["1","3","6","7","8","9","12","13"]', '["{\\"id\\":\\"1\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}"]', '', '', 1, 1509968690, 1, 1, NULL, 0, 'Beautiful Bay View House for Rent rent house 571 Rexleigh Drive USA California  Sacramento ', 'https://www.youtube.com/watch?v=5HKkbwVEXIk', NULL, ' ');
INSERT INTO `estate` VALUES(7, 'Luxury Apartment for Sale', ' Aliquam vel egestas turpis. Proin sollicitudin imperdiet nisi ac rutrum. Sed imperdiet libero malesuada erat cursus eu pulvinar tellus rhoncus. Ut eget tellus neque, faucibus ornare odio. Fusce sagittis hendrerit mi a sollicitudin. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam ullamcorper libero sed ante auctor vel gravida nunc placerat. Suspendisse molestie posuere sem, in viverra dolor venenatis sit amet. Aliquam gravida nibh quis justo pulvinar luctus. Phasellus a malesuada massa. Mauris elementum tempus nisi, vitae ullamcorper sem ultricies vitae. Nullam consectetur lacinia nisi, quis laoreet magna pulvinar in. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. In hac habitasse platea dictumst. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.Morbi eu sapien ac diam facilisis vehicula nec sit amet odio. Vivamus quis dui ac nulla molestie blandit eu in nunc. In justo erat, lacinia in vulputate non, tristique eu mi. Aliquam tristique dapibus tempor. Vivamus malesuada tempor urna, in convallis massa lacinia sed. Phasellus gravida auctor vestibulum. Suspendisse potenti. In tincidunt felis bibendum nunc tempus sagittis. Praesent elit dolor, ultricies interdum porta sit amet, iaculis in neque. Nullam urna ante, tempus vel iaculis nec, rutrum sit amet nulla. Morbi vestibulum ante in turpis ultricies in tincidunt sapien iaculis. Aenean feugiat rhoncus arcu, at luctus libero blandit tempus. Vivamus rutrum tellus quis leo placerat eu adipiscing purus vehicula.', 'apartment', 'sale', 3000000, 0, 0, 'per_week', 3000000, 4500, 'sqft', 5, 3, '2001', '548 Market St', 1, 4, 9, '94104', '37.7900286', '-122.40083979999997', 'SmartDesignStudio-TrioApt_2.jpg', '["small-apartment-interior-design-ideas-designforlifeden-for-apartment-interior-design-ideas-colorful-twist-in-white-apartment-interior-design.jpg","The-Madison-at-Racine-Apartments-in-Chicago-21.jpg","yes-its-possible-to-live-well-in-a-studio-apartmentheres-how-1752664-1461975810_640x0c1.jpg","","beautiful-apartment-interior-design-gallery-house-best-emejing-photos-home-decorating-ideas-service-nanjing.jpg"]', '["3","4","5","6","7","8","9","10","12","13"]', '["{\\"id\\":\\"1\\",\\"value\\":\\"2\\",\\"units\\":\\"meters\\"}"]', '', '', 1, 1509969044, 1, 0, NULL, 0, 'Luxury Apartment for Sale sale apartment 548 Market St USA California  San Fransisco ', 'https://www.youtube.com/watch?v=Sf-kSC6JGFo', NULL, ' ');

-- --------------------------------------------------------

--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `phrase_id` int(11) NOT NULL AUTO_INCREMENT,
  `phrase` longtext COLLATE utf8_unicode_ci NOT NULL,
  `english` longtext COLLATE utf8_unicode_ci NOT NULL,
  `spanish` longtext COLLATE utf8_unicode_ci NOT NULL,
  `arabic` longtext COLLATE utf8_unicode_ci NOT NULL,
  `russian` longtext COLLATE utf8_unicode_ci NOT NULL,
  `chinese` longtext COLLATE utf8_unicode_ci NOT NULL,
  `turkish` longtext COLLATE utf8_unicode_ci NOT NULL,
  `portuguese` longtext COLLATE utf8_unicode_ci NOT NULL,
  `french` longtext COLLATE utf8_unicode_ci NOT NULL,
  `german` longtext COLLATE utf8_unicode_ci NOT NULL,
  `italian` longtext COLLATE utf8_unicode_ci NOT NULL,
  `hindi` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`phrase_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=416 ;

--
-- Dumping data for table `language`
--

INSERT INTO `language` VALUES(1, 'dashboard', 'Dashboard', 'Tablero', 'لوحة القيادة', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(2, 'real_estate', 'Real Estate', 'Bienes raíces', 'العقارات', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(3, 'create_estate', 'Create Estate', 'crear y Propiedades', 'إنشاء العقارية', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(4, 'estates', 'Estates', 'Estates', 'عقارات', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(5, 'location', 'Location', 'Ubicación', 'موقعك', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(6, 'amenities', 'Amenities', 'Comodidades', 'وسائل الراحة', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(7, 'distance_fields', 'Distance Fields', 'Los campos distancia', 'ملاعب المسافة', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(8, 'agents', 'Agents', 'agentes', 'عملاء', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(9, 'widgets', 'Widgets', 'Reproductores', 'الحاجيات', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(10, 'all_widgets', 'All Widgets', 'todos los widgets', 'جميع القطع', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(11, 'widget_positions', 'Widget Positions', 'Posiciones Widget', 'المراكز القطعة', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(12, 'pages_&_menu', 'Pages & Menu', 'Páginas y Menú', 'صفحات والقائمة', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(13, 'pages', 'Pages', 'páginas', 'صفحات', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(14, 'new_page', 'New Page', 'Nueva pagina', 'صفحة جديدة', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(15, 'menu', 'Menu', 'Menú', 'قائمة طعام', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(16, 'packages', 'Packages', 'paquetes', 'حزم', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(17, 'purchase_history', 'Purchase History', 'Historial de compras', 'تاريخ شراء', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(18, 'settings', 'Settings', 'ajustes', 'إعدادات', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(19, 'system_settings', 'System Settings', 'Ajustes del sistema', 'اعدادات النظام', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(20, 'language_settings', 'Language Settings', 'Ajustes de idioma', 'اعدادات اللغة', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(21, 'realestate_settings', 'Realestate Settings', 'Ajustes realestate', 'إعدادات عقارات', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(22, 'payment_settings', 'Payment Settings', 'Configuración de pago', 'إعدادات الدفع', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(23, 'sitemap', 'Sitemap', 'Sitemap', 'خريطة الموقع', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(24, 'profile', 'Profile', 'Profile', 'الملف الشخصي', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(25, 'website', 'Website', 'Website', 'موقع الكتروني', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(26, 'logout', 'Logout', 'Logout', 'الخروج', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(27, 'house', 'House', 'House', 'منزل', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(28, 'condominium', 'Condominium', 'Condominium', 'سيادة مشتركة', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(29, 'apartment', 'Apartment', 'Apartment', 'شقة', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(30, 'villa', 'Villa', 'Villa', 'فيلا', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(31, 'registered_agents', 'Registered Agents', 'Registered Agents', 'وكلاء مسجل', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(32, 'properties', 'Properties', 'Properties', 'الخصائص', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(33, 'active_packages', 'Active Packages', 'Active Packages', 'الحزم النشطة', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(34, 'last_30_days', 'Last 30 Days', 'Last 30 Days', 'آخر 30 أيام', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(35, 'delete', 'Delete', 'Delete', 'حذف', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(36, 'cancel', 'Cancel', 'Cancel', 'إلغاء', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(37, 'purchase', 'Purchase', 'Purchase', 'شراء', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(38, 'create_new_estate', 'Create New Estate', 'Create New Estate', 'إنشاء جديد العقارية', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(39, 'home', 'Home', 'Home', 'الصفحة الرئيسية', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(40, 'basic_information', 'Basic Information', 'Basic Information', 'معلومات اساسية', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(41, 'title', 'Title', 'Title', 'عنوان', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(42, 'description', 'Description', 'Description', 'وصف', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(43, 'purpose', 'Purpose', 'Purpose', 'غرض', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(44, 'select_an_option', 'Select An Option', 'Select An Option', 'حدد اختيارا', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(45, 'sale', 'Sale', 'Sale', 'تخفيض السعر', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(46, 'rent', 'Rent', 'Rent', 'تأجير', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(47, 'estate_type', 'Estate Type', 'Estate Type', 'نوع العقار', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(48, 'commercial', 'Commercial', 'Commercial', 'تجاري', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(49, 'building', 'Building', 'Building', 'بناء', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(50, 'land', 'Land', 'Land', 'أرض', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(51, 'price', 'Price', 'Price', 'السعر', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(52, 'rent_price', 'Rent Price', 'Rent Price', 'للإيجار السعر', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(53, 'per_week', 'Per Week', 'Per Week', 'في الاسبوع', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(54, 'per_month', 'Per Month', 'Per Month', 'كل شهر', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(55, 'per_year', 'Per Year', 'Per Year', 'كل سنة', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(56, 'contact_for_price', 'Contact For Price', 'Contact For Price', 'الاتصال عن سعر', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(57, 'no', 'No', 'No', 'لا', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(58, 'yes', 'Yes', 'Yes', 'نعم فعلا', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(59, 'size', 'Size', 'Size', 'بحجم', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(60, 'bedroom', 'Bedroom', 'Bedroom', 'غرفة نوم', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(61, 'bath', 'Bath', 'Bath', 'حمام', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(62, 'year_built', 'Year Built', 'Year Built', 'بنيت عام', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(63, 'agent', 'Agent', 'Agent', 'Agent', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(64, 'address', 'Address', 'Address', 'Address', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(65, 'country', 'Country', 'Country', 'Country', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(66, 'select_a_country', 'Select A Country', 'Select A Country', 'Select A Country', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(67, 'state/province', 'State/province', 'State/province', 'State/province', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(68, 'select_a_state/province', 'Select A State/province', 'Select A State/province', 'Select A State/province', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(69, 'city', 'City', 'City', 'City', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(70, 'select_a_city', 'Select A City', 'Select A City', 'Select A City', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(71, 'zip_code', 'Zip Code', 'Zip Code', 'Zip Code', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(72, 'view_on_map', 'View On Map', 'View On Map', 'View On Map', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(73, 'latitude', 'Latitude', 'Latitude', 'Latitude', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(74, 'longitude', 'Longitude', 'Longitude', 'Longitude', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(75, 'map', 'Map', 'Map', 'Map', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(76, 'distance', 'Distance', 'Distance', 'Distance', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(77, 'image', 'Image', 'Image', 'Image', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(78, 'featured_image', 'Featured Image', 'Featured Image', 'Featured Image', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(79, 'add_estate', 'Add Estate', 'Add Estate', 'Add Estate', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(80, 'type', 'Type', 'Type', 'Type', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(81, 'featured', 'Featured', 'Featured', 'Featured', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(82, 'action', 'Action', 'Action', 'Action', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(83, 'edit', 'Edit', 'Edit', 'Edit', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(84, 'remove_featured', 'Remove Featured', 'Remove Featured', 'Remove Featured', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(85, 'make_featured', 'Make Featured', 'Make Featured', 'Make Featured', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(86, 'add_country', 'Add Country', 'Add Country', 'Add Country', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(87, 'add_state', 'Add State', 'Add State', 'Add State', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(88, 'add_city', 'Add City', 'Add City', 'Add City', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(89, 'name', 'Name', 'Name', 'Name', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(90, 'parent', 'Parent', 'Parent', 'Parent', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(91, 'select_country', 'Select Country', 'Select Country', 'Select Country', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(92, 'select_state', 'Select State', 'Select State', 'Select State', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(93, 'state', 'State', 'State', 'State', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(94, 'edit_location', 'Edit Location', 'Edit Location', 'Edit Location', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(95, 'update_location', 'Update Location', 'Update Location', 'Update Location', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(96, 'add_amenities', 'Add Amenities', 'Add Amenities', 'Add Amenities', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(97, 'icon', 'Icon', 'Icon', 'Icon', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(98, 'create_amenities', 'Create Amenities', 'Create Amenities', 'Create Amenities', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(99, 'edit_estate', 'Edit Estate', 'Edit Estate', 'Edit Estate', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(100, 'gallery', 'Gallery', 'Gallery', 'Gallery', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(101, 'additional_info', 'Additional Info', 'Additional Info', 'Additional Info', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(102, 'embed_video_url', 'Embed Video Url', 'Embed Video Url', 'Embed Video Url', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(103, 'video_url', 'Video Url', 'Video Url', 'Video Url', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(104, 'gas_emission', 'Gas Emission', 'Gas Emission', 'Gas Emission', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(105, 'energy_efficiency', 'Energy Efficiency', 'Energy Efficiency', 'Energy Efficiency', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(106, 'tags', 'Tags', 'Tags', 'Tags', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(107, 'update_estate', 'Update Estate', 'Update Estate', 'Update Estate', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(108, 'edit_amenity', 'Edit Amenity', 'Edit Amenity', 'Edit Amenity', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(109, 'update_amenity', 'Update Amenity', 'Update Amenity', 'Update Amenity', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(110, 'add_distance_fields', 'Add Distance Fields', 'Add Distance Fields', 'Add Distance Fields', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(111, 'edit_distance_fields', 'Edit Distance Fields', 'Edit Distance Fields', 'Edit Distance Fields', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(112, 'update_distance_field', 'Update Distance Field', 'Update Distance Field', 'Update Distance Field', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(113, 'create_distance_fields', 'Create Distance Fields', 'Create Distance Fields', 'Create Distance Fields', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(114, 'email', 'Email', 'Email', 'Email', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(115, 'phone', 'Phone', 'Phone', 'Phone', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(116, 'status', 'Status', 'Status', 'Status', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(117, 'active', 'Active', 'Active', 'Active', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(118, 'ban_user', 'Ban User', 'Ban User', 'Ban User', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(119, 'add_widget', 'Add Widget', 'Add Widget', 'Add Widget', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(120, 'edit_widget', 'Edit Widget', 'Edit Widget', 'Edit Widget', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(121, 'add_widgets', 'Add Widgets', 'Add Widgets', 'Add Widgets', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(122, 'create_widget', 'Create Widget', 'Create Widget', 'Create Widget', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(123, 'home_ad_banner_first', 'Home Ad Banner First', 'Home Ad Banner First', 'Home Ad Banner First', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(124, 'home_ad_banner_second', 'Home Ad Banner Second', 'Home Ad Banner Second', 'Home Ad Banner Second', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(125, 'right_bar_post_detail', 'Right Bar Post Detail', 'Right Bar Post Detail', 'Right Bar Post Detail', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(126, 'footer_first_column', 'Footer First Column', 'Footer First Column', 'Footer First Column', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(127, 'footer_second_column', 'Footer Second Column', 'Footer Second Column', 'Footer Second Column', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(128, 'footer_third_column', 'Footer Third Column', 'Footer Third Column', 'Footer Third Column', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(129, 'right_bar_all_agents', 'Right Bar All Agents', 'Right Bar All Agents', 'Right Bar All Agents', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(130, 'right_bar_contact', 'Right Bar Contact', 'Right Bar Contact', 'Right Bar Contact', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(131, 'show', 'Show', 'Show', 'Show', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(132, 'available_widgets', 'Available Widgets', 'Available Widgets', 'Available Widgets', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(133, 'active_widgets', 'Active Widgets', 'Active Widgets', 'Active Widgets', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(134, 'alias', 'Alias', 'Alias', 'Alias', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(135, 'edit_page', 'Edit Page', 'Edit Page', 'Edit Page', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(136, 'menu_title', 'Menu Title', 'Menu Title', 'Menu Title', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(137, 'show_in_menu', 'Show In Menu', 'Show In Menu', 'Show In Menu', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(138, 'no ', 'No ', 'No ', 'No ', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(139, 'content_from', 'Content From', 'Content From', 'Content From', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(140, 'url ', 'Url ', 'Url ', 'Url ', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(141, 'manual', 'Manual', 'Manual', 'Manual', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(142, 'url', 'Url', 'Url', 'Url', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(143, 'url', 'Url', 'Url', 'Url', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(144, 'page_layout', 'Page Layout', 'Page Layout', 'Page Layout', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(145, 'right_bar_with_content', 'Right Bar With Content', 'Right Bar With Content', 'Right Bar With Content', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(146, 'left_bar_with_content ', 'Left Bar With Content ', 'Left Bar With Content ', 'Left Bar With Content ', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(147, 'only_content', 'Only Content', 'Only Content', 'Only Content', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(148, 'content', 'Content', 'Content', 'Content', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(149, 'SEO_options', 'SEO Options', 'SEO Options', 'SEO Options', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(150, 'meta_description', 'Meta Description', 'Meta Description', 'Meta Description', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(151, 'key_words', 'Key Words', 'Key Words', 'Key Words', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(152, 'crawl_after(days)', 'Crawl After(days)', 'Crawl After(days)', 'Crawl After(days)', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(153, 'crawl_after', 'Crawl After', 'Crawl After', 'Crawl After', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(154, 'no ', 'No ', 'No ', 'No ', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(155, 'url', 'Url', 'Url', 'Url', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(156, 'url', 'Url', 'Url', 'Url', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(157, 'no ', 'No ', 'No ', 'No ', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(158, 'url', 'Url', 'Url', 'Url', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(159, 'url', 'Url', 'Url', 'Url', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(160, 'save', 'Save', 'Save', 'Save', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(161, 'create_page', 'Create Page', 'Create Page', 'Create Page', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(162, 'no ', 'No ', 'No ', 'No ', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(163, 'url', 'Url', 'Url', 'Url', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(164, 'url', 'Url', 'Url', 'Url', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(165, 'no ', 'No ', 'No ', 'No ', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(166, 'url', 'Url', 'Url', 'Url', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(167, 'url', 'Url', 'Url', 'Url', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(168, 'no ', 'No ', 'No ', 'No ', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(169, 'url', 'Url', 'Url', 'Url', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(170, 'url', 'Url', 'Url', 'Url', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(171, 'package', 'Package', 'Package', 'Package', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(172, 'add_package', 'Add Package', 'Add Package', 'Add Package', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(173, 'number_of_properties', 'Number Of Properties', 'Number Of Properties', 'Number Of Properties', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(174, 'validity', 'Validity', 'Validity', 'Validity', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(175, 'options', 'Options', 'Options', 'Options', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(176, 'add_new_package', 'Add New Package', 'Add New Package', 'Add New Package', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(177, 'submit', 'Submit', 'Submit', 'Submit', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(178, 'edit_package', 'Edit Package', 'Edit Package', 'Edit Package', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(179, 'update', 'Update', 'Update', 'Update', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(180, 'amount', 'Amount', 'Amount', 'Amount', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(181, 'activation_date', 'Activation Date', 'Activation Date', 'Activation Date', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(182, 'expire_date', 'Expire Date', 'Expire Date', 'Expire Date', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(183, 'payment_type', 'Payment Type', 'Payment Type', 'Payment Type', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(184, 'system_name', 'System Name', 'System Name', 'System Name', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(185, 'system_email', 'System Email', 'System Email', 'System Email', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(186, 'currency', 'Currency', 'Currency', 'Currency', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(187, 'currency_type', 'Currency Type', 'Currency Type', 'Currency Type', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(188, 'text', 'Text', 'Text', 'Text', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(189, 'currency_placing', 'Currency Placing', 'Currency Placing', 'Currency Placing', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(190, 'before_with_no_gap', 'Before With No Gap', 'Before With No Gap', 'Before With No Gap', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(191, 'before_with_gap', 'Before With Gap', 'Before With Gap', 'Before With Gap', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(192, 'after_with_no_gap', 'After With No Gap', 'After With No Gap', 'After With No Gap', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(193, 'after_with_gap', 'After With Gap', 'After With Gap', 'After With Gap', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(194, 'language', 'Language', 'Language', 'Language', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(195, 'english', 'English', 'English', 'English', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(196, 'spanish', 'Spanish', 'Spanish', 'Spanish', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(197, 'arabic', 'Arabic', 'Arabic', 'Arabic', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(198, 'russian', 'Russian', 'Russian', 'Russian', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(199, 'chinese', 'Chinese', 'Chinese', 'Chinese', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(200, 'turkish', 'Turkish', 'Turkish', 'Turkish', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(201, 'portuguese', 'Portuguese', 'Portuguese', 'Portuguese', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(202, 'french', 'French', 'French', 'French', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(203, 'german', 'German', 'German', 'German', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(204, 'italian', 'Italian', 'Italian', 'Italian', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(205, 'hindi', 'Hindi', 'Hindi', 'Hindi', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(206, 'text_alignment', 'Text Alignment', 'Text Alignment', 'Text Alignment', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(207, 'left_to_right', 'Left To Right', 'Left To Right', 'Left To Right', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(208, 'right_to_left', 'Right To Left', 'Right To Left', 'Right To Left', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(209, 'copyright_text', 'Copyright Text', 'Copyright Text', 'Copyright Text', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(210, 'save_settings', 'Save Settings', 'Save Settings', 'Save Settings', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(211, 'upload_logo', 'Upload Logo', 'Upload Logo', 'Upload Logo', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(212, 'select_logo', 'Select Logo', 'Select Logo', 'Select Logo', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(213, 'change', 'Change', 'Change', 'Change', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(214, 'remove', 'Remove', 'Remove', 'Remove', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(215, 'manage_language', 'Manage Language', 'Manage Language', 'Manage Language', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(216, 'language_list', 'Language List', 'Language List', 'Language List', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(217, 'add_phrase', 'Add Phrase', 'Add Phrase', 'Add Phrase', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(218, 'add_language', 'Add Language', 'Add Language', 'Add Language', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(219, 'option', 'Option', 'Option', 'Option', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(220, 'edit_phrase', 'Edit Phrase', 'Edit Phrase', 'Edit Phrase', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(221, 'delete_language', 'Delete Language', 'Delete Language', 'Delete Language', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(222, 'phrase', 'Phrase', 'Phrase', 'Phrase', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(223, 'value_required', 'Value Required', 'Value Required', 'Value Required', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(224, 'basic_settings', 'Basic Settings', 'Basic Settings', 'Basic Settings', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(225, 'enable_signup', 'Enable Signup', 'Enable Signup', 'Enable Signup', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(226, 'banner_type', 'Banner Type', 'Banner Type', 'Banner Type', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(227, 'slider', 'Slider', 'Slider', 'Slider', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(228, 'map_center_latitude', 'Map Center Latitude', 'Map Center Latitude', 'Map Center Latitude', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(229, 'map_center_longitude', 'Map Center Longitude', 'Map Center Longitude', 'Map Center Longitude', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(230, 'map_centre_zoom', 'Map Centre Zoom', 'Map Centre Zoom', 'Map Centre Zoom', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(231, 'recent_estates_count', 'Recent Estates Count', 'Recent Estates Count', 'Recent Estates Count', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(232, 'google_map_api_key', 'Google Map Api Key', 'Google Map Api Key', 'Google Map Api Key', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(233, 'recaptcha_site_key', 'Recaptcha Site Key', 'Recaptcha Site Key', 'Recaptcha Site Key', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(234, 'recaptcha_secret_key', 'Recaptcha Secret Key', 'Recaptcha Secret Key', 'Recaptcha Secret Key', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(235, 'setup_payment_informations', 'Setup Payment Informations', 'Setup Payment Informations', 'Setup Payment Informations', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(236, 'mode', 'Mode', 'Mode', 'Mode', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(237, 'sandbox', 'Sandbox', 'Sandbox', 'Sandbox', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(238, 'production', 'Production', 'Production', 'Production', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(239, 'client_id', 'Client Id', 'Client Id', 'Client Id', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(240, 'save_changes', 'Save Changes', 'Save Changes', 'Save Changes', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(241, 'test_mode', 'Test Mode', 'Test Mode', 'Test Mode', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(242, 'on', 'On', 'On', 'On', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(243, 'off', 'Off', 'Off', 'Off', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(244, 'test_secret_key', 'Test Secret Key', 'Test Secret Key', 'Test Secret Key', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(245, 'test_public_key', 'Test Public Key', 'Test Public Key', 'Test Public Key', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(246, 'live_secret_key', 'Live Secret Key', 'Live Secret Key', 'Live Secret Key', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(247, 'live_public_key', 'Live Public Key', 'Live Public Key', 'Live Public Key', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(248, 'create_xml', 'Create Xml', 'Create Xml', 'Create Xml', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(249, 'view_xml', 'View Xml', 'View Xml', 'View Xml', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(250, 'first_name', 'First Name', 'First Name', 'First Name', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(251, 'last_name', 'Last Name', 'Last Name', 'Last Name', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(252, 'about', 'About', 'About', 'About', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(253, 'facebook', 'Facebook', 'Facebook', 'Facebook', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(254, 'instagram', 'Instagram', 'Instagram', 'Instagram', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(255, 'twitter', 'Twitter', 'Twitter', 'Twitter', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(256, 'google_plus', 'Google Plus', 'Google Plus', 'Google Plus', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(257, 'linkedin', 'Linkedin', 'Linkedin', 'Linkedin', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(258, 'skype', 'Skype', 'Skype', 'Skype', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(259, 'profile_image', 'Profile Image', 'Profile Image', 'Profile Image', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(260, 'change_password', 'Change Password', 'Change Password', 'Change Password', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(261, 'current_password', 'Current Password', 'Current Password', 'Current Password', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(262, 'new_password', 'New Password', 'New Password', 'New Password', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(263, 'confirm_new_password', 'Confirm New Password', 'Confirm New Password', 'Confirm New Password', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(264, 'aboutus', 'Aboutus', 'Aboutus', 'Aboutus', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(265, 'contact', 'Contact', 'Contact', 'Contact', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(266, 'admin_panel', 'Admin Panel', 'Admin Panel', 'Admin Panel', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(267, 'log_out', 'Log Out', 'Log Out', 'Log Out', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(268, 'seach_for_address, city, neighbourhood', 'Seach For Address, City, Neighbourhood', 'Seach For Address, City, Neighbourhood', 'Seach For Address, City, Neighbourhood', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(269, 'all_properties', 'All Properties', 'All Properties', 'All Properties', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(270, 'for_sale', 'For Sale', 'For Sale', 'For Sale', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(271, 'for_rent', 'For Rent', 'For Rent', 'For Rent', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(272, 'search_properties', 'Search Properties', 'Search Properties', 'Search Properties', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(273, 'featured_properties', 'Featured Properties', 'Featured Properties', 'Featured Properties', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(274, 'For', 'For', 'For', 'For', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(275, 'latest_properties', 'Latest Properties', 'Latest Properties', 'Latest Properties', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(282, 'our_agents', 'Our Agents', 'Our Agents', 'Our Agents', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(283, 'recent_properties', 'Recent Properties', 'Recent Properties', 'Recent Properties', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(290, 'advance_search', 'Advance Search', 'Advance Search', 'Advance Search', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(291, 'real_estate_properties', 'Real Estate Properties', 'Real Estate Properties', 'Real Estate Properties', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(292, 'advanced_search', 'Advanced Search', 'Advanced Search', 'Advanced Search', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(293, 'city, country, address, neighbourhood', 'City, Country, Address, Neighbourhood', 'City, Country, Address, Neighbourhood', 'City, Country, Address, Neighbourhood', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(294, 'property_type', 'Property Type', 'Property Type', 'Property Type', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(295, 'all', 'All', 'All', 'All', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(296, 'bedrooms', 'Bedrooms', 'Bedrooms', 'Bedrooms', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(297, 'any', 'Any', 'Any', 'Any', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(298, 'baths', 'Baths', 'Baths', 'Baths', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(299, 'minimum_price', 'Minimum Price', 'Minimum Price', 'Minimum Price', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(300, 'maximum_price', 'Maximum Price', 'Maximum Price', 'Maximum Price', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(301, 'sort_by', 'Sort By', 'Sort By', 'Sort By', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(302, 'high_to_low', 'High To Low', 'High To Low', 'High To Low', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(303, 'low_to_high', 'Low To High', 'Low To High', 'Low To High', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(304, 'new_to_old', 'New To Old', 'New To Old', 'New To Old', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(305, 'old_to_new', 'Old To New', 'Old To New', 'Old To New', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(306, 'for', 'For', 'For', 'For', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(314, 'days', 'Days', 'Days', 'Days', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(315, 'view_details', 'View Details', 'View Details', 'View Details', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(316, 'top_agents', 'Top Agents', 'Top Agents', 'Top Agents', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(317, 'estate_types', 'Estate Types', 'Estate Types', 'Estate Types', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(318, 'top_properties', 'Top Properties', 'Top Properties', 'Top Properties', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(319, 'contact_us', 'Contact Us', 'Contact Us', 'Contact Us', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(320, 'send_message', 'Send Message', 'Send Message', 'Send Message', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(321, 'login', 'Login', 'Login', 'Login', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(322, 'register', 'Register', 'Register', 'Register', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(335, 'password', 'Password', 'Password', 'Password', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(336, 'forgot_your_password', 'Forgot Your Password', 'Forgot Your Password', 'Forgot Your Password', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(392, 'update_phrase', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(343, 'agent_panel', 'Agent Panel', 'Agent Panel', 'Agent Panel', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(357, 'property_details', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(358, 'general_amenities', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(359, 'distances', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(360, 'agent_details', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(361, 'property_location', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(362, 'image_gallery', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(363, 'featured_video', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(364, 'contact_agent', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(365, 'your_name', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(366, 'email_address', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(367, 'message', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(369, 'agent_dashboard', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(370, 'manage_package', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(371, 'my_properties', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(372, 'currently_active', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(391, 'phrase_list', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(393, 'data_created', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(394, 'data_deleted', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(395, 'facebook_app_id', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(396, 'no ', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(397, 'url', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(404, 'min_price', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(405, 'max_price', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(414, 'data_updated', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `language` VALUES(415, 'view', '', '', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `location_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent` int(11) NOT NULL,
  `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `type` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`location_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

--
-- Dumping data for table `location`
--

INSERT INTO `location` VALUES(1, 0, 'USA', 'country');
INSERT INTO `location` VALUES(2, 0, 'Canada', 'country');
INSERT INTO `location` VALUES(3, 0, ' Bangladesh', 'country');
INSERT INTO `location` VALUES(4, 1, 'California', 'state');
INSERT INTO `location` VALUES(5, 1, ' New York', 'state');
INSERT INTO `location` VALUES(6, 2, 'Ottawa', 'state');
INSERT INTO `location` VALUES(7, 2, ' Toronto', 'state');
INSERT INTO `location` VALUES(8, 4, 'San Diego', 'city');
INSERT INTO `location` VALUES(9, 4, ' San Fransisco', 'city');
INSERT INTO `location` VALUES(10, 4, ' Los Angeles', 'city');
INSERT INTO `location` VALUES(11, 1, 'Virginia', 'state');
INSERT INTO `location` VALUES(12, 1, ' Utah', 'state');
INSERT INTO `location` VALUES(13, 4, 'San Jose', 'city');
INSERT INTO `location` VALUES(14, 4, ' Sacramento', 'city');
INSERT INTO `location` VALUES(15, 4, ' Long Beach', 'city');
INSERT INTO `location` VALUES(16, 4, ' Oakland', 'city');

-- --------------------------------------------------------

--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `subject` longtext COLLATE utf8_unicode_ci,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `estate_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `message`
--

INSERT INTO `message` VALUES(1, 'Jane Margo', 'saad@dbcinfotech.com', 'Agent Inquiry', 'fefwfwffwfwfwfw How do you do?', 1, NULL);
INSERT INTO `message` VALUES(2, 'Aiko Riddle', 'dagomes@yahoo.com', 'Agent Inquiry', 'Do est corporis libero unde aut illum quod aliquam in sit distinctio Voluptatem in sit nulla pariatur Alias', 1, NULL);
INSERT INTO `message` VALUES(3, 'Winter Newton', 'tonoves@yahoo.com', 'Sed mollit laboriosam', 'Molestiae qui in ea amet et fugiat ducimus eiusmod nulla pariatur Molestias quam sit laboris iusto voluptas fugiat sint numquam', 3, 4);
INSERT INTO `message` VALUES(4, 'Xenos Abbott', 'fotyji@hotmail.com', 'Repellendus Est corporis id culpa', 'Omnis elit ratione et neque atque reprehenderit suscipit fuga Commodo et tenetur labore molestiae amet cum quasi in maiores est', 3, 4);
INSERT INTO `message` VALUES(5, 'India Patterson', 'vohiqufiz@gmail.com', 'Magni expedita ipsa volup', 'Sunt consequatur Ea amet porro cillum voluptas nulla consectetur error', 3, 4);
INSERT INTO `message` VALUES(6, 'Wyoming Crane', 'rufijar@gmail.com', 'Aspernatur rerum labor', 'Quis sunt eveniet in ut dolor dolore nulla qui', 3, 4);
INSERT INTO `message` VALUES(7, 'Bethany Mann', 'loden@hotmail.com', 'Agent Inquiry', 'Incididunt et excepturi provident dolores laborum cillum deserunt', 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `package`
--

CREATE TABLE `package` (
  `package_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext COLLATE utf8_unicode_ci NOT NULL,
  `number_of_properties` int(11) NOT NULL,
  `validity` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  PRIMARY KEY (`package_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `package`
--

INSERT INTO `package` VALUES(1, 'Free', 10, 30, 0.00);
INSERT INTO `package` VALUES(2, 'Basic', 50, 90, 100.00);
INSERT INTO `package` VALUES(3, 'Premium', 100, 365, 200.00);

-- --------------------------------------------------------

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `page_id` int(11) NOT NULL AUTO_INCREMENT,
  `alias` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `show_in_menu` tinyint(1) NOT NULL DEFAULT '1',
  `layout` int(3) DEFAULT NULL,
  `content_from` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` longtext COLLATE utf8_unicode_ci,
  `content` longtext COLLATE utf8_unicode_ci,
  `sidebar` longtext COLLATE utf8_unicode_ci,
  `seo_settings` longtext COLLATE utf8_unicode_ci,
  `create_time` int(11) DEFAULT NULL,
  `status` int(3) NOT NULL DEFAULT '1',
  `editable` tinyint(1) NOT NULL DEFAULT '1',
  `parent` int(11) DEFAULT NULL,
  `draft` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`page_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES(1, 'home', 1, 0, 'url', 'Home', '', '', '', '{"meta_description":"","key_words":"","crawl_after":""}', NULL, 1, 1, 0, 0);
INSERT INTO `pages` VALUES(2, 'properties', 1, 0, 'url', 'Properties', 'show/search', '', '', '{"meta_description":"Hello","key_words":"ffaf","crawl_after":"3"}', NULL, 1, 1, 0, 0);
INSERT INTO `pages` VALUES(3, 'packages', 1, 0, 'url', 'Packages', 'show/package', '', '', '{"meta_description":"","key_words":"","crawl_after":""}', NULL, 1, 1, 0, 0);
INSERT INTO `pages` VALUES(4, 'agents', 1, 0, 'url', 'Agents', 'show/agents', '', '', '{"meta_description":"","key_words":"","crawl_after":""}', NULL, 1, 1, 0, 0);
INSERT INTO `pages` VALUES(5, 'aboutus', 1, 2, 'manual', 'About Us', 'show/page/aboutus', '<p>Loren Ipsum About Us. May the force be with you.</p>', '', '{"meta_description":"about","key_words":"lala","crawl_after":"3"}', NULL, 1, 1, 0, 0);
INSERT INTO `pages` VALUES(6, 'contact', 1, 0, 'url', 'Contact', 'show/contact', '', '', '{"meta_description":"contact, real estate","key_words":"contact, address","crawl_after":"3"}', NULL, 1, 1, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `realestate_settings`
--

CREATE TABLE `realestate_settings` (
  `settings_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` longtext COLLATE utf8_unicode_ci,
  `description` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`settings_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `realestate_settings`
--

INSERT INTO `realestate_settings` VALUES(1, 'banner_type', 'slider');
INSERT INTO `realestate_settings` VALUES(2, 'map_center_latitude', '34.0207504');
INSERT INTO `realestate_settings` VALUES(3, 'map_center_longitude', '-118.6919234');
INSERT INTO `realestate_settings` VALUES(4, 'map_centre_zoom', '8');
INSERT INTO `realestate_settings` VALUES(5, 'recent_estates_count', '12');
INSERT INTO `realestate_settings` VALUES(6, 'google_map_api_key', 'AIzaSyDkESPQprNTIDU2hpuVjVqrhRAJfI0_rL4');
INSERT INTO `realestate_settings` VALUES(7, 'enable_signup', 'yes');

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `settings_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`settings_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES(1, 'system_name', 'Domino');
INSERT INTO `settings` VALUES(3, 'address', 'Impedit in aut voluptatem Eum aliquammmm');
INSERT INTO `settings` VALUES(4, 'phone', '+247-12-5808442222');
INSERT INTO `settings` VALUES(5, 'paypal', '[{"active":"1","mode":"sandbox","sandbox_client_id":"AZDxjDScFpQtjWTOUtWKbyN_bDt4OgqaF4eYXlewfBP4-8aqX3PiV8e1GWU6liB2CUXlkA59kJXE7M6R","production_client_id":"someid"}]');
INSERT INTO `settings` VALUES(6, 'currency', 'USD');
INSERT INTO `settings` VALUES(7, 'system_email', 'xovewin@hotmail.commmm');
INSERT INTO `settings` VALUES(10, 'language', 'english');
INSERT INTO `settings` VALUES(11, 'text_align', 'left-to-right');
INSERT INTO `settings` VALUES(17, 'currency_type', 'icon');
INSERT INTO `settings` VALUES(18, 'currency_placing', 'before_with_gap');
INSERT INTO `settings` VALUES(19, 'menu', '[{"page_id":"1","parent":0},{"page_id":"2","parent":0},{"page_id":"5","parent":0},{"page_id":"3","parent":0},{"page_id":"4","parent":0},{"page_id":"6","parent":0}]');
INSERT INTO `settings` VALUES(20, 'widget_position', '[{"name":"home_ad_banner_first","status":1,"widgets":["home_image_banner"]},{"name":"home_ad_banner_second","status":1,"widgets":["home_text_banner"]},{"name":"right_bar_post_detail","status":1,"widgets":["top_properties","recent_properties","fb_like_box","top_agents","all_estate_types"]},{"name":"footer_first_column","status":1,"widgets":["about_us"]},{"name":"footer_second_column","status":1,"widgets":["recent_properties_footer"]},{"name":"footer_third_column","status":1,"widgets":["contact_text"]},{"name":"right_bar_all_agents","status":1,"widgets":["recent_properties","top_agents","all_estate_types","top_properties"]},{"name":"right_bar_contact","status":1,"widgets":["contact_page_sidebar"]}]');
INSERT INTO `settings` VALUES(21, 'meta_description', 'realcon property listing');
INSERT INTO `settings` VALUES(22, 'key_words', 'real estate,property,listing, house');
INSERT INTO `settings` VALUES(23, 'crawl_after', '3');
INSERT INTO `settings` VALUES(24, 'fb_app_id', '244967666032203');
INSERT INTO `settings` VALUES(25, 'stripe_keys', '[{"active":"1","testmode":"on","public_key":"pk_test_c6VvBEbwHFdulFZ62q1IQrar","secret_key":"sk_test_9IMkiM6Ykxr1LCe2dJ3PgaxS","public_live_key":"pk_live_xxxxxxxxxxxxxxxxxxxxxxxx","secret_live_key":"sk_live_xxxxxxxxxxxxxxxxxxxxxxxx"}]');
INSERT INTO `settings` VALUES(26, 'recaptcha', '[{"site_key":"6Le8NDQUAAAAAGM1TaLMRxaV5wjcywhXAWLhQVoM","secret_key":"6Le8NDQUAAAAAINMHiJGyGTYibtGWZK0p4TJRQx2"}]');
INSERT INTO `settings` VALUES(27, 'purchase_code', '');
INSERT INTO `settings` VALUES(28, 'version', '1.0');
INSERT INTO `settings` VALUES(29, 'copyright_text', 'Copyright 2017 | Creativeitem');
INSERT INTO `settings` VALUES(30, 'logo', 'logo.png');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `user_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_type` int(3) NOT NULL,
  `first_name` char(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `last_name` char(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `profile_photo` char(200) COLLATE utf8_unicode_ci DEFAULT '',
  `email` char(100) COLLATE utf8_unicode_ci NOT NULL,
  `password` char(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `about_me` text COLLATE utf8_unicode_ci,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `facebook` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `instagram` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gplus` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `linkedin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `skype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `remember_me_key` char(255) COLLATE utf8_unicode_ci DEFAULT '',
  `recovery_key` char(255) COLLATE utf8_unicode_ci DEFAULT '',
  `confirmation_key` char(30) COLLATE utf8_unicode_ci DEFAULT '',
  `confirmed` int(1) NOT NULL DEFAULT '1',
  `confirmed_date` datetime DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '1' COMMENT '1=active, 2= banned, 0 = deleted',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES(1, 1, 'Admin', 'Doe', 'about-agent.jpg', 'admin@example.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '01717055740', '    ', 'Sales Manager', '', '', '', '', '', '', '', '', '', 1, NULL, 1);
INSERT INTO `users` VALUES(2, 2, 'Jimi', 'Page', 'Real-Estate-Agent.jpg', 'jim@example.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '001991', '  ', NULL, 'https://facebook.com', NULL, 'https://twitter.com', 'https://google.com', 'https://linkedin.com', NULL, '', '', '', 1, NULL, 1);
INSERT INTO `users` VALUES(3, 2, 'Jane', 'Hendrix', 'realtor.jpg', 'creative@example.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '001', '   ', NULL, 'https://facebook.com', NULL, 'https://twitter.com', '', 'https://linkedin.com', NULL, '', '', '', 1, NULL, 1);
INSERT INTO `users` VALUES(4, 2, 'Matt', 'Murdock', 'realtor_understands.jpg', 'agent2@example.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '56347895', ' ', NULL, '', NULL, '', 'https://google.com', '', NULL, '', '', '', 1, NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `user_package`
--

CREATE TABLE `user_package` (
  `user_package_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `amount` longtext COLLATE utf8_unicode_ci NOT NULL,
  `activation_date` longtext COLLATE utf8_unicode_ci NOT NULL,
  `expiration_date` longtext COLLATE utf8_unicode_ci NOT NULL,
  `is_active` int(11) NOT NULL COMMENT '0 = inactive, 1 = active',
  `payment_type` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`user_package_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=30 ;

--
-- Dumping data for table `user_package`
--

INSERT INTO `user_package` VALUES(4, 3, 2, '0', '1493661600', '1496253600', 0, 'paypal');
INSERT INTO `user_package` VALUES(13, 3, 1, '0', '1493661600', '1496253600', 1, 'paypal');
INSERT INTO `user_package` VALUES(14, 2, 1, '100.00', '1508781600', '1511373600', 0, 'paypal');
INSERT INTO `user_package` VALUES(15, 2, 3, '200.00', '1509436556', '1540972556', 0, 'stripe');
INSERT INTO `user_package` VALUES(16, 2, 3, '200.00', '1509436572', '1540972572', 0, 'stripe');
INSERT INTO `user_package` VALUES(17, 2, 2, '100.00', '1509436864', '1517212864', 0, 'stripe');
INSERT INTO `user_package` VALUES(18, 2, 3, '200.00', '1509437724', '1540973724', 0, 'stripe');
INSERT INTO `user_package` VALUES(19, 2, 2, '100.00', '1509437871', '1517213871', 0, 'stripe');
INSERT INTO `user_package` VALUES(20, 2, 1, '0.00', '1509438194', '1512030194', 0, 'stripe');
INSERT INTO `user_package` VALUES(21, 2, 2, '100.00', '1509438315', '1517214315', 0, 'stripe');
INSERT INTO `user_package` VALUES(22, 2, 1, '0.00', '1509438389', '1512030389', 0, 'stripe');
INSERT INTO `user_package` VALUES(23, 2, 2, '100.00', '1509447300', '1517223300', 0, 'stripe');
INSERT INTO `user_package` VALUES(24, 2, 2, '100.00', '1509455999', '1517231999', 0, 'stripe');
INSERT INTO `user_package` VALUES(25, 2, 2, '100.00', '1509482028', '1517258028', 0, 'paypal');
INSERT INTO `user_package` VALUES(26, 2, 3, '200.00', '1509482231', '1541018231', 0, 'paypal');
INSERT INTO `user_package` VALUES(27, 2, 2, '100.00', '1509519406', '1517295406', 0, 'stripe');
INSERT INTO `user_package` VALUES(28, 2, 3, '200.00', '1509962540', '1541498540', 0, 'stripe');
INSERT INTO `user_package` VALUES(29, 2, 3, '200.00', '1509962723', '1541498723', 1, 'stripe');

-- --------------------------------------------------------

--
-- Table structure for table `widgets`
--

CREATE TABLE `widgets` (
  `widget_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alias` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `editable` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`widget_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=16 ;

--
-- Dumping data for table `widgets`
--

INSERT INTO `widgets` VALUES(3, 'Contact Text', 'contact_text', 1, 1);
INSERT INTO `widgets` VALUES(4, 'About Us', 'about_us', 1, 1);
INSERT INTO `widgets` VALUES(5, 'Recent Properties Footer', 'recent_properties_footer', 1, 1);
INSERT INTO `widgets` VALUES(6, 'Home Text Banner', 'home_text_banner', 1, 1);
INSERT INTO `widgets` VALUES(7, 'Home Image Banner', 'home_image_banner', 1, 1);
INSERT INTO `widgets` VALUES(8, 'Adsense Banner', 'adsense_banner', 1, 1);
INSERT INTO `widgets` VALUES(9, 'All Estate Types', 'all_estate_types', 1, 1);
INSERT INTO `widgets` VALUES(10, 'Contact Page Sidebar', 'contact_page_sidebar', 1, 1);
INSERT INTO `widgets` VALUES(11, 'FB Like Box', 'fb_like_box', 1, 1);
INSERT INTO `widgets` VALUES(12, 'Recent Properties', 'recent_properties', 1, 1);
INSERT INTO `widgets` VALUES(13, 'Top Agents', 'top_agents', 1, 1);
INSERT INTO `widgets` VALUES(14, 'Top Properties', 'top_properties', 1, 1);
