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

START TRANSACTION;



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

--
-- Table structure for table `tracking_details`
--

CREATE TABLE `tracking_details` (
  `id` int(11) NOT NULL,
  `tracking_number` varchar(255) NOT NULL,
  `origin` varchar(255) NOT NULL,
  `destination` varchar(255) NOT NULL,
  `weight` varchar(50) NOT NULL,
  `cubic` varchar(50) NOT NULL,
  `sender_name` varchar(255) NOT NULL,
  `receiver_name` varchar(255) NOT NULL,
  `receiver_number` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `parcel_name` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `size` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `delivery_required_by` varchar(255) NOT NULL,
  `estimated_delivery` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tracking_details`
--

INSERT INTO `tracking_details` (`id`, `tracking_number`, `origin`, `destination`, `weight`, `cubic`, `sender_name`, `receiver_name`, `receiver_number`, `email`, `parcel_name`, `status`, `size`, `message`, `delivery_required_by`, `estimated_delivery`, `image`) VALUES
(7, '1234567890', 'lagos', 'china', '45', '324', 'Bright', 'david', '2311513455412', 'brytedree@gmail.com', 'bag', 'Pending', '34', 'big big bag', '2022-08-30 02:35', '2022-08-03 06:45', 'mcLsN7IEms.png'),
(8, 'Rpf22kWk07', 'lagos', 'china', '45', '324', 'Bright', 'david', '2311513455412', 'brytedree@gmail.com', 'bag', 'Pending', '34', 'h', '2022-08-29 05:32', '2022-08-23 15:42', 'Rpf22kWk07.png'),
(9, 'zlQeihxy8f', 'Denmark', 'Aster Dell', '200kg', '390m', 'Nigel Miller', 'Eliana Hooper', '614', 'tyvyhym@mailinator.com', 'Weddig gift', 'Out for delivery', 'fragile', 'Est consequuntur no', '2023-02-03 19:15', '2009-10-24 16:32', 'zlQeihxy8f.png'),
(10, 'BibyeSgEWE', 'Deleniti dolores ut ', 'Sequi atque nulla mi', 'Veniam molestiae eo', 'Consectetur volupta', 'Axel Sims', 'Demetria Koch', '446', 'siro@mailinator.com', 'Mollitia quam amet ', 'Cancelled', 'Consectetur ex debi', 'Veritatis nisi occae', '2008-01-01 08:51', '2000-06-24 05:55', 'BibyeSgEWE.png'),
(11, '4qHQwa3ebr', 'Denmark', 'Amsterdam', '200kg', '390m', 'Adam Smith', 'Henry Bales', '1234567890', 'mail@mailinator.com', 'Wedding Gift', 'In Transit', 'fragile', 'A token of my love', '2022-12-02 14:03', '2022-12-01 14:03', '4qHQwa3ebr.png');

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

--
-- Table structure for table `tracking_update`
--

CREATE TABLE `tracking_update` (
  `id` int(11) NOT NULL,
  `tracking_number` varchar(255) NOT NULL,
  `message` varchar(1000) NOT NULL,
  `status` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tracking_update`
--

INSERT INTO `tracking_update` (`id`, `tracking_number`, `message`, `status`, `created_at`) VALUES
(7, '1234567890', 'Your shipment has been picked up by the receiver ', 'Picked up', '2022-07-12 03:57:00'),
(8, '1234567890', 'fgdggdgddg', 'Pending', '2022-07-13 16:09:00'),
(9, '1234567890', 'sdsddds', 'In Transit', '2022-07-13 16:14:00'),
(10, 'CoSgcSQ9yh', '', 'Picked up', '0000-00-00 00:00:00'),
(11, 'mcLsN7IEms', 'big big bag', 'Pending', '2022-08-18 00:33:00'),
(12, 'Rpf22kWk07', 'h', 'Pending', '2022-08-25 01:45:00'),
(13, 'zlQeihxy8f', 'Est consequuntur no', 'Out for delivery', '2010-09-19 10:21:00'),
(14, 'BibyeSgEWE', 'Veritatis nisi occae', 'Cancelled', '2020-02-15 21:24:00'),
(15, 'zlQeihxy8f', 'deereeed', 'Enroute', '2022-11-05 02:03:00'),
(16, '4qHQwa3ebr', 'A token of my love', 'In Transit', '2022-11-05 09:03:00'),
(17, '4qHQwa3ebr', 'Parcel in transit to Mexico, Held by Authority ', 'Pending', '2022-11-17 04:07:00'),
(19, '4qHQwa3ebr', 'iohniuin', 'In Transit', '2022-12-16 18:15:00'),
(20, '4qHQwa3ebr', 'k', 'Delivered', '2022-12-25 06:18:00');

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

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

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

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

