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 99  } y I  Y u i 9  q m% 5 a M Q ! = M  )] E e U  u a A -  1 +262422481371312J+262424464028257I+262428303104522H+262422162436076G+262423844149353F+262420276927084E+262426635851310D+262421587752867C+262429317261939B+262424443573254A+262420227519548@+262429220541348?+262426957347977>+262425994100287=+262424903729538<+262427870071981;+262420512661695:+2624279488183589+2624202782302618+2624235947663587+2624223207050096+2624269525367355+2624217482282654+2624230025608573+2624278947901492+2624290996972941+2624285461033120+262427890795899/+262422370696848.+262420332449835-+262422950090071,+262428298596566++262425990673143*+262426072917172)+262421165046923(+262429058828473'+262421283991936&+262429671580694%+262429231573224$+262427817826110#+262421933984995"+262423357517092!+262425337714672 +262426286368213+262421582787077+262429135903144+262421182510770+262423754283554+262420603300669+262424504915326+262425458015723+262423825158604+262420789182624+262427208191249+262423351129801+262421764556750+262428538139450+262422982649824+262421795499441+262421763254741+262427094973552+262424084479497 +262428863809666 +262423378838566 +262420027433718 +262426168332369 +262424257573952+262428079108064+262426617582886+262420464741838+262426619054658+262428978708853+262426384049918+ 262428972136893 J &z |  5 } 7W  ( 8 [% k$ '6 h  l 9i  X  j Y  H I { F J  G Zy 116J%491611255284I%491613288571H%491617234144G%491611542547F%491613266803E%491610610382D%491615244425C%491616753227B%491613033114A%491616551838@%491616606258?%491617318003>%491617711745=%491617358686<%491611248347;%491612226611:%4916113446339%4916158273278%4916182446537%4916116224826%4916103045185%4916128254574%4916162825173%4916145178482%4916158522461%4916151754600%491612732018/%491614235163.%491610468806-%491610450452,%491610228305+%491611104072*%491615733056)%491615127785(%491614543048'%491616725288&%491616122177%%491611451071$%491610184052#%491614040740"%491613616516!%491618842783 %491617152582%491614272625%491611320825%491611614802%491612715861%491617731217%491614164582%491613506643%491610302047%491610485181%491613230581%491612507408%491618836564%491613045753%491611274637%491610283880%491612667387%491611085062%491611625621 %491610580550 %491617027881 %491611230214 %491612830134 %491618260720%491617452524%491613787523%491618206445%491611720227%491614415221%491618136871% 491615207128   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 99  } y I  Y u i 9  q m% 5 a M Q ! = M  )] E e U  u a A -  1 +262422481371312J+262424464028257I+262428303104522H+262422162436076G+262423844149353F+262420276927084E+262426635851310D+262421587752867C+262429317261939B+262424443573254A+262420227519548@+262429220541348?+262426957347977>+262425994100287=+262424903729538<+262427870071981;+262420512661695:+2624279488183589+2624202782302618+2624235947663587+2624223207050096+2624269525367355+2624217482282654+2624230025608573+2624278947901492+2624290996972941+2624285461033120+262427890795899/+262422370696848.+262420332449835-+262422950090071,+262428298596566++262425990673143*+262426072917172)+262421165046923(+262429058828473'+262421283991936&+262429671580694%+262429231573224$+262427817826110#+262421933984995"+262423357517092!+262425337714672 +262426286368213+262421582787077+262429135903144+262421182510770+262423754283554+262420603300669+262424504915326+262425458015723+262423825158604+262420789182624+262427208191249+262423351129801+262421764556750+262428538139450+262422982649824+262421795499441+262421763254741+262427094973552+262424084479497 +262428863809666 +262423378838566 +262420027433718 +262426168332369 +262424257573952+262428079108064+262426617582886+262420464741838+262426619054658+262428978708853+262426384049918+ 262428972136893 8J+) 26242248137131211612345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624244640282574916112552843H+% 2624283031045224916132885713G+% 2624221624360764916172341443F+% 2624238441493534916115425473E+% 2624202769270844916132668033D+% 2624266358513104916106103823C+% 2624215877528674916152444253B+% 2624293172619394916167532273A+% 2624244435732544916130331143@+% 2624202275195484916165518383?+% 2624292205413484916166062583>+% 2624269573479774916173180033=+% 2624259941002874916177117453<+% 2624249037295384916173586863;+% 2624278700719814916112483473:+% 26242051266169549161222661139+% 26242794881835849161134463338+% 26242027823026149161582732737+% 26242359476635849161824465336+% 26242232070500949161162248235+% 26242695253673549161030451834+% 26242174822826549161282545733+% 26242300256085749161628251732+% 26242789479014949161451784831+% 26242909969729449161585224630+% 2624285461033124916151754603/+% 2624278907958994916127320183.+% 2624223706968484916142351633-+% 2624203324498354916104688063,+% 2624229500900714916104504523++% 2624282985965664916102283053*+% 2624259906731434916111040723)+% 2624260729171724916157330563(+% 2624211650469234916151277853'+% 2624290588284734916145430483&+% 2624212839919364916167252883%+% 2624296715806944916161221773$+% 2624292315732244916114510713#+% 2624278178261104916101840523"+% 2624219339849954916140407403!+% 2624233575170924916136165163 +% 2624253377146724916188427833+% 2624262863682134916171525823+% 2624215827870774916142726253+% 2624291359031444916113208253+% 2624211825107704916116148023+% 2624237542835544916127158613+% 2624206033006694916177312173+% 2624245049153264916141645823+% 2624254580157234916135066433+% 2624238251586044916103020473+% 2624207891826244916104851813+% 2624272081912494916132305813+% 2624233511298014916125074083+% 2624217645567504916188365643+% 2624285381394504916130457533+% 2624229826498244916112746373+% 2624217954994414916102838803+% 2624217632547414916126673873+% 2624270949735524916110850623 +% 2624240844794974916116256213 +% 2624288638096664916105805503 +% 2624233788385664916170278813 +% 2624200274337184916112302143 +% 2624261683323694916128301343+% 2624242575739524916182607203+% 2624280791080644916174525243+% 2624266175828864916137875233+% 2624204647418384916182064453+% 2624266190546584916117202273+% 2624289787088534916144152213+% 262426384049918491618136871[+%7 3262428972136893491615207128MSC-00-00-00-00-00-002024-10-27 12:03:00