Bug 21651: Remove language specific sql file for notice templates related tables
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Wed, 24 Oct 2018 19:34:46 +0000 (16:34 -0300)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Thu, 30 May 2019 19:22:44 +0000 (20:22 +0100)
This patch removes the 3 following files for the different languages
- message_transport_types.sql
- sample_notices_message_attributes.sql
- sample_notices_message_transports.sql
They were all identical, only one version is kept in installer/data/mysql/mandatory

.txt files are removed as well

They inserted data for
- message_transport_types
- message_attributes
- message_transport_type

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
(cherry picked from commit 1114ba929f0aa634d6f9c10d8931c2ca25871c7d)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

59 files changed:
installer/data/mysql/de-DE/mandatory/message_transport_types.txt [deleted file]
installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql [deleted file]
installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.txt [deleted file]
installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.txt [deleted file]
installer/data/mysql/en/mandatory/message_transport_types.sql [deleted file]
installer/data/mysql/en/mandatory/message_transport_types.txt [deleted file]
installer/data/mysql/en/mandatory/sample_notices_message_attributes.txt [deleted file]
installer/data/mysql/en/mandatory/sample_notices_message_transports.txt [deleted file]
installer/data/mysql/es-ES/mandatory/message_transport_types.sql [deleted file]
installer/data/mysql/es-ES/mandatory/message_transport_types.txt [deleted file]
installer/data/mysql/es-ES/mandatory/sample_notices_message_attributes.sql [deleted file]
installer/data/mysql/es-ES/mandatory/sample_notices_message_attributes.txt [deleted file]
installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.sql [deleted file]
installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.txt [deleted file]
installer/data/mysql/fr-CA/obligatoire/message_transport_types.sql [deleted file]
installer/data/mysql/fr-CA/obligatoire/message_transport_types.txt [deleted file]
installer/data/mysql/fr-CA/obligatoire/sample_notices_message_attributes.sql [deleted file]
installer/data/mysql/fr-CA/obligatoire/sample_notices_message_attributes.txt [deleted file]
installer/data/mysql/fr-CA/obligatoire/sample_notices_message_transports.sql [deleted file]
installer/data/mysql/fr-CA/obligatoire/sample_notices_message_transports.txt [deleted file]
installer/data/mysql/fr-FR/1-Obligatoire/message_transport_types.sql [deleted file]
installer/data/mysql/fr-FR/1-Obligatoire/message_transport_types.txt [deleted file]
installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_attributes.sql [deleted file]
installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_attributes.txt [deleted file]
installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.sql [deleted file]
installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.txt [deleted file]
installer/data/mysql/it-IT/necessari/message_transport_types.sql [deleted file]
installer/data/mysql/it-IT/necessari/message_transport_types.txt [deleted file]
installer/data/mysql/it-IT/necessari/sample_notices_message_attributes.sql [deleted file]
installer/data/mysql/it-IT/necessari/sample_notices_message_attributes.txt [deleted file]
installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql [deleted file]
installer/data/mysql/it-IT/necessari/sample_notices_message_transports.txt [deleted file]
installer/data/mysql/mandatory/message_transport_types.sql [moved from installer/data/mysql/de-DE/mandatory/message_transport_types.sql with 100% similarity]
installer/data/mysql/mandatory/sample_notices_message_attributes.sql [moved from installer/data/mysql/en/mandatory/sample_notices_message_attributes.sql with 100% similarity]
installer/data/mysql/mandatory/sample_notices_message_transports.sql [moved from installer/data/mysql/en/mandatory/sample_notices_message_transports.sql with 100% similarity]
installer/data/mysql/nb-NO/1-Obligatorisk/message_transport_types.sql [deleted file]
installer/data/mysql/nb-NO/1-Obligatorisk/message_transport_types.txt [deleted file]
installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_attributes.sql [deleted file]
installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_attributes.txt [deleted file]
installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.sql [deleted file]
installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.txt [deleted file]
installer/data/mysql/pl-PL/mandatory/message_transport_types.sql [deleted file]
installer/data/mysql/pl-PL/mandatory/message_transport_types.txt [deleted file]
installer/data/mysql/pl-PL/mandatory/sample_notices_message_attributes.sql [deleted file]
installer/data/mysql/pl-PL/mandatory/sample_notices_message_attributes.txt [deleted file]
installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.sql [deleted file]
installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.txt [deleted file]
installer/data/mysql/ru-RU/mandatory/message_transport_types.sql [deleted file]
installer/data/mysql/ru-RU/mandatory/message_transport_types.txt [deleted file]
installer/data/mysql/ru-RU/mandatory/sample_notices_message_attributes.sql [deleted file]
installer/data/mysql/ru-RU/mandatory/sample_notices_message_attributes.txt [deleted file]
installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.sql [deleted file]
installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.txt [deleted file]
installer/data/mysql/uk-UA/mandatory/message_transport_types.sql [deleted file]
installer/data/mysql/uk-UA/mandatory/message_transport_types.txt [deleted file]
installer/data/mysql/uk-UA/mandatory/sample_notices_message_attributes.sql [deleted file]
installer/data/mysql/uk-UA/mandatory/sample_notices_message_attributes.txt [deleted file]
installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.sql [deleted file]
installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.txt [deleted file]

diff --git a/installer/data/mysql/de-DE/mandatory/message_transport_types.txt b/installer/data/mysql/de-DE/mandatory/message_transport_types.txt
deleted file mode 100644 (file)
index ed177e9..0000000
+++ /dev/null
@@ -1,2 +0,0 @@
-Definiert die unterstützten Transportarten für Benachrichtigungen
-(Email, SMS, ...)
diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql b/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql
deleted file mode 100644 (file)
index b078106..0000000
+++ /dev/null
@@ -1,8 +0,0 @@
-insert into `message_attributes`
-(`message_attribute_id`, message_name, `takes_days`)
-values
-(1, 'Item_Due', 0),
-(2, 'Advance_Notice', 1),
-(4, 'Hold_Filled', 0),
-(5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
\ No newline at end of file
diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.txt b/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.txt
deleted file mode 100644 (file)
index 5b1a161..0000000
+++ /dev/null
@@ -1,2 +0,0 @@
-Definiert Benachrichtigungsoptionen für Fälligkeits-, Erinnerungs- und
-Vormerkbenachrichtigungen.
diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.txt b/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.txt
deleted file mode 100644 (file)
index 76e8d0d..0000000
+++ /dev/null
@@ -1,2 +0,0 @@
-Definiert Versandarten u.a. für Fälligkeits-, Erinnerungs-,
-und Vormerkbenachrichtigungen per Email und SMS.
diff --git a/installer/data/mysql/en/mandatory/message_transport_types.sql b/installer/data/mysql/en/mandatory/message_transport_types.sql
deleted file mode 100644 (file)
index ed3c4ad..0000000
+++ /dev/null
@@ -1,7 +0,0 @@
-INSERT INTO message_transport_types
-(message_transport_type)
-values
-('email'),
-('print'),
-('sms'),
-('phone');
diff --git a/installer/data/mysql/en/mandatory/message_transport_types.txt b/installer/data/mysql/en/mandatory/message_transport_types.txt
deleted file mode 100644 (file)
index 054d914..0000000
+++ /dev/null
@@ -1,2 +0,0 @@
-Defines default message transports for email and sms.
-
diff --git a/installer/data/mysql/en/mandatory/sample_notices_message_attributes.txt b/installer/data/mysql/en/mandatory/sample_notices_message_attributes.txt
deleted file mode 100644 (file)
index 5a326f4..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Defines default messages for the enhanced messaging configuration.
diff --git a/installer/data/mysql/en/mandatory/sample_notices_message_transports.txt b/installer/data/mysql/en/mandatory/sample_notices_message_transports.txt
deleted file mode 100644 (file)
index 74cea36..0000000
+++ /dev/null
@@ -1,2 +0,0 @@
-Defines default message transports for sending item due messages and
-advance notice messages through email and SMS.
diff --git a/installer/data/mysql/es-ES/mandatory/message_transport_types.sql b/installer/data/mysql/es-ES/mandatory/message_transport_types.sql
deleted file mode 100644 (file)
index ed3c4ad..0000000
+++ /dev/null
@@ -1,7 +0,0 @@
-INSERT INTO message_transport_types
-(message_transport_type)
-values
-('email'),
-('print'),
-('sms'),
-('phone');
diff --git a/installer/data/mysql/es-ES/mandatory/message_transport_types.txt b/installer/data/mysql/es-ES/mandatory/message_transport_types.txt
deleted file mode 100644 (file)
index d1137d0..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Medios de envio de notificaciones por email y SMS predeterminados.
diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices_message_attributes.sql b/installer/data/mysql/es-ES/mandatory/sample_notices_message_attributes.sql
deleted file mode 100644 (file)
index a7a6032..0000000
+++ /dev/null
@@ -1,9 +0,0 @@
-insert into `message_attributes`
-(`message_attribute_id`, message_name, `takes_days`)
-values
-(1, 'Item_Due', 0),
-(2, 'Advance_Notice', 1),
-(4, 'Hold_Filled', 0),
-(5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
-
diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices_message_attributes.txt b/installer/data/mysql/es-ES/mandatory/sample_notices_message_attributes.txt
deleted file mode 100644 (file)
index aacf285..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Mensajes predeterminados para fechas de vencimiento, anuncios en general, y eventos de la biblioteca.
diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.sql
deleted file mode 100644 (file)
index 5954baf..0000000
+++ /dev/null
@@ -1,20 +0,0 @@
-insert into `message_transports`
-(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
-values
-(1, 'email', 0, 'circulation', 'DUE'),
-(1, 'email', 1, 'circulation', 'DUEDGST'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(2, 'phone', 0, 'circulation', 'PREDUE'),
-(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
-(4, 'email', 0, 'reserves',    'HOLD'),
-(4, 'sms',   0, 'reserves',    'HOLD'),
-(4, 'phone', 0, 'reserves',    'HOLD'),
-(5, 'email', 0, 'circulation', 'CHECKIN'),
-(5, 'sms',   0, 'circulation', 'CHECKIN'),
-(6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.txt b/installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.txt
deleted file mode 100644 (file)
index 4f5143c..0000000
+++ /dev/null
@@ -1,2 +0,0 @@
-Define los medios de envío de avisos de vencimiento, cercanía de fechas
-importantes y avisos de eventos de la biblioteca a través de email o SMS.
diff --git a/installer/data/mysql/fr-CA/obligatoire/message_transport_types.sql b/installer/data/mysql/fr-CA/obligatoire/message_transport_types.sql
deleted file mode 100644 (file)
index 3a90e76..0000000
+++ /dev/null
@@ -1,8 +0,0 @@
-INSERT INTO message_transport_types
-(message_transport_type)
-values
-('print'),
-('email'),
-('sms'),
-('feed'),
-('phone');
diff --git a/installer/data/mysql/fr-CA/obligatoire/message_transport_types.txt b/installer/data/mysql/fr-CA/obligatoire/message_transport_types.txt
deleted file mode 100644 (file)
index 03b0f52..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Liste des types de transport possibles pour les messages (courriel, sms, impression, flux et téléphone).
diff --git a/installer/data/mysql/fr-CA/obligatoire/sample_notices_message_attributes.sql b/installer/data/mysql/fr-CA/obligatoire/sample_notices_message_attributes.sql
deleted file mode 100644 (file)
index 8499d3d..0000000
+++ /dev/null
@@ -1,8 +0,0 @@
-insert into `message_attributes`
-(`message_attribute_id`, message_name, `takes_days`)
-values
-(1, 'Item_Due', 0),
-(2, 'Advance_Notice', 1),
-(4, 'Hold_Filled', 0),
-(5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
diff --git a/installer/data/mysql/fr-CA/obligatoire/sample_notices_message_attributes.txt b/installer/data/mysql/fr-CA/obligatoire/sample_notices_message_attributes.txt
deleted file mode 100644 (file)
index 9396ec1..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Définit les messages par défaut pour les documents en retard, les notifications et les évènements de la bibliothèque à venir.
diff --git a/installer/data/mysql/fr-CA/obligatoire/sample_notices_message_transports.sql b/installer/data/mysql/fr-CA/obligatoire/sample_notices_message_transports.sql
deleted file mode 100644 (file)
index 5954baf..0000000
+++ /dev/null
@@ -1,20 +0,0 @@
-insert into `message_transports`
-(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
-values
-(1, 'email', 0, 'circulation', 'DUE'),
-(1, 'email', 1, 'circulation', 'DUEDGST'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(2, 'phone', 0, 'circulation', 'PREDUE'),
-(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
-(4, 'email', 0, 'reserves',    'HOLD'),
-(4, 'sms',   0, 'reserves',    'HOLD'),
-(4, 'phone', 0, 'reserves',    'HOLD'),
-(5, 'email', 0, 'circulation', 'CHECKIN'),
-(5, 'sms',   0, 'circulation', 'CHECKIN'),
-(6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
diff --git a/installer/data/mysql/fr-CA/obligatoire/sample_notices_message_transports.txt b/installer/data/mysql/fr-CA/obligatoire/sample_notices_message_transports.txt
deleted file mode 100644 (file)
index 66d5c59..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Définit les moyens de transport pour envoyer les notifications et les messages de courtoisies.
diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/message_transport_types.sql b/installer/data/mysql/fr-FR/1-Obligatoire/message_transport_types.sql
deleted file mode 100644 (file)
index 5355973..0000000
+++ /dev/null
@@ -1,7 +0,0 @@
-INSERT INTO message_transport_types
-(message_transport_type)
-values
-('print'),
-('email'),
-('sms'),
-('phone');
diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/message_transport_types.txt b/installer/data/mysql/fr-FR/1-Obligatoire/message_transport_types.txt
deleted file mode 100644 (file)
index 3a8926a..0000000
+++ /dev/null
@@ -1,2 +0,0 @@
-defines default message tranports for email, and sms.
-
diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_attributes.sql b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_attributes.sql
deleted file mode 100644 (file)
index a7a6032..0000000
+++ /dev/null
@@ -1,9 +0,0 @@
-insert into `message_attributes`
-(`message_attribute_id`, message_name, `takes_days`)
-values
-(1, 'Item_Due', 0),
-(2, 'Advance_Notice', 1),
-(4, 'Hold_Filled', 0),
-(5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
-
diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_attributes.txt b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_attributes.txt
deleted file mode 100644 (file)
index c407138..0000000
+++ /dev/null
@@ -1,3 +0,0 @@
-Définit les messages par défaut pour les documents en retard, les notifications et les évènements de la bibliothèque à venir.
-
-
diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.sql b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.sql
deleted file mode 100644 (file)
index 5954baf..0000000
+++ /dev/null
@@ -1,20 +0,0 @@
-insert into `message_transports`
-(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
-values
-(1, 'email', 0, 'circulation', 'DUE'),
-(1, 'email', 1, 'circulation', 'DUEDGST'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(2, 'phone', 0, 'circulation', 'PREDUE'),
-(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
-(4, 'email', 0, 'reserves',    'HOLD'),
-(4, 'sms',   0, 'reserves',    'HOLD'),
-(4, 'phone', 0, 'reserves',    'HOLD'),
-(5, 'email', 0, 'circulation', 'CHECKIN'),
-(5, 'sms',   0, 'circulation', 'CHECKIN'),
-(6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.txt b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.txt
deleted file mode 100644 (file)
index 16c8eb3..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Définit les moyens de transport pour envoyer les messages par email ou SMS.
\ No newline at end of file
diff --git a/installer/data/mysql/it-IT/necessari/message_transport_types.sql b/installer/data/mysql/it-IT/necessari/message_transport_types.sql
deleted file mode 100644 (file)
index eacb8e5..0000000
+++ /dev/null
@@ -1,11 +0,0 @@
-SET FOREIGN_KEY_CHECKS=0;
-
-INSERT INTO message_transport_types
-(message_transport_type)
-values
-('email'),
-('print'),
-('sms'),
-('phone');
-
-SET FOREIGN_KEY_CHECKS=1;
diff --git a/installer/data/mysql/it-IT/necessari/message_transport_types.txt b/installer/data/mysql/it-IT/necessari/message_transport_types.txt
deleted file mode 100644 (file)
index 51f390f..0000000
+++ /dev/null
@@ -1,2 +0,0 @@
-\feffDefinisce come avviene di il trasporto del messaggio, se via
-email, stampa, sms, feed rss.
diff --git a/installer/data/mysql/it-IT/necessari/sample_notices_message_attributes.sql b/installer/data/mysql/it-IT/necessari/sample_notices_message_attributes.sql
deleted file mode 100644 (file)
index 63d07fd..0000000
+++ /dev/null
@@ -1,11 +0,0 @@
-SET FOREIGN_KEY_CHECKS=0;
-
-insert into `message_attributes`
-(`message_attribute_id`, message_name, `takes_days`)
-values
-(1, 'Item_Due', 0),
-(2, 'Advance_Notice', 1),
-(4, 'Hold_Filled', 0),
-(5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
-SET FOREIGN_KEY_CHECKS=1;
diff --git a/installer/data/mysql/it-IT/necessari/sample_notices_message_attributes.txt b/installer/data/mysql/it-IT/necessari/sample_notices_message_attributes.txt
deleted file mode 100644 (file)
index 98d1f4d..0000000
+++ /dev/null
@@ -1,2 +0,0 @@
-Definisce i messaggi di default per le copie scadute, gli avvisi e gli eventi in arrivo.
-
diff --git a/installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql b/installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql
deleted file mode 100644 (file)
index dd6a2d8..0000000
+++ /dev/null
@@ -1,24 +0,0 @@
-SET FOREIGN_KEY_CHECKS=0;
-
-insert into `message_transports`
-(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
-values
-(1, 'email', 0, 'circulation', 'DUE'),
-(1, 'email', 1, 'circulation', 'DUEDGST'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(2, 'phone', 0, 'circulation', 'PREDUE'),
-(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
-(4, 'email', 0, 'reserves',    'HOLD'),
-(4, 'sms',   0, 'reserves',    'HOLD'),
-(4, 'phone', 0, 'reserves',    'HOLD'),
-(5, 'email', 0, 'circulation', 'CHECKIN'),
-(5, 'sms',   0, 'circulation', 'CHECKIN'),
-(6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
-
-SET FOREIGN_KEY_CHECKS=1;
diff --git a/installer/data/mysql/it-IT/necessari/sample_notices_message_transports.txt b/installer/data/mysql/it-IT/necessari/sample_notices_message_transports.txt
deleted file mode 100644 (file)
index e44b6d0..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Definisce i metodi di trasporto di default dei messaggi, via e-mail o SMS.
diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/message_transport_types.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/message_transport_types.sql
deleted file mode 100644 (file)
index 6ff2f66..0000000
+++ /dev/null
@@ -1,28 +0,0 @@
--- 
--- Default classification sources and filing rules
--- for Koha.
---
--- Copyright (C) 2011 Magnus Enger Libriotech
---
--- This file is part of Koha.
---
--- Koha is free software; you can redistribute it and/or modify it under the
--- terms of the GNU General Public License as published by the Free Software
--- Foundation; either version 2 of the License, or (at your option) any later
--- version.
--- 
--- Koha is distributed in the hope that it will be useful, but WITHOUT ANY
--- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
--- A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
--- 
--- You should have received a copy of the GNU General Public License along
--- with Koha; if not, write to the Free Software Foundation, Inc.,
--- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
-
-INSERT INTO message_transport_types
-(message_transport_type)
-values
-('email'),
-('print'),
-('sms'),
-('phone');
diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/message_transport_types.txt b/installer/data/mysql/nb-NO/1-Obligatorisk/message_transport_types.txt
deleted file mode 100644 (file)
index ce8b9fe..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Definerer standard meldingsveier for e-post, brev, nyhetsstrømmer og SMS.
diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_attributes.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_attributes.sql
deleted file mode 100644 (file)
index a7a6032..0000000
+++ /dev/null
@@ -1,9 +0,0 @@
-insert into `message_attributes`
-(`message_attribute_id`, message_name, `takes_days`)
-values
-(1, 'Item_Due', 0),
-(2, 'Advance_Notice', 1),
-(4, 'Hold_Filled', 0),
-(5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
-
diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_attributes.txt b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_attributes.txt
deleted file mode 100644 (file)
index 14d7109..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Definerer standard meldinger for purringer og varslinger. 
diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.sql
deleted file mode 100644 (file)
index 5954baf..0000000
+++ /dev/null
@@ -1,20 +0,0 @@
-insert into `message_transports`
-(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
-values
-(1, 'email', 0, 'circulation', 'DUE'),
-(1, 'email', 1, 'circulation', 'DUEDGST'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(2, 'phone', 0, 'circulation', 'PREDUE'),
-(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
-(4, 'email', 0, 'reserves',    'HOLD'),
-(4, 'sms',   0, 'reserves',    'HOLD'),
-(4, 'phone', 0, 'reserves',    'HOLD'),
-(5, 'email', 0, 'circulation', 'CHECKIN'),
-(5, 'sms',   0, 'circulation', 'CHECKIN'),
-(6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.txt b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.txt
deleted file mode 100644 (file)
index 25e6780..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Definerer standard meldingsmåter for utsending av purringer og varslinger, via SMS og E-post. 
diff --git a/installer/data/mysql/pl-PL/mandatory/message_transport_types.sql b/installer/data/mysql/pl-PL/mandatory/message_transport_types.sql
deleted file mode 100644 (file)
index ed3c4ad..0000000
+++ /dev/null
@@ -1,7 +0,0 @@
-INSERT INTO message_transport_types
-(message_transport_type)
-values
-('email'),
-('print'),
-('sms'),
-('phone');
diff --git a/installer/data/mysql/pl-PL/mandatory/message_transport_types.txt b/installer/data/mysql/pl-PL/mandatory/message_transport_types.txt
deleted file mode 100644 (file)
index b74c092..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Określa domyślne typy transportu wiadomości.
diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices_message_attributes.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices_message_attributes.sql
deleted file mode 100644 (file)
index a7a6032..0000000
+++ /dev/null
@@ -1,9 +0,0 @@
-insert into `message_attributes`
-(`message_attribute_id`, message_name, `takes_days`)
-values
-(1, 'Item_Due', 0),
-(2, 'Advance_Notice', 1),
-(4, 'Hold_Filled', 0),
-(5, 'Item_Check_in', 0),
-(6, 'Item_Checkout', 0);
-
diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices_message_attributes.txt b/installer/data/mysql/pl-PL/mandatory/sample_notices_message_attributes.txt
deleted file mode 100644 (file)
index 621cf14..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Określa domyślne typy powiadomień o wypożyczeniach, zwrotach, przetrzymaniach i nadchodzących wydarzeniach.
diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.sql
deleted file mode 100644 (file)
index 5954baf..0000000
+++ /dev/null
@@ -1,20 +0,0 @@
-insert into `message_transports`
-(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
-values
-(1, 'email', 0, 'circulation', 'DUE'),
-(1, 'email', 1, 'circulation', 'DUEDGST'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(2, 'phone', 0, 'circulation', 'PREDUE'),
-(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
-(4, 'email', 0, 'reserves',    'HOLD'),
-(4, 'sms',   0, 'reserves',    'HOLD'),
-(4, 'phone', 0, 'reserves',    'HOLD'),
-(5, 'email', 0, 'circulation', 'CHECKIN'),
-(5, 'sms',   0, 'circulation', 'CHECKIN'),
-(6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.txt b/installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.txt
deleted file mode 100644 (file)
index 74e960e..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Określa domyślne transporty wiadomości o przetrzymaniach, zaawansowanych powiadomień i informacji o wydarzeniach dla emaila i sms.
diff --git a/installer/data/mysql/ru-RU/mandatory/message_transport_types.sql b/installer/data/mysql/ru-RU/mandatory/message_transport_types.sql
deleted file mode 100644 (file)
index a789904..0000000
+++ /dev/null
@@ -1,9 +0,0 @@
-TRUNCATE message_transport_types;
-
-INSERT INTO message_transport_types
-(message_transport_type)
-values
-('email'),
-('print'),
-('sms'),
-('phone');
diff --git a/installer/data/mysql/ru-RU/mandatory/message_transport_types.txt b/installer/data/mysql/ru-RU/mandatory/message_transport_types.txt
deleted file mode 100644 (file)
index 89dc5ed..0000000
+++ /dev/null
@@ -1,2 +0,0 @@
-Определяет типовые способы сообщений с помощью электронной почты и SMS.
-
diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices_message_attributes.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices_message_attributes.sql
deleted file mode 100644 (file)
index 94c7897..0000000
+++ /dev/null
@@ -1,11 +0,0 @@
-truncate message_attributes;
-
-insert into `message_attributes`
-(`message_attribute_id`, message_name, `takes_days`)
-values
-(1, 'Item_Due',                    0),
-(2, 'Advance_Notice',              1),
-(4, 'Hold_Filled',                 0),
-(5, 'Item_Check_in',               0),
-(6, 'Item_Checkout',               0);
-
diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices_message_attributes.txt b/installer/data/mysql/ru-RU/mandatory/sample_notices_message_attributes.txt
deleted file mode 100644 (file)
index 755aced..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Определения сообщений по умолчанию для задолженных экземпляров, заблаговременных уведомлений и будущих библиотечных событий.
diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.sql
deleted file mode 100644 (file)
index 5954baf..0000000
+++ /dev/null
@@ -1,20 +0,0 @@
-insert into `message_transports`
-(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
-values
-(1, 'email', 0, 'circulation', 'DUE'),
-(1, 'email', 1, 'circulation', 'DUEDGST'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(2, 'phone', 0, 'circulation', 'PREDUE'),
-(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
-(4, 'email', 0, 'reserves',    'HOLD'),
-(4, 'sms',   0, 'reserves',    'HOLD'),
-(4, 'phone', 0, 'reserves',    'HOLD'),
-(5, 'email', 0, 'circulation', 'CHECKIN'),
-(5, 'sms',   0, 'circulation', 'CHECKIN'),
-(6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.txt b/installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.txt
deleted file mode 100644 (file)
index b8d556d..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Определение типовых собщальных транспортов для сообщений об задолженности экземпляров, заблаговременных уведомлений а также сообщений о библиотечных мероприятиях с помощью электронной почты и SMS.
diff --git a/installer/data/mysql/uk-UA/mandatory/message_transport_types.sql b/installer/data/mysql/uk-UA/mandatory/message_transport_types.sql
deleted file mode 100644 (file)
index f79325c..0000000
+++ /dev/null
@@ -1,9 +0,0 @@
--- TRUNCATE message_transport_types;
-
-INSERT INTO message_transport_types
-(message_transport_type)
-values
-('email'),
-('print'),
-('sms'),
-('phone');
diff --git a/installer/data/mysql/uk-UA/mandatory/message_transport_types.txt b/installer/data/mysql/uk-UA/mandatory/message_transport_types.txt
deleted file mode 100644 (file)
index fc3169e..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Означення типових способів повідомлень з допомогою електронної пошти та SMS.
diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices_message_attributes.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices_message_attributes.sql
deleted file mode 100644 (file)
index df987b5..0000000
+++ /dev/null
@@ -1,15 +0,0 @@
--- truncate message_attributes;
-
-insert into message_attributes
- (message_attribute_id, message_name,     takes_days) values
- (1,                    'Item_Due'      , 0),
- (2,                    'Advance_Notice', 1),
- (4,                    'Hold_Filled'   , 0),
- (5,                    'Item_Check_in' , 0),
- (6,                    'Item_Checkout' , 0);
--- Наразі не перекладено (за прикладом інших мовних файлів)
--- (1, 'Одиниця заборгована'   , 0),
--- (2, 'Завчасне повідомлення',  1),
--- (4, 'Резервування виконано' , 0),
--- (5, 'Повернення примірника',  0),
--- (6, 'Видача примірника'     , 0);
diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices_message_attributes.txt b/installer/data/mysql/uk-UA/mandatory/sample_notices_message_attributes.txt
deleted file mode 100644 (file)
index 3d6d349..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Означення повідомлень по умовчанню для заборгованих примірників, завчасних увідомлень та майбутніх бібліотечних подій.
\ No newline at end of file
diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.sql
deleted file mode 100644 (file)
index 5954baf..0000000
+++ /dev/null
@@ -1,20 +0,0 @@
-insert into `message_transports`
-(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
-values
-(1, 'email', 0, 'circulation', 'DUE'),
-(1, 'email', 1, 'circulation', 'DUEDGST'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(2, 'phone', 0, 'circulation', 'PREDUE'),
-(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
-(4, 'email', 0, 'reserves',    'HOLD'),
-(4, 'sms',   0, 'reserves',    'HOLD'),
-(4, 'phone', 0, 'reserves',    'HOLD'),
-(5, 'email', 0, 'circulation', 'CHECKIN'),
-(5, 'sms',   0, 'circulation', 'CHECKIN'),
-(6, 'email', 0, 'circulation', 'CHECKOUT'),
-(6, 'sms',   0, 'circulation', 'CHECKOUT');
diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.txt b/installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.txt
deleted file mode 100644 (file)
index 6a005b0..0000000
+++ /dev/null
@@ -1 +0,0 @@
-Означення типових повідомляльних транспортів для повідомлень про заборговані примірники, завчасних увідомлень а також повідомлення про бібліотечні події з допомогою електронної пошти та SMS.