-- 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 ('X553812','2016-06-15'),('X553910','2016-06-15'),('X553924','2016-06-15'),('X553941','2016-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 ('X553812     ','Leiutis käsitleb saha tugiraami, mille põhielement on kandetala 2, mida saab tõstesilindriga 3 tõsta üles-alla ja tala nihutussilindriga 4 pöörata vasakule-paremale. Raami konstruktsioon toimib kahekordse parallelogrammina. Nimelt vertikaaltasandis toimiva parallelogrammi moodustavad kandetala 2 ja ühenduslüli 5 koostöös sahaga 1 ja sõiduki küljes oleva kinnitusalusega 6, horisontaaltasandis toimiva parallelogrammi moodustavad kandetala 2 ja pöördsilinder 7 koostöös sahaga 1 ja sõiduki küljes oleva kinnitusalusega 6. Leiutisekohane tugiraam erineb selle poolest, et tänu ühenduslüli 5 kasutamisele säilib tugiraamil lumesahkade puhul traditsiooniline \"parallelogrammi\" omadus, millega on tagatud transpordiasendis ülestõstetud saha jäämine maapinnaga paralleelseks.','The invention provides a support frame of a plough, the main element of which is a bearing beam 2, which can be lifted up-down by a lift cylinder 3 and turned to left-right by a beam move cylinder 4. The frame of the construction acts as a double parallelogram. Namely the parallelogram acting in vertical plane is formed by the bearing beam 2 and the connecting element 5 in cooperation with the plough 1 and fixing mount 6 on the vehicle, the parallelogram acting in horisontal plane is formed by bearing beam 2 and turn cylinder 7 in cooperation with the plough 1 and fixing mount 6 on the vehicle. Support frame according to the invention differs in that due to the use of connecting element 5 the support frame maintains the feature of traditional \"parallelogram\" of the snow ploughs, which ensures that the raised plough in transport position remains parallel to the ground.'),('X553910     ','Leiutiseks on prügipakkimisseade, mis on mõeldud küljelt- või eestlaetavale prügiveokile või eraldi seisvale presskonteinerile. Pakkimisseade sisaldab horisontaalselt tõukesilindritega liikuvat pressplaati ja sellega ühendatud trumlile keritavat transportöörlinti. Leiutise eesmärgiks on vältida prügi kogunemist pressplaadi taha pressimise ajal. Transportöörlinti saab trumlilt lahti kerida ja seetõttu saab pressplaat pikemalt liikuda ning prügi on võimalik lõpuni kokku pressida, mille tulemusel saavutatakse suurem kokkupressimise aste ja vastavalt ka suurem kogutava prügi kogus. Pressplaadi abil on võimalik prügi prügiveoki kerest või eraldiseisvast prügikonteinerist välja lükata ilma neid kallutamata.','The invention is a garbage-packing device for a side or front loading garbage track or a separate container. The packing device contains a horisontal cylinder moving press plate which is joined to the conveyor belt which is reelable on the drum. The purpose of the invention is to avoid garbage accumulation behind the press plate during packing. Conveyor belt is rolled up around the drum and therefore it is possible to obtain longer move of the press plate and it is possible to pack garbage until the end, by which higher compaction rate is obtained and accordingly bigger amount of collected garbage. Press plate enables to remove garbage from container without tipping.'),('X553924     ','Leiutis käsitleb meetodit reoveest lämmastiku ja fosfori ärastamist segregeeritud aktiivmuda koosluste abil kaheastmelises biopuhastis, mille kohaselt esimeses astmes viiakse sisenev reovesi (1) kokku aktiivmudasettega (8), väljuv segu (7) suunatakse vahesetitisse (6), millest reostust sisaldav selitatud vesi (10) viiakse teises astmes läbi oksilise tsooni (11) lõppsetitisse (13), milles see separeeritakse aktiivmudasetteks (14) ja selitatud veeks (15), kusjuures aktiivmudasete (14) juhitakse tagasi oksilisse tsooni (11). Uudne on see, et kummaski astmes kasutatakse segregeeritud aktiivmudasid ja nitraate sisaldav selitatud (15) vesi suunatakse (17 või 18) lõppsetitist (13) tagasi anoksilisse tsooni (4), kus viiakse läbi adenosiindifosfaadi konversioon adenosiintrifosfaadiks.','The invention relates to a method of biological removal of nitrogen and phosphor from waste water using segregated activated sludge compounds in a two-stage biological treatment plant, according to which in the first stage the incoming waste water (1) is merged with circulating sludge sediment (8), the resulting mix (7) is directed into intermediate sedimentation basin (6) from where clarified water (10) is led in the second stage through an oxic zone (11) into final sedimentation basin (13) where it is separated into active sludge sediment (14) and clarified water (15), whereas sediment (14) is led back to the oxic zone (11). Novelty lies in the use of segregated activated sludges in both stages and in clarified water (15) containing nitrates being led (17 or 18) from the final sedimentation basin (13) back to the anoxic zone (4), where the conversion of adenosine diphosphate into adenosine triphosphate takes place.'),('X553941     ','Leiutis käsitleb teehooldusmasina saha terahoidja konstruktsiooni. Leiutise terahoidja sisaldab elastselt deformeeruvast materjalist osa, milles on õhuga täidetud tühimik. Tühimikuga külgnevad terahoidja osad moodustavad küljelt vaadates parallelogrammi lülid, kus on ülemine liikuv lüli, alumine liikuv lüli, eesmine liikuv lüli ja tagumine liikumatu lüli. Deformeeruvast materjalist terahoidja osal on tühimiku poolses osas hambad, mis on kohandatud teel olevast takistusest üle liikumise korral omavahel haakuma. Sellise haakumisega on tagatud terahoidja suurem tagastusjõud algasendisse ja välditud olukorda, kus terahoidja võib jääda ilma tagastuseta tööasendisse. Selleks, et eelreguleerida tera asendit nii, et tera ja teepinna vaheline nurk oleks vastavalt konkreetsele vajadusele, on terahoidjal pingutaja, mis on kohandatud saha tera nurga muutmiseks. Käesoleva leiutise kohane terahoidja koosneb saha laiuses lühikestest kõrvuti paigutatud moodulitest.','The invention is related to design of plough blade holder of a road maintenance vehicle. The blade holder of the invention comprises a part made of elastically deforming material, which has a air filled space. Parts of the blade holder adjacent to the hollow space viewed from the side form segments of the parallelogram, having upper moving segment, lower moving segment, front moving segment and rear moving segment. Blade holder from elastically deforming material has teeth in the hollow space side, which are adopted to hook with each other on moving over an obstacle on the road. Thanks to this hooking is guaranteed greater returning force into initial position and avoided situation, where the blade holder may stay into opearting position without return. In order to pre-adjust the position of the blade so, that the angle between the blade and the road surface is according to a specific need, the blade holder has a tightener, which is adopted to change the angle of the blade. The blade holder of the present invention consists in width of the plough of short modules placed beside each other.');
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','');
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 ('X553812     ',1),('X553910     ',1),('X553924     ',1),('X553941     ',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 ('X553812','201301','E01H   5/06',1,1,1,1),('X553910','201401','B65F   3/00',1,1,1,1),('X553910','201401','B65F   3/02',1,1,1,2),('X553910','201401','B65F   3/04',1,1,1,3),('X553910','201401','B65F   3/08',1,1,1,4),('X553910','201401','B65F   3/20',1,1,1,5),('X553910','201401','B65F   3/28',1,1,1,6),('X553924','201601','C02F   3/12',1,1,1,1),('X553924','201601','C02F   3/30',2,1,1,2),('X553941','201501','E01H   5/06',1,1,1,1);
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 ('X553812     ',14094,2),('X553910     ',14094,1),('X553924     ',14339,1),('X553924     ',14340,2),('X553924     ',14341,3),('X553941     ',14094,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 (14094,'Raoul','','Renser','Väike-Männiku 7','EE','Tallinn','11216',''),(14339,'Olev','','Sokk','Ehitajate tee 5','EE','Tallinn','19086',''),(14340,'Enn','','Loigu','Ehitajate tee 5','EE','Tallinn','19086',''),(14341,'Karin','','Pachel','Ehitajate tee 5','EE','Tallinn','19086','');
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 ('X553812     ',3316,1),('X553910     ',3316,1),('X553924     ',328,1),('X553941     ',3316,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',''),(3316,2,'','','','Meiren Engineering OÜ','Väike-Männiku 7','EE','Tallinn','11216','');
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;
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 ('X553812     ','EE201200007',201200007,'EE05771','05771',2,'20160615','P201200007  ','20120507','Saha tugiraam','Support frame of a plough',36),('X553910     ','EE201400014',201400014,'EE05769','05769',2,'20160615','P201400014  ','20140517','Prügipakkimisseade','A garbage-packing device',36),('X553924     ','EE201400027',201400027,'EE05770','05770',2,'20160615','P201400027  ','20140709','Meetod reoveest lämmastiku ja fosfori ärastamiseks segregeeritud aktiivmuda koosluste abil kaheastmelises biopuhastis','Method of biological removal of nitrogen and phosphor from waste water using segregated activated sludge compounds in a two-stage biological treatment plant',0),('X553941     ','EE201400039',201400039,'','',1,'20160615','P201400039  ','20141113','Teehooldusmasina saha terahoidja','Blade holder for road maintenance plough',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 */;