-- 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 ('X2691','2019-07-15'),('X2706','2019-07-15'),('X2707','2019-07-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 ('X2691       ','Leiutise objektiks on mööbliese, esmajoones riiul või kummut, kus mööbliese sisaldab aluskonstruktsiooni, ristkülikukujulist põhjaplaati (2), vähemalt ühte hoiuruumi ja katteplaati (4). Et mööbliese oleks lihtsasti kokku pandav ning oleks võimalik selle mõõtmeid ja proportsioone muuta ja oleks võimalik ka tagantjärele mööblieseme muutmine eri vajadusteks, on hoiuruum moodustatud moodulist (8), mis sisaldab põhja, seinu ja katet, kus põhjaplaadi (2) ülapinnas on ühendusvahendid mooduli vastuvõtmiseks ja lahtivõetavalt kinnitamiseks põhjaplaadile, ning katteplaadi (4) alapinnas on ühendusvahendid mooduli vastuvõtmiseks ja lahtivõetavalt kinnitamiseks katteplaadi külge, kus ühendusvahendid on lisaks paigutatud üksteisega risti olevatele sirgetele.','Present invention relates to a piece of furniture, such as a shelf or dresser, where said piece of furniture comprises a substructure, a rectangular bottom plate (2), at least one storage space and a cover plate (4). In order to said furniture being easily erectable and in order to enable modification of dimensions and proportions of such furniture afterwards to meet different needs, the storage space is formed from a module (8) comprising a base, walls and a cover, where the upper surface of the base plate (2) comprises fastening means for receiving and detachably fixing the module to the base plate, and the bottom surface of the cover plate (4) comprises fastening means for receiving and detachably fixing the module to the cover plate, where the fastening means are arranged to the crossing lines.'),('X2706       ','Reguleeritav taimetugi sisaldab lahtivõetavatest elementidest tugijalga, mille külge on kinnitatud reguleeritavate ühenduselementidega lahtivõetavatest elementidest tugirõngas.','Adjustable plant support comprising a support leg of demountable elements having a support ring of demountable elements attached to it with adjustable fastening means.'),('X2707       ','Leiutis kuulub kütuste tootmise, keemiatehnoloogia ja jäätmekäitluse valdkonda ning käsitleb plastjäätmete koospürolüüsi meetodit, kus õli kvaliteedi tõstmiseks plastjäätmeid koospürolüüsitakse koos anorgaaniliste materjaliga ning plastjäätmete osakaal moodustab kuni 85% pürolüüsitava segu massist. Koospürolüüsi tulemusena tekivad gaas, õli ja tahke jääk erinevates vahekordades. Leiutise eesmärk on lahendada plastjäätmete pürolüüsil tekkiva õli kvaliteedi probleem, vältimaks õlikomponentide taaskondensatsiooni ja tahkete osakeste tekkimist õlis. Anorgaanilise materjalina kasutatakse koospürolüüsi protsessis silikaatkivimina liiva, karbonaatkivimina põlevkivi kaevandamisel tekkivat aherainet, tuhana põlevkivitööstuses tekkivat elektri- või õlitootmise jääktuhka. Plastjäätmete koospürolüüsi  meetodit saab otseselt rakendada väikesemahulises tootmisettevõttes väiksema võimsusega lihtsa konstruktsiooniga pürolüüsiseadmetes, mis koosnevad perioodilisest kuumutatavast pürolüüsireaktorist, tekkiva aurugaasi segu kondensatsiooni süsteemist ja sellest eralduva gaasi utiliseerimise seadmest.','The invention relates to the field of fuel production, chemical engineering and waste management, and deals with the method of co-pyrolysis of plastic waste, whereby plastic waste is co-pyrolyzed with inorganic material to increase the quality of oil, and the proportion of plastic waste accounts for up to 85% of the pyrolysis mixture. As a result of co-pyrolysis, gas, oil and solid residue are produced in different proportions. The purpose of the invention is to solve the problem of the quality of oil produced by the pyrolysis of plastic waste in order to prevent the re-condensation of the oil components and the formation of solid particulates in the oil. As an inorganic material, the co-pyrolysis process uses carbonate rock as a result of the extraction of oil shale, silicate sand, and inorganic residues (ashes) from oil shale industry. The co-pyrolysis of plastic waste can be directly applied to a small-scale production plant as batch process with simple structure of pyrolysis equipment consisting from a pyrolysis reactor, condensation system for a steam-gas mixture and a gas utilization unit.');
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 (18,'LASVET Patendibüroo OÜ','Jaak','Ostrat','Suurtüki 4a','Tallinn','10133','EE'),(41,'Patendi- & Kaubamärgibüroo Koitel OÜ','Raivo','Koitel','Tina 26','Tallinn','10126','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 ('X2691       ',1),('X2706       ',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 ('X2691','201901','A47B  47/00',1,1,1,1),('X2691','201901','A47B  67/04',2,1,1,2),('X2691','201901','F16B  12/00',2,1,1,3),('X2706','201901','A01G   9/12',1,1,1,1),('X2707','201901','C10B  53/07',1,1,1,1),('X2707','201901','C10G   1/00',2,1,1,2),('X2707','201901','F23G   5/027',1,1,1,3),('X2707','201901','F23G   7/12',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 ('X2691       ',2560,1),('X2706       ',2583,1),('X2707       ',2584,1),('X2707       ',2585,2),('X2707       ',2586,3),('X2707       ',2587,4);
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 (2560,'Hannu','','Ojala','Rahikkatie 88','FI','Kauhajoki AS','FI-61850',''),(2583,'Rein','','Kaubi','Leino talu, Kihlevere küla, Kadrina vald','EE','Lääne-Viru maakond','45215',''),(2584,'Hella','','Riisalu','Järveküla tee 75','EE','Kohtla-Järve','30322',''),(2585,'Olga','','Pihl','Järveküla tee 75','EE','Kohtla-Järve','30322',''),(2586,'Dmitri','','Suštšik','Järveküla tee 75','EE','Kohtla-Järve','30322',''),(2587,'Julia','','Kapralova','Järveküla tee75','EE','Kohtla-Järve','30322','');
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 ('X2691       ',1944,1),('X2706       ',1961,1),('X2707       ',266,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',''),(1944,2,'','','','Leo-Matti Ojala Oy','Rahikkatie 88','FI','Kauhajoki AS','FI-61850',''),(1961,2,'','','','Brek OÜ','Leino talu, Kihlevere küla, Kadrina vald','EE','Lääne-Viru maakond','45215','');
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 ('X2691','FI','U20174072','20170313',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 ('X2691       ','EE201800004',201800004,'EE01467','01467',1,'20190715','U201800004  ','20180302','Mööbliese','A piece of furniture',18),('X2706       ','EE201800017',201800017,'EE01466','01466',1,'20190715','U201800017  ','20180619','Reguleeritav taimetugi','Adjustable plant support',41),('X2707       ','EE201800018',201800018,'EE01468','01468',1,'20190715','U201800018  ','20180719','Plastjäätmete koospürolüüsi meetod','Method of co-pyrolysis of plastic waste',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 */;

