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

(-)a/installer/data/mysql/de-DE/mandatory/auth_values.sql (+2 lines)
Line 0 Link Here
1
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','Nein','Nein');
2
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Ja','Ja');
(-)a/installer/data/mysql/de-DE/mandatory/auth_values.txt (+1 lines)
Line 0 Link Here
1
Normierte Werte
(-)a/installer/data/mysql/de-DE/mandatory/sample_notices.sql (-51 / +49 lines)
Lines 19-112 VALUES ('circulation','ODUE','Mahnung','Mahnung','Liebe/r <<borrowers.firstname> Link Here
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
('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>>');
20
20
21
INSERT INTO `letter` (module, code, name, title, content, is_html)
21
INSERT INTO `letter` (module, code, name, title, content, is_html)
22
VALUES ('circulation','ISSUESLIP','Ausleihquittung (Quittungsdruck)','Ausleihquittung (Quittungsdruck)', '<h3><<branches.branchname>></h3>
22
VALUES ('circulation','ISSUESLIP','Ausleihquittung (Quittungsdruck)','Ausleihquittung (Quittungsdruck)', '<h2>Ausleihquittung</h2>
23
Ausleihe an: <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
23
Bibliothek: <<branches.branchname>> <br/>
24
(<<borrowers.cardnumber>>) <br />
24
Ausleihe an: <<borrowers.firstname>>  <<borrowers.surname>> <br />
25
25
Ausweisnummer: <<borrowers.cardnumber>> <br />
26
<br />
26
<<today>><br />
27
<<today>><br />
27
28
<br />
28
<h4>Ausleihen</h4>
29
<h4>Ausleihen</h4>
29
<checkedout>
30
<checkedout>
30
<p>
31
<p>
31
<<biblio.title>> <br />
32
<<biblio.title>> <br />
33
Signatur: <<items.itemcallnumber>><br/>
32
Barcode: <<items.barcode>><br />
34
Barcode: <<items.barcode>><br />
33
Fällig am: <<issues.date_due>><br />
35
Fällig am: <<issues.date_due>><br />
34
</p>
36
</p>
35
</checkedout>
37
</checkedout>
36
38
<br />
37
<h4>Überfällig</h4>
39
<h4>Überfällig</h4>
38
<overdue>
40
<overdue>
39
<p>
41
<p>
40
<<biblio.title>> <br />
42
<<biblio.title>> <br />
43
Signatur: <<items.itemcallnumber>><br/>
41
Barcode: <<items.barcode>><br />
44
Barcode: <<items.barcode>><br />
42
Fällig am: <<issues.date_due>><br />
45
Fällig am: <<issues.date_due>><br />
43
</p>
46
</p>
44
</overdue>
47
</overdue>
45
46
<hr>
47
48
<h4 style="text-align: center; font-style:italic;">Neuigkeiten</h4>
49
<news>
48
<news>
50
<div class="newsitem">
49
<div class="newsitem">
51
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
50
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
52
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.new>></p>
51
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.new>></p>
53
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Veröffentlicht am <<opac_news.timestamp>></p>
52
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px"><<opac_news.timestamp>></p>
54
<hr />
53
<hr />
55
</div>
54
</div>
56
</news>', 1),
55
</news>', 1),
57
('circulation','ISSUEQSLIP','Kurzquittung','Kurzquittung', '<h3><<branches.branchname>></h3>
56
('circulation','ISSUEQSLIP','Kurzquittung','Kurzquittung', '<h2>Ausleihquittung</h2>
58
Ausleihe an: <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
57
Bibliothek: <<branches.branchname>> <br/>
59
(<<borrowers.cardnumber>>) <br />
58
Ausleihe an: <<borrowers.firstname>>  <<borrowers.surname>> <br />
60
59
Ausweisnummer: <<borrowers.cardnumber>> <br />
60
<br />
61
<<today>><br />
61
<<today>><br />
62
62
<br />
63
<h4>Heutige Ausleihen</h4>
63
<h4>Heutige Ausleihen</h4>
64
<checkedout>
64
<checkedout>
65
<p>
65
<p>
66
<<biblio.title>> <br />
66
<<biblio.title>> <br />
67
Barcode: <<items.barcode>><br />
67
Barcode: <<items.barcode>><br />
68
Signatur: <<items.itemcallnumber>><br/>
68
Fällig am: <<issues.date_due>><br />
69
Fällig am: <<issues.date_due>><br />
69
</p>
70
</p>
70
</checkedout>', 1),
71
</checkedout>', 1),
71
('circulation','RESERVESLIP','Vormerkquittung','Vormerkquittung', '<h5>Datum: <<today>></h5>
72
('circulation','RESERVESLIP','Vormerkquittung','Vormerkquittung', '<h2>Ausleihquittung</h2>
72
73
Bibliothek: <<branches.branchname>> <br/>
73
<h3> Bereitstellung in <<branches.branchname>></h3>
74
Ausleihe an: <<borrowers.firstname>>  <<borrowers.surname>> <br />
74
75
Ausweisnummer: <<borrowers.cardnumber>> <br />
75
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
76
<br />
76
77
<<today>><br />
77
<ul>
78
    <li><<borrowers.cardnumber>></li>
79
    <li><<borrowers.phone>></li>
80
    <li> <<borrowers.address>><br />
81
         <<borrowers.address2>><br />
82
         <<borrowers.city >>  <<borrowers.zipcode>>
83
    </li>
84
    <li><<borrowers.email>></li>
85
</ul>
86
<br />
78
<br />
87
<h3>VORMERKUNG</h3>
79
<h4>Ausleihen</h4>
88
<h4><<biblio.title>></h4>
80
<checkedout>
89
<h5><<biblio.author>></h5>
81
<p>
90
<ul>
82
<<biblio.title>> <br />
91
   <li><<items.barcode>></li>
83
Signatur: <<items.itemcallnumber>><br/>
92
   <li><<items.itemcallnumber>></li>
84
Barcode: <<items.barcode>><br />
93
   <li><<reserves.waitingdate>></li>
85
Fällig am: <<issues.date_due>><br />
94
</ul>
95
<p>Notiz:
96
<pre><<reserves.reservenotes>></pre>
97
</p>
86
</p>
87
</checkedout>
88
<br />
89
<h4>Überfällig</h4>
90
<overdue>
91
<p>
92
<<biblio.title>> <br />
93
Signatur: <<items.itemcallnumber>><br/>
94
Barcode: <<items.barcode>><br />
95
Fällig am: <<issues.date_due>><br />
96
</p>
97
</overdue>
98
', 1),
98
', 1),
99
('circulation','TRANSFERSLIP','Transportquittung','Transportquittung', '<h5>Datum: <<today>></h5>
99
('circulation','TRANSFERSLIP','Transportquittung','Transportquittung', '<h2>TRANSPORT</h2>
100
100
<h3>Transport nach: <<branches.branchname>></h3>
101
<h3>Transport nach <<branches.branchname>></h3>
101
<h3>Datum: <<today>></h3>
102
102
<br/>
103
<br/>
103
<h3>EXEMPLAR</h3>
104
<h3>EXEMPLAR</h3>
104
<h4><<biblio.title>></h4>
105
<h4><<biblio.author>><<biblio.title>></h4>
105
<h5><<biblio.author>></h5>
106
Barcode: <<items.barcode>><br/>
106
<ul>
107
Signatur: <<items.itemcallnumber>><br/>', 1);
107
   <li><<items.barcode>></li>
108
   <li><<items.itemcallnumber>></li>
109
</ul>', 1);
110
108
111
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
109
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
112
VALUES (
110
VALUES (
(-)a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql (-1 / +39 lines)
Lines 25-30 VALUES( 'opac', 'i', 'en', 'OPAC'); Link Here
25
INSERT INTO language_descriptions(subtag, type, lang, description)
25
INSERT INTO language_descriptions(subtag, type, lang, description)
26
VALUES( 'opac', 'i', 'fr', 'OPAC');
26
VALUES( 'opac', 'i', 'fr', 'OPAC');
27
27
28
INSERT INTO language_descriptions(subtag, type, lang, description)
29
VALUES( 'opac', 'i', 'de', 'OPAC');
30
28
-- Staff Client
31
-- Staff Client
29
INSERT INTO language_subtag_registry( subtag, type, description, added)
32
INSERT INTO language_subtag_registry( subtag, type, description, added)
30
VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
33
VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
Lines 35-40 VALUES( 'intranet', 'i', 'en', 'Staff Client'); Link Here
35
INSERT INTO language_descriptions(subtag, type, lang, description)
38
INSERT INTO language_descriptions(subtag, type, lang, description)
36
VALUES( 'intranet', 'i', 'fr', '????');
39
VALUES( 'intranet', 'i', 'fr', '????');
37
40
41
INSERT INTO language_descriptions(subtag, type, lang, description)
42
VALUES( 'intranet', 'i', 'de', 'Dienstoberfläche');
43
38
-- Theme (t)
44
-- Theme (t)
39
INSERT INTO language_subtag_registry( subtag, type, description, added)
45
INSERT INTO language_subtag_registry( subtag, type, description, added)
40
VALUES ( 'prog', 't', 'Prog','2005-10-16');
46
VALUES ( 'prog', 't', 'Prog','2005-10-16');
Lines 45-50 VALUES( 'prog', 't', 'en', 'Prog'); Link Here
45
INSERT INTO language_descriptions(subtag, type, lang, description)
51
INSERT INTO language_descriptions(subtag, type, lang, description)
46
VALUES( 'prog', 't', 'fr', 'Prog');
52
VALUES( 'prog', 't', 'fr', 'Prog');
47
53
54
INSERT INTO language_descriptions(subtag, type, lang, description)
55
VALUES( 'prog', 't', 'de', 'Prog');
56
48
-- LANGUAGES
57
-- LANGUAGES
49
58
50
-- Arabic
59
-- Arabic
Lines 283-289 INSERT INTO language_descriptions(subtag, type, lang, description) Link Here
283
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
292
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
284
293
285
INSERT INTO language_descriptions(subtag, type, lang, description)
294
INSERT INTO language_descriptions(subtag, type, lang, description)
286
VALUES( 'el', 'language', 'de', 'Griechisch (Nach 1453)');
295
VALUES( 'el', 'language', 'de', 'Griechisch (Moern [1453- ]');
287
296
288
-- Hebrew
297
-- Hebrew
289
INSERT INTO language_subtag_registry( subtag, type, description, added)
298
INSERT INTO language_subtag_registry( subtag, type, description, added)
Lines 454-459 VALUES( 'gl', 'language', 'en', 'Galician'); Link Here
454
INSERT INTO language_descriptions(subtag, type, lang, description)
463
INSERT INTO language_descriptions(subtag, type, lang, description)
455
VALUES( 'gl', 'language', 'fr', 'Galicien');
464
VALUES( 'gl', 'language', 'fr', 'Galicien');
456
465
466
INSERT INTO language_descriptions(subtag, type, lang, description)
467
VALUES( 'gl', 'language', 'de', 'Galicisch');
468
469
457
-- Norwegian (bokmål)
470
-- Norwegian (bokmål)
458
INSERT INTO language_subtag_registry( subtag, type, description, added)
471
INSERT INTO language_subtag_registry( subtag, type, description, added)
459
VALUES ( 'nb', 'language', 'Norwegian bokm&#229;l','2005-10-16' );
472
VALUES ( 'nb', 'language', 'Norwegian bokm&#229;l','2005-10-16' );
Lines 781-786 VALUES( 'Arab', 'script','en', 'Arabic'); Link Here
781
INSERT INTO language_descriptions(subtag, type, lang, description)
794
INSERT INTO language_descriptions(subtag, type, lang, description)
782
VALUES( 'Arab', 'script','fr', 'Arabic');
795
VALUES( 'Arab', 'script','fr', 'Arabic');
783
796
797
INSERT INTO language_descriptions(subtag, type, lang, description)
798
VALUES( 'Arab', 'script', 'de', 'Arabisch');
799
784
-- Cyrillic
800
-- Cyrillic
785
INSERT INTO language_subtag_registry( subtag, type, description, added)
801
INSERT INTO language_subtag_registry( subtag, type, description, added)
786
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
802
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
Lines 794-799 VALUES( 'Cyrl', 'script', 'en', 'Cyrillic'); Link Here
794
INSERT INTO language_descriptions(subtag, type, lang, description)
810
INSERT INTO language_descriptions(subtag, type, lang, description)
795
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
811
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
796
812
813
INSERT INTO language_descriptions(subtag, type, lang, description)
814
VALUES( 'Cyrl', 'script', 'de', 'Kyrillisch');
815
816
797
-- Greek
817
-- Greek
798
INSERT INTO language_subtag_registry( subtag, type, description, added)
818
INSERT INTO language_subtag_registry( subtag, type, description, added)
799
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
819
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
Lines 807-812 VALUES( 'Grek', 'script', 'en', 'Greek'); Link Here
807
INSERT INTO language_descriptions(subtag, type, lang, description)
827
INSERT INTO language_descriptions(subtag, type, lang, description)
808
VALUES( 'Grek', 'script', 'fr', 'Greek');
828
VALUES( 'Grek', 'script', 'fr', 'Greek');
809
829
830
INSERT INTO language_descriptions(subtag, type, lang, description)
831
VALUES( 'Grek', 'script', 'de', 'Griechisch');
832
833
810
-- Han - Simplified
834
-- Han - Simplified
811
INSERT INTO language_subtag_registry( subtag, type, description, added)
835
INSERT INTO language_subtag_registry( subtag, type, description, added)
812
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
836
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
Lines 820-825 VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)'); Link Here
820
INSERT INTO language_descriptions(subtag, type, lang, description)
844
INSERT INTO language_descriptions(subtag, type, lang, description)
821
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
845
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
822
846
847
INSERT INTO language_descriptions(subtag, type, lang, description)
848
VALUES( 'Hans', 'script', 'de', 'Han (Vereinfachte Variante)');
849
850
823
-- Han - Traditional
851
-- Han - Traditional
824
INSERT INTO language_subtag_registry( subtag, type, description, added)
852
INSERT INTO language_subtag_registry( subtag, type, description, added)
825
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
853
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
Lines 830-835 VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)'); Link Here
830
INSERT INTO language_descriptions(subtag, type, lang, description)
858
INSERT INTO language_descriptions(subtag, type, lang, description)
831
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
859
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
832
860
861
INSERT INTO language_descriptions(subtag, type, lang, description)
862
VALUES( 'Hant', 'script', 'de', 'Han (Traditionelle Variante)');
863
833
-- Hebrew
864
-- Hebrew
834
INSERT INTO language_subtag_registry( subtag, type, description, added)
865
INSERT INTO language_subtag_registry( subtag, type, description, added)
835
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
866
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
Lines 840-845 VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew'); Link Here
840
INSERT INTO language_descriptions(subtag, type, lang, description)
871
INSERT INTO language_descriptions(subtag, type, lang, description)
841
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
872
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
842
873
874
INSERT INTO language_descriptions(subtag, type, lang, description)
875
VALUES( 'Hebr', 'script', 'de', 'Hebräisch');
876
843
-- Lao
877
-- Lao
844
INSERT INTO language_subtag_registry( subtag, type, description, added)
878
INSERT INTO language_subtag_registry( subtag, type, description, added)
845
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
879
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
Lines 850-855 VALUES ( 'Laoo', 'script', 'lo', 'Lao'); Link Here
850
INSERT INTO language_descriptions(subtag, type, lang, description)
884
INSERT INTO language_descriptions(subtag, type, lang, description)
851
VALUES( 'Laoo', 'script', 'en', 'Lao');
885
VALUES( 'Laoo', 'script', 'en', 'Lao');
852
886
887
INSERT INTO language_descriptions(subtag, type, lang, description)
888
VALUES( 'Laoo', 'script', 'en', 'Laotisch');
889
890
853
-- REGIONS
891
-- REGIONS
854
-- Canada
892
-- Canada
855
INSERT INTO language_subtag_registry( subtag, type, description, added)
893
INSERT INTO language_subtag_registry( subtag, type, description, added)
(-)a/installer/data/mysql/de-DE/mandatory/userflags.sql (-1 / +1 lines)
Lines 15-19 INSERT INTO `userflags` VALUES(14,'editauthorities','Normdaten ändern',0); Link Here
15
INSERT INTO `userflags` VALUES(15,'serials','Zugriff auf Abonnementverwaltung/Zeitschriftenmodul',0);
15
INSERT INTO `userflags` VALUES(15,'serials','Zugriff auf Abonnementverwaltung/Zeitschriftenmodul',0);
16
INSERT INTO `userflags` VALUES(16,'reports','Zugriff auf Reportmodul',0);
16
INSERT INTO `userflags` VALUES(16,'reports','Zugriff auf Reportmodul',0);
17
INSERT INTO `userflags` VALUES(17,'staffaccess','Berechtigungen/Logins für Bibliotheksmitarbeiter vergeben',0);
17
INSERT INTO `userflags` VALUES(17,'staffaccess','Berechtigungen/Logins für Bibliotheksmitarbeiter vergeben',0);
18
INSERT INTO `userflags` VALUES(18,'coursereserves','Course Reserves',0);
18
INSERT INTO `userflags` VALUES(18,'coursereserves','Semesteraparate',0);
19
INSERT INTO `userflags` VALUES(19,'plugins', 'Koha Plugins', '0');
19
INSERT INTO `userflags` VALUES(19,'plugins', 'Koha Plugins', '0');
(-)a/installer/data/mysql/de-DE/mandatory/userpermissions.sql (-8 / +8 lines)
Lines 18-24 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
18
   (11, 'budget_modify', 'Konten verändern (keine Neuen anlegen, aber Bestehende ändern)'),
18
   (11, 'budget_modify', 'Konten verändern (keine Neuen anlegen, aber Bestehende ändern)'),
19
   (11, 'planning_manage', 'Etatplanung verwalten'),
19
   (11, 'planning_manage', 'Etatplanung verwalten'),
20
   (11, 'order_manage', 'Bestellungen verwalten'),
20
   (11, 'order_manage', 'Bestellungen verwalten'),
21
   (11, 'order_manage_all', 'Manage all orders and baskets, regardless of restrictions on them'),
21
   (11, 'order_manage_all', 'Bestellungen aller Bibliotheken, unabhängig von Berechtigungen, verwalten'),
22
   (11, 'group_manage', 'Bestellgruppen vewalten'),
22
   (11, 'group_manage', 'Bestellgruppen vewalten'),
23
   (11, 'order_receive', 'Lieferungen verwalten'),
23
   (11, 'order_receive', 'Lieferungen verwalten'),
24
   (11, 'budget_add_del', 'Konten hinzufügen/ändern, aber bestehende nicht ändern'),
24
   (11, 'budget_add_del', 'Konten hinzufügen/ändern, aber bestehende nicht ändern'),
Lines 46-53 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
46
   (13, 'moderate_tags', 'Von Benutzern vergebene Tags moderieren'),
46
   (13, 'moderate_tags', 'Von Benutzern vergebene Tags moderieren'),
47
   (13, 'rotating_collections', 'Wandernde Sammlungen verwalten'),
47
   (13, 'rotating_collections', 'Wandernde Sammlungen verwalten'),
48
   (13, 'upload_local_cover_images', 'Eigene Coverbilder hochladen'),
48
   (13, 'upload_local_cover_images', 'Eigene Coverbilder hochladen'),
49
   (13, 'manage_patron_lists', 'Add, edit and delete patron lists and their contents'),
49
   (13, 'manage_patron_lists', 'Benutzerlisten anlegen, bearbeiten und löschen'),
50
   (13, 'marc_modification_templates', 'Manage marc modification templates'),
50
   (13, 'marc_modification_templates', 'Templates für MARC-Modifikationen verwalten'),
51
   (15, 'check_expiration', 'Ablauf eines Abonnements prüfen'),
51
   (15, 'check_expiration', 'Ablauf eines Abonnements prüfen'),
52
   (15, 'claim_serials', 'Fehlende Hefte reklamieren'),
52
   (15, 'claim_serials', 'Fehlende Hefte reklamieren'),
53
   (15, 'create_subscription', 'Neues Abonnement anlegen'),
53
   (15, 'create_subscription', 'Neues Abonnement anlegen'),
Lines 56-68 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
56
   (15, 'receive_serials', 'Zugang von Heften'),
56
   (15, 'receive_serials', 'Zugang von Heften'),
57
   (15, 'renew_subscription', 'Abonnements verlängern'),
57
   (15, 'renew_subscription', 'Abonnements verlängern'),
58
   (15, 'routing', 'Umlauflisten verwalten'),
58
   (15, 'routing', 'Umlauflisten verwalten'),
59
   (15, 'superserials', 'Manage subscriptions from any branch (only applies when IndependantBranches is used)'),
59
   (15, 'superserials', 'Abonnements aller Bibliotheken verwalten (nur relevant wenn IndependentBranches verwendet wird)'),
60
   (16, 'execute_reports', 'SQL-Reports ausführen'),
60
   (16, 'execute_reports', 'SQL-Reports ausführen'),
61
   (16, 'create_reports', 'SQL-Reports erstellen'),
61
   (16, 'create_reports', 'SQL-Reports erstellen'),
62
   (18, 'manage_courses', 'Add, edit and delete courses'),
62
   (18, 'manage_courses', 'Semesterapparate anlegen, bearbenten und löschen'),
63
   (18, 'add_reserves', 'Add course reserves'),
63
   (18, 'add_reserves', 'Semesterapparate anlegen'),
64
   (18, 'delete_reserves', 'Remove course reserves'),
64
   (18, 'delete_reserves', 'Semesterapparate löschen'),
65
   (19, 'manage', 'Plugins verwealten (installieren/deinstallieren)'),
65
   (19, 'manage', 'Plugins verwalten (installieren/deinstallieren)'),
66
   (19, 'tool', 'Werkzeug-Plugins verwenden'),
66
   (19, 'tool', 'Werkzeug-Plugins verwenden'),
67
   (19, 'report', 'Report-Plugins verwenden'),
67
   (19, 'report', 'Report-Plugins verwenden'),
68
   (19, 'configure', 'Plugins konfigurieren')
68
   (19, 'configure', 'Plugins konfigurieren')
(-)a/installer/data/mysql/de-DE/optional/csv_profiles.sql (+2 lines)
Line 0 Link Here
1
INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type )
2
VALUES ( "Zeitschriftenreklamationen", "Standardprofil für den Export von Heftinformationen für Zeitschriftenreklamationen", "LIEFERANT=aqbooksellers.name|TITEL=subscription.title|HEFTNUMMER=serial.serialseq|SEIT=serial.planneddate", ",", "sql" );
(-)a/installer/data/mysql/de-DE/optional/csv_profiles.txt (+3 lines)
Line 0 Link Here
1
CSV-Profile
2
3
CSV-Profiles, einschließlich einem für den Export von Zeitschriftenreklamationen.
(-)a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql (+2 lines)
Lines 1-5 Link Here
1
INSERT INTO `z3950servers`
1
INSERT INTO `z3950servers`
2
(`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `encoding`) VALUES 
2
(`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `encoding`) VALUES 
3
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,1,'USMARC','utf8'),
3
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,1,'USMARC','utf8'),
4
('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
5
('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'),
4
('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',6,0,0,'USMARC','MARC-8'),
6
('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',6,0,0,'USMARC','MARC-8'),
5
('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',10,0,0,'USMARC','MARC-8'); 
7
('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',10,0,0,'USMARC','MARC-8'); 
(-)a/installer/data/mysql/en/mandatory/subtag_registry.sql (-1 / +39 lines)
Lines 25-30 VALUES( 'opac', 'i', 'en', 'OPAC'); Link Here
25
INSERT INTO language_descriptions(subtag, type, lang, description)
25
INSERT INTO language_descriptions(subtag, type, lang, description)
26
VALUES( 'opac', 'i', 'fr', 'OPAC');
26
VALUES( 'opac', 'i', 'fr', 'OPAC');
27
27
28
INSERT INTO language_descriptions(subtag, type, lang, description)
29
VALUES( 'opac', 'i', 'de', 'OPAC');
30
28
-- Staff Client
31
-- Staff Client
29
INSERT INTO language_subtag_registry( subtag, type, description, added)
32
INSERT INTO language_subtag_registry( subtag, type, description, added)
30
VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
33
VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
Lines 35-40 VALUES( 'intranet', 'i', 'en', 'Staff Client'); Link Here
35
INSERT INTO language_descriptions(subtag, type, lang, description)
38
INSERT INTO language_descriptions(subtag, type, lang, description)
36
VALUES( 'intranet', 'i', 'fr', '????');
39
VALUES( 'intranet', 'i', 'fr', '????');
37
40
41
INSERT INTO language_descriptions(subtag, type, lang, description)
42
VALUES( 'intranet', 'i', 'de', 'Dienstoberfläche');
43
38
-- Theme (t)
44
-- Theme (t)
39
INSERT INTO language_subtag_registry( subtag, type, description, added)
45
INSERT INTO language_subtag_registry( subtag, type, description, added)
40
VALUES ( 'prog', 't', 'Prog','2005-10-16');
46
VALUES ( 'prog', 't', 'Prog','2005-10-16');
Lines 45-50 VALUES( 'prog', 't', 'en', 'Prog'); Link Here
45
INSERT INTO language_descriptions(subtag, type, lang, description)
51
INSERT INTO language_descriptions(subtag, type, lang, description)
46
VALUES( 'prog', 't', 'fr', 'Prog');
52
VALUES( 'prog', 't', 'fr', 'Prog');
47
53
54
INSERT INTO language_descriptions(subtag, type, lang, description)
55
VALUES( 'prog', 't', 'de', 'Prog');
56
48
-- LANGUAGES
57
-- LANGUAGES
49
58
50
-- Arabic
59
-- Arabic
Lines 283-289 INSERT INTO language_descriptions(subtag, type, lang, description) Link Here
283
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
292
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
284
293
285
INSERT INTO language_descriptions(subtag, type, lang, description)
294
INSERT INTO language_descriptions(subtag, type, lang, description)
286
VALUES( 'el', 'language', 'de', 'Griechisch (Nach 1453)');
295
VALUES( 'el', 'language', 'de', 'Griechisch (Moern [1453- ]');
287
296
288
-- Hebrew
297
-- Hebrew
289
INSERT INTO language_subtag_registry( subtag, type, description, added)
298
INSERT INTO language_subtag_registry( subtag, type, description, added)
Lines 454-459 VALUES( 'gl', 'language', 'en', 'Galician'); Link Here
454
INSERT INTO language_descriptions(subtag, type, lang, description)
463
INSERT INTO language_descriptions(subtag, type, lang, description)
455
VALUES( 'gl', 'language', 'fr', 'Galicien');
464
VALUES( 'gl', 'language', 'fr', 'Galicien');
456
465
466
INSERT INTO language_descriptions(subtag, type, lang, description)
467
VALUES( 'gl', 'language', 'de', 'Galicisch');
468
469
457
-- Norwegian (bokmål)
470
-- Norwegian (bokmål)
458
INSERT INTO language_subtag_registry( subtag, type, description, added)
471
INSERT INTO language_subtag_registry( subtag, type, description, added)
459
VALUES ( 'nb', 'language', 'Norwegian bokm&#229;l','2005-10-16' );
472
VALUES ( 'nb', 'language', 'Norwegian bokm&#229;l','2005-10-16' );
Lines 781-786 VALUES( 'Arab', 'script','en', 'Arabic'); Link Here
781
INSERT INTO language_descriptions(subtag, type, lang, description)
794
INSERT INTO language_descriptions(subtag, type, lang, description)
782
VALUES( 'Arab', 'script','fr', 'Arabic');
795
VALUES( 'Arab', 'script','fr', 'Arabic');
783
796
797
INSERT INTO language_descriptions(subtag, type, lang, description)
798
VALUES( 'Arab', 'script', 'de', 'Arabisch');
799
784
-- Cyrillic
800
-- Cyrillic
785
INSERT INTO language_subtag_registry( subtag, type, description, added)
801
INSERT INTO language_subtag_registry( subtag, type, description, added)
786
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
802
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
Lines 794-799 VALUES( 'Cyrl', 'script', 'en', 'Cyrillic'); Link Here
794
INSERT INTO language_descriptions(subtag, type, lang, description)
810
INSERT INTO language_descriptions(subtag, type, lang, description)
795
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
811
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
796
812
813
INSERT INTO language_descriptions(subtag, type, lang, description)
814
VALUES( 'Cyrl', 'script', 'de', 'Kyrillisch');
815
816
797
-- Greek
817
-- Greek
798
INSERT INTO language_subtag_registry( subtag, type, description, added)
818
INSERT INTO language_subtag_registry( subtag, type, description, added)
799
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
819
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
Lines 807-812 VALUES( 'Grek', 'script', 'en', 'Greek'); Link Here
807
INSERT INTO language_descriptions(subtag, type, lang, description)
827
INSERT INTO language_descriptions(subtag, type, lang, description)
808
VALUES( 'Grek', 'script', 'fr', 'Greek');
828
VALUES( 'Grek', 'script', 'fr', 'Greek');
809
829
830
INSERT INTO language_descriptions(subtag, type, lang, description)
831
VALUES( 'Grek', 'script', 'de', 'Griechisch');
832
833
810
-- Han - Simplified
834
-- Han - Simplified
811
INSERT INTO language_subtag_registry( subtag, type, description, added)
835
INSERT INTO language_subtag_registry( subtag, type, description, added)
812
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
836
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
Lines 820-825 VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)'); Link Here
820
INSERT INTO language_descriptions(subtag, type, lang, description)
844
INSERT INTO language_descriptions(subtag, type, lang, description)
821
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
845
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
822
846
847
INSERT INTO language_descriptions(subtag, type, lang, description)
848
VALUES( 'Hans', 'script', 'de', 'Han (Vereinfachte Variante)');
849
850
823
-- Han - Traditional
851
-- Han - Traditional
824
INSERT INTO language_subtag_registry( subtag, type, description, added)
852
INSERT INTO language_subtag_registry( subtag, type, description, added)
825
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
853
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
Lines 830-835 VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)'); Link Here
830
INSERT INTO language_descriptions(subtag, type, lang, description)
858
INSERT INTO language_descriptions(subtag, type, lang, description)
831
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
859
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
832
860
861
INSERT INTO language_descriptions(subtag, type, lang, description)
862
VALUES( 'Hant', 'script', 'de', 'Han (Traditionelle Variante)');
863
833
-- Hebrew
864
-- Hebrew
834
INSERT INTO language_subtag_registry( subtag, type, description, added)
865
INSERT INTO language_subtag_registry( subtag, type, description, added)
835
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
866
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
Lines 840-845 VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew'); Link Here
840
INSERT INTO language_descriptions(subtag, type, lang, description)
871
INSERT INTO language_descriptions(subtag, type, lang, description)
841
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
872
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
842
873
874
INSERT INTO language_descriptions(subtag, type, lang, description)
875
VALUES( 'Hebr', 'script', 'de', 'Hebräisch');
876
843
-- Lao
877
-- Lao
844
INSERT INTO language_subtag_registry( subtag, type, description, added)
878
INSERT INTO language_subtag_registry( subtag, type, description, added)
845
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
879
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
Lines 850-855 VALUES ( 'Laoo', 'script', 'lo', 'Lao'); Link Here
850
INSERT INTO language_descriptions(subtag, type, lang, description)
884
INSERT INTO language_descriptions(subtag, type, lang, description)
851
VALUES( 'Laoo', 'script', 'en', 'Lao');
885
VALUES( 'Laoo', 'script', 'en', 'Lao');
852
886
887
INSERT INTO language_descriptions(subtag, type, lang, description)
888
VALUES( 'Laoo', 'script', 'en', 'Laotisch');
889
890
853
-- REGIONS
891
-- REGIONS
854
-- Canada
892
-- Canada
855
INSERT INTO language_subtag_registry( subtag, type, description, added)
893
INSERT INTO language_subtag_registry( subtag, type, description, added)
(-)a/installer/data/mysql/en/mandatory/userpermissions.sql (-1 / +1 lines)
Lines 56-62 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
56
   (15, 'receive_serials', 'Serials receiving'),
56
   (15, 'receive_serials', 'Serials receiving'),
57
   (15, 'renew_subscription', 'Renew a subscription'),
57
   (15, 'renew_subscription', 'Renew a subscription'),
58
   (15, 'routing', 'Routing'),
58
   (15, 'routing', 'Routing'),
59
   (15, 'superserials', 'Manage subscriptions from any branch (only applies when IndependantBranches is used)'),
59
   (15, 'superserials', 'Manage subscriptions from any branch (only applies when IndependentBranches is used)'),
60
   (16, 'execute_reports', 'Execute SQL reports'),
60
   (16, 'execute_reports', 'Execute SQL reports'),
61
   (16, 'create_reports', 'Create SQL Reports'),
61
   (16, 'create_reports', 'Create SQL Reports'),
62
   (18, 'manage_courses', 'Add, edit and delete courses'),
62
   (18, 'manage_courses', 'Add, edit and delete courses'),
(-)a/installer/data/mysql/en/optional/sample_z3950_servers.sql (-6 / +5 lines)
Lines 1-7 Link Here
1
INSERT INTO z3950servers
1
INSERT INTO `z3950servers`
2
(host, port, db, userid, password, name, checked, rank, syntax, encoding,recordtype) VALUES 
2
(`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `encoding`) VALUES
3
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
3
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,1,'USMARC','utf8'),
4
('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
4
('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
5
('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'),
5
('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'),
6
('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'),
6
('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',6,0,0,'USMARC','MARC-8'),
7
('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',0,0,'USMARC','MARC-8','biblio'); 
7
('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',10,0,0,'USMARC','MARC-8');
8
- 

Return to bug 11260