DROP TABLE IF EXISTS `sales_ships`;
CREATE TABLE `sales_ships` (
                               `id` int NOT NULL AUTO_INCREMENT,
                               `user_id` int NOT NULL,
                               `sales_id` int NOT NULL,
                               `brand_id` int NOT NULL,
                               `code` varchar(50) NOT NULL,
                               `price` decimal(15,6) NOT NULL,
                               `total` decimal(15,6) NOT NULL,
                               `title` varchar(150) NOT NULL,
                               `tax` decimal(15,6) NOT NULL,
                               `tax_id` int NOT NULL,
                               `sale_status_id` int NOT NULL,
                               `ship_status` tinyint(1) NOT NULL,
                               `ship_code` varchar(50) NOT NULL,
                               `insert_date` datetime NOT NULL,
                               PRIMARY KEY (`id`),
                               KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;