+ Defined setting table for system-wide administrator settings

1 files changed, 8 insertions, 0 deletions

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` (