14 Mar
2016
14 Mar
'16
5:09 p.m.
On Mon, 2016-03-14 at 10:12 +0100, Marcel Korpel wrote:
* Lukas Fleischer <lfleischer@archlinux.org> (Sun, 13 Mar 2016 11:49:01 +0100):
- LastLoginIPAddress INTEGER UNSIGNED NOT NULL DEFAULT 0, + LastLoginIPAddress VARCHAR(40) NULL DEFAULT NULL,
VARCHAR(40) is too short, I think, see http://stackoverflow.com/q/166132/258127
According to Linux header files, the maximum length of an IPv6 address is 45 characters.
Regards, Marcel
I'm not 100% sure how this actually stores the address, but if it's stored in its hex form, it can only be as large as 39 characters (4*8+7) making 40 characters more than enough. Mark Weiman