Attachment 113583 Details for Bug 12446 – Bug 12446: Add canbeguarantee value to patron categories sample data

[patch] Bug 12446: Add canbeguarantee value to patron categories sample data

Bug-12446-Add-canbeguarantee-value-to-patron-categ.patch (text/plain), 24.55 KB, created by Maryse Simard on 2020-11-12 21:44:59 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Maryse Simard

Created: 2020-11-12 21:44:59 UTC

Size: 24.55 KB

patch

obsolete

>From 82c12287c37d08f41f02cc92556c54fc439b89cb Mon Sep 17 00:00:00 2001
>From: Maryse Simard <maryse.simard@inlibro.com>
>Date: Thu, 12 Nov 2020 16:01:35 -0500
>Subject: [PATCH] Bug 12446: Add canbeguarantee value to patron categories
> sample data
>
>This patch changes sample data so patron categories of type 'C' or
>'P' can be guarantees by default.
>---
> .../mysql/en/optional/patron_categories.yml   |  5 ++++
> .../fr-FR/2-Optionel/patron_categories.sql    | 18 +++++------
> .../it-IT/optional/patron_categories.sql      | 26 ++++++++--------
> .../nb-NO/2-Valgfritt/patron_categories.sql   | 26 ++++++++--------
> .../pl-PL/optional/patron_categories.sql      | 26 ++++++++--------
> .../ru-RU/optional/patron_categories.sql      | 10 +++----
> .../uk-UA/optional/patron_categories.sql      | 30 +++++++++----------
> 7 files changed, 73 insertions(+), 68 deletions(-)
>
>diff --git a/installer/data/mysql/en/optional/patron_categories.yml b/installer/data/mysql/en/optional/patron_categories.yml
>index e5a02d1084..3d8d72696f 100644
>--- a/installer/data/mysql/en/optional/patron_categories.yml
>+++ b/installer/data/mysql/en/optional/patron_categories.yml
>@@ -99,6 +99,7 @@ tables:
>           issuelimit: ~
>           reservefee: '0.000000'
>           category_type: 'C'
>+          canbeguarantee: 1
> 
>         - categorycode: 'J'
>           description: 'Juvenile'
>@@ -112,6 +113,7 @@ tables:
>           issuelimit: ~
>           reservefee: '0.000000'
>           category_type: 'C'
>+          canbeguarantee: 1
> 
>         - categorycode: 'YA'
>           description: 'Young Adult'
>@@ -125,6 +127,7 @@ tables:
>           issuelimit: ~
>           reservefee: '0.000000'
>           category_type: 'C'
>+          canbeguarantee: 1
> 
>         #  Professionals
>         - categorycode: 'T'
>@@ -139,6 +142,7 @@ tables:
>           issuelimit: ~
>           reservefee: '0.000000'
>           category_type: 'P'
>+          canbeguarantee: 1
> 
>         - categorycode: 'B'
>           description: 'Board'
>@@ -152,6 +156,7 @@ tables:
>           issuelimit: ~
>           reservefee: '0.000000'
>           category_type: 'P'
>+          canbeguarantee: 1
> 
>         #  Institutional
>         - categorycode: 'IL'
>diff --git a/installer/data/mysql/fr-FR/2-Optionel/patron_categories.sql b/installer/data/mysql/fr-FR/2-Optionel/patron_categories.sql
>index 22ddcd99f8..47902271aa 100644
>--- a/installer/data/mysql/fr-FR/2-Optionel/patron_categories.sql
>+++ b/installer/data/mysql/fr-FR/2-Optionel/patron_categories.sql
>@@ -1,15 +1,15 @@
> SET NAMES utf8;
>-INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES 
>-('ADULT','Adulte',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>-('ETUD','Etudiant',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>+INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES
>+('ADULT','Adulte',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
>+('ETUD','Etudiant',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
> 
>-('ENF','Enfant',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>-('ADO','Adolescent',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>+('ENF','Enfant',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
>+('ADO','Adolescent',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
> 
>-('PROF','Professeur',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
>-('PERS','Personnel bibliothÃ¨que',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
>+('PROF','Professeur',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P',1),
>+('PERS','Personnel bibliothÃ¨que',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P',1),
> 
>-('PEB','PrÃªt Entre BibliothÃ¨que',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>+('PEB','PrÃªt Entre BibliothÃ¨que',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
> ('PMI','PMI',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>-('BDP','BibliothÃ¨que DÃ©partementale',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I');
>+('BDP','BibliothÃ¨que DÃ©partementale',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0);
> 
>diff --git a/installer/data/mysql/it-IT/optional/patron_categories.sql b/installer/data/mysql/it-IT/optional/patron_categories.sql
>index 6ca50fc975..77e53e5bb0 100644
>--- a/installer/data/mysql/it-IT/optional/patron_categories.sql
>+++ b/installer/data/mysql/it-IT/optional/patron_categories.sql
>@@ -1,23 +1,23 @@
>-INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES 
>+INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES
> 
> -- Adult Patrons
>-('PT','Utente',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>-('ST','Studente',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>-('HB','Gruppa familiare',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>+('PT','Utente',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
>+('ST','Studente',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
>+('HB','Gruppa familiare',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
> 
> -- Children
>-('K','Bambino',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>-('J','Ragazzo',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>-('YA','Adolescente',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>+('K','Bambino',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
>+('J','Ragazzo',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
>+('YA','Adolescente',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
> 
> -- Professionals
>-('T','Insegnante',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
>-('B','Associati',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),
>+('T','Insegnante',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P',1),
>+('B','Associati',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P',1),
> 
> -- Institutional
>-('IL','Prestito Interbibliotecario',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>-('SC','Scuola',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>-('L','Biblioteca',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>+('IL','Prestito Interbibliotecario',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
>+('SC','Scuola',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
>+('L','Biblioteca',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
> 
> -- Staff
>-('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');
>+('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S',0);
>diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.sql b/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.sql
>index 456eed81f4..0d7c233779 100644
>--- a/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.sql
>+++ b/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.sql
>@@ -19,26 +19,26 @@
> -- You should have received a copy of the GNU General Public License
> -- along with Koha; if not, see <http://www.gnu.org/licenses>.
> 
>-INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES 
>+INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES
> 
> -- Adult Patrons
>-('PT','LÃ¥ner',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>-('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>-('HB','HjemmelÃ¥ner',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>+('PT','LÃ¥ner',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
>+('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
>+('HB','HjemmelÃ¥ner',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
> 
> -- Children
>-('K','Barn',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>-('J','Ungdom',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>-('YA','Ung voksen',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>+('K','Barn',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
>+('J','Ungdom',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
>+('YA','Ung voksen',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
> 
> -- Professionals
>-('T','LÃ¦rer',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
>-('B','Styremedlem',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),
>+('T','LÃ¦rer',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P',1),
>+('B','Styremedlem',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P',1),
> 
> -- Institutional
>-('IL','FjernlÃ¥n',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>-('SC','Skole',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>-('L','Bibliotek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>+('IL','FjernlÃ¥n',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
>+('SC','Skole',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
>+('L','Bibliotek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
> 
> -- Staff
>-('S','Bibliotekansatt',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');
>+('S','Bibliotekansatt',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S',0);
>diff --git a/installer/data/mysql/pl-PL/optional/patron_categories.sql b/installer/data/mysql/pl-PL/optional/patron_categories.sql
>index 57a00dabdb..f78fa73080 100644
>--- a/installer/data/mysql/pl-PL/optional/patron_categories.sql
>+++ b/installer/data/mysql/pl-PL/optional/patron_categories.sql
>@@ -1,23 +1,23 @@
>-INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES
>+INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES
> 
> -- Adult Patrons
>-('PT','Patron',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>-('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>-('HB','Home Bound',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>+('PT','Patron',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
>+('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
>+('HB','Home Bound',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
> 
> -- Children
>-('K','Kid',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>-('J','Juvenile',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>-('YA','Young Adult',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>+('K','Kid',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
>+('J','Juvenile',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
>+('YA','Young Adult',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
> 
> -- Professionals
>-('T','Teacher',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
>-('B','Board',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),
>+('T','Teacher',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P',1),
>+('B','Board',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P',1),
> 
> -- Institutional
>-('IL','Inter-Library Loan',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>-('SC','School',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>-('L','Library',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>+('IL','Inter-Library Loan',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
>+('SC','School',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
>+('L','Library',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
> 
> -- Staff
>-('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');
>+('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S',0);
>diff --git a/installer/data/mysql/ru-RU/optional/patron_categories.sql b/installer/data/mysql/ru-RU/optional/patron_categories.sql
>index 8e72b6d984..2c5abc637b 100644
>--- a/installer/data/mysql/ru-RU/optional/patron_categories.sql
>+++ b/installer/data/mysql/ru-RU/optional/patron_categories.sql
>@@ -1,14 +1,14 @@
> TRUNCATE categories;
> 
>-INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES ('B','Ð¡Ð¾Ð²ÐµÑ',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P');
>+INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES ('B','Ð¡Ð¾Ð²ÐµÑ',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P',1);
> 
> INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES ('HB','ÐÐ¾ÑÐµÑÐ¸ÑÐµÐ»Ð¸, Ð½Ð°ÑÐ¾Ð´ÑÑÐ¸ÐµÑÑ Ð´Ð¾Ð¼Ð°',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A');
> 
> INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES ('IL','ÐÐµÐ¶Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÑÐ½ÑÐ¹ Ð¾Ð±Ð¼ÐµÐ½',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I');
> 
>-INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES ('J','ÐÐµÑÐ¾Ð²ÐµÑÑÐµÐ½Ð½Ð¾Ð»ÐµÑÐ½Ð¸Ð¹',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C');
>+INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES ('J','ÐÐµÑÐ¾Ð²ÐµÑÑÐµÐ½Ð½Ð¾Ð»ÐµÑÐ½Ð¸Ð¹',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1);
> 
>-INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES ('K','Ð ÐµÐ±ÑÐ½Ð¾Ðº',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C');
>+INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES ('K','Ð ÐµÐ±ÑÐ½Ð¾Ðº',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1);
> 
> INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES ('L','ÐÐ¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐ°',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I');
> 
>@@ -20,6 +20,6 @@ INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upp
> 
> INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES ('ST','Ð¡ÑÑÐ´ÐµÐ½Ñ',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A');
> 
>-INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES ('T','ÐÑÐµÐ¿Ð¾Ð´Ð°Ð²Ð°ÑÐµÐ»Ñ',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P');
>+INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES ('T','ÐÑÐµÐ¿Ð¾Ð´Ð°Ð²Ð°ÑÐµÐ»Ñ',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P',1);
> 
>-INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES ('YA','Ð®Ð½Ð¾ÑÐ°',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C');
>+INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES ('YA','Ð®Ð½Ð¾ÑÐ°',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1);
>diff --git a/installer/data/mysql/uk-UA/optional/patron_categories.sql b/installer/data/mysql/uk-UA/optional/patron_categories.sql
>index c8ee501520..e23b19bd0d 100644
>--- a/installer/data/mysql/uk-UA/optional/patron_categories.sql
>+++ b/installer/data/mysql/uk-UA/optional/patron_categories.sql
>@@ -31,28 +31,28 @@ ON DUPLICATE KEY UPDATE description='ÐÑÐ¿ÑÑÐ°Ð½Ñ',enrolmentperiod=99,uppera
> 
> -- ÐÑÑÐ¸
> 
>-INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
>-(            'J',                   'ÐÐµÐ¿Ð¾Ð²Ð½Ð¾Ð»ÑÑÐ½ÑÐ¹',                99,              17,                    5,         NULL,     NULL,             '0.000000',                      1,           NULL,           '0.000000',              'C')
>-ON DUPLICATE KEY UPDATE description='ÐÐµÐ¿Ð¾Ð²Ð½Ð¾Ð»ÑÑÐ½ÑÐ¹',enrolmentperiod=99,upperagelimit=17,dateofbirthrequired=5,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=1,issuelimit=NULL,reservefee='0.000000',category_type='C';
>+INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type, canbeguarantee) VALUES
>+(            'J',                   'ÐÐµÐ¿Ð¾Ð²Ð½Ð¾Ð»ÑÑÐ½ÑÐ¹',                99,              17,                    5,         NULL,     NULL,             '0.000000',                      1,           NULL,           '0.000000',              'C',               1)
>+ON DUPLICATE KEY UPDATE description='ÐÐµÐ¿Ð¾Ð²Ð½Ð¾Ð»ÑÑÐ½ÑÐ¹',enrolmentperiod=99,upperagelimit=17,dateofbirthrequired=5,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=1,issuelimit=NULL,reservefee='0.000000',category_type='C',canbeguarantee=1;
> 
>-INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
>-(            'K',                   'ÐÐ¸ÑÐ¸Ð½Ð°',                99,              17,                    5,         NULL,     NULL,             '0.000000',                      1,           NULL,           '0.000000',              'C')
>-ON DUPLICATE KEY UPDATE description='ÐÐ¸ÑÐ¸Ð½Ð°',enrolmentperiod=99,upperagelimit=17,dateofbirthrequired=5,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=1,issuelimit=NULL,reservefee='0.000000',category_type='C';
>+INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type, canbeguarantee) VALUES
>+(            'K',                   'ÐÐ¸ÑÐ¸Ð½Ð°',                99,              17,                    5,         NULL,     NULL,             '0.000000',                      1,           NULL,           '0.000000',              'C',               1)
>+ON DUPLICATE KEY UPDATE description='ÐÐ¸ÑÐ¸Ð½Ð°',enrolmentperiod=99,upperagelimit=17,dateofbirthrequired=5,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=1,issuelimit=NULL,reservefee='0.000000',category_type='C',canbeguarantee=1;
> 
>-INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
>-(            'YA',                  'Ð®Ð½Ð°Ðº',                99,              17,                    5,         NULL,     NULL,             '0.000000',                      1,           NULL,           '0.000000',              'C')
>-ON DUPLICATE KEY UPDATE description='Ð®Ð½Ð°Ðº',enrolmentperiod=99,upperagelimit=17,dateofbirthrequired=5,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=1,issuelimit=NULL,reservefee='0.000000',category_type='C';
>+INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type, canbeguarantee) VALUES
>+(            'YA',                  'Ð®Ð½Ð°Ðº',                99,              17,                    5,         NULL,     NULL,             '0.000000',                      1,           NULL,           '0.000000',              'C',               1)
>+ON DUPLICATE KEY UPDATE description='Ð®Ð½Ð°Ðº',enrolmentperiod=99,upperagelimit=17,dateofbirthrequired=5,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=1,issuelimit=NULL,reservefee='0.000000',category_type='C',canbeguarantee=1;
> 
> 
> -- Ð§Ð»ÐµÐ½ ÐºÐ¾Ð»ÐµÐºÑÐ¸Ð²Ñ, Ð¾ÑÐ³Ð°Ð½ÑÐ·Ð°ÑÑÑ, Ð¾Ð±âÑÐ´Ð½Ð°Ð½Ð½Ñ
> 
>-INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
>-(            'B',                   'Ð Ð°Ð´Ð°',                99,              17,                    5,         NULL,     NULL,             '0.000000',                      1,           NULL,           '0.000000',              'P')
>-ON DUPLICATE KEY UPDATE description='Ð Ð°Ð´Ð°',enrolmentperiod=99,upperagelimit=17,dateofbirthrequired=5,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=1,issuelimit=NULL,reservefee='0.000000',category_type='P';
>+INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type, canbeguarantee) VALUES
>+(            'B',                   'Ð Ð°Ð´Ð°',                99,              17,                    5,         NULL,     NULL,             '0.000000',                      1,           NULL,           '0.000000',              'P',               1)
>+ON DUPLICATE KEY UPDATE description='Ð Ð°Ð´Ð°',enrolmentperiod=99,upperagelimit=17,dateofbirthrequired=5,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=1,issuelimit=NULL,reservefee='0.000000',category_type='P',canbeguarantee=1;
> 
>-INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
>-(            'T',                   'ÐÐ¸ÐºÐ»Ð°Ð´Ð°Ñ',                99,              999,                    18,         NULL,     NULL,             '0.000000',                      0,           NULL,           '0.000000',              'P')
>-ON DUPLICATE KEY UPDATE description='ÐÐ¸ÐºÐ»Ð°Ð´Ð°Ñ',enrolmentperiod=99,upperagelimit=999,dateofbirthrequired=18,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=0,issuelimit=NULL,reservefee='0.000000',category_type='P';
>+INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type, canbeguarantee) VALUES
>+(            'T',                   'ÐÐ¸ÐºÐ»Ð°Ð´Ð°Ñ',                99,              999,                    18,         NULL,     NULL,             '0.000000',                      0,           NULL,           '0.000000',              'P',               1)
>+ON DUPLICATE KEY UPDATE description='ÐÐ¸ÐºÐ»Ð°Ð´Ð°Ñ',enrolmentperiod=99,upperagelimit=999,dateofbirthrequired=18,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=0,issuelimit=NULL,reservefee='0.000000',category_type='P',canbeguarantee=1;
> 
> 
> -- ÐÐ¾Ð»ÐµÐºÑÐ¸Ð², Ð¾ÑÐ³Ð°Ð½ÑÐ·Ð°ÑÑÑ, Ð¾Ð±âÑÐ´Ð½Ð°Ð½Ð½Ñ
>-- 
>2.17.1

Actions: View | Diff | Splinter Review

Attachments on bug 12446: 29278 | 36176 | 39744 | 42469 | 42470 | 42535 | 46277 | 46278 | 46327 | 46328 | 46345 | 46486 | 49793 | 50953 | 53534 | 53535 | 53536 | 53913 | 60929 | 60930 | 60934 | 63148 | 63149 | 63214 | 64793 | 64794 | 64828 | 72295 | 72883 | 77766 | 77767 | 77768 | 79343 | 79344 | 79345 | 79347 | 79348 | 85069 | 88364 | 88365 | 88366 | 88367 | 90389 | 90390 | 90391 | 90392 | 90470 | 90471 | 90472 | 90473 | 93388 | 93389 | 93390 | 93391 | 93392 | 93393 | 93394 | 95411 | 95853 | 95854 | 95855 | 95856 | 95857 | 95858 | 95859 | 95860 | 106753 | 106754 | 106755 | 106756 | 106757 | 107611 | 111052 | 111053 | 111317 | 111318 | 112102 | 112160 | 112161 | 112162 | 112163 | 113583 | 121925 | 121926 | 121927 | 121928 | 121929 | 122084 | 122085 | 122086 | 122087 | 122088 | 122089 | 122090 | 122091 | 122184 | 122185 | 122186 | 122187 | 130398 | 130399 | 130400 | 130401 | 130402 | 131965 | 131966 | 131967 | 131968 | 131969 | 133691 | 133952 | 133953 | 133954 | 133955 | 133956 | 133957 | 134930 | 134931 | 134932 | 134933 | 134934 | 134935 | 134936 | 135506 | 135507 | 135508 | 135509 | 135510 | 135511 | 135512 | 135519 | 135520 | 135521 | 135522 | 135523 | 135544 | 135545 | 142401 | 142408 | 142431 | 142432 | 142433 | 142434 | 142435 | 142436 | 142437 | 142438 | 142439