|
Lines 943-948
CREATE TABLE `itemtypes` ( -- defines the item types
Link Here
|
| 943 |
sip_media_type VARCHAR(3) DEFAULT NULL, -- SIP2 protocol media type for this itemtype |
943 |
sip_media_type VARCHAR(3) DEFAULT NULL, -- SIP2 protocol media type for this itemtype |
| 944 |
hideinopac tinyint(1) NOT NULL DEFAULT 0, -- Hide the item type from the search options in OPAC |
944 |
hideinopac tinyint(1) NOT NULL DEFAULT 0, -- Hide the item type from the search options in OPAC |
| 945 |
searchcategory varchar(80) default NULL, -- Group this item type with others with the same value on OPAC search options |
945 |
searchcategory varchar(80) default NULL, -- Group this item type with others with the same value on OPAC search options |
|
|
946 |
`automatic_checkin` tinyint(1) NOT NULL DEFAULT 0, -- 1 if automatic checkin is enabled for items of this type |
| 946 |
PRIMARY KEY (`itemtype`), |
947 |
PRIMARY KEY (`itemtype`), |
| 947 |
CONSTRAINT itemtypes_ibfk_1 FOREIGN KEY (parent_type) REFERENCES itemtypes(itemtype) ON UPDATE CASCADE ON DELETE CASCADE, |
948 |
CONSTRAINT itemtypes_ibfk_1 FOREIGN KEY (parent_type) REFERENCES itemtypes(itemtype) ON UPDATE CASCADE ON DELETE CASCADE, |
| 948 |
UNIQUE KEY `itemtype` (`itemtype`) |
949 |
UNIQUE KEY `itemtype` (`itemtype`) |
| 949 |
- |
|
|