From 1b52219a3d2d6ac3954090f752c00dde2ba86c85 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Mon, 24 Jun 2013 15:35:28 +0200 Subject: [PATCH] Bug 10509: Using updates instead of inserts in translated mysql files Content-Type: text/plain; charset=utf-8 This patch makes changes to C4/Installer to allow running global (English) sql inserts before updating them from the specific language file. This patch touches only de-DE/mandatory to illustrate the concept. All language installs should proceed as usual. Test plan: Test the English install and test the German install. If you do not feel confident, check another one too :) Signed-off-by: Marcel de Rooy Verified that the German install still functions. --- C4/Installer.pm | 88 ++- .../data/mysql/de-DE/mandatory/class_sources.sql | 38 +- .../de-DE/mandatory/message_transport_types.sql | 10 +- .../data/mysql/de-DE/mandatory/sample_notices.sql | 158 +++- .../sample_notices_message_attributes.sql | 11 +- .../sample_notices_message_transports.sql | 20 +- installer/data/mysql/de-DE/mandatory/stopwords.sql | 102 +--- .../data/mysql/de-DE/mandatory/subtag_registry.sql | 900 +------------------- installer/data/mysql/de-DE/mandatory/userflags.sql | 76 ++- .../data/mysql/de-DE/mandatory/userpermissions.sql | 246 ++++-- 10 files changed, 493 insertions(+), 1156 deletions(-) diff --git a/C4/Installer.pm b/C4/Installer.pm index 5bb9662..410008b 100644 --- a/C4/Installer.pm +++ b/C4/Installer.pm @@ -24,6 +24,8 @@ our $VERSION = 3.07.00.049; use C4::Context; use C4::Installer::PerlModules; +use constant GLOBAL_SQL_FOLDER => 'en'; + =head1 NAME C4::Installer @@ -465,6 +467,9 @@ Runs a the specified SQL using the DB's command-line SQL tool, and returns any strings sent to STDERR by the command-line tool. +Additionally: if it detects a global counterpart for this SQL file, it runs +that file first (inserting english records) and updates for translation. + B there has been a long-standing desire to replace this with an SQL loader that goes through DBI; partly for portability issues @@ -481,7 +486,7 @@ sub load_sql { my $filename = shift; my $datadir = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}"; - my $error; + my $error=''; my $strcmd; my $cmd; if ( $self->{dbms} eq 'mysql' ) { @@ -495,7 +500,11 @@ sub load_sql { . ( $self->{user} ? " -u $self->{user} " : "" ) . ( $self->{password} ? " -p'$self->{password}'" : "" ) . " $self->{dbname} "; - $error = qx($strcmd --default-character-set=utf8 <$filename 2>&1 1>/dev/null); + my $globalfile= _find_global_mysql_counterpart($filename, $datadir); + #check if there is a global counterpart + #in that case we english-insert first and language-update second + $error.= _run_mysql_file($strcmd, $globalfile) if $globalfile; + $error.= _run_mysql_file($strcmd, $filename); } elsif ( $self->{dbms} eq 'Pg' ) { $cmd = qx(which psql 2>/dev/null || whereis psql 2>/dev/null); chomp $cmd; @@ -520,6 +529,81 @@ sub load_sql { return $error; } +sub _run_mysql_file { + my ($cmd, $file)= @_; +warn "L532: $file"; + return qx($cmd --default-character-set=utf8 <$file 2>&1 1>/dev/null); +} + +sub _find_global_mysql_counterpart { +# checks for a global counterpart file to be run before the lang sql file +# note ALSO that we are still in the process of converting files +# this is reflected in the contents of $counterpart + my ($fullpath, $datadir)= @_; + my ($lang, $sub, $file)= + _parse_sqlpath( substr( $fullpath, length($datadir))); + my $counterpart= _load_counterpart($lang); + + if(defined $counterpart ) { + my $global= $datadir.'/'.GLOBAL_SQL_FOLDER.'/'. + ($counterpart->{$sub}//$sub).'/'. + ($counterpart->{$file}//$file); + return $global if $global && -e $global; + } + return; +} + +sub _parse_sqlpath { #extract language, subfolder, filename + my $path= shift; + if( $path =~ /^\/?([^\/]+)\/(.*)\/([^\/]+)$/ ) { + return ($1, $2, $3); + } + return; +} + +sub _load_counterpart { + #TODO: Work in progress for other languages + #Started with de-DE/mandatory sql files + my $lang= shift||''; + my $hashref; + + if( $lang =~ /de-DE/ ) { #German: no filename changes + $hashref= { + 'marcflavour/marc21/mandatory' => 'skip_for_now', + 'marcflavour/marc21/optional' => 'skip_for_now', + optional => 'skip_for_now', + #only de-DE/mandatory will be found for now + }; + #this is enough to get it running without name conversions + } + elsif( $lang eq 'en' ) { #English: no filename changes + return undef; # as long as we do not have a separate global folder + + #TODO: Should we use en as global folder? Or have a global folder too? + #The global folder should contain inserts. + #The en folder would have updates and serve as a translation basis? + } + elsif( $lang =~ /es-ES/ ) { #Spanish + } + elsif( $lang =~ /fr-FR/ ) { #French: filename changes + $hashref= { + '1-Obligatoire' => 'mandatory', + }; + return undef; # not in use yet + } + elsif( $lang =~ /it-IT/ ) { #Italian + } + elsif( $lang =~ /nb-NO/ ) { #Norwegian + } + elsif( $lang =~ /pl-PL/ ) { #Polish + } + elsif( $lang =~ /ru-RU/ ) { #Russian + } + elsif( $lang =~ /uk-UA/ ) { #Ukrainian + } + return $hashref; +} + =head2 get_file_path_from_name my $filename = $installer->get_file_path_from_name('script_name'); diff --git a/installer/data/mysql/de-DE/mandatory/class_sources.sql b/installer/data/mysql/de-DE/mandatory/class_sources.sql index 3b0174b..ad1ce65 100644 --- a/installer/data/mysql/de-DE/mandatory/class_sources.sql +++ b/installer/data/mysql/de-DE/mandatory/class_sources.sql @@ -20,17 +20,33 @@ -- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. -- class sorting (filing) rules -INSERT INTO `class_sort_rules` (`class_sort_rule`, `description`, `sort_routine`) VALUES - ('dewey', 'Standard-Sortierregeln für DDC', 'Dewey'), - ('lcc', 'Standard-Sortierregeln für LCC', 'LCC'), - ('generic', 'Generische Sortierregeln für Signaturen', 'Generic'); +UPDATE class_sort_rules SET + description = 'Standard-Sortierregeln für DDC' +WHERE class_sort_rule = 'dewey'; +UPDATE class_sort_rules SET + description = 'Standard-Sortierregeln für LCC' +WHERE class_sort_rule = 'lcc'; +UPDATE class_sort_rules SET + description = 'Generische Sortierregeln für Signaturen' +WHERE class_sort_rule = 'generic'; -- classification schemes or sources -INSERT INTO `class_sources` (`cn_source`, `description`, `used`, `class_sort_rule`) VALUES - ('ddc', 'Dewey-Decimalklassifikation (DDC)', 1, 'dewey'), - ('lcc', 'Klassifikation der Library of Congress (LCC)', 1, 'lcc'), - ('udc', 'Universelle Dezimalklassifikation (UDC)', 0, 'generic'), - ('sudocs', 'SuDoc-Klassifikation (U.S. GPO)', 0, 'generic'), - ('anscr', 'ANSCR (Tonaufnahmen)', 0, 'generic'), - ('z', 'Andere/Generische Klassifikation', 0, 'generic'); +UPDATE class_sources SET + description = 'Dewey-Decimalklassifikation (DDC)' +WHERE cn_source = 'ddc'; +UPDATE class_sources SET + description = 'Klassifikation der Library of Congress (LCC)' +WHERE cn_source = 'lcc'; +UPDATE class_sources SET + description = 'Universelle Dezimalklassifikation (UDC)' +WHERE cn_source = 'udc'; +UPDATE class_sources SET + description = 'SuDoc-Klassifikation (U.S. GPO)' +WHERE cn_source = 'sudocs'; +UPDATE class_sources SET + description = 'ANSCR (Tonaufnahmen)' +WHERE cn_source = 'anscr'; +UPDATE class_sources SET + description = 'Andere/Generische Klassifikation' +WHERE cn_source = 'z'; diff --git a/installer/data/mysql/de-DE/mandatory/message_transport_types.sql b/installer/data/mysql/de-DE/mandatory/message_transport_types.sql index bbcb64c..9c01da3 100644 --- a/installer/data/mysql/de-DE/mandatory/message_transport_types.sql +++ b/installer/data/mysql/de-DE/mandatory/message_transport_types.sql @@ -1,7 +1,3 @@ -INSERT INTO message_transport_types -(message_transport_type) -values -('email'), -('print'), -('sms'), -('feed'); +-- At this moment this file is just a placeholder for the global sql file +-- with the same name. No translation is needed for now. +-- Do NOT delete this file. The webinstaller needs it to exist. diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql index 42a6f95..441c080 100644 --- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql +++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql @@ -1,25 +1,98 @@ -INSERT INTO `letter` (module, code, name, title, content) -VALUES ('circulation','ODUE','Mahnung','Mahnung','Liebe/r <> <>,\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<>\n<>\n<> <>\nTelefon: <>\nFax: <>\nEmail: <>\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"<>" by <>, <>, Barcode: <> Gebühr: <>\n\nVielen Dank für die schnelle Erledigung.\n\n< Ihr Bibliotheksteam\n'), -('claimacquisition','ACQCLAIM','Reklamation (Erwerbung)','Titel nicht eingetroffen','<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n\r\nOrdernumber <> (<>) (<> bestellt) (je $<> €) sind nicht eingetroffen.'), -('serial','RLIST','Neues Heft zugegangen','Zeitschrift ist jetzt verfügbar','<> <>,\r\n\r\nDas folgende Heft ist jetzt verfügbar:\r\n\r\n<>, <> (<>)\r\n\r\nBitte holen Sie es sobald möglich ab.'), -('members','ACCTDETAILS','Kontoinformationen - Standard','Ihr neues Benutzerkonto','Liebe/r <> <> <>.\r\n\r\nDie Daten Ihres neuen Benutzerkontos sind:\r\n\r\nBenutzer: <>\r\nPasswort: <>\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'), -('circulation','DUE','Fälligkeitsbenachrichtigung','Fälligkeitsbenachrichtigung','Liebe/r <> <>,\r\n\r\nDie folgenden Medien sind ab heute fällig:\r\n\r\n<>, <> (<>)'), -('circulation','DUEDGST','Fälligkeitsbenachrichtigung (Zusammenfassung)','Fälligkeitsbenachrichtigung','Sie haben <> überfällige Medien.'), -('circulation','PREDUE','Erinnerungsbenachrichtigung','Erinnerungsbenachrichtigung','Liebe/r <> <>,\r\n\r\nFolgende Ausleihe wird bald fällig:\r\n\r\n<>, <> (<>)'), -('circulation','PREDUEDGST','Erinnerungsbenachrichtigung (Zusammenfassung)','Erinnerungsbenachrichtigung','Sie haben <> Ausleihen, die bald fällig werden.'), -('circulation','RENEWAL','Verlängerungsbenachrichtigung','Verlängerungsquittung','Liebe/r <> <>,\r\n\r\nFolgede Exemplare wurden verlängert:\r\n----\r\n<>\r\n----\r\nVielen Dank,\r\n<>.'), -('reserves', 'HOLD', 'Vormerkbenachrichtigung', 'Vormerkung abholbereit in <>', 'Liebe/r <> <>,\r\n\r\nFür Sie liegt seit <> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <>\r\nVerfasser: <>\r\nExemplar: <>\r\nStandort: <>\r\n<>\r\n<>\r\n<>\r\n<> <>'), -('reserves', 'HOLD_PRINT', 'Vormerkbenachrichtigung (Print)', 'Vormerkbenachrichtigung (Print)', '<>\r\n<>\r\n<>\r\n<>\r\n<> <>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<> <>\r\n<>\r\n<>\r\n<> <>\r\n<>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nLiebe(r) <> <>,\r\n\r\nFür Sie liegt seit dem <> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <>\r\nVerfasser: <>\r\nSignatur: <>\r\n'), -('circulation','CHECKIN','Rückgabequittung (Zusammenfassung)','Rückgabequittung','Die folgenden Medien wurden zurückgegeben:\r\n----\r\n<>\r\n----\r\nVielen Dank.'), -('circulation','CHECKOUT','Ausleihquittung (Zusammenfassung)','Ausleihquittung','Die folgenden Medien wurden entliehen:\r\n----\r\n<>\r\n----\r\nVielen Dank für Ihren Besuch in <>.'), -('reserves', 'HOLDPLACED', 'Neue Vormerkung', 'Neue Vormerkung','Folgender Titel wurde vorgemerkt: <> (<>) durch den Benutzer <> <> (<>).'), -('suggestions','ACCEPTED','Anschaffungsvorschlag wurde angenommen', 'Ihr Anschaffungsvorschlag wurde angenommen','Liebe(r) <> <>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <> by <>.\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: <>.\n\nVielen Dank,\n\n<>'), -('suggestions','AVAILABLE','Vorgeschlagenes Medium verfügbar', 'Das vorgeschlagene Medium ist jetzt verfügbar','Liebe(r) <> <>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <> von <>.\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: <>.\n\nVielen Dank,\n\n<>'), -('suggestions','ORDERED','Vorgeschlagenes Medium bestellt', 'Das vorgeschlagene Medium wurde im Buchhandel bestellt','Liebe(r) <> <>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlaten: <> von <>.\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 <>.\n\nVielen Dank,\n\n<>'), -('suggestions','REJECTED','Anschaffungsvorschlag nicht angenommen', 'Ihr Anschaffungsvorschlag wurde nicht angenommen','Liebe(r) <> <>,\n\nSie haven der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <> von <>.\n\nDie Bibliothek hat diesen Titel heute recherchiert und sich gegen eine Anschaffung entschieden.\n\nBegründung: <>\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <>.\n\nVielen Dank,\n\n<>'); - -INSERT INTO `letter` (module, code, name, title, content, is_html) -VALUES ('circulation','ISSUESLIP','Ausleihquittung (Quittungsdruck)','Ausleihquittung (Quittungsdruck)', '

<>

+UPDATE letter SET + name = 'Mahnung', + title = 'Mahnung', + content = 'Liebe/r <> <>,\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<>\n<>\n<> <>\nTelefon: <>\nFax: <>\nEmail: <>\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"<>" by <>, <>, Barcode: <> Gebühr: <>\n\nVielen Dank für die schnelle Erledigung.\n\n< Ihr Bibliotheksteam\n' +WHERE module = 'circulation' AND code = 'ODUE'; +UPDATE letter SET + name = 'Reklamation (Erwerbung)', + title = 'Titel nicht eingetroffen', + content = '<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n\r\nOrdernumber <> (<>) (<> bestellt) (je $<> €) sind nicht eingetroffen.' +WHERE module = 'claimacquisition' AND code = 'ACQCLAIM'; +UPDATE letter SET + name = 'Neues Heft zugegangen', + title = 'Zeitschrift ist jetzt verfügbar', + content = '<> <>,\r\n\r\nDas folgende Heft ist jetzt verfügbar:\r\n\r\n<>, <> (<>)\r\n\r\nBitte holen Sie es sobald möglich ab.' +WHERE module = 'serial' AND code = 'RLIST'; +UPDATE letter SET + name = 'Kontoinformationen - Standard', + title = 'Ihr neues Benutzerkonto', + content = 'Liebe/r <> <> <>.\r\n\r\nDie Daten Ihres neuen Benutzerkontos sind:\r\n\r\nBenutzer: <>\r\nPasswort: <>\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' +WHERE module = 'members' AND code = 'ACCTDETAILS'; +UPDATE letter SET + name = 'Fälligkeitsbenachrichtigung', + title = 'Fälligkeitsbenachrichtigung', + content = 'Liebe/r <> <>,\r\n\r\nDie folgenden Medien sind ab heute fällig:\r\n\r\n<>, <> (<>)' +WHERE module = 'circulation' AND code = 'DUE'; +UPDATE letter SET + name = 'Fälligkeitsbenachrichtigung (Zusammenfassung)', + title = 'Fälligkeitsbenachrichtigung', + content = 'Sie haben <> überfällige Medien.' +WHERE module = 'circulation' AND code = 'DUEDGST'; +UPDATE letter SET + name = 'Erinnerungsbenachrichtigung', + title = 'Erinnerungsbenachrichtigung', + content = 'Liebe/r <> <>,\r\n\r\nFolgende Ausleihe wird bald fällig:\r\n\r\n<>, <> (<>)' +WHERE module = 'circulation' AND code = 'PREDUE'; +UPDATE letter SET + name = 'Erinnerungsbenachrichtigung (Zusammenfassung)', + title = 'Erinnerungsbenachrichtigung', + content = 'Sie haben <> Ausleihen, die bald fällig werden.' +WHERE module = 'circulation' AND code = 'PREDUEDGST'; +UPDATE letter SET + name = 'Verlängerungsbenachrichtigung', + title = 'Verlängerungsquittung', + content = 'Liebe/r <> <>,\r\n\r\nFolgede Exemplare wurden verlängert:\r\n----\r\n<>\r\n----\r\nVielen Dank,\r\n<>.' +WHERE module = 'circulation' AND code = 'RENEWAL'; +UPDATE letter SET + name = 'Vormerkbenachrichtigung', + title = 'Vormerkung abholbereit in <>', + content = 'Liebe/r <> <>,\r\n\r\nFür Sie liegt seit <> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <>\r\nVerfasser: <>\r\nExemplar: <>\r\nStandort: <>\r\n<>\r\n<>\r\n<>\r\n<> <>' +WHERE module = 'reserves' AND code = 'HOLD'; +UPDATE letter SET + name = 'Vormerkbenachrichtigung (Print)', + title = 'Vormerkbenachrichtigung (Print)', + content = '<>\r\n<>\r\n<>\r\n<>\r\n<> <>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<> <>\r\n<>\r\n<>\r\n<> <>\r\n<>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nLiebe(r) <> <>,\r\n\r\nFür Sie liegt seit dem <> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <>\r\nVerfasser: <>\r\nSignatur: <>\r\n' +WHERE module = 'reserves' AND code = 'HOLD_PRINT'; +UPDATE letter SET + name = 'Rückgabequittung (Zusammenfassung)', + title = 'Rückgabequittung', + content = 'Die folgenden Medien wurden zurückgegeben:\r\n----\r\n<>\r\n----\r\nVielen Dank.' +WHERE module = 'circulation' AND code = 'CHECKIN'; +UPDATE letter SET + name = 'Ausleihquittung (Zusammenfassung)', + title = 'Ausleihquittung', + content = 'Die folgenden Medien wurden entliehen:\r\n----\r\n<>\r\n----\r\nVielen Dank für Ihren Besuch in <>.' +WHERE module = 'circulation' AND code = 'CHECKOUT'; +UPDATE letter SET + name = 'Neue Vormerkung', + title = 'Neue Vormerkung', + content = 'Folgender Titel wurde vorgemerkt: <> (<>) durch den Benutzer <> <> (<>).' +WHERE module = 'reserves' AND code = 'HOLDPLACED'; +UPDATE letter SET + name = 'Anschaffungsvorschlag wurde angenommen', + title = 'Ihr Anschaffungsvorschlag wurde angenommen', + content = 'Liebe(r) <> <>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <> by <>.\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: <>.\n\nVielen Dank,\n\n<>' +WHERE module = 'suggestions' AND code = 'ACCEPTED'; +UPDATE letter SET + name = 'Vorgeschlagenes Medium verfügbar', + title = 'Das vorgeschlagene Medium ist jetzt verfügbar', + content = 'Liebe(r) <> <>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <> von <>.\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: <>.\n\nVielen Dank,\n\n<>' +WHERE module = 'suggestions' AND code = 'AVAILABLE'; +UPDATE letter SET + name = 'Vorgeschlagenes Medium bestellt', + title = 'Das vorgeschlagene Medium wurde im Buchhandel bestellt', + content = 'Liebe(r) <> <>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlaten: <> von <>.\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 <>.\n\nVielen Dank,\n\n<>' +WHERE module = 'suggestions' AND code = 'ORDERED'; +UPDATE letter SET + name = 'Anschaffungsvorschlag nicht angenommen', + title = 'Ihr Anschaffungsvorschlag wurde nicht angenommen', + content = 'Liebe(r) <> <>,\n\nSie haven der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <> von <>.\n\nDie Bibliothek hat diesen Titel heute recherchiert und sich gegen eine Anschaffung entschieden.\n\nBegründung: <>\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <>.\n\nVielen Dank,\n\n<>' +WHERE module = 'suggestions' AND code = 'REJECTED'; + +UPDATE letter SET + name = 'Ausleihquittung (Quittungsdruck)', + title = 'Ausleihquittung (Quittungsdruck)', + content = '

<>

Ausleihe an: <> <> <>
(<>)
@@ -53,8 +126,13 @@ Fällig am: <>

Posted on <>


-', 1), -('circulation','ISSUEQSLIP','Kurzquittung','Kurzquittung', '

<>

+', + is_html = 1 +WHERE module = 'circulation' AND code = 'ISSUESLIP'; +UPDATE letter SET + name = 'Kurzquittung', + title = 'Kurzquittung', + content = '

<>

Ausleihe an: <> <> <>
(<>)
@@ -67,8 +145,13 @@ Ausleihe an: <> <> < Barcode: <>
Fällig am: <>

-', 1), -('circulation','RESERVESLIP','Vormerkquittung','Vormerkquittung', '
Datum: <>
+', + is_html = 1 +WHERE module = 'circulation' AND code = 'ISSUEQSLIP'; +UPDATE letter SET + name = 'Vormerkquittung', + title = 'Vormerkquittung', + content = '
Datum: <>

Bereitstellung in <>

@@ -95,8 +178,13 @@ Fällig am: <>

Notiz:

<>

-', 1), -('circulation','TRANSFERSLIP','Transportquittung','Transportquittung', '
Datum: <>
+', + is_html = 1 +WHERE module = 'circulation' AND code = 'RESERVESLIP'; +UPDATE letter SET + name = 'Transportquittung', + title = 'Transportquittung', + content = '
Datum: <>

Transport nach <>

@@ -106,11 +194,15 @@ Fällig am: <>
  • <>
  • <>
  • -
', 1); +', + is_html = 1 +WHERE module = 'circulation' AND code = 'TRANSFERSLIP'; -INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`) -VALUES ( -'members', 'OPAC_REG_VERIFY', '', 'Bestätigung der Anmeldung zur Bibliotheksnutzung', '1', 'Verify Your Account', 'Guten Tag, +UPDATE letter SET + name = 'Bestätigung der Anmeldung zur Bibliotheksnutzung', + is_html = '1', + title = 'Verify Your Account', + content = 'Guten Tag, Ihr Bibliothekskonto wurde angelegt. Bitte bestätigen Sie Ihre Emailadresse, indem Sie auf folgenden Link klicken: @@ -120,4 +212,4 @@ Wenn Sie keine Kontoanmeldung durchgeführt haben, können Sie diese Benachricht Vielen Dank, Ihr Bibliotheksteam' -); +WHERE module = 'members' AND code = 'OPAC_REG_VERIFY'; diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql b/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql index b078106..9c01da3 100644 --- a/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql +++ b/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql @@ -1,8 +1,3 @@ -insert into `message_attributes` -(`message_attribute_id`, message_name, `takes_days`) -values -(1, 'Item_Due', 0), -(2, 'Advance_Notice', 1), -(4, 'Hold_Filled', 0), -(5, 'Item_Check_in', 0), -(6, 'Item_Checkout', 0); \ No newline at end of file +-- At this moment this file is just a placeholder for the global sql file +-- with the same name. No translation is needed for now. +-- Do NOT delete this file. The webinstaller needs it to exist. diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql index ae68378..9c01da3 100644 --- a/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql +++ b/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql @@ -1,17 +1,3 @@ -insert into `message_transports` -(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`) -values -(1, 'email', 0, 'circulation', 'DUE'), -(1, 'email', 1, 'circulation', 'DUEDGST'), -(2, 'email', 0, 'circulation', 'PREDUE'), -(2, 'email', 1, 'circulation', 'PREDUEDGST'), -(4, 'email', 0, 'reserves', 'HOLD'), -(1, 'sms', 0, 'circulation', 'DUE'), -(1, 'sms', 1, 'circulation', 'DUEDGST'), -(2, 'sms', 0, 'circulation', 'PREDUE'), -(2, 'sms', 1, 'circulation', 'PREDUEDGST'), -(4, 'sms', 0, 'reserves', 'HOLD'), -(5, 'email', 0, 'circulation', 'CHECKIN'), -(5, 'sms', 0, 'circulation', 'CHECKIN'), -(6, 'email', 0, 'circulation', 'CHECKOUT'), -(6, 'sms', 0, 'circulation', 'CHECKOUT'); +-- At this moment this file is just a placeholder for the global sql file +-- with the same name. No translation is needed for now. +-- Do NOT delete this file. The webinstaller needs it to exist. diff --git a/installer/data/mysql/de-DE/mandatory/stopwords.sql b/installer/data/mysql/de-DE/mandatory/stopwords.sql index 1bf4725..9c01da3 100644 --- a/installer/data/mysql/de-DE/mandatory/stopwords.sql +++ b/installer/data/mysql/de-DE/mandatory/stopwords.sql @@ -1,99 +1,3 @@ -INSERT INTO stopwords VALUES -('a'), -('about'), -('also'), -('an'), -('and'), -('another'), -('any'), -('are'), -('as'), -('at'), -('back'), -('be'), -('because'), -('been'), -('being'), -('but'), -('by'), -('can'), -('could'), -('did'), -('do'), -('each'), -('end'), -('even'), -('for'), -('from'), -('get'), -('go'), -('had'), -('have'), -('he'), -('her'), -('here'), -('his'), -('how'), -('i'), -('if'), -('in'), -('into'), -('is'), -('it'), -('just'), -('may'), -('me'), -('might'), -('much'), -('must'), -('my'), -('no'), -('not'), -('of'), -('off'), -('on'), -('only'), -('or'), -('other'), -('our'), -('out'), -('should'), -('so'), -('some'), -('still'), -('such'), -('than'), -('that'), -('the'), -('their'), -('them'), -('then'), -('there'), -('these'), -('they'), -('this'), -('those'), -('to'), -('too'), -('try'), -('two'), -('under'), -('up'), -('us'), -('was'), -('we'), -('were'), -('what'), -('when'), -('where'), -('which'), -('while'), -('who'), -('why'), -('will'), -('with'), -('within'), -('without'), -('would'), -('you'), -('your'); +-- At this moment this file is just a placeholder for the global sql file +-- with the same name. No translation is needed for now. +-- Do NOT delete this file. The webinstaller needs it to exist. diff --git a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql b/installer/data/mysql/de-DE/mandatory/subtag_registry.sql index 9663c5c..9c01da3 100644 --- a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql +++ b/installer/data/mysql/de-DE/mandatory/subtag_registry.sql @@ -1,897 +1,3 @@ --- http://www.w3.org/International/articles/language-tags/ - --- BIDI Stuff, Arabic and Hebrew -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Arab', 'rtl'); -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Hebr', 'rtl'); - --- Default mappings between script and language subcodes -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'ar', 'Arab'); -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'he', 'Hebr'); - --- EXTENSIONS --- Interface (i) --- SELECT * FROM language_subtag_registry WHERE type='i'; --- OPAC -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'opac', 'i', 'OPAC','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'opac', 'i', 'en', 'OPAC'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'opac', 'i', 'fr', 'OPAC'); - --- Staff Client -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'intranet', 'i', 'en', 'Staff Client'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'intranet', 'i', 'fr', '????'); - --- Theme (t) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'prog', 't', 'Prog','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 't', 'en', 'Prog'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 't', 'fr', 'Prog'); - --- LANGUAGES - --- Arabic -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ar', 'language', 'Arabic','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ar','ara'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'ar', 'language', 'ar', 'العربية'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'en', 'Arabic'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'fr', 'Arabe'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'de', 'Arabisch'); - --- Armenian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hy', 'language', 'Armenian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hy','arm'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'hy', 'language', 'hy', 'Հայերէն'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'en', 'Armenian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'fr', 'Armenian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'de', 'Armenisch'); - --- Bulgarian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'bg','bul'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'bg', 'language', 'bg', 'Български'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'en', 'Bulgarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'fr', 'Bulgare'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'de', 'Bulgarisch'); - --- Chinese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'zh', 'language', 'Chinese','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'zh','chi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'zh', 'language', 'zh', '中文'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'zh', 'language', 'en', 'Chinese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'zh', 'language', 'fr', 'Chinois'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'zh', 'language', 'de', 'Chinesisch'); - --- Czech -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'cs', 'language', 'Czech','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'cs','cze'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'cs', 'language', 'cs', 'čeština'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'en', 'Czech'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'fr', 'Tchèque'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'de', 'Tschechisch'); - --- Danish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'da', 'language', 'Danish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'da','dan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'da', 'language', 'da', 'Dansk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'en', 'Danish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'fr', 'Danois'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'de', 'Dänisch'); - --- Dutch, Flemish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nl', 'language', 'Dutch','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nl','dut'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'nl', 'language', 'nl', 'Nederlands'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'en', 'Dutch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'fr', 'Néerlandais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'de', 'Niederländisch'); - --- English -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'en', 'language', 'English','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'en','eng'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'en', 'English'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'fr', 'Anglais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'de', 'Englisch'); - --- Finnish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fi', 'language', 'Finnish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fi','fin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'fi', 'suomi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'en', 'Finnish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'de', 'Finnisch'); - --- French -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fr', 'language', 'French','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fr','fre'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'en', 'French'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'fr', 'Français'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'de', 'Französisch'); - --- INSERT INTO language_descriptions(subtag, type, lang, description) --- VALUES( 'fr-CA', 'language', 'fr-CA', 'français'); - --- Lao -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'lo', 'language', 'Lao','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'lo','lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'en', 'Lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'fr', 'Laotien'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'de', 'Laotisch'); - --- German -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'de', 'language', 'German','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'de','ger'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'de', 'Deutsch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'en', 'German'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'fr', 'Allemand'); - --- Greek -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'el','gre'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'el', 'ελληνικά'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'de', 'Griechisch (Nach 1453)'); - --- Hebrew -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'he', 'language', 'Hebrew','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'he','heb'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'he', 'עברית'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'en', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'fr', 'Hébreu'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'de', 'Hebräisch'); - --- Hindi -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hi', 'language', 'Hindi','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hi','hin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'hi', 'हिन्दी'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'en', 'Hindi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'fr', 'Hindi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'de', 'Hindi'); - --- Hungarian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hu','hun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'hu', 'Magyar'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'en', 'Hungarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'fr', 'Hongrois'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'de', 'Ungarisch'); - --- Indonesian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'id', 'language', 'Indonesian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'id','ind'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'id', 'Bahasa Indonesia'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'en', 'Indonesian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'fr', 'Indonésien'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'de', 'Indonesisch'); - --- Italian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'it', 'language', 'Italian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'it','ita'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'it', 'Italiano'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'en', 'Italian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'fr', 'Italien'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'de', 'Italienisch'); - --- Japanese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ja', 'language', 'Japanese','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ja','jpn'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'ja', '日本語'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'en', 'Japanese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'fr', 'Japonais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'de', 'Japanisch'); - --- Korean -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ko', 'language', 'Korean','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ko','kor'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'ko', '한국어'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'en', 'Korean'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'fr', 'Coréen'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'de', 'Koreanisch'); - --- Latin -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'la', 'language', 'Latin','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'la','lat'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'la', 'Latina'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'en', 'Latin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'fr', 'Latin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'de', 'Latein'); - --- Galician - -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'gl', 'language', 'Galician','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'gl','glg'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'gl', 'Galego'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'en', 'Galician'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'fr', 'Galicien'); - --- Norwegian (bokmål) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nb','nor'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nb','nob'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'nb', 'Norsk bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'en', 'Norwegian bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'de', 'Norwegisch bokmål'); - --- Norwegian (nynorsk) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nn','nno'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk'); - --- Persian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fa', 'language', 'Persian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fa','per'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fa', 'فارسى'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'en', 'Persian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fr', 'Persan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'de', 'Persisch'); - --- Polish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pl', 'language', 'Polish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pl','pol'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'pl', 'Polski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'en', 'Polish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'fr', 'Polonais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'de', 'Polnisch'); - --- Portuguese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pt','por'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'pt', 'Português'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'en', 'Portuguese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'fr', 'Portugais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'de', 'Portugiesisch'); - --- Romanian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ro','rum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'ro', 'Română'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'en', 'Romanian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'fr', 'Roumain'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'de', 'Rumänisch'); - --- Russian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ru', 'language', 'Russian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ru','rus'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'ru', 'Русский'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'en', 'Russian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'fr', 'Russe'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'de', 'Russisch'); - --- Serbian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sr', 'language', 'Serbian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'sr','srp'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'sr', 'српски'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'en', 'Serbian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'fr', 'Serbe'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'de', 'Serbisch'); - --- Spanish, Castilian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'es','spa'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'es', 'Español'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'en', 'Spanish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'fr', 'Espagnol'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'de', 'Spanisch'); - --- Spanish, Catalan -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ca', 'language', 'Catalan','2013-01-12' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ca','cat'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'es', 'Catalán'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'en', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'fr', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'ca', 'Català'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'de', 'Katalanisch'); - --- Swedish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'sv','swe'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'sv', 'Svenska'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'en', 'Swedish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'fr', 'Suédois'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'de', 'Schwedisch'); - --- Tetum -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'tet', 'language', 'Tetum','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'tet','tet'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'tet', 'tetun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'en', 'Tetum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'fr', 'Tétoum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'de', 'Tetum'); - --- Thai -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'th', 'language', 'Thai','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'th','tha'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'th', 'ภาษาไทย'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'en', 'Thai'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'fr', 'Thaï'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'de', 'Thailändisch'); - --- Turkish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'tr', 'language', 'Turkish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'tr','tur'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tr', 'language', 'tr', 'Türkçe'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tr', 'language', 'en', 'Turkish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tr', 'language', 'fr', 'Turc'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tr', 'language', 'de', 'Türkisch'); - --- Ukranian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'uk', 'language', 'Ukranian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'uk','ukr'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'uk', 'language', 'uk', 'Українська'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'uk', 'language', 'en', 'Ukranian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'uk', 'language', 'fr', 'Ukrainien'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'uk', 'language', 'de', 'Ukrainisch'); - --- Urdu -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ur', 'language', 'Urdu','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ur','urd'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ur', 'language', 'en', 'Urdu'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ur', 'language', 'ur', 'اردو'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ur', 'language', 'fr', 'Ourdou'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ur', 'language', 'de', 'Urdu'); - --- SCRIPTS --- Arabic -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Arab', 'script', 'Arabic','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Arab','script', 'Arab', 'العربية'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Arab', 'script','en', 'Arabic'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Arab', 'script','fr', 'Arabic'); - --- Cyrillic -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Cyrl', 'script', 'Cyrl', '????'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Cyrl', 'script', 'en', 'Cyrillic'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic'); - --- Greek -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Grek', 'script', 'Greek','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Grek', 'script', 'Grek', '????'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Grek', 'script', 'en', 'Greek'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Grek', 'script', 'fr', 'Greek'); - --- Han - Simplified -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)'); - --- Han - Traditional -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)'); - --- Hebrew -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hebr', 'script', 'en', 'Hebrew'); - --- Lao -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Laoo', 'script', 'Lao','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Laoo', 'script', 'lo', 'Lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Laoo', 'script', 'en', 'Lao'); - --- REGIONS --- Canada -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'CA', 'region', 'Canada','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'CA', 'region', 'en', 'Canada'); - --- Denmark -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'DK', 'region', 'Denmark','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'DK', 'region', 'dk', 'Danmark'); - --- France -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'FR', 'region', 'France','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'FR', 'region', 'fr', 'France'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'FR', 'region', 'en', 'France'); - --- New Zealand -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'NZ', 'region', 'en', 'New Zealand'); - --- United Kingdom -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'GB', 'region', 'en', 'United Kingdom'); - --- United States -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'US', 'region', 'United States','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'US', 'region', 'en', 'United States'); +-- At this moment this file is just a placeholder for the global sql file +-- with the same name. No translation is needed for now. +-- Do NOT delete this file. The webinstaller needs it to exist. diff --git a/installer/data/mysql/de-DE/mandatory/userflags.sql b/installer/data/mysql/de-DE/mandatory/userflags.sql index e9b7f2d..72a3538 100644 --- a/installer/data/mysql/de-DE/mandatory/userflags.sql +++ b/installer/data/mysql/de-DE/mandatory/userflags.sql @@ -1,19 +1,57 @@ -INSERT INTO `userflags` VALUES(0,'superlibrarian','Zugriff auf alle Funktionen',0); -INSERT INTO `userflags` VALUES(1,'circulate','Medien ausleihen/zurückgeben',0); -INSERT INTO `userflags` VALUES(2,'catalogue','Katalogsuche verwenden (Dienstoberfläche)',0); -INSERT INTO `userflags` VALUES(3,'parameters','Systemparameter verändern',0); -INSERT INTO `userflags` VALUES(4,'borrowers','Benutzer anlegen/ändern',0); -INSERT INTO `userflags` VALUES(5,'permissions','Berechtigungen für Benutzer vergeben',0); -INSERT INTO `userflags` VALUES(6,'reserveforothers','Vormerkungen für Benutzer setzen/ändern',0); -INSERT INTO `userflags` VALUES(7,'borrow','Medien entleihen',1); -INSERT INTO `userflags` VALUES(9,'editcatalogue','Katalogdaten ändern (Titel- und Bestandsdaten ändern)',0); -INSERT INTO `userflags` VALUES(10,'updatecharges','Gebühren kassieren/ändern',0); -INSERT INTO `userflags` VALUES(11,'acquisition','Erwerbung und Verwaltung von Anschaffungsvorschlägen',0); -INSERT INTO `userflags` VALUES(12,'management','Zugriff auf Administration',0); -INSERT INTO `userflags` VALUES(13,'tools','Werkzeuge verwenden (Export, Import, Etikettendruck)',0); -INSERT INTO `userflags` VALUES(14,'editauthorities','Normdaten ändern',0); -INSERT INTO `userflags` VALUES(15,'serials','Zugriff auf Abonnementverwaltung/Zeitschriftenmodul',0); -INSERT INTO `userflags` VALUES(16,'reports','Zugriff auf Reportmodul',0); -INSERT INTO `userflags` VALUES(17,'staffaccess','Berechtigungen/Logins für Bibliotheksmitarbeiter vergeben',0); -INSERT INTO `userflags` VALUES(18,'coursereserves','Course Reserves',0); -INSERT INTO `userflags` VALUES(19,'plugins', 'Koha Plugins', '0'); +UPDATE userflags SET + flagdesc = 'Zugriff auf alle Funktionen' +WHERE bit = 0 AND flag = 'superlibrarian'; +UPDATE userflags SET + flagdesc = 'Medien ausleihen/zurückgeben' +WHERE bit = 1 AND flag = 'circulate'; +UPDATE userflags SET + flagdesc = 'Katalogsuche verwenden (Dienstoberfläche)' +WHERE bit = 2 AND flag = 'catalogue'; +UPDATE userflags SET + flagdesc = 'Systemparameter verändern' +WHERE bit = 3 AND flag = 'parameters'; +UPDATE userflags SET + flagdesc = 'Benutzer anlegen/ändern' +WHERE bit = 4 AND flag = 'borrowers'; +UPDATE userflags SET + flagdesc = 'Berechtigungen für Benutzer vergeben' +WHERE bit = 5 AND flag = 'permissions'; +UPDATE userflags SET + flagdesc = 'Vormerkungen für Benutzer setzen/ändern' +WHERE bit = 6 AND flag = 'reserveforothers'; +UPDATE userflags SET + flagdesc = 'Medien entleihen' +WHERE bit = 7 AND flag = 'borrow'; +UPDATE userflags SET + flagdesc = 'Katalogdaten ändern (Titel- und Bestandsdaten ändern)' +WHERE bit = 9 AND flag = 'editcatalogue'; +UPDATE userflags SET + flagdesc = 'Gebühren kassieren/ändern' +WHERE bit = 10 AND flag = 'updatecharges'; +UPDATE userflags SET + flagdesc = 'Erwerbung und Verwaltung von Anschaffungsvorschlägen' +WHERE bit = 11 AND flag = 'acquisition'; +UPDATE userflags SET + flagdesc = 'Zugriff auf Administration' +WHERE bit = 12 AND flag = 'management'; +UPDATE userflags SET + flagdesc = 'Werkzeuge verwenden (Export, Import, Etikettendruck)' +WHERE bit = 13 AND flag = 'tools'; +UPDATE userflags SET + flagdesc = 'Normdaten ändern' +WHERE bit = 14 AND flag = 'editauthorities'; +UPDATE userflags SET + flagdesc = 'Zugriff auf Abonnementverwaltung/Zeitschriftenmodul' +WHERE bit = 15 AND flag = 'serials'; +UPDATE userflags SET + flagdesc = 'Zugriff auf Reportmodul' +WHERE bit = 16 AND flag = 'reports'; +UPDATE userflags SET + flagdesc = 'Berechtigungen/Logins für Bibliotheksmitarbeiter vergeben' +WHERE bit = 17 AND flag = 'staffaccess'; +UPDATE userflags SET + flagdesc = 'Course Reserves' +WHERE bit = 18 AND flag = 'coursereserves'; +UPDATE userflags SET + flagdesc = 'Koha Plugins' +WHERE bit = 19 AND flag = 'plugins'; diff --git a/installer/data/mysql/de-DE/mandatory/userpermissions.sql b/installer/data/mysql/de-DE/mandatory/userpermissions.sql index eb2d48a..b1a81f2 100644 --- a/installer/data/mysql/de-DE/mandatory/userpermissions.sql +++ b/installer/data/mysql/de-DE/mandatory/userpermissions.sql @@ -1,63 +1,183 @@ -INSERT INTO permissions (module_bit, code, description) VALUES - ( 1, 'circulate_remaining_permissions', 'Übrige Ausleihberechtigungen'), - ( 1, 'override_renewals', 'Gesperrte Verlängerungen überschreiben'), - ( 1, 'overdues_report', 'Überfälligkeiten-Report ausführen'), - ( 3, 'parameters_remaining_permissions', 'Übrige Administrationsberechtigungen'), - ( 3, 'manage_circ_rules', 'Ausleihkonditionen verwalten'), - ( 6, 'place_holds', 'Vormerkungen für Benutzer setzen'), - ( 6, 'modify_holds_priority', 'Vormerkungspriorität verändern'), - ( 9, 'edit_catalogue', 'Katalogdaten bearbeiten (Titel- und Exemplardaten ändern)'), - ( 9, 'fast_cataloging', 'Schnellaufnahmen anlegen'), - ( 9, 'edit_items', 'Exemplare bearbeiten'), - (11, 'vendors_manage', 'Lieferanten verwalten'), - (11, 'contracts_manage', 'Vereinbarungen verwalten'), - (11, 'period_manage', 'Etats verwalten'), - (11, 'budget_manage', 'Konten verwalten'), - (11, 'budget_modify', 'Konten verändern (keine Neuen anlegen, aber Bestehende ändern)'), - (11, 'planning_manage', 'Etatplanung verwalten'), - (11, 'order_manage', 'Bestellungen verwalten'), - (11, 'group_manage', 'Bestellgruppen vewalten'), - (11, 'order_receive', 'Lieferungen verwalten'), - (11, 'budget_add_del', 'Konten hinzufügen/ändern, aber bestehende nicht ändern'), - (11, 'budget_manage_all', 'Alle Konten verwalten'), - (13, 'edit_news', 'Nachrichten für OPAC und Dienstoberfläche verfassen'), - (13, 'label_creator', 'Etiketten und Barcodes aus Katalog- und Benutzerdaten erstellen'), - (13, 'edit_calendar', 'Schließtage eintragen'), - (13, 'moderate_comments', 'Benutzerkommentare moderieren'), - (13, 'edit_notices', 'Benachrichtigungen verwalten'), - (13, 'edit_notice_status_triggers', 'Mahntrigger für überfällige Medien verwalten'), - (13, 'edit_quotes', '"Zitat des Tages" konfigurieren'), - (13, 'view_system_logs', 'Logs durchsuchen/einsehen'), - (13, 'inventory', 'Inventur durchführen'), - (13, 'stage_marc_import', 'MARC-Datensätze zwischenspeichern'), - (13, 'manage_staged_marc', 'MARC-Importe verwalten, auch Übernahme in Katalog und Import rückgängig machen'), - (13, 'export_catalog', 'Titel- und Exemplardaten exportieren'), - (13, 'import_patrons', 'Benutzerdaten importieren'), - (13, 'edit_patrons', 'Stapelbearbeitung von Benutzerdaten durchführen'), - (13, 'delete_anonymize_patrons', 'Inaktive Benutzer löschen und Ausleihhistorie anonymisieren (Benutzerausleihhistorie löschen)'), - (13, 'batch_upload_patron_images', 'Benutzerfotos einzeln oder im Stapel hochladen'), - (13, 'schedule_tasks', 'Aufgabenplaner verwenden'), - (13, 'items_batchmod', 'Stapelbearbeitung von Exemplaren durchführen'), - (13, 'items_batchdel', 'Stapellöschung von Exemplaren durchführen'), - (13, 'manage_csv_profiles', 'CSV-Profile für Export verwalten'), - (13, 'moderate_tags', 'Von Benutzern vergebene Tags moderieren'), - (13, 'rotating_collections', 'Wandernde Sammlungen verwalten'), - (13, 'upload_local_cover_images', 'Eigene Coverbilder hochladen'), - (15, 'check_expiration', 'Ablauf eines Abonnements prüfen'), - (15, 'claim_serials', 'Fehlende Hefte reklamieren'), - (15, 'create_subscription', 'Neues Abonnement anlegen'), - (15, 'delete_subscription', 'Bestehende Abonnements löschen'), - (15, 'edit_subscription', 'Bestehende Abonnements bearbeiten'), - (15, 'receive_serials', 'Zugang von Heften'), - (15, 'renew_subscription', 'Abonnements verlängern'), - (15, 'routing', 'Umlauflisten verwalten'), - (16, 'execute_reports', 'SQL-Reports ausführen'), - (16, 'create_reports', 'SQL-Reports erstellen'), - (18, 'manage_courses', 'Add, edit and delete courses'), - (18, 'add_reserves', 'Add course reserves'), - (18, 'delete_reserves', 'Remove course reserves'), - (19, 'manage', 'Plugins verwealten (installieren/deinstallieren)'), - (19, 'tool', 'Werkzeug-Plugins verwenden'), - (19, 'report', 'Report-Plugins verwenden'), - (19, 'configure', 'Plugins konfigurieren') -; +UPDATE permissions SET + description = 'Übrige Ausleihberechtigungen' +WHERE module_bit = 1 AND code = 'circulate_remaining_permissions'; +UPDATE permissions SET + description = 'Gesperrte Verlängerungen überschreiben' +WHERE module_bit = 1 AND code = 'override_renewals'; +UPDATE permissions SET + description = 'Überfälligkeiten-Report ausführen' +WHERE module_bit = 1 AND code = 'overdues_report'; +UPDATE permissions SET + description = 'Übrige Administrationsberechtigungen' +WHERE module_bit = 3 AND code = 'parameters_remaining_permissions'; +UPDATE permissions SET + description = 'Ausleihkonditionen verwalten' +WHERE module_bit = 3 AND code = 'manage_circ_rules'; +UPDATE permissions SET + description = 'Vormerkungen für Benutzer setzen' +WHERE module_bit = 6 AND code = 'place_holds'; +UPDATE permissions SET + description = 'Vormerkungspriorität verändern' +WHERE module_bit = 6 AND code = 'modify_holds_priority'; +UPDATE permissions SET + description = 'Katalogdaten bearbeiten (Titel- und Exemplardaten ändern)' +WHERE module_bit = 9 AND code = 'edit_catalogue'; +UPDATE permissions SET + description = 'Schnellaufnahmen anlegen' +WHERE module_bit = 9 AND code = 'fast_cataloging'; +UPDATE permissions SET + description = 'Exemplare bearbeiten' +WHERE module_bit = 9 AND code = 'edit_items'; +UPDATE permissions SET + description = 'Lieferanten verwalten' +WHERE module_bit = 11 AND code = 'vendors_manage'; +UPDATE permissions SET + description = 'Vereinbarungen verwalten' +WHERE module_bit = 11 AND code = 'contracts_manage'; +UPDATE permissions SET + description = 'Etats verwalten' +WHERE module_bit = 11 AND code = 'period_manage'; +UPDATE permissions SET + description = 'Konten verwalten' +WHERE module_bit = 11 AND code = 'budget_manage'; +UPDATE permissions SET + description = 'Konten verändern (keine Neuen anlegen, aber Bestehende ändern)' +WHERE module_bit = 11 AND code = 'budget_modify'; +UPDATE permissions SET + description = 'Etatplanung verwalten' +WHERE module_bit = 11 AND code = 'planning_manage'; +UPDATE permissions SET + description = 'Bestellungen verwalten' +WHERE module_bit = 11 AND code = 'order_manage'; +UPDATE permissions SET + description = 'Bestellgruppen vewalten' +WHERE module_bit = 11 AND code = 'group_manage'; +UPDATE permissions SET + description = 'Lieferungen verwalten' +WHERE module_bit = 11 AND code = 'order_receive'; +UPDATE permissions SET + description = 'Konten hinzufügen/ändern, aber bestehende nicht ändern' +WHERE module_bit = 11 AND code = 'budget_add_del'; +UPDATE permissions SET + description = 'Alle Konten verwalten' +WHERE module_bit = 11 AND code = 'budget_manage_all'; +UPDATE permissions SET + description = 'Nachrichten für OPAC und Dienstoberfläche verfassen' +WHERE module_bit = 13 AND code = 'edit_news'; +UPDATE permissions SET + description = 'Etiketten und Barcodes aus Katalog- und Benutzerdaten erstellen' +WHERE module_bit = 13 AND code = 'label_creator'; +UPDATE permissions SET + description = 'Schließtage eintragen' +WHERE module_bit = 13 AND code = 'edit_calendar'; +UPDATE permissions SET + description = 'Benutzerkommentare moderieren' +WHERE module_bit = 13 AND code = 'moderate_comments'; +UPDATE permissions SET + description = 'Benachrichtigungen verwalten' +WHERE module_bit = 13 AND code = 'edit_notices'; +UPDATE permissions SET + description = 'Mahntrigger für überfällige Medien verwalten' +WHERE module_bit = 13 AND code = 'edit_notice_status_triggers'; +UPDATE permissions SET + description = '"Zitat des Tages" konfigurieren' +WHERE module_bit = 13 AND code = 'edit_quotes'; +UPDATE permissions SET + description = 'Logs durchsuchen/einsehen' +WHERE module_bit = 13 AND code = 'view_system_logs'; +UPDATE permissions SET + description = 'Inventur durchführen' +WHERE module_bit = 13 AND code = 'inventory'; +UPDATE permissions SET + description = 'MARC-Datensätze zwischenspeichern' +WHERE module_bit = 13 AND code = 'stage_marc_import'; +UPDATE permissions SET + description = 'MARC-Importe verwalten, auch Übernahme in Katalog und Import rückgängig machen' +WHERE module_bit = 13 AND code = 'manage_staged_marc'; +UPDATE permissions SET + description = 'Titel- und Exemplardaten exportieren' +WHERE module_bit = 13 AND code = 'export_catalog'; +UPDATE permissions SET + description = 'Benutzerdaten importieren' +WHERE module_bit = 13 AND code = 'import_patrons'; +UPDATE permissions SET + description = 'Stapelbearbeitung von Benutzerdaten durchführen' +WHERE module_bit = 13 AND code = 'edit_patrons'; +UPDATE permissions SET + description = 'Inaktive Benutzer löschen und Ausleihhistorie anonymisieren (Benutzerausleihhistorie löschen)' +WHERE module_bit = 13 AND code = 'delete_anonymize_patrons'; +UPDATE permissions SET + description = 'Benutzerfotos einzeln oder im Stapel hochladen' +WHERE module_bit = 13 AND code = 'batch_upload_patron_images'; +UPDATE permissions SET + description = 'Aufgabenplaner verwenden' +WHERE module_bit = 13 AND code = 'schedule_tasks'; +UPDATE permissions SET + description = 'Stapelbearbeitung von Exemplaren durchführen' +WHERE module_bit = 13 AND code = 'items_batchmod'; +UPDATE permissions SET + description = 'Stapellöschung von Exemplaren durchführen' +WHERE module_bit = 13 AND code = 'items_batchdel'; +UPDATE permissions SET + description = 'CSV-Profile für Export verwalten' +WHERE module_bit = 13 AND code = 'manage_csv_profiles'; +UPDATE permissions SET + description = 'Von Benutzern vergebene Tags moderieren' +WHERE module_bit = 13 AND code = 'moderate_tags'; +UPDATE permissions SET + description = 'Wandernde Sammlungen verwalten' +WHERE module_bit = 13 AND code = 'rotating_collections'; +UPDATE permissions SET + description = 'Eigene Coverbilder hochladen' +WHERE module_bit = 13 AND code = 'upload_local_cover_images'; +UPDATE permissions SET + description = 'Ablauf eines Abonnements prüfen' +WHERE module_bit = 15 AND code = 'check_expiration'; +UPDATE permissions SET + description = 'Fehlende Hefte reklamieren' +WHERE module_bit = 15 AND code = 'claim_serials'; +UPDATE permissions SET + description = 'Neues Abonnement anlegen' +WHERE module_bit = 15 AND code = 'create_subscription'; +UPDATE permissions SET + description = 'Bestehende Abonnements löschen' +WHERE module_bit = 15 AND code = 'delete_subscription'; +UPDATE permissions SET + description = 'Bestehende Abonnements bearbeiten' +WHERE module_bit = 15 AND code = 'edit_subscription'; +UPDATE permissions SET + description = 'Zugang von Heften' +WHERE module_bit = 15 AND code = 'receive_serials'; +UPDATE permissions SET + description = 'Abonnements verlängern' +WHERE module_bit = 15 AND code = 'renew_subscription'; +UPDATE permissions SET + description = 'Umlauflisten verwalten' +WHERE module_bit = 15 AND code = 'routing'; +UPDATE permissions SET + description = 'SQL-Reports ausführen' +WHERE module_bit = 16 AND code = 'execute_reports'; +UPDATE permissions SET + description = 'SQL-Reports erstellen' +WHERE module_bit = 16 AND code = 'create_reports'; +UPDATE permissions SET + description = 'Add, edit and delete courses' +WHERE module_bit = 18 AND code = 'manage_courses'; +UPDATE permissions SET + description = 'Add course reserves' +WHERE module_bit = 18 AND code = 'add_reserves'; +UPDATE permissions SET + description = 'Remove course reserves' +WHERE module_bit = 18 AND code = 'delete_reserves'; +UPDATE permissions SET + description = 'Plugins verwealten (installieren/deinstallieren)' +WHERE module_bit = 19 AND code = 'manage'; +UPDATE permissions SET + description = 'Werkzeug-Plugins verwenden' +WHERE module_bit = 19 AND code = 'tool'; +UPDATE permissions SET + description = 'Report-Plugins verwenden' +WHERE module_bit = 19 AND code = 'report'; +UPDATE permissions SET + description = 'Plugins konfigurieren' +WHERE module_bit = 19 AND code = 'configure'; -- 1.7.7.6