Bugzilla – Attachment 83079 Details for
Bug 19066
Add branchcode to accountlines
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 19066: (QA follow-up) Move db update to perl
Bug-19066-QA-follow-up-Move-db-update-to-perl.patch (text/plain), 1.72 KB, created by
Martin Renvoize (ashimema)
on 2018-12-12 08:58:58 UTC
(
hide
)
Description:
Bug 19066: (QA follow-up) Move db update to perl
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2018-12-12 08:58:58 UTC
Size:
1.72 KB
patch
obsolete
>From 766618842709ca417e29091d816349bc95c52624 Mon Sep 17 00:00:00 2001 >From: Josef Moravec <josef.moravec@gmail.com> >Date: Wed, 31 Oct 2018 07:24:05 +0000 >Subject: [PATCH] Bug 19066: (QA follow-up) Move db update to perl > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > installer/data/mysql/atomicupdate/bug_19066.sql | 1 - > .../bug_19066_add_accountlines_branchcode.perl | 11 +++++++++++ > 2 files changed, 11 insertions(+), 1 deletion(-) > delete mode 100644 installer/data/mysql/atomicupdate/bug_19066.sql > create mode 100644 installer/data/mysql/atomicupdate/bug_19066_add_accountlines_branchcode.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_19066.sql b/installer/data/mysql/atomicupdate/bug_19066.sql >deleted file mode 100644 >index 8fe161a6a3..0000000000 >--- a/installer/data/mysql/atomicupdate/bug_19066.sql >+++ /dev/null >@@ -1 +0,0 @@ >-ALTER TABLE accountlines ADD branchcode VARCHAR( 10 ) NULL DEFAULT NULL AFTER manager_id; >diff --git a/installer/data/mysql/atomicupdate/bug_19066_add_accountlines_branchcode.perl b/installer/data/mysql/atomicupdate/bug_19066_add_accountlines_branchcode.perl >new file mode 100644 >index 0000000000..426d997da5 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_19066_add_accountlines_branchcode.perl >@@ -0,0 +1,11 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ >+ if( !column_exists( 'accountlines', 'branchcode' ) ) { >+ $dbh->do("ALTER TABLE accountlines ADD branchcode VARCHAR( 10 ) NULL DEFAULT NULL AFTER manager_id"); >+ } >+ >+ # Always end with this (adjust the bug info) >+ SetVersion( $DBversion ); >+ print "Upgrade to $DBversion done (Bug 19066 - Add branchcode to accountlines)\n"; >+} >-- >2.19.2
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 19066
:
65769
|
65770
|
65771
|
67756
|
67757
|
71153
|
71154
|
71155
|
73185
|
73186
|
73187
|
73595
|
77281
|
77282
|
77283
|
78900
|
78901
|
81144
|
81145
|
81146
|
81253
|
81254
|
81255
|
81684
|
81912
|
81918
|
82047
|
82048
|
82084
|
82086
|
82087
|
82469
|
82470
|
82471
|
82473
|
82474
|
82475
|
82476
|
82477
|
82478
|
83067
|
83068
|
83069
|
83070
|
83071
|
83072
|
83073
|
83074
|
83075
|
83076
|
83077
|
83078
|
83079
|
83080
|
83081
|
83082
|
83083
|
83084
|
83275
|
83519
|
83520
|
83521
|
83522
|
83523
|
83524
|
83525
|
83526
|
83527
|
83528
|
83628