DROP TABLE IF EXISTS `change_re_products`;
CREATE TABLE `change_re_products` (
                                      `id` int NOT NULL AUTO_INCREMENT,
                                      `change_id` int NOT NULL,
                                      `product_id` int NOT NULL,
                                      `order_id` int NOT NULL,
                                      `product_name` varchar(50) NOT NULL,
                                      `price` decimal(15,4) NOT NULL,
                                      `count` int NOT NULL,
                                      `user_id` int NOT NULL,
                                      `customer_id` int NOT NULL,
                                      `name` varchar(50) NOT NULL,
                                      `surname` varchar(50) NOT NULL,
                                      `options` varchar(50) NOT NULL,
                                      `description` varchar(150) NOT NULL,
                                      `other` varchar(200) NOT NULL,
                                      `product_status` tinyint(1) NOT NULL,
                                      `order_status_id` int NOT NULL,
                                      `status` tinyint(1) NOT NULL,
                                      `shop_id` int NOT NULL,
                                      PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;