/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.4.95
 Source Server Type    : MySQL
 Source Server Version : 100621 (10.6.21-MariaDB-0ubuntu0.22.04.2)
 Source Host           : 192.168.4.95:3306
 Source Schema         : CSTA_DB

 Target Server Type    : MySQL
 Target Server Version : 100621 (10.6.21-MariaDB-0ubuntu0.22.04.2)
 File Encoding         : 65001

 Date: 17/06/2025 16:17:43
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for 320_mapTable
-- ----------------------------
DROP TABLE IF EXISTS `320_mapTable`;
CREATE TABLE `320_mapTable`  (
  `detailFieldList` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `sumFieldList` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for 8ke1Detail
-- ----------------------------
DROP TABLE IF EXISTS `8ke1Detail`;
CREATE TABLE `8ke1Detail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `mes_recei_lan` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `octet_recei_lan` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mes_trans_lan` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `octet_trans_lan` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mes_recei_hdlc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `octet_recei_hdlc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mes_trans_hdlc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `octet_trans_hdlc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sync_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sync_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sync_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sync_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sync_4` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sync_5` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sync_6` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sync_7` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `signal_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `signal_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `signal_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `signal_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `signal_4` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `signal_5` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `signal_6` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `signal_7` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alarm_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alarm_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alarm_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alarm_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alarm_4` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alarm_5` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alarm_6` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alarm_7` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `slip_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `slip_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `slip_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `slip_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `slip_4` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `slip_5` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `slip_6` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `slip_7` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `crc4_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `crc4_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `crc4_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `crc4_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `crc4_4` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `crc4_5` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `crc4_6` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `crc4_7` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for aasDetail
-- ----------------------------
DROP TABLE IF EXISTS `aasDetail`;
CREATE TABLE `aasDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `pps_service_attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `pps_service_success` int UNSIGNED NOT NULL DEFAULT 0,
  `msc_service_attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `msc_service_success` int UNSIGNED NOT NULL DEFAULT 0,
  `invalid_call` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for aasDetailData
-- ----------------------------
DROP TABLE IF EXISTS `aasDetailData`;
CREATE TABLE `aasDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `pps_service_attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `pps_service_success` int UNSIGNED NOT NULL DEFAULT 0,
  `msc_service_attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `msc_service_success` int UNSIGNED NOT NULL DEFAULT 0,
  `invalid_call` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for aifDetail
-- ----------------------------
DROP TABLE IF EXISTS `aifDetail`;
CREATE TABLE `aifDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `paging_resp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `paging_resp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rr_ho_cmd_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rr_ho_cmd_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `imsi_detach_ind_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `imsi_detach_ind_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_accept_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_accept_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auth_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auth_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auth_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auth_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auth_response_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auth_response_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `id_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `id_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `id_response_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `id_response_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tmsi_realloc_cmd_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tmsi_realloc_cmd_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tmsi_realloc_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tmsi_realloc_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_accept_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_accept_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_abort_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_abort_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_prompt_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_prompt_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_reest_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_reest_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `abort_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `abort_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mm_null_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mm_null_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mm_status_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mm_status_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mm_info_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mm_info_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alerting_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alerting_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `call_confirmed_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `call_confirmed_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `call_proceeding_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `call_proceeding_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `connect_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `connect_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `connect_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `connect_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `emergency_setup_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `emergency_setup_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `progress_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `progress_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `setup_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `setup_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `modify_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `modify_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `modify_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `modify_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `modify_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `modify_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `user_info_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `user_info_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hold_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hold_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hold_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hold_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hold_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hold_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `retrieve_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `retrieve_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `retrieve_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `retrieve_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `retrieve_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `retrieve_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `disconnect_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `disconnect_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `release_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `release_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `release_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `release_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `congestion_ctrl_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `congestion_ctrl_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `notify_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `notify_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `status_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `status_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `status_enq_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `status_enq_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_dtmf_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_dtmf_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_dtmf_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_dtmf_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_dtmf_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_dtmf_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_dtmf_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_dtmf_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_dtmf_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_dtmf_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `facility_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `facility_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `facility_ss_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `facility_ss_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `register_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `register_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `release_cmp_ss_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `release_cmp_ss_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_data_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_data_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_error_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_error_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_smma_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_smma_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `block_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `block_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `block_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `block_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unblock_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unblock_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unblock_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unblock_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_blk_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_blk_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_blk_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_blk_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_unblk_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_unblk_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_unblk_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_unblk_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resrc_req_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resrc_req_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resrc_ind_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resrc_ind_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `paging_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `paging_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `overload_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `overload_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_cc_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_cc_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_cc_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_cc_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_can_enq_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_can_enq_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_can_resq_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_can_resq_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `assign_req_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `assign_req_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `assign_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `assign_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `assign_fail_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `assign_fail_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_required_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_required_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_req_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_req_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_cmd_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_cmd_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_suc_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_suc_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_fail_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_fail_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_performed_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_performed_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_req_rej_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_req_rej_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_detect_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_detect_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `clr_cmd_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `clr_cmd_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `clr_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `clr_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `clr_req_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `clr_req_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sapi_rej_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sapi_rej_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `confusion_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `confusion_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suspend_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suspend_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resume_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resume_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `loc_info_cmd_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `loc_info_cmd_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `loc_info_rpt_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `loc_info_rpt_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `msc_invk_trace_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `msc_invk_trace_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `bsc_invk_trace_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `bsc_invk_trace_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unequip_cc_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unequip_cc_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `change_cc_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `change_cc_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `change_cc_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `change_cc_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cipher_mode_cmd_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cipher_mode_cmd_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_update_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_update_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cipher_mode_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cipher_mode_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `queue_ind_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `queue_ind_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `l3_info_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `l3_info_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `classmark_req_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `classmark_req_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cipher_mode_rej_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cipher_mode_rej_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `load_ind_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `load_ind_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lsa_info_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lsa_info_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for aifDetailData
-- ----------------------------
DROP TABLE IF EXISTS `aifDetailData`;
CREATE TABLE `aifDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `paging_resp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `paging_resp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rr_ho_cmd_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rr_ho_cmd_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `imsi_detach_ind_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `imsi_detach_ind_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_accept_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_accept_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auth_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auth_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auth_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auth_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auth_response_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auth_response_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `id_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `id_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `id_response_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `id_response_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tmsi_realloc_cmd_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tmsi_realloc_cmd_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tmsi_realloc_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tmsi_realloc_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_accept_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_accept_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_abort_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_abort_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_prompt_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_prompt_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_reest_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_reest_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `abort_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `abort_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mm_null_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mm_null_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mm_status_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mm_status_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mm_info_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mm_info_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alerting_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alerting_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `call_confirmed_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `call_confirmed_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `call_proceeding_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `call_proceeding_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `connect_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `connect_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `connect_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `connect_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `emergency_setup_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `emergency_setup_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `progress_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `progress_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `setup_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `setup_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `modify_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `modify_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `modify_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `modify_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `modify_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `modify_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `user_info_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `user_info_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hold_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hold_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hold_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hold_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hold_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hold_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `retrieve_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `retrieve_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `retrieve_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `retrieve_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `retrieve_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `retrieve_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `disconnect_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `disconnect_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `release_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `release_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `release_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `release_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `congestion_ctrl_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `congestion_ctrl_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `notify_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `notify_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `status_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `status_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `status_enq_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `status_enq_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_dtmf_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_dtmf_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_dtmf_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_dtmf_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_dtmf_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_dtmf_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_dtmf_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_dtmf_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_dtmf_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_dtmf_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `facility_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `facility_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `facility_ss_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `facility_ss_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `register_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `register_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `release_cmp_ss_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `release_cmp_ss_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_data_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_data_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_error_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_error_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_smma_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rp_smma_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `block_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `block_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `block_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `block_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unblock_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unblock_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unblock_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unblock_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_blk_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_blk_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_blk_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_blk_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_unblk_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_unblk_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_unblk_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cc_group_unblk_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resrc_req_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resrc_req_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resrc_ind_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resrc_ind_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `paging_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `paging_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `overload_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `overload_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_cc_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_cc_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_cc_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_cc_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_can_enq_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_can_enq_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_can_resq_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_can_resq_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `assign_req_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `assign_req_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `assign_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `assign_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `assign_fail_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `assign_fail_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_required_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_required_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_req_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_req_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_cmd_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_cmd_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_suc_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_suc_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_fail_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_fail_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_performed_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_performed_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_req_rej_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_req_rej_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_detect_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ho_detect_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `clr_cmd_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `clr_cmd_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `clr_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `clr_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `clr_req_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `clr_req_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sapi_rej_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sapi_rej_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `confusion_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `confusion_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suspend_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suspend_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resume_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resume_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `loc_info_cmd_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `loc_info_cmd_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `loc_info_rpt_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `loc_info_rpt_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `msc_invk_trace_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `msc_invk_trace_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `bsc_invk_trace_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `bsc_invk_trace_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unequip_cc_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unequip_cc_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `change_cc_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `change_cc_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `change_cc_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `change_cc_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cipher_mode_cmd_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cipher_mode_cmd_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_update_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cm_update_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cipher_mode_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cipher_mode_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `queue_ind_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `queue_ind_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `l3_info_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `l3_info_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `classmark_req_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `classmark_req_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cipher_mode_rej_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cipher_mode_rej_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `load_ind_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `load_ind_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lsa_info_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lsa_info_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for amrmgDetail
-- ----------------------------
DROP TABLE IF EXISTS `amrmgDetail`;
CREATE TABLE `amrmgDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `rtp_pkg_miss` int UNSIGNED NOT NULL DEFAULT 0,
  `rtp_pkg_recv` int UNSIGNED NOT NULL DEFAULT 0,
  `rtp_pkg_sent` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for amrmgDetailData
-- ----------------------------
DROP TABLE IF EXISTS `amrmgDetailData`;
CREATE TABLE `amrmgDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `rtp_pkg_miss` int UNSIGNED NOT NULL DEFAULT 0,
  `rtp_pkg_recv` int UNSIGNED NOT NULL DEFAULT 0,
  `rtp_pkg_sent` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for aucDetail
-- ----------------------------
DROP TABLE IF EXISTS `aucDetail`;
CREATE TABLE `aucDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `auc_auth_suc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hlr_created_sub_suc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hlr_del_sub_suc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auc_created_sub_suc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auc_del_sub_suc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auc_auth_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hlr_created_sub_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hlr_del_sub_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auc_created_sub_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auc_del_sub_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `int_sub_suc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `int_sub_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for aucDetailData
-- ----------------------------
DROP TABLE IF EXISTS `aucDetailData`;
CREATE TABLE `aucDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `auc_auth_suc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hlr_created_sub_suc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hlr_del_sub_suc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auc_created_sub_suc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auc_del_sub_suc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auc_auth_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hlr_created_sub_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hlr_del_sub_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auc_created_sub_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `auc_del_sub_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `int_sub_suc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `int_sub_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for cnfDetail
-- ----------------------------
DROP TABLE IF EXISTS `cnfDetail`;
CREATE TABLE `cnfDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_tg` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `att` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ans` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `caller_clear` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `no_ans` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `subscriber_busy` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `network_busy` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `call_barred` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `signaling_timer_expired` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `total_holding_time` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `att_mosmf_10` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suc_mosmf_10` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `att_mtsmf_10` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suc_mtsof_10` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `key_e1_tg`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for cstaDefine
-- ----------------------------
DROP TABLE IF EXISTS `cstaDefine`;
CREATE TABLE `cstaDefine`  (
  `isEnable` tinyint NOT NULL DEFAULT 1,
  `sysTypeNo` int NOT NULL DEFAULT 0,
  `objIndex` tinyint NOT NULL DEFAULT 0,
  `oid` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `useAgent` tinyint(1) NOT NULL DEFAULT 0,
  `recordTable` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `sumTable` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `hasSubSys` tinyint(1) NOT NULL DEFAULT 1,
  `sumUp` tinyint(1) NOT NULL DEFAULT 0,
  `checkTime` tinyint(1) NOT NULL DEFAULT 1,
  `isFullRow` tinyint(1) NOT NULL DEFAULT 1,
  `cstaType` tinyint(1) NOT NULL DEFAULT 0,
  `width` tinyint(1) NOT NULL DEFAULT 4,
  `id1Start` smallint NOT NULL DEFAULT 0,
  `id1End` smallint NOT NULL DEFAULT 0,
  `id1Offset` smallint NOT NULL DEFAULT 0,
  `id1Field` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `id2Start` smallint NOT NULL DEFAULT 0,
  `id2End` smallint NOT NULL DEFAULT 0,
  `id2Offset` smallint NOT NULL DEFAULT 0,
  `id2Field` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `fieldList` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `detailToSum` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `csvPath` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`sysTypeNo`, `objIndex`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cstaPubVarConf
-- ----------------------------
DROP TABLE IF EXISTS `cstaPubVarConf`;
CREATE TABLE `cstaPubVarConf`  (
  `pubVarName` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `pubVarValue` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `remark` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  INDEX `pubVarName`(`pubVarName`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for eirDetail
-- ----------------------------
DROP TABLE IF EXISTS `eirDetail`;
CREATE TABLE `eirDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `mabls` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mablf` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `magls` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `maglf` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mdbls` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mdblf` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mdgls` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mdglf` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tcis` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tcif` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for eirDetailData
-- ----------------------------
DROP TABLE IF EXISTS `eirDetailData`;
CREATE TABLE `eirDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `mabls` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mablf` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `magls` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `maglf` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mdbls` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mdblf` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mdgls` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mdglf` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tcis` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tcif` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for hlrDetail
-- ----------------------------
DROP TABLE IF EXISTS `hlrDetail`;
CREATE TABLE `hlrDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `ncmroh` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `arasrh` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srasfh` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `errash` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `aisds` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sisds` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alu` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `slu` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `asroh` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ssroh` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `arsri` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srsri` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `asdssp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ssdsrp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ansa` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `snsa` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `arm` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srm` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ms_initial_ussd_attempt` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ms_initial_ussd_success` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relay_ussd_to_scf_attempt` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relay_ussd_to_scf_success` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for hlrDetailData
-- ----------------------------
DROP TABLE IF EXISTS `hlrDetailData`;
CREATE TABLE `hlrDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `ncmroh` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `arasrh` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srasfh` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `errash` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `aisds` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sisds` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alu` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `slu` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `asroh` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ssroh` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `arsri` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srsri` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `asdssp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ssdsrp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ansa` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `snsa` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `arm` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srm` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ms_initial_ussd_attempt` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ms_initial_ussd_success` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relay_ussd_to_scf_attempt` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relay_ussd_to_scf_success` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for igrsDetail
-- ----------------------------
DROP TABLE IF EXISTS `igrsDetail`;
CREATE TABLE `igrsDetail`  (
  `key_sys_id` tinyint UNSIGNED NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NULL DEFAULT 0,
  `key_component_id` tinyint UNSIGNED NULL DEFAULT 0,
  `send_packet_signal` int UNSIGNED NULL DEFAULT 0,
  `send_byte_signal` int UNSIGNED NULL DEFAULT 0,
  `recv_packet_signal` int UNSIGNED NULL DEFAULT 0,
  `recv_byte_signal` int UNSIGNED NULL DEFAULT 0,
  `send_packet_data` int UNSIGNED NULL DEFAULT 0,
  `send_byte_data` int UNSIGNED NULL DEFAULT 0,
  `recv_packet_data` int UNSIGNED NULL DEFAULT 0,
  `recv_byte_data` int UNSIGNED NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for igrsDetailData
-- ----------------------------
DROP TABLE IF EXISTS `igrsDetailData`;
CREATE TABLE `igrsDetailData`  (
  `key_sys_id` tinyint UNSIGNED NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NULL DEFAULT 0,
  `key_component_id` tinyint UNSIGNED NULL DEFAULT 0,
  `send_packet_signal` int UNSIGNED NULL DEFAULT 0,
  `send_byte_signal` int UNSIGNED NULL DEFAULT 0,
  `recv_packet_signal` int UNSIGNED NULL DEFAULT 0,
  `recv_byte_signal` int UNSIGNED NULL DEFAULT 0,
  `send_packet_data` int UNSIGNED NULL DEFAULT 0,
  `send_byte_data` int UNSIGNED NULL DEFAULT 0,
  `recv_packet_data` int UNSIGNED NULL DEFAULT 0,
  `recv_byte_data` int UNSIGNED NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for imsDetail
-- ----------------------------
DROP TABLE IF EXISTS `imsDetail`;
CREATE TABLE `imsDetail`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `num_of_register_success` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_register_failed` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_moc_setup` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_moc_ring` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_mtc_setup` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_mtc_ring` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for imsDetailData
-- ----------------------------
DROP TABLE IF EXISTS `imsDetailData`;
CREATE TABLE `imsDetailData`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `num_of_register_success` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_register_failed` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_moc_setup` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_moc_ring` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_mtc_setup` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_mtc_ring` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for imsSum
-- ----------------------------
DROP TABLE IF EXISTS `imsSum`;
CREATE TABLE `imsSum`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `num_of_register_success` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_register_failed` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_moc_setup` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_moc_ring` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_mtc_setup` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_mtc_ring` int NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for ipalimDetail
-- ----------------------------
DROP TABLE IF EXISTS `ipalimDetail`;
CREATE TABLE `ipalimDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_tg` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `Attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `Success` int UNSIGNED NOT NULL DEFAULT 0,
  `Duration` int UNSIGNED NOT NULL DEFAULT 0,
  `cc_normal` int UNSIGNED NOT NULL DEFAULT 0,
  `cc_call_deny` int UNSIGNED NOT NULL DEFAULT 0,
  `cc_net_busy` int UNSIGNED NOT NULL DEFAULT 0,
  `cc_caller_clear` int UNSIGNED NOT NULL DEFAULT 0,
  `cc_sub_busy` int UNSIGNED NOT NULL DEFAULT 0,
  `cc_no_answer` int UNSIGNED NOT NULL DEFAULT 0,
  `cc_sig_error` int UNSIGNED NOT NULL DEFAULT 0,
  `lu_normal` int UNSIGNED NOT NULL DEFAULT 0,
  `lu_res_not_ok` int UNSIGNED NOT NULL DEFAULT 0,
  `lu_ser_not_ok` int UNSIGNED NOT NULL DEFAULT 0,
  `lu_ser_no_imp` int UNSIGNED NOT NULL DEFAULT 0,
  `lu_msg_error` int UNSIGNED NOT NULL DEFAULT 0,
  `lu_pro_error` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_normal` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_error_sub` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_ser_not_ok` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_net_busy` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_msg_error` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_pro_error` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_res_not_ok` int UNSIGNED NOT NULL DEFAULT 0,
  `f0` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_0` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_1` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_2` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_3` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_4` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_5` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_6` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_7` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_8` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_9` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_10` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_11` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_12` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_13` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_14` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_15` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_16` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_17` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_18` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_19` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_20` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_21` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_22` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_23` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_24` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_25` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_26` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_27` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_28` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_29` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_30` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_31` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_32` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_33` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_34` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_35` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_36` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_37` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_38` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_39` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_40` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_41` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_42` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_43` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_44` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_45` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_46` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_47` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_48` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_49` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_50` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_51` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_52` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_53` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_54` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_55` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_56` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_57` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_58` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_59` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_60` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_61` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_62` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_63` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_64` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_65` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_66` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_67` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_68` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_69` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_70` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_71` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_72` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_73` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_74` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_75` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_76` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_77` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_78` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_79` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_80` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_81` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_82` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_83` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_84` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_85` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_86` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_87` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_88` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_89` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_90` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_91` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_92` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_93` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_94` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_95` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_96` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_97` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_98` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_99` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_100` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_101` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_102` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_103` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_104` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_105` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_106` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_107` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_108` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_109` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_110` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_111` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_112` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_113` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_114` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_115` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_116` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_117` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_118` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_119` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_120` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_121` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_122` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_123` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_124` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_125` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_126` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_127` int UNSIGNED NOT NULL DEFAULT 0,
  `f2` int UNSIGNED NOT NULL DEFAULT 0,
  `f3` int UNSIGNED NOT NULL DEFAULT 0,
  `f4` int UNSIGNED NOT NULL DEFAULT 0,
  `f5` int UNSIGNED NOT NULL DEFAULT 0,
  `f6` int UNSIGNED NOT NULL DEFAULT 0,
  `f7` int UNSIGNED NOT NULL DEFAULT 0,
  `f8` int UNSIGNED NOT NULL DEFAULT 0,
  `f9` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_0` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_1` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_2` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_3` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_4` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_5` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_6` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_7` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_8` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_9` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_10` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_11` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_12` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_13` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_14` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_15` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_16` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_17` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_18` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_19` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_20` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_21` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_22` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_23` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_24` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_25` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_26` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_27` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_28` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_29` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_30` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_31` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_32` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_33` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_34` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_35` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_36` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_37` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_38` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_39` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_40` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_41` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_42` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_43` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_44` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_45` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_46` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_47` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_48` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_49` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_50` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_51` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_52` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_53` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_54` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_55` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_56` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_57` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_58` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_59` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_60` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_61` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_62` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_63` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_64` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_65` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_66` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_67` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_68` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_69` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_70` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_71` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_72` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_73` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_74` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_75` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_76` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_77` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_78` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_79` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_80` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_81` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_82` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_83` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_84` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_85` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_86` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_87` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_88` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_89` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_90` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_91` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_92` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_93` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_94` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_95` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_96` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_97` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_98` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_99` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_100` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_101` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_102` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_103` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_104` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_105` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_106` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_107` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_108` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_109` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_110` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_111` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_112` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_113` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_114` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_115` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_116` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_117` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_118` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_119` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_120` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_121` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_122` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_123` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_124` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_125` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_126` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_127` int UNSIGNED NOT NULL DEFAULT 0,
  `f11` int UNSIGNED NOT NULL DEFAULT 0,
  `f12` int UNSIGNED NOT NULL DEFAULT 0,
  `f13` int UNSIGNED NOT NULL DEFAULT 0,
  `f14` int UNSIGNED NOT NULL DEFAULT 0,
  `f15` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `key_e1_tg`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for ipalimDetailData
-- ----------------------------
DROP TABLE IF EXISTS `ipalimDetailData`;
CREATE TABLE `ipalimDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_tg` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `Attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `Success` int UNSIGNED NOT NULL DEFAULT 0,
  `Duration` int UNSIGNED NOT NULL DEFAULT 0,
  `cc_normal` int UNSIGNED NOT NULL DEFAULT 0,
  `cc_call_deny` int UNSIGNED NOT NULL DEFAULT 0,
  `cc_net_busy` int UNSIGNED NOT NULL DEFAULT 0,
  `cc_caller_clear` int UNSIGNED NOT NULL DEFAULT 0,
  `cc_sub_busy` int UNSIGNED NOT NULL DEFAULT 0,
  `cc_no_answer` int UNSIGNED NOT NULL DEFAULT 0,
  `cc_sig_error` int UNSIGNED NOT NULL DEFAULT 0,
  `lu_normal` int UNSIGNED NOT NULL DEFAULT 0,
  `lu_res_not_ok` int UNSIGNED NOT NULL DEFAULT 0,
  `lu_ser_not_ok` int UNSIGNED NOT NULL DEFAULT 0,
  `lu_ser_no_imp` int UNSIGNED NOT NULL DEFAULT 0,
  `lu_msg_error` int UNSIGNED NOT NULL DEFAULT 0,
  `lu_pro_error` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_normal` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_error_sub` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_ser_not_ok` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_net_busy` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_msg_error` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_pro_error` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_res_not_ok` int UNSIGNED NOT NULL DEFAULT 0,
  `f0` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_0` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_1` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_2` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_3` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_4` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_5` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_6` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_7` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_8` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_9` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_10` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_11` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_12` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_13` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_14` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_15` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_16` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_17` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_18` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_19` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_20` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_21` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_22` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_23` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_24` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_25` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_26` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_27` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_28` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_29` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_30` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_31` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_32` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_33` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_34` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_35` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_36` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_37` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_38` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_39` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_40` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_41` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_42` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_43` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_44` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_45` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_46` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_47` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_48` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_49` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_50` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_51` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_52` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_53` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_54` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_55` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_56` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_57` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_58` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_59` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_60` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_61` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_62` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_63` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_64` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_65` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_66` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_67` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_68` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_69` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_70` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_71` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_72` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_73` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_74` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_75` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_76` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_77` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_78` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_79` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_80` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_81` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_82` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_83` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_84` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_85` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_86` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_87` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_88` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_89` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_90` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_91` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_92` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_93` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_94` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_95` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_96` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_97` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_98` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_99` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_100` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_101` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_102` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_103` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_104` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_105` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_106` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_107` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_108` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_109` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_110` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_111` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_112` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_113` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_114` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_115` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_116` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_117` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_118` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_119` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_120` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_121` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_122` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_123` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_124` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_125` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_126` int UNSIGNED NOT NULL DEFAULT 0,
  `f1_127` int UNSIGNED NOT NULL DEFAULT 0,
  `f2` int UNSIGNED NOT NULL DEFAULT 0,
  `f3` int UNSIGNED NOT NULL DEFAULT 0,
  `f4` int UNSIGNED NOT NULL DEFAULT 0,
  `f5` int UNSIGNED NOT NULL DEFAULT 0,
  `f6` int UNSIGNED NOT NULL DEFAULT 0,
  `f7` int UNSIGNED NOT NULL DEFAULT 0,
  `f8` int UNSIGNED NOT NULL DEFAULT 0,
  `f9` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_0` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_1` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_2` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_3` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_4` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_5` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_6` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_7` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_8` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_9` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_10` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_11` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_12` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_13` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_14` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_15` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_16` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_17` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_18` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_19` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_20` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_21` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_22` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_23` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_24` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_25` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_26` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_27` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_28` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_29` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_30` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_31` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_32` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_33` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_34` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_35` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_36` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_37` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_38` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_39` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_40` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_41` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_42` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_43` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_44` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_45` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_46` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_47` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_48` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_49` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_50` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_51` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_52` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_53` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_54` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_55` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_56` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_57` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_58` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_59` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_60` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_61` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_62` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_63` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_64` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_65` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_66` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_67` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_68` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_69` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_70` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_71` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_72` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_73` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_74` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_75` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_76` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_77` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_78` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_79` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_80` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_81` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_82` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_83` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_84` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_85` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_86` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_87` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_88` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_89` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_90` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_91` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_92` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_93` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_94` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_95` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_96` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_97` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_98` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_99` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_100` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_101` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_102` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_103` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_104` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_105` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_106` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_107` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_108` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_109` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_110` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_111` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_112` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_113` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_114` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_115` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_116` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_117` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_118` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_119` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_120` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_121` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_122` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_123` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_124` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_125` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_126` int UNSIGNED NOT NULL DEFAULT 0,
  `f10_127` int UNSIGNED NOT NULL DEFAULT 0,
  `f11` int UNSIGNED NOT NULL DEFAULT 0,
  `f12` int UNSIGNED NOT NULL DEFAULT 0,
  `f13` int UNSIGNED NOT NULL DEFAULT 0,
  `f14` int UNSIGNED NOT NULL DEFAULT 0,
  `f15` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `key_e1_tg`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for irlsDetail
-- ----------------------------
DROP TABLE IF EXISTS `irlsDetail`;
CREATE TABLE `irlsDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `Attempt` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `Success` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `oper_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cre_vim_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `conn_local_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `conn_vim_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `noti_req_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `excep_retr_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `noti_retr_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for irlsDetailData
-- ----------------------------
DROP TABLE IF EXISTS `irlsDetailData`;
CREATE TABLE `irlsDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `Attempt` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `Success` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `oper_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cre_vim_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `conn_local_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `conn_vim_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `noti_req_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `excep_retr_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `noti_retr_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for lanDetail
-- ----------------------------
DROP TABLE IF EXISTS `lanDetail`;
CREATE TABLE `lanDetail`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `key_subsys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `dlk_in_short` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dlk_in_long` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dlk_in_arp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dlk_in_ip` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dlk_in_other` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dlk_out_arp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dlk_out_ip` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dlk_err_arp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ip_in_erraddr` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ip_in_icmp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ip_in_udp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ip_in_tcp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ip_in_other` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ip_out_icmp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ip_out_udp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ip_out_tcp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ip_out_err` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `icmp_in_ping` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `icmp_in_other` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `icmp_in_pinglam` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `icmp_in_pingcsu` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `icmp_in_pingother` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `icmp_out_pinglam` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `icmp_out_pingcsu` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udp_in_iic` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udp_in_tftp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udp_in_snmp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udp_in_other` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udp_out_iic` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udp_out_tftp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udp_out_snmp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mhcDetail
-- ----------------------------
DROP TABLE IF EXISTS `mhcDetail`;
CREATE TABLE `mhcDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `hlr_noti_mhc` int UNSIGNED NOT NULL DEFAULT 0,
  `mhc_noti_hlr` int UNSIGNED NOT NULL DEFAULT 0,
  `rep_att` int UNSIGNED NOT NULL DEFAULT 0,
  `rep_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `rep_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_att` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_del_att` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_del_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_del_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_dld_att` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_dld_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_dld_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `mhc_msg_sent` int UNSIGNED NOT NULL DEFAULT 0,
  `mhc_msg_recv` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_0` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_0` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_0` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_0` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_0` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_0` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_1` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_1` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_1` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_1` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_1` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_1` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_2` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_2` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_2` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_2` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_2` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_2` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_3` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_3` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_3` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_3` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_3` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_3` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_4` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_4` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_4` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_4` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_4` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_4` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_5` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_5` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_5` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_5` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_5` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_5` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_6` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_6` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_6` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_6` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_6` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_6` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_7` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_7` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_7` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_7` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_7` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_7` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_8` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_8` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_8` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_8` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_8` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_8` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_9` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_9` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_9` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_9` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_9` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_9` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_10` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_10` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_10` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_10` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_10` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_10` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_11` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_11` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_11` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_11` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_11` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_11` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_12` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_12` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_12` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_12` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_12` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_12` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_13` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_13` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_13` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_13` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_13` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_13` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_14` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_14` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_14` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_14` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_14` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_14` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_15` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_15` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_15` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_15` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_15` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_15` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mhcDetailData
-- ----------------------------
DROP TABLE IF EXISTS `mhcDetailData`;
CREATE TABLE `mhcDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `hlr_noti_mhc` int UNSIGNED NOT NULL DEFAULT 0,
  `mhc_noti_hlr` int UNSIGNED NOT NULL DEFAULT 0,
  `rep_att` int UNSIGNED NOT NULL DEFAULT 0,
  `rep_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `rep_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_att` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_del_att` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_del_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_del_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_dld_att` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_dld_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `veri_dld_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `mhc_msg_sent` int UNSIGNED NOT NULL DEFAULT 0,
  `mhc_msg_recv` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_0` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_0` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_0` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_0` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_0` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_0` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_1` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_1` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_1` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_1` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_1` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_1` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_2` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_2` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_2` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_2` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_2` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_2` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_3` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_3` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_3` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_3` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_3` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_3` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_4` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_4` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_4` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_4` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_4` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_4` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_5` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_5` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_5` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_5` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_5` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_5` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_6` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_6` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_6` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_6` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_6` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_6` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_7` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_7` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_7` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_7` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_7` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_7` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_8` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_8` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_8` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_8` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_8` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_8` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_9` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_9` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_9` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_9` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_9` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_9` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_10` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_10` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_10` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_10` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_10` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_10` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_11` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_11` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_11` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_11` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_11` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_11` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_12` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_12` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_12` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_12` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_12` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_12` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_13` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_13` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_13` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_13` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_13` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_13` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_14` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_14` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_14` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_14` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_14` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_14` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_a_15` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_s_15` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_o_f_15` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_a_15` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_s_15` int UNSIGNED NOT NULL DEFAULT 0,
  `syn_i_f_15` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mmeDetail
-- ----------------------------
DROP TABLE IF EXISTS `mmeDetail`;
CREATE TABLE `mmeDetail`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `num_of_online_enb` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_registered_ues` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_connected_ues` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_idle_ues` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mmeDetailData
-- ----------------------------
DROP TABLE IF EXISTS `mmeDetailData`;
CREATE TABLE `mmeDetailData`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `num_of_online_enb` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_registered_ues` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_connected_ues` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_idle_ues` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mmeSum
-- ----------------------------
DROP TABLE IF EXISTS `mmeSum`;
CREATE TABLE `mmeSum`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `num_of_online_enb` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_registered_ues` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_connected_ues` int UNSIGNED NOT NULL DEFAULT 0,
  `num_of_idle_ues` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mnpDetail
-- ----------------------------
DROP TABLE IF EXISTS `mnpDetail`;
CREATE TABLE `mnpDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `msc_sri` int UNSIGNED NOT NULL DEFAULT 0,
  `smsc_sri` int UNSIGNED NOT NULL DEFAULT 0,
  `pps_ati` int UNSIGNED NOT NULL DEFAULT 0,
  `mnp_query_req` int UNSIGNED NOT NULL DEFAULT 0,
  `own_not_ported` int UNSIGNED NOT NULL DEFAULT 0,
  `own_ported_out` int UNSIGNED NOT NULL DEFAULT 0,
  `foreign_not_ported` int UNSIGNED NOT NULL DEFAULT 0,
  `foreign_ported_in` int UNSIGNED NOT NULL DEFAULT 0,
  `foreign_ported_to_3party` int UNSIGNED NOT NULL DEFAULT 0,
  `total_not_ported` int UNSIGNED NOT NULL DEFAULT 0,
  `total_ported` int UNSIGNED NOT NULL DEFAULT 0,
  `query_err` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mnpDetailData
-- ----------------------------
DROP TABLE IF EXISTS `mnpDetailData`;
CREATE TABLE `mnpDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `msc_sri` int UNSIGNED NOT NULL DEFAULT 0,
  `smsc_sri` int UNSIGNED NOT NULL DEFAULT 0,
  `pps_ati` int UNSIGNED NOT NULL DEFAULT 0,
  `mnp_query_req` int UNSIGNED NOT NULL DEFAULT 0,
  `own_not_ported` int UNSIGNED NOT NULL DEFAULT 0,
  `own_ported_out` int UNSIGNED NOT NULL DEFAULT 0,
  `foreign_not_ported` int UNSIGNED NOT NULL DEFAULT 0,
  `foreign_ported_in` int UNSIGNED NOT NULL DEFAULT 0,
  `foreign_ported_to_3party` int UNSIGNED NOT NULL DEFAULT 0,
  `total_not_ported` int UNSIGNED NOT NULL DEFAULT 0,
  `total_ported` int UNSIGNED NOT NULL DEFAULT 0,
  `query_err` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mrfcDetail
-- ----------------------------
DROP TABLE IF EXISTS `mrfcDetail`;
CREATE TABLE `mrfcDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `Attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `Success` int UNSIGNED NOT NULL DEFAULT 0,
  `Duration` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau0` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau1` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau2` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau3` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau4` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau5` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau6` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau7` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau8` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau9` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau10` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau11` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau12` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau13` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau14` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau15` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau16` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau17` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau18` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau19` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau20` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau21` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau22` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau23` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau24` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau25` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau26` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau27` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau28` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau29` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau30` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau31` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mrfcDetailData
-- ----------------------------
DROP TABLE IF EXISTS `mrfcDetailData`;
CREATE TABLE `mrfcDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `Attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `Success` int UNSIGNED NOT NULL DEFAULT 0,
  `Duration` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau0` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau1` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau2` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau3` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau4` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau5` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau6` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau7` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau8` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau9` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau10` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau11` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau12` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau13` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau14` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau15` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau16` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau17` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau18` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau19` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau20` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau21` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau22` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau23` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau24` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau25` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau26` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau27` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau28` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau29` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau30` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau31` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mscDetail
-- ----------------------------
DROP TABLE IF EXISTS `mscDetail`;
CREATE TABLE `mscDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_tg` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `Attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `Success` int UNSIGNED NOT NULL DEFAULT 0,
  `Duration` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau0` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau1` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau2` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau3` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau4` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau5` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau6` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau7` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau8` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau9` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau10` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau11` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau12` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau13` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau14` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau15` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau16` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau17` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau18` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau19` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau20` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau21` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau22` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau23` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau24` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau25` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau26` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau27` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau28` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau29` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau30` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau31` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau32` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau33` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau34` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau35` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau36` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau37` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau38` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau39` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau40` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau41` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau42` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau43` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau44` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau45` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau46` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau47` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau48` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau49` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau50` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau51` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau52` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau53` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau54` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau55` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau56` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau57` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau58` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau59` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau60` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau61` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau62` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau63` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau64` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau65` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau66` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau67` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau68` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau69` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau70` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau71` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau72` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau73` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau74` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau75` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau76` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau77` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau78` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau79` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau80` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau81` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau82` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau83` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau84` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau85` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau86` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau87` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau88` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau89` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau90` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau91` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau92` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau93` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau94` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau95` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau96` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau97` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau98` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau99` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau100` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau101` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau102` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau103` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau104` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau105` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau106` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau107` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau108` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau109` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau110` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau111` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau112` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau113` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau114` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau115` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau116` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau117` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau118` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau119` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau120` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau121` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau122` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau123` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau124` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau125` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau126` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau127` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau128` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau129` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau130` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau131` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau132` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau133` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau134` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau135` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau136` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau137` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau138` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau139` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau140` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau141` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau142` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau143` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau144` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau145` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau146` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau147` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau148` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau149` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau150` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau151` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau152` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau153` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau154` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau155` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau156` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau157` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau158` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau159` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau160` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau161` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau162` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau163` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau164` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau165` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau166` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau167` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau168` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau169` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau170` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau171` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau172` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau173` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau174` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau175` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau176` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau177` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau178` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau179` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau180` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau181` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau182` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau183` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau184` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau185` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau186` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau187` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau188` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau189` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau190` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau191` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau192` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau193` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau194` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau195` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau196` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau197` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau198` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau199` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau200` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau201` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau202` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau203` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau204` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau205` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau206` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau207` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau208` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau209` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau210` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau211` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau212` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau213` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau214` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau215` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau216` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau217` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau218` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau219` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau220` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau221` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau222` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau223` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau224` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau225` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau226` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau227` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau228` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau229` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau230` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau231` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau232` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau233` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau234` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau235` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau236` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau237` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau238` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau239` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau240` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau241` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau242` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau243` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau244` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau245` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau246` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau247` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau248` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau249` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau250` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau251` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau252` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau253` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau254` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau255` int UNSIGNED NOT NULL DEFAULT 0,
  `Gsm` int UNSIGNED NOT NULL DEFAULT 0,
  `Umts` int UNSIGNED NOT NULL DEFAULT 0,
  `Other` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `key_e1_tg`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mscDetail3g
-- ----------------------------
DROP TABLE IF EXISTS `mscDetail3g`;
CREATE TABLE `mscDetail3g`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_tg` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `Attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `Success` int UNSIGNED NOT NULL DEFAULT 0,
  `Duration` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau0` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau1` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau2` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau3` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau4` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau5` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau6` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau7` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau8` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau9` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau10` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau11` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau12` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau13` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau14` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau15` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau16` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau17` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau18` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau19` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau20` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau21` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau22` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau23` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau24` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau25` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau26` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau27` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau28` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau29` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau30` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau31` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau32` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau33` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau34` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau35` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau36` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau37` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau38` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau39` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau40` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau41` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau42` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau43` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau44` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau45` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau46` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau47` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau48` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau49` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau50` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau51` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau52` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau53` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau54` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau55` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau56` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau57` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau58` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau59` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau60` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau61` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau62` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau63` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau64` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau65` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau66` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau67` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau68` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau69` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau70` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau71` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau72` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau73` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau74` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau75` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau76` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau77` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau78` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau79` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau80` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau81` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau82` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau83` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau84` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau85` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau86` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau87` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau88` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau89` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau90` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau91` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau92` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau93` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau94` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau95` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau96` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau97` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau98` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau99` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau100` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau101` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau102` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau103` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau104` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau105` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau106` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau107` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau108` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau109` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau110` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau111` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau112` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau113` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau114` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau115` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau116` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau117` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau118` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau119` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau120` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau121` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau122` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau123` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau124` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau125` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau126` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau127` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau128` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau129` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau130` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau131` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau132` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau133` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau134` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau135` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau136` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau137` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau138` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau139` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau140` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau141` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau142` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau143` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau144` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau145` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau146` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau147` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau148` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau149` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau150` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau151` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau152` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau153` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau154` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau155` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau156` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau157` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau158` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau159` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau160` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau161` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau162` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau163` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau164` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau165` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau166` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau167` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau168` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau169` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau170` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau171` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau172` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau173` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau174` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau175` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau176` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau177` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau178` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau179` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau180` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau181` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau182` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau183` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau184` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau185` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau186` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau187` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau188` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau189` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau190` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau191` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau192` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau193` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau194` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau195` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau196` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau197` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau198` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau199` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau200` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau201` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau202` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau203` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau204` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau205` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau206` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau207` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau208` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau209` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau210` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau211` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau212` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau213` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau214` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau215` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau216` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau217` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau218` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau219` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau220` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau221` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau222` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau223` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau224` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau225` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau226` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau227` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau228` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau229` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau230` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau231` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau232` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau233` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau234` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau235` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau236` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau237` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau238` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau239` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau240` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau241` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau242` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau243` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau244` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau245` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau246` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau247` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau248` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau249` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau250` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau251` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau252` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau253` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau254` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau255` int UNSIGNED NOT NULL DEFAULT 0,
  `Gsm` int UNSIGNED NOT NULL DEFAULT 0,
  `Umts` int UNSIGNED NOT NULL DEFAULT 0,
  `Other` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `key_e1_tg`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mscDetail3gData
-- ----------------------------
DROP TABLE IF EXISTS `mscDetail3gData`;
CREATE TABLE `mscDetail3gData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_tg` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `Attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `Success` int UNSIGNED NOT NULL DEFAULT 0,
  `Duration` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau0` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau1` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau2` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau3` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau4` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau5` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau6` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau7` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau8` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau9` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau10` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau11` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau12` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau13` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau14` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau15` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau16` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau17` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau18` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau19` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau20` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau21` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau22` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau23` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau24` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau25` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau26` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau27` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau28` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau29` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau30` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau31` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau32` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau33` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau34` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau35` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau36` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau37` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau38` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau39` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau40` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau41` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau42` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau43` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau44` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau45` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau46` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau47` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau48` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau49` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau50` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau51` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau52` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau53` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau54` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau55` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau56` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau57` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau58` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau59` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau60` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau61` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau62` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau63` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau64` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau65` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau66` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau67` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau68` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau69` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau70` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau71` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau72` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau73` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau74` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau75` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau76` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau77` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau78` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau79` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau80` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau81` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau82` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau83` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau84` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau85` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau86` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau87` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau88` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau89` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau90` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau91` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau92` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau93` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau94` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau95` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau96` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau97` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau98` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau99` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau100` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau101` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau102` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau103` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau104` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau105` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau106` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau107` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau108` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau109` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau110` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau111` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau112` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau113` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau114` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau115` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau116` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau117` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau118` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau119` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau120` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau121` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau122` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau123` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau124` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau125` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau126` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau127` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau128` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau129` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau130` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau131` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau132` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau133` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau134` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau135` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau136` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau137` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau138` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau139` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau140` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau141` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau142` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau143` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau144` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau145` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau146` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau147` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau148` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau149` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau150` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau151` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau152` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau153` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau154` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau155` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau156` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau157` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau158` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau159` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau160` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau161` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau162` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau163` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau164` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau165` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau166` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau167` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau168` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau169` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau170` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau171` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau172` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau173` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau174` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau175` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau176` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau177` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau178` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau179` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau180` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau181` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau182` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau183` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau184` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau185` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau186` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau187` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau188` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau189` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau190` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau191` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau192` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau193` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau194` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau195` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau196` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau197` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau198` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau199` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau200` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau201` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau202` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau203` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau204` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau205` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau206` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau207` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau208` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau209` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau210` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau211` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau212` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau213` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau214` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau215` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau216` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau217` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau218` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau219` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau220` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau221` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau222` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau223` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau224` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau225` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau226` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau227` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau228` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau229` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau230` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau231` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau232` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau233` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau234` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau235` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau236` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau237` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau238` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau239` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau240` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau241` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau242` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau243` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau244` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau245` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau246` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau247` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau248` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau249` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau250` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau251` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau252` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau253` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau254` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau255` int UNSIGNED NOT NULL DEFAULT 0,
  `Gsm` int UNSIGNED NOT NULL DEFAULT 0,
  `Umts` int UNSIGNED NOT NULL DEFAULT 0,
  `Other` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `key_e1_tg`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mscDetailData
-- ----------------------------
DROP TABLE IF EXISTS `mscDetailData`;
CREATE TABLE `mscDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_tg` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `Attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `Success` int UNSIGNED NOT NULL DEFAULT 0,
  `Duration` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau0` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau1` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau2` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau3` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau4` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau5` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau6` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau7` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau8` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau9` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau10` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau11` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau12` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau13` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau14` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau15` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau16` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau17` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau18` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau19` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau20` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau21` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau22` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau23` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau24` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau25` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau26` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau27` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau28` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau29` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau30` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau31` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau32` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau33` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau34` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau35` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau36` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau37` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau38` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau39` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau40` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau41` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau42` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau43` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau44` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau45` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau46` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau47` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau48` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau49` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau50` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau51` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau52` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau53` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau54` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau55` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau56` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau57` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau58` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau59` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau60` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau61` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau62` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau63` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau64` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau65` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau66` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau67` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau68` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau69` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau70` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau71` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau72` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau73` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau74` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau75` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau76` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau77` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau78` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau79` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau80` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau81` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau82` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau83` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau84` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau85` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau86` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau87` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau88` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau89` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau90` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau91` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau92` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau93` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau94` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau95` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau96` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau97` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau98` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau99` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau100` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau101` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau102` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau103` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau104` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau105` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau106` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau107` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau108` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau109` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau110` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau111` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau112` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau113` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau114` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau115` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau116` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau117` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau118` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau119` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau120` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau121` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau122` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau123` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau124` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau125` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau126` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau127` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau128` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau129` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau130` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau131` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau132` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau133` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau134` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau135` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau136` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau137` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau138` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau139` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau140` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau141` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau142` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau143` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau144` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau145` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau146` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau147` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau148` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau149` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau150` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau151` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau152` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau153` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau154` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau155` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau156` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau157` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau158` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau159` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau160` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau161` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau162` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau163` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau164` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau165` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau166` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau167` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau168` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau169` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau170` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau171` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau172` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau173` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau174` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau175` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau176` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau177` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau178` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau179` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau180` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau181` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau182` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau183` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau184` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau185` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau186` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau187` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau188` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau189` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau190` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau191` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau192` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau193` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau194` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau195` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau196` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau197` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau198` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau199` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau200` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau201` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau202` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau203` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau204` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau205` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau206` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau207` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau208` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau209` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau210` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau211` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau212` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau213` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau214` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau215` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau216` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau217` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau218` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau219` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau220` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau221` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau222` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau223` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau224` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau225` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau226` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau227` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau228` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau229` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau230` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau231` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau232` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau233` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau234` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau235` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau236` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau237` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau238` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau239` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau240` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau241` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau242` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau243` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau244` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau245` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau246` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau247` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau248` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau249` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau250` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau251` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau252` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau253` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau254` int UNSIGNED NOT NULL DEFAULT 0,
  `Cau255` int UNSIGNED NOT NULL DEFAULT 0,
  `Gsm` int UNSIGNED NOT NULL DEFAULT 0,
  `Umts` int UNSIGNED NOT NULL DEFAULT 0,
  `Other` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `key_e1_tg`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mscSum
-- ----------------------------
DROP TABLE IF EXISTS `mscSum`;
CREATE TABLE `mscSum`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_tg` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `Attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `Success` int UNSIGNED NOT NULL DEFAULT 0,
  `Duration` int UNSIGNED NOT NULL DEFAULT 0,
  `Normal` int UNSIGNED NOT NULL DEFAULT 0,
  `CallDeny` int UNSIGNED NOT NULL DEFAULT 0,
  `NetBusy` int UNSIGNED NOT NULL DEFAULT 0,
  `CallerClear` int UNSIGNED NOT NULL DEFAULT 0,
  `SubBusy` int UNSIGNED NOT NULL DEFAULT 0,
  `NoAnswer` int UNSIGNED NOT NULL DEFAULT 0,
  `SignalErr` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `key_e1_tg`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mscSum3g
-- ----------------------------
DROP TABLE IF EXISTS `mscSum3g`;
CREATE TABLE `mscSum3g`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_tg` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `Attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `Success` int UNSIGNED NOT NULL DEFAULT 0,
  `Duration` int UNSIGNED NOT NULL DEFAULT 0,
  `Normal` int UNSIGNED NOT NULL DEFAULT 0,
  `CallDeny` int UNSIGNED NOT NULL DEFAULT 0,
  `NetBusy` int UNSIGNED NOT NULL DEFAULT 0,
  `CallerClear` int UNSIGNED NOT NULL DEFAULT 0,
  `SubBusy` int UNSIGNED NOT NULL DEFAULT 0,
  `NoAnswer` int UNSIGNED NOT NULL DEFAULT 0,
  `SignalErr` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `key_e1_tg`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mscSum3gData
-- ----------------------------
DROP TABLE IF EXISTS `mscSum3gData`;
CREATE TABLE `mscSum3gData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_tg` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `Attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `Success` int UNSIGNED NOT NULL DEFAULT 0,
  `Duration` int UNSIGNED NOT NULL DEFAULT 0,
  `Normal` int UNSIGNED NOT NULL DEFAULT 0,
  `CallDeny` int UNSIGNED NOT NULL DEFAULT 0,
  `NetBusy` int UNSIGNED NOT NULL DEFAULT 0,
  `CallerClear` int UNSIGNED NOT NULL DEFAULT 0,
  `SubBusy` int UNSIGNED NOT NULL DEFAULT 0,
  `NoAnswer` int UNSIGNED NOT NULL DEFAULT 0,
  `SignalErr` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `key_e1_tg`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mscSumData
-- ----------------------------
DROP TABLE IF EXISTS `mscSumData`;
CREATE TABLE `mscSumData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_tg` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `Attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `Success` int UNSIGNED NOT NULL DEFAULT 0,
  `Duration` int UNSIGNED NOT NULL DEFAULT 0,
  `Normal` int UNSIGNED NOT NULL DEFAULT 0,
  `CallDeny` int UNSIGNED NOT NULL DEFAULT 0,
  `NetBusy` int UNSIGNED NOT NULL DEFAULT 0,
  `CallerClear` int UNSIGNED NOT NULL DEFAULT 0,
  `SubBusy` int UNSIGNED NOT NULL DEFAULT 0,
  `NoAnswer` int UNSIGNED NOT NULL DEFAULT 0,
  `SignalErr` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `key_e1_tg`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mtp2Conf
-- ----------------------------
DROP TABLE IF EXISTS `mtp2Conf`;
CREATE TABLE `mtp2Conf`  (
  `key_type` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `description` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `description_2` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`key_type`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mtp2Detail
-- ----------------------------
DROP TABLE IF EXISTS `mtp2Detail`;
CREATE TABLE `mtp2Detail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `port0` smallint UNSIGNED NOT NULL DEFAULT 0,
  `port1` smallint UNSIGNED NOT NULL DEFAULT 0,
  `port2` smallint UNSIGNED NOT NULL DEFAULT 0,
  `port3` smallint UNSIGNED NOT NULL DEFAULT 0,
  `port4` smallint UNSIGNED NOT NULL DEFAULT 0,
  `port5` smallint UNSIGNED NOT NULL DEFAULT 0,
  `port6` smallint UNSIGNED NOT NULL DEFAULT 0,
  `port7` smallint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mtp3Conf
-- ----------------------------
DROP TABLE IF EXISTS `mtp3Conf`;
CREATE TABLE `mtp3Conf`  (
  `key_type` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `description` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `description_2` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`key_type`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for mtp3Detail
-- ----------------------------
DROP TABLE IF EXISTS `mtp3Detail`;
CREATE TABLE `mtp3Detail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `local_auto_chgover` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `local_auto_chgback` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sl_restoration` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_unavai_sl` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_inhib_local_mana` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_inhib_remote_mana` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_unavai_link` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_unavai_remote_proc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_remote_proc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_remote_proc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `local_mana_inhib` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `local_mana_uninhib` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_local_busy` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_local_inhib` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `end_local_inhib` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_remote_inhib` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `end_remote_inhib` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_unavai_set` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_set_failure` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_set_failure` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tft_failure_set` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tfa_recov_set` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `adja_sp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_adja_sp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_adja_sp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `normal_route_unava_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_normal_route_unava_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alter_route_unava_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_alter_route_unavai_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `normal_route_unava_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_normal_route_unava_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alter_route_unava_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_alter_route_unavai_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `normal_route_unava_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_normal_route_unava_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alter_route_unava_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_alter_route_unavai_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `normal_route_unava_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_normal_route_unava_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alter_route_unava_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_alter_route_unavai_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `snm_message_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_message_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sccp_message_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tup_message_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `isup_message_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `snm_message_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_message_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sccp_message_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tup_message_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `isup_message_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `snm_message_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_message_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sccp_message_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tup_message_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `isup_message_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `snm_message_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_message_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sccp_message_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tup_message_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `isup_message_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `msu_sccp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `msu_tup` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `msu_isup` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_e1_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for mtp3DetailData
-- ----------------------------
DROP TABLE IF EXISTS `mtp3DetailData`;
CREATE TABLE `mtp3DetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `local_auto_chgover` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `local_auto_chgback` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sl_restoration` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_unavai_sl` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_inhib_local_mana` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_inhib_remote_mana` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_unavai_link` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_unavai_remote_proc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_remote_proc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_remote_proc` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `local_mana_inhib` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `local_mana_uninhib` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_local_busy` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_local_inhib` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `end_local_inhib` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_remote_inhib` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `end_remote_inhib` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_unavai_set` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_set_failure` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_set_failure` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tft_failure_set` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tfa_recov_set` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `adja_sp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_adja_sp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_adja_sp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `normal_route_unava_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_normal_route_unava_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alter_route_unava_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_alter_route_unavai_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `normal_route_unava_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_normal_route_unava_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alter_route_unava_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_alter_route_unavai_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `normal_route_unava_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_normal_route_unava_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alter_route_unava_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_alter_route_unavai_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `normal_route_unava_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_normal_route_unava_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `alter_route_unava_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_alter_route_unavai_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `snm_message_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_message_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sccp_message_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tup_message_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `isup_message_0` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `snm_message_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_message_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sccp_message_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tup_message_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `isup_message_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `snm_message_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_message_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sccp_message_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tup_message_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `isup_message_2` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `snm_message_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_message_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sccp_message_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tup_message_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `isup_message_3` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `msu_sccp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `msu_tup` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `msu_isup` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_e1_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for oppsDetail
-- ----------------------------
DROP TABLE IF EXISTS `oppsDetail`;
CREATE TABLE `oppsDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `man_reg_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `man_reg_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `auto_reg_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `auto_reg_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `opr_lu_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `opr_lu_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `oth_lu_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `oth_lu_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `recy_sub_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `recy_sub_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `swi_roam_mode_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `swi_roam_mode_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `swi_opr_mode_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `swi_opr_mode_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `pri_to_pri` int UNSIGNED NOT NULL DEFAULT 0,
  `hyb_to_pri` int UNSIGNED NOT NULL DEFAULT 0,
  `hyb_to_pub` int UNSIGNED NOT NULL DEFAULT 0,
  `pub_to_pub` int UNSIGNED NOT NULL DEFAULT 0,
  `ord_to_pub` int UNSIGNED NOT NULL DEFAULT 0,
  `pub_to_pri` int UNSIGNED NOT NULL DEFAULT 0,
  `ord_lu_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `hyb_lu_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `pub_lu_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `ord_lu_exc` int UNSIGNED NOT NULL DEFAULT 0,
  `hyb_lu_exc` int UNSIGNED NOT NULL DEFAULT 0,
  `pub_lu_exc` int UNSIGNED NOT NULL DEFAULT 0,
  `pre_lu_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `pre_lu_exc` int UNSIGNED NOT NULL DEFAULT 0,
  `pre_to_pub` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for oppsDetailData
-- ----------------------------
DROP TABLE IF EXISTS `oppsDetailData`;
CREATE TABLE `oppsDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `man_reg_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `man_reg_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `auto_reg_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `auto_reg_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `opr_lu_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `opr_lu_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `oth_lu_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `oth_lu_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `recy_sub_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `recy_sub_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `swi_roam_mode_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `swi_roam_mode_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `swi_opr_mode_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `swi_opr_mode_fail` int UNSIGNED NOT NULL DEFAULT 0,
  `pri_to_pri` int UNSIGNED NOT NULL DEFAULT 0,
  `hyb_to_pri` int UNSIGNED NOT NULL DEFAULT 0,
  `hyb_to_pub` int UNSIGNED NOT NULL DEFAULT 0,
  `pub_to_pub` int UNSIGNED NOT NULL DEFAULT 0,
  `ord_to_pub` int UNSIGNED NOT NULL DEFAULT 0,
  `pub_to_pri` int UNSIGNED NOT NULL DEFAULT 0,
  `ord_lu_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `hyb_lu_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `pub_lu_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `ord_lu_exc` int UNSIGNED NOT NULL DEFAULT 0,
  `hyb_lu_exc` int UNSIGNED NOT NULL DEFAULT 0,
  `pub_lu_exc` int UNSIGNED NOT NULL DEFAULT 0,
  `pre_lu_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `pre_lu_exc` int UNSIGNED NOT NULL DEFAULT 0,
  `pre_to_pub` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for pcr8Detail
-- ----------------------------
DROP TABLE IF EXISTS `pcr8Detail`;
CREATE TABLE `pcr8Detail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_tg` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `att` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ans` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `caller_clear` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `no_ans` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `subscriber_busy` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `network_busy` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `call_barred` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `signaling_timer_expired` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `total_holding_time` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `att_mosmf_10` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suc_mosmf_10` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `att_mtsmf_10` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suc_mtsof_10` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `key_e1_tg`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for pcrDetail
-- ----------------------------
DROP TABLE IF EXISTS `pcrDetail`;
CREATE TABLE `pcrDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_tg` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `att` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ans` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `caller_clear` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `no_ans` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `subscriber_busy` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `network_busy` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `call_barred` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `signaling_timer_expired` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `total_holding_time` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `att_mosmf_10` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suc_mosmf_10` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `att_mtsmf_10` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suc_mtsof_10` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `key_e1_tg`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for ppsDetail
-- ----------------------------
DROP TABLE IF EXISTS `ppsDetail`;
CREATE TABLE `ppsDetail`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `local_calling_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `trunk_out_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `NDD_call_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `HMT_call_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `IDD_call_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `local_called_nums` int NOT NULL DEFAULT 0,
  `call_in_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `periodic_charge_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `assisted_recharge_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `assisted_withdraw_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `recharge_success_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `recharge_fail_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `cnf_sums` int UNSIGNED NOT NULL DEFAULT 0,
  `third_party_nums` int NOT NULL DEFAULT 0,
  `emergency_call_nums` int NOT NULL DEFAULT 0,
  `local_calling_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `trunk_out_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `NDD_call_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `HMT_call_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `IDD_call_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `local_called_cost` int NOT NULL DEFAULT 0,
  `call_in_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `periodic_charge_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `assisted_recharge_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `assisted_withdraw_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `recharge_success_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `recharge_fail_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `cnf_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `third_party_cost` int NOT NULL DEFAULT 0,
  `emergency_call_cost` int NOT NULL DEFAULT 0,
  `local_calling_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `trunk_out_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `NDD_call_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `HMT_call_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `IDD_call_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `local_called_duration` int NOT NULL DEFAULT 0,
  `call_in_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `periodic_charge_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `assisted_recharge_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `assisted_withdraw_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `recharge_success_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `recharge_fail_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `cnf_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `third_party_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `emergency_call_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `gprs_attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `gprs_tol_charge` int UNSIGNED NOT NULL DEFAULT 0,
  `gprs_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `gprs_tol_volume` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for ppsDetailData
-- ----------------------------
DROP TABLE IF EXISTS `ppsDetailData`;
CREATE TABLE `ppsDetailData`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `local_calling_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `trunk_out_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `NDD_call_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `HMT_call_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `IDD_call_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `local_called_nums` int NOT NULL DEFAULT 0,
  `call_in_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `periodic_charge_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `assisted_recharge_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `assisted_withdraw_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `recharge_success_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `recharge_fail_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_nums` int UNSIGNED NOT NULL DEFAULT 0,
  `cnf_sums` int UNSIGNED NOT NULL DEFAULT 0,
  `third_party_nums` int NOT NULL DEFAULT 0,
  `emergency_call_nums` int NOT NULL DEFAULT 0,
  `local_calling_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `trunk_out_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `NDD_call_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `HMT_call_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `IDD_call_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `local_called_cost` int NOT NULL DEFAULT 0,
  `call_in_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `periodic_charge_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `assisted_recharge_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `assisted_withdraw_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `recharge_success_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `recharge_fail_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `cnf_cost` int UNSIGNED NOT NULL DEFAULT 0,
  `third_party_cost` int NOT NULL DEFAULT 0,
  `emergency_call_cost` int NOT NULL DEFAULT 0,
  `local_calling_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `trunk_out_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `NDD_call_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `HMT_call_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `IDD_call_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `local_called_duration` int NOT NULL DEFAULT 0,
  `call_in_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `periodic_charge_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `assisted_recharge_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `assisted_withdraw_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `recharge_success_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `recharge_fail_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `sm_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `cnf_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `third_party_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `emergency_call_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `gprs_attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `gprs_tol_charge` int UNSIGNED NOT NULL DEFAULT 0,
  `gprs_duration` int UNSIGNED NOT NULL DEFAULT 0,
  `gprs_tol_volume` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for ranapDetail
-- ----------------------------
DROP TABLE IF EXISTS `ranapDetail`;
CREATE TABLE `ranapDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_paging_resp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_paging_resp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_ho_cmb_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_ho_cmb_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_imsi_detach_ind_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_imsi_detach_ind_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_lu_accept_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_lu_accept_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_lu_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_lu_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_lu_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_lu_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_response_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_response_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_id_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_id_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_id_response_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_id_response_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_tmsi_pealloc_cmd_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_tmsi_pealloc_cmd_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_tmsi_pealloc_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_tmsi_pealloc_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_failure_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_failure_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_accept_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_accept_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_abort_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_abort_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_prompt_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_prompt_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_reset_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_reset_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_abort_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_abort_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_mm_null_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_mm_null_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_mm_status_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_mm_status_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_mm_info_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_mm_info_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cp_data_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cp_data_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cp_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cp_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cp_error_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cp_error_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_facility_ss_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_facility_ss_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_register_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_register_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_release_cmp_ss_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_release_cmp_ss_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_alerting_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_alerting_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_call_proceeding_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_call_proceeding_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_progress_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_progress_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_setup_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_setup_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_connect_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_connect_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_call_confirmed_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_call_confirmed_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_emergency_setup_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_emergency_setup_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_connect_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_connect_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_user_info_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_user_info_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_modify_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_modify_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_modify_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_modify_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_hold_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_hold_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_hold_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_hold_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_hold_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_hold_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_retrieve_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_retrieve_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_retrieve_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_retrieve_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_retrieve_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_retrieve_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_modify_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_modify_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_disconnect_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_disconnect_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_release_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_release_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_release_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_release_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_stop_dtmf_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_stop_dtmf_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_stop_dtmf_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_stop_dtmf_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_status_enq_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_status_enq_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_start_dtmf_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_start_dtmf_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_start_dtmf_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_start_dtmf_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_start_dtmf_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_start_dtmf_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_congestion_ctrl_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_congestion_ctrl_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_facility_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_facility_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_status_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_status_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_notify_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_notify_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unkown_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unkown_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_release_command_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_release_command_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_release_complete_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_release_complete_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_required_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_required_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_command_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_command_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_preparation_fail_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_preparation_fail_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_request_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_request_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_failure_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_failure_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_cancel_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_cancel_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_cancel_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_cancel_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srns_context_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srns_context_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srns_context_response_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srns_context_response_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `security_mode_command_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `security_mode_command_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `security_mode_complete_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `security_mode_complete_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `security_mode_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `security_mode_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `data_volume_report_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `data_volume_report_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `data_volume_report_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `data_volume_report_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_resource_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_resource_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_resource_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_resource_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_related_data_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_related_data_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_related_data_response_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_related_data_response_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_related_data_failure_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_related_data_failure_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rab_modify_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rab_modify_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rab_release_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rab_release_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_release_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_release_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_detect_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_detect_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_complete_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_complete_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srns_data_forward_command_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srns_data_forward_command_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `forward_srns_context_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `forward_srns_context_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `forward_trans_context_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `forward_trans_context_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `paging_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `paging_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `common_id_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `common_id_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cn_invoke_trace_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cn_invoke_trace_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cn_deactivate_trace_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cn_deactivate_trace_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_reporting_control_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_reporting_control_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_report_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_report_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `initial_ue_message_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `initial_ue_message_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `direct_tranfer_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `direct_tranfer_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `overload_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `overload_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `error_indication_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `error_indication_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `pab_assignment_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `pab_assignment_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rab_assignment_response_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rab_assignment_response_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for ranapDetailData
-- ----------------------------
DROP TABLE IF EXISTS `ranapDetailData`;
CREATE TABLE `ranapDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_paging_resp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_paging_resp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_ho_cmb_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_ho_cmb_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_imsi_detach_ind_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_imsi_detach_ind_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_lu_accept_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_lu_accept_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_lu_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_lu_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_lu_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_lu_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_response_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_response_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_id_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_id_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_id_response_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_id_response_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_tmsi_pealloc_cmd_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_tmsi_pealloc_cmd_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_tmsi_pealloc_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_tmsi_pealloc_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_failure_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_auth_failure_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_accept_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_accept_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_abort_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_abort_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_prompt_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_prompt_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_reset_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cm_reset_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_abort_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_abort_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_mm_null_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_mm_null_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_mm_status_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_mm_status_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_mm_info_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_mm_info_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cp_data_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cp_data_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cp_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cp_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cp_error_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_cp_error_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_facility_ss_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_facility_ss_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_register_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_register_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_release_cmp_ss_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_release_cmp_ss_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_alerting_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_alerting_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_call_proceeding_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_call_proceeding_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_progress_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_progress_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_setup_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_setup_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_connect_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_connect_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_call_confirmed_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_call_confirmed_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_emergency_setup_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_emergency_setup_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_connect_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_connect_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_user_info_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_user_info_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_modify_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_modify_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_modify_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_modify_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_hold_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_hold_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_hold_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_hold_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_hold_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_hold_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_retrieve_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_retrieve_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_retrieve_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_retrieve_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_retrieve_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_retrieve_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_modify_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_modify_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_disconnect_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_disconnect_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_release_cmp_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_release_cmp_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_release_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_release_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_stop_dtmf_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_stop_dtmf_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_stop_dtmf_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_stop_dtmf_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_status_enq_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_status_enq_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_start_dtmf_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_start_dtmf_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_start_dtmf_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_start_dtmf_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_start_dtmf_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_start_dtmf_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_congestion_ctrl_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_congestion_ctrl_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_facility_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_facility_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_status_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_status_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_notify_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dtap_notify_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unkown_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unkown_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_release_command_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_release_command_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_release_complete_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_release_complete_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_required_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_required_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_command_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_command_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_preparation_fail_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_preparation_fail_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_request_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_request_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_failure_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_failure_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_cancel_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_cancel_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_cancel_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_cancel_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srns_context_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srns_context_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srns_context_response_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srns_context_response_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `security_mode_command_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `security_mode_command_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `security_mode_complete_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `security_mode_complete_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `security_mode_reject_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `security_mode_reject_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `data_volume_report_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `data_volume_report_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `data_volume_report_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `data_volume_report_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_resource_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_resource_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_resource_ack_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reset_resource_ack_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_related_data_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_related_data_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_related_data_response_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_related_data_response_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_related_data_failure_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_related_data_failure_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rab_modify_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rab_modify_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rab_release_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rab_release_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_release_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lu_release_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_detect_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_detect_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_complete_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `relocation_complete_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srns_data_forward_command_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srns_data_forward_command_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `forward_srns_context_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `forward_srns_context_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `forward_trans_context_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `forward_trans_context_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `paging_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `paging_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `common_id_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `common_id_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cn_invoke_trace_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cn_invoke_trace_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cn_deactivate_trace_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cn_deactivate_trace_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_reporting_control_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_reporting_control_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_report_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `location_report_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `initial_ue_message_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `initial_ue_message_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `direct_tranfer_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `direct_tranfer_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `overload_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `overload_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `error_indication_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `error_indication_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `pab_assignment_request_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `pab_assignment_request_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rab_assignment_response_r` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rab_assignment_response_s` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for rcsDetail
-- ----------------------------
DROP TABLE IF EXISTS `rcsDetail`;
CREATE TABLE `rcsDetail`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `key_pod_id` smallint UNSIGNED NOT NULL DEFAULT 0,
  `numRtpBRecvUplink` int UNSIGNED NULL DEFAULT 0,
  `numRtpPRecvUplink` int UNSIGNED NULL DEFAULT 0,
  `numRtpBSentUplink` int UNSIGNED NULL DEFAULT 0,
  `numRtpPSentUplink` int UNSIGNED NULL DEFAULT 0,
  `numRtpBRecvDnlink` int UNSIGNED NULL DEFAULT 0,
  `numRtpPRecvDnlink` int UNSIGNED NULL DEFAULT 0,
  `numRtpBSentDnlink` int UNSIGNED NULL DEFAULT 0,
  `numRtpPSentDnlink` int UNSIGNED NULL DEFAULT 0,
  `numLsCall` int UNSIGNED NOT NULL DEFAULT 0,
  `numGtpKBRecvUplink` int UNSIGNED NULL DEFAULT 0,
  `numGtpPRecvUplink` int UNSIGNED NULL DEFAULT 0,
  `numGtpKBSentUplink` int UNSIGNED NULL DEFAULT 0,
  `numGtpPSentUplink` int UNSIGNED NULL DEFAULT 0,
  `numGtpKBRecvDnlink` int UNSIGNED NULL DEFAULT 0,
  `numGtpPRecvDnlink` int UNSIGNED NULL DEFAULT 0,
  `numGtpKBSentDnlink` int UNSIGNED NULL DEFAULT 0,
  `numGtpPSentDnlink` int UNSIGNED NULL DEFAULT 0,
  `numLuAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numLuSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numDetach` int UNSIGNED NOT NULL DEFAULT 0,
  `numMoAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numMoSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numMoNoAnswer` int UNSIGNED NOT NULL DEFAULT 0,
  `numMtAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numMtSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numMtNoAnswer` int UNSIGNED NOT NULL DEFAULT 0,
  `numEmoAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numEmoSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numEmoNoAnswer` int UNSIGNED NOT NULL DEFAULT 0,
  `numSmoAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numSmoSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numSmtAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numSmtSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numGprsAttachAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numGprsAttachSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numRauAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numRauSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numPdpActAttempt` int UNSIGNED NULL DEFAULT 0,
  `numPdpActSuccess` int UNSIGNED NULL DEFAULT 0,
  `numPdpDeact` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUnk` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUN` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNRTD` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFCUA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFODB` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNCC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUB` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNUR` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUANA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFCR` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFCRDTFAD` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFPEMP` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNSUC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFDOOO` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFINF` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFFR` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRTSE` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNU` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNCA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNOOO` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFTF` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFSEC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFAID` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRCNA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRU` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFQOSU` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRFNS` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFIClBWTC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFBCNA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFBCNPA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFSOONA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFBSNI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFAETOGTAM` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRFNI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFORDICIA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFSOONI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFITIV` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUNMOC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFID` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFITNS` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFSIM` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFIMI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFMTNEONI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFMTNCWPS` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFIENEONI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFCE` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFMNCWPS` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFROTE` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFPE` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFIW` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUnk` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUN` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNRTD` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFCUA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFODB` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNCC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUB` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNUR` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUANA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFCR` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFCRDTFAD` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFPEMP` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNSUC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFDOOO` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFINF` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFFR` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRTSE` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNU` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNCA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNOOO` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFTF` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFSEC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFAID` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRCNA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRU` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFQOSU` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRFNS` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFIClBWTC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFBCNA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFBCNPA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFSOONA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFBSNI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFAETOGTAM` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRFNI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFORDICIA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFSOONI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFITIV` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUNMOC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFID` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFITNS` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFSIM` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFIMI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFMTNEONI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFMTNCWPS` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFIENEONI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFCE` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFMNCWPS` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFROTE` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFPE` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFIW` int UNSIGNED NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for rcsDetailData
-- ----------------------------
DROP TABLE IF EXISTS `rcsDetailData`;
CREATE TABLE `rcsDetailData`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `key_pod_id` smallint UNSIGNED NOT NULL DEFAULT 0,
  `numRtpBRecvUplink` int UNSIGNED NULL DEFAULT 0,
  `numRtpPRecvUplink` int UNSIGNED NULL DEFAULT 0,
  `numRtpBSentUplink` int UNSIGNED NULL DEFAULT 0,
  `numRtpPSentUplink` int UNSIGNED NULL DEFAULT 0,
  `numRtpBRecvDnlink` int UNSIGNED NULL DEFAULT 0,
  `numRtpPRecvDnlink` int UNSIGNED NULL DEFAULT 0,
  `numRtpBSentDnlink` int UNSIGNED NULL DEFAULT 0,
  `numRtpPSentDnlink` int UNSIGNED NULL DEFAULT 0,
  `numLsCall` int UNSIGNED NOT NULL DEFAULT 0,
  `numGtpKBRecvUplink` int UNSIGNED NULL DEFAULT 0,
  `numGtpPRecvUplink` int UNSIGNED NULL DEFAULT 0,
  `numGtpKBSentUplink` int UNSIGNED NULL DEFAULT 0,
  `numGtpPSentUplink` int UNSIGNED NULL DEFAULT 0,
  `numGtpKBRecvDnlink` int UNSIGNED NULL DEFAULT 0,
  `numGtpPRecvDnlink` int UNSIGNED NULL DEFAULT 0,
  `numGtpKBSentDnlink` int UNSIGNED NULL DEFAULT 0,
  `numGtpPSentDnlink` int UNSIGNED NULL DEFAULT 0,
  `numLuAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numLuSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numDetach` int UNSIGNED NOT NULL DEFAULT 0,
  `numMoAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numMoSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numMoNoAnswer` int UNSIGNED NOT NULL DEFAULT 0,
  `numMtAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numMtSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numMtNoAnswer` int UNSIGNED NOT NULL DEFAULT 0,
  `numEmoAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numEmoSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numEmoNoAnswer` int UNSIGNED NOT NULL DEFAULT 0,
  `numSmoAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numSmoSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numSmtAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numSmtSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numGprsAttachAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numGprsAttachSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numRauAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numRauSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numPdpActAttempt` int UNSIGNED NULL DEFAULT 0,
  `numPdpActSuccess` int UNSIGNED NULL DEFAULT 0,
  `numPdpDeact` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUnk` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUN` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNRTD` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFCUA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFODB` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNCC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUB` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNUR` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUANA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFCR` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFCRDTFAD` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFPEMP` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNSUC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFDOOO` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFINF` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFFR` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRTSE` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNU` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNCA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNOOO` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFTF` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFSEC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFAID` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRCNA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRU` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFQOSU` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRFNS` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFIClBWTC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFBCNA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFBCNPA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFSOONA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFBSNI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFAETOGTAM` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRFNI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFORDICIA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFSOONI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFITIV` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUNMOC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFID` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFITNS` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFSIM` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFIMI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFMTNEONI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFMTNCWPS` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFIENEONI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFCE` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFMNCWPS` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFROTE` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFPE` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFIW` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUnk` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUN` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNRTD` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFCUA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFODB` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNCC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUB` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNUR` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUANA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFCR` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFCRDTFAD` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFPEMP` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNSUC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFDOOO` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFINF` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFFR` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRTSE` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNU` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNCA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNOOO` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFTF` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFSEC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFAID` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRCNA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRU` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFQOSU` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRFNS` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFIClBWTC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFBCNA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFBCNPA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFSOONA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFBSNI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFAETOGTAM` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRFNI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFORDICIA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFSOONI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFITIV` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUNMOC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFID` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFITNS` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFSIM` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFIMI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFMTNEONI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFMTNCWPS` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFIENEONI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFCE` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFMNCWPS` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFROTE` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFPE` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFIW` int UNSIGNED NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for rcsSum
-- ----------------------------
DROP TABLE IF EXISTS `rcsSum`;
CREATE TABLE `rcsSum`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `key_pod_id` smallint UNSIGNED NOT NULL DEFAULT 0,
  `numRtpBRecvUplink` int UNSIGNED NULL DEFAULT 0,
  `numRtpPRecvUplink` int UNSIGNED NULL DEFAULT 0,
  `numRtpBSentUplink` int UNSIGNED NULL DEFAULT 0,
  `numRtpPSentUplink` int UNSIGNED NULL DEFAULT 0,
  `numRtpBRecvDnlink` int UNSIGNED NULL DEFAULT 0,
  `numRtpPRecvDnlink` int UNSIGNED NULL DEFAULT 0,
  `numRtpBSentDnlink` int UNSIGNED NULL DEFAULT 0,
  `numRtpPSentDnlink` int UNSIGNED NULL DEFAULT 0,
  `numLsCall` int UNSIGNED NOT NULL DEFAULT 0,
  `numGtpKBRecvUplink` int UNSIGNED NULL DEFAULT 0,
  `numGtpPRecvUplink` int UNSIGNED NULL DEFAULT 0,
  `numGtpKBSentUplink` int UNSIGNED NULL DEFAULT 0,
  `numGtpPSentUplink` int UNSIGNED NULL DEFAULT 0,
  `numGtpKBRecvDnlink` int UNSIGNED NULL DEFAULT 0,
  `numGtpPRecvDnlink` int UNSIGNED NULL DEFAULT 0,
  `numGtpKBSentDnlink` int UNSIGNED NULL DEFAULT 0,
  `numGtpPSentDnlink` int UNSIGNED NULL DEFAULT 0,
  `numLuAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numLuSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numDetach` int UNSIGNED NOT NULL DEFAULT 0,
  `numMoAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numMoSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numMoNoAnswer` int UNSIGNED NOT NULL DEFAULT 0,
  `numMtAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numMtSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numMtNoAnswer` int UNSIGNED NOT NULL DEFAULT 0,
  `numEmoAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numEmoSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numEmoNoAnswer` int UNSIGNED NOT NULL DEFAULT 0,
  `numSmoAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numSmoSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numSmtAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numSmtSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numGprsAttachAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numGprsAttachSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numRauAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `numRauSuccess` int UNSIGNED NOT NULL DEFAULT 0,
  `numPdpActAttempt` int UNSIGNED NULL DEFAULT 0,
  `numPdpActSuccess` int UNSIGNED NULL DEFAULT 0,
  `numPdpDeact` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUnk` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUN` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNRTD` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFCUA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFODB` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNCC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUB` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNUR` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUANA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFCR` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFCRDTFAD` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFPEMP` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNSUC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFDOOO` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFINF` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFFR` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRTSE` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNU` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNCA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFNOOO` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFTF` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFSEC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFAID` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRCNA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRU` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFQOSU` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRFNS` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFIClBWTC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFBCNA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFBCNPA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFSOONA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFBSNI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFAETOGTAM` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFRFNI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFORDICIA` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFSOONI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFITIV` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFUNMOC` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFID` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFITNS` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFSIM` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFIMI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFMTNEONI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFMTNCWPS` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFIENEONI` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFCE` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFMNCWPS` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFROTE` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFPE` int UNSIGNED NULL DEFAULT 0,
  `numMoVocFIW` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUnk` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUN` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNRTD` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFCUA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFODB` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNCC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUB` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNUR` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUANA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFCR` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFCRDTFAD` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFPEMP` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNSUC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFDOOO` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFINF` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFFR` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRTSE` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNU` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNCA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFNOOO` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFTF` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFSEC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFAID` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRCNA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRU` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFQOSU` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRFNS` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFIClBWTC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFBCNA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFBCNPA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFSOONA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFBSNI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFAETOGTAM` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFRFNI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFORDICIA` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFSOONI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFITIV` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFUNMOC` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFID` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFITNS` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFSIM` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFIMI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFMTNEONI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFMTNCWPS` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFIENEONI` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFCE` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFMNCWPS` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFROTE` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFPE` int UNSIGNED NULL DEFAULT 0,
  `numMtVocFIW` int UNSIGNED NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for sccpDetail
-- ----------------------------
DROP TABLE IF EXISTS `sccpDetail`;
CREATE TABLE `sccpDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_id` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `rf_nt_nature_addr` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rf_nt_spec_addr` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rf_network_failure` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rf_network_cong` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rf_subsys_failure` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rf_subsys_cong` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rf_unequ_user` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_negative_ack` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `syntax_error` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rf_unqualified` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `re_timer_treass_expiry` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `re_seg_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `re_no_reas_space` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hop_counter_viola` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mes_seg` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `failure_super` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `timer_tiar_expiry` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `pi_reset_conn` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `pi_release_conn` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `se_seg_not_supp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `se_seg_failed` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `re_reas_failed` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `slsu_failure` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_main_made_busy` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_cong` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_all` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `soos_grant_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `soos_request_denied` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cong_mes_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_lsp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_lsp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `spm_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sam_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_handled_subsys` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_inten_subsys` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_requiring_trans` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_orig_pcss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_term_pcss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mes_sent_backup_subsys` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dt1_mes_recei_mpss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dt1_mes_sent_mpss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dt2_mes_recei_mpss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dt2_mes_sent_mpss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ed_mes_sent_mpss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ed_mes_recei_mpss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udt_mes_sent` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udts_mes_sent` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udt_mes_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udts_mes_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cr_mes_sent_isdn` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cree_mes_sent_mtp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cr_mes_recei_isdn` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cref_mes_recei_mtp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rsr_mes_sent_mtp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rsr_mes_recei_mtp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `err_mes_sent_mtp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `err_mes_recei_mtp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `xudt_mes_sent` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `xudts_mes_sent` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `xudt_mes_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `xudts_mes_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ludt_mes_sent` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ludts_mes_sent` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ludt_mes_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ludts_mes_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for sccpDetailData
-- ----------------------------
DROP TABLE IF EXISTS `sccpDetailData`;
CREATE TABLE `sccpDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_id` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `rf_nt_nature_addr` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rf_nt_spec_addr` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rf_network_failure` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rf_network_cong` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rf_subsys_failure` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rf_subsys_cong` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rf_unequ_user` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_negative_ack` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `syntax_error` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rf_unqualified` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `re_timer_treass_expiry` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `re_seg_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `re_no_reas_space` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `hop_counter_viola` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mes_seg` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `failure_super` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `timer_tiar_expiry` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `pi_reset_conn` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `pi_release_conn` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `se_seg_not_supp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `se_seg_failed` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `re_reas_failed` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `slsu_failure` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_main_made_busy` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_cong` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_all` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `soos_grant_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `soos_request_denied` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cong_mes_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `start_lsp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `stop_lsp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `spm_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sam_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_handled_subsys` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_inten_subsys` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_requiring_trans` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_orig_pcss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tm_term_pcss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mes_sent_backup_subsys` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dt1_mes_recei_mpss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dt1_mes_sent_mpss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dt2_mes_recei_mpss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dt2_mes_sent_mpss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ed_mes_sent_mpss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ed_mes_recei_mpss` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udt_mes_sent` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udts_mes_sent` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udt_mes_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `udts_mes_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cr_mes_sent_isdn` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cree_mes_sent_mtp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cr_mes_recei_isdn` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `cref_mes_recei_mtp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rsr_mes_sent_mtp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rsr_mes_recei_mtp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `err_mes_sent_mtp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `err_mes_recei_mtp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `xudt_mes_sent` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `xudts_mes_sent` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `xudt_mes_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `xudts_mes_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ludt_mes_sent` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ludts_mes_sent` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ludt_mes_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ludts_mes_recei` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for smegDetail
-- ----------------------------
DROP TABLE IF EXISTS `smegDetail`;
CREATE TABLE `smegDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `in_email_att` int UNSIGNED NOT NULL DEFAULT 0,
  `in_email_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `out_email_att` int UNSIGNED NOT NULL DEFAULT 0,
  `out_email_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `in_sms_att` int UNSIGNED NOT NULL DEFAULT 0,
  `in_sms_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `out_sms_att` int UNSIGNED NOT NULL DEFAULT 0,
  `out_sms_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for smegDetailData
-- ----------------------------
DROP TABLE IF EXISTS `smegDetailData`;
CREATE TABLE `smegDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `in_email_att` int UNSIGNED NOT NULL DEFAULT 0,
  `in_email_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `out_email_att` int UNSIGNED NOT NULL DEFAULT 0,
  `out_email_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `in_sms_att` int UNSIGNED NOT NULL DEFAULT 0,
  `in_sms_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `out_sms_att` int UNSIGNED NOT NULL DEFAULT 0,
  `out_sms_suc` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for smscDetail
-- ----------------------------
DROP TABLE IF EXISTS `smscDetail`;
CREATE TABLE `smscDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `MAP_to_SMSC_attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `MAP_to_SMSC_success` int UNSIGNED NOT NULL DEFAULT 0,
  `MAP_to_SMSC_sysfail` int UNSIGNED NOT NULL DEFAULT 0,
  `MAP_to_SMSC_userfail` int UNSIGNED NOT NULL DEFAULT 0,
  `MAP_to_SMSC_smfail` int UNSIGNED NOT NULL DEFAULT 0,
  `MAP_to_SMSC_byte` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_MAP_attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_MAP_success` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_MAP_sysfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_MAP_userfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_MAP_smfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_MAP_byte` int UNSIGNED NOT NULL DEFAULT 0,
  `SIP_to_SMSC_attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `SIP_to_SMSC_success` int UNSIGNED NOT NULL DEFAULT 0,
  `SIP_to_SMSC_sysfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SIP_to_SMSC_userfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SIP_to_SMSC_smfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SIP_to_SMSC_byte` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_SIP_attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_SIP_success` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_SIP_sysfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_SIP_userfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_SIP_smfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_SIP_byte` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for smscDetailData
-- ----------------------------
DROP TABLE IF EXISTS `smscDetailData`;
CREATE TABLE `smscDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `MAP_to_SMSC_attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `MAP_to_SMSC_success` int UNSIGNED NOT NULL DEFAULT 0,
  `MAP_to_SMSC_sysfail` int UNSIGNED NOT NULL DEFAULT 0,
  `MAP_to_SMSC_userfail` int UNSIGNED NOT NULL DEFAULT 0,
  `MAP_to_SMSC_smfail` int UNSIGNED NOT NULL DEFAULT 0,
  `MAP_to_SMSC_byte` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_MAP_attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_MAP_success` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_MAP_sysfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_MAP_userfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_MAP_smfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_MAP_byte` int UNSIGNED NOT NULL DEFAULT 0,
  `SIP_to_SMSC_attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `SIP_to_SMSC_success` int UNSIGNED NOT NULL DEFAULT 0,
  `SIP_to_SMSC_sysfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SIP_to_SMSC_userfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SIP_to_SMSC_smfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SIP_to_SMSC_byte` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_SIP_attempt` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_SIP_success` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_SIP_sysfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_SIP_userfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_SIP_smfail` int UNSIGNED NOT NULL DEFAULT 0,
  `SMSC_to_SIP_byte` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for smscSmppData
-- ----------------------------
DROP TABLE IF EXISTS `smscSmppData`;
CREATE TABLE `smscSmppData`  (
  `key_sys_id` tinyint NOT NULL DEFAULT 0,
  `key_type` tinyint NOT NULL DEFAULT 0,
  `smppId` int NOT NULL COMMENT 'smmpNum',
  `SMPP_to_SMSC_attempt` int NOT NULL DEFAULT 0,
  `SMPP_to_SMSC_success` int NOT NULL DEFAULT 0,
  `SMPP_to_SMSC_sysfail` int NOT NULL DEFAULT 0,
  `SMPP_to_SMSC_userfail` int NOT NULL DEFAULT 0,
  `SMPP_to_SMSC_smfail` int NOT NULL DEFAULT 0,
  `SMPP_to_SMSC_byte` int NOT NULL DEFAULT 0,
  `SMSC_to_SMPP_attempt` int NOT NULL DEFAULT 0,
  `SMSC_to_SMPP_success` int NOT NULL DEFAULT 0,
  `SMSC_to_SMPP_sysfail` int NOT NULL DEFAULT 0,
  `SMSC_to_SMPP_userfail` int NOT NULL DEFAULT 0,
  `SMSC_to_SMPP_smfail` int NOT NULL DEFAULT 0,
  `SMSC_to_SMPP_byte` int NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_type`, `smppId`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for spgwDetail
-- ----------------------------
DROP TABLE IF EXISTS `spgwDetail`;
CREATE TABLE `spgwDetail`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `attempted_sess_est_num` int UNSIGNED NOT NULL DEFAULT 0,
  `succ_sess_est_num` int UNSIGNED NOT NULL DEFAULT 0,
  `attempted_ims_session_est_num` int UNSIGNED NOT NULL DEFAULT 0,
  `succ_ims_sess_est_num` int UNSIGNED NOT NULL DEFAULT 0,
  `attempted_delete_sess_num` int UNSIGNED NOT NULL DEFAULT 0,
  `succ_delete_sess_sucess_num` int NOT NULL DEFAULT 0,
  `attempted_create_bearer_num` int UNSIGNED NOT NULL DEFAULT 0,
  `succ_create_bearer_num` int UNSIGNED NOT NULL DEFAULT 0,
  `attempted_ggsn_create_pdp_num` int UNSIGNED NOT NULL DEFAULT 0,
  `succ_ggsn_create_pdp_num` int UNSIGNED NOT NULL DEFAULT 0,
  `attempted_ggsn_delete_pdp_num` int UNSIGNED NOT NULL DEFAULT 0,
  `succ_ggsn_delete_pdp_num` int UNSIGNED NOT NULL DEFAULT 0,
  `ps_pagin_num` int UNSIGNED NOT NULL DEFAULT 0,
  `fail_ps_paging_num` int UNSIGNED NOT NULL DEFAULT 0,
  `ims_paging_num` int NOT NULL DEFAULT 0,
  `fail_ims_paging_num` int NOT NULL DEFAULT 0,
  `uplink_total_volume` bigint UNSIGNED NOT NULL DEFAULT 0,
  `downlink_total_volume` bigint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for spgwDetailData
-- ----------------------------
DROP TABLE IF EXISTS `spgwDetailData`;
CREATE TABLE `spgwDetailData`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `attempted_sess_est_num` int UNSIGNED NOT NULL DEFAULT 0,
  `succ_sess_est_num` int UNSIGNED NOT NULL DEFAULT 0,
  `attempted_ims_session_est_num` int UNSIGNED NOT NULL DEFAULT 0,
  `succ_ims_sess_est_num` int UNSIGNED NOT NULL DEFAULT 0,
  `attempted_delete_sess_num` int UNSIGNED NOT NULL DEFAULT 0,
  `succ_delete_sess_sucess_num` int NOT NULL DEFAULT 0,
  `attempted_create_bearer_num` int UNSIGNED NOT NULL DEFAULT 0,
  `succ_create_bearer_num` int UNSIGNED NOT NULL DEFAULT 0,
  `attempted_ggsn_create_pdp_num` int UNSIGNED NOT NULL DEFAULT 0,
  `succ_ggsn_create_pdp_num` int UNSIGNED NOT NULL DEFAULT 0,
  `attempted_ggsn_delete_pdp_num` int UNSIGNED NOT NULL DEFAULT 0,
  `succ_ggsn_delete_pdp_num` int UNSIGNED NOT NULL DEFAULT 0,
  `ps_pagin_num` int UNSIGNED NOT NULL DEFAULT 0,
  `fail_ps_paging_num` int UNSIGNED NOT NULL DEFAULT 0,
  `ims_paging_num` int NOT NULL DEFAULT 0,
  `fail_ims_paging_num` int NOT NULL DEFAULT 0,
  `uplink_total_volume` bigint UNSIGNED NOT NULL DEFAULT 0,
  `downlink_total_volume` bigint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for spgwSum
-- ----------------------------
DROP TABLE IF EXISTS `spgwSum`;
CREATE TABLE `spgwSum`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `attemp_sess_est_num` int UNSIGNED NOT NULL DEFAULT 0,
  `suc_sess_est_num` int UNSIGNED NOT NULL DEFAULT 0,
  `actived_user_num` int UNSIGNED NOT NULL DEFAULT 0,
  `max_actived_user_num` int UNSIGNED NOT NULL DEFAULT 0,
  `cur_ps_active_user_num` int UNSIGNED NOT NULL DEFAULT 0,
  `max_cur_ps_active_user_num` int NOT NULL DEFAULT 0,
  `cur_ims_active_user_num` int UNSIGNED NOT NULL DEFAULT 0,
  `max_cur_ims_active_user_num` int UNSIGNED NOT NULL DEFAULT 0,
  `ps_ip_addr_allocated` int UNSIGNED NOT NULL DEFAULT 0,
  `ps_ip_addr_free` int UNSIGNED NOT NULL DEFAULT 0,
  `ims_ip_addr_allocated` int UNSIGNED NOT NULL DEFAULT 0,
  `ims_ip_addr_free` int UNSIGNED NOT NULL DEFAULT 0,
  `ps_pagin_num` int UNSIGNED NOT NULL DEFAULT 0,
  `fail_ps_paging_num` int UNSIGNED NOT NULL DEFAULT 0,
  `ims_paging_num` int NOT NULL DEFAULT 0,
  `fail_ims_paging_num` int NOT NULL DEFAULT 0,
  `ps_ccr_update_num` int UNSIGNED NOT NULL DEFAULT 0,
  `ps_ccr_update_time_interval` int UNSIGNED NOT NULL DEFAULT 0,
  `uplink_average_pack_num` bigint UNSIGNED NOT NULL DEFAULT 0,
  `downlink_average_pack_num` bigint UNSIGNED NOT NULL DEFAULT 0,
  `uplink_average_pack_size` bigint UNSIGNED NOT NULL DEFAULT 0,
  `downlink_average_pack_size` bigint UNSIGNED NOT NULL DEFAULT 0,
  `uplink_data_bit_rate` bigint UNSIGNED NOT NULL DEFAULT 0,
  `uplink_data_max_bit_rate` bigint UNSIGNED NOT NULL DEFAULT 0,
  `downlink_data_bit_rate` bigint UNSIGNED NOT NULL DEFAULT 0,
  `downlink_data_max_bit_rate` bigint UNSIGNED NOT NULL DEFAULT 0,
  `gtp_context_num` int UNSIGNED NOT NULL DEFAULT 0,
  `gtp_active_tunnrl_num` int UNSIGNED NOT NULL DEFAULT 0,
  `total_up_pktnum` bigint UNSIGNED NOT NULL DEFAULT 0,
  `total_down_pktnum` bigint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for tcapDetail
-- ----------------------------
DROP TABLE IF EXISTS `tcapDetail`;
CREATE TABLE `tcapDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_id` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `tn_tcmes_sent_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tn_tcmes_rece_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tn_comp_sent_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tn_comp_rece_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_trans_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mean_num_ids_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_trans_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `max_num_ids_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_ids_thre_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unre_mes_type_21` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `incorrect_tp_21` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `bad_form_tp_21` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unre_tid_21` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resource_limit_21` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urc_gp_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mc_gp_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `bsc_gp_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urli_ip_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urli_rr_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rrue_rr_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urid_re_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reue_re_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dii_ip_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `uro_ip_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mp_ip_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ir_ip_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lrue_ip_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `uelo_ip_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ure_re_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `uee_re_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mp_rr_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mp_re_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unre_mes_type_24` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `incorrect_tp_24` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `bad_form_tp_24` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unre_tid_24` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resource_limit_24` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urc_gp_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mc_gp_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `bsc_gp_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urli_ip_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urii_re_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rrue_rr_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urii_rr_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reue_re_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dii_ip_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `uro_ip_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mp_ip_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ir_ip_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lrue_ip_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `uelo_ip_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ure_re_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `uee_re_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mp_rr_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mp_re_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_tclc_oper_7` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_mes_discarded_8` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_pa_received_10` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_reject_received_11` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_error_detected_12` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for tcapDetailData
-- ----------------------------
DROP TABLE IF EXISTS `tcapDetailData`;
CREATE TABLE `tcapDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_e1_id` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `tn_tcmes_sent_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tn_tcmes_rece_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tn_comp_sent_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `tn_comp_rece_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_trans_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mean_num_ids_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dur_trans_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `max_num_ids_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_ids_thre_1` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unre_mes_type_21` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `incorrect_tp_21` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `bad_form_tp_21` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unre_tid_21` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resource_limit_21` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urc_gp_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mc_gp_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `bsc_gp_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urli_ip_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urli_rr_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rrue_rr_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urid_re_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reue_re_22` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dii_ip_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `uro_ip_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mp_ip_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ir_ip_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lrue_ip_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `uelo_ip_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ure_re_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `uee_re_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mp_rr_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mp_re_23` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unre_mes_type_24` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `incorrect_tp_24` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `bad_form_tp_24` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `unre_tid_24` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `resource_limit_24` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urc_gp_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mc_gp_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `bsc_gp_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urli_ip_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urii_re_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `rrue_rr_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `urii_rr_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `reue_re_25` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `dii_ip_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `uro_ip_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mp_ip_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ir_ip_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `lrue_ip_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `uelo_ip_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `ure_re_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `uee_re_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mp_rr_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `mp_re_26` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_tclc_oper_7` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_mes_discarded_8` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_pa_received_10` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_reject_received_11` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `num_error_detected_12` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for tmgDetail
-- ----------------------------
DROP TABLE IF EXISTS `tmgDetail`;
CREATE TABLE `tmgDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `rtp_pkg_miss` int UNSIGNED NOT NULL DEFAULT 0,
  `rtp_pkg_recv` int UNSIGNED NOT NULL DEFAULT 0,
  `rtp_pkg_sent` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for tmgDetailData
-- ----------------------------
DROP TABLE IF EXISTS `tmgDetailData`;
CREATE TABLE `tmgDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_subsys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `rtp_pkg_miss` int UNSIGNED NOT NULL DEFAULT 0,
  `rtp_pkg_recv` int UNSIGNED NOT NULL DEFAULT 0,
  `rtp_pkg_sent` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_subsys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for udmDetail
-- ----------------------------
DROP TABLE IF EXISTS `udmDetail`;
CREATE TABLE `udmDetail`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `n5gAKAAuthenAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `n5gAkAAuthenSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `nEAPAKAAuthenAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `nEAPAKAAuthenSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMF3gppAccessRegiAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMF3gppAccessRegiSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMFNon3gppAccRegiAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMFNon3gppAccessRegiSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `nSMFRegiAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMFRegiSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for udmDetailData
-- ----------------------------
DROP TABLE IF EXISTS `udmDetailData`;
CREATE TABLE `udmDetailData`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `n5gAKAAuthenAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `n5gAkAAuthenSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `nEAPAKAAuthenAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `nEAPAKAAuthenSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMF3gppAccessRegiAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMF3gppAccessRegiSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMFNon3gppAccRegiAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMFNon3gppAccessRegiSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `nSMFRegiAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMFRegiSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for udmSum
-- ----------------------------
DROP TABLE IF EXISTS `udmSum`;
CREATE TABLE `udmSum`  (
  `key_sys_id` tinyint(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00,
  `n5gAKAAuthenAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `n5gAkAAuthenSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `nEAPAKAAuthenAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `nEAPAKAAuthenSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMF3gppAccessRegiAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMF3gppAccessRegiSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMFNon3gppAccRegiAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMFNon3gppAccessRegiSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `nSMFRegiAttempt` int UNSIGNED NOT NULL DEFAULT 0,
  `nAMFRegiSuc` int UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for vlrDetail
-- ----------------------------
DROP TABLE IF EXISTS `vlrDetail`;
CREATE TABLE `vlrDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `amma` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `smma` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `airp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sirp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `apr` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `spr` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `aprpla` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sprpla` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `arassv` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srashv` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `errash` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `aapv` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sapv` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `aavlu` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `savlu` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `arvlu` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srvlu` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `avop` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `soprv` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `nrv` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for vlrDetailData
-- ----------------------------
DROP TABLE IF EXISTS `vlrDetailData`;
CREATE TABLE `vlrDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `amma` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `smma` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `airp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sirp` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `apr` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `spr` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `aprpla` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sprpla` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `arassv` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srashv` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `errash` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `aapv` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `sapv` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `aavlu` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `savlu` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `arvlu` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `srvlu` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `avop` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `soprv` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `nrv` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for vssDetail
-- ----------------------------
DROP TABLE IF EXISTS `vssDetail`;
CREATE TABLE `vssDetail`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `att_org_call` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suc_org_call` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `att_term_call` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suc_term_call` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `att_lev_msg` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suc_lev_msg` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `att_mnt_msg` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suc_mnt_msg` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `acc_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for vssDetailData
-- ----------------------------
DROP TABLE IF EXISTS `vssDetailData`;
CREATE TABLE `vssDetailData`  (
  `key_sys_id` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `key_type` tinyint UNSIGNED NOT NULL DEFAULT 0,
  `att_org_call` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suc_org_call` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `att_term_call` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suc_term_call` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `att_lev_msg` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suc_lev_msg` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `att_mnt_msg` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `suc_mnt_msg` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `acc_fail` mediumint UNSIGNED NOT NULL DEFAULT 0,
  `csta_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_sys_id`, `key_type`, `csta_datetime`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

SET FOREIGN_KEY_CHECKS = 1;
