This is one of many patches that will document the MySQL table structure for Koha. This patch adds comments to the authorised_values table.
Signed-off-by: Nicole C. Engard <[email protected]> --- installer/data/mysql/kohastructure.sql | 14 +++++++------- 1 files changed, 7 insertions(+), 7 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e9edf25..770ca34 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -95,13 +95,13 @@ CREATE TABLE `auth_types` ( -- DROP TABLE IF EXISTS `authorised_values`; -CREATE TABLE `authorised_values` ( - `id` int(11) NOT NULL auto_increment, - `category` varchar(10) NOT NULL default '', - `authorised_value` varchar(80) NOT NULL default '', - `lib` varchar(80) default NULL, - `lib_opac` VARCHAR(80) default NULL, - `imageurl` varchar(200) default NULL, +CREATE TABLE `authorised_values` ( -- stores values for authorized values categories and values + `id` int(11) NOT NULL auto_increment, -- unique key, used to identify the authorized value + `category` varchar(10) NOT NULL default '', -- key used to identify the authorized value category + `authorised_value` varchar(80) NOT NULL default '', -- code use to identify the authorized value + `lib` varchar(80) default NULL, -- authorized value description as printed in the staff client + `lib_opac` VARCHAR(80) default NULL, -- authorized value description as printed in the OPAC + `imageurl` varchar(200) default NULL, -- authorized value URL PRIMARY KEY (`id`), KEY `name` (`category`), KEY `lib` (`lib`), -- 1.7.2.3 _______________________________________________ Koha-patches mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
