 alter table opl_marcRecord change  `recFormat` `recFormat` set('book','ebook','journal','artifact','photoPoster','musicCassette','bookOnTape','movie','libraryKit','map','sheetMusic','internet','electronicMedia','CDMusic','compactDisc') DEFAULT 'book' ;


alter table opl_item add `lcc_sbj` varchar(3) DEFAULT '';
alter table opl_item add `lcc_num` smallint(6) DEFAULT '0';
alter table opl_item add `lcc_cutter` varchar(50) DEFAULT '';
alter table opl_item add `lcc_rmdr` varchar(50) DEFAULT '';
alter table opl_item add `callNumSort_dewey` varchar(100) DEFAULT '';
alter table opl_item add `callNumSort_lcc` varchar(100) DEFAULT '';


CREATE TABLE `opl_lcc` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `lccCode` varchar(30) DEFAULT '',
  `sbjClass` varchar(5) NOT NULL DEFAULT '',
  `sbjRange` varchar(100) NOT NULL DEFAULT '',
  `rangeB` float DEFAULT '0',
  `rangeE` float DEFAULT '0',
  `description` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `i_groupRange` (`sbjClass`,`sbjRange`),
  KEY `i_desc` (`description`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;


alter table opl_marcImport add `type` enum('hardCopy','ebook') DEFAULT 'hardCopy';
alter table opl_marcImport add `sf856Code` char(1) DEFAULT '';
alter table opl_marcImport add `sf852Data` varchar(255) DEFAULT NULL;
alter table opl_marcImport add  
