File: //storage02/Bkup/miti_mitint-2022-03-26.sql
-- MariaDB dump 10.19 Distrib 10.4.24-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: miti_mitint
-- ------------------------------------------------------
-- Server version 10.4.24-MariaDB-log
/*!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 */;
/*!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 `MIT_Amit888`
--
DROP TABLE IF EXISTS `MIT_Amit888`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_Amit888` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`reduction_of_coin` int(255) NOT NULL,
`direction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`waybill_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`customer_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`product detail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`primary phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`weight` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`commodity value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_Amit888`
--
LOCK TABLES `MIT_Amit888` WRITE;
/*!40000 ALTER TABLE `MIT_Amit888` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_Amit888` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_Amit888._history`
--
DROP TABLE IF EXISTS `MIT_Amit888._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_Amit888._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_Amit888._history`
--
LOCK TABLES `MIT_Amit888._history` WRITE;
/*!40000 ALTER TABLE `MIT_Amit888._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_Amit888._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_Dhruv243`
--
DROP TABLE IF EXISTS `MIT_Dhruv243`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_Dhruv243` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`reduction_of_coin` int(255) NOT NULL,
`direction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`waybill_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`customer_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`product detail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`primary phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`weight` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`commodity value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_Dhruv243`
--
LOCK TABLES `MIT_Dhruv243` WRITE;
/*!40000 ALTER TABLE `MIT_Dhruv243` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_Dhruv243` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_Dhruv243._history`
--
DROP TABLE IF EXISTS `MIT_Dhruv243._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_Dhruv243._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_Dhruv243._history`
--
LOCK TABLES `MIT_Dhruv243._history` WRITE;
/*!40000 ALTER TABLE `MIT_Dhruv243._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_Dhruv243._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_Umang 601`
--
DROP TABLE IF EXISTS `MIT_Umang 601`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_Umang 601` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`reduction_of_coin` int(255) NOT NULL,
`direction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`waybill_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`customer_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`product detail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`primary phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`weight` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`commodity value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_Umang 601`
--
LOCK TABLES `MIT_Umang 601` WRITE;
/*!40000 ALTER TABLE `MIT_Umang 601` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_Umang 601` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_Umang 601._history`
--
DROP TABLE IF EXISTS `MIT_Umang 601._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_Umang 601._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_Umang 601._history`
--
LOCK TABLES `MIT_Umang 601._history` WRITE;
/*!40000 ALTER TABLE `MIT_Umang 601._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_Umang 601._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_ajay4`
--
DROP TABLE IF EXISTS `MIT_ajay4`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_ajay4` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`reduction_of_coin` int(255) NOT NULL,
`direction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`waybill_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`customer_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`product detail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`primary phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`weight` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`commodity value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_ajay4`
--
LOCK TABLES `MIT_ajay4` WRITE;
/*!40000 ALTER TABLE `MIT_ajay4` DISABLE KEYS */;
INSERT INTO `MIT_ajay4` VALUES (1,47,'forward','','5963258741','12545845','2022-02-03','COD','Surface','umang kathiriya','free product','8758545854','145,opera business hub','10','0'),(2,37,'reverse','','5678694444','123456854','2022-02-03','','Surface','jp','free product','75657565756','12,soft building complex','','');
/*!40000 ALTER TABLE `MIT_ajay4` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_ajay4._history`
--
DROP TABLE IF EXISTS `MIT_ajay4._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_ajay4._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_ajay4._history`
--
LOCK TABLES `MIT_ajay4._history` WRITE;
/*!40000 ALTER TABLE `MIT_ajay4._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_ajay4._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_harshil379`
--
DROP TABLE IF EXISTS `MIT_harshil379`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_harshil379` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`reduction_of_coin` int(255) NOT NULL,
`direction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`waybill_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`customer_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`product detail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`primary phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`weight` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`commodity value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_harshil379`
--
LOCK TABLES `MIT_harshil379` WRITE;
/*!40000 ALTER TABLE `MIT_harshil379` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_harshil379` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_harshil379._history`
--
DROP TABLE IF EXISTS `MIT_harshil379._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_harshil379._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_harshil379._history`
--
LOCK TABLES `MIT_harshil379._history` WRITE;
/*!40000 ALTER TABLE `MIT_harshil379._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_harshil379._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_jay169`
--
DROP TABLE IF EXISTS `MIT_jay169`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_jay169` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`reduction_of_coin` int(255) NOT NULL,
`direction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`waybill_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`customer_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`product detail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`primary phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`weight` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`commodity value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_jay169`
--
LOCK TABLES `MIT_jay169` WRITE;
/*!40000 ALTER TABLE `MIT_jay169` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_jay169` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_jay169._history`
--
DROP TABLE IF EXISTS `MIT_jay169._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_jay169._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_jay169._history`
--
LOCK TABLES `MIT_jay169._history` WRITE;
/*!40000 ALTER TABLE `MIT_jay169._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_jay169._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_jaydeep555`
--
DROP TABLE IF EXISTS `MIT_jaydeep555`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_jaydeep555` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`wallet` int(255) NOT NULL,
`direction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_jaydeep555`
--
LOCK TABLES `MIT_jaydeep555` WRITE;
/*!40000 ALTER TABLE `MIT_jaydeep555` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_jaydeep555` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_jaydeep555._history`
--
DROP TABLE IF EXISTS `MIT_jaydeep555._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_jaydeep555._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_jaydeep555._history`
--
LOCK TABLES `MIT_jaydeep555._history` WRITE;
/*!40000 ALTER TABLE `MIT_jaydeep555._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_jaydeep555._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_jignesh777`
--
DROP TABLE IF EXISTS `MIT_jignesh777`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_jignesh777` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`reduction_of_coin` int(255) NOT NULL,
`direction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`waybill_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`customer_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`product detail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`primary phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`weight` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`commodity value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_jignesh777`
--
LOCK TABLES `MIT_jignesh777` WRITE;
/*!40000 ALTER TABLE `MIT_jignesh777` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_jignesh777` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_jignesh777._history`
--
DROP TABLE IF EXISTS `MIT_jignesh777._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_jignesh777._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_jignesh777._history`
--
LOCK TABLES `MIT_jignesh777._history` WRITE;
/*!40000 ALTER TABLE `MIT_jignesh777._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_jignesh777._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_jignesh849`
--
DROP TABLE IF EXISTS `MIT_jignesh849`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_jignesh849` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`reduction_of_coin` int(255) NOT NULL,
`direction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`waybill_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`customer_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`product detail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`primary phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`weight` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`commodity value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_jignesh849`
--
LOCK TABLES `MIT_jignesh849` WRITE;
/*!40000 ALTER TABLE `MIT_jignesh849` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_jignesh849` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `MIT_jignesh849._history`
--
DROP TABLE IF EXISTS `MIT_jignesh849._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MIT_jignesh849._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `MIT_jignesh849._history`
--
LOCK TABLES `MIT_jignesh849._history` WRITE;
/*!40000 ALTER TABLE `MIT_jignesh849._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `MIT_jignesh849._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin`
--
DROP TABLE IF EXISTS `admin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`fname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`lname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Company Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Company Logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Company Address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date of Joining` date NOT NULL,
`wallet` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin`
--
LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` VALUES (1,'jaydeep','prajapati','7069440745','jp818281@gmail.com','MIT INTERNATIONAL','mit_international.jpg','145,Dadar Nagar Haveli, Surat','jp1153','$2y$10$..dNdGTemzp26uoLDytKbe/Z6hFivDK.y6eJeujobhVol70G4wsOu','2022-01-08',14726);
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_jp`
--
DROP TABLE IF EXISTS `admin_jp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_jp` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`wallet` int(255) NOT NULL,
`diction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_jp`
--
LOCK TABLES `admin_jp` WRITE;
/*!40000 ALTER TABLE `admin_jp` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_jp` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_jp._history`
--
DROP TABLE IF EXISTS `admin_jp._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_jp._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_jp._history`
--
LOCK TABLES `admin_jp._history` WRITE;
/*!40000 ALTER TABLE `admin_jp._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_jp._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jp1153`
--
DROP TABLE IF EXISTS `jp1153`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jp1153` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`reduction_of_coin` int(255) NOT NULL,
`direction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`waybill_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`customer_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`product detail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`primary phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`weight` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`commodity value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jp1153`
--
LOCK TABLES `jp1153` WRITE;
/*!40000 ALTER TABLE `jp1153` DISABLE KEYS */;
INSERT INTO `jp1153` VALUES (1,22,'forward','Not Picked','123467800','8518410212063','2022-01-17','COD','Surface','Umang Kathiriya','','','','',''),(2,10,'forward','Not Picked','9865854525','8518410212074','2022-01-17','Pre-paid','Surface','Umang Kathiriya','','','','',''),(3,0,'forward','Not Picked','77447744','8518410212240','2022-01-19','Pre-paid','Surface','UUUK','Free product','7433005640','CHHITU NAGAR,PUNA BOMBAY MKT ROAD,','100',''),(4,22,'forward','Not Picked','7433005640','8518410212236','2022-01-19','Pre-paid','Surface','Umang Kathiriya','Free product','7433005640','CHHITU NAGAR,PUNA BOMBAY MKT ROAD,','150',''),(5,12,'forward','Not Picked','4534665443454','8518410212214','2022-01-19','Pre-paid','Surface','jp','small size of essential','9856545255','145,new soc., amroli','150','150'),(6,0,'reverse','Closed','9856545255','8518410212096','2022-01-19','Pickup','Surface','Umang Kathiriya','','','','',''),(7,0,'forward','','2522121100','8518410212590','2022-01-29','Pre-paid','Surface','alpesh tanpure','','','','',''),(11,37,'forward','Manifested','123456789456','8518410212822','2022-02-03','Pre-paid','Surface','umang kathiriya','free product','7069440745','145,opera business hub','10','0'),(13,37,'reverse','Closed','1234567894','8518410212833','2022-02-03','Pickup','Surface','umang kathiriya','free product','7069440745','145,opera business hub','',''),(14,37,'forward','Not Picked','7433005640','8518410212973','2022-02-08','Pre-paid','Surface','Umang Kathiriya','testing product','7433005640','145, Opera business hub','10','0'),(15,125,'forward','Delivered','241261500','8518410212984','2022-02-08','Pre-paid','Surface','SHRIKANT MAHATO 9386358689','LED DRIVER','9386358689','PO KATRUS BAZAR DISTIC DHANBAD','1500','0'),(16,47,'forward','Delivered','18125210','8518410213021','2022-02-09','Pre-paid','Surface','ABDUL FAIROZ','IMMITIMESHION ','9353098832','HOUSE NO #72 KONANDUR POST THIRTHAHALLI 9353098832','210','0'),(17,70,'forward','Delivered','19139463','8518410213382','2022-02-23','Pre-paid','Surface','parul goel','HOME APPLINCE','9805548347','SHIHARDI MUSALALNA DHARMPUR ','465','0'),(18,110,'forward','Delivered','2121123','8518410213404','2022-02-24','Pre-paid','Surface','DR JEGO ORI 9436069257','SURGICAL PRODUCT','9436069257','GG ENT OPPOSITE TRIHMS HOSPITEL Naharlagun ','600','0'),(19,37,'forward','Manifested','123456789','8518410213441','2022-02-25','Pre-paid','Surface','Umang Kathiriya','FREE PRODUCT','8544344344','A - 303 Shubhalaxmi apartment, Chhtunagar soc, sitanagar road punagam','10','0'),(20,54,'forward','Manifested','22121454','8518410213452','2022-02-25','Pre-paid','Surface','MAA DRUG HOUDES','garm,ent','9374265252','123 CROSS ROAD SHOPPING CENTER','1000','0'),(21,37,'forward','Manifested','35416126','8518410213485','2022-02-25','Pre-paid','Surface','Umang Kathiriya','FREE PRODUCT','9544344344','A - 303 Shubhalaxmi apartment, Chhtunagar soc, sitanagar road punagam','12','0'),(22,42,'forward','Delivered','1293','8518410213570','2022-03-02','Pre-paid','Surface','SAMATA SALES ','DOCUMENT','9423193328',' MR JITENDRA TATIYA H NO 523 SATANA ROAD PIMPALNER DHULE Dhule Maharashtra , ','189','0'),(23,42,'forward','Delivered','19104','8518410213581','2022-03-02','Pre-paid','Surface','GODVEL STONE 9833941419','DOCUMENT ','9833941419',' SHOP NO 162 NEAR MAHARASHTRA WEIGH BRIDGE OPP RAILWAY YARD L.B.S ROAD . SION (WEST) 9819549844 7045616464 Mumbai Maharashtra , ','221','0'),(24,57,'forward','Delivered','121211','8518410213592','2022-03-02','Pre-paid','Surface','BONDU ADITYA SOURY','PINAL BUTER','9030218010','BONDU ADITYA SOURY D NO 8-4-142 SANGEETHARAV PETA SAMARLAKOTA 9030218010','339','0'),(25,297,'forward','Delivered','511687731906106','8518410213603','2022-03-03','Pre-paid','Surface','JNV DHANSURA DISTT ARAVALLI GUJ','OREVA 50WT LED FLOOD LIGHT','8619710117','SHAKTINAGAR AREA , AT.PO.TA.DHANSURA DIST:ARVALLI MO:8619710117','8200','0'),(26,81,'forward','Delivered','25279','8518410213614','2022-03-03','Pre-paid','Surface','SAI COLLECTION 8149657752','GARMENT','8149657752','DHAPYA MANDIR ROAD MACHHIGALI BAZAR PETH KARJAT 9921328032','1100','0'),(27,86,'forward','Delivered','34284','8518410213625','2022-03-03','Pre-paid','Surface','PRATAP AZGAONKAR 8805276635','GARMENT','8805276635','H NO 230 NEAR MAHALAXMI TEMPLE BHAGAT WADA AMONA MARCEL GOA ','559','0'),(28,60,'forward','Delivered','520805','8518410213640','2022-03-05','Pre-paid','Surface','RAJUBHAI MO:9523153086','PAPER','9523153086','MA GAYTRI VASTRALAY , KARNI ROAD , ITASORI','500','0'),(29,88,'forward','Not Picked','1234567854','8518410213754','2022-03-05','COD','Surface','umang kathiriya','free product','7069440748','134, lakshmi nagar,katargam','10','10'),(30,57,'forward','In Transit','12106296','8518410213765','2022-03-06','Pre-paid','Surface','adarsh punia 9739917033','oil','9739917033','a 203 bren avalon apartment chinnapanahalli main road , doddanekudi extenshion ','296',''),(31,48,'forward','Delivered','18145','8518410213776','2022-03-06','Pre-paid','Surface','michael 8655774012','OIL','8655774012','PANCHSHEEL CHS 92./C-9 GATE NO 8 MHADA MALAD (W) ','296',''),(32,47,'forward','Delivered','262615235','8518410213780','2022-03-06','Pre-paid','Surface','DR SRAVYA VASIREDDY 7075419333','SURGICAL PRODUCT','7075419333','301 KAILASH MID VALLEY CITY BESIDE TDP OFFICE MANGALGIRI AP ','239',''),(33,70,'forward','Delivered','16174','8518410213835','2022-03-07','Pre-paid','Surface','ABHIJEET KUMAR 9572097861','COTTOMN PRE ROLL','9572097861','9 CORPS DENTAL UNIT YOL CANT YOL KANGRA ','339',''),(34,115,'forward','Delivered','182216','8518410213850','2022-03-07','Pre-paid','Surface','PIYUSH SURESH SHATRI 9582951255','HAEMOMRTER SAHIL METHOD 9018','9582951255','RVC ENTER NEAR ALLAHABAD BANK MALL ROAD MEERUT','1095',''),(35,88,'forward','Not Picked','24574205855','8518410213920','2022-03-08','COD','Surface','umang kathiriya','free product','7069440748','134, lakshmi nagar,katargam','10','10'),(36,125,'forward','Delivered','3025121600','8518410213942','2022-03-09','Pre-paid','Surface','JITENDRABHAI MO:9996666198','HOSE PIPE','9996666198','#7-132/1 , CINEMA ROAD , TATIPAKA , DINDI AREA RAZOLE MANDAL , KONASEEMA , E.G','1500',''),(37,93,'forward','Delivered','2417081000','8518410214012','2022-03-10','Pre-paid','Surface','ZAVED KHAN MO:6294477698','MEDITION','6294477698','VILL: THIPARA KARIGOR PARA PO+PS:PANDUA','1000',''),(38,108,'forward','Delivered','181610','8518410214023','2022-03-10','COD','Surface','anshul hemrajani ','OPTICAL','9096323100',' Ad.. Bhim chowk jaripatka nagpur Baba saheb Ambedkar putla. 9096323100','331','1800'),(39,178,'forward','Delivered','322312','8518410214034','2022-03-10','COD','Surface','Aaditya gujjar','SHOES','9374265252','House no 1499 sector 28 faridabad haryana ','1160','3300'),(40,115,'forward','Delivered','29377','8518410214045','2022-03-10','Pre-paid','Surface','DIPVI MAHATME 9049981725','GARMENT','9049981725','FLAT NO 201 KAMATB PRESTIGE ST INEZ, LAND MARK OPP DUKLE HEVEN TALEIGAO ','1210',''),(41,48,'forward','Delivered','422216','8518410214060','2022-03-10','Pre-paid','Surface','arjun parjapti harpokhra','garment','9374265252','depria kothiwal ','4',''),(42,108,'forward','Delivered','18910','8518410214082','2022-03-11','COD','Surface','DEV RAJ','optical','8528368359',' #1783 dhsmesh nagar Naya gaon. Near navjeevan (clinic Mohali 8528368359 (Mohali_Nayagaon_D (Punjab) PIN:','349','1099'),(43,144,'forward','Pending','301514','8518410214115','2022-03-12','Pre-paid','Surface','somaa india pvt ltd 8368400800','energe machin tools ','8368400800','village aruwawa shushil building material nizamuddirnpur ','1851',''),(44,48,'forward','Delivered','14164','8518410214126','2022-03-12','Pre-paid','Surface','harleen kaur 8210732475','cosmetic product','8210732475','pp compound ranchi jarkhand near cake shop bakery house no 66','165',''),(45,86,'forward','Delivered','231110','8518410214152','2022-03-12','Pre-paid','Surface','RAM MURTI MEENA BOD GEM',' hospitel product ISTUMNT','9374265252','CSIS NATIONAL INSTITUTE OF OCEANOGRAPHY DONA PAULA , DEPARTMENT OF SCIENTIFIC AND INDUSTRIAL RESEARCH ( CSIR)','1000',''),(46,163,'forward','Delivered','42328','8518410214163','2022-03-12','Pre-paid','Express','MANISH BHADANI ','LEP TOP','9375555719',' PLOT NO 19, NEW PLOT AREA, ASODAR ROAD, NEAR KHODIYA MANDIR, BHINGRAD, TA LATHI, DI AMRELI, MOB: 9375555719','4000',''),(47,57,'forward','Not Picked','22104','8518410214174','2022-03-12','Pre-paid','Surface','CHARATMAL JAIN 9414786197','PLASTIC PUMP HOLI','9414786197','WORD NOMBER 15 KOTHARIYA KI CHOL DEVGADH RAJSHMAND 9460824435','500',''),(48,77,'forward','Delivered','323220','8518410214185','2022-03-12','Pre-paid','Express','CHARATMAL JAIN 9414786197','PICHKARI FOR HOLI','9414786197','WORD NOMBER 15 KOTHARIYA KI CHOL DEVGADH RAJSHMAND 9460824435','500',''),(49,60,'forward','Delivered','210706400','8518410214340','2022-03-15','Pre-paid','Surface','SAMIR GHUSH MO:7908519261','ELE COMPONENT','7908519261','BANKURA , KOTULPUR , L/M LEGO SA,OBAI SAMITI','400',''),(50,191,'forward','Delivered','361818','8518410214351','2022-03-15','Pre-paid','Surface','Rajesh sahu','HERBAL PRODUCT','8658321020','POST:-TILISINGI,BHALIASAHI,VIA-KU LLADA, GANJAM,ODISHA, 8658321020 9157777606','2450',''),(51,125,'forward','Delivered','221712','8518410214362','2022-03-15','Pre-paid','Surface','SHINEDAS 9995922022','PINAL BUTTERR','9995922022','LIYAMEL CHOCOLATES MEPPUKKADA MALAYINKEZHO PO ','1345',''),(52,115,'forward','Delivered','4029051400','8518410214384','2022-03-16','Pre-paid','Surface','RAMYA MO:9880217475','GARMENT','9880217475','ESAP UNIT SECOND FLOOR ADMINISTRAVE BULDING UAS CAMPUS','1400',''),(53,108,'forward','Delivered','18109','8518410214395','2022-03-16','COD','Surface','Mohit kalayana ','optical','9680704077',' A-3 shiv path colony khati pura road jhotwara jaipur Landmark: well baby hospital Mob No:9680704077','350','1099'),(54,86,'forward','Delivered','24109','8518410214406','2022-03-16','Pre-paid','Surface','LAXMI ENTERPRISE','MACHIN PARTS','9660787830',' NEAR PURANI POLICE CHOWKI ZOZAWAR 9660787830','669',''),(55,60,'forward','Delivered','291105400','8518410214432','2022-03-17','Pre-paid','Surface','BIMAL BANI','ELE COMPONENT','7697807276','CHUTE DEVGAON , NAURDHA CHOWK KHARSHIA','400',''),(56,86,'forward','Dispatched','20159','8518410214443','2022-03-19','Pre-paid','Surface','ROHIT SHARMA','PINAL BUTTER','7728042877','F 37 GREEN PARK COLONY AGRA ROAD JAIPUR 7728042877','615',''),(57,93,'forward','In Transit','31106','8518410214465','2022-03-21','COD','Surface','Ganesh Balasaheb Satav ','WOCHT','9850823294','Sr no 209 bhaghirathinagar hadapsar Hanuman mandir Maharashtra 9850823294','219','1200'),(58,99,'forward','In Transit','15148','8518410214476','2022-03-21','COD','Surface',': hikayathullah','AIRPORT','9342611859',': no2 pudumani kuppam mosque 2nd street Landmark : mosque ,thersa school City : chennai : 9342611859','219','700'),(59,48,'forward','In Transit','18105','8518410214491','2022-03-21','Pre-paid','Surface','AMRUTHA 9989318065','SEMPLE','9989318065','PLOT NO 18.C-O RAMESH CHANDRA BOSE BALAJI NAGAR DESAPATHRUNI PALEM PARAVADA INDUSTRIAL AREA ','185',''),(60,70,'forward','In Transit','211010','8518410214502','2022-03-21','Pre-paid','Surface','CH HAYIO 7002169913','SEMPLE PINNAL','7002169913','C-O BANK OF INDIA NEGC COMPLEX OPPOSITE STATE LIBRARY KOHIMA ','500',''),(61,57,'forward','In Transit','18187','8518410214513','2022-03-22','Pre-paid','Surface','D P SINGH 8171039177','WOCHT','8171039177','AHIYA PUR KALAN HATHRAS ','388','');
/*!40000 ALTER TABLE `jp1153` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jp1153_history`
--
DROP TABLE IF EXISTS `jp1153_history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jp1153_history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jp1153_history`
--
LOCK TABLES `jp1153_history` WRITE;
/*!40000 ALTER TABLE `jp1153_history` DISABLE KEYS */;
INSERT INTO `jp1153_history` VALUES (1,'jp1153','Self','500','2022-01-11'),(2,'jp1153','jp1153','500','2022-01-11'),(3,'jp1153','jp1153','100','2022-01-11'),(4,'jp1153','Self','1000','2022-01-11'),(5,'jp1153','Self','50','2022-01-11'),(6,'jp1153','jp1153','50','2022-01-11'),(7,'jp1153','hey543','200','2022-01-11'),(8,'jp1153','Self','500','2022-01-11'),(9,'jp1153','jay/852','40','2022-01-11'),(10,'jp1153','MIT_dhruv','500','2022-01-12'),(11,'jp1153','Self','5000','2022-01-12'),(12,'jp1153','MIT_dhruv','500','2022-01-12'),(13,'jp1153','jay45','10','2022-01-12'),(14,'jp1153','jp1153','50','2022-01-12'),(15,'jp1153','Self','10','2022-01-18'),(16,'jp1153','MIT_jignesh','50','2022-01-18'),(17,'jp1153','Self','1000','2022-01-26'),(18,'jp1153','MIT_Piyush250','200','2022-01-26'),(19,'jp1153','Self','10000','2022-01-27'),(20,'jp1153','MIT_dhruv','2000','2022-01-27'),(21,'jp1153','Self','10','2022-01-31'),(22,'jp1153','Self','20','2022-02-02'),(23,'jp1153','Order Placed With waybill: 12545845','37','2022-02-03'),(24,'jp1153','Order Placed With waybill: 123456854','37','2022-02-03'),(25,'jp1153','Order Placed With waybill: 12545845','37','2022-02-03'),(26,'jp1153','Order Placed With waybill: 8518410212822','37','2022-02-03'),(27,'jp1153','Order Placed With waybill: 123456854','37','2022-02-03'),(28,'jp1153','Order Placed With waybill: 8518410212833','37','2022-02-03'),(29,'jp1153','MIT_Amit888','1','2022-02-07'),(30,'jp1153','MIT_Dhruv243','500','2022-02-07'),(31,'jp1153','Order Placed With waybill: 8518410212973','37','2022-02-08'),(32,'jp1153','Order Placed With waybill: 8518410212984','125','2022-02-08'),(33,'jp1153','Order Placed With waybill: 8518410213021','47','2022-02-09'),(34,'jp1153','Order Placed With waybill: 8518410213382','70','2022-02-23'),(35,'jp1153','Order Placed With waybill: 8518410213404','110','2022-02-24'),(36,'jp1153','Self','12','2022-02-25'),(37,'jp1153','MIT_Dhruv243','210','2022-02-25'),(38,'jp1153','Order Placed With waybill: 8518410213441','37','2022-02-25'),(39,'jp1153','Order Placed With waybill: 8518410213452','54','2022-02-25'),(40,'jp1153','Order Placed With waybill: 8518410213485','37','2022-02-25'),(41,'jp1153','Order Placed With waybill: 8518410213570','42','2022-03-02'),(42,'jp1153','Order Placed With waybill: 8518410213581','42','2022-03-02'),(43,'jp1153','Order Placed With waybill: 8518410213592','57','2022-03-02'),(44,'jp1153','Order Placed With waybill: 8518410213603','297','2022-03-03'),(45,'jp1153','Order Placed With waybill: 8518410213614','81','2022-03-03'),(46,'jp1153','Order Placed With waybill: 8518410213625','86','2022-03-03'),(47,'jp1153','Order Placed With waybill: 8518410213640','60','2022-03-05'),(48,'jp1153','Order Placed With waybill: 8518410213754','88','2022-03-05'),(49,'jp1153','Order Placed With waybill: 8518410213765','57','2022-03-06'),(50,'jp1153','Order Placed With waybill: 8518410213776','48','2022-03-06'),(51,'jp1153','Order Placed With waybill: 8518410213780','47','2022-03-06'),(52,'jp1153','Order Placed With waybill: 8518410213835','70','2022-03-07'),(53,'jp1153','Order Placed With waybill: 8518410213850','115','2022-03-07'),(54,'jp1153','Order Placed With waybill: 8518410213920','88','2022-03-08'),(55,'jp1153','Order Placed With waybill: 8518410213942','125','2022-03-09'),(56,'jp1153','Order Placed With waybill: 8518410214012','93','2022-03-10'),(57,'jp1153','Order Placed With waybill: 8518410214023','108','2022-03-10'),(58,'jp1153','Order Placed With waybill: 8518410214034','178','2022-03-10'),(59,'jp1153','Order Placed With waybill: 8518410214045','115','2022-03-10'),(60,'jp1153','Order Placed With waybill: 8518410214060','48','2022-03-10'),(61,'jp1153','Order Placed With waybill: 8518410214082','108','2022-03-11'),(62,'jp1153','Order Placed With waybill: 8518410214115','144','2022-03-12'),(63,'jp1153','Order Placed With waybill: 8518410214126','48','2022-03-12'),(64,'jp1153','Order Placed With waybill: 8518410214152','86','2022-03-12'),(65,'jp1153','Order Placed With waybill: 8518410214163','163','2022-03-12'),(66,'jp1153','Order Placed With waybill: 8518410214174','57','2022-03-12'),(67,'jp1153','Order Placed With waybill: 8518410214185','77','2022-03-12'),(68,'jp1153','Order Placed With waybill: 8518410214340','60','2022-03-15'),(69,'jp1153','Order Placed With waybill: 8518410214351','191','2022-03-15'),(70,'jp1153','Order Placed With waybill: 8518410214362','125','2022-03-15'),(71,'jp1153','Order Placed With waybill: 8518410214384','115','2022-03-16'),(72,'jp1153','Order Placed With waybill: 8518410214395','108','2022-03-16'),(73,'jp1153','Order Placed With waybill: 8518410214406','86','2022-03-16'),(74,'jp1153','Order Placed With waybill: 8518410214432','60','2022-03-17'),(75,'jp1153','Order Placed With waybill: 8518410214443','86','2022-03-19'),(76,'jp1153','Order Placed With waybill: 8518410214465','93','2022-03-21'),(77,'jp1153','Order Placed With waybill: 8518410214476','99','2022-03-21'),(78,'jp1153','Order Placed With waybill: 8518410214491','48','2022-03-21'),(79,'jp1153','Order Placed With waybill: 8518410214502','70','2022-03-21'),(80,'jp1153','Order Placed With waybill: 8518410214513','57','2022-03-22');
/*!40000 ALTER TABLE `jp1153_history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_dhruv`
--
DROP TABLE IF EXISTS `mit_dhruv`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_dhruv` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`wallet` int(255) NOT NULL,
`diction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_dhruv`
--
LOCK TABLES `mit_dhruv` WRITE;
/*!40000 ALTER TABLE `mit_dhruv` DISABLE KEYS */;
/*!40000 ALTER TABLE `mit_dhruv` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_dhruv_history`
--
DROP TABLE IF EXISTS `mit_dhruv_history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_dhruv_history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Information` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_dhruv_history`
--
LOCK TABLES `mit_dhruv_history` WRITE;
/*!40000 ALTER TABLE `mit_dhruv_history` DISABLE KEYS */;
INSERT INTO `mit_dhruv_history` VALUES (1,'Received From jp1153','500','2022-01-12');
/*!40000 ALTER TABLE `mit_dhruv_history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_jignesh`
--
DROP TABLE IF EXISTS `mit_jignesh`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_jignesh` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`wallet` int(255) NOT NULL,
`diction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_jignesh`
--
LOCK TABLES `mit_jignesh` WRITE;
/*!40000 ALTER TABLE `mit_jignesh` DISABLE KEYS */;
/*!40000 ALTER TABLE `mit_jignesh` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_jignesh848`
--
DROP TABLE IF EXISTS `mit_jignesh848`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_jignesh848` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`wallet` int(255) NOT NULL,
`diction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_jignesh848`
--
LOCK TABLES `mit_jignesh848` WRITE;
/*!40000 ALTER TABLE `mit_jignesh848` DISABLE KEYS */;
/*!40000 ALTER TABLE `mit_jignesh848` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_jignesh848._history`
--
DROP TABLE IF EXISTS `mit_jignesh848._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_jignesh848._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_jignesh848._history`
--
LOCK TABLES `mit_jignesh848._history` WRITE;
/*!40000 ALTER TABLE `mit_jignesh848._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `mit_jignesh848._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_jp521`
--
DROP TABLE IF EXISTS `mit_jp521`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_jp521` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`wallet` int(255) NOT NULL,
`diction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_jp521`
--
LOCK TABLES `mit_jp521` WRITE;
/*!40000 ALTER TABLE `mit_jp521` DISABLE KEYS */;
/*!40000 ALTER TABLE `mit_jp521` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_jp521._history`
--
DROP TABLE IF EXISTS `mit_jp521._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_jp521._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_jp521._history`
--
LOCK TABLES `mit_jp521._history` WRITE;
/*!40000 ALTER TABLE `mit_jp521._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `mit_jp521._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_piyush177`
--
DROP TABLE IF EXISTS `mit_piyush177`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_piyush177` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`wallet` int(255) NOT NULL,
`diction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_piyush177`
--
LOCK TABLES `mit_piyush177` WRITE;
/*!40000 ALTER TABLE `mit_piyush177` DISABLE KEYS */;
/*!40000 ALTER TABLE `mit_piyush177` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_piyush177._history`
--
DROP TABLE IF EXISTS `mit_piyush177._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_piyush177._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_piyush177._history`
--
LOCK TABLES `mit_piyush177._history` WRITE;
/*!40000 ALTER TABLE `mit_piyush177._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `mit_piyush177._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_piyush250`
--
DROP TABLE IF EXISTS `mit_piyush250`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_piyush250` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`wallet` int(255) NOT NULL,
`diction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_piyush250`
--
LOCK TABLES `mit_piyush250` WRITE;
/*!40000 ALTER TABLE `mit_piyush250` DISABLE KEYS */;
/*!40000 ALTER TABLE `mit_piyush250` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_piyush250._history`
--
DROP TABLE IF EXISTS `mit_piyush250._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_piyush250._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_piyush250._history`
--
LOCK TABLES `mit_piyush250._history` WRITE;
/*!40000 ALTER TABLE `mit_piyush250._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `mit_piyush250._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_piyush697`
--
DROP TABLE IF EXISTS `mit_piyush697`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_piyush697` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`wallet` int(255) NOT NULL,
`direction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_piyush697`
--
LOCK TABLES `mit_piyush697` WRITE;
/*!40000 ALTER TABLE `mit_piyush697` DISABLE KEYS */;
/*!40000 ALTER TABLE `mit_piyush697` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_piyush697._history`
--
DROP TABLE IF EXISTS `mit_piyush697._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_piyush697._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_piyush697._history`
--
LOCK TABLES `mit_piyush697._history` WRITE;
/*!40000 ALTER TABLE `mit_piyush697._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `mit_piyush697._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_piyush841`
--
DROP TABLE IF EXISTS `mit_piyush841`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_piyush841` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`wallet` int(255) NOT NULL,
`direction_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Order id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Manifested_Date` date NOT NULL,
`Type_of_shipment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`mode_of_transition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_piyush841`
--
LOCK TABLES `mit_piyush841` WRITE;
/*!40000 ALTER TABLE `mit_piyush841` DISABLE KEYS */;
/*!40000 ALTER TABLE `mit_piyush841` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mit_piyush841._history`
--
DROP TABLE IF EXISTS `mit_piyush841._history`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mit_piyush841._history` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`Admin name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer To` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Transfer Coin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mit_piyush841._history`
--
LOCK TABLES `mit_piyush841._history` WRITE;
/*!40000 ALTER TABLE `mit_piyush841._history` DISABLE KEYS */;
/*!40000 ALTER TABLE `mit_piyush841._history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pick_up_points`
--
DROP TABLE IF EXISTS `pick_up_points`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pick_up_points` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`w_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`w_add` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`pin` int(255) NOT NULL,
`locality` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`c_person` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`r_add` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`r_pin` int(255) NOT NULL,
`r_locality` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`r_city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`r_state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`r_country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pick_up_points`
--
LOCK TABLES `pick_up_points` WRITE;
/*!40000 ALTER TABLE `pick_up_points` DISABLE KEYS */;
INSERT INTO `pick_up_points` VALUES (8,'softech','',394107,'amroli','surat','gujarat','india','Umang Kathiriya','email@email.com','9374265252','',394107,'amroli','surat','gujarat','india','active','jp1153'),(14,'AtoZ delhivery','5 SINDHI MARKET 1 ST FLOOR SINDHI MARKET AMBA CHOWK 9328415252',364001,'AMBA CHOWK','BHAVNAGAR','gujarat','india','ketan','INFO@MITINT.NET','9328415252','5 SINDHI MARKET 1 ST FLOOR SINDHI MARKET AMBA CHOWK 9328415252',364001,'AMBA CHOWK','BHAVNAGAR','gujarat','india','active','jp1153');
/*!40000 ALTER TABLE `pick_up_points` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`fname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`lname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`Company Name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Company Address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Company Logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Security Question` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Security Answer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`Date of Joining` date DEFAULT current_timestamp(),
`wallet` int(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (3,'jaydeep','prajapati','7069440745','jp818281@gmail.com','kolkata','145, Girnar soc.,amroli,surat','','jp1153','$2y$10$8YrowplZQTwLrT/.dxL6xerjyA6KKeBQiCH32Mf7601iwg4Wsf2Nq','Age','21','2022-01-03',550),(30,'jignesh','pj','7069440745','prajapatijaydeep664@gmail.com','home','A - 303 Shubhalaxmi apartment, Chhtunagar soc, sitanagar road punagam,amroli,surat','C:\\fakepath\\Desktop-Wallpaper-4.jpg','MIT_jignesh848','$2y$10$A6WRuT5rfL5eMyXmyDCy7ecPVZ8nhUZGHHQm9Xd4C1WSoqc5qzARm','birth-year','2001','2022-01-23',0),(32,'Piyush','Bhai','9856545852','hpnavadiya007@gmail.com','Dharmik','145,new soc.,katargam,amroli','','MIT_Piyush250','123','birth-year','2001','2022-01-24',200),(33,'Piyush','Bhai','9856545858','piebeta3601@gmail.com','Dharmik','145,new soc.,katargam,amroli','','MIT_Piyush177','123','birth-year','2001','2022-01-24',0),(35,'Piyush','Bhai','85645254854','jp818281@gmail.com','gtu','145,new soc.,katargam,amroli','C:\\fakepath\\a081c1b0-40c7-478c-b14a-9011cd325c93.jfif','MIT_Piyush747','123','birth-year','2001','2022-01-25',0),(36,'Piyush','Bhai','7548595685','jp818281@gmail.com','Dharmik','15,lol,katargam,amroli','C:\\fakepath\\Screenshot (11).png','MIT_Piyush841','123','Lucky number','55','2022-01-25',0),(37,'Piyush','Bhai','7545852545','jp818281@gmail.com','home','15,lol,katargam,amroli','C:\\fakepath\\favicon.ico','MIT_Piyush697','$2y$10$gDtjr0BQ9Ap/vyMVVvMBjeGghjPFMsG8mjHRcdTgYE/Y4p89Bm65i','birth-year','2001','2022-01-26',0),(39,'ajay','rathod','7069440745','jignesh6342@gmail.com','mayank','45,no way home,local,amroli','','MIT_ajay4','$2y$10$WTd3NNwGmAAydgUGKXFzZ.UEKWS7tOtC465892y1KIPRdy0fqrUSK','Lucky number','15','2022-01-29',-84),(40,'jaydeep','prajapati','7069440745','jp818281@gmail.com','jocks','145,line2,line3','dharmik.jpg','MIT_jaydeep555','$2y$10$k0KRBNxxNjumdCBEhhtILugV.NTPSddjMxDTlTGdhZNod9jNjl.Mi','Age','20','2022-01-29',NULL),(41,'harshil','patel','7856959685','harshillunagariya813@gmail.com','360softtech','145,opera business hub,lajamani chowk,Mota varachha,surat','Screenshot (11).png','MIT_harshil379','$2y$10$e0qZo3wZ7p4T3rMGVDRLYOySkYeNhg4Dizr1wIDSa8kepfdwoyhDy','Favourate-color','red','2022-02-07',NULL),(42,'jignesh','Dabhi','7069440745','jp818281@gmail.com','360softtech','145,opera business hub,lajamani chowk,Mota varachha,surat','Screenshot (14).png','MIT_jignesh777','$2y$10$yupg9Aebzaow0lmodF2lPuM6KPMD2g0cWtdiD2n/h3gjID5xwqN7O','birth-year','2001','2022-02-07',NULL),(43,'Amit','Shah','98595858569','jp818281@gmail.com','Home Minister','North block building,Rajpath,Delhi','Screenshot (4).png','MIT_Amit888','$2y$10$4CC/XRjMyDcSX5DjOAgVte4Rh4IlD10vtjYhnRvl0VhYkn.mALDZC','Nick-name','Mota Bhai','2022-02-07',1),(44,'Dhruv','Kaklotar','7069440745','kaklotardhruv09@gmail.com','dhruv mobile','145,new soc.,lajamani chowk,Mota varachha,amroli','login_logo.png','MIT_Dhruv243','$2y$10$C5ACX8H/5p3twO1qk1BXxOWKxXxTih9OhfFWDxEJK55y0whUSBYfy','birth-year','2022','2022-02-07',710),(47,'Umang ','Kathirya','7433005640','umangkathiriya743@gmail.com','360 Softtech','145, Opera Business Hub,Lajamani Chowk ,Mota Varachha Surat','Official Logo.png','MIT_Umang 601','$2y$10$JtklKnkRvZd9db4aBaxXNu2qtcaiWchdSmcWJTxbLG.HFxRNE0jHW','Lucky number','7','2022-02-08',NULL),(48,'jay','patel','7069440745','jp818281@gmail.com','office','A - 303 Shubhalaxmi apartment, Chhtunagar soc, sitanagar road punagam,amroli,surat','Desktop-Wallpaper-4.jpg','MIT_jay169','$2y$10$PkyunrdniPiIbcMKYcuEiOIcZjTO9p0Vp62I1eHKQ8VYpptAconla','birth-year','2000','2022-02-10',NULL),(49,'jignesh','pj','7069440745','prajapatijaydeep664@gmail.com','360softtech','145, girnar society ,chhaprabhatha road,surat','83346-CLIENT_LOGO.jpg','MIT_jignesh849','$2y$10$asMGIILGY6BfirCbH09MS.LMo3LEZWI/c9TYiMs5aeUw.zgY.ejGy','Lucky number','1153','2022-02-16',NULL);
/*!40000 ALTER TABLE `users` 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 2022-03-26 6:07:18