From ad99117a15062a3819dad1f52a072e9694a954df Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Wed, 11 Apr 2018 21:34:14 +0300
Subject: server: last read marker for threads

---
 juick-server-jdbc/src/main/resources/schema.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'juick-server-jdbc/src/main/resources/schema.sql')

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`)
 );
 
-- 
cgit v1.2.3

