diff options
| author | Malf Furious <m@lfurio.us> | 2016-02-07 14:01:22 -0500 |
|---|---|---|
| committer | Malf Furious <m@lfurio.us> | 2016-02-07 14:01:22 -0500 |
| commit | 72e37180b69db2c067b926b54c64e1989bef0be4 (patch) | |
| tree | d5e76f4894d3822f1923464c641c63fa283bdd2b /schema.sql | |
| parent | 43ca317ea7d49396eb2958a38aed8b737ef4186b (diff) | |
| parent | c5564a0a2ae183c533a38905eccdbf383030cd4c (diff) | |
| download | scrott-72e37180b69db2c067b926b54c64e1989bef0be4.tar.gz scrott-72e37180b69db2c067b926b54c64e1989bef0be4.zip | |
Merge branch 'auth' into dev
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, |