installer/data/mysql/de-DE/optional/patron_categories.sql

   1 INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES
   2
   3 -- Adult Patrons
   4 ('PT','Erwachsener',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'),
   6 ('HB','Ans Haus gebunden',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
   7
   8 -- Children
   9 ('K','Kind',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
  10 ('J','Jugendlicher',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
  11 ('YA','Junger Erwachsener',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
  12
  13 -- Professionals
  14 ('T','Lehrer',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
  15 ('B','Vorstand',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),
  16
  17 -- Institutional
  18 ('IL','Fernleihbibliothek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
  19 ('SC','Schule',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
  20 ('L','Bibliothek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
  21
  22 -- Staff
  23 ('S','Mitarbeiter',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');