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