-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` int(11) NOT NULL,
  `blog_title` varchar(300) NOT NULL,
  `blog_desc` varchar(300) NOT NULL,
  `blog_detail` varchar(2000) NOT NULL,
  `ufile` varchar(1000) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` (`id`, `blog_title`, `blog_desc`, `blog_detail`, `ufile`, `updated_at`) VALUES
(1, 'We provide the best digital services', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Impedit nihil tenetur minus quidem.', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Impedit nihil tenetur minus quidem est deserunt molestias accusamus harum ullam tempore debitis et, expedita, repellat delectus aspernatur neque itaque qui quod.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Impedit nihil tenetur minus quidem est deserunt molestias accusamus harum ullam tempore debitis et, expedita, repellat delectus aspernatur neque itaque qui quod.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Impedit nihil tenetur minus quidem est deserunt molestias accusamus harum ullam tempore debitis et, expedita, repellat delectus aspernatur neque itaque qui quod.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Impedit nihil tenetur minus quidem est deserunt molestias accusamus harum ullam tempore debitis et, expedita, repellat delectus aspernatur neque itaque qui quod.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Impedit nihil tenetur minus quidem est deserunt molestias accusamus harum ullam tempore debitis et, expedita, repellat delectus aspernatur neque itaque qui quod.', '', '2022-07-15 12:47:45'),
(2, 'We provide the best digital services', 'We provide the best digital servicesWe provide the best digital servicesWe provide the best digital services', 'We provide the best digital servicesWe provide the best digital servicesWe provide the best digital servicesWe provide the best digital servicesWe provide the best digital servicesWe provide the best digital servicesWe provide the best digital services', '60936059d354562031616499540.png', '2022-07-16 05:49:44');

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

--
-- Table structure for table `logo`
--

CREATE TABLE `logo` (
  `id` int(11) NOT NULL,
  `xfile` varchar(1000) NOT NULL,
  `ufile` varchar(1000) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `logo`
--

INSERT INTO `logo` (`id`, `xfile`, `ufile`, `updated_at`) VALUES
(1, '7195kanyenya_engineering_works_logo-removebg-preview.png', '9427kanyenya_engineering_works_logo-removebg-preview.png', '2024-04-03 18:44:40');

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

--
-- Table structure for table `portfolio`
--

CREATE TABLE `portfolio` (
  `id` int(11) NOT NULL,
  `port_title` varchar(500) NOT NULL,
  `port_desc` varchar(1000) NOT NULL,
  `port_detail` varchar(2000) NOT NULL,
  `ufile` varchar(1000) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `portfolio`
--

INSERT INTO `portfolio` (`id`, `port_title`, `port_desc`, `port_detail`, `ufile`, `updated_at`) VALUES
(5, 'Construction of a classroom block and VIP latrines  at Mpigi Umea', 'Construction of  a 2 classroom block,  A  5 stance VIP latrine  block for  girls, a 5 stance VIP latrine for boys ', 'Construction of  a 2 classroom block,  A  5 stance VIP latrine  block for  girls, a 5 stance VIP latrine for boys supply of 36 three (3) seater desks & 2 sets  of teacher’s furniture at Mpigi  UMEA P/S ', '5312IMG_20220905_135141_678.jpg', '2024-07-12 17:48:44'),
(7, 'Construction of A5- Stance lined pit latrine at Kinoni Umea Primary School, Kibibi ', 'Construction of A5- Stance lined pit latrine at Kinoni Umea Primary School, Kibibi Town Council using SFG P.O.BOX 103, MPIGI -UGANDA', 'Construction of A5- Stance lined pit latrine at Kinoni Umea Primary School, Kibibi Town Council using SFG P.O.BOX 103, MPIGI -UGANDA', '6700latrine.jpg', '2024-07-12 17:57:13'),
(9, 'Construction of Apartments and other commercial buildings', 'Construction of Apartments and other commercial buildings', 'Construction of Apartments and other commercial buildings', '5327IMG-20220909-WA0021.jpg', '2024-07-12 17:59:45'),
(22, 'Construction of Structures at Schools plus Supplies', 'Click to view', 'Kanyenya Engineering Works Limited constructed a classroom block, a 5 stance VIP latrine block for Girls, a 5 stance VIP latrine block for boys, supplied 36 three(3) seater desks and 2 sets of teachers\' furniture at Mpigi Umea P/S under Education under Procurement Reference Number: MPIGI-LG/WRKS/00073. Constructed a three-classroom block(3) at Mabanda Islamic Primary School under Procurement Reference Number: Buta827/Wrks/22-23/00001.Constructed a three classroom block at Mpigi Umea Primary school in Mpigi Umea P/S under Procurement Reference Number: MPIGI-LG/WRKS/2023-2024/00024. Constructed girls\' toilets with showers at Entebbe Secondary School - Entebbe Municipality under Procurement Reference Number: ESS/WRKS/24-25/0002', '1072two.jpg', '2024-08-01 22:26:53'),
(23, 'Construction and extension of water systems', 'Click to view', 'Kanyenya Engineering Works Limited excellently accomplished  water works of: Water Mains Extension to Matanga in Masaka District under Procurement Reference No: 799804. Water Mains Extension to Matanga phase II in Masaka district under Procurement Reference No:\r\n799819. Water supply works of water pipeline extension from Katende to kikondo Kiringetite sub county in Mpigi district under Procurement Reference No:Mpigi54o/wks/17-18/00005. Water supply works of water pipeline extension of kitakyusa, Bukasa and Lwamikoma water supply system in Kitutu s/c, Mpigi District under Procurement Reference No: Mpigi540/WRKS/19-20/00004. Construction of Namatale piped water system Phase II in Buvuma District under Procurement Reference No: BUVU590/WRKS/21-22/00008.Extension of piped water 3.5km to Kitagobwa village, Ngando sub county in Butambala DLG under Procurement Reference No: Buta608/Wrks/21-22/00011. Extension of piped water 3.5km to Bukesa village, Ngando Sub county in Butambala DLG under Procurement Reference No:\r\nButa827/Wrks/22-23/00004. Contract for framework contract for labour to construct water works in selected towns under WSDF-C in Central and Mid -Western Uganda under Procurement Reference No:MoWE/WRKS/22-2023/00135. Extension of piped water borehole pumped 2.5km, Butende Village in Ngando Sub county using water grant funds under Procurement Reference No: Buta827/Wrks/23-24/00004. Construction of Namatale piped water system phase iv under Procurement Reference No: BUVU829/WKS/22-23/00003. Construction of water supply system phase III in Bweema Sub county under Procurement Reference No: BUV829/WRKS/22-23/00002. Construction of water supply system Phase II in Bwema Sub county under Procurement Reference No: BUV/590/WRKS/21-22/00008. Construction of Kacuro Gravity flow scheme in Kacuro and Kitibya villages of Kigata parish-Kyanamira subcounty Ndorwa county of Kabale district under Procurement Reference No: KABA 512/WRKS/16-17/00098. Construction of Tolit Town water ', '700water project.jpg', '2024-08-01 22:46:59'),
(24, 'Supply and delivery of fish fingerlings', 'Click to view', 'Kanyenya Engineering Works Limited succussfuly performed works of: Framework contract for supply and delivery of Tilapia fish fingerlings under framework arrangement for three years lot 1(one) under under Procurement Reference No: NAADS/SUPLS/2020-21/00011/1. Framework contract for supply and delivery of African cat fish fingerlings under framework arrangement for three years lot 3 (three)\r\nNAADS/SUPLS/2020-21/00011/3', '3846IMG_20220120_130736_596.jpg', '2024-08-01 22:54:56'),
(25, 'Construction, completion, renovation & maintenance of buildings at health centres', 'Click to view', 'Kanyenya Engineering Works Limited constructed  a maternity ward, Administration block, 2 staff houses, 2 blocks of 5 stance VIP latrines at Nyahuka Town Council Bundibugyo district. Constructed a 2 No.3 Storey staff accommodation block at Mbarara Regional Referral hospital', '124hospital.jpg', '2024-08-01 23:06:43'),
(27, 'construction, completion, renovation & maintenance of Residential houses', 'Click to view', 'Kanyenya Engineering Works Limited has gained out standing experience in the construction, completion, renovation and maintenance of all types of houses completed  on time following technical specification and at affordable prices', '3892house (2).jpg', '2024-08-01 23:17:45');

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

--
-- Table structure for table `section_title`
--

CREATE TABLE `section_title` (
  `id` int(11) NOT NULL,
  `about_title` varchar(500) NOT NULL,
  `about_text` varchar(1000) NOT NULL,
  `why_title` varchar(500) NOT NULL,
  `why_text` varchar(1000) NOT NULL,
  `service_title` varchar(500) NOT NULL,
  `service_text` varchar(1000) NOT NULL,
  `port_title` varchar(500) NOT NULL,
  `port_text` varchar(1000) NOT NULL,
  `test_title` varchar(500) NOT NULL,
  `test_text` varchar(1000) NOT NULL,
  `contact_title` varchar(500) NOT NULL,
  `contact_text` varchar(1000) NOT NULL,
  `enquiry_title` varchar(500) NOT NULL,
  `enquiry_text` varchar(1000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `section_title`
--

INSERT INTO `section_title` (`id`, `about_title`, `about_text`, `why_title`, `why_text`, `service_title`, `service_text`, `port_title`, `port_text`, `test_title`, `test_text`, `contact_title`, `contact_text`, `enquiry_title`, `enquiry_text`) VALUES
(1, 'Equipment', 'Our extensive inventory features the latest machinery and tools, ensuring efficiency and reliability for every project with both heavy duty and specialised tools. Kanyenya Engineering Works Limited is committed to supplying high quality solutions to support your success at all costs.  ', 'Construction and Supplies for Development', 'Trust Kanyenya Engineering Works For all your Engineering Solutions', 'Our Service Spectrum', 'We are here to partner with you every step of the way with our wide range of services', 'Explore Our Portfolio of Success', 'We take pride in our track record of delivering exceptional results for our clients. Each endeavor reflects our commitment to excellence and client satisfaction.', 'Meet Our Team', 'Our dedicated team of professionals brings a wealth of experience, creativity, and passion to deliver top-notch solutions. We value collaboration, continuous learning, and a customer-centric approach to exceed your expectations. Explore one by one to learn more about the talented individuals driving our success. We\'re excited to work with you!', 'Get in Touch with Us', 'Ready to start a project?  Connect with our team of experts and discover how we can assist you. \r\nReach out using the information below or fill out the form, and we\'ll get back to you as soon as possible.\r\n\r\n', 'Who we are?', 'Kanyenya Engineering Works Limited began as a general works contractor in 2015. Over the years the company gradually expanded its services to provision of general supplies. It has undertaken many challenging projects and accumulated general skills in both supplies, construction works and any other related works.');

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

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `id` int(11) NOT NULL,
  `service_title` varchar(500) NOT NULL,
  `service_desc` varchar(1000) NOT NULL,
  `service_detail` varchar(2000) NOT NULL,
  `ufile` varchar(1000) NOT NULL,
  `upadated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `service`
--

INSERT INTO `service` (`id`, `service_title`, `service_desc`, `service_detail`, `ufile`, `upadated_at`) VALUES
(3, 'Construction of buildings & carpentry', 'Lorem ipsum dolor sit amet, consectet ur adipisicing elit, sed do eiusmod tempor incididunt emit.', 'Lorem ipsum dolor sit amet, consectet ur adipisicing elit, sed do eiusmod tempor incididunt emit.Lorem ipsum dolor sit amet, consectet ur adipisicing elit, sed do eiusmod tempor incididunt emit.Lorem ipsum dolor sit amet, consectet ur adipisicing elit, sed do eiusmod tempor incididunt emit.Lorem ipsum dolor sit amet, consectet ur adipisicing elit, sed do eiusmod tempor incididunt emit.Lorem ipsum dolor sit amet, consectet ur adipisicing elit, sed do eiusmod tempor incididunt emit.Lorem ipsum dolor sit amet, consectet ur adipisicing elit, sed do eiusmod tempor incididunt emit.Lorem ipsum dolor sit amet, consectet ur adipisicing elit, sed do eiusmod tempor incididunt emit.Lorem ipsum dolor sit amet, consectet ur adipisicing elit, sed do eiusmod tempor incididunt emit.', '9668788-7884680_hero-headshot-sitting-hd-png-download.jpg', '2024-03-08 16:27:23'),
(14, 'Supplies', 'Marine & fresh water products, agricultural products, building & construction materials, plumbing materials', 'Kanyenya Engineering Works Limited deals in a wide rage of supplies some of which include: Building & Construction Materials such as Concrete and Cement: Basic materials for foundations and structures. Steel and Metals: Reinforcement bars, steel beams, and metal sheets. Wood and Lumber: Framing lumber, plywood, and engineered wood products. Bricks and Blocks: Used for masonry work and building walls. Marine & Fresh Water Products for example: Fishing Equipment: Nets, rods, reels, bait, and tackle. Marine Electronics: GPS systems, fish finders, marine radios, and sonar devices. Aquaculture Supplies: Fish feeds, tanks, pumps, and aeration systems. Safety Gear: Life jackets, flares, first-aid kits, and marine fire extinguishers. Agricultural Products: Seeds and Plants: Crop seeds, seedlings, and nursery plants. Fertilizers: Organic and synthetic fertilizers for soil enrichment. Pesticides and Herbicides: Chemicals for pest and weed control. Agricultural Machinery: Tractors, plows, harvesters, and irrigation systems. Animal Husbandry Supplies: Feed, veterinary medicines, and breeding equipment. Insulation Materials: Fiberglass, foam board, and spray foam for energy efficiency. Plumbing Materials: We deal in materials vital for water supply and waste management systems. They include: Pipes and Tubes: PVC, copper, PEX, and galvanized steel pipes. Fittings and Valves: Elbows, tees, couplings, and shut-off valves. Fixtures: Sinks, faucets, toilets, and bathtubs. Water Heaters: Tankless, electric, and gas water heaters. Drainage Systems: Gutter systems, drain pipes, and sump pumps.', '8685SUPPLY.jpg', '2024-08-05 17:18:59'),
(16, 'Electrical, plumbing & other installation activities', 'Installation activities which cover a broad spectrum of systems critical for building functionality and comfort.', 'These include: \r\nConstruction of high and low voltage power lines\r\nWiring and Cabling:  \r\nElectrical Panel Installation:\r\nLighting Systems:\r\nSafety Systems:\r\nTesting and Inspection:\r\nPipe Installation\r\nFixture Setup\r\nLeak Detection and Repair:\r\nSystem Maintenance:\r\nHVAC Systems\r\nElevators and Escalators:', '4765electrical.jpg', '2024-05-24 18:21:58'),
(19, 'Mechanical works', 'We design, fabricate, install, and do maintenance of mechanical systems ', 'Mechanical works encompass a wide range of activities in which Kanyenya Engineering Works Limited has outstanding expertise and these involve the design, fabrication, installation, and maintenance of mechanical systems which are essential in various industries, including manufacturing, construction, automotive, and aerospace. Mechanical works typically involve: Design and Engineering: Creating detailed plans and specifications for mechanical components and systems using computer-aided design (CAD) software. Fabrication and Machining: Cutting, shaping, and assembling materials (like metals and plastics) to produce mechanical parts and structures. Installation: Setting up mechanical systems such as HVAC (heating, ventilation, and air conditioning), plumbing, and industrial machinery in buildings and facilities. Maintenance and Repair: Regular inspection, servicing, and fixing of mechanical systems to ensure they operate efficiently and safely. Quality Control: Testing and evaluating mechanical components and systems to meet safety standards and performance criteria. Trust Kanyenya Engineering Works Limited for mechanical works which are crucial for the functionality and efficiency of modern infrastructure and technology.', '8847mechanical works.jpg', '2024-08-08 16:39:49'),
(22, 'Construction of infrastructure such as roads, bridges, and water projects', 'We specialise in the construction of essential infrastructure contributing to the growth and development of the regions we serve', 'Kanyenya Engineering Works Limited has experience in the construction of essential infrastructure. From roads and bridges to water projects, we are dedicated to building the foundations that support and enhance communities. Our expertise ensures quality and reliability in every project , contributing to the growth and development of the regions we serve.', '410infrastructure (2).png', '2024-08-05 17:54:19'),
(23, 'Carpentry', 'Let us transform your space with our expertise and dedication to fine woodworking', 'We specialise in creating custom woodwork that brings your vision to life. From furniture and cabinetry to intricate trim and molding, our skilled carpenters deliver quality and excellence in every project. Let us transform your space with our expertise and dedication to fine woodworking', '5737download (1).jfif', '2024-08-05 18:40:48'),
(24, 'Construction of buildings and making plans', 'Partner with us to create structures that stand the test of time', 'Kanyenya Engineering Works Limited deals in the construction of high quality buildings and the meticulous planning that brings them to life. Our team is dedicated to delivering excellence from the initial design phase to the final build, ensuring your vision is realized with precision and professionalism. \r\nPartner with us to create structures that stand the test of time', '4349construction plans (2).png', '2024-08-05 18:49:24');

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

--
-- Table structure for table `siteconfig`
--

CREATE TABLE `siteconfig` (
  `id` int(11) NOT NULL,
  `site_keyword` varchar(1000) NOT NULL,
  `site_desc` varchar(500) NOT NULL,
  `site_title` varchar(300) NOT NULL,
  `site_about` varchar(1000) NOT NULL,
  `site_footer` varchar(1000) NOT NULL,
  `follow_text` varchar(1000) NOT NULL,
  `site_url` varchar(50) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `siteconfig`
--

INSERT INTO `siteconfig` (`id`, `site_keyword`, `site_desc`, `site_title`, `site_about`, `site_footer`, `follow_text`, `site_url`, `updated_at`) VALUES
(1, 'engineering, construction, supply, architecture', 'Kanyenya Engineering Works Limited Website', '  Kanyenya Engineering Works Limited Website', '         Our offices are located along Hoima road, Kayunga, Wakiso - Uganda. \r\n\r\n We look forward to welcoming you.\r\n\r\n', '© 2024 All Rights Reserved', 'Join our growing online community to keep up-to-date with the latest updates  and special offers from Kanyenya Engineering Works Ltd. \r\n\r\n', 'http://localhost:8080/vogue/', '2024-08-06 19:42:56');

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

--
-- Table structure for table `sitecontact`
--

CREATE TABLE `sitecontact` (
  `id` int(11) NOT NULL,
  `phone1` varchar(150) NOT NULL,
  `phone2` varchar(150) NOT NULL,
  `email1` varchar(100) NOT NULL,
  `email2` varchar(100) NOT NULL,
  `longitude` varchar(100) NOT NULL,
  `latitude` varchar(150) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `sitecontact`
--

INSERT INTO `sitecontact` (`id`, `phone1`, `phone2`, `email1`, `email2`, `longitude`, `latitude`, `updated_at`) VALUES
(1, '+256 776 348202', '+256 753247623', 'kanyenyaengineeringworksltd@gmail.com', 'kanyenyaengineeringworksltd@gmail.com', '7.099737483', '7.63734634', '2024-05-17 21:10:42');

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` int(11) NOT NULL,
  `slide_title` varchar(150) NOT NULL,
  `slide_text` varchar(500) NOT NULL,
  `ufile` varchar(1000) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `slide_title`, `slide_text`, `ufile`, `updated_at`) VALUES
(1, 'We are digital agency & Marketing', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Impedit nihil tenetur minus quidem est deserunt molestias accusamus harum ullam tempore debitis et, expedita, repellat delectus aspernatur neque itaque qui quod.', '58806059d354562031616499540.png', '2022-07-17 14:23:07');

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

--
-- Table structure for table `social`
--

CREATE TABLE `social` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `fa` varchar(150) NOT NULL,
  `social_link` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `social`
--

INSERT INTO `social` (`id`, `name`, `fa`, `social_link`) VALUES
(1, 'Facebook', 'fa-facebook', 'https://facebook.com/faithyemi'),
(2, 'Instagram', 'fa-instagram', 'https://instagram.com/faith_awolu');

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

--
-- Table structure for table `static`
--

CREATE TABLE `static` (
  `id` int(11) NOT NULL,
  `stitle` varchar(150) NOT NULL,
  `stext` varchar(500) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `static`
--

INSERT INTO `static` (`id`, `stitle`, `stext`, `updated_at`) VALUES
(1, 'Kanyenya Engineering Works Limited', 'Welcome to Kanyenya Engineering Works Ltd where innovation meets precision. With a rich history of excellence & commitment to delivering top-notch engineering solutions, we pride ourselves on being a trusted partner for all your engineering & supply needs. From conceptualization to execution, our dedicated team of professionals combines expertise with creativity to turn your ideas into reality. Explore our range of services & discover why clients trust us to deliver exceptional results.', '2024-03-08 17:18:29');

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

--
-- Table structure for table `testimony`
--

CREATE TABLE `testimony` (
  `id` int(11) NOT NULL,
  `message` varchar(300) NOT NULL,
  `name` varchar(150) NOT NULL,
  `position` varchar(100) NOT NULL,
  `ufile` varchar(1000) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `testimony`
--

INSERT INTO `testimony` (`id`, `message`, `name`, `position`, `ufile`, `updated_at`) VALUES
(8, 'What he says', 'Mr. Sserwadda', 'Engineer', '5341avatar-1.png', '2024-05-17 21:08:51'),
(9, 'dvw,MMKLJKLJDK,SCMDNLKACJWOAIEJIOEJFOMCLKMSKLDCJERO;JWOEIULWJED', 'Mr. Mwesi Geofrey', 'Director', '762director.jpg', '2024-05-20 23:39:28'),
(13, 'She is a professional Information Technology Administrator well equipped with knowledge of operating systems, graphics designing, networking, programing, trouble shooting, server administration, cyber security, software and hardware maintenance plus competent internet skills', 'Tabingwa Rosette', 'Head of Information Technology', '8991cropped.jpg', '2024-08-08 16:34:41');

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

--
-- Table structure for table `why_us`
--

CREATE TABLE `why_us` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `detail` varchar(500) NOT NULL,
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `why_us`
--

INSERT INTO `why_us` (`id`, `title`, `detail`, `updated_on`) VALUES
(6, 'Our Mission', 'Construction and Supplies for development', '2024-03-08 17:49:06'),
(7, 'Our Goal', 'To add value for clients through innovation, foresight, integrity, and aggressive performance, and to serve with character and purpose', '2024-03-08 17:51:45'),
(9, 'Core Operation', 'Construction', '2024-05-17 20:52:38');

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `blog`
--
ALTER TABLE `blog`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `logo`
--
ALTER TABLE `logo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `portfolio`
--
ALTER TABLE `portfolio`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `section_title`
--
ALTER TABLE `section_title`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `service`
--
ALTER TABLE `service`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `sitecontact`
--
ALTER TABLE `sitecontact`
  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=2;

--
-- AUTO_INCREMENT for table `social`
--
ALTER TABLE `social`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `static`
--
ALTER TABLE `static`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `testimony`
--
ALTER TABLE `testimony`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `why_us`
--
ALTER TABLE `why_us`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
COMMIT;

