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

DROP TABLE IF EXISTS `HFCS03_Konsum`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `HFCS03_Konsum` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `q_pos` int(5) NOT NULL,
  `q_name` char(20) COLLATE utf8_unicode_ci NOT NULL,
  `tip_sql` int(2) DEFAULT NULL,
  `drg_sql` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `les_sql` int(2) DEFAULT NULL,
  `goto_sql` text COLLATE utf8_unicode_ci NOT NULL,
  `fil_sql` text COLLATE utf8_unicode_ci NOT NULL,
  `con_sql` text COLLATE utf8_unicode_ci NOT NULL,
  `open_sql` int(2) DEFAULT NULL,
  `anno_sql` int(2) DEFAULT NULL,
  `attachAnswers` int(11) DEFAULT NULL,
  `attachFalse` tinyint(1) DEFAULT NULL,
  `rot_sql` text COLLATE utf8_unicode_ci,
  `srot_sql` int(1) DEFAULT NULL,
  `erot_sql` int(1) DEFAULT NULL,
  `srotLegend` int(1) DEFAULT NULL,
  `erotLegend` int(1) DEFAULT NULL,
  `srotAttributes` int(1) DEFAULT NULL,
  `erotAttributes` int(1) DEFAULT NULL,
  `qrot_sql` char(9) COLLATE utf8_unicode_ci DEFAULT NULL,
  `id_style` int(8) DEFAULT NULL,
  `id_mask` int(8) DEFAULT NULL,
  `must_answer` tinyint(1) NOT NULL DEFAULT '1',
  `disable_question` tinyint(1) NOT NULL DEFAULT '0',
  `answers_filter` tinyint(1) NOT NULL DEFAULT '0',
  `variableTypeBase` tinyint(1) NOT NULL DEFAULT '4',
  `variableTypeOpen` tinyint(1) NOT NULL DEFAULT '0',
  `open_answers` char(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `open_legend` char(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `open_attributes` char(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `multi_nogo_answers` char(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `multi_nogo_legends` char(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `multilanguage_all` text COLLATE utf8_unicode_ci,
  `qleave_js_alert` tinyint(1) NOT NULL DEFAULT '0',
  `filter_answer` text COLLATE utf8_unicode_ci,
  `filter_legend` text COLLATE utf8_unicode_ci,
  `filter_attributes` text COLLATE utf8_unicode_ci,
  `hasStructure` tinyint(4) DEFAULT '0',
  `use_for_quotas` tinyint(1) DEFAULT '0',
  `isFinal` tinyint(1) DEFAULT '0',
  `id_showTogether` int(11) NOT NULL DEFAULT '0',
  `answerGroups` text COLLATE utf8_unicode_ci,
  `legendGroups` text COLLATE utf8_unicode_ci,
  `id_plugin` int(11) DEFAULT NULL,
  `id_incentive` int(11) DEFAULT NULL,
  `incentive_possibilites` tinyint(1) NOT NULL DEFAULT '0',
  `allow_listening` tinyint(1) NOT NULL DEFAULT '0',
  `old_id` int(11) NOT NULL,
  `up_down_rotchk` int(11) NOT NULL,
  `up_down_rotvar` int(11) NOT NULL,
  `repeat_legend` int(11) NOT NULL,
  `autoSubmit` tinyint(1) NOT NULL DEFAULT '0',
  `autoSubmitTimeout` int(11) NOT NULL DEFAULT '100',
  `missing_values` char(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `open_end_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 text box 2 text area',
  `enter_submit` tinyint(1) NOT NULL DEFAULT '1',
  `slider_color` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `trace_color` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `slider_shape` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `slider_handle_image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email_app_group` int(11) DEFAULT NULL,
  `email_app_template` int(11) DEFAULT NULL,
  `encrypt` tinyint(1) DEFAULT NULL,
  `multi_type` tinyint(4) DEFAULT '1' COMMENT '1 column multi response 2 line multi response 3 line and column',
  `rotate_legend` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '0 do not rotate legend text 1 rotate legend on desktop 2 rotate legend on mobile 3 rotate legend on both',
  `anonymize` tinyint(4) NOT NULL DEFAULT '0',
  `input_types` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `input_types_properties` text COLLATE utf8_unicode_ci,
  `custom_controls` text COLLATE utf8_unicode_ci,
  `rec_question_id` int(11) DEFAULT '0',
  `rec_interval` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'start_q:end_q',
  `show_as_single` tinyint(4) NOT NULL DEFAULT '0',
  `show_as_single_cond` text COLLATE utf8_unicode_ci,
  `show_as_single_design` int(11) DEFAULT NULL,
  `show_as_single_autosubmit` tinyint(1) DEFAULT '0',
  `show_as_single_autosubmit_delay` int(11) DEFAULT '200',
  `input_position` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 next to label 2 under label',
  `after_text` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `answer_click_animation` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `answer_click_element` int(11) DEFAULT NULL COMMENT '1 - control 2 - label 3 both',
  `answer_click_animation_duration` int(11) NOT NULL DEFAULT '1000',
  PRIMARY KEY (`id`),
  UNIQUE KEY `q_name` (`q_name`),
  KEY `q_pos` (`q_pos`),
  KEY `tip_sql` (`tip_sql`),
  KEY `show_as_single_design` (`show_as_single_design`)
) ENGINE=InnoDB AUTO_INCREMENT=178 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `HFCS03_Konsum`
--

LOCK TABLES `HFCS03_Konsum` WRITE;
/*!40000 ALTER TABLE `HFCS03_Konsum` DISABLE KEYS */;
INSERT INTO `HFCS03_Konsum` VALUES (1,-6,'_Start',5,'',0,'true#1','','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,1,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(2,-5,'_End',5,'',0,'','','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(3,-15,'_notAllow',5,'',0,'','','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(4,-16,'_notActive',5,'',0,'','','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(14,1,'questtext',4,'',6,'','','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,1,0,6,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(15,3,'dtxtvars',4,'',6,'','false','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,1,0,6,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(16,43,'ENDIV',1,'',1,'$ENDIV==1#ENDIV','','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(132,2,'instext',4,'',6,'','','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,1,0,6,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(135,10,'HI0200',4,'',6,'','','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,6,6,'3','','','','','',0,'','','',1,0,0,0,'0,0,0<|><|>','',0,0,0,0,0,0,0,0,0,100,'',1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(136,15,'HI0210',4,'',6,'','','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,6,6,'3','','','','','',0,'','','',1,0,0,0,'0,0,0<|><|>','',0,0,0,0,0,0,0,0,0,100,'',1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(137,19,'HI0230',4,'',6,'','','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,6,6,'3','','','','','',0,'','','',1,0,0,0,'0,0,0<|><|>','',0,0,0,0,0,0,0,0,0,100,'',1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(138,6,'HI0220',4,'',6,'','','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,6,6,'3','','','','','',0,'','','',1,0,0,0,'0,0,0<|><|>','',0,0,0,0,0,0,0,0,0,100,'',1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(139,21,'HI0300',1,'',1,'','','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,5,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(140,22,'HI0310',4,'',6,'','$HI0300 == 1','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,6,6,'3','','','','','',0,'','','',1,0,0,0,'0,0,0<|><|>','',0,0,0,0,0,0,0,0,0,100,'',1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(141,24,'AHI0410',1,'',1,'','','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,5,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(142,25,'AHI0420',4,'',6,'','$AHI0410 == 1','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,6,6,'3','','','','','',0,'','','',1,0,0,0,'0,0,0<|><|>','',0,0,0,0,0,0,0,0,0,100,'',1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(143,26,'HI0500',1,'',1,'','','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,5,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(144,27,'HI0600',1,'',1,'','','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,5,0,'','','','','','',0,'','','',1,0,0,0,'0,0,0,0,0<|><|>','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,'text,text,text,text,text','null','',0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(145,28,'HI0700',2,'',1,'','$HI0600 == 1','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,1,4,0,'7','','','','','',0,'','','',1,0,0,0,'0,0,0,0,0,0,0,0,0<|><|>','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(146,29,'AHI0710',4,'',6,'','','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,6,6,'3','','','','','',0,'','','',1,0,0,0,'0,0,0<|><|>','',0,0,0,0,0,0,0,0,0,100,'',1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(147,36,'AHI0610',1,'',1,'$AHI0610==3 && $AHI0610 == 6 && $AHI0610 == 7#HIZ040x','','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,5,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(148,37,'AHI0620',1,'',1,'','$AHI0610 != 3 &&  $AHI0610 != 6 &&  $AHI0610 != 7',' $AHI0620 != 1 || preg_match(\"/^\\d{1,2}(,\\d{1,3})?$/\",  $AHI0620_opn)',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,6,6,'1','','','','','',0,'','','',1,0,0,0,'0,0,0<|><|>','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,'text,text,text','null','',0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(150,39,'HI0800',1,'',1,'','','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,5,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(151,41,'AHI0400sr',1,'',1,'','max_answers(array($AHI0400_1,$AHI0400_2,$AHI0400_3,$AHI0400_4,$AHI0400_5,$AHI0400_6,$AHI0400_7,$AHI0400_8,$AHI0400_9,$AHI0400_10,$AHI0400_11,$AHI0400_12,$AHI0400_13,$AHI0400_14)) > 1','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,5,0,'','','','','','',0,'0$AHI0400_1 != 1<!>0$AHI0400_2 != 2<!>0$AHI0400_3 != 3<!>0$AHI0400_4 != 4<!>0$AHI0400_5 != 5<!>0$AHI0400_6 != 6<!>0$AHI0400_7 != 7<!>0$AHI0400_8 != 8<!>0$AHI0400_9 != 9<!>0$AHI0400_10 != 10<!>0$AHI0400_11 != 11<!>0$AHI0400_12 != 12<!>0$AHI0400_13 != 13<!>0$AHI0400_14 != 14<!>0<!>0','','',1,0,0,0,'0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0<|><|>','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,'text,text,text,text,text,text,text,text,text,text,text,text,text,text,text,text','null','',0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(152,42,'AZT0220',6,'',0,'','','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,1,0,9,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(153,40,'AHI0400',3,'',4,'','','',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'14','','','15,16','','',0,'','','',1,0,0,0,'0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0<|><|>','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,'text,text,text,text,text,text,text,text,text,text,text,text,text,text,text,text','null','',0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(154,4,'hfcs01xdummy',4,'',6,'','$hfcs01xdummy_1 == NULL','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,0,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(155,5,'einxKonsum',1,'',1,'','','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(156,7,'HI0100',4,'',6,'','','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,6,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(158,38,'HIZ040x',1,'',1,'','','$HIZ040x != 1 || ( $HIZ040x_opn >= 0 && $HIZ040x_opn <= 100 && preg_match(\"/^\\d{1,3}(,\\d{1,2})?$/\",  $HIZ040x_opn))',0,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'1','','','','','',0,'','','',1,0,0,0,'0,0,0<|><|>','',9,0,0,0,0,0,0,0,0,100,'',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,'range,text,text','{\"1\":[],\"0\":{\"max\":\"100\",\"min\":\"0\"}}','',0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(159,-3,'_Repeal',5,NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,0,4,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,1,0,0,0,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,100,NULL,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,0,200,1,NULL,'0',NULL,1000),(160,8,'sc8HI0100',1,'',1,' $sc8HI0100 ==2#sc8HI0100','checkBetrag(getEuro(\"HI0100\"),3000)','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(161,9,'sc9HI0100',1,'',1,' $sc9HI0100 ==2#sc9HI0100','checkBetrag(getEuro(\"HI0100\"),0,20)','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(162,11,'sc10HI0200',1,'',1,' $sc10HI0200 ==2#sc10HI0200','checkBetrag(getEuro(\"HI0200\"),3000)','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(163,12,'sc11HI0200',1,'',1,' $sc11HI0200 ==2#sc11HI0200','checkBetrag(getEuro(\"HI0100\")+getEuro(\"HI0200\"),3000)','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(164,13,'sc12HI0200',1,'',1,' $sc12HI0200 ==2#sc12HI0200','getEuro(\"HI0100\")+getEuro(\"HI0200\")==getEuro(\"HI0220\") && getEuro(\"HI0220\")','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(165,14,'sc13HI0200',1,'',1,' $sc13HI0200 ==2#sc13HI0200','getEuro(\"HI0100\")+getEuro(\"HI0200\")>getEuro(\"HI0220\") && getEuro(\"HI0220\")','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(166,16,'sc14HI0210',1,'',1,' $sc14HI0210 ==2#sc14HI0210','checkBetrag(getEuro(\"HI0210\"),0,20)','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(167,17,'sc15HI0210',1,'',1,' $sc15HI0210 ==2#sc15HI0210','checkBetrag(getEuro(\"HI0210\"),3000)','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(168,18,'sc16HI0210',1,'',1,'$sc16HI0210==2#sc16HI0210','getEuro(\"HI0100\")+getEuro(\"HI0200\")+getEuro(\"HI0210\")>getEuro(\"HI0220\") && getEuro(\"HI0220\")','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(169,20,'sc17HI0230',1,'',1,'$sc17HI0230==2#sc17HI0230','checkBetrag(getEuro(\"HI0230\"),20000)','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(170,23,'sc19HI0310',1,'',1,'$sc19HI0310==2#sc19HI0310','checkBetrag(getEuro(\"HI0310\"),5000)','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(171,30,'sc20AHI0710',1,'',1,'$sc20AHI0710==2#sc20AHI0710','checkBetrag(getEuro(\"AHI0710\"),0,300)','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(172,31,'sc21AHI0710',1,'',1,'$sc21AHI0710==2#sc21AHI0710','getEuro(\"AHI0710\")&&getEuro(\"HI0100\")&&getEuro(\"AHI0710\")<getEuro(\"HI0100\")','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(173,32,'sc22AHI0710',1,'',1,'$sc22AHI0710==2#sc22AHI0710','getEuro(\"AHI0710\")&&getEuro(\"HI0200\")&&getEuro(\"AHI0710\")<getEuro(\"HI0200\")','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(174,33,'sc23AHI0710',1,'',1,'$sc23AHI0710==2#sc23AHI0710','getEuro(\"HI0310\") && getEuro(\"AHI0710\") && getEuro(\"AHI0710\")<getEuro(\"HI0310\")','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(175,34,'sc24AHI0710',1,'',1,'$sc24AHI0710==2#sc24AHI0710','getEuro(\"AHI0710\") && getEuro(\"HI0310\") && getEuro(\"AHI0710\") < getEuro(\"HI0310\")','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,1,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000),(176,35,'sc25AHI0710',1,'',1,'$sc25AHI0710==2#sc25AHI0710','getEuro(\"AHI0710\") && (getEuro(\"HI0220\")+getEuro(\"HI0310\")) > getEuro(\"AHI0710\")','',1,0,0,0,'',0,0,0,0,0,0,'',0,0,1,0,0,4,0,'','','','','','',0,'','','',1,0,0,0,'','',0,0,0,0,0,0,0,0,0,100,'',1,1,'','','','',0,0,0,1,0,0,'','','',0,'',0,'',0,0,200,1,'','0',0,1000);
/*!40000 ALTER TABLE `HFCS03_Konsum` 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:09
