Bugzilla – Attachment 57745 Details for
Bug 15705
Notify the user on auto renewing
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 15705: Increasing size of auto_renew_error to 32
Bug-15705-Increasing-size-of-autorenewerror-to-32.patch (text/plain), 3.04 KB, created by
Jonathan Druart
on 2016-11-24 10:59:30 UTC
(
hide
)
Description:
Bug 15705: Increasing size of auto_renew_error to 32
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2016-11-24 10:59:30 UTC
Size:
3.04 KB
patch
obsolete
>From 6805458ceeb230203b698f29890e0f2a244e1ac1 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Mon, 24 Oct 2016 17:16:55 +0200 >Subject: [PATCH] Bug 15705: Increasing size of auto_renew_error to 32 > >auto_too_much_oweing is bigger than 16, so we need more! >--- > installer/data/mysql/atomicupdate/bug_XXXXX.sql | 4 ++-- > installer/data/mysql/kohastructure.sql | 4 ++-- > 2 files changed, 4 insertions(+), 4 deletions(-) > >diff --git a/installer/data/mysql/atomicupdate/bug_XXXXX.sql b/installer/data/mysql/atomicupdate/bug_XXXXX.sql >index fed41f4..7a5de7d 100644 >--- a/installer/data/mysql/atomicupdate/bug_XXXXX.sql >+++ b/installer/data/mysql/atomicupdate/bug_XXXXX.sql >@@ -1,5 +1,5 @@ >-ALTER TABLE issues ADD COLUMN auto_renew_error VARCHAR(16) DEFAULT NULL AFTER auto_renew; >-ALTER TABLE old_issues ADD COLUMN auto_renew_error VARCHAR(16) DEFAULT NULL AFTER auto_renew; >+ALTER TABLE issues ADD COLUMN auto_renew_error VARCHAR(32) DEFAULT NULL AFTER auto_renew; >+ALTER TABLE old_issues ADD COLUMN auto_renew_error VARCHAR(32) DEFAULT NULL AFTER auto_renew; > > INSERT INTO letter (module, code, name, title, content, message_transport_type, is_tt) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals', > "Dear [% borrower.firstname %] [% borrower.surname %], >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 55dee35..c9c13e8 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1742,7 +1742,7 @@ CREATE TABLE `issues` ( -- information related to check outs or issues > `return` varchar(4) default NULL, > `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed > `auto_renew` BOOLEAN default FALSE, -- automatic renewal >- `auto_renew_error` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error >+ `auto_renew_error` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error > `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched > `issuedate` datetime default NULL, -- date the item was checked out or issued > `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag >@@ -1772,7 +1772,7 @@ CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r > `return` varchar(4) default NULL, > `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed > `auto_renew` BOOLEAN default FALSE, -- automatic renewal >- `auto_renew_error` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error >+ `auto_renew_error` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error > `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched > `issuedate` datetime default NULL, -- date the item was checked out or issued > `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag >-- >2.1.4
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 15705
:
47470
|
47471
|
47472
|
50336
|
50337
|
50338
|
50341
|
50342
|
50344
|
50345
|
50346
|
50680
|
50681
|
50682
|
50683
|
50732
|
50733
|
56756
|
56757
|
56758
|
56759
|
56760
|
56798
|
56799
|
56981
|
56983
|
57741
|
57742
|
57743
|
57744
|
57745
|
57746
|
57747
|
61080
|
61081
|
61082
|
61083
|
61084
|
61085
|
61086
|
61495
|
61496
|
61497
|
61498
|
61499
|
61500
|
61501
|
61739
|
62072
|
63036
|
63037
|
63138
|
63139
|
63140
|
63141
|
63142
|
63143
|
63144