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

(-)a/installer/data/mysql/atomicupdate/bug_25560-add_updatenotforloan_to_itemtypes.pl (+16 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "25560",
5
    description => "Adding new column 'itemtypes.updatenotforloan'",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
10
        if( !column_exists( 'itemtypes', 'updatenotforloan' ) ) {
11
          $dbh->do(q{
12
              ALTER TABLE itemtypes ADD COLUMN `updatenotforloan` TINYINT(1) NOT NULL DEFAULT 1 AFTER `hideinopac`
13
          });
14
        }
15
    },
16
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 3163-3168 CREATE TABLE `itemtypes` ( Link Here
3163
  `checkinmsgtype` char(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'message' COMMENT 'type (CSS class) for the checkinmsg, can be ''alert'' or ''message''',
3163
  `checkinmsgtype` char(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'message' COMMENT 'type (CSS class) for the checkinmsg, can be ''alert'' or ''message''',
3164
  `sip_media_type` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'SIP2 protocol media type for this itemtype',
3164
  `sip_media_type` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'SIP2 protocol media type for this itemtype',
3165
  `hideinopac` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Hide the item type from the search options in OPAC',
3165
  `hideinopac` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Hide the item type from the search options in OPAC',
3166
  `updatenotforloan` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Enable this item type to be altered by the UpdateNotForLoanStatusOnCheckin system preference',
3166
  `searchcategory` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Group this item type with others with the same value on OPAC search options',
3167
  `searchcategory` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Group this item type with others with the same value on OPAC search options',
3167
  `automatic_checkin` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'If automatic checkin is enabled for items of this type',
3168
  `automatic_checkin` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'If automatic checkin is enabled for items of this type',
3168
  PRIMARY KEY (`itemtype`),
3169
  PRIMARY KEY (`itemtype`),
3169
- 

Return to bug 25560