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

START TRANSACTION;



--
-- Database: `rahulpuridemo_Technology`
--

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

--
-- Table structure for table `abouts`
--

CREATE TABLE `abouts` (
  `id` int UNSIGNED NOT NULL,
  `description1` text COLLATE utf8mb4_general_ci,
  `description` text COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `vision` text COLLATE utf8mb4_general_ci,
  `mission` text COLLATE utf8mb4_general_ci,
  `value` text COLLATE utf8mb4_general_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `abouts`
--

INSERT INTO `abouts` (`id`, `description1`, `description`, `image`, `vision`, `mission`, `value`, `created_at`, `updated_at`) VALUES
(1, '<p>Established with a vision to bridge the gap between technology and business, our mission is to help clients harness the power of digital tools to enhance their operations, build their brand, and grow sustainably. Our team of skilled professionals brings creativity, experience, and technical expertise to every project, ensuring high-quality results and long-term success.</p><p>Whether you\'re a startup looking to establish your digital presence or an enterprise aiming to scale, Prabhu Digital Services is your trusted partner in digital transformation.</p>', '<p><strong>Prabhu Digital Services Private Limited</strong> is a forward-thinking technology company committed to delivering innovative digital solutions that empower businesses and individuals in the digital age. With a focus on excellence, reliability, and customer satisfaction, we offer a wide range of services including web development, digital marketing, software solutions, and IT consulting.</p><p>Founded with the mission to simplify technology and make it accessible to everyone, we work closely with clients to understand their needs and craft tailored digital strategies that deliver measurable results. From building responsive websites and optimizing SEO performance to creating custom software and managing social media campaigns, our team ensures every solution drives value.</p>', '1749297655.png', 'vision', 'mission', 'value', '2025-05-21 01:16:12', '2025-06-07 06:34:10');

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `description` text COLLATE utf8mb4_general_ci NOT NULL,
  `date` date NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `title`, `description`, `date`, `image`, `created_at`, `updated_at`) VALUES
(1, 'mmmm', 'pppppllll', '2025-05-21', '1747811673.jpg', '2025-05-21 01:43:57', '2025-05-21 01:44:33'),
(2, 'ccccc', '<p>xxxx</p>', '2025-05-21', '1747827218.png', '2025-05-21 06:03:38', '2025-05-21 06:03:38');

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` int NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `image`, `created_at`, `updated_at`) VALUES
(2, '1749300021.png', '2025-05-29 05:37:05', '2025-06-07 07:10:21'),
(3, '1749300037.png', '2025-05-29 05:37:30', '2025-06-07 07:10:37'),
(4, '1749300055.png', '2025-06-07 07:10:55', '2025-06-07 07:10:55'),
(5, '1749300071.png', '2025-06-07 07:11:11', '2025-06-07 07:11:11'),
(6, '1749300088.png', '2025-06-07 07:11:28', '2025-06-07 07:11:28');

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int UNSIGNED NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone1` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lname` text COLLATE utf8mb4_general_ci,
  `image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `address`, `email`, `phone`, `phone1`, `lname`, `image`, `created_at`, `updated_at`) VALUES
(2, 'Delhi', 'info@gmail.com', '01234567890', NULL, NULL, '1749299862.png', '2025-05-21 07:01:24', '2025-06-07 07:07:42');

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

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

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

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

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `description` text COLLATE utf8mb4_general_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`id`, `title`, `description`, `created_at`, `updated_at`) VALUES
(2, 'mmm', 'ppp', '2025-05-21 03:03:35', '2025-05-21 03:03:35'),
(3, 'ppp', 'nnnnn', '2025-05-21 03:03:51', '2025-05-21 03:03:51');

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

--
-- Table structure for table `industries`
--

CREATE TABLE `industries` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `description` text COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `industries`
--

INSERT INTO `industries` (`id`, `title`, `description`, `image`, `slug`, `created_at`, `updated_at`) VALUES
(1, 'Cloud Enablement Services', '<p>Lay the foundation for cost effective, scalable and interoperable multi-party video collaboration. You can experience crisp, smooth video quality with resolutions up to 1080p/60fps, stellar bandwidth efficiency, and error</p>', '1748511381.png', 'cloud-enablement-services', '2025-05-29 04:06:21', '2025-06-09 04:36:12'),
(2, 'Employee Productivity Tracker', '<p>Transform how you Communicate, Collaborate and Serve your customers. Voice, Video and other communications services can be connected directly to business workflows, filtering and delivering the right information</p>', '1748511553.png', 'employee-productivity-tracker', '2025-05-29 04:09:13', '2025-06-09 04:37:39'),
(3, 'Facility Management Services', '<p>Lay the foundation for cost effective, scalable and interoperable multi-party video collaboration. You can experience crisp, smooth video quality with resolutions up to 1080p/60fps, stellar bandwidth efficiency, and error</p>', '1749463726.jpg', 'facility-management-services', '2025-06-09 04:38:46', '2025-06-09 04:38:46'),
(4, 'B2B Wealth Management Platform', '<p>Transform how you Communicate, Collaborate and Serve your customers. Voice, Video and other communications services can be connected directly to business workflows, filtering and delivering the right information</p>', '1749463830.jpg', 'B2B-wealth-management-platform', '2025-06-09 04:40:30', '2025-06-09 04:40:30');

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) 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);

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `slug` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_general_ci,
  `image` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `title`, `slug`, `description`, `image`, `created_at`, `updated_at`) VALUES
(3, 'IT Network Solution', 'network-solution', '<p>IT Network Solution</p>', '1748496838.png', '2025-05-29 00:03:58', '2025-06-09 04:24:01'),
(4, 'Data Center Solutions', 'data-center-solutions', '<p>Data Center Solutions</p>', '1748501330.png', '2025-05-29 01:18:50', '2025-06-09 04:24:59'),
(5, 'Audio-Video Solution', 'audio-video-solution', '<p>Audio-Video Solution</p>', '1748501376.png', '2025-05-29 01:19:36', '2025-06-09 04:25:57'),
(6, 'Business Continuity Solution', 'business-continuity-solution', '<p>Business Continuity Solution</p>', '1749463011.png', '2025-06-09 04:26:51', '2025-06-09 04:26:51'),
(7, 'ELVS Solution', 'elvs-solution', '<p>ELVS Solution</p>', '1749463054.png', '2025-06-09 04:27:34', '2025-06-09 04:27:34'),
(8, 'IT Security Solution', 'it-security-solution', '<p>IT Security Solution</p>', '1749463102.png', '2025-06-09 04:28:22', '2025-06-09 04:28:22');

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

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

CREATE TABLE `sliders` (
  `id` int NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `description` text COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `title`, `description`, `image`, `created_at`, `updated_at`) VALUES
(2, 'Get the power to do Big Business', 'pppppp', '1749294980.jpg', '2025-05-21 00:48:58', '2025-06-07 05:46:20');

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

--
-- Table structure for table `sub_products`
--

CREATE TABLE `sub_products` (
  `id` int UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `description` text COLLATE utf8mb4_general_ci,
  `pack` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mrp` decimal(10,2) DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `product_id` int UNSIGNED NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sub_products`
--

INSERT INTO `sub_products` (`id`, `title`, `description`, `pack`, `mrp`, `slug`, `product_id`, `image`, `created_at`, `updated_at`) VALUES
(3, 'Labour Law', '<p>hhhhhhhhhhh</p>', NULL, NULL, 'labour-law', 3, '1748502109.png', '2025-05-29 01:31:49', '2025-05-29 02:56:09'),
(4, 'HR Compilances', NULL, NULL, NULL, 'compilance', 4, '1748502180.png', '2025-05-29 01:33:00', '2025-05-29 01:33:00'),
(5, 'Company Law', NULL, NULL, NULL, 'company-law', 3, '1748502927.png', '2025-05-29 01:45:27', '2025-05-29 01:45:27');

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

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

CREATE TABLE `testimonials` (
  `id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `department` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_general_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `name`, `department`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Technology', 'hjkl', 'hjop', '2025-05-29 05:11:26', '2025-05-29 05:11:41'),
(2, 'rtyujb', 'hj', 'nm', '2025-05-29 05:12:08', '2025-05-29 05:12:08');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

--
-- Indexes for table `sub_products`
--
ALTER TABLE `sub_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

--
-- 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` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `sub_products`
--
ALTER TABLE `sub_products`
  ADD CONSTRAINT `sub_products_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;
COMMIT;

