-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `real_estate_script`
--

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

--
-- Table structure for table `analytics`
--

CREATE TABLE `analytics` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_ip` varchar(255) DEFAULT NULL,
  `country_code` varchar(3) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `operating_system` varchar(255) DEFAULT NULL,
  `browser` varchar(255) DEFAULT NULL,
  `date` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `app_ads`
--

CREATE TABLE `app_ads` (
  `id` int(11) UNSIGNED NOT NULL,
  `ads_name` varchar(255) DEFAULT NULL,
  `ads_info` text DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `app_ads`
--

INSERT INTO `app_ads` (`id`, `ads_name`, `ads_info`, `status`) VALUES
(1, 'Admob', '{\"publisher_id\":\"\",\"banner_on_off\":\"0\",\"banner_id\":\"\",\"interstitial_on_off\":\"0\",\"interstitial_id\":\"\",\"interstitial_clicks\":\"5\",\"native_on_off\":\"0\",\"native_id\":\"\",\"native_position\":\"7\"}', 0),
(2, 'StartApp', '{\"publisher_id\":\"208651629\",\"banner_on_off\":\"0\",\"banner_id\":\"\",\"interstitial_on_off\":\"0\",\"interstitial_id\":\"\",\"interstitial_clicks\":\"5\",\"native_on_off\":\"0\",\"native_id\":\"\",\"native_position\":\"7\"}', 0),
(3, 'Facebook', '{\"publisher_id\":\"\",\"banner_on_off\":\"0\",\"banner_id\":\"\",\"interstitial_on_off\":\"0\",\"interstitial_id\":\"\",\"interstitial_clicks\":\"5\",\"native_on_off\":\"0\",\"native_id\":\"\",\"native_position\":\"7\"}', 0),
(4, 'AppLovins MAX', '{\"publisher_id\":\"\",\"banner_on_off\":\"0\",\"banner_id\":\"\",\"interstitial_on_off\":\"0\",\"interstitial_id\":\"\",\"interstitial_clicks\":\"5\",\"native_on_off\":\"0\",\"native_id\":\"\",\"native_position\":\"7\"}', 0),
(5, 'Wortise', '{\"publisher_id\":\"a4e76baa-c4ce-4672-ba85-f2f7190bd19b\",\"banner_on_off\":\"1\",\"banner_id\":\"a2562302-14ce-476b-94d4-0c6431f1f927\",\"interstitial_on_off\":\"1\",\"interstitial_id\":\"ed6fc25c-9855-485e-9513-fed0d3acc528\",\"interstitial_clicks\":\"5\",\"native_on_off\":\"1\",\"native_id\":\"cf65ed35-4765-4955-96fc-a33cf43d5340\",\"native_position\":\"7\"}', 1),
(6, 'Unity Ads', '{\"publisher_id\":\"\",\"banner_on_off\":\"0\",\"banner_id\":\"\",\"interstitial_on_off\":\"0\",\"interstitial_id\":\"\",\"interstitial_clicks\":\"5\"}', 0);

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

--
-- Table structure for table `favourite`
--

CREATE TABLE `favourite` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `post_type` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `location` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `location` (`id`, `name`, `status`) VALUES
(3, 'New York, USA', 1);

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

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

CREATE TABLE `pages` (
  `id` int(11) UNSIGNED NOT NULL,
  `page_title` varchar(500) NOT NULL,
  `page_slug` varchar(500) NOT NULL,
  `page_content` text NOT NULL,
  `page_about_image` varchar(255) DEFAULT NULL,
  `page_about_text2` text DEFAULT NULL,
  `page_about_image2` varchar(255) DEFAULT NULL,
  `page_order` int(3) DEFAULT NULL,
  `page_position` varchar(255) NOT NULL DEFAULT 'Bottom',
  `page_contact_address` varchar(500) DEFAULT NULL,
  `page_contact_phone` varchar(255) DEFAULT NULL,
  `page_contact_email` varchar(255) DEFAULT NULL,
  `page_contact_map` varchar(500) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `pages` (`id`, `page_title`, `page_slug`, `page_content`, `page_about_image`, `page_about_text2`, `page_about_image2`, `page_order`, `page_position`, `page_contact_address`, `page_contact_phone`, `page_contact_email`, `page_contact_map`, `status`) VALUES
(1, 'About Us', 'about-us', '<h2>Welcome to Viavi Real Estate</h2>\r\n<p>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&rsquo;s real estate market.</p>\r\n<p>At 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.</p>\r\n<p>Discover your dream home effortlessly. Explore diverse properties and expert guidance for a seamless buying experience.</p>', 'upload/placeholder_img.jpg', '<h2>Discover What Sets Our Real Estate Expertise Apart</h2>\r\n<p>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&rsquo;s real estate market.</p>\r\n<p>At 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.</p>\r\n<p>Discover your dream home effortlessly. Explore diverse properties and expert guidance for a seamless buying experience.</p>', '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', '<iframe src=\\\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3692.061458662123!2d70.78399097404937!3d22.275661643790418!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3959ca4119fc5f3d%3A0x79efddff6062f51f!2sVIAVIWEB!5e0!3m2!1sen!2sin!4v1721715932201!5m2!1sen!2sin\\\" width=\\\"600\\\" height=\\\"450\\\" style=\\\"border:0;\\\" allowfullscreen=\\\"\\\" loading=\\\"lazy\\\" referrerpolicy=\\\"no-referrer-when-downgrade\\\"></iframe>', 1),
(3, 'Privacy Policy', 'privacy-policy', '<h4><strong>Privacy Policy of&nbsp;<span class=\\\"highlight preview_company_name\\\">Company Name</span></strong></h4>\r\n<p><span class=\\\"highlight preview_company_name\\\">Company Name</span>&nbsp;operates the&nbsp;<span class=\\\"highlight preview_website_name\\\">Website Name</span>&nbsp;website, which provides the SERVICE.</p>\r\n<p>This 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&nbsp;<span class=\\\"highlight preview_website_name\\\">Website Name</span>&nbsp;website.</p>\r\n<p>If 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.</p>\r\n<p>The terms used in this Privacy Policy have the same meanings as in our Terms and Conditions, which is accessible at&nbsp;<span class=\\\"highlight preview_website_url\\\">Website URL</span>, unless otherwise defined in this Privacy Policy.</p>\r\n<h4><strong>Information Collection and Use</strong></h4>\r\n<p>For 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.</p>\r\n<h4><strong>Log Data</strong></h4>\r\n<p>We 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 (&ldquo;IP&rdquo;) 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.</p>\r\n<h4><strong>Cookies</strong></h4>\r\n<p>Cookies 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.</p>\r\n<p>Our website uses these &ldquo;cookies&rdquo; 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.</p>\r\n<h4><strong>Service Providers</strong></h4>\r\n<p>We may employ third-party companies and individuals due to the following reasons:</p>\r\n<ul>\r\n<li>To facilitate our Service</li>\r\n<li>To provide the Service on our behalf</li>\r\n<li>To perform Service-related services or</li>\r\n<li>To assist us in analyzing how our Service is used.</li>\r\n</ul>\r\n<p>We 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.</p>\r\n<h4><strong>Security</strong></h4>\r\n<p>We 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.</p>\r\n<h4><strong>Links to Other Sites</strong></h4>\r\n<p>Our 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.</p>\r\n<p>Children\\\'s Privacy</p>\r\n<p>Our 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.</p>\r\n<h4><strong>Changes to This Privacy Policy</strong></h4>\r\n<p>We 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.</p>\r\n<h4><strong>Contact Us</strong></h4>\r\n<p>If you have any questions or suggestions about our Privacy Policy, do not hesitate to contact us.</p>', NULL, NULL, NULL, 3, 'Bottom', NULL, NULL, NULL, NULL, 1),
(4, 'Terms Of Use', 'terms-of-use', '<p><strong>Use of this site is provided by Demos subject to the following Terms and Conditions:</strong><br />1. Your use constitutes acceptance of these Terms and Conditions as at the date of your first use of the site.<br />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.<br />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.<br />4. This site and the information, names, images, pictures, logos regarding or relating to Demos are provided &ldquo;as is&rdquo; 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.<br />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.<br />6. Copyright restrictions: please refer to our Creative Commons license terms governing the use of material on this site.<br />7. Demos takes no responsibility for the content of external Internet Sites.<br />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.<br />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.<br />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.<br />11. If these Terms and Conditions are not accepted in full, the use of this site must be terminated immediately.</p>', NULL, NULL, NULL, 2, 'Bottom', NULL, NULL, NULL, NULL, 1),
(5, 'Delete Account Instruction', 'delete-account-instruction', '<p>We&rsquo;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.</p>\r\n<h3>Steps to Manually Delete Your Account:</h3>\r\n<ol>\r\n<li>\r\n<p><strong>Prepare Your Request</strong></p>\r\n<ul>\r\n<li>Ensure you have access to the email associated with your account.</li>\r\n<li>Have your username and any relevant account information ready.</li>\r\n</ul>\r\n</li>\r\n<li>\r\n<p><strong>Compose an Email</strong></p>\r\n<ul>\r\n<li>Open your email client.</li>\r\n<li>Create a new email addressed to our support team at <a rel=\\\"noreferrer\\\">support@example.com</a>.</li>\r\n</ul>\r\n</li>\r\n<li>\r\n<p><strong>Subject Line</strong></p>\r\n<ul>\r\n<li>Use a clear subject line such as \\\"Account Deletion Request\\\".</li>\r\n</ul>\r\n</li>\r\n<li>\r\n<p><strong>Email Body</strong></p>\r\n<ul>\r\n<li>Include the following information in the body of the email:\r\n<ul>\r\n<li>Your full name.</li>\r\n<li>Your username.</li>\r\n<li>The email address associated with your account.</li>\r\n<li>A brief statement requesting the deletion of your account.</li>\r\n<li>(Optional) A reason for deleting your account.</li>\r\n</ul>\r\n</li>\r\n</ul>\r\n</li>\r\n<li>\r\n<p><strong>Send the Email</strong></p>\r\n<ul>\r\n<li>Review the information for accuracy.</li>\r\n<li>Send the email to <a rel=\\\"noreferrer\\\">support@example.com</a>.</li>\r\n</ul>\r\n</li>\r\n<li>\r\n<p><strong>Wait for Confirmation</strong></p>\r\n<ul>\r\n<li>Our support team will process your request.</li>\r\n<li>You will receive a confirmation email once your account has been successfully deleted.</li>\r\n</ul>\r\n</li>\r\n</ol>\r\n<h3>Important Notes:</h3>\r\n<ul>\r\n<li><strong>Data Loss:</strong> All your data, including personal information, posts, and messages, will be permanently deleted and cannot be recovered.</li>\r\n<li><strong>Subscription Cancellation:</strong> Any active subscriptions will be automatically canceled. No refunds will be issued for unused portions of subscriptions.</li>\r\n<li><strong>Backup Your Data:</strong> If you wish to keep any data, make sure to download it before requesting account deletion.</li>\r\n</ul>\r\n<p>If you encounter any issues or need further assistance, please contact our support team at <a rel=\\\"noreferrer\\\">support@example.com</a>.</p>\r\n<p>Thank you for using our service!</p>', NULL, NULL, NULL, 4, 'Bottom', NULL, NULL, NULL, NULL, 1);

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

--
-- 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\":\"<p><strong>Account<\\/strong>: 2223330032299999<br \\/><strong>IFSC<\\/strong>: SBIN000123456<br \\/><strong>Bank Name<\\/strong>: SBI<br \\/><strong>Beneficiary Name<\\/strong>: John Deo<\\/p>\\r\\n<p><br \\/>Transfer the exact amount for the payment to be successful. Please make payment only in the account number mentioned above.<\\/p>\\r\\n<p>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 `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 `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 `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 `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 `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 `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 `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 `web_banner_ads`
--
ALTER TABLE `web_banner_ads`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

