ALTER TABLE opl_prefFormParam CONVERT TO CHARACTER SET utf8;replace into opl_prefFormParam values('overwrittenByBarcode',0,'Merge/overwrite on User ID',0),('overwrittenByBarcode',1,'Merge/overwrite on User barcode',1);update opl_preference p inner join opl_prefFormParam f on f.var=p.var && f.val=p.val set gid=4,gOrder=1, p.varType='radio', p.valShow=f.name, p.description='User Import : Merge/overwrite on User ID or user barcode' where p.var='overwrittenByBarcode';
