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 U Y A  } u ) i  a   1% 9 e  I 95 y Q q mM u ]! a E   - M  = +262423274136205J+262429359089625I+262422378165920H+262421264086414G+262429523985324F+262421821561267E+262421901118386D+262427914626848C+262423451540593B+262424016188488A+262422706003319@+262428903615826?+262421341114695>+262429605564992=+262426556828402<+262423629630443;+262426103603724:+2624203020704239+2624239841937748+2624279925420117+2624296391805296+2624274381242535+2624266046331014+2624291143399503+2624229468569192+2624292828330731+2624201816121190+262420058795280/+262422193042755.+262420636517298-+262421194178987,+262424160343100++262425316674032*+262425910609109)+262427309719758(+262420441114629'+262421782394484&+262422369606299%+262423019809758$+262428549879304#+262420069631810"+262426837446674!+262423856031932 +262427647887167+262421076422819+262429049825010+262421126958531+262426243977977+262423327835414+262424013074861+262427866332544+262425397953183+262425023882118+262427781388472+262426751362655+262427461821438+262429137831915+262427502441339+262426928539113+262429570379733+262429778899627+262422656210047 +262423724991697 +262423262436511 +262425341847581 +262427294658961 +262428032325799+262427603094849+262424468315596+262420314547025+262428558761906+262420976431710+262426173263916+ 262425503194830 J  } I H  &Gy { %  F  k  Y (W ' 7 h 9 i J Z $z 5 8 |  lX [ j6 295J%491613747213I%491616003251H%491616727485G%491618586403F%491618057851E%491610478862D%491618576404C%491618786382B%491612183217A%491612662303@%491616142016?%491612467063>%491611316142=%491611338768<%491617826220;%491614488687:%4916176531549%4916106442348%4916167403467%4916123680866%4916178201315%4916125323204%4916157064013%4916155087452%4916155857701%4916168402120%491612317816/%491615772733.%491610757841-%491611642077,%491610785707+%491615208301*%491610703102)%491613742511(%491618635478'%491611123405&%491612373218%%491611743422$%491610334757#%491615465085"%491614478342!%491610014715 %491617121082%491616071462%491612777717%491611357236%491618732136%491611020374%491618451063%491616311235%491617022340%491610578336%491615343264%491613153545%491611253508%491613220638%491615857640%491618308286%491614437648%491618872474%491616845075 %491617520151 %491611750777 %491614027847 %491615785041 %491611102315%491617712532%491612255663%491618512751%491613021617%491610167721%491618132582% 491617206554   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 U Y A  } u ) i  a   1% 9 e  I 95 y Q q mM u ]! a E   - M  = +262423274136205J+262429359089625I+262422378165920H+262421264086414G+262429523985324F+262421821561267E+262421901118386D+262427914626848C+262423451540593B+262424016188488A+262422706003319@+262428903615826?+262421341114695>+262429605564992=+262426556828402<+262423629630443;+262426103603724:+2624203020704239+2624239841937748+2624279925420117+2624296391805296+2624274381242535+2624266046331014+2624291143399503+2624229468569192+2624292828330731+2624201816121190+262420058795280/+262422193042755.+262420636517298-+262421194178987,+262424160343100++262425316674032*+262425910609109)+262427309719758(+262420441114629'+262421782394484&+262422369606299%+262423019809758$+262428549879304#+262420069631810"+262426837446674!+262423856031932 +262427647887167+262421076422819+262429049825010+262421126958531+262426243977977+262423327835414+262424013074861+262427866332544+262425397953183+262425023882118+262427781388472+262426751362655+262427461821438+262429137831915+262427502441339+262426928539113+262429570379733+262429778899627+262422656210047 +262423724991697 +262423262436511 +262425341847581 +262427294658961 +262428032325799+262427603094849+262424468315596+262420314547025+262428558761906+262420976431710+262426173263916+ 262425503194830 8J+) 26242327413620529512345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624293590896254916137472133H+% 2624223781659204916160032513G+% 2624212640864144916167274853F+% 2624295239853244916185864033E+% 2624218215612674916180578513D+% 2624219011183864916104788623C+% 2624279146268484916185764043B+% 2624234515405934916187863823A+% 2624240161884884916121832173@+% 2624227060033194916126623033?+% 2624289036158264916161420163>+% 2624213411146954916124670633=+% 2624296055649924916113161423<+% 2624265568284024916113387683;+% 2624236296304434916178262203:+% 26242610360372449161448868739+% 26242030207042349161765315438+% 26242398419377449161064423437+% 26242799254201149161674034636+% 26242963918052949161236808635+% 26242743812425349161782013134+% 26242660463310149161253232033+% 26242911433995049161570640132+% 26242294685691949161550874531+% 26242928283307349161558577030+% 2624201816121194916168402123/+% 2624200587952804916123178163.+% 2624221930427554916157727333-+% 2624206365172984916107578413,+% 2624211941789874916116420773++% 2624241603431004916107857073*+% 2624253166740324916152083013)+% 2624259106091094916107031023(+% 2624273097197584916137425113'+% 2624204411146294916186354783&+% 2624217823944844916111234053%+% 2624223696062994916123732183$+% 2624230198097584916117434223#+% 2624285498793044916103347573"+% 2624200696318104916154650853!+% 2624268374466744916144783423 +% 2624238560319324916100147153+% 2624276478871674916171210823+% 2624210764228194916160714623+% 2624290498250104916127777173+% 2624211269585314916113572363+% 2624262439779774916187321363+% 2624233278354144916110203743+% 2624240130748614916184510633+% 2624278663325444916163112353+% 2624253979531834916170223403+% 2624250238821184916105783363+% 2624277813884724916153432643+% 2624267513626554916131535453+% 2624274618214384916112535083+% 2624291378319154916132206383+% 2624275024413394916158576403+% 2624269285391134916183082863+% 2624295703797334916144376483+% 2624297788996274916188724743 +% 2624226562100474916168450753 +% 2624237249916974916175201513 +% 2624232624365114916117507773 +% 2624253418475814916140278473 +% 2624272946589614916157850413+% 2624280323257994916111023153+% 2624276030948494916177125323+% 2624244683155964916122556633+% 2624203145470254916185127513+% 2624285587619064916130216173+% 2624209764317104916101677213+% 262426173263916491618132582[+%7 3262425503194830491617206554MSC-00-00-00-00-00-002024-10-15 05:56:07