

alter table opl_user change sid sid varchar(50)  DEFAULT NULL, change userbarcode userbarcode varchar(50)  DEFAULT NULL;
alter table opl_delUser change sid sid varchar(50)  DEFAULT NULL, change userbarcode userbarcode varchar(50)  DEFAULT NULL;
alter table opl_userImg  change userbarcode userbarcode varchar(50)  DEFAULT NULL;



delete from opl_prefFormParam where var='anonymizeLoan';
insert into opl_prefFormParam(var,listOrder,name,val) values
    ('anonymizeLoan',0,'off',0),
    ('anonymizeLoan',1,'upon return',-1),
    ('anonymizeLoan',2,'after 5 days',5),
    ('anonymizeLoan',3,'after 10 days',10),
    ('anonymizeLoan',4,'after 30 days',30),
    ('anonymizeLoan',5,'after 60 days',60),
    ('anonymizeLoan',6,'after 90 days',90),
    ('anonymizeLoan',7,'after 120 days',120),
    ('anonymizeLoan',8,'after 180 days',180),
    ('anonymizeLoan',9,'after 1 year',365),
    ('anonymizeLoan',10,'after 2 years',730),
    ('anonymizeLoan',11,'after 3 years',1095),
    ('anonymizeLoan',12,'prior to current school year',1000000),
    ('showARL',6,'Suggested Grade Level','suggestGrdLvl'),
    ('briefRecFields',17,'Suggested Grade Level','suggestGrdLvl'),
    ('refineSearchfields',15,'Suggested Grade Level','suggestGrdLvl');

CREATE TABLE IF NOT EXISTS`opl_myFile` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `data` mediumtext default '',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

