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

(-)a/installer/data/mysql/kohastructure.sql (-41 / +7 lines)
Lines 801-847 CREATE TABLE `import_items` ( Link Here
801
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
801
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
802
802
803
--
803
--
804
-- Table structure for table `issuingrules`
804
-- Table structure for table `refund_lost_item_fee_rules`
805
--
805
--
806
806
807
DROP TABLE IF EXISTS `issuingrules`;
807
DROP TABLE IF EXISTS `refund_lost_item_fee_rules`;
808
CREATE TABLE `issuingrules` ( -- circulation and fine rules
808
CREATE TABLE `refund_lost_item_fee_rules` ( -- refund lost item fee rules tbale
809
  `categorycode` varchar(10) NOT NULL default '', -- patron category this rule is for (categories.categorycode)
810
  `itemtype` varchar(10) NOT NULL default '', -- item type this rule is for (itemtypes.itemtype)
811
  `restrictedtype` tinyint(1) default NULL, -- not used? always NULL
812
  `rentaldiscount` decimal(28,6) default NULL, -- percent discount on the rental charge for this item
813
  `reservecharge` decimal(28,6) default NULL,
814
  `fine` decimal(28,6) default NULL, -- fine amount
815
  `finedays` int(11) default NULL, -- suspension in days
816
  `maxsuspensiondays` int(11) default NULL, -- max suspension days
817
  `suspension_chargeperiod` int(11) default '1', -- how often the finedays is charged
818
  `firstremind` int(11) default NULL, -- fine grace period
819
  `chargeperiod` int(11) default NULL, -- how often the fine amount is charged
820
  `chargeperiod_charge_at` tinyint(1) NOT NULL DEFAULT '0', -- Should fine be given at the start ( 1 ) or the end ( 0 ) of the period
821
  `accountsent` int(11) default NULL, -- not used? always NULL
822
  `issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit
823
  `lengthunit` varchar(10) default 'days', -- unit of checkout length (days, hours)
824
  `hardduedate` date default NULL, -- hard due date
825
  `hardduedatecompare` tinyint NOT NULL default "0", -- type of hard due date (1 = after, 0 = on, -1 = before)
826
  `renewalsallowed` smallint(6) NOT NULL default "0", -- how many renewals are allowed
827
  `renewalperiod` int(4) default NULL, -- renewal period in the unit set in issuingrules.lengthunit
828
  `norenewalbefore` int(4) default NULL, -- no renewal allowed until X days or hours before due date.
829
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
830
  `no_auto_renewal_after` int(4) default NULL, -- no auto renewal allowed after X days or hours after the issue date
831
  `no_auto_renewal_after_hard_limit` date default NULL, -- no auto renewal allowed after a given date
832
  `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed
833
  `holds_per_record` SMALLINT(6) NOT NULL DEFAULT 1, -- How many holds a patron can have on a given bib
834
  `holds_per_day` SMALLINT(6) DEFAULT NULL, -- How many holds a patron can have on a day
835
  `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)
809
  `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)
836
  overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine
810
  `refund` tinyint(1) NOT NULL default 0, -- control wether to refund lost item fees on return
837
  cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT  '0', -- cap the fine based on item's replacement price
811
  PRIMARY KEY  (`branchcode`)
838
  onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf
839
  opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold
840
  article_requests enum('no','yes','bib_only','item_only') NOT NULL DEFAULT 'no', -- allow article requests to be placed,
841
  `note` varchar(100) default NULL, -- description of rule, reason for setting rule
842
  PRIMARY KEY  (`branchcode`,`categorycode`,`itemtype`),
843
  KEY `categorycode` (`categorycode`),
844
  KEY `itemtype` (`itemtype`)
845
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
812
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
846
813
847
--
814
--
848
- 

Return to bug 18936