diff options
author | M <m@lfurio.us> | 2015-11-19 22:33:02 -0500 |
---|---|---|
committer | M <m@lfurio.us> | 2015-11-19 22:33:02 -0500 |
commit | fbb58c515142d55de72ae61b504596bea97d0f67 (patch) | |
tree | 2cf1916ef7260665a0712bab70bfffa7c1d1116c /schema.sql | |
parent | b1c0e57c8a1ccb9074cc5eecc64464aaece26973 (diff) | |
download | scrott-fbb58c515142d55de72ae61b504596bea97d0f67.tar.gz scrott-fbb58c515142d55de72ae61b504596bea97d0f67.zip |
* Data schema errata
Diffstat (limited to '')
-rw-r--r-- | schema.sql | 7 |
1 files changed, 7 insertions, 0 deletions
@@ -42,6 +42,8 @@ CREATE TABLE `object` ( `owner` varchar(10) NOT NULL, `parent` varchar(10) DEFAULT NULL, `name` varchar(50) NOT NULL, + `timeCreated` datetime NOT NULL, + `timeUpdated` datetime NOT NULL, `type` enum( 'user', 'group', @@ -61,12 +63,17 @@ CREATE TABLE `obj_member` ( ); /* User objects - special attributes */ +/* Notice: 'timeUpdated' field should be used to store the time of the start of the user's current session */ +/* Notice: 'key' field is the user's hashed and salted password -- SHA256 */ +/* Notice: 'salt' is a random SHA256 output, used as salt for user's password */ DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `guid` varchar(10) NOT NULL, `key` varchar(64) NOT NULL, `salt` varchar(64) NOT NULL, `alias` varchar(50) DEFAULT NULL, + `email` varchar(50) DEFAULT NULL, + `emailConf` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`) ); |