-- 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 ('X2590','2019-03-15'),('X2689','2019-03-15'),('X2697','2019-03-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 ('X2590 ','Mehaaniline turbakogumisagregaat, mis on ühendatud puksiirvahendiga, ja turbakogumisagregaat sisaldab raamile paigutatud punkrit, millel on kallutav punkripõhi. Turbakogumisagregaadi raam on paigutatud kahele teineteisest sõltumatule kummilindist roomikule. Turbakogumisagregaadi kallutatava põhjaga punkri avaneval punkriseinal on kumer kuju, mis jäljendab kallutatava punkripõhja liikumistrajektoori, kusjuures punker on agregaadi liikumissuunaga ühtiva telje suhtes sümmeetriline, st et mõlemale roomikule langeb samasugune koormus.','Mechanical collecting assembly for peat which is connected with a towing gear and the collecting assembly comprises a hopper (bunker) placed on the frame, the hopper has a tilting bottom. The opening side wall of the hopper with tilting bottom has convex pattern which imitates trajectory of the tilting bottom of the hopper wherein the hopper is symmetrical to the axis which is coincident to the direction of the movement of the assembly, i.e similar load falls to both caterpillars.'),('X2689 ','Leiutise sisuks on erikujuline padi, millel on nõgus kaelatoetusala 1 pikemal küljel ja nõgus vahe 3 mõlemal lühemal küljel. Nõgus kaelatoetusala 1 asub ühe pikema külje keskel ja teine pikem külg 2 kulgeb sirgelt. Nõgusa kaelatoetusalaga 1 pikem külg on sirgest pikemast küljest 2 pikem 1,1 kuni 1,2 korda. Nõgus vahe 3 mõlemal lühemal küljel lõpeb aga sirge osaga 4.','The special shape pillow has a neck support part (1) along the longer side and two gaps (3) on both shorter sides. The concravity to support the neck (1) is placed in the centre of the longer side, the other longer side (2) runs straight. The side with the concravity (1) is 1,1 to 1,2 times longer than the other longer side (2). The sides with the gap (3) end with a straight part 4.'),('X2697 ','Elektrimasina tehnilise seisundi jälgimise meetodi kohaselt salvestatakse elektrimasina akustiline signaal mobiiltelefoniga alati samal kaugusel elektrimasinast. Salvestatud elektrimasina helisignaal edastatakse serverisse. Serveris salvestatud helisignaal töödeldakse elektrimasina rikkekoha ja rikke põhjuse väljaselgitamiseks töötlemiskeskuses digitaalselt ja digitaalse signaalitöötluse tulemused saadetakse tagasi elektrimasina käitajale.','According to the condition monitoring method of the electrical machine, the acoustic signal of the electrical machine is recorded with a mobile phone always at the same distance from the electrical machine. The recorded sound signal is then forwarded to the server. The recorded sound signal is digitally processed in the server in order to localize the fault and the position of the fault in the electrical machine, after which the digitally processed data of the signal is sent back to the operator of the electrical machine.'); 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 (22,'Rosman ja Partnerid OÜ','Tarmo','Rosman','pk 652','Tallinn','12602',''),(41,'Patendi- & Kaubamärgibüroo Koitel OÜ','Raivo','Koitel','Tina 26','Tallinn','10126','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 ('X2590 ',1),('X2689 ',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 ('X2590','201601','E21C 49/00',1,1,1,1),('X2689','201901','A47G 9/10',1,1,1,1),('X2697','200601','G01H 17/00',1,1,1,1),('X2697','200601','G06F 17/00',1,1,1,2),('X2697','201801','H04M 1/24',1,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 ('X2590 ',2429,1),('X2590 ',2430,2),('X2590 ',2431,3),('X2689 ',2557,1),('X2697 ',2566,1),('X2697 ',2567,2),('X2697 ',2568,3),('X2697 ',2569,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 (2429,'Janar','','Jõgi','Raba tee 8, Soodevahe küla, Rae vald','EE','Harju maakond','75322',''),(2430,'Toomas','','Kuusk','Raiesmiku 4','EE','Saue','76506',''),(2431,'Marek','','Sisask','Muuseumi tee 2, Lagedi alevik, Rae vald','EE','Harju maakond','75303',''),(2557,'Kristel','','Rauk','Häilu 4','EE','Tallinn','12617',''),(2566,'Toomas','','Vaimann','Ehitajate tee 5','EE','Tallinn','19086',''),(2567,'Jan','','Sobra','Ke Smoliku 280','CZ','Jistebnice','39133',''),(2568,'Anouar','','Belahcen','Ehitajate tee 5','EE','Tallinn','19086',''),(2569,'Ants','','Kallaste','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 ('X2590 ',1830,1),('X2689 ',1941,1),('X2697 ',266,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 (266,2,'','','','Tallinna Tehnikaülikool','Ehitajate tee 5','EE','Tallinn','19086',''),(1830,2,'','','','AS Ahtol','Raba tee 5, Soodevahe küla, Rae vald','EE','Harju maakond','75322',''),(1941,2,'','','','Ravanelle OÜ','Häilu 4','EE','Tallinn','12617',''); 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 ('X2590 ','EE201600028',201600028,'EE01459','01459',1,'20190315','U201600028 ','20160614','Mehaaniline turbakogumisagregaat','Mechanical collecting assembly for peat',41),('X2689 ','EE201800002',201800002,'EE01458','01458',1,'20190315','U201800002 ','20180129','Erikujuline padi','Special shape pillow',22),('X2697 ','EE201800009',201800009,'EE01460','01460',1,'20190315','U201800009 ','20180425','Elektrimasina tehnilise seisundi jälgimise meetod','Method for monitoring of the technical condition of the electrical machine',0); UNLOCK TABLES; /*!40000 ALTER TABLE `yptappli` ENABLE KEYS */; -- -- Dumping routines for database 'patent_esp' -- DELIMITER ;; DELIMITER ;