
<stat>#BACKUP HFCS11_Einschaetzung_structure ;
<stat>DROP TABLE IF EXISTS HFCS11_Einschaetzung_structure;
<stat>DROP TABLE IF EXISTS HFCS11_Einschaetzung___EngineLog;
<stat>DELETE FROM  _www_interviewer_statistics WHERE id_project = 13;
<stat>CREATE TABLE `HFCS11_Einschaetzung_structure` (
  `id` int(7) NOT NULL AUTO_INCREMENT,
  `id_clien` int(5) DEFAULT NULL,
  `flag_cli` int(1) DEFAULT NULL,
  `user_id` int(5) DEFAULT NULL,
  `user_type` tinyint(4) DEFAULT NULL,
  `id_loginSID` int(11) DEFAULT NULL,
  `id_device` tinyint(4) DEFAULT NULL,
  `id_language` tinyint(3) unsigned DEFAULT NULL,
  `smpl_var` int(1) DEFAULT NULL,
  `sp_adult` int(1) DEFAULT NULL,
  `sp_man` int(1) DEFAULT NULL,
  `id_site` char(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(8) DEFAULT NULL,
  `status_rec` int(8) DEFAULT NULL,
  `flag_bad` int(3) NOT NULL DEFAULT '99',
  `t_status` int(11) unsigned DEFAULT NULL,
  `t_start` int(11) unsigned DEFAULT NULL,
  `t_stop` int(11) unsigned DEFAULT NULL,
  `d_status` datetime DEFAULT NULL,
  `d_start` datetime DEFAULT NULL,
  `d_stop` datetime DEFAULT NULL,
  `t_pause` int(11) NOT NULL DEFAULT '0',
  `t_diffs` int(10) NOT NULL DEFAULT '0',
  `QT_user_id` int(5) DEFAULT NULL,
  `questtext_1` text COLLATE utf8_unicode_ci,
  `instext_1` text COLLATE utf8_unicode_ci,
  `dtxtvars_1` text COLLATE utf8_unicode_ci,
  `hfcs01xdummy_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hfcs01xdummy_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hfcs01xdummy_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hfcs01xdummy_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AZT0310` datetime DEFAULT NULL,
  `AHAein` int(10) DEFAULT NULL,
  `AHA0500` int(10) DEFAULT NULL,
  `AHA0770` int(10) DEFAULT NULL,
  `AHA0770_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AHA1010_1` int(10) DEFAULT NULL,
  `AHA1010_2` int(10) DEFAULT NULL,
  `AHA1010_3` int(10) DEFAULT NULL,
  `AHA1010_4` int(10) DEFAULT NULL,
  `AHA1010_5` int(10) DEFAULT NULL,
  `AHA1010_6` int(10) DEFAULT NULL,
  `AHA1010_7` int(10) DEFAULT NULL,
  `AHA1010_8` int(10) DEFAULT NULL,
  `AHA1010_9` int(10) DEFAULT NULL,
  `AHA1010_opn7` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AHA1410_1` int(10) DEFAULT NULL,
  `AHA1410_2` int(10) DEFAULT NULL,
  `AHA1410_3` int(10) DEFAULT NULL,
  `AHA1410_4` int(10) DEFAULT NULL,
  `AHA1410_5` int(10) DEFAULT NULL,
  `AHA1410_6` int(10) DEFAULT NULL,
  `AHA1410_7` int(10) DEFAULT NULL,
  `AHA1410_opn1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AHA1410_opn2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AHA1410_opn3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AHA1410_opn4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AHA1410_opn5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AHA1420` int(10) DEFAULT NULL,
  `AHA0800` int(10) DEFAULT NULL,
  `AHA1310` int(10) DEFAULT NULL,
  `AHA1310_opn` text COLLATE utf8_unicode_ci,
  `AHA1210_1` int(10) DEFAULT NULL,
  `AHA1210_2` int(10) DEFAULT NULL,
  `AHA1210_3` int(10) DEFAULT NULL,
  `AHA1210_4` int(10) DEFAULT NULL,
  `AHA1210_5` int(10) DEFAULT NULL,
  `AHA1210_6` int(10) DEFAULT NULL,
  `AHA1210_7` int(10) DEFAULT NULL,
  `AHA1210_8` int(10) DEFAULT NULL,
  `AHA1210_9` int(10) DEFAULT NULL,
  `AHA1210_opn7` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AHA1210sr` int(10) DEFAULT NULL,
  `AHA1100` int(10) DEFAULT NULL,
  `NW0001_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NW0002_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NW0003_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Treatment` int(10) DEFAULT NULL,
  `AHA1220` int(10) DEFAULT NULL,
  `AHA1230` int(10) DEFAULT NULL,
  `AZT0320` datetime DEFAULT NULL,
  `AHP0100_1` text COLLATE utf8_unicode_ci,
  `HP0200_1` text COLLATE utf8_unicode_ci,
  `AHP0300_1` text COLLATE utf8_unicode_ci,
  `AZT0330` datetime DEFAULT NULL,
  `THANKYOU` int(10) DEFAULT NULL,
  `ENDIV` int(10) DEFAULT NULL,
  `EV_id_record` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dsgvo1` int(10) DEFAULT NULL,
  `dsgvo2_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dsgvo2_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dsgvo2_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `structureid_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `source_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `source_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `source_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `source_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `resp_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `resp_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `resp_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `resp_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `resp_5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `iv_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `iv_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `iv_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `formdata_1` text COLLATE utf8_unicode_ci,
  `checkq` int(10) DEFAULT NULL,
  `checkdummy` int(10) DEFAULT NULL,
  `CoronaTS` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id_type` (`user_id`,`user_type`),
  KEY `status` (`status`,`status_rec`),
  KEY `id_device` (`id_device`),
  KEY `id_language` (`id_language`),
  KEY `flag_bad` (`flag_bad`),
  KEY `id_site` (`id_site`(5)),
  KEY `id_loginSID` (`id_loginSID`),
  KEY `sp_man` (`sp_man`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
<stat>CREATE TABLE `HFCS11_Einschaetzung___EngineLog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_structure` int(11) NOT NULL,
  `id_question` smallint(6) NOT NULL,
  `id_user` int(11) NOT NULL,
  `user_type` tinyint(4) NOT NULL,
  `id_language` smallint(6) DEFAULT NULL,
  `q_name` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `currentRotationString` text COLLATE utf8_unicode_ci NOT NULL,
  `questionnairePath` text COLLATE utf8_unicode_ci NOT NULL,
  `engineTime` int(11) NOT NULL,
  `questStart` int(11) DEFAULT NULL,
  `questEnd` int(11) DEFAULT NULL,
  `arriveStatus` tinyint(4) DEFAULT NULL,
  `eventLogger` text COLLATE utf8_unicode_ci,
  `activeRecord` tinyint(1) NOT NULL,
  `browser_type_id` smallint(6) NOT NULL,
  `device_name_id` smallint(6) NOT NULL,
  `device_property_id` smallint(6) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_structure` (`id_structure`),
  KEY `id_user_user_type_activeRecord` (`id_user`,`user_type`,`activeRecord`),
  KEY `browser_type_id` (`browser_type_id`),
  KEY `device_name_id` (`device_name_id`),
  KEY `device_property_id` (`device_property_id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
<stat>REPLACE INTO _Projects SET id = '13',key_proj = '13-l886giolh3',proj_name = 'HFCS11_Einschaetzung',language = '60',naziv_proj = '_',old = 'N',created = '25.10.2019 - 13:42',creat_name = 'Administrator ',modify = '25.10.2019 - 13:42',modi_name = 'Administrator ',active = '1',start_date = '2019-10-25 00:00:00',end_date = '2021-10-08 00:00:00',print_filter = '1',print_jump = '1',print_condition = '1',print_answfilter = '1',print_hidden_question = '1',stat_show_var = '1',stat_show_val = '1',lock_app_to_user = '0',rotation = 'N',regionopt = '0',hide_back_button = '0',id_telname = '',tel_reserve = '0',id_capiTable = '0',capi_reserve = '0',qt_useregtel = '0',qt_useactel = '0',reg_strictlock = '0',stat_show_scaleborder = '0',busy_call_delay = '20',noanswer_call_delay = '120',callback_call_delay = '5',num_max_call = '3',num_max_call_app = '99',back_delete = '0',set_use_autodial = '0',quota_vars = '',telselect = '0',proj_backup = '',strictlock_manual = '0',ml_showopt_www = '1',ml_position_www = '2',ml_html_www = '',forward_button_link = '',back_button_link = '',exit_button_link = '',help_button_link = '',quest_distance_buttons = '0',submit_where = '0',submit_auto = '0',question_over = '0',user_status_bar = '',radio_button_enable = '',radio_button_disable = '',chk_button_enable = '',chk_button_disable = '',use_img_radio = '0',submit_delay_press = '1',exit_alert_msg = 'Are you sure?',forward_button_disable_link = '',back_button_disable_link = '',error_img_scale = '',start_quest_button_link = '',quest_start_alert_msg = 'Are you sure?',intstat_opt = '',webcapi_clear_all = '0',webcapi_clear_finished = '0',webcapi_finished = '0',use_special_sampling = '0',wh_special_sampling = '',disablebasic = '0',call_time_length = '25',use_predictive = '0',predictive_work = '0',ma_remove_arrows = '0',ma_row_color = '',predictive_numbers_tofind = '0',predictive_overcall = '0',isTemplate = '0',id_select_layer = '0',redirectActive = '0',redirectConditions = '',interview_show_variable = '1',interview_show_ans_value = '0',has_user_quotas = '0',respondent_searched_fields = '',telnum_select_type = '1',use_lowest = '0',use_lowest_layer = '',is_nfield = '0',id_nfield_project = '',name_nfield_project = '',stat_show_filter_in = '0',stat_show_filter_out = '0',stat_show_goto = '0',stat_show_answer_filter = '0',stat_show_question_type = '0',stat_show_open_end_type = '0',limit_interviews = '0',number_of_interviews = '0',check_for_quota = '1',submit_on_enter = '1',survey_image = '',onboarding = '',browser_title = '',custom_fields = '',show_app_button = '1',show_src_tel_number = '1',display_tel_char_limit = '',structure_tel_char_limit = '',manual_dial_layers = '',anonymization_datetime = '',anonymization_user = '',anonymization_fields = '',report_file = '',show_apart_on_mobile = '0';
<stat>REPLACE INTO _ProjectsTree SET id = '13',id_sup = '18',id_project = '13',orderBy = '0',idLab = 'HFCS11_Einschaetzung',node_img = '',is_leaf = '1',merged = '0';
<stat>REPLACE INTO _ProjectsTree SET id = '18',id_sup = '0',id_project = '0',orderBy = '1',idLab = 'HFCS',node_img = '',is_leaf = '0',merged = '0';
<stat>DELETE FROM  _LanguageProjects WHERE id_project = 13;
<stat>DELETE FROM  _LanguageUserInterface WHERE id_project IN (0, 13);
<stat>DELETE FROM  _QuestionRotation WHERE id_project = 13;
<stat>DELETE FROM  _ProjectExtraVariables  WHERE id_project = 13;
<stat>INSERT INTO _ProjectExtraVariables  SET id = '10',id_project = '13',var_name = 'id_record',var_type = '0',anonymize = '0';
<stat>INSERT INTO _LanguageProjects  SET id_language = '60',id_project = '13';
<stat>INSERT INTO _LanguageUserInterface SET id = '1',id_language = '60',id_text_type = '40',id_project = '13',id_question = '162',lngText = 'Verteilen Sie genau 100 Punkte!';