-- 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 ('X553955','2017-09-15'),('X554007','2017-09-15'),('X554008','2017-09-15'),('X554009','2017-09-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 ('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.'),('X554007     ','Leiutis puudutab paigaldusklambrit kohandatavatele riiulisüsteemidele, mis tagab, et kohandatava riiuliplaadi kinnitus oleks töökindel ja vastupidav, tekitamata seejuures riiuliplaadile kruviauke või  muid jälgi, ning mis samuti võimaldab riiuliplaate eemaldada ja samas või teises kohas uuesti paigaldada. Paigaldusklamber lukustub automaatselt riiuliplaadi ja seinatala pilu ülemise punkti vahele. Kui klamber jõuab lõppasendisse, jooksevad labad läbi seinatala pilude ning fikseeruvad plõkskinnitusega.','The invention is a mounting clip for adjustable shelf systems, which ensures reliable and durable fixing of adjustable shelf boards without leaving any screw holes or marks on the board, and also provides a possibility to dismount shelf boards by being re-adjustable in the same or different location. The mounting clip automatically locks its position between the shelf board and upper part of the rail opening. When the clip reaches its final position the wings will pass through the opening and create a snap in fixation.'),('X554008     ','Leiutises kirjeldatakse meetodit, mis seisneb stabiilse adapteeritud mikroobikoosluse toimel graptoliitargilliidi metallorgaanilise aine lõhustamises anaeroobses keskkonnas, millega kaasneb metallide  bioleostumine ja metaani eraldumine. Esitatakse leiutist kinnitavad katsetulemused ja näidatakse betaiini toimet kasvukeskkonnas argilliidi metallorgaaniliste ühendite lagundamisel. Iseloomustatakse neid protsesse läbi viivat mikroobikooslust.','The present invention describes a method which consists in decomposition of graptolite argillite organometallic matter in anaerobic environment by a stable adapted microbial consortium, accompanied by bioleaching of metals and methane generation. Supporting experimental data is presented and the effect of betaine in biodegradation of argillite organometallic compounds is demonstrated. Microbial communities provoking these processes are characterized.'),('X554009     ','Leiutise sisuks on välitingimustes kasutatav energiasäästlik linnusöögimaja, mis töötab patareide, aku, päikesepaneeli või võrgu toitel ja sisaldab mahtuvuslikku andurit, mis mahtuvuse muutuse peale registreerib ja loendab lindude külastusi ning teeb nendest pilte ja videoklippe. Pildistamise sagedus on vabalt muudetav internetiserveris või mobiilirakenduses oleva tarkvara vahendusel. Linnusöögimajas on reaalaja kell, temperatuuriandur väliskeskkonna temperatuuri jälgimiseks ning toidukontrolliandur. Linnusöögimaja elektroonikaosad on veekindlas korpuses. Linnusöögimaja on andmevahetuseks ühendatud internetiga juhtmevaba andmeside abil ning kõik linnusöögimajad on globaalselt ühendatud tsentraalse internetiserveriga. Linnusöögimajas oleva kaamera, kontrolleri ning intemetiserveris oleva tarkvara abil toimub linnuliikide tuvastamine. Leiutise elektroonikalülituste ja tarkvara topoloogia sobib kasutamiseks ka teiste elusorganismide automaatseks tuvastamiseks, registreerimiseks ja juhtmevabaks loendamiseks.','The energy-efficient battery, solar panel or mains supply powered bird feeder intended for outdoor conditions incorporates a capacitive sensor, which, upon capacitance change, registers and counts bird visits and takes photos and video clips. The capturing frequency can be changed via software located in the server or mobile application. The bird feeder includes a real-time clock, a temperature sensor for measuring outside temperature and a feed checking sensor. The electronic components of the bird feeder are located in a watertight enclosure. The bird feeder is connected to the Internet using wireless data communication and all feeders are globally connected to the central Internet server. The bird species identification is accomplished using the camera and the controller, located in the bird feeder, and software, located in the internet server. The topology of the electronic circuitry and software is also suitable for identification, registration and counting of other living organisms.');
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 ('X553955     ',1),('X554007     ',1),('X554009     ',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 ('X553955','201501','B07B  13/065',1,1,1,1),('X554007','201701','A47B  96/06',1,1,1,1),('X554007','201701','A47B  96/07',1,1,1,2),('X554007','201701','A47B  57/42',1,1,1,3),('X554008','201701','C22B   3/18',1,1,1,1),('X554008','201701','E21B  43/22',2,1,1,2),('X554008','201701','C12P   5/02',2,1,1,3),('X554009','201601','A01K  31/00',1,1,1,1),('X554009','201601','H04N   7/18',2,1,1,2),('X554009','201601','A01K  39/04',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 ('X553955     ',13526,2),('X553955     ',13797,1),('X553955     ',14121,3),('X554007     ',14486,1),('X554008     ',14487,1),('X554008     ',14488,3),('X554008     ',14489,2),('X554008     ',14491,4),('X554008     ',14492,5),('X554009     ',14493,1),('X554009     ',14494,2),('X554009     ',14495,3),('X554009     ',14496,4),('X554009     ',14497,5);
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',''),(14121,'Jüri','','Olt','Keskasula 21, Kuremaa','EE','Jõgeva maakond','48445',''),(14486,'Hans','','Erlandsson','Tundalsvagen 6','SE','Sollentuna','192 48',''),(14487,'Anne','','Menert','Vaksali 3-24','EE','Tartu','50410',''),(14488,'Maia','','Kivisaar','Mõisavahe 42-47','EE','Tartu','50708',''),(14489,'Sirli','','Sipp Kulli','Hämariku tee 15, Tabasalu','EE','Harju maakond','76901',''),(14491,'Ain','','Heinaru','Riia 5-8','EE','Tartu','51010',''),(14492,'Tiit','','Maidre','Linnamäe tee 5-18','EE','Tallinn','13912',''),(14493,'Heigo','','Mõlder','Liivalaia 11/2-16','EE','Tallinn','10118',''),(14494,'Tanel','','Kerstna','Tööstuse 47A-39','EE','Tallinn','10416',''),(14495,'Ago','','Mõlder','Kuldnoka 5-9','EE','Tallinn','10619',''),(14496,'Marek','','Jarkovoi','Pärnu mnt 110-9','EE','Tallinn','11313','Harjumaa'),(14497,'Riina','','Libe','Liivalaia 11/2-16','EE','Tallinn','10118','');
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 ('X553955     ',3387,1),('X554007     ',3603,1),('X554008     ',3653,1),('X554009     ',3606,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 (3387,2,'','','','Eesti Maaülikool','Fr. R. Kreutzwaldi 1a','EE','Tartu','51014',''),(3603,1,'Hans','','Erlandsson','','Tundalsvagen 6','SE','Sollentuna','192 48',''),(3606,2,'','','','Smart Nature OÜ','Liivalaia 11/2-16','EE','Tallinn','10118',''),(3653,2,'','','','BiotaTec OÜ','Mäealuse 4','EE','Tallinn','12618','');
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 ('X553955     ','EE201400049',201400049,'EE05798','05798',2,'20170915','P201400049  ','20141230','Rihmsorteer','Belt sorter',0),('X554007     ','EE201600002',201600002,'','',1,'20170915','P201600002  ','20160211','Paigaldusklamber kohandatavatele riiulisüsteemidele','Mounting clip for adjustable shelf systems',36),('X554008     ','EE201600003',201600003,'','',1,'20170915','P201600003  ','20160216','Meetod graptoliitargilliidi metallorgaanilise aine lõhustamiseks mikroobikoosluse abil','Method for decomposition of the metallorganic matter of graptolite-argillite by microbial consortium',0),('X554009     ','EE201600004',201600004,'','',1,'20170915','P201600004  ','20160218','Lindude automaatne tuvastamise, registreerimise ja loendamise meetod ning vastav linnusöögimaja','Automatic bird identification, registration and counting method and corresponding bird feeder',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 */;

