From c21fd2a98334c07dbd738507227d2f62b2245596 Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Thu, 27 Sep 2012 00:55:32 -0400 Subject: [PATCH] Bug 6716: Update biblioitems tables This patch documents the cn_sort and agerestriction fields in the biblioitems and deletedbiblioitems tables. Signed-off-by: Paul Poulain --- installer/data/mysql/kohastructure.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index f864abc3fe..5f6739fee0 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -177,8 +177,8 @@ CREATE TABLE `biblioitems` ( -- information related to bibliographic records in `cn_class` varchar(30) default NULL, `cn_item` varchar(10) default NULL, `cn_suffix` varchar(10) default NULL, - `cn_sort` varchar(30) default NULL, - `agerestriction` varchar(255) default NULL, + `cn_sort` varchar(30) default NULL, -- normalized version of the call number used for sorting + `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) `totalissues` int(10), `marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML PRIMARY KEY (`biblioitemnumber`), @@ -650,8 +650,8 @@ CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t `cn_class` varchar(30) default NULL, `cn_item` varchar(10) default NULL, `cn_suffix` varchar(10) default NULL, - `cn_sort` varchar(30) default NULL, - `agerestriction` varchar(255) default NULL, + `cn_sort` varchar(30) default NULL, -- normalized version of the call number used for sorting + `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a) `totalissues` int(10), `marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML PRIMARY KEY (`biblioitemnumber`), -- 2.39.2