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

START TRANSACTION;



--
-- 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 `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 `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 `viathrough`
--
ALTER TABLE `viathrough`
  MODIFY `viathroughid` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

