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 4824-4829 CREATE TABLE `subscription` ( Link Here
4824
  `itemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
4824
  `itemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
4825
  `previousitemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
4825
  `previousitemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
4826
  `mana_id` int(11) DEFAULT NULL,
4826
  `mana_id` int(11) DEFAULT NULL,
4827
  `ccode` varchar(80) DEFAULT NULL COMMENT 'collection code to assign to serial items',
4827
  PRIMARY KEY (`subscriptionid`),
4828
  PRIMARY KEY (`subscriptionid`),
4828
  KEY `subscription_ibfk_1` (`periodicity`),
4829
  KEY `subscription_ibfk_1` (`periodicity`),
4829
  KEY `subscription_ibfk_2` (`numberpattern`),
4830
  KEY `subscription_ibfk_2` (`numberpattern`),
4830
- 

Return to bug 23352