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