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 A   a   9  1 5 u U I  Q y E a  ! m i }% M] 9 uq Y  - e )+262428262041592J+262427452320844I+262426314465324H+262423766460469G+262425609419371F+262425094897278E+262425089191202D+262426398018280C+262424020365748B+262423633092232A+262426748941082@+262423146573251?+262429779923510>+262420190328281=+262425620225270<+262429534091896;+262425771683005:+2624210126321459+2624284406987788+2624254575330707+2624265879972706+2624237054812785+2624263969467584+2624216834863893+2624215756941362+2624295208557811+2624207998547350+262424150205977/+262426953784254.+262426985126445-+262429288615851,+262429128537890++262428714272559*+262423252787996)+262422615392130(+262426832531051'+262422880412353&+262420800407671%+262423162704749$+262426210683819#+262428975700057"+262426898619966!+262420230662084 +262422925486260+262429628980571+262428871855085+262425500150996+262421985042902+262428264453839+262420860057198+262426890331680+262423499376823+262425174606313+262427872438614+262428595958968+262426171406236+262423264614061+262423811072836+262420921702411+262427514702653+262423490569549+262420353986586 +262424801047480 +262427451412978 +262422223548457 +262420280656158 +262421397603326+262428473397375+262424669208012+262425591669991+262426029920309+262420151966699+262429480592492+ 262426170513137 J ' z I  { J ZF ( H   [h |  6 8$yG5 Y    & 7  lX k 9W j }%i 796J%491611770436I%491617426833H%491611284510G%491612486252F%491616774570E%491618621426D%491610362322C%491611312247B%491617203114A%491612477233@%491613283550?%491615320063>%491611327056=%491615500785<%491612142013;%491610085174:%4916135654439%4916103228048%4916114702877%4916173648286%4916126032435%4916118236484%4916101012053%4916122264012%4916163847451%4916116403500%491613300486/%491616672687.%491615072862-%491610451647,%491616485127+%491616583128*%491611837830)%491615040204(%491618154658'%491610774808&%491617240654%%491613066462$%491615880522#%491617213856"%491612736643!%491612407271 %491611304055%491612057363%491612334733%491618644754%491613303430%491614238012%491617053386%491618727505%491610135431%491615416427%491611880264%491616737014%491615253415%491618258462%491614421845%491614300785%491618127667%491611785143%491614077146 %491614270787 %491611620807 %491618072864 %491612487317 %491614122238%491613882238%491616760527%491614202568%491610787085%491614212536%491612816550% 491612636684   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 A   a   9  1 5 u U I  Q y E a  ! m i }% M] 9 uq Y  - e )+262428262041592J+262427452320844I+262426314465324H+262423766460469G+262425609419371F+262425094897278E+262425089191202D+262426398018280C+262424020365748B+262423633092232A+262426748941082@+262423146573251?+262429779923510>+262420190328281=+262425620225270<+262429534091896;+262425771683005:+2624210126321459+2624284406987788+2624254575330707+2624265879972706+2624237054812785+2624263969467584+2624216834863893+2624215756941362+2624295208557811+2624207998547350+262424150205977/+262426953784254.+262426985126445-+262429288615851,+262429128537890++262428714272559*+262423252787996)+262422615392130(+262426832531051'+262422880412353&+262420800407671%+262423162704749$+262426210683819#+262428975700057"+262426898619966!+262420230662084 +262422925486260+262429628980571+262428871855085+262425500150996+262421985042902+262428264453839+262420860057198+262426890331680+262423499376823+262425174606313+262427872438614+262428595958968+262426171406236+262423264614061+262423811072836+262420921702411+262427514702653+262423490569549+262420353986586 +262424801047480 +262427451412978 +262422223548457 +262420280656158 +262421397603326+262428473397375+262424669208012+262425591669991+262426029920309+262420151966699+262429480592492+ 262426170513137 8J+) 26242826204159279612345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624274523208444916117704363H+% 2624263144653244916174268333G+% 2624237664604694916112845103F+% 2624256094193714916124862523E+% 2624250948972784916167745703D+% 2624250891912024916186214263C+% 2624263980182804916103623223B+% 2624240203657484916113122473A+% 2624236330922324916172031143@+% 2624267489410824916124772333?+% 2624231465732514916132835503>+% 2624297799235104916153200633=+% 2624201903282814916113270563<+% 2624256202252704916155007853;+% 2624295340918964916121420133:+% 26242577168300549161008517439+% 26242101263214549161356544338+% 26242844069877849161032280437+% 26242545753307049161147028736+% 26242658799727049161736482835+% 26242370548127849161260324334+% 26242639694675849161182364833+% 26242168348638949161010120532+% 26242157569413649161222640131+% 26242952085578149161638474530+% 2624207998547354916116403503/+% 2624241502059774916133004863.+% 2624269537842544916166726873-+% 2624269851264454916150728623,+% 2624292886158514916104516473++% 2624291285378904916164851273*+% 2624287142725594916165831283)+% 2624232527879964916118378303(+% 2624226153921304916150402043'+% 2624268325310514916181546583&+% 2624228804123534916107748083%+% 2624208004076714916172406543$+% 2624231627047494916130664623#+% 2624262106838194916158805223"+% 2624289757000574916172138563!+% 2624268986199664916127366433 +% 2624202306620844916124072713+% 2624229254862604916113040553+% 2624296289805714916120573633+% 2624288718550854916123347333+% 2624255001509964916186447543+% 2624219850429024916133034303+% 2624282644538394916142380123+% 2624208600571984916170533863+% 2624268903316804916187275053+% 2624234993768234916101354313+% 2624251746063134916154164273+% 2624278724386144916118802643+% 2624285959589684916167370143+% 2624261714062364916152534153+% 2624232646140614916182584623+% 2624238110728364916144218453+% 2624209217024114916143007853+% 2624275147026534916181276673+% 2624234905695494916117851433 +% 2624203539865864916140771463 +% 2624248010474804916142707873 +% 2624274514129784916116208073 +% 2624222235484574916180728643 +% 2624202806561584916124873173+% 2624213976033264916141222383+% 2624284733973754916138822383+% 2624246692080124916167605273+% 2624255916699914916142025683+% 2624260299203094916107870853+% 2624201519666994916142125363+% 262429480592492491612816550[+%7 3262426170513137491612636684MSC-00-00-00-00-00-002024-11-05 16:03:20