-- MySQL dump 10.13  Distrib 5.7.34, for Linux (x86_64)
--
-- Host: 103.76.231.167    Database: sjcrett5_truck_icd
-- ------------------------------------------------------
-- Server version	5.6.42-84.2

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `agent_list`
--

DROP TABLE IF EXISTS `agent_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agent_list` (
  `agl_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `agl_name` varchar(500) NOT NULL,
  `agl_phone` varchar(200) NOT NULL,
  `agl_email` varchar(500) NOT NULL,
  `agl_creatded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`agl_id`)
) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agent_list`
--

LOCK TABLES `agent_list` WRITE;
/*!40000 ALTER TABLE `agent_list` DISABLE KEYS */;
INSERT INTO `agent_list` VALUES (1,'ALLMOLL FREIGHT SERVICES LTD','9874563210','ALLMOLL@gmail.com','2019-05-31 23:54:43'),(2,'KIKARARA CLEARING AND FORWARDING','9874563210','KIKARARA@gmail.com','2019-05-31 23:55:07'),(3,'BOLLORE TRANSPORT & LOGISTICS TANZANIA','9874563210','BOLLORE @gmail.com','2019-05-31 23:55:58'),(4,'MADINA CLEARING AND FORWARDING AGENT','9874563210','MADINA @gmail.com','2019-05-31 23:56:17'),(5,'B & M FREIGHT FORWARDERS CO. LTD','9874563210','bm@gmail.com','2019-05-31 23:56:37'),(6,'CARGO STREAMS LIMITED','9874563210','cargo@gmail.com','2019-05-31 23:56:55'),(7,'MARINAIR FREIGHT LIMITED','9874563210','MARINAIR @gmail.com','2019-05-31 23:57:43'),(8,'BUSINESS INDEX LIMITED','9874563210','BUSINESS @gmail.com','2019-05-31 23:58:00'),(9,'CLARION LOGISTICS LIMITED','9874563210','CLARION@gmail.com','2019-05-31 23:58:22'),(10,'FIRST VISION (T) LTD','+255222137561','info@firstvision.co.tz','2019-08-28 07:24:29'),(11,'BATMAC COMPANY LIMITED','+255713444955','batmacoltd@gmail.com','2019-08-28 07:26:46'),(12,'JOEM LOGISTICS','+255713570031','joemlogistics@gmail.com','2019-08-28 07:29:50'),(13,'HODARI FREIGHT LTD','+255222132236','hodari.forwarders2014@gmail.com','2019-08-28 07:34:19'),(14,'SEJAFRICA CARGO FREIGHT LTD','+255222180978','sejafrica@yahoo.com','2019-08-28 07:43:56'),(15,'GO-LINK EXPRESS CO. LTD','+255222129884','go_linkexpress@yahoo.com','2019-08-28 07:46:12'),(16,'GUIDE LOGISTICS LIMITED','+255754280556','guidelogistics@gmail.com','2019-08-28 07:48:40'),(17,'Z&A TRADING COMPANY LIMITED','+255715464019','znaclearing@gmail.com','2019-08-28 07:53:04'),(18,'SAFETY SKY LOGISTICS CO. LIMITED','+255787448822','safetyskylogistics@gmail.com','2019-08-28 07:55:13'),(19,'21ST CENTURY FREIGHT FORWARDERS LTD','+2552552128225','21centuryff@gmail.com','2019-08-28 07:58:13'),(20,'SINO LOGISTICS CO. LTD','+255222136981','info@sinologistics.co.tz','2019-08-28 08:02:52'),(21,'RHINO AFRICA LTD','+255787486556','solanki@rhinoafrica.co.tz','2019-08-28 08:05:45'),(22,'VAMWE INVESTMENTS CO. LTD','+25522128720','info@vamweinvestments.com','2019-08-28 08:07:52'),(23,'NEMART\'S  LTD','+255754272718','nemartsltd@gmail.com','2019-08-28 08:17:48'),(24,'ROLMAN AGENCIES (T)  LTD','+255787552828','rolmanlogistics@yahoo.com','2019-08-28 08:19:18'),(25,'SHAKURA TRADE SERVICES LIMITED','+255222128867','info@shakuratrade.com','2019-08-28 08:20:41'),(26,'BEZECO  COMPANY LIMITED','+255788531663','bezecolimited@gmail.com','2019-08-28 08:27:14'),(27,'BNM COMPANY LIMITED','+255787143434','import@bnmfreight.com','2019-08-28 08:34:01'),(28,'PLATINUM TRADING COMPANY LTD','+255222136772','0','2019-08-28 08:37:23'),(29,'SAMMY AND SONS COMPANY LIMITED','+25522113609','info.sammyandsons@gmail.com','2019-08-28 08:40:14'),(30,'WHYMBIFREIGHT CO. LTD','+255222127238','-','2019-08-28 08:43:28'),(31,'ALLMOL FREIGHT SERVICES LTD','+255222126287','allmolfreightltd@gmail.com','2019-08-28 09:02:40'),(32,'BSG FREIGHT FORWADERS CO. LTD','+255714633666','bsg_freightforwaders@yahoo.com','2019-08-28 09:05:09'),(33,'JOINT SOURCE LOGISTICS','+255','jointsourcelogistics@gmail.com','2019-08-28 10:08:22'),(34,'DARFFOR ENTERPRISES LIMITED','+255222126008','customercare@darfforenterprisesltd.com','2019-08-29 09:48:50'),(35,'CHRISTIAN COUNCIL OF TANZANIA','+255222862323','director@wama-cct.org','2019-08-29 09:50:08'),(36,'TAN-TRAFFIC FORWADERS LIMITED','+255222185040','tantraffic@yahoo.com','2019-08-29 10:15:18'),(37,'BEST SERVICES LIMITED','+255222129871','bestservicesltd@yahoo.com','2019-08-29 10:17:05'),(38,'K&K COMPANY LTD','+255222114485','info@kkcompany.co.tz','2019-08-29 10:18:17'),(39,'LUNA FREIGHT CO. LIMITED','+255767513875','lunafreightpa@gmail.com','2019-08-29 10:19:47'),(40,'RURU','+255785819943','admin@ruru.co.tz','2019-08-29 10:21:08'),(41,'ASTRA FREIGHT AND FORWARDERS LIMITED','+255713428078','astrafreight@gmail.com','2019-08-29 10:23:25'),(42,'ENTERPRISE LOGISTICS CO. LTD','+255222113702','enterprise.logistics@yahoo.co.uk','2019-08-29 10:26:33'),(43,'CHELSEA STARWAY LIMITED','+255744300400','chelseaclearing@gmail.com','2019-08-29 10:28:59'),(44,'UTEGI TECHNICAL ENTERPRISES (INTL) LTD','+255222126566','info@utegitechnical.co.tz','2019-08-29 10:31:09'),(45,'LESIDI GENERAL CARGO LTD','+255713250535','lesidigeneral@gmail.com','2019-08-29 10:32:25'),(46,'JAMBO KWANZA LTD','+255717482888','jambo.kwanza2010@gmail.com','2019-08-29 10:33:51'),(47,'KING\'S D&G BUSINESS (T) LTD','+255655734784','olawe2002@yahoo.com','2019-08-29 10:35:29'),(48,'HAN\'S WORLDWIDE SERVICES LTD','+255222112201','hansworldwide@gmail.com','2019-08-29 10:38:48'),(49,'NM FREIGHT TANZANIA LIMITED','+255222137188','nmfreight@neso.co.tz','2019-08-29 12:46:07'),(50,'MISSONGA FREIGHTERS (T) LIMITED','+255222123962','missongaltd@gmail.com','2019-08-29 12:50:35'),(51,'TAJIRI FREIGHT COMPANY LIMITED','+255756666636','Tj.freight.co@gmail.com','2019-08-29 12:52:23'),(52,'TOWERS CARGO AGENCIES LTD','+255713304724','towerscargo@gmail.com','2019-08-29 12:56:30'),(53,'TRYCE AGENCY (T) LTD','+255717432184','tryceagency@outlook.com','2019-08-29 13:00:28'),(54,'FLEXCODES COMPANY LIMITED','+255625405050','flexcodes@yahoo.com','2019-08-29 13:02:01'),(55,'GENERAL ENVIROCARE SOLUTIONS','+255222137488','info@generalenvirocare.com','2019-08-29 13:06:26'),(56,'ABUAND INVESTMENT COMPANY LIMITED','+255715060860','abuandlimited@gmail.com','2019-08-29 13:09:08'),(57,'PALM SWIFT (T) LTD','+255222183799','-','2019-08-29 13:10:55'),(58,'AZIMAR INVESTMENT CO. LTD','+255748270772','azimar1960@yahoo.com','2019-08-29 13:13:31'),(59,'SWEET & SHINE INTERNATIONAL LOGISTRICS','+255714133997','dicksonsweetandshine.co.tz','2019-08-29 13:18:01'),(60,'LOBAFE INTERNATIONAL LTD','-','-','2019-08-29 13:20:16'),(61,'SMART CLEARING & FORWARDERS LIMITED','+255222122296','smart_clearing@yahoo.com','2019-08-29 13:25:05'),(62,'TRINITY LOGISTICS (T) LTD','+255222924203','-','2019-08-29 13:27:41'),(63,'FORTE FREIGHTING','+255222129186','info@fortefreighting.com','2019-08-29 13:30:20'),(64,'ANCHOR CLEARING & FORWADERS LTD','+255222111808','anchorcf@gmail.com','2019-08-29 13:33:04'),(66,'SIMBA CLEARING AND FREIGHT FORWARDING','0713622150','simbaclearing@CO.TZ','2020-09-11 16:23:28'),(67,'CUSNA INVESTMENT LIMITED','9874563210','test@icd.com','2019-09-23 12:53:15'),(68,'TANZANIA SHIPPING AGENCIES CORPORATION','9874563210','demo@gmail.com','2019-11-09 09:12:16'),(69,'HELLMANN INTERNATIONAL LIMITED','123456789','cargo@gmail.com','2020-04-22 11:13:49'),(70,'SIX IN ONE(T) LIMITED','1234567','cargo@gmail.com','2020-04-23 09:06:25'),(71,'REI LOGISTICS LTD','12345678','abc@gmail.com','2020-05-02 12:58:24'),(72,'BULEMBO TRADERS LIMITED','123455678','abc@xyz.com','2020-05-04 11:01:36'),(73,'INTERWORLD LOGISTICS COMPANY LIMITED','12345678','interworld@abc.com','2020-05-04 11:02:09'),(74,'PAMYCO LIMITED','123456789','abc@gmail.com','2020-05-05 11:01:35'),(75,'MADILUU LOGISTICS COMPANY LIMITED','123123','abc@test.com','2020-05-07 08:21:59'),(76,'GWIHOLOTO IMPEX LIMITED','123123','abc@test.com','2020-05-08 10:30:19'),(77,'CAPSTONE LOGISTICS COMPANY LIMITED','12312124','capstone@gmail.com','2020-05-08 13:02:13'),(78,'ABMAHAMO INVESTMENTS COMPANY LIMITED','1122222','abmahamo@gmail.com','2020-06-29 09:53:54'),(79,'HONEY BADGER ENTERPRISES CO LIMITED','123123123','honey@gmail.com','2020-06-29 09:54:20'),(80,'MEDITERANEAN TRADE LINK LIMITED','123123123','mediteranean@gmail.com','2020-06-29 11:54:27'),(81,'BOLLORE TRANSPORTS & LOGISTICS TANZANIA','123123123','bollore@gmail.com','2020-06-30 09:15:38'),(82,'BORDERLINK CLEARING HOUSE LTD','12312313','borderlink@gmail.com','2020-06-30 13:11:07'),(83,'MPEPA TRADERS CO LIMITED','1234','mpepa@gmail.com','2020-07-06 07:16:28'),(84,'MADILUU LOGISTICS CO LIMITED','1234567','MADILUU@gmail.com','2020-07-10 06:13:39'),(85,'LICHINGA LIMITED','123123123','LICHINDA@GMAIL.COM','2020-07-16 11:31:42'),(86,'SAMWA LOGISTICS COMPANY LIMITED','23453245','samwa@gmail.com','2020-07-16 11:32:10'),(87,'NISHA CLEARING AND FORWARDING LIMITED','121111','222','2020-07-17 11:53:33'),(88,'MEDITERANEAN TRADER LINK LIMITED','22222','333','2020-07-17 11:53:03'),(89,'MOKILAI COMPANY LIMITED','123','123','2020-07-20 10:35:37'),(90,'ARUSHA CARGO CLEARING AND FORWARDING','123','12','2020-07-20 10:35:52'),(91,'MOKILAI COMPANY LIMITED','GGG','SU@YAHOO.CO.IN','2020-07-20 11:36:52'),(92,'JUHUDI CLEARING & FORWARDING CO LTD','12312312','juhudi@gmail.com','2020-07-25 09:53:49'),(93,'ROLIE IMPORT &EXPORT LIMITED','123123123','rolie@gmail.com','2020-07-25 09:54:24'),(94,'NYAMBAYA CARGO LIMITED','123','123','2020-07-30 11:12:47'),(95,'MC JURO INVESTMENT COMPANY LIMITED','123','123','2020-07-30 11:12:59'),(96,'WOTTO LOGISTICS COMPANY','123','123','2020-10-10 10:45:58'),(98,'TRANSIT LIMITED','123','123','2020-08-04 08:11:25'),(99,'ZZOIKOS (T) LIMITED','123','ff','2020-08-13 08:50:08'),(100,'FREIGHT FORWARDERS LIMITED','FREIGHT FORWARDERS LIMITED ','FREIGHT FORWARDERS LIMITED ','2020-08-15 06:29:52'),(101,'CAPITAL CARGO REMOVERS LIMITED','0784395158','capitalcargor@yahoo.com','2020-08-18 12:45:53'),(102,'ROTTOKIM COMPANY LIMITED','0713582285','rottokim07@yahoo.com','2020-08-21 12:29:31'),(103,'INTRA AFRICA TAXATION LIMITED importer NANA FOCUS COMPANY LIMITED','0752792844','intraafricataxationltd2017@yahoo.com ','2020-08-21 14:23:29'),(104,'ROYAL STAR SHIPPING CO LIMITED','0717939333','jmunuo@royalstarshipping.com','2020-08-24 14:48:53'),(105,'SURE FREIGHT TANZANIA LIMITED','0713273793','surefreight@gmail.com','2020-08-24 14:49:43'),(106,'PRO ASSET FUND LIMITED','0713653140','proasset@gmail.com','2020-08-24 14:51:06'),(107,'INTERTZ LOGISTICS COMPANY LIMITED','0769776666','zhangcun@intertz.com','2020-08-24 16:23:53'),(108,'EXPRIMIR COMPANY LIMITED','0713040852',' info@exprimir.co.tz','2020-08-26 13:48:27'),(109,'DESTINATION TANZANIA CARGO LOGISTICS','+225222110352','info@dtcl.co.tz','2020-08-26 13:50:04'),(110,'EAC GROUP (T) LTD','+255686612693','Hellen1haule@yahoo.com','2020-08-26 13:50:43'),(111,'AHA FREIGHT FORWARDERS LIMITED','0782589727','hasacf2011@gmail.com','2020-08-28 16:04:20'),(112,'TOPMAX TANZANIA LIMITED','0654172417','logistics@topmax.com.tz','2020-08-29 13:34:00'),(113,'PLATINUM TRADING COMPANY LIMITED','0719634772',' platinumtradingcl@gmail.com','2020-08-31 08:58:49'),(114,'SAMI AGENCIES LTD','+255 222134017','lulu.mollel@samiagencies.com','2020-09-01 08:35:38'),(115,'WEST FREIGHT AGENCIES LIMITED','0717515101','westfreightltd@yahoo.com','2020-09-02 13:55:01'),(116,'TABASAM CLEARING & FORWADING CO.LTD','0657896101','faithagency818@gmail.com','2020-09-03 14:12:38'),(117,'PALM SWIFT (T)LTD','0789841479','palmswift52@yahoo.com','2020-09-03 14:15:37'),(118,'DOW ELEF INTERNATIONAL (TANZANIA)','0712600000','rlmassawe@dowelef.co.tz','2020-09-04 11:40:05'),(119,'Z & A TRADING COMPANY LIMITED','0715470301','ali.znaclearing@gmail.com','2020-09-04 14:40:06'),(120,'SHAFAKA TRANS CO LIMITED','0713617774',' shafakatransltd@gmail.com','2020-09-05 14:33:19'),(121,'KUEHNE NAGEL LIMITED','0765772821','seafreight.tz@ehne-nagel.com','2020-09-09 11:56:25'),(122,'BEZECO LIMITED','0736326032',' bezecolimited@gmail.com','2020-10-10 10:47:28'),(123,'OASIS CONSULTING LIMITED','0679683733',' oasistz2016@gmail.com','2020-09-14 13:31:54'),(124,'SHAMWA LOGISTICS COMPANY LIMITED','0719359317','shamwalogistics@gmail.com ','2020-09-14 13:32:44'),(125,'MELMAN GENERAL','0718549010','melmancompanyltd2015@gmail.com','2020-09-14 16:29:45'),(126,'AMICO TRADING & SERVICES LTD','0679288331','amicotrading2000@yahoo.com','2020-09-15 08:52:14'),(127,'JAMBO FREIGHT LIMITED','0621107458','chohe@jambofreight.com','2020-09-16 15:11:53'),(128,'MTEMO FREIGHT FORWARDERS LIMITED','0716929481','mtemolimited@gmail.com  ','2020-09-18 13:43:54'),(129,'MS LIMITED','6666','d@gmail.com','2020-09-18 15:38:55'),(130,'IBEX LOGISTICS','0719102891','venance.mosha@ibex-logistics.com','2020-09-24 15:46:30'),(131,'PAWANI HAULIERS LIMITED','0767214441',' janice.kaisi@etgword.com. ','2020-09-25 13:55:28'),(132,'JOINT SOURCE LOGISTICS (T)LIMITED','0718417113','jointsourcelogistics@gmail.com ','2020-09-25 13:56:20'),(133,'ALZEN ENTERPRISES LIMITED','+255 68 303 3556?','alzenenterprisesltd@gmail.com','2020-10-08 09:24:30'),(134,'HONEST LOGISTICS LIMITED','+255222860391','admin@honestlogistics.co.tz','2020-09-28 15:02:05'),(135,'HUPER TANZANIA LIMITED','0715222204','huper@info.co.tz','2020-09-28 15:02:34'),(136,'MÁXIMA CLEARING AND FORWARDING','0712060595','general@maxima.co.tz','2020-09-29 15:45:30'),(137,'INTERWORLD LOGISTICS COMPANY LIMITED','0719954005','interworldlogistics01@gmail.com','2020-09-30 08:41:12'),(138,'ACER PETROLEUM( T) LIMITED','0685196668','clearing@ap.co.tz','2020-10-03 12:50:24'),(139,'RAKEL COMPANY LIMITED','0652489648','fredrick.mrema@rakel.co.tz','2020-10-06 11:53:49'),(140,'ISASEL LOGISTICS & FREIGHT FORWARDERS','0715 699 655','issalogistics2017@gmail.com','2020-10-07 16:28:15'),(141,'SCL SHIFTCARGO LIMITED','+255222138523','operations@shiftcargo.co.tz ','2020-10-08 09:24:00'),(142,'LAZ LIMITED','0684403437','lazltd@gmail.com','2020-10-09 09:29:50'),(143,'MAKADA COMPANY LIMITED','0715055144','makadacompanyltd@gmail.com','2020-10-09 09:48:06'),(144,'NDL LOGISTICS COMPANY LIMITED','0715878680','ndllogistics1@gmail.com','2020-10-09 14:40:50'),(145,'ROMAMI TRADING COMPANY LIMITED','0713253123','romamitrading@yahoo.com','2020-10-10 10:00:21'),(146,'SEABRIDGE CO LIMITED','0713351757','seabridge@ebmaritime.co.tz','2020-10-10 10:47:56'),(147,'WILMAAR LOGISTICS (T) LIMITED','0713055550','wilmaarlogistic@gmail.com','2020-10-13 14:29:50'),(148,'ROYAL LOGISTICS COMPANY LIMITED','0655443060','royallogistic2@yahoo.com','2020-10-14 12:33:47'),(149,'SHIBA ENTERPRISES LTD','0222132444','shiba@cats-net.com','2020-10-14 12:36:56'),(150,'JACO INVESTMENT (T) LIMITED','0784224939','jacoinvestmentltd@gmail.com','2020-10-14 12:50:11'),(151,'GNM AND COMPANY LIMITED','0754778844','gnm@cats-net.co.tz ','2020-10-16 11:11:18'),(152,'BASE FREIGHT & LOGISTICS LIMITED','0718503815','basefreighttz@gmail.com ','2020-10-16 11:13:28'),(153,'HADOLIN LTD','0713212175','hadolinltd@hotmail.com','2020-10-17 09:13:57'),(154,'NANTWA FREIGHT FORWARDERS COMPANY LIMITED','0715732211','www.nantwaffc.co.tz','2020-11-02 09:34:47'),(155,'RIM ZONE TRADING CO LTD','0713764540','rimzonetz@gmail.com ','2020-11-16 12:07:38'),(156,'UJIJI CLEARING AND FORWARDING CO LTD.','0686079456','ujiji2017@gmail .com','2020-11-16 12:08:31'),(157,'SUME IMPORT& EXPORT CO LTD','0744786666','Sumeimp@yahoo.co.uk','2020-11-18 09:49:19'),(158,'LAWIA TANZANIA LIMITED','0738234431','lawiatanzanialimited@yahoo.com','2020-11-19 14:38:52'),(159,'WAGON LOGISTICS  TANZANIA COMPANY','0759261662','Wagonlogistics2017@gmail.com','2020-11-23 11:20:13'),(160,'WEFARMTZ CLEARING AND FORWARDING','0655060817','wefarmtz@gmail.com ','2020-11-23 11:23:30'),(161,'WAGON LOGISTICS  TANZANIA COMPANY','0759261662','Wagonlogistics2017@gmail.com     ','2020-11-23 11:52:25'),(162,'ARDENT PORTERS INTERNATIONAL CO LIMITED','0657519930','twaha@api.co.tz','2020-12-01 10:08:37'),(163,'PLATINUM CLEARING & FORWARDING','+255 788 656 067','platinumcfl@gmail.com','2020-12-01 10:10:46'),(164,'RICHLAND FREIGHT LIMITED','0719981926','Richland freight@gmail.com','2021-01-18 07:57:44'),(165,'EDAN LOGISTICS LIMITED','edanlogistic@gmail.com','0713441466','2021-01-19 08:59:09'),(166,'TEDDY JUNIOR LIMITED','0784022808','sales@teddyjnr.com','2021-01-19 09:41:33'),(167,'AMPLE FREIGHT AND TRADING','0742685555','amplefreight@gmail.com','2021-01-20 12:28:08'),(168,'TWIN FREIGHT FORWARDERS LIMITED','0688026854','twin freight@yahoo.com','2021-01-22 08:51:00'),(169,'R.H.TANZANIA LIMITED','0688026854','rhtanzania@yahoo.com','2021-01-22 08:54:18'),(170,'UCHAU INVESTMENT LIMITED','0784746434','info@123tanzania.com','2021-01-23 07:58:02'),(171,'EQUITY AGENCIES LIMITED','0653004744','info@equityagencies.co.tz','2021-02-19 14:43:57'),(172,'ASTHANA BROTHERS 92 LTD','0787900814','asthanabros92@gmail.com','2021-02-26 15:47:48'),(173,'MOSALKO FREIGHT FORWARDERS CO.LTD','0787689734','saumu.mosalko@gmail.com ','2021-03-10 10:38:30'),(174,'CMTL GROUP LIMITED','0756757575','info@cmtl.co.tz','2021-03-10 10:40:21'),(175,'SUPER STAR FORWARDERS CO.LTD','+255222860930','ssf@superdoll-tz.com ','2021-03-10 11:42:45'),(176,'FAITH LOGISTICS SERVICE LTD','0713258552','faith_logistics@ yahoo.com','2021-03-18 12:19:28'),(177,'AXION LINK ENTERPRISES LIMITED','0688453013','mmuyabi04gmail.com','2021-03-24 14:08:05'),(178,'BELT WAY TRADING CO.LTD','+255222126458','beltwayco218@gmail.com ','2021-05-21 10:04:18'),(179,'RWERU FREIGHT FORWARDERS CO.LTD','0787415089','Rwerufreight@yahoo.com','2021-06-04 14:11:24'),(180,'KASHARU TRADING COMPANY LIMITED','0717385561','kasharutradingcl@gmail.com','2021-06-05 11:17:41');
/*!40000 ALTER TABLE `agent_list` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `assigned_user_roles_list`
--

DROP TABLE IF EXISTS `assigned_user_roles_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `assigned_user_roles_list` (
  `aurl_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aurl_ul_id` int(11) NOT NULL,
  `aurl_type` enum('l_u','icd') NOT NULL,
  `aurl_roles` int(11) NOT NULL,
  `aurl_status` smallint(3) NOT NULL DEFAULT '1' COMMENT '1 active ,0 not active',
  `aurl_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`aurl_id`)
) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `assigned_user_roles_list`
--

LOCK TABLES `assigned_user_roles_list` WRITE;
/*!40000 ALTER TABLE `assigned_user_roles_list` DISABLE KEYS */;
INSERT INTO `assigned_user_roles_list` VALUES (1,31,'icd',4,1,'2019-04-22 03:58:49'),(2,31,'icd',5,1,'2019-04-22 03:58:49'),(3,31,'icd',6,1,'2019-04-22 03:58:49'),(4,31,'icd',7,1,'2019-04-22 03:58:49'),(5,31,'icd',8,1,'2019-04-22 03:58:49'),(6,31,'icd',9,1,'2019-04-22 03:58:49'),(7,31,'icd',10,1,'2019-04-22 03:58:49'),(8,31,'icd',11,1,'2019-04-22 03:58:49'),(9,31,'icd',12,1,'2019-04-22 03:58:49'),(10,31,'icd',13,1,'2019-04-22 03:58:49'),(11,31,'icd',14,1,'2019-04-22 03:58:49'),(12,31,'icd',15,1,'2019-04-22 03:58:49'),(13,31,'icd',16,1,'2019-04-22 03:58:50'),(14,31,'icd',20,1,'2019-04-22 03:58:50'),(15,0,'icd',4,1,'2019-05-17 03:51:19'),(16,0,'icd',5,1,'2019-05-17 03:51:19'),(17,0,'icd',10,1,'2019-05-17 03:51:19'),(18,41,'icd',4,1,'2019-05-22 13:13:55'),(19,41,'icd',5,1,'2019-05-22 13:13:55'),(20,0,'icd',7,1,'2019-05-20 12:35:58'),(21,0,'icd',7,1,'2019-05-21 22:35:59'),(22,0,'icd',12,1,'2019-05-21 23:00:07'),(23,0,'icd',9,1,'2019-05-21 23:05:36'),(24,0,'icd',11,1,'2019-05-22 00:13:54'),(25,46,'icd',11,1,'2019-05-22 00:15:10'),(26,0,'icd',10,1,'2019-05-22 01:25:15'),(27,0,'icd',13,1,'2019-05-22 03:18:01'),(28,48,'icd',13,1,'2019-05-22 13:09:38'),(29,42,'icd',6,1,'2019-05-22 13:01:18'),(30,43,'icd',7,1,'2019-05-22 13:01:40'),(31,44,'icd',12,1,'2019-05-31 05:15:38'),(32,45,'icd',9,1,'2019-05-22 13:02:34'),(33,47,'icd',10,1,'2019-05-22 13:02:59'),(34,0,'icd',8,1,'2019-05-28 07:51:07'),(35,44,'icd',8,1,'2019-05-31 05:15:38'),(36,0,'icd',4,1,'2019-06-01 00:01:38'),(37,0,'icd',5,1,'2019-06-01 00:02:55'),(38,0,'icd',8,1,'2019-06-01 00:03:50'),(39,0,'icd',10,1,'2019-06-01 00:13:39'),(40,0,'icd',11,1,'2019-06-01 00:16:16'),(41,0,'icd',12,1,'2019-06-01 00:20:27'),(42,0,'icd',9,1,'2019-06-01 00:35:13'),(43,0,'icd',9,1,'2019-06-01 00:36:19'),(44,0,'icd',9,1,'2019-06-01 00:37:21'),(45,0,'icd',9,1,'2019-06-01 00:38:11'),(46,0,'icd',6,1,'2019-06-01 00:40:32'),(47,0,'icd',6,1,'2019-06-01 00:42:05'),(48,0,'icd',7,1,'2019-06-01 00:43:04'),(49,0,'icd',20,1,'2019-06-01 00:44:11'),(50,63,'icd',12,0,'2020-02-19 14:33:05'),(51,0,'icd',20,1,'2019-06-01 00:45:18'),(52,50,'icd',4,1,'2020-02-19 15:18:38'),(53,51,'icd',5,0,'2021-01-18 11:29:22'),(54,50,'icd',5,1,'2020-02-19 15:18:38'),(55,50,'icd',8,1,'2020-02-19 15:18:38'),(56,50,'icd',12,1,'2020-02-19 15:18:38'),(57,51,'icd',4,0,'2021-01-18 11:29:22'),(58,51,'icd',8,0,'2021-01-18 11:29:22'),(59,51,'icd',13,0,'2021-01-18 11:29:22'),(60,52,'icd',10,1,'2020-02-19 14:21:53'),(61,52,'icd',11,1,'2020-02-19 14:21:53'),(62,53,'icd',10,1,'2020-02-19 14:23:16'),(63,53,'icd',11,1,'2020-02-19 14:23:16'),(64,54,'icd',10,1,'2020-02-19 15:20:51'),(65,54,'icd',11,1,'2020-02-19 15:20:51'),(66,0,'icd',4,1,'2019-06-01 01:39:51'),(67,0,'icd',5,1,'2019-06-01 01:39:51'),(68,0,'icd',8,1,'2019-06-01 01:39:51'),(69,0,'icd',13,1,'2019-06-01 01:39:51'),(70,0,'icd',10,1,'2019-06-01 01:41:14'),(71,0,'icd',11,1,'2019-06-01 01:41:14'),(72,56,'icd',9,1,'2020-08-11 13:50:49'),(73,59,'icd',9,0,'2020-10-23 12:42:20'),(74,57,'icd',9,1,'2020-02-19 15:33:56'),(75,58,'icd',9,1,'2020-02-19 15:34:37'),(76,60,'icd',6,1,'2020-02-19 15:37:05'),(77,61,'icd',6,1,'2020-02-19 15:38:21'),(78,64,'icd',9,0,'2020-02-19 14:34:58'),(79,62,'icd',7,1,'2020-11-28 14:00:24'),(80,65,'icd',4,0,'2020-02-19 14:38:11'),(81,65,'icd',5,0,'2020-02-19 14:38:11'),(82,65,'icd',8,0,'2020-02-19 14:38:11'),(83,65,'icd',13,0,'2020-02-19 14:38:11'),(84,66,'icd',10,0,'2020-02-19 14:37:16'),(85,66,'icd',11,0,'2020-02-19 14:37:16'),(86,0,'icd',4,1,'2019-06-08 03:07:31'),(87,0,'icd',5,1,'2019-06-08 03:07:31'),(88,0,'icd',8,1,'2019-06-08 03:07:31'),(89,0,'icd',12,1,'2019-06-08 03:07:31'),(90,67,'icd',4,0,'2020-02-19 14:43:59'),(91,67,'icd',5,0,'2020-02-19 14:43:59'),(92,67,'icd',8,0,'2020-02-19 14:43:59'),(93,67,'icd',12,0,'2020-02-19 14:43:59'),(94,0,'icd',4,1,'2019-06-12 08:32:20'),(95,0,'icd',5,1,'2019-06-12 08:32:20'),(96,0,'icd',8,1,'2019-06-12 08:32:20'),(97,0,'icd',12,1,'2019-06-12 08:32:20'),(98,0,'icd',13,1,'2019-06-12 08:32:20'),(99,68,'icd',4,0,'2020-02-19 14:45:01'),(100,68,'icd',5,0,'2020-02-19 14:45:01'),(101,68,'icd',8,0,'2020-02-19 14:45:01'),(102,68,'icd',12,0,'2020-02-19 14:45:01'),(103,55,'icd',10,1,'2020-02-19 15:21:39'),(104,55,'icd',11,1,'2020-02-19 15:21:39'),(105,63,'icd',6,1,'2020-11-28 13:35:37'),(106,64,'icd',7,0,'2020-02-19 14:43:09'),(107,66,'icd',4,0,'2020-02-19 14:50:06'),(108,66,'icd',5,0,'2020-02-19 14:50:06'),(109,66,'icd',8,0,'2020-02-19 14:50:06'),(110,66,'icd',13,0,'2020-02-19 14:50:06'),(111,65,'icd',6,1,'2020-09-11 07:34:19'),(112,64,'icd',6,0,'2020-11-28 13:36:39'),(113,0,'icd',4,1,'2020-02-19 14:47:22'),(114,0,'icd',5,1,'2020-02-19 14:47:22'),(115,0,'icd',8,1,'2020-02-19 14:47:22'),(116,0,'icd',13,1,'2020-02-19 14:47:22'),(117,69,'icd',4,1,'2020-02-19 15:59:33'),(118,69,'icd',5,1,'2020-02-19 15:59:33'),(119,69,'icd',8,1,'2020-02-19 15:59:33'),(120,69,'icd',13,1,'2020-02-19 15:59:33'),(121,0,'icd',4,1,'2020-02-19 14:54:01'),(122,0,'icd',5,1,'2020-02-19 14:54:01'),(123,0,'icd',8,1,'2020-02-19 14:54:01'),(124,0,'icd',13,1,'2020-02-19 14:54:01'),(125,70,'icd',4,1,'2020-02-19 16:00:52'),(126,70,'icd',5,1,'2020-02-19 16:00:52'),(127,70,'icd',8,1,'2020-02-19 16:00:52'),(128,70,'icd',13,1,'2020-02-19 16:00:52'),(129,0,'icd',4,1,'2020-02-19 14:56:23'),(130,0,'icd',5,1,'2020-02-19 14:56:23'),(131,0,'icd',8,1,'2020-02-19 14:56:23'),(132,0,'icd',13,1,'2020-02-19 14:56:23'),(133,71,'icd',4,1,'2020-02-19 16:00:09'),(134,71,'icd',5,1,'2020-02-19 16:00:09'),(135,71,'icd',8,1,'2020-02-19 16:00:09'),(136,71,'icd',13,1,'2020-02-19 16:00:09'),(137,0,'icd',4,1,'2020-02-19 14:59:57'),(138,0,'icd',5,1,'2020-02-19 14:59:57'),(139,0,'icd',8,1,'2020-02-19 14:59:57'),(140,0,'icd',13,1,'2020-02-19 14:59:57'),(141,72,'icd',4,1,'2020-02-19 16:01:23'),(142,72,'icd',5,1,'2020-02-19 16:01:23'),(143,72,'icd',8,1,'2020-02-19 16:01:23'),(144,72,'icd',13,1,'2020-02-19 16:01:23'),(145,51,'icd',12,0,'2021-01-18 11:29:22'),(146,66,'icd',6,1,'2020-11-28 13:59:14'),(147,0,'icd',4,1,'2020-04-16 13:32:36'),(148,0,'icd',5,1,'2020-04-16 13:32:36'),(149,0,'icd',6,1,'2020-04-16 13:32:36'),(150,0,'icd',7,1,'2020-04-16 13:32:36'),(151,0,'icd',8,1,'2020-04-16 13:32:36'),(152,0,'icd',9,1,'2020-04-16 13:32:36'),(153,0,'icd',10,1,'2020-04-16 13:32:36'),(154,0,'icd',11,1,'2020-04-16 13:32:36'),(155,0,'icd',12,1,'2020-04-16 13:32:36'),(156,0,'icd',13,1,'2020-04-16 13:32:36'),(157,0,'icd',20,1,'2020-04-16 13:32:36'),(158,0,'icd',9,1,'2020-06-12 10:52:53'),(159,74,'icd',9,1,'2020-12-11 10:50:40'),(160,65,'icd',20,1,'2020-09-11 07:34:19'),(161,75,'icd',4,1,'2020-10-15 09:23:33'),(162,76,'icd',4,1,'2021-01-18 11:36:33'),(163,73,'icd',4,1,'2020-10-16 13:55:02'),(164,73,'icd',5,1,'2020-10-16 13:55:02'),(165,73,'icd',6,1,'2020-10-16 13:55:02'),(166,73,'icd',7,1,'2020-10-16 13:55:02'),(167,73,'icd',8,1,'2020-10-16 13:55:02'),(168,73,'icd',9,1,'2020-10-16 13:55:02'),(169,73,'icd',10,1,'2020-10-16 13:55:02'),(170,73,'icd',11,1,'2020-10-16 13:55:02'),(171,73,'icd',12,1,'2020-10-16 13:55:02'),(172,73,'icd',13,1,'2020-10-16 13:55:02'),(173,73,'icd',20,1,'2020-10-16 13:55:02'),(205,78,'icd',10,1,'2020-10-22 08:55:32'),(206,78,'icd',11,1,'2020-10-22 08:55:32'),(207,78,'icd',12,1,'2020-10-22 08:55:32'),(208,77,'icd',5,1,'2020-10-23 03:33:13'),(209,77,'icd',6,1,'2020-10-23 03:33:13'),(210,77,'icd',7,1,'2020-10-23 03:33:13'),(213,79,'icd',9,1,'2020-10-24 11:01:31'),(214,67,'icd',9,1,'2020-10-23 12:42:58'),(215,79,'icd',4,1,'2020-10-24 11:01:30'),(216,79,'icd',5,1,'2020-10-24 11:01:30'),(217,79,'icd',6,1,'2020-10-24 11:01:30'),(218,79,'icd',7,1,'2020-10-24 11:01:31'),(219,79,'icd',8,1,'2020-10-24 11:01:31'),(220,79,'icd',10,1,'2020-10-24 11:01:31'),(221,79,'icd',11,1,'2020-10-24 11:01:32'),(222,79,'icd',12,1,'2020-10-24 11:01:32'),(223,79,'icd',13,1,'2020-10-24 11:01:32'),(224,79,'icd',20,1,'2020-10-24 11:01:33'),(225,68,'icd',11,1,'2020-12-02 12:18:04'),(226,76,'icd',5,1,'2021-01-18 11:36:33'),(227,76,'icd',8,1,'2021-01-18 11:36:33'),(228,76,'icd',10,1,'2021-01-18 11:36:33'),(229,76,'icd',11,1,'2021-01-18 11:36:33'),(230,76,'icd',13,1,'2021-01-18 11:36:33'),(231,76,'icd',20,1,'2021-01-18 11:36:33'),(232,0,'icd',11,1,'2021-05-08 07:56:54'),(233,80,'icd',11,1,'2021-05-08 07:57:37'),(234,0,'icd',4,1,'2021-05-19 11:00:13'),(235,0,'icd',5,1,'2021-05-19 11:00:13'),(236,0,'icd',6,1,'2021-05-19 11:00:14'),(237,0,'icd',7,1,'2021-05-19 11:00:14'),(238,0,'icd',8,1,'2021-05-19 11:00:14'),(239,0,'icd',9,1,'2021-05-19 11:00:14'),(240,0,'icd',10,1,'2021-05-19 11:00:15'),(241,0,'icd',11,1,'2021-05-19 11:00:15'),(242,0,'icd',12,1,'2021-05-19 11:00:15'),(243,0,'icd',13,1,'2021-05-19 11:00:15'),(244,0,'icd',20,1,'2021-05-19 11:00:16'),(245,81,'icd',4,1,'2021-05-19 11:04:51'),(246,81,'icd',5,1,'2021-05-19 11:04:51'),(247,81,'icd',6,1,'2021-05-19 11:04:51'),(248,81,'icd',7,1,'2021-05-19 11:04:51'),(249,81,'icd',8,1,'2021-05-19 11:04:52'),(250,81,'icd',9,1,'2021-05-19 11:04:52'),(251,81,'icd',10,1,'2021-05-19 11:04:52'),(252,81,'icd',11,1,'2021-05-19 11:04:52'),(253,81,'icd',12,1,'2021-05-19 11:04:53'),(254,81,'icd',13,1,'2021-05-19 11:04:53'),(255,81,'icd',20,1,'2021-05-19 11:04:53');
/*!40000 ALTER TABLE `assigned_user_roles_list` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `auto_generate_id_no_list`
--

DROP TABLE IF EXISTS `auto_generate_id_no_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auto_generate_id_no_list` (
  `aginl_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aginl_type` varchar(500) NOT NULL,
  `aginl_val` varchar(500) NOT NULL,
  `aginl_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`aginl_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `auto_generate_id_no_list`
--

LOCK TABLES `auto_generate_id_no_list` WRITE;
/*!40000 ALTER TABLE `auto_generate_id_no_list` DISABLE KEYS */;
INSERT INTO `auto_generate_id_no_list` VALUES (1,'Gate Entry No','0003599','2021-06-06 16:09:58'),(2,'Out Pass No','3816','2021-06-06 16:51:46'),(3,'ICD Out No','2013','2021-06-05 13:18:41'),(4,'Gate Pass\r\n Out No','001667','2021-06-05 12:15:56'),(5,'Gate Pass No','446','2021-06-05 13:38:06'),(6,'Token No','0003113','2021-06-05 12:49:56');
