[BLOB]\"></figure><p><span style=\"font-size:18px;\">Fish feed contains various raw materials with characteristics and of diverse origin. The high demands towards raw material quality require a thorough understanding of the functionality of each raw material in fish feed – down to fish species level.</span></p><p><span style=\"font-size:18px;\">Raw materials are tested in feeding trials for nutrient digestibility as well as effects on fish growth and health.</span></p><p><span style=\"font-size:18px;\">At Smart Masheda Research, we are constantly screening and testing new raw materials in our fish feeds, ultimately adding them to our raw material portfolio.</span></p>', 1, 3, '2023-04-19 12:08:33', '2023-05-08 07:13:49');
INSERT INTO `sections` (`id`, `page_id`, `description`, `status`, `order`, `created_at`, `updated_at`) VALUES
(11, 4, '<h4><span style=\"font-size:28px;\"><strong>High Tech Production Line</strong></span><br>&nbsp;<img class=\"image-style-align-right image image-style-block-align-left\" src=\"data: image/jpeg;base64,[BLOB]\"></h4><p><span style=\"font-size:18px;\">Smart Masheda production line Depend on the best Fish feed producing equipment’s as we believe that the Equipment’s is one the important and key factors to introduce high quality product to our valuable customers</span></p>', 1, 4, '2023-04-19 12:09:08', '2023-05-08 07:14:27');
INSERT INTO `sections` (`id`, `page_id`, `description`, `status`, `order`, `created_at`, `updated_at`) VALUES
(12, 1, '<p><span style=\"color:rgb(5,104,57);font-size:28px;\"><span class=\"blue-text text-uppercase\" style=\"box-sizing:border-box;text-transform:uppercase !important;\"><strong>OBJECTIVES&nbsp;</strong></span></span></p><ul><li><span style=\"color:hsl(0,0%,0%);font-size:18px;\"><span class=\"blue-text text-uppercase\" style=\"box-sizing:border-box;text-transform:uppercase !important;\">Ensure feed produced is safe and wholesome along the food chain.</span></span></li><li><span style=\"color:hsl(0,0%,0%);font-size:18px;\"><span class=\"blue-text text-uppercase\" style=\"box-sizing:border-box;text-transform:uppercase !important;\">Contribute to boosting the local economy from fish production.</span></span></li><li><span style=\"color:hsl(0,0%,0%);font-size:18px;\"><span class=\"blue-text text-uppercase\" style=\"box-sizing:border-box;text-transform:uppercase !important;\">Improve the quality of our clients’ farmed fish.</span></span></li><li><span style=\"color:hsl(0,0%,0%);font-size:18px;\"><span class=\"blue-text text-uppercase\" style=\"box-sizing:border-box;text-transform:uppercase !important;\">Help protect over fished species regionally and globally.</span></span></li><li><span style=\"color:hsl(0,0%,0%);font-size:18px;\"><span class=\"blue-text text-uppercase\" style=\"box-sizing:border-box;text-transform:uppercase !important;\">Increase fish trade and foreign exchange.</span></span></li><li><span style=\"color:hsl(0,0%,0%);font-size:18px;\"><span class=\"blue-text text-uppercase\" style=\"box-sizing:border-box;text-transform:uppercase !important;\">Heighten fish producers’ incomes.</span></span></li></ul>', 1, 5, '2023-04-27 00:50:01', '2023-05-09 08:10:12'),
(13, 5, '<h1 class=\"text-uppercase\" style=\"-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);box-sizing:border-box;color:rgb(26, 29, 32);font-family:Raleway, sans-serif;font-size:4rem;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;letter-spacing:0.1px;line-height:4rem;margin:0px 0px 1.25rem;orphans:2;text-align:left;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:uppercase !important;white-space:normal;widows:2;word-spacing:0px;\"><span style=\"color:rgb(5,104,57);\"><span class=\"orange-text\" style=\"box-sizing:border-box;\"><strong>SPECIAL</strong></span></span><span style=\"color:rgb(242,129,35);\"><span class=\"orange-text\" style=\"box-sizing:border-box;\"><strong> </strong></span></span><span style=\"color:hsl(0,0%,0%);\"><span class=\"orange-text\" style=\"box-sizing:border-box;\"><strong>Smart Masheda</strong></span></span><span style=\"color:rgb(242,129,35);\"><span class=\"orange-text\" style=\"box-sizing:border-box;\"><strong> </strong></span></span><span style=\"color:rgb(5,104,57);\"><span class=\"orange-text\" style=\"box-sizing:border-box;\"><strong>FORMULA</strong></span></span><span style=\"color:rgb(242,129,35);\"><span class=\"orange-text\" style=\"box-sizing:border-box;\"><strong>&nbsp;</strong></span></span></h1><p class=\"quality-desc\" style=\"-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);box-sizing:border-box;color:rgb(26, 29, 32);font-family:Raleway, sans-serif;font-size:18px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:0.1px;line-height:1.8;margin:0px 0px 0px !important;orphans:2;padding:5px 20px;text-align:left;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;\"><span style=\"font-size:18px;\">\'The components of the Smart Masheda® formula are derived from plant-based and animal sources with first-class nutritional composition to bring quality sinking and floating Smart Masheda feeds.</span></p><p class=\"quality-desc\" style=\"-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);box-sizing:border-box;color:rgb(26, 29, 32);font-family:Raleway, sans-serif;font-size:18px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:0.1px;line-height:1.8;margin:0px 0px 0px !important;orphans:2;padding:5px 20px;text-align:left;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;\"><span style=\"font-size:18px;\">The main dietary protein source in our formulation is fish meal. We also use plant protein sources such as soy protein and corn gluten. Among plant protein ingredients, soybean meal (SBM), the most nutritive plant ingredient used in feeding farmed fish.</span></p><p class=\"quality-desc\" style=\"-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);box-sizing:border-box;color:rgb(26, 29, 32);font-family:Raleway, sans-serif;font-size:18px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:0.1px;line-height:1.8;margin:0px;orphans:2;padding:5px 20px;text-align:left;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;\"><span style=\"font-size:18px;\">It has a well-balanced amino acid profile and is resistant to oxidation and spoilage. SBM is free of organisms such as fungi, viruses, and bacteria while it enjoys high digestibility.</span></p>', 1, 1, '2023-04-27 01:51:09', '2023-05-09 08:18:46');
INSERT INTO `sections` (`id`, `page_id`, `description`, `status`, `order`, `created_at`, `updated_at`) VALUES
(14, 5, '<p><img class=\"image image-style-align-right\" src=\"data: image/jpeg;base64,[BLOB]\"><a style=\"background-color:transparent;box-sizing:border-box;color:rgb(0, 123, 255);cursor:pointer;text-decoration:none;transition:all 0.2s ease-in-out 0s;\" href=\"https://drive.google.com/file/d/1l8tj8KxgrE6OkGg9xd4w29Pa08RhTxAp/view\" target=\"_blank\"><span style=\"font-size:24px;\"><strong>ISO 9001:2015 Quality Management Systems</strong></span></a></p><p><span style=\"background-color:rgb(255,255,255);color:rgb(0,0,0);font-family:Raleway, sans-serif;font-size:18px;\"><span style=\"-webkit-text-stroke-width:0px;display:inline !important;float:none;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:500;letter-spacing:0.1px;orphans:2;text-align:justify;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;\">An international standard that specifies requirements for a quality management system (QMS). Organizations use the standard to demonstrate the ability to consistently provide products and services that meet customer and regulatory requirements.</span></span></p>', 1, 2, '2023-04-27 01:52:05', '2023-04-27 02:04:27');
INSERT INTO `sections` (`id`, `page_id`, `description`, `status`, `order`, `created_at`, `updated_at`) VALUES
(15, 5, '<p><img class=\"image-style-align-left image_resized image\" style=\"width:32.73%;\" src=\"data:image/png;base64,[BLOB]\" uploadprocessed=\"true\"><a style=\"background-color:transparent;box-sizing:border-box;color:rgb(0, 123, 255);cursor:pointer;text-decoration:none;transition:all 0.2s ease-in-out 0s;\" href=\"https://drive.google.com/file/d/1l8tj8KxgrE6OkGg9xd4w29Pa08RhTxAp/view\" target=\"_blank\"><span style=\"font-size:24px;\"><strong>ISO 14001:2015 Environmental Management Systems</strong></span></a></p><p><span style=\"background-color:rgb(255,255,255);color:rgb(0,0,0);font-family:Raleway, sans-serif;font-size:18px;\"><span style=\"-webkit-text-stroke-width:0px;display:inline !important;float:none;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:500;letter-spacing:0.1px;orphans:2;text-align:justify;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;\">(EMS) is a systematic framework to manage the immediate and long-term environmental impacts of an organization’s products, services and process</span></span></p>', 1, 3, '2023-04-27 01:53:02', '2023-04-27 02:01:47'),
(16, 6, '<p class=\"top-sub\" style=\"-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);box-sizing:border-box;color:rgb(26, 29, 32);font-family:Raleway, sans-serif;font-size:16px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:500;letter-spacing:0.1px;line-height:1.6;margin:0px 0px 10px;orphans:2;text-align:left;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;\"><br>&nbsp;</p><p>&nbsp;</p><p class=\"top-sub\" style=\"-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);box-sizing:border-box;color:rgb(26, 29, 32);font-family:Raleway, sans-serif;font-size:16px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:500;letter-spacing:0.1px;line-height:1.6;margin:0px 0px 10px;orphans:2;text-align:left;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;\">Since Year 1964</p><h2 style=\"-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);box-sizing:border-box;color:rgb(26, 29, 32);font-family:Raleway, sans-serif;font-size:3rem;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;letter-spacing:0.1px;line-height:3.25rem;margin:0px 0px 1.25rem;orphans:2;text-align:left;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;\"><strong>We are </strong><span style=\"color:rgb(5,104,57);\"><strong>Smart Masheda</strong></span><span style=\"color:rgb(242,129,35);\"><strong>&nbsp;</strong></span></h2><p style=\"-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);box-sizing:border-box;color:rgb(26, 29, 32);font-family:Raleway, sans-serif;font-size:16px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:500;letter-spacing:0.1px;line-height:1.6;margin:0px 0px 10px;orphans:2;text-align:left;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;\"><strong>Smart Masheda®</strong> offers balanced nutrition for farmed fish. We serve fish farmers to raise Fish production while maintaining resources for tomorrow’s food production.</p><p style=\"-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);box-sizing:border-box;color:rgb(26, 29, 32);font-family:Raleway, sans-serif;font-size:16px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:500;letter-spacing:0.1px;line-height:1.6;margin:0px 0px 10px;orphans:2;text-align:left;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;\">We improve pisciculture sustainability by boosting the efficiency of feed production and conversion to lessen environmental impact and preserve natural assets.</p>', 1, 1, '2023-04-27 02:08:56', '2023-05-09 08:13:26');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `value` text 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 `settings`
--

INSERT INTO `settings` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES
(1, 'name', 'Smart Masheda', '2023-04-12 15:32:31', '2023-05-10 09:31:18'),
(2, 'email', 'info@smartmasheda.com', '2023-04-12 15:32:31', '2023-05-10 09:31:18'),
(3, 'phone', '+202 25645185', '2023-04-12 15:32:31', '2023-05-10 09:31:18'),
(4, 'address', 'Villa 148 - 2nd Neighborhood - 2nd Area Fifth Settlement , Cairo Egypt.', '2023-04-12 15:32:31', '2023-05-10 09:31:18'),
(5, 'location', 'https://www.google.com/maps/embed?pb=!1m17!1m12!1m3!1d3454.9517083492783!2d31.44292299999999!3d30.009542999999997!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m2!1m1!2zMzDCsDAwJzM0LjQiTiAzMcKwMjYnMzQuNSJF!5e0!3m2!1sen!2seg!4v1682953625471!5m2!1sen!2seg', '2023-04-12 15:32:31', '2023-05-10 09:31:18'),
(6, 'logo', 'setting/logo.png', '2023-04-12 15:32:31', '2023-05-01 08:16:06'),
(7, 'icon', 'setting/icon.png', '2023-04-12 15:32:31', '2023-04-30 12:10:58'),
(8, 'about', 'Smart Masheda provides first-class feeds for fish . Smart Masheda is positioned as a leading developer of nutrients in Egypt.', '2023-04-19 14:17:31', '2023-05-10 09:31:18'),
(9, 'footer_logo', 'setting/footer_logo.png', '2023-05-10 12:24:57', '2023-05-10 09:31:18');

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

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

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` text NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `link_title` varchar(255) NOT NULL,
  `link` text NOT NULL,
  `order` tinyint(4) 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 `sliders`
--

INSERT INTO `sliders` (`id`, `image`, `title`, `description`, `link_title`, `link`, `order`, `created_at`, `updated_at`) VALUES
(1, 'slides/1681735297.jpg', 'Smart Masheda', 'Leading manufacturer of high quality fish feeds in the African continent specially formulated with advanced technology to provide a broad spectrum of nutrients needed from Fry to Adult.', 'explore more', 'https://smartmasheda.com/page/about-us', 1, '2023-04-17 10:41:37', '2023-05-08 07:20:06'),
(3, 'slides/1681737487.jpg', 'High quality fish feed for Aquafarming', 'We improve pisciculture sustainability by boosting the efficiency of feed production and conversion to lessen environmental impact and preserve natural assets.', 'read more', 'https://smartmasheda.com/page/research', 3, '2023-04-17 11:18:08', '2023-05-08 07:19:38'),
(4, 'slides/1681737759.jpg', 'Heighten Farms Income', 'We help uplift fish growth performance and maximize livestock productivity.', 'see more', 'https://smartmasheda.com/page/products', 2, '2023-04-17 11:22:41', '2023-05-08 07:20:49');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity_log`
--
ALTER TABLE `activity_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subject` (`subject_type`,`subject_id`),
  ADD KEY `causer` (`causer_type`,`causer_id`),
  ADD KEY `activity_log_log_name_index` (`log_name`);

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `fishes`
--
ALTER TABLE `fishes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `fishes_name_unique` (`name`),
  ADD KEY `fishes_fish_type_id_foreign` (`fish_type_id`);

--
-- Indexes for table `fish_types`
--
ALTER TABLE `fish_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `fish_types_name_unique` (`name`);

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

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pages_name_unique` (`name`);

--
-- Indexes for table `parteners`
--
ALTER TABLE `parteners`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `parteners_name_unique` (`name`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `products_name_unique` (`name`),
  ADD KEY `products_fish_type_id_foreign` (`fish_type_id`);

--
-- Indexes for table `sections`
--
ALTER TABLE `sections`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sections_page_id_foreign` (`page_id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_name_unique` (`name`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_log`
--
ALTER TABLE `activity_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=145;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

--
-- AUTO_INCREMENT for table `fishes`
--
ALTER TABLE `fishes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `fish_types`
--
ALTER TABLE `fish_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `parteners`
--
ALTER TABLE `parteners`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `sections`
--
ALTER TABLE `sections`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `fishes`
--
ALTER TABLE `fishes`
  ADD CONSTRAINT `fishes_fish_type_id_foreign` FOREIGN KEY (`fish_type_id`) REFERENCES `fish_types` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_fish_type_id_foreign` FOREIGN KEY (`fish_type_id`) REFERENCES `fish_types` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sections`
--
ALTER TABLE `sections`
  ADD CONSTRAINT `sections_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE;
COMMIT;

