-- 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 ('X553864','2017-02-15'),('X553916','2017-02-15'),('X553929','2017-02-15'),('X553972','2017-02-15'),('X553984','2017-02-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 ('X553864     ','Leiutis on seotud veealuse duššmassaaži vanniga, kus inimesel on võimalik vannis olla nii istuvas asendis, selili- kui ka kõhuliasendis. Vanni spetsiaalne konstruktsioon võimaldab jätta keha kuni kaelani vee alla, tagades sealjuures mugava asendi ning jättes keha pingetest vabaks.','The invention relates to an underwater shower massage bath, in which a human can be in sitting, supine or prone position. Special construction of bath is provided to leave body until neck under the water, while comfortable and tensionless body position is ensured.'),('X553916     ','Leiutis kuulub intelligentsete transpordisüsteemide valdkonda (ITS, Intelligent Transportation systems) ja käsitleb teehooldusmasinat, mis sisaldab vahendeid teehooldusmasina erinevate komponentide kohta info kogumiseks ja edastamiseks ning kogutud info põhjal komponentide asendite ja töörežiimide kohta soovituste andmiseks teehooldusmasina juhile, või käskluste edastamiseks kas teehooldusmasina juhi või masina enda poolt.','This invention belongs to the field of intelligent transport systems and concerns a road maintenance vehicle encompassing devices for collecting and transmitting information about the various components of a road maintenance vehicle, and for the provision of the road maintenance vehicle operator with recommendations about the positions and operating modes of the components based on the information collected, or for the transmission of orders by either the road maintenance vehicle operator or the vehicle itself.'),('X553929     ','Leiutis pakub välja maja keskküttesüsteemi autonoomse kontrollsüsteemi ja keskküttesüsteemi autonoomse reguleerimismeetodi, eesmärgiga vähendada ruumide kütmiseks kasutatavat soojusenergiat. Leiutisekohane küttesüsteem sisaldab soojusvahetit 1, milles on soojatootja poolne soojusvaheti 2, soojatarbija ehk kortermaja poolne soojusvaheti 3, termostaatventiiliga 14 varustatud radiaator 13, soojatootja küttevee vooluhulga regulaatorventiil 4, mida juhitakse juhtimis-reguleerimiskeskusest 5 saabuva signaaliga, samuti tsirkulatsioonipumpa 10, millesse on integreeritud või on sellega järjestikku ühendatud   tagasivooluhulga andur 11, mis on ühendatud juhtimis-reguleerimiskeskuses paikneva elektroonikalülitusega. Juhtimis-reguleerimiskeskuses 5 paiknev elektroonikalülitus 12 on konfigureeritud võtma vastu tagasivooluhulga andurist 11 saadetavaid signaale ja reguleerima vastavalt tsirkulatsioonipumpa läbivale vooluhulgale soojatootja küttevee vooluhulga regulaatorventiili 4, millega on tagatud  see,et  termostaatide 15 töö alusel reguleeritakse soojatarbija poolt soojatootjalt võetava kütteenergia hulka, kusjuures termostaadid 15 reageerivad ruumi temperatuuri muutustele, seega arvestatakse  küttesüsteemi töös näiteks päikese poolt ruumi tekitatavat nn vabasoojust, samuti tuule jahutavat mõju hoone tuulepoolsetele ruumidele.','The present invention provides an autonomous control system of central heating system and autonomous adjusting method of central heating system, in order to reduce thermal energy used for heating of rooms. The heating system of the invention comprises a heat exchanger 1, having heat exchanger 2 of the heat producer, heat exchanger 3 of the heat consumer or apartment house, radiator 13 equipped with thermostatic valve 14, adjusting valve 4 of heating water flow amount of the heat producer, controlled by the incoming signal from control/adjustment unit 5, as well as the circulation pump 10, which is integrated with or is connected in series with the reflux amount sensor 11, which is connected to the electronic circuit located in the control/adjustment unit. Electronic circuit 12 located in the control/adjustment unit 5 is configured to receive signals sent from reflux amount sensor 11 and adjust according to the flow amount through the circulation pump the adjusting valve 4 of the heat producer, which ensures that based on the work of the thermostats 15, the amount of the heating energy taken from the heat producer is adjusted, wherein thermostats 15 respond to changes in room temperature, thus during the operation of the heating system, for example, so called free energy produced by the sun, and the cooling effect of the wind to rooms on the windy sides of the building is taken into consideration.'),('X553972     ','Leiutise sisuks on binaarse ergutusega impedantsi analüüsi meetod ja seade, kus analüüsitäpsuse oluline paranemine saavutatakse ergutussignaali vastussignaali võendamisel ja esmatöötlusel tekkivate ebatäpsuste (k.a. nende, mis on tingitud signaali nn aliaskomponentidest) arvessevõtmisega, kasutades kogu süsteemi mudelit. Viimane sisaldab mõõdetava objekti aseskeemi (või selle variante) ning vastussignaali esialgse analüüsi mudelit koos puuduste arvestamisega. Impedantsianalüüsi vahe- või lõpptulemuseks on aseskeem koos aseskeemi komponentide parameetritega, mis parimal viisil sobitab süsteemi  analüüsi kogumudeli tulemuse ja vastussignaali esialgse analüüsi tulemuse. Edasiseks tulemuseks võib olla ka aseskeemist arvutatud impedantsi sageduskäik või määratud objekti klassifikaator.','The objekt of the invention is a method and device for impedance analysis with binary excitation, with improved accuracy, where the nonidealities of the sampling and preprocessing of the response signal (including aliasing effects) are taken into account by using of the overall system model with equivalent circuit diagrams of the analyzed object and the model of the preliminary analysis of the response signal. The result of the analysis is the equivalent circuit diagram with component values with the best match of the overall model analysis and of the preliminary analyze of the response signal. Further, the result of the analysis can be the impedance frequency response or the classifier of the analyzed object.'),('X553984     ','Metallialkoksiide (Ti(OR)x, Zr(OR)x, Si(OR)x ja Hf(OR)x) ning ioonset vedelikku (1-metüülimidasooli ja 3-kloropropüül trietoksüsilaani - MTICI) kasutati stabiilsete homogeensete ionogeelide saamiseks  lahuse-geeli meetodi abil. Käesolev leiutis võimaldab esmalt oksiidi nanoosakeste prekursori stabiliseerimist kovalentselt seotud ionogeelis vastavalt prekursori valikule (Si-O-Ti, Si-O-Si, Si-O-Zr või Si-O-Hf), rakendades lahuse-geeli meetodit.','Metal alkoxides (Ti(OR)x, Zr(OR)x, Si(OR)x and Hf(OR)x) and ionic liquid (1-methylimidazole and 3-chloropropyl triethoxysilane-MTICI) were used to obtain stable homogeneous ionogels via the sol-gel approach. At first level this invention allows the precursor of oxide nanoparticles to be stabilized in the form of a covalently bonded ionogel according to the choice of precursor (Si-O-Ti, Si-O-Si, Si-O-Zr or Si-O-Hf) by applying the sol-gel method.');
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 (36,'AAA Patendibüroo OÜ','Tõnu','Nelsas','Tartu mnt 16','Tallinn','10117',''),(38,'Sarap ja Putk Patendibüroo','Margus','Sarap','Kompanii 1C','Tartu','51004','EE'),(39,'Patendi- & Kaubamärgibüroo Koitel OÜ','Raivo','Koitel','Tina 26','Tallinn','10126','EE');
UNLOCK TABLES;
/*!40000 ALTER TABLE `yagent` ENABLE KEYS */;

--
-- Table structure for table `ybdata`
--

DROP TABLE IF EXISTS `ybdata`;
CREATE TABLE `ybdata` (
  `idappli` varchar(12) collate utf8_estonian_ci NOT NULL,
  `order` int(3) default NULL,
  PRIMARY KEY  (`idappli`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;

--
-- Dumping data for table `ybdata`
--


/*!40000 ALTER TABLE `ybdata` DISABLE KEYS */;
LOCK TABLES `ybdata` WRITE;
INSERT INTO `ybdata` VALUES ('X553864     ',1),('X553916     ',1),('X553929     ',1),('X553972     ',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 ('X553864','201301','A61H  33/00',1,1,1,1),('X553864','201301','A47K   3/02',1,1,1,2),('X553916','201501','E01H   5/06',1,1,1,1),('X553929','201601','F04D  15/00',1,1,1,1),('X553929','201601','F24D  19/10',2,1,1,2),('X553972','201601','A61B   5/053',1,1,1,1),('X553972','201601','G01R  27/28',2,1,1,2),('X553984','201601','C01B  13/32',1,1,1,1),('X553984','201601','C01G   1/02',2,1,1,2),('X553984','201601','B82Y  30/00',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 ('X553864     ',13444,2),('X553916     ',14329,2),('X553929     ',14347,1),('X553972     ',9931,2),('X553972     ',13048,1),('X553972     ',13144,4),('X553972     ',14392,5),('X553972     ',14416,3),('X553984     ',7824,10),('X553984     ',14435,1),('X553984     ',14436,2),('X553984     ',14438,6),('X553984     ',14439,7),('X553984     ',14440,9),('X553984     ',14442,11),('X553984     ',14443,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 (7824,'Ants','','Lõhmus','Ümera 6','EE','Tartu','50406',''),(9931,'Raul','','Land','Akadeemia tee 7A-17','EE','Tallinn','12611',''),(13048,'Olev','','Märtens','Sügislase 20/1','EE','Tallinn','11913',''),(13144,'Paul','','Annus','Harju 5-12','EE','Tallinn','10146',''),(13444,'Villi','','Pogga','Narva mnt 15-9','EE','Tallinn','10120',''),(14329,'Jaan','','Meikup','Röa mõis, Röa küla, Väätsa vald','EE','Järva maakond','72806',''),(14347,'Pjotr','','Bazanov','Mustamäe tee 102-102','EE','Tallinn','12917',''),(14392,'Marko','','Reidla','Vahessaare küla, Konguta vald','EE','Tartu maakond','61215',''),(14416,'Mart','','Min','Ladva 26','EE','Saue','76506',''),(14435,'Raul','','Välbe','Turu 13-57','EE','Tartu','51004',''),(14436,'Rünno','','Lõhmus','Ümera 8','EE','Tartu','50406',''),(14438,'Madis','','Umalas','Halinga, Halinga vald','EE','Pärnu maakond','87212',''),(14439,'Valter','','Reedo','Nisu 31','EE','Tartu','50407',''),(14440,'Marta','','Tarkanovskaja','Narva mnt 25-111','EE','Tartu','51013',''),(14442,'Jakob','','Kübarsepp','Rännaku 56','EE','Tallinn','10921',''),(14443,'Uno','','Mäeorg','Pärna allee 3-21, Vahi alevik, Tartu vald','EE','Tartu maakond','60534','');
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 ('X553864     ',3432,1),('X553916     ',3316,1),('X553929     ',3519,1),('X553929     ',3520,2),('X553972     ',328,1),('X553972     ',3542,2),('X553984     ',328,2),('X553984     ',334,1),('X553984     ',3567,3);
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',''),(334,2,'','','','Tartu Ülikool','Ülikooli 18','EE','Tartu','50090',''),(3316,2,'','','','Meiren Engineering OÜ','Väike-Männiku 7','EE','Tallinn','11216',''),(3432,2,'','','','Osaühing Aquator','Pärnu mnt 110','EE','Tallinn','11313',''),(3519,1,'Pjotr','','Bazanov','','Mustamäe tee 102-102','EE','Tallinn','12917',''),(3520,1,'Rasmus','','Kivila','','Mai põik 4-7','EE','Tallinn','11621',''),(3542,2,'','','','Eliko Tehnoloogia Arenduskeskus OÜ','Mäealuse 2/1','EE','Tallinn','12618',''),(3567,2,'','','','Eesti Nanotehnoloogiate Arenduskeskuse AS','Ravila 14c','EE','Tartu','50411','');
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 ('X553984','GB','1410837.7','20140618',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 ('X553864     ','EE201300018',201300018,'EE05789','05789',2,'20170215','P201300018  ','20130517','Veealuse duššmassaaži vann','Underwater shower massage bath',36),('X553916     ','EE201400020',201400020,'EE05791','05791',2,'20170215','P201400020  ','20140606','Teehooldusmasin','Road maintenance vehicle',39),('X553929     ','EE201400032',201400032,'EE05792','05792',2,'20170215','P201400032  ','20140815','Keskküttesüsteemi autonoomne kontrollsüsteem ja keskküttesüsteemi autonoomne reguleerimismeetod','Autonomous control system of central heating system and autonomous adjusting method of central heating system',36),('X553972     ','EE201500014',201500014,'EE05788','05788',2,'20170215','P201500014  ','20150420','Impedantsi binaarse ergutusega analüüsi meetod ja seade','Method and device for impedance analysis with binary excitation',0),('X553984     ','EE201500022',201500022,'EE05790','05790',2,'20170215','P201500022  ','20150618','Meetod metallioksiidi nanoosakeste valmistamiseks geelis','A method for preparing metal oxide nanoparticles in a gel',38);
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 */;