95 lines
6.0 KiB
SQL
95 lines
6.0 KiB
SQL
/*
|
|
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 : VLR_DB
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 100621 (10.6.21-MariaDB-0ubuntu0.22.04.2)
|
|
File Encoding : 65001
|
|
|
|
Date: 17/06/2025 17:01:15
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for subscriberData
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `subscriberData`;
|
|
CREATE TABLE `subscriberData` (
|
|
`IMSI` char(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
|
|
`msisdn_len` tinyint UNSIGNED NOT NULL DEFAULT 0,
|
|
`MSISDN` char(18) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`MS_Category` char(2) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
|
|
`Sub_status` char(2) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
|
|
`ODB_General` char(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
|
|
`ODB_Specific` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
|
|
`Provision_bs` char(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
|
|
`Provision_ts` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
|
|
`msrn_len` tinyint UNSIGNED NOT NULL DEFAULT 0,
|
|
`MSRN` char(18) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`TMSI` char(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`LMSI` char(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`AuthSetsNum` tinyint UNSIGNED NOT NULL DEFAULT 0,
|
|
`AuthSetsIndex` tinyint UNSIGNED NOT NULL DEFAULT 0,
|
|
`auth_sets1` char(56) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`auth_sets2` char(56) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`auth_sets3` char(56) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`auth_sets4` char(56) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`auth_sets5` char(56) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`CKSN` tinyint UNSIGNED NOT NULL DEFAULT 0,
|
|
`LAI` char(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`MSC_Number` char(18) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`HLR_Number` char(18) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`Cell_ID` char(5) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
|
|
`Handover_Number` char(18) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`CFU_ST` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`CFB_ST` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`CFNRy_ST` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`CFNRc_ST` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`CFU_Num` char(18) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`CFB_Num` char(18) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`CFNRy_Num` char(18) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`CFNRc_Num` char(18) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`AllBar` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`BAOC` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`BOIC` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`BOICexHC` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`BAIC` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`BICRoam` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`barring_info7` char(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`barring_info8` char(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`CLIP` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`CLIR` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`COLP` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`COLR` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`AOCI` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`AOCC` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`CallHold` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`CallWait` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`ECT` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`MPTY` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`LANotAllowedFlag` tinyint UNSIGNED NOT NULL DEFAULT 0,
|
|
`RoamRestricFlag` tinyint UNSIGNED NOT NULL DEFAULT 0,
|
|
`IMSIDetachFlag` tinyint UNSIGNED NOT NULL DEFAULT 0,
|
|
`RadioConfirmFlag` tinyint UNSIGNED NOT NULL DEFAULT 0,
|
|
`DataConfirmFlag` tinyint UNSIGNED NOT NULL DEFAULT 0,
|
|
`LocationConfirm` tinyint UNSIGNED NOT NULL DEFAULT 0,
|
|
`MNRF` tinyint UNSIGNED NOT NULL DEFAULT 0,
|
|
`purgeTick` int UNSIGNED NOT NULL DEFAULT 0,
|
|
`msc_thread` smallint UNSIGNED NOT NULL DEFAULT 0,
|
|
`O_CSI` char(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`SMS_CSI` char(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`SS_CSI` char(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`MSISDN_opt` char(18) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
|
|
`ra_type` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '0',
|
|
PRIMARY KEY (`IMSI`) USING BTREE
|
|
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|