Ferreteria/v0.5/sql/user account: Difference between revisions
< Ferreteria | v0.5 | sql
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
==History== | ==History== | ||
* '''2022-03-17''' (Note) I feel like "UserName" is ambiguous. Maybe "AcctName"? "LoginName"? | * '''2022-03-17''' (Note) I feel like "UserName" is ambiguous. Maybe "AcctName"? "LoginName"? | ||
* '''2022-03-23''' Changed "UserName" to " | * '''2022-03-23''' Changed "UserName" to "LoginSlug". Added "WhenLogin" and "WhenLogout". | ||
==SQL== | ==SQL== | ||
<syntaxhighlight lang=mysql> | <syntaxhighlight lang=mysql> | ||
CREATE TABLE `user_account` ( | CREATE TABLE `user_account` ( | ||
`ID` int NOT NULL AUTO_INCREMENT, | `ID` int NOT NULL AUTO_INCREMENT, | ||
` | `LoginSlug` varchar(31) NOT NULL COMMENT 'log in ID', | ||
`FullName` varchar(127) DEFAULT NULL COMMENT 'optional ''real'' name', | `FullName` varchar(127) DEFAULT NULL COMMENT 'optional ''real'' name', | ||
`PassHash` varbinary(128) NOT NULL COMMENT 'hash for [password+salt]', | `PassHash` varbinary(128) NOT NULL COMMENT 'hash for [password+salt]', | ||
| Line 15: | Line 15: | ||
`WhenLogout` datetime DEFAULT NULL COMMENT 'time of last explicit logout' | `WhenLogout` datetime DEFAULT NULL COMMENT 'time of last explicit logout' | ||
PRIMARY KEY (`ID`), | PRIMARY KEY (`ID`), | ||
UNIQUE KEY ` | UNIQUE KEY `LoginSlug` (`LoginSlug`) | ||
) ENGINE=InnoDB; | ) ENGINE=InnoDB; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 14:36, 23 March 2022
History
- 2022-03-17 (Note) I feel like "UserName" is ambiguous. Maybe "AcctName"? "LoginName"?
- 2022-03-23 Changed "UserName" to "LoginSlug". Added "WhenLogin" and "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',
`WhenLogout` datetime DEFAULT NULL COMMENT 'time of last explicit logout'
PRIMARY KEY (`ID`),
UNIQUE KEY `LoginSlug` (`LoginSlug`)
) ENGINE=InnoDB;