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

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

--
-- Dumping data for table `HFCS99_Kommentar`
--

LOCK TABLES `HFCS99_Kommentar` WRITE;
/*!40000 ALTER TABLE `HFCS99_Kommentar` DISABLE KEYS */;
INSERT INTO `HFCS99_Kommentar` 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,4,'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,6,'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,7,'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,5,'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),(134,2,'comment',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,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,1,'quest',4,'',6,'','','',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),(136,3,'idRecord',4,'',6,'','','',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),(137,-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,0,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);
/*!40000 ALTER TABLE `HFCS99_Kommentar` 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
