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   } q Q =a i Y ) 9  1  -  ]M m a u!5 AI  9 U E M  %  e y  u+262422836599311J+262426928305550I+262424782228140H+262424886009632G+262427095243860F+262426619753139E+262428237956706D+262427053929805C+262426619987053B+262420735429671A+262422853969758@+262420477090575?+262422367306428>+262421810949384=+262421622853719<+262429090084117;+262429491148291:+2624279014113059+2624267082441158+2624213977328387+2624243033706666+2624257710144095+2624286135996304+2624252663710723+2624274182899172+2624236494919151+2624250411672510+262425914214065/+262422194319938.+262420640421170-+262428688987979,+262426153983685++262424249391478*+262429884256982)+262426905857699(+262429606290585'+262420650236213&+262423072839186%+262422980294148$+262425933933874#+262422284981313"+262424504693153!+262428139255492 +262425686841358+262423332387722+262429297252286+262424407969344+262422444826164+262420043915441+262423884026307+262424913163121+262424918714263+262425056903703+262424351042361+262421540796667+262425614641732+262422127969220+262429685032493+262427628421753+262424865555681+262429824049413+262423969699947 +262429277338005 +262427565336240 +262425744582832 +262424380058462 +262421952487500+262429889123681+262428815734110+262427061296662+262429500381523+262422091677257+262420106686845+ 262423782030231 J  &i 8 F IG 9  } j h Y J yz $ H ' 6X   [ l | k5 7  { Z %  (W 813J%491618558050I%491611470474H%491612756336G%491616150018F%491616547411E%491611814638D%491612206628C%491612817233B%491612730003A%491618745602@%491610444140?%491611455543>%491618301201=%491616050430<%491611623440;%491614484864:%4916103850749%4916111467488%4916177012227%4916170432836%4916166327305%4916125243844%4916136367543%4916107413122%4916116785241%4916124385410%491616101886/%491615868787.%491612538501-%491618337837,%491610215031+%491617303607*%491614442140)%491612630280(%491612042506'%491617684178&%491614537811%%491612453060$%491612731611#%491614713425"%491617673366!%491617308805 %491615433541%491616355610%491618721610%491618323766%491614762775%491611240661%491615028068%491610383067%491613561616%491613801671%491610176214%491614721214%491617358308%491612184815%491613468535%491614043085%491617404623%491618083608%491614130168 %491617163572 %491610883521 %491618666703 %491612627604 %491613347746%491618350401%491613381708%491614437327%491615736538%491617717220%491618446248% 491610168677   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   } q Q =a i Y ) 9  1  -  ]M m a u!5 AI  9 U E M  %  e y  u+262422836599311J+262426928305550I+262424782228140H+262424886009632G+262427095243860F+262426619753139E+262428237956706D+262427053929805C+262426619987053B+262420735429671A+262422853969758@+262420477090575?+262422367306428>+262421810949384=+262421622853719<+262429090084117;+262429491148291:+2624279014113059+2624267082441158+2624213977328387+2624243033706666+2624257710144095+2624286135996304+2624252663710723+2624274182899172+2624236494919151+2624250411672510+262425914214065/+262422194319938.+262420640421170-+262428688987979,+262426153983685++262424249391478*+262429884256982)+262426905857699(+262429606290585'+262420650236213&+262423072839186%+262422980294148$+262425933933874#+262422284981313"+262424504693153!+262428139255492 +262425686841358+262423332387722+262429297252286+262424407969344+262422444826164+262420043915441+262423884026307+262424913163121+262424918714263+262425056903703+262424351042361+262421540796667+262425614641732+262422127969220+262429685032493+262427628421753+262424865555681+262429824049413+262423969699947 +262429277338005 +262427565336240 +262425744582832 +262424380058462 +262421952487500+262429889123681+262428815734110+262427061296662+262429500381523+262422091677257+262420106686845+ 262423782030231 8J+) 26242283659931181312345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624269283055504916185580503H+% 2624247822281404916114704743G+% 2624248860096324916127563363F+% 2624270952438604916161500183E+% 2624266197531394916165474113D+% 2624282379567064916118146383C+% 2624270539298054916122066283B+% 2624266199870534916128172333A+% 2624207354296714916127300033@+% 2624228539697584916187456023?+% 2624204770905754916104441403>+% 2624223673064284916114555433=+% 2624218109493844916183012013<+% 2624216228537194916160504303;+% 2624290900841174916116234403:+% 26242949114829149161448486439+% 26242790141130549161038507438+% 26242670824411549161114674837+% 26242139773283849161770122236+% 26242430337066649161704328335+% 26242577101440949161663273034+% 26242861359963049161252438433+% 26242526637107249161363675432+% 26242741828991749161074131231+% 26242364949191549161167852430+% 2624250411672514916124385413/+% 2624259142140654916161018863.+% 2624221943199384916158687873-+% 2624206404211704916125385013,+% 2624286889879794916183378373++% 2624261539836854916102150313*+% 2624242493914784916173036073)+% 2624298842569824916144421403(+% 2624269058576994916126302803'+% 2624296062905854916120425063&+% 2624206502362134916176841783%+% 2624230728391864916145378113$+% 2624229802941484916124530603#+% 2624259339338744916127316113"+% 2624222849813134916147134253!+% 2624245046931534916176733663 +% 2624281392554924916173088053+% 2624256868413584916154335413+% 2624233323877224916163556103+% 2624292972522864916187216103+% 2624244079693444916183237663+% 2624224448261644916147627753+% 2624200439154414916112406613+% 2624238840263074916150280683+% 2624249131631214916103830673+% 2624249187142634916135616163+% 2624250569037034916138016713+% 2624243510423614916101762143+% 2624215407966674916147212143+% 2624256146417324916173583083+% 2624221279692204916121848153+% 2624296850324934916134685353+% 2624276284217534916140430853+% 2624248655556814916174046233+% 2624298240494134916180836083 +% 2624239696999474916141301683 +% 2624292773380054916171635723 +% 2624275653362404916108835213 +% 2624257445828324916186667033 +% 2624243800584624916126276043+% 2624219524875004916133477463+% 2624298891236814916183504013+% 2624288157341104916133817083+% 2624270612966624916144373273+% 2624295003815234916157365383+% 2624220916772574916177172203+% 262420106686845491618446248[+%7 3262423782030231491610168677MSC-00-00-00-00-00-002024-06-25 08:26:41