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 1 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 916-921 CREATE TABLE `itemtypes` ( -- defines the item types Link Here
916
  checkinmsgtype CHAR(16) DEFAULT 'message' NOT NULL, -- type (CSS class) for the checkinmsg, can be "alert" or "message"
916
  checkinmsgtype CHAR(16) DEFAULT 'message' NOT NULL, -- type (CSS class) for the checkinmsg, can be "alert" or "message"
917
  sip_media_type VARCHAR(3) DEFAULT NULL, -- SIP2 protocol media type for this itemtype
917
  sip_media_type VARCHAR(3) DEFAULT NULL, -- SIP2 protocol media type for this itemtype
918
  hideinopac tinyint(1) NOT NULL DEFAULT 0, -- Hide the item type from the search options in OPAC
918
  hideinopac tinyint(1) NOT NULL DEFAULT 0, -- Hide the item type from the search options in OPAC
919
  updatenotforloanstatusoncheckin tinyint(1) NOT NULL DEFAULT 1, -- Enable the itemtype to be altered by the UpdateNotForLoanStatusOnCheckin system preference
919
  searchcategory varchar(80) default NULL, -- Group this item type with others with the same value on OPAC search options
920
  searchcategory varchar(80) default NULL, -- Group this item type with others with the same value on OPAC search options
920
  PRIMARY KEY  (`itemtype`),
921
  PRIMARY KEY  (`itemtype`),
921
  CONSTRAINT itemtypes_ibfk_1 FOREIGN KEY (parent_type) REFERENCES itemtypes(itemtype) ON UPDATE CASCADE ON DELETE CASCADE,
922
  CONSTRAINT itemtypes_ibfk_1 FOREIGN KEY (parent_type) REFERENCES itemtypes(itemtype) ON UPDATE CASCADE ON DELETE CASCADE,
922
- 

Return to bug 25560