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