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 ) m Y! 9I  M }% Mu A y - i =    U  ] 5 e E 1  q u  a Q9 +262421437427547J+262421462080538I+262428686805396H+262428154892185G+262423579478880F+262422135276128E+262427813245862D+262428607699680C+262425508834877B+262425790209069A+262421459166270@+262426882172057?+262421024294568>+262424229352920=+262429425268690<+262426278944462;+262422892320759:+2624205499458399+2624253044415838+2624228700366867+2624250963332026+2624254794700245+2624212421058644+2624284832355643+2624260031832692+2624231018250651+2624223389400820+262425928944640/+262424128777105.+262422062533858-+262425163337458,+262426051810618++262426464777866*+262422954554303)+262429681928609(+262428599895010'+262420158503008&+262424919661138%+262426810561649$+262426296538169#+262421323751318"+262421073211153!+262422857519493 +262426497687013+262425159268962+262426460932596+262427686290838+262426182085638+262425649511381+262425610141124+262421342997849+262426231841324+262421454836041+262426092995629+262427847555829+262425911726710+262428060838726+262424288980711+262428516100189+262421337117444+262420404464636+262427419424352 +262426819928527 +262422133991188 +262429680186276 +262422160831088 +262420653592796+262422235083779+262425075856571+262428457421293+262422606227824+262424841195947+262420104270322+ 262420523339923 J  {i HFX z y '     [   8 J5  W j & % | } $ 7 l G k I h ( 96 Y Z066J%491618322015I%491618466723H%491614387432G%491613242887F%491617332505E%491616564070D%491612863204C%491616242754B%491612685556A%491611238788@%491613414155?%491615482218>%491611451315=%491614788022<%491617363523;%491611821183:%4916141400269%4916177714458%4916187738757%4916177567316%4916158387465%4916170524354%4916131362013%4916153240852%4916178175351%4916167808650%491614840584/%491616302784.%491615753154-%491617067627,%491615463678+%491617206481*%491610786103)%491618766221(%491615237411'%491610514306&%491612020771%%491613688151$%491612576171#%491616460025"%491610023735!%491611847347 %491614338502%491614848378%491610233044%491615788736%491618507747%491617407472%491611081612%491610704867%491611436000%491613456764%491617340105%491611357426%491612860637%491614886562%491614003247%491612437010%491613132372%491611834056%491617187375 %491614784163 %491610811243 %491615114667 %491618073045 %491611505325%491614656677%491614476347%491617620221%491610033042%491617108103%491612604082% 491618444845   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 ) m Y! 9I  M }% Mu A y - i =    U  ] 5 e E 1  q u  a Q9 +262421437427547J+262421462080538I+262428686805396H+262428154892185G+262423579478880F+262422135276128E+262427813245862D+262428607699680C+262425508834877B+262425790209069A+262421459166270@+262426882172057?+262421024294568>+262424229352920=+262429425268690<+262426278944462;+262422892320759:+2624205499458399+2624253044415838+2624228700366867+2624250963332026+2624254794700245+2624212421058644+2624284832355643+2624260031832692+2624231018250651+2624223389400820+262425928944640/+262424128777105.+262422062533858-+262425163337458,+262426051810618++262426464777866*+262422954554303)+262429681928609(+262428599895010'+262420158503008&+262424919661138%+262426810561649$+262426296538169#+262421323751318"+262421073211153!+262422857519493 +262426497687013+262425159268962+262426460932596+262427686290838+262426182085638+262425649511381+262425610141124+262421342997849+262426231841324+262421454836041+262426092995629+262427847555829+262425911726710+262428060838726+262424288980711+262428516100189+262421337117444+262420404464636+262427419424352 +262426819928527 +262422133991188 +262429680186276 +262422160831088 +262420653592796+262422235083779+262425075856571+262428457421293+262422606227824+262424841195947+262420104270322+ 262420523339923 8J+) 26242143742754706612345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624214620805384916183220153H+% 2624286868053964916184667233G+% 2624281548921854916143874323F+% 2624235794788804916132428873E+% 2624221352761284916173325053D+% 2624278132458624916165640703C+% 2624286076996804916128632043B+% 2624255088348774916162427543A+% 2624257902090694916126855563@+% 2624214591662704916112387883?+% 2624268821720574916134141553>+% 2624210242945684916154822183=+% 2624242293529204916114513153<+% 2624294252686904916147880223;+% 2624262789444624916173635233:+% 26242289232075949161182118339+% 26242054994583949161414002638+% 26242530444158349161777144537+% 26242287003668649161877387536+% 26242509633320249161775673135+% 26242547947002449161583874634+% 26242124210586449161705243533+% 26242848323556449161313620132+% 26242600318326949161532408531+% 26242310182506549161781753530+% 2624223389400824916167808653/+% 2624259289446404916148405843.+% 2624241287771054916163027843-+% 2624220625338584916157531543,+% 2624251633374584916170676273++% 2624260518106184916154636783*+% 2624264647778664916172064813)+% 2624229545543034916107861033(+% 2624296819286094916187662213'+% 2624285998950104916152374113&+% 2624201585030084916105143063%+% 2624249196611384916120207713$+% 2624268105616494916136881513#+% 2624262965381694916125761713"+% 2624213237513184916164600253!+% 2624210732111534916100237353 +% 2624228575194934916118473473+% 2624264976870134916143385023+% 2624251592689624916148483783+% 2624264609325964916102330443+% 2624276862908384916157887363+% 2624261820856384916185077473+% 2624256495113814916174074723+% 2624256101411244916110816123+% 2624213429978494916107048673+% 2624262318413244916114360003+% 2624214548360414916134567643+% 2624260929956294916173401053+% 2624278475558294916113574263+% 2624259117267104916128606373+% 2624280608387264916148865623+% 2624242889807114916140032473+% 2624285161001894916124370103+% 2624213371174444916131323723+% 2624204044646364916118340563 +% 2624274194243524916171873753 +% 2624268199285274916147841633 +% 2624221339911884916108112433 +% 2624296801862764916151146673 +% 2624221608310884916180730453+% 2624206535927964916115053253+% 2624222350837794916146566773+% 2624250758565714916144763473+% 2624284574212934916176202213+% 2624226062278244916100330423+% 2624248411959474916171081033+% 262420104270322491612604082[+%7 3262420523339923491618444845MSC-00-00-00-00-00-002024-10-11 08:25:59