| commit | 13cf0cd109772eabd750d4d0bf322beb19e3bc12 | [log] [tgz] |
|---|---|---|
| author | Adrià Vilanova Martínez <me@avm99963.com> | Sun Nov 20 01:02:20 2022 +0100 |
| committer | Adrià Vilanova Martínez <me@avm99963.com> | Sun Nov 20 01:02:20 2022 +0100 |
| tree | 89af6f70df0612e4b1c1154aa2069f6fb9df13ee | |
| parent | d3394e1accae91a2624805e4b08012483d99341f [diff] [blame] |
Improve security Change-Id: Ia98bb629c8c81f609d3a5e4d023616a95f9c4248
diff --git a/db/missatges.sql b/db/missatges.sql new file mode 100644 index 0000000..3769cc1 --- /dev/null +++ b/db/missatges.sql
@@ -0,0 +1,8 @@ +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 +);