/* 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 : UDM_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:05 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for subscriberData -- ---------------------------- DROP TABLE IF EXISTS `subscriberData`; CREATE TABLE `subscriberData` ( `supi` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `gpsis` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `internal_group_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_ue_ambr_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_snssais_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ue_usage_type` int NOT NULL, `rat_restriction` int NOT NULL, `forbidden_areas_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `service_area_restriction_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `core_network_type_restriction` int NOT NULL, `rfsp_index` int NOT NULL, `periodic_registration_timer` int NOT NULL, `mps_priority` int NOT NULL, `mcs_priority` int NOT NULL, `odb_packet_services` int NOT NULL, `mico_mode` int NOT NULL, `active_time` int NOT NULL, `download_packet_count` int NOT NULL, `subscribed_slice_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_smf_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_data` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `purge_flag` int NOT NULL, `pei` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ims_vops` int NOT NULL, `guami` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `pdu_session_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `single_nssais_str` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `dnns` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`supi`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for subscriberData_0 -- ---------------------------- DROP TABLE IF EXISTS `subscriberData_0`; CREATE TABLE `subscriberData_0` ( `supi` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `gpsis` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `internal_group_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_ue_ambr_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_snssais_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ue_usage_type` int NOT NULL, `rat_restriction` int NOT NULL, `forbidden_areas_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `service_area_restriction_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `core_network_type_restriction` int NOT NULL, `rfsp_index` int NOT NULL, `periodic_registration_timer` int NOT NULL, `mps_priority` int NOT NULL, `mcs_priority` int NOT NULL, `odb_packet_services` int NOT NULL, `mico_mode` int NOT NULL, `active_time` int NOT NULL, `download_packet_count` int NOT NULL, `subscribed_slice_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_smf_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_data` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `purge_flag` int NOT NULL, `pei` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ims_vops` int NOT NULL, `guami` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `pdu_session_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `single_nssais_str` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `dnns` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`supi`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for subscriberData_1 -- ---------------------------- DROP TABLE IF EXISTS `subscriberData_1`; CREATE TABLE `subscriberData_1` ( `supi` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `gpsis` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `internal_group_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_ue_ambr_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_snssais_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ue_usage_type` int NOT NULL, `rat_restriction` int NOT NULL, `forbidden_areas_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `service_area_restriction_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `core_network_type_restriction` int NOT NULL, `rfsp_index` int NOT NULL, `periodic_registration_timer` int NOT NULL, `mps_priority` int NOT NULL, `mcs_priority` int NOT NULL, `odb_packet_services` int NOT NULL, `mico_mode` int NOT NULL, `active_time` int NOT NULL, `download_packet_count` int NOT NULL, `subscribed_slice_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_smf_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_data` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `purge_flag` int NOT NULL, `pei` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ims_vops` int NOT NULL, `guami` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `pdu_session_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `single_nssais_str` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `dnns` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`supi`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for subscriberData_10 -- ---------------------------- DROP TABLE IF EXISTS `subscriberData_10`; CREATE TABLE `subscriberData_10` ( `supi` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `gpsis` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `internal_group_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_ue_ambr_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_snssais_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ue_usage_type` int NOT NULL, `rat_restriction` int NOT NULL, `forbidden_areas_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `service_area_restriction_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `core_network_type_restriction` int NOT NULL, `rfsp_index` int NOT NULL, `periodic_registration_timer` int NOT NULL, `mps_priority` int NOT NULL, `mcs_priority` int NOT NULL, `odb_packet_services` int NOT NULL, `mico_mode` int NOT NULL, `active_time` int NOT NULL, `download_packet_count` int NOT NULL, `subscribed_slice_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_smf_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_data` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `purge_flag` int NOT NULL, `pei` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ims_vops` int NOT NULL, `guami` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `pdu_session_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `single_nssais_str` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `dnns` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`supi`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for subscriberData_11 -- ---------------------------- DROP TABLE IF EXISTS `subscriberData_11`; CREATE TABLE `subscriberData_11` ( `supi` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `gpsis` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `internal_group_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_ue_ambr_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_snssais_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ue_usage_type` int NOT NULL, `rat_restriction` int NOT NULL, `forbidden_areas_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `service_area_restriction_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `core_network_type_restriction` int NOT NULL, `rfsp_index` int NOT NULL, `periodic_registration_timer` int NOT NULL, `mps_priority` int NOT NULL, `mcs_priority` int NOT NULL, `odb_packet_services` int NOT NULL, `mico_mode` int NOT NULL, `active_time` int NOT NULL, `download_packet_count` int NOT NULL, `subscribed_slice_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_smf_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_data` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `purge_flag` int NOT NULL, `pei` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ims_vops` int NOT NULL, `guami` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `pdu_session_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `single_nssais_str` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `dnns` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`supi`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for subscriberData_2 -- ---------------------------- DROP TABLE IF EXISTS `subscriberData_2`; CREATE TABLE `subscriberData_2` ( `supi` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `gpsis` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `internal_group_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_ue_ambr_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_snssais_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ue_usage_type` int NOT NULL, `rat_restriction` int NOT NULL, `forbidden_areas_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `service_area_restriction_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `core_network_type_restriction` int NOT NULL, `rfsp_index` int NOT NULL, `periodic_registration_timer` int NOT NULL, `mps_priority` int NOT NULL, `mcs_priority` int NOT NULL, `odb_packet_services` int NOT NULL, `mico_mode` int NOT NULL, `active_time` int NOT NULL, `download_packet_count` int NOT NULL, `subscribed_slice_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_smf_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_data` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `purge_flag` int NOT NULL, `pei` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ims_vops` int NOT NULL, `guami` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `pdu_session_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `single_nssais_str` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `dnns` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`supi`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for subscriberData_3 -- ---------------------------- DROP TABLE IF EXISTS `subscriberData_3`; CREATE TABLE `subscriberData_3` ( `supi` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `gpsis` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `internal_group_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_ue_ambr_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_snssais_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ue_usage_type` int NOT NULL, `rat_restriction` int NOT NULL, `forbidden_areas_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `service_area_restriction_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `core_network_type_restriction` int NOT NULL, `rfsp_index` int NOT NULL, `periodic_registration_timer` int NOT NULL, `mps_priority` int NOT NULL, `mcs_priority` int NOT NULL, `odb_packet_services` int NOT NULL, `mico_mode` int NOT NULL, `active_time` int NOT NULL, `download_packet_count` int NOT NULL, `subscribed_slice_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_smf_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_data` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `purge_flag` int NOT NULL, `pei` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ims_vops` int NOT NULL, `guami` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `pdu_session_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `single_nssais_str` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `dnns` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`supi`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for subscriberData_4 -- ---------------------------- DROP TABLE IF EXISTS `subscriberData_4`; CREATE TABLE `subscriberData_4` ( `supi` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `gpsis` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `internal_group_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_ue_ambr_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_snssais_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ue_usage_type` int NOT NULL, `rat_restriction` int NOT NULL, `forbidden_areas_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `service_area_restriction_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `core_network_type_restriction` int NOT NULL, `rfsp_index` int NOT NULL, `periodic_registration_timer` int NOT NULL, `mps_priority` int NOT NULL, `mcs_priority` int NOT NULL, `odb_packet_services` int NOT NULL, `mico_mode` int NOT NULL, `active_time` int NOT NULL, `download_packet_count` int NOT NULL, `subscribed_slice_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_smf_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_data` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `purge_flag` int NOT NULL, `pei` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ims_vops` int NOT NULL, `guami` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `pdu_session_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `single_nssais_str` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `dnns` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`supi`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for subscriberData_5 -- ---------------------------- DROP TABLE IF EXISTS `subscriberData_5`; CREATE TABLE `subscriberData_5` ( `supi` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `gpsis` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `internal_group_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_ue_ambr_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_snssais_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ue_usage_type` int NOT NULL, `rat_restriction` int NOT NULL, `forbidden_areas_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `service_area_restriction_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `core_network_type_restriction` int NOT NULL, `rfsp_index` int NOT NULL, `periodic_registration_timer` int NOT NULL, `mps_priority` int NOT NULL, `mcs_priority` int NOT NULL, `odb_packet_services` int NOT NULL, `mico_mode` int NOT NULL, `active_time` int NOT NULL, `download_packet_count` int NOT NULL, `subscribed_slice_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_smf_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_data` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `purge_flag` int NOT NULL, `pei` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ims_vops` int NOT NULL, `guami` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `pdu_session_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `single_nssais_str` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `dnns` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`supi`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for subscriberData_6 -- ---------------------------- DROP TABLE IF EXISTS `subscriberData_6`; CREATE TABLE `subscriberData_6` ( `supi` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `gpsis` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `internal_group_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_ue_ambr_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_snssais_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ue_usage_type` int NOT NULL, `rat_restriction` int NOT NULL, `forbidden_areas_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `service_area_restriction_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `core_network_type_restriction` int NOT NULL, `rfsp_index` int NOT NULL, `periodic_registration_timer` int NOT NULL, `mps_priority` int NOT NULL, `mcs_priority` int NOT NULL, `odb_packet_services` int NOT NULL, `mico_mode` int NOT NULL, `active_time` int NOT NULL, `download_packet_count` int NOT NULL, `subscribed_slice_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_smf_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_data` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `purge_flag` int NOT NULL, `pei` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ims_vops` int NOT NULL, `guami` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `pdu_session_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `single_nssais_str` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `dnns` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`supi`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for subscriberData_7 -- ---------------------------- DROP TABLE IF EXISTS `subscriberData_7`; CREATE TABLE `subscriberData_7` ( `supi` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `gpsis` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `internal_group_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_ue_ambr_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_snssais_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ue_usage_type` int NOT NULL, `rat_restriction` int NOT NULL, `forbidden_areas_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `service_area_restriction_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `core_network_type_restriction` int NOT NULL, `rfsp_index` int NOT NULL, `periodic_registration_timer` int NOT NULL, `mps_priority` int NOT NULL, `mcs_priority` int NOT NULL, `odb_packet_services` int NOT NULL, `mico_mode` int NOT NULL, `active_time` int NOT NULL, `download_packet_count` int NOT NULL, `subscribed_slice_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_smf_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_data` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `purge_flag` int NOT NULL, `pei` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ims_vops` int NOT NULL, `guami` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `pdu_session_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `single_nssais_str` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `dnns` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`supi`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for subscriberData_8 -- ---------------------------- DROP TABLE IF EXISTS `subscriberData_8`; CREATE TABLE `subscriberData_8` ( `supi` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `gpsis` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `internal_group_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_ue_ambr_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_snssais_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ue_usage_type` int NOT NULL, `rat_restriction` int NOT NULL, `forbidden_areas_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `service_area_restriction_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `core_network_type_restriction` int NOT NULL, `rfsp_index` int NOT NULL, `periodic_registration_timer` int NOT NULL, `mps_priority` int NOT NULL, `mcs_priority` int NOT NULL, `odb_packet_services` int NOT NULL, `mico_mode` int NOT NULL, `active_time` int NOT NULL, `download_packet_count` int NOT NULL, `subscribed_slice_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_smf_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_data` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `purge_flag` int NOT NULL, `pei` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ims_vops` int NOT NULL, `guami` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `pdu_session_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `single_nssais_str` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `dnns` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`supi`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for subscriberData_9 -- ---------------------------- DROP TABLE IF EXISTS `subscriberData_9`; CREATE TABLE `subscriberData_9` ( `supi` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `gpsis` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `internal_group_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_ue_ambr_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_snssais_temp` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ue_usage_type` int NOT NULL, `rat_restriction` int NOT NULL, `forbidden_areas_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `service_area_restriction_templ` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `core_network_type_restriction` int NOT NULL, `rfsp_index` int NOT NULL, `periodic_registration_timer` int NOT NULL, `mps_priority` int NOT NULL, `mcs_priority` int NOT NULL, `odb_packet_services` int NOT NULL, `mico_mode` int NOT NULL, `active_time` int NOT NULL, `download_packet_count` int NOT NULL, `subscribed_slice_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_smf_selection_data_temp` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `subscribed_data` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `purge_flag` int NOT NULL, `pei` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `ims_vops` int NOT NULL, `guami` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `pdu_session_ids` varchar(32) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `single_nssais_str` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `dnns` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, PRIMARY KEY (`supi`) USING BTREE ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1;