From 62c044899eb293de99004499b48cc9f84f8a98e0 Mon Sep 17 00:00:00 2001 From: danyonsewell Date: Thu, 12 Oct 2023 02:21:10 +0000 Subject: [PATCH] Bug 22188: updating kohastructure.sql to include creation of pubdatepatternformat field Sponsored-by: Auckland University of Technology --- installer/data/mysql/kohastructure.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 9c1b45ac45..1116728709 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -5535,6 +5535,7 @@ CREATE TABLE `subscription` ( `itemtype` varchar(10) DEFAULT NULL, `previousitemtype` varchar(10) DEFAULT NULL, `mana_id` int(11) DEFAULT NULL, + `pubdatepatternformat` varchar(3) DEFAULT NULL, `ccode` varchar(80) DEFAULT NULL COMMENT 'collection code to assign to serial items', `published_on_template` TEXT DEFAULT NULL COMMENT 'Template Toolkit syntax to generate the default "Published on (text)" field when receiving an issue this serial', PRIMARY KEY (`subscriptionid`), -- 2.30.2