db/missatges.sql

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
);