aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2018-04-15 19:47:53 +0000
committerGravatar Vitaly Takmazov2018-04-15 19:47:53 +0000
commit0aa64b3201df580918ba496e3df65f0b7dfdd41f (patch)
treeac6230cc8fe23eb6d974efd2c7e08148a306f038
parent2844b14f747d93aea3684d570be8d4a002c50ed2 (diff)
update mysql schema
-rw-r--r--juick-server-jdbc/src/main/resources/juick.sql4
1 files changed, 2 insertions, 2 deletions
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