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  9]  = y E e ! }   % a U )q Y  A 9 M  m 1 M 5u u QI a i - +262425835135761J+262425921797691I+262423899338124H+262428260124146G+262421515949684F+262423111586410E+262422827856760D+262428361175625C+262422494661997B+262423600668134A+262423619899581@+262420737793392?+262424237671857>+262422016779940=+262428417960397<+262422315050223;+262422138806372:+2624229672834389+2624242782244938+2624200062688567+2624228591686486+2624234365130225+2624264463472704+2624299040264263+2624236803590682+2624297398151161+2624256443572320+262424114397575/+262429733517401.+262422930199213-+262421506893941,+262420413979379++262421827423650*+262428933395815)+262427780110902(+262425331005299'+262427801221077&+262429366366665%+262427072712659$+262422222637853#+262424512819499"+262426671784250!+262428028798863 +262420500838509+262420486670329+262422449061630+262422324049700+262427605276431+262426234369219+262421054421221+262422772203467+262428040580541+262428556840419+262420954070985+262424253932939+262426034298504+262425230553188+262421717418523+262422260106168+262426097219423+262422564411633+262422092668427 +262420563107169 +262423683131395 +262420932201741 +262427676858266 +262429552478292+262428064479300+262425300738947+262425641468895+262426432119267+262429893631755+262425064046903+ 262423354473481 J  i GW Z }% { y  9z 86 7$  X &  '  ( l j  Y 5 J  kFh I H  | [300J%491615723872I%491613338751H%491617404005G%491618655724F%491615757777E%491611763248D%491618360647C%491614766580B%491614501061A%491615651672@%491615027024?%491613134204>%491614506618=%491616544621<%491611334450;%491615380561:%4916134280669%4916181286478%4916117601707%4916177421626%4916186304225%4916183583164%4916120673353%4916147635252%4916141483251%4916182041450%491612525334/%491612780322.%491612843236-%491618477781,%491614705425+%491613723834*%491618142077)%491617064261(%491616000145'%491612024304&%491617121007%%491617583452$%491610523222#%491611666112"%491614480530!%491616113548 %491612657377%491616646470%491613071814%491612016155%491613520854%491611340110%491614626303%491610678663%491613375726%491614578042%491617015707%491611402561%491610661047%491613108271%491615850640%491617571410%491610143736%491615386514%491613872805 %491617332200 %491617805431 %491611662044 %491618052745 %491612475053%491610400480%491614505667%491613702121%491610612802%491617730836%491614856015% 491615653113   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  9]  = y E e ! }   % a U )q Y  A 9 M  m 1 M 5u u QI a i - +262425835135761J+262425921797691I+262423899338124H+262428260124146G+262421515949684F+262423111586410E+262422827856760D+262428361175625C+262422494661997B+262423600668134A+262423619899581@+262420737793392?+262424237671857>+262422016779940=+262428417960397<+262422315050223;+262422138806372:+2624229672834389+2624242782244938+2624200062688567+2624228591686486+2624234365130225+2624264463472704+2624299040264263+2624236803590682+2624297398151161+2624256443572320+262424114397575/+262429733517401.+262422930199213-+262421506893941,+262420413979379++262421827423650*+262428933395815)+262427780110902(+262425331005299'+262427801221077&+262429366366665%+262427072712659$+262422222637853#+262424512819499"+262426671784250!+262428028798863 +262420500838509+262420486670329+262422449061630+262422324049700+262427605276431+262426234369219+262421054421221+262422772203467+262428040580541+262428556840419+262420954070985+262424253932939+262426034298504+262425230553188+262421717418523+262422260106168+262426097219423+262422564411633+262422092668427 +262420563107169 +262423683131395 +262420932201741 +262427676858266 +262429552478292+262428064479300+262425300738947+262425641468895+262426432119267+262429893631755+262425064046903+ 262423354473481 8J+) 26242583513576130012345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624259217976914916157238723H+% 2624238993381244916133387513G+% 2624282601241464916174040053F+% 2624215159496844916186557243E+% 2624231115864104916157577773D+% 2624228278567604916117632483C+% 2624283611756254916183606473B+% 2624224946619974916147665803A+% 2624236006681344916145010613@+% 2624236198995814916156516723?+% 2624207377933924916150270243>+% 2624242376718574916131342043=+% 2624220167799404916145066183<+% 2624284179603974916165446213;+% 2624223150502234916113344503:+% 26242213880637249161538056139+% 26242296728343849161342806638+% 26242427822449349161812864737+% 26242000626885649161176017036+% 26242285916864849161774216235+% 26242343651302249161863042234+% 26242644634727049161835831633+% 26242990402642649161206733532+% 26242368035906849161476352531+% 26242973981511649161414832530+% 2624256443572324916182041453/+% 2624241143975754916125253343.+% 2624297335174014916127803223-+% 2624229301992134916128432363,+% 2624215068939414916184777813++% 2624204139793794916147054253*+% 2624218274236504916137238343)+% 2624289333958154916181420773(+% 2624277801109024916170642613'+% 2624253310052994916160001453&+% 2624278012210774916120243043%+% 2624293663666654916171210073$+% 2624270727126594916175834523#+% 2624222226378534916105232223"+% 2624245128194994916116661123!+% 2624266717842504916144805303 +% 2624280287988634916161135483+% 2624205008385094916126573773+% 2624204866703294916166464703+% 2624224490616304916130718143+% 2624223240497004916120161553+% 2624276052764314916135208543+% 2624262343692194916113401103+% 2624210544212214916146263033+% 2624227722034674916106786633+% 2624280405805414916133757263+% 2624285568404194916145780423+% 2624209540709854916170157073+% 2624242539329394916114025613+% 2624260342985044916106610473+% 2624252305531884916131082713+% 2624217174185234916158506403+% 2624222601061684916175714103+% 2624260972194234916101437363+% 2624225644116334916153865143 +% 2624220926684274916138728053 +% 2624205631071694916173322003 +% 2624236831313954916178054313 +% 2624209322017414916116620443 +% 2624276768582664916180527453+% 2624295524782924916124750533+% 2624280644793004916104004803+% 2624253007389474916145056673+% 2624256414688954916137021213+% 2624264321192674916106128023+% 2624298936317554916177308363+% 262425064046903491614856015[+%7 3262423354473481491615653113MSC-00-00-00-00-00-002024-10-16 12:02:59