DROP TABLE IF EXISTS `tracking_details`;
CREATE TABLE `tracking_details` (
    `id` INT(10) unsigned NOT NULL AUTO_INCREMENT,
    `tracking` TEXT NOT NULL,
    `shipping_details_id` INT(10) unsigned NOT NULL,
    `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP NULL DEFAULT NULL,
    `deleted_at` TIMESTAMP NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `shipping_details_id` (`shipping_details_id`),
    CONSTRAINT `tracking_details_ibfk_shipping_details` FOREIGN KEY (`shipping_details_id`) REFERENCES `shipping_details` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;