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