Bugzilla – Attachment 96410 Details for
Bug 20352
Add ability of currency/price to have a symbol after amount
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 20352: DB changes
Bug-20352-DB-changes.patch (text/plain), 1.63 KB, created by
Jonathan Druart
on 2019-12-18 11:05:43 UTC
(
hide
)
Description:
Bug 20352: DB changes
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2019-12-18 11:05:43 UTC
Size:
1.63 KB
patch
obsolete
>From fb36a2bfe6eb2fbb5af6f9de368e5f8b926fa2f6 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Wed, 18 Dec 2019 11:44:14 +0100 >Subject: [PATCH] Bug 20352: DB changes > >--- > installer/data/mysql/atomicupdate/bug_20352.perl | 13 +++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 14 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_20352.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_20352.perl b/installer/data/mysql/atomicupdate/bug_20352.perl >new file mode 100644 >index 0000000000..8819d8b2cf >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_20352.perl >@@ -0,0 +1,13 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ if( !column_exists( 'currency', 'p_cs_precedes' ) ) { >+ $dbh->do(q| >+ ALTER TABLE currency >+ ADD COLUMN p_cs_precedes tinyint(1) DEFAULT 1 >+ AFTER p_sep_by_space >+ |); >+ } >+ >+ SetVersion( $DBversion ); >+ print "Upgrade to $DBversion done (Bug 20352 - Add column currency.p_cs_precedes)\n"; >+} >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 67495ab962..31f9b4c8b0 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -432,6 +432,7 @@ CREATE TABLE `currency` ( > `active` tinyint(1) default NULL, > `archived` tinyint(1) DEFAULT 0, > `p_sep_by_space` tinyint(1) DEFAULT 0, >+ `p_cs_precedes` tinyint(1) DEFAULT 1, > PRIMARY KEY (`currency`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_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 20352
:
96410
|
96411
|
96412
|
98234
|
98235
|
98236
|
103924
|
103925
|
103926
|
103927