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 ! a i  %a Y -  95 ) U   QI  =  y   u] A MM   } q9 eu 1 E m+262422414760500J+262427142115515I+262420272415049H+262426218938596G+262421062286039F+262424475442840E+262427729426890D+262425157576563C+262429304698062B+262420049041129A+262423714670146@+262425865857487?+262422782437708>+262424483729720=+262423848798292<+262428682952200;+262424801719963:+2624275363393149+2624210625045468+2624245040098197+2624236206470606+2624218352752505+2624290885571264+2624203674682063+2624222263823422+2624222040754491+2624268652227450+262423198570147/+262420314224777.+262427957295601-+262424425228212,+262424470610406++262429080020447*+262427675756966)+262426979259191(+262420720950944'+262428389281348&+262423453223475%+262429118765521$+262429533176212#+262421728478156"+262429551391107!+262425408735609 +262422105428156+262424175410925+262428794276222+262422750302467+262426019647709+262425342955136+262424552670494+262420198741676+262422549512194+262424056589586+262426397824550+262428421794765+262428244032780+262427723549396+262423250057913+262420434781601+262421222327273+262427999741930+262425614774391 +262423300174475 +262421296509602 +262428584730671 +262427200749510 +262421434469966+262428783107141+262421101088285+262427805315935+262423376061776+262426623215632+262428736696762+ 262424177006225 J X  9 F &  Y6 j } h 5 k 8 Z J [ ( G y  7 H W { 'i% |$z l  I 650J%491614705113I%491610637734H%491614383644G%491614533313F%491618545427E%491612745415D%491615481068C%491611237022B%491617268472A%491611353343@%491611412061?%491611283037>%491615533320=%491610366683<%491613353663;%491617574501:%4916138544879%4916187101678%4916143513187%4916137333476%4916183753085%4916112240514%4916160031473%4916186341582%4916155514451%4916175247800%491616873418/%491610147801.%491610172674-%491616838623,%491611386808+%491617010201*%491617140732)%491611615458(%491611824106'%491617472622&%491611508546%%491614085765$%491611117435#%491617014003"%491614138702!%491613348432 %491613513246%491613123535%491613747631%491618013102%491611805757%491615632471%491610236367%491617723114%491618543074%491613172515%491612041475%491611623023%491617406043%491616264238%491614412616%491614610401%491614782014%491611567284%491618446068 %491613714345 %491611216713 %491617354701 %491613421363 %491616836757%491614072737%491615715210%491612080165%491616144135%491618648802%491613256108% 491614408570   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 ! a i  %a Y -  95 ) U   QI  =  y   u] A MM   } q9 eu 1 E m+262422414760500J+262427142115515I+262420272415049H+262426218938596G+262421062286039F+262424475442840E+262427729426890D+262425157576563C+262429304698062B+262420049041129A+262423714670146@+262425865857487?+262422782437708>+262424483729720=+262423848798292<+262428682952200;+262424801719963:+2624275363393149+2624210625045468+2624245040098197+2624236206470606+2624218352752505+2624290885571264+2624203674682063+2624222263823422+2624222040754491+2624268652227450+262423198570147/+262420314224777.+262427957295601-+262424425228212,+262424470610406++262429080020447*+262427675756966)+262426979259191(+262420720950944'+262428389281348&+262423453223475%+262429118765521$+262429533176212#+262421728478156"+262429551391107!+262425408735609 +262422105428156+262424175410925+262428794276222+262422750302467+262426019647709+262425342955136+262424552670494+262420198741676+262422549512194+262424056589586+262426397824550+262428421794765+262428244032780+262427723549396+262423250057913+262420434781601+262421222327273+262427999741930+262425614774391 +262423300174475 +262421296509602 +262428584730671 +262427200749510 +262421434469966+262428783107141+262421101088285+262427805315935+262423376061776+262426623215632+262428736696762+ 262424177006225 8J+) 26242241476050065012345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624271421155154916147051133H+% 2624202724150494916106377343G+% 2624262189385964916143836443F+% 2624210622860394916145333133E+% 2624244754428404916185454273D+% 2624277294268904916127454153C+% 2624251575765634916154810683B+% 2624293046980624916112370223A+% 2624200490411294916172684723@+% 2624237146701464916113533433?+% 2624258658574874916114120613>+% 2624227824377084916112830373=+% 2624244837297204916155333203<+% 2624238487982924916103666833;+% 2624286829522004916133536633:+% 26242480171996349161757450139+% 26242753633931449161385448738+% 26242106250454649161871016737+% 26242450400981949161435131836+% 26242362064706049161373334735+% 26242183527525049161837530834+% 26242908855712649161122405133+% 26242036746820649161600314732+% 26242222638234249161863415831+% 26242220407544949161555144530+% 2624268652227454916175247803/+% 2624231985701474916168734183.+% 2624203142247774916101478013-+% 2624279572956014916101726743,+% 2624244252282124916168386233++% 2624244706104064916113868083*+% 2624290800204474916170102013)+% 2624276757569664916171407323(+% 2624269792591914916116154583'+% 2624207209509444916118241063&+% 2624283892813484916174726223%+% 2624234532234754916115085463$+% 2624291187655214916140857653#+% 2624295331762124916111174353"+% 2624217284781564916170140033!+% 2624295513911074916141387023 +% 2624254087356094916133484323+% 2624221054281564916135132463+% 2624241754109254916131235353+% 2624287942762224916137476313+% 2624227503024674916180131023+% 2624260196477094916118057573+% 2624253429551364916156324713+% 2624245526704944916102363673+% 2624201987416764916177231143+% 2624225495121944916185430743+% 2624240565895864916131725153+% 2624263978245504916120414753+% 2624284217947654916116230233+% 2624282440327804916174060433+% 2624277235493964916162642383+% 2624232500579134916144126163+% 2624204347816014916146104013+% 2624212223272734916147820143+% 2624279997419304916115672843 +% 2624256147743914916184460683 +% 2624233001744754916137143453 +% 2624212965096024916112167133 +% 2624285847306714916173547013 +% 2624272007495104916134213633+% 2624214344699664916168367573+% 2624287831071414916140727373+% 2624211010882854916157152103+% 2624278053159354916120801653+% 2624233760617764916161441353+% 2624266232156324916186488023+% 262428736696762491613256108[+%7 3262424177006225491614408570MSC-00-00-00-00-00-002024-06-18 05:56:16