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 |
- |
|
|