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! 9 y  1 I ]a%   a Y  Q  }u i = m )  U A  E M M u 9  - e5q+262420078794990J+262426502992657I+262423138051782H+262427590419214G+262422819615560F+262422368681334E+262424961564145D+262423717926764C+262420285881335B+262426737790544A+262425082232546@+262423109979129?+262424815513245>+262424491512051=+262423745444483<+262429090795797;+262420227010759:+2624263096274929+2624245712062328+2624284805490357+2624246877919536+2624249589434435+2624225535134994+2624209305886563+2624202817423992+2624287515031351+2624253929091790+262425194684265/+262424391806536.+262424266009532-+262428102544232,+262426383561755++262420132499759*+262425105753616)+262420396887344(+262424607115624'+262426735243531&+262428454671179%+262420312150201$+262425828589287#+262423449801736"+262424786785669!+262420357118208 +262423967079334+262425603803367+262426022301793+262420357778791+262425994848756+262425108123565+262424186473893+262420043778533+262429360031700+262420810466037+262421214479419+262429798050102+262421697246052+262423744664254+262425786525572+262428872136291+262422411079530+262420021218158+262420785827115 +262425862084056 +262422335960440 +262428168397201 +262426800339512 +262421253111698+262424276340922+262425798429582+262423529679837+262426509078923+262424490374715+262420742804288+ 262424425119859 J  8z J   Y  7 | % {W Z ( }  9 j H  Fy k i &hX [ '$ 65 l G  I380J%491613234535I%491613652373H%491611201280G%491615567636F%491617561456E%491613302175D%491615828015C%491610215476B%491616661828A%491611775822@%491613182024?%491614233487>%491617322126=%491614730435<%491612337228;%491615856820:%4916106554539%4916188625268%4916130484407%4916146723046%4916126181335%4916122172664%4916121870183%4916138048872%4916181162521%4916185445030%491611283856/%491612680270.%491611220044-%491616247620,%491615050728+%491612351071*%491613763817)%491612087785(%491613678874'%491612753441&%491613312062%%491611864048$%491614487436#%491618686571"%491618137458!%491612126753 %491613231835%491613265044%491618832845%491612681105%491616344263%491618428363%491615406884%491614888852%491610707864%491610774670%491613564137%491618286808%491610271156%491616602565%491616004078%491615725148%491615224150%491614821102%491616186623 %491616463532 %491614503411 %491612847247 %491615227881 %491614585855%491610513464%491617731245%491613866564%491613267014%491617580041%491611763413% 491616576508   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! 9 y  1 I ]a%   a Y  Q  }u i = m )  U A  E M M u 9  - e5q+262420078794990J+262426502992657I+262423138051782H+262427590419214G+262422819615560F+262422368681334E+262424961564145D+262423717926764C+262420285881335B+262426737790544A+262425082232546@+262423109979129?+262424815513245>+262424491512051=+262423745444483<+262429090795797;+262420227010759:+2624263096274929+2624245712062328+2624284805490357+2624246877919536+2624249589434435+2624225535134994+2624209305886563+2624202817423992+2624287515031351+2624253929091790+262425194684265/+262424391806536.+262424266009532-+262428102544232,+262426383561755++262420132499759*+262425105753616)+262420396887344(+262424607115624'+262426735243531&+262428454671179%+262420312150201$+262425828589287#+262423449801736"+262424786785669!+262420357118208 +262423967079334+262425603803367+262426022301793+262420357778791+262425994848756+262425108123565+262424186473893+262420043778533+262429360031700+262420810466037+262421214479419+262429798050102+262421697246052+262423744664254+262425786525572+262428872136291+262422411079530+262420021218158+262420785827115 +262425862084056 +262422335960440 +262428168397201 +262426800339512 +262421253111698+262424276340922+262425798429582+262423529679837+262426509078923+262424490374715+262420742804288+ 262424425119859 8J+) 26242007879499038012345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624265029926574916132345353H+% 2624231380517824916136523733G+% 2624275904192144916112012803F+% 2624228196155604916155676363E+% 2624223686813344916175614563D+% 2624249615641454916133021753C+% 2624237179267644916158280153B+% 2624202858813354916102154763A+% 2624267377905444916166618283@+% 2624250822325464916117758223?+% 2624231099791294916131820243>+% 2624248155132454916142334873=+% 2624244915120514916173221263<+% 2624237454444834916147304353;+% 2624290907957974916123372283:+% 26242022701075949161585682039+% 26242630962749249161065545338+% 26242457120623249161886252637+% 26242848054903549161304844036+% 26242468779195349161467230435+% 26242495894344349161261813334+% 26242255351349949161221726633+% 26242093058865649161218701832+% 26242028174239949161380488731+% 26242875150313549161811625230+% 2624253929091794916185445033/+% 2624251946842654916112838563.+% 2624243918065364916126802703-+% 2624242660095324916112200443,+% 2624281025442324916162476203++% 2624263835617554916150507283*+% 2624201324997594916123510713)+% 2624251057536164916137638173(+% 2624203968873444916120877853'+% 2624246071156244916136788743&+% 2624267352435314916127534413%+% 2624284546711794916133120623$+% 2624203121502014916118640483#+% 2624258285892874916144874363"+% 2624234498017364916186865713!+% 2624247867856694916181374583 +% 2624203571182084916121267533+% 2624239670793344916132318353+% 2624256038033674916132650443+% 2624260223017934916188328453+% 2624203577787914916126811053+% 2624259948487564916163442633+% 2624251081235654916184283633+% 2624241864738934916154068843+% 2624200437785334916148888523+% 2624293600317004916107078643+% 2624208104660374916107746703+% 2624212144794194916135641373+% 2624297980501024916182868083+% 2624216972460524916102711563+% 2624237446642544916166025653+% 2624257865255724916160040783+% 2624288721362914916157251483+% 2624224110795304916152241503+% 2624200212181584916148211023 +% 2624207858271154916161866233 +% 2624258620840564916164635323 +% 2624223359604404916145034113 +% 2624281683972014916128472473 +% 2624268003395124916152278813+% 2624212531116984916145858553+% 2624242763409224916105134643+% 2624257984295824916177312453+% 2624235296798374916138665643+% 2624265090789234916132670143+% 2624244903747154916175800413+% 262420742804288491611763413[+%7 3262424425119859491616576508MSC-00-00-00-00-00-002024-10-28 08:26:07