From 1bf95de120d273b96c0d89cc21f9c32f3b2e6851 Mon Sep 17 00:00:00 2001 From: M Date: Fri, 20 Nov 2015 22:57:19 -0500 Subject: + Defined setting table for system-wide administrator settings --- schema.sql | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index 2171cde..add1472 100644 --- a/schema.sql +++ b/schema.sql @@ -34,6 +34,14 @@ USE `db_scrott`; * Permissions can be overridden down-stream, but permissions will cascade otherwise. */ +/* System-wide admin settings */ +DROP TABLE IF EXISTS `setting`; +CREATE TABLE `setting` ( + `key` varchar(50) NOT NULL, + `value` varchar(50) DEFAULT NULL, + PRIMARY KEY (`key`) +); + /* Common object structure attributes */ DROP TABLE IF EXISTS `object`; CREATE TABLE `object` ( -- cgit v1.2.3