CREATE TABLE `opl_recordIdentifier` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `rid` int(10) unsigned NOT NULL default '1',
  `tag` char(3) NOT NULL default '',
  `code` char(1) NOT NULL default '',
  `data` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `i_tcd` (`tag`,`code`,`data`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

alter table opl_marcImport
    change cMerge mode enum('autoMerge','overlay','manualMerge','new') NOT NULL default 'autoMerge',
    add mergeMode enum('strict','loose') not null default 'strict' after mode,
    add countMergedHolding int(10) unsigned default '0' after countMerged,
    add holding_op enum('update','preserve') NOT NULL default 'update',
    add recordSource enum('generic','OCoLC') NOT NULL default 'generic';
