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 I! e u = a Y   Q 1     m  u y - M i  } M59  U 9] A%a q E )+262427149212182J+262426343547522I+262421477226589H+262425031628433G+262425356920938F+262421259716749E+262423651508856D+262427038780472C+262424135885666B+262420194729051A+262421001792815@+262424494002886?+262429773725824>+262421338575622=+262422283850029<+262420794503150;+262425231128817:+2624283475671189+2624218109351598+2624221580692897+2624232117322826+2624219714081925+2624259514177154+2624222794304133+2624234781806162+2624252413489251+2624275658560770+262427104665328/+262425581917094.+262426234830895-+262423179586491,+262428049217825++262421954132569*+262423541607461)+262425688333138(+262423125164502'+262423881781988&+262424892446898%+262422671087095$+262429355095411#+262421548243031"+262424662524344!+262422609960185 +262427074062154+262423929118042+262426878858205+262423070812398+262425033751151+262429219928312+262422946926687+262420741996982+262426459652671+262420511266617+262427443408996+262428219574450+262420898540575+262422496845947+262427031606777+262422990529612+262424915772900+262429902720964+262422124772204 +262426239151752 +262427597002379 +262426689816449 +262425512173039 +262427879627898+262421084331312+262429722960486+262427273859416+262424299535614+262420737591218+262428186841885+ 262426017056156 J yF ( $ k  5 IX 8hW  i  }  j %  ' G J | H  Y 76 l  & 9 {z [ Z 376J%491610507785I%491617324144H%491615874047G%491618274784F%491616726046E%491614157380D%491613824337C%491612032222B%491614017754A%491615207341@%491614431331?%491613182122>%491615531784=%491616065641<%491610057722;%491615477202:%4916121344869%4916118553438%4916184280807%4916110645086%4916160226555%4916153156604%4916105225343%4916162431332%4916140171761%4916186336870%491614664036/%491610034178.%491616801012-%491615066420,%491617138301+%491616334668*%491616051328)%491616202010(%491615112207'%491618063340&%491614886268%%491618046766$%491611644624#%491612700005"%491610728184!%491611126023 %491614874511%491611180462%491616165521%491615283687%491616544024%491615814234%491612028458%491613188280%491618108404%491617378557%491614110365%491615468148%491613208412%491614368836%491612754751%491612341702%491610325041%491614135777%491611013540 %491611646142 %491610443112 %491612267656 %491612176634 %491610066028%491618355353%491617003831%491615710532%491611267813%491614270737%491611500515% 491611202584   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 I! e u = a Y   Q 1     m  u y - M i  } M59  U 9] A%a q E )+262427149212182J+262426343547522I+262421477226589H+262425031628433G+262425356920938F+262421259716749E+262423651508856D+262427038780472C+262424135885666B+262420194729051A+262421001792815@+262424494002886?+262429773725824>+262421338575622=+262422283850029<+262420794503150;+262425231128817:+2624283475671189+2624218109351598+2624221580692897+2624232117322826+2624219714081925+2624259514177154+2624222794304133+2624234781806162+2624252413489251+2624275658560770+262427104665328/+262425581917094.+262426234830895-+262423179586491,+262428049217825++262421954132569*+262423541607461)+262425688333138(+262423125164502'+262423881781988&+262424892446898%+262422671087095$+262429355095411#+262421548243031"+262424662524344!+262422609960185 +262427074062154+262423929118042+262426878858205+262423070812398+262425033751151+262429219928312+262422946926687+262420741996982+262426459652671+262420511266617+262427443408996+262428219574450+262420898540575+262422496845947+262427031606777+262422990529612+262424915772900+262429902720964+262422124772204 +262426239151752 +262427597002379 +262426689816449 +262425512173039 +262427879627898+262421084331312+262429722960486+262427273859416+262424299535614+262420737591218+262428186841885+ 262426017056156 8J+) 26242714921218237612345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624263435475224916105077853H+% 2624214772265894916173241443G+% 2624250316284334916158740473F+% 2624253569209384916182747843E+% 2624212597167494916167260463D+% 2624236515088564916141573803C+% 2624270387804724916138243373B+% 2624241358856664916120322223A+% 2624201947290514916140177543@+% 2624210017928154916152073413?+% 2624244940028864916144313313>+% 2624297737258244916131821223=+% 2624213385756224916155317843<+% 2624222838500294916160656413;+% 2624207945031504916100577223:+% 26242523112881749161547720239+% 26242834756711849161213448638+% 26242181093515949161185534337+% 26242215806928949161842808036+% 26242321173228249161106450835+% 26242197140819249161602265534+% 26242595141771549161531566033+% 26242227943041349161052253432+% 26242347818061649161624313331+% 26242524134892549161401717630+% 2624275658560774916186336873/+% 2624271046653284916146640363.+% 2624255819170944916100341783-+% 2624262348308954916168010123,+% 2624231795864914916150664203++% 2624280492178254916171383013*+% 2624219541325694916163346683)+% 2624235416074614916160513283(+% 2624256883331384916162020103'+% 2624231251645024916151122073&+% 2624238817819884916180633403%+% 2624248924468984916148862683$+% 2624226710870954916180467663#+% 2624293550954114916116446243"+% 2624215482430314916127000053!+% 2624246625243444916107281843 +% 2624226099601854916111260233+% 2624270740621544916148745113+% 2624239291180424916111804623+% 2624268788582054916161655213+% 2624230708123984916152836873+% 2624250337511514916165440243+% 2624292199283124916158142343+% 2624229469266874916120284583+% 2624207419969824916131882803+% 2624264596526714916181084043+% 2624205112666174916173785573+% 2624274434089964916141103653+% 2624282195744504916154681483+% 2624208985405754916132084123+% 2624224968459474916143688363+% 2624270316067774916127547513+% 2624229905296124916123417023+% 2624249157729004916103250413+% 2624299027209644916141357773 +% 2624221247722044916110135403 +% 2624262391517524916116461423 +% 2624275970023794916104431123 +% 2624266898164494916122676563 +% 2624255121730394916121766343+% 2624278796278984916100660283+% 2624210843313124916183553533+% 2624297229604864916170038313+% 2624272738594164916157105323+% 2624242995356144916112678133+% 2624207375912184916142707373+% 262428186841885491611500515[+%7 3262426017056156491611202584MSC-00-00-00-00-00-002024-09-14 12:03:05