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 -5I m u ]%Mq Y U   i u e! 9 } E =   Q ) y 9 A   a a 1  M +262425356145118J+262429791858169I+262429227809889H+262424991537922G+262429165861101F+262428051583796E+262424160994059D+262426649893096C+262429585260988B+262425254386105A+262429611766465@+262428231553390?+262427430398310>+262426853936567=+262427229614932<+262425316557690;+262427504685538:+2624298856062209+2624274732929878+2624234389601757+2624250293367896+2624269971442345+2624233810830644+2624271481432563+2624271181938192+2624201702529971+2624281327073920+262423581584622/+262424726155437.+262425712816484-+262421005471280,+262426522675863++262427302357382*+262429966353461)+262425564791849(+262429007673095'+262429427213602&+262423644469113%+262429541434138$+262426588322611#+262422720931430"+262420653688500!+262428144540493 +262420741970572+262426678779982+262421841045087+262427598652370+262425370533351+262427545906636+262426439958241+262425348051971+262420378986803+262420561608246+262421987529537+262422568191785+262425858800603+262424706266695+262423615820937+262429050322876+262426182189311+262420230834656+262420126340114 +262424479184958 +262422337971660 +262427808638464 +262422486715440 +262429216994001+262420759138099+262420176950632+262427768179795+262427258690842+262424115289468+262427764047499+ 262420334965557 J  ji  } lh H | [ ZF$ '  9 G % 8 J k X { (6y Y  7  I zW & 5 141J%491614480086I%491613335605H%491613832283G%491611858552F%491610860617E%491610575353D%491610762611C%491616085703B%491613557614A%491618705011@%491612765448?%491616106627>%491616834847=%491613303007<%491615668321;%491612670424:%4916137242239%4916173418578%4916121646677%4916141086266%4916117104135%4916141227304%4916183524803%4916142703802%4916175700831%4916172518570%491612767512/%491616215642.%491610518013-%491613417414,%491618331548+%491616273231*%491611576670)%491615512875(%491610361083'%491614344353&%491617314727%%491613374701$%491613383461#%491610202701"%491615821171!%491617052821 %491614338488%491617127163%491610724188%491613608526%491614565161%491613474614%491614137147%491610485463%491617727506%491618160470%491612171276%491613710881%491618764403%491611535250%491615744871%491610581325%491616681114%491618447168%491612187331 %491618427405 %491612164816 %491618104876 %491611430504 %491615404042%491614640427%491610185838%491612031870%491614230164%491615780183%491618805312% 491616725816   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 -5I m u ]%Mq Y U   i u e! 9 } E =   Q ) y 9 A   a a 1  M +262425356145118J+262429791858169I+262429227809889H+262424991537922G+262429165861101F+262428051583796E+262424160994059D+262426649893096C+262429585260988B+262425254386105A+262429611766465@+262428231553390?+262427430398310>+262426853936567=+262427229614932<+262425316557690;+262427504685538:+2624298856062209+2624274732929878+2624234389601757+2624250293367896+2624269971442345+2624233810830644+2624271481432563+2624271181938192+2624201702529971+2624281327073920+262423581584622/+262424726155437.+262425712816484-+262421005471280,+262426522675863++262427302357382*+262429966353461)+262425564791849(+262429007673095'+262429427213602&+262423644469113%+262429541434138$+262426588322611#+262422720931430"+262420653688500!+262428144540493 +262420741970572+262426678779982+262421841045087+262427598652370+262425370533351+262427545906636+262426439958241+262425348051971+262420378986803+262420561608246+262421987529537+262422568191785+262425858800603+262424706266695+262423615820937+262429050322876+262426182189311+262420230834656+262420126340114 +262424479184958 +262422337971660 +262427808638464 +262422486715440 +262429216994001+262420759138099+262420176950632+262427768179795+262427258690842+262424115289468+262427764047499+ 262420334965557 8J+) 26242535614511814112345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624297918581694916144800863H+% 2624292278098894916133356053G+% 2624249915379224916138322833F+% 2624291658611014916118585523E+% 2624280515837964916108606173D+% 2624241609940594916105753533C+% 2624266498930964916107626113B+% 2624295852609884916160857033A+% 2624252543861054916135576143@+% 2624296117664654916187050113?+% 2624282315533904916127654483>+% 2624274303983104916161066273=+% 2624268539365674916168348473<+% 2624272296149324916133030073;+% 2624253165576904916156683213:+% 26242750468553849161267042439+% 26242988560622049161372422338+% 26242747329298749161734185737+% 26242343896017549161216466736+% 26242502933678949161410862635+% 26242699714423449161171041334+% 26242338108306449161412273033+% 26242714814325649161835248032+% 26242711819381949161427038031+% 26242017025299749161757008330+% 2624281327073924916172518573/+% 2624235815846224916127675123.+% 2624247261554374916162156423-+% 2624257128164844916105180133,+% 2624210054712804916134174143++% 2624265226758634916183315483*+% 2624273023573824916162732313)+% 2624299663534614916115766703(+% 2624255647918494916155128753'+% 2624290076730954916103610833&+% 2624294272136024916143443533%+% 2624236444691134916173147273$+% 2624295414341384916133747013#+% 2624265883226114916133834613"+% 2624227209314304916102027013!+% 2624206536885004916158211713 +% 2624281445404934916170528213+% 2624207419705724916143384883+% 2624266787799824916171271633+% 2624218410450874916107241883+% 2624275986523704916136085263+% 2624253705333514916145651613+% 2624275459066364916134746143+% 2624264399582414916141371473+% 2624253480519714916104854633+% 2624203789868034916177275063+% 2624205616082464916181604703+% 2624219875295374916121712763+% 2624225681917854916137108813+% 2624258588006034916187644033+% 2624247062666954916115352503+% 2624236158209374916157448713+% 2624290503228764916105813253+% 2624261821893114916166811143+% 2624202308346564916184471683 +% 2624201263401144916121873313 +% 2624244791849584916184274053 +% 2624223379716604916121648163 +% 2624278086384644916181048763 +% 2624224867154404916114305043+% 2624292169940014916154040423+% 2624207591380994916146404273+% 2624201769506324916101858383+% 2624277681797954916120318703+% 2624272586908424916142301643+% 2624241152894684916157801833+% 262427764047499491618805312[+%7 3262420334965557491616725816MSC-00-00-00-00-00-002024-06-21 05:56:14