-- 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 `HFCS08_Erwerb_tree`
--

DROP TABLE IF EXISTS `HFCS08_Erwerb_tree`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HFCS08_Erwerb_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=289 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `HFCS08_Erwerb_tree`
--

LOCK TABLES `HFCS08_Erwerb_tree` WRITE;
/*!40000 ALTER TABLE `HFCS08_Erwerb_tree` DISABLE KEYS */;
INSERT INTO `HFCS08_Erwerb_tree` VALUES (13,0,0,1,'DUMMY','',0,0),(14,13,14,2,'questtext','',1,0),(15,13,15,1,'dtxtvars','',1,0),(16,0,16,7,'ENDIV','',1,0),(132,13,132,3,'instext','',1,0),(133,0,0,2,'5-ERWERB','',0,0),(134,133,134,2,'PE9020','',1,0),(135,133,135,3,'APE0100','',1,0),(136,133,136,4,'APE0100sr','',1,0),(137,133,137,5,'APE0200','',1,0),(138,133,138,6,'APE0200sr','',1,0),(139,133,139,7,'APE0310','',1,0),(140,133,140,9,'APE0500','',1,0),(141,133,141,10,'APE0610','',1,0),(142,133,142,11,'APE0620','',1,0),(143,133,143,13,'APE0630','',1,0),(144,133,144,14,'APE0600','',1,0),(145,133,145,18,'APE0410','',1,0),(146,133,146,20,'PE0700','',1,0),(147,133,147,22,'PE0800','',1,0),(148,133,148,24,'PE0900','',1,0),(149,133,149,25,'APE0250','',1,0),(150,133,150,26,'APE0250sr','',1,0),(151,133,151,27,'PE0350','',1,0),(152,133,152,28,'PE0450','',1,0),(153,133,153,29,'APE0270','',1,0),(154,133,154,30,'APE0270sr','',1,0),(155,133,155,31,'PE0370','',1,0),(156,133,156,32,'PE0470','',1,0),(157,133,157,33,'PEZ010','',1,0),(158,133,158,34,'PE1005','',1,0),(159,133,159,36,'PE1100','',1,0),(160,133,160,39,'PEZ020','',1,0),(161,133,161,40,'APE1240','',1,0),(162,133,162,41,'APA0320','',1,0),(163,133,163,42,'AZT0270','',1,0),(165,13,165,4,'dumPers','',1,0),(166,13,166,5,'hfcs01xdummy','',1,0),(168,133,168,23,'PE0810','',1,0),(169,0,0,3,'7-EINKOMMEN PG','',0,0),(170,0,0,4,'7-Einkommen HG','',0,0),(171,169,171,1,'PGein','',1,0),(172,169,172,2,'PG9020','',1,0),(173,169,173,3,'PG0100','',1,0),(174,169,174,5,'PG0110','',1,0),(175,169,175,6,'APG0120','',1,0),(176,169,176,7,'PG0200','',1,0),(177,169,177,8,'PG0210','',1,0),(178,169,178,9,'APG0220','',1,0),(179,169,179,10,'PG0300','',1,0),(180,169,180,12,'PG0310','',1,0),(181,169,181,15,'APG0320','',1,0),(182,169,182,16,'APG0330','',1,0),(183,169,183,17,'APG0340','',1,0),(184,169,184,18,'APG0350','',1,0),(185,169,185,19,'APG0400','',1,0),(186,169,186,21,'APG0410','',1,0),(187,169,187,23,'APG0420','',1,0),(188,169,188,24,'APG0430','',1,0),(189,169,189,25,'APG0440','',1,0),(190,169,190,26,'APG0450','',1,0),(191,169,191,27,'APG0461','',1,0),(192,169,192,28,'APG0470','',1,0),(193,169,193,29,'APG0480','',1,0),(194,169,194,30,'APG0490','',1,0),(195,169,195,31,'APG0462','',1,0),(196,169,196,32,'PG0500','',1,0),(197,169,197,33,'PG0510','',1,0),(198,170,198,1,'HGein','',1,0),(199,170,199,3,'HG0100','',1,0),(200,170,200,5,'HG0110','',1,0),(201,170,201,8,'HG0200','',1,0),(202,170,202,9,'HG0210','',1,0),(203,170,203,10,'HG0250','',1,0),(204,170,204,11,'HG0260','',1,0),(205,170,205,12,'HG0300','',1,0),(206,170,206,15,'HG0310','',1,0),(207,170,207,17,'HG0400','',1,0),(208,170,208,20,'HG0410','',1,0),(209,170,209,21,'AHG0420','',1,0),(210,170,210,22,'HG0500','',1,0),(211,170,211,25,'HG0510','',1,0),(212,170,212,26,'HG0600','',1,0),(213,170,213,27,'HG0620','',1,0),(214,170,214,28,'HG0610','',1,0),(215,170,215,30,'HG0700','',1,0),(216,170,216,31,'HG0800','',1,0),(217,170,217,32,'AZT0280','',1,0),(218,0,0,5,'6-PENSION','',0,0),(219,218,219,1,'PFein','',1,0),(221,218,221,3,'APF0100','',1,0),(222,218,222,4,'APF0110','',1,0),(223,218,223,6,'APF0300','',1,0),(224,218,224,8,'APF0520','',1,0),(225,218,225,9,'APF0530','',1,0),(226,218,226,10,'APF0540','',1,0),(227,218,227,12,'APF0600','',1,0),(228,218,228,13,'APF0610','',1,0),(230,218,230,15,'APF0700','',1,0),(231,218,231,16,'APF0710','',1,0),(232,218,232,18,'APF0800','',1,0),(233,218,233,19,'APF0900','',1,0),(234,218,234,20,'APF0920','',1,0),(235,218,235,21,'APF0930','',1,0),(236,218,236,23,'APF0940','',1,0),(237,218,237,25,'AZT0290','',1,0),(238,218,238,11,'APF0550','',1,0),(240,218,240,17,'APF0720','',1,0),(241,218,241,2,'PF9020','',1,0),(242,133,242,1,'PEein','',1,0),(243,170,243,2,'HGxREf','',1,0),(247,0,0,6,'11-Lebenszufriedenheit','',0,0),(248,247,248,1,'APA9020','',1,0),(249,247,249,2,'APA0710x1','',1,0),(250,247,250,3,'APA0720x1','',1,0),(251,247,251,4,'APA0730x1','',1,0),(252,247,252,5,'APA0740x1','',1,0),(253,247,253,6,'APA0750x1','',1,0),(254,247,254,7,'AZT0300','',1,0),(255,133,255,15,'sc201APE0600','',1,0),(256,133,256,16,'sc202APE0600','',1,0),(257,133,257,17,'sc203APE0600','',1,0),(258,133,258,12,'sc204APE0620','',1,0),(259,133,259,21,'sc205PE0700','',1,0),(260,133,260,35,'sc206PE1005','',1,0),(261,133,261,37,'sc207PE1100','',1,0),(262,133,262,38,'sc208PE1100','',1,0),(263,218,263,5,'sc243APF0110','',1,0),(264,218,264,7,'sc244APF0300','',1,0),(265,218,265,14,'sc246APF0610','',1,0),(266,218,266,22,'sc247APF0930','',1,0),(267,218,267,24,'sc248APF0940','',1,0),(268,169,268,4,'sc209PG0100','',1,0),(269,169,269,11,'sc214PG0300','',1,0),(270,169,270,13,'sc216PG0310','',1,0),(271,169,271,14,'sc217PG0310','',1,0),(272,169,272,20,'sc219PG0400','',1,0),(273,169,273,22,'sc221APG0410','',1,0),(274,169,274,34,'sc224APG0510','',1,0),(275,169,275,35,'sc225APG0510','',1,0),(276,170,276,6,'sc228HG0110','',1,0),(277,170,277,7,'sc229HG0110','',1,0),(278,170,278,13,'sc232HG0300','',1,0),(279,170,279,14,'sc233HG0300','',1,0),(280,170,280,16,'sc235HG0310','',1,0),(281,170,281,18,'sc236HG0400','',1,0),(282,170,282,19,'sc237HG0400','',1,0),(283,170,283,23,'sc239HG0500','',1,0),(284,170,284,24,'sc240HG0500','',1,0),(285,170,285,29,'sc242HG0610','',1,0),(286,170,286,4,'sc226HG0100','',1,0),(287,133,287,19,'PE0400','',1,0),(288,133,288,8,'PE0300','',1,0);
/*!40000 ALTER TABLE `HFCS08_Erwerb_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:12
