Bugzilla – Attachment 22109 Details for
Bug 10889
wrong description for a column of biblio table in kohastructure.sql
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 10889: fix comment describing biblioitems.serial
Bug-10889-fix-comment-describing-biblioitemsserial.patch (text/plain), 2.50 KB, created by
Joy Nelson
on 2013-10-20 20:50:11 UTC
(
hide
)
Description:
Bug 10889: fix comment describing biblioitems.serial
Filename:
MIME Type:
Creator:
Joy Nelson
Created:
2013-10-20 20:50:11 UTC
Size:
2.50 KB
patch
obsolete
>From 5047252d149442379e05a679ff36097f19aedfc6 Mon Sep 17 00:00:00 2001 >From: Galen Charlton <gmc@esilibrary.com> >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 <gmc@esilibrary.com> >Signed-off-by: Joy Nelson <joy@bywatersolutions.com> >--- > 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 10889
:
22083
|
22109
|
22312