diff options
| author |  Vitaly Takmazov | 2018-04-15 22:11:41 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2018-04-15 22:11:41 +0300 |
| commit | 312a462685fce047d4712780ae46f2b910f5d057 (patch) | |
| tree | bdb37547a6a3d8fc1976f3c9435de26b24310482 /juick-server-jdbc/src/main/resources | |
| parent | fa9788960e934d9b78e5968eb2c384254218090a (diff) | |
jdbc: update lastmessage user column
Diffstat (limited to 'juick-server-jdbc/src/main/resources')
| -rw-r--r-- | juick-server-jdbc/src/main/resources/schema.sql | 2 |
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', |