-- MySQL dump 10.16  Distrib 10.1.37-MariaDB, for Win32 (AMD64)
--
-- Host: localhost    Database: logistics_test
-- ------------------------------------------------------
-- Server version	10.1.37-MariaDB

/*!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 `order_status_a`
--

DROP TABLE IF EXISTS `order_status_a`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_status_a` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `statusName` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_status_a`
--

LOCK TABLES `order_status_a` WRITE;
/*!40000 ALTER TABLE `order_status_a` DISABLE KEYS */;
INSERT INTO `order_status_a` VALUES (1,'Submitted Request.','Customer submitted request.'),(2,'Boda Agent arrived at customer location.','Boda Agent arrived at customer location.'),(3,'Customer dispatched goods to Boda agent.','Customer dispatched goods to Boda agent.'),(4,'Boda agent accepts dispatched goods from customer','Boda agent accepts dispatched goods from customer'),(5,'Boda agent arrived at Pick Up collection center.','Boda agent arrived at Pick Up collection center.'),(6,'Boda Agent dispatched goods to Pick Up  Collection Center agent.','Senior Supa Boda agent arrives at Pick Up Collection center.'),(7,'Pick Up Collection center agent accepts dispatched goods from Boda agent.','Pick Up Collection center agent accepts dispatched goods from Boda agent.'),(8,'Senior Supa Boda agent arrives at Pick Up Collection center.','Pick Up Collection center agent dispatched goods to Supa Boda agent.'),(9,'Supa Boda agent arrives at Pick Up Collection center.','Supa Boda agent arrives at Pick Up Collection center.'),(10,'Boda agent arrived at Pick Up Collection center.','Boda agent arrived at Pick Up Collection center.'),(11,'\r\nPick Up Collection Center Agent dispatched goods to Senior Supa Boda','Pick Up Collection Center Agent dispatched goods to Senior Supa Boda'),(12,'\r\nPick Up Collection Center Agent dispatched goods to Supa Boda','\r\nPick Up Collection Center Agent dispatched goods to Supa Boda'),(13,'\r\nPick Up Collection Center Agent dispatched goods to Boda Agent','\r\nPick Up Collection Center Agent dispatched goods to Boda Agent'),(14,'Senior Supa Boda agent accepted goods from Pick Up Collection Center','Senior Supa Boda agent accepted goods from Pick Up Collection Center'),(15,'Supa Boda agent accepted goods from Pick Up Collection Center','Supa Boda agent accepted goods from Pick Up Collection Center'),(16,'Boda agent accepted goods from Pick Up Collection Center','Boda agent accepted goods from Pick Up Collection Center'),(17,'Senior Supa Boda agent arrived at Major Collection Center.','Senior Supa Boda agent arrived at Major Collection Center.'),(18,'Supa Boda agent arrived at Main Collection Center.','Supa Boda agent arrived at Main Collection Center.'),(19,'Boda agent arrived at Normal Collection Center.','Boda agent arrived at Normal Collection Center.'),(20,'Senior Supa Boda agent Dispatched goods to Major Collection Center agent.','Senior Supa Boda agent Dispatched goods to Major Collection Center agent.'),(21,'Supa Boda agent Dispatched goods to Main Collection Center agent.','Supa Boda agent Dispatched goods to Main Collection Center agent.'),(22,'Normal Boda agent Dispatched goods to Normal Collection Center agent.','Normal Boda agent Dispatched goods to Normal Collection Center agent.'),(23,'Major Collection  Center agent accepts goods from Senior,Supa or normal Boda agent','Major Collection  Center agent accepts goods from Senior,Supa or normal Boda agent'),(24,'Main Collection  Center agent accepts goods from Senior,Supa or normal Boda agent','Main Collection  Center agent accepts goods from Senior,Supa or normal Boda agent'),(25,'Normal Collection  Center agent accepts goods from Senior,Supa or normal Boda agent','Normal Collection  Center agent accepts goods from Senior,Supa or normal Boda agent'),(26,'Delivery  Center accepted Goods from Senior,Supa or normal Boda agent.','Delivery  Center accepted Goods from Senior,Supa or normal Boda agent.'),(27,'Senior,Supa or normal Boda agent arrived at Delivery Collection Center.','Senior,Supa or normal Boda agent arrived at Delivery Collection Center.'),(28,'Delivery Center Dispatched goods to Senior,Supa or normal Boda agent','Delivery Center Dispatched goods to Senior,Supa or normal Boda agent'),(29,'Senior,Supa or normal Boda agent accepted goods from Delivery Center','Senior,Supa or normal Boda agent accepted goods from Delivery Center'),(30,'Senior,Supa or normal Boda agent arrived at recipient location.','Senior,Supa or normal Boda agent arrived at recipient location.'),(31,'Senior,Supa or normal Boda agent Dispatched to recipient.','Senior,Supa or normal Boda agent Dispatched to recipient.'),(32,'recipient acepted goods from Senior,Supa or normal Boda agent','recipient acepted goods from Senior,Supa or normal Boda agent');
/*!40000 ALTER TABLE `order_status_a` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-02-24  6:08:46
