--
-- Host: 127.0.0.1    Database: kgs_moving
-- ------------------------------------------------------


--
-- Table structure for table `about_companies`
--

CREATE TABLE `about_companies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` int NOT NULL,
  `updated_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `about_companies`
--

INSERT INTO `about_companies` VALUES (1,'Kenchy Global Service','<p>Welcome to Kenchy Global Services, your trusted partner for professional moving, business,<br />\r\nand cleaning services. With a commitment to excellence and customer satisfaction, we provide<br />\r\nreliable, efficient, and affordable solutions tailored to meet your needs.</p>\r\n\r\n<p><br />\r\nWhether you&rsquo;re relocating to a new home, need business support, or require top-quality<br />\r\ncleaning services, our experienced team ensures a seamless experience from start to finish. We<br />\r\npride ourselves on professionalism, punctuality, and delivering high-quality service every time.</p>\r\n\r\n<p><br />\r\nAt Kenchy Global Services, we are more than just a service provider&mdash;we are your partner in<br />\r\nmaking life easier.</p>','examppxampptmpphpc3f7tmp-2025-04-03-67ede164b8bbf.jpg',1,0,1,NULL,'2025-04-02 19:16:20');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `frequently_asked_questions`
--

CREATE TABLE `frequently_asked_questions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `question` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` int NOT NULL,
  `updated_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `frequently_asked_questions`
--


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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_reset_tokens_table',1),(3,'2014_10_12_100000_create_password_resets_table',1),(4,'2019_08_19_000000_create_failed_jobs_table',1),(5,'2019_12_14_000001_create_personal_access_tokens_table',1),(6,'2022_06_28_195230_create_services_table',1),(7,'2023_06_04_110915_create_about_companies_table',1),(8,'2023_10_29_011518_create_frequently_asked_questions_table',1),(9,'2024_12_08_053412_create_teams_table',1),(10,'2024_12_18_014525_create_reviews_table',1),(11,'2024_12_29_101444_create_web_properties_table',1);

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

CREATE TABLE `reviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rating` double(10,2) DEFAULT '5.00',
  `review` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` int NOT NULL,
  `updated_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reviews`
--


--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` int NOT NULL,
  `updated_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` VALUES (1,'Moving Services','Packing, loading, unloading, furniture assembly, junk removal, and same-day delivery.','<p>Moving can be stressful, but we make it easy! Our professional movers handle everything with<br />\r\ncare and efficiency, ensuring a smooth transition for your home or business.</p>\r\n\r\n<p><br />\r\nOur Moving Services Include:<br />\r\n✔ Packing &amp; Unpacking &ndash; Secure packing to protect your belongings.<br />\r\n✔ Loading &amp; Unloading &ndash; Safe and efficient handling of heavy items.<br />\r\n✔ Furniture Assembly &ndash; Professional assembly and disassembly.<br />\r\n✔ Junk Removal &ndash; Quick and hassle-free disposal of unwanted items.<br />\r\n✔ Same-Day Delivery &ndash; Fast and reliable transport for urgent needs.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We provide residential and commercial moving services, tailored to fit your schedule and<br />\r\nbudget. Let us handle the heavy lifting while you focus on settling into your new space.</p>','exampptmpphpb22atmp-2025-04-02-67ecbb92d7054.jpg','exampptmpphpb22btmp-2025-04-02-67ecbb92e9e7e.svg',1,1,1,'2025-04-01 22:22:42','2025-04-01 22:22:42'),(2,'Cleaning Services','Residential and commercial cleaning, deep cleaning, and move-in/move-out cleaning.','<p>A clean space is a happy space! Whether you need routine cleaning or a deep clean, our team<br />\r\ndelivers spotless results every time.</p>\r\n\r\n<p><br />\r\nOur Cleaning Services Include:<br />\r\n✔ Residential Cleaning &ndash; Keep your home fresh, tidy, and hygienic.<br />\r\n✔ Commercial Cleaning &ndash; Professional office and business cleaning.<br />\r\n✔ Move-In/Move-Out Cleaning &ndash; Ensure a clean start in your new home.<br />\r\n✔ Deep Cleaning &ndash; Thorough cleaning for hard-to-reach areas.</p>\r\n\r\n<p><br />\r\nWe use high-quality, eco-friendly products to ensure a safe and effective cleaning experience.<br />\r\nBook a cleaning today and enjoy a spotless space!</p>','exampptmpphpb57etmp-2025-04-02-67ecbc16b1398.jpg','exampptmpphpb57ftmp-2025-04-02-67ecbc16b3e5e.svg',1,1,1,'2025-04-01 22:24:54','2025-04-01 22:24:54'),(3,'Business Services','Notary public, document translation, and general business support.','<p>Notary public, document translation, and general business support.</p>','exampptmpphpf071tmp-2025-04-02-67ecbc674ccc9.jpg','exampptmpphpf072tmp-2025-04-02-67ecbc674d80b.svg',1,1,1,'2025-04-01 22:26:15','2025-04-01 22:26:15'),(4,'Phone & Money Transfer','Bill payments, secure international transfers via CAM, Unitransfer, and Ria.','<p>Bill payments, secure international transfers via CAM, Unitransfer, and Ria.</p>','exampptmpphpcbdftmp-2025-04-02-67ecbc9f8271f.jpg','exampptmpphpcbe0tmp-2025-04-02-67ecbc9f83539.svg',1,1,1,'2025-04-01 22:27:11','2025-04-01 22:27:11');

--
-- Table structure for table `teams`
--

CREATE TABLE `teams` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `designation` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `linkedin_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` int NOT NULL,
  `updated_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `teams`
--


--
-- Table structure for table `web_properties`
--

CREATE TABLE `web_properties` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slogan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `support_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `business_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fb_link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter_link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `youtube_link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `youtube_video_key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin_link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `footer_text` text COLLATE utf8mb4_unicode_ci,
  `logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `count_one` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `count_one_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `count_two` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `count_two_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_signature_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_designation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_message` text COLLATE utf8mb4_unicode_ci,
  `owner_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` int NOT NULL,
  `updated_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `web_properties`
--

INSERT INTO `web_properties` VALUES (1,'Kenchy Global Service','Experts in Hassle-Free Relocation','info@kenchyglobalservices.com','support@domainname.com',NULL,'407-879-5438','#','#',NULL,NULL,'#','2817 Belco Dr Ste 4, Orlando, FL 32808',NULL,'exampptmpphp1944tmp-2025-04-02-67ecb8dc86664.png','92','15','1082','4.8','examppxampptmpphp2fd2tmp-2025-04-03-67ede180b9cb4.png','CEO Website','<p>&ldquo;Moving isn&#39;t just about transporting items, it&#39;s about embracing change and starting fresh. We&#39;re dedicated to ensuring your journey is seamless, so you can focus on settling into your new beginning.&rdquo;</p>',NULL,1,0,1,NULL,'2025-04-02 19:18:53');


