
<stat>#BACKUP demo_all_questions_structure ;
<stat>DROP TABLE IF EXISTS demo_all_questions_structure;
<stat>DROP TABLE IF EXISTS demo_all_questions___EngineLog;
<stat>DELETE FROM  _www_interviewer_statistics WHERE id_project = 2;
<stat>CREATE TABLE `demo_all_questions_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',
  `CRCrec` varchar(35) COLLATE utf8_unicode_ci DEFAULT NULL,
  `id_capi_sample` int(10) DEFAULT NULL,
  `id_capi_table` int(10) DEFAULT NULL,
  `id_capi_address` int(10) DEFAULT NULL,
  `QT_user_id` int(5) DEFAULT NULL,
  `age_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sex` int(10) DEFAULT NULL,
  `catchaa` tinyint(4) DEFAULT NULL,
  `dtpick_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `kondate_1` text COLLATE utf8_unicode_ci,
  `slide1` int(10) DEFAULT NULL,
  `slide2` int(10) DEFAULT NULL,
  `sr1` int(10) DEFAULT NULL,
  `sr2op` int(10) DEFAULT NULL,
  `sr2op_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `op_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sr3op` int(10) DEFAULT NULL,
  `sr3op_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sr4op` int(10) DEFAULT NULL,
  `sr4op_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `op2_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `op2_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `op2_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `op3_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `op3_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mr1_1` int(10) DEFAULT NULL,
  `mr1_2` int(10) DEFAULT NULL,
  `mr1_3` int(10) DEFAULT NULL,
  `mr1_4` int(10) DEFAULT NULL,
  `mr1_5` int(10) DEFAULT NULL,
  `mr2op_1` int(10) DEFAULT NULL,
  `mr2op_2` int(10) DEFAULT NULL,
  `mr2op_3` int(10) DEFAULT NULL,
  `mr2op_4` int(10) DEFAULT NULL,
  `mr2op_5` int(10) DEFAULT NULL,
  `mr2op_opn3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mr2op_opn5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mr3dk_1` int(10) DEFAULT NULL,
  `mr3dk_2` int(10) DEFAULT NULL,
  `mr3dk_3` int(10) DEFAULT NULL,
  `mr3dk_4` int(10) DEFAULT NULL,
  `mr3dk_5` int(10) DEFAULT NULL,
  `mr3dk_6` int(10) DEFAULT NULL,
  `sc1_1` int(10) DEFAULT NULL,
  `sc1_2` int(10) DEFAULT NULL,
  `sc1_3` int(10) DEFAULT NULL,
  `sc1_4` int(10) DEFAULT NULL,
  `sc2opn_1` int(10) DEFAULT NULL,
  `sc2opn_2` int(10) DEFAULT NULL,
  `sc2opn_3` int(10) DEFAULT NULL,
  `sc2opn_4` int(10) DEFAULT NULL,
  `mp3sc1_1_1` int(10) DEFAULT NULL,
  `mp3sc1_1_2` int(10) DEFAULT NULL,
  `mp3sc1_1_3` int(10) DEFAULT NULL,
  `mp3sc1_1_4` int(10) DEFAULT NULL,
  `mp3sc1_2_1` int(10) DEFAULT NULL,
  `mp3sc1_2_2` int(10) DEFAULT NULL,
  `mp3sc1_2_3` int(10) DEFAULT NULL,
  `mp3sc1_2_4` int(10) DEFAULT NULL,
  `mp3sc1_3_1` int(10) DEFAULT NULL,
  `mp3sc1_3_2` int(10) DEFAULT NULL,
  `mp3sc1_3_3` int(10) DEFAULT NULL,
  `mp3sc1_3_4` int(10) DEFAULT NULL,
  `mp3sc1_4_1` int(10) DEFAULT NULL,
  `mp3sc1_4_2` int(10) DEFAULT NULL,
  `mp3sc1_4_3` int(10) DEFAULT NULL,
  `mp3sc1_4_4` int(10) DEFAULT NULL,
  `mp3sc1_5_1` int(10) DEFAULT NULL,
  `mp3sc1_5_2` int(10) DEFAULT NULL,
  `mp3sc1_5_3` int(10) DEFAULT NULL,
  `mp3sc1_5_4` int(10) DEFAULT NULL,
  `mp3sc2_1_1` int(10) DEFAULT NULL,
  `mp3sc2_1_2` int(10) DEFAULT NULL,
  `mp3sc2_1_3` int(10) DEFAULT NULL,
  `mp3sc2_1_4` int(10) DEFAULT NULL,
  `mp3sc2_1_5` int(10) DEFAULT NULL,
  `mp3sc2_2_1` int(10) DEFAULT NULL,
  `mp3sc2_2_2` int(10) DEFAULT NULL,
  `mp3sc2_2_3` int(10) DEFAULT NULL,
  `mp3sc2_2_4` int(10) DEFAULT NULL,
  `mp3sc2_2_5` int(10) DEFAULT NULL,
  `mp3sc2_3_1` int(10) DEFAULT NULL,
  `mp3sc2_3_2` int(10) DEFAULT NULL,
  `mp3sc2_3_3` int(10) DEFAULT NULL,
  `mp3sc2_3_4` int(10) DEFAULT NULL,
  `mp3sc2_3_5` int(10) DEFAULT NULL,
  `mp3sc2_4_1` int(10) DEFAULT NULL,
  `mp3sc2_4_2` int(10) DEFAULT NULL,
  `mp3sc2_4_3` int(10) DEFAULT NULL,
  `mp3sc2_4_4` int(10) DEFAULT NULL,
  `mp3sc2_4_5` int(10) DEFAULT NULL,
  `sc4paar_1` int(10) DEFAULT NULL,
  `sc4paar_2` int(10) DEFAULT NULL,
  `sc4paar_3` int(10) DEFAULT NULL,
  `sc4paar_4` int(10) DEFAULT NULL,
  `sc4paar_5` int(10) DEFAULT NULL,
  `sc4paar_6` int(10) DEFAULT NULL,
  `sc4paar_7` int(10) DEFAULT NULL,
  `sc4paar_8` int(10) DEFAULT NULL,
  `sc4paar_9` int(10) DEFAULT NULL,
  `sc4paar_10` int(10) DEFAULT NULL,
  `sc4paar_11` int(10) DEFAULT NULL,
  `sc4paar_12` int(10) DEFAULT NULL,
  `sc4paar2_1` int(10) DEFAULT NULL,
  `sc4paar2_2` int(10) DEFAULT NULL,
  `sc4paar2_3` int(10) DEFAULT NULL,
  `sc4paar2_4` int(10) DEFAULT NULL,
  `sc4paar2_5` int(10) DEFAULT NULL,
  `sc4paar2_6` int(10) DEFAULT NULL,
  `sc4paar2_7` int(10) DEFAULT NULL,
  `sc4paar2_8` int(10) DEFAULT NULL,
  `sc4paar2_9` int(10) DEFAULT NULL,
  `sc4paar2_10` int(10) DEFAULT NULL,
  `sc4paar2_11` int(10) DEFAULT NULL,
  `sc4paar2_12` int(10) DEFAULT NULL,
  `srplz` int(10) DEFAULT NULL,
  `srplz_opn` int(10) DEFAULT NULL,
  `plz_1` text COLLATE utf8_unicode_ci,
  `plz_2` text COLLATE utf8_unicode_ci,
  `plz_3` text COLLATE utf8_unicode_ci,
  `dragndrop_1` int(10) DEFAULT NULL,
  `dragndrop_2` int(10) DEFAULT NULL,
  `dragndrop_3` int(10) DEFAULT NULL,
  `dragndrop_4` int(10) DEFAULT NULL,
  `dragndrop_5` int(10) DEFAULT NULL,
  `dragndrop_6` int(10) DEFAULT NULL,
  `dragndrop_7` int(10) DEFAULT NULL,
  `dragndrop_8` int(10) DEFAULT NULL,
  `dragndrop_9` int(10) DEFAULT NULL,
  `dragndrop_10` int(10) DEFAULT NULL,
  `dragndrop_11` int(10) DEFAULT NULL,
  `questText` int(10) DEFAULT NULL,
  `time1` datetime DEFAULT NULL,
  `ende` int(10) DEFAULT NULL,
  `sc2opn_opn3` 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`),
  KEY `id_capi_address` (`id_capi_address`),
  KEY `id_capi_table` (`id_capi_table`),
  KEY `id_capi_sample` (`id_capi_sample`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
<stat>CREATE TABLE `demo_all_questions___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=309 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, -2, 0, 'ef1b743d643406f', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 3, 0, -2, 0, '9f9c601648e1fe2', 0);
<stat>INSERT IGNORE INTO `_www_ids` (`id`, `id_user`, `user_type`, `id_project`, `id_site`, `loginSID`, `idGenStruc`) VALUES (null, 6, 0, -2, 0, '7a80920f44da1ce', 0);
<stat>DELETE FROM _www_ids WHERE id_user>0 AND user_type=0 AND id_project=2 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=-2) 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 = '6',username = 'test',password = 'test',Firstname = '',Surname = '',email = '',region = '',phone_number = '',language = '0',SIPPhoneID = '',SIPPass = '',id_default_tel_project = '0';
<stat>CREATE TABLE IF NOT EXISTS `demo_all_questions___sample` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tdisable` tinyint(4) NOT NULL DEFAULT '0',
  `id_sample` int(11) NOT NULL,
  `id_sampleTable` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_type` tinyint(4) NOT NULL,
  `planned_visit_time` int(11) NOT NULL,
  `num_interviews` smallint(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sampleUnique` (`id_sample`,`id_sampleTable`),
  KEY `id_sample` (`id_sample`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
<stat>DELETE FROM _CapiProperties WHERE id_project = 2
<stat>DELETE FROM `demo_all_questions___sample`
<stat>DELETE FROM _CapiTables WHERE id = 2
<stat>INSERT INTO _CapiTables SET id = '2',id_sup = '0',name = 'adr_demo_all_questions',sts_reg = '0',sts_ac = '0',reserved_numbers = '',flag_sample = '0',orderBy = '3',is_leaf = '1'
<stat>DROP TABLE IF EXISTS capi___adr_demo_all_questions
<stat>CREATE TABLE IF NOT EXISTS `capi___adr_demo_all_questions` (
  `id` int(7) NOT NULL AUTO_INCREMENT,
  `id_municipality` int(3) NOT NULL DEFAULT '0',
  `municipality` varchar(120) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `id_settlement` int(4) NOT NULL DEFAULT '0',
  `settlement` varchar(120) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `id_street` int(4) NOT NULL DEFAULT '0',
  `street` varchar(150) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `address` int(4) NOT NULL DEFAULT '0',
  `addon_address` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `zip` int(4) NOT NULL DEFAULT '0',
  `town` varchar(120) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `x_coordinate` int(9) NOT NULL DEFAULT '0',
  `y_coordinate` int(9) NOT NULL DEFAULT '0',
  `id_region` int(3) NOT NULL DEFAULT '0',
  `population` int(11) NOT NULL DEFAULT '0',
  `type_settlement` int(1) NOT NULL DEFAULT '0',
  `id_import` int(11) DEFAULT '0',
  `time_import` int(11) NOT NULL DEFAULT '0',
  `proj_reserved` int(5) NOT NULL DEFAULT '0',
  `tdisable` tinyint(1) NOT NULL DEFAULT '0',
  `capi_BL` tinyint(3) NOT NULL,
  `capi_PB` tinyint(3) NOT NULL,
  `capi_OG` tinyint(3) NOT NULL,
  `capi_intein` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `capi_vorwahl` text COLLATE utf8_unicode_ci NOT NULL,
  `capi_telnr` text COLLATE utf8_unicode_ci NOT NULL,
  `capi_ID_POST` int(10) NOT NULL,
  `capi_hnr` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_municipality` (`id_municipality`),
  KEY `id_settlement` (`id_settlement`),
  KEY `id_street` (`id_street`),
  KEY `address` (`address`),
  KEY `zip` (`zip`),
  KEY `x_coordinate` (`x_coordinate`),
  KEY `y_coordinate` (`y_coordinate`),
  KEY `id_region` (`id_region`),
  KEY `population` (`population`),
  KEY `type_settlement` (`type_settlement`),
  KEY `id_import` (`id_import`),
  KEY `proj_reserved` (`proj_reserved`),
  KEY `tdisable` (`tdisable`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
<stat>INSERT INTO capi___adr_demo_all_questions SET id = '1',id_municipality = '1',municipality = '990999',id_settlement = '1',settlement = 'Calisota',id_street = '0',street = 'Blumenweg',address = '0',addon_address = 'Nr. 1',zip = '1811',town = 'Entenhausen',name = 'Donald Duck',x_coordinate = '0',y_coordinate = '0',id_region = '0',population = '0',type_settlement = '0',id_import = '1',time_import = '1570545271',proj_reserved = '2',tdisable = '0',capi_BL = '9',capi_PB = '9',capi_OG = '9',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '0',capi_hnr = 'Nr. 13';
<stat>INSERT INTO capi___adr_demo_all_questions SET id = '2',id_municipality = '1',municipality = '990999',id_settlement = '2',settlement = 'Calisota',id_street = '0',street = 'Blumenweg',address = '0',addon_address = 'Nr. 1',zip = '1811',town = 'Entenhausen',name = 'Dagobert Duck',x_coordinate = '0',y_coordinate = '0',id_region = '0',population = '0',type_settlement = '0',id_import = '1',time_import = '1570545271',proj_reserved = '2',tdisable = '0',capi_BL = '9',capi_PB = '9',capi_OG = '9',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '0',capi_hnr = 'Nr. 14';
<stat>INSERT INTO capi___adr_demo_all_questions SET id = '3',id_municipality = '1',municipality = '990999',id_settlement = '3',settlement = 'Calisota',id_street = '0',street = 'Blumenweg',address = '0',addon_address = 'Nr. 1',zip = '1811',town = 'Entenhausen',name = 'Daisy Duck',x_coordinate = '0',y_coordinate = '0',id_region = '0',population = '0',type_settlement = '0',id_import = '1',time_import = '1570545271',proj_reserved = '2',tdisable = '0',capi_BL = '9',capi_PB = '9',capi_OG = '9',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '0',capi_hnr = 'Nr. 15';
<stat>INSERT INTO capi___adr_demo_all_questions SET id = '4',id_municipality = '1',municipality = '990999',id_settlement = '4',settlement = 'Calisota',id_street = '0',street = 'Blumenweg',address = '0',addon_address = 'Nr. 1',zip = '1811',town = 'Entenhausen',name = 'Gustav Gans',x_coordinate = '0',y_coordinate = '0',id_region = '0',population = '0',type_settlement = '0',id_import = '1',time_import = '1570545271',proj_reserved = '2',tdisable = '0',capi_BL = '9',capi_PB = '9',capi_OG = '9',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '0',capi_hnr = 'Nr. 16';
<stat>INSERT INTO capi___adr_demo_all_questions SET id = '5',id_municipality = '1',municipality = '990999',id_settlement = '5',settlement = 'Calisota',id_street = '0',street = 'Blumenweg',address = '0',addon_address = 'Nr. 1',zip = '1811',town = 'Entenhausen',name = 'Klaas Klever',x_coordinate = '0',y_coordinate = '0',id_region = '0',population = '0',type_settlement = '0',id_import = '1',time_import = '1570545271',proj_reserved = '2',tdisable = '0',capi_BL = '9',capi_PB = '9',capi_OG = '9',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '0',capi_hnr = 'Nr. 17';
<stat>INSERT INTO capi___adr_demo_all_questions SET id = '6',id_municipality = '1',municipality = '990999',id_settlement = '6',settlement = 'Calisota',id_street = '0',street = 'Blumenweg',address = '0',addon_address = 'Nr. 1',zip = '1811',town = 'Entenhausen',name = 'Gundel Gaukeley',x_coordinate = '0',y_coordinate = '0',id_region = '0',population = '0',type_settlement = '0',id_import = '1',time_import = '1570545271',proj_reserved = '2',tdisable = '0',capi_BL = '9',capi_PB = '9',capi_OG = '9',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '0',capi_hnr = 'Nr. 18';
<stat>INSERT INTO capi___adr_demo_all_questions SET id = '7',id_municipality = '1',municipality = '990999',id_settlement = '7',settlement = 'Calisota',id_street = '0',street = 'Blumenweg',address = '0',addon_address = 'Nr. 1',zip = '1811',town = 'Entenhausen',name = 'Micky Maus',x_coordinate = '0',y_coordinate = '0',id_region = '0',population = '0',type_settlement = '0',id_import = '1',time_import = '1570545271',proj_reserved = '2',tdisable = '0',capi_BL = '9',capi_PB = '9',capi_OG = '9',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '0',capi_hnr = 'Nr. 19';
<stat>INSERT INTO capi___adr_demo_all_questions SET id = '8',id_municipality = '1',municipality = '990999',id_settlement = '8',settlement = 'Calisota',id_street = '0',street = 'Blumenweg',address = '0',addon_address = 'Nr. 2',zip = '1811',town = 'Entenhausen',name = 'Goofy',x_coordinate = '0',y_coordinate = '0',id_region = '0',population = '0',type_settlement = '0',id_import = '1',time_import = '1570545271',proj_reserved = '2',tdisable = '0',capi_BL = '9',capi_PB = '9',capi_OG = '9',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '0',capi_hnr = 'Nr. 20';
<stat>INSERT INTO capi___adr_demo_all_questions SET id = '9',id_municipality = '1',municipality = '990999',id_settlement = '9',settlement = 'Calisota',id_street = '0',street = 'Blumenweg',address = '0',addon_address = 'Nr. 2',zip = '1811',town = 'Entenhausen',name = 'Minni Maus',x_coordinate = '0',y_coordinate = '0',id_region = '0',population = '0',type_settlement = '0',id_import = '1',time_import = '1570545271',proj_reserved = '2',tdisable = '0',capi_BL = '9',capi_PB = '9',capi_OG = '9',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '0',capi_hnr = 'Nr. 21';
<stat>INSERT INTO capi___adr_demo_all_questions SET id = '10',id_municipality = '1',municipality = '990999',id_settlement = '10',settlement = 'Calisota',id_street = '0',street = 'Blumenweg',address = '0',addon_address = 'Nr. 2',zip = '1811',town = 'Entenhausen',name = 'Pluto',x_coordinate = '0',y_coordinate = '0',id_region = '0',population = '0',type_settlement = '0',id_import = '1',time_import = '1570545271',proj_reserved = '2',tdisable = '0',capi_BL = '9',capi_PB = '9',capi_OG = '9',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '0',capi_hnr = 'Nr. 22';
<stat>INSERT INTO capi___adr_demo_all_questions SET id = '11',id_municipality = '1',municipality = '990999',id_settlement = '11',settlement = 'Calisota',id_street = '0',street = 'Blumenweg',address = '0',addon_address = 'Nr. 2',zip = '1811',town = 'Entenhausen',name = 'Klarabella Kuh',x_coordinate = '0',y_coordinate = '0',id_region = '0',population = '0',type_settlement = '0',id_import = '1',time_import = '1570545271',proj_reserved = '2',tdisable = '0',capi_BL = '9',capi_PB = '9',capi_OG = '9',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '0',capi_hnr = 'Nr. 23';
<stat>INSERT INTO capi___adr_demo_all_questions SET id = '12',id_municipality = '1',municipality = '990999',id_settlement = '12',settlement = 'Calisota',id_street = '0',street = 'Blumenweg',address = '0',addon_address = 'Nr. 2',zip = '1811',town = 'Entenhausen',name = 'Kater Karlo',x_coordinate = '0',y_coordinate = '0',id_region = '0',population = '0',type_settlement = '0',id_import = '1',time_import = '1570545271',proj_reserved = '2',tdisable = '0',capi_BL = '9',capi_PB = '9',capi_OG = '9',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '0',capi_hnr = 'Nr. 24';
<stat>INSERT INTO demo_all_questions___sample SET id = '1',tdisable = '0',id_sample = '1',id_sampleTable = '2',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO demo_all_questions___sample SET id = '2',tdisable = '0',id_sample = '2',id_sampleTable = '2',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO demo_all_questions___sample SET id = '3',tdisable = '0',id_sample = '3',id_sampleTable = '2',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO demo_all_questions___sample SET id = '4',tdisable = '0',id_sample = '4',id_sampleTable = '2',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO demo_all_questions___sample SET id = '5',tdisable = '0',id_sample = '5',id_sampleTable = '2',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO demo_all_questions___sample SET id = '6',tdisable = '0',id_sample = '6',id_sampleTable = '2',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO demo_all_questions___sample SET id = '7',tdisable = '0',id_sample = '7',id_sampleTable = '2',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO demo_all_questions___sample SET id = '8',tdisable = '0',id_sample = '8',id_sampleTable = '2',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO demo_all_questions___sample SET id = '9',tdisable = '0',id_sample = '9',id_sampleTable = '2',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO demo_all_questions___sample SET id = '10',tdisable = '0',id_sample = '10',id_sampleTable = '2',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO demo_all_questions___sample SET id = '11',tdisable = '0',id_sample = '11',id_sampleTable = '2',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO demo_all_questions___sample SET id = '12',tdisable = '0',id_sample = '12',id_sampleTable = '2',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT IGNORE INTO `_Plugin` SET id_plugin 	= '9', plugin_name = 'Slider plugin',	plugin_path	= 'slider'
<stat>CREATE TABLE IF NOT EXISTS `_plugin_slider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_project` int(11) NOT NULL,
  `id_question` int(11) NOT NULL,
  `show_scale` tinyint(4) NOT NULL DEFAULT '1',
  `upper_bound` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lower_bound` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `scale_type` tinyint(4) NOT NULL DEFAULT '0',
  `step` int(11) NOT NULL DEFAULT '0',
  `scale_font` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `scale_font_size` int(11) NOT NULL DEFAULT '0',
  `scale_font_color` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `slider_font` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `slider_font_size` int(11) NOT NULL DEFAULT '10',
  `slider_font_color` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '#000000',
  `extreme_font` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `extreme_font_size` int(11) NOT NULL,
  `extreme_font_color` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `extreme_circle_color` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `extreme_radius` int(11) NOT NULL,
  `slider_type` int(11) NOT NULL DEFAULT '1',
  `interval_from` float NOT NULL DEFAULT '0',
  `interval_to` float NOT NULL DEFAULT '100',
  `null_value` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `default_text` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `default_value` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `scale_values` text COLLATE utf8_unicode_ci NOT NULL,
  `pole_image` text COLLATE utf8_unicode_ci NOT NULL,
  `slider_width` int(11) NOT NULL,
  `extreme_border_width` int(11) NOT NULL,
  `slider_handle_image` text COLLATE utf8_unicode_ci NOT NULL,
  `hide_no_answer` tinyint(4) NOT NULL DEFAULT '0',
  `no_answer_text` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `left_text` text COLLATE utf8_unicode_ci NOT NULL,
  `right_text` text COLLATE utf8_unicode_ci NOT NULL,
  `disable_next_button` tinyint(4) NOT NULL DEFAULT '0',
  `text_box_width` int(11) NOT NULL,
  `space_after_slider` int(11) NOT NULL DEFAULT '0',
  `show_poles` tinyint(1) NOT NULL,
  `slider_height` int(11) NOT NULL DEFAULT '5',
  `selected_color` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  `scale_steps` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `border_color` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ffffff',
  `border_width` int(11) NOT NULL DEFAULT '0',
  `background_color` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `selected_border_color` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '#ffffff',
  `selected_border_width` int(11) NOT NULL DEFAULT '0',
  `handle_margin_top` int(11) NOT NULL DEFAULT '0',
  `vertical_text_position` int(11) NOT NULL DEFAULT '0',
  `main_css` text COLLATE utf8_unicode_ci NOT NULL,
  `group` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `scale_element_width` int(11) NOT NULL DEFAULT '100',
  `left_text_padding` int(11) NOT NULL DEFAULT '0',
  `right_text_padding` int(11) NOT NULL DEFAULT '0',
  `no_answer_slider_action` int(11) NOT NULL DEFAULT '2',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_project` (`id_project`,`id_question`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
<stat>DELETE FROM `_plugin_slider` WHERE id_project = 2
<stat>INSERT INTO `_plugin_slider` SET `id_project` = '2',`id_question` = '30',`show_scale` = '1',`upper_bound` = '',`lower_bound` = '',`scale_type` = '1',`step` = '1',`scale_font` = 'Arial',`scale_font_size` = '11',`scale_font_color` = 'black',`slider_font` = 'Arial',`slider_font_size` = '11',`slider_font_color` = 'black',`extreme_font` = 'Arial',`extreme_font_size` = '11',`extreme_font_color` = 'black',`extreme_circle_color` = '#0094da',`extreme_radius` = '45',`slider_type` = '2',`interval_from` = '0',`interval_to` = '10',`null_value` = '-1',`default_text` = 'Slide',`default_value` = '0',`scale_values` = '',`pole_image` = '',`slider_width` = '800',`extreme_border_width` = '0',`slider_handle_image` = '../../webIfesProjects/sliderHandel.png',`hide_no_answer` = '1',`no_answer_text` = 'No answer',`left_text` = '1.Antwort',`right_text` = '2.Antwort',`disable_next_button` = '0',`text_box_width` = '150',`space_after_slider` = '0',`show_poles` = '0',`slider_height` = '5',`selected_color` = '',`deleted` = '0',`scale_steps` = '',`border_color` = 'ffffff',`border_width` = '0',`background_color` = '',`selected_border_color` = '#ffffff',`selected_border_width` = '0',`handle_margin_top` = '0',`vertical_text_position` = '0',`main_css` = '',`group` = '2',`scale_element_width` = '100',`left_text_padding` = '0',`right_text_padding` = '0',`no_answer_slider_action` = '1'
<stat>INSERT IGNORE INTO `_Plugin` SET id_plugin 	= '7', plugin_name = 'Drag and drop plugin',	plugin_path	= 'dragandrop'
<stat>CREATE TABLE IF NOT EXISTS `_plugin_dragandrop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_project` int(11) NOT NULL,
  `id_question` int(11) NOT NULL,
  `cardsType` int(11) NOT NULL,
  `cardWidth` int(11) NOT NULL,
  `cardHeight` int(11) NOT NULL,
  `cardBaseColor` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `cardBorderColor` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `cardShadow` int(11) NOT NULL,
  `cardShadowColor` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `cardAllVisible` tinyint(1) NOT NULL,
  `layout` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `textAlign` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
  `cardRows` int(11) NOT NULL,
  `cardColumns` int(11) NOT NULL,
  `resetEnabled` tinyint(1) NOT NULL,
  `cardFontSize` int(11) NOT NULL,
  `captionFontSize` int(11) NOT NULL,
  `boxNeutralColor` text COLLATE utf8_unicode_ci NOT NULL,
  `neutralMargin` int(11) NOT NULL,
  `centerOffset` int(11) NOT NULL,
  `cardRoundCorners` tinyint(1) NOT NULL,
  `boxBgColor` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `boxBaseColor` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `boxBorderColor` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `boxRoundCorners` int(11) NOT NULL,
  `boxCaptionHidden` tinyint(2) NOT NULL,
  `boxMargin` int(11) NOT NULL,
  `centerLineWidth` int(11) NOT NULL,
  `centerLineColor` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `resetOffsetLeft` int(11) NOT NULL,
  `resetOffsetTop` int(11) NOT NULL,
  `resetIcon` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `resetText` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `itemsAlignHorizontal` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
  `itemsAlignVertical` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
  `cardPaddingInBox` int(11) NOT NULL,
  `fullScreenWidth` tinyint(1) NOT NULL,
  `openAnswerText` text COLLATE utf8_unicode_ci NOT NULL,
  `openAnswerTextArea` tinyint(1) NOT NULL,
  `openAnswerEnabled` tinyint(1) NOT NULL,
  `openAnswerRelQuestion` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `horizontal_card_margin` smallint(6) NOT NULL,
  `noGoAnswers` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `requireAllAnswers` tinyint(1) NOT NULL DEFAULT '1',
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  `cardTextColor` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `boxHeight` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index` (`id_project`,`id_question`)
) ENGINE=MyISAM AUTO_INCREMENT=311 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
<stat>DELETE FROM `_plugin_dragandrop` WHERE id_project = 2
<stat>INSERT INTO `_plugin_dragandrop` SET `id_project` = '2',`id_question` = '39',`cardsType` = '1',`cardWidth` = '140',`cardHeight` = '90',`cardBaseColor` = '#fefefe',`cardBorderColor` = '#000000',`cardShadow` = '5',`cardShadowColor` = '#3d3d3d',`cardAllVisible` = '0',`layout` = 'vertical',`textAlign` = 'left',`cardRows` = '1',`cardColumns` = '1',`resetEnabled` = '0',`cardFontSize` = '14',`captionFontSize` = '14',`boxNeutralColor` = '',`neutralMargin` = '40',`centerOffset` = '20',`cardRoundCorners` = '5',`boxBgColor` = '#ffffff',`boxBaseColor` = '#999999',`boxBorderColor` = '#cccccc',`boxRoundCorners` = '2',`boxCaptionHidden` = '0',`boxMargin` = '20',`centerLineWidth` = '1',`centerLineColor` = '#000000',`resetOffsetLeft` = '470',`resetOffsetTop` = '164',`resetIcon` = '',`resetText` = '',`itemsAlignHorizontal` = 'center',`itemsAlignVertical` = 'middle',`cardPaddingInBox` = '10',`fullScreenWidth` = '0',`openAnswerText` = 'Please insert text:',`openAnswerTextArea` = '0',`openAnswerEnabled` = '0',`openAnswerRelQuestion` = '',`horizontal_card_margin` = '5',`noGoAnswers` = '',`requireAllAnswers` = '1',`deleted` = '0',`cardTextColor` = '#000000',`boxHeight` = '0'
<stat>INSERT IGNORE INTO `_Plugin` SET id_plugin 	= '36', plugin_name = 'Date select',	plugin_path	= 'dateselect'
<stat>CREATE TABLE IF NOT EXISTS `_plugin_dateselect` (
  `id_plugin_gallery` int(11) NOT NULL AUTO_INCREMENT,
  `id_question` int(11) NOT NULL,
  `id_project` int(11) NOT NULL,
  `timepicker` tinyint(1) NOT NULL DEFAULT '0',
  `icon_trigger` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `theme` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
  `inline` tinyint(1) NOT NULL DEFAULT '0',
  `minDate` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `maxDate` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `select_year_variable` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `default_date` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `show_default_date` tinyint(1) NOT NULL DEFAULT '0',
  `language` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
  `datepicker` tinyint(1) NOT NULL DEFAULT '1',
  `allowTimes` text COLLATE utf8_unicode_ci,
  `start_time` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `end_time` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `step` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `showFormat` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_plugin_gallery`),
  UNIQUE KEY `id_question` (`id_question`,`id_project`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
<stat>DELETE FROM `_plugin_dateselect` WHERE id_project = 2
<stat>INSERT INTO `_plugin_dateselect` SET `id_plugin_gallery` = '1',`id_question` = '45',`id_project` = '2',`timepicker` = '0',`icon_trigger` = 'https://support.solve-x.net/webIfesProjects/icon_calendar.png',`theme` = 'default',`inline` = '0',`minDate` = '1.1.1930',`maxDate` = '1.1.2005',`select_year_variable` = '',`default_date` = '1.1.1980',`show_default_date` = '1',`language` = 'de',`datepicker` = '1',`allowTimes` = '',`start_time` = '00:00',`end_time` = '24:00',`step` = 'PT15M',`showFormat` = '',`deleted` = '0'
<stat>INSERT IGNORE INTO `_Plugin` SET id_plugin 	= '106', plugin_name = 'Responsive slider',	plugin_path	= 'responsiveslider'
<stat>CREATE TABLE IF NOT EXISTS `_plugin_responsiveslider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_project` int(11) NOT NULL,
  `id_question` int(11) NOT NULL,
  `space_after_slider` int(11) NOT NULL DEFAULT '50',
  `space_before_slider` int(11) NOT NULL DEFAULT '50',
  `space_left_slider` int(11) NOT NULL DEFAULT '20',
  `space_right_slider` int(11) NOT NULL DEFAULT '20',
  `font_size` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `background_color` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `scale_min` int(11) NOT NULL DEFAULT '1',
  `scale_max` int(11) NOT NULL DEFAULT '5',
  `scale_step` int(11) NOT NULL DEFAULT '1',
  `left_side_text` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `right_side_text` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_project` (`id_project`,`id_question`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC
<stat>DELETE FROM `_plugin_responsiveslider` WHERE id_project = 2
<stat>INSERT INTO `_plugin_responsiveslider` SET `id_project` = '2',`id_question` = '44',`space_after_slider` = '50',`space_before_slider` = '50',`space_left_slider` = '20',`space_right_slider` = '20',`font_size` = '',`background_color` = '',`scale_min` = '1',`scale_max` = '5',`scale_step` = '1',`left_side_text` = 'left text',`right_side_text` = 'right text',`deleted` = '0'
<stat>REPLACE INTO _Projects SET id = '2',key_proj = '2-ycnn6jtnh5',proj_name = 'demo_all_questions',language = '60',naziv_proj = 'Demo Questionaire',old = 'N',created = '08.10.2019 - 16:26',creat_name = 'Administrator ',modify = '08.10.2019 - 16:26',modi_name = 'Administrator ',active = '1',start_date = '2019-10-08 00:00:00',end_date = '2022-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 = '2',capi_reserve = '12',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 = 'DEMO',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 = '2',id_sup = '17',id_project = '2',orderBy = '0',idLab = 'demo_all_questions',node_img = '',is_leaf = '1',merged = '0';
<stat>REPLACE INTO _ProjectsTree SET id = '17',id_sup = '0',id_project = '0',orderBy = '1',idLab = 'TEST',node_img = '',is_leaf = '0',merged = '0';
<stat>DELETE FROM  _LanguageProjects WHERE id_project = 2;
<stat>DELETE FROM  _LanguageUserInterface WHERE id_project IN (0, 2);
<stat>DELETE FROM  _QuestionRotation WHERE id_project = 2;
<stat>DELETE FROM  _ProjectExtraVariables  WHERE id_project = 2;
<stat>INSERT INTO _LanguageProjects  SET id_language = '46',id_project = '2';
<stat>INSERT INTO _LanguageProjects  SET id_language = '60',id_project = '2';