installer/data/mysql/it-IT/necessari/patron_categories.sql

   1 SET FOREIGN_KEY_CHECKS=0;
   2
   3 INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES
   4
   5 -- Adult Patrons
   6 ('PT','Utente',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
   7 ('ST','Studente',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
   8
   9 -- Children
  10 ('K','Bambino',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
  11 ('J','Ragazzo',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
  12 ('YA','Adolescente',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
  13
  14 -- Professionals
  15 ('T','Insegnante',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
  16 ('B','Board',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),
  17
  18 -- Institutional
  19 ('IL','Prestito Interbibliotecario',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
  20 ('SC','Scuola',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
  21 ('L','Biblioteca',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
  22
  23 -- Staff
  24 ('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');
  25
  26 SET FOREIGN_KEY_CHECKS=1;