-- MySQL dump 10.16  Distrib 10.1.44-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: Warpit_Webcati
-- ------------------------------------------------------
-- Server version	10.1.44-MariaDB-0+deb9u1

/*!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 utf8mb4 */;
/*!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 */;

--
-- Table structure for table `HFCS06_Beteiligungen_tree`
--

DROP TABLE IF EXISTS `HFCS06_Beteiligungen_tree`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HFCS06_Beteiligungen_tree` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `id_sup` int(5) NOT NULL,
  `id_question` int(5) NOT NULL,
  `orderBy` smallint(6) NOT NULL,
  `idLab` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `node_img` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `is_leaf` tinyint(1) NOT NULL,
  `showTogether` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_sup` (`id_sup`),
  KEY `id_question` (`id_question`),
  KEY `orderBy` (`orderBy`)
) ENGINE=InnoDB AUTO_INCREMENT=325 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `HFCS06_Beteiligungen_tree`
--

LOCK TABLES `HFCS06_Beteiligungen_tree` WRITE;
/*!40000 ALTER TABLE `HFCS06_Beteiligungen_tree` DISABLE KEYS */;
INSERT INTO `HFCS06_Beteiligungen_tree` VALUES (13,0,0,1,'DUMMY','',0,0),(14,13,14,1,'questtext','',1,0),(15,13,15,3,'dtxtvars','',1,0),(16,0,16,3,'ENDIV','',1,0),(132,13,132,2,'instext','',1,0),(133,0,0,2,'4-BETEILIGUNGEN','',0,0),(134,133,134,2,'HD0200','',1,0),(135,133,135,3,'HD0210','',1,0),(136,193,136,1,'hdeinx1','',1,0),(137,193,137,2,'HD030x1','',1,0),(138,193,138,4,'AHD040x1','',1,0),(139,324,139,1,'HD050x1','',1,0),(140,324,140,2,'AHD051x1','',1,0),(141,193,141,7,'AHD060x1','',1,0),(142,193,142,8,'HD070x1','',1,0),(143,193,143,10,'HD080x1','',1,0),(144,193,144,12,'AHD082x1','',1,0),(145,133,145,8,'AHD0900','',1,0),(146,133,146,9,'HD1000','',1,0),(147,133,147,10,'HD1010','',1,0),(148,133,148,11,'HD1100','',1,0),(149,133,149,12,'HD1110','',1,0),(150,133,150,13,'AHD1200','',1,0),(151,133,151,14,'AHD1210','',1,0),(152,133,152,16,'AHD1220','',1,0),(153,133,153,17,'AHD1230','',1,0),(154,133,154,19,'AHD1120','',1,0),(155,133,155,20,'AHD1130','',1,0),(156,199,156,1,'hdein2x1','',1,0),(157,199,157,2,'AHD114x1','',1,0),(158,199,158,4,'AHD115x1','',1,0),(159,199,159,6,'AHD116x1','',1,0),(160,199,160,7,'AHD117x1','',1,0),(161,199,161,8,'AHD118x1','',1,0),(162,133,162,25,'AHD1190','',1,0),(163,133,163,26,'HD1300','',1,0),(164,133,164,27,'HD1310','',1,0),(165,133,165,28,'HD1320a','',1,0),(166,133,166,36,'HD1330','',1,0),(167,133,167,38,'HD1400','',1,0),(168,133,168,39,'HD1410','',1,0),(169,133,169,40,'HD1420','',1,0),(170,133,170,42,'HD1500','',1,0),(171,133,171,43,'HD1510','',1,0),(172,133,172,45,'HD1520','',1,0),(173,133,173,46,'AHD1530','',1,0),(174,133,174,47,'AHD1540','',1,0),(175,133,175,48,'HD1600','',1,0),(176,133,176,49,'HD1610','',1,0),(177,133,177,50,'HD1620','',1,0),(178,262,178,1,'HD1630x1','',1,0),(179,262,179,2,'HD1640x1','',1,0),(180,262,180,3,'HD1650x1','',1,0),(181,262,181,4,'HD1660x1','',1,0),(182,133,182,56,'HD1700','',1,0),(183,133,183,57,'HD1710','',1,0),(184,133,184,59,'HD1900','',1,0),(185,133,185,60,'HD1910','',1,0),(186,133,186,61,'HD1920','',1,0),(187,133,187,65,'HD1800','',1,0),(188,133,188,66,'AHD1930','',1,0),(189,133,189,67,'AHD1940','',1,0),(190,133,190,68,'AHD1950','',1,0),(192,13,192,5,'hfcs01xdummy','',1,0),(193,133,0,5,'HD0210x1','',0,0),(194,193,194,3,'AHD031x1','',1,0),(196,13,196,4,'dumPers','',1,0),(197,13,197,6,'hfcs04xdummy','',1,0),(198,13,198,7,'hfcs05xdummy','',1,0),(199,133,0,22,'AHD1130x1','',0,0),(200,133,200,29,'HD1320b','',1,0),(201,133,201,30,'HD1320c','',1,0),(202,133,202,31,'HD1320d','',1,0),(203,133,203,32,'HD1320e','',1,0),(204,133,204,33,'HD1320f','',1,0),(205,133,205,34,'HD1320g','',1,0),(206,133,0,6,'HD0210x2','',0,0),(207,133,0,7,'HD0210x3','',0,0),(228,206,228,1,'hdeinx2','',1,0),(229,206,229,2,'HD030x2','',1,0),(230,206,230,3,'AHD031x2','',1,0),(231,206,231,4,'AHD040x2','',1,0),(232,206,232,5,'HD050x2','',1,0),(233,206,233,7,'AHD051x2','',1,0),(234,206,234,8,'AHD060x2','',1,0),(235,206,235,9,'HD070x2','',1,0),(236,206,236,11,'HD080x2','',1,0),(237,206,237,13,'AHD082x2','',1,0),(238,207,238,1,'hdeinx3','',1,0),(239,207,239,2,'HD030x3','',1,0),(240,207,240,3,'AHD031x3','',1,0),(241,207,241,4,'AHD040x3','',1,0),(242,207,242,5,'HD050x3','',1,0),(243,207,243,7,'AHD051x3','',1,0),(244,207,244,8,'AHD060x3','',1,0),(245,207,245,9,'HD070x3','',1,0),(246,207,246,11,'HD080x3','',1,0),(247,207,247,13,'AHD082x3','',1,0),(248,133,0,23,'AHD1130x2','',0,0),(249,133,0,24,'AHD1130x3','',0,0),(250,248,250,1,'hdein2x2','',1,0),(251,248,251,2,'AHD114x2','',1,0),(252,248,252,4,'AHD115x2','',1,0),(253,248,253,6,'AHD116x2','',1,0),(254,248,254,7,'AHD117x2','',1,0),(255,248,255,8,'AHD118x2','',1,0),(256,249,256,1,'hdein2x3','',1,0),(257,249,257,2,'AHD114x3','',1,0),(258,249,258,4,'AHD115x3','',1,0),(259,249,259,6,'AHD116x3','',1,0),(260,249,260,7,'AHD117x3','',1,0),(261,249,261,8,'AHD118x3','',1,0),(262,133,0,51,'HD1630x1','',0,0),(263,133,0,52,'HD1630x2','',0,0),(264,263,264,2,'HD1630x2','',1,0),(265,263,265,3,'HD1640x2','',1,0),(266,263,266,4,'HD1650x2','',1,0),(267,263,267,5,'HD1660x2','',1,0),(268,263,268,1,'hd1630einx2','',1,0),(270,133,0,53,'HD1630x3','',0,0),(271,133,0,54,'HD1630x4','',0,0),(272,133,0,55,'HD1630x5','',0,0),(273,270,273,1,'hd1630einx3','',1,0),(274,270,274,2,'HD1630x3','',1,0),(275,270,275,3,'HD1640x3','',1,0),(276,270,276,4,'HD1650x3','',1,0),(277,270,277,5,'HD1660x3','',1,0),(278,271,278,1,'hd1630einx4','',1,0),(279,271,279,2,'HD1630x4','',1,0),(280,271,280,3,'HD1640x4','',1,0),(281,271,281,4,'HD1650x4','',1,0),(282,271,282,5,'HD1660x4','',1,0),(283,272,283,1,'hd1630einx5','',1,0),(284,272,284,2,'HD1630x5','',1,0),(285,272,285,3,'HD1640x5','',1,0),(286,272,286,4,'HD1650x5','',1,0),(287,272,287,5,'HD1660x5','',1,0),(288,133,288,69,'AZT0250','',1,0),(290,193,290,11,'AHD081x1','',1,0),(291,206,291,12,'AHD081x2','',1,0),(292,207,292,12,'AHD081x3','',1,0),(293,133,293,1,'hdein0','',1,0),(294,133,294,4,'sc162HD0210','',1,0),(295,193,295,6,'sc164AHD040x1','',1,0),(296,193,296,9,'sc167AHD070x1','',1,0),(297,206,297,6,'sc164AHD040x2','',1,0),(298,207,298,6,'sc164AHD040x3','',1,0),(299,206,299,10,'sc167AHD070x2','',1,0),(300,207,300,10,'sc167AHD070x3','',1,0),(301,133,301,15,'sc171AHD1210','',1,0),(302,133,302,18,'sc172AHD1230','',1,0),(303,133,303,21,'sc174AHD1130','',1,0),(304,199,304,3,'sc176AHD114x1','',1,0),(305,199,305,5,'sc178AHD115x1','',1,0),(306,199,306,9,'sc179AHD118x1','',1,0),(307,248,307,3,'sc176AHD114x2','',1,0),(308,249,308,3,'sc176AHD114x3','',1,0),(309,248,309,5,'sc178AHD115x2','',1,0),(310,249,310,5,'sc178AHD115x3','',1,0),(311,248,311,9,'sc179AHD118x2','',1,0),(312,249,312,9,'sc179AHD118x3','',1,0),(313,133,313,35,'sc181HD1320','',1,0),(317,133,317,37,'sc182HD1330','',1,0),(318,133,318,41,'sc184HD1420','',1,0),(319,133,319,44,'sc185HD1510','',1,0),(320,133,320,58,'sc189HD1710','',1,0),(321,133,321,62,'sc190HD1920','',1,0),(322,133,322,63,'sc191HD1920','',1,0),(323,133,323,64,'sc192HD1920','',1,0),(324,193,0,5,'HD050 AHD051 x1','',0,1);
/*!40000 ALTER TABLE `HFCS06_Beteiligungen_tree` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 */;

-- Dump completed on 2020-05-28 17:23:11
