Lines 1130-1136
CREATE TABLE `issuingrules` ( -- circulation and fine rules
Link Here
|
1130 |
`renewalperiod` int(4) default NULL, -- renewal period in the unit set in issuingrules.lengthunit |
1130 |
`renewalperiod` int(4) default NULL, -- renewal period in the unit set in issuingrules.lengthunit |
1131 |
`reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed |
1131 |
`reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed |
1132 |
`branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode) |
1132 |
`branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode) |
1133 |
overduefinescap decimal default NULL, -- the maximum amount of an overdue fine |
1133 |
overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine |
1134 |
PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`), |
1134 |
PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`), |
1135 |
KEY `categorycode` (`categorycode`), |
1135 |
KEY `categorycode` (`categorycode`), |
1136 |
KEY `itemtype` (`itemtype`) |
1136 |
KEY `itemtype` (`itemtype`) |