Lines 1019-1025
CREATE TABLE `issuingrules` ( -- circulation and fine rules
Link Here
|
1019 |
`hardduedate` date default NULL, -- hard due date |
1019 |
`hardduedate` date default NULL, -- hard due date |
1020 |
`hardduedatecompare` tinyint NOT NULL default "0", -- type of hard due date (1 = after, 0 = on, -1 = before) |
1020 |
`hardduedatecompare` tinyint NOT NULL default "0", -- type of hard due date (1 = after, 0 = on, -1 = before) |
1021 |
`renewalsallowed` smallint(6) NOT NULL default "0", -- how many renewals are allowed |
1021 |
`renewalsallowed` smallint(6) NOT NULL default "0", -- how many renewals are allowed |
1022 |
`renewalperiod` int(4) default NULL -- renewal period in the unit set in issuingrules.lengthunit |
1022 |
`renewalperiod` int(4) default NULL, -- renewal period in the unit set in issuingrules.lengthunit |
1023 |
`reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed |
1023 |
`reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed |
1024 |
`branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode) |
1024 |
`branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode) |
1025 |
overduefinescap decimal default NULL, -- the maximum amount of an overdue fine |
1025 |
overduefinescap decimal default NULL, -- the maximum amount of an overdue fine |
1026 |
- |
|
|