datatypes for users table fields [created_on], [last_login] are incorrect

[mah0001]

The data type for the created_on and last_login fields are incorrect. As a result, when you create a new user or login, the fields does not get updated.

The datatype should be INT or something else instead of the mediumint.

See (http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html).

mediumint(11): 11 is not the number of digits you can save in the field. 11 is number of digits that will be displayed. so having mediumint(2) or mediumint(8) or mediumint(11) does not make any difference to the storage capacity.

//from mysql install
created_on mediumint(11) unsigned NOT NULL,
last_login mediumint(11) unsigned NOT NULL,
active int(1) unsigned DEFAULT NULL,

//should be changed to:
created_on int unsigned NOT NULL,
last_login int unsigned NOT NULL,
active tinyint unsigned DEFAULT NULL,

[benedmunds]

Fixed. Thank you for testing!