Bugzilla – Attachment 58358 Details for
Bug 17767
Let Koha::Patron::Modification handle extended attributes
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 17767: Add borrower_modification.extended_attributes
Bug-17767-Add-borrowermodificationextendedattribut.patch (text/plain), 1.94 KB, created by
Tomás Cohen Arazi (tcohen)
on 2016-12-21 16:02:41 UTC
(
hide
)
Description:
Bug 17767: Add borrower_modification.extended_attributes
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi (tcohen)
Created:
2016-12-21 16:02:41 UTC
Size:
1.94 KB
patch
obsolete
>From 6e7764c9f24846784333a5a8da2f209ff62451b5 Mon Sep 17 00:00:00 2001 >From: Tomas Cohen Arazi <tomascohen@theke.io> >Date: Tue, 13 Dec 2016 17:42:35 -0300 >Subject: [PATCH] Bug 17767: Add borrower_modification.extended_attributes > >This patch changes the DB structure adding borrower_modifications.extended_attributes >--- > .../mysql/atomicupdate/bug_extended_attr_modification.sql | 12 ++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 13 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_extended_attr_modification.sql > >diff --git a/installer/data/mysql/atomicupdate/bug_extended_attr_modification.sql b/installer/data/mysql/atomicupdate/bug_extended_attr_modification.sql >new file mode 100644 >index 0000000..58c1253 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_extended_attr_modification.sql >@@ -0,0 +1,12 @@ >+ALTER TABLE borrower_modifications ADD COLUMN extended_attributes text DEFAULT NULL AFTER privacy; >+ >+-- $DBversion = "16.12.00.XXX"; >+-- if ( CheckVersion($DBversion) ) { >+-- >+-- $dbh->do( "ALTER TABLE borrower_modifications >+-- ADD COLUMN extended_attributes text DEFAULT NULL >+-- AFTER privacy" ); >+-- print "Upgrade to $DBversion done (Bug 8835). Everything is fine.\n"; >+-- >+-- SetVersion($DBversion); >+-- } >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 514c13d..f40692e 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3424,6 +3424,7 @@ CREATE TABLE IF NOT EXISTS `borrower_modifications` ( > `altcontactphone` varchar(50) DEFAULT NULL, > `smsalertnumber` varchar(50) DEFAULT NULL, > `privacy` int(11) DEFAULT NULL, >+ `extended_attributes` text DEFAULT NULL, > PRIMARY KEY (`verification_token`,`borrowernumber`), > KEY `verification_token` (`verification_token`), > KEY `borrowernumber` (`borrowernumber`) >-- >2.7.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 17767
:
58256
|
58257
|
58258
|
58259
|
58260
|
58358
|
58359
|
58360
|
58361
|
58362
|
58365
|
58366
|
58367
|
58368
|
58369
|
58437
|
58438
|
58439
|
58440
|
58441