-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Apr 28, 2026 at 09:14 AM
-- Server version: 8.0.45
-- PHP Version: 8.2.30

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: `cargo`
--

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

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `admin_id` int NOT NULL,
  `username` varchar(50) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `email` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`admin_id`, `username`, `password_hash`, `email`, `created_at`) VALUES
(1, 'admin', 'admin', 'support@reliparcel.com', '2025-10-11 11:52:12');

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

--
-- Table structure for table `contact_messages`
--

CREATE TABLE `contact_messages` (
  `id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT 'New',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `entries`
--

CREATE TABLE `entries` (
  `id` int NOT NULL,
  `prize_id` int NOT NULL,
  `prize_name` varchar(255) NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `age` int NOT NULL,
  `street_address` varchar(255) NOT NULL,
  `city` varchar(100) NOT NULL,
  `zip_code` varchar(20) NOT NULL,
  `heard_about` varchar(50) DEFAULT NULL,
  `entry_date` datetime NOT NULL,
  `id_front_path` varchar(255) DEFAULT NULL,
  `id_back_path` varchar(255) DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `giveaways`
--

CREATE TABLE `giveaways` (
  `id` int NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `image_url` varchar(255) NOT NULL,
  `value` varchar(100) NOT NULL,
  `prize_name_short` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `giveaways`
--

INSERT INTO `giveaways` (`id`, `title`, `description`, `image_url`, `value`, `prize_name_short`) VALUES
(1, 'The Dream Home & $250K Cash', 'A stunning luxury apartment in central London, plus a quarter-million cash to furnish it.', '../uploads/giveaway_images/giveaway_68ebf45430d29.jpg', '$1,500,000+', 'Dream Home'),
(2, 'Luxury Sports Car (BMW M5)', 'Drive away a brand new, fully loaded BMW M5. Insurance and taxes paid for the first year.', '../uploads/giveaway_images/giveaway_68ebf4435d72b.jpg', '$120,000', 'BMW M5'),
(3, 'Cash Prize: $70,000 USD', 'A straight-up $70,000 cash injection into your bank account. Use it for anything you like!', '../uploads/giveaway_images/giveaway_68ebf2e48490b.jpg', '$70,000', '$70,000 Cash');

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

--
-- Table structure for table `payment_proofs`
--

CREATE TABLE `payment_proofs` (
  `proof_id` bigint NOT NULL,
  `payment_method` enum('bank','crypto','giftcard') NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `submission_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `admin_notes` text,
  `processed_by` int DEFAULT NULL,
  `processed_date` timestamp NULL DEFAULT NULL,
  `bank_proof_path` varchar(255) DEFAULT NULL,
  `crypto_currency` varchar(10) DEFAULT NULL,
  `crypto_amount_raw` varchar(50) DEFAULT NULL,
  `crypto_proof_path` varchar(255) DEFAULT NULL,
  `giftcard_value_usd` decimal(10,2) DEFAULT NULL,
  `giftcard_proof_front_path` varchar(255) DEFAULT NULL,
  `giftcard_proof_back_path` varchar(255) DEFAULT NULL,
  `shipment_id` int DEFAULT NULL,
  `tracking_number` varchar(255) DEFAULT NULL,
  `proof_status` varchar(50) NOT NULL DEFAULT 'Pending Review'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `shipments`
--

CREATE TABLE `shipments` (
  `id` int UNSIGNED NOT NULL,
  `tracking_number` varchar(20) NOT NULL,
  `sender_name` varchar(100) NOT NULL,
  `sender_address` text NOT NULL,
  `sender_phone` varchar(20) NOT NULL,
  `receiver_name` varchar(100) NOT NULL,
  `receiver_address` text NOT NULL,
  `receiver_phone` varchar(20) NOT NULL,
  `receiver_email` varchar(255) DEFAULT NULL,
  `package_description` text NOT NULL,
  `weight` decimal(10,2) NOT NULL,
  `dimensions` varchar(50) NOT NULL,
  `service_type` varchar(50) NOT NULL,
  `quantity` int NOT NULL DEFAULT '1',
  `status` varchar(50) NOT NULL DEFAULT 'Pending',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `estimated_delivery` date NOT NULL,
  `package_images` text COMMENT 'JSON array or comma-separated list of package image paths',
  `payment_status` varchar(50) NOT NULL DEFAULT 'Unpaid',
  `amount` decimal(10,2) DEFAULT NULL,
  `currency` varchar(3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shipments`
--

INSERT INTO `shipments` (`id`, `tracking_number`, `sender_name`, `sender_address`, `sender_phone`, `receiver_name`, `receiver_address`, `receiver_phone`, `receiver_email`, `package_description`, `weight`, `dimensions`, `service_type`, `quantity`, `status`, `created_at`, `estimated_delivery`, `package_images`, `payment_status`, `amount`, `currency`) VALUES
(4, 'AWB-5B0DF45D', 'Suzan Blacker', 'Atlanta, Georgia, USA', '+1 38172 172611', 'Luwas', 'Utrecht, Netherlands', '+44 837 182 1811', NULL, 'Electronics', 1.23, '5x7x4', 'International', 1, 'Exception', '2025-11-09 14:48:58', '2025-11-20', 'uploads/shipment/AWB-5B0DF45D_6910a9da7e669.jpg', 'Paid', NULL, NULL),
(16, 'AWB-5605E5B0', 'KENNEDY SMITH', '787 Financial District, N, NY 10001 canadan 56 Pox', '+2899174997', 'Test monks', '24 Marina Road, WallStreet USA', '+1 38172 172611', 'jennifersmith@gmai.com', 'yyyyyyy', 0.02, '30x20', 'Express', 1, 'In Transit', '2026-04-28 07:47:52', '2026-05-05', NULL, 'Unpaid', 7000.00, 'USD');

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

--
-- Table structure for table `site_config`
--

CREATE TABLE `site_config` (
  `setting_key` varchar(255) NOT NULL,
  `setting_value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_config`
--

INSERT INTO `site_config` (`setting_key`, `setting_value`) VALUES
('bank_account_name', 'Linda Grayham Smith'),
('bank_account_number', '0918271275'),
('bank_name', 'Bank of America'),
('bank_sort_code', '381821'),
('contact_email', 'admin@example.com'),
('crypto_btc', ''),
('crypto_eth', 'ETH18271663'),
('crypto_ltc', 'LTC1827162556'),
('crypto_usdt', ''),
('default_language', 'en'),
('enable_sms_sending', '1'),
('facebook_url', 'https://facebook.com/GlobalAxisCargo'),
('giftcard_note', 'Please scratch off the silver strip and ensure the code is clearly visible.'),
('instagram_url', 'https://instagram.com/GlobalAxisCargo'),
('maintenance_mode', '0'),
('site_favicon', 'site_favicon_1776944877.png'),
('site_logo', 'site_logo_1776944790.png'),
('site_title', 'Global Axis Cargo'),
('site_url', 'http://localhost/cargo'),
('smartsupp_code', '<!-- Smartsupp Live Chat script -->\r\n<script type=\"text/javascript\">\r\nvar _smartsupp = _smartsupp || {};\r\n_smartsupp.key = \'ef9f68c550d950c67378dcff6a005855f015abd4\';\r\nwindow.smartsupp||(function(d) {\r\n  var s,c,o=smartsupp=function(){ o._.push(arguments)};o._=[];\r\n  s=d.getElementsByTagName(\'script\')[0];c=d.createElement(\'script\');\r\n  c.type=\'text/javascript\';c.charset=\'utf-8\';c.async=true;\r\n  c.src=\'https://www.smartsuppchat.com/loader.js?\';s.parentNode.insertBefore(c,s);\r\n})(document);\r\n</script>\r\n<noscript>Powered by <a href=\"https://www.smartsupp.com\" target=\"_blank\">Smartsupp</a></noscript>\r\n'),
('smtp_encryption', 'ssl'),
('smtp_from_email', 'reply@codedwebwebmasters.com'),
('smtp_from_name', 'Global Delivery'),
('smtp_host', 'mail.codedwebwebmasters.com'),
('smtp_password', 'Raziboy11*'),
('smtp_port', '465'),
('smtp_username', 'info@codedwebwebmasters.com'),
('telegram_username', '@myusername'),
('twilio_number', '+17652468143'),
('twilio_sid', 'ACb354a463a7f82872c85da51614d41c80'),
('twilio_token', '218a8b9b57e626cc006f651475fe9c29'),
('twitter_url', 'https://twitter.com/GlobalAxisCargo'),
('use_bank', '1'),
('use_crypto', '1'),
('use_facebook', '1'),
('use_giftcard', '1'),
('use_instagram', '1'),
('use_site_logo', '1'),
('use_smartsupp', '1'),
('use_smtp', '1'),
('use_telegram', '1'),
('use_twitter', '1'),
('use_whatsapp', '1'),
('use_youtube', '1'),
('whatsapp_number', '1234567890'),
('youtube_url', 'https://youtube.com/GlobalAxisCargo');

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` int UNSIGNED NOT NULL,
  `client_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_location` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_service` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `testimonial_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rating` tinyint(1) NOT NULL DEFAULT '5',
  `language` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
  `submission_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `client_name`, `client_location`, `product_service`, `testimonial_text`, `client_image_path`, `rating`, `language`, `submission_date`) VALUES
(10, 'Hudson & Wells Law', 'New York, NY', 'Confidential Legal Document Courier', 'For high-stakes contracts, discretion and speed are essential. Their dedicated messenger service provides an **auditable, secure chain of custody** every time.', 'uploads/1max.jpg', 5, 'en', '2025-11-10 09:49:18'),
(11, 'Aura Boutique', 'London, UK', 'Fast Fashion Retail Logistics', 'Their expedited services ensure our latest collections hit our global stores in days, not weeks. **Crucial for staying ahead of trends** and minimizing stock-out risk.', 'uploads/alesia.jpg', 5, 'en', '2025-11-10 09:49:18'),
(12, 'Atlas Manufacturing', 'Detroit, MI', 'Heavy Industrial Component Transport', 'We ship oversized machine parts weekly. Their team is expert at coordinating complex lifts without delay.', 'uploads/emilie.jpg', 5, 'en', '2025-11-10 09:49:18'),
(13, 'Chef Ricardo M.', 'Paris, FR', 'Gourmet Food Wholesale Delivery', 'Excellent handling for fresh produce. The refrigerated trucks are reliable, and the drivers are careful to maintain the **quality and integrity** of our perishable goods.', 'uploads/LJ.jpg', 5, 'en', '2025-11-10 09:49:18'),
(14, 'Innovatech Solutions', 'San Jose, CA', 'Prototype and R&D Shipping', 'When testing new products, we need maximum security and minimal handling. Their **secure, sealed-box delivery** is exactly what we need for sensitive prototypes.', 'uploads/paul.jpg', 5, 'en', '2025-11-10 09:49:18'),
(15, 'Maria Rodriguez', 'Madrid, ES', 'Small Business Partner Program', 'Their volume discounts and streamlined pick-up have allowed me to grow my online pottery shop without the usual logistics headaches. **Highly affordable and reliable**.', 'uploads/testimonial_68ea7fc7612bf.jpg', 4, 'en', '2025-11-10 09:49:18'),
(16, 'Kensington Arts', 'Melbourne, AU', 'Fine Art Exhibition Transport', 'They are one of the few couriers we trust with priceless paintings. Their attention to **crating and insurance documentation** is impeccable.', 'uploads/testimonial_68ea80f7b5a64.jpg', 5, 'en', '2025-11-10 09:49:18'),
(17, 'Driftwood Furniture', 'Vancouver, CA', 'White-Glove Residential Delivery', 'Our customers consistently praise the professional and polite delivery crew. They handle assembly and trash removal, providing a true **white-glove experience**.', 'uploads/testimonial_68ea8099b1f8e.jpg', 5, 'en', '2025-11-10 09:49:18'),
(18, 'Global Trade Hub', 'New Delhi, IN', 'Bulk Import/Export Management', 'Their team demystifies complex import duties and customs paperwork. They have significantly cut down our **border delay times**.', 'uploads/T2.jpeg', 5, 'en', '2025-11-10 09:49:18'),
(19, 'Liam O’Connell', 'Dublin, IE', 'Residential International Move', 'Shipped our entire household abroad. Everything arrived safely and was meticulously accounted for. **Outstanding door-to-door service**.', 'uploads/bald.jpg', 5, 'en', '2025-11-10 09:49:18');

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

--
-- Table structure for table `tracking_history`
--

CREATE TABLE `tracking_history` (
  `id` int UNSIGNED NOT NULL,
  `shipment_id` int UNSIGNED NOT NULL,
  `location` varchar(255) NOT NULL,
  `status_update` varchar(255) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `on_hold_reason` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tracking_history`
--

INSERT INTO `tracking_history` (`id`, `shipment_id`, `location`, `status_update`, `updated_at`, `on_hold_reason`) VALUES
(12, 4, 'Atlanta, Georgia, USA', 'Shipment information received', '2025-11-09 14:48:58', NULL),
(13, 4, 'Port of Newark, NJ, USA', 'In Transit', '2025-11-09 14:50:05', NULL),
(14, 4, 'Port of Felixstowe, UK', 'In Transit', '2025-11-09 14:52:04', NULL),
(15, 4, 'Port of Rotterdam, Netherlands', 'On Hold', '2025-11-09 14:53:20', NULL),
(16, 4, 'Schiphol Airport, Netherlands', 'In Transit', '2025-11-09 15:06:23', NULL),
(23, 4, 'Port of Amsterdam', 'On Hold', '2025-11-13 07:36:07', 'Customs Clearance'),
(24, 4, 'Port of Amsterdam', 'On Hold', '2025-11-13 07:45:46', 'Custom Clearance'),
(26, 4, 'Port of Amsterdam', 'On Hold', '2025-11-13 07:52:40', 'Custom Clearance'),
(44, 4, 'New york', 'Out for Delivery', '2026-04-23 12:40:07', NULL),
(45, 4, 'Washington', 'In Transit', '2026-04-23 12:41:26', NULL),
(46, 4, 'New york', 'Delivered', '2026-04-23 12:42:00', NULL),
(47, 4, 'Washington', 'Exception', '2026-04-23 12:42:37', NULL),
(48, 16, '787 Financial District, N, NY 10001 canadan 56 Pox', 'In Transit', '2026-04-28 07:47:52', NULL);

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

--
-- Table structure for table `winners`
--

CREATE TABLE `winners` (
  `id` int NOT NULL,
  `winner_name` varchar(100) NOT NULL,
  `winner_location` varchar(100) NOT NULL,
  `prize_won` varchar(255) NOT NULL,
  `winner_image_path` varchar(255) DEFAULT NULL,
  `testimonial` text NOT NULL,
  `image_initials` varchar(10) DEFAULT '',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `winners`
--

INSERT INTO `winners` (`id`, `winner_name`, `winner_location`, `prize_won`, `winner_image_path`, `testimonial`, `image_initials`, `created_at`) VALUES
(2, 'Michael Scott', 'Los Angeles, CA', 'Express Overnight Delivery', '../uploads/ABS2GSmGkMuwfiOMw3vPkcMA75J1VmS3.jpg', 'Super fast delivery. Tracking was spot on!', 'MS', '2025-11-10 10:30:00'),
(3, 'Sarah Jenkins', 'Boston, MA', 'Secure Local Parcel', '../uploads/home_delivery.jpg', 'My fragile item arrived safely and on time. Excellent service', 'SJ', '2025-11-10 10:31:00'),
(4, 'Aisha Hassan', 'Dubai, UAE', 'International Freight', '../uploads/aisha.jpg', 'No issues with customs. A smooth overseas shipment.', 'AH', '2025-11-10 10:32:00'),
(5, 'James Wilson', 'London, UK', 'Scheduled Home Delivery', '../uploads/unnamed.jpg', 'The delivery window was perfect. Very reliable service.', 'JW', '2025-11-10 10:33:00'),
(6, 'Carla Jones', 'Madrid, ES', 'Cold Chain Transport', '../uploads/cold_chain.jpg', 'The temperature log confirmed my item stayed chilled. Highly professional.', 'CJ', '2025-11-10 10:34:00'),
(7, 'Refrigerated Food Transport', 'Sydney, AU', 'Refrigerated Food Transport', '../uploads/winner_1.jpg', 'My meal kits arrived perfectly chilled. Excellent temperature control!', 'DK', '2025-11-10 10:35:00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`admin_id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`);

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

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

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

--
-- Indexes for table `payment_proofs`
--
ALTER TABLE `payment_proofs`
  ADD PRIMARY KEY (`proof_id`);

--
-- Indexes for table `shipments`
--
ALTER TABLE `shipments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tracking_number` (`tracking_number`);

--
-- Indexes for table `site_config`
--
ALTER TABLE `site_config`
  ADD PRIMARY KEY (`setting_key`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_product_service` (`product_service`),
  ADD KEY `idx_language` (`language`);

--
-- Indexes for table `tracking_history`
--
ALTER TABLE `tracking_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shipment_id` (`shipment_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `admin_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `contact_messages`
--
ALTER TABLE `contact_messages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `entries`
--
ALTER TABLE `entries`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `giveaways`
--
ALTER TABLE `giveaways`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `payment_proofs`
--
ALTER TABLE `payment_proofs`
  MODIFY `proof_id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `shipments`
--
ALTER TABLE `shipments`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tracking_history`
--
ALTER TABLE `tracking_history`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `winners`
--
ALTER TABLE `winners`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `tracking_history`
--
ALTER TABLE `tracking_history`
  ADD CONSTRAINT `tracking_history_ibfk_1` FOREIGN KEY (`shipment_id`) REFERENCES `shipments` (`id`) ON DELETE CASCADE;
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 */;
