-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jun 18, 2025 at 01:03 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 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: `courierx` -- -- -------------------------------------------------------- -- -- 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', '@Advancecargo1234'); -- -------------------------------------------------------- -- -- 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, `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`, `mail_track_update`, `mail_track_save`) VALUES (1, 'Advanced Premier Freights', 'Advanced Premier Freights', 'http://advancedpremierfreights.online', 'ADVA', '8', 'terms', 'Yes', 'Yes', 'Advanced Premier Freights', 'info@advancedpremierfreights.online', '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 (1, 'CX-23-07-59406381', 'John Doe', '08123456789', 'testuser@gmail.com', 'Jao street', 'Delivered', 'Aba', 'testuser2@gmail.com', 'Ruger Rand', '08123456789', 'Buao Street', '2024-07-07', '2024-07-14', 'Top', 'Mando', NULL, 'Ex-Drill Express', '32432', 'Land trans', '5kg', '1', 'On Delivery', 'CX-23-07-59406381.png', '10:00', '2024-07-14 20:35:32'), (2, 'ADVA-06-64718935', 'LUKE DUVRAU', '145268978595', 'ulrichwilfried1234@gmail.com', 'FOKOU, BONABERI, DOUALA', 'Pending', 'Umm Qasr Port, Iraq', 'walterecot@gmail.com', 'TCHATCHOUANG TEGANTCHOUA ULRICH WILFRIED', '5623251542', 'FOKOU, BONABERI, DOUALA', '2025-06-18', '2025-06-20', 'TYPRE', 'Port, Newyork, USA', NULL, 'DHL', '253415', 'AIR', '25KG', '1', 'CASH', 'ADVA-06-64718935.png', '00:30', '2025-06-18 07:56:17'); -- -------------------------------------------------------- -- -- 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() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- 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=3; -- -- AUTO_INCREMENT for table `track_update` -- ALTER TABLE `track_update` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; 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 */;