From 5047252d149442379e05a679ff36097f19aedfc6 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Sun, 20 Oct 2013 17:43:12 +0000 Subject: [PATCH] Bug 10889: fix comment describing biblioitems.serial biblioitems.serial is not a foreign key; it's a Boolean indicating whether the biblio record is a serial, which in turn influences how serial items are displayed. Signed-off-by: Galen Charlton Signed-off-by: Joy Nelson --- installer/data/mysql/kohastructure.sql | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e1e3e96..a4a3209 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -121,7 +121,7 @@ CREATE TABLE `biblio` ( -- table that stores bibliographic information `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 + `serial` tinyint(1) default NULL, -- Boolean indicating whether biblio is for a serial `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 @@ -710,7 +710,7 @@ CREATE TABLE `deletedbiblio` ( -- stores information about bibliographic records `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 + `serial` tinyint(1) default NULL, -- Boolean indicating whether biblio is for a serial `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 -- 1.7.2.5