-- MySQL dump 10.11
--
-- Host: localhost    Database: Calypso
-- ------------------------------------------------------
-- Server version	5.0.77-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `Audit`
--

DROP TABLE IF EXISTS `Audit`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Audit` (
  `idAudit` int(10) unsigned NOT NULL auto_increment,
  `auditUser` int(10) unsigned NOT NULL,
  `auditDateTime` datetime NOT NULL,
  `auditEntity` varchar(45) NOT NULL,
  `auditEntityClass` varchar(255) NOT NULL,
  `updatedObjectKeys` varchar(255) NOT NULL,
  `actionPerformed` varchar(45) NOT NULL,
  `object` blob,
  PRIMARY KEY  (`idAudit`),
  KEY `fk_Audit_User1` (`auditUser`),
  CONSTRAINT `fk_Audit_User1` FOREIGN KEY (`auditUser`) REFERENCES `User` (`idUser`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=5467 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `BarrierDate`
--

DROP TABLE IF EXISTS `BarrierDate`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `BarrierDate` (
  `idBarrierDate` int(10) unsigned NOT NULL auto_increment,
  `idDestinationCountry` int(10) unsigned NOT NULL,
  `idDestinationGroup` int(10) unsigned default NULL,
  `fromDate` date NOT NULL,
  `toDate` date NOT NULL,
  `idPeriodType` int(10) unsigned NOT NULL,
  `deleted` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`idBarrierDate`),
  UNIQUE KEY `uniqueKey` USING BTREE (`idDestinationCountry`,`idDestinationGroup`,`fromDate`,`toDate`,`deleted`),
  KEY `fk_BarrierDate_DestinationGroup1` (`idDestinationGroup`),
  KEY `fk_BarrierDate_PeriodType1` (`idPeriodType`),
  KEY `fk_BarrierDate_GeographyCountry1` (`idDestinationCountry`),
  CONSTRAINT `fk_BarrierDate_DestinationGroup1` FOREIGN KEY (`idDestinationGroup`) REFERENCES `DestinationGroup` (`idDestinationGroup`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_BarrierDate_GeographyCountry1` FOREIGN KEY (`idDestinationCountry`) REFERENCES `GeographyCountry` (`idGeographyCountry`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_BarrierDate_PeriodType1` FOREIGN KEY (`idPeriodType`) REFERENCES `PeriodType` (`idPeriodType`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2879 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `BarrierDateLink`
--

DROP TABLE IF EXISTS `BarrierDateLink`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `BarrierDateLink` (
  `idBarrierDateLink` int(10) unsigned NOT NULL auto_increment,
  `idSourceCountryOfOrigin` int(10) unsigned NOT NULL,
  `idSourceBarrierDate` int(10) unsigned NOT NULL,
  `idTargetCountryOfOrigin` int(10) unsigned NOT NULL,
  `idTargetBarrierDate` int(10) unsigned NOT NULL,
  `linkedExchangeRate` decimal(5,2) NOT NULL,
  `linkedUpliftFactor` decimal(5,2) NOT NULL,
  PRIMARY KEY  (`idBarrierDateLink`),
  UNIQUE KEY `unique_link` (`idTargetCountryOfOrigin`,`idTargetBarrierDate`),
  KEY `fk_BarrierDateLink_CountryOfOrigin1` (`idSourceCountryOfOrigin`),
  KEY `fk_BarrierDateLink_CountryOfOrigin2` (`idTargetCountryOfOrigin`),
  KEY `fk_BarrierDateLink_BarrierDate1` (`idSourceBarrierDate`),
  KEY `fk_BarrierDateLink_BarrierDate2` (`idTargetBarrierDate`),
  CONSTRAINT `fk_BarrierDateLink_BarrierDate1` FOREIGN KEY (`idSourceBarrierDate`) REFERENCES `BarrierDate` (`idBarrierDate`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_BarrierDateLink_BarrierDate2` FOREIGN KEY (`idTargetBarrierDate`) REFERENCES `BarrierDate` (`idBarrierDate`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_BarrierDateLink_CountryOfOrigin1` FOREIGN KEY (`idSourceCountryOfOrigin`) REFERENCES `CountryOfOrigin` (`idCountryOfOrigin`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_BarrierDateLink_CountryOfOrigin2` FOREIGN KEY (`idTargetCountryOfOrigin`) REFERENCES `CountryOfOrigin` (`idCountryOfOrigin`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=15319 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `CarClass`
--

DROP TABLE IF EXISTS `CarClass`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `CarClass` (
  `idCarClass` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(8) NOT NULL,
  `ranking` varchar(255) NOT NULL,
  `keyCarClass` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`idCarClass`),
  UNIQUE KEY `ranking` (`ranking`)
) ENGINE=InnoDB AUTO_INCREMENT=3384 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `CountryOfOrigin`
--

DROP TABLE IF EXISTS `CountryOfOrigin`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `CountryOfOrigin` (
  `idCountryOfOrigin` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `currency` varchar(3) NOT NULL,
  `groupPattern` varchar(255) NOT NULL,
  PRIMARY KEY  (`idCountryOfOrigin`),
  UNIQUE KEY `countryName` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=984 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `DestinationGroup`
--

DROP TABLE IF EXISTS `DestinationGroup`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `DestinationGroup` (
  `idDestinationGroup` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `idGeographyCountry` int(10) unsigned NOT NULL,
  `virtual` tinyint(1) NOT NULL,
  `deleted` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`idDestinationGroup`),
  UNIQUE KEY `uniqueNameCountry` USING BTREE (`name`,`idGeographyCountry`,`deleted`),
  KEY `fk_DestinationGroup_GeographyCountry1` (`idGeographyCountry`),
  CONSTRAINT `fk_DestinationGroup_GeographyCountry1` FOREIGN KEY (`idGeographyCountry`) REFERENCES `GeographyCountry` (`idGeographyCountry`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=16924 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Duration`
--

DROP TABLE IF EXISTS `Duration`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Duration` (
  `idDuration` int(10) unsigned NOT NULL auto_increment,
  `idDurationType` int(10) unsigned NOT NULL,
  `min` int(10) unsigned NOT NULL,
  `max` int(10) unsigned NOT NULL,
  `keyDuration` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`idDuration`),
  UNIQUE KEY `uniqueKey` (`idDurationType`,`min`,`max`),
  KEY `fk_Duration_DurationType1` (`idDurationType`),
  CONSTRAINT `fk_Duration_DurationType1` FOREIGN KEY (`idDurationType`) REFERENCES `DurationType` (`idDurationType`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1927 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `DurationType`
--

DROP TABLE IF EXISTS `DurationType`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `DurationType` (
  `idDurationType` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) NOT NULL,
  PRIMARY KEY  (`idDurationType`),
  UNIQUE KEY `uniqueKey` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `GeographyCity`
--

DROP TABLE IF EXISTS `GeographyCity`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `GeographyCity` (
  `idGeographyCity` int(10) unsigned NOT NULL auto_increment,
  `idGeographyCountry` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`idGeographyCity`),
  UNIQUE KEY `GeogCityCountryName` (`idGeographyCountry`,`name`),
  KEY `fk_GeographyCity_GeographyCountry1` (`idGeographyCountry`),
  CONSTRAINT `fk_GeographyCity_GeographyCountry1` FOREIGN KEY (`idGeographyCountry`) REFERENCES `GeographyCountry` (`idGeographyCountry`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=16457 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `GeographyCountry`
--

DROP TABLE IF EXISTS `GeographyCountry`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `GeographyCountry` (
  `idGeographyCountry` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`idGeographyCountry`),
  UNIQUE KEY `GeogCountryName` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=567 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `GeographyLocation`
--

DROP TABLE IF EXISTS `GeographyLocation`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `GeographyLocation` (
  `idGeographyLocation` int(10) unsigned NOT NULL auto_increment,
  `idGeographyCity` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `idDestinationGroup` int(10) unsigned NOT NULL,
  `externalId` int(11) NOT NULL,
  PRIMARY KEY  (`idGeographyLocation`),
  UNIQUE KEY `GeogCityName` (`name`,`idGeographyCity`),
  KEY `fk_GeographyLocation_GeographyCity1` (`idGeographyCity`),
  KEY `fk_GeographyLocation_DestinationGroup1` (`idDestinationGroup`),
  CONSTRAINT `fk_GeographyLocation_DestinationGroup1` FOREIGN KEY (`idDestinationGroup`) REFERENCES `DestinationGroup` (`idDestinationGroup`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_GeographyLocation_GeographyCity1` FOREIGN KEY (`idGeographyCity`) REFERENCES `GeographyCity` (`idGeographyCity`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=28107 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `MarginFloor`
--

DROP TABLE IF EXISTS `MarginFloor`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `MarginFloor` (
  `idMarginFloor` int(10) unsigned NOT NULL auto_increment,
  `ranking` varchar(255) default NULL,
  `year` int(11) default NULL,
  `idCountryOfOrigin` int(10) unsigned default NULL,
  `idDestinationCountry` int(10) unsigned default NULL,
  `idDestinationGroup` int(10) unsigned default NULL,
  `idPeriodType` int(10) unsigned default NULL,
  `baseAbsoluteFloor` decimal(16,2) NOT NULL,
  `basePercentageFloor` decimal(4,2) NOT NULL,
  PRIMARY KEY  (`idMarginFloor`),
  UNIQUE KEY `ranking` (`ranking`),
  KEY `fk_MarginFloor_GeographyCountry1` (`idDestinationCountry`),
  KEY `fk_MarginFloor_PeriodType1` (`idPeriodType`),
  KEY `fk_MarginFloor_CountryOfOrigin1` (`idCountryOfOrigin`),
  KEY `fk_MarginFloor_DestinationGroup1` (`idDestinationGroup`),
  CONSTRAINT `fk_MarginFloor_CountryOfOrigin1` FOREIGN KEY (`idCountryOfOrigin`) REFERENCES `CountryOfOrigin` (`idCountryOfOrigin`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_MarginFloor_DestinationGroup1` FOREIGN KEY (`idDestinationGroup`) REFERENCES `DestinationGroup` (`idDestinationGroup`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_MarginFloor_GeographyCountry1` FOREIGN KEY (`idDestinationCountry`) REFERENCES `GeographyCountry` (`idGeographyCountry`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_MarginFloor_PeriodType1` FOREIGN KEY (`idPeriodType`) REFERENCES `PeriodType` (`idPeriodType`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `MarginFloorDuration`
--

DROP TABLE IF EXISTS `MarginFloorDuration`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `MarginFloorDuration` (
  `idMarginFloorDuration` int(10) unsigned NOT NULL auto_increment,
  `idMarginFloor` int(10) unsigned NOT NULL,
  `idDuration` int(10) unsigned default NULL,
  `absoluteFloor` decimal(16,2) NOT NULL default '0.00',
  `percentageFloor` decimal(4,2) NOT NULL default '0.00',
  PRIMARY KEY  (`idMarginFloorDuration`),
  UNIQUE KEY `uniqueKey` (`idMarginFloor`,`idDuration`),
  KEY `fk_MarginFloorDuration_Duration1` (`idDuration`),
  KEY `fk_MarginFloorDuration_MarginFloor1` (`idMarginFloor`),
  CONSTRAINT `fk_MarginFloorDuration_Duration1` FOREIGN KEY (`idDuration`) REFERENCES `Duration` (`idDuration`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_MarginFloorDuration_MarginFloor1` FOREIGN KEY (`idMarginFloor`) REFERENCES `MarginFloor` (`idMarginFloor`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2679 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `MarginFloorPricingRequestView`
--

DROP TABLE IF EXISTS `MarginFloorPricingRequestView`;
/*!50001 DROP VIEW IF EXISTS `MarginFloorPricingRequestView`*/;
/*!50001 CREATE TABLE `MarginFloorPricingRequestView` (
  `aReq` int(10) unsigned,
  `idPricingRequest` int(10) unsigned,
  `idCountryOfOrigin` int(10) unsigned,
  `idBarrierDate` int(10) unsigned,
  `puDate` datetime,
  `duration` int(11),
  `requestDate` datetime,
  `idGeographyLocation` int(10) unsigned,
  `idPricingRequestSource` int(10) unsigned,
  `productType` int(11),
  `idDestinationGroup` int(10) unsigned,
  `idGeographyCountry` int(10) unsigned,
  `total` bigint(21)
) ENGINE=MyISAM */;

--
-- Table structure for table `MarginFloorRanking`
--

DROP TABLE IF EXISTS `MarginFloorRanking`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `MarginFloorRanking` (
  `idMarginFloorRanking` int(10) unsigned NOT NULL,
  `ranking` int(11) NOT NULL,
  PRIMARY KEY  (`idMarginFloorRanking`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `MarginFloorRuleStatistic`
--

DROP TABLE IF EXISTS `MarginFloorRuleStatistic`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `MarginFloorRuleStatistic` (
  `idMarginFloorRuleStatistic` int(10) unsigned NOT NULL auto_increment,
  `ruleTriggered` tinyint(1) NOT NULL,
  `floorMargin` decimal(16,2) default NULL,
  `actualMargin` decimal(16,2) default NULL,
  `baseSellingPrice` decimal(12,2) default NULL,
  `idPricingRequestCarClass` int(10) NOT NULL,
  PRIMARY KEY  USING BTREE (`idMarginFloorRuleStatistic`),
  KEY `fk_MarginFloorRuleStatistic` (`idPricingRequestCarClass`),
  CONSTRAINT `fk_MarginFloorRuleStatistic` FOREIGN KEY (`idPricingRequestCarClass`) REFERENCES `PricingRequestCarClass` (`idPricingRequestCarClass`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_latvian_ci;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `MarginFloorTriggeredPricingRequestView`
--

DROP TABLE IF EXISTS `MarginFloorTriggeredPricingRequestView`;
/*!50001 DROP VIEW IF EXISTS `MarginFloorTriggeredPricingRequestView`*/;
/*!50001 CREATE TABLE `MarginFloorTriggeredPricingRequestView` (
  `bReq` int(10) unsigned,
  `totalTriggered` bigint(21)
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `MarginFloorView`
--

DROP TABLE IF EXISTS `MarginFloorView`;
/*!50001 DROP VIEW IF EXISTS `MarginFloorView`*/;
/*!50001 CREATE TABLE `MarginFloorView` (
  `idMarginFloor` int(10) unsigned,
  `ranking` varchar(255),
  `countryOfOrigin` varchar(255),
  `geographyCountry` varchar(255),
  `destinationGroup` varchar(255),
  `periodType` varchar(45),
  `baseAbsoluteFloor` decimal(16,2),
  `basePercentageFloor` decimal(4,2)
) ENGINE=MyISAM */;

--
-- Table structure for table `MarginTarget`
--

DROP TABLE IF EXISTS `MarginTarget`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `MarginTarget` (
  `idMarginTarget` int(10) unsigned NOT NULL auto_increment,
  `ranking` varchar(255) default NULL,
  `year` int(11) default NULL,
  `idGeographyCountry` int(10) unsigned default NULL,
  `idDestinationGroup` int(10) unsigned default NULL,
  `idCountryOfOrigin` int(10) unsigned default NULL,
  `idPeriodType` int(10) unsigned default NULL,
  `baseMarginTarget` decimal(12,2) NOT NULL,
  PRIMARY KEY  (`idMarginTarget`),
  UNIQUE KEY `ranking` (`ranking`),
  KEY `fk_MarginTarget_GeographyCountry1` (`idGeographyCountry`),
  KEY `fk_MarginTarget_DestinationGroup1` (`idDestinationGroup`),
  KEY `fk_MarginTarget_CountryOfOrigin1` (`idCountryOfOrigin`),
  KEY `fk_MarginTarget_PeriodType1` (`idPeriodType`),
  CONSTRAINT `fk_MarginTarget_CountryOfOrigin1` FOREIGN KEY (`idCountryOfOrigin`) REFERENCES `CountryOfOrigin` (`idCountryOfOrigin`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_MarginTarget_DestinationGroup1` FOREIGN KEY (`idDestinationGroup`) REFERENCES `DestinationGroup` (`idDestinationGroup`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_MarginTarget_GeographyCountry1` FOREIGN KEY (`idGeographyCountry`) REFERENCES `GeographyCountry` (`idGeographyCountry`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_MarginTarget_PeriodType1` FOREIGN KEY (`idPeriodType`) REFERENCES `PeriodType` (`idPeriodType`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `MarginTargetDuration`
--

DROP TABLE IF EXISTS `MarginTargetDuration`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `MarginTargetDuration` (
  `idMarginTargetDuration` int(10) unsigned NOT NULL auto_increment,
  `idMarginTarget` int(10) unsigned NOT NULL,
  `idDuration` int(10) unsigned NOT NULL,
  `target` decimal(12,2) NOT NULL,
  PRIMARY KEY  (`idMarginTargetDuration`),
  UNIQUE KEY `uniqueKey` (`idMarginTarget`,`idDuration`),
  KEY `fk_MarginTargetDuration_Duration1` (`idDuration`),
  KEY `fk_MarginTargetDuration_MarginTarget1` (`idMarginTarget`),
  CONSTRAINT `fk_MarginTargetDuration_Duration1` FOREIGN KEY (`idDuration`) REFERENCES `Duration` (`idDuration`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_MarginTargetDuration_MarginTarget1` FOREIGN KEY (`idMarginTarget`) REFERENCES `MarginTarget` (`idMarginTarget`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1172 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `MarginTargetRule`
--

DROP TABLE IF EXISTS `MarginTargetRule`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `MarginTargetRule` (
  `idMarginTargetRule` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) NOT NULL,
  PRIMARY KEY  (`idMarginTargetRule`),
  UNIQUE KEY `uniqueKey` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `MarginTargetRuleCarClass`
--

DROP TABLE IF EXISTS `MarginTargetRuleCarClass`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `MarginTargetRuleCarClass` (
  `idMarginTargetRuleCarClass` int(10) unsigned NOT NULL auto_increment,
  `idMarginTargetRule` int(10) unsigned NOT NULL,
  `idCarClass` int(10) unsigned NOT NULL,
  `scaling` decimal(4,2) NOT NULL,
  PRIMARY KEY  (`idMarginTargetRuleCarClass`),
  KEY `fk_MarginTargetRuleCarClass_CarClass1` (`idCarClass`),
  KEY `fk_MarginTargetRuleCarClass_MarginTargetRule1` (`idMarginTargetRule`),
  CONSTRAINT `fk_MarginTargetRuleCarClass_CarClass1` FOREIGN KEY (`idCarClass`) REFERENCES `CarClass` (`idCarClass`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_MarginTargetRuleCarClass_MarginTargetRule1` FOREIGN KEY (`idMarginTargetRule`) REFERENCES `MarginTargetRule` (`idMarginTargetRule`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `MarginTargetRuleDuration`
--

DROP TABLE IF EXISTS `MarginTargetRuleDuration`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `MarginTargetRuleDuration` (
  `idMarginTargetRuleDuration` int(10) unsigned NOT NULL auto_increment,
  `idMarginTargetRule` int(10) unsigned NOT NULL,
  `idDuration` int(10) unsigned NOT NULL,
  `scaling` decimal(4,2) NOT NULL,
  PRIMARY KEY  (`idMarginTargetRuleDuration`),
  UNIQUE KEY `uniqueKey` (`idMarginTargetRule`,`idDuration`),
  KEY `fk_MarginTargetRuleDuration_MarginTargetRule1` (`idMarginTargetRule`),
  KEY `fk_MarginTargetRuleDuration_Duration1` (`idDuration`),
  CONSTRAINT `fk_MarginTargetRuleDuration_Duration1` FOREIGN KEY (`idDuration`) REFERENCES `Duration` (`idDuration`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_MarginTargetRuleDuration_MarginTargetRule1` FOREIGN KEY (`idMarginTargetRule`) REFERENCES `MarginTargetRule` (`idMarginTargetRule`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `MarginTargetView`
--

DROP TABLE IF EXISTS `MarginTargetView`;
/*!50001 DROP VIEW IF EXISTS `MarginTargetView`*/;
/*!50001 CREATE TABLE `MarginTargetView` (
  `idMarginTarget` int(10) unsigned,
  `ranking` varchar(255),
  `year` int(11),
  `geographyCountry` varchar(255),
  `destinationGroup` varchar(255),
  `countryOfOrigin` varchar(255),
  `periodType` varchar(45),
  `baseMarginTarget` decimal(12,2)
) ENGINE=MyISAM */;

--
-- Table structure for table `OpticalUplift`
--

DROP TABLE IF EXISTS `OpticalUplift`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OpticalUplift` (
  `idOpticalUplift` int(10) unsigned NOT NULL auto_increment,
  `ranking` varchar(255) default NULL,
  `idDestinationCountry` int(10) unsigned default NULL,
  `idDestinationGroup` int(10) unsigned default NULL,
  `idCountryOfOrigin` int(10) unsigned default NULL,
  PRIMARY KEY  (`idOpticalUplift`),
  KEY `fk_OpticalUplift_GeographyCountry1` (`idDestinationCountry`),
  KEY `fk_OpticalUplift_DestinationGroup1` (`idDestinationGroup`),
  KEY `fk_OpticalUplift_CountryOfOrigin1` (`idCountryOfOrigin`),
  CONSTRAINT `fk_OpticalUplift_CountryOfOrigin1` FOREIGN KEY (`idCountryOfOrigin`) REFERENCES `CountryOfOrigin` (`idCountryOfOrigin`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_OpticalUplift_DestinationGroup1` FOREIGN KEY (`idDestinationGroup`) REFERENCES `DestinationGroup` (`idDestinationGroup`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_OpticalUplift_GeographyCountry1` FOREIGN KEY (`idDestinationCountry`) REFERENCES `GeographyCountry` (`idGeographyCountry`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `OpticalUpliftDuration`
--

DROP TABLE IF EXISTS `OpticalUpliftDuration`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OpticalUpliftDuration` (
  `idOpticalUpliftDuration` int(10) unsigned NOT NULL auto_increment,
  `idOpticalUplift` int(10) unsigned NOT NULL,
  `idDuration` int(10) unsigned NOT NULL,
  `uplift` decimal(5,2) NOT NULL,
  PRIMARY KEY  (`idOpticalUpliftDuration`),
  KEY `fk_OpticalUpliftDuration_OpticalUplift1` (`idOpticalUplift`),
  KEY `fk_OpticalUpliftDuration_Duration1` (`idDuration`),
  CONSTRAINT `fk_OpticalUpliftDuration_Duration1` FOREIGN KEY (`idDuration`) REFERENCES `Duration` (`idDuration`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_OpticalUpliftDuration_OpticalUplift1` FOREIGN KEY (`idOpticalUplift`) REFERENCES `OpticalUplift` (`idOpticalUplift`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1704 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `PeriodType`
--

DROP TABLE IF EXISTS `PeriodType`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PeriodType` (
  `idPeriodType` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) NOT NULL,
  PRIMARY KEY  (`idPeriodType`),
  UNIQUE KEY `PeriodName` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `PreferredSupplier`
--

DROP TABLE IF EXISTS `PreferredSupplier`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PreferredSupplier` (
  `idPreferredSupplier` int(10) unsigned NOT NULL auto_increment,
  `ranking` varchar(255) default NULL,
  `idGeographyCountry` int(10) unsigned default NULL,
  `idDestinationGroup` int(10) unsigned default NULL,
  `idCountryOfOrigin` int(10) unsigned default NULL,
  `idBarrierDate` int(10) unsigned default NULL,
  `sippCodePattern` varchar(8) default NULL,
  `idSupplier` int(10) unsigned NOT NULL,
  `preferred` tinyint(1) NOT NULL default '1',
  `marginTolerance` decimal(4,2) NOT NULL default '0.00',
  PRIMARY KEY  (`idPreferredSupplier`),
  UNIQUE KEY `ranking` (`ranking`),
  KEY `fk_PreferredSupplier_CountryOfOrigin1` (`idCountryOfOrigin`),
  KEY `fk_PreferredSupplier_Supplier1` (`idSupplier`),
  KEY `fk_PreferredSupplier_BarrierDate1` (`idBarrierDate`),
  KEY `fk_PreferredSupplier_GeographyCountry1` (`idGeographyCountry`),
  KEY `fk_PreferredSupplier_DestinationGroup1` (`idDestinationGroup`),
  CONSTRAINT `fk_PreferredSupplier_BarrierDate1` FOREIGN KEY (`idBarrierDate`) REFERENCES `BarrierDate` (`idBarrierDate`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_PreferredSupplier_CountryOfOrigin1` FOREIGN KEY (`idCountryOfOrigin`) REFERENCES `CountryOfOrigin` (`idCountryOfOrigin`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_PreferredSupplier_DestinationGroup1` FOREIGN KEY (`idDestinationGroup`) REFERENCES `DestinationGroup` (`idDestinationGroup`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_PreferredSupplier_GeographyCountry1` FOREIGN KEY (`idGeographyCountry`) REFERENCES `GeographyCountry` (`idGeographyCountry`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_PreferredSupplier_Supplier1` FOREIGN KEY (`idSupplier`) REFERENCES `Supplier` (`idSupplier`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `PreferredSupplierDuration`
--

DROP TABLE IF EXISTS `PreferredSupplierDuration`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PreferredSupplierDuration` (
  `idPreferredSupplierDuration` int(10) unsigned NOT NULL auto_increment,
  `idPreferredSupplier` int(10) unsigned NOT NULL,
  `idDuration` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`idPreferredSupplierDuration`),
  UNIQUE KEY `uniqueKey` (`idPreferredSupplier`,`idDuration`),
  KEY `fk_PreferredSupplierDuration_PreferredSupplier1` (`idPreferredSupplier`),
  KEY `fk_PreferredSupplierDuration_Duration1` (`idDuration`),
  CONSTRAINT `fk_PreferredSupplierDuration_Duration1` FOREIGN KEY (`idDuration`) REFERENCES `Duration` (`idDuration`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_PreferredSupplierDuration_PreferredSupplier1` FOREIGN KEY (`idPreferredSupplier`) REFERENCES `PreferredSupplier` (`idPreferredSupplier`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `PreferredSupplierView`
--

DROP TABLE IF EXISTS `PreferredSupplierView`;
/*!50001 DROP VIEW IF EXISTS `PreferredSupplierView`*/;
/*!50001 CREATE TABLE `PreferredSupplierView` (
  `idPreferredSupplier` int(10) unsigned,
  `ranking` varchar(255),
  `countryOfOrigin` varchar(255),
  `geographyCountry` varchar(255),
  `destinationGroup` varchar(255),
  `idBarrierDate` int(10) unsigned,
  `sippCodePattern` varchar(8),
  `supplier` varchar(45),
  `preferred` tinyint(1),
  `marginTolerance` decimal(4,2)
) ENGINE=MyISAM */;

--
-- Table structure for table `PriceTolDiff`
--

DROP TABLE IF EXISTS `PriceTolDiff`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PriceTolDiff` (
  `idPriceTolDiff` int(10) unsigned NOT NULL auto_increment,
  `ranking` varchar(255) default NULL,
  `idCountryOfOrigin` int(10) unsigned default NULL,
  `idGeographyCountry` int(10) unsigned default NULL,
  `idDestinationGroup` int(10) unsigned default NULL,
  `idSupplier` int(10) unsigned default NULL,
  `baseTolerance` decimal(4,2) NOT NULL,
  `baseDifferential` decimal(4,2) NOT NULL,
  `idPeriodType` int(10) unsigned default NULL,
  PRIMARY KEY  (`idPriceTolDiff`),
  UNIQUE KEY `ranking` (`ranking`),
  KEY `fk_PriceTolDiff_CountryOfOrigin1` (`idCountryOfOrigin`),
  KEY `fk_PriceTolDiff_DestinationGroup1` (`idDestinationGroup`),
  KEY `fk_PriceTolDiff_Supplier1` (`idSupplier`),
  KEY `fk_PriceTolDiff_GeographyCountry1` (`idGeographyCountry`),
  CONSTRAINT `fk_PriceTolDiff_CountryOfOrigin1` FOREIGN KEY (`idCountryOfOrigin`) REFERENCES `CountryOfOrigin` (`idCountryOfOrigin`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_PriceTolDiff_DestinationGroup1` FOREIGN KEY (`idDestinationGroup`) REFERENCES `DestinationGroup` (`idDestinationGroup`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_PriceTolDiff_GeographyCountry1` FOREIGN KEY (`idGeographyCountry`) REFERENCES `GeographyCountry` (`idGeographyCountry`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_PriceTolDiff_Supplier1` FOREIGN KEY (`idSupplier`) REFERENCES `Supplier` (`idSupplier`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `PriceTolDiffDuration`
--

DROP TABLE IF EXISTS `PriceTolDiffDuration`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PriceTolDiffDuration` (
  `idPriceTolDiffDuration` int(10) unsigned NOT NULL auto_increment,
  `idPriceTolDiff` int(10) unsigned NOT NULL,
  `idDuration` int(10) unsigned NOT NULL,
  `tolerance` decimal(4,2) NOT NULL,
  `differential` decimal(4,2) NOT NULL,
  PRIMARY KEY  (`idPriceTolDiffDuration`),
  UNIQUE KEY `uniqueKey` (`idPriceTolDiff`,`idDuration`),
  KEY `fk_PriceTolDiffDuration_PriceTolDiff1` (`idPriceTolDiff`),
  KEY `fk_PriceTolDiffDuration_Duration1` (`idDuration`),
  CONSTRAINT `fk_PriceTolDiffDuration_Duration1` FOREIGN KEY (`idDuration`) REFERENCES `Duration` (`idDuration`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_PriceTolDiffDuration_PriceTolDiff1` FOREIGN KEY (`idPriceTolDiff`) REFERENCES `PriceTolDiff` (`idPriceTolDiff`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=792 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `PriceTolDiffView`
--

DROP TABLE IF EXISTS `PriceTolDiffView`;
/*!50001 DROP VIEW IF EXISTS `PriceTolDiffView`*/;
/*!50001 CREATE TABLE `PriceTolDiffView` (
  `idPriceTolDiff` int(10) unsigned,
  `ranking` varchar(255),
  `countryOfOrigin` varchar(255),
  `geographyCountry` varchar(255),
  `destinationGroup` varchar(255),
  `supplier` varchar(45),
  `baseTolerance` decimal(4,2),
  `baseDifferential` decimal(4,2)
) ENGINE=MyISAM */;

--
-- Table structure for table `PriceUpdateAction`
--

DROP TABLE IF EXISTS `PriceUpdateAction`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PriceUpdateAction` (
  `idPriceUpdateAction` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) NOT NULL,
  PRIMARY KEY  (`idPriceUpdateAction`),
  UNIQUE KEY `ActionName` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `PricingRequest`
--

DROP TABLE IF EXISTS `PricingRequest`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PricingRequest` (
  `idPricingRequest` int(10) unsigned NOT NULL auto_increment,
  `idCountryOfOrigin` int(10) unsigned NOT NULL,
  `idBarrierDate` int(10) unsigned NOT NULL,
  `puDate` datetime default NULL,
  `duration` int(11) default NULL,
  `requestDate` datetime default NULL,
  `idGeographyLocation` int(10) unsigned NOT NULL,
  `idPricingRequestSource` int(10) unsigned NOT NULL,
  `productType` int(11) default NULL,
  PRIMARY KEY  (`idPricingRequest`),
  KEY `fk_PricingRequest_CountryOfOrigin1` (`idCountryOfOrigin`),
  KEY `fk_PricingRequest_BarrierDate1` (`idBarrierDate`),
  KEY `fk_PricingRequest_GeographyLocation1` (`idGeographyLocation`),
  KEY `fk_PricingRequest_PricingRequestSource1` (`idPricingRequestSource`),
  CONSTRAINT `fk_PricingRequest_CountryOfOrigin1` FOREIGN KEY (`idCountryOfOrigin`) REFERENCES `CountryOfOrigin` (`idCountryOfOrigin`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_PricingRequest_GeographyLocation1` FOREIGN KEY (`idGeographyLocation`) REFERENCES `GeographyLocation` (`idGeographyLocation`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_PricingRequest_PricingRequestSource1` FOREIGN KEY (`idPricingRequestSource`) REFERENCES `PricingRequestSource` (`idPricingRequestSource`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `PricingRequestCarClass`
--

DROP TABLE IF EXISTS `PricingRequestCarClass`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PricingRequestCarClass` (
  `idPricingRequestCarClass` int(11) NOT NULL,
  `idCarClass` int(10) unsigned NOT NULL,
  `idPricingRequest` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`idPricingRequestCarClass`),
  KEY `fk_PricingRequestCarClass_CarClass1` (`idCarClass`),
  KEY `fk_PricingRequestCarClass_PricingRequest1` (`idPricingRequest`),
  CONSTRAINT `fk_PricingRequestCarClass_CarClass1` FOREIGN KEY (`idCarClass`) REFERENCES `CarClass` (`idCarClass`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_PricingRequestCarClass_PricingRequest1` FOREIGN KEY (`idPricingRequest`) REFERENCES `PricingRequest` (`idPricingRequest`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `PricingRequestSource`
--

DROP TABLE IF EXISTS `PricingRequestSource`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `PricingRequestSource` (
  `idPricingRequestSource` int(10) unsigned NOT NULL auto_increment,
  `source` varchar(45) NOT NULL,
  PRIMARY KEY  (`idPricingRequestSource`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `PricingRequestStatisticView`
--

DROP TABLE IF EXISTS `PricingRequestStatisticView`;
/*!50001 DROP VIEW IF EXISTS `PricingRequestStatisticView`*/;
/*!50001 CREATE TABLE `PricingRequestStatisticView` (
  `idPricingRequestStatisticView` int(10) unsigned,
  `idCountryOfOrigin` int(10) unsigned,
  `idBarrierDate` int(10) unsigned,
  `idGeographyLocation` int(10) unsigned,
  `idGeographyCountry` int(10) unsigned,
  `idDestinationGroup` int(10) unsigned,
  `idPricingRequestSource` int(10) unsigned,
  `pickUpDate` datetime,
  `duration` int(11),
  `requestDate` datetime,
  `totalMarginFloorsTriggered` bigint(21),
  `totalRequests` bigint(21)
) ENGINE=MyISAM */;

--
-- Table structure for table `RetailPriceRuleStatistic`
--

DROP TABLE IF EXISTS `RetailPriceRuleStatistic`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `RetailPriceRuleStatistic` (
  `idRetailPriceRuleStatistic` int(10) unsigned NOT NULL auto_increment,
  `idPricingRequestCarClass` int(10) NOT NULL,
  `ruleTriggered` tinyint(1) NOT NULL,
  `retailPrice` decimal(12,2) default NULL,
  PRIMARY KEY  USING BTREE (`idRetailPriceRuleStatistic`),
  KEY `fk_RetailPriceRuleStatistic_PricingRequestCarClass1` (`idPricingRequestCarClass`),
  CONSTRAINT `fk_RetailPriceRuleStatistic_PricingRequestCarClass1` FOREIGN KEY (`idPricingRequestCarClass`) REFERENCES `PricingRequestCarClass` (`idPricingRequestCarClass`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `Supplier`
--

DROP TABLE IF EXISTS `Supplier`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Supplier` (
  `idSupplier` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(45) NOT NULL,
  `retail` tinyint(1) NOT NULL default '0',
  `retailBound` tinyint(1) NOT NULL default '0',
  `groupPattern` varchar(255) NOT NULL,
  PRIMARY KEY  (`idSupplier`),
  UNIQUE KEY `supplierName` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2437 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `SupplierStepUp`
--

DROP TABLE IF EXISTS `SupplierStepUp`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `SupplierStepUp` (
  `idSupplierStepUp` int(10) unsigned NOT NULL auto_increment,
  `ranking` varchar(255) default NULL,
  `idGeographyCountry` int(10) unsigned default NULL,
  `idDestinationGroup` int(10) unsigned default NULL,
  `priceIncrement` decimal(5,2) NOT NULL,
  `marginIncrement` decimal(5,2) NOT NULL,
  PRIMARY KEY  (`idSupplierStepUp`),
  KEY `fk_SupplierStepUp_GeographyCountry1` (`idGeographyCountry`),
  KEY `fk_SupplierStepUp_DestinationGroup1` (`idDestinationGroup`),
  KEY `ranking` (`ranking`),
  CONSTRAINT `fk_SupplierStepUp_DestinationGroup1` FOREIGN KEY (`idDestinationGroup`) REFERENCES `DestinationGroup` (`idDestinationGroup`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_SupplierStepUp_GeographyCountry1` FOREIGN KEY (`idGeographyCountry`) REFERENCES `GeographyCountry` (`idGeographyCountry`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=382 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `SupplierStepUpView`
--

DROP TABLE IF EXISTS `SupplierStepUpView`;
/*!50001 DROP VIEW IF EXISTS `SupplierStepUpView`*/;
/*!50001 CREATE TABLE `SupplierStepUpView` (
  `idSupplierStepUp` int(10) unsigned,
  `ranking` varchar(255),
  `geographyCountry` varchar(255),
  `destinationGroup` varchar(255),
  `priceIncrement` decimal(5,2),
  `marginIncrement` decimal(5,2)
) ENGINE=MyISAM */;

--
-- Table structure for table `TacticalPriceRule`
--

DROP TABLE IF EXISTS `TacticalPriceRule`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `TacticalPriceRule` (
  `idTacticalPriceRule` int(10) unsigned NOT NULL auto_increment,
  `ranking` varchar(255) default NULL,
  `idGeographyCountry` int(10) unsigned default NULL,
  `idDestinationGroup` int(10) unsigned default NULL,
  `idCountryOfOrigin` int(10) unsigned default NULL,
  `fromDateTime` datetime default NULL,
  `toDateTime` datetime default NULL,
  `minDateRange` int(11) default NULL,
  `maxDateRange` int(11) default NULL,
  `sippCodePattern` varchar(8) default NULL,
  `markUpPercentage` decimal(4,2) NOT NULL,
  `description` varchar(255) default NULL,
  PRIMARY KEY  (`idTacticalPriceRule`),
  UNIQUE KEY `ranking` (`ranking`),
  KEY `fk_TacticalPriceRule_GeographyCountry1` (`idGeographyCountry`),
  KEY `fk_TacticalPriceRule_CountryOfOrigin1` (`idCountryOfOrigin`),
  KEY `fk_TacticalPriceRule_DestinationGroup1` (`idDestinationGroup`),
  CONSTRAINT `fk_TacticalPriceRule_CountryOfOrigin1` FOREIGN KEY (`idCountryOfOrigin`) REFERENCES `CountryOfOrigin` (`idCountryOfOrigin`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_TacticalPriceRule_DestinationGroup1` FOREIGN KEY (`idDestinationGroup`) REFERENCES `DestinationGroup` (`idDestinationGroup`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_TacticalPriceRule_GeographyCountry1` FOREIGN KEY (`idGeographyCountry`) REFERENCES `GeographyCountry` (`idGeographyCountry`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `TacticalPriceRuleDuration`
--

DROP TABLE IF EXISTS `TacticalPriceRuleDuration`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `TacticalPriceRuleDuration` (
  `idTacticalPriceRuleDuration` int(10) unsigned NOT NULL auto_increment,
  `idTacticalPriceRule` int(10) unsigned NOT NULL,
  `idDuration` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`idTacticalPriceRuleDuration`),
  KEY `fk_TacticalPriceRuleDuration_TacticalPriceRule1` (`idTacticalPriceRule`),
  KEY `fk_TacticalPriceRuleDuration_Duration1` (`idDuration`),
  CONSTRAINT `fk_TacticalPriceRuleDuration_Duration1` FOREIGN KEY (`idDuration`) REFERENCES `Duration` (`idDuration`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_TacticalPriceRuleDuration_TacticalPriceRule1` FOREIGN KEY (`idTacticalPriceRule`) REFERENCES `TacticalPriceRule` (`idTacticalPriceRule`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `TacticalPriceRuleStatistic`
--

DROP TABLE IF EXISTS `TacticalPriceRuleStatistic`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `TacticalPriceRuleStatistic` (
  `idTacticalPriceRuleStatistic` int(10) unsigned NOT NULL auto_increment,
  `idPricingRequestCarClass` int(10) NOT NULL,
  `triggered` tinyint(1) NOT NULL,
  PRIMARY KEY  (`idTacticalPriceRuleStatistic`),
  KEY `fk_TacticalPriceRuleStatistic_PricingRequest1` (`idPricingRequestCarClass`),
  CONSTRAINT `fk_TacticalPriceRuleStatistic_PricingRequest1` FOREIGN KEY (`idPricingRequestCarClass`) REFERENCES `PricingRequestCarClass` (`idPricingRequestCarClass`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `TacticalPriceRuleView`
--

DROP TABLE IF EXISTS `TacticalPriceRuleView`;
/*!50001 DROP VIEW IF EXISTS `TacticalPriceRuleView`*/;
/*!50001 CREATE TABLE `TacticalPriceRuleView` (
  `idtacticalPriceRule` int(10) unsigned,
  `ranking` varchar(255),
  `geographyCountry` varchar(255),
  `destinationGroup` varchar(255),
  `countryOfOrigin` varchar(255),
  `fromDateTime` datetime,
  `toDateTime` datetime,
  `minDateRange` int(11),
  `maxDateRange` int(11),
  `sippCodePattern` varchar(8),
  `markUpPercentage` decimal(4,2),
  `description` varchar(255)
) ENGINE=MyISAM */;

--
-- Table structure for table `TargetSellingPrice`
--

DROP TABLE IF EXISTS `TargetSellingPrice`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `TargetSellingPrice` (
  `idTargetSellingPrice` int(10) unsigned NOT NULL auto_increment,
  `idCountryOfOrigin` int(10) unsigned NOT NULL,
  `idBarrierDate` int(10) unsigned NOT NULL,
  `idDuration` int(10) unsigned NOT NULL,
  `idCarClass` int(10) unsigned NOT NULL,
  `price` decimal(12,2) NOT NULL,
  `currentActive` tinyint(1) NOT NULL default '0',
  `updateUser` int(10) unsigned NOT NULL,
  `updateDateTime` datetime NOT NULL,
  `idPriceUpdateAction` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`idTargetSellingPrice`),
  KEY `fk_TargetSellingPrice_CountryOfOrigin1` (`idCountryOfOrigin`),
  KEY `fk_TargetSellingPrice_Duration1` (`idDuration`),
  KEY `fk_TargetSellingPrice_CarClass1` (`idCarClass`),
  KEY `fk_TargetSellingPrice_User1` (`updateUser`),
  KEY `fk_TargetSellingPrice_PriceUpdateAction1` (`idPriceUpdateAction`),
  KEY `compKey` (`idCountryOfOrigin`,`idDuration`,`idCarClass`,`currentActive`),
  KEY `fk_TargetSellingPrice_BarrierDate1` (`idBarrierDate`),
  CONSTRAINT `fk_TargetSellingPrice_BarrierDate1` FOREIGN KEY (`idBarrierDate`) REFERENCES `BarrierDate` (`idBarrierDate`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_TargetSellingPrice_CarClass1` FOREIGN KEY (`idCarClass`) REFERENCES `CarClass` (`idCarClass`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_TargetSellingPrice_CountryOfOrigin1` FOREIGN KEY (`idCountryOfOrigin`) REFERENCES `CountryOfOrigin` (`idCountryOfOrigin`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_TargetSellingPrice_Duration1` FOREIGN KEY (`idDuration`) REFERENCES `Duration` (`idDuration`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_TargetSellingPrice_PriceUpdateAction1` FOREIGN KEY (`idPriceUpdateAction`) REFERENCES `PriceUpdateAction` (`idPriceUpdateAction`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_TargetSellingPrice_User1` FOREIGN KEY (`updateUser`) REFERENCES `User` (`idUser`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2790174 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `TargetSellingPriceView`
--

DROP TABLE IF EXISTS `TargetSellingPriceView`;
/*!50001 DROP VIEW IF EXISTS `TargetSellingPriceView`*/;
/*!50001 CREATE TABLE `TargetSellingPriceView` (
  `idTargetSellingPrice` int(10) unsigned,
  `countryOfOrigin` varchar(255),
  `carClass` varchar(8),
  `minDuration` bigint(11) unsigned,
  `maxDuration` bigint(11) unsigned,
  `idBarrierDate` int(10) unsigned,
  `price` decimal(12,2),
  `currentActive` tinyint(1),
  `userName` varchar(45),
  `updateDateTime` datetime,
  `priceUpdateAction` varchar(45)
) ENGINE=MyISAM */;

--
-- Table structure for table `User`
--

DROP TABLE IF EXISTS `User`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `User` (
  `idUser` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`idUser`),
  UNIQUE KEY `userName` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Final view structure for view `MarginFloorPricingRequestView`
--

/*!50001 DROP TABLE `MarginFloorPricingRequestView`*/;
/*!50001 DROP VIEW IF EXISTS `MarginFloorPricingRequestView`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`mysql`@`192.168.162.%` SQL SECURITY DEFINER */
/*!50001 VIEW `MarginFloorPricingRequestView` AS select `pr`.`idPricingRequest` AS `aReq`,`pr`.`idPricingRequest` AS `idPricingRequest`,`pr`.`idCountryOfOrigin` AS `idCountryOfOrigin`,`pr`.`idBarrierDate` AS `idBarrierDate`,`pr`.`puDate` AS `puDate`,`pr`.`duration` AS `duration`,`pr`.`requestDate` AS `requestDate`,`pr`.`idGeographyLocation` AS `idGeographyLocation`,`pr`.`idPricingRequestSource` AS `idPricingRequestSource`,`pr`.`productType` AS `productType`,`dg`.`idDestinationGroup` AS `idDestinationGroup`,`gcountry`.`idGeographyCountry` AS `idGeographyCountry`,count(0) AS `total` from (((((((`MarginFloorRuleStatistic` `mf` join `CarClass` `cc`) join `PricingRequest` `pr`) join `PricingRequestCarClass` `prcc`) join `GeographyLocation` `gl`) join `DestinationGroup` `dg`) join `GeographyCity` `gcity`) join `GeographyCountry` `gcountry`) where ((`mf`.`idPricingRequestCarClass` = `prcc`.`idPricingRequestCarClass`) and (`prcc`.`idCarClass` = `cc`.`idCarClass`) and (`pr`.`idPricingRequest` = `prcc`.`idPricingRequest`) and (`gl`.`idGeographyLocation` = `pr`.`idGeographyLocation`) and (`gl`.`idDestinationGroup` = `dg`.`idDestinationGroup`) and (`gl`.`idGeographyCity` = `gcity`.`idGeographyCity`) and (`gcity`.`idGeographyCountry` = `gcountry`.`idGeographyCountry`)) group by `pr`.`idPricingRequest` */;

--
-- Final view structure for view `MarginFloorTriggeredPricingRequestView`
--

/*!50001 DROP TABLE `MarginFloorTriggeredPricingRequestView`*/;
/*!50001 DROP VIEW IF EXISTS `MarginFloorTriggeredPricingRequestView`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`mysql`@`192.168.162.%` SQL SECURITY DEFINER */
/*!50001 VIEW `MarginFloorTriggeredPricingRequestView` AS select `pr`.`idPricingRequest` AS `bReq`,count(0) AS `totalTriggered` from (((((((`MarginFloorRuleStatistic` `mf` join `CarClass` `cc`) join `PricingRequest` `pr`) join `PricingRequestCarClass` `prcc`) join `GeographyLocation` `gl`) join `DestinationGroup` `dg`) join `GeographyCity` `gcity`) join `GeographyCountry` `gcountry`) where ((`mf`.`idPricingRequestCarClass` = `prcc`.`idPricingRequestCarClass`) and (`prcc`.`idCarClass` = `cc`.`idCarClass`) and (`pr`.`idPricingRequest` = `prcc`.`idPricingRequest`) and (`gl`.`idGeographyLocation` = `pr`.`idGeographyLocation`) and (`gl`.`idDestinationGroup` = `dg`.`idDestinationGroup`) and (`gl`.`idGeographyCity` = `gcity`.`idGeographyCity`) and (`gcity`.`idGeographyCountry` = `gcountry`.`idGeographyCountry`) and (`mf`.`ruleTriggered` = 1)) group by `pr`.`idPricingRequest` */;

--
-- Final view structure for view `MarginFloorView`
--

/*!50001 DROP TABLE `MarginFloorView`*/;
/*!50001 DROP VIEW IF EXISTS `MarginFloorView`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`mysql`@`192.168.162.%` SQL SECURITY DEFINER */
/*!50001 VIEW `MarginFloorView` AS select `MF`.`idMarginFloor` AS `idMarginFloor`,`MF`.`ranking` AS `ranking`,(select `COO`.`name` AS `name` from `CountryOfOrigin` `COO` where (`MF`.`idCountryOfOrigin` = `COO`.`idCountryOfOrigin`)) AS `countryOfOrigin`,(select `GL`.`name` AS `name` from `GeographyCountry` `GL` where (`MF`.`idDestinationCountry` = `GL`.`idGeographyCountry`)) AS `geographyCountry`,(select `DG`.`name` AS `name` from `DestinationGroup` `DG` where (`MF`.`idDestinationGroup` = `DG`.`idDestinationGroup`)) AS `destinationGroup`,(select `PT`.`name` AS `name` from `PeriodType` `PT` where (`MF`.`idPeriodType` = `PT`.`idPeriodType`)) AS `periodType`,`MF`.`baseAbsoluteFloor` AS `baseAbsoluteFloor`,`MF`.`basePercentageFloor` AS `basePercentageFloor` from `MarginFloor` `MF` order by `MF`.`ranking` */;

--
-- Final view structure for view `MarginTargetView`
--

/*!50001 DROP TABLE `MarginTargetView`*/;
/*!50001 DROP VIEW IF EXISTS `MarginTargetView`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`mysql`@`192.168.162.%` SQL SECURITY DEFINER */
/*!50001 VIEW `MarginTargetView` AS select `MT`.`idMarginTarget` AS `idMarginTarget`,`MT`.`ranking` AS `ranking`,`MT`.`year` AS `year`,(select `GL`.`name` AS `name` from `GeographyCountry` `GL` where (`MT`.`idGeographyCountry` = `GL`.`idGeographyCountry`)) AS `geographyCountry`,(select `DG`.`name` AS `name` from `DestinationGroup` `DG` where (`MT`.`idDestinationGroup` = `DG`.`idDestinationGroup`)) AS `destinationGroup`,(select `COO`.`name` AS `name` from `CountryOfOrigin` `COO` where (`MT`.`idCountryOfOrigin` = `COO`.`idCountryOfOrigin`)) AS `countryOfOrigin`,(select `PT`.`name` AS `name` from `PeriodType` `PT` where (`MT`.`idPeriodType` = `PT`.`idPeriodType`)) AS `periodType`,`MT`.`baseMarginTarget` AS `baseMarginTarget` from `MarginTarget` `MT` order by `MT`.`ranking` */;

--
-- Final view structure for view `PreferredSupplierView`
--

/*!50001 DROP TABLE `PreferredSupplierView`*/;
/*!50001 DROP VIEW IF EXISTS `PreferredSupplierView`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`mysql`@`192.168.162.%` SQL SECURITY DEFINER */
/*!50001 VIEW `PreferredSupplierView` AS select `PS`.`idPreferredSupplier` AS `idPreferredSupplier`,`PS`.`ranking` AS `ranking`,(select `COO`.`name` AS `name` from `CountryOfOrigin` `COO` where (`PS`.`idCountryOfOrigin` = `COO`.`idCountryOfOrigin`)) AS `countryOfOrigin`,(select `GL`.`name` AS `name` from `GeographyCountry` `GL` where (`PS`.`idGeographyCountry` = `GL`.`idGeographyCountry`)) AS `geographyCountry`,(select `DG`.`name` AS `name` from `DestinationGroup` `DG` where (`PS`.`idDestinationGroup` = `DG`.`idDestinationGroup`)) AS `destinationGroup`,`PS`.`idBarrierDate` AS `idBarrierDate`,`PS`.`sippCodePattern` AS `sippCodePattern`,(select `S`.`name` AS `name` from `Supplier` `S` where (`PS`.`idSupplier` = `S`.`idSupplier`)) AS `supplier`,`PS`.`preferred` AS `preferred`,`PS`.`marginTolerance` AS `marginTolerance` from `PreferredSupplier` `PS` order by `PS`.`ranking` */;

--
-- Final view structure for view `PriceTolDiffView`
--

/*!50001 DROP TABLE `PriceTolDiffView`*/;
/*!50001 DROP VIEW IF EXISTS `PriceTolDiffView`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`mysql`@`192.168.162.%` SQL SECURITY DEFINER */
/*!50001 VIEW `PriceTolDiffView` AS select `PTD`.`idPriceTolDiff` AS `idPriceTolDiff`,`PTD`.`ranking` AS `ranking`,(select `COO`.`name` AS `name` from `CountryOfOrigin` `COO` where (`PTD`.`idCountryOfOrigin` = `COO`.`idCountryOfOrigin`)) AS `countryOfOrigin`,(select `GL`.`name` AS `name` from `GeographyCountry` `GL` where (`PTD`.`idGeographyCountry` = `GL`.`idGeographyCountry`)) AS `geographyCountry`,(select `DG`.`name` AS `name` from `DestinationGroup` `DG` where (`PTD`.`idDestinationGroup` = `DG`.`idDestinationGroup`)) AS `destinationGroup`,(select `S`.`name` AS `name` from `Supplier` `S` where (`PTD`.`idSupplier` = `S`.`idSupplier`)) AS `supplier`,`PTD`.`baseTolerance` AS `baseTolerance`,`PTD`.`baseDifferential` AS `baseDifferential` from `PriceTolDiff` `PTD` order by `PTD`.`ranking` */;

--
-- Final view structure for view `PricingRequestStatisticView`
--

/*!50001 DROP TABLE `PricingRequestStatisticView`*/;
/*!50001 DROP VIEW IF EXISTS `PricingRequestStatisticView`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`mysql`@`192.168.162.%` SQL SECURITY DEFINER */
/*!50001 VIEW `PricingRequestStatisticView` AS select `mfr`.`idPricingRequest` AS `idPricingRequestStatisticView`,`mfr`.`idCountryOfOrigin` AS `idCountryOfOrigin`,`mfr`.`idBarrierDate` AS `idBarrierDate`,`mfr`.`idGeographyLocation` AS `idGeographyLocation`,`mfr`.`idGeographyCountry` AS `idGeographyCountry`,`mfr`.`idDestinationGroup` AS `idDestinationGroup`,`mfr`.`idPricingRequestSource` AS `idPricingRequestSource`,`mfr`.`puDate` AS `pickUpDate`,`mfr`.`duration` AS `duration`,`mfr`.`requestDate` AS `requestDate`,`mft`.`totalTriggered` AS `totalMarginFloorsTriggered`,`mfr`.`total` AS `totalRequests` from (`MarginFloorPricingRequestView` `mfr` join `MarginFloorTriggeredPricingRequestView` `mft`) where (`mfr`.`aReq` = `mft`.`bReq`) */;

--
-- Final view structure for view `SupplierStepUpView`
--

/*!50001 DROP TABLE `SupplierStepUpView`*/;
/*!50001 DROP VIEW IF EXISTS `SupplierStepUpView`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`mysql`@`192.168.162.%` SQL SECURITY DEFINER */
/*!50001 VIEW `SupplierStepUpView` AS select `SSU`.`idSupplierStepUp` AS `idSupplierStepUp`,`SSU`.`ranking` AS `ranking`,(select `GL`.`name` AS `name` from `GeographyCountry` `GL` where (`SSU`.`idGeographyCountry` = `GL`.`idGeographyCountry`)) AS `geographyCountry`,(select `DG`.`name` AS `name` from `DestinationGroup` `DG` where (`SSU`.`idDestinationGroup` = `DG`.`idDestinationGroup`)) AS `destinationGroup`,`SSU`.`priceIncrement` AS `priceIncrement`,`SSU`.`marginIncrement` AS `marginIncrement` from `SupplierStepUp` `SSU` order by `SSU`.`ranking` */;

--
-- Final view structure for view `TacticalPriceRuleView`
--

/*!50001 DROP TABLE `TacticalPriceRuleView`*/;
/*!50001 DROP VIEW IF EXISTS `TacticalPriceRuleView`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`mysql`@`192.168.162.%` SQL SECURITY DEFINER */
/*!50001 VIEW `TacticalPriceRuleView` AS select `TPR`.`idTacticalPriceRule` AS `idtacticalPriceRule`,`TPR`.`ranking` AS `ranking`,(select `GL`.`name` AS `name` from `GeographyCountry` `GL` where (`TPR`.`idGeographyCountry` = `GL`.`idGeographyCountry`)) AS `geographyCountry`,(select `DG`.`name` AS `name` from `DestinationGroup` `DG` where (`TPR`.`idDestinationGroup` = `DG`.`idDestinationGroup`)) AS `destinationGroup`,(select `COO`.`name` AS `name` from `CountryOfOrigin` `COO` where (`TPR`.`idCountryOfOrigin` = `COO`.`idCountryOfOrigin`)) AS `countryOfOrigin`,`TPR`.`fromDateTime` AS `fromDateTime`,`TPR`.`toDateTime` AS `toDateTime`,`TPR`.`minDateRange` AS `minDateRange`,`TPR`.`maxDateRange` AS `maxDateRange`,`TPR`.`sippCodePattern` AS `sippCodePattern`,`TPR`.`markUpPercentage` AS `markUpPercentage`,`TPR`.`description` AS `description` from `TacticalPriceRule` `TPR` order by `TPR`.`ranking` */;

--
-- Final view structure for view `TargetSellingPriceView`
--

/*!50001 DROP TABLE `TargetSellingPriceView`*/;
/*!50001 DROP VIEW IF EXISTS `TargetSellingPriceView`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`mysql`@`192.168.162.%` SQL SECURITY DEFINER */
/*!50001 VIEW `TargetSellingPriceView` AS select `TSP`.`idTargetSellingPrice` AS `idTargetSellingPrice`,(select `COO`.`name` AS `name` from `CountryOfOrigin` `COO` where (`TSP`.`idCountryOfOrigin` = `COO`.`idCountryOfOrigin`)) AS `countryOfOrigin`,(select `CC`.`name` AS `name` from `CarClass` `CC` where (`TSP`.`idCarClass` = `CC`.`idCarClass`)) AS `carClass`,(select `D`.`min` AS `min` from `Duration` `D` where (`TSP`.`idCarClass` = `D`.`idDuration`)) AS `minDuration`,(select `D`.`max` AS `max` from `Duration` `D` where (`TSP`.`idDuration` = `D`.`idDuration`)) AS `maxDuration`,`TSP`.`idBarrierDate` AS `idBarrierDate`,`TSP`.`price` AS `price`,`TSP`.`currentActive` AS `currentActive`,(select `U`.`username` AS `username` from `User` `U` where (`TSP`.`updateUser` = `U`.`idUser`)) AS `userName`,`TSP`.`updateDateTime` AS `updateDateTime`,(select `PUA`.`name` AS `name` from `PriceUpdateAction` `PUA` where (`TSP`.`idPriceUpdateAction` = `PUA`.`idPriceUpdateAction`)) AS `priceUpdateAction` from `TargetSellingPrice` `TSP` */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2010-04-07 16:24:46

drop table MarginFloorRuleStatistic;
show create table MarginFloorPricingRequestView;