Welcome to Viavi Real Estate, where we turn houses into homes and dreams into reality. This Viavi Real Estate Portal is designed to make property management and browsing a breeze, offering a robust set of features tailored to the needs of today’s real estate market.
\r\nAt Viavi Real Estate, our unwavering commitment lies in crafting unparalleled real estate journeys. Our seasoned professionals, armed with extensive market knowledge, walk alongside you through every phase of your property endeavor. We prioritize understanding your unique aspirations, tailoring our expertise to match your vision.
\r\nDiscover your dream home effortlessly. Explore diverse properties and expert guidance for a seamless buying experience.
', 'upload/placeholder_img.jpg', 'Welcome to Viavi Real Estate, where we turn houses into homes and dreams into reality. This Viavi Real Estate Portal is designed to make property management and browsing a breeze, offering a robust set of features tailored to the needs of today’s real estate market.
\r\nAt Viavi Real Estate, our unwavering commitment lies in crafting unparalleled real estate journeys. Our seasoned professionals, armed with extensive market knowledge, walk alongside you through every phase of your property endeavor. We prioritize understanding your unique aspirations, tailoring our expertise to match your vision.
\r\nDiscover your dream home effortlessly. Explore diverse properties and expert guidance for a seamless buying experience.
', 'upload/placeholder_img.jpg', 1, 'Top', NULL, NULL, NULL, NULL, 1), (2, 'Contact Us', 'contact-us', '', NULL, NULL, NULL, 2, 'Top', '3rd Floor, Shyam Complex, Parivar Park, near Mayani Chowk, Rajkot, Gujarat', '+91 9874561233', 'info@example.com', '', 1), (3, 'Privacy Policy', 'privacy-policy', 'Company Name operates the Website Name website, which provides the SERVICE.
\r\nThis page is used to inform website visitors regarding our policies with the collection, use, and disclosure of Personal Information if anyone decided to use our Service, the Website Name website.
\r\nIf you choose to use our Service, then you agree to the collection and use of information in relation with this policy. The Personal Information that we collect are used for providing and improving the Service. We will not use or share your information with anyone except as described in this Privacy Policy.
\r\nThe terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, which is accessible at Website URL, unless otherwise defined in this Privacy Policy.
\r\nFor a better experience while using our Service, we may require you to provide us with certain personally identifiable information, including but not limited to your name, phone number, and postal address. The information that we collect will be used to contact or identify you.
\r\nWe want to inform you that whenever you visit our Service, we collect information that your browser sends to us that is called Log Data. This Log Data may include information such as your computer\\\'s Internet Protocol (“IP”) address, browser version, pages of our Service that you visit, the time and date of your visit, the time spent on those pages, and other statistics.
\r\nCookies are files with small amount of data that is commonly used an anonymous unique identifier. These are sent to your browser from the website that you visit and are stored on your computer\\\'s hard drive.
\r\nOur website uses these “cookies” to collection information and to improve our Service. You have the option to either accept or refuse these cookies, and know when a cookie is being sent to your computer. If you choose to refuse our cookies, you may not be able to use some portions of our Service.
\r\nWe may employ third-party companies and individuals due to the following reasons:
\r\nWe want to inform our Service users that these third parties have access to your Personal Information. The reason is to perform the tasks assigned to them on our behalf. However, they are obligated not to disclose or use the information for any other purpose.
\r\nWe value your trust in providing us your Personal Information, thus we are striving to use commercially acceptable means of protecting it. But remember that no method of transmission over the internet, or method of electronic storage is 100% secure and reliable, and we cannot guarantee its absolute security.
\r\nOur Service may contain links to other sites. If you click on a third-party link, you will be directed to that site. Note that these external sites are not operated by us. Therefore, we strongly advise you to review the Privacy Policy of these websites. We have no control over, and assume no responsibility for the content, privacy policies, or practices of any third-party sites or services.
\r\nChildren\\\'s Privacy
\r\nOur Services do not address anyone under the age of 13. We do not knowingly collect personal identifiable information from children under 13. In the case we discover that a child under 13 has provided us with personal information, we immediately delete this from our servers. If you are a parent or guardian and you are aware that your child has provided us with personal information, please contact us so that we will be able to do necessary actions.
\r\nWe may update our Privacy Policy from time to time. Thus, we advise you to review this page periodically for any changes. We will notify you of any changes by posting the new Privacy Policy on this page. These changes are effective immediately, after they are posted on this page.
\r\nIf you have any questions or suggestions about our Privacy Policy, do not hesitate to contact us.
', NULL, NULL, NULL, 3, 'Bottom', NULL, NULL, NULL, NULL, 1), (4, 'Terms Of Use', 'terms-of-use', 'Use of this site is provided by Demos subject to the following Terms and Conditions:
1. Your use constitutes acceptance of these Terms and Conditions as at the date of your first use of the site.
2. Demos reserves the rights to change these Terms and Conditions at any time by posting changes online. Your continued use of this site after changes are posted constitutes your acceptance of this agreement as modified.
3. You agree to use this site only for lawful purposes, and in a manner which does not infringe the rights, or restrict, or inhibit the use and enjoyment of the site by any third party.
4. This site and the information, names, images, pictures, logos regarding or relating to Demos are provided “as is” without any representation or endorsement made and without warranty of any kind whether express or implied. In no event will Demos be liable for any damages including, without limitation, indirect or consequential damages, or any damages whatsoever arising from the use or in connection with such use or loss of use of the site, whether in contract or in negligence.
5. Demos does not warrant that the functions contained in the material contained in this site will be uninterrupted or error free, that defects will be corrected, or that this site or the server that makes it available are free of viruses or bugs or represents the full functionality, accuracy and reliability of the materials.
6. Copyright restrictions: please refer to our Creative Commons license terms governing the use of material on this site.
7. Demos takes no responsibility for the content of external Internet Sites.
8. Any communication or material that you transmit to, or post on, any public area of the site including any data, questions, comments, suggestions, or the like, is, and will be treated as, non-confidential and non-proprietary information.
9. If there is any conflict between these Terms and Conditions and rules and/or specific terms of use appearing on this site relating to specific material then the latter shall prevail.
10. These terms and conditions shall be governed and construed in accordance with the laws of England and Wales. Any disputes shall be subject to the exclusive jurisdiction of the Courts of England and Wales.
11. If these Terms and Conditions are not accepted in full, the use of this site must be terminated immediately.
We’re sorry to see you go! Follow the steps below to manually delete your account. Please note that this action is irreversible, and all your data will be permanently removed.
\r\nPrepare Your Request
\r\nCompose an Email
\r\nSubject Line
\r\nEmail Body
\r\nSend the Email
\r\nWait for Confirmation
\r\nIf you encounter any issues or need further assistance, please contact our support team at support@example.com.
\r\nThank you for using our service!
', NULL, NULL, NULL, 4, 'Bottom', NULL, NULL, NULL, NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `id` int(11) UNSIGNED NOT NULL, `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `payment_gateway` -- CREATE TABLE `payment_gateway` ( `id` int(11) UNSIGNED NOT NULL, `gateway_name` varchar(255) NOT NULL, `gateway_short_info` varchar(255) DEFAULT NULL, `gateway_info` text DEFAULT NULL, `status` int(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `payment_gateway` -- INSERT INTO `payment_gateway` (`id`, `gateway_name`, `gateway_short_info`, `gateway_info`, `status`) VALUES (1, 'Paypal', 'For international payment', '{\"mode\":\"sandbox\",\"paypal_client_id\":null,\"paypal_secret\":null}', 0), (2, 'Stripe', 'For International Payment', '{\"stripe_secret_key\":null,\"stripe_publishable_key\":null}', 0), (3, 'Razorpay', 'Pay with Wallets and UPI', '{\"razorpay_key\":null,\"razorpay_secret\":null}', 0), (4, 'Paystack', 'Payments for Nigeria', '{\"paystack_secret_key\":null,\"paystack_public_key\":null}', 0), (6, 'PayUMoney', 'Pay with Wallets and UPI', '{\"mode\":\"sandbox\",\"payu_merchant_id\":null,\"payu_key\":null,\"payu_salt\":null}', 0), (8, 'Flutterwave', 'Payments for Africa', '{\"flutterwave_public_key\":null,\"flutterwave_secret_key\":null,\"flutterwave_encryption_key\":null}', 0), (12, 'Bank Transfer', 'Manual Bank Transfer', '{\"banktransfer_info\":\"Account<\\/strong>: 2223330032299999 If you have any questions, you can contact customer support at any time.<\\/p>\"}', 1),
(13, 'Braintree', 'For International Payment', '{\"mode\":\"sandbox\",\"braintree_merchant_id\":null,\"braintree_public_key\":null,\"braintree_private_key\":null,\"braintree_merchant_account_id\":null}', 0),
(14, 'SSLCOMMERZ', 'Payment for Bangladesh', '{\"mode\":\"sandbox\",\"store_id\":\"viavi66f54bdb5c9cc\",\"store_password\":\"viavi66f54bdb5c9cc@ssl\"}', 0),
(15, 'CinetPay', 'CinetPay for West Africa and Central Africa', '{\"mode\":\"sandbox\",\"cinetpay_api_key\":\"903676224645c928b7f5758.24192977\",\"cinetpay_secret_key\":\"193562810164d367aebab324.18559187\",\"cinetpay_site_id\":\"608738\"}', 0);
-- --------------------------------------------------------
--
-- Table structure for table `post_views`
--
CREATE TABLE `post_views` (
`id` bigint(11) UNSIGNED NOT NULL,
`post_id` int(11) NOT NULL,
`post_type` varchar(255) NOT NULL,
`post_views` int(11) NOT NULL DEFAULT 0,
`post_download` int(11) NOT NULL DEFAULT 0,
`date` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `post_views`
--
INSERT INTO `post_views` (`id`, `post_id`, `post_type`, `post_views`, `post_download`, `date`) VALUES
(2, 67, 'Property', 1, 0, 1767571200);
-- --------------------------------------------------------
--
-- Table structure for table `property`
--
CREATE TABLE `property` (
`id` int(11) UNSIGNED NOT NULL,
`user_id` int(11) NOT NULL,
`type_id` int(11) NOT NULL,
`location_id` int(11) DEFAULT NULL,
`title` varchar(255) NOT NULL,
`slug` varchar(255) DEFAULT NULL,
`description` text DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`address` varchar(500) DEFAULT NULL,
`latitude` varchar(255) DEFAULT NULL,
`longitude` varchar(255) DEFAULT NULL,
`purpose` varchar(255) DEFAULT NULL,
`bedrooms` varchar(255) DEFAULT NULL,
`bathrooms` varchar(255) DEFAULT NULL,
`area` varchar(255) DEFAULT NULL,
`furnishing` varchar(255) DEFAULT NULL,
`amenities` varchar(255) DEFAULT NULL,
`price` int(11) DEFAULT NULL,
`verified` varchar(255) NOT NULL,
`image` varchar(255) NOT NULL,
`floor_plan_image` varchar(255) DEFAULT NULL,
`featured` int(1) NOT NULL DEFAULT 0,
`status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `property`
--
INSERT INTO `property` (`id`, `user_id`, `type_id`, `location_id`, `title`, `slug`, `description`, `phone`, `address`, `latitude`, `longitude`, `purpose`, `bedrooms`, `bathrooms`, `area`, `furnishing`, `amenities`, `price`, `verified`, `image`, `floor_plan_image`, `featured`, `status`) VALUES
(59, 1, 3, 3, 'Spacious House Estate in New York, USA 830', 'spacious-house-estate-in-new-york-usa-830-uh8euc', 'Well maintained House located in New York, USA. Close to local amenities and public transport.', '9212845537', '798 Hill Ave, New York, USA', '40.6578', '-73.833', 'Sale', '3', '2', '817 Sq-ft', 'Unfurnished', 'Gym,Air conditioning,Security,Lift,Garden,Parking', 183089, 'YES', 'upload/placeholder_img.jpg', 'upload/generator-42ecc7a29d9f4f1429c2033197830134.jpg', 0, 1),
(60, 1, 3, 3, 'Quiet House Retreat in New York, USA 880', 'quiet-house-retreat-in-new-york-usa-880-s37nvg', 'Well maintained House located in New York, USA. Close to local amenities and public transport.', '9508614160', '518 Sunset Rd, New York, USA', '40.6308', '-74.164', 'Sale', '4', '3', '1782 Sq-ft', 'Semi-Furnished', 'Lift,Garden,Gym', 325473, 'YES', 'upload/placeholder_img.jpg', 'upload/placeholder_img.jpg', 0, 1),
(61, 1, 3, 3, 'Cozy House Home in New York, USA 968', 'cozy-house-home-in-new-york-usa-968-rbuzxc', 'Well maintained House located in New York, USA. Close to local amenities and public transport.', '9757527344', '612 Cedar St, New York, USA', '40.5898', '-74.202', 'Sale', '4', '4', '696 Sq-ft', 'Unfurnished', 'Lift,Parking,Air conditioning,Pool,Gym', 487513, 'YES', 'upload/generator-1419c48b490b8045eb1ec62cdc19e37f.jpg', 'upload/generator-dbd993c2b2ce10a762cc9a04a6c6cc14.jpg', 0, 1),
(62, 1, 3, 3, 'Luxury House Home in New York, USA 842', 'luxury-house-home-in-new-york-usa-842-0jmpmx', 'Well maintained House located in New York, USA. Close to local amenities and public transport.', '9794872296', '219 Park St, New York, USA', '40.7748', '-74.178', 'Sale', '5', '1', '2436 Sq-ft', 'Furnished', 'Pool,Lift,Balcony,Security,Air conditioning,Garden', 157856, 'YES', 'upload/generator-1419c48b490b8045eb1ec62cdc19e37f.jpg', 'upload/generator-1419c48b490b8045eb1ec62cdc19e37f.jpg', 0, 1),
(63, 1, 3, 3, 'Classic House Suite in New York, USA 118', 'classic-house-suite-in-new-york-usa-118-wjfboq', 'Well maintained House located in New York, USA. Close to local amenities and public transport.', '9107327185', '440 Garden Blvd, New York, USA', '40.5818', '-74.103', 'Sale', '2', '1', '2388 Sq-ft', 'Semi-Furnished', 'Internet,Gym,CCTV,Parking,Security', 383976, 'YES', 'upload/generator-1419c48b490b8045eb1ec62cdc19e37f.jpg', 'upload/placeholder_img.jpg', 0, 1),
(64, 1, 3, 3, 'Cozy House Suite in New York, USA 526', 'cozy-house-suite-in-new-york-usa-526-hczllw', 'Well maintained House located in New York, USA. Close to local amenities and public transport.', '9870683576', '618 Lake Ave, New York, USA', '40.8388', '-73.977', 'Sale', '5', '1', '3423 Sq-ft', 'Furnished', 'Garden,Pool,Gym', 157721, 'YES', 'upload/generator-1419c48b490b8045eb1ec62cdc19e37f.jpg', 'upload/placeholder_img.jpg', 0, 1),
(67, 1, 3, 3, 'Modern House Place in New York, USA 679', 'modern-house-place-in-new-york-usa-679-e43z8q', 'Well maintained House located in New York, USA. Close to local amenities and public transport.', '9373142381', '482 Main Rd, New York, USA', '40.6278', '-74.139', 'Sale', '1', '1', '2711 Sq-ft', 'Semi-Furnished', 'Gym,Air conditioning,CCTV,Security,Balcony', 420896, 'YES', 'upload/generator-dbd993c2b2ce10a762cc9a04a6c6cc14.jpg', 'upload/generator-42ecc7a29d9f4f1429c2033197830134.jpg', 0, 1),
(68, 1, 3, 3, 'Charming House Suite in New York, USA 809', 'charming-house-suite-in-new-york-usa-809-jq1ed5', 'Well maintained House located in New York, USA. Close to local amenities and public transport.', '9348326782', '168 Main Ln, New York, USA', '40.7248', '-73.819', 'Sale', '2', '2', '2509 Sq-ft', 'Furnished', 'Parking,Garden,Lift,CCTV,Air conditioning,Pool', 124124, 'YES', 'upload/generator-1419c48b490b8045eb1ec62cdc19e37f.jpg', 'upload/generator-1419c48b490b8045eb1ec62cdc19e37f.jpg', 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `property_gallery`
--
CREATE TABLE `property_gallery` (
`id` int(11) UNSIGNED NOT NULL,
`post_id` int(11) NOT NULL,
`image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `property_gallery`
--
INSERT INTO `property_gallery` (`id`, `post_id`, `image`) VALUES
(133, 59, 'upload/generator-dbd993c2b2ce10a762cc9a04a6c6cc14.jpg'),
(134, 59, 'upload/generator-1419c48b490b8045eb1ec62cdc19e37f.jpg'),
(135, 59, 'upload/placeholder_img.jpg'),
(136, 60, 'upload/placeholder_img.jpg'),
(137, 61, 'upload/generator-1419c48b490b8045eb1ec62cdc19e37f.jpg'),
(138, 61, 'upload/generator-42ecc7a29d9f4f1429c2033197830134.jpg'),
(139, 61, 'upload/placeholder_img.jpg'),
(140, 62, 'upload/placeholder_img.jpg'),
(141, 62, 'upload/generator-42ecc7a29d9f4f1429c2033197830134.jpg'),
(142, 62, 'upload/generator-dbd993c2b2ce10a762cc9a04a6c6cc14.jpg'),
(143, 63, 'upload/generator-dbd993c2b2ce10a762cc9a04a6c6cc14.jpg'),
(144, 63, 'upload/placeholder_img.jpg'),
(145, 63, 'upload/generator-42ecc7a29d9f4f1429c2033197830134.jpg'),
(146, 64, 'upload/generator-dbd993c2b2ce10a762cc9a04a6c6cc14.jpg'),
(147, 64, 'upload/generator-42ecc7a29d9f4f1429c2033197830134.jpg'),
(148, 64, 'upload/generator-1419c48b490b8045eb1ec62cdc19e37f.jpg'),
(153, 67, 'upload/generator-42ecc7a29d9f4f1429c2033197830134.jpg'),
(154, 67, 'upload/generator-1419c48b490b8045eb1ec62cdc19e37f.jpg'),
(155, 68, 'upload/placeholder_img.jpg'),
(156, 68, 'upload/generator-1419c48b490b8045eb1ec62cdc19e37f.jpg'),
(157, 68, 'upload/generator-42ecc7a29d9f4f1429c2033197830134.jpg');
-- --------------------------------------------------------
--
-- Table structure for table `property_inquiries`
--
CREATE TABLE `property_inquiries` (
`id` int(11) UNSIGNED NOT NULL,
`property_id` int(11) NOT NULL DEFAULT 0,
`owner_id` int(11) NOT NULL DEFAULT 0,
`user_id` int(11) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`phone` varchar(50) DEFAULT NULL,
`message` text NOT NULL,
`date` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `property_inquiries`
--
INSERT INTO `property_inquiries` (`id`, `property_id`, `owner_id`, `user_id`, `name`, `email`, `phone`, `message`, `date`) VALUES
(1, 58, 1, 2, 'Jrjrj', 'obichibundo8@gmail.com', '838287272', 'Jdndnnd', 1767580792);
-- --------------------------------------------------------
--
-- Table structure for table `reports`
--
CREATE TABLE `reports` (
`id` int(11) UNSIGNED NOT NULL,
`user_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`post_type` varchar(255) NOT NULL,
`message` varchar(255) NOT NULL,
`date` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE `settings` (
`id` int(11) UNSIGNED NOT NULL,
`site_name` varchar(255) NOT NULL,
`site_description` varchar(255) DEFAULT NULL,
`site_keywords` varchar(255) DEFAULT NULL,
`site_logo` varchar(255) NOT NULL,
`site_favicon` varchar(255) NOT NULL,
`site_email` varchar(255) NOT NULL,
`site_header_code` text DEFAULT NULL,
`site_footer_code` text DEFAULT NULL,
`site_copyright` varchar(255) DEFAULT NULL,
`styling` varchar(255) NOT NULL DEFAULT 'stylesheet_one',
`time_zone` varchar(255) NOT NULL DEFAULT 'UTC',
`default_language` varchar(255) NOT NULL DEFAULT 'en',
`currency_code` varchar(255) NOT NULL DEFAULT 'USD',
`admin_logo` varchar(255) DEFAULT NULL,
`app_name` varchar(255) NOT NULL,
`app_email` varchar(255) NOT NULL,
`app_logo` varchar(255) NOT NULL,
`app_company` varchar(255) DEFAULT NULL,
`app_website` varchar(255) DEFAULT NULL,
`app_contact` varchar(255) DEFAULT NULL,
`app_version` varchar(255) DEFAULT NULL,
`smtp_host` varchar(255) DEFAULT NULL,
`smtp_port` varchar(255) DEFAULT NULL,
`smtp_email` varchar(255) DEFAULT NULL,
`smtp_password` varchar(255) DEFAULT NULL,
`smtp_encryption` varchar(255) DEFAULT NULL,
`google_login` varchar(255) NOT NULL DEFAULT 'false',
`google_client_id` varchar(255) DEFAULT NULL,
`google_client_secret` varchar(255) DEFAULT NULL,
`google_redirect` text DEFAULT NULL,
`contact_email` varchar(255) DEFAULT NULL,
`contact_phone` varchar(255) DEFAULT NULL,
`contact_address` varchar(500) DEFAULT NULL,
`facebook_link` varchar(255) NOT NULL,
`twitter_link` varchar(255) DEFAULT NULL,
`instagram_link` varchar(255) DEFAULT NULL,
`youtube_link` varchar(255) DEFAULT NULL,
`onesignal_app_id` varchar(255) DEFAULT NULL,
`onesignal_rest_key` varchar(255) DEFAULT NULL,
`app_update_hide_show` varchar(255) NOT NULL DEFAULT 'true',
`app_update_version_code` varchar(255) DEFAULT NULL,
`app_update_desc` varchar(255) DEFAULT NULL,
`app_update_link` varchar(255) DEFAULT NULL,
`app_update_cancel_option` varchar(255) NOT NULL DEFAULT 'true',
`pagination_limit` int(3) NOT NULL DEFAULT 10,
`latest_limit` int(3) NOT NULL DEFAULT 10,
`envato_buyer_name` varchar(255) DEFAULT NULL,
`envato_purchase_code` varchar(255) DEFAULT NULL,
`app_package_name` varchar(255) DEFAULT NULL,
`recaptcha_site_key` varchar(255) DEFAULT NULL,
`recaptcha_secret_key` varchar(255) DEFAULT NULL,
`recaptcha_on_login` int(1) NOT NULL DEFAULT 0,
`recaptcha_on_signup` int(1) NOT NULL DEFAULT 0,
`recaptcha_on_forgot_pass` int(1) NOT NULL DEFAULT 0,
`recaptcha_on_contact_us` int(1) NOT NULL DEFAULT 0,
`gdpr_cookie_on_off` int(1) NOT NULL DEFAULT 1,
`gdpr_cookie_title` varchar(500) DEFAULT NULL,
`gdpr_cookie_text` text DEFAULT NULL,
`gdpr_cookie_url` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`id`, `site_name`, `site_description`, `site_keywords`, `site_logo`, `site_favicon`, `site_email`, `site_header_code`, `site_footer_code`, `site_copyright`, `styling`, `time_zone`, `default_language`, `currency_code`, `admin_logo`, `app_name`, `app_email`, `app_logo`, `app_company`, `app_website`, `app_contact`, `app_version`, `smtp_host`, `smtp_port`, `smtp_email`, `smtp_password`, `smtp_encryption`, `google_login`, `google_client_id`, `google_client_secret`, `google_redirect`, `contact_email`, `contact_phone`, `contact_address`, `facebook_link`, `twitter_link`, `instagram_link`, `youtube_link`, `onesignal_app_id`, `onesignal_rest_key`, `app_update_hide_show`, `app_update_version_code`, `app_update_desc`, `app_update_link`, `app_update_cancel_option`, `pagination_limit`, `latest_limit`, `envato_buyer_name`, `envato_purchase_code`, `app_package_name`, `recaptcha_site_key`, `recaptcha_secret_key`, `recaptcha_on_login`, `recaptcha_on_signup`, `recaptcha_on_forgot_pass`, `recaptcha_on_contact_us`, `gdpr_cookie_on_off`, `gdpr_cookie_title`, `gdpr_cookie_text`, `gdpr_cookie_url`) VALUES
(1, 'Viavi Real Estate Script', 'Viavi Real estate made simple is lightning fast and light weight PHP script. Viavi Real estate agents work with property buyers or sellers and help them to navigate a complex nature of a property market.', 'apartment for rent, bootstrap, commercial, estate listings, google maps, house, land, property agent, property script, real estate php script, rental listings, sale, Viavi real estate app', 'upload/site_logo.png', 'upload/favicon.png', 'info@example.com', '', '', 'Copyright ┬® 2024 www.viaviweb.com All Rights Reserved.', 'stylesheet_one', 'Asia/Kolkata', 'en', 'USD', 'upload/real_estate_app_logo.png', 'Real Estate', 'info@viavilab.com', 'upload/app_icon2.png', 'Viavi Webtech', 'www.viaviweb.com', '+91 9227777522', '1.0.0', NULL, '465', NULL, NULL, 'SSL', '0', NULL, NULL, '', 'info@example.com', '+91 9876541233', '3rd Floor, Shyam Complex, Parivar Park, near Mayani Chowk, Rajkot, Gujarat', 'https://facebook.com/viaviweb', 'https://twitter.com/viaviwebtech', 'https://instagram.com/viaviwebtech', 'https://youtube.com/viaviwebtech', NULL, NULL, 'false', '1', 'Please update new app', 'https://google.com', 'true', 10, 10, NULL, NULL, 'com.app.realestateapp', NULL, NULL, 0, 0, 0, 0, 1, 'This Website Is Using Cookies', 'We use them to give you the best experience. If you continue using our website, we\\\'ll assume that you are happy to receive all cookies on this website.', '#');
-- --------------------------------------------------------
--
-- Table structure for table `subscription_plan`
--
CREATE TABLE `subscription_plan` (
`id` int(11) UNSIGNED NOT NULL,
`plan_name` varchar(255) NOT NULL,
`plan_days` int(11) NOT NULL,
`plan_duration` varchar(255) NOT NULL,
`plan_duration_type` varchar(255) NOT NULL,
`plan_price` decimal(11,2) NOT NULL,
`plan_property_limit` int(4) NOT NULL,
`status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `subscription_plan`
--
INSERT INTO `subscription_plan` (`id`, `plan_name`, `plan_days`, `plan_duration`, `plan_duration_type`, `plan_price`, `plan_property_limit`, `status`) VALUES
(2, 'Basic Plan', 7, '7', '1', 10.00, 5, 1),
(3, 'Premium Plan', 30, '1', '30', 50.00, 10, 1),
(4, 'Platinum Plan', 365, '1', '365', 99.00, 50, 1);
-- --------------------------------------------------------
--
-- Table structure for table `transaction`
--
CREATE TABLE `transaction` (
`id` int(11) UNSIGNED NOT NULL,
`user_id` int(11) NOT NULL,
`email` varchar(255) DEFAULT NULL,
`plan_id` int(11) DEFAULT NULL,
`gateway` varchar(255) NOT NULL,
`payment_amount` varchar(255) NOT NULL,
`payment_id` varchar(255) NOT NULL,
`date` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `transaction`
--
INSERT INTO `transaction` (`id`, `user_id`, `email`, `plan_id`, `gateway`, `payment_amount`, `payment_id`, `date`) VALUES
(1, 2, 'obichibundo8@gmail.com', 1, 'NA', '0.00', '-', 1767580901);
-- --------------------------------------------------------
--
-- Table structure for table `type`
--
CREATE TABLE `type` (
`id` int(11) UNSIGNED NOT NULL,
`type_name` varchar(255) NOT NULL,
`type_slug` varchar(255) NOT NULL,
`type_image` varchar(255) DEFAULT NULL,
`status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `type`
--
INSERT INTO `type` (`id`, `type_name`, `type_slug`, `type_image`, `status`) VALUES
(1, 'Apartment', 'apartment', 'upload/types/apartment.png', 1),
(2, 'Commercial', 'commercial', 'upload/types/commercial.png', 1),
(3, 'House', 'house', 'upload/types/house.png', 1),
(4, 'Industrial', 'industrial', 'upload/types/industrial.png', 1),
(5, 'Land', 'land', 'upload/types/land.png', 1),
(6, 'Office', 'office', 'upload/types/office.png', 1),
(7, 'Residential', 'residential', 'upload/types/residential.png', 1);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(11) UNSIGNED NOT NULL,
`usertype` varchar(255) DEFAULT 'User',
`social_login_type` varchar(255) DEFAULT NULL,
`google_id` varchar(255) DEFAULT NULL,
`facebook_id` varchar(255) DEFAULT NULL,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`phone` varchar(255) DEFAULT NULL,
`user_image` varchar(255) DEFAULT NULL,
`plan_id` int(4) DEFAULT NULL,
`start_date` int(11) DEFAULT NULL,
`exp_date` int(11) DEFAULT NULL,
`plan_amount` float(11,2) DEFAULT NULL,
`status` int(1) NOT NULL DEFAULT 1,
`confirmation_code` varchar(255) DEFAULT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`session_id` text DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `usertype`, `social_login_type`, `google_id`, `facebook_id`, `name`, `email`, `password`, `phone`, `user_image`, `plan_id`, `start_date`, `exp_date`, `plan_amount`, `status`, `confirmation_code`, `remember_token`, `session_id`, `created_at`, `updated_at`) VALUES
(1, 'Admin', NULL, NULL, NULL, 'Viavi Webtech', 'admin@admin.com', '$2y$12$2sNGts3XlhqNNMEvSOf4b.JGb6F8BZDcG12e.KjZI1SZ6IKWJ1D2C', '9227777522', NULL, NULL, NULL, NULL, NULL, 1, NULL, 'guGeBrzDfXhAKfImcEKYHx7rAZQJ2hfJzFoo6uprF6n0tEcM5kY8QEofTELG', 'iXL5Efee1FhfiXQzxPTe2PzEfFqU3seM3b6TzvU7', '2020-03-10 01:46:45', '2024-07-23 15:52:56'),
(2, 'User', NULL, NULL, NULL, 'Nxnx', 'obichibundo8@gmail.com', '$2y$12$eTZ6l21Ploeb8lytEUj3wueuM27xnM5RlVlByj89VXgJUVDz/0J8C', NULL, NULL, 1, 1767571200, 1767657600, 0.00, 1, NULL, NULL, NULL, '2026-01-05 01:27:15', '2026-01-05 01:41:41');
-- --------------------------------------------------------
--
-- Table structure for table `web_banner_ads`
--
CREATE TABLE `web_banner_ads` (
`id` int(11) UNSIGNED NOT NULL,
`home_top` text DEFAULT NULL,
`home_bottom` text DEFAULT NULL,
`list_top` text DEFAULT NULL,
`list_bottom` text DEFAULT NULL,
`details_top` text DEFAULT NULL,
`details_bottom` text DEFAULT NULL,
`other_page_top` text DEFAULT NULL,
`other_page_bottom` text DEFAULT NULL,
`sidebar` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
--
-- Dumping data for table `web_banner_ads`
--
INSERT INTO `web_banner_ads` (`id`, `home_top`, `home_bottom`, `list_top`, `list_bottom`, `details_top`, `details_bottom`, `other_page_top`, `other_page_bottom`, `sidebar`) VALUES
(1, '', '', '', '', '', '', '', '', '');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `analytics`
--
ALTER TABLE `analytics`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `app_ads`
--
ALTER TABLE `app_ads`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `favourite`
--
ALTER TABLE `favourite`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `location`
--
ALTER TABLE `location`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
ADD PRIMARY KEY (`id`),
ADD KEY `password_resets_email_index` (`email`),
ADD KEY `password_resets_token_index` (`token`);
--
-- Indexes for table `payment_gateway`
--
ALTER TABLE `payment_gateway`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `post_views`
--
ALTER TABLE `post_views`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `property`
--
ALTER TABLE `property`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_property_user_id_type_id_location_id_status` (`user_id`,`type_id`,`location_id`,`status`);
--
-- Indexes for table `property_gallery`
--
ALTER TABLE `property_gallery`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_gallery_post_id` (`post_id`);
--
-- Indexes for table `property_inquiries`
--
ALTER TABLE `property_inquiries`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_inquiry_property_id` (`property_id`),
ADD KEY `idx_inquiry_owner_id` (`owner_id`),
ADD KEY `idx_inquiry_user_id` (`user_id`);
--
-- Indexes for table `reports`
--
ALTER TABLE `reports`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `subscription_plan`
--
ALTER TABLE `subscription_plan`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `transaction`
--
ALTER TABLE `transaction`
ADD PRIMARY KEY (`id`),
ADD KEY `idx_transaction_user_id` (`user_id`);
--
-- Indexes for table `type`
--
ALTER TABLE `type`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `web_banner_ads`
--
ALTER TABLE `web_banner_ads`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `analytics`
--
ALTER TABLE `analytics`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `app_ads`
--
ALTER TABLE `app_ads`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `favourite`
--
ALTER TABLE `favourite`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `location`
--
ALTER TABLE `location`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `password_resets`
--
ALTER TABLE `password_resets`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `payment_gateway`
--
ALTER TABLE `payment_gateway`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `post_views`
--
ALTER TABLE `post_views`
MODIFY `id` bigint(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `property`
--
ALTER TABLE `property`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;
--
-- AUTO_INCREMENT for table `property_gallery`
--
ALTER TABLE `property_gallery`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=158;
--
-- AUTO_INCREMENT for table `property_inquiries`
--
ALTER TABLE `property_inquiries`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `reports`
--
ALTER TABLE `reports`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `subscription_plan`
--
ALTER TABLE `subscription_plan`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `type`
--
ALTER TABLE `type`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `web_banner_ads`
--
ALTER TABLE `web_banner_ads`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
IFSC<\\/strong>: SBIN000123456
Bank Name<\\/strong>: SBI
Beneficiary Name<\\/strong>: John Deo<\\/p>\\r\\n
Transfer the exact amount for the payment to be successful. Please make payment only in the account number mentioned above.<\\/p>\\r\\n