Bugzilla – Attachment 71119 Details for
Bug 4078
Add the ability to customize and display the symbol for a currency
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 4078: Update DB entry - add new column currency.p_sep_by_space
Bug-4078-Update-DB-entry---add-new-column-currency.patch (text/plain), 1.60 KB, created by
Jonathan Druart
on 2018-02-01 17:43:10 UTC
(
hide
)
Description:
Bug 4078: Update DB entry - add new column currency.p_sep_by_space
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2018-02-01 17:43:10 UTC
Size:
1.60 KB
patch
obsolete
>From b45e667553f13a0c71a6218fbcf7b170e560a7fd Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Thu, 1 Feb 2018 14:30:53 -0300 >Subject: [PATCH] Bug 4078: Update DB entry - add new column > currency.p_sep_by_space > >--- > installer/data/mysql/atomicupdate/bug_4078.perl | 9 +++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 10 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_4078.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_4078.perl b/installer/data/mysql/atomicupdate/bug_4078.perl >new file mode 100644 >index 0000000000..0aa414f3cf >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_4078.perl >@@ -0,0 +1,9 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ if( !column_exists( 'currency', 'p_sep_by_space' ) ) { >+ $dbh->do( "ALTER TABLE currency ADD COLUMN p_sep_by_space tinyint(1) default 0 after archived" ); >+ } >+ >+ SetVersion( $DBversion ); >+ print "Upgrade to $DBversion done (Bug 4078: Add column currency.p_sep_by_space)\n"; >+} >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index f031503ae8..e62d0c1ea1 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -488,6 +488,7 @@ CREATE TABLE `currency` ( > `rate` float(15,5) default NULL, > `active` tinyint(1) default NULL, > `archived` tinyint(1) DEFAULT 0, >+ `p_sep_by_space` tinyint(1) DEFAULT 0, > PRIMARY KEY (`currency`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > >-- >2.11.0
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 4078
:
7308
|
43320
|
45877
|
45878
|
45888
|
71118
|
71119
|
71120
|
71121
|
71122
|
71123
|
72378
|
72379
|
72380
|
72381
|
72382
|
72383
|
72511
|
72512
|
72513
|
72514
|
72515
|
72516
|
73196