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




--
-- Database: `realestate_install`
--

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

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

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

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

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

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

--
-- Table structure for table `ci_sessions`
--

CREATE TABLE `ci_sessions` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

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

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

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

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

CREATE TABLE `estate` (
  `estate_id` int(11) NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `estate` (`estate_id`, `title`, `description`, `type`, `purpose`, `price`, `contact_for_price`, `rent_price`, `rent_price_unit`, `total_price`, `size`, `size_unit`, `bedroom`, `bath`, `year_built`, `address`, `country`, `state`, `city`, `zip_code`, `latitude`, `longitude`, `featured_image`, `gallery`, `amenities`, `distance_fields`, `energy_efficiency`, `gas_emission`, `created_by`, `create_time`, `status`, `featured`, `report`, `total_views`, `search_meta`, `video_url`, `house_plan`, `tags`) 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', 'null', '["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    '),
(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', 'null', '["1","2","3","5","7","8","9","12","13"]', '["{\\"id\\":\\"1\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"2\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"3\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"4\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"5\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"6\\",\\"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 '),
(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', '[""]', '["3","4","5","7","8","11","13"]', '["{\\"id\\":\\"1\\",\\"value\\":\\"32\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"2\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"3\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"4\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"5\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"6\\",\\"value\\":\\"\\",\\"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, '   '),
(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', 'null', '["2","3","5","6","7","9","10","11","12","13"]', '["{\\"id\\":\\"1\\",\\"value\\":\\"30\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"2\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"3\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"4\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"5\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"6\\",\\"value\\":\\"\\",\\"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, '  '),
(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', 'null', '["1","3","6","7","8","9","12","13"]', '["{\\"id\\":\\"1\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"2\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"3\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"4\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"5\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"6\\",\\"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, '  '),
(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', '[""]', '["3","4","5","6","7","8","9","10","12","13"]', '["{\\"id\\":\\"1\\",\\"value\\":\\"2\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"2\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"3\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"4\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"5\\",\\"value\\":\\"\\",\\"units\\":\\"meters\\"}","{\\"id\\":\\"6\\",\\"value\\":\\"\\",\\"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,
  `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
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

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

CREATE TABLE `location` (
  `location_id` int(11) NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

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

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

CREATE TABLE `message` (
  `message_id` int(11) NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `message` (`message_id`, `name`, `email`, `subject`, `message`, `user_id`, `estate_id`) VALUES
(1, 'Jane Margo', 'saad@dbcinfotech.com', 'Agent Inquiry', 'fefwfwffwfwfwfw How do you do?', 1, NULL),
(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),
(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),
(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),
(5, 'India Patterson', 'vohiqufiz@gmail.com', 'Magni expedita ipsa volup', 'Sunt consequatur Ea amet porro cillum voluptas nulla consectetur error', 3, 4),
(6, 'Wyoming Crane', 'rufijar@gmail.com', 'Aspernatur rerum labor', 'Quis sunt eveniet in ut dolor dolore nulla qui', 3, 4),
(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,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

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

CREATE TABLE `pages` (
  `page_id` int(11) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `pages` (`page_id`, `alias`, `show_in_menu`, `layout`, `content_from`, `title`, `url`, `content`, `sidebar`, `seo_settings`, `create_time`, `status`, `editable`, `parent`, `draft`) VALUES
(1, 'home', 1, 0, 'url', 'Home', '', '', '', '{"meta_description":"","key_words":"","crawl_after":""}', NULL, 1, 1, 0, 0),
(2, 'properties', 1, 0, 'url', 'Properties', 'show/search', '', '', '{"meta_description":"Hello","key_words":"ffaf","crawl_after":"3"}', NULL, 1, 1, 0, 0),
(3, 'packages', 1, 0, 'url', 'Packages', 'show/package', '', '', '{"meta_description":"","key_words":"","crawl_after":""}', NULL, 1, 1, 0, 0),
(4, 'agents', 1, 0, 'url', 'Agents', 'show/agents', '', '', '{"meta_description":"","key_words":"","crawl_after":""}', NULL, 1, 1, 0, 0),
(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),
(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,
  `type` longtext COLLATE utf8_unicode_ci,
  `description` longtext COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `realestate_settings` (`settings_id`, `type`, `description`) VALUES
(1, 'banner_type', 'slider'),
(2, 'map_center_latitude', '34.0207504'),
(3, 'map_center_longitude', '-118.6919234'),
(4, 'map_centre_zoom', '8'),
(5, 'recent_estates_count', '12'),
(6, 'google_map_api_key', 'AIzaSyDkESPQprNTIDU2hpuVjVqrhRAJfI0_rL4'),
(7, 'enable_signup', 'yes'),
(8, 'walkscore_api', 'c7167e71480903acb6db6516a10ec93a'),
(9, 'banner', '["bg1.jpg","bg2.jpg", "bg3.jpg", "bg4.jpg"]');

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

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

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

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

INSERT INTO `settings` (`settings_id`, `type`, `description`) VALUES
(1, 'system_name', 'Domino'),
(3, 'address', 'Impedit in aut voluptatem Eum aliquammmm'),
(4, 'phone', '+247-12-5808442222'),
(5, 'paypal', '[{"active":"1","mode":"sandbox","sandbox_client_id":"AZDxjDScFpQtjWTOUtWKbyN_bDt4OgqaF4eYXlewfBP4-8aqX3PiV8e1GWU6liB2CUXlkA59kJXE7M6R","production_client_id":"someid"}]'),
(6, 'currency', 'USD'),
(7, 'system_email', 'xovewin@hotmail.commmm'),
(10, 'language', 'english'),
(11, 'text_align', 'left-to-right'),
(17, 'currency_type', 'icon'),
(18, 'currency_placing', 'before_with_gap'),
(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}]'),
(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"]}]'),
(21, 'meta_description', 'realcon property listing'),
(22, 'key_words', 'real estate,property,listing, house'),
(23, 'crawl_after', '3'),
(24, 'fb_app_id', '244967666032203'),
(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"}]'),
(26, 'recaptcha', '[{"site_key":"6Le8NDQUAAAAAGM1TaLMRxaV5wjcywhXAWLhQVoM","secret_key":"6Le8NDQUAAAAAINMHiJGyGTYibtGWZK0p4TJRQx2"}]'),
(27, 'purchase_code', ''),
(28, 'version', '1.0'),
(29, 'copyright_text', 'Copyright 2018 | ProWebber'),
(30, 'logo', 'logo.png');

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

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

CREATE TABLE `users` (
  `user_id` int(10) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

CREATE TABLE `user_package` (
  `user_package_id` int(11) NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

CREATE TABLE `widgets` (
  `widget_id` int(11) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

--
-- Indexes for dumped tables
--

--
-- Indexes for table `amenities`
--
ALTER TABLE `amenities`
  ADD PRIMARY KEY (`amenity_id`);

--
-- Indexes for table `ci_sessions`
--
ALTER TABLE `ci_sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ci_sessions_timestamp` (`timestamp`);

--
-- Indexes for table `distance_fields`
--
ALTER TABLE `distance_fields`
  ADD PRIMARY KEY (`distance_id`);

--
-- Indexes for table `estate`
--
ALTER TABLE `estate`
  ADD PRIMARY KEY (`estate_id`);

--
-- Indexes for table `language`
--
ALTER TABLE `language`
  ADD PRIMARY KEY (`phrase_id`);

--
-- Indexes for table `location`
--
ALTER TABLE `location`
  ADD PRIMARY KEY (`location_id`);

--
-- Indexes for table `message`
--
ALTER TABLE `message`
  ADD PRIMARY KEY (`message_id`);

--
-- Indexes for table `package`
--
ALTER TABLE `package`
  ADD PRIMARY KEY (`package_id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`page_id`);

--
-- Indexes for table `realestate_settings`
--
ALTER TABLE `realestate_settings`
  ADD PRIMARY KEY (`settings_id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`settings_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`);

--
-- Indexes for table `user_package`
--
ALTER TABLE `user_package`
  ADD PRIMARY KEY (`user_package_id`);

--
-- Indexes for table `widgets`
--
ALTER TABLE `widgets`
  ADD PRIMARY KEY (`widget_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `amenities`
--
ALTER TABLE `amenities`
  MODIFY `amenity_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `distance_fields`
--
ALTER TABLE `distance_fields`
  MODIFY `distance_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `estate`
--
ALTER TABLE `estate`
  MODIFY `estate_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `language`
--
ALTER TABLE `language`
  MODIFY `phrase_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=416;
--
-- AUTO_INCREMENT for table `location`
--
ALTER TABLE `location`
  MODIFY `location_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `message`
--
ALTER TABLE `message`
  MODIFY `message_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `package`
--
ALTER TABLE `package`
  MODIFY `package_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `realestate_settings`
--
ALTER TABLE `realestate_settings`
  MODIFY `settings_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `settings_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `user_package`
--
ALTER TABLE `user_package`
  MODIFY `user_package_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `widgets`
--
ALTER TABLE `widgets`
  MODIFY `widget_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
