alter table opl_emailRequest change reqType reqType enum('odNotice','preDueNotice','QECatNotice','fineNotice','parenTrxNotice') default 'odNotice' ;
alter table opl_guardian add refId varchar(40) DEFAULT NULL, add receiveLoanTrxNotice tinyint(2) unsigned default 1;
update opl_guardian set refId=UUID();
insert into opl_preference values('parentTxnNotification','0','Off','1|0','radio','Auto send loan transactions to parent/guardian',0,2,0);
insert into opl_prefFormParam values ('parentTxnNotification',0,'Off',0),('parentTxnNotification',1,'On',1);
