-- Table structure for table `job_requests`
--

CREATE TABLE `job_requests` (
  `id` bigint UNSIGNED NOT NULL,
  `job_post_id` int NOT NULL,
  `seller_id` int NOT NULL,
  `user_id` int NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `cancel_requset` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cancel_reason_buyer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cancel_reason_seller` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `approved_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `payment_status` tinyint(1) NOT NULL,
  `project_price` double(8,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_requests`
--

INSERT INTO `job_requests` (`id`, `job_post_id`, `seller_id`, `user_id`, `description`, `status`, `cancel_requset`, `cancel_reason_buyer`, `cancel_reason_seller`, `approved_status`, `created_at`, `updated_at`, `payment_status`, `project_price`) VALUES
(1, 3, 3, 1, 'Are you a talented iOS App Developer looking to make a difference in the mobile app world? Join our team as we embark on creating innovative and user-friendly applications that enhance the mobile experience for our users.', 'approved', NULL, NULL, NULL, 'approved', '2024-07-13 09:11:44', '2025-07-03 06:48:29', 0, NULL),
(2, 6, 3, 1, 'Are you a talented iOS App Developer looking to make a difference in the mobile app world? Join our team as we embark on creating innovative and user-friendly applications that enhance the mobile experience for our users.', 'approved', NULL, NULL, NULL, 'approved', '2024-07-15 09:21:07', '2025-07-19 05:21:25', 0, NULL),
(3, 9, 3, 1, 'Are you a talented iOS App Developer looking to make a difference in the mobile app world? Join our team as we embark on creating innovative and user-friendly applications that enhance the mobile experience for our users.', 'cancel', NULL, NULL, NULL, NULL, '2024-07-15 09:21:17', '2025-07-03 05:29:33', 0, NULL),
(4, 10, 3, 1, 'Are you a talented iOS App Developer looking to make a difference in the mobile app world? Join our team as we embark on creating innovative and user-friendly applications that enhance the mobile experience for our users.', 'approved', NULL, NULL, NULL, NULL, '2024-07-15 09:21:25', '2025-07-05 03:04:59', 0, NULL),
(5, 4, 3, 1, 'Are you a talented iOS App Developer looking to make a difference in the mobile app world? Join our team as we embark on creating innovative and user-friendly applications that enhance the mobile experience for our users.', 'pending', NULL, NULL, NULL, NULL, '2024-07-15 09:21:36', '2024-07-15 09:21:36', 0, NULL),
(11, 7, 4, 1, 'vxzczx', 'cancel', NULL, NULL, NULL, 'cancel', '2025-07-05 05:15:59', '2025-07-05 05:42:55', 0, NULL),
(12, 7, 3, 1, 'sadadas', 'rejected', NULL, NULL, NULL, NULL, '2025-07-05 05:16:20', '2025-07-05 05:41:42', 0, NULL),
(14, 8, 4, 1, 'Molestiae sint dolor', 'pending', NULL, NULL, NULL, NULL, '2025-07-08 08:26:57', '2025-07-08 08:26:57', 0, NULL),
(16, 8, 3, 1, 'Ut quia est recusand', 'pending', NULL, NULL, NULL, NULL, '2025-07-08 10:25:55', '2025-07-08 10:25:55', 0, NULL),
(25, 1, 3, 1, 'Qui ea ex et ut aute', 'approved', NULL, NULL, NULL, NULL, '2025-07-28 11:51:46', '2025-07-28 11:53:05', 0, NULL),
(27, 15, 3, 1, 'Hello', 'approved', NULL, NULL, NULL, NULL, '2025-07-29 03:59:49', '2025-07-29 04:00:17', 0, NULL),
(28, 16, 3, 1, 'Are you a talented iOS App Developer looking to make a difference in the mobile app world? Join our team as we embark on creating innovative and user-friendly applications that enhance the mobile experience for our users. As an iOS App Developer, you will play a crucial role in designing, developing, and testing iOS applications that meet the needs and expectations of our diverse user base. Your creativity and technical expertise will be instrumental in bringing our app ideas to life and ensuring they deliver exceptional value and usability.', 'approved', NULL, NULL, NULL, NULL, '2025-07-29 08:37:42', '2025-07-29 08:55:50', 0, NULL),
(29, 17, 3, 1, 'I&#039;m writing to express my interest in any currently vacant or potential developer roles at [Company Name]. With [X years] of experience designing, coding, and testing software solutions, I’m passionate about creating efficient, user-friendly applications that meet today&#039;s business needs.', 'pending', NULL, NULL, NULL, NULL, '2025-07-30 03:53:32', '2025-07-30 03:53:32', 0, NULL),
(30, 17, 7, 1, 'I&#039;m writing to express my interest in any current or potential warehouse worker roles at [Company Name]. With [X years] of experience in warehouse operations, I’m skilled at ensuring efficient, organized, and safe handling of inventory and shipments.\r\n\r\nIn my previous role years a—I handled tasks such as receiving and stocking products, preparing orders for shipment, and operating forklifts and other equipment. I take pride in keeping workspaces clean and organized while meeting productivity and accuracy targets. Safety and efficiency are always top priorities in my work.', 'pending', NULL, NULL, NULL, NULL, '2025-07-30 03:56:46', '2025-07-30 03:56:46', 0, NULL),
(31, 18, 3, 1, 'I&#039;m writing to express my interest in any currently vacant or potential developer roles at [Company Name]. With [X years] of experience designing, coding, and testing software solutions, I’m passionate about creating efficient, user-friendly applications that meet today&#039;s business needs.', 'cancel', NULL, 'cancel', NULL, 'cancel', '2025-07-30 05:48:00', '2025-07-30 06:23:12', 1, NULL),
(32, 19, 3, 1, 'I&#039;m writing to express my interest in any currently vacant or potential developer roles at [Company Name]. With [X years] of experience designing, coding, and testing software solutions, I’m passionate about creating efficient, user-friendly applications that meet today&#039;s business needs.', 'cancel', NULL, NULL, 'Cancel Order seller Richard', 'cancel_pending', '2025-07-30 06:51:18', '2025-07-30 08:25:00', 1, NULL),
(33, 20, 3, 1, 'sdfsdfsd', 'cancel', NULL, 'dsfsdfsdf', NULL, 'cancel', '2025-07-30 09:34:06', '2025-07-30 09:37:29', 0, NULL),
(36, 21, 3, 1, 'There is some confusion around the cover letter and the application letter. I&amp;#039;m not about to say anyone is wrong, but for the purposes of this article, we&amp;#039;re dealing with them as two separate things—meaning a cover letter is not the same thing as an application letter.\r\n\r\nSo what is an application letter?\r\n\r\nWhile the terms cover letter and application letter are often used interchangeably, there is a difference. An application letter is often more detailed—it offers more insight into your experience and skills. But it&amp;#039;s also used to send to a company you may be interested in working with that may not have any current openings. While a cover letter is attached to a resume and should be tailored to a specific position.', 'cancel', NULL, NULL, 'sorry i can&#039;t do this', 'cancel_pending', '2025-07-30 10:48:43', '2025-07-30 10:54:34', 1, NULL),
(37, 22, 3, 1, 'There is some confusion around the cover letter and the application letter. I&amp;#039;m not about to say anyone is wrong, but for the purposes of this article, we&amp;#039;re dealing with them as two separate things—meaning a cover letter is not the same thing as an application letter.\r\n\r\nSo what is an application letter?\r\n\r\nWhile the terms cover letter and application letter are often used interchangeably, there is a difference. An application letter is often more detailed—it offers more insight into your experience and skills. But it&amp;#039;s also used to send to a company you may be interested in working with that may not have any current openings. While a cover letter is attached to a resume and should be tailored to a specific position.', 'pending', NULL, NULL, NULL, NULL, '2025-07-30 10:48:53', '2025-07-30 10:48:53', 0, NULL),
(38, 23, 3, 1, 'There is some confusion around the cover letter and the application letter. I&amp;#039;m not about to say anyone is wrong, but for the purposes of this article, we&amp;#039;re dealing with them as two separate things—meaning a cover letter is not the same thing as an application letter.\r\n\r\nSo what is an application letter?\r\n\r\nWhile the terms cover letter and application letter are often used interchangeably, there is a difference. An application letter is often more detailed—it offers more insight into your experience and skills. But it&amp;#039;s also used to send to a company you may be interested in working with that may not have any current openings. While a cover letter is attached to a resume and should be tailored to a specific position.', 'cancel', NULL, 'erert', NULL, 'cancel', '2025-07-30 11:03:52', '2025-07-30 11:06:32', 1, NULL),
(39, 24, 3, 1, 'There is some confusion around the cover letter and the application letter. I&amp;#039;m not about to say anyone is wrong, but for the purposes of this article, we&amp;#039;re dealing with them as two separate things—meaning a cover letter is not the same thing as an application letter.\r\n\r\nSo what is an application letter?\r\n\r\nWhile the terms cover letter and application letter are often used interchangeably, there is a difference. An application letter is often more detailed—it offers more insight into your experience and skills. But it&amp;#039;s also used to send to a company you may be interested in working with that may not have any current openings. While a cover letter is attached to a resume and should be tailored to a specific position.', 'approved', NULL, NULL, NULL, 'approved', '2025-07-30 11:28:22', '2025-07-30 11:29:48', 1, NULL),
(40, 27, 11, 10, 'want to interest', 'cancel', NULL, 'test', NULL, 'cancel', '2025-08-16 12:09:41', '2025-08-16 12:42:13', 1, NULL),
(41, 26, 11, 10, 'want to interest', 'approved', NULL, NULL, NULL, 'approved', '2025-08-16 12:46:32', '2025-08-16 12:55:44', 1, NULL),
(42, 28, 11, 10, 'want to apply', 'cancel', NULL, 'test', NULL, 'cancel', '2025-08-16 13:11:01', '2025-08-16 13:23:20', 1, NULL);

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

--
-- Table structure for table `job_request_files`
--

CREATE TABLE `job_request_files` (
  `id` bigint UNSIGNED NOT NULL,
  `job_request_id` int DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  `submit_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `job_request_files`
--

INSERT INTO `job_request_files` (`id`, `job_request_id`, `status`, `submit_file`, `created_at`, `updated_at`) VALUES
(24, 1, 1, 'uploads/custom-images/file-name-17516886066056.docx', '2025-07-05 04:10:06', '2025-07-05 04:10:06'),
(28, 2, 1, 'uploads/custom-images/file-name-17529022738270.zip', '2025-07-19 05:17:53', '2025-07-19 05:17:53'),
(29, 18, 1, 'uploads/custom-images/file-name-17529081939622.png', '2025-07-19 06:56:33', '2025-07-19 06:56:33'),
(30, 21, 1, 'uploads/custom-images/file-name-17536989174317.png', '2025-07-28 10:35:17', '2025-07-28 10:35:17'),
(31, 23, 1, 'uploads/custom-images/file-name-17536997535478.png', '2025-07-28 10:49:13', '2025-07-28 10:49:13'),
(32, 24, 1, 'uploads/custom-images/file-name-17537010325097.png', '2025-07-28 11:10:32', '2025-07-28 11:10:32'),
(33, 25, 1, 'uploads/custom-images/file-name-17537036511036.png', '2025-07-28 11:54:11', '2025-07-28 11:54:11'),
(34, 28, 1, 'uploads/custom-images/file-name-17537793803172.pdf', '2025-07-29 08:56:20', '2025-07-29 08:56:20'),
(35, 40, 1, 'uploads/custom-images/file-name-17553476957269.webp', '2025-08-16 12:34:55', '2025-08-16 12:34:55'),
(36, 41, 1, 'uploads/custom-images/file-name-17553489225442.webp', '2025-08-16 12:55:22', '2025-08-16 12:55:22');

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

--
-- Table structure for table `kyc_information`
--

CREATE TABLE `kyc_information` (
  `id` bigint UNSIGNED NOT NULL,
  `kyc_id` bigint UNSIGNED DEFAULT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` int NOT NULL DEFAULT '0',
  `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 `kyc_information`
--

INSERT INTO `kyc_information` (`id`, `kyc_id`, `user_id`, `file`, `message`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 3, 'uploads/custom-images/kyc-2024-08-29-02-03-01-2814.webp', '&lt;p&gt;This is my NID, please check and verified my account. Thanks&lt;/p&gt;', 1, '2024-08-29 08:03:01', '2024-08-29 08:04:03'),
(2, 2, 4, 'uploads/custom-images/kyc-2024-08-29-02-08-49-5243.webp', '&lt;p&gt;I have attached my driving license, please check and verified my account. thanks&lt;/p&gt;', 1, '2024-08-29 08:08:50', '2024-08-29 08:08:59');

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

--
-- Table structure for table `kyc_types`
--

CREATE TABLE `kyc_types` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `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 `kyc_types`
--

INSERT INTO `kyc_types` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'NID', 1, '2024-08-29 08:00:57', '2024-08-29 08:00:57'),
(2, 'Driving License', 1, '2024-08-29 08:02:04', '2024-08-29 08:02:04');

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint UNSIGNED NOT NULL,
  `lang_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang_direction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_default` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes',
  `status` int NOT NULL DEFAULT '1',
  `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 `languages`
--

INSERT INTO `languages` (`id`, `lang_name`, `lang_code`, `lang_direction`, `is_default`, `status`, `created_at`, `updated_at`) VALUES
(1, 'English', 'en', 'left_to_right', 'No', 1, '2024-05-07 11:56:30', '2024-05-07 12:01:16'),
(22, 'Hindi', 'hd', 'left_to_right', 'No', 1, '2024-07-10 05:34:58', '2024-07-10 05:34:58');

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

--
-- Table structure for table `listings`
--

CREATE TABLE `listings` (
  `id` bigint UNSIGNED NOT NULL,
  `sub_category_id` bigint UNSIGNED NOT NULL DEFAULT '0',
  `seller_id` int NOT NULL DEFAULT '0',
  `category_id` int NOT NULL,
  `thumb_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_view` bigint NOT NULL DEFAULT '0',
  `regular_price` decimal(8,2) DEFAULT NULL,
  `offer_price` decimal(8,2) DEFAULT NULL,
  `is_featured` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'disable',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'disable',
  `approved_by_admin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `tags` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `seo_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `seo_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_draft` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `listings`
--

INSERT INTO `listings` (`id`, `sub_category_id`, `seller_id`, `category_id`, `thumb_image`, `slug`, `total_view`, `regular_price`, `offer_price`, `is_featured`, `status`, `approved_by_admin`, `tags`, `seo_title`, `seo_description`, `created_at`, `updated_at`, `is_draft`) VALUES
(1, 0, 7, 2, 'uploads/custom-images/listing-2024-07-10-12-24-41-9621.webp', 'mobile-app-ios-developer-wanted', 0, NULL, NULL, 'enable', 'enable', 'approved', '[{\"value\":\"Mobile apps\"},{\"value\":\"ios apps\"},{\"value\":\"android\"}]', 'Mobile application development', 'The successful candidate should have a keen eye for detail, a passion for technology, and the ability to collaborate with cross-functional teams. If you have a proven track record of developing successful iOS applications and can bring creative ideas to the table, we would love to hear from you.', '2024-07-10 06:24:41', '2024-08-25 07:12:32', 'no'),
(2, 0, 7, 13, 'uploads/custom-images/listing-2024-07-10-01-07-02-4407.webp', 'content-writer-for-blog-articles', 0, NULL, NULL, 'enable', 'enable', 'approved', '[{\"value\":\"Mobile apps\"},{\"value\":\"ios apps\"},{\"value\":\"android\"}]', 'Mobile application development', 'The ideal candidate should be able to communicate brand messages effectively through visual elements. If you have a passion for branding and can turn ideas into visually striking logos, we want to see your portfolio.', '2024-07-10 06:24:41', '2024-07-10 07:37:47', 'no'),
(3, 11, 5, 6, 'uploads/custom-images/listing-2024-07-10-01-09-04-3084.webp', 'digital-marketer-for-social-media', 0, NULL, NULL, 'enable', 'enable', 'approved', '[{\"value\":\"Mobile apps\"},{\"value\":\"ios apps\"},{\"value\":\"android\"}]', 'Mobile application development', 'The successful candidate should have a keen eye for detail, a passion for technology, and the ability to collaborate with cross-functional teams. If you have a proven track record of developing successful iOS applications and can bring creative ideas to the table, we would love to hear from you.', '2024-07-10 06:24:41', '2024-08-27 04:38:19', 'no'),
(4, 0, 3, 2, 'uploads/custom-images/listing-2024-07-10-01-10-30-5232.webp', 'video-editor-for-creative-projects', 0, NULL, NULL, 'enable', 'enable', 'approved', '[{&quot;value&quot;:&quot;Mobile apps&quot;},{&quot;value&quot;:&quot;ios apps&quot;},{&quot;value&quot;:&quot;android&quot;}]', 'Mobile application development', 'The successful candidate should have a keen eye for detail, a passion for technology, and the ability to collaborate with cross-functional teams. If you have a proven track record of developing successful iOS applications and can bring creative ideas to the table, we would love to hear from you.', '2024-07-10 06:24:41', '2025-07-29 09:05:14', 'no'),
(5, 37, 4, 10, 'uploads/custom-images/listing-2024-07-10-01-12-40-6616.webp', 'social-media-manager-for-engagement', 0, NULL, NULL, 'enable', 'enable', 'approved', '[{\"value\":\"Mobile apps\"},{\"value\":\"ios apps\"},{\"value\":\"android\"}]', 'Mobile application development', 'The successful candidate should have a keen eye for detail, a passion for technology, and the ability to collaborate with cross-functional teams. If you have a proven track record of developing successful iOS applications and can bring creative ideas to the table, we would love to hear from you.', '2024-07-10 06:24:41', '2024-08-27 04:38:40', 'no'),
(6, 17, 7, 8, 'uploads/custom-images/listing-2024-07-10-02-54-59-4379.webp', 'mobile-app-ios-developer-wanted6', 0, NULL, NULL, 'enable', 'enable', 'approved', '[{\"value\":\"Mobile apps\"},{\"value\":\"ios apps\"},{\"value\":\"android\"}]', 'Mobile application development', 'The successful candidate should have a keen eye for detail, a passion for technology, and the ability to collaborate with cross-functional teams. If you have a proven track record of developing successful iOS applications and can bring creative ideas to the table, we would love to hear from you.', '2024-07-10 06:24:41', '2024-08-27 04:38:52', 'no'),
(7, 0, 7, 9, 'uploads/custom-images/listing-2024-07-10-03-02-20-2006.webp', 'mobile-app-ios-developer-wanted7', 0, NULL, NULL, 'enable', 'enable', 'approved', '[{\"value\":\"Mobile apps\"},{\"value\":\"ios apps\"},{\"value\":\"android\"}]', 'Mobile application development', 'The successful candidate should have a keen eye for detail, a passion for technology, and the ability to collaborate with cross-functional teams. If you have a proven track record of developing successful iOS applications and can bring creative ideas to the table, we would love to hear from you.', '2024-07-10 06:24:41', '2024-07-10 09:02:20', 'no'),
(8, 13, 7, 6, 'uploads/custom-images/listing-2024-07-10-03-02-58-6573.webp', 'mobile-app-ios-developer-wanted8', 0, NULL, NULL, 'enable', 'enable', 'approved', '[{\"value\":\"Mobile apps\"},{\"value\":\"ios apps\"},{\"value\":\"android\"}]', 'Mobile application development', 'The successful candidate should have a keen eye for detail, a passion for technology, and the ability to collaborate with cross-functional teams. If you have a proven track record of developing successful iOS applications and can bring creative ideas to the table, we would love to hear from you.', '2024-07-10 06:24:41', '2024-08-27 04:39:14', 'no'),
(9, 27, 7, 12, 'uploads/custom-images/listing-2024-07-10-03-03-38-1821.webp', 'mobile-app-ios-developer-wanted9', 0, NULL, NULL, 'enable', 'enable', 'approved', '[{\"value\":\"Mobile apps\"},{\"value\":\"ios apps\"},{\"value\":\"android\"}]', 'Mobile application development', 'The successful candidate should have a keen eye for detail, a passion for technology, and the ability to collaborate with cross-functional teams. If you have a proven track record of developing successful iOS applications and can bring creative ideas to the table, we would love to hear from you.', '2024-07-10 06:24:41', '2024-08-27 04:39:25', 'no'),
(10, 0, 7, 13, 'uploads/custom-images/listing-2024-07-10-03-04-10-7837.webp', 'mobile-app-ios-developer-wanted10', 0, NULL, NULL, 'enable', 'enable', 'approved', '[{\"value\":\"Mobile apps\"},{\"value\":\"ios apps\"},{\"value\":\"android\"}]', 'Mobile application development', 'The successful candidate should have a keen eye for detail, a passion for technology, and the ability to collaborate with cross-functional teams. If you have a proven track record of developing successful iOS applications and can bring creative ideas to the table, we would love to hear from you.', '2024-07-10 06:24:41', '2024-07-10 09:04:10', 'no');

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

--
-- Table structure for table `listing_galleries`
--

CREATE TABLE `listing_galleries` (
  `id` bigint UNSIGNED NOT NULL,
  `listing_id` int NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `listing_galleries`
--

INSERT INTO `listing_galleries` (`id`, `listing_id`, `image`, `created_at`, `updated_at`) VALUES
(6, 1, 'uploads/custom-images/listing-gallery-2024-07-10-12-37-44-54380.webp', '2024-07-10 06:37:44', '2024-07-10 06:37:44'),
(7, 1, 'uploads/custom-images/listing-gallery-2024-07-10-12-37-44-82411.webp', '2024-07-10 06:37:44', '2024-07-10 06:37:44'),
(8, 1, 'uploads/custom-images/listing-gallery-2024-07-10-12-37-44-34692.webp', '2024-07-10 06:37:44', '2024-07-10 06:37:44'),
(9, 1, 'uploads/custom-images/listing-gallery-2024-07-10-12-37-44-32443.webp', '2024-07-10 06:37:44', '2024-07-10 06:37:44'),
(10, 1, 'uploads/custom-images/listing-gallery-2024-07-10-12-37-44-56654.webp', '2024-07-10 06:37:44', '2024-07-10 06:37:44'),
(11, 2, 'uploads/custom-images/listing-gallery-2024-07-10-01-07-48-91900.webp', '2024-07-10 07:07:48', '2024-07-10 07:07:48'),
(12, 2, 'uploads/custom-images/listing-gallery-2024-07-10-01-07-48-15131.webp', '2024-07-10 07:07:48', '2024-07-10 07:07:48'),
(13, 2, 'uploads/custom-images/listing-gallery-2024-07-10-01-07-48-57172.webp', '2024-07-10 07:07:48', '2024-07-10 07:07:48'),
(14, 2, 'uploads/custom-images/listing-gallery-2024-07-10-01-07-48-25053.webp', '2024-07-10 07:07:48', '2024-07-10 07:07:48'),
(15, 3, 'uploads/custom-images/listing-gallery-2024-07-10-01-09-31-54880.webp', '2024-07-10 07:09:31', '2024-07-10 07:09:31'),
(16, 3, 'uploads/custom-images/listing-gallery-2024-07-10-01-09-31-96001.webp', '2024-07-10 07:09:31', '2024-07-10 07:09:31'),
(17, 3, 'uploads/custom-images/listing-gallery-2024-07-10-01-09-31-27572.webp', '2024-07-10 07:09:31', '2024-07-10 07:09:31'),
(18, 3, 'uploads/custom-images/listing-gallery-2024-07-10-01-09-31-27953.webp', '2024-07-10 07:09:31', '2024-07-10 07:09:31'),
(19, 4, 'uploads/custom-images/listing-gallery-2024-07-10-01-11-00-80070.webp', '2024-07-10 07:11:00', '2024-07-10 07:11:00'),
(20, 4, 'uploads/custom-images/listing-gallery-2024-07-10-01-11-00-54651.webp', '2024-07-10 07:11:00', '2024-07-10 07:11:00'),
(21, 4, 'uploads/custom-images/listing-gallery-2024-07-10-01-11-00-91302.webp', '2024-07-10 07:11:00', '2024-07-10 07:11:00'),
(23, 6, 'uploads/custom-images/listing-gallery-2024-07-10-02-55-22-99870.webp', '2024-07-10 08:55:22', '2024-07-10 08:55:22'),
(24, 6, 'uploads/custom-images/listing-gallery-2024-07-10-02-55-22-96961.webp', '2024-07-10 08:55:22', '2024-07-10 08:55:22'),
(25, 6, 'uploads/custom-images/listing-gallery-2024-07-10-02-55-22-45182.webp', '2024-07-10 08:55:22', '2024-07-10 08:55:22'),
(26, 6, 'uploads/custom-images/listing-gallery-2024-07-10-02-55-22-41983.webp', '2024-07-10 08:55:22', '2024-07-10 08:55:22'),
(27, 7, 'uploads/custom-images/listing-gallery-2024-07-10-03-02-34-13930.webp', '2024-07-10 09:02:34', '2024-07-10 09:02:34'),
(28, 7, 'uploads/custom-images/listing-gallery-2024-07-10-03-02-34-82151.webp', '2024-07-10 09:02:34', '2024-07-10 09:02:34'),
(29, 8, 'uploads/custom-images/listing-gallery-2024-07-10-03-03-09-85650.webp', '2024-07-10 09:03:09', '2024-07-10 09:03:09'),
(30, 8, 'uploads/custom-images/listing-gallery-2024-07-10-03-03-09-36261.webp', '2024-07-10 09:03:09', '2024-07-10 09:03:09'),
(31, 8, 'uploads/custom-images/listing-gallery-2024-07-10-03-03-09-39682.webp', '2024-07-10 09:03:09', '2024-07-10 09:03:09'),
(32, 8, 'uploads/custom-images/listing-gallery-2024-07-10-03-03-09-78773.webp', '2024-07-10 09:03:09', '2024-07-10 09:03:09'),
(33, 9, 'uploads/custom-images/listing-gallery-2024-07-10-03-03-49-17110.webp', '2024-07-10 09:03:49', '2024-07-10 09:03:49'),
(34, 9, 'uploads/custom-images/listing-gallery-2024-07-10-03-03-49-20441.webp', '2024-07-10 09:03:49', '2024-07-10 09:03:49'),
(35, 9, 'uploads/custom-images/listing-gallery-2024-07-10-03-03-49-38572.webp', '2024-07-10 09:03:49', '2024-07-10 09:03:49'),
(36, 10, 'uploads/custom-images/listing-gallery-2024-07-10-03-04-24-29590.webp', '2024-07-10 09:04:24', '2024-07-10 09:04:24'),
(37, 10, 'uploads/custom-images/listing-gallery-2024-07-10-03-04-24-47971.webp', '2024-07-10 09:04:24', '2024-07-10 09:04:24'),
(38, 10, 'uploads/custom-images/listing-gallery-2024-07-10-03-04-24-91602.webp', '2024-07-10 09:04:24', '2024-07-10 09:04:24'),
(39, 10, 'uploads/custom-images/listing-gallery-2024-07-10-03-04-24-32533.webp', '2024-07-10 09:04:24', '2024-07-10 09:04:24');

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

--
-- Table structure for table `listing_packages`
--

CREATE TABLE `listing_packages` (
  `id` bigint UNSIGNED NOT NULL,
  `listing_id` int NOT NULL,
  `basic_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `basic_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `basic_price` decimal(8,2) NOT NULL,
  `basic_delivery_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `basic_revision` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `basic_fn_website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `basic_page` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `basic_responsive` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `basic_source_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `basic_content_upload` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `basic_speed_optimized` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `standard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `standard_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `standard_price` decimal(8,2) NOT NULL,
  `standard_delivery_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `standard_revision` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `standard_fn_website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `standard_page` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `standard_responsive` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `standard_source_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `standard_content_upload` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `standard_speed_optimized` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `premium_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `premium_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `premium_price` decimal(8,2) NOT NULL,
  `premium_delivery_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `premium_revision` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `premium_fn_website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `premium_page` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `premium_responsive` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `premium_source_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `premium_content_upload` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `premium_speed_optimized` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `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 `listing_packages`
--

INSERT INTO `listing_packages` (`id`, `listing_id`, `basic_name`, `basic_description`, `basic_price`, `basic_delivery_date`, `basic_revision`, `basic_fn_website`, `basic_page`, `basic_responsive`, `basic_source_code`, `basic_content_upload`, `basic_speed_optimized`, `standard_name`, `standard_description`, `standard_price`, `standard_delivery_date`, `standard_revision`, `standard_fn_website`, `standard_page`, `standard_responsive`, `standard_source_code`, `standard_content_upload`, `standard_speed_optimized`, `premium_name`, `premium_description`, `premium_price`, `premium_delivery_date`, `premium_revision`, `premium_fn_website`, `premium_page`, `premium_responsive`, `premium_source_code`, `premium_content_upload`, `premium_speed_optimized`, `created_at`, `updated_at`) VALUES
(1, 1, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', 59.00, '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Standard', 'Get a professional Mobile App Design or Development.', 199.00, '2', '2', 'yes', '8', 'yes', 'yes', 'yes', 'yes', 'Premium', 'Get a professional Mobile App Design or Development', 599.00, '3', '3', 'yes', '10', 'yes', 'yes', 'yes', 'yes', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(2, 2, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', 60.00, '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Standard', 'Get a professional Mobile App Design or Development.', 199.00, '2', '2', 'yes', '8', 'yes', 'yes', 'yes', 'yes', 'Premium', 'Get a professional Mobile App Design or Development', 599.00, '3', '3', 'yes', '10', 'yes', 'yes', 'yes', 'yes', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(3, 3, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', 49.00, '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Standard', 'Get a professional Mobile App Design or Development.', 199.00, '2', '2', 'yes', '8', 'yes', 'yes', 'yes', 'yes', 'Premium', 'Get a professional Mobile App Design or Development', 599.00, '3', '3', 'yes', '10', 'yes', 'yes', 'yes', 'yes', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(4, 4, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', 30.00, '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Standard', 'Get a professional Mobile App Design or Development.', 199.00, '2', '2', 'yes', '8', 'yes', 'yes', 'yes', 'yes', 'Premium', 'Get a professional Mobile App Design or Development', 599.00, '3', '3', 'yes', '10', 'yes', 'yes', 'yes', 'yes', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(5, 5, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', 15.00, '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Standard', 'Get a professional Mobile App Design or Development.', 199.00, '2', '2', 'yes', '8', 'yes', 'yes', 'yes', 'yes', 'Premium', 'Get a professional Mobile App Design or Development', 599.00, '3', '3', 'yes', '10', 'yes', 'yes', 'yes', 'yes', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(6, 6, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', 25.00, '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Standard', 'Get a professional Mobile App Design or Development.', 199.00, '2', '2', 'yes', '8', 'yes', 'yes', 'yes', 'yes', 'Premium', 'Get a professional Mobile App Design or Development', 599.00, '3', '3', 'yes', '10', 'yes', 'yes', 'yes', 'yes', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(7, 7, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', 90.00, '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Standard', 'Get a professional Mobile App Design or Development.', 199.00, '2', '2', 'yes', '8', 'yes', 'yes', 'yes', 'yes', 'Premium', 'Get a professional Mobile App Design or Development', 599.00, '3', '3', 'yes', '10', 'yes', 'yes', 'yes', 'yes', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(8, 8, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', 95.00, '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Standard', 'Get a professional Mobile App Design or Development.', 199.00, '2', '2', 'yes', '8', 'yes', 'yes', 'yes', 'yes', 'Premium', 'Get a professional Mobile App Design or Development', 599.00, '3', '3', 'yes', '10', 'yes', 'yes', 'yes', 'yes', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(9, 9, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', 70.00, '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Standard', 'Get a professional Mobile App Design or Development.', 199.00, '2', '2', 'yes', '8', 'yes', 'yes', 'yes', 'yes', 'Premium', 'Get a professional Mobile App Design or Development', 599.00, '3', '3', 'yes', '10', 'yes', 'yes', 'yes', 'yes', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(10, 10, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', 80.00, '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Standard', 'Get a professional Mobile App Design or Development.', 199.00, '2', '2', 'yes', '8', 'yes', 'yes', 'yes', 'yes', 'Premium', 'Get a professional Mobile App Design or Development', 599.00, '3', '3', 'yes', '10', 'yes', 'yes', 'yes', 'yes', '2024-07-10 06:24:41', '2024-07-10 06:24:41');

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

--
-- Table structure for table `listing_translations`
--

CREATE TABLE `listing_translations` (
  `id` bigint UNSIGNED NOT NULL,
  `listing_id` int NOT NULL,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `listing_translations`
--

INSERT INTO `listing_translations` (`id`, `listing_id`, `lang_code`, `title`, `description`, `created_at`, `updated_at`) VALUES
(1, 1, 'en', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\r\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\r\n<ul>\r\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\r\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\r\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\r\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\r\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\r\n</ul>\r\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\r\n<ul>\r\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\r\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\r\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\r\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\r\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\r\n</ul>\r\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\r\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-08-25 07:08:23'),
(2, 1, 'hd', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\n<ul>\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\n<ul>\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-07-12 09:23:11'),
(3, 2, 'en', 'Content Writer for Blog Articles', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\n<ul>\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\n<ul>\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-07-10 07:35:36'),
(4, 2, 'hd', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\n<ul>\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\n<ul>\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(5, 3, 'en', 'Digital Marketer for Social Media', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\r\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\r\n<ul>\r\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\r\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\r\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\r\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\r\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\r\n</ul>\r\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\r\n<ul>\r\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\r\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\r\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\r\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\r\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\r\n</ul>\r\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\r\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-08-27 04:38:19'),
(6, 3, 'hd', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\n<ul>\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\n<ul>\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(7, 4, 'en', 'Video Editor for Creative Projects', '&lt;p&gt;Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&lt;/p&gt;\r\n&lt;p&gt;&lt;span style=&quot;font-size: 14pt;&quot;&gt;&lt;strong&gt;Service Offerings:&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;\r\n&lt;ul&gt;\r\n&lt;li&gt;&lt;strong&gt;Swift Expertise:&lt;/strong&gt; Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.&lt;/li&gt;\r\n&lt;li&gt;&lt;strong&gt;UI/UX Design:&lt;/strong&gt; Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.&lt;/li&gt;\r\n&lt;li&gt;&lt;strong&gt;Testing &amp;amp; Optimization:&lt;/strong&gt; Conducting thorough testing and&amp;nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.&lt;/li&gt;\r\n&lt;li&gt;&lt;strong&gt;Collaborative Approach:&lt;/strong&gt; Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.&lt;/li&gt;\r\n&lt;li&gt;&lt;strong&gt;Continuous Support:&lt;/strong&gt; Providing ongoing supportissues, implement updates, and ensure the app&#039;s optimal performance and functionality.&lt;/li&gt;\r\n&lt;/ul&gt;\r\n&lt;p&gt;&lt;span style=&quot;font-size: 14pt;&quot;&gt;&lt;strong&gt;Why Choose Me:&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;\r\n&lt;ul&gt;\r\n&lt;li&gt;&lt;strong&gt;Expertise:&lt;/strong&gt; With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.&lt;/li&gt;\r\n&lt;li&gt;&lt;strong&gt;Quality Focus:&lt;/strong&gt; Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.&lt;/li&gt;\r\n&lt;li&gt;&lt;strong&gt;Client-Centric:&lt;/strong&gt; Prioritizing client satisfaction by&amp;nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.&lt;/li&gt;\r\n&lt;li&gt;&lt;strong&gt;Innovation:&lt;/strong&gt; Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.&lt;/li&gt;\r\n&lt;li&gt;&lt;strong&gt;Reliability:&lt;/strong&gt; Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.&lt;/li&gt;\r\n&lt;/ul&gt;\r\n&lt;p&gt;&lt;span style=&quot;font-size: 14pt;&quot;&gt;&lt;strong&gt;Let&#039;s Collaborate:&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;\r\n&lt;p&gt;If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&amp;nbsp;&lt;/p&gt;', '2024-07-10 06:24:41', '2024-08-25 08:22:54'),
(8, 4, 'hd', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\n<ul>\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\n<ul>\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(9, 5, 'en', 'Social Media Manager for Engagement', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\r\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\r\n<ul>\r\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\r\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\r\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\r\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\r\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\r\n</ul>\r\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\r\n<ul>\r\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\r\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\r\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\r\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\r\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\r\n</ul>\r\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\r\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-08-27 04:38:40'),
(10, 5, 'hd', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\n<ul>\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\n<ul>\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(11, 6, 'en', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\r\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\r\n<ul>\r\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\r\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\r\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\r\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\r\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\r\n</ul>\r\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\r\n<ul>\r\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\r\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\r\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\r\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\r\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\r\n</ul>\r\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\r\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-08-27 04:38:52'),
(12, 6, 'hd', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\n<ul>\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\n<ul>\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(13, 7, 'en', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\n<ul>\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\n<ul>\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-07-10 06:44:53');
INSERT INTO `listing_translations` (`id`, `listing_id`, `lang_code`, `title`, `description`, `created_at`, `updated_at`) VALUES
(14, 7, 'hd', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\n<ul>\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\n<ul>\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(15, 8, 'en', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\r\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\r\n<ul>\r\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\r\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\r\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\r\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\r\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\r\n</ul>\r\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\r\n<ul>\r\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\r\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\r\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\r\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\r\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\r\n</ul>\r\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\r\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-08-27 04:39:14'),
(16, 8, 'hd', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\n<ul>\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\n<ul>\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(17, 9, 'en', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\r\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\r\n<ul>\r\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\r\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\r\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\r\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\r\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\r\n</ul>\r\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\r\n<ul>\r\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\r\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\r\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\r\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\r\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\r\n</ul>\r\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\r\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-08-27 04:39:25'),
(18, 9, 'hd', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\n<ul>\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\n<ul>\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-07-10 06:24:41'),
(19, 10, 'en', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\n<ul>\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\n<ul>\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-07-10 06:44:53'),
(20, 10, 'hd', 'Mobile App iOS Developer Wanted', '<p>Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.</p>\n<p><span style=\"font-size: 14pt;\"><strong>Service Offerings:</strong></span></p>\n<ul>\n<li><strong>Swift Expertise:</strong> Leveraging my proficiency in Swift language to develop robust and efficient iOS applications that meet your requirements.</li>\n<li><strong>UI/UX Design:</strong> Crafting visually appealing and intuitive user interfaces to enhance user engagement and drive app usability.</li>\n<li><strong>Testing &amp; Optimization:</strong> Conducting thorough testing and&nbsp; ensure bug-free, high-performance apps that deliver a seamless user experience.</li>\n<li><strong>Collaborative Approach:</strong> Working closely with clients to goals, and to tailor app solutions that align with their brand identity and objectives.</li>\n<li><strong>Continuous Support:</strong> Providing ongoing supportissues, implement updates, and ensure the app\'s optimal performance and functionality.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Why Choose Me:</strong></span></p>\n<ul>\n<li><strong>Expertise:</strong> With years of experience in iOS app development, I bring expertise in creating custom solutions tailored to your specific needs.</li>\n<li><strong>Quality Focus:</strong> Committed to delivering high-quality apps that exceed expectations in terms of design, functionality, and user experience.</li>\n<li><strong>Client-Centric:</strong> Prioritizing client satisfaction by&nbsp; their needs, communicating effectively, and ensuring transparency throughout the project.</li>\n<li><strong>Innovation:</strong> Embracing creativity and innovation to develop unique andsolutions that set clients apart in the competitive app market.</li>\n<li><strong>Reliability:</strong> Delivering projects on time and within budget, while open communication channels and providing regular updates on progress.</li>\n</ul>\n<p><span style=\"font-size: 14pt;\"><strong>Let\'s Collaborate:</strong></span></p>\n<p>If you are ready to take your app idea to the next level and create a standout mobile application that resonates with users, I am here to help. Together, we can turn your vision into a functional, visually appealing, and user-friendly iOS app that makes a lasting impression. Contact me today to discuss your project requirements and explore how we can work together to bring your app dreams to life. Are you looking to transform your app idea into a reality? As a seasoned iOS App Developer, I offer specialized gig services to cater to your mobile app development needs. With a focus on innovation, user experience, and quality, I am dedicated to delivering top-notch iOS applications that resonate with your target audience and elevate your brand presence in the digital realm.&nbsp;</p>', '2024-07-10 06:24:41', '2024-07-10 06:24:41');

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` bigint UNSIGNED NOT NULL,
  `buyer_id` int NOT NULL DEFAULT '1',
  `seller_id` int NOT NULL DEFAULT '1',
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `buyer_read_msg` int NOT NULL DEFAULT '0',
  `seller_read_msg` int NOT NULL DEFAULT '0',
  `send_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `service_id` int NOT NULL DEFAULT '0',
  `isadmin_seen` tinyint(1) NOT NULL DEFAULT '0',
  `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 `messages`
--

INSERT INTO `messages` (`id`, `buyer_id`, `seller_id`, `message`, `buyer_read_msg`, `seller_read_msg`, `send_by`, `service_id`, `isadmin_seen`, `created_at`, `updated_at`) VALUES
(1, 1, 3, 'Hello brother, How are you ? I have a laravel project.', 1, 1, 'buyer', 0, 1, '2024-07-26 09:12:38', '2025-07-31 03:01:23'),
(2, 1, 3, 'Hello', 1, 1, 'seller', 0, 1, '2024-07-26 09:13:12', '2025-07-29 08:20:46'),
(3, 1, 3, 'I&#039;m fine. What&#039;s about you ?', 1, 1, 'seller', 0, 1, '2024-07-26 09:13:21', '2025-07-29 08:20:46'),
(4, 1, 3, 'Let&#039;s discuss the project', 1, 1, 'seller', 0, 1, '2024-07-26 09:13:30', '2025-07-29 08:20:46'),
(5, 1, 3, 'Please share google meet link', 1, 1, 'buyer', 0, 1, '2024-07-26 09:13:42', '2025-07-31 03:01:23'),
(6, 1, 7, 'Hello, I have laravel project. I need a fixing the bug. can you help me ?', 1, 0, 'buyer', 0, 1, '2024-07-26 09:14:31', '2025-07-29 05:42:32'),
(7, 1, 7, 'Please response me', 1, 0, 'buyer', 0, 1, '2024-07-26 09:14:42', '2025-07-29 05:42:32'),
(8, 1, 7, 'Can you share the bug sample ?', 1, 1, 'seller', 0, 1, '2024-07-26 09:14:42', '2025-10-07 06:04:41'),
(9, 1, 7, 'Sure, Give me time please', 1, 0, 'buyer', 0, 1, '2024-07-26 09:15:33', '2025-07-29 05:42:32'),
(10, 1, 3, 'hi', 1, 1, 'buyer', 0, 1, '2025-06-29 03:25:47', '2025-07-31 03:01:23'),
(11, 1, 3, 'Hello', 1, 1, 'seller', 0, 1, '2025-06-29 03:26:13', '2025-07-29 08:20:46'),
(12, 1, 7, 'asdasda', 1, 0, 'buyer', 0, 1, '2025-06-29 05:38:26', '2025-07-29 05:42:32'),
(13, 1, 7, 'hi', 1, 0, 'buyer', 0, 1, '2025-06-29 05:41:49', '2025-07-29 05:42:32'),
(14, 1, 7, 'Hello', 1, 0, 'buyer', 0, 1, '2025-06-29 05:42:32', '2025-07-29 05:42:32'),
(15, 1, 7, 'asdad', 1, 0, 'buyer', 0, 1, '2025-06-29 05:46:49', '2025-07-29 05:42:32'),
(16, 1, 3, 'Hello', 1, 1, 'buyer', 0, 1, '2025-06-29 06:07:50', '2025-07-31 03:01:23'),
(17, 1, 3, 'new file', 1, 1, 'buyer', 0, 1, '2025-06-29 07:00:50', '2025-07-31 03:01:23'),
(18, 1, 3, 'hello', 1, 1, 'buyer', 0, 1, '2025-06-29 08:08:39', '2025-07-31 03:01:23'),
(19, 1, 3, 'ddfsd', 1, 1, 'buyer', 0, 1, '2025-06-29 08:09:24', '2025-07-31 03:01:23'),
(20, 1, 3, 'asdd', 1, 1, 'buyer', 0, 1, '2025-06-29 08:09:55', '2025-07-31 03:01:23'),
(21, 1, 3, 'dsfsdfs', 1, 1, 'buyer', 0, 1, '2025-06-29 08:10:04', '2025-07-31 03:01:23'),
(22, 1, 3, 'dsfsf', 1, 1, 'buyer', 0, 1, '2025-06-29 08:11:33', '2025-07-31 03:01:23'),
(23, 1, 3, 'sdfdsf', 1, 1, 'buyer', 0, 1, '2025-06-29 08:12:16', '2025-07-31 03:01:23'),
(24, 1, 3, 'new file', 1, 1, 'buyer', 0, 1, '2025-06-29 08:14:03', '2025-07-31 03:01:23'),
(25, 1, 3, 'Hi', 1, 1, 'buyer', 0, 1, '2025-06-29 08:15:51', '2025-07-31 03:01:23'),
(26, 1, 3, 'how are u', 1, 1, 'seller', 0, 1, '2025-06-29 08:18:58', '2025-07-29 08:20:46'),
(27, 1, 3, 'f9', 1, 1, 'buyer', 0, 1, '2025-06-29 08:19:15', '2025-07-31 03:01:23'),
(28, 1, 3, 'Hello', 1, 1, 'seller', 0, 1, '2025-06-29 08:19:36', '2025-07-29 08:20:46'),
(29, 1, 3, 'Hi', 1, 1, 'buyer', 0, 1, '2025-06-29 08:19:45', '2025-07-31 03:01:23'),
(30, 1, 3, 'File', 1, 1, 'buyer', 0, 1, '2025-06-29 08:20:02', '2025-07-31 03:01:23'),
(31, 1, 3, 'Hello', 1, 1, 'seller', 0, 1, '2025-06-29 08:26:34', '2025-07-29 08:20:46'),
(32, 1, 3, 'hello', 1, 1, 'seller', 0, 1, '2025-06-29 08:26:51', '2025-07-29 08:20:46'),
(33, 1, 3, 'check this file', 1, 1, 'seller', 0, 1, '2025-06-29 08:27:21', '2025-07-29 08:20:46'),
(34, 1, 3, 'asdasd', 1, 1, 'seller', 0, 1, '2025-06-29 08:29:05', '2025-07-29 08:20:46'),
(35, 1, 3, 'sdsada', 1, 1, 'seller', 0, 1, '2025-06-29 08:29:16', '2025-07-29 08:20:46'),
(36, 1, 3, 'sdhfds', 1, 1, 'seller', 0, 1, '2025-06-29 08:32:11', '2025-07-29 08:20:46'),
(37, 1, 3, 'hi', 1, 1, 'seller', 0, 1, '2025-06-29 08:33:25', '2025-07-29 08:20:46'),
(38, 1, 3, 'hello 1', 1, 1, 'seller', 0, 1, '2025-06-29 08:33:36', '2025-07-29 08:20:46'),
(39, 1, 3, 'hi', 1, 1, 'buyer', 0, 1, '2025-06-29 08:34:22', '2025-07-31 03:01:23'),
(40, 1, 3, 'Hello', 1, 1, 'buyer', 0, 1, '2025-06-29 08:34:32', '2025-07-31 03:01:23'),
(41, 1, 3, 'Hello1234', 1, 1, 'buyer', 0, 1, '2025-06-29 08:34:42', '2025-07-31 03:01:23'),
(42, 1, 3, 'hay', 1, 1, 'seller', 0, 1, '2025-06-29 08:34:54', '2025-07-29 08:20:46'),
(43, 1, 3, 'seller file', 1, 1, 'seller', 0, 1, '2025-06-29 08:35:33', '2025-07-29 08:20:46'),
(44, 1, 3, 'hello', 1, 1, 'seller', 0, 1, '2025-06-29 09:09:19', '2025-07-29 08:20:46'),
(45, 1, 3, 'another file', 1, 1, 'seller', 0, 1, '2025-06-29 09:09:39', '2025-07-29 08:20:46'),
(46, 1, 3, 'Hi', 1, 1, 'buyer', 0, 1, '2025-06-29 10:21:29', '2025-07-31 03:01:23'),
(47, 1, 3, 'Hello', 1, 1, 'seller', 0, 1, '2025-06-29 10:21:57', '2025-07-29 08:20:46'),
(48, 1, 3, 'dsfd', 1, 1, 'seller', 0, 1, '2025-07-07 10:02:53', '2025-07-29 08:20:46'),
(49, 1, 3, 'i8iiiii', 1, 1, 'seller', 0, 1, '2025-07-07 10:05:11', '2025-07-29 08:20:46'),
(50, 1, 3, 'Hello', 1, 1, 'buyer', 0, 1, '2025-07-07 10:07:57', '2025-07-31 03:01:23'),
(51, 1, 3, 'df', 1, 1, 'buyer', 0, 1, '2025-07-07 10:09:05', '2025-07-31 03:01:23'),
(52, 1, 3, 'df', 1, 1, 'buyer', 0, 1, '2025-07-07 10:09:15', '2025-07-31 03:01:23'),
(53, 1, 3, 'Hello', 1, 1, 'seller', 0, 1, '2025-07-07 10:12:56', '2025-07-29 08:20:46'),
(54, 1, 7, 'dasdasd', 1, 0, 'buyer', 0, 1, '2025-07-07 10:16:59', '2025-07-29 05:42:32'),
(55, 1, 3, 'hi', 1, 1, 'seller', 0, 1, '2025-07-07 10:23:07', '2025-07-29 08:20:46'),
(56, 1, 3, 'Hello', 1, 1, 'buyer', 0, 1, '2025-07-07 10:23:54', '2025-07-31 03:01:23'),
(57, 1, 3, 'Hello', 1, 1, 'buyer', 0, 1, '2025-07-07 10:31:56', '2025-07-31 03:01:23'),
(58, 1, 3, 'Hi', 1, 1, 'buyer', 0, 1, '2025-07-07 10:32:02', '2025-07-31 03:01:23'),
(59, 1, 3, 'File', 1, 1, 'buyer', 0, 1, '2025-07-07 10:32:18', '2025-07-31 03:01:23'),
(60, 1, 3, NULL, 1, 1, 'buyer', 0, 1, '2025-07-07 10:32:27', '2025-07-31 03:01:23'),
(61, 1, 3, 'Hello', 1, 1, 'seller', 0, 1, '2025-07-07 10:50:27', '2025-07-29 08:20:46'),
(62, 1, 3, 'Hi', 1, 1, 'seller', 0, 1, '2025-07-07 10:50:36', '2025-07-29 08:20:46'),
(63, 1, 3, 'File', 1, 1, 'seller', 0, 1, '2025-07-07 10:51:33', '2025-07-29 08:20:46'),
(64, 1, 3, NULL, 1, 1, 'seller', 0, 1, '2025-07-07 10:51:44', '2025-07-29 08:20:46'),
(65, 1, 3, 'Hi', 1, 1, 'buyer', 0, 1, '2025-07-07 10:54:21', '2025-07-31 03:01:23'),
(66, 1, 3, 'Hi', 1, 1, 'seller', 0, 1, '2025-07-07 10:57:41', '2025-07-29 08:20:46'),
(67, 1, 3, NULL, 1, 1, 'buyer', 0, 1, '2025-07-07 11:00:17', '2025-07-31 03:01:23'),
(68, 1, 3, 'hi', 1, 1, 'buyer', 0, 1, '2025-07-07 11:00:37', '2025-07-31 03:01:23'),
(69, 1, 3, 'sohel vai file', 1, 1, 'buyer', 0, 1, '2025-07-07 11:00:55', '2025-07-31 03:01:23'),
(70, 1, 3, NULL, 1, 1, 'buyer', 0, 1, '2025-07-07 11:01:06', '2025-07-31 03:01:23'),
(71, 1, 3, NULL, 1, 1, 'seller', 0, 1, '2025-07-09 02:50:47', '2025-07-29 08:20:46'),
(72, 1, 3, 'Hello', 1, 1, 'seller', 0, 1, '2025-07-17 06:17:10', '2025-07-29 08:20:46'),
(73, 1, 3, 'Hi', 1, 1, 'buyer', 0, 1, '2025-07-17 06:17:30', '2025-07-31 03:01:23'),
(74, 1, 3, 'Hello', 1, 1, 'buyer', 0, 1, '2025-07-17 07:00:35', '2025-07-31 03:01:23'),
(75, 1, 7, 'hi', 1, 0, 'buyer', 0, 1, '2025-07-17 07:03:46', '2025-07-29 05:42:32'),
(76, 1, 3, 'hi', 1, 1, 'buyer', 0, 1, '2025-07-17 08:13:18', '2025-07-31 03:01:23'),
(77, 1, 3, 'Hello', 1, 1, 'buyer', 0, 1, '2025-07-17 08:15:07', '2025-07-31 03:01:23'),
(78, 1, 3, 'Hello', 1, 1, 'buyer', 0, 1, '2025-07-17 08:20:15', '2025-07-31 03:01:23'),
(79, 1, 7, 'Hi', 1, 0, 'buyer', 0, 1, '2025-07-17 08:25:02', '2025-07-29 05:42:32'),
(80, 1, 3, NULL, 1, 1, 'seller', 0, 1, '2025-07-17 10:21:04', '2025-07-29 08:20:46'),
(81, 1, 3, 'hello', 1, 1, 'seller', 0, 1, '2025-07-17 10:21:09', '2025-07-29 08:20:46'),
(82, 1, 3, 'hello', 1, 1, 'seller', 0, 1, '2025-07-17 10:30:12', '2025-07-29 08:20:46'),
(83, 1, 3, 'Hello', 1, 1, 'buyer', 0, 1, '2025-07-28 10:01:55', '2025-07-31 03:01:23'),
(84, 1, 3, 'Hello', 1, 1, 'seller', 0, 1, '2025-07-28 10:02:18', '2025-07-29 08:20:46'),
(85, 1, 3, 'Hi', 1, 1, 'buyer', 0, 1, '2025-07-28 10:02:29', '2025-07-31 03:01:23'),
(86, 1, 3, 'dcs', 1, 1, 'buyer', 0, 1, '2025-07-28 10:02:52', '2025-07-31 03:01:23'),
(87, 1, 3, 'Hello', 1, 1, 'seller', 0, 1, '2025-07-29 05:15:57', '2025-07-29 08:20:46'),
(88, 1, 3, NULL, 1, 1, 'seller', 0, 1, '2025-07-29 05:28:43', '2025-07-29 08:20:46'),
(89, 1, 3, 'Hello', 1, 1, 'seller', 0, 1, '2025-07-29 05:29:25', '2025-07-29 08:20:46'),
(90, 1, 3, 'Hi', 1, 1, 'seller', 0, 1, '2025-07-29 05:30:03', '2025-07-29 08:20:46'),
(91, 1, 3, 'Hello', 1, 1, 'seller', 0, 1, '2025-07-29 05:30:27', '2025-07-29 08:20:46'),
(92, 1, 3, 'Hi', 1, 1, 'buyer', 0, 1, '2025-07-29 05:32:22', '2025-07-31 03:01:23'),
(93, 1, 3, 'please check this file', 1, 1, 'seller', 0, 1, '2025-07-29 05:34:20', '2025-07-29 08:20:46'),
(94, 1, 3, NULL, 1, 1, 'seller', 0, 1, '2025-07-29 05:34:26', '2025-07-29 08:20:46'),
(95, 1, 3, 'okay', 1, 1, 'buyer', 0, 1, '2025-07-29 05:34:40', '2025-07-31 03:01:23'),
(96, 1, 3, 'Publish the given module configuration files, or without an argument publish all modules configuration files.', 1, 1, 'seller', 0, 1, '2025-07-29 05:47:06', '2025-07-29 08:20:46'),
(97, 1, 3, 'Publish the given module configuration files, or without an argument publish all modules configuration files.Publish the given module configuration files, or without an argument publish all modules configuration files.Publish the given module configuration files, or without an argument publish all modules configuration files.Publish the given module configuration files, or without an argument publish all modules configuration files.', 1, 1, 'seller', 0, 1, '2025-07-29 05:47:14', '2025-07-29 08:20:46'),
(98, 1, 3, 'Publish the given module configuration files, or without an argument publish all modules configuration files.Publish the given module configuration files, or without an argument publish all modules configuration files.Publish the given module configuration files, or without an argument publish all modules configuration files.Publish the given module configuration files, or without an argument publish all modules configuration files.', 1, 1, 'buyer', 0, 1, '2025-07-29 05:47:49', '2025-07-31 03:01:23'),
(99, 10, 11, 'Ki obostha dada', 1, 1, 'buyer', 0, 0, '2025-08-16 11:36:14', '2025-08-16 11:37:52'),
(100, 10, 11, 'ki obosthsa tomar', 1, 1, 'seller', 0, 0, '2025-08-16 11:37:58', '2025-08-16 11:42:24'),
(101, 10, 11, 'achi valoi', 1, 0, 'buyer', 0, 0, '2025-08-16 11:38:10', '2025-08-16 11:38:10'),
(102, 10, 11, 'koi acho', 1, 0, 'buyer', 0, 0, '2025-08-16 11:38:13', '2025-08-16 11:38:13'),
(103, 10, 11, 'dhakay achi', 1, 1, 'seller', 0, 0, '2025-08-16 11:41:27', '2025-08-16 11:42:24'),
(104, 10, 11, 'mirpur', 1, 1, 'seller', 0, 0, '2025-08-16 11:41:29', '2025-08-16 11:42:24'),
(105, 10, 11, 'pic dekho', 1, 1, 'seller', 0, 0, '2025-08-16 11:41:47', '2025-08-16 11:42:24'),
(106, 10, 11, 'ei j ami', 1, 0, 'buyer', 0, 0, '2025-08-16 11:42:07', '2025-08-16 11:42:07');

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

--
-- Table structure for table `messages_documents`
--

CREATE TABLE `messages_documents` (
  `id` bigint UNSIGNED NOT NULL,
  `message_id` int NOT NULL,
  `buyer_id` int NOT NULL,
  `seller_id` int NOT NULL,
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `messages_documents`
--

INSERT INTO `messages_documents` (`id`, `message_id`, `buyer_id`, `seller_id`, `file_name`, `created_at`, `updated_at`) VALUES
(1, 15, 1, 7, 'uploads/custom-images/file-name-17511760093523.jpg', '2025-06-29 05:46:49', '2025-06-29 05:46:49'),
(2, 16, 1, 3, 'uploads/custom-images/file-name-17511772709702.png', '2025-06-29 06:07:50', '2025-06-29 06:07:50'),
(3, 17, 1, 3, 'uploads/custom-images/file-name-17511804503792.png', '2025-06-29 07:00:50', '2025-06-29 07:00:50'),
(4, 18, 1, 3, 'uploads/custom-images/file-name-17511845194001.jpg', '2025-06-29 08:08:39', '2025-06-29 08:08:39'),
(5, 19, 1, 3, 'uploads/custom-images/file-name-17511845644007.png', '2025-06-29 08:09:24', '2025-06-29 08:09:24'),
(6, 20, 1, 3, 'uploads/custom-images/file-name-17511845956140.png', '2025-06-29 08:09:55', '2025-06-29 08:09:55'),
(7, 22, 1, 3, 'uploads/custom-images/file-name-17511846931489.jpg', '2025-06-29 08:11:33', '2025-06-29 08:11:33'),
(8, 24, 1, 3, 'uploads/custom-images/file-name-17511848437117.jpg', '2025-06-29 08:14:03', '2025-06-29 08:14:03'),
(9, 25, 1, 3, 'uploads/custom-images/file-name-17511849515840.png', '2025-06-29 08:15:51', '2025-06-29 08:15:51'),
(10, 30, 1, 3, 'uploads/custom-images/file-name-17511852029690.png', '2025-06-29 08:20:02', '2025-06-29 08:20:02'),
(11, 33, 1, 3, 'uploads/custom-images/file-name-17511856413005.png', '2025-06-29 08:27:21', '2025-06-29 08:27:21'),
(12, 35, 1, 3, 'uploads/custom-images/file-name-17511857566635.png', '2025-06-29 08:29:16', '2025-06-29 08:29:16'),
(13, 36, 1, 3, 'uploads/custom-images/file-name-17511859313720.png', '2025-06-29 08:32:11', '2025-06-29 08:32:11'),
(14, 37, 1, 3, 'uploads/custom-images/file-name-17511860053333.png', '2025-06-29 08:33:25', '2025-06-29 08:33:25'),
(15, 38, 1, 3, 'uploads/custom-images/file-name-17511860163902.png', '2025-06-29 08:33:36', '2025-06-29 08:33:36'),
(16, 43, 1, 3, 'uploads/custom-images/file-name-17511861339334.png', '2025-06-29 08:35:33', '2025-06-29 08:35:33'),
(17, 45, 1, 3, 'uploads/custom-images/file-name-17511881799995.png', '2025-06-29 09:09:39', '2025-06-29 09:09:39'),
(18, 48, 1, 3, 'uploads/custom-images/file-name-17518825736458.png', '2025-07-07 10:02:53', '2025-07-07 10:02:53'),
(19, 49, 1, 3, 'uploads/custom-images/file-name-17518827112699.png', '2025-07-07 10:05:11', '2025-07-07 10:05:11'),
(20, 51, 1, 3, 'uploads/custom-images/file-name-17518829451011.png', '2025-07-07 10:09:05', '2025-07-07 10:09:05'),
(21, 52, 1, 3, 'uploads/custom-images/file-name-17518829551586.png', '2025-07-07 10:09:15', '2025-07-07 10:09:15'),
(22, 54, 1, 7, 'uploads/custom-images/file-name-17518834191600.jpg', '2025-07-07 10:16:59', '2025-07-07 10:16:59'),
(23, 59, 1, 3, 'uploads/custom-images/file-name-17518843385914.png', '2025-07-07 10:32:18', '2025-07-07 10:32:18'),
(24, 60, 1, 3, 'uploads/custom-images/file-name-17518843479649.png', '2025-07-07 10:32:27', '2025-07-07 10:32:27'),
(25, 63, 1, 3, 'uploads/custom-images/file-name-17518854934666.png', '2025-07-07 10:51:33', '2025-07-07 10:51:33'),
(26, 64, 1, 3, 'uploads/custom-images/file-name-17518855048838.jpg', '2025-07-07 10:51:44', '2025-07-07 10:51:44'),
(27, 67, 1, 3, 'uploads/custom-images/file-name-17518860177222.png', '2025-07-07 11:00:17', '2025-07-07 11:00:17'),
(28, 69, 1, 3, 'uploads/custom-images/file-name-17518860556900.png', '2025-07-07 11:00:55', '2025-07-07 11:00:55'),
(29, 70, 1, 3, 'uploads/custom-images/file-name-17518860676370.png', '2025-07-07 11:01:07', '2025-07-07 11:01:07'),
(30, 71, 1, 3, 'uploads/custom-images/file-name-17520294479094.png', '2025-07-09 02:50:47', '2025-07-09 02:50:47'),
(31, 80, 1, 3, 'uploads/custom-images/file-name-17527476646628.png', '2025-07-17 10:21:04', '2025-07-17 10:21:04'),
(32, 88, 1, 3, 'uploads/custom-images/file-name-17537669233013.pdf', '2025-07-29 05:28:43', '2025-07-29 05:28:43'),
(33, 94, 1, 3, 'uploads/custom-images/file-name-17537672662711.png', '2025-07-29 05:34:26', '2025-07-29 05:34:26'),
(34, 105, 10, 11, 'uploads/custom-images/file-name-17553445077540.webp', '2025-08-16 11:41:47', '2025-08-16 11:41:47'),
(35, 105, 10, 11, 'uploads/custom-images/file-name-17553445077492.webp', '2025-08-16 11:41:47', '2025-08-16 11:41:47'),
(36, 106, 10, 11, 'uploads/custom-images/file-name-17553445276576.webp', '2025-08-16 11:42:07', '2025-08-16 11:42:07'),
(37, 106, 10, 11, 'uploads/custom-images/file-name-17553445272121.webp', '2025-08-16 11:42:07', '2025-08-16 11:42:07');

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int 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, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(8, '2014_10_12_100000_create_password_resets_table', 2),
(9, '2024_05_06_161335_create_admins_table', 3),
(10, '2024_05_06_182035_create_global_settings_table', 4),
(11, '2024_05_07_174113_create_languages_table', 5),
(12, '2024_05_07_180516_create_currencies_table', 6),
(15, '2024_05_09_045544_create_testimonials_table', 7),
(16, '2024_05_09_045555_create_testimonial_trasnlations_table', 7),
(19, '2024_05_09_080956_create_email_settings_table', 8),
(20, '2024_05_09_082850_create_email_templates_table', 9),
(21, '2024_05_09_090449_add_statu_to_users', 10),
(22, '2024_05_09_090506_add_personal_info_to_admins', 10),
(23, '2024_05_09_091106_add_avatar_to_admins', 11),
(24, '2024_05_09_100009_create_seo_settings_table', 12),
(27, '2024_05_09_110823_create_term_and_conditions_table', 13),
(28, '2024_05_09_111521_create_privacy_policies_table', 13),
(29, '2024_05_09_114012_create_faqs_table', 14),
(30, '2024_05_09_114027_create_faq_translations_table', 14),
(31, '2024_05_08_151634_create_blogs_table', 15),
(32, '2024_05_08_152208_create_blog_categories_table', 15),
(33, '2024_05_08_152741_create_blog_translations_table', 15),
(34, '2024_05_08_152807_create_blog_category_translations_table', 15),
(35, '2024_05_12_064013_create_blog_comments_table', 16),
(36, '2024_01_31_044113_create_cities_table', 17),
(37, '2024_01_31_045030_create_city_translations_table', 17),
(38, '2024_02_24_052456_create_categories_table', 17),
(39, '2024_02_24_054937_create_sub_categories_table', 17),
(40, '2024_02_24_054952_create_sub_category_translations_table', 17),
(44, '2024_05_13_053040_add_city_image_to_cities', 18),
(45, '2024_05_13_060052_create_category_translations', 19),
(46, '2024_05_13_062301_add_icon_to_categories', 20),
(47, '2024_05_13_062424_add_category_id_to_category_translation', 21),
(48, '2024_05_13_081716_create_payment_gateways_table', 22),
(53, '2024_05_13_121650_create_homepages_table', 24),
(54, '2024_05_13_122614_create_homepage_translations_table', 24),
(55, '2024_05_14_102923_add_working_des_to_homepage_translations', 25),
(56, '2024_05_14_115626_add_app_link_to_homepages', 26),
(57, '2024_01_31_090220_create_listings_table', 27),
(58, '2024_01_31_092624_create_listing_translations_table', 27),
(59, '2024_02_01_104552_create_listing_galleries_table', 27),
(60, '2024_03_20_060641_create_job_requests_table', 27),
(61, '2024_05_02_171413_create_job_posts_table', 27),
(62, '2024_05_02_171618_create_job_post_translations_table', 27),
(63, '2024_05_14_144849_add_banned_to_users', 28),
(64, '2024_05_15_163816_create_about_us_table', 29),
(65, '2024_05_15_163829_create_about_us_translations_table', 29),
(66, '2024_05_27_161629_create_listing_packages_table', 30),
(67, '2024_06_09_155059_create_newsletters_table', 31),
(68, '2024_06_15_154748_create_footers_table', 32),
(69, '2024_06_15_155130_create_footer_translations_table', 32),
(70, '2024_06_26_105119_create_orders_table', 33),
(71, '2024_06_28_122222_create_reviews_table', 34),
(72, '2024_06_28_145313_create_withdraw_methods_table', 34),
(73, '2024_06_28_161601_create_seller_withdraws_table', 34),
(74, '2024_07_02_220449_create_custom_pages_table', 35),
(75, '2024_07_02_221522_create_custom_page_translations_table', 35),
(76, '2024_07_03_121953_create_contact_messages_table', 36),
(77, '2024_07_03_125356_add_features_to_homepages', 37),
(78, '2024_07_03_125617_add_features_to_homepage_translations', 38),
(79, '2024_07_06_105541_add_home2_intro_to_homepages', 39),
(80, '2024_07_06_105607_add_home2_intro_to_homepage_translations', 39),
(81, '2024_07_06_171027_create_wishlists_table', 40),
(82, '2024_07_25_123830_create_messages_table', 41),
(83, '2024_07_25_204121_create_wallets_table', 42),
(84, '2024_07_25_204251_create_wallet_transactions_table', 42),
(85, '2024_07_28_212722_add_submit_file_to_orders', 43),
(86, '2024_07_28_215446_create_refund_requests_table', 43),
(89, '2024_08_24_165133_create_sub_categories_table', 44),
(90, '2024_08_24_165613_create_sub_category_translates_table', 44),
(91, '2024_08_25_122955_add_category_id_to_listings_table', 45),
(92, '2024_08_27_155829_create_kyc_types_table', 46),
(93, '2024_08_27_155830_create_kyc_information_table', 46),
(94, '2024_08_27_182402_add_kyc_status_to_users_table', 46),
(95, '2024_08_28_141156_add_status_columns_to_users_table', 46),
(100, '2024_02_11_095157_create_subscription_plans_table', 47),
(101, '2024_02_14_121751_create_subscription_histories_table', 47),
(102, '2024_11_08_163939_add_register_otp_to_users', 48),
(103, '2024_11_08_165459_add_email_template_to_email_templates', 48),
(104, '2025_01_15_222722_add_is_draft_to_listings', 48),
(105, '2025_01_19_082620_create_sliders_table', 49),
(106, '2025_05_11_102144_create_xg_ftp_infos_table', 50),
(107, '2025_06_29_111933_create_messages_documents_table', 51),
(108, '2025_06_29_145433_create_job_request_files_table', 52),
(110, '2025_06_29_161350_create_block_users_table', 53),
(111, '2025_07_02_143949_create_job_post_messages_table', 54),
(112, '2025_07_02_144142_create_job_post_messages_documents_table', 55),
(113, '2025_07_03_115432_add_cancel_info_to_job_requests_table', 56),
(114, '2025_07_05_144954_create_restricted_keywords_table', 57),
(115, '2025_07_17_123708_add_adminsen_messages_table', 58),
(116, '2025_07_17_142915_add_adminsen_job_post_messages_table', 59),
(117, '2025_07_29_102333_add_paymentstatus_to_job_requests_table', 60),
(120, '2025_07_30_105146_add_refundtype_to_refund_requests_table', 61),
(121, '2025_08_28_072923__add_admin_type_to_admins', 62),
(122, '2025_08_28_121154_create_admin_permission_lists_table', 62),
(123, '2025_08_28_122224_create_admin_roles_table', 62),
(124, '2025_08_28_122231_create_admin_role_permissions_table', 62),
(125, '2025_08_28_122237_create_admin_role_assignments_table', 62),
(129, '2024_09_27_133920_create_seller_levels_table', 63),
(130, '2024_09_27_163406_create_seller_level_histories_table', 63),
(131, '2024_09_27_171025_add_level_info_in_users', 63);

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

--
-- Table structure for table `newsletters`
--

CREATE TABLE `newsletters` (
  `id` bigint UNSIGNED NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `verified_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_verified` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0',
  `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 `orders`
--

CREATE TABLE `orders` (
  `id` bigint UNSIGNED NOT NULL,
  `order_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `buyer_id` int NOT NULL,
  `seller_id` int NOT NULL,
  `listing_id` int NOT NULL,
  `listing_package_id` int NOT NULL,
  `total_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `package_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `additional_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `package_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `package_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `delivery_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `revision` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `fn_website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `number_of_page` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `responsive` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `source_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `content_upload` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `speed_optimized` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `payment_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `transaction_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `approved_by_seller` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `completed_by_buyer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `submit_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `order_id`, `buyer_id`, `seller_id`, `listing_id`, `listing_package_id`, `total_amount`, `package_amount`, `additional_amount`, `package_name`, `package_description`, `delivery_date`, `revision`, `fn_website`, `number_of_page`, `responsive`, `source_code`, `content_upload`, `speed_optimized`, `payment_method`, `payment_status`, `transaction_id`, `order_status`, `approved_by_seller`, `completed_by_buyer`, `created_at`, `updated_at`, `submit_file`) VALUES
(1, '1532267775', 1, 7, 2, 2, 99.00, 99.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'txn_3PcjoYF56Pb8BOOX1O6qD8NJ', 'pending', 'pending', 'pending', '2024-07-15 07:59:19', '2024-07-15 07:59:19', NULL),
(2, '17774696', 1, 5, 3, 3, 99.00, 99.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Paypal', 'success', 'ZUJKUEUDELUGE', 'cancel_by_buyer', 'pending', 'pending', '2024-07-15 07:59:51', '2024-07-30 02:15:38', NULL),
(3, '928264438', 1, 7, 10, 10, 99.00, 99.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Mollie', 'success', 'tr_aB8CcdG94i', 'complete_by_buyer', 'approved', 'complete', '2024-07-15 08:00:28', '2024-07-15 08:09:31', NULL),
(4, '1720558422', 1, 3, 4, 4, 99.00, 99.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'txn_3PcjrVF56Pb8BOOX0zsOfVSe', 'complete_by_buyer', 'approved', 'complete', '2024-07-15 08:02:22', '2024-07-15 08:08:54', NULL),
(5, '535722509', 1, 3, 4, 4, 99.00, 99.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Mollie', 'success', 'tr_rY7HW8CoWJ', 'complete_by_buyer', 'approved', 'complete', '2024-07-15 08:03:26', '2024-07-15 08:11:17', NULL),
(6, '1246543857', 1, 3, 4, 4, 30.00, 30.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Paypal', 'success', 'ZUJKUEUDELUGE', 'complete_by_buyer', 'approved', 'complete', '2024-07-15 08:10:35', '2025-07-19 08:31:25', 'uploads/custom-images/file-name-17529138855285.png'),
(7, '1149560676', 1, 7, 1, 1, 59.00, 59.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'txn_3Rq73kF56Pb8BOOX1GME5QJH', 'complete_by_buyer', 'approved', 'complete', '2025-07-29 06:31:26', '2025-07-29 06:47:22', 'uploads/custom-images/file-name-17537708936385.pdf'),
(8, '416152177', 7, 3, 4, 4, 30.00, 30.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'txn_3Rq7LAF56Pb8BOOX01t0e161', 'pending', 'pending', 'pending', '2025-07-29 06:49:26', '2025-07-29 06:49:26', NULL),
(9, '927282243', 1, 3, 4, 4, 30.00, 30.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'txn_3Rq7NTF56Pb8BOOX0QZFg6jT', 'complete_by_buyer', 'approved', 'complete', '2025-07-29 06:51:49', '2025-07-29 09:52:51', 'uploads/custom-images/file-name-17537827717980.zip'),
(10, '1597276654', 1, 3, 4, 4, 30.00, 30.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'txn_3RqRY6F56Pb8BOOX1Ewl5r1H', 'cancel_by_buyer', 'approved', 'pending', '2025-07-30 04:24:12', '2025-07-30 04:30:44', 'uploads/custom-images/file-name-17538494886850.png'),
(11, '182887588', 1, 3, 4, 4, 30.00, 30.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'txn_3RqSWAF56Pb8BOOX1Trvmq6A', 'pending', 'pending', 'pending', '2025-07-30 05:26:13', '2025-07-30 05:26:13', NULL),
(12, '539007788', 1, 3, 4, 4, 30.00, 30.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Wallet', 'success', 'wallet', 'pending', 'pending', 'pending', '2025-07-30 05:31:12', '2025-07-30 05:31:12', NULL),
(13, '540956422', 1, 7, 1, 1, 59.00, 59.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'pi_3RuUyoF56Pb8BOOX116jKfXg', 'pending', 'pending', 'pending', '2025-08-10 08:52:22', '2025-08-10 08:52:22', NULL),
(14, '93465268', 1, 7, 2, 2, 60.00, 60.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'pi_3RuVFIF56Pb8BOOX0ODHmQFa', 'pending', 'pending', 'pending', '2025-08-10 09:09:01', '2025-08-10 09:09:01', NULL),
(15, '1057066889', 1, 7, 1, 1, 59.00, 59.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'pi_3RuVVpF56Pb8BOOX0I9ZvcX3', 'pending', 'pending', 'pending', '2025-08-10 09:26:06', '2025-08-10 09:26:06', NULL),
(16, '787389335', 1, 7, 1, 1, 59.00, 59.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'pi_3RuVreF56Pb8BOOX1OsBOG9P', 'pending', 'pending', 'pending', '2025-08-10 09:48:41', '2025-08-10 09:48:41', NULL),
(17, '1046906461', 1, 7, 1, 1, 59.00, 59.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'pi_3RuVuXF56Pb8BOOX1t4OCwH6', 'pending', 'pending', 'pending', '2025-08-10 09:51:43', '2025-08-10 09:51:43', NULL),
(18, '1737851292', 1, 7, 1, 1, 59.00, 59.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'pi_3RuW7TKR6EwGbT2q1F0NiJXA', 'pending', 'pending', 'pending', '2025-08-10 10:06:16', '2025-08-10 10:06:16', NULL),
(19, '1467640022', 1, 7, 1, 1, 59.00, 59.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'pi_3RuWH9F56Pb8BOOX0bi5G9vS', 'pending', 'pending', 'pending', '2025-08-10 10:15:07', '2025-08-10 10:15:07', NULL),
(20, '227651617', 1, 7, 1, 1, 59.00, 59.00, 0.00, 'Basic', 'Get a basic 10-screen Mobile App Design or Development', '1', '1', 'no', '4', 'yes', 'no', 'no', 'no', 'Stripe', 'success', 'pi_3RuWVAAExj09zAgw1bplyBeH', 'pending', 'pending', 'pending', '2025-08-10 10:29:33', '2025-08-10 10:29:33', NULL);

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payment_gateways`
--

CREATE TABLE `payment_gateways` (
  `id` bigint UNSIGNED NOT NULL,
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `payment_gateways`
--

INSERT INTO `payment_gateways` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'stripe_status', '1', NULL, '2025-08-10 10:28:36'),
(2, 'stripe_image', 'uploads/website-images/stripe-2024-06-26-09-11-39-8478.png', NULL, '2024-06-26 03:11:39'),
(3, 'stripe_currency_id', '1', NULL, '2025-08-10 10:28:36'),
(4, 'stripe_key', 'pk_test_51RuWSIAExj09zAgwgvrxGvM225Zw3hmvOO6wzx1LfJ6jtnBEjaj4GhZb2aRa3wUP5cBnsuq2yXsNBfhdWDTgVUVg00IIlR0AVb', NULL, '2025-08-10 10:28:36'),
(5, 'stripe_secret', 'sk_test_51RuWSIAExj09zAgwVAEvOu9ZAwUhbiTJks1eECvsx5Y8TAsu9J6vfmOmWn4dQyBv87JbGJsmp3SbKWc9wAJ0jtiA00CsnoE6yE', NULL, '2025-08-10 10:28:36'),
(6, 'paypal_status', '1', NULL, '2024-06-27 06:52:59'),
(7, 'paypal_image', 'uploads/website-images/paypal-2024-06-26-09-12-11-9195.png', NULL, '2024-06-26 03:12:11'),
(8, 'paypal_account_mode', 'sandbox', NULL, '2024-06-27 06:52:59'),
(9, 'paypal_currency_id', '1', NULL, '2024-07-10 05:34:33'),
(10, 'paypal_client_id', 'AWlV5x8Lhj9BRF8-TnawXtbNs-zt69mMVXME1BGJUIoDdrAYz8QIeeTBQp0sc2nIL9E529KJZys32Ipy', NULL, '2024-06-27 06:52:59'),
(11, 'paypal_secret_key', 'EEvn1J_oIC6alxb-FoF4t8buKwy4uEWHJ4_Jd_wolaSPRMzFHe6GrMrliZAtawDDuE-WKkCKpWGiz0Yn', NULL, '2024-06-27 06:52:59'),
(12, 'razorpay_status', '1', NULL, '2025-06-25 09:06:09'),
(13, 'razorpay_image', 'uploads/custom-images/file-name-17508423695346.png', NULL, '2025-06-25 09:06:09'),
(14, 'razorpay_currency_id', '8', NULL, '2025-06-25 09:06:09'),
(15, 'razorpay_key', 'rzp_test_K7CipNQYyyMPiS', NULL, '2025-06-25 09:06:09'),
(16, 'razorpay_secret', 'zSBmNMorJrirOrnDrbOd1ALO', NULL, '2025-06-25 09:06:09'),
(17, 'razorpay_name', 'WorkZone', NULL, '2025-06-25 09:06:09'),
(18, 'razorpay_description', 'Online MarketPlace', NULL, '2025-06-25 09:06:09'),
(19, 'razorpay_theme_color', '#57c20f', NULL, '2025-06-25 09:06:09'),
(20, 'flutterwave_status', '1', NULL, '2024-06-30 08:03:34'),
(21, 'flutterwave_logo', 'uploads/website-images/paypal-2024-06-26-09-12-33-6846.png', NULL, '2024-06-26 03:12:33'),
(22, 'flutterwave_currency_id', '1', NULL, '2024-07-10 05:34:33'),
(23, 'flutterwave_public_key', 'FLWPUBK_TEST-5760e3ff9888aa1ab5e5cd1ec3f99cb1-X', NULL, '2024-06-30 08:03:34'),
(24, 'flutterwave_secret_key', 'FLWSECK_TEST-81cb5da016d0a51f7329d4a8057e766d-X', NULL, '2024-06-30 08:03:34'),
(25, 'flutterwave_title', 'WorkZone', NULL, '2024-06-30 08:03:34'),
(26, 'mollie_status', '1', NULL, '2024-07-03 04:47:49'),
(27, 'mollie_image', 'uploads/website-images/paypal-2024-06-26-09-12-39-3044.png', NULL, '2024-06-26 03:12:39'),
(28, 'mollie_currency_id', '1', NULL, '2024-07-10 05:34:33'),
(29, 'mollie_key', 'test_p9qgUn7Sg22xF3Q8D9heBSVEzrzM5Q', NULL, '2024-07-03 04:47:49'),
(30, 'paystack_status', '1', NULL, '2024-07-03 05:17:44'),
(31, 'paystack_image', 'uploads/website-images/paypal-2024-06-26-09-12-47-9168.png', NULL, '2024-06-26 03:12:47'),
(32, 'paystack_currency_id', '1', NULL, '2024-07-10 05:34:33'),
(33, 'paystack_public_key', 'pk_test_057dfe5dee14eaf9c3b4573df1e3760c02c06e38', NULL, '2024-07-03 05:17:44'),
(34, 'paystack_secret_key', 'sk_test_77cb93329abbdc18104466e694c9f720a7d69c97', NULL, '2024-07-03 05:17:44'),
(35, 'instamojo_status', '1', NULL, '2024-07-03 06:04:33'),
(36, 'instamojo_image', 'uploads/website-images/paypal-2024-06-26-09-12-53-1868.png', NULL, '2024-06-26 03:12:53'),
(37, 'instamojo_account_mode', 'Sandbox', NULL, '2024-07-03 06:04:33'),
(38, 'instamojo_currency_id', '1', NULL, '2024-07-10 05:34:33'),
(39, 'instamojo_api_key', 'test_5f4a2c9a58ef216f8a1a688910f', NULL, '2024-07-03 06:04:33'),
(40, 'instamojo_auth_token', 'test_994252ada69ce7b3d282b9941c2', NULL, '2024-07-03 06:04:33'),
(41, 'bank_status', '1', NULL, '2025-06-25 09:07:49'),
(42, 'bank_image', 'uploads/custom-images/file-name-17508424692769.png', NULL, '2025-06-25 09:07:49'),
(43, 'bank_account_info', 'Bank Name: Your bank name\r\nAccount Number:  Your bank account number\r\nRouting Number: Your bank routing number\r\nBranch: Your bank branch name', NULL, '2025-06-25 09:07:49');

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

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

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `privacy_policies`
--

CREATE TABLE `privacy_policies` (
  `id` bigint UNSIGNED NOT NULL,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `privacy_policies`
--

INSERT INTO `privacy_policies` (`id`, `lang_code`, `description`, `created_at`, `updated_at`) VALUES
(1, 'en', '<h4>01.Introduction</h4>\r\n<p>A Privacy Policy is a legal document that informs users about the data collected, how it\'s used, and how it\'s protected. It typically includes information about the type of personal our ainformation collected (such as names, email addresses, etc.), the purpose of collection, and whether the information is shared with third parties. It outlines the rights of users regarding their data, such as the right to access, correct, or delete their information.</p>\r\n<h4>02.Workzone of Privacy and Policy</h4>\r\n<p>Terms of Service (also known as Terms and Conditions or Terms of Use) set the rules and guidelines for using a particular service or platform. They establish the contractual relationship between the user and the service provider. They often include details about user behavior, content usage policies, disclaimers, limitations of liability, and procedures for dispute resolution.Users typically agree to these terms by using the service.When you visit a website or use an online service, you are usually asked to agree to both the Privacy Policy and the Terms of Service. These documents are crucial for transparency, legal compliance, and establishing the terms under which users can access and use the service.</p>\r\n<p>It\'s important for businesses and service providers to keep these documents up-to-date and easily accessible to users. If you have specific questions or concerns about privacy policies or terms of service, feel free to provide more details, and I\'ll do my best to assist you.</p>\r\n<h4>3. Protect Your Property</h4>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown as printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuriezcs but also the on leap into as eylectronic typesetting, remaining as essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of Letraszvxet sheets containing Lorem Ipsum our spassages, andei more recently with a desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book. five centuries but also a the on leap into electronic typesetting, remaining essentially unchanged. It aswasn&rsquo;t popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, andei more recently with desktop our aspublishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>\r\n<h4>4. What to Include in Terms and Conditions for Limitations of Liability</h4>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the as1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five as centuries but also the on leap into as electronic ki typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of as Leitraset sheets containing Loriem Ipsum passages, our andei more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>\r\n<p>ive centuries but also the on leap into electronic typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of Letraset as sheets containing Lorem Ipsum passages, andei more recently with desktop publishing software like Aldus PageMaker our as including versions of Loriem Ipsum to make a type our as specimen book. It wasn&rsquo;t popularised in the 1960s with the release of Letraset sheets as containing Lorem Ipsum passages, andei more recently with a desktop publishing software like Aldus PageMaker including versions of Loremas Ipsum to make a type specimen book.</p>\r\n<h4>05.Pricing and Payment Policy</h4>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the as 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five as centuries but also as the on leap into electronic as typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release as of Letraset sheets containing Lorem Ipsum our spassages, andei more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>\r\n<p>five centuries but also the on leap into electronic typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, andei more recently with desktop publishing software like Aldus PageMaker our as including versions of Lorem aIpsum to make a type specimen our as book. It wasn&rsquo;t popularised in the 1960s with the release of Letraset sheetsasd containing Lorem Ipsum passages, andei more recentlysl with desktop publishing software like Aldus PageMaker including versions of Loremadfsfds Ipsum to make a type specimen book.</p>\r\n<p>It has survived not only five centuries but also the on leap into electronic typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the our 1960s with the release of Letraset sheets containing Lorem Ipsum passages, andei more recently with desktop publishing asou software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>', NULL, '2024-07-10 08:24:22'),
(19, 'hd', '<h4>01.Introduction</h4>\r\n<p>A Privacy Policy is a legal document that informs users about the data collected, how it\'s used, and how it\'s protected. It typically includes information about the type of personal our ainformation collected (such as names, email addresses, etc.), the purpose of collection, and whether the information is shared with third parties. It outlines the rights of users regarding their data, such as the right to access, correct, or delete their information.</p>\r\n<h4>02.Freelance Terms of Service (Privacy and Policy)</h4>\r\n<p>Terms of Service (also known as Terms and Conditions or Terms of Use) set the rules and guidelines for using a particular service or platform. They establish the contractual relationship between the user and the service provider. They often include details about user behavior, content usage policies, disclaimers, limitations of liability, and procedures for dispute resolution.Users typically agree to these terms by using the service.When you visit a website or use an online service, you are usually asked to agree to both the Privacy Policy and the Terms of Service. These documents are crucial for transparency, legal compliance, and establishing the terms under which users can access and use the service.</p>\r\n<p>It\'s important for businesses and service providers to keep these documents up-to-date and easily accessible to users. If you have specific questions or concerns about privacy policies or terms of service, feel free to provide more details, and I\'ll do my best to assist you.</p>\r\n<h4>3. Protect Your Property</h4>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown as printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuriezcs but also the on leap into as eylectronic typesetting, remaining as essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of Letraszvxet sheets containing Lorem Ipsum our spassages, andei more recently with a desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book. five centuries but also a the on leap into electronic typesetting, remaining essentially unchanged. It aswasn&rsquo;t popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, andei more recently with desktop our aspublishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>\r\n<h4>4. What to Include in Terms and Conditions for Limitations of Liability</h4>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the as1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five as centuries but also the on leap into as electronic ki typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of as Leitraset sheets containing Loriem Ipsum passages, our andei more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>\r\n<p>ive centuries but also the on leap into electronic typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of Letraset as sheets containing Lorem Ipsum passages, andei more recently with desktop publishing software like Aldus PageMaker our as including versions of Loriem Ipsum to make a type our as specimen book. It wasn&rsquo;t popularised in the 1960s with the release of Letraset sheets as containing Lorem Ipsum passages, andei more recently with a desktop publishing software like Aldus PageMaker including versions of Loremas Ipsum to make a type specimen book.</p>\r\n<h4>05.Pricing and Payment Policy</h4>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the as 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five as centuries but also as the on leap into electronic as typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release as of Letraset sheets containing Lorem Ipsum our spassages, andei more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>\r\n<p>five centuries but also the on leap into electronic typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, andei more recently with desktop publishing software like Aldus PageMaker our as including versions of Lorem aIpsum to make a type specimen our as book. It wasn&rsquo;t popularised in the 1960s with the release of Letraset sheetsasd containing Lorem Ipsum passages, andei more recentlysl with desktop publishing software like Aldus PageMaker including versions of Loremadfsfds Ipsum to make a type specimen book.</p>\r\n<p>It has survived not only five centuries but also the on leap into electronic typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the our 1960s with the release of Letraset sheets containing Lorem Ipsum passages, andei more recently with desktop publishing asou software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>', '2024-07-10 05:34:58', '2024-07-10 05:34:58');

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

--
-- Table structure for table `refund_requests`
--

CREATE TABLE `refund_requests` (
  `id` bigint UNSIGNED NOT NULL,
  `buyer_id` int NOT NULL DEFAULT '0',
  `seller_id` int NOT NULL DEFAULT '0',
  `order_id` int NOT NULL DEFAULT '0',
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `refund_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending' COMMENT 'pending,rejected,approved',
  `note2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `job_request_id` int DEFAULT NULL,
  `refund_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'order',
  `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 `refund_requests`
--

INSERT INTO `refund_requests` (`id`, `buyer_id`, `seller_id`, `order_id`, `note`, `refund_amount`, `status`, `note2`, `job_request_id`, `refund_type`, `created_at`, `updated_at`) VALUES
(1, 1, 5, 2, 'please refund the balance', 99.00, 'approved', NULL, NULL, 'order', '2024-07-30 02:15:52', '2024-07-30 02:16:36'),
(2, 1, 3, 10, 'please refund amount', 30.00, 'pending', NULL, NULL, 'order', '2025-07-30 05:23:39', '2025-07-30 05:23:39'),
(3, 1, 3, 0, 'cancel', 70.00, 'pending', NULL, 31, 'job', '2025-07-30 06:23:12', '2025-07-30 06:23:12'),
(4, 1, 3, 0, NULL, 120.00, 'approved', 'Cancel Order seller Richard', 32, 'job', '2025-07-30 08:25:00', '2025-07-30 09:18:04'),
(5, 1, 3, 0, NULL, 100.00, 'rejected', 'sorry i can&#039;t do this', 36, 'job', '2025-07-30 10:54:34', '2025-07-30 10:55:15'),
(6, 1, 3, 0, 'erert', 20.00, 'approved', NULL, 38, 'job', '2025-07-30 11:06:32', '2025-07-30 11:14:35'),
(7, 10, 11, 22, 'test bank', 26.00, 'approved', NULL, NULL, 'order', '2025-08-16 12:01:28', '2025-08-16 12:03:50'),
(8, 10, 11, 0, 'test', 20.00, 'approved', NULL, 40, 'job', '2025-08-16 12:42:13', '2025-08-16 12:48:35'),
(9, 10, 11, 0, 'test', 10.00, 'pending', NULL, 42, 'job', '2025-08-16 13:23:20', '2025-08-16 13:23:20');

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

--
-- Table structure for table `restricted_keywords`
--

CREATE TABLE `restricted_keywords` (
  `id` bigint UNSIGNED NOT NULL,
  `keyword_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `restricted_keywords`
--

INSERT INTO `restricted_keywords` (`id`, `keyword_name`, `created_at`, `updated_at`) VALUES
(9, 'number', '2025-07-05 10:48:19', '2025-07-05 10:48:19'),
(10, '@', '2025-07-05 11:01:37', '2025-07-05 11:01:37'),
(11, 'http', '2025-07-05 11:29:39', '2025-07-05 11:29:39'),
(12, 'https', '2025-07-05 11:29:50', '2025-07-05 11:29:50'),
(13, 'www', '2025-07-05 11:30:01', '2025-07-05 11:30:01'),
(14, 'Hi', '2025-07-09 04:59:20', '2025-07-09 04:59:20');

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

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

CREATE TABLE `reviews` (
  `id` bigint UNSIGNED NOT NULL,
  `order_id` int NOT NULL,
  `listing_id` int NOT NULL,
  `buyer_id` int NOT NULL,
  `seller_id` int NOT NULL,
  `rating` int NOT NULL,
  `review` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'disable',
  `review_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'buyer',
  `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 `reviews`
--

INSERT INTO `reviews` (`id`, `order_id`, `listing_id`, `buyer_id`, `seller_id`, `rating`, `review`, `status`, `review_by`, `created_at`, `updated_at`) VALUES
(1, 4, 4, 1, 3, 4, 'There are many variations of passages of Lorem Ipsum available, but the our as majoritys have su alteration in some form, by injected humour, or randomised words which don&#039;t.', 'disable', 'buyer', '2024-07-15 08:09:21', '2024-07-15 08:09:50'),
(2, 3, 10, 1, 7, 3, 'There are many variations of passages of Lorem Ipsum available, but the our as majoritys have su alteration in some form, by injected humour, or randomised words which don&#039;t.', 'enable', 'buyer', '2024-07-15 08:09:36', '2024-07-15 08:09:44'),
(3, 6, 4, 1, 3, 3, 'There are many variations of passages of Lorem Ipsum available, but the our as majoritys have su alteration in some form, by injected humour, or randomised words which don&#039;t.', 'enable', 'buyer', '2024-07-15 08:11:12', '2024-07-15 08:11:49'),
(4, 5, 4, 1, 3, 5, 'There are many variations of passages of Lorem Ipsum available, but the our as majoritys have su alteration in some form, by injected humour, or randomised words which don&#039;t.', 'enable', 'buyer', '2024-07-15 08:11:22', '2024-07-15 08:11:44'),
(5, 7, 1, 1, 7, 5, 'Good Job', 'disable', 'buyer', '2025-07-29 06:47:44', '2025-07-29 06:47:44'),
(6, 9, 4, 1, 3, 5, 'There are many variations of passages of Lorem Ipsum available, but the our as majoritys have su alteration in some form, by injected humour, or randomised words which don&#039;t.', 'enable', 'buyer', '2025-07-29 08:16:39', '2025-07-29 08:16:39');

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

--
-- Table structure for table `seller_levels`
--

CREATE TABLE `seller_levels` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `min_orders` int NOT NULL DEFAULT '0',
  `commission` decimal(5,2) NOT NULL,
  `basic_price` decimal(8,2) NOT NULL DEFAULT '0.00',
  `min_order_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `is_new_seller` enum('yes','no') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no',
  `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 `seller_levels`
--

INSERT INTO `seller_levels` (`id`, `name`, `icon`, `min_orders`, `commission`, `basic_price`, `min_order_amount`, `is_new_seller`, `created_at`, `updated_at`) VALUES
(1, 'New Seller', 'uploads/website-images/new-seller.png', 0, 25.00, 500.00, 0.00, 'yes', '2025-12-02 03:59:23', '2025-12-02 03:59:23'),
(2, 'Level 1', 'uploads/website-images/level-one.png', 3, 20.00, 1000.00, 1500.00, 'no', '2025-12-02 03:59:23', '2025-12-02 03:59:23'),
(3, 'Level 2', 'uploads/website-images/level-two.png', 5, 15.00, 1500.00, 2000.00, 'no', '2025-12-02 03:59:23', '2025-12-02 03:59:23'),
(4, 'Level 3', 'uploads/website-images/level-three.png', 7, 10.00, 2000.00, 3500.00, 'no', '2025-12-02 03:59:23', '2025-12-02 03:59:23'),
(5, 'Cre8ers Choice', 'uploads/website-images/level-four.png', 10, 5.00, 2500.00, 4500.00, 'no', '2025-12-02 03:59:23', '2025-12-02 03:59:23'),
(6, 'Top Rated', 'uploads/website-images/top-seller.png', 15, 1.00, 5000.00, 15000.00, 'no', '2025-12-02 03:59:23', '2025-12-02 03:59:23');

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

--
-- Table structure for table `seller_level_histories`
--

CREATE TABLE `seller_level_histories` (
  `id` bigint UNSIGNED NOT NULL,
  `seller_id` bigint UNSIGNED NOT NULL,
  `seller_level_id` bigint UNSIGNED NOT NULL,
  `level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `assigned_at` datetime NOT NULL,
  `orders_at_assignment` int DEFAULT NULL,
  `order_amount_at_assignment` decimal(10,2) 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 `seller_level_histories`
--

INSERT INTO `seller_level_histories` (`id`, `seller_id`, `seller_level_id`, `level`, `assigned_at`, `orders_at_assignment`, `order_amount_at_assignment`, `created_at`, `updated_at`) VALUES
(1, 3, 1, 'New Seller', '2025-12-02 10:09:18', 0, 0.00, '2025-12-02 04:09:18', '2025-12-02 04:09:18'),
(2, 4, 1, 'New Seller', '2025-12-02 10:09:18', 0, 0.00, '2025-12-02 04:09:18', '2025-12-02 04:09:18'),
(3, 5, 1, 'New Seller', '2025-12-02 10:09:18', 0, 0.00, '2025-12-02 04:09:18', '2025-12-02 04:09:18'),
(4, 6, 1, 'New Seller', '2025-12-02 10:09:18', 0, 0.00, '2025-12-02 04:09:18', '2025-12-02 04:09:18'),
(5, 7, 1, 'New Seller', '2025-12-02 10:09:18', 0, 0.00, '2025-12-02 04:09:18', '2025-12-02 04:09:18'),
(6, 11, 1, 'New Seller', '2025-12-02 10:09:18', 0, 0.00, '2025-12-02 04:09:18', '2025-12-02 04:09:18');

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

--
-- Table structure for table `seller_withdraws`
--

CREATE TABLE `seller_withdraws` (
  `id` bigint UNSIGNED NOT NULL,
  `seller_id` int NOT NULL,
  `withdraw_method_id` int NOT NULL,
  `withdraw_method_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `withdraw_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `charge_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `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 `seller_withdraws`
--

INSERT INTO `seller_withdraws` (`id`, `seller_id`, `withdraw_method_id`, `withdraw_method_name`, `total_amount`, `withdraw_amount`, `charge_amount`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 3, 1, 'Bank Payment', 10.00, 9.95, 0.05, 'Account : 93843943\r\nIBBL Dhaka', 'approved', '2024-07-15 09:24:22', '2024-07-15 09:25:16'),
(2, 3, 1, 'Bank Payment', 10.00, 9.95, 0.05, 'Account : 93843945\r\nDBBL Dhaka', 'approved', '2024-07-15 09:24:48', '2024-07-15 09:25:01'),
(3, 3, 1, 'Bank Payment', 10.00, 9.95, 0.05, 'Branch: Your bank branch name', 'pending', '2024-09-15 03:55:24', '2024-09-15 03:55:24'),
(4, 11, 1, 'Bank Payment', 10.00, 9.95, 0.05, 'test', 'approved', '2025-08-16 12:04:40', '2025-08-16 12:05:12');

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

--
-- Table structure for table `seo_settings`
--

CREATE TABLE `seo_settings` (
  `id` bigint UNSIGNED NOT NULL,
  `page_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `seo_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `seo_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `seo_settings`
--

INSERT INTO `seo_settings` (`id`, `page_name`, `seo_title`, `seo_description`, `created_at`, `updated_at`) VALUES
(1, 'Home', 'Home Page', '<p>Home Page</p>', NULL, '2024-05-09 04:12:51'),
(2, 'Blogs', 'Blogs', 'Blogs', NULL, NULL),
(3, 'About Us', 'About Us', '<p>About Us</p>', NULL, '2024-07-02 11:43:46'),
(4, 'Contact Us', 'Contact Us', '<p>Contact Us</p>', NULL, '2024-05-09 04:12:54'),
(5, 'FAQ', 'FAQ', 'FAQ', NULL, NULL),
(6, 'Terms & Conditions', 'Terms & Conditions', 'Terms & Conditions', NULL, NULL),
(7, 'Freelancer', 'Freelancer', 'Freelancer', NULL, NULL),
(8, 'Job Post', 'Job Post', 'Job Post', NULL, NULL),
(9, 'Privacy Policy', 'Privacy Policy', 'Privacy Policy', NULL, NULL),
(10, 'Service', 'Service', 'Service', NULL, NULL);

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint UNSIGNED NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `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 `sliders`
--

INSERT INTO `sliders` (`id`, `image`, `title`, `status`, `created_at`, `updated_at`) VALUES
(3, 'uploads/website-images/slider-image-2025-05-10-03-05-18-8846.webp', 'Find Your Perfect Freelancer Quick and Easy', 'active', '2025-05-10 09:05:18', '2025-05-10 09:05:18'),
(4, 'uploads/website-images/slider-image-2025-05-10-03-05-29-6242.webp', 'Find Your Perfect Freelancer Quick and Easy', 'active', '2025-05-10 09:05:29', '2025-05-10 09:05:29'),
(5, 'uploads/custom-images/file-name-17508438814051.png', 'zxfdfas', 'active', '2025-06-25 09:31:21', '2025-06-25 09:31:21');

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

--
-- Table structure for table `subscription_histories`
--

CREATE TABLE `subscription_histories` (
  `id` bigint UNSIGNED NOT NULL,
  `order_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `subscription_plan_id` int NOT NULL,
  `plan_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `plan_price` decimal(8,2) NOT NULL,
  `expiration_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `max_listing` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `featured_listing` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `recommended_seller` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `payment_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `transaction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `subscription_histories`
--

INSERT INTO `subscription_histories` (`id`, `order_id`, `user_id`, `subscription_plan_id`, `plan_name`, `plan_price`, `expiration_date`, `expiration`, `max_listing`, `featured_listing`, `recommended_seller`, `status`, `payment_method`, `payment_status`, `transaction`, `created_at`, `updated_at`) VALUES
(1, '1145225003', 4, 2, 'Silver', 19.99, '2025-09-12', 'yearly', '50', '10', 'active', 'expired', 'hand_cash', 'success', 'hand_cash', '2024-09-12 10:05:58', '2024-09-12 10:18:29'),
(3, '1505247687', 3, 3, 'Gold', 49.99, 'lifetime', 'lifetime', '50', '15', 'active', 'expired', 'hand_cash', 'success', 'hand_cash', '2024-09-12 10:14:00', '2024-09-15 05:14:59'),
(4, '1498578875', 3, 1, 'Free', 0.00, '2024-10-12', 'monthly', '20', '5', 'inactive', 'expired', 'Free', 'success', 'hand_cash', '2024-09-12 10:15:18', '2024-09-15 05:14:59'),
(5, '349907814', 4, 2, 'Silver', 19.99, '2025-09-12', 'yearly', '50', '10', 'active', 'active', 'hand_cash', 'success', 'hand_cash', '2024-09-12 10:18:29', '2024-09-12 10:18:29'),
(6, '739253305', 3, 2, 'Silver', 19.99, '2025-09-13', 'yearly', '50', '10', 'active', 'expired', 'hand_cash', 'success', 'hand_cash', '2024-09-13 11:59:31', '2024-09-15 05:14:59'),
(7, '175171775', 3, 2, 'Silver', 19.99, '2025-09-14', 'yearly', '50', '10', 'active', 'expired', 'Paypal', 'success', 'ZUJKUEUDELUGE', '2024-09-13 12:10:44', '2024-09-15 05:14:59'),
(8, '528079858', 3, 2, 'Silver', 19.99, '2025-09-14', 'yearly', '50', '10', 'active', 'expired', 'Instamojo', 'success', 'MOJO4913005A66463449', '2024-09-13 12:14:54', '2024-09-15 05:14:59'),
(11, '1382072656', 3, 4, 'Premium', 99.99, 'lifetime', 'lifetime', '100', '20', 'active', 'active', 'Stripe', 'success', 'txn_3PzAnWF56Pb8BOOX1Emhu447', '2024-09-15 05:14:59', '2024-09-15 05:14:59');

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

--
-- Table structure for table `subscription_plans`
--

CREATE TABLE `subscription_plans` (
  `id` bigint UNSIGNED NOT NULL,
  `plan_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `plan_price` decimal(8,2) NOT NULL,
  `expiration_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `max_listing` int NOT NULL DEFAULT '0',
  `featured_listing` int NOT NULL DEFAULT '0',
  `recommended_seller` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `serial` int 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 `subscription_plans`
--

INSERT INTO `subscription_plans` (`id`, `plan_name`, `plan_price`, `expiration_date`, `max_listing`, `featured_listing`, `recommended_seller`, `status`, `serial`, `created_at`, `updated_at`) VALUES
(1, 'Free', 0.00, 'monthly', 20, 0, 'inactive', 'active', 1, '2024-08-29 05:44:14', '2024-09-12 11:11:24'),
(2, 'Silver', 19.99, 'yearly', 20, 0, 'inactive', 'active', 2, '2024-08-29 05:48:12', '2024-09-15 04:53:39'),
(3, 'Gold', 49.99, 'lifetime', 50, 15, 'active', 'active', 3, '2024-08-29 05:48:48', '2024-08-29 05:48:48'),
(4, 'Premium', 99.99, 'lifetime', 100, 20, 'active', 'active', 4, '2024-09-15 04:53:27', '2024-09-15 04:53:27');

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

--
-- Table structure for table `sub_categories`
--

CREATE TABLE `sub_categories` (
  `id` bigint UNSIGNED NOT NULL,
  `category_id` bigint UNSIGNED NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `sub_categories`
--

INSERT INTO `sub_categories` (`id`, `category_id`, `slug`, `status`, `created_at`, `updated_at`) VALUES
(11, 6, 'logo-design', 'enable', '2024-08-26 04:50:41', '2024-08-26 04:50:41'),
(12, 6, 'brand-style-guides', 'enable', '2024-08-26 04:50:54', '2024-08-26 04:50:54'),
(13, 6, 'business-cards-stationery', 'enable', '2024-08-26 04:51:06', '2024-08-26 04:51:06'),
(14, 6, 'fonts-typography', 'enable', '2024-08-26 04:51:18', '2024-08-26 04:51:18'),
(15, 6, 'illustration', 'enable', '2024-08-26 04:51:31', '2024-08-26 04:51:31'),
(16, 8, 'frontend-development', 'enable', '2024-08-26 04:53:38', '2024-08-26 04:53:38'),
(17, 8, 'backend-development', 'enable', '2024-08-26 04:53:49', '2024-08-26 04:53:49'),
(18, 8, 'fullstack-development', 'enable', '2024-08-26 04:54:01', '2024-08-26 04:54:01'),
(19, 8, 'web-mobile-design', 'enable', '2024-08-26 04:54:12', '2024-08-26 04:54:12'),
(20, 8, 'cms-development-eg-wordpress-joomla', 'enable', '2024-08-26 04:54:21', '2024-08-26 04:54:21'),
(21, 3, 'social-media-marketing', 'enable', '2024-08-26 04:54:40', '2024-08-26 04:54:40'),
(22, 3, 'seo-optimization', 'enable', '2024-08-26 04:54:52', '2024-08-26 04:54:52'),
(23, 3, 'content-marketing', 'enable', '2024-08-26 04:55:01', '2024-08-26 04:55:01'),
(24, 3, 'email-marketing', 'enable', '2024-08-26 04:55:13', '2024-08-26 04:55:13'),
(25, 3, 'paid-advertising-eg-google-ads-facebook-ads', 'enable', '2024-08-26 04:55:24', '2024-08-26 04:55:24'),
(26, 12, 'residential-design', 'enable', '2024-08-26 05:02:47', '2024-08-26 05:02:47'),
(27, 12, 'commercial-design', 'enable', '2024-08-26 05:03:04', '2024-08-26 05:03:04'),
(28, 12, 'landscape-architecture', 'enable', '2024-08-26 05:03:14', '2024-08-26 05:03:14'),
(29, 12, 'interior-design', 'enable', '2024-08-26 05:03:24', '2024-08-26 05:03:24'),
(30, 12, 'urban-planning', 'enable', '2024-08-26 05:03:34', '2024-08-26 05:03:34'),
(31, 11, 'xui-design', 'enable', '2024-08-26 05:03:53', '2024-08-26 05:03:53'),
(32, 11, 'responsive-design', 'enable', '2024-08-26 05:04:02', '2024-08-26 05:04:02'),
(33, 11, 'wordpress-design', 'enable', '2024-08-26 05:04:10', '2024-08-26 05:04:10'),
(34, 11, 'ecommerce-design', 'enable', '2024-08-26 05:04:20', '2024-08-26 05:04:20'),
(35, 11, 'landing-page-design', 'enable', '2024-08-26 05:04:29', '2024-08-26 05:04:29'),
(36, 10, 'machine-learning', 'enable', '2024-08-26 05:04:39', '2024-08-26 05:04:39'),
(37, 10, 'ai-chatbots', 'enable', '2024-08-26 05:04:48', '2024-08-26 05:04:48'),
(38, 10, 'natural-language-processing', 'enable', '2024-08-26 05:05:03', '2024-08-26 05:05:03'),
(39, 10, 'predictive-analytics', 'enable', '2024-08-26 05:05:14', '2024-08-26 05:05:14'),
(40, 10, 'computer-vision', 'enable', '2024-08-26 05:05:23', '2024-08-26 05:05:23'),
(41, 7, 'portrait-photography', 'enable', '2024-08-26 05:06:09', '2024-08-26 05:06:09'),
(42, 7, 'event-photography', 'enable', '2024-08-26 05:06:20', '2024-08-26 05:06:20'),
(43, 7, 'product-photography', 'enable', '2024-08-26 05:06:30', '2024-08-26 05:06:30'),
(44, 7, 'photo-editing', 'enable', '2024-08-26 05:06:38', '2024-08-26 05:06:38'),
(45, 7, 'stock-photography', 'enable', '2024-08-26 05:06:49', '2024-08-26 05:06:49'),
(46, 4, '2d-animation', 'enable', '2024-08-26 05:07:03', '2024-08-26 05:07:03'),
(47, 4, '3d-animation', 'enable', '2024-08-26 05:07:13', '2024-08-26 05:07:13'),
(48, 4, 'motion-graphics', 'enable', '2024-08-26 05:07:24', '2024-08-26 05:07:24'),
(49, 4, 'whiteboard-animation', 'enable', '2024-08-26 05:07:35', '2024-08-26 05:07:35'),
(50, 4, 'character-animation', 'enable', '2024-08-26 05:07:46', '2024-08-26 05:07:46');

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

--
-- Table structure for table `sub_category_translates`
--

CREATE TABLE `sub_category_translates` (
  `id` bigint UNSIGNED NOT NULL,
  `subcategory_id` bigint UNSIGNED NOT NULL,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `sub_category_translates`
--

INSERT INTO `sub_category_translates` (`id`, `subcategory_id`, `lang_code`, `name`, `created_at`, `updated_at`) VALUES
(13, 11, 'en', 'Logo Design', '2024-08-26 04:50:41', '2024-08-26 04:50:41'),
(14, 11, 'hd', 'Logo Design', '2024-08-26 04:50:41', '2024-08-26 04:50:41'),
(15, 12, 'en', 'Brand Style Guides', '2024-08-26 04:50:54', '2024-08-26 04:50:54'),
(16, 12, 'hd', 'Brand Style Guides', '2024-08-26 04:50:54', '2024-08-26 04:50:54'),
(17, 13, 'en', 'Business Cards & Stationery', '2024-08-26 04:51:06', '2024-08-26 04:51:06'),
(18, 13, 'hd', 'Business Cards & Stationery', '2024-08-26 04:51:06', '2024-08-26 04:51:06'),
(19, 14, 'en', 'Fonts & Typography', '2024-08-26 04:51:18', '2024-08-26 04:51:18'),
(20, 14, 'hd', 'Fonts & Typography', '2024-08-26 04:51:18', '2024-08-26 04:51:18'),
(21, 15, 'en', 'Illustration', '2024-08-26 04:51:31', '2024-08-26 04:51:31'),
(22, 15, 'hd', 'Illustration', '2024-08-26 04:51:31', '2024-08-26 04:51:31'),
(23, 16, 'en', 'Frontend Development', '2024-08-26 04:53:38', '2024-08-26 04:53:38'),
(24, 16, 'hd', 'Frontend Development', '2024-08-26 04:53:38', '2024-08-26 04:53:38'),
(25, 17, 'en', 'Backend Development', '2024-08-26 04:53:49', '2024-08-26 04:53:49'),
(26, 17, 'hd', 'Backend Development', '2024-08-26 04:53:49', '2024-08-26 04:53:49'),
(27, 18, 'en', 'Full-Stack Development', '2024-08-26 04:54:01', '2024-08-26 04:54:01'),
(28, 18, 'hd', 'Full-Stack Development', '2024-08-26 04:54:01', '2024-08-26 04:54:01'),
(29, 19, 'en', 'Web & Mobile Design', '2024-08-26 04:54:12', '2024-08-26 04:54:12'),
(30, 19, 'hd', 'Web & Mobile Design', '2024-08-26 04:54:12', '2024-08-26 04:54:12'),
(31, 20, 'en', 'CMS Development (e.g., WordPress, Joomla)', '2024-08-26 04:54:21', '2024-08-26 04:54:21'),
(32, 20, 'hd', 'CMS Development (e.g., WordPress, Joomla)', '2024-08-26 04:54:21', '2024-08-26 04:54:21'),
(33, 21, 'en', 'Social Media Marketing', '2024-08-26 04:54:40', '2024-08-26 04:54:40'),
(34, 21, 'hd', 'Social Media Marketing', '2024-08-26 04:54:40', '2024-08-26 04:54:40'),
(35, 22, 'en', 'SEO Optimization', '2024-08-26 04:54:52', '2024-08-26 04:54:52'),
(36, 22, 'hd', 'SEO Optimization', '2024-08-26 04:54:52', '2024-08-26 04:54:52'),
(37, 23, 'en', 'Content Marketing', '2024-08-26 04:55:01', '2024-08-26 04:55:01'),
(38, 23, 'hd', 'Content Marketing', '2024-08-26 04:55:01', '2024-08-26 04:55:01'),
(39, 24, 'en', 'Email Marketing', '2024-08-26 04:55:13', '2024-08-26 04:55:13'),
(40, 24, 'hd', 'Email Marketing', '2024-08-26 04:55:13', '2024-08-26 04:55:13'),
(41, 25, 'en', 'Paid Advertising (e.g., Google Ads, Facebook Ads)', '2024-08-26 04:55:24', '2024-08-26 04:55:24'),
(42, 25, 'hd', 'Paid Advertising (e.g., Google Ads, Facebook Ads)', '2024-08-26 04:55:24', '2024-08-26 04:55:24'),
(43, 26, 'en', 'Residential Design', '2024-08-26 05:02:47', '2024-08-26 05:02:47'),
(44, 26, 'hd', 'Residential Design', '2024-08-26 05:02:47', '2024-08-26 05:02:47'),
(45, 27, 'en', 'Commercial Design', '2024-08-26 05:03:04', '2024-08-26 05:03:04'),
(46, 27, 'hd', 'Commercial Design', '2024-08-26 05:03:04', '2024-08-26 05:03:04'),
(47, 28, 'en', 'Landscape Architecture', '2024-08-26 05:03:14', '2024-08-26 05:03:14'),
(48, 28, 'hd', 'Landscape Architecture', '2024-08-26 05:03:14', '2024-08-26 05:03:14'),
(49, 29, 'en', 'Interior Design', '2024-08-26 05:03:24', '2024-08-26 05:03:24'),
(50, 29, 'hd', 'Interior Design', '2024-08-26 05:03:24', '2024-08-26 05:03:24'),
(51, 30, 'en', 'Urban Planning', '2024-08-26 05:03:34', '2024-08-26 05:03:34'),
(52, 30, 'hd', 'Urban Planning', '2024-08-26 05:03:34', '2024-08-26 05:03:34'),
(53, 31, 'en', 'X/UI Design', '2024-08-26 05:03:53', '2024-08-26 05:03:53'),
(54, 31, 'hd', 'X/UI Design', '2024-08-26 05:03:53', '2024-08-26 05:03:53'),
(55, 32, 'en', 'Responsive Design', '2024-08-26 05:04:02', '2024-08-26 05:04:02'),
(56, 32, 'hd', 'Responsive Design', '2024-08-26 05:04:02', '2024-08-26 05:04:02'),
(57, 33, 'en', 'WordPress Design', '2024-08-26 05:04:10', '2024-08-26 05:04:10'),
(58, 33, 'hd', 'WordPress Design', '2024-08-26 05:04:10', '2024-08-26 05:04:10'),
(59, 34, 'en', 'eCommerce Design', '2024-08-26 05:04:20', '2024-08-26 05:04:20'),
(60, 34, 'hd', 'eCommerce Design', '2024-08-26 05:04:20', '2024-08-26 05:04:20'),
(61, 35, 'en', 'Landing Page Design', '2024-08-26 05:04:29', '2024-08-26 05:04:29'),
(62, 35, 'hd', 'Landing Page Design', '2024-08-26 05:04:29', '2024-08-26 05:04:29'),
(63, 36, 'en', 'Machine Learning', '2024-08-26 05:04:39', '2024-08-26 05:04:39'),
(64, 36, 'hd', 'Machine Learning', '2024-08-26 05:04:39', '2024-08-26 05:04:39'),
(65, 37, 'en', 'AI Chatbots', '2024-08-26 05:04:48', '2024-08-26 05:04:48'),
(66, 37, 'hd', 'AI Chatbots', '2024-08-26 05:04:48', '2024-08-26 05:04:48'),
(67, 38, 'en', 'Natural Language Processing', '2024-08-26 05:05:03', '2024-08-26 05:05:03'),
(68, 38, 'hd', 'Natural Language Processing', '2024-08-26 05:05:03', '2024-08-26 05:05:03'),
(69, 39, 'en', 'Predictive Analytics', '2024-08-26 05:05:14', '2024-08-26 05:05:14'),
(70, 39, 'hd', 'Predictive Analytics', '2024-08-26 05:05:14', '2024-08-26 05:05:14'),
(71, 40, 'en', 'Computer Vision', '2024-08-26 05:05:23', '2024-08-26 05:05:23'),
(72, 40, 'hd', 'Computer Vision', '2024-08-26 05:05:23', '2024-08-26 05:05:23'),
(73, 41, 'en', 'Portrait Photography', '2024-08-26 05:06:09', '2024-08-26 05:06:09'),
(74, 41, 'hd', 'Portrait Photography', '2024-08-26 05:06:09', '2024-08-26 05:06:09'),
(75, 42, 'en', 'Event Photography', '2024-08-26 05:06:20', '2024-08-26 05:06:20'),
(76, 42, 'hd', 'Event Photography', '2024-08-26 05:06:20', '2024-08-26 05:06:20'),
(77, 43, 'en', 'Product Photography', '2024-08-26 05:06:30', '2024-08-26 05:06:30'),
(78, 43, 'hd', 'Product Photography', '2024-08-26 05:06:30', '2024-08-26 05:06:30'),
(79, 44, 'en', 'Photo Editing', '2024-08-26 05:06:38', '2024-08-26 05:06:38'),
(80, 44, 'hd', 'Photo Editing', '2024-08-26 05:06:38', '2024-08-26 05:06:38'),
(81, 45, 'en', 'Stock Photography', '2024-08-26 05:06:49', '2024-08-26 05:06:49'),
(82, 45, 'hd', 'Stock Photography', '2024-08-26 05:06:49', '2024-08-26 05:06:49'),
(83, 46, 'en', '2D Animation', '2024-08-26 05:07:03', '2024-08-26 05:07:03'),
(84, 46, 'hd', '2D Animation', '2024-08-26 05:07:03', '2024-08-26 05:07:03'),
(85, 47, 'en', '3D Animation', '2024-08-26 05:07:13', '2024-08-26 05:07:13'),
(86, 47, 'hd', '3D Animation', '2024-08-26 05:07:13', '2024-08-26 05:07:13'),
(87, 48, 'en', 'Motion Graphics', '2024-08-26 05:07:24', '2024-08-26 05:07:24'),
(88, 48, 'hd', 'Motion Graphics', '2024-08-26 05:07:24', '2024-08-26 05:07:24'),
(89, 49, 'en', 'Whiteboard Animation', '2024-08-26 05:07:35', '2024-08-26 05:07:35'),
(90, 49, 'hd', 'Whiteboard Animation', '2024-08-26 05:07:35', '2024-08-26 05:07:35'),
(91, 50, 'en', 'Character Animation', '2024-08-26 05:07:46', '2024-08-26 05:07:46'),
(92, 50, 'hd', 'Character Animation', '2024-08-26 05:07:46', '2024-08-26 05:07:46');

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

--
-- Table structure for table `term_and_conditions`
--

CREATE TABLE `term_and_conditions` (
  `id` bigint UNSIGNED NOT NULL,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `term_and_conditions`
--

INSERT INTO `term_and_conditions` (`id`, `lang_code`, `description`, `created_at`, `updated_at`) VALUES
(1, 'en', '<h4>01.Introduction</h4>\r\n<p>A Privacy Policy is a legal document that informs users about the data collected, how it\'s used, and how it\'s protected. It typically includes information about the type of personal our ainformation collected (such as names, email addresses, etc.), the purpose of collection, and whether the information is shared with third parties. It outlines the rights of users regarding their data, such as the right to access, correct, or delete their information.</p>\r\n<h4>02. Workzone Terms of Service</h4>\r\n<p>Terms of Service (also known as Terms and Conditions or Terms of Use) set the rules and guidelines for using a particular service or platform. They establish the contractual relationship between the user and the service provider. They often include details about user behavior, content usage policies, disclaimers, limitations of liability, and procedures for dispute resolution.Users typically agree to these terms by using the service.When you visit a website or use an online service, you are usually asked to agree to both the Privacy Policy and the Terms of Service. These documents are crucial for transparency, legal compliance, and establishing the terms under which users can access and use the service.</p>\r\n<p>It\'s important for businesses and service providers to keep these documents up-to-date and easily accessible to users. If you have specific questions or concerns about privacy policies or terms of service, feel free to provide more details, and I\'ll do my best to assist you.</p>\r\n<h4>3. Protect Your Property</h4>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown as printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuriezcs but also the on leap into as eylectronic typesetting, remaining as essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of Letraszvxet sheets containing Lorem Ipsum our spassages, andei more recently with a desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book. five centuries but also a the on leap into electronic typesetting, remaining essentially unchanged. It aswasn&rsquo;t popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, andei more recently with desktop our aspublishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>\r\n<h4>4. What to Include in Terms and Conditions for Limitations of Liability</h4>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the as1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five as centuries but also the on leap into as electronic ki typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of as Leitraset sheets containing Loriem Ipsum passages, our andei more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>\r\n<p>ive centuries but also the on leap into electronic typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of Letraset as sheets containing Lorem Ipsum passages, andei more recently with desktop publishing software like Aldus PageMaker our as including versions of Loriem Ipsum to make a type our as specimen book. It wasn&rsquo;t popularised in the 1960s with the release of Letraset sheets as containing Lorem Ipsum passages, andei more recently with a desktop publishing software like Aldus PageMaker including versions of Loremas Ipsum to make a type specimen book.</p>\r\n<h4>05.Pricing and Payment Policy</h4>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the as 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five as centuries but also as the on leap into electronic as typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release as of Letraset sheets containing Lorem Ipsum our spassages, andei more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>\r\n<p>five centuries but also the on leap into electronic typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, andei more recently with desktop publishing software like Aldus PageMaker our as including versions of Lorem aIpsum to make a type specimen our as book. It wasn&rsquo;t popularised in the 1960s with the release of Letraset sheetsasd containing Lorem Ipsum passages, andei more recentlysl with desktop publishing software like Aldus PageMaker including versions of Loremadfsfds Ipsum to make a type specimen book.</p>\r\n<p>It has survived not only five centuries but also the on leap into electronic typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the our 1960s with the release of Letraset sheets containing Lorem Ipsum passages, andei more recently with desktop publishing asou software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>', NULL, '2024-07-12 08:57:41'),
(19, 'hd', '<h4>01.Introduction</h4>\r\n<p>A Privacy Policy is a legal document that informs users about the data collected, how it\'s used, and how it\'s protected. It typically includes information about the type of personal our ainformation collected (such as names, email addresses, etc.), the purpose of collection, and whether the information is shared with third parties. It outlines the rights of users regarding their data, such as the right to access, correct, or delete their information.</p>\r\n<h4>02.Freelance Terms of Service (Privacy and Policy)</h4>\r\n<p>Terms of Service (also known as Terms and Conditions or Terms of Use) set the rules and guidelines for using a particular service or platform. They establish the contractual relationship between the user and the service provider. They often include details about user behavior, content usage policies, disclaimers, limitations of liability, and procedures for dispute resolution.Users typically agree to these terms by using the service.When you visit a website or use an online service, you are usually asked to agree to both the Privacy Policy and the Terms of Service. These documents are crucial for transparency, legal compliance, and establishing the terms under which users can access and use the service.</p>\r\n<p>It\'s important for businesses and service providers to keep these documents up-to-date and easily accessible to users. If you have specific questions or concerns about privacy policies or terms of service, feel free to provide more details, and I\'ll do my best to assist you.</p>\r\n<h4>3. Protect Your Property</h4>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown as printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuriezcs but also the on leap into as eylectronic typesetting, remaining as essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of Letraszvxet sheets containing Lorem Ipsum our spassages, andei more recently with a desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book. five centuries but also a the on leap into electronic typesetting, remaining essentially unchanged. It aswasn&rsquo;t popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, andei more recently with desktop our aspublishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>\r\n<h4>4. What to Include in Terms and Conditions for Limitations of Liability</h4>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the as1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five as centuries but also the on leap into as electronic ki typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of as Leitraset sheets containing Loriem Ipsum passages, our andei more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>\r\n<p>ive centuries but also the on leap into electronic typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of Letraset as sheets containing Lorem Ipsum passages, andei more recently with desktop publishing software like Aldus PageMaker our as including versions of Loriem Ipsum to make a type our as specimen book. It wasn&rsquo;t popularised in the 1960s with the release of Letraset sheets as containing Lorem Ipsum passages, andei more recently with a desktop publishing software like Aldus PageMaker including versions of Loremas Ipsum to make a type specimen book.</p>\r\n<h4>05.Pricing and Payment Policy</h4>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the as 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five as centuries but also as the on leap into electronic as typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release as of Letraset sheets containing Lorem Ipsum our spassages, andei more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>\r\n<p>five centuries but also the on leap into electronic typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, andei more recently with desktop publishing software like Aldus PageMaker our as including versions of Lorem aIpsum to make a type specimen our as book. It wasn&rsquo;t popularised in the 1960s with the release of Letraset sheetsasd containing Lorem Ipsum passages, andei more recentlysl with desktop publishing software like Aldus PageMaker including versions of Loremadfsfds Ipsum to make a type specimen book.</p>\r\n<p>It has survived not only five centuries but also the on leap into electronic typesetting, remaining essentially unchanged. It wasn&rsquo;t popularised in the our 1960s with the release of Letraset sheets containing Lorem Ipsum passages, andei more recently with desktop publishing asou software like Aldus PageMaker including versions of Lorem Ipsum to make a type specimen book.</p>', '2024-07-10 05:34:58', '2024-07-10 05:34:58');

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint UNSIGNED NOT NULL,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `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 `testimonials`
--

INSERT INTO `testimonials` (`id`, `logo`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, NULL, 'uploads/custom-images/abdur-rohman-20240710125422.png', 'active', '2024-07-10 06:54:22', '2024-07-10 06:54:22'),
(2, NULL, 'uploads/custom-images/niloy-mazumdar-20240710125510.png', 'active', '2024-07-10 06:55:10', '2024-07-10 06:55:10'),
(3, NULL, 'uploads/custom-images/nasrun-nessa-20240710125554.png', 'active', '2024-07-10 06:55:54', '2024-07-10 06:55:54'),
(4, NULL, 'uploads/custom-images/rafiqul-shuvo-20240710125626.png', 'active', '2024-07-10 06:56:26', '2024-07-10 06:56:26'),
(5, NULL, 'uploads/custom-images/ibrahim-khalil-20240710125702.png', 'active', '2024-07-10 06:57:02', '2024-07-10 06:57:02'),
(6, NULL, 'uploads/custom-images/file-name-17508452595426.png', 'active', '2024-07-10 06:58:22', '2025-06-25 09:54:19');

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

--
-- Table structure for table `testimonial_trasnlations`
--

CREATE TABLE `testimonial_trasnlations` (
  `id` bigint UNSIGNED NOT NULL,
  `testimonial_id` int NOT NULL,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `designation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `testimonial_trasnlations`
--

INSERT INTO `testimonial_trasnlations` (`id`, `testimonial_id`, `lang_code`, `name`, `designation`, `comment`, `created_at`, `updated_at`) VALUES
(1, 1, 'en', 'Abdur Rohman', 'CEO', 'Working with Shohelon our app project expectations was an absolute pleasure. Their attention to detail, creativity, and technical expertise shone through in every aspect of the app development process. The final product exceeded our expectations and has been well-received by our expectations users. Highly recommend!  Their attention to detail', '2024-07-10 06:54:22', '2024-07-15 08:21:48'),
(2, 1, 'hd', 'Abdur Rohman', 'CEO', 'Working with [Your Name] on our app project was an absolute pleasure. Their attention to detail, creativity, and technical expertise shone through in every aspect of the app development process. The final product exceeded our expectations and has been well-received by our users. Highly recommend!', '2024-07-10 06:54:22', '2024-07-10 06:54:22'),
(3, 2, 'en', 'Niloy Mazumdar', 'Founder', 'I am thrilled with the professionalism iOS app developed by [Your Name]. Their professionalism, dedication, and ability to bring our professionalism vision to life were exceptional. The app\'s user-friendly interface and seamless developer functionality are a testament to their expertise. professionalismA truly talented developer & results.', '2024-07-10 06:55:10', '2024-07-15 08:24:04'),
(4, 2, 'hd', 'Niloy Mazumdar', 'Founder', 'I am thrilled with the iOS app developed by [Your Name]. Their professionalism, dedication, and ability to bring our vision to life were exceptional. The app\'s user-friendly interface and seamless functionality are a testament to their expertise. A truly talented developer who delivers outstanding results.', '2024-07-10 06:55:10', '2024-07-10 06:55:10'),
(5, 3, 'en', 'Nasrun Nessa', 'Chairman', 'Choosing Shohel for our app development needs was one of the best decisions we made. Their knowledge of Swift programming and UI/UX design transformed our ideas into a polished, high-quality app. The collaborative approach, clear decisions communication, and commitment to excellence decisions made the entire process smooth and successful.', '2024-07-10 06:55:54', '2024-07-10 07:01:46'),
(6, 3, 'hd', 'Nasrun Nessa', 'Chairman', 'Choosing Shohel for our app development needs was one of the best decisions we made. Their knowledge of Swift programming and UI/UX design transformed our ideas into a polished, high-quality app. The collaborative approach, clear communication, and commitment to excellence made the entire process smooth and successful.', '2024-07-10 06:55:54', '2024-07-10 06:55:54'),
(7, 4, 'en', 'Rafiqul Shuvo', 'CTO', 'Shohel is a standout iOS App Developer who goes above and beyond to deliver exceptional results. Their attention to detail, problem-solving skills, and ability to adapt to changes made the development process seamless. The app they created for us not only met but exceeded ours. Highly recommended for anyone app development services.', '2024-07-10 06:56:26', '2024-07-15 08:23:33'),
(8, 4, 'hd', 'Rafiqul Shuvo', 'CTO', 'Shohel is a standout iOS App Developer who goes above and beyond to deliver exceptional results. Their attention to detail, problem-solving skills, and ability to adapt to changes made the development process seamless. The app they created for us not only met but exceeded our expectations. Highly recommended for anyone seeking top-notch app development services.', '2024-07-10 06:56:26', '2024-07-10 06:56:26'),
(9, 5, 'en', 'Ibrahim Khalil', 'COO', 'I cannot speak highly enough of the professionalism and expertise demonstrated by Shohel throughout our app development journey. Their commitment to quality, responsiveness to feedback, and dedication to delivering a top-tier app were truly . collaborative professionalism. Thank you for your outstanding work!', '2024-07-10 06:57:02', '2024-07-15 08:22:52'),
(10, 5, 'hd', 'Ibrahim Khalil', 'COO', 'I cannot speak highly enough of the professionalism and expertise demonstrated by Shohel throughout our app development journey. Their commitment to quality, responsiveness to feedback, and dedication to delivering a top-tier app were truly commendable. Working with them was a collaborative and rewarding experience that resulted in a successful app launch. Thank you for your outstanding work!', '2024-07-10 06:57:02', '2024-07-10 06:57:02'),
(11, 6, 'en', 'Sheikh Hasin', 'PM', 'I cannot speak highly enough of the professionalism and expertise demonstrated by Shohel throughout our app development journey. Their commitment to quality, responsiveness to feedback, and dedication to delivering a top-tier app were truly commendable. Working with them was a collaborative and rewarding experience', '2024-07-10 06:58:22', '2024-07-15 08:24:21'),
(12, 6, 'hd', 'Sheikh Hasin', 'PM', 'I cannot speak highly enough of the professionalism and expertise demonstrated by Shohel throughout our app development journey. Their commitment to quality, responsiveness to feedback, and dedication to delivering a top-tier app were truly commendable. Working with them was a collaborative and rewarding experience that resulted in a successful app launch. Thank you for your outstanding work!\"', '2024-07-10 06:58:22', '2024-07-10 06:58:22');

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

--
-- Table structure for table `wallets`
--

CREATE TABLE `wallets` (
  `id` bigint UNSIGNED NOT NULL,
  `buyer_id` int NOT NULL,
  `balance` decimal(8,2) DEFAULT '0.00',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `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 `wallets`
--

INSERT INTO `wallets` (`id`, `buyer_id`, `balance`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 184.00, 'active', '2024-07-26 07:10:15', '2025-07-30 11:28:55'),
(2, 3, 0.00, 'active', '2024-07-30 02:40:53', '2024-07-30 02:40:53'),
(3, 10, 46.00, 'active', '2025-08-16 11:31:10', '2025-08-16 13:16:08');

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

--
-- Table structure for table `wallet_transactions`
--

CREATE TABLE `wallet_transactions` (
  `id` bigint UNSIGNED NOT NULL,
  `buyer_id` int NOT NULL,
  `amount` decimal(8,2) DEFAULT '0.00',
  `payment_gateway` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `payment_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'credit',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'success',
  `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 `wallet_transactions`
--

INSERT INTO `wallet_transactions` (`id`, `buyer_id`, `amount`, `payment_gateway`, `transaction_id`, `payment_status`, `payment_type`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 20.00, 'Stripe', 'txn_3PgiKnF56Pb8BOOX1Z3Cx1F7', 'success', 'credit', NULL, 'success', '2024-07-26 07:13:04', '2024-07-26 07:13:04'),
(2, 1, 25.00, 'Paypal', 'ZUJKUEUDELUGE', 'success', 'credit', NULL, 'success', '2024-07-26 07:13:35', '2024-07-26 07:13:35'),
(3, 1, 60.00, 'Mollie', 'tr_uFXZkrJmaB', 'success', 'credit', NULL, 'success', '2024-07-26 08:46:07', '2024-07-26 08:46:07'),
(4, 1, 20.00, 'Stripe', 'txn_3PgjnHF56Pb8BOOX0UIM554V', 'success', 'credit', NULL, 'success', '2024-07-26 08:46:34', '2024-07-26 08:46:34'),
(5, 1, 20.00, 'Paypal', 'ZUJKUEUDELUGE', 'success', 'credit', NULL, 'success', '2024-07-26 08:48:21', '2024-07-26 08:48:21'),
(6, 1, 20.00, 'Razorpay', 'pay_OdCV21UF8xttCi', 'success', 'credit', NULL, 'success', '2024-07-26 08:49:37', '2024-07-26 08:49:37'),
(7, 1, 99.00, 'Refund amount', 'from_refund', 'success', 'credit', NULL, 'success', '2024-07-30 02:16:36', '2024-07-30 02:16:36'),
(8, 1, 100.00, 'Stripe', 'txn_3RqSaLF56Pb8BOOX1tEeAdGp', 'success', 'credit', NULL, 'success', '2025-07-30 05:30:32', '2025-07-30 05:30:32'),
(9, 1, 120.00, 'Refund amount', 'from_refund', 'success', 'credit', NULL, 'success', '2025-07-30 09:20:23', '2025-07-30 09:20:23'),
(10, 1, 20.00, 'Refund amount', 'from_refund', 'success', 'credit', NULL, 'success', '2025-07-30 11:14:35', '2025-07-30 11:14:35'),
(11, 10, 26.00, 'Refund amount', 'from_refund', 'success', 'credit', NULL, 'success', '2025-08-16 12:03:50', '2025-08-16 12:03:50'),
(12, 10, 20.00, 'Refund amount', 'from_refund', 'success', 'credit', NULL, 'success', '2025-08-16 12:48:35', '2025-08-16 12:48:35'),
(13, 10, 50.00, 'Paypal', 'ZUJKUEUDELUGE', 'success', 'credit', NULL, 'success', '2025-08-16 13:15:57', '2025-08-16 13:15:57');

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

--
-- Table structure for table `wishlists`
--

CREATE TABLE `wishlists` (
  `id` bigint UNSIGNED NOT NULL,
  `item_id` int NOT NULL,
  `user_id` int 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 `wishlists`
--

INSERT INTO `wishlists` (`id`, `item_id`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2024-07-15 09:27:46', '2024-07-15 09:27:46'),
(2, 3, 1, '2024-07-15 09:27:48', '2024-07-15 09:27:48'),
(3, 5, 1, '2024-07-15 09:27:49', '2024-07-15 09:27:49'),
(4, 6, 1, '2024-07-15 09:27:51', '2024-07-15 09:27:51');

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

--
-- Table structure for table `withdraw_methods`
--

CREATE TABLE `withdraw_methods` (
  `id` bigint UNSIGNED NOT NULL,
  `method_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `min_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `max_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `withdraw_charge` decimal(8,2) NOT NULL DEFAULT '0.00',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'disable',
  `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 `withdraw_methods`
--

INSERT INTO `withdraw_methods` (`id`, `method_name`, `min_amount`, `max_amount`, `withdraw_charge`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Bank Payment', 1.00, 10.00, 0.50, '<p>Bank Name: Your bank name<br>Account Number: &nbsp;Your bank account number<br>Routing Number: Your bank routing number<br>Branch: Your bank branch name</p>', 'enable', '2024-07-15 09:23:29', '2024-07-15 09:23:29');

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

--
-- Table structure for table `xg_ftp_infos`
--

CREATE TABLE `xg_ftp_infos` (
  `id` bigint UNSIGNED NOT NULL,
  `item_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `item_license_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `item_license_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `item_license_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `admin_permission_lists`
--
ALTER TABLE `admin_permission_lists`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admin_permission_lists_name_unique` (`name`),
  ADD KEY `admin_permission_lists_parent_id_foreign` (`parent_id`);

--
-- Indexes for table `admin_roles`
--
ALTER TABLE `admin_roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admin_roles_name_unique` (`name`);

--
-- Indexes for table `admin_role_assignments`
--
ALTER TABLE `admin_role_assignments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admin_role_assignments_admin_id_admin_role_id_unique` (`admin_id`,`admin_role_id`),
  ADD KEY `admin_role_assignments_admin_role_id_foreign` (`admin_role_id`),
  ADD KEY `admin_role_assignments_assigned_by_foreign` (`assigned_by`);

--
-- Indexes for table `admin_role_permissions`
--
ALTER TABLE `admin_role_permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admin_role_permissions_admin_role_id_admin_permission_id_unique` (`admin_role_id`,`admin_permission_id`),
  ADD KEY `admin_role_permissions_admin_permission_id_foreign` (`admin_permission_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
  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 `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  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 `payment_gateways`
--
ALTER TABLE `payment_gateways`
  ADD PRIMARY KEY (`id`);

--
-- 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 `privacy_policies`
--
ALTER TABLE `privacy_policies`
  ADD PRIMARY KEY (`id`);

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

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

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

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

--
-- Indexes for table `seller_level_histories`
--
ALTER TABLE `seller_level_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `seller_level_histories_seller_id_foreign` (`seller_id`),
  ADD KEY `seller_level_histories_seller_level_id_foreign` (`seller_level_id`);

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

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

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

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

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

--
-- Indexes for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sub_categories_slug_unique` (`slug`);

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `about_us`
--
ALTER TABLE `about_us`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `about_us_translations`
--
ALTER TABLE `about_us_translations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `admin_permission_lists`
--
ALTER TABLE `admin_permission_lists`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=263;

--
-- AUTO_INCREMENT for table `admin_roles`
--
ALTER TABLE `admin_roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

--
-- AUTO_INCREMENT for table `admin_role_permissions`
--
ALTER TABLE `admin_role_permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1008;

--
-- AUTO_INCREMENT for table `block_users`
--
ALTER TABLE `block_users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

--
-- AUTO_INCREMENT for table `blog_category_translations`
--
ALTER TABLE `blog_category_translations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

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

--
-- AUTO_INCREMENT for table `blog_translations`
--
ALTER TABLE `blog_translations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

--
-- AUTO_INCREMENT for table `category_translations`
--
ALTER TABLE `category_translations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

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

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

--
-- AUTO_INCREMENT for table `contact_messages`
--
ALTER TABLE `contact_messages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `contact_us`
--
ALTER TABLE `contact_us`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `contact_us_translations`
--
ALTER TABLE `contact_us_translations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `currencies`
--
ALTER TABLE `currencies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `custom_pages`
--
ALTER TABLE `custom_pages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

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

--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

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

--
-- AUTO_INCREMENT for table `faq_translations`
--
ALTER TABLE `faq_translations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `footers`
--
ALTER TABLE `footers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `footer_translations`
--
ALTER TABLE `footer_translations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `global_settings`
--
ALTER TABLE `global_settings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;

--
-- AUTO_INCREMENT for table `homepages`
--
ALTER TABLE `homepages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `homepage_translations`
--
ALTER TABLE `homepage_translations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `job_posts`
--
ALTER TABLE `job_posts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `job_post_messages`
--
ALTER TABLE `job_post_messages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=108;

--
-- AUTO_INCREMENT for table `job_post_messages_documents`
--
ALTER TABLE `job_post_messages_documents`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `job_post_translations`
--
ALTER TABLE `job_post_translations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- AUTO_INCREMENT for table `job_requests`
--
ALTER TABLE `job_requests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `job_request_files`
--
ALTER TABLE `job_request_files`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `kyc_information`
--
ALTER TABLE `kyc_information`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `kyc_types`
--
ALTER TABLE `kyc_types`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `listings`
--
ALTER TABLE `listings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `listing_galleries`
--
ALTER TABLE `listing_galleries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `listing_packages`
--
ALTER TABLE `listing_packages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `listing_translations`
--
ALTER TABLE `listing_translations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107;

--
-- AUTO_INCREMENT for table `messages_documents`
--
ALTER TABLE `messages_documents`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

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

--
-- AUTO_INCREMENT for table `newsletters`
--
ALTER TABLE `newsletters`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `payment_gateways`
--
ALTER TABLE `payment_gateways`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

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

--
-- AUTO_INCREMENT for table `privacy_policies`
--
ALTER TABLE `privacy_policies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `refund_requests`
--
ALTER TABLE `refund_requests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `restricted_keywords`
--
ALTER TABLE `restricted_keywords`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

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

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

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

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

--
-- AUTO_INCREMENT for table `seo_settings`
--
ALTER TABLE `seo_settings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `subscription_histories`
--
ALTER TABLE `subscription_histories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

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

--
-- AUTO_INCREMENT for table `sub_categories`
--
ALTER TABLE `sub_categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT for table `sub_category_translates`
--
ALTER TABLE `sub_category_translates`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=95;

--
-- AUTO_INCREMENT for table `term_and_conditions`
--
ALTER TABLE `term_and_conditions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `testimonial_trasnlations`
--
ALTER TABLE `testimonial_trasnlations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

--
-- AUTO_INCREMENT for table `wallet_transactions`
--
ALTER TABLE `wallet_transactions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

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

--
-- AUTO_INCREMENT for table `withdraw_methods`
--
ALTER TABLE `withdraw_methods`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `xg_ftp_infos`
--
ALTER TABLE `xg_ftp_infos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `admin_permission_lists`
--
ALTER TABLE `admin_permission_lists`
  ADD CONSTRAINT `admin_permission_lists_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `admin_permission_lists` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `admin_role_assignments`
--
ALTER TABLE `admin_role_assignments`
  ADD CONSTRAINT `admin_role_assignments_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `admin_role_assignments_admin_role_id_foreign` FOREIGN KEY (`admin_role_id`) REFERENCES `admin_roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `admin_role_assignments_assigned_by_foreign` FOREIGN KEY (`assigned_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `admin_role_permissions`
--
ALTER TABLE `admin_role_permissions`
  ADD CONSTRAINT `admin_role_permissions_admin_permission_id_foreign` FOREIGN KEY (`admin_permission_id`) REFERENCES `admin_permission_lists` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `admin_role_permissions_admin_role_id_foreign` FOREIGN KEY (`admin_role_id`) REFERENCES `admin_roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `seller_level_histories`
--
ALTER TABLE `seller_level_histories`
  ADD CONSTRAINT `seller_level_histories_seller_id_foreign` FOREIGN KEY (`seller_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `seller_level_histories_seller_level_id_foreign` FOREIGN KEY (`seller_level_id`) REFERENCES `seller_levels` (`id`);
COMMIT;

