Bug 10969: Fix sample itemtypes for translated installers

[srvgit] / installer / data / mysql / de-DE / optional / sample_itemtypes.sql

diff --git a/installer/data/mysql/de-DE/optional/sample_itemtypes.sql b/installer/data/mysql/de-DE/optional/sample_itemtypes.sql
index b4c6174..968e851 100644 (file)
--- a/installer/data/mysql/de-DE/optional/sample_itemtypes.sql
+++ b/installer/data/mysql/de-DE/optional/sample_itemtypes.sql
@@ -1,8 +1,9 @@
-INSERT INTO `itemtypes` VALUES ('BK', 'Bücher',0,0,'bridge/book.gif','');
-INSERT INTO `itemtypes` VALUES ('MX', 'Medienkombinationen',0,0,'bridge/kit.gif','');
-INSERT INTO `itemtypes` VALUES ('CF', 'Datenträger',0,0,'bridge/computer_file.gif','');
-INSERT INTO `itemtypes` VALUES ('MP', 'Karten',0,0,'bridge/map.gif','');
-INSERT INTO `itemtypes` VALUES ('VM', 'AV-Medien',0,1,'bridge/dvd.gif','');
-INSERT INTO `itemtypes` VALUES ('MU', 'Musik',0,0,'bridge/sound.gif','');
-INSERT INTO `itemtypes` VALUES ('CR', 'Zeitschriften',0,0,'bridge/periodical.gif','');
-INSERT INTO `itemtypes` VALUES ('REF', 'Nachschlagewerke',0,1,'','');
+INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES
+('BK', 'Bücher',0,0,'bridge/book.gif',''),
+('MX', 'Medienkombinationen',0,0,'bridge/kit.gif',''),
+('CF', 'Datenträger',0,0,'bridge/computer_file.gif',''),
+('MP', 'Karten',0,0,'bridge/map.gif',''),
+('VM', 'AV-Medien',0,1,'bridge/dvd.gif',''),
+('MU', 'Musik',0,0,'bridge/sound.gif',''),
+('CR', 'Zeitschriften',0,0,'bridge/periodical.gif',''),
+('REF', 'Nachschlagewerke',0,1,'bridge/reference.gif','');