REPLACE into opl_prefFormParam(var,listORder,name,val) 
    VALUES
    ('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'),
    ('ebookModule',0,'Enable','1'),
    ('ebookModule',1,'Disable','0')
;


REPLACE INTO `opl_prefGroup` 
    VALUES 
    (10,'Ebook Settings');

REPLACE INTO `opl_preference` 
    VALUES 
    ('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)
    ;

REPLACE INTO `opl_permission` 
    VALUES 
    (34,1,'eBook Mgmt','ebook_mgmt');


