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 5 9   E i ! I a M 1 =%M A U   9 a  Q e Y  u]u m  } )q - y+262421331002230J+262423688063616I+262425805178123H+262427841122340G+262421284649987F+262425429559888E+262421380008940D+262425173215480C+262422963624942B+262421555325091A+262425045934956@+262422238633019?+262429233601363>+262424026409011=+262426849073692<+262427444520915;+262429962116953:+2624226977126779+2624214556554548+2624226604194387+2624233728116036+2624246108099505+2624209328476784+2624235743431523+2624277279306752+2624296077803551+2624246132139590+262424784500973/+262422081492172.+262429179663676-+262426559682860,+262420927603888++262423305975598*+262425562884017)+262420373861847(+262423418970268'+262428827815356&+262425037354482%+262423954606507$+262422043020701#+262427492754915"+262428245146045!+262426178275577 +262425159993429+262429527560701+262421428927657+262428404791956+262421093035611+262424433287966+262421575394290+262422638596718+262420473891625+262422991391216+262427968293915+262429393028725+262427323175461+262421591509967+262426736157260+262429756546818+262429303914936+262428435610536+262429326316435 +262420082955459 +262424358629416 +262425680272665 +262424423538294 +262423641391865+262428174246613+262428107142790+262424120742363+262427020654671+262426623032738+262424766103388+ 262424629281874 J  h  Z H l  '  Y 8 7 j I { k 6X }G 9 J 5 & [ y |i zW %    $ (F205J%491618826785I%491615340322H%491615345803G%491616032062F%491611777750E%491615153007D%491618615226C%491618573466B%491612026112A%491617052248@%491617585363?%491612435681>%491611103876=%491618353684<%491618756024;%491612545088:%4916131773319%4916133788608%4916112165017%4916144807006%4916166835235%4916187531164%4916180808063%4916140045542%4916154082001%4916176816240%491617360080/%491612347706.%491617702081-%491612633236,%491615880181+%491613207180*%491611634173)%491612834773(%491613246783'%491614347351&%491610325027%%491616810347$%491614784781#%491614775743"%491616217767!%491615656877 %491611448107%491612431058%491610340688%491617376544%491615088647%491615331157%491615130031%491616774473%491617136531%491611343117%491611006174%491611341631%491617601875%491610286776%491613132125%491610304223%491617267123%491616038044%491618802622 %491615510508 %491618838630 %491617211284 %491610588770 %491616675571%491613621150%491618550854%491615225241%491615231631%491610733455%491617286818% 491611188726   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 5 9   E i ! I a M 1 =%M A U   9 a  Q e Y  u]u m  } )q - y+262421331002230J+262423688063616I+262425805178123H+262427841122340G+262421284649987F+262425429559888E+262421380008940D+262425173215480C+262422963624942B+262421555325091A+262425045934956@+262422238633019?+262429233601363>+262424026409011=+262426849073692<+262427444520915;+262429962116953:+2624226977126779+2624214556554548+2624226604194387+2624233728116036+2624246108099505+2624209328476784+2624235743431523+2624277279306752+2624296077803551+2624246132139590+262424784500973/+262422081492172.+262429179663676-+262426559682860,+262420927603888++262423305975598*+262425562884017)+262420373861847(+262423418970268'+262428827815356&+262425037354482%+262423954606507$+262422043020701#+262427492754915"+262428245146045!+262426178275577 +262425159993429+262429527560701+262421428927657+262428404791956+262421093035611+262424433287966+262421575394290+262422638596718+262420473891625+262422991391216+262427968293915+262429393028725+262427323175461+262421591509967+262426736157260+262429756546818+262429303914936+262428435610536+262429326316435 +262420082955459 +262424358629416 +262425680272665 +262424423538294 +262423641391865+262428174246613+262428107142790+262424120742363+262427020654671+262426623032738+262424766103388+ 262424629281874 8J+) 26242133100223020512345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624236880636164916188267853H+% 2624258051781234916153403223G+% 2624278411223404916153458033F+% 2624212846499874916160320623E+% 2624254295598884916117777503D+% 2624213800089404916151530073C+% 2624251732154804916186152263B+% 2624229636249424916185734663A+% 2624215553250914916120261123@+% 2624250459349564916170522483?+% 2624222386330194916175853633>+% 2624292336013634916124356813=+% 2624240264090114916111038763<+% 2624268490736924916183536843;+% 2624274445209154916187560243:+% 26242996211695349161254508839+% 26242269771267749161317733138+% 26242145565545449161337886037+% 26242266041943849161121650136+% 26242337281160349161448070035+% 26242461080995049161668352334+% 26242093284767849161875311633+% 26242357434315249161808080632+% 26242772793067549161400455431+% 26242960778035549161540820030+% 2624246132139594916176816243/+% 2624247845009734916173600803.+% 2624220814921724916123477063-+% 2624291796636764916177020813,+% 2624265596828604916126332363++% 2624209276038884916158801813*+% 2624233059755984916132071803)+% 2624255628840174916116341733(+% 2624203738618474916128347733'+% 2624234189702684916132467833&+% 2624288278153564916143473513%+% 2624250373544824916103250273$+% 2624239546065074916168103473#+% 2624220430207014916147847813"+% 2624274927549154916147757433!+% 2624282451460454916162177673 +% 2624261782755774916156568773+% 2624251599934294916114481073+% 2624295275607014916124310583+% 2624214289276574916103406883+% 2624284047919564916173765443+% 2624210930356114916150886473+% 2624244332879664916153311573+% 2624215753942904916151300313+% 2624226385967184916167744733+% 2624204738916254916171365313+% 2624229913912164916113431173+% 2624279682939154916110061743+% 2624293930287254916113416313+% 2624273231754614916176018753+% 2624215915099674916102867763+% 2624267361572604916131321253+% 2624297565468184916103042233+% 2624293039149364916172671233+% 2624284356105364916160380443 +% 2624293263164354916188026223 +% 2624200829554594916155105083 +% 2624243586294164916188386303 +% 2624256802726654916172112843 +% 2624244235382944916105887703+% 2624236413918654916166755713+% 2624281742466134916136211503+% 2624281071427904916185508543+% 2624241207423634916152252413+% 2624270206546714916152316313+% 2624266230327384916107334553+% 262424766103388491617286818[+%7 3262424629281874491611188726MSC-00-00-00-00-00-002024-06-25 05:56:56