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 YM  u9a 1q u    - U E I m  }  Q )  y    i % 9 =  e A  a 5 !  +262427289847693J+262420558594245I+262428757579981H+262421001089421G+262420890248729F+262424042083615E+262420783384524D+262429338536158C+262426175232504B+262420401823074A+262428693754352@+262422045669298?+262424776069847>+262427898310580=+262424717325830<+262428424949746;+262425723468602:+2624261310623909+2624259345056288+2624298867236597+2624234999128596+2624219727911685+2624254937186064+2624254078789493+2624295891005182+2624221940084631+2624284544551300+262422358432309/+262427043832730.+262424110592413-+262427951730782,+262422832618986++262427116972971*+262426790852761)+262423776301078(+262424232821206'+262429762289635&+262421925559753%+262421577441795$+262422694528873#+262420566776596"+262423758214627!+262421701066371 +262423165922987+262429257410676+262426015382669+262429016045237+262426711532132+262425247855143+262428068346106+262429470937368+262429189515616+262423562581511+262420542355820+262421632360418+262429500990015+262427761753601+262427773293420+262420865701494+262426050210685+262421554740394+262424617150654 +262421978670279 +262427265972116 +262421038774613 +262420638095315 +262421229833579+262421876218161+262427230123975+262426842871689+262424240818146+262421421583063+262426527203348+ 262424107794976 J  I 9 }% ( y { &iG J  '     X$ z5F H 8W 7  [ j  l  k Z | Yh6 868J%491611862364I%491611078328H%491613277132G%491617132331F%491617654136E%491611317111D%491610173506C%491611833544B%491610638827A%491610866165@%491610321550?%491614107015>%491615083547=%491615676151<%491614220843;%491613878134:%4916166163609%4916108117538%4916184645257%4916184515456%4916184777445%4916124235744%4916147082013%4916123247532%4916145581651%4916102674270%491617058677/%491618380038.%491610342528-%491614057712,%491612647110+%491616754607*%491616315245)%491618562688(%491617157802'%491612532302&%491617163082%%491613343886$%491615155581#%491614341824"%491610252263!%491615665733 %491616382724%491614033884%491618407520%491611412324%491618722247%491612837175%491615161058%491612772340%491615828082%491612418167%491617878230%491613361568%491618300362%491617065157%491614705321%491613818705%491617853260%491612624363%491615308111 %491615836355 %491616207263 %491616666147 %491618565710 %491612422181%491617177844%491614747082%491616101100%491615021725%491613874735%491618486052% 491613676356   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 YM  u9a 1q u    - U E I m  }  Q )  y    i % 9 =  e A  a 5 !  +262427289847693J+262420558594245I+262428757579981H+262421001089421G+262420890248729F+262424042083615E+262420783384524D+262429338536158C+262426175232504B+262420401823074A+262428693754352@+262422045669298?+262424776069847>+262427898310580=+262424717325830<+262428424949746;+262425723468602:+2624261310623909+2624259345056288+2624298867236597+2624234999128596+2624219727911685+2624254937186064+2624254078789493+2624295891005182+2624221940084631+2624284544551300+262422358432309/+262427043832730.+262424110592413-+262427951730782,+262422832618986++262427116972971*+262426790852761)+262423776301078(+262424232821206'+262429762289635&+262421925559753%+262421577441795$+262422694528873#+262420566776596"+262423758214627!+262421701066371 +262423165922987+262429257410676+262426015382669+262429016045237+262426711532132+262425247855143+262428068346106+262429470937368+262429189515616+262423562581511+262420542355820+262421632360418+262429500990015+262427761753601+262427773293420+262420865701494+262426050210685+262421554740394+262424617150654 +262421978670279 +262427265972116 +262421038774613 +262420638095315 +262421229833579+262421876218161+262427230123975+262426842871689+262424240818146+262421421583063+262426527203348+ 262424107794976 8J+) 26242728984769386812345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624205585942454916118623643H+% 2624287575799814916110783283G+% 2624210010894214916132771323F+% 2624208902487294916171323313E+% 2624240420836154916176541363D+% 2624207833845244916113171113C+% 2624293385361584916101735063B+% 2624261752325044916118335443A+% 2624204018230744916106388273@+% 2624286937543524916108661653?+% 2624220456692984916103215503>+% 2624247760698474916141070153=+% 2624278983105804916150835473<+% 2624247173258304916156761513;+% 2624284249497464916142208433:+% 26242572346860249161387813439+% 26242613106239049161661636038+% 26242593450562849161081175337+% 26242988672365949161846452536+% 26242349991285949161845154535+% 26242197279116849161847774434+% 26242549371860649161242357433+% 26242540787894949161470820132+% 26242958910051849161232475331+% 26242219400846349161455816530+% 2624284544551304916102674273/+% 2624223584323094916170586773.+% 2624270438327304916183800383-+% 2624241105924134916103425283,+% 2624279517307824916140577123++% 2624228326189864916126471103*+% 2624271169729714916167546073)+% 2624267908527614916163152453(+% 2624237763010784916185626883'+% 2624242328212064916171578023&+% 2624297622896354916125323023%+% 2624219255597534916171630823$+% 2624215774417954916133438863#+% 2624226945288734916151555813"+% 2624205667765964916143418243!+% 2624237582146274916102522633 +% 2624217010663714916156657333+% 2624231659229874916163827243+% 2624292574106764916140338843+% 2624260153826694916184075203+% 2624290160452374916114123243+% 2624267115321324916187222473+% 2624252478551434916128371753+% 2624280683461064916151610583+% 2624294709373684916127723403+% 2624291895156164916158280823+% 2624235625815114916124181673+% 2624205423558204916178782303+% 2624216323604184916133615683+% 2624295009900154916183003623+% 2624277617536014916170651573+% 2624277732934204916147053213+% 2624208657014944916138187053+% 2624260502106854916178532603+% 2624215547403944916126243633 +% 2624246171506544916153081113 +% 2624219786702794916158363553 +% 2624272659721164916162072633 +% 2624210387746134916166661473 +% 2624206380953154916185657103+% 2624212298335794916124221813+% 2624218762181614916171778443+% 2624272301239754916147470823+% 2624268428716894916161011003+% 2624242408181464916150217253+% 2624214215830634916138747353+% 262426527203348491618486052[+%7 3262424107794976491613676356MSC-00-00-00-00-00-002024-09-20 08:26:03