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