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 95M  m Y  9 A 1a M 9  - !]  E  % }  yq  U i a = Q ) u  I eu+262422425204063J+262422938863106I+262427307327072H+262428342343144G+262429033663893F+262420758288063E+262425792440058D+262422835028758C+262428989277130B+262421378491542A+262426199288208@+262425072345705?+262428244039458>+262428038421442=+262428148782335<+262429546719148;+262426021895038:+2624291358092149+2624272746921028+2624244712280117+2624243019606966+2624236431983315+2624211161619344+2624254729263523+2624223112589032+2624243567222391+2624224571611040+262426614631393/+262427152110026.+262425648248786-+262423716355384,+262426311927429++262421232022767*+262425097293079)+262429530400364(+262429317263005'+262423050624311&+262428656487330%+262422770190712$+262425126994212#+262421840709679"+262421834717145!+262425140042109 +262423475036697+262424331417357+262422162043770+262421662761454+262421139895486+262421494279282+262425581601276+262424665458204+262420167322534+262428995848301+262424826622489+262426193428792+262427159331753+262424573274239+262427737723806+262426211588952+262421853010349+262427992019383+262423855577073 +262425414631497 +262425581243569 +262423494982459 +262420451286041 +262422775014507+262429621535437+262420997214964+262425963672425+262427732366552+262420019491260+262427137738179+ 262425219265119 J { } &  I$ ' zG Z    i l JF y  W 7 H  %  j 85 h Y k 9 | ( X6 [ 529J%491618251138I%491618182716H%491614233620G%491618676306F%491614120402E%491610472152D%491614774312C%491613812324B%491611877254A%491610508875@%491610720880?%491612668130>%491617762521=%491615850444<%491616458823;%491611815767:%4916168343089%4916111263178%4916121807567%4916177388186%4916182431645%4916178874574%4916117450463%4916131542172%4916186848211%4916171586310%491613288873/%491610081606.%491618286188-%491611113130,%491610520274+%491615764033*%491615824481)%491617730735(%491616665568'%491610223268&%491613188670%%491614577205$%491616152828#%491611663773"%491613400164!%491612630806 %491615320866%491612532746%491616650455%491616444688%491618673325%491612152246%491618564834%491614114345%491612140018%491612372666%491616342004%491613516777%491613346510%491613076582%491613412042%491614270445%491615616445%491615306858%491611588010 %491617044780 %491614441617 %491615408711 %491617551663 %491614675086%491613308621%491614718860%491614244156%491615158651%491618502041%491618442274% 491618653067   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 95M  m Y  9 A 1a M 9  - !]  E  % }  yq  U i a = Q ) u  I eu+262422425204063J+262422938863106I+262427307327072H+262428342343144G+262429033663893F+262420758288063E+262425792440058D+262422835028758C+262428989277130B+262421378491542A+262426199288208@+262425072345705?+262428244039458>+262428038421442=+262428148782335<+262429546719148;+262426021895038:+2624291358092149+2624272746921028+2624244712280117+2624243019606966+2624236431983315+2624211161619344+2624254729263523+2624223112589032+2624243567222391+2624224571611040+262426614631393/+262427152110026.+262425648248786-+262423716355384,+262426311927429++262421232022767*+262425097293079)+262429530400364(+262429317263005'+262423050624311&+262428656487330%+262422770190712$+262425126994212#+262421840709679"+262421834717145!+262425140042109 +262423475036697+262424331417357+262422162043770+262421662761454+262421139895486+262421494279282+262425581601276+262424665458204+262420167322534+262428995848301+262424826622489+262426193428792+262427159331753+262424573274239+262427737723806+262426211588952+262421853010349+262427992019383+262423855577073 +262425414631497 +262425581243569 +262423494982459 +262420451286041 +262422775014507+262429621535437+262420997214964+262425963672425+262427732366552+262420019491260+262427137738179+ 262425219265119 8J+) 26242242520406352912345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624229388631064916182511383H+% 2624273073270724916181827163G+% 2624283423431444916142336203F+% 2624290336638934916186763063E+% 2624207582880634916141204023D+% 2624257924400584916104721523C+% 2624228350287584916147743123B+% 2624289892771304916138123243A+% 2624213784915424916118772543@+% 2624261992882084916105088753?+% 2624250723457054916107208803>+% 2624282440394584916126681303=+% 2624280384214424916177625213<+% 2624281487823354916158504443;+% 2624295467191484916164588233:+% 26242602189503849161181576739+% 26242913580921449161683430838+% 26242727469210249161112631737+% 26242447122801149161218075636+% 26242430196069649161773881835+% 26242364319833149161824316434+% 26242111616193449161788745733+% 26242547292635249161174504632+% 26242231125890349161315421731+% 26242435672223949161868482130+% 2624224571611044916171586313/+% 2624266146313934916132888733.+% 2624271521100264916100816063-+% 2624256482487864916182861883,+% 2624237163553844916111131303++% 2624263119274294916105202743*+% 2624212320227674916157640333)+% 2624250972930794916158244813(+% 2624295304003644916177307353'+% 2624293172630054916166655683&+% 2624230506243114916102232683%+% 2624286564873304916131886703$+% 2624227701907124916145772053#+% 2624251269942124916161528283"+% 2624218407096794916116637733!+% 2624218347171454916134001643 +% 2624251400421094916126308063+% 2624234750366974916153208663+% 2624243314173574916125327463+% 2624221620437704916166504553+% 2624216627614544916164446883+% 2624211398954864916186733253+% 2624214942792824916121522463+% 2624255816012764916185648343+% 2624246654582044916141143453+% 2624201673225344916121400183+% 2624289958483014916123726663+% 2624248266224894916163420043+% 2624261934287924916135167773+% 2624271593317534916133465103+% 2624245732742394916130765823+% 2624277377238064916134120423+% 2624262115889524916142704453+% 2624218530103494916156164453+% 2624279920193834916153068583 +% 2624238555770734916115880103 +% 2624254146314974916170447803 +% 2624255812435694916144416173 +% 2624234949824594916154087113 +% 2624204512860414916175516633+% 2624227750145074916146750863+% 2624296215354374916133086213+% 2624209972149644916147188603+% 2624259636724254916142441563+% 2624277323665524916151586513+% 2624200194912604916185020413+% 262427137738179491618442274[+%7 3262425219265119491618653067MSC-00-00-00-00-00-002024-10-05 05:56:07