-- MySQL dump 10.11
--
-- Host: localhost    Database: ztest
-- ------------------------------------------------------
-- Server version	5.0.77

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `opl_prefFormParam`
--

DROP TABLE IF EXISTS `opl_prefFormParam`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `opl_prefFormParam` (
  `var` varchar(150) collate utf8_unicode_ci NOT NULL,
  `listOrder` tinyint(2) unsigned default '0',
  `name` varchar(150) collate utf8_unicode_ci NOT NULL,
  `val` varchar(150) collate utf8_unicode_ci NOT NULL,
  KEY `var` (`var`,`val`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `opl_prefFormParam`
--

LOCK TABLES `opl_prefFormParam` WRITE;
/*!40000 ALTER TABLE `opl_prefFormParam` DISABLE KEYS */;
INSERT INTO `opl_prefFormParam` VALUES ('allowOverdue',0,'override automatically without approval','2'),('allowOverdue',0,'override with question','1'),('allowOverdue',0,'no override','0'),('autoAdd2NewItemList',0,'On','1'),('autoAdd2NewItemList',1,'Off','0'),('autoUpdateUnion',0,'Enable','1'),('autoUpdateUnion',1,'Disable','0'),('barcodeType',0,'default','0'),('barcodeType',0,'Follett','1'),('barcodeType',0,'Spectrum','2'),('barcodeType',0,'Alexandria-Leading Zeros','3'),('bibformat',0,'APA','apa'),('bibformat',0,'MLA','mla'),('bibformat',0,'Shelf','shelf'),('bibTimeclear',0,'minute','m'),('bibTimeclear',1,'hour','h'),('bibTimeclear',2,'day','d'),('charge_damage',0,'On','1'),('charge_damage',1,'Off','0'),('charge_lost',0,'On','1'),('charge_lost',1,'Off','0'),('charge_overdue',0,'On','1'),('charge_overdue',1,'Off','0'),('circulationSound',0,'On','1'),('circulationSound',1,'Off','0'),('defaultSearchPage',0,'standard','0'),('defaultSearchPage',0,'beginner','1'),('defaultSearchPage',0,'advance','2'),('defaultSearchPage',0,'OWL Beginner Interface','3'),('equipmentMgmnt',0,'Enable','1'),('equipmentMgmnt',1,'Disable','0'),('fine',0,'On','1'),('fine',1,'Off','0'),('lang',0,'English','en'),('lang',0,'French','fr'),('multilingual',0,'On','1'),('multilingual',1,'Off','0'),('OWLBgSrchFields',2,'author','author'),('OWLBgSrchFields',0,'keyword','keyword'),('OWLBgSrchFields',1,'title','title'),('patronItemPrivacy',0,'On','1'),('patronItemPrivacy',1,'Off','0'),('rating',0,'disable the reader rating item','0'),('rating',0,'enable the reader rating item in expand record page','1'),('rating',0,'enable the reader rating item in search result and expand record pages','2'),('showARL',0,'On','1'),('showARL',1,'Off','0'),('showBeginnerSrch',0,'Hide all','0'),('showBeginnerSrch',0,'Show all','1'),('showBeginnerSrch',0,'show Beginner only','2'),('showBeginnerSrch',0,'show OWL beginner only','3'),('showLocation',0,'On','1'),('showLocation',1,'Off','0'),('showPathfinder',0,'On','1'),('showPathfinder',1,'Off','0'),('textbookChargeDamage',0,'On','1'),('textbookChargeDamage',1,'Off','0'),('textbookChargeLost',0,'On','1'),('textbookChargeLost',1,'Off','0'),('textbookChargeOverdue',0,'On','1'),('textbookChargeOverdue',1,'Off','0'),('textbookFine',0,'On','1'),('textbookFine',1,'Off','0'),('textbookMgmnt',0,'Enable','1'),('textbookMgmnt',1,'Disable','0'),('timeclear',0,'minute','m'),('timeclear',1,'hour','h'),('timeclear',2,'day','d'),('timeout',0,'minute','m'),('timeout',1,'hour','h'),('timeout',2,'day','d'),('unionCircUpdate',0,'Enable','1'),('unionCircUpdate',1,'Disable','0'),('useHolidays',0,'exclude holidays in circulation','1'),('useHolidays',0,'include holidays as working days in circulation','0'),('validateBarcode',0,'Enable','1'),('validateBarcode',1,'Disable','0'),('timezone',13,'(GMT  0.0) Western Europe Time, London, Lisbon, Casablanca','Europe/London'),('timezone',14,'(GMT +1.0) Brussels, Copenhagen, Madrid, Paris','Europe/Brussels'),('timezone',24,'(GMT +10.0) Eastern Australia, Guam, Vladivostok','Australia/Sydney'),('timezone',25,'(GMT +11.0) Magadan, Solomon Islands, New Caledonia','Asia/Magadan'),('timezone',26,'(GMT +12.0) Auckland, Wellington, Fiji, Kamchatka','Pacific/Fiji'),('timezone',15,'(GMT +2.0) Kaliningrad, South Africa','Europe/Kaliningrad'),('timezone',16,'(GMT +3.0) Baghdad, Riyadh, Moscow, St. Petersburg','Europe/Moscow'),('timezone',16,'(GMT +3.5) Tehran','Asia/Tehran'),('timezone',17,'(GMT +4.0) Abu Dhabi, Muscat, Baku, Tbilisi','Asia/Baku'),('timezone',17,'(GMT +4.5) Kabul','Asia/Kabul'),('timezone',18,'(GMT +5.0) Ekaterinburg, Islamabad, Karachi, Tashkent','Asia/Karachi'),('timezone',18,'(GMT +5.5) Bombay, Calcutta, Madras, New Delhi','Indian/Maldives'),('timezone',19,'(GMT +6.0) Almaty, Dhaka, Colombo','Asia/Almaty'),('timezone',20,'(GMT +7.0) Bangkok, Hanoi, Jakarta','Asia/Bangkok'),('timezone',21,'(GMT +8.0) Beijing, Perth, Singapore, Hong Kong','Asia/Hong_Kong'),('timezone',22,'(GMT +9.0) Tokyo, Seoul, Osaka, Sapporo, Yakutsk','Asia/Tokyo'),('timezone',23,'(GMT +9.5) Adelaide, Darwin','Australia/Adelaide'),('timezone',12,'(GMT -1.0) Azores, Cape Verde Islands','Atlantic/Azores'),('timezone',2,'(GMT -10.0) Hawaii','Pacific/Honolulu'),('timezone',1,'(GMT -11.0) Midway Island, Samoa','Pacific/Midway'),('timezone',0,'(GMT -12.0) Eniwetok, Kwajalein','Pacific/Kwajalein'),('timezone',11,'(GMT -2.0) Mid-Atlantic','America/Noronha'),('timezone',9,'(GMT -3.0) Brazil, Buenos Aires, Georgetown','America/Sao_Paulo'),('timezone',10,'(GMT -3.5) Newfoundland','America/St_Johns'),('timezone',8,'(GMT -4.0) Atlantic Time (Canada), Caracas, La Paz','America/Caracas'),('timezone',7,'(GMT -5.0) Eastern Time (US &amp; Canada), Bogota, Lima','America/Montreal'),('timezone',7,'(GMT -5.0) Jamaica, Lima, Peru, Panama','America/Jamaica'),('timezone',6,'(GMT -6.0) Central Time (US &amp; Canada), Mexico City','America/Chicago'),('timezone',5,'(GMT -7.0) Mountain Time (US &amp; Canada)','America/Edmonton'),('timezone',4,'(GMT -8.0) Pacific Time (US &amp; Canada)','America/Vancouver'),('timezone',3,'(GMT -9.0) Alaska','America/Anchorage'),('OWLBgSrchFields',3,'subject','subject');
/*!40000 ALTER TABLE `opl_prefFormParam` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2010-06-14 15:56:57
