INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES 

-- Adult Patrons
('PT','Erwachsener',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
('HB','Ans Haus gebunden',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),

-- Children
('K','Kind',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
('J','Jugendlicher',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
('YA','Junger Erwachsener',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),

-- Professionals
('T','Lehrer',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
('B','Gremienmitglied',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),

-- Institutional
('IL','Fernleihbibliothek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
('SC','Schule',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
('L','Bibliothek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),

-- Staff
('S','Bibliotheksmitarbeiter',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');
