-- phpMyAdmin SQL Dump -- version 5.1.0 -- https://www.phpmyadmin.net/ -- -- Host: localhost:8889 -- Generation Time: Jun 09, 2025 at 06:57 PM -- Server version: 5.7.34 -- PHP Version: 7.4.21 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: `bim` -- -- -------------------------------------------------------- -- -- Table structure for table `action` -- CREATE TABLE `action` ( `id` int(11) NOT NULL, `reviewedby` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `actiontaken` longtext COLLATE utf8_unicode_ci NOT NULL, `review` longtext COLLATE utf8_unicode_ci NOT NULL, `reviewdate` datetime NOT NULL, `status` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `incidentid` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `recorddate` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `action` -- INSERT INTO `action` (`id`, `reviewedby`, `actiontaken`, `review`, `reviewdate`, `status`, `incidentid`, `recorddate`) VALUES (1, 'US1', '', 'ReviewReviewReviewReview', '2025-05-19 12:38:00', 'active', '2', '2025-05-19 12:33:23'), (2, 'US1', '', 'ReviewReviewReviewReviewReviewReviewReviewReviewReviewReviewReview\r\nReviewReviewReviewReviewReviewReviewReviewReviewReviewReviewRev\r\niewReviewReviewReviewReviewReviewReviewReviewReviewRev iewReviewReviewReviewReviewReviewReviewReviewReviewRev iewReviewReviewReviewReviewReviewReviewReviewReviewRev iewReviewReviewReviewReviewReviewReviewReviewRevie wReviewReviewReviewReviewReviewReviewReviewReviewReviewReviewReview', '2025-05-19 12:41:00', 'active', '1', '2025-05-19 12:36:25'), (3, 'US1', '', 'wrew', '2025-05-19 12:55:00', 'active', '2', '2025-05-19 12:55:29'), (4, 'US14', '', 'Test Test review', '2025-05-19 15:39:00', 'active', '4', '2025-05-19 15:39:58'), (5, 'US11', '', 'Yuda iskari', '2025-05-19 15:45:00', 'active', '4', '2025-05-19 15:45:40'), (6, 'US10', '', 'we', '2025-05-19 15:46:00', 'active', '4', '2025-05-19 15:46:39'), (7, 'US10', '', 'Testt', '2025-05-19 15:41:00', 'active', '4', '2025-05-19 17:42:10'), (8, 'US10', '', 'm;lm', '2025-05-19 15:35:00', 'active', '4', '2025-05-19 17:46:39'), (9, 'US11', 'reject', 'jkgjkv jkgvjkvjkvkj', '2025-05-18 07:49:00', 'active', '6', '2025-05-20 07:50:30'), (10, 'US14', 'approved', 'ukgkj', '2025-05-18 08:03:00', 'active', '6', '2025-05-20 08:04:05'), (11, 'US11', 'approved', 'ukgjkv', '2025-05-18 08:06:00', 'active', '6', '2025-05-20 08:06:34'), (12, 'US1', 'reject', 'ilhil', '2025-05-18 08:27:00', 'active', '2', '2025-05-20 08:27:25'), (13, 'US14', 'approved', 'juma was not in a good mood', '2025-05-20 18:05:00', 'active', '10', '2025-05-20 18:06:32'), (14, 'US10', 'reject', 'ReviewReviewReviewReviewReviewReviewReviewReviewReviewReviewReview\r\n ReviewReviewReviewReviewReviewReviewReviewReviewReviewReviewReview ReviewReviewReviewReviewReviewReviewReviewReviewReviewReviewReview ReviewReviewReviewReviewReviewReviewReviewReviewReviewReviewReview ', '2025-05-20 21:23:00', 'active', '4', '2025-05-20 21:23:53'); -- -------------------------------------------------------- -- -- Table structure for table `employee` -- CREATE TABLE `employee` ( `empid` int(50) NOT NULL, `employer` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `location` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `firstname` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `lastname` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `department` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `job` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `position` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `section` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `status` varchar(10) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `recorddate` datetime NOT NULL, `postedby` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `recid` int(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `employee` -- INSERT INTO `employee` (`empid`, `employer`, `location`, `firstname`, `lastname`, `department`, `job`, `position`, `section`, `status`, `email`, `recorddate`, `postedby`, `recid`) VALUES (77, '19', '20', 'ally', 'juma', '14', 'job', '10', '17', 'active', 'rr', '2025-05-19 06:02:40', 'US1', 1), (234, '18', '21', 'facenet', 'Pharmacy', '15', 'accountant', '8', '17', 'active', 'eliasangito1997@gmail.com', '2025-05-19 09:30:58', 'US1', 2), (65, '18', '21', 'Minja', 'MINJA', '15', 'accountant', '22', '16', 'active', 'eliasangito1997@gmail.com', '2025-05-19 15:29:05', 'US11', 3), (567, '18', '21', 'JOHN', 'HECHE', '15', 'accountant', '10', '16', 'active', 'lilianpallangyo9@gmail.com', '2025-05-20 17:54:28', 'US11', 4), (123, 'bbl', 'bbl', 'Juma', 'Kibaso', 'Sales', 'Juma', 'JJ', 'dss', 'active', 'ee@mail', '2025-05-29 10:05:16', 'US1', 5), (12, '18', '20', 'Jane', 'Mlengo', '14', 'bottle washer', '9', '16', 'active', 'john@gmail.com', '2025-05-29 10:09:48', 'US1', 6), (10, '18', '20', 'Loning\'o', 'Mlengo', '14', 'bottle washer', '9', '16', 'active', 'john@gmail.com', '2025-05-29 10:12:57', 'US1', 7), (11, '18', '20', 'Lowai', 'Mlengo', '14', 'bottle washer', '9', '16', 'active', 'john@gmail.com', '2025-05-29 10:12:57', 'US1', 8); -- -------------------------------------------------------- -- -- Table structure for table `incident` -- CREATE TABLE `incident` ( `id` int(11) NOT NULL, `incidentdate` datetime NOT NULL, `type` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `incidentdescription` longtext COLLATE utf8_unicode_ci NOT NULL, `policy` longtext COLLATE utf8_unicode_ci NOT NULL, `empid` int(100) NOT NULL, `reportedby` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `status` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `actiontaken` longtext COLLATE utf8_unicode_ci NOT NULL, `postedby` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `recorddate` datetime NOT NULL, `actiondate` datetime NOT NULL, `currentlevel` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'SECTIONHEAD', `overallstatus` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `incident` -- INSERT INTO `incident` (`id`, `incidentdate`, `type`, `incidentdescription`, `policy`, `empid`, `reportedby`, `status`, `actiontaken`, `postedby`, `recorddate`, `actiondate`, `currentlevel`, `overallstatus`) VALUES (1, '2025-05-19 11:02:00', 'positive', 'form_rincidentform_rincidentform_rincidentform_rincidentform_rincident', 'Policy Affected', 2, 'Reported By', 'underreview', 'Action Taken:\r\nAction Taken:\r\nAction Taken:\r\nAction Taken:\r\nAction Taken:\r\n', 'US1', '2025-05-19 11:02:38', '2025-05-19 05:02:00', 'SECTIONHEAD', NULL), (2, '2025-05-19 11:13:00', 'positive', 'sds', 'Policy Affected', 2, 'Reported By', 'underreview', 'sdfsd', 'US1', '2025-05-19 11:13:33', '2025-05-19 05:13:00', '2', 'yes'), (3, '2025-05-19 15:29:00', 'positive', 'Incident Description:Incident DescriptionIncident DescriptionIncident DescriptionIncident DescriptionIncident DescriptionIncident Description', 'Policy Affected', 3, 'Reported By', 'underreview', 'Incident Description:\r\nAction TakenAction TakenAction TakenAction TakenAction TakenAction TakenAction Taken', 'US13', '2025-05-19 15:30:46', '2025-05-19 15:30:00', '0', NULL), (4, '2025-05-19 15:37:00', 'positive', 'yybkjkkjjkjk', 'Policy Affected', 3, 'Reported By', 'close', 'klnkln', 'US13', '2025-05-19 15:37:22', '2025-05-19 15:37:00', '5', 'rejected'), (5, '2025-05-19 15:40:00', 'positive', 'sdfsdfdsfsd', 'Policy Affected', 1, 'Reported By', 'underreview', 'dsfs', 'US14', '2025-05-19 15:40:45', '2025-05-19 15:40:00', '0', NULL), (6, '2025-05-19 16:35:00', 'positive', 'jk', 'Policy Affected', 1, 'Reported By', 'close', 'jjjIncident Description:\r\n', 'US10', '2025-05-19 16:36:15', '2025-05-19 04:36:00', '2', ''), (7, '2025-05-19 17:14:00', 'positive', 'sdv', 'Policy Affected', 1, 'Reported By', 'underreview', 'ds', 'US10', '2025-05-19 17:13:21', '2025-05-19 17:09:00', '0', NULL), (8, '2025-05-19 17:20:00', 'positive', ' jklkllkn', 'Policy Affected', 1, 'Reported By', 'underreview', 'klnkn', 'US10', '2025-05-19 17:28:37', '2025-05-19 17:26:00', '0', NULL), (9, '2025-05-19 18:05:00', 'negative', 'dsvsdsfsa', 'dss', 2, 'Reported By', 'underreview', 'dsfsd', 'US10', '2025-05-19 18:06:07', '2025-05-19 18:06:00', '0', NULL), (10, '2025-05-18 17:55:00', 'positive', 'Incident DescriptionIncident Description\r\nIncident DescriptionIncident Description\r\nIncident Description\r\nIncident Description', 'Affected Affected', 4, 'Reported By', 'open', 'Action Take\r\nAction Take\r\nAction Take\r\nAction Take\r\nAction Take\r\nAction Take Action Take', 'US11', '2025-05-20 18:02:04', '2025-05-20 18:01:00', '1', NULL), (11, '2025-05-14 09:38:00', 'positive', 'df', 'Affected Affected', 4, 'Reported By', 'underreview', 'df', 'US13', '2025-05-22 09:39:08', '2025-05-15 09:39:00', '0', NULL), (12, '2025-05-13 09:41:00', 'positive', 'Incident DescriptionIncident Description', 'Affected Affected', 4, 'Reported By', 'underreview', 'Incident Description', 'US13', '2025-05-22 09:41:55', '2025-05-15 09:41:00', '0', NULL); -- -------------------------------------------------------- -- -- Table structure for table `manifest` -- CREATE TABLE `manifest` ( `id` int(11) NOT NULL, `function` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `apptype` varchar(100) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `masters` -- CREATE TABLE `masters` ( `recid` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `status` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `masters` -- INSERT INTO `masters` (`recid`, `name`, `status`, `_type`) VALUES (8, 'Administrator', 'active', 'title'), (9, 'Supervisor', 'active', 'title'), (10, 'HOD', 'active', 'title'), (11, 'HRM', 'active', 'title'), (12, 'MD', 'active', 'title'), (13, 'Sales', 'inactive', 'title'), (14, 'Sales', 'active', 'department'), (15, 'Account', 'active', 'department'), (16, 'Sect 1', 'active', 'section'), (17, 'Sect 2', 'active', 'section'), (18, 'BBL', 'active', 'employer'), (19, 'MSL', 'active', 'employer'), (20, 'Deport', 'active', 'location'), (21, 'Bonite', 'active', 'location'), (22, 'Normal', 'active', 'title'); -- -------------------------------------------------------- -- -- Table structure for table `roles_assignment` -- CREATE TABLE `roles_assignment` ( `recid` int(11) NOT NULL, `userid` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `location` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `role` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `recorddate` datetime NOT NULL, `postedby` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `status` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `department` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `section` varchar(100) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `roles_assignment` -- INSERT INTO `roles_assignment` (`recid`, `userid`, `location`, `role`, `recorddate`, `postedby`, `status`, `department`, `section`) VALUES (1, 'US1', '21', 'sectionhead', '2025-06-09 16:44:34', 'US1', 'active', '', ''), (2, 'US1', '21', 'hod', '2025-06-09 16:45:39', 'US1', 'active', '', ''), (4, 'US13', '21', 'SECTIONHEAD', '2025-06-09 19:20:01', 'US1', 'active', '', ''), (5, 'US1', 'all', 'SECTIONHEAD', '2025-06-09 21:36:28', 'US1', 'active', '15', '16'), (6, 'US1', '21', '', '2025-06-09 21:36:40', 'US1', 'active', '15', '16'); -- -------------------------------------------------------- -- -- Table structure for table `temp_imports` -- CREATE TABLE `temp_imports` ( `id` int(11) NOT NULL, `employeeid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `firstname` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `lastname` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `job` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `position` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `section` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `department` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `employer` varchar(255) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `temp_imports` -- INSERT INTO `temp_imports` (`id`, `employeeid`, `firstname`, `lastname`, `email`, `job`, `position`, `section`, `department`, `location`, `employer`) VALUES (11, '10', 'Loning\'o', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (12, '11', 'Lowai', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (13, '12', 'Jane', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (14, '10', 'Loning\'o', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (15, '11', 'Lowai', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (16, '12', 'Jane', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (17, '10', 'Loning\'o', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (18, '11', 'Lowai', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (19, '12', 'Jane', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (20, '10', 'Loning\'o', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (21, '11', 'Lowai', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (22, '12', 'Jane', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (23, '10', 'Loning\'o', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (24, '11', 'Lowai', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (25, '12', 'Jane', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (26, '10', 'Loning\'o', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (27, '11', 'Lowai', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'), (28, '12', 'Jane', 'Mlengo', 'john@gmail.com', 'bottle washer', '9', '16', '14', '20', '18'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `fullname` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `status` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `mobile` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `department` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `signature` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `section` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(150) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `fullname`, `password`, `status`, `username`, `mobile`, `department`, `signature`, `section`, `title`, `email`) VALUES ('US1', 'Default User', '1234', 'active', 'admin', '0746371037', '15', 'maelekezo.PNG', '16', '8', 'eliasangito1997@gmail.com'), ('US10', 'Kulwa Marco', '123', 'active', 'kulwa', '06', '15', 'kulwa marco.png', '16', '12', ''), ('US11', 'Regina Mayala', '123', 'active', 'regina', '062', '15', 'regina ngusa.png', '16', '11', ''), ('US13', 'Godlisten Shirima', '123', 'active', 'godlisten', '05', '15', '', '16', '9', 'eliaf@mail.com'), ('US14', 'Juma', '123', 'active', 'juma', '054', '15', '', '16', '10', ''), ('US15', 'halima hyu', '123', 'active', 'halima', '098', '15', '', '16', '10', 'elia@mail.com'); -- -- Indexes for dumped tables -- -- -- Indexes for table `action` -- ALTER TABLE `action` ADD PRIMARY KEY (`id`); -- -- Indexes for table `employee` -- ALTER TABLE `employee` ADD PRIMARY KEY (`recid`); -- -- Indexes for table `incident` -- ALTER TABLE `incident` ADD PRIMARY KEY (`id`); -- -- Indexes for table `manifest` -- ALTER TABLE `manifest` ADD PRIMARY KEY (`id`); -- -- Indexes for table `masters` -- ALTER TABLE `masters` ADD PRIMARY KEY (`recid`); -- -- Indexes for table `roles_assignment` -- ALTER TABLE `roles_assignment` ADD PRIMARY KEY (`recid`); -- -- Indexes for table `temp_imports` -- ALTER TABLE `temp_imports` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `action` -- ALTER TABLE `action` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `employee` -- ALTER TABLE `employee` MODIFY `recid` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `incident` -- ALTER TABLE `incident` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `manifest` -- ALTER TABLE `manifest` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `masters` -- ALTER TABLE `masters` MODIFY `recid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `roles_assignment` -- ALTER TABLE `roles_assignment` MODIFY `recid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `temp_imports` -- ALTER TABLE `temp_imports` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; 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 */;