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 ] = i ) y  qM Q 1 9 A M5  Y U    9 ! a a -  E I % u e  m u }+262424967631435J+262423773596844I+262425975444132H+262428666158970G+262420143757020F+262425584949563E+262422191799903D+262422821206602C+262425669663250B+262421846285037A+262424084304913@+262424587844470?+262421083021046>+262420297837807=+262422675581869<+262428725899298;+262421167868057:+2624274517053129+2624299407586958+2624297727201387+2624229662288446+2624248899118855+2624284415187644+2624289094816643+2624218411369102+2624272140657671+2624234825194900+262424166890856/+262420845000871.+262429973115170-+262428612475378,+262424741282090++262422634664125*+262422601190434)+262423140180454(+262420551520508'+262423921925083&+262427413860870%+262422764933683$+262427753321168#+262424084853253"+262429077915509!+262427413481566 +262429114663557+262425901401025+262424635193939+262422829410462+262424641723141+262429420179056+262426137958651+262425839729510+262423781729906+262428611596482+262420224016366+262422144380323+262423874058412+262421637922677+262422706709530+262427028508356+262423241410989+262420047099984+262428175554815 +262425165930255 +262428641843223 +262423324348979 +262422166281765 +262426805948141+262429535867742+262424704784970+262426356736373+262428339474689+262425731726466+262425107251653+ 262424825809863 J  [  & 8 Hy   | $  (h I Wi 7 Z% 96F { G J5 j k l  }z X  Y '  737J%491613415080I%491614530708H%491616588227G%491610352428F%491617285671E%491618032000D%491614365823C%491614011712B%491615787832A%491612628478@%491618244607?%491618084084>%491611653013=%491611521325<%491613405560;%491618560823:%4916106476219%4916140081748%4916144173137%4916170264536%4916125531545%4916116261654%4916186584553%4916162563132%4916113133481%4916166750630%491618340660/%491611556283.%491611853502-%491617527468,%491610616027+%491614118146*%491611185218)%491618462274(%491616834471'%491615625238&%491614403054%%491617431525$%491611447205#%491617685282"%491612101268!%491610377442 %491618225717%491610478234%491610257168%491614477610%491615025683%491616566413%491618336611%491614116700%491618044748%491618642576%491614871724%491616556430%491614600755%491611220801%491615348862%491617363352%491613610184%491612874676%491613172216 %491616661034 %491615334678 %491614046605 %491613828813 %491611304885%491613866580%491615643604%491610782861%491613867701%491618441728%491610754485% 491618667838   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 ] = i ) y  qM Q 1 9 A M5  Y U    9 ! a a -  E I % u e  m u }+262424967631435J+262423773596844I+262425975444132H+262428666158970G+262420143757020F+262425584949563E+262422191799903D+262422821206602C+262425669663250B+262421846285037A+262424084304913@+262424587844470?+262421083021046>+262420297837807=+262422675581869<+262428725899298;+262421167868057:+2624274517053129+2624299407586958+2624297727201387+2624229662288446+2624248899118855+2624284415187644+2624289094816643+2624218411369102+2624272140657671+2624234825194900+262424166890856/+262420845000871.+262429973115170-+262428612475378,+262424741282090++262422634664125*+262422601190434)+262423140180454(+262420551520508'+262423921925083&+262427413860870%+262422764933683$+262427753321168#+262424084853253"+262429077915509!+262427413481566 +262429114663557+262425901401025+262424635193939+262422829410462+262424641723141+262429420179056+262426137958651+262425839729510+262423781729906+262428611596482+262420224016366+262422144380323+262423874058412+262421637922677+262422706709530+262427028508356+262423241410989+262420047099984+262428175554815 +262425165930255 +262428641843223 +262423324348979 +262422166281765 +262426805948141+262429535867742+262424704784970+262426356736373+262428339474689+262425731726466+262425107251653+ 262424825809863 8J+) 26242496763143573712345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624237735968444916134150803H+% 2624259754441324916145307083G+% 2624286661589704916165882273F+% 2624201437570204916103524283E+% 2624255849495634916172856713D+% 2624221917999034916180320003C+% 2624228212066024916143658233B+% 2624256696632504916140117123A+% 2624218462850374916157878323@+% 2624240843049134916126284783?+% 2624245878444704916182446073>+% 2624210830210464916180840843=+% 2624202978378074916116530133<+% 2624226755818694916115213253;+% 2624287258992984916134055603:+% 26242116786805749161856082339+% 26242745170531249161064762138+% 26242994075869549161400817437+% 26242977272013849161441731336+% 26242296622884449161702645335+% 26242488991188549161255315434+% 26242844151876449161162616533+% 26242890948166449161865845532+% 26242184113691049161625631331+% 26242721406576749161131334830+% 2624234825194904916166750633/+% 2624241668908564916183406603.+% 2624208450008714916115562833-+% 2624299731151704916118535023,+% 2624286124753784916175274683++% 2624247412820904916106160273*+% 2624226346641254916141181463)+% 2624226011904344916111852183(+% 2624231401804544916184622743'+% 2624205515205084916168344713&+% 2624239219250834916156252383%+% 2624274138608704916144030543$+% 2624227649336834916174315253#+% 2624277533211684916114472053"+% 2624240848532534916176852823!+% 2624290779155094916121012683 +% 2624274134815664916103774423+% 2624291146635574916182257173+% 2624259014010254916104782343+% 2624246351939394916102571683+% 2624228294104624916144776103+% 2624246417231414916150256833+% 2624294201790564916165664133+% 2624261379586514916183366113+% 2624258397295104916141167003+% 2624237817299064916180447483+% 2624286115964824916186425763+% 2624202240163664916148717243+% 2624221443803234916165564303+% 2624238740584124916146007553+% 2624216379226774916112208013+% 2624227067095304916153488623+% 2624270285083564916173633523+% 2624232414109894916136101843+% 2624200470999844916128746763 +% 2624281755548154916131722163 +% 2624251659302554916166610343 +% 2624286418432234916153346783 +% 2624233243489794916140466053 +% 2624221662817654916138288133+% 2624268059481414916113048853+% 2624295358677424916138665803+% 2624247047849704916156436043+% 2624263567363734916107828613+% 2624283394746894916138677013+% 2624257317264664916184417283+% 262425107251653491610754485[+%7 3262424825809863491618667838MSC-00-00-00-00-00-002024-11-04 16:02:59