From 64eab3eea446cdfc8fbadcd58f5ee3175acebd0b Mon Sep 17 00:00:00 2001 From: Alex Buckley Date: Mon, 13 Dec 2021 13:56:38 +0000 Subject: [PATCH] Bug 23352: Database changes Sponsored-By: Brimbank Library, Australia --- .../bug_23352-add_ccode_column_to_subscriptions_table.pl | 16 ++++++++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 17 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_23352-add_ccode_column_to_subscriptions_table.pl diff --git a/installer/data/mysql/atomicupdate/bug_23352-add_ccode_column_to_subscriptions_table.pl b/installer/data/mysql/atomicupdate/bug_23352-add_ccode_column_to_subscriptions_table.pl new file mode 100644 index 0000000000..a847e502d7 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_23352-add_ccode_column_to_subscriptions_table.pl @@ -0,0 +1,16 @@ +use Modern::Perl; + +{ + bug_number => "23352", + description => "Adding new column 'subscription.ccode'", + up => sub { + my ($args) = @_; + my $dbh = $args->{dbh}; + + if( !column_exists( 'subscription', 'ccode' ) ) { + $dbh->do(q{ + ALTER TABLE subscription ADD COLUMN `ccode` varchar(80) DEFAULT NULL AFTER `mana_id` + }); + } + }, +} diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index a309cea736..ac63fca7e6 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -4824,6 +4824,7 @@ CREATE TABLE `subscription` ( `itemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `previousitemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mana_id` int(11) DEFAULT NULL, + `ccode` varchar(80) DEFAULT NULL COMMENT 'collection code to assign to serial items', PRIMARY KEY (`subscriptionid`), KEY `subscription_ibfk_1` (`periodicity`), KEY `subscription_ibfk_2` (`numberpattern`), -- 2.11.0