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 U Q -%  i M  y M 9  = e5 9   A Y  } aq ) E ua!uI   ] m 1 +262423946316806J+262422203006217I+262425386811022H+262426761718866G+262426537240381F+262421944475751E+262426442293357D+262424327528776C+262428167529510B+262429843524119A+262421938873480@+262421834626157?+262426167447951>+262423664331112=+262420242529424<+262423761598927;+262421980398029:+2624215538629799+2624281419665558+2624205126047867+2624293327926876+2624215279197995+2624240790564774+2624280287675743+2624275884147052+2624207500841871+2624247716014780+262420134595982/+262421546990365.+262425244335930-+262428357067127,+262424214437076++262422697804765*+262423272379621)+262423004978165(+262420690223198'+262423244209056&+262424996046373%+262429340181687$+262426448318747#+262424792435647"+262429064122512!+262426761158775 +262421316392132+262427892643101+262424230460876+262429895224349+262428404014599+262426414118307+262428141876497+262427196305967+262423775118650+262427278212490+262428948099493+262425402181614+262421252165661+262420109043863+262420020461275+262424284303212+262428559206965+262420838782815+262427298675525 +262427448492672 +262421091180354 +262423181598496 +262421917541388 +262427195548265+262427239579323+262420001848632+262424651000430+262423362002099+262421370013593+262424554367147+ 262428968415804 J |6  9  J } y  j i 8 {z Y l5 X [ '$     (F% Z 7Gh I W k H &  557J%491616044838I%491611270762H%491611458471G%491614015180F%491613678373E%491611466247D%491617361726C%491611184113B%491610578345A%491611628612@%491610127533?%491615006747>%491617142114=%491615821144<%491618502165;%491614572664:%4916131800679%4916166731858%4916162632437%4916176611126%4916104774475%4916113116454%4916125832173%4916122871732%4916114640281%4916135784460%491613876866/%491611727558.%491612384382-%491615013727,%491617732332+%491616335321*%491617688650)%491613615600(%491612466504'%491613503253&%491618131135%%491616244274$%491611201203#%491616148604"%491615521634!%491615311243 %491615433453%491616573253%491613476022%491616134650%491610487624%491616433634%491613880861%491613041051%491613535521%491616572463%491613486355%491611347003%491616653380%491612885413%491615612021%491614644056%491613522876%491612101662%491614723232 %491613818100 %491616083007 %491617464154 %491616508671 %491612078658%491610788463%491612634447%491613782714%491615518605%491611418050%491612186687% 491617444871   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 U Q -%  i M  y M 9  = e5 9   A Y  } aq ) E ua!uI   ] m 1 +262423946316806J+262422203006217I+262425386811022H+262426761718866G+262426537240381F+262421944475751E+262426442293357D+262424327528776C+262428167529510B+262429843524119A+262421938873480@+262421834626157?+262426167447951>+262423664331112=+262420242529424<+262423761598927;+262421980398029:+2624215538629799+2624281419665558+2624205126047867+2624293327926876+2624215279197995+2624240790564774+2624280287675743+2624275884147052+2624207500841871+2624247716014780+262420134595982/+262421546990365.+262425244335930-+262428357067127,+262424214437076++262422697804765*+262423272379621)+262423004978165(+262420690223198'+262423244209056&+262424996046373%+262429340181687$+262426448318747#+262424792435647"+262429064122512!+262426761158775 +262421316392132+262427892643101+262424230460876+262429895224349+262428404014599+262426414118307+262428141876497+262427196305967+262423775118650+262427278212490+262428948099493+262425402181614+262421252165661+262420109043863+262420020461275+262424284303212+262428559206965+262420838782815+262427298675525 +262427448492672 +262421091180354 +262423181598496 +262421917541388 +262427195548265+262427239579323+262420001848632+262424651000430+262423362002099+262421370013593+262424554367147+ 262428968415804 8J+) 26242394631680655712345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624222030062174916160448383H+% 2624253868110224916112707623G+% 2624267617188664916114584713F+% 2624265372403814916140151803E+% 2624219444757514916136783733D+% 2624264422933574916114662473C+% 2624243275287764916173617263B+% 2624281675295104916111841133A+% 2624298435241194916105783453@+% 2624219388734804916116286123?+% 2624218346261574916101275333>+% 2624261674479514916150067473=+% 2624236643311124916171421143<+% 2624202425294244916158211443;+% 2624237615989274916185021653:+% 26242198039802949161457266439+% 26242155386297949161318006738+% 26242814196655549161667318537+% 26242051260478649161626324336+% 26242933279268749161766111235+% 26242152791979949161047744734+% 26242407905647749161131164533+% 26242802876757449161258321732+% 26242758841470549161228717331+% 26242075008418749161146402830+% 2624247716014784916135784463/+% 2624201345959824916138768663.+% 2624215469903654916117275583-+% 2624252443359304916123843823,+% 2624283570671274916150137273++% 2624242144370764916177323323*+% 2624226978047654916163353213)+% 2624232723796214916176886503(+% 2624230049781654916136156003'+% 2624206902231984916124665043&+% 2624232442090564916135032533%+% 2624249960463734916181311353$+% 2624293401816874916162442743#+% 2624264483187474916112012033"+% 2624247924356474916161486043!+% 2624290641225124916155216343 +% 2624267611587754916153112433+% 2624213163921324916154334533+% 2624278926431014916165732533+% 2624242304608764916134760223+% 2624298952243494916161346503+% 2624284040145994916104876243+% 2624264141183074916164336343+% 2624281418764974916138808613+% 2624271963059674916130410513+% 2624237751186504916135355213+% 2624272782124904916165724633+% 2624289480994934916134863553+% 2624254021816144916113470033+% 2624212521656614916166533803+% 2624201090438634916128854133+% 2624200204612754916156120213+% 2624242843032124916146440563+% 2624285592069654916135228763+% 2624208387828154916121016623 +% 2624272986755254916147232323 +% 2624274484926724916138181003 +% 2624210911803544916160830073 +% 2624231815984964916174641543 +% 2624219175413884916165086713+% 2624271955482654916120786583+% 2624272395793234916107884633+% 2624200018486324916126344473+% 2624246510004304916137827143+% 2624233620020994916155186053+% 2624213700135934916114180503+% 262424554367147491612186687[+%7 3262428968415804491617444871MSC-00-00-00-00-00-002024-10-19 05:56:30