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

START TRANSACTION;



--
-- Database: `kgs_moving`
--

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

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

CREATE TABLE `about_companies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `details` text NOT NULL,
  `image` varchar(191) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `about_companies` (`id`, `title`, `details`, `image`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) 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>', 'exampptmpphp9b77tmp-2025-04-02-67ecb9c237136.jpg', 1, 0, 1, NULL, '2025-04-01 22:15:26');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(191) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_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_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 `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(191) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

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

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

INSERT INTO `services` (`id`, `title`, `short_description`, `description`, `image`, `icon`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) 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(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `image` varchar(191) NOT NULL,
  `designation` varchar(191) NOT NULL,
  `linkedin_url` varchar(191) DEFAULT NULL,
  `facebook_url` varchar(191) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_id` int(11) NOT NULL COMMENT '1 => admin',
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `role_id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 1, 'admin', 'admin@gmail.com', NULL, '$2y$10$HApkmdnSQFgERhg4/QVYuuyWQXGrwq7J5UG6RGIfM0CvG0XTqEMSa', NULL, NULL, NULL);

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

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

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

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

INSERT INTO `web_properties` (`id`, `company_name`, `slogan`, `email`, `support_email`, `business_email`, `phone_no`, `fb_link`, `twitter_link`, `youtube_link`, `youtube_video_key`, `linkedin_link`, `address`, `footer_text`, `logo`, `count_one`, `count_one_text`, `count_two`, `count_two_text`, `owner_signature_image`, `owner_designation`, `owner_message`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Kenchy Global Service', NULL, 'info@kenchyglobalservices.com', NULL, NULL, '407-879-5438', '#', '#', NULL, NULL, '#', '2817 Belco Dr Ste 4, Orlando, FL 32808', NULL, 'exampptmpphp1944tmp-2025-04-02-67ecb8dc86664.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, NULL, '2025-04-01 22:13:15');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `about_companies`
--
ALTER TABLE `about_companies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `frequently_asked_questions`
--
ALTER TABLE `frequently_asked_questions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reviews`
--
ALTER TABLE `reviews`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `teams`
--
ALTER TABLE `teams`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `web_properties`
--
ALTER TABLE `web_properties`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

