-- 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 ('X554049','2019-02-15'),('X554065','2019-02-15'),('X554066','2019-02-15'),('X554118','2019-02-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 ('X554049     ','Leiutis on ette nähtud põlevkivi tahke soojuskandjaga töötlemisel saadud aurugaasisegu puhastamisel kasutatud põlevkiviõli raskfraktsiooni puhastamiseks selles puhastusprotsessis kogunenud tahketest osakestest. Selleks valmistatakse puhastamisele kuuluvast raskfraktsioonist, põlevkivibensiinist ja fenoolveest puhastatav segu, mida vajadusel töödeldaks flokulandiga ja mis seejärel lahutatakse tsentrifugaaldekanteris veefraktsiooniks, tahkeks fraktsiooniks ja orgaaniliseks fraktsiooniks. Veefraktsiooon juhitakse tagasi puhastatava segu valmistamise protsessi, tahke fraktsioon suunatakse pürolüüsi, orgaaniline fraktsioon lahutatakse destillatsioonikolonnis põlevkivibensiiniks ja puhtaks põlevkiviõli raskfraktsiooniks.','The invention is provided for purifying shale oil heavy fraction having been contaminated with solid impurities in the process of wet purifying of the gas-vapour mixture obtained in the pyrolysis process of oil shale. For this, the composition to be purified is prepared from contaminated shale oil heavy fraction, petrol and phenol-water, which in case of necessity is additionally treated with flocculant. Subsequently, the mixture is separated in the centrifugal decanter to water fraction, solid fraction and organic fraction. The water fraction is sent back to the process of preparing the composition for purification, the solid fraction is sent for pyrolysis and the organic fraction is separated to the petrol and pure shale oil heavy fraction in a distillation device.'),('X554065     ','Leiutis kuulub ilmastikunähtustel põhinevate tsüklilise talitlusega toitesüsteemide valdkonda on kasutatav kompostisegisti elektriajami varustamiseks elektrienergiaga ja mille primaarenergiamuunduri väljundvõimsus on väiksem elektriajami võimsusest. Leiutuse sisuks on kompostisegisti elektriajami toitesüsteem, mis sisaldab primaarenergiamuundurit, kondensaatorpatareid, primaarenergiamuunduri lülitit, juhtseadet ja elektriajami lülitit. Kompostisegistit käitatakse tsükliliselt kondensaatorpatarei perioodilise täislaadimisega primaarenegiamuundurist ja tühjakslaadimisega elektriajamile tingimustes, kus primaarenergiamuunduri väljundvõimsus on väiksem elektriajami poolt tarbitavast võimsusest.','The invention belongs to the domain of weather-powered cyclically operating supply systems is used to supply electric energy to compost tumbler\'s electric drive and in which the primary energy converters power output is less than the load power of the electric drive. The invention relates to an electric power supply system for a compost tumbler, comprising a primary energy converter, a capacitor battery, a primary energy converter\'s switch, control device and electric drive switch. The compost tumbler is operated cyclically by periodic recharge of the capacitor battery from the primary energy converter and discharge to the electric drive in conditions where the primary energy converter\'s power output is less than the load power of the electric drive.'),('X554066     ','Leiutis käsitleb komposiitkeraamikat ja eelkõige funktsionaalselt gradeeritud elektrit ja soojust juhtivat keraamikat, mis sisaldab keraamilisi metallioksiidkiudusid, mis on kaetud mitme kihi grafeeniga. Komposiit on liigendatud nii mehaaniliste omaduste, nimelt murdetugevuse ja kõvaduse järgi, kui ka elektrijuhtivuse ja soojusjuhtivuse järgi. Struktuurselt on ka tera suurus materjali eri kihtides olulisel määral ja ettekavandatavalt gradeeritav.','The invention relates to composite ceramics, and more particularly to functionally graded electro- and thermo-conductive ceramics comprising metal oxide ceramic fibres wrapped into several layers of graphene. The composite has graduation in terms of mechanical properties, namely fracture toughness and hardness; electroconductivity and thermal conductivity. Structurally, the grain size in different layers of the material also has significant and tailorable graduation.'),('X554118     ','Pidevroomiksüsteemi lüliliige sisaldab kaht külgliiget ja kaht tihvtliiget, kusjuures kaks külgliiget asuvad üksteise vastas ja on omavahel ühendatud kahe tihvtliikmega ning tihvtliikmed on pikiliikmed, mille lateraalristlõikel on üks sümmeetriatelg.','A link member for a continuous track system comprising two side members, and two pin members, wherein the two side members oppose each other and are joined by the two pin members, and wherein the pin members are longitudinal members having a lateral cross section with a single axis of symmetry.');
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'),(52,'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 ('X554049     ',1),('X554065     ',1),('X554118     ',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 ('X554049','201801','C10G  31/10',1,1,1,1),('X554049','201801','B01D  21/26',2,1,1,2),('X554049','201801','B01D  21/01',2,1,1,3),('X554065','201801','B01F   9/02',1,1,1,1),('X554065','201801','H02J   7/00',1,1,1,2),('X554065','201801','H02J   7/35',2,1,1,3),('X554065','201801','H02J  15/00',1,1,1,4),('X554066','201801','C04B  35/01',1,1,1,1),('X554066','201801','C04B  35/10',1,1,1,2),('X554066','201801','C04B  35/52',1,1,1,3),('X554066','201801','C04B  35/565',1,1,1,4),('X554066','201801','C04B  35/584',1,1,1,5),('X554118','201801','B62D  55/04',1,1,1,1),('X554118','201801','B62D  55/205',2,1,1,2),('X554118','201801','B60C  27/08',2,1,1,3),('X554118','201801','F16G  15/00',2,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 ('X554049     ',14562,1),('X554049     ',14563,2),('X554049     ',14564,5),('X554049     ',14565,6),('X554049     ',14566,7),('X554049     ',14567,8),('X554065     ',14121,3),('X554065     ',14590,1),('X554065     ',14591,2),('X554066     ',14523,3),('X554066     ',14592,1),('X554066     ',14593,2),('X554118     ',14688,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 (14121,'Jüri','','Olt','Keskasula 21, Kuremaa','EE','Jõgeva maakond','48445',''),(14523,'Irina','','Hussainova','Ehitajate tee 5','EE','Tallinn','19086',''),(14562,'Nikolai','','Ostrouhhov','Põhja allee 24-30','EE','Kohtla-Järve','30324',''),(14563,'Igor','','Velmar','Mureli 11','EE','Jõhvi','41535',''),(14564,'Nikolai','','Petrovitð','Jaama 41','EE','Jõhvi','41532',''),(14565,'Meelis','','Eldermann','Loomuse 9','EE','Tallinn','13516',''),(14566,'Alexander','','Fedotov','Võidu prospekt 1-47','EE','Narva','21008',''),(14567,'Vasily','','Pivovarov','Ravi 6-5','EE','Kohtla-Järve','30322',''),(14590,'Hardi','','Hõimoja','Fr. R. Kreutzwaldi 56/1','EE','Tartu','51014',''),(14591,'Vladimir','','Rjurikov','Fr. R. Kreutzwaldi 56/1','EE','Tartu','51014',''),(14592,'Maria','','Drozdova','Ehitajate tee 5','EE','Tallinn','19086',''),(14593,'Roman','','Ivanov','Ehitajate tee 5','EE','Tallinn','19086',''),(14688,'Stewart','','Kelly','21 Alexandra Meadows','GB','Lockerbie Dumfries&Galloway','DG11 2SA','');
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 ('X554049     ',2905,1),('X554065     ',3387,1),('X554066     ',328,1),('X554118     ',3720,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 (328,2,'','','','Tallinna Tehnikaülikool','Ehitajate tee 5','EE','Tallinn','19086',''),(2905,2,'','','','VKG OIL AS','Järveküla tee 14','EE','Kohtla-Järve','30328',''),(3387,2,'','','','Eesti Maaülikool','Fr. R. Kreutzwaldi 1a','EE','Tartu','51014',''),(3720,2,'','','','Clark Tracks Limited','Irongray Park','GB','Dumfries DG2 0HT, Scotland','','');
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;
INSERT INTO `ypct` VALUES ('X554118     ','GB','2016/05139','WO','17/194905','20171116');
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 ('X554049     ','EE201700009',201700009,'EE05816','05816',2,'20190215','P201700009  ','20170220','Meetod põlevkiviõli raskfraktsiooni puhastamiseks tahketest osakestest','Method for purifying shale oil heavy fraction from solid impurities',18),('X554065     ','EE201700025',201700025,'','',1,'20190215','P201700025  ','20170706','Kompostisegisti elektriajami toitesüsteem','Power supply system of a compost tumbler',0),('X554066     ','EE201700026',201700026,'','',1,'20190215','P201700026  ','20170707','Funktsionaalselt gradeeritud omadustega keraamiline komposiitmaterjal','A ceramic composite material with functionally graded properties',0),('X554118     ','EE201800030',201800030,'','',1,'20190215','P201800030  ','20160513','Roomiksüsteemi täiustused või roomiksüsteemiga seotud täiustused','Improvements in or relating to track apparatus',52);
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 */;

