-- 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 ('X2519','2016-11-15'),('X2525','2016-11-15'),('X2553','2016-11-15'),('X2554','2016-11-15'),('X2556','2016-11-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 ('X2519       ','Käesolev leiutis on seotud tulirelva lahtikäiva kabaga, mis võimaldab kaba pöörata kokkupandud asendist (tulirelva küljel) taktikalisse asendisse. Lahtikäiv kaba sisaldab kaba (1), mis on kinnitatud kaba varda (2) külge, mille otsa on moodustatud U-kujuline detail, mis kinnitatakse kaba pööra külge kinnitusdetaili (9), 5 tsentreerimispuksi (8) ja vedruga (7). Kaba pööra (3) tulirelva-poolne ots sisestatakse tulirelva adapterisse ning kinnitatakse adapteri vaheseina külge tagasilöögiplaadiga 6. Tagasilöögiplaadi 6 külge on kinnitatud tagasilöögipuks tulirelva kelgu tagasilöögi kompenseerimiseks. Kaba pöör on valmistatud ilmastikukindlast plastmaterjalist.','The present invention relates to a foldable butt stock for the firearm, which enables to rotate the butt stock from the folded position (on the side of the firearm) to the tactical position. The foldable butt stock comprises a butt (1), which is fixed to the butt rod (2) end of which is formed a U-shaped member, which is fixed to the rotatable knob of the butt by fastening element (9), centring bush (8) and the spring (7). The firearm side end of the reversible knob (3) is inserted into the firearm adapter and fixed to the adapter partition with baffle plate (6). The baffle bunt (5) is attached to the baffle plate (6) to compensate the backfire of the firearm carriage. The butt reversible knob is made from the weather-resistant plastics material.'),('X2525       ','Esitatud kokkupandav jalgratta 1 külghaagis 2 sisaldab raami, mille moodustavad kokkupandav alumine raam 3 ja jäikusraam 10, kokkupandavat tugitooli 4, kettülekandega autonoomset pedaalisõlme 5 ja külghaagise ratast 6. Alumine raam 3 sisaldab kolme väikeraami 7, 8, 9, mis on ühendatud liigenditega lattidega 32. Autonoomse pedaalisõlme 5 kettülekanne sisaldab ainult ühte eesmist vedavat ketiratast  17, ühte ketti 18, ühte tagumist veetavat ketiratast 19 ja liitvõlli 20. Külghaagis 2 on kinnitatud jalgratta 1 külge kolmes kohas jalgrattaraami tagaosas, kasutamata jalgrattaraami juhtraua toru, kinnitustoru 24, kinnituskronsteini 27, lukkude 31, paigalduskronsteini 25 ja reguleerimiskronsteini 26 abil. Külghaagis 2 on kinnitatud jalgratta külghaagise ratta 6 telje nihutamisega tahapoole jalgratta tagumise ratta pikitelje suhtes vähemalt 150-200 mm. Esitatud leiutise autonoomne pedaalisõlm 5 vähendab jalgratturi koormust külghaagises kaassõitja transportimisel. Tugitooli 4 eemaldamisel kasutatakse jäikusraami 10 veoseplatvormina.','The present collapsible bicycle 1 sidecar 2 comprises a frame formed by collapsible lower frame 3 and a stiffening frame 10, a collapsible armchair 4, a pedal autonomous device 5 with chain transmission and a sidecar wheel 6. The lower frame 3 comprises three small frames 7, 8 , 9 connected by articulated bars 32. The pedal device 5 with chain transmission comprises only one head driving sprocket wheel 17, one chain 18, one back driven sprocket wheel 19 and the combination shaft 20. The sidecar 2 is attached to the bicycle 1 in three positions by a fastening pipe 24, a fastening bracket 27, a mounting bracket 25 and an adjustment bracket 26 without using the pipe of the frame of bicycle controls. The sidecar 2 is attached to the bicycle 1 by transferring the axle of the wheel 6 of the sidecar back in respect to the axle of the wheel of the bicycle at least 150 mm to 200 mm. The autonomous pedal drive 5 of the present invention decreases the efforts of the biker. If the armchair 4 is removed, the frame 10 is used as a pallet.'),('X2553       ','Meetod kalapüügiks jäätunud veekogust vee aereerimise abil hõlmab vähemalt ühte veekogu kaldal asuvat ehitist, milles on vähemalt üks õhuhapnikuga rikastamise segisti. Vesi pumbatakse jäätunud veekogust segistisse, kus toimub vee õhustamine, ja seejärel suunatakse õhustatud vesi veekogusse tagasi. Leiutis ühendab endas vee õhustamist, kalakasvatust ja turvalist talvist kalapüüki kaldaga ühendatud  sillalt, väldib hapnikupuudust jäätunud veekogus ning peatab kalade massilise talvise hävingu ja vähendab ohtlike mikroorganismide ja mürgiste gaaside tekkimist veekogus. Esitatud süsteemis ja meetodis on uus segistitüüp, anti-kollineaarne difuusor, mis on ette nähtud komponentide difuusseks koostoimimiseks ja toimib ka teiste gaaside ja vedelike puhul.','Method for fishing from iced waters using water aeration comprises at least one building located on the water body coast and at least one mixer for water aeration in the building. The water is pumped from the iced water body into the mixer, where the aeration of water takes place and after that aerated water is directed back to the water body. The invention combines the aeration of water, fish breeding and safe fishing during winter from a bridge united with coast, and avoids massive death of fish in iced water, reducting the content of dangerous microorganisms and development of poisonous gases. New type of mixer, represented in the system and method, called anti-collinear diffuser, is provided for diffusive interaction of components and is also suitable for other gases and liquids.'),('X2554       ','Süsteem kalapüügiks jäätunud veekogust vee aereerimise abil hõlmab vähemalt ühte veekogu kaldal asuvat ehitist, milles on vähemalt üks õhuhapnikuga rikastamise segisti. Vesi pumbatakse jäätunud veekogust segistisse, kus toimub vee õhustamine, ja seejärel suunatakse õhustatud vesi veekogusse tagasi. Leiutis ühendab endas vee õhustamist, kalakasvatust ja turvalist talvist kalapüüki kaldaga ühendatud sillalt, väldib hapnikupuudust jäätunud veekogus ning peatab kalade massilise talvise hävingu ja vähendab ohtlike mikroorganismide ja mürgiste gaaside tekkimist veekogus. Esitatud süsteemis on uus segistitüüp, anti-kollineaarne difuusor, mis on ette nähtud komponentide difuusseks koostoimimiseks ja toimib ka teiste gaaside ja vedelike puhul.','System for fishing from iced waters using water aeration comprises at least one building located on the water body coast and at least one mixer for water aeration in the building. The water is pumped from the iced water body into the mixer, where the aeration of water takes place and after that aerated water is directed back to the water body. The invention combines the aeration of water, fish breeding and safe fishing during winter from a bridge united with coast, and avoids massive death of fish in iced water, reducting the content of dangerous microorganisms and development of poisonous gases. New type of mixer, represented in the system, called anti-collinear diffuser, is provided for diffusive interaction of components and is also suitable for other gases and liquids.'),('X2556       ','Kultivaatoripii sisaldab deltapiid 3, mis on kinnitatud liigendi 4 abil piisääre 1 tagumise külje alumise osa külge. Nimetatud konstruktsiooniga kultivaatoripiid on mõeldud eeskätt reaskultuuri kultivaatori tarbeks.','Tine of a cultivator contains a delta tine 3, which is fastened with a joint 4 to the bottom part of back side of the cultivator’s tine shank 1. The cultivator’s tine is intented to be used mainly for a drill cultivator.');
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 (12,'Patendibüroo Kaitsepurus OÜ','Reet','Maasikamäe','Mulla 4-3','Tallinn','10611','EE'),(38,'Sarap ja Putk Patendibüroo','Margus','Sarap','Kompanii 1C','Tartu','51004','EE'),(41,'Patendi- & Kaubamärgibüroo Koitel OÜ','Raivo','Koitel','Tina 26','Tallinn','10126','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 ('X2519       ',1),('X2525       ',1),('X2553       ',1),('X2554       ',1),('X2556       ',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 ('X2519','201601','F41C  23/04',1,1,1,1),('X2525','201601','B62K  27/02',1,1,1,1),('X2525','201601','B62K  27/12',2,1,1,2),('X2553','201601','A01K  63/04',1,1,1,1),('X2553','201601','C02F   7/00',1,1,1,2),('X2554','201601','A01K  63/04',1,1,1,1),('X2554','201601','C02F   7/00',1,1,1,2),('X2556','201601','A01B  35/22',1,1,1,1),('X2556','201601','A01B  23/02',1,1,1,2);
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 ('X2525       ',2357,1),('X2553       ',2385,1),('X2554       ',2385,1),('X2556       ',2224,1),('X2556       ',2389,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 (2224,'Mattias','','Hunt','Põhja-Vesiroosi talu, Vilusi küla, Lohusuu vald','EE','Ida-Viru maakond','42007',''),(2357,'Viktor','','Narsutdinov','Kolde pst 88-47','EE','Tallinn','10321',''),(2385,'Svetlana','','Abels','Järve tee 4-58, Klooga alevik, Keila vald','EE','Harju maakond','76703',''),(2389,'Mati','','Müüripeal','Taaratamme talu, Haapsi küla, Varbla vald','EE','Pärnu maakond','88207','');
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 ('X2519       ',1761,1),('X2525       ',1764,1),('X2553       ',1792,1),('X2554       ',1792,1),('X2556       ',1634,1),('X2556       ',1795,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 (1634,1,'Mattias','','Hunt','','Põhja-Vesiroosi talu, Vilusi küla, Lohusuu vald','EE','Ida-Viru maakond','42007',''),(1761,2,'','','','EST-MIL Tactical OÜ','Vahtra talu, Ruskavere küla, Saare vald','EE','Jõgeva maakond','49315',''),(1764,1,'Viktor','','Narsutdinov','','Kolde pst 88-47','EE','Tallinn','10321',''),(1792,1,'Svetlana','','Abels','','Järve tee 4-58, Klooga alevik, Keila vald','EE','Harju maakond','76703',''),(1795,1,'Mati','','Müüripeal','','Taaratamme talu, Haapsi küla, Varbla vald','EE','Pärnu maakond','88207','');
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 ('X2519       ','EE201500050',201500050,'EE01378','01378',1,'20161115','U201500050  ','20150630','Lahtikäiv kaba tulirelvale','A foldable butt stock for the firearm',38),('X2525       ','EE201500056',201500056,'EE01377','01377',1,'20161115','U201500056  ','20150729','Kokkupandav jalgratta külghaagis','Collapsible bicycle sidecar',41),('X2553       ','EE201500082',201500082,'EE01375','01375',1,'20161115','U201500082  ','20151211','Meetod kalapüügiks jäätunud veekogust vee aereerimise abil','Method for fishing from iced waters using water aeration',0),('X2554       ','EE201500083',201500083,'EE01376','01376',1,'20161115','U201500083  ','20151211','Süsteem kalapüügiks jäätunud veekogust vee aereerimise abil','System for fishing from iced waters using water aeration',0),('X2556       ','EE201500085',201500085,'EE01374','01374',1,'20161115','U201500085  ','20151229','Kultivaatoripii','Tine of a cultivator',12);
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 */;