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 i  Q 9  a 1   u Uu E ] y5q -    9 ) m M a %  M Y e A  I! }  =+262424851907737J+262426159489741I+262421764101293H+262423121684047G+262425432142673F+262426311865883E+262425776527573D+262423571149100C+262428956577499B+262420230144563A+262424794711712@+262423012187851?+262425362051808>+262429698077520=+262420478844858<+262426362217592;+262423977848808:+2624242674947139+2624257556878958+2624290915799597+2624247418568756+2624257283783025+2624261710772564+2624210042955073+2624204707152252+2624242304502971+2624277985321210+262423144634343/+262420050076065.+262429092258691-+262427590631622,+262421885538664++262422291585125*+262421215603387)+262420938835875(+262425481264470'+262425955938357&+262421350862415%+262422140919069$+262423507866480#+262426300070404"+262425400899773!+262429327156944 +262425764398098+262427781011394+262428364066992+262423708872299+262425795110036+262429036290546+262424281572954+262429010509315+262424089718744+262429003418232+262423783601263+262424198432458+262425189479918+262422443453976+262422343221128+262426095769836+262425591274792+262426062450406+262427899937218 +262422583780985 +262425798549646 +262421064084791 +262425652086025 +262425741359741+262423489057550+262429637308092+262427941252320+262421468247176+262426446219011+262428780541884+ 262424339994774 J  6  I 7 G [  y 8 X ' &$ h Hz Z J5 j  | F Y 9 } i  l ( % k W {013J%491617200721I%491615343548H%491613572543G%491611303170F%491616842362E%491615630053D%491618215235C%491610886570B%491612445088A%491615822312@%491611408846?%491614105741>%491611054223=%491610750100<%491614354653;%491612634521:%4916123805459%4916107672788%4916134148237%4916178410506%4916141075355%4916174710124%4916143041073%4916127343682%4916114007271%4916124583380%491611653132/%491611267448.%491613847646-%491613204564,%491612781148+%491610836435*%491613306852)%491615162282(%491613680386'%491618755207&%491612567725%%491616752151$%491610316307#%491617465353"%491616270012!%491616806807 %491617620838%491614031622%491615007372%491617732306%491610406631%491611083634%491612477480%491615856853%491613335600%491617735265%491611774644%491615683708%491617260385%491616528484%491617745242%491612200220%491614056016%491611474421%491613160168 %491613604410 %491614556326 %491618612367 %491613247641 %491611810804%491615723550%491610020723%491613107346%491615867762%491614517447%491618721411% 491613823802   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 i  Q 9  a 1   u Uu E ] y5q -    9 ) m M a %  M Y e A  I! }  =+262424851907737J+262426159489741I+262421764101293H+262423121684047G+262425432142673F+262426311865883E+262425776527573D+262423571149100C+262428956577499B+262420230144563A+262424794711712@+262423012187851?+262425362051808>+262429698077520=+262420478844858<+262426362217592;+262423977848808:+2624242674947139+2624257556878958+2624290915799597+2624247418568756+2624257283783025+2624261710772564+2624210042955073+2624204707152252+2624242304502971+2624277985321210+262423144634343/+262420050076065.+262429092258691-+262427590631622,+262421885538664++262422291585125*+262421215603387)+262420938835875(+262425481264470'+262425955938357&+262421350862415%+262422140919069$+262423507866480#+262426300070404"+262425400899773!+262429327156944 +262425764398098+262427781011394+262428364066992+262423708872299+262425795110036+262429036290546+262424281572954+262429010509315+262424089718744+262429003418232+262423783601263+262424198432458+262425189479918+262422443453976+262422343221128+262426095769836+262425591274792+262426062450406+262427899937218 +262422583780985 +262425798549646 +262421064084791 +262425652086025 +262425741359741+262423489057550+262429637308092+262427941252320+262421468247176+262426446219011+262428780541884+ 262424339994774 8J+) 26242485190773701312345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624261594897414916172007213H+% 2624217641012934916153435483G+% 2624231216840474916135725433F+% 2624254321426734916113031703E+% 2624263118658834916168423623D+% 2624257765275734916156300533C+% 2624235711491004916182152353B+% 2624289565774994916108865703A+% 2624202301445634916124450883@+% 2624247947117124916158223123?+% 2624230121878514916114088463>+% 2624253620518084916141057413=+% 2624296980775204916110542233<+% 2624204788448584916107501003;+% 2624263622175924916143546533:+% 26242397784880849161263452139+% 26242426749471349161238054538+% 26242575568789549161076727837+% 26242909157995949161341482336+% 26242474185687549161784105035+% 26242572837830249161410753534+% 26242617107725649161747101233+% 26242100429550749161430410732+% 26242047071522549161273436831+% 26242423045029749161140072730+% 2624277985321214916124583383/+% 2624231446343434916116531323.+% 2624200500760654916112674483-+% 2624290922586914916138476463,+% 2624275906316224916132045643++% 2624218855386644916127811483*+% 2624222915851254916108364353)+% 2624212156033874916133068523(+% 2624209388358754916151622823'+% 2624254812644704916136803863&+% 2624259559383574916187552073%+% 2624213508624154916125677253$+% 2624221409190694916167521513#+% 2624235078664804916103163073"+% 2624263000704044916174653533!+% 2624254008997734916162700123 +% 2624293271569444916168068073+% 2624257643980984916176208383+% 2624277810113944916140316223+% 2624283640669924916150073723+% 2624237088722994916177323063+% 2624257951100364916104066313+% 2624290362905464916110836343+% 2624242815729544916124774803+% 2624290105093154916158568533+% 2624240897187444916133356003+% 2624290034182324916177352653+% 2624237836012634916117746443+% 2624241984324584916156837083+% 2624251894799184916172603853+% 2624224434539764916165284843+% 2624223432211284916177452423+% 2624260957698364916122002203+% 2624255912747924916140560163+% 2624260624504064916114744213 +% 2624278999372184916131601683 +% 2624225837809854916136044103 +% 2624257985496464916145563263 +% 2624210640847914916186123673 +% 2624256520860254916132476413+% 2624257413597414916118108043+% 2624234890575504916157235503+% 2624296373080924916100207233+% 2624279412523204916131073463+% 2624214682471764916158677623+% 2624264462190114916145174473+% 262428780541884491618721411[+%7 3262424339994774491613823802MSC-00-00-00-00-00-002024-10-30 08:56:06