DROP TABLE IF EXISTS `invoice_items`;
CREATE TABLE `invoice_items` (
                                 `id` int NOT NULL AUTO_INCREMENT,
                                 `name` varchar(150) NOT NULL,
                                 `barcode` varchar(15) NOT NULL,
                                 `safe_id` int NOT NULL,
                                 `new_price` decimal(15,6) NOT NULL,
                                 `price` decimal(15,6) NOT NULL,
                                 `product_list_id` int NOT NULL,
                                 `quantity` int NOT NULL,
                                 `rate` float NOT NULL,
                                 `total` decimal(15,6) NOT NULL,
                                 `invoice_id` int NOT NULL,
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;