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

(-)a/installer/data/mysql/atomicupdate/bug_20644-add_checkprevcheckout_to_items.pl (-1 / +1 lines)
Lines 11-17 return { Link Here
11
            $dbh->do(
11
            $dbh->do(
12
                q{
12
                q{
13
                ALTER TABLE itemtypes
13
                ALTER TABLE itemtypes
14
                ADD IF NOT EXISTS checkprevcheckout varchar(7) NOT NULL DEFAULT 'inherit' COMMENT 'produce a warning for a patron if a item of this type has previously been checked out to the same patron if ''yes'', not if ''no'', defer to category setting if ''inherit''.'
14
                ADD IF NOT EXISTS checkprevcheckout enum('yes', 'no', 'inherit') NOT NULL DEFAULT 'inherit' COMMENT 'produce a warning for a patron if a item of this type has previously been checked out to the same patron if ''yes'', not if ''no'', defer to category setting if ''inherit''.'
15
                AFTER automatic_checkin;
15
                AFTER automatic_checkin;
16
            }
16
            }
17
            );
17
            );
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 4239-4245 CREATE TABLE `itemtypes` ( Link Here
4239
  `searchcategory` varchar(80) DEFAULT NULL COMMENT 'Group this item type with others with the same value on OPAC search options',
4239
  `searchcategory` varchar(80) DEFAULT NULL COMMENT 'Group this item type with others with the same value on OPAC search options',
4240
  `automatic_checkin` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'If automatic checkin is enabled for items of this type',
4240
  `automatic_checkin` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'If automatic checkin is enabled for items of this type',
4241
  `bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Activate bookable feature for items related to this item type',
4241
  `bookable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Activate bookable feature for items related to this item type',
4242
  `checkprevcheckout` varchar(7) NOT NULL DEFAULT 'inherit' COMMENT 'produce a warning for a patron if a item of this type has previously been checked out to the same patron if ''yes'', not if ''no'', defer to category setting if ''inherit''.',
4242
  `checkprevcheckout` enum('yes','no','inherit') NOT NULL DEFAULT 'inherit' COMMENT 'produce a warning for a patron if a item of this type has previously been checked out to the same patron if ''yes'', not if ''no'', defer to category setting if ''inherit''.',
4243
  PRIMARY KEY (`itemtype`),
4243
  PRIMARY KEY (`itemtype`),
4244
  UNIQUE KEY `itemtype` (`itemtype`),
4244
  UNIQUE KEY `itemtype` (`itemtype`),
4245
  KEY `itemtypes_ibfk_1` (`parent_type`),
4245
  KEY `itemtypes_ibfk_1` (`parent_type`),
4246
- 

Return to bug 20644