-- MySQL dump 10.13  Distrib 5.1.73, for debian-linux-gnu (i486)
--
-- Host: dynergiepatent.mysql.db    Database: dynergiepatent
-- ------------------------------------------------------
-- Server version	5.5.47-0+deb7u1-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 `abstract_contact`
--

DROP TABLE IF EXISTS `abstract_contact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `abstract_contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `discr` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_EED580A85E237E06` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `abstract_contact`
--

LOCK TABLES `abstract_contact` WRITE;
/*!40000 ALTER TABLE `abstract_contact` DISABLE KEYS */;
INSERT INTO `abstract_contact` VALUES (1,'Lifestand','company'),(2,'Cabinet Beau de Loménie','company'),(3,'Serge Ferrari','company'),(4,'ML','company'),(5,'Cleveland Clinic','company');
/*!40000 ALTER TABLE `abstract_contact` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `abstract_invoice`
--

DROP TABLE IF EXISTS `abstract_invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `abstract_invoice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patent_id` int(11) DEFAULT NULL,
  `reference` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `currency` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `invoiced_at` datetime NOT NULL,
  `amount` double NOT NULL,
  `discr` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_32D271D4AEA34913` (`reference`),
  KEY `IDX_32D271D411AAFF4A` (`patent_id`),
  CONSTRAINT `FK_32D271D411AAFF4A` FOREIGN KEY (`patent_id`) REFERENCES `abstract_patent` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `abstract_invoice`
--

LOCK TABLES `abstract_invoice` WRITE;
/*!40000 ALTER TABLE `abstract_invoice` DISABLE KEYS */;
INSERT INTO `abstract_invoice` VALUES (1,64,'1H717960 0001 FR BN','EUR','2013-01-01 00:00:00',-165,'annuity'),(2,53,'1H703140 0018 FR OEB','EUR','2013-01-01 00:00:00',-165,'annuity'),(3,49,'1H717960 0016 FR BN','EUR','9999-01-01 00:00:00',-203,'annuity'),(4,38,'1H703140 0016 FR OEB','EUR','2013-01-01 00:00:00',-203,'annuity'),(5,42,'1H703140 0017 FR ECT','EUR','2013-01-01 00:00:00',-203,'annuity'),(6,85,'1H717960 0007 FR OEB','EUR','2013-01-01 00:00:00',-243,'annuity'),(7,32,'1H717960 0015 FR BN','EUR','9999-01-01 00:00:00',-243,'annuity'),(8,75,'1H717960 0005 FR OEB','EUR','2013-01-01 00:00:00',-283,'annuity'),(9,81,'1H717960 0006 FR OEB','EUR','2013-01-01 00:00:00',-283,'annuity'),(13,66,'1H717960 0001 DE BN','EUR','9999-01-01 00:00:00',-329.1,'annuity'),(14,35,'1H703140 0016 BE OEB','EUR','2013-01-01 00:00:00',-330.13,'annuity'),(15,68,'1H717960 0003 FR BN','EUR','2013-01-01 00:00:00',-339,'annuity'),(16,77,'1H717960 0006 FR BN','EUR','2013-01-01 00:00:00',-339,'annuity'),(17,70,'1H717960 0004 FR BN','EUR','2014-01-01 00:00:00',-339,'annuity'),(18,71,'1H717960 0005 FR BN','EUR','2013-01-01 00:00:00',-339,'annuity'),(19,67,'1H717960 0002 FR BN','EUR','2013-01-01 00:00:00',-339,'annuity'),(20,54,'1H703140 0018 GB OEB','EUR','2013-01-01 00:00:00',-349.53,'annuity'),(21,44,'1H703140 0017 CH ECT','EUR','2013-01-01 00:00:00',-376.9,'annuity'),(22,36,'1H703140 0016 CH OEB','EUR','2013-01-01 00:00:00',-376.9,'annuity'),(23,51,'1H703140 0018 CH OEB','EUR','2013-01-01 00:00:00',-376.9,'annuity'),(24,46,'1H703140 0017 GB ECT','EUR','2013-01-01 00:00:00',-377.59,'annuity'),(25,39,'1H703140 0016 GB OEB','EUR','2013-01-01 00:00:00',-377.59,'annuity'),(26,31,'1H717960 0014 FR OEB','EUR','2013-01-01 00:00:00',-379,'annuity'),(27,52,'1H703140 0018 DE OEB','EUR','2013-01-01 00:00:00',-380.6,'annuity'),(28,39,'1H717960 0015 GB OEB','EUR','2013-01-01 00:00:00',-433.71,'annuity'),(29,82,'1H717960 0006 GB OEB','EUR','2013-01-01 00:00:00',-433.71,'annuity'),(30,45,'1H703140 0017 DE ECT','EUR','2013-01-01 00:00:00',-442.4,'annuity'),(31,37,'1H703140 0016 DE OEB','EUR','2013-01-01 00:00:00',-442.4,'annuity'),(32,40,'1H703140 0016 SE OEB','EUR','2013-01-01 00:00:00',-459.7,'annuity'),(33,24,'1H717960 0013 FR BN','EUR','2013-01-01 00:00:00',-469,'annuity'),(34,18,'1H717960 0012 FR BN','EUR','2013-01-01 00:00:00',-469,'annuity'),(35,79,'1H717960 0006 CH OEB','EUR','2013-01-01 00:00:00',-476.84,'annuity'),(36,83,'XZ208','EUR','2013-09-02 00:00:00',-5000,'procedure'),(39,83,'YYY','EUR','2014-01-01 00:00:00',-5000,'opposition');
/*!40000 ALTER TABLE `abstract_invoice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `abstract_patent`
--

DROP TABLE IF EXISTS `abstract_patent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `abstract_patent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner_id` int(11) NOT NULL,
  `depositor_id` int(11) DEFAULT NULL,
  `representative_id` int(11) DEFAULT NULL,
  `inventor_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `application_zone_id` int(11) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `publication_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `filed_at` datetime NOT NULL,
  `prioritized_at` datetime NOT NULL,
  `published_at` datetime DEFAULT NULL,
  `delivered_at` datetime DEFAULT NULL,
  `lapsed_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `image_path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deposit_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deposit_reason` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `discr` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lft` int(11) NOT NULL,
  `rght` int(11) NOT NULL,
  `root` int(11) DEFAULT NULL,
  `level` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_C8F2DDB02B36786B` (`title`),
  UNIQUE KEY `UNIQ_C8F2DDB0AEA34913` (`reference`),
  UNIQUE KEY `UNIQ_C8F2DDB0871B4215` (`deposit_number`),
  KEY `IDX_C8F2DDB07E3C61F9` (`owner_id`),
  KEY `IDX_C8F2DDB0EB8724B4` (`depositor_id`),
  KEY `IDX_C8F2DDB0FC3FF006` (`representative_id`),
  KEY `IDX_C8F2DDB09CECD5D4` (`inventor_id`),
  KEY `IDX_C8F2DDB0727ACA70` (`parent_id`),
  KEY `IDX_C8F2DDB074923A98` (`application_zone_id`),
  CONSTRAINT `FK_C8F2DDB0727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `abstract_patent` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_C8F2DDB074923A98` FOREIGN KEY (`application_zone_id`) REFERENCES `application_zone` (`id`),
  CONSTRAINT `FK_C8F2DDB07E3C61F9` FOREIGN KEY (`owner_id`) REFERENCES `abstract_contact` (`id`),
  CONSTRAINT `FK_C8F2DDB09CECD5D4` FOREIGN KEY (`inventor_id`) REFERENCES `abstract_contact` (`id`),
  CONSTRAINT `FK_C8F2DDB0EB8724B4` FOREIGN KEY (`depositor_id`) REFERENCES `abstract_contact` (`id`),
  CONSTRAINT `FK_C8F2DDB0FC3FF006` FOREIGN KEY (`representative_id`) REFERENCES `abstract_contact` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `abstract_patent`
--

LOCK TABLES `abstract_patent` WRITE;
/*!40000 ALTER TABLE `abstract_patent` DISABLE KEYS */;
INSERT INTO `abstract_patent` VALUES (1,1,1,2,NULL,NULL,4,'Parallélogramme repose-pieds','1H703140 0009 SE BN','SE9900845','1999-03-10 00:00:00','1999-03-10 00:00:00','2000-09-11 00:00:00','2003-09-09 00:00:00',NULL,NULL,NULL,'SE9900845','do not know','patent',1,10,1,0),(2,1,1,2,NULL,1,1,'Parallélogramme repose-pieds DE','1H703140 0009 DE BN','DE19912840','1999-03-22 00:00:00','1999-03-10 00:00:00','2000-09-28 00:00:00','2004-07-22 00:00:00',NULL,NULL,NULL,'DE19912840','do not know','patent',8,9,1,1),(3,1,1,2,NULL,1,2,'Parallélogramme repose-pieds GB','1H703140 0009 GB BN','GB2348363','1999-04-01 00:00:00','1999-03-10 00:00:00','1999-05-26 00:00:00','2003-06-25 00:00:00',NULL,NULL,NULL,'GB9907728','do not know','patent',6,7,1,1),(4,1,1,2,NULL,1,3,'Parallélogramme repose-pieds JP','1H703140 009 JP BN','JP2000300610','1999-04-15 00:00:00','1999-03-10 00:00:00','2000-10-31 00:00:00','2007-09-21 00:00:00',NULL,NULL,NULL,'JP11107802','do not know','patent',4,5,1,1),(5,1,1,2,NULL,1,5,'Parallélogramme repose-pieds US','1H703140 0009 US BN','US6192533','1999-04-02 00:00:00','1999-03-10 00:00:00','1999-04-14 00:00:00','2001-02-27 00:00:00',NULL,NULL,NULL,'US09283997','do not know','patent',2,3,1,1),(6,1,1,2,NULL,NULL,6,'Profondeur d\'assise','1H703140 0010 FR BN','FR2769831','1997-10-22 00:00:00','1997-10-22 00:00:00','1999-04-23 00:00:00','2000-01-21 00:00:00',NULL,NULL,NULL,'FR9713459','do not know','patent',1,12,6,0),(7,1,1,2,NULL,6,1,'Profondeur d\'assise DE','1H703140 0010 DE BN','DE19912830','1999-03-22 00:00:00','1997-10-22 00:00:00','2000-09-28 00:00:00','2004-03-11 00:00:00',NULL,NULL,NULL,'DE19912830','do not know','patent',10,11,6,1),(8,1,1,2,NULL,6,2,'Profondeur d\'assise GB','1H703140 0010 GB BN','GB2348364','1999-04-01 00:00:00','1997-10-22 00:00:00','2000-10-04 00:00:00','2003-06-25 00:00:00',NULL,NULL,NULL,'GB9907729','do not know','patent',8,9,6,1),(9,1,1,2,NULL,6,3,'Profondeur d\'assise JP','1H703140 0010 JP BN','JP2000300385','1999-04-15 00:00:00','1997-10-22 00:00:00','2000-10-31 00:00:00','2007-03-30 00:00:00',NULL,NULL,NULL,'JP11107804','do not know','patent',6,7,6,1),(10,1,1,2,NULL,6,4,'Profondeur d\'assise SE','1H703140 0010 SE BN','SE520852','1999-03-10 00:00:00','1997-10-22 00:00:00','2000-09-11 00:00:00','2003-09-02 00:00:00',NULL,NULL,NULL,'SE9900844','do not know','patent',4,5,6,1),(11,1,1,2,NULL,6,5,'Profondeur d\'assise US','1H703140 0010 US BN','US09283745','1999-04-02 00:00:00','1997-10-22 00:00:00','2001-06-11 00:00:00','2001-06-12 00:00:00',NULL,NULL,NULL,'US19990283745','do not know','patent',2,3,6,1),(12,1,1,2,NULL,NULL,6,'Noix d\'accoudoir','1H717960 011 FR BN','FR2779945','1998-06-23 00:00:00','1998-06-23 00:00:00','1999-12-24 00:00:00','2000-11-10 00:00:00',NULL,NULL,NULL,'FR9808107','do not know','patent',1,12,12,0),(13,1,1,2,NULL,12,7,'Noix d\'accoudoir CA','1H703140 0012 CA BN','CA2275977','1999-06-22 00:00:00','1998-06-23 00:00:00','1999-12-23 00:00:00','2003-05-06 00:00:00',NULL,NULL,NULL,'CA2275977','do not know','patent',10,11,12,1),(14,1,1,2,NULL,12,1,'Noix d\'accoudoir DE','1H703140 0012 DE BN','DE19927244','1999-06-15 00:00:00','1998-06-23 00:00:00','1999-12-29 00:00:00','1999-12-30 00:00:00',NULL,NULL,NULL,'DE19991027244','do not know','patent',8,9,12,1),(15,1,1,2,NULL,12,2,'Noix d\'accoudoir GB','1H703140 0012 GB BN','GB2339450','1999-06-18 00:00:00','1998-06-23 00:00:00','2000-12-26 00:00:00','2002-11-27 00:00:00',NULL,NULL,NULL,'GB9914134','do not know','patent',6,7,12,1),(16,1,1,2,NULL,12,4,'Noix d\'accoudoir SE','1H703140 0012 SE BN','SE9902382A','1999-06-23 00:00:00','1998-06-23 00:00:00','1999-12-24 00:00:00','2003-12-16 00:00:00',NULL,NULL,NULL,'SE9902382','do not know','patent',4,5,12,1),(17,1,1,2,NULL,12,5,'Noix d\'accoudoir US','1H703140 0012 US','US6250717','1999-06-23 00:00:00','1998-06-23 00:00:00','2001-06-25 00:00:00','2001-06-26 00:00:00',NULL,NULL,NULL,'US09338498','do not know','patent',2,3,12,1),(18,1,1,2,NULL,NULL,6,'Genouillère ergonomique','1H17960 0012 FR BN','FR2813520','2000-09-07 00:00:00','2000-09-07 00:00:00','2002-03-08 00:00:00','2002-12-06 00:00:00',NULL,NULL,NULL,'FR0011415','do not know','patent',1,10,18,0),(19,1,1,2,NULL,18,1,'Genouillère ergonomique DE','1H703140 0013 DE BN','DE10143977','2001-09-07 00:00:00','2000-09-07 00:00:00','2002-06-06 00:00:00','2012-09-20 00:00:00',NULL,NULL,NULL,'DE10143977','do not know','patent',8,9,18,1),(20,1,1,2,NULL,18,2,'Genouillère ergonomique GB','1H703140 0013 GB BN','GB2369300','2001-09-07 00:00:00','2000-09-07 00:00:00','2002-05-29 00:00:00','2004-05-05 00:00:00',NULL,NULL,NULL,'GB0121706','do not know','patent',6,7,18,1),(21,1,1,2,NULL,18,8,'Genouillère ergonomique NO','1H703140 0013 NO BN','NO20014337','2001-09-06 00:00:00','2000-09-07 00:00:00','2002-03-08 00:00:00','2008-07-21 00:00:00',NULL,NULL,NULL,'NO20014337','do not know','patent',4,5,18,1),(22,1,1,2,NULL,18,5,'Genouillère ergonomique US','1H703140 0013 US BN','US2002027334','2001-09-06 00:00:00','2000-09-07 00:00:00','2002-03-07 00:00:00','2003-08-05 00:00:00',NULL,NULL,NULL,'US09946455','do not know','patent',2,3,18,1),(23,1,1,2,NULL,NULL,6,'Parallélogramme repose-pieds FR','1H717960 0009 FR BN','FR2769830','1997-10-22 00:00:00','1997-10-22 00:00:00','1999-04-23 00:00:00','2000-02-11 00:00:00',NULL,NULL,NULL,'FR9713458','do not know','patent',1,2,23,0),(24,1,1,2,NULL,NULL,6,'Verrouillage centralisé et indexé','1H717960 0013 FR BN','FR2813524','2000-09-07 00:00:00','2000-09-07 00:00:00','2002-03-08 00:00:00','2002-12-06 00:00:00',NULL,NULL,NULL,'FR0011412','do not know','patent',1,8,24,0),(25,1,1,2,NULL,24,1,'Verrouillage centralisé et indexé DE','1H703140 0014 DE BN','DE10143971','2001-09-07 00:00:00','2000-09-07 00:00:00','2002-05-02 00:00:00','2012-01-19 00:00:00',NULL,NULL,NULL,'DE10143971','do not know','patent',6,7,24,1),(26,1,1,2,NULL,24,4,'Verrouillage centralisé et indexé SE','1H703140 0014 SE BN','SE200102972','2001-09-07 00:00:00','2000-09-07 00:00:00','2002-03-08 00:00:00','2003-11-11 00:00:00',NULL,NULL,NULL,'SE01029727','do not know','patent',4,5,24,1),(27,1,1,2,NULL,24,5,'Verrouillage centralisé et indexé US','1H703140 0014 US BN','US2002027385','2001-09-06 00:00:00','2000-09-07 00:00:00','2002-03-07 00:00:00','2003-05-27 00:00:00',NULL,NULL,NULL,'US09946813','do not know','patent',2,3,24,1),(28,1,1,2,NULL,NULL,6,'Transfert par gravité','1H703140 0015 FR BN','FR2833481','2001-12-13 00:00:00','2001-12-13 00:00:00','2003-06-20 00:00:00','2004-03-12 00:00:00','2009-08-31 00:00:00',NULL,NULL,'FR0116150','do not know','patent',1,8,28,0),(29,1,1,2,NULL,28,5,'Transfert par gravité US','1H703140 0015 US BN','US2003110561','2002-12-12 00:00:00','2001-12-13 00:00:00','2003-06-19 00:00:00','2004-06-01 00:00:00',NULL,NULL,NULL,'US10317057','do not know','patent',6,7,28,1),(30,1,1,2,NULL,28,9,'Transfert par gravité EP','1H703140 0015 EP OEB','EP1319383','2002-12-11 00:00:00','2001-12-13 00:00:00','2003-06-18 00:00:00','2007-04-25 00:00:00',NULL,NULL,NULL,'EP1319383','do not know','patent',2,5,28,1),(31,1,1,2,NULL,30,6,'Transfert par gravité EP FR','1H17960 0014 FR OEB','EPFR1319383','2002-12-11 00:00:00','2001-12-13 00:00:00','2003-06-18 00:00:00','2007-04-25 00:00:00',NULL,NULL,NULL,'EPFR1319383','do not know','patent',3,4,28,2),(32,1,1,2,NULL,NULL,6,'Réglage inclinaison repose-pieds','1H717960 0015 FR BN','FR2890855','2005-09-20 00:00:00','2005-09-20 00:00:00','2007-03-23 00:00:00','2007-12-14 00:00:00',NULL,NULL,NULL,'FR0509588','do not know','patent',1,20,32,0),(33,1,1,2,NULL,32,9,'Réglage inclinaison repose-pieds EP','1H703140 0016 EP OEB','EP1764070','2006-09-14 00:00:00','2005-09-20 00:00:00','2007-03-21 00:00:00','2012-11-07 00:00:00',NULL,NULL,NULL,'EP1764070','do not know','patent',4,19,32,1),(34,1,1,2,NULL,33,10,'Réglage inclinaison repose-pieds AT','1H703140 0016 AT OEB','EPAT1764070','2006-09-14 00:00:00','2005-09-20 00:00:00','2007-03-21 00:00:00','2012-11-07 00:00:00',NULL,NULL,NULL,'EPAT1764070','do not know','patent',17,18,32,2),(35,1,1,2,NULL,33,11,'Réglage inclinaison repose-pieds BE','1H703140 0016 BE OEB','EPBE1764070','2006-09-14 00:00:00','2005-09-20 00:00:00','2007-03-21 00:00:00','2012-11-07 00:00:00',NULL,NULL,NULL,'EPBE1764070','do not know','patent',15,16,32,2),(36,1,1,2,NULL,33,12,'Réglage inclinaison repose-pieds CH','1H703140 0016 CH OEB','EPCH1764070','2006-09-14 00:00:00','2005-09-20 00:00:00','2007-03-21 00:00:00','2012-11-07 00:00:00',NULL,NULL,NULL,'EPCH1764070','do not know','patent',13,14,32,2),(37,1,1,2,NULL,33,1,'Réglage inclinaison repose-pieds DE','1H703140 0016 DE OEB','EPDE1764070','2006-09-14 00:00:00','2005-09-20 00:00:00','2007-03-21 00:00:00','2012-11-07 00:00:00',NULL,NULL,NULL,'EPDE1764070','do not know','patent',11,12,32,2),(38,1,1,2,NULL,33,6,'Réglage inclinaison repose-pieds FR','1H703140 0016 FR OEB','EPFR1764070','2006-09-14 00:00:00','2005-09-20 00:00:00','2007-03-21 00:00:00','2012-11-07 00:00:00',NULL,NULL,NULL,'EPFR1764070','do not know','patent',9,10,32,2),(39,1,1,2,NULL,33,2,'Réglage inclinaison repose-pieds GB','1H703140 0016 GB OEB','EPGB1764070','2006-09-14 00:00:00','2005-09-20 00:00:00','2007-03-21 00:00:00','2012-11-07 00:00:00',NULL,NULL,NULL,'EPGB1764070','do not know','patent',7,8,32,2),(40,1,1,2,NULL,33,4,'Réglage inclinaison repose-pieds SE','1H703140 0016 SE OEB','EPSE1764070','2006-09-14 00:00:00','2005-09-20 00:00:00','2007-03-21 00:00:00','2012-12-07 00:00:00',NULL,NULL,NULL,'EPSE1764070','do not know','patent',5,6,32,2),(41,1,1,2,NULL,32,5,'Réglage inclinaison repose-pieds US','1H703140 0016 US BN','US7815209','2006-09-19 00:00:00','2005-09-20 00:00:00','2007-03-22 00:00:00','2010-10-19 00:00:00',NULL,NULL,NULL,'US11523065','do not know','patent',2,3,32,1),(42,1,1,2,NULL,NULL,6,'Fauteuil multipositions pour handicapés','1H703140 0017','WO2006FR50288','2006-04-03 00:00:00','2006-04-03 00:00:00','2007-10-11 00:00:00','2012-05-02 00:00:00',NULL,NULL,NULL,'FR06726299','do not know','patent',1,14,42,0),(43,1,1,2,NULL,42,13,'Fauteuil multipositions pour handicapés PCT','1H703 0017 PCT','WO07113395','2006-04-03 00:00:00','2006-04-03 00:00:00','2007-10-11 00:00:00',NULL,NULL,NULL,NULL,'WO06726299','do not know','patent',2,13,42,1),(44,1,1,2,NULL,43,12,'Fauteuil multipositions pour handicapés CH','1H703140 0017 CH','CH06726299','2006-04-03 00:00:00','2006-04-03 00:00:00','2007-10-11 00:00:00','2012-05-02 00:00:00',NULL,NULL,NULL,'CH06726299','do not know','patent',11,12,42,2),(45,1,1,2,NULL,43,1,'Fauteuil multipositions pour handicapés DE','1H703140 0017 DE','DE06726299','2006-04-03 00:00:00','2006-04-03 00:00:00','2007-10-11 00:00:00','2012-05-02 00:00:00',NULL,NULL,NULL,'DE06726299','do not know','patent',9,10,42,2),(46,1,1,2,NULL,43,2,'Fauteuil multipositions pour handicapés GB','1H703140 0017 GB','GB06726299','2006-04-03 00:00:00','2006-04-03 00:00:00','2007-10-11 00:00:00','2012-05-02 00:00:00',NULL,NULL,NULL,'GB06726299','do not know','patent',7,8,42,2),(47,1,1,2,NULL,43,14,'Fauteuil multipositions pour handicapés IN','1H703140 0017 IN','IN08300DN2008','2006-04-03 00:00:00','2006-04-03 00:00:00','2009-06-12 00:00:00',NULL,NULL,NULL,NULL,'IN8300DELNP2008','do not know','patent',5,6,42,2),(48,1,1,2,NULL,43,5,'Fauteuil multipositions pour handicapés US','1H703140 0017 US','US2009218784','2006-04-03 00:00:00','2006-04-03 00:00:00','2009-09-03 00:00:00','2012-03-06 00:00:00',NULL,NULL,NULL,'US12225866','do not know','patent',3,4,42,2),(49,1,1,2,NULL,NULL,6,'Multipositions mono-vérin','1H717960 0016 FR BN','FR2901997','2006-06-07 00:00:00','2006-06-07 00:00:00','2007-12-14 00:00:00','2009-05-15 00:00:00',NULL,NULL,NULL,'FR0652050','do not know','patent',1,18,49,0),(50,1,1,2,NULL,49,9,'Multipositions mono-vérin EP','1H703140 0018 EP OEB','EP1864637','2007-06-01 00:00:00','2006-06-07 00:00:00','2007-12-12 00:00:00','2011-01-12 00:00:00',NULL,NULL,NULL,'EP07109387','do not know','patent',8,17,49,1),(51,1,1,2,NULL,50,12,'Multipositions mono-vérin CH','1H703140 0018 CH OEB','CH07109387','2007-06-01 00:00:00','2006-06-07 00:00:00','2007-12-12 00:00:00','2011-01-12 00:00:00',NULL,NULL,NULL,'CH07109387','do not know','patent',15,16,49,2),(52,1,1,2,NULL,50,1,'Multipositions mono-vérin DE','1H703140 0018 DE OEB','DE602007011848','2007-06-01 00:00:00','2006-06-07 00:00:00','2007-12-12 00:00:00','2011-01-12 00:00:00',NULL,NULL,NULL,'DE07109387','do not know','patent',13,14,49,2),(53,1,1,2,NULL,50,6,'Multipositions mono-vérin FR','1H703140 0018 FR OEB','FR07109387','2007-06-01 00:00:00','2006-06-07 00:00:00','2007-12-12 00:00:00','2011-01-12 00:00:00',NULL,NULL,NULL,'FR07109387','do not know','patent',11,12,49,2),(54,1,1,2,NULL,50,2,'Multipositions mono vérin GB','1H703140 0018 GB OEB','GB07109387','2007-06-01 00:00:00','2006-06-07 00:00:00','2007-12-12 00:00:00','2011-01-12 00:00:00',NULL,NULL,NULL,'GB07109387','do not know','patent',9,10,49,2),(55,1,1,2,NULL,49,15,'Multipositions moni-vérin CN','1H703140 0018 CN BN','CN101103946','2007-06-07 00:00:00','2006-06-07 00:00:00','2008-01-16 00:00:00','2011-06-01 00:00:00',NULL,NULL,NULL,'CN200710138809','do not know','patent',6,7,49,1),(56,1,1,2,NULL,49,14,'Multipositions mono-vérin IN','1H703140 0018 IN BN','IN01224DE2007','2007-06-06 00:00:00','2006-06-07 00:00:00','2007-12-14 00:00:00',NULL,NULL,NULL,NULL,'IN1224DEL2007','do not know','patent',4,5,49,1),(57,1,1,2,NULL,49,5,'Multipositions mono-vérin US','1H703140 0018 US BN','US2007296177','2007-06-05 00:00:00','2006-06-07 00:00:00','2007-12-27 00:00:00','2010-08-31 00:00:00',NULL,NULL,NULL,'US11806951','do not know','patent',2,3,49,1),(58,1,1,2,NULL,NULL,6,'Rétro-déplacement verticalisation','1H703140 008 FR','FR2717377','1994-03-18 00:00:00','1994-03-18 00:00:00','1995-09-22 00:00:00','1996-06-21 00:00:00','2014-03-18 00:00:00',NULL,NULL,'FR9403439','do not know','patent',1,12,58,0),(59,1,1,2,NULL,58,9,'Rétro-déplacement verticalisation EP','1H703140 008 EP OEB','EP0699067','1995-03-17 00:00:00','1994-03-18 00:00:00','1996-03-06 00:00:00','1998-09-16 00:00:00','2015-03-17 00:00:00',NULL,NULL,'EP95913214','do not know','patent',2,11,58,1),(60,1,1,2,NULL,59,12,'Rétro-déplacement verticalisation CH','1H703140 008  CH OEB','CH915913214','1995-03-17 00:00:00','1994-03-18 00:00:00','1996-03-06 00:00:00','1998-09-16 00:00:00','2015-03-17 00:00:00',NULL,NULL,'CH915913214','do not know','patent',9,10,58,2),(61,1,1,2,NULL,59,4,'Rétro-déplacement verticalisation SE','1H703140 008 SE OEB','SE95913214','1995-03-17 00:00:00','1994-03-18 00:00:00','1996-03-06 00:00:00','1998-09-16 00:00:00','2015-03-17 00:00:00',NULL,NULL,'SE915913214','do not know','patent',7,8,58,2),(62,1,1,2,NULL,59,2,'Rétro-déplacement verticalisation GB','1H703140 008 GB OEB','GB95913214','1995-03-17 00:00:00','1994-03-18 00:00:00','1996-06-03 00:00:00','1998-09-16 00:00:00','2015-03-17 00:00:00',NULL,NULL,'GB95913214','do not know','patent',5,6,58,2),(63,1,1,2,NULL,59,1,'Rétro-déplacement verticalisation DE','1H703140 008 DE OEB','DE95913214','1995-03-17 00:00:00','1994-03-18 00:00:00','1996-03-06 00:00:00','1998-09-16 00:00:00','2015-03-17 00:00:00',NULL,NULL,'DE95913214','do not know','patent',3,4,58,2),(64,1,1,2,NULL,NULL,6,'Garde au sol variable','1H717960 001 FR BN','FR2915091','2007-04-20 00:00:00','2007-04-20 00:00:00','2008-10-24 00:00:00','2009-07-24 00:00:00',NULL,NULL,NULL,'FR0754602','do not know','patent',1,6,64,0),(65,1,1,2,NULL,64,15,'Garde au sol variable CN','1H717960 0001 CN BN','CN101288616','2007-06-27 00:00:00','2007-04-20 00:00:00','2008-10-24 00:00:00','2013-01-02 00:00:00',NULL,NULL,NULL,'CN200710112698','do not know','patent',4,5,64,1),(66,1,1,2,NULL,64,1,'Garde au sol variable DE','1H717960 0001 DE BN','DE102008019832','2008-04-19 00:00:00','2007-04-20 00:00:00','2008-10-30 00:00:00','2015-11-15 00:00:00',NULL,NULL,NULL,'DE102008019832','do not know','patent',2,3,64,1),(67,1,1,2,NULL,NULL,6,'Poignée multiprises','1H717960 002 FR BN','FR2856486','2003-06-19 00:00:00','2003-06-19 00:00:00','2004-12-24 00:00:00','2005-11-04 00:00:00',NULL,NULL,NULL,'FR0307408','do not know','patent',1,2,67,0),(68,1,1,2,NULL,NULL,6,'Poignée réglable en profondeur','1H717960 003 FR BN','FR2856280','2003-06-19 00:00:00','2003-06-19 00:00:00','2004-12-24 00:00:00','2006-02-10 00:00:00',NULL,NULL,NULL,'FR0307409','do not know','patent',1,4,68,0),(69,1,1,2,NULL,68,1,'Poignée réglable en profondeur DE','1H717960 003 DE BN','DE102004029399','2004-06-19 00:00:00','2003-06-19 00:00:00','2005-01-20 00:00:00',NULL,NULL,NULL,NULL,'DE102004029399','do not know','patent',2,3,68,1),(70,1,1,2,NULL,NULL,6,'Poignée débrayable','1H717960 0004 FR BN','FR2856281','2003-06-19 00:00:00','2003-06-19 00:00:00','2004-12-24 00:00:00','2006-02-17 00:00:00',NULL,NULL,NULL,'FR0307410','do not know','patent',1,2,70,0),(71,1,1,2,NULL,NULL,6,'Inclinaison dossier dynamique','1H717960 FR BN','FR2856282','2003-06-19 00:00:00','2003-06-19 00:00:00','2004-12-24 00:00:00','2006-02-17 00:00:00',NULL,NULL,NULL,'FR0307412','do not know','patent',1,12,71,0),(72,1,1,2,NULL,71,9,'Inclinaison dossier dynamique EP','1H717960 0005 EP OEB','EP04356101','2004-06-17 00:00:00','2003-06-19 00:00:00','2004-12-22 00:00:00','2011-08-24 00:00:00',NULL,NULL,NULL,'EP04356101','do not know','patent',2,11,71,1),(73,1,1,2,NULL,72,12,'Inclinaison dossier dynamique CH','1H717960 0005 CH OEB','CH04356101','2004-06-17 00:00:00','2003-06-19 00:00:00','2004-12-22 00:00:00','2011-08-24 00:00:00',NULL,NULL,NULL,'CH04356101','do not know','patent',9,10,71,2),(74,1,1,2,NULL,72,1,'Inclinaison dossier dynamique DE','1H717960 0005 DE OEB','DE04356101','2004-06-17 00:00:00','2003-06-19 00:00:00','2004-12-22 00:00:00','2011-08-24 00:00:00',NULL,NULL,NULL,'DE04356101','do not know','patent',7,8,71,2),(75,1,1,2,NULL,72,6,'Inclinaison dossier dynamique FR','1H717960 0005 FR OEB','FR04356101','2004-06-17 00:00:00','2003-06-19 00:00:00','2004-12-24 00:00:00','2011-08-24 00:00:00',NULL,NULL,NULL,'FR04356101','do not know','patent',5,6,71,2),(76,1,1,2,NULL,72,2,'Inclinaison dossier dynamique GB','1H717960 0005 GB OEB','GB04356101','2004-06-17 00:00:00','2003-06-19 00:00:00','2004-12-22 00:00:00','2011-08-24 00:00:00',NULL,NULL,NULL,'GB04356101','do not know','patent',3,4,71,2),(77,1,1,2,NULL,NULL,6,'Genouillère amovible','1H717960 0006','FR2856279','2003-06-19 00:00:00','2003-06-19 00:00:00','2004-12-24 00:00:00','2006-02-17 00:00:00',NULL,NULL,NULL,'FR0307413','do not know','patent',1,12,77,0),(78,1,1,2,NULL,77,9,'Genouillère amovible EP','1H717960 006 EP OEB','EP1488769','2004-06-17 00:00:00','2003-06-19 00:00:00','2004-12-22 00:00:00','2012-01-11 00:00:00',NULL,NULL,NULL,'EP04356100','do not know','patent',2,11,77,1),(79,1,1,2,NULL,78,12,'Genouillère amovible CH','1H717960 006 CH OEB','CH04356100','2004-06-17 00:00:00','2003-06-19 00:00:00','2004-12-22 00:00:00','2012-01-11 00:00:00',NULL,NULL,NULL,'CH04356100','do not know','patent',9,10,77,2),(80,1,1,2,NULL,78,1,'Genouillère amovible DE','1H717960 0006 DE OEB','DE04356100','2004-06-17 00:00:00','2003-06-19 00:00:00','2004-12-22 00:00:00','2012-01-11 00:00:00',NULL,NULL,NULL,'DE04356100','do not know','patent',7,8,77,2),(81,1,1,2,NULL,78,6,'Genouillère amovible FR','1H717960 0006 FR OEB','FR04356100','2004-06-17 00:00:00','2003-06-19 00:00:00','2004-12-22 00:00:00','2012-01-11 00:00:00',NULL,NULL,NULL,'FR04356100','do not know','patent',5,6,77,2),(82,1,1,2,NULL,78,2,'Genouillère amovible GB','1H717960 GB OEB','GB04356100','2004-06-17 00:00:00','2003-06-19 00:00:00','2004-12-22 00:00:00','2012-01-11 00:00:00',NULL,NULL,NULL,'GB0436100','do not know','patent',3,4,77,2),(83,1,1,2,NULL,NULL,6,'Démultiplication poignée','1H717960 007 FR OEB','FR2870451','2004-05-24 00:00:00','2004-05-24 00:00:00','2005-11-25 00:00:00','2006-08-18 00:00:00','2011-02-18 00:00:00',NULL,NULL,'FR0405578','do not know','patent',1,6,83,0),(84,1,1,2,NULL,83,9,'Démultiplication poignée EP','1H717960 EP OEB','EP1600134','2005-05-20 00:00:00','2004-05-24 00:00:00','2005-11-30 00:00:00','2008-10-22 00:00:00',NULL,NULL,NULL,'EP05356092','do not know','patent',2,5,83,1),(85,1,1,2,NULL,84,6,'Démultiplications poignée FR','1H17960 007 FR OEB','FR05356092','2005-05-20 00:00:00','2004-05-24 00:00:00','2005-11-30 00:00:00','2008-10-22 00:00:00',NULL,NULL,NULL,'FR05356092','do not know','patent',3,4,83,2),(86,3,3,NULL,NULL,NULL,6,'Z-PLUS FR',NULL,'3004212','2013-04-04 00:00:00','2013-04-04 00:00:00','2014-10-10 00:00:00','2015-04-10 00:00:00',NULL,NULL,NULL,'1353053','do not know','patent',1,38,86,0),(87,3,3,NULL,NULL,86,9,'Z-PLUS EP',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 EP','do not know','patent',2,37,86,1),(88,3,3,NULL,NULL,87,6,'Z-PLUS EP-FR',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 FR','do not know','patent',35,36,86,2),(89,3,3,NULL,NULL,87,10,'Z-PLUS AT',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 AT','do not know','patent',33,34,86,2),(90,3,3,NULL,NULL,87,11,'Z-PLUS BE',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 BE','do not know','patent',31,32,86,2),(91,3,3,NULL,NULL,87,12,'Z-PLUS CH',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 CH','do not know','patent',29,30,86,2),(92,3,3,NULL,NULL,87,16,'Z-PLUS CZ',NULL,'2799657','2014-03-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 CZ','do not know','patent',27,28,86,2),(93,3,3,NULL,NULL,87,1,'Z-PLUS DE',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758','do not know','patent',25,26,86,2),(94,3,3,NULL,NULL,87,17,'Z-PLUS DK',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 DK','do not know','patent',23,24,86,2),(95,3,3,NULL,NULL,87,18,'Z-PLUS EP-ES',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 ES','do not know','patent',21,22,86,2),(96,3,3,NULL,NULL,87,19,'Z-PLUS EP-FI',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 FI','do not know','patent',19,20,86,2),(97,3,3,NULL,NULL,87,2,'Z-PLUS EP-GB',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 GB','do not know','patent',17,18,86,2),(98,3,3,NULL,NULL,87,20,'Z-PLUS EP-IT',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 IT','do not know','patent',15,16,86,2),(99,3,3,NULL,NULL,87,21,'Z-PLUS EP-NL',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 NL','do not know','patent',13,14,86,2),(100,3,3,NULL,NULL,87,8,'Z-PLUS EP NO',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 EP-NO','do not know','patent',11,12,86,2),(101,3,3,NULL,NULL,87,22,'Z-PLUS EP-PL',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 PL','do not know','patent',9,10,86,2),(102,3,3,NULL,NULL,87,23,'Z-PLUS EP-PT',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 PT','do not know','patent',7,8,86,2),(103,3,3,NULL,NULL,87,4,'Z-PLUS EP-SE',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 SE','do not know','patent',5,6,86,2),(104,3,3,NULL,NULL,87,24,'Z-PLUS EP-TR',NULL,'2799657','2014-04-03 00:00:00','2013-04-04 00:00:00','2014-11-05 00:00:00','2015-08-12 00:00:00',NULL,NULL,NULL,'141634758 TR','do not know','patent',3,4,86,2),(105,3,3,NULL,NULL,NULL,6,'Anti-condensation FR',NULL,NULL,'2015-03-27 00:00:00','2015-03-27 00:00:00',NULL,NULL,NULL,NULL,NULL,'1552590 FR','do not know','patent',1,2,105,0),(106,3,3,NULL,NULL,NULL,6,'Fil en étoile FR',NULL,NULL,'2015-09-25 00:00:00','2015-09-25 00:00:00',NULL,NULL,NULL,NULL,NULL,'1570045 FR','do not know','patent',1,2,106,0),(107,4,4,NULL,NULL,NULL,5,'brevet',NULL,NULL,'2016-06-06 00:00:00','2016-06-06 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'do not know','patent',1,12,107,0),(108,4,4,NULL,NULL,107,15,'brevet2',NULL,NULL,'2016-06-06 00:00:00','2016-06-06 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'do not know','patent',10,11,107,1),(109,4,4,NULL,NULL,107,9,'brevet4',NULL,NULL,'2016-06-06 00:00:00','2016-06-06 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'do not know','patent',8,9,107,1),(110,4,4,NULL,NULL,107,14,'brevet3',NULL,NULL,'2016-06-06 00:00:00','2016-06-06 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'do not know','patent',6,7,107,1),(111,4,4,NULL,NULL,107,3,'brevet5',NULL,NULL,'2016-06-06 00:00:00','2016-06-06 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'do not know','patent',4,5,107,1),(112,4,4,NULL,NULL,107,7,'brevet6',NULL,NULL,'2016-06-06 00:00:00','2016-06-06 00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,'do not know','patent',2,3,107,1),(113,5,5,NULL,NULL,NULL,5,'Method of producing a patient-specific three dimensional model','Etude Medicrea 1','US2014272881','2014-03-10 00:00:00','2014-03-10 00:00:00','2014-09-18 00:00:00',NULL,NULL,NULL,NULL,'2014US-14202428','do not know','patent',1,4,113,0),(114,5,5,NULL,NULL,113,13,'Method of producing a patient-specific three dimensional model PCT','Etude Medicrea 1 PCT','WO2014159191','2014-03-10 00:00:00','2014-03-10 00:00:00','2014-10-02 00:00:00',NULL,NULL,NULL,NULL,'2014WO-US22444','do not know','patent',2,3,113,1);
/*!40000 ALTER TABLE `abstract_patent` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `annuity`
--

DROP TABLE IF EXISTS `annuity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `annuity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `application_zone_id` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_number_idx` (`application_zone_id`,`number`),
  KEY `IDX_DD3CEA4274923A98` (`application_zone_id`),
  CONSTRAINT `FK_DD3CEA4274923A98` FOREIGN KEY (`application_zone_id`) REFERENCES `application_zone` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=206 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `annuity`
--

LOCK TABLES `annuity` WRITE;
/*!40000 ALTER TABLE `annuity` DISABLE KEYS */;
INSERT INTO `annuity` VALUES (108,1,3),(109,1,4),(110,1,5),(111,1,6),(112,1,7),(113,1,8),(114,1,9),(115,1,10),(116,1,11),(117,1,12),(118,1,13),(119,1,14),(120,1,15),(121,1,16),(122,1,17),(123,1,18),(124,1,19),(125,1,20),(126,2,5),(127,2,6),(128,2,7),(129,2,8),(130,2,9),(131,2,10),(132,2,11),(133,2,12),(134,2,13),(135,2,14),(136,2,15),(137,2,16),(138,2,17),(139,2,18),(140,2,19),(141,2,20),(142,3,1),(143,3,2),(144,3,3),(145,3,4),(146,3,5),(147,3,6),(148,3,7),(149,3,8),(150,3,9),(151,3,10),(152,3,11),(153,3,12),(154,3,13),(155,3,14),(156,3,15),(157,3,16),(158,3,17),(159,3,18),(160,3,19),(161,3,20),(162,3,21),(163,3,22),(164,3,23),(165,3,24),(166,3,25),(185,4,3),(186,4,4),(187,4,5),(188,4,6),(189,4,7),(190,4,8),(191,4,9),(192,4,10),(193,4,11),(194,4,12),(195,4,13),(196,4,14),(197,4,15),(198,4,16),(199,4,17),(200,4,18),(201,4,19),(202,4,20),(203,5,1),(204,5,2),(205,5,3),(1,6,2),(2,6,3),(3,6,4),(4,6,5),(5,6,6),(6,6,7),(7,6,8),(8,6,9),(9,6,10),(10,6,11),(11,6,12),(12,6,13),(14,6,14),(15,6,15),(16,6,16),(17,6,17),(18,6,18),(19,6,19),(20,6,20),(70,7,3),(71,7,4),(72,7,5),(73,7,6),(74,7,7),(75,7,8),(76,7,9),(77,7,10),(78,7,11),(79,7,12),(80,7,13),(81,7,14),(82,7,15),(83,7,16),(84,7,17),(85,7,18),(86,7,19),(87,7,20),(167,8,3),(168,8,4),(169,8,5),(170,8,6),(171,8,7),(172,8,8),(173,8,9),(174,8,10),(175,8,11),(176,8,12),(177,8,13),(178,8,14),(179,8,15),(180,8,16),(181,8,17),(182,8,18),(183,8,19),(184,8,20),(21,10,6),(22,10,7),(23,10,8),(24,10,9),(25,10,10),(26,10,11),(27,10,12),(28,10,13),(29,10,14),(30,10,15),(31,10,16),(32,10,17),(33,10,18),(34,10,19),(35,10,20),(53,11,3),(54,11,4),(55,11,5),(56,11,6),(57,11,7),(58,11,8),(59,11,9),(60,11,10),(61,11,11),(62,11,12),(63,11,13),(64,11,14),(65,11,15),(66,11,16),(67,11,18),(68,11,19),(69,11,20),(36,12,5),(37,12,6),(38,12,7),(39,12,8),(40,12,9),(41,12,10),(42,12,11),(43,12,12),(44,12,13),(45,12,14),(46,12,15),(47,12,16),(48,12,17),(49,12,18),(50,12,19),(52,12,20),(88,15,1),(89,15,2),(90,15,3),(91,15,4),(92,15,5),(93,15,6),(94,15,7),(95,15,8),(96,15,9),(97,15,10),(98,15,11),(99,15,12),(100,15,13),(101,15,14),(102,15,15),(103,15,16),(104,15,17),(105,15,18),(106,15,19),(107,15,20);
/*!40000 ALTER TABLE `annuity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `annuity_amount`
--

DROP TABLE IF EXISTS `annuity_amount`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `annuity_amount` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `annuity_id` int(11) NOT NULL,
  `amount` double NOT NULL,
  `applied_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_amount_idx` (`applied_at`,`annuity_id`,`amount`),
  KEY `IDX_A336FFB69EA1FBA2` (`annuity_id`),
  CONSTRAINT `FK_A336FFB69EA1FBA2` FOREIGN KEY (`annuity_id`) REFERENCES `annuity` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `annuity_amount`
--

LOCK TABLES `annuity_amount` WRITE;
/*!40000 ALTER TABLE `annuity_amount` DISABLE KEYS */;
INSERT INTO `annuity_amount` VALUES (1,1,38,'9999-01-01 00:00:00'),(2,2,38,'9999-01-01 00:00:00'),(3,3,38,'9999-01-01 00:00:00'),(4,4,38,'9999-01-01 00:00:00'),(5,5,76,'9999-01-01 00:00:00'),(6,6,96,'9999-01-01 00:00:00'),(7,7,136,'9999-01-01 00:00:00'),(8,8,180,'9999-01-01 00:00:00'),(9,9,220,'9999-01-01 00:00:00'),(10,10,260,'9999-01-01 00:00:00'),(11,11,300,'9999-01-01 00:00:00'),(12,12,350,'9999-01-01 00:00:00'),(13,14,400,'9999-01-01 00:00:00'),(14,15,450,'9999-01-01 00:00:00'),(15,16,510,'9999-01-01 00:00:00'),(16,17,570,'9999-01-01 00:00:00'),(17,18,640,'9999-01-01 00:00:00'),(18,19,720,'9999-01-01 00:00:00'),(19,20,790,'9999-01-01 00:00:00'),(20,21,104,'9999-01-01 00:00:00'),(21,22,208,'9999-01-01 00:00:00'),(22,23,313,'9999-01-01 00:00:00'),(23,24,417,'9999-01-01 00:00:00'),(24,25,522,'9999-01-01 00:00:00'),(25,26,626,'9999-01-01 00:00:00'),(26,27,731,'9999-01-01 00:00:00'),(27,28,835,'9999-01-01 00:00:00'),(28,29,940,'9999-01-01 00:00:00'),(29,30,1044,'9999-01-01 00:00:00'),(30,31,1148,'9999-01-01 00:00:00'),(31,32,1253,'9999-01-01 00:00:00'),(32,33,1357,'9999-01-01 00:00:00'),(33,34,1566,'9999-01-01 00:00:00'),(34,35,1775,'9999-01-01 00:00:00'),(35,36,136.12,'9999-01-01 00:00:00'),(36,37,181.49,'9999-01-01 00:00:00'),(37,38,226.86,'9999-01-01 00:00:00'),(38,39,272.23,'9999-01-01 00:00:00'),(39,40,317.6,'9999-01-01 00:00:00'),(40,41,362.97,'9999-01-01 00:00:00'),(41,42,408.35,'9999-01-01 00:00:00'),(42,43,453.72,'9999-01-01 00:00:00'),(43,44,499.09,'9999-01-01 00:00:00'),(44,45,544.46,'9999-01-01 00:00:00'),(45,46,589.83,'9999-01-01 00:00:00'),(46,47,635.2,'9999-01-01 00:00:00'),(47,48,680.58,'9999-01-01 00:00:00'),(48,49,725.95,'9999-01-01 00:00:00'),(49,50,771.32,'9999-01-01 00:00:00'),(50,52,816.69,'9999-01-01 00:00:00'),(51,53,35,'9999-01-01 00:00:00'),(52,54,50,'9999-01-01 00:00:00'),(53,55,65,'9999-01-01 00:00:00'),(54,56,85,'9999-01-01 00:00:00'),(55,57,100,'9999-01-01 00:00:00'),(56,58,125,'9999-01-01 00:00:00'),(57,59,145,'9999-01-01 00:00:00'),(58,60,170,'9999-01-01 00:00:00'),(59,61,195,'9999-01-01 00:00:00'),(60,62,220,'9999-01-01 00:00:00'),(61,63,250,'9999-01-01 00:00:00'),(62,64,290,'9999-01-01 00:00:00'),(63,65,330,'9999-01-01 00:00:00'),(64,66,370,'9999-01-01 00:00:00'),(65,67,455,'9999-01-01 00:00:00'),(66,68,500,'9999-01-01 00:00:00'),(67,69,545,'9999-01-01 00:00:00'),(68,70,64.63,'9999-01-01 00:00:00'),(69,71,64.63,'9999-01-01 00:00:00'),(70,72,64.63,'9999-01-01 00:00:00'),(71,73,129.26,'9999-01-01 00:00:00'),(72,74,129.26,'9999-01-01 00:00:00'),(73,75,129.26,'9999-01-01 00:00:00'),(74,76,129.26,'9999-01-01 00:00:00'),(75,77,129.26,'9999-01-01 00:00:00'),(76,78,161.58,'9999-01-01 00:00:00'),(77,79,161.58,'9999-01-01 00:00:00'),(78,80,161.58,'9999-01-01 00:00:00'),(79,81,161.58,'9999-01-01 00:00:00'),(80,82,161.58,'9999-01-01 00:00:00'),(81,83,290.84,'9999-01-01 00:00:00'),(82,84,290.84,'9999-01-01 00:00:00'),(83,85,290.84,'9999-01-01 00:00:00'),(84,86,290.84,'9999-01-01 00:00:00'),(85,87,290.84,'9999-01-01 00:00:00'),(86,88,131,'9999-01-01 00:00:00'),(87,89,131,'9999-01-01 00:00:00'),(88,90,131,'9999-01-01 00:00:00'),(89,91,175,'9999-01-01 00:00:00'),(90,92,175,'9999-01-01 00:00:00'),(91,93,175,'9999-01-01 00:00:00'),(92,94,291,'9999-01-01 00:00:00'),(93,95,291,'9999-01-01 00:00:00'),(94,96,291,'9999-01-01 00:00:00'),(95,97,583,'9999-01-01 00:00:00'),(96,98,583,'9999-01-01 00:00:00'),(97,99,583,'9999-01-01 00:00:00'),(98,100,874,'9999-01-01 00:00:00'),(99,101,874,'9999-01-01 00:00:00'),(100,102,874,'9999-01-01 00:00:00'),(101,103,1165,'9999-01-01 00:00:00'),(102,104,1165,'9999-01-01 00:00:00'),(103,105,1165,'9999-01-01 00:00:00'),(104,106,1165,'9999-01-01 00:00:00'),(105,107,1165,'9999-01-01 00:00:00'),(106,108,70,'9999-01-01 00:00:00'),(107,109,70,'9999-01-01 00:00:00'),(108,110,90,'9999-01-01 00:00:00'),(109,111,130,'9999-01-01 00:00:00'),(110,112,180,'9999-01-01 00:00:00'),(111,113,240,'9999-01-01 00:00:00'),(112,114,290,'9999-01-01 00:00:00'),(113,115,350,'9999-01-01 00:00:00'),(114,116,470,'9999-01-01 00:00:00'),(115,117,620,'9999-01-01 00:00:00'),(116,118,760,'9999-01-01 00:00:00'),(117,119,910,'9999-01-01 00:00:00'),(118,120,1060,'9999-01-01 00:00:00'),(119,121,1230,'9999-01-01 00:00:00'),(120,122,1410,'9999-01-01 00:00:00'),(121,123,1590,'9999-01-01 00:00:00'),(122,124,1760,'9999-01-01 00:00:00'),(123,125,1940,'9999-01-01 00:00:00'),(124,126,93.22,'9999-01-01 00:00:00'),(125,127,119.85,'9999-01-01 00:00:00'),(126,128,146.49,'9999-01-01 00:00:00'),(127,129,173.12,'9999-01-01 00:00:00'),(128,130,199.75,'9999-01-01 00:00:00'),(129,131,226.39,'9999-01-01 00:00:00'),(130,132,253.02,'9999-01-01 00:00:00'),(131,133,279.66,'9999-01-01 00:00:00'),(132,134,332.92,'9999-01-01 00:00:00'),(133,135,386.19,'9999-01-01 00:00:00'),(134,136,466.09,'9999-01-01 00:00:00'),(135,137,545.99,'9999-01-01 00:00:00'),(136,138,612.58,'9999-01-01 00:00:00'),(137,139,679.16,'9999-01-01 00:00:00'),(138,140,745.75,'9999-01-01 00:00:00'),(139,141,799.02,'9999-01-01 00:00:00'),(140,142,17.03,'9999-01-01 00:00:00'),(141,143,17.03,'9999-01-01 00:00:00'),(142,144,17.03,'9999-01-01 00:00:00'),(143,145,52.57,'9999-01-01 00:00:00'),(144,146,52.57,'9999-01-01 00:00:00'),(145,147,52.57,'9999-01-01 00:00:00'),(146,148,158.44,'9999-01-01 00:00:00'),(147,149,158.44,'9999-01-01 00:00:00'),(148,150,158.44,'9999-01-01 00:00:00'),(149,151,456.07,'9999-01-01 00:00:00'),(150,152,456.07,'9999-01-01 00:00:00'),(151,153,456.07,'9999-01-01 00:00:00'),(152,154,456.07,'9999-01-01 00:00:00'),(153,155,456.07,'9999-01-01 00:00:00'),(154,156,456.07,'9999-01-01 00:00:00'),(155,157,456.07,'9999-01-01 00:00:00'),(156,158,456.07,'9999-01-01 00:00:00'),(157,159,456.07,'9999-01-01 00:00:00'),(158,160,456.07,'9999-01-01 00:00:00'),(159,161,456.07,'9999-01-01 00:00:00'),(160,162,456.07,'9999-01-01 00:00:00'),(161,163,456.07,'9999-01-01 00:00:00'),(162,164,456.07,'9999-01-01 00:00:00'),(163,165,456.07,'9999-01-01 00:00:00'),(164,166,456.07,'9999-01-01 00:00:00'),(165,167,215.74,'9999-01-01 00:00:00'),(166,168,138.69,'9999-01-01 00:00:00'),(167,169,169.51,'9999-01-01 00:00:00'),(168,170,205.47,'9999-01-01 00:00:00'),(169,171,226.02,'9999-01-01 00:00:00'),(170,172,261.97,'9999-01-01 00:00:00'),(171,173,292.79,'9999-01-01 00:00:00'),(172,174,328.75,'9999-01-01 00:00:00'),(173,175,359.57,'9999-01-01 00:00:00'),(174,176,395.53,'9999-01-01 00:00:00'),(175,177,431.48,'9999-01-01 00:00:00'),(176,178,462.3,'9999-01-01 00:00:00'),(177,179,498.26,'9999-01-01 00:00:00'),(178,180,534.22,'9999-01-01 00:00:00'),(179,181,565.04,'9999-01-01 00:00:00'),(180,182,595.86,'9999-01-01 00:00:00'),(181,183,636.95,'9999-01-01 00:00:00'),(182,184,667.77,'9999-01-01 00:00:00'),(183,185,137.61,'9999-01-01 00:00:00'),(184,186,105.85,'9999-01-01 00:00:00'),(185,187,137.61,'9999-01-01 00:00:00'),(186,188,169.36,'9999-01-01 00:00:00'),(187,189,190.53,'9999-01-01 00:00:00'),(188,190,232.87,'9999-01-01 00:00:00'),(189,191,264.63,'9999-01-01 00:00:00'),(190,192,296.38,'9999-01-01 00:00:00'),(191,193,328.14,'9999-01-01 00:00:00'),(192,194,359.89,'9999-01-01 00:00:00'),(193,195,402.23,'9999-01-01 00:00:00'),(194,196,433.99,'9999-01-01 00:00:00'),(195,197,465.74,'9999-01-01 00:00:00'),(196,198,497.5,'9999-01-01 00:00:00'),(197,199,529.26,'9999-01-01 00:00:00'),(198,200,571.6,'9999-01-01 00:00:00'),(199,201,603.35,'9999-01-01 00:00:00'),(200,202,635.11,'9999-01-01 00:00:00'),(201,203,1432.27,'9999-01-01 00:00:00'),(202,204,3222.62,'9999-01-01 00:00:00'),(203,205,6624.27,'9999-01-01 00:00:00');
/*!40000 ALTER TABLE `annuity_amount` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `annuity_invoice`
--

DROP TABLE IF EXISTS `annuity_invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `annuity_invoice` (
  `id` int(11) NOT NULL,
  `annuity_number` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `FK_2A98B6CEBF396750` FOREIGN KEY (`id`) REFERENCES `abstract_invoice` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `annuity_invoice`
--

LOCK TABLES `annuity_invoice` WRITE;
/*!40000 ALTER TABLE `annuity_invoice` DISABLE KEYS */;
INSERT INTO `annuity_invoice` VALUES (1,7),(2,7),(3,8),(4,8),(5,8),(6,9),(7,9),(8,10),(9,10),(13,6),(14,8),(15,11),(16,11),(17,11),(18,11),(19,11),(20,7),(21,8),(22,8),(23,8),(24,8),(25,8),(26,12),(27,7),(28,10),(29,10),(30,8),(31,8),(32,8),(33,14),(34,14),(35,10);
/*!40000 ALTER TABLE `annuity_invoice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `application_zone`
--

DROP TABLE IF EXISTS `application_zone`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `application_zone` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `currency` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `annuity_duration` int(11) NOT NULL,
  `patent_protection_duration` int(11) NOT NULL,
  `utility_model_protection_duration` int(11) DEFAULT NULL,
  `chapter_one` int(11) NOT NULL,
  `chapter_two` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_5707A88FF026BB7C` (`country_code`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `application_zone`
--

LOCK TABLES `application_zone` WRITE;
/*!40000 ALTER TABLE `application_zone` DISABLE KEYS */;
INSERT INTO `application_zone` VALUES (1,'DE','EUR',1,20,NULL,30,30),(2,'GB','EUR',1,20,NULL,31,31),(3,'JP','EUR',1,20,NULL,30,30),(4,'SE','EUR',1,20,NULL,31,31),(5,'US','EUR',4,20,NULL,30,30),(6,'FR','EUR',1,20,NULL,30,30),(7,'CA','EUR',1,20,NULL,30,30),(8,'NO','EUR',1,20,NULL,31,31),(9,'EP','EUR',1,20,NULL,31,31),(10,'AT','EUR',1,20,NULL,30,30),(11,'BE','EUR',1,20,NULL,0,0),(12,'CH','EUR',1,20,NULL,30,30),(13,'PCT','EUR',1,20,NULL,0,0),(14,'IN','EUR',1,20,NULL,31,31),(15,'CN','EUR',1,20,NULL,30,30),(16,'CZ','EUR',1,20,NULL,31,31),(17,'DK','EUR',1,20,NULL,31,31),(18,'ES','EUR',1,20,NULL,30,30),(19,'FI','EUR',1,20,NULL,31,31),(20,'IT','EUR',1,20,NULL,0,0),(21,'NL','EUR',1,20,NULL,0,0),(22,'PL','EUR',1,20,NULL,30,30),(23,'PT','EUR',1,20,NULL,30,30),(24,'TR','EUR',1,20,NULL,30,30);
/*!40000 ALTER TABLE `application_zone` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migration_versions`
--

DROP TABLE IF EXISTS `migration_versions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migration_versions` (
  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migration_versions`
--

LOCK TABLES `migration_versions` WRITE;
/*!40000 ALTER TABLE `migration_versions` DISABLE KEYS */;
INSERT INTO `migration_versions` VALUES ('20160426123321'),('20160601132815'),('20160606103457');
/*!40000 ALTER TABLE `migration_versions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `opposition_invoice`
--

DROP TABLE IF EXISTS `opposition_invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `opposition_invoice` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `FK_FD3420E4BF396750` FOREIGN KEY (`id`) REFERENCES `abstract_invoice` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `opposition_invoice`
--

LOCK TABLES `opposition_invoice` WRITE;
/*!40000 ALTER TABLE `opposition_invoice` DISABLE KEYS */;
INSERT INTO `opposition_invoice` VALUES (39);
/*!40000 ALTER TABLE `opposition_invoice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `procedure_invoice`
--

DROP TABLE IF EXISTS `procedure_invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `procedure_invoice` (
  `id` int(11) NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `FK_C12DFDADBF396750` FOREIGN KEY (`id`) REFERENCES `abstract_invoice` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `procedure_invoice`
--

LOCK TABLES `procedure_invoice` WRITE;
/*!40000 ALTER TABLE `procedure_invoice` DISABLE KEYS */;
INSERT INTO `procedure_invoice` VALUES (36,'Facturation correspondant  au dépôt du brevet français');
/*!40000 ALTER TABLE `procedure_invoice` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2016-09-26 16:36:28
