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

(-)a/installer/data/mysql/de-DE/optional/sample_creator_data.sql (-20 / +3 lines)
Lines 1-9 Link Here
1
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1
INSERT INTO `creator_layouts` (layout_id, barcode_type, start_label, printing_type, layout_name, guidebox, font, font_size, units, callnum_split, text_justify, format_string, layout_xml, creator) VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(18,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(19,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(20,'CODE39',1,'BAR','Test Layout',0,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT">
2
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3
4
LOCK TABLES `creator_layouts` WRITE;
5
/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
6
INSERT INTO `creator_layouts` VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(18,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(19,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(20,'CODE39',1,'BAR','Test Layout',0,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT">
7
  <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
2
  <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
8
    <data_source image_name="none" image_source="patronimages" />
3
    <data_source image_name="none" image_source="patronimages" />
9
  </images>
4
  </images>
Lines 15-34 INSERT INTO `creator_layouts` VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,'TR' Link Here
15
  <text font="TR" font_size="6" llx="115" lly="65" text_alignment="L" />
10
  <text font="TR" font_size="6" llx="115" lly="65" text_alignment="L" />
16
</opt>
11
</opt>
17
','Patroncards');
12
','Patroncards');
18
/*!40000 ALTER TABLE `creator_layouts` ENABLE KEYS */;
19
UNLOCK TABLES;
20
13
21
14
22
LOCK TABLES `creator_templates` WRITE;
15
INSERT INTO `creator_templates` (template_id, profile_id, template_code, template_desc, page_width, page_height, label_width, label_height, top_text_margin, left_text_margin, top_margin, left_margin, cols, rows, col_gap, row_gap, units, creator) VALUES (1,1,'Avery 5160 | 1 x 2-5/8','3 columns, 10 rows of labels',8.5,11,2.63,1,0.139,0,0.35,0.23,3,10,0.13,0,'INCH','Labels'),(7,13,'Demco WS14942260','1\" X 1.5\" Spine Label | Setup for up to four lines of text',8.5,11,1.5,1,0.236,0,0.5,0.25,5,10,0.0625,0,'INCH','Labels'),(12,14,'Demco WS14942260','1\" X 1.5\" Spine Label | Setup for five lines of text',8.5,11,1.5,1,0.139,0,0.53,0.3,5,10,0.0625,0,'INCH','Labels'),(22,0,'DEFAULT TEMPLATE 01','Default description',0,5,0,0,0,0,0,0,0,0,0,0,'POINT','Labels'),(23,16,'HB-PC0001','A template for home brewed patron card forms',8.5,11,3.1875,1.9375,0,0,0.6875,0.875,2,4,0.4375,0.1875,'INCH','Patroncards');
23
/*!40000 ALTER TABLE `creator_templates` DISABLE KEYS */;
24
INSERT INTO `creator_templates` VALUES (1,1,'Avery 5160 | 1 x 2-5/8','3 columns, 10 rows of labels',8.5,11,2.63,1,0.139,0,0.35,0.23,3,10,0.13,0,'INCH','Labels'),(7,13,'Demco WS14942260','1\" X 1.5\" Spine Label | Setup for up to four lines of text',8.5,11,1.5,1,0.236,0,0.5,0.25,5,10,0.0625,0,'INCH','Labels'),(12,14,'Demco WS14942260','1\" X 1.5\" Spine Label | Setup for five lines of text',8.5,11,1.5,1,0.139,0,0.53,0.3,5,10,0.0625,0,'INCH','Labels'),(22,0,'DEFAULT TEMPLATE 01','Default description',0,5,0,0,0,0,0,0,0,0,0,0,'POINT','Labels'),(23,16,'HB-PC0001','A template for home brewed patron card forms',8.5,11,3.1875,1.9375,0,0,0.6875,0.875,2,4,0.4375,0.1875,'INCH','Patroncards');
25
/*!40000 ALTER TABLE `creator_templates` ENABLE KEYS */;
26
UNLOCK TABLES;
27
16
28
LOCK TABLES `printers_profile` WRITE;
17
INSERT INTO printers_profile (profile_id, printer_name, template_id, paper_bin, offset_horz, offset_vert, creep_horz, creep_vert, units, creator) VALUES (1,'Library Laser',1,'Bypass',-2,9,3,0,'POINT','Labels'),(11,'Library Laser',1,'Tray 1',0,0,0,0,'POINT','Labels'),(16,'Test Printer 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards');
29
/*!40000 ALTER TABLE `printers_profile` DISABLE KEYS */;
30
INSERT INTO `printers_profile` VALUES (1,'Library Laser',1,'Bypass',-2,9,3,0,'POINT','Labels'),(11,'Library Laser',1,'Tray 1',0,0,0,0,'POINT','Labels'),(16,'Test Printer 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards');
31
/*!40000 ALTER TABLE `printers_profile` ENABLE KEYS */;
32
UNLOCK TABLES;
33
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
34
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
(-)a/installer/data/mysql/de-DE/optional/sample_holidays.sql (-1 / +1 lines)
Lines 1-4 Link Here
1
INSERT INTO `repeatable_holidays` VALUES
1
INSERT INTO repeatable_holidays (id,branchcode,weekday,day,month,title,description) VALUES
2
(2,'MPL',0,NULL,NULL,'','Sonntag'),
2
(2,'MPL',0,NULL,NULL,'','Sonntag'),
3
(3,'MPL',NULL,1,1,'','Neujahr'),
3
(3,'MPL',NULL,1,1,'','Neujahr'),
4
(4,'MPL',NULL,25,12,'','1. Weihnachtsfeiertag'),
4
(4,'MPL',NULL,25,12,'','1. Weihnachtsfeiertag'),
(-)a/installer/data/mysql/de-DE/optional/sample_itemtypes.sql (-8 / +9 lines)
Lines 1-8 Link Here
1
INSERT INTO `itemtypes` VALUES ('BK', 'Bücher',0,0,'bridge/book.gif','');
1
INSERT INTO `itemtypes` (itemtype,description,rentalcharge,notforloan,imageurl,summary) VALUES
2
INSERT INTO `itemtypes` VALUES ('MX', 'Medienkombinationen',0,0,'bridge/kit.gif','');
2
('BK', 'Bücher',0,0,'bridge/book.gif',''),
3
INSERT INTO `itemtypes` VALUES ('CF', 'Datenträger',0,0,'bridge/computer_file.gif','');
3
('MX', 'Medienkombinationen',0,0,'bridge/kit.gif',''),
4
INSERT INTO `itemtypes` VALUES ('MP', 'Karten',0,0,'bridge/map.gif','');
4
('CF', 'Datenträger',0,0,'bridge/computer_file.gif',''),
5
INSERT INTO `itemtypes` VALUES ('VM', 'AV-Medien',0,1,'bridge/dvd.gif','');
5
('MP', 'Karten',0,0,'bridge/map.gif',''),
6
INSERT INTO `itemtypes` VALUES ('MU', 'Musik',0,0,'bridge/sound.gif','');
6
('VM', 'AV-Medien',0,1,'bridge/dvd.gif',''),
7
INSERT INTO `itemtypes` VALUES ('CR', 'Zeitschriften',0,0,'bridge/periodical.gif','');
7
('MU', 'Musik',0,0,'bridge/sound.gif',''),
8
INSERT INTO `itemtypes` VALUES ('REF', 'Nachschlagewerke',0,1,'bridge/reference.gif','');
8
('CR', 'Zeitschriften',0,0,'bridge/periodical.gif',''),
9
('REF', 'Nachschlagewerke',0,1,'bridge/reference.gif','');
(-)a/installer/data/mysql/de-DE/optional/sample_news.sql (-2 / +2 lines)
Lines 1-2 Link Here
1
INSERT INTO `opac_news` VALUES (1,'Willkommen bei Koha','Willkommen bei Koha. Koha ist ein vollständiges integriertes Bibliothekssystem. Es wurde ursprünglich in Neuseeland von Katipo Communications Ltd entwickelt und ging im Januar 2000 für den Horowhenua Library Trust zum ersten mal in Produktion. Koha wird heute von einem internationalen Team aus Support-Dienstleistern und Anwendern weiterentwickelt.','koha','2007-10-29 05:25:58','2099-01-10',1),
1
INSERT INTO `opac_news` (idnew,title,new,lang,timestamp,expirationdate,number) VALUES
2
(1,'Willkommen bei Koha','Willkommen bei Koha. Koha ist ein vollständiges integriertes Bibliothekssystem. Es wurde ursprünglich in Neuseeland von Katipo Communications Ltd entwickelt und ging im Januar 2000 für den Horowhenua Library Trust zum ersten mal in Produktion. Koha wird heute von einem internationalen Team aus Support-Dienstleistern und Anwendern weiterentwickelt.','koha','2007-10-29 05:25:58','2099-01-10',1),
2
(2,'Was kommt jetzt?','Wie geht es weiter, nachdem Sie Koha installiert haben? Hier einige Vorschläge:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Lesen Sie die Koha-Dokumentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Lesen oder Schreiben Sie im Koha-Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Verfolgen oder beteiligen Sie sich an Diskussionen</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Melden Sie Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Erstellen Sie Fehlerkorrekturen mit GIT (Versionskontrollsystem)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chatten Sie mit Koha-Anwendern und -Entwicklern</a></li>\r\n</ul>\r\n','koha','2007-10-29 05:34:45','2099-01-10',2);
3
(2,'Was kommt jetzt?','Wie geht es weiter, nachdem Sie Koha installiert haben? Hier einige Vorschläge:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Lesen Sie die Koha-Dokumentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Lesen oder Schreiben Sie im Koha-Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Verfolgen oder beteiligen Sie sich an Diskussionen</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Melden Sie Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Erstellen Sie Fehlerkorrekturen mit GIT (Versionskontrollsystem)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chatten Sie mit Koha-Anwendern und -Entwicklern</a></li>\r\n</ul>\r\n','koha','2007-10-29 05:34:45','2099-01-10',2);
3
- 

Return to bug 10521