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 9u   u ) M } a% E - I 9 i9 y e M ! U =] Q  m  Y a 5 1  q   A +262423128213696J+262424275261402I+262421500219373H+262420626748002G+262421709062005F+262426070351246E+262424880733912D+262426846489703C+262429721130520B+262426109336482A+262421076843777@+262420343075972?+262420817412711>+262425178022734=+262425757509755<+262424231445060;+262424090012427:+2624201009992879+2624222569579158+2624273962767237+2624283126568806+2624249451256225+2624275409706074+2624224682949713+2624263634823302+2624221466176951+2624293838303970+262424925018724/+262423369975502.+262421363604576-+262425855800338,+262428719144914++262428609165889*+262429256048529)+262428820737272(+262420186529348'+262424741308551&+262427814798014%+262427643389562$+262421899829118#+262426514203294"+262426303132277!+262429613787299 +262426788069402+262422254672661+262428154976988+262420920037765+262427165190990+262423339160364+262426236078531+262424786911416+262427404859609+262422843538960+262425690213628+262428277260382+262426444778959+262422604119947+262426208863503+262428366388244+262428779989314+262425530555379+262429754104969 +262420776289874 +262421547471748 +262423592123721 +262421296105133 +262426908322311+262420079000743+262423030978424+262427741775465+262420120677256+262429962789216+262425751859343+ 262425427887710 J Y | ZF i l kG & X [  J ' j 6 9   8 }  H W %z 7 I yh  $ 5 ( { 623J%491618567046I%491614805088H%491614112616G%491613745556F%491612432677E%491615653266D%491615366287C%491610301160B%491613275776A%491617812144@%491616334448?%491618168735>%491618187685=%491616087535<%491617711721;%491614317657:%4916155340869%4916173732088%4916112747467%4916125686076%4916103645045%4916138426124%4916116053003%4916147783332%4916160213781%4916186753100%491612041114/%491618485017.%491615005187-%491618340236,%491613244771+%491617214544*%491616278424)%491610186358(%491614440261'%491618683172&%491618750042%%491616781463$%491615451012#%491613328240"%491617255578!%491611067626 %491614461878%491611056406%491616744457%491616877781%491614517560%491612627444%491613643420%491611724188%491617135468%491617722227%491618208065%491615486642%491618310486%491615277387%491616008141%491614282513%491614131607%491612883558%491618223067 %491618348204 %491611466574 %491616704135 %491617775037 %491617750216%491617864184%491614011581%491612028848%491614370410%491618585726%491617535826% 491613727835   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 9u   u ) M } a% E - I 9 i9 y e M ! U =] Q  m  Y a 5 1  q   A +262423128213696J+262424275261402I+262421500219373H+262420626748002G+262421709062005F+262426070351246E+262424880733912D+262426846489703C+262429721130520B+262426109336482A+262421076843777@+262420343075972?+262420817412711>+262425178022734=+262425757509755<+262424231445060;+262424090012427:+2624201009992879+2624222569579158+2624273962767237+2624283126568806+2624249451256225+2624275409706074+2624224682949713+2624263634823302+2624221466176951+2624293838303970+262424925018724/+262423369975502.+262421363604576-+262425855800338,+262428719144914++262428609165889*+262429256048529)+262428820737272(+262420186529348'+262424741308551&+262427814798014%+262427643389562$+262421899829118#+262426514203294"+262426303132277!+262429613787299 +262426788069402+262422254672661+262428154976988+262420920037765+262427165190990+262423339160364+262426236078531+262424786911416+262427404859609+262422843538960+262425690213628+262428277260382+262426444778959+262422604119947+262426208863503+262428366388244+262428779989314+262425530555379+262429754104969 +262420776289874 +262421547471748 +262423592123721 +262421296105133 +262426908322311+262420079000743+262423030978424+262427741775465+262420120677256+262429962789216+262425751859343+ 262425427887710 8J+) 26242312821369662312345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624242752614024916185670463H+% 2624215002193734916148050883G+% 2624206267480024916141126163F+% 2624217090620054916137455563E+% 2624260703512464916124326773D+% 2624248807339124916156532663C+% 2624268464897034916153662873B+% 2624297211305204916103011603A+% 2624261093364824916132757763@+% 2624210768437774916178121443?+% 2624203430759724916163344483>+% 2624208174127114916181687353=+% 2624251780227344916181876853<+% 2624257575097554916160875353;+% 2624242314450604916177117213:+% 26242409001242749161431765739+% 26242010099928749161553408638+% 26242225695791549161737320837+% 26242739627672349161127474636+% 26242831265688049161256860735+% 26242494512562249161036450434+% 26242754097060749161384261233+% 26242246829497149161160530032+% 26242636348233049161477833331+% 26242214661769549161602137830+% 2624293838303974916186753103/+% 2624249250187244916120411143.+% 2624233699755024916184850173-+% 2624213636045764916150051873,+% 2624258558003384916183402363++% 2624287191449144916132447713*+% 2624286091658894916172145443)+% 2624292560485294916162784243(+% 2624288207372724916101863583'+% 2624201865293484916144402613&+% 2624247413085514916186831723%+% 2624278147980144916187500423$+% 2624276433895624916167814633#+% 2624218998291184916154510123"+% 2624265142032944916133282403!+% 2624263031322774916172555783 +% 2624296137872994916110676263+% 2624267880694024916144618783+% 2624222546726614916110564063+% 2624281549769884916167444573+% 2624209200377654916168777813+% 2624271651909904916145175603+% 2624233391603644916126274443+% 2624262360785314916136434203+% 2624247869114164916117241883+% 2624274048596094916171354683+% 2624228435389604916177222273+% 2624256902136284916182080653+% 2624282772603824916154866423+% 2624264447789594916183104863+% 2624226041199474916152773873+% 2624262088635034916160081413+% 2624283663882444916142825133+% 2624287799893144916141316073+% 2624255305553794916128835583 +% 2624297541049694916182230673 +% 2624207762898744916183482043 +% 2624215474717484916114665743 +% 2624235921237214916167041353 +% 2624212961051334916177750373+% 2624269083223114916177502163+% 2624200790007434916178641843+% 2624230309784244916140115813+% 2624277417754654916120288483+% 2624201206772564916143704103+% 2624299627892164916185857263+% 262425751859343491617535826[+%7 3262425427887710491613727835MSC-00-00-00-00-00-002024-09-15 12:03:03