Lines 853-858
CREATE TABLE `import_items` (
Link Here
|
853 |
|
853 |
|
854 |
DROP TABLE IF EXISTS `issuingrules`; |
854 |
DROP TABLE IF EXISTS `issuingrules`; |
855 |
CREATE TABLE `issuingrules` ( -- circulation and fine rules |
855 |
CREATE TABLE `issuingrules` ( -- circulation and fine rules |
|
|
856 |
`issuingrules_id` int(11) NOT NULL auto_increment, |
856 |
`categorycode` varchar(10) NOT NULL default '', -- patron category this rule is for (categories.categorycode) |
857 |
`categorycode` varchar(10) NOT NULL default '', -- patron category this rule is for (categories.categorycode) |
857 |
`itemtype` varchar(10) NOT NULL default '', -- item type this rule is for (itemtypes.itemtype) |
858 |
`itemtype` varchar(10) NOT NULL default '', -- item type this rule is for (itemtypes.itemtype) |
858 |
`restrictedtype` tinyint(1) default NULL, -- not used? always NULL |
859 |
`restrictedtype` tinyint(1) default NULL, -- not used? always NULL |
Lines 886-892
CREATE TABLE `issuingrules` ( -- circulation and fine rules
Link Here
|
886 |
onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf |
887 |
onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf |
887 |
opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold |
888 |
opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold |
888 |
article_requests enum('no','yes','bib_only','item_only') NOT NULL DEFAULT 'no', -- allow article requests to be placed, |
889 |
article_requests enum('no','yes','bib_only','item_only') NOT NULL DEFAULT 'no', -- allow article requests to be placed, |
889 |
PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`), |
890 |
PRIMARY KEY (`issuingrules_id`), |
|
|
891 |
UNIQUE KEY `issuingrules_selects` (`branchcode`,`categorycode`,`itemtype`), |
890 |
KEY `categorycode` (`categorycode`), |
892 |
KEY `categorycode` (`categorycode`), |
891 |
KEY `itemtype` (`itemtype`) |
893 |
KEY `itemtype` (`itemtype`) |
892 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
894 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
893 |
- |
|
|