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 ma M Q ! =    } u 1 i9q ) % u 5   a M     E  y - Y ] e 9 A I U +262429331381406J+262425732598285I+262425705766449H+262422068221831G+262427136594513F+262422159613457E+262421839248158D+262420432577690C+262425345070766B+262426824672646A+262428477580376@+262420286255044?+262423552857012>+262420759118167=+262420369874295<+262429266749859;+262427936346250:+2624235672401369+2624208938439758+2624294069228567+2624299616713396+2624246955155055+2624242494957574+2624262068486843+2624215876111512+2624280137902491+2624293313817950+262429857392928/+262423187478341.+262421929047636-+262428386307810,+262420229492508++262426481800142*+262420617808833)+262427899098826(+262427434712737'+262420878974520&+262426289479616%+262422710538925$+262426732565750#+262428190644074"+262420134841927!+262426147792457 +262421688002056+262423464606552+262428454631637+262421438453913+262425880554412+262425219313961+262421825065122+262420564453312+262424842650053+262429721569643+262428871181000+262423404112664+262424451793515+262426742396119+262425017695297+262428712255268+262427877008392+262424765199672+262425672037771 +262425233334681 +262423646905145 +262423321396375 +262420328182607 +262420181224006+262424267280922+262425474996349+262423786232370+262426165918249+262426512211947+262420600847369+ 262421438153147 J  8X  WGh  Y { | %  [ y i I J j H & z 9 6 7 ( l $  k }5 Z  'F 994J%491616761133I%491616230014H%491615380654G%491614408275F%491617307628E%491617757213D%491610416378C%491613607345B%491616516060A%491616030235@%491615432057?%491617855787>%491613768416=%491615078065<%491617606523;%491618227463:%4916102472269%4916153607178%4916178576747%4916176810886%4916130716405%4916120375404%4916140041433%4916173508322%4916125184821%4916134774800%491618012557/%491614221706.%491612112278-%491614172052,%491615746003+%491616731280*%491615610824)%491612132272(%491615576033'%491612855866&%491610788303%%491610502850$%491616318011#%491614660212"%491614307480!%491611025456 %491616181513%491613141577%491618082853%491613870432%491616537165%491611412325%491610256020%491615300878%491616121023%491613872022%491616016730%491615314473%491615623423%491613403177%491614866486%491610028870%491618104806%491611358218%491617580681 %491617811774 %491618502466 %491611083470 %491611807616 %491614848268%491614472843%491610438627%491615374616%491611681238%491612367677%491615061205% 491612171157   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 ma M Q ! =    } u 1 i9q ) % u 5   a M     E  y - Y ] e 9 A I U +262429331381406J+262425732598285I+262425705766449H+262422068221831G+262427136594513F+262422159613457E+262421839248158D+262420432577690C+262425345070766B+262426824672646A+262428477580376@+262420286255044?+262423552857012>+262420759118167=+262420369874295<+262429266749859;+262427936346250:+2624235672401369+2624208938439758+2624294069228567+2624299616713396+2624246955155055+2624242494957574+2624262068486843+2624215876111512+2624280137902491+2624293313817950+262429857392928/+262423187478341.+262421929047636-+262428386307810,+262420229492508++262426481800142*+262420617808833)+262427899098826(+262427434712737'+262420878974520&+262426289479616%+262422710538925$+262426732565750#+262428190644074"+262420134841927!+262426147792457 +262421688002056+262423464606552+262428454631637+262421438453913+262425880554412+262425219313961+262421825065122+262420564453312+262424842650053+262429721569643+262428871181000+262423404112664+262424451793515+262426742396119+262425017695297+262428712255268+262427877008392+262424765199672+262425672037771 +262425233334681 +262423646905145 +262423321396375 +262420328182607 +262420181224006+262424267280922+262425474996349+262423786232370+262426165918249+262426512211947+262420600847369+ 262421438153147 8J+) 26242933138140699412345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624257325982854916167611333H+% 2624257057664494916162300143G+% 2624220682218314916153806543F+% 2624271365945134916144082753E+% 2624221596134574916173076283D+% 2624218392481584916177572133C+% 2624204325776904916104163783B+% 2624253450707664916136073453A+% 2624268246726464916165160603@+% 2624284775803764916160302353?+% 2624202862550444916154320573>+% 2624235528570124916178557873=+% 2624207591181674916137684163<+% 2624203698742954916150780653;+% 2624292667498594916176065233:+% 26242793634625049161822746339+% 26242356724013649161024722638+% 26242089384397549161536071737+% 26242940692285649161785767436+% 26242996167133949161768108835+% 26242469551550549161307164034+% 26242424949575749161203754033+% 26242620684868449161400414332+% 26242158761115149161735083231+% 26242801379024949161251848230+% 2624293313817954916134774803/+% 2624298573929284916180125573.+% 2624231874783414916142217063-+% 2624219290476364916121122783,+% 2624283863078104916141720523++% 2624202294925084916157460033*+% 2624264818001424916167312803)+% 2624206178088334916156108243(+% 2624278990988264916121322723'+% 2624274347127374916155760333&+% 2624208789745204916128558663%+% 2624262894796164916107883033$+% 2624227105389254916105028503#+% 2624267325657504916163180113"+% 2624281906440744916146602123!+% 2624201348419274916143074803 +% 2624261477924574916110254563+% 2624216880020564916161815133+% 2624234646065524916131415773+% 2624284546316374916180828533+% 2624214384539134916138704323+% 2624258805544124916165371653+% 2624252193139614916114123253+% 2624218250651224916102560203+% 2624205644533124916153008783+% 2624248426500534916161210233+% 2624297215696434916138720223+% 2624288711810004916160167303+% 2624234041126644916153144733+% 2624244517935154916156234233+% 2624267423961194916134031773+% 2624250176952974916148664863+% 2624287122552684916100288703+% 2624278770083924916181048063+% 2624247651996724916113582183 +% 2624256720377714916175806813 +% 2624252333346814916178117743 +% 2624236469051454916185024663 +% 2624233213963754916110834703 +% 2624203281826074916118076163+% 2624201812240064916148482683+% 2624242672809224916144728433+% 2624254749963494916104386273+% 2624237862323704916153746163+% 2624261659182494916116812383+% 2624265122119474916123676773+% 262420600847369491615061205[+%7 3262421438153147491612171157MSC-00-00-00-00-00-002024-10-31 16:03:00