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  Y u M = m } ! A  9 y  5u  aI 1] )   9 a     q - M Q U e i  % E+262426708400103J+262420877452778I+262426742440578H+262420744882777G+262422597980370F+262421149177069E+262422056617001D+262422027930091C+262421084453149B+262427487469486A+262427936810524@+262427571761526?+262426050019069>+262421492444483=+262428763407411<+262429236033957;+262423609450038:+2624294773080709+2624271115081798+2624217779431427+2624295625441726+2624217105679145+2624204285642124+2624295254103523+2624202677119022+2624280506840471+2624223333165290+262428842904585/+262429466688014.+262421642300828-+262428089313322,+262423009686652++262424760034372*+262427981761156)+262424387405863(+262423483726345'+262424128516660&+262427787625510%+262425768904120$+262429598170816#+262420330248062"+262421623807514!+262422753602395 +262426496082679+262426116620844+262425667671527+262429059586254+262423775942978+262426733077451+262427382047299+262421717196396+262424505583699+262425768250489+262425871126701+262428035958338+262426267559564+262427019019766+262424988282317+262421734071657+262422604888771+262423346588439+262423932274689 +262429444628551 +262429584131385 +262423095715176 +262428307213447 +262425699657101+262424700235768+262424930750542+262426670955345+262429995075623+262425448127443+262424913123437+ 262427946219688 J { 7 8 J6 | Z  ' 9Wh  [  & H i% j$ F  I y   l Xz ( G  k  Y 5 } 214J%491617016317I%491612522036H%491610640573G%491613576351F%491616121603E%491618601825D%491613402250C%491613412582B%491615128101A%491616168245@%491611228075?%491612382206>%491612008732=%491616018820<%491617705410;%491612506315:%4916104666729%4916154006338%4916117125117%4916175733026%4916116587535%4916172876444%4916135303403%4916183683752%4916154110581%4916133581060%491614044331/%491618871235.%491613717511-%491617545421,%491613718530+%491610046642*%491613884381)%491618248522(%491614465326'%491610017141&%491615202227%%491618636671$%491616080337#%491615365784"%491616307280!%491613466000 %491615863237%491617154707%491612228317%491614363636%491610758206%491617331575%491616515448%491614057176%491616762554%491615250822%491613114067%491611872756%491610155370%491616061444%491613528676%491616037215%491616371718%491613482768%491614636030 %491618431571 %491615141581 %491613270717 %491613344671 %491615565201%491612776102%491615346212%491612220670%491616317015%491614050001%491616001861% 491617761810   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  Y u M = m } ! A  9 y  5u  aI 1] )   9 a     q - M Q U e i  % E+262426708400103J+262420877452778I+262426742440578H+262420744882777G+262422597980370F+262421149177069E+262422056617001D+262422027930091C+262421084453149B+262427487469486A+262427936810524@+262427571761526?+262426050019069>+262421492444483=+262428763407411<+262429236033957;+262423609450038:+2624294773080709+2624271115081798+2624217779431427+2624295625441726+2624217105679145+2624204285642124+2624295254103523+2624202677119022+2624280506840471+2624223333165290+262428842904585/+262429466688014.+262421642300828-+262428089313322,+262423009686652++262424760034372*+262427981761156)+262424387405863(+262423483726345'+262424128516660&+262427787625510%+262425768904120$+262429598170816#+262420330248062"+262421623807514!+262422753602395 +262426496082679+262426116620844+262425667671527+262429059586254+262423775942978+262426733077451+262427382047299+262421717196396+262424505583699+262425768250489+262425871126701+262428035958338+262426267559564+262427019019766+262424988282317+262421734071657+262422604888771+262423346588439+262423932274689 +262429444628551 +262429584131385 +262423095715176 +262428307213447 +262425699657101+262424700235768+262424930750542+262426670955345+262429995075623+262425448127443+262424913123437+ 262427946219688 8J+) 26242670840010321412345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624208774527784916170163173H+% 2624267424405784916125220363G+% 2624207448827774916106405733F+% 2624225979803704916135763513E+% 2624211491770694916161216033D+% 2624220566170014916186018253C+% 2624220279300914916134022503B+% 2624210844531494916134125823A+% 2624274874694864916151281013@+% 2624279368105244916161682453?+% 2624275717615264916112280753>+% 2624260500190694916123822063=+% 2624214924444834916120087323<+% 2624287634074114916160188203;+% 2624292360339574916177054103:+% 26242360945003849161250631539+% 26242947730807049161046667238+% 26242711150817949161540063337+% 26242177794314249161171251136+% 26242956254417249161757330235+% 26242171056791449161165875334+% 26242042856421249161728764433+% 26242952541035249161353034032+% 26242026771190249161836837531+% 26242805068404749161541105830+% 2624223333165294916133581063/+% 2624288429045854916140443313.+% 2624294666880144916188712353-+% 2624216423008284916137175113,+% 2624280893133224916175454213++% 2624230096866524916137185303*+% 2624247600343724916100466423)+% 2624279817611564916138843813(+% 2624243874058634916182485223'+% 2624234837263454916144653263&+% 2624241285166604916100171413%+% 2624277876255104916152022273$+% 2624257689041204916186366713#+% 2624295981708164916160803373"+% 2624203302480624916153657843!+% 2624216238075144916163072803 +% 2624227536023954916134660003+% 2624264960826794916158632373+% 2624261166208444916171547073+% 2624256676715274916122283173+% 2624290595862544916143636363+% 2624237759429784916107582063+% 2624267330774514916173315753+% 2624273820472994916165154483+% 2624217171963964916140571763+% 2624245055836994916167625543+% 2624257682504894916152508223+% 2624258711267014916131140673+% 2624280359583384916118727563+% 2624262675595644916101553703+% 2624270190197664916160614443+% 2624249882823174916135286763+% 2624217340716574916160372153+% 2624226048887714916163717183+% 2624233465884394916134827683 +% 2624239322746894916146360303 +% 2624294446285514916184315713 +% 2624295841313854916151415813 +% 2624230957151764916132707173 +% 2624283072134474916133446713+% 2624256996571014916155652013+% 2624247002357684916127761023+% 2624249307505424916153462123+% 2624266709553454916122206703+% 2624299950756234916163170153+% 2624254481274434916140500013+% 262424913123437491616001861[+%7 3262427946219688491617761810MSC-00-00-00-00-00-002024-09-29 08:25:59