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

START TRANSACTION;



--
-- Database: `rahulpuridemo_smartpro`
--

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

--
-- 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>kkkk</p>', '<p>pppllllllllll</p>', '1747810088.png', 'vision', 'mission', 'value', '2025-05-21 01:16:12', '2025-05-29 06:00:08');

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

--
-- 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
(3, 'Why Real Estate Is the Best Investment in India – Especially in Delhi NCR?', '<p>In a dynamic and rapidly growing economy like India, real estate stands tall as one of the most reliable and rewarding forms of investment. Nowhere is this more evident than in <strong>Delhi-NCR</strong>, a region that continues to thrive as an economic and infrastructure powerhouse.</p><p><strong>🔑 1. Tangible &amp; Secure Asset</strong></p><p>Unlike stocks or mutual funds, real estate is a <strong>physical asset</strong>. It offers <strong>security, control, and long-term stability</strong>—perfect for conservative and growth-focused investors alike.</p><p>&nbsp;</p><p><strong>📈 2. Consistent Appreciation in Delhi-NCR</strong></p><p>Property prices in areas like <strong>Gurgaon, Noida, Ghazaiabad, Dwarka Expressway, and Greater Noida</strong> have shown steady appreciation, thanks to:</p><p>Rapid infrastructure upgrades</p><p>Metro connectivity expansion</p><p>Proximity to business hubs and airports</p><p>&nbsp;</p><p><strong>🏙 3. High Rental Yield Potential</strong></p><p>With a large population of <strong>working professionals, students, and corporate tenants</strong>, Delhi-NCR offers:</p><p>2–6% annual rental yield</p><p>Even higher returns in commercial leasing (co-working spaces, retail, etc.)</p><p>&nbsp;</p><p><strong>🚧 4. Government-Driven Growth</strong></p><p>Massive policy pushes are making real estate investment safer and more lucrative:</p><p><strong>RERA Act</strong> ensures transparency and accountability</p><p><strong>Smart Cities Mission</strong>, <strong>PMAY</strong>, and <strong>infrastructure corridor projects</strong> like Delhi-Mumbai Expressway fuel growth</p><p>&nbsp;</p><p><strong>🧾 5. Tax Benefits &amp; Leverage</strong></p><p>Home loans come with <strong>tax deductions on interest and principal</strong> under Sections 24 and 80C</p><p>Real estate allows <strong>leveraged investing</strong> (using EMIs), multiplying ROI over time</p><p>&nbsp;</p><p><strong>🌆 6. Diversification Against Market Volatility</strong></p><p>In volatile markets, real estate offers a <strong>hedge against inflation</strong> and stock market risks. It’s a <strong>low-correlation asset</strong> that balances any investment portfolio.</p><p>&nbsp;</p><p><strong>🧭 7. Emotional Value + Passive Income</strong></p><p>Owning a property brings not just wealth, but peace of mind. Whether it\'s a <strong>second home, a rental flat, or a commercial space</strong>, it offers a dual benefit of <strong>capital gain + passive income</strong>.</p><p>&nbsp;</p><p><strong>📍 Why Delhi-NCR Specifically?</strong></p><p><strong>Hub of Fortune 500 companies</strong></p><p><strong>Upcoming airport in Jewar</strong>, Delhi-Mumbai Industrial Corridor</p><p>Huge migration inflow = rising housing demand</p><p>New sectors in <strong>Gurgaon (Sector 85–115)</strong> , <strong>Ghaziabad (Bapudham, Wave, Raj Nagar Ext.)</strong> and <strong>Noida (Sector 150, 143)</strong> are booming</p>', '2025-07-15', '1752572494.png', '2025-07-15 09:41:34', '2025-07-23 10:56:42');

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

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

CREATE TABLE `clients` (
  `id` int NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `link` 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 `clients`
--

INSERT INTO `clients` (`id`, `image`, `link`, `created_at`, `updated_at`) VALUES
(4, '1752993627.jpg', 'https://rahulpuri.in/dynamic/smartproperty/public/JadeCounty', '2025-07-18 13:22:25', '2025-07-23 12:16:47');

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

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

CREATE TABLE `contacts` (
  `id` int UNSIGNED NOT NULL,
  `address` text COLLATE utf8mb4_general_ci,
  `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,
  `address1` text COLLATE utf8mb4_general_ci,
  `address2` text COLLATE utf8mb4_general_ci,
  `address3` text COLLATE utf8mb4_general_ci,
  `link1` text COLLATE utf8mb4_general_ci,
  `link2` text COLLATE utf8mb4_general_ci,
  `link3` text COLLATE utf8mb4_general_ci,
  `facebook` text COLLATE utf8mb4_general_ci,
  `instagram` text COLLATE utf8mb4_general_ci,
  `twitter` text COLLATE utf8mb4_general_ci,
  `linkdin` 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 `contacts`
--

INSERT INTO `contacts` (`id`, `address`, `email`, `phone`, `phone1`, `lname`, `image`, `address1`, `address2`, `address3`, `link1`, `link2`, `link3`, `facebook`, `instagram`, `twitter`, `linkdin`, `created_at`, `updated_at`) VALUES
(2, 'Ghaziabad', 'smartpropgzb@gmail.com', '9210642053', NULL, NULL, '1750424135.png', 'Sector 2, Wave City', 'xyz2', 'xyz3', 'https://g.co/kgs/H7fqxRA', 'kkk', 'mmm', 'kkk', 'https://www.instagram.com/smartpropgzb/', 'hh', 'hh', '2025-05-21 07:01:24', '2025-07-15 09:36:38');

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

--
-- 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,
  `type` varchar(400) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description1` text COLLATE utf8mb4_general_ci,
  `description2` text COLLATE utf8mb4_general_ci,
  `description3` text COLLATE utf8mb4_general_ci,
  `description4` 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 `industries`
--

INSERT INTO `industries` (`id`, `title`, `description`, `image`, `slug`, `type`, `description1`, `description2`, `description3`, `description4`, `created_at`, `updated_at`) VALUES
(4, 'Jade County', '<p>&nbsp;</p><p>&nbsp;</p><ul><li><strong>3 BHK Apartment</strong> – 2358 Sq. Ft. – ₹2.59 Cr</li><li><strong>4 BHK Apartment</strong> – 2898 Sq. Ft. – ₹3.19 Cr</li><li><strong>4 BHK Apartment</strong> – 3555 Sq. Ft. – ₹3.91 Cr</li><li><strong>5 BHK Apartment</strong> – 5094 Sq. Ft. – ₹5.60 Cr</li></ul>', '1752573034.jpg', 'JadeCounty', 'new', '<ol><li>Master Bedroom: Oil Bound Distemper walls, Laminated Wooden flooring, VRV AC fittings</li><li>Other Bedrooms: Oil Bound Distemper walls, Laminated Wooden flooring</li><li>Living Area: Italian/Imported Marble flooring, False ceiling</li><li>Kitchen: Equipped with Hob and Chimney</li><li>Bathroom: Geyser, Premium Bath Fittings, Exhaust Fan</li><li>Structure: RCC Frame Structure</li></ol>', '<ul><li><strong>Location &amp; Project Scale</strong></li></ul><ol><li>Set along the Delhi–Meerut Expressway/NH‑24 within the integrated township of Wave City, Ghaziabad&nbsp;</li><li>Spread over approximately <strong>13.3 acres</strong>, featuring <strong>9 high-rise towers</strong> (27–31 floors) with about <strong>1,000–1,014 premium residences</strong> .</li></ol>', '<ul><li><strong>Connectivity &amp; Surroundings</strong></li></ul><ol><li>Excellent access: NH‑24 (Delhi–Meerut Expressway), Eastern Peripheral Expressway, Hindon Airport, and upcoming Wave City metro</li><li>Close to schools (GD Goenka, DPS), hospitals (Columbia Asia, Yashoda), shopping malls (Shipra Mall, Galleria), and commercial hubs (Noida sectors)&nbsp;</li></ol>', '<p style=\"color:#3c4436;\">✅ 1. <strong>Premium Lifestyle in a Green Township</strong></p><p>IGBC Gold-rated project with 80% open spaces, landscaped gardens, and luxury amenities like a 55,000 sq. ft. clubhouse and cascading swimming pools.</p><p>✅ 2. <strong>Strategic Expressway Location</strong></p><p>Located on NH‑24 (Delhi–Meerut Expressway) with excellent connectivity to Noida, Delhi, and the upcoming Wave City metro – ideal for both living and investment.</p><p>✅ 3. <strong>Trusted Developer with Record Sales</strong></p><p>Backed by County Group, with Phase I sold out in just 7 days (₹1,600 Cr pre-sales) – a mark of strong market trust and future value appreciation.</p>', '2025-07-15 09:50:34', '2025-07-23 06:26:42');

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

--
-- 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` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `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, 'BAPUDHAM', 'Bapudham', NULL, '1748496838.png', '2025-05-29 00:03:58', '2025-07-10 09:59:34'),
(5, 'RAJ NAGAR EXT.', 'rajnagarext', NULL, '1748501376.png', '2025-05-29 01:19:36', '2025-07-10 09:59:47'),
(6, 'WAVE CITY', 'wavecity', NULL, '1750678760.png', '2025-06-23 06:09:20', '2025-07-10 10:00:47');

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

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

CREATE TABLE `sliders` (
  `id` int NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `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
(9, 'BD1', 'BD1', '1752749850.jpg', '2025-07-17 10:57:30', '2025-07-17 10:57:30'),
(10, 'BD2', 'BD2', '1752749955.jpg', '2025-07-17 10:59:15', '2025-07-17 10:59:15'),
(11, 'BD3', 'BD3', '1752750003.jpg', '2025-07-17 11:00:03', '2025-07-17 11:00:03');

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

--
-- 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,
  `type` varchar(400) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mrp1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `dimensions` text COLLATE utf8mb4_general_ci,
  `address` text COLLATE utf8mb4_general_ci,
  `facing` varchar(400) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `detail` text COLLATE utf8mb4_general_ci,
  `trend` text COLLATE utf8mb4_general_ci,
  `locality` text COLLATE utf8mb4_general_ci,
  `recommendation` text COLLATE utf8mb4_general_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `verified` tinyint(1) NOT NULL DEFAULT '0'
) 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`, `type`, `mrp1`, `date`, `dimensions`, `address`, `facing`, `detail`, `trend`, `locality`, `recommendation`, `created_at`, `updated_at`, `verified`) VALUES
(8, 'Property 1', '<p>Best Society</p>', 'Clear', 1000000.00, 'prop1rne', 3, '1751024197.png', 'Flats', NULL, '2025-06-28', '100 gaj', 'Test Address Raj Nagar', 'North East', '<p>Test Name</p>', '<p>Test Name</p>', NULL, NULL, '2025-06-23 06:08:13', '2025-07-10 10:01:25', 0),
(9, 'vvv', '<p>vvv</p>', NULL, NULL, 'vvv', 6, '1750678801.png', 'Flats', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-23 06:10:01', '2025-07-07 10:41:39', 0),
(11, 'Property 2', '<p>Well gates society</p>', 'Clear', 20000000.00, 'prop1', 3, '1751023760.png', 'Plots', NULL, '2025-06-28', '280 Gaj', 'B block , Bapudham', 'North East', '<p>Mukesh Kumar</p>', NULL, NULL, NULL, '2025-06-27 11:29:20', '2025-07-10 10:04:06', 0),
(12, 'proprty4', '<p>vvv</p>', 'ggg', 149.00, 'property', 6, '1751266427.png', 'Plots', '56', '2025-06-30', 'ggg', 'ggg', 'gg', '<p>bb</p>', '<p>bbb</p>', '<p>nn</p>', '<p>fff</p>', '2025-06-30 06:53:47', '2025-07-07 10:41:51', 0),
(14, 'Property 3', NULL, '12', 4000000.00, 'mm', 3, '1751288144.jpg', 'Villa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-30 12:55:44', '2025-07-10 10:02:12', 0),
(15, 'Villa', NULL, NULL, NULL, 'mmr', 5, '1751288230.jpg', 'Villa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-30 12:57:10', '2025-06-30 12:58:22', 0),
(16, 'rajnagar', NULL, NULL, NULL, 'rajnagar', 5, '1751349157.jpg', 'Villa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-01 05:52:37', '2025-07-01 05:52:37', 0),
(17, 'ext', NULL, NULL, NULL, 'ext', 5, '1751349184.jpg', 'Villa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-01 05:53:04', '2025-07-01 05:53:04', 0),
(19, 'fff', NULL, '12', 149.00, 'fff', 3, '1752842731.png', 'commercial-shop', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-18 12:45:31', '2025-07-18 13:03:03', 1);

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

--
-- 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,
  `product_id` bigint UNSIGNED DEFAULT NULL,
  `sector` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `year` varchar(10) COLLATE utf8mb4_general_ci 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`, `product_id`, `sector`, `year`) VALUES
(3, '20k', '19k', NULL, '2025-07-14 08:15:08', '2025-07-14 08:25:59', 5, 'sector2', '2017'),
(4, '2ok', '39k', NULL, '2025-07-14 09:20:45', '2025-07-14 09:20:45', 3, 'sector1', '2015'),
(5, '88', '99', NULL, '2025-07-14 11:08:48', '2025-07-14 11:08:48', 3, 'sector1', '2018'),
(6, '77', '00', NULL, '2025-07-14 11:09:12', '2025-07-14 11:09:12', 3, 'sector1', '2019'),
(7, '77', '22', NULL, '2025-07-14 11:09:37', '2025-07-14 11:09:37', 3, 'sector1', '2020'),
(8, '44', '33', NULL, '2025-07-14 11:09:58', '2025-07-14 11:09:58', 3, 'sector1', '2021'),
(9, '77', '55', NULL, '2025-07-14 11:11:03', '2025-07-14 11:11:03', 5, 'sector1', '2021'),
(10, '55', '44', NULL, '2025-07-14 11:11:56', '2025-07-14 11:11:56', 5, 'sector2', '2019'),
(11, '23', '32', NULL, '2025-07-14 11:13:31', '2025-07-14 11:13:31', 5, 'sector2', '2020');

--
-- 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=4;

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

--
-- 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=12;

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

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

--
-- 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;

