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

(-)a/installer/data/mysql/atomicupdate/bug_41649.pl (+23 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  => "41649",
6
    description => "Add sip_magnetic column to itemtypes table for SIP media handling",
7
    up          => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        # Add sip_magnetic column to itemtypes table
12
        $dbh->do(
13
            q{
14
            ALTER TABLE itemtypes
15
            ADD COLUMN sip_magnetic TINYINT(1) NOT NULL DEFAULT 0
16
            COMMENT 'Indicates if items of this type are magnetic media for SIP'
17
            AFTER sip_media_type
18
        }
19
        );
20
21
        say_success( $out, "Added column 'itemtypes.sip_magnetic'" );
22
    },
23
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 4308-4313 CREATE TABLE `itemtypes` ( Link Here
4308
  `checkinmsg` varchar(255) DEFAULT NULL COMMENT 'message that is displayed when an item with the given item type is checked in',
4308
  `checkinmsg` varchar(255) DEFAULT NULL COMMENT 'message that is displayed when an item with the given item type is checked in',
4309
  `checkinmsgtype` char(16) NOT NULL DEFAULT 'message' COMMENT 'type (CSS class) for the checkinmsg, can be ''alert'' or ''message''',
4309
  `checkinmsgtype` char(16) NOT NULL DEFAULT 'message' COMMENT 'type (CSS class) for the checkinmsg, can be ''alert'' or ''message''',
4310
  `sip_media_type` varchar(3) DEFAULT NULL COMMENT 'SIP2 protocol media type for this itemtype',
4310
  `sip_media_type` varchar(3) DEFAULT NULL COMMENT 'SIP2 protocol media type for this itemtype',
4311
  `sip_magnetic` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Indicates if items of this type are magnetic media for SIP',
4311
  `hideinopac` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Hide the item type from the search options in OPAC',
4312
  `hideinopac` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Hide the item type from the search options in OPAC',
4312
  `searchcategory` varchar(80) DEFAULT NULL COMMENT 'Group this item type with others with the same value on OPAC search options',
4313
  `searchcategory` varchar(80) DEFAULT NULL COMMENT 'Group this item type with others with the same value on OPAC search options',
4313
  `automatic_checkin` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'If automatic checkin is enabled for items of this type',
4314
  `automatic_checkin` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'If automatic checkin is enabled for items of this type',
4314
- 

Return to bug 41649