-- 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 ('X2620','2018-11-15'),('X2648','2018-11-15'),('X2649','2018-11-15'),('X2659','2018-11-15'),('X2674','2018-11-15'),('X2681','2018-11-15'),('X2688','2018-11-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 ('X2620       ','Leiutis käsitleb ümberpööratava kaanega käsitöökarpi, mis sisaldab põhjaga ja külgseinaga korpust (1), kaant (2) ja tasapinnalist magnetelementi (3) kaane (2) sisemisel küljel, kaane (2) ristlõikes astmelise külgprofiili alumine aste (4) ulatub korpuse (1) siseküljeni (5) ja alumisest astmest (4) kõrgemal asetsev ja sellest külgsuunas eenduv aste (6) toetub korpuse (1) ülemisele servale (7) ja ulatub korpuse (1) välisküljeni (8). Uudne on see, et kaane (2) ristlõikes astmelisel külgprofiilil on kaane (2) välimisel küljel lisaaste (9), mis paikneb külgsuunas eenduvast astmest (6) kõrgemal ja ulatub korpuse (1) siseküljeni (5).','The invention relates to a sewing box with a reversible lid comprising a body (1) with a bottom and side wall, a lid (2) and a plane magnet element (3) on the inside of lid (2), whereas the lower step (4) of the lid with a stepped cross section extends to the inner side (5) of the body (1) and the step (6) positioned higher than the bottom step (4) and laterally extending from it, rests on the top edge (7) of the body (1) and extends to the outer side (8) of the body (1). Novelty lies in the additional step (9) of the side profile with a stepped cross section, which is positioned on the outside of lid (2), higher than the laterally extending step (6), and extends to the inner side (5) of the body (1).'),('X2648       ','Käesolev leiutis esitab kalastuslandi. Kalastuslandi konksul on kinnihaakumise vastane kaitse. Konksukaitse on konksu teravikupoolset osa ehk konksu põlve ja konksu teravikku ümbritsev ühest või mitmest tamiilist koosnev aas. Kalastuslandi peibutis on kinnitatud konksusäärele, kusjuures konksusääre külge on kinnitatud ka lanti tasakaalustav täiendav raskus, mis eelistatud teostuses on konksusääre  ümber keritud tina- või pliitraat. Konksu peapoolsesse otsa on kinnitatud kaks kala 3D-silma kujutavat kumerat plaati, mis on eelistatud teostuses omavahel kokku fikseeritud epoksiidliimiga. Epoksiidliimi sisse võib olla segatud erinevat värvi sätendavaid osakesi kala tähelepanu äratamiseks. Leiutise ühe alternatiivse variandi kohaselt on kasutatud kahte teineteise suhtes järjestikku paigaldatud konksu. Leiutise ühe alternatiivi kohaselt on kalastuslandi ette metallrõngaga kinnitatud pöörlev lant.','The present invention provides a fishing lure. The hook of the fishing lure has a protection against hooking. The protection includes a loop of one or several fishing lines surrounding the point portion of the hook, i.e. surrounding the bend and the point of the hook. Bait of the fishing lure is attached to the shank, wherein a balancing additional weight is also attached to the shank, which in a preferred embodiment is a tin or lead wire winded around the shank. Two curved plates depicting 3D fish eyes are attached to the eye end of the hook, which in a preferred embodiment are attached with epoxy resin. Into the epoxy resin different shining particles of different colors may be mixed to attract the attention of fish. In one alternative embodiment of the invention two hooks in series with respect to each other are used. In one alternative embodiment of the invention in front of the fishing lure a rotating bait attached by a metal ring.'),('X2649       ','Leiutis käsitleb päikesepaneelide kinnitamise vahendit, mis sisaldab metall-lehte ja raskust, kusjuures metall-leht on painutatud nii, et on moodustatud esimene kinnitusserv, teine kinnitusserv, lame  põhjasektsioon, mis paikneb esimese kinnitusserva ja teise kinnitusserva vahel, esimene kaldsektsioon, mis paikneb esimese servasektsiooni ja lameda põhjasektsiooni vahel, ja teine kaldsektsioon, mis  paikneb teise servasektsiooni ja lameda põhjasektsiooni vahel, kusjuures esimese kinnitusserva ja teise kinnitusserva paiknemise tasapinnad on paralleelsed, ning kusjuures raskus on paigutatud lamedale põhjasektsioonile. Uudne on see, et lamedal põhjasektsioonil on vähemalt kaks kinnitussõlme raskuse jaoks ja lamedat põhjaosa saab enne päikesepaneelide paigaldamist lihtsa tööoperatsiooniga poolitada, kusjuures kinnitussõlmeks on metall-lehte läbiv keermestatud ava. Keermestatud avaga on aksiaalselt ühendatud keermestatud tugevduselement, milleks võib olla otsak või mutter.','The invention relates to solar panel fastening means that comprises a sheet of metal and a weight, whereas the sheet of metal is bent to form a first mounting surface, a second mounting surface, a flat bottom section between the first and second mounting surfaces, a first inclined section between the first mounting surface and the flat bottom section, and a second inclined section between the second mounting surface and the flat bottom section, whereas the planes of the first and second mounting surfaces are parallel and the weight is positioned on the flat bottom section. The novelty lies in the flat bottom section having at least two fixing units for the weight and the flat bottom section can be split with an easy operation, whereas the fixing unit is comprised of a threaded aperture through the metal sheet. A threaded reinforcing element is axially connected to the threaded aperture being either a nozzle or a nut.'),('X2659       ','Leiutis käsitleb joondamisnööri 1 kinnitusseadet 2, mis sisaldab kinnituspuksi 3 ja kinnituskruvi 6 kinnitusseadme 2 ehituskonstruktsiooni külge kinnitamiseks. Kinnituspuksis 3 on läbiv ava 5 kinnituskruvile 6 ning kinnituspuksile 3 on moodustatud ringjas juhtsoon 4, 4\' joondamisnööri 1 juhtimiseks. Kinnitusseade 2 sisaldab kinnituspuksiga 3 jäigalt ühendatud mähkimispooli 7, milles on soon 8 joondamisnööri 1 soonde 8 mähkimisega kinnitamiseks.','Present invention relates to a fastening device 2 for a guide line 1, said device 2 comprises a mounting bushing 3 and a fixing screw 6 for fastening said fastening device 2 to a building structure. The mounting bushing 3 comprises a through hole for the fixing screw 6 and onto the mounting bushing 3 a circular groove 4, 4\' is formed for guiding said guide line 1. The fastening device 2 comprises a wrapping spool 7 rigidly connected to said mounting bushing 3, where said wrapping spool 7 comprises a groove 8 for attaching guide line 1 by wrapping said guide line 1 into said groove 8.'),('X2674       ','Leiutise sisuks on ravimivõtmise meeldetuletuse seade, mis koosneb omavahel ühendatud käevõrust (mikrokontrolleri, Bluetooth-liidese, LED-lambikeste, toiteploki ja loenduriga) ja ravimikarbist (ravimite laegaste, mikrokontrolleri, Bluetooth-liidese, digitaal-analoogmuunduri, heligeneraatori, toiteploki, loenduri, lüliti ja anduritega). Leiutis kuulub meditsiini valdkonda ja pakub patsiendile arsti poolt määratud ravimite võtmist raviplaani (kuupäevade ja kellaaegadega) alusel ja seda meeldetuletustega isevalitud laulu või muusikapala saatel. Ravimivõtmise meeldetuletuse seade võimaldab ravimikarbi näol ühtset ravimite hoiupaika, kui patsient peab ravikuuri ajal samaaegselt mitmeid erinevaid ravimeid võtma.','The Medication Reminder Device consists of a mutually connected bracelet (microcontroller, Bluetooth interface, LED-bulbs, power supply and counter) and medicine box (medicine compartments, microcontroller, Bluetooth interface, digital analogue converter, sound generator, power supply unit, counter, switch and sensors). The invention belongs to the medical field; it provides the patient with a way of taking prescription-only medicines on the basis of a treatment plan (dates and times) and is equipped with a reminder in the form of a self-selected song or piece of music. The invention provides a single medicine storage unit in the form of a box in a situation where the patient is required to take various medicines simultaneously during the course of treatment.'),('X2681       ','Leiutis käsitleb meetodit väävli eemaldamiseks naftasaaduste st, mis hõlmab soojusvahetis eelnevalt 40-90 °C juures kuumutatud naftasaaduse segamist segistis normaalrõhul kaltsiumiühendeid sisaldava adsorbendiga osakeste peensusega 40-150 µm ja väävlit sisaldava tahke faasi moodustamist segus ning seejärel saadud segust väävlit sisaldava tahke faasi eraldamist. Uudne on see, et pärast segistis segamist viiakse konverteris läbi naftasaaduse ja adsorbendi täiendav segamine ja sidumine. Konverteris toimub lisaks väävli efektiivsemale füüsikalisele sidumisele adsorbendiosakestega ka keemiline sidumine. Tehnoloogilise protsessi toimimiseks on vajalik naftasaaduse piisav voolavus. Sõltuvalt desulfureeritava naftasaaduse viskoossusest toimub segamine konverteris normaalrõhul või ülerõhul.','The invention relates to a method for removing sulfur from oil products that involves mixing oil product preheated to 40–90 °C in a heat exchanger at atmospheric pressure in a mixer with an absorbent containing calcium compounds and with particle size 40–150 µm, the formation of a solid phase containing sulfur, and removing the solid phase containing sulfur from the resulting mix. Novelty lies in additional mixing and binding of oil products and absorbent in a converter after the mixing in the mixer. In addition to more effective physical binding of sulfur in the converter, chemical binding also takes place. For the technological process to function, sufficient fluidity of the oil product is required. Depending on the viscosity of the oil product to be desulfurized, the mixing in the converter takes place at normal or high pressure.'),('X2688       ','Kühvellabidas sisaldab üles käänatud külgmiste äärte ja tagumise äärega labaosa, mille põhi on ligikaudu põhja keskosast kühvellabida varre poole kaldu. Labaosa esiserv on eendunud samas tasapinnas labaosa põhja esiosast, esiserv on sirgjooneline ja otstest kumerdatud nurkadega, kusjuures üleskäänatud külgmiste äärte ülemine serv on kaldu ka labaosa tagumise ääre suunas. Labaosa ja vart ühendav ühendusosa ulatub ligikaudu labaosa keskosani, kusjuures ühendusosa küljest eenduvad diagonaalselt labaosa esiserva nurkadesse tugevdusribid.','The shovel includes a blade section with lateral and rear sides with edges folded upwards, where the base is at an angle of inclination from approximately the centre of the base towards the shaft of the shovel. The front edge of the blade section reaches outwards at the same level with front part of the base of the blade section, is rectilinear and has rounded corners, while the top edge of lateral sides folded upwards is also at an angle towards the rear edge of the blade section. The joint connecting the blade section and shaft reaches approximately to the centre of the blade section, while reinforcement ribs reach diagonally from the joint to the corners in the front edge of the blade section.');
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',''),(37,'Patendibüroo Turvaja OÜ','Riho','Pikkor','Liivalaia 22','Tallinn','10118','EE'),(41,'Patendi- & Kaubamärgibüroo Koitel OÜ','Raivo','Koitel','Tina 26','Tallinn','10126','EE'),(46,'LASVET Patendibüroo OÜ','Jürgen','Toome','Suurtüki 4a','Tallinn','10133','EE');
UNLOCK TABLES;
/*!40000 ALTER TABLE `yagent` ENABLE KEYS */;

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

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

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


/*!40000 ALTER TABLE `ybdata` DISABLE KEYS */;
LOCK TABLES `ybdata` WRITE;
INSERT INTO `ybdata` VALUES ('X2620       ',1),('X2648       ',1),('X2649       ',1),('X2659       ',1),('X2674       ',1),('X2681       ',1),('X2688       ',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 ('X2620','201801','A41H  19/00',1,1,1,1),('X2620','201801','D05B  91/12',2,1,1,2),('X2648','201701','A01K  85/00',1,1,1,1),('X2648','201701','A01K  85/02',1,1,1,2),('X2649','201801','E04D  13/18',1,1,1,1),('X2649','201801','F24S  80/58',1,1,1,2),('X2659','201801','E04G  21/18',1,1,1,1),('X2674','201801','A61J   7/04',1,1,1,1),('X2674','201801','G06F  19/00',2,1,1,2),('X2681','201801','C10G  19/00',1,1,1,1),('X2688','201801','A01B   1/02',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 ('X2620       ',2477,1),('X2648       ',2508,1),('X2649       ',2509,1),('X2659       ',2515,1),('X2674       ',2538,1),('X2674       ',2539,2),('X2681       ',2548,1),('X2681       ',2549,2),('X2681       ',2550,3),('X2681       ',2551,4),('X2688       ',2556,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 (2477,'Helen','','Kaigu','Kase 22a','EE','Tallinn','12011',''),(2508,'Edvin','','Kevvai','Tamme 15-79, Haapsalu','EE','Lääne maakond','90508',''),(2509,'Taavi','','Lipstok','Punane 73','EE','Tallinn','13619',''),(2515,'Tarmo','','Raidma','Suur Kaar 20-1','EE','Tartu','50404',''),(2538,'Greta Madeleine','','Gnannt','Idapõllu tee 7-30, Haabneeme','EE','Harju maakond','74001',''),(2539,'Margus','','Suurmets','Idapõllu tee 7-30, Haabneeme','EE','Harju maakond','74001',''),(2548,'Jakov','','Saprõkin','Maja 7, Vatslaveere AÜ, Vatsla küla, Saue vald','EE','Harju maakond','76915',''),(2549,'Vitaly','','Petrov','Paldiski mnt 227-9','EE','Tallinn','13520',''),(2550,'Jaan','','Külaviir','Sütiste tee 16-57','EE','Tallinn','13411',''),(2551,'Boris','','Kipnis','Liivalaia 30-35','EE','Tallinn','10118',''),(2556,'Ülo','','Vanamb','Wismari 24/2','EE','Tallinn','10136','');
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 ('X2620       ',1870,1),('X2648       ',1894,1),('X2649       ',1895,1),('X2659       ',1902,1),('X2674       ',1925,1),('X2681       ',1933,1),('X2681       ',1934,2),('X2681       ',1935,3),('X2681       ',1936,4),('X2688       ',1940,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 (1870,1,'Helen','','Kaigu','','Kase 22a','EE','Tallinn','12011',''),(1894,1,'Edvin','','Kevvai','','Tamme 15-79, Haapsalu','EE','Lääne maakond','90508',''),(1895,2,'','','','Energogen OÜ','Punane 73','EE','Tallinn','13619',''),(1902,1,'Tarmo','','Raidma','','Suur Kaar 20-1','EE','Tartu','50404',''),(1925,1,'Margus','','Suurmets','','Idapõllu tee 7-30, Haabneeme','EE','Harju maakond','74001',''),(1933,1,'Jakov','','Saprõkin','','Maja 7, Vatslaveere AÜ, Vatsla küla, Saue vald','EE','Harju maakond','76915',''),(1934,1,'Vitaly','','Petrov','','Paldiski mnt 227-9','EE','Tallinn','13520',''),(1935,1,'Jaan','','Külaviir','','Sütiste tee 16-57','EE','Tallinn','13411',''),(1936,1,'Boris','','Kipnis','','Liivalaia 30-35','EE','Tallinn','10118',''),(1940,1,'Ülo','','Vanamb','','Wismari 24/2','EE','Tallinn','10136','');
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 ('X2620       ','EE201600058',201600058,'EE01441','01441',1,'20181115','U201600058  ','20161222','Ümberpööratava kaanega käsitöökarp','Sewing box with a reversible lid',37),('X2648       ','EE201700024',201700024,'EE01440','01440',1,'20181115','U201700024  ','20170414','Kalastuslant','Fishing lure',36),('X2649       ','EE201700025',201700025,'EE01444','01444',1,'20181115','U201700025  ','20170418','Päikesepaneelide kinnitamise vahend','Solar panel fastening means',37),('X2659       ','EE201700031',201700031,'EE01445','01445',1,'20181115','U201700031  ','20170622','Joondamisnööri kinnitusseade','A fastening device for a guide line',46),('X2674       ','EE201700044',201700044,'EE01442','01442',1,'20181115','U201700044  ','20171018','Ravimivõtmise meeldetuletusseade','Medication Reminder Device',0),('X2681       ','EE201700051',201700051,'EE01443','01443',1,'20181115','U201700051  ','20171222','Meetod väävli eemaldamiseks naftasaadustest','Method for removing sulfur from oil products',37),('X2688       ','EE201800001',201800001,'EE01439','01439',1,'20181115','U201800001  ','20180105','Kühvellabidas','Shovel',41);
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 */;

