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  u a Q A] =!  1  } u% i 5 y E a   Y q9  U  e 9  - M M I   +262428593044502J+262428989115894I+262426169070554H+262420803979342G+262424068490650F+262423781000936E+262429903041474D+262422576824416C+262424887333130B+262428707923077A+262422844442720@+262426214595210?+262420211116514>+262422708113815=+262421897314774<+262427957620056;+262425876777289:+2624266243549069+2624299878053858+2624216967139437+2624240033144796+2624222713605985+2624290541896364+2624271963322663+2624296639997802+2624289853081891+2624221585256430+262427270788306/+262425311410294.+262424733328949-+262428176706833,+262423946331498++262427812838403*+262426492259670)+262420709756293(+262429773162164'+262421615599946&+262425364394294%+262423551589421$+262425896648257#+262426603012436"+262420376442153!+262424536327690 +262420223435097+262429338325027+262421249985392+262422990383238+262421416337095+262429785150608+262426370131359+262422827731593+262425846443457+262429655467079+262422160043268+262426644838361+262427940270744+262420115419125+262427302218588+262424435686181+262429962467928+262426438658352+262421939730162 +262427652302682 +262425234155679 +262426968660358 +262429270816958 +262421454282705+262424978582603+262424356280961+262427940407978+262424512844272+262420802588540+262423586484344+ 262428953951341 J I | J F l $  iy Z j  & 7 8  k YW } [ 9 5 G 6 h z H ( '   {X%  882J%491617604571I%491615812811H%491610325805G%491615634637F%491610575676E%491615445535D%491611028442C%491612317710B%491616108072A%491611530773@%491612564412?%491618272568>%491614310254=%491612247164<%491618277202;%491617823368:%4916146442539%4916101738088%4916116432437%4916147701266%4916102336835%4916124263274%4916140338763%4916113138802%4916167476571%4916178381430%491617032548/%491613062106.%491610433838-%491614700064,%491614447635+%491614627364*%491617375384)%491614861678(%491611755064'%491618457281&%491618148230%%491618871035$%491617144706#%491616820137"%491612630414!%491616752405 %491617435184%491616721131%491615312617%491618574105%491616860254%491616760548%491618535271%491611616635%491617325723%491610251316%491611022880%491610746276%491610887171%491615251830%491615058655%491618888062%491616681803%491614834230%491611052366 %491616742522 %491610571256 %491615266834 %491617108756 %491611624284%491612234228%491618177505%491610501387%491611353501%491617068800%491615525385% 491614466738   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  u a Q A] =!  1  } u% i 5 y E a   Y q9  U  e 9  - M M I   +262428593044502J+262428989115894I+262426169070554H+262420803979342G+262424068490650F+262423781000936E+262429903041474D+262422576824416C+262424887333130B+262428707923077A+262422844442720@+262426214595210?+262420211116514>+262422708113815=+262421897314774<+262427957620056;+262425876777289:+2624266243549069+2624299878053858+2624216967139437+2624240033144796+2624222713605985+2624290541896364+2624271963322663+2624296639997802+2624289853081891+2624221585256430+262427270788306/+262425311410294.+262424733328949-+262428176706833,+262423946331498++262427812838403*+262426492259670)+262420709756293(+262429773162164'+262421615599946&+262425364394294%+262423551589421$+262425896648257#+262426603012436"+262420376442153!+262424536327690 +262420223435097+262429338325027+262421249985392+262422990383238+262421416337095+262429785150608+262426370131359+262422827731593+262425846443457+262429655467079+262422160043268+262426644838361+262427940270744+262420115419125+262427302218588+262424435686181+262429962467928+262426438658352+262421939730162 +262427652302682 +262425234155679 +262426968660358 +262429270816958 +262421454282705+262424978582603+262424356280961+262427940407978+262424512844272+262420802588540+262423586484344+ 262428953951341 8J+) 26242859304450288212345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624289891158944916176045713H+% 2624261690705544916158128113G+% 2624208039793424916103258053F+% 2624240684906504916156346373E+% 2624237810009364916105756763D+% 2624299030414744916154455353C+% 2624225768244164916110284423B+% 2624248873331304916123177103A+% 2624287079230774916161080723@+% 2624228444427204916115307733?+% 2624262145952104916125644123>+% 2624202111165144916182725683=+% 2624227081138154916143102543<+% 2624218973147744916122471643;+% 2624279576200564916182772023:+% 26242587677728949161782336839+% 26242662435490649161464425338+% 26242998780538549161017380837+% 26242169671394349161164324336+% 26242400331447949161477012635+% 26242227136059849161023368334+% 26242905418963649161242632733+% 26242719633226649161403387632+% 26242966399978049161131388031+% 26242898530818949161674765730+% 2624221585256434916178381433/+% 2624272707883064916170325483.+% 2624253114102944916130621063-+% 2624247333289494916104338383,+% 2624281767068334916147000643++% 2624239463314984916144476353*+% 2624278128384034916146273643)+% 2624264922596704916173753843(+% 2624207097562934916148616783'+% 2624297731621644916117550643&+% 2624216155999464916184572813%+% 2624253643942944916181482303$+% 2624235515894214916188710353#+% 2624258966482574916171447063"+% 2624266030124364916168201373!+% 2624203764421534916126304143 +% 2624245363276904916167524053+% 2624202234350974916174351843+% 2624293383250274916167211313+% 2624212499853924916153126173+% 2624229903832384916185741053+% 2624214163370954916168602543+% 2624297851506084916167605483+% 2624263701313594916185352713+% 2624228277315934916116166353+% 2624258464434574916173257233+% 2624296554670794916102513163+% 2624221600432684916110228803+% 2624266448383614916107462763+% 2624279402707444916108871713+% 2624201154191254916152518303+% 2624273022185884916150586553+% 2624244356861814916188880623+% 2624299624679284916166818033+% 2624264386583524916148342303 +% 2624219397301624916110523663 +% 2624276523026824916167425223 +% 2624252341556794916105712563 +% 2624269686603584916152668343 +% 2624292708169584916171087563+% 2624214542827054916116242843+% 2624249785826034916122342283+% 2624243562809614916181775053+% 2624279404079784916105013873+% 2624245128442724916113535013+% 2624208025885404916170688003+% 262423586484344491615525385[+%7 3262428953951341491614466738MSC-00-00-00-00-00-002024-06-27 08:26:53