Bugzilla – Attachment 67222 Details for
Bug 19344
DB fields login_attempts and lang may be inverted
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 19344: Reorder lang and login_attempts in the [deleted]borrowers tables
SIGNED-OFF-Bug-19344-Reorder-lang-and-loginattempt.patch (text/plain), 1.18 KB, created by
Mark Tompsett
on 2017-09-19 17:46:31 UTC
(
hide
)
Description:
Bug 19344: Reorder lang and login_attempts in the [deleted]borrowers tables
Filename:
MIME Type:
Creator:
Mark Tompsett
Created:
2017-09-19 17:46:31 UTC
Size:
1.18 KB
patch
obsolete
>From d832b6a5288e5fb21ed01fd62c05730895808b02 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Tue, 19 Sep 2017 13:32:31 -0300 >Subject: [PATCH] [SIGNED-OFF] Bug 19344: Reorder lang and login_attempts in > the [deleted]borrowers tables > >Due to a bad rebase, the borrowers and deletedborrowers table structure >may different from a new install and upgraded install >For new installs, the order was: lang, login_attempts >For upgraded installs, it was lang, last_seen, login_attempts > >After this patch, the order must be: >- last_seen >- lang >- login_attempts > >Signed-off-by: Mark Tompsett <mtompset@hotmail.com> >--- > installer/data/mysql/atomicupdate/bug_19344.sql | 2 ++ > 1 file changed, 2 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_19344.sql > >diff --git a/installer/data/mysql/atomicupdate/bug_19344.sql b/installer/data/mysql/atomicupdate/bug_19344.sql >new file mode 100644 >index 0000000..36faba8 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_19344.sql >@@ -0,0 +1,2 @@ >+ALTER TABLE borrowers MODIFY COLUMN login_attempts int(4) AFTER lang; >+ALTER TABLE deletedborrowers MODIFY COLUMN login_attempts int(4) AFTER lang; >-- >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 19344
:
67220
|
67222
|
67466