From b6d07ca784c73df381498f32f470d79ac8359c70 Mon Sep 17 00:00:00 2001 From: Joshua Ferraro Date: Sat, 29 Sep 2007 16:45:42 -0500 Subject: [PATCH] improving sample patron data Signed-off-by: Chris Cormack --- .../data/en/optional/borrower_categories.sql | 4 --- .../data/en/optional/borrower_categories.txt | 1 - .../data/en/optional/patron_categories.sql | 17 +++++++++++++ .../data/en/optional/patron_categories.txt | 25 +++++++++++++++++++ 4 files changed, 42 insertions(+), 5 deletions(-) delete mode 100644 installer/data/en/optional/borrower_categories.sql delete mode 100644 installer/data/en/optional/borrower_categories.txt create mode 100644 installer/data/en/optional/patron_categories.sql create mode 100644 installer/data/en/optional/patron_categories.txt diff --git a/installer/data/en/optional/borrower_categories.sql b/installer/data/en/optional/borrower_categories.sql deleted file mode 100644 index d7d35ad79b..0000000000 --- a/installer/data/en/optional/borrower_categories.sql +++ /dev/null @@ -1,4 +0,0 @@ -INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES ('PATRON','patron',12,100,18,NULL,NULL,'0.000000',0,NULL,'0.000000','A'); -INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES ('CHILD','child',12,18,0,NULL,NULL,'0.000000',0,NULL,'0.000000','C'); -INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES ('INST','institution',12,100,0,NULL,NULL,'0.000000',0,NULL,'0.000000','I'); -INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES ('PROF','professional',12,100,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'); diff --git a/installer/data/en/optional/borrower_categories.txt b/installer/data/en/optional/borrower_categories.txt deleted file mode 100644 index b31389eefe..0000000000 --- a/installer/data/en/optional/borrower_categories.txt +++ /dev/null @@ -1 +0,0 @@ -Default borrower categories: Adult Patron, Child, Institution, Professional. You can add additional categories after installation. diff --git a/installer/data/en/optional/patron_categories.sql b/installer/data/en/optional/patron_categories.sql new file mode 100644 index 0000000000..9b24263953 --- /dev/null +++ b/installer/data/en/optional/patron_categories.sql @@ -0,0 +1,17 @@ +INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES +('PT','Patron',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','Home Bound',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'), + +('K','Kid',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), +('J','Juvenile',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), +('YA','Young Adult',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), + +('T','Teacher',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'), +('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'), +('B','Board',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'), + +('IL','Inter-Library Loan',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'), +('SC','School',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'), +('L','Library',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'); + diff --git a/installer/data/en/optional/patron_categories.txt b/installer/data/en/optional/patron_categories.txt new file mode 100644 index 0000000000..ccb7f40970 --- /dev/null +++ b/installer/data/en/optional/patron_categories.txt @@ -0,0 +1,25 @@ +Sample patron types and categories: + +Type: Categories: + +Adult Patron - default patron type + PT - Patron + ST - Student + BH - Homebound + +Child - patron with a guarantor + K - Kid + J - Juvenile + YA - Young Adult + +Organization - patron is an institution, not a person + ILL - Inter-library Loan + SC - School + L - Library + +Professional - a member of an organization (organization is guarantor) + T - Teacher + S - Staff + B - Board + +Types are currently hardcoded, but you can add/edit/delete categories after installation from the administration module. -- 2.39.5