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 99 e ]   Q Y i a u  A U %au E   } q 1 ! - M5  = y )  I m M 9 +262429677995380J+262429661629469I+262421423860971H+262421524522004G+262426592894931F+262423882799725E+262428555783043D+262423623022725C+262425195248195B+262426643000984A+262420607037097@+262422353711507?+262429136544837>+262428404901860=+262420981771810<+262420081635860;+262428720172208:+2624244792432219+2624255118324898+2624293551987307+2624226255564666+2624265911902395+2624217715633304+2624249166624233+2624250028394762+2624268052738071+2624224364960580+262422647937168/+262421241681082.+262425173460763-+262420382549732,+262420927283641++262427313182568*+262427843387351)+262425610984710(+262424241414322'+262429883716213&+262422763877082%+262426457943862$+262423679424819#+262421186828801"+262429625492291!+262428546834604 +262427073925206+262424505385676+262422184558015+262423606989684+262420169587492+262421382783753+262429385902836+262426770185735+262427820875663+262429398084131+262420273163466+262425680599345+262426270440687+262421441520341+262426949594035+262428860726772+262423603778247+262429028364156+262425734768248 +262422762058314 +262422775134333 +262420030087769 +262427507357622 +262422836452031+262422912385876+262423840100905+262428535031367+262428179978886+262420359372948+262429158801091+ 262420975507224 J W {X Y h H [ 6  8  Z &  G I 9  k % i5 $ (z  F } 7  | ly '  j J115J%491616062644I%491613552605H%491618717147G%491610561121F%491618317448E%491617581061D%491610627134C%491612052624B%491618374384A%491615747711@%491618712275?%491610485374>%491611005480=%491613602515<%491617023847;%491618480244:%4916113044369%4916134085288%4916115661727%4916137334846%4916181827645%4916165477654%4916154818263%4916185665472%4916101387261%4916111576360%491611885587/%491616207540.%491614348081-%491612231376,%491611602880+%491617716628*%491610503727)%491610470468(%491618705205'%491610302882&%491615084668%%491616735555$%491610721226#%491611325548"%491616636217!%491617785564 %491613337562%491618688080%491611343157%491614565281%491610884422%491612501005%491610373123%491615366354%491616086153%491613647574%491615667372%491617706553%491612042086%491612024857%491617885053%491613724270%491611238714%491616355727%491615733638 %491615368014 %491617028627 %491610282001 %491610503148 %491618324764%491611345437%491613221766%491614810017%491611646366%491615713038%491615074222% 491617383704   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 99 e ]   Q Y i a u  A U %au E   } q 1 ! - M5  = y )  I m M 9 +262429677995380J+262429661629469I+262421423860971H+262421524522004G+262426592894931F+262423882799725E+262428555783043D+262423623022725C+262425195248195B+262426643000984A+262420607037097@+262422353711507?+262429136544837>+262428404901860=+262420981771810<+262420081635860;+262428720172208:+2624244792432219+2624255118324898+2624293551987307+2624226255564666+2624265911902395+2624217715633304+2624249166624233+2624250028394762+2624268052738071+2624224364960580+262422647937168/+262421241681082.+262425173460763-+262420382549732,+262420927283641++262427313182568*+262427843387351)+262425610984710(+262424241414322'+262429883716213&+262422763877082%+262426457943862$+262423679424819#+262421186828801"+262429625492291!+262428546834604 +262427073925206+262424505385676+262422184558015+262423606989684+262420169587492+262421382783753+262429385902836+262426770185735+262427820875663+262429398084131+262420273163466+262425680599345+262426270440687+262421441520341+262426949594035+262428860726772+262423603778247+262429028364156+262425734768248 +262422762058314 +262422775134333 +262420030087769 +262427507357622 +262422836452031+262422912385876+262423840100905+262428535031367+262428179978886+262420359372948+262429158801091+ 262420975507224 8J+) 26242967799538011512345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624296616294694916160626443H+% 2624214238609714916135526053G+% 2624215245220044916187171473F+% 2624265928949314916105611213E+% 2624238827997254916183174483D+% 2624285557830434916175810613C+% 2624236230227254916106271343B+% 2624251952481954916120526243A+% 2624266430009844916183743843@+% 2624206070370974916157477113?+% 2624223537115074916187122753>+% 2624291365448374916104853743=+% 2624284049018604916110054803<+% 2624209817718104916136025153;+% 2624200816358604916170238473:+% 26242872017220849161848024439+% 26242447924322149161130443638+% 26242551183248949161340852837+% 26242935519873049161156617236+% 26242262555646649161373348435+% 26242659119023949161818276434+% 26242177156333049161654776533+% 26242491666242349161548182632+% 26242500283947649161856654731+% 26242680527380749161013872630+% 2624224364960584916111576363/+% 2624226479371684916118855873.+% 2624212416810824916162075403-+% 2624251734607634916143480813,+% 2624203825497324916122313763++% 2624209272836414916116028803*+% 2624273131825684916177166283)+% 2624278433873514916105037273(+% 2624256109847104916104704683'+% 2624242414143224916187052053&+% 2624298837162134916103028823%+% 2624227638770824916150846683$+% 2624264579438624916167355553#+% 2624236794248194916107212263"+% 2624211868288014916113255483!+% 2624296254922914916166362173 +% 2624285468346044916177855643+% 2624270739252064916133375623+% 2624245053856764916186880803+% 2624221845580154916113431573+% 2624236069896844916145652813+% 2624201695874924916108844223+% 2624213827837534916125010053+% 2624293859028364916103731233+% 2624267701857354916153663543+% 2624278208756634916160861533+% 2624293980841314916136475743+% 2624202731634664916156673723+% 2624256805993454916177065533+% 2624262704406874916120420863+% 2624214415203414916120248573+% 2624269495940354916178850533+% 2624288607267724916137242703+% 2624236037782474916112387143+% 2624290283641564916163557273 +% 2624257347682484916157336383 +% 2624227620583144916153680143 +% 2624227751343334916170286273 +% 2624200300877694916102820013 +% 2624275073576224916105031483+% 2624228364520314916183247643+% 2624229123858764916113454373+% 2624238401009054916132217663+% 2624285350313674916148100173+% 2624281799788864916116463663+% 2624203593729484916157130383+% 262429158801091491615074222[+%7 3262420975507224491617383704MSC-00-00-00-00-00-002024-06-13 08:26:43