-- 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 ('X2561','2017-03-15'),('X2571','2017-03-15'),('X2573','2017-03-15'),('X2609','2017-03-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 ('X2561       ','Vertikaalselt lendutõusev ja maanduv lennumasin, mis sisaldab raami, eesmist ja tagumist propellerite plokki, mootorit, aerodünaamilisi pindu, lennumasina juhtimissüsteemi, piloodi istekohta, kütusepaaki. Käesoleva leiutise lennumasin erineb selle poolest, et samateljelistest vastassuunas pöörlevatest ülemisest ja alumisest propellerist moodustatud eesmine propellerite plokk ja tagumine propellerite plokk on lennusihis ümber lennusihiga risti oleva telje kallutatavad, suurendades niiviisi mitmesugustes lennurežiimides lennumasina mootori efektiivsust. Lennumasina juhtimiseks on selle juhtimissüsteemis juhtorganite ja täitevmehhanismide vahelise otsese mehaanilise seotuse välistamiseks kasutatud elektroonikavahendeid, võimaldades niiviisi laiendada lennumasina kasutamise valdkondi, suurendada selle töökindlust ja ohutust. Lennumasina juhtimissüsteem sisaldab juhtkange, avioonikakompleksi kuvarit ja elektronprotsessorit, kusjuures propellerite plokid on paigutatud kuullaagrite vahendusel raamile ja on tõmbevektori muutmiseks lennusihiliselt kallutatavad ning nende lennusihiline kallutamine võib toimuda mittesünkroonselt vastavalt elektronprotsessoris salvestatud programmi kohaselt saabunud käsule. Lennumasina konstruktsioon võimaldab seda kasutada nii piloteeritavas kui mittepiloteeritavas režiimis, kusjuures piloteeritavast režiimist mittepiloteeritavasse režiimi ja vastupidi ümberlülitamine toimub vastavasse lennumasina pilusse varrasvõtme sisestamise teel.','Flying apparatus for vertical take-up and landings comprises a frame, frontal and rear blocks of propellers, an engine, aerodynamic surfaces, a system for ruling of the flying apparatus, a pilot\'s seat, a fuel tank. The said flying apparatus is characterized by a possibility to turn around an axis transversal to the flying direction the propeller blocks consisting of upper and lower propellers, rotating in the opposite directions around a common axis, thus enhancing in various flying modes the efficiency of the engine of the flying apparatus. For the controlling of the flight of the flying apparatus the direct mechanical connection between the ruling equipment and driving mechanisms is excluded by the use of electronic device, thus enabling to broaden the applications, reliability and safety of the said flying apparatus. The ruling system of the flying apparatus comprises joysticks, the display of the avionics complex and an electronic processor, wherein the blocks of propellers are mounted on the frame through bearings and are longitudinally inclinable for varying of the pulling vector in respect of the flying direction, and their longitudinal inclination may occur in response to the command of the saved electronic processor program. The construction of the flying apparatus allows its use in the pilotage mode or in non-pilotage mode, wherein the switching from one regime to another and vice versa may be accomplished by inserting a rod-key into the slot of the flying apparatus.'),('X2571       ','Käesolev leiutis käsitleb käsitsi köitmise meetodit, kus erinevalt Belgia peidetud pistest tehakse köitmisnööri kinnitamiseks sõlm kaane ja vahetüki vahele. Sõlmed annavad köitele efektsust, tugevust  ning takistavad köitenööride libisemist ja kaanedetailide paigalt nihkumist. Köitmist alustatakse köite ülemisest servast ja köitmine toimub suunaga ülevalt alla, paralleelselt nii paremal kui vasakul pool. Toote seljatükile on tekitatud köitenööridest keerd või lisatud erinevaid kaunistuselemente.','The present invention relates to a method for bookbinding by hand, where unlike the Belgian secret bindings, the knot for fastening the binding rope is made between the lid and linear spine. The knots give more effect and strength to the binding, also prevent the slipping of the ropes or displacement of the cover. The binding starts from the upper edge and is moving from top to bottom, parallel on both the right and the left side. On the back of the product the twist is made of binding ropes or a variety of decorative elements are added.'),('X2573       ','Universaalse liigutatava riputi eesmärk on võimaldada lakke riputatavate interjööri disainielementide dünaamilisemat kasutust, pakkudes võimalust tekitada sujuvalt riputuseks kandekoht mistahes punktis ringikujulisel laepinnal. Selle lihtne konstruktsioon võimaldab seda kuluefektiivselt toota ning sisekujunduse erinevate osadena või täiendustena kasutada ilma liigset keerukust lisamata. Universaalne liigutatav riputi liigub ringikujuliselt 360° ning võrreldes keskkohaga edasi-tagasi. See koosneb omavahel keermekinnituse abil ühendatavatest identsetest varrastest, moodustades ridva, tugifunktsiooniga rattakujulisest otsadetailist ehk tugirattast, riputusfunktsiooniga otsadetailist ehk riputusotsakust, laekinnitusest, 360° pöörlevast kandurist ning riputuskonksudest. Laekinnitus koos kanduriga kinnitatakse lae külge, vardad ühendatakse omavahel ridvaks ning asetatakse kandurist läbi, seejärel ühendatakse tugiratas ning riputusotsak ja paigaldatakse ridvale soovi korral konksud.','Multi-use movable hanger provides a more dynamic use of pendant interior ceiling design elements, enabling to smoothly create a hanging point wherever on the circular ceiling area. Simple construction allows it to be produced cost-effectively and use it with different decor elements or additions without adding excessive complexity. Multi-use movable hanger spins 360° around its axes, back and forth from the middle spot. It consists of identical connectable spars which together form a rod, a wheel-shaped end detail named support wheel which performs support function and an end detail with hanging function named hanging nozzle, ceiling bracket, 360° spinable holder and hanging hooks. Ceiling bracket with holder is attached to the ceiling, spars are connected together forming a rod and placed through the bracket. Then the end details are attached and hanging hooks added if desired.'),('X2609       ','Käesolev leiutis käsitleb liha- ja juustutoodete kastet, mis sisaldab tomatit, tšillit, küüslauku, paprikat, soola, pipart, äädikat ja moosisuhkrut. Kastet kasutatakse liha- ja juustutoodetele dipikastmeks, moosiks, samuti ka grilltoodete kastmeks peale küpsetamist','The present invention is related to a sauce for meat and cheese products, containing tomatoes, chilli, garlic, paprika, salt, pepper, vinegar and jam sugar. Sauce is used for meat and cheese products as a dip or jam or as barbeque sauce for grilled meat and other products.');
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 (33,'INTELS Patendibüroo OÜ','Juhan','Hämmalov','Magasini 12','Tartu','51005','EE'),(53,'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 ('X2561       ',1),('X2571       ',1),('X2573       ',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 ('X2561','201601','B64C  27/08',1,1,1,1),('X2561','201601','B64C  27/28',1,1,1,2),('X2561','201601','B64C  29/00',1,1,1,3),('X2571','201701','B42D   1/00',1,1,1,1),('X2571','201701','B42D   3/08',2,1,1,2),('X2573','201601','F21V  21/08',1,1,1,1),('X2573','201601','F21V  21/34',1,1,1,2),('X2609','201701','A23L  21/12',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 ('X2561       ',2396,1),('X2571       ',2408,1),('X2573       ',2410,1),('X2609       ',2460,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `yinvent` ENABLE KEYS */;

--
-- Table structure for table `yinventor`
--

DROP TABLE IF EXISTS `yinventor`;
CREATE TABLE `yinventor` (
  `idinvent` int(11) NOT NULL,
  `fninventor` varchar(60) collate utf8_estonian_ci default NULL,
  `midninventor` varchar(60) collate utf8_estonian_ci default NULL,
  `nminventor` varchar(120) collate utf8_estonian_ci default NULL,
  `adinventor` varchar(240) collate utf8_estonian_ci default NULL,
  `idcountry` varchar(2) collate utf8_estonian_ci default NULL,
  `nmtown` varchar(80) collate utf8_estonian_ci default NULL,
  `idtown` varchar(10) collate utf8_estonian_ci default NULL,
  `nmstate` varchar(80) collate utf8_estonian_ci default NULL,
  PRIMARY KEY  (`idinvent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_estonian_ci;

--
-- Dumping data for table `yinventor`
--


/*!40000 ALTER TABLE `yinventor` DISABLE KEYS */;
LOCK TABLES `yinventor` WRITE;
INSERT INTO `yinventor` VALUES (2396,'Oleksandr','','Ptashnyk','Matsi talu, Soodoma küla, Kanepi vald','EE','Põlva maakond','63124',''),(2408,'Marget','','Rüütli','Janusse-Peetri, Kiuma küla, Põlva vald','EE','Põlva maakond','63208',''),(2410,'Evelin','','Koitmaa','Jaama 19a','EE','Tartu','51009',''),(2460,'Tõnis','','Kipper','Kesktee 26','EE','Tallinn','12112','');
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 ('X2561       ',1802,1),('X2571       ',1812,1),('X2573       ',1815,1),('X2609       ',1852,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 (1802,1,'Oleksandr','','Ptashnyk','','Matsi talu, Soodoma küla, Kanepi vald','EE','Põlva maakond','63124',''),(1812,2,'','','','Tegram Projekt OÜ','Janusse-Peetri, Kiuma küla, Põlva vald','EE','Põlva maakond','63208',''),(1815,1,'Evelin','','Koitmaa','','Jaama 19a','EE','Tartu','51009',''),(1852,1,'Tõnis','','Kipper','','Kesktee 26','EE','Tallinn','12112','');
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;
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 ('X2561       ','EE201600003',201600003,'EE01392','01392',1,'20170315','U201600003  ','20160128','Vertikaalselt lendutõusev ja maanduv lennumasin','Flying apparatus for vertical take-off and landing',33),('X2571       ','EE201600013',201600013,'EE01391','01391',1,'20170315','U201600013  ','20160414','Käsitsi köitmise meetod','Method for bookbinding by hand',53),('X2573       ','EE201600015',201600015,'EE01393','01393',1,'20170315','U201600015  ','20160427','Universaalne liigutatav riputi','Multi-use movable hanger',0),('X2609       ','EE201600047',201600047,'EE01390','01390',1,'20170315','U201600047  ','20161108','Liha- ja juustutoodete kaste','A sauce for meat and cheese 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 */;