DROP TABLE IF EXISTS `sales_totals`;
CREATE TABLE `sales_totals` (
                                `id` int NOT NULL AUTO_INCREMENT,
                                `sales_id` int NOT NULL,
                                `array_index` int NOT NULL,
                                `code` varchar(50) NOT NULL,
                                `title` varchar(100) NOT NULL,
                                `price` decimal(15,4) NOT NULL,
                                `price_text` varchar(50) NOT NULL,
                                `text_code` varchar(50) NOT NULL,
                                `date_added` datetime DEFAULT NULL,
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;