-- 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 ('X2328','2016-12-15'),('X2540','2016-12-15'),('X2559','2016-12-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 ('X2328       ','Meetod mobiilterminali vahendusel loovtööde konkurssidel osalemiseks süsteemis, mis sisaldab mobiilterminale, mis on arvutivõrgu kaudu ühendatud serveriga. Meetod sisaldab järgmisi protsesse: a) mobiilterminalis käivitatakse mobiilterminali rakendus serveril jooksva rakenduse poolt hallataval konkursil osalemiseks; b) mobiilterminali rakenduse kaudu edastatakse loovtöö serveri rakendusele konkursil osalemiseks; c) serveri rakenduse poolt edastatakse mobiilterminalile valik varem esitatud loovtöid hindamiseks; d) mobiilterminali rakenduse poolt võetakse vastu ja edastatakse kasutaja hinnang vähemalt ühele varem esitatud loovtööle; ning e) mobiilterminali kaudu edastatud loovtöö võetakse serveri rakenduse poolt konkursile vastu alles pärast varasemale loovtööle hinnangu andmist.','Method for participating in creative work competitions via mobile terminal in a system comprising mobile terminals that are connected to server via computer network. The method comprises: a) a mobile terminal application is started in the mobile terminal for participating in a competition hosted by a server application; b) creative work for participating in competition is transmitted via mobile terminal application to a server application; c) server application transmits previously presented creative works for rating to the mobile terminal; d) mobile terminal application receives and forwards the user\'s rating to at least one previously presented creative work; and e) creative work transmitted via the mobile terminal is admitted by the server application to the competition only after previous creative works are rated.'),('X2540       ','Suitsugeneraator on seade suitsuahjule intensiivse ja ühtlaselt hajuva suitsu tootmiseks, kusjuures kuumutuselement on asetatud võre peal oleva suitsumaterjali kohale.','Generator of smoke is a device for producing intensive smoke that is evenly distributed, whereby the heating unit is located above the smoking stuff situated on the grid.'),('X2559       ','Käesolev leiutis käsitleb mööblieset, täpsemalt tumbat ja selle tugitooliks muutmise lahendust. Tugitooliks muudetav tumba koosneb tumba istme liikumatust osast 1, tumba istme U-kujulisest liikumisvõimelisest osast 2 ja tumba istme U-kujulise liikumisvõimelise osa kõrguse reguleerimise seadmest 3. Lahenduses muudetakse tumba tugitooliks nii, et tumba istme perimeetril, tumba istme tasapinnalt, tumba istme U-kujulise liikumisvõimelise osa kõrguse reguleerimise seadet 3 kasutades liigutatakse tumba istme U-kujuline liikumisvõimeline osa 2 üles liikumisulatusega L, mille tulemusel moodustub käe-ja seljatugi, muutes tumba tugitooliks, ja tumba istme U-kujulise liikumisvõimelise osa 2 ehk käe- ja seljatoe allaliikumisel tumba istme tasapinnale muutub tugitool tagasi tumbaks.','The invention handles a piece of furniture, precisely pouf and a solution of converting the pouf to armchair. Pouf convertible to armchair consists of pouf non-movable part 1, pouf seat U-figured movable part 2 and pouf seat U-figured movable part height regulating equipment 3. Solution handles pouf convertible to armchair using pouf seat U-figured movable part height regulating equipment 3 for moving pouf seat U-figured movable part 2 up with movement extent L on pouf seat perimeter from pouf seat level, as a result it becomes an arm- and backrest, converting pouf to armchair. Pouf seat U-figured movable part 2 or armrest-backrest moving down to pouf seat level converts armchair back to pouf.');
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 (35,'KOPPEL patendibüroo OÜ','Mart Enn','Koppel','Roseni 10-151','Tallinn','10111','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 ('X2540       ',1),('X2559       ',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 ('X2328','201601','G06F  17/00',1,1,1,1),('X2328','201601','G06F  15/16',2,1,1,2),('X2540','201501','A23B   4/052',1,1,1,1),('X2559','201601','A47C  13/00',1,1,1,1),('X2559','201601','A47C   7/40',2,1,1,2),('X2559','201601','A47C   3/16',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 ('X2328       ',1655,4),('X2328       ',2116,1),('X2328       ',2117,2),('X2328       ',2137,5),('X2328       ',2138,6),('X2540       ',2381,2),('X2559       ',2393,1),('X2559       ',2394,2);
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 (1655,'Marek','','Kullas','C.R. Jakobsoni 18-2','EE','Tartu','51005',''),(2116,'Eero','','Talvistu','Sadama 18','EE','Haapsalu','90502',''),(2117,'Kristjan','','Sild','Pikk 52-5','EE','Tallinn','10133',''),(2137,'Oliver','','Raal','Sõle 25B/2-11','EE','Tallinn','10614',''),(2138,'Robert','','Kõrvits','Koidu 40-10','EE','Tallinn','10136',''),(2381,'Jussi Tapani','','Mäenpää','Kadaka tee 22, Vaela küla, Kiili vald','EE','Harju maakond','75413',''),(2393,'Rene','','Urb','Kummeli tee 88','EE','Tallinn','11912',''),(2394,'Lemme','','Urb','Kummeli tee 88','EE','Tallinn','11912','');
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 ('X2328       ',1552,1),('X2540       ',1788,2),('X2559       ',1799,1),('X2559       ',1800,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 (1552,2,'','','','Camorka OÜ','Veerenni 24','EE','Tallinn','10135',''),(1788,1,'Jussi Tapani','','Mäenpää','','Kadaka tee 22, Vaela küla, Kiili vald','EE','Harju maakond','75413',''),(1799,1,'Rene','','Urb','','Kummeli tee 88','EE','Tallinn','11912',''),(1800,1,'Lemme','','Urb','','Kummeli tee 88','EE','Tallinn','11912','');
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 ('X2328       ','EE201300058',201300058,'EE01381','01381',1,'20161215','U201300058  ','20130517','Meetod mobiilterminali vahendusel loovtööde konkurssidel osalemiseks','Method for participating in creative work competitions via mobile terminal',35),('X2540       ','EE201500069',201500069,'EE01379','01379',1,'20161215','U201500069  ','20150920','Suitsugeneraator','Smoke device',0),('X2559       ','EE201600001',201600001,'EE01380','01380',1,'20161215','U201600001  ','20160106','Tugitooliks muudetav tumba','Pouf convertible to armchair',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 */;

