From 078c262b7e71439b18f3a14740f02c26f860a348 Mon Sep 17 00:00:00 2001 From: Kyle M Hall 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