-- 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 ('X554017','2018-06-15'),('X554036','2018-06-15'),('X554078','2018-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 ('X554017     ','Käesolev leiutis käsitleb põlevkivilendtuhka sisaldavat polümeerkomposiitmaterjali, mis sisaldab 70 kuni 90 massiprotsenti põlevkivilendtuhka ja 10 kuni 30 massiprotsenti polümeeri. Välja pakutud komposiit on ette nähtud lisamiseks polümeermaterjalile selle omaduste muutmiseks, armatuuri tekitamiseks tootes ja/või täiteainena valmistoote hinna alandamiseks.','The present invention is related to polymer composite material, which contains oil shale ash from 70 to 90% by weight and polymer from 10 to 30% by weight. The proposed composite material is intended to be added to the polymer material to modify its properties, to create the armature to the product and/or to reduce the price of the finished product as a filler.'),('X554036     ','Süsteem ja meetod kalapüügiks jäätunud veekogust vee aereerimise abil hõlmab vähemalt ühte veekogu kaldal asuvat ehitist, milles on vähemalt üks õhuhapnikuga rikastamise segisti. Vesi pumbatakse jäätunud veekogust segistisse, kus toimub vee ohustamine, ja seejärel suunatakse ohustatud vesi veekogusse tagasi. Leiutis ühendab endas vee ohustamist, kalakasvatust ja turvalist talvist kalapüüki kaldaga ühendatud sillalt ja väldib hapnikupuudust jäätunud veekogus ning peatab oluliselt kalade massilise talvise hukkumise ja vähendab ohtlike mikroorganismide ja mürgiste gaaside tekkimist veekogus. Süsteemis ja meetodis on esmakordselt esitatud uus segisti tüüp, antikollineaarne difuusor, mis on ette nähtud komponentide difuusseks koostoimimiseks ja toimib ka teiste gaaside ja vedelike puhul.','The system and method for fishing from iced waters using water aeration comprises at least one building located on the coast of the water body and at least one mixer for water aeration is in the building. The water is pumped from the iced water body into the mixer, where the aeration of water takes place, and after that aerated water is directed back into the water body. The invention combines the aeration of water, fish breeding and safe fishing during winter from connected with coast bridge and avoids massive death of fish in iced water, reducing the content of dangerous microorganisms and development of poisonous gases. New type of mixer, represented in the system and method, called anti-collinear diffuser, is provided for diffusive interaction of components and is also suitable for other gases and liquids.'),('X554078     ','Avaldatakse meetod krüptograafilise liitsignatuuri genereerimiseks. Nimetatud meetodi koostisse kuulub mingi sõnumi ja esimese osaleja signatuuri esimese osa vastuvõtt, kusjuures see esimese osaleja signatuuri esimene osa on tuletatud sõnumist ja esimese privaatvõtme esimesest osakust. Peale selle kuuluvad meetodi koostisse esimese osaleja signatuuri genereerimine esimese osaleja signatuuri esimesest osast ja esimese privaatvõtme teisest osakust ning teise osaleja signatuuri genereerimine sõnumist ja teisest privaatvõtmest. Peale selle kuulub meetodi koostisse esimese osaleja signatuuri ja teise osaleja signatuuri kombineerimine krüptograafilise liitsignatuuri genereerimiseks. Avaldatakse ka vahend ja masinloetav andmekandja selle meetodi teostuseks.','Disclosed herein is a method for generating a composite cryptographic signature. The method comprises receiving a message and a first part of a first party signature, wherein the first part of the first party signature is derived from the message and a first share of a first private key. The method further comprises generating a first party signature from the first part of the first party signature and a second share of the first private key and generating a second party signature from the message and a second private key. The method further comprises combining the first party signature and the second party signature to generate a composite cryptographic signature. An apparatus, a computer-readable medium for implementing this method are also disclosed.');
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 (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 ('X554036     ',1),('X554078     ',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 ('X554017','201601','C09C   3/10',1,1,1,1),('X554017','201601','C04B  18/04',2,1,1,2),('X554017','201601','C04B  18/06',2,1,1,3),('X554017','201601','B29C  47/10',2,1,1,4),('X554017','201601','B29C  47/36',2,1,1,5),('X554017','201601','B29C  47/76',2,1,1,6),('X554017','201601','B29C  47/78',2,1,1,7),('X554036','201701','A01K  63/04',1,1,1,1),('X554036','201701','C02F   7/00',1,1,1,2),('X554078','201801','H04L   9/08',1,1,1,1),('X554078','201801','H04L   9/32',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 ('X554017     ',14504,1),('X554036     ',14541,1),('X554078     ',14610,1),('X554078     ',14611,2),('X554078     ',14612,3),('X554078     ',14613,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 (14504,'Ivar','','Viira','Kesk-Sõjamäe 3D','EE','Tallinn','11415',''),(14541,'Svetlana','','Abels','Järve tee 4-58, Klooga alevik, Keila vald','EE','Harju maakond','76703',''),(14610,'Ahto','','Buldas','Mäealuse 2/1','EE','Tallinn','12618',''),(14611,'Peeter','','Laud','Mäealuse 2/1','EE','Tallinn','12618',''),(14612,'Mart','','Oruaas','Mäealuse 2/1','EE','Tallinn','12618',''),(14613,'Aivo','','Kalu','Mäealuse 2/1','EE','Tallinn','12618','');
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 ('X554017     ',3612,1),('X554036     ',3631,1),('X554078     ',3674,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 (3612,2,'','','','Mineralplast OÜ','Kesk-Sõjamäe 3D','EE','Tallinn','11415',''),(3631,1,'Svetlana','','Abels','','Järve tee 4-58, Klooga alevik, Keila vald','EE','Harju maakond','76703',''),(3674,2,'','','','Cybernetica AS','Mäealuse 2/1','EE','Tallinn','12618','');
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 ('X554036','EE','U201500082','20151211',1),('X554036','EE','U201500083','20151211',2),('X554078','GB','1617620.8','20161018',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 ('X554017     ','EE201600010',201600010,'EE05806','05806',2,'20180615','P201600010  ','20160422','Põlevkivilendtuhka sisaldav polümeerkomposiitmaterjal ja meetod selle valmistamiseks','A polymer composite material containing oil shale ash and method for manufacture its',52),('X554036     ','EE201600026',201600026,'EE05805','05805',2,'20180615','P201600026  ','20161124','Süsteem ja meetod kalapüügiks jäätunud veekogust vee aereerimise abil','System and method for fishing from iced waters using water aeration',0),('X554078     ','EE201700036',201700036,'','',1,'20180615','P201700036  ','20171018','Meetod, seade ja süsteem krüptograafilise liitsignatuuri genereerimiseks ning masinloetav andmekandja','Method, device and system for generating a composite cryptographic signature and a computer readable medium',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 */;

