diff options
| author |  Vitaly Takmazov | 2018-04-15 19:47:53 +0000 |
|---|---|---|
| committer | Vitaly Takmazov | 2018-04-15 19:47:53 +0000 |
| commit | 0aa64b3201df580918ba496e3df65f0b7dfdd41f (patch) | |
| tree | ac6230cc8fe23eb6d974efd2c7e08148a306f038 /juick-server-jdbc/src/main/resources | |
| parent | 2844b14f747d93aea3684d570be8d4a002c50ed2 (diff) | |
update mysql schema
Diffstat (limited to 'juick-server-jdbc/src/main/resources')
| -rw-r--r-- | juick-server-jdbc/src/main/resources/juick.sql | 4 |
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 |