-- 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 ('X553898','2015-11-16'),('X553903','2015-11-16'),('X553904','2015-11-16'),('X553905','2015-11-16'),('X553906','2015-11-16'),('X553938','2015-11-16'),('X553971','2015-11-16');
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 ('X553898     ','Leiutis käsitleb isoleeritud mikroorganismi tüve Lactobacillus brevis TAK 124-1 NCIMB42149, mida kasutatakse sööda aeroobse stabiilsuse tagamiseks ja fermenteerimise parandamiseks, söödas piimhappe ja äädikhappe kontsentratsiooni suurendamiseks, pH alandamiseks ja seeläbi söödas toitainete kadude vähendamiseks. Mikroorganismi kasutamine sileerimisel pärsib patogeensete mikroobide (klostriidide ja  enteropatogeenide) ning pärm- ja hallitusseente toimet. Mikroorganismi sisaldav söödalisand pikendab sööda säilimisaega.','The invention provides the isolated microorganism Lactobacillus brevis TAK 124-1 NCIMB42149, which is used for securing the aerobic stability of feed and improving the fermentation of feed, for increasing the concentration of lactic acid and acetic acid, for reducing pH, hence decreasing the loss of nutrients in feed. L. brevis TAK 124-1 suppresses the function of pathogens (Clostridia and enteropathogens), yeast and fungi in feed. Feed additive comprising said microorganism helps to extend shelf-life of feed.'),('X553903     ','Leiutiseks on polüetüleenhelvestest ja polüestermikrokiududest täidismaterjal, mida kasutatakse vooditarvete, eelkõige patjade täidisena. Polüetüleenhelvestest ja polüestermikrokiududest täidis on kerge, õhuline ja elastne, andes padjatäidisena kasutamisel padjale udusulepadjaga sarnase pehmuse. Pakutud täidis on ebasoodne keskkond bakterite paljunemiseks, olles sealjuures pestav baktereid hävitava temperatuuri juures kodustes tingimustes. Pakutud täidisega padi säilitab kohevuse, elastsuse ja pehmuse ka pärast pesu. Täidisel ei ole tervist kahjustavaid omadusi, sobides sealjuures ka allergikutele.','The invention provides a stuffing containing polyethylene flakes and polyester microfibers, which is used as stuffing for bed clothes, especially pillows. The stuffing containing polyethylene flakes and polyester microfibers is light, airy and flexible, giving the same softness characteristics as down pillow. Provided stuffing is an unfavorable environment for bacterial growth, being washable at bacteria killing temperature in domestic conditions. A pillow filled with provided stuffing maintains fluffy, flexible and soft even after washing. The stuffing has no health adversing impacts, being suitable also for allergics.'),('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äljavalgumist 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.'),('X553905     ','Leiutis on seotud lumesaha tera konstruktsiooniga. Saha tera kulumiskindel element on paigutatud elastsesse ümbrisesse, mis on kinnitatud sahaga ühendatud metallplaatide vahele, kusjuures metallplaadil on jahutamiseks avad, millest kulumiskindlate elementide kannad osaliselt välja ulatuvad. Need väljaulatuvad osad on otsekontaktis ümbritseva keskkonnaga, sealhulgas lume, vee, jää ja õhuga, et jahutada tera ja teepinna kokkupuutel hõõrdumise tõttu kuumenevat tera.','Invention is related to the design of a blade of a snow plough. Wear element of the blade of the plough is placed into the elastic encasement, which is attached between metal plates that are attached to the plough, wherein there are openings in the metal plate for cooling, abutments of the wear elements protruding partly from said openings. These protruding parts are in direct contact with the surrounding environment to cool the blade that heats up because of the friction when the blade and road surface are in contact.'),('X553906     ','Leiutis kuulub materjalide uurimise ja analüüsimise valdkonda, täpsemalt liha mehaaniliste omaduste määramise meetodite hulka ning on kasutatav liha õrnuse määramisel. Gravitatsioonilise impulssmeetodi iseloomulik tunnus on see, et liha proovitükk lõigatakse läbi ^-kujulise lõiketera vabal langemisel liha proovitükile. Lõikamise protsessi käigus liha proovitüki läbimisel väheneb ^-kujulise lõiketera kiirus liha, sealhulgas veiseliha mehaanilistest omadustest lähtuvalt, sealhulgas sitkusest tulenevate takistusjõudude mõjul lõiketerale. Lõikamise protsessi lõppedes mõõdetakse jõuanduriga lõiketera jääkjõudu ja selle mõju kestust, kusjuures fikseeritakse jääkjõu mõju lõpp ja algus, mis registreeritakse andmesalvesti (arvuti) poolt. Saadud andmete põhjal arvutatakse impulss ja lõikeenergia.','The invention belongs to the field of material research and analysis, in particular, to the methods for estimation the mechanical traits of meat, and it can be used for estimation of the tenderness of meat. A characteristic trait of the gravitational impulse method is that a sample segment of meat is cut through with a ^-shaped shear blade at its free-fall to the sample meat piece. In the cutting process, the speed of the ^-shaped shear blade, passing through the meat segment, decreases due to the mechanic traits of meat, including the impact of toughness-deduced resistance force on the shear blade. At the end of the cutting process, the residual force of the shear blade as well as the durability of its impact are measured by a force transducer; thereby the end and start of the residual force impact are fixed, being registered by a data recorder (computer). On the basis of this data impulse and shear energy are measured.'),('X553938     ','Leiutis käsitleb Lactobacillus plantarum Inducia DSM 21379 kasutamist hüpokolestereemilise, antimikroobse ja antioksüdatiivse agendina. Nimetatud tüve sisaldavatel toiduainetel ja toidulisanditel on südant kaitsev toime. Mikroorganismi L. plantarum Inducia kasutatakse kolesterooli metabolismi häirete ja südameveresoonkonnahaiguste ennetamiseks, kuna ta vähendab LDL-kolesterooli taset ja samaaegselt tõstab organismi antioksüdatiivset aktiivsust, mõjutades oksüdatiivse stressi markereid soovitud suunas - oksüdeeritud madala tihedusega lipoproteiinide (ox-LDL) tase ja oksüdatiivse stressi indeks  (OSI) vähenevad. Tüve L. plantarum Inducia kasutatakse ka antimikroobse agendina endogeenset või eksogeenset päritolu Clostridium difficile põhjustatud kõhulahtisuse (CDAD) riski vähendamiseks. L. plantarum Inducia takistab Clostridium difficile eoste germinatsiooni ja Clostridium difficile vegetatiivsete rakkude paljunemist. Tüvi L. plantarum Inducia on kasutatav samaaegselt antibiootikumraviga.  Clostridium difficile vastased kompositsioonid võivad lisaks sisaldada ka ksülitooli.','The invention relates to a microorganism strain Lactobacillus plantarum Inducia DSM 21379 for use as hypocholesterolemic, antimicrobial and anti-oxidative agent. The food products and compositions comprising said strain have a cardio-protective effect. L. plantarum Inducia is used in preventing cholesterol metabolism disorders and cardiovascular disorders by reducing the level of LDL-cholesterol, and simultaneously as an anti-oxidative agent for use in enhancing anti-oxidative activity of human body by reducing the levels of oxidative stress markers - oxidized low density lipoprotein (ox-LDL) and oxidative stress index (OSI). L. plantarum Inducia can be used as an antimicrobial agent in lowering 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.'),('X553971     ','Katlamajas kondensaadi jahutamiseks mõeldud meetod ja seade sisaldab kondensaatorit (1), mis on ühendatud kondensaadi jahutiga (3), mida läbib põletuskatlasse sisenev kanal (4), mis saab alguse põletuskatla põlemisõhu kanalist. Kondensaadijahutil (3) on vahetu põlemisõhu ja kondensaadi vaheline kuumuse ja massi ülekandeühendus kondensaadi jahutamiseks ning põlemisõhu soojendamiseks ja niisutamiseks. Kondensaadi väljutuskanal (5) väljub kondensaadijahutist (3) ja selle otstarve on katlamajast jahutatud kondensaadi väljutamine.','Method and an apparatus for cooling condensate in a boiler plant comprises a condenser (1), which is connected to a condensate cooler (3), through which a duct (4) branching off from a combustion air duct of the boiler is introduced to the boiler. The condensate cooler (3) has a direct heat and mass transfer connection between combustion air and condensate, for cooling the condensate and for heating and moistening the combustion air. A discharge duct (5) for the condensate extends from the condensate cooler (3) for discharging the cooled condensate from the boiler plant.');
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'),(36,'AAA Patendibüroo OÜ','Tõnu','Nelsas','Tartu mnt 16','Tallinn','10117',''),(52,'Patendibüroo KÄOSAAR OÜ','Marit','Meinberg','Suur-Patarei 2','Tallinn','10415','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 ('X553904     ',1),('X553905     ',1),('X553906     ',1),('X553971     ',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 ('X553898','201401','A23K   3/02',1,1,1,1),('X553898','201401','C12N   1/20',2,1,1,2),('X553898','201401','C12R   1/24',2,1,1,3),('X553903','201501','B68G   1/00',1,1,1,1),('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),('X553905','201401','E01H   5/06',1,1,1,1),('X553906','201501','A22B   5/00',1,1,1,1),('X553906','201501','G01N  21/00',2,1,1,2),('X553938','201501','A61K  35/747',1,1,1,1),('X553938','201501','A23L   1/30',2,1,1,2),('X553938','201501','C12R   1/25',2,1,1,3),('X553971','201501','F02G   5/02',1,1,1,1),('X553971','201501','F24H   8/00',2,1,1,2),('X553971','201501','F28C   1/00',2,1,1,3),('X553971','201501','B01D  47/14',2,1,1,4);
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 ('X553898     ',13295,3),('X553898     ',13667,2),('X553898     ',14234,4),('X553898     ',14235,5),('X553898     ',14236,6),('X553898     ',14237,7),('X553898     ',14238,1),('X553903     ',14305,2),('X553904     ',14363,2),('X553904     ',14364,3),('X553904     ',14365,4),('X553905     ',14094,2),('X553906     ',13746,3),('X553906     ',14109,1),('X553906     ',14110,2),('X553906     ',14121,4),('X553906     ',14309,5),('X553906     ',14310,6),('X553906     ',14311,7),('X553906     ',14312,8),('X553906     ',14313,9),('X553938     ',13294,1),('X553938     ',13295,3),('X553938     ',13300,16),('X553938     ',13305,7),('X553938     ',13667,2),('X553938     ',14239,15),('X553938     ',14369,10),('X553938     ',14370,11),('X553938     ',14372,17),('X553938     ',14373,5),('X553938     ',14374,9),('X553938     ',14375,13),('X553971     ',14414,1),('X553971     ',14415,2);
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 (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     ',''),(13305,'Imbi','','Smidt','Voika küla, Nõo vald','EE','Tartu maakond','61622     ',''),(13667,'Epp','','Songisepp','Tähe 105-7','EE','Tartu','50107     ',''),(13746,'Urmas','','Sannik','Vaablase 14-1','EE','Tallinn','12916     ',''),(14094,'Raoul','','Renser','Väike-Männiku 7','EE','Tallinn','11216     ',''),(14109,'Väino','','Poikalainen','Aretuse 1-4, Märja, Tähtvere vald','EE','Tartu maakond','61406     ',''),(14110,'Lembit','','Lepasalu','Pilve 11-4, Märja, Tähtvere vald','EE','Tartu maakond','61406     ',''),(14121,'Jüri','','Olt','Keskasula 21, Kuremaa','EE','Jõgeva maakond','48445     ',''),(14234,'Andres','','Olt','Sangla 25-8','EE','Tartu','50407     ',''),(14235,'Helgi','','Kaldmäe','Kreutzwaldi 40-8','EE','Tartu','51006     ',''),(14236,'Olav','','Kärt','Lõhe 28','EE','Tallinn','13516     ',''),(14237,'Meelis','','Ots','Tammsaare 5-13','EE','Tartu','51006     ',''),(14238,'Kristiina','','Kokk','Ringtee 31, Tõrvandi, Ülenurme vald','EE','Tartu maakond','61715     ',''),(14239,'Jelena','','Stsepetova','Muru 12-28','EE','Tartu','50303     ',''),(14305,'Göran Valdemar','','Sjöholm','Helme tee 1, Manniva küla, Jõelähtme vald','EE','Harju maakond','74217     ',''),(14309,'Aarne','','Põldvere','Riia mnt 170, Lemmatsi, Ülenurme vald','EE','Tartu maakond','61704     ',''),(14310,'Riho','','Martinson','Kevade 3','EE','Rakvere','44306     ',''),(14311,'Alo','','Tänavots','Tamme põik 35-6','EE','Tartu','50416     ',''),(14312,'Hannes','','Mootse','Kaasiku 20, Ülenurme alevik','EE','Tartu maakond','61714     ',''),(14313,'Andres','','Sats','Aiandi tee 5-45, Luunja vald','EE','Tartu maakond','62207     ',''),(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     ',''),(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     ',''),(14374,'Kai','','Truusalu','Vanemuise 45-59','EE','Tartu','51003     ',''),(14375,'Kalle','','Kilk','Suur kaar 21-3','EE','Tartu','50404     ',''),(14414,'Joonas','','Arola','Ruopionkatu 11 A 6','FI','Tampere','FI-33800  ',''),(14415,'Seppo','','Tuominiemi','Mansikkakuja 5','FI','Pirkkala','FI-33960  ','');
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 ('X553898     ',2796,1),('X553903     ',3496,1),('X553904     ',3523,2),('X553905     ',3316,1),('X553906     ',3387,1),('X553938     ',2796,1),('X553971     ',3556,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 (2796,2,'','','','OÜ Tervisliku Piima Biotehnoloogiate Arenduskeskus','Kreutzwaldi 1','EE','Tartu','51014',''),(3316,2,'','','','Meiren Engineering OÜ','Väike-Männiku 7','EE','Tallinn','11216',''),(3387,2,'','','','Eesti Maaülikool','Fr. R. Kreutzwaldi 1a','EE','Tartu','51014',''),(3496,2,'','','','Osaühing Delux','Raua 5','EE','Viljandi','71020',''),(3523,2,'','','','Tallinna Ülikool','Narva mnt 25','EE','Tallinn','10120',''),(3556,2,'','','','Valmet Technologies Oy','Keilasatama 5','FI','Espoo','FI-02150','');
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 ('X553938','US','244284','20140403',1),('X553971','FI','20145295','20140328',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 ('X553898     ','EE201400005',201400005,'EE05756','05756',2,'20151116','P201400005  ','20140214','Isoleeritud mikroorganismi tüvi Lactobacillus brevis TAK 124-1 NCIMB42149 ja selle kasutamine','Isolated microorganism strain Lactobacillus brevis TAK 124-1 NCIMB42149 and use thereof',4),('X553903     ','EE201400008',201400008,'','',1,'20151116','P201400008  ','20140326','Vooditarvete täidismaterjal ja selle kasutamine','Stuffing material for bed clothes and use thereof',36),('X553904     ','EE201400009',201400009,'','',1,'20151116','P201400009  ','20140414','Elektriline seade mudavanni protseduuri teostamiseks jäsemetele','Electrical mud therapy device for limbs',36),('X553905     ','EE201400010',201400010,'','',1,'20151116','P201400010  ','20140414','Lumesaha tera','Blade of a snow plough',36),('X553906     ','EE201400011',201400011,'','',1,'20151116','P201400011  ','20140423','Gravitatsiooniline impulssmeetod ja seade liha lõikeenergia määramiseks','Gravitational impulse method and device for estimation meat shear energy',0),('X553938     ','EE201400038',201400038,'','',1,'20151116','P201400038  ','20141031','Hüpokolestereemilist ja antimikroobset agenti probiootilist mikroorganismi tüve Lactobacillus plantarum Inducia DSM 21379 sisaldav kompositsioon kasutamiseks südame-veresoonkonnahaiguste ja Clostridium difficile põhjustatava kõhulahtisuse ennetamisek','Composition comprising a probiotic microorganism strain Lactobacillus plantarum Inducia DSM 21379 as hypocholesterolemic and antimicrobial agent for use in preventing cardiovascular disorders Clostridium difficile associated diarrhoea',4),('X553971     ','EE201500013',201500013,'','',1,'20151116','P201500013  ','20150326','Meetod ja seade kondensaadi jahutamiseks ja selle soojuse taaskasutamiseks katlamajas','A method and an apparatus for cooling condensate and for recovering heat from it in a boiler plant',52);
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 */;