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 Q! m Mu5] 9  y u% A M a ) Y =   e    1 i9 } -q   I a U E  +262422844526065J+262424147107730I+262424538049991H+262423682787574G+262421546415510F+262421652564955E+262425837811491D+262427832803568C+262429391762736B+262420476171252A+262429032241416@+262426440718876?+262424891324788>+262424905159984=+262420544188412<+262426362656496;+262423321999984:+2624283756946219+2624268407063048+2624262970822267+2624246594383516+2624249948881415+2624257992340664+2624258436533093+2624294483841612+2624278390467731+2624241417824900+262429208177094/+262427302650493.+262427818790639-+262424516275877,+262423172769692++262423147874922*+262424808917710)+262423258947601(+262420526140334'+262428071398638&+262422851830937%+262426988283005$+262429382042923#+262424892358322"+262421407550851!+262426756128430 +262428755514088+262422859340191+262424595628456+262420397953642+262426559378514+262429549651570+262426818273847+262421122295092+262422390959000+262428957355983+262422761386670+262427960945688+262424566111595+262423881926347+262429912454806+262428558235094+262421296983521+262427603211428+262426477576946 +262426882410454 +262423731211548 +262427586095588 +262421818065592 +262429100404316+262422019415698+262424109851388+262428205181754+262429905956629+262425685014766+262427127230814+ 262427087614487 J    J [GX  % l Y Z HF '5$z 8 k (W   { 9 |h  j6 }y  I  7 &i 597J%491613746272I%491615414240H%491611464813G%491611526666F%491612326054E%491616821621D%491611737425C%491616278681B%491614673055A%491611678081@%491610744776?%491617803805>%491615880274=%491614168182<%491611113082;%491612864075:%4916136337139%4916177347538%4916125372857%4916136841246%4916157311375%4916167150864%4916143315103%4916101040782%4916188135381%4916181868570%491611178385/%491611136106.%491611076387-%491618041853,%491618386570+%491618342378*%491612824235)%491612380432(%491616158721'%491615142445&%491611243273%%491618264503$%491612175522#%491617731720"%491614342850!%491617038081 %491611011282%491614716841%491613642615%491612180376%491616173635%491611560027%491611601646%491618420348%491613451464%491613340267%491615440734%491612038430%491618806535%491616130654%491618084666%491611554324%491618451057%491611232700%491613202543 %491613071032 %491612852064 %491613751838 %491615864887 %491616856517%491617045655%491616050060%491615657104%491617683061%491615324330%491617288138% 491611636033   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 Q! m Mu5] 9  y u% A M a ) Y =   e    1 i9 } -q   I a U E  +262422844526065J+262424147107730I+262424538049991H+262423682787574G+262421546415510F+262421652564955E+262425837811491D+262427832803568C+262429391762736B+262420476171252A+262429032241416@+262426440718876?+262424891324788>+262424905159984=+262420544188412<+262426362656496;+262423321999984:+2624283756946219+2624268407063048+2624262970822267+2624246594383516+2624249948881415+2624257992340664+2624258436533093+2624294483841612+2624278390467731+2624241417824900+262429208177094/+262427302650493.+262427818790639-+262424516275877,+262423172769692++262423147874922*+262424808917710)+262423258947601(+262420526140334'+262428071398638&+262422851830937%+262426988283005$+262429382042923#+262424892358322"+262421407550851!+262426756128430 +262428755514088+262422859340191+262424595628456+262420397953642+262426559378514+262429549651570+262426818273847+262421122295092+262422390959000+262428957355983+262422761386670+262427960945688+262424566111595+262423881926347+262429912454806+262428558235094+262421296983521+262427603211428+262426477576946 +262426882410454 +262423731211548 +262427586095588 +262421818065592 +262429100404316+262422019415698+262424109851388+262428205181754+262429905956629+262425685014766+262427127230814+ 262427087614487 8J+) 26242284452606559712345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624241471077304916137462723H+% 2624245380499914916154142403G+% 2624236827875744916114648133F+% 2624215464155104916115266663E+% 2624216525649554916123260543D+% 2624258378114914916168216213C+% 2624278328035684916117374253B+% 2624293917627364916162786813A+% 2624204761712524916146730553@+% 2624290322414164916116780813?+% 2624264407188764916107447763>+% 2624248913247884916178038053=+% 2624249051599844916158802743<+% 2624205441884124916141681823;+% 2624263626564964916111130823:+% 26242332199998449161286407539+% 26242837569462149161363371338+% 26242684070630449161773475337+% 26242629708222649161253728536+% 26242465943835149161368412435+% 26242499488814149161573113734+% 26242579923406649161671508633+% 26242584365330949161433151032+% 26242944838416149161010407831+% 26242783904677349161881353830+% 2624241417824904916181868573/+% 2624292081770944916111783853.+% 2624273026504934916111361063-+% 2624278187906394916110763873,+% 2624245162758774916180418533++% 2624231727696924916183865703*+% 2624231478749224916183423783)+% 2624248089177104916128242353(+% 2624232589476014916123804323'+% 2624205261403344916161587213&+% 2624280713986384916151424453%+% 2624228518309374916112432733$+% 2624269882830054916182645033#+% 2624293820429234916121755223"+% 2624248923583224916177317203!+% 2624214075508514916143428503 +% 2624267561284304916170380813+% 2624287555140884916110112823+% 2624228593401914916147168413+% 2624245956284564916136426153+% 2624203979536424916121803763+% 2624265593785144916161736353+% 2624295496515704916115600273+% 2624268182738474916116016463+% 2624211222950924916184203483+% 2624223909590004916134514643+% 2624289573559834916133402673+% 2624227613866704916154407343+% 2624279609456884916120384303+% 2624245661115954916188065353+% 2624238819263474916161306543+% 2624299124548064916180846663+% 2624285582350944916115543243+% 2624212969835214916184510573+% 2624276032114284916112327003 +% 2624264775769464916132025433 +% 2624268824104544916130710323 +% 2624237312115484916128520643 +% 2624275860955884916137518383 +% 2624218180655924916158648873+% 2624291004043164916168565173+% 2624220194156984916170456553+% 2624241098513884916160500603+% 2624282051817544916156571043+% 2624299059566294916176830613+% 2624256850147664916153243303+% 262427127230814491617288138[+%7 3262427087614487491611636033MSC-00-00-00-00-00-002024-11-07 08:56:07