Attachment #113583 for bug #12446

View | Details | Raw Unified | Return to bug 12446
Collapse All | Expand All




          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'C'
          canbeguarantee: 1

        - categorycode: 'J'
          description: 'Juvenile'

          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'C'
          canbeguarantee: 1

        - categorycode: 'YA'
          description: 'Young Adult'

          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'C'
          canbeguarantee: 1

        #  Professionals
        - categorycode: 'T'

          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'P'
          canbeguarantee: 1

        - categorycode: 'B'
          description: 'Board'

          issuelimit: ~
          reservefee: '0.000000'
          category_type: 'P'
          canbeguarantee: 1

        #  Institutional
        - categorycode: 'IL'

Lines 1-15 Link Here

(-)a/installer/data/mysql/fr-FR/2-Optionel/patron_categories.sql (-9 / +9 lines)
1	SET NAMES utf8;	1	SET NAMES utf8;
2	INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES	2	INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES
3	('ADULT','Adulte',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),	3	('ADULT','Adulte',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
4	('ETUD','Etudiant',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),	4	('ETUD','Etudiant',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
5		5
6	('ENF','Enfant',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),	6	('ENF','Enfant',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
7	('ADO','Adolescent',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),	7	('ADO','Adolescent',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
8		8
9	('PROF','Professeur',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),	9	('PROF','Professeur',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P',1),
10	('PERS','Personnel bibliothèque',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),	10	('PERS','Personnel bibliothèque',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P',1),
11		11
12	('PEB','Prêt Entre Bibliothèque',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),	12	('PEB','Prêt Entre Bibliothèque',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
13	('PMI','PMI',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),	13	('PMI','PMI',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
14	('BDP','Bibliothèque Départementale',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I');	14	('BDP','Bibliothèque Départementale',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0);
15		15




TRUNCATE categories;

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`, `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`, `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');



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`, `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`, `canbeguarantee`) VALUES ('YA','Юноша',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, 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, 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, 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, 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, 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;


-- Колектив, організація, об’єднання
- 

Return to bug 12446

Lines 99-104 tables: Link Here

(-)a/installer/data/mysql/en/optional/patron_categories.yml (+5 lines)
99	issuelimit: ~	99	issuelimit: ~
100	reservefee: '0.000000'	100	reservefee: '0.000000'
101	category_type: 'C'	101	category_type: 'C'
		102	canbeguarantee: 1
102		103
103	- categorycode: 'J'	104	- categorycode: 'J'
104	description: 'Juvenile'	105	description: 'Juvenile'
Lines 112-117 tables: Link Here
112	issuelimit: ~	113	issuelimit: ~
113	reservefee: '0.000000'	114	reservefee: '0.000000'
114	category_type: 'C'	115	category_type: 'C'
		116	canbeguarantee: 1
115		117
116	- categorycode: 'YA'	118	- categorycode: 'YA'
117	description: 'Young Adult'	119	description: 'Young Adult'
Lines 125-130 tables: Link Here
125	issuelimit: ~	127	issuelimit: ~
126	reservefee: '0.000000'	128	reservefee: '0.000000'
127	category_type: 'C'	129	category_type: 'C'
		130	canbeguarantee: 1
128		131
129	# Professionals	132	# Professionals
130	- categorycode: 'T'	133	- categorycode: 'T'
Lines 139-144 tables: Link Here
139	issuelimit: ~	142	issuelimit: ~
140	reservefee: '0.000000'	143	reservefee: '0.000000'
141	category_type: 'P'	144	category_type: 'P'
		145	canbeguarantee: 1
142		146
143	- categorycode: 'B'	147	- categorycode: 'B'
144	description: 'Board'	148	description: 'Board'
Lines 152-157 tables: Link Here
152	issuelimit: ~	156	issuelimit: ~
153	reservefee: '0.000000'	157	reservefee: '0.000000'
154	category_type: 'P'	158	category_type: 'P'
		159	canbeguarantee: 1
155		160
156	# Institutional	161	# Institutional
157	- categorycode: 'IL'	162	- categorycode: 'IL'

Lines 1-23 Link Here

(-)a/installer/data/mysql/it-IT/optional/patron_categories.sql (-13 / +13 lines)
1	INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES	1	INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES
2		2
3	-- Adult Patrons	3	-- Adult Patrons
4	('PT','Utente',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),	4	('PT','Utente',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
5	('ST','Studente',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),	5	('ST','Studente',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
6	('HB','Gruppa familiare',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),	6	('HB','Gruppa familiare',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
7		7
8	-- Children	8	-- Children
9	('K','Bambino',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),	9	('K','Bambino',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
10	('J','Ragazzo',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),	10	('J','Ragazzo',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
11	('YA','Adolescente',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),	11	('YA','Adolescente',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
12		12
13	-- Professionals	13	-- Professionals
14	('T','Insegnante',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),	14	('T','Insegnante',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P',1),
15	('B','Associati',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),	15	('B','Associati',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P',1),
16		16
17	-- Institutional	17	-- Institutional
18	('IL','Prestito Interbibliotecario',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),	18	('IL','Prestito Interbibliotecario',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
19	('SC','Scuola',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),	19	('SC','Scuola',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
20	('L','Biblioteca',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),	20	('L','Biblioteca',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
21		21
22	-- Staff	22	-- Staff
23	('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');	23	('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S',0);

Lines 19-44 Link Here

(-)a/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.sql (-13 / +13 lines)
19	-- You should have received a copy of the GNU General Public License	19	-- You should have received a copy of the GNU General Public License
20	-- along with Koha; if not, see <http://www.gnu.org/licenses>.	20	-- along with Koha; if not, see <http://www.gnu.org/licenses>.
21		21
22	INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES	22	INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES
23		23
24	-- Adult Patrons	24	-- Adult Patrons
25	('PT','Låner',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),	25	('PT','Låner',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
26	('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),	26	('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
27	('HB','Hjemmelåner',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),	27	('HB','Hjemmelåner',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
28		28
29	-- Children	29	-- Children
30	('K','Barn',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),	30	('K','Barn',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
31	('J','Ungdom',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),	31	('J','Ungdom',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
32	('YA','Ung voksen',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),	32	('YA','Ung voksen',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
33		33
34	-- Professionals	34	-- Professionals
35	('T','Lærer',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),	35	('T','Lærer',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P',1),
36	('B','Styremedlem',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),	36	('B','Styremedlem',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P',1),
37		37
38	-- Institutional	38	-- Institutional
39	('IL','Fjernlån',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),	39	('IL','Fjernlån',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
40	('SC','Skole',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),	40	('SC','Skole',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
41	('L','Bibliotek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),	41	('L','Bibliotek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
42		42
43	-- Staff	43	-- Staff
44	('S','Bibliotekansatt',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');	44	('S','Bibliotekansatt',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S',0);

Lines 1-23 Link Here

(-)a/installer/data/mysql/pl-PL/optional/patron_categories.sql (-13 / +13 lines)
1	INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES	1	INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES
2		2
3	-- Adult Patrons	3	-- Adult Patrons
4	('PT','Patron',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),	4	('PT','Patron',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
5	('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),	5	('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
6	('HB','Home Bound',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),	6	('HB','Home Bound',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
7		7
8	-- Children	8	-- Children
9	('K','Kid',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),	9	('K','Kid',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
10	('J','Juvenile',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),	10	('J','Juvenile',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
11	('YA','Young Adult',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),	11	('YA','Young Adult',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
12		12
13	-- Professionals	13	-- Professionals
14	('T','Teacher',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),	14	('T','Teacher',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P',1),
15	('B','Board',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),	15	('B','Board',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P',1),
16		16
17	-- Institutional	17	-- Institutional
18	('IL','Inter-Library Loan',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),	18	('IL','Inter-Library Loan',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
19	('SC','School',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),	19	('SC','School',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
20	('L','Library',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),	20	('L','Library',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
21		21
22	-- Staff	22	-- Staff
23	('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');	23	('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S',0);

Lines 1-14 Link Here

(-)a/installer/data/mysql/ru-RU/optional/patron_categories.sql (-5 / +5 lines)
1	TRUNCATE categories;	1	TRUNCATE categories;
2		2
3	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');	3	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);
4		4
5	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');	5	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');
6		6
7	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');	7	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');
8		8
9	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');	9	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);
10		10
11	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');	11	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);
12		12
13	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');	13	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');
14		14
Lines 20-25 INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upp Link Here
20		20
21	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');	21	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');
22		22
23	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');	23	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);
24		24
25	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');	25	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);

Lines 31-58 ON DUPLICATE KEY UPDATE description='Аспірант',enrolmentperiod=99,uppera Link Here

(-)a/installer/data/mysql/uk-UA/optional/patron_categories.sql (-16 / +15 lines)
31		31
32	-- Діти	32	-- Діти
33		33
34	INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES	34	INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type, canbeguarantee) VALUES
35	( 'J', 'Неповнолітній', 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C')	35	( 'J', 'Неповнолітній', 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C', 1)
36	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';	36	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;
37		37
38	INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES	38	INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type, canbeguarantee) VALUES
39	( 'K', 'Дитина', 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C')	39	( 'K', 'Дитина', 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C', 1)
40	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';	40	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;
41		41
42	INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES	42	INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type, canbeguarantee) VALUES
43	( 'YA', 'Юнак', 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C')	43	( 'YA', 'Юнак', 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C', 1)
44	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';	44	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;
45		45
46		46
47	-- Член колективу, організації, об’єднання	47	-- Член колективу, організації, об’єднання
48		48
49	INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES	49	INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type, canbeguarantee) VALUES
50	( 'B', 'Рада', 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'P')	50	( 'B', 'Рада', 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'P', 1)
51	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';	51	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;
52		52
53	INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES	53	INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type, canbeguarantee) VALUES
54	( 'T', 'Викладач', 99, 999, 18, NULL, NULL, '0.000000', 0, NULL, '0.000000', 'P')	54	( 'T', 'Викладач', 99, 999, 18, NULL, NULL, '0.000000', 0, NULL, '0.000000', 'P', 1)
55	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';	55	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;
56		56
57		57
58	-- Колектив, організація, об’єднання	58	-- Колектив, організація, об’єднання
59	-