-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 24, 2023 at 09:09 PM
-- Server version: 10.3.39-MariaDB-cll-lve
-- PHP Version: 8.1.16

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `freetuto_startesk`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `password`) VALUES
(1, 'admin', '123456');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `sitename` varchar(255) NOT NULL,
  `site_title` varchar(255) NOT NULL,
  `site_url` varchar(255) NOT NULL,
  `track_prefix` varchar(255) NOT NULL,
  `track_num` varchar(255) NOT NULL,
  `invoice_terms` text NOT NULL,
  `allow_print` enum('Yes','No','','') NOT NULL,
  `show_map` enum('Yes','No','','') NOT NULL,
  `email_name` varchar(255) NOT NULL,
  `email_address` varchar(255) NOT NULL,
  `phone` varchar(500) NOT NULL,
  `address` varchar(500) NOT NULL,
  `site_logo` varchar(500) NOT NULL,
  `mail_track_update` enum('Yes','No','','') NOT NULL,
  `mail_track_save` enum('Yes','No','','') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `sitename`, `site_title`, `site_url`, `track_prefix`, `track_num`, `invoice_terms`, `allow_print`, `show_map`, `email_name`, `email_address`, `phone`, `address`, `site_logo`, `mail_track_update`, `mail_track_save`) VALUES
(1, 'StarTesk', 'Logistics', 'https://startesk.freetutorz.tech', 'AAE1', '10', 'terms', 'Yes', 'Yes', 'StarTesk', 'support@startesk.freetutorz.tech', '138 Lower Rd, London SE16 2UG111', '+44 20 8895 2479', '65746e78d873flogo.png', 'Yes', 'Yes');

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

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

CREATE TABLE `tracking` (
  `id` int(11) NOT NULL,
  `tracking_number` varchar(255) NOT NULL,
  `sender_name` varchar(255) NOT NULL,
  `sender_contact` varchar(255) NOT NULL,
  `sender_email` varchar(255) NOT NULL,
  `sender_address` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `dispatch_location` varchar(255) NOT NULL,
  `receiver_email` varchar(255) NOT NULL,
  `receiver_name` varchar(255) NOT NULL,
  `receiver_contact` varchar(255) NOT NULL,
  `receiver_address` varchar(255) NOT NULL,
  `dispatch_date` varchar(255) NOT NULL,
  `delivery_date` varchar(255) NOT NULL,
  `pdesc` varchar(255) NOT NULL,
  `destination` varchar(255) NOT NULL,
  `current_location` varchar(255) DEFAULT NULL,
  `carrier` varchar(255) NOT NULL,
  `carrier_ref` varchar(255) NOT NULL,
  `ship_mode` varchar(255) NOT NULL,
  `weight` varchar(255) NOT NULL,
  `quantity` varchar(255) NOT NULL,
  `payment_mode` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `delivery_time` varchar(255) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `tracking` (`id`, `tracking_number`, `sender_name`, `sender_contact`, `sender_email`, `sender_address`, `status`, `dispatch_location`, `receiver_email`, `receiver_name`, `receiver_contact`, `receiver_address`, `dispatch_date`, `delivery_date`, `pdesc`, `destination`, `current_location`, `carrier`, `carrier_ref`, `ship_mode`, `weight`, `quantity`, `payment_mode`, `image`, `delivery_time`, `date`) VALUES
(7, 'AAE1-12-2084137695', 'Emmanuella Rek', '0909878876', 'gseun129@gmail.com', '124 New Dev Cord 34', 'Departed', 'Australia', 'gseun129@gmail.com', 'Desmond Tutu', '8998787776', 'Emma Lane USA', '2023-12-12', '2023-12-25', '2 Box of Cloths Phones and Laptop', 'United States', 'Guinea Bisau', 'Fedex', '343409', 'Air', '25KG', '34', 'Transfer', 'AAE1-12-2084137695.png', '10:11', '2023-12-21 20:25:42'),
(8, 'AAE1-12-8315096742', 'Tema Anderson', '89898898888', 'gseun129@gmail.com', '86yDes abandon lane', 'Active', 'Amsterdam', 'gseun129@gmail.com', 'Mariam Anderson', '908778888', '23 Hun Clear Ave 45676', '2023-12-12', '2023-12-25', '2 Box of Cloths Phones and Laptop', 'United States', 'Berlin', 'Fedex', '343487', 'Air Send', '25KG', '5', 'Transfer', 'AAE1-12-8315096742.png', '12:12', '2023-12-21 20:44:58'),
(9, 'AAE1-12-8936174205', 'John Doe', '048461819166', 'digitalwebartists@gmail.com', 'No. St John', 'Active', 'China', 'emmyswebdesign@gmail.com', 'Emmy Lanes', '078451515169', 'New York 2938', '2023-12-17', '2023-12-29', 'Swift cars', 'USA', 'Australia', 'DHL', '27772666', 'Flight', '2', '15000', 'Paypal', 'AAE1-12-8936174205.png', '10:44', '2023-12-24 18:44:43');

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

--
-- Table structure for table `track_update`
--

CREATE TABLE `track_update` (
  `id` int(11) NOT NULL,
  `track_num` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL,
  `note` varchar(255) NOT NULL,
  `current_location` varchar(255) NOT NULL,
  `updated_at` datetime NOT NULL DEFAULT current_timestamp(),
  `delivery_charge` varchar(255) DEFAULT NULL,
  `total_charge` varchar(255) DEFAULT NULL,
  `is_current_location` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `track_update`
--

INSERT INTO `track_update` (`id`, `track_num`, `status`, `date`, `time`, `note`, `current_location`, `updated_at`, `delivery_charge`, `total_charge`, `is_current_location`) VALUES
(13, 'AAE1-12-2084137695', 'Active', '2023-12-13', '12:12', 'Delivery charge needs to be paid before arrival', 'Albania', '2023-12-21 20:26:52', '25000', '25000', 'yes'),
(14, 'AAE1-12-2084137695', 'Departed', '2023-12-14', '11:11', '', 'Rwanda', '2023-12-21 20:31:00', '', '', 'no'),
(15, 'AAE1-12-2084137695', 'Departed', '2023-12-15', '12:12', 'Delivery charge will be paid on arrival', 'Guinea Bisau', '2023-12-21 20:33:03', '25000', '25000', 'no'),
(16, 'AAE1-12-8315096742', 'Pending', '2023-12-14', '11:11', '', 'Australia', '2023-12-21 20:52:16', '30000', '35000', 'no'),
(17, 'AAE1-12-8315096742', 'Active', '2023-12-16', '11:01', '', 'Italy', '2023-12-21 20:56:16', '', '', 'no'),
(18, 'AAE1-12-8315096742', 'Departed', '2023-12-18', '02:22', '', 'Germany', '2023-12-21 20:59:16', '', '', 'no'),
(19, 'AAE1-12-8315096742', 'Arrived', '2023-12-19', '11:11', '', 'USA', '2023-12-21 21:36:49', '25000', '25000', 'no'),
(20, 'AAE1-12-8315096742', 'On hold', '2023-12-26', '02:02', 'Held for custom checks', 'Dallas', '2023-12-22 17:13:29', '50', '150', 'no'),
(21, 'AAE1-12-8315096742', 'On hold', '2023-12-26', '02:02', 'Held for custom checks', 'Dallas', '2023-12-22 17:15:35', '50', '150', 'no'),
(22, 'AAE1-12-8315096742', 'Active', '2023-12-07', '02:03', 'Parcel is active', 'Berlin', '2023-12-22 17:53:59', '4000', '7500', 'no'),
(23, 'AAE1-12-8936174205', 'Active', '2023-12-25', '21:00', 'Ready to move', 'Australia', '2023-12-24 18:48:35', '3000', '5000', 'no');

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for table `track_update`
--
ALTER TABLE `track_update`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
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 */;
