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

(-)a/C4/Installer.pm (-2 / +86 lines)
Lines 24-29 our $VERSION = 3.07.00.049; Link Here
24
use C4::Context;
24
use C4::Context;
25
use C4::Installer::PerlModules;
25
use C4::Installer::PerlModules;
26
26
27
use constant GLOBAL_SQL_FOLDER => 'en';
28
27
=head1 NAME
29
=head1 NAME
28
30
29
C4::Installer
31
C4::Installer
Lines 465-470 Runs a the specified SQL using the DB's command-line Link Here
465
SQL tool, and returns any strings sent to STDERR
467
SQL tool, and returns any strings sent to STDERR
466
by the command-line tool.
468
by the command-line tool.
467
469
470
Additionally: if it detects a global counterpart for this SQL file, it runs
471
that file first (inserting english records) and updates for translation.
472
468
B<FIXME:> there has been a long-standing desire to
473
B<FIXME:> there has been a long-standing desire to
469
replace this with an SQL loader that goes
474
replace this with an SQL loader that goes
470
through DBI; partly for portability issues
475
through DBI; partly for portability issues
Lines 481-487 sub load_sql { Link Here
481
    my $filename = shift;
486
    my $filename = shift;
482
487
483
    my $datadir = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}";
488
    my $datadir = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}";
484
    my $error;
489
    my $error='';
485
    my $strcmd;
490
    my $strcmd;
486
    my $cmd;
491
    my $cmd;
487
    if ( $self->{dbms} eq 'mysql' ) {
492
    if ( $self->{dbms} eq 'mysql' ) {
Lines 495-501 sub load_sql { Link Here
495
            . ( $self->{user}     ? " -u $self->{user} "     : "" )
500
            . ( $self->{user}     ? " -u $self->{user} "     : "" )
496
            . ( $self->{password} ? " -p'$self->{password}'"   : "" )
501
            . ( $self->{password} ? " -p'$self->{password}'"   : "" )
497
            . " $self->{dbname} ";
502
            . " $self->{dbname} ";
498
        $error = qx($strcmd --default-character-set=utf8 <$filename 2>&1 1>/dev/null);
503
        my $globalfile= _find_global_mysql_counterpart($filename, $datadir);
504
            #check if there is a global counterpart
505
            #in that case we english-insert first and language-update second
506
        $error.= _run_mysql_file($strcmd, $globalfile) if $globalfile;
507
        $error.= _run_mysql_file($strcmd, $filename);
499
    } elsif ( $self->{dbms} eq 'Pg' ) {
508
    } elsif ( $self->{dbms} eq 'Pg' ) {
500
        $cmd = qx(which psql 2>/dev/null || whereis psql 2>/dev/null);
509
        $cmd = qx(which psql 2>/dev/null || whereis psql 2>/dev/null);
501
        chomp $cmd;
510
        chomp $cmd;
Lines 520-525 sub load_sql { Link Here
520
    return $error;
529
    return $error;
521
}
530
}
522
531
532
sub _run_mysql_file {
533
    my ($cmd, $file)= @_;
534
warn "L532: $file";
535
    return qx($cmd --default-character-set=utf8 <$file 2>&1 1>/dev/null);
536
}
537
538
sub _find_global_mysql_counterpart {
539
# checks for a global counterpart file to be run before the lang sql file
540
# note ALSO that we are still in the process of converting files
541
# this is reflected in the contents of $counterpart
542
    my ($fullpath, $datadir)= @_;
543
    my ($lang, $sub, $file)=
544
        _parse_sqlpath( substr( $fullpath, length($datadir)));
545
    my $counterpart= _load_counterpart($lang);
546
547
    if(defined $counterpart ) {
548
        my $global= $datadir.'/'.GLOBAL_SQL_FOLDER.'/'.
549
            ($counterpart->{$sub}//$sub).'/'.
550
            ($counterpart->{$file}//$file);
551
        return $global if $global && -e $global;
552
    }
553
    return;
554
}
555
556
sub _parse_sqlpath { #extract language, subfolder, filename
557
    my $path= shift;
558
    if( $path =~ /^\/?([^\/]+)\/(.*)\/([^\/]+)$/ ) {
559
        return ($1, $2, $3);
560
    }
561
    return;
562
}
563
564
sub _load_counterpart {
565
    #TODO: Work in progress for other languages
566
    #Started with de-DE/mandatory sql files
567
    my $lang= shift||'';
568
    my $hashref;
569
570
    if( $lang =~ /de-DE/ ) { #German: no filename changes
571
        $hashref= {
572
            'marcflavour/marc21/mandatory' => 'skip_for_now',
573
            'marcflavour/marc21/optional' => 'skip_for_now',
574
            optional => 'skip_for_now',
575
                #only de-DE/mandatory will be found for now
576
        };
577
            #this is enough to get it running without name conversions
578
    }
579
    elsif( $lang eq 'en' ) { #English: no filename changes
580
        return undef; # as long as we do not have a separate global folder
581
582
        #TODO: Should we use en as global folder? Or have a global folder too?
583
        #The global folder should contain inserts.
584
        #The en folder would have updates and serve as a translation basis?
585
    }
586
    elsif( $lang =~ /es-ES/ ) { #Spanish
587
    }
588
    elsif( $lang =~ /fr-FR/ ) { #French: filename changes
589
        $hashref= {
590
            '1-Obligatoire' => 'mandatory',
591
        };
592
        return undef; # not in use yet
593
    }
594
    elsif( $lang =~ /it-IT/ ) { #Italian
595
    }
596
    elsif( $lang =~ /nb-NO/ ) { #Norwegian
597
    }
598
    elsif( $lang =~ /pl-PL/ ) { #Polish
599
    }
600
    elsif( $lang =~ /ru-RU/ ) { #Russian
601
    }
602
    elsif( $lang =~ /uk-UA/ ) { #Ukrainian
603
    }
604
    return $hashref;
605
}
606
523
=head2 get_file_path_from_name
607
=head2 get_file_path_from_name
524
608
525
  my $filename = $installer->get_file_path_from_name('script_name');
609
  my $filename = $installer->get_file_path_from_name('script_name');
(-)a/installer/data/mysql/de-DE/mandatory/class_sources.sql (-11 / +27 lines)
Lines 20-36 Link Here
20
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
20
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
21
21
22
-- class sorting (filing) rules
22
-- class sorting (filing) rules
23
INSERT INTO `class_sort_rules` (`class_sort_rule`, `description`, `sort_routine`) VALUES
23
UPDATE class_sort_rules SET
24
                               ('dewey', 'Standard-Sortierregeln für DDC', 'Dewey'),
24
    description = 'Standard-Sortierregeln für DDC'
25
                               ('lcc', 'Standard-Sortierregeln für LCC', 'LCC'),
25
WHERE class_sort_rule = 'dewey';
26
                               ('generic', 'Generische Sortierregeln für Signaturen', 'Generic');
26
UPDATE class_sort_rules SET
27
    description = 'Standard-Sortierregeln für LCC'
28
WHERE class_sort_rule = 'lcc';
29
UPDATE class_sort_rules SET
30
    description = 'Generische Sortierregeln für Signaturen'
31
WHERE class_sort_rule = 'generic';
27
32
28
33
29
-- classification schemes or sources
34
-- classification schemes or sources
30
INSERT INTO `class_sources` (`cn_source`, `description`, `used`, `class_sort_rule`) VALUES
35
UPDATE class_sources SET
31
                            ('ddc', 'Dewey-Decimalklassifikation (DDC)', 1, 'dewey'),
36
    description = 'Dewey-Decimalklassifikation (DDC)'
32
                            ('lcc', 'Klassifikation der Library of Congress (LCC)', 1, 'lcc'),
37
WHERE cn_source = 'ddc';
33
                            ('udc', 'Universelle Dezimalklassifikation (UDC)', 0, 'generic'),
38
UPDATE class_sources SET
34
                            ('sudocs', 'SuDoc-Klassifikation (U.S. GPO)', 0, 'generic'),
39
    description = 'Klassifikation der Library of Congress (LCC)'
35
                            ('anscr', 'ANSCR (Tonaufnahmen)', 0, 'generic'),
40
WHERE cn_source = 'lcc';
36
                            ('z', 'Andere/Generische Klassifikation', 0, 'generic');
41
UPDATE class_sources SET
42
    description = 'Universelle Dezimalklassifikation (UDC)'
43
WHERE cn_source = 'udc';
44
UPDATE class_sources SET
45
    description = 'SuDoc-Klassifikation (U.S. GPO)'
46
WHERE cn_source = 'sudocs';
47
UPDATE class_sources SET
48
    description = 'ANSCR (Tonaufnahmen)'
49
WHERE cn_source = 'anscr';
50
UPDATE class_sources SET
51
    description = 'Andere/Generische Klassifikation'
52
WHERE cn_source = 'z';
(-)a/installer/data/mysql/de-DE/mandatory/message_transport_types.sql (-7 / +3 lines)
Lines 1-7 Link Here
1
INSERT INTO message_transport_types
1
-- At this moment this file is just a placeholder for the global sql file
2
(message_transport_type)
2
-- with the same name. No translation is needed for now.
3
values
3
-- Do NOT delete this file. The webinstaller needs it to exist.
4
('email'),
5
('print'),
6
('sms'),
7
('feed');
(-)a/installer/data/mysql/de-DE/mandatory/sample_notices.sql (-33 / +125 lines)
Lines 1-25 Link Here
1
INSERT INTO `letter` (module, code, name, title, content) 
1
UPDATE letter SET
2
VALUES ('circulation','ODUE','Mahnung','Mahnung','Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\n\nNach unseren Unterlagen haben Sie Medien entliehen, die nun überfällig geworden sind. Unsere Bibliothek erhebt keine Mahngebühren, bitte geben Sie die entliehenen Medien schnellstmöglich zurück.\n\n<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>> <<branches.branchaddress3>>\nTelefon: <<branches.branchphone>>\nFax: <<branches.branchfax>>\nEmail: <<branches.branchemail>>\n\nSie können die überfälligen Medien soweit möglich auch direkt über Ihr Benutzerkonto online verlängern. Wenn ein Medium länger als 30 Tage überfällig ist, wird Ihr Benutzeraccount gesperrt und Sie können keine Medien mehr entleihen.\n\nDie folgenden Medien sind zur Zeit überfällig:\n\n<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Gebühr: <<items.fine>></item>\n\nVielen Dank für die schnelle Erledigung.\n\n< Ihr Bibliotheksteam\n'),
2
    name = 'Mahnung',
3
('claimacquisition','ACQCLAIM','Reklamation (Erwerbung)','Titel nicht eingetroffen','<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<aqorders.title>>) (<<aqorders.quantity>> bestellt) (je $<<aqorders.listprice>> €) sind nicht eingetroffen.</order>'),
3
    title = 'Mahnung',
4
('serial','RLIST','Neues Heft zugegangen','Zeitschrift ist jetzt verfügbar','<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nDas folgende Heft ist jetzt verfügbar:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nBitte holen Sie es sobald möglich ab.'),
4
    content = 'Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\n\nNach unseren Unterlagen haben Sie Medien entliehen, die nun überfällig geworden sind. Unsere Bibliothek erhebt keine Mahngebühren, bitte geben Sie die entliehenen Medien schnellstmöglich zurück.\n\n<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>> <<branches.branchaddress3>>\nTelefon: <<branches.branchphone>>\nFax: <<branches.branchfax>>\nEmail: <<branches.branchemail>>\n\nSie können die überfälligen Medien soweit möglich auch direkt über Ihr Benutzerkonto online verlängern. Wenn ein Medium länger als 30 Tage überfällig ist, wird Ihr Benutzeraccount gesperrt und Sie können keine Medien mehr entleihen.\n\nDie folgenden Medien sind zur Zeit überfällig:\n\n<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Gebühr: <<items.fine>></item>\n\nVielen Dank für die schnelle Erledigung.\n\n< Ihr Bibliotheksteam\n'
5
('members','ACCTDETAILS','Kontoinformationen - Standard','Ihr neues Benutzerkonto','Liebe/r <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>.\r\n\r\nDie Daten Ihres neuen Benutzerkontos sind:\r\n\r\nBenutzer:  <<borrowers.userid>>\r\nPasswort: <<borrowers.password>>\r\n\r\nWenn Sie Probleme in Hinsicht auf Ihr Benutzerkonto haben, wenden Sie sich bitte an die Bibliothek.\r\n\r\nVielen Dank,\r\nIhr Bibliotheksteam'), 
5
WHERE module = 'circulation' AND code = 'ODUE';
6
('circulation','DUE','Fälligkeitsbenachrichtigung','Fälligkeitsbenachrichtigung','Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nDie folgenden Medien sind ab heute fällig:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'), 
6
UPDATE letter SET
7
('circulation','DUEDGST','Fälligkeitsbenachrichtigung (Zusammenfassung)','Fälligkeitsbenachrichtigung','Sie haben <<count>> überfällige Medien.'), 
7
    name = 'Reklamation (Erwerbung)',
8
('circulation','PREDUE','Erinnerungsbenachrichtigung','Erinnerungsbenachrichtigung','Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFolgende Ausleihe wird bald fällig:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'), 
8
    title = 'Titel nicht eingetroffen',
9
('circulation','PREDUEDGST','Erinnerungsbenachrichtigung (Zusammenfassung)','Erinnerungsbenachrichtigung','Sie haben <<count>> Ausleihen, die bald fällig werden.'),
9
    content = '<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<aqorders.title>>) (<<aqorders.quantity>> bestellt) (je $<<aqorders.listprice>> €) sind nicht eingetroffen.</order>'
10
('circulation','RENEWAL','Verlängerungsbenachrichtigung','Verlängerungsquittung','Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFolgede Exemplare wurden verlängert:\r\n----\r\n<<biblio.title>>\r\n----\r\nVielen Dank,\r\n<<branches.branchname>>.'),
10
WHERE module = 'claimacquisition' AND code = 'ACQCLAIM';
11
('reserves', 'HOLD', 'Vormerkbenachrichtigung', 'Vormerkung abholbereit in <<branches.branchname>>', 'Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFür Sie liegt seit <<reserves.waitingdate>> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <<biblio.title>>\r\nVerfasser: <<biblio.author>>\r\nExemplar: <<items.copynumber>>\r\nStandort: <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>'),
11
UPDATE letter SET
12
('reserves', 'HOLD_PRINT', 'Vormerkbenachrichtigung (Print)', 'Vormerkbenachrichtigung (Print)', '<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchzip>> <<branches.branchcity>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.address2>>\r\n<<borrowers.zipcode>> <<borrowers.city>>\r\n<<borrowers.country>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nLiebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFür Sie liegt seit dem <<reserves.waitingdate>> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <<biblio.title>>\r\nVerfasser: <<biblio.author>>\r\nSignatur: <<items.itemcallnumber>>\r\n'),
12
    name = 'Neues Heft zugegangen',
13
('circulation','CHECKIN','Rückgabequittung (Zusammenfassung)','Rückgabequittung','Die folgenden Medien wurden zurückgegeben:\r\n----\r\n<<biblio.title>>\r\n----\r\nVielen Dank.'),
13
    title = 'Zeitschrift ist jetzt verfügbar',
14
('circulation','CHECKOUT','Ausleihquittung (Zusammenfassung)','Ausleihquittung','Die folgenden Medien wurden entliehen:\r\n----\r\n<<biblio.title>>\r\n----\r\nVielen Dank für Ihren Besuch in <<branches.branchname>>.'),
14
    content = '<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nDas folgende Heft ist jetzt verfügbar:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nBitte holen Sie es sobald möglich ab.'
15
('reserves', 'HOLDPLACED', 'Neue Vormerkung', 'Neue Vormerkung','Folgender Titel wurde vorgemerkt: <<biblio.title>> (<<biblio.biblionumber>>) durch den Benutzer <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).'),
15
WHERE module = 'serial' AND code = 'RLIST';
16
('suggestions','ACCEPTED','Anschaffungsvorschlag wurde angenommen', 'Ihr Anschaffungsvorschlag wurde angenommen','Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <<suggestions.title>> by <<suggestions.author>>.\n\nDie Bibliothek hat diesen Titel heute recherchiert und wird Ihn sobald wie möglich im Buchhandel bestellen. Sie erhalten Nachricht, sobald die Bestellung abgeschlossen ist und sobald der Titel in der Bibliotek verfügbar ist.\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'),
16
UPDATE letter SET
17
('suggestions','AVAILABLE','Vorgeschlagenes Medium verfügbar', 'Das vorgeschlagene Medium ist jetzt verfügbar','Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <<suggestions.title>> von <<suggestions.author>>.\n\nWir freuen uns Ihnen mitteilen zu können, dass dieser Titel jetzt im Bestand der Bibliothek verfügbar ist.\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'),
17
    name = 'Kontoinformationen - Standard',
18
('suggestions','ORDERED','Vorgeschlagenes Medium bestellt', 'Das vorgeschlagene Medium wurde im Buchhandel bestellt','Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlaten: <<suggestions.title>> von <<suggestions.author>>.\n\nWir freuen uns Ihnen mitteilen zu können, dass dieser Titel jetzt im Buchhandel bestellt wurde. Nach Eintreffen wird er in unseren Bestand eingearbeitet.\n\nSie erhalten Nachricht, sobald das Medium verfügbar ist.\n\nBei Nachfragen erreichen Sie uns unter der Emailadresse <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'),
18
    title = 'Ihr neues Benutzerkonto',
19
('suggestions','REJECTED','Anschaffungsvorschlag nicht angenommen', 'Ihr Anschaffungsvorschlag wurde nicht angenommen','Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haven der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <<suggestions.title>> von <<suggestions.author>>.\n\nDie Bibliothek hat diesen Titel heute recherchiert und sich gegen eine Anschaffung entschieden.\n\nBegründung: <<suggestions.reason>>\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>');
19
    content = 'Liebe/r <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>.\r\n\r\nDie Daten Ihres neuen Benutzerkontos sind:\r\n\r\nBenutzer:  <<borrowers.userid>>\r\nPasswort: <<borrowers.password>>\r\n\r\nWenn Sie Probleme in Hinsicht auf Ihr Benutzerkonto haben, wenden Sie sich bitte an die Bibliothek.\r\n\r\nVielen Dank,\r\nIhr Bibliotheksteam'
20
20
WHERE module = 'members' AND code = 'ACCTDETAILS';
21
INSERT INTO `letter` (module, code, name, title, content, is_html)
21
UPDATE letter SET
22
VALUES ('circulation','ISSUESLIP','Ausleihquittung (Quittungsdruck)','Ausleihquittung (Quittungsdruck)', '<h3><<branches.branchname>></h3>
22
    name = 'Fälligkeitsbenachrichtigung',
23
    title = 'Fälligkeitsbenachrichtigung',
24
    content = 'Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nDie folgenden Medien sind ab heute fällig:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'
25
WHERE module = 'circulation' AND code = 'DUE';
26
UPDATE letter SET
27
    name = 'Fälligkeitsbenachrichtigung (Zusammenfassung)',
28
    title = 'Fälligkeitsbenachrichtigung',
29
    content = 'Sie haben <<count>> überfällige Medien.'
30
WHERE module = 'circulation' AND code = 'DUEDGST';
31
UPDATE letter SET
32
    name = 'Erinnerungsbenachrichtigung',
33
    title = 'Erinnerungsbenachrichtigung',
34
    content = 'Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFolgende Ausleihe wird bald fällig:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'
35
WHERE module = 'circulation' AND code = 'PREDUE';
36
UPDATE letter SET
37
    name = 'Erinnerungsbenachrichtigung (Zusammenfassung)',
38
    title = 'Erinnerungsbenachrichtigung',
39
    content = 'Sie haben <<count>> Ausleihen, die bald fällig werden.'
40
WHERE module = 'circulation' AND code = 'PREDUEDGST';
41
UPDATE letter SET
42
    name = 'Verlängerungsbenachrichtigung',
43
    title = 'Verlängerungsquittung',
44
    content = 'Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFolgede Exemplare wurden verlängert:\r\n----\r\n<<biblio.title>>\r\n----\r\nVielen Dank,\r\n<<branches.branchname>>.'
45
WHERE module = 'circulation' AND code = 'RENEWAL';
46
UPDATE letter SET
47
    name = 'Vormerkbenachrichtigung',
48
    title = 'Vormerkung abholbereit in <<branches.branchname>>',
49
    content = 'Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFür Sie liegt seit <<reserves.waitingdate>> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <<biblio.title>>\r\nVerfasser: <<biblio.author>>\r\nExemplar: <<items.copynumber>>\r\nStandort: <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>'
50
WHERE module = 'reserves' AND code = 'HOLD';
51
UPDATE letter SET
52
    name = 'Vormerkbenachrichtigung (Print)',
53
    title = 'Vormerkbenachrichtigung (Print)',
54
    content = '<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchzip>> <<branches.branchcity>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.address2>>\r\n<<borrowers.zipcode>> <<borrowers.city>>\r\n<<borrowers.country>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nLiebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFür Sie liegt seit dem <<reserves.waitingdate>> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <<biblio.title>>\r\nVerfasser: <<biblio.author>>\r\nSignatur: <<items.itemcallnumber>>\r\n'
55
WHERE module = 'reserves' AND code = 'HOLD_PRINT';
56
UPDATE letter SET
57
    name = 'Rückgabequittung (Zusammenfassung)',
58
    title = 'Rückgabequittung',
59
    content = 'Die folgenden Medien wurden zurückgegeben:\r\n----\r\n<<biblio.title>>\r\n----\r\nVielen Dank.'
60
WHERE module = 'circulation' AND code = 'CHECKIN';
61
UPDATE letter SET
62
    name = 'Ausleihquittung (Zusammenfassung)',
63
    title = 'Ausleihquittung',
64
    content = 'Die folgenden Medien wurden entliehen:\r\n----\r\n<<biblio.title>>\r\n----\r\nVielen Dank für Ihren Besuch in <<branches.branchname>>.'
65
WHERE module = 'circulation' AND code = 'CHECKOUT';
66
UPDATE letter SET
67
    name = 'Neue Vormerkung',
68
    title = 'Neue Vormerkung',
69
    content = 'Folgender Titel wurde vorgemerkt: <<biblio.title>> (<<biblio.biblionumber>>) durch den Benutzer <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).'
70
WHERE module = 'reserves' AND code = 'HOLDPLACED';
71
UPDATE letter SET
72
    name = 'Anschaffungsvorschlag wurde angenommen',
73
    title = 'Ihr Anschaffungsvorschlag wurde angenommen',
74
    content = 'Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <<suggestions.title>> by <<suggestions.author>>.\n\nDie Bibliothek hat diesen Titel heute recherchiert und wird Ihn sobald wie möglich im Buchhandel bestellen. Sie erhalten Nachricht, sobald die Bestellung abgeschlossen ist und sobald der Titel in der Bibliotek verfügbar ist.\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'
75
WHERE module = 'suggestions' AND code = 'ACCEPTED';
76
UPDATE letter SET
77
    name = 'Vorgeschlagenes Medium verfügbar',
78
    title = 'Das vorgeschlagene Medium ist jetzt verfügbar',
79
    content = 'Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <<suggestions.title>> von <<suggestions.author>>.\n\nWir freuen uns Ihnen mitteilen zu können, dass dieser Titel jetzt im Bestand der Bibliothek verfügbar ist.\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'
80
WHERE module = 'suggestions' AND code = 'AVAILABLE';
81
UPDATE letter SET
82
    name = 'Vorgeschlagenes Medium bestellt',
83
    title = 'Das vorgeschlagene Medium wurde im Buchhandel bestellt',
84
    content = 'Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlaten: <<suggestions.title>> von <<suggestions.author>>.\n\nWir freuen uns Ihnen mitteilen zu können, dass dieser Titel jetzt im Buchhandel bestellt wurde. Nach Eintreffen wird er in unseren Bestand eingearbeitet.\n\nSie erhalten Nachricht, sobald das Medium verfügbar ist.\n\nBei Nachfragen erreichen Sie uns unter der Emailadresse <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'
85
WHERE module = 'suggestions' AND code = 'ORDERED';
86
UPDATE letter SET
87
    name = 'Anschaffungsvorschlag nicht angenommen',
88
    title = 'Ihr Anschaffungsvorschlag wurde nicht angenommen',
89
    content = 'Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haven der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <<suggestions.title>> von <<suggestions.author>>.\n\nDie Bibliothek hat diesen Titel heute recherchiert und sich gegen eine Anschaffung entschieden.\n\nBegründung: <<suggestions.reason>>\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'
90
WHERE module = 'suggestions' AND code = 'REJECTED';
91
92
UPDATE letter SET
93
    name = 'Ausleihquittung (Quittungsdruck)',
94
    title = 'Ausleihquittung (Quittungsdruck)',
95
    content = '<h3><<branches.branchname>></h3>
23
Ausleihe an: <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
96
Ausleihe an: <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
24
(<<borrowers.cardnumber>>) <br />
97
(<<borrowers.cardnumber>>) <br />
25
98
Lines 53-60 Fällig am: <<issues.date_due>><br /> Link Here
53
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.timestamp>></p>
126
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.timestamp>></p>
54
<hr />
127
<hr />
55
</div>
128
</div>
56
</news>', 1),
129
</news>',
57
('circulation','ISSUEQSLIP','Kurzquittung','Kurzquittung', '<h3><<branches.branchname>></h3>
130
    is_html = 1
131
WHERE module = 'circulation' AND code = 'ISSUESLIP';
132
UPDATE letter SET
133
    name = 'Kurzquittung',
134
    title = 'Kurzquittung',
135
    content = '<h3><<branches.branchname>></h3>
58
Ausleihe an: <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
136
Ausleihe an: <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
59
(<<borrowers.cardnumber>>) <br />
137
(<<borrowers.cardnumber>>) <br />
60
138
Lines 67-74 Ausleihe an: <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname> Link Here
67
Barcode: <<items.barcode>><br />
145
Barcode: <<items.barcode>><br />
68
Fällig am: <<issues.date_due>><br />
146
Fällig am: <<issues.date_due>><br />
69
</p>
147
</p>
70
</checkedout>', 1),
148
</checkedout>',
71
('circulation','RESERVESLIP','Vormerkquittung','Vormerkquittung', '<h5>Datum: <<today>></h5>
149
    is_html = 1
150
WHERE module = 'circulation' AND code = 'ISSUEQSLIP';
151
UPDATE letter SET
152
    name = 'Vormerkquittung',
153
    title = 'Vormerkquittung',
154
    content = '<h5>Datum: <<today>></h5>
72
155
73
<h3> Bereitstellung in <<branches.branchname>></h3>
156
<h3> Bereitstellung in <<branches.branchname>></h3>
74
157
Lines 95-102 Fällig am: <<issues.date_due>><br /> Link Here
95
<p>Notiz:
178
<p>Notiz:
96
<pre><<reserves.reservenotes>></pre>
179
<pre><<reserves.reservenotes>></pre>
97
</p>
180
</p>
98
', 1),
181
',
99
('circulation','TRANSFERSLIP','Transportquittung','Transportquittung', '<h5>Datum: <<today>></h5>
182
    is_html = 1
183
WHERE module = 'circulation' AND code = 'RESERVESLIP';
184
UPDATE letter SET
185
    name = 'Transportquittung',
186
    title = 'Transportquittung',
187
    content = '<h5>Datum: <<today>></h5>
100
188
101
<h3>Transport nach <<branches.branchname>></h3>
189
<h3>Transport nach <<branches.branchname>></h3>
102
190
Lines 106-116 Fällig am: <<issues.date_due>><br /> Link Here
106
<ul>
194
<ul>
107
   <li><<items.barcode>></li>
195
   <li><<items.barcode>></li>
108
   <li><<items.itemcallnumber>></li>
196
   <li><<items.itemcallnumber>></li>
109
</ul>', 1);
197
</ul>',
198
    is_html = 1
199
WHERE module = 'circulation' AND code = 'TRANSFERSLIP';
110
200
111
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
201
UPDATE letter SET
112
VALUES (
202
    name = 'Bestätigung der Anmeldung zur Bibliotheksnutzung',
113
'members',  'OPAC_REG_VERIFY',  '',  'Bestätigung der Anmeldung zur Bibliotheksnutzung',  '1',  'Verify Your Account',  'Guten Tag,
203
    is_html = '1',
204
    title = 'Verify Your Account',
205
    content = 'Guten Tag,
114
206
115
Ihr Bibliothekskonto wurde angelegt. Bitte bestätigen Sie Ihre Emailadresse, indem Sie auf folgenden Link klicken:
207
Ihr Bibliothekskonto wurde angelegt. Bitte bestätigen Sie Ihre Emailadresse, indem Sie auf folgenden Link klicken:
116
208
Lines 120-123 Wenn Sie keine Kontoanmeldung durchgeführt haben, können Sie diese Benachricht Link Here
120
212
121
Vielen Dank,
213
Vielen Dank,
122
Ihr Bibliotheksteam'
214
Ihr Bibliotheksteam'
123
);
215
WHERE module = 'members' AND code = 'OPAC_REG_VERIFY';
(-)a/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql (-8 / +3 lines)
Lines 1-8 Link Here
1
insert into `message_attributes`
1
-- At this moment this file is just a placeholder for the global sql file
2
(`message_attribute_id`, message_name, `takes_days`)
2
-- with the same name. No translation is needed for now.
3
values
3
-- Do NOT delete this file. The webinstaller needs it to exist.
4
(1, 'Item_Due', 0),
5
(2, 'Advance_Notice', 1),
6
(4, 'Hold_Filled', 0),
7
(5, 'Item_Check_in', 0),
8
(6, 'Item_Checkout', 0);
(-)a/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql (-17 / +3 lines)
Lines 1-17 Link Here
1
insert into `message_transports`
1
-- At this moment this file is just a placeholder for the global sql file
2
(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
2
-- with the same name. No translation is needed for now.
3
values
3
-- Do NOT delete this file. The webinstaller needs it to exist.
4
(1, 'email', 0, 'circulation', 'DUE'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
6
(2, 'email', 0, 'circulation', 'PREDUE'),
7
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
8
(4, 'email', 0, 'reserves',    'HOLD'),
9
(1, 'sms',   0, 'circulation', 'DUE'),
10
(1, 'sms',   1, 'circulation', 'DUEDGST'),
11
(2, 'sms',   0, 'circulation', 'PREDUE'),
12
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
13
(4, 'sms',   0, 'reserves',    'HOLD'),
14
(5, 'email', 0, 'circulation', 'CHECKIN'),
15
(5, 'sms',   0, 'circulation', 'CHECKIN'),
16
(6, 'email', 0, 'circulation', 'CHECKOUT'),
17
(6, 'sms',   0, 'circulation', 'CHECKOUT');
(-)a/installer/data/mysql/de-DE/mandatory/stopwords.sql (-99 / +3 lines)
Lines 1-99 Link Here
1
INSERT INTO stopwords VALUES
1
-- At this moment this file is just a placeholder for the global sql file
2
('a'),
2
-- with the same name. No translation is needed for now.
3
('about'),
3
-- Do NOT delete this file. The webinstaller needs it to exist.
4
('also'),
5
('an'),
6
('and'),
7
('another'),
8
('any'),
9
('are'),
10
('as'),
11
('at'),
12
('back'),
13
('be'),
14
('because'),
15
('been'),
16
('being'),
17
('but'),
18
('by'),
19
('can'),
20
('could'),
21
('did'),
22
('do'),
23
('each'),
24
('end'),
25
('even'),
26
('for'),
27
('from'),
28
('get'),
29
('go'),
30
('had'),
31
('have'),
32
('he'),
33
('her'),
34
('here'),
35
('his'),
36
('how'),
37
('i'),
38
('if'),
39
('in'),
40
('into'),
41
('is'),
42
('it'),
43
('just'),
44
('may'),
45
('me'),
46
('might'),
47
('much'),
48
('must'),
49
('my'),
50
('no'),
51
('not'),
52
('of'),
53
('off'),
54
('on'),
55
('only'),
56
('or'),
57
('other'),
58
('our'),
59
('out'),
60
('should'),
61
('so'),
62
('some'),
63
('still'),
64
('such'),
65
('than'),
66
('that'),
67
('the'),
68
('their'),
69
('them'),
70
('then'),
71
('there'),
72
('these'),
73
('they'),
74
('this'),
75
('those'),
76
('to'),
77
('too'),
78
('try'),
79
('two'),
80
('under'),
81
('up'),
82
('us'),
83
('was'),
84
('we'),
85
('were'),
86
('what'),
87
('when'),
88
('where'),
89
('which'),
90
('while'),
91
('who'),
92
('why'),
93
('will'),
94
('with'),
95
('within'),
96
('without'),
97
('would'),
98
('you'),
99
('your');
(-)a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql (-897 / +3 lines)
Lines 1-897 Link Here
1
-- http://www.w3.org/International/articles/language-tags/
1
-- At this moment this file is just a placeholder for the global sql file
2
2
-- with the same name. No translation is needed for now.
3
-- BIDI Stuff, Arabic and Hebrew
3
-- Do NOT delete this file. The webinstaller needs it to exist.
4
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
5
VALUES( 'Arab', 'rtl');
6
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
7
VALUES( 'Hebr', 'rtl');
8
9
-- Default mappings between script and language subcodes
10
INSERT INTO language_script_mapping(language_subtag,script_subtag)
11
VALUES( 'ar', 'Arab');
12
INSERT INTO language_script_mapping(language_subtag,script_subtag)
13
VALUES( 'he', 'Hebr');
14
15
-- EXTENSIONS
16
-- Interface (i)
17
-- SELECT * FROM language_subtag_registry WHERE type='i';
18
-- OPAC
19
INSERT INTO language_subtag_registry( subtag, type, description, added)
20
VALUES ( 'opac', 'i', 'OPAC','2005-10-16');
21
22
INSERT INTO language_descriptions(subtag, type, lang, description)
23
VALUES( 'opac', 'i', 'en', 'OPAC');
24
25
INSERT INTO language_descriptions(subtag, type, lang, description)
26
VALUES( 'opac', 'i', 'fr', 'OPAC');
27
28
-- Staff Client
29
INSERT INTO language_subtag_registry( subtag, type, description, added)
30
VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
31
32
INSERT INTO language_descriptions(subtag, type, lang, description)
33
VALUES( 'intranet', 'i', 'en', 'Staff Client');
34
35
INSERT INTO language_descriptions(subtag, type, lang, description)
36
VALUES( 'intranet', 'i', 'fr', '????');
37
38
-- Theme (t)
39
INSERT INTO language_subtag_registry( subtag, type, description, added)
40
VALUES ( 'prog', 't', 'Prog','2005-10-16');
41
42
INSERT INTO language_descriptions(subtag, type, lang, description)
43
VALUES( 'prog', 't', 'en', 'Prog');
44
45
INSERT INTO language_descriptions(subtag, type, lang, description)
46
VALUES( 'prog', 't', 'fr', 'Prog');
47
48
-- LANGUAGES
49
50
-- Arabic
51
INSERT INTO language_subtag_registry( subtag, type, description, added)
52
VALUES ( 'ar', 'language', 'Arabic','2005-10-16');
53
54
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
55
VALUES( 'ar','ara');
56
57
INSERT INTO language_descriptions(subtag, type, lang, description)
58
VALUES ( 'ar', 'language', 'ar', '&#1575;&#1604;&#1593;&#1585;&#1576;&#1610;&#1577;');
59
60
INSERT INTO language_descriptions(subtag, type, lang, description)
61
VALUES( 'ar', 'language', 'en', 'Arabic');
62
63
INSERT INTO language_descriptions(subtag, type, lang, description)
64
VALUES( 'ar', 'language', 'fr', 'Arabe');
65
66
INSERT INTO language_descriptions(subtag, type, lang, description)
67
VALUES( 'ar', 'language', 'de', 'Arabisch');
68
69
-- Armenian
70
INSERT INTO language_subtag_registry( subtag, type, description, added)
71
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
72
73
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
74
VALUES( 'hy','arm');
75
76
INSERT INTO language_descriptions(subtag, type, lang, description)
77
VALUES ( 'hy', 'language', 'hy', '&#1344;&#1377;&#1397;&#1381;&#1408;&#1383;&#1398;');
78
79
INSERT INTO language_descriptions(subtag, type, lang, description)
80
VALUES( 'hy', 'language', 'en', 'Armenian');
81
82
INSERT INTO language_descriptions(subtag, type, lang, description)
83
VALUES( 'hy', 'language', 'fr', 'Armenian');
84
85
INSERT INTO language_descriptions(subtag, type, lang, description)
86
VALUES( 'hy', 'language', 'de', 'Armenisch');
87
88
-- Bulgarian
89
INSERT INTO language_subtag_registry( subtag, type, description, added)
90
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
91
92
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
93
VALUES( 'bg','bul');
94
95
INSERT INTO language_descriptions(subtag, type, lang, description)
96
VALUES ( 'bg', 'language', 'bg', '&#1041;&#1098;&#1083;&#1075;&#1072;&#1088;&#1089;&#1082;&#1080;');
97
98
INSERT INTO language_descriptions(subtag, type, lang, description)
99
VALUES( 'bg', 'language', 'en', 'Bulgarian');
100
101
INSERT INTO language_descriptions(subtag, type, lang, description)
102
VALUES( 'bg', 'language', 'fr', 'Bulgare');
103
104
INSERT INTO language_descriptions(subtag, type, lang, description)
105
VALUES( 'bg', 'language', 'de', 'Bulgarisch');
106
107
-- Chinese
108
INSERT INTO language_subtag_registry( subtag, type, description, added)
109
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
110
111
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
112
VALUES( 'zh','chi');
113
114
INSERT INTO language_descriptions(subtag, type, lang, description)
115
VALUES ( 'zh', 'language', 'zh', '&#20013;&#25991;');
116
117
INSERT INTO language_descriptions(subtag, type, lang, description)
118
VALUES( 'zh', 'language', 'en', 'Chinese');
119
120
INSERT INTO language_descriptions(subtag, type, lang, description)
121
VALUES( 'zh', 'language', 'fr', 'Chinois');
122
123
INSERT INTO language_descriptions(subtag, type, lang, description)
124
VALUES( 'zh', 'language', 'de', 'Chinesisch');
125
126
-- Czech
127
INSERT INTO language_subtag_registry( subtag, type, description, added)
128
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
129
130
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
131
VALUES( 'cs','cze');
132
133
INSERT INTO language_descriptions(subtag, type, lang, description)
134
VALUES ( 'cs', 'language', 'cs', '&#x010D;e&#353;tina');
135
136
INSERT INTO language_descriptions(subtag, type, lang, description)
137
VALUES( 'cs', 'language', 'en', 'Czech');
138
139
INSERT INTO language_descriptions(subtag, type, lang, description)
140
VALUES( 'cs', 'language', 'fr', 'Tchèque');
141
142
INSERT INTO language_descriptions(subtag, type, lang, description)
143
VALUES( 'cs', 'language', 'de', 'Tschechisch');
144
145
-- Danish
146
INSERT INTO language_subtag_registry( subtag, type, description, added)
147
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
148
149
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
150
VALUES( 'da','dan');
151
152
INSERT INTO language_descriptions(subtag, type, lang, description)
153
VALUES ( 'da', 'language', 'da', 'Dansk');
154
155
INSERT INTO language_descriptions(subtag, type, lang, description)
156
VALUES( 'da', 'language', 'en', 'Danish');
157
158
INSERT INTO language_descriptions(subtag, type, lang, description)
159
VALUES( 'da', 'language', 'fr', 'Danois');
160
161
INSERT INTO language_descriptions(subtag, type, lang, description)
162
VALUES( 'da', 'language', 'de', 'Dänisch');
163
164
-- Dutch, Flemish
165
INSERT INTO language_subtag_registry( subtag, type, description, added)
166
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
167
168
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
169
VALUES( 'nl','dut');
170
171
INSERT INTO language_descriptions(subtag, type, lang, description)
172
VALUES ( 'nl', 'language', 'nl', 'Nederlands');
173
174
INSERT INTO language_descriptions(subtag, type, lang, description)
175
VALUES( 'nl', 'language', 'en', 'Dutch');
176
177
INSERT INTO language_descriptions(subtag, type, lang, description)
178
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
179
180
INSERT INTO language_descriptions(subtag, type, lang, description)
181
VALUES( 'nl', 'language', 'de', 'Niederländisch');
182
183
-- English
184
INSERT INTO language_subtag_registry( subtag, type, description, added)
185
VALUES ( 'en', 'language', 'English','2005-10-16' );
186
187
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
188
VALUES( 'en','eng');
189
190
INSERT INTO language_descriptions(subtag, type, lang, description)
191
VALUES( 'en', 'language', 'en', 'English');
192
193
INSERT INTO language_descriptions(subtag, type, lang, description)
194
VALUES( 'en', 'language', 'fr', 'Anglais');
195
196
INSERT INTO language_descriptions(subtag, type, lang, description)
197
VALUES( 'en', 'language', 'de', 'Englisch');
198
199
-- Finnish
200
INSERT INTO language_subtag_registry( subtag, type, description, added)
201
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
202
203
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
204
VALUES( 'fi','fin');
205
206
INSERT INTO language_descriptions(subtag, type, lang, description)
207
VALUES( 'fi', 'language', 'fi', 'suomi');
208
209
INSERT INTO language_descriptions(subtag, type, lang, description)
210
VALUES( 'fi', 'language', 'en', 'Finnish');
211
212
INSERT INTO language_descriptions(subtag, type, lang, description)
213
VALUES( 'fi', 'language', 'de', 'Finnisch');
214
215
-- French
216
INSERT INTO language_subtag_registry( subtag, type, description, added)
217
VALUES ( 'fr', 'language', 'French','2005-10-16' );
218
219
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
220
VALUES( 'fr','fre');
221
222
INSERT INTO language_descriptions(subtag, type, lang, description)
223
VALUES( 'fr', 'language', 'en', 'French');
224
225
INSERT INTO language_descriptions(subtag, type, lang, description)
226
VALUES( 'fr', 'language', 'fr', 'Fran&ccedil;ais');
227
228
INSERT INTO language_descriptions(subtag, type, lang, description)
229
VALUES( 'fr', 'language', 'de', 'Französisch');
230
231
-- INSERT INTO language_descriptions(subtag, type, lang, description)
232
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'fran&ccedil;ais');
233
234
-- Lao
235
INSERT INTO language_subtag_registry( subtag, type, description, added)
236
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
237
238
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
239
VALUES( 'lo','lao');
240
241
INSERT INTO language_descriptions(subtag, type, lang, description)
242
VALUES( 'lo', 'language', 'lo', '&#3742;&#3762;&#3754;&#3762;&#3749;&#3762;&#3751;');
243
244
INSERT INTO language_descriptions(subtag, type, lang, description)
245
VALUES( 'lo', 'language', 'en', 'Lao');
246
247
INSERT INTO language_descriptions(subtag, type, lang, description)
248
VALUES( 'lo', 'language', 'fr', 'Laotien');
249
250
INSERT INTO language_descriptions(subtag, type, lang, description)
251
VALUES( 'lo', 'language', 'de', 'Laotisch');
252
253
-- German
254
INSERT INTO language_subtag_registry( subtag, type, description, added)
255
VALUES ( 'de', 'language', 'German','2005-10-16' );
256
257
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
258
VALUES( 'de','ger');
259
260
INSERT INTO language_descriptions(subtag, type, lang, description)
261
VALUES( 'de', 'language', 'de', 'Deutsch');
262
263
INSERT INTO language_descriptions(subtag, type, lang, description)
264
VALUES( 'de', 'language', 'en', 'German');
265
266
INSERT INTO language_descriptions(subtag, type, lang, description)
267
VALUES( 'de', 'language', 'fr', 'Allemand');
268
269
-- Greek
270
INSERT INTO language_subtag_registry( subtag, type, description, added)
271
VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
272
273
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
274
VALUES( 'el','gre');
275
276
INSERT INTO language_descriptions(subtag, type, lang, description)
277
VALUES( 'el', 'language', 'el', '&#949;&#955;&#955;&#951;&#957;&#953;&#954;&#940;');
278
279
INSERT INTO language_descriptions(subtag, type, lang, description)
280
VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
281
282
INSERT INTO language_descriptions(subtag, type, lang, description)
283
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
284
285
INSERT INTO language_descriptions(subtag, type, lang, description)
286
VALUES( 'el', 'language', 'de', 'Griechisch (Nach 1453)');
287
288
-- Hebrew
289
INSERT INTO language_subtag_registry( subtag, type, description, added)
290
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
291
292
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
293
VALUES( 'he','heb');
294
295
INSERT INTO language_descriptions(subtag, type, lang, description)
296
VALUES( 'he', 'language', 'he', '&#1506;&#1489;&#1512;&#1497;&#1514;');
297
298
INSERT INTO language_descriptions(subtag, type, lang, description)
299
VALUES( 'he', 'language', 'en', 'Hebrew');
300
301
INSERT INTO language_descriptions(subtag, type, lang, description)
302
VALUES( 'he', 'language', 'fr', 'Hébreu');
303
304
INSERT INTO language_descriptions(subtag, type, lang, description)
305
VALUES( 'he', 'language', 'de', 'Hebräisch');
306
307
-- Hindi
308
INSERT INTO language_subtag_registry( subtag, type, description, added)
309
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
310
311
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
312
VALUES( 'hi','hin');
313
314
INSERT INTO language_descriptions(subtag, type, lang, description)
315
VALUES( 'hi', 'language', 'hi', '&#2361;&#2367;&#2344;&#2381;&#2342;&#2368;');
316
317
INSERT INTO language_descriptions(subtag, type, lang, description)
318
VALUES( 'hi', 'language', 'en', 'Hindi');
319
320
INSERT INTO language_descriptions(subtag, type, lang, description)
321
VALUES( 'hi', 'language', 'fr', 'Hindi');
322
323
INSERT INTO language_descriptions(subtag, type, lang, description)
324
VALUES( 'hi', 'language', 'de', 'Hindi');
325
326
-- Hungarian
327
INSERT INTO language_subtag_registry( subtag, type, description, added)
328
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
329
330
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
331
VALUES( 'hu','hun');
332
333
INSERT INTO language_descriptions(subtag, type, lang, description)
334
VALUES( 'hu', 'language', 'hu', 'Magyar');
335
336
INSERT INTO language_descriptions(subtag, type, lang, description)
337
VALUES( 'hu', 'language', 'en', 'Hungarian');
338
339
INSERT INTO language_descriptions(subtag, type, lang, description)
340
VALUES( 'hu', 'language', 'fr', 'Hongrois');
341
342
INSERT INTO language_descriptions(subtag, type, lang, description)
343
VALUES( 'hu', 'language', 'de', 'Ungarisch');
344
345
-- Indonesian
346
INSERT INTO language_subtag_registry( subtag, type, description, added)
347
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
348
349
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
350
VALUES( 'id','ind');
351
352
INSERT INTO language_descriptions(subtag, type, lang, description)
353
VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
354
355
INSERT INTO language_descriptions(subtag, type, lang, description)
356
VALUES( 'id', 'language', 'en', 'Indonesian');
357
358
INSERT INTO language_descriptions(subtag, type, lang, description)
359
VALUES( 'id', 'language', 'fr', 'Indonésien');
360
361
INSERT INTO language_descriptions(subtag, type, lang, description)
362
VALUES( 'id', 'language', 'de', 'Indonesisch');
363
364
-- Italian
365
INSERT INTO language_subtag_registry( subtag, type, description, added)
366
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
367
368
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
369
VALUES( 'it','ita');
370
371
INSERT INTO language_descriptions(subtag, type, lang, description)
372
VALUES( 'it', 'language', 'it', 'Italiano');
373
374
INSERT INTO language_descriptions(subtag, type, lang, description)
375
VALUES( 'it', 'language', 'en', 'Italian');
376
377
INSERT INTO language_descriptions(subtag, type, lang, description)
378
VALUES( 'it', 'language', 'fr', 'Italien');
379
380
INSERT INTO language_descriptions(subtag, type, lang, description)
381
VALUES( 'it', 'language', 'de', 'Italienisch');
382
383
-- Japanese
384
INSERT INTO language_subtag_registry( subtag, type, description, added)
385
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
386
387
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
388
VALUES( 'ja','jpn');
389
390
INSERT INTO language_descriptions(subtag, type, lang, description)
391
VALUES( 'ja', 'language', 'ja', '&#26085;&#26412;&#35486;');
392
393
INSERT INTO language_descriptions(subtag, type, lang, description)
394
VALUES( 'ja', 'language', 'en', 'Japanese');
395
396
INSERT INTO language_descriptions(subtag, type, lang, description)
397
VALUES( 'ja', 'language', 'fr', 'Japonais');
398
399
INSERT INTO language_descriptions(subtag, type, lang, description)
400
VALUES( 'ja', 'language', 'de', 'Japanisch');
401
402
-- Korean
403
INSERT INTO language_subtag_registry( subtag, type, description, added)
404
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
405
406
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
407
VALUES( 'ko','kor');
408
409
INSERT INTO language_descriptions(subtag, type, lang, description)
410
VALUES( 'ko', 'language', 'ko', '&#54620;&#44397;&#50612;');
411
412
INSERT INTO language_descriptions(subtag, type, lang, description)
413
VALUES( 'ko', 'language', 'en', 'Korean');
414
415
INSERT INTO language_descriptions(subtag, type, lang, description)
416
VALUES( 'ko', 'language', 'fr', 'Coréen');
417
418
INSERT INTO language_descriptions(subtag, type, lang, description)
419
VALUES( 'ko', 'language', 'de', 'Koreanisch');
420
421
-- Latin
422
INSERT INTO language_subtag_registry( subtag, type, description, added)
423
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
424
425
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
426
VALUES( 'la','lat');
427
428
INSERT INTO language_descriptions(subtag, type, lang, description)
429
VALUES( 'la', 'language', 'la', 'Latina');
430
431
INSERT INTO language_descriptions(subtag, type, lang, description)
432
VALUES( 'la', 'language', 'en', 'Latin');
433
434
INSERT INTO language_descriptions(subtag, type, lang, description)
435
VALUES( 'la', 'language', 'fr', 'Latin');
436
437
INSERT INTO language_descriptions(subtag, type, lang, description)
438
VALUES( 'la', 'language', 'de', 'Latein');
439
440
-- Galician
441
442
INSERT INTO language_subtag_registry( subtag, type, description, added)
443
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
444
445
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
446
VALUES( 'gl','glg');
447
448
INSERT INTO language_descriptions(subtag, type, lang, description)
449
VALUES( 'gl', 'language', 'gl', 'Galego');
450
451
INSERT INTO language_descriptions(subtag, type, lang, description)
452
VALUES( 'gl', 'language', 'en', 'Galician');
453
454
INSERT INTO language_descriptions(subtag, type, lang, description)
455
VALUES( 'gl', 'language', 'fr', 'Galicien');
456
457
-- Norwegian (bokmål)
458
INSERT INTO language_subtag_registry( subtag, type, description, added)
459
VALUES ( 'nb', 'language', 'Norwegian bokm&#229;l','2005-10-16' );
460
461
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
462
VALUES( 'nb','nor');
463
464
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
465
VALUES( 'nb','nob');
466
467
INSERT INTO language_descriptions(subtag, type, lang, description)
468
VALUES( 'nb', 'language', 'nb', 'Norsk bokm&#229;l');
469
470
INSERT INTO language_descriptions(subtag, type, lang, description)
471
VALUES( 'nb', 'language', 'en', 'Norwegian bokm&#229;l');
472
473
INSERT INTO language_descriptions(subtag, type, lang, description)
474
VALUES( 'nb', 'language', 'fr', 'Norvégien bokm&#229;l');
475
476
INSERT INTO language_descriptions(subtag, type, lang, description)
477
VALUES( 'nb', 'language', 'de', 'Norwegisch bokm&#229;l');
478
479
-- Norwegian (nynorsk)
480
INSERT INTO language_subtag_registry( subtag, type, description, added)
481
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
482
483
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
484
VALUES( 'nn','nno');
485
486
INSERT INTO language_descriptions(subtag, type, lang, description)
487
VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
488
489
INSERT INTO language_descriptions(subtag, type, lang, description)
490
VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
491
492
INSERT INTO language_descriptions(subtag, type, lang, description)
493
VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
494
495
INSERT INTO language_descriptions(subtag, type, lang, description)
496
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
497
498
INSERT INTO language_descriptions(subtag, type, lang, description)
499
VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk');
500
501
-- Persian
502
INSERT INTO language_subtag_registry( subtag, type, description, added)
503
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
504
505
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
506
VALUES( 'fa','per');
507
508
INSERT INTO language_descriptions(subtag, type, lang, description)
509
VALUES( 'fa', 'language', 'fa', '&#1601;&#1575;&#1585;&#1587;&#1609;');
510
511
INSERT INTO language_descriptions(subtag, type, lang, description)
512
VALUES( 'fa', 'language', 'en', 'Persian');
513
514
INSERT INTO language_descriptions(subtag, type, lang, description)
515
VALUES( 'fa', 'language', 'fr', 'Persan');
516
517
INSERT INTO language_descriptions(subtag, type, lang, description)
518
VALUES( 'fa', 'language', 'de', 'Persisch');
519
520
-- Polish
521
INSERT INTO language_subtag_registry( subtag, type, description, added)
522
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
523
524
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
525
VALUES( 'pl','pol');
526
527
INSERT INTO language_descriptions(subtag, type, lang, description)
528
VALUES( 'pl', 'language', 'pl', 'Polski');
529
530
INSERT INTO language_descriptions(subtag, type, lang, description)
531
VALUES( 'pl', 'language', 'en', 'Polish');
532
533
INSERT INTO language_descriptions(subtag, type, lang, description)
534
VALUES( 'pl', 'language', 'fr', 'Polonais');
535
536
INSERT INTO language_descriptions(subtag, type, lang, description)
537
VALUES( 'pl', 'language', 'de', 'Polnisch');
538
539
-- Portuguese
540
INSERT INTO language_subtag_registry( subtag, type, description, added)
541
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
542
543
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
544
VALUES( 'pt','por');
545
546
INSERT INTO language_descriptions(subtag, type, lang, description)
547
VALUES( 'pt', 'language', 'pt', 'Portugu&ecirc;s');
548
549
INSERT INTO language_descriptions(subtag, type, lang, description)
550
VALUES( 'pt', 'language', 'en', 'Portuguese');
551
552
INSERT INTO language_descriptions(subtag, type, lang, description)
553
VALUES( 'pt', 'language', 'fr', 'Portugais');
554
555
INSERT INTO language_descriptions(subtag, type, lang, description)
556
VALUES( 'pt', 'language', 'de', 'Portugiesisch');
557
558
-- Romanian
559
INSERT INTO language_subtag_registry( subtag, type, description, added)
560
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
561
562
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
563
VALUES( 'ro','rum');
564
565
INSERT INTO language_descriptions(subtag, type, lang, description)
566
VALUES( 'ro', 'language', 'ro', 'Rom&acirc;n&#259;');
567
568
INSERT INTO language_descriptions(subtag, type, lang, description)
569
VALUES( 'ro', 'language', 'en', 'Romanian');
570
571
INSERT INTO language_descriptions(subtag, type, lang, description)
572
VALUES( 'ro', 'language', 'fr', 'Roumain');
573
574
INSERT INTO language_descriptions(subtag, type, lang, description)
575
VALUES( 'ro', 'language', 'de', 'Rumänisch');
576
577
-- Russian
578
INSERT INTO language_subtag_registry( subtag, type, description, added)
579
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
580
581
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
582
VALUES( 'ru','rus');
583
584
INSERT INTO language_descriptions(subtag, type, lang, description)
585
VALUES( 'ru', 'language', 'ru', '&#1056;&#1091;&#1089;&#1089;&#1082;&#1080;&#1081;');
586
587
INSERT INTO language_descriptions(subtag, type, lang, description)
588
VALUES( 'ru', 'language', 'en', 'Russian');
589
590
INSERT INTO language_descriptions(subtag, type, lang, description)
591
VALUES( 'ru', 'language', 'fr', 'Russe');
592
593
INSERT INTO language_descriptions(subtag, type, lang, description)
594
VALUES( 'ru', 'language', 'de', 'Russisch');
595
596
-- Serbian
597
INSERT INTO language_subtag_registry( subtag, type, description, added)
598
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
599
600
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
601
VALUES( 'sr','srp');
602
603
INSERT INTO language_descriptions(subtag, type, lang, description)
604
VALUES( 'sr', 'language', 'sr', '&#1089;&#1088;&#1087;&#1089;&#1082;&#1080;');
605
606
INSERT INTO language_descriptions(subtag, type, lang, description)
607
VALUES( 'sr', 'language', 'en', 'Serbian');
608
609
INSERT INTO language_descriptions(subtag, type, lang, description)
610
VALUES( 'sr', 'language', 'fr', 'Serbe');
611
612
INSERT INTO language_descriptions(subtag, type, lang, description)
613
VALUES( 'sr', 'language', 'de', 'Serbisch');
614
615
-- Spanish, Castilian
616
INSERT INTO language_subtag_registry( subtag, type, description, added)
617
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
618
619
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
620
VALUES( 'es','spa');
621
622
INSERT INTO language_descriptions(subtag, type, lang, description)
623
VALUES( 'es', 'language', 'es', 'Espa&ntilde;ol');
624
625
INSERT INTO language_descriptions(subtag, type, lang, description)
626
VALUES( 'es', 'language', 'en', 'Spanish');
627
628
INSERT INTO language_descriptions(subtag, type, lang, description)
629
VALUES( 'es', 'language', 'fr', 'Espagnol');
630
631
INSERT INTO language_descriptions(subtag, type, lang, description)
632
VALUES( 'es', 'language', 'de', 'Spanisch');
633
634
-- Spanish, Catalan
635
INSERT INTO language_subtag_registry( subtag, type, description, added)
636
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
637
638
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
639
VALUES( 'ca','cat');
640
641
INSERT INTO language_descriptions(subtag, type, lang, description)
642
VALUES( 'ca', 'language', 'es', 'Catalán');
643
644
INSERT INTO language_descriptions(subtag, type, lang, description)
645
VALUES( 'ca', 'language', 'en', 'Catalan');
646
647
INSERT INTO language_descriptions(subtag, type, lang, description)
648
VALUES( 'ca', 'language', 'fr', 'Catalan');
649
650
INSERT INTO language_descriptions(subtag, type, lang, description)
651
VALUES( 'ca', 'language', 'ca', 'Català');
652
653
INSERT INTO language_descriptions(subtag, type, lang, description)
654
VALUES( 'ca', 'language', 'de', 'Katalanisch');
655
656
-- Swedish
657
INSERT INTO language_subtag_registry( subtag, type, description, added)
658
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
659
660
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
661
VALUES( 'sv','swe');
662
663
INSERT INTO language_descriptions(subtag, type, lang, description)
664
VALUES( 'sv', 'language', 'sv', 'Svenska');
665
666
INSERT INTO language_descriptions(subtag, type, lang, description)
667
VALUES( 'sv', 'language', 'en', 'Swedish');   
668
669
INSERT INTO language_descriptions(subtag, type, lang, description)
670
VALUES( 'sv', 'language', 'fr', 'Suédois');
671
672
INSERT INTO language_descriptions(subtag, type, lang, description)
673
VALUES( 'sv', 'language', 'de', 'Schwedisch');
674
675
-- Tetum
676
INSERT INTO language_subtag_registry( subtag, type, description, added)
677
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
678
679
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
680
VALUES( 'tet','tet');
681
682
INSERT INTO language_descriptions(subtag, type, lang, description)
683
VALUES( 'tet', 'language', 'tet', 'tetun');
684
685
INSERT INTO language_descriptions(subtag, type, lang, description)
686
VALUES( 'tet', 'language', 'en', 'Tetum');
687
688
INSERT INTO language_descriptions(subtag, type, lang, description)
689
VALUES( 'tet', 'language', 'fr', 'Tétoum');
690
691
INSERT INTO language_descriptions(subtag, type, lang, description)
692
VALUES( 'tet', 'language', 'de', 'Tetum');
693
694
-- Thai
695
INSERT INTO language_subtag_registry( subtag, type, description, added)
696
VALUES ( 'th', 'language', 'Thai','2005-10-16');
697
698
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
699
VALUES( 'th','tha');
700
701
INSERT INTO language_descriptions(subtag, type, lang, description)
702
VALUES( 'th', 'language', 'th', '&#3616;&#3634;&#3625;&#3634;&#3652;&#3607;&#3618;');
703
704
INSERT INTO language_descriptions(subtag, type, lang, description)
705
VALUES( 'th', 'language', 'en', 'Thai');   
706
707
INSERT INTO language_descriptions(subtag, type, lang, description)
708
VALUES( 'th', 'language', 'fr', 'Thaï');
709
710
INSERT INTO language_descriptions(subtag, type, lang, description)
711
VALUES( 'th', 'language', 'de', 'Thailändisch');
712
713
-- Turkish
714
INSERT INTO language_subtag_registry( subtag, type, description, added)
715
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
716
717
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
718
VALUES( 'tr','tur');
719
720
INSERT INTO language_descriptions(subtag, type, lang, description)
721
VALUES( 'tr', 'language', 'tr', 'T&uuml;rk&ccedil;e');
722
723
INSERT INTO language_descriptions(subtag, type, lang, description)
724
VALUES( 'tr', 'language', 'en', 'Turkish');   
725
726
INSERT INTO language_descriptions(subtag, type, lang, description)
727
VALUES( 'tr', 'language', 'fr', 'Turc');
728
729
INSERT INTO language_descriptions(subtag, type, lang, description)
730
VALUES( 'tr', 'language', 'de', 'Türkisch');
731
732
-- Ukranian
733
INSERT INTO language_subtag_registry( subtag, type, description, added)
734
VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
735
736
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
737
VALUES( 'uk','ukr');
738
739
INSERT INTO language_descriptions(subtag, type, lang, description)
740
VALUES( 'uk', 'language', 'uk', '&#1059;&#1082;&#1088;&#1072;&#1111;&#1085;&#1089;&#1100;&#1082;&#1072;');
741
742
INSERT INTO language_descriptions(subtag, type, lang, description)
743
VALUES( 'uk', 'language', 'en', 'Ukranian');
744
745
INSERT INTO language_descriptions(subtag, type, lang, description)
746
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
747
748
INSERT INTO language_descriptions(subtag, type, lang, description)
749
VALUES( 'uk', 'language', 'de', 'Ukrainisch');
750
751
-- Urdu
752
INSERT INTO language_subtag_registry( subtag, type, description, added)
753
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
754
755
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
756
VALUES( 'ur','urd');
757
758
INSERT INTO language_descriptions(subtag, type, lang, description)
759
VALUES( 'ur', 'language', 'en', 'Urdu');
760
761
INSERT INTO language_descriptions(subtag, type, lang, description)
762
VALUES( 'ur', 'language', 'ur', '&#1575;&#1585;&#1583;&#1608;');
763
764
INSERT INTO language_descriptions(subtag, type, lang, description)
765
VALUES( 'ur', 'language', 'fr', 'Ourdou');
766
767
INSERT INTO language_descriptions(subtag, type, lang, description)
768
VALUES( 'ur', 'language', 'de', 'Urdu');
769
770
-- SCRIPTS
771
-- Arabic
772
INSERT INTO language_subtag_registry( subtag, type, description, added)
773
VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
774
775
INSERT INTO language_descriptions(subtag, type, lang, description)
776
VALUES ( 'Arab','script', 'Arab', '&#1575;&#1604;&#1593;&#1585;&#1576;&#1610;&#1577;');
777
778
INSERT INTO language_descriptions(subtag, type, lang, description)
779
VALUES( 'Arab', 'script','en', 'Arabic');
780
781
INSERT INTO language_descriptions(subtag, type, lang, description)
782
VALUES( 'Arab', 'script','fr', 'Arabic');
783
784
-- Cyrillic
785
INSERT INTO language_subtag_registry( subtag, type, description, added)
786
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
787
788
INSERT INTO language_descriptions(subtag, type, lang, description)
789
VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
790
791
INSERT INTO language_descriptions(subtag, type, lang, description)
792
VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
793
794
INSERT INTO language_descriptions(subtag, type, lang, description)
795
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
796
797
-- Greek
798
INSERT INTO language_subtag_registry( subtag, type, description, added)
799
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
800
801
INSERT INTO language_descriptions(subtag, type, lang, description)
802
VALUES ( 'Grek', 'script', 'Grek', '????');
803
804
INSERT INTO language_descriptions(subtag, type, lang, description)
805
VALUES( 'Grek', 'script', 'en', 'Greek');
806
807
INSERT INTO language_descriptions(subtag, type, lang, description)
808
VALUES( 'Grek', 'script', 'fr', 'Greek');
809
810
-- Han - Simplified
811
INSERT INTO language_subtag_registry( subtag, type, description, added)
812
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
813
814
INSERT INTO language_descriptions(subtag, type, lang, description)
815
VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
816
817
INSERT INTO language_descriptions(subtag, type, lang, description)
818
VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
819
820
INSERT INTO language_descriptions(subtag, type, lang, description)
821
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
822
823
-- Han - Traditional
824
INSERT INTO language_subtag_registry( subtag, type, description, added)
825
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
826
827
INSERT INTO language_descriptions(subtag, type, lang, description)
828
VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
829
830
INSERT INTO language_descriptions(subtag, type, lang, description)
831
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
832
833
-- Hebrew
834
INSERT INTO language_subtag_registry( subtag, type, description, added)
835
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
836
837
INSERT INTO language_descriptions(subtag, type, lang, description)
838
VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
839
840
INSERT INTO language_descriptions(subtag, type, lang, description)
841
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
842
843
-- Lao
844
INSERT INTO language_subtag_registry( subtag, type, description, added)
845
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
846
847
INSERT INTO language_descriptions(subtag, type, lang, description)
848
VALUES ( 'Laoo', 'script', 'lo', 'Lao');
849
850
INSERT INTO language_descriptions(subtag, type, lang, description)
851
VALUES( 'Laoo', 'script', 'en', 'Lao');
852
853
-- REGIONS
854
-- Canada
855
INSERT INTO language_subtag_registry( subtag, type, description, added)
856
VALUES ( 'CA', 'region', 'Canada','2005-10-16');
857
858
INSERT INTO language_descriptions(subtag, type, lang, description)
859
VALUES( 'CA', 'region', 'en', 'Canada');
860
861
-- Denmark
862
INSERT INTO language_subtag_registry( subtag, type, description, added)
863
VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
864
865
INSERT INTO language_descriptions(subtag, type, lang, description)
866
VALUES( 'DK', 'region', 'dk', 'Danmark');
867
868
-- France
869
INSERT INTO language_subtag_registry( subtag, type, description, added)
870
VALUES ( 'FR', 'region', 'France','2005-10-16');
871
872
INSERT INTO language_descriptions(subtag, type, lang, description)
873
VALUES ( 'FR', 'region', 'fr', 'France');
874
875
INSERT INTO language_descriptions(subtag, type, lang, description)
876
VALUES( 'FR', 'region', 'en', 'France');
877
878
-- New Zealand
879
INSERT INTO language_subtag_registry( subtag, type, description, added)
880
VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
881
882
INSERT INTO language_descriptions(subtag, type, lang, description)
883
VALUES( 'NZ', 'region', 'en', 'New Zealand');
884
885
-- United Kingdom
886
INSERT INTO language_subtag_registry( subtag, type, description, added)
887
VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
888
889
INSERT INTO language_descriptions(subtag, type, lang, description)
890
VALUES( 'GB', 'region', 'en', 'United Kingdom');
891
892
-- United States
893
INSERT INTO language_subtag_registry( subtag, type, description, added)
894
VALUES ( 'US', 'region', 'United States','2005-10-16');
895
896
INSERT INTO language_descriptions(subtag, type, lang, description)
897
VALUES( 'US', 'region', 'en', 'United States');
(-)a/installer/data/mysql/de-DE/mandatory/userflags.sql (-19 / +57 lines)
Lines 1-19 Link Here
1
INSERT INTO `userflags` VALUES(0,'superlibrarian','Zugriff auf alle Funktionen',0);
1
UPDATE userflags SET
2
INSERT INTO `userflags` VALUES(1,'circulate','Medien ausleihen/zurückgeben',0);
2
    flagdesc = 'Zugriff auf alle Funktionen'
3
INSERT INTO `userflags` VALUES(2,'catalogue','Katalogsuche verwenden (Dienstoberfläche)',0);
3
WHERE bit = 0 AND flag = 'superlibrarian';
4
INSERT INTO `userflags` VALUES(3,'parameters','Systemparameter verändern',0);
4
UPDATE userflags SET
5
INSERT INTO `userflags` VALUES(4,'borrowers','Benutzer anlegen/ändern',0);
5
    flagdesc = 'Medien ausleihen/zurückgeben'
6
INSERT INTO `userflags` VALUES(5,'permissions','Berechtigungen für Benutzer vergeben',0);
6
WHERE bit = 1 AND flag = 'circulate';
7
INSERT INTO `userflags` VALUES(6,'reserveforothers','Vormerkungen für Benutzer setzen/ändern',0);
7
UPDATE userflags SET
8
INSERT INTO `userflags` VALUES(7,'borrow','Medien entleihen',1);
8
    flagdesc = 'Katalogsuche verwenden (Dienstoberfläche)'
9
INSERT INTO `userflags` VALUES(9,'editcatalogue','Katalogdaten ändern (Titel- und Bestandsdaten ändern)',0);
9
WHERE bit = 2 AND flag = 'catalogue';
10
INSERT INTO `userflags` VALUES(10,'updatecharges','Gebühren kassieren/ändern',0);
10
UPDATE userflags SET
11
INSERT INTO `userflags` VALUES(11,'acquisition','Erwerbung und Verwaltung von Anschaffungsvorschlägen',0);
11
    flagdesc = 'Systemparameter verändern'
12
INSERT INTO `userflags` VALUES(12,'management','Zugriff auf Administration',0);
12
WHERE bit = 3 AND flag = 'parameters';
13
INSERT INTO `userflags` VALUES(13,'tools','Werkzeuge verwenden (Export, Import, Etikettendruck)',0);
13
UPDATE userflags SET
14
INSERT INTO `userflags` VALUES(14,'editauthorities','Normdaten ändern',0);
14
    flagdesc = 'Benutzer anlegen/ändern'
15
INSERT INTO `userflags` VALUES(15,'serials','Zugriff auf Abonnementverwaltung/Zeitschriftenmodul',0);
15
WHERE bit = 4 AND flag = 'borrowers';
16
INSERT INTO `userflags` VALUES(16,'reports','Zugriff auf Reportmodul',0);
16
UPDATE userflags SET
17
INSERT INTO `userflags` VALUES(17,'staffaccess','Berechtigungen/Logins für Bibliotheksmitarbeiter vergeben',0);
17
    flagdesc = 'Berechtigungen für Benutzer vergeben'
18
INSERT INTO `userflags` VALUES(18,'coursereserves','Course Reserves',0);
18
WHERE bit = 5 AND flag = 'permissions';
19
INSERT INTO `userflags` VALUES(19,'plugins', 'Koha Plugins', '0');
19
UPDATE userflags SET
20
    flagdesc = 'Vormerkungen für Benutzer setzen/ändern'
21
WHERE bit = 6 AND flag = 'reserveforothers';
22
UPDATE userflags SET
23
    flagdesc = 'Medien entleihen'
24
WHERE bit = 7 AND flag = 'borrow';
25
UPDATE userflags SET
26
    flagdesc = 'Katalogdaten ändern (Titel- und Bestandsdaten ändern)'
27
WHERE bit = 9 AND flag = 'editcatalogue';
28
UPDATE userflags SET
29
    flagdesc = 'Gebühren kassieren/ändern'
30
WHERE bit = 10 AND flag = 'updatecharges';
31
UPDATE userflags SET
32
    flagdesc = 'Erwerbung und Verwaltung von Anschaffungsvorschlägen'
33
WHERE bit = 11 AND flag = 'acquisition';
34
UPDATE userflags SET
35
    flagdesc = 'Zugriff auf Administration'
36
WHERE bit = 12 AND flag = 'management';
37
UPDATE userflags SET
38
    flagdesc = 'Werkzeuge verwenden (Export, Import, Etikettendruck)'
39
WHERE bit = 13 AND flag = 'tools';
40
UPDATE userflags SET
41
    flagdesc = 'Normdaten ändern'
42
WHERE bit = 14 AND flag = 'editauthorities';
43
UPDATE userflags SET
44
    flagdesc = 'Zugriff auf Abonnementverwaltung/Zeitschriftenmodul'
45
WHERE bit = 15 AND flag = 'serials';
46
UPDATE userflags SET
47
    flagdesc = 'Zugriff auf Reportmodul'
48
WHERE bit = 16 AND flag = 'reports';
49
UPDATE userflags SET
50
    flagdesc = 'Berechtigungen/Logins für Bibliotheksmitarbeiter vergeben'
51
WHERE bit = 17 AND flag = 'staffaccess';
52
UPDATE userflags SET
53
    flagdesc = 'Course Reserves'
54
WHERE bit = 18 AND flag = 'coursereserves';
55
UPDATE userflags SET
56
    flagdesc = 'Koha Plugins'
57
WHERE bit = 19 AND flag = 'plugins';
(-)a/installer/data/mysql/de-DE/mandatory/userpermissions.sql (-64 / +183 lines)
Lines 1-63 Link Here
1
INSERT INTO permissions (module_bit, code, description) VALUES
1
UPDATE permissions SET
2
   ( 1, 'circulate_remaining_permissions', 'Übrige Ausleihberechtigungen'),
2
    description = 'Übrige Ausleihberechtigungen'
3
   ( 1, 'override_renewals', 'Gesperrte Verlängerungen überschreiben'),
3
WHERE module_bit = 1 AND code = 'circulate_remaining_permissions';
4
   ( 1, 'overdues_report', 'Überfälligkeiten-Report ausführen'),
4
UPDATE permissions SET
5
   ( 3, 'parameters_remaining_permissions', 'Übrige Administrationsberechtigungen'),
5
    description = 'Gesperrte Verlängerungen überschreiben'
6
   ( 3, 'manage_circ_rules', 'Ausleihkonditionen verwalten'),
6
WHERE module_bit = 1 AND code = 'override_renewals';
7
   ( 6, 'place_holds', 'Vormerkungen für Benutzer setzen'),
7
UPDATE permissions SET
8
   ( 6, 'modify_holds_priority', 'Vormerkungspriorität verändern'),
8
    description = 'Überfälligkeiten-Report ausführen'
9
   ( 9, 'edit_catalogue', 'Katalogdaten bearbeiten (Titel- und Exemplardaten ändern)'),
9
WHERE module_bit = 1 AND code = 'overdues_report';
10
   ( 9, 'fast_cataloging', 'Schnellaufnahmen anlegen'),
10
UPDATE permissions SET
11
   ( 9, 'edit_items', 'Exemplare bearbeiten'),
11
    description = 'Übrige Administrationsberechtigungen'
12
   (11, 'vendors_manage', 'Lieferanten verwalten'),
12
WHERE module_bit = 3 AND code = 'parameters_remaining_permissions';
13
   (11, 'contracts_manage', 'Vereinbarungen verwalten'),
13
UPDATE permissions SET
14
   (11, 'period_manage', 'Etats verwalten'),
14
    description = 'Ausleihkonditionen verwalten'
15
   (11, 'budget_manage', 'Konten verwalten'),
15
WHERE module_bit = 3 AND code = 'manage_circ_rules';
16
   (11, 'budget_modify', 'Konten verändern (keine Neuen anlegen, aber Bestehende ändern)'),
16
UPDATE permissions SET
17
   (11, 'planning_manage', 'Etatplanung verwalten'),
17
    description = 'Vormerkungen für Benutzer setzen'
18
   (11, 'order_manage', 'Bestellungen verwalten'),
18
WHERE module_bit = 6 AND code = 'place_holds';
19
   (11, 'group_manage', 'Bestellgruppen vewalten'),
19
UPDATE permissions SET
20
   (11, 'order_receive', 'Lieferungen verwalten'),
20
    description = 'Vormerkungspriorität verändern'
21
   (11, 'budget_add_del', 'Konten hinzufügen/ändern, aber bestehende nicht ändern'),
21
WHERE module_bit = 6 AND code = 'modify_holds_priority';
22
   (11, 'budget_manage_all', 'Alle Konten verwalten'),
22
UPDATE permissions SET
23
   (13, 'edit_news', 'Nachrichten für OPAC und Dienstoberfläche verfassen'),
23
    description = 'Katalogdaten bearbeiten (Titel- und Exemplardaten ändern)'
24
   (13, 'label_creator', 'Etiketten und Barcodes aus Katalog- und Benutzerdaten erstellen'),
24
WHERE module_bit = 9 AND code = 'edit_catalogue';
25
   (13, 'edit_calendar', 'Schließtage eintragen'),
25
UPDATE permissions SET
26
   (13, 'moderate_comments', 'Benutzerkommentare moderieren'),
26
    description = 'Schnellaufnahmen anlegen'
27
   (13, 'edit_notices', 'Benachrichtigungen verwalten'),
27
WHERE module_bit = 9 AND code = 'fast_cataloging';
28
   (13, 'edit_notice_status_triggers', 'Mahntrigger für überfällige Medien verwalten'),
28
UPDATE permissions SET
29
   (13, 'edit_quotes', '"Zitat des Tages" konfigurieren'),
29
    description = 'Exemplare bearbeiten'
30
   (13, 'view_system_logs', 'Logs durchsuchen/einsehen'),
30
WHERE module_bit = 9 AND code = 'edit_items';
31
   (13, 'inventory', 'Inventur durchführen'),
31
UPDATE permissions SET
32
   (13, 'stage_marc_import', 'MARC-Datensätze zwischenspeichern'),
32
    description = 'Lieferanten verwalten'
33
   (13, 'manage_staged_marc', 'MARC-Importe verwalten, auch Übernahme in Katalog und Import rückgängig machen'),
33
WHERE module_bit = 11 AND code = 'vendors_manage';
34
   (13, 'export_catalog', 'Titel- und Exemplardaten exportieren'),
34
UPDATE permissions SET
35
   (13, 'import_patrons', 'Benutzerdaten importieren'),
35
    description = 'Vereinbarungen verwalten'
36
   (13, 'edit_patrons', 'Stapelbearbeitung von Benutzerdaten durchführen'),
36
WHERE module_bit = 11 AND code = 'contracts_manage';
37
   (13, 'delete_anonymize_patrons', 'Inaktive Benutzer löschen und Ausleihhistorie anonymisieren (Benutzerausleihhistorie löschen)'),
37
UPDATE permissions SET
38
   (13, 'batch_upload_patron_images', 'Benutzerfotos einzeln oder im Stapel hochladen'),
38
    description = 'Etats verwalten'
39
   (13, 'schedule_tasks', 'Aufgabenplaner verwenden'),
39
WHERE module_bit = 11 AND code = 'period_manage';
40
   (13, 'items_batchmod', 'Stapelbearbeitung von Exemplaren durchführen'),
40
UPDATE permissions SET
41
   (13, 'items_batchdel', 'Stapellöschung von Exemplaren durchführen'),
41
    description = 'Konten verwalten'
42
   (13, 'manage_csv_profiles', 'CSV-Profile für Export verwalten'),
42
WHERE module_bit = 11 AND code = 'budget_manage';
43
   (13, 'moderate_tags', 'Von Benutzern vergebene Tags moderieren'),
43
UPDATE permissions SET
44
   (13, 'rotating_collections', 'Wandernde Sammlungen verwalten'),
44
    description = 'Konten verändern (keine Neuen anlegen, aber Bestehende ändern)'
45
   (13, 'upload_local_cover_images', 'Eigene Coverbilder hochladen'),
45
WHERE module_bit = 11 AND code = 'budget_modify';
46
   (15, 'check_expiration', 'Ablauf eines Abonnements prüfen'),
46
UPDATE permissions SET
47
   (15, 'claim_serials', 'Fehlende Hefte reklamieren'),
47
    description = 'Etatplanung verwalten'
48
   (15, 'create_subscription', 'Neues Abonnement anlegen'),
48
WHERE module_bit = 11 AND code = 'planning_manage';
49
   (15, 'delete_subscription', 'Bestehende Abonnements löschen'),
49
UPDATE permissions SET
50
   (15, 'edit_subscription', 'Bestehende Abonnements bearbeiten'),
50
    description = 'Bestellungen verwalten'
51
   (15, 'receive_serials', 'Zugang von Heften'),
51
WHERE module_bit = 11 AND code = 'order_manage';
52
   (15, 'renew_subscription', 'Abonnements verlängern'),
52
UPDATE permissions SET
53
   (15, 'routing', 'Umlauflisten verwalten'),
53
    description = 'Bestellgruppen vewalten'
54
   (16, 'execute_reports', 'SQL-Reports ausführen'),
54
WHERE module_bit = 11 AND code = 'group_manage';
55
   (16, 'create_reports', 'SQL-Reports erstellen'),
55
UPDATE permissions SET
56
   (18, 'manage_courses', 'Add, edit and delete courses'),
56
    description = 'Lieferungen verwalten'
57
   (18, 'add_reserves', 'Add course reserves'),
57
WHERE module_bit = 11 AND code = 'order_receive';
58
   (18, 'delete_reserves', 'Remove course reserves'),
58
UPDATE permissions SET
59
   (19, 'manage', 'Plugins verwealten (installieren/deinstallieren)'),
59
    description = 'Konten hinzufügen/ändern, aber bestehende nicht ändern'
60
   (19, 'tool', 'Werkzeug-Plugins verwenden'),
60
WHERE module_bit = 11 AND code = 'budget_add_del';
61
   (19, 'report', 'Report-Plugins verwenden'),
61
UPDATE permissions SET
62
   (19, 'configure', 'Plugins konfigurieren')
62
    description = 'Alle Konten verwalten'
63
;
63
WHERE module_bit = 11 AND code = 'budget_manage_all';
64
UPDATE permissions SET
65
    description = 'Nachrichten für OPAC und Dienstoberfläche verfassen'
66
WHERE module_bit = 13 AND code = 'edit_news';
67
UPDATE permissions SET
68
    description = 'Etiketten und Barcodes aus Katalog- und Benutzerdaten erstellen'
69
WHERE module_bit = 13 AND code = 'label_creator';
70
UPDATE permissions SET
71
    description = 'Schließtage eintragen'
72
WHERE module_bit = 13 AND code = 'edit_calendar';
73
UPDATE permissions SET
74
    description = 'Benutzerkommentare moderieren'
75
WHERE module_bit = 13 AND code = 'moderate_comments';
76
UPDATE permissions SET
77
    description = 'Benachrichtigungen verwalten'
78
WHERE module_bit = 13 AND code = 'edit_notices';
79
UPDATE permissions SET
80
    description = 'Mahntrigger für überfällige Medien verwalten'
81
WHERE module_bit = 13 AND code = 'edit_notice_status_triggers';
82
UPDATE permissions SET
83
    description = '"Zitat des Tages" konfigurieren'
84
WHERE module_bit = 13 AND code = 'edit_quotes';
85
UPDATE permissions SET
86
    description = 'Logs durchsuchen/einsehen'
87
WHERE module_bit = 13 AND code = 'view_system_logs';
88
UPDATE permissions SET
89
    description = 'Inventur durchführen'
90
WHERE module_bit = 13 AND code = 'inventory';
91
UPDATE permissions SET
92
    description = 'MARC-Datensätze zwischenspeichern'
93
WHERE module_bit = 13 AND code = 'stage_marc_import';
94
UPDATE permissions SET
95
    description = 'MARC-Importe verwalten, auch Übernahme in Katalog und Import rückgängig machen'
96
WHERE module_bit = 13 AND code = 'manage_staged_marc';
97
UPDATE permissions SET
98
    description = 'Titel- und Exemplardaten exportieren'
99
WHERE module_bit = 13 AND code = 'export_catalog';
100
UPDATE permissions SET
101
    description = 'Benutzerdaten importieren'
102
WHERE module_bit = 13 AND code = 'import_patrons';
103
UPDATE permissions SET
104
    description = 'Stapelbearbeitung von Benutzerdaten durchführen'
105
WHERE module_bit = 13 AND code = 'edit_patrons';
106
UPDATE permissions SET
107
    description = 'Inaktive Benutzer löschen und Ausleihhistorie anonymisieren (Benutzerausleihhistorie löschen)'
108
WHERE module_bit = 13 AND code = 'delete_anonymize_patrons';
109
UPDATE permissions SET
110
    description = 'Benutzerfotos einzeln oder im Stapel hochladen'
111
WHERE module_bit = 13 AND code = 'batch_upload_patron_images';
112
UPDATE permissions SET
113
    description = 'Aufgabenplaner verwenden'
114
WHERE module_bit = 13 AND code = 'schedule_tasks';
115
UPDATE permissions SET
116
    description = 'Stapelbearbeitung von Exemplaren durchführen'
117
WHERE module_bit = 13 AND code = 'items_batchmod';
118
UPDATE permissions SET
119
    description = 'Stapellöschung von Exemplaren durchführen'
120
WHERE module_bit = 13 AND code = 'items_batchdel';
121
UPDATE permissions SET
122
    description = 'CSV-Profile für Export verwalten'
123
WHERE module_bit = 13 AND code = 'manage_csv_profiles';
124
UPDATE permissions SET
125
    description = 'Von Benutzern vergebene Tags moderieren'
126
WHERE module_bit = 13 AND code = 'moderate_tags';
127
UPDATE permissions SET
128
    description = 'Wandernde Sammlungen verwalten'
129
WHERE module_bit = 13 AND code = 'rotating_collections';
130
UPDATE permissions SET
131
    description = 'Eigene Coverbilder hochladen'
132
WHERE module_bit = 13 AND code = 'upload_local_cover_images';
133
UPDATE permissions SET
134
    description = 'Ablauf eines Abonnements prüfen'
135
WHERE module_bit = 15 AND code = 'check_expiration';
136
UPDATE permissions SET
137
    description = 'Fehlende Hefte reklamieren'
138
WHERE module_bit = 15 AND code = 'claim_serials';
139
UPDATE permissions SET
140
    description = 'Neues Abonnement anlegen'
141
WHERE module_bit = 15 AND code = 'create_subscription';
142
UPDATE permissions SET
143
    description = 'Bestehende Abonnements löschen'
144
WHERE module_bit = 15 AND code = 'delete_subscription';
145
UPDATE permissions SET
146
    description = 'Bestehende Abonnements bearbeiten'
147
WHERE module_bit = 15 AND code = 'edit_subscription';
148
UPDATE permissions SET
149
    description = 'Zugang von Heften'
150
WHERE module_bit = 15 AND code = 'receive_serials';
151
UPDATE permissions SET
152
    description = 'Abonnements verlängern'
153
WHERE module_bit = 15 AND code = 'renew_subscription';
154
UPDATE permissions SET
155
    description = 'Umlauflisten verwalten'
156
WHERE module_bit = 15 AND code = 'routing';
157
UPDATE permissions SET
158
    description = 'SQL-Reports ausführen'
159
WHERE module_bit = 16 AND code = 'execute_reports';
160
UPDATE permissions SET
161
    description = 'SQL-Reports erstellen'
162
WHERE module_bit = 16 AND code = 'create_reports';
163
UPDATE permissions SET
164
    description = 'Add, edit and delete courses'
165
WHERE module_bit = 18 AND code = 'manage_courses';
166
UPDATE permissions SET
167
    description = 'Add course reserves'
168
WHERE module_bit = 18 AND code = 'add_reserves';
169
UPDATE permissions SET
170
    description = 'Remove course reserves'
171
WHERE module_bit = 18 AND code = 'delete_reserves';
172
UPDATE permissions SET
173
    description = 'Plugins verwealten (installieren/deinstallieren)'
174
WHERE module_bit = 19 AND code = 'manage';
175
UPDATE permissions SET
176
    description = 'Werkzeug-Plugins verwenden'
177
WHERE module_bit = 19 AND code = 'tool';
178
UPDATE permissions SET
179
    description = 'Report-Plugins verwenden'
180
WHERE module_bit = 19 AND code = 'report';
181
UPDATE permissions SET
182
    description = 'Plugins konfigurieren'
183
WHERE module_bit = 19 AND code = 'configure';
64
- 

Return to bug 10509