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

START TRANSACTION;



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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int(11) NOT NULL,
  `message` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `message`, `name`, `email`, `subject`) VALUES
(1, 'gyu', 'miugiu', 'hkgyugt', 'hgiug'),
(2, '423423', 'wrt43', '4t434@ed4e.com', 'dfr'),
(3, '423423', 'wrt43', '4t434@ed4e.com', 'dfr'),
(4, 'i have a complaint', 'larry', 'mabuk@larry.com', 'complaint');

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

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` int(11) NOT NULL,
  `product_id` varchar(255) NOT NULL,
  `current_location` varchar(255) NOT NULL,
  `destination_address` varchar(255) NOT NULL,
  `status_item` varchar(255) NOT NULL,
  `sender_name` varchar(255) NOT NULL,
  `receiver_name` varchar(255) NOT NULL,
  `package` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `depart_date` varchar(255) NOT NULL,
  `exp_date` varchar(255) NOT NULL,
  `shipment_mode` varchar(255) NOT NULL,
  `pickup_date_time` varchar(255) NOT NULL,
  `depart_time` varchar(255) NOT NULL,
  `weight` varchar(255) NOT NULL,
  `quantity` varchar(255) NOT NULL,
  `carrier_r_n` varchar(255) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `carrier` varchar(255) NOT NULL,
  `comments` varchar(255) NOT NULL,
  `image` longblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`id`, `product_id`, `current_location`, `destination_address`, `status_item`, `sender_name`, `receiver_name`, `package`, `email`, `phone`, `depart_date`, `exp_date`, `shipment_mode`, `pickup_date_time`, `depart_time`, `weight`, `quantity`, `carrier_r_n`, `remark`, `carrier`, `comments`, `image`) VALUES
(21, 'Q0AOh', 'Barcelona Spain', ' No 11 La Mouette. Sandrivier street. Riversdal. Meyerton. Gauteng. South Africa', 'Package now on hold in Johannesburg south africa', 'James Victor', 'Sandra Meyer', 'Express', 'sandra.meyer@webmail.co.za', '0789904498', '11-12-2020', '14-12-2020', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'sandra.meyer@webmail.co.za', '0789904498', 'Enter Remark', 'South Africa', 'Enter Comment', ''),
(23, 'eSf14', 'South Africa', 'i445 Orange Avenue space 55 Chula  vista  Ca 91911', 'Transit on hold', 'Daniel Alfred', 'Lydia Beanes', 'UNKNOWN YET', 'lydiabeanes@icloud.com', '619 621 0737  ', '11-12-2020', '17-12-2020', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'lydiabeanes@icloud.com', '619 422 5712', 'Enter Remark', 'San Diego City in California', 'Enter Comment', ''),
(24, 'gnOV3', 'Barcelona Spain', '142 Dubbeltjiegras street Danville ext 3  West View  Pretoria West ', 'Transit on hold', 'Victor James.', 'Paula Khumalo', 'Express', 'pc.khumalo1@gmail.com', '+27 82 513 6736', '14-12-2020', '19-12-2020', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'pc.khumalo1@gmail.com ', '+27 82 513 6736', 'Enter Remark', 'Cape Town South Africa', 'Enter Comment', ''),
(26, 'JTkKR', 'Canada', ' 460 ash Ave s  Maple lake mn 55358 USA', 'Transit on hold', 'Anthony Nelson', 'Tanya jude ', 'Express', 'tanyajude62@gmail.com', '+1612442 3079', '18-12-2020', '21-12-2020', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '3kg', 'tanyajude62@gmail.com', '+1612442 3079', 'Enter Remark', 'USA', 'Enter Comment', ''),
(30, '3cuCo', 'Iraq ', '14 Villa Maroela Onderste Street Krugersdop North 1739 Gauteng South Africa', 'Transit on hold', 'Daniel Ray', 'Anna Maria Geldenhuys', 'Standard', 'annettedv77@gmail.com', '074 428 0348', '3-1-2021', '10-1-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'annettedv77@gmail.com', '074 428 0348', 'Enter Remark', 'Cape Town South Africa', 'Enter Comment', ''),
(32, 'cuY3x', 'Aden Yemen', 'No. 4, No. 24, 22nd Lane, Taitang 1st Street, Pingtung City Taiwan', 'Transit on hold', 'Captain Lee', ' He Yating', 'Express', 'yaiyai19401055@yahoo.com.tw', '886911884662', '11-14-2019', '11-29-2019', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'yaiyai 19401055@yahoo.com.tw', '886911884662', 'Enter Remark', 'Taipei Taiwan ', 'Enter Comment', ''),
(33, '4Aac8', 'Kansas', '26202 bubbling brook drive foristell Missouri 63348', 'Hold', 'Anthony Nelson', 'Brenda Williams', 'Standard', 'bdsue1984@gmail.com', '+1636-312-4706', '1-25-2021', '2-4-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '3kg', 'bdsue1984@gmail.com', '+1636-312-4706', 'Enter Remark', ' Kansas City', 'Enter Comment', ''),
(35, 'TQ5g0', 'USA City los Angeles', 'Türkiye İlim ve Edebiyat Eseri Sahipleri Meslek Birliği  İzmir 1. CADDE 33/16 Aydın APARTMANI 4. Kat Kızılay / ANKARA/TÜRKİYE', 'Hold', 'kiefer Sutherland ', 'Mine Tokyürek', 'Standard', 'aysenurkosar226@gmail.com', '+9 0537 477 79 92', '1-30-2021', '2-03-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '3kg', 'aysenurkosar226@gmail.com', '+9 0537 477 79 92', 'Enter Remark', 'Spain', 'Enter Comment', ''),
(37, 'JWbdz', 'Iraq', '24273 Leeustraat N2GATEWAY Delft Cape Town South Africa   nearest airport Cape Town International Airport', 'Transit on hold', 'Alfred Raymond', 'Melony Daniels ', 'Standard', 'Melonyd21@gmail.com', ' 0607967933', '2-05-2021', '2-09-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'Melonyd21@gmail.com', '0607967933 ', 'Enter Remark', 'Johannesburg South Africa', 'Enter Comment', ''),
(38, 'PZFcI', 'Iraq ', 'Хорошо 720005 КыргызÑтан. Город Бишкек П/К Елецкий 63/1 Джапаркулова ', 'Transit on hold', 'Daniel Raymond ', 'Сабыркуль', 'Standard', 'dsabyrkul@gmail.com', '+996 500 900 493', '10-02-2021', '16-02-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'dsabyrkul@gmail.com', '+996 500 900 493', 'Enter Remark', 'Kyrgyzstan (Kyrgyz Republic)', 'Enter Comment', ''),
(39, '17vrO', 'Los Angeles California', '192 Wright road york ,alabama 36925.  ', 'Transit on hold', 'Robert Lendvai', ' Mitsy Brooks. ', 'Standard', 'Mitsybrooks@gmail.com', '+1 205-736-1847', '2-25-2021', '2-26-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '3kg', 'Mitsybrooks@gmail.com', '+1 205-736-1847', 'Enter Remark', 'Alabama Airport', 'Enter Comment', ''),
(40, 'y8xp6', 'Iran', '中国四å·çœæˆ都市é’羊区9å·院9栋3å•元12å·', 'Transit on hold', 'Kimmiller', 'å´兴明', 'Standard', '', '15308034721', '8-4-2021', '15-4-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', '', '15308034721', 'Enter Remark', 'Beijing China', 'Enter Comment', ''),
(42, 'GYqRB', 'Iran', '中国广东çœ深圳市龙岗区横岗街é“腾昌一路', 'Transit on hold', 'Kimmiller', 'æ¨瑷绫', 'Standard', 'yang396833@qq.com', '13266844314', '11-4-2021', '15-4-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'yang396833@qq.com', '13266844314', 'Enter Remark', 'Beijing China', 'Enter Comment', ''),
(44, 'ONsFY', 'Iraq ', '43 drosday str peerles park noord kraaifontein 7570 Cape Town', 'Transit on hold', 'Alfred Raymond', 'Lindie Linde ', 'Standard', 'lindielinde69@gmail.com', '+27 68 135 5848', '4-17-2021', '4-23-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'lindielinde69@gmail.com', '086 135 5848', 'Enter Remark', 'Johannesburg South Africa', 'Enter Comment', ''),
(45, 'C28AG', 'Iran', '深圳市罗湖区è‰埔å“屋æ‘181栋602室刘端元收', 'Transit on hold', 'Kimmiller', '刘端元', 'Standard', '', '15399704697', '4-17-2021', '4-20-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', '', '18273731969', 'Enter Remark', 'Beijing China', 'Enter Comment', ''),
(46, 'th7Uq', 'Iraq ', '1294 9th Avenue  Chatsworth  Malmesbury  Capetown  Western cape  South Africa ', 'Transit on hold', 'Alfred Raymond', 'Belinda  Oliver Oppelt (Cook)', 'Standard', 'Belindacook816@gmall.com', '0730710630', '4-19-2021', '4-23-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'Belindacook816@gmall.com', '0730710630', 'Enter Remark', 'Johannesburg South Africa', 'Enter Comment', ''),
(48, '3lfEN', 'Iraq ', 'Варшава, Польща вул. БогумунівÑька, 17. ІндекÑ 037.', 'Transit on hold', 'Oliver Connor', 'Галина ЯроÑлавівна', 'Standard', 'jdegalia71@gmail.com', '+ 48783447371, + 48731239702,', '4-27-2021', '4-29-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'jdegalia71@gmail.com', ' + 48886768490', 'Enter Remark', 'Slovakia ', 'Enter Comment', ''),
(49, 'DAGtS', 'Iraq ', 'КазахÑтан г. Ðлматы ул Жана гаÑыр 19', 'Transit on hold', ' Grenn James', 'Барлыкова Ðургуль Жумановна', 'Standard', 'nurgulurbarlykova@gmail.com', '', '5-2-2021', '5-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'nurgulurbarlykova@gmail.com', '', 'Enter Remark', 'Zhezdy Kazakhstan', 'Enter Comment', ''),
(51, 's9PWq', 'Iraq ', '16144 Bramell St, detroit MI 48219 , Detroit Metropolitan Wayne County Airport. ', 'Transit on hold', 'Raymond Alfred ', 'LYNEETTE', 'Standard', 'raylyneette@gmail.com', '+1 248-243-6295', '5-2-2021', '5-6-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'raylyneette@gmail.com', '+1 248-243-6295', 'Enter Remark', 'Dearborn', 'Enter Comment', ''),
(52, 'SIaiu', 'Iraq ', '8 maple close  Medowie  2318 New south Wales  Australia ', 'Transit on hold', 'Morris Walker', 'Heather mason', 'Standard', 'heather.d.mason@live.com', '+61 419201998', '05-14-2021', '05-18-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'heather.d.mason@live.com', '+61 419201998', 'Enter Remark', 'Sydney ', 'Enter Comment', ''),
(54, 'Z2DXQ', 'Iraq ', '中国å‰林çœ长春市绿圆区西诚家圆妈妈译站，', 'Transit on hold', 'Captain Lee Bung', '玲å­', 'Standard', '', '13578676506', '18-05-2021', '20-05-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', '', '13578676506', 'Enter Remark', 'Beijing China', 'Enter Comment', ''),
(56, 'QO0fb', 'Canada', 'Rua Antônio Bernardes costa 300 Bairro Laranjeiras CEP 38410230 Condomínio laranjeira apartamento 201bloco B Uberlândia MG', 'Transit on hold', 'Mark Hooderson', 'Maria Aparecida Luz', 'Standard', 'cida_aparecidinha145@hotmail.com', ' 55 34 996492781', '19-05-2021', '22-05-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'cida_aparecidinha145@hotmail.com', ' 55 34 996492781', 'Enter Remark', 'Bolivia Brazil', 'Enter Comment', ''),
(58, 'c5JtS', 'Iraq ', 'å±æ±縣 潮州鎮 å—進路 二巷13號', 'Transit on hold', 'Captain Lee', '潘永芸', 'Standard', '', '0968884739', '19-05-2021', '22-05-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', '', '0968884739', 'Enter Remark', 'Taipei Taiwan ', 'Enter Comment', ''),
(61, '3wK2D', 'Iraq ', '1320  Mary St. N. 501 Oshawa  Ontario  Canada  L1G 6Y9', 'Transit on hold', 'Alfred D Raymond', 'Marian  Vera Smith', 'Express', 'smith_marian@hotmail.com', '1-905-926-1291', '01-6-2021', '04-6-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'smith_marian@hotmail.com', '1-905-926-1291', 'Enter Remark', 'Calgary', 'Enter Comment', ''),
(62, 'PqlaQ', 'Afghanistan', '101 Woh Chai St Shek kip Mei Post office Hong Kong', 'Transit on hold', 'Kim Meyer', 'Marry Ann D.Pineda', 'Standard', 'davidmaeann192@gmail.com', '+85260971815', '12-6-2021', '14-6-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'davidmaeann192@gmail.com', '+85260971815', 'Enter Remark', 'Kowloon , Kowloon City', 'Enter Comment', ''),
(64, 'pq1dH', 'Afghanistan', '24955 Harrislee Süderstrasse 33.Germany', 'Transit on hold', 'Kim Meyer', 'Bärbel', 'Standard', 'Barbel@gmail.com', '+491789312732', '13-6-2021', '16-6-2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.8kg', 'Bärbel@gmail.com ', '+491789312732', 'Enter Remark', 'Berlin', 'Enter Comment', ''),
(67, 'HdbAs', 'Syria Damascus ', '201ny Tyler st Mc Gregor', 'Arrive sort facility germany', 'Karina Lopez ', 'Michael Gutierrez ', 'Flight ', 'karinalopez0706116@gmail', '+ (337) 378-7574', '28/60/2021', '01/70/2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.5kg', 'Jben4real@gmail.com ', '+124 092656619', 'Enter Remark', 'Germany', 'Enter Comment', ''),
(69, 'jWdGO', 'Scotland United Kingdom', '8 Haverhill St. Haverhill, Ma. 01830', 'Package on hold at Arizona Custom department USA', 'Craig Morgan', 'Margaret Wiseman', 'Flight', 'craigmorgan157@gmail.com', '+19299224930', '01/07/2021', '05/07/2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '5.5kg', 'wpeggy934@gmail.com', '19786416210', 'Enter Remark', ' Arizona,USA', 'Enter Comment', 0x6d6d6578706f7274313534303738353630333132302e6a7067),
(72, 'Pa4ZA', 'Texas United States', '132 wright street sunshine 3023 Victoria Australia', 'Box Parcel ', 'Samuel David ', 'Nancy Mow', 'Safe and Trusted ', 'robinevans006@gmail.com', '+1 (929) 269-4572', '8th July 2021', '9th July 2021 ', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '25kg', 'nancymow6509@gmail.com', '+61 4027 11865', 'Enter Remark', '💲âŒâŒâŒ📴Your package Box is now in Sidney Kingsford Smith International Airport Australia 🇦🇺  its On hold for check up by immigration Officers please contact our customer service below to communicate with them. ', 'Enter Comment', ''),
(73, 'tF2T1', 'Phillipine Bank ', ' Tripoli  shock street Libya ', 'Box Delivery ', 'Philippine National Bank', 'Nouri Dadaosh', 'Home safe and Trusted Delivery ', 'robinevans006@gmail.com', '', '10th July 2021', '12th July 2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '25KG', 'â€‪Nouridadaosh82@gmail.com‬â€', '+218 913206448', 'Enter Remark', '🛑âŒ🛑 Your package Box is now in  Tobruk Airport Libya 🇱🇾 its On hold for security check up by immigration Officers please contact our customer service below to communicate with them', 'Enter Comment', ''),
(74, 'mUd8s', 'Phillipine to Libya ', 'Libya Tarhuna city Municipal Branch Sunday Market Near Tawheed Mosque', 'Box Parcel ', 'Delivery Officer Robin Evans ', 'Sobhi Salama', 'Trusted and fast Delivery ', 'robinevans006@gmail.com', '+1 (893) 698-0077', 'July 10th 2021', '12 July 2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '25 KG ', 'smsalama64@gmail.com', '+218 92-5056158', 'Enter Remark', '🛑âŒ🛑 Your package Box is now in  Tripoli International Airport Libya 🇱🇾 its On hold for security check up by immigration Officers please contact our customer service below to communicate with them.', 'Enter Comment', ''),
(76, 'JA3k0', 'Syria Damascus military camp', '9932 Rte 8 Blissfield New Brunswick Canada ', 'Box Delivery ', 'Karina Lopez ', 'Mark John  Arbeau ', 'Trusted Delivery service ', 'robinevans006@gmail.com', '+1(929) 269-4572', '17/07/2021', '19/07/2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '35 kg heavy ', 'Markkarbeau@gmail.com ', '+1 506 869-649', 'Enter Remark', 'âŒâŒâŒ Box now on Security check out by immigration Officers at Halifax / Stanfield International Airport Halifax Canada please  contact our customer service below to make Clearance Asap ', 'Enter Comment', ''),
(77, '9F3KW', 'USA California ', '4/2 Peterson Avenue Coburg North 3058 Melbourne Australia', 'Box Document Delivery ', 'James Williams ', 'Allyson Stallion', 'Fast way Trusted Delivery Service ', 'samsungcompanyofficial8@gmail.com', '+1 (929) 269‑4572', '26/07/2021', '27/07/2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '35kg ', 'al-dal@live.com', '+61 0423067949', 'Enter Remark', 'âŒâŒâŒ➡ï¸Your Goods is now on hold by immigration Officer in Canberra international Airport Australia, please contact our customer service for further assistance ', 'Enter Comment', ''),
(78, 'KISJ3', 'California USA ', 'Douar Ouled Bouaisha, Almoravid, Marrakech Morocco', 'Trusted and Reliable Service ', 'Cynthia Parker ', 'Al-Maskini Abdul Malik, ', 'Box Delivery ', 'robinevans006@gmail.com', '+1 (929) 269-4572', '30/07/2021', '31/07/2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '39kg', 'ahmedfirahmed@gmail.com', '+212655949837', 'Enter Remark', 'Flight left California few hours Ago now On the way to Australia ', 'Enter Comment', ''),
(79, 'sMdAU', 'California USA ', 'Václavské předměstí Písek 39701 Czech republic', 'Box Delivery ', 'Cynthia Parker ', 'Alois Nepereny', 'Box Delivery ', 'robinevans006@gmail.com', '+1 (929) 269-4572', '31/07/2021', '01/07/2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '35kg weight ', 'Alois.nepereny@gmail.com', '+420 607650104', 'Enter Remark', 'âŒâŒâŒ➡ï¸ Your Goods now on Security check up in Ostrava international Airport Czech republic please contact our customer service down below on how to sort out this issue, thanks for your service ', 'Enter Comment', ''),
(80, 'MKUqW', 'Europe German Mortgage investment Company ', 'Jr 2300 Welton St # Apt 221 Denver Colorado 80205', 'Box Parcel Document Delivery ', 'Europe German Mortgage investment Company management ', 'Henry Brown ', 'Fast way Trusted Delivery Service ', 'jben4real@gmail.com', '+1 (929) 269-4572', '08/03/2021', ' 08/04/2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '35kg', 'henrybrown712@yahoo.com', '+1 (303) 956-7138', 'Enter Remark', 'âŒâŒâŒ You have to make Clearance of your Box as soon as possible ', 'Enter Comment', ''),
(81, 'E5Lr4', 'United States California ', 'Address  Curacao  Willemstad  Breedestraat  129 apt G', 'Box Parcel ', 'SAMSUNG COMPANY ', 'Diego Manuel  Villegas Arocha', 'Fast and Trusted Delivery ', 'jben4real@gmail.com', '+1 (929) 269-4572', '15/08/2021', '16/08/2021', 'EnterShipmentMode', 'PickupDate&Time', 'DepartmentTime', '25KG', 'diegomvillegasa@gmail.com', '+599 96820910', 'Enter Remark', 'âŒâŒâŒ Goods on Hold under security check please contact Our customer service for Solutions your package is presently in your country 🇨🇼 ', 'Enter Comment', '');

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

--
-- Table structure for table `summary_vat`
--

CREATE TABLE `summary_vat` (
  `id` int(11) NOT NULL,
  `summary` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `product_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `summary_vat`
--

INSERT INTO `summary_vat` (`id`, `summary`, `amount`, `product_id`) VALUES
(2, '$0.00', '$2,000', 'mgQwR'),
(3, '$0.00', '$2,000', 'mgQwR'),
(4, '$0.00', '$2,000', 'mgQwR');

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `testimonial` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `track_history`
--

CREATE TABLE `track_history` (
  `id` int(11) NOT NULL,
  `current_location` varchar(255) NOT NULL,
  `dates` varchar(255) NOT NULL,
  `status_item` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `product_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `track_history`
--

INSERT INTO `track_history` (`id`, `current_location`, `dates`, `status_item`, `color`, `product_id`) VALUES
(12, 'Paris', '28/5/2020', 'ACTIVE', 'green', 'mgQwR'),
(13, 'Quater', '29/5/2020', 'Held By Custom', 'red', 'mgQwR'),
(14, 'Abudabi', '2020-06-01', 'In Transit', 'green', 'mgQwR'),
(15, 'Tiamo Island', '10:13 - 18/09/2020', 'Transit', '', 'WbhVH'),
(16, 'Tiamo Island', '10:13 - 18/09/2020', 'Received by Courier', '', 'WbhVH'),
(17, 'usa', '10-09-2020', 'hold', '', 'YZem6'),
(18, 'usa', '10-09-2020', 'hold', 'Brown', 'product_id'),
(19, 'usa', '11-09-2020', 'hold', 'Brown', 'WbhVH'),
(20, 'Malaysia', '11-09-2020', 'in-transit ', 'Brown', 'd7Dhv'),
(21, 'USA', '5-09-2020', 'hold', 'Brown', 'd7Dhv'),
(26, 'Malaysia', '', 'in-transit ', 'Brown', 'si9W7'),
(27, 'USA', '2020-03-09', 'in-transit ', 'Brown', 'jEex7'),
(28, 'Benin', '03/09/2020', 'brown leaf', 'brown', 'Er6mo'),
(29, 'oyo', '07/09/2020', 'brown leaf', 'brown', 'Er6mo'),
(30, 'lagos', '09/09/2020', 'brown leaf', 'brown', 'Er6mo'),
(31, 'ghana', '10/09/2020', 'brown leaf', 'brown', 'Er6mo'),
(32, 'ghana', '04/09/2020', 'ACTIVE ', 'green', 'VoKgx'),
(33, 'lagos', '07/09/2020', 'ACTIVE ', 'green', 'VoKgx'),
(34, 'Indonesia', '5-09-2020', 'hold', 'Brown', 'd7Dhv'),
(35, 'jbndsh', 'weqjkbqh', 'jhbebw', 'tn4', 'xjcIg'),
(36, 'jbndsh', 'weqjkbqh', 'jhbebw', 'tn4', 'xjcIg'),
(37, 'jbndsh', 'weqjkbqh', 'jhbebw', 'tn4', 'xjcIg');

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

--
-- Table structure for table `vat`
--

CREATE TABLE `vat` (
  `id` int(11) NOT NULL,
  `location` varchar(255) NOT NULL,
  `bill_peiod` varchar(255) NOT NULL,
  `invoice_date` varchar(255) NOT NULL,
  `product_id` varchar(255) NOT NULL,
  `due_date` varchar(255) NOT NULL,
  `past_due_ammount` varchar(255) NOT NULL,
  `current_charges` varchar(255) NOT NULL,
  `payments` varchar(255) NOT NULL,
  `adjustment` varchar(255) NOT NULL,
  `amount_due` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vat`
--

INSERT INTO `vat` (`id`, `location`, `bill_peiod`, `invoice_date`, `product_id`, `due_date`, `past_due_ammount`, `current_charges`, `payments`, `adjustment`, `amount_due`) VALUES
(2, 'Barbara Ackerson 2912 Moon Lake drive Rice Lake WI54868', '26/12/19 To 30/1219', '10/9/2020', 'mgQwR', '30/9/2020', '$0.00', '$2,000', '$0.00', '$22.00', '0.00');

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

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

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

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

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

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

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

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

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

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

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

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

