-- 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 ('X2534','2017-06-15'),('X2568','2017-06-15'),('X2579','2017-06-15'),('X2580','2017-06-15'),('X2582','2017-06-15'),('X2586','2017-06-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 ('X2534       ','Käesolev leiutis käsitleb e-noodivihikut, digitaalset noodikirja esitamise ja muutmise seadet, mis kasutab madala voolutarbimisega ning mittepeegelduvaid valgusekraaniga e-paber-ekraane (Electronic Paper Display - EPD). E-noodivihik on ette nähtud eelkõige kasutamiseks professionaalsetele muusikutele, kellele on oluline noodikirja suur formaat - vähemalt kaks kõrvuti asetsevat A4-formaadis lehekülge ning nootidele märkmete tegemise võimalus. E-noodivihik koosneb kahest ekraanimoodulist. Mõlemad ekraanimoodulid kasutavad ekraane diagonaali mõõduga vähemalt 13,3\'\', mis töötavad e-paber-tehnoloogial. Ekraanimoodulid on ühendatud omavahel hingesüsteemiga, mis võimaldab seadet keskelt kokku klappida ja avada ühte sirgesse tasapinda. Hingesüsteem võimaldab ekraanimoodulite üksteisest eraldamist  ning kasutamist eraldiseisva seadmena. Mõlemad ekraanimoodulid kasutavad puutetundlikku ekraanisüsteemi ja ekraanidel on taustavalgus.','The present invention relates to E-reader for sheet music. The invented device uses low power consumption and non-reflective screen technology Electronic Paper Display – EPD – with touchscreen and light layer. It is meant for displaying and annotating the digital sheets music. E-reader for sheet music is specially designed for professional musicians who need sheet music in large format (at least screens with diagonal 13,3\") and the functionality to annotate. E-reader for sheet music consists of two screen modules. Both modules use EPD screen, touchscreen and light layer. Modules are connected to each other by a hinge system, which enables the device to be bi-foldable and also opens the E-reader for sheet music 180 degrees. The hinge system allows each module to be detached to use them separately as one screen of the E-reader for sheet music.'),('X2568       ','Leiutis käsitleb kokkumonteeritava kasvuhoonesõrestiku kaarekujulist elementi, kusjuures sõrestikuelemendil on välimine kaar ja sisemine kaar, kahe kaare vahele on ühendatud sõrestikuelementi tugevdavad kõõlud. Sisemise kaare raadius on suurem kui välimise kaare raadius, sisemine kaar on U-kujulise profiiliga terasplekist, kusjuures U-harud on venitatud, et anda kaarele kaare kuju, tugevdavad kõõlud on kinnitusvahenditega omavahel ja välimise ja sisemise kaarega ühendatud. Iga element koosneb vähemalt kahest kokkumonteeritavast osast.','The invention relates to an arc-shaped truss element of mountable greenhouse, in which the truss element has an inner arc and an outer arc, between the two arcs reinforcing chords of the truss element are connected. The radius of the inner arc is greater than the radius of the outer arc, the inner arc is made of an U-shaped steel sheet, wherein the U-arms are stretched, to provide the arc an arched shape, reinforcing chords are connected by fastening means to each other and to the outer and inner arc. Each element consists of at least two assemblable parts.'),('X2579       ','Leiutis käsitleb liigendi tapi 1 ja tapikanna 2 kinnituskonstruktsiooni, mis sisaldab tappi 1 ja selle otsale 3 kinnitatud tapikanda 2. Tapi 1 otsa 3 on moodustatud tapi 1 pikitelje 5 suhtes sümmeetriliselt vastamisi asetsevate ja tapi 1 otsast eenduvate tapihammaste 6 paar või paarid, mis tööolukorras on hambumises tapikannas 2 olevate pesadega 4. Tapikanna 2 fikseerimiseks tapile 1 on tapi 1 otsa 3 selle välispinda 10 moodustatud lukustusrõngale 11 soon 12 nii, et see soon 12 asetseb tapihammaste 6 välispinnas 10. Tööolukorras on tapi 1 välispinnal 10 olevas soones 12 olev lukustusrõngas 11  ümbritsetud tapivõruga 13, mille tarvis on tapivõrus 13 ringjas süvend 14 lukustusrõngale 11.','Present invention relates to a fixation arrangement of a joint pin 1 and a pin clamp 2 comprising a pin 1 and pin clamp 2 fixed to head 3 of the pin 1. To the head 3 of the pin 1 at least one pair of pin teeth 6 are formed, which are symmetric to the longitudinal axis 5 of the pin 1 and which in the working condition engage recesses 6 in the pin clamp 2. For fixing a pin clamp 2 to the head 3 of the pin 1, a groove 12 is formed onto the outer surface 10 of the pin 1 for receiving locking ring 11, where said groove 12 is situated also in the outer surface 10 of the pin teeth 6. In the working condition in the groove 12 in outer surface 10 of the pin 1 a locking ring 11 is placed, which is enveloped by pin collar 13, which includes a circular recess 14 for receiving locking ring 11.'),('X2580       ','Käesolev leiutis käsitleb ninaprillide ergonoomilist ninakaart. Ninaprillide 1 paremaks paigaldamiseks ninale on ninaprillide ninakaar 3 varustatud nupukestega 4 ja 6, millest kaks nupukest 4 asuvad ninakaare välisküljel selliselt, et kahe näpuga oleks mugav neist haarates prille ninale sättida, ja kolmas nupuke 6 asub ninakaare 3 üleval keskel. Ninaprillide 1 ninakaar 3 on ergonoomiline, kus mõõtmistulemuste alusel välja töötatud prillide ninakaar 3 on ellipsikujuline, ellipsi raadius r1 on 7,00 mm ja r2 on 7,50 mm ning ninakaare kaldenurk a on 36°.','The present invention relates to an ergonomic bridge for nose glasses. For better placement of the reading glasses 1 on the nose, the bridge 3 of the reading glasses is provided with knobs 4 and 6, two knobs 4 located on the outside, making it comfortable to grasp and place the glasses on the nose with two fingers, and third knob 6 is located on the upper center of the bridge. The bridge 3 of the reading glasses 1 is ergonomic, where measurements of the radius of the bridge 3 of the reading glasses 1 have been developed in ellipsoidal shape, as the radius r1 is 7,0 mm and radius r2 is 7,5 mm and the angle a of the bridge is 36°.'),('X2582       ','Käesolev leiutis käsitleb taimekasvatustopsi (1), mis sisaldab õõnsat korpust (2), millel on ülemine ots ja alumine ots, mõlemad nimetatud otsad on suletud otsakatetega (3, 4), õõnsas korpuses (2) asetseb kasvukeskkond (5). Kasvukeskkonnas (5) on õõnsus (6) vähemalt ühe seemne (7) jaoks ja vähemalt alumine otsakate (4) on valmistatud veeslahustuvast materjalist.','Present invention relates to a plant growing cup (1) comprising a hollow body (2) having upper end and bottom end, both of those ends are closed by a respective lid (3, 4), inside of the hollow body (2) a grow media (5) is placed. Inside of the grow media (5) is a cavity (6) for seeds (7) and at least the bottom lid (4) made of a material dissolvable in water.'),('X2586       ','Vajaduse leiutise järele on tinginud raskeveokite varuratta nõrk turvalisus. Originaallukk on lukustatud lihtsa ripplukuga, mis on lihtsasti purustatav. Varuratta hind on kõrge, mistõttu on varuratta  vargus laialt levinud. Antud leiutis lukustab fiksaatori rattakorvi külge ning oma kuju ja materjali tugevuse tõttu on selle varguskindlus olemasolevatest alternatiividest oluliselt kõrgem. Töö põhimõte - lukukorpus asetatakse rattakorvi poldi peale ning sulgetakse poldi külge velje salamutriga. Salamutri saab sulgeda ja avada vaid selle komplekti kuuluva võtmega.','The need for this invention is drawn from the weak security of truck\'s and trailer\'s spare wheel locking. Initially the lock for truck\'s and trailer\'s spare wheel is just a padlock, which is easily breakable. Regular solutions are not secure enough and stealing of spare wheels is very common, because it\'s easy and the wheel is expensive. This certain invention locks the spare wheel fixings and thanks to its material and shape it has a much higher level of security against undesired breakdowns than the alternatives in the market. Function - the lock is placed onto the bolt of the spare wheel basket and closed to the bolt with the wheel bolt nut. The bolt nut can be closed and opened only with a unique wrench.');
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',''),(46,'LASVET Patendibüroo OÜ','Jürgen','Toome','Suurtüki 4a','Tallinn','10133','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 ('X2534       ',1),('X2568       ',1),('X2579       ',1),('X2580       ',1),('X2582       ',1),('X2586       ',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 ('X2534','201601','G09B  15/02',1,1,1,1),('X2534','201601','G06F  17/24',2,1,1,2),('X2568','201701','A01G   9/14',1,1,1,1),('X2568','201701','E04H  15/36',2,1,1,2),('X2579','201601','F16B  21/16',1,1,1,1),('X2580','201601','G02C   1/02',1,1,1,1),('X2580','201601','G02C   5/08',1,1,1,2),('X2580','201601','G02C   5/10',1,1,1,3),('X2580','201601','G02C   5/12',1,1,1,4),('X2582','201701','A01G  31/02',1,1,1,1),('X2586','201601','B62D  43/00',1,1,1,1),('X2586','201601','B62D  43/04',1,1,1,2);
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 ('X2534       ',2361,1),('X2534       ',2362,2),('X2534       ',2363,3),('X2568       ',2046,2),('X2579       ',2412,1),('X2580       ',2413,1),('X2582       ',2416,3),('X2582       ',2417,2),('X2586       ',2423,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 (2046,'Aleksei','','Farber','Ranniku tee 29/9a','EE','Tallinn','12113',''),(2361,'Siim-Juhan','','Vakker','Kivineeme 1, Neeme küla, Jõelähtme vald','EE','Harju maakond','74226',''),(2362,'Märt','','Jõesaar','Kadakaranna 13, Neeme küla, Jõelähtme vald','EE','Harju maakond','74226',''),(2363,'Ivo','','Suursoo','Ristikangru 38, Manniva küla, Jõelähtme vald','EE','Harju maakond','74217',''),(2412,'Anti','','Puusepp','Laane tee 27, Käsmu küla, Vihula vald','EE','Lääne-Viru maakond','45601',''),(2413,'Andrei','','Astapenko','Tartu mnt 10-23','EE','Tallinn','10145',''),(2416,'Lauri','','Kapp','Mõtuse 11','EE','Tallinn','10619',''),(2417,'Gregory Francis Chakwan','','Lu','Karikakra tee 18, Püünsi küla, Viimsi vald','EE','Harju maakond','74013',''),(2423,'Tarmo','','Lattu','Kase 68-103','EE','Tallinn','12012','');
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 ('X2534       ',1766,1),('X2568       ',1492,1),('X2579       ',1817,1),('X2580       ',1818,1),('X2582       ',1819,1),('X2586       ',1826,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 (1492,2,'','','','Heikkinen OÜ','Rohuneeme tee 1, Haabneeme alevik, Viimsi vald','EE','Harjumaa','74001',''),(1766,2,'','','','NotesNote OÜ','Kivineeme 1, Neeme küla, Jõelähtme vald','EE','Harju maakond','74226',''),(1817,2,'','','','OÜ Palmse Mehaanikakoda','Võsupere küla, Vihula vald','EE','Lääne-Viru maakond','45202',''),(1818,2,'','','','Glens OÜ','Tartu mnt 10-23','EE','Tallinn','10145',''),(1819,2,'','','','Natufia Labs OÜ','Tuukri 50','EE','Tallinn','10120',''),(1826,2,'','','','Trailer Lock OÜ','Kari 17-49','EE','Tallinn','10315','');
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 ('X2534       ','EE201500063',201500063,'EE01400','01400',1,'20170615','U201500063  ','20150827','E-noodivihik','E-reader for sheet music',53),('X2568       ','EE201600010',201600010,'EE01395','01395',1,'20170615','U201600010  ','20160328','Kasvuhoonesõrestiku kaarekujuline element','Arc shape element of framework of greenhouse',36),('X2579       ','EE201600017',201600017,'EE01398','01398',1,'20170615','U201600017  ','20160429','Liigendi tapi ja tapikanna kinnituskonstruktsioon','Fixation arrangement of a joint pin and a pin clamp',46),('X2580       ','EE201600018',201600018,'EE01399','01399',1,'20170615','U201600018  ','20160510','Ninaprillide ergonoomiline ninakaar','Ergonomic bgidge for nose glasses',53),('X2582       ','EE201600020',201600020,'EE01396','01396',1,'20170615','U201600020  ','20160518','Taimekasvatustops','A plant growing cup',46),('X2586       ','EE201600024',201600024,'EE01397','01397',1,'20170615','U201600024  ','20160603','Raskeveoki varuratta turvalukk ja mutrivõti','Heavy duty vehicle spare wheel\'s security lock and a wrench',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 */;