Arkania / ArkCORE-NG

Cataclysm 4.3.4 emulator.. with archeology..
http://gpn39f.spdns.de/forum1/
GNU General Public License v2.0
71 stars 93 forks source link

Invalid Default Value for LastLogin #246

Open knuxyl opened 7 years ago

knuxyl commented 7 years ago

/base/auth.sql line 27 last_login timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',

This is an invalid default type for column type "timestamp". The correct default value for MySQL 5.5 for column type "timestamp" should be "CURRENT_TIMESTAMP" and for MySQL 5.6+ "CURRENT_TIMESTAMP" is the default value for both "timestamp" and "datetime"