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

START TRANSACTION;



--
-- Database: `trustrater`
--

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

--
-- Table structure for table `articles`
--

CREATE TABLE `articles` (
  `id` int UNSIGNED NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `parent_id` int UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `slug`, `icon`, `parent_id`, `created_at`, `updated_at`) VALUES
(7, 'Education', 'education', NULL, NULL, '2019-06-18 13:47:42', '2024-02-12 10:19:43'),
(24, 'Advertising & Marketing', 'advertising-marketing', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(25, 'Travel & Hospitality', 'travel-hospitality', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(26, 'Business Products & Services', 'business-products-services', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(27, 'IT System Development', 'it-system-development', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(28, 'Manufacturing', 'manufacturing', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(29, 'Food & Beverage', 'food-beverage', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(30, 'Logistics & Transportation', 'logistics-transportation', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(31, 'Telecommunications', 'telecommunications', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(32, 'Insurance', 'insurance', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(33, 'Real Estate', 'real-estate', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(34, 'Financial Services', 'financial-services', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(35, 'Retail', 'retail', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(36, 'Media', 'media', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(37, 'Energy', 'energy', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(38, 'IT Services', 'it-services', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(39, 'Software', 'software', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(40, 'Engineering', 'engineering', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(41, 'Consumer Products & Services', 'consumer-products-services', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(42, 'Computer Hardware', 'computer-hardware', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(43, 'Construction', 'construction', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(44, 'Security', 'security', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(45, 'Environmental Services', 'environmental-services', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(46, 'Government Services', 'government-services', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(47, 'IT Management', 'it-management', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(48, 'Health', 'health', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38'),
(49, 'Human Resources', 'human-resources', NULL, NULL, '2024-12-26 05:59:38', '2024-12-26 05:59:38');

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

--
-- Table structure for table `faq`
--

CREATE TABLE `faq` (
  `id` int UNSIGNED NOT NULL,
  `question` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `answer` text COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `faq`
--

INSERT INTO `faq` (`id`, `question`, `answer`) VALUES
(1, 'How do I write a review?', 'To write a review, simply create an account or log in to your existing one. Use the search bar to find the business, product, or service you want to review, click on it, and select the \"Write a Review\" button. Share your honest experience, including specific details to help others make informed decisions. Once complete, submit your review for approval.'),
(2, 'Can I edit or delete my review after posting it?', 'Yes, you can edit or delete your review after posting. Log in to your account, navigate to your profile, and find the review you want to update. Click the \"Edit\" or \"Delete\" option next to the review, make the necessary changes, or remove it entirely. Please note that edits may undergo a moderation process to ensure compliance with our guidelines.'),
(3, 'Are reviews moderated? How do you ensure they are genuine?', 'We take the integrity of reviews seriously. All reviews undergo automated and manual checks to identify suspicious activity, such as fake reviews or spam. Businesses and users can flag reviews that seem inappropriate or fake. Our team investigates reported content to maintain trust and transparency on the platform.');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_12_17_114551_create_categories_table', 1),
(4, '2016_12_17_119816_create_categorizables_table', 1),
(5, '2019_01_01_000000-create_options_table', 1),
(6, '2019_03_02_131608_create_sites_table', 2),
(7, '2019_03_04_152056_create_reviews_table', 3);

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

--
-- Table structure for table `options_table`
--

CREATE TABLE `options_table` (
  `id` int UNSIGNED NOT NULL,
  `option_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `options_table`
--

INSERT INTO `options_table` (`id`, `option_name`, `option_value`) VALUES
(5, 'currency_symbol', '$'),
(6, 'currency_code', 'USD'),
(7, 'paypalEnable', 'Yes'),
(8, 'stripeEnable', 'Yes'),
(13, 'seo_title', 'PHP TrustRater - Business Reviews Saas Platform'),
(14, 'seo_desc', 'PHP Trusted Reviews description meta tag'),
(15, 'seo_keys', 'php trusted reviews, reviews'),
(16, 'extra_js', NULL),
(17, 'site_title', 'TrustRater'),
(18, 'site_description', '#1 Community Trusted Reviews'),
(19, 'site_belowDescription', 'From People Like You'),
(20, 'paypal_email', 'you@paypal.com'),
(22, 'sideAd', NULL),
(23, 'homeAd', NULL),
(24, 'catAd', NULL),
(25, 'license_key', NULL),
(44, 'seo_description', 'Discover a powerful business reviews platform that connects consumers and businesses. Share and read authentic reviews, build trust, and make informed decisions'),
(45, 'seo_keywords', 'reviews, community reviews, company reviews'),
(46, 'homepage_headline', '#1 Community Trusted'),
(47, 'homepage_subheadline', 'From People Like You'),
(48, 'logo', NULL),
(49, 'home_header_image', NULL),
(50, 'can_guests_suggest_company', 'No'),
(51, 'homepage_underlined', 'Reviews'),
(54, 'paypal_enable', 'No'),
(55, 'stripe_public', ''),
(56, 'stripe_private', ''),
(57, 'stripe_enable', 'No'),
(58, 'monthly_price', '9'),
(59, 'yearly_price', '69'),
(60, 'six_months_price', '39'),
(65, 'sidebarAdCode', ''),
(66, 'homepageAdCode', NULL),
(67, 'stripe_whsec', ''),
(68, 'autoapprove_reviews', NULL),
(69, 'autoapprove_companies', NULL),
(70, 'footer_description', 'Discover honest reviews, share your experiences, and make informed decisions. Our platform connects you with real user feedback on businesses.'),
(71, 'cf_turnstile_enable', 'No'),
(72, 'cf_turnstile_key', NULL),
(73, 'cf_turnstile_secret', NULL);

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

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

CREATE TABLE `pages` (
  `id` int UNSIGNED NOT NULL,
  `page_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `page_slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `page_content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `pages` (`id`, `page_title`, `page_slug`, `page_content`, `created_at`, `updated_at`) VALUES
(3, 'Privacy Policy', 'privacy-policy', '<p>This Privacy Policy describes how your personal information is collected, used, and shared when you visit or make a purchase from https://your-domain.com (the \"Site\"). Continuing using this site means you agree to all of the mentions below.</p>\r\n<p><strong><span style=\"font-size: 18pt;\">Personal information we collect</span></strong></p>\r\n<p>When you visit the Site, we automatically collect certain information about your device, including information about your web browser, IP address, time zone, and some of the cookies that are installed on your device. Additionally, as you browse the Site, we collect information about the individual web pages or products that you view, what websites or search terms referred you to the Site, and information about how you interact with the Site. We refer to this automatically-collected information as \"Device Information.\"</p>\r\n<p><span style=\"font-size: 12pt;\">We collect Device Information using the following technologies:</span></p>\r\n<p>- \"Cookies\" are data files that are placed on your device or computer and often include an anonymous unique identifier. For more information about cookies, and how to disable cookies, visit cookiesandyou.com.</p>\r\n<p>- &ldquo;Log files&rdquo; track actions occurring on the Site, and collect data including your IP address, browser type, Internet service provider, referring/exit pages, and date/time stamps.</p>\r\n<p>The payments on our marketplace are made via Paypal and Stripe, so we do not store any transactions related information, like credit card number, billing information etc. We do however store the payment gateway transaction ID for easier reference in case of any disputes. We refer to this information as &ldquo;Order Information.&rdquo;</p>\r\n<p>When we talk about \"Personal Information\" in this Privacy Policy, we are talking both about Device Information and Order Information.</p>\r\n<p><span style=\"font-size: 18pt;\"><strong>How do we use your personal information?</strong></span></p>\r\n<p>We use the Order Information that we collect generally to fulfill any orders placed through the Site. Additionally, we use this Order Information to:</p>\r\n<p>Communicate with you, Screen our orders for potential risk or fraud; and When in line with the preferences you have shared with us, provide you with information or advertising relating to our products or services</p>\r\n<p>We use the Device Information that we collect to help us screen for potential risk and fraud (in particular, your IP address), and more generally to improve and optimize our Site (for example, by generating analytics about how our customers browse and interact with the Site, and to assess the success of our marketing and advertising campaigns).</p>\r\n<p><strong><span style=\"font-size: 18pt;\">Sharing your personal information</span></strong></p>\r\n<p>We do not share your Personal Information with third parties.</p>\r\n<p>We use Google Analytics to help us understand how our customers use the Site. You can read more about how Google uses your Personal Information on their site. You can also opt-out of Google Analytics .</p>\r\n<p>Finally, we may also share limited Personal Information to comply with applicable laws and regulations, to respond to a subpoena, search warrant or other lawful request for information we receive, or to otherwise protect our rights.</p>\r\n<p><span style=\"font-size: 18pt;\"><strong>Do not track</strong></span></p>\r\n<p>Please note that we do not alter our Site&rsquo;s data collection and use practices when we see a Do Not Track signal from your browser.</p>\r\n<p><strong><span style=\"font-size: 18pt;\">Your rights</span></strong></p>\r\n<p>If you are a European resident, you have the right to access personal information we hold about you and to ask that your personal information be corrected, updated, or deleted. If you would like to exercise this right, please contact us through the contact information below.</p>\r\n<p>Additionally, if you are a European resident we note that we are processing your information in order to fulfill contracts we might have with you (for example if you make an order through the Site), or otherwise to pursue our legitimate business interests listed above.</p>\r\n<p><span style=\"font-size: 18pt;\"><strong>Data retention</strong></span></p>\r\n<p>When you place an order through the Site, we will maintain your Order Information for our records unless and until you ask us to delete this information.</p>\r\n<p><strong><span style=\"font-size: 18pt;\">Changes</span></strong></p>\r\n<p>We may update this privacy policy from time to time in order to reflect, for example, changes to our practices or for other operational, legal or regulatory reasons.</p>\r\n<p><strong><span style=\"font-size: 18pt;\">Contact us</span></strong></p>\r\n<p>For more information about our privacy practices, if you have questions, or if you would like to make a complaint, please get in touch by sending us a contact message.</p>', '2016-08-28 05:46:04', '2016-08-28 05:46:04'),
(4, 'Terms of Service', 'terms-of-service', '<p><strong><span style=\"font-size: 18pt;\">Overview</span></strong></p>\n<p>This website is operated by Your site name here. Throughout the site, the terms &ldquo;we&rdquo;, &ldquo;us&rdquo; and &ldquo;our&rdquo; refer to Your site name here. Your site name here offers this website, including all information, tools and services available from this site to you, the user, conditioned upon your acceptance of all terms, conditions, policies and notices stated here.</p>\n<p>By visiting our site and/ or purchasing something from us, you engage in our &ldquo;Service&rdquo; and agree to be bound by the following terms and conditions (&ldquo;Terms of Service&rdquo;, &ldquo;Terms&rdquo;), including those additional terms and conditions and policies referenced herein and/or available by hyperlink. These Terms of Service apply&nbsp; to all users of the site, including without limitation users who are browsers, vendors, customers, merchants, and/ or contributors of content.</p>\n<p>Please read these Terms of Service carefully before accessing or using our website. By accessing or using any part of the site, you agree to be bound by these Terms of Service. If you do not agree to all the terms and conditions of this agreement, then you may not access the website or use any services. If these Terms of Service are considered an offer, acceptance is expressly limited to these Terms of Service.</p>\n<p>Any new features or tools which are added to the current store shall also be subject to the Terms of Service. You can review the most current version of the Terms of Service at any time on this page. We reserve the right to update, change or replace any part of these Terms of Service by posting updates and/or changes to our website. It is your responsibility to check this page periodically for changes. Your continued use of or access to the website following the posting of any changes constitutes acceptance of those changes.</p>\n<p><strong><span style=\"font-size: 18pt;\">Platform Terms</span></strong></p>\n<p>By agreeing to these Terms of Service, you represent that you are at least the age of majority in your state or province of residence, or that you are the age of majority in your state or province of residence and you have given us your consent to allow any of your minor dependents to use this site.</p>\n<p>You may not use our products for any illegal or unauthorized purpose nor may you, in the use of the Service, violate any laws in your jurisdiction (including but not limited to copyright laws).</p>\n<p>You must not transmit any worms or viruses or any code of a destructive nature.</p>\n<p>A breach or violation of any of the Terms will result in an immediate termination of your Services.</p>\n<p><strong><span style=\"font-size: 18pt;\">General Conditions</span></strong></p>\n<p>We reserve the right to refuse service to anyone for any reason at any time.</p>\n<p>You understand that your content (not including credit card information), may be transferred unencrypted and involve (a) transmissions over various networks; and (b) changes to conform and adapt to technical requirements of connecting networks or devices. Credit card information is always encrypted during transfer over networks.</p>\n<p>You agree not to reproduce, duplicate, copy, sell, resell or exploit any portion of the Service, use of the Service, or access to the Service or any contact on the website through which the service is provided, without express written permission by us.</p>\n<p>The headings used in this agreement are included for convenience only and will not limit or otherwise affect these Terms.</p>\n<p>Accuracy, Completeness And Timeliness Of Information</p>\n<p>We are not responsible if information made available on this site is not accurate, complete or current. The material on this site is provided for general information only and should not be relied upon or used as the sole basis for making decisions without consulting primary, more accurate, more complete or more timely sources of information. Any reliance on the material on this site is at your own risk.</p>\n<p>This site may contain certain historical information. Historical information, necessarily, is not current and is provided for your reference only. We reserve the right to modify the contents of this site at any time, but we have no obligation to update any information on our site. You agree that it is your responsibility to monitor changes to our site.</p>\n<p><strong><span style=\"font-size: 18pt;\">Modifications To The Service And Prices</span></strong></p>\n<p>Prices for our products are subject to change without notice.</p>\n<p>We reserve the right at any time to modify or discontinue the Service (or any part or content thereof) without notice at any time.</p>\n<p>We shall not be liable to you or to any third-party for any modification, price change, suspension or discontinuance of the Service.</p>\n<p><strong><span style=\"font-size: 18pt;\">Products And Services</span></strong></p>\n<p>Certain products or services may be available exclusively online through the website. These products or services may have limited quantities and are subject to return or exchange only according to our Return Policy.</p>\n<p>We have made every effort to display as accurately as possible the colors and images of our products that appear at the store. We cannot guarantee that your computer monitor\'s display of any color will be accurate.</p>\n<p>We reserve the right, but are not obligated, to limit the sales of our products or Services to any person, geographic region or jurisdiction. We may exercise this right on a case-by-case basis. We reserve the right to limit the quantities of any products or services that we offer. All descriptions of products or product pricing are subject to change at anytime without notice, at the sole discretion of our users. Users reserve the right to discontinue any product at any time. Any offer for any product or service made on this site is void where prohibited.</p>\n<p>We do not warrant that the quality of any products, services, information, or other material purchased or obtained by you will meet your expectations, or that any errors in the Service will be corrected.</p>\n<p><strong><span style=\"font-size: 18pt;\">Accuracy Of Billing And Account Information</span></strong></p>\n<p>We reserve the right to refuse any order you place with us. We may, in our sole discretion, limit or cancel quantities purchased per person, per household or per order. These restrictions may include orders placed by or under the same customer account, the same credit card, and/or orders that use the same billing and/or shipping address. In the event that we make a change to or cancel an order, we may attempt to notify you by contacting the e-mail and/or billing address/phone number provided at the time the order was made. We reserve the right to limit or prohibit orders that, in our sole judgment, appear to be placed by dealers, resellers or distributors.</p>\n<p>You agree to provide current, complete and accurate purchase and account information for all purchases made at our store.</p>\n<p>For more detail, please review our Returns Policy.</p>\n<p><strong><span style=\"font-size: 18pt;\">Optional Tools</span></strong></p>\n<p>We may provide you with access to third-party tools over which we neither monitor nor have any control nor input.</p>\n<p>You acknowledge and agree that we provide access to such tools &rdquo;as is&rdquo; and &ldquo;as available&rdquo; without any warranties, representations or conditions of any kind and without any endorsement. We shall have no liability whatsoever arising from or relating to your use of optional third-party tools.</p>\n<p>Any use by you of optional tools offered through the site is entirely at your own risk and discretion and you should ensure that you are familiar with and approve of the terms on which tools are provided by the relevant third-party provider(s).</p>\n<p>We may also, in the future, offer new services and/or features through the website (including, the release of new tools and resources). Such new features and/or services shall also be subject to these Terms of Service.</p>\n<p><strong><span style=\"font-size: 18pt;\">Third-party Links</span></strong></p>\n<p>Certain content, products and services available via our Service may include materials from third-parties.</p>\n<p>Third-party links on this site may direct you to third-party websites that are not affiliated with us. We are not responsible for examining or evaluating the content or accuracy and we do not warrant and will not have any liability or responsibility for any third-party materials or websites, or for any other materials, products, or services of third-parties.</p>\n<p>We are not liable for any harm or damages related to the purchase or use of goods, services, resources, content, or any other transactions made in connection with any third-party websites. Please review carefully the third-party\'s policies and practices and make sure you understand them before you engage in any transaction. Complaints, claims, concerns, or questions regarding third-party products should be directed to the third-party.</p>\n<p><span style=\"font-size: 18pt;\"><strong>User Comments, Feedback And Other Submissions</strong></span></p>\n<p>If, at our request, you send certain specific submissions (for example contest entries) or without a request from us you send creative ideas, suggestions, proposals, plans, or other materials, whether online, by email, by postal mail, or otherwise (collectively, \'comments\'), you agree that we may, at any time, without restriction, edit, copy, publish, distribute, translate and otherwise use in any medium any comments that you forward to us. We are and shall be under no obligation (1) to maintain any comments in confidence; (2) to pay compensation for any comments; or (3) to respond to any comments.</p>\n<p>We may, but have no obligation to, monitor, edit or remove content that we determine in our sole discretion are unlawful, offensive, threatening, libelous, defamatory, pornographic, obscene or otherwise objectionable or violates any party&rsquo;s intellectual property or these Terms of Services</p>\n<p>You agree that your comments will not violate any right of any third-party, including copyright, trademark, privacy, personality or other personal or proprietary right. You further agree that your comments will not contain libelous or otherwise unlawful, abusive or obscene material, or contain any computer virus or other malware that could in any way affect the operation of the Service or any related website. You may not use a false e-mail address, pretend to be someone other than yourself, or otherwise mislead us or third-parties as to the origin of any comments. You are solely responsible for any comments you make and their accuracy. We take no responsibility and assume no liability for any comments posted by you or any third-party.</p>\n<p>Your submission of personal information through the store is governed by our Privacy Policy.</p>\n<p><strong><span style=\"font-size: 18pt;\">Errors, Inaccuracies And Omissions</span></strong></p>\n<p>Occasionally there may be information on our site or in the Service that contains typographical errors, inaccuracies or omissions that may relate to product descriptions, pricing, promotions, offers, product shipping charges, transit times and availability. We reserve the right to correct any errors, inaccuracies or omissions, and to change or update information or cancel orders if any information in the Service or on any related website is inaccurate at any time without prior notice (including after you have submitted your order).</p>\n<p>We undertake no obligation to update, amend or clarify information in the Service or on any related website, including without limitation, pricing information, except as required by law. No specified update or refresh date applied in the Service or on any related website, should be taken to indicate that all information in the Service or on any related website has been modified or updated.</p>\n<p><strong><span style=\"font-size: 18pt;\">Prohibited Uses</span></strong></p>\n<p>In addition to other prohibitions as set forth in the Terms of Service, you are prohibited from using the site or its content: (a) for any unlawful purpose; (b) to solicit others to perform or participate in any unlawful acts; (c) to violate any international, federal, provincial or state regulations, rules, laws, or local ordinances; (d) to infringe upon or violate our intellectual property rights or the intellectual property rights of others; (e) to harass, abuse, insult, harm, defame, slander, disparage, intimidate, or discriminate based on gender, sexual orientation, religion, ethnicity, race, age, national origin, or disability; (f) to submit false or misleading information; (g) to upload or transmit viruses or any other type of malicious code that will or may be used in any way that will affect the functionality or operation of the Service or of any related website, other websites, or the Internet; (h) to collect or track the personal information of others; (i) to spam, phish, pharm, pretext, spider, crawl, or scrape; (j) for any obscene or immoral purpose; or (k) to interfere with or circumvent the security features of the Service or any related website, other websites, or the Internet. We reserve the right to terminate your use of the Service or any related website for violating any of the prohibited uses.</p>\n<p><strong><span style=\"font-size: 18pt;\">Disclaimer Of Warranties; Limitation Of Liability</span></strong></p>\n<p>We do not guarantee, represent or warrant that your use of our service will be uninterrupted, timely, secure or error-free.</p>\n<p>We do not warrant that the results that may be obtained from the use of the service will be accurate or reliable.</p>\n<p>You agree that from time to time we may remove the service for indefinite periods of time or cancel the service at any time, without notice to you.</p>\n<p>You expressly agree that your use of, or inability to use, the service is at your sole risk. The service and all products and services delivered to you through the service are (except as expressly stated by us) provided \'as is\' and \'as available\' for your use, without any representation, warranties or conditions of any kind, either express or implied, including all implied warranties or conditions of merchantability, merchantable quality, fitness for a particular purpose, durability, title, and non-infringement.</p>\n<p>In no case shall Your site name here, our directors, officers, employees, affiliates, agents, contractors, interns, suppliers, service providers or licensors be liable for any injury, loss, claim, or any direct, indirect, incidental, punitive, special, or consequential damages of any kind, including, without limitation lost profits, lost revenue, lost savings, loss of data, replacement costs, or any similar damages, whether based in contract, tort (including negligence), strict liability or otherwise, arising from your use of any of the service or any products procured using the service, or for any other claim related in any way to your use of the service or any product, including, but not limited to, any errors or omissions in any content, or any loss or damage of any kind incurred as a result of the use of the service or any content (or product) posted, transmitted, or otherwise made available via the service, even if advised of their possibility. Because some states or jurisdictions do not allow the exclusion or the limitation of liability for consequential or incidental damages, in such states or jurisdictions, our liability shall be limited to the maximum extent permitted by law.</p>\n<p><strong><span style=\"font-size: 18pt;\">Indemnification</span></strong></p>\n<p>You agree to indemnify, defend and hold harmless Your site name here and our parent, subsidiaries, affiliates, partners, officers, directors, agents, contractors, licensors, service providers, subcontractors, suppliers, interns and employees, harmless from any claim or demand, including reasonable attorneys&rsquo; fees, made by any third-party due to or arising out of your breach of these Terms of Service or the documents they incorporate by reference, or your violation of any law or the rights of a third-party.</p>\n<p><strong><span style=\"font-size: 18pt;\">Severability</span></strong></p>\n<p>In the event that any provision of these Terms of Service is determined to be unlawful, void or unenforceable, such provision shall nonetheless be enforceable to the fullest extent permitted by applicable law, and the unenforceable portion shall be deemed to be severed from these Terms of Service, such determination shall not affect the validity and enforceability of any other remaining provisions.</p>\n<p><strong><span style=\"font-size: 18pt;\">Termination</span></strong></p>\n<p>The obligations and liabilities of the parties incurred prior to the termination date shall survive the termination of this agreement for all purposes.</p>\n<p>These Terms of Service are effective unless and until terminated by either you or us. You may terminate these Terms of Service at any time by notifying us that you no longer wish to use our Services, or when you cease using our site.</p>\n<p>If in our sole judgment you fail, or we suspect that you have failed, to comply with any term or provision of these Terms of Service, we also may terminate this agreement at any time without notice and you will remain liable for all amounts due up to and including the date of termination; and/or accordingly may deny you access to our Services (or any part thereof).</p>\n<p><strong><span style=\"font-size: 18pt;\">Entire Agreement</span></strong></p>\n<p>The failure of us to exercise or enforce any right or provision of these Terms of Service shall not constitute a waiver of such right or provision.</p>\n<p>These Terms of Service and any policies or operating rules posted by us on this site or in respect to The Service constitutes the entire agreement and understanding between you and us and govern your use of the Service, superseding any prior or contemporaneous agreements, communications and proposals, whether oral or written, between you and us (including, but not limited to, any prior versions of the Terms of Service).Any ambiguities in the interpretation of these Terms of Service shall not be construed against the drafting party.</p>\n<p><strong><span style=\"font-size: 18pt;\">Governing Law</span></strong></p>\n<p>These Terms of Service and any separate agreements whereby we provide you Services shall be governed by and construed in accordance with the laws of Your Location Here.</p>\n<p>Changes To Terms Of Service</p>\n<p>You can review the most current version of the Terms of Service at any time at this page.</p>\n<p>We reserve the right, at our sole discretion, to update, change or replace any part of these Terms of Service by posting updates and changes to our website. It is your responsibility to check our website periodically for changes. Your continued use of or access to our website or the Service following the posting of any changes to these Terms of Service constitutes acceptance of those changes.</p>\n<p>Contact Information</p>\n<p>Questions about the Terms of Service should be sent to us over the contact page</p>', '2024-02-16 16:59:43', '2024-02-16 17:00:23');

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int UNSIGNED NOT NULL,
  `review_item_id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED DEFAULT NULL,
  `rating` tinyint UNSIGNED NOT NULL,
  `review_title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `review_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `company_reply` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `publish` enum('Yes','No') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'No'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `review_attachments`
--

CREATE TABLE `review_attachments` (
  `id` int UNSIGNED NOT NULL,
  `review_id` int UNSIGNED NOT NULL,
  `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `saas_subscriptions`
--

CREATE TABLE `saas_subscriptions` (
  `id` int UNSIGNED NOT NULL,
  `subscr_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `site_id` int UNSIGNED NOT NULL,
  `amount` double(10,2) DEFAULT NULL,
  `plan` enum('monthly','yearly','manual','six_months') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gateway` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subscr_expires` datetime DEFAULT CURRENT_TIMESTAMP,
  `subscr_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Active',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sites`
--

CREATE TABLE `sites` (
  `id` int UNSIGNED NOT NULL,
  `category_id` int UNSIGNED NOT NULL,
  `url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `autogenerate_screenshot` enum('Yes','No') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Yes',
  `uploaded_screenshot` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `business_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `claimed_by` int DEFAULT NULL,
  `submittedBy` int DEFAULT NULL,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `publish` enum('Yes','No') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'No',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `votes`
--

CREATE TABLE `votes` (
  `id` int NOT NULL,
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `review_id` int NOT NULL,
  `vote` enum('Up','Down') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'Up'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `articles`
--
ALTER TABLE `articles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `categories__lft__rgt_parent_id_index` (`parent_id`);

--
-- Indexes for table `faq`
--
ALTER TABLE `faq`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `options_table`
--
ALTER TABLE `options_table`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `options_table_option_name_unique` (`option_name`),
  ADD KEY `options_table_option_name_index` (`option_name`);

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

--
-- Indexes for table `reviews`
--
ALTER TABLE `reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reviews_review_item_id_index` (`review_item_id`),
  ADD KEY `reviews_review_item_id_rating_index` (`review_item_id`,`rating`),
  ADD KEY `reviews_review_item_id_user_id_index` (`review_item_id`,`user_id`);

--
-- Indexes for table `review_attachments`
--
ALTER TABLE `review_attachments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `saas_subscriptions`
--
ALTER TABLE `saas_subscriptions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sites`
--
ALTER TABLE `sites`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sites_url_unique` (`url`);

--
-- Indexes for table `votes`
--
ALTER TABLE `votes`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `articles`
--
ALTER TABLE `articles`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- AUTO_INCREMENT for table `faq`
--
ALTER TABLE `faq`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `options_table`
--
ALTER TABLE `options_table`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `reviews`
--
ALTER TABLE `reviews`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `review_attachments`
--
ALTER TABLE `review_attachments`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `saas_subscriptions`
--
ALTER TABLE `saas_subscriptions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sites`
--
ALTER TABLE `sites`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `votes`
--
ALTER TABLE `votes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;
COMMIT;

