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 ] m =  - 9 uq a5 1 M E  y  ! I e M )   Qa 9 A  }u  %  Y  i U  +262426764749489J+262421851719928I+262421409456624H+262421289917962G+262421711423713F+262428064243450E+262427024111377D+262429980587445C+262428967425168B+262427337806961A+262426934902933@+262427683581027?+262425865213814>+262421039293400=+262426330558815<+262424117720058;+262422708980333:+2624261821575359+2624233669534858+2624200041101507+2624244736974106+2624295988338285+2624279086728114+2624211012181643+2624260044498522+2624211194860911+2624267857777990+262429420897367/+262428822704564.+262427290128968-+262421175289526,+262423601595360++262422295171225*+262422347613776)+262423783050878(+262420239953062'+262420300301894&+262422186781296%+262421641876837$+262422164141658#+262427852836395"+262420939340816!+262426501918811 +262424437997742+262423107276497+262423458217235+262427918369841+262426310801172+262427626224400+262427402339804+262423705284561+262421639787544+262423988604488+262420657396151+262421359181149+262426253227202+262423127549095+262428128484665+262420887619153+262427021059106+262429585249770+262425403076588 +262428218141875 +262427572499969 +262421256277678 +262424712874401 +262426394996689+262427337599050+262423077741887+262424607817033+262426239342436+262420874131719+262420873653639+ 262429790656447 J $ Z 8    Hi5 Y6 h F I {y % 9W | jG X  k } 7 &z [  J '  l ( 630J%491618661611I%491614753047H%491618336678G%491618052244F%491618653005E%491616424016D%491615038510C%491610023150B%491611760781A%491614106865@%491618122335?%491618151411>%491616348426=%491615302618<%491612431507;%491618437803:%4916114237779%4916142610768%4916113685487%4916163255806%4916150630635%4916114205324%4916154737813%4916114715572%4916112183081%4916117854630%491615560205/%491611824567.%491618645635-%491614670663,%491617172166+%491616680482*%491612764771)%491613136513(%491615210771'%491614332762&%491613671378%%491618035675$%491610525313#%491617864023"%491614050845!%491613476272 %491611010412%491615414774%491617352074%491614712261%491613272367%491615267883%491615318182%491613074168%491617234170%491610227748%491612616465%491615557636%491617567526%491615443517%491618668541%491612147514%491613671068%491613660306%491610386563 %491613102503 %491613838746 %491615018815 %491613561608 %491614624311%491611667443%491618141062%491614672238%491617445074%491615073701%491613141851% 491618406837   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 ] m =  - 9 uq a5 1 M E  y  ! I e M )   Qa 9 A  }u  %  Y  i U  +262426764749489J+262421851719928I+262421409456624H+262421289917962G+262421711423713F+262428064243450E+262427024111377D+262429980587445C+262428967425168B+262427337806961A+262426934902933@+262427683581027?+262425865213814>+262421039293400=+262426330558815<+262424117720058;+262422708980333:+2624261821575359+2624233669534858+2624200041101507+2624244736974106+2624295988338285+2624279086728114+2624211012181643+2624260044498522+2624211194860911+2624267857777990+262429420897367/+262428822704564.+262427290128968-+262421175289526,+262423601595360++262422295171225*+262422347613776)+262423783050878(+262420239953062'+262420300301894&+262422186781296%+262421641876837$+262422164141658#+262427852836395"+262420939340816!+262426501918811 +262424437997742+262423107276497+262423458217235+262427918369841+262426310801172+262427626224400+262427402339804+262423705284561+262421639787544+262423988604488+262420657396151+262421359181149+262426253227202+262423127549095+262428128484665+262420887619153+262427021059106+262429585249770+262425403076588 +262428218141875 +262427572499969 +262421256277678 +262424712874401 +262426394996689+262427337599050+262423077741887+262424607817033+262426239342436+262420874131719+262420873653639+ 262429790656447 8J+) 26242676474948963012345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624218517199284916186616113H+% 2624214094566244916147530473G+% 2624212899179624916183366783F+% 2624217114237134916180522443E+% 2624280642434504916186530053D+% 2624270241113774916164240163C+% 2624299805874454916150385103B+% 2624289674251684916100231503A+% 2624273378069614916117607813@+% 2624269349029334916141068653?+% 2624276835810274916181223353>+% 2624258652138144916181514113=+% 2624210392934004916163484263<+% 2624263305588154916153026183;+% 2624241177200584916124315073:+% 26242270898033349161843780339+% 26242618215753549161142377738+% 26242336695348549161426107637+% 26242000411015049161136854836+% 26242447369741049161632558035+% 26242959883382849161506306334+% 26242790867281149161142053233+% 26242110121816449161547378132+% 26242600444985249161147155731+% 26242111948609149161121830830+% 2624267857777994916117854633/+% 2624294208973674916155602053.+% 2624288227045644916118245673-+% 2624272901289684916186456353,+% 2624211752895264916146706633++% 2624236015953604916171721663*+% 2624222951712254916166804823)+% 2624223476137764916127647713(+% 2624237830508784916131365133'+% 2624202399530624916152107713&+% 2624203003018944916143327623%+% 2624221867812964916136713783$+% 2624216418768374916180356753#+% 2624221641416584916105253133"+% 2624278528363954916178640233!+% 2624209393408164916140508453 +% 2624265019188114916134762723+% 2624244379977424916110104123+% 2624231072764974916154147743+% 2624234582172354916173520743+% 2624279183698414916147122613+% 2624263108011724916132723673+% 2624276262244004916152678833+% 2624274023398044916153181823+% 2624237052845614916130741683+% 2624216397875444916172341703+% 2624239886044884916102277483+% 2624206573961514916126164653+% 2624213591811494916155576363+% 2624262532272024916175675263+% 2624231275490954916154435173+% 2624281284846654916186685413+% 2624208876191534916121475143+% 2624270210591064916136710683+% 2624295852497704916136603063 +% 2624254030765884916103865633 +% 2624282181418754916131025033 +% 2624275724999694916138387463 +% 2624212562776784916150188153 +% 2624247128744014916135616083+% 2624263949966894916146243113+% 2624273375990504916116674433+% 2624230777418874916181410623+% 2624246078170334916146722383+% 2624262393424364916174450743+% 2624208741317194916150737013+% 262420873653639491613141851[+%7 3262429790656447491618406837MSC-00-00-00-00-00-002024-06-27 05:56:56