DROP TABLE IF EXISTS `voucher`;
CREATE TABLE `voucher` (
                           `id` int NOT NULL AUTO_INCREMENT,
                           `order_id` int NOT NULL,
                           `code` varchar(10) NOT NULL,
                           `from_name` varchar(64) NOT NULL,
                           `from_email` varchar(96) NOT NULL,
                           `to_name` varchar(64) NOT NULL,
                           `to_email` varchar(96) NOT NULL,
                           `voucher_theme_id` int NOT NULL,
                           `message` text NOT NULL,
                           `amount` decimal(15,4) NOT NULL,
                           `status` tinyint(1) NOT NULL,
                           `date_added` datetime NOT NULL,
                           `shop_id` int NOT NULL,
                           PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;