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 u 9  m =q % 15 y Ua  ] 9  } ) E M a e u i! Y Q A - M  I+262420218203569J+262428586099690I+262425300750039H+262420183477189G+262420821503650F+262423531291559E+262421614349054D+262427433477111C+262422461449110B+262428401303556A+262429669691604@+262425184923817?+262424409287085>+262421500147824=+262427635267323<+262425326047179;+262422587407607:+2624283212085399+2624239978406728+2624250132570737+2624205778371006+2624283087996875+2624216651052134+2624230548703273+2624240314253362+2624285228769141+2624283689919260+262422924333893/+262426263645004.+262424057968755-+262422770688947,+262423091032110++262420543532980*+262423052889878)+262428709493256(+262420549746210'+262426974790325&+262425922970470%+262421785213728$+262424683993714#+262427627512875"+262420943965621!+262426176888641 +262422215757308+262428335181693+262423369938221+262421973470447+262424337958060+262427215630673+262424570249867+262426763359215+262421919363848+262429923034700+262423137541038+262421577400444+262423936620020+262421181123750+262423798396171+262421557362629+262429333243487+262427729333799+262420174063617 +262429032467793 +262421721548554 +262423728256678 +262425220641919 +262422928798699+262426068230824+262420660521966+262421890589184+262426366626977+262429253499403+262425000305162+ 262429458498081 J  G k 8 % 6F  H & lX [ Y (  i  j 9 '$ {  7hy  | z } J I5 W   Z 951J%491612625202I%491614036278H%491616585401G%491612253625F%491611750617E%491616362806D%491613570267C%491610402813B%491615046641A%491612655448@%491615400401?%491618617502>%491610123551=%491613218340<%491611156380;%491614070528:%4916103668209%4916166683168%4916184721287%4916103207816%4916160381425%4916130056254%4916105011513%4916158555012%4916132371661%4916108022370%491617871030/%491610310474.%491618365581-%491615371526,%491611638571+%491615410204*%491611356121)%491612320008(%491613521584'%491615242856&%491618287026%%491615143814$%491616133334#%491612252433"%491610361176!%491615354030 %491615187080%491611422606%491610773835%491610781612%491611115400%491610202417%491611838872%491613022786%491616156727%491610277866%491613565765%491618584780%491615806048%491614078231%491611727164%491611167781%491612736324%491613038052%491614266612 %491617737620 %491611137132 %491618002478 %491615537343 %491615717506%491611414401%491610001811%491614555354%491616632013%491613160531%491615864635% 491618342831   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 u 9  m =q % 15 y Ua  ] 9  } ) E M a e u i! Y Q A - M  I+262420218203569J+262428586099690I+262425300750039H+262420183477189G+262420821503650F+262423531291559E+262421614349054D+262427433477111C+262422461449110B+262428401303556A+262429669691604@+262425184923817?+262424409287085>+262421500147824=+262427635267323<+262425326047179;+262422587407607:+2624283212085399+2624239978406728+2624250132570737+2624205778371006+2624283087996875+2624216651052134+2624230548703273+2624240314253362+2624285228769141+2624283689919260+262422924333893/+262426263645004.+262424057968755-+262422770688947,+262423091032110++262420543532980*+262423052889878)+262428709493256(+262420549746210'+262426974790325&+262425922970470%+262421785213728$+262424683993714#+262427627512875"+262420943965621!+262426176888641 +262422215757308+262428335181693+262423369938221+262421973470447+262424337958060+262427215630673+262424570249867+262426763359215+262421919363848+262429923034700+262423137541038+262421577400444+262423936620020+262421181123750+262423798396171+262421557362629+262429333243487+262427729333799+262420174063617 +262429032467793 +262421721548554 +262423728256678 +262425220641919 +262422928798699+262426068230824+262420660521966+262421890589184+262426366626977+262429253499403+262425000305162+ 262429458498081 8J+) 26242021820356995112345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624285860996904916126252023H+% 2624253007500394916140362783G+% 2624201834771894916165854013F+% 2624208215036504916122536253E+% 2624235312915594916117506173D+% 2624216143490544916163628063C+% 2624274334771114916135702673B+% 2624224614491104916104028133A+% 2624284013035564916150466413@+% 2624296696916044916126554483?+% 2624251849238174916154004013>+% 2624244092870854916186175023=+% 2624215001478244916101235513<+% 2624276352673234916132183403;+% 2624253260471794916111563803:+% 26242258740760749161407052839+% 26242832120853949161036682038+% 26242399784067249161666831637+% 26242501325707349161847212836+% 26242057783710049161032078135+% 26242830879968749161603814234+% 26242166510521349161300562533+% 26242305487032749161050115132+% 26242403142533649161585550131+% 26242852287691449161323716630+% 2624283689919264916108022373/+% 2624229243338934916178710303.+% 2624262636450044916103104743-+% 2624240579687554916183655813,+% 2624227706889474916153715263++% 2624230910321104916116385713*+% 2624205435329804916154102043)+% 2624230528898784916113561213(+% 2624287094932564916123200083'+% 2624205497462104916135215843&+% 2624269747903254916152428563%+% 2624259229704704916182870263$+% 2624217852137284916151438143#+% 2624246839937144916161333343"+% 2624276275128754916122524333!+% 2624209439656214916103611763 +% 2624261768886414916153540303+% 2624222157573084916151870803+% 2624283351816934916114226063+% 2624233699382214916107738353+% 2624219734704474916107816123+% 2624243379580604916111154003+% 2624272156306734916102024173+% 2624245702498674916118388723+% 2624267633592154916130227863+% 2624219193638484916161567273+% 2624299230347004916102778663+% 2624231375410384916135657653+% 2624215774004444916185847803+% 2624239366200204916158060483+% 2624211811237504916140782313+% 2624237983961714916117271643+% 2624215573626294916111677813+% 2624293332434874916127363243+% 2624277293337994916130380523 +% 2624201740636174916142666123 +% 2624290324677934916177376203 +% 2624217215485544916111371323 +% 2624237282566784916180024783 +% 2624252206419194916155373433+% 2624229287986994916157175063+% 2624260682308244916114144013+% 2624206605219664916100018113+% 2624218905891844916145553543+% 2624263666269774916166320133+% 2624292534994034916131605313+% 262425000305162491615864635[+%7 3262429458498081491618342831MSC-00-00-00-00-00-002024-06-24 05:56:14