View | Details | Raw Unified | Return to bug 6716
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-23 / +22 lines)
Lines 485-492 CREATE TABLE `branch_borrower_circ_rules` ( Link Here
485
--
485
--
486
486
487
DROP TABLE IF EXISTS `default_borrower_circ_rules`;
487
DROP TABLE IF EXISTS `default_borrower_circ_rules`;
488
CREATE TABLE `default_borrower_circ_rules` (
488
CREATE TABLE `default_borrower_circ_rules` ( -- default checkout rules found under "Default checkout, hold and return policy"
489
  `categorycode` VARCHAR(10) NOT NULL,
489
  `categorycode` VARCHAR(10) NOT NULL, -- patron category this rul
490
  `maxissueqty` int(4) default NULL,
490
  `maxissueqty` int(4) default NULL,
491
  PRIMARY KEY (`categorycode`),
491
  PRIMARY KEY (`categorycode`),
492
  CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
492
  CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
Lines 978-1003 CREATE TABLE `issues` ( -- information related to check outs or issues Link Here
978
--
978
--
979
979
980
DROP TABLE IF EXISTS `issuingrules`;
980
DROP TABLE IF EXISTS `issuingrules`;
981
CREATE TABLE `issuingrules` (
981
CREATE TABLE `issuingrules` ( -- circulation and fine rules
982
  `categorycode` varchar(10) NOT NULL default '',
982
  `categorycode` varchar(10) NOT NULL default '', -- patron category this rule is for (categories.categorycode)
983
  `itemtype` varchar(10) NOT NULL default '',
983
  `itemtype` varchar(10) NOT NULL default '', -- item type this rule is for (itemtypes.itemtype)
984
  `restrictedtype` tinyint(1) default NULL,
984
  `restrictedtype` tinyint(1) default NULL, -- not used? always NULL
985
  `rentaldiscount` decimal(28,6) default NULL,
985
  `rentaldiscount` decimal(28,6) default NULL, -- percent discount on the rental charge for this item
986
  `reservecharge` decimal(28,6) default NULL,
986
  `reservecharge` decimal(28,6) default NULL, 
987
  `fine` decimal(28,6) default NULL,
987
  `fine` decimal(28,6) default NULL, -- fine amount
988
  `finedays` int(11) default NULL,
988
  `finedays` int(11) default NULL, -- suspension in days
989
  `firstremind` int(11) default NULL,
989
  `firstremind` int(11) default NULL, -- fine grace period
990
  `chargeperiod` int(11) default NULL,
990
  `chargeperiod` int(11) default NULL, -- how often the fine amount is charged
991
  `accountsent` int(11) default NULL,
991
  `accountsent` int(11) default NULL, -- not used? always NULL
992
  `chargename` varchar(100) default NULL,
992
  `chargename` varchar(100) default NULL, -- not used? always NULL
993
  `maxissueqty` int(4) default NULL,
993
  `maxissueqty` int(4) default NULL, -- total number of checkouts allowed
994
  `issuelength` int(4) default NULL,
994
  `issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit
995
  `lengthunit` varchar(10) default 'days',
995
  `lengthunit` varchar(10) default 'days', -- unit of checkout length (days, hours)
996
  `hardduedate` date default NULL,
996
  `hardduedate` date default NULL, -- hard due date
997
  `hardduedatecompare` tinyint NOT NULL default "0",
997
  `hardduedatecompare` tinyint NOT NULL default "0", -- type of hard due date (1 = after, 0 = on, -1 = before)
998
  `renewalsallowed` smallint(6) NOT NULL default "0",
998
  `renewalsallowed` smallint(6) NOT NULL default "0", -- how many renewals are allowed
999
  `reservesallowed` smallint(6) NOT NULL default "0",
999
  `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed
1000
  `branchcode` varchar(10) NOT NULL default '',
1000
  `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)
1001
  PRIMARY KEY  (`branchcode`,`categorycode`,`itemtype`),
1001
  PRIMARY KEY  (`branchcode`,`categorycode`,`itemtype`),
1002
  KEY `categorycode` (`categorycode`),
1002
  KEY `categorycode` (`categorycode`),
1003
  KEY `itemtype` (`itemtype`)
1003
  KEY `itemtype` (`itemtype`)
1004
- 

Return to bug 6716