-- 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 ('X553913','2016-08-15'),('X553954','2016-08-15'),('X553955','2016-08-15'),('X553956','2016-08-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 ('X553913 ','Leiutis käsitleb tõsteseadet küljeltlaaditava prügiveoki jaoks. Seade sisaldab prügiveoki külgsuunas liigutatavat poomi, mille otsas on prügikonteineri haarats. Tõsteseade võimaldab prügikonteinereid haarata ja tõsta üsna prügiveoki külje lähedalt, mistõttu on prügiveoki töötamiseks vaja vähem tõsteruumi tänaval. Käesoleva leiutise liigutatav poom on prügikonteineri haaramiseks ühendatud horisontaalse lineaarliikumise mehhanismiga, mis võimaldab haarata prügiveokist eemal paiknevat konteinerit. Leiutise tõsteseadmega saab prügikonteinereid käsitseda mõlemalt poolt prügiveokit.','Invention covers lifting device for a side loading waste vehicle, comprising a beam movable sideways of the waste vehicle, having a grip for dustbin at the end of the beam. Lifting device enables grabbing and lifting the dustbins rather close to the waste vehicle. Therefore there is need for less lifting space in the street for operating the waste vehicle. The movable beam of the present invention, in order to grab a container, is connected with a mechanism of horisontal linear movement, which enables grabbing of the container locating remote of the waste vehicle. Lifting device of the invention can handle dustbins from both sides of the waste vehicle.'),('X553954 ','Sisemise valgusallikaga topeltseinaga silindriline pöörlev fotobioreaktor, mis sisaldab kinnist anumat, mis kujutab endast kahte rõhtsat, ühel pöörlemisteljel paiknevat pöörlevat topeltseinaga silindrit, mille välimiste ja sisemiste seintega ning otstega ning pöörlevaid topeltseinaga silindreid ühendava, mittepöörleva fikseeritud osaga moodustub piiratud kinnine ruum, mis on täidetud vetikakultuuri sisaldava lahusega. Fotobioreaktori pöörlevate topeltseinaga silindrite keskele on paigutatud sisemine valgusallikas, mille poolt tekitatud üleliigse soojus ärapuhumiseks ventilaatorit, valgusallika sisse ja välja lülitamiseks on lülitusseadis. Mittepöörleva fikseeritud osa ülaosa külge on jäigalt kinnitatud filtriga ja klapiga varustatud jääkgaaside väljaviigud ning toitelahuse sisseviigud ning allosas biomassi väljaviigud ning süsihappegaasi (CO2) ja õhu sisseviigud. Pöörlevate topeltseintega silindrite lahtised otsad on varustatud mitmeastmeliste tihenditega, mis on viidud kontakti mittepöörleva fikseeritud osa liugepindadega ning kinnised otsad on varustatud otspingutitega pöörlevate topeltseintega silindrite telgnihkumise tõkestamiseks.','The invention belongs to the field of microbiology instrumentation, more specifically instrumentation for mass cultivating photoactive microorganisms. Double walled cylindrical rotating photobioreactor with inner light source, that includes closed vessel, which is formed by two horizontal double walled cylinders on the common rotational axes with a potential to rotate, outer and inner walls, endplates, and the fixed section that joins both rotating double walled cylinders and is filled with microalgal solution. In the middle of the double walled cylinders inner light source is placed. The excess heat produced by the light source is dissipated using ventilator. Turning the light source on and off the switching mechanism is used. To the upper part of the fixed section the outtake of residual gases and input of nutrient solution with filters and valves are fixed. To the lower part of the fixed section the outtake of excess biomass and input of carbon dioxide (CO2) and/or air with filters and valves are fixed. The open ends of rotating double walled cylinders are furnished with seals that make contact with the sliding surfaces of the fixed section. The closed ends are furnished with rolling-braces that prevent axial displacement.'),('X553955 ','Marjade rihmsorteer, mida kasutatakse marjade sorteerimiseks suuruse järgi, sisaldab reguleeritavat rihmatrumlit, mis on ette nähtud rihmade vahekauguse sujuvaks muutmiseks ning mis sisaldab rihmasid kandvaid rihmarattaid, rihmarataste sees paiknevat juhtvõlli ning selle ümber paiknevat torukujulist lõhikuga varustatud hülssi, rihmarattaid ja juhtvõlli ühendavaid juhtvardaid, gofreeritud katet, jaotusketast, käepidet ja fiksaatorit. Reguleeritava rihmatrumli juhtvõll sisaldab muhvi ja muhvi südamikku, mis on omavahel ühendatud keerme abil. Juhtvõlli ümber paiknev torukujuline hülss on varustatud vähemalt kolme lõhikuga. Kuuekandilise ristlõikega reguleervõll, mis on paigutatud muhvi südamike sisse, on ühendatud käepidemega ja muhvide südamikega, et pöörata muhvide südamikke ümber oma telje ning nihutada rihmarataste juhtvõlli ümber paikneva torukujulise hülsi suhtes.','Belt sorter for sorting berries according to their size that has an adjustable roller to smoothly change distance between belts contains belt pulleys to carry belts, a guide shaft located inside of belt pulleys, a tubular sleeve with a slit located around the guide shaft, guide pins that connect belt pulleys to the guide shaft, a corrugated cover, an adjusting disc, a handle and a fixator. Adjustable roller guide shaft includes sleeves and sleeve cores which are connected to each other by threads. Tubular sleeve that is located around guide shaft has at least three slits. A hexagonal-shape guide shaft located inside the sleeve cores is connected by a handle and sleeve cores to turn sleeve cores around their axis and to move belt pulleys on tubular sleeve that is located around the guide shaft.'),('X553956 ','Leiutis kuulub mittefossiilse päritoluga kütuste tootmise tehnoloogiate valdkonda, täpsemalt etanooli tootmise meetodite hulka ning on kasutatav etanooli tootmiseks lignotselluloossest biomassist. Leiutise sisuks on lämmastiklõhkamismeetod biomassi rakustruktuuri lõhkumiseks, mille kohaselt kuiv peenestatud biomass segatakse veega kreemitaolise konsistentsi saavutamiseni, kusjuures biomassi ja vee massisuhe on 1:5 kuni 1:15, rõhk tõstetakse lämmastiku (N2) lisamise teel rõhuni 10 kuni 30 baari, temperatuur reaktori sees tõstetakse väljastpoolt kuumutamise teel temperatuurini 125 kuni 175 kraadi Celsiuse järgi ja hoitakse seal inkubatsiooni aja jooksul 10 kuni 120 minutit, seejärel lastakse biomass jahtuda lõpptemperatuurini 125 kuni 175 kraadi Celsiuse järgi, kusjuures biomassi kuumutamise, temperatuuri hoidmise ja jahutamise aeg survereaktoris on kokku 1 kuni 4 tundi, ning peale lõpptemperatuurini viimist alandatakse survereaktoris rõhk kiiresti atmosfäärirõhuni ja eeltöödeldud biomass suunatakse survereaktorist edasisele töötlusele.','The invention belongs to the field of production technologies of non-fossil biofuels, more specifically production methods of bioethanol, and it is applicable in biofuel production process from lignocellulosic biomass. In nitrogen explosion method for disrupting cell structure, dry milled biomass is mixed with water to achieve creamy consistency (the biomass to water ratio from 1:5 to 1:15), pressure is increased using nitrogen gas (N2) to a range of 10 to 60 bars, temperature in the pressure vessel is raised to the range of 125 to 190 degrees Celsius and is kept thus for the incubation period of 10 to 120 minutes. The mixture is then cooled to the temperature range of 25 to 90 degrees Celsius, while the total time of biomass heating, incubation and cooling is in the range of 1 to 4 hours. After reaching the final temperature, the pressure is suddenly released to achieve explosive decompression and the pretreated biomass is used in further processing.'); 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 ('X553913 ',1),('X553954 ',1),('X553955 ',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 ('X553913','201501','B65F 3/00',1,1,1,1),('X553913','201501','B65F 3/04',1,1,1,2),('X553954','201601','C12M 1/00',1,1,1,1),('X553954','201601','A01G 33/00',2,1,1,2),('X553955','201501','B07B 13/065',1,1,1,1),('X553956','201601','C08L 97/02',1,1,1,1),('X553956','201601','D21B 1/36',2,1,1,2),('X553956','201601','C12P 7/06',2,1,1,3); 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 ('X553913 ',14094,2),('X553954 ',14121,3),('X553954 ',14199,1),('X553954 ',14394,2),('X553955 ',13526,2),('X553955 ',13797,1),('X553955 ',14121,3),('X553956 ',14121,4),('X553956 ',14199,1),('X553956 ',14395,2),('X553956 ',14396,3); 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 (13526,'Margus','','Arak','Akvarelli 10','EE','Tartu','51011',''),(13797,'Kaarel','','Soots','Võruvälja 16-5','EE','Tartu','50112',''),(14094,'Raoul','','Renser','Väike-Männiku 7','EE','Tallinn','11216',''),(14121,'Jüri','','Olt','Keskasula 21, Kuremaa','EE','Jõgeva maakond','48445',''),(14199,'Timo','','Kikas','Hommiku 6','EE','Tartu','50412',''),(14394,'Lara','','Podkuiko','Roosi 48-6','EE','Tartu','51009',''),(14395,'Merlin','','Raud','Väike-Tähe 10-1','EE','Tartu','51010',''),(14396,'Marti','','Tutt','Pearna-Hansu, Kasvandu küla, Kaiu vald','EE','Rapla maakond','79321',''); 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 ('X553913 ',3316,1),('X553954 ',3387,1),('X553955 ',3387,1),('X553956 ',3387,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 (3316,2,'','','','Meiren Engineering OÜ','Väike-Männiku 7','EE','Tallinn','11216',''),(3387,2,'','','','Eesti Maaülikool','Fr. R. Kreutzwaldi 1a','EE','Tartu','51014',''); 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 ('X553913 ','EE201400017',201400017,'EE05776','05776',2,'20160815','P201400017 ','20140531','Tõsteseade küljeltlaaditava prügiveoki jaoks','Lifting device for a side loading waste vehicle',36),('X553954 ','EE201400048',201400048,'','',1,'20160815','P201400048 ','20141230','Sisemise valgusallikaga topeltseinaga silindriline pöörlev fotobioreaktor','Double walled cylindrical rotating photobioreactor with inner light source',0),('X553955 ','EE201400049',201400049,'','',1,'20160815','P201400049 ','20141230','Rihmsorteer','Belt sorter',0),('X553956 ','EE201400050',201400050,'','',1,'20160815','P201400050 ','20141230','Lämmastiklõhkamismeetod biomassi rakustruktuuri lõhkumiseks','Nitrogen explosion pretreatment method for disruption of cellular structure of biomass',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 */;