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 ) e  U  !I - Y Aq  M i u] a 9  yu 1     a Q E9% }  = m5+262425535725048J+262424237287571I+262425352491642H+262425064448937G+262424876633316F+262427686186507E+262424343596801D+262421156031257C+262421723646000B+262422590543538A+262427158535180@+262426807643195?+262420356363583>+262429600503768=+262427852346310<+262420399811365;+262425629199136:+2624274736418359+2624218362484058+2624210668918287+2624258357081246+2624277017698525+2624282617869434+2624260877293183+2624200681014162+2624218878098441+2624232393293390+262421012671397/+262424422118541.+262429105301814-+262421339109530,+262428012515098++262423459233392*+262429319934659)+262422845348393(+262428255231017'+262420205909195&+262421241347568%+262425906246634$+262428355978829#+262422416192877"+262429942344546!+262425549824563 +262421144057336+262425286129033+262425923649161+262427411080369+262420473489405+262429134620027+262420786053481+262421744967046+262429954268583+262421796942384+262425127415885+262423373116634+262429152097421+262428379395794+262420769551750+262425704252367+262420412870606+262424089052282+262427543386408 +262426522505190 +262428734087511 +262428432098492 +262420156762840 +262427739836831+262425737435893+262425757747516+262420377952699+262425611435700+262424448806961+262426409076349+ 262429915851362 J J  H G  l (W 'F [ y6 | 7%    & k h   9 X }i Y j {z I5  $ Z 8 596J%491610871610I%491615110132H%491610005645G%491611163308F%491610804401E%491616428307D%491613086421C%491611222718B%491613865727A%491614810802@%491617842805?%491615028071>%491615641183=%491615080824<%491610575646;%491611114443:%4916186116169%4916171752408%4916184800067%4916133723846%4916115078345%4916118131684%4916186083533%4916143351202%4916138212361%4916188541020%491610026532/%491610350705.%491612085133-%491610741036,%491612835455+%491611533520*%491610105184)%491616510774(%491616626411'%491616860505&%491612131387%%491618084008$%491616123453#%491611325571"%491615382514!%491615265683 %491618143354%491612300852%491610158354%491611751675%491611455718%491610634705%491616147145%491616486756%491617168526%491617877630%491613754405%491612242484%491611688360%491618527205%491618631075%491616243281%491610085864%491614583232%491618334233 %491617602304 %491611141302 %491611034458 %491614021212 %491611455044%491611441844%491612817021%491611856726%491617628123%491614523732%491617523288% 491611327183   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 ) e  U  !I - Y Aq  M i u] a 9  yu 1     a Q E9% }  = m5+262425535725048J+262424237287571I+262425352491642H+262425064448937G+262424876633316F+262427686186507E+262424343596801D+262421156031257C+262421723646000B+262422590543538A+262427158535180@+262426807643195?+262420356363583>+262429600503768=+262427852346310<+262420399811365;+262425629199136:+2624274736418359+2624218362484058+2624210668918287+2624258357081246+2624277017698525+2624282617869434+2624260877293183+2624200681014162+2624218878098441+2624232393293390+262421012671397/+262424422118541.+262429105301814-+262421339109530,+262428012515098++262423459233392*+262429319934659)+262422845348393(+262428255231017'+262420205909195&+262421241347568%+262425906246634$+262428355978829#+262422416192877"+262429942344546!+262425549824563 +262421144057336+262425286129033+262425923649161+262427411080369+262420473489405+262429134620027+262420786053481+262421744967046+262429954268583+262421796942384+262425127415885+262423373116634+262429152097421+262428379395794+262420769551750+262425704252367+262420412870606+262424089052282+262427543386408 +262426522505190 +262428734087511 +262428432098492 +262420156762840 +262427739836831+262425737435893+262425757747516+262420377952699+262425611435700+262424448806961+262426409076349+ 262429915851362 8J+) 26242553572504859612345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624242372875714916108716103H+% 2624253524916424916151101323G+% 2624250644489374916100056453F+% 2624248766333164916111633083E+% 2624276861865074916108044013D+% 2624243435968014916164283073C+% 2624211560312574916130864213B+% 2624217236460004916112227183A+% 2624225905435384916138657273@+% 2624271585351804916148108023?+% 2624268076431954916178428053>+% 2624203563635834916150280713=+% 2624296005037684916156411833<+% 2624278523463104916150808243;+% 2624203998113654916105756463:+% 26242562919913649161111444339+% 26242747364183549161861161638+% 26242183624840549161717524037+% 26242106689182849161848000636+% 26242583570812449161337238435+% 26242770176985249161150783434+% 26242826178694349161181316833+% 26242608772931849161860835332+% 26242006810141649161433512031+% 26242188780984449161382123630+% 2624232393293394916188541023/+% 2624210126713974916100265323.+% 2624244221185414916103507053-+% 2624291053018144916120851333,+% 2624213391095304916107410363++% 2624280125150984916128354553*+% 2624234592333924916115335203)+% 2624293199346594916101051843(+% 2624228453483934916165107743'+% 2624282552310174916166264113&+% 2624202059091954916168605053%+% 2624212413475684916121313873$+% 2624259062466344916180840083#+% 2624283559788294916161234533"+% 2624224161928774916113255713!+% 2624299423445464916153825143 +% 2624255498245634916152656833+% 2624211440573364916181433543+% 2624252861290334916123008523+% 2624259236491614916101583543+% 2624274110803694916117516753+% 2624204734894054916114557183+% 2624291346200274916106347053+% 2624207860534814916161471453+% 2624217449670464916164867563+% 2624299542685834916171685263+% 2624217969423844916178776303+% 2624251274158854916137544053+% 2624233731166344916122424843+% 2624291520974214916116883603+% 2624283793957944916185272053+% 2624207695517504916186310753+% 2624257042523674916162432813+% 2624204128706064916100858643+% 2624240890522824916145832323 +% 2624275433864084916183342333 +% 2624265225051904916176023043 +% 2624287340875114916111413023 +% 2624284320984924916110344583 +% 2624201567628404916140212123+% 2624277398368314916114550443+% 2624257374358934916114418443+% 2624257577475164916128170213+% 2624203779526994916118567263+% 2624256114357004916176281233+% 2624244488069614916145237323+% 262426409076349491617523288[+%7 3262429915851362491611327183MSC-00-00-00-00-00-002024-10-27 05:56:06