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%M } ] y 1uq  A  a M   9 U i  E - )  u e 5   !I =  a Y Q m 9 +262424123667630J+262423797319840I+262423657868496H+262424579743047G+262429144735102F+262423162510358E+262422422315134D+262422431188449C+262423115744291B+262423810269105A+262427649234661@+262425368635488?+262424410502482>+262427472609048=+262429013125892<+262424956417097;+262421255374484:+2624250823196519+2624230695524228+2624275143133987+2624230878622966+2624229008093915+2624203982709334+2624245718555523+2624242149919312+2624244080240721+2624226900443920+262424130159401/+262424190696033.+262420410514129-+262420733441335,+262421699638174++262426271300566*+262423339272445)+262425028086155(+262429530122935'+262420711673681&+262420972389991%+262421320656890$+262424336885203#+262428821890770"+262429100640652!+262423960957919 +262427690321156+262422697877031+262424376126842+262426465710627+262423017478674+262426560107559+262426876584595+262427123848400+262426106120472+262427151617353+262421099736108+262421433415142+262428270699907+262425580579469+262429863091221+262423944169279+262423209135046+262421634470174+262428170526821 +262420648852412 +262420130334369 +262429301303678 +262420193155560 +262428453822305+262421427454488+262425657410767+262424088315949+262427384378214+262429988425375+262422640280599+ 262426466912457 J  (X } hG    7 H W Jz  Yy  & k5 $ I {i |% 9 j 8 ' l F6  [ Z   964J%491610242663I%491616281448H%491613701430G%491618077412F%491617458812E%491610537454D%491617475361C%491616865723B%491618561576A%491614540602@%491610238517?%491611064672>%491611654014=%491614462570<%491617887812;%491617050124:%4916168251789%4916152753518%4916182860567%4916147075426%4916161180375%4916151052584%4916108877543%4916141021262%4916122325461%4916145078850%491618447786/%491618836680.%491610051538-%491612278131,%491614667866+%491612551108*%491613143210)%491614248850(%491616762657'%491615310561&%491615141881%%491617281887$%491611222418#%491616638038"%491612473840!%491614554686 %491613278378%491617463034%491618405577%491616166588%491617744058%491611457062%491610474077%491615843148%491613843845%491615813250%491611430851%491618747286%491618002857%491614111338%491616631580%491618831244%491612523771%491610378807%491615118533 %491615020862 %491617718021 %491613306426 %491611386400 %491614251623%491618701487%491618455271%491613366461%491617628606%491615650807%491614104678% 491612112737   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%M } ] y 1uq  A  a M   9 U i  E - )  u e 5   !I =  a Y Q m 9 +262424123667630J+262423797319840I+262423657868496H+262424579743047G+262429144735102F+262423162510358E+262422422315134D+262422431188449C+262423115744291B+262423810269105A+262427649234661@+262425368635488?+262424410502482>+262427472609048=+262429013125892<+262424956417097;+262421255374484:+2624250823196519+2624230695524228+2624275143133987+2624230878622966+2624229008093915+2624203982709334+2624245718555523+2624242149919312+2624244080240721+2624226900443920+262424130159401/+262424190696033.+262420410514129-+262420733441335,+262421699638174++262426271300566*+262423339272445)+262425028086155(+262429530122935'+262420711673681&+262420972389991%+262421320656890$+262424336885203#+262428821890770"+262429100640652!+262423960957919 +262427690321156+262422697877031+262424376126842+262426465710627+262423017478674+262426560107559+262426876584595+262427123848400+262426106120472+262427151617353+262421099736108+262421433415142+262428270699907+262425580579469+262429863091221+262423944169279+262423209135046+262421634470174+262428170526821 +262420648852412 +262420130334369 +262429301303678 +262420193155560 +262428453822305+262421427454488+262425657410767+262424088315949+262427384378214+262429988425375+262422640280599+ 262426466912457 8J+) 26242412366763096412345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624237973198404916102426633H+% 2624236578684964916162814483G+% 2624245797430474916137014303F+% 2624291447351024916180774123E+% 2624231625103584916174588123D+% 2624224223151344916105374543C+% 2624224311884494916174753613B+% 2624231157442914916168657233A+% 2624238102691054916185615763@+% 2624276492346614916145406023?+% 2624253686354884916102385173>+% 2624244105024824916110646723=+% 2624274726090484916116540143<+% 2624290131258924916144625703;+% 2624249564170974916178878123:+% 26242125537448449161705012439+% 26242508231965149161682517838+% 26242306955242249161527535137+% 26242751431339849161828605636+% 26242308786229649161470754235+% 26242290080939149161611803734+% 26242039827093349161510525833+% 26242457185555249161088775432+% 26242421499193149161410212631+% 26242440802407249161223254630+% 2624226900443924916145078853/+% 2624241301594014916184477863.+% 2624241906960334916188366803-+% 2624204105141294916100515383,+% 2624207334413354916122781313++% 2624216996381744916146678663*+% 2624262713005664916125511083)+% 2624233392724454916131432103(+% 2624250280861554916142488503'+% 2624295301229354916167626573&+% 2624207116736814916153105613%+% 2624209723899914916151418813$+% 2624213206568904916172818873#+% 2624243368852034916112224183"+% 2624288218907704916166380383!+% 2624291006406524916124738403 +% 2624239609579194916145546863+% 2624276903211564916132783783+% 2624226978770314916174630343+% 2624243761268424916184055773+% 2624264657106274916161665883+% 2624230174786744916177440583+% 2624265601075594916114570623+% 2624268765845954916104740773+% 2624271238484004916158431483+% 2624261061204724916138438453+% 2624271516173534916158132503+% 2624210997361084916114308513+% 2624214334151424916187472863+% 2624282706999074916180028573+% 2624255805794694916141113383+% 2624298630912214916166315803+% 2624239441692794916188312443+% 2624232091350464916125237713+% 2624216344701744916103788073 +% 2624281705268214916151185333 +% 2624206488524124916150208623 +% 2624201303343694916177180213 +% 2624293013036784916133064263 +% 2624201931555604916113864003+% 2624284538223054916142516233+% 2624214274544884916187014873+% 2624256574107674916184552713+% 2624240883159494916133664613+% 2624273843782144916176286063+% 2624299884253754916156508073+% 262422640280599491614104678[+%7 3262426466912457491612112737MSC-00-00-00-00-00-002024-10-29 12:03:00