From 312a462685fce047d4712780ae46f2b910f5d057 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Sun, 15 Apr 2018 22:11:41 +0300
Subject: jdbc: update lastmessage user column

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

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

diff --git a/juick-server-jdbc/src/main/resources/schema.sql b/juick-server-jdbc/src/main/resources/schema.sql
index 66b4d7ac..ec28a456 100644
--- a/juick-server-jdbc/src/main/resources/schema.sql
+++ b/juick-server-jdbc/src/main/resources/schema.sql
@@ -327,7 +327,7 @@ CREATE TABLE IF NOT EXISTS `users` (
   `passw` char(32) NOT NULL,
   `lang` enum('en','ru','fr','fa','__') NOT NULL DEFAULT '__',
   `banned` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `lastmessage` int(11) NOT NULL DEFAULT '0',
+  `lastmessage` timestamp(9) NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `lastpm` int(11) NOT NULL DEFAULT '0',
   `lastphoto` int(11) NOT NULL DEFAULT '0',
   `karma` smallint(6) NOT NULL DEFAULT '0',
-- 
cgit v1.2.3