-- 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 ('X554028','2018-09-17'),('X554045','2018-09-17'),('X554049','2018-09-17'),('X554091','2018-09-17');
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 ('X554028     ','Leiutise eesmärgiks on luua seade ja meetod, mis võimaldab mehitamata õhusõiduki automaatset positsioneerimist maandumisplatvormil. Seade sisaldab maandumisplatvormi, mille maandumisaluse pind on osaliselt või täielikult ühendatud vibratsiooni tekitava seadmega. Vibratsiooni tulemusel positsioneeritakse maandumisalusele maandunud mehitamata õhusõiduk sellel soovitud asukohta ja asendisse. Maandumisaluse sensoritega tuvastatakse mehitamata õhusõiduki paiknemine maandumisalusel soovitud asukohas ja asendis.','The purpose of the invention is to create a device and a method which allows the automated positioning of an unmanned aerial vehicle on the landing platform. Device comprises of the landing platform, the landing surface of which is fully or partially connected to a vibration generating device. The unmanned aerial vehicle, landed on the landing surface, is positioned to the desired location and position on it by vibration. Sensors of the landing surface detect the position and location of the unmanned aerial vehicle on the desired spot on the landing surface.'),('X554045     ','Leiutiseks on meetod ja seade sageduskarakteristiku mõõtmiseks, mis sisaldab ajast sõltuva sagedusega mõõdetava objekti ergutussignaali (näiteks lineaarse siinus-chirpi) genereerimist ning ajast sõltuvat lühikeses libisevas ajavallaaknas toimuvat objekti vastussignaali analüüsi, kusjuures vastussignaali võendamishetked on genereeritud vastavalt ergutussignaali etteantud faasisammule ning libisevas analüüsiajaaknas on etteantud arv vastussignaali järjestikulisi võendeid. Vastussignaali analüüs lühikeses libisevas ajavallaaknas võib olla teostatud tema korrutamise ja akumuleerimisega paralleelselt kahe erineva tugilainekujuga, millest üks võib olla ergutussignaaliga sama lainekujuga siinus-chirp ning teine vastav koosinus-chirp ning analüüsi tulemusteks on vastava sageduskäigu reaal- ja imaginaarosad.','The present invention relates to a method and device for frequency response measurement, including generation of an excitation signal (like sinewave) with time-depending frequency (e.g. linear chirp) for the measured object, and in a relatively short time-domain sliding analyzing window of the response signal, wherein the time instants of the sampling of the response signal are generated according to the pre-defined phase increments of the excitation signal and the mentioned sliding analysis window includes the pre-defined number of sequential response samples. This analysis in the mentioned short-time window can be implemented as the multiplication-and-accumulation of the response signal in parallel to first and second reference waveforms, one of which could be the sine-chirp waveform, similar to the excitation signal, and the other reference waveform could be the corresponding cosine-chirp, giving accordingly real and imaginary parts of the frequency response.'),('X554049     ','Leiutis on ette nähtud põlevkivi tahke soojuskandjaga töötlemisel saadud aurugaasisegu puhastamisel kasutatud põlevkiviõli raskfraktsiooni puhastamiseks selles puhastusprotsessis kogunenud tahketest osakestest. Selleks valmistatakse puhastamisele kuuluvast raskfraktsioonist, põlevkivibensiinist ja fenoolveest puhastatav segu, mida vajadusel töödeldaks flokulandiga ja mis seejärel lahutatakse tsentrifugaaldekanteris veefraktsiooniks, tahkeks fraktsiooniks ja orgaaniliseks fraktsiooniks. Veefraktsiooon juhitaks tagasi puhastatava segu valmistamise protsessi, tahke fraktsioon suunatakse pürolüüsi, orgaaniline fraktsioon lahutataks destillatsioonikolonnis põlevkivibensiiniks ja puhtaks põlevkiviõli raskfraktsiooniks.','The invention is provided for purifying shale oil heavy fraction having been contaminated with solid impurities in the process of wet purifying of the gas-vapour mixture obtained in the pyrolysis process of oil shale. For this, the composition to be purified is prepared from contaminated shale oil heavy fraction, petrol and phenol-water, which in case of necessity is additionally treated with flocculant. Subsequently, the mixture is separated in the centrifugal decanter to water fraction, solid fraction and organic fraction. The water fraction is sent back to the process of preparing the composition for purification, the solid fraction is sent for pyrolysis and the organic fraction is separated to the petrol and pure shale oil heavy fraction in a distillation device.'),('X554091     ','Leiutis käsitleb probiootilist mikroorganismi tüve Lactobacillus plantarum Inducia DSM 21379, mida saab kasutada antimikroobse agendina endogeenset ja/või eksogeenset päritolu Clostridium difficile põhjustatud kõhulahtisuse (CDAD) riski vähendamiseks C. difficile eoste germinatsiooni takistamise ja C. difficile vegetatiivsete rakkude paljunemise allasurumise teel. L. plantarum Inducia sobib kasutamiseks samaaegselt antibiootikumiraviga. Tüve L. plantarum Inducia sisaldavad C. difficile vastased kompositsioonid võivad lisaks sisaldada ka ksülitooli.','The invention relates to probiotic microorganism strain Lactobacillus plantarum Inducia DSM 21379 which can be used as an antimicrobial agent in lowering the risk of Clostridium difficile associated diarrhoea (CDAD) of endogenous or exogenous origin by preventing germination of C. difficile spores and by suppressing proliferation of C. difficile vegetative cells. L. plantarum Inducia can be used simultaneously with antibiotic treatment. The compositions against C. difficile may further comprise xylitol.');
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 (4,'Patendibüroo Ustervall OÜ','Sirje','Kahu','Kivi 21-6','Tartu','51009','EE'),(18,'LASVET Patendibüroo OÜ','Jaak','Ostrat','Suurtüki 4a','Tallinn','10133','EE'),(39,'Patendi- & Kaubamärgibüroo Koitel OÜ','Raivo','Koitel','Tina 26','Tallinn','10126','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 ('X554028     ',1),('X554045     ',1),('X554049     ',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 ('X554028','201801','B64F   1/00',1,1,1,1),('X554028','201801','B64F   1/12',2,1,1,2),('X554028','201801','B64F   1/22',2,1,1,3),('X554045','201701','G01N  27/00',1,1,1,1),('X554045','201701','G01R  23/00',2,1,1,2),('X554045','201701','G01R  31/00',2,1,1,3),('X554045','201701','G06F  17/00',2,1,1,4),('X554049','201801','C10G  31/10',1,1,1,1),('X554049','201801','B01D  21/26',2,1,1,2),('X554049','201801','B01D  21/01',2,1,1,3),('X554091','201801','A61K  35/747',1,1,1,1),('X554091','201801','A23L  33/135',2,1,1,2),('X554091','201801','A61P   1/12',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 ('X554028     ',4458,2),('X554028     ',14524,1),('X554028     ',14525,3),('X554028     ',14526,4),('X554045     ',14550,1),('X554045     ',14551,2),('X554045     ',14552,3),('X554045     ',14553,4),('X554045     ',14554,5),('X554049     ',12830,4),('X554049     ',14562,1),('X554049     ',14563,2),('X554049     ',14565,5),('X554049     ',14566,6),('X554049     ',14567,7),('X554091     ',13294,2),('X554091     ',13295,4),('X554091     ',13300,14),('X554091     ',13308,12),('X554091     ',13667,3),('X554091     ',14369,10),('X554091     ',14370,11),('X554091     ',14372,15),('X554091     ',14373,7),('X554091     ',14640,8),('X554091     ',14641,9),('X554091     ',14642,13);
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 (4458,'Toomas','','Haggi','Paasiku 4-301','EE','Tallinn','13916',''),(12830,'Nikolai','','Petrovits','Jaama 41','EE','Jõhvi','41532',''),(13294,'Marika','','Mikelsaar','Jakobsoni 11-4','EE','Tartu','51005',''),(13295,'Merle','','Rätsep','Alasi 31-49','EE','Tartu','50109',''),(13300,'Siiri','','Kõljalg','Elva 6','EE','Tartu','50404',''),(13308,'Kalle','','Kilk','Suur-Kaar 21-3','EE','Tartu','50404',''),(13667,'Epp','','Songisepp','Tähe 105-7','EE','Tartu','50107',''),(14369,'Epp','','Sepp','Kaarli pst 11-47','EE','Tallinn','10119',''),(14370,'Raik-Hiio','','Mikelsaar','Jakobsoni 11-4','EE','Tartu','51005',''),(14372,'Mirjam','','Vallas','Ravila 76-34','EE','Tartu','50408',''),(14373,'Pirje','','Hütt','Kulli 10-2','EE','Tartu','50416',''),(14524,'Tõnu','','Vaher','Untaugu 8, Neeme küla, Jõelähtme vald','EE','Harju maakond','74226',''),(14525,'Jaan','','Palm','Lodjapuu tee 14-1, Karla küla, Rae vald','EE','Harju maakond','75326',''),(14526,'Priit','','Leomar','Toominga tee 4, Haljava küla, Jõelähtme vald','EE','Harju maakond','75224',''),(14550,'Olev','','Märtens','Ehitajate tee 5','EE','Tallinn','19086',''),(14551,'Mart','','Min','Ehitajate tee 5','EE','Tallinn','19086',''),(14552,'Jaan','','Ojarand','Ehitajate tee 5','EE','Tallinn','19086',''),(14553,'Raul','','Land','Ehitajate tee 5','EE','Tallinn','19086',''),(14554,'Marek','','Rist','Ehitajate tee 5','EE','Tallinn','19086',''),(14562,'Nikolai','','Ostrouhhov','Põhja allee 24-30','EE','Kohtla-Järve','30324','Ida-Virumaa'),(14563,'Igor','','Velmar','Mureli 11','EE','Jõhvi','41535','Ida-Virumaa'),(14565,'Meelis','','Eldermann','Loomuse 9','EE','Tallinn','13516',''),(14566,'Alexander','','Fedotov','Võidu prospekt 1-47','EE','Narva','21008','Ida-Virumaa'),(14567,'Vasily','','Pivovarov','Ravi 6-5','EE','Kohtla-Järve','30322','Ida-Virumaa'),(14640,'Imbi','','Smidt','Nõo vald','EE','Tartu maakond','61622',''),(14641,'Kai','','Truusalu','Vanemuise 45-59','EE','Tartu','50107',''),(14642,'Jelena','','Stsepetova','Muru 12-28','EE','Tartu','50707','');
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 ('X554028     ',2525,1),('X554045     ',328,1),('X554049     ',2905,1),('X554091     ',3668,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',''),(2525,2,'','','','OÜ ELI','Haljas tee 25','EE','Tallinn','12012',''),(2905,2,'','','','VKG OIL AS','Järveküla tee 14','EE','Kohtla-Järve','30328',''),(3668,2,'','','','BioCC OÜ','Kreutzwaldi 1','EE','Tartu','51014','');
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;
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 ('X554091','US','244284','20140403',1),('X554091','EE','P201400038','20141031',2);
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 ('X554028     ','EE201600018',201600018,'EE05810','05810',2,'20180917','P201600018  ','20160831','Seade ja meetod mehitamata õhusõiduki automaatseks positsioneerimiseks maandumisplatvormil','A device and a method for automated positioning of an unmanned aerial vehicle on the landing platform',39),('X554045     ','EE201700005',201700005,'','',1,'20180917','P201700005  ','20170201','Meetod ja seade sageduskarakteristiku mõõtmiseks','Method and device for frequency response measurement',0),('X554049     ','EE201700009',201700009,'','',1,'20180917','P201700009  ','20170220','Meetod põlevkiviõli raskfraktsiooni puhastamiseks tahketest lisanditest','Method for purifying shale oil heavy fraction from solid impurities',18),('X554091     ','EE201800005',201800005,'EE05809','05809',2,'20180917','P201800005  ','20141031','Probiootilist mikroorganismi tüve Lactobacillus plantarum Inducia DSM 21379 sisaldav kompositsioon kasutamiseks Clostridium difficile põhjustatud kõhulahtisuse (CDAD) riski vähendamiseks','Composition comrising probiotic microorganism strain Lactobacillus plantarum Inducia DSM 21379 for use in reducing risk of Clostridium difficile associated diarrhoea (CDAD)',4);
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 */;

