Attachment #156595 for bug #34328

View | Details | Raw Unified | Return to bug 34328
Collapse All | Expand All




    up          => sub {
        my ($args) = @_;
        my ( $dbh, $out ) = @$args{qw(dbh out)};

        # Unique key on subtag + code.. use INSERT IGNORE
        $dbh->do(q{
            INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
            VALUES ( 'gd','gla' )
        });

        # Unique key on subtag + type.. use INSERT IGNORE
        $dbh->do(q{
            INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added)
            VALUES ( 'gd', 'language', 'Scottish Gaelic', NOW() )
        });

        # Unique key on subtag + type + lang.. use INSERT IGNORE
        $dbh->do(q{
            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic')
        });

        $dbh->do(q{
            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'gd', 'language', 'en_GB', 'Scottish Gaelic')
        });

        $dbh->do(q{
            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'gd', 'language', 'gd', 'Gàidhlig')
        });

        $dbh->do(q{
            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'gd', 'language', 'fr', 'Gaélique écossais')
        });

        $dbh->do(q{
            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'gd', 'language', 'de', 'Schottisch-Gälisch')
        });

        $dbh->do(q{
            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'gd', 'language', 'pl', 'Język szkocki gaelicki')
        });

- 

Return to bug 34328

Lines 6-48 return { Link Here

(-)a/installer/data/mysql/atomicupdate/bug_34328.pl (-9 / +12 lines)
6	up => sub {	6	up => sub {
7	my ($args) = @_;	7	my ($args) = @_;
8	my ( $dbh, $out ) = @$args{qw(dbh out)};	8	my ( $dbh, $out ) = @$args{qw(dbh out)};
		9
		10	# Unique key on subtag + code.. use INSERT IGNORE
9	$dbh->do(q{	11	$dbh->do(q{
10	INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)	12	INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
11	VALUES ( 'gd','gla' )	13	VALUES ( 'gd','gla' )
12	});	14	});
13		15
		16	# Unique key on subtag + type.. use INSERT IGNORE
14	$dbh->do(q{	17	$dbh->do(q{
15	INSERT INTO language_subtag_registry( subtag, type, description, added)	18	INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added)
16	VALUES ( 'gd', 'language', 'Scottish Gaelic', NOW() )	19	VALUES ( 'gd', 'language', 'Scottish Gaelic', NOW() )
17	});	20	});
18		21
		22	# Unique key on subtag + type + lang.. use INSERT IGNORE
19	$dbh->do(q{	23	$dbh->do(q{
20	INSERT INTO language_descriptions(subtag, type, lang, description)	24	INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
21	VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic')	25	VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic')
22	});	26	});
23		27
24	$dbh->do(q{	28	$dbh->do(q{
25	INSERT INTO language_descriptions(subtag, type, lang, description)	29	INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
26	VALUES ( 'gd', 'language', 'en_GB', 'Scottish Gaelic')	30	VALUES ( 'gd', 'language', 'en_GB', 'Scottish Gaelic')
27	});	31	});
28		32
29	$dbh->do(q{	33	$dbh->do(q{
30	INSERT INTO language_descriptions(subtag, type, lang, description)	34	INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
31	VALUES ( 'gd', 'language', 'gd', 'Gàidhlig')	35	VALUES ( 'gd', 'language', 'gd', 'Gàidhlig')
32	});	36	});
33		37
34	$dbh->do(q{	38	$dbh->do(q{
35	INSERT INTO language_descriptions(subtag, type, lang, description)	39	INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
36	VALUES ( 'gd', 'language', 'fr', 'Gaélique écossais')	40	VALUES ( 'gd', 'language', 'fr', 'Gaélique écossais')
37	});	41	});
38		42
39	$dbh->do(q{	43	$dbh->do(q{
40	INSERT INTO language_descriptions(subtag, type, lang, description)	44	INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
41	VALUES ( 'gd', 'language', 'de', 'Schottisch-Gälisch')	45	VALUES ( 'gd', 'language', 'de', 'Schottisch-Gälisch')
42	});	46	});
43		47
44	$dbh->do(q{	48	$dbh->do(q{
45	INSERT INTO language_descriptions(subtag, type, lang, description)	49	INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
46	VALUES ( 'gd', 'language', 'pl', 'Język szkocki gaelicki')	50	VALUES ( 'gd', 'language', 'pl', 'Język szkocki gaelicki')
47	});	51	});
48		52
49	-