summaryrefslogtreecommitdiffstats
path: root/schema.sql
diff options
context:
space:
mode:
authorM <m@lfurio.us>2015-11-19 22:33:02 -0500
committerM <m@lfurio.us>2015-11-19 22:33:02 -0500
commitfbb58c515142d55de72ae61b504596bea97d0f67 (patch)
tree2cf1916ef7260665a0712bab70bfffa7c1d1116c /schema.sql
parentb1c0e57c8a1ccb9074cc5eecc64464aaece26973 (diff)
downloadscrott-fbb58c515142d55de72ae61b504596bea97d0f67.tar.gz
scrott-fbb58c515142d55de72ae61b504596bea97d0f67.zip
* Data schema errata
Diffstat (limited to '')
-rw-r--r--schema.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/schema.sql b/schema.sql
index 2863cbc..589fafb 100644
--- a/schema.sql
+++ b/schema.sql
@@ -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`)
);