Attachment 21600 Details for Bug 10969 – Bug 10969: Fix sample itemtypes for translated installers

[patch] Bug 10969: Fix sample itemtypes for translated installers

Bug-10969-Fix-sample-itemtypes-for-translated-inst.patch (text/plain), 8.35 KB, created by Katrin Fischer on 2013-09-29 16:50:14 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2013-09-29 16:50:14 UTC

Size: 8.35 KB

patch

obsolete

>From 2e547ef79f526b2dbb09404d68e1f43d51b17a00 Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <Katrin.Fischer.83@web.de>
>Date: Sun, 29 Sep 2013 18:45:06 +0200
>Subject: [PATCH] Bug 10969: Fix sample itemtypes for translated installers
>
>To test:
>- Install the specific language and run the web installer.
>Or:
>- Truncate or delete all from the itemtypes table in your database.
>- Try to run the complete SQL in the itemtypes sample files.
>
>Verify the table is filled correctly.
>---
> .../data/mysql/de-DE/optional/sample_itemtypes.sql |   17 ++++++-------
> .../data/mysql/es-ES/optional/sample_itemtypes.sql |   17 ++++++-------
> .../mysql/nb-NO/2-Valgfritt/sample_itemtypes.sql   |   17 ++++++-------
> .../data/mysql/pl-PL/optional/sample_itemtypes.sql |   17 ++++++-------
> .../mysql/ru-RU/optional/library_item_types.sql    |   25 +++++++-------------
> 5 files changed, 45 insertions(+), 48 deletions(-)
>
>diff --git a/installer/data/mysql/de-DE/optional/sample_itemtypes.sql b/installer/data/mysql/de-DE/optional/sample_itemtypes.sql
>index fb4e046..968e851 100644
>--- 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,'bridge/reference.gif','');
>+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','');
>diff --git a/installer/data/mysql/es-ES/optional/sample_itemtypes.sql b/installer/data/mysql/es-ES/optional/sample_itemtypes.sql
>index 76510b4..9180dec 100644
>--- a/installer/data/mysql/es-ES/optional/sample_itemtypes.sql
>+++ b/installer/data/mysql/es-ES/optional/sample_itemtypes.sql
>@@ -1,8 +1,9 @@
>-INSERT INTO `itemtypes` VALUES ('BK', 'Books',5,0,'bridge/book.gif','');
>-INSERT INTO `itemtypes` VALUES ('MX', 'Mixed Materials',5,0,'bridge/kit.gif','');
>-INSERT INTO `itemtypes` VALUES ('CF', 'Computer Files',5,0,'bridge/computer_file.gif','');
>-INSERT INTO `itemtypes` VALUES ('MP', 'Maps',5,0,'bridge/map.gif','');
>-INSERT INTO `itemtypes` VALUES ('VM', 'Visual Materials',5,1,'bridge/dvd.gif','');
>-INSERT INTO `itemtypes` VALUES ('MU', 'Music',5,0,'bridge/sound.gif','');
>-INSERT INTO `itemtypes` VALUES ('CR', 'Continuing Resources',5,0,'bridge/periodical.gif','');
>-INSERT INTO `itemtypes` VALUES ('REF', 'Reference',0,1,'','');
>+INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES
>+('BK', 'Books',5,0,'bridge/book.gif',''),
>+('MX', 'Mixed Materials',5,0,'bridge/kit.gif',''),
>+('CF', 'Computer Files',5,0,'bridge/computer_file.gif',''),
>+('MP', 'Maps',5,0,'bridge/map.gif',''),
>+('VM', 'Visual Materials',5,1,'bridge/dvd.gif',''),
>+('MU', 'Music',5,0,'bridge/sound.gif',''),
>+('CR', 'Continuing Resources',5,0,'bridge/periodical.gif',''),
>+('REF', 'Reference',0,1,'','');
>diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.sql
>index 120d4d6..95e4e79 100644
>--- a/installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.sql
>+++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.sql
>@@ -19,11 +19,12 @@
> -- with Koha; if not, write to the Free Software Foundation, Inc.,
> -- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
> 
>-INSERT INTO `itemtypes` VALUES ('BK', 'BÃ¸ker',0,0,'bridge/book.gif','');
>-INSERT INTO `itemtypes` VALUES ('MX', 'Blandet innhold',0,0,'bridge/kit.gif','');
>-INSERT INTO `itemtypes` VALUES ('CF', 'Datafiler',0,0,'bridge/computer_file.gif','');
>-INSERT INTO `itemtypes` VALUES ('MP', 'Kart',0,0,'bridge/map.gif','');
>-INSERT INTO `itemtypes` VALUES ('VM', 'Visuelt materiale',0,1,'bridge/dvd.gif','');
>-INSERT INTO `itemtypes` VALUES ('MU', 'Musikk',5,0,'bridge/sound.gif','');
>-INSERT INTO `itemtypes` VALUES ('CR', 'Periodika',0,0,'bridge/periodical.gif','');
>-INSERT INTO `itemtypes` VALUES ('REF', 'Oppslagsverk',0,1,'','');
>+INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES
>+('BK', 'BÃ¸ker',0,0,'bridge/book.gif',''),
>+('MX', 'Blandet innhold',0,0,'bridge/kit.gif',''),
>+('CF', 'Datafiler',0,0,'bridge/computer_file.gif',''),
>+('MP', 'Kart',0,0,'bridge/map.gif',''),
>+('VM', 'Visuelt materiale',0,1,'bridge/dvd.gif',''),
>+('MU', 'Musikk',5,0,'bridge/sound.gif',''),
>+('CR', 'Periodika',0,0,'bridge/periodical.gif',''),
>+('REF', 'Oppslagsverk',0,1,'','');
>diff --git a/installer/data/mysql/pl-PL/optional/sample_itemtypes.sql b/installer/data/mysql/pl-PL/optional/sample_itemtypes.sql
>index 41074ae..6c5e57c 100644
>--- a/installer/data/mysql/pl-PL/optional/sample_itemtypes.sql
>+++ b/installer/data/mysql/pl-PL/optional/sample_itemtypes.sql
>@@ -1,8 +1,9 @@
>-INSERT INTO `itemtypes` VALUES ('BK', 'KsiÄÅ¼ki',5,0,'bridge/book.gif','');
>-INSERT INTO `itemtypes` VALUES ('MX', 'MateriaÅy mieszane',5,0,'bridge/kit.gif','');
>-INSERT INTO `itemtypes` VALUES ('CF', 'Pliki komputerowe',5,0,'bridge/computer_file.gif','');
>-INSERT INTO `itemtypes` VALUES ('MP', 'Mapy',5,0,'bridge/map.gif','');
>-INSERT INTO `itemtypes` VALUES ('VM', 'MateriaÅy wziualne',5,1,'bridge/dvd.gif','');
>-INSERT INTO `itemtypes` VALUES ('MU', 'Muzyka',5,0,'bridge/sound.gif','');
>-INSERT INTO `itemtypes` VALUES ('CR', 'Wydawnictwa ciÄgÅe',5,0,'bridge/periodical.gif','');
>-INSERT INTO `itemtypes` VALUES ('REF', 'Reference',0,1,'','');
>+INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES
>+('BK', 'KsiÄÅ¼ki',5,0,'bridge/book.gif',''),
>+('MX', 'MateriaÅy mieszane',5,0,'bridge/kit.gif',''),
>+('CF', 'Pliki komputerowe',5,0,'bridge/computer_file.gif',''),
>+('MP', 'Mapy',5,0,'bridge/map.gif',''),
>+('VM', 'MateriaÅy wziualne',5,1,'bridge/dvd.gif',''),
>+('MU', 'Muzyka',5,0,'bridge/sound.gif',''),
>+('CR', 'Wydawnictwa ciÄgÅe',5,0,'bridge/periodical.gif',''),
>+('REF', 'Reference',0,1,'','');
>diff --git a/installer/data/mysql/ru-RU/optional/library_item_types.sql b/installer/data/mysql/ru-RU/optional/library_item_types.sql
>index c21adc9..2374caa 100644
>--- a/installer/data/mysql/ru-RU/optional/library_item_types.sql
>+++ b/installer/data/mysql/ru-RU/optional/library_item_types.sql
>@@ -1,17 +1,10 @@
> TRUNCATE itemtypes;
>-
>-INSERT INTO `itemtypes` VALUES ('BK', ' ÐÐ½Ð¸Ð³Ð¸',5,0,'bridge/book.gif','');
>-
>-INSERT INTO `itemtypes` VALUES ('MX', 'Ð¡Ð¼ÐµÑÐ°Ð½Ð½ÑÐµ Ð°ÑÐµÑÐ¸Ð°Ð»Ñ',5,0,'bridge/kit.gif','');
>-
>-INSERT INTO `itemtypes` VALUES ('CF', 'ÐÐ¾Ð¼Ð¿ÑÑÑÐµÑÐ½ÑÐµ ÑÐ°Ð¹Ð»Ñ',5,0,'bridge/computer_file.gif','');
>-
>-INSERT INTO `itemtypes` VALUES ('MP', 'ÐÐ°ÑÑÑ',5,0,'bridge/map.gif','');
>-
>-INSERT INTO `itemtypes` VALUES ('VM', 'ÐÐ¸Ð·ÑÐ°Ð»ÑÐ½ÑÐµ Ð¼Ð°ÑÐµÑÐ¸Ð°Ð»Ñ',5,1,'bridge/dvd.gif','');
>-
>-INSERT INTO `itemtypes` VALUES ('MU', 'ÐÑÐ·ÑÐºÐ°',5,0,'bridge/sound.gif','');
>-
>-INSERT INTO `itemtypes` VALUES ('CR', 'ÐÑÐ¾Ð´Ð¾Ð»Ð¶Ð°ÑÑÐ¸ÐµÑÑ ÑÐµÑÑÑÑÑ',5,0,'bridge/periodical.gif','');
>-
>-INSERT INTO `itemtypes` VALUES ('REF', 'Ð¡Ð¿ÑÐ°Ð²Ð¾ÑÐ½Ð¸ÐºÐ¸',0,1,'','');
>+INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES
>+('BK', ' ÐÐ½Ð¸Ð³Ð¸',5,0,'bridge/book.gif',''),
>+('MX', 'Ð¡Ð¼ÐµÑÐ°Ð½Ð½ÑÐµ Ð°ÑÐµÑÐ¸Ð°Ð»Ñ',5,0,'bridge/kit.gif',''),
>+('CF', 'ÐÐ¾Ð¼Ð¿ÑÑÑÐµÑÐ½ÑÐµ ÑÐ°Ð¹Ð»Ñ',5,0,'bridge/computer_file.gif',''),
>+('MP', 'ÐÐ°ÑÑÑ',5,0,'bridge/map.gif',''),
>+('VM', 'ÐÐ¸Ð·ÑÐ°Ð»ÑÐ½ÑÐµ Ð¼Ð°ÑÐµÑÐ¸Ð°Ð»Ñ',5,1,'bridge/dvd.gif',''),
>+('MU', 'ÐÑÐ·ÑÐºÐ°',5,0,'bridge/sound.gif',''),
>+('CR', 'ÐÑÐ¾Ð´Ð¾Ð»Ð¶Ð°ÑÑÐ¸ÐµÑÑ ÑÐµÑÑÑÑÑ',5,0,'bridge/periodical.gif',''),
>+('REF', 'Ð¡Ð¿ÑÐ°Ð²Ð¾ÑÐ½Ð¸ÐºÐ¸',0,1,'','');
>-- 
>1.7.9.5

Actions: View | Diff | Splinter Review

Attachments on bug 10969: 21600 | 21606 | 22090