Ferreteria/v0.5/sql/user account
< Ferreteria | v0.5 | sql(Redirected from Ferreteria/v0.5/login/data/account)
Jump to navigation
Jump to search
This table is used by the login system.
History
- 2022-03-17 (Note) I feel like "UserName" is ambiguous. Maybe "AcctName"? "LoginName"?
- 2022-03-23 Changed "UserName" to "LoginSlug". Added "WhenLogin", "WhenUsed', "WhenLogout".
SQL
CREATE TABLE `user_account` (
`ID` int NOT NULL AUTO_INCREMENT,
`LoginSlug` varchar(31) NOT NULL COMMENT 'log in ID',
`FullName` varchar(127) DEFAULT NULL COMMENT 'optional ''real'' name',
`PassHash` varbinary(128) NOT NULL COMMENT 'hash for [password+salt]',
`PassSalt` varbinary(128) NOT NULL COMMENT 'random prefix for hashing password',
`EmailAddr` varchar(255) NOT NULL COMMENT 'email address',
`WhenCreated` datetime NOT NULL COMMENT 'when user was created',
`WhenLogin` datetime DEFAULT NULL COMMENT 'time of last successful login',
`WhenUsed` datetime DEFAULT NULL COMMENT 'time when account was last accessed',
`WhenLogout` datetime DEFAULT NULL COMMENT 'time of last explicit logout'
PRIMARY KEY (`ID`),
UNIQUE KEY `LoginSlug` (`LoginSlug`)
) ENGINE=InnoDB;