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

START TRANSACTION;



--
-- Database: `siwilima`
--

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

--
-- Table structure for table `blog_posts`
--

CREATE TABLE `blog_posts` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `excerpt` text COLLATE utf8mb4_unicode_ci,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `read_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `published_at` timestamp NULL DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT '0',
  `sort_order` 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 `blog_posts`
--

INSERT INTO `blog_posts` (`id`, `title`, `slug`, `category`, `image`, `excerpt`, `content`, `read_time`, `published_at`, `is_published`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, 'How to Select the Perfect PVC Ceiling Texture for Your Living Space', 'how-to-select-pvc-ceiling-texture', 'design', 'images/hero_ceiling.png', 'Wooden ceilings offer classic elegance but require expensive maintenance. Discover how to pick the right PVC wood-grain texture to fit your lighting.', '<h3>Aesthetic Harmony in Modern Interiors</h3><p>Choosing ceiling materials dictates the visual warmth of any room. Traditional timber ceilings bring a classic appeal but come with heavy maintenance costs, termite risks, and periodic painting.</p><h4>Matching Textures with Natural Light</h4><p>If your room has large glass windows and receives abundant morning light, darker textures like <strong>Premium Mahogany</strong> or <strong>Royal Teak</strong> will absorb harsh reflections while adding warmth.</p><p>For smaller rooms with limited natural light, lighter wood textures like <strong>Natural Oak</strong> or <strong>Ash Grey</strong> create an illusion of spaciousness.</p>', '5 min read', '2026-06-17 18:30:00', 1, 1, '2026-06-27 21:30:16', '2026-06-27 21:30:16'),
(2, 'The Science Behind ASA Polymer: Why i-Roof Beats Galvanized Steel Sheets', 'science-behind-asa-polymer-roofing', 'tech', 'images/hero_roofing.png', 'In hot tropical regions, steel sheets absorb solar energy, acting as radiators. Read why multi-layer polymer roofing lowers indoor temperature.', '<h3>The Tropical Roof Challenge</h3><p>Galvanized corrugated metal roofs have long been the standard in Sri Lanka due to initial low costs. However, they present significant performance challenges in tropical coastal environments.</p><h4>How ASA Polymer Works</h4><p>ASA (Acrylonitrile Styrene Acrylate) is an advanced thermoplastic with exceptional UV resistance. Unlike steel which conducts heat directly into your home, the multi-layer polymer structure of i-Roof sheets creates a thermal barrier.</p><p>Independent laboratory tests show that ASA polymer sheets can reduce roof surface temperature by up to 15°C compared to dark-colored steel sheets under the same solar exposure.</p>', '7 min read', '2026-05-27 18:30:00', 1, 2, '2026-06-27 21:30:16', '2026-06-27 21:30:16'),
(3, 'Luxury Vinyl Flooring Planks Installation: Glue-Down vs Interlocking', 'vinyl-flooring-glue-down-vs-interlocking', 'guide', 'images/hero_flooring.png', 'Selecting flooring involves deciding on backing mechanisms. Read our direct comparison guide on durability, costs, and water protection differences.', '<h3>A Modern Floor Alternative</h3><p>Luxury Vinyl Tiles (LVT) and planks have surged in popularity across Sri Lankan homes and commercial spaces. They offer the aesthetic of hardwood with the durability of polymer engineering.</p><h4>Glue-Down System</h4><p>Glue-down vinyl planks are directly adhered to the subfloor using specialized adhesive. This method provides exceptional stability for heavy load areas like commercial showrooms. It allows individual plank replacement without lifting the entire floor.</p><h4>Interlocking (Click-Lock) System</h4><p>Click-lock planks float over the subfloor, making them ideal for DIY installations and rental properties. They can be uninstalled and reinstalled without damage. However, they may produce a slight hollow sound underfoot without proper underlayment.</p>', '6 min read', '2026-04-09 18:30:00', 1, 3, '2026-06-27 21:30:16', '2026-06-27 21:30:16');

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

--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hours` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `map_embed` text COLLATE utf8mb4_unicode_ci,
  `sort_order` int NOT NULL DEFAULT '0',
  `is_active` tinyint(1) 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 `branches`
--

INSERT INTO `branches` (`id`, `name`, `address`, `phone`, `hours`, `map_embed`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Keppetipola', 'Front Of Depot, No 47 Nuwaraeliya road, Keppetipola', '94718463919', 'Mon - Sat: 8:30 AM - 5:30 PM', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3962.062086884024!2d80.87258827589255!3d6.89668229310237!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3ae37900107aaeb1%3A0xe7a2332f555735b6!2sSivilima%20Keppetipola!5e0!3m2!1sen!2slk!4v1719586000000!5m2!1sen!2slk', 1, 1, '2026-06-27 21:55:29', '2026-06-28 09:54:33');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) 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 `categories`
--

INSERT INTO `categories` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES
(1, 'Ceiling', 'ceiling', '2026-06-27 21:05:35', '2026-06-27 21:05:35'),
(2, 'Roofing', 'roofing', '2026-06-27 21:05:35', '2026-06-27 21:05:35'),
(3, 'Flooring', 'flooring', '2026-06-27 21:05:35', '2026-06-27 21:05:35');

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

--
-- Table structure for table `contact_inquiries`
--

CREATE TABLE `contact_inquiries` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `interest` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_read` 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;

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

--
-- 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` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` varchar(255) 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 `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` smallint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 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, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_06_28_020818_create_sliders_table', 1),
(5, '2026_06_28_020819_create_site_settings_table', 1),
(6, '2026_06_28_020820_create_testimonials_table', 1),
(7, '2026_06_28_023227_create_categories_table', 2),
(8, '2026_06_28_023229_create_products_table', 2),
(9, '2026_06_28_023922_create_projects_table', 3),
(10, '2026_06_28_025650_create_blog_posts_table', 4),
(11, '2026_06_28_031608_create_contact_inquiries_table', 5),
(12, '2026_06_28_032247_create_branches_table', 6),
(13, '2026_06_28_050000_add_map_embed_to_branches_table', 7);

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

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

CREATE TABLE `products` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `price` decimal(12,2) NOT NULL DEFAULT '0.00',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` bigint UNSIGNED NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `sort_order` 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 `products`
--

INSERT INTO `products` (`id`, `name`, `description`, `price`, `image`, `category_id`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, 'i-Panel Finishing Ceiling', 'Premium PVC ceiling panels with natural wood-grain texture. Water-resistant, termite-free, fire-retardant. Perfect for living rooms and bedrooms.', 450.00, 'images/hero_ceiling.png', 1, 1, 1, '2026-06-27 21:05:35', '2026-06-27 21:05:35'),
(2, 'i-Panel Heavy Duty Ceiling', 'Extra thick PVC ceiling panels for commercial and industrial spaces. Superior durability and load-bearing capacity.', 580.00, 'images/hero_ceiling.png', 1, 1, 2, '2026-06-27 21:05:35', '2026-06-27 21:05:35'),
(3, 'i-Roof Standard Sheet', 'ASA Polymer layered roof sheet with heat insulation. Anti-corrosive, sound dampening, and UV resistant for tropical climates.', 1250.00, 'images/hero_roofing.png', 2, 1, 1, '2026-06-27 21:05:35', '2026-06-27 21:05:35'),
(4, 'i-Roof Premium Sheet', 'Triple-layer ASA polymer roofing with advanced thermal barrier. 15-year warranty, ideal for coastal and high-humidity areas.', 1850.00, 'images/hero_roofing.png', 2, 1, 2, '2026-06-27 21:05:35', '2026-06-27 21:05:35'),
(5, 'GoFloor Vinyl Plank - Oak', 'Luxury vinyl flooring plank with authentic oak wood texture. Anti-scratch, anti-slip, 100% waterproof. Click-lock installation.', 320.00, 'images/hero_flooring.png', 3, 1, 1, '2026-06-27 21:05:35', '2026-06-27 21:05:35'),
(6, 'GoFloor Vinyl Plank - Teak', 'Premium teak-finish luxury vinyl plank. Sound dampening underlayment included. Perfect for bedrooms and living areas.', 380.00, 'images/hero_flooring.png', 3, 1, 2, '2026-06-27 21:05:35', '2026-06-27 21:05:35');

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

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `scale` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `images` json DEFAULT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `is_active` tinyint(1) 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 `projects`
--

INSERT INTO `projects` (`id`, `name`, `location`, `description`, `scale`, `category`, `images`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Luxury Residential Villa', 'Colombo 07', 'Materials: i-Panel finishing ceiling (Mahogany), GoFloor vinyl planks (Warm Oak)', '3,200 sq ft coverage', 'residential', '[\"images/project_villa.png\", \"images/project_villa_2.png\", \"images/project_villa_3.png\", \"images/project_villa_4.png\"]', 1, 1, '2026-06-27 21:12:49', '2026-06-27 21:17:44'),
(2, 'Heritage Boutique Hotel', 'Galle Fort', 'Materials: i-Roof ASA sheets (Charcoal Grey)', '5,500 sq ft near ocean salt-belt', 'hospitality', '[\"images/project_hotel.png\", \"images/project_hotel_2.png\", \"images/project_hotel_3.png\", \"images/project_hotel_4.png\"]', 2, 1, '2026-06-27 21:12:49', '2026-06-27 21:17:44'),
(3, 'Contemporary Mountain Retreat', 'Kandy', 'Materials: i-Panel ceilings (Teak), i-Roof sheets (Forest Green)', '2,800 sq ft layouts', 'residential', '[\"images/project_retreat.png\", \"images/project_retreat_2.png\"]', 3, 1, '2026-06-27 21:12:49', '2026-06-27 21:17:44'),
(4, 'Automobile Luxury Showroom', 'Negombo', 'Materials: i-Panel Heavy-B ceiling panels, fluted 3D wall cladding', '4,500 sq ft retail layout', 'commercial', '[\"images/project_showroom.png\", \"images/project_showroom_2.png\", \"images/project_showroom_3.png\", \"images/project_showroom_4.png\"]', 4, 1, '2026-06-27 21:12:49', '2026-06-27 21:17:44');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `sliders` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button2_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button2_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `is_active` tinyint(1) 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 `sliders`
--

INSERT INTO `sliders` (`id`, `title`, `subtitle`, `description`, `image`, `link_text`, `link_url`, `button2_text`, `button2_url`, `product_key`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'i-Panel PVC Ceilings', 'LIFETIME CEILING SOLUTIONS', 'Eco-friendly, water-resistant, termite-free, and fire-retardant ceiling panels. Upgrade your interior spaces with natural wooden textures that last a lifetime.', 'images/hero_ceiling.png', 'Explore Ceilings', 'ceiling', 'Request Quote', NULL, 'ceil-finishing', 1, 1, '2026-06-27 20:39:29', '2026-06-27 20:39:29'),
(2, 'i-Roof Polymer Sheets', 'ADVANCED WEATHER PROTECTION', 'ASA Polymer layered roof sheets engineered for harsh tropical climates. Heat insulated, anti-corrosive, sound dampening, and color fade resistant.', 'images/hero_roofing.png', 'Explore Roofing', 'roofing', 'Request Quote', NULL, 'roof-standard', 2, 1, '2026-06-27 20:39:29', '2026-06-27 20:39:29'),
(3, 'GoFloor Vinyl Planks', 'ELEGANT FLOORING DESIGNS', 'Luxury vinyl flooring planks with anti-scratch, anti-slip, and water-resistant technology. Bring the warmth and elegance of solid wood to any room.', 'images/hero_flooring.png', 'Explore Flooring', 'flooring', 'Request Quote', NULL, 'floor-plank', 3, 1, '2026-06-27 20:39:29', '2026-06-27 20:39:29');

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

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

CREATE TABLE `testimonials` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quote` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `is_active` tinyint(1) 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 `testimonials`
--

INSERT INTO `testimonials` (`id`, `name`, `role`, `quote`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Samantha Wijesinghe', 'Architect, Colombo', 'We installed i-Panel finishing ceilings in our entire living room and veranda. The wood texture is indistinguishable from real teak, and it completely changed the elegance of the house. No painting needed, ever!', 1, 1, '2026-06-27 20:39:29', '2026-06-27 20:39:29'),
(2, 'Dinesh Wickramasinghe', 'Architect, Colombo', 'Switching our ceiling contracts from timber to i-Panel saved our project nearly 12% in materials cost and eliminated the risk of termite damage. Our clients love the genuine wood texture.', 2, 1, '2026-06-27 20:39:29', '2026-06-27 20:39:29'),
(3, 'Malith Fernando', 'Project Engineer, Galle', 'The ASA Polymer roofing sheets from SIVILIMA outperformed any metal sheet we\'ve used. Even on a coastal hotel in Galle, zero corrosion after three monsoon seasons.', 3, 1, '2026-06-27 20:39:30', '2026-06-27 20:39:30');

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `contact_inquiries`
--
ALTER TABLE `contact_inquiries`
  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`),
  ADD KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  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`),
  ADD KEY `products_category_id_foreign` (`category_id`);

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

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;
COMMIT;

