update opl_preference set val= replace(val,':1016,',':1016,9016,') where var='useAttOrder' && val regexp ':1016,';
update opl_preference set val= replace(val,',1016,',',1016,9016,') where var='useAttOrder' && val regexp ',1016,';

update opl_preference set val= replace(val,':4,',':4,9004,') where var='useAttOrder' && val regexp ':4,';
update opl_preference set val= replace(val,',4,',',4,9004,') where var='useAttOrder' && val regexp ',4,';

update opl_preference set val= replace(val,':21,',':21,9021,') where var='useAttOrder' && val regexp ':21,';
update opl_preference set val= replace(val,',21,',',21,9021,') where var='useAttOrder' && val regexp ',21,';

alter table opl_dateClosed 
add  `note` text  DEFAULT '',
add  `closed` enum('0','1') DEFAULT '1',
add  `imgName` varchar(250) DEFAULT '';

alter table opl_portlet change type type enum('aboutUs','rss','search','libraryHours','newItemList','newsEvents','image','webLinks','pathfinders','weather','reviewItemList','calendar') DEFAULT NULL;


delete from opl_prefFormParam where var='lang' or var ='multilingual';
insert into opl_prefFormParam(var,val,listOrder,name) 
  values
  ('lang','en',0,'English'),
  ('lang','fr',1,'French'),
  ('lang','es',2,'Spanish'),
  ('multilingual','en',0,'English'),
  ('multilingual','fr',1,'French'),
  ('multilingual','es',2,'Spanish');


update  opl_preference  
set val='en,fr',valShow='en,fr',opt='text',varType='checkbox',
    description='Select supported languages'
where var='multilingual' && val='1';

update  opl_preference  
set val='en',valShow='en',opt='text',varType='checkbox',
    description='Select supported languages'
where var='multilingual' && val='0';


