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     1 } 9 Q  = M a A u5 U 9 y )  e i E  m]q  ! -u I M Y a%+262425384046194J+262429281939833I+262424503476380H+262424838822857G+262428421768276F+262428329106117E+262420792221465D+262421924431436C+262425885795329B+262420782872209A+262426291902433@+262420562855369?+262425949704285>+262423976488799=+262423476617452<+262426964552422;+262425709920314:+2624214002062999+2624279274314738+2624235823297427+2624222126625846+2624254975140585+2624240555131294+2624207760909343+2624216360320162+2624286275347931+2624247790578840+262425374559307/+262427262655875.+262421398426199-+262420429078209,+262428772440012++262422129258632*+262429645758320)+262422186311413(+262420490924309'+262424590386729&+262427839905514%+262421065994927$+262427440971044#+262429631311802"+262427988728242!+262420243633540 +262420577328169+262428901678019+262429566297109+262422808313280+262424081089862+262425905471368+262427191309820+262428456163766+262424958298476+262428844490841+262428080080324+262428238076128+262425213447156+262427817240112+262421113645402+262428357674048+262426095530177+262425794873923+262420463709934 +262428453034876 +262429863491043 +262421759308763 +262424461085080 +262429827945742+262428750952269+262428542831602+262424365431256+262420835338207+262423882981786+262429524025299+ 262420944606779 J H  I { 9 | j5 l   h   Z J 6 7$ YW ' (y F [ i &  }XG 8  % k z 281J%491614551075I%491610853541H%491613641801G%491615127685F%491612530431E%491616516884D%491618785637C%491617688428B%491610410271A%491612753520@%491616166485?%491613554286>%491612145508=%491615480148<%491618334055;%491614351548:%4916170562809%4916103708138%4916136227427%4916181325586%4916111514605%4916137236474%4916135355033%4916147607872%4916102274041%4916100600470%491616853708/%491612038044.%491613132306-%491610201262,%491616335785+%491614034078*%491610005613)%491614244861(%491612163104'%491610612582&%491616470324%%491617702450$%491613880865#%491612537117"%491617810663!%491613622610 %491617278777%491616088165%491611173857%491618130274%491614031278%491616775345%491616581370%491616112404%491618510522%491614652416%491613612875%491610225316%491618581580%491617277507%491617475726%491613547506%491611305884%491612775265%491614231124 %491612323333 %491615017754 %491614351216 %491613256450 %491614663450%491615350478%491612638040%491612674051%491616513344%491618074021%491614382264% 491615257741   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     1 } 9 Q  = M a A u5 U 9 y )  e i E  m]q  ! -u I M Y a%+262425384046194J+262429281939833I+262424503476380H+262424838822857G+262428421768276F+262428329106117E+262420792221465D+262421924431436C+262425885795329B+262420782872209A+262426291902433@+262420562855369?+262425949704285>+262423976488799=+262423476617452<+262426964552422;+262425709920314:+2624214002062999+2624279274314738+2624235823297427+2624222126625846+2624254975140585+2624240555131294+2624207760909343+2624216360320162+2624286275347931+2624247790578840+262425374559307/+262427262655875.+262421398426199-+262420429078209,+262428772440012++262422129258632*+262429645758320)+262422186311413(+262420490924309'+262424590386729&+262427839905514%+262421065994927$+262427440971044#+262429631311802"+262427988728242!+262420243633540 +262420577328169+262428901678019+262429566297109+262422808313280+262424081089862+262425905471368+262427191309820+262428456163766+262424958298476+262428844490841+262428080080324+262428238076128+262425213447156+262427817240112+262421113645402+262428357674048+262426095530177+262425794873923+262420463709934 +262428453034876 +262429863491043 +262421759308763 +262424461085080 +262429827945742+262428750952269+262428542831602+262424365431256+262420835338207+262423882981786+262429524025299+ 262420944606779 8J+) 26242538404619428112345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624292819398334916145510753H+% 2624245034763804916108535413G+% 2624248388228574916136418013F+% 2624284217682764916151276853E+% 2624283291061174916125304313D+% 2624207922214654916165168843C+% 2624219244314364916187856373B+% 2624258857953294916176884283A+% 2624207828722094916104102713@+% 2624262919024334916127535203?+% 2624205628553694916161664853>+% 2624259497042854916135542863=+% 2624239764887994916121455083<+% 2624234766174524916154801483;+% 2624269645524224916183340553:+% 26242570992031449161435154839+% 26242140020629949161705628038+% 26242792743147349161037081337+% 26242358232974249161362274236+% 26242221266258449161813255835+% 26242549751405849161115146034+% 26242405551312949161372364733+% 26242077609093449161353550332+% 26242163603201649161476078731+% 26242862753479349161022740430+% 2624247790578844916100600473/+% 2624253745593074916168537083.+% 2624272626558754916120380443-+% 2624213984261994916131323063,+% 2624204290782094916102012623++% 2624287724400124916163357853*+% 2624221292586324916140340783)+% 2624296457583204916100056133(+% 2624221863114134916142448613'+% 2624204909243094916121631043&+% 2624245903867294916106125823%+% 2624278399055144916164703243$+% 2624210659949274916177024503#+% 2624274409710444916138808653"+% 2624296313118024916125371173!+% 2624279887282424916178106633 +% 2624202436335404916136226103+% 2624205773281694916172787773+% 2624289016780194916160881653+% 2624295662971094916111738573+% 2624228083132804916181302743+% 2624240810898624916140312783+% 2624259054713684916167753453+% 2624271913098204916165813703+% 2624284561637664916161124043+% 2624249582984764916185105223+% 2624288444908414916146524163+% 2624280800803244916136128753+% 2624282380761284916102253163+% 2624252134471564916185815803+% 2624278172401124916172775073+% 2624211136454024916174757263+% 2624283576740484916135475063+% 2624260955301774916113058843+% 2624257948739234916127752653 +% 2624204637099344916142311243 +% 2624284530348764916123233333 +% 2624298634910434916150177543 +% 2624217593087634916143512163 +% 2624244610850804916132564503+% 2624298279457424916146634503+% 2624287509522694916153504783+% 2624285428316024916126380403+% 2624243654312564916126740513+% 2624208353382074916165133443+% 2624238829817864916180740213+% 262429524025299491614382264[+%7 3262420944606779491615257741MSC-00-00-00-00-00-002024-11-04 12:26:06