From 508c46d1bcf1826a7252465b83f2f66eb9532f1b Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Sun, 14 Aug 2011 13:49:11 -0400 Subject: [PATCH] Bug 6716 - Deleted Biblio Table This patch documents the deletedbiblio table, with the exception of the seriestitle field which I could not find an example of. Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 24 ++++++++++++------------ 1 file changed, 12 insertions(+), 12 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 408f1f9e2c..03efc4e5b5 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -582,19 +582,19 @@ CREATE TABLE `currency` ( -- DROP TABLE IF EXISTS `deletedbiblio`; -CREATE TABLE `deletedbiblio` ( - `biblionumber` int(11) NOT NULL default 0, - `frameworkcode` varchar(4) NOT NULL default '', - `author` mediumtext, - `title` mediumtext, - `unititle` mediumtext, - `notes` mediumtext, - `serial` tinyint(1) default NULL, +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 (|) + `serial` tinyint(1) default NULL, -- foreign key, linking to the subscriptionid in the serial table `seriestitle` mediumtext, - `copyrightdate` smallint(6) default NULL, - `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, - `datecreated` DATE NOT NULL, - `abstract` 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) PRIMARY KEY (`biblionumber`), KEY `blbnoidx` (`biblionumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.39.2