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

(-)a/installer/data/mysql/atomicupdate/bug_25560-add_boolean_updatenotforloanstatusoncheckin.perl (+9 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
4
    if( !column_exists( 'itemtypes', 'updatenotforloanstatusoncheckin' ) ) {
5
        $dbh->do(q{ ALTER TABLE itemtypes ADD COLUMN updatenotforloanstatusoncheckin TINYINT(1) NOT NULL DEFAULT 0 AFTER hideinopac });
6
    }
7
8
    NewVersion( $DBversion, 25560, "Add updatenotforloanstatusoncheckin boolean flag to itemtypestable");
9
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 907-912 CREATE TABLE `itemtypes` ( -- defines the item types Link Here
907
  checkinmsgtype CHAR(16) DEFAULT 'message' NOT NULL, -- type (CSS class) for the checkinmsg, can be "alert" or "message"
907
  checkinmsgtype CHAR(16) DEFAULT 'message' NOT NULL, -- type (CSS class) for the checkinmsg, can be "alert" or "message"
908
  sip_media_type VARCHAR(3) DEFAULT NULL, -- SIP2 protocol media type for this itemtype
908
  sip_media_type VARCHAR(3) DEFAULT NULL, -- SIP2 protocol media type for this itemtype
909
  hideinopac tinyint(1) NOT NULL DEFAULT 0, -- Hide the item type from the search options in OPAC
909
  hideinopac tinyint(1) NOT NULL DEFAULT 0, -- Hide the item type from the search options in OPAC
910
  updatenotforloanstatusoncheckin tinyint(1) NOT NULL DEFAULT 0, -- Enable the itemtype to be altered by the UpdateNotForLoanStatusOnCheckin system preference
910
  searchcategory varchar(80) default NULL, -- Group this item type with others with the same value on OPAC search options
911
  searchcategory varchar(80) default NULL, -- Group this item type with others with the same value on OPAC search options
911
  PRIMARY KEY  (`itemtype`),
912
  PRIMARY KEY  (`itemtype`),
912
  UNIQUE KEY `itemtype` (`itemtype`)
913
  UNIQUE KEY `itemtype` (`itemtype`)
913
- 

Return to bug 25560