Attachment 31247 Details for Bug 6536 – Bug 6536: Follow-up: Updating web installer sql files for z3950servers

[patch] Bug 6536: Follow-up: Updating web installer sql files for z3950servers

Bug-6536-Follow-up-Updating-web-installer-sql-file.patch (text/plain), 9.46 KB, created by Marcel de Rooy on 2014-08-28 13:23:14 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2014-08-28 13:23:14 UTC

Size: 9.46 KB

patch

obsolete

>From ff9de4b9a88de1cf5c68151a53692419c5f79992 Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Thu, 28 Aug 2014 14:59:56 +0200
>Subject: [PATCH] Bug 6536: Follow-up: Updating web installer sql files for
> z3950servers
>Content-Type: text/plain; charset=utf-8
>
>Removing icon, description and position from installer sql files.
>Not all files contained them.
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>I have run all sql files on an empty table by script.
>---
> .../data/mysql/fr-FR/2-Optionel/z3950_BNF.sql      |    2 +-
> .../data/mysql/nb-NO/2-Valgfritt/z3950servers.sql  |   12 ++++++------
> .../ru-RU/optional/z39-50servers_collection.sql    |   16 ++++++++--------
> .../uk-UA/optional/z39-50servers_collection.sql    |   16 ++++++++--------
> 4 files changed, 23 insertions(+), 23 deletions(-)
>
>diff --git a/installer/data/mysql/fr-FR/2-Optionel/z3950_BNF.sql b/installer/data/mysql/fr-FR/2-Optionel/z3950_BNF.sql
>index cde873e..bbaf526 100644
>--- a/installer/data/mysql/fr-FR/2-Optionel/z3950_BNF.sql
>+++ b/installer/data/mysql/fr-FR/2-Optionel/z3950_BNF.sql
>@@ -1 +1 @@
>-INSERT INTO `z3950servers` (`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `icon`, `position`, `type`, `description`) VALUES ('z3950.bnf.fr', 2211, 'TOUT', 'Z3950', 'Z3950_BNF', 'BNF2', 2, 1, 2, 'UNIMARC', NULL, 'primary', 'zed', '');
>\ No newline at end of file
>+INSERT INTO `z3950servers` (`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `type`) VALUES ('z3950.bnf.fr', 2211, 'TOUT', 'Z3950', 'Z3950_BNF', 'BNF2', 2, 1, 2, 'UNIMARC', 'zed');
>diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql b/installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql
>index b1af0f3..c4d1e46 100644
>--- a/installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql
>+++ b/installer/data/mysql/nb-NO/2-Valgfritt/z3950servers.sql
>@@ -1,6 +1,6 @@
>-INSERT INTO z3950servers (host, port, db, userid, password, name, id, checked, rank, syntax, timeout, icon, position, type, encoding, description) VALUES
>-('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,0,0,'USMARC',0,NULL,'primary','zed','utf8',''),
>-('z3950.bibsys.no',2100,'BIBSYS','','','BIBSYS',12,1,1,'NORMARC',0,NULL,'primary','zed','ISO_8859-1',''),
>-('z3950.nb.no',2100,'Norbok','','','NORBOK',13,0,0,'NORMARC',0,NULL,'primary','zed','ISO_8859-1',''),
>-('z3950.nb.no',2100,'Sambok','','','SAMBOK',14,0,0,'NORMARC',0,NULL,'primary','zed','ISO_8859-1',''),
>-('z3950.deich.folkebibl.no',210,'data','','','DEICHMAN',15,0,0,'NORMARC',0,NULL,'primary','zed','ISO_8859-1','');
>+INSERT INTO z3950servers (host, port, db, userid, password, name, id, checked, rank, syntax, timeout, type, encoding) VALUES
>+('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,0,0,'USMARC',0,'zed','utf8'),
>+('z3950.bibsys.no',2100,'BIBSYS','','','BIBSYS',12,1,1,'NORMARC',0,'zed','ISO_8859-1'),
>+('z3950.nb.no',2100,'Norbok','','','NORBOK',13,0,0,'NORMARC',0,'zed','ISO_8859-1'),
>+('z3950.nb.no',2100,'Sambok','','','SAMBOK',14,0,0,'NORMARC',0,'zed','ISO_8859-1'),
>+('z3950.deich.folkebibl.no',210,'data','','','DEICHMAN',15,0,0,'NORMARC',0,'zed','ISO_8859-1');
>diff --git a/installer/data/mysql/ru-RU/optional/z39-50servers_collection.sql b/installer/data/mysql/ru-RU/optional/z39-50servers_collection.sql
>index 6097f95..0630197 100644
>--- a/installer/data/mysql/ru-RU/optional/z39-50servers_collection.sql
>+++ b/installer/data/mysql/ru-RU/optional/z39-50servers_collection.sql
>@@ -1,11 +1,11 @@
> TRUNCATE z3950servers;
> 
> INSERT INTO `z3950servers` 
>-(`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `icon`, `position`, `type`, `encoding`, `description`) VALUES 
>-('z3950.bnf.fr', 2211, 'TOUT', 'Z3950', 'Z3950_BNF', 'BNF2', 2, 1, 1, 'UNIMARC', NULL, 'primary', 'zed', 'utf8', ''),
>-('62.76.8.149', 210, 'books', '', '', 'ÐÐÐ£Ð§ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ ÐÐÐ¨ÐÐÐ Ð¡ÐÐÐÐ ÐÐÐ¡Ð£ÐÐÐ Ð¡Ð¢ÐÐÐÐÐÐÐ Ð£ÐÐÐÐÐ Ð¡ÐÐ¢ÐÐ¢Ð', 3, 1, 1, 'UNIMARC', NULL, 'primary', 'zed', 'utf8', ''),
>-('81.30.205.34', 210, 'books', '', '', 'ÐÐÐ¦ÐÐÐÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ ÐÐ. ÐÐ¥ÐÐÐ¢-ÐÐÐÐ ÐÐÐÐÐÐ (ÐÐ BOOKS)', 4, 1, 1, 'UNIMARC', NULL, 'primary', 'zed', 'utf8', ''),
>-('libor.pstu.ru', 210, 'books', '', '', 'ÐÐÐ ÐÐ¡ÐÐÐ ÐÐÐ¡Ð£ÐÐÐ Ð¡Ð¢ÐÐÐÐÐ«Ð Ð¢ÐÐ¥ÐÐÐ§ÐÐ¡ÐÐÐ Ð£ÐÐÐÐÐ Ð¡ÐÐ¢ÐÐ¢ (ÐÐ BOOKS)', 5, 1, 1, 'UNIMARC', NULL, 'primary', 'zed', 'utf8', ''),
>-('212.3.135.157', 210, 'books', '', '', 'Ð¡ÐÐÐÐÐÐ¡ÐÐÐ¯ ÐÐÐÐÐ¡Ð¢ÐÐÐ¯ Ð£ÐÐÐÐÐ Ð¡ÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ (ÐÐ BOOKS)', 6, 1, 1, 'UNIMARC', NULL, 'primary', 'zed', 'utf8', ''),
>-('212.3.135.157', 210, 'books_r', '', '', 'Ð¡ÐÐÐÐÐÐ¡ÐÐÐ¯ ÐÐÐÐÐ¡Ð¢ÐÐÐ¯ Ð£ÐÐÐÐÐ Ð¡ÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ (ÐÐ BOOKS_R)', 63, 1, 1, 'UNIMARC', NULL, 'primary', 'zed', 'utf8', ''),
>-('212.3.135.157', 210, 'soub', '', '', 'Ð¡ÐÐÐÐÐÐ¡ÐÐÐ¯ ÐÐÐÐÐ¡Ð¢ÐÐÐ¯ Ð£ÐÐÐÐÐ Ð¡ÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ (ÐÐ SOUB)', 7, 1, 1, 'UNIMARC', NULL, 'primary', 'zed', 'utf8', '');
>\ No newline at end of file
>+(`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `type`, `encoding`) VALUES 
>+('z3950.bnf.fr', 2211, 'TOUT', 'Z3950', 'Z3950_BNF', 'BNF2', 2, 1, 1, 'UNIMARC', 'zed', 'utf8'),
>+('62.76.8.149', 210, 'books', '', '', 'ÐÐÐ£Ð§ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ ÐÐÐ¨ÐÐÐ Ð¡ÐÐÐÐ ÐÐÐ¡Ð£ÐÐÐ Ð¡Ð¢ÐÐÐÐÐÐÐ Ð£ÐÐÐÐÐ Ð¡ÐÐ¢ÐÐ¢Ð', 3, 1, 1, 'UNIMARC', 'zed', 'utf8'),
>+('81.30.205.34', 210, 'books', '', '', 'ÐÐÐ¦ÐÐÐÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ ÐÐ. ÐÐ¥ÐÐÐ¢-ÐÐÐÐ ÐÐÐÐÐÐ (ÐÐ BOOKS)', 4, 1, 1, 'UNIMARC', 'zed', 'utf8'),
>+('libor.pstu.ru', 210, 'books', '', '', 'ÐÐÐ ÐÐ¡ÐÐÐ ÐÐÐ¡Ð£ÐÐÐ Ð¡Ð¢ÐÐÐÐÐ«Ð Ð¢ÐÐ¥ÐÐÐ§ÐÐ¡ÐÐÐ Ð£ÐÐÐÐÐ Ð¡ÐÐ¢ÐÐ¢ (ÐÐ BOOKS)', 5, 1, 1, 'UNIMARC', 'zed', 'utf8'),
>+('212.3.135.157', 210, 'books', '', '', 'Ð¡ÐÐÐÐÐÐ¡ÐÐÐ¯ ÐÐÐÐÐ¡Ð¢ÐÐÐ¯ Ð£ÐÐÐÐÐ Ð¡ÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ (ÐÐ BOOKS)', 6, 1, 1, 'UNIMARC', 'zed', 'utf8'),
>+('212.3.135.157', 210, 'books_r', '', '', 'Ð¡ÐÐÐÐÐÐ¡ÐÐÐ¯ ÐÐÐÐÐ¡Ð¢ÐÐÐ¯ Ð£ÐÐÐÐÐ Ð¡ÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ (ÐÐ BOOKS_R)', 63, 1, 1, 'UNIMARC', 'zed', 'utf8'),
>+('212.3.135.157', 210, 'soub', '', '', 'Ð¡ÐÐÐÐÐÐ¡ÐÐÐ¯ ÐÐÐÐÐ¡Ð¢ÐÐÐ¯ Ð£ÐÐÐÐÐ Ð¡ÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ (ÐÐ SOUB)', 7, 1, 1, 'UNIMARC', 'zed', 'utf8');
>diff --git a/installer/data/mysql/uk-UA/optional/z39-50servers_collection.sql b/installer/data/mysql/uk-UA/optional/z39-50servers_collection.sql
>index 6097f95..0630197 100644
>--- a/installer/data/mysql/uk-UA/optional/z39-50servers_collection.sql
>+++ b/installer/data/mysql/uk-UA/optional/z39-50servers_collection.sql
>@@ -1,11 +1,11 @@
> TRUNCATE z3950servers;
> 
> INSERT INTO `z3950servers` 
>-(`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `icon`, `position`, `type`, `encoding`, `description`) VALUES 
>-('z3950.bnf.fr', 2211, 'TOUT', 'Z3950', 'Z3950_BNF', 'BNF2', 2, 1, 1, 'UNIMARC', NULL, 'primary', 'zed', 'utf8', ''),
>-('62.76.8.149', 210, 'books', '', '', 'ÐÐÐ£Ð§ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ ÐÐÐ¨ÐÐÐ Ð¡ÐÐÐÐ ÐÐÐ¡Ð£ÐÐÐ Ð¡Ð¢ÐÐÐÐÐÐÐ Ð£ÐÐÐÐÐ Ð¡ÐÐ¢ÐÐ¢Ð', 3, 1, 1, 'UNIMARC', NULL, 'primary', 'zed', 'utf8', ''),
>-('81.30.205.34', 210, 'books', '', '', 'ÐÐÐ¦ÐÐÐÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ ÐÐ. ÐÐ¥ÐÐÐ¢-ÐÐÐÐ ÐÐÐÐÐÐ (ÐÐ BOOKS)', 4, 1, 1, 'UNIMARC', NULL, 'primary', 'zed', 'utf8', ''),
>-('libor.pstu.ru', 210, 'books', '', '', 'ÐÐÐ ÐÐ¡ÐÐÐ ÐÐÐ¡Ð£ÐÐÐ Ð¡Ð¢ÐÐÐÐÐ«Ð Ð¢ÐÐ¥ÐÐÐ§ÐÐ¡ÐÐÐ Ð£ÐÐÐÐÐ Ð¡ÐÐ¢ÐÐ¢ (ÐÐ BOOKS)', 5, 1, 1, 'UNIMARC', NULL, 'primary', 'zed', 'utf8', ''),
>-('212.3.135.157', 210, 'books', '', '', 'Ð¡ÐÐÐÐÐÐ¡ÐÐÐ¯ ÐÐÐÐÐ¡Ð¢ÐÐÐ¯ Ð£ÐÐÐÐÐ Ð¡ÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ (ÐÐ BOOKS)', 6, 1, 1, 'UNIMARC', NULL, 'primary', 'zed', 'utf8', ''),
>-('212.3.135.157', 210, 'books_r', '', '', 'Ð¡ÐÐÐÐÐÐ¡ÐÐÐ¯ ÐÐÐÐÐ¡Ð¢ÐÐÐ¯ Ð£ÐÐÐÐÐ Ð¡ÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ (ÐÐ BOOKS_R)', 63, 1, 1, 'UNIMARC', NULL, 'primary', 'zed', 'utf8', ''),
>-('212.3.135.157', 210, 'soub', '', '', 'Ð¡ÐÐÐÐÐÐ¡ÐÐÐ¯ ÐÐÐÐÐ¡Ð¢ÐÐÐ¯ Ð£ÐÐÐÐÐ Ð¡ÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ (ÐÐ SOUB)', 7, 1, 1, 'UNIMARC', NULL, 'primary', 'zed', 'utf8', '');
>\ No newline at end of file
>+(`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `type`, `encoding`) VALUES 
>+('z3950.bnf.fr', 2211, 'TOUT', 'Z3950', 'Z3950_BNF', 'BNF2', 2, 1, 1, 'UNIMARC', 'zed', 'utf8'),
>+('62.76.8.149', 210, 'books', '', '', 'ÐÐÐ£Ð§ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ ÐÐÐ¨ÐÐÐ Ð¡ÐÐÐÐ ÐÐÐ¡Ð£ÐÐÐ Ð¡Ð¢ÐÐÐÐÐÐÐ Ð£ÐÐÐÐÐ Ð¡ÐÐ¢ÐÐ¢Ð', 3, 1, 1, 'UNIMARC', 'zed', 'utf8'),
>+('81.30.205.34', 210, 'books', '', '', 'ÐÐÐ¦ÐÐÐÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ ÐÐ. ÐÐ¥ÐÐÐ¢-ÐÐÐÐ ÐÐÐÐÐÐ (ÐÐ BOOKS)', 4, 1, 1, 'UNIMARC', 'zed', 'utf8'),
>+('libor.pstu.ru', 210, 'books', '', '', 'ÐÐÐ ÐÐ¡ÐÐÐ ÐÐÐ¡Ð£ÐÐÐ Ð¡Ð¢ÐÐÐÐÐ«Ð Ð¢ÐÐ¥ÐÐÐ§ÐÐ¡ÐÐÐ Ð£ÐÐÐÐÐ Ð¡ÐÐ¢ÐÐ¢ (ÐÐ BOOKS)', 5, 1, 1, 'UNIMARC', 'zed', 'utf8'),
>+('212.3.135.157', 210, 'books', '', '', 'Ð¡ÐÐÐÐÐÐ¡ÐÐÐ¯ ÐÐÐÐÐ¡Ð¢ÐÐÐ¯ Ð£ÐÐÐÐÐ Ð¡ÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ (ÐÐ BOOKS)', 6, 1, 1, 'UNIMARC', 'zed', 'utf8'),
>+('212.3.135.157', 210, 'books_r', '', '', 'Ð¡ÐÐÐÐÐÐ¡ÐÐÐ¯ ÐÐÐÐÐ¡Ð¢ÐÐÐ¯ Ð£ÐÐÐÐÐ Ð¡ÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ (ÐÐ BOOKS_R)', 63, 1, 1, 'UNIMARC', 'zed', 'utf8'),
>+('212.3.135.157', 210, 'soub', '', '', 'Ð¡ÐÐÐÐÐÐ¡ÐÐÐ¯ ÐÐÐÐÐ¡Ð¢ÐÐÐ¯ Ð£ÐÐÐÐÐ Ð¡ÐÐÐ¬ÐÐÐ¯ ÐÐÐÐÐÐÐ¢ÐÐÐ (ÐÐ SOUB)', 7, 1, 1, 'UNIMARC', 'zed', 'utf8');
>-- 
>1.7.7.6

Actions: View | Diff | Splinter Review

Attachments on bug 6536: 4540 | 4541 | 4959 | 6901 | 6919 | 6920 | 6924 | 13462 | 26169 | 26170 | 26171 | 26172 | 29754 | 29755 | 29756 | 29779 | 29780 | 29788 | 29790 | 29791 | 29812 | 29813 | 29814 | 29815 | 29816 | 29817 | 29818 | 29819 | 30189 | 30190 | 30191 | 30192 | 30193 | 30194 | 30900 | 30901 | 30902 | 30903 | 30904 | 30905 | 30906 | 30907 | 30929 | 30930 | 30931 | 30932 | 30933 | 30934 | 30935 | 30936 | 31046 | 31048 | 31137 | 31193 | 31194 | 31195 | 31227 | 31247 | 31248 | 37264