DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages` (
                            `id` int NOT NULL AUTO_INCREMENT,
                            `sender_user_id` int NOT NULL,
                            `receiver_user_id` int NOT NULL,
                            `subject` varchar(255) NOT NULL,
                            `department_id` int NOT NULL,
                            `status` int NOT NULL COMMENT '0-beklemede,1- okundu, 2- cevaplandı',
                            `insert_date` datetime NOT NULL,
                            `update_date` datetime NOT NULL,
                            PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;