-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Mar 25, 2024 at 03:26 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 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: `logisticsdb` -- -- -------------------------------------------------------- -- -- Table structure for table `agent` -- CREATE TABLE `agent` ( `agentid` int(11) NOT NULL, `agentname` varchar(200) DEFAULT NULL, `agentdescription` varchar(200) DEFAULT NULL, `agentcode` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `agent` -- INSERT INTO `agent` (`agentid`, `agentname`, `agentdescription`, `agentcode`) VALUES (1, ' DHL Tanzania Ltd', ' DHL Tanzania Ltd', ' DHL'), (2, 'KUEHNE AND NAGEL LTD (KN)', 'KUEHNE AND NAGEL LTD (KN)', 'K&N'), (3, 'Africa Global Logistics (AGL)', 'Africa Global Logistics (AGL)', 'AGL'), (4, 'Great Lakes Logistics and Consultancy Services (EA) Company Limited (GLLCS)', 'Great Lakes Logistics and Consultancy Services (EA) Company Limited (GLLCS)', 'GLLCS'), (5, 'ADL LOGISTICS', 'ADL LOGISTICS', 'ADL'), (6, 'UPS', 'UPS', 'UPS'), (7, 'Freight in Time', 'Freight in Time', 'FT'); -- -------------------------------------------------------- -- -- Table structure for table `comment` -- CREATE TABLE `comment` ( `commentid` int(11) NOT NULL, `commentdescription` text NOT NULL, `commentcreatedby` varchar(200) NOT NULL, `commentcreateddate` datetime NOT NULL, `Itno` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `comment` -- INSERT INTO `comment` (`commentid`, `commentdescription`, `commentcreatedby`, `commentcreateddate`, `Itno`) VALUES (1, 'Tracking in Draft', '1', '2024-03-20 00:00:00', '1'), (2, 'Testing Payment', '1', '2024-03-20 00:00:00', '1'), (3, 'Testing Agent', '1', '2024-03-21 00:00:00', '1'), (4, ' gg', '1', '2024-03-21 00:00:00', '1'), (5, 'df', '1', '2024-03-21 00:00:00', '1'), (6, 'Test', '1', '2024-03-22 00:00:00', '1'), (7, 'Test 2', '1', '2024-03-22 00:00:00', '1'), (8, 'ddd', '1', '2024-03-22 00:00:00', '1'), (9, 'Tracking in Draft', '1', '2024-03-22 00:00:00', '2'), (10, 'testing', '1', '2024-03-22 00:00:00', '2'), (11, 'Tracking in Draft', '1', '2024-03-22 00:00:00', '3'), (12, 'he', '1', '2024-03-25 00:00:00', '1'), (13, '2', '1', '2024-03-25 00:00:00', '1'), (14, 'g', '1', '2024-03-25 00:00:00', '1'), (15, 'sd', '1', '2024-03-25 00:00:00', '1'), (16, 'f', '1', '2024-03-25 00:00:00', '1'), (17, 'h', '1', '2024-03-25 00:00:00', '1'), (18, 'bb', '1', '2024-03-25 00:00:00', '1'), (19, 'h', '1', '2024-03-25 00:00:00', '1'), (20, 'ff', '1', '2024-03-25 00:00:00', '1'), (21, '1', '1', '2024-03-25 00:00:00', '1'), (22, 'dd', '1', '2024-03-25 00:00:00', '1'), (23, 'hh', '1', '2024-03-25 00:00:00', '1'), (24, 'hh', '1', '2024-03-25 00:00:00', '1'), (25, 'gg', '1', '2024-03-25 00:00:00', '1'), (26, 'hi', '1', '2024-03-25 00:00:00', '1'), (27, 'test', '1', '2024-03-25 00:00:00', '1'), (28, 'test', '1', '2024-03-25 00:00:00', '1'), (29, 'test', '1', '2024-03-25 00:00:00', '1'), (30, 'tttt', '1', '2024-03-25 00:00:00', '1'), (31, 'tt', '1', '2024-03-25 00:00:00', '1'), (32, 'yy', '1', '2024-03-25 00:00:00', '1'), (33, 'tt', '1', '2024-03-25 00:00:00', '1'), (34, 'tt', '1', '2024-03-25 00:00:00', '1'), (35, 'fggfg', '1', '2024-03-25 00:00:00', '1'); -- -------------------------------------------------------- -- -- Table structure for table `currencycode` -- CREATE TABLE `currencycode` ( `currencycodeid` int(11) NOT NULL, `currencycodename` varchar(200) DEFAULT NULL, `currencydescription` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `currencycode` -- INSERT INTO `currencycode` (`currencycodeid`, `currencycodename`, `currencydescription`) VALUES (1, 'Arab Emirates Dirha', 'AED'), (2, 'Arab Emirates Dirha', 'AED'), (3, 'Australian Dollar', 'AUD'), (4, 'Canadian Dollar', 'CAD'), (5, 'Swiss Franks', 'CHF'), (6, 'Euro', 'EUR'), (7, 'French Franks', 'FRF'), (8, 'Sterling Pounds', 'GBP'), (9, 'Indian Rupees', 'INR'), (10, 'Japanes Yen', 'JPY'), (11, 'Kenyan Shilling', 'KES'), (12, 'Qatar Riyal', 'QAR'), (13, 'South African Rand', 'RAND'), (14, 'Tanzanian Shilling', 'TZS'), (15, 'Swidish Kronor', 'SEK'), (16, 'US Dollars', 'USD'); -- -------------------------------------------------------- -- -- Table structure for table `department` -- CREATE TABLE `department` ( `departmentid` int(11) NOT NULL, `departmentname` varchar(200) NOT NULL, `departmentdescription` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `department` -- INSERT INTO `department` (`departmentid`, `departmentname`, `departmentdescription`) VALUES (1, 'PM: PLANT MANAGER', 'PM: PLANT MANAGER'), (2, 'TP: TEMPORARY', 'TP: TEMPORARY'), (3, 'AD: ADMIN', 'AD: ADMIN'), (4, 'FN: FINANCE', 'FN: FINANCE'), (5, 'HR: HUMAN RESOURCE', 'HR: HUMAN RESOURCE'), (6, 'SC: SUPPLY CHAIN', 'SC: SUPPLY CHAIN'), (7, 'BD: BUSINESS DEVELOPMENT', 'BD: BUSINESS DEVELOPMENT'), (8, 'OP: OPERATIONS', 'OP: OPERATIONS'), (9, 'TE: TECHNICAL', 'TE: TECHNICAL'), (10, 'HS: HEALTH AND SAFETY', 'HS: HEALTH AND SAFETY'), (11, 'MN: MAINTENANCE', 'MN: MAINTENANCE'), (12, 'IT: INFORMATION TECHNOLOGY', 'IT: INFORMATION TECHNOLOGY'), (13, 'CM: COMMERCIAL', 'CM: COMMERCIAL'), (14, 'GI: GAS AND INFRASTRUCTURE', 'GI: GAS AND INFRASTRUCTURE'), (15, 'PR: PUBLIC RELATION', 'PR: PUBLIC RELATION'); -- -------------------------------------------------------- -- -- Table structure for table `logisticsline` -- CREATE TABLE `logisticsline` ( `logisticsline` int(11) NOT NULL, `ponum` varchar(200) DEFAULT NULL, `Itno` int(11) NOT NULL, `orderdate` datetime DEFAULT NULL, `requireddate` datetime DEFAULT NULL, `vendorno` varchar(200) DEFAULT NULL, `companiesname` varchar(500) DEFAULT NULL, `paymentterms` varchar(200) DEFAULT NULL, `totalcost` varchar(200) DEFAULT NULL, `currencycode` varchar(200) DEFAULT NULL, `exchangerate` datetime DEFAULT NULL, `exchangerate2` varchar(200) DEFAULT NULL, `linedescription` text DEFAULT NULL, `lineorderqty` varchar(200) DEFAULT NULL, `lineunitcost` varchar(200) DEFAULT NULL, `linelinecost` varchar(200) DEFAULT NULL, `lineloadedcost` varchar(200) DEFAULT NULL, `receiptreq` varchar(200) DEFAULT NULL, `issue` varchar(200) DEFAULT NULL, `enterdate` datetime DEFAULT NULL, `cratedlineby` varchar(200) DEFAULT NULL, `receptline` varchar(200) DEFAULT NULL, `receptlinedate` datetime DEFAULT NULL, `receptlineby` varchar(200) DEFAULT NULL, `receivedqty` varchar(200) DEFAULT NULL, `requireddatepoline` datetime DEFAULT NULL, `reqdeliverydate` datetime DEFAULT NULL, `freightterms` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `logisticsline` -- INSERT INTO `logisticsline` (`logisticsline`, `ponum`, `Itno`, `orderdate`, `requireddate`, `vendorno`, `companiesname`, `paymentterms`, `totalcost`, `currencycode`, `exchangerate`, `exchangerate2`, `linedescription`, `lineorderqty`, `lineunitcost`, `linelinecost`, `lineloadedcost`, `receiptreq`, `issue`, `enterdate`, `cratedlineby`, `receptline`, `receptlinedate`, `receptlineby`, `receivedqty`, `requireddatepoline`, `reqdeliverydate`, `freightterms`) VALUES (1, 'PO2317259', 1, '2023-02-08 09:38:54', '2023-05-31 11:39:00', 'EFP000001', 'EFP EXPORT INDUSTRIE SERVICE GmbH', '30 DAYS', '2369.26', 'EUR', '0000-00-00 00:00:00', '2699.0476190', 'TAPER BUSHING BROWNING P/N: R1- 3.3/4\" HS CODE :84835020 ORIGIN :US', '2.00', '176.82', '353.64', '353.64', NULL, NULL, '2024-03-20 14:23:22', '1', NULL, NULL, NULL, '', '2023-05-31 11:39:00', '2023-02-22 00:00:00', ''), (2, 'PO2317259', 1, '2023-02-08 09:38:54', '2023-05-31 11:39:00', 'EFP000001', 'EFP EXPORT INDUSTRIE SERVICE GmbH', '30 DAYS', '2369.26', 'EUR', '0000-00-00 00:00:00', '2699.0476190', 'SHEAVE BROWNING P/N: 6R5V85 HS CODE :84835020 ORIGIN :US', '2.00', '552.71', '1105.42', '1105.42', NULL, NULL, '2024-03-20 14:23:22', '1', NULL, NULL, NULL, '', '2023-05-31 11:39:00', '2023-02-22 00:00:00', ''), (3, 'PO2317259', 1, '2023-02-08 09:38:54', '2023-05-31 11:39:00', 'EFP000001', 'EFP EXPORT INDUSTRIE SERVICE GmbH', '30 DAYS', '2369.26', 'EUR', '0000-00-00 00:00:00', '2699.0476190', 'BUSHING BROWNING P/N: SH 1.5/8\" HS CODE :84835020 ORIGIN: US', '5.00', '40.02', '200.10', '200.10', NULL, NULL, '2024-03-20 14:23:22', '1', NULL, NULL, NULL, '', '2023-05-31 11:39:00', '2023-02-22 00:00:00', ''), (4, 'PO2317259', 1, '2023-02-08 09:38:54', '2023-05-31 11:39:00', 'EFP000001', 'EFP EXPORT INDUSTRIE SERVICE GmbH', '30 DAYS', '2369.26', 'EUR', '0000-00-00 00:00:00', '2699.0476190', 'PULLEY BROWNING P/N: 43V365SH HS CODE :84835020 ORIGIN :US', '5.00', '142.02', '710.10', '710.10', NULL, NULL, '2024-03-20 14:23:22', '1', NULL, NULL, NULL, '', '2023-05-31 11:39:00', '2023-02-22 00:00:00', ''), (5, 'PO2317261', 2, '2023-02-08 09:40:39', '2023-09-30 13:06:00', 'SIE000001', 'Siemens Energy AB', '30 DAYS', '779900.00', 'SEK', '0000-00-00 00:00:00', '236.9047619', 'Freight charges', '1.00', '30000.00', '30000.00', '30000.00', NULL, NULL, '2024-03-22 10:27:24', '1', NULL, NULL, NULL, '', '2023-09-30 13:06:00', '2023-09-30 00:00:00', ''), (6, 'PO2317261', 2, '2023-02-08 09:40:39', '2023-09-30 13:06:00', 'SIE000001', 'Siemens Energy AB', '30 DAYS', '779900.00', 'SEK', '0000-00-00 00:00:00', '236.9047619', 'Cost for purchasing of UGT2 expansion joint. Material E1B100955681.', '1.00', '749900.00', '749900.00', '749900.00', NULL, NULL, '2024-03-22 10:27:24', '1', NULL, NULL, NULL, '', '2023-09-30 13:06:00', '2023-09-30 00:00:00', ''), (7, 'PO2317506', 3, '2023-04-18 14:42:09', '2023-07-24 12:07:00', 'EFP000001', 'EFP EXPORT INDUSTRIE SERVICE GmbH', '30 DAYS', '1349.15', 'EUR', '0000-00-00 00:00:00', '2768.3453237', 'SEALANT SIKAFLEX -221 MULTPURPOSE', '48.00', '8.49', '407.52', '407.52', NULL, NULL, '2024-03-22 11:00:22', '1', NULL, NULL, NULL, '48.00', '2023-07-24 12:07:00', '2023-07-24 00:00:00', ''), (8, 'PO2317506', 3, '2023-04-18 14:42:09', '2023-07-24 12:07:00', 'EFP000001', 'EFP EXPORT INDUSTRIE SERVICE GmbH', '30 DAYS', '1349.15', 'EUR', '0000-00-00 00:00:00', '2768.3453237', 'CABLES SHRINKING TUBE 1.6MMX12M', '1.00', '30.33', '30.33', '30.33', NULL, NULL, '2024-03-22 11:00:22', '1', NULL, NULL, NULL, '1.00', '2023-07-24 12:07:00', '2023-07-24 00:00:00', ''), (9, 'PO2317506', 3, '2023-04-18 14:42:09', '2023-07-24 12:07:00', 'EFP000001', 'EFP EXPORT INDUSTRIE SERVICE GmbH', '30 DAYS', '1349.15', 'EUR', '0000-00-00 00:00:00', '2768.3453237', 'RELY AUXILIARY RXMB1-804 1MRK000804AN', '1.00', '273.01', '273.01', '273.01', NULL, NULL, '2024-03-22 11:00:22', '1', NULL, NULL, NULL, '', '2023-07-24 12:07:00', '2023-07-24 00:00:00', ''), (10, 'PO2317506', 3, '2023-04-18 14:42:09', '2023-07-24 12:07:00', 'EFP000001', 'EFP EXPORT INDUSTRIE SERVICE GmbH', '30 DAYS', '1349.15', 'EUR', '0000-00-00 00:00:00', '2768.3453237', 'UV DETECTOR SUPPORT Q9033B1000', '1.00', '638.29', '638.29', '638.29', NULL, NULL, '2024-03-22 11:00:22', '1', NULL, NULL, NULL, '1.00', '2023-07-24 12:07:00', '2023-07-24 00:00:00', ''); -- -------------------------------------------------------- -- -- Table structure for table `logistictrack` -- CREATE TABLE `logistictrack` ( `Itno` int(11) NOT NULL, `datedocumentsreceived` date DEFAULT NULL, `shipment` varchar(200) NOT NULL, `reference` varchar(200) DEFAULT NULL, `purchaseno` varchar(200) DEFAULT NULL, `po_invamount` varchar(200) DEFAULT NULL, `termsofpayment` varchar(200) DEFAULT NULL, `freightterms` varchar(200) DEFAULT NULL, `type` varchar(200) DEFAULT NULL, `vendorname` varchar(200) DEFAULT NULL, `goodsdescription` text DEFAULT NULL, `modeoftrans` varchar(200) DEFAULT NULL, `ttdatetovendor` varchar(200) DEFAULT NULL, `orderacknoledgementdate` date DEFAULT NULL, `expecteddispatchdate` date DEFAULT NULL, `dispatchdate` date DEFAULT NULL, `etadar` date DEFAULT NULL, `differencepovsinv` varchar(200) DEFAULT NULL, `wbno` varchar(200) DEFAULT NULL, `arrdate` date DEFAULT NULL, `datedocsenttoagent` date DEFAULT NULL, `regno` varchar(200) DEFAULT NULL, `regdate` date DEFAULT NULL, `assno` varchar(200) DEFAULT NULL, `assdate` date DEFAULT NULL, `hscodeapprovedbytra` date DEFAULT NULL, `releaseorderdatebycustoms` varchar(200) DEFAULT NULL, `actualdeliverydate` date DEFAULT NULL, `userdepartment` varchar(200) DEFAULT NULL, `amount` varchar(200) DEFAULT NULL, `remarks` text DEFAULT NULL, `invno` varchar(200) DEFAULT NULL, `amountog` varchar(200) DEFAULT NULL, `dimension` varchar(200) DEFAULT NULL, `weight` varchar(200) DEFAULT NULL, `agentname` varchar(200) DEFAULT NULL, `c15ref` varchar(200) DEFAULT NULL, `tax_i_duty` varchar(200) DEFAULT NULL, `tax_e_duty` varchar(200) DEFAULT NULL, `tax_vat` varchar(200) DEFAULT NULL, `vat_o_charges` varchar(200) DEFAULT NULL, `totaltaxespayable` varchar(200) DEFAULT NULL, `ateoftt` varchar(200) DEFAULT NULL, `agentinvoiceno` varchar(200) DEFAULT NULL, `currencyteype` varchar(200) DEFAULT NULL, `progressstatus` varchar(200) DEFAULT NULL, `otherdescription` text DEFAULT NULL, `currentcomments` text DEFAULT NULL, `extralines` varchar(200) DEFAULT NULL, `lcreatedby` varchar(200) DEFAULT NULL, `createddate` date DEFAULT NULL, `approvername1` varchar(200) DEFAULT NULL, `approvername2` varchar(200) DEFAULT NULL, `approver1comment` text DEFAULT NULL, `approver2comment` text DEFAULT NULL, `supplierid` varchar(200) DEFAULT NULL, `agentid` varchar(200) DEFAULT NULL, `trackstatus` varchar(200) DEFAULT NULL, `departmentname` varchar(200) NOT NULL, `actuallinedeliverydate` datetime DEFAULT NULL, `porequireddate` datetime DEFAULT NULL, `poexpectdeliverdate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `logistictrack` -- INSERT INTO `logistictrack` (`Itno`, `datedocumentsreceived`, `shipment`, `reference`, `purchaseno`, `po_invamount`, `termsofpayment`, `freightterms`, `type`, `vendorname`, `goodsdescription`, `modeoftrans`, `ttdatetovendor`, `orderacknoledgementdate`, `expecteddispatchdate`, `dispatchdate`, `etadar`, `differencepovsinv`, `wbno`, `arrdate`, `datedocsenttoagent`, `regno`, `regdate`, `assno`, `assdate`, `hscodeapprovedbytra`, `releaseorderdatebycustoms`, `actualdeliverydate`, `userdepartment`, `amount`, `remarks`, `invno`, `amountog`, `dimension`, `weight`, `agentname`, `c15ref`, `tax_i_duty`, `tax_e_duty`, `tax_vat`, `vat_o_charges`, `totaltaxespayable`, `ateoftt`, `agentinvoiceno`, `currencyteype`, `progressstatus`, `otherdescription`, `currentcomments`, `extralines`, `lcreatedby`, `createddate`, `approvername1`, `approvername2`, `approver1comment`, `approver2comment`, `supplierid`, `agentid`, `trackstatus`, `departmentname`, `actuallinedeliverydate`, `porequireddate`, `poexpectdeliverdate`) VALUES (1, '2023-02-08', '', NULL, 'PO2317259', '2369.26', '30 DAYS', '', '', 'EFP EXPORT INDUSTRIE SERVICE GmbH', 'SUPPLY OF OIL COOLER MOTOR SHEEVE AND TURBINE VENT FAN AND THEIR SPLIT TAPER BUSHINGS', '', '', '2024-03-22', '2024-03-22', '2024-03-22', '2024-03-22', '1369.26', '', '2024-03-22', '2024-03-22', '', '2024-03-22', '', '2024-03-22', '2024-03-22', '', '2024-03-22', 'kayus', '1000', '', '10203', '1000', '', '', 'Great Lakes Logistics and Consultancy Services (EA) Company Limited (GLLCS)', '', '', '', '', '', '', '', '3445545', 'EUR', '', '', '', '', '1', '2024-03-20', NULL, NULL, NULL, NULL, '', '', '1', 'IT: INFORMATION TECHNOLOGY', '2023-05-31 11:39:00', '2023-05-31 11:39:00', NULL), (2, '2023-02-08', '', NULL, 'PO2317261', '779900.00', '30 DAYS', '', '', 'Siemens Energy AB', 'Supply of Diffuser Expansion Joint for Ugt2 Replacement', '', '', '0000-00-00', '0000-00-00', '0000-00-00', '0000-00-00', '79900', '', '0000-00-00', '0000-00-00', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '0000-00-00', '', '700000', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'SEK', '', '', '', '', '1', '2024-03-22', NULL, NULL, NULL, NULL, '', '', '1', 'IT: INFORMATION TECHNOLOGY', '2023-09-30 13:06:00', '2023-09-30 13:06:00', NULL), (3, '2023-04-18', '', NULL, 'PO2317506', '1349.15', '30 DAYS', '', NULL, 'EFP EXPORT INDUSTRIE SERVICE GmbH', 'SUPPLY OF VARIOUS ITEMS FOR INVENTORY REPLENISHMENT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'EUR', NULL, NULL, NULL, NULL, '1', '2024-03-22', NULL, NULL, NULL, NULL, NULL, NULL, '1', 'IT: INFORMATION TECHNOLOGY', '2023-07-24 12:07:00', '2023-07-24 12:07:00', NULL); -- -------------------------------------------------------- -- -- Table structure for table `paymentmode` -- CREATE TABLE `paymentmode` ( `paymentid` int(11) NOT NULL, `paymentmodename` varchar(200) DEFAULT NULL, `paymentmodedescription` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `regimetype` -- CREATE TABLE `regimetype` ( `regimetypeid` int(11) NOT NULL, `regimename` varchar(200) DEFAULT NULL, `regimecode` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id` int(11) NOT NULL, `username` varchar(255) NOT NULL, `auth_key` varchar(32) NOT NULL, `password_hash` varchar(255) NOT NULL, `password_reset_token` varchar(255) DEFAULT NULL, `email` varchar(255) NOT NULL, `status` smallint(6) NOT NULL DEFAULT 10, `created_at` int(11) NOT NULL, `updated_at` int(11) NOT NULL, `verification_token` varchar(255) DEFAULT NULL, `usercategory` int(11) DEFAULT NULL, `dbsession` varchar(200) DEFAULT NULL, `firstname` varchar(200) NOT NULL, `lastname` varchar(200) NOT NULL, `sex` varchar(200) NOT NULL, `departmentid` int(11) NOT NULL, `telextensionno` varchar(200) NOT NULL, `mobilenumber` varchar(200) NOT NULL, `userstatus` varchar(200) NOT NULL, `joineddate` varchar(200) NOT NULL, `exitdate` varchar(200) NOT NULL, `designationdesc` varchar(200) NOT NULL, `createdby` varchar(200) NOT NULL, `createddate` date NOT NULL, `createdtime` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `username`, `auth_key`, `password_hash`, `password_reset_token`, `email`, `status`, `created_at`, `updated_at`, `verification_token`, `usercategory`, `dbsession`, `firstname`, `lastname`, `sex`, `departmentid`, `telextensionno`, `mobilenumber`, `userstatus`, `joineddate`, `exitdate`, `designationdesc`, `createdby`, `createddate`, `createdtime`) VALUES (1, 'kayus.patrice', 'ZDOsKT8sWEncFGAe7sMQJvZfyxsXXJj7', '$2y$13$9/ZqvycJhKZVIaKqDkATZO0CBDJLz7sK3/Kw3Sqtw9Ra7Pr.A6CXC', NULL, 'kayus.patrice@songas.com', 10, 1675502738, 1675502738, 'y1NJNMHCWveQWUEjB2DxolwNjSXo7rPC_1675502738', NULL, 'TEST', 'Kayus', 'Patrice', '', 12, '', '', '', '', '', '', '', '0000-00-00', '0000-00-00'), (2, 'sunil.ved', '_N-NxHcg6-VkDqEjSJGw9EQH4fg0lfWl', '$2y$13$F32m1Vyg4j2F0qAlMXAVBu9lrFdHh2Xp4t9TwLf8Q0SVLcn9ZoNsm', NULL, 'sunil.ved@songas.com', 10, 1675502772, 1675502772, 'Sab4mCUSgrNalr79zX7jbakMUhOWSQtL_1675502772', 1, 'TEST', 'Sunil', 'Ved', '', 12, '', '', '', '', '', '', '', '0000-00-00', '0000-00-00'), (3, 'oforo.shayo', '$2y$10$U66DiuxWMX84NNvPAjUOouqwP', '$2y$13$IAyGg8.rgRLTOp/wI3ugI.AaTG3i5m5/QBIvzjFAsDdT8hLJJV3Am', NULL, 'oforo.shayo@songas.com', 10, 1701257262, 1701257262, '1RaNiPhtCn2aRDKvXvhqvcmXe2dlA_NS_1701257262', NULL, 'TEST', 'Oforo', 'shayo', '', 8, '', '', '', '', '', '', 'kayus.patrice', '0000-00-00', '0000-00-00'), (4, 'john.maitaria', 'o1NyxTsr_IKEvdxVzhfvT_-GxgDfcp08', '$2y$13$ufnqQzl64Qew74g1.9Gw9OIuBjnumTlStSFsEB/wh3NmPEvZ8kQkq', NULL, 'john.maitaria@songas.com', 10, 1701257308, 1701257308, '8ChcHeIrEcn5bKkYn1RT6X05YzqA6i0X_1701257308', NULL, 'TEST', 'John', 'Maitaria', '', 10, '', '', '', '', '', '', 'kayus.patrice', '0000-00-00', '0000-00-00'), (5, 'nickson.moses', '97zEu1C1nYNQfa_tYrjQplkh4nxaA9Ic', '$2y$13$cD7lqI.GTBnlPG3Ej3dEjucORwfQXXM2FqQBOHh3OQ/u4jIFQtiDa', NULL, 'nickson.moses@songas.com', 10, 1701257347, 1701257347, 'Lf2509GRsC2gIlLOGqNXHJUXA2pEl2hA_1701257347', NULL, 'TEST', 'nickson', 'moses', '', 11, '', '', '', '', '', '', 'kayus.patrice', '0000-00-00', '0000-00-00'), (6, 'martin.mngodo', 'qQNOFJbFOWZbrQM6Ts3a8S-pR-SOlKg2', '$2y$13$TbnjePGpj/4/39ouZCAWkeepBOlBq158rKKKmT8X/Y2LV5UOeMWR2', NULL, 'martin.mngodo@songas.com', 10, 1703080753, 1703080753, 'vvU1DemETjMxC5cjVvziUaWDGxzNwxrW_1703080753', NULL, NULL, '', '', '', 12, '', '', '', '', '', '', '', '0000-00-00', '0000-00-00'), (7, 'heradius.chami', 'NpwUbS0DQmpFxi9XeBSJi6c07WNNZbeB', '$2y$13$LVmPD1xmcOARC.kHZOKZg.H6WAnE7dTiDdvEehV4QzSCxAIR7RuS6', NULL, 'heradius.chami@songas.com', 10, 1703140364, 1703140364, 'burL5GPakVoCdziE35wLWvvalIhd_eni_1703140364', NULL, NULL, 'heradius', 'chami', 'male', 8, '', '', '', '', '', '', 'kayus.patrice', '2023-12-21', '0000-00-00'), (8, 'saidi.mussa', 'WNWu18RqSuXGQpL62pOLAJgCwvBGEQXk', '$2y$13$hsPoJG1Wy9sPLF6UdooEQuytP8fL3RD9qv.uhUscAm9UG/Kyh28sG', NULL, 'saidi.mussa@songas.com', 10, 1703225675, 1703225675, 'kzu3KmLGgIHMun-tBtIl4qRfmAYbxlTR_1703225675', NULL, NULL, 'saidi', 'mussa', 'male', 8, '', '', '', '', '', '', 'kayus.patrice', '0000-00-00', '0000-00-00'), (10, 'salehe.salum', 'ZbATibJjU0nJaFvgDw6AUCkYFqbxhByA', '$2y$13$7ki24mVzVxQZZpEjgfGbnea4QTJRV/4SLZimltg6sH4wQFtB462x.', NULL, 'salehe.salum@songas.com', 10, 1706160226, 1706160226, 'Kdlkz-Qyp8LUC7HaFyuQxXYqSpGBe9SV_1706160226', NULL, NULL, '', '', '', 1, '', '', '', '', '', '', '', '0000-00-00', '0000-00-00'), (12, 'mussa.ndanzi', '36HERXG32sqFJuhVRDr2EA52i-ulH6L-', '$2y$13$xdgh5HOvJJfKLyyt/ZC5H.puU83yxaeBJ/U4Ur38G.gx.AsoezPpu', NULL, 'mussa.ndanzi@songas.com', 10, 1706160334, 1706160334, 'JIgv_YN4V2HXGkV7Ath36UzO2UkapZk6_1706160334', NULL, NULL, '', '', '', 10, '', '', '', '', '', '', '', '0000-00-00', '0000-00-00'), (13, 'ignatus.laurian', 'xXzn-aKT0ghlVdNQUru_oBSXtPc0nwvj', '$2y$13$Huc29yoBHyf2mdMDW5oLyenrlCY.PC5.Uv1LTeWXexm3RqHamc6Yy', NULL, 'ignatus.laurian@songas.com', 10, 1706160422, 1706160422, 'VU6s1wx6DmAijRN91chVuPtm4t6XT1_g_1706160422', NULL, NULL, '', '', '', 10, '', '', '', '', '', '', '', '0000-00-00', '0000-00-00'), (14, 'hamza.hamis', 'upkgatkURaZexqdLs7cfuwsiWOzM-VVi', '$2y$13$/CwRheOpBvizkHoavq5gQ.eJymaHjLOaYHgx7dSDwbaC9V8bzTVGy', NULL, 'hamza.hamis@songas.com', 10, 1706160519, 1706160519, 'ucRTIX31PTkuIrKzucHMuh4LM_INnBY0_1706160519', NULL, NULL, '', '', '', 10, '', '', '', '', '', '', '', '0000-00-00', '0000-00-00'), (15, 'mary.mwanukuzi', 'Y4Md6xDv34FYcCBFlDLthWnbhqzTg3yK', '$2y$13$0eK.imOFAVzurTvg6QEy8ujMG5oDYxMUpHUVkWM/HLMv9wz1X9h1q', NULL, 'mary.mwanukuzi@songas.com', 10, 1706599656, 1706599656, 'WPbGDocMwmph92aWJeh9SZILAouaBqiV_1706599656', NULL, NULL, '', '', '', 9, '', '', '', '', '', '', 'kayus.patrice', '2024-01-30', '2024-01-30'), (16, 'joseph.msiyani', 'JxYDr8xqS5N-b3Q6blH0RbAdnNmOT92E', '$2y$13$oArzE/aYIYbW7nv3VmMBzeuCOqWGYm6avBhthO8F5D3dgaV8jGWYq', NULL, 'joseph.msiyani@songas.com', 10, 1706599696, 1706599696, '3yN5j8ld-W6AHKcfqPYGflX3JIw7QHVs_1706599696', NULL, NULL, '', '', '', 8, '', '', '', '', '', '', '', '0000-00-00', '0000-00-00'), (17, 'thomas.nagagwa', 'NbMd2DOgdizWpAdgDgzk_AOCcuM0ltQv', '$2y$13$RE45u2CKBM3gbrWk6/kSiOPpPL3ddIGCs/BRY6wtuecHWuP8cuIkO', NULL, 'thomas.nagagwa@sonagas.com', 10, 1706601125, 1706601125, 'Yvs2zMfgWoDBmUBwl_xjpKi5i1ZjBawT_1706601124', NULL, NULL, '', '', '', 8, '', '', 'Active', '', '', '', 'kayus.patrice', '0000-00-00', '0000-00-00'), (18, 'samwel.nganyira', 'NbMd2DOgdizWpAdgDgzk_AOCcuM0ltQv', '$2y$13$RE45u2CKBM3gbrWk6/kSiOPpPL3ddIGCs/BRY6wtuecHWuP8cuIkO', NULL, 'samwel.nganyira@songas.com', 10, 1706601387, 1706601387, 'ZMO3FuFK_j6fUXaGIJgaOYPr06EKzxSZ_1706601387', NULL, NULL, '', '', '', 8, '', '', '', '', '', '', 'kayus.patrice', '2024-01-30', '2024-01-30'); -- -------------------------------------------------------- -- -- Table structure for table `viathrough` -- CREATE TABLE `viathrough` ( `viathroughid` int(11) NOT NULL, `viathroughname` varchar(200) DEFAULT NULL, `viathroughdescription` varchar(200) DEFAULT NULL, `viacode` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `agent` -- ALTER TABLE `agent` ADD PRIMARY KEY (`agentid`), ADD KEY `agentname` (`agentname`); -- -- Indexes for table `comment` -- ALTER TABLE `comment` ADD PRIMARY KEY (`commentid`); -- -- Indexes for table `currencycode` -- ALTER TABLE `currencycode` ADD PRIMARY KEY (`currencycodeid`); -- -- Indexes for table `department` -- ALTER TABLE `department` ADD PRIMARY KEY (`departmentid`); -- -- Indexes for table `logisticsline` -- ALTER TABLE `logisticsline` ADD PRIMARY KEY (`logisticsline`), ADD KEY `Itno` (`Itno`); -- -- Indexes for table `logistictrack` -- ALTER TABLE `logistictrack` ADD PRIMARY KEY (`Itno`), ADD KEY `agentname` (`agentname`); -- -- Indexes for table `paymentmode` -- ALTER TABLE `paymentmode` ADD PRIMARY KEY (`paymentid`); -- -- Indexes for table `regimetype` -- ALTER TABLE `regimetype` ADD PRIMARY KEY (`regimetypeid`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`), ADD UNIQUE KEY `password_reset_token` (`password_reset_token`); -- -- Indexes for table `viathrough` -- ALTER TABLE `viathrough` ADD PRIMARY KEY (`viathroughid`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `agent` -- ALTER TABLE `agent` MODIFY `agentid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `comment` -- ALTER TABLE `comment` MODIFY `commentid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36; -- -- AUTO_INCREMENT for table `currencycode` -- ALTER TABLE `currencycode` MODIFY `currencycodeid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `department` -- ALTER TABLE `department` MODIFY `departmentid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `logisticsline` -- ALTER TABLE `logisticsline` MODIFY `logisticsline` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `logistictrack` -- ALTER TABLE `logistictrack` MODIFY `Itno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `paymentmode` -- ALTER TABLE `paymentmode` MODIFY `paymentid` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `regimetype` -- ALTER TABLE `regimetype` MODIFY `regimetypeid` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `viathrough` -- ALTER TABLE `viathrough` MODIFY `viathroughid` int(11) NOT NULL AUTO_INCREMENT; 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 */;