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  u M U a u  )q E y ! =]  5  m }  I  a 1    i9 9 A % Q e  +262427267140817J+262420139914160I+262426624248206H+262421965902974G+262426970052405F+262423986522676E+262426242269406D+262428577008509C+262420821541754B+262423581318350A+262421481671338@+262426912677279?+262423010302323>+262423829660836=+262429200086144<+262429326459075;+262423453016476:+2624246798054039+2624230597549908+2624293284168137+2624298181012256+2624265691936285+2624207223494824+2624268996212853+2624241788147322+2624200207909721+2624276451442560+262421426003716/+262427076873477.+262425649166427-+262420713521400,+262425717940433++262426373589782*+262425702961463)+262428139834519(+262421375439249'+262421851369863&+262429836865929%+262426715603928$+262423437650267#+262420236672275"+262425279285823!+262425736510848 +262429730774286+262426557715417+262427048822191+262428809716659+262422512167480+262420241658876+262421192114324+262423730744157+262424669756074+262426209074254+262423946906475+262423022711969+262422806134039+262420567543934+262427437831329+262427518471819+262425734210622+262424090102548+262425406274485 +262426476958443 +262428329492174 +262427083171891 +262421017299227 +262421600878447+262420741536852+262421576323968+262422644131456+262429554860863+262424809729967+262427075932866+ 262427244170405 J k Z  9 7 y '%  $ & | 6 8F  Y h { ( z }W l [   G Ii5 JX j H 027J%491614726447I%491610675481H%491617714550G%491615740371F%491615664006E%491615056154D%491616633377C%491614230103B%491617528336A%491616204527@%491615802510?%491611883026>%491612778588=%491615768253<%491614828621;%491611586785:%4916127242139%4916167068058%4916102043117%4916102028736%4916120865775%4916111238864%4916176808153%4916123608312%4916162581421%4916102002520%491610366730/%491613104672.%491610226317-%491618284004,%491612067656+%491611050378*%491618270068)%491613107721(%491618175265'%491613741438&%491611304521%%491611861305$%491610306322#%491616211773"%491612722726!%491616205440 %491613656608%491617047023%491613832754%491611748047%491612522124%491616346485%491618152230%491616817582%491614866148%491613300662%491616147836%491618426786%491617371722%491611625164%491613103783%491617452830%491611868323%491613846013%491612012246 %491617237413 %491612748711 %491615632782 %491613716385 %491611205053%491611820402%491610240008%491613700573%491615013416%491613564204%491612023281% 491612473268   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  u M U a u  )q E y ! =]  5  m }  I  a 1    i9 9 A % Q e  +262427267140817J+262420139914160I+262426624248206H+262421965902974G+262426970052405F+262423986522676E+262426242269406D+262428577008509C+262420821541754B+262423581318350A+262421481671338@+262426912677279?+262423010302323>+262423829660836=+262429200086144<+262429326459075;+262423453016476:+2624246798054039+2624230597549908+2624293284168137+2624298181012256+2624265691936285+2624207223494824+2624268996212853+2624241788147322+2624200207909721+2624276451442560+262421426003716/+262427076873477.+262425649166427-+262420713521400,+262425717940433++262426373589782*+262425702961463)+262428139834519(+262421375439249'+262421851369863&+262429836865929%+262426715603928$+262423437650267#+262420236672275"+262425279285823!+262425736510848 +262429730774286+262426557715417+262427048822191+262428809716659+262422512167480+262420241658876+262421192114324+262423730744157+262424669756074+262426209074254+262423946906475+262423022711969+262422806134039+262420567543934+262427437831329+262427518471819+262425734210622+262424090102548+262425406274485 +262426476958443 +262428329492174 +262427083171891 +262421017299227 +262421600878447+262420741536852+262421576323968+262422644131456+262429554860863+262424809729967+262427075932866+ 262427244170405 8J+) 26242726714081702712345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624201399141604916147264473H+% 2624266242482064916106754813G+% 2624219659029744916177145503F+% 2624269700524054916157403713E+% 2624239865226764916156640063D+% 2624262422694064916150561543C+% 2624285770085094916166333773B+% 2624208215417544916142301033A+% 2624235813183504916175283363@+% 2624214816713384916162045273?+% 2624269126772794916158025103>+% 2624230103023234916118830263=+% 2624238296608364916127785883<+% 2624292000861444916157682533;+% 2624293264590754916148286213:+% 26242345301647649161158678539+% 26242467980540349161272421338+% 26242305975499049161670680537+% 26242932841681349161020431136+% 26242981810122549161020287335+% 26242656919362849161208657734+% 26242072234948249161112388633+% 26242689962128549161768081532+% 26242417881473249161236083131+% 26242002079097249161625814230+% 2624276451442564916102002523/+% 2624214260037164916103667303.+% 2624270768734774916131046723-+% 2624256491664274916102263173,+% 2624207135214004916182840043++% 2624257179404334916120676563*+% 2624263735897824916110503783)+% 2624257029614634916182700683(+% 2624281398345194916131077213'+% 2624213754392494916181752653&+% 2624218513698634916137414383%+% 2624298368659294916113045213$+% 2624267156039284916118613053#+% 2624234376502674916103063223"+% 2624202366722754916162117733!+% 2624252792858234916127227263 +% 2624257365108484916162054403+% 2624297307742864916136566083+% 2624265577154174916170470233+% 2624270488221914916138327543+% 2624288097166594916117480473+% 2624225121674804916125221243+% 2624202416588764916163464853+% 2624211921143244916181522303+% 2624237307441574916168175823+% 2624246697560744916148661483+% 2624262090742544916133006623+% 2624239469064754916161478363+% 2624230227119694916184267863+% 2624228061340394916173717223+% 2624205675439344916116251643+% 2624274378313294916131037833+% 2624275184718194916174528303+% 2624257342106224916118683233+% 2624240901025484916138460133 +% 2624254062744854916120122463 +% 2624264769584434916172374133 +% 2624283294921744916127487113 +% 2624270831718914916156327823 +% 2624210172992274916137163853+% 2624216008784474916112050533+% 2624207415368524916118204023+% 2624215763239684916102400083+% 2624226441314564916137005733+% 2624295548608634916150134163+% 2624248097299674916135642043+% 262427075932866491612023281[+%7 3262427244170405491612473268MSC-00-00-00-00-00-002024-10-11 05:56:06