[Koha-patches] [PATCH] Bug 6716 - MySQL definition for authorised values table
Nicole C. Engard
nengard at bywatersolutions.com
Sun Aug 14 19:03:19 CEST 2011
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 <nengard at bywatersolutions.com>
---
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
More information about the Koha-patches
mailing list