View | Details | Raw Unified | Return to bug 23352
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_23352-add_ccode_column_to_subscriptions_table.pl (+16 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
{
4
    bug_number => "23352",
5
    description => "Adding new column 'subscription.ccode'",
6
    up => sub {
7
        my ($args) = @_;
8
        my $dbh = $args->{dbh};
9
10
        if( !column_exists( 'subscription', 'ccode' ) ) {
11
          $dbh->do(q{
12
              ALTER TABLE subscription ADD COLUMN `ccode` varchar(80) DEFAULT NULL AFTER `mana_id`
13
          });
14
        }
15
    },
16
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 4829-4834 CREATE TABLE `subscription` ( Link Here
4829
  `itemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
4829
  `itemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
4830
  `previousitemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
4830
  `previousitemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
4831
  `mana_id` int(11) DEFAULT NULL,
4831
  `mana_id` int(11) DEFAULT NULL,
4832
  `ccode` varchar(80) DEFAULT NULL COMMENT 'collection code to assign to serial items',
4832
  PRIMARY KEY (`subscriptionid`),
4833
  PRIMARY KEY (`subscriptionid`),
4833
  KEY `subscription_ibfk_1` (`periodicity`),
4834
  KEY `subscription_ibfk_1` (`periodicity`),
4834
  KEY `subscription_ibfk_2` (`numberpattern`),
4835
  KEY `subscription_ibfk_2` (`numberpattern`),
4835
- 

Return to bug 23352