
insert into opl_prefFormParam(var,listOrder,name,val) values
('OD_emailScheduler','1','Off','0'),
('OD_emailScheduler','2','1 days','1'),
('OD_emailScheduler','3','2 days','2'),
('OD_emailScheduler','4','3 days','3'),
('OD_emailScheduler','5','4 days','4'),
('OD_emailScheduler','6','5 days','5'),
('OD_emailScheduler','7','6 days','6'),
('OD_emailScheduler','8','7 days','7'),
('OD_emailScheduler','9','8 days','8'),
('OD_emailScheduler','10','9 days','9'),
('OD_emailScheduler','11','10 days','10');

insert into opl_preference(var,val,valShow,varType,description,gid) values
("OD_emailScheduler",
'{"days":"0","subject":"Overdue Items Reminder","fieldInc":["title","price","callNum"],msgTop:"",msgBottom:"","recipient":["student"]}',
'Off',
'select',
'Scheduled emailing of overdue notice',
3);

alter table opl_requestReserve add note varchar(255) default '';

