Bugzilla – Attachment 89538 Details for
Bug 20307
Language overlay for authorized values
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 20307: (QA follow-up) Move DB update to perl
Bug-20307-QA-follow-up-Move-DB-update-to-perl.patch (text/plain), 1.87 KB, created by
Martin Renvoize (ashimema)
on 2019-05-10 10:13:11 UTC
(
hide
)
Description:
Bug 20307: (QA follow-up) Move DB update to perl
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2019-05-10 10:13:11 UTC
Size:
1.87 KB
patch
obsolete
>From b97f1fab52281a71cd72b33bd61f453ed1bb5337 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Fri, 10 May 2019 10:13:36 +0100 >Subject: [PATCH] Bug 20307: (QA follow-up) Move DB update to perl > >--- > installer/data/mysql/atomicupdate/bug_20307.perl | 11 +++++++++++ > installer/data/mysql/atomicupdate/bug_20307.sql | 3 --- > 2 files changed, 11 insertions(+), 3 deletions(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_20307.perl > delete mode 100644 installer/data/mysql/atomicupdate/bug_20307.sql > >diff --git a/installer/data/mysql/atomicupdate/bug_20307.perl b/installer/data/mysql/atomicupdate/bug_20307.perl >new file mode 100644 >index 0000000000..4f96e1a0d5 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_20307.perl >@@ -0,0 +1,11 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if ( CheckVersion($DBversion) ) { >+ if ( !column_exists( 'localization', 'interface' ) ) { >+ $dbh->do("ALTER TABLE `localization` ADD COLUMN `interface` VARCHAR(30) DEFAULT NULL AFTER `entity`"); >+ $dbh->do("ALTER TABLE `localization` DROP CONSTRAINT `entity_code_lang`"); >+ $dbh->do("ALTER TABLE `localization` ADD UNIQUE KEY `entity_code_interface_lang` (entity, code, interface, lang)"); >+ } >+ >+ SetVersion($DBversion); >+ print "Upgrade to $DBversion done (Bug 20307 - Update localization table with interface)\n"; >+} >diff --git a/installer/data/mysql/atomicupdate/bug_20307.sql b/installer/data/mysql/atomicupdate/bug_20307.sql >deleted file mode 100644 >index 05ad215edf..0000000000 >--- a/installer/data/mysql/atomicupdate/bug_20307.sql >+++ /dev/null >@@ -1,3 +0,0 @@ >-alter table localization add column interface varchar(30) default null after entity; >-alter table localization drop constraint entity_code_lang; >-alter table localization add unique key entity_code_interface_lang (entity, code, interface, lang); >-- >2.20.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 20307
:
86622
|
86623
|
86624
|
86625
|
86626
|
86627
|
89538
|
91645
|
91646
|
91647
|
91648
|
91649
|
91650
|
91651
|
91653
|
92192
|
92193
|
92359
|
92360
|
92361
|
94245
|
94246
|
94247
|
94248
|
94249
|
94250
|
94251
|
94252
|
94253
|
94254
|
94255
|
94256
|
94700
|
94701
|
94702
|
94703
|
94704
|
94705
|
94706
|
94707
|
94708
|
94709
|
94710
|
94711
|
97074
|
97075
|
98863
|
98864
|
98865
|
98866
|
98867
|
98868
|
98869
|
98870
|
98871
|
98872
|
98873
|
98874
|
98875
|
98876
|
101070
|
101450