-- 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 `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 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 `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) 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 `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 `site_settings`
--

CREATE TABLE `site_settings` (
  `id` bigint UNSIGNED NOT NULL,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text',
  `group` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(255) 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 `site_settings`
--

INSERT INTO `site_settings` (`id`, `key`, `value`, `type`, `group`, `label`, `created_at`, `updated_at`) VALUES
(1, 'site_name', 'SIVILIMA', 'text', 'general', 'Site Name', '2026-06-27 20:39:29', '2026-06-28 09:51:15'),
(2, 'site_description', 'Premium Ceiling, Roofing & Flooring Solutions in Sri Lanka', 'text', 'general', 'Site Description', '2026-06-27 20:39:29', '2026-06-28 08:24:05'),
(3, 'contact_email', 'info@siwilima.lk', 'text', 'contact', 'Contact Email', '2026-06-27 20:39:29', '2026-06-28 08:24:05'),
(4, 'contact_phone', '94718463919', 'text', 'contact', 'Contact Phone', '2026-06-27 20:39:29', '2026-06-28 09:53:16'),
(5, 'contact_address', 'Front Of Depot, No 47 Nuwaraeliya road, Keppetipola', 'textarea', 'contact', 'Address', '2026-06-27 20:39:29', '2026-06-28 09:53:16'),
(6, 'hero_about_title', 'Engineered to Outlast Traditional Wood & Metal', 'text', 'home', 'Why Title', '2026-06-27 20:39:29', '2026-06-28 08:24:05'),
(7, 'hero_about_desc', 'Traditional ceiling panels rot, metal roofs rust in coastal humidity, and wooden floors warp. SIVILIMA Premium solutions combine advanced ASA Polymer and composite PVC technologies to offer maintenance-free materials that stand the test of time.', 'textarea', 'home', 'Why Description', '2026-06-27 20:39:29', '2026-06-28 08:24:05'),
(8, 'cta_title', 'Looking to Upgrade Your Building Project?', 'text', 'home', 'CTA Title', '2026-06-27 20:39:29', '2026-06-28 08:24:05'),
(9, 'cta_desc', 'Get in touch with our design engineers for a free inspection, material calculation, and premium design options.', 'textarea', 'home', 'CTA Description', '2026-06-27 20:39:29', '2026-06-28 08:24:05'),
(10, 'home_stats', '[{\"number\":\"100%\",\"label\":\"Termite Free\"},{\"number\":\"15+\",\"label\":\"Years Warranty\"},{\"number\":\"300k+\",\"label\":\"Homes Beautified\"}]', 'json', 'home', 'Stats', '2026-06-27 20:57:54', '2026-06-27 20:57:54'),
(11, 'home_features', '[{\"title\":\"Eco-Friendly \\/ Lead Free\",\"desc\":\"100% substitute for wood, preserving Sri Lankan forest cover. Fully recyclable.\"},{\"title\":\"Fire Retardant (Class A)\",\"desc\":\"Engineered PVC compound which is self-extinguishing and will not spread flame.\"},{\"title\":\"100% Water Resistant\",\"desc\":\"Will not sag, rot, or expand when exposed to moisture. Ideal for tropical climates.\"},{\"title\":\"Termite & Borer Proof\",\"desc\":\"Zero organic wood material, meaning insects cannot infest or damage the panels.\"}]', 'json', 'home', 'Features', '2026-06-27 20:57:54', '2026-06-28 09:53:16'),
(12, 'turnstile_site_key', '0x4AAAAAADJVxOKYeBg2mUqV', 'text', 'security', 'Turnstile Site Key', '2026-06-27 21:49:41', '2026-06-28 09:53:16'),
(13, 'turnstile_secret_key', '0x4AAAAAADJVxCK9vfCt26sju7l18xhCMHw', 'text', 'security', 'Turnstile Secret Key', '2026-06-27 21:49:41', '2026-06-28 09:53:16'),
(14, 'social_facebook', 'https://facebook.com/', 'text', 'social', 'Facebook URL', '2026-06-27 21:49:41', '2026-06-28 08:24:05'),
(15, 'social_instagram', 'https://instagram.com/', 'text', 'social', 'Instagram URL', '2026-06-27 21:49:41', '2026-06-28 08:24:05'),
(16, 'social_twitter', 'https://x.com/', 'text', 'social', 'Twitter / X URL', '2026-06-27 21:49:41', '2026-06-28 08:24:05'),
(17, 'social_youtube', 'https://youtube.com/', 'text', 'social', 'YouTube URL', '2026-06-27 21:49:41', '2026-06-28 08:24:05'),
(18, 'about_banner_title', 'About Our Company', 'text', 'about', 'Banner Title', '2026-06-28 07:53:57', '2026-06-28 08:24:04'),
(19, 'about_banner_desc', 'SIVILIMA Premium Solutions is Sri Lanka\'s largest manufacturer and supplier of modern, eco-friendly wood-substitute building materials.', 'textarea', 'about', 'Banner Description', '2026-06-28 07:53:57', '2026-06-28 08:24:04'),
(20, 'about_banner_image', 'images/hero_ceiling.png', 'text', 'about', 'Banner Background Image', '2026-06-28 07:53:57', '2026-06-28 08:24:04'),
(21, 'about_intro_heading', 'Pioneering Green Building Material Science', 'text', 'about', 'Intro Heading', '2026-06-28 07:53:58', '2026-06-28 08:24:04'),
(22, 'about_intro_para1', 'For over a decade, we have reimagined building interiors and exteriors. By substituting organic wood with highly durable polymer composites, we preserve forests while eliminating rot, termite damage, and paint fading.', 'textarea', 'about', 'Intro Paragraph 1', '2026-06-28 07:53:58', '2026-06-28 08:24:04'),
(23, 'about_intro_para2', 'Our research and development laboratories constantly refine polymer mixtures to deliver materials that resist severe tropical climates — handling Galle\'s coastal humidity, Colombo\'s urban heat, and Nuwara Eliya\'s frost.', 'textarea', 'about', 'Intro Paragraph 2', '2026-06-28 07:53:58', '2026-06-28 08:24:04'),
(24, 'about_intro_image', 'images/hero_flooring.png', 'text', 'about', 'Intro Image', '2026-06-28 07:53:58', '2026-06-28 09:51:15'),
(25, 'about_overlay_title', 'Idea Group Subsidiary', 'text', 'about', 'Overlay Box Title', '2026-06-28 07:53:58', '2026-06-28 08:24:05'),
(26, 'about_overlay_desc', 'Guaranteed corporate trust & quality excellence.', 'text', 'about', 'Overlay Box Description', '2026-06-28 07:53:58', '2026-06-28 08:24:05'),
(27, 'about_stat1_num', '150+', 'text', 'about', 'Stat 1 - Number', '2026-06-28 07:53:58', '2026-06-28 08:24:05'),
(28, 'about_stat1_label', 'Showrooms in SL', 'text', 'about', 'Stat 1 - Label', '2026-06-28 07:53:58', '2026-06-28 08:24:05'),
(29, 'about_stat2_num', '12+', 'text', 'about', 'Stat 2 - Number', '2026-06-28 07:53:58', '2026-06-28 08:24:05'),
(30, 'about_stat2_label', 'Years of Service', 'text', 'about', 'Stat 2 - Label', '2026-06-28 07:53:58', '2026-06-28 08:24:05'),
(31, 'about_values_section_title', 'Core Brand Pillars', 'text', 'about', 'Values Section Title', '2026-06-28 07:53:58', '2026-06-28 08:24:05'),
(32, 'about_values_section_desc', 'The foundations driving our product engineering and customer support systems.', 'textarea', 'about', 'Values Section Description', '2026-06-28 07:53:58', '2026-06-28 08:24:05'),
(33, 'about_timeline_section_title', 'Our Timeline of Milestones', 'text', 'about', 'Timeline Section Title', '2026-06-28 07:53:58', '2026-06-28 08:24:05'),
(34, 'about_timeline_section_desc', 'A journey from a single ceiling brand to Sri Lanka\'s leading building supplies conglomerate.', 'textarea', 'about', 'Timeline Section Description', '2026-06-28 07:53:58', '2026-06-28 08:24:05'),
(35, 'about_mission_title', 'Our Corporate Mission', 'text', 'about', 'Mission Title', '2026-06-28 07:53:58', '2026-06-28 08:24:05'),
(36, 'about_mission_desc', 'To lead the Sri Lankan building industry by researching, producing, and distributing advanced eco-friendly alternatives to timber and steel, while supporting local structural engineering communities with sound technical resources.', 'textarea', 'about', 'Mission Description', '2026-06-28 07:53:58', '2026-06-28 08:24:05'),
(37, 'about_vision_title', 'Our Architectural Vision', 'text', 'about', 'Vision Title', '2026-06-28 07:53:58', '2026-06-28 08:24:05'),
(38, 'about_vision_desc', 'To establish a fully carbon-neutral Sri Lankan construction ecosystem where every residence and commercial venue utilizes maintenance-free, recyclable polymer components, eliminating deforestation entirely.', 'textarea', 'about', 'Vision Description', '2026-06-28 07:53:58', '2026-06-28 08:24:05'),
(39, 'about_values', '[{\"title\":\"Eco-Conservation\",\"desc\":\"Our PVC core relies on lead-free compounds, acting as a viable substitute for forest timber and preserving local biodiversity.\"},{\"title\":\"Fire & Safety First\",\"desc\":\"Safety is paramount. All material fabrications comply with Class A fire retardant self-extinguishing regulations.\"},{\"title\":\"Client Accessibility\",\"desc\":\"Through our hotline and islandwide showrooms, we ensure quick site measurements, deliveries, and engineer consults.\"}]', 'json', 'about', 'Core Values', '2026-06-28 07:53:58', '2026-06-28 07:53:58'),
(40, 'about_milestones', '[{\"year\":\"2012\",\"title\":\"Inception of i-Panel\",\"desc\":\"Introduced the first lead-free, wood-substitute PVC ceiling panels in Sri Lanka, offering a modern alternative to logging.\"},{\"year\":\"2016\",\"title\":\"i-Roof Launch\",\"desc\":\"Engineered and launched ASA Polymer roofing sheets, specifically optimized for thermal cooling in tropical climates.\"},{\"year\":\"2020\",\"title\":\"GoFloor Expansion\",\"desc\":\"Diversified into interior flooring solutions with high-end luxury vinyl tiles (LVT) planks and PVC skirtings.\"},{\"year\":\"2025\",\"title\":\"150th Showroom Milestone\",\"desc\":\"Established a deep network spanning every major city in Sri Lanka, ensuring material accessibility and direct delivery.\"}]', 'json', 'about', 'Timeline Milestones', '2026-06-28 07:53:58', '2026-06-28 07:53:58'),
(42, 'seo_home_title', 'SIVILIMA | Premium Ceiling, Roofing & Flooring Solutions Sri Lanka', 'text', 'seo', 'Home - Title', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(43, 'seo_home_desc', 'SIVILIMA Premium Solutions offers eco-friendly, fire-retardant, and durable PVC ceilings (i-Panel), ASA Polymer roofing (i-Roof), and luxury vinyl flooring in Sri Lanka. Islandwide delivery.', 'textarea', 'seo', 'Home - Description', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(44, 'seo_home_keywords', 'Sivilima, i-Panel, i-Roof, ceiling panels Sri Lanka, roofing sheets, vinyl flooring, eco-friendly building materials, PVC ceilings', 'text', 'seo', 'Home - Keywords', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(45, 'seo_home_image', 'images/hero_ceiling.png', 'text', 'seo', 'Home - OG Image', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(46, 'seo_about_title', 'About Us | SIVILIMA Premium Building Solutions', 'text', 'seo', 'About - Title', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(47, 'seo_about_desc', 'Learn about SIVILIMA Premium Solutions — Sri Lanka\'s largest manufacturer of eco-friendly wood-substitute building materials. 150+ showrooms, 12+ years of excellence.', 'textarea', 'seo', 'About - Description', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(48, 'seo_about_keywords', 'about Sivilima, building materials Sri Lanka, eco-friendly construction, PVC manufacturer, Idea Group subsidiary', 'text', 'seo', 'About - Keywords', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(49, 'seo_about_image', 'images/hero_ceiling.png', 'text', 'seo', 'About - OG Image', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(50, 'seo_products_title', 'Product Catalog | SIVILIMA Premium Building Materials', 'text', 'seo', 'Products - Title', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(51, 'seo_products_desc', 'Explore SIVILIMA\'s complete product catalog — PVC ceilings, ASA roofing sheets, vinyl flooring planks, and wall claddings. Request custom quotes online.', 'textarea', 'seo', 'Products - Description', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(52, 'seo_products_keywords', 'Sivilima products, PVC ceiling panels, ASA roofing, vinyl flooring, wall claddings, building materials catalog', 'text', 'seo', 'Products - Keywords', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(53, 'seo_products_image', 'images/hero_ceiling.png', 'text', 'seo', 'Products - OG Image', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(54, 'seo_ceiling_title', 'i-Panel PVC Ceilings | Waterproof, Termite-Free | SIVILIMA', 'text', 'seo', 'Ceiling - Title', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(55, 'seo_ceiling_desc', 'Premium i-Panel PVC ceiling solutions — 100% waterproof, fire-retardant, termite-proof. Available in wood-grain textures. 30+ year lifetime. Free site inspection.', 'textarea', 'seo', 'Ceiling - Description', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(56, 'seo_ceiling_keywords', 'PVC ceilings, i-Panel ceiling, waterproof ceiling, termite proof ceiling, ceiling panels Sri Lanka, wood substitute ceiling', 'text', 'seo', 'Ceiling - Keywords', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(57, 'seo_ceiling_image', 'images/hero_ceiling.png', 'text', 'seo', 'Ceiling - OG Image', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(58, 'seo_roofing_title', 'i-Roof ASA Polymer Roofing | Anti-Corrosive Sheets | SIVILIMA', 'text', 'seo', 'Roofing - Title', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(59, 'seo_roofing_desc', 'Tropical-grade i-Roof ASA polymer roofing sheets — heat-reflective, sound-insulating, anti-corrosive. Engineered for Sri Lankan coastal climates. 15-year warranty.', 'textarea', 'seo', 'Roofing - Description', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(60, 'seo_roofing_keywords', 'ASA roofing, i-Roof, polymer roofing sheets, anti-corrosive roofing, heat reflective roof, Sri Lanka roofing sheets', 'text', 'seo', 'Roofing - Keywords', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(61, 'seo_roofing_image', 'images/hero_roofing.png', 'text', 'seo', 'Roofing - OG Image', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(62, 'seo_flooring_title', 'GoFloor Luxury Vinyl Flooring | Anti-Slip Planks | SIVILIMA', 'text', 'seo', 'Flooring - Title', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(63, 'seo_flooring_desc', 'Premium GoFloor luxury vinyl planks — anti-scratch, anti-slip, 100% waterproof. Authentic wood-grain finishes with sound-dampening underlay. Free consultation.', 'textarea', 'seo', 'Flooring - Description', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(64, 'seo_flooring_keywords', 'vinyl flooring, GoFloor, luxury vinyl planks, waterproof flooring, wood grain flooring, LVT flooring Sri Lanka', 'text', 'seo', 'Flooring - Keywords', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(65, 'seo_flooring_image', 'images/hero_flooring.png', 'text', 'seo', 'Flooring - OG Image', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(66, 'seo_projects_title', 'Our Projects | Completed Installations | SIVILIMA', 'text', 'seo', 'Projects - Title', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(67, 'seo_projects_desc', 'Browse SIVILIMA\'s completed ceiling, roofing, and flooring projects across Sri Lanka — residential villas, hotels, commercial showrooms, and more.', 'textarea', 'seo', 'Projects - Description', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(68, 'seo_projects_keywords', 'Sivilima projects, ceiling installations, roofing projects, flooring installations, Sri Lanka construction, completed projects', 'text', 'seo', 'Projects - Keywords', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(69, 'seo_projects_image', 'images/hero_roofing.png', 'text', 'seo', 'Projects - OG Image', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(70, 'seo_blog_title', 'Blog | Building Tips & Material Guides | SIVILIMA', 'text', 'seo', 'Blog - Title', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(71, 'seo_blog_desc', 'Read expert articles on ceiling installation, roofing material science, flooring selection guides, and interior design tips from SIVILIMA\'s engineering team.', 'textarea', 'seo', 'Blog - Description', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(72, 'seo_blog_keywords', 'building tips, ceiling guide, roofing guide, flooring guide, interior design Sri Lanka, construction blog', 'text', 'seo', 'Blog - Keywords', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(73, 'seo_blog_image', 'images/hero_flooring.png', 'text', 'seo', 'Blog - OG Image', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(74, 'seo_contact_title', 'Contact Us | SIVILIMA Premium Solutions Sri Lanka', 'text', 'seo', 'Contact - Title', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(75, 'seo_contact_desc', 'Get in touch with SIVILIMA Premium Solutions. Visit our 150+ showrooms across Sri Lanka or call 072 200 2200 for free estimates on ceilings, roofing, and flooring.', 'textarea', 'seo', 'Contact - Description', '2026-06-28 08:23:47', '2026-06-28 09:51:15'),
(76, 'seo_contact_keywords', 'contact Sivilima, building materials hotline, ceiling quote Sri Lanka, roofing estimate, flooring consultation, Sivilima showroom', 'text', 'seo', 'Contact - Keywords', '2026-06-28 08:23:47', '2026-06-28 09:51:16'),
(77, 'seo_contact_image', 'images/hero_flooring.png', 'text', 'seo', 'Contact - OG Image', '2026-06-28 08:23:47', '2026-06-28 09:51:16'),
(78, 'site_logo', NULL, 'text', 'general', 'Site Logo (path or URL)', '2026-06-28 08:42:09', '2026-06-28 09:53:16'),
(79, 'site_favicon', NULL, 'text', 'general', 'Favicon (path or URL, e.g. uploads/favicon.png)', '2026-06-28 08:51:56', '2026-06-28 09:53:16'),
(80, 'whatsapp_number', '94718463919', 'text', 'contact', 'WhatsApp Number (with country code, no +)', '2026-06-28 09:51:15', '2026-06-28 09:53:16');

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

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

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

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

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) 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 `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Sivilima Admin', 'admin@siwilima.lk', '2026-06-28 09:51:15', '$2y$12$UqjvL8Qm2LG5FnHKXkPLrO9LNd4MqBR5BXicDrxvKUxV5AtdYzEC2', NULL, '2026-06-27 20:39:29', '2026-06-28 09:51:15');

--
-- 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 `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_expiration_index` (`expiration`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_locks_expiration_index` (`expiration`);

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

--
-- 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 `site_settings`
--
ALTER TABLE `site_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `site_settings_key_unique` (`key`);

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

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

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

--
-- 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 `site_settings`
--
ALTER TABLE `site_settings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  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;

