-- MySQL dump 10.10
--
-- Host: localhost    Database: patent_esp
-- ------------------------------------------------------
-- Server version	5.0.24a-community-nt-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 */;

--
-- Current Database: `patent_esp`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `patent_esp` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_estonian_ci */;

USE `patent_esp`;

--
-- Table structure for table `update5`
--

DROP TABLE IF EXISTS `update5`;
CREATE TABLE `update5` (
  `idappli` char(12) collate utf8_estonian_ci NOT NULL,
  `dtpubli` date NOT NULL,
  PRIMARY KEY  (`idappli`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;

--
-- Dumping data for table `update5`
--


/*!40000 ALTER TABLE `update5` DISABLE KEYS */;
LOCK TABLES `update5` WRITE;
INSERT INTO `update5` VALUES ('X553846','2016-03-15'),('X553848','2016-03-15'),('X553872','2016-03-15'),('X553903','2016-03-15'),('X553926','2016-03-15'),('X553929','2016-03-15'),('X553936','2016-03-15'),('X553942','2016-03-15');
UNLOCK TABLES;
/*!40000 ALTER TABLE `update5` ENABLE KEYS */;

--
-- Table structure for table `yabstract`
--

DROP TABLE IF EXISTS `yabstract`;
CREATE TABLE `yabstract` (
  `idappli` varchar(12) collate utf8_estonian_ci NOT NULL,
  `txtform` varchar(2000) collate utf8_estonian_ci default NULL,
  `abstract` varchar(2000) collate utf8_estonian_ci default NULL,
  PRIMARY KEY  (`idappli`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;

--
-- Dumping data for table `yabstract`
--


/*!40000 ALTER TABLE `yabstract` DISABLE KEYS */;
LOCK TABLES `yabstract` WRITE;
INSERT INTO `yabstract` VALUES ('X553846     ','Käesolev leiutis esitab ravimkoostised, mis koosnevad inimese kannabinoidiretseptori vastase antikeha aktiveeritud ja potentseeritud vormist, ja nende kasutuse rasvumise ning sellega seotud ainevahetushäirete raviks. Lisaks esitab käesolev leiutis ravimkoostised, mis koosnevad inimese kannabinoidiretseptori vastase antikeha aktiveeritud ja potentseeritud vormist ning valgu S-100 vastase antikeha aktiveeritud ja potentseeritud vormist psühhoaktiivsete ainete sõltuvuse raviks.','The present disclosure provides pharmaceutical compositions comprising an activated potentiated form of an antibody to human cannabinoid receptor and their use in the treatment of obesity and related metabolic disorders. The present disclosure further provides pharmaceutical compositions comprising an activated potentiated form of an antibody to human cannabinoid receptor and activated potentiated form of an antibody to protein S - 100 for use in the treatment of addiction to psychoactive substances.'),('X553848     ','Käesolev leiutis esitab ravimikoostise manustamiseks patsiendile, kes kannatab diabeedi ja muude ainevahetushäirete all, ravimikoostis sisaldab a) inimese insuliiniretseptori vastase antikeha aktiveeritud ja potentseeritud vormi ning b) endoteliaalse NO süntaasi vastase antikeha aktiveeritud ja potentseeritud vormi.','The present invention provides a pharmaceutical composition for administration to a patient suffering from diabetes and other metabolic disorders, the composition comprises a) an activated-potentiated form of an antibody to human insulin receptor, and b) an activated-potentiated form of an antibody to endothelial NO-synthase.'),('X553872     ','Leiutis käsitleb meetodit põlevkiviõli sisaldava süsivesiniktoorme töötlemiseks, mis sisaldab hüdrogeenivat krakkimist keevkihis, fraktsioneerimist ja destilleerimist atmosfäärirõhul ja @ gaasifraktsiooni, naftafraktsiooni, diislifraktsiooni ja diislifraktsioonist raskema fraktsiooni moodustamist, samuti diislifraktsioonist raskema fraktsiooni vedelik-vedelik-ekstraktsiooni ja nafta- ja diislifraktsiooni vesinikuga töötlemist. Meetod on mõeldud kütusetoorme maksimaalse saagise saamiseks.','Method for converting hydrocarbon feedstock comprising a shale oil, comprising a step of hydroconverting in an ebullating bed, a step of fractionating by atmospheric distillation into a light fraction, a naphtha fraction, a gas-oil fraction and a fraction heavier than the gas-oil fraction, a step of liquid/liquid extraction of the fraction heavier than the gas-oil fraction, and a dedicated hydrotreating for each of the naphtha and gas-oil fractions. The method aims to maximize the yield of fuel bases.'),('X553903     ','Leiutiseks on polüetüleenhelvestest ja polüestermikrokiududest täidismaterjal, mida kasutatakse vooditarvete, eelkõige patjade täidisena. Polüetüleenhelvestest ja polüestermikrokiududest täidis on kerge, õhuline ja elastne, andes padjatäidisena kasutamisel padjale udusulepadjaga sarnase pehmuse. Pakutud täidis on ebasoodne keskkond bakterite paljunemiseks, olles sealjuures pestav baktereid hävitava temperatuuri juures kodustes tingimustes. Pakutud täidisega padi säilitab kohevuse, elastsuse ja pehmuse ka pärast pesu. Täidisel ei ole tervist kahjustavaid omadusi, sobides sealjuures ka allergikutele.','The invention provides a stuffing containing polyethylene flakes and polyester microfibers, which is used as stuffing for bed clothes, especially pillows. The stuffing containing polyethylene flakes and polyester microfibers is light, airy and flexible, giving the same softness characteristics as down pillow. Provided stuffing is an unfavorable environment for bacterial growth, being washable at bacteria killing temperature in domestic conditions. A pillow filled with provided stuffing maintains fluffy, flexible and soft even after washing. The stuffing has no health adversing impacts, being suitable also for allergics.'),('X553926     ','Seade komposiitmaterjalide purunemismehhanismi uurimiseks ja testimiseks, mis on moodustatud platvormist 2, vedrudest 3, korpusest 4, kaanest 6, kinnitusvahenditest 7 ja 8, avast 9, ajamist 10a või 10b, katsekeha 5 kinnitusvahendist 12, kinnitusvahendite 7 keeramise avadest 13, pieso-elektrilisest jõuandurist 15, ja koormussüsteemist. Koormussüsteem on moodustatud platvormist 2, vedrust 3, korpusest 4, kaanest 6, kinnitusvahenditest 7 ja 8. Seade komposiitmaterjalide purunemismehhanismi uurimiseks võimaldab tekitada uuritavates materjalides aeglaselt pragusid ja uurida nende arengut ning kvantitatiivselt hinnata materjali tugevust ja kvalitatiivselt hinnata faaside ja faasidevahelisi tugevusi (kohesioon ja adhesioon).','The device for assessment of the fracture mechanisms of composite materials which consists of platform 2, springs 3, body 4, lid 6, fastenings 7 and 8, openings 9, drive 10a or 10b, holder 12 for test sample 5, openings 13 for rotation of the fastening 7, piezoelectric force cell 15 and loading system. Loading system consists of platform 2, springs 3, body 4, lid 6, fastenings 7 and 8. The device for assessment of the fracture mechanisms of composite materials enables to initiate slowly the cracks in the material under research and to track their development (growth) that allows the quantitative estimation of the bulk strength of material and qualitative estimation of the single phase and interphase strength (cohesion and adhesion).'),('X553929     ','Leiutis pakub maja keskküttesüsteemi autonoomse kontrollsüsteemi ja keskküttesüsteemi autonoomse reguleerimismeetodi, eesmärgiga vähendada ruumide kütmiseks kasutatavat soojusenergiat. Leiutisekohane  küttesüsteem sisaldab soojusvahetit 1, milles on soojatootja poolne soojusvaheti 2, soojatarbija ehk kortermaja poolne soojusvaheti 3, termostaatventiiliga 14 varustatud radiaator 13, soojatootja küttevee vooluhulga regulaatorventiil 4, mida juhitakse juhtimis/reguleerimiskeskusest 5 saabuva signaaliga, samuti tsirkulatsioonipumpa 10, millesse on integreeritud või on sellega järjestikku ühendatud   tagasivooluhulga andur 11, mis on ühendatud juhtimis/reguleerimiskeskuses paikneva elektroonikalülitusega. Juhtimis/reguleerimiskeskuses 5 paiknev elektroonikalülitus 12 on konfigureeritud võtma vastu tagasivooluhulga andurist 11 saadetavaid signaale ja reguleerima vastavalt tsirkulatsioonipumpa läbivale vooluhulgale soojatootja küttevee vooluhulga regulaatorventiili 4, millega on tagatud see, et  termostaatide 15 töö alusel reguleeritakse soojatarbija poolt soojatootjalt võetava kütteenergia hulka, kusjuures termostaadid 15 reageerivad ruumi temperatuuri muutustele, seega arvestatakse küttesüsteemi töös näiteks päikese poolt ruumi tekitatavat nn vabasoojust, samuti tuule jahutavat mõju hoone tuulepoolsetele ruumidele.','The present invention provides an autonomous control system of central heating system and autonomous adjusting method of central heating system, in order to reduce thermal energy used for heating of rooms. The heating system of the invention comprises a heat exchanger 1, having heat exchanger 2 of the heat producer, heat exchanger 3 of the heat consumer or apartment house, radiator 13 equipped with thermostatic valve 14, adjusting valve 4 of heating water flow amount of the heat producer, controlled by the incoming signal from control/adjustment unit 5, as well as the circulation pump 10, which is integrated with or is connected in series with the reflux amount sensor 11, which is connected to electronic circuit located in the control/adjustment unit. Electronic circuit 12 located in the control/adjustment unit 5 is configured to receive signals sent from reflux amount sensor 11 and adjust according to flow amount through the circulation pump the adjusting valve 4 of the heat producer, which ensures that based on the work of the thermostats 15 is adjusted the amount of the heating energy taken from the heat producer, wherein thermostats 15 respond to changes in room temperature, thus during operation of the heating system is taken into consideration, for example, so called free energy produced by the sun, and the cooling effect of the wind to rooms on the windy sides of the building.'),('X553936     ','Käesolev leiutis kuulub väetiste tootmise valdkonda ja käsitleb meetodit ja seadet granuleeritud väetiste, näiteks karbamiidi ja ammooniumnitraadi tootmiseks. Granuleeritud väetis toodetakse selle väetise sulatise pihustamise teel (dispergeerimisel) granuleerimistorni mahus, milles moodustatud sulatisetilgad jahutatakse ja tahkestatakse allalangemisel, kui need kontakteeruvad tõusva õhuvooluga. Saadud graanulid jahutatakse välises keevkihtaparaadis, kus väetise graanulid transporditakse horisontaalselt. Keevkihtaparaadis väljutatakse tolmunud õhk eraldi  vähemalt kahest keevkihtaparaadi tsoonist, kusjuures tolmunud õhk juhitakse graanulite liikumise järgi keevkihtaparaadi esimesest tsoonist õhupuhastusseadisesse tolmunud õhu puhastamiseks, ja tolmunud õhk keevkihtaparaadi järgnevatest tsoonidest suunatakse granuleerimistorni. Tehniline tulemus seisneb keevkihtaparaadist puhastamiseks edastatava tolmunud õhu mahu vähenemises ja selle tulemusel ka õhu puhastamiseks kulutatava energia ja  kapitalikulude vähenemises.','The invention belongs to the field of fertilizers and relates to a method and apparatus for producing fertilizers in granular form, for example carbamide and ammonium nitrate. The fertilizer in granular form is produced by means of dispersing fertilizer melt in a volume of a granulating tower, where drops of melt formed are cooled and hardened when coming into contact with the rising flow of air. The granules produced are cooled in a separate fluidized bed apparatus with a horizontal movement of fertilizer granules. In the fluidized bed apparatus separate removal of dust-filled air is performed from at least two zones of the apparatus, wherein the dust-filled air from the first zone of the apparatus in the direction of passage of the granules is directed into a device for purifying the dust-filled air, and the dust-filled air from the subsequent zones of the apparatus is directed into the granulating tower. The technical result is in reducing the volume of dust-filled air arriving for purification from the fluidized bed apparatus and reducing the energy losses and costs involved in the purification of this air as a result.'),('X553942     ','Leiutis kirjeldab meetodit parkimissessiooni andmete  elektrooniliseks muutmiseks parkimissessiooni käigus, millega on võimalik elektrooniliselt mitme kasutajaterminali sidemooduli kasutajaliidese kaudu vahetult parkimissessiooni andmeid muuta, kui kasutaja või sõiduki automaatse parkimise aktiveerimise süsteem on määranud vale parkimisala. Selle võtte abil on võimalik vältida kasutajale tahvi või muude sanktsioonide rakendamist ja seda kogu parkimissessiooni eest. Elektroonilist kasutajaliidest võib kasutada nii sõiduki kasutaja kui ka parkimiskontrolör.','Invention describes a method for electronically altering vehicle\'s parking session data during an ongoing parking sessioon, which allow direct electronic altering of the parking data by a different user terminal communication module user interfaces, when the vehicle is assigned by user or vehicle’s automated parking system to incorrect parking area.By using the method, fine or other sanctions to the user are avoided for the whole parking session. The electronic user interface can be used by either the user of the vehicler or a parking inspector.');
UNLOCK TABLES;
/*!40000 ALTER TABLE `yabstract` ENABLE KEYS */;

--
-- Table structure for table `yagent`
--

DROP TABLE IF EXISTS `yagent`;
CREATE TABLE `yagent` (
  `idagent` int(3) NOT NULL,
  `ctagent` varchar(250) collate utf8_estonian_ci default NULL,
  `fnagent` varchar(60) collate utf8_estonian_ci default NULL,
  `nmagent` varchar(120) collate utf8_estonian_ci default NULL,
  `adagent` varchar(240) collate utf8_estonian_ci default NULL,
  `nmtown` varchar(80) collate utf8_estonian_ci default NULL,
  `idtown` varchar(10) collate utf8_estonian_ci default NULL,
  `idcountry` varchar(2) collate utf8_estonian_ci default NULL,
  PRIMARY KEY  (`idagent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;

--
-- Dumping data for table `yagent`
--


/*!40000 ALTER TABLE `yagent` DISABLE KEYS */;
LOCK TABLES `yagent` WRITE;
INSERT INTO `yagent` VALUES (7,'OÜ Kesna','Ljubov','Kesselman','Tedre 77-52','Tallinn','10616',''),(36,'AAA Patendibüroo OÜ','Tõnu','Nelsas','Tartu mnt 16','Tallinn','10117',''),(37,'Patendibüroo Turvaja OÜ','Riho','Pikkor','Liivalaia 22','Tallinn','10118','EE'),(39,'Patendi- & Kaubamärgibüroo Koitel OÜ','Raivo','Koitel','Tina 26','Tallinn','10126','EE'),(48,'Sarap ja Putk Patendibüroo','Mikk','Putk','Tõnismägi 3-2','Tallinn','10119','EE');
UNLOCK TABLES;
/*!40000 ALTER TABLE `yagent` ENABLE KEYS */;

--
-- Table structure for table `ybdata`
--

DROP TABLE IF EXISTS `ybdata`;
CREATE TABLE `ybdata` (
  `idappli` varchar(12) collate utf8_estonian_ci NOT NULL,
  `order` int(3) default NULL,
  PRIMARY KEY  (`idappli`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;

--
-- Dumping data for table `ybdata`
--


/*!40000 ALTER TABLE `ybdata` DISABLE KEYS */;
LOCK TABLES `ybdata` WRITE;
INSERT INTO `ybdata` VALUES ('X553926     ',1),('X553929     ',1),('X553936     ',1),('X553942     ',1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `ybdata` ENABLE KEYS */;

--
-- Table structure for table `yclass`
--

DROP TABLE IF EXISTS `yclass`;
CREATE TABLE `yclass` (
  `idappli` char(12) collate utf8_estonian_ci NOT NULL,
  `dtversion` char(6) collate utf8_estonian_ci default NULL,
  `ipcclass` varchar(15) collate utf8_estonian_ci default NULL,
  `symbpos` int(1) default NULL,
  `tyclassif` int(1) default NULL,
  `scclassif` int(1) default NULL,
  `odclass` int(3) default NULL,
  KEY `idappli` (`idappli`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;

--
-- Dumping data for table `yclass`
--


/*!40000 ALTER TABLE `yclass` DISABLE KEYS */;
LOCK TABLES `yclass` WRITE;
INSERT INTO `yclass` VALUES ('X553846','201301','C07K  16/18',1,1,1,1),('X553846','201301','C07K  16/28',2,1,1,2),('X553846','201301','A61K  39/395',2,1,1,3),('X553846','201301','A61K  41/00',2,1,1,4),('X553846','201301','A61P   3/00',2,1,1,5),('X553846','201301','A61P   3/04',2,1,1,6),('X553846','201301','A61P  25/34',2,1,1,7),('X553848','201301','C07K  16/28',1,1,1,1),('X553848','201301','C07K  16/40',2,1,1,2),('X553848','201301','A61K  39/395',2,1,1,3),('X553848','201301','A61K  41/00',2,1,1,4),('X553848','201301','A61P   3/10',2,1,1,5),('X553872','201301','C10G   1/00',1,1,1,1),('X553872','201301','C10G  67/04',2,1,1,2),('X553872','201301','C10L   1/02',2,1,1,3),('X553903','201501','B68G   1/00',1,1,1,1),('X553926','201601','G01N   3/42',1,1,1,1),('X553929','201501','F04D  15/00',1,1,1,1),('X553929','201501','F24D  19/10',2,1,1,2),('X553936','201401','C05C   7/02',1,1,1,1),('X553936','201401','B01J   2/04',2,1,1,2),('X553942','201501','G07B  15/02',1,1,1,1),('X553942','201501','G07C   1/30',2,1,1,2),('X553942','201501','G07F  17/24',2,1,1,3);
UNLOCK TABLES;
/*!40000 ALTER TABLE `yclass` ENABLE KEYS */;

--
-- Table structure for table `yinvent`
--

DROP TABLE IF EXISTS `yinvent`;
CREATE TABLE `yinvent` (
  `idappli` varchar(12) collate utf8_estonian_ci NOT NULL,
  `idinvent` int(11) NOT NULL,
  `odinvent` int(3) default NULL,
  PRIMARY KEY  (`idappli`,`idinvent`),
  KEY `idappli` (`idappli`),
  KEY `idinvent` (`idinvent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;

--
-- Dumping data for table `yinvent`
--


/*!40000 ALTER TABLE `yinvent` DISABLE KEYS */;
LOCK TABLES `yinvent` WRITE;
INSERT INTO `yinvent` VALUES ('X553846     ',14179,1),('X553846     ',14180,2),('X553846     ',14181,3),('X553846     ',14183,4),('X553846     ',14184,5),('X553846     ',14185,6),('X553846     ',14186,7),('X553848     ',14179,1),('X553872     ',14227,1),('X553872     ',14228,2),('X553872     ',14229,3),('X553872     ',14230,4),('X553903     ',14305,2),('X553926     ',14333,1),('X553926     ',14343,2),('X553929     ',14347,1),('X553936     ',13621,8),('X553936     ',14355,1),('X553936     ',14356,2),('X553936     ',14357,3),('X553936     ',14358,4),('X553936     ',14359,5),('X553936     ',14360,6),('X553936     ',14361,7),('X553942     ',14261,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `yinvent` ENABLE KEYS */;

--
-- Table structure for table `yinventor`
--

DROP TABLE IF EXISTS `yinventor`;
CREATE TABLE `yinventor` (
  `idinvent` int(11) NOT NULL,
  `fninventor` varchar(60) collate utf8_estonian_ci default NULL,
  `midninventor` varchar(60) collate utf8_estonian_ci default NULL,
  `nminventor` varchar(120) collate utf8_estonian_ci default NULL,
  `adinventor` varchar(240) collate utf8_estonian_ci default NULL,
  `idcountry` varchar(2) collate utf8_estonian_ci default NULL,
  `nmtown` varchar(80) collate utf8_estonian_ci default NULL,
  `idtown` varchar(10) collate utf8_estonian_ci default NULL,
  `nmstate` varchar(80) collate utf8_estonian_ci default NULL,
  PRIMARY KEY  (`idinvent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;

--
-- Dumping data for table `yinventor`
--


/*!40000 ALTER TABLE `yinventor` DISABLE KEYS */;
LOCK TABLES `yinventor` WRITE;
INSERT INTO `yinventor` VALUES (13621,'Nikolai','','Kuznetsov','bulv. Pobedy 3, kv. 20','RU','Dzerzhinsk','606000','Nizhegorodskaya obl.'),(14179,'Oleg','Iliich','Epshtein','4 Samotyochny per., d. 3, kv 72','RU','Moskva','127473',''),(14180,'Svetlana','Alexandrovna','Sergeeva','ul. Rossoshanskaya, d. 1, korp. 1, kv. 214','RU','Moskva','117535',''),(14181,'Liudmila','Fyodorovna','Dolgovyh','ul. Kurchatova, d. 16, kv. 1','RU','Tšeljabinsk','454091',''),(14183,'Irina','Anatolievna','Kheyfets','Novy Bulvar, d. 15, kv. 412','RU','Dolgoprudny','141707','Moskovskaya obl.'),(14184,'Julia','Leonidovna','Dugina','Angelov per., d. 5, kv. 25','RU','Moskva','125368',''),(14185,'Julia','Alexandrovna','Zabolotneva','Marijnsky Park, d. 39, k.2 kv. 46','RU','Moskva','109559',''),(14186,'Sergey','Alexandrovich','Tarasov','ul. Sovetskaya 56, korp. 3, kv. 97, 98','RU','Golitsyno, Odintsovsky r-n','143040','Moskovskaya obl.'),(14227,'Christophe','','Halais','16, allée des Acacias','FR','Lons','64140',''),(14228,'Hélène','','Leroy','164, route de Bacqueville','FR','Saint Vigor D\'ymonville','76430',''),(14229,'Frédéric','','Morel','8, avenue Paul Doumer','FR','Chatou','78400',''),(14230,'Cécile','','Plain','14, rue de la République','FR','Saint Germaine en Laye','78100',''),(14261,'Kristjan','','Konks','Saeveski 3-29','EE','Tallinn','11214',''),(14305,'Göran Valdemar','','Sjöholm','Helme tee 1, Manniva küla, Jõelähtme vald','EE','Harju maakond','74217',''),(14333,'Maksim','','Antonov','Ehitajate tee 5','EE','Tallinn','19086',''),(14343,'Sergei','','Nikitin','Kalevipoja 9-27','EE','Tallinn','13625',''),(14347,'Pjotr','','Bazanov','Mustamäe tee 102-102','EE','Tallinn','12917',''),(14355,'Aleksei','','Besedin','pr. Chkalova 51, kv. 80','RU','Dzerzhinsk','606007','Nizhegorodskaya obl.'),(14356,'Yury','','Shnepp','ul. Tereshkovoi 64a, kv. 22','RU','Dzerzhinsk','606029','Nizhegorodskaya obl.'),(14357,'Georgy','','Baklan','pr. Tsiolkovskogo 77b, kv. 37','RU','Dzerzhinsk','606033','Nizhegorodskaya obl.'),(14358,'Olga','','Dunaeva','ul. Petrischeva 25, kv. 108','RU','Dzerzhinsk','606037','Nizhegorodskaya obl.'),(14359,'Aleksandr','','Rodionov','ul. Griboedova 40, kv. 6','RU','Dzerzhinsk','606008','Nizhegorodskaya obl.'),(14360,'Valentina','','Kizimenko','ul. Oktyabrskaya 5, kv. 12','RU','Dzerzhinsk','606008','Nizhegorodskaya obl.'),(14361,'Aleksandr','','Prokopyev','ul. Kuibysheva 36','RU','Volodarsk','606070','Nizhegorodskaya obl.');
UNLOCK TABLES;
/*!40000 ALTER TABLE `yinventor` ENABLE KEYS */;

--
-- Table structure for table `yown`
--

DROP TABLE IF EXISTS `yown`;
CREATE TABLE `yown` (
  `idappli` varchar(12) collate utf8_estonian_ci NOT NULL,
  `idowner` int(12) NOT NULL,
  `odowner` int(3) default NULL,
  PRIMARY KEY  (`idappli`,`idowner`),
  KEY `idappli` (`idappli`),
  KEY `idowner` (`idowner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;

--
-- Dumping data for table `yown`
--


/*!40000 ALTER TABLE `yown` DISABLE KEYS */;
LOCK TABLES `yown` WRITE;
INSERT INTO `yown` VALUES ('X553846     ',3400,1),('X553848     ',3400,1),('X553872     ',3451,1),('X553872     ',3452,2),('X553903     ',3496,1),('X553926     ',328,1),('X553929     ',3519,1),('X553929     ',3520,2),('X553936     ',3089,1),('X553942     ',3477,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `yown` ENABLE KEYS */;

--
-- Table structure for table `yowner`
--

DROP TABLE IF EXISTS `yowner`;
CREATE TABLE `yowner` (
  `idowner` int(12) NOT NULL,
  `ntincorp` int(11) NOT NULL,
  `fnowner` varchar(60) collate utf8_estonian_ci default NULL,
  `midnowner` varchar(60) collate utf8_estonian_ci default NULL,
  `nmowner` varchar(120) collate utf8_estonian_ci default NULL,
  `orgname` varchar(120) collate utf8_estonian_ci default NULL,
  `adowner` varchar(240) collate utf8_estonian_ci default NULL,
  `idcountry` varchar(2) collate utf8_estonian_ci default NULL,
  `nmtown` varchar(80) collate utf8_estonian_ci default NULL,
  `idtown` varchar(10) collate utf8_estonian_ci default NULL,
  `nmstate` varchar(80) collate utf8_estonian_ci default NULL,
  PRIMARY KEY  (`idowner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;

--
-- Dumping data for table `yowner`
--


/*!40000 ALTER TABLE `yowner` DISABLE KEYS */;
LOCK TABLES `yowner` WRITE;
INSERT INTO `yowner` VALUES (328,2,'','','','Tallinna Tehnikaülikool','Ehitajate tee 5','EE','Tallinn','19086',''),(3089,2,'','','','Otkrytoe Aktsionernoe Obshchestvo \'\'Nauchno-Issledovatelsky i Proektny Institut Karbamida i Produktov Organicheskogo','Sinteza\'\' (OAO NIIK) \rul. Griboedova 31','RU','Dzerzhinsk','606008',''),(3400,1,'Oleg','Iliich','Epshtein','','4 Samotyochny per., d. 3, kv. 72','RU','Moskva','127473',''),(3451,2,'','','','Total Raffinage Marketing','24 cours Michelet','FR','Puteaux','92800',''),(3452,2,'','','','Axens','89 Boulevard Franklin Roosevelt','FR','Rueil Malmaison','92500',''),(3477,2,'','','','Autlo OÜ','Saeveski 3-29','EE','Tallinn','11214',''),(3496,2,'','','','Osaühing Delux','Raua 5','EE','Viljandi','71020',''),(3519,1,'Pjotr','','Bazanov','','Mustamäe tee 102-102','EE','Tallinn','12917',''),(3520,1,'Rasmus','','Kivila','','Mai põik 4-7','EE','Tallinn','11621','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `yowner` ENABLE KEYS */;

--
-- Table structure for table `ypct`
--

DROP TABLE IF EXISTS `ypct`;
CREATE TABLE `ypct` (
  `idappli` varchar(12) collate utf8_estonian_ci NOT NULL,
  `orictry` varchar(2) collate utf8_estonian_ci default NULL,
  `nopctep` varchar(13) collate utf8_estonian_ci default NULL,
  `intctry` varchar(2) collate utf8_estonian_ci default NULL,
  `nopubli` varchar(12) collate utf8_estonian_ci default NULL,
  `dtpctpubli` varchar(8) collate utf8_estonian_ci default NULL,
  KEY `idappli` (`idappli`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;

--
-- Dumping data for table `ypct`
--


/*!40000 ALTER TABLE `ypct` DISABLE KEYS */;
LOCK TABLES `ypct` WRITE;
INSERT INTO `ypct` VALUES ('X553846     ','IB','2011/00240','WO','12/007847','20120119'),('X553848     ','IB','2011/00217','WO','12/010966','20120126'),('X553872     ','FR','2011/05302','WO','12/085406','20120628'),('X553936     ','RU','2013/00031','WO','13/154470','20131017');
UNLOCK TABLES;
/*!40000 ALTER TABLE `ypct` ENABLE KEYS */;

--
-- Table structure for table `ypriority`
--

DROP TABLE IF EXISTS `ypriority`;
CREATE TABLE `ypriority` (
  `idappli` char(12) collate utf8_estonian_ci NOT NULL,
  `idcountry` varchar(2) collate utf8_estonian_ci default NULL,
  `noprio` varchar(15) collate utf8_estonian_ci default NULL,
  `dtprio` varchar(8) collate utf8_estonian_ci default NULL,
  `odpriority` int(3) default NULL,
  KEY `idappli` (`idappli`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;

--
-- Dumping data for table `ypriority`
--


/*!40000 ALTER TABLE `ypriority` DISABLE KEYS */;
LOCK TABLES `ypriority` WRITE;
INSERT INTO `ypriority` VALUES ('X553846','RU','2010129289','20100715',1),('X553846','RU','2010130350','20100721',2),('X553846','RU','2011122407','20110602',3),('X553848','RU','2010130348','20100721',1),('X553848','RU','2011127051','20110701',2),('X553872','FR','1061244','20101224',1),('X553936','RU','2012114061','20120410',1),('X553942','EE','P201300039','20131202',1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `ypriority` ENABLE KEYS */;

--
-- Table structure for table `yptappli`
--

DROP TABLE IF EXISTS `yptappli`;
CREATE TABLE `yptappli` (
  `idappli` varchar(12) collate utf8_estonian_ci NOT NULL,
  `doc-id` varchar(20) collate utf8_estonian_ci NOT NULL,
  `doc-number-pub` int(12) NOT NULL,
  `doc-idp` varchar(20) collate utf8_estonian_ci default NULL,
  `doc-number-pubp` varchar(12) collate utf8_estonian_ci default NULL,
  `kind` int(2) NOT NULL,
  `dtpubli` varchar(8) collate utf8_estonian_ci NOT NULL,
  `extidappli` varchar(12) collate utf8_estonian_ci NOT NULL,
  `dtappli` varchar(8) collate utf8_estonian_ci NOT NULL,
  `title` varchar(250) collate utf8_estonian_ci default NULL,
  `engtitle` varchar(250) collate utf8_estonian_ci default NULL,
  `idagent` int(3) default NULL,
  PRIMARY KEY  (`idappli`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;

--
-- Dumping data for table `yptappli`
--


/*!40000 ALTER TABLE `yptappli` DISABLE KEYS */;
LOCK TABLES `yptappli` WRITE;
INSERT INTO `yptappli` VALUES ('X553846     ','EE201300005',201300005,'EE05760','05760',2,'20160315','P201300005  ','20110715','Ravimkoostis','Pharmaceutical compositions',48),('X553848     ','EE201300007',201300007,'EE05761','05761',2,'20160315','P201300007  ','20110715','Kombineeritud ravimkoostis diabeedi ning ainevahetushäirete raviks','A combined pharmaceutical composition for treatment of diabetes and metabolic disorders',48),('X553872     ','EE201300023',201300023,'EE05762','05762',2,'20160315','P201300023  ','20111216','Meetod põlevkiviõli sisaldava süsivesiniktoorme töötlemiseks, mis hõlmab hüdrogeenivat krakkimist keevkihis, fraktsioneerimist atmosfäärdestillatsioonil ja raske fraktsiooni vedelik-vedelik-ekstraktsiooni','Method for converting hydrocarbon feedstock comprising a shale oil by hydroconversion in an ebullating bed, fractionation by atmospheric distillation and liquid/liquid extraction of the heavy fraction',37),('X553903     ','EE201400008',201400008,'EE05763','05763',2,'20160315','P201400008  ','20140326','Vooditarvete täidismaterjal ja selle kasutamine','Stuffing material for bed clothes and use thereof',36),('X553926     ','EE201400029',201400029,'','',1,'20160315','P201400029  ','20140811','Seade komposiitmaterjalide purunemismehhanismi uurimiseks','Device for assessment of the fracture mechanisms of composite materials',0),('X553929     ','EE201400032',201400032,'','',1,'20160315','P201400032  ','20140815','Keskküttesüsteemi autonoomne kontrollsüsteem ja keskküttesüsteemi autonoomne reguleerimismeetod','Autonomous control system of central heating system and autonomous adjusting method of central heating system',36),('X553936     ','EE201400036',201400036,'EE05764','05764',2,'20160315','P201400036  ','20130404','Meetod ja seade granuleeritud väetise tootmiseks','Method and apparatus for producing fertilizer in granular form',7),('X553942     ','EE201400040',201400040,'EE05765','05765',2,'20160315','P201400040  ','20141201','Meetod sõiduki parkimissessiooni andmete elektrooniliseks muutmiseks parkimissessiooni käigus','Method for electronic data altering of a vechile\'s parking during an ongoing parking session',39);
UNLOCK TABLES;
/*!40000 ALTER TABLE `yptappli` ENABLE KEYS */;

--
-- Dumping routines for database 'patent_esp'
--
DELIMITER ;;
DELIMITER ;
/*!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 */;

