-- 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 ('X2352','2015-09-15'),('X2389','2015-09-15'),('X2395','2015-09-15'),('X2396','2015-09-15'),('X2452','2015-09-15'),('X2501','2015-09-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 ('X2352       ','Elektrilise impedantsi modulaarne mõõtesüsteem kuulub elektroonsete mõõtesüsteemide valdkonda, mis on orienteeritud impedantsi sagedussõltuvuse ehk impedantsi spektri mõõtmisele. Väljatöötatud mitmesageduslik ja mitmepaigaline impedantsi mõõtmise süsteem võimaldab suurendada või vähendada kanalite arvu mõõtesüsteemis väga paindlikult vastavalt tegeliku mõõteolukorra vajadustele, jäädes instrumentaalselt (riistvaraliselt) lähedale üksiku paljukanalilise instrumendi vormile. Leiutis on ette nähtud rakendamiseks bioloogiliste objektide puhul, kuid kasutusala pole sellega piiratud.','Modular system for the measurement of electrical impedance belongs to the field of electronic systems for electrical measurements, orientated to the measurement of frequency response or spectrum of the impedance. Created multifrequency and multisite measurement system enables to increase and decrease the number of channels in the measurement system very flexibly, according to the needs of actual measurement situation, instrumentally still remaining near to the single multichannel instrument. The invention is foreseen, but not limited for application in the field of biological objects.'),('X2389       ','Esitatud puitsilla konstruktsioon sisaldab kaldasammast, kaldasambaistmeid, millele omakorda toetub peakandja, puitlamellidest sillatekiplaati, hüdroisolatsiooni ja fiiberbetoonkatet. Silla pealesõidu konstruktsioon moodustub kaldasamba kehandist koos geovõrguga tugevdatud pinnasega. Peakandja otstesse on paigaldatud toekannad. Puitlamellidest sillatekiplaat on valmistatud eri kõrgustega vahelduvatest puitlamellidest, mis on omavahel ühendatud naelte abil, kusjuures üks nael ühendab kolm lamelli. Peakandja ja sillatekiplaat on ühendatud erinevate kruvidega. Sillatekiplaadi lamellide külge on ankurdatud nihkekobad. Sillatekiplaat on kaetud enne betoneerimist hüdroisolatsiooniga ja selle peale on paigaldatud fiiberbetoonkate.','A present timber bridge construction comprises an abutment, a girder supported on the seat of abutment, a laminated bridge deck, a laminate sheeting and a cover of fibre reinforced concrete. The connection between abutment and embankment is formed of soil reinforced with geogrid. The bearing shoes are mounted to the ends of the girder. The laminated timber bridge deck is fabricated from the alternating different heigth wooden lumbers connected to each other by nails wherein one nail connects three lumbers. The girders and the laminated bridge deck are connected by different screws. The shear screws are anchored to lumbers of the bridge deck. The bridge deck is covered with the laminate sheeting before concreting and the cover of the fibre reinforced concrete is placed on the laminate sheeting.'),('X2395       ','Süsteem valgustusseadme kalibreerimiseks ja juhtimiseks pakub tarkvara funktsionaalsust valgustussüsteemidele, mida võib kasutada filmis, televisioonis või fotograafias. See sisaldab omavahel ühendatud juhtimis- ja toiteüksuseid, mida saab kasutada \'\'virnana\'\', ning valgusteid koos transiivermoodulitega ja valgusti väliste juhtimisseadmetega. Antud süsteemi tarkvara koosneb virtuaalse spektromeetri funktsioonist, mis sisaldab multispektraalsete otsingutabelite kalibratsiooni kasutaja täielikuks navigatsiooniks värviruumis (näiteks CIE-1931), mis võtab arvesse kasutaja ja ümbruse muutujad, kasutab interpolatsioonikõveraid ja mis võimaldab täiendamiseks kasutada välist riistvara, kus vastava funktsiooni navigatsioon on lisatud puutetundlikule seadmele. Süsteem sisaldab täiendavalt hallkaardi ümbrusvalguse tuvastamise funktsiooni, mis võimaldab kiirendada soovitavate värvuste seadistamist, ning kommunikatsiooni alamsüsteemi, mis võimaldab pakettsidet erinevate omavahel ühendatud juhtimis- ja toiteüksuste ja/ning väliste valgusjuhtimisseadmete vahel.','The system for calibration and controlling of lighting device provides software functionality to a light system that may be used in film, television or photography, that consists of interconnected power supply and control units that can be used in a \'stack\', and lamp units, with attachable transceiver modules and external light control devices. The software for this system consists of a \'virtual spectrometer\' feature that includes calibration of the multi-spectral look-up tables for full user navigation in a color space (e.g. CIE-1931) that takes into account user and ambient variables, uses interpolation curves, and that could be further refined by using external hardware; navigation is included on a touchscreen-enabled device for said feature. The system also includes a \'gray card ambient light detection\' feature to speed up the setup of desirable colors, a communications subsystem that allows packet communications between multiple interconnected power supply and control units and an external light control device.'),('X2396       ','Leiutis pakub kasvuhooneakna automaatavaja konstruktsiooni, mis sisaldab eelistatud teostuses temperatuuri mõjul kesktelje ümber pöörduvat metall-liistu, kusjuures liistu kahe äärmise otsa külge on pööratavalt ühendatud vardad, nii et varraste teised otsad on ühendatud õhutusaknaga.','Invention provides a design of an automatic opener of the greenhouse window, which in a preferred embodiment comprises a metal lath pivoting around central axis caused by temperature, wherein two ends of the metal lath are pivotably connected to rods so that the other ends of the rods are connected to a ventilation window.'),('X2452       ','Leiutis kuulub füsioteraapia valdkonda, täpsemalt inimese kehal olevate reflektoorsete punktide stimuleerimiseks ette nähtud seadmete hulka ning on kasutatav nii individuaalse massaaživahendina kui ka masseerija poolt käsimassaaži läbiviimiseks. Seade sisaldab tööosa, pidet ja saba, kusjuures saba on ühendatud pidemega ja ette nähtud massaaživahendi kinnitamiseks kohakindlalt seinakinnituse abil hoone seina külge. Tööosa on peamiselt munaja kujuga, mille eesmine, väiksema kumerusraadiusega ots on ette nähtud inimese valupunkti mõjutamiseks ning pidemepoolne tagumine, suurema kumerusraadiusega  osa on jäigalt kinnitatud pideme külge.','The invention belongs to the field of physiotheraphy, in particular to the devices designed for stimulating reflex point on the body, and it can be used as an individually used massage tool or by a masseuse in the course of giving a massage. The device consist of the operational part, a handle, and a tail, whereby the tail is connected to the handle and designed for attachment of the massage tool to the wall firmly mount with fixing device. The operational device is mainly egg-shaped, the front of wich has a smaller radius of curvature, and is designed for manipulation of person\'s pain spot. And the thicker end on the side of the handle is rigidly connected to the handle.'),('X2501       ','Puuri tipunurga kontrollimise seade võimaldab kontrollida spiraalpuuri tipunurga õigsust ja sümmeetrilisust puuri telje suhtes valguspilu järgi puuri lõikeserva ja kontrollnurga sümmeetriatasapinna vahel. Puuri tipunurga kontrollimise seade sisaldab alust 1, pööratavat šabloonplaati 5, mille mõlemas servas on rida erineva suurusega kontrollnurki 6, kahe prismaatilise soonega 3, 4 kaheosalist reguleeritava pikkusega tugiliistu 2, mis on kinnitatud aluse 1 külge kruvidega 11, koonilise tipuga silindrilist abinõu 8 puuri tipunurgale vastava kontrollnurga 6 asendi täpseks sättimiseks prismaatilise kujuga soone 3 või 4  suhtes, ning aluse 1 sisse paigaldatud vooluringi koos valgust hajutava ekraaniga 9.','The control device for drill tip angle enables checking the precision of the tip angle of the spiral drill and its symmetricity in relation to the drill axis using a light slit between the cutting edge and the symmetry plane of the control angle. The control device for drill tip angle consists of a base 1, rotating stencil plate 5, both edges of which have control angles of various sizes 6, with two prismatic seams 3, 4 two-part support slats with regulated length 2, which are attached to base 1 using screws 11, cylindrical support vessel with conical tip 8 for setting the control angle 6 precisely for prismatic seam 3 or 4, and a circuit inside base 1 with light dispersing screen 9.');
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 (15,'OÜ Moorlat & Ko Patendibüroo','Ott','Moorlat','pk 4730','Tallinn','13503','EE'),(17,'Danteks OÜ','Jüri','Olt','Keskasula 21, Kuremaa','Jõgeva maakond','48445','EE'),(36,'AAA Patendibüroo OÜ','Tõnu','Nelsas','Tartu mnt 16','Tallinn','10117',''),(41,'Patendi- & Kaubamärgibüroo Koitel OÜ','Raivo','Koitel','Tartu mnt 65','Tallinn','10115',''),(54,'Patendibüroo Kaitsepurus OÜ','Arvi','Uukivi','Mulla 4-3','Tallinn','10611','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 ('X2352       ',1),('X2389       ',1),('X2395       ',1),('X2396       ',1),('X2452       ',1),('X2501       ',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 ('X2352','201501','A61B   5/053',1,1,1,1),('X2389','201501','E01D   1/00',1,1,1,1),('X2389','201501','E01D   2/02',2,1,1,2),('X2389','201501','E01D  19/08',2,1,1,3),('X2395','201501','G03B  15/00',1,1,1,1),('X2395','201501','G05B  23/02',2,1,1,2),('X2395','201501','H05B  33/08',2,1,1,3),('X2395','201501','H05B  37/00',2,1,1,4),('X2396','201501','E05F   3/00',1,1,1,1),('X2396','201501','A01G   9/24',2,1,1,2),('X2452','201501','A61H  39/04',1,1,1,1),('X2501','201501','B23Q  17/00',1,1,1,1),('X2501','201501','G01B   3/14',1,1,1,2),('X2501','201501','G01B   5/213',1,1,1,3),('X2501','201501','G01B   5/24',1,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 ('X2352       ',2144,1),('X2352       ',2145,2),('X2352       ',2146,3),('X2352       ',2147,4),('X2352       ',2148,5),('X2352       ',2149,6),('X2389       ',2112,2),('X2395       ',2207,1),('X2395       ',2208,2),('X2395       ',2209,3),('X2396       ',2046,2),('X2452       ',2274,1),('X2501       ',2330,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     ',''),(2112,'Priit','','Willbach','Kadaka pst 102-11','EE','Tallinn','10922     ',''),(2144,'Marek','','Rist','Ehitajate tee 5','EE','Tallinn','19086     ',''),(2145,'Mart','','Min','Kuklase 3-4','EE','Tallinn','13424     ',''),(2146,'Paul','','Annus','Harju 5-12','EE','Tallinn','10146     ',''),(2147,'Raul','','Land','Akadeemia tee 7A-17','EE','Tallinn','12611     ',''),(2148,'Toomas','','Parve','Rännaku pst 3-7','EE','Tallinn','10917     ',''),(2149,'Marko','','Reidla','Ehitajate tee 5','EE','Tallinn','19086     ',''),(2207,'Kaspar','','Kallas','Niine 11','EE','Tallinn','10414     ',''),(2208,'Eduard','','Vaselo','Niine 11','EE','Tallinn','10414     ',''),(2209,'Kaur','','Kallas','Niine 11','EE','Tallinn','10414     ',''),(2274,'Erki','','Mets','Reinu talu, Annikvere küla, Põltsamaa vald','EE','Jõgeva maakond','48004     ',''),(2330,'Vjatšeslav','','Zahharov','Energia 7-1','EE','Tallinn','11316     ','');
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 ('X2352       ',266,2),('X2352       ',1573,3),('X2389       ',1616,1),('X2395       ',1621,1),('X2396       ',1492,2),('X2452       ',1691,1),('X2501       ',1741,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 (266,2,'','','','Tallinna Tehnikaülikool','Ehitajate tee 5','EE','Tallinn','19086',''),(1492,2,'','','','Heikkinen OÜ','Rohuneeme tee 1, Haabneeme alevik, Viimsi vald','EE','Harjumaa','74001',''),(1573,2,'','','','OÜ ELIKO Tehnoloogia Arenduskeskus','Mäealuse 2/1','EE','Tallinn','12618',''),(1616,2,'','','','Nordpont OÜ','Madara 25','EE','Tallinn','10612',''),(1621,2,'','','','Digital Sputnik Lighting OÜ','Niine 11','EE','Tallinn','10414',''),(1691,1,'Erki','','Mets','','Reinu Talu, Annikvere küla, Põltsamaa vald','EE','Jõgeva maakond','48004',''),(1741,1,'Vjatšeslav','','Zahharov','','Energia 7-1','EE','Tallinn','11316','');
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 ('X2352       ','EE201300075',201300075,'EE01312','01312',1,'20150915','U201300075  ','20130829','Elektrilise impedantsi modulaarne mõõtesüsteem','Modular system for the measurement of the electrical impedance',0),('X2389       ','EE201400011',201400011,'EE01315','01315',1,'20150915','U201400011  ','20140307','Puitsilla konstruktsioon','Timber bridge construction',41),('X2395       ','EE201400017',201400017,'EE01317','01317',1,'20150915','U201400017  ','20140328','Süsteem valgustusseadme kalibreerimiseks ja juhtimiseks','System for calibration and controlling of lighting device',15),('X2396       ','EE201400018',201400018,'EE01316','01316',1,'20150915','U201400018  ','20140401','Kasvuhooneakna automaatavaja konstruktsioon','Design of an automatic opener of the greenhouse window',36),('X2452       ','EE201400067',201400067,'EE01313','01313',1,'20150915','U201400067  ','20141015','Massaaživahend','Massage tool',17),('X2501       ','EE201500032',201500032,'EE01314','01314',1,'20150915','U201500032  ','20150416','Puuri tipunurga kontrollimise seade','Control device for drill tip angle',54);
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 */;