[Koha-patches] [PATCH] Bug 6716: document issuingrules table
Nicole C. Engard
nengard at bywatersolutions.com
Fri Jul 13 20:32:50 CEST 2012
---
installer/data/mysql/kohastructure.sql | 44 ++++++++++++++++----------------
1 files changed, 22 insertions(+), 22 deletions(-)
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 3b9827a..b97be27 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -485,8 +485,8 @@ CREATE TABLE `branch_borrower_circ_rules` (
--
DROP TABLE IF EXISTS `default_borrower_circ_rules`;
-CREATE TABLE `default_borrower_circ_rules` (
- `categorycode` VARCHAR(10) NOT NULL,
+CREATE TABLE `default_borrower_circ_rules` ( -- default checkout rules found under "Default checkout, hold and return policy"
+ `categorycode` VARCHAR(10) NOT NULL, -- patron category this rul
`maxissueqty` int(4) default NULL,
PRIMARY KEY (`categorycode`),
CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
@@ -978,26 +978,26 @@ CREATE TABLE `issues` ( -- information related to check outs or issues
--
DROP TABLE IF EXISTS `issuingrules`;
-CREATE TABLE `issuingrules` (
- `categorycode` varchar(10) NOT NULL default '',
- `itemtype` varchar(10) NOT NULL default '',
- `restrictedtype` tinyint(1) default NULL,
- `rentaldiscount` decimal(28,6) default NULL,
- `reservecharge` decimal(28,6) default NULL,
- `fine` decimal(28,6) default NULL,
- `finedays` int(11) default NULL,
- `firstremind` int(11) default NULL,
- `chargeperiod` int(11) default NULL,
- `accountsent` int(11) default NULL,
- `chargename` varchar(100) default NULL,
- `maxissueqty` int(4) default NULL,
- `issuelength` int(4) default NULL,
- `lengthunit` varchar(10) default 'days',
- `hardduedate` date default NULL,
- `hardduedatecompare` tinyint NOT NULL default "0",
- `renewalsallowed` smallint(6) NOT NULL default "0",
- `reservesallowed` smallint(6) NOT NULL default "0",
- `branchcode` varchar(10) NOT NULL default '',
+CREATE TABLE `issuingrules` ( -- circulation and fine rules
+ `categorycode` varchar(10) NOT NULL default '', -- patron category this rule is for (categories.categorycode)
+ `itemtype` varchar(10) NOT NULL default '', -- item type this rule is for (itemtypes.itemtype)
+ `restrictedtype` tinyint(1) default NULL, -- not used? always NULL
+ `rentaldiscount` decimal(28,6) default NULL, -- percent discount on the rental charge for this item
+ `reservecharge` decimal(28,6) default NULL,
+ `fine` decimal(28,6) default NULL, -- fine amount
+ `finedays` int(11) default NULL, -- suspension in days
+ `firstremind` int(11) default NULL, -- fine grace period
+ `chargeperiod` int(11) default NULL, -- how often the fine amount is charged
+ `accountsent` int(11) default NULL, -- not used? always NULL
+ `chargename` varchar(100) default NULL, -- not used? always NULL
+ `maxissueqty` int(4) default NULL, -- total number of checkouts allowed
+ `issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit
+ `lengthunit` varchar(10) default 'days', -- unit of checkout length (days, hours)
+ `hardduedate` date default NULL, -- hard due date
+ `hardduedatecompare` tinyint NOT NULL default "0", -- type of hard due date (1 = after, 0 = on, -1 = before)
+ `renewalsallowed` smallint(6) NOT NULL default "0", -- how many renewals are allowed
+ `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed
+ `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)
PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`),
KEY `categorycode` (`categorycode`),
KEY `itemtype` (`itemtype`)
--
1.7.2.3
More information about the Koha-patches
mailing list