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 u M q 9 a  I m  %  ) A Q 5 ! - U i y    e a } Y  E]M u9 =+262421340968933J+262420429861852I+262426232912032H+262420319135879G+262424101750330F+262427507932048E+262422973442983D+262429487720774C+262422352680335B+262420297754737A+262425772297574@+262423507101989?+262423666122716>+262429983375905=+262424047552958<+262425949254077;+262425296219134:+2624211656421309+2624247984614778+2624246630533367+2624296793365156+2624256853044315+2624243760174064+2624209974233783+2624232802944532+2624244568033131+2624240348576490+262424472770438/+262424776401164.+262426953618799-+262421288512526,+262423642417679++262422126650081*+262421951195886)+262422310065907(+262428730489077'+262422459770489&+262422162832175%+262420066181583$+262427813874413#+262427342505498"+262423222351651!+262422447845386 +262424706727507+262425316869427+262423345223645+262425350485232+262424249260938+262420156369730+262421853654505+262424380558474+262424112498666+262422745567073+262428008895292+262421109938118+262422238189930+262424786939596+262425668990342+262421870346371+262427705029238+262420911703749+262425764230019 +262420944643024 +262423455319914 +262429430838142 +262428334072762 +262421940981839+262428812869062+262424097451440+262420792231250+262426055760384+262424181033377+262427947201823+ 262428998733794 J % k |h  l i {X  & J  Z  W  z ' F (  } H j 85G [ 9 7 $y  I Y6   516J%491614630668I%491616727123H%491612053238G%491616386746F%491611037276E%491614868354D%491613775308C%491615011177B%491615333205A%491611567635@%491612417246?%491610777741>%491613340376=%491610563031<%491617568323;%491614277208:%4916160465389%4916180131788%4916126236247%4916101817566%4916102523545%4916112371184%4916166118183%4916164131442%4916145251431%4916153450130%491612124076/%491616807228.%491618871325-%491614764421,%491611667486+%491616760587*%491615318800)%491618123268(%491615785004'%491611464845&%491615143432%%491613001221$%491616513106#%491615382408"%491613221870!%491618185657 %491613543582%491614635784%491617333147%491610153122%491618166451%491616135087%491611487465%491611336123%491614032456%491617851008%491617815614%491613770320%491613032310%491611625564%491616852285%491611736372%491616076780%491612425377%491616820374 %491616123236 %491614558207 %491613523053 %491610351468 %491617208265%491617642113%491610302812%491618507787%491617402721%491616387251%491614116518% 491617568025   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 u M q 9 a  I m  %  ) A Q 5 ! - U i y    e a } Y  E]M u9 =+262421340968933J+262420429861852I+262426232912032H+262420319135879G+262424101750330F+262427507932048E+262422973442983D+262429487720774C+262422352680335B+262420297754737A+262425772297574@+262423507101989?+262423666122716>+262429983375905=+262424047552958<+262425949254077;+262425296219134:+2624211656421309+2624247984614778+2624246630533367+2624296793365156+2624256853044315+2624243760174064+2624209974233783+2624232802944532+2624244568033131+2624240348576490+262424472770438/+262424776401164.+262426953618799-+262421288512526,+262423642417679++262422126650081*+262421951195886)+262422310065907(+262428730489077'+262422459770489&+262422162832175%+262420066181583$+262427813874413#+262427342505498"+262423222351651!+262422447845386 +262424706727507+262425316869427+262423345223645+262425350485232+262424249260938+262420156369730+262421853654505+262424380558474+262424112498666+262422745567073+262428008895292+262421109938118+262422238189930+262424786939596+262425668990342+262421870346371+262427705029238+262420911703749+262425764230019 +262420944643024 +262423455319914 +262429430838142 +262428334072762 +262421940981839+262428812869062+262424097451440+262420792231250+262426055760384+262424181033377+262427947201823+ 262428998733794 8J+) 26242134096893351612345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624204298618524916146306683H+% 2624262329120324916167271233G+% 2624203191358794916120532383F+% 2624241017503304916163867463E+% 2624275079320484916110372763D+% 2624229734429834916148683543C+% 2624294877207744916137753083B+% 2624223526803354916150111773A+% 2624202977547374916153332053@+% 2624257722975744916115676353?+% 2624235071019894916124172463>+% 2624236661227164916107777413=+% 2624299833759054916133403763<+% 2624240475529584916105630313;+% 2624259492540774916175683233:+% 26242529621913449161427720839+% 26242116564213049161604653838+% 26242479846147749161801317837+% 26242466305333649161262362436+% 26242967933651549161018175635+% 26242568530443149161025235434+% 26242437601740649161123711833+% 26242099742337849161661181832+% 26242328029445349161641314431+% 26242445680331349161452514330+% 2624240348576494916153450133/+% 2624244727704384916121240763.+% 2624247764011644916168072283-+% 2624269536187994916188713253,+% 2624212885125264916147644213++% 2624236424176794916116674863*+% 2624221266500814916167605873)+% 2624219511958864916153188003(+% 2624223100659074916181232683'+% 2624287304890774916157850043&+% 2624224597704894916114648453%+% 2624221628321754916151434323$+% 2624200661815834916130012213#+% 2624278138744134916165131063"+% 2624273425054984916153824083!+% 2624232223516514916132218703 +% 2624224478453864916181856573+% 2624247067275074916135435823+% 2624253168694274916146357843+% 2624233452236454916173331473+% 2624253504852324916101531223+% 2624242492609384916181664513+% 2624201563697304916161350873+% 2624218536545054916114874653+% 2624243805584744916113361233+% 2624241124986664916140324563+% 2624227455670734916178510083+% 2624280088952924916178156143+% 2624211099381184916137703203+% 2624222381899304916130323103+% 2624247869395964916116255643+% 2624256689903424916168522853+% 2624218703463714916117363723+% 2624277050292384916160767803+% 2624209117037494916124253773 +% 2624257642300194916168203743 +% 2624209446430244916161232363 +% 2624234553199144916145582073 +% 2624294308381424916135230533 +% 2624283340727624916103514683+% 2624219409818394916172082653+% 2624288128690624916176421133+% 2624240974514404916103028123+% 2624207922312504916185077873+% 2624260557603844916174027213+% 2624241810333774916163872513+% 262427947201823491614116518[+%7 3262428998733794491617568025MSC-00-00-00-00-00-002024-10-28 12:03:00