-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 15, 2021 at 02:51 AM
-- Server version: 10.3.28-MariaDB-log-cll-lve
-- PHP Version: 7.3.27

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `fxtejobr_glo`
--

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

--
-- Table structure for table `deposits`
--

CREATE TABLE `deposits` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `wallet` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `transaction_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amount` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rate` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `charge` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `net_amount` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `payment_type` tinyint(4) NOT NULL,
  `message` blob DEFAULT NULL,
  `status` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `active` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `deposits`
--

INSERT INTO `deposits` (`id`, `user_id`, `name`, `wallet`, `transaction_id`, `amount`, `rate`, `charge`, `net_amount`, `payment_type`, `message`, `status`, `created_at`, `updated_at`, `active`) VALUES
(271, 286, 'John J. Foo Yuan', '', '', '350', NULL, '', '', 0, NULL, 0, '2020-03-13 01:50:59', NULL, 0),
(334, 0, '', '', '', '147', NULL, '', '', 0, NULL, 0, '2020-03-15 00:09:09', NULL, 0),
(335, 0, '', '', '', '600', NULL, '', '', 0, NULL, 0, '2020-03-15 00:19:20', NULL, 0),
(336, 0, '', '', '', '10500', NULL, '', '', 0, NULL, 0, '2020-03-15 00:24:15', NULL, 0),
(337, 0, '', '', '', '101', NULL, '', '', 0, NULL, 0, '2020-03-15 00:45:09', NULL, 0),
(338, 0, '', '', '', '452', NULL, '', '', 0, NULL, 0, '2020-03-15 16:04:17', NULL, 0),
(339, 0, '', '', '', '16666', NULL, '', '', 0, NULL, 0, '2020-03-15 16:12:31', NULL, 0),
(340, 0, '', '', '', '16666', NULL, '', '', 0, NULL, 0, '2020-03-15 16:20:43', NULL, 0),
(341, 0, '', '', '', '560', NULL, '', '', 0, NULL, 0, '2020-03-15 16:56:15', NULL, 0),
(342, 0, '', '', '', '560', NULL, '', '', 0, NULL, 0, '2020-03-15 16:58:47', NULL, 0),
(343, 0, '', '', '', '560', NULL, '', '', 0, NULL, 0, '2020-03-15 17:00:35', NULL, 0),
(344, 0, '', '', '', '560', NULL, '', '', 0, NULL, 0, '2020-03-15 17:03:39', NULL, 0),
(345, 0, '', '', '', '560', NULL, '', '', 0, NULL, 0, '2020-03-15 17:05:39', NULL, 0),
(346, 0, '', '', '', '560', NULL, '', '', 0, NULL, 0, '2020-03-15 17:23:17', NULL, 0),
(347, 0, '', '', '', '560', NULL, '', '', 0, NULL, 0, '2020-03-15 17:47:24', NULL, 0),
(348, 0, '', '', '', '7000', NULL, '', '', 0, NULL, 0, '2020-03-15 17:56:25', NULL, 0),
(349, 0, '', '', '', '852', NULL, '', '', 0, NULL, 0, '2020-03-15 18:19:36', NULL, 0),
(350, 0, '', '', '', '400', NULL, '', '', 0, NULL, 0, '2020-03-15 18:46:31', NULL, 0),
(351, 0, '', '', '', '258', NULL, '', '', 0, NULL, 0, '2020-03-15 19:09:04', NULL, 0),
(352, 0, '', '', '', '698', NULL, '', '', 0, NULL, 0, '2020-03-15 19:12:37', NULL, 0),
(353, 0, '', '', '', '2000', NULL, '', '', 0, NULL, 0, '2020-03-15 20:16:19', NULL, 0),
(354, 0, '', '', '', '100', NULL, '', '', 0, NULL, 0, '2020-03-15 20:17:44', NULL, 0),
(355, 0, '', '', '', '100', NULL, '', '', 0, NULL, 0, '2020-03-15 20:18:20', NULL, 0),
(356, 0, '', '', '', '200', NULL, '', '', 0, NULL, 0, '2020-03-18 07:06:56', NULL, 0),
(357, 0, '', '', '', '1000', NULL, '', '', 0, NULL, 0, '2020-03-18 18:24:24', NULL, 0),
(358, 0, '', '', '', '1000', NULL, '', '', 0, NULL, 0, '2020-03-18 18:25:05', NULL, 0),
(359, 0, '', '', '', '1000', NULL, '', '', 0, NULL, 0, '2020-03-18 18:27:07', NULL, 0),
(360, 0, '', '', '', '1000', NULL, '', '', 0, NULL, 0, '2020-03-18 18:45:53', NULL, 0),
(361, 0, '', '', '', '100', NULL, '', '', 0, NULL, 0, '2020-03-19 08:32:08', NULL, 0),
(362, 0, '', '', '', '100', NULL, '', '', 0, NULL, 0, '2020-03-19 08:33:24', NULL, 0);

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

--
-- Table structure for table `move`
--

CREATE TABLE `move` (
  `id` int(10) UNSIGNED NOT NULL,
  `userid` int(11) NOT NULL,
  `date` varchar(100) NOT NULL,
  `day` varchar(100) NOT NULL,
  `time` varchar(100) NOT NULL,
  `trackingno` varchar(225) NOT NULL,
  `status` varchar(225) NOT NULL,
  `clocation` varchar(225) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `move`
--

INSERT INTO `move` (`id`, `userid`, `date`, `day`, `time`, `trackingno`, `status`, `clocation`) VALUES
(1, 1, '', '', '', '', '', '0'),
(2, 1, '', '', '', '', '', ''),
(3, 2, '', '', '', '', '', ''),
(4, 2, '', '', '', '', '', ''),
(5, 2, '', '', '', '', 'on transit', 'Clinton Maryland'),
(6, 2, '', '', '', '', 'on transit', 'Clinton Maryland'),
(7, 1, '', '', '', '', 'ON TRANSIT', 'ANTALYA INTL AIRPORT TURKEY'),
(8, 1, '', '', '', '', 'ON TRANSIT', 'ANTALYA INTL AIRPORT TURKEY'),
(9, 1, '', '', '', 'EQB1265E', 'ON TRANSIT', 'ANTALYA INTL AIRPORT TURKEY'),
(10, 1, '', '', '', 'EQB1265E', 'STOPPED BY CUSTOMS', 'NON INSPECTION'),
(11, 1, '', '', '', 'EQB1265E', 'STOPPED BY CUSTOMS', 'NON INSPECTION'),
(12, 1, '', '', '', 'EQB1265E', 'STOPPED BY CUSTOMS', 'NON INSPECTION'),
(13, 1, '', '', '', 'EQB1265E', 'STOPPED BY CUSTOMS', 'NON INSPECTION'),
(14, 1, '', '', '', 'EQB1265E', 'ON TRANSIT', 'ANTALYA INTL AIRPORT TURKEY'),
(15, 1, '', '', '', 'EQB1265E', 'ON TRANSIT MOVING', 'ANTALYA INTL AIRPORT TURKEY'),
(16, 5, '', '', '', 'KEA3457J', 'ACTIVE ', 'NON'),
(17, 5, '', '', '', 'KEA3457J', 'ACTIVE ', 'ON AIR '),
(18, 6, '', '', '', 'FHP3993C', ' ACTIVE ', 'ON AIR '),
(19, 6, '', '', '', 'FHP3993C', 'ON TRANSIT ', 'PHNOM PENH  INTER AIRPORT CAMBODIA '),
(20, 5, '', '', '', 'KEA3457J', 'ON TRANSIT ', 'PHNOM PENH  INTER AIRPORT CAMBODIA '),
(21, 5, '', '', '', 'KEA3457J', 'ACTIVE ', 'ON AIR '),
(22, 6, '', '', '', 'FHP3993C', 'ACTIVE ', 'ON AIR '),
(23, 5, '', '', '', 'KEA3457J', 'ON TRANSIT ', 'Ministro Pistarini International Ai'),
(24, 7, '', '', '', 'EAM3625P', 'ACTIVE ', 'Afghanistan '),
(25, 7, '', '', '', 'EAM3625P', 'ON AIR ', 'NONE'),
(26, 6, '', '', '', 'FHP3993C', 'ON TRANSIT ', 'Ministro Pistarini International Ai'),
(27, 5, '', '', '', 'KEA3457J', 'ON TRANSIT ', 'Mexico City International Airport'),
(28, 5, '', '', '', 'KEA3457J', 'ACTIVE ', 'ON AIR '),
(29, 6, '', '', '', 'FHP3993C', 'ACTIVE ', 'ON AIR '),
(30, 7, '', '', '', 'EAM3625P', 'ON TRANSIT ', 'PHNOM PENH  INTER AIRPORT CAMBODIA '),
(31, 7, '', '', '', 'EAM3625P', 'ACTIVE ', 'ON AIR '),
(32, 7, '', '', '', 'EAM3625P', 'ON TRANSIT ', 'Mexico City International Airport'),
(33, 7, '', '', '', 'EAM3625P', 'ACTIVE ', 'ON AIR '),
(34, 8, '', '', '', 'NJQ7119E', 'ACTIVE ', 'NON'),
(35, 8, '', '', '', 'NJQ7119E', 'ON TRANSIT ', 'PHNOM PENH  INTER AIRPORT CAMBODIA '),
(36, 8, '', '', '', 'NJQ7119E', 'ACTIVE ', 'ON AIR '),
(37, 8, '', '', '', 'NJQ7119E', 'ON TRANSIT ', 'Mexico City International Airport'),
(38, 8, '', '', '', 'NJQ7119E', 'ACTIVE ', 'ON AIR '),
(39, 9, '', '', '', 'MJP6174K', 'ON AIR ', 'Afghanistan '),
(40, 9, '', '', '', 'MJP6174K', 'ON TRANSIT ', 'Mexico City International Airport'),
(41, 9, '', '', '', 'MJP6174K', 'ACTIVE ', 'ON AIR '),
(42, 9, '', '', '', 'MJP6174K', 'ON TRANSIT ', 'PHNOM PENH  INTER AIRPORT CAMBODIA '),
(43, 9, '', '', '', 'MJP6174K', 'ACTIVE ', 'ON AIR '),
(44, 9, '', '', '', 'MJP6174K', 'ON TRANSIT ', 'Dubai International Airport'),
(45, 10, '', '', '', 'JAN9829C', 'ACTIVE ', 'CAMBODIA '),
(46, 9, '', '', '', 'MJP6174K', 'ACTIVE ', 'ON AIR '),
(47, 9, '', '', '', 'MJP6174K', 'ON  HOLD ', 'O.R. TAMBO INTERNATIONAL AIRPORT. '),
(48, 9, '', '', '', 'MJP6174K', ' ACTIVE ', 'ON AIR '),
(49, 13, '', '', '', 'JJQ1472H', 'ACTIVE ', 'ON AIR '),
(50, 13, '', '', '', 'JJQ1472H', 'ACTIVE ', 'Afghanistan '),
(51, 14, '', '', '', 'CJA3926P', 'ACTIVE ', 'IRAQ'),
(52, 14, '', '', '', 'CJA3926P', 'ACTIVE ', 'ON AIR '),
(53, 14, '', '', '', 'CJA3926P', 'ON TRANSIT ', 'WATTAY,INTERNATIONAL AIRPORT LAOS.'),
(54, 14, '', '', '', 'CJA3926P', 'ACTIVE ', 'ON AIR '),
(55, 15, 'Saturday, August 29  , 2020', '', '', 'BQA5727G', 'ON TRANSIT', 'ANTALYA INTL AIRPORT TURKEY'),
(56, 15, 'Sunday, August 30  , 2020', '', '', 'BQA5727G', 'ON TRANSIT MOVING', 'lagos'),
(57, 15, 'Sunday 30th of August 2020 07:36:44 AM', '', '', 'BQA5727G', 'STOPPED BY CUSTOMS', 'Owerri'),
(58, 16, 'Sunday 30th of August 2020 09:39:08 AM', '', '', 'NKE5799G', 'ON transist', 'Mexico'),
(59, 18, 'Sunday 30th of August 2020 09:41:57 AM', '', '', 'MPN8596C', 'Transist', 'Mexico airport'),
(60, 15, 'Sunday 30th of August 2020 09:51:58 AM', '', '', 'BQA5727G', 'ON TRANSIT', 'Owerri'),
(61, 15, 'Sunday 30th of August 2020 09:55:08 AM', '', '', 'BQA5727G', '', 'Arizona '),
(62, 18, 'Sunday 30th of August 2020 10:19:48 AM', '', '', 'MPN8596C', 'Transist', 'Arizona '),
(63, 15, 'Sunday 30th of August 2020 10:24:31 AM', '', '', 'BQA5727G', 'Hold', 'Panama '),
(64, 15, 'Monday 31st of August 2020 03:07:46 AM', '', '', 'BQA5727G', 'ON transist', 'Arizona '),
(65, 15, 'Monday 31st of August 2020 03:11:09 AM', '', '', 'BQA5727G', 'ON TRANSIT MOVING', 'Owerri'),
(66, 18, 'Monday 31st of August 2020 01:35:54 PM', '', '', 'MPN8596C', '', 'Arizona '),
(67, 18, 'Monday 31st of August 2020 01:36:43 PM', '', '', 'MPN8596C', '', ''),
(68, 18, 'Monday 31st of August 2020 01:37:33 PM', '', '', 'MPN8596C', '', ''),
(69, 15, 'Monday 31st of August 2020 01:38:47 PM', '', '', 'BQA5727G', 'STOPPED BY CUSTOMS', 'Lagos'),
(70, 15, 'Monday 31st of August 2020 01:40:36 PM', '', '', 'BQA5727G', '', ''),
(71, 15, 'Monday 31st of August 2020 01:56:20 PM', '', '', 'BQA5727G', '', ''),
(72, 19, '1st of September 2020', 'Tuesday', '04:56:36 PM', 'GBM2718P', 'On transit', 'Bennin'),
(73, 20, '1st of September 2020', 'Tuesday', '05:28:55 PM', 'CMG7264H', '', ''),
(74, 21, '1st of September 2020', 'Tuesday', '05:44:41 PM', 'QAF2322H', 'ON transist', 'Syria airport'),
(75, 0, '1st of September 2020', 'Tuesday', '06:28:39 PM', '', '', ''),
(76, 23, '1st of September 2020', 'Tuesday', '06:31:14 PM', 'QBF4865G', 'Accepted/Registered', 'Bennin'),
(77, 23, '2nd of September 2020', 'Wednesday', '01:16:57 AM', 'QBF4865G', 'On transit', 'Abuja'),
(78, 24, '2nd of September 2020', 'Wednesday', '01:29:15 AM', 'HHP4257B', 'On transit', 'Departed from express global delive'),
(79, 24, '2nd of September 2020', 'Wednesday', '01:32:43 AM', 'HHP4257B', '', ''),
(80, 24, '2nd of September 2020', 'Wednesday', '01:34:03 AM', 'HHP4257B', '', 'Mexico'),
(81, 24, '2nd of September 2020', 'Wednesday', '01:35:46 AM', 'HHP4257B', 'Hold', 'Mexico airport'),
(82, 25, '2nd of September 2020', 'Wednesday', '01:42:25 AM', 'QJK1277N', 'On transit', 'Syria airport'),
(83, 24, '2nd of September 2020', 'Wednesday', '06:35:04 AM', 'HHP4257B', 'Arrival details', 'doorstep'),
(84, 27, '15th of September 2020', 'Tuesday', '06:47:00 AM', 'FEA1844E', 'On transit', 'Yemen Airport'),
(85, 30, '15th of September 2020', 'Tuesday', '07:40:06 AM', 'KBM8563M', 'On transit', 'Syria airport'),
(86, 26, '16th of September 2020', 'Wednesday', '10:45:09 AM', 'CMM6126K', 'Accepted/Registered', 'Bennin'),
(87, 27, '16th of September 2020', 'Wednesday', '10:50:27 AM', 'FEA1844E', 'On transit', 'Yemen Airport'),
(88, 27, '16th of September 2020', 'Wednesday', '11:03:00 AM', 'FEA1844E', 'On transit', 'Mexico airport'),
(89, 30, '16th of September 2020', 'Wednesday', '01:01:26 PM', 'KBM8563M', 'On transit', 'Syria airport'),
(90, 30, '16th of September 2020', 'Wednesday', '07:26:51 PM', 'KBM8563M', 'On transit', 'Mexico airport'),
(91, 27, '17th of September 2020', 'Thursday', '05:55:36 AM', 'FEA1844E', 'On transit', 'Mexico airport'),
(92, 27, '17th of September 2020', 'Thursday', '05:57:40 AM', 'FEA1844E', 'Hold', 'Mexico airport'),
(93, 28, '17th of September 2020', 'Thursday', '06:07:20 AM', 'HKA2966J', '', ''),
(94, 28, '17th of September 2020', 'Thursday', '06:08:14 AM', 'HKA2966J', 'On hold ', 'Mexico airport'),
(95, 31, '10th of November 2020', 'Tuesday', '11:46:20 PM', 'ACC3918B', 'Transist', 'Syria airport'),
(96, 31, '11th of November 2020', 'Wednesday', '01:58:28 PM', 'ACC3918B', 'On transit', 'Syria airport'),
(97, 31, '11th of November 2020', 'Wednesday', '02:38:15 PM', 'ACC3918B', 'On transit', 'Mexico'),
(98, 31, '11th of November 2020', 'Wednesday', '02:48:12 PM', 'ACC3918B', 'On transit', 'Mexico'),
(99, 32, '11th of November 2020', 'Wednesday', '02:56:32 PM', 'AKH9883J', 'accepted /registered', 'NON INSPECTION'),
(100, 32, '11th of November 2020', 'Wednesday', '03:25:44 PM', 'AKH9883J', 'accepted /registered', 'NON INSPECTION'),
(101, 32, '11th of November 2020', 'Wednesday', '03:26:52 PM', 'AKH9883J', 'On hold', 'Mexico airport'),
(102, 31, '12th of November 2020', 'Thursday', '04:28:13 AM', 'ACC3918B', 'On hold', 'Mexico airport'),
(103, 33, '26th of November 2020', 'Thursday', '10:06:19 AM', 'MEN3755B', 'On Transit', 'Syria Airport'),
(104, 34, '26th of November 2020', 'Thursday', '10:15:16 AM', 'ECC1281C', 'On Transit', 'Syria Airport'),
(105, 33, '27th of November 2020', 'Friday', '05:03:43 AM', 'MEN3755B', 'On Transit', 'Syria Airport'),
(106, 34, '27th of November 2020', 'Friday', '05:11:02 AM', 'ECC1281C', 'On Transit', 'Syria Airport'),
(107, 34, '27th of November 2020', 'Friday', '05:12:45 AM', 'ECC1281C', 'On hold', 'Birmingham Airport'),
(108, 33, '27th of November 2020', 'Friday', '05:13:57 AM', 'MEN3755B', 'On hold', 'Spain Airport'),
(109, 35, '24th of December 2020', 'Thursday', '01:03:27 AM', 'EKJ1484K', 'On Transit', 'Syria Airport'),
(110, 35, '24th of December 2020', 'Thursday', '04:54:26 PM', 'EKJ1484K', 'On Transit', 'Syria Airport'),
(111, 35, '24th of December 2020', 'Thursday', '04:55:27 PM', 'EKJ1484K', 'On Transit', 'Mexico airport'),
(112, 35, '28th of December 2020', 'Monday', '10:16:33 AM', 'EKJ1484K', 'On Transit', 'Mexico airport'),
(113, 35, '28th of December 2020', 'Monday', '10:19:56 AM', 'EKJ1484K', 'On hold', 'Mexico airport'),
(121, 37, '12th of April 2021', 'Monday', '04:01:23 PM', 'AHM9958E', 'Shipped', 'Los Angeles, CA'),
(122, 37, '13th of April 2021', 'Tuesday', '10:38:41 AM', 'AHM9958E', 'STOPPED BY CUSTOMS', 'Los Angeles International Airport ('),
(123, 37, '14th of April 2021', 'Wednesday', '12:11:29 PM', 'AHM9958E', 'STOPPED BY CUSTOMS, DEMANDING FOR ANTI-MONEY LAUNDERING COVER WORTH A CHARGE OF 1500$', 'Los Angeles International Airport ('),
(124, 37, '14th of April 2021', 'Wednesday', '04:27:20 PM', 'AHM9958E', 'CUSTOMS RESTRICTION, CLEARED!', 'Los Angeles International Airport ('),
(125, 37, '14th of April 2021', 'Wednesday', '05:41:36 PM', 'AHM9958E', 'Air freight to Albuquerque International Sunport  Airport. ', 'Transit'),
(126, 37, '14th of April 2021', 'Wednesday', '06:02:14 PM', 'AHM9958E', 'ARRIVAL AT THE ALBUQUERQUE INTERNATIONAL SUNPORT AIRPORT', 'Albuquerque International Sunport  '),
(127, 37, '15th of April 2021', 'Thursday', '05:02:02 PM', 'AHM9958E', 'PENDING. ALBUQUERQUE INTERNATIONAL SUNPORT AIRPORT OFFICIALS ASKING FOR INTERNATIONAL CLEARANCE CERT', 'Albuquerque International Sunport  '),
(128, 37, '15th of April 2021', 'Thursday', '05:13:42 PM', 'AHM9958E', 'WAITING FOR YOUR SSN, AND 800$ TAX COMPLETION DELIVERY FEE.  ', 'Four Corners Regional Airport, Farm'),
(129, 37, '15th of April 2021', 'Thursday', '05:17:47 PM', 'AHM9958E', 'Arrival at Four Corners Regional Airport. ', 'Four Corners Regional Airport, Farm'),
(130, 37, '16th of April 2021', 'Friday', '06:00:34 PM', 'AHM9958E', 'WAITING FOR YOUR SSN, AND 800$ TAX COMPLETION DELIVERY FEE.  ', 'Four Corners Regional Airport, Farm'),
(131, 37, '19th of April 2021', 'Monday', '01:24:17 PM', 'AHM9958E', 'Payment was not complete due the incomplete amount of remittance from the Apple company.', 'Four Corners Regional Airport, Farm'),
(132, 37, '19th of April 2021', 'Monday', '01:27:48 PM', 'AHM9958E', 'READY FOR PICKUP', 'Express Way Fly LTD OFFICE'),
(133, 37, '21st of April 2021', 'Wednesday', '04:16:16 PM', 'AHM9958E', 'READY FOR PICKUP. PLEASE CHECK YOUR MAILBOX OR IN THE INFORMATION BELOW FOR PICKUP. ', 'Express Way Fly LTD OFFICE'),
(134, 42, '28th of April 2021', 'Wednesday', '11:24:53 PM', 'MNF5294B', 'Shipped', 'Afghanistan'),
(136, 42, '28th of April 2021', 'Wednesday', '11:30:53 PM', 'MNF5294B', 'CUSTOMS HOLD', 'Hamid Karzai International Airport'),
(137, 37, '6th of May 2021', 'Thursday', '02:51:05 PM', 'AHM9958E', 'READY FOR PICKUP. PLEASE CHECK YOUR MAILBOX OR IN THE INFORMATION BELOW FOR PICKUP. ', 'Truth or Consequences Municipal Air');

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `sno` int(200) NOT NULL,
  `name` int(200) NOT NULL,
  `consigno` int(200) NOT NULL,
  `email` int(200) NOT NULL,
  `amount` int(200) NOT NULL,
  `comments` int(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`sno`, `name`, `consigno`, `email`, `amount`, `comments`) VALUES
(0, 0, 343344, 0, 100, 0),
(0, 0, 0, 0, 0, 0),
(0, 0, 0, 0, 0, 0),
(0, 0, 0, 0, 0, 0),
(0, 0, 0, 0, 0, 0),
(0, 0, 0, 0, 0, 0),
(0, 0, 0, 0, 0, 0),
(0, 0, 0, 0, 0, 0),
(0, 0, 0, 0, 0, 0),
(0, 0, 0, 0, 10500, 0),
(0, 0, 2093834, 0, 753, 0);

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

--
-- Table structure for table `request`
--

CREATE TABLE `request` (
  `sno` int(10) UNSIGNED NOT NULL,
  `contact_fname` varchar(100) NOT NULL,
  `contact_lname` varchar(1000) NOT NULL,
  `contact_email` varchar(100) NOT NULL,
  `contact_telephone` varchar(100) NOT NULL,
  `contact_comments` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `request`
--

INSERT INTO `request` (`sno`, `contact_fname`, `contact_lname`, `contact_email`, `contact_telephone`, `contact_comments`) VALUES
(123, 'John J.', 'Foo Yuan', 'john@boc-ph.online', '0165603081', 'Parcel'),
(124, 'Michael Kevin', 'Swain', 'lucky@sonofgraceoffice.website', '0944964764', 'Box'),
(127, 'Mackroy', 'Joe Cross', 'customer6387@boc-ph.online', '4809394222', 'jjjjjjjjj'),
(135, 'Faizaliev Muhriddin', 'Ashuralievich', 'customer6388@boc-ph.online', '901067070', 'llllllll'),
(136, 'diricoded', 'aku', 'diricoded@gmail.com', '556667', ',.'),
(139, 'Faizaliev Muhriddin', 'Ashuralievich', 'customer6388@boc-ph.online', '901067070', 'llllllll'),
(140, 'John J.', 'Foo Yuan', 'john@boc-ph.online', '0165603081', 'bgrfdew'),
(141, 'Michael Kevin', 'Swain', 'lucky@sonofgraceoffice.website', '0944964764', 'loiuyt'),
(142, 'Bill', 'Wallace', 'billrusselwallace@gmail.com', '+852 8067006798', 'juy');

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

--
-- Table structure for table `tracking`
--

CREATE TABLE `tracking` (
  `id` int(10) UNSIGNED NOT NULL,
  `trackingno` varchar(30) NOT NULL,
  `consigno` varchar(15) NOT NULL,
  `sender` varchar(30) NOT NULL,
  `saddress` varchar(1000) NOT NULL,
  `semail` varchar(100) NOT NULL,
  `remail` varchar(100) NOT NULL,
  `receiver` varchar(35) NOT NULL,
  `recphone` varchar(20) NOT NULL,
  `senderphone` varchar(100) NOT NULL,
  `address` varchar(50) NOT NULL,
  `packagetype` varchar(15) NOT NULL,
  `cost` varchar(15) NOT NULL,
  `transtype` varchar(15) NOT NULL,
  `dispdate` varchar(30) NOT NULL,
  `pickdate` varchar(30) NOT NULL,
  `status` varchar(100) NOT NULL,
  `clocation` varchar(35) NOT NULL,
  `weight` varchar(225) NOT NULL,
  `active` int(11) NOT NULL DEFAULT 1,
  `move` int(11) NOT NULL DEFAULT 5,
  `msg` varchar(1000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tracking`
--

INSERT INTO `tracking` (`id`, `trackingno`, `consigno`, `sender`, `saddress`, `semail`, `remail`, `receiver`, `recphone`, `senderphone`, `address`, `packagetype`, `cost`, `transtype`, `dispdate`, `pickdate`, `status`, `clocation`, `weight`, `active`, `move`, `msg`) VALUES
(35, 'EKJ1484K', '68906', 'Greg Emiliano Iglesias', 'Syria', '', 'Kristimyerstilford1983@gmail.com', 'Kristi Myers', '+1 541 420 97754', '', '440 me Madras hwy #25 \r\nPrineville Oregon', 'Consignment', '$3,200', 'Air', '24/12/2020', '17/02/2020', 'STOPPED BY CUSTOMS', 'Owerri', '19.0kg', 1, 45, 'move'),
(37, 'AHM9958E', '68906', 'Fredrick Hermann', 'Los Angeles, CA', 'officialme887@gmail.com', 'gloriacarpenter01@gmail.com', 'Gloria Carpenter', '+15054277275', '+12133144462', '111 Fahrion Street Bloomfield, NM  87413', 'Consignment', '500$', 'Air', '12/04/2021', '07/05/2021', 'READY FOR PICKUP', 'Fruitland Kirtland, NM', '9kg', 1, 100, 'PLEASE YOUR ITEM IS READY FOR PICKUP. PLEASE SEND THE REQUESTED 150$ FOR PICKUP. WE WILL ARRIVE IN 17 MIN AFTER PAYMENT AND CLEARING OF SOME PACKAGES HERE IN OUR OFFICE. THANKS'),
(42, 'MNF5294B', '68906', 'Rice Christine', 'Southwest of Kandahar Camp Rhino, 75th Ranger Regiment', 'christinerice209@gmail.com', 'richpsych.ater@gmail.com', 'Richard Ater', '+1206 335 2892', '+1917 985 8079', '12345 lake city way NE #17 Seattle WA 98125', 'Consignment', '3.5 Million$', 'Air', '30/04/2021', '02/05/2021', 'CUSTOMS HOLD', 'Hamid Karzai International Airport', '90,000kg', 1, 10, 'CUSTOMS DEMANDED FOR ANTI-MONEY LAUNDERING COVERINGS WORTH A FEE OF 850$. PLEASE CONTACT US AS SOON AS POSSIBLE TO CONTINUE WITH THIS DELIVERY. THANKS!'),
(44, 'HPB2633H', '68906', 'Fredrick Hermann', 'Los Angeles, California', 'officialme887@gmail.com', 'gironangie97@gmail.com', 'Angie Giron', '+1575-805-5814', '+1213-314-4462', '3200 Del Rey Blvd space 12 Las cruces New Mexico 8', 'Consignment', '480,000$', 'Air', '08/05/2021', '14/05/2021', 'Shipped', 'Heathrow Airport', '17kg', 1, 5, 'sent'),
(45, 'PFK2199J', '68906', 'Richard williams Wu', 'Arizona', 'mailto:Onlinebase03@gmail.com', 'mailto:annakaprabon@gmail.com', 'Srijana Lusteaux ', '+14157605037', '+15802324622', 'Apt 304\r\n237 Avenue De La Division Leclerc \r\n92290', 'Consignment', '2millon$', 'Air', '24/05/2021', '27/05/2021', 'Shipped', 'Syria', '90,000kg', 1, 5, 'sent');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `sno` int(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `username` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`sno`, `email`, `username`, `password`) VALUES
(1, 'info@expressflyltd.com', 'globalexdeliverycompany', 'Admin111@'),
(2, 'info@globalexdeliverycompany.com', 'globalexdeliverycompany', 'good134');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `request`
--
ALTER TABLE `request`
  ADD PRIMARY KEY (`sno`);

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`sno`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `deposits`
--
ALTER TABLE `deposits`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=363;

--
-- AUTO_INCREMENT for table `move`
--
ALTER TABLE `move`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=138;

--
-- AUTO_INCREMENT for table `request`
--
ALTER TABLE `request`
  MODIFY `sno` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=143;

--
-- AUTO_INCREMENT for table `tracking`
--
ALTER TABLE `tracking`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `sno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

/*!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 */;
