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 59 Y a  9   e% A  }a 1 )   E M M  I! q y m - i Q   Uu  =]+262422427572163J+262425152746169I+262421541309794H+262420434831748G+262424548905150F+262428932406289E+262429122742231D+262425674642853C+262428604773890B+262426921199435A+262428995882480@+262422743333846?+262424419427924>+262429726300210=+262428542785663<+262423008555876;+262427339055782:+2624294480208419+2624258993225258+2624296287061177+2624280263102806+2624223465870745+2624253288009634+2624226865439023+2624246521128992+2624275517705731+2624233121611130+262429300800183/+262428342401091.+262424025729772-+262427086516087,+262425492651942++262423895679185*+262428202502072)+262428352165547(+262426371956079'+262421352660179&+262426576924012%+262424129025653$+262425031723959#+262421373842844"+262427353045119!+262423362341224 +262423035730505+262423065564148+262422122890476+262424376382979+262428909967198+262422928499130+262420673662682+262426632718786+262421169561185+262426600532030+262429775377441+262427216918053+262429632895955+262426268253370+262424979957994+262424610041128+262426198472161+262429993996585+262427313665412 +262424225768363 +262423018624161 +262421192170912 +262425347165192 +262424027661994+262429429981928+262423755355688+262428878394749+262426892746780+262422791067452+262420735632342+ 262422251863128 J  7F (  {% iG6 ly [ }$ J 9 jX W &  | ' 5 H k Y h Z   8 Iz   803J%491610714277I%491613846057H%491613316805G%491612503835F%491612240156E%491612648133D%491613638823C%491611478402B%491617764181A%491612453630@%491618280664?%491615336640>%491616735851=%491615008367<%491617875527;%491615411344:%4916180313019%4916182430248%4916172724427%4916160073466%4916151773085%4916160414774%4916165856813%4916167871532%4916107732431%4916154472230%491617233785/%491618634613.%491618861538-%491610122171,%491614378383+%491610131284*%491615521820)%491616155413(%491614068320'%491611003788&%491614640720%%491614441760$%491616561022#%491618716671"%491614272112!%491610615267 %491616411076%491617780174%491611181230%491611328628%491612116077%491612058501%491614185826%491611735471%491618271337%491617741763%491615687200%491611247860%491610153051%491612076585%491611271283%491617660166%491613583012%491612071075%491612751377 %491615504607 %491610381165 %491614366420 %491616856075 %491612433810%491610474765%491613622710%491617858581%491611420003%491610880820%491618734262% 491611722386   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 59 Y a  9   e% A  }a 1 )   E M M  I! q y m - i Q   Uu  =]+262422427572163J+262425152746169I+262421541309794H+262420434831748G+262424548905150F+262428932406289E+262429122742231D+262425674642853C+262428604773890B+262426921199435A+262428995882480@+262422743333846?+262424419427924>+262429726300210=+262428542785663<+262423008555876;+262427339055782:+2624294480208419+2624258993225258+2624296287061177+2624280263102806+2624223465870745+2624253288009634+2624226865439023+2624246521128992+2624275517705731+2624233121611130+262429300800183/+262428342401091.+262424025729772-+262427086516087,+262425492651942++262423895679185*+262428202502072)+262428352165547(+262426371956079'+262421352660179&+262426576924012%+262424129025653$+262425031723959#+262421373842844"+262427353045119!+262423362341224 +262423035730505+262423065564148+262422122890476+262424376382979+262428909967198+262422928499130+262420673662682+262426632718786+262421169561185+262426600532030+262429775377441+262427216918053+262429632895955+262426268253370+262424979957994+262424610041128+262426198472161+262429993996585+262427313665412 +262424225768363 +262423018624161 +262421192170912 +262425347165192 +262424027661994+262429429981928+262423755355688+262428878394749+262426892746780+262422791067452+262420735632342+ 262422251863128 8J+) 26242242757216380312345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624251527461694916107142773H+% 2624215413097944916138460573G+% 2624204348317484916133168053F+% 2624245489051504916125038353E+% 2624289324062894916122401563D+% 2624291227422314916126481333C+% 2624256746428534916136388233B+% 2624286047738904916114784023A+% 2624269211994354916177641813@+% 2624289958824804916124536303?+% 2624227433338464916182806643>+% 2624244194279244916153366403=+% 2624297263002104916167358513<+% 2624285427856634916150083673;+% 2624230085558764916178755273:+% 26242733905578249161541134439+% 26242944802084149161803130138+% 26242589932252549161824302437+% 26242962870611749161727244236+% 26242802631028049161600734635+% 26242234658707449161517730834+% 26242532880096349161604147733+% 26242268654390249161658568132+% 26242465211289949161678715331+% 26242755177057349161077324330+% 2624233121611134916154472233/+% 2624293008001834916172337853.+% 2624283424010914916186346133-+% 2624240257297724916188615383,+% 2624270865160874916101221713++% 2624254926519424916143783833*+% 2624238956791854916101312843)+% 2624282025020724916155218203(+% 2624283521655474916161554133'+% 2624263719560794916140683203&+% 2624213526601794916110037883%+% 2624265769240124916146407203$+% 2624241290256534916144417603#+% 2624250317239594916165610223"+% 2624213738428444916187166713!+% 2624273530451194916142721123 +% 2624233623412244916106152673+% 2624230357305054916164110763+% 2624230655641484916177801743+% 2624221228904764916111812303+% 2624243763829794916113286283+% 2624289099671984916121160773+% 2624229284991304916120585013+% 2624206736626824916141858263+% 2624266327187864916117354713+% 2624211695611854916182713373+% 2624266005320304916177417633+% 2624297753774414916156872003+% 2624272169180534916112478603+% 2624296328959554916101530513+% 2624262682533704916120765853+% 2624249799579944916112712833+% 2624246100411284916176601663+% 2624261984721614916135830123+% 2624299939965854916120710753 +% 2624273136654124916127513773 +% 2624242257683634916155046073 +% 2624230186241614916103811653 +% 2624211921709124916143664203 +% 2624253471651924916168560753+% 2624240276619944916124338103+% 2624294299819284916104747653+% 2624237553556884916136227103+% 2624288783947494916178585813+% 2624268927467804916114200033+% 2624227910674524916108808203+% 262420735632342491618734262[+%7 3262422251863128491611722386MSC-00-00-00-00-00-002024-10-30 05:56:06