CREATE TABLE IF NOT EXISTS `tblcorporateactions` (
  `*EventCD` varchar(10) DEFAULT NULL COMMENT 'Event type code',
  `*EventID` int(10) DEFAULT NULL COMMENT 'Unique global Event Identifier combined with Event type code',
  `*OptionID` int(10) DEFAULT NULL COMMENT 'Mulitple Payment Option ID - Groups together multiple elements that comprise a complete payment option e.g. Part Cash, part Stock',
  `*SerialID` int(10) DEFAULT NULL COMMENT 'Mulpile Payment Serial ID - Enumerates each element of an option from a multiple payment so the the combination of OptionID and SerialID',
  `*ScexhID` int(10) DEFAULT NULL COMMENT 'Unique global level Listing ID',
  `*SedolID` int(10) DEFAULT NULL COMMENT 'EDI Internal unique ID for latest Sedol',
  `Actflag` char(1) DEFAULT NULL COMMENT 'Event Level Action Status',
  `Changed` datetime DEFAULT NULL COMMENT 'Date event updated.',
  `Created` date DEFAULT NULL COMMENT 'Date event first entered',
  `SecID` int(10) DEFAULT NULL COMMENT 'Unique global level Security ID (can be used to link all multiple listings together',
  `IssID` int(10) DEFAULT NULL COMMENT 'Unique global level Issuer ID (can be used to link all securities of a company togther)',
  `ISIN` char(12) DEFAULT NULL COMMENT 'ISIN code (global level identifier)',
  `USCode` char(9) DEFAULT NULL COMMENT 'USCode (global level identifier)',
  `IssuerName` varchar(70) DEFAULT NULL COMMENT 'Name of Issuer',
  `CntryofIncorp` char(2) DEFAULT NULL COMMENT 'ISO Country of Incorporation of Issuer',
  `SIC` varchar(10) DEFAULT NULL COMMENT 'Standard Industrial Classification Code',
  `CIK` varchar(10) DEFAULT NULL COMMENT 'Central Index Key',
  `IndusID` int(10) DEFAULT NULL COMMENT 'EDI Proprietary Industry Sector Code',
  `SectyCD` char(3) DEFAULT NULL COMMENT 'Type of Equity Instrument',
  `SecurityDesc` varchar(70) DEFAULT NULL COMMENT 'Security Description',
  `ParValue` decimal(14,5) DEFAULT NULL COMMENT 'Security Parvalue',
  `PVCurrency` char(3) DEFAULT NULL COMMENT 'Security Parvalue Currency',
  `StatusFlag` char(1) DEFAULT NULL COMMENT 'Inactive at the global level else security is active. Not to be confused with delisted which is inactive at the exchange level',
  `PrimaryExchgCD` char(6) DEFAULT NULL COMMENT 'Exchange code for the primary listing (empty if unknown)',
  `Sedol` char(7) DEFAULT NULL COMMENT 'The UK National Security Identification Number',
  `SedolCurrency` char(3) DEFAULT NULL COMMENT 'Sedol Currency',
  `Defunct` char(1) DEFAULT NULL,
  `SedolRegCntry` char(2) DEFAULT NULL COMMENT 'Registered Country of Sedol',
  `StructCD` varchar(10) DEFAULT NULL,
  `ExchgCntry` char(2) DEFAULT NULL COMMENT 'Country of Exchange where listed',
  `ExchgCD` char(6) DEFAULT NULL COMMENT 'EDI maintained Exchange code. Equivalent to the MIC code but necessary as MIC might not be available in a timely fashion.',
  `Mic` char(4) DEFAULT NULL COMMENT 'ISO standard Market Identification Code',
  `Micseg` char(4) DEFAULT NULL COMMENT 'ISO standard Market Identification Code',
  `LocalCode` varchar(50) DEFAULT NULL COMMENT 'Local code unique at Market level - a ticker or number',
  `ListStatus` char(1) DEFAULT NULL COMMENT 'Indicates whether a security is Listed on an Exchange or Unlisted Indicates Exchange Listing Status',
  `Date1Type` varchar(20) DEFAULT NULL COMMENT 'Type of calendar date',
  `Date1` date DEFAULT NULL COMMENT 'Calendar date',
  `Date2Type` varchar(20) DEFAULT NULL COMMENT 'Type of calendar date',
  `Date2` date DEFAULT NULL COMMENT 'Calendar date',
  `Date3Type` varchar(20) DEFAULT NULL COMMENT 'Type of calendar date',
  `Date3` date DEFAULT NULL COMMENT 'Calendar date',
  `Date4Type` varchar(20) DEFAULT NULL COMMENT 'Type of calendar date',
  `Date4` date DEFAULT NULL COMMENT 'Calendar date',
  `Date5Type` varchar(20) DEFAULT NULL COMMENT 'Type of calendar date',
  `Date5` date DEFAULT NULL COMMENT 'Calendar date',
  `Date6Type` varchar(20) DEFAULT NULL COMMENT 'Type of calendar date',
  `Date6` date DEFAULT NULL COMMENT 'Calendar date',
  `Date7Type` varchar(20) DEFAULT NULL COMMENT 'Type of calendar date',
  `Date7` date DEFAULT NULL COMMENT 'Calendar date',
  `Date8Type` varchar(20) DEFAULT NULL COMMENT 'Type of calendar date',
  `Date8` date DEFAULT NULL COMMENT 'Calendar date',
  `Date9Type` varchar(20) DEFAULT NULL COMMENT 'Type of calendar date',
  `Date9` date DEFAULT NULL COMMENT 'Calendar date',
  `Date10Type` varchar(20) DEFAULT NULL COMMENT 'Type of calendar date',
  `Date10` date DEFAULT NULL COMMENT 'Calendar date',
  `Date11Type` varchar(20) DEFAULT NULL COMMENT 'Type of calendar date',
  `Date11` date DEFAULT NULL COMMENT 'Calendar date',
  `Date12Type` varchar(20) DEFAULT NULL COMMENT 'Type of calendar date',
  `Date12` date DEFAULT NULL COMMENT 'Calendar date',
  `Paytype` char(1) DEFAULT NULL COMMENT 'Paytype flag',
  `RDID` int(10) DEFAULT NULL COMMENT 'Record Date ID. Useful to link to other records sharing the same record date',
  `Priority` int(2) DEFAULT NULL COMMENT 'Indicates order of events where record date is shared',
  `DefaultOpt` tinyint(1) DEFAULT NULL COMMENT 'Paytype flag',
  `OutturnSecID` int(10) DEFAULT NULL COMMENT 'EDI Security ID for an outturn security if any. Where sucessor the outturn SecID will be the same as the parent SecID',
  `OutturnIsin` char(12) DEFAULT NULL COMMENT 'ISIN code outturn. These can be resultant OR successor codes.',
  `RatioOld` decimal(15,7) DEFAULT NULL COMMENT 'Number of old shares. Number of New Securities the shareholder receives as a proportion of Old Securities surrendered',
  `RatioNew` decimal(15,7) DEFAULT NULL COMMENT 'Number of new shares',
  `Fractions` char(1) DEFAULT NULL COMMENT 'Fractions',
  `Currency` char(3) DEFAULT NULL COMMENT 'ISO Currency Code',
  `Rate1Type` varchar(20) DEFAULT NULL COMMENT 'Type of of pay rate',
  `Rate1` decimal(14,5) DEFAULT NULL,
  `Rate2Type` varchar(20) DEFAULT NULL COMMENT 'Type of of pay rate',
  `Rate2` decimal(14,5) DEFAULT NULL COMMENT 'Pay rate',
  `Field1Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field1` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field2Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field2` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field3Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field3` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field4Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field4` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field5Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field5` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field6Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field6` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field7Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field7` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field8Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field8` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field9Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field9` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field10Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field10` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field11Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field11` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field12Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field12` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field13Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field13` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field14Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field14` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field15Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field15` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field16Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field16` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field17Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field17` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field18Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field18` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field19Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field19` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field20Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field20` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field21Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field21` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field22Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field22` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field23Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field23` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content',
  `Field24Name` varchar(20) DEFAULT NULL COMMENT 'Name of Event specific Field',
  `Field24` varchar(255) DEFAULT NULL COMMENT 'Event Specific Field Content'
) ENGINE=InnoDB DEFAULT CHARSET=utf8