Re: Maybe a bug in the parser?
Looks like this
CREATE TABLE `corax_event` (
`Event_Id` bigint(20) unsigned NOT NULL auto_increment,
`ASSET_ID` bigint(20) unsigned default NULL,
`RIC` varchar(20) default NULL,
`SECURITY_ID` bigint(20) unsigned default NULL,
`RIC_Source` int(10) unsigned default NULL,
`Div_Market_Lvl_Id` bigint(20) unsigned default NULL,
`Cap_Chng_Market_Lvl_Id` bigint(20) unsigned default NULL,
`Previous_Event_Id` bigint(20) unsigned default NULL,
`Event_Type` int(10) unsigned default NULL,
`FI_ISSUER_ID` bigint(20) unsigned default NULL,
`EQ_ISSUER_ID` bigint(20) unsigned default NULL,
`EPS_ID` bigint(20) unsigned default NULL,
`PILC` bigint(20) unsigned default NULL,
`TSO_Event_Id` bigint(20) unsigned default NULL,
`Event_Time` datetime NOT NULL default '0000-00-00 00:00:00',
`Cancel_Msg` tinyint(3) unsigned default '0',
`Event_CD` varchar(4) default '',
`Cap_Event_Type` tinyint(3) unsigned default NULL,
`Div_Feature` tinyint(3) unsigned default NULL,
`Div_Type_Marker` tinyint(3) unsigned default NULL,
`Record_Date` date default NULL,
`Message` varchar(255) default NULL,
PRIMARY KEY (`Event_Id`),
KEY `Asset_Id_idx` (`ASSET_ID`),
KEY `Security_Id_idx` (`SECURITY_ID`),
KEY `FI_Issuer_idx` (`FI_ISSUER_ID`),
KEY `EQ_Issuer_Idx` (`EQ_ISSUER_ID`),
KEY `Cap_Chng_Market_idx` (`Cap_Chng_Market_Lvl_Id`),
KEY `Div_Market_Lvl_idx` TYPE BTREE (`RIC`,`Div_Market_Lvl_Id`),
KEY `RIC_idx` (`RIC`),
KEY `Event_Type_idx` (`Event_Type`),
KEY `Event_Time_idx` (`Event_Time`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 1634304 kB';
bit of a star schema going on here.
Thx.
David