-- 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 ('X2429','2015-12-15'),('X2440','2015-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 ('X2429 ','Vann harjutuste tegemiseks sisaldab ligikaudu vertikaalset seinaosa ning vastavalt vormitud vannipõhja, millest eendub harjutamisalus, kusjuures vannipõhi on vormitud nii, et vanni kõige sügavam ala on harjutamisalusel lamava inimese jalgade liigutamise ulatuse piirkonnas, madalam käte liigutamise ulatuse piirkondades, kusjuures vanni kuju pealtvaates on konfigureeritud järgima harjutamisaluse kasutajate jäsemete liigutamise ulatuse trajektoori.','Bath for exercising, which contains an approximately vertical wall portion, and a suitably configured bath bottom, from which extends an exercise base, wherein the bath bottom is formed so that the bath is the deepest in the area where the person lying on the exercise base reaches when moving her legs, the bath is lower in the area where she reaches when moving her arms, wherein the bath bottom is shaped so that in the top view it follows the trajectory of the user can reach when moving her limbs.'),('X2440 ','Leiutiseks on kaugjuhitav helifaile taasesitav pehme mänguasi, mis on mõeldud lastele helifailide, näiteks MP3-formaadis failide taasesitamiseks ja kuulamiseks. Kaugjuhitava pehme MP3-mänguasja pehme korpus sisaldab MP3-audioseadet, mis on väljast kaugjuhitava puldiga reguleeritav. MP3-audioseade asub pehme korpuse sees olevas taskus olevas pehmendusega kotis, mistõttu ei kaota kaugjuhitav pehme MP3-mänguasi väljastpoolt oma pehmeid omadusi. Pehme korpuse sees olev tasku on välimiselt küljelt tõmblukuga lukustatav, mistõttu ei pääse laps seesolevale tehnikale ligi.','The invention is a remote controlled playback soft toy for listening audio files, e.g. files in MP3 format for children. Remote controlled soft MP3 toy has a soft body which contains a remote control regulated MP3 audio device. MP3 audio device is inside a cushioned bag in a pocket which is inside the soft body and therefore the remote controlled soft toy maintains its soft characteristics. The pocket inside the soft body is lockable from outside by a zipper, so a child is not able to reach technical devices inside.'); 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'),(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 ('X2429 ',1),('X2440 ',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 ('X2429','201501','A63B 21/00',1,1,1,1),('X2429','201501','A63B 22/00',2,1,1,2),('X2429','201501','A63B 23/00',2,1,1,3),('X2429','201501','A47K 3/00',2,1,1,4),('X2440','201501','A63H 3/28',1,1,1,1); 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 ('X2429 ',2247,1),('X2429 ',2248,2),('X2429 ',2249,3); 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 (2247,'Heidi','','Rajamäe-Parik','Tervise 36','EE','Keila','76607 ',''),(2248,'Meelis','','Unt','Järveotsa tee 35A-24','EE','Tallinn','13520 ',''),(2249,'Tarmo','','Härmaorg','Männimetsa tee 2','EE','Tallinn','10915 ',''); 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 ('X2429 ',1658,1),('X2440 ',1672,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 (1658,2,'','','','Waterflight OÜ','Tervise 36','EE','Keila','76607',''),(1672,2,'','','','MyMimm OÜ','Türi 6','EE','Tallinn','11313',''); 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 ('X2429 ','EE201400044',201400044,'EE01328','01328',1,'20151215','U201400044 ','20140612','Vann harjutuste tegemiseks','Bath for exercising',35),('X2440 ','EE201400055',201400055,'EE01329','01329',1,'20151215','U201400055 ','20140901','Kaugjuhitav helifaile taasesitav pehme mänguasi','Remote controlled playback soft toy',36); 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 */;