CREATE TABLE `cal_ev_eventvalue` ( `ev_serial` int(11) NOT NULL auto_increment, `ev_e_serial` int(11) NOT NULL default '0', `ev_edi_serial` int(11) NOT NULL default '0', `ev_value` varchar(254) NOT NULL default '', PRIMARY KEY (`ev_serial`), KEY `ev_value` (`ev_value`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1