Bugzilla – Attachment 46319 Details for
Bug 12375
Store serials enumeration data in separate fields
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 12375 - Add new serial fields to kohastructure
Bug-12375---Add-new-serial-fields-to-kohastructure.patch (text/plain), 1.37 KB, created by
Kyle M Hall (khall)
on 2016-01-06 12:18:00 UTC
(
hide
)
Description:
Bug 12375 - Add new serial fields to kohastructure
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2016-01-06 12:18:00 UTC
Size:
1.37 KB
patch
obsolete
>From 078c262b7e71439b18f3a14740f02c26f860a348 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Wed, 6 Jan 2016 12:17:22 +0000 >Subject: [PATCH] Bug 12375 - Add new serial fields to kohastructure > >--- > installer/data/mysql/kohastructure.sql | 3 +++ > 1 file changed, 3 insertions(+) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 02725fd..431a541 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1958,6 +1958,9 @@ CREATE TABLE `serial` ( -- issues related to subscriptions > `biblionumber` varchar(100) NOT NULL default '', -- foreign key for the biblio.biblionumber that this issue is attached to > `subscriptionid` varchar(100) NOT NULL default '', -- foreign key to the subscription.subscriptionid that this issue is part of > `serialseq` varchar(100) NOT NULL default '', -- issue information (volume, number, etc) >+ `serialseq_x` varchar( 100 ) NULL DEFAULT NULL, -- first part of issue information >+ `serialseq_y` varchar( 100 ) NULL DEFAULT NULL, -- second part of issue information >+ `serialseq_z` varchar( 100 ) NULL DEFAULT NULL, -- third part of issue information > `status` tinyint(4) NOT NULL default 0, -- status code for this issue (see manual for full descriptions) > `planneddate` date default NULL, -- date expected > `notes` text, -- notes >-- >2.1.4
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 12375
:
28675
|
28676
|
28677
|
28678
|
28679
|
28680
|
28681
|
28682
|
28683
|
28843
|
28844
|
28845
|
28846
|
29928
|
29929
|
30099
|
30100
|
30101
|
30102
|
30103
|
30104
|
30108
|
35155
|
35156
|
35157
|
35158
|
35159
|
35160
|
35161
|
40710
|
40711
|
40712
|
40713
|
40714
|
40715
|
40716
|
46122
|
46123
|
46124
|
46125
|
46126
|
46127
|
46128
| 46319