aboutsummaryrefslogtreecommitdiff
path: root/juick-server-jdbc/src/main/resources/schema.sql
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2018-04-15 22:11:41 +0300
committerGravatar Vitaly Takmazov2018-04-15 22:11:41 +0300
commit312a462685fce047d4712780ae46f2b910f5d057 (patch)
treebdb37547a6a3d8fc1976f3c9435de26b24310482 /juick-server-jdbc/src/main/resources/schema.sql
parentfa9788960e934d9b78e5968eb2c384254218090a (diff)
jdbc: update lastmessage user column
Diffstat (limited to 'juick-server-jdbc/src/main/resources/schema.sql')
-rw-r--r--juick-server-jdbc/src/main/resources/schema.sql2
1 files changed, 1 insertions, 1 deletions
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',