-- phpMyAdmin SQL Dump -- version 5.2.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Nov 08, 2026 at 02:30 AM -- Server version: 5.7.44 -- PHP Version: 8.1.34 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; -- -- Database: `resalahp_petrotechlb` -- -- -------------------------------------------------------- -- -- Table structure for table `aboutus` -- CREATE TABLE `aboutus` ( `id` int(11) NOT NULL, `description` text NOT NULL, `conclusion` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `aboutus` -- INSERT INTO `aboutus` (`id`, `description`, `conclusion`) VALUES (2, 'Petrotechlb Company - Petrotech is a partnership working in the field of fuel products and its equipment supply, engineering studies, design, construction, maintenance & operation.\r\nWe have the expertise and the qualified personnel to design and implement fuel storage tanks and stations turn-key, and supervise such kind of work so that our staff covers the design, implementation, modification and modernization of stations, supervising the implementation of the stations, all in accordance with international standards such as ASME, API, EI, APEA to ensure that the rules of the storage tanks and fuel stations are followed and the quality of implementation is determined according to international standards.\r\nWe have the specialized staff for maintenance work covering all governorates of the country that has sufficient experience to deal with all the equipment we supply and adopt.\r\nWe deal with a wide range of international companies known for their products of loading arms,drive pump, fuel pumps, submersible pumps, automation and tank level gage systems,flowmeters, smart card systems, accessories supply companies.', 'Our company is one of the specialized companies in the service sector of fuel storage tanks, stations and products. We have a specialized staff that performs the study, installation and maintenance work. It provides the customer with services from A to Z . We have support engineers of electricity, construction, automation and software works due to the variety of works covered by the company.'); -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE `category` ( `id` int(11) NOT NULL, `title` varchar(45) DEFAULT NULL, `type` enum('product','service','project') NOT NULL DEFAULT 'product' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `category` -- INSERT INTO `category` (`id`, `title`, `type`) VALUES (1, 'Fuel Stations', 'product'), (2, 'Fuel Storage Tanks', 'product'); -- -------------------------------------------------------- -- -- Table structure for table `certificate` -- CREATE TABLE `certificate` ( `id` int(11) NOT NULL, `icon` varchar(45) NOT NULL, `title` varchar(45) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ci_sessions` -- CREATE TABLE `ci_sessions` ( `id` varchar(128) NOT NULL, `ip_address` varchar(45) NOT NULL, `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0', `data` blob NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `ci_sessions` -- INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('172q0r9u2cqdtsjrc04q9lostcmv7hkm', '82.137.255.68', 1524392927, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339323634303b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('dkggtspm694l3gn73nol12pdk737iod8', '82.137.255.68', 1524393267, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339333038313b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('eabsdiv5rlri9rt9pahk6k6n5k2n7b3l', '82.137.255.68', 1524393828, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339333536333b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('8h5uclve5rlte88sslknvm2aq9ir7p3v', '82.137.255.68', 1524394538, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339343235373b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('gc99cva7l1mfj3o7hrbv5v0qf7rbugbf', '82.137.255.68', 1524394890, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339343630343b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('jd6ib7c8ibit97f2kdkapekrpmqqii7j', '82.137.255.68', 1524395322, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339353034393b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('a8501jddn3qmdh64oqve0nt2urpdc3b1', '82.137.255.68', 1524395690, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339353433363b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('v1nfg6b835adtrtq4qiep1mm8o7asnqm', '82.137.255.68', 1524396676, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339363438383b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('3oispscmo1rai4cupslnumfllc8lpvon', '82.137.255.68', 1524396865, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339363836353b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('l7800c6t54q61phhrkudnh8tn08pt65q', '82.137.255.68', 1524397363, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339373136363b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('sj925gs1ju4tqktv3306d8m5a23ratoe', '46.58.144.3', 1524397315, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339373331353b), ('kcr4ttfd8e78tbi153k02ia6uv42q8aj', '82.137.255.68', 1524397611, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339373437323b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('jts3kv0gopbiak7ipna2vt8fu5d3h9qu', '94.47.31.3', 1524397783, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339373630373b), ('cjc0siur74uho4ad1d6f1f5hvl8fe2jp', '94.47.31.3', 1524397632, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339373633323b), ('dajaa312oc0mtch3tlhurbkrcpqh0qq4', '82.137.255.68', 1524398122, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339373930373b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('adutbsn90n1v6df6ot7pmhc9q5ltj42a', '94.47.31.3', 1524398554, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339383535343b), ('3i4dnnkdkhmajrtop83rn5aac0k173en', '82.137.255.68', 1524399005, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339393030353b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('9n3mrdpu64idn4apr5t0k0qqlent0gcn', '94.47.31.3', 1524399260, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339393236303b), ('aifsoeh0okftpl2ar7vp7556u7q1qukh', '94.47.31.3', 1524399261, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339393236313b), ('jaqa0cvbp9l29tg403h7pqj0a6ptjcl0', '94.47.31.3', 1524399266, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339393236363b), ('ak7jso520kpmteg7ahkstb4h06p5cc02', '82.137.255.68', 1524399471, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339393437313b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('m0c8eoodcbjaef8gjtd55s9d99cedjfe', '82.137.255.68', 1524400041, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343339393839333b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('mqhm6i1np8e9ptrq2194mbpgf459d6gg', '82.137.255.68', 1524400715, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430303534353b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('56th36hsr5rr7bsslt3bpsf0ckp5a63k', '82.137.255.68', 1524401168, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430303937393b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('hdtrsqqt5emndp2njc6uf4dfm4s5ijuu', '82.137.255.68', 1524401393, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430313334313b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('hortrvtmiij9cn852ubn6031o4rencr9', '94.47.254.188', 1524401391, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430313339313b), ('7lfrcvol1b7sd2r5e9dmsenuidfo24cn', '94.47.254.188', 1524401823, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430313535353b), ('5trvlmo8d7f1cug8hb0f4rc8culfvq81', '82.137.255.68', 1524401834, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430313733383b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('127g4ki7iu2tilrjr786sushfg69e6j6', '94.47.254.188', 1524402041, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430313736363b), ('5mmrqqam09o168onm6qkn661qcs1gg08', '94.47.254.188', 1524402346, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430323039333b), ('ql8ejn1jiaetn87h4d5vqgdfesc6dpid', '94.47.254.188', 1524402113, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430323131333b), ('49soeg97pvvnnibmdi1krrp9471eo686', '94.47.254.188', 1524402641, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430323434303b), ('m0bu2nkq855c2dbidhk07le8nt5btmns', '94.47.254.188', 1524402666, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430323636363b), ('t7s42rsk0g6abmksv5aa5a4g7ssnui6f', '94.47.254.188', 1524403045, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430323735343b), ('j44ht8s3udtfn0fjq8pdjh7tpsv4hj24', '94.47.254.188', 1524403312, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430333132323b), ('h0g24dlffk6v2bhikn1l3fu652oupiiq', '94.47.254.188', 1524403977, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430333931373b), ('nkc0k5sm67ebn23g0j9ct59pf8vqolfr', '94.47.254.188', 1524404639, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430343630303b), ('mmb4v5u32bugk6eu0jfef2jl4lpget4f', '94.47.254.188', 1524404740, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430343637323b), ('723ss7fq7qff66s596gjhnf6b56m9l7t', '94.47.254.188', 1524406479, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430363434303b), ('l6ialhkkb8ocdv131q6ecsggeafo64pr', '94.47.254.188', 1524408011, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430373939333b), ('nute3c023rggigakvu7a599sj0f9fejf', '94.47.254.188', 1524408233, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430383232393b), ('iiev911akcu22gj4v96t6o8ola081o99', '94.47.254.188', 1524408336, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430383333363b), ('p1g7r20798ogbavadnqg3c28b421c5h8', '94.47.254.188', 1524409914, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343430393931343b), ('g263rifsa9180strefnj4kak2mbn8t62', '188.160.48.116', 1524410861, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431303630383b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('i1i33h22tclkpqd0hkih7dc6cq6f3ma8', '94.47.254.188', 1524410822, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431303734383b), ('6oqm8eisq9h66r2io14391v4iu8rcapq', '94.47.254.188', 1524410951, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431303935313b), ('9ruvsv7oi46iug1o17u4cumsmei7h8lh', '188.160.48.116', 1524411178, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431313137383b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('h2u58kjdcbv5r547vmaa8o4l15usuejf', '188.160.48.116', 1524411516, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431313531333b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('s9g22lgrq9sf55esj4pf6qodh7uah5l1', '188.160.48.116', 1524411822, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431313832323b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('58r8bj4s3jh2o6qu0mcqqm3gnlbvr2b7', '94.47.254.188', 1524411903, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431313834373b), ('4kjjfu8jqq8t30ngvklbc27bqbht43c5', '188.160.48.116', 1524412187, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431323138373b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('fkrnps1pmao86sh5mn92eo2okso0fudm', '94.47.254.188', 1524412646, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431323434333b), ('2n6mfgb0d062rubogrsbu8nqgmd3d4q0', '94.47.254.188', 1524413236, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431323936393b), ('un6ln50udv3ev3ag0sa9snffabkj9em7', '188.160.48.116', 1524413126, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431323937363b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('rml6lt0j5pa5cgmdptbnku5p5u4bbcp1', '94.47.254.188', 1524413646, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431333335333b), ('6o0nlm7i48hs4ftg67pa8gv44l307fri', '188.160.48.116', 1524413537, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431333439383b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('p12kv5ckoefj0pgkng4upvtreum337v1', '94.47.254.188', 1524413852, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431333635393b), ('f5be1avqjbrh4kalu97td1altrletm7l', '94.47.254.188', 1524413975, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431333638383b), ('il4b0hgsuadjkc10ipn8sph64i0apac3', '94.47.254.188', 1524414164, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431343034323b), ('945h84r3lab17phl5sbplqvcnskmq83s', '188.160.48.116', 1524414308, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431343231353b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('i8olsvfbon33r4kfsged9n4rc1feqo97', '94.47.254.188', 1524414673, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431343337383b), ('65g45184982fsge3tplh0hpv716ccjqi', '188.160.48.116', 1524414698, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431343532323b6c6f676765645f696e7c613a343a7b733a323a226964223b733a313a2231223b733a383a22757365726e616d65223b733a343a22656d6164223b733a343a22726f6c65223b733a353a2261646d696e223b733a353a2270686f746f223b733a383a22757365722e6a7067223b7d), ('s03obmnit7bl0dp894gmgh6ehkv9mqca', '94.47.254.188', 1524414684, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431343534363b), ('22k1bnltslu4pna9dt8uf19ov6hc2p5d', '94.47.254.188', 1524414853, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431343639363b), ('9tmq9rh8d51go5alb3bb8qo1sph4t356', '94.47.254.188', 1524414730, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343431343730323b), ('52lf02ick9lulqj19rmighduvqmt09ap', '94.141.220.1', 1524424825, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343432343832353b), ('2bnbmnta4267gfpcl17l772jil310ab8', '185.227.141.224', 1524425774, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343432353639323b), ('r8oer2ggtfi698r80r9trhmcsq8gvnu7', '54.67.59.131', 1524428161, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343432383136313b), ('h9bsnf18j2nrjk6fegik5eh7qhpr18mq', '94.141.222.3', 1524470716, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343437303530333b), ('shmum103g25g0lekfrh35o3i098k8nl2', '78.110.96.29', 1524474618, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343437343631383b), ('u025rv1k4pg7nfdaq407ajn0tpv095hf', '78.110.96.29', 1524474693, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343437343639333b), ('r01qbusvblf8goomvh62h5pm87v1ob5e', '35.162.70.167', 1524477682, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343437373638323b), ('4f6utpnat57vbvc9k6f2ei2tgk9iu52o', '94.102.94.59', 1524506685, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343530363638353b), ('ku6o645f4sptg4kvu5kqsl5r4uh3smgi', '34.228.227.138', 1524510958, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532343531303935383b); -- -------------------------------------------------------- -- -- Table structure for table `contactus` -- CREATE TABLE `contactus` ( `id` int(11) NOT NULL, `zone` varchar(255) NOT NULL, `address` text, `tel` varchar(255) NOT NULL, `fax` varchar(255) DEFAULT NULL, `mob` varchar(255) DEFAULT NULL, `email1` varchar(255) DEFAULT NULL, `email2` varchar(255) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `file` -- CREATE TABLE `file` ( `id` int(11) NOT NULL, `path` varchar(500) NOT NULL, `product_id` int(11) DEFAULT NULL, `project_id` int(11) DEFAULT NULL, `service_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `image` -- CREATE TABLE `image` ( `id` int(11) NOT NULL, `title` varchar(254) DEFAULT NULL, `path` varchar(254) DEFAULT NULL, `product_id` int(11) DEFAULT NULL, `service_id` int(11) DEFAULT NULL, `project_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `partner` -- CREATE TABLE `partner` ( `id` int(11) NOT NULL, `title` varchar(45) DEFAULT NULL, `image` varchar(45) NOT NULL, `link` varchar(45) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `product` -- CREATE TABLE `product` ( `id` int(11) NOT NULL, `title` varchar(45) NOT NULL, `icon` varchar(45) NOT NULL, `summary` text, `details` text, `resources` text, `feature` varchar(1) NOT NULL DEFAULT '0', `category_id` int(11) NOT NULL, `manufacture` text ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `product` -- INSERT INTO `product` (`id`, `title`, `icon`, `summary`, `details`, `resources`, `feature`, `category_id`, `manufacture`) VALUES (1, 'Loading Arms', 'arms.jpg', 'Petrotechlb is a leader company in supplying, installing and maintaining top Loading Arms, working with silea puةps which have more than 50 years experience. \r\nTop Loading Arms are a self supported system that allows to load Railcars and road tankers from the top manhole with the widest horizontal range to fill all compartments without moving the vehicle and with a vertical range to load tankers with different height. The loading arms can be supplied with a wide variety of valves, sensors and accessories.\r\n', 'loading arms has a wide working range with a maximum variable reach of 3500 mm which allows to load all compartment that may fit in the working area , allows a 360° rotation to allow to load on both sides of the gantry.\r\nThe arm will be able to load railcars and road tanker of different height and width\r\n', NULL, '1', 2, NULL), (3, 'Fuel Driven Pumps', 'silea.jpg', 'Petrotechlb is a leader company in supplying, installing and maintaining fuel driven pumps, We deal with Italian Silea pumps which have more than 50 years experience.', 'Silea pumps features:
\r\n* The pump can be mounted on tank trucks with cardan shafts or hydraulic motor for unloading all petroleum products. The pump can be supplied with different coupling accesories and seals for some chemica liquids.
\r\n* The Positive displacement pump sets are supplied on metal plate bases coupled by belts and pulleys orbygear box reducers to an electric or a diedel motor. Electric motors can be supplied with different certifications ATEX, IECex.\r\n', 'SILEA', '0', 2, NULL), (5, 'Lanfeng', 'lanfeng.jpg', 'Petrotechlb is a leader company in supplying, installing and maintaining fuel dispenser pumps, We are distributors for China Pumps.\r\nLanfeng is one of the large-scale manufacturers specialized in developing and producing fuel dispenser ,gas dispenser and all components.\r\n', 'The company in line with the running idea “to make the most outstanding product with the most favorable price ,to depend upon the advanced technology and superior quality , grows stronger unceasingly. Features of Lanfeng Fuel Dispenser: Lanfeng Pump offers a variety of solutions for retail fueling. Depending on your specific application and fueling configuration, we have fuel dispensers to suit your needs for straight grade or blended fuels, standard fuels, diesel and more, Lanfeng Fuel Dispenser ensure safety, reliability and quality.', NULL, '1', 1, 'Lanfeng'), (6, 'Pipe & Accessories', 'pipe.jpg', 'Petrotechlb is a leader company in supplying, installing and maintaining fuel stations, Featuring our products by most complete line of underground and aboveground containment products including pipe, fittings, sumps and boots. Whether you require product or vent piping, fiberglass or polyethylene sumps.', 'The UPP™ electrofusion welding process is safe and simple to complete in any climate and virtually any weather condition. An installer simply preps the components, fits them together attaching welder leads to the fitting, and then presses a single button on the welding unit to initiate the process. The welder unit itself calculates the exact settings required to complete the weld, regardless of the pipework diameter or temperature, leaving no settings for the installer to input. Products Include:\r\n• Electrofusion-welded semi-rigid pipework & fittings\r\n• XP flexible pipework & fittings\r\n• Ducting\r\n• Entry boots\r\n• Termination fittings\r\n• Fiberglass or polyethylene tank & dispenser sumps\r\n', NULL, '0', 1, NULL), (7, 'ATG Systems', '007.jpg', 'We are driven by our pursuit to innovate, simplify, secure, and connect every station owner to their vital site date, We have a range of products for fuel management systems that meet the objectives of the station owners.\r\n', 'Our products can connect every station owner to their fuel management system, to achieve reliability, security and ease of control and control of the fuel station, allows supervision and monitoring of reservoir level and recording reports at every moment and at any time.\r\n', NULL, '0', 1, NULL), (8, 'Flow Meters', 'flow.jpg', 'Petrotechlb is a leader company in supplying, installing and maintaining fuel Flow Meter.\r\nLiquid Controls is the global market leader in precision measuring systems providing highly engineered and differentiated products used in custody transfer of highly valuable refined fuels and liquids. From its start in 1956, Liquid Controls has been dedicated to providing high quality flow meters and accessories for accurate liquid measurement in custody transfer applications.\r\n', 'FEATURES: \r\n* Sustained Accuracy and Repeatability.\r\n* No Metal-to-Metal Contact within the measuring chamber.\r\n* Low Pressure Loss & Low Maintenance.\r\n* 3 PD Series available to support an extensive range of refined fuel and fluid. \r\napplications:.\r\n* Choice of Aluminum or Stainless Steel materials of construction.\r\n* Variety of system accessories available to provide our customers a single source for accuracy and reliability when it comes to fuel measurement and data management. \r\nBENEFITS:\r\n* Self-contained operation without electrical power or signal conditioning (for units equipped with mechanical registers, printers or presets); no special piping requirements.\r\n* Electronic output and registration equipment where enhanced accuracy and electronic communications are needed.\r\n* Weights & Measures approval (world-wide) for custody transfer with mechanical or electronic registration systems meeting API standards.\r\n* Electronic accessories designed and approved to Class 1 Div. 2 standards.\r\n', 'LC', '1', 2, 'LC'), (9, 'Bennett', 'bennett.jpg', 'Petotechlb is a leader company in supplying, installing and maintaining fuel pumps, Bennett Pump offers a variety of solutions for retail fueling.we have fuel dispensers to suit your needs for straight grade or blended fuels.', 'Features of Bennett Pumps:\r\nBennett Pump offers a variety of solutions for retail fueling. Depending on your specific application and fueling configuration, we have fuel dispensers to suit your needs for straight grade or blended fuels, standard fuels, alcohol, ethanol, diesel and more, Bennett pumps ensure safety, reliability and quality.\r\n', NULL, '0', 1, 'BENNETT'); -- -------------------------------------------------------- -- -- Table structure for table `project` -- CREATE TABLE `project` ( `id` int(11) NOT NULL, `title` varchar(45) NOT NULL, `description` text NOT NULL, `icon` varchar(45) NOT NULL, `customer` varchar(45) DEFAULT NULL, `current` varchar(1) NOT NULL DEFAULT '0', `usedequipment` text, `category_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `service` -- CREATE TABLE `service` ( `id` int(11) NOT NULL, `title` varchar(45) NOT NULL, `icon` varchar(45) NOT NULL, `summary` text, `feature` varchar(1) NOT NULL DEFAULT '0', `category_id` int(11) NOT NULL, `vision` text, `types` text ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` int(11) NOT NULL, `logo` varchar(500) NOT NULL, `facebook` varchar(500) DEFAULT NULL, `twitter` varchar(500) DEFAULT NULL, `youtube` varchar(500) DEFAULT NULL, `email` varchar(500) DEFAULT NULL, `address` text, `phone` varchar(45) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `logo`, `facebook`, `twitter`, `youtube`, `email`, `address`, `phone`) VALUES (1, 'logo.png', '#', '#', '#', 'info@petrotechlb.com', 'LEBANON-ALMATN', '+96181301941'); -- -------------------------------------------------------- -- -- Table structure for table `slider` -- CREATE TABLE `slider` ( `id` int(11) NOT NULL, `image` varchar(500) NOT NULL, `title` varchar(500) NOT NULL, `description` varchar(500) DEFAULT NULL, `link` varchar(45) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id` int(11) NOT NULL, `username` varchar(45) NOT NULL, `password` varchar(45) NOT NULL, `role` enum('admin','data_entry') NOT NULL DEFAULT 'data_entry' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `username`, `password`, `role`) VALUES (1, 'emad', '202cb962ac59075b964b07152d234b70', 'admin'); -- -------------------------------------------------------- -- -- Table structure for table `why3s` -- CREATE TABLE `why3s` ( `id` int(11) NOT NULL DEFAULT '0', `description` text NOT NULL, `conclusion` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `why3s` -- INSERT INTO `why3s` (`id`, `description`, `conclusion`) VALUES (1, 'Standard Services & Solutions Co. - Petrotech is a joint venture company founded in 2010 working in the field of oil products & supplies. Engineering studies, design, supply, construction, maintenance & operation. We have the expertise and the qualified personnel to design and implement the switchboards and gas stations, and supervising this kind of work so that our staff covers the design, implementation, modification and modernization of the stations, supervising the implementation of the stations, all according to the Syrian and international specifications such as APEA, EI. API, ASME, ... to ensure that we follow the rules of the warehouses and fuel stations and to adjust the quality of implementation according to international standards. We have a cadre specialized in maintenance work covering all governorates of the country has sufficient experience to deal with all the equipment we supply and adopt. We deal with a wide range of international companies known for their products from loading arms, pumps, fuel pumps, submersibles, automation systems and measuring tank level, smart card systems, suppliers of accessories.\n', 'A joint venture with Naya Oil Services Company has recently been established, technical inspection, calibration. Under the name of Naya Standard Services and Solutions Company, we are licensed under this name to represent Naya Company such as SHELL, BP, Hulliborto ... and other oil companies international forces operating in Iraq.\n'); -- -- Indexes for dumped tables -- -- -- Indexes for table `aboutus` -- ALTER TABLE `aboutus` ADD PRIMARY KEY (`id`); -- -- Indexes for table `category` -- ALTER TABLE `category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `certificate` -- ALTER TABLE `certificate` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ci_sessions` -- ALTER TABLE `ci_sessions` ADD KEY `ci_sessions_timestamp` (`timestamp`); -- -- Indexes for table `contactus` -- ALTER TABLE `contactus` ADD PRIMARY KEY (`id`); -- -- Indexes for table `file` -- ALTER TABLE `file` ADD PRIMARY KEY (`id`), ADD KEY `fk_image_product1_idx` (`product_id`), ADD KEY `fk_image_project1_idx` (`project_id`), ADD KEY `fk_image_Service1_idx` (`service_id`); -- -- Indexes for table `image` -- ALTER TABLE `image` ADD PRIMARY KEY (`id`), ADD KEY `fk_image_product2_idx` (`product_id`), ADD KEY `fk_image_Service2_idx` (`service_id`), ADD KEY `fk_image_project2_idx` (`project_id`); -- -- Indexes for table `partner` -- ALTER TABLE `partner` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product` -- ALTER TABLE `product` ADD PRIMARY KEY (`id`), ADD KEY `fk_product_category1_idx` (`category_id`); -- -- Indexes for table `project` -- ALTER TABLE `project` ADD PRIMARY KEY (`id`), ADD KEY `fk_project_category1_idx` (`category_id`); -- -- Indexes for table `service` -- ALTER TABLE `service` ADD PRIMARY KEY (`id`), ADD KEY `fk_Service_category_idx` (`category_id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `slider` -- ALTER TABLE `slider` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username_UNIQUE` (`username`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `aboutus` -- ALTER TABLE `aboutus` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `category` -- ALTER TABLE `category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `certificate` -- ALTER TABLE `certificate` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `contactus` -- ALTER TABLE `contactus` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `file` -- ALTER TABLE `file` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `image` -- ALTER TABLE `image` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `partner` -- ALTER TABLE `partner` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `product` -- ALTER TABLE `product` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `project` -- ALTER TABLE `project` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `service` -- ALTER TABLE `service` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `slider` -- ALTER TABLE `slider` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Constraints for dumped tables -- -- -- Constraints for table `file` -- ALTER TABLE `file` ADD CONSTRAINT `fk_image_Service1` FOREIGN KEY (`service_id`) REFERENCES `service` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_image_product1` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_image_project1` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Constraints for table `image` -- ALTER TABLE `image` ADD CONSTRAINT `fk_image_Service2` FOREIGN KEY (`service_id`) REFERENCES `service` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_image_product2` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_image_project2` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Constraints for table `product` -- ALTER TABLE `product` ADD CONSTRAINT `fk_product_category1` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Constraints for table `project` -- ALTER TABLE `project` ADD CONSTRAINT `fk_project_category1` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Constraints for table `service` -- ALTER TABLE `service` ADD CONSTRAINT `fk_Service_category` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; COMMIT; /*!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 */;