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 ) a ] -   ! E% m M Q y M I i 5  Y  U  } u a 1 A  u q   e 9 +262429792375136J+262424122800872I+262420760620874H+262428431374340G+262425365214776F+262428392951572E+262426920514313D+262424911714599C+262429992326495B+262420623003798A+262429240134897@+262429232021714?+262420544552632>+262420037146371=+262422641121201<+262429460744438;+262423911444831:+2624223026302899+2624285302979408+2624201932704597+2624295400071216+2624206633915135+2624224556517424+2624211986729083+2624259561684122+2624211936363311+2624279989594150+262425672214671/+262424800592627.+262426828373825-+262427218939794,+262426610514123++262424774656322*+262425851436580)+262428034713311(+262421539258861'+262426550401757&+262424140264900%+262427439816847$+262421729173379#+262425249886904"+262422407047457!+262425065580141 +262426746202601+262421662811562+262420877992987+262427969607106+262423707341904+262421216710396+262425332227245+262421702825736+262425036347738+262424398950538+262420981524186+262429220494430+262424697419284+262425175965504+262423053671529+262425658119880+262422516248530+262420215307208+262428425696288 +262429104959846 +262421796181248 +262420303530670 +262422563980499 +262427428770665+262427089500736+262427524978985+262420126274529+262421691148882+262421253192399+262426197934688+ 262424550194317 J  ( Ii G  Z  l } 7  & F '   Y k 8 | % H z 9XW y5 { j h 6 J [ $433J%491610754515I%491616707301H%491618306103G%491618448014F%491612705165E%491612843043D%491616044855C%491616636076B%491617281036A%491614126646@%491610630751?%491616311185>%491612156078=%491613771617<%491614468016;%491614161168:%4916154410529%4916114461358%4916125138867%4916150060366%4916157575005%4916186020614%4916100621653%4916125260572%4916145650211%4916155830610%491616462846/%491614186354.%491612487831-%491613633887,%491613722423+%491613578513*%491616185353)%491614766801(%491617845062'%491617743136&%491610023252%%491614877134$%491617815666#%491613707486"%491617867013!%491612313070 %491618120303%491611023444%491612775026%491616142544%491618244618%491612200735%491617127353%491611650427%491616438504%491610564454%491613373451%491610817810%491613301488%491613564086%491615525270%491611717377%491618401472%491612633044%491618826674 %491617674508 %491614107475 %491617278713 %491617876120 %491617432486%491618417322%491611778228%491610107754%491610761483%491610522605%491611874237% 491614451586   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 ) a ] -   ! E% m M Q y M I i 5  Y  U  } u a 1 A  u q   e 9 +262429792375136J+262424122800872I+262420760620874H+262428431374340G+262425365214776F+262428392951572E+262426920514313D+262424911714599C+262429992326495B+262420623003798A+262429240134897@+262429232021714?+262420544552632>+262420037146371=+262422641121201<+262429460744438;+262423911444831:+2624223026302899+2624285302979408+2624201932704597+2624295400071216+2624206633915135+2624224556517424+2624211986729083+2624259561684122+2624211936363311+2624279989594150+262425672214671/+262424800592627.+262426828373825-+262427218939794,+262426610514123++262424774656322*+262425851436580)+262428034713311(+262421539258861'+262426550401757&+262424140264900%+262427439816847$+262421729173379#+262425249886904"+262422407047457!+262425065580141 +262426746202601+262421662811562+262420877992987+262427969607106+262423707341904+262421216710396+262425332227245+262421702825736+262425036347738+262424398950538+262420981524186+262429220494430+262424697419284+262425175965504+262423053671529+262425658119880+262422516248530+262420215307208+262428425696288 +262429104959846 +262421796181248 +262420303530670 +262422563980499 +262427428770665+262427089500736+262427524978985+262420126274529+262421691148882+262421253192399+262426197934688+ 262424550194317 8J+) 26242979237513643312345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624241228008724916107545153H+% 2624207606208744916167073013G+% 2624284313743404916183061033F+% 2624253652147764916184480143E+% 2624283929515724916127051653D+% 2624269205143134916128430433C+% 2624249117145994916160448553B+% 2624299923264954916166360763A+% 2624206230037984916172810363@+% 2624292401348974916141266463?+% 2624292320217144916106307513>+% 2624205445526324916163111853=+% 2624200371463714916121560783<+% 2624226411212014916137716173;+% 2624294607444384916144680163:+% 26242391144483149161416116839+% 26242230263028949161544105238+% 26242853029794049161144613537+% 26242019327045949161251388636+% 26242954000712149161500603635+% 26242066339151349161575750034+% 26242245565174249161860206133+% 26242119867290849161006216532+% 26242595616841249161252605731+% 26242119363633149161456502130+% 2624279989594154916155830613/+% 2624256722146714916164628463.+% 2624248005926274916141863543-+% 2624268283738254916124878313,+% 2624272189397944916136338873++% 2624266105141234916137224233*+% 2624247746563224916135785133)+% 2624258514365804916161853533(+% 2624280347133114916147668013'+% 2624215392588614916178450623&+% 2624265504017574916177431363%+% 2624241402649004916100232523$+% 2624274398168474916148771343#+% 2624217291733794916178156663"+% 2624252498869044916137074863!+% 2624224070474574916178670133 +% 2624250655801414916123130703+% 2624267462026014916181203033+% 2624216628115624916110234443+% 2624208779929874916127750263+% 2624279696071064916161425443+% 2624237073419044916182446183+% 2624212167103964916122007353+% 2624253322272454916171273533+% 2624217028257364916116504273+% 2624250363477384916164385043+% 2624243989505384916105644543+% 2624209815241864916133734513+% 2624292204944304916108178103+% 2624246974192844916133014883+% 2624251759655044916135640863+% 2624230536715294916155252703+% 2624256581198804916117173773+% 2624225162485304916184014723+% 2624202153072084916126330443 +% 2624284256962884916188266743 +% 2624291049598464916176745083 +% 2624217961812484916141074753 +% 2624203035306704916172787133 +% 2624225639804994916178761203+% 2624274287706654916174324863+% 2624270895007364916184173223+% 2624275249789854916117782283+% 2624201262745294916101077543+% 2624216911488824916107614833+% 2624212531923994916105226053+% 262426197934688491611874237[+%7 3262424550194317491614451586MSC-00-00-00-00-00-002024-10-13 08:25:59