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