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 %E~I u @ l 7  c . Z % Q }H'%+ 2624222797061703$+% 2624214270827344916118553173#+% 2624202772327504916164861563"+% 2624287181787944916132830373!+% 2624217616346894916124063103 +% 2624248463421484916118817003+% 2624234871514194916144328443+% 2624246389802034916171788883+% 2624266961395194916175551103+% 2624224092583694916175725343+% 2624250666296974916168173883+% 2624265091056694916178405323+% 2624265280883674916186634313+% 2624283725517134916114820613+% 2624216168738624916134658343+% 2624250025862374916107252683+% 2624253271450694916126662233+% 2624280247455674916188876473+% 2624244525467884916188035173+% 2624298611225344916146861023+% 2624240812081844916163513513+% 2624288378316804916146677313+% 2624278117011654916137025213+% 2624293606049874916106821673 +% 2624231157494704916100670453 +% 2624203652155564916144773833 +% 2624296993619654916157821353 +% 2624267717860474916172334443 +% 2624215362611324916105458853+% 2624251615793844916108102063+% 2624257696809894916103770433+% 2624256397522924916164877223+% 262427912326763491612054887[+%7 3262422034363510491613662768MSC-00-00-00-00-00-002024-10-30 16:03:34[+%7 3262427379236099491618018851MSC-00-00-00-00-00-002024-10-30 16:03:24'+ 2624266637610513+% 262428111241024491610857150 %  E 1M5 m    I a]u   9q! Y%+262422279706170%+262421427082734$+262420277232750#+262428718178794"+262421761634689!+262424846342148 +262423487151419+262424638980203+262426696139519+262422409258369+262425066629697+262426509105669+262426528088367+262428372551713+262421616873862+262425002586237+262425327145069+262428024745567+262424452546788+262429861122534+262424081208184+262428837831680+262427811701165+262429360604987+262423115749470 +262420365215556 +262429699361965 +262426771786047 +262421536261132 +262425161579384+262425769680989+262425639752292+262427912326763+262422034363510+262427379236099+262426663761051+ 262428111241024 %  0tu    AR Bc 1Sd%%491611855317$%491616486156#%491613283037"%491612406310!%491611881700 %491614432844%491617178888%491617555110%491617572534%491616817388%491617840532%491618663431%491611482061%491613465834%491610725268%491612666223%491618887647%491618803517%491614686102%491616351351%491614667731%491613702521%491610682167%491610067045 %491614477383 %491615782135 %491617233444 %491610545885 %491610810206%491610377043%491616487722%491612054887%491613662768%491618018851% 491610857150    g@X2 p J # b ; %$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  wg7 S  o # ? [  wJ$MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ#MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ"MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ!MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJ MM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FJMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2FKMM101112131415161718191A1B1C1D1E1F202122232425262728292A2B2C2D2E2F! 7MSC-00-00-00-00-00-00 7 MSC-00-00-00-00-00-00 %  E 1M5 m    I a]u   9q! Y%+262422279706170%+262421427082734$+262420277232750#+262428718178794"+262421761634689!+262424846342148 +262423487151419+262424638980203+262426696139519+262422409258369+262425066629697+262426509105669+262426528088367+262428372551713+262421616873862+262425002586237+262425327145069+262428024745567+262424452546788+262429861122534+262424081208184+262428837831680+262427811701165+262429360604987+262423115749470 +262420365215556 +262429699361965 +262426771786047 +262421536261132 +262425161579384+262425769680989+262425639752292+262427912326763+262422034363510+262427379236099+262426663761051+ 262428111241024