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

START TRANSACTION;



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

--
-- Table structure for table `history`
--

CREATE TABLE `history` (
  `id` int NOT NULL,
  `shipping_id` varchar(100) DEFAULT NULL,
  `sender_email` varchar(100) DEFAULT NULL,
  `current_location` text,
  `shipment_status` text,
  `status_date` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `history`
--

INSERT INTO `history` (`id`, `shipping_id`, `sender_email`, `current_location`, `shipment_status`, `status_date`) VALUES
(214, '87', '', 'Select Country From', 'Shipment Started', '');

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int NOT NULL,
  `fullname` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `subject` text,
  `message` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `quotes`
--

CREATE TABLE `quotes` (
  `id` int NOT NULL,
  `firstname` varchar(10000) DEFAULT NULL,
  `lastname` varchar(200) DEFAULT NULL,
  `email` varchar(300) DEFAULT NULL,
  `freight_type` varchar(100) DEFAULT NULL,
  `departure_city` text,
  `delivery_city` text,
  `info` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `shipment`
--

CREATE TABLE `shipment` (
  `id` int NOT NULL,
  `sender_name` varchar(150) NOT NULL,
  `sender_email` varchar(150) DEFAULT NULL,
  `sender_phone` varchar(100) DEFAULT NULL,
  `receiver_name` varchar(100) DEFAULT NULL,
  `receiver_email` varchar(100) DEFAULT NULL,
  `receiver_phone` varchar(100) DEFAULT NULL,
  `package_name` text,
  `package_weight` varchar(300) DEFAULT NULL,
  `shipment_type` varchar(100) DEFAULT NULL,
  `booking_date` varchar(100) DEFAULT NULL,
  `country_from` varchar(150) DEFAULT NULL,
  `country_to` varchar(150) DEFAULT NULL,
  `delivery_date` varchar(100) DEFAULT NULL,
  `tracking_code` varchar(100) DEFAULT NULL,
  `payment_amount` varchar(100) DEFAULT NULL,
  `photo` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `shipment`
--

INSERT INTO `shipment` (`id`, `sender_name`, `sender_email`, `sender_phone`, `receiver_name`, `receiver_email`, `receiver_phone`, `package_name`, `package_weight`, `shipment_type`, `booking_date`, `country_from`, `country_to`, `delivery_date`, `tracking_code`, `payment_amount`, `photo`) VALUES
(87, '', '', '', '', '', '', '', '', 'Shipment Type', '', 'Select Country From', 'Select Country To', '', 'F3S-528', '', 'NULL');

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

--
-- Table structure for table `status`
--

CREATE TABLE `status` (
  `id` int NOT NULL,
  `shipping_id` varchar(100) DEFAULT NULL,
  `sender_email` varchar(100) DEFAULT NULL,
  `current_location` text,
  `shipment_status` text,
  `status_date` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `status`
--

INSERT INTO `status` (`id`, `shipping_id`, `sender_email`, `current_location`, `shipment_status`, `status_date`) VALUES
(92, '87', '', 'Select Country From', 'Shipment Started', '');

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

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

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

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

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

--
-- AUTO_INCREMENT for table `history`
--
ALTER TABLE `history`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=215;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=356;

--
-- AUTO_INCREMENT for table `quotes`
--
ALTER TABLE `quotes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `shipment`
--
ALTER TABLE `shipment`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;

--
-- AUTO_INCREMENT for table `status`
--
ALTER TABLE `status`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=93;
COMMIT;

