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