diff options
| author |  Vitaly Takmazov | 2018-04-11 21:34:14 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2018-04-11 21:34:14 +0300 |
| commit | ad99117a15062a3819dad1f52a072e9694a954df (patch) | |
| tree | 61b47950cca3adba91ef4f7c8ce80c1a1f8a531f /juick-server-jdbc/src/main/resources/schema.sql | |
| parent | 47254ab8555162bc121c7b618fff42fc64b9454c (diff) | |
server: last read marker for threads
Diffstat (limited to 'juick-server-jdbc/src/main/resources/schema.sql')
| -rw-r--r-- | juick-server-jdbc/src/main/resources/schema.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/juick-server-jdbc/src/main/resources/schema.sql b/juick-server-jdbc/src/main/resources/schema.sql index 544b4e51..66b4d7ac 100644 --- a/juick-server-jdbc/src/main/resources/schema.sql +++ b/juick-server-jdbc/src/main/resources/schema.sql @@ -227,6 +227,7 @@ CREATE TABLE IF NOT EXISTS `replies` ( CREATE TABLE IF NOT EXISTS `subscr_messages` ( `message_id` int(10) unsigned NOT NULL, `suser_id` int(10) unsigned NOT NULL, + `last_read_rid` smallint(5) unsigned NOT NULL DEFAULT '0', UNIQUE KEY (`message_id`,`suser_id`) ); |