
<stat>DROP TABLE IF EXISTS pTestQuest1; 
<stat>DROP TABLE IF EXISTS pTestQuest1_language; 
<stat>DROP TABLE IF EXISTS pTestQuest1_script; 
<stat>DROP TABLE IF EXISTS pTestQuest1_tree; 
<stat>CREATE TABLE `pTestQuest1` (
  `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',
  `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',
  `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,
  `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 '0',
  `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 1 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=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
<stat>CREATE TABLE `pTestQuest1_language` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_language` int(11) NOT NULL,
  `id_question` int(11) NOT NULL,
  `id_text_type` int(11) NOT NULL,
  `lngText` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `qlt_index` (`id_language`,`id_question`,`id_text_type`),
  KEY `id_question` (`id_question`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
<stat>CREATE TABLE `pTestQuest1_script` (
  `id_question` int(11) NOT NULL,
  `id_event` int(11) NOT NULL,
  `script` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_question`,`id_event`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
<stat>CREATE TABLE `pTestQuest1_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=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
<stat>INSERT INTO pTestQuest1 SET id = '1',q_pos = '-6',q_name = '_Start',tip_sql = '5',drg_sql = '',les_sql = '',goto_sql = 'true#1',fil_sql = '',con_sql = '',open_sql = '',anno_sql = '',attachAnswers = '',attachFalse = '',rot_sql = '',srot_sql = '',erot_sql = '',srotLegend = '',erotLegend = '',srotAttributes = '',erotAttributes = '',qrot_sql = '',id_style = '',id_mask = '',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '',id_incentive = '',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',custom_controls = '',rec_question_id = '0',rec_interval = '',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO pTestQuest1 SET id = '2',q_pos = '-5',q_name = '_End',tip_sql = '5',drg_sql = '',les_sql = '',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '',anno_sql = '',attachAnswers = '',attachFalse = '',rot_sql = '',srot_sql = '',erot_sql = '',srotLegend = '',erotLegend = '',srotAttributes = '',erotAttributes = '',qrot_sql = '',id_style = '',id_mask = '',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '',id_incentive = '',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',custom_controls = '',rec_question_id = '0',rec_interval = '',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO pTestQuest1 SET id = '3',q_pos = '-15',q_name = '_notAllow',tip_sql = '5',drg_sql = '',les_sql = '',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '',anno_sql = '',attachAnswers = '',attachFalse = '',rot_sql = '',srot_sql = '',erot_sql = '',srotLegend = '',erotLegend = '',srotAttributes = '',erotAttributes = '',qrot_sql = '',id_style = '',id_mask = '',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '',id_incentive = '',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',custom_controls = '',rec_question_id = '0',rec_interval = '',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO pTestQuest1 SET id = '4',q_pos = '-16',q_name = '_notActive',tip_sql = '5',drg_sql = '',les_sql = '',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '',anno_sql = '',attachAnswers = '',attachFalse = '',rot_sql = '',srot_sql = '',erot_sql = '',srotLegend = '',erotLegend = '',srotAttributes = '',erotAttributes = '',qrot_sql = '',id_style = '',id_mask = '',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '',id_incentive = '',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',custom_controls = '',rec_question_id = '0',rec_interval = '',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO pTestQuest1 SET id = '5',q_pos = '-3',q_name = '_Repeal',tip_sql = '5',drg_sql = '',les_sql = '',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '',anno_sql = '',attachAnswers = '',attachFalse = '',rot_sql = '',srot_sql = '',erot_sql = '',srotLegend = '',erotLegend = '',srotAttributes = '',erotAttributes = '',qrot_sql = '',id_style = '',id_mask = '',must_answer = '1',disable_question = '1',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '1',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '',id_incentive = '',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',custom_controls = '',rec_question_id = '0',rec_interval = '',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO pTestQuest1 SET id = '6',q_pos = '1',q_name = 'f1',tip_sql = '1',drg_sql = '',les_sql = '1',goto_sql = '',fil_sql = '',con_sql = '',open_sql = '1',anno_sql = '',attachAnswers = '',attachFalse = '',rot_sql = '',srot_sql = '',erot_sql = '',srotLegend = '',erotLegend = '',srotAttributes = '',erotAttributes = '',qrot_sql = '',id_style = '',id_mask = '',must_answer = '1',disable_question = '0',answers_filter = '0',variableTypeBase = '4',variableTypeOpen = '0',open_answers = '',open_legend = '',open_attributes = '',multi_nogo_answers = '',multi_nogo_legends = '',multilanguage_all = '',qleave_js_alert = '0',filter_answer = '',filter_legend = '',filter_attributes = '',hasStructure = '0',use_for_quotas = '0',isFinal = '0',id_showTogether = '0',answerGroups = '',legendGroups = '',id_plugin = '',id_incentive = '',incentive_possibilites = '0',allow_listening = '0',old_id = '0',up_down_rotchk = '0',up_down_rotvar = '0',repeat_legend = '0',autoSubmit = '0',autoSubmitTimeout = '100',missing_values = '',open_end_type = '1',enter_submit = '1',slider_color = '',trace_color = '',slider_shape = '',slider_handle_image = '',email_app_group = '',email_app_template = '',encrypt = '',multi_type = '1',custom_controls = '',rec_question_id = '0',rec_interval = '',rotate_legend = '0',anonymize = '0',input_types = '',input_types_properties = '',show_as_single = '0',show_as_single_cond = '',show_as_single_design = '0',show_as_single_autosubmit = '0',show_as_single_autosubmit_delay = '200',input_position = '1',after_text = '',answer_click_animation = '0',answer_click_element = '',answer_click_animation_duration = '1000';
<stat>INSERT INTO pTestQuest1_language SET id = '1',id_language = '60',id_question = '1',id_text_type = '2',lngText = 'Welcome text';
<stat>INSERT INTO pTestQuest1_language SET id = '2',id_language = '60',id_question = '2',id_text_type = '2',lngText = 'Questionnaire finished';
<stat>INSERT INTO pTestQuest1_language SET id = '3',id_language = '60',id_question = '3',id_text_type = '2',lngText = 'Thank you for participating in this survey!';
<stat>INSERT INTO pTestQuest1_language SET id = '4',id_language = '60',id_question = '4',id_text_type = '2',lngText = 'This survey is not active!';
<stat>INSERT INTO pTestQuest1_language SET id = '5',id_language = '60',id_question = '5',id_text_type = '2',lngText = 'Repeal';
<stat>INSERT INTO pTestQuest1_language SET id = '6',id_language = '60',id_question = '6',id_text_type = '2',lngText = 'Frage 1';
<stat>INSERT INTO pTestQuest1_language SET id = '7',id_language = '60',id_question = '6',id_text_type = '3',lngText = '1 ja/2 nein';
<stat>INSERT INTO pTestQuest1_tree SET id = '6',id_sup = '0',id_question = '6',orderBy = '1',idLab = 'f1',node_img = '',is_leaf = '1',showTogether = '0';