Bugzilla – Attachment 72236 Details for
Bug 18936
Move issuingrules into circulation_rules
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 18936: (follow-up) Remove issuingrules from kohastructure.sql
Bug-18936-follow-up-Remove-issuingrules-from-kohas.patch (text/plain), 3.82 KB, created by
Jesse Weaver
on 2018-02-26 19:18:45 UTC
(
hide
)
Description:
Bug 18936: (follow-up) Remove issuingrules from kohastructure.sql
Filename:
MIME Type:
Creator:
Jesse Weaver
Created:
2018-02-26 19:18:45 UTC
Size:
3.82 KB
patch
obsolete
>From 7f1435cf724f5755d0dd9ca69b397c13e777ab07 Mon Sep 17 00:00:00 2001 >From: Jesse Weaver <pianohacker@gmail.com> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 18936
:
65247
|
65248
|
65249
|
67629
|
67758
|
68236
|
71034
|
71035
|
71036
|
71037
|
71038
|
71039
|
71040
|
71041
|
72230
|
72231
|
72232
|
72233
|
72234
|
72235
|
72236
|
72237
|
72238
|
91953
|
91954
|
91955
|
91956
|
91957
|
91958
|
91959
|
91960
|
91961
|
91962
|
91963
|
91964
|
91965
|
91966
|
91967
|
91968
|
91969
|
91970
|
91971
|
91972
|
91973
|
91974
|
91975
|
94179
|
94180
|
94181
|
94182
|
94183
|
94184
|
94185
|
94186
|
94187
|
94188
|
94189
|
94190
|
94191
|
94192
|
94193
|
94194
|
94195
|
94196
|
94197
|
94198
|
94199
|
94200
|
98299
|
98300
|
98301
|
98302
|
98303
|
98304
|
98305
|
98306
|
98307
|
98308
|
98309
|
98310
|
98311
|
98312
|
98313
|
98314
|
98315
|
98316
|
98317
|
98318
|
98319
|
98320
|
98321
|
98322
|
98323
|
98324
|
98325
|
98326
|
98327
|
98328
|
98329
|
98330
|
98331
|
98332
|
98333
|
98334
|
98335
|
98336
|
98337
|
98338
|
98339
|
98340
|
98341
|
98342
|
98343
|
98344
|
98345
|
98346
|
98347
|
98407
|
98408