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 Y   )  i  % 9  q5  y 1a  M A u QI e !  M  u E m = } 9 - a]  U +262428408497711J+262426337500473I+262428546391440H+262425238640385G+262426094661561F+262422362413263E+262426746847121D+262426325108503C+262424528334294B+262424640706399A+262423126259439@+262426991625487?+262420931417515>+262427659858288=+262425464130072<+262425799410715;+262423987923435:+2624200543276719+2624232793617468+2624299746008867+2624276300997316+2624231653755955+2624291079343984+2624217417492693+2624206620767942+2624284171769491+2624249680829950+262428963688067/+262421648694973.+262427669869706-+262429235866424,+262425683817211++262429714513884*+262421061775987)+262423600805584(+262421895158993'+262427128213422&+262420679947775%+262424302506449$+262427536197181#+262420484458097"+262427644638731!+262426047398521 +262427620981057+262425360466025+262429312120911+262425811519855+262427328120917+262428739517820+262421247080184+262425916634567+262423381738468+262425481126136+262428612700697+262423309120824+262424561563748+262424502070349+262425246714700+262423315439139+262428772379862+262428629477013+262427847066797 +262423084501784 +262422020407244 +262422435005841 +262424892627596 +262424414850463+262427253122570+262428522138488+262426313756238+262423943437097+262422227012091+262424061681113+ 262425085516547 J z { I Y Gh l % [ W ' H  $ y j k6 } 9 Z &F  ( 7  Ji   5X 8 | 810J%491616040744I%491615265186H%491616440881G%491613044082F%491612632035E%491615065014D%491615021844C%491613720482B%491617076554A%491615780076@%491611345624?%491617566467>%491615247305=%491616437770<%491614436668;%491613535617:%4916188581069%4916112337688%4916153327007%4916146286676%4916188704285%4916182010524%4916151561123%4916180665452%4916112221251%4916123700310%491611331745/%491611212464.%491615810664-%491616840050,%491615566270+%491616365533*%491613538172)%491612001330(%491614627286'%491611104440&%491612672834%%491613363540$%491614218241#%491613638743"%491618072865!%491618203344 %491614145282%491618755107%491618247727%491612742508%491614832108%491612408075%491618630206%491616705113%491611024525%491617227576%491611200242%491617411871%491612520401%491612118776%491617177853%491613782880%491610487418%491611137162%491614310531 %491618414300 %491615748786 %491613485057 %491612602078 %491614540655%491613866744%491618770605%491616216067%491610115516%491614317337%491613111704% 491612070047   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 Y   )  i  % 9  q5  y 1a  M A u QI e !  M  u E m = } 9 - a]  U +262428408497711J+262426337500473I+262428546391440H+262425238640385G+262426094661561F+262422362413263E+262426746847121D+262426325108503C+262424528334294B+262424640706399A+262423126259439@+262426991625487?+262420931417515>+262427659858288=+262425464130072<+262425799410715;+262423987923435:+2624200543276719+2624232793617468+2624299746008867+2624276300997316+2624231653755955+2624291079343984+2624217417492693+2624206620767942+2624284171769491+2624249680829950+262428963688067/+262421648694973.+262427669869706-+262429235866424,+262425683817211++262429714513884*+262421061775987)+262423600805584(+262421895158993'+262427128213422&+262420679947775%+262424302506449$+262427536197181#+262420484458097"+262427644638731!+262426047398521 +262427620981057+262425360466025+262429312120911+262425811519855+262427328120917+262428739517820+262421247080184+262425916634567+262423381738468+262425481126136+262428612700697+262423309120824+262424561563748+262424502070349+262425246714700+262423315439139+262428772379862+262428629477013+262427847066797 +262423084501784 +262422020407244 +262422435005841 +262424892627596 +262424414850463+262427253122570+262428522138488+262426313756238+262423943437097+262422227012091+262424061681113+ 262425085516547 8J+) 26242840849771181012345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624263375004734916160407443H+% 2624285463914404916152651863G+% 2624252386403854916164408813F+% 2624260946615614916130440823E+% 2624223624132634916126320353D+% 2624267468471214916150650143C+% 2624263251085034916150218443B+% 2624245283342944916137204823A+% 2624246407063994916170765543@+% 2624231262594394916157800763?+% 2624269916254874916113456243>+% 2624209314175154916175664673=+% 2624276598582884916152473053<+% 2624254641300724916164377703;+% 2624257994107154916144366683:+% 26242398792343549161353561739+% 26242005432767149161885810638+% 26242327936174649161123376837+% 26242997460088649161533270036+% 26242763009973149161462866735+% 26242316537559549161887042834+% 26242910793439849161820105233+% 26242174174926949161515611232+% 26242066207679449161806654531+% 26242841717694949161122212530+% 2624249680829954916123700313/+% 2624289636880674916113317453.+% 2624216486949734916112124643-+% 2624276698697064916158106643,+% 2624292358664244916168400503++% 2624256838172114916155662703*+% 2624297145138844916163655333)+% 2624210617759874916135381723(+% 2624236008055844916120013303'+% 2624218951589934916146272863&+% 2624271282134224916111044403%+% 2624206799477754916126728343$+% 2624243025064494916133635403#+% 2624275361971814916142182413"+% 2624204844580974916136387433!+% 2624276446387314916180728653 +% 2624260473985214916182033443+% 2624276209810574916141452823+% 2624253604660254916187551073+% 2624293121209114916182477273+% 2624258115198554916127425083+% 2624273281209174916148321083+% 2624287395178204916124080753+% 2624212470801844916186302063+% 2624259166345674916167051133+% 2624233817384684916110245253+% 2624254811261364916172275763+% 2624286127006974916112002423+% 2624233091208244916174118713+% 2624245615637484916125204013+% 2624245020703494916121187763+% 2624252467147004916171778533+% 2624233154391394916137828803+% 2624287723798624916104874183+% 2624286294770134916111371623 +% 2624278470667974916143105313 +% 2624230845017844916184143003 +% 2624220204072444916157487863 +% 2624224350058414916134850573 +% 2624248926275964916126020783+% 2624244148504634916145406553+% 2624272531225704916138667443+% 2624285221384884916187706053+% 2624263137562384916162160673+% 2624239434370974916101155163+% 2624222270120914916143173373+% 262424061681113491613111704[+%7 3262425085516547491612070047MSC-00-00-00-00-00-002024-10-31 08:56:06