From 97b2a56f2756a1f1947320fe89ce355e0c7cc9c1 Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Fri, 20 Nov 2009 18:28:14 +0100 Subject: [PATCH] more SQL fixes. Installer now works fine with french & unimarc --- .../mysql/fr-FR/3-LecturePub/sample_itemtypes.sql | 24 +++++++++++----------- .../fr-FR/4-Conservation/sample_itemtypes.sql | 18 ++++++++-------- 2 files changed, 21 insertions(+), 21 deletions(-) diff --git a/installer/data/mysql/fr-FR/3-LecturePub/sample_itemtypes.sql b/installer/data/mysql/fr-FR/3-LecturePub/sample_itemtypes.sql index cb238129a3..775daf5ebd 100644 --- a/installer/data/mysql/fr-FR/3-LecturePub/sample_itemtypes.sql +++ b/installer/data/mysql/fr-FR/3-LecturePub/sample_itemtypes.sql @@ -4,15 +4,15 @@ -- SET NAMES utf8; -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('LIVR', ' Livre', 1, 0.0000, 0, 'Fiction.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('BD', 'BD', 1, 0.0000, 0, 'MZ.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('LOC', 'Fonds Local', 1, 0.0000, 0, 'Rare Book.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('PERI', 'Périodique', 1, 0.0000, 0, 'SIRS.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('USUE', 'Usuel', 0, 0.0000, 1, 'Reference.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ARTI', 'Article', 0, 0.0000, 1, 'PF.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('CD', 'CD musique', 1, 0.0000, 0, 'Music CD.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('CDR', 'CD-ROM', 1, 0.0000, 0, 'CD-ROM software.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('DVD', 'DVD', 1, 0.0000, 0, 'DVD.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('WEB', 'Ressource Web', 0, 0.0000, 1, 'WEB.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ADAP', 'Document Adapté', 1, 0.0000, 0, 'Fiction, large print.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('VHS', 'VHS', 1, 0.0000, 0, 'AVNF.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('LIVR', ' Livre', 0.0000, 0, 'Fiction.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('BD', 'BD', 0.0000, 0, 'MZ.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('LOC', 'Fonds Local', 0.0000, 0, 'Rare Book.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('PERI', 'Périodique', 0.0000, 0, 'SIRS.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('USUE', 'Usuel', 0.0000, 1, 'Reference.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ARTI', 'Article', 0.0000, 1, 'PF.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('CD', 'CD musique', 0.0000, 0, 'Music CD.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('CDR', 'CD-ROM', 0.0000, 0, 'CD-ROM software.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('DVD', 'DVD', 0.0000, 0, 'DVD.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('WEB', 'Ressource Web', 0.0000, 1, 'WEB.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ADAP', 'Document Adapté', 0.0000, 0, 'Fiction, large print.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('VHS', 'VHS', 0.0000, 0, 'AVNF.gif', ''); diff --git a/installer/data/mysql/fr-FR/4-Conservation/sample_itemtypes.sql b/installer/data/mysql/fr-FR/4-Conservation/sample_itemtypes.sql index 03f3373132..9aa49fc86f 100644 --- a/installer/data/mysql/fr-FR/4-Conservation/sample_itemtypes.sql +++ b/installer/data/mysql/fr-FR/4-Conservation/sample_itemtypes.sql @@ -2,12 +2,12 @@ -- Contenu de la table `itemtypes` -- SET NAMES utf8; -INSERT IGNORE INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ARTI', 'Article', 0, 0.0000, 0, 'Pamphlet.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MEM', 'Mémoire', 0, 0.0000, 0, 'Faculty Course Materials.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MICR', 'Microfiche', 0, 0.0000, 0, 'Microfiche.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MONA', 'Livre ancien', 0, 0.0000, 0, 'Rare Book.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MONO', ' Livre', 1, 0.0000, 0, 'Fiction.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MULT', 'Multimédia (K7, DVD...)', 0, 0.0000, 0, 'Microfilm.gif', ''); -INSERT IGNORE INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('PERI', 'Périodique', 0, 0.0000, 0, 'SIRS.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('THE', 'Thèse ancienne', 0, 0.0000, 0, 'Rare Book.gif', ''); -INSERT INTO `itemtypes` (`itemtype`, `description`, `renewalsallowed`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('TU', 'Travail Universitaire', 0, 0.0000, 0, 'Faculty Course Materials.gif', ''); +INSERT IGNORE INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ARTI', 'Article', 0.0000, 0, 'Pamphlet.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MEM', 'Mémoire', 0.0000, 0, 'Faculty Course Materials.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MICR', 'Microfiche', 0.0000, 0, 'Microfiche.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MONA', 'Livre ancien', 0.0000, 0, 'Rare Book.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MONO', ' Livre', 0.0000, 0, 'Fiction.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MULT', 'Multimédia (K7, DVD...)', 0.0000, 0, 'Microfilm.gif', ''); +INSERT IGNORE INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('PERI', 'Périodique', 0.0000, 0, 'SIRS.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('THE', 'Thèse ancienne', 0.0000, 0, 'Rare Book.gif', ''); +INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('TU', 'Travail Universitaire', 0.0000, 0, 'Faculty Course Materials.gif', ''); -- 2.11.0