[Koha-patches] =?y?q?=5BPATCH=5D=20Bug=207022=3A=20Move=20sample=5Fnotices*=20sql=20files=20from=20optional=20to=20mandatory?=

Thu Oct 13 23:00:27 CEST 2011

Sending messages  will not work correctly without correct data in sample_notice_message_transports
and sample_notice_message_attributes tables. There is no way to configure those tables in Koha.
SQL files should be in the mandatory part of the web installer.
---
 .../sample_notices_message_attributes.sql          |    8 ++++++++
 .../sample_notices_message_attributes.txt          |    1 +
 .../sample_notices_message_transports.sql          |   17 +++++++++++++++++
 .../sample_notices_message_transports.txt          |    2 ++
 .../optional/sample_notices_message_attributes.sql |    8 --------
 .../optional/sample_notices_message_attributes.txt |    1 -
 .../optional/sample_notices_message_transports.sql |   17 -----------------
 .../optional/sample_notices_message_transports.txt |    2 --
 .../sample_notices_message_attributes.sql          |    9 +++++++++
 .../sample_notices_message_attributes.txt          |    2 ++
 .../sample_notices_message_transports.sql          |   17 +++++++++++++++++
 .../sample_notices_message_transports.txt          |    3 +++
 .../optional/sample_notices_message_attributes.sql |    9 ---------
 .../optional/sample_notices_message_attributes.txt |    2 --
 .../optional/sample_notices_message_transports.sql |   17 -----------------
 .../optional/sample_notices_message_transports.txt |    3 ---
 .../sample_notices_message_attributes.sql          |    9 +++++++++
 .../sample_notices_message_attributes.txt          |    1 +
 .../sample_notices_message_transports.sql          |   17 +++++++++++++++++
 .../sample_notices_message_transports.txt          |    2 ++
 .../optional/sample_notices_message_attributes.sql |    9 ---------
 .../optional/sample_notices_message_attributes.txt |    1 -
 .../optional/sample_notices_message_transports.sql |   17 -----------------
 .../optional/sample_notices_message_transports.txt |    2 --
 .../sample_notices_message_attributes.sql          |    9 +++++++++
 .../sample_notices_message_attributes.txt          |    3 +++
 .../sample_notices_message_transports.sql          |   17 +++++++++++++++++
 .../sample_notices_message_transports.txt          |    1 +
 .../sample_notices_message_attributes.sql          |    9 ---------
 .../sample_notices_message_attributes.txt          |    3 ---
 .../sample_notices_message_transports.sql          |   17 -----------------
 .../sample_notices_message_transports.txt          |    1 -
 .../sample_notices_message_attributes.sql          |    9 +++++++++
 .../sample_notices_message_attributes.txt          |    1 +
 .../sample_notices_message_transports.sql          |   17 +++++++++++++++++
 .../sample_notices_message_transports.txt          |    1 +
 .../sample_notices_message_attributes.sql          |    9 ---------
 .../sample_notices_message_attributes.txt          |    1 -
 .../sample_notices_message_transports.sql          |   17 -----------------
 .../sample_notices_message_transports.txt          |    1 -
 .../sample_notices_message_attributes.sql          |    9 +++++++++
 .../sample_notices_message_attributes.txt          |    1 +
 .../sample_notices_message_transports.sql          |   17 +++++++++++++++++
 .../sample_notices_message_transports.txt          |    1 +
 .../optional/sample_notices_message_attributes.sql |    9 ---------
 .../optional/sample_notices_message_attributes.txt |    1 -
 .../optional/sample_notices_message_transports.sql |   17 -----------------
 .../optional/sample_notices_message_transports.txt |    1 -
 .../sample_notices_message_attributes.sql          |   11 +++++++++++
 .../sample_notices_message_attributes.txt          |    1 +
 .../sample_notices_message_transports.sql          |   18 ++++++++++++++++++
 .../sample_notices_message_transports.txt          |    1 +
 .../optional/sample_notices_message_attributes.sql |   11 -----------
 .../optional/sample_notices_message_attributes.txt |    1 -
 .../optional/sample_notices_message_transports.sql |   18 ------------------
 .../optional/sample_notices_message_transports.txt |    1 -
 .../sample_notices_message_attributes.sql          |   11 +++++++++++
 .../sample_notices_message_attributes.txt          |    1 +
 .../sample_notices_message_transports.sql          |   18 ++++++++++++++++++
 .../sample_notices_message_transports.txt          |    1 +
 .../optional/sample_notices_message_attributes.sql |   11 -----------
 .../optional/sample_notices_message_attributes.txt |    1 -
 .../optional/sample_notices_message_transports.sql |   18 ------------------
 .../optional/sample_notices_message_transports.txt |    1 -
 64 files changed, 236 insertions(+), 236 deletions(-)
 create mode 100644 installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql
 create mode 100644 installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.txt
 create mode 100644 installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql
 create mode 100644 installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.txt
 delete mode 100644 installer/data/mysql/de-DE/optional/sample_notices_message_attributes.sql
 delete mode 100644 installer/data/mysql/de-DE/optional/sample_notices_message_attributes.txt
 delete mode 100644 installer/data/mysql/de-DE/optional/sample_notices_message_transports.sql
 delete mode 100644 installer/data/mysql/de-DE/optional/sample_notices_message_transports.txt
 create mode 100644 installer/data/mysql/en/mandatory/sample_notices_message_attributes.sql
 create mode 100644 installer/data/mysql/en/mandatory/sample_notices_message_attributes.txt
 create mode 100644 installer/data/mysql/en/mandatory/sample_notices_message_transports.sql
 create mode 100644 installer/data/mysql/en/mandatory/sample_notices_message_transports.txt
 delete mode 100644 installer/data/mysql/en/optional/sample_notices_message_attributes.sql
 delete mode 100644 installer/data/mysql/en/optional/sample_notices_message_attributes.txt
 delete mode 100644 installer/data/mysql/en/optional/sample_notices_message_transports.sql
 delete mode 100644 installer/data/mysql/en/optional/sample_notices_message_transports.txt
 create mode 100644 installer/data/mysql/es-ES/mandatory/sample_notices_message_attributes.sql
 create mode 100644 installer/data/mysql/es-ES/mandatory/sample_notices_message_attributes.txt
 create mode 100644 installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.sql
 create mode 100644 installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.txt
 delete mode 100644 installer/data/mysql/es-ES/optional/sample_notices_message_attributes.sql
 delete mode 100644 installer/data/mysql/es-ES/optional/sample_notices_message_attributes.txt
 delete mode 100644 installer/data/mysql/es-ES/optional/sample_notices_message_transports.sql
 delete mode 100644 installer/data/mysql/es-ES/optional/sample_notices_message_transports.txt
 create mode 100644 installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_attributes.sql
 create mode 100644 installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_attributes.txt
 create mode 100644 installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.sql
 create mode 100644 installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.txt
 delete mode 100644 installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql
 delete mode 100644 installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.txt
 delete mode 100644 installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql
 delete mode 100644 installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.txt
 create mode 100644 installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_attributes.sql
 create mode 100644 installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_attributes.txt
 create mode 100644 installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.sql
 create mode 100644 installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.txt
 delete mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.sql
 delete mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.txt
 delete mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.sql
 delete mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.txt
 create mode 100644 installer/data/mysql/pl-PL/mandatory/sample_notices_message_attributes.sql
 create mode 100644 installer/data/mysql/pl-PL/mandatory/sample_notices_message_attributes.txt
 create mode 100644 installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.sql
 create mode 100644 installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.txt
 delete mode 100644 installer/data/mysql/pl-PL/optional/sample_notices_message_attributes.sql
 delete mode 100644 installer/data/mysql/pl-PL/optional/sample_notices_message_attributes.txt
 delete mode 100644 installer/data/mysql/pl-PL/optional/sample_notices_message_transports.sql
 delete mode 100644 installer/data/mysql/pl-PL/optional/sample_notices_message_transports.txt
 create mode 100644 installer/data/mysql/ru-RU/mandatory/sample_notices_message_attributes.sql
 create mode 100644 installer/data/mysql/ru-RU/mandatory/sample_notices_message_attributes.txt
 create mode 100644 installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.sql
 create mode 100644 installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.txt
 delete mode 100644 installer/data/mysql/ru-RU/optional/sample_notices_message_attributes.sql
 delete mode 100644 installer/data/mysql/ru-RU/optional/sample_notices_message_attributes.txt
 delete mode 100644 installer/data/mysql/ru-RU/optional/sample_notices_message_transports.sql
 delete mode 100644 installer/data/mysql/ru-RU/optional/sample_notices_message_transports.txt
 create mode 100644 installer/data/mysql/uk-UA/mandatory/sample_notices_message_attributes.sql
 create mode 100644 installer/data/mysql/uk-UA/mandatory/sample_notices_message_attributes.txt
 create mode 100644 installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.sql
 create mode 100644 installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.txt
 delete mode 100644 installer/data/mysql/uk-UA/optional/sample_notices_message_attributes.sql
 delete mode 100644 installer/data/mysql/uk-UA/optional/sample_notices_message_attributes.txt
 delete mode 100644 installer/data/mysql/uk-UA/optional/sample_notices_message_transports.sql
 delete mode 100644 installer/data/mysql/uk-UA/optional/sample_notices_message_transports.txt

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
new file mode 100644
index 0000000..b505486
--- /dev/null
+++ b/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql
@@ -0,0 +1,8 @@
+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
new file mode 100644
index 0000000..3c538e0
--- /dev/null
+++ b/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.txt
@@ -0,0 +1 @@
+Definiert Benachrichtigungsoptionen fÃ¼r FÃ¤lligkeits-, Erinnerungs- und Vormerkbenachrichtigungen, sowie Veranstaltungshinweise.
diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql
new file mode 100644
index 0000000..ae68378
--- /dev/null
+++ b/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql
@@ -0,0 +1,17 @@
+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'),
+(2, 'email', 0, 'circulation', 'PREDUE'),
+(2, 'email', 1, 'circulation', 'PREDUEDGST'),
+(4, 'email', 0, 'reserves',    'HOLD'),
+(1, 'sms',   0, 'circulation', 'DUE'),
+(1, 'sms',   1, 'circulation', 'DUEDGST'),
+(2, 'sms',   0, 'circulation', 'PREDUE'),
+(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
+(4, 'sms',   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/de-DE/mandatory/sample_notices_message_transports.txt b/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.txt
new file mode 100644
index 0000000..5587a74
--- /dev/null
+++ b/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.txt
@@ -0,0 +1,2 @@
+Definiert Versandarten fÃ¼r u.a. FÃ¤lligkeits-,
+Erinnerungs- und Vormerkbenachrichtigungen per Email und SMS.
\ No newline at end of file
diff --git a/installer/data/mysql/de-DE/optional/sample_notices_message_attributes.sql b/installer/data/mysql/de-DE/optional/sample_notices_message_attributes.sql
deleted file mode 100644
index b505486..0000000
--- a/installer/data/mysql/de-DE/optional/sample_notices_message_attributes.sql
+++ /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/optional/sample_notices_message_attributes.txt b/installer/data/mysql/de-DE/optional/sample_notices_message_attributes.txt
deleted file mode 100644
index 3c538e0..0000000
--- a/installer/data/mysql/de-DE/optional/sample_notices_message_attributes.txt
+++ /dev/null
@@ -1 +0,0 @@
-Definiert Benachrichtigungsoptionen fÃ¼r FÃ¤lligkeits-, Erinnerungs- und Vormerkbenachrichtigungen, sowie Veranstaltungshinweise.
diff --git a/installer/data/mysql/de-DE/optional/sample_notices_message_transports.sql b/installer/data/mysql/de-DE/optional/sample_notices_message_transports.sql
deleted file mode 100644
index ae68378..0000000
--- a/installer/data/mysql/de-DE/optional/sample_notices_message_transports.sql
+++ /dev/null
@@ -1,17 +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'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(4, 'email', 0, 'reserves',    'HOLD'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(4, 'sms',   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/de-DE/optional/sample_notices_message_transports.txt b/installer/data/mysql/de-DE/optional/sample_notices_message_transports.txt
deleted file mode 100644
index 5587a74..0000000
--- a/installer/data/mysql/de-DE/optional/sample_notices_message_transports.txt
+++ /dev/null
@@ -1,2 +0,0 @@
-Definiert Versandarten fÃ¼r u.a. FÃ¤lligkeits-,
-Erinnerungs- und Vormerkbenachrichtigungen per Email und SMS.
\ No newline at end of file
diff --git a/installer/data/mysql/en/mandatory/sample_notices_message_attributes.sql b/installer/data/mysql/en/mandatory/sample_notices_message_attributes.sql
new file mode 100644
index 0000000..a7a6032
--- /dev/null
+++ b/installer/data/mysql/en/mandatory/sample_notices_message_attributes.sql
@@ -0,0 +1,9 @@
+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/en/mandatory/sample_notices_message_attributes.txt b/installer/data/mysql/en/mandatory/sample_notices_message_attributes.txt
new file mode 100644
index 0000000..770bcac
--- /dev/null
+++ b/installer/data/mysql/en/mandatory/sample_notices_message_attributes.txt
@@ -0,0 +1,2 @@
+defines default messages for items due, advance notices, and upcoming library events.
+
diff --git a/installer/data/mysql/en/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/en/mandatory/sample_notices_message_transports.sql
new file mode 100644
index 0000000..ae68378
--- /dev/null
+++ b/installer/data/mysql/en/mandatory/sample_notices_message_transports.sql
@@ -0,0 +1,17 @@
+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'),
+(2, 'email', 0, 'circulation', 'PREDUE'),
+(2, 'email', 1, 'circulation', 'PREDUEDGST'),
+(4, 'email', 0, 'reserves',    'HOLD'),
+(1, 'sms',   0, 'circulation', 'DUE'),
+(1, 'sms',   1, 'circulation', 'DUEDGST'),
+(2, 'sms',   0, 'circulation', 'PREDUE'),
+(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
+(4, 'sms',   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/en/mandatory/sample_notices_message_transports.txt b/installer/data/mysql/en/mandatory/sample_notices_message_transports.txt
new file mode 100644
index 0000000..18e3431
--- /dev/null
+++ b/installer/data/mysql/en/mandatory/sample_notices_message_transports.txt
@@ -0,0 +1,3 @@
+Defines default message transports for sending item due messages,
+advance notice messages, and library event messages through email
+and SMS.
diff --git a/installer/data/mysql/en/optional/sample_notices_message_attributes.sql b/installer/data/mysql/en/optional/sample_notices_message_attributes.sql
deleted file mode 100644
index a7a6032..0000000
--- a/installer/data/mysql/en/optional/sample_notices_message_attributes.sql
+++ /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/en/optional/sample_notices_message_attributes.txt b/installer/data/mysql/en/optional/sample_notices_message_attributes.txt
deleted file mode 100644
index 770bcac..0000000
--- a/installer/data/mysql/en/optional/sample_notices_message_attributes.txt
+++ /dev/null
@@ -1,2 +0,0 @@
-defines default messages for items due, advance notices, and upcoming library events.
-
diff --git a/installer/data/mysql/en/optional/sample_notices_message_transports.sql b/installer/data/mysql/en/optional/sample_notices_message_transports.sql
deleted file mode 100644
index ae68378..0000000
--- a/installer/data/mysql/en/optional/sample_notices_message_transports.sql
+++ /dev/null
@@ -1,17 +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'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(4, 'email', 0, 'reserves',    'HOLD'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(4, 'sms',   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/en/optional/sample_notices_message_transports.txt b/installer/data/mysql/en/optional/sample_notices_message_transports.txt
deleted file mode 100644
index 18e3431..0000000
--- a/installer/data/mysql/en/optional/sample_notices_message_transports.txt
+++ /dev/null
@@ -1,3 +0,0 @@
-Defines default message transports for sending item due messages,
-advance notice messages, and library event messages through email
-and SMS.
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
new file mode 100644
index 0000000..a7a6032
--- /dev/null
+++ b/installer/data/mysql/es-ES/mandatory/sample_notices_message_attributes.sql
@@ -0,0 +1,9 @@
+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
new file mode 100644
index 0000000..aacf285
--- /dev/null
+++ b/installer/data/mysql/es-ES/mandatory/sample_notices_message_attributes.txt
@@ -0,0 +1 @@
+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
new file mode 100644
index 0000000..ae68378
--- /dev/null
+++ b/installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.sql
@@ -0,0 +1,17 @@
+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'),
+(2, 'email', 0, 'circulation', 'PREDUE'),
+(2, 'email', 1, 'circulation', 'PREDUEDGST'),
+(4, 'email', 0, 'reserves',    'HOLD'),
+(1, 'sms',   0, 'circulation', 'DUE'),
+(1, 'sms',   1, 'circulation', 'DUEDGST'),
+(2, 'sms',   0, 'circulation', 'PREDUE'),
+(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
+(4, 'sms',   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
new file mode 100644
index 0000000..4f5143c
--- /dev/null
+++ b/installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.txt
@@ -0,0 +1,2 @@
+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/es-ES/optional/sample_notices_message_attributes.sql b/installer/data/mysql/es-ES/optional/sample_notices_message_attributes.sql
deleted file mode 100644
index a7a6032..0000000
--- a/installer/data/mysql/es-ES/optional/sample_notices_message_attributes.sql
+++ /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/optional/sample_notices_message_attributes.txt b/installer/data/mysql/es-ES/optional/sample_notices_message_attributes.txt
deleted file mode 100644
index aacf285..0000000
--- a/installer/data/mysql/es-ES/optional/sample_notices_message_attributes.txt
+++ /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/optional/sample_notices_message_transports.sql b/installer/data/mysql/es-ES/optional/sample_notices_message_transports.sql
deleted file mode 100644
index ae68378..0000000
--- a/installer/data/mysql/es-ES/optional/sample_notices_message_transports.sql
+++ /dev/null
@@ -1,17 +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'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(4, 'email', 0, 'reserves',    'HOLD'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(4, 'sms',   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/optional/sample_notices_message_transports.txt b/installer/data/mysql/es-ES/optional/sample_notices_message_transports.txt
deleted file mode 100644
index 4f5143c..0000000
--- a/installer/data/mysql/es-ES/optional/sample_notices_message_transports.txt
+++ /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-FR/1-Obligatoire/sample_notices_message_attributes.sql b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_attributes.sql
new file mode 100644
index 0000000..8e919e9
--- /dev/null
+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_attributes.sql
@@ -0,0 +1,9 @@
+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
new file mode 100644
index 0000000..c407138
--- /dev/null
+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_attributes.txt
@@ -0,0 +1,3 @@
+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
new file mode 100644
index 0000000..ae68378
--- /dev/null
+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.sql
@@ -0,0 +1,17 @@
+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'),
+(2, 'email', 0, 'circulation', 'PREDUE'),
+(2, 'email', 1, 'circulation', 'PREDUEDGST'),
+(4, 'email', 0, 'reserves',    'HOLD'),
+(1, 'sms',   0, 'circulation', 'DUE'),
+(1, 'sms',   1, 'circulation', 'DUEDGST'),
+(2, 'sms',   0, 'circulation', 'PREDUE'),
+(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
+(4, 'sms',   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
new file mode 100644
index 0000000..16c8eb3
--- /dev/null
+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.txt
@@ -0,0 +1 @@
+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/fr-FR/2-Optionel/sample_notices_message_attributes.sql b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql
deleted file mode 100644
index 8e919e9..0000000
--- a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql
+++ /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/2-Optionel/sample_notices_message_attributes.txt b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.txt
deleted file mode 100644
index c407138..0000000
--- a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.txt
+++ /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/2-Optionel/sample_notices_message_transports.sql b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql
deleted file mode 100644
index ae68378..0000000
--- a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql
+++ /dev/null
@@ -1,17 +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'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(4, 'email', 0, 'reserves',    'HOLD'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(4, 'sms',   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/2-Optionel/sample_notices_message_transports.txt b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.txt
deleted file mode 100644
index 16c8eb3..0000000
--- a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.txt
+++ /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/nb-NO/1-Obligatorisk/sample_notices_message_attributes.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_attributes.sql
new file mode 100644
index 0000000..a7a6032
--- /dev/null
+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_attributes.sql
@@ -0,0 +1,9 @@
+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
new file mode 100644
index 0000000..14d7109
--- /dev/null
+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_attributes.txt
@@ -0,0 +1 @@
+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
new file mode 100644
index 0000000..ae68378
--- /dev/null
+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.sql
@@ -0,0 +1,17 @@
+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'),
+(2, 'email', 0, 'circulation', 'PREDUE'),
+(2, 'email', 1, 'circulation', 'PREDUEDGST'),
+(4, 'email', 0, 'reserves',    'HOLD'),
+(1, 'sms',   0, 'circulation', 'DUE'),
+(1, 'sms',   1, 'circulation', 'DUEDGST'),
+(2, 'sms',   0, 'circulation', 'PREDUE'),
+(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
+(4, 'sms',   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
new file mode 100644
index 0000000..25e6780
--- /dev/null
+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.txt
@@ -0,0 +1 @@
+Definerer standard meldingsmÃ¥ter for utsending av purringer og varslinger, via SMS og E-post. 
diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.sql
deleted file mode 100644
index a7a6032..0000000
--- a/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.sql
+++ /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/2-Valgfritt/sample_notices_message_attributes.txt b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.txt
deleted file mode 100644
index 14d7109..0000000
--- a/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.txt
+++ /dev/null
@@ -1 +0,0 @@
-Definerer standard meldinger for purringer og varslinger. 
diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.sql
deleted file mode 100644
index ae68378..0000000
--- a/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.sql
+++ /dev/null
@@ -1,17 +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'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(4, 'email', 0, 'reserves',    'HOLD'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(4, 'sms',   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/2-Valgfritt/sample_notices_message_transports.txt b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.txt
deleted file mode 100644
index 25e6780..0000000
--- a/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.txt
+++ /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/sample_notices_message_attributes.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices_message_attributes.sql
new file mode 100644
index 0000000..8e919e9
--- /dev/null
+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices_message_attributes.sql
@@ -0,0 +1,9 @@
+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
new file mode 100644
index 0000000..621cf14
--- /dev/null
+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices_message_attributes.txt
@@ -0,0 +1 @@
+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
new file mode 100644
index 0000000..ae68378
--- /dev/null
+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.sql
@@ -0,0 +1,17 @@
+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'),
+(2, 'email', 0, 'circulation', 'PREDUE'),
+(2, 'email', 1, 'circulation', 'PREDUEDGST'),
+(4, 'email', 0, 'reserves',    'HOLD'),
+(1, 'sms',   0, 'circulation', 'DUE'),
+(1, 'sms',   1, 'circulation', 'DUEDGST'),
+(2, 'sms',   0, 'circulation', 'PREDUE'),
+(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
+(4, 'sms',   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
new file mode 100644
index 0000000..74e960e
--- /dev/null
+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.txt
@@ -0,0 +1 @@
+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/pl-PL/optional/sample_notices_message_attributes.sql b/installer/data/mysql/pl-PL/optional/sample_notices_message_attributes.sql
deleted file mode 100644
index 8e919e9..0000000
--- a/installer/data/mysql/pl-PL/optional/sample_notices_message_attributes.sql
+++ /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/optional/sample_notices_message_attributes.txt b/installer/data/mysql/pl-PL/optional/sample_notices_message_attributes.txt
deleted file mode 100644
index 621cf14..0000000
--- a/installer/data/mysql/pl-PL/optional/sample_notices_message_attributes.txt
+++ /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/optional/sample_notices_message_transports.sql b/installer/data/mysql/pl-PL/optional/sample_notices_message_transports.sql
deleted file mode 100644
index ae68378..0000000
--- a/installer/data/mysql/pl-PL/optional/sample_notices_message_transports.sql
+++ /dev/null
@@ -1,17 +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'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(4, 'email', 0, 'reserves',    'HOLD'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(4, 'sms',   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/optional/sample_notices_message_transports.txt b/installer/data/mysql/pl-PL/optional/sample_notices_message_transports.txt
deleted file mode 100644
index 74e960e..0000000
--- a/installer/data/mysql/pl-PL/optional/sample_notices_message_transports.txt
+++ /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/sample_notices_message_attributes.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices_message_attributes.sql
new file mode 100644
index 0000000..c9d9bd1
--- /dev/null
+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices_message_attributes.sql
@@ -0,0 +1,11 @@
+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
new file mode 100644
index 0000000..755aced
--- /dev/null
+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices_message_attributes.txt
@@ -0,0 +1 @@
+ÐžÐ¿Ñ€ÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ ÑÐ¾Ð¾Ð±Ñ‰ÐµÐ½Ð¸Ð¹ Ð¿Ð¾ ÑƒÐ¼Ð¾Ð»Ñ‡Ð°Ð½Ð¸ÑŽ Ð´Ð»Ñ Ð·Ð°Ð´Ð¾Ð»Ð¶ÐµÐ½Ð½Ñ‹Ñ… ÑÐºÐ·ÐµÐ¼Ð¿Ð»ÑÑ€Ð¾Ð², Ð·Ð°Ð±Ð»Ð°Ð³Ð¾Ð²Ñ€ÐµÐ¼ÐµÐ½Ð½Ñ‹Ñ… ÑƒÐ²ÐµÐ´Ð¾Ð¼Ð»ÐµÐ½Ð¸Ð¹ Ð¸ Ð±ÑƒÐ´ÑƒÑ‰Ð¸Ñ… Ð±Ð¸Ð±Ð»Ð¸Ð¾Ñ‚ÐµÑ‡Ð½Ñ‹Ñ… ÑÐ¾Ð±Ñ‹Ñ‚Ð¸Ð¹.
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
new file mode 100644
index 0000000..ade4d03
--- /dev/null
+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.sql
@@ -0,0 +1,18 @@
+truncate message_transports;
+
+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'),
+(2, 'email', 0, 'circulation', 'PREDUE'),
+(2, 'email', 1, 'circulation', 'PREDUEDGST'),
+(1, 'sms',   0, 'circulation', 'DUE'),
+(1, 'sms',   1, 'circulation', 'DUEDGST'),
+(2, 'sms',   0, 'circulation', 'PREDUE'),
+(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
+(4, 'sms',   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
new file mode 100644
index 0000000..b8d556d
--- /dev/null
+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.txt
@@ -0,0 +1 @@
+ÐžÐ¿Ñ€ÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ðµ Ñ‚Ð¸Ð¿Ð¾Ð²Ñ‹Ñ… ÑÐ¾Ð±Ñ‰Ð°Ð»ÑŒÐ½Ñ‹Ñ… Ñ‚Ñ€Ð°Ð½ÑÐ¿Ð¾Ñ€Ñ‚Ð¾Ð² Ð´Ð»Ñ ÑÐ¾Ð¾Ð±Ñ‰ÐµÐ½Ð¸Ð¹ Ð¾Ð± Ð·Ð°Ð´Ð¾Ð»Ð¶ÐµÐ½Ð½Ð¾ÑÑ‚Ð¸ ÑÐºÐ·ÐµÐ¼Ð¿Ð»ÑÑ€Ð¾Ð², Ð·Ð°Ð±Ð»Ð°Ð³Ð¾Ð²Ñ€ÐµÐ¼ÐµÐ½Ð½Ñ‹Ñ… ÑƒÐ²ÐµÐ´Ð¾Ð¼Ð»ÐµÐ½Ð¸Ð¹ Ð° Ñ‚Ð°ÐºÐ¶Ðµ ÑÐ¾Ð¾Ð±Ñ‰ÐµÐ½Ð¸Ð¹ Ð¾ Ð±Ð¸Ð±Ð»Ð¸Ð¾Ñ‚ÐµÑ‡Ð½Ñ‹Ñ… Ð¼ÐµÑ€Ð¾Ð¿Ñ€Ð¸ÑÑ‚Ð¸ÑÑ… Ñ Ð¿Ð¾Ð¼Ð¾Ñ‰ÑŒÑŽ ÑÐ»ÐµÐºÑ‚Ñ€Ð¾Ð½Ð½Ð¾Ð¹ Ð¿Ð¾Ñ‡Ñ‚Ñ‹ Ð¸ SMS.
diff --git a/installer/data/mysql/ru-RU/optional/sample_notices_message_attributes.sql b/installer/data/mysql/ru-RU/optional/sample_notices_message_attributes.sql
deleted file mode 100644
index c9d9bd1..0000000
--- a/installer/data/mysql/ru-RU/optional/sample_notices_message_attributes.sql
+++ /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/optional/sample_notices_message_attributes.txt b/installer/data/mysql/ru-RU/optional/sample_notices_message_attributes.txt
deleted file mode 100644
index 755aced..0000000
--- a/installer/data/mysql/ru-RU/optional/sample_notices_message_attributes.txt
+++ /dev/null
@@ -1 +0,0 @@
-ÐžÐ¿Ñ€ÐµÐ´ÐµÐ»ÐµÐ½Ð¸Ñ ÑÐ¾Ð¾Ð±Ñ‰ÐµÐ½Ð¸Ð¹ Ð¿Ð¾ ÑƒÐ¼Ð¾Ð»Ñ‡Ð°Ð½Ð¸ÑŽ Ð´Ð»Ñ Ð·Ð°Ð´Ð¾Ð»Ð¶ÐµÐ½Ð½Ñ‹Ñ… ÑÐºÐ·ÐµÐ¼Ð¿Ð»ÑÑ€Ð¾Ð², Ð·Ð°Ð±Ð»Ð°Ð³Ð¾Ð²Ñ€ÐµÐ¼ÐµÐ½Ð½Ñ‹Ñ… ÑƒÐ²ÐµÐ´Ð¾Ð¼Ð»ÐµÐ½Ð¸Ð¹ Ð¸ Ð±ÑƒÐ´ÑƒÑ‰Ð¸Ñ… Ð±Ð¸Ð±Ð»Ð¸Ð¾Ñ‚ÐµÑ‡Ð½Ñ‹Ñ… ÑÐ¾Ð±Ñ‹Ñ‚Ð¸Ð¹.
diff --git a/installer/data/mysql/ru-RU/optional/sample_notices_message_transports.sql b/installer/data/mysql/ru-RU/optional/sample_notices_message_transports.sql
deleted file mode 100644
index ade4d03..0000000
--- a/installer/data/mysql/ru-RU/optional/sample_notices_message_transports.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-truncate message_transports;
-
-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'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(4, 'sms',   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/optional/sample_notices_message_transports.txt b/installer/data/mysql/ru-RU/optional/sample_notices_message_transports.txt
deleted file mode 100644
index b8d556d..0000000
--- a/installer/data/mysql/ru-RU/optional/sample_notices_message_transports.txt
+++ /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
new file mode 100644
index 0000000..75e2793
--- /dev/null
+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices_message_attributes.sql
@@ -0,0 +1,11 @@
+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/uk-UA/mandatory/sample_notices_message_attributes.txt b/installer/data/mysql/uk-UA/mandatory/sample_notices_message_attributes.txt
new file mode 100644
index 0000000..3d6d349
--- /dev/null
+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices_message_attributes.txt
@@ -0,0 +1 @@
+ÐžÐ·Ð½Ð°Ñ‡ÐµÐ½Ð½Ñ Ð¿Ð¾Ð²Ñ–Ð´Ð¾Ð¼Ð»ÐµÐ½ÑŒ Ð¿Ð¾ ÑƒÐ¼Ð¾Ð²Ñ‡Ð°Ð½Ð½ÑŽ Ð´Ð»Ñ Ð·Ð°Ð±Ð¾Ñ€Ð³Ð¾Ð²Ð°Ð½Ð¸Ñ… Ð¿Ñ€Ð¸Ð¼Ñ–Ñ€Ð½Ð¸ÐºÑ–Ð², Ð·Ð°Ð²Ñ‡Ð°ÑÐ½Ð¸Ñ… ÑƒÐ²Ñ–Ð´Ð¾Ð¼Ð»ÐµÐ½ÑŒ Ñ‚Ð° Ð¼Ð°Ð¹Ð±ÑƒÑ‚Ð½Ñ–Ñ… Ð±Ñ–Ð±Ð»Ñ–Ð¾Ñ‚ÐµÑ‡Ð½Ð¸Ñ… Ð¿Ð¾Ð´Ñ–Ð¹.
\ 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
new file mode 100644
index 0000000..ade4d03
--- /dev/null
+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.sql
@@ -0,0 +1,18 @@
+truncate message_transports;
+
+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'),
+(2, 'email', 0, 'circulation', 'PREDUE'),
+(2, 'email', 1, 'circulation', 'PREDUEDGST'),
+(1, 'sms',   0, 'circulation', 'DUE'),
+(1, 'sms',   1, 'circulation', 'DUEDGST'),
+(2, 'sms',   0, 'circulation', 'PREDUE'),
+(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
+(4, 'sms',   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
new file mode 100644
index 0000000..6a005b0
--- /dev/null
+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.txt
@@ -0,0 +1 @@
+ÐžÐ·Ð½Ð°Ñ‡ÐµÐ½Ð½Ñ Ñ‚Ð¸Ð¿Ð¾Ð²Ð¸Ñ… Ð¿Ð¾Ð²Ñ–Ð´Ð¾Ð¼Ð»ÑÐ»ÑŒÐ½Ð¸Ñ… Ñ‚Ñ€Ð°Ð½ÑÐ¿Ð¾Ñ€Ñ‚Ñ–Ð² Ð´Ð»Ñ Ð¿Ð¾Ð²Ñ–Ð´Ð¾Ð¼Ð»ÐµÐ½ÑŒ Ð¿Ñ€Ð¾ Ð·Ð°Ð±Ð¾Ñ€Ð³Ð¾Ð²Ð°Ð½Ñ– Ð¿Ñ€Ð¸Ð¼Ñ–Ñ€Ð½Ð¸ÐºÐ¸, Ð·Ð°Ð²Ñ‡Ð°ÑÐ½Ð¸Ñ… ÑƒÐ²Ñ–Ð´Ð¾Ð¼Ð»ÐµÐ½ÑŒ Ð° Ñ‚Ð°ÐºÐ¾Ð¶ Ð¿Ð¾Ð²Ñ–Ð´Ð¾Ð¼Ð»ÐµÐ½Ð½Ñ Ð¿Ñ€Ð¾ Ð±Ñ–Ð±Ð»Ñ–Ð¾Ñ‚ÐµÑ‡Ð½Ñ– Ð¿Ð¾Ð´Ñ–Ñ— Ð· Ð´Ð¾Ð¿Ð¾Ð¼Ð¾Ð³Ð¾ÑŽ ÐµÐ»ÐµÐºÑ‚Ñ€Ð¾Ð½Ð½Ð¾Ñ— Ð¿Ð¾ÑˆÑ‚Ð¸ Ñ‚Ð° SMS.
diff --git a/installer/data/mysql/uk-UA/optional/sample_notices_message_attributes.sql b/installer/data/mysql/uk-UA/optional/sample_notices_message_attributes.sql
deleted file mode 100644
index 75e2793..0000000
--- a/installer/data/mysql/uk-UA/optional/sample_notices_message_attributes.sql
+++ /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/uk-UA/optional/sample_notices_message_attributes.txt b/installer/data/mysql/uk-UA/optional/sample_notices_message_attributes.txt
deleted file mode 100644
index 3d6d349..0000000
--- a/installer/data/mysql/uk-UA/optional/sample_notices_message_attributes.txt
+++ /dev/null
@@ -1 +0,0 @@
-ÐžÐ·Ð½Ð°Ñ‡ÐµÐ½Ð½Ñ Ð¿Ð¾Ð²Ñ–Ð´Ð¾Ð¼Ð»ÐµÐ½ÑŒ Ð¿Ð¾ ÑƒÐ¼Ð¾Ð²Ñ‡Ð°Ð½Ð½ÑŽ Ð´Ð»Ñ Ð·Ð°Ð±Ð¾Ñ€Ð³Ð¾Ð²Ð°Ð½Ð¸Ñ… Ð¿Ñ€Ð¸Ð¼Ñ–Ñ€Ð½Ð¸ÐºÑ–Ð², Ð·Ð°Ð²Ñ‡Ð°ÑÐ½Ð¸Ñ… ÑƒÐ²Ñ–Ð´Ð¾Ð¼Ð»ÐµÐ½ÑŒ Ñ‚Ð° Ð¼Ð°Ð¹Ð±ÑƒÑ‚Ð½Ñ–Ñ… Ð±Ñ–Ð±Ð»Ñ–Ð¾Ñ‚ÐµÑ‡Ð½Ð¸Ñ… Ð¿Ð¾Ð´Ñ–Ð¹.
\ No newline at end of file
diff --git a/installer/data/mysql/uk-UA/optional/sample_notices_message_transports.sql b/installer/data/mysql/uk-UA/optional/sample_notices_message_transports.sql
deleted file mode 100644
index ade4d03..0000000
--- a/installer/data/mysql/uk-UA/optional/sample_notices_message_transports.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-truncate message_transports;
-
-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'),
-(2, 'email', 0, 'circulation', 'PREDUE'),
-(2, 'email', 1, 'circulation', 'PREDUEDGST'),
-(1, 'sms',   0, 'circulation', 'DUE'),
-(1, 'sms',   1, 'circulation', 'DUEDGST'),
-(2, 'sms',   0, 'circulation', 'PREDUE'),
-(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
-(4, 'sms',   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/optional/sample_notices_message_transports.txt b/installer/data/mysql/uk-UA/optional/sample_notices_message_transports.txt
deleted file mode 100644
index 6a005b0..0000000
--- a/installer/data/mysql/uk-UA/optional/sample_notices_message_transports.txt
+++ /dev/null
@@ -1 +0,0 @@
-ÐžÐ·Ð½Ð°Ñ‡ÐµÐ½Ð½Ñ Ñ‚Ð¸Ð¿Ð¾Ð²Ð¸Ñ… Ð¿Ð¾Ð²Ñ–Ð´Ð¾Ð¼Ð»ÑÐ»ÑŒÐ½Ð¸Ñ… Ñ‚Ñ€Ð°Ð½ÑÐ¿Ð¾Ñ€Ñ‚Ñ–Ð² Ð´Ð»Ñ Ð¿Ð¾Ð²Ñ–Ð´Ð¾Ð¼Ð»ÐµÐ½ÑŒ Ð¿Ñ€Ð¾ Ð·Ð°Ð±Ð¾Ñ€Ð³Ð¾Ð²Ð°Ð½Ñ– Ð¿Ñ€Ð¸Ð¼Ñ–Ñ€Ð½Ð¸ÐºÐ¸, Ð·Ð°Ð²Ñ‡Ð°ÑÐ½Ð¸Ñ… ÑƒÐ²Ñ–Ð´Ð¾Ð¼Ð»ÐµÐ½ÑŒ Ð° Ñ‚Ð°ÐºÐ¾Ð¶ Ð¿Ð¾Ð²Ñ–Ð´Ð¾Ð¼Ð»ÐµÐ½Ð½Ñ Ð¿Ñ€Ð¾ Ð±Ñ–Ð±Ð»Ñ–Ð¾Ñ‚ÐµÑ‡Ð½Ñ– Ð¿Ð¾Ð´Ñ–Ñ— Ð· Ð´Ð¾Ð¿Ð¾Ð¼Ð¾Ð³Ð¾ÑŽ ÐµÐ»ÐµÐºÑ‚Ñ€Ð¾Ð½Ð½Ð¾Ñ— Ð¿Ð¾ÑˆÑ‚Ð¸ Ñ‚Ð° SMS.
-- 
1.7.4.1

