Bugzilla – Attachment 128435 Details for
Bug 29631
21.06.000.12 may fail
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 29631: (QA follow-up) Add missing cleanups
Bug-29631-QA-follow-up-Add-missing-cleanups.patch (text/plain), 1.84 KB, created by
Tomás Cohen Arazi (tcohen)
on 2021-12-13 10:28:09 UTC
(
hide
)
Description:
Bug 29631: (QA follow-up) Add missing cleanups
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi (tcohen)
Created:
2021-12-13 10:28:09 UTC
Size:
1.84 KB
patch
obsolete
>From ec09410318e417ce4dd4dcb522ed077f31acb86d Mon Sep 17 00:00:00 2001 >From: Tomas Cohen Arazi <tomascohen@theke.io> >Date: Mon, 13 Dec 2021 07:27:28 -0300 >Subject: [PATCH] Bug 29631: (QA follow-up) Add missing cleanups > >Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> >--- > installer/data/mysql/db_revs/210600012.pl | 20 ++++++++++++++++++++ > 1 file changed, 20 insertions(+) > >diff --git a/installer/data/mysql/db_revs/210600012.pl b/installer/data/mysql/db_revs/210600012.pl >index 361a6056fc..673b43b646 100755 >--- a/installer/data/mysql/db_revs/210600012.pl >+++ b/installer/data/mysql/db_revs/210600012.pl >@@ -24,6 +24,17 @@ return { > }; > > if( !unique_key_exists( 'language_descriptions', 'uniq_desc' ) ) { >+ >+ $dbh->do(q{ >+ DELETE a >+ FROM language_descriptions AS a, language_descriptions AS b >+ WHERE a.id < b.id >+ AND a.subtag IS NOT NULL >+ AND a.subtag=b.subtag >+ AND a.lang IS NOT NULL >+ AND a.lang=b.lang >+ AND a.type=b.type >+ }); > $dbh->do(q{ > ALTER TABLE language_descriptions > ADD UNIQUE KEY uniq_desc (subtag, type, lang) >@@ -31,6 +42,15 @@ return { > }; > > if( !unique_key_exists( 'language_rfc4646_to_iso639', 'uniq_code' ) ) { >+ >+ $dbh->do(q{ >+ DELETE a >+ FROM language_rfc4646_to_iso639 AS a, language_rfc4646_to_iso639 AS b >+ WHERE a.id < b.id >+ AND a.rfc4646_subtag IS NOT NULL >+ AND a.rfc4646_subtag=b.rfc4646_subtag >+ AND a.iso639_2_code=b.iso639_2_code >+ }); > $dbh->do(q{ > ALTER TABLE language_rfc4646_to_iso639 > ADD UNIQUE KEY uniq_code (rfc4646_subtag, iso639_2_code) >-- >2.34.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 29631
:
128209
|
128214
|
128238
|
128434
| 128435