Attachment 26593 Details for Bug 7567 – Bug 7567 - Clean up sample news files

[patch] Bug 7567 - Clean up sample news files

Bug-7567---Clean-up-sample-news-files.patch (text/plain), 50.98 KB, created by Mark Tompsett on 2014-03-26 15:56:48 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Mark Tompsett

Created: 2014-03-26 15:56:48 UTC

Size: 50.98 KB

patch

obsolete

>From bf39cd351a491b5822c89e38ff91ba12ade4f0c1 Mon Sep 17 00:00:00 2001
>From: Mark Tompsett <mtompset@hotmail.com>
>Date: Fri, 13 Dec 2013 15:51:36 -0500
>Subject: [PATCH] Bug 7567 - Clean up sample news files
>
>Some files had truncate. Some files had foreign key checks.
>Other files had foreign key checks disabled. Some files gave
>the column names expressly, and others assumed the fields in
>a particular order. Everything was modified to:
>- not truncate
>- not say utf8 (because it should already be by default)
>- not disable foreign key checks (because it should work)
>- expressly name the fields (adding fields shouldn't break it)
>
>TEST PLAN
>---------
>0) Backup opac_news if you care about your news.
>1) open mysql client
>2) use the koha database
>3) Run the following script
>TRUNCATE opac_news;
>source ~/kohaclone/installer/data/mysql/uk-UA/optional/sample_news.sql
>source ~/kohaclone/installer/data/mysql/it-IT/necessari/sample_news.sql
>source ~/kohaclone/installer/data/mysql/de-DE/optional/sample_news.sql
>source ~/kohaclone/installer/data/mysql/nb-NO/2-Valgfritt/sample_news.sql
>source ~/kohaclone/installer/data/mysql/en/optional/sample_news.sql
>source ~/kohaclone/installer/data/mysql/pl-PL/optional/sample_news.sql
>source ~/kohaclone/installer/data/mysql/es-ES/optional/sample_news.sql
>source ~/kohaclone/installer/data/mysql/ru-RU/optional/sample_news.sql
>source ~/kohaclone/installer/data/mysql/fr-FR/2-Optionel/sample_news.sql
>
>- Were there errors?
>- Did everything add nicely?
> - Not likely, by expressly stating the idnew field, the news
> items in some files would not be added.
>
>4) apply patch
>5) try running the script again
>
>- Were there errors?
>- Did everything add nicely?
>6) Log into the staff client
>7) Tools->News
>- Do you see the news items added?
>
>Signed-off-by: Chris Cormack <chris@bigballofwax.co.nz>
>
>Much needed clean up, making for much more robust and less error prone
>sql
>---
> .../data/mysql/de-DE/optional/sample_news.sql | 4 +--
> installer/data/mysql/en/optional/sample_news.sql | 4 +--
> .../data/mysql/es-ES/optional/sample_news.sql | 4 +--
> .../data/mysql/fr-FR/2-Optionel/sample_news.sql | 3 +-
> .../data/mysql/it-IT/necessari/sample_news.sql | 10 ++----
> .../data/mysql/nb-NO/2-Valgfritt/sample_news.sql | 4 +--
> .../data/mysql/pl-PL/optional/sample_news.sql | 4 +--
> .../data/mysql/ru-RU/optional/sample_news.sql | 36 +++++++++-----------
> .../data/mysql/uk-UA/optional/sample_news.sql | 34 +++++++++---------
> 9 files changed, 46 insertions(+), 57 deletions(-)
>
>diff --git a/installer/data/mysql/de-DE/optional/sample_news.sql b/installer/data/mysql/de-DE/optional/sample_news.sql
>index e7a2e6e..1e02676 100644
>--- a/installer/data/mysql/de-DE/optional/sample_news.sql
>+++ b/installer/data/mysql/de-DE/optional/sample_news.sql
>@@ -1,2 +1,2 @@
>-INSERT INTO `opac_news` VALUES (1,'Willkommen bei Koha','Willkommen bei Koha. Koha ist ein vollstÃ¤ndiges integriertes Bibliothekssystem. Es wurde ursprÃ¼nglich in Neuseeland von Katipo Communications Ltd entwickelt und ging im Januar 2000 fÃ¼r den Horowhenua Library Trust zum ersten mal in Produktion. Koha wird heute von einem internationalen Team aus Support-Dienstleistern und Anwendern weiterentwickelt.','koha','2007-10-29 05:25:58','2099-01-10',1),
>-(2,'Was kommt jetzt?','Wie geht es weiter, nachdem Sie Koha installiert haben? Hier einige VorschlÃ¤ge:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Lesen Sie die Koha-Dokumentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Lesen oder Schreiben Sie im Koha-Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Verfolgen oder beteiligen Sie sich an Diskussionen</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Melden Sie Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Erstellen Sie Fehlerkorrekturen mit GIT (Versionskontrollsystem)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chatten Sie mit Koha-Anwendern und -Entwicklern</a></li>\r\n</ul>\r\n','koha','2007-10-29 05:34:45','2099-01-10',2);
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES ('Willkommen bei Koha','Willkommen bei Koha. Koha ist ein vollstÃ¤ndiges integriertes Bibliothekssystem. Es wurde ursprÃ¼nglich in Neuseeland von Katipo Communications Ltd entwickelt und ging im Januar 2000 fÃ¼r den Horowhenua Library Trust zum ersten mal in Produktion. Koha wird heute von einem internationalen Team aus Support-Dienstleistern und Anwendern weiterentwickelt.','koha','2007-10-29 05:25:58','2099-01-10',1),
>+('Was kommt jetzt?','Wie geht es weiter, nachdem Sie Koha installiert haben? Hier einige VorschlÃ¤ge:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Lesen Sie die Koha-Dokumentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Lesen oder Schreiben Sie im Koha-Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Verfolgen oder beteiligen Sie sich an Diskussionen</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Melden Sie Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Erstellen Sie Fehlerkorrekturen mit GIT (Versionskontrollsystem)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chatten Sie mit Koha-Anwendern und -Entwicklern</a></li>\r\n</ul>\r\n','koha','2007-10-29 05:34:45','2099-01-10',2);
>diff --git a/installer/data/mysql/en/optional/sample_news.sql b/installer/data/mysql/en/optional/sample_news.sql
>index 4327f4b..56995bb 100644
>--- a/installer/data/mysql/en/optional/sample_news.sql
>+++ b/installer/data/mysql/en/optional/sample_news.sql
>@@ -1,2 +1,2 @@
>-INSERT INTO `opac_news` VALUES (1,'Welcome to Koha','Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe.','koha','2007-10-29 05:25:58','2099-01-10',1),
>-(2,'What\'s Next?','Now that you\'ve installed Koha, what\'s next? Here are some suggestions:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Read Koha Documentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Read/Write to the Koha Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Read and Contribute to Discussions</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Report Koha Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Submit Patches to Koha using Git (Version Control System)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chat with Koha users and developers</a></li>\r\n</ul>\r\n','koha','2007-10-29 05:34:45','2099-01-10',2);
>\ No newline at end of file
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES ('Welcome to Koha','Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe.','koha','2007-10-29 05:25:58','2099-01-10',1),
>+('What\'s Next?','Now that you\'ve installed Koha, what\'s next? Here are some suggestions:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Read Koha Documentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Read/Write to the Koha Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Read and Contribute to Discussions</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Report Koha Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Submit Patches to Koha using Git (Version Control System)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chat with Koha users and developers</a></li>\r\n</ul>\r\n','koha','2007-10-29 05:34:45','2099-01-10',2);
>diff --git a/installer/data/mysql/es-ES/optional/sample_news.sql b/installer/data/mysql/es-ES/optional/sample_news.sql
>index 4327f4b..56995bb 100644
>--- a/installer/data/mysql/es-ES/optional/sample_news.sql
>+++ b/installer/data/mysql/es-ES/optional/sample_news.sql
>@@ -1,2 +1,2 @@
>-INSERT INTO `opac_news` VALUES (1,'Welcome to Koha','Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe.','koha','2007-10-29 05:25:58','2099-01-10',1),
>-(2,'What\'s Next?','Now that you\'ve installed Koha, what\'s next? Here are some suggestions:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Read Koha Documentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Read/Write to the Koha Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Read and Contribute to Discussions</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Report Koha Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Submit Patches to Koha using Git (Version Control System)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chat with Koha users and developers</a></li>\r\n</ul>\r\n','koha','2007-10-29 05:34:45','2099-01-10',2);
>\ No newline at end of file
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES ('Welcome to Koha','Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe.','koha','2007-10-29 05:25:58','2099-01-10',1),
>+('What\'s Next?','Now that you\'ve installed Koha, what\'s next? Here are some suggestions:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Read Koha Documentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Read/Write to the Koha Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Read and Contribute to Discussions</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Report Koha Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Submit Patches to Koha using Git (Version Control System)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chat with Koha users and developers</a></li>\r\n</ul>\r\n','koha','2007-10-29 05:34:45','2099-01-10',2);
>diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_news.sql b/installer/data/mysql/fr-FR/2-Optionel/sample_news.sql
>index 888a17a..e210d19 100644
>--- a/installer/data/mysql/fr-FR/2-Optionel/sample_news.sql
>+++ b/installer/data/mysql/fr-FR/2-Optionel/sample_news.sql
>@@ -1,2 +1 @@
>-SET NAMES utf8;
>-INSERT INTO `opac_news` VALUES (1,'Bienvenue dans Koha !','Bienvenue dans Koha 3, la toute nouvelle version du systÃ¨me intÃ©grÃ© de gestion de bibliothÃ¨que (SIGB) open source de rÃ©fÃ©rence. DÃ©veloppÃ© initialement en Nouvelle ZÃ©lande et dÃ©ployÃ© pour la premiÃ¨re fois en janvier 2000, Koha est un projet international soutenu par des sociÃ©tÃ©s de services en logiciels libres et par des bibliothÃ©caires du monde entier.','koha','2008-01-14 03:25:58','2099-01-10',1),(2,'Et maintenant ?','FÃ©licitations ! vous avez dÃ©sormais une version opÃ©rationnelle de Koha. Et maintenant, que faire ?\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">lisez la documentation de Koha ;</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">lisez et participez au Wiki de Koha ;</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">abonnez-vous aux listes de discussion ;</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">signalez des bugs ;</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/doku.php?id=en:development:git_usage\">proposez des correctifs et des amÃ©liorations ;</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">discutez avec les utilisateurs et les dÃ©veloppeurs de Koha.</a></li>\r\n</ul>\r\n','koha','2008-01-14 03:34:45','2099-01-10',2);
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES ('Bienvenue dans Koha !','Bienvenue dans Koha 3, la toute nouvelle version du systÃ¨me intÃ©grÃ© de gestion de bibliothÃ¨que (SIGB) open source de rÃ©fÃ©rence. DÃ©veloppÃ© initialement en Nouvelle ZÃ©lande et dÃ©ployÃ© pour la premiÃ¨re fois en janvier 2000, Koha est un projet international soutenu par des sociÃ©tÃ©s de services en logiciels libres et par des bibliothÃ©caires du monde entier.','koha','2008-01-14 03:25:58','2099-01-10',1),('Et maintenant ?','FÃ©licitations ! vous avez dÃ©sormais une version opÃ©rationnelle de Koha. Et maintenant, que faire ?\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">lisez la documentation de Koha ;</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">lisez et participez au Wiki de Koha ;</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">abonnez-vous aux listes de discussion ;</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">signalez des bugs ;</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/doku.php?id=en:development:git_usage\">proposez des correctifs et des amÃ©liorations ;</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">discutez avec les utilisateurs et les dÃ©veloppeurs de Koha.</a></li>\r\n</ul>\r\n','koha','2008-01-14 03:34:45','2099-01-10',2);
>diff --git a/installer/data/mysql/it-IT/necessari/sample_news.sql b/installer/data/mysql/it-IT/necessari/sample_news.sql
>index 30cb64e..0c5f226 100644
>--- a/installer/data/mysql/it-IT/necessari/sample_news.sql
>+++ b/installer/data/mysql/it-IT/necessari/sample_news.sql
>@@ -13,10 +13,6 @@
> -- 
> -- Dump dei dati per la tabella 'opac_news'
> -- 
>-SET FOREIGN_KEY_CHECKS=0;
>-
>-INSERT INTO opac_news (idnew, title, new, lang, timestamp, expirationdate, number) VALUES 
>-(1, 'Benvenuto in Koha', 'Koha Ã¨ un gestionale di biblioteca (ILS) completo e Open Source. Sviluppato inzialmente in New Zealand da Katipo Communications Ltd e messo in linea per la prima volta nel gennaio 2000 per il Horowhenua Library Trust, Koha Ã¨ ora mantenuto da un gruppo di aziende di servizi e dipendenti di biblioteca distribuiti in tutto il mondo.', 'koha', '2007-10-29 00:00:00', '2099-01-10', 1),
>-(2, 'Cosa c''Ã¨ di nuovo ?', 'Ora che hai installato cosa, qual''Ã¨ il passo successivo ? Qui alcuni suggerimenti:\r\n<ul>\r\n<li><a href="http://koha-community.org/documentation/">Leggi la documentazione di Koha</a></li>\r\n<li><a href="http://wiki.koha-community.org">Leggi/aggiorna il Wiki di Koha Wiki</a></li>\r\n<li><a href="http://koha-commaunity.org/support/koha-mailing-lists/">Leggi e contribusci alle liste di discussione</a></li>\r\n<li><a href="http://bugs.koha-community.org">Descrivi e segnala i bug di Koha</a></li>\r\n<li>Chatta con gli utenti e gli sviluppatori di Koha sul server irc.katipo.co.nz, porta 6667 canale #koha</li>\r\n<li><a href="http://stats.workbuffer.org/irclog/koha/today">Leggi il log della chat di Koha di oggi</a></li>\r\n</ul>\r\n', 'koha', '2007-10-29 00:00:00', '2099-01-10', 2);
>-
>-SET FOREIGN_KEY_CHECKS=1;
>+INSERT INTO opac_news (title, new, lang, timestamp, expirationdate, number) VALUES
>+('Benvenuto in Koha', 'Koha Ã¨ un gestionale di biblioteca (ILS) completo e Open Source. Sviluppato inzialmente in New Zealand da Katipo Communications Ltd e messo in linea per la prima volta nel gennaio 2000 per il Horowhenua Library Trust, Koha Ã¨ ora mantenuto da un gruppo di aziende di servizi e dipendenti di biblioteca distribuiti in tutto il mondo.', 'koha', '2007-10-29 00:00:00', '2099-01-10', 1),
>+('Cosa c''Ã¨ di nuovo ?', 'Ora che hai installato cosa, qual''Ã¨ il passo successivo ? Qui alcuni suggerimenti:\r\n<ul>\r\n<li><a href="http://koha-community.org/documentation/">Leggi la documentazione di Koha</a></li>\r\n<li><a href="http://wiki.koha-community.org">Leggi/aggiorna il Wiki di Koha Wiki</a></li>\r\n<li><a href="http://koha-commaunity.org/support/koha-mailing-lists/">Leggi e contribusci alle liste di discussione</a></li>\r\n<li><a href="http://bugs.koha-community.org">Descrivi e segnala i bug di Koha</a></li>\r\n<li>Chatta con gli utenti e gli sviluppatori di Koha sul server irc.katipo.co.nz, porta 6667 canale #koha</li>\r\n<li><a href="http://stats.workbuffer.org/irclog/koha/today">Leggi il log della chat di Koha di oggi</a></li>\r\n</ul>\r\n', 'koha', '2007-10-29 00:00:00', '2099-01-10', 2);
>diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_news.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_news.sql
>index 735db1b..f877258 100644
>--- a/installer/data/mysql/nb-NO/2-Valgfritt/sample_news.sql
>+++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_news.sql
>@@ -1,2 +1,2 @@
>-INSERT INTO `opac_news` VALUES (1,'Velkommen til Koha!','Velkommen til Koha. Koha er et biblioteksystem rikt pÃ¥ funksjoner. Koha ble opprinnelig utviklet i New Zealand av Katipo Communications Ltd og fÃ¸rst tatt i bruk i januar 2000 av Horowhenua Library Trust. I dag vedlikeholdes Koha av et verdensomspennende fellesskap av bibliotek og leverandÃ¸rer.','koha',DATE_SUB(NOW(), INTERVAL 1 DAY),'2099-01-10',1),
>-(2,'Hva nÃ¥?','Hva kan du gjÃ¸re nÃ¥ som du har installert Koha? Her er noen forslag:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Les dokumentasjon</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Les eller bidra til Koha sin wiki</a></li>\r\n<li><a href=\"http://koha-community.org/get-involved/\">Les og delta i diskusjoner</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Meld fra om feil og mangler</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Send inn feilrettinger med Git (versjonskontrollsystem)</a></li>\r\n<li><a href=\"http://koha-community.org/get-involved/irc/\">Chat med Koha-brukere og -utviklere</a></li>\r\n</ul>\r\n','koha',DATE_SUB(NOW(), INTERVAL 1 DAY),'2099-01-10',2);
>\ No newline at end of file
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES ('Velkommen til Koha!','Velkommen til Koha. Koha er et biblioteksystem rikt pÃ¥ funksjoner. Koha ble opprinnelig utviklet i New Zealand av Katipo Communications Ltd og fÃ¸rst tatt i bruk i januar 2000 av Horowhenua Library Trust. I dag vedlikeholdes Koha av et verdensomspennende fellesskap av bibliotek og leverandÃ¸rer.','koha',DATE_SUB(NOW(), INTERVAL 1 DAY),'2099-01-10',1),
>+('Hva nÃ¥?','Hva kan du gjÃ¸re nÃ¥ som du har installert Koha? Her er noen forslag:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Les dokumentasjon</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Les eller bidra til Koha sin wiki</a></li>\r\n<li><a href=\"http://koha-community.org/get-involved/\">Les og delta i diskusjoner</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Meld fra om feil og mangler</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Send inn feilrettinger med Git (versjonskontrollsystem)</a></li>\r\n<li><a href=\"http://koha-community.org/get-involved/irc/\">Chat med Koha-brukere og -utviklere</a></li>\r\n</ul>\r\n','koha',DATE_SUB(NOW(), INTERVAL 1 DAY),'2099-01-10',2);
>diff --git a/installer/data/mysql/pl-PL/optional/sample_news.sql b/installer/data/mysql/pl-PL/optional/sample_news.sql
>index a055b6a..d7fa817 100644
>--- a/installer/data/mysql/pl-PL/optional/sample_news.sql
>+++ b/installer/data/mysql/pl-PL/optional/sample_news.sql
>@@ -1,3 +1,3 @@
>-INSERT INTO `opac_news` VALUES (1,'Witaj w Koha.','Koha to profesjonalny system biblioteczny o otwartym kodzie. Stworzony w Nowej Zelandii przez Katipo Communications Ltd (wdroÅ¼ony po raz pierwszy w styczniu 2000 r. Horowhenua Library Trust) jest obecnie rozwijany przez grupe programistÃ³w i bibliotekarzy z caÅego Åwiata..','koha','2007-10-29 05:25:58','2099-01-10',1),
>-(2,'Co dalej?','ZainstalowaÅeÅ Koha - i co dalej? PoniÅ¼ej znajdziesz kilka wskazÃ³wek:
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES ('Witaj w Koha.','Koha to profesjonalny system biblioteczny o otwartym kodzie. Stworzony w Nowej Zelandii przez Katipo Communications Ltd (wdroÅ¼ony po raz pierwszy w styczniu 2000 r. Horowhenua Library Trust) jest obecnie rozwijany przez grupe programistÃ³w i bibliotekarzy z caÅego Åwiata..','koha','2007-10-29 05:25:58','2099-01-10',1),
>+('Co dalej?','ZainstalowaÅeÅ Koha - i co dalej? PoniÅ¼ej znajdziesz kilka wskazÃ³wek:
> \r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Zapoznaj siÄ z dokumentacjÄ</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Czytaj/Edytuj Koha Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">WeÅº udziaÅ w dyskusji</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">ZgÅoÅÄ bÅÄd</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">WyÅlij patch przy uzyciu Git (Version Control System)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Porozmawiaj z twÃ³rcami i uÅ¼ytkownikami Koha</a></li>\r\n</ul>\r\n','koha','2007-10-29 05:34:45','2099-01-10',2);
>diff --git a/installer/data/mysql/ru-RU/optional/sample_news.sql b/installer/data/mysql/ru-RU/optional/sample_news.sql
>index b6907cf..6517ea9 100644
>--- a/installer/data/mysql/ru-RU/optional/sample_news.sql
>+++ b/installer/data/mysql/ru-RU/optional/sample_news.sql
>@@ -1,29 +1,25 @@
>-TRUNCATE opac_news;
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('Welcome to Koha','Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe.','en','2008-05-28 22:45:42','2099-01-10',1);
> 
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(1,'Welcome to Koha','Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe.','en','2008-05-28 22:45:42','2099-01-10',1);
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('ÐÐ°ÑÐºÐ°Ð²Ð¾ Ð¿ÑÐ¾ÑÐ¸Ð¼Ð¾ Ð´Ð¾ ÐÐ¾ÑÐ°','ÐÐ°ÑÐºÐ°Ð²Ð¾ Ð¿ÑÐ¾ÑÐ¸Ð¼Ð¾ Ð´Ð¾ ÐÐ¾ÑÐ°. ÐÐ¾ÑÐ° Ñ Ð¿Ð¾Ð²Ð½Ð¾ÑÑÐ½ÐºÑÑÐ¾Ð½Ð°Ð»ÑÐ½Ð¾Ñ ÐÐÐÐ¡ Ð· Ð²ÑÐ´ÐºÑÐ¸ÑÐ¸Ð¼Ð¸ Ð´Ð¶ÐµÑÐµÐ»ÑÐ½Ð¸Ð¼Ð¸ ÐºÐ¾Ð´Ð°Ð¼. Ð Ð¾Ð·ÑÐ¾Ð±Ð»ÐµÐ½Ð° ÑÐ¿Ð¾ÑÐ°ÑÐºÑ Ð² ÐÐ¾Ð²ÑÐ¹ ÐÐµÐ»Ð°Ð½Ð´ÑÑ ÐºÐ¾Ð¼Ð¿Ð°Ð½ÑÑÑ Katipo Communications Ltd Ñ Ð²Ð¿ÐµÑÑÐµ Ð²Ð¸Ð¿ÑÑÐµÐ½Ð° Ð² ÑÑÑÐ½Ñ 2000 ÑÐ¾ÐºÑ Ð´Ð»Ñ Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÑÐ½Ð¾Ð³Ð¾ ÐºÐ¾Ð½ÑÐ¾ÑÑÑÑÐ¼Ñ Ð¥Ð¾ÑÐ¾ÑÐ½ÐµÐ°. ÐÐ¾ÑÐ° Ð² Ð´Ð°Ð½Ð¸Ð¹ ÑÐ°Ñ Ð¿ÑÐ´ÑÑÐ¸Ð¼ÑÑÑÑÑÑ Ð³ÑÑÐ¿Ð¾Ñ Ð¿Ð¾ÑÑÐ°ÑÐ°Ð»ÑÐ½Ð¸ÐºÑÐ² Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð½Ð¾Ð³Ð¾ Ð·Ð°Ð±ÐµÐ·Ð¿ÐµÑÐµÐ½Ð½Ñ Ñ ÑÐ°ÑÑÐ²ÑÑÐ¼Ð¸ Ð· Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÑÐ½Ð¸Ñ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³ÑÐ¹ Ð·Ñ Ð²ÑÑÑÑ Ð·ÐµÐ¼Ð½Ð¾Ñ ÐºÑÐ»Ñ. ','uk-UA','2008-05-28 22:48:29','2099-01-10',1);
> 
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(2,'ÐÐ°ÑÐºÐ°Ð²Ð¾ Ð¿ÑÐ¾ÑÐ¸Ð¼Ð¾ Ð´Ð¾ ÐÐ¾ÑÐ°','ÐÐ°ÑÐºÐ°Ð²Ð¾ Ð¿ÑÐ¾ÑÐ¸Ð¼Ð¾ Ð´Ð¾ ÐÐ¾ÑÐ°. ÐÐ¾ÑÐ° Ñ Ð¿Ð¾Ð²Ð½Ð¾ÑÑÐ½ÐºÑÑÐ¾Ð½Ð°Ð»ÑÐ½Ð¾Ñ ÐÐÐÐ¡ Ð· Ð²ÑÐ´ÐºÑÐ¸ÑÐ¸Ð¼Ð¸ Ð´Ð¶ÐµÑÐµÐ»ÑÐ½Ð¸Ð¼Ð¸ ÐºÐ¾Ð´Ð°Ð¼. Ð Ð¾Ð·ÑÐ¾Ð±Ð»ÐµÐ½Ð° ÑÐ¿Ð¾ÑÐ°ÑÐºÑ Ð² ÐÐ¾Ð²ÑÐ¹ ÐÐµÐ»Ð°Ð½Ð´ÑÑ ÐºÐ¾Ð¼Ð¿Ð°Ð½ÑÑÑ Katipo Communications Ltd Ñ Ð²Ð¿ÐµÑÑÐµ Ð²Ð¸Ð¿ÑÑÐµÐ½Ð° Ð² ÑÑÑÐ½Ñ 2000 ÑÐ¾ÐºÑ Ð´Ð»Ñ Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÑÐ½Ð¾Ð³Ð¾ ÐºÐ¾Ð½ÑÐ¾ÑÑÑÑÐ¼Ñ Ð¥Ð¾ÑÐ¾ÑÐ½ÐµÐ°. ÐÐ¾ÑÐ° Ð² Ð´Ð°Ð½Ð¸Ð¹ ÑÐ°Ñ Ð¿ÑÐ´ÑÑÐ¸Ð¼ÑÑÑÑÑÑ Ð³ÑÑÐ¿Ð¾Ñ Ð¿Ð¾ÑÑÐ°ÑÐ°Ð»ÑÐ½Ð¸ÐºÑÐ² Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð½Ð¾Ð³Ð¾ Ð·Ð°Ð±ÐµÐ·Ð¿ÐµÑÐµÐ½Ð½Ñ Ñ ÑÐ°ÑÑÐ²ÑÑÐ¼Ð¸ Ð· Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÑÐ½Ð¸Ñ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³ÑÐ¹ Ð·Ñ Ð²ÑÑÑÑ Ð·ÐµÐ¼Ð½Ð¾Ñ ÐºÑÐ»Ñ. ','uk-UA','2008-05-28 22:48:29','2099-01-10',1);
> 
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('ÐÐ¾Ð±ÑÐ¾ Ð¿Ð¾Ð¶Ð°Ð»Ð¾Ð²Ð°ÑÑ Ð² ÐÐ¾ÑÐ°','ÐÐ¾Ð±ÑÐ¾ Ð¿Ð¾Ð¶Ð°Ð»Ð¾Ð²Ð°ÑÑ Ð² ÐÐ¾ÑÐ°. ÐÐ¾ÑÐ° ÑÐ²Ð»ÑÐµÑÑÑ Ð¿Ð¾Ð»Ð½Ð¾ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½Ð¾Ð¹ ÐÐÐÐ¡ Ñ Ð¾ÑÐºÑÑÑÑÐ¼Ð¸ Ð¸ÑÑÐ¾Ð´Ð½Ð¸ÐºÐ°Ð¼Ð¸. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð° Ð¿ÐµÑÐ²Ð¾Ð½Ð°ÑÐ°Ð»ÑÐ½Ð¾ Ð² ÐÐ¾Ð²Ð¾Ð¹ ÐÐµÐ»Ð°Ð½Ð´Ð¸Ð¸ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸ÐµÐ¹ Katipo Communications Ltd Ð¸ Ð²Ð¿ÐµÑÐ²ÑÐµ Ð²ÑÐ¿ÑÑÐµÐ½Ð° Ð² ÑÐ½Ð²Ð°ÑÐµ 2000 Ð³Ð¾Ð´Ð° Ð´Ð»Ñ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÑÐ½Ð¾Ð³Ð¾ ÐºÐ¾Ð½ÑÐ¾ÑÑÐ¸ÑÐ¼Ð° Ð¥Ð¾ÑÐ¾ÑÐ½ÐµÐ°, ÐÐ¾ÑÐ° Ð² Ð½Ð°ÑÑÐ¾ÑÑÐµÐµ Ð²ÑÐµÐ¼Ñ Ð¿Ð¾Ð´Ð´ÐµÑÐ¶Ð¸Ð²Ð°ÐµÑÑÑ Ð³ÑÑÐ¿Ð¿Ð¾Ð¹ Ð¿Ð¾ÑÑÐ°Ð²ÑÐ¸ÐºÐ¾Ð² Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ Ð¸ ÑÐ¿ÐµÑÐ¸Ð°Ð»Ð¸ÑÑÐ°Ð¼Ð¸ Ð¿Ð¾ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÑÐ½ÑÐ¼ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸ÑÐ¼ ÑÐ¾ Ð²ÑÐµÐ³Ð¾ Ð·ÐµÐ¼Ð½Ð¾Ð³Ð¾ ÑÐ°ÑÐ°. ','ru-RU','2007-10-29 05:25:58','2099-01-10',1);
> 
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(3,'ÐÐ¾Ð±ÑÐ¾ Ð¿Ð¾Ð¶Ð°Ð»Ð¾Ð²Ð°ÑÑ Ð² ÐÐ¾ÑÐ°','ÐÐ¾Ð±ÑÐ¾ Ð¿Ð¾Ð¶Ð°Ð»Ð¾Ð²Ð°ÑÑ Ð² ÐÐ¾ÑÐ°. ÐÐ¾ÑÐ° ÑÐ²Ð»ÑÐµÑÑÑ Ð¿Ð¾Ð»Ð½Ð¾ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½Ð¾Ð¹ ÐÐÐÐ¡ Ñ Ð¾ÑÐºÑÑÑÑÐ¼Ð¸ Ð¸ÑÑÐ¾Ð´Ð½Ð¸ÐºÐ°Ð¼Ð¸. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð° Ð¿ÐµÑÐ²Ð¾Ð½Ð°ÑÐ°Ð»ÑÐ½Ð¾ Ð² ÐÐ¾Ð²Ð¾Ð¹ ÐÐµÐ»Ð°Ð½Ð´Ð¸Ð¸ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸ÐµÐ¹ Katipo Communications Ltd Ð¸ Ð²Ð¿ÐµÑÐ²ÑÐµ Ð²ÑÐ¿ÑÑÐµÐ½Ð° Ð² ÑÐ½Ð²Ð°ÑÐµ 2000 Ð³Ð¾Ð´Ð° Ð´Ð»Ñ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÑÐ½Ð¾Ð³Ð¾ ÐºÐ¾Ð½ÑÐ¾ÑÑÐ¸ÑÐ¼Ð° Ð¥Ð¾ÑÐ¾ÑÐ½ÐµÐ°, ÐÐ¾ÑÐ° Ð² Ð½Ð°ÑÑÐ¾ÑÑÐµÐµ Ð²ÑÐµÐ¼Ñ Ð¿Ð¾Ð´Ð´ÐµÑÐ¶Ð¸Ð²Ð°ÐµÑÑÑ Ð³ÑÑÐ¿Ð¿Ð¾Ð¹ Ð¿Ð¾ÑÑÐ°Ð²ÑÐ¸ÐºÐ¾Ð² Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ Ð¸ ÑÐ¿ÐµÑÐ¸Ð°Ð»Ð¸ÑÑÐ°Ð¼Ð¸ Ð¿Ð¾ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÑÐ½ÑÐ¼ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸ÑÐ¼ ÑÐ¾ Ð²ÑÐµÐ³Ð¾ Ð·ÐµÐ¼Ð½Ð¾Ð³Ð¾ ÑÐ°ÑÐ°. ','ru-RU','2007-10-29 05:25:58','2099-01-10',1);
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('ÐÐ¾Ð±ÑÐ¾ Ð¿Ð¾Ð¶Ð°Ð»Ð¾Ð²Ð°ÑÑ Ð² ÐÐ¾ÑÐ°','ÐÐ¾Ð±ÑÐ¾ Ð¿Ð¾Ð¶Ð°Ð»Ð¾Ð²Ð°ÑÑ Ð² ÐÐ¾ÑÐ°. ÐÐ¾ÑÐ° ÑÐ²Ð»ÑÐµÑÑÑ Ð¿Ð¾Ð»Ð½Ð¾ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½Ð¾Ð¹ ÐÐÐÐ¡ Ñ Ð¾ÑÐºÑÑÑÑÐ¼Ð¸ Ð¸ÑÑÐ¾Ð´Ð½Ð¸ÐºÐ°Ð¼Ð¸. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð° Ð¿ÐµÑÐ²Ð¾Ð½Ð°ÑÐ°Ð»ÑÐ½Ð¾ Ð² ÐÐ¾Ð²Ð¾Ð¹ ÐÐµÐ»Ð°Ð½Ð´Ð¸Ð¸ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸ÐµÐ¹ Katipo Communications Ltd Ð¸ Ð²Ð¿ÐµÑÐ²ÑÐµ Ð²ÑÐ¿ÑÑÐµÐ½Ð° Ð² ÑÐ½Ð²Ð°ÑÐµ 2000 Ð³Ð¾Ð´Ð° Ð´Ð»Ñ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÑÐ½Ð¾Ð³Ð¾ ÐºÐ¾Ð½ÑÐ¾ÑÑÐ¸ÑÐ¼Ð° Ð¥Ð¾ÑÐ¾ÑÐ½ÐµÐ°, ÐÐ¾ÑÐ° Ð² Ð½Ð°ÑÑÐ¾ÑÑÐµÐµ Ð²ÑÐµÐ¼Ñ Ð¿Ð¾Ð´Ð´ÐµÑÐ¶Ð¸Ð²Ð°ÐµÑÑÑ Ð³ÑÑÐ¿Ð¿Ð¾Ð¹ Ð¿Ð¾ÑÑÐ°Ð²ÑÐ¸ÐºÐ¾Ð² Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ Ð¸ ÑÐ¿ÐµÑÐ¸Ð°Ð»Ð¸ÑÑÐ°Ð¼Ð¸ Ð¿Ð¾ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÑÐ½ÑÐ¼ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸ÑÐ¼ ÑÐ¾ Ð²ÑÐµÐ³Ð¾ Ð·ÐµÐ¼Ð½Ð¾Ð³Ð¾ ÑÐ°ÑÐ°. ','koha','2007-10-29 05:25:58','2099-01-10',1);
> 
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(4,'ÐÐ¾Ð±ÑÐ¾ Ð¿Ð¾Ð¶Ð°Ð»Ð¾Ð²Ð°ÑÑ Ð² ÐÐ¾ÑÐ°','ÐÐ¾Ð±ÑÐ¾ Ð¿Ð¾Ð¶Ð°Ð»Ð¾Ð²Ð°ÑÑ Ð² ÐÐ¾ÑÐ°. ÐÐ¾ÑÐ° ÑÐ²Ð»ÑÐµÑÑÑ Ð¿Ð¾Ð»Ð½Ð¾ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½Ð¾Ð¹ ÐÐÐÐ¡ Ñ Ð¾ÑÐºÑÑÑÑÐ¼Ð¸ Ð¸ÑÑÐ¾Ð´Ð½Ð¸ÐºÐ°Ð¼Ð¸. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð° Ð¿ÐµÑÐ²Ð¾Ð½Ð°ÑÐ°Ð»ÑÐ½Ð¾ Ð² ÐÐ¾Ð²Ð¾Ð¹ ÐÐµÐ»Ð°Ð½Ð´Ð¸Ð¸ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸ÐµÐ¹ Katipo Communications Ltd Ð¸ Ð²Ð¿ÐµÑÐ²ÑÐµ Ð²ÑÐ¿ÑÑÐµÐ½Ð° Ð² ÑÐ½Ð²Ð°ÑÐµ 2000 Ð³Ð¾Ð´Ð° Ð´Ð»Ñ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÑÐ½Ð¾Ð³Ð¾ ÐºÐ¾Ð½ÑÐ¾ÑÑÐ¸ÑÐ¼Ð° Ð¥Ð¾ÑÐ¾ÑÐ½ÐµÐ°, ÐÐ¾ÑÐ° Ð² Ð½Ð°ÑÑÐ¾ÑÑÐµÐµ Ð²ÑÐµÐ¼Ñ Ð¿Ð¾Ð´Ð´ÐµÑÐ¶Ð¸Ð²Ð°ÐµÑÑÑ Ð³ÑÑÐ¿Ð¿Ð¾Ð¹ Ð¿Ð¾ÑÑÐ°Ð²ÑÐ¸ÐºÐ¾Ð² Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ Ð¸ ÑÐ¿ÐµÑÐ¸Ð°Ð»Ð¸ÑÑÐ°Ð¼Ð¸ Ð¿Ð¾ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÑÐ½ÑÐ¼ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸ÑÐ¼ ÑÐ¾ Ð²ÑÐµÐ³Ð¾ Ð·ÐµÐ¼Ð½Ð¾Ð³Ð¾ ÑÐ°ÑÐ°. ','koha','2007-10-29 05:25:58','2099-01-10',1);
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('What\'s Next?','Now that you\'ve installed Koha, what\'s next? Here are some suggestions:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Read Koha Documentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Read/Write to the Koha Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Read and Contribute to Discussions</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Report Koha Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Submit Patches to Koha using Git (Version Control System)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chat with Koha users and developers</a></li>\r\n</ul>\r\n','en','2007-10-29 05:34:45','2099-01-10',2);
> 
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('Ð©Ð¾ Ð´Ð°Ð»Ñ?','Ð¢ÐµÐ¿ÐµÑ, ÐºÐ¾Ð»Ð¸ ÐÐ¸ Ð²ÑÑÐ°Ð½Ð¾Ð²Ð¸Ð»Ð¸ ÐÐ¾ÑÐ°, ÑÐ¾ Ð¶ Ð´Ð°Ð»Ñ? ÐÑÑ Ð´ÐµÑÐºÑ Ð¿ÑÐ¾Ð¿Ð¾Ð·Ð¸ÑÑÑ:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ°ÑÑÑ Ð¿ÑÐ¾ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ/Ð¿Ð¸ÑÑÑÑ Ð½Ð° ÐÐ¾ÑÐ° Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ñ Ð±ÐµÑÑÑÑ ÑÑÐ°ÑÑÑ Ð² Ð¾Ð±Ð³Ð¾Ð²Ð¾ÑÐµÐ½Ð½ÑÑ</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Ð Ð°Ð¿Ð¾ÑÑÑÐ¹ÑÐµ Ð¿ÑÐ¾ Ð½ÐµÐ´Ð¾Ð»ÑÐºÐ¸ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\"> ÐÐ¾Ð´Ð°Ð²Ð°Ð¹ÑÐµ Ð¿Ð°ÑÑÑ Ð´Ð»Ñ ÐÐ¾ÑÐ°, Ð²Ð¸ÐºÐ¾ÑÐ¸ÑÑÐ¾Ð²ÑÑÑÐ¸ Git (ÑÐ¸ÑÑÐµÐ¼Ð° ÐºÐ¾Ð½ÑÑÐ¾Ð»Ñ Ð²ÐµÑÑÑÐ¹)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð°Ñ ÐºÐ¾ÑÐ¸ÑÑÑÐ²Ð°ÑÑÐ² ÑÐ° ÑÐ¾Ð·ÑÐ¾Ð±Ð½Ð¸ÐºÑÐ² ÐÐ¾ÑÐ°</a></li>\r\n</ul>','uk-UA','2008-05-28 23:07:23','2099-01-10',2);
> 
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(5,'What\'s Next?','Now that you\'ve installed Koha, what\'s next? Here are some suggestions:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Read Koha Documentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Read/Write to the Koha Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Read and Contribute to Discussions</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Report Koha Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Submit Patches to Koha using Git (Version Control System)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chat with Koha users and developers</a></li>\r\n</ul>\r\n','en','2007-10-29 05:34:45','2099-01-10',2);
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('Ð§ÑÐ¾ Ð´Ð°Ð»ÑÑÐµ?','Ð¢ÐµÐ¿ÐµÑÑ, ÐºÐ¾Ð³Ð´Ð° ÐÑ ÑÑÑÐ°Ð½Ð¾Ð²Ð¸Ð»Ð¸ ÐÐ¾ÑÐ°, ÑÑÐ¾ Ð¶Ðµ Ð´Ð°Ð»ÑÑÐµ? ÐÐ¾Ñ Ð½ÐµÐºÐ¾ÑÐ¾ÑÑÐµ Ð¿ÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ°ÑÐ¸Ñ Ð¿ÑÐ¾ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ/Ð¿Ð¸ÑÐ¸ÑÐµ Ð½Ð° ÐÐ¾ÑÐ° Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\"> Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð¸ Ð¿ÑÐ¸Ð½Ð¸Ð¼Ð°Ð¹ÑÐµ ÑÑÐ°ÑÑÐ¸Ðµ Ð² Ð¾Ð±ÑÑÐ¶Ð´ÐµÐ½Ð¸ÑÑ</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">ÐÑÐ¸ÑÑÐ²Ð°Ð¹ÑÐµÑÑ Ð¿ÑÐ¾ Ð½ÐµÐ´Ð¾ÑÐµÑÑ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\"> ÐÐ¾Ð´Ð°Ð²Ð°Ð¹ÑÐµ Ð¿Ð°ÑÑÐ¸ Ð´Ð»Ñ ÐÐ¾ÑÐ°, Ð¸ÑÐ¿Ð¾Ð»ÑÐ·ÑÑ Git (ÑÐ¸ÑÑÐµÐ¼Ð° ÐºÐ¾Ð½ÑÑÐ¾Ð»Ñ Ð²ÐµÑÑÐ¸Ð¹)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð°Ñ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»ÐµÐ¹ Ð¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÑÐ¸ÐºÐ¾Ð² ÐÐ¾ÑÐ°</a></li>\r\n</ul>','ru-RU','2008-05-28 23:02:25','2099-01-10',2);
> 
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(6,'Ð©Ð¾ Ð´Ð°Ð»Ñ?','Ð¢ÐµÐ¿ÐµÑ, ÐºÐ¾Ð»Ð¸ ÐÐ¸ Ð²ÑÑÐ°Ð½Ð¾Ð²Ð¸Ð»Ð¸ ÐÐ¾ÑÐ°, ÑÐ¾ Ð¶ Ð´Ð°Ð»Ñ? ÐÑÑ Ð´ÐµÑÐºÑ Ð¿ÑÐ¾Ð¿Ð¾Ð·Ð¸ÑÑÑ:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ°ÑÑÑ Ð¿ÑÐ¾ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ/Ð¿Ð¸ÑÑÑÑ Ð½Ð° ÐÐ¾ÑÐ° Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ñ Ð±ÐµÑÑÑÑ ÑÑÐ°ÑÑÑ Ð² Ð¾Ð±Ð³Ð¾Ð²Ð¾ÑÐµÐ½Ð½ÑÑ</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Ð Ð°Ð¿Ð¾ÑÑÑÐ¹ÑÐµ Ð¿ÑÐ¾ Ð½ÐµÐ´Ð¾Ð»ÑÐºÐ¸ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\"> ÐÐ¾Ð´Ð°Ð²Ð°Ð¹ÑÐµ Ð¿Ð°ÑÑÑ Ð´Ð»Ñ ÐÐ¾ÑÐ°, Ð²Ð¸ÐºÐ¾ÑÐ¸ÑÑÐ¾Ð²ÑÑÑÐ¸ Git (ÑÐ¸ÑÑÐµÐ¼Ð° ÐºÐ¾Ð½ÑÑÐ¾Ð»Ñ Ð²ÐµÑÑÑÐ¹)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð°Ñ ÐºÐ¾ÑÐ¸ÑÑÑÐ²Ð°ÑÑÐ² ÑÐ° ÑÐ¾Ð·ÑÐ¾Ð±Ð½Ð¸ÐºÑÐ² ÐÐ¾ÑÐ°</a></li>\r\n</ul>','uk-UA','2008-05-28 23:07:23','2099-01-10',2);
>-
>-
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(7,'Ð§ÑÐ¾ Ð´Ð°Ð»ÑÑÐµ?','Ð¢ÐµÐ¿ÐµÑÑ, ÐºÐ¾Ð³Ð´Ð° ÐÑ ÑÑÑÐ°Ð½Ð¾Ð²Ð¸Ð»Ð¸ ÐÐ¾ÑÐ°, ÑÑÐ¾ Ð¶Ðµ Ð´Ð°Ð»ÑÑÐµ? ÐÐ¾Ñ Ð½ÐµÐºÐ¾ÑÐ¾ÑÑÐµ Ð¿ÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ°ÑÐ¸Ñ Ð¿ÑÐ¾ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ/Ð¿Ð¸ÑÐ¸ÑÐµ Ð½Ð° ÐÐ¾ÑÐ° Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\"> Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð¸ Ð¿ÑÐ¸Ð½Ð¸Ð¼Ð°Ð¹ÑÐµ ÑÑÐ°ÑÑÐ¸Ðµ Ð² Ð¾Ð±ÑÑÐ¶Ð´ÐµÐ½Ð¸ÑÑ</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">ÐÑÐ¸ÑÑÐ²Ð°Ð¹ÑÐµÑÑ Ð¿ÑÐ¾ Ð½ÐµÐ´Ð¾ÑÐµÑÑ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\"> ÐÐ¾Ð´Ð°Ð²Ð°Ð¹ÑÐµ Ð¿Ð°ÑÑÐ¸ Ð´Ð»Ñ ÐÐ¾ÑÐ°, Ð¸ÑÐ¿Ð¾Ð»ÑÐ·ÑÑ Git (ÑÐ¸ÑÑÐµÐ¼Ð° ÐºÐ¾Ð½ÑÑÐ¾Ð»Ñ Ð²ÐµÑÑÐ¸Ð¹)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð°Ñ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»ÐµÐ¹ Ð¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÑÐ¸ÐºÐ¾Ð² ÐÐ¾ÑÐ°</a></li>\r\n</ul>','ru-RU','2008-05-28 23:02:25','2099-01-10',2);
>-
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(8,'Ð§ÑÐ¾ Ð´Ð°Ð»ÑÑÐµ?','Ð¢ÐµÐ¿ÐµÑÑ, ÐºÐ¾Ð³Ð´Ð° ÐÑ ÑÑÑÐ°Ð½Ð¾Ð²Ð¸Ð»Ð¸ ÐÐ¾ÑÐ°, ÑÑÐ¾ Ð¶Ðµ Ð´Ð°Ð»ÑÑÐµ? ÐÐ¾Ñ Ð½ÐµÐºÐ¾ÑÐ¾ÑÑÐµ Ð¿ÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ°ÑÐ¸Ñ Ð¿ÑÐ¾ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ/Ð¿Ð¸ÑÐ¸ÑÐµ Ð½Ð° ÐÐ¾ÑÐ° Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\"> Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð¸ Ð¿ÑÐ¸Ð½Ð¸Ð¼Ð°Ð¹ÑÐµ ÑÑÐ°ÑÑÐ¸Ðµ Ð² Ð¾Ð±ÑÑÐ¶Ð´ÐµÐ½Ð¸ÑÑ</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">ÐÑÐ¸ÑÑÐ²Ð°Ð¹ÑÐµÑÑ Ð¿ÑÐ¾ Ð½ÐµÐ´Ð¾ÑÐµÑÑ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\"> ÐÐ¾Ð´Ð°Ð²Ð°Ð¹ÑÐµ Ð¿Ð°ÑÑÐ¸ Ð´Ð»Ñ ÐÐ¾ÑÐ°, Ð¸ÑÐ¿Ð¾Ð»ÑÐ·ÑÑ Git (ÑÐ¸ÑÑÐµÐ¼Ð° ÐºÐ¾Ð½ÑÑÐ¾Ð»Ñ Ð²ÐµÑÑÐ¸Ð¹)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð°Ñ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»ÐµÐ¹ Ð¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÑÐ¸ÐºÐ¾Ð² ÐÐ¾ÑÐ°</a></li>\r\n</ul>','koha','2008-05-28 23:02:25','2099-01-10',2);
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('Ð§ÑÐ¾ Ð´Ð°Ð»ÑÑÐµ?','Ð¢ÐµÐ¿ÐµÑÑ, ÐºÐ¾Ð³Ð´Ð° ÐÑ ÑÑÑÐ°Ð½Ð¾Ð²Ð¸Ð»Ð¸ ÐÐ¾ÑÐ°, ÑÑÐ¾ Ð¶Ðµ Ð´Ð°Ð»ÑÑÐµ? ÐÐ¾Ñ Ð½ÐµÐºÐ¾ÑÐ¾ÑÑÐµ Ð¿ÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ°ÑÐ¸Ñ Ð¿ÑÐ¾ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ/Ð¿Ð¸ÑÐ¸ÑÐµ Ð½Ð° ÐÐ¾ÑÐ° Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\"> Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð¸ Ð¿ÑÐ¸Ð½Ð¸Ð¼Ð°Ð¹ÑÐµ ÑÑÐ°ÑÑÐ¸Ðµ Ð² Ð¾Ð±ÑÑÐ¶Ð´ÐµÐ½Ð¸ÑÑ</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">ÐÑÐ¸ÑÑÐ²Ð°Ð¹ÑÐµÑÑ Ð¿ÑÐ¾ Ð½ÐµÐ´Ð¾ÑÐµÑÑ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\"> ÐÐ¾Ð´Ð°Ð²Ð°Ð¹ÑÐµ Ð¿Ð°ÑÑÐ¸ Ð´Ð»Ñ ÐÐ¾ÑÐ°, Ð¸ÑÐ¿Ð¾Ð»ÑÐ·ÑÑ Git (ÑÐ¸ÑÑÐµÐ¼Ð° ÐºÐ¾Ð½ÑÑÐ¾Ð»Ñ Ð²ÐµÑÑÐ¸Ð¹)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð°Ñ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»ÐµÐ¹ Ð¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÑÐ¸ÐºÐ¾Ð² ÐÐ¾ÑÐ°</a></li>\r\n</ul>','koha','2008-05-28 23:02:25','2099-01-10',2);
> 
>diff --git a/installer/data/mysql/uk-UA/optional/sample_news.sql b/installer/data/mysql/uk-UA/optional/sample_news.sql
>index 614edac..6f8424b 100644
>--- a/installer/data/mysql/uk-UA/optional/sample_news.sql
>+++ b/installer/data/mysql/uk-UA/optional/sample_news.sql
>@@ -1,25 +1,23 @@
>-TRUNCATE opac_news;
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('ÐÐ¾Ð±ÑÐ¾ Ð¿Ð¾Ð¶Ð°Ð»Ð¾Ð²Ð°ÑÑ Ð² ÐÐ¾ÑÐ°','ÐÐ¾Ð±ÑÐ¾ Ð¿Ð¾Ð¶Ð°Ð»Ð¾Ð²Ð°ÑÑ Ð² ÐÐ¾ÑÐ°. ÐÐ¾ÑÐ° ÑÐ²Ð»ÑÐµÑÑÑ Ð¿Ð¾Ð»Ð½Ð¾ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½Ð¾Ð¹ ÐÐÐÐ¡ Ñ Ð¾ÑÐºÑÑÑÑÐ¼Ð¸ Ð¸ÑÑÐ¾Ð´Ð½Ð¸ÐºÐ°Ð¼Ð¸. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð° Ð¿ÐµÑÐ²Ð¾Ð½Ð°ÑÐ°Ð»ÑÐ½Ð¾ Ð² ÐÐ¾Ð²Ð¾Ð¹ ÐÐµÐ»Ð°Ð½Ð´Ð¸Ð¸ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸ÐµÐ¹ Katipo Communications Ltd Ð¸ Ð²Ð¿ÐµÑÐ²ÑÐµ Ð²ÑÐ¿ÑÑÐµÐ½Ð° Ð² ÑÐ½Ð²Ð°ÑÐµ 2000 Ð³Ð¾Ð´Ð° Ð´Ð»Ñ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÑÐ½Ð¾Ð³Ð¾ ÐºÐ¾Ð½ÑÐ¾ÑÑÐ¸ÑÐ¼Ð° Ð¥Ð¾ÑÐ¾ÑÐ½ÐµÐ°, ÐÐ¾ÑÐ° Ð² Ð½Ð°ÑÑÐ¾ÑÑÐµÐµ Ð²ÑÐµÐ¼Ñ Ð¿Ð¾Ð´Ð´ÐµÑÐ¶Ð¸Ð²Ð°ÐµÑÑÑ Ð³ÑÑÐ¿Ð¿Ð¾Ð¹ Ð¿Ð¾ÑÑÐ°Ð²ÑÐ¸ÐºÐ¾Ð² Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ Ð¸ ÑÐ¿ÐµÑÐ¸Ð°Ð»Ð¸ÑÑÐ°Ð¼Ð¸ Ð¿Ð¾ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÑÐ½ÑÐ¼ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸ÑÐ¼ ÑÐ¾ Ð²ÑÐµÐ³Ð¾ Ð·ÐµÐ¼Ð½Ð¾Ð³Ð¾ ÑÐ°ÑÐ°. ','ru-RU','2007-10-29 05:25:58','2099-01-10',1);
> 
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(1,'ÐÐ¾Ð±ÑÐ¾ Ð¿Ð¾Ð¶Ð°Ð»Ð¾Ð²Ð°ÑÑ Ð² ÐÐ¾ÑÐ°','ÐÐ¾Ð±ÑÐ¾ Ð¿Ð¾Ð¶Ð°Ð»Ð¾Ð²Ð°ÑÑ Ð² ÐÐ¾ÑÐ°. ÐÐ¾ÑÐ° ÑÐ²Ð»ÑÐµÑÑÑ Ð¿Ð¾Ð»Ð½Ð¾ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð»ÑÐ½Ð¾Ð¹ ÐÐÐÐ¡ Ñ Ð¾ÑÐºÑÑÑÑÐ¼Ð¸ Ð¸ÑÑÐ¾Ð´Ð½Ð¸ÐºÐ°Ð¼Ð¸. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð° Ð¿ÐµÑÐ²Ð¾Ð½Ð°ÑÐ°Ð»ÑÐ½Ð¾ Ð² ÐÐ¾Ð²Ð¾Ð¹ ÐÐµÐ»Ð°Ð½Ð´Ð¸Ð¸ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸ÐµÐ¹ Katipo Communications Ltd Ð¸ Ð²Ð¿ÐµÑÐ²ÑÐµ Ð²ÑÐ¿ÑÑÐµÐ½Ð° Ð² ÑÐ½Ð²Ð°ÑÐµ 2000 Ð³Ð¾Ð´Ð° Ð´Ð»Ñ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÑÐ½Ð¾Ð³Ð¾ ÐºÐ¾Ð½ÑÐ¾ÑÑÐ¸ÑÐ¼Ð° Ð¥Ð¾ÑÐ¾ÑÐ½ÐµÐ°, ÐÐ¾ÑÐ° Ð² Ð½Ð°ÑÑÐ¾ÑÑÐµÐµ Ð²ÑÐµÐ¼Ñ Ð¿Ð¾Ð´Ð´ÐµÑÐ¶Ð¸Ð²Ð°ÐµÑÑÑ Ð³ÑÑÐ¿Ð¿Ð¾Ð¹ Ð¿Ð¾ÑÑÐ°Ð²ÑÐ¸ÐºÐ¾Ð² Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ Ð¸ ÑÐ¿ÐµÑÐ¸Ð°Ð»Ð¸ÑÑÐ°Ð¼Ð¸ Ð¿Ð¾ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÑÐ½ÑÐ¼ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸ÑÐ¼ ÑÐ¾ Ð²ÑÐµÐ³Ð¾ Ð·ÐµÐ¼Ð½Ð¾Ð³Ð¾ ÑÐ°ÑÐ°. ','ru-RU','2007-10-29 05:25:58','2099-01-10',1);
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('What\'s Next?','Now that you\'ve installed Koha, what\'s next? Here are some suggestions:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Read Koha Documentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Read/Write to the Koha Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Read and Contribute to Discussions</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Report Koha Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Submit Patches to Koha using Git (Version Control System)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chat with Koha users and developers</a></li>\r\n</ul>\r\n','en','2007-10-29 05:34:45','2099-01-10',2);
> 
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(2,'What\'s Next?','Now that you\'ve installed Koha, what\'s next? Here are some suggestions:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Read Koha Documentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Read/Write to the Koha Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Read and Contribute to Discussions</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Report Koha Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Submit Patches to Koha using Git (Version Control System)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chat with Koha users and developers</a></li>\r\n</ul>\r\n','en','2007-10-29 05:34:45','2099-01-10',2);
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('Welcome to Koha','Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe.','en','2008-05-28 22:45:42','2099-01-10',1);
> 
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(3,'Welcome to Koha','Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe.','en','2008-05-28 22:45:42','2099-01-10',1);
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('ÐÐ°ÑÐºÐ°Ð²Ð¾ Ð¿ÑÐ¾ÑÐ¸Ð¼Ð¾ Ð´Ð¾ ÐÐ¾ÑÐ°','ÐÐ°ÑÐºÐ°Ð²Ð¾ Ð¿ÑÐ¾ÑÐ¸Ð¼Ð¾ Ð´Ð¾ ÐÐ¾ÑÐ°. ÐÐ¾ÑÐ° Ñ Ð¿Ð¾Ð²Ð½Ð¾ÑÑÐ½ÐºÑÑÐ¾Ð½Ð°Ð»ÑÐ½Ð¾Ñ ÐÐÐÐ¡ Ð· Ð²ÑÐ´ÐºÑÐ¸ÑÐ¸Ð¼Ð¸ Ð´Ð¶ÐµÑÐµÐ»ÑÐ½Ð¸Ð¼Ð¸ ÐºÐ¾Ð´Ð°Ð¼. Ð Ð¾Ð·ÑÐ¾Ð±Ð»ÐµÐ½Ð° ÑÐ¿Ð¾ÑÐ°ÑÐºÑ Ð² ÐÐ¾Ð²ÑÐ¹ ÐÐµÐ»Ð°Ð½Ð´ÑÑ ÐºÐ¾Ð¼Ð¿Ð°Ð½ÑÑÑ Katipo Communications Ltd Ñ Ð²Ð¿ÐµÑÑÐµ Ð²Ð¸Ð¿ÑÑÐµÐ½Ð° Ð² ÑÑÑÐ½Ñ 2000 ÑÐ¾ÐºÑ Ð´Ð»Ñ Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÑÐ½Ð¾Ð³Ð¾ ÐºÐ¾Ð½ÑÐ¾ÑÑÑÑÐ¼Ñ Ð¥Ð¾ÑÐ¾ÑÐ½ÐµÐ°. ÐÐ¾ÑÐ° Ð² Ð´Ð°Ð½Ð¸Ð¹ ÑÐ°Ñ Ð¿ÑÐ´ÑÑÐ¸Ð¼ÑÑÑÑÑÑ Ð³ÑÑÐ¿Ð¾Ñ Ð¿Ð¾ÑÑÐ°ÑÐ°Ð»ÑÐ½Ð¸ÐºÑÐ² Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð½Ð¾Ð³Ð¾ Ð·Ð°Ð±ÐµÐ·Ð¿ÐµÑÐµÐ½Ð½Ñ Ñ ÑÐ°ÑÑÐ²ÑÑÐ¼Ð¸ Ð· Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÑÐ½Ð¸Ñ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³ÑÐ¹ Ð·Ñ Ð²ÑÑÑÑ Ð·ÐµÐ¼Ð½Ð¾Ñ ÐºÑÐ»Ñ. ','koha','2008-05-28 22:48:29','2099-01-10',1);
> 
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(4,'ÐÐ°ÑÐºÐ°Ð²Ð¾ Ð¿ÑÐ¾ÑÐ¸Ð¼Ð¾ Ð´Ð¾ ÐÐ¾ÑÐ°','ÐÐ°ÑÐºÐ°Ð²Ð¾ Ð¿ÑÐ¾ÑÐ¸Ð¼Ð¾ Ð´Ð¾ ÐÐ¾ÑÐ°. ÐÐ¾ÑÐ° Ñ Ð¿Ð¾Ð²Ð½Ð¾ÑÑÐ½ÐºÑÑÐ¾Ð½Ð°Ð»ÑÐ½Ð¾Ñ ÐÐÐÐ¡ Ð· Ð²ÑÐ´ÐºÑÐ¸ÑÐ¸Ð¼Ð¸ Ð´Ð¶ÐµÑÐµÐ»ÑÐ½Ð¸Ð¼Ð¸ ÐºÐ¾Ð´Ð°Ð¼. Ð Ð¾Ð·ÑÐ¾Ð±Ð»ÐµÐ½Ð° ÑÐ¿Ð¾ÑÐ°ÑÐºÑ Ð² ÐÐ¾Ð²ÑÐ¹ ÐÐµÐ»Ð°Ð½Ð´ÑÑ ÐºÐ¾Ð¼Ð¿Ð°Ð½ÑÑÑ Katipo Communications Ltd Ñ Ð²Ð¿ÐµÑÑÐµ Ð²Ð¸Ð¿ÑÑÐµÐ½Ð° Ð² ÑÑÑÐ½Ñ 2000 ÑÐ¾ÐºÑ Ð´Ð»Ñ Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÑÐ½Ð¾Ð³Ð¾ ÐºÐ¾Ð½ÑÐ¾ÑÑÑÑÐ¼Ñ Ð¥Ð¾ÑÐ¾ÑÐ½ÐµÐ°. ÐÐ¾ÑÐ° Ð² Ð´Ð°Ð½Ð¸Ð¹ ÑÐ°Ñ Ð¿ÑÐ´ÑÑÐ¸Ð¼ÑÑÑÑÑÑ Ð³ÑÑÐ¿Ð¾Ñ Ð¿Ð¾ÑÑÐ°ÑÐ°Ð»ÑÐ½Ð¸ÐºÑÐ² Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð½Ð¾Ð³Ð¾ Ð·Ð°Ð±ÐµÐ·Ð¿ÐµÑÐµÐ½Ð½Ñ Ñ ÑÐ°ÑÑÐ²ÑÑÐ¼Ð¸ Ð· Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÑÐ½Ð¸Ñ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³ÑÐ¹ Ð·Ñ Ð²ÑÑÑÑ Ð·ÐµÐ¼Ð½Ð¾Ñ ÐºÑÐ»Ñ. ','koha','2008-05-28 22:48:29','2099-01-10',1);
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('Ð§ÑÐ¾ Ð´Ð°Ð»ÑÑÐµ?','Ð¢ÐµÐ¿ÐµÑÑ, ÐºÐ¾Ð³Ð´Ð° ÐÑ ÑÑÑÐ°Ð½Ð¾Ð²Ð¸Ð»Ð¸ ÐÐ¾ÑÐ°, ÑÑÐ¾ Ð¶Ðµ Ð´Ð°Ð»ÑÑÐµ? ÐÐ¾Ñ Ð½ÐµÐºÐ¾ÑÐ¾ÑÑÐµ Ð¿ÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ°ÑÐ¸Ñ Ð¿ÑÐ¾ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ/Ð¿Ð¸ÑÐ¸ÑÐµ Ð½Ð° ÐÐ¾ÑÐ° Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\"> Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð¸ Ð¿ÑÐ¸Ð½Ð¸Ð¼Ð°Ð¹ÑÐµ ÑÑÐ°ÑÑÐ¸Ðµ Ð² Ð¾Ð±ÑÑÐ¶Ð´ÐµÐ½Ð¸ÑÑ</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">ÐÑÐ¸ÑÑÐ²Ð°Ð¹ÑÐµÑÑ Ð¿ÑÐ¾ Ð½ÐµÐ´Ð¾ÑÐµÑÑ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\"> ÐÐ¾Ð´Ð°Ð²Ð°Ð¹ÑÐµ Ð¿Ð°ÑÑÐ¸ Ð´Ð»Ñ ÐÐ¾ÑÐ°, Ð¸ÑÐ¿Ð¾Ð»ÑÐ·ÑÑ Git (ÑÐ¸ÑÑÐµÐ¼Ð° ÐºÐ¾Ð½ÑÑÐ¾Ð»Ñ Ð²ÐµÑÑÐ¸Ð¹)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð°Ñ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»ÐµÐ¹ Ð¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÑÐ¸ÐºÐ¾Ð² ÐÐ¾ÑÐ°</a></li>\r\n</ul>','ru-RU','2008-05-28 23:02:25','2099-01-10',2);
> 
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(5,'Ð§ÑÐ¾ Ð´Ð°Ð»ÑÑÐµ?','Ð¢ÐµÐ¿ÐµÑÑ, ÐºÐ¾Ð³Ð´Ð° ÐÑ ÑÑÑÐ°Ð½Ð¾Ð²Ð¸Ð»Ð¸ ÐÐ¾ÑÐ°, ÑÑÐ¾ Ð¶Ðµ Ð´Ð°Ð»ÑÑÐµ? ÐÐ¾Ñ Ð½ÐµÐºÐ¾ÑÐ¾ÑÑÐµ Ð¿ÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ°ÑÐ¸Ñ Ð¿ÑÐ¾ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ/Ð¿Ð¸ÑÐ¸ÑÐµ Ð½Ð° ÐÐ¾ÑÐ° Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\"> Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð¸ Ð¿ÑÐ¸Ð½Ð¸Ð¼Ð°Ð¹ÑÐµ ÑÑÐ°ÑÑÐ¸Ðµ Ð² Ð¾Ð±ÑÑÐ¶Ð´ÐµÐ½Ð¸ÑÑ</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">ÐÑÐ¸ÑÑÐ²Ð°Ð¹ÑÐµÑÑ Ð¿ÑÐ¾ Ð½ÐµÐ´Ð¾ÑÐµÑÑ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\"> ÐÐ¾Ð´Ð°Ð²Ð°Ð¹ÑÐµ Ð¿Ð°ÑÑÐ¸ Ð´Ð»Ñ ÐÐ¾ÑÐ°, Ð¸ÑÐ¿Ð¾Ð»ÑÐ·ÑÑ Git (ÑÐ¸ÑÑÐµÐ¼Ð° ÐºÐ¾Ð½ÑÑÐ¾Ð»Ñ Ð²ÐµÑÑÐ¸Ð¹)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð°Ñ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»ÐµÐ¹ Ð¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÑÐ¸ÐºÐ¾Ð² ÐÐ¾ÑÐ°</a></li>\r\n</ul>','ru-RU','2008-05-28 23:02:25','2099-01-10',2);
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('Ð©Ð¾ Ð´Ð°Ð»Ñ?','Ð¢ÐµÐ¿ÐµÑ, ÐºÐ¾Ð»Ð¸ ÐÐ¸ Ð²ÑÑÐ°Ð½Ð¾Ð²Ð¸Ð»Ð¸ ÐÐ¾ÑÐ°, ÑÐ¾ Ð¶ Ð´Ð°Ð»Ñ? ÐÑÑ Ð´ÐµÑÐºÑ Ð¿ÑÐ¾Ð¿Ð¾Ð·Ð¸ÑÑÑ:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ°ÑÑÑ Ð¿ÑÐ¾ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ/Ð¿Ð¸ÑÑÑÑ Ð½Ð° ÐÐ¾ÑÐ° Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ñ Ð±ÐµÑÑÑÑ ÑÑÐ°ÑÑÑ Ð² Ð¾Ð±Ð³Ð¾Ð²Ð¾ÑÐµÐ½Ð½ÑÑ</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Ð Ð°Ð¿Ð¾ÑÑÑÐ¹ÑÐµ Ð¿ÑÐ¾ Ð½ÐµÐ´Ð¾Ð»ÑÐºÐ¸ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\"> ÐÐ¾Ð´Ð°Ð²Ð°Ð¹ÑÐµ Ð¿Ð°ÑÑÑ Ð´Ð»Ñ ÐÐ¾ÑÐ°, Ð²Ð¸ÐºÐ¾ÑÐ¸ÑÑÐ¾Ð²ÑÑÑÐ¸ Git (ÑÐ¸ÑÑÐµÐ¼Ð° ÐºÐ¾Ð½ÑÑÐ¾Ð»Ñ Ð²ÐµÑÑÑÐ¹)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð°Ñ ÐºÐ¾ÑÐ¸ÑÑÑÐ²Ð°ÑÑÐ² ÑÐ° ÑÐ¾Ð·ÑÐ¾Ð±Ð½Ð¸ÐºÑÐ² ÐÐ¾ÑÐ°</a></li>\r\n</ul>','koha','2008-05-28 23:07:23','2099-01-10',2);
> 
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(6,'Ð©Ð¾ Ð´Ð°Ð»Ñ?','Ð¢ÐµÐ¿ÐµÑ, ÐºÐ¾Ð»Ð¸ ÐÐ¸ Ð²ÑÑÐ°Ð½Ð¾Ð²Ð¸Ð»Ð¸ ÐÐ¾ÑÐ°, ÑÐ¾ Ð¶ Ð´Ð°Ð»Ñ? ÐÑÑ Ð´ÐµÑÐºÑ Ð¿ÑÐ¾Ð¿Ð¾Ð·Ð¸ÑÑÑ:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ°ÑÑÑ Ð¿ÑÐ¾ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ/Ð¿Ð¸ÑÑÑÑ Ð½Ð° ÐÐ¾ÑÐ° Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ñ Ð±ÐµÑÑÑÑ ÑÑÐ°ÑÑÑ Ð² Ð¾Ð±Ð³Ð¾Ð²Ð¾ÑÐµÐ½Ð½ÑÑ</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Ð Ð°Ð¿Ð¾ÑÑÑÐ¹ÑÐµ Ð¿ÑÐ¾ Ð½ÐµÐ´Ð¾Ð»ÑÐºÐ¸ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\"> ÐÐ¾Ð´Ð°Ð²Ð°Ð¹ÑÐµ Ð¿Ð°ÑÑÑ Ð´Ð»Ñ ÐÐ¾ÑÐ°, Ð²Ð¸ÐºÐ¾ÑÐ¸ÑÑÐ¾Ð²ÑÑÑÐ¸ Git (ÑÐ¸ÑÑÐµÐ¼Ð° ÐºÐ¾Ð½ÑÑÐ¾Ð»Ñ Ð²ÐµÑÑÑÐ¹)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð°Ñ ÐºÐ¾ÑÐ¸ÑÑÑÐ²Ð°ÑÑÐ² ÑÐ° ÑÐ¾Ð·ÑÐ¾Ð±Ð½Ð¸ÐºÑÐ² ÐÐ¾ÑÐ°</a></li>\r\n</ul>','koha','2008-05-28 23:07:23','2099-01-10',2);
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('ÐÐ°ÑÐºÐ°Ð²Ð¾ Ð¿ÑÐ¾ÑÐ¸Ð¼Ð¾ Ð´Ð¾ ÐÐ¾ÑÐ°','ÐÐ°ÑÐºÐ°Ð²Ð¾ Ð¿ÑÐ¾ÑÐ¸Ð¼Ð¾ Ð´Ð¾ ÐÐ¾ÑÐ°. ÐÐ¾ÑÐ° Ñ Ð¿Ð¾Ð²Ð½Ð¾ÑÑÐ½ÐºÑÑÐ¾Ð½Ð°Ð»ÑÐ½Ð¾Ñ ÐÐÐÐ¡ Ð· Ð²ÑÐ´ÐºÑÐ¸ÑÐ¸Ð¼Ð¸ Ð´Ð¶ÐµÑÐµÐ»ÑÐ½Ð¸Ð¼Ð¸ ÐºÐ¾Ð´Ð°Ð¼. Ð Ð¾Ð·ÑÐ¾Ð±Ð»ÐµÐ½Ð° ÑÐ¿Ð¾ÑÐ°ÑÐºÑ Ð² ÐÐ¾Ð²ÑÐ¹ ÐÐµÐ»Ð°Ð½Ð´ÑÑ ÐºÐ¾Ð¼Ð¿Ð°Ð½ÑÑÑ Katipo Communications Ltd Ñ Ð²Ð¿ÐµÑÑÐµ Ð²Ð¸Ð¿ÑÑÐµÐ½Ð° Ð² ÑÑÑÐ½Ñ 2000 ÑÐ¾ÐºÑ Ð´Ð»Ñ Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÑÐ½Ð¾Ð³Ð¾ ÐºÐ¾Ð½ÑÐ¾ÑÑÑÑÐ¼Ñ Ð¥Ð¾ÑÐ¾ÑÐ½ÐµÐ°. ÐÐ¾ÑÐ° Ð² Ð´Ð°Ð½Ð¸Ð¹ ÑÐ°Ñ Ð¿ÑÐ´ÑÑÐ¸Ð¼ÑÑÑÑÑÑ Ð³ÑÑÐ¿Ð¾Ñ Ð¿Ð¾ÑÑÐ°ÑÐ°Ð»ÑÐ½Ð¸ÐºÑÐ² Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð½Ð¾Ð³Ð¾ Ð·Ð°Ð±ÐµÐ·Ð¿ÐµÑÐµÐ½Ð½Ñ Ñ ÑÐ°ÑÑÐ²ÑÑÐ¼Ð¸ Ð· Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÑÐ½Ð¸Ñ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³ÑÐ¹ Ð·Ñ Ð²ÑÑÑÑ Ð·ÐµÐ¼Ð½Ð¾Ñ ÐºÑÐ»Ñ. ','uk-UA','2008-05-28 22:48:29','2099-01-10',1);
> 
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(7,'ÐÐ°ÑÐºÐ°Ð²Ð¾ Ð¿ÑÐ¾ÑÐ¸Ð¼Ð¾ Ð´Ð¾ ÐÐ¾ÑÐ°','ÐÐ°ÑÐºÐ°Ð²Ð¾ Ð¿ÑÐ¾ÑÐ¸Ð¼Ð¾ Ð´Ð¾ ÐÐ¾ÑÐ°. ÐÐ¾ÑÐ° Ñ Ð¿Ð¾Ð²Ð½Ð¾ÑÑÐ½ÐºÑÑÐ¾Ð½Ð°Ð»ÑÐ½Ð¾Ñ ÐÐÐÐ¡ Ð· Ð²ÑÐ´ÐºÑÐ¸ÑÐ¸Ð¼Ð¸ Ð´Ð¶ÐµÑÐµÐ»ÑÐ½Ð¸Ð¼Ð¸ ÐºÐ¾Ð´Ð°Ð¼. Ð Ð¾Ð·ÑÐ¾Ð±Ð»ÐµÐ½Ð° ÑÐ¿Ð¾ÑÐ°ÑÐºÑ Ð² ÐÐ¾Ð²ÑÐ¹ ÐÐµÐ»Ð°Ð½Ð´ÑÑ ÐºÐ¾Ð¼Ð¿Ð°Ð½ÑÑÑ Katipo Communications Ltd Ñ Ð²Ð¿ÐµÑÑÐµ Ð²Ð¸Ð¿ÑÑÐµÐ½Ð° Ð² ÑÑÑÐ½Ñ 2000 ÑÐ¾ÐºÑ Ð´Ð»Ñ Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÑÐ½Ð¾Ð³Ð¾ ÐºÐ¾Ð½ÑÐ¾ÑÑÑÑÐ¼Ñ Ð¥Ð¾ÑÐ¾ÑÐ½ÐµÐ°. ÐÐ¾ÑÐ° Ð² Ð´Ð°Ð½Ð¸Ð¹ ÑÐ°Ñ Ð¿ÑÐ´ÑÑÐ¸Ð¼ÑÑÑÑÑÑ Ð³ÑÑÐ¿Ð¾Ñ Ð¿Ð¾ÑÑÐ°ÑÐ°Ð»ÑÐ½Ð¸ÐºÑÐ² Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð½Ð¾Ð³Ð¾ Ð·Ð°Ð±ÐµÐ·Ð¿ÐµÑÐµÐ½Ð½Ñ Ñ ÑÐ°ÑÑÐ²ÑÑÐ¼Ð¸ Ð· Ð±ÑÐ±Ð»ÑÐ¾ÑÐµÑÐ½Ð¸Ñ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³ÑÐ¹ Ð·Ñ Ð²ÑÑÑÑ Ð·ÐµÐ¼Ð½Ð¾Ñ ÐºÑÐ»Ñ. ','uk-UA','2008-05-28 22:48:29','2099-01-10',1);
>-
>-INSERT INTO `opac_news` (`idnew`, `title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES 
>-(8,'Ð©Ð¾ Ð´Ð°Ð»Ñ?','Ð¢ÐµÐ¿ÐµÑ, ÐºÐ¾Ð»Ð¸ ÐÐ¸ Ð²ÑÑÐ°Ð½Ð¾Ð²Ð¸Ð»Ð¸ ÐÐ¾ÑÐ°, ÑÐ¾ Ð¶ Ð´Ð°Ð»Ñ? ÐÑÑ Ð´ÐµÑÐºÑ Ð¿ÑÐ¾Ð¿Ð¾Ð·Ð¸ÑÑÑ:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ°ÑÑÑ Ð¿ÑÐ¾ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ/Ð¿Ð¸ÑÑÑÑ Ð½Ð° ÐÐ¾ÑÐ° Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ñ Ð±ÐµÑÑÑÑ ÑÑÐ°ÑÑÑ Ð² Ð¾Ð±Ð³Ð¾Ð²Ð¾ÑÐµÐ½Ð½ÑÑ</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Ð Ð°Ð¿Ð¾ÑÑÑÐ¹ÑÐµ Ð¿ÑÐ¾ Ð½ÐµÐ´Ð¾Ð»ÑÐºÐ¸ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\"> ÐÐ¾Ð´Ð°Ð²Ð°Ð¹ÑÐµ Ð¿Ð°ÑÑÑ Ð´Ð»Ñ ÐÐ¾ÑÐ°, Ð²Ð¸ÐºÐ¾ÑÐ¸ÑÑÐ¾Ð²ÑÑÑÐ¸ Git (ÑÐ¸ÑÑÐµÐ¼Ð° ÐºÐ¾Ð½ÑÑÐ¾Ð»Ñ Ð²ÐµÑÑÑÐ¹)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð°Ñ ÐºÐ¾ÑÐ¸ÑÑÑÐ²Ð°ÑÑÐ² ÑÐ° ÑÐ¾Ð·ÑÐ¾Ð±Ð½Ð¸ÐºÑÐ² ÐÐ¾ÑÐ°</a></li>\r\n</ul>','uk-UA','2008-05-28 23:07:23','2099-01-10',2);
>+INSERT INTO `opac_news` (`title`, `new`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES
>+('Ð©Ð¾ Ð´Ð°Ð»Ñ?','Ð¢ÐµÐ¿ÐµÑ, ÐºÐ¾Ð»Ð¸ ÐÐ¸ Ð²ÑÑÐ°Ð½Ð¾Ð²Ð¸Ð»Ð¸ ÐÐ¾ÑÐ°, ÑÐ¾ Ð¶ Ð´Ð°Ð»Ñ? ÐÑÑ Ð´ÐµÑÐºÑ Ð¿ÑÐ¾Ð¿Ð¾Ð·Ð¸ÑÑÑ:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ°ÑÑÑ Ð¿ÑÐ¾ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ/Ð¿Ð¸ÑÑÑÑ Ð½Ð° ÐÐ¾ÑÐ° Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð¸ÑÐ°Ð¹ÑÐµ Ñ Ð±ÐµÑÑÑÑ ÑÑÐ°ÑÑÑ Ð² Ð¾Ð±Ð³Ð¾Ð²Ð¾ÑÐµÐ½Ð½ÑÑ</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Ð Ð°Ð¿Ð¾ÑÑÑÐ¹ÑÐµ Ð¿ÑÐ¾ Ð½ÐµÐ´Ð¾Ð»ÑÐºÐ¸ ÐÐ¾ÑÐ°</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\"> ÐÐ¾Ð´Ð°Ð²Ð°Ð¹ÑÐµ Ð¿Ð°ÑÑÑ Ð´Ð»Ñ ÐÐ¾ÑÐ°, Ð²Ð¸ÐºÐ¾ÑÐ¸ÑÑÐ¾Ð²ÑÑÑÐ¸ Git (ÑÐ¸ÑÑÐµÐ¼Ð° ÐºÐ¾Ð½ÑÑÐ¾Ð»Ñ Ð²ÐµÑÑÑÐ¹)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Ð§Ð°Ñ ÐºÐ¾ÑÐ¸ÑÑÑÐ²Ð°ÑÑÐ² ÑÐ° ÑÐ¾Ð·ÑÐ¾Ð±Ð½Ð¸ÐºÑÐ² ÐÐ¾ÑÐ°</a></li>\r\n</ul>','uk-UA','2008-05-28 23:07:23','2099-01-10',2);
>-- 
>1.7.9.5

Actions: View | Diff | Splinter Review

Attachments on bug 7567: 22863 | 22917 | 22920 | 23350 | 23351 | 23352 | 23362 | 23368 | 23378 | 23383 | 23386 | 23474 | 23475 | 23501 | 23544 | 23547 | 23552 | 23553 | 23554 | 23559 | 23664 | 23703 | 23704 | 23705 | 25316 | 25317 | 25318 | 25319 | 25320 | 25321 | 25322 | 25323 | 25324 | 25325 | 25331 | 25332 | 25333 | 26510 | 26511 | 26590 | 26591 | 26592 | 26593 | 26594 | 26595 | 26596 | 26597 | 26598 | 26599 | 26600 | 26601 | 26602 | 26603 | 26604 | 26605 | 26606 | 26607 | 26608 | 26609 | 26610 | 26611 | 26612 | 26631 | 26632 | 26633 | 26634 | 26635 | 26636 | 26637 | 26638 | 26639 | 26640 | 26641 | 26642 | 26643 | 26644 | 26647