alter table opl_bkgItem add `title` mediumtext after rid,add author varchar(150) default null after rid,add `dateDue` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' after author, add dateLoan datetime NOT NULL DEFAULT '0000-00-00 00:00:00' after author;
alter table opl_bkgItem add  KEY `i_loan` (`dateLoan`,`dateDue`);
alter table opl_bkgItem add  FULLTEXT KEY `ind_f` (`author`,`title`);
alter table opl_bkg change deliveryMethod deliveryMethod enum('SHIP','LIB_PICKUP','CLRM_PICKUP','CURB_PICKUP') default 'LIB_PICKUP';
update opl_bkgItem i inner join opl_loan l using(idloan) set i.dateLoan=l.dateLoan,i.dateDue=l.dateDue where i.kind='LIBRARY';
update opl_bkgItem i inner join opl_marcRecord m using(rid) set i.title=m.title, i.author=m.author where i.kind='library';
