-- 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 ('X551549','2016-07-15'),('X553904','2016-07-15'),('X553909','2016-07-15'),('X553920','2016-07-15'),('X553923','2016-07-15'),('X553943','2016-07-15'),('X553950','2016-07-15'),('X553951','2016-07-15'),('X553980','2016-07-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 ('X551549     ','Käesolev leiutis käsitleb kinuklidiinderivaate valemiga (I), milles © on fenüültuum, C4-9-heteroaromaatne rühm, mis sisaldab ühte või mitut heteroaatomit, või naftalenüül-, 5,6,7,8-tetrahüdronaftalenüül- või bifenüülrühm. Nendel ühenditel on tugev afiinsus M3-muskariiniretseptorite suhtes. Samuti käsitleb leiutis nende ühendite valmistamismeetodit, vaheühendeid, farmatseutilist kompositsiooni ja nende kasutamist.','The present invention relates to quinuclidine derivatives of formula (I) wherein ( is a phenyl ring, a C4 to C9 heteroaromatic compound containing one or more heteroatoms, or a naphthalenyl, 5,6,7,8tetrahydronaphthalenyl or biphenyl group. These compounds show high affinity for muscarinic M3 receptors. This invention relates also to a method of preparation, intermediates, a pharmaceutical composition and use thereof.'),('X553904     ','Leiutiseks on elektriline seade mudavanni protseduuri teostamiseks jäsemetele, mis võimaldab teostada protseduuri mõlemal käel samaaegselt optimaalse mudakogusega, transportida koheses kasutusvalmisolekus ning kontrollida protseduuri parameetreid, seadistades muda temperatuuri ja protseduuri kestvuse aega. Seadmesse asetatakse protseduuri teostamiseks käed. Seadmel on silikoonist või kummist ümbristega avad, vältimaks muda väljavalgumise kasutamise ajal, ning avad on korgiga suletavad, mis võimaldab muda säilitada seadme sees ning seadet mugavalt transportida, ilma et muda välja valguks. Seadet kasutatakse mudateraapia protseduuri teostamiseks kätele eelkõige raviasutustes, kuid tänu kompaktsele ehitusele on võimalik seadet kasutada ka mujal.','The invention provides an electrical mud therapy device for limbs, which enables to perform the procedure for both hands at the same time with optimal amount of mud, to transport the device being immediately ready to use and to control procedure parameters by setting mud temperature and running time. Hands are inserted into the device and the procedure is carried out. The device is provided with openings covered with rubber or silicone sheaths to avoid mud spill during procedure. Openings are closed with caps, which enables to preserve mud inside the device for transporting without spilling any mud. The device is used for carrying out mud therapy procedures at treatment authorities, but compact construction of the device enables to use it elsewhere.'),('X553909     ','Püsimagnetitega sünkroonreluktansmootor, millel on mähistega staator ja magnetpoolustega rootor. Rootori magnetpooluste vahelist q-telge läbib mitu magnetvoo tõkestuspilu, mis kulgevad ühe magnetpooluse alt teise magnetpooluse alla. Magnetvoo tõkestuspilude vahel asuvad magnetvoo juhtsillad. Püsimagnetid on paigutatud magnetvoo juhtsildadesse nende juhtsildade keskel q-teljel. Sellega suureneb rootori q-telje-suunaline reluktans. See suurendab pöördemomenti ja võimaldab vähendada kaaluja gabariite.','Permanent magnet assisted reluctance motor that has a stator with windings and a rotor with magnetic poles. Several flux barriers cross q-axis, which is situated between the rotor magnetic põles, and they run from one magnetic pole to another magnetic pole. Flux paths are situated between flux barriers. Permanent magnets are placed in the flux paths, on the q-axis in the center of those flux paths. Due to that, q-axis oriented reluctance of the rotor rises. This rises angular torque as well as gives the possibility of lowering weight and size.'),('X553920     ','Rongi sihtpunkti kiiremini jõudmine ilma rongile kiirust lisamata toimub reisijate rongile asumise ja rongist väljumise arvel ilma rongi rongijaamades peatumiseta, mis toimub vagunite vahetuse abil. Üks vagun, kuhu on kogunenud rongist väljuda soovivad reisijad, asub kiiresti liikuva rongi sabas. Teine vagun, kuhu on kogunenud reisijad, kes soovivad alustada reisi rongiga, mis liigub suure kiirusega raudtee magistraalliinil, asub rongijaama ees. Need vagunid vahetavad omavahel kohad. Vagunite omavaheline vahetus toimub automaatselt spetsiaalse elektriliini abil, mis asub raudtee magistraalliini kohal. Seda elektriliini toidetakse madalpinge kõrgsageduselektrivooluga. Selle madalpinge kõrgsageduselektrivoolu abil haagitakse vagun kiiresti liikuva rongi sabast lahti sel momendil, kui rongi sabas oleva vaguni vooluandur-vooluvõttur kontakteerub selle kontaktliiniga, ja samal momendil, selle sama spetsiaalse kontaktliini abil, käivitatakse automaatselt teine vagun, mis seisab raudteejaama  ees reisijatega. See teine vagun ületab raudteejaama haruteel oleva pöörmetepiirkonna, jõuab raudtee magistraalliinile, lisab kiirust, jõuab järele rongile ja haakub temaga käigu pealt. Lahtiühendatud vagun seisatatakse magistraalliinile ja manööverdatakse rongijaama ning reisijad väljuvad vagunist rongijaamas.','The faster arrival of the train at the destination without speeding up the train is accomplished at the expense of passengers boarding and alighting from the train without the train stopping at train stations, which is done by swapping cars. One car, in which passengers wishing to alight from the train have assembled, is located at the very rear of the fast moving train. Another car, in which passengers have assembled wishing to begin their journey on the train that is travelling at high speeds on a trunk railway, is located in front of the train station. These cars swap places. The reciprocal swap between the cars occurs automatically by means of a dedicated power line, which is located above the trunk railway. This power line is supplied with low-voltage high-frequency current. By means of high-frequency low-voltage current, the car in the very rear of the fast moving train is uncoupled at the moment when the current sensor / current collector makes contact with this power line, and at the same time, by means of the same dedicated power line, the other car, standing in front of the station with passengers, is started up automatically. The other car crosses the switch area on the approach track of the train station, reaches the trunk railway, speeds up, catches up with the train and couples with it on the move. The uncoupled car is stopped on the trunk railway and manoeuvred to the train station, with passengers alighting from the train at the train station.'),('X553923     ','Leiutis kuulub teedemasinate valdkonda, täpsemalt puistematerjalide, nagu eri fraktsiooniga killustik, kruus, liiv, freesasfalt, vedamise, laotamise ja tasandamise masinate hulka. Masin kujutab endast poolhaagist, mis ühendatuna sadulautoga moodustab liikurmasina. Masin sisaldab korpust, mille külge on kinnitatud veermik koos sildadega, puistematerjali punkrit, laotus- ja tasandusseadist, tõstemehhanismi, profiilterade seadistamise mehhanismi, laiendusmehhanismi, punkri kaldse tagaseina puhastamise mehhanismi ja tasandustera puhastamise seadist.','The invention belongs among roadworks machinery, more particularly among the equipment for the transportation, spreading and levelling of bulk material, such as crushed stone of different particle sizes, gravel, sand and milled asphalt. This machine is a semitrailer, forming a self-propelled machine when attached to a saddle truck. The machine comprises of a frame that has an undercarriage together with axles fastened to it, a bulk material hopper, a spreading and levelling unit for bulk material spread out, a lifting mechanism for the spreading unit, an adjusting mechanism for profiling blades, an expansion mechanism, a cleaning mechanism for hopper.'),('X553943     ','Leiutiseks on pallimängude puur, mis koosneb ruumilisest nelinurkse konstruktsiooniga puurist ja selle sees olevatest vastastikku asetsevatest pinkidest. Pingil istudes või pingile käte abil kehaga toetudes saavutatakse keha diagonaalselt kaldus asend. Pallimängude puuri kasutades arendatakse mängija jalgade või käte tööd ning tähelepanu ja keskendumisvõimet.','The inventions is a cage for ball games, which comprises a cage of square spatial construction and facing benches inside of it. Diagonally inclined body position is achieved by sitting or leaning on benches. By using cage for ball games attention and concentration abilities are being developed.'),('X553950     ','Meetod ja seade täpsete ajatemplitega pideva pildivoo kujutisehõiveks sisaldab moduleeritud valgusallikat, mida juhib absoluutne reaal-ajaline globaalne ajabaas (näiteks globaalse navigatsiooni satelliidi süsteemi (GNSS) kontrolleri abil) ja kujutisehõive ja töötluse osa, mis dekodeerib valguse modulatsiooni lainekuju ning määrab ajatempli iga kaadri jaoks. GNSSi aja ja asukoha sõnumeid saab kasutada ka aja ja asukoha täistemplite genereerimiseks. Mitmeelemendilisi valgusallikaid võib kasutada ajavallas enama ajainformatsiooni edastamiseks. Mitme pildivoo (näiteks eri kaameratest) ajatemplite  jaoks võib kasutada mitmeid sama modulatsioonimustriga valgusallikaid.','Method and device for acquiring stream of the precisely time-stamped images, including the modulated light source, controlled by the absolute global real-time-base (e.g. provided by global navigation satellite system (GNSS) controller) and the image acquisition and processing unit, decoding the light modulation waveform and determining the time-stamp for every image frame. The GNSS time and position messages can be used to provide the full time- and location stamps for each frame. Multi-element light sources can be used to have more informative light modulation in the time domain. For time-stamping of several image streams (e.g. from several cameras) multiple light sources with the same modulation can be used.'),('X553951     ','Virtuaalne ühendatud anumate süsteem sisaldab visualiseerimisseadet ja juhtmoodulit. Käesolev virtuaalne ühendatud anumate süsteem on reaalne seade, mis imiteerib reaalseid protsesse, on hooldusvaba,  töötab iseseisvalt ja on kaugjuhitav. Visualiseerimise seade sisaldab vähemalt ühte virtuaalpaagi moodulit, vähemalt ühte peaekraani, vähemalt ühte klappi, vähemalt ühte valgusdioodi, vähemalt ühte lisaekraani, kiirendusandurit ja valjuhääldit. Pumba moodul sisaldab mikrokontrollerit, vibratsioonmootorit, seitsme-segmendilist indikaatorit ja klapi moodulit. Juhtmoodul sisaldab korpust, potentsiomeetrit ja tumblerit. Moodulid on paigaldatud põhipaneelile ja moodulite paigaldamise konkreetsed kohad on määratud selle tööstusseadme poolt, mida imiteeritakse virtuaalmudeliga. Süsteemi konfiguratsioon on staatiline ja selle aluseks on kasutaja spetsifikatsioon.','The virtual coupled tanks system comprises visualization device and control unit. The present virtual coupled tanks system is a physical device that imitates real-life processes virtually, is maintenance free, works independently and is remote-controlled. The visualization device comprises at least one virtual tank module, at least one main display, at least one valve, at least one LED, at least an additional alphanumeric display, accelerometer, speaker. Pump module comprises microcontroller device, vibrational motor, seven-segment indicator, valve module. The control unit comprises housing, at least one potentiometer, and toggle switches. The modules are fitted in specific places on the main visualization panel. The particular location of the modules is determined by a particular real-life industrial device that is replicated in the virtual model. The configuration of the whole system is static and is subject to user specification.'),('X553980     ','Käesolev leiutis käsitleb meetodit ja seadet pulbermaterjalide valmistamiseks, kus pulbrite jahvatamine, sellele järgnev käitlemine ning konsolideerimine toimub vaakumikeskkonnas. Leiutisekohase meetodiga vähendatakse töödeldava kergesti reageeriva pulbermaterjali saastumist eelkõige hapnikuga. Meetod on kasutatav kergelt oksüdeeruvatest materjalidest nagu magnetsulamitest, kergmetallidest või karbiidkermistest peenpulbrite ja neist valmistatud toodete saamiseks.','The present invention aims at providing a method and device for manufacturing sintered material products, whereas milling of the powders and subsequent handling and consolidation is performed under vacuum atmosphere. The presented method allows reduction of contamination of highly reactive materials, especially with oxygen. The method is applicable for fine pulverising of easily oxidising powder materials, like magnet alloys, light metals or ceramic-metal composites and making bulk products from thereof.');
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 (17,'Danteks OÜ','Jüri','Olt','Keskasula 21, Kuremaa','Jõgeva maakond','48445','EE'),(28,'Patendibüroo Turvaja OÜ','Harald','Tehver','Liivalaia 22','Tallinn','10118','EE'),(36,'AAA Patendibüroo OÜ','Tõnu','Nelsas','Tartu mnt 16','Tallinn','10117',''),(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 ('X551549     ',1),('X553904     ',1),('X553909     ',1),('X553920     ',1),('X553923     ',1),('X553943     ',1),('X553950     ',1),('X553951     ',1),('X553980     ',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 ('X551549','200701','C07D 453/02',1,1,1,1),('X551549','200701','A61K  31/435',2,1,1,2),('X551549','200701','A61P  43/00',2,1,1,3),('X553904','201501','A61H  33/04',1,1,1,1),('X553904','201501','A61H  35/00',2,1,1,2),('X553904','201501','A61F   7/00',2,1,1,3),('X553909','201601','H02K   1/27',1,1,1,1),('X553909','201601','H02K  21/14',2,1,1,2),('X553920','201601','B60M   3/06',1,1,1,1),('X553920','201601','B61B   1/00',2,1,1,2),('X553920','201601','B61B  13/00',2,1,1,3),('X553920','201601','B61K   1/00',2,1,1,4),('X553923','201401','E01C  19/12',1,1,1,1),('X553923','201401','E01C  19/22',1,1,1,2),('X553923','201401','E01C  19/25',1,1,1,3),('X553923','201401','E01C  19/48',1,1,1,4),('X553943','201601','A63B  69/00',1,1,1,1),('X553943','201601','A63B  71/02',2,1,1,2),('X553943','201601','A63B  21/28',2,1,1,3),('X553943','201601','A63B  63/00',2,1,1,4),('X553943','201601','E04H  17/00',2,1,1,5),('X553950','201501','G03B  15/03',1,1,1,1),('X553950','201501','G03B  17/00',2,1,1,2),('X553950','201501','H04N   5/238',2,1,1,3),('X553950','201501','H04N   9/475',2,1,1,4),('X553950','201501','H04N  13/02',2,1,1,5),('X553951','201501','G09B  25/00',1,1,1,1),('X553951','201501','G05D   9/12',2,1,1,2),('X553980','201501','B22F   3/12',1,1,1,1),('X553980','201501','B22F   9/04',2,1,1,2),('X553980','201501','C22C   1/04',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 ('X551549     ',8641,5),('X551549     ',13131,2),('X551549     ',13132,4),('X553904     ',14363,2),('X553904     ',14364,3),('X553904     ',14365,4),('X553909     ',12742,1),('X553909     ',14319,2),('X553909     ',14320,3),('X553909     ',14321,4),('X553920     ',14336,1),('X553923     ',13760,2),('X553943     ',14379,1),('X553950     ',9931,3),('X553950     ',13048,1),('X553950     ',14385,2),('X553950     ',14386,4),('X553950     ',14387,7),('X553950     ',14388,8),('X553950     ',14392,6),('X553951     ',14389,1),('X553951     ',14390,2),('X553951     ',14391,3),('X553980     ',14075,5),('X553980     ',14427,1),('X553980     ',14428,2),('X553980     ',14429,3),('X553980     ',14430,4),('X553980     ',14431,6),('X553980     ',14432,7),('X553980     ',14433,8);
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 (8641,'Maria Antonia','','Buil Albero','Calle Paris, 50, 1°- 4ª','ES','Barcelona','E-08029',''),(9931,'Raul','','Land','Akadeemia tee 7A-17','EE','Tallinn','12611',''),(12742,'Kuno','','Janson','J. Sütiste tee 22-5','EE','Tallinn','13411',''),(13048,'Olev','','Märtens','Sügislase 20/1','EE','Tallinn','11913',''),(13131,'Dolors Fernandez','','Forner','C/Roger de Flor, 221, 5°-4ª','ES','Barcelona','E-08025',''),(13132,'Maria Prat','','Quiñones','Andrea Doria, 2, 1°-1ª','ES','Barcelona','E-08003',''),(13760,'Enn','','Roosi','Pikk 19, Märjamaa','EE','Rapla maakond','78304',''),(14075,'Renno','','Veinthal','Ehitajate tee 5','EE','Tallinn','19086',''),(14319,'Anouar','','Belahcen','Muskattitie 9a-4','FI','Espoo','02680',''),(14320,'Ants','','Kallaste','Nisu 22-2','EE','Tallinn','10314',''),(14321,'Toomas','','Vaimann','Keskuse 14a-43','EE','Tallinn','12911',''),(14336,'Fjodor','','Voitra','Ehitajate tee 37-66','EE','Tallinn','12612',''),(14363,'Arvo','','Pärenson','Vana-Kalamaja 16-39','EE','Tallinn','10414',''),(14364,'Raivo','','Hein','Jahu 10-25','EE','Tallinn','10415',''),(14365,'Taavet','','Pärenson','Akadeemia tee 38-165','EE','Tallinn','12611',''),(14379,'Maxim','','Shilo','Magasini 13A-1','EE','Tallinn','10138',''),(14385,'Ago','','Mõlder','E. Vilde tee 121a-18','EE','Tallinn','12613',''),(14386,'Tõnis','','Saar','Gonsiori 7-20','EE','Tallinn','10117',''),(14387,'Douglas','','Reid','Heltermaa küla, Pühalepa vald','EE','Hiiu maakond','92312',''),(14388,'Alexander','','Girfanov','Kalevipoja põik 2-6','EE','Tallinn','13614',''),(14389,'Aleksei','','Tepljakov','Ehitajate tee 5','EE','Tallinn','19086',''),(14390,'Eduard','','Petlenkov','Ehitajate tee 5','EE','Tallinn','19086',''),(14391,'Juri','','Belikov','Ehitajate tee 5','EE','Tallinn','19086',''),(14392,'Marko','','Reidla','Vahessaare küla, Konguta vald','EE','Tartu maakond','61215',''),(14427,'Lauri','','Kollo','Ehitajate tee 5','EE','Tallinn','19086',''),(14428,'Kaspar','','Kallip','Ehitajate tee 5','EE','Tallinn','19086',''),(14429,'Zorjana','','Mural','Ehitajate tee 5','EE','Tallinn','19086',''),(14430,'Hans','','Vallner','Ehitajate tee 5','EE','Tallinn','19086',''),(14431,'Märt','','Kolnes','Ehitajate tee 5','EE','Tallinn','19086',''),(14432,'Marek','','Tarraste','Ehitajate tee 5','EE','Tallinn','19086',''),(14433,'Marek','','Jõeleht','Ehitajate tee5','EE','Tallinn','19086','');
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 ('X551549     ',3129,2),('X553904     ',3523,2),('X553909     ',328,1),('X553920     ',3512,1),('X553923     ',3148,2),('X553943     ',3538,1),('X553950     ',328,1),('X553950     ',3542,2),('X553951     ',328,1),('X553980     ',328,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',''),(3129,2,'','','','Almirall, S.A.','Ronda del General Mitre, 151','ES','Barcelona','08022',''),(3148,1,'Enn','','Roosi','','Pikk 19, Märjamaa','EE','Rapla maakond','78304',''),(3512,1,'Fjodor','','Voitra','','Ehitajate tee 37-66','EE','Tallinn','12612',''),(3523,2,'','','','Tallinna Ülikool','Narva mnt 25','EE','Tallinn','10120',''),(3538,2,'','','','Football Game OÜ','Magasini 13A-1','EE','Tallinn','10138',''),(3542,2,'','','','Eliko Tehnoloogia Arenduskeskus OÜ','Mäealuse 2/1','EE','Tallinn','12618','');
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 ('X551549     ','EP','00/06469','WO','01/04118','20010118');
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 ('X551549','ES','P9901580','19990714',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 ('X551549     ','EE200200017',200200017,'EE04915','04915',17,'20160715','P200200017  ','20000707','Kinuklidiinderivaadid, nende valmistamismeetod, vaheühendid, farmatseutiline kompositsioon ja nende kasutamine','Quinuclidine derivatives, a method for preparing thereof, intermediates, a pharmaceutical composition, and use thereof',28),('X553904     ','EE201400009',201400009,'EE05772','05772',2,'20160715','P201400009  ','20140414','Elektriline seade mudavanni protseduuri teostamiseks jäsemetele','Electrical mud therapy device for limbs',36),('X553909     ','EE201400013',201400013,'EE05773','05773',2,'20160715','P201400013  ','20140509','Püsimagnetitega sünkroonreluktansmootor','Permanent magnet reluctance motor',0),('X553920     ','EE201400024',201400024,'EE05774','05774',2,'20160715','P201400024  ','20140619','Süsteem ja meetod reisijate rongi sisenemiseks ja rongist väljumiseks ilma rongi peatumiseta rongijaamas','A system and method for the boarding and alighting of passengers from a train without the train stopping at a train station',39),('X553923     ','EE201400026',201400026,'EE05775','05775',2,'20160715','P201400026  ','20140707','Puistematerjali vedamise, laotamise ja tasandamise masin','Machine for transportation, spreading and levelling bulk material',17),('X553943     ','EE201400041',201400041,'','',1,'20160715','P201400041  ','20141203','Pallimängude puur ja selle kasutamine','Cage for ball games and use thereof',36),('X553950     ','EE201400044',201400044,'','',1,'20160715','P201400044  ','20141218','Meetod ja seade täpsete ajatemplitega pideva pildivoo kujutisehõiveks','Method and device for acquiring stream of the precisely time-stamped images',0),('X553951     ','EE201400045',201400045,'','',1,'20160715','P201400045  ','20141218','Virtuaalne ühendatud anumate süsteem','Virtual coupled tanks system',0),('X553980     ','EE201500021',201500021,'','',1,'20160715','P201500021  ','20150513','Meetod ja seade pulbermaterjalist toodete valmistamiseks','Method and device for manufacturing sintered material products',0);
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 */;

