From 82c12287c37d08f41f02cc92556c54fc439b89cb Mon Sep 17 00:00:00 2001 From: Maryse Simard 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 . -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