
<stat>CREATE TABLE IF NOT EXISTS `pTestQuest1___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 = 30
<stat>DELETE FROM `pTestQuest1___sample`
<stat>DELETE FROM _CapiTables WHERE id = 3
<stat>INSERT INTO _CapiTables SET id = '3',id_sup = '0',name = 'adrtest1',sts_reg = '0',sts_ac = '0',reserved_numbers = '',flag_sample = '0',orderBy = '2',is_leaf = '1'
<stat>DROP TABLE IF EXISTS capi___adrtest1
<stat>CREATE TABLE IF NOT EXISTS `capi___adrtest1` (
  `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___adrtest1 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 = '1570698411',proj_reserved = '30',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___adrtest1 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 = '1570698411',proj_reserved = '30',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___adrtest1 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 = '1570698411',proj_reserved = '30',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___adrtest1 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 = '1570698411',proj_reserved = '30',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___adrtest1 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 = '1570698411',proj_reserved = '30',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___adrtest1 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 = '1570698411',proj_reserved = '30',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___adrtest1 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 = '1570698411',proj_reserved = '30',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___adrtest1 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 = '1570698411',proj_reserved = '30',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___adrtest1 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 = '1570698411',proj_reserved = '30',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___adrtest1 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 = '1570698411',proj_reserved = '30',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___adrtest1 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 = '1570698411',proj_reserved = '30',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___adrtest1 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 = '1570698411',proj_reserved = '30',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 pTestQuest1___sample SET id = '1',tdisable = '0',id_sample = '1',id_sampleTable = '3',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO pTestQuest1___sample SET id = '2',tdisable = '0',id_sample = '2',id_sampleTable = '3',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO pTestQuest1___sample SET id = '3',tdisable = '0',id_sample = '3',id_sampleTable = '3',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO pTestQuest1___sample SET id = '4',tdisable = '0',id_sample = '4',id_sampleTable = '3',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO pTestQuest1___sample SET id = '5',tdisable = '0',id_sample = '5',id_sampleTable = '3',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO pTestQuest1___sample SET id = '6',tdisable = '0',id_sample = '6',id_sampleTable = '3',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO pTestQuest1___sample SET id = '7',tdisable = '0',id_sample = '7',id_sampleTable = '3',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO pTestQuest1___sample SET id = '8',tdisable = '0',id_sample = '8',id_sampleTable = '3',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO pTestQuest1___sample SET id = '9',tdisable = '0',id_sample = '9',id_sampleTable = '3',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO pTestQuest1___sample SET id = '10',tdisable = '0',id_sample = '10',id_sampleTable = '3',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO pTestQuest1___sample SET id = '11',tdisable = '0',id_sample = '11',id_sampleTable = '3',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO pTestQuest1___sample SET id = '12',tdisable = '0',id_sample = '12',id_sampleTable = '3',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';