diff options
Diffstat (limited to '')
| -rw-r--r-- | schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
@@ -47,7 +47,7 @@ DROP TABLE IF EXISTS `object`; CREATE TABLE `object` ( `guid` varchar(10) NOT NULL, `perms` int(10) unsigned NOT NULL DEFAULT 0, - `owner` varchar(10) NOT NULL, + `owner` varchar(10) DEFAULT NULL, `parent` varchar(10) DEFAULT NULL, `name` varchar(50) NOT NULL, `timeCreated` datetime NOT NULL, @@ -86,7 +86,6 @@ CREATE TABLE `msg_read` ( ); /* 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`; @@ -95,6 +94,7 @@ CREATE TABLE `user` ( `key` varchar(64) NOT NULL, `salt` varchar(64) NOT NULL, `alias` varchar(50) DEFAULT NULL, + `admin` int(10) unsigned NOT NULL DEFAULT 0, `email` varchar(50) DEFAULT NULL, `emailConf` int(10) unsigned NOT NULL DEFAULT 0, `emailConfKey` varchar(64) NOT NULL, |