|
Lines 1-23
Link Here
|
| 1 |
INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES |
|
|
| 2 |
|
| 3 |
-- Adult Patrons |
| 4 |
('PT','Patron',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','Home Bound',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'), |
| 7 |
|
| 8 |
-- Children |
| 9 |
('K','Kid',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), |
| 10 |
('J','Juvenile',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), |
| 11 |
('YA','Young Adult',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), |
| 12 |
|
| 13 |
-- Professionals |
| 14 |
('T','Teacher',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'), |
| 15 |
('B','Board',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'), |
| 16 |
|
| 17 |
-- Institutional |
| 18 |
('IL','Inter-Library Loan',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'), |
| 19 |
('SC','School',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'), |
| 20 |
('L','Library',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'), |
| 21 |
|
| 22 |
-- Staff |
| 23 |
('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S'); |