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 9I5 Q m!M9 U u a    e ) A %] -a 9  uq 1 y  }   Y  i M  =  E+262424654907586J+262429105064477I+262422764829444H+262422749285364G+262428000139960F+262425394632534E+262428738542759D+262423716455045C+262429020972057B+262429747003081A+262427848686379@+262423464833006?+262423834590226>+262429551072457=+262420660129055<+262423809068025;+262427703244986:+2624286954392629+2624262808858378+2624291154392627+2624276233458916+2624262965155045+2624237337105664+2624231427751333+2624234230157052+2624245390953551+2624242829560420+262422634559910/+262428879206708.+262427785783732-+262420450541235,+262422313538589++262426989533499*+262427349926390)+262425025459269(+262426998228823'+262424630684868&+262427753452138%+262427668327834$+262429947586323#+262427936797318"+262420698419400!+262424641307635 +262427605757146+262424393200471+262422772142860+262422538062411+262427786394075+262429745876838+262429514060170+262420776839896+262420191186731+262420029163303+262424443304220+262426028325265+262428919195804+262420269127907+262428353173035+262427791001241+262424504541782+262422268930336+262429753864958 +262425957994623 +262424418509165 +262421965916820 +262421056078354 +262424615041723+262425579551791+262420734466904+262425769889819+262425308695656+262420692352567+262429317569691+ 262420702960929 J jy (6 k H  } l   & Y I 85  $ F  {i X |   7 z% 'G Z   [h 9  J W180J%491610744358I%491618606282H%491618713272G%491618222210F%491611731651E%491611412257D%491618464012C%491612548688B%491610025721A%491617521136@%491613164111?%491611206710>%491613520750=%491613226417<%491615350307;%491617221214:%4916128824789%4916127641668%4916172802507%4916108433036%4916151128435%4916108714344%4916117703733%4916144274012%4916100436341%4916154827660%491613305843/%491615726624.%491618710803-%491618748457,%491612351473+%491615716121*%491610881250)%491612627633(%491610355244'%491614132115&%491618555524%%491612225303$%491610038358#%491614476745"%491617851427!%491613845844 %491617626358%491616040035%491615523340%491616722457%491610804654%491617272078%491614818718%491614374425%491615806487%491611211318%491616220106%491614214785%491617662638%491612087475%491610606003%491612345738%491618272777%491616322112%491613472078 %491613106072 %491613650572 %491618784638 %491618322171 %491610675475%491618632660%491614010061%491611621401%491612011332%491611106550%491618031787% 491612438316   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 9I5 Q m!M9 U u a    e ) A %] -a 9  uq 1 y  }   Y  i M  =  E+262424654907586J+262429105064477I+262422764829444H+262422749285364G+262428000139960F+262425394632534E+262428738542759D+262423716455045C+262429020972057B+262429747003081A+262427848686379@+262423464833006?+262423834590226>+262429551072457=+262420660129055<+262423809068025;+262427703244986:+2624286954392629+2624262808858378+2624291154392627+2624276233458916+2624262965155045+2624237337105664+2624231427751333+2624234230157052+2624245390953551+2624242829560420+262422634559910/+262428879206708.+262427785783732-+262420450541235,+262422313538589++262426989533499*+262427349926390)+262425025459269(+262426998228823'+262424630684868&+262427753452138%+262427668327834$+262429947586323#+262427936797318"+262420698419400!+262424641307635 +262427605757146+262424393200471+262422772142860+262422538062411+262427786394075+262429745876838+262429514060170+262420776839896+262420191186731+262420029163303+262424443304220+262426028325265+262428919195804+262420269127907+262428353173035+262427791001241+262424504541782+262422268930336+262429753864958 +262425957994623 +262424418509165 +262421965916820 +262421056078354 +262424615041723+262425579551791+262420734466904+262425769889819+262425308695656+262420692352567+262429317569691+ 262420702960929 8J+) 26242465490758618012345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624291050644774916107443583H+% 2624227648294444916186062823G+% 2624227492853644916187132723F+% 2624280001399604916182222103E+% 2624253946325344916117316513D+% 2624287385427594916114122573C+% 2624237164550454916184640123B+% 2624290209720574916125486883A+% 2624297470030814916100257213@+% 2624278486863794916175211363?+% 2624234648330064916131641113>+% 2624238345902264916112067103=+% 2624295510724574916135207503<+% 2624206601290554916132264173;+% 2624238090680254916153503073:+% 26242770324498649161722121439+% 26242869543926249161288247838+% 26242628088583749161276416637+% 26242911543926249161728025036+% 26242762334589149161084330335+% 26242629651550449161511284334+% 26242373371056649161087143433+% 26242314277513349161177037332+% 26242342301570549161442740131+% 26242453909535549161004363430+% 2624242829560424916154827663/+% 2624226345599104916133058433.+% 2624288792067084916157266243-+% 2624277857837324916187108033,+% 2624204505412354916187484573++% 2624223135385894916123514733*+% 2624269895334994916157161213)+% 2624273499263904916108812503(+% 2624250254592694916126276333'+% 2624269982288234916103552443&+% 2624246306848684916141321153%+% 2624277534521384916185555243$+% 2624276683278344916122253033#+% 2624299475863234916100383583"+% 2624279367973184916144767453!+% 2624206984194004916178514273 +% 2624246413076354916138458443+% 2624276057571464916176263583+% 2624243932004714916160400353+% 2624227721428604916155233403+% 2624225380624114916167224573+% 2624277863940754916108046543+% 2624297458768384916172720783+% 2624295140601704916148187183+% 2624207768398964916143744253+% 2624201911867314916158064873+% 2624200291633034916112113183+% 2624244433042204916162201063+% 2624260283252654916142147853+% 2624289191958044916176626383+% 2624202691279074916120874753+% 2624283531730354916106060033+% 2624277910012414916123457383+% 2624245045417824916182727773+% 2624222689303364916163221123 +% 2624297538649584916134720783 +% 2624259579946234916131060723 +% 2624244185091654916136505723 +% 2624219659168204916187846383 +% 2624210560783544916183221713+% 2624246150417234916106754753+% 2624255795517914916186326603+% 2624207344669044916140100613+% 2624257698898194916116214013+% 2624253086956564916120113323+% 2624206923525674916111065503+% 262429317569691491618031787[+%7 3262420702960929491612438316MSC-00-00-00-00-00-002024-09-07 05:56:12