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 -  5 u q e  1 I = a !  9  9 i E  M aM } Y ]  y ) A U Q u+262425760474469J+262427123627921I+262424565144134H+262429732186182G+262426829633488F+262424811474585E+262424965185790D+262425266662336C+262427155851183B+262424157621591A+262423701293168@+262421505244110?+262428782276526>+262424456869346=+262429718689662<+262422312862420;+262428519975292:+2624294579649409+2624204270567988+2624271543144317+2624222485571386+2624235267209185+2624256577365964+2624245966443023+2624206557632462+2624204798392901+2624292592187820+262429663845511/+262425967087528.+262428161137180-+262421237463081,+262423249722006++262425042483946*+262420931889923)+262426783245142(+262420626704630'+262428292026187&+262423034921740%+262423562981458$+262426679601380#+262428173166245"+262420370378097!+262420241613050 +262420410219425+262425755190839+262429330169313+262420916770735+262420439577620+262428459105475+262428287408815+262424635792937+262421211297091+262423996451629+262428383979809+262422309594597+262425543361774+262424919104165+262426156232044+262422472111968+262426496640595+262426807611843+262423978528805 +262428482549450 +262420232882193 +262425289953702 +262428120221740 +262427550435681+262422043256577+262422844823432+262426421433989+262425702082575+262429146456910+262424836034613+ 262423782047952 J Jz  %  Y H FXy 7h  [ 86  5 I |i }W & $ l j  { 9 Z  (  'G k 744J%491617801182I%491617530346H%491610078877G%491613024253F%491616433178E%491615102060D%491618165838C%491613674346B%491611467150A%491611405662@%491611120355?%491616287013>%491617746373=%491613881203<%491616081188;%491618172244:%4916133063779%4916146572288%4916177088367%4916186788406%4916148114025%4916137374074%4916134463123%4916120743332%4916171657801%4916180078860%491615700443/%491614631176.%491612664180-%491613461073,%491616080806+%491612123073*%491611366424)%491611275132(%491616831244'%491617424224&%491610236457%%491610467573$%491611233210#%491610672163"%491615635200!%491610634847 %491613836720%491611025165%491611310407%491610548658%491613421763%491618201566%491611876727%491614871374%491610157861%491616125187%491617420043%491616270675%491617286352%491614840281%491612147485%491612168628%491610606546%491618024575%491616262050 %491614023033 %491611634575 %491615545650 %491612460783 %491612060048%491615357561%491612503424%491617753622%491610241645%491617188273%491614447264% 491616748426   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 -  5 u q e  1 I = a !  9  9 i E  M aM } Y ]  y ) A U Q u+262425760474469J+262427123627921I+262424565144134H+262429732186182G+262426829633488F+262424811474585E+262424965185790D+262425266662336C+262427155851183B+262424157621591A+262423701293168@+262421505244110?+262428782276526>+262424456869346=+262429718689662<+262422312862420;+262428519975292:+2624294579649409+2624204270567988+2624271543144317+2624222485571386+2624235267209185+2624256577365964+2624245966443023+2624206557632462+2624204798392901+2624292592187820+262429663845511/+262425967087528.+262428161137180-+262421237463081,+262423249722006++262425042483946*+262420931889923)+262426783245142(+262420626704630'+262428292026187&+262423034921740%+262423562981458$+262426679601380#+262428173166245"+262420370378097!+262420241613050 +262420410219425+262425755190839+262429330169313+262420916770735+262420439577620+262428459105475+262428287408815+262424635792937+262421211297091+262423996451629+262428383979809+262422309594597+262425543361774+262424919104165+262426156232044+262422472111968+262426496640595+262426807611843+262423978528805 +262428482549450 +262420232882193 +262425289953702 +262428120221740 +262427550435681+262422043256577+262422844823432+262426421433989+262425702082575+262429146456910+262424836034613+ 262423782047952 8J+) 26242576047446974412345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624271236279214916178011823H+% 2624245651441344916175303463G+% 2624297321861824916100788773F+% 2624268296334884916130242533E+% 2624248114745854916164331783D+% 2624249651857904916151020603C+% 2624252666623364916181658383B+% 2624271558511834916136743463A+% 2624241576215914916114671503@+% 2624237012931684916114056623?+% 2624215052441104916111203553>+% 2624287822765264916162870133=+% 2624244568693464916177463733<+% 2624297186896624916138812033;+% 2624223128624204916160811883:+% 26242851997529249161817224439+% 26242945796494049161330637738+% 26242042705679849161465722837+% 26242715431443149161770883636+% 26242224855713849161867884035+% 26242352672091849161481140234+% 26242565773659649161373740733+% 26242459664430249161344631232+% 26242065576324649161207433331+% 26242047983929049161716578030+% 2624292592187824916180078863/+% 2624296638455114916157004433.+% 2624259670875284916146311763-+% 2624281611371804916126641803,+% 2624212374630814916134610733++% 2624232497220064916160808063*+% 2624250424839464916121230733)+% 2624209318899234916113664243(+% 2624267832451424916112751323'+% 2624206267046304916168312443&+% 2624282920261874916174242243%+% 2624230349217404916102364573$+% 2624235629814584916104675733#+% 2624266796013804916112332103"+% 2624281731662454916106721633!+% 2624203703780974916156352003 +% 2624202416130504916106348473+% 2624204102194254916138367203+% 2624257551908394916110251653+% 2624293301693134916113104073+% 2624209167707354916105486583+% 2624204395776204916134217633+% 2624284591054754916182015663+% 2624282874088154916118767273+% 2624246357929374916148713743+% 2624212112970914916101578613+% 2624239964516294916161251873+% 2624283839798094916174200433+% 2624223095945974916162706753+% 2624255433617744916172863523+% 2624249191041654916148402813+% 2624261562320444916121474853+% 2624224721119684916121686283+% 2624264966405954916106065463+% 2624268076118434916180245753 +% 2624239785288054916162620503 +% 2624284825494504916140230333 +% 2624202328821934916116345753 +% 2624252899537024916155456503 +% 2624281202217404916124607833+% 2624275504356814916120600483+% 2624220432565774916153575613+% 2624228448234324916125034243+% 2624264214339894916177536223+% 2624257020825754916102416453+% 2624291464569104916171882733+% 262424836034613491614447264[+%7 3262423782047952491616748426MSC-00-00-00-00-00-002024-06-26 12:03:31