CREATE TABLE EOF_big_t1 (
  `time` bigint(20) NOT NULL,
  `psn` bigint(20) NOT NULL DEFAULT '0',
  `start` bigint(20) NOT NULL DEFAULT '0',
  `end` bigint(20) NOT NULL DEFAULT '0',
  `reloaded` tinyint(1) NOT NULL DEFAULT '0',
  `rattype` smallint(6) NOT NULL DEFAULT '-1',
  `record_start` bigint(20) NOT NULL DEFAULT '0',
  `record_end` bigint(20) NOT NULL DEFAULT '0',
  `duration_s` bigint(20) NOT NULL DEFAULT '0',
  `lac` mediumint(9) NOT NULL DEFAULT '-1',
  `rac` smallint(6) NOT NULL DEFAULT '-1',
  `cellid_or_sac` mediumint(9) NOT NULL DEFAULT '-1',
  `eci` int(11) NOT NULL DEFAULT '-1',
  `apnname` int(11) NOT NULL DEFAULT '-1',
  `uplink_ip_ipv4_ipv6` char(45) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `downlink_ip_ipv4_ipv6` char(45) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `imsibcd` bigint(20) NOT NULL DEFAULT '0',
  `msisdnbcd` bigint(20) NOT NULL DEFAULT '0',
  `msisdn` char(32) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `msisdn_raw` char(32) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `imei_sv_bcd` bigint(20) NOT NULL DEFAULT '0',
  `pdpactivation` bigint(20) NOT NULL DEFAULT '0',
  `uplink_start` bigint(20) NOT NULL DEFAULT '0',
  `uplink_end` bigint(20) NOT NULL DEFAULT '0',
  `downlink_start` bigint(20) NOT NULL DEFAULT '0',
  `downlink_end` bigint(20) NOT NULL DEFAULT '0',
  `dlnode` int(11) NOT NULL DEFAULT '-1',
  `ulnode` int(11) NOT NULL DEFAULT '-1',
  `uplink_ip` int(11) NOT NULL DEFAULT '-1',
  `downlink_ip` int(11) NOT NULL DEFAULT '-1',
  `hostipaddr` int(11) NOT NULL DEFAULT '-1',
  `mobileipaddr` int(11) NOT NULL DEFAULT '-1',
  `hostipv6addr` char(39) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `mobileipv6addr` char(39) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `uplink_port` int(11) NOT NULL DEFAULT '-1',
  `downlink_port` int(11) NOT NULL DEFAULT '-1',
  `pdpnsapi` tinyint(4) NOT NULL DEFAULT '-1',
  `uplink_teid` bigint(20) NOT NULL DEFAULT '-1',
  `downlink_teid` bigint(20) NOT NULL DEFAULT '-1',
  `vlan` smallint(6) NOT NULL DEFAULT '-1',
  `transport_protocol` smallint(6) NOT NULL DEFAULT '-1',
  `mud_direction` tinyint(4) NOT NULL DEFAULT '-1',
  `directtunnelind` tinyint(4) NOT NULL DEFAULT '-1',
  `precedence` tinyint(4) NOT NULL DEFAULT '-1',
  `uplink_fragmentation` tinyint(1) NOT NULL DEFAULT '0',
  `downlink_fragmentation` tinyint(1) NOT NULL DEFAULT '0',
  `reason` smallint(6) NOT NULL DEFAULT '-1',
  `traffic_handling_priority` tinyint(4) NOT NULL DEFAULT '-1',
  `traffic_class` tinyint(4) NOT NULL DEFAULT '-1',
  `qos_qci` tinyint(4) NOT NULL DEFAULT '-1',
  `ulpackets` bigint(20) NOT NULL DEFAULT '0',
  `dlpackets` bigint(20) NOT NULL DEFAULT '0',
  `ulbytes` bigint(20) NOT NULL DEFAULT '0',
  `dlbytes` bigint(20) NOT NULL DEFAULT '0',
  `ulretransmits` bigint(20) NOT NULL DEFAULT '0',
  `dlretransmits` bigint(20) NOT NULL DEFAULT '0',
  `ul_retransmit_ratio` bigint(20) NOT NULL DEFAULT '0',
  `dl_retransmit_ratio` bigint(20) NOT NULL DEFAULT '0',
  `ulfragments` bigint(20) NOT NULL DEFAULT '0',
  `dlfragments` bigint(20) NOT NULL DEFAULT '0',
  `ulfragmentedpackets` bigint(20) NOT NULL DEFAULT '0',
  `dlfragmentedpackets` bigint(20) NOT NULL DEFAULT '0',
  `queryname` char(101) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `dns_cause` mediumint(9) NOT NULL DEFAULT '-1',
  `resolvedaddress` bigint(20) NOT NULL DEFAULT '0',
  `dns_lookup_time` bigint(20) NOT NULL DEFAULT '0',
  `tacid_` int(11) NOT NULL DEFAULT '-1',
  `ulnode_id` int(11) NOT NULL DEFAULT '-1',
  `dlnode_id` int(11) NOT NULL DEFAULT '-1',
  `sgsn_id` int(11) NOT NULL DEFAULT '-1',
  `ggsn_id` int(11) NOT NULL DEFAULT '-1',
  `categoryid` int(11) NOT NULL DEFAULT '-1',
  `traffic_category` tinyint(4) NOT NULL DEFAULT '-1',
  `bsc_rnc_id` int(11) NOT NULL DEFAULT '-1',
  `cell` int(11) NOT NULL DEFAULT '-1',
  `cell_group` int(11) NOT NULL DEFAULT '-1',
  `ltetac` int(11) NOT NULL DEFAULT '-1',
  `enodeb` int(11) NOT NULL DEFAULT '-1',
  `tac_topo` int(11) NOT NULL DEFAULT '-1',
  `tcp_control` smallint(6) NOT NULL DEFAULT '-1',
  `tcp_syn` bigint(20) NOT NULL DEFAULT '0',
  `tcp_synack` bigint(20) NOT NULL DEFAULT '0',
  `tcp_ack` bigint(20) NOT NULL DEFAULT '0',
  `tcp_fin` bigint(20) NOT NULL DEFAULT '0',
  `tcp_rst` bigint(20) NOT NULL DEFAULT '0',
  `service` tinyint(4) NOT NULL DEFAULT '-1',
  `host_id` int(11) NOT NULL DEFAULT '-1',
  `apnid` int(11) NOT NULL DEFAULT '-1',
  `iana_application` int(11) NOT NULL DEFAULT '-1',
  `ul_flow_size` int(11) NOT NULL DEFAULT '-1',
  `dl_flow_size` int(11) NOT NULL DEFAULT '-1',
  `udp_attempt` tinyint(1) NOT NULL DEFAULT '0',
  `tcp_attempt` tinyint(1) NOT NULL DEFAULT '0',
  `syn_attempts` tinyint(1) NOT NULL DEFAULT '0',
  `synack_attempts` tinyint(1) NOT NULL DEFAULT '0',
  `ack_attempts` tinyint(1) NOT NULL DEFAULT '0',
  `ulflowtime` bigint(20) NOT NULL DEFAULT '0',
  `dlflowtime` bigint(20) NOT NULL DEFAULT '0',
  `tcp_rtt_ul` bigint(20) NOT NULL DEFAULT '0',
  `tcp_rtt_dl` bigint(20) NOT NULL DEFAULT '0',
  `tcp_rtt_completion` bigint(20) NOT NULL DEFAULT '0',
  `tcpNormalClose` tinyint(1) NOT NULL DEFAULT '0',
  `tcpAbnormalClose` tinyint(1) NOT NULL DEFAULT '0',
  `tcpRstClose` tinyint(1) NOT NULL DEFAULT '0',
  `dns_server` int(11) NOT NULL DEFAULT '-1',
  `dnsattempt` tinyint(1) NOT NULL DEFAULT '0',
  `roamingfilter` tinyint(1) NOT NULL DEFAULT '0',
  `mobilecc_gn` int(11) NOT NULL DEFAULT '-1',
  `mobileop_gn` int(11) NOT NULL DEFAULT '-1',
  `vipfilter` tinyint(1) NOT NULL DEFAULT '0',
  `custid1` int(11) NOT NULL DEFAULT '-1',
  `custid2` int(11) NOT NULL DEFAULT '-1',
  `custid3` int(11) NOT NULL DEFAULT '-1',
  `application` int(11) NOT NULL DEFAULT '-1',
  `applicationfamily` int(11) NOT NULL DEFAULT '-1',
  `application_stack` char(45) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `roamingfilter_outbound` tinyint(1) NOT NULL DEFAULT '0',
  `totalfilter` tinyint(1) NOT NULL DEFAULT '0',
  `manufactor` int(11) NOT NULL DEFAULT '-1',
  `model` int(11) NOT NULL DEFAULT '-1',
  `devicetype_imei` int(11) NOT NULL DEFAULT '-1'
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

CREATE TABLE EOF_big_t2 (
  `time` bigint(20) NOT NULL,
  `psn` bigint(20) NOT NULL DEFAULT '0',
  `start` bigint(20) NOT NULL DEFAULT '0',
  `end` bigint(20) NOT NULL DEFAULT '0',
  `reloaded` tinyint(1) NOT NULL DEFAULT '0',
  `rattype` smallint(6) NOT NULL DEFAULT '-1',
  `record_start` bigint(20) NOT NULL DEFAULT '0',
  `record_end` bigint(20) NOT NULL DEFAULT '0',
  `duration_s` bigint(20) NOT NULL DEFAULT '0',
  `lac` mediumint(9) NOT NULL DEFAULT '-1',
  `rac` smallint(6) NOT NULL DEFAULT '-1',
  `cellid_or_sac` mediumint(9) NOT NULL DEFAULT '-1',
  `eci` int(11) NOT NULL DEFAULT '-1',
  `apnname` int(11) NOT NULL DEFAULT '-1',
  `uplink_ip_ipv4_ipv6` char(45) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `downlink_ip_ipv4_ipv6` char(45) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `imsibcd` bigint(20) NOT NULL DEFAULT '0',
  `msisdnbcd` bigint(20) NOT NULL DEFAULT '0',
  `msisdn` char(32) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `msisdn_raw` char(32) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `imei_sv_bcd` bigint(20) NOT NULL DEFAULT '0',
  `pdpactivation` bigint(20) NOT NULL DEFAULT '0',
  `uplink_start` bigint(20) NOT NULL DEFAULT '0',
  `uplink_end` bigint(20) NOT NULL DEFAULT '0',
  `downlink_start` bigint(20) NOT NULL DEFAULT '0',
  `downlink_end` bigint(20) NOT NULL DEFAULT '0',
  `dlnode` int(11) NOT NULL DEFAULT '-1',
  `ulnode` int(11) NOT NULL DEFAULT '-1',
  `uplink_ip` int(11) NOT NULL DEFAULT '-1',
  `downlink_ip` int(11) NOT NULL DEFAULT '-1',
  `hostipaddr` int(11) NOT NULL DEFAULT '-1',
  `mobileipaddr` int(11) NOT NULL DEFAULT '-1',
  `hostipv6addr` char(39) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `mobileipv6addr` char(39) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `uplink_port` int(11) NOT NULL DEFAULT '-1',
  `downlink_port` int(11) NOT NULL DEFAULT '-1',
  `pdpnsapi` tinyint(4) NOT NULL DEFAULT '-1',
  `uplink_teid` bigint(20) NOT NULL DEFAULT '-1',
  `downlink_teid` bigint(20) NOT NULL DEFAULT '-1',
  `vlan` smallint(6) NOT NULL DEFAULT '-1',
  `transport_protocol` smallint(6) NOT NULL DEFAULT '-1',
  `mud_direction` tinyint(4) NOT NULL DEFAULT '-1',
  `directtunnelind` tinyint(4) NOT NULL DEFAULT '-1',
  `precedence` tinyint(4) NOT NULL DEFAULT '-1',
  `uplink_fragmentation` tinyint(1) NOT NULL DEFAULT '0',
  `downlink_fragmentation` tinyint(1) NOT NULL DEFAULT '0',
  `reason` smallint(6) NOT NULL DEFAULT '-1',
  `traffic_handling_priority` tinyint(4) NOT NULL DEFAULT '-1',
  `traffic_class` tinyint(4) NOT NULL DEFAULT '-1',
  `qos_qci` tinyint(4) NOT NULL DEFAULT '-1',
  `ulpackets` bigint(20) NOT NULL DEFAULT '0',
  `dlpackets` bigint(20) NOT NULL DEFAULT '0',
  `ulbytes` bigint(20) NOT NULL DEFAULT '0',
  `dlbytes` bigint(20) NOT NULL DEFAULT '0',
  `ulretransmits` bigint(20) NOT NULL DEFAULT '0',
  `dlretransmits` bigint(20) NOT NULL DEFAULT '0',
  `ul_retransmit_ratio` bigint(20) NOT NULL DEFAULT '0',
  `dl_retransmit_ratio` bigint(20) NOT NULL DEFAULT '0',
  `ulfragments` bigint(20) NOT NULL DEFAULT '0',
  `dlfragments` bigint(20) NOT NULL DEFAULT '0',
  `ulfragmentedpackets` bigint(20) NOT NULL DEFAULT '0',
  `dlfragmentedpackets` bigint(20) NOT NULL DEFAULT '0',
  `queryname` char(101) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `dns_cause` mediumint(9) NOT NULL DEFAULT '-1',
  `resolvedaddress` bigint(20) NOT NULL DEFAULT '0',
  `dns_lookup_time` bigint(20) NOT NULL DEFAULT '0',
  `tacid_` int(11) NOT NULL DEFAULT '-1',
  `ulnode_id` int(11) NOT NULL DEFAULT '-1',
  `dlnode_id` int(11) NOT NULL DEFAULT '-1',
  `sgsn_id` int(11) NOT NULL DEFAULT '-1',
  `ggsn_id` int(11) NOT NULL DEFAULT '-1',
  `categoryid` int(11) NOT NULL DEFAULT '-1',
  `traffic_category` tinyint(4) NOT NULL DEFAULT '-1',
  `bsc_rnc_id` int(11) NOT NULL DEFAULT '-1',
  `cell` int(11) NOT NULL DEFAULT '-1',
  `cell_group` int(11) NOT NULL DEFAULT '-1',
  `ltetac` int(11) NOT NULL DEFAULT '-1',
  `enodeb` int(11) NOT NULL DEFAULT '-1',
  `tac_topo` int(11) NOT NULL DEFAULT '-1',
  `tcp_control` smallint(6) NOT NULL DEFAULT '-1',
  `tcp_syn` bigint(20) NOT NULL DEFAULT '0',
  `tcp_synack` bigint(20) NOT NULL DEFAULT '0',
  `tcp_ack` bigint(20) NOT NULL DEFAULT '0',
  `tcp_fin` bigint(20) NOT NULL DEFAULT '0',
  `tcp_rst` bigint(20) NOT NULL DEFAULT '0',
  `service` tinyint(4) NOT NULL DEFAULT '-1',
  `host_id` int(11) NOT NULL DEFAULT '-1',
  `apnid` int(11) NOT NULL DEFAULT '-1',
  `iana_application` int(11) NOT NULL DEFAULT '-1',
  `ul_flow_size` int(11) NOT NULL DEFAULT '-1',
  `dl_flow_size` int(11) NOT NULL DEFAULT '-1',
  `udp_attempt` tinyint(1) NOT NULL DEFAULT '0',
  `tcp_attempt` tinyint(1) NOT NULL DEFAULT '0',
  `syn_attempts` tinyint(1) NOT NULL DEFAULT '0',
  `synack_attempts` tinyint(1) NOT NULL DEFAULT '0',
  `ack_attempts` tinyint(1) NOT NULL DEFAULT '0',
  `ulflowtime` bigint(20) NOT NULL DEFAULT '0',
  `dlflowtime` bigint(20) NOT NULL DEFAULT '0',
  `tcp_rtt_ul` bigint(20) NOT NULL DEFAULT '0',
  `tcp_rtt_dl` bigint(20) NOT NULL DEFAULT '0',
  `tcp_rtt_completion` bigint(20) NOT NULL DEFAULT '0',
  `tcpNormalClose` tinyint(1) NOT NULL DEFAULT '0',
  `tcpAbnormalClose` tinyint(1) NOT NULL DEFAULT '0',
  `tcpRstClose` tinyint(1) NOT NULL DEFAULT '0',
  `dns_server` int(11) NOT NULL DEFAULT '-1',
  `dnsattempt` tinyint(1) NOT NULL DEFAULT '0',
  `roamingfilter` tinyint(1) NOT NULL DEFAULT '0',
  `mobilecc_gn` int(11) NOT NULL DEFAULT '-1',
  `mobileop_gn` int(11) NOT NULL DEFAULT '-1',
  `vipfilter` tinyint(1) NOT NULL DEFAULT '0',
  `custid1` int(11) NOT NULL DEFAULT '-1',
  `custid2` int(11) NOT NULL DEFAULT '-1',
  `custid3` int(11) NOT NULL DEFAULT '-1',
  `application` int(11) NOT NULL DEFAULT '-1',
  `applicationfamily` int(11) NOT NULL DEFAULT '-1',
  `application_stack` char(45) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
  `roamingfilter_outbound` tinyint(1) NOT NULL DEFAULT '0',
  `totalfilter` tinyint(1) NOT NULL DEFAULT '0',
  `manufactor` int(11) NOT NULL DEFAULT '-1',
  `model` int(11) NOT NULL DEFAULT '-1',
  `devicetype_imei` int(11) NOT NULL DEFAULT '-1'
) ENGINE=MYISAM DEFAULT CHARSET=utf8;
