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

START TRANSACTION;



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

--
-- Table structure for table `parcel`
--

CREATE TABLE `parcel` (
  `id` int(11) NOT NULL,
  `sname` varchar(255) DEFAULT NULL,
  `sphone` varchar(255) DEFAULT NULL,
  `saddress` varchar(255) DEFAULT NULL,
  `semail` varchar(255) DEFAULT NULL,
  `rname` varchar(255) DEFAULT NULL,
  `rphone` varchar(255) DEFAULT NULL,
  `raddress` varchar(255) DEFAULT NULL,
  `remail` varchar(255) DEFAULT NULL,
  `cno` varchar(255) DEFAULT NULL,
  `weight` varchar(255) DEFAULT NULL,
  `package` varchar(255) DEFAULT NULL,
  `quantity` varchar(50) NOT NULL,
  `mode` varchar(255) DEFAULT NULL,
  `product` varchar(255) DEFAULT NULL,
  `payment` varchar(255) DEFAULT NULL,
  `depttime` varchar(255) DEFAULT NULL,
  `deptdate` varchar(30) DEFAULT NULL,
  `origin` varchar(255) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `expdelivdate` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `service_type` varchar(50) NOT NULL,
  `charge` varchar(50) DEFAULT NULL,
  `total` varchar(50) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `bol` varchar(50) NOT NULL,
  `shipment_type` varchar(155) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `parcel`
--

INSERT INTO `parcel` (`id`, `sname`, `sphone`, `saddress`, `semail`, `rname`, `rphone`, `raddress`, `remail`, `cno`, `weight`, `package`, `quantity`, `mode`, `product`, `payment`, `depttime`, `deptdate`, `origin`, `destination`, `status`, `expdelivdate`, `comment`, `service_type`, `charge`, `total`, `image`, `bol`, `shipment_type`) VALUES
(1, 'Chris Renson', '3434342121', 'London Cowbridge, United Kingdom', 'marcdouglas961@gmail.com', 'Janeth Russ', '07823827621', 'Kahew, Massachusetts', 'aguero4pres@gmail.com', '8537DRTU', '10kg', NULL, '60', 'Sea Freight', 'Items', 'BITCOIN', NULL, NULL, 'New York City', 'Istanbul, Turkiye', 'In Transit', '19-12-2023', NULL, 'International', NULL, '$2,500', NULL, '15621241', NULL),
(2, 'Richard Micheal', '07823827621', 'ajax', 'marcdouglas961@gmail.com', 'marc marc', '07823827621', 'London', 'marcdouglas961@gmail.com', '6237ZFKE', '10kg', NULL, '6', 'Sea Freight', 'Items', 'USDT', NULL, NULL, 'New York City', 'FLORIDA, USA', 'In Transit', '03-07-2024', NULL, 'International', NULL, '$3,900', NULL, '15621241', 'Parcel');

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

--
-- Table structure for table `track`
--

CREATE TABLE `track` (
  `id` int(11) NOT NULL,
  `cno` varchar(255) NOT NULL,
  `udate` varchar(255) NOT NULL,
  `utime` varchar(50) DEFAULT NULL,
  `location` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `about` text NOT NULL,
  `remark` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `track`
--

INSERT INTO `track` (`id`, `cno`, `udate`, `utime`, `location`, `status`, `about`, `remark`) VALUES
(1, '8537DRTU', '27/07/2024', '10:26 am', 'Marbella', 'Delivered', 'Item has arrived at', 'bnnmnmnm'),
(2, '8537DRTU', '31/07/2024', '13:36', 'Ottawa', 'In Transit', 'Item has left', 'nmnmnmnm'),
(3, '6237ZFKE', '31/07/2024', '10:26 am', 'Marbella', 'In Transit', 'Item has left', 'Goods Moving');

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

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

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

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

