From ce1f5d14d7eb1a7bc90b812840e2664bab5d6722 Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Fri, 26 Aug 2011 19:23:12 -0400 Subject: [PATCH] Bug 6716 - Document the systempreferences table This patch defines the systempreferences table. Some of the fields aren't actually used anymore with the new system preference editor, but have been documented anyway. Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index d4518911f8..7d097febbc 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1867,12 +1867,12 @@ CREATE TABLE `suggestions` ( -- DROP TABLE IF EXISTS `systempreferences`; -CREATE TABLE `systempreferences` ( - `variable` varchar(50) NOT NULL default '', - `value` text, - `options` mediumtext, - `explanation` text, - `type` varchar(20) default NULL, +CREATE TABLE `systempreferences` ( -- global system preferences + `variable` varchar(50) NOT NULL default '', -- system preference name + `value` text, -- system preference values + `options` mediumtext, -- options for multiple choice system preferences + `explanation` text, -- descriptive text for the system preference + `type` varchar(20) default NULL, -- type of question this preference asks (multiple choice, plain text, yes or no, etc) PRIMARY KEY (`variable`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.39.2