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 =   Y a y I5! Q]q M a 9  U ) %  i 9 - } A 1 u  M   u e E +262423401185134J+262428485724998I+262422968318782H+262428110322359G+262420138595740F+262428636183969E+262429350266749D+262428928126355C+262426826270986B+262424723670802A+262428780294353@+262428323521182?+262424226582405>+262420110263402=+262421681382327<+262429688343210;+262421005251679:+2624242214096499+2624260806992278+2624263263989537+2624204390611376+2624258588425325+2624270672807284+2624234235354533+2624208161504282+2624263972018821+2624275910307770+262424196687844/+262426280823089.+262426437793705-+262424990453478,+262422482843815++262429050805670*+262425287252640)+262423229812856(+262428777378084'+262420569993130&+262429974838211%+262427914610949$+262429703648892#+262420642579514"+262420001585975!+262423110580458 +262425380196738+262421595914926+262421268440539+262427272745606+262426167766097+262424787181535+262424946377249+262421553456547+262421412580280+262421397925589+262421776855187+262421853505127+262424203130067+262424644569527+262428908968637+262425387234620+262420630080364+262421077527145+262429145784240 +262423095756136 +262424878773568 +262426388789773 +262422845660696 +262420837439277+262429512424849+262422934113696+262426290655288+262420347749311+262421767190844+262429670562243+ 262420813415620 J | y ' & i ( Y 6 Zz [ $W j I { 8   }   l   % J 9 F kG Xh5  H 7  670J%491611227236I%491616688674H%491616516803G%491613310524F%491615356840E%491615040753D%491613434108C%491618680478B%491615803445A%491618443651@%491618708161?%491615658427>%491616273156=%491618355631<%491617233417;%491610143041:%4916141032279%4916138007728%4916128778037%4916173851666%4916100083525%4916118701474%4916177448273%4916150552012%4916157064861%4916142318730%491614815504/%491610010767.%491615045437-%491618784230,%491610426218+%491618468810*%491618436377)%491611455300(%491613508107'%491613847784&%491611578372%%491614023887$%491610512431#%491610315328"%491616138310!%491613328465 %491611774371%491612022015%491613058437%491616357428%491612005013%491617567878%491617878814%491610548818%491613003478%491618182572%491617664140%491618133670%491617080777%491615243201%491615784360%491616871826%491615025681%491617354136%491613414647 %491618333465 %491617356162 %491613416626 %491618150222 %491610071348%491612371403%491615063067%491615881321%491613718886%491616302478%491617231331% 491614605308   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 =   Y a y I5! Q]q M a 9  U ) %  i 9 - } A 1 u  M   u e E +262423401185134J+262428485724998I+262422968318782H+262428110322359G+262420138595740F+262428636183969E+262429350266749D+262428928126355C+262426826270986B+262424723670802A+262428780294353@+262428323521182?+262424226582405>+262420110263402=+262421681382327<+262429688343210;+262421005251679:+2624242214096499+2624260806992278+2624263263989537+2624204390611376+2624258588425325+2624270672807284+2624234235354533+2624208161504282+2624263972018821+2624275910307770+262424196687844/+262426280823089.+262426437793705-+262424990453478,+262422482843815++262429050805670*+262425287252640)+262423229812856(+262428777378084'+262420569993130&+262429974838211%+262427914610949$+262429703648892#+262420642579514"+262420001585975!+262423110580458 +262425380196738+262421595914926+262421268440539+262427272745606+262426167766097+262424787181535+262424946377249+262421553456547+262421412580280+262421397925589+262421776855187+262421853505127+262424203130067+262424644569527+262428908968637+262425387234620+262420630080364+262421077527145+262429145784240 +262423095756136 +262424878773568 +262426388789773 +262422845660696 +262420837439277+262429512424849+262422934113696+262426290655288+262420347749311+262421767190844+262429670562243+ 262420813415620 8J+) 26242340118513467012345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624284857249984916112272363H+% 2624229683187824916166886743G+% 2624281103223594916165168033F+% 2624201385957404916133105243E+% 2624286361839694916153568403D+% 2624293502667494916150407533C+% 2624289281263554916134341083B+% 2624268262709864916186804783A+% 2624247236708024916158034453@+% 2624287802943534916184436513?+% 2624283235211824916187081613>+% 2624242265824054916156584273=+% 2624201102634024916162731563<+% 2624216813823274916183556313;+% 2624296883432104916172334173:+% 26242100525167949161014304139+% 26242422140964949161410322738+% 26242608069922749161380077237+% 26242632639895349161287780336+% 26242043906113749161738516635+% 26242585884253249161000835234+% 26242706728072849161187014733+% 26242342353545349161774482732+% 26242081615042849161505520131+% 26242639720188249161570648630+% 2624275910307774916142318733/+% 2624241966878444916148155043.+% 2624262808230894916100107673-+% 2624264377937054916150454373,+% 2624249904534784916187842303++% 2624224828438154916104262183*+% 2624290508056704916184688103)+% 2624252872526404916184363773(+% 2624232298128564916114553003'+% 2624287773780844916135081073&+% 2624205699931304916138477843%+% 2624299748382114916115783723$+% 2624279146109494916140238873#+% 2624297036488924916105124313"+% 2624206425795144916103153283!+% 2624200015859754916161383103 +% 2624231105804584916133284653+% 2624253801967384916117743713+% 2624215959149264916120220153+% 2624212684405394916130584373+% 2624272727456064916163574283+% 2624261677660974916120050133+% 2624247871815354916175678783+% 2624249463772494916178788143+% 2624215534565474916105488183+% 2624214125802804916130034783+% 2624213979255894916181825723+% 2624217768551874916176641403+% 2624218535051274916181336703+% 2624242031300674916170807773+% 2624246445695274916152432013+% 2624289089686374916157843603+% 2624253872346204916168718263+% 2624206300803644916150256813+% 2624210775271454916173541363 +% 2624291457842404916134146473 +% 2624230957561364916183334653 +% 2624248787735684916173561623 +% 2624263887897734916134166263 +% 2624228456606964916181502223+% 2624208374392774916100713483+% 2624295124248494916123714033+% 2624229341136964916150630673+% 2624262906552884916158813213+% 2624203477493114916137188863+% 2624217671908444916163024783+% 262429670562243491617231331[+%7 3262420813415620491614605308MSC-00-00-00-00-00-002024-11-03 16:03:00