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!Ia Y e] 9 u -q  a 9  y M   Q U     ) } i %M  = 5u A  1 E+262422175613710J+262423357114350I+262422639028976H+262422522371245G+262428960194803F+262424596080679E+262421739305141D+262424375516628C+262427681639843B+262426553401873A+262423606639421@+262428701216019?+262427142928889>+262428864344994=+262424216353951<+262422002769857;+262423213190895:+2624225801573579+2624273957846928+2624226807073537+2624260733030646+2624215315286445+2624201552014374+2624299062141693+2624226228303962+2624225874958191+2624293704845050+262424561192292/+262427492053975.+262427304453791-+262427614420852,+262423709458148++262425822749312*+262427175547513)+262422267433408(+262429707640013'+262423671885583&+262423909889152%+262429922435547$+262429969117298#+262421474134866"+262420931150338!+262429703943495 +262424506758412+262424024415431+262422432491384+262425161613781+262423055090615+262424921100615+262425493412063+262421026781857+262429176770086+262421204447638+262422124048066+262422615746279+262424372276848+262423066038009+262421390996249+262429975715936+262428056131006+262428846922771+262425876204788 +262423284103475 +262428085423330 +262422720914733 +262428482215078 +262421398421149+262429203752465+262420962585362+262426097006227+262422186989801+262424919296574+262424244881577+ 262428584143681 J 6   [ X ( J Y i Fz 75 | }h HG $ ' 9 % 8 I W y  { j Z l & k  520J%491611577474I%491615464736H%491611621660G%491610761640F%491618267665E%491614082766D%491618326681C%491614238641B%491611276154A%491611412862@%491617125857?%491617753408>%491611872103=%491616548810<%491610754825;%491614781243:%4916158211869%4916160083218%4916182656277%4916187350246%4916136718175%4916147785204%4916105851043%4916155044832%4916161055861%4916165372870%491617544847/%491611282203.%491612774240-%491610770672,%491618485154+%491613355070*%491614510562)%491611886848(%491618002551'%491617677321&%491610103235%%491617313576$%491617063760#%491614630414"%491612553311!%491611870568 %491618800363%491613232728%491615003730%491615760400%491610016244%491614618177%491611008032%491612630051%491613100665%491615636255%491612018410%491618805111%491614847060%491613374730%491615233870%491611800841%491617535378%491612422510%491614744706 %491613635555 %491613048444 %491616477780 %491614114650 %491616636046%491615611330%491618021146%491618280245%491617732833%491612852587%491616017806% 491610234020   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!Ia Y e] 9 u -q  a 9  y M   Q U     ) } i %M  = 5u A  1 E+262422175613710J+262423357114350I+262422639028976H+262422522371245G+262428960194803F+262424596080679E+262421739305141D+262424375516628C+262427681639843B+262426553401873A+262423606639421@+262428701216019?+262427142928889>+262428864344994=+262424216353951<+262422002769857;+262423213190895:+2624225801573579+2624273957846928+2624226807073537+2624260733030646+2624215315286445+2624201552014374+2624299062141693+2624226228303962+2624225874958191+2624293704845050+262424561192292/+262427492053975.+262427304453791-+262427614420852,+262423709458148++262425822749312*+262427175547513)+262422267433408(+262429707640013'+262423671885583&+262423909889152%+262429922435547$+262429969117298#+262421474134866"+262420931150338!+262429703943495 +262424506758412+262424024415431+262422432491384+262425161613781+262423055090615+262424921100615+262425493412063+262421026781857+262429176770086+262421204447638+262422124048066+262422615746279+262424372276848+262423066038009+262421390996249+262429975715936+262428056131006+262428846922771+262425876204788 +262423284103475 +262428085423330 +262422720914733 +262428482215078 +262421398421149+262429203752465+262420962585362+262426097006227+262422186989801+262424919296574+262424244881577+ 262428584143681 8J+) 26242217561371052012345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624233571143504916115774743H+% 2624226390289764916154647363G+% 2624225223712454916116216603F+% 2624289601948034916107616403E+% 2624245960806794916182676653D+% 2624217393051414916140827663C+% 2624243755166284916183266813B+% 2624276816398434916142386413A+% 2624265534018734916112761543@+% 2624236066394214916114128623?+% 2624287012160194916171258573>+% 2624271429288894916177534083=+% 2624288643449944916118721033<+% 2624242163539514916165488103;+% 2624220027698574916107548253:+% 26242321319089549161478124339+% 26242258015735749161582118638+% 26242739578469249161600832137+% 26242268070735349161826562736+% 26242607330306449161873502435+% 26242153152864449161367181734+% 26242015520143749161477852033+% 26242990621416949161058510432+% 26242262283039649161550448331+% 26242258749581949161610558630+% 2624293704845054916165372873/+% 2624245611922924916175448473.+% 2624274920539754916112822033-+% 2624273044537914916127742403,+% 2624276144208524916107706723++% 2624237094581484916184851543*+% 2624258227493124916133550703)+% 2624271755475134916145105623(+% 2624222674334084916118868483'+% 2624297076400134916180025513&+% 2624236718855834916176773213%+% 2624239098891524916101032353$+% 2624299224355474916173135763#+% 2624299691172984916170637603"+% 2624214741348664916146304143!+% 2624209311503384916125533113 +% 2624297039434954916118705683+% 2624245067584124916188003633+% 2624240244154314916132327283+% 2624224324913844916150037303+% 2624251616137814916157604003+% 2624230550906154916100162443+% 2624249211006154916146181773+% 2624254934120634916110080323+% 2624210267818574916126300513+% 2624291767700864916131006653+% 2624212044476384916156362553+% 2624221240480664916120184103+% 2624226157462794916188051113+% 2624243722768484916148470603+% 2624230660380094916133747303+% 2624213909962494916152338703+% 2624299757159364916118008413+% 2624280561310064916175353783+% 2624288469227714916124225103 +% 2624258762047884916147447063 +% 2624232841034754916136355553 +% 2624280854233304916130484443 +% 2624227209147334916164777803 +% 2624284822150784916141146503+% 2624213984211494916166360463+% 2624292037524654916156113303+% 2624209625853624916180211463+% 2624260970062274916182802453+% 2624221869898014916177328333+% 2624249192965744916128525873+% 262424244881577491616017806[+%7 3262428584143681491610234020MSC-00-00-00-00-00-002024-11-05 08:56:07