|
Lines 1194-1199
CREATE TABLE `issuingrules` ( -- circulation and fine rules
Link Here
|
| 1194 |
cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT '0', -- cap the fine based on item's replacement price |
1194 |
cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT '0', -- cap the fine based on item's replacement price |
| 1195 |
onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf |
1195 |
onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf |
| 1196 |
opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold |
1196 |
opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold |
|
|
1197 |
article_requests enum('no','yes','bib_only','item_only') NOT NULL DEFAULT 'no', -- allow article requests to be placed, |
| 1197 |
PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`), |
1198 |
PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`), |
| 1198 |
KEY `categorycode` (`categorycode`), |
1199 |
KEY `categorycode` (`categorycode`), |
| 1199 |
KEY `itemtype` (`itemtype`) |
1200 |
KEY `itemtype` (`itemtype`) |
|
Lines 3626-3632
CREATE TABLE `article_requests` (
Link Here
|
| 3626 |
`date` text, |
3627 |
`date` text, |
| 3627 |
`pages` text, |
3628 |
`pages` text, |
| 3628 |
`chapters` text, |
3629 |
`chapters` text, |
| 3629 |
`status` enum('OPEN','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'OPEN', |
3630 |
`status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', |
| 3630 |
`notes` text, |
3631 |
`notes` text, |
| 3631 |
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
3632 |
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
| 3632 |
`updated_on` timestamp NULL DEFAULT NULL, |
3633 |
`updated_on` timestamp NULL DEFAULT NULL, |
| 3633 |
- |
|
|