D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
backup2
/
cpbackup
/
seed
/
technoi4
/
mysql
/
Filename :
technoi4_webdemo.sql
back
Copy
-- MySQL dump 10.13 Distrib 5.7.23-23, for Linux (x86_64) -- -- Host: localhost Database: technoi4_webdemo -- ------------------------------------------------------ -- Server version 5.7.23-23 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!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 */; /*!50717 SELECT COUNT(*) INTO @rocksdb_has_p_s_session_variables FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'performance_schema' AND TABLE_NAME = 'session_variables' */; /*!50717 SET @rocksdb_get_is_supported = IF (@rocksdb_has_p_s_session_variables, 'SELECT COUNT(*) INTO @rocksdb_is_supported FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'rocksdb_bulk_load\'', 'SELECT 0') */; /*!50717 PREPARE s FROM @rocksdb_get_is_supported */; /*!50717 EXECUTE s */; /*!50717 DEALLOCATE PREPARE s */; /*!50717 SET @rocksdb_enable_bulk_load = IF (@rocksdb_is_supported, 'SET SESSION rocksdb_bulk_load = 1', 'SET @rocksdb_dummy_bulk_load = 0') */; /*!50717 PREPARE s FROM @rocksdb_enable_bulk_load */; /*!50717 EXECUTE s */; /*!50717 DEALLOCATE PREPARE s */; -- -- Current Database: `technoi4_webdemo` -- -- -- Table structure for table `brand` -- DROP TABLE IF EXISTS `brand`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `brand` ( `id` int(11) NOT NULL AUTO_INCREMENT, `brand_name` varchar(255) NOT NULL, `cid` varchar(255) NOT NULL, `brand_desc` text NOT NULL, `image` varchar(255) NOT NULL, `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `is_deleted` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `brand` -- LOCK TABLES `brand` WRITE; /*!40000 ALTER TABLE `brand` DISABLE KEYS */; INSERT INTO `brand` (`id`, `brand_name`, `cid`, `brand_desc`, `image`, `created_on`, `is_deleted`) VALUES (1,'Polymelt Germany','1','<p>PP-R Pipe System for Hot & Potable Water</p>','Polymelt Logo.jpg','2023-05-16 08:33:09',0),(2,'PoloKAL NG, Austria','4','<p>Pipe System for Domestic Drains & Sewers</p>','SAN58933000000-300x400.jpg','2023-05-16 08:33:27',0),(3,'Euro Standard,Italy','5','<p>Polyethylene Fittings for the Construction of Fuel gas, Water and Fire-Fighting Systems</p>','SAN1725700T000-300x400.jpg','2023-05-16 08:33:45',0),(4,'Pegler Yorkshire,UK','6','<p>For use in Water Heating Applications</p>','SAN9072100T000-300x400.jpg','2023-05-16 08:34:06',0),(5,'Polypipe Terrain , UK','7','<p>UPVC Drainage System</p>','SAN95728000000-300x400.jpg','2023-05-16 08:33:09',0),(6,'Bailey Products, UK','8','<p>Drain Cleaning Rods and Tools </p>','SAN58933000000-300x400.jpg','2023-05-16 08:33:27',0),(10,'Norm,Turkey','9','<p>Pipe Clamps and Fixing Elements</p>','','2023-05-23 11:12:03',0),(11,'Precision Plumbing Products,USA','10','<p>PPP Water Hammer Arrestor</p>','','2023-06-03 08:03:06',0),(12,'Industrias, Mateu- Spain','11','<p>Stainless Steel Braided Connectors</p>','','2023-06-03 08:03:59',0),(13,'Flowflex Components LTD-UK','12','<p>Applications in the Plumbing & Heating Industry</p>','','2023-06-03 08:04:19',0),(14,'Polymelt Germany','2','<p>PP-R Pipe System For Outdoor Applications</p>','Polymelt Logo.jpg','2023-05-16 08:33:09',0),(16,'Polymelt Germany','3','<p>PP-R Pipe System for HVAC Applications</p>','','2023-06-14 11:21:14',0); /*!40000 ALTER TABLE `brand` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `categary` -- DROP TABLE IF EXISTS `categary`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `categary` ( `id` int(11) NOT NULL AUTO_INCREMENT, `categary_title` varchar(255) NOT NULL, `desc` text NOT NULL, `image` varchar(255) NOT NULL, `createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `is_deleted` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `categary` -- LOCK TABLES `categary` WRITE; /*!40000 ALTER TABLE `categary` DISABLE KEYS */; INSERT INTO `categary` (`id`, `categary_title`, `desc`, `image`, `createdon`, `is_deleted`) VALUES (1,'PPR Pipe System','<p>PPR Pipe System for Hot & Potable Water </p>','Ecosan-800x800.png','2023-05-16 07:43:15',0),(2,'UV Resistant Piping System','<p>PP-R Pipe System For Outdoor Applications</p>','UV_Polymelt-800x800.png','2023-05-16 07:43:40',0),(3,'Mechanical PPR Pipe System','<p>PP-R Pipe System for HVAC Applications</p>','Klima_Mechanical_Polymelt-800x800.png','2023-05-16 07:44:12',0),(4,'Sound Insulated Pipe','<p>Pipe System for Domestic Drains & Sewers</p>','csm_Anwendungsuebersicht_POLO-KAL_NG_2_41baacfe2f.jpg','2023-05-16 07:44:48',0),(5,'HDPE PE 100 FITTINGS','<p>Polyethylene Fittings for the Construction of Fuel Gas, Water and Fire-Fighting Systems</p>','','2023-05-16 07:43:15',0),(6,'Plumbing Valves & Fittings','<p>For use in Water Heating Applications</p>','444.png','2023-05-16 07:43:40',0),(7,' UPVC Drainage Pipes & Fittings','<p>UPVC Drainage System</p>','','2023-05-16 07:44:12',0),(8,'Drain Test Plugs','<p>Drain Cleaning Rods and Tools </p>','1.png','2023-05-16 07:44:48',0),(9,'Pipe Hangers Support','<p>Pipe Clamps and Fixing Elements</p>','','2023-06-03 07:51:06',0),(10,'Water Hammer Arrestor','<p>PPP Water Hammer Arrestor</p>','','2023-06-03 07:51:22',0),(11,'Flexible Hose','<p>Stainless Steel Braided Connectors</p>','','2023-06-03 07:51:40',0),(12,' Compression & Pex Pipes Fittings','<p>Applications in the Plumbing & Heating Industry</p>','','2023-06-03 07:51:53',0); /*!40000 ALTER TABLE `categary` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `image` -- DROP TABLE IF EXISTS `image`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `image` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `user_name` varchar(255) NOT NULL, `mobile` varchar(255) NOT NULL, `image` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `image` -- LOCK TABLES `image` WRITE; /*!40000 ALTER TABLE `image` DISABLE KEYS */; /*!40000 ALTER TABLE `image` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `media` -- DROP TABLE IF EXISTS `media`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `media` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `media_name` varchar(255) NOT NULL, `media_desc` varchar(160) NOT NULL, `image` varchar(255) NOT NULL, `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `is_deleted` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `media` -- LOCK TABLES `media` WRITE; /*!40000 ALTER TABLE `media` DISABLE KEYS */; INSERT INTO `media` (`id`, `media_name`, `media_desc`, `image`, `created_on`, `is_deleted`) VALUES (5,'News/Events','<p> </p>','TGT logo.jpg','2023-07-01 12:01:47',0),(6,'Careers','<p> </p>','TGT logo.jpg','2023-07-01 12:02:19',0); /*!40000 ALTER TABLE `media` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pdf_image` -- DROP TABLE IF EXISTS `pdf_image`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pdf_image` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(11) NOT NULL, `image` varchar(255) NOT NULL, `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `is_deleted` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pdf_image` -- LOCK TABLES `pdf_image` WRITE; /*!40000 ALTER TABLE `pdf_image` DISABLE KEYS */; INSERT INTO `pdf_image` (`id`, `pid`, `image`, `created_on`, `is_deleted`) VALUES (12,13,'ECOSAN Technical Manual.pdf','2023-06-14 13:01:12',0),(13,14,'ECOSAN Technical Manual.pdf','2023-06-14 13:01:23',0),(14,15,'MECHANICAL Technical Manual.pdf','2023-06-14 13:03:47',0),(19,22,'Bailey Products Catalogue.pdf','2023-06-14 13:05:54',0),(20,24,'PPP Product Catalogue.pdf','2023-06-14 13:08:14',0),(28,20,'Pegler Technical Product Catalogue.pdf','2023-06-15 08:23:31',0),(29,23,'Norm Product Catalogue.pdf','2023-06-15 08:23:31',0),(30,26,'Flowflex Product Catalogue.pdf','2023-06-15 08:33:49',0),(36,18,'POLO KAL Catalogue1.pdf','2023-06-15 10:31:03',0),(37,19,'TECHNICAL DATA EUROSTANDARD1.pdf','2023-06-15 10:37:12',0),(38,21,'Terrain Above Ground Catalogue.pdf','2023-06-15 10:40:14',0),(39,21,'Terrain Under Ground Catalogue.pdf','2023-06-15 10:41:15',0),(40,25,'Flexible Hose Filnox Catalogue.pdf','2023-06-15 10:43:09',0); /*!40000 ALTER TABLE `pdf_image` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product` -- DROP TABLE IF EXISTS `product`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `product` ( `pid` int(11) NOT NULL AUTO_INCREMENT, `cid` int(11) NOT NULL, `bid` int(11) NOT NULL, `product_name` varchar(255) NOT NULL, `product_desc` text NOT NULL, `image` varchar(255) NOT NULL, `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `is_deleted` tinyint(1) NOT NULL, PRIMARY KEY (`pid`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product` -- LOCK TABLES `product` WRITE; /*!40000 ALTER TABLE `product` DISABLE KEYS */; INSERT INTO `product` (`pid`, `cid`, `bid`, `product_name`, `product_desc`, `image`, `created_on`, `is_deleted`) VALUES (13,1,1,'ECOSAN ML5 PPR','<p><strong>POLYMELT ECOSAN: PP-R Pipe System for Hot and Potable Water with Easy Installation</strong></p><p>ECOSAN presents a versatile solution for supply lines in new constructions, renovations, or repairs, ensuring top-notch performance without any losses or leakage. This innovative installation system caters to a wide range of requirements, serving residential buildings, hospitals, hotels, office buildings, and schools with exceptional potable water installations, as well as cold and hot water pipes for various applications. Developed by POLYMELT, the ECOSAN piping system combines unrivaled quality, effortless installation, and long-lasting functionality.</p><p><strong>Key Features of the ECOSAN PP-R Piping System:</strong></p><p>- <strong>Unmatched Durability:</strong> ECOSAN pipes are designed to withstand the test of time, delivering decades of reliable performance without any degradation or leaks.</p><p>- <strong>Homogeneous Connection: </strong>The installation system ensures a seamless and uniform connection, promoting optimal flow and preventing any weak points.</p><p>- <strong>Hygiene Excellence:</strong> ECOSAN meets high standards for hygiene, making it ideal for applications where cleanliness is paramount.</p><p>- <strong>Excellent Thermal Load Capacity</strong>: With great thermal load capacity, ECOSAN pipes can withstand temperature variations, ensuring reliable operation in various conditions.</p><p>- <strong>Superior Chemical Resistance:</strong> The piping system exhibits high resistance to chemicals, making it suitable for transporting aggressive media such as acids and alkaline solutions.</p><p>- <strong>Reduced Flow Noise:</strong> ECOSAN pipes minimize flow noise, creating a quieter and more comfortable environment.</p><p>- <strong>Precise Dimensional Accuracy:</strong> The system boasts dimensional accuracy, ensuring a precise fit and facilitating hassle-free installation.</p><p>The Ultimate Choice for Hot and Cold Potable Water: ECOSAN, crafted from premium-grade polypropylene, and ECOSAN ML5, composed of multilayer fibre-reinforced composite pipes, guarantee a dependable, long-lasting supply in a multitude of installation systems.</p><p>These pipes find applications in compressed air systems, agriculture, horticulture, industries requiring transportation of aggressive media, heating installations, shipbuilding, and more.</p><p><strong>Additionally, the POLYMELT ECOSAN piping system is suitable for:</strong></p><p>- Cold water</p><p>- Hot water</p><p>- Compressed air</p><p>- Potable water</p><p>Experience the excellence of ECOSAN piping system—reliable, durable, and flawless supply for all your installation needs.</p>','Polymelt_Produkt_Econsan_Trinkwasser.png','2023-06-03 12:40:09',0),(14,2,1,'PPR UV','<p><strong>POLYMELT UV: PP-R Pipe System for Outdoor Applications</strong></p><p>Discover our range of UV resistant pipe systems specially designed to excel in outdoor environments. At POLYMELT, we recognize the challenges posed by UV radiation to plastic piping systems, which can impact their durability and lifespan. However, with our UV resistant PPR pipes, you can have peace of mind knowing that your outdoor piping system is built to endure. Our advanced and robust polypropylene (PP-R) piping solution has undergone rigorous testing under the most demanding conditions to ensure exceptional resistance to UV radiation.</p><p><strong>Key Features:</strong></p><p>- <strong>Built to Last Under Sunlight Exposure:</strong> Our UV resistant PPR pipes and fittings are engineered to withstand continuous exposure to sunlight without rusting, calcifying, corroding, or crumbling over time. With decades of virtually maintenance-free usage guaranteed, investing in our UV resistant PPR pipes is a wise choice for any outdoor piping system.</p><p>- <strong>UV-Resistant: </strong>Our pipes offer superior UV resistance, ensuring long-term performance and protection against the harmful effects of sunlight.</p><p>- <strong>Corrosion-Free:</strong> In addition to UV resistance, our PPR pipes are corrosion-free, providing enhanced durability and longevity.</p><p>- <strong>Increased Flow Rate: </strong>By utilizing our PPR pipes, you can experience improved flow rates, optimizing the efficiency of your outdoor piping system.</p><p>- <strong>Easy Installation:</strong> Our UV resistant PPR pipes are designed for effortless installation, saving you time and effort during the setup process.</p><p><strong>THE IDEAL UV-RESISTANT PIPING SYSTEM</strong></p><p><strong>Versatility meets reliability.</strong></p><p>In addition to their UV resistance, our PPR pipes offer numerous advantages. They are corrosion-free, enhancing flow rates and facilitating easy installation. Polymelt\'s UV resistant PPR pipes are the perfect solution for hot and cold water distribution in residential, industrial, and commercial buildings, as well as irrigation systems.</p><p>With a wide array of accessories and options available, our UV resistant PPR pipes are tailored for systems exposed to the elements. Each installation ensures secure connections, delivering years of dependable, virtually maintenance-free service.</p><p><strong>The POLYMELT UV piping system is suitable for:</strong></p><p>- Cold water</p><p>- Hot water</p><p>- Compressed air</p><p>- Cooling</p><p>- UV resistant</p><p>- Potable water</p><p> </p>','Polymelt_Produkt_UV_Trinkwasser.png','2023-06-03 12:41:29',0),(15,3,1,'Polo Klima','<p><strong>MECHANICAL: PP-R Pipe System for HVAC Applications</strong></p><p>The MECHANICAL PP-R piping system is designed to meet the demands of water conveyance in enclosed cooling water systems. Ideal for residential and commercial buildings, including hotels and shopping centers, as well as industrial buildings requiring technological cooling, this non-corroding pipe system offers reliability and longevity.</p><p><strong>GERMAN-ENGINEERED PIPING SYSTEMS. THE FUTURE OF HVAC ENGINEERING FROM POLYMELT.</strong></p><p><strong>Key Features:</strong></p><p>- <strong>Zero Metallic Corrosion: </strong>With the MECHANICAL PP-R pipe system, you can bid farewell to worries of metallic corrosion, ensuring a durable and efficient solution for your HVAC applications.</p><p>- <strong>Cost-effective Solution: </strong>Superior materials and design result in reduced construction and operation costs, providing affordability without compromising quality.</p><p>- <strong>Faster Installation: </strong>Our fusion technology and prefabrication modularity enable significantly faster installation times, optimizing efficiency.</p><p>- <strong>Easier Installation: </strong>With a weight 80% lighter than steel, our pipes reduce strain and require fewer equipment, simplifying the installation process.</p><p>- <strong>Long-lasting Performance: </strong>Our purpose-engineered polypropylene ensures long-term performance, surpassing other materials in longevity.</p><p>- <strong>Virtually Leak-free: </strong>Decades of research and development have yielded the industry\'s most reliable pipes and heat-fusion joints, minimizing the risk of leaks.</p><p>- <strong>Supports Sustainability: </strong>The corrosion- and scale-resistant nature of our PP-R piping ensures a lifetime of improved energy efficiency without the need for corrosion protection.</p><p><strong>The versatile POLYMELT Mechanical piping system is designed to cater to various applications, including but not limited to:</strong></p><p><strong>Cold water distribution:</strong> Whether it\'s for residential, commercial, or industrial purposes, the POLYMELT Mechanical piping system is an excellent choice for efficiently transporting cold water.</p><p><strong>Hot water supply</strong>: For establishments requiring a reliable and robust piping solution for hot water circulation, the POLYMELT Mechanical piping system offers optimal performance and durability.</p><p><strong>Compressed air distribution</strong>: When it comes to conveying compressed air for industrial processes, the POLYMELT Mechanical piping system ensures a seamless and efficient airflow.</p><p><strong>Cooling applications:</strong> From cooling systems in buildings to industrial cooling processes, the POLYMELT Mechanical piping system provides a dependable infrastructure for circulating and distributing chilled fluids.</p><p><strong>Heating systems:</strong> The POLYMELT Mechanical piping system is well-suited for heating applications, delivering heat transfer efficiency and reliability for both residential and commercial heating systems.</p><p>With its adaptability and reliability, the POLYMELT Mechanical piping system is a versatile solution for a wide range of applications, ensuring optimal performance and longevity.</p><p> </p>','Bilder_fuer_Video_1280x720px_Klima Floeten.jpg','2023-06-03 12:41:57',0),(18,4,2,'POLO KAL','<p><strong>The POLO-KAL NG Pipe System for Domestic Drains & Sewers: Staying Clean When It Gets Dirty</strong></p><p>POLO-KAL NG, designed specifically for fast, cost-effective, and optimized installation of domestic drains and sewers. Whether it\'s for single-family homes, multi-family residences, or multi-storey commercial and industrial buildings, this pipe system delivers exceptional performance. It ensures easy installation, absolute safety, and reliable functionality. With multiple layers of robust polypropylene, it offers excellent sound insulation, minimal linear expansion, and high ring stiffness. The proven sealing system of POLYMELT pipes keeps the wastewater system permanently tight, ensuring that dirty water stays where it belongs. Additionally, these pipes and fittings are highly impact-resistant, even in cold weather conditions.</p><p><strong>Key Features:</strong></p><p>- <strong>Push-fit Connection:</strong> The POLO-KAL NG piping system utilizes a simple push-fit connection method, facilitating fast and efficient assembly.</p><p>- <strong>Corrosion-free:</strong> With a corrosion-free design, these pipes provide long-lasting durability and reliability for domestic drains and sewers.</p><p>- <strong>Tight Connection:</strong> The POLYMELT system ensures a tight and secure connection, preventing leaks and maintaining the integrity of the wastewater system.</p><p>- <strong>Easy Installation: </strong>The installation process is straightforward, requiring only a minimum number of tools and resulting in significant time savings.</p><p><strong>The Pipe System for Waste Water – Serving the Entire Building</strong></p><p><strong>Advantages of the POLO-KAL NG piping system for drains & sewers:</strong></p><p>- <strong>Fast Assembly:</strong> The simple push-fit system allows for quick assembly, reducing installation time and effort.</p><p>- <strong>Minimal Tool Requirements:</strong> With only a few tools needed, the installation process is streamlined and hassle-free.</p><p>- <strong>Safety and Leak-proof Connection: </strong>The system ensures safety during assembly and provides a permanently leak-proof connection, minimizing the risk of issues in the future.</p><p>- <strong>Noise-Insulating: </strong>The multilayer technology with optimized plastic compositions offers effective noise insulation, contributing to a more peaceful environment.</p><p>- <strong>Compatibility: </strong>The POLO-KAL NG piping system is compatible across various systems, providing flexibility and convenience.</p><p>- <strong>Environmentally Friendly:</strong> This system is free of PVC and halogens, making it an environmentally conscious choice.</p><p>Discover the reliability and performance of the POLYMELT POLO-KAL NG piping system for domestic drains and sewer needs. This advanced system efficiently handles gravity black and grey water, kitchen and grease waste water, as well as vent pipes and rainwater. With its durable design and innovative materials, it ensures smooth flow and prevents clogs. Experience hassle-free wastewater management with POLYMELT and trust in its proven effectiveness. Upgrade your drainage system today and enjoy the benefits of this reliable solution.</p>','Polymelt_Produkt_KAL_NG_Abwasser-1.png','2023-06-06 07:36:21',0),(19,5,3,'EURO STANDARD ','<p>Polyethylene fittings</p><p>The polyethylene fittings of the EUROSTANDARD range are injection molded with PE 100 and PE 100-RC type resins suitable for use for pipe fittings in fuel gas, water and pressurized fluid transport networks. The characteristics comply with the <a href=\"https://www.eurostandard.it/certificazioni/\">UNI EN 1555</a> , <a href=\"https://www.eurostandard.it/certificazioni/\">UNI EN 12201</a> and <a href=\"https://www.eurostandard.it/certificazioni/\">UNI EN ISO 15494</a> standards . The resins used, originally added with carbon black to give stabilization to UV rays, are suitable for contact with drinking water and foodstuffs pursuant to the Ministerial Decree of 21 March 1973 and Ministerial Decree n. 174 dated 6 April 2004. EUROSTANDARD fittings can be welded with PE100 and PE80 pipes and fittings having a fluidity index of 0.2 – 1.4 g/10 min (ISO 1133-1 5 kg / 190 °C).</p>','004_transition_square.jpg','2023-06-06 07:39:34',0),(20,6,4,'PEGLER YORKSHIRE','<p>VALVES & FITTINGS</p><p>Established in 1899, <strong>Pegler</strong> is respected the world over as one of the leading manufacturers of plumbing and heating products. <strong>Pegler Quality:</strong></p><ul><li>Pegler valves and fittings are renowned for their quality, design, reliability and overall value for money.</li><li>Robust construction under the most stringent quality control conditions assures a long working life.</li><li>Pegler investment in advanced manufacturing techniques has achieved BS EN ISO 9001:2000 Quality Assurance accreditation.</li><li>Where appropriate, Pegler products comply with kite mark British Standards or the European norm.</li><li><strong>Product range includes:</strong></li><li>Pegler fluid control solutions meet all the requirements of water regulations and include both single and double check valves for controlling the direction of water flow.</li><li>For isolating pipes, Pegler gives you the option of compact ball operated isolating valves or, for heavier applications, gate valves. Where regulation as well as isolation flow is required, use stop valves for in-line control and bib taps for terminal control.</li><li>An extensive range of Pegler float valves gives water level control at high and low pressures.</li></ul>','444.png','2023-06-06 07:42:20',0),(21,7,5,'TERRAIN','<p>UPVC DRAINAGE SYSTEMS</p><p><strong>Terrain</strong> heritage in the Gulf stretches back over 50 years. Terrain has been proudly associated with Bin Moosa & Daly for over 40 years during which time they have collaborated on many prestigious developments in the UAE. Terrain systems are fully accredited and manufactured to relevant British Standards, whilst also bearing Kitemark approval. </p><p><strong>Key Benefits are:</strong></p><ul><li>Wide range of solvent and push-fit soil and waste solutions</li><li>Unrivalled installation options to match any project</li><li>Quick and easy installation</li><li>Light weight and easy to handle</li><li>High quality finish and colour to match all systems</li><li>Suitable for all types of commercial, high rise residential, domestic, industrial and public sector installations</li><li>Extensive technical experience to support and advise on all aspects of design and installation</li></ul>','Terrain.jpg','2023-06-06 07:44:10',0),(22,8,6,'BAILEY','<p><strong>Bailey </strong>has been producing quality products since 1940 with an extensive range of Drain cleaning rods and tools, along with drain stopping and testing equipment. Bailey Rods are covered by international trademarks and are renowned worldwide for quality and durability. Manufacturing is carried out within recognized standard ISO 9001 and with strong commitment to improving products and services continuously.</p><p><strong>The Products Range Includes:</strong></p><ul><li>Cleaning Rods – Drain Rod Tools, Accessories for rods, Cleaning rod sets, cleaning brushes, Sewer cleaning Rods and Tools</li><li>Drain Testing – Drain Testing plugs & equipment (Central Locking & Rim Fast)</li><li>Ducting Rodding – Duct Rodding Equipment</li></ul>','drain-plug-group-2.jpg','2023-06-06 07:46:40',0),(23,9,10,'NORM','<p><strong>Pipe Hanger Support</strong></p><p>NORM Fixing (NORM BaÄŸlantı) steadily has invested in its man power and production facilities since starting its manufacturing of high-quality pipe clamps, fixing, and hanging elements in 2005. Not only having extended our range of products, we also increased product quality and performance on highest levels.</p><p>Obeying the rules and directives of FM, UL, ISO 9001:2008, TSEK, TUV and GOST, our whole manufacturing process, is focused on total quality management, ensuring the use of high-quality raw materials, the production of premium quality products and customer service.</p><p>NORM Fixing’s standard product program primarily includes pipe clamps, anchors, threaded rods, hanging accessories (U-, L-, C-type channels) and other fixing elements like U-bolts and beam clamps, additionally developing and producing customer tailored fixing solutions.</p><p>NORM’s highly motivated and well trained man power is focused on preserving high quality standards and “on time†delivery. Our product line is sold via a strong wholesaler network in Turkey. For our abroad markets, we rely on our distributors, helping us to supply our products to end customers world-wide.</p>','Screenshot 2023-06-20 162001.jpg','2023-06-06 07:46:56',0),(24,10,11,'PPP-USA','<p><strong>Water Hammer Arrestor</strong></p><p>At Precision Plumbing Products, we are committed to providing the plumbing community with durable parts and exceptional service. We maintain a long tradition of growth through product expansion, customer loyalty and long-standing relationships.</p><p>You can count on PPP’s experienced and educated team to deliver premium results. In Portland, OR, we control every step of the manufacturing process at our ISO 9001 and ISO 14001 certified facilities; from conception to design and delivery. This allows for the highest standards in quality management.</p>','PPP-Arrestors.jpg','2023-06-06 07:47:10',0),(25,11,12,'FILNOX-MATEU','<p><strong>FLEXIBLE HOSE</strong></p><p>Since 1982, when we began to manufacture flexible connectors, INDUSTRIAS MATEU has been concerned with perfecting its production processes and implanting its own technology. To this end, it has established all the appropriate quality controls required in our activity.</p><p>For this reason, in 1992, INDUSTRIAS MATEU succeeded in being the first Spanish flexible connector manufacturer to obtain the mark thanks to our constant concern for maximum quality.</p><p>From here on, the development of the company at both national and international level enters a new era, and has equipped itself with the most professional research and control media to respond to the demands of a market that is more and more competitive and demanding.</p>','61RWio46cEL._AC_UF894,1000_QL80_.jpg','2023-06-06 07:47:23',0),(26,12,13,'FLOWFLEX - UK','<p>The UK\'s Leading Brass Fittings Manufacturer</p><p>Manufactured in the UK, to the highest standards, our complete range of Flowflex Compression Fittings include PEX fittings and Large bronze flanged Compression Fittings. Our flagship range, it provides the reliability and quality demanded by today’s professional installers and consultants.</p><p>Since 1954, we have been designing and manufacturing compression fittings to answer the needs of the market, continually improving and innovating to bolster and improve our offering. Our range covers sizes from 8mm to 108mm and are guaranteed against manufacturing defects for 25 years.</p>','block_compression_2_73460b613e.jpg','2023-06-06 07:47:38',0); /*!40000 ALTER TABLE `product` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_image` -- DROP TABLE IF EXISTS `product_image`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `product_image` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(11) NOT NULL, `image` varchar(255) NOT NULL, `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `is_deleted` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_image` -- LOCK TABLES `product_image` WRITE; /*!40000 ALTER TABLE `product_image` DISABLE KEYS */; INSERT INTO `product_image` (`id`, `pid`, `image`, `created_on`, `is_deleted`) VALUES (14,22,'bailey-logo.jpg','2023-06-14 13:35:22',0),(15,22,'rim-fastening-drain-test-plugs.jpg','2023-06-14 13:38:10',0),(16,22,'test-plug-brass-wingnut.jpg','2023-06-14 13:38:10',0),(17,22,'test-plug-double-steel-wingnut.jpg','2023-06-14 13:38:11',0),(18,19,'EURO STANDARD LOGO.png','2023-06-14 13:39:23',0),(19,21,'Terrain logo.png','2023-06-14 13:42:25',0),(20,23,'Norm-Logo.jpg','2023-06-14 13:42:40',0),(21,20,'Pegler- Logo.png','2023-06-14 13:43:00',0),(22,24,'logo.jpg','2023-06-14 13:43:16',0),(23,25,'Mateu Logo.gif','2023-06-14 13:43:30',0),(24,26,'Flowflex Logo.JPG','2023-06-14 13:43:42',0),(27,13,'Ecosan-800x800.png','2023-06-15 03:23:40',0),(30,13,'Polymelt_ECOSAN_.png','2023-06-15 03:23:41',0),(31,13,'Logo_Polymelt_Final.jpg','2023-06-15 09:15:58',0),(32,14,'Logo_Polymelt_Final.jpg','2023-06-17 08:14:55',0),(34,15,'Logo_Polymelt_Final.jpg','2023-06-17 08:17:06',0); /*!40000 ALTER TABLE `product_image` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `project` -- DROP TABLE IF EXISTS `project`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `project` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `desc` varchar(160) NOT NULL, `image` varchar(255) NOT NULL, `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `is_deleted` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `project` -- LOCK TABLES `project` WRITE; /*!40000 ALTER TABLE `project` DISABLE KEYS */; INSERT INTO `project` (`id`, `name`, `desc`, `image`, `created_on`, `is_deleted`) VALUES (1,'GEWAN ISLAND HOTEL+BEACH CLUB','<p> </p>','corinthia_hotel_doha_900x600.jpeg','2023-05-30 10:53:55',0),(2,'79 VILLAS COMPLEX +CLUB HOUSE+ANCILLARY BUILDING','<p> </p>','image 1.jpeg','2023-05-30 10:54:55',0),(3,'NBK SQUARE COMMERCIAL','<p> </p>','NBK square.jpg','2023-05-30 10:53:55',0),(4,'THE GARDEN 133 VILLAS- Al THUMAMA, QATAR','<p> </p>','LQ_The_Garden_Villas_Al_Thumama_12_dfcd85f863.jpg','2023-05-30 10:54:55',0),(5,'RESIDENTIAL BUILDING @ LUSAIL (B+G+4) 18 BUILDING','<p> </p>','Image 1.jpeg','2023-05-30 10:53:55',0); /*!40000 ALTER TABLE `project` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `service` -- DROP TABLE IF EXISTS `service`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `service` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `service_name` varchar(255) NOT NULL, `service_desc` text NOT NULL, `image` varchar(255) NOT NULL, `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `is_deleted` tinyint(1) NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `service` -- LOCK TABLES `service` WRITE; /*!40000 ALTER TABLE `service` DISABLE KEYS */; INSERT INTO `service` (`id`, `service_name`, `service_desc`, `image`, `created_on`, `is_deleted`) VALUES (3,'HDPE PIPE FABRICATION','<p> </p>','20220804042307803.jpg','2023-05-11 03:47:40',0),(4,'HDPE & PVC FABRICATED FITTINGS','<p> </p>','page 20.jpg','2023-05-11 03:47:40',0),(5,'HDPE WELDING MACHINE SERVICES ','<p> </p>','P_Tiny_640-2-640x640.jpg','2023-05-11 03:47:40',0),(6,'EPDM RUBBER GASKETS','<p> </p>','WhatsApp Image 2022-10-29 at 14.32.49.jpeg','2023-05-11 03:47:40',0); /*!40000 ALTER TABLE `service` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user` -- DROP TABLE IF EXISTS `user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user` ( `u_id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `mobile_no` varchar(255) NOT NULL, `address` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verification_link` varchar(255) NOT NULL, `email_verified_at` datetime DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `reset_link_token` varchar(255) DEFAULT NULL, `exp_date` datetime DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `profile_image` varchar(255) DEFAULT NULL, `user_type` int(11) NOT NULL COMMENT 'admin-0,user-1', `status` tinyint(1) DEFAULT NULL COMMENT 'active-1,inactive-2', PRIMARY KEY (`u_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user` -- LOCK TABLES `user` WRITE; /*!40000 ALTER TABLE `user` DISABLE KEYS */; INSERT INTO `user` (`u_id`, `first_name`, `last_name`, `country`, `mobile_no`, `address`, `email`, `email_verification_link`, `email_verified_at`, `password`, `reset_link_token`, `exp_date`, `image`, `profile_image`, `user_type`, `status`) VALUES (1,'Admin','Admin','United Kingdom','+44 7361625706','Kemp House 160 City Road London - United Kingdom EC1V 2NX','admin@admin.com','',NULL,'Pass1w0rd123$',NULL,NULL,NULL,'himalayan_broking.jpg',0,1); /*!40000 ALTER TABLE `user` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'technoi4_webdemo' -- -- -- Dumping routines for database 'technoi4_webdemo' -- /*!50112 SET @disable_bulk_load = IF (@is_rocksdb_supported, 'SET SESSION rocksdb_bulk_load = @old_rocksdb_bulk_load', 'SET @dummy_rocksdb_bulk_load = 0') */; /*!50112 PREPARE s FROM @disable_bulk_load */; /*!50112 EXECUTE s */; /*!50112 DEALLOCATE PREPARE s */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2025-06-13 1:40:34