From 0aa64b3201df580918ba496e3df65f0b7dfdd41f Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Sun, 15 Apr 2018 19:47:53 +0000
Subject: update mysql schema

---
 juick-server-jdbc/src/main/resources/juick.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

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

diff --git a/juick-server-jdbc/src/main/resources/juick.sql b/juick-server-jdbc/src/main/resources/juick.sql
index e652cc19..d13a06a2 100644
--- a/juick-server-jdbc/src/main/resources/juick.sql
+++ b/juick-server-jdbc/src/main/resources/juick.sql
@@ -786,7 +786,7 @@ CREATE TABLE `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 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',
@@ -914,4 +914,4 @@ CREATE TABLE `wl_users` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2018-04-12 18:17:04
+-- Dump completed on 2018-04-15 19:47:16
-- 
cgit v1.2.3