From b21f235b9eb485a35b59e5f7b348d833ff98f143 Mon Sep 17 00:00:00 2001
From: Chris Nighswonger <cnighswonger@foundations.edu>
Date: Sat, 12 Dec 2009 15:17:13 -0500
Subject: [PATCH] Bugfix for various bugs in mandatory and sample data for
 webinstaller

NOTE: This patch removes the sample budgets data which was obsoleted by the new
aquisitions module. The changes introduced with this new module will require
a completely new set of sample data to be written.
---
 installer/data/mysql/en/mandatory/sysprefs.sql   |  2 --
 .../data/mysql/en/optional/sample_budgets.sql    | 11 -----------
 .../data/mysql/en/optional/sample_budgets.txt    |  1 -
 .../data/mysql/en/optional/sample_itemtypes.sql  | 16 ++++++++--------
 4 files changed, 8 insertions(+), 22 deletions(-)
 delete mode 100644 installer/data/mysql/en/optional/sample_budgets.sql
 delete mode 100644 installer/data/mysql/en/optional/sample_budgets.txt

diff --git a/installer/data/mysql/en/mandatory/sysprefs.sql b/installer/data/mysql/en/mandatory/sysprefs.sql
index cfa16e2f8e..3e0c38250d 100644
--- a/installer/data/mysql/en/mandatory/sysprefs.sql
+++ b/installer/data/mysql/en/mandatory/sysprefs.sql
@@ -271,6 +271,4 @@ INSERT INTO systempreferences (variable,value,options,explanation,type)VALUES('D
 INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('AllowAllMessageDeletion','0','Allow any Library to delete any message','','YesNo');
 INSERT INTO systempreferences (variable,value,explanation,options,type)VALUES('ShowPatronImageInWebBasedSelfCheck', '0', 'If ON, displays patron image when a patron uses web-based self-checkout', '', 'YesNo');
 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('EnableOpacSearchHistory', '1', 'Enable or disable opac search history', 'YesNo','');
-INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('OPACPatronDetails','1','If OFF the patron details tab in the OPAC is disabled.','','YesNo');
-INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('OPACFinesTab','1','If OFF the patron fines tab in the OPAC is disabled.','','YesNo');
 INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('RoutingListAddReserves','1','If ON the patrons on routing lists are automatically added to holds on the issue.','','YesNo');
diff --git a/installer/data/mysql/en/optional/sample_budgets.sql b/installer/data/mysql/en/optional/sample_budgets.sql
deleted file mode 100644
index a17dd1c556..0000000000
--- a/installer/data/mysql/en/optional/sample_budgets.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-INSERT INTO `aqbudget` VALUES
-
-('CHILD','2008-01-01','2008-12-31','5000.00',1,''),
-('GEN','2008-01-01','2008-12-31','20000.00',2,''),
-('REF','2008-01-01','2008-12-31','5000.00',3,'');
-
-INSERT INTO `aqbookfund` VALUES
-
-('CHILD','Children\'s Materials',NULL,''),
-('GEN','General Stacks',NULL,''),
-('REF','Reference Materials',NULL,'');
diff --git a/installer/data/mysql/en/optional/sample_budgets.txt b/installer/data/mysql/en/optional/sample_budgets.txt
deleted file mode 100644
index de87938b8e..0000000000
--- a/installer/data/mysql/en/optional/sample_budgets.txt
+++ /dev/null
@@ -1 +0,0 @@
-Sample Budgets and Funds
diff --git a/installer/data/mysql/en/optional/sample_itemtypes.sql b/installer/data/mysql/en/optional/sample_itemtypes.sql
index f842f94bda..39e09713ac 100644
--- a/installer/data/mysql/en/optional/sample_itemtypes.sql
+++ b/installer/data/mysql/en/optional/sample_itemtypes.sql
@@ -1,8 +1,8 @@
-INSERT INTO `itemtypes` VALUES ('BK', 'Books',5,0,0,'bridge/book.gif','');
-INSERT INTO `itemtypes` VALUES ('MX', 'Mixed Materials',5,0,0,'bridge/kit.gif','');
-INSERT INTO `itemtypes` VALUES ('CF', 'Computer Files',5,0,0,'bridge/computer_file.gif','');
-INSERT INTO `itemtypes` VALUES ('MP', 'Maps',5,0,0,'bridge/map.gif','');
-INSERT INTO `itemtypes` VALUES ('VM', 'Visual Materials',5,0,1,'bridge/dvd.gif','');
-INSERT INTO `itemtypes` VALUES ('MU', 'Music',5,0,0,'bridge/sound.gif','');
-INSERT INTO `itemtypes` VALUES ('CR', 'Continuing Resources',5,0,0,'bridge/periodical.gif','');
-INSERT INTO `itemtypes` VALUES ('REF', 'Reference',0,0,1,'','');
+INSERT INTO `itemtypes` VALUES ('BK', 'Books',5,0,0,'bridge/book.gif');
+INSERT INTO `itemtypes` VALUES ('MX', 'Mixed Materials',5,0,0,'bridge/kit.gif');
+INSERT INTO `itemtypes` VALUES ('CF', 'Computer Files',5,0,0,'bridge/computer_file.gif');
+INSERT INTO `itemtypes` VALUES ('MP', 'Maps',5,0,0,'bridge/map.gif');
+INSERT INTO `itemtypes` VALUES ('VM', 'Visual Materials',5,0,1,'bridge/dvd.gif');
+INSERT INTO `itemtypes` VALUES ('MU', 'Music',5,0,0,'bridge/sound.gif');
+INSERT INTO `itemtypes` VALUES ('CR', 'Continuing Resources',5,0,0,'bridge/periodical.gif');
+INSERT INTO `itemtypes` VALUES ('REF', 'Reference',0,0,1,'');
-- 
2.39.5