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 } i% Mq 5  -    ) a U a  Y9 9 = Q  I E yM u m] u A    ! e+262425181586001J+262421227825806I+262424179580867H+262428861956387G+262429443602884F+262429109130330E+262422507241458D+262428074822605C+262422862668876B+262425688043966A+262423671893556@+262429586745592?+262423853509363>+262425238425760=+262425700081937<+262429936920876;+262427669431465:+2624218107412559+2624223887007768+2624254612221737+2624292775040426+2624230929526125+2624228632529204+2624249551066243+2624266334167892+2624225896940951+2624289732272130+262424420896175/+262421030062381.+262420967758668-+262420853931403,+262426132740475++262429187149517*+262422024703108)+262428997066942(+262424656747762'+262420906092351&+262429713384415%+262420736560946$+262427432124992#+262425012808689"+262428290343522!+262425815580491 +262423577907203+262428532980122+262427146040242+262424956102333+262428446372451+262426265218343+262429361570616+262429893856012+262422190700746+262427038481473+262428411352880+262421574836777+262423569429524+262429304607064+262422705784215+262429987551307+262420143834644+262427897737035+262428161910840 +262421155200142 +262421064062685 +262425151977622 +262427996773591 +262424682281093+262428118088337+262426575351252+262421688359794+262429466989432+262422560406848+262428326109080+ 262423579661417 J [ WhG (z  k  6X 7   }  y$ I  l 9 Yi { &%F5     ' 8 | H j J Z 684J%491610575163I%491614553154H%491618277151G%491610187677F%491614533465E%491613127111D%491616554251C%491616432567B%491618803427A%491615780847@%491618454708?%491612445251>%491610215216=%491613647812<%491617071041;%491617601517:%4916181036059%4916144485028%4916185165507%4916111278726%4916182152175%4916186304324%4916114615053%4916121435632%4916111837671%4916137155080%491618254400/%491618284132.%491614475103-%491611011187,%491615105825+%491611771052*%491618243411)%491614650158(%491618256221'%491614738816&%491611015326%%491610283655$%491618600204#%491616206562"%491618455173!%491615327554 %491612744865%491616273321%491612311542%491615236213%491611500234%491610563070%491611520118%491614717435%491610805173%491613680584%491611521053%491614646736%491612655865%491610372341%491612171376%491612265845%491613178138%491614538373%491613833531 %491615300681 %491615286315 %491610482286 %491610523461 %491613748150%491612546343%491610586444%491615871614%491617423171%491611262237%491617015343% 491616287017   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 } i% Mq 5  -    ) a U a  Y9 9 = Q  I E yM u m] u A    ! e+262425181586001J+262421227825806I+262424179580867H+262428861956387G+262429443602884F+262429109130330E+262422507241458D+262428074822605C+262422862668876B+262425688043966A+262423671893556@+262429586745592?+262423853509363>+262425238425760=+262425700081937<+262429936920876;+262427669431465:+2624218107412559+2624223887007768+2624254612221737+2624292775040426+2624230929526125+2624228632529204+2624249551066243+2624266334167892+2624225896940951+2624289732272130+262424420896175/+262421030062381.+262420967758668-+262420853931403,+262426132740475++262429187149517*+262422024703108)+262428997066942(+262424656747762'+262420906092351&+262429713384415%+262420736560946$+262427432124992#+262425012808689"+262428290343522!+262425815580491 +262423577907203+262428532980122+262427146040242+262424956102333+262428446372451+262426265218343+262429361570616+262429893856012+262422190700746+262427038481473+262428411352880+262421574836777+262423569429524+262429304607064+262422705784215+262429987551307+262420143834644+262427897737035+262428161910840 +262421155200142 +262421064062685 +262425151977622 +262427996773591 +262424682281093+262428118088337+262426575351252+262421688359794+262429466989432+262422560406848+262428326109080+ 262423579661417 8J+) 26242518158600168412345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624212278258064916105751633H+% 2624241795808674916145531543G+% 2624288619563874916182771513F+% 2624294436028844916101876773E+% 2624291091303304916145334653D+% 2624225072414584916131271113C+% 2624280748226054916165542513B+% 2624228626688764916164325673A+% 2624256880439664916188034273@+% 2624236718935564916157808473?+% 2624295867455924916184547083>+% 2624238535093634916124452513=+% 2624252384257604916102152163<+% 2624257000819374916136478123;+% 2624299369208764916170710413:+% 26242766943146549161760151739+% 26242181074125549161810360538+% 26242238870077649161444850237+% 26242546122217349161851655036+% 26242927750404249161112787235+% 26242309295261249161821521734+% 26242286325292049161863043233+% 26242495510662449161146150532+% 26242663341678949161214356331+% 26242258969409549161118376730+% 2624289732272134916137155083/+% 2624244208961754916182544003.+% 2624210300623814916182841323-+% 2624209677586684916144751033,+% 2624208539314034916110111873++% 2624261327404754916151058253*+% 2624291871495174916117710523)+% 2624220247031084916182434113(+% 2624289970669424916146501583'+% 2624246567477624916182562213&+% 2624209060923514916147388163%+% 2624297133844154916110153263$+% 2624207365609464916102836553#+% 2624274321249924916186002043"+% 2624250128086894916162065623!+% 2624282903435224916184551733 +% 2624258155804914916153275543+% 2624235779072034916127448653+% 2624285329801224916162733213+% 2624271460402424916123115423+% 2624249561023334916152362133+% 2624284463724514916115002343+% 2624262652183434916105630703+% 2624293615706164916115201183+% 2624298938560124916147174353+% 2624221907007464916108051733+% 2624270384814734916136805843+% 2624284113528804916115210533+% 2624215748367774916146467363+% 2624235694295244916126558653+% 2624293046070644916103723413+% 2624227057842154916121713763+% 2624299875513074916122658453+% 2624201438346444916131781383+% 2624278977370354916145383733 +% 2624281619108404916138335313 +% 2624211552001424916153006813 +% 2624210640626854916152863153 +% 2624251519776224916104822863 +% 2624279967735914916105234613+% 2624246822810934916137481503+% 2624281180883374916125463433+% 2624265753512524916105864443+% 2624216883597944916158716143+% 2624294669894324916174231713+% 2624225604068484916112622373+% 262428326109080491617015343[+%7 3262423579661417491616287017MSC-00-00-00-00-00-002024-10-12 08:26:00