DROP TABLE IF EXISTS `news_letter`;
CREATE TABLE `news_letter` (
                               `id` int NOT NULL AUTO_INCREMENT,
                               `telephone` varchar(15) NOT NULL,
                               `email` varchar(50) NOT NULL,
                               `customer_id` int NOT NULL,
                               `status` tinyint(1) NOT NULL,
                               `date_added` datetime NOT NULL,
                               `date_edit` datetime NOT NULL,
                               `shop_id` int NOT NULL DEFAULT '1',
                               PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;