From f22431c2a1415627c9155ee52b5a19ecef01e9ed 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 Signed-off-by: Jonathan Druart Signed-off-by: Galen Charlton --- installer/data/mysql/kohastructure.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index b1dcf34066..140c5d8455 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 -- 2.11.0