insert into opl_user 
    (username, password, firstname, lastname, created, pw_timestamp, permission,permissions, status) 
    values 
    ('admin', 'X6M5u7se6s7TtS5U9EV2qvDXfZY', 'Admin', 'Library', now(), now(), 'yyyyyyyyyyyyyyyyyyyy','user_add,user_delete,user_edit,user_permEdit,pref_edit,bibsrc,circ_ill_filter,circ_loan,circ_return,circ_rsrv,circ_rsrv_self,notice,payment,ebook_mgmt,genre,pf,rating,rsrv_shelf,marc_add,marc_del,marc_edit,marc_export,marc_merge,tb_record_edit,tb_circ_loan,tb_circ_return,tb_circ_rsrv,tb_circ_rsrv_self,tb_fine,tb_notice,tb_report,tb_course_edit,eq_record_edit,eq_circ_loan,eq_circ_return,eq_circ_rsrv,eq_circ_rsrv_self,eq_report,rpt_catRec,rpt_circ,rpt_fine,rpt_notice,rpt_user,fine,fine_edit,fine_waive,tb_user_edit,eq_rpt_circ,tb_rpt_circ', 1);

insert into opl_zDatabase (name, description) 
    values
    (database(), 'My Library');
--    (database(), concat(upper(database()), ' Server'));
update opl_zDatabase set zid=zid-1;
insert into opl_zDatabase (name, description, host, port, syntax, encoding, state, stateList) 
    values
    ('union', 'SCOOLS Union (NYS)', 'scools.org', 210, 0, 'utf8', 0, 1),
    ('LCDB', 'Library of Congress', 'lx2.loc.gov', 210, 1, 'marc8', 0, 1),
    ('INNOPAC', 'OhioLink', 'olc1.ohiolink.edu', 210, 1, 'marc8', 0, 1),
    ('edemo_tres', 'OPALS Ebook database', 'tres.demo.kari.opalsinfo.net', 210, 1, 'utf8', 0, 1);

insert into opl_category (catname, maxloans, maxreserv,allowUserEdit,defaultPerm) values
    ('Staff', 20, 0,'0','user_add,user_delete,user_edit,user_permEdit,pref_edit,bibsrc,circ_ill_filter,circ_loan,circ_return,circ_rsrv,circ_rsrv_self,notice,payment,ebook_mgmt,genre,pf,rating,rsrv_shelf,marc_add,marc_del,marc_edit,marc_export,marc_merge,tb_record_edit,tb_circ_loan,tb_circ_return,tb_circ_rsrv,tb_circ_rsrv_self,tb_fine,tb_notice,tb_report,tb_course_edit,eq_record_edit,eq_circ_loan,eq_circ_return,eq_circ_rsrv,eq_circ_rsrv_self,eq_report,rpt_catRec,rpt_circ,rpt_fine,rpt_notice,rpt_user,fine,fine_edit,fine_waive,tb_user_edit,eq_rpt_circ,tb_rpt_circ');


insert into opl_category (catname, maxloans, maxreserv,defaultPerm) 
    values
    ('Student', 6, 0,'circ_rsrv_self'),
    ('Faculty', 40, 0,'circ_rsrv_self'),
    ('Inter Library Loan', 50, 0,''),
    ('Other', 2, 0,''),
    ('Non-circ', 99, 0,'');

INSERT INTO `opl_itemCategory` 
    VALUES 
    (1,'Library'),(2,'Textbook'),(3,'Equipment');

insert into opl_itemType (id, description, defaultType) 
    values
    ('G', 'General', 1),
    ('E-book', '', 1);

insert into opl_itemTypeParam (itemTypeId, userTypeId, loanPeriod, renewalPeriod, reservePeriod, holdPeriod, gracePeriod, maxRenewal,maxItemLoan) 
    values
    ('G', 1, 240, 240, 240, 240, 240, 10,6),
    ('G', 2, 240, 240, 240, 240, 240, 10,40),
    ('G', 3, 240, 240, 240, 240, 240, 10,20),
    ('G', 4, 240, 240, 240, 240, 240, 10,50),
    ('G', 5, 240, 240, 240, 240, 240, 10,2),
    ('G', 6, 240, 240, 240, 240, 240, 10,99),
    ('E-book', 1, 240, 240, 240, 240, 240, 10,6),
    ('E-book', 2, 240, 240, 240, 240, 240, 10,40),
    ('E-book', 3, 240, 240, 240, 240, 240, 10,20),
    ('E-book', 4, 240, 240, 240, 240, 240, 10,50),
    ('E-book', 5, 240, 240, 240, 240, 240, 10,2),
    ('E-book', 6, 240, 240, 240, 240, 240, 10,99);

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'),
    ('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',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'),
    ('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'),
    ('ILL_Messaging',0,'Enable','1'),
    ('ILL_Messaging',1,'Disable','0'),
    ('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'),
    ('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,'bookManuscript','bookManuscript'),
    ('unionExportExcludeTypes',3,'ebook','ebook'),
    ('unionExportExcludeTypes',4,'journal','journal'),
    ('unionExportExcludeTypes',5,'serial','serial'),
    ('unionExportExcludeTypes',6,'electronicMedia','electronicMedia'),
    ('unionExportExcludeTypes',7,'internet','internet'),
    ('unionExportExcludeTypes',8,'compactDisc','compactDisc'),
    ('unionExportExcludeTypes',9,'map','map'),
    ('unionExportExcludeTypes',10,'mapManuscript','mapManuscript'),
    ('unionExportExcludeTypes',11,'bookOnTape','bookOnTape'),
    ('unionExportExcludeTypes',13,'musicCassette','musicCassette'),
    ('unionExportExcludeTypes',14,'CDMusic','CDMusic'),
    ('unionExportExcludeTypes',15,'manuscriptMusic','manuscriptMusic'),
    ('unionExportExcludeTypes',16,'sheetMusic','sheetMusic'),
    ('unionExportExcludeTypes',17,'artifact','artifact'),
    ('unionExportExcludeTypes',18,'photoPoster','photoPoster'),
    ('unionExportExcludeTypes',19,'libraryKit','libraryKit'),
    ('unionExportExcludeTypes',20,'mixedMaterial','mixedMaterial'),
    ('unionExportExcludeTypes',21,'movie','movie'),
    ('unionExportExcludeTypes',22,'videocassette','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'),
    ('selfcheck',0,'On','1'),
    ('selfcheck',1,'Off','0'),
    ('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,'after 30 days',30),
    ('anonymizeLoan',2,'after 60 days',60),
    ('anonymizeLoan',3,'after 90 days',90),
    ('anonymizeLoan',4,'after 120 days',120),
    ('anonymizeLoan',5,'after 150 days',150),
    ('anonymizeLoan',6,'after 180 days',180),
    ('anonymizeLoan',7,'after 210 days',210),
    ('anonymizeLoan',8,'after 240 days',240),
    ('anonymizeLoan',9,'after 270 days',270),
    ('anonymizeLoan',10,'after 300 days',300),
    ('anonymizeLoan',11,'after 330 days',330),
    ('anonymizeLoan',12,'after 1 year',365),
    ('anonymizeLoan',13,'after 2 years',730),
    ('anonymizeLoan',14,'after 3 years',1095),
    ('equipmentOverdueDisplay',0,'Off',0),
    ('equipmentOverdueDisplay',1,'On',1),
    ('textbookOverdueDisplay',0,'Off',0),
    ('textbookOverdueDisplay',1,'On',1)



    ;
insert into opl_prefFormParam(var,name,val,listOrder) values
("currency","USD - United States Dollar","USD:$",1),
("currency","CAD - Canada Dollar","CAD:$",2),
("currency","ALL - Albania Lek","ALL:Lek",3),
("currency","AFN - Afghanistan Afghani","AFN:؋",4),
("currency","ARS - Argentina Peso","ARS:$",5),
("currency","AWG - Aruba Guilder","AWG:",6),
("currency","AUD - Australia Dollar","AUD:$",7),
("currency","AZN - Azerbaijan New Manat","AZN:ман",8),
("currency","BSD - Bahamas Dollar","BSD:$",9),
("currency","BBD - Barbados Dollar","BBD:$",10),
("currency","BYR - Belarus Ruble","BYR:p.",11),
("currency","BZD - Belize Dollar","BZD:BZ$",12),
("currency","BMD - Bermuda Dollar","BMD:$",13),
("currency","BOB - Bolivia Bolíviano","BOB:$b",14),
("currency","BAM - Bosnia and Herzegovina Convertible Marka","BAM:KM",15),
("currency","BWP - Botswana Pula","BWP:P",16),
("currency","BGN - Bulgaria Lev","BGN:лв",17),
("currency","BRL - Brazil Real","BRL:R$",18),
("currency","BND - Brunei Darussalam Dollar","BND:$",19),
("currency","KHR - Cambodia Riel","KHR:៛",20),
("currency","KYD - Cayman Islands Dollar","KYD:$",21),
("currency","CLP - Chile Peso","CLP:$",22),
("currency","CNY - China Yuan Renminbi","CNY:¥",23),
("currency","COP - Colombia Peso","COP:$",24),
("currency","CRC - Costa Rica Colon","CRC:₡",25),
("currency","HRK - Croatia Kuna","HRK:kn",26),
("currency","CUP - Cuba Peso","CUP:₱",27),
("currency","CZK - Czech Republic Koruna","CZK:Kč",28),
("currency","DKK - Denmark Krone","DKK:kr",29),
("currency","DOP - Dominican Republic Peso","DOP:RD$",30),
("currency","XCD - East Caribbean Dollar","XCD:$",31),
("currency","EGP - Egypt Pound","EGP:£",32),
("currency","SVC - El Salvador Colon","SVC:$",33),
("currency","EUR - Euro Member Countries","EUR:€",34),
("currency","FKP - Falkland Islands (Malvinas) Pound","FKP:£",35),
("currency","FJD - Fiji Dollar","FJD:$",36),
("currency","GHS - Ghana Cedi","GHS:¢",37),
("currency","GIP - Gibraltar Pound","GIP:£",38),
("currency","GTQ - Guatemala Quetzal","GTQ:Q",39),
("currency","GGP - Guernsey Pound","GGP:£",40),
("currency","GYD - Guyana Dollar","GYD:$",41),
("currency","HNL - Honduras Lempira","HNL:L",42),
("currency","HKD - Hong Kong Dollar","HKD:$",43),
("currency","HUF - Hungary Forint","HUF:Ft",44),
("currency","ISK - Iceland Krona","ISK:kr",45),
("currency","INR - India Rupee","INR:",46),
("currency","IDR - Indonesia Rupiah","IDR:Rp",47),
("currency","IRR - Iran Rial","IRR:﷼",48),
("currency","IMP - Isle of Man Pound","IMP:£",49),
("currency","ILS - Israel Shekel","ILS:",50),
("currency","JMD - Jamaica Dollar","JMD:J$",51),
("currency","JPY - Japan Yen","JPY:¥",52),
("currency","JEP - Jersey Pound","JEP:£",53),
("currency","JOD - Jordanian Dinar","JOD",53),
("currency","KZT - Kazakhstan Tenge","KZT:лв",54),
("currency","KPW - Korea (North) Won","KPW:₩",55),
("currency","KRW - Korea (South) Won","KRW:₩",56),
("currency","KGS - Kyrgyzstan Som","KGS:лв",57),
("currency","LAK - Laos Kip","LAK:",58),
("currency","LBP - Lebanon Pound","LBP:£",59),
("currency","LRD - Liberia Dollar","LRD:$",60),
("currency","MKD - Macedonia Denar","MKD:ден",61),
("currency","MYR - Malaysia Ringgit","MYR:RM",62),
("currency","MUR - Mauritius Rupee","MUR:₨",63),
("currency","MXN - Mexico Peso","MXN:$",64),
("currency","MNT - Mongolia Tughrik","MNT:₮",65),
("currency","MZN - Mozambique Metical","MZN:MT",66),
("currency","NAD - Namibia Dollar","NAD:$",67),
("currency","NPR - Nepal Rupee","NPR:₨",68),
("currency","ANG - Netherlands Antilles Guilder","ANG:",69),
("currency","NZD - New Zealand Dollar","NZD:$",70),
("currency","NIO - Nicaragua Cordoba","NIO:C$",71),
("currency","NGN - Nigeria Naira","NGN:₦",72),
("currency","NOK - Norway Krone","NOK:kr",74),
("currency","OMR - Oman Rial","OMR:﷼",75),
("currency","PKR - Pakistan Rupee","PKR:₨",76),
("currency","PAB - Panama Balboa","PAB:B/.",77),
("currency","PYG - Paraguay Guarani","PYG:Gs",78),
("currency","PEN - Peru Sol","PEN:S/.",79),
("currency","PHP - Philippines Peso","PHP:₱",80),
("currency","PLN - Poland Zloty","PLN:zł",81),
("currency","QAR - Qatar Riyal","QAR:﷼",82),
("currency","RON - Romania New Leu","RON:lei",83),
("currency","RUB - Russia Ruble","RUB:руб",84),
("currency","SHP - Saint Helena Pound","SHP:£",85),
("currency","SAR - Saudi Arabia Riyal","SAR:﷼",86),
("currency","RSD - Serbia Dinar","RSD:Дин.",87),
("currency","SCR - Seychelles Rupee","SCR:₨",88),
("currency","SGD - Singapore Dollar","SGD:$",89),
("currency","SBD - Solomon Islands Dollar","SBD:$",90),
("currency","SOS - Somalia Shilling","SOS:S",91),
("currency","ZAR - South Africa Rand","ZAR:R",92),
("currency","LKR - Sri Lanka Rupee","LKR:₨",94),
("currency","SEK - Sweden Krona","SEK:kr",95),
("currency","CHF - Switzerland Franc","CHF:CHF",96),
("currency","SRD - Suriname Dollar","SRD:$",97),
("currency","SYP - Syria Pound","SYP:£",98),
("currency","TWD - Taiwan New Dollar","TWD:NT$",99),
("currency","THB - Thailand Baht","THB:฿",100),
("currency","TTD - Trinidad and Tobago Dollar","TTD:TT$",101),
("currency","TRY - Turkey Lira","TRY:",102),
("currency","TVD - Tuvalu Dollar","TVD:$",103),
("currency","UAH - Ukraine Hryvnia","UAH:₴",104),
("currency","GBP - United Kingdom Pound","GBP:£",105),
("currency","UYU - Uruguay Peso","UYU:$U",106),
("currency","UZS - Uzbekistan Som","UZS:лв",107),
("currency","VEF - Venezuela Bolivar","VEF:Bs",108),
("currency","VND - Viet Nam Dong","VND:₫",109),
("currency","YER - Yemen Rial","YER:﷼",110),
("currency","ZWD - Zimbabwe Dollar","ZWD:Z$",111);

INSERT INTO `opl_prefGroup` 
    VALUES 
    (1,'General Preferences Settings'),
	(2,'Circulation Preferences Settings'),
	(3,'Overdue & Fine Management'),
	(4,'Data Import / Export Management'),
	(5,'OPAC Display Preferences Settings'),
	(6,'OPAC / Database Preferences Settings'),
	(7,'Reports Preferences Settings'),
	(8,'Local Catalog  Union Catalog Preferences Settings'),
	(9,'Additional Modules'),
    (10,'Ebook Settings'),
    (11,'SIF Agent');

INSERT INTO `opl_preference` 
    VALUES 
    ('theme','opals','opals','string','text','Theme directory',1,5,21),
    ('lang','en','English','string','select','Language directory',0,1,6),
    ('country','US','US','','text','',0,1,1),
--    ('libcode','zTest','zTest','string','text','Library code',0,1,7),
--    ('libname','OPALS Test site','OPALS Test site','String','text','',0,1,8),
    ('link1_name','OPALS School Demo','OPALS School Demo','string','text','1st primary link',0,5,14),
    ('link1_url','http://ztest.scoolaid.net/','http://ztest.scoolaid.net/','string','text','1st primary url',0,5,15),
    ('link2_name','Supported by OPALS-na.org','Supported by OPALS-na.org','string','text','2nd primary link',0,5,16),
    ('link2_url','http://opals-na.org/','http://opals-na.org/','string','text','2nd primary url',0,5,17),
    ('cssTheme','0','0','number','','CSS Overlay Theme',1,0,0),
    ('slogan','Thanks for looking at OPALS','Thanks for looking at OPALS','string','text','slogan of library',0,5,20),
    ('fdrtax','0.0','0.0','number','text','Goods and services tax (GST)',0,0,0),
    ('prvtax','0.0','0.0','number','text','Provincial/Harmonized sales tax (PST/HST)',0,0,0),
    ('fine','0','Off','integer','radio','Turn on/off fine system',0,3,2),
    ('cerf','0','0','string','text','Enable/disable CERF search',1,6,1),
    ('emailSmtp','','','','text','SMTP server',0,1,4),
    ('dateProfile','US-NY','US-NY','','text','',1,0,0),
    ('reportGroup','3,2','3,2','0,1,2,3','text','1:homeroom; 2: teacher;  3: grade; 4: phone; 5:student ID',0,7,1),
    ('odNoticeMsgTop','The following items that you borrowed from the library/media center are now past due:','','','text','',0,7,2),
    ('odNoticeMsgBottom','Please return any items that may be overdue. Thank you in advance for your cooperation.','','','text','',0,7,3),
    ('itemonloanMsgTop','Item on loan','','','text','',0,7,4),
    ('itemonloanMsgBottom','The following items are checked out.','','','text','',0,7,5),
--    ('dateFirst','2008-09-03','2008-09-03','','text','',1,0,0),
--    ('dateLast','2010-06-14','2012-06-29','','text','',1,0,0),
    ('timeout','200m','200m','string','timeLength','Session time out',0,1,9),
    ('timeclear','4h','4h','string','timeLength','Screen time out',0,5,22),
    ('searchAdv','4,and,1003,or,21,or,5,or,12','4,and,1003,or,21,or,5,or,12','see manual','text','Advance search configuration',0,5,2),
    ('useAttOrder','list:1016,9016,4,9004,5006,1003,21,5001,5000,13,12,1005,1004,31,7,8,16,9,5002,63,59,1018,5,6','list:1016,9016,4,9004,5006,1003,21,5001,5000,13,12,1005,1004,31,7,8,16,9,5002,63,59,1018,5,6','see manual','text','Use attribute order',0,5,3),
    ('emailAddress','noone@noreply.org','noone@noreply.org','','text','OPALS generic email account. Format: "Full Name" <someone@example.com>',0,1,2),
    ('validateBarcode','0','Disable','binary','radio','Enable/disable barcode validation',0,2,2),
    ('union852','',' ','integer','text','Union display: 0-code, 1-lib, 2-both',1,8,1),
    ('iuset','1','1','','text','',0,0,0),
    ('iumap','sid,Student Number,firstname,First Name,lastname,Last Name,addrLine1,Mailing Street,city,Mailing City,state,Mailing State,zip,Mailing Zip,phone,Home Phone,birthday,Birthday,gender,Gender,homeroom,Homeroom,teacher,HR Teacher Last Name,grade,Grade Level,yeargraduation,Graduation Year','sid,Student Number,firstname,First Name,lastname,Last Name,addrLine1,Mailing Street,city,Mailing City,state,Mailing State,zip,Mailing Zip,phone,Home Phone,birthday,Birthday,gender,Gender,homeroom,Homeroom,teacher,HR Teacher Last Name,grade,Grade Level,yeargraduation,Graduation Year','','text','',1,0,0),
    ('amazonId','','','string','text','Amazon Web Service ID',0,5,7),
    ('barcodeType','0','default','0|1|2|3','select','Barcode Type',0,2,1),
    ('warningDatetime','','','','text','Date and time to show warning message',1,0,0),
    ('allowOverdue','1','override with question','integer','select','Overdue allowance setting',0,3,1),
   ('allowOutstandingBalance',2,'override automatically without approval','integer','select','Loan restriction for patron with outstanding balance.   No override / Override with question / Override automatically without approval',0,3,1),  
    ('bibformat','apa','APA','','select','Default bibliography format',0,5,12),
    ('defCategory','','','','select','Default user category',0,4,1),
    ('userFileFtp_url','','','','text','',0,4,2),
    ('userFileFtp_username','','','','text','',0,4,3),
    ('userFileFtp_password','','','','text','',0,4,4),
    ('userCsvFileLocation','','','','text','',0,4,5),
    ('userDataOverwriten',0,'User data will be imported only when there are changes in the CSV file','','radio','',0,4,6),

    ('overwrittenByBarcode','0','0','0|1','text','To overwrite user data when importing users',1,0,0),
    ('recordLock','','','','text','Marc record lock/unlock',1,0,0),
    ('lockingDatetime','','','','text','Date and time to lock site',1,0,0),
    ('emailUser','','','','text','Email account username',0,1,5),
    ('emailPass','','','','text','Email account password',0,1,3),
    ('selfcreateAccount','0','Off','','radio','allow/disallow self register account.',0,1,10),
    ('hit_counter',1,'On','0|1','radio','enable/disable hit counter',0,1,11),
    ('defaultSearchPage','0','standard','0|1|2|3','select','Default search interface',0,5,1),
    ('bibTimeclear','10m','10m','string','timeLength','bibiography time clear',0,5,13),
    ('useHolidays','1','exclude holidays in circulation','0|1','radio','Include = Count holiday as part of loan period. Exclude = Extend loan period a day for each holiday',0,3,3),
    ('charge_damage','0','Off','1','radio','set system fine for damage.',0,3,4),
    ('charge_lost','0','Off','1','radio','set system fine for Lost',0,3,5),
    ('charge_overdue','0','Off','1','radio','set system fine for Overdue',0,3,6),
    ('patronItemPrivacy','0','Off','1|0','radio','set system allow to show or hide patron information',0,2,5),
    ('slipPrinter','0','Disable','1|0','radio','Enable/Disable use of slip printer.',0,2,5),
    ('syndeticsId','','','nysbsls','text','Syndetics client code \"ESUFS\"',0,5,9),
    ('circulationSound','1','On','0 | 1','radio','circulation sound system',0,2,3),
    ('allowSelfRenewal','1','On','0 | 1','radio','Allow self-renewal',0,2,8),
    ('showLocation','0','Off','0|1','radio','show item location($852 c)',0,5,11),
    ('textbookMgmnt','0','Disable','0|1','radio','Enable/Disable Textbook management module',0,9,2),
    ('showARL','0','Off','0|1','radio','Show accelerated readers/reading counts/lexile search.',0,5,24),
    
    ('learn360ClientKey','','','','text','learn360 URI mapping',0,5,26),
    ('learn360Location','','','','text','',0,5,27),

    ('libAddress','245 labrosse','245 labrosse','','text','',1,0,0),
    ('libCity','Montreal','Montreal','','text','',1,0,0),
    ('libState','QC','QC','','text','',1,0,0),
    ('libZip','H1H 1W1','H1H 1W1','','text','',1,0,0),
    ('libPhone','','','','text','',1,0,0),
    ('libFax','','','','text','',1,0,0),
    ('libEmail','','','','text','',1,0,0),
    ('showBeginnerSrch','0','Hide all','0|1|2|3','select','Beginner search interface setting',0,5,4),
    ('beginnerSrchLocation','','','','text','Beginner Search Location (#852 c)',0,5,4),
    ('multilingual','en','en','text','checkbox','Select supported languages',0,5,19),
    ('unionId','','','text','text','union authentication id used for updating union site(deletion/import)',0,8,2),
    ('autoUpdateUnion','0','Disable','0|1','radio','enable/disable auto update union',0,8,3),
    ('unionSvcUrl','','','url','text','union update web service url',0,8,4),
    ('autoAdd2NewItemList','1','On','0|1','radio',' Auto add to new item list in z-import,import or clone record;',0,5,10),
    ('equipmentMgmnt','0','Disable','0|1','radio','Enable/Disable Equipment management module',0,9,1),
    ('amazonSecreteKey','','','string','text',' Amazon Secret Access Key',0,5,8),
    ('rating','0','disable the reader rating item','0|1|2','select','Reader rating feature setting',0,5,23),
    ('OWLBgSrchFields','keyword,title,author','keyword,title,author','','checkbox','Search fields display in OWL Search Page',0,5,6),
    ('OWLsrchLocation','','','','text','OWL Search Location (#852 c)',0,5,5),
    ('showPathfinder','0','Off','0|1','radio','pathfinders setting',0,5,25),
    ('unionCircUpdate','0','Disable','0|1','radio','enable/disabled  auto update circulation data to union',0,8,5),
    ('ILL_Messaging','0','Disable','0|1','radio','enable/disabled  ILL messaging',0,8,8),
    ('unionCircUpdateDate','0000-00-00 00:00:00','0000-00-00 00:00:00','datetime','text','date and time in international format (YYYY-mm-dd HH:MM:SS)',1,8,6),
    ('textbookFine','0','Off','Integer','radio','Turn on/off Textbook fine system',0,9,3),
    ('textbookChargeLost','0','Off','Integer','radio','set Textbook fine system for Lost',0,9,4),
    ('textbookChargeDamage','0','Off','Integer','radio','set Textbook fine system for damage',0,9,5),
    ('textbookChargeOverdue','0','Off','Integer','radio','set Textbook fine system for overdue',0,9,6),
    ('equipmentOverdueDisplay','0','Off','Integer','radio','On/Off to display/not display Equipment outstanding transactions in other modules',0,9,7),
    ('textbookOverdueDisplay','0','Off','Integer','radio','On/Off to display/not display Equipment outstanding transactions in other modules',0,9,8),
    ('timezone','America/Montreal','(GM4 -5.0) Eastern Time (US &amp; Canada), Bogota, Lima','','select','Time Zone',0,1,9),
    ('defaultSearchResultSort','31','Publication date','Integer','select','Default search result sort field',0,5,4),
    ('bookingReserve','1','On','0|1','radio','enable/disable Booking Reserve function',0,5,28),
    ('googlePreview','1','On','0|1','radio','Turn Google Preview Off/Off',0,5,29),
    ('classificationSystem','dewey', 'Dewey Decimal System','dewey|LCC','select','Dewey Decimal System',0,5,13),
    ('OpacLoginRequired','0','No','0|1','radio','Turn on/off OPAC Access login requirement',0,1,13),
    ('selfcheck','0','Off','0|1','radio','SIP self-service checkout',0,1,13),
    ('acsd_uuid','','','string','text','ACSD UUID',1,1,13),
    ('ebookModule','0','Disable','0|1','radio','enable / disable Ebook module',0,10,1),
    ('ebs_libCode','','','string','text','Opals eBook library code',0,10,2),
    ('ebs_host','','','string','text','Opals eBook server host',0,10,3),
    ('ebs_accessKey','','','string','text','Opals eBook access key',0,10,4),
    ('unionExportExcludeTypes','','','','checkbox','List of record types excluded when export',0,8,7),
    ('showLocationFilter','1','Enable','0|1','radio','enable / disable location search option',0,5,1),
    ('libname_css','font-size:18pt;text-shadow: 0 3px 3px black; color:#00CCFF;font-family: arial','font-size:18pt;text-shadow: 0 3px 3px black; color:#00CCFF;font-family: arial','','text','',1,0,0),
    ('slogan_css','font-size:12pt;text-shadow: 0 3px 3px black; color:white;font-family: arial;','font-size:12pt;text-shadow: 0 3px 3px black; color:white;font-family: arial;','','text','',1,0,0),
    ('headerLogo_pos','left','','left','text','',1,0,0),
    ('headerbg_class','gradient_gray','gradient_gray','','text','',1,0,0),
    ('disableLibCat','0','Disabled','0|1','radio','Enable / Disable : library catalog module',0,1,12),
    ('showQRCode',1,'on','0|1','radio','On / Off QR code display in home menu',0,1,15),
    ('reservationSysType',0,'on','0|1','radio','Reservation system policy setting',0,2,5),
    ('searchResultDisplay','gallery','Gallery view','list|gallery','radio','Default display type in result page.',0,5,31),
    ('SIF_enable',0,'disable',NULL,'radio','Enable/disable SIF agent',0,11,14),
    ('SIF_zis_url','','',NULL,'text','ZIS address',0,11,14),
    ('SIF_sourceId','','',NULL,'text','SIF agent source ID ',0,11,14),
    ('SIF_version','','',NULL,'select','SIF version',0,11,14),
    ('SIF_schoolLocalId','','',NULL,'text','School local ID of the student record',0,11,14),
    ('preDueNotice','0','off',NULL,'select','up coming due items reminder emailing',0,3,8),
    ('currency','USD:$','USD - United States Dolla','text','select','select Currency symbol-code',0,1,18),
    ('curCode','USD','',NULL,'text',NULL,1,1,19),
    ('curSymbol','$','',NULL,'text',NULL,1,1,19),
    ('showGenre', 0,'Off','0|1','radio','On / Off Genre - Featured Collections in home menu',0,5,30),
    ('anonymizeLoan','0' ,'off',NULL,'select','', 0,2,6),
    ('custRptFields','{}','',null,'text','',1,null,null)
    ;


insert into opl_extDatabase (page,name, url, param,rank,hidden,description) 
    values
    ('searchPage','C.E.R.F.','http://cerfinfo.com/cerfkoha.asp','keyword',0,0,NULL),
    ('searchPage','NOVEL-Databases','http://kbn.cerfinfo.com/novel.asp','term',0,1,NULL),
    ('searchPage','Quest-All','http://kbn.cerfinfo.com/questall.asp','src=Cerf&term',0,1,NULL),
    ('OWL','','','',1,0,''),
    ('OWL','','','',2,0,''),
    ('OWL','','','',3,0,''),
    ('OWL','','','',4,0,''),
    ('OWL','','','',5,0,'');
    
insert into opl_openHours 
    (weekday, open, close)
    values
    (1,'8:00','11:30'),
    (1,'13:30','15:30'),
    (2,'8:00','11:30'),
    (2,'13:30','15:30'),
    (3,'8:00','11:30'),
    (3,'13:30','15:30'),
    (4,'8:00','11:30'),
    (4,'13:30','15:30'),
    (5,'8:00','12:00'),
    (5,'13:00','15:00'),
    (6,'',''),
    (0,'','');

INSERT INTO `opl_index_map` 
    VALUES 
    ('12','Control-number-local','001','',NULL),
    ('9','Control-number-LC','010','a',NULL),
    ('7','Identifier-ISBN','020','a',NULL),
    ('8','Identifier-ISSN','022','a',NULL),
    ('8','Identifier-ISSN','440','x',NULL),
    ('8','Identifier-ISSN','490','x',NULL),
    ('8','Identifier-ISSN','700','x',NULL),
    ('8','Identifier-ISSN','710','x',NULL),
    ('8','Identifier-ISSN','711','x',NULL),
    ('8','Identifier-ISSN','730','x',NULL),
    ('13','Classification-Dewey','082','a',NULL),
    ('16','Classification-LC','050','a',NULL),
    ('16','Classification-LC','490','l',NULL),
    ('4','Title','130','a,t',NULL),
    ('4','Title','210','a',NULL),
    ('4','Title','222','a',NULL),
    ('4','Title','240','a',NULL),
    ('6','Title-uniform','240','a',NULL),
    ('4','Title','242','a,b',NULL),
    ('4','Title','243','a',NULL),
    ('4','Title','245','a,b,p',NULL),
    ('4','Title','246','a,b',NULL),
    ('4','Title','247','a,b',NULL),
    ('4','Title','440','a',NULL),
    ('4','Title','490','a',NULL),
    ('5','Title-series','440','a',NULL),
    ('5','Title-series','490','a',NULL),
    ('4','Title','505','t',NULL),
    ('4','Title','700','t',NULL),
    ('4','Title','710','t',NULL),
    ('4','Title','711','t',NULL),
    ('4','Title','730','a,t',NULL),
    ('4','Title','740','a',NULL),
    ('4','Title','800','c,t',NULL),
    ('4','Title','810','t',NULL),
    ('4','Title','811','t',NULL),
    ('4','Title','830','t',NULL),
    ('5002','Medium','245','h',NULL),
    ('59','Name-geographic-place-publication','260','a',NULL),
    ('1018','Name-publisher','260','b',NULL),
    ('31','Date-publication','260','c',NULL),
    ('63','Note','500','a',NULL),
    ('63','Note','501','a',NULL),
    ('63','Note','502','a',NULL),
    ('63','Note','503','a',NULL),
    ('63','Note','504','a',NULL),
    ('63','Note','505','a',NULL),
    ('63','Note','506','a',NULL),
    ('63','Note','507','a',NULL),
    ('63','Note','508','a',NULL),
    ('63','Note','509','a',NULL),
    ('63','Note','510','a',NULL),
    ('63','Note','511','a',NULL),
    ('63','Note','512','a',NULL),
    ('63','Note','513','a',NULL),
    ('63','Note','514','a',NULL),
    ('63','Note','515','a',NULL),
    ('63','Note','516','a',NULL),
    ('63','Note','517','a',NULL),
    ('63','Note','518','a',NULL),
    ('63','Note','519','a',NULL),
    ('63','Note','520','a',NULL),
    ('63','Note','521','a',NULL),
    ('63','Note','522','a',NULL),
    ('63','Note','523','a',NULL),
    ('63','Note','524','a',NULL),
    ('63','Note','525','a',NULL),
    ('63','Note','526','a',NULL),
    ('63','Note','527','a',NULL),
    ('63','Note','528','a',NULL),
    ('63','Note','529','a',NULL),
    ('63','Note','530','a',NULL),
    ('63','Note','531','a',NULL),
    ('63','Note','532','a',NULL),
    ('63','Note','533','a',NULL),
    ('63','Note','534','a',NULL),
    ('63','Note','535','a',NULL),
    ('63','Note','536','a',NULL),
    ('63','Note','537','a',NULL),
    ('63','Note','538','a',NULL),
    ('63','Note','539','a',NULL),
    ('63','Note','540','a',NULL),
    ('63','Note','541','a',NULL),
    ('63','Note','542','a',NULL),
    ('63','Note','543','a',NULL),
    ('63','Note','544','a',NULL),
    ('63','Note','545','a',NULL),
    ('63','Note','546','a',NULL),
    ('63','Note','547','a',NULL),
    ('63','Note','548','a',NULL),
    ('63','Note','549','a',NULL),
    ('63','Note','550','a',NULL),
    ('63','Note','551','a',NULL),
    ('63','Note','552','a',NULL),
    ('63','Note','553','a',NULL),
    ('63','Note','554','a',NULL),
    ('63','Note','555','a',NULL),
    ('63','Note','556','a',NULL),
    ('63','Note','557','a',NULL),
    ('63','Note','558','a',NULL),
    ('63','Note','559','a',NULL),
    ('63','Note','560','a',NULL),
    ('63','Note','561','a',NULL),
    ('63','Note','562','a',NULL),
    ('63','Note','563','a',NULL),
    ('63','Note','564','a',NULL),
    ('63','Note','565','a',NULL),
    ('63','Note','566','a',NULL),
    ('63','Note','567','a',NULL),
    ('63','Note','568','a',NULL),
    ('63','Note','569','a',NULL),
    ('63','Note','570','a',NULL),
    ('63','Note','571','a',NULL),
    ('63','Note','572','a',NULL),
    ('63','Note','573','a',NULL),
    ('63','Note','574','a',NULL),
    ('63','Note','575','a',NULL),
    ('63','Note','576','a',NULL),
    ('63','Note','577','a',NULL),
    ('63','Note','578','a',NULL),
    ('63','Note','579','a',NULL),
    ('63','Note','580','a',NULL),
    ('63','Note','581','a',NULL),
    ('63','Note','582','a',NULL),
    ('63','Note','583','a',NULL),
    ('63','Note','584','a',NULL),
    ('63','Note','585','a',NULL),
    ('63','Note','586','a',NULL),
    ('63','Note','587','a',NULL),
    ('63','Note','588','a',NULL),
    ('63','Note','589','a',NULL),
    ('63','Note','590','a',NULL),
    ('63','Note','591','a',NULL),
    ('63','Note','592','a',NULL),
    ('63','Note','593','a',NULL),
    ('63','Note','594','a',NULL),
    ('63','Note','595','a',NULL),
    ('63','Note','596','a',NULL),
    ('63','Note','597','a',NULL),
    ('63','Note','598','a',NULL),
    ('63','Note','599','a',NULL),
    ('21','Subject','600','',NULL),
    ('21','Subject','601','',NULL),
    ('21','Subject','602','',NULL),
    ('21','Subject','603','',NULL),
    ('21','Subject','604','',NULL),
    ('21','Subject','605','',NULL),
    ('21','Subject','606','',NULL),
    ('21','Subject','607','',NULL),
    ('21','Subject','608','',NULL),
    ('21','Subject','609','',NULL),
    ('21','Subject','610','',NULL),
    ('21','Subject','611','',NULL),
    ('21','Subject','612','',NULL),
    ('21','Subject','613','',NULL),
    ('21','Subject','614','',NULL),
    ('21','Subject','615','',NULL),
    ('21','Subject','616','',NULL),
    ('21','Subject','617','',NULL),
    ('21','Subject','618','',NULL),
    ('21','Subject','619','',NULL),
    ('21','Subject','620','',NULL),
    ('21','Subject','621','',NULL),
    ('21','Subject','622','',NULL),
    ('21','Subject','623','',NULL),
    ('21','Subject','624','',NULL),
    ('21','Subject','625','',NULL),
    ('21','Subject','626','',NULL),
    ('21','Subject','627','',NULL),
    ('21','Subject','628','',NULL),
    ('21','Subject','629','',NULL),
    ('21','Subject','630','',NULL),
    ('21','Subject','631','',NULL),
    ('21','Subject','632','',NULL),
    ('21','Subject','633','',NULL),
    ('21','Subject','634','',NULL),
    ('21','Subject','635','',NULL),
    ('21','Subject','636','',NULL),
    ('21','Subject','637','',NULL),
    ('21','Subject','638','',NULL),
    ('21','Subject','639','',NULL),
    ('21','Subject','640','',NULL),
    ('21','Subject','641','',NULL),
    ('21','Subject','642','',NULL),
    ('21','Subject','643','',NULL),
    ('21','Subject','644','',NULL),
    ('21','Subject','645','',NULL),
    ('21','Subject','646','',NULL),
    ('21','Subject','647','',NULL),
    ('21','Subject','648','',NULL),
    ('21','Subject','649','',NULL),
    ('21','Subject','650','',NULL),
    ('21','Subject','651','',NULL),
    ('21','Subject','652','',NULL),
    ('21','Subject','653','',NULL),
    ('21','Subject','654','',NULL),
    ('21','Subject','655','',NULL),
    ('21','Subject','656','',NULL),
    ('21','Subject','657','',NULL),
    ('21','Subject','658','',NULL),
    ('21','Subject','659','',NULL),
    ('21','Subject','660','',NULL),
    ('21','Subject','661','',NULL),
    ('21','Subject','662','',NULL),
    ('21','Subject','663','',NULL),
    ('21','Subject','664','',NULL),
    ('21','Subject','665','',NULL),
    ('21','Subject','666','',NULL),
    ('21','Subject','667','',NULL),
    ('21','Subject','668','',NULL),
    ('21','Subject','669','',NULL),
    ('21','Subject','670','',NULL),
    ('21','Subject','671','',NULL),
    ('21','Subject','672','',NULL),
    ('21','Subject','673','',NULL),
    ('21','Subject','674','',NULL),
    ('21','Subject','675','',NULL),
    ('21','Subject','676','',NULL),
    ('21','Subject','677','',NULL),
    ('21','Subject','678','',NULL),
    ('21','Subject','679','',NULL),
    ('21','Subject','680','',NULL),
    ('21','Subject','681','',NULL),
    ('21','Subject','682','',NULL),
    ('21','Subject','683','',NULL),
    ('21','Subject','684','',NULL),
    ('21','Subject','685','',NULL),
    ('21','Subject','686','',NULL),
    ('21','Subject','687','',NULL),
    ('21','Subject','688','',NULL),
    ('21','Subject','689','',NULL),
    ('21','Subject','690','',NULL),
    ('21','Subject','691','',NULL),
    ('21','Subject','692','',NULL),
    ('21','Subject','693','',NULL),
    ('21','Subject','694','',NULL),
    ('21','Subject','695','',NULL),
    ('21','Subject','696','',NULL),
    ('21','Subject','697','',NULL),
    ('21','Subject','698','',NULL),
    ('21','Subject','699','',NULL),
    ('1003','Author-name','100','a,q',NULL),
    ('1003','Author-name','110','a,b',NULL),
    ('1003','Author-name','111','a,q',NULL),
    ('1003','Author-name','700','a,q',NULL),
    ('1003','Author-name','710','a,d',NULL),
    ('1003','Author-name','711','a',NULL),
    ('1003','Author-name','800','a,q',NULL),
    ('1003','Author-name','810','a',NULL),
    ('1003','Author-name','811','a',NULL),
    ('13','Classification-Dewey','852','h',NULL),
    ('5000','Bar-code','852','p',NULL),
    ('5001','Call-number-local','852','k,h,i,m',NULL),
    ('s4','Title-sort value','245','-',NULL),
    ('s31','Date-publication-sort value','260','-',NULL),
    ('s5001','Call number-sort value','852','-',NULL),
    ('s1003','Author-sort value','100','a',NULL),
    ('1016','Anywhere search attribute list',NULL,NULL,'attr_4,attr_5,attr_6,attr_21,attr_31,attr_59,attr_63,attr_1003');


INSERT INTO `tb_index_map` 
    VALUES 
    (1,'010','LCCN','a',0,0,1,'010_a','0','1',15,'1'),
	(2,'020','ISBN','a',0,0,1,'020_a','0','1',3,'1'),
	(3,'022','ISSN','a',0,0,1,'022_a','0','1',20,'1'),
	(4,'100','Author','a',1,0,1,'100_a','0','1',4,'1'),
	(5,'110','Corporate Author','a',1,0,1,'110_a','0','0',5,'1'),
	(6,'245','Title','a',0,1,1,'245_a','0','1',1,'1'),
	(7,'245','Subtitle','b',0,0,1,'245_b','0','1',2,'1'),
	(8,'250','Edition','a',0,0,1,'250_a','0','1',11,'1'),
	(9,'260','Place of publication','a',0,0,1,'260_a','0','0',13,'1'),
	(10,'260','Publisher','b',0,0,1,'260_b','0','1',12,'1'),
	(11,'260','Year of publication','c',0,0,1,'260_c','0','1',14,'1'),
	(12,'300','Pages','a',0,0,1,'300_a','0','1',8,'1'),
	(13,'490','Series','a',0,0,1,'490_a','0','1',6,'1'),
	(14,'490','Volume #','v',0,0,1,'490_v','0','1',7,'1'),
	(15,'500','General Note','a',0,0,1,'500_a','0','1',16,'1'),
	(16,'505','Detailed Contents Page','g',0,0,1,'505_g','0','1',17,'1'),
	(17,'520','Content Summary','a',0,0,1,'520_a','0','1',18,'1'),
	(18,'521','Reading Level','a',0,0,1,'521_a','0','1',19,'1'),
	(19,'650','Topics','a',1,0,1,'650_a','0','1',10,'1'),
	(20,'856','Publication URL & Description','u',1,0,3,'856_u','0','1',21,'1'),
	(21,'900','Grade Level','a',0,0,1,'900_a','1','1',22,'1'),
	(22,'900','Course Number','b',0,0,1,'900_b','1','0',23,'1'),
	(23,'900','Course Name','c',0,0,1,'900_c','1','1',24,'1'),
	(24,'900','Course Description','d',0,0,1,'900_d','0','0',25,'1'),
	(29,'300','Number of words','w',0,0,4,'300_w','0','1',9,'1'),
	(30,'900','Kit Contains - Lesson Plan(s)','e',0,0,5,'900_e','1','0',30,'1'),
	(31,'900','Kit Contains - CD','f',0,0,5,'900_f','0','0',26,'1'),
	(32,'900','Kit Contains - DVD','g',0,0,5,'900_g','0','0',27,'1'),
	(33,'900','Kit Contains - Books','h',0,0,5,'900_h','0','0',28,'1'),
	(34,'900','Kit Contains - Other','k',0,0,5,'900_k','0','0',29,'1'),
	(35,'005','modDate','',0,0,1,'005','0','0',31,'0');

INSERT INTO `eq_def` 
    VALUES 
    (1,'record',1,'Manufacturer','Manufacturer',0,0,1,1,1,1,0,'0',50,''),
    (3,'record',2,'Model','Model',0,0,0,1,1,1,0,'0',50,''),
    (26,'item',10,'District Code','District Code',0,0,0,0,1,0,0,'0',50,''),
    (14,'record',4,'Warranty Notes','Warranty Notes',0,0,0,0,1,0,0,'0',50,''),
    (18,'item',11,'Building Code','Building Code',0,0,0,1,1,1,0,'0',20,''),
    (16,'record',6,'Manufacturer URL','link to manufacturer url',0,0,0,1,1,0,2,'0',10,''),
    (38,'item',15,'Status','Items Status Notes',0,0,0,0,1,1,0,'0',50,''),
    (28,'record',8,'Online Manual','link to equipment manual page',0,0,0,0,1,0,2,'0',10,''),
    (27,'record',7,'Supplier URL','link to supplier url',0,0,0,0,1,0,2,'0',10,''),
    (6,'item',3,'Price','Price',0,0,0,0,1,1,0,'0',50,''),
    (7,'item',14,'District Inventory Number','District Inventory Number',0,0,0,0,1,0,0,'0',50,''),
    (11,'item',12,'Location in building','Location in building',0,0,1,1,1,1,0,'0',50,''),
    (5,'item',1,'Serial Number','Serial number',0,0,1,1,1,1,0,'0',50,'capitalize'),
    (31,'item',13,'Date Acquired/Assigned/Install','Date Acquired',0,0,0,0,1,0,2,'0',10,''),
    (33,'record',3,'General Notes','General Notes',0,0,0,0,1,1,0,'0',50,''),
    (36,'record',5,'General Accessories Notes','Accessories Notes',0,0,0,0,1,0,0,'0',50,''),
    (39,'item',16,'Vendor Name','Vendor Name',0,0,0,0,1,0,0,'0',50,''),
    (40,'item',17,'Assigned Person First Name','Assigned Person First Name',0,0,1,0,1,0,0,'0',50,''),
    (41,'item',18,'Assigned Person Last Name','Assigned Person Last Name',0,0,1,0,1,0,0,'0',50,''),
    (42,'item',2,'P.O. Number','Purchase Order Number',0,0,0,0,1,0,0,'0',50,''),
    (43,'item',4,'IP Address','IP Address',0,0,0,0,1,0,0,'0',50,''),
    (44,'item',5,'MAC Address','MAC Address',0,0,0,0,1,0,0,'0',50,''),
    (45,'item',6,'Software Key','Software Key',0,0,0,0,1,0,0,'0',50,''),
    (46,'item',7,'Cart Number','Cart Number',0,0,0,0,1,1,0,'0',50,''),
    (47,'item',8,'Slot Number','Slot Number',0,0,0,0,1,0,7,'0',50,''),
    (37,'item',15,'Machine Name','Machine Name',0,0,0,0,1,0,0,'0',50,''),
    (48,'item',9,'Accessories','Accessories',0,0,0,1,1,0,8,'0',10,''),
    (8,'item',19,'Item Designation','Item Designation',0,0,1,0,1,0,0,'0',50,''),
    (9,'item',9,'Grant','Grant',0,0,0,0,1,0,0,'0',50,'');

INSERT INTO `eq_defRequired` 
    VALUES 
    (1,'record',1,'Equipment Name','Equipment Name',1,1,1,0),
	(2,'item',1,'Bar Code','Bar Code',1,1,1,0),
	(3,'item',2,'Item Type','Item Category Type',1,1,0,0);

INSERT INTO `eq_fieldDataType` 
    VALUES 
    (1,'Text',0),
    (2,'Date',0),
    (3,'Url Link',0),
    (4,'Number',0),
    (5,'Checkbox',0),
    (6,'Select',0),
    (7,'NumberList',10),
    (8,'CheckboxList',0);

INSERT INTO `opl_transCode` 
    VALUES 
    (1,'OVERDUE_CHARGED','overdue charged',''),
    (2,'LOST_CHARGED','lost charged',''),
    (3,'DAMAGE_CHARGED','damage charged',''),
    (4,'PAYMENT','payment',''),
    (5,'FORGIVE','forgive',''),
    (6,'CREDIT_REFUND','credit refund',''),
    (7,'RATE_ADJUSTMENT','rate adjustment',''),
    (8,'REFUND','refund',''),
    (9,'SERVICE_FEE','service fee',''),
    (10,'CREDIT_USED','credit used',''),
    (11,'PAY_FROM_CREDIT','pay from credit','');

INSERT INTO `opl_permission` VALUES (1,1,'User Add','user_add'),
    (2,1,'User Edit','user_edit'),
    (3,1,'User Delete','user_delete'),
    (4,6,'Marc Edit','marc_edit'),
    (5,3,'Pref Edit','pref_edit'),
    (6,4,'Circ Loan','circ_loan'),
    (7,4,'Circ Return','circ_return'),
    (8,4,'Circ Reserve','circ_rsrv'),
    (9,4,'Self-Reserve','circ_rsrv_self'),
    (10,17,'Collect','fine'),
    (12,4,'Notice','notice'),
    (44,6,'Delete record','marc_del'),
    (14,4,'Email Bib','bibsrc'),
    (15,5,'Path Finder','pf'),
    (16,5,'Rating','rating'),
    (18,7,'Record Edit','tb_record_edit'),
    (11,4,'Payment','payment'),
    (19,9,'Circ Loan','tb_circ_loan'),
    (20,9,'Circ Return','tb_circ_return'),
    (21,9,'Circ Reserve','tb_circ_rsrv'),
    (22,9,'Self-Reserve','tb_circ_rsrv_self'),
    (23,9,'Fine','tb_fine'),
    (24,9,'Notice','tb_notice'),
    (25,9,'Report','tb_report'),
    (27,12,'Record Edit','eq_record_edit'),
    (28,14,'Circ Loan','eq_circ_loan'),
    (29,14,'Circ Return','eq_circ_return'),
    (30,14,'Circ Reserve','eq_circ_rsrv'),
    (31,14,'Self-Reserve','eq_circ_rsrv_self'),
    (32,14,'Report','eq_report'),
    (43,6,'Add new record','marc_add'),
    (26,10,'Course','tb_course_edit'),
    (33,4,'ILL Filter','circ_ill_filter'),
    (34,5,'eBook Mgmt','ebook_mgmt'),
    (35,16,'User','rpt_user'),
    (36,16,'Circ','rpt_circ'),
    (37,16,'Catalog Rec','rpt_catRec'),
    (38,16,'Fine','rpt_fine'),
    (39,16,'Notice','rpt_notice'),
    (41,17,'Adjust','fine_edit'),
    (42,17,'Waive','fine_waive'),
    (45,6,'Merge records','marc_merge'),
    (46,6,'Export records','marc_export'),
    (47,1,'User Permissions Change','user_permEdit'),
    (48,5,'Genre','genre'),
    (49,5,'Reserve Shelf','rsrv_shelf'),
    (50,9,'User Edit','tb_user_edit'),
    (51,9,'Circ Report','tb_rpt_circ'),
    (52,14,'Circ Report','eq_rpt_circ');




INSERT INTO `opl_permGroup` 
    VALUES 
    (1,1,'User'),
    (2,3,'Marc'),
    (3,1,'System'),
    (4,2,'Circ'),
    (5,2,'Misc'),
    (7,3,'Marc'),
    (9,3,'Circ'),
    (10,3,'Misc'),
    (12,4,'Marc'),
    (14,4,'Circ'),
    (16,2,'Report'),
    (17,2,'Fine'),
    (6,2,'Marc');

INSERT INTO `opl_subSystem` 
    VALUES 
    (2,'Library'),
    (3,'Textbook'),
    (4,'Equipment'),
    (1,'System management');


INSERT INTO `opl_portalLayout` 
    VALUES 
    (1,1,1,1,678,NULL),
    (1,2,2,1,NULL,NULL);

INSERT INTO `opl_portalTheme` 
    VALUES (1,'basic',' /htdosc/theme/css/portal.css');    

INSERT INTO `opl_portlet` 
    VALUES 
    (1,1,null,'aboutUs'),
    (2,1,1,'newsEvents'),
    (3,1,2,'newItemList'),
    (4,2,1,'libraryHours'),
    (5,2,2,'pathfinders');

INSERT INTO `opl_portletProp` 
    VALUES 
    (2,'nItemShow','3'),
    (2,'fieldsShow','title'),
    (3,'showBookCover','true'),
    (3,'fieldsShow','title,author,pubDate'),
    (3,'nItemShow','9');




