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 a - % 9 M q9 )a ] e Y  M i 5  A y  U  }  =I E   uu Q   1! m +262420999512598J+262423470674209I+262420362624191H+262428479021422G+262421579484854F+262421094775278E+262428010296245D+262424730090796C+262427970867157B+262426590494131A+262422584622449@+262428451953808?+262422010207196>+262427563528272=+262428681666421<+262422778327604;+262425110070448:+2624230857929929+2624228867108748+2624267962243057+2624205243724536+2624289231215315+2624251024249574+2624245998058883+2624258806164322+2624204579644561+2624250319670500+262425578817709/+262423520837412.+262426095279780-+262426909184362,+262425755247017++262426823930040*+262424108816647)+262424804900269(+262426993938125'+262423370631433&+262421828116704%+262428986737506$+262427819125540#+262422942538775"+262429347471009!+262429659944409 +262427832593171+262428700277916+262425194889217+262429869991034+262426172116248+262420325437831+262428929953431+262429319691376+262424588046596+262427662792129+262422668371858+262421855166971+262421090803804+262422671494426+262425404880131+262423308815630+262422392119858+262426935139107+262422141261188 +262428796287205 +262420553825298 +262421911818816 +262421770891484 +262422201231417+262428557829939+262427719458748+262428410259264+262422409734798+262420580032198+262429501581904+ 262423572464978 J ' k i H & h [$ ( 7  X  |  j Iz l6 9 5 % Y yF Z } 8  W G { J 311J%491612082018I%491614478170H%491618538614G%491612034755F%491614336038E%491617103332D%491610763084C%491613751810B%491617334875A%491618870700@%491610417886?%491611618617>%491616384508=%491615254500<%491613627842;%491610085526:%4916173222619%4916143084578%4916167744617%4916104043726%4916137443575%4916142380634%4916174761843%4916166671862%4916183748451%4916175070210%491613302413/%491612462532.%491613748562-%491612500442,%491611040783+%491612335228*%491610662785)%491616148802(%491614047213'%491618182667&%491617014447%%491614633722$%491610823217#%491613576872"%491612334554!%491615842343 %491618221271%491610521238%491614725336%491615452005%491614361646%491617874304%491613308877%491610633572%491614315775%491614723408%491610501371%491614187813%491617103733%491618825181%491615037425%491614608842%491610411580%491612456078%491612047301 %491614685555 %491616481487 %491617485131 %491611744052 %491616481070%491616176240%491616857404%491618751101%491611658400%491617405177%491616247434% 491614640557   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 a - % 9 M q9 )a ] e Y  M i 5  A y  U  }  =I E   uu Q   1! m +262420999512598J+262423470674209I+262420362624191H+262428479021422G+262421579484854F+262421094775278E+262428010296245D+262424730090796C+262427970867157B+262426590494131A+262422584622449@+262428451953808?+262422010207196>+262427563528272=+262428681666421<+262422778327604;+262425110070448:+2624230857929929+2624228867108748+2624267962243057+2624205243724536+2624289231215315+2624251024249574+2624245998058883+2624258806164322+2624204579644561+2624250319670500+262425578817709/+262423520837412.+262426095279780-+262426909184362,+262425755247017++262426823930040*+262424108816647)+262424804900269(+262426993938125'+262423370631433&+262421828116704%+262428986737506$+262427819125540#+262422942538775"+262429347471009!+262429659944409 +262427832593171+262428700277916+262425194889217+262429869991034+262426172116248+262420325437831+262428929953431+262429319691376+262424588046596+262427662792129+262422668371858+262421855166971+262421090803804+262422671494426+262425404880131+262423308815630+262422392119858+262426935139107+262422141261188 +262428796287205 +262420553825298 +262421911818816 +262421770891484 +262422201231417+262428557829939+262427719458748+262428410259264+262422409734798+262420580032198+262429501581904+ 262423572464978 8J+) 26242099951259831112345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624234706742094916120820183H+% 2624203626241914916144781703G+% 2624284790214224916185386143F+% 2624215794848544916120347553E+% 2624210947752784916143360383D+% 2624280102962454916171033323C+% 2624247300907964916107630843B+% 2624279708671574916137518103A+% 2624265904941314916173348753@+% 2624225846224494916188707003?+% 2624284519538084916104178863>+% 2624220102071964916116186173=+% 2624275635282724916163845083<+% 2624286816664214916152545003;+% 2624227783276044916136278423:+% 26242511007044849161008552639+% 26242308579299249161732226138+% 26242288671087449161430845737+% 26242679622430549161677446136+% 26242052437245349161040437235+% 26242892312153149161374435734+% 26242510242495749161423806333+% 26242459980588849161747618432+% 26242588061643249161666718631+% 26242045796445649161837484530+% 2624250319670504916175070213/+% 2624255788177094916133024133.+% 2624235208374124916124625323-+% 2624260952797804916137485623,+% 2624269091843624916125004423++% 2624257552470174916110407833*+% 2624268239300404916123352283)+% 2624241088166474916106627853(+% 2624248049002694916161488023'+% 2624269939381254916140472133&+% 2624233706314334916181826673%+% 2624218281167044916170144473$+% 2624289867375064916146337223#+% 2624278191255404916108232173"+% 2624229425387754916135768723!+% 2624293474710094916123345543 +% 2624296599444094916158423433+% 2624278325931714916182212713+% 2624287002779164916105212383+% 2624251948892174916147253363+% 2624298699910344916154520053+% 2624261721162484916143616463+% 2624203254378314916178743043+% 2624289299534314916133088773+% 2624293196913764916106335723+% 2624245880465964916143157753+% 2624276627921294916147234083+% 2624226683718584916105013713+% 2624218551669714916141878133+% 2624210908038044916171037333+% 2624226714944264916188251813+% 2624254048801314916150374253+% 2624233088156304916146088423+% 2624223921198584916104115803+% 2624269351391074916124560783 +% 2624221412611884916120473013 +% 2624287962872054916146855553 +% 2624205538252984916164814873 +% 2624219118188164916174851313 +% 2624217708914844916117440523+% 2624222012314174916164810703+% 2624285578299394916161762403+% 2624277194587484916168574043+% 2624284102592644916187511013+% 2624224097347984916116584003+% 2624205800321984916174051773+% 262429501581904491616247434[+%7 3262423572464978491614640557MSC-00-00-00-00-00-002024-10-12 12:03:02