
<stat>#BACKUP p27293122_structure ;
<stat>DROP TABLE IF EXISTS p27293122_structure;
<stat>DROP TABLE IF EXISTS p27293122___EngineLog;
<stat>DELETE FROM  _www_interviewer_statistics WHERE id_project = 38;
<stat>CREATE TABLE `p27293122_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,
  `questtext_1` text COLLATE utf8_unicode_ci,
  `Projektdaten_1` text COLLATE utf8_unicode_ci,
  `Projektdaten_2` text COLLATE utf8_unicode_ci,
  `Projektdaten_3` text COLLATE utf8_unicode_ci,
  `Projektdaten_4` text COLLATE utf8_unicode_ci,
  `Projektdaten_5` text COLLATE utf8_unicode_ci,
  `Projektdaten_6` text COLLATE utf8_unicode_ci,
  `Projektdaten_7` text COLLATE utf8_unicode_ci,
  `Projektdaten_8` text COLLATE utf8_unicode_ci,
  `Projektdaten_9` text COLLATE utf8_unicode_ci,
  `Projektdaten_10` text COLLATE utf8_unicode_ci,
  `Projektdaten_11` text COLLATE utf8_unicode_ci,
  `Projektdaten_12` text COLLATE utf8_unicode_ci,
  `Projektdaten_13` text COLLATE utf8_unicode_ci,
  `Projektdaten_14` text COLLATE utf8_unicode_ci,
  `Projektdaten_15` text COLLATE utf8_unicode_ci,
  `Projektdaten_16` text COLLATE utf8_unicode_ci,
  `Projektdaten_17` text COLLATE utf8_unicode_ci,
  `Projektdaten_18` text COLLATE utf8_unicode_ci,
  `Projektdaten_19` text COLLATE utf8_unicode_ci,
  `Projektdaten_20` text COLLATE utf8_unicode_ci,
  `Projektdaten_21` text COLLATE utf8_unicode_ci,
  `Projektdaten_22` text COLLATE utf8_unicode_ci,
  `Projektdaten_23` text COLLATE utf8_unicode_ci,
  `Projektdaten_24` text COLLATE utf8_unicode_ci,
  `Projektdaten_25` text COLLATE utf8_unicode_ci,
  `projdata_1` text COLLATE utf8_unicode_ci,
  `KvNr` tinyint(3) DEFAULT NULL,
  `TEST` tinyint(3) DEFAULT NULL,
  `Liste` int(10) DEFAULT NULL,
  `methode` int(10) DEFAULT NULL,
  `AGE_1` int(10) DEFAULT NULL,
  `SEX` tinyint(3) DEFAULT NULL,
  `tmstart` datetime DEFAULT NULL,
  `ANZTV_1` tinyint(3) DEFAULT NULL,
  `timevdbstart` datetime DEFAULT NULL,
  `DEVHH_1` int(10) DEFAULT NULL,
  `DEVHH_2` int(10) DEFAULT NULL,
  `DEVHH_3` int(10) DEFAULT NULL,
  `DEVHH_4` int(10) DEFAULT NULL,
  `DEVTVHH_1` int(10) DEFAULT NULL,
  `DEVTVHH_2` int(10) DEFAULT NULL,
  `DEVTVHH_3` int(10) DEFAULT NULL,
  `DEVTVHH_4` int(10) DEFAULT NULL,
  `INTNET` tinyint(3) DEFAULT NULL,
  `INTART_1` tinyint(3) DEFAULT NULL,
  `INTART_2` tinyint(3) DEFAULT NULL,
  `INTART_3` tinyint(3) DEFAULT NULL,
  `INTART_4` tinyint(3) DEFAULT NULL,
  `INTART_5` tinyint(3) DEFAULT NULL,
  `INTART_6` tinyint(3) DEFAULT NULL,
  `INTART_7` tinyint(3) DEFAULT NULL,
  `INTART_opn6` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `KOSTSTREAM_1` tinyint(3) DEFAULT NULL,
  `KOSTSTREAM_2` tinyint(3) DEFAULT NULL,
  `KOSTSTREAM_3` tinyint(3) DEFAULT NULL,
  `KOSTSTREAM_4` tinyint(3) DEFAULT NULL,
  `KOSTSTREAM_5` tinyint(3) DEFAULT NULL,
  `KOSTSTREAM_6` tinyint(3) DEFAULT NULL,
  `KOSTSTREAM_7` tinyint(3) DEFAULT NULL,
  `KOSTSTREAM_8` tinyint(3) DEFAULT NULL,
  `KOSTSTREAM_9` tinyint(3) DEFAULT NULL,
  `KOSTSTREAM_10` tinyint(3) DEFAULT NULL,
  `einlende` datetime DEFAULT NULL,
  `TVARTCxTV1` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV1_1` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV1_2` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV1_3` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV1_4` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV1_opn1` int(10) DEFAULT NULL,
  `TVDIAGxTV1_opn2` int(10) DEFAULT NULL,
  `TVORTAxTV1` tinyint(3) DEFAULT NULL,
  `RCEXTxTV1` tinyint(3) DEFAULT NULL,
  `RCINTxTV1` tinyint(3) DEFAULT NULL,
  `ZSRECxTV1` tinyint(3) DEFAULT NULL,
  `SPEICHxTV1` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_1` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_2` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_3` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_4` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_5` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_6` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_7` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_8` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_9` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_10` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_11` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_12` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_13` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_14` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_15` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_16` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV1_opn12` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVPLUGxTV1_opn14` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVFUNCxTV1_1` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV1_2` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV1_3` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV1_4` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV1_5` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV1_6` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV1_7` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV1_8` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV1_9` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV1_10` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV1_11` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV1_12` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV1_13` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV1_14` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV1_15` tinyint(3) DEFAULT NULL,
  `TVHDxTV1_1` int(10) DEFAULT NULL,
  `TVHDxTV1_2` int(10) DEFAULT NULL,
  `TVHDxTV1_3` int(10) DEFAULT NULL,
  `TVHDxTV1_4` int(10) DEFAULT NULL,
  `TVHDxTV1_5` int(10) DEFAULT NULL,
  `HDCKxTV1` int(10) DEFAULT NULL,
  `TVRECxTV1_1` tinyint(3) DEFAULT NULL,
  `TVRECxTV1_2` tinyint(3) DEFAULT NULL,
  `TVRECxTV1_3` tinyint(3) DEFAULT NULL,
  `TVRECxTV1_4` tinyint(3) DEFAULT NULL,
  `TVRECxTV1_5` tinyint(3) DEFAULT NULL,
  `TVRECxTV1_6` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV1_1` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV1_2` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV1_3` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV1_4` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV1_5` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV1_6` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV1_7` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV1_8` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV1_9` tinyint(3) DEFAULT NULL,
  `A1TVSATxTV1` int(10) DEFAULT NULL,
  `TVCKxTV1_1` int(10) DEFAULT NULL,
  `TVCKxTV1_2` int(10) DEFAULT NULL,
  `TVCKxTV1_3` int(10) DEFAULT NULL,
  `TVCKxTV1_4` int(10) DEFAULT NULL,
  `KABANBxTV1` tinyint(3) DEFAULT NULL,
  `KABANBxTV1_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVLISTxTV1_1` int(10) DEFAULT NULL,
  `TVLISTxTV1_2` int(10) DEFAULT NULL,
  `TVLISTxTV1_3` int(10) DEFAULT NULL,
  `TVLISTxTV1_4` int(10) DEFAULT NULL,
  `TVLISTxTV1_5` int(10) DEFAULT NULL,
  `TVLISTxTV1_6` int(10) DEFAULT NULL,
  `TVLISTxTV1_7` int(10) DEFAULT NULL,
  `DIGICRDxTV1_1` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV1_2` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV1_3` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV1_4` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV1_5` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV1_6` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV1_7` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV1_8` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV1_9` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV1_10` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV1_opn8` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `INTCKxTV1` tinyint(3) DEFAULT NULL,
  `HBBCKxTV1` tinyint(3) DEFAULT NULL,
  `APPSxTV1_1` int(10) DEFAULT NULL,
  `APPSxTV1_2` int(10) DEFAULT NULL,
  `APPSxTV1_3` int(10) DEFAULT NULL,
  `APPSxTV1_4` int(10) DEFAULT NULL,
  `APPSxTV1_5` int(10) DEFAULT NULL,
  `APPSxTV1_6` int(10) DEFAULT NULL,
  `APPSxTV1_7` int(10) DEFAULT NULL,
  `APPSxTV1_8` int(10) DEFAULT NULL,
  `APPSxTV1_9` int(10) DEFAULT NULL,
  `APPSxTV1_10` int(10) DEFAULT NULL,
  `APPSxTV1_11` int(10) DEFAULT NULL,
  `APPSxTV1_12` int(10) DEFAULT NULL,
  `APPSxTV1_13` int(10) DEFAULT NULL,
  `APPSxTV1_14` int(10) DEFAULT NULL,
  `APPSxTV1_15` int(10) DEFAULT NULL,
  `APPSxTV1_16` int(10) DEFAULT NULL,
  `APPSxTV1_17` int(10) DEFAULT NULL,
  `APPSxTV1_18` int(10) DEFAULT NULL,
  `APPSxTV1_19` int(10) DEFAULT NULL,
  `APPSxTV1_20` int(10) DEFAULT NULL,
  `APPSxTV1_21` int(10) DEFAULT NULL,
  `APPSxTV1_22` int(10) DEFAULT NULL,
  `APPSxTV1_23` int(10) DEFAULT NULL,
  `APPSxTV1_24` int(10) DEFAULT NULL,
  `APPSxTV1_25` int(10) DEFAULT NULL,
  `APPSxTV1_26` int(10) DEFAULT NULL,
  `APPSxTV1_27` int(10) DEFAULT NULL,
  `APPSxTV1_28` int(10) DEFAULT NULL,
  `PROXYxTV1` tinyint(3) DEFAULT NULL,
  `tv1ende` datetime DEFAULT NULL,
  `TVARTCxTV2` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV2_1` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV2_2` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV2_3` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV2_4` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV2_opn1` int(10) DEFAULT NULL,
  `TVDIAGxTV2_opn2` int(10) DEFAULT NULL,
  `TVORTAxTV2` tinyint(3) DEFAULT NULL,
  `RCEXTxTV2` tinyint(3) DEFAULT NULL,
  `RCINTxTV2` tinyint(3) DEFAULT NULL,
  `ZSRECxTV2` tinyint(3) DEFAULT NULL,
  `SPEICHxTV2` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_1` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_2` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_3` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_4` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_5` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_6` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_7` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_8` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_9` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_10` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_11` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_12` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_13` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_14` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_15` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_16` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV2_opn12` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVPLUGxTV2_opn14` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVFUNCxTV2_1` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV2_2` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV2_3` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV2_4` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV2_5` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV2_6` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV2_7` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV2_8` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV2_9` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV2_10` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV2_11` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV2_12` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV2_13` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV2_14` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV2_15` tinyint(3) DEFAULT NULL,
  `TVHDxTV2_1` int(10) DEFAULT NULL,
  `TVHDxTV2_2` int(10) DEFAULT NULL,
  `TVHDxTV2_3` int(10) DEFAULT NULL,
  `TVHDxTV2_4` int(10) DEFAULT NULL,
  `TVHDxTV2_5` int(10) DEFAULT NULL,
  `HDCKxTV2` int(10) DEFAULT NULL,
  `TVRECxTV2_1` tinyint(3) DEFAULT NULL,
  `TVRECxTV2_2` tinyint(3) DEFAULT NULL,
  `TVRECxTV2_3` tinyint(3) DEFAULT NULL,
  `TVRECxTV2_4` tinyint(3) DEFAULT NULL,
  `TVRECxTV2_5` tinyint(3) DEFAULT NULL,
  `TVRECxTV2_6` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV2_1` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV2_2` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV2_3` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV2_4` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV2_5` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV2_6` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV2_7` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV2_8` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV2_9` tinyint(3) DEFAULT NULL,
  `A1TVSATxTV2` int(10) DEFAULT NULL,
  `TVCKxTV2_1` int(10) DEFAULT NULL,
  `TVCKxTV2_2` int(10) DEFAULT NULL,
  `TVCKxTV2_3` int(10) DEFAULT NULL,
  `TVCKxTV2_4` int(10) DEFAULT NULL,
  `KABANBxTV2` tinyint(3) DEFAULT NULL,
  `KABANBxTV2_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVLISTxTV2_1` int(10) DEFAULT NULL,
  `TVLISTxTV2_2` int(10) DEFAULT NULL,
  `TVLISTxTV2_3` int(10) DEFAULT NULL,
  `TVLISTxTV2_4` int(10) DEFAULT NULL,
  `TVLISTxTV2_5` int(10) DEFAULT NULL,
  `TVLISTxTV2_6` int(10) DEFAULT NULL,
  `TVLISTxTV2_7` int(10) DEFAULT NULL,
  `DIGICRDxTV2_1` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV2_2` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV2_3` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV2_4` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV2_5` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV2_6` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV2_7` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV2_8` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV2_9` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV2_10` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV2_opn8` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `INTCKxTV2` tinyint(3) DEFAULT NULL,
  `HBBCKxTV2` tinyint(3) DEFAULT NULL,
  `APPSxTV2_1` int(10) DEFAULT NULL,
  `APPSxTV2_2` int(10) DEFAULT NULL,
  `APPSxTV2_3` int(10) DEFAULT NULL,
  `APPSxTV2_4` int(10) DEFAULT NULL,
  `APPSxTV2_5` int(10) DEFAULT NULL,
  `APPSxTV2_6` int(10) DEFAULT NULL,
  `APPSxTV2_7` int(10) DEFAULT NULL,
  `APPSxTV2_8` int(10) DEFAULT NULL,
  `APPSxTV2_9` int(10) DEFAULT NULL,
  `APPSxTV2_10` int(10) DEFAULT NULL,
  `APPSxTV2_11` int(10) DEFAULT NULL,
  `APPSxTV2_12` int(10) DEFAULT NULL,
  `APPSxTV2_13` int(10) DEFAULT NULL,
  `APPSxTV2_14` int(10) DEFAULT NULL,
  `APPSxTV2_15` int(10) DEFAULT NULL,
  `APPSxTV2_16` int(10) DEFAULT NULL,
  `APPSxTV2_17` int(10) DEFAULT NULL,
  `APPSxTV2_18` int(10) DEFAULT NULL,
  `APPSxTV2_19` int(10) DEFAULT NULL,
  `APPSxTV2_20` int(10) DEFAULT NULL,
  `APPSxTV2_21` int(10) DEFAULT NULL,
  `APPSxTV2_22` int(10) DEFAULT NULL,
  `APPSxTV2_23` int(10) DEFAULT NULL,
  `APPSxTV2_24` int(10) DEFAULT NULL,
  `APPSxTV2_25` int(10) DEFAULT NULL,
  `APPSxTV2_26` int(10) DEFAULT NULL,
  `APPSxTV2_27` int(10) DEFAULT NULL,
  `APPSxTV2_28` int(10) DEFAULT NULL,
  `PROXYxTV2` tinyint(3) DEFAULT NULL,
  `tv2ende` datetime DEFAULT NULL,
  `TVARTCxTV3` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV3_1` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV3_2` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV3_3` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV3_4` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV3_opn1` int(10) DEFAULT NULL,
  `TVDIAGxTV3_opn2` int(10) DEFAULT NULL,
  `TVORTAxTV3` tinyint(3) DEFAULT NULL,
  `RCEXTxTV3` tinyint(3) DEFAULT NULL,
  `RCINTxTV3` tinyint(3) DEFAULT NULL,
  `ZSRECxTV3` tinyint(3) DEFAULT NULL,
  `SPEICHxTV3` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_1` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_2` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_3` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_4` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_5` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_6` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_7` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_8` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_9` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_10` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_11` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_12` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_13` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_14` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_15` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_16` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV3_opn12` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVPLUGxTV3_opn14` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVFUNCxTV3_1` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV3_2` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV3_3` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV3_4` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV3_5` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV3_6` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV3_7` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV3_8` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV3_9` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV3_10` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV3_11` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV3_12` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV3_13` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV3_14` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV3_15` tinyint(3) DEFAULT NULL,
  `TVHDxTV3_1` int(10) DEFAULT NULL,
  `TVHDxTV3_2` int(10) DEFAULT NULL,
  `TVHDxTV3_3` int(10) DEFAULT NULL,
  `TVHDxTV3_4` int(10) DEFAULT NULL,
  `TVHDxTV3_5` int(10) DEFAULT NULL,
  `HDCKxTV3` int(10) DEFAULT NULL,
  `TVRECxTV3_1` tinyint(3) DEFAULT NULL,
  `TVRECxTV3_2` tinyint(3) DEFAULT NULL,
  `TVRECxTV3_3` tinyint(3) DEFAULT NULL,
  `TVRECxTV3_4` tinyint(3) DEFAULT NULL,
  `TVRECxTV3_5` tinyint(3) DEFAULT NULL,
  `TVRECxTV3_6` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV3_1` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV3_2` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV3_3` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV3_4` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV3_5` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV3_6` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV3_7` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV3_8` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV3_9` tinyint(3) DEFAULT NULL,
  `A1TVSATxTV3` int(10) DEFAULT NULL,
  `TVCKxTV3_1` int(10) DEFAULT NULL,
  `TVCKxTV3_2` int(10) DEFAULT NULL,
  `TVCKxTV3_3` int(10) DEFAULT NULL,
  `TVCKxTV3_4` int(10) DEFAULT NULL,
  `KABANBxTV3` tinyint(3) DEFAULT NULL,
  `KABANBxTV3_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVLISTxTV3_1` int(10) DEFAULT NULL,
  `TVLISTxTV3_2` int(10) DEFAULT NULL,
  `TVLISTxTV3_3` int(10) DEFAULT NULL,
  `TVLISTxTV3_4` int(10) DEFAULT NULL,
  `TVLISTxTV3_5` int(10) DEFAULT NULL,
  `TVLISTxTV3_6` int(10) DEFAULT NULL,
  `TVLISTxTV3_7` int(10) DEFAULT NULL,
  `DIGICRDxTV3_1` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV3_2` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV3_3` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV3_4` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV3_5` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV3_6` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV3_7` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV3_8` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV3_9` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV3_10` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV3_opn8` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `INTCKxTV3` tinyint(3) DEFAULT NULL,
  `HBBCKxTV3` tinyint(3) DEFAULT NULL,
  `APPSxTV3_1` int(10) DEFAULT NULL,
  `APPSxTV3_2` int(10) DEFAULT NULL,
  `APPSxTV3_3` int(10) DEFAULT NULL,
  `APPSxTV3_4` int(10) DEFAULT NULL,
  `APPSxTV3_5` int(10) DEFAULT NULL,
  `APPSxTV3_6` int(10) DEFAULT NULL,
  `APPSxTV3_7` int(10) DEFAULT NULL,
  `APPSxTV3_8` int(10) DEFAULT NULL,
  `APPSxTV3_9` int(10) DEFAULT NULL,
  `APPSxTV3_10` int(10) DEFAULT NULL,
  `APPSxTV3_11` int(10) DEFAULT NULL,
  `APPSxTV3_12` int(10) DEFAULT NULL,
  `APPSxTV3_13` int(10) DEFAULT NULL,
  `APPSxTV3_14` int(10) DEFAULT NULL,
  `APPSxTV3_15` int(10) DEFAULT NULL,
  `APPSxTV3_16` int(10) DEFAULT NULL,
  `APPSxTV3_17` int(10) DEFAULT NULL,
  `APPSxTV3_18` int(10) DEFAULT NULL,
  `APPSxTV3_19` int(10) DEFAULT NULL,
  `APPSxTV3_20` int(10) DEFAULT NULL,
  `APPSxTV3_21` int(10) DEFAULT NULL,
  `APPSxTV3_22` int(10) DEFAULT NULL,
  `APPSxTV3_23` int(10) DEFAULT NULL,
  `APPSxTV3_24` int(10) DEFAULT NULL,
  `APPSxTV3_25` int(10) DEFAULT NULL,
  `APPSxTV3_26` int(10) DEFAULT NULL,
  `APPSxTV3_27` int(10) DEFAULT NULL,
  `APPSxTV3_28` int(10) DEFAULT NULL,
  `PROXYxTV3` tinyint(3) DEFAULT NULL,
  `tv3endex` datetime DEFAULT NULL,
  `TVARTCxTV4` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV4_1` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV4_2` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV4_3` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV4_4` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV4_opn1` int(10) DEFAULT NULL,
  `TVDIAGxTV4_opn2` int(10) DEFAULT NULL,
  `TVORTAxTV4` tinyint(3) DEFAULT NULL,
  `RCEXTxTV4` tinyint(3) DEFAULT NULL,
  `RCINTxTV4` tinyint(3) DEFAULT NULL,
  `ZSRECxTV4` tinyint(3) DEFAULT NULL,
  `SPEICHxTV4` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_1` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_2` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_3` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_4` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_5` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_6` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_7` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_8` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_9` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_10` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_11` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_12` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_13` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_14` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_15` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_16` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV4_opn12` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVPLUGxTV4_opn14` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVFUNCxTV4_1` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV4_2` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV4_3` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV4_4` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV4_5` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV4_6` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV4_7` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV4_8` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV4_9` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV4_10` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV4_11` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV4_12` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV4_13` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV4_14` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV4_15` tinyint(3) DEFAULT NULL,
  `TVHDxTV4_1` int(10) DEFAULT NULL,
  `TVHDxTV4_2` int(10) DEFAULT NULL,
  `TVHDxTV4_3` int(10) DEFAULT NULL,
  `TVHDxTV4_4` int(10) DEFAULT NULL,
  `TVHDxTV4_5` int(10) DEFAULT NULL,
  `HDCKxTV4` int(10) DEFAULT NULL,
  `TVRECxTV4_1` tinyint(3) DEFAULT NULL,
  `TVRECxTV4_2` tinyint(3) DEFAULT NULL,
  `TVRECxTV4_3` tinyint(3) DEFAULT NULL,
  `TVRECxTV4_4` tinyint(3) DEFAULT NULL,
  `TVRECxTV4_5` tinyint(3) DEFAULT NULL,
  `TVRECxTV4_6` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV4_1` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV4_2` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV4_3` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV4_4` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV4_5` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV4_6` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV4_7` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV4_8` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV4_9` tinyint(3) DEFAULT NULL,
  `A1TVSATxTV4` int(10) DEFAULT NULL,
  `TVCKxTV4_1` int(10) DEFAULT NULL,
  `TVCKxTV4_2` int(10) DEFAULT NULL,
  `TVCKxTV4_3` int(10) DEFAULT NULL,
  `TVCKxTV4_4` int(10) DEFAULT NULL,
  `KABANBxTV4` tinyint(3) DEFAULT NULL,
  `KABANBxTV4_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVLISTxTV4_1` int(10) DEFAULT NULL,
  `TVLISTxTV4_2` int(10) DEFAULT NULL,
  `TVLISTxTV4_3` int(10) DEFAULT NULL,
  `TVLISTxTV4_4` int(10) DEFAULT NULL,
  `TVLISTxTV4_5` int(10) DEFAULT NULL,
  `TVLISTxTV4_6` int(10) DEFAULT NULL,
  `TVLISTxTV4_7` int(10) DEFAULT NULL,
  `DIGICRDxTV4_1` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV4_2` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV4_3` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV4_4` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV4_5` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV4_6` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV4_7` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV4_8` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV4_9` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV4_10` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV4_opn8` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `INTCKxTV4` tinyint(3) DEFAULT NULL,
  `HBBCKxTV4` tinyint(3) DEFAULT NULL,
  `APPSxTV4_1` int(10) DEFAULT NULL,
  `APPSxTV4_2` int(10) DEFAULT NULL,
  `APPSxTV4_3` int(10) DEFAULT NULL,
  `APPSxTV4_4` int(10) DEFAULT NULL,
  `APPSxTV4_5` int(10) DEFAULT NULL,
  `APPSxTV4_6` int(10) DEFAULT NULL,
  `APPSxTV4_7` int(10) DEFAULT NULL,
  `APPSxTV4_8` int(10) DEFAULT NULL,
  `APPSxTV4_9` int(10) DEFAULT NULL,
  `APPSxTV4_10` int(10) DEFAULT NULL,
  `APPSxTV4_11` int(10) DEFAULT NULL,
  `APPSxTV4_12` int(10) DEFAULT NULL,
  `APPSxTV4_13` int(10) DEFAULT NULL,
  `APPSxTV4_14` int(10) DEFAULT NULL,
  `APPSxTV4_15` int(10) DEFAULT NULL,
  `APPSxTV4_16` int(10) DEFAULT NULL,
  `APPSxTV4_17` int(10) DEFAULT NULL,
  `APPSxTV4_18` int(10) DEFAULT NULL,
  `APPSxTV4_19` int(10) DEFAULT NULL,
  `APPSxTV4_20` int(10) DEFAULT NULL,
  `APPSxTV4_21` int(10) DEFAULT NULL,
  `APPSxTV4_22` int(10) DEFAULT NULL,
  `APPSxTV4_23` int(10) DEFAULT NULL,
  `APPSxTV4_24` int(10) DEFAULT NULL,
  `APPSxTV4_25` int(10) DEFAULT NULL,
  `APPSxTV4_26` int(10) DEFAULT NULL,
  `APPSxTV4_27` int(10) DEFAULT NULL,
  `APPSxTV4_28` int(10) DEFAULT NULL,
  `PROXYxTV4` tinyint(3) DEFAULT NULL,
  `tv4endex` datetime DEFAULT NULL,
  `TVARTCxTV5` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV5_1` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV5_2` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV5_3` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV5_4` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV5_opn1` int(10) DEFAULT NULL,
  `TVDIAGxTV5_opn2` int(10) DEFAULT NULL,
  `TVORTAxTV5` tinyint(3) DEFAULT NULL,
  `RCEXTxTV5` tinyint(3) DEFAULT NULL,
  `RCINTxTV5` tinyint(3) DEFAULT NULL,
  `ZSRECxTV5` tinyint(3) DEFAULT NULL,
  `SPEICHxTV5` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_1` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_2` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_3` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_4` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_5` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_6` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_7` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_8` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_9` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_10` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_11` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_12` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_13` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_14` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_15` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_16` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV5_opn12` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVPLUGxTV5_opn14` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVFUNCxTV5_1` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV5_2` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV5_3` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV5_4` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV5_5` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV5_6` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV5_7` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV5_8` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV5_9` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV5_10` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV5_11` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV5_12` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV5_13` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV5_14` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV5_15` tinyint(3) DEFAULT NULL,
  `TVHDxTV5_1` int(10) DEFAULT NULL,
  `TVHDxTV5_2` int(10) DEFAULT NULL,
  `TVHDxTV5_3` int(10) DEFAULT NULL,
  `TVHDxTV5_4` int(10) DEFAULT NULL,
  `TVHDxTV5_5` int(10) DEFAULT NULL,
  `HDCKxTV5` int(10) DEFAULT NULL,
  `TVRECxTV5_1` tinyint(3) DEFAULT NULL,
  `TVRECxTV5_2` tinyint(3) DEFAULT NULL,
  `TVRECxTV5_3` tinyint(3) DEFAULT NULL,
  `TVRECxTV5_4` tinyint(3) DEFAULT NULL,
  `TVRECxTV5_5` tinyint(3) DEFAULT NULL,
  `TVRECxTV5_6` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV5_1` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV5_2` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV5_3` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV5_4` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV5_5` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV5_6` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV5_7` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV5_8` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV5_9` tinyint(3) DEFAULT NULL,
  `A1TVSATxTV5` int(10) DEFAULT NULL,
  `TVCKxTV5_1` int(10) DEFAULT NULL,
  `TVCKxTV5_2` int(10) DEFAULT NULL,
  `TVCKxTV5_3` int(10) DEFAULT NULL,
  `TVCKxTV5_4` int(10) DEFAULT NULL,
  `KABANBxTV5` tinyint(3) DEFAULT NULL,
  `KABANBxTV5_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVLISTxTV5_1` int(10) DEFAULT NULL,
  `TVLISTxTV5_2` int(10) DEFAULT NULL,
  `TVLISTxTV5_3` int(10) DEFAULT NULL,
  `TVLISTxTV5_4` int(10) DEFAULT NULL,
  `TVLISTxTV5_5` int(10) DEFAULT NULL,
  `TVLISTxTV5_6` int(10) DEFAULT NULL,
  `TVLISTxTV5_7` int(10) DEFAULT NULL,
  `DIGICRDxTV5_1` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV5_2` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV5_3` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV5_4` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV5_5` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV5_6` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV5_7` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV5_8` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV5_9` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV5_10` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV5_opn8` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `INTCKxTV5` tinyint(3) DEFAULT NULL,
  `HBBCKxTV5` tinyint(3) DEFAULT NULL,
  `APPSxTV5_1` int(10) DEFAULT NULL,
  `APPSxTV5_2` int(10) DEFAULT NULL,
  `APPSxTV5_3` int(10) DEFAULT NULL,
  `APPSxTV5_4` int(10) DEFAULT NULL,
  `APPSxTV5_5` int(10) DEFAULT NULL,
  `APPSxTV5_6` int(10) DEFAULT NULL,
  `APPSxTV5_7` int(10) DEFAULT NULL,
  `APPSxTV5_8` int(10) DEFAULT NULL,
  `APPSxTV5_9` int(10) DEFAULT NULL,
  `APPSxTV5_10` int(10) DEFAULT NULL,
  `APPSxTV5_11` int(10) DEFAULT NULL,
  `APPSxTV5_12` int(10) DEFAULT NULL,
  `APPSxTV5_13` int(10) DEFAULT NULL,
  `APPSxTV5_14` int(10) DEFAULT NULL,
  `APPSxTV5_15` int(10) DEFAULT NULL,
  `APPSxTV5_16` int(10) DEFAULT NULL,
  `APPSxTV5_17` int(10) DEFAULT NULL,
  `APPSxTV5_18` int(10) DEFAULT NULL,
  `APPSxTV5_19` int(10) DEFAULT NULL,
  `APPSxTV5_20` int(10) DEFAULT NULL,
  `APPSxTV5_21` int(10) DEFAULT NULL,
  `APPSxTV5_22` int(10) DEFAULT NULL,
  `APPSxTV5_23` int(10) DEFAULT NULL,
  `APPSxTV5_24` int(10) DEFAULT NULL,
  `APPSxTV5_25` int(10) DEFAULT NULL,
  `APPSxTV5_26` int(10) DEFAULT NULL,
  `APPSxTV5_27` int(10) DEFAULT NULL,
  `APPSxTV5_28` int(10) DEFAULT NULL,
  `PROXYxTV5` tinyint(3) DEFAULT NULL,
  `tv5endex` datetime DEFAULT NULL,
  `TVARTCxTV6` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV6_1` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV6_2` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV6_3` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV6_4` tinyint(3) DEFAULT NULL,
  `TVDIAGxTV6_opn1` int(10) DEFAULT NULL,
  `TVDIAGxTV6_opn2` int(10) DEFAULT NULL,
  `TVORTAxTV6` tinyint(3) DEFAULT NULL,
  `RCEXTxTV6` tinyint(3) DEFAULT NULL,
  `RCINTxTV6` tinyint(3) DEFAULT NULL,
  `ZSRECxTV6` tinyint(3) DEFAULT NULL,
  `SPEICHxTV6` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_1` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_2` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_3` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_4` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_5` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_6` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_7` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_8` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_9` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_10` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_11` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_12` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_13` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_14` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_15` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_16` tinyint(3) DEFAULT NULL,
  `TVPLUGxTV6_opn12` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVPLUGxTV6_opn14` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVFUNCxTV6_1` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV6_2` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV6_3` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV6_4` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV6_5` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV6_6` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV6_7` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV6_8` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV6_9` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV6_10` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV6_11` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV6_12` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV6_13` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV6_14` tinyint(3) DEFAULT NULL,
  `TVFUNCxTV6_15` tinyint(3) DEFAULT NULL,
  `TVHDxTV6_1` int(10) DEFAULT NULL,
  `TVHDxTV6_2` int(10) DEFAULT NULL,
  `TVHDxTV6_3` int(10) DEFAULT NULL,
  `TVHDxTV6_4` int(10) DEFAULT NULL,
  `TVHDxTV6_5` int(10) DEFAULT NULL,
  `HDCKxTV6` int(10) DEFAULT NULL,
  `TVRECxTV6_1` tinyint(3) DEFAULT NULL,
  `TVRECxTV6_2` tinyint(3) DEFAULT NULL,
  `TVRECxTV6_3` tinyint(3) DEFAULT NULL,
  `TVRECxTV6_4` tinyint(3) DEFAULT NULL,
  `TVRECxTV6_5` tinyint(3) DEFAULT NULL,
  `TVRECxTV6_6` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV6_1` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV6_2` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV6_3` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV6_4` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV6_5` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV6_6` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV6_7` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV6_8` tinyint(3) DEFAULT NULL,
  `TVEMPFxTV6_9` tinyint(3) DEFAULT NULL,
  `A1TVSATxTV6` int(10) DEFAULT NULL,
  `TVCKxTV6_1` int(10) DEFAULT NULL,
  `TVCKxTV6_2` int(10) DEFAULT NULL,
  `TVCKxTV6_3` int(10) DEFAULT NULL,
  `TVCKxTV6_4` int(10) DEFAULT NULL,
  `KABANBxTV6` tinyint(3) DEFAULT NULL,
  `KABANBxTV6_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVLISTxTV6_1` int(10) DEFAULT NULL,
  `TVLISTxTV6_2` int(10) DEFAULT NULL,
  `TVLISTxTV6_3` int(10) DEFAULT NULL,
  `TVLISTxTV6_4` int(10) DEFAULT NULL,
  `TVLISTxTV6_5` int(10) DEFAULT NULL,
  `TVLISTxTV6_6` int(10) DEFAULT NULL,
  `TVLISTxTV6_7` int(10) DEFAULT NULL,
  `DIGICRDxTV6_1` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV6_2` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV6_3` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV6_4` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV6_5` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV6_6` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV6_7` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV6_8` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV6_9` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV6_10` tinyint(3) DEFAULT NULL,
  `DIGICRDxTV6_opn8` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `INTCKxTV6` tinyint(3) DEFAULT NULL,
  `HBBCKxTV6` tinyint(3) DEFAULT NULL,
  `APPSxTV6_1` int(10) DEFAULT NULL,
  `APPSxTV6_2` int(10) DEFAULT NULL,
  `APPSxTV6_3` int(10) DEFAULT NULL,
  `APPSxTV6_4` int(10) DEFAULT NULL,
  `APPSxTV6_5` int(10) DEFAULT NULL,
  `APPSxTV6_6` int(10) DEFAULT NULL,
  `APPSxTV6_7` int(10) DEFAULT NULL,
  `APPSxTV6_8` int(10) DEFAULT NULL,
  `APPSxTV6_9` int(10) DEFAULT NULL,
  `APPSxTV6_10` int(10) DEFAULT NULL,
  `APPSxTV6_11` int(10) DEFAULT NULL,
  `APPSxTV6_12` int(10) DEFAULT NULL,
  `APPSxTV6_13` int(10) DEFAULT NULL,
  `APPSxTV6_14` int(10) DEFAULT NULL,
  `APPSxTV6_15` int(10) DEFAULT NULL,
  `APPSxTV6_16` int(10) DEFAULT NULL,
  `APPSxTV6_17` int(10) DEFAULT NULL,
  `APPSxTV6_18` int(10) DEFAULT NULL,
  `APPSxTV6_19` int(10) DEFAULT NULL,
  `APPSxTV6_20` int(10) DEFAULT NULL,
  `APPSxTV6_21` int(10) DEFAULT NULL,
  `APPSxTV6_22` int(10) DEFAULT NULL,
  `APPSxTV6_23` int(10) DEFAULT NULL,
  `APPSxTV6_24` int(10) DEFAULT NULL,
  `APPSxTV6_25` int(10) DEFAULT NULL,
  `APPSxTV6_26` int(10) DEFAULT NULL,
  `APPSxTV6_27` int(10) DEFAULT NULL,
  `APPSxTV6_28` int(10) DEFAULT NULL,
  `PROXYxTV6` tinyint(3) DEFAULT NULL,
  `tv6endex` datetime DEFAULT NULL,
  `HHEMPF_1` tinyint(3) DEFAULT NULL,
  `HHEMPF_2` tinyint(3) DEFAULT NULL,
  `HHEMPF_3` tinyint(3) DEFAULT NULL,
  `HHEMPF_4` tinyint(3) DEFAULT NULL,
  `HHEMPF_5` tinyint(3) DEFAULT NULL,
  `HHEMPF_6` tinyint(3) DEFAULT NULL,
  `HHEMPF_7` tinyint(3) DEFAULT NULL,
  `HHEMPFplus_1` tinyint(3) DEFAULT NULL,
  `HHEMPFplus_2` tinyint(3) DEFAULT NULL,
  `HHEMPFplus_3` tinyint(3) DEFAULT NULL,
  `HHEMPFplus_4` tinyint(3) DEFAULT NULL,
  `HHEMPFplus_5` tinyint(3) DEFAULT NULL,
  `HHEMPFplus_6` tinyint(3) DEFAULT NULL,
  `HHEMPFplus_7` tinyint(3) DEFAULT NULL,
  `HHEMPFplus_8` tinyint(3) DEFAULT NULL,
  `HHEMPFplus_9` tinyint(3) DEFAULT NULL,
  `HHEMPFxNr_1` tinyint(3) DEFAULT NULL,
  `HHEMPFxNr_2` tinyint(3) DEFAULT NULL,
  `HHEMPFxNr_3` tinyint(3) DEFAULT NULL,
  `HHEMPFxNr_4` tinyint(3) DEFAULT NULL,
  `HHEMPFxNr_5` tinyint(3) DEFAULT NULL,
  `HHEMPFxNr_6` tinyint(3) DEFAULT NULL,
  `HHEMPFxNr_7` tinyint(3) DEFAULT NULL,
  `HHEMPFplusxNr_1` tinyint(3) DEFAULT NULL,
  `HHEMPFplusxNr_2` tinyint(3) DEFAULT NULL,
  `HHEMPFplusxNr_3` tinyint(3) DEFAULT NULL,
  `HHEMPFplusxNr_4` tinyint(3) DEFAULT NULL,
  `HHEMPFplusxNr_5` tinyint(3) DEFAULT NULL,
  `HHEMPFplusxNr_6` tinyint(3) DEFAULT NULL,
  `HHEMPFplusxNr_7` tinyint(3) DEFAULT NULL,
  `HHEMPFplusxNr_8` tinyint(3) DEFAULT NULL,
  `HHEMPFplusxNr_9` tinyint(3) DEFAULT NULL,
  `PAYTV_1` int(10) DEFAULT NULL,
  `PAYTV_2` int(10) DEFAULT NULL,
  `PAYTV_3` int(10) DEFAULT NULL,
  `SKY_1` tinyint(3) DEFAULT NULL,
  `SKY_2` tinyint(3) DEFAULT NULL,
  `SKY_3` tinyint(3) DEFAULT NULL,
  `SKY_4` tinyint(3) DEFAULT NULL,
  `SKY_5` tinyint(3) DEFAULT NULL,
  `SKY_6` tinyint(3) DEFAULT NULL,
  `SKYHD_1` int(10) DEFAULT NULL,
  `SKYHD_2` int(10) DEFAULT NULL,
  `SKYHD_3` int(10) DEFAULT NULL,
  `AUT_1` tinyint(3) DEFAULT NULL,
  `AUT_2` tinyint(3) DEFAULT NULL,
  `AUT_3` tinyint(3) DEFAULT NULL,
  `AUT_4` tinyint(3) DEFAULT NULL,
  `AUT_5` tinyint(3) DEFAULT NULL,
  `SIMP_1` tinyint(3) DEFAULT NULL,
  `SIMP_2` tinyint(3) DEFAULT NULL,
  `SIMP_3` tinyint(3) DEFAULT NULL,
  `SIMP_4` tinyint(3) DEFAULT NULL,
  `SIMP_5` tinyint(3) DEFAULT NULL,
  `SIMPLYCHK` int(10) DEFAULT NULL,
  `DUMSENPL_1` text COLLATE utf8_unicode_ci,
  `DUMSENPL_2` text COLLATE utf8_unicode_ci,
  `DUMSENPL_3` text COLLATE utf8_unicode_ci,
  `DUMSENPL_4` text COLLATE utf8_unicode_ci,
  `DUMSENPL_5` text COLLATE utf8_unicode_ci,
  `DUMSENPL_6` text COLLATE utf8_unicode_ci,
  `DUMSENPL_7` text COLLATE utf8_unicode_ci,
  `DUMSENPL_8` text COLLATE utf8_unicode_ci,
  `DUMSENPL_9` text COLLATE utf8_unicode_ci,
  `DUMSENPL_10` text COLLATE utf8_unicode_ci,
  `DUMSENPL_11` text COLLATE utf8_unicode_ci,
  `DUMSENPL_12` text COLLATE utf8_unicode_ci,
  `DUMSENPL_13` text COLLATE utf8_unicode_ci,
  `DUMSENPL_14` text COLLATE utf8_unicode_ci,
  `DUMSENPL_15` text COLLATE utf8_unicode_ci,
  `DUMSENPL_16` text COLLATE utf8_unicode_ci,
  `DUMSENPL_17` text COLLATE utf8_unicode_ci,
  `DUMSENPL_18` text COLLATE utf8_unicode_ci,
  `DUMSENPL_19` text COLLATE utf8_unicode_ci,
  `DUMSENPL_20` text COLLATE utf8_unicode_ci,
  `DUMSENPL_21` text COLLATE utf8_unicode_ci,
  `DUMSENPL_22` text COLLATE utf8_unicode_ci,
  `DUMSENPL_23` text COLLATE utf8_unicode_ci,
  `TVBACK_1` int(10) DEFAULT NULL,
  `TVBACK_2` int(10) DEFAULT NULL,
  `TVBACK_3` int(10) DEFAULT NULL,
  `TVBACK_4` int(10) DEFAULT NULL,
  `TVBACK_5` int(10) DEFAULT NULL,
  `TVBACK_6` int(10) DEFAULT NULL,
  `TVBACK_7` int(10) DEFAULT NULL,
  `TVBACK_8` int(10) DEFAULT NULL,
  `FAVLST` int(10) DEFAULT NULL,
  `HDzu0` int(10) DEFAULT NULL,
  `HDzu1` int(10) DEFAULT NULL,
  `HDzu2` int(10) DEFAULT NULL,
  `HDzu3A` int(10) DEFAULT NULL,
  `HDzu3B` int(10) DEFAULT NULL,
  `HDzu4A` int(10) DEFAULT NULL,
  `HDzu4B` int(10) DEFAULT NULL,
  `HDzu5` int(10) DEFAULT NULL,
  `HDzu6` int(10) DEFAULT NULL,
  `HDzu7_1` int(10) DEFAULT NULL,
  `HDzu7_2` int(10) DEFAULT NULL,
  `HDzu7_3` int(10) DEFAULT NULL,
  `SENDPLx1` tinyint(3) DEFAULT NULL,
  `HDx1` int(10) DEFAULT NULL,
  `ATDEx1` int(10) DEFAULT NULL,
  `SENDPLx2` tinyint(3) DEFAULT NULL,
  `HDx2` int(10) DEFAULT NULL,
  `ATDEx2` int(10) DEFAULT NULL,
  `SENDPLx3` tinyint(3) DEFAULT NULL,
  `HDx3` int(10) DEFAULT NULL,
  `ATDEx3` int(10) DEFAULT NULL,
  `SENDPLx4` tinyint(3) DEFAULT NULL,
  `HDx4` int(10) DEFAULT NULL,
  `ATDEx4` int(10) DEFAULT NULL,
  `SENDPLx5` tinyint(3) DEFAULT NULL,
  `HDx5` int(10) DEFAULT NULL,
  `ATDEx5` int(10) DEFAULT NULL,
  `SENDPLx6` tinyint(3) DEFAULT NULL,
  `HDx6` int(10) DEFAULT NULL,
  `ATDEx6` int(10) DEFAULT NULL,
  `SENDPLx7` tinyint(3) DEFAULT NULL,
  `HDx7` int(10) DEFAULT NULL,
  `ATDEx7` int(10) DEFAULT NULL,
  `SENDPLx8` tinyint(3) DEFAULT NULL,
  `HDx8` int(10) DEFAULT NULL,
  `ATDEx8` int(10) DEFAULT NULL,
  `SENDPLx9` tinyint(3) DEFAULT NULL,
  `HDx9` int(10) DEFAULT NULL,
  `ATDEx9` int(10) DEFAULT NULL,
  `SENDPLx10` tinyint(3) DEFAULT NULL,
  `HDx10` int(10) DEFAULT NULL,
  `ATDEx10` int(10) DEFAULT NULL,
  `SENDPLx11` tinyint(3) DEFAULT NULL,
  `HDx11` int(10) DEFAULT NULL,
  `ATDEx11` int(10) DEFAULT NULL,
  `SENDPLx12` tinyint(3) DEFAULT NULL,
  `HDx12` int(10) DEFAULT NULL,
  `ATDEx12` int(10) DEFAULT NULL,
  `SENDPLx13` tinyint(3) DEFAULT NULL,
  `HDx13` int(10) DEFAULT NULL,
  `ATDEx13` int(10) DEFAULT NULL,
  `SENDPLx14` tinyint(3) DEFAULT NULL,
  `HDx14` int(10) DEFAULT NULL,
  `ATDEx14` int(10) DEFAULT NULL,
  `SENDPLx15` tinyint(3) DEFAULT NULL,
  `HDx15` int(10) DEFAULT NULL,
  `ATDEx15` int(10) DEFAULT NULL,
  `SENDPLx16` tinyint(3) DEFAULT NULL,
  `HDx16` int(10) DEFAULT NULL,
  `ATDEx16` int(10) DEFAULT NULL,
  `SENDPLx17` tinyint(3) DEFAULT NULL,
  `HDx17` int(10) DEFAULT NULL,
  `ATDEx17` int(10) DEFAULT NULL,
  `SENDPLx18` tinyint(3) DEFAULT NULL,
  `HDx18` int(10) DEFAULT NULL,
  `ATDEx18` int(10) DEFAULT NULL,
  `SENDPLx19` tinyint(3) DEFAULT NULL,
  `HDx19` int(10) DEFAULT NULL,
  `ATDEx19` int(10) DEFAULT NULL,
  `SENDPLx20` tinyint(3) DEFAULT NULL,
  `HDx20` int(10) DEFAULT NULL,
  `ATDEx20` int(10) DEFAULT NULL,
  `UPCCK` int(10) DEFAULT NULL,
  `HHBES_1` tinyint(3) DEFAULT NULL,
  `HHBES_2` tinyint(3) DEFAULT NULL,
  `HHBES_3` tinyint(3) DEFAULT NULL,
  `HHBES_4` tinyint(3) DEFAULT NULL,
  `HHBES_5` tinyint(3) DEFAULT NULL,
  `HHBES_6` tinyint(3) DEFAULT NULL,
  `HHBES_7` tinyint(3) DEFAULT NULL,
  `HHBES_8` tinyint(3) DEFAULT NULL,
  `HHBES_9` tinyint(3) DEFAULT NULL,
  `HHBES_10` tinyint(3) DEFAULT NULL,
  `HHBES_11` tinyint(3) DEFAULT NULL,
  `HHBES_12` tinyint(3) DEFAULT NULL,
  `HHBES_13` tinyint(3) DEFAULT NULL,
  `HHBES_14` tinyint(3) DEFAULT NULL,
  `HHBES_15` tinyint(3) DEFAULT NULL,
  `HHBES_16` tinyint(3) DEFAULT NULL,
  `HHBES_17` tinyint(3) DEFAULT NULL,
  `HHBES_18` tinyint(3) DEFAULT NULL,
  `HHBES_19` tinyint(3) DEFAULT NULL,
  `HHBES_20` tinyint(3) DEFAULT NULL,
  `HHBES_21` tinyint(3) DEFAULT NULL,
  `mainende` datetime DEFAULT NULL,
  `screen1` int(10) DEFAULT NULL,
  `screen2_1` int(10) DEFAULT NULL,
  `screen2_2` int(10) DEFAULT NULL,
  `screen2_3` int(10) DEFAULT NULL,
  `screen2_4` int(10) DEFAULT NULL,
  `ANZGRP_1` tinyint(3) DEFAULT NULL,
  `ANZGRP_2` tinyint(3) DEFAULT NULL,
  `ANZGRP_3` tinyint(3) DEFAULT NULL,
  `ANZGRP_4` tinyint(3) DEFAULT NULL,
  `ANZGES_1` int(10) DEFAULT NULL,
  `ANZSTAT_1` int(10) DEFAULT NULL,
  `ANZSTAT_2` int(10) DEFAULT NULL,
  `MINAGE_1` text COLLATE utf8_unicode_ci,
  `MINAGE_2` text COLLATE utf8_unicode_ci,
  `CHKANZP` tinyint(3) DEFAULT NULL,
  `BEZxAxS_1` text COLLATE utf8_unicode_ci,
  `BEZxAxS_2` text COLLATE utf8_unicode_ci,
  `BEZxAxS_3` text COLLATE utf8_unicode_ci,
  `BEZxAxS_4` text COLLATE utf8_unicode_ci,
  `BEZxAxS_5` text COLLATE utf8_unicode_ci,
  `BEZxAxS_6` text COLLATE utf8_unicode_ci,
  `BEZxAxS_7` text COLLATE utf8_unicode_ci,
  `BEZxAxS_8` text COLLATE utf8_unicode_ci,
  `BEZxAxS_9` text COLLATE utf8_unicode_ci,
  `MINxAGE_1` text COLLATE utf8_unicode_ci,
  `MINxAGE_2` text COLLATE utf8_unicode_ci,
  `MINxAGE_3` text COLLATE utf8_unicode_ci,
  `MINxAGE_4` text COLLATE utf8_unicode_ci,
  `MINxAGE_5` text COLLATE utf8_unicode_ci,
  `MINxAGE_6` text COLLATE utf8_unicode_ci,
  `MINxAGE_7` text COLLATE utf8_unicode_ci,
  `MINxAGE_8` text COLLATE utf8_unicode_ci,
  `MINxAGE_9` text COLLATE utf8_unicode_ci,
  `MAXxAGE_1` text COLLATE utf8_unicode_ci,
  `MAXxAGE_2` text COLLATE utf8_unicode_ci,
  `MAXxAGE_3` text COLLATE utf8_unicode_ci,
  `MAXxAGE_4` text COLLATE utf8_unicode_ci,
  `MAXxAGE_5` text COLLATE utf8_unicode_ci,
  `MAXxAGE_6` text COLLATE utf8_unicode_ci,
  `MAXxAGE_7` text COLLATE utf8_unicode_ci,
  `MAXxAGE_8` text COLLATE utf8_unicode_ci,
  `MAXxAGE_9` text COLLATE utf8_unicode_ci,
  `AGExP1_1` tinyint(3) DEFAULT NULL,
  `SEXxP1` tinyint(3) DEFAULT NULL,
  `AGExP2_1` tinyint(3) DEFAULT NULL,
  `SEXxP2` tinyint(3) DEFAULT NULL,
  `AGExP3_1` tinyint(3) DEFAULT NULL,
  `SEXxP3` tinyint(3) DEFAULT NULL,
  `AGExP4_1` tinyint(3) DEFAULT NULL,
  `SEXxP4` tinyint(3) DEFAULT NULL,
  `AGExP5_1` tinyint(3) DEFAULT NULL,
  `SEXxP5` tinyint(3) DEFAULT NULL,
  `AGExP6_1` tinyint(3) DEFAULT NULL,
  `SEXxP6` tinyint(3) DEFAULT NULL,
  `AGExP7_1` tinyint(3) DEFAULT NULL,
  `SEXxP7` tinyint(3) DEFAULT NULL,
  `AGExP8_1` tinyint(3) DEFAULT NULL,
  `SEXxP8` tinyint(3) DEFAULT NULL,
  `AGExP9_1` tinyint(3) DEFAULT NULL,
  `SEXxP9` tinyint(3) DEFAULT NULL,
  `ANZU14_1` int(10) DEFAULT NULL,
  `LISTEPERS_1` tinyint(3) DEFAULT NULL,
  `LISTEPERS_2` tinyint(3) DEFAULT NULL,
  `LISTEPERS_3` tinyint(3) DEFAULT NULL,
  `LISTEPERS_4` tinyint(3) DEFAULT NULL,
  `LISTEPERS_5` tinyint(3) DEFAULT NULL,
  `LISTEPERS_6` tinyint(3) DEFAULT NULL,
  `LISTEPERS_7` tinyint(3) DEFAULT NULL,
  `LISTEPERS_8` tinyint(3) DEFAULT NULL,
  `LISTEPERS_9` tinyint(3) DEFAULT NULL,
  `LISTEPERS_opn1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LISTEPERS_opn2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LISTEPERS_opn3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LISTEPERS_opn4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LISTEPERS_opn5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LISTEPERS_opn6` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LISTEPERS_opn7` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LISTEPERS_opn8` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LISTEPERS_opn9` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NRRESP` tinyint(3) DEFAULT NULL,
  `NRHHV` tinyint(3) DEFAULT NULL,
  `NRHHF_1` tinyint(3) DEFAULT NULL,
  `NRHHF_2` tinyint(3) DEFAULT NULL,
  `NRHHF_3` tinyint(3) DEFAULT NULL,
  `NRHHF_4` tinyint(3) DEFAULT NULL,
  `NRHHF_5` tinyint(3) DEFAULT NULL,
  `NRHHF_6` tinyint(3) DEFAULT NULL,
  `NRHHF_7` tinyint(3) DEFAULT NULL,
  `NRHHF_8` tinyint(3) DEFAULT NULL,
  `NRHHF_9` tinyint(3) DEFAULT NULL,
  `LPERS2_1` tinyint(3) DEFAULT NULL,
  `LPERS2_2` tinyint(3) DEFAULT NULL,
  `LPERS2_3` tinyint(3) DEFAULT NULL,
  `LPERS2_4` tinyint(3) DEFAULT NULL,
  `LPERS2_5` tinyint(3) DEFAULT NULL,
  `LPERS2_6` tinyint(3) DEFAULT NULL,
  `LPERS2_7` tinyint(3) DEFAULT NULL,
  `LPERS2_8` tinyint(3) DEFAULT NULL,
  `LPERS2_9` tinyint(3) DEFAULT NULL,
  `LPERS2_opn1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LPERS2_opn2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LPERS2_opn3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LPERS2_opn4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LPERS2_opn5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LPERS2_opn6` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LPERS2_opn7` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LPERS2_opn8` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LPERS2_opn9` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ALTERxP1_1` tinyint(3) DEFAULT NULL,
  `GESCHLxP1` tinyint(3) DEFAULT NULL,
  `BEZxP1_1` text COLLATE utf8_unicode_ci,
  `TAETxP1` tinyint(3) DEFAULT NULL,
  `TAETFxP1` tinyint(3) DEFAULT NULL,
  `BERUFxP1` tinyint(3) DEFAULT NULL,
  `BEAMTExP1` tinyint(3) DEFAULT NULL,
  `STANDxP1` tinyint(3) DEFAULT NULL,
  `EDUCxP1` tinyint(3) DEFAULT NULL,
  `STAATSBxP1` tinyint(3) DEFAULT NULL,
  `STAATSBxP1_opn` text COLLATE utf8_unicode_ci,
  `GEBLANDxP1` tinyint(3) DEFAULT NULL,
  `GEBLANDxP1_opn` text COLLATE utf8_unicode_ci,
  `GLMUTTxP1` tinyint(3) DEFAULT NULL,
  `GLMUTTxP1_opn` text COLLATE utf8_unicode_ci,
  `GLVATxP1` tinyint(3) DEFAULT NULL,
  `GLVATxP1_opn` text COLLATE utf8_unicode_ci,
  `ALTERxP2_1` tinyint(3) DEFAULT NULL,
  `GESCHLxP2` tinyint(3) DEFAULT NULL,
  `BEZxP2_1` text COLLATE utf8_unicode_ci,
  `TAETxP2` tinyint(3) DEFAULT NULL,
  `TAETFxP2` tinyint(3) DEFAULT NULL,
  `BERUFxP2` tinyint(3) DEFAULT NULL,
  `BEAMTExP2` tinyint(3) DEFAULT NULL,
  `STANDxP2` tinyint(3) DEFAULT NULL,
  `EDUCxP2` tinyint(3) DEFAULT NULL,
  `STAATSBxP2` tinyint(3) DEFAULT NULL,
  `STAATSBxP2_opn` text COLLATE utf8_unicode_ci,
  `GEBLANDxP2` tinyint(3) DEFAULT NULL,
  `GEBLANDxP2_opn` text COLLATE utf8_unicode_ci,
  `GLMUTTxP2` tinyint(3) DEFAULT NULL,
  `GLMUTTxP2_opn` text COLLATE utf8_unicode_ci,
  `GLVATxP2` tinyint(3) DEFAULT NULL,
  `GLVATxP2_opn` text COLLATE utf8_unicode_ci,
  `ALTERxP3_1` tinyint(3) DEFAULT NULL,
  `GESCHLxP3` tinyint(3) DEFAULT NULL,
  `BEZxP3_1` text COLLATE utf8_unicode_ci,
  `TAETxP3` tinyint(3) DEFAULT NULL,
  `BERUFxP3` tinyint(3) DEFAULT NULL,
  `STANDxP3` tinyint(3) DEFAULT NULL,
  `EDUCxP3` tinyint(3) DEFAULT NULL,
  `STAATSBxP3` tinyint(3) DEFAULT NULL,
  `STAATSBxP3_opn` text COLLATE utf8_unicode_ci,
  `GEBLANDxP3` tinyint(3) DEFAULT NULL,
  `GEBLANDxP3_opn` text COLLATE utf8_unicode_ci,
  `GLMUTTxP3` tinyint(3) DEFAULT NULL,
  `GLMUTTxP3_opn` text COLLATE utf8_unicode_ci,
  `GLVATxP3` tinyint(3) DEFAULT NULL,
  `GLVATxP3_opn` text COLLATE utf8_unicode_ci,
  `ALTERxP4_1` tinyint(3) DEFAULT NULL,
  `GESCHLxP4` tinyint(3) DEFAULT NULL,
  `BEZxP4_1` text COLLATE utf8_unicode_ci,
  `TAETxP4` tinyint(3) DEFAULT NULL,
  `BERUFxP4` tinyint(3) DEFAULT NULL,
  `STANDxP4` tinyint(3) DEFAULT NULL,
  `EDUCxP4` tinyint(3) DEFAULT NULL,
  `STAATSBxP4` tinyint(3) DEFAULT NULL,
  `STAATSBxP4_opn` text COLLATE utf8_unicode_ci,
  `GEBLANDxP4` tinyint(3) DEFAULT NULL,
  `GEBLANDxP4_opn` text COLLATE utf8_unicode_ci,
  `GLMUTTxP4` tinyint(3) DEFAULT NULL,
  `GLMUTTxP4_opn` text COLLATE utf8_unicode_ci,
  `GLVATxP4` tinyint(3) DEFAULT NULL,
  `GLVATxP4_opn` text COLLATE utf8_unicode_ci,
  `ALTERxP5_1` tinyint(3) DEFAULT NULL,
  `GESCHLxP5` tinyint(3) DEFAULT NULL,
  `BEZxP5_1` text COLLATE utf8_unicode_ci,
  `TAETxP5` tinyint(3) DEFAULT NULL,
  `BERUFxP5` tinyint(3) DEFAULT NULL,
  `STANDxP5` tinyint(3) DEFAULT NULL,
  `EDUCxP5` tinyint(3) DEFAULT NULL,
  `STAATSBxP5` tinyint(3) DEFAULT NULL,
  `STAATSBxP5_opn` text COLLATE utf8_unicode_ci,
  `GEBLANDxP5` tinyint(3) DEFAULT NULL,
  `GEBLANDxP5_opn` text COLLATE utf8_unicode_ci,
  `GLMUTTxP5` tinyint(3) DEFAULT NULL,
  `GLMUTTxP5_opn` text COLLATE utf8_unicode_ci,
  `GLVATxP5` tinyint(3) DEFAULT NULL,
  `GLVATxP5_opn` text COLLATE utf8_unicode_ci,
  `ALTERxP6_1` tinyint(3) DEFAULT NULL,
  `GESCHLxP6` tinyint(3) DEFAULT NULL,
  `BEZxP6_1` text COLLATE utf8_unicode_ci,
  `TAETxP6` tinyint(3) DEFAULT NULL,
  `BERUFxP6` tinyint(3) DEFAULT NULL,
  `STANDxP6` tinyint(3) DEFAULT NULL,
  `EDUCxP6` tinyint(3) DEFAULT NULL,
  `STAATSBxP6` tinyint(3) DEFAULT NULL,
  `STAATSBxP6_opn` text COLLATE utf8_unicode_ci,
  `GEBLANDxP6` tinyint(3) DEFAULT NULL,
  `GEBLANDxP6_opn` text COLLATE utf8_unicode_ci,
  `GLMUTTxP6` tinyint(3) DEFAULT NULL,
  `GLMUTTxP6_opn` text COLLATE utf8_unicode_ci,
  `GLVATxP6` tinyint(3) DEFAULT NULL,
  `GLVATxP6_opn` text COLLATE utf8_unicode_ci,
  `ALTERxP7_1` tinyint(3) DEFAULT NULL,
  `GESCHLxP7` tinyint(3) DEFAULT NULL,
  `BEZxP7_1` text COLLATE utf8_unicode_ci,
  `TAETxP7` tinyint(3) DEFAULT NULL,
  `BERUFxP7` tinyint(3) DEFAULT NULL,
  `STANDxP7` tinyint(3) DEFAULT NULL,
  `EDUCxP7` tinyint(3) DEFAULT NULL,
  `STAATSBxP7` tinyint(3) DEFAULT NULL,
  `STAATSBxP7_opn` text COLLATE utf8_unicode_ci,
  `GEBLANDxP7` tinyint(3) DEFAULT NULL,
  `GEBLANDxP7_opn` text COLLATE utf8_unicode_ci,
  `GLMUTTxP7` tinyint(3) DEFAULT NULL,
  `GLMUTTxP7_opn` text COLLATE utf8_unicode_ci,
  `GLVATxP7` tinyint(3) DEFAULT NULL,
  `GLVATxP7_opn` text COLLATE utf8_unicode_ci,
  `ALTERxP8_1` tinyint(3) DEFAULT NULL,
  `GESCHLxP8` tinyint(3) DEFAULT NULL,
  `BEZxP8_1` text COLLATE utf8_unicode_ci,
  `TAETxP8` tinyint(3) DEFAULT NULL,
  `BERUFxP8` tinyint(3) DEFAULT NULL,
  `STANDxP8` tinyint(3) DEFAULT NULL,
  `EDUCxP8` tinyint(3) DEFAULT NULL,
  `STAATSBxP8` tinyint(3) DEFAULT NULL,
  `STAATSBxP8_opn` text COLLATE utf8_unicode_ci,
  `GEBLANDxP8` tinyint(3) DEFAULT NULL,
  `GEBLANDxP8_opn` text COLLATE utf8_unicode_ci,
  `GLMUTTxP8` tinyint(3) DEFAULT NULL,
  `GLMUTTxP8_opn` text COLLATE utf8_unicode_ci,
  `GLVATxP8` tinyint(3) DEFAULT NULL,
  `GLVATxP8_opn` text COLLATE utf8_unicode_ci,
  `ALTERxP9_1` tinyint(3) DEFAULT NULL,
  `GESCHLxP9` tinyint(3) DEFAULT NULL,
  `BEZxP9_1` text COLLATE utf8_unicode_ci,
  `TAETxP9` tinyint(3) DEFAULT NULL,
  `BERUFxP9` tinyint(3) DEFAULT NULL,
  `STANDxP9` tinyint(3) DEFAULT NULL,
  `EDUCxP9` tinyint(3) DEFAULT NULL,
  `STAATSBxP9` tinyint(3) DEFAULT NULL,
  `STAATSBxP9_opn` text COLLATE utf8_unicode_ci,
  `GEBLANDxP9` tinyint(3) DEFAULT NULL,
  `GEBLANDxP9_opn` text COLLATE utf8_unicode_ci,
  `GLMUTTxP9` tinyint(3) DEFAULT NULL,
  `GLMUTTxP9_opn` text COLLATE utf8_unicode_ci,
  `GLVATxP9` tinyint(3) DEFAULT NULL,
  `GLVATxP9_opn` text COLLATE utf8_unicode_ci,
  `timevdbend` datetime DEFAULT NULL,
  `ANZVER_1` tinyint(3) DEFAULT NULL,
  `ZPNETT` tinyint(3) DEFAULT NULL,
  `HHNETT` tinyint(3) DEFAULT NULL,
  `TELCON` tinyint(3) DEFAULT NULL,
  `TELCON_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `statende` datetime DEFAULT NULL,
  `poln9` tinyint(3) DEFAULT NULL,
  `poln10` tinyint(3) DEFAULT NULL,
  `poln11_1` tinyint(3) DEFAULT NULL,
  `poln11_2` tinyint(3) DEFAULT NULL,
  `poln11_3` tinyint(3) DEFAULT NULL,
  `poln11_4` tinyint(3) DEFAULT NULL,
  `poln11_5` tinyint(3) DEFAULT NULL,
  `poln12` tinyint(3) DEFAULT NULL,
  `poln13` tinyint(3) DEFAULT NULL,
  `poln19` tinyint(3) DEFAULT NULL,
  `poln19_opn` text COLLATE utf8_unicode_ci,
  `poln20` tinyint(3) DEFAULT NULL,
  `poln20_opn` int(10) DEFAULT NULL,
  `poln20a` int(10) DEFAULT NULL,
  `poln22` tinyint(3) DEFAULT NULL,
  `polende` datetime DEFAULT NULL,
  `ttstart` int(10) DEFAULT NULL,
  `tt1` int(10) DEFAULT NULL,
  `tt2_1` int(10) DEFAULT NULL,
  `tt2_2` int(10) DEFAULT NULL,
  `tt2_3` int(10) DEFAULT NULL,
  `tt2_4` int(10) DEFAULT NULL,
  `tt2_5` int(10) DEFAULT NULL,
  `tt2_6` int(10) DEFAULT NULL,
  `tt2_7` int(10) DEFAULT NULL,
  `tt2_8` int(10) DEFAULT NULL,
  `tt2_9` int(10) DEFAULT NULL,
  `tt3` int(10) DEFAULT NULL,
  `tt4` int(10) DEFAULT NULL,
  `tt5` int(10) DEFAULT NULL,
  `tt6_1` int(10) DEFAULT NULL,
  `tt6a` int(10) DEFAULT NULL,
  `tt7` int(10) DEFAULT NULL,
  `tt8x1_1` text COLLATE utf8_unicode_ci,
  `tt8ax1` int(10) DEFAULT NULL,
  `tt8x2_1` text COLLATE utf8_unicode_ci,
  `tt8ax2` int(10) DEFAULT NULL,
  `tt8x3_1` text COLLATE utf8_unicode_ci,
  `tt8ax3` int(10) DEFAULT NULL,
  `tt8x4_1` text COLLATE utf8_unicode_ci,
  `tt8ax4` int(10) DEFAULT NULL,
  `tt8x5_1` text COLLATE utf8_unicode_ci,
  `tt8ax5` int(10) DEFAULT NULL,
  `tt8x6_1` text COLLATE utf8_unicode_ci,
  `tt8ax6` int(10) DEFAULT NULL,
  `tt8x7_1` text COLLATE utf8_unicode_ci,
  `tt8ax7` int(10) DEFAULT NULL,
  `tt8x8_1` text COLLATE utf8_unicode_ci,
  `tt8ax8` int(10) DEFAULT NULL,
  `tt8x9_1` text COLLATE utf8_unicode_ci,
  `tt8ax9` int(10) DEFAULT NULL,
  `tt9` int(10) DEFAULT NULL,
  `tt10` int(10) DEFAULT NULL,
  `tt11` int(10) DEFAULT NULL,
  `tt12_1` text COLLATE utf8_unicode_ci,
  `tt12_2` text COLLATE utf8_unicode_ci,
  `tt12_3` text COLLATE utf8_unicode_ci,
  `tt12_4` text COLLATE utf8_unicode_ci,
  `tt12_5` text COLLATE utf8_unicode_ci,
  `ttend` datetime DEFAULT NULL,
  `r1` int(10) DEFAULT NULL,
  `r2_1` text COLLATE utf8_unicode_ci,
  `rage_1` int(10) DEFAULT NULL,
  `rsex` int(10) DEFAULT NULL,
  `redu` int(10) DEFAULT NULL,
  `rjob` int(10) DEFAULT NULL,
  `kondata_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `kondata_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `kondata_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `kondata_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `kondata_5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `kondata_6` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `kondata_7` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `kondata_8` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `streetname_1` text COLLATE utf8_unicode_ci,
  `structureid_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `source_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `source_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `source_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `source_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `resp_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `resp_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `resp_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `resp_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `resp_5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `iv_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `iv_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `iv_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `formdata_1` text COLLATE utf8_unicode_ci,
  `checkq` int(10) DEFAULT NULL,
  `checkdummy` int(10) DEFAULT NULL,
  `CoronaTS` datetime DEFAULT NULL,
  `vernr_1` text COLLATE utf8_unicode_ci,
  `intnr_1` text COLLATE utf8_unicode_ci,
  `verng2` tinyint(3) DEFAULT NULL,
  `verng2_opn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `verende` datetime DEFAULT NULL,
  `verng1_1` int(10) DEFAULT NULL,
  `BREAK` tinyint(3) DEFAULT NULL,
  `ENDIV` tinyint(3) DEFAULT NULL,
  `fbende` datetime DEFAULT NULL,
  `DEVINT_1` int(10) DEFAULT NULL,
  `DEVINT_2` int(10) DEFAULT NULL,
  `DEVINT_3` int(10) DEFAULT NULL,
  `DEVINT_4` int(10) DEFAULT NULL,
  `KOSTSTREAM_11` tinyint(3) DEFAULT NULL,
  `KOSTSTREAM_opn10` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `APPSxTV1_29` int(10) DEFAULT NULL,
  `APPSxTV1_30` int(10) DEFAULT NULL,
  `APPSxTV2_29` int(10) DEFAULT NULL,
  `APPSxTV2_30` int(10) DEFAULT NULL,
  `APPSxTV3_29` int(10) DEFAULT NULL,
  `APPSxTV3_30` int(10) DEFAULT NULL,
  `APPSxTV4_29` int(10) DEFAULT NULL,
  `APPSxTV4_30` int(10) DEFAULT NULL,
  `APPSxTV5_29` int(10) DEFAULT NULL,
  `APPSxTV5_30` int(10) DEFAULT NULL,
  `APPSxTV6_29` int(10) DEFAULT NULL,
  `APPSxTV6_30` int(10) DEFAULT NULL,
  `DUMNUTZT_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DUMNUTZT_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DUMNUTZT_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DUMNUTZT_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DUMNUTZT_5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DUMNUTZT_6` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NUTZTxP1_1` int(10) DEFAULT NULL,
  `NUTZTxP1_2` int(10) DEFAULT NULL,
  `NUTZTxP1_3` int(10) DEFAULT NULL,
  `NUTZTxP1_4` int(10) DEFAULT NULL,
  `NUTZTxP1_5` int(10) DEFAULT NULL,
  `NUTZTxP1_6` int(10) DEFAULT NULL,
  `NUTZTxP2_1` int(10) DEFAULT NULL,
  `NUTZTxP2_2` int(10) DEFAULT NULL,
  `NUTZTxP2_3` int(10) DEFAULT NULL,
  `NUTZTxP2_4` int(10) DEFAULT NULL,
  `NUTZTxP2_5` int(10) DEFAULT NULL,
  `NUTZTxP2_6` int(10) DEFAULT NULL,
  `NUTZTxP9_1` int(10) DEFAULT NULL,
  `NUTZTxP9_2` int(10) DEFAULT NULL,
  `NUTZTxP9_3` int(10) DEFAULT NULL,
  `NUTZTxP9_4` int(10) DEFAULT NULL,
  `NUTZTxP9_5` int(10) DEFAULT NULL,
  `NUTZTxP9_6` int(10) DEFAULT NULL,
  `NUTZTxP8_1` int(10) DEFAULT NULL,
  `NUTZTxP8_2` int(10) DEFAULT NULL,
  `NUTZTxP8_3` int(10) DEFAULT NULL,
  `NUTZTxP8_4` int(10) DEFAULT NULL,
  `NUTZTxP8_5` int(10) DEFAULT NULL,
  `NUTZTxP8_6` int(10) DEFAULT NULL,
  `NUTZTxP7_1` int(10) DEFAULT NULL,
  `NUTZTxP7_2` int(10) DEFAULT NULL,
  `NUTZTxP7_3` int(10) DEFAULT NULL,
  `NUTZTxP7_4` int(10) DEFAULT NULL,
  `NUTZTxP7_5` int(10) DEFAULT NULL,
  `NUTZTxP7_6` int(10) DEFAULT NULL,
  `NUTZTxP6_1` int(10) DEFAULT NULL,
  `NUTZTxP6_2` int(10) DEFAULT NULL,
  `NUTZTxP6_3` int(10) DEFAULT NULL,
  `NUTZTxP6_4` int(10) DEFAULT NULL,
  `NUTZTxP6_5` int(10) DEFAULT NULL,
  `NUTZTxP6_6` int(10) DEFAULT NULL,
  `NUTZTxP5_1` int(10) DEFAULT NULL,
  `NUTZTxP5_2` int(10) DEFAULT NULL,
  `NUTZTxP5_3` int(10) DEFAULT NULL,
  `NUTZTxP5_4` int(10) DEFAULT NULL,
  `NUTZTxP5_5` int(10) DEFAULT NULL,
  `NUTZTxP5_6` int(10) DEFAULT NULL,
  `NUTZTxP4_1` int(10) DEFAULT NULL,
  `NUTZTxP4_2` int(10) DEFAULT NULL,
  `NUTZTxP4_3` int(10) DEFAULT NULL,
  `NUTZTxP4_4` int(10) DEFAULT NULL,
  `NUTZTxP4_5` int(10) DEFAULT NULL,
  `NUTZTxP4_6` int(10) DEFAULT NULL,
  `NUTZTxP3_1` int(10) DEFAULT NULL,
  `NUTZTxP3_2` int(10) DEFAULT NULL,
  `NUTZTxP3_3` int(10) DEFAULT NULL,
  `NUTZTxP3_4` int(10) DEFAULT NULL,
  `NUTZTxP3_5` int(10) DEFAULT NULL,
  `NUTZTxP3_6` int(10) DEFAULT NULL,
  `APPSxTV1_31` int(10) DEFAULT NULL,
  `APPSxTV2_31` int(10) DEFAULT NULL,
  `APPSxTV3_31` int(10) DEFAULT NULL,
  `APPSxTV4_31` int(10) DEFAULT NULL,
  `APPSxTV6_31` int(10) DEFAULT NULL,
  `APPSxTV5_31` int(10) DEFAULT NULL,
  `Projektdaten_26` text COLLATE utf8_unicode_ci,
  `Projektdaten_27` text COLLATE utf8_unicode_ci,
  `Projektdaten_28` text COLLATE utf8_unicode_ci,
  `Projektdaten_29` text COLLATE utf8_unicode_ci,
  `Projektdaten_30` text COLLATE utf8_unicode_ci,
  `kondata_9` 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=22 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
<stat>CREATE TABLE `p27293122___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=2750 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
<stat>CREATE TABLE IF NOT EXISTS `p27293122___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 = 38
<stat>DELETE FROM `p27293122___sample`
<stat>DELETE FROM _CapiTables WHERE id = 15
<stat>INSERT INTO _CapiTables SET id = '15',id_sup = '0',name = 'adr27293122',sts_reg = '0',sts_ac = '0',reserved_numbers = '',flag_sample = '0',orderBy = '2',is_leaf = '1'
<stat>DROP TABLE IF EXISTS capi___adr27293122
<stat>CREATE TABLE IF NOT EXISTS `capi___adr27293122` (
  `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_PB` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `capi_OG` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `capi_BL` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `capi_hnr` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `capi_intein` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `capi_vorwahl` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `capi_telnr` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `capi_ID_POST` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `capi_gkz` varchar(255) 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=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
<stat>INSERT INTO capi___adr27293122 SET id = '13',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 = '1625210783',proj_reserved = '38',tdisable = '0',capi_PB = '9',capi_OG = '9',capi_BL = '9',capi_hnr = 'Nr. 13',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '',capi_gkz = '';
<stat>INSERT INTO capi___adr27293122 SET id = '14',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 = '1625210783',proj_reserved = '38',tdisable = '0',capi_PB = '9',capi_OG = '9',capi_BL = '9',capi_hnr = 'Nr. 14',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '',capi_gkz = '';
<stat>INSERT INTO capi___adr27293122 SET id = '15',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 = '1625210783',proj_reserved = '38',tdisable = '0',capi_PB = '9',capi_OG = '9',capi_BL = '9',capi_hnr = 'Nr. 15',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '',capi_gkz = '';
<stat>INSERT INTO capi___adr27293122 SET id = '16',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 = '1625210783',proj_reserved = '38',tdisable = '0',capi_PB = '9',capi_OG = '9',capi_BL = '9',capi_hnr = 'Nr. 16',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '',capi_gkz = '';
<stat>INSERT INTO capi___adr27293122 SET id = '17',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 = '1625210783',proj_reserved = '38',tdisable = '0',capi_PB = '9',capi_OG = '9',capi_BL = '9',capi_hnr = 'Nr. 17',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '',capi_gkz = '';
<stat>INSERT INTO capi___adr27293122 SET id = '18',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 = '1625210783',proj_reserved = '38',tdisable = '0',capi_PB = '9',capi_OG = '9',capi_BL = '9',capi_hnr = 'Nr. 18',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '',capi_gkz = '';
<stat>INSERT INTO capi___adr27293122 SET id = '19',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 = '1625210783',proj_reserved = '38',tdisable = '0',capi_PB = '9',capi_OG = '9',capi_BL = '9',capi_hnr = 'Nr. 19',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '',capi_gkz = '';
<stat>INSERT INTO capi___adr27293122 SET id = '20',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 = '1625210783',proj_reserved = '38',tdisable = '0',capi_PB = '9',capi_OG = '9',capi_BL = '9',capi_hnr = 'Nr. 20',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '',capi_gkz = '';
<stat>INSERT INTO capi___adr27293122 SET id = '21',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 = '1625210783',proj_reserved = '38',tdisable = '0',capi_PB = '9',capi_OG = '9',capi_BL = '9',capi_hnr = 'Nr. 21',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '',capi_gkz = '';
<stat>INSERT INTO capi___adr27293122 SET id = '22',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 = '1625210783',proj_reserved = '38',tdisable = '0',capi_PB = '9',capi_OG = '9',capi_BL = '9',capi_hnr = 'Nr. 22',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '',capi_gkz = '';
<stat>INSERT INTO capi___adr27293122 SET id = '23',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 = '1625210783',proj_reserved = '38',tdisable = '0',capi_PB = '9',capi_OG = '9',capi_BL = '9',capi_hnr = 'Nr. 23',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '',capi_gkz = '';
<stat>INSERT INTO capi___adr27293122 SET id = '24',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 = '1625210783',proj_reserved = '38',tdisable = '0',capi_PB = '9',capi_OG = '9',capi_BL = '9',capi_hnr = 'Nr. 24',capi_intein = 'test',capi_vorwahl = '',capi_telnr = '',capi_ID_POST = '',capi_gkz = '';
<stat>INSERT INTO p27293122___sample SET id = '1',tdisable = '0',id_sample = '13',id_sampleTable = '15',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO p27293122___sample SET id = '2',tdisable = '0',id_sample = '14',id_sampleTable = '15',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO p27293122___sample SET id = '3',tdisable = '0',id_sample = '15',id_sampleTable = '15',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO p27293122___sample SET id = '4',tdisable = '0',id_sample = '16',id_sampleTable = '15',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO p27293122___sample SET id = '5',tdisable = '0',id_sample = '17',id_sampleTable = '15',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO p27293122___sample SET id = '6',tdisable = '0',id_sample = '18',id_sampleTable = '15',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO p27293122___sample SET id = '7',tdisable = '0',id_sample = '19',id_sampleTable = '15',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO p27293122___sample SET id = '8',tdisable = '0',id_sample = '20',id_sampleTable = '15',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO p27293122___sample SET id = '9',tdisable = '0',id_sample = '21',id_sampleTable = '15',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO p27293122___sample SET id = '10',tdisable = '0',id_sample = '22',id_sampleTable = '15',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO p27293122___sample SET id = '11',tdisable = '0',id_sample = '23',id_sampleTable = '15',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>INSERT INTO p27293122___sample SET id = '12',tdisable = '0',id_sample = '24',id_sampleTable = '15',user_id = '6',user_type = '0',planned_visit_time = '0',num_interviews = '1';
<stat>REPLACE INTO _Projects SET id = '38',key_proj = '38-m7gakwzl1m',proj_name = 'p27293122',language = '60',naziv_proj = 'Teletest Q3/2021',old = 'N',created = '14.06.2021 - 14:33',creat_name = 'Alexander Hitzinger',modify = '14.06.2021 - 14:33',modi_name = 'Alexander Hitzinger',active = '1',start_date = '2021-06-14 00:00:00',end_date = '2022-06-14 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 = '15',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 = '0',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 = 'TT Q3/2021',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 = '38',id_sup = '0',id_project = '38',orderBy = '0',idLab = 'p27293122',node_img = '',is_leaf = '1',merged = '0';
<stat>DELETE FROM  _LanguageProjects WHERE id_project = 38;
<stat>DELETE FROM  _LanguageUserInterface WHERE id_project IN (0, 38);
<stat>DELETE FROM  _QuestionRotation WHERE id_project = 38;
<stat>DELETE FROM  _ProjectExtraVariables  WHERE id_project = 38;
<stat>INSERT INTO _LanguageProjects  SET id_language = '60',id_project = '38';
<stat>INSERT INTO _QuestionRotation SET id = '134',id_project = '38',id_sup = '0',idLab = '',orderBy = '1',id_complex = '0',id_packet = '0',id_question = '0',type = '0',is_rotated = '0';
<stat>INSERT INTO _QuestionRotation SET id = '135',id_project = '38',id_sup = '134',idLab = '',orderBy = '1',id_complex = '0',id_packet = '0',id_question = '0',type = '1',is_rotated = '0';
<stat>INSERT INTO _QuestionRotation SET id = '137',id_project = '38',id_sup = '134',idLab = '',orderBy = '2',id_complex = '0',id_packet = '0',id_question = '0',type = '1',is_rotated = '0';
<stat>INSERT INTO _QuestionRotation SET id = '136',id_project = '38',id_sup = '135',idLab = '',orderBy = '171',id_complex = '134',id_packet = '0',id_question = '1234',type = '2',is_rotated = '0';
<stat>INSERT INTO _QuestionRotation SET id = '138',id_project = '38',id_sup = '137',idLab = '',orderBy = '172',id_complex = '134',id_packet = '0',id_question = '1236',type = '2',is_rotated = '0';