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   I  E Y  !  Uq  Q 1 } A -  M] ) a y   u5 9  =9 i%  m eaM +262427071462135J+262424847201092I+262425244462911H+262426325502438G+262424137995618F+262427887397396E+262422219831262D+262424657561146C+262420435024178B+262420457797771A+262423278475770@+262422418056849?+262425216045565>+262427644724103=+262423997102406<+262429176135831;+262425581762099:+2624296912489109+2624212176226878+2624257154336427+2624258157895526+2624257572853395+2624222707249354+2624219587024363+2624285490072362+2624245460010491+2624243994081240+262423291221629/+262427994498833.+262424321501043-+262428995852712,+262421387110445++262427346903289*+262426888483872)+262420402068646(+262420919362031'+262429894847561&+262421192476075%+262424155243828$+262422041973067#+262422236063904"+262429014728085!+262426146195657 +262424025049738+262423937622483+262422684873806+262422702986037+262427277062695+262420293885524+262424757218224+262423242611315+262426799552030+262421755134812+262424903671955+262423751752769+262427415590879+262424680457047+262422015517447+262421663556391+262425879749351+262420019593384+262424236729390 +262422859852245 +262428441922382 +262427687008114 +262429440597476 +262429281383074+262420904010282+262425758950694+262420964802062+262426806588267+262423988818865+262426563534336+ 262427641413490 J 7 Ih H 9  Z k X 5  $ i l F   8   &   Y (W 6yG j%z J | } {  ' [  801J%491616428386I%491610450603H%491617182854G%491618747067F%491612435410E%491617305560D%491613147610C%491610548014B%491614200788A%491611423604@%491616603362?%491612861380>%491615537820=%491615150808<%491610582154;%491617866668:%4916142821049%4916102586468%4916107507627%4916110727006%4916172784315%4916141322784%4916174116083%4916132885742%4916112186171%4916144438000%491614342168/%491612205351.%491618877535-%491614801030,%491614754784+%491610146433*%491610351854)%491615786448(%491617078653'%491617373340&%491611645213%%491616216718$%491616538441#%491617468830"%491610700311!%491612170812 %491616267305%491618748260%491613641705%491617110788%491616622171%491616747724%491611231305%491612247776%491617127545%491612674152%491611172002%491614403446%491614726100%491618116861%491612162571%491618011481%491611272332%491610230080%491612203870 %491611611307 %491613176431 %491616442470 %491610300300 %491616731878%491614244577%491613206462%491617058021%491617661545%491618475310%491615146452% 491610387516   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   I  E Y  !  Uq  Q 1 } A -  M] ) a y   u5 9  =9 i%  m eaM +262427071462135J+262424847201092I+262425244462911H+262426325502438G+262424137995618F+262427887397396E+262422219831262D+262424657561146C+262420435024178B+262420457797771A+262423278475770@+262422418056849?+262425216045565>+262427644724103=+262423997102406<+262429176135831;+262425581762099:+2624296912489109+2624212176226878+2624257154336427+2624258157895526+2624257572853395+2624222707249354+2624219587024363+2624285490072362+2624245460010491+2624243994081240+262423291221629/+262427994498833.+262424321501043-+262428995852712,+262421387110445++262427346903289*+262426888483872)+262420402068646(+262420919362031'+262429894847561&+262421192476075%+262424155243828$+262422041973067#+262422236063904"+262429014728085!+262426146195657 +262424025049738+262423937622483+262422684873806+262422702986037+262427277062695+262420293885524+262424757218224+262423242611315+262426799552030+262421755134812+262424903671955+262423751752769+262427415590879+262424680457047+262422015517447+262421663556391+262425879749351+262420019593384+262424236729390 +262422859852245 +262428441922382 +262427687008114 +262429440597476 +262429281383074+262420904010282+262425758950694+262420964802062+262426806588267+262423988818865+262426563534336+ 262427641413490 8J+) 26242707146213580112345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624248472010924916164283863H+% 2624252444629114916104506033G+% 2624263255024384916171828543F+% 2624241379956184916187470673E+% 2624278873973964916124354103D+% 2624222198312624916173055603C+% 2624246575611464916131476103B+% 2624204350241784916105480143A+% 2624204577977714916142007883@+% 2624232784757704916114236043?+% 2624224180568494916166033623>+% 2624252160455654916128613803=+% 2624276447241034916155378203<+% 2624239971024064916151508083;+% 2624291761358314916105821543:+% 26242558176209949161786666839+% 26242969124891049161428210438+% 26242121762268749161025864637+% 26242571543364249161075076236+% 26242581578955249161107270035+% 26242575728533949161727843134+% 26242227072493549161413227833+% 26242195870243649161741160832+% 26242854900723649161328857431+% 26242454600104949161121861730+% 2624243994081244916144438003/+% 2624232912216294916143421683.+% 2624279944988334916122053513-+% 2624243215010434916188775353,+% 2624289958527124916148010303++% 2624213871104454916147547843*+% 2624273469032894916101464333)+% 2624268884838724916103518543(+% 2624204020686464916157864483'+% 2624209193620314916170786533&+% 2624298948475614916173733403%+% 2624211924760754916116452133$+% 2624241552438284916162167183#+% 2624220419730674916165384413"+% 2624222360639044916174688303!+% 2624290147280854916107003113 +% 2624261461956574916121708123+% 2624240250497384916162673053+% 2624239376224834916187482603+% 2624226848738064916136417053+% 2624227029860374916171107883+% 2624272770626954916166221713+% 2624202938855244916167477243+% 2624247572182244916112313053+% 2624232426113154916122477763+% 2624267995520304916171275453+% 2624217551348124916126741523+% 2624249036719554916111720023+% 2624237517527694916144034463+% 2624274155908794916147261003+% 2624246804570474916181168613+% 2624220155174474916121625713+% 2624216635563914916180114813+% 2624258797493514916112723323+% 2624200195933844916102300803 +% 2624242367293904916122038703 +% 2624228598522454916116113073 +% 2624284419223824916131764313 +% 2624276870081144916164424703 +% 2624294405974764916103003003+% 2624292813830744916167318783+% 2624209040102824916142445773+% 2624257589506944916132064623+% 2624209648020624916170580213+% 2624268065882674916176615453+% 2624239888188654916184753103+% 262426563534336491615146452[+%7 3262427641413490491610387516MSC-00-00-00-00-00-002024-06-23 12:02:56