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 9     u% i9  m u 1 M A y U   e   aq YI  ) } = Q5 -M ] E! a+262420012237621J+262422900096894I+262425489819792H+262422614009463G+262428525664310F+262424642094673E+262421969681066D+262422054044335C+262426364474217B+262424758990619A+262420918543088@+262420056831106?+262426921138350>+262427621840903=+262428028018166<+262425309894907;+262423585750081:+2624273803024799+2624214491712768+2624234064307737+2624202235049856+2624298048986575+2624281892041814+2624253106663633+2624268270623572+2624284755397201+2624235174774410+262423960849853/+262422175180391.+262427481832155-+262425330316049,+262426430011833++262427487317377*+262424563628902)+262424428262730(+262424122814797'+262428344934211&+262420205709201%+262422832710891$+262428955126449#+262426685615091"+262422474145319!+262421223823442 +262422257024337+262425274512079+262427349894337+262427896664636+262423190204608+262424861284776+262422422258317+262429180090850+262428092929440+262426795733640+262428594253825+262425720964659+262421167473921+262427241489010+262425336929416+262424688732961+262422334684552+262426854991250+262428766603727 +262427331381830 +262421438878661 +262422195160940 +262428513384225 +262429984880002+262421249322611+262424926750826+262427849181837+262420704640537+262423985105257+262424897109045+ 262420452918412 J 6    { ' } lh %  yW  |  & kG (Fi H  8 X Jz5 I 9 Y j$ 7 [  Z 197J%491615128316I%491617278240H%491616260022G%491618548286F%491612341230E%491612161312D%491612774373C%491612885086B%491618264171A%491618872564@%491611610415?%491613467187>%491617672026=%491615440007<%491612821346;%491611846281:%4916155432069%4916171838658%4916188626367%4916143123506%4916137085445%4916173222544%4916158107503%4916161616512%4916125106011%4916113181330%491610546834/%491617336570.%491618626607-%491611207510,%491614240516+%491618070006*%491615421822)%491617628377(%491617746783'%491611715353&%491614076263%%491613755710$%491617664820#%491617682218"%491611783332!%491611842277 %491611456264%491611608211%491618580623%491612735650%491610883422%491614326270%491616256471%491615238731%491616340257%491615670028%491612331176%491616510878%491614406372%491611320283%491618072407%491613537260%491614325430%491617641850%491617883540 %491617167265 %491615184630 %491613383642 %491612462600 %491613227132%491616747775%491614147614%491614771341%491613747261%491610845676%491617823011% 491612305855   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 9     u% i9  m u 1 M A y U   e   aq YI  ) } = Q5 -M ] E! a+262420012237621J+262422900096894I+262425489819792H+262422614009463G+262428525664310F+262424642094673E+262421969681066D+262422054044335C+262426364474217B+262424758990619A+262420918543088@+262420056831106?+262426921138350>+262427621840903=+262428028018166<+262425309894907;+262423585750081:+2624273803024799+2624214491712768+2624234064307737+2624202235049856+2624298048986575+2624281892041814+2624253106663633+2624268270623572+2624284755397201+2624235174774410+262423960849853/+262422175180391.+262427481832155-+262425330316049,+262426430011833++262427487317377*+262424563628902)+262424428262730(+262424122814797'+262428344934211&+262420205709201%+262422832710891$+262428955126449#+262426685615091"+262422474145319!+262421223823442 +262422257024337+262425274512079+262427349894337+262427896664636+262423190204608+262424861284776+262422422258317+262429180090850+262428092929440+262426795733640+262428594253825+262425720964659+262421167473921+262427241489010+262425336929416+262424688732961+262422334684552+262426854991250+262428766603727 +262427331381830 +262421438878661 +262422195160940 +262428513384225 +262429984880002+262421249322611+262424926750826+262427849181837+262420704640537+262423985105257+262424897109045+ 262420452918412 8J+) 26242001223762119712345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624229000968944916151283163H+% 2624254898197924916172782403G+% 2624226140094634916162600223F+% 2624285256643104916185482863E+% 2624246420946734916123412303D+% 2624219696810664916121613123C+% 2624220540443354916127743733B+% 2624263644742174916128850863A+% 2624247589906194916182641713@+% 2624209185430884916188725643?+% 2624200568311064916116104153>+% 2624269211383504916134671873=+% 2624276218409034916176720263<+% 2624280280181664916154400073;+% 2624253098949074916128213463:+% 26242358575008149161184628139+% 26242738030247949161554320638+% 26242144917127649161718386537+% 26242340643077349161886263636+% 26242022350498549161431235035+% 26242980489865749161370854434+% 26242818920418149161732225433+% 26242531066636349161581075032+% 26242682706235749161616165131+% 26242847553972049161251060130+% 2624235174774414916113181333/+% 2624239608498534916105468343.+% 2624221751803914916173365703-+% 2624274818321554916186266073,+% 2624253303160494916112075103++% 2624264300118334916142405163*+% 2624274873173774916180700063)+% 2624245636289024916154218223(+% 2624244282627304916176283773'+% 2624241228147974916177467833&+% 2624283449342114916117153533%+% 2624202057092014916140762633$+% 2624228327108914916137557103#+% 2624289551264494916176648203"+% 2624266856150914916176822183!+% 2624224741453194916117833323 +% 2624212238234424916118422773+% 2624222570243374916114562643+% 2624252745120794916116082113+% 2624273498943374916185806233+% 2624278966646364916127356503+% 2624231902046084916108834223+% 2624248612847764916143262703+% 2624224222583174916162564713+% 2624291800908504916152387313+% 2624280929294404916163402573+% 2624267957336404916156700283+% 2624285942538254916123311763+% 2624257209646594916165108783+% 2624211674739214916144063723+% 2624272414890104916113202833+% 2624253369294164916180724073+% 2624246887329614916135372603+% 2624223346845524916143254303+% 2624268549912504916176418503 +% 2624287666037274916178835403 +% 2624273313818304916171672653 +% 2624214388786614916151846303 +% 2624221951609404916133836423 +% 2624285133842254916124626003+% 2624299848800024916132271323+% 2624212493226114916167477753+% 2624249267508264916141476143+% 2624278491818374916147713413+% 2624207046405374916137472613+% 2624239851052574916108456763+% 262424897109045491617823011[+%7 3262420452918412491612305855MSC-00-00-00-00-00-002024-11-01 08:56:06