DfBNvYxG

1CREATE TABLE IF NOT EXISTS `messages` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `senderId` int(11) NOT NULL DEFAULT '0',
4  `receiverId` int(11) NOT NULL DEFAULT '0',
5  `message` TEXT DEFAULT NULL,
6  `createdAt` datetime NOT NULL,
7  `updatedAt` datetime NOT NULL,
8  `seenAt` datetime NULL,
9  PRIMARY KEY (`id`,`senderId`,`receiverId`),
10  CONSTRAINT `messages_ibfk_1` FOREIGN KEY (`senderId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
11  CONSTRAINT `messages_ibfk_2` FOREIGN KEY (`receiverId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
12);