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

START TRANSACTION;



--
-- Database: `express`
--

-- --------------------------------------------------------

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `dname` varchar(200) NOT NULL,
  `userid` varchar(35) NOT NULL,
  `demail` varchar(30) NOT NULL,
  `dpass` varchar(60) NOT NULL,
  `dposition` varchar(30) NOT NULL DEFAULT 'subadmin',
  `dprivileges` varchar(100) CHARACTER SET latin1 NOT NULL,
  `daccName` varchar(30) DEFAULT NULL,
  `daccNum` varchar(50) DEFAULT NULL,
  `dbank` varchar(20) DEFAULT NULL,
  `drate` int(11) NOT NULL,
  `dkey` varchar(255) DEFAULT NULL,
  `dstatus` varchar(20) NOT NULL DEFAULT 'active',
  `lastlogin` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `dname`, `userid`, `demail`, `dpass`, `dposition`, `dprivileges`, `daccName`, `daccNum`, `dbank`, `drate`, `dkey`, `dstatus`, `lastlogin`) VALUES
(1, 'Admin', '2147400083647', 'admin@hugoglobal.com.ng', '21232f297a57a5a743894a0e4a801fc3', 'administrator', '', 'Express', '12312313', 'UBA', 740, 'AIzaSyDaUrghW4Bx5w1U3h8_MT-zgnSWpvNdNBU', 'active', '2020-02-27 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `daddress`
--

CREATE TABLE `daddress` (
  `id` int(11) NOT NULL,
  `aid` varchar(34) DEFAULT NULL,
  `dtitle` varchar(120) DEFAULT NULL,
  `dphone` varchar(50) DEFAULT NULL,
  `daddress` text DEFAULT NULL,
  `ddate` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `daddress`
--

INSERT INTO `daddress` (`id`, `aid`, `dtitle`, `dphone`, `daddress`, `ddate`) VALUES
(1, 'ab51c7514c40a7c335921e8f0ff56cc2', 'HUGO CHINA OFFICE', '+8618898321844', 'Shop AB19, 1f , Tong Tong Commercial Trade City, No 101, Guangyuan West Road, Yuexiu District.广东广州市越秀区广园西路101号通通商贸城A区负一层AB19档\r\n510000 Guangzhou City, Guangdong Province', '2022-12-15 15:27:18'),
(2, 'c540ad4a66906a36c59fe6bb3cfcdf80', 'HUGO EXPRESS SERVICE CENTER - AJAO ESTATE, LAGOS', '+234813 688 9809', '45, OSOLO WAY AJAO, LAGOS STATE.\r\n\r\nAjao Estate, Lagos', '2022-12-15 15:34:38'),
(3, '3df5c5026a0e6761acb92d42b391af76', 'HUGO EXPRESS STATION - MANDELLAS', '+2348032396491 +2349068569773', 'BLOCK L, SHOP SF3 , 2ND FLOOR . OPPOSITE TINUBU SQUARE WATER FALL .\r\nIDUMOTA, LAGOS', '2022-12-15 15:37:17'),
(4, '1decd65617d33ab1ccadb678bd126c2f', 'HUGO EXPRESS STATION - TRADEFAIR INTERNATIONAL MARKET', '+2347080815769', 'A.PT-GL BLOCK 5 SHOP 226, TRADE FAIR INTERNATIONAL MARKET.\r\n\r\nLAGOS, LAGOS', '2022-12-15 15:38:10'),
(5, 'd8c86a4121fab565cce5b9548a33008f', 'HUGO EXPRESS CONSOLIDATION STATION', '+8613500032394', 'ROOM 209, NO 22 GUANGYUAN MIDDLE ROAD , BAIYUN DISTRICT , GUANGZHOU , GAUNGDONG , CHINA.\r\n\r\n5100000 GUANGZHOU, GUANGDONG', '2022-12-15 15:39:08'),
(6, '3d5a4e5526d0be0d0fb883d2311904bc', 'HUGO LEKKI - STATION', '+2347025188549', 'OLIVE PLAZA , SUIT 25 , 14 LEKKI AJAH EXPRESS WAY (BY JAKANDE) OSAPA LONDON , LEKKI .\r\n\r\n106103\r\nEti-Osa, LAGOS', '2022-12-15 15:40:03'),
(7, '65710361c2a662e7bad544dbc0f884b0', 'HUGO STATION - IKEJA', '+2348103131274', 'NO 1 ADEOLA ADEOYE STREET, IKEJA ,LAGOS.\r\n\r\n0168\r\nIKEJA, LAGOS', '2022-12-15 15:41:18');

-- --------------------------------------------------------

--
-- Table structure for table `daddtional_charges`
--

CREATE TABLE `daddtional_charges` (
  `id` int(11) NOT NULL,
  `orderId` varchar(34) DEFAULT NULL,
  `damount` varchar(11) DEFAULT NULL,
  `dreasons` text DEFAULT NULL,
  `ddate` varchar(24) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `daddtional_charges`
--

INSERT INTO `daddtional_charges` (`id`, `orderId`, `damount`, `dreasons`, `ddate`) VALUES
(1, 'HGE20230124030704', '20000', 'Custom clearing with additional charge', '2023-02-02 11:46:00'),
(2, 'HGE20230124030704', '8000', 'Another charges', '2023-02-02 11:57:51'),
(3, 'HGE20230206040914', '8000', 'Police issues', '2023-02-10 14:33:18'),
(4, 'HGE20230216105903', '8000', 'Police settlement', '2023-02-16 11:34:32'),
(5, 'HGE20230223054137', '1000', 'mmm', '2023-02-23 17:45:33'),
(7, 'HGE0987654678999', '8000', 'Custom clearing and Nigeria police', '2023-02-27 14:23:24');

-- --------------------------------------------------------

--
-- Table structure for table `ddomestic_order`
--

CREATE TABLE `ddomestic_order` (
  `id` int(11) NOT NULL,
  `did` varchar(34) DEFAULT NULL,
  `userid` varchar(34) DEFAULT NULL,
  `dfname` varchar(100) DEFAULT NULL,
  `phone` varchar(40) DEFAULT NULL,
  `demail` varchar(50) DEFAULT NULL,
  `title` text DEFAULT NULL,
  `dshipping_type` varchar(34) DEFAULT NULL,
  `dservice_type` varchar(34) DEFAULT NULL,
  `ditem` text DEFAULT NULL,
  `pname` varchar(100) DEFAULT NULL,
  `plocation` varchar(100) DEFAULT NULL,
  `paddress` text DEFAULT NULL,
  `pzip` varchar(15) DEFAULT NULL,
  `pcity` varchar(50) DEFAULT NULL,
  `pstate` varchar(50) DEFAULT NULL,
  `plat` varchar(25) DEFAULT NULL,
  `plong` varchar(25) DEFAULT NULL,
  `pphone` varchar(40) DEFAULT NULL,
  `paltPhone` varchar(40) DEFAULT NULL,
  `pextra` text DEFAULT NULL,
  `dname` varchar(100) DEFAULT NULL,
  `dlocation` varchar(100) DEFAULT NULL,
  `daddress` text DEFAULT NULL,
  `dzip` varchar(15) DEFAULT NULL,
  `dcity` varchar(50) DEFAULT NULL,
  `dstate` varchar(50) DEFAULT NULL,
  `dlat` varchar(25) DEFAULT NULL,
  `dlong` varchar(25) DEFAULT NULL,
  `ddistance` varchar(11) DEFAULT NULL,
  `dphone` varchar(40) DEFAULT NULL,
  `daltPhone` varchar(40) DEFAULT NULL,
  `dextra` text DEFAULT NULL,
  `dpaymentStatus` varchar(15) NOT NULL DEFAULT 'pending',
  `sstatus` varchar(15) DEFAULT 'pending',
  `dtracking` varchar(34) DEFAULT NULL,
  `rdate` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ddomestic_order`
--

INSERT INTO `ddomestic_order` (`id`, `did`, `userid`, `dfname`, `phone`, `demail`, `title`, `dshipping_type`, `dservice_type`, `ditem`, `pname`, `plocation`, `paddress`, `pzip`, `pcity`, `pstate`, `plat`, `plong`, `pphone`, `paltPhone`, `pextra`, `dname`, `dlocation`, `daddress`, `dzip`, `dcity`, `dstate`, `dlat`, `dlong`, `ddistance`, `dphone`, `daltPhone`, `dextra`, `dpaymentStatus`, `sstatus`, `dtracking`, `rdate`) VALUES
(1, 'HGE20230206040914', 'c4764b3ed69827456689cf7b62865400', 'Elefiku Stephen Adedeji', '09098523804', 'youngelefiku1@gmail.com', 'Request me', '3b7cfe7c8f17b520c7b19895eb27369a', 'a9a0a0912a5e6bd5700762c1ba5d315e', 'package', 'Young Adedeji', 'Toyin street ikeja, Toyin Street, Ikeja, Nigeria', 'No 4 Toyin street', '101233', 'Ikeja', 'Lagos', '4.8316227', '7.0047001', '09876534', '3455', 'comment', 'Oluwaseun Adedeji', 'Rumuola Bus Stop, Aba Road, Port Harcourt, Nigeria', '23897654', '500102', 'Port Harcourt', 'Rivers', '', '', '449.37', '09098523804', '3456789', 'extra part 2', 'pending', 'pending', 'HUGT9876543', '2023-02-10 10:23:00'),
(2, 'HGE20230206041912', 'c4764b3ed69827456689cf7b62865400', 'Elefiku Stephen Adedeji', '09098523804', 'youngelefiku1@gmail.com', 'option', '3b7cfe7c8f17b520c7b19895eb27369a', '55c5a6e17ed7cdfaab080f4d837f73a4', 'pack', 'Young Adedeji', 'Rumuola Bus Stop, Aba Road, Port Harcourt, Nigeria', '23', '500102', 'Port Harcourt', 'Rivers', '4.8316227', '7.0047001', '09876534', '34567890', 'comment', 'Oluwaseun Adedeji', 'Toyin street ikeja, Toyin Street, Ikeja, Nigeria', '04', '101233', 'Ikeja', 'Lagos', '6.5964847', '3.346078', '449.37', '90876543234', '34534535546', 'rxtra', 'pending', 'pending', NULL, '2023-02-06 16:19:12'),
(3, 'HGE20230216105903', 'cbda3f6115d51141567c51ac354d3550', 'Isaac Newton', '09098142565', 'isaacnewton@gmail.com', 'Goods', '3b7cfe7c8f17b520c7b19895eb27369a', '55c5a6e17ed7cdfaab080f4d837f73a4', 'food items', 'Young Adedeji', 'Toyin street ikeja, Toyin Street, Ikeja, Nigeria', 'No 4 Toyin street', '101233', 'Ikeja', 'Lagos', '6.5964847', '3.346078', '09876534', '34567890', '', 'Oluwaseun Adedeji', 'Emmanuel Plaza, Chief G U Ake Road, Port Harcourt, Nigeria', 'plot 15 &amp; 16', '500102', 'Obio/Akpor', 'Rivers', '4.8676034', '7.0175513', '449.37', '90876543234', '34534535546', '', 'pending', 'pending', 'HUG09876500', '2023-02-16 10:59:03'),
(5, 'HGE20230227023738', '46e729f542086631c50d40577572b701', '', '', '', 'Testing', '3b7cfe7c8f17b520c7b19895eb27369a', 'a9a0a0912a5e6bd5700762c1ba5d315e', '', 'Emmanuel Plaza', '', 'Plot 15 &amp; 16', '500102', 'Obio/Akpor', 'Rivers', '4.8676034', '', '0809876543', '', 'Opposite RCCG Jesus Court', 'Emmanuel Plaza', '', 'Plot 15 &amp; 16', '500102', 'Obio/Akpor', 'Rivers', '4.8676034', '', '0.00', '0809876543', '', 'Opposite RCCG Jesus Court', 'pending', 'pending', NULL, '2023-02-27 14:37:38'),
(6, 'HGE20230227024622', '46e729f542086631c50d40577572b701', 'Temiloluwa Stephen', '07055553109', 'temiloluwa@gmail.com', 'Testing', 'd3be64ff42c59b433055c4bd5fc9919e', 'a9a0a0912a5e6bd5700762c1ba5d315e', '', 'Emmanuel Plaza', '', 'Plot 15 &amp; 16', '500102', 'Obio/Akpor', 'Rivers', '4.8676034', '', '0809876543', '', 'Opposite RCCG Jesus Court', 'Emmanuel Plaza', '', 'Plot 15 &amp; 16', '500102', 'Obio/Akpor', 'Rivers', '4.8676034', '', '0.00', '0809876543', '', 'Opposite RCCG Jesus Court', 'pending', 'pending', NULL, '2023-02-27 14:46:22'),
(7, 'HGE20230227043715', '46e729f542086631c50d40577572b701', 'Temiloluwa Stephen', '07055553109', 'temiloluwa@gmail.com', 'Testing', '3b7cfe7c8f17b520c7b19895eb27369a', '55c5a6e17ed7cdfaab080f4d837f73a4', '', 'Emmanuel Plaza', '', 'Plot 15 &amp; 16', '500102', 'Obio/Akpor', 'Rivers', '4.8676034', '', '0809876543', '', 'Opposite RCCG Jesus Court', 'Emmanuel Plaza', '', 'Plot 15 &amp; 16', '500102', 'Obio/Akpor', 'Rivers', '4.8676034', '', '0.00', '0809876543', '', 'Opposite RCCG Jesus Court', 'pending', 'pending', NULL, '2023-02-27 16:37:15');

-- --------------------------------------------------------

--
-- Table structure for table `dinternational_order`
--

CREATE TABLE `dinternational_order` (
  `id` int(11) NOT NULL,
  `orderId` varchar(34) DEFAULT NULL,
  `userid` varchar(34) DEFAULT NULL,
  `dfname` varchar(50) DEFAULT NULL,
  `dphone` varchar(25) DEFAULT NULL,
  `demail` varchar(50) DEFAULT NULL,
  `dshipping_type` varchar(34) DEFAULT NULL,
  `dtitlex` varchar(255) DEFAULT NULL,
  `dservice_type` varchar(34) DEFAULT NULL,
  `daddressx` varchar(255) DEFAULT NULL,
  `dextra` text DEFAULT NULL,
  `dtracking` varchar(34) DEFAULT NULL,
  `dstatus` varchar(15) DEFAULT 'pending',
  `dadmin_comment` text DEFAULT NULL,
  `dpayment` varchar(10) NOT NULL DEFAULT 'pending',
  `darrival` varchar(25) DEFAULT NULL,
  `ddelivery` varchar(25) DEFAULT NULL,
  `ddatex` varchar(25) DEFAULT NULL,
  `dcanReasons` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dinternational_order`
--

INSERT INTO `dinternational_order` (`id`, `orderId`, `userid`, `dfname`, `dphone`, `demail`, `dshipping_type`, `dtitlex`, `dservice_type`, `daddressx`, `dextra`, `dtracking`, `dstatus`, `dadmin_comment`, `dpayment`, `darrival`, `ddelivery`, `ddatex`, `dcanReasons`) VALUES
(5, 'HGE20230124023842', 'Guess', 'Adedeji Temiloluwa', '+2348103131274', 'temiloluwa@gmail.com', '27b47af9f101e4ace01eaa9bf175c198', 'Request for me', '902abb1ccc1eef116bb3dab6e85453d7', '65710361c2a662e7bad544dbc0f884b0', 'Drop this at Ikeja', 'HUG12345678', 'Processed', NULL, 'pending', NULL, NULL, '2023-01-25 15:20:25', NULL),
(6, 'HGE20230124030704', 'c4764b3ed69827456689cf7b62865400', 'Elefiku Stephen Adedeji', '09098523804', 'youngelefiku1@gmail.com', '27b47af9f101e4ace01eaa9bf175c198', 'Thank you', '902abb1ccc1eef116bb3dab6e85453d7', '65710361c2a662e7bad544dbc0f884b0', 'Drop this for me at  IKeja', 'HUG09876543', 'Delivered', NULL, 'Paid', '10/3/2023', '15/3/2023', '2023-02-01 16:45:26', NULL),
(7, 'HGE20230202012135', 'cbda3f6115d51141567c51ac354d3550', 'Isaac Newton', '09098142565', 'isaacnewton@gmail.com', '27b47af9f101e4ace01eaa9bf175c198', '', 'b8cd8b0fc90909cc0939e49e684ef2da', 'd8c86a4121fab565cce5b9548a33008f', '', NULL, 'Cancelled', NULL, 'pending', '10/3/2023', '15/3/2023', '2023-02-02 13:21:35', 'Big problemm'),
(8, 'HGE0987654678999', '46e729f542086631c50d40577572b701', 'Temiloluwa Stephen', '07055553109', 'temiloluwa@gmail.com', '4cc3b84b5b9e906646556c0cc0476bee', 'Testing', 'b8cd8b0fc90909cc0939e49e684ef2da', '3df5c5026a0e6761acb92d42b391af76', 'Test', NULL, 'pending', NULL, 'pending', '10/3/2023', '15/3/2023', '2023-02-23 11:39:06', NULL),
(10, 'HGE05315b02087', '46e729f542086631c50d40577572b701', 'Temiloluwa Stephen', '07055553109', 'temiloluwa@gmail.com', '218b1d569eb1e5cba9d8d12b9ea9d970', '', '92195ef7893c06a3055de49fe36f0517', '21194fd176d7bd32ad9e17d6694460c3', '', 'HUG123432544455', 'pending', NULL, 'pending', '10/3/2023', '15/3/2023', '2023-02-23 12:10:03', NULL),
(11, 'HGE20230223123031', '46e729f542086631c50d40577572b701', 'Temiloluwa Stephen', '07055553109', 'temiloluwa@gmail.com', '4cc3b84b5b9e906646556c0cc0476bee', '', '902abb1ccc1eef116bb3dab6e85453d7', '1decd65617d33ab1ccadb678bd126c2f', '', NULL, 'pending', NULL, 'pending', '10/3/2023', '15/3/2023', '2023-02-23 12:30:31', NULL),
(12, 'HGE20230223054137', 'c4764b3ed69827456689cf7b62865400', 'Elefiku Stephen Adedeji', '09098523804', 'youngelefiku1@gmail.com', '4cc3b84b5b9e906646556c0cc0476bee', '', '902abb1ccc1eef116bb3dab6e85453d7', '3df5c5026a0e6761acb92d42b391af76', '', NULL, 'pending', NULL, 'pending', '10/3/2023', '15/3/2023', '2023-02-23 17:41:37', NULL),
(14, 'HGE20230228125523', 'Guess', 'Testing Cart', '08037803996', 'testnetwork@test.com', '218b1d569eb1e5cba9d8d12b9ea9d970', 'Respect me', '902abb1ccc1eef116bb3dab6e85453d7', 'ab51c7514c40a7c335921e8f0ff56cc2', 'No comment', NULL, 'pending', NULL, 'pending', '10/3/2023', '15/3/2023', '2023-02-28 12:55:23', NULL),
(18, 'HGE20230228010649', 'Guess', 'Testing Cart', '08037803996', 'testnetwork@test.com', '27b47af9f101e4ace01eaa9bf175c198', 'aSsAS', '92195ef7893c06a3055de49fe36f0517', 'ab51c7514c40a7c335921e8f0ff56cc2', 'ADAdd', NULL, 'pending', NULL, 'pending', '10/3/2023', '15/3/2023', '2023-02-28 13:06:49', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `dinvoice`
--

CREATE TABLE `dinvoice` (
  `id` int(11) NOT NULL,
  `orderId` varchar(34) DEFAULT NULL,
  `dvolume` varchar(15) DEFAULT '0',
  `dcustom` varchar(15) DEFAULT '0',
  `ddiscount` varchar(11) DEFAULT '0',
  `idate` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dinvoice`
--

INSERT INTO `dinvoice` (`id`, `orderId`, `dvolume`, `dcustom`, `ddiscount`, `idate`) VALUES
(2, 'HGE20230124030704', '50', '45', '10', '2023-02-02 11:29:26'),
(3, 'HGE20230124023842', '50', '45', '10', '2023-02-02 11:29:26'),
(4, 'HGE20230202012135', '0', '0', '0', NULL),
(5, 'HGE20230206040914', '50', '10', '0', '2023-02-10 14:29:13'),
(6, 'HGE20230206041912', '0', '0', '0', NULL),
(7, 'HGE20230216105903', '0', '0', '0', NULL),
(8, 'HGE0987654678999', '50', '50', '0', '2023-02-27 12:14:32'),
(10, 'HGE05315b02087', '100', '100', '0', '2023-02-23 13:25:50'),
(11, 'HGE20230223123031', '0', '0', '0', NULL),
(12, 'HGE20230223054137', '50', '100', '0', '2023-02-23 17:43:42'),
(13, 'HGE20230227022549', '0', '0', '0', NULL),
(14, 'HGE20230227023738', '0', '0', '0', NULL),
(15, 'HGE20230227024622', '0', '0', '0', NULL),
(16, 'HGE20230227043715', '0', '0', '0', NULL),
(17, 'HGE20230228125523', '0', '0', '0', NULL),
(18, 'HGE20230228125523', '0', '0', '0', NULL),
(19, 'HGE20230228125711', '0', '0', '0', NULL),
(20, 'HGE20230228125711', '0', '0', '0', NULL),
(21, 'HGE20230228125935', '0', '0', '0', NULL),
(22, 'HGE20230228010649', '0', '0', '0', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `dlogin`
--

CREATE TABLE `dlogin` (
  `id` int(11) NOT NULL,
  `userid` varchar(34) DEFAULT NULL,
  `username` text DEFAULT NULL,
  `drefCode` varchar(20) DEFAULT NULL,
  `dfname` varchar(100) DEFAULT NULL,
  `demail` varchar(30) DEFAULT NULL,
  `dphone` varchar(20) DEFAULT NULL,
  `daddress` text DEFAULT NULL,
  `dwallet` varchar(11) NOT NULL DEFAULT '0.00',
  `dpass` varchar(34) DEFAULT NULL,
  `ddob` varchar(24) DEFAULT NULL,
  `daccNum` varchar(20) DEFAULT NULL,
  `daccName` varchar(50) DEFAULT NULL,
  `dbank` varchar(20) DEFAULT NULL,
  `dpin` varchar(8) DEFAULT NULL,
  `dpinExp` varchar(25) DEFAULT NULL,
  `dstatus` varchar(10) DEFAULT 'pending',
  `ddate` varchar(25) DEFAULT NULL,
  `dref` varchar(20) DEFAULT NULL,
  `dref2` varchar(34) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dlogin`
--

INSERT INTO `dlogin` (`id`, `userid`, `username`, `drefCode`, `dfname`, `demail`, `dphone`, `daddress`, `dwallet`, `dpass`, `ddob`, `daccNum`, `daccName`, `dbank`, `dpin`, `dpinExp`, `dstatus`, `ddate`, `dref`, `dref2`) VALUES
(6, 'c4764b3ed69827456689cf7b62865400', 'Elefiku6', '3100000', 'Elefiku Stephen Adedeji', 'youngelefiku1@gmail.com', '09098523804', 'Aso rock villa, Abuja', '158000', '4adf7d6eebb0266197b2d52a6273865b', '05-11-2006', '', '', '', '8414', '2023-02-20 14:49:02', 'active', '2022-08-31 15:46:32', '845891', NULL),
(22, '46e729f542086631c50d40577572b701', 'Temiloluwa22', '226112640', 'Temiloluwa Stephen', 'temiloluwa@gmail.com', '07055553109', NULL, '0.00', 'bc0cbcacee08d345efe88f4e447db6ab', NULL, NULL, NULL, NULL, '3493', '2023-02-27 18:01:08', 'pending', '2023-02-20 12:08:49', NULL, NULL),
(23, 'fb23a28a0f0cccecc18ddbc67527b2e4', 'James23', '235654059', 'James Smith', 'jamessmith@gmail.com', '08142466947', NULL, '0.00', 'b4cc344d25a2efe540adbf2678e2304c', NULL, NULL, NULL, NULL, NULL, NULL, 'active', '2023-02-20 12:31:01', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `dorders`
--

CREATE TABLE `dorders` (
  `id` int(11) NOT NULL,
  `oid` varchar(34) DEFAULT NULL,
  `bookingId` varchar(34) DEFAULT NULL,
  `userid` varchar(34) DEFAULT NULL,
  `dtitle` varchar(255) DEFAULT NULL,
  `dservice` varchar(255) DEFAULT NULL,
  `dsddress` text DEFAULT NULL,
  `dcomment` text DEFAULT NULL,
  `dwaybillNumber` varchar(100) DEFAULT NULL,
  `dcourieName` varchar(255) DEFAULT NULL,
  `dtype` varchar(15) DEFAULT NULL,
  `dstatus` varchar(15) DEFAULT NULL,
  `ddate` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `dprice`
--

CREATE TABLE `dprice` (
  `id` int(11) NOT NULL,
  `pid` varchar(34) DEFAULT NULL,
  `aid` varchar(34) DEFAULT NULL,
  `dtitle` varchar(150) DEFAULT NULL,
  `dprice` varchar(120) DEFAULT NULL,
  `ddate` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dprice`
--

INSERT INTO `dprice` (`id`, `pid`, `aid`, `dtitle`, `dprice`, `ddate`) VALUES
(5, 'db71dc30025fc112d41c6515b7c3ee5a', 'ab51c7514c40a7c335921e8f0ff56cc2', 'Express (1-2 days)', '(USD 13.00 per KG)', '2022-12-15 16:53:35'),
(6, '9a6ab9e78421fa02ae34a8792486b2d1', 'ab51c7514c40a7c335921e8f0ff56cc2', 'Express Cargo Customs Clearing', '(NGN 700.00 per KG)', '2022-12-15 16:54:50'),
(7, '1910f4d4ac522caddb800738dfaaaf22', 'ab51c7514c40a7c335921e8f0ff56cc2', 'Express Cargo (3-4 days)', '(USD 11.50 per KG)', '2022-12-15 16:55:10'),
(8, '0e0c1f1f3dfcdd1559494f8605ee0667', 'ab51c7514c40a7c335921e8f0ff56cc2', 'Air Cargo ( 14 - 16 days) Custom Clearing', '(NGN 530.00 per KG)', '2022-12-15 16:55:23'),
(9, 'd673acae6ceb96f09162167781a28361', 'ab51c7514c40a7c335921e8f0ff56cc2', 'Air Cargo Customs Clearing', '(NGN 530.00 per KG)', '2022-12-15 16:55:41'),
(10, 'ab39db4dbdd489e2d8125a51decc818b', 'ab51c7514c40a7c335921e8f0ff56cc2', 'Sea Cargo (50-60 days)', '(NGN 240,000.00 per CBM)', '2022-12-15 16:55:54'),
(11, '869d1626d05318a2cf202d61f66df03d', 'ab51c7514c40a7c335921e8f0ff56cc2', 'AIR CARGO (15-20DAYS). BATTERY AND LIQUID GOODS', '(USD 8.50 per KG)', '2022-12-15 16:56:07'),
(12, '3eb794103a93a2884a0bef6b5fd11a68', 'ab51c7514c40a7c335921e8f0ff56cc2', 'Air Cargo (5-7 days)', '(USD 7.80 per KG)', '2022-12-15 16:56:22'),
(13, 'ed16514c08cab7c09417b755c95d7034', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'Express (1-2 days)', '(USD 13.00 per KG)', '2022-12-15 16:58:59'),
(14, 'f090620fa34db45fea945840b0419d7d', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'Express Cargo Customs Clearing', '(NGN 700.00 per KG)', '2022-12-15 16:59:14'),
(15, 'c2435431719140a854aefdad55675ac5', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'Express Cargo (3-4 days)', '(USD 11.50 per KG)', '2022-12-15 16:59:26'),
(16, 'cf151091def093d8d22bfd3e6a145875', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'Express Customs Clearing', '(NGN 700.00 per KG)', '2022-12-15 16:59:43'),
(17, 'c35ae877d2e27e000903fb733df989cf', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'Regular Express Delivery', '(NGN 400.00 per KG)', '2022-12-15 16:59:55'),
(18, 'e3d1bc19402c66e6ff56910271b67f47', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'Normal Delivery Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:00:09'),
(19, '395ce88e696a696674fa0e752247b631', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'Instant Express Delivery', '(NGN 600.00 per KG)', '2022-12-15 17:00:21'),
(20, '743fa66cc44592b08845be6815c02c9d', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'Normal Delivery (Heavy goods 20 kg+)', '(NGN 180.00 per KG)', '2022-12-15 17:00:38'),
(21, 'dcf86268ae65e1489e08aea4245ee94b', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'Instant Express Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:00:51'),
(22, '79b6e6c9afa159565bc11b7b69fa54eb', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'Regular Express Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:01:05'),
(23, '9e606bff8a23d403c46c13239736e23f', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'Air Cargo ( 14 - 16 days) Custom Clearing', '(NGN 530.00 per KG)', '2022-12-15 17:01:16'),
(24, '7d522aac3fed83ab94c80be5f4809519', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'Air Cargo Customs Clearing', '(NGN 530.00 per KG)', '2022-12-15 17:01:44'),
(25, '5e9628e4eec3d36792e0571225ffb617', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'Sea Cargo (50-60 days)', '(NGN 240,000.00 per CBM)', '2022-12-15 17:01:57'),
(26, 'a7efc209b3539851a9999ed85d70f905', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'AIR CARGO (15-20DAYS). BATTERY AND LIQUID GOODS', '(USD 8.50 per KG)', '2022-12-15 17:02:11'),
(27, 'fd1e06791a5d01f78e7816e05b225fef', 'c540ad4a66906a36c59fe6bb3cfcdf80', 'Air Cargo (5-7 days)', '(USD 7.80 per KG)', '2022-12-15 17:02:22'),
(28, '27fcac0268b9b5dadfd8e382c254d89b', '3df5c5026a0e6761acb92d42b391af76', 'Express (1-2 days)', '(USD 13.00 per KG)', '2022-12-15 17:03:24'),
(29, '61c091de77f68b4892b5bd845bd7e207', '3df5c5026a0e6761acb92d42b391af76', 'Express Cargo Customs Clearing', '(NGN 700.00 per KG)', '2022-12-15 17:03:48'),
(30, '1805102f95ad97cd7c403dd1be6172fd', '3df5c5026a0e6761acb92d42b391af76', 'Express Cargo (3-4 days)', '(USD 11.50 per KG)', '2022-12-15 17:04:01'),
(31, '4ac526378ae050918deef561060ff633', '3df5c5026a0e6761acb92d42b391af76', 'Express Customs Clearing', '(NGN 700.00 per KG)', '2022-12-15 17:04:14'),
(32, '771cf43d6e97bdb27ac622ba063d3a31', '3df5c5026a0e6761acb92d42b391af76', 'Regular Express Delivery', '(NGN 400.00 per KG)', '2022-12-15 17:04:25'),
(33, '2ad4a0725473b2e06b96d363cf8a2497', '3df5c5026a0e6761acb92d42b391af76', 'Normal Delivery Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:04:38'),
(34, 'bc34be7dd04ba3373689532f65829b76', '3df5c5026a0e6761acb92d42b391af76', 'Instant Express Delivery', '(NGN 600.00 per KG)', '2022-12-15 17:04:52'),
(35, '1591ffe591a9ff9ac2ae2c2fe1be046b', '3df5c5026a0e6761acb92d42b391af76', 'Normal Delivery (Heavy goods 20 kg+)', '(NGN 180.00 per KG)', '2022-12-15 17:05:04'),
(36, '8ff314aa478272d89c1d89a193edbb19', '3df5c5026a0e6761acb92d42b391af76', 'Instant Express Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:05:16'),
(37, '73cbb4247a34fd047526bdc5569d6445', '3df5c5026a0e6761acb92d42b391af76', 'Regular Express Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:05:28'),
(38, '338580895540511af2e9c4c0447e51ef', '3df5c5026a0e6761acb92d42b391af76', 'Air Cargo ( 14 - 16 days) Custom Clearing', '(NGN 530.00 per KG)', '2022-12-15 17:05:40'),
(39, '642f673e5f66fc309211d3594dadb391', '3df5c5026a0e6761acb92d42b391af76', 'Air Cargo Customs Clearing', '(NGN 530.00 per KG)', '2022-12-15 17:05:54'),
(40, '1e74c358d025b18f22034de098f53800', '3df5c5026a0e6761acb92d42b391af76', 'Sea Cargo (50-60 days)', '(NGN 240,000.00 per CBM)', '2022-12-15 17:06:06'),
(41, '535e864848467ed7a91b603b4c6a8098', '3df5c5026a0e6761acb92d42b391af76', 'AIR CARGO (15-20DAYS). BATTERY AND LIQUID GOODS', '(USD 8.50 per KG)', '2022-12-15 17:06:55'),
(42, '3469509a3d68414727cbacece31aa31d', '3df5c5026a0e6761acb92d42b391af76', 'Air Cargo (5-7 days)', '(USD 7.80 per KG)', '2022-12-15 17:07:09'),
(43, '1dd45cba236a604f2772a23b58e068d5', '1decd65617d33ab1ccadb678bd126c2f', 'Express (1-2 days)', '(USD 13.00 per KG)', '2022-12-15 17:07:56'),
(44, 'cf0fab3ef07dc69115b35453501214e7', '1decd65617d33ab1ccadb678bd126c2f', 'Express Cargo Customs Clearing', '(NGN 700.00 per KG)', '2022-12-15 17:10:56'),
(45, 'ab3219651439ae5e34e58a0de9cdb3ea', '1decd65617d33ab1ccadb678bd126c2f', 'Express Cargo (3-4 days)', '(USD 11.50 per KG)', '2022-12-15 17:11:08'),
(46, 'b15aef965270a24769d141f7f04a9321', '1decd65617d33ab1ccadb678bd126c2f', 'Express Customs Clearing', '(NGN 700.00 per KG)', '2022-12-15 17:11:24'),
(47, 'f3b657a60fc17fcb965bb75c2a18e2fb', '1decd65617d33ab1ccadb678bd126c2f', 'Regular Express Delivery', '(NGN 400.00 per KG)', '2022-12-15 17:11:36'),
(48, '3bedd160151b2b362897cfbabea28e8f', '1decd65617d33ab1ccadb678bd126c2f', 'Normal Delivery Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:11:49'),
(49, '5a593440b728b07d0d5241cb4ed3f899', '1decd65617d33ab1ccadb678bd126c2f', 'Instant Express Delivery', '(NGN 600.00 per KG)', '2022-12-15 17:12:06'),
(50, 'ec36c0e5e892569b7d1d1509e68d74c0', '1decd65617d33ab1ccadb678bd126c2f', 'Normal Delivery (Heavy goods 20 kg+)', '(NGN 180.00 per KG)', '2022-12-15 17:12:19'),
(51, '79d106f592ae93e5c8a198633c5e53ae', '1decd65617d33ab1ccadb678bd126c2f', 'Instant Express Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:12:34'),
(52, '9cac37911ee53ba7652842a1a4a34e46', '1decd65617d33ab1ccadb678bd126c2f', 'Regular Express Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:12:46'),
(53, 'cc0df1b67cda246eea1ad2b7a28cf868', '1decd65617d33ab1ccadb678bd126c2f', 'Air Cargo ( 14 - 16 days) Custom Clearing', '(NGN 530.00 per KG)', '2022-12-15 17:12:59'),
(54, 'c4d51cf89a998921f2d130d2a77cc992', '1decd65617d33ab1ccadb678bd126c2f', 'Air Cargo Customs Clearing', '(NGN 530.00 per KG)', '2022-12-15 17:13:13'),
(55, '31525399f19872cccf3ad45665baae2c', '1decd65617d33ab1ccadb678bd126c2f', 'Sea Cargo (50-60 days)', '(NGN 240,000.00 per CBM)', '2022-12-15 17:13:38'),
(56, '36a5ebbeb9007f5a79acd3d9232c6ec1', '1decd65617d33ab1ccadb678bd126c2f', 'AIR CARGO (15-20DAYS). BATTERY AND LIQUID GOODS', '(USD 8.50 per KG)', '2022-12-15 17:13:55'),
(57, 'ea337f523dbefa295a0d7deb1365923e', '1decd65617d33ab1ccadb678bd126c2f', 'Air Cargo (5-7 days)', '(USD 8.50 per KG)', '2022-12-15 17:14:08'),
(58, 'ef22061655c2b35a769a3f3862829ed3', '1decd65617d33ab1ccadb678bd126c2f', 'Air Cargo (5-7 days)', '(USD 7.80 per KG)', '2022-12-15 17:18:13'),
(59, '7a50dd18e790522313abe5f261d5b941', 'd8c86a4121fab565cce5b9548a33008f', 'Express (1-2 days)', '(USD 13.00 per KG)', '2022-12-15 17:21:56'),
(60, 'cfac01d979de2901cc6b124361db231b', 'd8c86a4121fab565cce5b9548a33008f', 'Express Cargo (3-4 days)', '(USD 11.50 per KG)', '2022-12-15 17:22:06'),
(61, '38cac932349c247b36d7bd142839c222', 'd8c86a4121fab565cce5b9548a33008f', 'Express Customs Clearing', '(NGN 700.00 per KG)', '2022-12-15 17:22:17'),
(62, 'afc56412e542bed4e780364b300f8352', 'd8c86a4121fab565cce5b9548a33008f', 'Express Cargo Customs Clearing', '(NGN 700.00 per KG)', '2022-12-15 17:22:29'),
(63, 'c8f4b73869765df2608be2175bd7c839', 'd8c86a4121fab565cce5b9548a33008f', 'Regular Express Delivery', '(NGN 400.00 per KG)', '2022-12-15 17:22:40'),
(64, 'f8b696176e13ba7f0b857c0e900898fb', 'd8c86a4121fab565cce5b9548a33008f', 'Air Cargo ( 14 - 16 days) Custom Clearing', '(NGN 530.00 per KG)', '2022-12-15 17:22:51'),
(65, '14f64b5b209d52b4cd0e09ae41e41bcd', 'd8c86a4121fab565cce5b9548a33008f', 'Air Cargo Customs Clearing', '(NGN 530.00 per KG)', '2022-12-15 17:23:05'),
(66, '768205fec275277d7f50c161bd61197b', 'd8c86a4121fab565cce5b9548a33008f', 'Sea Cargo (50-60 days)', '(NGN 240,000.00 per CBM)', '2022-12-15 17:23:21'),
(67, '8bb7249daa95656cfc7a72b075334299', 'd8c86a4121fab565cce5b9548a33008f', 'AIR CARGO (15-20DAYS). BATTERY AND LIQUID GOODS', '(USD 8.50 per KG)', '2022-12-15 17:23:32'),
(68, '2950ac2c97072be40318c9ac71eb60c6', 'd8c86a4121fab565cce5b9548a33008f', 'Air Cargo (5-7 days)', '(USD 7.80 per KG)', '2022-12-15 17:23:45'),
(69, '171b27995ca9ba8006fc6cb2a23a02eb', '3d5a4e5526d0be0d0fb883d2311904bc', 'Instant Express Delivery', '(NGN 600.00 per KG)', '2022-12-15 17:25:15'),
(70, 'fcdf4bd1ac13122ba91f7f3fdc4e24bc', '3d5a4e5526d0be0d0fb883d2311904bc', 'Normal Delivery Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:25:30'),
(71, '43ad5eda27f75832c2302fbeded87074', '3d5a4e5526d0be0d0fb883d2311904bc', 'Normal Delivery (Heavy goods 20 kg+)', '(NGN 180.00 per KG)', '2022-12-15 17:25:39'),
(72, '416f34d406248500dcc8749f713c945e', '3d5a4e5526d0be0d0fb883d2311904bc', 'Instant Express Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:25:51'),
(73, 'bfdbf458346f220b76a5f32968282ab4', '3d5a4e5526d0be0d0fb883d2311904bc', 'Regular Express Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:26:01'),
(74, '2262e90d207ee0acee1de615f94abd06', '65710361c2a662e7bad544dbc0f884b0', 'Instant Express Delivery', '(NGN 600.00 per KG)', '2022-12-15 17:28:26'),
(75, 'd0e79007ef467371f8c28ba2c43a2662', '65710361c2a662e7bad544dbc0f884b0', 'Normal Delivery Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:28:36'),
(76, '9f4d93e0c37e8848078d37e024b4179d', '65710361c2a662e7bad544dbc0f884b0', 'Normal Delivery (Heavy goods 20 kg+)', '(NGN 180.00 per KG)', '2022-12-15 17:28:48'),
(77, 'b33c5dc358c577e4cdc380ad96f5d586', '65710361c2a662e7bad544dbc0f884b0', 'Instant Express Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:29:00'),
(78, '03865cc327d3cf25d588007f26934be9', '65710361c2a662e7bad544dbc0f884b0', 'Regular Express Distance Component', '(NGN 150.00 per KM)', '2022-12-15 17:29:10');

-- --------------------------------------------------------

--
-- Table structure for table `droutes`
--

CREATE TABLE `droutes` (
  `id` int(11) NOT NULL,
  `rid` varchar(34) DEFAULT NULL,
  `dtype` varchar(20) DEFAULT NULL,
  `droute` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `droutes`
--

INSERT INTO `droutes` (`id`, `rid`, `dtype`, `droute`) VALUES
(1, '4cc3b84b5b9e906646556c0cc0476bee', 'International', 'China - Nigeria'),
(2, '27b47af9f101e4ace01eaa9bf175c198', 'International', 'Dubai - Nigeria'),
(3, 'b5dd2c30b0446a373be7d12c8ac0a18c', 'International', 'UK - Nigeria'),
(4, '0232d379309559fa8a9850b58b5766d6', 'International', 'US - Nigeria'),
(5, '218b1d569eb1e5cba9d8d12b9ea9d970', 'International', 'Turkey - Nigeria'),
(6, '3b7cfe7c8f17b520c7b19895eb27369a', 'Domestic', 'Lagos - Port Harcourt'),
(7, 'd3be64ff42c59b433055c4bd5fc9919e', 'Domestic', 'Lagos - Abuja');

-- --------------------------------------------------------

--
-- Table structure for table `dservices`
--

CREATE TABLE `dservices` (
  `id` int(11) NOT NULL,
  `sid` varchar(34) DEFAULT NULL,
  `dtype` varchar(20) DEFAULT NULL,
  `dservice` varchar(100) DEFAULT NULL,
  `drate` varchar(11) DEFAULT NULL,
  `dimg` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dservices`
--

INSERT INTO `dservices` (`id`, `sid`, `dtype`, `dservice`, `drate`, `dimg`) VALUES
(8, 'b8cd8b0fc90909cc0939e49e684ef2da', 'International', 'Express (1-2 days)', '8.10', 'ff626722d6639dd008b27efeac51e08d.png'),
(9, '0daed682f53b6c4766d4845b427da4a6', 'International', 'Express Cargo(3-4 days)', '8.10', '0ed4f753370a7fb1ba357bb0ac18cb72.png'),
(10, '902abb1ccc1eef116bb3dab6e85453d7', 'International', 'Air Cargo (5-7 days)', '8.10', 'df079bf7063c056e2d3d3177c960ab7f.png'),
(11, 'fbd5e6df327d5841d41ff37f1c1ff0f5', 'International', 'Sea Cargo (50-60 days)', '9.10', '00a6b6a991e390151dfe7e3b33229584.png'),
(12, '92195ef7893c06a3055de49fe36f0517', 'International', 'Air Cargo (15-20 days). Battery &amp; Liquid Goods', '8.10', 'e4afbe6b32bc555b89fa9ccbb3113d7a.png'),
(13, '55c5a6e17ed7cdfaab080f4d837f73a4', 'Domestic', 'Normal Delivery: 24 HOURS DELIVERY', '600', 'a7f1f0e6c2ba39ae59db97b0ea6693e3.png'),
(14, 'a6fda22e43926ead2793ff5f9c84faaa', 'Domestic', 'Regular Express Delivery: 24 HOURS DELIVERY', '850', '0254c620b84eefed1a11c257d666d5b3.png'),
(15, '16617d93998cddfc7881ab9b4e4228a6', 'Domestic', 'Instant Express Delivery: 6 HOURS DELIVERY', '900', 'a5adfd25da0749f76858ff7a9d08fc5f.png'),
(17, 'a9a0a0912a5e6bd5700762c1ba5d315e', 'Domestic', 'Bulk Delivery: 24 HOURS DELIVERY', '700', 'e33bbf0606301266f5f93406b56d83d3.png');

-- --------------------------------------------------------

--
-- Table structure for table `dtracking_list`
--

CREATE TABLE `dtracking_list` (
  `id` int(11) NOT NULL,
  `orderId` varchar(34) DEFAULT NULL,
  `dtitle` varchar(255) DEFAULT NULL,
  `dlocation` varchar(255) DEFAULT NULL,
  `dcomment` text DEFAULT NULL,
  `ddate` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dtracking_list`
--

INSERT INTO `dtracking_list` (`id`, `orderId`, `dtitle`, `dlocation`, `dcomment`, `ddate`) VALUES
(7, 'HGE20230124030704', 'DEPARTED FACILITY IN GUANGZHOU, CHINA', 'Guangzhau Baiyun Internation Airport Guangzhau, China (Cargo Flight Station)', '', '2023-01-27 16:30:27'),
(8, 'HGE20230124023842', 'ARRIVED AT CARGO TERMINAL', 'HugoExpress warehouse, Guangzhou, china', '', '2023-01-27 17:18:49'),
(9, 'HGE20230124030704', 'PACKAGE PROCESSED AND READY FOR SHIPPING', 'Guangzhau Baiyun Internation Airport Guangzhau, China (Cargo Terminal)', '', '2023-02-01 14:46:42'),
(10, 'HGE20230206040914', 'ARRIVED AT CARGO TERMINAL', 'Guangzhau Baiyun Internation Airport Guangzhau, China (Custom facility)', '', '2023-02-10 14:21:48'),
(11, 'HGE20230206040914', 'PACKAGE PROCESSED AND READY FOR SHIPPING', 'HugoExpress warehouse, Guangzhou, china', 'Very good', '2023-02-10 14:28:11'),
(12, 'HGE05315b02087', 'PACKAGE PROCESSED AND READY FOR SHIPPING', 'Guangzhau Baiyun Internation Airport Guangzhau, China', 'Ready for shipping', '2023-02-23 13:26:42');

-- --------------------------------------------------------

--
-- Table structure for table `dtracking_location`
--

CREATE TABLE `dtracking_location` (
  `id` int(11) NOT NULL,
  `tid` varchar(34) DEFAULT NULL,
  `dlocation` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dtracking_location`
--

INSERT INTO `dtracking_location` (`id`, `tid`, `dlocation`) VALUES
(1, 'fb7f58b564cf99dbadc9d406815b13a5', 'Guangzhau Baiyun Internation Airport Guangzhau, China'),
(3, '07b52c536b3621d9030773e95e1396ef', 'HugoExpress warehouse, Guangzhou, china'),
(4, 'e8c80f1e325c5284e88007ecb48aaa16', 'Guangzhau Baiyun Internation Airport Guangzhau, China (Cargo Terminal)'),
(5, '2d17d94bdecb1fa7c69379b678eebbb2', 'Guangzhau Baiyun Internation Airport Guangzhau, China (Custom facility)'),
(6, '68f431ce008a4651ddbb14e36465bf7a', 'Guangzhau Baiyun Internation Airport Guangzhau, China (Cargo Flight Station)'),
(7, '23ded3be454dddd369fe1f08d6516280', 'Addis Ababa Bole International Airport, Ethiopia');

-- --------------------------------------------------------

--
-- Table structure for table `dtrack_info`
--

CREATE TABLE `dtrack_info` (
  `id` int(11) NOT NULL,
  `tid` varchar(34) DEFAULT NULL,
  `dtitle` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dtrack_info`
--

INSERT INTO `dtrack_info` (`id`, `tid`, `dtitle`) VALUES
(1, 'e31e13f790cb604b7579656448f91a4b', 'PACKAGE RECEIVED'),
(2, '3b20d329de4e1af85fd5a507d1e4c1ff', 'PACKAGE PROCESSED AND READY FOR SHIPPING'),
(3, '0488c11d8d299a9d7bcc12de8f00ad21', 'DEPARTED FACILITY IN GUANGZHOU, CHINA'),
(4, 'a513040031e59927eca3ec6cfe6de6ee', 'ARRIVED AT CARGO TERMINAL');

-- --------------------------------------------------------

--
-- Table structure for table `dwaybills`
--

CREATE TABLE `dwaybills` (
  `id` int(11) NOT NULL,
  `wid` varchar(34) DEFAULT NULL,
  `orderId` varchar(34) DEFAULT NULL,
  `dwaybill` varchar(50) DEFAULT NULL,
  `dcourier` varchar(100) DEFAULT NULL,
  `dreceived` varchar(5) DEFAULT 'no',
  `wdate` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `dwaybills`
--

INSERT INTO `dwaybills` (`id`, `wid`, `orderId`, `dwaybill`, `dcourier`, `dreceived`, `wdate`) VALUES
(2, 'a7833aae988e51a460d15beef710f3b0', 'HGE20230124022957', '562136851412', 'James bond', 'no', '2023-01-24 14:29:57'),
(3, '5a2a71e794ade243cc2d242b15d0cc8a', 'HGE20230124022957', '7896856558', 'Isaac Newton', 'no', '2023-01-24 14:29:57'),
(4, '0f6028ff10ab71786f0dba1677cc1c1c', 'HGE20230124022957', '908709070798', 'Favour smith', 'no', '2023-01-24 14:29:57'),
(5, '3ef741b34305d7aaa2f12871e2373576', 'HGE20230124022957', '9876345256', 'Micheal Button', 'no', '2023-01-24 14:29:57'),
(6, '09722bc8fe30240415c60a77f8110f3e', 'HGE20230124023354', '0987656746', 'Card bean', 'no', '2023-01-24 14:33:54'),
(7, '37d69ad6e9561e4c334451c8009c5026', 'HGE20230124023354', '9876543324', 'Joel Kun', 'no', '2023-01-24 14:33:54'),
(8, '7cf3cba8a5955b2eebff957ae7580d51', 'HGE20230124023842', '20987656746', 'Krod Kate', 'yes', '2023-01-27 17:18:08'),
(9, '6736087c24ef54414fe3ea55ed8c6a98', 'HGE20230124023842', '76854324536', 'Carrier', 'yes', '2023-01-27 17:18:06'),
(11, 'c61cee666aa41831049472b044334dcd', 'HGE20230124030704', '362136851412', 'Card beans', 'yes', '2023-02-01 14:57:15'),
(12, '851b5c6998ba06aec24cc3f96f9aa085', 'HGE20230124030704', '09876567463', 'James bonder', 'yes', '2023-02-01 14:57:16'),
(13, '0e44ba417f2d7d56e9fafad663456be7', 'HGE20230124030704', '209876567462', 'Krod Kater', 'yes', '2023-02-01 14:57:17'),
(14, '3ed0668d53dc0b61f994245e6078f4d3', 'HGE20230124023842', '45344254661', 'Blap too', 'yes', '2023-01-25 15:32:33'),
(15, '931bb9eb772019510bb158bc506b3587', 'HGE20230202012135', '908765214', 'Plater', 'no', '2023-02-02 14:51:16'),
(16, 'a9f5391355ef37fe4aa12a79f6ae9e5e', 'HGE0987654678999', '234567890', 'Base', 'yes', '2023-02-27 11:42:21'),
(17, 'c66e94f0c18b75902dc6dd448d8eda59', 'HGE0987654678999', '0987654567', 'Ball', 'yes', '2023-02-27 11:42:39'),
(18, 'c15b6920efaf3185aaed2484e3bf3242', 'HGE0987654678999', '65432456789', 'Card', 'yes', '2023-02-27 11:42:40'),
(19, 'e417d13c16411a16a7f85d51eac768b3', 'HGE0987654678999', '00000098765432', 'Last on the list', 'yes', '2023-02-27 11:42:41'),
(21, '4c03bba6e53819803444e71bfaaeaec2', 'HGE05315b02087', '362136851412', 'Testing', 'yes', '2023-02-23 13:25:04'),
(22, '4ada5ee7c5de2170f282ffd1aeeacdf2', 'HGE20230223123031', '12345678', 'Testing ', 'no', NULL),
(23, '9b1ca058b3dc4013cdc89dcdf8ca9a88', 'HGE20230223123031', '4567897654', 'Test', 'no', NULL),
(24, '0df0601eabf45a8f659ab3b69e1160f7', 'HGE20230223054137', 'we678976322', '344658756756', 'no', NULL),
(25, '9cd56aff38f1e1bec3eb73853e560b7b', 'HGE20230223054137', 'wret3t3463463', 'fsfsdfsdfsdfsd', 'no', NULL),
(26, 'dbb21c30b1af30207aaacfa90ab82546', 'HGE20230228125523', '562136851412', 'Card beans', 'no', NULL),
(27, '35d723c562c0dd71cb6dfc7567c41a8a', 'HGE20230228125523', '987654333', 'fasfafagsdgsdg', 'no', NULL),
(28, 'e48914dafd8e6a3a611029147d26789e', 'HGE20230228125523', '562136851412', 'Card beans', 'no', NULL),
(29, 'dd0efddfc2a01dec4eaa35447f8e7e54', 'HGE20230228125523', '987654333', 'fasfafagsdgsdg', 'no', NULL),
(30, '831bcb978f9202c09e615fb23c684d81', 'HGE20230228125711', '562136851412', 'Card beans', 'no', NULL),
(31, '63d5a14b7f8cdb1f84dd1f9363c41c63', 'HGE20230228125711', '562136851412', 'Card beans', 'no', NULL),
(32, '320e26898a4ad4a6faa0a623cb009b9f', 'HGE20230228125935', '562136851412', 'Card beans', 'no', NULL),
(33, '110ada963b9755f3eb156eb8af1df546', 'HGE20230228010649', '562136851412', 'asdasdasdasd', 'no', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `myaddress`
--

CREATE TABLE `myaddress` (
  `id` int(11) NOT NULL,
  `aid` varchar(34) DEFAULT NULL,
  `userid` varchar(34) DEFAULT NULL,
  `dname` varchar(255) DEFAULT NULL,
  `dlocation` text DEFAULT NULL,
  `daddress` text DEFAULT NULL,
  `dzip` varchar(20) DEFAULT NULL,
  `dcity` varchar(50) DEFAULT NULL,
  `dstate` varchar(50) DEFAULT NULL,
  `dphone` varchar(20) DEFAULT NULL,
  `daltPhone` varchar(20) DEFAULT NULL,
  `dcomment` text DEFAULT NULL,
  `dlat` varchar(20) DEFAULT NULL,
  `dlog` varchar(20) DEFAULT NULL,
  `ddate` varchar(24) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `myaddress`
--

INSERT INTO `myaddress` (`id`, `aid`, `userid`, `dname`, `dlocation`, `daddress`, `dzip`, `dcity`, `dstate`, `dphone`, `daltPhone`, `dcomment`, `dlat`, `dlog`, `ddate`) VALUES
(2, 'de4ece1acd0d6d0200d14d7a5e0092b0', 'c4764b3ed69827456689cf7b62865400', 'Emmanuel Plaza', 'Emmanuel Plaza, Chief G U Ake Road, Port Harcourt, Nigeria', 'plot 16 Emmanuel Plaza, Chief G U Ake Road', '500102', 'Obio/Akpor', 'Rivers', '09098523804', '', '', '4.8676034', '7.0175513', '2022-12-20 14:54:01'),
(3, 'f838bf9c6d4e7323bd3aaf9027371374', 'c4764b3ed69827456689cf7b62865400', 'Takete2', 'Takete-Isao, Nigeria', 'No1 Ogbankeja compound', '262102', 'Yagba East', 'Kogi', '09098523804', '090890', 'Love this address', '8.1797721', '5.702971299999999', '2022-12-20 16:35:32'),
(4, '1250074bcbd7ebe16e685930af1d40c5', 'c4764b3ed69827456689cf7b62865400', 'Takete', 'Takete-Isao, Nigeria', 'No1 Ogbankeja compound', '262102', 'Yagba East', 'Kogi', '09098523804', '090', 'Love this address', '8.1797721', '5.702971299999999', '2022-12-20 16:29:47'),
(5, '21194fd176d7bd32ad9e17d6694460c3', '46e729f542086631c50d40577572b701', 'Emmanuel Plaza', 'Emmanuel Plaza, Chief G U Ake Road, Port Harcourt, Nigeria', 'Plot 15 &amp; 16', '500102', 'Obio/Akpor', 'Rivers', '0809876543', '09087654376', 'Opposite RCCG Jesus Court', '4.8676034', '7.0175513', '2023-02-22 13:21:56');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `demail` (`demail`);

--
-- Indexes for table `daddress`
--
ALTER TABLE `daddress`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `daddtional_charges`
--
ALTER TABLE `daddtional_charges`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ddomestic_order`
--
ALTER TABLE `ddomestic_order`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dinternational_order`
--
ALTER TABLE `dinternational_order`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dinvoice`
--
ALTER TABLE `dinvoice`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dlogin`
--
ALTER TABLE `dlogin`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `demail` (`demail`);

--
-- Indexes for table `dorders`
--
ALTER TABLE `dorders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dprice`
--
ALTER TABLE `dprice`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `droutes`
--
ALTER TABLE `droutes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dservices`
--
ALTER TABLE `dservices`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dtracking_list`
--
ALTER TABLE `dtracking_list`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dtracking_location`
--
ALTER TABLE `dtracking_location`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dtrack_info`
--
ALTER TABLE `dtrack_info`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dwaybills`
--
ALTER TABLE `dwaybills`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `myaddress`
--
ALTER TABLE `myaddress`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `daddress`
--
ALTER TABLE `daddress`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `daddtional_charges`
--
ALTER TABLE `daddtional_charges`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `ddomestic_order`
--
ALTER TABLE `ddomestic_order`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `dinternational_order`
--
ALTER TABLE `dinternational_order`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `dinvoice`
--
ALTER TABLE `dinvoice`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `dlogin`
--
ALTER TABLE `dlogin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `dorders`
--
ALTER TABLE `dorders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dprice`
--
ALTER TABLE `dprice`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80;

--
-- AUTO_INCREMENT for table `droutes`
--
ALTER TABLE `droutes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `dservices`
--
ALTER TABLE `dservices`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `dtracking_list`
--
ALTER TABLE `dtracking_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `dtracking_location`
--
ALTER TABLE `dtracking_location`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `dtrack_info`
--
ALTER TABLE `dtrack_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `dwaybills`
--
ALTER TABLE `dwaybills`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `myaddress`
--
ALTER TABLE `myaddress`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

