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 9q  a m% i 1 E ! 9 Q = y a   M A  u 9 - U YI] u } ) M  e  5  +262421929621451J+262428350645405I+262423627131817H+262428040816655G+262426583923725F+262420472190632E+262429176087713D+262429827307821C+262427381408712B+262424497436101A+262428830011382@+262429938929209?+262428232141682>+262423360244473=+262423186293262<+262428698053553;+262423499074478:+2624278850619239+2624264307881978+2624217989666977+2624232947021516+2624281096674055+2624236208886294+2624240122269013+2624255853629402+2624262365458241+2624245876501040+262426854751711/+262421061070632.+262428183863532-+262424690668797,+262420637072684++262424653645949*+262429297676674)+262421798140486(+262421548996647'+262426047681757&+262428525556725%+262421277298495$+262421322354491#+262427434218415"+262420930964279!+262427335827621 +262428167595976+262426818450248+262422838993730+262423715278109+262428426258594+262423860128710+262423955449204+262421636922723+262429501252842+262427448394970+262427731470802+262420427721723+262429436767835+262420818908779+262425209293643+262429099292539+262420318685441+262422122413259+262420567995475 +262421629385190 +262420971522046 +262426100323095 +262424506305712 +262420867879791+262425632714839+262423248747032+262428693597422+262429911548807+262426930315070+262425158964520+ 262424637753184 J $y % { 5  k IF 7 l H Z z &  hG J ' Y } 8 6 [ jX | 9 (   i W 672J%491617361105I%491617134605H%491614816053G%491616382640F%491612322737E%491615478581D%491610308160C%491612264625B%491618701476A%491616863602@%491611566565?%491617355531>%491610148611=%491617483520<%491610811563;%491614877285:%4916155385749%4916115682078%4916126532757%4916112111036%4916170103855%4916158203474%4916167724853%4916180578212%4916135647231%4916125403240%491612754083/%491617023036.%491613224874-%491617637311,%491613133358+%491612228176*%491612375158)%491615126658(%491616434517'%491610224086&%491611134623%%491616551481$%491613400671#%491617548243"%491618652338!%491615026087 %491618077075%491615580778%491617804376%491610220235%491616338311%491614607320%491616462447%491618154228%491612820053%491615203301%491610725534%491612177205%491611765447%491612421021%491615845525%491610564546%491612443803%491610550046%491610055167 %491610473616 %491612145864 %491618878240 %491613764082 %491610126383%491614181328%491610806840%491618146733%491615005411%491618150081%491618532428% 491613072330   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 9q  a m% i 1 E ! 9 Q = y a   M A  u 9 - U YI] u } ) M  e  5  +262421929621451J+262428350645405I+262423627131817H+262428040816655G+262426583923725F+262420472190632E+262429176087713D+262429827307821C+262427381408712B+262424497436101A+262428830011382@+262429938929209?+262428232141682>+262423360244473=+262423186293262<+262428698053553;+262423499074478:+2624278850619239+2624264307881978+2624217989666977+2624232947021516+2624281096674055+2624236208886294+2624240122269013+2624255853629402+2624262365458241+2624245876501040+262426854751711/+262421061070632.+262428183863532-+262424690668797,+262420637072684++262424653645949*+262429297676674)+262421798140486(+262421548996647'+262426047681757&+262428525556725%+262421277298495$+262421322354491#+262427434218415"+262420930964279!+262427335827621 +262428167595976+262426818450248+262422838993730+262423715278109+262428426258594+262423860128710+262423955449204+262421636922723+262429501252842+262427448394970+262427731470802+262420427721723+262429436767835+262420818908779+262425209293643+262429099292539+262420318685441+262422122413259+262420567995475 +262421629385190 +262420971522046 +262426100323095 +262424506305712 +262420867879791+262425632714839+262423248747032+262428693597422+262429911548807+262426930315070+262425158964520+ 262424637753184 8J+) 26242192962145167212345678901234 In9e0 \ ' S   J  v A m 8 d/[&R~Iu@ l7c.Z%3I+% 2624283506454054916173611053H+% 2624236271318174916171346053G+% 2624280408166554916148160533F+% 2624265839237254916163826403E+% 2624204721906324916123227373D+% 2624291760877134916154785813C+% 2624298273078214916103081603B+% 2624273814087124916122646253A+% 2624244974361014916187014763@+% 2624288300113824916168636023?+% 2624299389292094916115665653>+% 2624282321416824916173555313=+% 2624233602444734916101486113<+% 2624231862932624916174835203;+% 2624286980535534916108115633:+% 26242349907447849161487728539+% 26242788506192349161553857438+% 26242643078819749161156820737+% 26242179896669749161265327536+% 26242329470215149161121110335+% 26242810966740549161701038534+% 26242362088862949161582034733+% 26242401222690149161677248532+% 26242558536294049161805782131+% 26242623654582449161356472330+% 2624245876501044916125403243/+% 2624268547517114916127540833.+% 2624210610706324916170230363-+% 2624281838635324916132248743,+% 2624246906687974916176373113++% 2624206370726844916131333583*+% 2624246536459494916122281763)+% 2624292976766744916123751583(+% 2624217981404864916151266583'+% 2624215489966474916164345173&+% 2624260476817574916102240863%+% 2624285255567254916111346233$+% 2624212772984954916165514813#+% 2624213223544914916134006713"+% 2624274342184154916175482433!+% 2624209309642794916186523383 +% 2624273358276214916150260873+% 2624281675959764916180770753+% 2624268184502484916155807783+% 2624228389937304916178043763+% 2624237152781094916102202353+% 2624284262585944916163383113+% 2624238601287104916146073203+% 2624239554492044916164624473+% 2624216369227234916181542283+% 2624295012528424916128200533+% 2624274483949704916152033013+% 2624277314708024916107255343+% 2624204277217234916121772053+% 2624294367678354916117654473+% 2624208189087794916124210213+% 2624252092936434916158455253+% 2624290992925394916105645463+% 2624203186854414916124438033+% 2624221224132594916105500463 +% 2624205679954754916100551673 +% 2624216293851904916104736163 +% 2624209715220464916121458643 +% 2624261003230954916188782403 +% 2624245063057124916137640823+% 2624208678797914916101263833+% 2624256327148394916141813283+% 2624232487470324916108068403+% 2624286935974224916181467333+% 2624299115488074916150054113+% 2624269303150704916181500813+% 262425158964520491618532428[+%7 3262424637753184491613072330MSC-00-00-00-00-00-002024-10-19 08:25:59