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 9u Y 9 A y a   i5 ! )I  - U q  } m  % Q9 Ma  E M e  u 1   =]+262420186228126J+262427448694306I+262421316713666H+262428485338334G+262423257939469F+262424450228363E+262429800056342D+262427215527905C+262421933188518B+262429713042138A+262424968200739@+262423450550147?+262423045008652>+262429931675059=+262426366047944<+262427878007379;+262420676315794:+2624267760710089+2624234174310298+2624277226063697+2624240225255196+2624260250253515+2624249063807724+2624245801518923+2624223282962692+2624239199565181+2624205701517710+262423966959199/+262421998320215.+262424838445055-+262429032255155,+262426872728156++262421565965115*+262425057476047)+262424984143447(+262429149834708'+262428088384400&+262427395137090%+262428775920925$+262427437089411#+262420132892534"+262424908952331!+262428917457076 +262426044088655+262427212132934+262426140950568+262427879191466+262420670248730+262424122530639+262421647867304+262422923504016+262422142750456+262423136529029+262429981321171+262424058298989+262425252921249+262420051957918+262421660091764+262429086433663+262429012648053+262423808842347+262428372749206 +262420596510590 +262425768604107 +262426757079849 +262427062142052 +262427117253922+262420023507360+262423660455142+262422478146313+262425165843450+262421853314205+262423511799769+ 262425688081118 J  X   y k [ Z J$   | G ( & %6 I5F  }z 9 j 8  '  l Y 7i    H hW {   715J%491614120714I%491616112504H%491612582867G%491612200614F%491616608886E%491615810531D%491614507373C%491617773445B%491613034347A%491617280585@%491615673648?%491613701430>%491612374547=%491616333150<%491618461821;%491616411375:%4916162417089%4916152751728%4916125382477%4916117626216%4916135674485%4916102872124%4916177178503%4916135014402%4916162315711%4916174214840%491617476425/%491611530275.%491610548454-%491610670780,%491614134158+%491617081283*%491617666616)%491617028845(%491616188888'%491618148120&%491616443081%%491614701403$%491618403443#%491615727055"%491618247546!%491618778005 %491611166886%491611431405%491618628438%491614723023%491615070220%491613758276%491610585512%491617174258%491616026327%491618568562%491613526675%491617382653%491612301672%491616523655%491610821417%491613405314%491618837771%491613345715%491612610801 %491615365538 %491615534206 %491618061585 %491618045327 %491611623875%491617457140%491615728361%491611565201%491615772485%491617605138%491614405036% 491610546473   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 9u Y 9 A y a   i5 ! )I  - U q  } m  % Q9 Ma  E M e  u 1   =]+262420186228126J+262427448694306I+262421316713666H+262428485338334G+262423257939469F+262424450228363E+262429800056342D+262427215527905C+262421933188518B+262429713042138A+262424968200739@+262423450550147?+262423045008652>+262429931675059=+262426366047944<+262427878007379;+262420676315794:+2624267760710089+2624234174310298+2624277226063697+2624240225255196+2624260250253515+2624249063807724+2624245801518923+2624223282962692+2624239199565181+2624205701517710+262423966959199/+262421998320215.+262424838445055-+262429032255155,+262426872728156++262421565965115*+262425057476047)+262424984143447(+262429149834708'+262428088384400&+262427395137090%+262428775920925$+262427437089411#+262420132892534"+262424908952331!+262428917457076 +262426044088655+262427212132934+262426140950568+262427879191466+262420670248730+262424122530639+262421647867304+262422923504016+262422142750456+262423136529029+262429981321171+262424058298989+262425252921249+262420051957918+262421660091764+262429086433663+262429012648053+262423808842347+262428372749206 +262420596510590 +262425768604107 +262426757079849 +262427062142052 +262427117253922+262420023507360+262423660455142+262422478146313+262425165843450+262421853314205+262423511799769+ 262425688081118 8J+) 26242018622812671512345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624274486943064916141207143H+% 2624213167136664916161125043G+% 2624284853383344916125828673F+% 2624232579394694916122006143E+% 2624244502283634916166088863D+% 2624298000563424916158105313C+% 2624272155279054916145073733B+% 2624219331885184916177734453A+% 2624297130421384916130343473@+% 2624249682007394916172805853?+% 2624234505501474916156736483>+% 2624230450086524916137014303=+% 2624299316750594916123745473<+% 2624263660479444916163331503;+% 2624278780073794916184618213:+% 26242067631579449161641137539+% 26242677607100849161624170838+% 26242341743102949161527517237+% 26242772260636949161253824736+% 26242402252551949161176262135+% 26242602502535149161356744834+% 26242490638077249161028721233+% 26242458015189249161771785032+% 26242232829626949161350144031+% 26242391995651849161623157130+% 2624205701517714916174214843/+% 2624239669591994916174764253.+% 2624219983202154916115302753-+% 2624248384450554916105484543,+% 2624290322551554916106707803++% 2624268727281564916141341583*+% 2624215659651154916170812833)+% 2624250574760474916176666163(+% 2624249841434474916170288453'+% 2624291498347084916161888883&+% 2624280883844004916181481203%+% 2624273951370904916164430813$+% 2624287759209254916147014033#+% 2624274370894114916184034433"+% 2624201328925344916157270553!+% 2624249089523314916182475463 +% 2624289174570764916187780053+% 2624260440886554916111668863+% 2624272121329344916114314053+% 2624261409505684916186284383+% 2624278791914664916147230233+% 2624206702487304916150702203+% 2624241225306394916137582763+% 2624216478673044916105855123+% 2624229235040164916171742583+% 2624221427504564916160263273+% 2624231365290294916185685623+% 2624299813211714916135266753+% 2624240582989894916173826533+% 2624252529212494916123016723+% 2624200519579184916165236553+% 2624216600917644916108214173+% 2624290864336634916134053143+% 2624290126480534916188377713+% 2624238088423474916133457153 +% 2624283727492064916126108013 +% 2624205965105904916153655383 +% 2624257686041074916155342063 +% 2624267570798494916180615853 +% 2624270621420524916180453273+% 2624271172539224916116238753+% 2624200235073604916174571403+% 2624236604551424916157283613+% 2624224781463134916115652013+% 2624251658434504916157724853+% 2624218533142054916176051383+% 262423511799769491614405036[+%7 3262425688081118491610546473MSC-00-00-00-00-00-002024-06-10 05:56:10