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   y 1 =q a e U a I  u  } )  u Q i  ] 5! - M E 9 A m9  M% Y +262428484578867J+262428263907930I+262421775439189H+262423134047970G+262429476546060F+262429746152147E+262423776327765D+262421845483912C+262422407323147B+262422372432602A+262424820945326@+262423030764878?+262424640906405>+262421484871778=+262425365492030<+262422383638129;+262421418803061:+2624206261276269+2624224125605598+2624204418077057+2624236165398326+2624202760465055+2624250899943474+2624277366156723+2624293515383582+2624282263222831+2624286765028470+262422481711360/+262425691109132.+262424462783852-+262424745468258,+262421894781420++262426252670642*+262426512189726)+262426763806041(+262424967353383'+262422584554142&+262422491695736%+262421431103551$+262428473643812#+262429682694126"+262428708044706!+262428546993893 +262427536737944+262424264767854+262429806738204+262427005852040+262420829325136+262429841109207+262420550956728+262428113026868+262427921395819+262422958810511+262427710314055+262421761280399+262428809590959+262427173498057+262428243476874+262422734728905+262428284277915+262427033104811+262423080011481 +262427808046311 +262429657948167 +262428911998272 +262429496116806 +262422539760244+262425082506792+262425050727614+262423976474122+262429389961991+262420869952656+262420467881162+ 262424534273340 J 5 } ( h {   I y  Wz  kXiF 8 Y '  Z$ % &  | [ J 9 G 7 j l H   6010J%491610666815I%491617203127H%491617154814G%491617134842F%491617675878E%491610638035D%491617326180C%491612222540B%491617406044A%491615654725@%491615635300?%491613334806>%491618218848=%491616468613<%491611816346;%491614585201:%4916138545459%4916121847658%4916151402437%4916134528366%4916166081155%4916122748824%4916146033463%4916183707202%4916184011071%4916137760700%491613655064/%491615561634.%491612155500-%491618055324,%491615871461+%491617502536*%491617733008)%491614033036(%491617565224'%491611160776&%491617864535%%491612687625$%491610317508#%491617806054"%491613720014!%491610702205 %491612482172%491613340753%491611182724%491615647012%491618436228%491617354388%491613576334%491613604038%491612815554%491612454472%491616476455%491617870825%491618177488%491618705355%491617513340%491618633523%491612435051%491610848107%491615346205 %491610625672 %491613610028 %491612787238 %491610776441 %491612454172%491610570633%491612407257%491615142345%491616220866%491613506021%491614607201% 491612523852   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   y 1 =q a e U a I  u  } )  u Q i  ] 5! - M E 9 A m9  M% Y +262428484578867J+262428263907930I+262421775439189H+262423134047970G+262429476546060F+262429746152147E+262423776327765D+262421845483912C+262422407323147B+262422372432602A+262424820945326@+262423030764878?+262424640906405>+262421484871778=+262425365492030<+262422383638129;+262421418803061:+2624206261276269+2624224125605598+2624204418077057+2624236165398326+2624202760465055+2624250899943474+2624277366156723+2624293515383582+2624282263222831+2624286765028470+262422481711360/+262425691109132.+262424462783852-+262424745468258,+262421894781420++262426252670642*+262426512189726)+262426763806041(+262424967353383'+262422584554142&+262422491695736%+262421431103551$+262428473643812#+262429682694126"+262428708044706!+262428546993893 +262427536737944+262424264767854+262429806738204+262427005852040+262420829325136+262429841109207+262420550956728+262428113026868+262427921395819+262422958810511+262427710314055+262421761280399+262428809590959+262427173498057+262428243476874+262422734728905+262428284277915+262427033104811+262423080011481 +262427808046311 +262429657948167 +262428911998272 +262429496116806 +262422539760244+262425082506792+262425050727614+262423976474122+262429389961991+262420869952656+262420467881162+ 262424534273340 8J+) 26242848457886701012345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624282639079304916106668153H+% 2624217754391894916172031273G+% 2624231340479704916171548143F+% 2624294765460604916171348423E+% 2624297461521474916176758783D+% 2624237763277654916106380353C+% 2624218454839124916173261803B+% 2624224073231474916122225403A+% 2624223724326024916174060443@+% 2624248209453264916156547253?+% 2624230307648784916156353003>+% 2624246409064054916133348063=+% 2624214848717784916182188483<+% 2624253654920304916164686133;+% 2624223836381294916118163463:+% 26242141880306149161458520139+% 26242062612762649161385454538+% 26242241256055949161218476537+% 26242044180770549161514024336+% 26242361653983249161345283635+% 26242027604650549161660811534+% 26242508999434749161227488233+% 26242773661567249161460334632+% 26242935153835849161837072031+% 26242822632228349161840110730+% 2624286765028474916137760703/+% 2624224817113604916136550643.+% 2624256911091324916155616343-+% 2624244627838524916121555003,+% 2624247454682584916180553243++% 2624218947814204916158714613*+% 2624262526706424916175025363)+% 2624265121897264916177330083(+% 2624267638060414916140330363'+% 2624249673533834916175652243&+% 2624225845541424916111607763%+% 2624224916957364916178645353$+% 2624214311035514916126876253#+% 2624284736438124916103175083"+% 2624296826941264916178060543!+% 2624287080447064916137200143 +% 2624285469938934916107022053+% 2624275367379444916124821723+% 2624242647678544916133407533+% 2624298067382044916111827243+% 2624270058520404916156470123+% 2624208293251364916184362283+% 2624298411092074916173543883+% 2624205509567284916135763343+% 2624281130268684916136040383+% 2624279213958194916128155543+% 2624229588105114916124544723+% 2624277103140554916164764553+% 2624217612803994916178708253+% 2624288095909594916181774883+% 2624271734980574916187053553+% 2624282434768744916175133403+% 2624227347289054916186335233+% 2624282842779154916124350513+% 2624270331048114916108481073 +% 2624230800114814916153462053 +% 2624278080463114916106256723 +% 2624296579481674916136100283 +% 2624289119982724916127872383 +% 2624294961168064916107764413+% 2624225397602444916124541723+% 2624250825067924916105706333+% 2624250507276144916124072573+% 2624239764741224916151423453+% 2624293899619914916162208663+% 2624208699526564916135060213+% 262420467881162491614607201[+%7 3262424534273340491612523852MSC-00-00-00-00-00-002024-09-30 05:56:06