From 635ceb4808624ad6676d43e83c1ff5a7d4341d36 Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
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

