SQLite format 3@  .c   O^ +!indexidx_subscr_imsisubscriber CREATE UNIQUE INDEX idx_subscr_imsi ON subscriber (imsi) Mtableindind CREATE TABLE ind ( -- 3G auth IND pool to be used for this VLR ind INTEGER PRIMARY KEY, -- VLR identification, usually the GSUP source_name vlr TEXT NOT NULL, UNIQUE (vlr) )% 9indexsqlite_autoindex_ind_1ind ktableauc_3gauc_3gCREATE TABLE auc_3g ( subscriber_id INTEGER PRIMARY KEY, -- subscriber.id algo_id_3g INTEGER NOT NULL, -- enum osmo_auth_algo value k VARCHAR(64) NOT NULL, -- hex string: subscriber's secret key (128/256bit) op VARCHAR(64), -- hex string: operator's secret key (128/256bit) opc VARCHAR(64), -- hex string: derived from OP and K (128/256bit) sqn INTEGER NOT NULL DEFAULT 0, -- sequence number of key usage -- nr of index bits at lower SQN end ind_bitlen INTEGER NOT NULL DEFAULT 5 )j/tableauc_2gauc_2gCREATE TABLE auc_2g ( subscriber_id INTEGER PRIMARY KEY, -- subscriber.id algo_id_2g INTEGER NOT NULL, -- enum osmo_auth_algo value ki VARCHAR(32) NOT NULL -- hex string: subscriber's secret key (128bit) )<;;tablesubscriber_multi_msisdnsubscriber_multi_msisdnCREATE TABLE subscriber_multi_msisdn ( -- Chapter 2.1.3 subscriber_id INTEGER, -- subscriber.id msisdn VARCHAR(15) NOT NULL )))Wtablesubscriber_apnsubscriber_apnCREATE TABLE subscriber_apn ( subscriber_id INTEGER, -- subscriber.id apn VARCHAR(256) NOT NULL )<!!CtablesubscribersubscriberCREATE TABLE subscriber ( -- OsmoHLR's DB scheme is modelled roughly after TS 23.008 version 13.3.0 id INTEGER PRIMARY KEY, -- Chapter 2.1.1.1 imsi VARCHAR(15) UNIQUE NOT NULL, -- Chapter 2.1.2 msisdn VARCHAR(15) UNIQUE, -- Chapter 2.2.3: Most recent / current IMEISV imeisv VARCHAR, -- Chapter 2.1.9: Most recent / current IMEI imei VARCHAR(14), -- Chapter 2.4.5 vlr_number VARCHAR(15), -- Chapter 2.4.6 msc_number VARCHAR(15), -- Chapter 2.4.8.1 sgsn_number VARCHAR(15), -- Chapter 2.13.10 sgsn_address VARCHAR, -- Chapter 2.4.8.2 ggsn_number VARCHAR(15), -- Chapter 2.4.9.2 gmlc_number VARCHAR(15), -- Chapter 2.4.23 smsc_number VARCHAR(15), -- Chapter 2.4.24 periodic_lu_tmr INTEGER, -- Chapter 2.13.115 periodic_rau_tau_tmr INTEGER, -- Chapter 2.1.1.2: network access mode nam_cs BOOLEAN NOT NULL DEFAULT 1, nam_ps BOOLEAN NOT NULL DEFAULT 1, -- Chapter 2.1.8 lmsi INTEGER, -- The below purged flags might not even be stored non-volatile, -- refer to TS 23.012 Chapter 3.6.1.4 -- Chapter 2.7.5 ms_purged_cs BOOLEAN NOT NULL DEFAULT 0, -- Chapter 2.7.6 ms_purged_ps BOOLEAN NOT NULL DEFAULT 0, -- Timestamp of last location update seen from subscriber -- The value is a string which encodes a UTC timestamp in granularity of seconds. last_lu_seen TIMESTAMP default NULL, last_lu_seen_ps TIMESTAMP default NULL, -- When a LU was received via a proxy, that proxy's hlr_number is stored here, -- while vlr_number reflects the MSC on the far side of that proxy. vlr_via_proxy VARCHAR, sgsn_via_proxy VARCHAR )3G!indexsqlite_autoindex_subscriber_2subscriber3G!indexsqlite_autoindex_subscriber_1subscriber  I J 9 uu  9 )q M 1 A - Q E    U }% 5 ]I y e M 9 Y!a = a m i   +262426625907956J+262426214051498I+262428012873958H+262420022093889G+262421811772839F+262421655135870E+262421263325401D+262424308115464C+262429263894361B+262428657834901A+262429683066942@+262421160910224?+262421678935035>+262427758107786=+262422644137652<+262425928645574;+262425202253830:+2624225913773069+2624214009852448+2624294162231887+2624228881003776+2624263999132375+2624278655158714+2624236870199153+2624298577203122+2624226054108011+2624223399436810+262423951928325/+262429141903935.+262424129809000-+262423423702696,+262424375834561++262423359934591*+262428588004537)+262429502072004(+262424913161744'+262422624664943&+262421985736164%+262422208369627$+262422836719697#+262426985176152"+262428730240254!+262421584165329 +262424912063345+262423162130238+262424780098494+262425082894473+262429482305385+262425120459375+262423666380183+262427166619121+262424414845330+262425011653684+262424927983740+262421689914040+262427781967993+262429684925650+262422539739494+262428114513505+262425315949425+262429946716551+262429410097209 +262423252999797 +262424225541986 +262421485483360 +262421990351278 +262427207279667+262420478263216+262425912499940+262427525953207+262422776987510+262423502100715+262429210067755+ 262420118465213 J 5$ Y I% | z h Z }  Wy & 8 ' F H   k {6  (   J  li G 7 [X  9 j011J%491615756240I%491618232446H%491616234032G%491617652132F%491616336484E%491612443557D%491618488145C%491614037424B%491618780846A%491616245288@%491616524017?%491612737148>%491616048233=%491616158163<%491612660614;%491613527142:%4916134211209%4916108481038%4916124164867%4916152618666%4916113331435%4916150851324%4916105551853%4916167468752%4916175280571%4916147605370%491615066404/%491614164767.%491615751213-%491618087788,%491613320832+%491617236087*%491614645385)%491610537721(%491618838265'%491615478548&%491614815027%%491614320365$%491616168880#%491617124602"%491613750718!%491611818568 %491611707524%491618372606%491618433613%491611232741%491615513110%491616665073%491617656584%491616401366%491611807284%491615078565%491618487430%491618321587%491614681648%491616216361%491612857382%491613265403%491612381523%491614847055%491610373118 %491610164075 %491614440007 %491613185768 %491612147555 %491613306280%491617680018%491613043788%491612046813%491611013803%491616215856%491613068542% 491616271820   7f@~X1 p I " a :  y R ,  j D  \ 5 tM&'%IM000102030405060708090A0B0C0D0E0F%HM000102030405060708090A0B0C0D0E0F$G M000102030405060708090A0B0C0D0E0F%DM000102030405060708090A0B0C0D0E0F%CM000102030405060708090A0B0C0D0E0F$B M000102030405060708090A0B0C0D0E0F%AM000102030405060708090A0B0C0D0E0F%@M000102030405060708090A0B0C0D0E0F$? M000102030405060708090A0B0C0D0E0F%<M000102030405060708090A0B0C0D0E0F%;M000102030405060708090A0B0C0D0E0F$: M000102030405060708090A0B0C0D0E0F%9M000102030405060708090A0B0C0D0E0F%8M000102030405060708090A0B0C0D0E0F$7 M000102030405060708090A0B0C0D0E0F%4M000102030405060708090A0B0C0D0E0F%3M000102030405060708090A0B0C0D0E0F$2 M000102030405060708090A0B0C0D0E0F%1M000102030405060708090A0B0C0D0E0F%0M000102030405060708090A0B0C0D0E0F$/ M000102030405060708090A0B0C0D0E0F%,M000102030405060708090A0B0C0D0E0F%+M000102030405060708090A0B0C0D0E0F$* M000102030405060708090A0B0C0D0E0F%)M000102030405060708090A0B0C0D0E0F%(M000102030405060708090A0B0C0D0E0F$' M000102030405060708090A0B0C0D0E0F%$M000102030405060708090A0B0C0D0E0F%#M000102030405060708090A0B0C0D0E0F$" M000102030405060708090A0B0C0D0E0F%!M000102030405060708090A0B0C0D0E0F% M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F% M000102030405060708090A0B0C0D0E0F% M000102030405060708090A0B0C0D0E0F$  M000102030405060708090A0B0C0D0E0F% M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F%M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F$ M000102030405060708090A0B0C0D0E0F -h8 T  p $ @ \  x ,Hd4Pl <XLJIMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJHMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJGMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJFMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJEMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJAMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ@MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ?MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ>MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ=MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ9MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ8MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ7MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ6MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ5MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ1MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ0MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ/MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ.MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ-MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ)MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ(MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ'MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ&MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ%MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ!MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2F 7MSC-00-00-00-00-00-00 7 MSC-00-00-00-00-00-00 J 9 uu  9 )q M 1 A - Q E    U }% 5 ]I y e M 9 Y!a = a m i   +262426625907956J+262426214051498I+262428012873958H+262420022093889G+262421811772839F+262421655135870E+262421263325401D+262424308115464C+262429263894361B+262428657834901A+262429683066942@+262421160910224?+262421678935035>+262427758107786=+262422644137652<+262425928645574;+262425202253830:+2624225913773069+2624214009852448+2624294162231887+2624228881003776+2624263999132375+2624278655158714+2624236870199153+2624298577203122+2624226054108011+2624223399436810+262423951928325/+262429141903935.+262424129809000-+262423423702696,+262424375834561++262423359934591*+262428588004537)+262429502072004(+262424913161744'+262422624664943&+262421985736164%+262422208369627$+262422836719697#+262426985176152"+262428730240254!+262421584165329 +262424912063345+262423162130238+262424780098494+262425082894473+262429482305385+262425120459375+262423666380183+262427166619121+262424414845330+262425011653684+262424927983740+262421689914040+262427781967993+262429684925650+262422539739494+262428114513505+262425315949425+262429946716551+262429410097209 +262423252999797 +262424225541986 +262421485483360 +262421990351278 +262427207279667+262420478263216+262425912499940+262427525953207+262422776987510+262423502100715+262429210067755+ 262420118465213 8J+) 26242662590795601112345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624262140514984916157562403H+% 2624280128739584916182324463G+% 2624200220938894916162340323F+% 2624218117728394916176521323E+% 2624216551358704916163364843D+% 2624212633254014916124435573C+% 2624243081154644916184881453B+% 2624292638943614916140374243A+% 2624286578349014916187808463@+% 2624296830669424916162452883?+% 2624211609102244916165240173>+% 2624216789350354916127371483=+% 2624277581077864916160482333<+% 2624226441376524916161581633;+% 2624259286455744916126606143:+% 26242520225383049161352714239+% 26242259137730649161342112038+% 26242140098524449161084810337+% 26242941622318849161241648636+% 26242288810037749161526186635+% 26242639991323749161133314334+% 26242786551587149161508513233+% 26242368701991549161055518532+% 26242985772031249161674687531+% 26242260541080149161752805730+% 2624223399436814916147605373/+% 2624239519283254916150664043.+% 2624291419039354916141647673-+% 2624241298090004916157512133,+% 2624234237026964916180877883++% 2624243758345614916133208323*+% 2624233599345914916172360873)+% 2624285880045374916146453853(+% 2624295020720044916105377213'+% 2624249131617444916188382653&+% 2624226246649434916154785483%+% 2624219857361644916148150273$+% 2624222083696274916143203653#+% 2624228367196974916161688803"+% 2624269851761524916171246023!+% 2624287302402544916137507183 +% 2624215841653294916118185683+% 2624249120633454916117075243+% 2624231621302384916183726063+% 2624247800984944916184336133+% 2624250828944734916112327413+% 2624294823053854916155131103+% 2624251204593754916166650733+% 2624236663801834916176565843+% 2624271666191214916164013663+% 2624244148453304916118072843+% 2624250116536844916150785653+% 2624249279837404916184874303+% 2624216899140404916183215873+% 2624277819679934916146816483+% 2624296849256504916162163613+% 2624225397394944916128573823+% 2624281145135054916132654033+% 2624253159494254916123815233+% 2624299467165514916148470553 +% 2624294100972094916103731183 +% 2624232529997974916101640753 +% 2624242255419864916144400073 +% 2624214854833604916131857683 +% 2624219903512784916121475553+% 2624272072796674916133062803+% 2624204782632164916176800183+% 2624259124999404916130437883+% 2624275259532074916120468133+% 2624227769875104916110138033+% 2624235021007154916162158563+% 262429210067755491613068542[+%7 3262420118465213491616271820MSC-00-00-00-00-00-002024-11-02 12:25:59