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 4866-4871 CREATE TABLE `subscription` ( Link Here
4866
  `itemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
4866
  `itemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
4867
  `previousitemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
4867
  `previousitemtype` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
4868
  `mana_id` int(11) DEFAULT NULL,
4868
  `mana_id` int(11) DEFAULT NULL,
4869
  `ccode` varchar(80) DEFAULT NULL COMMENT 'collection code to assign to serial items',
4869
  PRIMARY KEY (`subscriptionid`),
4870
  PRIMARY KEY (`subscriptionid`),
4870
  KEY `subscription_ibfk_1` (`periodicity`),
4871
  KEY `subscription_ibfk_1` (`periodicity`),
4871
  KEY `subscription_ibfk_2` (`numberpattern`),
4872
  KEY `subscription_ibfk_2` (`numberpattern`),
4872
- 

Return to bug 23352