1 SET FOREIGN_KEY_CHECKS=0;
3 INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES
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'),
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'),
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'),
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'),
24 ('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');
26 SET FOREIGN_KEY_CHECKS=1;