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 9 - a  a  i %  1  9 A YI u M u ]M U  5 ) }  =  Q q y  e m! E+262423993428799J+262425254117327I+262421981475918H+262425090504894G+262423538036818F+262420006796018E+262427432838816D+262423904576287C+262426067649730B+262422843206617A+262422102221260@+262423654061508?+262427567432918>+262428201962723=+262428515160205<+262429607452166;+262428795551833:+2624260471335329+2624296121132768+2624270509530457+2624219570749896+2624202405344835+2624252322703534+2624283714790983+2624211910862502+2624209153720401+2624243880421960+262427108285428/+262422179641473.+262427617540453-+262421065277235,+262425444695903++262421459248161*+262422911562803)+262429076166459(+262428100985044'+262427243767827&+262426450310434%+262423381706260$+262429926697779#+262424503333348"+262429620190113!+262423545764367 +262425646367260+262428592080479+262420187988919+262426447121331+262426956406414+262423239550489+262423150569071+262429861988639+262427519136960+262424674879925+262426743136826+262428610927864+262422157156698+262424445027216+262422187255474+262422144595043+262426818704657+262428733521250+262421488153010 +262427620989990 +262422875443344 +262420487819456 +262426834964477 +262421331230982+262425744308711+262428153151141+262421253946616+262429248034821+262422635644342+262427427576637+ 262421601715206 J  G H j I | 8 9  {Xy l h Z$   [ &i YW   J k z  7  %  (F } '  65 664J%491617452075I%491611601585H%491614817362G%491613736768F%491612744170E%491617557823D%491617143888C%491617012007B%491613782547A%491618138045@%491616651507?%491615858465>%491617068710=%491614388030<%491613170460;%491617824685:%4916115370139%4916112384078%4916128361357%4916156211166%4916115274545%4916167244844%4916136381263%4916165867872%4916110472631%4916151634130%491617827283/%491614483468.%491610132016-%491611671368,%491614000265+%491616507442*%491610732681)%491614031480(%491610840088'%491612078232&%491612787533%%491615675363$%491610463187#%491611311181"%491614631505!%491615300212 %491614305584%491610840250%491613645370%491616663213%491618332634%491610542116%491612227184%491614028022%491615810150%491611600778%491611528656%491618020881%491616018841%491616616741%491612172621%491617321887%491618467344%491616002456%491613085405 %491618814256 %491617504226 %491614035314 %491612807135 %491612743853%491612482026%491617545647%491614165502%491614724024%491618380767%491616532154% 491612163788   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 9 - a  a  i %  1  9 A YI u M u ]M U  5 ) }  =  Q q y  e m! E+262423993428799J+262425254117327I+262421981475918H+262425090504894G+262423538036818F+262420006796018E+262427432838816D+262423904576287C+262426067649730B+262422843206617A+262422102221260@+262423654061508?+262427567432918>+262428201962723=+262428515160205<+262429607452166;+262428795551833:+2624260471335329+2624296121132768+2624270509530457+2624219570749896+2624202405344835+2624252322703534+2624283714790983+2624211910862502+2624209153720401+2624243880421960+262427108285428/+262422179641473.+262427617540453-+262421065277235,+262425444695903++262421459248161*+262422911562803)+262429076166459(+262428100985044'+262427243767827&+262426450310434%+262423381706260$+262429926697779#+262424503333348"+262429620190113!+262423545764367 +262425646367260+262428592080479+262420187988919+262426447121331+262426956406414+262423239550489+262423150569071+262429861988639+262427519136960+262424674879925+262426743136826+262428610927864+262422157156698+262424445027216+262422187255474+262422144595043+262426818704657+262428733521250+262421488153010 +262427620989990 +262422875443344 +262420487819456 +262426834964477 +262421331230982+262425744308711+262428153151141+262421253946616+262429248034821+262422635644342+262427427576637+ 262421601715206 8J+) 26242399342879966412345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624252541173274916174520753H+% 2624219814759184916116015853G+% 2624250905048944916148173623F+% 2624235380368184916137367683E+% 2624200067960184916127441703D+% 2624274328388164916175578233C+% 2624239045762874916171438883B+% 2624260676497304916170120073A+% 2624228432066174916137825473@+% 2624221022212604916181380453?+% 2624236540615084916166515073>+% 2624275674329184916158584653=+% 2624282019627234916170687103<+% 2624285151602054916143880303;+% 2624296074521664916131704603:+% 26242879555183349161782468539+% 26242604713353249161153701338+% 26242961211327649161123840737+% 26242705095304549161283613536+% 26242195707498949161562111635+% 26242024053448349161152745434+% 26242523227035349161672448433+% 26242837147909849161363812632+% 26242119108625049161658678731+% 26242091537204049161104726330+% 2624243880421964916151634133/+% 2624271082854284916178272833.+% 2624221796414734916144834683-+% 2624276175404534916101320163,+% 2624210652772354916116713683++% 2624254446959034916140002653*+% 2624214592481614916165074423)+% 2624229115628034916107326813(+% 2624290761664594916140314803'+% 2624281009850444916108400883&+% 2624272437678274916120782323%+% 2624264503104344916127875333$+% 2624233817062604916156753633#+% 2624299266977794916104631873"+% 2624245033333484916113111813!+% 2624296201901134916146315053 +% 2624235457643674916153002123+% 2624256463672604916143055843+% 2624285920804794916108402503+% 2624201879889194916136453703+% 2624264471213314916166632133+% 2624269564064144916183326343+% 2624232395504894916105421163+% 2624231505690714916122271843+% 2624298619886394916140280223+% 2624275191369604916158101503+% 2624246748799254916116007783+% 2624267431368264916115286563+% 2624286109278644916180208813+% 2624221571566984916160188413+% 2624244450272164916166167413+% 2624221872554744916121726213+% 2624221445950434916173218873+% 2624268187046574916184673443+% 2624287335212504916160024563 +% 2624214881530104916130854053 +% 2624276209899904916188142563 +% 2624228754433444916175042263 +% 2624204878194564916140353143 +% 2624268349644774916128071353+% 2624213312309824916127438533+% 2624257443087114916124820263+% 2624281531511414916175456473+% 2624212539466164916141655023+% 2624292480348214916147240243+% 2624226356443424916183807673+% 262427427576637491616532154[+%7 3262421601715206491612163788MSC-00-00-00-00-00-002024-07-02 05:56:57