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 Q  Au yM = Y 1 ) q ! U  m  5  u ] % -  i e E a M } 9 9  I  a +262426322868939J+262425571620418I+262425280891124H+262423855259452G+262423063970863F+262425572679409E+262429852973067D+262426482983156C+262420178464033B+262423008200317A+262428096316260@+262421623320468?+262421376271057>+262420667822109=+262420117648875<+262424888587443;+262420411619439:+2624270398007109+2624239325574218+2624270435999087+2624233486628866+2624220358949335+2624252831098594+2624230430770433+2624237636903472+2624246189386031+2624202327266540+262422818117972/+262424809525245.+262425722703693-+262427471990770,+262428229768848++262423160303123*+262424552512778)+262427904260352(+262423370427797'+262429375458912&+262420174688476%+262420895044486$+262424970938425#+262420720156332"+262423111294432!+262423426760024 +262422494790373+262427068491325+262428828975586+262428735382257+262424714263991+262427190182320+262429239340006+262422213955099+262423415389417+262428607040653+262424457209203+262421849307884+262426706337112+262423401469160+262429736809520+262424492971236+262424801894616+262428702995034+262426796003625 +262423958567522 +262424573859368 +262426663862903 +262420504407458 +262429641685154+262420290250543+262424404067922+262421601518636+262426360090369+262421716907923+262425948932170+ 262423336954425 J z   i Z G X Hy J '  6 l  k j5$ [ I }  & 8 Y 7 | Wh  9 { F  (% 775J%491618516766I%491617776414H%491613051583G%491613866812F%491613628061E%491614861780D%491617245007C%491615741527B%491613633052A%491611506186@%491618121722?%491618071746>%491618362306=%491618443667<%491611030258;%491613157354:%4916154805479%4916142602158%4916114353847%4916137105856%4916164884865%4916103486084%4916103858353%4916167068252%4916102482181%4916115775840%491611545862/%491611851837.%491617672542-%491610774683,%491615427271+%491616253855*%491612644223)%491616121818(%491613726023'%491617853550&%491615133370%%491615370528$%491610503564#%491615107122"%491613271537!%491613220737 %491610411425%491610368478%491613671336%491618640483%491613357828%491611831805%491612363341%491611425280%491610204361%491614320351%491617167430%491614272185%491613453662%491614103730%491614873084%491612536233%491616653564%491617040481%491613826330 %491613810112 %491618210556 %491616830127 %491616853683 %491612875837%491615388575%491613264860%491618306281%491615585408%491618022158%491610178803% 491611255767   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 Q  Au yM = Y 1 ) q ! U  m  5  u ] % -  i e E a M } 9 9  I  a +262426322868939J+262425571620418I+262425280891124H+262423855259452G+262423063970863F+262425572679409E+262429852973067D+262426482983156C+262420178464033B+262423008200317A+262428096316260@+262421623320468?+262421376271057>+262420667822109=+262420117648875<+262424888587443;+262420411619439:+2624270398007109+2624239325574218+2624270435999087+2624233486628866+2624220358949335+2624252831098594+2624230430770433+2624237636903472+2624246189386031+2624202327266540+262422818117972/+262424809525245.+262425722703693-+262427471990770,+262428229768848++262423160303123*+262424552512778)+262427904260352(+262423370427797'+262429375458912&+262420174688476%+262420895044486$+262424970938425#+262420720156332"+262423111294432!+262423426760024 +262422494790373+262427068491325+262428828975586+262428735382257+262424714263991+262427190182320+262429239340006+262422213955099+262423415389417+262428607040653+262424457209203+262421849307884+262426706337112+262423401469160+262429736809520+262424492971236+262424801894616+262428702995034+262426796003625 +262423958567522 +262424573859368 +262426663862903 +262420504407458 +262429641685154+262420290250543+262424404067922+262421601518636+262426360090369+262421716907923+262425948932170+ 262423336954425 8J+) 26242632286893977512345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624255716204184916185167663H+% 2624252808911244916177764143G+% 2624238552594524916130515833F+% 2624230639708634916138668123E+% 2624255726794094916136280613D+% 2624298529730674916148617803C+% 2624264829831564916172450073B+% 2624201784640334916157415273A+% 2624230082003174916136330523@+% 2624280963162604916115061863?+% 2624216233204684916181217223>+% 2624213762710574916180717463=+% 2624206678221094916183623063<+% 2624201176488754916184436673;+% 2624248885874434916110302583:+% 26242041161943949161315735439+% 26242703980071049161548054738+% 26242393255742149161426021537+% 26242704359990849161143538436+% 26242334866288649161371058535+% 26242203589493349161648848634+% 26242528310985949161034860833+% 26242304307704349161038583532+% 26242376369034749161670682531+% 26242461893860349161024821830+% 2624202327266544916115775843/+% 2624228181179724916115458623.+% 2624248095252454916118518373-+% 2624257227036934916176725423,+% 2624274719907704916107746833++% 2624282297688484916154272713*+% 2624231603031234916162538553)+% 2624245525127784916126442233(+% 2624279042603524916161218183'+% 2624233704277974916137260233&+% 2624293754589124916178535503%+% 2624201746884764916151333703$+% 2624208950444864916153705283#+% 2624249709384254916105035643"+% 2624207201563324916151071223!+% 2624231112944324916132715373 +% 2624234267600244916132207373+% 2624224947903734916104114253+% 2624270684913254916103684783+% 2624288289755864916136713363+% 2624287353822574916186404833+% 2624247142639914916133578283+% 2624271901823204916118318053+% 2624292393400064916123633413+% 2624222139550994916114252803+% 2624234153894174916102043613+% 2624286070406534916143203513+% 2624244572092034916171674303+% 2624218493078844916142721853+% 2624267063371124916134536623+% 2624234014691604916141037303+% 2624297368095204916148730843+% 2624244929712364916125362333+% 2624248018946164916166535643+% 2624287029950344916170404813 +% 2624267960036254916138263303 +% 2624239585675224916138101123 +% 2624245738593684916182105563 +% 2624266638629034916168301273 +% 2624205044074584916168536833+% 2624296416851544916128758373+% 2624202902505434916153885753+% 2624244040679224916132648603+% 2624216015186364916183062813+% 2624263600903694916155854083+% 2624217169079234916180221583+% 262425948932170491610178803[+%7 3262423336954425491611255767MSC-00-00-00-00-00-002024-06-19 08:27:29