基站接入5GCN"/>
基于Docker的UERANSIM多基站接入5GCN
目录
1. 核心网配置
2. UERANSIM配置
2.1 UERANSIM镜像拉取
2.2 UERANSIM docker-compose文件配置
ueransim1配置
ueransim2配置
ueransim3配置
gNB参数
UE参数
3. UERANSIM运行
3.1 容器启动
3.2 容器健康状态查询
3.3 ueransim接入日志查询
3.4 AMF日志查询
3.5 用户信息查询
4. 数据流测试
5. 基站及核心网的取消部署
5.1 基站取消部署
5.2 核心网的取消部署
附录
核心网docker-compose-basic-vpp-nrf.yaml文件
核心网数据库oai_db2.sql文件
1. 核心网配置
UERANSIM目前不支持集成和加密算法NIA0，NEA0。因此，我们必须在 docker-compose 中更新 AMF 配置（重要说明：在部署核心网络之前，在 docker-compose 的 oai-amf 服务中添加以下参数。）如下所示 ：
- INT_ALGO_LIST=["NIA1" , "NIA2"]- CIPH_ALGO_LIST=["NEA1" , "NEA2"]
#截至V1.5.0版本的核心网任然需要添加启动基础核心网
oai-cn5g-fed/docker-compose$ docker-compose -f docker-compose-basic-vpp-nrf.yaml up -d
Creating mysql ... done
Creating oai-nrf ... done
Creating vpp-upf ... done
Creating oai-udr ... done
Creating oai-udm ... done
Creating oai-ext-dn ... done
Creating oai-ausf ... done
Creating oai-amf ... done
Creating oai-smf ... done
检查容器健康状态
oai-cn5g-fed/docker-compose$ docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
4349e8808902 oai-smf:latest "/bin/bash /openair-…" 49 seconds ago Up 48 seconds (healthy) 80/tcp, 9090/tcp, 8805/udp oai-smf
62e774768482 oai-amf:latest "/bin/bash /openair-…" 49 seconds ago Up 48 seconds (healthy) 80/tcp, 9090/tcp, 38412/sctp oai-amf
0302e6a3d2b3 oai-ausf:latest "/bin/bash /openair-…" 50 seconds ago Up 49 seconds (healthy) 80/tcp oai-ausf
fb3249a5ade7 ubuntu:bionic "/bin/bash -c ' apt …" 51 seconds ago Up 49 seconds oai-ext-dn
4f114039c218 oai-udm:latest "/bin/bash /openair-…" 51 seconds ago Up 49 seconds (healthy) 80/tcp oai-udm
c0838aff8796 oai-udr:latest "/bin/bash /openair-…" 51 seconds ago Up 50 seconds (healthy) 80/tcp oai-udr
99ab1b23862c oai-upf-vpp:latest "/openair-upf/bin/en…" 51 seconds ago Up 50 seconds (healthy) 2152/udp, 8085/udp vpp-upf
3469f853e26d mysql:8.0 "docker-entrypoint.s…" 52 seconds ago Up 51 seconds (healthy) 3306/tcp, 33060/tcp mysql
ab06bd3104ef oai-nrf:latest "/bin/bash /openair-…" 52 seconds ago Up 51 seconds (healthy) 80/tcp, 9090/tcp oai-nrf
2. UERANSIM配置
2.1 UERANSIM镜像拉取
docker pull rohankharade/ueransim
docker image tag rohankharade/ueransim:latest ueransim:latest
2.2 UERANSIM docker-compose文件配置
注意：OAI官网提供了一个原始的UERANSIM配置脚本docker-compose-ueransim-vpp.yaml
我们只需要在其基础上进行修改即可，我重新配置了三个不同的ueransim容器，用ueransim1，ueransim2和ueransim3分别表示，其中ueransim1就是原始脚本的粘贴。详细配置见下图：
-
ueransim1配置
先创建ueransim1.ymal文件
oai-cn5g-fed/docker-compose$ vim ueransim1.yaml文件内容：
version: '3.8'
services:ueransim:container_name: ueransimimage: ueransim:latestprivileged: trueenvironment:# GNB Congig Parameters- MCC=208- MNC=95- NCI=0x000000010- TAC=0xa000- LINK_IP=192.168.70.141- NGAP_IP=192.168.70.141- GTP_IP=192.168.72.141- NGAP_PEER_IP=192.168.70.132- SST=222- SD=123- IGNORE_STREAM_IDS=true# UE Config Parameters- NUMBER_OF_UE=1- IMSI=208950000000031 #与附录.sql数据库文件对应- KEY=0C0A34601D4F07677303652C0462535B- OP=63bfa50ee6523365ff14c1f45f88737d- OP_TYPE=OPC- AMF_VALUE=8000- IMEI=356938035643803- IMEI_SV=0035609204079514- GNB_IP_ADDRESS=192.168.70.141- PDU_TYPE=IPv4- APN=default- SST_0=222- SD_0=123- SST_C=222- SD_C=123- SST_D=222- SD_D=123networks:public_net:ipv4_address: 192.168.70.141public_net_access:ipv4_address: 192.168.72.141healthcheck:test: /bin/bash -c "ifconfig uesimtun0"interval: 10stimeout: 5sretries: 5
networks:public_net:external:name: demo-oai-public-netpublic_net_access:external:name: oai-public-access
-
ueransim2配置
先创建ueransim2.ymal文件
oai-cn5g-fed/docker-compose$ vim ueransim2.yaml文件内容：
version: '3.8'
services:ueransim2:container_name: ueransim2image: ueransim:latestprivileged: trueenvironment:# GNB Congig Parameters- MCC=208- MNC=95- NCI=0x000000010- TAC=0xa000- LINK_IP=192.168.70.144- NGAP_IP=192.168.70.144- GTP_IP=192.168.72.144- NGAP_PEER_IP=192.168.70.132- SST=222- SD=123- IGNORE_STREAM_IDS=true# UE Config Parameters- NUMBER_OF_UE=1- IMSI=208950000000032 #与附录.sql数据库文件对应- KEY=0C0A34601D4F07677303652C0462535B- OP=63bfa50ee6523365ff14c1f45f88737d- OP_TYPE=OPC- AMF_VALUE=8000- IMEI=356938035643803- IMEI_SV=0035609204079514- GNB_IP_ADDRESS=192.168.70.144- PDU_TYPE=IPv4- APN=default- SST_0=222- SD_0=123- SST_C=222- SD_C=123- SST_D=222- SD_D=123networks:public_net:ipv4_address: 192.168.70.144public_net_access:ipv4_address: 192.168.72.144healthcheck:test: /bin/bash -c "ifconfig uesimtun0"interval: 10s
networks:public_net:external:name: demo-oai-public-netpublic_net_access:external:name: oai-public-access-
ueransim3配置
ueransim3:container_name: ueransim3image: ueransim:latestprivileged: trueenvironment:# GNB Congig Parameters- MCC=208- MNC=95- NCI=0x000000010- TAC=0xa000- LINK_IP=192.168.70.145- NGAP_IP=192.168.70.145- GTP_IP=192.168.72.145- NGAP_PEER_IP=192.168.70.132- SST=222- SD=123- IGNORE_STREAM_IDS=true# UE Config Parameters- NUMBER_OF_UE=1- IMSI=208950000000033 #与附录.sql数据库文件对应- KEY=0C0A34601D4F07677303652C0462535B- OP=63bfa50ee6523365ff14c1f45f88737d- OP_TYPE=OPC- AMF_VALUE=8000- IMEI=356938035643803- IMEI_SV=0035609204079514- GNB_IP_ADDRESS=192.168.70.145- PDU_TYPE=IPv4- APN=default- SST_0=222- SD_0=123- SST_C=222- SD_C=123- SST_D=222- SD_D=123networks:public_net:ipv4_address: 192.168.70.145public_net_access:ipv4_address: 192.168.72.145healthcheck:test: /bin/bash -c "ifconfig uesimtun0"interval: 10s
networks:public_net:external:name: demo-oai-public-netpublic_net_access:external:name: oai-public-access几个重要参数配置提醒
gNB参数
mcc: HPLMN (Home PLMN)的移动国家代码值。需要和SUPI保持一致。
mnc: HPLMN (Home PLMN)的移动网络代码值。需要和SUPI保持一致。MNC值可以是2位数字或3位数字。注意，2位值与3位值在语义上是不同的。例25与025不同。更多细节可以在TS 23.501中找到
nci: 该字段指定NR小区标识。同样idLength指定gNB ID的位长，它是NR单元标识的一部分。更多关于TS 38.413
tac: 此单元格的跟踪区域代码(tac)值
linkIp: 用于该gNB的无线电链路模拟的本地IP。UE应连接到此IP地址进行无线电模拟。IP地址必须与终端配置文件中的参数一致。否则UE无法连接到gNB。默认情况下，我们写在样例配置文件中，但如果您在不同的机器上使用UE和gNB，则根据您的环境更改此参数和参数
ngapIp: 该gNB N2接口的本地IP。AMF将发送SCTP数据包到此IP地址，因此要精确地设置此IP地址。否则AMF无法连接到gNB, SCTP超时错误。默认情况下，我们在示例配置文件中编写了这些内容，但是如果在不同的机器上使用gNB和AMF，则根据您的环境更改这些内容。(我们也建议在不同的机器上使用UERANSIM和核心网)
gtpIp: 该gNB的N3接口的本地IP。UPF会将GTP报文发送到此IP地址，因此请精确设置此IP地址。否则UPF无法向gNB发送数据报，数据平面功能无法正常工作。默认情况下，我们在示例配置文件中编写了这些内容，但是如果在不同的机器上使用gNB和UPF，则根据您的环境进行更改。(我们也建议在不同的机器上使用UERANSIM和核心网)
gtpAdvertiseIp: 如果需要将GTP监听地址和外部访问地址分开，可以设置该值覆盖向UPF发布的下行用户面传输层地址。这个字段是可选的，对大多数人来说不是必需的。在gNB和UPF之间进行NAT时尤其有用。我们没有在示例配置文件中包含该字段。
ngap_per_ip: 与核心网amf ip一致
amfConfigs: N2 (NGAP)接口的AMF IP地址和端口信息列表。这是你在address中设置的另一个端点。这一次，您应该将这个值设置为AMF的IP地址。默认情况下，我们在示例配置文件中编写了这些内容，但是如果在不同的机器上使用gNB和AMF，则根据您的环境更改这些内容。这个值通常是一个列表，但是目前只使用第一个指定的AMF。更复杂的AMF选择机制将在未来实现
slices: 该字段在终端配置中有说明。它是gNB支持的切片列表。
ignoreStreamIds: 某些核心网络可能无法正确处理SCTP流号。如果您想忽略此类错误，则将此字段设置为。true
SD,SST: 与核心网amf中切片信息参数保持一致，多个基站可以使用相同的参数（提供相同的切片业务种类）
UE参数
supi: 需要填写终端的IMSI号。请注意，我们只支持IMSI作为SUPI，即不支持NAI。除紧急注册外，此字段为必填项。
mcc: HPLMN (Home PLMN)的移动国家代码值。需要和SUPI保持一致。
mnc: HPLMN (Home PLMN)的移动网络代码值。需要和SUPI保持一致。MNC值可以是2位数字或3位数字。注意，2位值与3位值在语义上是不同的。例25与025不同。更多细节可以在TS 23.501中找到
key: 这是为该特定终端分配的永久订阅键。
op: 操作符代码值(op或OPC)必须写在这里。如果你在这里写OP值，你应该将opType设置为OP，如果你在这里写OPC值，你应该将opType设置为OPC。您可以使用OP或OPC密钥。
amf: 认证管理字段(Authentication Management Field, amf)必须写在这里。请注意，这与核心网络功能AMF(访问和移动管理功能)是不同的。
imei: 设备的imei号。如果没有SUPI和紧急登记，则使用IMEI。这个值通常不使用。
imeiSv: 设备的imeiSv号。如果没有SUPI和IMEI，则使用IMEISV，用于紧急登记等。这个值通常不使用。
gnbSearchList: gNB用于模拟无线电链路的IP地址列表。可以为多个gnb分配多个IP地址。UE将尝试从这个列表中选择一些gNB。该IP地址必须与gNB配置文件中的linkIp参数相匹配。否则UE无法连接到gNB。默认情况下，我们在示例配置文件中编写了127.0.0.1，但是如果您在不同的机器上使用UE和gNB，则根据您的环境更改此参数和linkIp参数。
uacAic: 该字段需要配置UAC (Unified Access Control)、AIC (Access identity Configuration)。mps代表多媒体优先服务，mcs代表关键任务服务。UAC AI配置参见TS 31.102。
uacAcc: 需要配置UAC (Unified Access Control)， Access Control Class (Access Control Class)。normalClass的取值范围为[0,9]，11到15的类用于高优先级访问。UAC ACC配置参见TS 31.102。
sessions: 初始PDU会话列表。这些会话在终端成功注册到5G核心网后自动建立。可以将多个PDU会话添加到此列表中。(不超过15个)。如果不需要初始化PDU会话，可以完全删除sessions参数。会话有type、apn和slice参数。目前只支持IPv4作为PDU会话类型。apn字段是可选的，用于指定接入点名称。slice参数是可选的，为这个特定的PDU会话指定S-NSSAI。sd参数也是可选的，但如果slice参数被包含，则sst总是必须的。可以删除可选参数，也可以将相关字段设置为null。
Configured - NSSAI: HPLMN (Home PLMN)为该终端配置的NSSAI。NSSAI的内容已经在上面解释过了。
Default - NSSAI: 该终端默认配置的NSSAI。NSSAI的内容已经在上面解释过
integrity/ciphering: 您可以在这里设置该终端支持的完整性和加密算法。通常，UERANSIM支持所有算法，但您可以通过此配置手动禁用其中一些算法。
integrityMaxRate: 该终端用户平面的完整性保护最大数据速率。可能的值是64kbps和TS 24.501指定的full。
3. UERANSIM运行
3.1 容器启动
oai-cn5g-fed/docker-compose# docker-compose -f ueransim1.yaml up -d
Creating ueransim1 ... doneoai-cn5g-fed/docker-compose# docker-compose -f ueransim2.yaml up -d
Creating ueransim2 ... done
oai-cn5g-fed/docker-compose# docker-compose -f ueransim3.yaml up -d
Creating ueransim3 ... done
3.2 容器健康状态查询
oai-cn5g-fed/docker-compose# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
e6357edcdf7f ueransim:latest "/ueransim/bin/entry…" About a minute ago Up About a minute (healthy) ueransim3
de87d59d237a ueransim:latest "/ueransim/bin/entry…" 2 minutes ago Up 2 minutes (healthy) ueransim2
c322b7a585ea ueransim:latest "/ueransim/bin/entry…" 3 minutes ago Up 3 minutes (healthy) ueransim1
6b54c671d801 oaisoftwarealliance/oai-smf:v1.5.0 "python3 /openair-sm…" 4 minutes ago Up 4 minutes (healthy) 80/tcp, 8080/tcp, 8805/udp oai-smf
a6f3e20cb32c oaisoftwarealliance/oai-amf:v1.5.0 "python3 /openair-am…" 4 minutes ago Up 4 minutes (healthy) 80/tcp, 9090/tcp, 38412/sctp oai-amf
efbbbeb5c564 oaisoftwarealliance/oai-ausf:v1.5.0 "python3 /openair-au…" 4 minutes ago Up 4 minutes (healthy) 80/tcp oai-ausf
6a9eec82d26d oaisoftwarealliance/oai-udm:v1.5.0 "python3 /openair-ud…" 4 minutes ago Up 4 minutes (healthy) 80/tcp oai-udm
464d2d89aac6 oaisoftwarealliance/oai-udr:v1.5.0 "python3 /openair-ud…" 4 minutes ago Up 4 minutes (healthy) 80/tcp oai-udr
704c5d822908 oaisoftwarealliance/oai-upf-vpp:v1.5.0 "/openair-upf/bin/en…" 4 minutes ago Up 4 minutes (healthy) 2152/udp, 8085/udp vpp-upf
d5c1eab629f5 oaisoftwarealliance/trf-gen-cn5g:latest "/bin/bash -c ' ipta…" 4 minutes ago Up 4 minutes (healthy) oai-ext-dn
407bf665562f oaisoftwarealliance/oai-nrf:v1.5.0 "python3 /openair-nr…" 4 minutes ago Up 4 minutes (healthy) 80/tcp, 9090/tcp oai-nrf
ec61be3a00a9 mysql:8.0 "docker-entrypoint.s…" 4 minutes ago Up 4 minutes (healthy) 3306/tcp, 33060/tcp mysql
3.3 ueransim接入日志查询
- ueransim1
oai-cn5g-fed/docker-compose# docker logs ueransim1
### Running ueransim ###
Running gnb
UERANSIM v3.2.5
[2023-03-07 08:32:24.723] [sctp] [info] Trying to establish SCTP connection... (192.168.70.132:38412)
[2023-03-07 08:32:24.724] [sctp] [info] SCTP connection established (192.168.70.132:38412)
[2023-03-07 08:32:24.724] [sctp] [debug] SCTP association setup ascId[15]
[2023-03-07 08:32:24.725] [ngap] [debug] Sending NG Setup Request
[2023-03-07 08:32:24.731] [ngap] [debug] NG Setup Response received
[2023-03-07 08:32:24.731] [ngap] [info] NG Setup procedure is successful
Running ue
UERANSIM v3.2.5
[2023-03-07 08:32:25.733] [nas] [info] UE switches to state [MM-DEREGISTERED/PLMN-SEARCH]
[2023-03-07 08:32:25.733] [rrc] [debug] UE[1] new signal detected
[2023-03-07 08:32:25.734] [rrc] [debug] New signal detected for cell[1], total [1] cells in coverage
[2023-03-07 08:32:25.734] [nas] [info] Selected plmn[208/95]
[2023-03-07 08:32:25.734] [rrc] [info] Selected cell plmn[208/95] tac[40960] category[SUITABLE]
[2023-03-07 08:32:25.734] [nas] [info] UE switches to state [MM-DEREGISTERED/PS]
[2023-03-07 08:32:25.734] [nas] [info] UE switches to state [MM-DEREGISTERED/NORMAL-SERVICE]
[2023-03-07 08:32:25.734] [nas] [debug] Initial registration required due to [MM-DEREG-NORMAL-SERVICE]
[2023-03-07 08:32:25.734] [nas] [debug] UAC access attempt is allowed for identity[0], category[MO_sig]
[2023-03-07 08:32:25.734] [nas] [debug] Sending Initial Registration
[2023-03-07 08:32:25.735] [nas] [info] UE switches to state [MM-REGISTER-INITIATED]
[2023-03-07 08:32:25.735] [rrc] [debug] Sending RRC Setup Request
[2023-03-07 08:32:25.735] [rrc] [info] RRC Setup for UE[1]
[2023-03-07 08:32:25.736] [rrc] [info] RRC connection established
[2023-03-07 08:32:25.736] [rrc] [info] UE switches to state [RRC-CONNECTED]
[2023-03-07 08:32:25.736] [nas] [info] UE switches to state [CM-CONNECTED]
[2023-03-07 08:32:25.736] [ngap] [debug] Initial NAS message received from UE[1]
[2023-03-07 08:32:25.783] [nas] [debug] Authentication Request received
[2023-03-07 08:32:25.791] [nas] [debug] Security Mode Command received
[2023-03-07 08:32:25.791] [nas] [debug] Selected integrity[1] ciphering[1]
[2023-03-07 08:32:25.794] [ngap] [debug] Initial Context Setup Request received
[2023-03-07 08:32:25.795] [nas] [debug] Registration accept received
[2023-03-07 08:32:25.795] [nas] [info] UE switches to state [MM-REGISTERED/NORMAL-SERVICE]
[2023-03-07 08:32:25.795] [nas] [debug] Sending Registration Complete
[2023-03-07 08:32:25.795] [nas] [info] Initial Registration is successful
[2023-03-07 08:32:25.795] [nas] [debug] Sending PDU Session Establishment Request
[2023-03-07 08:32:25.795] [nas] [debug] UAC access attempt is allowed for identity[0], category[MO_sig]
[2023-03-07 08:32:26.043] [ngap] [info] PDU session resource(s) setup for UE[1] count[1]
[2023-03-07 08:32:26.043] [nas] [debug] PDU Session Establishment Accept received
[2023-03-07 08:32:26.044] [nas] [info] PDU Session establishment is successful PSI[1]
[2023-03-07 08:32:26.056] [app] [info] Connection setup for PDU session[1] is successful, TUN interface[uesimtun0, 12.1.1.2] is up.- ueransim2
oai-cn5g-fed/docker-compose# docker logs ueransim2
UERANSIM v3.2.5
[2023-03-07 08:33:39.418] [sctp] [info] Trying to establish SCTP connection... (192.168.70.132:38412)
[2023-03-07 08:33:39.419] [sctp] [info] SCTP connection established (192.168.70.132:38412)
[2023-03-07 08:33:39.419] [sctp] [debug] SCTP association setup ascId[17]
[2023-03-07 08:33:39.419] [ngap] [debug] Sending NG Setup Request
[2023-03-07 08:33:39.421] [ngap] [debug] NG Setup Response received
[2023-03-07 08:33:39.421] [ngap] [info] NG Setup procedure is successful
Running ue
UERANSIM v3.2.5
[2023-03-07 08:33:40.423] [nas] [info] UE switches to state [MM-DEREGISTERED/PLMN-SEARCH]
[2023-03-07 08:33:40.423] [rrc] [debug] UE[1] new signal detected
[2023-03-07 08:33:40.423] [rrc] [debug] New signal detected for cell[1], total [1] cells in coverage
[2023-03-07 08:33:40.424] [nas] [info] Selected plmn[208/95]
[2023-03-07 08:33:40.424] [rrc] [info] Selected cell plmn[208/95] tac[40960] category[SUITABLE]
[2023-03-07 08:33:40.424] [nas] [info] UE switches to state [MM-DEREGISTERED/PS]
[2023-03-07 08:33:40.424] [nas] [info] UE switches to state [MM-DEREGISTERED/NORMAL-SERVICE]
[2023-03-07 08:33:40.424] [nas] [debug] Initial registration required due to [MM-DEREG-NORMAL-SERVICE]
[2023-03-07 08:33:40.424] [nas] [debug] UAC access attempt is allowed for identity[0], category[MO_sig]
[2023-03-07 08:33:40.424] [nas] [debug] Sending Initial Registration
[2023-03-07 08:33:40.424] [nas] [info] UE switches to state [MM-REGISTER-INITIATED]
[2023-03-07 08:33:40.424] [rrc] [debug] Sending RRC Setup Request
[2023-03-07 08:33:40.424] [rrc] [info] RRC Setup for UE[1]
[2023-03-07 08:33:40.425] [rrc] [info] RRC connection established
[2023-03-07 08:33:40.425] [rrc] [info] UE switches to state [RRC-CONNECTED]
[2023-03-07 08:33:40.425] [nas] [info] UE switches to state [CM-CONNECTED]
[2023-03-07 08:33:40.425] [ngap] [debug] Initial NAS message received from UE[1]
[2023-03-07 08:33:40.436] [nas] [debug] Authentication Request received
[2023-03-07 08:33:40.444] [nas] [debug] Security Mode Command received
[2023-03-07 08:33:40.444] [nas] [debug] Selected integrity[1] ciphering[1]
[2023-03-07 08:33:40.447] [ngap] [debug] Initial Context Setup Request received
[2023-03-07 08:33:40.448] [nas] [debug] Registration accept received
[2023-03-07 08:33:40.448] [nas] [info] UE switches to state [MM-REGISTERED/NORMAL-SERVICE]
[2023-03-07 08:33:40.448] [nas] [debug] Sending Registration Complete
[2023-03-07 08:33:40.448] [nas] [info] Initial Registration is successful
[2023-03-07 08:33:40.448] [nas] [debug] Sending PDU Session Establishment Request
[2023-03-07 08:33:40.448] [nas] [debug] UAC access attempt is allowed for identity[0], category[MO_sig]
[2023-03-07 08:33:56.555] [nas] [warning] Retransmitting PDU Session Establishment Request due to T3580 expiry
[2023-03-07 08:33:56.555] [nas] [debug] UAC access attempt is allowed for identity[0], category[MO_sig]
[2023-03-07 08:33:56.576] [ngap] [info] PDU session resource(s) setup for UE[1] count[1]
[2023-03-07 08:33:56.577] [nas] [debug] PDU Session Establishment Accept received
[2023-03-07 08:33:56.577] [nas] [info] PDU Session establishment is successful PSI[1]
[2023-03-07 08:33:56.590] [app] [info] Connection setup for PDU session[1] is successful, TUN interface[uesimtun0, 12.1.1.3] is up.- ueransim3
oai-cn5g-fed/docker-compose# docker logs ueransim3
UERANSIM v3.2.5
[2023-03-07 08:34:40.868] [sctp] [info] Trying to establish SCTP connection... (192.168.70.132:38412)
[2023-03-07 08:34:40.869] [sctp] [info] SCTP connection established (192.168.70.132:38412)
[2023-03-07 08:34:40.870] [sctp] [debug] SCTP association setup ascId[19]
[2023-03-07 08:34:40.870] [ngap] [debug] Sending NG Setup Request
[2023-03-07 08:34:40.871] [ngap] [debug] NG Setup Response received
[2023-03-07 08:34:40.871] [ngap] [info] NG Setup procedure is successful
Running ue
UERANSIM v3.2.5
[2023-03-07 08:34:41.919] [nas] [info] UE switches to state [MM-DEREGISTERED/PLMN-SEARCH]
[2023-03-07 08:34:41.919] [rrc] [debug] UE[1] new signal detected
[2023-03-07 08:34:41.919] [rrc] [debug] New signal detected for cell[1], total [1] cells in coverage
[2023-03-07 08:34:41.920] [nas] [info] Selected plmn[208/95]
[2023-03-07 08:34:41.920] [rrc] [info] Selected cell plmn[208/95] tac[40960] category[SUITABLE]
[2023-03-07 08:34:41.920] [nas] [info] UE switches to state [MM-DEREGISTERED/PS]
[2023-03-07 08:34:41.920] [nas] [info] UE switches to state [MM-DEREGISTERED/NORMAL-SERVICE]
[2023-03-07 08:34:41.920] [nas] [debug] Initial registration required due to [MM-DEREG-NORMAL-SERVICE]
[2023-03-07 08:34:41.920] [nas] [debug] UAC access attempt is allowed for identity[0], category[MO_sig]
[2023-03-07 08:34:41.920] [nas] [debug] Sending Initial Registration
[2023-03-07 08:34:41.920] [nas] [info] UE switches to state [MM-REGISTER-INITIATED]
[2023-03-07 08:34:41.920] [rrc] [debug] Sending RRC Setup Request
[2023-03-07 08:34:41.921] [rrc] [info] RRC Setup for UE[1]
[2023-03-07 08:34:41.921] [rrc] [info] RRC connection established
[2023-03-07 08:34:41.921] [rrc] [info] UE switches to state [RRC-CONNECTED]
[2023-03-07 08:34:41.921] [nas] [info] UE switches to state [CM-CONNECTED]
[2023-03-07 08:34:41.921] [ngap] [debug] Initial NAS message received from UE[1]
[2023-03-07 08:34:41.933] [nas] [debug] Authentication Request received
[2023-03-07 08:34:41.941] [nas] [debug] Security Mode Command received
[2023-03-07 08:34:41.941] [nas] [debug] Selected integrity[1] ciphering[1]
[2023-03-07 08:34:41.945] [ngap] [debug] Initial Context Setup Request received
[2023-03-07 08:34:41.945] [nas] [debug] Registration accept received
[2023-03-07 08:34:41.946] [nas] [info] UE switches to state [MM-REGISTERED/NORMAL-SERVICE]
[2023-03-07 08:34:41.946] [nas] [debug] Sending Registration Complete
[2023-03-07 08:34:41.946] [nas] [info] Initial Registration is successful
[2023-03-07 08:34:41.946] [nas] [debug] Sending PDU Session Establishment Request
[2023-03-07 08:34:41.946] [nas] [debug] UAC access attempt is allowed for identity[0], category[MO_sig]
[2023-03-07 08:34:42.176] [ngap] [info] PDU session resource(s) setup for UE[1] count[1]
[2023-03-07 08:34:42.176] [nas] [debug] PDU Session Establishment Accept received
[2023-03-07 08:34:42.176] [nas] [info] PDU Session establishment is successful PSI[1]
[2023-03-07 08:34:42.190] [app] [info] Connection setup for PDU session[1] is successful, TUN interface[uesimtun0, 12.1.1.4] is up.3.4 AMF日志查询
oai-cn5g-fed/docker-compose# docker logs oai-amf
[2023-03-07T08:36:41.820800] [AMF] [amf_app] [info ] |----------------------------------------------------gNBs' information-------------------------------------------|
[2023-03-07T08:36:41.820802] [AMF] [amf_app] [info ] | Index | Status | Global ID | gNB Name | PLMN |
[2023-03-07T08:36:41.820805] [AMF] [amf_app] [info ] | 1 | Connected | 0x1 | UERANSIM-gnb-208-95-1 | 208, 95 |
[2023-03-07T08:36:41.820807] [AMF] [amf_app] [info ] |----------------------------------------------------------------------------------------------------------------|
[2023-03-07T08:36:41.820808] [AMF] [amf_app] [info ]
[2023-03-07T08:36:41.820809] [AMF] [amf_app] [info ] |----------------------------------------------------------------------------------------------------------------|
[2023-03-07T08:36:41.820810] [AMF] [amf_app] [info ] |----------------------------------------------------UEs' information--------------------------------------------|
[2023-03-07T08:36:41.820811] [AMF] [amf_app] [info ] | Index | 5GMM state | IMSI | GUTI | RAN UE NGAP ID | AMF UE ID | PLMN |Cell ID|
[2023-03-07T08:36:41.820814] [AMF] [amf_app] [info ] | 1| 5GMM-REGISTERED| 208950000000031| | 1| 1| 208, 95 | 256|
[2023-03-07T08:36:41.820816] [AMF] [amf_app] [info ] | 2| 5GMM-REGISTERED| 208950000000032| | 1| 2| 208, 95 | 256|
[2023-03-07T08:36:41.820818] [AMF] [amf_app] [info ] | 3| 5GMM-REGISTERED| 208950000000033| | 1| 3| 208, 95 | 256|
[2023-03-07T08:36:41.820819] [AMF] [amf_app] [info ] |----------------------------------------------------------------------------------------------------------------|
3.5 用户信息查询
您可以借助 UE 控制台进一步调查子命令的用法和帮助信息。（参考官方页面）
$ docker exec -it ueransim ./nr-cli imsi-208950000000130
--------------------------------------------------------------------------------------------
$ commands
info | Show some information about the UE
status | Show some status information about the UE
timers | Dump current status of the timers in the UE
rls-state | Show status information about RLS
coverage | Dump available cells and PLMNs in the coverage
ps-establish | Trigger a PDU session establishment procedure
ps-list | List all PDU sessions
ps-release | Trigger a PDU session release procedure
ps-release-all | Trigger PDU session release procedures for all active sessions
deregister | Perform a de-registration by the UE
--------------------------------------------------------------------------------------------
4. 数据流测试
我们任然使用oai提供的外部DN容器来进行ping测试
root@lab-virtual-machine:/home/lab/oai-cn5g-fed/docker-compose# docker exec -it oai-ext-dn ping -c 3 12.1.1.2
PING 12.1.1.2 (12.1.1.2) 56(84) bytes of data.
64 bytes from 12.1.1.2: icmp_seq=1 ttl=63 time=4.68 ms
64 bytes from 12.1.1.2: icmp_seq=2 ttl=63 time=1.68 ms
64 bytes from 12.1.1.2: icmp_seq=3 ttl=63 time=1.79 ms--- 12.1.1.2 ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2025ms
rtt min/avg/max/mdev = 1.685/2.720/4.687/1.392 ms
root@lab-virtual-machine:/home/lab/oai-cn5g-fed/docker-compose# docker exec -it oai-ext-dn ping -c 3 12.1.1.3
PING 12.1.1.3 (12.1.1.3) 56(84) bytes of data.
64 bytes from 12.1.1.3: icmp_seq=1 ttl=63 time=2.63 ms
64 bytes from 12.1.1.3: icmp_seq=2 ttl=63 time=1.25 ms
64 bytes from 12.1.1.3: icmp_seq=3 ttl=63 time=1.58 ms--- 12.1.1.3 ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2015ms
rtt min/avg/max/mdev = 1.253/1.824/2.635/0.589 ms
root@lab-virtual-machine:/home/lab/oai-cn5g-fed/docker-compose# docker exec -it oai-ext-dn ping -c 3 12.1.1.4
PING 12.1.1.4 (12.1.1.4) 56(84) bytes of data.
64 bytes from 12.1.1.4: icmp_seq=1 ttl=63 time=1.95 ms
64 bytes from 12.1.1.4: icmp_seq=2 ttl=63 time=0.847 ms
64 bytes from 12.1.1.4: icmp_seq=3 ttl=63 time=1.26 ms--- 12.1.1.4 ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2038ms
rtt min/avg/max/mdev = 0.847/1.356/1.956/0.458 ms5. 基站及核心网的取消部署
警告⚠：必须先全部取消基站的接入后才能关闭核心网
5.1 基站取消部署
oai-cn5g-fed/docker-compose# docker-compose -f ueransim1.yaml down
Stopping ueransim1 ... done
WARNING: Found orphan containers (oai-udm, oai-smf, oai-nrf, oai-amf, oai-udr, mysql, ueransim3, ueransim2, oai-ext-dn, vpp-upf, oai-ausf) for this project. If you removed or renamed this service in your compose file, you can run this command with the --remove-orphans flag to clean it up.
Removing ueransim1 ... done
Network demo-oai-public-net is external, skipping
Network oai-public-access is external, skipping
root@lab-virtual-machine:/home/lab/oai-cn5g-fed/docker-compose# docker-compose -f ueransim2.yaml down
Stopping ueransim2 ... done
WARNING: Found orphan containers (oai-amf, oai-smf, vpp-upf, oai-ext-dn, oai-nrf, oai-udm, oai-ausf, mysql, ueransim3, oai-udr) for this project. If you removed or renamed this service in your compose file, you can run this command with the --remove-orphans flag to clean it up.
Removing ueransim2 ... done
Network demo-oai-public-net is external, skipping
Network oai-public-access is external, skipping
root@lab-virtual-machine:/home/lab/oai-cn5g-fed/docker-compose# docker-compose -f ueransim3.yaml down
Stopping ueransim3 ... done
WARNING: Found orphan containers (oai-ext-dn, oai-nrf, oai-udm, oai-udr, oai-ausf, oai-smf, mysql, vpp-upf, oai-amf) for this project. If you removed or renamed this service in your compose file, you can run this command with the --remove-orphans flag to clean it up.
Removing ueransim3 ... done
Network demo-oai-public-net is external, skipping
Network oai-public-access is external, skipping5.2 核心网的取消部署
python3 ./core-network.py --type stop-basic-vpp --scenario 1[2023-03-07 17:19:25,710] root:DEBUG: UnDeploying OAI 5G core components....
[2023-03-07 17:19:25,710] root:DEBUG: docker-compose -f docker-compose-basic-vpp-nrf.yaml down -t 0
Stopping oai-smf ... done
Stopping oai-amf ... done
Stopping oai-ausf ... done
Stopping oai-udm ... done
Stopping oai-udr ... done
Stopping vpp-upf ... done
Stopping oai-ext-dn ... done
Stopping oai-nrf ... done
Stopping mysql ... done
Removing oai-smf ... done
Removing oai-amf ... done
Removing oai-ausf ... done
Removing oai-udm ... done
Removing oai-udr ... done
Removing vpp-upf ... done
Removing oai-ext-dn ... done
Removing oai-nrf ... done
Removing mysql ... done
Removing network demo-oai-public-net
Removing network oai-public-access
Removing network oai-public-core[2023-03-07 17:19:30,346] root:DEBUG: OAI 5G core components are UnDeployed....附录
核心网docker-compose-basic-vpp-nrf.yaml文件
version: '3.8'
services:mysql:container_name: "mysql"image: mysql:8.0volumes:- ./database/oai_db2.sql:/docker-entrypoint-initdb.d/oai_db.sql- ./healthscripts/mysql-healthcheck2.sh:/tmp/mysql-healthcheck.shenvironment:- TZ=Europe/Paris- MYSQL_DATABASE=oai_db- MYSQL_USER=test- MYSQL_PASSWORD=test- MYSQL_ROOT_PASSWORD=linuxhealthcheck:test: /bin/bash -c "/tmp/mysql-healthcheck.sh"interval: 10stimeout: 5sretries: 30networks:public_net:ipv4_address: 192.168.70.131oai-udr:container_name: "oai-udr"image: oaisoftwarealliance/oai-udr:v1.5.0environment:- TZ=Europe/Paris- UDR_NAME=OAI_UDR- UDR_INTERFACE_NAME_FOR_NUDR=eth0- MYSQL_IPV4_ADDRESS=192.168.70.131- MYSQL_USER=test- MYSQL_PASS=test- MYSQL_DB=oai_db- WAIT_MYSQL=120- USE_FQDN_DNS=yes- REGISTER_NRF=yes- NRF_IPV4_ADDRESS=192.168.70.130- NRF_FQDN=oai-nrfdepends_on:- mysql- oai-nrfnetworks:public_net:ipv4_address: 192.168.70.136oai-udm:container_name: "oai-udm"image: oaisoftwarealliance/oai-udm:v1.5.0environment:- TZ=Europe/Paris- UDM_NAME=OAI_UDM- SBI_IF_NAME=eth0- REGISTER_NRF=yes- USE_FQDN_DNS=yes- UDR_IP_ADDRESS=192.168.70.136- UDR_FQDN=oai-udr- NRF_IPV4_ADDRESS=192.168.70.130- NRF_FQDN=oai-nrfdepends_on:- oai-udrnetworks:public_net:ipv4_address: 192.168.70.137oai-ausf:container_name: "oai-ausf"image: oaisoftwarealliance/oai-ausf:v1.5.0environment:- TZ=Europe/Paris- AUSF_NAME=OAI_AUSF- SBI_IF_NAME=eth0- USE_FQDN_DNS=yes- REGISTER_NRF=yes- UDM_IP_ADDRESS=192.168.70.137- UDM_FQDN=oai-udm- NRF_IPV4_ADDRESS=192.168.70.130- NRF_FQDN=oai-nrfdepends_on:- oai-udmnetworks:public_net:ipv4_address: 192.168.70.138oai-nrf:container_name: "oai-nrf"image: oaisoftwarealliance/oai-nrf:v1.5.0environment:- TZ=Europe/Paris- NRF_INTERFACE_NAME_FOR_SBI=eth0networks:public_net:ipv4_address: 192.168.70.130oai-amf:container_name: "oai-amf"image: oaisoftwarealliance/oai-amf:v1.5.0environment:- TZ=Europe/paris- MCC=208- MNC=95- REGION_ID=128- AMF_SET_ID=1- SERVED_GUAMI_MCC_0=208- SERVED_GUAMI_MNC_0=95- SERVED_GUAMI_REGION_ID_0=128- SERVED_GUAMI_AMF_SET_ID_0=1- SERVED_GUAMI_MCC_1=460- SERVED_GUAMI_MNC_1=11- SERVED_GUAMI_REGION_ID_1=10- SERVED_GUAMI_AMF_SET_ID_1=1- PLMN_SUPPORT_MCC=208- PLMN_SUPPORT_MNC=95- PLMN_SUPPORT_TAC=0xa000# Slice 0 (222, 123)- SST_0=222- SD_0=123# Slice 0 (128, 12)- SST_1=128- SD_1=12- AMF_INTERFACE_NAME_FOR_NGAP=eth0- AMF_INTERFACE_NAME_FOR_N11=eth0# One single SMF instance- SMF_INSTANCE_ID_0=1- SMF_FQDN_0=oai-smf- SMF_IPV4_ADDR_0=192.168.70.133- SELECTED_0=true- NF_REGISTRATION=yes- SMF_SELECTION=yes- USE_FQDN_DNS=yes- EXTERNAL_AUSF=yes- EXTERNAL_UDM=no- EXTERNAL_NSSF=no- NRF_IPV4_ADDRESS=192.168.70.130- NRF_FQDN=oai-nrf- AUSF_IPV4_ADDRESS=192.168.70.138- AUSF_FQDN=oai-ausf- UDM_IPV4_ADDRESS=192.168.70.137- UDM_FQDN=oai-udmdepends_on:- mysql- vpp-upf- oai-ext-dn- oai-ausfnetworks:public_net:ipv4_address: 192.168.70.132oai-smf:container_name: "oai-smf"image: oaisoftwarealliance/oai-smf:v1.5.0environment:- TZ=Europe/Paris- SMF_INTERFACE_NAME_FOR_N4=eth0- SMF_INTERFACE_NAME_FOR_SBI=eth0- DEFAULT_DNS_IPV4_ADDRESS=172.21.3.100- DEFAULT_DNS_SEC_IPV4_ADDRESS=8.8.8.8- AMF_IPV4_ADDRESS=192.168.70.132- AMF_FQDN=oai-amf- UDM_IPV4_ADDRESS=192.168.70.137- UDM_FQDN=oai-udm- UPF_IPV4_ADDRESS=192.168.70.201- UPF_FQDN_0=vpp-upf.node.5gcn.mnc95.mcc208.3gppnetwork- NRF_IPV4_ADDRESS=192.168.70.130- NRF_FQDN=oai-nrf- DEFAULT_CSCF_IPV4_ADDRESS=127.0.0.1 # only needed when ims is being used- USE_LOCAL_SUBSCRIPTION_INFO=yes #Set to yes if SMF uses local subscription information instead of from an UDM- REGISTER_NRF=yes- DISCOVER_UPF=yes- USE_FQDN_DNS=yes- ENABLE_USAGE_REPORTING=yes# Slice 0 (1, 0xFFFFFF)- DNN_NI0=oai- TYPE0=IPv4- DNN_RANGE0=12.1.1.151 - 12.1.1.253- NSSAI_SST0=1- SESSION_AMBR_UL0=200Mbps- SESSION_AMBR_DL0=400Mbps# Slice 1 (1, 1)- DNN_NI1=oai.ipv4- TYPE1=IPv4- DNN_RANGE1=12.1.1.51 - 12.1.1.150- NSSAI_SST1=1- NSSAI_SD1=1- SESSION_AMBR_UL1=100Mbps- SESSION_AMBR_DL1=200Mbps# Slice 2 (222, 123)- DNN_NI2=default- TYPE2=IPv4- DNN_RANGE2=12.1.1.2 - 12.1.1.50- NSSAI_SST2=222- NSSAI_SD2=123- SESSION_AMBR_UL2=50Mbps- SESSION_AMBR_DL2=100Mbps# Slice 3 for ims- DNN_NI3=ims- TYPE3=IPv4v6- DNN_RANGE3=14.1.1.2 - 14.1.1.253extra_hosts:- "vpp-upf.node.5gcn.mnc95.mcc208.3gppnetwork:192.168.70.201"depends_on:- oai-amfnetworks:public_net:ipv4_address: 192.168.70.133vpp-upf:privileged: truecontainer_name: "vpp-upf"image: oaisoftwarealliance/oai-upf-vpp:v1.5.0environment:- IF_1_IP=192.168.70.201- IF_1_TYPE=N4- IF_2_IP=192.168.72.201- IF_2_TYPE=N3- IF_2_NWI=access.oai- IF_3_IP=192.168.73.201- IF_3_TYPE=N6- IF_3_IP_REMOTE=192.168.73.135 # EXT-DN IP Address- IF_3_NWI=internet.oai- NAME=VPP-UPF- MNC=95- MCC=208- REALM=3gppnetwork- VPP_MAIN_CORE=0- VPP_CORE_WORKER=1
# - VPP_PLUGIN_PATH=/usr/lib64/vpp_plugins/ # RHEL7- VPP_PLUGIN_PATH=/usr/lib/x86_64-linux-gnu/vpp_plugins/ # Ubntu18.04- SNSSAI_SD=123- SNSSAI_SST=222- DNN=default- REGISTER_NRF=yes- NRF_IP_ADDR=192.168.70.130- NRF_PORT=80- HTTP_VERSION=1depends_on:- oai-nrfhealthcheck:test: /bin/bash -c "pgrep vpp"interval: 10stimeout: 5sretries: 5networks:public_net:ipv4_address: 192.168.70.134public_net_access:ipv4_address: 192.168.72.134public_net_core:ipv4_address: 192.168.73.134oai-ext-dn:privileged: trueinit: truecontainer_name: "oai-ext-dn"image: oaisoftwarealliance/trf-gen-cn5g:latestentrypoint: /bin/bash -c \"iptables -t nat -A POSTROUTING -o eth0 -j MASQUERADE;"\"ip route add 12.1.1.0/24 via 192.168.73.201 dev eth0; ip route; sleep infinity"command: ["/bin/bash", "-c", "trap : SIGTERM SIGINT; sleep infinity & wait"]healthcheck:test: /bin/bash -c "iptables -L -t nat | grep MASQUERADE"interval: 10stimeout: 5sretries: 5networks:public_net_core:ipv4_address: 192.168.73.135
networks:public_net:driver: bridgename: demo-oai-public-netipam:config:- subnet: 192.168.70.0/24driver_opts:com.dockerwork.bridge.name: "demo-oai"public_net_access:name: oai-public-accessipam:config:- subnet: 192.168.72.0/24driver_opts:com.dockerwork.bridge.name: "cn5g-access"public_net_core:name: oai-public-coreipam:config:- subnet: 192.168.73.0/24driver_opts:com.dockerwork.bridge.name: "cn5g-core"
我们使用的oai-ex-dn的容器也是在basic核心网的docker-compose-basic-nrf.yaml文件中定义的，我们将该容器的代码截取出来
oai-ext-dn:privileged: trueinit: truecontainer_name: oai-ext-dnimage: oaisoftwarealliance/trf-gen-cn5g:latestentrypoint: /bin/bash -c \"ip route add 12.1.1.0/24 via 192.168.70.134 dev eth0; ip route; sleep infinity"command: ["/bin/bash", "-c", "trap : SIGTERM SIGINT; sleep infinity & wait"]healthcheck:test: /bin/bash -c "ip r | grep 12.1.1"interval: 10stimeout: 5sretries: 5networks:public_net:ipv4_address: 192.168.70.135核心网数据库oai_db2.sql文件
-- phpMyAdmin SQL Dump
-- version 5.1.0
-- /
--
-- Host: 172.16.200.10:3306
-- Generation Time: Mar 22, 2021 at 10:31 AM
-- Server version: 5.7.33
-- PHP Version: 7.4.15SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;--
-- Database: `oai_db`
---- ----------------------------------------------------------
-- Table structure for table `AccessAndMobilitySubscriptionData`
--CREATE TABLE `AccessAndMobilitySubscriptionData` (`ueid` varchar(15) NOT NULL,`servingPlmnid` varchar(15) NOT NULL,`supportedFeatures` varchar(50) DEFAULT NULL,`gpsis` json DEFAULT NULL,`internalGroupIds` json DEFAULT NULL,`sharedVnGroupDataIds` json DEFAULT NULL,`subscribedUeAmbr` json DEFAULT NULL,`nssai` json DEFAULT NULL,`ratRestrictions` json DEFAULT NULL,`forbiddenAreas` json DEFAULT NULL,`serviceAreaRestriction` json DEFAULT NULL,`coreNetworkTypeRestrictions` json DEFAULT NULL,`rfspIndex` int(10) DEFAULT NULL,`subsRegTimer` int(10) DEFAULT NULL,`ueUsageType` int(10) DEFAULT NULL,`mpsPriority` tinyint(1) DEFAULT NULL,`mcsPriority` tinyint(1) DEFAULT NULL,`activeTime` int(10) DEFAULT NULL,`sorInfo` json DEFAULT NULL,`sorInfoExpectInd` tinyint(1) DEFAULT NULL,`sorafRetrieval` tinyint(1) DEFAULT NULL,`sorUpdateIndicatorList` json DEFAULT NULL,`upuInfo` json DEFAULT NULL,`micoAllowed` tinyint(1) DEFAULT NULL,`sharedAmDataIds` json DEFAULT NULL,`odbPacketServices` json DEFAULT NULL,`serviceGapTime` int(10) DEFAULT NULL,`mdtUserConsent` json DEFAULT NULL,`mdtConfiguration` json DEFAULT NULL,`traceData` json DEFAULT NULL,`cagData` json DEFAULT NULL,`stnSr` varchar(50) DEFAULT NULL,`cMsisdn` varchar(50) DEFAULT NULL,`nbIoTUePriority` int(10) DEFAULT NULL,`nssaiInclusionAllowed` tinyint(1) DEFAULT NULL,`rgWirelineCharacteristics` varchar(50) DEFAULT NULL,`ecRestrictionDataWb` json DEFAULT NULL,`ecRestrictionDataNb` tinyint(1) DEFAULT NULL,`expectedUeBehaviourList` json DEFAULT NULL,`primaryRatRestrictions` json DEFAULT NULL,`secondaryRatRestrictions` json DEFAULT NULL,`edrxParametersList` json DEFAULT NULL,`ptwParametersList` json DEFAULT NULL,`iabOperationAllowed` tinyint(1) DEFAULT NULL,`wirelineForbiddenAreas` json DEFAULT NULL,`wirelineServiceAreaRestriction` json DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;INSERT INTO `AccessAndMobilitySubscriptionData` (`ueid`, `servingPlmnid`, `nssai`) VALUES
('208950000000125', '20895','{\"defaultSingleNssais\": [{\"sst\": 1, \"sd\": \"1\"}]}'),
('208950000000126', '20895','{\"defaultSingleNssais\": [{\"sst\": 1, \"sd\": \"1\"}]}'),
('208950000000127', '20895','{\"defaultSingleNssais\": [{\"sst\": 1, \"sd\": \"1\"}]}'),
('208950000000128', '20895','{\"defaultSingleNssais\": [{\"sst\": 1, \"sd\": \"1\"}]}'),
('208950000000129', '20895','{\"defaultSingleNssais\": [{\"sst\": 1, \"sd\": \"1\"}]}');
-- ----------------------------------------------------------
-- Table structure for table `Amf3GppAccessRegistration`
--CREATE TABLE `Amf3GppAccessRegistration` (`ueid` varchar(15) NOT NULL,`amfInstanceId` varchar(50) NOT NULL,`supportedFeatures` varchar(50) DEFAULT NULL,`purgeFlag` tinyint(1) DEFAULT NULL,`pei` varchar(50) DEFAULT NULL,`imsVoPs` json DEFAULT NULL,`deregCallbackUri` varchar(50) NOT NULL,`amfServiceNameDereg` json DEFAULT NULL,`pcscfRestorationCallbackUri` varchar(50) DEFAULT NULL,`amfServiceNamePcscfRest` json DEFAULT NULL,`initialRegistrationInd` tinyint(1) DEFAULT NULL,`guami` json NOT NULL,`backupAmfInfo` json DEFAULT NULL,`drFlag` tinyint(1) DEFAULT NULL,`ratType` json NOT NULL,`urrpIndicator` tinyint(1) DEFAULT NULL,`amfEeSubscriptionId` varchar(50) DEFAULT NULL,`epsInterworkingInfo` json DEFAULT NULL,`ueSrvccCapability` tinyint(1) DEFAULT NULL,`registrationTime` varchar(50) DEFAULT NULL,`vgmlcAddress` json DEFAULT NULL,`contextInfo` json DEFAULT NULL,`noEeSubscriptionInd` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------------------------------------
-- Table structure for table `AuthenticationStatus`
--CREATE TABLE `AuthenticationStatus` (`ueid` varchar(20) NOT NULL,`nfInstanceId` varchar(50) NOT NULL,`success` tinyint(1) NOT NULL,`timeStamp` varchar(50) NOT NULL,`authType` varchar(25) NOT NULL,`servingNetworkName` varchar(50) NOT NULL,`authRemovalInd` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------------------------------------
-- Table structure for table `AuthenticationSubscription`
--CREATE TABLE `AuthenticationSubscription` (`ueid` varchar(20) NOT NULL,`authenticationMethod` varchar(25) NOT NULL,`encPermanentKey` varchar(50) DEFAULT NULL,`protectionParameterId` varchar(50) DEFAULT NULL,`sequenceNumber` json DEFAULT NULL,`authenticationManagementField` varchar(50) DEFAULT NULL,`algorithmId` varchar(50) DEFAULT NULL,`encOpcKey` varchar(50) DEFAULT NULL,`encTopcKey` varchar(50) DEFAULT NULL,`vectorGenerationInHss` tinyint(1) DEFAULT NULL,`n5gcAuthMethod` varchar(15) DEFAULT NULL,`rgAuthenticationInd` tinyint(1) DEFAULT NULL,`supi` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;--
-- Dumping data for table `AuthenticationSubscription`
--INSERT INTO `AuthenticationSubscription` (`ueid`, `authenticationMethod`, `encPermanentKey`, `protectionParameterId`, `sequenceNumber`, `authenticationManagementField`, `algorithmId`, `encOpcKey`, `encTopcKey`, `vectorGenerationInHss`, `n5gcAuthMethod`, `rgAuthenticationInd`, `supi`) VALUES
('208950000000031', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000031'),
('208950000000032', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000032'),
('208950000000033', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000033'),
('208950000000034', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000034'),
('208950000000035', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000035'),
('208950000000036', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000036'),
('208950000000037', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000037'),
('208950000000038', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000038'),
('208950000000039', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000039'),
('208950000000040', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000040'),
('208950000000041', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000041'),
('208950000000042', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000042'),
('208950000000043', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000043'),
('208950000000044', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000044'),
('208950000000045', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000045'),
('208950000000046', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000046'),
('208950000000047', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000047'),
('208950000000048', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000048'),
('208950000000049', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000049'),
('208950000000050', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000050'),
('208950000000051', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000051'),
('208950000000052', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000052'),
('208950000000053', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000053'),
('208950000000054', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000054'),
('208950000000055', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000055'),
('208950000000056', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000056'),
('208950000000057', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000057'),
('208950000000058', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000058'),
('208950000000059', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000059'),
('208950000000060', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000060'),
('208950000000061', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000061'),
('208950000000062', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000062'),
('208950000000063', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000063'),
('208950000000064', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000064'),
('208950000000065', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000065'),
('208950000000066', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000066'),
('208950000000067', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000067'),
('208950000000068', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000068'),
('208950000000069', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000069'),
('208950000000070', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000070'),
('208950000000071', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000071'),
('208950000000072', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000072'),
('208950000000073', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000073'),
('208950000000074', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000074'),
('208950000000075', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000075'),
('208950000000076', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000076'),
('208950000000077', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000077'),
('208950000000078', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000078'),
('208950000000079', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000079'),
('208950000000080', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000080'),
('208950000000081', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000081'),
('208950000000082', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000082'),
('208950000000083', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000083'),
('208950000000084', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000084'),
('208950000000085', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000085'),
('208950000000086', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000086'),
('208950000000087', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000087'),
('208950000000088', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000088'),
('208950000000089', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000089'),
('208950000000090', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000090'),
('208950000000091', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000091'),
('208950000000092', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000092'),
('208950000000093', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000093'),
('208950000000094', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000094'),
('208950000000095', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000095'),
('208950000000096', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000096'),
('208950000000097', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000097'),
('208950000000098', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000098'),
('208950000000099', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000099'),
('208950000000100', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000100'),
('208950000000101', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000101'),
('208950000000102', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000102'),
('208950000000103', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000103'),
('208950000000104', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000104'),
('208950000000105', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000105'),
('208950000000106', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000106'),
('208950000000107', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000107'),
('208950000000108', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000108'),
('208950000000109', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000109'),
('208950000000110', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000110'),
('208950000000111', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000111'),
('208950000000112', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000112'),
('208950000000113', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000113'),
('208950000000114', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000114'),
('208950000000115', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000115'),
('208950000000116', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000116'),
('208950000000117', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000117'),
('208950000000118', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000118'),
('208950000000119', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000119'),
('208950000000120', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000120'),
('208950000000121', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000121'),
('208950000000122', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000122'),
('208950000000123', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000123'),
('208950000000124', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000124'),
('208950000000125', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000125'),
('208950000000126', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000126'),
('208950000000127', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000127'),
('208950000000128', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000128'),
('208950000000129', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000129'),
('208950000000130', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000130'),
('208950000000131', '5G_AKA', '0C0A34601D4F07677303652C0462535B', '0C0A34601D4F07677303652C0462535B', '{\"sqn\": \"000000000020\", \"sqnScheme\": \"NON_TIME_BASED\", \"lastIndexes\": {\"ausf\": 0}}', '8000', 'milenage', '63bfa50ee6523365ff14c1f45f88737d', NULL, NULL, NULL, NULL, '208950000000131');-- ----------------------------------------------------------
-- Table structure for table `SdmSubscriptions`
--CREATE TABLE `SdmSubscriptions` (`ueid` varchar(15) NOT NULL,`subsId` int(10) UNSIGNED NOT NULL,`nfInstanceId` varchar(50) NOT NULL,`implicitUnsubscribe` tinyint(1) DEFAULT NULL,`expires` varchar(50) DEFAULT NULL,`callbackReference` varchar(50) NOT NULL,`amfServiceName` json DEFAULT NULL,`monitoredResourceUris` json NOT NULL,`singleNssai` json DEFAULT NULL,`dnn` varchar(50) DEFAULT NULL,`subscriptionId` varchar(50) DEFAULT NULL,`plmnId` json DEFAULT NULL,`immediateReport` tinyint(1) DEFAULT NULL,`report` json DEFAULT NULL,`supportedFeatures` varchar(50) DEFAULT NULL,`contextInfo` json DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------------------------------------
-- Table structure for table `SessionManagementSubscriptionData`
--CREATE TABLE `SessionManagementSubscriptionData` (`ueid` varchar(15) NOT NULL,`servingPlmnid` varchar(15) NOT NULL,`singleNssai` json NOT NULL,`dnnConfigurations` json DEFAULT NULL,`internalGroupIds` json DEFAULT NULL,`sharedVnGroupDataIds` json DEFAULT NULL,`sharedDnnConfigurationsId` varchar(50) DEFAULT NULL,`odbPacketServices` json DEFAULT NULL,`traceData` json DEFAULT NULL,`sharedTraceDataId` varchar(50) DEFAULT NULL,`expectedUeBehavioursList` json DEFAULT NULL,`suggestedPacketNumDlList` json DEFAULT NULL,`3gppChargingCharacteristics` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;--
-- Dumping data for table `SessionManagementSubscriptionData`
--INSERT INTO `SessionManagementSubscriptionData` (`ueid`, `servingPlmnid`, `singleNssai`, `dnnConfigurations`) VALUES
('208950000000031', '20895', '{\"sst\": 222, \"sd\": \"123\"}','{\"default\":{\"pduSessionTypes\":{ \"defaultSessionType\": \"IPV4\"},\"sscModes\": {\"defaultSscMode\": \"SSC_MODE_1\"},\"5gQosProfile\": {\"5qi\": 6,\"arp\":{\"priorityLevel\": 1,\"preemptCap\": \"NOT_PREEMPT\",\"preemptVuln\":\"NOT_PREEMPTABLE\"},\"priorityLevel\":1},\"sessionAmbr\":{\"uplink\":\"100Mbps\", \"downlink\":\"100Mbps\"},\"staticIpAddress\":[{\"ipv4Addr\": \"12.1.1.4\"}]}}');
INSERT INTO `SessionManagementSubscriptionData` (`ueid`, `servingPlmnid`, `singleNssai`, `dnnConfigurations`) VALUES
('208950000000032', '20895', '{\"sst\": 222, \"sd\": \"123\"}','{\"default\":{\"pduSessionTypes\":{ \"defaultSessionType\": \"IPV4\"},\"sscModes\": {\"defaultSscMode\": \"SSC_MODE_1\"},\"5gQosProfile\": {\"5qi\": 6,\"arp\":{\"priorityLevel\": 1,\"preemptCap\": \"NOT_PREEMPT\",\"preemptVuln\":\"NOT_PREEMPTABLE\"},\"priorityLevel\":1},\"sessionAmbr\":{\"uplink\":\"100Mbps\", \"downlink\":\"100Mbps\"}}}');
-- ----------------------------------------------------------
-- Table structure for table `SmfRegistrations`
--CREATE TABLE `SmfRegistrations` (`ueid` varchar(15) NOT NULL,`subpduSessionId` int(10) NOT NULL,`smfInstanceId` varchar(50) NOT NULL,`smfSetId` varchar(50) DEFAULT NULL,`supportedFeatures` varchar(50) DEFAULT NULL,`pduSessionId` int(10) NOT NULL,`singleNssai` json NOT NULL,`dnn` varchar(50) DEFAULT NULL,`emergencyServices` tinyint(1) DEFAULT NULL,`pcscfRestorationCallbackUri` varchar(50) DEFAULT NULL,`plmnId` json NOT NULL,`pgwFqdn` varchar(50) DEFAULT NULL,`epdgInd` tinyint(1) DEFAULT NULL,`deregCallbackUri` varchar(50) DEFAULT NULL,`registrationReason` json DEFAULT NULL,`registrationTime` varchar(50) DEFAULT NULL,`contextInfo` json DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------------------------------------
-- Table structure for table `SmfSelectionSubscriptionData`
--CREATE TABLE `SmfSelectionSubscriptionData` (`ueid` varchar(15) NOT NULL,`servingPlmnid` varchar(15) NOT NULL,`supportedFeatures` varchar(50) DEFAULT NULL,`subscribedSnssaiInfos` json DEFAULT NULL,`sharedSnssaiInfosId` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;--
-- Indexes for dumped tables
----
-- Indexes for table `AccessAndMobilitySubscriptionData`
--
ALTER TABLE `AccessAndMobilitySubscriptionData`ADD PRIMARY KEY (`ueid`,`servingPlmnid`) USING BTREE;--
-- Indexes for table `Amf3GppAccessRegistration`
--
ALTER TABLE `Amf3GppAccessRegistration`ADD PRIMARY KEY (`ueid`);--
-- Indexes for table `AuthenticationStatus`
--
ALTER TABLE `AuthenticationStatus`ADD PRIMARY KEY (`ueid`);--
-- Indexes for table `AuthenticationSubscription`
--
ALTER TABLE `AuthenticationSubscription`ADD PRIMARY KEY (`ueid`);--
-- Indexes for table `SdmSubscriptions`
--
ALTER TABLE `SdmSubscriptions`ADD PRIMARY KEY (`subsId`,`ueid`) USING BTREE;--
-- Indexes for table `SessionManagementSubscriptionData`
--
ALTER TABLE `SessionManagementSubscriptionData`ADD PRIMARY KEY (`ueid`,`servingPlmnid`) USING BTREE;--
-- Indexes for table `SmfRegistrations`
--
ALTER TABLE `SmfRegistrations`ADD PRIMARY KEY (`ueid`,`subpduSessionId`) USING BTREE;--
-- Indexes for table `SmfSelectionSubscriptionData`
--
ALTER TABLE `SmfSelectionSubscriptionData`ADD PRIMARY KEY (`ueid`,`servingPlmnid`) USING BTREE;--
-- AUTO_INCREMENT for dumped tables
----
-- AUTO_INCREMENT for table `SdmSubscriptions`
--
ALTER TABLE `SdmSubscriptions`MODIFY `subsId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;更多推荐
基于Docker的UERANSIM多基站接入5GCN
发布评论