blob: 3769cc1a7ebe5c71a49aabfcdb2e38d0fe69d851 [file] [log] [blame]
CREATE TABLE missatges (
`id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
`sender_id` int(11) NOT NULL,
`receiver_id` int(11) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
`content` text NOT NULL,
`seen` tinyint(1) DEFAULT 0
);