-- 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 ('X554039','2018-08-15'),('X554040','2018-08-15'),('X554043','2018-08-15'),('X554044','2018-08-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 ('X554039     ','Leiutis on kasutatav juurviljakombainide või juurviljapealsekoristite koostisosana. Juurviljapeade puhasti, mis sisaldab sundajamiga varustatud rõhtsal võllil kahte tangentsiaalselt ühest otsast jäigalt kinnitatud peamist puhastuselementi, mille sundajamiga varustatud rõhtsa võlli külge kinnitamata välimised otsad on ühendatud sundajamiga varustatud rõhtsa võlliga elastse sidemete abi, ning radiaalselt vastassuundades paiknevaid täiendavaid puhastuselemente. Täiendavad puhastuselemendid on ?-kujulise ristlõikega, nende alus on kinnitatud sundajamiga varustatud rõhtsa võlli külge, aga kaks haru on paigutatud radiaalselt võlli telje sihis, nende sisemistele pindadele sirgjuhikutele on paigutatud kahe külgtoendi külge liikuv ja massiivne pinguti, mille välimine pind on tilgakujuline, mille venitatud ots on sundajamiga varustatud rõhtsa võlli pöörlemise suunas, aga sisemine pind on seotud sundajamiga varustatud rõhtsa võlliga survevedru kaudu. Täiendavate puhastuselementide otste vahele on paigutatud elastne lint, mis hõlmab pinguti välispinna, mille otsad on kinnitatud sundajamiga varustatud rõhtsa võlli külge täiendavate puhastuselementide mõlema külje poolt, aga elastse lindi tööpind on varustatud lühikeste sõrmedega.','This invention can be used as a component of root crop harvesters or root crop top harvesters. The device for topping unlifted root crops contains a forced-driven horizontal shaft with two main cleaning elements joined tangentially and rigidly from one end, and whose outer sides that are not connected to the forced-driven horizontal shaft are joined flexibly to the shaft, and additional cleaning elements, which are located in radially opposite directions. The additional cleaning elements have a ?-shaped cross-section, the base of which is attached to forced-driven horizontal shaft and two branches are located  radially in the direction of the shaft and its inner surfaces or straight guides feature a massive moving tensioner attached to the two side supports and the outer surface of which is drop-shaped and its extended part is in the rotational direction of the forced-driven shaft and its inner surface is attached to the forced-driven horizontal shaft using compression spring. Between the ends of additional cleaning elements there is an elastic band which covers the outer surface of the tensioner and its- ends have been attached to the forced-driven horizontal shaft from the both sides of additional cleaning elements and the working surface of the elastic band is equipped with short fingers.'),('X554040     ','Mugul- ja juurviljade edastamise ning sõelumise meetod, mille kohaselt mullast välja kaevatud mugula- ja juurikasegu juhitakse sõelumisalale, kus seda mõjutatakse sõelumisseadiste poolt aktiivselt ja  passiivselt, mugula- ja juurikasegu raputatakse, mille tulemusena peenestatakse selles sisalduv muld ja eraldatakse mugula- ja juurikasegust erinevate komponentidena ning suunatakse mugulad ja juurikad, muld ning taimejäänused sõelumisalalt välja. Mugul- ja juurviljade edastamise ning sõelumise seade sisaldab etteandekonveierit, põrkeharja, põrkepõlle, vibroraputit, mille kaarjasse külgmisse ja alumisse ossa on paigutatud sundajamiga varustatud harjapaarid, kahte jaotuskonveierit ja väljalaadimiskonveierit. Vibroraputi kaarjas külgmine ja alumine osa on koostatud kombinatsioonina järjestikustest ülemistest haaravatest ja alumistest puhastavatest vastassuunas pöörlevatest harjapaaridest, millel on erineva pikkusega varvad, nii et igal ülemisel ja alumisel harjapaaril on pikivertikaalsel tasapinnal kooniline eralduspilu, aga vibroraputi külgmises osas on kahe vastupidises suunas pöörleva püüdeharja vahel ristkülikukujuline läbiulatuv ava.','A method for conveying and separating tubers or root crops according to which the mixture of tubers or root crops and soil and plant residues that is dug up from soil is forwarded to the screening area where the screening devices process the mixture both actively and passively; the mixture of tubers or root crops is shaken, which breaks up the soil content and tubers or root crops are separated from the mixture as different components, and the tubers or root crops and soil and plant residues are removed from the screening area. The device for conveying and separating of tubers or root crops contains a feeding conveyor, a baffle brush, a baffle apron, a vibrating shaker which contains forced-driven pairs of brushes in its curved side and lower part, two distributor conveyors and unloading conveyor. The curved side and lower part of the vibrating shaker contains a combination of successive pairs of brushes, which feature upper gripping brushes and lower cleaning brushes rotating in opposite directions and which are characterised by bristles of various lengths in a way that each of the upper and lower pair of brushes forms a conical separating opening on longitudinal vertical plane; however, there is a rectangle-shaped penetrating opening between the two collector brushes rotating in the opposite directions in the side part of the vibrating shaker.'),('X554043     ','Leiutis käsitleb mullaparanduspreparaati, mis sisaldab segu orgaanilisest sõnnikust, nagu loomuliku niiskusega kodulinnuväljaheiteid, koos põlevkivitööstuse tahke jäätmega ja/või mullaparendamisainega. Samuti käsitleb leiutis meetodit mullaparanduspreparaadi valmistamiseks. Kuna mullaparanduspreparaadi komponendid on täielikult looduslikud, võib seda klassifitseerida orgaaniliseks väetiseks.','The invention relates to a soil conditioner comprising of a mixture of organic manure such as poultry excrements having natural moisture with oil shale industrial solid waste and/or soil improvement substance. The invention also relates to a method for producing the soil conditioner. As the components of the soil conditioner are completely natural, it can be classified as organic fertilizer.'),('X554044     ','Leiutis käsitleb süsteemi ja meetodit hoone ventilatsiooni tõhustamiseks ja hoonest välja tõmmatavalt ventilatsiooniõhult saadava soojuse ärakasutamiseks hoone tarbeks. Leiutises rakendatakse loomulikku ventilatsiooni sundventilatsiooni vähendamiseks, saavutades parema SFP. Samuti lisatakse hoone ventilatsioonile ventilatsiooniga seonduva energiasäästu tagamiseks soojustagastussüsteem.','The invention relates to a system and method for improving a ventilation of a building and using heat from withdrawable ventilation air for the benefit of a building. Natural ventilation is used in the invention to reduce forced ventilation, achieving enhanced SFP. Also a heat returning system is added to the ventilation of the building to provide ventilation-related energy savings.'),('X554052     ','Leiutis käsitleb meetodit piiriületuse virtuaalse järjekorra moodustamiseks ja rakendamiseks piiriületusel, kus piiriületuse teeninduspunkti jõudlus on piiratud või ebaühtlane ja kus teenuse pakkumise piiratud ressursside ja piiriületusest huvitatud sõidukite suure hulga tõttu on tekkinud piiriületajatest pika ooteajaga järjekord. Meetodi eesmärgiks on parandada sõidukite riikidevaheliste piiriületuse teeninduspunktide jõudlust, suurendada piiriületusel piiriületajatele pakutavate teenuste efektiivsust, parandada piiripunktides sõidukitest tekkivate järjekordade organiseerimist ja piiriületajate aja planeerimist ning vähendada piiriületajate piiripunktis viibimise aega. Meetod hõlmab järgmisi etappe: piiriületajate tehniliste vahendite kasutajaliidestest edastatakse informatsioon piiripunkti järjekorra kontroll- ja haldusmoodulile esimesest võimalikust ajast piiripunkti oote- ja puhkealasse jõudmiseks; kogutakse edastatud informatsioon, mille baasil moodustatakse virtuaalne järjekord,  järjestades piiriületajate oote- ja puhkealasse jõudmise esimesed võimalikud ajad vastavalt edastatud informatsioonis sisaldunud aegadele; piiripunkti teeninduspunktist edastatakse informatsioon järjekorra kontroll- ja haldusmoodulile uute piiriületajate piiripunkti saatmise ajast; arvutatakse iga teeninduspunkti kontrolli läbinud piiriületajast informatsiooni edastamise järgselt uus keskmise teenindustsükli kestus.','Method for creating and implementing a virtual queue of border crossers at border crossing, where the resources and capacity of the service point of border crossing are limited or uneven and queues with long waiting periods are caused by large number of vehicles crossing the border. The aim of the method is to improve capacity of the service points of the interstate border crossing, increase the efficiency of the services provided during the border crossing, improve the organization of queues of vehicles at border crossing check points, and time planning during the border crossing, and reduce the time spent crossing the border at border service point. The method comprises the steps of transferring the information of the border-crossers\' first possible times to reach to the waiting area of the border crossing from user interfaces of technical means to the control and management unit; forming the virtual queue on the basis of the collected information by arranging the first possible times to reach to the waiting area of border-crossers; from border crossing service point transferring the information when to send the new border-crossers to the check point to the control and management unit; after each passing the border crossing calculates a new duration of the average service cycle.'),('X554103     ','Leiutis kuulub madala orgaanilise osa sisaldusega tahkete kütuste termilise töötlemise valdkonda ja seda saab kasutada kütuseid ümbertöötlevas tööstuses. Põlevkivi või ka teiste madala orgaanilise osa sisaldusega kütuste töötlemine näeb ette kütuse kuivatamise suitsugaasidega, täkke faasi eraldamise soojuskandjaks, tooraine pürolüüsi reaktoris, auru-gaasisegu ja koksi-ja tuhasegu jäägi lahutamise  setitamiskambris, tuha eraldamise, suitsugaaside jahutamise ning koksi- ja tuhasegu jäägi põletamise. Seade meetodi realiseerimiseks sisaldab järjestikku ühendatud reaktori, selituskambri, aerofontäänkolde, soojuskandja tsükloni, tuhatsükloni, soojuse utiliseerimise süsteemi ning tuhaärastussüsteemi ja inertse materjali punkri, mis on ühendatud koksi- ja tuhasegu jäägi põletamise kambri väljundiga. Leiutis võimaldab põlevkivi energeetilise potentsiaali täielikuma ärakasutamise ja ümbritsevale keskkonnale vähemohtliku jääkprodukti (põlevkivituha). Sellist jääkprodukti saab kasutada ärakasutatud põlevkivi-karjääride rekultiveerimiseks.','The invention relates to thermal conversion of solid fuels with a low organic content and can be used in the fuel-processing industry. Conversion of oil shale or high-ash solid fuel comprises flue-gas drying of feedstock, recovering the solid phase as a heat-carrying agent, feedstock pyrolysis in a reactor, separating a gas-vapour mixture from a coke-ash residue in a dust-settling chamber, discharging ash, cooling flue gases, and combustion of the coke-ash residue. An inert material having an ambient temperature is supplied at the point of an outlet of the coke-ash residue combustion chamber. The plant comprises, arranged in series, a reactor, the dust-settling chamber, a flash-process furnace, a heat-carrier cyclone, an ash cyclone, a waste-heat recovery system, an ash-discharge system and a bin for inert material connected with the outlet of the coke-ash residue combustion chamber. The invention allows for a more complete use of the oil shale energy potential and for obtaining ash with a reduced negative effect on the environment, which makes it possible to use the ash for recultivation of quarries resulting from oil shale mining.');
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 (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'),(48,'Sarap ja Putk Patendibüroo','Mikk','Putk','Kiriku 6','Tallinn','10130','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 ('X554039     ',1),('X554040     ',1),('X554052     ',1),('X554103     ',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 ('X554039','201701','A01D  23/02',1,1,1,1),('X554039','201701','A01D  27/04',1,1,1,2),('X554039','201701','A01D  33/02',1,1,1,3),('X554040','201701','A01D  33/00',1,1,1,1),('X554040','201701','A01D  33/08',1,1,1,2),('X554043','201801','C05G   1/00',1,1,1,1),('X554043','201801','C05G   3/04',2,1,1,2),('X554043','201801','C05F   3/02',2,1,1,3),('X554044','201701','F24F  11/00',1,1,1,1),('X554044','201701','F24F   7/00',2,1,1,2),('X554044','201701','G05D  23/19',2,1,1,3),('X554044','201701','G05D   7/06',2,1,1,4),('X554052','201701','G08G   1/00',1,1,1,1),('X554052','201701','G06Q  10/00',2,1,1,2),('X554103','201801','C10B  53/06',1,1,1,1),('X554103','201801','C10B  49/18',2,1,1,2);
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 ('X554039     ',13526,2),('X554039     ',14121,1),('X554039     ',14544,3),('X554039     ',14545,4),('X554040     ',13526,2),('X554040     ',14121,1),('X554040     ',14544,3),('X554040     ',14545,4),('X554043     ',14548,1),('X554044     ',14549,1),('X554052     ',14569,1),('X554103     ',14661,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 (13526,'Margus','','Arak','Akvarelli 10','EE','Tartu','51011',''),(14121,'Jüri','','Olt','Keskasula 21, Kuremaa','EE','Jõgeva maakond','48445',''),(14544,'Volodymyr','','Bulgakov','Heroyiv Oborony 15','UA','Kiiev','03041',''),(14545,'Valerii','','Adamchuk','Vokzalna 11, Glevakha-1, Vasylkivi rajoon','UA','Kiiev','08631',''),(14548,'Markus Kristian','','Aho','Vanhankyläntie 20','FI','Kiikala','25390',''),(14549,'Indrek','','Pihtjõe','Vabaõhumuuseumi tee 4c-32','EE','Tallinn','13522',''),(14569,'Toivo','','Kuldkepp','Paul Kerese 52','EE','Tallinn','11215',''),(14661,'Igor','','Bidilo','Suur-Patarei 2-21','EE','Tallinn','10415','');
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 ('X554039     ',3387,1),('X554040     ',3387,1),('X554043     ',3637,1),('X554044     ',3638,1),('X554052     ',3645,1),('X554103     ',3696,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 (3387,2,'','','','Eesti Maaülikool','Fr. R. Kreutzwaldi 1a','EE','Tartu','51014',''),(3637,2,'','','','Eesti Väetis OÜ','Tiskre tee 18, Haabersti linnaosa','EE','Tallinn','13516',''),(3638,2,'','','','OÜ Varpo Grupp','Kadaka tee 187c','EE','Tallinn','12617',''),(3645,2,'','','','ERAA Eesti Rahvusvaheliste Autovedajate Assotsiatsioon','Narva mnt. 91','EE','Tallinn','10127',''),(3696,2,'','','','AKTCIONERNOE OBSHCHESTVO \'\'ATEK GRUPP\'\'','Kutuzovskiy prospect,11','RU','Moscow','121248','');
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 ('X554103     ','RU','2016/00079','WO','17/099629','20170615');
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 ('X554052','EE','P200900085','20160805',1),('X554103','RU','RU2015153090','20151210',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 ('X554039     ','EE201600029',201600029,'','',1,'20180815','P201600029  ','20161229','Juurviljapeade puhasti','Device for topping unlifted root crops',0),('X554040     ','EE201600030',201600030,'','',1,'20180815','P201600030  ','20161229','Mugul- ja juurviljade edastamise ning sõelumise meetod ja seade','A method and device for conveying and separating tubers and root crops',0),('X554043     ','EE201700003',201700003,'','',1,'20180815','P201700003  ','20170120','Mullaparanduspreparaat ja meetod selle valmistamiseks','Soil conditioner and method for producing the same',39),('X554044     ','EE201700004',201700004,'','',1,'20180815','P201700004  ','20170125','Süsteem ja meetod hoone ventilatsiooni tõhustamiseks','System and method for improving a ventilation of a building',39),('X554052     ','EE201700012',201700012,'','',1,'20180815','P201700012  ','20170311','Elektrooniline süsteem ja meetod piiriületuse virtuaalse järjekorra moodustamiseks ja rakendamiseks sõidukitega piiriületajatele','Electronic system and method for creating virtual queue of border crossing with vehicles and implementing at border crossing',48),('X554103     ','EE201800015',201800015,'','',1,'20180815','P201800015  ','20161130','Meetod ja seade põlevkivi või teiste madala orgaanilise osa sisaldusega tahkete kütuste termiliseks töötlemiseks','Method and apparatus for thermal processing of oil shale or other solid fuels having low concentration of organic part',18);
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 */;

