Bugzilla – Attachment 2778 Details for
Bug 5423
Deleted Patrons are no longer saved in table deletedborrowers
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Proposed patch, written for and tested with 3.2.x
0001-3.2-Bug-5423-Deleted-Patrons-are-no-longer-saved-in-.patch (text/plain), 2.65 KB, created by
Katrin Fischer
on 2010-11-21 02:34:11 UTC
(
hide
)
Description:
Proposed patch, written for and tested with 3.2.x
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2010-11-21 02:34:11 UTC
Size:
2.65 KB
patch
obsolete
>From 3c81bc4abec05f2878435ab4d49752015d0e36a2 Mon Sep 17 00:00:00 2001 >From: Katrin Fischer <Katrin.Fischer.83@web.de> >Date: Sun, 21 Nov 2010 02:58:49 +0100 >Subject: [PATCH] [3.2] Bug 5423: Deleted Patrons are no longer saved in table deletedborrowers >Content-Type: text/plain; charset="utf-8" > >Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de> >--- > installer/data/mysql/kohastructure.sql | 3 ++- > installer/data/mysql/updatedatabase.pl | 9 +++++++++ > kohaversion.pl | 2 +- > 3 files changed, 12 insertions(+), 2 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 9148970..695129b 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -642,7 +642,7 @@ CREATE TABLE `deletedbiblioitems` ( > DROP TABLE IF EXISTS `deletedborrowers`; > CREATE TABLE `deletedborrowers` ( > `borrowernumber` int(11) NOT NULL default 0, >- `cardnumber` varchar(9) NOT NULL default '', >+ `cardnumber` varchar(16) NOT NULL default '', > `surname` mediumtext NOT NULL, > `firstname` text, > `title` mediumtext, >@@ -703,6 +703,7 @@ CREATE TABLE `deletedborrowers` ( > `altcontactcountry` text default NULL, > `altcontactphone` varchar(50) default NULL, > `smsalertnumber` varchar(50) default NULL, >+ `privacy` integer(11) DEFAULT '1' NOT NULL, > KEY `borrowernumber` (`borrowernumber`), > KEY `cardnumber` (`cardnumber`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 62e7991..31a86ba 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -3842,6 +3842,15 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { > SetVersion ($DBversion); > } > >+$DBversion = '3.02.00.XXX'; >+if (C4::Context->preference("Version") < TransformToNum($DBversion)) { >+ $dbh->do("ALTER TABLE deletedborrowers ADD `privacy` int(11) AFTER smsalertnumber;"); >+ $dbh->do("ALTER TABLE deletedborrowers CHANGE `cardnumber` `cardnumber` varchar(16);"); >+ print "Upgrade to $DBversion done (Fix differences between borrowers and deletedborrowers)\n"; >+ SetVersion ($DBversion); >+} >+ >+ > =head1 FUNCTIONS > > =head2 DropAllForeignKeys($table) >diff --git a/kohaversion.pl b/kohaversion.pl >index a506d9b..8129b69 100644 >--- a/kohaversion.pl >+++ b/kohaversion.pl >@@ -16,7 +16,7 @@ the kohaversion is divided in 4 parts : > use strict; > > sub kohaversion { >- our $VERSION = '3.02.00.007'; >+ our $VERSION = '3.02.00.XXX'; > # version needs to be set this way > # so that it can be picked up by Makefile.PL > # during install >-- >1.7.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 5423
:
2777
|
2778
|
2802
|
2804