| Adrià Vilanova MartÃnez | 13cf0cd | 2022-11-20 01:02:20 +0100 | [diff] [blame^] | 1 | CREATE TABLE missatges ( |
| 2 | `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, | ||||
| 3 | `sender_id` int(11) NOT NULL, | ||||
| 4 | `receiver_id` int(11) NOT NULL, | ||||
| 5 | `timestamp` timestamp NOT NULL DEFAULT current_timestamp(), | ||||
| 6 | `content` text NOT NULL, | ||||
| 7 | `seen` tinyint(1) DEFAULT 0 | ||||
| 8 | ); | ||||