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

(-)a/installer/data/mysql/atomicupdate/bug_39518-add_basket_name_field.pl (+18 lines)
Line 0 Link Here
1
use Modern::Perl;
2
use Koha::Installer::Output qw(say_warning say_success say_info);
3
4
return {
5
    bug_number  => "39518",
6
    description => "Add a field to define the basket name in the MARC order account for a vendor",
7
    up          => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        # Do you stuffs here
12
        $dbh->do(
13
            q{ ALTER TABLE marc_order_accounts ADD COLUMN `basket_name_field` varchar(10) DEFAULT NULL COMMENT 'the field that a vendor can use to include a basket name that will be used to create the basket for the file' AFTER match_value}
14
        );
15
16
        say_success( $out, "Basket name field added successfully" );
17
    },
18
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 4584-4589 CREATE TABLE `marc_order_accounts` ( Link Here
4584
  `encoding` varchar(50) DEFAULT NULL COMMENT 'file encoding',
4584
  `encoding` varchar(50) DEFAULT NULL COMMENT 'file encoding',
4585
  `match_field` varchar(10) DEFAULT NULL COMMENT 'the field that a vendor account has been mapped to in a marc record',
4585
  `match_field` varchar(10) DEFAULT NULL COMMENT 'the field that a vendor account has been mapped to in a marc record',
4586
  `match_value` varchar(50) DEFAULT NULL COMMENT 'the value to be matched against the marc record',
4586
  `match_value` varchar(50) DEFAULT NULL COMMENT 'the value to be matched against the marc record',
4587
  `basket_name_field` varchar(10) DEFAULT NULL COMMENT 'the field that a vendor can use to include a basket name that will be used to create the basket for the file',
4587
  PRIMARY KEY (`id`),
4588
  PRIMARY KEY (`id`),
4588
  KEY `marc_ordering_account_ibfk_1` (`vendor_id`),
4589
  KEY `marc_ordering_account_ibfk_1` (`vendor_id`),
4589
  KEY `marc_ordering_account_ibfk_2` (`budget_id`),
4590
  KEY `marc_ordering_account_ibfk_2` (`budget_id`),
4590
- 

Return to bug 39518