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 a  U%   u -! } 5  ) 1 Mu Y I q  E  e y M9 a  A ] 9 i  m =  Q+262428538538246J+262427053099097I+262420055460935H+262421888262714G+262420594994845F+262423079248883E+262426718085038D+262428365034963C+262428037863003B+262429034474256A+262429477005940@+262426459003581?+262424880511617>+262429283898042=+262429844540968<+262427017773439;+262427024569191:+2624222380342349+2624213306912268+2624254432613537+2624218081820236+2624214996713545+2624278386313264+2624280337542163+2624269803405682+2624222653879371+2624280482038330+262420163689129/+262428626903005.+262422844031517-+262425926767962,+262421797397807++262427594304137*+262427741888035)+262420933602636(+262421212028320'+262429751744529&+262420082892091%+262424912250584$+262426730409642#+262425305112570"+262429135020654!+262424387591918 +262428896775468+262421007423879+262425126222024+262425483119200+262428113495037+262426823975683+262422026385828+262422823119729+262424023374491+262425709576725+262428151563303+262425975834951+262422552261793+262427529303870+262424466350972+262429074811166+262421144014943+262426700986983+262426812195758 +262425601210925 +262420289078054 +262427152767988 +262425231477046 +262427699658784+262425276982555+262425512144646+262421597044245+262421027291439+262429407867454+262422774073551+ 262428333484206 J $ Hy  z  { ' l  6 I &i% 8  Z kX 7 F  ( J } j  Gh 9 [ Y 5 |   W333J%491614385102I%491615374572H%491614460440G%491615507081F%491611858182E%491614500361D%491616205415C%491615074346B%491610415834A%491614230385@%491616415566?%491614577066>%491612442566=%491618042376<%491614153540;%491611453354:%4916132424879%4916128883208%4916136203417%4916138661886%4916174288825%4916153086454%4916158677373%4916102830342%4916125053831%4916126451110%491612255840/%491618054080.%491617471625-%491613606550,%491613054206+%491614133427*%491610070173)%491615883866(%491614560383'%491611433803&%491617373084%%491610611868$%491615023753#%491611200636"%491613463111!%491612026150 %491618356382%491610765574%491616605335%491613184317%491612516361%491615056038%491614000216%491613102768%491610887328%491612304253%491616754728%491610816350%491615748340%491615630470%491610444083%491613010640%491618801102%491612557580%491610068274 %491617306568 %491614227210 %491618487008 %491615067804 %491610083001%491614651782%491613300634%491613870331%491615632006%491614241731%491611226558% 491612434800   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 a  U%   u -! } 5  ) 1 Mu Y I q  E  e y M9 a  A ] 9 i  m =  Q+262428538538246J+262427053099097I+262420055460935H+262421888262714G+262420594994845F+262423079248883E+262426718085038D+262428365034963C+262428037863003B+262429034474256A+262429477005940@+262426459003581?+262424880511617>+262429283898042=+262429844540968<+262427017773439;+262427024569191:+2624222380342349+2624213306912268+2624254432613537+2624218081820236+2624214996713545+2624278386313264+2624280337542163+2624269803405682+2624222653879371+2624280482038330+262420163689129/+262428626903005.+262422844031517-+262425926767962,+262421797397807++262427594304137*+262427741888035)+262420933602636(+262421212028320'+262429751744529&+262420082892091%+262424912250584$+262426730409642#+262425305112570"+262429135020654!+262424387591918 +262428896775468+262421007423879+262425126222024+262425483119200+262428113495037+262426823975683+262422026385828+262422823119729+262424023374491+262425709576725+262428151563303+262425975834951+262422552261793+262427529303870+262424466350972+262429074811166+262421144014943+262426700986983+262426812195758 +262425601210925 +262420289078054 +262427152767988 +262425231477046 +262427699658784+262425276982555+262425512144646+262421597044245+262421027291439+262429407867454+262422774073551+ 262428333484206 8J+) 26242853853824633312345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624270530990974916143851023H+% 2624200554609354916153745723G+% 2624218882627144916144604403F+% 2624205949948454916155070813E+% 2624230792488834916118581823D+% 2624267180850384916145003613C+% 2624283650349634916162054153B+% 2624280378630034916150743463A+% 2624290344742564916104158343@+% 2624294770059404916142303853?+% 2624264590035814916164155663>+% 2624248805116174916145770663=+% 2624292838980424916124425663<+% 2624298445409684916180423763;+% 2624270177734394916141535403:+% 26242702456919149161145335439+% 26242223803423449161324248738+% 26242133069122649161288832037+% 26242544326135349161362034136+% 26242180818202349161386618835+% 26242149967135449161742888234+% 26242783863132649161530864533+% 26242803375421649161586773732+% 26242698034056849161028303431+% 26242226538793749161250538330+% 2624280482038334916126451113/+% 2624201636891294916122558403.+% 2624286269030054916180540803-+% 2624228440315174916174716253,+% 2624259267679624916136065503++% 2624217973978074916130542063*+% 2624275943041374916141334273)+% 2624277418880354916100701733(+% 2624209336026364916158838663'+% 2624212120283204916145603833&+% 2624297517445294916114338033%+% 2624200828920914916173730843$+% 2624249122505844916106118683#+% 2624267304096424916150237533"+% 2624253051125704916112006363!+% 2624291350206544916134631113 +% 2624243875919184916120261503+% 2624288967754684916183563823+% 2624210074238794916107655743+% 2624251262220244916166053353+% 2624254831192004916131843173+% 2624281134950374916125163613+% 2624268239756834916150560383+% 2624220263858284916140002163+% 2624228231197294916131027683+% 2624240233744914916108873283+% 2624257095767254916123042533+% 2624281515633034916167547283+% 2624259758349514916108163503+% 2624225522617934916157483403+% 2624275293038704916156304703+% 2624244663509724916104440833+% 2624290748111664916130106403+% 2624211440149434916188011023+% 2624267009869834916125575803 +% 2624268121957584916100682743 +% 2624256012109254916173065683 +% 2624202890780544916142272103 +% 2624271527679884916184870083 +% 2624252314770464916150678043+% 2624276996587844916100830013+% 2624252769825554916146517823+% 2624255121446464916133006343+% 2624215970442454916138703313+% 2624210272914394916156320063+% 2624294078674544916142417313+% 262422774073551491611226558[+%7 3262428333484206491612434800MSC-00-00-00-00-00-002024-09-27 08:25:58