-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Generation Time: Mar 17, 2026 at 06:47 AM
-- Server version: 5.7.23
-- PHP Version: 7.2.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `kanyenya`
--

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

--
-- Table structure for table `about_new`
--

CREATE TABLE `about_new` (
  `id` int(11) NOT NULL,
  `message` longtext NOT NULL,
  `name` varchar(150) 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 `about_new`
--

INSERT INTO `about_new` (`id`, `message`, `name`, `ufile`, `updated_at`) VALUES
(36, 'We were established in 2015 as a general works contractor. Since then, the company has steadily evolved into a multidisciplinary firm, offering a broad range of services including construction, general supplies, civil engineering, and many others. With a strong foundation built on professionalism, integrity, and technical expertise, we have successfully undertaken and delivered numerous complex projects across various sectors — including infrastructure development, public utilities, institutional facilities, and private developments. Over time, we have gained vast experience in executing solutions, from planning and design to implementation. We pride ourselves on delivering high-quality work, adhering to timelines, and maintaining strong client relationships. Our team of dedicated engineers, technicians, and support staff work collaboratively to ensure that every project meets the highest standards of safety, efficiency, and sustainability.', 'Kanyenya Engineering Works Ltd', 't1.png', '2025-08-01 06:25:26');

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `aid` int(10) NOT NULL,
  `auser` varchar(50) NOT NULL,
  `aemail` varchar(50) NOT NULL,
  `apass` varchar(50) NOT NULL,
  `adob` date NOT NULL,
  `aphone` varchar(15) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`aid`, `auser`, `aemail`, `apass`, `adob`, `aphone`, `created_at`, `updated_at`) VALUES
(9, 'admin', 'admin@gmail.com', '74aba4cf890ad33136f65e94eb3fad50e05460f4', '1994-12-06', '0781944113', '2025-05-23 15:46:24', '2025-07-15 02:23:00');

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `cid` int(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `subject` varchar(100) NOT NULL,
  `message` varchar(250) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`cid`, `name`, `email`, `phone`, `subject`, `message`, `created_at`, `updated_at`) VALUES
(13, 'Charlse', 'charlse@gmail.com', '0781944113', 'Healthy cows', 'sample text sample', '2025-05-23 15:46:24', '2025-07-08 03:20:17'),
(16, 'Assumpta', 'rosettetabingwa@gmail.com', '0781944113', 'Observation', 'Good website', '2025-05-23 15:46:24', '2025-05-23 15:46:24');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `title`, `photo`, `date`) VALUES
(47, 'Residential House', 'house (2).jpg', '2025-07-23 12:53:43'),
(48, 'Residential house', '1739614174153.jpg', '2025-07-23 12:56:01'),
(49, 'Fingerlings', 'IMG_20211213_113036_360.jpg', '2025-07-23 13:09:54'),
(50, 'Fish ponds', 'IMG_20211203_161832_329.jpg', '2025-07-23 13:12:47'),
(51, 'fingerlings', 'cropd.jpg', '2025-07-23 13:17:50'),
(53, 'latrine', 'IMG_20220905_134713_868.jpg', '2025-07-23 13:18:46'),
(54, 'classroom block', 'one.jpg', '2025-07-23 13:19:19'),
(55, 'officials', 'Supply of fingerlings.jpg', '2025-07-23 13:19:45');

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

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int(11) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `employer` varchar(500) NOT NULL,
  `doc` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `subject`, `employer`, `doc`) VALUES
(35, 'Construction of a  5 Stance lined pit latrine with a urinal  at Ggunda Primary school in Kammengo subcounty', 'Mpigi DLG', '0000-00-00'),
(36, 'Water Mains Extension to Matanga in Masaka District', 'Water and Sewerage Corporation', '2016-10-10'),
(37, 'Water Mains Extension to Matanga phase II in Masaka district', 'National Water and Sewerage Corporation', '2016-10-10'),
(38, 'Water supply works of water pipeline extension from Katende to kikondo  Kiringetite sub county in Mpigi district', 'Mpigi DLG', '2018-05-02'),
(39, 'Water supply works of water pipeline extension of kitakyusa, Bukasa and Lwamikoma water supply system in Kitutu s/c, Mpigi District', 'Mpigi DLG', '2020-03-20'),
(40, 'Framework contract for supply and delivery of Tilapia fish fingerlings under framework arrangement for three years lot 1(one)', 'NAADS', '0000-00-00'),
(41, 'Framework contract for supply and delivery of African cat fish fingerlings under framework arrangement for three years lot 3 (three)', 'NAADS', '0000-00-00'),
(42, 'Construction of Namatale piped water system Phase II in Buvuma District', 'Buvuma DLG', '2022-06-30'),
(43, 'Construction of a 2-classroom block, a 5 stance VIP latrine block for Girls, a 5 stance VIP latrine block for boys, supply of 36 three(3) seater desks and 2 sets of teachers\' furniture at Mpigi Umea P/S under Education', 'Mpigi DLG', '2022-09-30'),
(44, 'Extension of piped water 3.5km to Kitagobwa village, Ngando sub county in Butambala DLG', 'Butambala DLG', '2022-06-30'),
(45, 'Extension of piped water 3.5km to Bukesa village, Ngando Sub county in Butambala DLG', 'Butambala DLG', '2022-06-30'),
(46, 'Construction of a three-classroom block(3) at Mabanda Islamic Primary School', 'Butambala DLG', '2022-06-30'),
(47, 'Construction of Namatale piped water system Phase III', 'Buvuma DLG', '2022-06-30'),
(48, 'Contract for framework contract for labour to construct water works in selected towns under WSDF-C in Central and Mid -Western Uganda', 'Ministry of water and environment', '2025-05-30'),
(49, 'Extension of piped water borehole pumped 2.5km, Butende Village in Ngando Sub county using water grant funds ', 'Butambala DLG', '2024-03-30'),
(50, 'Construction of A5 Stance lined pit latrine at Kinoni Umea Primary School, Kibibi Town Council using SFG', 'Butambala DLG', '2024-06-30'),
(52, 'Construction of Namatale piped water system phase iv', 'Buvuma DLG', '2024-06-30'),
(53, 'Construction of girls\' toilets with showers', 'Entebbe SS', '0000-00-00'),
(54, 'Construction of a maternity ward, Administration block, 2 staff houses, 2 blocks of 5 stance VIP latrines at Nyahuka Town Council Bundibugyo district', 'Bundibugyo DLG', '0000-00-00'),
(55, 'Construction of Bananywa Seed Secondary School in Bananywa sub county, Kyankwanzi District', 'Kyankwanzi DLG', '2020-12-18'),
(56, 'Construction of water supply system phase III in Bweema Sub county', 'Buvuma DLG', '0000-00-00'),
(57, 'Construction of water supply system Phase II in Bwema Sub county', 'Buvuma DLG', '0000-00-00'),
(58, 'Construction of a 2 No.3 Storey staff accommodation block at Mbarara Regional Referral hospital', 'Mbarara Regional Referral Hospital', '2021-01-06'),
(59, 'Construction of Kacuro Gravity flow scheme in Kacuro and Kitibya villages of Kigata parish-Kyanamira subcounty Ndorwa county of Kabale district', 'Kabale DLG', '0000-00-00'),
(60, 'Construction of Tolit Town water supply Project', 'Government of South Sudan', '2018-03-10'),
(61, 'REGISTRATION (SHORT LISTING) OF PROVIDERS FOR WORKS: Extension of piped water supply system  Financial Years: 2024-2025, 2025-2026, 2026-2027', 'Bukomansimbi DLG', '0000-00-00'),
(62, 'Procurement Of The Frame Work Contract For Wetland Demarcation And Fish Restocking In Albert Water Management Zone', 'Ministry of water and environment', '0000-00-00'),
(63, 'Proposed construction of boys\' dormitory block on plots 189, 120, block 70 Gombe, Butambal District', 'Gombe SS', '0000-00-00'),
(64, 'Registration (short listing) of providers for works; construction of solar water production wells', 'Kiryandongo District Local Government', '0000-00-00'),
(65, 'Registration (short listing) of providers for works; renovation and maintenance of permanent buildings', 'Kiryandongo DLG', '0000-00-00'),
(66, 'Construction of a three classroom block at Mpigi Umea Primary school in Mpigi Umea P/S', 'Mpigi DLG', '0000-00-00'),
(67, 'Registration (short listing) of providers for works, services or supplies:  Construction of piped water system', 'Buvuma DLG', '0000-00-00'),
(68, 'Registration (short listing) of providers for works, services or supplies: construction of buildings and road networks', 'Buvuma DLG', '0000-00-00'),
(69, 'Supply of pipes, fittings and water meters under framework contract for central and mid-western regions -wsdfc', 'Ministry of water and environment', '0000-00-00'),
(70, 'Additional works for extension of piped water(400m) to Butende village Ngando Sub-county,Butambala district using Water grant', 'Butambala district local  government ', '0000-00-00'),
(71, 'Registration (short listing) of providers for works 2024/2025: General building constructions', 'Kassanda DLG', '0000-00-00'),
(72, 'Registration (short listing) of providers for works 2024/2025: Construction of piped water schemes', 'Kassanda DLG', '0000-00-00'),
(73, 'Registration (short listing) of providers for works:  General buildings and construction works', 'Mpigi DLG', '0000-00-00'),
(74, 'Short listing (pre-qualification) of providers for works:  Construction, completion, renovation & maintenance of buildings', 'Namutumba DLG', '0000-00-00'),
(75, 'Short listing (pre-qualification) of providers for works:  Construction of mini piped water systems', 'Namutumba DLG', '0000-00-00'),
(76, 'Registration of providers for works: construction/renovation of classroom blocks,staff houses,health facilities 2024/2025, 2025/2026, 2026/2027', 'Yumbe District Local Government', '0000-00-00'),
(77, 'Registration of providers for works: construction of piped water systems 2024/2025, 2025/2026, 2026/2027', 'Yumbe District Local Government', '0000-00-00'),
(78, 'Registration of providers for works: minor road works 2024/2025, 2025/2026, 2026/2027', 'Yumbe District Local Government ', '0000-00-00'),
(79, 'Short listing (prequalification) for works: general construction, civil works and renovation of permanent buildings for f/y 2024-25 in Butambala district', 'Butambala DLG', '0000-00-00'),
(80, 'Short listing (prequalification) for works: general construction, civil works and renovation of permanent buildings for f/y 2024-25 in Butambala district', 'Butambala DLG', '0000-00-00'),
(81, 'Construction of a boundary wall for the girls’ hostel', 'Entebbe SS', '0000-00-00'),
(82, 'Construction of  a two classroom block at Ighalangire  P/S', 'Namutumba DLG', '0000-00-00'),
(83, 'Construction Of Namatale Piped Water System Phase V.', 'Buvuma DLG', '0000-00-00'),
(84, 'Construction of a Mini Solar Piped Water System at Kalongo', 'Kassanda DLG', '0000-00-00'),
(85, 'Construction of a  Mini Solar Piped Water System at Bweyongedde ', 'Kassanda DLG', '0000-00-00'),
(86, 'RENOVATION OF A CLASSROOM BLOCK AT  ST.MUGGAGGA JJALAMBA SSS IN BUWAMA  TOWN COUNCIL', 'Mpigi DLG', '0000-00-00'),
(87, 'CONSTRUCTION OF A 5STANCE LINED PIT LATRINE WITH  WASHROOM, AN INCINERATOR AND 1000 LITRE WATER TANK  AT KISAMMULA P/S IN MUDUUMA SUB COUNTY ', 'Mpigi DLG', '0000-00-00'),
(88, 'Renovation of a classroom block at Buwama Modern  P/S in Buwama TC ', 'Mpigi DLG', '0000-00-00');

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

--
-- Table structure for table `property`
--

CREATE TABLE `property` (
  `pid` int(50) NOT NULL,
  `title` varchar(200) NOT NULL,
  `pcontent` longtext NOT NULL,
  `type` varchar(100) NOT NULL,
  `bhk` varchar(50) NOT NULL,
  `stype` varchar(100) NOT NULL,
  `bedroom` int(50) NOT NULL,
  `bathroom` int(50) NOT NULL,
  `balcony` int(50) NOT NULL,
  `kitchen` int(50) NOT NULL,
  `hall` int(50) NOT NULL,
  `floor` varchar(50) NOT NULL,
  `size` varchar(50) NOT NULL,
  `price` int(50) NOT NULL,
  `location` varchar(200) NOT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `feature` longtext NOT NULL,
  `pimage` varchar(300) NOT NULL,
  `pimage1` varchar(300) NOT NULL,
  `pimage2` varchar(300) NOT NULL,
  `pimage3` varchar(300) NOT NULL,
  `pimage4` varchar(300) NOT NULL,
  `uid` int(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `mapimage` varchar(300) NOT NULL,
  `topmapimage` varchar(300) NOT NULL,
  `groundmapimage` varchar(300) NOT NULL,
  `totalfloor` varchar(50) NOT NULL,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `isFeatured` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `property`
--

INSERT INTO `property` (`pid`, `title`, `pcontent`, `type`, `bhk`, `stype`, `bedroom`, `bathroom`, `balcony`, `kitchen`, `hall`, `floor`, `size`, `price`, `location`, `city`, `state`, `feature`, `pimage`, `pimage1`, `pimage2`, `pimage3`, `pimage4`, `uid`, `status`, `mapimage`, `topmapimage`, `groundmapimage`, `totalfloor`, `date`, `isFeatured`, `created_at`, `updated_at`) VALUES
(1, 'ddd', 'dddddd', 'fff', 'ff', 'ff', 4, 4, 4, 4, 4, 'tt', 'gg', 4, 'r', 'r', 'r', 'rrrr', 'ff', 'fff', 'fff', 'fff', 'ffff', 44, 'ff', 'st08072502456421.png', 'st08072502456421.png', 'st08072502456421.png', 'dddd', '2025-07-08 05:57:36', NULL, '2025-07-08 02:57:36', '2025-07-08 02:57:36');

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

--
-- Table structure for table `recentprojects`
--

CREATE TABLE `recentprojects` (
  `pid` int(50) NOT NULL,
  `client` varchar(200) DEFAULT NULL COMMENT 'Make',
  `project` varchar(200) DEFAULT NULL COMMENT 'Model',
  `price` bigint(20) DEFAULT NULL COMMENT 'Price(UGX)',
  `pimage` varchar(300) DEFAULT NULL,
  `pimage1` varchar(300) DEFAULT NULL,
  `pimage2` varchar(300) DEFAULT NULL,
  `pimage3` varchar(300) DEFAULT NULL,
  `uid` int(50) NOT NULL,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `recentprojects`
--

INSERT INTO `recentprojects` (`pid`, `client`, `project`, `price`, `pimage`, `pimage1`, `pimage2`, `pimage3`, `uid`, `date`, `created_at`, `updated_at`) VALUES
(13, 'Butambala DLG', 'Supply of desks', 200000000, 'WhatsApp Image 2025-07-07 at 13.33.03.jpeg', 'WhatsApp Image 2025-07-07 at 13.33.02.jpeg', 'WhatsApp Image 2025-07-07 at 13.33.02 (2).jpeg', 'WhatsApp Image 2025-07-07 at 13.33.01.jpeg', 0, '2025-07-28 11:31:25', '2025-07-28 11:31:25', '2025-07-28 11:31:25'),
(14, 'Mpigi DLG', 'Construction of a classroom block and supply of desks', 400, 'IMG_20220905_135211_329.jpg', 'IMG_20221012_144807_975.jpg', 'IMG_20221013_113354_653.jpg', 'IMG-20220903-WA0006.jpg', 0, '2025-07-28 11:33:27', '2025-07-28 11:33:27', '2025-07-28 11:38:04'),
(15, 'Butambala DLG', '	Construction of vip latrine', 400, 'IMG_20220905_134713_868.jpg', 'IMG_20220905_134703_695.jpg', 'Picture6.png', 'Picture6.png', 0, '2025-07-28 11:42:18', '2025-07-28 11:42:18', '2025-07-28 11:42:18');

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

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `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 `staff`
--

INSERT INTO `staff` (`id`, `message`, `name`, `position`, `ufile`, `updated_at`) VALUES
(8, 'He is a skilled Building and Civil Engineer with a strong track record in designing, supervising, and delivering high-quality construction projects. Passionate about structural integrity and sustainable solutions, he brings technical expertise and innovative thinking to every stage of development.', 'Dennis Tukamwesige', 'Building & Civil Engineer', 'dennis.png', '2025-07-10 12:12:21'),
(9, 'He is a dedicated results-driven manager with a strong background in engineering and project leadership, he oversees operations with a focus on innovation, quality, and client satisfaction. He plays a key role in driving the company’s growth and delivering success across all projects', 'Mr. Mwesi Geofrey', 'Director', 'director-removebg-preview.png', '2025-07-23 08:37:01'),
(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', 'I.T Engineer', 'rose.png', '2025-07-18 02:11:30'),
(33, 'She is a dedicated Water Engineer with a passion for sustainable water solutions and environmental protection. With a solid background in civil and environmental engineering, she specializes in the design, development, and maintenance of water supply systems, wastewater treatment facilities, and sto', 'Kanyago Betty', 'Water Engineer', 'betty-removebg-preview.png', '2025-07-23 08:36:29');

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

--
-- Table structure for table `student`
--

CREATE TABLE `student` (
  `id` int(11) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `ref` varchar(100) NOT NULL,
  `dos` date NOT NULL,
  `employer` varchar(500) NOT NULL,
  `price` int(100) NOT NULL,
  `dor` date NOT NULL,
  `delete_status` enum('0','1') NOT NULL,
  `status` varchar(500) NOT NULL,
  `doc` date NOT NULL,
  `sdate` date DEFAULT NULL,
  `enddate` date DEFAULT NULL,
  `added_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `student`
--

INSERT INTO `student` (`id`, `subject`, `ref`, `dos`, `employer`, `price`, `dor`, `delete_status`, `status`, `doc`, `sdate`, `enddate`, `added_on`) VALUES
(35, 'Construction of a  5 Stance lined pit latrine with a urinal  at Ggunda Primary school in Kammengo subcounty', 'MPIGI-LG/WRKS/23-24/00041', '2024-04-22', 'Mpigi DLG', 25995848, '2024-04-22', '0', 'awarded', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(36, 'Water Mains Extension to Matanga in Masaka District', '799804', '0000-00-00', 'Water and Sewerage Corporation', 9940000, '0000-00-00', '1', 'completed', '2016-10-10', NULL, NULL, '2025-07-22 06:12:44'),
(37, 'Water Mains Extension to Matanga phase II in Masaka district', '799819', '0000-00-00', 'National Water and Sewerage Corporation', 9275000, '0000-00-00', '0', 'completed', '2016-10-10', NULL, NULL, '2025-07-22 06:12:44'),
(38, 'Water supply works of water pipeline extension from Katende to kikondo  Kiringetite sub county in Mpigi district', 'Mpigi54o/wks/17-18/00005', '0000-00-00', 'Mpigi DLG', 97692646, '2017-11-02', '0', 'Completed', '2018-05-02', NULL, NULL, '2025-07-22 06:12:44'),
(39, 'Water supply works of water pipeline extension of kitakyusa, Bukasa and Lwamikoma water supply system in Kitutu s/c, Mpigi District', 'Mpigi540/WRKS/19-20/00004', '0000-00-00', 'Mpigi DLG', 83736196, '2020-03-20', '0', 'completed', '2020-03-20', NULL, NULL, '2025-07-22 06:12:44'),
(40, 'Framework contract for supply and delivery of Tilapia fish fingerlings under framework arrangement for three years lot 1(one)', 'NAADS/SUPLS/2020-21/00011/1', '0000-00-00', 'NAADS', 244324700, '2021-01-22', '0', 'completed', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(41, 'Framework contract for supply and delivery of African cat fish fingerlings under framework arrangement for three years lot 3 (three)', 'NAADS/SUPLS/2020-21/00011/3', '0000-00-00', 'NAADS', 279211140, '2021-01-22', '0', 'Completed', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(42, 'Construction of Namatale piped water system Phase II in Buvuma District', 'BUVU590/WRKS/21-22/00008', '0000-00-00', 'Buvuma DLG', 323341146, '2021-06-28', '0', 'completed', '2022-06-30', NULL, NULL, '2025-07-22 06:12:44'),
(43, 'Construction of a 2-classroom block, a 5 stance VIP latrine block for Girls, a 5 stance VIP latrine block for boys, supply of 36 three(3) seater desks and 2 sets of teachers\' furniture at Mpigi Umea P/S under Education', 'MPIGI-LG/WRKS/00073', '0000-00-00', 'Mpigi DLG', 163543280, '2022-12-26', '0', 'completed', '2022-09-30', NULL, NULL, '2025-07-22 06:12:44'),
(44, 'Extension of piped water 3.5km to Kitagobwa village, Ngando sub county in Butambala DLG', 'Buta608/Wrks/21-22/00011', '0000-00-00', 'Butambala DLG', 123700000, '2022-04-02', '0', 'Completed', '2022-06-30', NULL, NULL, '2025-07-22 06:12:44'),
(45, 'Extension of piped water 3.5km to Bukesa village, Ngando Sub county in Butambala DLG', 'Buta827/Wrks/22-23/00004', '0000-00-00', 'Butambala DLG', 117500000, '2022-11-07', '0', 'completed', '2022-06-30', NULL, NULL, '2025-07-22 06:12:44'),
(46, 'Construction of a three-classroom block(3) at Mabanda Islamic Primary School', 'Buta827/Wrks/22-23/00001', '0000-00-00', 'Butambala DLG', 139977500, '2022-11-07', '0', 'Completed', '2022-06-30', NULL, NULL, '2025-07-22 06:12:44'),
(47, 'Construction of Namatale piped water system Phase III', 'BUVU829/WRKS/22-23/00002', '0000-00-00', 'Buvuma DLG', 314424747, '2022-12-19', '0', 'completed', '2022-06-30', NULL, NULL, '2025-07-22 06:12:44'),
(48, 'Contract for framework contract for labour to construct water works in selected towns under WSDF-C in Central and Mid -Western Uganda', 'MoWE/WRKS/22-2023/00135', '0000-00-00', 'Ministry of water and environment', 672045400, '2023-09-04', '0', 'Completed', '2025-05-30', NULL, NULL, '2025-07-22 06:12:44'),
(49, 'Extension of piped water borehole pumped 2.5km, Butende Village in Ngando Sub county using water grant funds ', 'Buta827/Wrks/23-24/00004', '0000-00-00', 'Butambala DLG', 99710000, '2024-12-15', '0', 'completed', '2024-03-30', NULL, NULL, '2025-07-22 06:12:44'),
(50, 'Construction of A5 Stance lined pit latrine at Kinoni Umea Primary School, Kibibi Town Council using SFG', 'Buta827/Wrks/23-24/00006', '0000-00-00', 'Butambala DLG', 26958516, '2023-12-15', '0', 'Completed', '2024-06-30', NULL, NULL, '2025-07-22 06:12:44'),
(52, 'Construction of Namatale piped water system phase iv', 'BUVU829/WKS/22-23/00003', '0000-00-00', 'Buvuma DLG', 244832559, '2024-03-14', '0', 'Completed', '2024-06-30', NULL, NULL, '2025-07-22 06:12:44'),
(53, 'Construction of girls\' toilets with showers', 'ESS/WRKS/24-25/0002', '2024-05-08', 'Entebbe SS', 83110000, '2024-06-10', '0', 'on going', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(54, 'Construction of a maternity ward, Administration block, 2 staff houses, 2 blocks of 5 stance VIP latrines at Nyahuka Town Council Bundibugyo district', '0', '0000-00-00', 'Bundibugyo DLG', 2147483647, '0000-00-00', '0', 'completed', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(55, 'Construction of Bananywa Seed Secondary School in Bananywa sub county, Kyankwanzi District', '0', '0000-00-00', 'Kyankwanzi DLG', 1656750600, '2019-12-18', '0', 'Completed', '2020-12-18', NULL, NULL, '2025-07-22 06:12:44'),
(56, 'Construction of water supply system phase III in Bweema Sub county', 'BUV829/WRKS/22-23/00002', '2023-06-05', 'Buvuma DLG', 314424747, '2023-06-05', '0', 'completed', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(57, 'Construction of water supply system Phase II in Bwema Sub county', 'BUV/590/WRKS/21-22/00008', '2022-05-30', 'Buvuma DLG', 323, '0000-00-00', '0', 'Completed', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(58, 'Construction of a 2 No.3 Storey staff accommodation block at Mbarara Regional Referral hospital', '0', '0000-00-00', 'Mbarara Regional Referral Hospital', 2147483647, '2018-12-12', '0', 'completed', '2021-01-06', NULL, NULL, '2025-07-22 06:12:44'),
(59, 'Construction of Kacuro Gravity flow scheme in Kacuro and Kitibya villages of Kigata parish-Kyanamira subcounty Ndorwa county of Kabale district', 'KABA 512/WRKS/16-17/00098', '0000-00-00', 'Kabale DLG', 0, '0000-00-00', '0', 'Completed', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(60, 'Construction of Tolit Town water supply Project', 'MIWR/UNDP/03/17', '0000-00-00', 'Government of South Sudan', 2147483647, '2016-08-10', '0', 'completed', '2018-03-10', NULL, NULL, '2025-07-22 06:12:44'),
(61, 'REGISTRATION (SHORT LISTING) OF PROVIDERS FOR WORKS: Extension of piped water supply system  Financial Years: 2024-2025, 2025-2026, 2026-2027', 'Wrks00002', '2024-07-03', 'Bukomansimbi DLG', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(62, 'Procurement Of The Frame Work Contract For Wetland Demarcation And Fish Restocking In Albert Water Management Zone', 'MoWE/NCONS/2023-2024/00211', '2024-02-04', 'Ministry of water and environment', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(63, 'Proposed construction of boys\' dormitory block on plots 189, 120, block 70 Gombe, Butambal District', 'GSS/WRKS/2024/00005', '2024-06-07', 'Gombe SS', 2147483647, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(64, 'Registration (short listing) of providers for works; construction of solar water production wells', 'Works/4000', '2024-05-14', 'Kiryandongo District Local Government', 0, '0000-00-00', '0', 'awarded', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(65, 'Registration (short listing) of providers for works; renovation and maintenance of permanent buildings', 'Works/5000', '2024-05-14', 'Kiryandongo DLG', 0, '0000-00-00', '0', 'awarded', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(66, 'Construction of a three classroom block at Mpigi Umea Primary school in Mpigi Umea P/S', 'MPIGI-LG/WRKS/2023-2024/00024', '2024-02-26', 'Mpigi DLG', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(67, 'Registration (short listing) of providers for works, services or supplies:  Construction of piped water system', 'BUVU829/PREQUALIFICATION/24-25/00001', '2024-07-10', 'Buvuma DLG', 0, '0000-00-00', '0', 'awarded', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(68, 'Registration (short listing) of providers for works, services or supplies: construction of buildings and road networks', 'BUVU829/PREQUALIFICATION/24-25/00001', '2024-07-10', 'Buvuma DLG', 0, '0000-00-00', '0', 'awarded', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(69, 'Supply of pipes, fittings and water meters under framework contract for central and mid-western regions -wsdfc', 'MoWE/SUPLS/2023-2024/00313', '2024-04-29', 'Ministry of water and environment', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(70, 'Additional works for extension of piped water(400m) to Butende village Ngando Sub-county,Butambala district using Water grant', 'Buta827/WRKS/23-24/00016', '0000-00-00', 'Butambala district local  government ', 11988800, '2024-05-14', '0', 'Completed', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(71, 'Registration (short listing) of providers for works 2024/2025: General building constructions', 'KAS855/WRKS/24-25/0001 PRQ', '2024-07-29', 'Kassanda DLG', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(72, 'Registration (short listing) of providers for works 2024/2025: Construction of piped water schemes', 'KAS 855/WRKS/24-25/0003 PRQ', '2024-07-29', 'Kassanda DLG', 0, '0000-00-00', '0', 'awarded', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(73, 'Registration (short listing) of providers for works:  General buildings and construction works', 'Works/1000', '2024-07-31', 'Mpigi DLG', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(74, 'Short listing (pre-qualification) of providers for works:  Construction, completion, renovation & maintenance of buildings', 'Wrks/6000 -1', '2024-08-06', 'Namutumba DLG', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(75, 'Short listing (pre-qualification) of providers for works:  Construction of mini piped water systems', 'Wrks/5005', '2024-08-06', 'Namutumba DLG', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(76, 'Registration of providers for works: construction/renovation of classroom blocks,staff houses,health facilities 2024/2025, 2025/2026, 2026/2027', '0', '2024-08-01', 'Yumbe District Local Government', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(77, 'Registration of providers for works: construction of piped water systems 2024/2025, 2025/2026, 2026/2027', '0', '2024-08-01', 'Yumbe District Local Government', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(78, 'Registration of providers for works: minor road works 2024/2025, 2025/2026, 2026/2027', '0', '0000-00-00', 'Yumbe District Local Government ', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(79, 'Short listing (prequalification) for works: general construction, civil works and renovation of permanent buildings for f/y 2024-25 in Butambala district', 'Buta827 /Wrks/ 24-25/001', '2024-10-12', 'Butambala DLG', 0, '0000-00-00', '1', 'Sub', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(80, 'Short listing (prequalification) for works: general construction, civil works and renovation of permanent buildings for f/y 2024-25 in Butambala district', 'Buta827 /Wrks/ 24-25/001', '2024-10-12', 'Butambala DLG', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(81, 'Construction of a boundary wall for the girls’ hostel', 'ESS/WRKS/2024/0003', '2024-10-07', 'Entebbe SS', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(82, 'Construction of  a two classroom block at Ighalangire  P/S', 'Namu 906/Wrks/24 -25/00045', '2024-10-23', 'Namutumba DLG', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(83, 'Construction Of Namatale Piped Water System Phase V.', 'BUVU829/WRKS/24-25/00004.', '2024-11-04', 'Buvuma DLG', 0, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(84, 'Construction of a Mini Solar Piped Water System at Kalongo', 'Kas855/Wrks/24-25/00010', '2024-09-24', 'Kassanda DLG', 347, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(85, 'Construction of a  Mini Solar Piped Water System at Bweyongedde ', 'Kas855/Wrks/24-25/0009', '2024-09-24', 'Kassanda DLG', 197, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(86, 'RENOVATION OF A CLASSROOM BLOCK AT  ST.MUGGAGGA JJALAMBA SSS IN BUWAMA  TOWN COUNCIL', 'MPIGI-LG/WRKS/2024-2025/00005 ', '2024-11-18', 'Mpigi DLG', 48415400, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(87, 'CONSTRUCTION OF A 5STANCE LINED PIT LATRINE WITH  WASHROOM, AN INCINERATOR AND 1000 LITRE WATER TANK  AT KISAMMULA P/S IN MUDUUMA SUB COUNTY ', 'MPIGI-LG/WRKS/2024-2025/00022', '2024-11-18', 'Mpigi DLG', 31535948, '0000-00-00', '0', 'submitted', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44'),
(88, 'Renovation of a classroom block at Buwama Modern  P/S in Buwama TC ', 'MPIGI-LG/WRKS/2024-2025/00018', '2024-11-18', 'Mpigi DLG', 15977200, '0000-00-00', '0', 'awarded', '0000-00-00', NULL, NULL, '2025-07-22 06:12:44');

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

--
-- Table structure for table `upload`
--

CREATE TABLE `upload` (
  `id` int(11) NOT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `filesize` bigint(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `upload`
--

INSERT INTO `upload` (`id`, `filename`, `filesize`) VALUES
(5, 'Appointment Letter-mwesi geofrey.pdf', 178453),
(8, 'Kalule Patrick Degree transcript.docx', 357190),
(10, 'Header Lyaga.docx', 125628),
(11, 'application for bid.docx', 203618),
(12, 'bank statement Kanyenya.pdf', 531222),
(15, 'Bak memarts.pdf', 625453),
(16, 'Bill of Quanties_Namatale RGCs phase ii.xlsx', 642941),
(17, 'IMG-20240412-WA0007.jpg', 107393),
(18, '4.4.1 Construction Schedule Bukesa Butambala.pdf', 2988928),
(19, 'Screenshot 2025-07-06 at 20.09.00.png', 12760);

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `uid` int(50) NOT NULL,
  `uname` varchar(100) NOT NULL,
  `uemail` varchar(100) NOT NULL,
  `uphone` varchar(20) NOT NULL,
  `upass` varchar(50) NOT NULL,
  `utype` varchar(50) NOT NULL,
  `uimage` varchar(300) NOT NULL,
  `ustatus` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`uid`, `uname`, `uemail`, `uphone`, `upass`, `utype`, `uimage`, `ustatus`, `created_at`, `updated_at`) VALUES
(61, 'rosette', 'rose@gmail.com', '0781944114', '4cdbb1c11683aeae9e8de4af07d71d1f6a00f1d6', '', 'black.jpg', 1, '2025-06-06 04:11:12', '2025-06-06 04:11:12');

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

--
-- Table structure for table `youtube_videos`
--

CREATE TABLE `youtube_videos` (
  `id` int(11) NOT NULL,
  `video_id` varchar(200) NOT NULL,
  `title` varchar(200) NOT NULL,
  `author` varchar(200) NOT NULL,
  `time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `uid` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `youtube_videos`
--

INSERT INTO `youtube_videos` (`id`, `video_id`, `title`, `author`, `time`, `created_at`, `updated_at`, `uid`) VALUES
(2, 'tE5FGuhltBU', 'YOUR FIRST 30 DAYS AS A NEW REAL ESTATE AGENT', 'Kevin Ray Ward', '2025-05-23 11:22:24', '2025-05-23 15:46:23', '2025-05-23 15:46:23', 0),
(3, 'QQQe1aDy4fE', 'The 3 Most Important Skills In Sales', 'Dan Lok', '2025-05-26 10:33:16', '2025-05-26 14:33:16', '2025-05-26 14:33:16', 44),
(4, 'dOslqMBloJ4', 'Questions to ALWAYS ask on the car lot as a Car Salesman - Car Selling Tips', 'Andy Elliott', '2025-05-28 21:16:30', '2025-05-29 01:16:30', '2025-05-29 01:16:30', 44);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`aid`);

--
-- Indexes for table `contact`
--
ALTER TABLE `contact`
  ADD PRIMARY KEY (`cid`);

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

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

--
-- Indexes for table `property`
--
ALTER TABLE `property`
  ADD PRIMARY KEY (`pid`);

--
-- Indexes for table `recentprojects`
--
ALTER TABLE `recentprojects`
  ADD PRIMARY KEY (`pid`);

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

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

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

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`uid`);

--
-- Indexes for table `youtube_videos`
--
ALTER TABLE `youtube_videos`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `video_id` (`video_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `cid` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

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

--
-- AUTO_INCREMENT for table `property`
--
ALTER TABLE `property`
  MODIFY `pid` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `recentprojects`
--
ALTER TABLE `recentprojects`
  MODIFY `pid` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

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

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

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

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `uid` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

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

/*!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 */;