-- 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 ('X2494','2017-11-15'),('X2584','2017-11-15'),('X2601','2017-11-15'),('X2610','2017-11-15'),('X2613','2017-11-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 ('X2494       ','Käesoleva leiutise kohane teisaldatav puulõhkumismasin sisaldab põhiraami (2), mis on valmistatud kahest U-talast (3), mille põhjad on omavahel ühendatud kinnituselementidega, kusjuures U-talade põhjade vahele on paigutatud distantselemendid, mis võimaldavad U-talade vahele kinnitada puulõhkumistera (5).  Lisaks sisaldab puulõhkumismasin põhiraamile kinnitatud hüdrosilindrit (6) koos hüdrosilindri juhtimisplokiga (7) ja tugiplaadiga (8), kogumisplaati (10) ning puulõhkumismasina transportimiseks vajalikke jalaseid või rattaid ning järelhaagise haakekonksu.','A transportable wood-splitting machine according to present invention comprises of a main frame (2) which is made of two U-beams (3), wherein the bases are interconnected by fastening elements. Between the bases of U-beams distance elements are placed, allowing to secure the cutting blade (5) between the U-beams. In addition, the wood-splitting machine comprises of a hydraulic cylinder (6) attached to the main frame together with a hydraulic cylinder control unit (7) and a support plate (8), the collecting plate (10) and the runners or wheels needed for transportation of the wood-splitting machine, and the trailer coupling hook.'),('X2584       ','Käesolev leiutis käsitleb turbiini voolava keskkonna voolu (1) kineetilise energia muundamiseks turbiini rootori (2) pöörlemiseks. Turbiini korpus sisaldab kahe paralleelse otskatte (8) vahele kinnitatud kolme moodulit (5, 6, 7), mille abil on moodustatud voolava keskkonna voolule (1) kaks sisendkanalit (9, 10) ja üks väljundkanal (11). Keskmine moodul (7) on paigutatud kahe äärmise mooduli (5, 6) vahele, millega on moodustatud turbiini korpusesse kaks sisendkanalit (9, 10) voolava keskkonna voolu (1) juhtimiseks rootorile (2), kus mõlema sisendkanali (9, 10) ristlõige väheneb sujuvalt vastava sisendkanali (9, 10) sisendavast selle väljundava poole. Voolava keskkonna voolu (1) juhtimiseks turbiinist välja on äärmiste moodulite (5, 6) vahele moodustatud üks ühine väljundkanal (11).','Present invention relates to a turbine for converting the kinetic energy of a flow (1) of a fluid medium into a rotation of a rotor (2) of the turbine. The turbine casing comprises between parallel end walls (8) three modules (5, 6, 7) forming into the flow (1) of a fluid medium two inlet channels (9, 10) and one outlet channel (11). The middle module (7) is placed between two outermost modules (5, 6) forming inside the casing of the turbine two inlet channels (9, 10) for directing flow (1) to the rotor (2) and the cross-section of both inlet channels (9, 10) is decreasing from the inlet opening of the channels towards the outlet opening of the channels. For directing flow (1) of a fluid medium out from the turbine, a single common outlet channel (11) is formed between outermost modules (5, 6).'),('X2601       ','Leiutis käsitleb koormaposti (1) lukustussõlme (2), mis sisaldab koormaposti (1) otsa (4) vastuvõtmiseks postipesa (3), et sellesse lukustada pöördumisvõimalusega koormaposti (1) ots (4). Lukustussõlm (2) laseb koormapostil (1) takistusega kokkupuutel postipesas (3) piiratud ulatuses pöörduda selliselt, et lukustus ei avane. Samuti võimaldab lukustusssõlm (2) koormapostil (1) raskusjõu mõjul pöörduda tagasi algasendisse.','Present invention relates to a locking unit (2) for the retaining member (1), where said unit comprises a socket (3) for receiving the end (4) of the retaining member (1) in order to lock said end rotatably into the socket. The locking unit (2) enables the retaining member (1) to rotate in the socket (3) without unlocking said retaining member (1) from said socket (3) when retaining member (1) strikes an obstacle. Also, the said locking unit (2) enables the retaining member (1) to return by the influence of gravity back to its original position.'),('X2610       ','Käesolev leiutis hõlmab integreeritavat päikesepaneeli kivikatusele. Päikesepaneel sisaldab päikesepaneelielementi, mis on paigutatud neljast profiilist (ülemine ja alumine profiil, vasak külgprofiil  ja parem külgprofiil) moodustatud raami. Raami vasaku ja parema külgprofiili tugiplaadi pikemale osale on kinnitatud katusekivi ühendusprofiili järgivad tugipadjandid (5). Integreeritav päikesepaneel  on lihtsalt kinnitatav kivikatuse roovitisele.','The present invention comprises an integrated solar panel to the tiled roof. The integrated solar panel comprises a solar panel element, which is arranged into a frame formed from four profiles (a top and bottom profile, a left side profile and a right side profile). To the longer part of the support plate of the left and right profile of the frame is attached a support pad comprising the profile identical with the roof tile connection profile. The integrated solar panel is easily mountable to the base of the roof tiles.'),('X2613       ','Kuivpuhastatava ekraaniga randmernärkmik sisaldab randmerihma 1, mille mõlemas otsas on takjakangast kinnitusriba 7, läbipaistvat kuivpuhastatavat ekraani 2, valgusallikat 3, lülilit 4, püsimagnetiga  varustatud markerit 6 ja markerihoidikut 5, milleks on terasplaat.','The wrist-mountable notepad with dry-erase screen comprises a wrist band 1, both ends of which have a hook and loop strip 7, a transparent dry-erase screen 2, a source of light 3, a switch 4, a marker 6 which is provided with a permanent magnet, and a marker-holder 5 in the form of a steel plate.');
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 (12,'Patendibüroo Kaitsepurus OÜ','Reet','Maasikamäe','Mulla 4-3','Tallinn','10611','EE'),(38,'Sarap ja Putk Patendibüroo','Margus','Sarap','Kompanii 1C','Tartu','51004','EE'),(46,'LASVET Patendibüroo OÜ','Jürgen','Toome','Suurtüki 4a','Tallinn','10133','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 ('X2494       ',1),('X2584       ',1),('X2601       ',1),('X2610       ',1),('X2613       ',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 ('X2494','201701','B27L   7/00',1,1,1,1),('X2584','201701','F03D   3/04',1,1,1,1),('X2584','201701','F03D   3/06',2,1,1,2),('X2601','201701','B60P   7/12',1,1,1,1),('X2601','201701','B62D  33/02',1,1,1,2),('X2610','201701','H02S  20/23',1,1,1,1),('X2610','201701','F24J   2/52',2,1,1,2),('X2613','201701','B43L   1/12',1,1,1,1),('X2613','201701','A45F   5/02',2,1,1,2),('X2613','201701','B43K  23/00',2,1,1,3),('X2613','201701','B43K  29/00',2,1,1,4),('X2613','201701','F21V  33/00',2,1,1,5);
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 ('X2494       ',2325,1),('X2494       ',2326,2),('X2494       ',2327,3),('X2584       ',2421,1),('X2601       ',2450,1),('X2610       ',2461,1),('X2610       ',2462,2),('X2610       ',2463,3),('X2613       ',2466,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 (2325,'Roland','','Mõtlik','Ringtee 6','EE','Tartu','51013',''),(2326,'Karl','','Englas','Ringtee 6','EE','Tartu','51013',''),(2327,'Martti','','Ehasalu','Ringtee 6','EE','Tartu','51013',''),(2421,'Oleg','','Fefelov','ul. Vorovskogo d. 5 kv. 20','RU','Kingisepp, Leningradskaya oblast, RU 188480','',''),(2450,'Anti','','Puusepp','Laane tee 27, Käsmu küla, Vihula vald','EE','Lääne-Viru maakond','45601',''),(2461,'Mattis','','Jürimäe','Jaani tee 9-2, Räni alevik, Ülenurme vald','EE','Tartu maakond','61708',''),(2462,'Mait','','Kukk','Holstre tee 18, Holstre küla, Viljandi vald','EE','Viljandi maakond','69602',''),(2463,'Silver','','Aednik','Nikolai Lunini 5-2','EE','Tartu','50406',''),(2466,'Reimo','','Indus','Orgita tee 36-18, Märjamaa vald','EE','Rapla maakond','78301','');
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 ('X2494       ',1738,1),('X2584       ',1821,1),('X2601       ',1841,1),('X2610       ',1853,1),('X2613       ',1857,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 (1738,2,'','','','Estre Masinaehitus OÜ','Ringtee 6','EE','Tartu','51013',''),(1821,2,'','','','WTF Engineering OÜ','Tallinna mnt 19C','EE','Narva','20303',''),(1841,2,'','','','OÜ Palmse Mehaanikakoda','Võsupere küla, Vihula vald','EE','Lääne-Viru maakond','45202',''),(1853,2,'','','','Solarstone OÜ','Tartu 16-8','EE','Viljandi','71004',''),(1857,1,'Reimo','','Indus','','Orgita tee 36-18, Märjamaa vald','EE','Rapla maakond','78301','');
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 ('X2494       ','EE201500025',201500025,'EE01412','01412',1,'20171115','U201500025  ','20150409','Teisaldatav puulõhkumismasin','A transportable wood-splitting machine',38),('X2584       ','EE201600022',201600022,'EE01415','01415',1,'20171115','U201600022  ','20160527','Turbiin voolava keskkonna voolu kineetilise energia muundamiseks turbiini rootori pöörlemiseks','A turbine for converting the kinetic energy of a flow of a fluid medium into a rotation of a rotor of the turbine',46),('X2601       ','EE201600039',201600039,'EE01414','01414',1,'20171115','U201600039  ','20160817','Koormaposti lukustussõlm','A locking unit for the retaining member',46),('X2610       ','EE201600048',201600048,'EE01416','01416',1,'20171115','U201600048  ','20161108','Integreeritav päikesepaneel kivikatusele','An integrated solar panel to the tiled roof',38),('X2613       ','EE201600051',201600051,'EE01413','01413',1,'20171115','U201600051  ','20161117','Kuivpuhastatava ekraaniga randmemärkmik','The wrist-mountable notepad with dry erase screen',12);
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 */;