@@ -, +, @@ - Install the specific language and run the web installer. - Truncate or delete all from the itemtypes table in your database. - Try to run the complete SQL in the itemtypes sample files. --- .../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(-) --- a/installer/data/mysql/de-DE/optional/sample_itemtypes.sql +++ a/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',''); --- a/installer/data/mysql/es-ES/optional/sample_itemtypes.sql +++ a/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,'',''); --- a/installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.sql +++ a/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,'',''); --- a/installer/data/mysql/pl-PL/optional/sample_itemtypes.sql +++ a/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,'',''); --- a/installer/data/mysql/ru-RU/optional/library_item_types.sql +++ a/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,'',''); --