summaryrefslogtreecommitdiffstats
path: root/schema.sql
diff options
context:
space:
mode:
authorMalf Furious <m@lfurio.us>2016-01-28 19:38:28 -0500
committerMalf Furious <m@lfurio.us>2016-01-28 19:38:28 -0500
commit635ceb4808624ad6676d43e83c1ff5a7d4341d36 (patch)
treecef9da19d9f6e6481cbe84c4ca50a4d0604d5e5f /schema.sql
parent67fb3eeb6d788b6f58d589757285a0e72a5ea3aa (diff)
downloadscrott-635ceb4808624ad6676d43e83c1ff5a7d4341d36.tar.gz
scrott-635ceb4808624ad6676d43e83c1ff5a7d4341d36.zip
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.
Diffstat (limited to '')
-rw-r--r--schema.sql1
1 files changed, 1 insertions, 0 deletions
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,