From c81b0a2ca59bd7254b66ca0256225c88436b3cab 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 (cherry picked from commit f22431c2a1415627c9155ee52b5a19ecef01e9ed) Signed-off-by: Tomas Cohen Arazi --- 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 2e1f1b7f11..7af3d1a84d 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -120,7 +120,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 @@ -607,7 +607,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.39.5