|
Lines 793-839
CREATE TABLE `import_items` (
Link Here
|
| 793 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
793 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 794 |
|
794 |
|
| 795 |
-- |
795 |
-- |
| 796 |
-- Table structure for table `issuingrules` |
796 |
-- Table structure for table `refund_lost_item_fee_rules` |
| 797 |
-- |
797 |
-- |
| 798 |
|
798 |
|
| 799 |
DROP TABLE IF EXISTS `issuingrules`; |
799 |
DROP TABLE IF EXISTS `refund_lost_item_fee_rules`; |
| 800 |
CREATE TABLE `issuingrules` ( -- circulation and fine rules |
800 |
CREATE TABLE `refund_lost_item_fee_rules` ( -- refund lost item fee rules tbale |
| 801 |
`categorycode` varchar(10) NOT NULL default '', -- patron category this rule is for (categories.categorycode) |
|
|
| 802 |
`itemtype` varchar(10) NOT NULL default '', -- item type this rule is for (itemtypes.itemtype) |
| 803 |
`restrictedtype` tinyint(1) default NULL, -- not used? always NULL |
| 804 |
`rentaldiscount` decimal(28,6) default NULL, -- percent discount on the rental charge for this item |
| 805 |
`reservecharge` decimal(28,6) default NULL, |
| 806 |
`fine` decimal(28,6) default NULL, -- fine amount |
| 807 |
`finedays` int(11) default NULL, -- suspension in days |
| 808 |
`maxsuspensiondays` int(11) default NULL, -- max suspension days |
| 809 |
`suspension_chargeperiod` int(11) default '1', -- how often the finedays is charged |
| 810 |
`firstremind` int(11) default NULL, -- fine grace period |
| 811 |
`chargeperiod` int(11) default NULL, -- how often the fine amount is charged |
| 812 |
`chargeperiod_charge_at` tinyint(1) NOT NULL DEFAULT '0', -- Should fine be given at the start ( 1 ) or the end ( 0 ) of the period |
| 813 |
`accountsent` int(11) default NULL, -- not used? always NULL |
| 814 |
`issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit |
| 815 |
`lengthunit` varchar(10) default 'days', -- unit of checkout length (days, hours) |
| 816 |
`hardduedate` date default NULL, -- hard due date |
| 817 |
`hardduedatecompare` tinyint NOT NULL default "0", -- type of hard due date (1 = after, 0 = on, -1 = before) |
| 818 |
`renewalsallowed` smallint(6) NOT NULL default "0", -- how many renewals are allowed |
| 819 |
`renewalperiod` int(4) default NULL, -- renewal period in the unit set in issuingrules.lengthunit |
| 820 |
`norenewalbefore` int(4) default NULL, -- no renewal allowed until X days or hours before due date. |
| 821 |
`auto_renew` BOOLEAN default FALSE, -- automatic renewal |
| 822 |
`no_auto_renewal_after` int(4) default NULL, -- no auto renewal allowed after X days or hours after the issue date |
| 823 |
`no_auto_renewal_after_hard_limit` date default NULL, -- no auto renewal allowed after a given date |
| 824 |
`reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed |
| 825 |
`holds_per_record` SMALLINT(6) NOT NULL DEFAULT 1, -- How many holds a patron can have on a given bib |
| 826 |
`holds_per_day` SMALLINT(6) DEFAULT NULL, -- How many holds a patron can have on a day |
| 827 |
`branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode) |
801 |
`branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode) |
| 828 |
overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine |
802 |
`refund` tinyint(1) NOT NULL default 0, -- control wether to refund lost item fees on return |
| 829 |
cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT '0', -- cap the fine based on item's replacement price |
803 |
PRIMARY KEY (`branchcode`) |
| 830 |
onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf |
|
|
| 831 |
opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold |
| 832 |
article_requests enum('no','yes','bib_only','item_only') NOT NULL DEFAULT 'no', -- allow article requests to be placed, |
| 833 |
`note` varchar(100) default NULL, -- description of rule, reason for setting rule |
| 834 |
PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`), |
| 835 |
KEY `categorycode` (`categorycode`), |
| 836 |
KEY `itemtype` (`itemtype`) |
| 837 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
804 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 838 |
|
805 |
|
| 839 |
-- |
806 |
-- |
| 840 |
- |
|
|