1 -- TRUNCATE categories;
3 -- INSERT INTO categories (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES
4 -- ('B', 'Рада', 99,17, 5, NULL,NULL,'0.000000',1,NULL,'0.000000','P'),
5 -- ('HB','Відвідувачі, що знаходяться вдома',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
6 -- ('IL','Міжбібліотечний обмін', 99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
7 -- ('J', 'Неповнолітній', 99,17, 5, NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
8 -- ('K', 'Дитина', 99,17, 5, NULL,NULL,'0.000000',1,NULL,'0.000000','C');
9 -- ('L', 'Бібліотека', 99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I');
10 -- ('PT','Відвідувач', 99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A');
11 -- ('S', 'Персонал бібліотеки', 99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');
12 -- ('SC','Школа', 99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I');
13 -- ('ST','Студент', 99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A');
14 -- ('T', 'Викладач', 99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P');
15 -- ('YA','Юнак', 99,17, 5, NULL,NULL,'0.000000',1,NULL,'0.000000','C');
17 INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
18 ( 'B', 'Рада', 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'P')
19 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';
21 INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
22 ( 'HB', 'Відвідувачі, що знаходяться вдома', 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'A')
23 ON DUPLICATE KEY UPDATE description='Відвідувачі, що знаходяться вдома',enrolmentperiod=99,upperagelimit=999,dateofbirthrequired=18,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=1,issuelimit=NULL,reservefee='0.000000',category_type='A';
25 INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
26 ( 'IL', 'Міжбібліотечний обмін', 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'I')
27 ON DUPLICATE KEY UPDATE description='Міжбібліотечний обмін',enrolmentperiod=99,upperagelimit=999,dateofbirthrequired=18,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=1,issuelimit=NULL,reservefee='0.000000',category_type='I';
29 INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
30 ( 'J', 'Неповнолітній', 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C')
31 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';
33 INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
34 ( 'K', 'Дитина', 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C')
35 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';
37 INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
38 ( 'L', 'Бібліотека', 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'I')
39 ON DUPLICATE KEY UPDATE description='Бібліотека',enrolmentperiod=99,upperagelimit=999,dateofbirthrequired=18,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=1,issuelimit=NULL,reservefee='0.000000',category_type='I';
41 INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
42 ( 'PT', 'Відвідувач', 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'A')
43 ON DUPLICATE KEY UPDATE description='Відвідувач',enrolmentperiod=99,upperagelimit=999,dateofbirthrequired=18,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=1,issuelimit=NULL,reservefee='0.000000',category_type='A';
45 INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
46 ( 'S', 'Персонал бібліотеки', 99, 999, 18, NULL, NULL, '0.000000', 0, NULL, '0.000000', 'S')
47 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='S';
49 INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
50 ( 'SC', 'Школа', 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'I')
51 ON DUPLICATE KEY UPDATE description='Школа',enrolmentperiod=99,upperagelimit=999,dateofbirthrequired=18,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=1,issuelimit=NULL,reservefee='0.000000',category_type='I';
53 INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
54 ( 'ST', 'Студент', 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'A')
55 ON DUPLICATE KEY UPDATE description='Студент',enrolmentperiod=99,upperagelimit=999,dateofbirthrequired=18,finetype=NULL,bulk=NULL,enrolmentfee='0.000000',overduenoticerequired=1,issuelimit=NULL,reservefee='0.000000',category_type='A';
57 INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
58 ( 'T', 'Викладач', 99, 999, 18, NULL, NULL, '0.000000', 0, NULL, '0.000000', 'P')
59 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';
61 INSERT INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) VALUES
62 ( 'YA', 'Юнак', 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C')
63 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';