-- 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 ('X2475','2015-08-17'),('X2486','2015-08-17'),('X2504','2015-08-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 ('X2475       ','Käesoleva kasuliku mudeli eesmärk on lihtsustada vahetatava turvise konstruktsiooni ja võimaldada vahetatava turvise mitmekordset kasutamist ilma kinnitusvahenditeta ning samuti võimaldada kiiret ja lihtsat paigaldamist ning eemaldamist. Mainitud vahetatav turvis on toodetud rõngakujulise kattena, mille välispinnal on turvisemuster ja mille struktuur sarnaneb õhkrehvi struktuuriga. Samal ajal on mainitud rõngakujulise katte sisemine diameeter praktiliselt võrdne õhkrehvi kogudiameetriga, kusjuures radiaalne paksus on vahemikus 0,1 kuni 2,0 rehvipaksust rehvi veerepinna alal ja laius on vahemikus 0,03 kuni 1,0 õhkrehvi veerepinna laiust. Rõngakujuline kate on toodetud selliselt, et see mahub vabalt õhkrehvi veerepinnale, kui rehvirõhk on viidud madalamaks kui õhurõhk, ja selliselt, et rõngakujuline kate kinnitub veerepinnale, kui õhkrehvis tõstetakse rõhk vähemalt nimiväärtuseni. Samuti on rõngakujuline kate toodetud nii, et seda on võimalik korduvalt kasutada ja korduvalt eemaldada, ilma et see kahjustaks õhkrehvi või rõngakujulist katet. Sellist tulemust võimaldab ka asjaolu, et enne rõngakujulise katte paigaldamist viiakse õhkrehvi rõhk õhurõhust madalamaks ja mainitud kate paigutatakse vabalt vähemalt osale õhkrehvi veerepinnast; seejärel tõstetakse rõhk kuni vähemalt nimiväärtuseni ja rõngakujuline kate kinnitub õhkrehvi veerepinnale.','The aim of the present invention is to simplify the design and ensure multiple utilization of the removable tread without fastening devices, as well as to enable fast and easy mounting and demounting. The removable tread is manufactured as a ring-shaped covering with a tread pattern on the outer surface and a structure similar to the pneumatic tyre structure. At the same time the ring-shaped covering has an internal diameter essentially equal to the outer diameter of the pneumatic tyre, radial thickness within the 0.1-2.0 range of the tyre thickness in the cap area, and width lying within 0.03 - 1.0 range of the pneumatic tyre cap width. The ring-shaped covering is manufactured to enable free fitting onto the pneumatic tyre cap by reducing the pressure in the tyre below the atmospheric pressure, and its fastening onto the cap by increasing the pressure in the pneumatic tyre to at least the nominal value; and the covering is manufactured to allow multiple use and removal without damage to the pneumatic tyre and the ring-shaped covering. This result is also due to the fact that prior to mounting of the ring-shaped covering the pressure in the pneumatic tyre is reduced to below atmospheric pressure, and the covering is put freely onto at least a part of the pneumatic tyre cap, afterwards the pressure is increased to at least the nominal value and the ring-shaped coating is attached onto the pneumatic tyre cap.'),('X2486       ','Leiutis käsitleb rasvafiltrit, mis sisaldab eesmist paneeli (1), tagumist paneeli (2), eesmisest kambrist (6) ja tagumisest kambrist (7) koosnevaid mooduleid, esimest külgmist paneeli (3a) ja teist külgmist paneeli (3b), eesmiste kambrite vastuvõtuavasid (8), tagumiste kambrite vastuvõtuavasid (9), moodulitevahelisi vaheseinu (4a) ja kambritevahelisi vaheseinu (4b). Uudne on see, et eesmised kambrid (6) ja tagumised kambrid (7) on peamiselt kolmnurkse ristlõikega, kusjuures eesmised kambrid (6) on moodustatud eesmise paneeli (1) fragmendi, moodulite vaheseina (4a) ja kambrite vaheseina (4b) poolt ja tagumised kambrid (7) on moodustatud tagumise paneeli (2) fragmendi, kambrite vaheseina (4b) ja moodulite vaheseina (4a) poolt.','The invention relates to a grease filter comprising front panel (1), back panel (2), modules consists of the front chamber (6) and the back chamber (7), the first side panel (3a) and the second side panel (3b), the front chamber inlets (8), the back chamber inlets (9), partitions (4a) between modules, partition(4b) between chambers. The novelty lies in the front chambers (6) and back chambers (7) having mainly triangular cross-section, whereas the front chambers (6) are formed by a fragment of the front panel (1), the modules\' partition (4a) and the chambers\' partition (4b), and the back chambers are formed by a fragment of the back panel (2), the chambers\' partition (4b) and the modules\' partition (4a).'),('X2504       ','Käesolev leiutis käsitleb pulka toiduaine, nagu jäätise, kommi või muu maiustuse hoidmiseks. Pulga kasutusolukorras on pulga üks ots ette nähtud paiknema toiduaines ja pulga teine ots on ette nähtud pulga hoidmiseks. Pulga otste vahel asetseb vedeliku imamise vahend.','The present invention relates to a stick for holding a food product such as an ice cream, a sweet or other treat. In a usage situation one end of the stick is intended to be positioned into the foodstuff and the other end of the stick is intended for holding a stick. Between the ends of the stick a means for absorbing fluid is situated.');
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 (37,'Patendibüroo Turvaja OÜ','Riho','Pikkor','Liivalaia 22','Tallinn','10118','EE'),(46,'LASVET Patendibüroo OÜ','Jürgen','Toome','Suurtüki 4a','Tallinn','10133','EE'),(53,'Patendibüroo Käosaar & Co OÜ','Marit','Meinberg','Suur-Patarei 2','Tallinn','10415','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 ('X2475       ',1),('X2486       ',1),('X2504       ',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 ('X2475','201501','B60C   9/22',1,1,1,1),('X2475','201501','B60C  11/00',1,1,1,2),('X2475','201501','B60C  11/02',1,1,1,3),('X2475','201501','B60C  11/14',1,1,1,4),('X2486','201501','A47J  36/38',1,1,1,1),('X2486','201501','B01D  46/06',1,1,1,2),('X2486','201501','B01D  46/24',1,1,1,3),('X2486','201501','B01D  46/40',1,1,1,4),('X2486','201501','B01D  46/52',1,1,1,5),('X2486','201501','B01D  47/05',1,1,1,6),('X2486','201501','B01D  50/00',1,1,1,7),('X2486','201501','F24C  15/20',2,1,1,8),('X2504','201501','A23G   9/26',1,1,1,1),('X2504','201501','A23G   9/44',1,1,1,2),('X2504','201501','A23G   9/50',1,1,1,3),('X2504','201501','A47G  21/00',1,1,1,4),('X2504','201501','B65D  85/78',1,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 ('X2475       ',2306,1),('X2486       ',2315,1),('X2486       ',2318,2),('X2486       ',2319,3),('X2504       ',2341,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 (2306,'Denis Valentinovich','','Nikishin','Rochdelskaya Str., h 12, Bld. 1, ap. 31','RU','Moscow','123022    ',''),(2315,'Triin','','Leetmaa','Astangu 72-44','EE','Tallinn','13519     ',''),(2318,'Einari','','Karm','Võnnu 23','EE','Haapsalu','90504     ',''),(2319,'Urmas','','Hiie','Läike 14','EE','Tallinn','10913     ',''),(2341,'Kaio','','Kivima','Jaan Poska 39/1-1','EE','Tallinn','10150     ','');
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 ('X2475       ',1721,1),('X2486       ',1729,1),('X2504       ',1752,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 (1721,1,'Denis Valentinovich','','Nikishin','','Rochdelskaya Str., h 12, Bld. 1, ap. 31','RU','Moscow','123022',''),(1729,2,'','','','ETS Nord AS','Peterburi tee 53','EE','Tallinn','11415',''),(1752,1,'Kaio','','Kivima','','Jaan Poska 39/1-1','EE','Tallinn','10150','');
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 ('X2475       ','EE201500007',201500007,'EE01311','01311',1,'20150817','U201500007  ','20150212','Vahetatav rehviturvis','Removable tyre tread',53),('X2486       ','EE201500017',201500017,'EE01310','01310',1,'20150817','U201500017  ','20150311','Rasvafilter','Grease filter',37),('X2504       ','EE201500035',201500035,'EE01309','01309',1,'20150817','U201500035  ','20150507','Pulk toiduaine, nagu jäätise, kommi või muu maiustuse hoidmiseks','Stick for holding a food product such as an ice cream, sweet or other treat',46);
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 */;