Lines 892-897
CREATE TABLE `items` ( -- holdings/item information
Link Here
|
892 |
DROP TABLE IF EXISTS `itemtypes`; |
892 |
DROP TABLE IF EXISTS `itemtypes`; |
893 |
CREATE TABLE `itemtypes` ( -- defines the item types |
893 |
CREATE TABLE `itemtypes` ( -- defines the item types |
894 |
itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type |
894 |
itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type |
|
|
895 |
parent_type varchar(10) NULL default NULL, -- unique key, a code associated with the item type |
895 |
description LONGTEXT, -- a plain text explanation of the item type |
896 |
description LONGTEXT, -- a plain text explanation of the item type |
896 |
rentalcharge decimal(28,6) default NULL, -- the amount charged when this item is checked out/issued |
897 |
rentalcharge decimal(28,6) default NULL, -- the amount charged when this item is checked out/issued |
897 |
rentalcharge_daily decimal(28,6) default NULL, -- the amount charged for each day between checkout date and due date |
898 |
rentalcharge_daily decimal(28,6) default NULL, -- the amount charged for each day between checkout date and due date |
Lines 909-914
CREATE TABLE `itemtypes` ( -- defines the item types
Link Here
|
909 |
hideinopac tinyint(1) NOT NULL DEFAULT 0, -- Hide the item type from the search options in OPAC |
910 |
hideinopac tinyint(1) NOT NULL DEFAULT 0, -- Hide the item type from the search options in OPAC |
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`), |
|
|
913 |
CONSTRAINT itemtypes_ibfk_1 FOREIGN KEY (parent_type) REFERENCES itemtypes(itemtype) ON UPDATE CASCADE ON DELETE CASCADE, |
912 |
UNIQUE KEY `itemtype` (`itemtype`) |
914 |
UNIQUE KEY `itemtype` (`itemtype`) |
913 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
915 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
914 |
|
916 |
|
915 |
- |
|
|