DROP TABLE IF EXISTS `support`;
CREATE TABLE `support` (
                           `id` int NOT NULL AUTO_INCREMENT,
                           `subject` varchar(150) NOT NULL,
                           `message` varchar(150) NOT NULL,
                           `support_status` varchar(50) NOT NULL,
                           `user_id` int NOT NULL,
                           `sender_user_id` int NOT NULL,
                           `receiver_user_id` int NOT NULL,
                           `urgency` varchar(50) NOT NULL,
                           `status` tinyint(1) NOT NULL,
                           `date_added` datetime NOT NULL,
                           `date_edit` datetime NOT NULL,
                           `shop_id` int NOT NULL DEFAULT '1',
                           `sender_deleted` tinyint(1) NOT NULL DEFAULT '0',
                           `receiver_deleted` tinyint(1) NOT NULL DEFAULT '0',
                           `message_id` int NOT NULL,
                           PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;