/* 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;