SQLite format 3@ .zq 7 5internet0800 2025-11-20T09:17:16Z {{MM+53c6e0b8a9c15224a8228b9a98ca1531d762a2206fe0b4151ace403c86a11e479800000101000000000002025-11-20T09:17:16Z  + 001010000000000          z  S , g,Y tabletfttft CREATE TABLE tft ( tft_id INTEGER NOT NULL, tft_group_id INTEGER NOT NULL, tft_string VARCHAR(100) NOT NULL, direction INTEGER NOT NULL, last_modified VARCHAR(100), PRIMARY KEY (tft_id) )g '' tablecharging_rulecharging_rule CREATE TABLE charging_rule ( charging_rule_id INTEGER NOT NULL, rule_name VARCHAR(20), qci INTEGER, arp_priority INTEGER, arp_preemption_capability BOOLEAN, arp_preemption_vulnerability BOOLEAN, mbr_dl INTEGER NOT NULL, mbr_ul INTEGER NOT NULL, gbr_dl INTEGER NOT NULL, gbr_ul INTEGER NOT NULL, tft_group_id INTEGER, precedence INTEGER, rating_group INTEGER, last_modified VARCHAR(100), PRIMARY KEY (charging_rule_id) )155tableemergency_subscriberemergency_subscriber CREATE TABLE emergency_subscriber ( emergency_subscriber_id INTEGER NOT NULL, imsi VARCHAR(18), serving_pgw VARCHAR(512), serving_pgw_timestamp VARCHAR(512), serving_pcscf VARCHAR(512), serving_pcscf_timestamp VARCHAR(512), gx_origin_realm VARCHAR(512), gx_origin_host VARCHAR(512), rat_type VARCHAR(512), ip VARCHAR(512), access_network_gateway_address VARCHAR(512), access_network_charging_address VARCHAR(512), last_modified VARCHAR(100), PRIMARY KEY (emergency_subscriber_id) )++Atableroaming_networkroaming_networkCREATE TABLE roaming_network ( roaming_network_id INTEGER NOT NULL, name VARCHAR(512), preference INTEGER, mcc VARCHAR(100), mnc VARCHAR(100), last_modified VARCHAR(100), PRIMARY KEY (roaming_network_id) )`)){tableims_subscriberims_subscriberCREATE TABLE ims_subscriber ( ims_subscriber_id INTEGER NOT NULL, msisdn VARCHAR(18), msisdn_list VARCHAR(1200), imsi VARCHAR(18), ifc_path VARCHAR(512), pcscf VARCHAR(512), pcscf_realm VARCHAR(512), pcscf_active_session VARCHAR(512), pcscf_timestamp DATETIME, pcscf_peer VARCHAR(512), xcap_profile TEXT, sh_profile TEXT, scscf VARCHAR(512), scscf_timestamp DATETIME, scscf_realm VARCHAR(512), scscf_peer VARCHAR(512), sh_template_path VARCHAR(512), last_modified VARCHAR(100), PRIMARY KEY (ims_subscriber_id), UNIQUE (msisdn) );O)indexsqlite_autoindex_ims_subscriber_1ims_subscriberqtableaucaucCREATE TABLE auc ( auc_id INTEGER NOT NULL, ki VARCHAR(32) NOT NULL, opc VARCHAR(32) NOT NULL, amf VARCHAR(4) NOT NULL, sqn BIGINT, iccid VARCHAR(20), imsi VARCHAR(18), batch_name VARCHAR(20), sim_vendor VARCHAR(20), esim BOOLEAN, lpa VARCHAR(128), pin1 VARCHAR(20), pin2 VARCHAR(20), puk1 VARCHAR(20), puk2 VARCHAR(20), kid VARCHAR(20), psk VARCHAR(128), des VARCHAR(128), adm1 VARCHAR(20), algo VARCHAR(20), misc1 VARCHAR(128), misc2 VARCHAR(128), misc3 VARCHAR(128), misc4 VARCHAR(128), last_modified VARCHAR(100), PRIMARY KEY (auc_id), UNIQUE (iccid), UNIQUE (imsi) )%9indexsqlite_autoindex_auc_2auc%9indexsqlite_autoindex_auc_1auc{]tableapnapnCREATE TABLE apn ( apn_id INTEGER NOT NULL, apn VARCHAR(50) NOT NULL, ip_version INTEGER, pgw_address VARCHAR(50), sgw_address VARCHAR(50), charging_characteristics VARCHAR(4), apn_ambr_dl INTEGER NOT NULL, apn_ambr_ul INTEGER NOT NULL, qci INTEGER, arp_priority INTEGER, arp_preemption_capability BOOLEAN, arp_preemption_vulnerability BOOLEAN, charging_rule_list VARCHAR(18), nbiot BOOLEAN, nidd_scef_id VARCHAR(512), nidd_scef_realm VARCHAR(512), nidd_mechanism INTEGER, nidd_rds INTEGER, nidd_preferred_data_mode INTEGER, last_modified VARCHAR(100), PRIMARY KEY (apn_id) )  0 > QV11Wtablesubscriber_routingsubscriber_routingCREATE TABLE subscriber_routing ( subscriber_routing_id INTEGER NOT NULL, subscriber_id INTEGER, apn_id INTEGER, ip_version INTEGER, ip_address VARCHAR(254), last_modified VARCHAR(100), PRIMARY KEY (subscriber_routing_id), UNIQUE (subscriber_id, apn_id), FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id) ON DELETE CASCADE, FOREIGN KEY(apn_id) REFERENCES apn (apn_id) ON DELETE CASCADE )CW1indexsqlite_autoindex_subscriber_routing_1subscriber_routingJ%%Wtableroaming_ruleroaming_ruleCREATE TABLE roaming_rule ( roaming_rule_id INTEGER NOT NULL, roaming_network_id INTEGER, allow BOOLEAN, enabled BOOLEAN, last_modified VARCHAR(100), PRIMARY KEY (roaming_rule_id), FOREIGN KEY(roaming_network_id) REFERENCES roaming_network (roaming_network_id) ON DELETE CASCADE )`!! tablesubscribersubscriberCREATE TABLE subscriber ( subscriber_id INTEGER NOT NULL, imsi VARCHAR(18), enabled BOOLEAN, auc_id INTEGER NOT NULL, default_apn INTEGER NOT NULL, apn_list VARCHAR(64) NOT NULL, msisdn VARCHAR(18), ue_ambr_dl INTEGER, ue_ambr_ul INTEGER, nam INTEGER, roaming_enabled BOOLEAN, roaming_rule_list VARCHAR(512), subscribed_rau_tau_timer INTEGER, serving_mme VARCHAR(512), serving_mme_timestamp DATETIME, serving_mme_realm VARCHAR(512), serving_mme_peer VARCHAR(512), serving_msc VARCHAR(512), serving_msc_timestamp DATETIME, serving_vlr VARCHAR(512), serving_vlr_timestamp DATETIME, serving_sgsn VARCHAR(512), serving_sgsn_timestamp DATETIME, last_seen_eci VARCHAR(64), last_seen_enodeb_id VARCHAR(64), last_seen_cell_id VARCHAR(64), last_seen_tac VARCHAR(64), last_seen_mcc VARCHAR(3), last_seen_mnc VARCHAR(3), last_location_update_timestamp DATETIME, last_modified VARCHAR(100), PRIMARY KEY (subscriber_id), UNIQUE (imsi), FOREIGN KEY(auc_id) REFERENCES auc (auc_id), FOREIGN KEY(default_apn) REFERENCES apn (apn_id) )3G!indexsqlite_autoindex_subscriber_1subscriber 5 I#indexsqlite_autoindex_eir_history_1eir_history ##wtableeir_historyeir_history CREATE TABLE eir_history ( imsi_imei_history_id INTEGER NOT NULL, imsi_imei VARCHAR(60), match_response_code INTEGER, imsi_imei_timestamp DATETIME, last_modified VARCHAR(100), PRIMARY KEY (imsi_imei_history_id), UNIQUE (imsi_imei) )S  tableeireir CREATE TABLE eir ( eir_id INTEGER NOT NULL, imei VARCHAR(60), imsi VARCHAR(60), regex_mode INTEGER, match_response_code INTEGER, last_modified VARCHAR(100), PRIMARY KEY (eir_id) )4##/tableserving_apnserving_apnCREATE TABLE serving_apn ( serving_apn_id INTEGER NOT NULL, subscriber_id INTEGER, apn INTEGER, pcrf_session_id VARCHAR(100), subscriber_routing VARCHAR(100), ip_version INTEGER, serving_pgw VARCHAR(512), serving_pgw_timestamp DATETIME, serving_pgw_realm VARCHAR(512), serving_pgw_peer VARCHAR(512), last_modified VARCHAR(100), PRIMARY KEY (serving_apn_id), FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id) ON DELETE CASCADE, FOREIGN KEY(apn) REFERENCES apn (apn_id) ON DELETE CASCADE ) ]]  +  +A#75001010000000000internet1100B?B?,mme.localdomain2025-11-20 09:17:19.425301localdomainmme.localdomain;hss012025-11-20T09:17:16Z + 001010000000000      ''etableoperation_logoperation_logCREATE TABLE operation_log ( id INTEGER NOT NULL, item_id INTEGER NOT NULL, operation_id VARCHAR(36) NOT NULL, operation VARCHAR(10), changes TEXT, last_modified VARCHAR(100), timestamp DATETIME, table_name VARCHAR(255), apn_id INTEGER, subscriber_routing_id INTEGER, serving_apn_id INTEGER, auc_id INTEGER, subscriber_id INTEGER, ims_subscriber_id INTEGER, roaming_rule_id INTEGER, roaming_network_id INTEGER, emergency_subscriber_id INTEGER, charging_rule_id INTEGER, tft_id INTEGER, eir_id INTEGER, imsi_imei_history_id INTEGER, subscriber_attributes_id INTEGER, PRIMARY KEY (id), FOREIGN KEY(apn_id) REFERENCES apn (apn_id), FOREIGN KEY(subscriber_routing_id) REFERENCES subscriber_routing (subscriber_routing_id), FOREIGN KEY(serving_apn_id) REFERENCES serving_apn (serving_apn_id), FOREIGN KEY(auc_id) REFERENCES auc (auc_id), FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id), FOREIGN KEY(ims_subscriber_id) REFERENCES ims_subscriber (ims_subscriber_id), FOREIGN KEY(roaming_rule_id) REFERENCES roaming_rule (roaming_rule_id), FOREIGN KEY(roaming_network_id) REFERENCES roaming_network (roaming_network_id), FOREIGN KEY(emergency_subscriber_id) REFERENCES emergency_subscriber (emergency_subscriber_id), FOREIGN KEY(charging_rule_id) REFERENCES charging_rule (charging_rule_id), FOREIGN KEY(tft_id) REFERENCES tft (tft_id), FOREIGN KEY(eir_id) REFERENCES eir (eir_id), FOREIGN KEY(imsi_imei_history_id) REFERENCES eir_history (imsi_imei_history_id), FOREIGN KEY(subscriber_attributes_id) REFERENCES subscriber_attributes (subscriber_attributes_id) )u77 tablesubscriber_attributessubscriber_attributesCREATE TABLE subscriber_attributes ( subscriber_attributes_id INTEGER NOT NULL, subscriber_id INTEGER NOT NULL, "key" VARCHAR(60), last_modified VARCHAR(100), value VARCHAR(12000), PRIMARY KEY (subscriber_attributes_id), FOREIGN KEY(subscriber_id) REFERENCES subscriber (subscriber_id) ON DELETE CASCADE ) - h-8 U M3c5e260bb-eb57-4bd1-bf16-626b5381a13bINSERTauc_id: [NoneType] None ----> [str] 1 ki: [NoneType] None ----> [str] 3c6e0b8a9c15224a8228b9a98ca1531d opc: [NoneType] None ----> [str] 762a2206fe0b4151ace403c86a11e479 amf: [NoneType] None ----> [str] 8000 sqn: [NoneType] None ----> [str] 0 iccid: [NoneType] None ----> [NoneType] None imsi: [NoneType] None ----> [str] 001010000000000 batch_name: [NoneType] None ----> [NoneType] None sim_vendor: [NoneType] None ----> [NoneType] None esim: [NoneType] None ----> [int] 0 lpa: [NoneType] None ----> [NoneType] None pin1: [NoneType] None ----> [NoneType] None pin2: [NoneType] None ----> [NoneType] None puk1: [NoneType] None ----> [NoneType] None puk2: [NoneType] None ----> [NoneType] None kid: [NoneType] None ----> [NoneType] None psk: [NoneType] None ----> [NoneType] None des: [NoneType] None ----> [NoneType] None adm1: [NoneType] None ----> [NoneType] None algo: [NoneType] None ----> [str] 0 misc1: [NoneType] None ----> [NoneType] None misc2: [NoneType] None ----> [NoneType] None misc3: [NoneType] None ----> [NoneType] None misc4: [NoneType] None ----> [NoneType] None last_modified: [NoneType] None ----> [str] 2025-11-20T09:17:16Z2025-11-20 09:17:16.176417+00:002025-11-20 09:17:16auc UGM38a1864a9-d2d1-4efd-aba9-1266c9044a8eINSERTapn_id: [NoneType] None ----> [int] 1 apn: [NoneType] None ----> [str] internet ip_version: [NoneType] None ----> [int] 0 pgw_address: [NoneType] None ----> [NoneType] None sgw_address: [NoneType] None ----> [NoneType] None charging_characteristics: [NoneType] None ----> [str] 0800 apn_ambr_dl: [NoneType] None ----> [int] 0 apn_ambr_ul: [NoneType] None ----> [int] 0 qci: [NoneType] None ----> [int] 9 arp_priority: [NoneType] None ----> [int] 4 arp_preemption_capability: [NoneType] None ----> [int] 0 arp_preemption_vulnerability: [NoneType] None ----> [int] 1 charging_rule_list: [NoneType] None ----> [NoneType] None nbiot: [NoneType] None ----> [int] 0 nidd_scef_id: [NoneType] None ----> [NoneType] None nidd_scef_realm: [NoneType] None ----> [NoneType] None nidd_mechanism: [NoneType] None ----> [NoneType] None nidd_rds: [NoneType] None ----> [NoneType] None nidd_preferred_data_mode: [NoneType] None ----> [NoneType] None last_modified: [NoneType] None ----> [str] 2025-11-20T09:17:16Z2025-11-20 09:17:16.066019+00:002025-11-20 09:17:16apn * UcM3!900c562b-5a28-4af1-96cf-343fefdd2c90INSERTsubscriber_id: [NoneType] None ----> [int] 1 imsi: [NoneType] None ----> [str] 001010000000000 enabled: [NoneType] None ----> [int] 1 auc_id: [NoneType] None ----> [str] 1 default_apn: [NoneType] None ----> [str] internet apn_list: [NoneType] None ----> [str] 1 msisdn: [NoneType] None ----> [str] 100 ue_ambr_dl: [NoneType] None ----> [int] 999999 ue_ambr_ul: [NoneType] None ----> [int] 999999 nam: [NoneType] None ----> [int] 0 roaming_enabled: [NoneType] None ----> [int] 1 roaming_rule_list: [NoneType] None ----> [NoneType] None subscribed_rau_tau_timer: [NoneType] None ----> [int] 300 serving_mme: [NoneType] None ----> [NoneType] None serving_mme_timestamp: [NoneType] None ----> [NoneType] None serving_mme_realm: [NoneType] None ----> [NoneType] None serving_mme_peer: [NoneType] None ----> [NoneType] None serving_msc: [NoneType] None ----> [NoneType] None serving_msc_timestamp: [NoneType] None ----> [NoneType] None serving_vlr: [NoneType] None ----> [NoneType] None serving_vlr_timestamp: [NoneType] None ----> [NoneType] None serving_sgsn: [NoneType] None ----> [NoneType] None serving_sgsn_timestamp: [NoneType] None ----> [NoneType] None last_seen_eci: [NoneType] None ----> [NoneType] None last_seen_enodeb_id: [NoneType] None ----> [NoneType] None last_seen_cell_id: [NoneType] None ----> [NoneType] None last_seen_tac: [NoneType] None ----> [NoneType] None last_seen_mcc: [NoneType] None ----> [NoneType] None last_seen_mnc: [NoneType] None ----> [NoneType] None last_location_update_timestamp: [NoneType] None ----> [NoneType] None last_modified: [NoneType] None ----> [str] 2025-11-20T09:17:16Z2025-11-20 09:17:16.195306+00:002025-11-20 09:17:16subscriber