-- 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 ('X2383','2016-01-15'),('X2409','2016-01-15'),('X2446','2016-01-15'),('X2447','2016-01-15'),('X2467','2016-01-15'),('X2492','2016-01-15'),('X2493','2016-01-15'),('X2513','2016-01-15'),('X2516','2016-01-15'),('X2526','2016-01-15'),('X2527','2016-01-15'),('X2528','2016-01-15'),('X2541','2016-01-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 ('X2383       ','Leiutis käsitleb meetodit vääveldioksiidi ja lämmastikdioksiidi kõrvaldamiseks suitsugaasidest, mis on saadud fossiilkütuste (põlevkivi, kivisüsi jt) põletamisel. Suitsugaasid juhitakse absorbeerivast vedelikust läbi, mille tulemusena eemaldatakse suitsugaasidest vääveldioksiid ja lämmastikdioksiid.','The invention concerns a method for purification of sulfur dioxide and nitrogen dioxide from flue gases, which is derived from fossil fuels (oil shale, coal and others) burning. The flue gases drawn through the liquid with absorbent and as a result the flue gases become free of sulfur dioxide and nitrogen dioxide.'),('X2409       ','Infotehnoloogiline süsteem kiirabiteenuse osutamise hõlbustamiseks sisaldab erakorralise meditsiiniteenuse pakkuja keskserverit ning vähemalt ühte kiirabitöötaja mobiiliseadet kiirabipatsiendi vigastusi puudutava informatsiooni sisestamiseks ja edastamiseks keskserverile. Mobiiliseade on nutitelefon või tahvelarvuti ning mobiiliseade on keskserveriga ühendatud traadita andmesidevõrgu kaudu. Mobiilseade on seadistatud kuvama mobiiliseadme ekraanile info sisestamiseks kohandatud lehekülgi, kusjuures info sisestamiseks kohandatud lehekülgi on kuni neli ning info sisestamiseks kohandatud leheküljed on kohandatud kiirabipatsiendi vigastusi puudutava eluliselt  tähtsa   info vastuvõtmiseks. Info sisestamiseks kuvatakse ekraanidele slaideri-, nupu-, märkeruuudu- ning raadionupu-tüüpi elemendid.','An information technology system for providing emergency services, comprising central server of the emergency services provider and at least one mobile device of the ambulance employee for entering information concerning injuries of the ambulance patient and transmitting this information to the central server. A mobile device is a smart phone or a tablet computer and the mobile device is connected with the central server via wireless data network. The mobile device is set to display pages on the screen of the mobile device that are adapted for entering the information, whereby up to 4 pages are adapted for entering the information and the pages that are adapted for entering the information are adapted for receiving vital information concerning injuries of the ambulance patient. On the screens there are a displayed slider, a button, a check box and a radio button type elements for entering the information.'),('X2446       ','Reguleeritav jalatsihoidik, mis sisaldab ülemist osa, millel on esimene pind ja esimene pööratav osa ning alumist osa, millel on teine pind ja teine pööratav osa koos eendiga, mis on sisestatav esimese pööratava osa avasse ning reguleerimisvahendit. Ülemine osa ja alumine osa on üksteisega liigendühenduses ning ülemise ja alumise osa vahele on ühendatud reguleerimisvahend, mille abil saab seada ülemise ja alumise osa vahelist nurka. Jalatsihoidiku jaoks vaja minevat ruumi saab reguleerida vastavalt jalatsite väljapaneku eesmärgile.','An adjustable shoe rack includes a top part having a first surface and a first pivotal portion and a bottom part having a second surface and a second pivotal portion, which has a protrusion for being pivotably engaged with the hole of the first pivotal portion and an adjustment device. The top part and the bottom part are pivotably connected to each other and the adjustment device is connected between the top and bottom parts to set the desired angular distance between the top and bottom parts. The space required for the shoes frame can be adjusted according to the purposes of the display of the shoes.'),('X2447       ','Reguleeritav jalatsihoidik, mis sisaldab ülemist osa, millel on esimene pind ja esimene pööratav osa ning alumist osa, millel on teine pind ja teine pööratav osa koos eendiga, mis on sisestatav esimese pööratava osa avasse ning reguleerimisvahendit. Ülemine osa ja alumine osa on üksteisega liigendühenduses ning ülemise ja alumise osa vahele on ühendatud reguleerimisvahend, mille abil saab seada ülemise ja alumise osa vahelist nurka. Jalatsihoidiku jaoks vaja minevat ruumi saab reguleerida vastavalt jalatsite väljapaneku eesmärgile.','An adjustable shoe rack includes a top part having a first surface and a first pivotal portion and a bottom part having a second surface and a second pivotal portion, which has a protrusion for being pivotably engaged with the hole of the first pivotal portion and an adjustment device. The top part and the bottom part are pivotably connected to each other and the adjustment device is connected between the top and bottom parts to set the desired angular distance between the top and bottom parts. The space required for the shoes frame can be adjusted according to the purposes of the display of the shoes.'),('X2467       ','Leiutise objektiks on korrapäraste kõverjooneliste servadega moodulitest laotud pinnakate. Nimetatud pinnakattemoodulid sisaldavad mitut pinnakatteelementi, millest vähemalt äärmiste elementide välimise serva kuju on vastavates külgnevates moodulites korrapäraselt korduv.','The present invention relates to a surface covering formed of modules having regular curvilinear edges. Modules of the surface covering comprise multiple surface covering elements, where the shapes at least outer edges of the outmost elements in corresponding adjacent modules are regularly reoccurring.'),('X2492       ','Käesolev leiutis seondub kuumaõhuahjuga, mis sisaldab mitmeid soojusülekandetorusid. Iga pikliku ristlõikega soojusülekandetoru (333) sisse on paigutatud vähemalt üks pikisuunaline sisesein (363\', 363\'\'), mis ulatub pikliku ristlõikega soojusülekandetoru (333) sisepinna ühest küljest sisepinna vastaskülje poole.','The present invention relates to a hot air oven comprising a plurality of heat exchanger tubes. Each elongated tube (333) is provided with at least one longitudinally extending interior wall (363\', 363\") which extends from one side of the interior surface of the elongated tube (333) towards another side of the interior surface.'),('X2493       ','Küpsetusriiuliga kuumaõhuahi toorproduktide küpsetamiseks kuumaõhuahju küpsetuskambris oleval küpsetusriiulil, kusjuures küpsetuskambri kambriuksel on olemuslikult sama kumerusraadius kui küpsetuskambri kumerdatud pinnaosadel, kambriust on võimalik nihutada ukseava ühele küljele ning ukseavale vastab ringikaar, millele vastav kesknurga väärtus on vahemikus 60° kuni 100°. Küpsetuskambril koos kumerdatud kambriuksega on olemuslikult ringjas ristlõige.','Hot air rack oven for baking goods on a rack inside an oven chamber, wherein the chamber door is curved with essentially the same diameter as the oven chamber. It is possible to slide the chamber door laterally to one side of the opening, and that the door opening subtends an angle which at the innermost edges of the opening is between 60° and 100°. The oven chamber, including the curved door, has a substantially circular cross section.'),('X2513       ','Mitmeotstarbeline spordiseade,  mis on eriti ette nähtud jalgpallurite tehniliste oskuste arendamiseks, sisaldab mängupinnaga (11) aluskeha (10), millel on kumer ülapind (15), aluskehale (10) paigaldatud takistust (20) ja tugistruktuuri (30), mis eraldab mängupinda (11) alusest (2). Tugistruktuuril (30) on täiendav kõrguse reguleerimise sõlm (31), millel on üks ühendusdetail (31a), mis kinnitatakse tugistruktuurile (30), ja teine, mängupinda (11) sisaldavale aluskehale (10) paigaldatud ühendusdetail (31b), ja lülituskomponent (31c), mis paigutatakse ühe ühendusdetaili (31a) ja teise ühendusdetaili (31b) vahele. Aluskehal (10) on ülapinnaga (15) sobitatud ülemine lüli (10a), mis sisaldab mängupinda (11), ja alumine lüli (10b), mis asetseb ülemise lüli (10a) all, kusjuures ülemine lüli (10a) on tehtud painduvast materjalist ja alumine lüli (10b) jäigast materjalist, ning lisaks on sellel kõveruse reguleerimise mehhanism (40), muutmaks ülemise lüli kõverust, ja kõveruse reguleerimise mehhanism (40) on paigutatud ülemise lüli (10a) ja tugistruktuuri (30) vahele.','A multi-purpose sports apparatus, particularly for improving footballers\' technical skills, comprising a foundation body (10) with a playing surface (11) having a convex top surface (15) looking from the interior of the foundation body (10), an obstacle (20) arranged on the foundation body (10), and a support structure (30) separating the playing surface (11) from the base (2). The support structure (30) has an additional height adjustment unit (31) which has one connecting body (31a) fastened to the support structure (30) and another connecting body (31b) attached to the foundation body (10) containing the playing area (11), and an actuator component (31c) interposed between one connecting body (31a) and the other connecting body (31b), and the foundation body (10) has an upper member (10a) fitted with the top surface (15) containing the playing area (11) and a lower member (10b) located under the upper member, where the upper member (10a) is made of flexible material and the lower member (10b) of rigid material, and furthermore has a curvature adjustment mechanism (40) to alter the curvature of the upper member (10a), said curvature adjustment mechanism (40) is interposed between the upper member (10a) and the support structure (30).'),('X2516       ','Käesolev leiutis käsitleb lahtiühendatavat toruliitmikku. Toruliitmik 1 sisaldab kahte ühendusdetaili 2, 3 ja nende kokku ühendamiseks ülemutrit 5 ning ühendusdetailide 2, 3 vahel tihendit 4. Ülemutriga 5 on ühendusdetailide 2, 3 otspinnad 6, 7 surutud tihendamiseks vastu tihendit 7. Ühendusdetailide 6, 7 otspinnad 6, 7 on varustatud soontega 8.','Present inventions relates to a detachable tube union. Union 1 comprises of two connection pieces 2, 3 and a union nut 5 for joining connection pieces together and between connection pieces 2, 3 a gasket 4 is placed. For sealing the faces 6, 7 of the connection pieces 2, 3 are pressed by the union nut 5 against gasket 4. The faces 6, 7 of the connection pieces 2, 3 are provided with grooves 8.'),('X2526       ','Käesoleva leiutise ülesandeks on uudse, põdrasamblikku ja šokolaadi sisaldava maiustuse väljatöötamine. Püstitatud ülesanne saavutatakse põdrasamblikku töödeldes. Kõigepealt puhastatakse samblik ja seejärel keedetakse vees 30 minutit. Seejärel küpsetatakse samblik ahjus 100 kraadi juures 30 minuti jooksul. Kui samblik on jahtunud, kaetakse see tumeda šokolaadi, piimašokolaadi või valge šokolaadiga ja nii saavutatakse uudse maitse ja tekstuuriga maiustus','The goal of this invention is to create a new sweet product containing cladonia and chocolate. This will be achieved by going through a specific cooking procedure. First, the cladonia is cleaned and boilt for 30 minutes. Then it is baked in the oven at 100 degrees Celsius for 30 minutes. After the cladonia has cooled, it is covered with white, dark or milk chocolate and this way a new sweet product with interesting texture and taste is achieved.'),('X2527       ','Käesoleva leiutise ülesandeks on uudse, šokolaadi ja nurmenukku sisaldava toote väljatöötamine. Püstitatud ülesanne saavutatakse, kui keedetakse nurmenukku koores, lisatakse šokolaad ja valmistatakse  sellest kommi sisu. Sisu pritsitakse pritskotiga valge šokolaadi, tumeda šokolaadi või piimašokolaadi kesta sisse ning kaunistatakse komm lõpuks kuivatatud nurmenukuga. Ühendatud on kaks tervisele kasulikku ainet, nurmenukk ja šokolaad.','The goal of this invention is to create a new product containing chocolate and cowslip. This will be achieved by boiling the cowslip in the whipping cream, adding chocolate and creating a filling. This filling is piped with a piping bag into a chocolate shell made of white, milk or dark chocolate and finally decorated with dried cowslip. This product combines two healthy ingredients, chocolate and cowslip.'),('X2528       ','Käesoleva leiutise ülesandeks on uudse, šokolaadi ja marja- või kuusevõrsepuistet sisaldava toote väljatöötamine. Püstitatud ülesanne saavutatakse, kui valmistatakse ümmargune komm kas valgest šokolaadist, piimašokolaadist või tumedast šokolaadist. Enne puiste lisamist veeretatakse kommi šokolaadiste käte vahel ja seejärel veeretatakse seda kommi omakorda puiste sees. Kattel lastakse tahkuda. Selle tagajärjel tekib värvilise puistega kaetud komm. Seega on ühendatud kaks tervisele kasulikku ainet, marja-/kuusevõrsepuiste ja šokolaad.','The goal of this invention is to create a new product containing chocolate and dried berries or spruce sprout powder. This will be achieved by making a round truffle from white, milk or dark chocolate. This round truffle is then turned in melted chocolate and after that in the berry/spruce sprout powder. As a result, a colourful round truffle which combines two healthy ingredients: chocolate and berry/spruce sprout powder, is created.'),('X2541       ','Käesolev leiutis käsitleb meetodit tahke kütuse ja gaasilise kütuse koospõletamiseks tsirkuleeriva keevkiviga katlas. Meetodi eripäraks on see, et põlevgaasi antakse keevkihi kohal olevasse ruumi segus katla retsirkulatsiooni suitsugaasidega, mis võetakse vähemalt ühest katla gaasikäikude punktist ja juhitakse kokkusegamisele põlevgaasiga retsirkulatsiooni tõmbeventilaatori abil.','Present invention relates to a method of co-firing of solid and gaseous fuels in a boiler with circulating fluidized bed. The method is characterized by that the fuel gas is supplied to the space above the fluid-bed in a mix with the flue gas recirculation, which are taken from at least one point of the flue gas ducts of the boiler and fed for mixing with fuel gas by flue gas recirculation fan of flue gas recirculation.');
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 (15,'OÜ Moorlat & Ko Patendibüroo','Ott','Moorlat','pk 4730','Tallinn','13503','EE'),(35,'KOPPEL patendibüroo OÜ','Mart Enn','Koppel','Roseni 10-151','Tallinn','10111','EE'),(37,'Patendibüroo Turvaja OÜ','Riho','Pikkor','Liivalaia 22','Tallinn','10118','EE'),(41,'Patendi- & Kaubamärgibüroo Koitel OÜ','Raivo','Koitel','Tina 26','Tallinn','10126','EE'),(46,'LASVET Patendibüroo OÜ','Jürgen','Toome','Suurtüki 4a','Tallinn','10133','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 ('X2383       ',1),('X2446       ',1),('X2447       ',1),('X2467       ',1),('X2492       ',1),('X2493       ',1),('X2513       ',1),('X2516       ',1),('X2541       ',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 ('X2383','201501','B01D  53/14',1,1,1,1),('X2409','201501','G06Q  50/22',1,1,1,1),('X2409','201501','G06Q  50/24',2,1,1,2),('X2409','201501','G06F  19/00',2,1,1,3),('X2446','201501','A47F   7/08',1,1,1,1),('X2446','201501','A47B  61/04',2,1,1,2),('X2446','201501','A47F   5/12',2,1,1,3),('X2447','201501','A47F   7/08',1,1,1,1),('X2447','201501','A47B  61/04',2,1,1,2),('X2447','201501','A47F   5/12',2,1,1,3),('X2467','201501','E04F  13/072',1,1,1,1),('X2467','201501','E04F  15/00',2,1,1,2),('X2467','201501','E04C   2/30',2,1,1,3),('X2492','201501','A21B   1/26',1,1,1,1),('X2492','201501','F28F   1/40',2,1,1,2),('X2493','201501','A21B   1/44',1,1,1,1),('X2493','201501','A21B   3/02',2,1,1,2),('X2513','201501','A63B  67/04',1,1,1,1),('X2513','201501','A63B  69/00',2,1,1,2),('X2516','201501','F16L  19/00',1,1,1,1),('X2516','201501','F16L  19/03',1,1,1,2),('X2516','201501','F16L  21/04',1,1,1,3),('X2516','201501','F16L  27/00',1,1,1,4),('X2526','201501','A23G   1/48',1,1,1,1),('X2527','201501','A23G   1/48',1,1,1,1),('X2528','201501','A23G   1/54',1,1,1,1),('X2528','201501','A23G   3/48',2,1,1,2),('X2541','201501','F23C  10/00',1,1,1,1);
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 ('X2383       ',2191,1),('X2409       ',2226,1),('X2446       ',2272,1),('X2447       ',2272,1),('X2467       ',2125,1),('X2492       ',2322,1),('X2493       ',2322,1),('X2493       ',2323,2),('X2493       ',2324,3),('X2513       ',2345,1),('X2516       ',2349,1),('X2526       ',2211,1),('X2527       ',2211,1),('X2528       ',2211,1),('X2541       ',2093,2),('X2541       ',2367,3),('X2541       ',2368,4),('X2541       ',2369,5);
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 (2093,'Vladimir','','Sidorkin','Sulevi 6','EE','Jõhvi','41535     ',''),(2125,'Hannes','','Tarn','Vana-Kalamaja 22','EE','Tallinn','10414     ',''),(2191,'Vladimir','','Matrossov','Paldiski mnt 227-190','EE','Tallinn','13520     ',''),(2211,'Kristi','','Lehtis','Mureli 18','EE','Tartu','50405     ',''),(2226,'Rauno','','Viitmann','Uus-Lehise, Kirna küla, Türi vald','EE','Järva maakond','72231     ','.'),(2272,'Ming-Te','','Chen','No. 2, Lane 334, San-Fon Road, Fon Chou City','TW','Taichung Hsien','42072     ',''),(2322,'Olof','','Engström','Bryggarvägen 7','SE','Huddinge','S-14140   ',''),(2323,'Magnus','','Krabbe','Soltorpsvägen 8','SE','Stenhamra','S-17961   ',''),(2324,'Per','','Junesand','Dalagatan 16','SE','Stockholm','SE-11324  ',''),(2345,'Gábor','','Borsányi','Fanyarka Street 1','HU','Budapest','HU-1037   ',''),(2349,'Sven','','Selgis','Sarapuu 6, Kangru alevik, Kiili vald','EE','Harju maakond','75403     ',''),(2367,'Andrei','','Tugov','Gagarini 76-59,','RU','Tšehhov, Moskva oblast 142300','',''),(2368,'Konstantin','','Bersenev','Tarna 2-3','EE','Kohtla-Järve','30721     ',''),(2369,'Georgy','','Ryabov','Beresovoi Roshi proezd, 6-11','RU','Moskva 125252','','');
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 ('X2383       ',1610,1),('X2409       ',1636,1),('X2446       ',1686,1),('X2447       ',1686,1),('X2467       ',1560,1),('X2492       ',1737,1),('X2493       ',1737,1),('X2513       ',1755,1),('X2516       ',1758,1),('X2526       ',1623,1),('X2527       ',1623,1),('X2528       ',1623,1),('X2541       ',1776,2);
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 (1560,2,'','','','Bole OÜ','Lõuna 6B, Paldiski','EE','Harju maakond','76805',''),(1610,1,'Vladimir','','Matrossov','','Paldiski mnt 227-190','EE','Tallinn','13520',''),(1623,1,'Kristi','','Lehtis','','Mureli 18','EE','Tartu','50405',''),(1636,2,'','','','Digimist OÜ','Uus-Lehise, Kirna küla, Türi vald','EE','Järva maakond','72231',''),(1686,1,'Ming-Te','','Chen','','No. 2, Lane 334, San-Fon Road, Fon Chou City','TW','Taichung Hsien','42072',''),(1737,2,'','','','Revent International AB','Box 714','SE','Upplands Väsby','S-19427',''),(1755,2,'','','','Teqball Holding S.Á R.L.','Avenue John F. Kennedy 44','LU','Luxembourg','L-1855',''),(1758,2,'','','','Vise Tootmine OÜ','Kadaka tee 42f','EE','Tallinn','12915',''),(1776,1,'','','ENTEH Engineering AS','','Elektriku 3','EE','Kohtla-Järve','30328','');
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 ('X2492       ','SE','2013/05106','WO','14/042585','20140320'),('X2493       ','SE','2013/05105','WO','14/042579','20140320'),('X2513       ','HU','2013/00010','WO','14/076515','20140522');
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 ('X2446','US','004935','20110112',1),('X2447','US','004935','20110112',1),('X2492','SE','1251030-1','20120914',1),('X2493','SE','1251022-8','20120912',1),('X2513','HU','4206 (U1200223)','20121114',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 ('X2383       ','EE201400005',201400005,'EE01338','01338',1,'20160115','U201400005  ','20140131','Meetod suitsugaaside puhastamiseks vääveldioksiidist ja lämmastikdioksiidist','The method of flue gases purification from sulphur dioxide and nitrogen dioxide',15),('X2409       ','EE201400028',201400028,'EE01342','01342',1,'20160115','U201400028  ','20140424','Infotehnoloogiline süsteem kiirabiteenuse osutamise hõlbustamiseks','An information technology system for facilitating providing emergency services',35),('X2446       ','EE201400061',201400061,'EE01335','01335',1,'20160115','U201400061  ','20120112','Reguleeritav jalatsihoidik','Adjustable shoe rack',41),('X2447       ','EE201400062',201400062,'EE01336','01336',1,'20160115','U201400062  ','20120112','Reguleeritav jalatsihoidik','Adjustable shoe rack',41),('X2467       ','EE201400082',201400082,'EE01339','01339',1,'20160115','U201400082  ','20141231','Korrapäraste kõverjooneliste servadega moodulitest pinnakate','Surface covering made of modules having regular curvilinear edges',46),('X2492       ','EE201500023',201500023,'EE01330','01330',1,'20160115','U201500023  ','20130913','Kuumaõhuahi','Hot air oven',37),('X2493       ','EE201500024',201500024,'EE01331','01331',1,'20160115','U201500024  ','20130911','Küpsetusriiuliga kuumaõhuahi','Hot air rack oven',37),('X2513       ','EE201500044',201500044,'EE01337','01337',1,'20160115','U201500044  ','20131113','Mitmeotstarbeline spordiseade','Multi-purpose sports apparatus',41),('X2516       ','EE201500047',201500047,'EE01340','01340',1,'20160115','U201500047  ','20150616','Lahtiühendatav toruliitmik','Detachable tube union',46),('X2526       ','EE201500057',201500057,'EE01332','01332',1,'20160115','U201500057  ','20150812','Põdrasamblikumaiustus','Reindeer moss sweets',0),('X2527       ','EE201500058',201500058,'EE01333','01333',1,'20160115','U201500058  ','20150812','Lille sisaldav maiustus','Sweets containing flower',0),('X2528       ','EE201500059',201500059,'EE01334','01334',1,'20160115','U201500059  ','20150812','Värviline komm','Colourful sweets',0),('X2541       ','EE201500070',201500070,'EE01341','01341',1,'20160115','U201500070  ','20151002','Meetod tahke kütuse ja gaasilise kütuse koospõletamiseks tsirkuleeriva keevkiviga katlas','A method of co-firing of solid and gaseous fuels in a boiler with circulating fluidized bed',46);
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 */;