INSERT INTO `opl_preference` VALUES
('eqOdNoticeHeader','',NULL,NULL,'text','Equipment Overdue Notice Header',0,9,2),
('eqOdNoticeMsgBot','[]',NULL,NULL,'textList','Equipment Overdue Notice Message at the Bottom',0,9,3),
('eqOdNoticeMsgTop','[]',NULL,NULL,'textList','Equipment Overdue Notice Message at the Top',0,9,4),
('equipmentOnLoanList','0','Hide','0|1|2','select','Show/Hide Equipment Transactions in Other Modules',0,9,12),
('equipmentOverdueDisplay','0','Off','Integer','radio','Show/Hide Equipment Outstanding Transactions in Other Modules',0,9,13),
('equipmentMgmnt','1','Enable','0|1','radio','Enable/Disable Equipment management module',0,9,9),
('equipmentFine','0','Off','integer','radio','Turn on/off Equipment fine system',0,9,8),
('equipmentChargeDamage','0','Off','Integer','radio','Set Equipment fine system for damage',0,9,5),
('equipmentChargeLost','0','Off','Integer','radio','Set Equipment fine system for lost',0,9,6),
('equipmentChargeOverdue','0','Off','Integer','radio','Set Equipment fine system for overdue',0,9,7),
('tbOdNoticeHeader','',NULL,NULL,'text','Textbook Overdue Notice Header',0,9,14),
('textbookOnLoanList','0','Hide','0|1|2','select','Show/Hide Textbook Transactions in Other Modules',0,9,24),
('equipmentOnLoanDisplayInLIB','0','Off','Integer','radio','Display Equipment Loaned Items in Library Module (if applicable)',0,9,10),
('equipmentOnLoanDisplayInTB','0','Off','Integer','radio','Display Equipment Loaned Items in Textbook Module (if applicable)',0,9,11),
('textbookOverdueDisplay','0','Off','Integer','radio','Show/Hide Textbook Outstanding Transactions in Other Modules',0,9,25),
('tbOdNoticeMsgTop','[\"Please return the following items\",\"Please return items to Textbook Room\"]','[\"Please return the following items\"]',NULL,'textList','Textbook Overdue Notice Message at the Top',0,9,16),
('textbookChargeDamage','0','Off','Integer','radio','Set Textbook fine system for Damage',0,9,17),
('textbookChargeLost','0','Off','Integer','radio','Set Textbook fine system for Lost',0,9,18),
('tbOdNoticeMsgBot','[]',NULL,NULL,'textList','Textbook Overdue Notice Message at the Bottom',0,9,15),
('textbookOnLoanDisplayInLIB','0','Off','Integer','radio','Display Textbook Loaned Items in Library Module (if applicable)',0,9,23),
('textbookOnLoanDisplayInEQ','0','Off','Integer','radio','Display Textbook Loaned Items in Equipment Module (if applicable)',0,9,22),
('textbookMgmnt','0','Disable','0|1','radio','Enable/Disable Textbook management module',0,9,21),
('textbookFine','0','Off','Integer','radio','Turn on/off Textbook fine system',0,9,20),
('textbookChargeOverdue','0','Off','Integer','radio','Set Textbook fine system for Overdue',0,9,19),
('eqCentralized','1','Enable','0|1','radio','Enable/Disable Equipment Centralized System',0,9,1)
ON DUPLICATE KEY UPDATE
    `description` = VALUES(`description`),
    `gOrder`      = VALUES(`gOrder`);

INSERT INTO `opl_prefFormParam` VALUES
('eqCentralized',1,'Disable','0'),
('eqCentralized',0,'Enable','1');
