aboutsummaryrefslogtreecommitdiff
path: root/juick-server-jdbc/src/main/resources
diff options
context:
space:
mode:
Diffstat (limited to 'juick-server-jdbc/src/main/resources')
-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',