From 7f1435cf724f5755d0dd9ca69b397c13e777ab07 Mon Sep 17 00:00:00 2001 From: Jesse Weaver Date: Mon, 29 Jan 2018 13:44:43 -0700 Subject: [PATCH] Bug 18936: (follow-up) Remove issuingrules from kohastructure.sql --- installer/data/mysql/kohastructure.sql | 42 ---------------------------------- 1 file changed, 42 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index ed882f6e9f..4b8e5d5294 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -787,48 +787,6 @@ CREATE TABLE `import_items` ( KEY `branchcode` (`branchcode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; --- --- Table structure for table `issuingrules` --- - -DROP TABLE IF EXISTS `issuingrules`; -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 - `maxsuspensiondays` int(11) default NULL, -- max suspension days - `firstremind` int(11) default NULL, -- fine grace period - `chargeperiod` int(11) default NULL, -- how often the fine amount is charged - `chargeperiod_charge_at` tinyint(1) NOT NULL DEFAULT '0', -- Should fine be given at the start ( 1 ) or the end ( 0 ) of the period - `accountsent` int(11) default NULL, -- not used? always NULL - `chargename` varchar(100) default NULL, -- not used? always NULL - `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 - `renewalperiod` int(4) default NULL, -- renewal period in the unit set in issuingrules.lengthunit - `norenewalbefore` int(4) default NULL, -- no renewal allowed until X days or hours before due date. - `auto_renew` BOOLEAN default FALSE, -- automatic renewal - `no_auto_renewal_after` int(4) default NULL, -- no auto renewal allowed after X days or hours after the issue date - `no_auto_renewal_after_hard_limit` date default NULL, -- no auto renewal allowed after a given date - `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed - `holds_per_record` SMALLINT(6) NOT NULL DEFAULT 1, -- How many holds a patron can have on a given bib - `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode) - overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine - cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT '0', -- cap the fine based on item's replacement price - onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf - opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold - article_requests enum('no','yes','bib_only','item_only') NOT NULL DEFAULT 'no', -- allow article requests to be placed, - PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`), - KEY `categorycode` (`categorycode`), - KEY `itemtype` (`itemtype`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; - -- -- Table structure for table `refund_lost_item_fee_rules` -- -- 2.15.1