create table opl_sessionVar_bak select * from opl_sessionVar;
drop table opl_sessionVar;
CREATE TABLE `opl_sessionVar` (
  `ssid` varchar(40) default '0',
  `var` varchar(36) default NULL,
  `sOrder` int(10) unsigned NOT NULL auto_increment,
  `rid` int(10) unsigned default NULL,
  `barcode` varchar(50) default NULL,
  `note` text,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  UNIQUE KEY `u_svo` (`ssid`,`var`,`sOrder`),
  KEY `rid` (`rid`,`barcode`,`var`,`ssid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
insert into opl_sessionVar (ssid,var,rid,barcode,note,timestamp) select ssid,var,rid,barcode,note,timestamp from opl_sessionVar_bak order by ssid,var,timestamp,rid;
drop table opl_sessionVar_bak;
--
alter table opl_ge852request change action action enum('update','append','appendF','delete','copy','transfer','updateAddNew','changeRecType', 'moveHolding');
alter table opl_ge852request change status status enum('waiting','processing','done') not null default 'waiting';
alter table opl_ge852record change status status enum('waiting','done','read_permission_denied','write_permission_denied') not null default 'waiting';
