-- 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 ('X2359','2015-10-15'),('X2369','2015-10-15'),('X2393','2015-10-15'),('X2450','2015-10-15'),('X2456','2015-10-15'),('X2458','2015-10-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 ('X2359       ','Kasulik mudel käsitleb lasertöötlussüsteemi lauda mittemetalsete läbipaistvate materjalide töötlemiseks, eriti süsteemi metalsete, nt madala kiirgusvõimega materjali kattekihtide eemaldamiseks klaasilt. Lasertöötlussüsteemi laud mittemetalsete läbipaistvate materjalide töötlemiseks laserkiirgusega sisaldab tööpinda, millel on vähemalt üks laua kattekiht töödeldava materjali paigutamiseks, kusjuures vähemalt üks laua kattekiht on valmistatud materjalist, mis on läbipaistev laserkiirguse jaoks lainepikkuste vahemikus 300 kuni 3000 nm ja mis kujutab endast kinnise kärgstruktuuriga elastselt painduvat vahtmaterjali. Tehniline efekt seisneb selles, et materjali töötlemise käigus, näiteks madala kiirgusvõimega materjali kattekihi eemaldamisel klaasitootelt läbi klaasi kulgeva fokusseeritud laserkiirega hajub kiir laua kattekihis täielikult või osaliselt madala energiatiheduse W/cm2 nivooni.','The utility model relates to table of laser processing system for processing of nonmetallic transparent materials, in particular, for removing metallic, for example, low-emission and other coatings from glass. Laser processing system table for processing nonmetallic transparent materials comprises a work surface on which at least one covering layer is provided for positioning the processed material, said at least one covering layer being made of a material transparent to laser radiation in the wavelength range of from 300 to 3000 nm and representing an elastically flexible foam material with a closed-cell structure. The technical effect is that in the course of processing a material, e.g. removing a low-emission coating from a glass article, by a focused laser beam passing through the glass volume, the beam is fully or partially scattered in the covering layer to a low power density W/cm2.'),('X2369       ','Leiutis kuulub vee keemilise koostise reaalajas määramise valdkonda rasketes keskkonnatingimustes, kus kasutatakse laser-kaugtuvastuse seadet nafta või õliproduktide avastamiseks. Merevee naftareostuse õigeaegne avastamine ja lokaliseerimine aitavad minimeerida mere- ja rannikualade keskkonna potentsiaalseid kahjusid. Leiutise eesmärgiks on luua seade vee keemilise saaste kaugtuvastamiseks ja klassifitseerimiseks eriti rasketes keskkonnatingimustes: jäises jäätükkidega vees, kõrge soolsuse, suure niiskuse ja madala temperatuuri korral koos seadme tööparameetrite, kaalu, gabariitmõõtmete ja energiatarbe optimiseerimisega. Seade töötab liikuva laeva või statsionaarse platvormi pardal pidevalt järelevalveta koos andmetöötluse ja tulemuste saatmisega sidekanalitele. LIDARi moodul on konstrueeritud hermeetiliselt suletud sisemise korpuse (6) sisse, mis on täidetud ülerõhu all oleva lämmastikuga (N2). Sisemine korpus asub välimise korpuse (1) sees. Õli avastamiseks arvutab LIDARi mikrokontroller (9) GPS-andmetele tuginedes välja laserkiirguri muutuva kordussageduse, millega on tagatud automaatselt toimuvate mõõtmiste puhul eelnevalt määratud konstantne ruumiline eraldusvõime.','The invention relates to the field of real-time detection of chemical contamination of water in harsh environmental conditions by using laser remote sensing apparatus for detection of oil or oil products. In-time detection and localization of oil pollution in seawater are the measures to minimize potential damages to the marine and coastal environment. The object of the present invention is to provide a device for remote detection and classification of chemical pollution in water in harsh environmental conditions such as high salinity, humidity and low temperature, to optimize operational parameters, weight, size and power consumption of such device, to make possible continuous unattended operation of such device on board of a moving or stationary platform and to provide data processing and reporting the results through communication channels. The LIDAR is designed inside the hermetical internal housing (6) filled with N2 at overpressure. The internal housing is located inside the external housing (1). For remote oil detection with variable Pulse Repetition Rate of the laser emitter is calculated by LIDAR microcontroller (9) based on GPS data to provide pre-set constant spatial resolution in underway measurements.'),('X2393       ','Leiutis käsitleb andurseadet in situ vees leiduvate fotosünteesivate mikrovetikate kontaktivabaks tuvastamiseks. Välja pakutud kompaktne, kontaktivaba ja optiline andurseade fotosünteesivate vetikate, sh sinirohevetikate, vesikeskkonnas kindlaks tegemiseks on väikese kaaluga ja võimsustarbega, suuteline töötama pidevalt, ilma järelevalveta, seda kas autonoomselt või võrgus tuvastava seadmena. Andurseade on suuteline jälgima veekogu distantsilt ja andma vees leiduva fütoplanktoni biomassi kvantitatiivse hinnangu. Selle võib paigaldada ükskõik missugusele vee kohal olevale platvormile ankurdatud või ujuvale poile kasuliku koormusena. Käesoleva leiutise kohane andurseade on sobiv fütoplanktoni koguse pidevaks jälgimiseks tavalises merevees, jõe- ja järvevees, veesisselaskekohtades ja tööstusseadmetes.','Present invention relates to a sensing device for in-situ non-contact detection of photosynthetic microalgae in water. A compact non-contact optical sensing device with low weight and power consumption for detection of photosynthetic algae, including blue-green algae, in water environment is provided. The device is capable of operating continuously, unattended, as a stand-alone or network sensing device. The sensing device is able to observe the water body at the distance and provide quantitative estimation of phytoplankton biomass in water. It can be installed on any platform above the water surface or as a payload for moored or floating buoys. The sensing device according to the present invention is suitable for continuous monitoring of the abundance of phytoplankton in natural seawater, river and lake waters, at water intake, and in industrial installations.'),('X2450       ','Käesolev leiutis käsitleb mobiiltelefoni kasutavat alarmseadet, täpsemalt mehhaanilist alarmseadet, millesse on integreeritud mobiiltelefon alarmi edastamiseks. Alarmseade sisaldab korpust ja fikseerimisvahendit mobiiltelefoni fikseerimiseks korpusesse. Alarmseadme korpusel on telefoni klahvile vajutamise süsteem alarmi edastamiseks.','The present invention relates to an alarm system using mobile phone, specifically mechanical alarm device, in which is integrated the mobile phone for alarm transmission. The alarm device includes a body and a fixing device for fixing a mobile phone in the body. The body of the alarm device has a system for pressing the mobile phone key for making the telephone call for alarm transmission.'),('X2456       ','Käesolev leiutis käsitleb joogipakendit, mis sisaldab taaskasutatavast esimesest materjalist kestaosa 101 ja taaskasutatavast teisest materjalist siseosa 102 joogi säilitamiseks. Joogipakend sisaldab  väliskesta külge kinnitatud ning osaliselt väliskesta ümbritsevat mehaanilist rebitavat vahendit 103, mis on paigutatud väliskesta, et see vahend lõhuks rebides nii, et rebitava vahendi rebimise ja kestaosa lõhkumise järel on võimalik eraldada siseosa 102 joogipakendist.','The present invention relates to a beverage package 100, comprising a skin portion 101 of first recyclable material and an inner portion 102 of second recyclable material for holding a beverage. The beverage package comprises a mechanical tearing means 103 provided on the outer skin, encircling at least partially the outer skin, and being adapted to substantially cut outer skin upon being ripped off, so that the inner portion 102 is removable from the beverage package after cutting the outer skin in order not to disrupt the sorted dumpster contents.'),('X2458       ','Leiutiseks on alusmatt-kandelinaga telkmantel, mis sisaldab tõmblukkudega ühendatud alusmatt-kandelina ja telkmantlit. Tõmblukud ühendavad telkmantli ja alusmatt-kandelina tihedalt nii, et vihm, tuul  ja putukad ei pääse külgedelt kasutajale ligi. Toode pakub sarnast kaitset nagu lihtsamad telgid, samas on alusmatt-kandelinaga telkmantli kõiki osasid võimalik eraldi kasutada.','The invention is a sleeping-carrying mat poncho, which includes sleeping-carrying mat and poncho, which are joint with zippers. The zippers join poncho and sleeping-carrying mat tightly in a way that rain, wind and insects will not reach user from sides. The product provides similar protection as a simple tent and also permits using all parts separately.');
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'),(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'),(46,'LASVET Patendibüroo OÜ','Jürgen','Toome','Suurtüki 4a','Tallinn','10133','EE'),(53,'Patendibüroo Käosaar & Co 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 ('X2359       ',1),('X2369       ',1),('X2393       ',1),('X2450       ',1),('X2456       ',1),('X2458       ',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 ('X2359','201501','B23K  26/40',1,1,1,1),('X2359','201501','B23K  26/36',2,1,1,2),('X2359','201501','B23K  26/10',2,1,1,3),('X2369','201501','G01N  21/64',1,1,1,1),('X2369','201501','G01N  21/15',2,1,1,2),('X2369','201501','G01S  17/88',2,1,1,3),('X2393','201501','G01N  21/64',1,1,1,1),('X2450','201501','G08B  13/08',1,1,1,1),('X2450','201501','H04M  11/04',2,1,1,2),('X2456','201501','B65D  77/06',1,1,1,1),('X2456','201501','B65D   5/54',2,1,1,2),('X2458','201501','E04H  15/02',1,1,1,1),('X2458','201501','A45F   4/12',2,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 ('X2359       ',2159,1),('X2359       ',2160,2),('X2369       ',2174,1),('X2369       ',2175,2),('X2393       ',2174,2),('X2393       ',2175,6),('X2393       ',2203,3),('X2393       ',2204,4),('X2450       ',1717,1),('X2456       ',2280,1),('X2458       ',1461,2);
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 (1461,'Aivar','','Närep','Mahla 83-6','EE','Tallinn','11215     ',''),(1717,'Igor','','Sominski','Endla 55-21','EE','Tallinn','10615     ',''),(2159,'Valentin Sergeevich','','Chadin','ul. Karier, d. 4, kv. 6, pos. Obukhovo, Noginsky r-n','RU','Moskovskaya oblast 142440','',''),(2160,'Alekper Kamalovich','','Aliev','ul. Babushkina, d. 10b, kv. 2','RU','g. Noginsk, Moskovskaya oblast 142407','',''),(2174,'Sergei','','Babitšenko','Lohu 12','EE','Tallinn','12618     ',''),(2175,'Leino','','Vint','Lohu 12','EE','Tallinn','12618     ',''),(2203,'Larissa','','Porõvkina','Lohu 12','EE','Tallinn','12618     ',''),(2204,'Innokenti','','Sobolev','Lohu 12','EE','Tallinn','12618     ',''),(2280,'Jenny','','Soukkan','Kanslersvägen 31','SE','Skarpnäck','SE-12838  ','');
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 ('X2359       ',1712,1),('X2369       ',1591,1),('X2393       ',1591,1),('X2450       ',1307,1),('X2450       ',1684,2),('X2450       ',1685,3),('X2456       ',1697,1),('X2458       ',1021,2);
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 (1021,1,'Aivar','','Närep','','Mahla 83-6','EE','Tallinn','11215',''),(1307,1,'Igor','','Sominski','','Endla 55-21','EE','Tallinn','10615',''),(1591,2,'','','','LDI Innovation OÜ','Lohu 12','EE','Tallinn','12618',''),(1684,1,'Sergei','','Šolohhov','','Uus-Maleva 9-15','EE','Tallinn','11711',''),(1685,1,'Hainer','','Õunapuu','','Põllu 44','EE','Tallinn','11619',''),(1697,2,'','','','Altia Oyj','Porkkalankatu 22','FI','Helsinki','FI-00180',''),(1712,2,'','','','\"LASCOM\" Limited Liability Company','ul. Zhukovskogo, d.2, str.24','RU','g. Dubna, Moskovskaya oblast 141983','','');
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 ('X2359','RU','RU2013102280','20130117',1),('X2456','FI','U20134235','20131107',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 ('X2359       ','EE201300082',201300082,'EE01318','01318',1,'20151015','U201300082  ','20131001','Lasertöötlussüsteemi laud mittemetalsete läbipaistvate materjalide töötlemiseks','Laser processing system table for processing nonmetallic transparent materials',37),('X2369       ','EE201300092',201300092,'EE01321','01321',1,'20151015','U201300092  ','20131125','Seade nafta avastamiseks kaugseirel','Device for remote oil detection',15),('X2393       ','EE201400015',201400015,'EE01322','01322',1,'20151015','U201400015  ','20140318','Andurseade in situ vees leiduvate fotosünteesivate mikrovetikate kontaktivabaks tuvastamiseks','Sensing device for in-situ non-contact detection of photosynthetic microalgae in water',46),('X2450       ','EE201400065',201400065,'EE01323','01323',1,'20151015','U201400065  ','20140929','Mobiiltelefoni kasutav alarmseade','Alarm system using mobile phone',0),('X2456       ','EE201400071',201400071,'EE01319','01319',1,'20151015','U201400071  ','20141105','Joogipakend','Beverage packaging',53),('X2458       ','EE201400073',201400073,'EE01320','01320',1,'20151015','U201400073  ','20141120','Alusmatt-kandelinaga telkmantel','Sleeping-carrying mat poncho',36);
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 */;