installer/data/mysql/uk-UA/optional/patron_categories.sql

   1 -- TRUNCATE categories;
   2
   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');
  16
  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';
  20
  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';
  24
  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';
  28
  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';
  32
  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';
  36
  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';
  40
  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';
  44
  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';
  48
  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';
  52
  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';
  56
  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';
  60
  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';