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 Q u 1 m u ] Y = % ) q 9 M y  i  a  e    9I  UM  a E ! A } 5 -+262426137741474J+262423801657443I+262427223483608H+262421476357107G+262423268714220F+262420287250606E+262425237545762D+262422518123428C+262427575092544B+262426428309125A+262426750619904@+262424861152652?+262422377582022>+262421771031768=+262420230342367<+262425378023842;+262423813777961:+2624246938705679+2624254455201028+2624294220122367+2624222355766196+2624260785196515+2624223610652904+2624239078559753+2624271591842322+2624299374737891+2624279847125700+262426943147250/+262424069747462.+262428431551508-+262426360419886,+262426426077526++262421321329659*+262429039650337)+262423213413925(+262421299671500'+262424405852125&+262424437805958%+262421034991676$+262427470227871#+262421744603543"+262421054410391!+262428012172441 +262425917454163+262421545470197+262425230326475+262422222725383+262424673649653+262427948484269+262425615442529+262427869121752+262429930581335+262426211767139+262421594520617+262423010331020+262423515715687+262426822219012+262422194711582+262427155824083+262422498180171+262422158343275+262425757241885 +262423497153192 +262422250974785 +262423526185851 +262427051265458 +262424785190725+262420491132678+262424883591880+262428835277855+262427873803171+262420466526487+262421703637561+ 262425924367930 J W |   Iz k [ 9 Z & J j Y H h  l yG '  6 { 8 X F ( 7 %5  }i  $351J%491616127535I%491611025132H%491611513187G%491610582360F%491613236435E%491618046753D%491618561218C%491616356867B%491614883258A%491617487438@%491610235745?%491611441066>%491613367655=%491618325205<%491610356728;%491613672647:%4916148677789%4916104041738%4916110275187%4916104872516%4916102165705%4916161586504%4916102736103%4916131282412%4916177341021%4916142125220%491612031726/%491617805426.%491613166523-%491613781685,%491611101286+%491616320476*%491612477017)%491612205244(%491611862714'%491614763763&%491613357661%%491615505543$%491612606316#%491611853726"%491610741350!%491612764166 %491612733600%491617034680%491611627753%491616563407%491614256636%491613541300%491615444754%491618048387%491610465841%491616487155%491616465853%491618502573%491613164656%491610340283%491613245071%491613717871%491610575507%491611772824%491618780368 %491617414314 %491615663215 %491610154331 %491613128684 %491613403027%491613326152%491618518266%491613765858%491618087626%491617826316%491616448048% 491610427422   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 Q u 1 m u ] Y = % ) q 9 M y  i  a  e    9I  UM  a E ! A } 5 -+262426137741474J+262423801657443I+262427223483608H+262421476357107G+262423268714220F+262420287250606E+262425237545762D+262422518123428C+262427575092544B+262426428309125A+262426750619904@+262424861152652?+262422377582022>+262421771031768=+262420230342367<+262425378023842;+262423813777961:+2624246938705679+2624254455201028+2624294220122367+2624222355766196+2624260785196515+2624223610652904+2624239078559753+2624271591842322+2624299374737891+2624279847125700+262426943147250/+262424069747462.+262428431551508-+262426360419886,+262426426077526++262421321329659*+262429039650337)+262423213413925(+262421299671500'+262424405852125&+262424437805958%+262421034991676$+262427470227871#+262421744603543"+262421054410391!+262428012172441 +262425917454163+262421545470197+262425230326475+262422222725383+262424673649653+262427948484269+262425615442529+262427869121752+262429930581335+262426211767139+262421594520617+262423010331020+262423515715687+262426822219012+262422194711582+262427155824083+262422498180171+262422158343275+262425757241885 +262423497153192 +262422250974785 +262423526185851 +262427051265458 +262424785190725+262420491132678+262424883591880+262428835277855+262427873803171+262420466526487+262421703637561+ 262425924367930 8J+) 26242613774147435112345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624238016574434916161275353H+% 2624272234836084916110251323G+% 2624214763571074916115131873F+% 2624232687142204916105823603E+% 2624202872506064916132364353D+% 2624252375457624916180467533C+% 2624225181234284916185612183B+% 2624275750925444916163568673A+% 2624264283091254916148832583@+% 2624267506199044916174874383?+% 2624248611526524916102357453>+% 2624223775820224916114410663=+% 2624217710317684916133676553<+% 2624202303423674916183252053;+% 2624253780238424916103567283:+% 26242381377796149161367264739+% 26242469387056749161486777838+% 26242544552010249161040417337+% 26242942201223649161102751836+% 26242223557661949161048725135+% 26242607851965149161021657034+% 26242236106529049161615865033+% 26242390785597549161027361032+% 26242715918423249161312824131+% 26242993747378949161773410230+% 2624279847125704916142125223/+% 2624269431472504916120317263.+% 2624240697474624916178054263-+% 2624284315515084916131665233,+% 2624263604198864916137816853++% 2624264260775264916111012863*+% 2624213213296594916163204763)+% 2624290396503374916124770173(+% 2624232134139254916122052443'+% 2624212996715004916118627143&+% 2624244058521254916147637633%+% 2624244378059584916133576613$+% 2624210349916764916155055433#+% 2624274702278714916126063163"+% 2624217446035434916118537263!+% 2624210544103914916107413503 +% 2624280121724414916127641663+% 2624259174541634916127336003+% 2624215454701974916170346803+% 2624252303264754916116277533+% 2624222227253834916165634073+% 2624246736496534916142566363+% 2624279484842694916135413003+% 2624256154425294916154447543+% 2624278691217524916180483873+% 2624299305813354916104658413+% 2624262117671394916164871553+% 2624215945206174916164658533+% 2624230103310204916185025733+% 2624235157156874916131646563+% 2624268222190124916103402833+% 2624221947115824916132450713+% 2624271558240834916137178713+% 2624224981801714916105755073+% 2624221583432754916117728243 +% 2624257572418854916187803683 +% 2624234971531924916174143143 +% 2624222509747854916156632153 +% 2624235261858514916101543313 +% 2624270512654584916131286843+% 2624247851907254916134030273+% 2624204911326784916133261523+% 2624248835918804916185182663+% 2624288352778554916137658583+% 2624278738031714916180876263+% 2624204665264874916178263163+% 262421703637561491616448048[+%7 3262425924367930491610427422MSC-00-00-00-00-00-002024-11-05 12:26:04