-- 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 ('X2597','2019-06-17'),('X2673','2019-06-17'),('X2685','2019-06-17');
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 ('X2597       ','Leiutisega esitatakse hoone renniga ventilatsioonirest, kusjuures rennil on väljaulatuv nõgusaks painutatud osa ja ääris, mis juhivad vedeliku ja mustuse hoone välisseinast eemale.','The present invention discloses a vent grate with a gutter of a building wherein the gutter has a protruding part bented into a concave shape and a flange to drain liquid and dirt away from the external wall of the building.'),('X2673       ','Esitatud mahutite puhastamise süsteem töötab suletud ahela põhimõttel, mis võimaldab sõltumatut (autonoomset) mahuti puhastusprotsessi ilma väliste energiaallikate (vesi, elekter, aur, ja teised) ühendusteta mis tahes kohas ja ajal. Mahutite puhastamise süsteem sisaldab mahutipuhastusseadet 1 ja kütusemahutit 2 puhastatavas mahutis 10 oleva aine ajutiseks paigutamiseks puhastusprotsessi ajaks. Mahutipuhastusseade 1 sisaldab eraldi töötlusanumat 9, kusjuures töötlusanumasse on paigutatud pumbad 16 ja 17, veesoojendi 14, skimmer 13, hüdrotsüklon 12, ja töötlusanum on varustatud anduritega. Mahutipuhastusseade sisaldab veel gaasiärastusventilaatorit 8, pöörlevat pihustusotsakut 11, mis on paigutatud puhastatavasse mahutisse 10. Mahutite puhastamise süsteem töötab eraldi automaatses töörežiimis, käsitsitöörežiimis ja töötlusanuma 9 puhastamise režiimis.','The present system for cleaning tanks is based on the principle of closed loop which allows to perform independent (autonomous) cleaning process without any connections to energy-resources (water, electricity, steam and other) at any site and at any time. The system for cleaning tanks comprises a device for cleaning the tank 1 and fuel tank 2 used for the temporary storage of substance from the tank 10 that is cleaned. The device for cleaning the tank 1 comprises the separate process vessel 9 wherein in the process vessel pumps 16 and 17, heater for water 14, skimmer 13, hydrocyclone 12 are placed, and the processing vessel is provided with sensors. The device for cleaning the tank further comprises degassing fan 8, rotary jet nozzle 11 which is placed in the tank 10 that is cleaned. The system for cleaning tanks works separately in automatic mode, in manual mode and self-cleaning mode for the vessel processed.'),('X2685       ','Leiutis käsitleb nurkhoobvibu, mis sisaldab kahe otsaga raami, kahte hooba, kahte vedruseadet, vibunööri, hoobade alumist reguleerimissõlme ja hoobade ülemist reguleerimissõlme, kusjuures hoovad on varustatud reguleerimissektoriga ja hoovad on pöörduvalt kinnitatud raami vastasotste külge. Uudne on see, et hoovad on kinnitatud raami vastasotste külge õõtshoova kaudu, kusjuures õõtshoova all paikneb raami külge kinnitatud tugi, reguleerimissektor on vedrut omava vedruseadmega ühendatud ülekandeplaadi vahendusel, vedruseade on varustatud reguleerimiskruvi omava reguleerimisklotsiga ja õõtshooval on käigupiiramiskruvi. Ülekandeplaadi mõlemas otsas on nugalaager, reguleerimissektoril ja vedrul on vastavad nugalaagripesad, kusjuures õõtshoova ja toe vahele on paigutatud vähemalt üks puhver.','The present invention related to a lever action archery bow that comprises a frame with two ends, two levers, two spring devices, a bowstring, a lower adjustment unit for levers and an upper adjustment unit for levers, whereas the levers have been provided with adjustment sectors and are attached on a swivel to the opposite ends of the frame. The novelty lies in the levers being attached to the opposite ends of the frame using an equalizer bar whereas under the equalizer bar a support has been fixed to the frame, the adjusting sector has been attached to the spring device that has a spring by means of a transfer plate, the spring device has been provided with an adjustment block that has an adjustment screw and the equalizer bar has a movement limiting screw. At both ends of the transmission plate there are knife bearings and the adjustment sector and the spring have corresponding knife bearing sockets and, whereas at least one buffer has been positioned between the equalizer bar.');
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 (31,'Patendi- ja Kaubamärgibüroo Koitel OÜ','Juta-Maris','Uustalu','Tina 26','Tallinn','10126','EE'),(37,'Patendibüroo Turvaja OÜ','Riho','Pikkor','Liivalaia 22','Tallinn','10118','EE'),(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 ('X2597       ',1),('X2685       ',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 ('X2597','201901','F24F  13/08',1,1,1,1),('X2597','201901','F24F  13/22',2,1,1,2),('X2673','201801','B08B   9/08',1,1,1,1),('X2673','201801','B08B   9/00',1,1,1,2),('X2685','201801','F41B   5/10',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 ('X2597       ',2447,1),('X2673       ',2534,1),('X2673       ',2535,2),('X2673       ',2536,3),('X2673       ',2537,4),('X2685       ',2553,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 (2447,'Margo','','Kivi','Talve 86b','EE','Kuressaare','93816',''),(2534,'Nikolai','','Šošin','Aiandi tee 21, Viimsi alevik, Viimsi vald','EE','Harju maakond','74001',''),(2535,'Vadym','','Ratkin','Aiandi tee 21, Viimsi alevik, Viimsi vald','EE','Harju maakond','74001',''),(2536,'Aleksandr','','Vinogradov','Aiandi tee 21, Viimsi alevik, Viimsi vald','EE','Harju maakond','74001',''),(2537,'Petr','','Sirotin','Aiandi tee 21, Viimsi alevik, Viimsi vald','EE','Harju maakond','74001',''),(2553,'Rein','','Kink','Puhangu 4a-68','EE','Tallinn','10311','');
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 ('X2597       ',1838,1),('X2673       ',1924,1),('X2685       ',1938,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 (1838,2,'','','','Stonetek OÜ','Talve 86b','EE','Kuressaare','93816',''),(1924,2,'','','','Dontal OÜ','Kivila 34-135','EE','Tallinn','13918',''),(1938,1,'Rein','','Kink','','Puhangu 4a-68','EE','Tallinn','10311','');
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 ('X2597       ','EE201600035',201600035,'EE01464','01464',1,'20190617','U201600035  ','20160722','Hoone renniga ventilatsioonirest','Vent grate with a gutter of a building',41),('X2673       ','EE201700043',201700043,'EE01463','01463',1,'20190617','U201700043  ','20171018','Mahutite puhastamise süsteem','System for cleaning tanks',31),('X2685       ','EE201700053',201700053,'EE01465','01465',1,'20190617','U201700053  ','20171229','Nurkhoobvibu','Lever action archery bow',37);
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 */;

