-- 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 ('X553938','2017-10-16'),('X554010','2017-10-16'),('X554056','2017-10-16');
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 ('X553938     ','Leiutis käsitleb Lactobacillus plantarum Inducia DSM 21379 kasutamist hüpokolestereemilise, antimikroobse ja antioksüdatiivse agendina. Nimetatud tüve sisaldavatel toiduainetel ja toidulisanditel on südant kaitsev toime. Mikroorganismi L. plantarum Inducia kasutatakse kolesterooli metabolismi häirete ja südameveresoonkonnahaiguste ennetamiseks, kuna ta vähendab LDL-kolesterooli taset ja samaaegselt tõstab organismi antioksüdatiivset aktiivsust, mõjutades oksüdatiivse stressi markereid soovitud suunas - oksüdeeritud madala tihedusega lipoproteiinide (ox-LDL) tase ja oksüdatiivse stressi indeks  (OSI) vähenevad.','The invention relates to a microorganism strain Lactobacillus plantarum Inducia DSM 21379 for use as hypocholesterolemic and anti-oxidative agent. The food products and compositions comprising said strain have a cardio-protective effect. L. plantarum Inducia is used in preventing cholesterol metabolism disorders and cardiovascular disorders by reducing the level of LDL-cholesterol, and simultaneously as an anti-oxidative agent for use in enhancing anti-oxidative activity of human body by reducing the levels of oxidative stress markers - oxidized low density lipoprotein (ox-LDL) and oxidative stress index (OSI).'),('X554010     ','Leiutise sisuks on fotoelektriline ehituspaneel, mis on moodustatud lehtmetaliist valmistatud paanist ja sellesse pressitud süvendisse või kõrgendusse lisatud fotoelektrilisest elemendist selliselt, et paani ja sellese lisatud päikesepaneeli pealmine pind on ühetasased. Selliselt on tagatud ehituspaneeli fotoelektrilise elemendi kaitstus väliskeskkonna kahjustavate mõjude eest ning välditud mehaanilised pinged, praod, korrosioon ja konstruktsioonikahjustused ning seeläbi tagatud suurem efektiivsus ning pikem eluiga.','The present invention relates to a photovoltaic building panel comprising metallic sheet material including socket for photovoltaic module, wherein the surface of the photovoltaic module is attached into the socket and the surface of the sheet material is plane. This sheet metal forming provides better protection of the integrated photovoltaic modules and the corresponding adhesive connections from the destructive environmental influences, mechanical stresses, cracks, corrosion and structural damage is avoided and thus a higher efficiency and a longer lifespan is guaranteed.'),('X554056     ','Kompositsioon tulekahjude leviku piiramiseks ja orgaanilise materjali tulekindluse suurendamiseks immutamise teel ning meetod selle kasutamiseks tuletõkkevahendina, kusjuures kompositsioon on saadud järgmiste lähteainete kokkusegamisel: kaaliumkarbonaat, sidrunhape, karbamiid ja vesi. Kompositsiooni võib täiendavalt lisada etanooli, metanooli, raudfosfaati ning boorhapet.','Composition for fire fighting and for improving organic material fire resistance by impregnation and method for using it as fire barrier tool, wherein the composition is made by mixing the following starting materials: potassium carbonate, citric acid, carbamide and water. Ethanol, methanol, iron phosphate and boric acid may be further to the composition.');
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 (4,'Patendibüroo Ustervall OÜ','Sirje','Kahu','Kivi 21-6','Tartu','51009','EE'),(35,'KOPPEL patendibüroo OÜ','Mart Enn','Koppel','Oja tee 22-2, Tiskre, Harku vald','Harju maakond','76916','EE'),(48,'Sarap ja Putk Patendibüroo','Mikk','Putk','Kiriku 6','Tallinn','10130','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 ('X554010     ',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 ('X553938','201501','A61K  35/747',1,1,1,1),('X553938','201701','A23L  33/135',2,1,1,2),('X553938','201701','A61P   9/00',2,1,1,3),('X554010','201601','E04D  13/18',1,1,1,1),('X554010','201601','H02S  20/23',2,1,1,2),('X554010','201701','E04D   3/40',2,1,1,3),('X554010','201601','F24J   2/00',2,1,1,4),('X554010','201701','E04D   3/38',2,1,1,5),('X554056','201701','A62D   1/00',1,1,1,1),('X554056','201701','C09K  21/06',2,1,1,2),('X554056','201701','A62C   3/02',2,1,1,3),('X554056','201701','B27K   3/16',2,1,1,4),('X554056','201701','B27K   3/26',2,1,1,5),('X554056','201701','B27K   3/34',2,1,1,6);
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 ('X553938     ',13294,1),('X553938     ',13295,3),('X553938     ',13300,16),('X553938     ',13305,7),('X553938     ',13667,2),('X553938     ',14239,15),('X553938     ',14369,10),('X553938     ',14370,11),('X553938     ',14372,17),('X553938     ',14373,5),('X553938     ',14374,9),('X553938     ',14375,13),('X554010     ',14498,1),('X554056     ',14574,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 (13294,'Marika','','Mikelsaar','Jakobsoni 11-4','EE','Tartu','51005',''),(13295,'Merle','','Rätsep','Alasi 31-49','EE','Tartu','50109',''),(13300,'Siiri','','Kõljalg','Elva 6','EE','Tartu','50404',''),(13305,'Imbi','','Smidt','Voika küla, Nõo vald','EE','Tartu maakond','61622',''),(13667,'Epp','','Songisepp','Tähe 105-7','EE','Tartu','50107',''),(14239,'Jelena','','Stsepetova','Muru 12-28','EE','Tartu','50303',''),(14369,'Epp','','Sepp','Kaarli pst 11-47','EE','Tallinn','10119',''),(14370,'Raik-Hiio','','Mikelsaar','Jakobsoni 11-4','EE','Tartu','51005',''),(14372,'Mirjam','','Vallas','Ravila 76-34','EE','Tartu','50408',''),(14373,'Pirje','','Hütt','Kulli 10-2','EE','Tartu','50416',''),(14374,'Kai','','Truusalu','Vanemuise 45-59','EE','Tartu','51003',''),(14375,'Kalle','','Kilk','Suur kaar 21-3','EE','Tartu','50404',''),(14498,'Andri','','Jagomägi','Spordi 16-44','EE','Tallinn','11315',''),(14574,'Aleksander','','Paukson','Piiri 6-12','EE','Keila','76610','');
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 ('X553938     ',3668,1),('X554010     ',3607,1),('X554056     ',3650,1),('X554056     ',3651,2);
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 (3607,2,'','','','Roofit Solar Energy OÜ','Spordi 16-44','EE','Tallinn','11315',''),(3650,1,'Anita','','Paukson','','Põhja 17-1','EE','Keila','76610',''),(3651,1,'Tarvi','','Uusen','','Kalda tee 34-33','EE','Tartu','50707',''),(3668,2,'','','','BioCC OÜ','Kreutzwaldi 1','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;
INSERT INTO `ypriority` VALUES ('X553938','US','244284','20140403',1),('X554056','EE','P201600006','20160321',1);
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 ('X553938     ','EE201400038',201400038,'EE05799','05799',2,'20171016','P201400038  ','20141031','Hüpokolestereemilist probiootilist mikroorganismi tüve Lactobacillus plantarum Inducia DSM 21379 sisaldav kompositsioon kasutamiseks südame-veresoonkonnahaiguste ennetamiseks','Composition comprising hypocholesterolemic probiotic microorganism strain Lactobacillus plantarum Inducia DSM 21379 for use in preventing cardiovascular disorders',4),('X554010     ','EE201600005',201600005,'','',1,'20171016','P201600005  ','20160314','Fotoelektriline ehituspaneel','Photovoltaic building panel',48),('X554056     ','EE201700016',201700016,'','',1,'20171016','P201700016  ','20170321','Tuldtõrjuv ja -tõkestav kompositsioon, selle valmistamise meetod ja kasutamine tulekahjude leviku piiramiseks ja orgaanilise materjali tulekindluse suurendamiseks','Fire repelling and blocking composition, method for preparing and use thereof for fire fighting and improving organic material fire resistance',35);
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 */;

