Lines 949-954
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
949 |
DROP TABLE IF EXISTS `itemtypes`; |
949 |
DROP TABLE IF EXISTS `itemtypes`; |
950 |
CREATE TABLE `itemtypes` ( -- defines the item types |
950 |
CREATE TABLE `itemtypes` ( -- defines the item types |
951 |
itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type |
951 |
itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type |
|
|
952 |
parent_type varchar(10) NULL default NULL, -- unique key, a code associated with the item type |
952 |
description LONGTEXT, -- a plain text explanation of the item type |
953 |
description LONGTEXT, -- a plain text explanation of the item type |
953 |
rentalcharge decimal(28,6) default NULL, -- the amount charged when this item is checked out/issued |
954 |
rentalcharge decimal(28,6) default NULL, -- the amount charged when this item is checked out/issued |
954 |
rentalcharge_daily decimal(28,6) default NULL, -- the amount charged for each day between checkout date and due date |
955 |
rentalcharge_daily decimal(28,6) default NULL, -- the amount charged for each day between checkout date and due date |
Lines 964-969
CREATE TABLE `itemtypes` ( -- defines the item types
Link Here
|
964 |
hideinopac tinyint(1) NOT NULL DEFAULT 0, -- Hide the item type from the search options in OPAC |
965 |
hideinopac tinyint(1) NOT NULL DEFAULT 0, -- Hide the item type from the search options in OPAC |
965 |
searchcategory varchar(80) default NULL, -- Group this item type with others with the same value on OPAC search options |
966 |
searchcategory varchar(80) default NULL, -- Group this item type with others with the same value on OPAC search options |
966 |
PRIMARY KEY (`itemtype`), |
967 |
PRIMARY KEY (`itemtype`), |
|
|
968 |
FOREIGN KEY (parent_type) REFERENCES itemtypes(itemtype) ON UPDATE CASCADE ON DELETE CASCADE, |
967 |
UNIQUE KEY `itemtype` (`itemtype`) |
969 |
UNIQUE KEY `itemtype` (`itemtype`) |
968 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
970 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
969 |
|
971 |
|
970 |
- |
|
|