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.

2 files changed, 2 insertions, 0 deletions

diff --git a/app/class/user.class.php b/app/class/user.class.php
index 6004dc9..9a87b01 100644
--- a/app/class/user.class.php
+++ b/app/class/user.class.php
@@ -17,6 +17,7 @@ class User extends Object
             "key",
             "salt",
             "alias",
+            "admin",
             "email",
             "emailConf",
             "emailConfKey"
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,