-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               8.0.30 - MySQL Community Server - GPL
-- Server OS:                    Win64
-- HeidiSQL Version:             12.1.0.6537
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- Dumping structure for table eei_new.about_settings
CREATE TABLE IF NOT EXISTS `about_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hero_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `who_we_are` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `who_we_are_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `our_message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `our_message_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `our_vision` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `our_vision_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `our_mission` text COLLATE utf8mb4_unicode_ci,
  `our_mission_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `gallery_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `about_settings_gallery_id_foreign` (`gallery_id`),
  CONSTRAINT `about_settings_gallery_id_foreign` FOREIGN KEY (`gallery_id`) REFERENCES `media_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.about_settings: ~0 rows (approximately)
INSERT INTO `about_settings` (`id`, `title`, `hero_image`, `who_we_are`, `who_we_are_image`, `our_message`, `our_message_image`, `our_vision`, `our_vision_image`, `our_mission`, `our_mission_image`, `created_at`, `updated_at`, `gallery_id`) VALUES
	(1, 'About Us', 'images/settings/about/23vpgUAcFMHKcVTqaDldf2PcvfCRSZhs8RQVl2dW.jpg', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page effortlessly and focus on showcasing your business. Our goal is to make website development accessible to everyone, ensuring you create engaging, responsive designs.', 'images/settings/about/2bjQVKZGBmks2AhTlli74Hv3q5MBVYgl3EgYdJPH.png', 'ttt', 'ttt', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page effortlessly and focus on showcasing your vision. Empower your team and elevate your goals by delivering modern and responsive designs. Lorem ipsum dolor sit amet consectetur adipisicing elit. Veritatis quae quo perferendis aliquam ab hic vitae itaque, pariatur atque id impedit blanditiis provident quam, obcaecati voluptas similique ipsam neque saepe sunt! Maxime eaque perspiciatis tempora nobis. Repudiandae nihil ex aliquam dolorem quod at odio corporis est? Odio possimus odit doloribus totam commodi doloremque? Accusantium expedita consequatur tenetur, harum, maxime repudiandae non quasi, excepturi optio nam et inventore vitae accusamus dolores omnis doloremque debitis illo architecto quaerat ducimus ab nemo in. Molestiae ex aut sunt eius cumque fugit repellendus recusandae quidem odit. Et dignissimos velit autem hic enim ipsum soluta magni.', 'images/settings/about/ZWJo3O71a9IBivyKtmtHmnWcQJRb9lz6qjEJo59P.png', 'Egestas fringilla aliquam leo, habitasse arcu varius lorem elit. Neque pellentesque donec et tellus ac varius tortor, bibendum. Nulla felis ac turpis at amet. Purus malesuada placerat arcu et enim elit in accumsan. Egestas fringilla aliquam leo, habitasse arcu varius lorem elit. Lorem ipsum, dolor sit amet consectetur adipisicing elit. Suscipit autem quibusdam laborum eveniet sint officia ex inventore fugit, reprehenderit adipisci? Neque quam beatae hic modi incidunt nisi libero magnam eius quidem debitis sit aut quod omnis, reprehenderit deleniti iste eos possimus veniam error rerum ducimus fuga nulla atque culpa! Beatae, laborum qui corrupti laboriosam voluptate quam molestias numquam error ipsam!', 'images/settings/about/SxvBs9UeH2ishuvMg3HEwrnd8HDuegWHPzqHu6YE.png', NULL, '2025-01-12 11:59:37', 4);

-- Dumping structure for table eei_new.categories
CREATE TABLE IF NOT EXISTS `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.categories: ~0 rows (approximately)
INSERT INTO `categories` (`id`, `name`, `description`, `image`, `icon`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'Low Voltage Panels Sector', 'Low Voltage Panels Sector', 'images/gallery/uJuQKawufWa5KGLhIySndYO4S04G5F05dREFj6LQ.jpg', 'images/gallery/44mqwQcDpLIzScVTUBJ1kX5Y1lGpLxeIuMaJExjm.jpg', NULL, '2025-01-12 12:35:03', '2025-01-12 12:35:03'),
	(2, 'Medium Voltage Panels Sector', 'Medium Voltage Panels Sector', 'images/gallery/KLPL2u9cvHEeDlKdwzAXgd4sM7Yri3al2u9QbUrR.jpg', 'images/gallery/0Eejm8JydZqamFbYYRu0XhC43KsRdyuwKK15CrgA.jpg', NULL, '2025-01-12 12:35:23', '2025-01-12 12:35:23');

-- Dumping structure for table eei_new.certificate_setting
CREATE TABLE IF NOT EXISTS `certificate_setting` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `gallery` bigint unsigned NOT NULL,
  `hero` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `certificate_setting_gallery_foreign` (`gallery`),
  CONSTRAINT `certificate_setting_gallery_foreign` FOREIGN KEY (`gallery`) REFERENCES `media_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.certificate_setting: ~0 rows (approximately)
INSERT INTO `certificate_setting` (`id`, `title`, `description`, `gallery`, `hero`, `created_at`, `updated_at`) VALUES
	(1, 'Certificate', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 4, 'images/lNMULVI8hq62ehEN6RBhJObOfUCyvgaTI4ADasMY.png', NULL, '2025-01-13 07:37:43');

-- Dumping structure for table eei_new.failed_jobs
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.failed_jobs: ~0 rows (approximately)

-- Dumping structure for table eei_new.galleries
CREATE TABLE IF NOT EXISTS `galleries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gallery_category_id` bigint unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `galleries_gallery_category_id_foreign` (`gallery_category_id`),
  CONSTRAINT `galleries_gallery_category_id_foreign` FOREIGN KEY (`gallery_category_id`) REFERENCES `media_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.galleries: ~1 rows (approximately)
INSERT INTO `galleries` (`id`, `title`, `name`, `description`, `gallery_category_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'images/gallery/2FIEeQgIz71ZtXWOAWWbk6lkep2HI4BbTyDOY9Y9.svg', 'certification of Quality', 'Elit purus magna donec mattis amet, leo varius sed.Elit purus magna donec mattis amet, leo varius sed.', 4, NULL, '2025-01-12 12:25:39', '2025-01-12 12:25:39'),
	(2, 'images/gallery/2FIEeQgIz71ZtXWOAWWbk6lkep2HI4BbTyDOY9Y9.svg', 'certification of Quality', 'Elit purus magna donec mattis amet, leo varius sed.Elit purus magna donec mattis amet, leo varius sed.', 4, NULL, '2025-01-12 12:31:27', '2025-01-12 12:31:27'),
	(3, 'images/gallery/vIiAJRkPJK6m7bpq7vmTRW4OL7NcOevrNDAMovuX.jpg', 'certification of Quality', 'certification of Quality', 4, NULL, '2025-01-13 07:50:57', '2025-01-13 07:50:57');

-- Dumping structure for table eei_new.home_pages
CREATE TABLE IF NOT EXISTS `home_pages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slider1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slider2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `who_we_are_desc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `services` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `feature1_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `feature2_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `feature3_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `feature1_desc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `feature2_desc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `feature3_desc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.home_pages: ~0 rows (approximately)
INSERT INTO `home_pages` (`id`, `slider1`, `slider2`, `title`, `description`, `who_we_are_desc`, `services`, `feature1_title`, `feature2_title`, `feature3_title`, `feature1_desc`, `feature2_desc`, `feature3_desc`, `created_at`, `updated_at`) VALUES
	(1, 'images/home/a88pBro95zqD0qE537dIV7jgX6owdxlHP7VwCqEo.jpg', 'images/home/VxN2GfRVloF8k69qISGTaUTKWkuqJ0u2H9wOoDGJ.jpg', 'Egyptian Company for Electrical Industries', 'With lots of unique blocks, you can easily build a page without coding. Build your next consultancy website within few minutes.', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Harum molestiae corrupti reiciendis blanditiis vero minima, modi consectetur. Quod, non possimus ducimus magni numquam nemo vitae error eum nobis placeat praesentium delectus explicabo beatae officiis fuga cum? Excepturi harum quam numquam necessitatibus quia', 'Switchgear Safety', 'Compliance Assured', 'Operational Efficiency', 'Elit purus magna donec mattis amet, leo varius sed. Elit purus magna donec mattis amet, leo varius sed.', 'Elit purus magna donec mattis amet, leo varius sed. Elit purus magna donec mattis amet, leo varius sed.', 'Elit purus magna donec mattis amet, leo varius sed. Elit purus magna donec mattis amet, leo varius sed.', '2025-01-12 13:49:34', '2025-01-12 11:52:21');

-- Dumping structure for table eei_new.logs
CREATE TABLE IF NOT EXISTS `logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.logs: ~0 rows (approximately)

-- Dumping structure for table eei_new.media_categories
CREATE TABLE IF NOT EXISTS `media_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.media_categories: ~0 rows (approximately)
INSERT INTO `media_categories` (`id`, `title`, `description`, `created_at`, `updated_at`) VALUES
	(1, 'Quis nisi anim a ani', 'Alias aut eu in et q', '2025-01-12 11:27:04', '2025-01-12 11:27:04'),
	(2, 'Quis nisi anim a ani', 'Alias aut eu in et q', '2025-01-12 11:27:42', '2025-01-12 11:27:42'),
	(3, 'Voluptas illum nobi', 'Suscipit in quis ali', '2025-01-12 11:28:05', '2025-01-12 11:28:05'),
	(4, 'Certificates', 'Certificates', '2025-01-12 11:59:07', '2025-01-12 11:59:07');

-- Dumping structure for table eei_new.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.migrations: ~0 rows (approximately)
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),
	(5, '2024_12_31_111502_create_categories_table', 1),
	(6, '2024_12_31_111521_create_services_table', 1),
	(7, '2024_12_31_111542_create_partners_table', 1),
	(8, '2024_12_31_111554_create_pages_table', 1),
	(10, '2024_12_31_111620_create_staff_table', 1),
	(11, '2024_12_31_111625_create_logs_table', 1),
	(12, '2025_01_01_101158_create_home_pages_table', 1),
	(13, '2025_01_02_144925_add_footer_to_settings_table', 1),
	(14, '2025_01_03_114631_add_columns_to_partners_table', 1),
	(15, '2025_01_03_121533_add_columns_to_partners_table', 1),
	(16, '2025_01_03_122540_add_columns_to_users_table', 1),
	(17, '2025_01_03_154048_add_columns_to_users_table', 1),
	(18, '2025_01_03_161958_add_columns_to_users_table', 1),
	(19, '2025_01_04_145802_create_about_settings_table', 1),
	(21, '2025_01_11_120558_media_category', 1),
	(22, '2025_01_12_115730_add_column_to_about_settings_table', 1),
	(25, '2026_1_11_111533_create_galleries_table', 2),
	(27, '2024_12_31_111611_create_settings_table', 3),
	(29, '2025_01_13_091741_create_certificate_setting_table', 4);

-- Dumping structure for table eei_new.pages
CREATE TABLE IF NOT EXISTS `pages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.pages: ~0 rows (approximately)

-- Dumping structure for table eei_new.partners
CREATE TABLE IF NOT EXISTS `partners` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.partners: ~0 rows (approximately)

-- Dumping structure for table eei_new.password_reset_tokens
CREATE TABLE IF NOT EXISTS `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,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.password_reset_tokens: ~0 rows (approximately)

-- Dumping structure for table eei_new.personal_access_tokens
CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.personal_access_tokens: ~0 rows (approximately)

-- Dumping structure for table eei_new.services
CREATE TABLE IF NOT EXISTS `services` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `pakage_size` int NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `services_category_id_foreign` (`category_id`),
  CONSTRAINT `services_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.services: ~0 rows (approximately)
INSERT INTO `services` (`id`, `name`, `description`, `content`, `pakage_size`, `image`, `status`, `category_id`, `created_at`, `updated_at`) VALUES
	(1, 'MCCB', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 44, 'images/gallery/3pEad3HDz0C2eqhrxXG5HKY69x3X36hsnpIHxDlg.jpg', 41, 1, '2025-01-12 12:38:15', '2025-01-12 12:38:15'),
	(2, 'MVF', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 4, 'images/gallery/oPyiXQB4W0OTn0Im0NiwnxbQi51kUtsq8C0lyqOV.jpg', 97, 1, '2025-01-12 12:40:57', '2025-01-12 12:40:57'),
	(3, 'Packaged Substation', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 54, 'images/gallery/ahwHvDmFatTkV7jy50tSznIX8y66jFWQK9VvFHEl.jpg', 84, 1, '2025-01-12 12:41:57', '2025-01-12 12:41:57'),
	(4, 'Switch-disconnector', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 49, 'images/gallery/VenC4EMEMlBKB2wOkUEAHOw1z8BP3pURtPDkYxYi.png', 45, 1, '2025-01-12 12:43:08', '2025-01-12 12:43:08'),
	(5, 'MCCB', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 78, 'images/gallery/42kr1aM9faLOHkpEuQilQcKLqd7eI9OZESqzAAK1.jpg', 7, 1, '2025-01-12 12:43:39', '2025-01-12 12:43:39'),
	(6, 'MCCB', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 11, 'images/gallery/jZFK9KYccvUe6Al3Zox4hBDVmZpv6Bl19crzJZ9p.jpg', 72, 2, '2025-01-12 12:44:26', '2025-01-12 12:44:26'),
	(7, 'MVF', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 22, 'images/gallery/IEx115CPNaCAg6LMxYL5Ric6acctoOfUUnhant1h.jpg', 1, 2, '2025-01-12 12:45:06', '2025-01-12 12:45:06'),
	(8, 'Packaged Substation', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 89, 'images/gallery/PSsgalMp5nEi9cECWJLsq1ulcpUzDYzQhYSG1cho.png', 1, 2, '2025-01-12 12:45:34', '2025-01-12 12:45:34'),
	(9, 'Switch-disconnector', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 89, 'images/gallery/9fuQKhhzkQcGJVXG7GwOenDtVnssFWKVXJfa9ZKB.jpg', 2, 2, '2025-01-12 12:46:10', '2025-01-12 12:46:10'),
	(10, 'MCCB', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 'With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page. With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.With lots of unique blocks, you can easily build a page without coding. Build your next landing page.', 73, 'images/gallery/F8V1BCTP9qzXzI5x2eVbQ6KItBYvfqIquEWD8LLf.jpg', 5, 2, '2025-01-12 12:46:42', '2025-01-12 12:46:42');

-- Dumping structure for table eei_new.settings
CREATE TABLE IF NOT EXISTS `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `site-name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `favicon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `working-hours` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '10',
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `facebook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `youtube` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.settings: ~0 rows (approximately)
INSERT INTO `settings` (`id`, `site-name`, `logo`, `favicon`, `footer`, `phone`, `email`, `working-hours`, `address`, `facebook`, `instagram`, `linkedin`, `youtube`, `created_at`, `updated_at`) VALUES
	(1, 'Neve Barrett', 'images/1h0H43a6lYBYKKKRHHA7lsa7M469d0v5tuHaRCGX.svg', 'images/ezek1fIyk8xahwqYZBDI8NeT918Kg6A1lRlF3Dka.png', 'images/JmZmbznDPJ1qJW4CkMoCFu45GTsEowOhlQncgpN9.png', '+1 (617) 896-6519', 'hevyp@mailinator.com', '10', 'Deleniti officiis op', 'Dolor et et nihil la', 'Maxime ea neque volu', 'Eaque consequatur r', 'Qui et perferendis c', '2025-01-13 08:57:11', '2025-01-13 07:01:24');

-- Dumping structure for table eei_new.staff
CREATE TABLE IF NOT EXISTS `staff` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.staff: ~0 rows (approximately)

-- Dumping structure for table eei_new.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `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 DEFAULT '$2y$12$PXW76IRXlUmIwlJz2/VaauHVY20XaltWRy1kaCl4/eVwOzW3I0.H6',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table eei_new.users: ~0 rows (approximately)
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `is_admin`, `deleted_at`) VALUES
	(1, 'Mahmoud', 'supervisor@gmail.com', '2025-01-12 11:23:02', '$2y$12$yB.b3QtzkQ653c.VSItr5O610a1YkvnvAowJeGqyr/Rzkc67pWnR2', 'y7mIwbMJ5V', '2025-01-12 11:23:02', '2025-01-12 11:23:02', 0, NULL);

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;