
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 0, 3, -4, 0, '195217de31ae71c', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 3, 0, -4, 0, '91ced27c4e47ee4', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 4, 0, -4, 0, '2064a0c15e5c2eb', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 5, 0, -4, 0, 'a26993028cd0750', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 6, 0, -4, 0, '7a602b9d35f3704', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 7, 0, -4, 0, '63bc8a691590e10', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 8, 0, -4, 0, '76117d765668ad0', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 9, 0, -4, 0, '5d9a6bd00866eb8', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 11, 0, -4, 0, 'a76cd9cfce5f0e4', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 12, 0, -4, 0, '288d7e1f6d13069', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 30, 0, -4, 0, 'e644af1b99cda39', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 34, 0, -4, 0, '7e59741a4309e67', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 38, 0, -4, 0, '48ec3031f2d6637', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 48, 0, -4, 0, '7a3bd775cecf99e', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 65, 0, -4, 0, '345b0ebaf24c3f1', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 70, 0, -4, 0, 'd1d5cf8d808e4f4', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 80, 0, -4, 0, '2763ff7bf78bd03', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 84, 0, -4, 0, '952ecf2f8d2fe29', 0);
<stat>DELETE FROM _www_ids WHERE id_user>0 AND user_type=0 AND id_project=4 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=-4) 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 _Interviewer SET id = '3',username = 'testuser1',password = 'testuser1',Firstname = '',Surname = '',email = '',region = '',phone_number = '',language = '0',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '4',username = 'testuser2',password = 'testuser2',Firstname = '',Surname = '',email = '',region = '',phone_number = '',language = '0',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '5',username = 'testuser3',password = 'testuser3',Firstname = '',Surname = '',email = '',region = '',phone_number = '',language = '0',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '6',username = 'test',password = 'test',Firstname = '',Surname = '',email = '',region = '',phone_number = '',language = '0',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '7',username = 'OeNB1',password = 'oenb1',Firstname = '',Surname = '',email = '',region = '',phone_number = '',language = '0',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '8',username = 'OeNB2',password = 'oenb2',Firstname = '',Surname = '',email = '',region = '',phone_number = '',language = '0',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '9',username = 'OeNB3',password = 'oenb3',Firstname = '',Surname = '',email = '',region = '',phone_number = '',language = '0',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '11',username = '15290',password = 'hefe07',Firstname = 'Waltraud',Surname = 'Stalzer',email = '',region = '',phone_number = '',language = '60',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '12',username = '16038',password = 'beny06',Firstname = 'Arnold',Surname = 'Tuppinger',email = '',region = '',phone_number = '',language = '60',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '30',username = '20115',password = 'xabu04',Firstname = 'Josef',Surname = 'Nöstinger',email = '',region = '',phone_number = '',language = '60',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '34',username = '18300',password = 'guzu04',Firstname = 'Herta',Surname = 'Danninger',email = '',region = '',phone_number = '',language = '60',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '38',username = '15703',password = 'duxu17',Firstname = 'Gülsen',Surname = 'Gündogan',email = '',region = '',phone_number = '',language = '60',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '48',username = '13564',password = 'huna14',Firstname = 'Alexander',Surname = 'Rosenfeld',email = '',region = '',phone_number = '',language = '60',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '65',username = '15174',password = 'zomi13',Firstname = 'Zsofia',Surname = 'Leuko',email = '',region = '',phone_number = '',language = '0',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '70',username = '15350',password = 'wogy04',Firstname = 'Martin',Surname = 'Holzer',email = '',region = '',phone_number = '',language = '0',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '80',username = '20216',password = 'zipy03',Firstname = 'Jadwiga',Surname = 'Rakowska',email = '',region = '',phone_number = '',language = '0',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Interviewer SET id = '84',username = '18160',password = 'wiku02',Firstname = 'Karin',Surname = 'Goll',email = '',region = '',phone_number = '',language = '0',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>REPLACE INTO _Projects SET id = '4',key_proj = '4-bnwpxmlcgg',proj_name = 'HFCS00_Base',language = '60',naziv_proj = 'HFCS 2020',old = 'N',created = '24.10.2019 - 17:00',creat_name = 'Administrator ',modify = '24.10.2019 - 17:00',modi_name = 'Administrator ',active = '1',start_date = '2019-10-24 00:00:00',end_date = '2020-10-24 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 = '5',capi_reserve = '122',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 = 'HFCS 2020',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 = '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 = 4;
<stat>DELETE FROM  _LanguageUserInterface WHERE id_project IN (0, 4);
<stat>DELETE FROM  _QuestionRotation WHERE id_project = 4;
<stat>DELETE FROM  _ProjectExtraVariables  WHERE id_project = 4;
<stat>INSERT INTO _LanguageProjects  SET id_language = '60',id_project = '4';