From 635ceb4808624ad6676d43e83c1ff5a7d4341d36 Mon Sep 17 00:00:00 2001 From: Malf Furious Date: Thu, 28 Jan 2016 19:38:28 -0500 Subject: Add admin field to user table User accounts now have a field to denote whether they are site administrators. The first account created during app initial configuration is an admin automatically. --- schema.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index add1472..44655b7 100644 --- a/schema.sql +++ b/schema.sql @@ -95,6 +95,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, -- cgit v1.2.3 From 86d179fbb5ece5d69184ecd885a2b29818e9a57e Mon Sep 17 00:00:00 2001 From: Malf Furious Date: Sat, 30 Jan 2016 18:12:25 -0500 Subject: Modify database schema and semantics for user objects When user objects are initially created they need to hold a NULL owner value (since users are self-owning objects and prior to db insertion their own guid is not known). Also, the timeUpdated field will no longer hold special meaning for user objects and is now going to be treated as consistent with the rest of the data model. --- schema.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index 44655b7..8902fbf 100644 --- a/schema.sql +++ b/schema.sql @@ -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`; -- cgit v1.2.3