
<stat>CREATE TABLE `HFCS01_Screener_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,
  `dtxtvars_1` text COLLATE utf8_unicode_ci,
  `dtxtvars_2` text COLLATE utf8_unicode_ci,
  `dtxtvars_3` text COLLATE utf8_unicode_ci,
  `AHNB0100` tinyint(3) DEFAULT NULL,
  `AZT0100` datetime DEFAULT NULL,
  `AHL0110` tinyint(3) DEFAULT NULL,
  `AHL0120` tinyint(3) DEFAULT NULL,
  `AHL0121` tinyint(3) DEFAULT NULL,
  `AHL0130` tinyint(3) DEFAULT NULL,
  `AHL0130_opn` text COLLATE utf8_unicode_ci,
  `AHL0140` tinyint(3) DEFAULT NULL,
  `AHL0140_opn` text COLLATE utf8_unicode_ci,
  `hlEin` tinyint(3) DEFAULT NULL,
  `AHL0210_1` int(10) DEFAULT NULL,
  `refPers_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA000x1_1` text COLLATE utf8_unicode_ci,
  `RA020x1` tinyint(3) DEFAULT NULL,
  `RA030x1` tinyint(3) DEFAULT NULL,
  `RA010x1` tinyint(3) DEFAULT NULL,
  `ARA091x1` tinyint(3) DEFAULT NULL,
  `ARA092x1` tinyint(3) DEFAULT NULL,
  `RA000x2_1` text COLLATE utf8_unicode_ci,
  `RA020x2` tinyint(3) DEFAULT NULL,
  `RA030x2` tinyint(3) DEFAULT NULL,
  `RA010x2` tinyint(3) DEFAULT NULL,
  `ARA091x2` tinyint(3) DEFAULT NULL,
  `ARA092x2` tinyint(3) DEFAULT NULL,
  `RA000x3_1` text COLLATE utf8_unicode_ci,
  `RA020x3` tinyint(3) DEFAULT NULL,
  `RA030x3` tinyint(3) DEFAULT NULL,
  `RA010x3` tinyint(3) DEFAULT NULL,
  `ARA091x3` tinyint(3) DEFAULT NULL,
  `ARA092x3` tinyint(3) DEFAULT NULL,
  `RA000x4_1` text COLLATE utf8_unicode_ci,
  `RA020x4` tinyint(3) DEFAULT NULL,
  `RA030x4` tinyint(3) DEFAULT NULL,
  `RA010x4` tinyint(3) DEFAULT NULL,
  `ARA091x4` tinyint(3) DEFAULT NULL,
  `ARA092x4` tinyint(3) DEFAULT NULL,
  `RA000x5_1` text COLLATE utf8_unicode_ci,
  `RA020x5` tinyint(3) DEFAULT NULL,
  `RA030x5` tinyint(3) DEFAULT NULL,
  `RA010x5` tinyint(3) DEFAULT NULL,
  `ARA091x5` tinyint(3) DEFAULT NULL,
  `ARA092x5` tinyint(3) DEFAULT NULL,
  `RA000x6_1` text COLLATE utf8_unicode_ci,
  `RA020x6` tinyint(3) DEFAULT NULL,
  `RA030x6` tinyint(3) DEFAULT NULL,
  `RA010x6` tinyint(3) DEFAULT NULL,
  `ARA091x6` tinyint(3) DEFAULT NULL,
  `ARA092x6` tinyint(3) DEFAULT NULL,
  `RA000x7_1` text COLLATE utf8_unicode_ci,
  `RA020x7` tinyint(3) DEFAULT NULL,
  `RA030x7` tinyint(3) DEFAULT NULL,
  `RA010x7` tinyint(3) DEFAULT NULL,
  `ARA091x7` tinyint(3) DEFAULT NULL,
  `ARA092x7` tinyint(3) DEFAULT NULL,
  `RA000x8_1` text COLLATE utf8_unicode_ci,
  `RA020x8` tinyint(3) DEFAULT NULL,
  `RA030x8` tinyint(3) DEFAULT NULL,
  `RA010x8` tinyint(3) DEFAULT NULL,
  `ARA092x8` tinyint(3) DEFAULT NULL,
  `ARA091x8` tinyint(3) DEFAULT NULL,
  `RA000x9_1` text COLLATE utf8_unicode_ci,
  `RA020x9` tinyint(3) DEFAULT NULL,
  `RA030x9` tinyint(3) DEFAULT NULL,
  `RA010x9` tinyint(3) DEFAULT NULL,
  `ARA091x9` tinyint(3) DEFAULT NULL,
  `ARA092x9` tinyint(3) DEFAULT NULL,
  `RA000x10_1` text COLLATE utf8_unicode_ci,
  `RA020x10` tinyint(3) DEFAULT NULL,
  `RA030x10` tinyint(3) DEFAULT NULL,
  `RA010x10` tinyint(3) DEFAULT NULL,
  `ARA091x10` tinyint(3) DEFAULT NULL,
  `ARA092x10` tinyint(3) DEFAULT NULL,
  `RA000x11_1` text COLLATE utf8_unicode_ci,
  `RA020x11` tinyint(3) DEFAULT NULL,
  `RA030x11` tinyint(3) DEFAULT NULL,
  `RA010x11` tinyint(3) DEFAULT NULL,
  `ARA091x11` tinyint(3) DEFAULT NULL,
  `ARA092x11` tinyint(3) DEFAULT NULL,
  `RA000x12_1` text COLLATE utf8_unicode_ci,
  `RA020x12` tinyint(3) DEFAULT NULL,
  `RA030x12` tinyint(3) DEFAULT NULL,
  `RA010x12` tinyint(3) DEFAULT NULL,
  `ARA091x12` tinyint(3) DEFAULT NULL,
  `ARA092x12` tinyint(3) DEFAULT NULL,
  `RA000x13_1` text COLLATE utf8_unicode_ci,
  `RA020x13` tinyint(3) DEFAULT NULL,
  `RA030x13` tinyint(3) DEFAULT NULL,
  `RA010x13` tinyint(3) DEFAULT NULL,
  `ARA091x13` tinyint(3) DEFAULT NULL,
  `ARA092x13` tinyint(3) DEFAULT NULL,
  `RA000x14_1` text COLLATE utf8_unicode_ci,
  `RA020x14` tinyint(3) DEFAULT NULL,
  `RA030x14` tinyint(3) DEFAULT NULL,
  `RA010x14` tinyint(3) DEFAULT NULL,
  `ARA091x14` tinyint(3) DEFAULT NULL,
  `ARA092x14` tinyint(3) DEFAULT NULL,
  `RA000x15_1` text COLLATE utf8_unicode_ci,
  `RA020x15` tinyint(3) DEFAULT NULL,
  `RA030x15` tinyint(3) DEFAULT NULL,
  `RA010x15` tinyint(3) DEFAULT NULL,
  `ARA091x15` tinyint(3) DEFAULT NULL,
  `ARA092x15` tinyint(3) DEFAULT NULL,
  `dumPers_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_6` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_7` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_8` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_9` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_10` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_11` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_12` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_13` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_14` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_15` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AHL0220` tinyint(3) DEFAULT NULL,
  `AHL0230` tinyint(3) DEFAULT NULL,
  `AHL0240_1` int(10) DEFAULT NULL,
  `AHL0250` tinyint(3) DEFAULT NULL,
  `ARA0930` tinyint(3) DEFAULT NULL,
  `ARA0940_1` tinyint(3) DEFAULT NULL,
  `ARA0940_2` tinyint(3) DEFAULT NULL,
  `ARA0940_3` tinyint(3) DEFAULT NULL,
  `ARA0940_4` tinyint(3) DEFAULT NULL,
  `ARA0940_5` tinyint(3) DEFAULT NULL,
  `ARA0940_6` tinyint(3) DEFAULT NULL,
  `ARA0940_7` tinyint(3) DEFAULT NULL,
  `ARA0940_8` tinyint(3) DEFAULT NULL,
  `ARA0940_9` tinyint(3) DEFAULT NULL,
  `ARA0940_10` tinyint(3) DEFAULT NULL,
  `ARA0940_11` tinyint(3) DEFAULT NULL,
  `ARA0940_12` tinyint(3) DEFAULT NULL,
  `ARA0940_13` tinyint(3) DEFAULT NULL,
  `ARA0940_14` tinyint(3) DEFAULT NULL,
  `ARA0940_15` tinyint(3) DEFAULT NULL,
  `dumPersFinal_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinal_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinal_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinal_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinal_5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinal_6` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinal_7` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinal_8` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinal_9` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinal_10` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinal_11` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinal_12` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinal_13` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinal_14` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinal_15` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AHL0260` tinyint(3) DEFAULT NULL,
  `dumPersFinalJs_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinalJs_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinalJs_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinalJs_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinalJs_5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinalJs_6` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinalJs_7` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinalJs_8` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinalJs_9` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinalJs_10` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinalJs_11` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinalJs_12` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinalJs_13` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinalJs_14` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPersFinalJs_15` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AZT0110` datetime DEFAULT NULL,
  `linkxScreener` int(10) DEFAULT NULL,
  `ENDIV` int(10) DEFAULT NULL,
  `EV_id_record` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `scRA0300` int(10) 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=38 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
<stat>CREATE TABLE `HFCS01_Screener___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=618 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 0, 3, -5, 0, 'ed824f6d6d8183a', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 3, 0, -5, 0, '0e37eb3efb5fa3e', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 4, 0, -5, 0, '105e2a355d4c57a', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 5, 0, -5, 0, 'c79083f1d90b7e0', 0);
<stat>DELETE FROM _www_ids WHERE id_user>0 AND user_type=0 AND id_project=5 AND id_site=0 AND id_user NOT IN (SELECT * FROM (SELECT id_user FROM `_www_ids` WHERE id_user>0 AND user_type=0 AND id_site=0 AND id_project=-5) AS p );
<stat>UPDATE IGNORE `_www_ids` SET `id_project`=ABS(`id_project`), `loginSID` = CONCAT(`loginSID`,'-',`id`) WHERE `id_project`<0;
<stat>DELETE FROM `_www_ids` WHERE `id_project`<0;
<stat>REPLACE INTO _Projects SET id = '5',key_proj = '5-lxg4kqojj2',proj_name = 'HFCS01_Screener',language = '60',naziv_proj = '',old = 'N',created = '25.10.2019 - 08:10',creat_name = 'Administrator ',modify = '25.10.2019 - 08:10',modi_name = 'Administrator ',active = '1',start_date = '2019-10-25 00:00:00',end_date = '2020-10-25 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 = '1',stat_show_filter_out = '1',stat_show_goto = '1',stat_show_answer_filter = '1',stat_show_question_type = '1',stat_show_open_end_type = '1',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 = '4',id_sup = '18',id_project = '4',orderBy = '0',idLab = 'HFCS00_Base',node_img = '',is_leaf = '1',merged = '0';
<stat>REPLACE INTO _ProjectsTree SET id = '5',id_sup = '18',id_project = '5',orderBy = '0',idLab = 'HFCS01_Screener',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 = 5;
<stat>DELETE FROM  _LanguageUserInterface WHERE id_project IN (0, 5);
<stat>DELETE FROM  _QuestionRotation WHERE id_project = 5;
<stat>DELETE FROM  _ProjectExtraVariables  WHERE id_project = 5;
<stat>INSERT INTO _ProjectExtraVariables  SET id = '1',id_project = '5',var_name = 'id_record',var_type = '0',anonymize = '0';
<stat>INSERT INTO _LanguageProjects  SET id_language = '60',id_project = '5';
<stat>CREATE TABLE `HFCS02_Merkmale_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,
  `dtxtvars_2` text COLLATE utf8_unicode_ci,
  `dtxtvars_3` text COLLATE utf8_unicode_ci,
  `dumPers_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_6` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_7` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_8` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_9` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_10` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_11` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_12` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_13` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_14` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dumPers_15` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hfcs01xdummy_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hfcs01xdummy_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARein` tinyint(3) DEFAULT NULL,
  `ARA0400x1` tinyint(3) DEFAULT NULL,
  `ARA0400opx1` int(10) DEFAULT NULL,
  `ARA0400opx1_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x1` tinyint(3) DEFAULT NULL,
  `RA0500x1_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x1` tinyint(3) DEFAULT NULL,
  `APA0100x1` tinyint(3) DEFAULT NULL,
  `sc5APA0100x1` int(10) DEFAULT NULL,
  `sc6APA0100x1` int(10) DEFAULT NULL,
  `APA0200x1` tinyint(3) DEFAULT NULL,
  `APA0200x1_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x1` int(10) DEFAULT NULL,
  `APA0210x1` tinyint(3) DEFAULT NULL,
  `APA0210x1_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x1` tinyint(3) DEFAULT NULL,
  `APA0220x1_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARA0400x2` tinyint(3) DEFAULT NULL,
  `ARA0400opx2` int(10) DEFAULT NULL,
  `ARA0400opx2_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x2` tinyint(3) DEFAULT NULL,
  `RA0500x2_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x2` tinyint(3) DEFAULT NULL,
  `APA0100x2` tinyint(3) DEFAULT NULL,
  `sc5APA0100x2` int(10) DEFAULT NULL,
  `APA0200x2` tinyint(3) DEFAULT NULL,
  `APA0200x2_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x2` int(10) DEFAULT NULL,
  `APA0210x2` tinyint(3) DEFAULT NULL,
  `APA0210x2_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x2` tinyint(3) DEFAULT NULL,
  `APA0220x2_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARA0400x3` tinyint(3) DEFAULT NULL,
  `ARA0400opx3` int(10) DEFAULT NULL,
  `ARA0400opx3_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x3` tinyint(3) DEFAULT NULL,
  `RA0500x3_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x3` tinyint(3) DEFAULT NULL,
  `APA0100x3` tinyint(3) DEFAULT NULL,
  `sc5APA0100x3` int(10) DEFAULT NULL,
  `APA0200x3` tinyint(3) DEFAULT NULL,
  `APA0200x3_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x3` int(10) DEFAULT NULL,
  `APA0210x3` tinyint(3) DEFAULT NULL,
  `APA0210x3_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x3` tinyint(3) DEFAULT NULL,
  `APA0220x3_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARA0400x4` tinyint(3) DEFAULT NULL,
  `ARA0400opx4` int(10) DEFAULT NULL,
  `ARA0400opx4_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x4` tinyint(3) DEFAULT NULL,
  `RA0500x4_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x4` tinyint(3) DEFAULT NULL,
  `APA0100x4` tinyint(3) DEFAULT NULL,
  `sc5APA0100x4` int(10) DEFAULT NULL,
  `APA0200x4` tinyint(3) DEFAULT NULL,
  `APA0200x4_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x4` int(10) DEFAULT NULL,
  `APA0210x4` tinyint(3) DEFAULT NULL,
  `APA0210x4_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x4` tinyint(3) DEFAULT NULL,
  `APA0220x4_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARA0400x5` tinyint(3) DEFAULT NULL,
  `ARA0400opx5` int(10) DEFAULT NULL,
  `ARA0400opx5_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x5` tinyint(3) DEFAULT NULL,
  `RA0500x5_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x5` tinyint(3) DEFAULT NULL,
  `APA0100x5` tinyint(3) DEFAULT NULL,
  `sc5APA0100x5` int(10) DEFAULT NULL,
  `APA0200x5` tinyint(3) DEFAULT NULL,
  `APA0200x5_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x5` int(10) DEFAULT NULL,
  `APA0210x5` tinyint(3) DEFAULT NULL,
  `APA0210x5_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x5` tinyint(3) DEFAULT NULL,
  `APA0220x5_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARA0400x6` tinyint(3) DEFAULT NULL,
  `ARA0400opx6` int(10) DEFAULT NULL,
  `ARA0400opx6_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x6` tinyint(3) DEFAULT NULL,
  `RA0500x6_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x6` tinyint(3) DEFAULT NULL,
  `APA0100x6` tinyint(3) DEFAULT NULL,
  `sc5APA0100x6` int(10) DEFAULT NULL,
  `APA0200x6` tinyint(3) DEFAULT NULL,
  `APA0200x6_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x6` int(10) DEFAULT NULL,
  `APA0210x6` tinyint(3) DEFAULT NULL,
  `APA0210x6_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x6` tinyint(3) DEFAULT NULL,
  `APA0220x6_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARA0400x7` tinyint(3) DEFAULT NULL,
  `ARA0400opx7` int(10) DEFAULT NULL,
  `ARA0400opx7_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x7` tinyint(3) DEFAULT NULL,
  `RA0500x7_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x7` tinyint(3) DEFAULT NULL,
  `APA0100x7` tinyint(3) DEFAULT NULL,
  `sc5APA0100x7` int(10) DEFAULT NULL,
  `APA0200x7` tinyint(3) DEFAULT NULL,
  `APA0200x7_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x7` int(10) DEFAULT NULL,
  `APA0210x7` tinyint(3) DEFAULT NULL,
  `APA0210x7_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x7` tinyint(3) DEFAULT NULL,
  `APA0220x7_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARA0400x8` tinyint(3) DEFAULT NULL,
  `ARA0400opx8` int(10) DEFAULT NULL,
  `ARA0400opx8_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x8` tinyint(3) DEFAULT NULL,
  `RA0500x8_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x8` tinyint(3) DEFAULT NULL,
  `APA0100x8` tinyint(3) DEFAULT NULL,
  `sc5APA0100x8` int(10) DEFAULT NULL,
  `APA0200x8` tinyint(3) DEFAULT NULL,
  `APA0200x8_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x8` int(10) DEFAULT NULL,
  `APA0210x8` tinyint(3) DEFAULT NULL,
  `APA0210x8_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x8` tinyint(3) DEFAULT NULL,
  `APA0220x8_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARA0400x9` tinyint(3) DEFAULT NULL,
  `ARA0400opx9` int(10) DEFAULT NULL,
  `ARA0400opx9_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x9` tinyint(3) DEFAULT NULL,
  `RA0500x9_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x9` tinyint(3) DEFAULT NULL,
  `APA0100x9` tinyint(3) DEFAULT NULL,
  `sc5APA0100x9` int(10) DEFAULT NULL,
  `APA0200x9` tinyint(3) DEFAULT NULL,
  `APA0200x9_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x9` int(10) DEFAULT NULL,
  `APA0210x9` tinyint(3) DEFAULT NULL,
  `APA0210x9_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x9` tinyint(3) DEFAULT NULL,
  `APA0220x9_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARA0400x10` tinyint(3) DEFAULT NULL,
  `ARA0400opx10` int(10) DEFAULT NULL,
  `ARA0400opx10_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x10` tinyint(3) DEFAULT NULL,
  `RA0500x10_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x10` tinyint(3) DEFAULT NULL,
  `APA0100x10` tinyint(3) DEFAULT NULL,
  `sc5APA0100x10` int(10) DEFAULT NULL,
  `APA0200x10` tinyint(3) DEFAULT NULL,
  `APA0200x10_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x10` int(10) DEFAULT NULL,
  `APA0210x10` tinyint(3) DEFAULT NULL,
  `APA0210x10_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x10` tinyint(3) DEFAULT NULL,
  `APA0220x10_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARA0400x11` tinyint(3) DEFAULT NULL,
  `ARA0400opx11` int(10) DEFAULT NULL,
  `ARA0400opx11_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x11` tinyint(3) DEFAULT NULL,
  `RA0500x11_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x11` tinyint(3) DEFAULT NULL,
  `APA0100x11` tinyint(3) DEFAULT NULL,
  `sc5APA0100x11` int(10) DEFAULT NULL,
  `APA0200x11` tinyint(3) DEFAULT NULL,
  `APA0200x11_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x11` int(10) DEFAULT NULL,
  `APA0210x11` tinyint(3) DEFAULT NULL,
  `APA0210x11_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x11` tinyint(3) DEFAULT NULL,
  `APA0220x11_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARA0400x12` tinyint(3) DEFAULT NULL,
  `ARA0400opx12` int(10) DEFAULT NULL,
  `ARA0400opx12_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x12` tinyint(3) DEFAULT NULL,
  `RA0500x12_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x12` tinyint(3) DEFAULT NULL,
  `APA0100x12` tinyint(3) DEFAULT NULL,
  `sc5APA0100x12` int(10) DEFAULT NULL,
  `APA0200x12` tinyint(3) DEFAULT NULL,
  `APA0200x12_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x12` int(10) DEFAULT NULL,
  `APA0210x12` tinyint(3) DEFAULT NULL,
  `APA0210x12_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x12` tinyint(3) DEFAULT NULL,
  `APA0220x12_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARA0400x13` tinyint(3) DEFAULT NULL,
  `ARA0400opx13` int(10) DEFAULT NULL,
  `ARA0400opx13_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x13` tinyint(3) DEFAULT NULL,
  `RA0500x13_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x13` tinyint(3) DEFAULT NULL,
  `APA0100x13` tinyint(3) DEFAULT NULL,
  `sc5APA0100x13` int(10) DEFAULT NULL,
  `APA0200x13` tinyint(3) DEFAULT NULL,
  `APA0200x13_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x13` int(10) DEFAULT NULL,
  `APA0210x13` tinyint(3) DEFAULT NULL,
  `APA0210x13_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x13` tinyint(3) DEFAULT NULL,
  `APA0220x13_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARA0400x14` tinyint(3) DEFAULT NULL,
  `ARA0400opx14` int(10) DEFAULT NULL,
  `ARA0400opx14_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x14` tinyint(3) DEFAULT NULL,
  `RA0500x14_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x14` tinyint(3) DEFAULT NULL,
  `APA0100x14` tinyint(3) DEFAULT NULL,
  `sc5APA0100x14` int(10) DEFAULT NULL,
  `APA0200x14` tinyint(3) DEFAULT NULL,
  `APA0200x14_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x14` int(10) DEFAULT NULL,
  `APA0210x14` tinyint(3) DEFAULT NULL,
  `APA0210x14_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x14` tinyint(3) DEFAULT NULL,
  `APA0220x14_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ARA0400x15` tinyint(3) DEFAULT NULL,
  `ARA0400opx15` int(10) DEFAULT NULL,
  `ARA0400opx15_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RA0500x15` tinyint(3) DEFAULT NULL,
  `RA0500x15_opn` text COLLATE utf8_unicode_ci,
  `ARA0310x15` tinyint(3) DEFAULT NULL,
  `APA0100x15` tinyint(3) DEFAULT NULL,
  `sc5APA0100x15` int(10) DEFAULT NULL,
  `APA0200x15` tinyint(3) DEFAULT NULL,
  `APA0200x15_opn` text COLLATE utf8_unicode_ci,
  `sc7APA0200x15` int(10) DEFAULT NULL,
  `APA0210x15` tinyint(3) DEFAULT NULL,
  `APA0210x15_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APA0220x15` tinyint(3) DEFAULT NULL,
  `APA0220x15_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AZT0210` datetime DEFAULT NULL,
  `ENDIV` int(10) DEFAULT NULL,
  `EV_id_record` varchar(255) COLLATE utf8_unicode_ci 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=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
<stat>CREATE TABLE `HFCS02_Merkmale___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=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 0, 3, -6, 0, '2ed993ad3d5d3de', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 3, 0, -6, 0, '4a02b236e09e33b', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 4, 0, -6, 0, '6375b2aeed8e3ea', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 5, 0, -6, 0, 'a519328018fd5ce', 0);
<stat>DELETE FROM _www_ids WHERE id_user>0 AND user_type=0 AND id_project=6 AND id_site=0 AND id_user NOT IN (SELECT * FROM (SELECT id_user FROM `_www_ids` WHERE id_user>0 AND user_type=0 AND id_site=0 AND id_project=-6) AS p );
<stat>UPDATE IGNORE `_www_ids` SET `id_project`=ABS(`id_project`), `loginSID` = CONCAT(`loginSID`,'-',`id`) WHERE `id_project`<0;
<stat>DELETE FROM `_www_ids` WHERE `id_project`<0;
<stat>REPLACE INTO _Projects SET id = '6',key_proj = '6-a75t1l6c23',proj_name = 'HFCS02_Merkmale',language = '60',naziv_proj = '',old = 'N',created = '25.10.2019 - 12:42',creat_name = 'Administrator ',modify = '25.10.2019 - 12:42',modi_name = 'Administrator ',active = '1',start_date = '2019-10-25 00:00:00',end_date = '2020-10-25 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 = '6',id_sup = '18',id_project = '6',orderBy = '0',idLab = 'HFCS02_Merkmale',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 = 6;
<stat>DELETE FROM  _LanguageUserInterface WHERE id_project IN (0, 6);
<stat>DELETE FROM  _QuestionRotation WHERE id_project = 6;
<stat>DELETE FROM  _ProjectExtraVariables  WHERE id_project = 6;
<stat>INSERT INTO _ProjectExtraVariables  SET id = '2',id_project = '6',var_name = 'id_record',var_type = '0',anonymize = '0';
<stat>INSERT INTO _LanguageProjects  SET id_language = '60',id_project = '6';
<stat>CREATE TABLE `HFCS03_Konsum_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,
  `einxKonsum` int(10) DEFAULT NULL,
  `HI0220_1` text COLLATE utf8_unicode_ci,
  `HI0100_1` text COLLATE utf8_unicode_ci,
  `sc8HI0100` int(10) DEFAULT NULL,
  `sc9HI0100` int(10) DEFAULT NULL,
  `HI0200_1` text COLLATE utf8_unicode_ci,
  `sc10HI0200` int(10) DEFAULT NULL,
  `sc11HI0200` int(10) DEFAULT NULL,
  `sc12HI0200` int(10) DEFAULT NULL,
  `sc13HI0200` int(10) DEFAULT NULL,
  `HI0210_1` text COLLATE utf8_unicode_ci,
  `sc14HI0210` int(10) DEFAULT NULL,
  `sc15HI0210` int(10) DEFAULT NULL,
  `sc16HI0210` int(10) DEFAULT NULL,
  `HI0230_1` text COLLATE utf8_unicode_ci,
  `sc17HI0230` int(10) DEFAULT NULL,
  `HI0300` tinyint(3) DEFAULT NULL,
  `HI0310_1` text COLLATE utf8_unicode_ci,
  `sc19HI0310` int(10) DEFAULT NULL,
  `HI0410` tinyint(3) DEFAULT NULL,
  `AHI0420_1` text COLLATE utf8_unicode_ci,
  `HI0500` tinyint(3) DEFAULT NULL,
  `HI0600` tinyint(3) DEFAULT NULL,
  `HI0700_1` int(10) DEFAULT NULL,
  `HI0700_2` int(10) DEFAULT NULL,
  `HI0700_3` int(10) DEFAULT NULL,
  `HI0700_4` int(10) DEFAULT NULL,
  `HI0700_5` int(10) DEFAULT NULL,
  `HI0700_6` int(10) DEFAULT NULL,
  `HI0700_7` int(10) DEFAULT NULL,
  `HI0700_opn7` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AHI0710_1` text COLLATE utf8_unicode_ci,
  `sc20AHI0710` int(10) DEFAULT NULL,
  `sc21AHI0710` int(10) DEFAULT NULL,
  `sc22AHI0710` int(10) DEFAULT NULL,
  `sc23AHI0710` int(10) DEFAULT NULL,
  `sc24AHI0710` int(10) DEFAULT NULL,
  `sc25AHI0710` int(10) DEFAULT NULL,
  `AHI0610` tinyint(3) DEFAULT NULL,
  `AHI0620_1` text COLLATE utf8_unicode_ci,
  `HIZ040x` int(10) DEFAULT NULL,
  `HIZ040x_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `HI0800` tinyint(3) DEFAULT NULL,
  `AHI0400_1` int(10) DEFAULT NULL,
  `AHI0400_2` int(10) DEFAULT NULL,
  `AHI0400_3` int(10) DEFAULT NULL,
  `AHI0400_4` int(10) DEFAULT NULL,
  `AHI0400_5` int(10) DEFAULT NULL,
  `AHI0400_6` int(10) DEFAULT NULL,
  `AHI0400_7` int(10) DEFAULT NULL,
  `AHI0400_8` int(10) DEFAULT NULL,
  `AHI0400_9` int(10) DEFAULT NULL,
  `AHI0400_10` int(10) DEFAULT NULL,
  `AHI0400_11` int(10) DEFAULT NULL,
  `AHI0400_12` int(10) DEFAULT NULL,
  `AHI0400_13` int(10) DEFAULT NULL,
  `AHI0400_14` int(10) DEFAULT NULL,
  `AHI0400_15` int(10) DEFAULT NULL,
  `AHI0400_16` int(10) DEFAULT NULL,
  `AHI0400_opn14` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AHI0400sr` tinyint(3) DEFAULT NULL,
  `AHI0400sr_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AZT0220` datetime DEFAULT NULL,
  `ENDIV` int(10) DEFAULT NULL,
  `EV_id_record` varchar(255) COLLATE utf8_unicode_ci 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=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
<stat>CREATE TABLE `HFCS03_Konsum___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=102 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 0, 3, -7, 0, 'e73db372986d695', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 3, 0, -7, 0, '4aa46c02af8e2ee', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 4, 0, -7, 0, 'eebf35fb809f074', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 5, 0, -7, 0, 'a6871871858f9e7', 0);
<stat>DELETE FROM _www_ids WHERE id_user>0 AND user_type=0 AND id_project=7 AND id_site=0 AND id_user NOT IN (SELECT * FROM (SELECT id_user FROM `_www_ids` WHERE id_user>0 AND user_type=0 AND id_site=0 AND id_project=-7) AS p );
<stat>UPDATE IGNORE `_www_ids` SET `id_project`=ABS(`id_project`), `loginSID` = CONCAT(`loginSID`,'-',`id`) WHERE `id_project`<0;
<stat>DELETE FROM `_www_ids` WHERE `id_project`<0;
<stat>REPLACE INTO _Projects SET id = '7',key_proj = '7-l4s7u33ahz',proj_name = 'HFCS03_Konsum',language = '60',naziv_proj = '',old = 'N',created = '25.10.2019 - 12:42',creat_name = 'Administrator ',modify = '25.10.2019 - 12:42',modi_name = 'Administrator ',active = '1',start_date = '2019-10-25 00:00:00',end_date = '2020-10-25 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 = '7',id_sup = '18',id_project = '7',orderBy = '0',idLab = 'HFCS03_Konsum',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 = 7;
<stat>DELETE FROM  _LanguageUserInterface WHERE id_project IN (0, 7);
<stat>DELETE FROM  _QuestionRotation WHERE id_project = 7;
<stat>DELETE FROM  _ProjectExtraVariables  WHERE id_project = 7;
<stat>INSERT INTO _ProjectExtraVariables  SET id = '3',id_project = '7',var_name = 'id_record',var_type = '0',anonymize = '0';
<stat>INSERT INTO _LanguageProjects  SET id_language = '60',id_project = '7';