-- 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 ('X553973','2018-05-15'),('X554001','2018-05-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 ('X553973     ','Käesoleva leiutise eesmärk on takistada lukukorpusega manipuleerimist. Leiutisekohane lukukorpus (1) sisaldab keret (3), otsaplaati (2) ja kaldlukukeelt (4). Kaldlukukeel on seatud liikuma lineaarselt läbi otsaplaadi ava (11) oma sisemise asendi ja väljaulatuva lukustusasendi vahel. Kaldlukukeele (4) saab veel seada väljaulatuvasse põhiasendisse, mille korral põhiasend asub nimetatud lineaarses liikumissuunas sisemise asendi ja lukustusasendi vahel. Kaldlukukeel (4) sisaldab tipuosa (4A) ja tagaosa (4B), kus tipuosa kinnitatakse tagaosa külge kinnituskruviga (5). Vähemalt ühel lukukorpuse (1)  küljel (3A, 3B), on kinnituskruvi (5) kohal ava (7), kui kaldlukukeel (4) asub põhiasendis. Kaldlukukeel sisaldab veel süvendit (6) vähemalt ühel küljel. Süvend asub ava (7) kohal siis, kui kaldlukukeel on lukustusasendis.','The object of the invention is to prevent manipulation of the lock body. A lock body (1) according to the invention comprises a case (3), a face plate (2) and an oblique bolt (4). The oblique bolt is arranged to move linearly through the bolt hole (11) of the face plate between the inner position and the protruding locking position. The oblique bolt (4) can further be arranged into a protruding basic position, which is in a linear direction of movement between the inner position and the locking position. The oblique bolt (4) comprises a tip part (4A) and a rear part (4B), the tip part being attached to the rear part by an attachment screw (5). At least one side (3A, 3B) of the lock body (1) has a hole (7) at the site of the attachment screw (5), when the oblique bolt (4) is in the basic position. The oblique bolt further comprises a recess (6) on at least one side. The recess is at the site of the hole (7), when the bolt is in the locking position.'),('X554001     ','Käesolevas leiutises kirjeldatakse polüvinüülformaalil põhinevat granulaarset või granulaarsete@kogumite kujul taimekasvusubstraati, mis sisaldab väetisi, mikroelemente ja täiteaineid, samuti@kirjeldatakse selle taimekasvusubstraadi valmistamise meetodit. Polüvinüülformaalil põhinevat@taimekasvusubstraati kasutatakse iseseisvalt või segatuna muude olemasolevate@taimekasvusubstraatidega (taimekasvukeskkondadega). Polüvinüülformaalil põhinev taimekasvusubstraat on olemuselt hüdrofiilne poorne granulaarne materjal, mille pooride suurus jääb vahemikku 5-500 µm, keskmiselt 100 µm. Homogeense taimekasvusubstraadina kasutamisel võib taimekasvusubstraat olla lahtiste graanulitena, graanulitest pressitud mahulise materjalina või juba sünteesitud võimalikult lõpptoote taoliselt (minimaalset mehaanilist töötlemist vajaval kujul).@','The present invention describes a polyvinylformal-based granular plant growth medium containing fertilizers, microelements and fillers, and method of preparing thereof. The polyvinylformal-based plant growth medium is used separately or mixed with known plant growth substrates (mediums). The polyvinylformal-based plant growth medium is a hydrophilic porous granular material, wherein the size of pores is between 5-500 µm, an avarage size of pores is 100 µm. When used as a homogenous plant growth substrate it may be in the form of loose granules, volumetric material obtained by extrusion of granules or it may be synthesized as an end product (requiring minimal mechanical treatment).');
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 (36,'AAA Patendibüroo OÜ','Tõnu','Nelsas','Tartu mnt 16','Tallinn','10117',''),(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 ('X553973     ',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 ('X553973','201501','E05B  63/04',1,1,1,1),('X553973','201501','E05B  63/20',2,1,1,2),('X554001','201801','A01G  24/30',1,1,1,1),('X554001','201801','A01G  24/42',2,1,1,2),('X554001','201601','C08F   8/28',2,1,1,3),('X554001','201601','C08F  16/06',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 ('X553973     ',14417,1),('X553973     ',14418,2),('X554001     ',14474,1),('X554001     ',14475,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 (14417,'Lauri','','Kojola','Urheilutie 25','FI','Nousiainen','FI-21270',''),(14418,'Toni','','Kivilähde','Hakametsäntie 10 A','FI','Salo','FI-24280',''),(14474,'Priit','','Post','Rohuneeme tee 54a, Pringi küla, Viimsi vald','EE','Harju maakond','74011',''),(14475,'Rene','','Peterson','Tuulemaa 9/15-38','EE','Tallinn','10312','');
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 ('X553973     ',3355,1),('X554001     ',3594,1),('X554001     ',3595,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 (3355,2,'','','','Abloy Oy','Wahlforssinkatu 20','FI','Joensuu','FI-80100',''),(3594,1,'Priit','','Post','','Rohuneeme tee 54a, Pringi küla, Viimsi vald','EE','Harju maakond','74011',''),(3595,1,'Rene','','Peterson','','Tuulemaa 9/15-38','EE','Tallinn','10312','');
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 ('X553973     ','FI','2013/05098','WO','2014/68177','20140508');
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 ('X553973','FI','20126131','20121031',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 ('X553973     ','EE201500015',201500015,'EE05804','05804',2,'20180515','P201500015  ','20131014','Lukukorpus','Lock body',52),('X554001     ','EE201500033',201500033,'EE05803','05803',2,'20180515','P201500033  ','20151123','Polüvinüülformaalil (PVFO) põhinev taimekasvusubstraat ja selle valmistamise meetod','Polyvinylformal (PVFO) based plant growth medium and method of preparing thereof',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 */;

