@@ -, +, @@ --- .../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 --- a/installer/data/mysql/atomicupdate/bug_23352-add_ccode_column_to_subscriptions_table.pl +++ a/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` + }); + } + }, +} --- a/installer/data/mysql/kohastructure.sql +++ a/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`), --