/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.14-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: tarvos    Database: tmp
-- ------------------------------------------------------
-- Server version	10.11.14-MariaDB-0+deb12u2

/*!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 utf8mb4 */;
/*!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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `opl_prefFormParam` (
  `var` varchar(150) NOT NULL,
  `listOrder` tinyint(2) unsigned DEFAULT 0,
  `name` varchar(150) NOT NULL,
  `val` varchar(150) NOT NULL,
  UNIQUE KEY `var` (`var`,`val`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 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'),
('allowOutstandingBalance',0,'no override','0'),
('allowOutstandingBalance',1,'override with question','1'),
('allowOutstandingBalance',2,'override automatically without approval','2'),
('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'),
('barcodeType',0,'Sagebrush','4'),
('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'),
('circulationVoice',0,'On','1'),
('circulationVoice',1,'Off','0'),
('parentTxnNotification',0,'Off','0'),
('parentTxnNotification',1,'On','1'),
('allowSelfRenewal',0,'On','1'),
('allowSelfRenewal',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',1,'French','fr'),
('lang',2,'Spanish','es'),
('lang',3,'Portuguese','pt'),
('lang',4,'Arabic','ar'),
('lang',6,'Czech','cz'),
('lang',5,'Russian','ru'),
('multilingual',0,'English','en'),
('multilingual',1,'French','fr'),
('multilingual',2,'Spanish','es'),
('multilingual',3,'Portuguese','pt'),
('multilingual',4,'Arabic','ar'),
('multilingual',5,'Russian','ru'),
('multilingual',6,'Czech','cz'),
('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,'Lexile','Lexile'),
('showARL',1,'Fountas & Pinnell','FP'),
('showARL',2,'Accelerated Reader','AR'),
('showARL',3,'Reading Counts','RC'),
('showARL',4,'Suggested Grade Level','suggestGrdLvl'),
('ARL_auto_update',0,'Lexile','Lexile'),
('ARL_auto_update',1,'Accelerated Reader','AR'),
('showMediaFormatFilter',0,'Enable','1'),
('showMediaFormatFilter',1,'Disable','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'),
('ILL_Messaging',0,'Enable','1'),
('ILL_Messaging',1,'Disable','0'),
('ILLFilter',0,'All ILLs',''),
('ILLFilter',1,'Open ILLs','bOpen'),
('ILLFilter',2,'Open or filled ILLs','bOpen|lFilled'),
('useHolidays',0,'Extend loan period a day for each holiday','1'),
('useHolidays',1,'Count holiday as part of loan period','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'),
('defaultSearchResultSort',0,'Publication date','31'),
('defaultSearchResultSort',1,'Title','4'),
('defaultSearchResultSort',2,'Author','1003'),
('defaultSearchResultSort',3,'Callnumber','5001'),
('defaultSearchResultSort',4,'Location','8008'),
('defaultSearchResultSort',5,'Relevance','0'),
('bookingReserve',0,'On','1'),
('bookingReserve',1,'Off','0'),
('googlePreview',0,'On','1'),
('googlePreview',1,'Off','0'),
('selfcreateAccount',1,'Off','0'),
('selfcreateAccount',0,'On','1'),
('hit_counter',0,'On','1'),
('hit_counter',1,'Off','0'),
('classificationSystem',0,'Dewey Decimal System','dewey'),
('classificationSystem',1,'Library of Congress classification','LCC'),
('classificationSystem',2,'Elazar Classification System','Elazar'),
('disableLibCat',0,'No ','0'),
('disableLibCat',1,'Yes','1'),
('OpacLoginRequired',0,'No login required','0'),
('OpacLoginRequired',1,'Login required','1'),
('slipPrinter',0,'Disable','0'),
('slipPrinter',1,'Enable','1'),
('unionExportExcludeTypes',1,'Book','book'),
('unionExportExcludeTypes',2,'Book Manuscript','bookManuscript'),
('unionExportExcludeTypes',3,'Ebook','ebook'),
('unionExportExcludeTypes',4,'Journal','journal'),
('unionExportExcludeTypes',5,'Serial','serial'),
('unionExportExcludeTypes',6,'Electronic Media','electronicMedia'),
('unionExportExcludeTypes',7,'Internet','internet'),
('unionExportExcludeTypes',8,'Compact Disc','compactDisc'),
('unionExportExcludeTypes',9,'Map','map'),
('unionExportExcludeTypes',10,'Map Manuscript','mapManuscript'),
('unionExportExcludeTypes',11,'Book On Tape','bookOnTape'),
('unionExportExcludeTypes',13,'Music Cassette','musicCassette'),
('unionExportExcludeTypes',14,'CD Music','CDMusic'),
('unionExportExcludeTypes',15,'Manuscript Music','manuscriptMusic'),
('unionExportExcludeTypes',16,'Sheet Music','sheetMusic'),
('unionExportExcludeTypes',17,'Artifact','artifact'),
('unionExportExcludeTypes',18,'Photo Poster','photoPoster'),
('unionExportExcludeTypes',19,'Library Kit','libraryKit'),
('unionExportExcludeTypes',20,'Mixed Material','mixedMaterial'),
('unionExportExcludeTypes',21,'Movie','movie'),
('unionExportExcludeTypes',22,'Video cassette','videocassette'),
('unionExportExcludeTypes',23,'DVD','DVD'),
('unionExportExcludeTypes',24,'Blu-ray','blu_ray'),
('unionExportExcludeTypes',25,'PDF','pdf'),
('ebookModule',0,'Enable','1'),
('ebookModule',1,'Disable','0'),
('showLocationFilter',0,'Enable','1'),
('showLocationFilter',1,'Disable','0'),
('libraryType',1,'k-12','k-12'),
('libraryType',2,'College/University','academy'),
('libraryType',3,'Public Library','public'),
('libraryType',4,'Database Subcription','subscription'),
('selfcheck',0,'On','1'),
('selfcheck',1,'Off','0'),
('hideMobileVersionOpt',0,'No','0'),
('hideMobileVersionOpt',1,'Yes','1'),
('showQRCode',0,'on','1'),
('showQRCode',1,'off','0'),
('searchResultDisplay',0,'List view','list'),
('searchResultDisplay',1,'Gallery view','gallery'),
('reservationSysType',0,'Basic reserve system','0'),
('reservationSysType',1,'enhanced request reserve management system','1'),
('SIF_enable',0,'disable','0'),
('SIF_enable',1,'enable','1'),
('SIF_version',0,'2.0r1','2.0r1'),
('SIF_version',1,'2.4','2.4'),
('preDueNotice',0,'off','0'),
('preDueNotice',1,'1 day','1'),
('preDueNotice',2,'2 days','2'),
('preDueNotice',3,'3 days','3'),
('preDueNotice',4,'4 days','4'),
('preDueNotice',5,'5 days','5'),
('preDueNotice',6,'6 days','6'),
('preDueNotice',7,'7 days','7'),
('preDueNotice',8,'8 days','8'),
('preDueNotice',9,'9 days','9'),
('preDueNotice',10,'10 days','10'),
('showGenre',0,'On','1'),
('showGenre',1,'Off','0'),
('anonymizeLoan',0,'off','0'),
('anonymizeLoan',1,'upon return','-1'),
('anonymizeLoan',2,'after 5 days','5'),
('anonymizeLoan',3,'after 10 days','10'),
('anonymizeLoan',4,'after 30 days','30'),
('anonymizeLoan',5,'after 60 days','60'),
('anonymizeLoan',6,'after 90 days','90'),
('anonymizeLoan',7,'after 120 days','120'),
('anonymizeLoan',8,'after 180 days','180'),
('anonymizeLoan',9,'after 1 year','365'),
('anonymizeLoan',10,'after 2 years','730'),
('anonymizeLoan',11,'after 3 years','1095'),
('anonymizeLoan',12,'prior to current school year','1000000'),
('tbAnonymizeLoan',0,'off','0'),
('tbAnonymizeLoan',1,'after 30 days','30'),
('tbAnonymizeLoan',2,'after 60 days','60'),
('tbAnonymizeLoan',3,'after 90 days','90'),
('tbAnonymizeLoan',4,'after 120 days','120'),
('tbAnonymizeLoan',5,'after 180 days','180'),
('tbAnonymizeLoan',6,'after 1 year','365'),
('tbAnonymizeLoan',7,'after 2 years','730'),
('tbAnonymizeLoan',8,'after 3 years','1095'),
('tbAnonymizeLoan',15,'prior to current school year','1000000'),
('eqAnonymizeLoan',0,'off','0'),
('eqAnonymizeLoan',1,'after 30 days','30'),
('eqAnonymizeLoan',2,'after 60 days','60'),
('eqAnonymizeLoan',3,'after 90 days','90'),
('eqAnonymizeLoan',4,'after 120 days','120'),
('eqAnonymizeLoan',5,'after 180 days','180'),
('eqAnonymizeLoan',6,'after 1 year','365'),
('eqAnonymizeLoan',7,'after 2 years','730'),
('eqAnonymizeLoan',8,'after 3 years','1095'),
('eqAnonymizeLoan',15,'prior to current school year','1000000'),
('equipmentOverdueDisplay',0,'Off','0'),
('equipmentOverdueDisplay',1,'On','1'),
('textbookOverdueDisplay',0,'Off','0'),
('textbookOverdueDisplay',1,'On','1'),
('renewalPolicy',0,'renewal from the date the renewal is requested','0'),
('renewalPolicy',1,'renewal from the due date','1'),
('reportGroup',1,'homeroom','1'),
('reportGroup',2,'teacher','2'),
('reportGroup',3,'grade','3'),
('reportGroup',4,'phone','4'),
('reportGroup',5,'student ID','5'),
('showTeachingBooksLink',0,'Show','1'),
('showTeachingBooksLink',1,'Hide','0'),
('preDueNotice_recipient',0,'student','toStudent'),
('preDueNotice_recipient',1,'guardians/parents','toGuardian'),
('libraryOnLoanDisplayInEQ',0,'Off','0'),
('libraryOnLoanDisplayInEQ',1,'On','1'),
('libraryOnLoanDisplayInTB',0,'Off','0'),
('libraryOnLoanDisplayInTB',1,'On','1'),
('userDataOverwriten',0,'User data will be imported only when there are changes in the CSV file','0'),
('userDataOverwriten',1,'User data will ALWAYS be overwriten each time the auto-import task runs','1'),
('showNoveListLink',1,'Hide','0'),
('showNoveListLink',0,'Show','1'),
('equipmentFine',0,'On','1'),
('equipmentFine',1,'Off','0'),
('equipmentChargeDamage',0,'On','1'),
('equipmentChargeDamage',1,'Off','0'),
('equipmentChargeLost',0,'On','1'),
('equipmentChargeLost',1,'Off','0'),
('equipmentChargeOverdue',0,'On','1'),
('equipmentChargeOverdue',1,'Off','0'),
('prepTimeRq4booking',0,'0','0'),
('prepTimeRq4booking',1,'1','1'),
('prepTimeRq4booking',2,'2','2'),
('prepTimeRq4booking',3,'3','3'),
('prepTimeRq4booking',4,'4','4'),
('prepTimeRq4booking',5,'5','5'),
('prepTimeRq4booking',6,'6','6'),
('prepTimeRq4booking',7,'7','7'),
('prepTimeRq4booking',8,'8','8'),
('prepTimeRq4booking',9,'9','9'),
('prepTimeRq4booking',10,'10','10'),
('ldapAuthentication',0,'Off','0'),
('ldapAuthentication',1,'On','1'),
('googleSignin',0,'Off','0'),
('googleSignin',1,'On','1'),
('samlSSO',0,'Off','0'),
('samlSSO',1,'On','1'),
('classlinkSSO',0,'Off','0'),
('classlinkSSO',1,'On','1'),
('useAttOrder',24,'Medium ','5002'),
('useAttOrder',23,'Local call number','5001'),
('useAttOrder',22,'Barcode ','5000'),
('useAttOrder',21,'Publisher','1018'),
('useAttOrder',13,'Date of publication','31'),
('useAttOrder',14,'Place of publication','59'),
('useAttOrder',25,'Title begins with','5006'),
('useAttOrder',26,'Awards','8026'),
('useAttOrder',20,'Anywhere (exact match) ','9016'),
('useAttOrder',19,'Anywhere ','1016'),
('useAttOrder',15,'Note','63'),
('useAttOrder',16,'Author keyword','1003'),
('useAttOrder',17,'Author (personal) ','1004'),
('useAttOrder',18,'Author (corporate)','1005'),
('useAttOrder',1,'Title','4'),
('useAttOrder',2,'Title (exact match)','9004'),
('useAttOrder',3,'Series title','5'),
('useAttOrder',4,'Uniform title','6'),
('useAttOrder',5,'ISBN','7'),
('useAttOrder',6,'ISSN','8'),
('useAttOrder',7,'LC control number','9'),
('useAttOrder',8,'Record ID','12'),
('useAttOrder',9,'Dewey','13'),
('useAttOrder',10,'LC classification','16'),
('useAttOrder',11,'Subject','21'),
('useAttOrder',12,'Subject (exact match)','9021'),
('useAttOrder',27,'Location','8008'),
('overwrittenByBarcode',0,'Merge/overwrite on User ID','0'),
('overwrittenByBarcode',1,'Merge/overwrite on User barcode','1'),
('refineSearchfields',1,'Location','location'),
('refineSearchfields',2,'Language','language'),
('refineSearchfields',3,'Author','author'),
('refineSearchfields',4,'Format','format'),
('refineSearchfields',5,'Subject','subject'),
('refineSearchfields',6,'Prefix','callnumberPrefix'),
('refineSearchfields',7,'Dewey','dewey'),
('refineSearchfields',8,'Classification Number ','lccGrp'),
('refineSearchfields',9,'Era','era'),
('refineSearchfields',10,'Genre','genre'),
('refineSearchfields',11,'BISAC','bisac'),
('refineSearchfields',12,'Lexile Measure ','lexileMeasure'),
('refineSearchfields',13,'Fountas Pinnell','fountasPinnell'),
('refineSearchfields',14,'Elazar','elazar'),
('refineSearchfields',15,'Suggested Grade Level','suggestGrdLvl'),
('briefRecFields_bgn',1,'Title','titleFull'),
('briefRecFields_bgn',2,'Series title','title_series_a'),
('briefRecFields_bgn',3,'Author','author'),
('briefRecFields_bgn',4,'Publisher','namePublisher'),
('briefRecFields_bgn',5,'Pub. date','datePublication'),
('briefRecFields_bgn',6,'Pub. place','placePublication'),
('briefRecFields_bgn',7,'Callnumber','callNum1St'),
('briefRecFields_bgn',8,'Location','location'),
('briefRecFields_bgn',9,'Date import','dateImport'),
('briefRecFields_bgn',10,'Circ. status','circStatus'),
('briefRecFields_bgn',11,'Lexile','lexileMeasure'),
('briefRecFields_bgn',12,'Fountas Pinnell','fountasPinnell'),
('briefRecFields_bgn',13,'Study Program','studyPrgm'),
('briefRecFields_bgn',14,'Pathfinders','pf'),
('briefRecFields_bgn',15,'Genre Collection','genreList'),
('briefRecFields_bgn',15,'Reserve Shelf','reserveShelf'),
('briefRecFields',1,'Title','titleFull'),
('briefRecFields',2,'Series title','title_series_a'),
('briefRecFields',3,'Author','author'),
('briefRecFields',4,'Publisher','namePublisher'),
('briefRecFields',5,'Pub. date','datePublication'),
('briefRecFields',6,'Pub. place','placePublication'),
('briefRecFields',7,'Callnumber','callNum1St'),
('briefRecFields',8,'Location','location'),
('briefRecFields',9,'Date import','dateImport'),
('briefRecFields',10,'Circ. status','circStatus'),
('briefRecFields',11,'Lexile','lexileMeasure'),
('briefRecFields',12,'Fountas Pinnell','fountasPinnell'),
('briefRecFields',13,'Study Program','studyPrgm'),
('briefRecFields',14,'Pathfinders','pf'),
('briefRecFields',15,'Genre Collection','genreList'),
('briefRecFields',16,'Reserve Shelf','reserveShelf'),
('briefRecFields',17,'Suggested Grade Level','suggestGrdLvl'),
('srchMediaFormatOrder',1,'Book','book'),
('srchMediaFormatOrder',2,'eBook','ebook'),
('srchMediaFormatOrder',3,'Manuscript Book','bookManuscript'),
('srchMediaFormatOrder',4,'Journal','journal'),
('srchMediaFormatOrder',5,'Serial','serial'),
('srchMediaFormatOrder',6,'Electronic Media','electronicMedia'),
('srchMediaFormatOrder',7,'Internet','internet'),
('srchMediaFormatOrder',8,'Compact Disc','compactDisc'),
('srchMediaFormatOrder',9,'Map','map'),
('srchMediaFormatOrder',10,'Manuscript Map','mapManuscript'),
('srchMediaFormatOrder',11,'Audiobook','bookOnTape'),
('srchMediaFormatOrder',12,'Music Cassette','musicCassette'),
('srchMediaFormatOrder',13,'CD Music','CDMusic'),
('srchMediaFormatOrder',14,'Manuscript Music','manuscriptMusic'),
('srchMediaFormatOrder',15,'Sheet Music','sheetMusic'),
('srchMediaFormatOrder',16,'Artifact','artifact'),
('srchMediaFormatOrder',17,'Photo, Poster','photoPoster'),
('srchMediaFormatOrder',18,'Library Kit','libraryKit'),
('srchMediaFormatOrder',19,'Mixed Material','mixedMaterial'),
('srchMediaFormatOrder',20,'Movie','movie'),
('srchMediaFormatOrder',21,'Video Cassette','videocassette'),
('srchMediaFormatOrder',22,'DVD','DVD'),
('srchMediaFormatOrder',23,'Blu ray','blu_ray'),
('srchMediaFormatOrder',24,'PDF','pdf'),
('autoRegUsedInHouse',0,'Off','0'),
('autoRegUsedInHouse',1,'On','1'),
('OD_emailScheduler',1,'Off','0'),
('OD_emailScheduler',2,'1 days','1'),
('OD_emailScheduler',3,'2 days','2'),
('OD_emailScheduler',4,'3 days','3'),
('OD_emailScheduler',5,'4 days','4'),
('OD_emailScheduler',6,'5 days','5'),
('OD_emailScheduler',7,'6 days','6'),
('OD_emailScheduler',8,'7 days','7'),
('OD_emailScheduler',9,'8 days','8'),
('OD_emailScheduler',10,'9 days','9'),
('OD_emailScheduler',11,'10 days','10'),
('currency',2,'USD - United States Dollar','USD:$'),
('currency',3,'CAD - Canada Dollar','CAD:$'),
('currency',4,'ALL - Albania Lek','ALL:Lek'),
('currency',5,'AFN - Afghanistan Afghani','AFN:؋'),
('currency',6,'ARS - Argentina Peso','ARS:$'),
('currency',7,'AWG - Aruba Guilder','AWG:'),
('currency',8,'AUD - Australia Dollar','AUD:$'),
('currency',9,'AZN - Azerbaijan New Manat','AZN:ман'),
('currency',10,'BSD - Bahamas Dollar','BSD:$'),
('currency',11,'BBD - Barbados Dollar','BBD:$'),
('currency',12,'BYR - Belarus Ruble','BYR:p.'),
('currency',13,'BZD - Belize Dollar','BZD:BZ$'),
('currency',14,'BMD - Bermuda Dollar','BMD:$'),
('currency',15,'BOB - Bolivia Bolíviano','BOB:$b'),
('currency',16,'BAM - Bosnia and Herzegovina Convertible Marka','BAM:KM'),
('currency',17,'BWP - Botswana Pula','BWP:P'),
('currency',18,'BGN - Bulgaria Lev','BGN:лв'),
('currency',19,'BRL - Brazil Real','BRL:R$'),
('currency',20,'BND - Brunei Darussalam Dollar','BND:$'),
('currency',21,'KHR - Cambodia Riel','KHR:៛'),
('currency',22,'KYD - Cayman Islands Dollar','KYD:$'),
('currency',23,'CLP - Chile Peso','CLP:$'),
('currency',24,'CNY - China Yuan Renminbi','CNY:¥'),
('currency',25,'COP - Colombia Peso','COP:$'),
('currency',26,'CRC - Costa Rica Colon','CRC:₡'),
('currency',27,'HRK - Croatia Kuna','HRK:kn'),
('currency',28,'CUP - Cuba Peso','CUP:₱'),
('currency',29,'CZK - Czech Republic Koruna','CZK:Kč'),
('currency',30,'DKK - Denmark Krone','DKK:kr'),
('currency',31,'DOP - Dominican Republic Peso','DOP:RD$'),
('currency',32,'XCD - East Caribbean Dollar','XCD:$'),
('currency',33,'EGP - Egypt Pound','EGP:£'),
('currency',34,'SVC - El Salvador Colon','SVC:$'),
('currency',34,'SZL - Emalangeni','SZL'),
('currency',35,'EUR - Euro Member Countries','EUR:€'),
('currency',36,'FKP - Falkland Islands (Malvinas) Pound','FKP:£'),
('currency',37,'FJD - Fiji Dollar','FJD:$'),
('currency',38,'GHS - Ghana Cedi','GHS:¢'),
('currency',39,'GIP - Gibraltar Pound','GIP:£'),
('currency',40,'GTQ - Guatemala Quetzal','GTQ:Q'),
('currency',41,'GGP - Guernsey Pound','GGP:£'),
('currency',42,'GYD - Guyana Dollar','GYD:$'),
('currency',43,'HNL - Honduras Lempira','HNL:L'),
('currency',44,'HKD - Hong Kong Dollar','HKD:$'),
('currency',45,'HTG - Haitien Gourdes','HTG:htg'),
('currency',45,'HUF - Hungary Forint','HUF:Ft'),
('currency',46,'ISK - Iceland Krona','ISK:kr'),
('currency',47,'INR - India Rupee','INR:'),
('currency',48,'IDR - Indonesia Rupiah','IDR:Rp'),
('currency',49,'IRR - Iran Rial','IRR:﷼'),
('currency',50,'IMP - Isle of Man Pound','IMP:£'),
('currency',51,'ILS - Israel Shekel','ILS:'),
('currency',52,'JMD - Jamaica Dollar','JMD:J$'),
('currency',53,'JPY - Japan Yen','JPY:¥'),
('currency',54,'JEP - Jersey Pound','JEP:£'),
('currency',54,'JOD - Jordanian Dinar','JOD'),
('currency',55,'KZT - Kazakhstan Tenge','KZT:лв'),
('currency',56,'KPW - Korea (North) Won','KPW:₩'),
('currency',57,'KRW - Korea (South) Won','KRW:₩'),
('currency',58,'KGS - Kyrgyzstan Som','KGS:лв'),
('currency',59,'LAK - Laos Kip','LAK:'),
('currency',60,'LBP - Lebanon Pound','LBP:£'),
('currency',61,'LRD - Liberia Dollar','LRD:$'),
('currency',62,'MKD - Macedonia Denar','MKD:ден'),
('currency',63,'MYR - Malaysia Ringgit','MYR:RM'),
('currency',64,'MUR - Mauritius Rupee','MUR:₨'),
('currency',65,'MXN - Mexico Peso','MXN:$'),
('currency',66,'MNT - Mongolia Tughrik','MNT:₮'),
('currency',67,'MZN - Mozambique Metical','MZN:MT'),
('currency',68,'Kyat - MMK','Kyat:Ks'),
('currency',69,'NAD - Namibia Dollar','NAD:$'),
('currency',70,'NPR - Nepal Rupee','NPR:₨'),
('currency',71,'ANG - Netherlands Antilles Guilder','ANG:'),
('currency',72,'NZD - New Zealand Dollar','NZD:$'),
('currency',73,'NIO - Nicaragua Cordoba','NIO:C$'),
('currency',74,'NGN - Nigeria Naira','NGN:₦'),
('currency',76,'NOK - Norway Krone','NOK:kr'),
('currency',77,'OMR - Oman Rial','OMR:﷼'),
('currency',78,'PKR - Pakistan Rupee','PKR:₨'),
('currency',79,'PAB - Panama Balboa','PAB:B/.'),
('currency',80,'PGK - Papua New Guinea Kina','PGK:K'),
('currency',81,'PYG - Paraguay Guarani','PYG:Gs'),
('currency',82,'PEN - Peru Sol','PEN:S/.'),
('currency',83,'PHP - Philippines Peso','PHP:₱'),
('currency',84,'PLN - Poland Zloty','PLN:zł'),
('currency',85,'QAR - Qatar Riyal','QAR:﷼'),
('currency',86,'RON - Romania New Leu','RON:lei'),
('currency',87,'RUB - Russia Ruble','RUB:руб'),
('currency',88,'SHP - Saint Helena Pound','SHP:£'),
('currency',89,'SAR - Saudi Arabia Riyal','SAR:﷼'),
('currency',90,'RSD - Serbia Dinar','RSD:Дин.'),
('currency',91,'SCR - Seychelles Rupee','SCR:₨'),
('currency',92,'SGD - Singapore Dollar','SGD:$'),
('currency',93,'SBD - Solomon Islands Dollar','SBD:$'),
('currency',94,'SOS - Somalia Shilling','SOS:S'),
('currency',95,'ZAR - South Africa Rand','ZAR:R'),
('currency',97,'LKR - Sri Lanka Rupee','LKR:₨'),
('currency',98,'SEK - Sweden Krona','SEK:kr'),
('currency',99,'CHF - Switzerland Franc','CHF:CHF'),
('currency',100,'SRD - Suriname Dollar','SRD:$'),
('currency',101,'SYP - Syria Pound','SYP:£'),
('currency',102,'TWD - Taiwan New Dollar','TWD:NT$'),
('currency',103,'THB - Thailand Baht','THB:฿'),
('currency',104,'TTD - Trinidad and Tobago Dollar','TTD:TT$'),
('currency',105,'TRY - Turkey Lira','TRY:'),
('currency',106,'TVD - Tuvalu Dollar','TVD:$'),
('currency',107,'UAH - Ukraine Hryvnia','UAH:₴'),
('currency',108,'GBP - United Kingdom Pound','GBP:£'),
('currency',109,'UYU - Uruguay Peso','UYU:$U'),
('currency',110,'UZS - Uzbekistan Som','UZS:лв'),
('currency',111,'VEF - Venezuela Bolivar','VEF:Bs'),
('currency',112,'VND - Viet Nam Dong','VND:₫'),
('currency',113,'YER - Yemen Rial','YER:﷼'),
('currency',114,'ZWD - Zimbabwe Dollar','ZWD:Z$');
/*!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 2026-06-09  9:03:38
