MySQL DB Build Code based on MDDL Schema

From FISD Wiki

Jump to: navigation, search

Code and Configuration

David Wynter has provided a complete MySQL schema dump file based on the MDDL xml Schema. His comments/overview:

"The follow SQL DDL is a fairly close mirroring of MDDL. The only concessions made to this being a database where to remove the <when/> element (which is only relevent to some Fixed Income elements anyway). I also removed the <Sequence/> element. My feeling is that if we need an audit for databasing this data we will generally prefer to use a serial auditing capability that is selective in which element and attribute values are important. Also to consolidate the separate Period, Date and Amount elements types where they had identical attributes and element references. These new elements are know as Period, MarketDate and Amount respectively and had a discriminator column to identify the type.

I will add additional versions for DB2, SQL Server and Oracle all populated with the values for the controlled vocabularies in late May 2008."

A zip version of the dump file is here.

The complete listing is below, some funky formatting of boxes apparently due to defaults in the wiki -- any help cleaning this up is more than appreciated!

-- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 5.1.22-rc-community

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- -- Create schema gcsm --

CREATE DATABASE IF NOT EXISTS gcsm; USE gcsm;

-- -- Definition of table `acceptance` --

DROP TABLE IF EXISTS `acceptance`; CREATE TABLE `acceptance` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `maxval` bigint(20) DEFAULT NULL,
 `minval` bigint(20) DEFAULT NULL,
 `rangetype` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `acceptance_source` (`source`),
 KEY `acceptance_rangetype` (`rangetype`),
 KEY `acceptance_minval` (`minval`),
 KEY `acceptance_maxval` (`maxval`),
 CONSTRAINT `acceptance_maxval` FOREIGN KEY (`maxval`) REFERENCES `maxval` (`id`),
 CONSTRAINT `acceptance_minval` FOREIGN KEY (`minval`) REFERENCES `minval` (`id`),
 CONSTRAINT `acceptance_rangetype` FOREIGN KEY (`rangetype`) REFERENCES `rangetype` (`id`),
 CONSTRAINT `acceptance_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `acceptance` --

/*!40000 ALTER TABLE `acceptance` DISABLE KEYS */; /*!40000 ALTER TABLE `acceptance` ENABLE KEYS */;

-- -- Definition of table `accretion` --

DROP TABLE IF EXISTS `accretion`; CREATE TABLE `accretion` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `accretionbehavior` bigint(20) DEFAULT NULL,
 `accretiontype` bigint(20) DEFAULT NULL,
 `firstamount` bigint(20) DEFAULT NULL,
 `firstdate` bigint(20) DEFAULT NULL,
 `lastamount` bigint(20) DEFAULT NULL,
 `lastdate` bigint(20) DEFAULT NULL,
 `nextamount` bigint(20) DEFAULT NULL,
 `nextdate` bigint(20) DEFAULT NULL,
 `nextperiod` bigint(20) DEFAULT NULL,
 `penultimateamount` bigint(20) DEFAULT NULL,
 `penultimatedate` bigint(20) DEFAULT NULL,
 `period` bigint(20) DEFAULT NULL,
 `schedule` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `accretion` bit(1) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `accretion_firstdate` (`firstdate`),
 KEY `accretion_firstamount` (`firstamount`),
 KEY `accretion_source` (`source`),
 KEY `accretion_accretionbehavior` (`accretionbehavior`),
 KEY `accretion_period` (`period`),
 KEY `accretion_nextperiod` (`nextperiod`),
 KEY `accretion_schedule` (`schedule`),
 KEY `accretion_accretiontype` (`accretiontype`),
 KEY `accretion_penultimatedate` (`penultimatedate`),
 KEY `accretion_penultimateamount` (`penultimateamount`),
 KEY `accretion_nextamount` (`nextamount`),
 KEY `accretion_nextdate` (`nextdate`),
 KEY `accretion_lastdate` (`lastdate`),
 KEY `accretion_lastamount` (`lastamount`),
 CONSTRAINT `accretion_lastamount` FOREIGN KEY (`lastamount`) REFERENCES `amount` (`id`),
 CONSTRAINT `accretion_accretionbehavior` FOREIGN KEY (`accretionbehavior`) REFERENCES `accretionbehavior` (`id`),
 CONSTRAINT `accretion_accretiontype` FOREIGN KEY (`accretiontype`) REFERENCES `accretiontype` (`id`),
 CONSTRAINT `accretion_firstamount` FOREIGN KEY (`firstamount`) REFERENCES `amount` (`id`),
 CONSTRAINT `accretion_firstdate` FOREIGN KEY (`firstdate`) REFERENCES `marketdate` (`id`),
 CONSTRAINT `accretion_lastdate` FOREIGN KEY (`lastdate`) REFERENCES `marketdate` (`id`),
 CONSTRAINT `accretion_nextamount` FOREIGN KEY (`nextamount`) REFERENCES `amount` (`id`),
 CONSTRAINT `accretion_nextdate` FOREIGN KEY (`nextdate`) REFERENCES `marketdate` (`id`),
 CONSTRAINT `accretion_nextperiod` FOREIGN KEY (`nextperiod`) REFERENCES `nextperiod` (`id`),
 CONSTRAINT `accretion_penultimateamount` FOREIGN KEY (`penultimateamount`) REFERENCES `amount` (`id`),
 CONSTRAINT `accretion_penultimatedate` FOREIGN KEY (`penultimatedate`) REFERENCES `marketdate` (`id`),
 CONSTRAINT `accretion_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `accretion_schedule` FOREIGN KEY (`schedule`) REFERENCES `schedule` (`id`),
 CONSTRAINT `accretion_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `accretion` --

/*!40000 ALTER TABLE `accretion` DISABLE KEYS */; /*!40000 ALTER TABLE `accretion` ENABLE KEYS */;

-- -- Definition of table `accretionbehavior` --

DROP TABLE IF EXISTS `accretionbehavior`; CREATE TABLE `accretionbehavior` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `calculationtype` bigint(20) DEFAULT NULL,
 `datetime` bigint(20) DEFAULT NULL,
 `fraction` bigint(20) DEFAULT NULL,
 `fractionhandlingtype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `marketcenter` bigint(20) DEFAULT NULL,
 `multiplier` bigint(20) DEFAULT NULL,
 `previousdatetime` bigint(20) DEFAULT NULL,
 `quantitydescriptiontype` bigint(20) DEFAULT NULL,
 `quantitytype` bigint(20) DEFAULT NULL,
 `valuationref` bigint(20) DEFAULT NULL,
 `valuationtype` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `accretionbehavior` decimal(19,2) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `accretionbehavior_source` (`source`),
 KEY `accretionbehavior_valationtype` (`valuationtype`),
 KEY `accrtnbhvir_qntitydscriptintyp` (`quantitydescriptiontype`),
 KEY `accretionbehavior_multiplier` (`multiplier`),
 KEY `accretionbehavior_quantitytype` (`quantitytype`),
 KEY `accretinbehavir_previsdatetime` (`previousdatetime`),
 KEY `accrtinbhvir_frctinhndlingtype` (`fractionhandlingtype`),
 KEY `accretionbehavior_valuationref` (`valuationref`),
 KEY `accretinbehavir_calclationtype` (`calculationtype`),
 KEY `accretionbehavior_datetime` (`datetime`),
 KEY `accretionbehavior_marketcenter` (`marketcenter`),
 KEY `accretinbehavir_indicatorstype` (`indicatorstype`),
 KEY `accretionbehavior_fraction` (`fraction`),
 CONSTRAINT `accretionbehavior_fraction` FOREIGN KEY (`fraction`) REFERENCES `fraction` (`id`),
 CONSTRAINT `accretinbehavir_calclationtype` FOREIGN KEY (`calculationtype`) REFERENCES `calculationtype` (`id`),
 CONSTRAINT `accretinbehavir_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `accretinbehavir_previsdatetime` FOREIGN KEY (`previousdatetime`) REFERENCES `previousdatetime` (`id`),
 CONSTRAINT `accretionbehavior_datetime` FOREIGN KEY (`datetime`) REFERENCES `datetime` (`id`),
 CONSTRAINT `accretionbehavior_marketcenter` FOREIGN KEY (`marketcenter`) REFERENCES `marketcenter` (`id`),
 CONSTRAINT `accretionbehavior_multiplier` FOREIGN KEY (`multiplier`) REFERENCES `multiplier` (`id`),
 CONSTRAINT `accretionbehavior_quantitytype` FOREIGN KEY (`quantitytype`) REFERENCES `quantitytype` (`id`),
 CONSTRAINT `accretionbehavior_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `accretionbehavior_valationtype` FOREIGN KEY (`valuationtype`) REFERENCES `valuationtype` (`id`),
 CONSTRAINT `accretionbehavior_valuationref` FOREIGN KEY (`valuationref`) REFERENCES `valuationref` (`id`),
 CONSTRAINT `accrtinbhvir_frctinhndlingtype` FOREIGN KEY (`fractionhandlingtype`) REFERENCES `fractionhandlingtype` (`id`),
 CONSTRAINT `accrtnbhvir_qntitydscriptintyp` FOREIGN KEY (`quantitydescriptiontype`) REFERENCES `quantitydescriptiontype` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `accretionbehavior` --

/*!40000 ALTER TABLE `accretionbehavior` DISABLE KEYS */; /*!40000 ALTER TABLE `accretionbehavior` ENABLE KEYS */;

-- -- Definition of table `accretiontype` --

DROP TABLE IF EXISTS `accretiontype`; CREATE TABLE `accretiontype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `source` bigint(20) DEFAULT NULL,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `accretiontype_source` (`source`),
 CONSTRAINT `accretiontype_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `accretiontype` --

/*!40000 ALTER TABLE `accretiontype` DISABLE KEYS */; /*!40000 ALTER TABLE `accretiontype` ENABLE KEYS */;

-- -- Definition of table `accrual` --

DROP TABLE IF EXISTS `accrual`; CREATE TABLE `accrual` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `accrualbasis` bigint(20) DEFAULT NULL,
 `daysinmonth` bigint(20) DEFAULT NULL,
 `daysinyear` bigint(20) DEFAULT NULL,
 `period` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `accrual_accrualbasis` (`accrualbasis`),
 KEY `accrual_daysinmonth` (`daysinmonth`),
 KEY `accrual_source` (`source`),
 KEY `accrual_period` (`period`),
 KEY `accrual_daysinyear` (`daysinyear`),
 CONSTRAINT `accrual_daysinyear` FOREIGN KEY (`daysinyear`) REFERENCES `daysinyear` (`id`),
 CONSTRAINT `accrual_accrualbasis` FOREIGN KEY (`accrualbasis`) REFERENCES `accrualbasis` (`id`),
 CONSTRAINT `accrual_daysinmonth` FOREIGN KEY (`daysinmonth`) REFERENCES `daysinmonth` (`id`),
 CONSTRAINT `accrual_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `accrual_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `accrual` --

/*!40000 ALTER TABLE `accrual` DISABLE KEYS */; /*!40000 ALTER TABLE `accrual` ENABLE KEYS */;

-- -- Definition of table `accrualbasis` --

DROP TABLE IF EXISTS `accrualbasis`; CREATE TABLE `accrualbasis` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `accrualbasistype` bigint(20) DEFAULT NULL,
 `accrualconventiontype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `accrualbasis_source` (`source`),
 KEY `accrualbasis_accrualbasistype` (`accrualbasistype`),
 KEY `accrualbasis_indicatorstype` (`indicatorstype`),
 KEY `accralbasis_accralcnventintype` (`accrualconventiontype`),
 CONSTRAINT `accralbasis_accralcnventintype` FOREIGN KEY (`accrualconventiontype`) REFERENCES `accrualconventiontype` (`id`),
 CONSTRAINT `accrualbasis_accrualbasistype` FOREIGN KEY (`accrualbasistype`) REFERENCES `accrualbasistype` (`id`),
 CONSTRAINT `accrualbasis_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `accrualbasis_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `accrualbasis` --

/*!40000 ALTER TABLE `accrualbasis` DISABLE KEYS */; /*!40000 ALTER TABLE `accrualbasis` ENABLE KEYS */;

-- -- Definition of table `accrualbasistype` --

DROP TABLE IF EXISTS `accrualbasistype`; CREATE TABLE `accrualbasistype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `accrualbasistype` --

/*!40000 ALTER TABLE `accrualbasistype` DISABLE KEYS */; /*!40000 ALTER TABLE `accrualbasistype` ENABLE KEYS */;

-- -- Definition of table `accrualconventiontype` --

DROP TABLE IF EXISTS `accrualconventiontype`; CREATE TABLE `accrualconventiontype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `accrualconventiontype` --

/*!40000 ALTER TABLE `accrualconventiontype` DISABLE KEYS */; /*!40000 ALTER TABLE `accrualconventiontype` ENABLE KEYS */;

-- -- Definition of table `address` --

DROP TABLE IF EXISTS `address`; CREATE TABLE `address` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `rank` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `address` varchar(255) DEFAULT NULL,
 `lang` varchar(255) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `address_source` (`source`),
 KEY `address_rank` (`rank`),
 CONSTRAINT `address_rank` FOREIGN KEY (`rank`) REFERENCES `rank` (`id`),
 CONSTRAINT `address_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `address` --

/*!40000 ALTER TABLE `address` DISABLE KEYS */; /*!40000 ALTER TABLE `address` ENABLE KEYS */;

-- -- Definition of table `agencyrankings` --

DROP TABLE IF EXISTS `agencyrankings`; CREATE TABLE `agencyrankings` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `agent` bigint(20) DEFAULT NULL,
 `ranking` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `agencyrankings_source` (`source`),
 KEY `agencyrankings_agent` (`agent`),
 KEY `agencyrankings_ranking` (`ranking`),
 CONSTRAINT `agencyrankings_ranking` FOREIGN KEY (`ranking`) REFERENCES `ranking` (`id`),
 CONSTRAINT `agencyrankings_agent` FOREIGN KEY (`agent`) REFERENCES `agent` (`id`),
 CONSTRAINT `agencyrankings_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `agencyrankings` --

/*!40000 ALTER TABLE `agencyrankings` DISABLE KEYS */; /*!40000 ALTER TABLE `agencyrankings` ENABLE KEYS */;

-- -- Definition of table `agencyratings` --

DROP TABLE IF EXISTS `agencyratings`; CREATE TABLE `agencyratings` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `agent` bigint(20) DEFAULT NULL,
 `rating` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `agencyratings_source` (`source`),
 KEY `agencyratings_agent` (`agent`),
 KEY `agencyratings_rating` (`rating`),
 CONSTRAINT `agencyratings_rating` FOREIGN KEY (`rating`) REFERENCES `rating` (`id`),
 CONSTRAINT `agencyratings_agent` FOREIGN KEY (`agent`) REFERENCES `agent` (`id`),
 CONSTRAINT `agencyratings_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `agencyratings` --

/*!40000 ALTER TABLE `agencyratings` DISABLE KEYS */; /*!40000 ALTER TABLE `agencyratings` ENABLE KEYS */;

-- -- Definition of table `agent` --

DROP TABLE IF EXISTS `agent`; CREATE TABLE `agent` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `agenttype` bigint(20) DEFAULT NULL,
 `code` bigint(20) DEFAULT NULL,
 `name` bigint(20) DEFAULT NULL,
 `previouscode` bigint(20) DEFAULT NULL,
 `entitytype` bigint(20) DEFAULT NULL,
 `industryidentifier` bigint(20) DEFAULT NULL,
 `location` bigint(20) DEFAULT NULL,
 `partystatustype` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `agent_source` (`source`),
 KEY `agent_location` (`location`),
 KEY `agent_agenttype` (`agenttype`),
 KEY `agent_industryidentifier` (`industryidentifier`),
 KEY `agent_previouscode` (`previouscode`),
 KEY `agent_partystatustype` (`partystatustype`),
 KEY `agent_name` (`name`),
 KEY `agent_entitytype` (`entitytype`),
 KEY `agent_code` (`code`),
 CONSTRAINT `agent_code` FOREIGN KEY (`code`) REFERENCES `code` (`id`),
 CONSTRAINT `agent_agenttype` FOREIGN KEY (`agenttype`) REFERENCES `agenttype` (`id`),
 CONSTRAINT `agent_entitytype` FOREIGN KEY (`entitytype`) REFERENCES `entitytype` (`id`),
 CONSTRAINT `agent_industryidentifier` FOREIGN KEY (`industryidentifier`) REFERENCES `industryidentifier` (`id`),
 CONSTRAINT `agent_location` FOREIGN KEY (`location`) REFERENCES `location` (`id`),
 CONSTRAINT `agent_name` FOREIGN KEY (`name`) REFERENCES `name` (`id`),
 CONSTRAINT `agent_partystatustype` FOREIGN KEY (`partystatustype`) REFERENCES `partystatustype` (`id`),
 CONSTRAINT `agent_previouscode` FOREIGN KEY (`previouscode`) REFERENCES `previouscode` (`id`),
 CONSTRAINT `agent_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `agent` --

/*!40000 ALTER TABLE `agent` DISABLE KEYS */; /*!40000 ALTER TABLE `agent` ENABLE KEYS */;

-- -- Definition of table `agenttype` --

DROP TABLE IF EXISTS `agenttype`; CREATE TABLE `agenttype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `agenttype` --

/*!40000 ALTER TABLE `agenttype` DISABLE KEYS */; /*!40000 ALTER TABLE `agenttype` ENABLE KEYS */;

-- -- Definition of table `agreedrestrictions` --

DROP TABLE IF EXISTS `agreedrestrictions`; CREATE TABLE `agreedrestrictions` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `source` bigint(20) DEFAULT NULL,
 `agreedrestriction` varchar(255) DEFAULT NULL,
 `lang` varchar(255) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `agreedrestrictions_source` (`source`),
 CONSTRAINT `agreedrestrictions_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `agreedrestrictions` --

/*!40000 ALTER TABLE `agreedrestrictions` DISABLE KEYS */; /*!40000 ALTER TABLE `agreedrestrictions` ENABLE KEYS */;

-- -- Definition of table `allowedindebtedness` --

DROP TABLE IF EXISTS `allowedindebtedness`; CREATE TABLE `allowedindebtedness` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `source` bigint(20) DEFAULT NULL,
 `allowedindebtedness` varchar(255) DEFAULT NULL,
 `lang` varchar(255) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `allowedindebtedness_source` (`source`),
 CONSTRAINT `allowedindebtedness_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `allowedindebtedness` --

/*!40000 ALTER TABLE `allowedindebtedness` DISABLE KEYS */; /*!40000 ALTER TABLE `allowedindebtedness` ENABLE KEYS */;

-- -- Definition of table `amortization` --

DROP TABLE IF EXISTS `amortization`; CREATE TABLE `amortization` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `amortizationbehavior` bigint(20) DEFAULT NULL,
 `amortizationtype` bigint(20) DEFAULT NULL,
 `firstamount` bigint(20) DEFAULT NULL,
 `firstdate` bigint(20) DEFAULT NULL,
 `lastamount` bigint(20) DEFAULT NULL,
 `lastdate` bigint(20) DEFAULT NULL,
 `nextamount` bigint(20) DEFAULT NULL,
 `nextdate` bigint(20) DEFAULT NULL,
 `nextperiod` bigint(20) DEFAULT NULL,
 `penultimateamount` bigint(20) DEFAULT NULL,
 `penultimatedate` bigint(20) DEFAULT NULL,
 `period` bigint(20) DEFAULT NULL,
 `schedule` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `amortization` bit(1) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `amortization_firstdate` (`firstdate`),
 KEY `amortization_firstamount` (`firstamount`),
 KEY `amortization_source` (`source`),
 KEY `amortization_period` (`period`),
 KEY `amortization_nextperiod` (`nextperiod`),
 KEY `amortization_amortizationtype` (`amortizationtype`),
 KEY `amortization_schedule` (`schedule`),
 KEY `amortization_penultimatedate` (`penultimatedate`),
 KEY `amortization_penultimateamount` (`penultimateamount`),
 KEY `amrtizatin_amrtizationbehavior` (`amortizationbehavior`),
 KEY `amortization_nextamount` (`nextamount`),
 KEY `amortization_nextdate` (`nextdate`),
 KEY `amortization_lastdate` (`lastdate`),
 KEY `amortization_lastamount` (`lastamount`),
 CONSTRAINT `amortization_lastamount` FOREIGN KEY (`lastamount`) REFERENCES `amount` (`id`),
 CONSTRAINT `amortization_amortizationtype` FOREIGN KEY (`amortizationtype`) REFERENCES `amortizationtype` (`id`),
 CONSTRAINT `amortization_firstamount` FOREIGN KEY (`firstamount`) REFERENCES `amount` (`id`),
 CONSTRAINT `amortization_firstdate` FOREIGN KEY (`firstdate`) REFERENCES `marketdate` (`id`),
 CONSTRAINT `amortization_lastdate` FOREIGN KEY (`lastdate`) REFERENCES `marketdate` (`id`),
 CONSTRAINT `amortization_nextamount` FOREIGN KEY (`nextamount`) REFERENCES `amount` (`id`),
 CONSTRAINT `amortization_nextdate` FOREIGN KEY (`nextdate`) REFERENCES `marketdate` (`id`),
 CONSTRAINT `amortization_nextperiod` FOREIGN KEY (`nextperiod`) REFERENCES `nextperiod` (`id`),
 CONSTRAINT `amortization_penultimateamount` FOREIGN KEY (`penultimateamount`) REFERENCES `amount` (`id`),
 CONSTRAINT `amortization_penultimatedate` FOREIGN KEY (`penultimatedate`) REFERENCES `marketdate` (`id`),
 CONSTRAINT `amortization_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `amortization_schedule` FOREIGN KEY (`schedule`) REFERENCES `schedule` (`id`),
 CONSTRAINT `amortization_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `amrtizatin_amrtizationbehavior` FOREIGN KEY (`amortizationbehavior`) REFERENCES `amortizationbehavior` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `amortization` --

/*!40000 ALTER TABLE `amortization` DISABLE KEYS */; /*!40000 ALTER TABLE `amortization` ENABLE KEYS */;

-- -- Definition of table `amortizationbehavior` --

DROP TABLE IF EXISTS `amortizationbehavior`; CREATE TABLE `amortizationbehavior` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `calculationtype` bigint(20) DEFAULT NULL,
 `datetime` bigint(20) DEFAULT NULL,
 `fraction` bigint(20) DEFAULT NULL,
 `fractionhandlingtype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `marketcenter` bigint(20) DEFAULT NULL,
 `multiplier` bigint(20) DEFAULT NULL,
 `previousdatetime` bigint(20) DEFAULT NULL,
 `quantitydescriptiontype` bigint(20) DEFAULT NULL,
 `quantitytype` bigint(20) DEFAULT NULL,
 `valuationref` bigint(20) DEFAULT NULL,
 `valuationtype` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `amortizationbehaviour` decimal(19,2) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `amortizationbehavior_source` (`source`),
 KEY `amrtizatinbehavir_valationtype` (`valuationtype`),
 KEY `amrtztnbhvr_qntitydscriptintyp` (`quantitydescriptiontype`),
 KEY `amortizationbehavior_mltiplier` (`multiplier`),
 KEY `amrtizatinbehavior_qantitytype` (`quantitytype`),
 KEY `amrtiztinbehvir_previsdatetime` (`previousdatetime`),
 KEY `amrtztinbhvir_frctinhndlingtyp` (`fractionhandlingtype`),
 KEY `amrtizatinbehavior_valationref` (`valuationref`),
 KEY `amrtiztinbehavir_calclatintype` (`calculationtype`),
 KEY `amortizationbehavior_datetime` (`datetime`),
 KEY `amrtizatinbehavir_marketcenter` (`marketcenter`),
 KEY `amrtiztinbehavir_indicatrstype` (`indicatorstype`),
 KEY `amortizationbehavior_fraction` (`fraction`),
 CONSTRAINT `amortizationbehavior_fraction` FOREIGN KEY (`fraction`) REFERENCES `fraction` (`id`),
 CONSTRAINT `amortizationbehavior_datetime` FOREIGN KEY (`datetime`) REFERENCES `datetime` (`id`),
 CONSTRAINT `amortizationbehavior_mltiplier` FOREIGN KEY (`multiplier`) REFERENCES `multiplier` (`id`),
 CONSTRAINT `amortizationbehavior_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `amrtizatinbehavior_qantitytype` FOREIGN KEY (`quantitytype`) REFERENCES `quantitytype` (`id`),
 CONSTRAINT `amrtizatinbehavior_valationref` FOREIGN KEY (`valuationref`) REFERENCES `valuationref` (`id`),
 CONSTRAINT `amrtizatinbehavir_marketcenter` FOREIGN KEY (`marketcenter`) REFERENCES `marketcenter` (`id`),
 CONSTRAINT `amrtizatinbehavir_valationtype` FOREIGN KEY (`valuationtype`) REFERENCES `valuationtype` (`id`),
 CONSTRAINT `amrtiztinbehavir_calclatintype` FOREIGN KEY (`calculationtype`) REFERENCES `calculationtype` (`id`),
 CONSTRAINT `amrtiztinbehavir_indicatrstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `amrtiztinbehvir_previsdatetime` FOREIGN KEY (`previousdatetime`) REFERENCES `previousdatetime` (`id`),
 CONSTRAINT `amrtztinbhvir_frctinhndlingtyp` FOREIGN KEY (`fractionhandlingtype`) REFERENCES `fractionhandlingtype` (`id`),
 CONSTRAINT `amrtztnbhvr_qntitydscriptintyp` FOREIGN KEY (`quantitydescriptiontype`) REFERENCES `quantitydescriptiontype` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `amortizationbehavior` --

/*!40000 ALTER TABLE `amortizationbehavior` DISABLE KEYS */; /*!40000 ALTER TABLE `amortizationbehavior` ENABLE KEYS */;

-- -- Definition of table `amortizationtype` --

DROP TABLE IF EXISTS `amortizationtype`; CREATE TABLE `amortizationtype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `amortizationtype` --

/*!40000 ALTER TABLE `amortizationtype` DISABLE KEYS */; /*!40000 ALTER TABLE `amortizationtype` ENABLE KEYS */;

-- -- Definition of table `amount` --

DROP TABLE IF EXISTS `amount`; CREATE TABLE `amount` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `calculationtype` bigint(20) DEFAULT NULL,
 `datetime` bigint(20) DEFAULT NULL,
 `fraction` bigint(20) DEFAULT NULL,
 `fractionhandlingtype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `marketcenter` bigint(20) DEFAULT NULL,
 `multiplier` bigint(20) DEFAULT NULL,
 `previousdatetime` bigint(20) DEFAULT NULL,
 `quantitydescriptiontype` bigint(20) DEFAULT NULL,
 `quantitytype` bigint(20) DEFAULT NULL,
 `valuationref` bigint(20) DEFAULT NULL,
 `valuationtype` bigint(20) DEFAULT NULL,
 `crossrate` bigint(20) DEFAULT NULL,
 `currency` bigint(20) DEFAULT NULL,
 `size` bigint(20) DEFAULT NULL,
 `paymentdelay` bigint(20) DEFAULT NULL,
 `amount` decimal(19,2) DEFAULT NULL,
 `type` int(11) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `amount_valuationtype` (`valuationtype`),
 KEY `amount_currency` (`currency`),
 KEY `amount_quantitydescriptiontype` (`quantitydescriptiontype`),
 KEY `amount_multiplier` (`multiplier`),
 KEY `amount_quantitytype` (`quantitytype`),
 KEY `amount_previousdatetime` (`previousdatetime`),
 KEY `amount_crossrate` (`crossrate`),
 KEY `amount_fractionhandlingtype` (`fractionhandlingtype`),
 KEY `amount_valuationref` (`valuationref`),
 KEY `amount_calculationtype` (`calculationtype`),
 KEY `amount_datetime` (`datetime`),
 KEY `amount_size` (`size`),
 KEY `amount_marketcenter` (`marketcenter`),
 KEY `amount_indicatorstype` (`indicatorstype`),
 KEY `amount_paymentdelay` (`paymentdelay`),
 KEY `amount_fraction` (`fraction`),
 CONSTRAINT `amount_fraction` FOREIGN KEY (`fraction`) REFERENCES `fraction` (`id`),
 CONSTRAINT `amount_calculationtype` FOREIGN KEY (`calculationtype`) REFERENCES `calculationtype` (`id`),
 CONSTRAINT `amount_crossrate` FOREIGN KEY (`crossrate`) REFERENCES `crossrate` (`id`),
 CONSTRAINT `amount_currency` FOREIGN KEY (`currency`) REFERENCES `currency` (`id`),
 CONSTRAINT `amount_datetime` FOREIGN KEY (`datetime`) REFERENCES `datetime` (`id`),
 CONSTRAINT `amount_fractionhandlingtype` FOREIGN KEY (`fractionhandlingtype`) REFERENCES `fractionhandlingtype` (`id`),
 CONSTRAINT `amount_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `amount_marketcenter` FOREIGN KEY (`marketcenter`) REFERENCES `marketcenter` (`id`),
 CONSTRAINT `amount_multiplier` FOREIGN KEY (`multiplier`) REFERENCES `multiplier` (`id`),
 CONSTRAINT `amount_paymentdelay` FOREIGN KEY (`paymentdelay`) REFERENCES `paymentdelay` (`id`),
 CONSTRAINT `amount_previousdatetime` FOREIGN KEY (`previousdatetime`) REFERENCES `previousdatetime` (`id`),
 CONSTRAINT `amount_quantitydescriptiontype` FOREIGN KEY (`quantitydescriptiontype`) REFERENCES `quantitydescriptiontype` (`id`),
 CONSTRAINT `amount_quantitytype` FOREIGN KEY (`quantitytype`) REFERENCES `quantitytype` (`id`),
 CONSTRAINT `amount_size` FOREIGN KEY (`size`) REFERENCES `size` (`id`),
 CONSTRAINT `amount_valuationref` FOREIGN KEY (`valuationref`) REFERENCES `valuationref` (`id`),
 CONSTRAINT `amount_valuationtype` FOREIGN KEY (`valuationtype`) REFERENCES `valuationtype` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `amount` --

/*!40000 ALTER TABLE `amount` DISABLE KEYS */; /*!40000 ALTER TABLE `amount` ENABLE KEYS */;

-- -- Definition of table `amountoutstanding` --

DROP TABLE IF EXISTS `amountoutstanding`; CREATE TABLE `amountoutstanding` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `amountoutstandingtype` bigint(20) DEFAULT NULL,
 `calculationtype` bigint(20) DEFAULT NULL,
 `datetime` bigint(20) DEFAULT NULL,
 `fraction` bigint(20) DEFAULT NULL,
 `fractionhandlingtype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `marketcenter` bigint(20) DEFAULT NULL,
 `multiplier` bigint(20) DEFAULT NULL,
 `previousdatetime` bigint(20) DEFAULT NULL,
 `quantitydescriptiontype` bigint(20) DEFAULT NULL,
 `quantitytype` bigint(20) DEFAULT NULL,
 `valuationref` bigint(20) DEFAULT NULL,
 `valuationtype` bigint(20) DEFAULT NULL,
 `crossrate` bigint(20) DEFAULT NULL,
 `currency` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `amountoutstanding` decimal(19,2) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `amountoutstanding_source` (`source`),
 KEY `amontoutstanding_valuationtype` (`valuationtype`),
 KEY `amountoutstanding_currency` (`currency`),
 KEY `amnttstndng_qntitydscriptintyp` (`quantitydescriptiontype`),
 KEY `amountoutstanding_multiplier` (`multiplier`),
 KEY `amountoutstanding_quantitytype` (`quantitytype`),
 KEY `amntotstanding_previosdatetime` (`previousdatetime`),
 KEY `amountoutstanding_crossrate` (`crossrate`),
 KEY `amnttstnding_frctinhndlingtype` (`fractionhandlingtype`),
 KEY `amountoutstanding_valuationref` (`valuationref`),
 KEY `amontotstanding_calclationtype` (`calculationtype`),
 KEY `amnttstnding_amnttstandingtype` (`amountoutstandingtype`),
 KEY `amountoutstanding_datetime` (`datetime`),
 KEY `amountoutstanding_marketcenter` (`marketcenter`),
 KEY `amontotstanding_indicatorstype` (`indicatorstype`),
 KEY `amountoutstanding_fraction` (`fraction`),
 CONSTRAINT `amountoutstanding_fraction` FOREIGN KEY (`fraction`) REFERENCES `fraction` (`id`),
 CONSTRAINT `amntotstanding_previosdatetime` FOREIGN KEY (`previousdatetime`) REFERENCES `previousdatetime` (`id`),
 CONSTRAINT `amnttstnding_amnttstandingtype` FOREIGN KEY (`amountoutstandingtype`) REFERENCES `amountoutstandingtype` (`id`),
 CONSTRAINT `amnttstnding_frctinhndlingtype` FOREIGN KEY (`fractionhandlingtype`) REFERENCES `fractionhandlingtype` (`id`),
 CONSTRAINT `amnttstndng_qntitydscriptintyp` FOREIGN KEY (`quantitydescriptiontype`) REFERENCES `quantitydescriptiontype` (`id`),
 CONSTRAINT `amontotstanding_calclationtype` FOREIGN KEY (`calculationtype`) REFERENCES `calculationtype` (`id`),
 CONSTRAINT `amontotstanding_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `amontoutstanding_valuationtype` FOREIGN KEY (`valuationtype`) REFERENCES `valuationtype` (`id`),
 CONSTRAINT `amountoutstanding_crossrate` FOREIGN KEY (`crossrate`) REFERENCES `crossrate` (`id`),
 CONSTRAINT `amountoutstanding_currency` FOREIGN KEY (`currency`) REFERENCES `currency` (`id`),
 CONSTRAINT `amountoutstanding_datetime` FOREIGN KEY (`datetime`) REFERENCES `datetime` (`id`),
 CONSTRAINT `amountoutstanding_marketcenter` FOREIGN KEY (`marketcenter`) REFERENCES `marketcenter` (`id`),
 CONSTRAINT `amountoutstanding_multiplier` FOREIGN KEY (`multiplier`) REFERENCES `multiplier` (`id`),
 CONSTRAINT `amountoutstanding_quantitytype` FOREIGN KEY (`quantitytype`) REFERENCES `quantitytype` (`id`),
 CONSTRAINT `amountoutstanding_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `amountoutstanding_valuationref` FOREIGN KEY (`valuationref`) REFERENCES `valuationref` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `amountoutstanding` --

/*!40000 ALTER TABLE `amountoutstanding` DISABLE KEYS */; /*!40000 ALTER TABLE `amountoutstanding` ENABLE KEYS */;

-- -- Definition of table `amountoutstandingtype` --

DROP TABLE IF EXISTS `amountoutstandingtype`; CREATE TABLE `amountoutstandingtype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `amountoutstandingtype` --

/*!40000 ALTER TABLE `amountoutstandingtype` DISABLE KEYS */; /*!40000 ALTER TABLE `amountoutstandingtype` ENABLE KEYS */;

-- -- Definition of table `analytics` --

DROP TABLE IF EXISTS `analytics`; CREATE TABLE `analytics` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `analytics_source` (`source`),
 CONSTRAINT `analytics_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `analytics` --

/*!40000 ALTER TABLE `analytics` DISABLE KEYS */; /*!40000 ALTER TABLE `analytics` ENABLE KEYS */;

-- -- Definition of table `announcementdate` --

DROP TABLE IF EXISTS `announcementdate`; CREATE TABLE `announcementdate` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `dayruletype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `marketcenter` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `announcementdate` datetime DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `announcementdate_source` (`source`),
 KEY `announcementdate_dayruletype` (`dayruletype`),
 KEY `announcementdate_marketcenter` (`marketcenter`),
 KEY `annoncementdate_indicatorstype` (`indicatorstype`),
 CONSTRAINT `annoncementdate_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `announcementdate_dayruletype` FOREIGN KEY (`dayruletype`) REFERENCES `dayruletype` (`id`),
 CONSTRAINT `announcementdate_marketcenter` FOREIGN KEY (`marketcenter`) REFERENCES `marketcenter` (`id`),
 CONSTRAINT `announcementdate_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `announcementdate` --

/*!40000 ALTER TABLE `announcementdate` DISABLE KEYS */; /*!40000 ALTER TABLE `announcementdate` ENABLE KEYS */;

-- -- Definition of table `ask` --

DROP TABLE IF EXISTS `ask`; CREATE TABLE `ask` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `last` bigint(20) DEFAULT NULL,
 `marketidentifier` bigint(20) DEFAULT NULL,
 `change` bigint(20) DEFAULT NULL,
 `close` bigint(20) DEFAULT NULL,
 `low` bigint(20) DEFAULT NULL,
 `open` bigint(20) DEFAULT NULL,
 `rank` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `ask_open` (`open`),
 KEY `ask_marketidentifier` (`marketidentifier`),
 KEY `ask_source` (`source`),
 KEY `ask_last` (`last`),
 KEY `ask_rank` (`rank`),
 KEY `ask_close` (`close`),
 KEY `ask_low` (`low`),
 KEY `ask_change` (`change`),
 CONSTRAINT `ask_change` FOREIGN KEY (`change`) REFERENCES `change` (`id`),
 CONSTRAINT `ask_close` FOREIGN KEY (`close`) REFERENCES `close` (`id`),
 CONSTRAINT `ask_last` FOREIGN KEY (`last`) REFERENCES `last` (`id`),
 CONSTRAINT `ask_low` FOREIGN KEY (`low`) REFERENCES `low` (`id`),
 CONSTRAINT `ask_marketidentifier` FOREIGN KEY (`marketidentifier`) REFERENCES `marketidentifier` (`id`),
 CONSTRAINT `ask_open` FOREIGN KEY (`open`) REFERENCES `open` (`id`),
 CONSTRAINT `ask_rank` FOREIGN KEY (`rank`) REFERENCES `rank` (`id`),
 CONSTRAINT `ask_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `ask` --

/*!40000 ALTER TABLE `ask` DISABLE KEYS */; /*!40000 ALTER TABLE `ask` ENABLE KEYS */;

-- -- Definition of table `auctiondate` --

DROP TABLE IF EXISTS `auctiondate`; CREATE TABLE `auctiondate` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `dayruletype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `marketcenter` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `auctiondate` date DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `auctiondate_source` (`source`),
 KEY `auctiondate_dayruletype` (`dayruletype`),
 KEY `auctiondate_marketcenter` (`marketcenter`),
 KEY `auctiondate_indicatorstype` (`indicatorstype`),
 CONSTRAINT `auctiondate_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `auctiondate_dayruletype` FOREIGN KEY (`dayruletype`) REFERENCES `dayruletype` (`id`),
 CONSTRAINT `auctiondate_marketcenter` FOREIGN KEY (`marketcenter`) REFERENCES `marketcenter` (`id`),
 CONSTRAINT `auctiondate_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `auctiondate` --

/*!40000 ALTER TABLE `auctiondate` DISABLE KEYS */; /*!40000 ALTER TABLE `auctiondate` ENABLE KEYS */;

-- -- Definition of table `background` --

DROP TABLE IF EXISTS `background`; CREATE TABLE `background` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `source` bigint(20) DEFAULT NULL,
 `background` varchar(255) DEFAULT NULL,
 `lang` varchar(255) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `background_source` (`source`),
 CONSTRAINT `background_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `background` --

/*!40000 ALTER TABLE `background` DISABLE KEYS */; /*!40000 ALTER TABLE `background` ENABLE KEYS */;

-- -- Definition of table `basevalue` --

DROP TABLE IF EXISTS `basevalue`; CREATE TABLE `basevalue` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `calculationtype` bigint(20) DEFAULT NULL,
 `datetime` bigint(20) DEFAULT NULL,
 `fraction` bigint(20) DEFAULT NULL,
 `fractionhandlingtype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `marketcenter` bigint(20) DEFAULT NULL,
 `multiplier` bigint(20) DEFAULT NULL,
 `previousdatetime` bigint(20) DEFAULT NULL,
 `quantitydescriptiontype` bigint(20) DEFAULT NULL,
 `quantitytype` bigint(20) DEFAULT NULL,
 `valuationref` bigint(20) DEFAULT NULL,
 `valuationtype` bigint(20) DEFAULT NULL,
 `unittype` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `basevalue` decimal(19,2) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `basevalue_source` (`source`),
 KEY `basevalue_valuationtype` (`valuationtype`),
 KEY `basevale_qantitydescriptintype` (`quantitydescriptiontype`),
 KEY `basevalue_multiplier` (`multiplier`),
 KEY `basevalue_quantitytype` (`quantitytype`),
 KEY `basevalue_previousdatetime` (`previousdatetime`),
 KEY `basevalue_fractionhandlingtype` (`fractionhandlingtype`),
 KEY `basevalue_valuationref` (`valuationref`),
 KEY `basevalue_calculationtype` (`calculationtype`),
 KEY `basevalue_unittype` (`unittype`),
 KEY `basevalue_datetime` (`datetime`),
 KEY `basevalue_marketcenter` (`marketcenter`),
 KEY `basevalue_indicatorstype` (`indicatorstype`),
 KEY `basevalue_fraction` (`fraction`),
 CONSTRAINT `basevalue_fraction` FOREIGN KEY (`fraction`) REFERENCES `fraction` (`id`),
 CONSTRAINT `basevale_qantitydescriptintype` FOREIGN KEY (`quantitydescriptiontype`) REFERENCES `quantitydescriptiontype` (`id`),
 CONSTRAINT `basevalue_calculationtype` FOREIGN KEY (`calculationtype`) REFERENCES `calculationtype` (`id`),
 CONSTRAINT `basevalue_datetime` FOREIGN KEY (`datetime`) REFERENCES `datetime` (`id`),
 CONSTRAINT `basevalue_fractionhandlingtype` FOREIGN KEY (`fractionhandlingtype`) REFERENCES `fractionhandlingtype` (`id`),
 CONSTRAINT `basevalue_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `basevalue_marketcenter` FOREIGN KEY (`marketcenter`) REFERENCES `marketcenter` (`id`),
 CONSTRAINT `basevalue_multiplier` FOREIGN KEY (`multiplier`) REFERENCES `multiplier` (`id`),
 CONSTRAINT `basevalue_previousdatetime` FOREIGN KEY (`previousdatetime`) REFERENCES `previousdatetime` (`id`),
 CONSTRAINT `basevalue_quantitytype` FOREIGN KEY (`quantitytype`) REFERENCES `quantitytype` (`id`),
 CONSTRAINT `basevalue_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `basevalue_unittype` FOREIGN KEY (`unittype`) REFERENCES `unittype` (`id`),
 CONSTRAINT `basevalue_valuationref` FOREIGN KEY (`valuationref`) REFERENCES `valuationref` (`id`),
 CONSTRAINT `basevalue_valuationtype` FOREIGN KEY (`valuationtype`) REFERENCES `valuationtype` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `basevalue` --

/*!40000 ALTER TABLE `basevalue` DISABLE KEYS */; /*!40000 ALTER TABLE `basevalue` ENABLE KEYS */;

-- -- Definition of table `benchmark` --

DROP TABLE IF EXISTS `benchmark`; CREATE TABLE `benchmark` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `code` bigint(20) DEFAULT NULL,
 `name` bigint(20) DEFAULT NULL,
 `previouscode` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `benchmark_source` (`source`),
 KEY `benchmark_previouscode` (`previouscode`),
 KEY `benchmark_name` (`name`),
 KEY `benchmark_code` (`code`),
 CONSTRAINT `benchmark_code` FOREIGN KEY (`code`) REFERENCES `code` (`id`),
 CONSTRAINT `benchmark_name` FOREIGN KEY (`name`) REFERENCES `name` (`id`),
 CONSTRAINT `benchmark_previouscode` FOREIGN KEY (`previouscode`) REFERENCES `previouscode` (`id`),
 CONSTRAINT `benchmark_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `benchmark` --

/*!40000 ALTER TABLE `benchmark` DISABLE KEYS */; /*!40000 ALTER TABLE `benchmark` ENABLE KEYS */;

-- -- Definition of table `benchmarkstrategy` --

DROP TABLE IF EXISTS `benchmarkstrategy`; CREATE TABLE `benchmarkstrategy` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `source` bigint(20) DEFAULT NULL,
 `benchmarkstrategy` varchar(255) DEFAULT NULL,
 `lang` varchar(255) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `benchmarkstrategy_source` (`source`),
 CONSTRAINT `benchmarkstrategy_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `benchmarkstrategy` --

/*!40000 ALTER TABLE `benchmarkstrategy` DISABLE KEYS */; /*!40000 ALTER TABLE `benchmarkstrategy` ENABLE KEYS */;

-- -- Definition of table `bid` --

DROP TABLE IF EXISTS `bid`; CREATE TABLE `bid` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `last` bigint(20) DEFAULT NULL,
 `marketidentifier` bigint(20) DEFAULT NULL,
 `change` bigint(20) DEFAULT NULL,
 `close` bigint(20) DEFAULT NULL,
 `high` bigint(20) DEFAULT NULL,
 `low` bigint(20) DEFAULT NULL,
 `open` bigint(20) DEFAULT NULL,
 `rank` bigint(20) DEFAULT NULL,
 `yield` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `bid_open` (`open`),
 KEY `bid_marketidentifier` (`marketidentifier`),
 KEY `bid_source` (`source`),
 KEY `bid_last` (`last`),
 KEY `bid_high` (`high`),
 KEY `bid_yield` (`yield`),
 KEY `bid_rank` (`rank`),
 KEY `bid_close` (`close`),
 KEY `bid_low` (`low`),
 KEY `bid_change` (`change`),
 CONSTRAINT `bid_change` FOREIGN KEY (`change`) REFERENCES `change` (`id`),
 CONSTRAINT `bid_close` FOREIGN KEY (`close`) REFERENCES `close` (`id`),
 CONSTRAINT `bid_high` FOREIGN KEY (`high`) REFERENCES `high` (`id`),
 CONSTRAINT `bid_last` FOREIGN KEY (`last`) REFERENCES `last` (`id`),
 CONSTRAINT `bid_low` FOREIGN KEY (`low`) REFERENCES `low` (`id`),
 CONSTRAINT `bid_marketidentifier` FOREIGN KEY (`marketidentifier`) REFERENCES `marketidentifier` (`id`),
 CONSTRAINT `bid_open` FOREIGN KEY (`open`) REFERENCES `open` (`id`),
 CONSTRAINT `bid_rank` FOREIGN KEY (`rank`) REFERENCES `rank` (`id`),
 CONSTRAINT `bid_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `bid_yield` FOREIGN KEY (`yield`) REFERENCES `yield` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `bid` --

/*!40000 ALTER TABLE `bid` DISABLE KEYS */; /*!40000 ALTER TABLE `bid` ENABLE KEYS */;

-- -- Definition of table `blocking` --

DROP TABLE IF EXISTS `blocking`; CREATE TABLE `blocking` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `period` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `blocking` datetime DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `blocking_source` (`source`),
 KEY `blocking_period` (`period`),
 CONSTRAINT `blocking_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `blocking_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `blocking` --

/*!40000 ALTER TABLE `blocking` DISABLE KEYS */; /*!40000 ALTER TABLE `blocking` ENABLE KEYS */;

-- -- Definition of table `businessclass` --

DROP TABLE IF EXISTS `businessclass`; CREATE TABLE `businessclass` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `comment` bigint(20) DEFAULT NULL,
 `creationdate` bigint(20) DEFAULT NULL,
 `datetime` bigint(20) DEFAULT NULL,
 `entityidentifier` bigint(20) DEFAULT NULL,
 `entitystatustype` bigint(20) DEFAULT NULL,
 `jurisdiction` bigint(20) DEFAULT NULL,
 `location` bigint(20) DEFAULT NULL,
 `period` bigint(20) DEFAULT NULL,
 `pointofcontact` bigint(20) DEFAULT NULL,
 `replacemententity` bigint(20) DEFAULT NULL,
 `replacementtype` bigint(20) DEFAULT NULL,
 `reviewdate` bigint(20) DEFAULT NULL,
 `sponsor` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `bsinessclass_replacemententity` (`replacemententity`),
 KEY `businessclass_source` (`source`),
 KEY `businessclass_entityidentifier` (`entityidentifier`),
 KEY `businessclass_location` (`location`),
 KEY `businessclass_period` (`period`),
 KEY `businessclass_reviewdate` (`reviewdate`),
 KEY `businessclass_replacementtype` (`replacementtype`),
 KEY `businessclass_comment` (`comment`),
 KEY `businessclass_entitystatustype` (`entitystatustype`),
 KEY `businessclass_sponsor` (`sponsor`),
 KEY `businessclass_datetime` (`datetime`),
 KEY `businessclass_creationdate` (`creationdate`),
 KEY `businessclass_pointofcontact` (`pointofcontact`),
 KEY `businessclass_jurisdiction` (`jurisdiction`),
 CONSTRAINT `businessclass_jurisdiction` FOREIGN KEY (`jurisdiction`) REFERENCES `jurisdiction` (`id`),
 CONSTRAINT `bsinessclass_replacemententity` FOREIGN KEY (`replacemententity`) REFERENCES `replacemententity` (`id`),
 CONSTRAINT `businessclass_comment` FOREIGN KEY (`comment`) REFERENCES `comment` (`id`),
 CONSTRAINT `businessclass_creationdate` FOREIGN KEY (`creationdate`) REFERENCES `creationdate` (`id`),
 CONSTRAINT `businessclass_datetime` FOREIGN KEY (`datetime`) REFERENCES `datetime` (`id`),
 CONSTRAINT `businessclass_entityidentifier` FOREIGN KEY (`entityidentifier`) REFERENCES `entityidentifier` (`id`),
 CONSTRAINT `businessclass_entitystatustype` FOREIGN KEY (`entitystatustype`) REFERENCES `entitystatustype` (`id`),
 CONSTRAINT `businessclass_location` FOREIGN KEY (`location`) REFERENCES `location` (`id`),
 CONSTRAINT `businessclass_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `businessclass_pointofcontact` FOREIGN KEY (`pointofcontact`) REFERENCES `pointofcontact` (`id`),
 CONSTRAINT `businessclass_replacementtype` FOREIGN KEY (`replacementtype`) REFERENCES `replacementtype` (`id`),
 CONSTRAINT `businessclass_reviewdate` FOREIGN KEY (`reviewdate`) REFERENCES `reviewdate` (`id`),
 CONSTRAINT `businessclass_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `businessclass_sponsor` FOREIGN KEY (`sponsor`) REFERENCES `sponsor` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `businessclass` --

/*!40000 ALTER TABLE `businessclass` DISABLE KEYS */; /*!40000 ALTER TABLE `businessclass` ENABLE KEYS */;

-- -- Definition of table `caedate` --

DROP TABLE IF EXISTS `caedate`; CREATE TABLE `caedate` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `period` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `caedate` datetime DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `caedate_source` (`source`),
 KEY `caedate_period` (`period`),
 CONSTRAINT `caedate_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `caedate_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `caedate` --

/*!40000 ALTER TABLE `caedate` DISABLE KEYS */; /*!40000 ALTER TABLE `caedate` ENABLE KEYS */;

-- -- Definition of table `caedomain` --

DROP TABLE IF EXISTS `caedomain`; CREATE TABLE `caedomain` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `corporateactionsclass` bigint(20) DEFAULT NULL,
 `corporateeventsclass` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `snap` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `caedomain_source` (`source`),
 KEY `caedomain_snap` (`snap`),
 KEY `caedomain_corporateeventsclass` (`corporateeventsclass`),
 KEY `caedmain_corporateactionsclass` (`corporateactionsclass`),
 CONSTRAINT `caedmain_corporateactionsclass` FOREIGN KEY (`corporateactionsclass`) REFERENCES `corporateactionsclass` (`id`),
 CONSTRAINT `caedomain_corporateeventsclass` FOREIGN KEY (`corporateeventsclass`) REFERENCES `corporateeventsclass` (`id`),
 CONSTRAINT `caedomain_snap` FOREIGN KEY (`snap`) REFERENCES `snap` (`id`),
 CONSTRAINT `caedomain_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `caedomain` --

/*!40000 ALTER TABLE `caedomain` DISABLE KEYS */; /*!40000 ALTER TABLE `caedomain` ENABLE KEYS */;

-- -- Definition of table `caeidentifier` --

DROP TABLE IF EXISTS `caeidentifier`; CREATE TABLE `caeidentifier` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `source` bigint(20) DEFAULT NULL,
 `caeidentifier` varchar(255) DEFAULT NULL,
 `lang` varchar(255) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `caeidentifier_source` (`source`),
 CONSTRAINT `caeidentifier_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `caeidentifier` --

/*!40000 ALTER TABLE `caeidentifier` DISABLE KEYS */; /*!40000 ALTER TABLE `caeidentifier` ENABLE KEYS */;

-- -- Definition of table `caelifecycletype` --

DROP TABLE IF EXISTS `caelifecycletype`; CREATE TABLE `caelifecycletype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `caelifecycletype` --

/*!40000 ALTER TABLE `caelifecycletype` DISABLE KEYS */; /*!40000 ALTER TABLE `caelifecycletype` ENABLE KEYS */;

-- -- Definition of table `caestatustype` --

DROP TABLE IF EXISTS `caestatustype`; CREATE TABLE `caestatustype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `caestatustype` --

/*!40000 ALTER TABLE `caestatustype` DISABLE KEYS */; /*!40000 ALTER TABLE `caestatustype` ENABLE KEYS */;

-- -- Definition of table `caetype` --

DROP TABLE IF EXISTS `caetype`; CREATE TABLE `caetype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `caetype` --

/*!40000 ALTER TABLE `caetype` DISABLE KEYS */; /*!40000 ALTER TABLE `caetype` ENABLE KEYS */;

-- -- Definition of table `calculationtype` --

DROP TABLE IF EXISTS `calculationtype`; CREATE TABLE `calculationtype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `calculationtype` --

/*!40000 ALTER TABLE `calculationtype` DISABLE KEYS */; /*!40000 ALTER TABLE `calculationtype` ENABLE KEYS */;

-- -- Definition of table `callable` --

DROP TABLE IF EXISTS `callable`; CREATE TABLE `callable` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `callabletype` bigint(20) DEFAULT NULL,
 `callconditiontype` bigint(20) DEFAULT NULL,
 `cleanup` bigint(20) DEFAULT NULL,
 `declining` bigint(20) DEFAULT NULL,
 `exerciserights` bigint(20) DEFAULT NULL,
 `firstamount` bigint(20) DEFAULT NULL,
 `firstdate` bigint(20) DEFAULT NULL,
 `lastamount` bigint(20) DEFAULT NULL,
 `lastdate` bigint(20) DEFAULT NULL,
 `makewholecall` bigint(20) DEFAULT NULL,
 `nextamount` bigint(20) DEFAULT NULL,
 `nextdate` bigint(20) DEFAULT NULL,
 `nextperiod` bigint(20) DEFAULT NULL,
 `notification` bigint(20) DEFAULT NULL,
 `partial` bigint(20) DEFAULT NULL,
 `penultimateamount` bigint(20) DEFAULT NULL,
 `penultimatedate` bigint(20) DEFAULT NULL,
 `period` bigint(20) DEFAULT NULL,
 `schedule` bigint(20) DEFAULT NULL,
 `softcall` bigint(20) DEFAULT NULL,
 `specialredemption` bigint(20) DEFAULT NULL,
 `taxreasons` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `callable` bit(1) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `callable_firstdate` (`firstdate`),
 KEY `callable_firstamount` (`firstamount`),
 KEY `callable_makewholecall` (`makewholecall`),
 KEY `callable_source` (`source`),
 KEY `callable_specialredemption` (`specialredemption`),
 KEY `callable_period` (`period`),
 KEY `callable_nextperiod` (`nextperiod`),
 KEY `callable_callconditiontype` (`callconditiontype`),
 KEY `callable_softcall` (`softcall`),
 KEY `callable_declining` (`declining`),
 KEY `callable_schedule` (`schedule`),
 KEY `callable_exerciserights` (`exerciserights`),
 KEY `callable_penultimatedate` (`penultimatedate`),
 KEY `callable_penultimateamount` (`penultimateamount`),
 KEY `callable_cleanup` (`cleanup`),
 KEY `callable_nextamount` (`nextamount`),
 KEY `callable_nextdate` (`nextdate`),
 KEY `callable_lastdate` (`lastdate`),
 KEY `callable_lastamount` (`lastamount`),
 KEY `callable_notification` (`notification`),
 KEY `callable_callabletype` (`callabletype`),
 KEY `callable_partial` (`partial`),
 KEY `callable_taxreasons` (`taxreasons`),
 CONSTRAINT `callable_taxreasons` FOREIGN KEY (`taxreasons`) REFERENCES `taxreasons` (`id`),
 CONSTRAINT `callable_callabletype` FOREIGN KEY (`callabletype`) REFERENCES `callabletype` (`id`),
 CONSTRAINT `callable_callconditiontype` FOREIGN KEY (`callconditiontype`) REFERENCES `callconditiontype` (`id`),
 CONSTRAINT `callable_cleanup` FOREIGN KEY (`cleanup`) REFERENCES `cleanup` (`id`),
 CONSTRAINT `callable_declining` FOREIGN KEY (`declining`) REFERENCES `declining` (`id`),
 CONSTRAINT `callable_exerciserights` FOREIGN KEY (`exerciserights`) REFERENCES `exerciserights` (`id`),
 CONSTRAINT `callable_firstamount` FOREIGN KEY (`firstamount`) REFERENCES `amount` (`id`),
 CONSTRAINT `callable_firstdate` FOREIGN KEY (`firstdate`) REFERENCES `marketdate` (`id`),
 CONSTRAINT `callable_lastamount` FOREIGN KEY (`lastamount`) REFERENCES `amount` (`id`),
 CONSTRAINT `callable_lastdate` FOREIGN KEY (`lastdate`) REFERENCES `marketdate` (`id`),
 CONSTRAINT `callable_makewholecall` FOREIGN KEY (`makewholecall`) REFERENCES `makewholecall` (`id`),
 CONSTRAINT `callable_nextamount` FOREIGN KEY (`nextamount`) REFERENCES `amount` (`id`),
 CONSTRAINT `callable_nextdate` FOREIGN KEY (`nextdate`) REFERENCES `marketdate` (`id`),
 CONSTRAINT `callable_nextperiod` FOREIGN KEY (`nextperiod`) REFERENCES `nextperiod` (`id`),
 CONSTRAINT `callable_notification` FOREIGN KEY (`notification`) REFERENCES `notification` (`id`),
 CONSTRAINT `callable_partial` FOREIGN KEY (`partial`) REFERENCES `partial` (`id`),
 CONSTRAINT `callable_penultimateamount` FOREIGN KEY (`penultimateamount`) REFERENCES `amount` (`id`),
 CONSTRAINT `callable_penultimatedate` FOREIGN KEY (`penultimatedate`) REFERENCES `marketdate` (`id`),
 CONSTRAINT `callable_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `callable_schedule` FOREIGN KEY (`schedule`) REFERENCES `schedule` (`id`),
 CONSTRAINT `callable_softcall` FOREIGN KEY (`softcall`) REFERENCES `softcall` (`id`),
 CONSTRAINT `callable_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `callable_specialredemption` FOREIGN KEY (`specialredemption`) REFERENCES `specialredemption` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `callable` --

/*!40000 ALTER TABLE `callable` DISABLE KEYS */; /*!40000 ALTER TABLE `callable` ENABLE KEYS */;

-- -- Definition of table `callabletype` --

DROP TABLE IF EXISTS `callabletype`; CREATE TABLE `callabletype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `callabletype` --

/*!40000 ALTER TABLE `callabletype` DISABLE KEYS */; /*!40000 ALTER TABLE `callabletype` ENABLE KEYS */;

-- -- Definition of table `callconditiontype` --

DROP TABLE IF EXISTS `callconditiontype`; CREATE TABLE `callconditiontype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `callconditiontype` --

/*!40000 ALTER TABLE `callconditiontype` DISABLE KEYS */; /*!40000 ALTER TABLE `callconditiontype` ENABLE KEYS */;

-- -- Definition of table `capitalizationtype` --

DROP TABLE IF EXISTS `capitalizationtype`; CREATE TABLE `capitalizationtype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `capitalizationtype` --

/*!40000 ALTER TABLE `capitalizationtype` DISABLE KEYS */; /*!40000 ALTER TABLE `capitalizationtype` ENABLE KEYS */;

-- -- Definition of table `capped` --

DROP TABLE IF EXISTS `capped`; CREATE TABLE `capped` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `calculationtype` bigint(20) DEFAULT NULL,
 `datetime` bigint(20) DEFAULT NULL,
 `fraction` bigint(20) DEFAULT NULL,
 `fractionhandlingtype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `marketcenter` bigint(20) DEFAULT NULL,
 `multiplier` bigint(20) DEFAULT NULL,
 `previousdatetime` bigint(20) DEFAULT NULL,
 `quantitydescriptiontype` bigint(20) DEFAULT NULL,
 `quantitytype` bigint(20) DEFAULT NULL,
 `valuationref` bigint(20) DEFAULT NULL,
 `valuationtype` bigint(20) DEFAULT NULL,
 `crossrate` bigint(20) DEFAULT NULL,
 `currency` bigint(20) DEFAULT NULL,
 `size` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `capped` decimal(19,2) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `capped_source` (`source`),
 KEY `capped_valuationtype` (`valuationtype`),
 KEY `capped_currency` (`currency`),
 KEY `capped_quantitydescriptiontype` (`quantitydescriptiontype`),
 KEY `capped_multiplier` (`multiplier`),
 KEY `capped_quantitytype` (`quantitytype`),
 KEY `capped_previousdatetime` (`previousdatetime`),
 KEY `capped_crossrate` (`crossrate`),
 KEY `capped_fractionhandlingtype` (`fractionhandlingtype`),
 KEY `capped_valuationref` (`valuationref`),
 KEY `capped_calculationtype` (`calculationtype`),
 KEY `capped_datetime` (`datetime`),
 KEY `capped_size` (`size`),
 KEY `capped_marketcenter` (`marketcenter`),
 KEY `capped_indicatorstype` (`indicatorstype`),
 KEY `capped_fraction` (`fraction`),
 CONSTRAINT `capped_fraction` FOREIGN KEY (`fraction`) REFERENCES `fraction` (`id`),
 CONSTRAINT `capped_calculationtype` FOREIGN KEY (`calculationtype`) REFERENCES `calculationtype` (`id`),
 CONSTRAINT `capped_crossrate` FOREIGN KEY (`crossrate`) REFERENCES `crossrate` (`id`),
 CONSTRAINT `capped_currency` FOREIGN KEY (`currency`) REFERENCES `currency` (`id`),
 CONSTRAINT `capped_datetime` FOREIGN KEY (`datetime`) REFERENCES `datetime` (`id`),
 CONSTRAINT `capped_fractionhandlingtype` FOREIGN KEY (`fractionhandlingtype`) REFERENCES `fractionhandlingtype` (`id`),
 CONSTRAINT `capped_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `capped_marketcenter` FOREIGN KEY (`marketcenter`) REFERENCES `marketcenter` (`id`),
 CONSTRAINT `capped_multiplier` FOREIGN KEY (`multiplier`) REFERENCES `multiplier` (`id`),
 CONSTRAINT `capped_previousdatetime` FOREIGN KEY (`previousdatetime`) REFERENCES `previousdatetime` (`id`),
 CONSTRAINT `capped_quantitydescriptiontype` FOREIGN KEY (`quantitydescriptiontype`) REFERENCES `quantitydescriptiontype` (`id`),
 CONSTRAINT `capped_quantitytype` FOREIGN KEY (`quantitytype`) REFERENCES `quantitytype` (`id`),
 CONSTRAINT `capped_size` FOREIGN KEY (`size`) REFERENCES `size` (`id`),
 CONSTRAINT `capped_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `capped_valuationref` FOREIGN KEY (`valuationref`) REFERENCES `valuationref` (`id`),
 CONSTRAINT `capped_valuationtype` FOREIGN KEY (`valuationtype`) REFERENCES `valuationtype` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `capped` --

/*!40000 ALTER TABLE `capped` DISABLE KEYS */; /*!40000 ALTER TABLE `capped` ENABLE KEYS */;

-- -- Definition of table `cashdomain` --

DROP TABLE IF EXISTS `cashdomain`; CREATE TABLE `cashdomain` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `cashdomain_source` (`source`),
 CONSTRAINT `cashdomain_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `cashdomain` --

/*!40000 ALTER TABLE `cashdomain` DISABLE KEYS */; /*!40000 ALTER TABLE `cashdomain` ENABLE KEYS */;

-- -- Definition of table `ceasedate` --

DROP TABLE IF EXISTS `ceasedate`; CREATE TABLE `ceasedate` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `calculationtype` bigint(20) DEFAULT NULL,
 `datetime` bigint(20) DEFAULT NULL,
 `fraction` bigint(20) DEFAULT NULL,
 `fractionhandlingtype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `marketcenter` bigint(20) DEFAULT NULL,
 `multiplier` bigint(20) DEFAULT NULL,
 `previousdatetime` bigint(20) DEFAULT NULL,
 `quantitydescriptiontype` bigint(20) DEFAULT NULL,
 `quantitytype` bigint(20) DEFAULT NULL,
 `valuationref` bigint(20) DEFAULT NULL,
 `valuationtype` bigint(20) DEFAULT NULL,
 `crossrate` bigint(20) DEFAULT NULL,
 `currency` bigint(20) DEFAULT NULL,
 `size` bigint(20) DEFAULT NULL,
 `snap` bigint(20) DEFAULT NULL,
 `ceasedate` datetime DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `ceasedate_snap` (`snap`),
 KEY `ceasedate_valuationtype` (`valuationtype`),
 KEY `ceasedate_currency` (`currency`),
 KEY `cesedate_qantitydescriptintype` (`quantitydescriptiontype`),
 KEY `ceasedate_multiplier` (`multiplier`),
 KEY `ceasedate_quantitytype` (`quantitytype`),
 KEY `ceasedate_previousdatetime` (`previousdatetime`),
 KEY `ceasedate_crossrate` (`crossrate`),
 KEY `ceasedate_fractionhandlingtype` (`fractionhandlingtype`),
 KEY `ceasedate_valuationref` (`valuationref`),
 KEY `ceasedate_calculationtype` (`calculationtype`),
 KEY `ceasedate_datetime` (`datetime`),
 KEY `ceasedate_size` (`size`),
 KEY `ceasedate_marketcenter` (`marketcenter`),
 KEY `ceasedate_indicatorstype` (`indicatorstype`),
 KEY `ceasedate_fraction` (`fraction`),
 CONSTRAINT `ceasedate_fraction` FOREIGN KEY (`fraction`) REFERENCES `fraction` (`id`),
 CONSTRAINT `ceasedate_calculationtype` FOREIGN KEY (`calculationtype`) REFERENCES `calculationtype` (`id`),
 CONSTRAINT `ceasedate_crossrate` FOREIGN KEY (`crossrate`) REFERENCES `crossrate` (`id`),
 CONSTRAINT `ceasedate_currency` FOREIGN KEY (`currency`) REFERENCES `currency` (`id`),
 CONSTRAINT `ceasedate_datetime` FOREIGN KEY (`datetime`) REFERENCES `datetime` (`id`),
 CONSTRAINT `ceasedate_fractionhandlingtype` FOREIGN KEY (`fractionhandlingtype`) REFERENCES `fractionhandlingtype` (`id`),
 CONSTRAINT `ceasedate_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `ceasedate_marketcenter` FOREIGN KEY (`marketcenter`) REFERENCES `marketcenter` (`id`),
 CONSTRAINT `ceasedate_multiplier` FOREIGN KEY (`multiplier`) REFERENCES `multiplier` (`id`),
 CONSTRAINT `ceasedate_previousdatetime` FOREIGN KEY (`previousdatetime`) REFERENCES `previousdatetime` (`id`),
 CONSTRAINT `ceasedate_quantitytype` FOREIGN KEY (`quantitytype`) REFERENCES `quantitytype` (`id`),
 CONSTRAINT `ceasedate_size` FOREIGN KEY (`size`) REFERENCES `size` (`id`),
 CONSTRAINT `ceasedate_snap` FOREIGN KEY (`snap`) REFERENCES `snap` (`id`),
 CONSTRAINT `ceasedate_valuationref` FOREIGN KEY (`valuationref`) REFERENCES `valuationref` (`id`),
 CONSTRAINT `ceasedate_valuationtype` FOREIGN KEY (`valuationtype`) REFERENCES `valuationtype` (`id`),
 CONSTRAINT `cesedate_qantitydescriptintype` FOREIGN KEY (`quantitydescriptiontype`) REFERENCES `quantitydescriptiontype` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `ceasedate` --

/*!40000 ALTER TABLE `ceasedate` DISABLE KEYS */; /*!40000 ALTER TABLE `ceasedate` ENABLE KEYS */;

-- -- Definition of table `change` --

DROP TABLE IF EXISTS `change`; CREATE TABLE `change` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `changedirection` bigint(20) DEFAULT NULL,
 `changetype` bigint(20) DEFAULT NULL,
 `calculationtype` bigint(20) DEFAULT NULL,
 `datetime` bigint(20) DEFAULT NULL,
 `fraction` bigint(20) DEFAULT NULL,
 `fractionhandlingtype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `marketcenter` bigint(20) DEFAULT NULL,
 `multiplier` bigint(20) DEFAULT NULL,
 `previousdatetime` bigint(20) DEFAULT NULL,
 `quantitydescriptiontype` bigint(20) DEFAULT NULL,
 `quantitytype` bigint(20) DEFAULT NULL,
 `valuationref` bigint(20) DEFAULT NULL,
 `valuationtype` bigint(20) DEFAULT NULL,
 `crossrate` bigint(20) DEFAULT NULL,
 `currency` bigint(20) DEFAULT NULL,
 `size` bigint(20) DEFAULT NULL,
 `period` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `change` decimal(19,2) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `change_changetype` (`changetype`),
 KEY `change_source` (`source`),
 KEY `change_period` (`period`),
 KEY `change_valuationtype` (`valuationtype`),
 KEY `change_currency` (`currency`),
 KEY `change_quantitydescriptiontype` (`quantitydescriptiontype`),
 KEY `change_multiplier` (`multiplier`),
 KEY `change_quantitytype` (`quantitytype`),
 KEY `change_previousdatetime` (`previousdatetime`),
 KEY `change_crossrate` (`crossrate`),
 KEY `change_fractionhandlingtype` (`fractionhandlingtype`),
 KEY `change_changedirection` (`changedirection`),
 KEY `change_valuationref` (`valuationref`),
 KEY `change_calculationtype` (`calculationtype`),
 KEY `change_datetime` (`datetime`),
 KEY `change_size` (`size`),
 KEY `change_marketcenter` (`marketcenter`),
 KEY `change_indicatorstype` (`indicatorstype`),
 KEY `change_fraction` (`fraction`),
 CONSTRAINT `change_fraction` FOREIGN KEY (`fraction`) REFERENCES `fraction` (`id`),
 CONSTRAINT `change_calculationtype` FOREIGN KEY (`calculationtype`) REFERENCES `calculationtype` (`id`),
 CONSTRAINT `change_changedirection` FOREIGN KEY (`changedirection`) REFERENCES `changedirection` (`id`),
 CONSTRAINT `change_changetype` FOREIGN KEY (`changetype`) REFERENCES `changetype` (`id`),
 CONSTRAINT `change_crossrate` FOREIGN KEY (`crossrate`) REFERENCES `crossrate` (`id`),
 CONSTRAINT `change_currency` FOREIGN KEY (`currency`) REFERENCES `currency` (`id`),
 CONSTRAINT `change_datetime` FOREIGN KEY (`datetime`) REFERENCES `datetime` (`id`),
 CONSTRAINT `change_fractionhandlingtype` FOREIGN KEY (`fractionhandlingtype`) REFERENCES `fractionhandlingtype` (`id`),
 CONSTRAINT `change_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `change_marketcenter` FOREIGN KEY (`marketcenter`) REFERENCES `marketcenter` (`id`),
 CONSTRAINT `change_multiplier` FOREIGN KEY (`multiplier`) REFERENCES `multiplier` (`id`),
 CONSTRAINT `change_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `change_previousdatetime` FOREIGN KEY (`previousdatetime`) REFERENCES `previousdatetime` (`id`),
 CONSTRAINT `change_quantitydescriptiontype` FOREIGN KEY (`quantitydescriptiontype`) REFERENCES `quantitydescriptiontype` (`id`),
 CONSTRAINT `change_quantitytype` FOREIGN KEY (`quantitytype`) REFERENCES `quantitytype` (`id`),
 CONSTRAINT `change_size` FOREIGN KEY (`size`) REFERENCES `size` (`id`),
 CONSTRAINT `change_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `change_valuationref` FOREIGN KEY (`valuationref`) REFERENCES `valuationref` (`id`),
 CONSTRAINT `change_valuationtype` FOREIGN KEY (`valuationtype`) REFERENCES `valuationtype` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `change` --

/*!40000 ALTER TABLE `change` DISABLE KEYS */; /*!40000 ALTER TABLE `change` ENABLE KEYS */;

-- -- Definition of table `changedirection` --

DROP TABLE IF EXISTS `changedirection`; CREATE TABLE `changedirection` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `changedirection` --

/*!40000 ALTER TABLE `changedirection` DISABLE KEYS */; /*!40000 ALTER TABLE `changedirection` ENABLE KEYS */;

-- -- Definition of table `changetype` --

DROP TABLE IF EXISTS `changetype`; CREATE TABLE `changetype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `changetype` --

/*!40000 ALTER TABLE `changetype` DISABLE KEYS */; /*!40000 ALTER TABLE `changetype` ENABLE KEYS */;

-- -- Definition of table `cleanup` --

DROP TABLE IF EXISTS `cleanup`; CREATE TABLE `cleanup` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `instrumentidentifier` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `cleanup` decimal(19,2) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `cleanup_source` (`source`),
 KEY `cleanup_instrumentidentifier` (`instrumentidentifier`),
 CONSTRAINT `cleanup_instrumentidentifier` FOREIGN KEY (`instrumentidentifier`) REFERENCES `instrumentidentifier` (`id`),
 CONSTRAINT `cleanup_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `cleanup` --

/*!40000 ALTER TABLE `cleanup` DISABLE KEYS */; /*!40000 ALTER TABLE `cleanup` ENABLE KEYS */;

-- -- Definition of table `clearinghouse` --

DROP TABLE IF EXISTS `clearinghouse`; CREATE TABLE `clearinghouse` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `period` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `clearinghouse` varchar(255) DEFAULT NULL,
 `lang` varchar(255) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `clearinghouse_source` (`source`),
 KEY `clearinghouse_period` (`period`),
 CONSTRAINT `clearinghouse_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `clearinghouse_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `clearinghouse` --

/*!40000 ALTER TABLE `clearinghouse` DISABLE KEYS */; /*!40000 ALTER TABLE `clearinghouse` ENABLE KEYS */;

-- -- Definition of table `clearingprocess` --

DROP TABLE IF EXISTS `clearingprocess`; CREATE TABLE `clearingprocess` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `period` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `clearinghouse` varchar(255) DEFAULT NULL,
 `lang` varchar(255) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `clearingprocess_source` (`source`),
 KEY `clearingprocess_period` (`period`),
 CONSTRAINT `clearingprocess_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `clearingprocess_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `clearingprocess` --

/*!40000 ALTER TABLE `clearingprocess` DISABLE KEYS */; /*!40000 ALTER TABLE `clearingprocess` ENABLE KEYS */;

-- -- Definition of table `clearingsettlement` --

DROP TABLE IF EXISTS `clearingsettlement`; CREATE TABLE `clearingsettlement` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `clearinghouse` bigint(20) DEFAULT NULL,
 `clearingprocess` bigint(20) DEFAULT NULL,
 `clearingsystem` bigint(20) DEFAULT NULL,
 `currency` bigint(20) DEFAULT NULL,
 `depositoryname` bigint(20) DEFAULT NULL,
 `depositorysystem` bigint(20) DEFAULT NULL,
 `marketidentifier` bigint(20) DEFAULT NULL,
 `partiesinvolved` bigint(20) DEFAULT NULL,
 `settlementtype` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `clringsttlment_mrketidentifier` (`marketidentifier`),
 KEY `clearingsettlement_clearinghse` (`clearinghouse`),
 KEY `clearingsettlement_source` (`source`),
 KEY `clringsttlement_depsitrysystem` (`depositorysystem`),
 KEY `cleringsettlement_depsitryname` (`depositoryname`),
 KEY `clearingsettlement_currency` (`currency`),
 KEY `clringsttlement_settlementtype` (`settlementtype`),
 KEY `clringsettlement_cleringsystem` (`clearingsystem`),
 KEY `clringsettlement_prtiesinvlved` (`partiesinvolved`),
 KEY `clringsettlement_cleringprcess` (`clearingprocess`),
 CONSTRAINT `clringsettlement_cleringprcess` FOREIGN KEY (`clearingprocess`) REFERENCES `clearingprocess` (`id`),
 CONSTRAINT `clearingsettlement_clearinghse` FOREIGN KEY (`clearinghouse`) REFERENCES `clearinghouse` (`id`),
 CONSTRAINT `clearingsettlement_currency` FOREIGN KEY (`currency`) REFERENCES `currency` (`id`),
 CONSTRAINT `clearingsettlement_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `cleringsettlement_depsitryname` FOREIGN KEY (`depositoryname`) REFERENCES `depositoryname` (`id`),
 CONSTRAINT `clringsettlement_cleringsystem` FOREIGN KEY (`clearingsystem`) REFERENCES `clearingsystem` (`id`),
 CONSTRAINT `clringsettlement_prtiesinvlved` FOREIGN KEY (`partiesinvolved`) REFERENCES `partiesinvolved` (`id`),
 CONSTRAINT `clringsttlement_depsitrysystem` FOREIGN KEY (`depositorysystem`) REFERENCES `depositorysystem` (`id`),
 CONSTRAINT `clringsttlement_settlementtype` FOREIGN KEY (`settlementtype`) REFERENCES `settlementtype` (`id`),
 CONSTRAINT `clringsttlment_mrketidentifier` FOREIGN KEY (`marketidentifier`) REFERENCES `marketidentifier` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `clearingsettlement` --

/*!40000 ALTER TABLE `clearingsettlement` DISABLE KEYS */; /*!40000 ALTER TABLE `clearingsettlement` ENABLE KEYS */;

-- -- Definition of table `clearingsystem` --

DROP TABLE IF EXISTS `clearingsystem`; CREATE TABLE `clearingsystem` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `period` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `clearingsystem` varchar(255) DEFAULT NULL,
 `lang` varchar(255) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `clearingsystem_source` (`source`),
 KEY `clearingsystem_period` (`period`),
 CONSTRAINT `clearingsystem_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `clearingsystem_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `clearingsystem` --

/*!40000 ALTER TABLE `clearingsystem` DISABLE KEYS */; /*!40000 ALTER TABLE `clearingsystem` ENABLE KEYS */;

-- -- Definition of table `close` --

DROP TABLE IF EXISTS `close`; CREATE TABLE `close` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `calculationtype` bigint(20) DEFAULT NULL,
 `datetime` bigint(20) DEFAULT NULL,
 `fraction` bigint(20) DEFAULT NULL,
 `fractionhandlingtype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `marketcenter` bigint(20) DEFAULT NULL,
 `multiplier` bigint(20) DEFAULT NULL,
 `previousdatetime` bigint(20) DEFAULT NULL,
 `quantitydescriptiontype` bigint(20) DEFAULT NULL,
 `quantitytype` bigint(20) DEFAULT NULL,
 `valuationref` bigint(20) DEFAULT NULL,
 `valuationtype` bigint(20) DEFAULT NULL,
 `crossrate` bigint(20) DEFAULT NULL,
 `currency` bigint(20) DEFAULT NULL,
 `size` bigint(20) DEFAULT NULL,
 `closetype` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `close` decimal(19,2) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `close_closetype` (`closetype`),
 KEY `close_source` (`source`),
 KEY `close_valuationtype` (`valuationtype`),
 KEY `close_currency` (`currency`),
 KEY `close_quantitydescriptiontype` (`quantitydescriptiontype`),
 KEY `close_multiplier` (`multiplier`),
 KEY `close_quantitytype` (`quantitytype`),
 KEY `close_previousdatetime` (`previousdatetime`),
 KEY `close_crossrate` (`crossrate`),
 KEY `close_fractionhandlingtype` (`fractionhandlingtype`),
 KEY `close_valuationref` (`valuationref`),
 KEY `close_calculationtype` (`calculationtype`),
 KEY `close_datetime` (`datetime`),
 KEY `close_size` (`size`),
 KEY `close_marketcenter` (`marketcenter`),
 KEY `close_indicatorstype` (`indicatorstype`),
 KEY `close_fraction` (`fraction`),
 CONSTRAINT `close_fraction` FOREIGN KEY (`fraction`) REFERENCES `fraction` (`id`),
 CONSTRAINT `close_calculationtype` FOREIGN KEY (`calculationtype`) REFERENCES `calculationtype` (`id`),
 CONSTRAINT `close_closetype` FOREIGN KEY (`closetype`) REFERENCES `closetype` (`id`),
 CONSTRAINT `close_crossrate` FOREIGN KEY (`crossrate`) REFERENCES `crossrate` (`id`),
 CONSTRAINT `close_currency` FOREIGN KEY (`currency`) REFERENCES `currency` (`id`),
 CONSTRAINT `close_datetime` FOREIGN KEY (`datetime`) REFERENCES `datetime` (`id`),
 CONSTRAINT `close_fractionhandlingtype` FOREIGN KEY (`fractionhandlingtype`) REFERENCES `fractionhandlingtype` (`id`),
 CONSTRAINT `close_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `close_marketcenter` FOREIGN KEY (`marketcenter`) REFERENCES `marketcenter` (`id`),
 CONSTRAINT `close_multiplier` FOREIGN KEY (`multiplier`) REFERENCES `multiplier` (`id`),
 CONSTRAINT `close_previousdatetime` FOREIGN KEY (`previousdatetime`) REFERENCES `previousdatetime` (`id`),
 CONSTRAINT `close_quantitydescriptiontype` FOREIGN KEY (`quantitydescriptiontype`) REFERENCES `quantitydescriptiontype` (`id`),
 CONSTRAINT `close_quantitytype` FOREIGN KEY (`quantitytype`) REFERENCES `quantitytype` (`id`),
 CONSTRAINT `close_size` FOREIGN KEY (`size`) REFERENCES `size` (`id`),
 CONSTRAINT `close_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `close_valuationref` FOREIGN KEY (`valuationref`) REFERENCES `valuationref` (`id`),
 CONSTRAINT `close_valuationtype` FOREIGN KEY (`valuationtype`) REFERENCES `valuationtype` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `close` --

/*!40000 ALTER TABLE `close` DISABLE KEYS */; /*!40000 ALTER TABLE `close` ENABLE KEYS */;

-- -- Definition of table `closetype` --

DROP TABLE IF EXISTS `closetype`; CREATE TABLE `closetype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `closetype` --

/*!40000 ALTER TABLE `closetype` DISABLE KEYS */; /*!40000 ALTER TABLE `closetype` ENABLE KEYS */;

-- -- Definition of table `closingdate` --

DROP TABLE IF EXISTS `closingdate`; CREATE TABLE `closingdate` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `dayruletype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `marketcenter` bigint(20) DEFAULT NULL,
 `closingdatetype` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `closingdate` date DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `closingdate_source` (`source`),
 KEY `closingdate_dayruletype` (`dayruletype`),
 KEY `closingdate_closingdatetype` (`closingdatetype`),
 KEY `closingdate_marketcenter` (`marketcenter`),
 KEY `closingdate_indicatorstype` (`indicatorstype`),
 CONSTRAINT `closingdate_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `closingdate_closingdatetype` FOREIGN KEY (`closingdatetype`) REFERENCES `closingdatetype` (`id`),
 CONSTRAINT `closingdate_dayruletype` FOREIGN KEY (`dayruletype`) REFERENCES `dayruletype` (`id`),
 CONSTRAINT `closingdate_marketcenter` FOREIGN KEY (`marketcenter`) REFERENCES `marketcenter` (`id`),
 CONSTRAINT `closingdate_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `closingdate` --

/*!40000 ALTER TABLE `closingdate` DISABLE KEYS */; /*!40000 ALTER TABLE `closingdate` ENABLE KEYS */;

-- -- Definition of table `closingdatetype` --

DROP TABLE IF EXISTS `closingdatetype`; CREATE TABLE `closingdatetype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `closingdatetype` --

/*!40000 ALTER TABLE `closingdatetype` DISABLE KEYS */; /*!40000 ALTER TABLE `closingdatetype` ENABLE KEYS */;

-- -- Definition of table `code` --

DROP TABLE IF EXISTS `code`; CREATE TABLE `code` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `codetype` bigint(20) DEFAULT NULL,
 `description` bigint(20) DEFAULT NULL,
 `nameref` bigint(20) DEFAULT NULL,
 `period` bigint(20) DEFAULT NULL,
 `rank` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `code` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `code_source` (`source`),
 KEY `code_period` (`period`),
 KEY `code_rank` (`rank`),
 KEY `code_nameref` (`nameref`),
 KEY `code_codetype` (`codetype`),
 KEY `code_description` (`description`),
 CONSTRAINT `code_description` FOREIGN KEY (`description`) REFERENCES `description` (`id`),
 CONSTRAINT `code_codetype` FOREIGN KEY (`codetype`) REFERENCES `codetype` (`id`),
 CONSTRAINT `code_nameref` FOREIGN KEY (`nameref`) REFERENCES `nameref` (`id`),
 CONSTRAINT `code_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `code_rank` FOREIGN KEY (`rank`) REFERENCES `rank` (`id`),
 CONSTRAINT `code_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `code` --

/*!40000 ALTER TABLE `code` DISABLE KEYS */; /*!40000 ALTER TABLE `code` ENABLE KEYS */;

-- -- Definition of table `codetype` --

DROP TABLE IF EXISTS `codetype`; CREATE TABLE `codetype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `codetype` --

/*!40000 ALTER TABLE `codetype` DISABLE KEYS */; /*!40000 ALTER TABLE `codetype` ENABLE KEYS */;

-- -- Definition of table `collateral` --

DROP TABLE IF EXISTS `collateral`; CREATE TABLE `collateral` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `collateraltype` bigint(20) DEFAULT NULL,
 `interestrate` bigint(20) DEFAULT NULL,
 `maturity` bigint(20) DEFAULT NULL,
 `underlying` bigint(20) DEFAULT NULL,
 `underlyingcount` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `collateral_interestrate` (`interestrate`),
 KEY `collateral_source` (`source`),
 KEY `collateral_underlyingcount` (`underlyingcount`),
 KEY `collateral_underlying` (`underlying`),
 KEY `collateral_maturity` (`maturity`),
 KEY `collateral_collateraltype` (`collateraltype`),
 CONSTRAINT `collateral_collateraltype` FOREIGN KEY (`collateraltype`) REFERENCES `collateraltype` (`id`),
 CONSTRAINT `collateral_interestrate` FOREIGN KEY (`interestrate`) REFERENCES `interestrate` (`id`),
 CONSTRAINT `collateral_maturity` FOREIGN KEY (`maturity`) REFERENCES `maturity` (`id`),
 CONSTRAINT `collateral_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `collateral_underlying` FOREIGN KEY (`underlying`) REFERENCES `underlying` (`id`),
 CONSTRAINT `collateral_underlyingcount` FOREIGN KEY (`underlyingcount`) REFERENCES `underlyingcount` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `collateral` --

/*!40000 ALTER TABLE `collateral` DISABLE KEYS */; /*!40000 ALTER TABLE `collateral` ENABLE KEYS */;

-- -- Definition of table `collateraltype` --

DROP TABLE IF EXISTS `collateraltype`; CREATE TABLE `collateraltype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `code` bigint(20) DEFAULT NULL,
 `name` bigint(20) DEFAULT NULL,
 `previouscode` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `collateraltype_source` (`source`),
 KEY `collateraltype_previouscode` (`previouscode`),
 KEY `collateraltype_name` (`name`),
 KEY `collateraltype_code` (`code`),
 CONSTRAINT `collateraltype_code` FOREIGN KEY (`code`) REFERENCES `code` (`id`),
 CONSTRAINT `collateraltype_name` FOREIGN KEY (`name`) REFERENCES `name` (`id`),
 CONSTRAINT `collateraltype_previouscode` FOREIGN KEY (`previouscode`) REFERENCES `previouscode` (`id`),
 CONSTRAINT `collateraltype_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `collateraltype` --

/*!40000 ALTER TABLE `collateraltype` DISABLE KEYS */; /*!40000 ALTER TABLE `collateraltype` ENABLE KEYS */;

-- -- Definition of table `comment` --

DROP TABLE IF EXISTS `comment`; CREATE TABLE `comment` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `source` bigint(20) DEFAULT NULL,
 `comment` varchar(255) DEFAULT NULL,
 `lang` varchar(255) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `comment_source` (`source`),
 CONSTRAINT `comment_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `comment` --

/*!40000 ALTER TABLE `comment` DISABLE KEYS */; /*!40000 ALTER TABLE `comment` ENABLE KEYS */;

-- -- Definition of table `commoditydomain` --

DROP TABLE IF EXISTS `commoditydomain`; CREATE TABLE `commoditydomain` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `source` bigint(20) DEFAULT NULL,
 `snap` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `commoditydomain_source` (`source`),
 KEY `commoditydomain_snap` (`snap`),
 CONSTRAINT `commoditydomain_snap` FOREIGN KEY (`snap`) REFERENCES `snap` (`id`),
 CONSTRAINT `commoditydomain_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `commoditydomain` --

/*!40000 ALTER TABLE `commoditydomain` DISABLE KEYS */; /*!40000 ALTER TABLE `commoditydomain` ENABLE KEYS */;

-- -- Definition of table `compensationdate` --

DROP TABLE IF EXISTS `compensationdate`; CREATE TABLE `compensationdate` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `source` bigint(20) DEFAULT NULL,
 `compensationdate` datetime DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `compensationdate_source` (`source`),
 CONSTRAINT `compensationdate_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `compensationdate` --

/*!40000 ALTER TABLE `compensationdate` DISABLE KEYS */; /*!40000 ALTER TABLE `compensationdate` ENABLE KEYS */;

-- -- Definition of table `component` --

DROP TABLE IF EXISTS `component`; CREATE TABLE `component` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `basevalue` bigint(20) DEFAULT NULL,
 `componentidentifier` bigint(20) DEFAULT NULL,
 `componentvalue` bigint(20) DEFAULT NULL,
 `multiplier` bigint(20) DEFAULT NULL,
 `weighting` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `component_source` (`source`),
 KEY `component_componentvalue` (`componentvalue`),
 KEY `component_componentidentifier` (`componentidentifier`),
 KEY `component_weighting` (`weighting`),
 KEY `component_multiplier` (`multiplier`),
 KEY `component_basevalue` (`basevalue`),
 CONSTRAINT `component_basevalue` FOREIGN KEY (`basevalue`) REFERENCES `basevalue` (`id`),
 CONSTRAINT `component_componentidentifier` FOREIGN KEY (`componentidentifier`) REFERENCES `componentidentifier` (`id`),
 CONSTRAINT `component_componentvalue` FOREIGN KEY (`componentvalue`) REFERENCES `componentvalue` (`id`),
 CONSTRAINT `component_multiplier` FOREIGN KEY (`multiplier`) REFERENCES `multiplier` (`id`),
 CONSTRAINT `component_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `component_weighting` FOREIGN KEY (`weighting`) REFERENCES `weighting` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `component` --

/*!40000 ALTER TABLE `component` DISABLE KEYS */; /*!40000 ALTER TABLE `component` ENABLE KEYS */;

-- -- Definition of table `componentidentifier` --

DROP TABLE IF EXISTS `componentidentifier`; CREATE TABLE `componentidentifier` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `code` bigint(20) DEFAULT NULL,
 `name` bigint(20) DEFAULT NULL,
 `previouscode` bigint(20) DEFAULT NULL,
 `instrumentstatustype` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `cmpnntidntifir_instrmntsttstyp` (`instrumentstatustype`),
 KEY `componentidentifier_source` (`source`),
 KEY `cmponentidentifier_previoscode` (`previouscode`),
 KEY `componentidentifier_name` (`name`),
 KEY `componentidentifier_code` (`code`),
 CONSTRAINT `componentidentifier_code` FOREIGN KEY (`code`) REFERENCES `code` (`id`),
 CONSTRAINT `cmpnntidntifir_instrmntsttstyp` FOREIGN KEY (`instrumentstatustype`) REFERENCES `instrumentstatustype` (`id`),
 CONSTRAINT `cmponentidentifier_previoscode` FOREIGN KEY (`previouscode`) REFERENCES `previouscode` (`id`),
 CONSTRAINT `componentidentifier_name` FOREIGN KEY (`name`) REFERENCES `name` (`id`),
 CONSTRAINT `componentidentifier_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `componentidentifier` --

/*!40000 ALTER TABLE `componentidentifier` DISABLE KEYS */; /*!40000 ALTER TABLE `componentidentifier` ENABLE KEYS */;

-- -- Definition of table `componentvalue` --

DROP TABLE IF EXISTS `componentvalue`; CREATE TABLE `componentvalue` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `calculationtype` bigint(20) DEFAULT NULL,
 `datetime` bigint(20) DEFAULT NULL,
 `fraction` bigint(20) DEFAULT NULL,
 `fractionhandlingtype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `marketcenter` bigint(20) DEFAULT NULL,
 `multiplier` bigint(20) DEFAULT NULL,
 `previousdatetime` bigint(20) DEFAULT NULL,
 `quantitydescriptiontype` bigint(20) DEFAULT NULL,
 `quantitytype` bigint(20) DEFAULT NULL,
 `valuationref` bigint(20) DEFAULT NULL,
 `valuationtype` bigint(20) DEFAULT NULL,
 `crossrate` bigint(20) DEFAULT NULL,
 `currency` bigint(20) DEFAULT NULL,
 `size` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `componentvalue` decimal(19,2) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `componentvalue_source` (`source`),
 KEY `componentvalue_valuationtype` (`valuationtype`),
 KEY `componentvalue_currency` (`currency`),
 KEY `cmpnntvle_qntitydescriptintype` (`quantitydescriptiontype`),
 KEY `componentvalue_multiplier` (`multiplier`),
 KEY `componentvalue_quantitytype` (`quantitytype`),
 KEY `componentvale_previousdatetime` (`previousdatetime`),
 KEY `componentvalue_crossrate` (`crossrate`),
 KEY `cmpnentvle_fractinhandlingtype` (`fractionhandlingtype`),
 KEY `componentvalue_valuationref` (`valuationref`),
 KEY `componentvalue_calculationtype` (`calculationtype`),
 KEY `componentvalue_datetime` (`datetime`),
 KEY `componentvalue_size` (`size`),
 KEY `componentvalue_marketcenter` (`marketcenter`),
 KEY `componentvalue_indicatorstype` (`indicatorstype`),
 KEY `componentvalue_fraction` (`fraction`),
 CONSTRAINT `componentvalue_fraction` FOREIGN KEY (`fraction`) REFERENCES `fraction` (`id`),
 CONSTRAINT `cmpnentvle_fractinhandlingtype` FOREIGN KEY (`fractionhandlingtype`) REFERENCES `fractionhandlingtype` (`id`),
 CONSTRAINT `cmpnntvle_qntitydescriptintype` FOREIGN KEY (`quantitydescriptiontype`) REFERENCES `quantitydescriptiontype` (`id`),
 CONSTRAINT `componentvale_previousdatetime` FOREIGN KEY (`previousdatetime`) REFERENCES `previousdatetime` (`id`),
 CONSTRAINT `componentvalue_calculationtype` FOREIGN KEY (`calculationtype`) REFERENCES `calculationtype` (`id`),
 CONSTRAINT `componentvalue_crossrate` FOREIGN KEY (`crossrate`) REFERENCES `crossrate` (`id`),
 CONSTRAINT `componentvalue_currency` FOREIGN KEY (`currency`) REFERENCES `currency` (`id`),
 CONSTRAINT `componentvalue_datetime` FOREIGN KEY (`datetime`) REFERENCES `datetime` (`id`),
 CONSTRAINT `componentvalue_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `componentvalue_marketcenter` FOREIGN KEY (`marketcenter`) REFERENCES `marketcenter` (`id`),
 CONSTRAINT `componentvalue_multiplier` FOREIGN KEY (`multiplier`) REFERENCES `multiplier` (`id`),
 CONSTRAINT `componentvalue_quantitytype` FOREIGN KEY (`quantitytype`) REFERENCES `quantitytype` (`id`),
 CONSTRAINT `componentvalue_size` FOREIGN KEY (`size`) REFERENCES `size` (`id`),
 CONSTRAINT `componentvalue_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `componentvalue_valuationref` FOREIGN KEY (`valuationref`) REFERENCES `valuationref` (`id`),
 CONSTRAINT `componentvalue_valuationtype` FOREIGN KEY (`valuationtype`) REFERENCES `valuationtype` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `componentvalue` --

/*!40000 ALTER TABLE `componentvalue` DISABLE KEYS */; /*!40000 ALTER TABLE `componentvalue` ENABLE KEYS */;

-- -- Definition of table `compounding` --

DROP TABLE IF EXISTS `compounding`; CREATE TABLE `compounding` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `period` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `compounding` bit(1) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `compounding_source` (`source`),
 KEY `compounding_period` (`period`),
 CONSTRAINT `compounding_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `compounding_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `compounding` --

/*!40000 ALTER TABLE `compounding` DISABLE KEYS */; /*!40000 ALTER TABLE `compounding` ENABLE KEYS */;

-- -- Definition of table `compulsory` --

DROP TABLE IF EXISTS `compulsory`; CREATE TABLE `compulsory` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `period` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `compulsory` bit(1) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `compulsory_source` (`source`),
 KEY `compulsory_period` (`period`),
 CONSTRAINT `compulsory_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `compulsory_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `compulsory` --

/*!40000 ALTER TABLE `compulsory` DISABLE KEYS */; /*!40000 ALTER TABLE `compulsory` ENABLE KEYS */;

-- -- Definition of table `confirmationdate` --

DROP TABLE IF EXISTS `confirmationdate`; CREATE TABLE `confirmationdate` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `source` bigint(20) DEFAULT NULL,
 `confirmationdate` datetime DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `confirmationdate_source` (`source`),
 CONSTRAINT `confirmationdate_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `confirmationdate` --

/*!40000 ALTER TABLE `confirmationdate` DISABLE KEYS */; /*!40000 ALTER TABLE `confirmationdate` ENABLE KEYS */;

-- -- Definition of table `contacttype` --

DROP TABLE IF EXISTS `contacttype`; CREATE TABLE `contacttype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `contacttype` --

/*!40000 ALTER TABLE `contacttype` DISABLE KEYS */; /*!40000 ALTER TABLE `contacttype` ENABLE KEYS */;

-- -- Definition of table `contractvaluemultiplier` --

DROP TABLE IF EXISTS `contractvaluemultiplier`; CREATE TABLE `contractvaluemultiplier` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `source` bigint(20) DEFAULT NULL,
 `contractvaluemultiplier` decimal(19,2) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `contractvaluemultiplier_source` (`source`),
 CONSTRAINT `contractvaluemultiplier_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `contractvaluemultiplier` --

/*!40000 ALTER TABLE `contractvaluemultiplier` DISABLE KEYS */; /*!40000 ALTER TABLE `contractvaluemultiplier` ENABLE KEYS */;

-- -- Definition of table `convertible` --

DROP TABLE IF EXISTS `convertible`; CREATE TABLE `convertible` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `convertibletype` bigint(20) DEFAULT NULL,
 `days` bigint(20) DEFAULT NULL,
 `issuerchoice` bigint(20) DEFAULT NULL,
 `mandatory` bigint(20) DEFAULT NULL,
 `period` bigint(20) DEFAULT NULL,
 `relatedto` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `convertible` bit(1) DEFAULT NULL,
 `validity` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `convertible_issuerchoice` (`issuerchoice`),
 KEY `convertible_days` (`days`),
 KEY `convertible_source` (`source`),
 KEY `convertible_period` (`period`),
 KEY `convertible_relatedto` (`relatedto`),
 KEY `convertible_convertibletype` (`convertibletype`),
 KEY `convertible_mandatory` (`mandatory`),
 CONSTRAINT `convertible_mandatory` FOREIGN KEY (`mandatory`) REFERENCES `mandatory` (`id`),
 CONSTRAINT `convertible_convertibletype` FOREIGN KEY (`convertibletype`) REFERENCES `convertibletype` (`id`),
 CONSTRAINT `convertible_days` FOREIGN KEY (`days`) REFERENCES `days` (`id`),
 CONSTRAINT `convertible_issuerchoice` FOREIGN KEY (`issuerchoice`) REFERENCES `issuerchoice` (`id`),
 CONSTRAINT `convertible_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `convertible_relatedto` FOREIGN KEY (`relatedto`) REFERENCES `relatedto` (`id`),
 CONSTRAINT `convertible_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `convertible` --

/*!40000 ALTER TABLE `convertible` DISABLE KEYS */; /*!40000 ALTER TABLE `convertible` ENABLE KEYS */;

-- -- Definition of table `convertibletype` --

DROP TABLE IF EXISTS `convertibletype`; CREATE TABLE `convertibletype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `convertibletype` --

/*!40000 ALTER TABLE `convertibletype` DISABLE KEYS */; /*!40000 ALTER TABLE `convertibletype` ENABLE KEYS */;

-- -- Definition of table `corporateactionsclass` --

DROP TABLE IF EXISTS `corporateactionsclass`; CREATE TABLE `corporateactionsclass` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `corporatechangesubclass` bigint(20) DEFAULT NULL,
 `datachangesubclass` bigint(20) DEFAULT NULL,
 `distributionsubclass` bigint(20) DEFAULT NULL,
 `holderactionsubclass` bigint(20) DEFAULT NULL,
 `issuancesubclass` bigint(20) DEFAULT NULL,
 `paymentactionsubclass` bigint(20) DEFAULT NULL,
 `redemptionsubclass` bigint(20) DEFAULT NULL,
 `restructuresubclass` bigint(20) DEFAULT NULL,
 `statuschangesubclass` bigint(20) DEFAULT NULL,
 `source` bigint(20) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `crprteactinsclss_dtchngesbclss` (`datachangesubclass`),
 KEY `crprtctinsclss_crprtchngsbclss` (`corporatechangesubclass`),
 KEY `crprtctinsclss_hlderctinsbclss` (`holderactionsubclass`),
 KEY `corporateactionsclass_source` (`source`),
 KEY `crprtctinsclss_pymntctinsbclss` (`paymentactionsubclass`),
 KEY `crprteactinsclss_issncesbclass` (`issuancesubclass`),
 KEY `crprtctinsclss_redemptinsbclss` (`redemptionsubclass`),
 KEY `crprtctinsclss_sttschngesbclss` (`statuschangesubclass`),
 KEY `crprtctinsclss_restrctresbclss` (`restructuresubclass`),
 KEY `crprtctnsclss_distribtinsbclss` (`distributionsubclass`),
 CONSTRAINT `crprtctnsclss_distribtinsbclss` FOREIGN KEY (`distributionsubclass`) REFERENCES `distributionsubclass` (`id`),
 CONSTRAINT `corporateactionsclass_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `crprtctinsclss_crprtchngsbclss` FOREIGN KEY (`corporatechangesubclass`) REFERENCES `corporatechangesubclass` (`id`),
 CONSTRAINT `crprtctinsclss_hlderctinsbclss` FOREIGN KEY (`holderactionsubclass`) REFERENCES `holderactionsubclass` (`id`),
 CONSTRAINT `crprtctinsclss_pymntctinsbclss` FOREIGN KEY (`paymentactionsubclass`) REFERENCES `paymentactionsubclass` (`id`),
 CONSTRAINT `crprtctinsclss_redemptinsbclss` FOREIGN KEY (`redemptionsubclass`) REFERENCES `redemptionsubclass` (`id`),
 CONSTRAINT `crprtctinsclss_restrctresbclss` FOREIGN KEY (`restructuresubclass`) REFERENCES `restructuresubclass` (`id`),
 CONSTRAINT `crprtctinsclss_sttschngesbclss` FOREIGN KEY (`statuschangesubclass`) REFERENCES `statuschangesubclass` (`id`),
 CONSTRAINT `crprteactinsclss_dtchngesbclss` FOREIGN KEY (`datachangesubclass`) REFERENCES `datachangesubclass` (`id`),
 CONSTRAINT `crprteactinsclss_issncesbclass` FOREIGN KEY (`issuancesubclass`) REFERENCES `issuancesubclass` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `corporateactionsclass` --

/*!40000 ALTER TABLE `corporateactionsclass` DISABLE KEYS */; /*!40000 ALTER TABLE `corporateactionsclass` ENABLE KEYS */;

-- -- Definition of table `corporatechangesubclass` --

DROP TABLE IF EXISTS `corporatechangesubclass`; CREATE TABLE `corporatechangesubclass` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `announcementdate` bigint(20) DEFAULT NULL,
 `effectivedate` bigint(20) DEFAULT NULL,
 `meetingdate` bigint(20) DEFAULT NULL,
 `meetingtype` bigint(20) DEFAULT NULL,
 `recorddate` bigint(20) DEFAULT NULL,
 `agent` bigint(20) DEFAULT NULL,
 `caedate` bigint(20) DEFAULT NULL,
 `caeidentifier` bigint(20) DEFAULT NULL,
 `caelifecycletype` bigint(20) DEFAULT NULL,
 `caestatustype` bigint(20) DEFAULT NULL,
 `caetype` bigint(20) DEFAULT NULL,
 `comment` bigint(20) DEFAULT NULL,
 `documenturl` bigint(20) DEFAULT NULL,
 `entityidentifier` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `instrumentidentifier` bigint(20) DEFAULT NULL,
 `issuerref` bigint(20) DEFAULT NULL,
 `relatedto` bigint(20) DEFAULT NULL,
 `eligibility` bigint(20) DEFAULT NULL,
 `offer` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `crpratechangesbclass_recrddate` (`recorddate`),
 KEY `corporatechangesubclass_source` (`source`),
 KEY `corporatechangesbclass_caedate` (`caedate`),
 KEY `crprtchngsbclss_ntityidntifier` (`entityidentifier`),
 KEY `crpratechangesbclass_docmentrl` (`documenturl`),
 KEY `corporatechangesubclass_offer` (`offer`),
 KEY `crprtechngesbclass_meetingtype` (`meetingtype`),
 KEY `crprtechngesbclss_effectivedte` (`effectivedate`),
 KEY `crprtechngesbclss_nnncementdte` (`announcementdate`),
 KEY `corporatechangesbclass_comment` (`comment`),
 KEY `crprtechngesbclss_ceidentifier` (`caeidentifier`),
 KEY `crpratechangesbclass_relatedto` (`relatedto`),
 KEY `corporatechangesubclass_agent` (`agent`),
 KEY `corporatechangesbclass_caetype` (`caetype`),
 KEY `crprtchngsbclss_clifecycletype` (`caelifecycletype`),
 KEY `crprtechngesbclss_caestatstype` (`caestatustype`),
 KEY `crprtechngesbclass_eligibility` (`eligibility`),
 KEY `crporatechangesbclass_isserref` (`issuerref`),
 KEY `crprtechngesbclss_indictrstype` (`indicatorstype`),
 KEY `crprtchngsbclss_nstrmntidntfir` (`instrumentidentifier`),
 KEY `crprtechngesbclass_meetingdate` (`meetingdate`),
 CONSTRAINT `crprtechngesbclass_meetingdate` FOREIGN KEY (`meetingdate`) REFERENCES `meetingdate` (`id`),
 CONSTRAINT `corporatechangesbclass_caedate` FOREIGN KEY (`caedate`) REFERENCES `caedate` (`id`),
 CONSTRAINT `corporatechangesbclass_caetype` FOREIGN KEY (`caetype`) REFERENCES `caetype` (`id`),
 CONSTRAINT `corporatechangesbclass_comment` FOREIGN KEY (`comment`) REFERENCES `comment` (`id`),
 CONSTRAINT `corporatechangesubclass_agent` FOREIGN KEY (`agent`) REFERENCES `agent` (`id`),
 CONSTRAINT `corporatechangesubclass_offer` FOREIGN KEY (`offer`) REFERENCES `offer` (`id`),
 CONSTRAINT `corporatechangesubclass_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `crporatechangesbclass_isserref` FOREIGN KEY (`issuerref`) REFERENCES `issuerref` (`id`),
 CONSTRAINT `crpratechangesbclass_docmentrl` FOREIGN KEY (`documenturl`) REFERENCES `documenturl` (`id`),
 CONSTRAINT `crpratechangesbclass_recrddate` FOREIGN KEY (`recorddate`) REFERENCES `recorddate` (`id`),
 CONSTRAINT `crpratechangesbclass_relatedto` FOREIGN KEY (`relatedto`) REFERENCES `relatedto` (`id`),
 CONSTRAINT `crprtchngsbclss_clifecycletype` FOREIGN KEY (`caelifecycletype`) REFERENCES `caelifecycletype` (`id`),
 CONSTRAINT `crprtchngsbclss_nstrmntidntfir` FOREIGN KEY (`instrumentidentifier`) REFERENCES `instrumentidentifier` (`id`),
 CONSTRAINT `crprtchngsbclss_ntityidntifier` FOREIGN KEY (`entityidentifier`) REFERENCES `entityidentifier` (`id`),
 CONSTRAINT `crprtechngesbclass_eligibility` FOREIGN KEY (`eligibility`) REFERENCES `eligibility` (`id`),
 CONSTRAINT `crprtechngesbclass_meetingtype` FOREIGN KEY (`meetingtype`) REFERENCES `meetingtype` (`id`),
 CONSTRAINT `crprtechngesbclss_caestatstype` FOREIGN KEY (`caestatustype`) REFERENCES `caestatustype` (`id`),
 CONSTRAINT `crprtechngesbclss_ceidentifier` FOREIGN KEY (`caeidentifier`) REFERENCES `caeidentifier` (`id`),
 CONSTRAINT `crprtechngesbclss_effectivedte` FOREIGN KEY (`effectivedate`) REFERENCES `effectivedate` (`id`),
 CONSTRAINT `crprtechngesbclss_indictrstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `crprtechngesbclss_nnncementdte` FOREIGN KEY (`announcementdate`) REFERENCES `marketdate` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `corporatechangesubclass` --

/*!40000 ALTER TABLE `corporatechangesubclass` DISABLE KEYS */; /*!40000 ALTER TABLE `corporatechangesubclass` ENABLE KEYS */;

-- -- Definition of table `corporateeventsclass` --

DROP TABLE IF EXISTS `corporateeventsclass`; CREATE TABLE `corporateeventsclass` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `corporatesubclass` bigint(20) DEFAULT NULL,
 `meetingsubclass` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `corporateeventsclass_source` (`source`),
 KEY `crprteeventsclss_crprtesbclass` (`corporatesubclass`),
 KEY `crprteeventsclss_meetingsbclss` (`meetingsubclass`),
 CONSTRAINT `crprteeventsclss_meetingsbclss` FOREIGN KEY (`meetingsubclass`) REFERENCES `meetingsubclass` (`id`),
 CONSTRAINT `corporateeventsclass_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `crprteeventsclss_crprtesbclass` FOREIGN KEY (`corporatesubclass`) REFERENCES `corporatesubclass` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `corporateeventsclass` --

/*!40000 ALTER TABLE `corporateeventsclass` DISABLE KEYS */; /*!40000 ALTER TABLE `corporateeventsclass` ENABLE KEYS */;

-- -- Definition of table `corporatesubclass` --

DROP TABLE IF EXISTS `corporatesubclass`; CREATE TABLE `corporatesubclass` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `announcementdate` bigint(20) DEFAULT NULL,
 `effectivedate` bigint(20) DEFAULT NULL,
 `meetingdate` bigint(20) DEFAULT NULL,
 `meetingtype` bigint(20) DEFAULT NULL,
 `recorddate` bigint(20) DEFAULT NULL,
 `agent` bigint(20) DEFAULT NULL,
 `caedate` bigint(20) DEFAULT NULL,
 `caeidentifier` bigint(20) NOT NULL,
 `caelifecycletype` bigint(20) NOT NULL,
 `caestatustype` bigint(20) NOT NULL,
 `caetype` bigint(20) NOT NULL,
 `comment` bigint(20) DEFAULT NULL,
 `documenturl` bigint(20) DEFAULT NULL,
 `entityidentifier` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `instrumentidentifier` bigint(20) NOT NULL,
 `issuerref` bigint(20) DEFAULT NULL,
 `relatedto` bigint(20) DEFAULT NULL,
 `eventdescription` bigint(20) DEFAULT NULL,
 `source` bigint(20) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `crpratesbclass_eventdescriptin` (`eventdescription`),
 KEY `corporatesubclass_recorddate` (`recorddate`),
 KEY `corporatesubclass_source` (`source`),
 KEY `corporatesubclass_caedate` (`caedate`),
 KEY `crprtesbclass_entityidentifier` (`entityidentifier`),
 KEY `corporatesubclass_documenturl` (`documenturl`),
 KEY `corporatesubclass_meetingtype` (`meetingtype`),
 KEY `corporatesbclass_effectivedate` (`effectivedate`),
 KEY `crpratesbclass_annoncementdate` (`announcementdate`),
 KEY `corporatesubclass_comment` (`comment`),
 KEY `corporatesbclass_caeidentifier` (`caeidentifier`),
 KEY `corporatesubclass_relatedto` (`relatedto`),
 KEY `corporatesubclass_agent` (`agent`),
 KEY `corporatesubclass_caetype` (`caetype`),
 KEY `crprtesbclass_caelifecycletype` (`caelifecycletype`),
 KEY `corporatesbclass_caestatustype` (`caestatustype`),
 KEY `corporatesubclass_issuerref` (`issuerref`),
 KEY `crporatesbclass_indicatorstype` (`indicatorstype`),
 KEY `crprtsbclss_instrmntidentifier` (`instrumentidentifier`),
 KEY `corporatesubclass_meetingdate` (`meetingdate`),
 CONSTRAINT `corporatesubclass_meetingdate` FOREIGN KEY (`meetingdate`) REFERENCES `meetingdate` (`id`),
 CONSTRAINT `corporatesbclass_caeidentifier` FOREIGN KEY (`caeidentifier`) REFERENCES `caeidentifier` (`id`),
 CONSTRAINT `corporatesbclass_caestatustype` FOREIGN KEY (`caestatustype`) REFERENCES `caestatustype` (`id`),
 CONSTRAINT `corporatesbclass_effectivedate` FOREIGN KEY (`effectivedate`) REFERENCES `effectivedate` (`id`),
 CONSTRAINT `corporatesubclass_agent` FOREIGN KEY (`agent`) REFERENCES `agent` (`id`),
 CONSTRAINT `corporatesubclass_caedate` FOREIGN KEY (`caedate`) REFERENCES `caedate` (`id`),
 CONSTRAINT `corporatesubclass_caetype` FOREIGN KEY (`caetype`) REFERENCES `caetype` (`id`),
 CONSTRAINT `corporatesubclass_comment` FOREIGN KEY (`comment`) REFERENCES `comment` (`id`),
 CONSTRAINT `corporatesubclass_documenturl` FOREIGN KEY (`documenturl`) REFERENCES `documenturl` (`id`),
 CONSTRAINT `corporatesubclass_issuerref` FOREIGN KEY (`issuerref`) REFERENCES `issuerref` (`id`),
 CONSTRAINT `corporatesubclass_meetingtype` FOREIGN KEY (`meetingtype`) REFERENCES `meetingtype` (`id`),
 CONSTRAINT `corporatesubclass_recorddate` FOREIGN KEY (`recorddate`) REFERENCES `recorddate` (`id`),
 CONSTRAINT `corporatesubclass_relatedto` FOREIGN KEY (`relatedto`) REFERENCES `relatedto` (`id`),
 CONSTRAINT `corporatesubclass_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `crporatesbclass_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `crpratesbclass_annoncementdate` FOREIGN KEY (`announcementdate`) REFERENCES `marketdate` (`id`),
 CONSTRAINT `crpratesbclass_eventdescriptin` FOREIGN KEY (`eventdescription`) REFERENCES `eventdescription` (`id`),
 CONSTRAINT `crprtesbclass_caelifecycletype` FOREIGN KEY (`caelifecycletype`) REFERENCES `caelifecycletype` (`id`),
 CONSTRAINT `crprtesbclass_entityidentifier` FOREIGN KEY (`entityidentifier`) REFERENCES `entityidentifier` (`id`),
 CONSTRAINT `crprtsbclss_instrmntidentifier` FOREIGN KEY (`instrumentidentifier`) REFERENCES `instrumentidentifier` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `corporatesubclass` --

/*!40000 ALTER TABLE `corporatesubclass` DISABLE KEYS */; /*!40000 ALTER TABLE `corporatesubclass` ENABLE KEYS */;

-- -- Definition of table `counterpartyclass` --

DROP TABLE IF EXISTS `counterpartyclass`; CREATE TABLE `counterpartyclass` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `comment` bigint(20) DEFAULT NULL,
 `creationdate` bigint(20) DEFAULT NULL,
 `datetime` bigint(20) DEFAULT NULL,
 `entityidentifier` bigint(20) DEFAULT NULL,
 `entitystatustype` bigint(20) DEFAULT NULL,
 `jurisdiction` bigint(20) DEFAULT NULL,
 `location` bigint(20) DEFAULT NULL,
 `period` bigint(20) DEFAULT NULL,
 `pointofcontact` bigint(20) DEFAULT NULL,
 `replacemententity` bigint(20) DEFAULT NULL,
 `replacementtype` bigint(20) DEFAULT NULL,
 `reviewdate` bigint(20) DEFAULT NULL,
 `sponsor` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `cnterprtyclss_replcemententity` (`replacemententity`),
 KEY `counterpartyclass_source` (`source`),
 KEY `cnterprtyclss_entityidentifier` (`entityidentifier`),
 KEY `counterpartyclass_location` (`location`),
 KEY `counterpartyclass_period` (`period`),
 KEY `counterpartyclass_reviewdate` (`reviewdate`),
 KEY `cnterprtyclass_replacementtype` (`replacementtype`),
 KEY `counterpartyclass_comment` (`comment`),
 KEY `cnterprtyclass_entitystatstype` (`entitystatustype`),
 KEY `counterpartyclass_sponsor` (`sponsor`),
 KEY `counterpartyclass_datetime` (`datetime`),
 KEY `counterpartyclass_creationdate` (`creationdate`),
 KEY `cnterpartyclass_pointofcontact` (`pointofcontact`),
 KEY `counterpartyclass_jurisdiction` (`jurisdiction`),
 CONSTRAINT `counterpartyclass_jurisdiction` FOREIGN KEY (`jurisdiction`) REFERENCES `jurisdiction` (`id`),
 CONSTRAINT `cnterpartyclass_pointofcontact` FOREIGN KEY (`pointofcontact`) REFERENCES `pointofcontact` (`id`),
 CONSTRAINT `cnterprtyclass_entitystatstype` FOREIGN KEY (`entitystatustype`) REFERENCES `entitystatustype` (`id`),
 CONSTRAINT `cnterprtyclass_replacementtype` FOREIGN KEY (`replacementtype`) REFERENCES `replacementtype` (`id`),
 CONSTRAINT `cnterprtyclss_entityidentifier` FOREIGN KEY (`entityidentifier`) REFERENCES `entityidentifier` (`id`),
 CONSTRAINT `cnterprtyclss_replcemententity` FOREIGN KEY (`replacemententity`) REFERENCES `replacemententity` (`id`),
 CONSTRAINT `counterpartyclass_comment` FOREIGN KEY (`comment`) REFERENCES `comment` (`id`),
 CONSTRAINT `counterpartyclass_creationdate` FOREIGN KEY (`creationdate`) REFERENCES `creationdate` (`id`),
 CONSTRAINT `counterpartyclass_datetime` FOREIGN KEY (`datetime`) REFERENCES `datetime` (`id`),
 CONSTRAINT `counterpartyclass_location` FOREIGN KEY (`location`) REFERENCES `location` (`id`),
 CONSTRAINT `counterpartyclass_period` FOREIGN KEY (`period`) REFERENCES `period` (`id`),
 CONSTRAINT `counterpartyclass_reviewdate` FOREIGN KEY (`reviewdate`) REFERENCES `reviewdate` (`id`),
 CONSTRAINT `counterpartyclass_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`),
 CONSTRAINT `counterpartyclass_sponsor` FOREIGN KEY (`sponsor`) REFERENCES `sponsor` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `counterpartyclass` --

/*!40000 ALTER TABLE `counterpartyclass` DISABLE KEYS */; /*!40000 ALTER TABLE `counterpartyclass` ENABLE KEYS */;

-- -- Definition of table `country` --

DROP TABLE IF EXISTS `country`; CREATE TABLE `country` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `source` bigint(20) DEFAULT NULL,
 `country` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `country_source` (`source`),
 CONSTRAINT `country_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `country` --

/*!40000 ALTER TABLE `country` DISABLE KEYS */; /*!40000 ALTER TABLE `country` ENABLE KEYS */;

-- -- Definition of table `covenant` --

DROP TABLE IF EXISTS `covenant`; CREATE TABLE `covenant` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `agreedrestrictions` bigint(20) DEFAULT NULL,
 `allowedindebtedness` bigint(20) DEFAULT NULL,
 `defaultclause` bigint(20) DEFAULT NULL,
 `negativepledge` bigint(20) DEFAULT NULL,
 `refrainfromacts` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `covenant_source` (`source`),
 KEY `covenant_allowedindebtedness` (`allowedindebtedness`),
 KEY `covenant_defaultclause` (`defaultclause`),
 KEY `covenant_agreedrestrictions` (`agreedrestrictions`),
 KEY `covenant_refrainfromacts` (`refrainfromacts`),
 KEY `covenant_negativepledge` (`negativepledge`),
 CONSTRAINT `covenant_negativepledge` FOREIGN KEY (`negativepledge`) REFERENCES `negativepledge` (`id`),
 CONSTRAINT `covenant_agreedrestrictions` FOREIGN KEY (`agreedrestrictions`) REFERENCES `agreedrestrictions` (`id`),
 CONSTRAINT `covenant_allowedindebtedness` FOREIGN KEY (`allowedindebtedness`) REFERENCES `allowedindebtedness` (`id`),
 CONSTRAINT `covenant_defaultclause` FOREIGN KEY (`defaultclause`) REFERENCES `defaultclause` (`id`),
 CONSTRAINT `covenant_refrainfromacts` FOREIGN KEY (`refrainfromacts`) REFERENCES `refrainfromacts` (`id`),
 CONSTRAINT `covenant_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `covenant` --

/*!40000 ALTER TABLE `covenant` DISABLE KEYS */; /*!40000 ALTER TABLE `covenant` ENABLE KEYS */;

-- -- Definition of table `creationdate` --

DROP TABLE IF EXISTS `creationdate`; CREATE TABLE `creationdate` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `dayruletype` bigint(20) DEFAULT NULL,
 `indicatorstype` bigint(20) DEFAULT NULL,
 `marketcenter` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `creationdate` date DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `creationdate_source` (`source`),
 KEY `creationdate_dayruletype` (`dayruletype`),
 KEY `creationdate_marketcenter` (`marketcenter`),
 KEY `creationdate_indicatorstype` (`indicatorstype`),
 CONSTRAINT `creationdate_indicatorstype` FOREIGN KEY (`indicatorstype`) REFERENCES `indicatorstype` (`id`),
 CONSTRAINT `creationdate_dayruletype` FOREIGN KEY (`dayruletype`) REFERENCES `dayruletype` (`id`),
 CONSTRAINT `creationdate_marketcenter` FOREIGN KEY (`marketcenter`) REFERENCES `marketcenter` (`id`),
 CONSTRAINT `creationdate_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `creationdate` --

/*!40000 ALTER TABLE `creationdate` DISABLE KEYS */; /*!40000 ALTER TABLE `creationdate` ENABLE KEYS */;

-- -- Definition of table `creditenhancement` --

DROP TABLE IF EXISTS `creditenhancement`; CREATE TABLE `creditenhancement` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `creditenhancementtype` bigint(20) DEFAULT NULL,
 `enhancement` bigint(20) DEFAULT NULL,
 `partiesinvolved` bigint(20) DEFAULT NULL,
 `relatedto` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `creditenhancement_source` (`source`),
 KEY `creditenhancement_relatedto` (`relatedto`),
 KEY `creditenhancement_enhancement` (`enhancement`),
 KEY `crditenhncmnt_crditenhncmnttyp` (`creditenhancementtype`),
 KEY `creditenhncement_prtiesinvlved` (`partiesinvolved`),
 CONSTRAINT `creditenhncement_prtiesinvlved` FOREIGN KEY (`partiesinvolved`) REFERENCES `partiesinvolved` (`id`),
 CONSTRAINT `crditenhncmnt_crditenhncmnttyp` FOREIGN KEY (`creditenhancementtype`) REFERENCES `creditenhancementtype` (`id`),
 CONSTRAINT `creditenhancement_enhancement` FOREIGN KEY (`enhancement`) REFERENCES `enhancement` (`id`),
 CONSTRAINT `creditenhancement_relatedto` FOREIGN KEY (`relatedto`) REFERENCES `relatedto` (`id`),
 CONSTRAINT `creditenhancement_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `creditenhancement` --

/*!40000 ALTER TABLE `creditenhancement` DISABLE KEYS */; /*!40000 ALTER TABLE `creditenhancement` ENABLE KEYS */;

-- -- Definition of table `creditenhancementtype` --

DROP TABLE IF EXISTS `creditenhancementtype`; CREATE TABLE `creditenhancementtype` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `full` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 `short` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `creditenhancementtype` --

/*!40000 ALTER TABLE `creditenhancementtype` DISABLE KEYS */; /*!40000 ALTER TABLE `creditenhancementtype` ENABLE KEYS */;

-- -- Definition of table `crossrate` --

DROP TABLE IF EXISTS `crossrate`; CREATE TABLE `crossrate` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `multiplier` bigint(20) DEFAULT NULL,
 `source` bigint(20) DEFAULT NULL,
 `crossrate` varchar(255) DEFAULT NULL,
 `scheme` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `crossrate_source` (`source`),
 KEY `crossrate_multiplier` (`multiplier`),
 CONSTRAINT `crossrate_multiplier` FOREIGN KEY (`multiplier`) REFERENCES `multiplier` (`id`),
 CONSTRAINT `crossrate_source` FOREIGN KEY (`source`) REFERENCES `source` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table `crossrate` --

/*!40000 ALTER TABLE `crossrate` DISABLE KEYS */; /*!40000 ALTER TABLE `crossrate` ENABLE KEYS */;

-- -- Definition of table `currency` --

DROP TABLE IF EXISTS `currency`; CREATE TABLE `currency` (

 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `mult