DROP TABLE IF EXISTS `mailing`;
CREATE TABLE `mailing` (
                           `id` int NOT NULL,
                           `sender` varchar(250) NOT NULL,
                           `content` varchar(150) NOT NULL,
                           `subject` varchar(150) NOT NULL,
                           `status` tinyint(1) NOT NULL,
                           `readed` tinyint(1) NOT NULL DEFAULT '0',
                           `delivery_date` datetime NOT NULL,
                           `read_date` datetime NOT NULL,
                           `shop_id` int NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;