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 9aI  m  e i a U  % 1  -! = Eu y  )q  }] 95 AM    M   Y Q  u 9+262425616233080J+262427525428708I+262421649660564H+262429544509306G+262426112345561F+262421292946675E+262421091638770D+262423369830552C+262423214786794B+262427384577003A+262424341299255@+262426511498925?+262424479191456>+262423844388673=+262428864599172<+262421144321119;+262424253383565:+2624260454161199+2624202404138798+2624233075007187+2624294298954336+2624201669051715+2624218374095684+2624281963199713+2624292716437292+2624237785322711+2624259330065190+262421738051635/+262421605877408.+262425139621184-+262427247127287,+262421648034012++262428757324827*+262429192254857)+262423707574555(+262428678516939'+262424297701832&+262427630679145%+262422894647391$+262423927966659#+262428805114898"+262420986614741!+262429786338469 +262424786898210+262429270675425+262428838773246+262421834230580+262422258233962+262428597274190+262422206797744+262423813075438+262425728600885+262420129230232+262425328080969+262424566743681+262424738282167+262423100450509+262423394996308+262425015171705+262428265738192+262423093207038+262426249543787 +262420620352621 +262422748197777 +262429828916307 +262426000307207 +262420025772011+262423972767098+262425143478068+262424930563146+262425222898900+262427306597872+262425846343545+ 262421113162198 J W F% Z  & 5 8 y Y H [  { j 9  k I  i (h J } | l G$ 6 X 'z 7422J%491615857207I%491614135232H%491616203654G%491613327027F%491616614370E%491616242357D%491611622178C%491611502784B%491613312324A%491611562263@%491615170863?%491610041201>%491614206527=%491612100066<%491615407504;%491617788031:%4916122846509%4916153066168%4916111638347%4916147462866%4916162470385%4916101388354%4916152788213%4916172654282%4916150180431%4916177518340%491611671740/%491615701347.%491613345606-%491617267160,%491611783512+%491618611627*%491613235700)%491613012420(%491613442244'%491613351353&%491611621516%%491612457227$%491612565352#%491614571212"%491617532144!%491616810217 %491616532454%491617051680%491617638261%491610540641%491617463463%491617041526%491617583300%491615853108%491618075217%491613048544%491618871074%491612033437%491615860561%491612740038%491616037117%491618241247%491614457614%491613842743%491617087282 %491612165342 %491610357670 %491610057603 %491616042584 %491612611644%491612323486%491610674078%491611864456%491614420152%491615380700%491613517717% 491611542588   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 9aI  m  e i a U  % 1  -! = Eu y  )q  }] 95 AM    M   Y Q  u 9+262425616233080J+262427525428708I+262421649660564H+262429544509306G+262426112345561F+262421292946675E+262421091638770D+262423369830552C+262423214786794B+262427384577003A+262424341299255@+262426511498925?+262424479191456>+262423844388673=+262428864599172<+262421144321119;+262424253383565:+2624260454161199+2624202404138798+2624233075007187+2624294298954336+2624201669051715+2624218374095684+2624281963199713+2624292716437292+2624237785322711+2624259330065190+262421738051635/+262421605877408.+262425139621184-+262427247127287,+262421648034012++262428757324827*+262429192254857)+262423707574555(+262428678516939'+262424297701832&+262427630679145%+262422894647391$+262423927966659#+262428805114898"+262420986614741!+262429786338469 +262424786898210+262429270675425+262428838773246+262421834230580+262422258233962+262428597274190+262422206797744+262423813075438+262425728600885+262420129230232+262425328080969+262424566743681+262424738282167+262423100450509+262423394996308+262425015171705+262428265738192+262423093207038+262426249543787 +262420620352621 +262422748197777 +262429828916307 +262426000307207 +262420025772011+262423972767098+262425143478068+262424930563146+262425222898900+262427306597872+262425846343545+ 262421113162198 8J+) 26242561623308042212345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624275254287084916158572073H+% 2624216496605644916141352323G+% 2624295445093064916162036543F+% 2624261123455614916133270273E+% 2624212929466754916166143703D+% 2624210916387704916162423573C+% 2624233698305524916116221783B+% 2624232147867944916115027843A+% 2624273845770034916133123243@+% 2624243412992554916115622633?+% 2624265114989254916151708633>+% 2624244791914564916100412013=+% 2624238443886734916142065273<+% 2624288645991724916121000663;+% 2624211443211194916154075043:+% 26242425338356549161778803139+% 26242604541611949161228465038+% 26242024041387949161530661637+% 26242330750071849161116383436+% 26242942989543349161474628635+% 26242016690517149161624703834+% 26242183740956849161013883533+% 26242819631997149161527882132+% 26242927164372949161726542831+% 26242377853227149161501804330+% 2624259330065194916177518343/+% 2624217380516354916116717403.+% 2624216058774084916157013473-+% 2624251396211844916133456063,+% 2624272471272874916172671603++% 2624216480340124916117835123*+% 2624287573248274916186116273)+% 2624291922548574916132357003(+% 2624237075745554916130124203'+% 2624286785169394916134422443&+% 2624242977018324916133513533%+% 2624276306791454916116215163$+% 2624228946473914916124572273#+% 2624239279666594916125653523"+% 2624288051148984916145712123!+% 2624209866147414916175321443 +% 2624297863384694916168102173+% 2624247868982104916165324543+% 2624292706754254916170516803+% 2624288387732464916176382613+% 2624218342305804916105406413+% 2624222582339624916174634633+% 2624285972741904916170415263+% 2624222067977444916175833003+% 2624238130754384916158531083+% 2624257286008854916180752173+% 2624201292302324916130485443+% 2624253280809694916188710743+% 2624245667436814916120334373+% 2624247382821674916158605613+% 2624231004505094916127400383+% 2624233949963084916160371173+% 2624250151717054916182412473+% 2624282657381924916144576143+% 2624230932070384916138427433 +% 2624262495437874916170872823 +% 2624206203526214916121653423 +% 2624227481977774916103576703 +% 2624298289163074916100576033 +% 2624260003072074916160425843+% 2624200257720114916126116443+% 2624239727670984916123234863+% 2624251434780684916106740783+% 2624249305631464916118644563+% 2624252228989004916144201523+% 2624273065978724916153807003+% 262425846343545491613517717[+%7 3262421113162198491611542588MSC-00-00-00-00-00-002024-11-06 16:03:00