installer/data/mysql/en/optional/patron_categories.sql

   1 INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES
   2
   3 ('PT','Patron',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
   4 ('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
   5 ('HB','Home Bound',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
   6
   7 ('K','Kid',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
   8 ('J','Juvenile',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
   9 ('YA','Young Adult',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
  10
  11 ('T','Teacher',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
  12 ('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
  13 ('B','Board',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),
  14
  15 ('IL','Inter-Library Loan',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
  16 ('SC','School',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
  17 ('L','Library',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I');
  18