EMS/build.ems
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
main
build.ems/extra/sql/install/CSTA_DB.sql
AGT EMS 3172312af0 feat: new upgrade db method
2025-06-18 10:17:43 +08:00

5319 lines
257 KiB
SQL
Raw Permalink Blame History

/*
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;
Reference in New Issue View Git Blame Copy Permalink