The comments on the biblio and deletedbiblio table didn't mention the MARC21 subfields. This patch adds that documentation in. --- installer/data/mysql/kohastructure.sql | 20 ++++++++++---------- 1 files changed, 10 insertions(+), 10 deletions(-)
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e4388a4..911ccb2 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -116,16 +116,16 @@ DROP TABLE IF EXISTS `biblio`; CREATE TABLE `biblio` ( -- table that stores bibliographic information `biblionumber` int(11) NOT NULL auto_increment, -- unique identifier assigned to each bibliographic record `frameworkcode` varchar(4) NOT NULL default '', -- foriegn key from the biblio_framework table to identify which framework was used in cataloging this record - `author` mediumtext, -- statement of responsibility from MARC record (100 in MARC21) - `title` mediumtext, -- title (without the subtitle) from the MARC record (245 in MARC21) - `unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240 in MARC21) - `notes` mediumtext, -- values from the general notes field in the MARC record (500 in MARC21) split by bar (|) + `author` mediumtext, -- statement of responsibility from MARC record (100$a in MARC21) + `title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21) + `unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21) + `notes` mediumtext, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) `serial` tinyint(1) default NULL, -- foreign key, linking to the subscriptionid in the serial table `seriestitle` mediumtext, `copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched `datecreated` DATE NOT NULL, -- the date this record was added to Koha - `abstract` mediumtext, -- summary from the MARC record (520 in MARC21) + `abstract` mediumtext, -- summary from the MARC record (520$a in MARC21) PRIMARY KEY (`biblionumber`), KEY `blbnoidx` (`biblionumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; @@ -590,16 +590,16 @@ DROP TABLE IF EXISTS `deletedbiblio`; CREATE TABLE `deletedbiblio` ( -- stores information about bibliographic records that have been deleted `biblionumber` int(11) NOT NULL auto_increment, -- unique identifier assigned to each bibliographic record `frameworkcode` varchar(4) NOT NULL default '', -- foriegn key from the biblio_framework table to identify which framework was used in cataloging this record - `author` mediumtext, -- statement of responsibility from MARC record (100 in MARC21) - `title` mediumtext, -- title (without the subtitle) from the MARC record (245 in MARC21) - `unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240 in MARC21) - `notes` mediumtext, -- values from the general notes field in the MARC record (500 in MARC21) split by bar (|) + `author` mediumtext, -- statement of responsibility from MARC record (100$a in MARC21) + `title` mediumtext, -- title (without the subtitle) from the MARC record (245$a in MARC21) + `unititle` mediumtext, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21) + `notes` mediumtext, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) `serial` tinyint(1) default NULL, -- foreign key, linking to the subscriptionid in the serial table `seriestitle` mediumtext, `copyrightdate` smallint(6) default NULL, -- publication or copyright date from the MARC record `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched `datecreated` DATE NOT NULL, -- the date this record was added to Koha - `abstract` mediumtext, -- summary from the MARC record (520 in MARC21) + `abstract` mediumtext, -- summary from the MARC record (520$a in MARC21) PRIMARY KEY (`biblionumber`), KEY `blbnoidx` (`biblionumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 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/
